[pmapper-users] p.mapper 5, first beta

[G. Allegri]

Thanks Armin,
I will give it a try ASAP.

giovanni
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] roadmap and acl

[G. Allegri]

>
>
>>> well, there are frameworks like GeoExt that might already have offered
>> this type of functionality. Did you ever try them?
>
>
> As you know, GeoExt is more a client viewer, decouled by the server side.
> What I like in Pmapper is the integrated environment, where with few
> configurations you obtain a full-featured system (client+server).
> Having an admin API would allow the configuration to be made through a web
> based UI, or even a desktop app. This would simplify/streamline the process
> of setting up and deploying maps and services for the end-user.
>

PS: and I love jQuery lot more then ExtJS! :)

About the OL integration, it could also permit to the use of external
services, like ArcGIS Server, Geoserver, etc. on top of the MS based
services. A lot of chances more to be welcomed in various application
contexts.

giovanni
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] roadmap and acl

[G. Allegri]

Thanks Armin for these notes. I reply inline:


>> well, there are frameworks like GeoExt that might already have offered
> this type of functionality. Did you ever try them?


As you know, GeoExt is more a client viewer, decouled by the server side.
What I like in Pmapper is the integrated environment, where with few
configurations you obtain a full-featured system (client+server).
Having an admin API would allow the configuration to be made through a web
based UI, or even a desktop app. This would simplify/streamline the process
of setting up and deploying maps and services for the end-user.


>
>
>  Armin, do you have any plans about it? Will you put it out when things are
>> done, or will you share the code while working on it?
>>
>
> So far quite some parts are still a bit under construction with frequent
> and possibly still deeper changes. It was not always easy to understand the
> sometimes strange logic of OL, and the OL mailing list was of no help for
> very specific questions (I practically never got any reply). So I was
> sometimes close to abandon the idea of using OL. Now I found most ways for
> workarounds, and the map navigation and interaction tools are mainly
> working.
>
> I'm currently in the final stage of rewriting the old and badly structured
> query code of p.mapper, this might be even possible to port it back to the
> p.mapper 4 (the new one will be version 5). The query stuff is again a bit
> of a mess, this time from the side of MapServer. But the new query classes
> should allow more easily to write you own functionality for the query
> result display if needed since this is now decoupled from actually getting
> the query result.
>
> A missing part is also the printing where I will mainly have to
> investigate how to print tiled layers that are not available via Mapserver
> (like OSM layers, Google layers will anyway not be allowed to be included
> in printings).
>
> Just to give an idea how the composition of layers from mapserver and OL
> works: You can define as now to have all MS layers (or groups) being
> rendered on a single map image, with or without tiling. Or you can split
> groups of layers into a few blocks, each block is an OL layer (I call the
> OL layers 'olThemes' to avoid too much of naming confusion). The
> combination which layers are rendered together or separately can be done in
> any type of combination. Using tiled layers for the time being will require
> to use the Google spherical mercator projection for the map. I cerated 2
> new types of new OL layers, one tiled and the other non-tiled. Both are
> based on MapScript and will only work inside a user PHP session.
>
> It will be very likely that the first release version of p.mapper 5 will
> have some very specific functionalities not yet included, and most likely
> also only a few plugins will work already then.
>
> When the code is a bit more stable I will put it on the SVN, depending
> also if anyone is interested in contributing some developments. I might put
> a preliminary beta version out in the next week or so, so that people can
> have a look at it on their own installation.
>
>
Great work. I'm not able to comment your points in this moment, I need to
have a look to the code, but it sounds great!
I hope to have a ride on it soon ;)


> A first draft version (already 2 weeks old) is available at
> http://www.pmapper.net/demo/**pmapper-5-dev/
> http://www.pmapper.net/demo/**pmapper-5-dev/?config=**singletile


OSM within Pmapper! That's what I was longing for ;)

giovanni
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] roadmap and acl

[G. Allegri]

Hi,
the idea to use Openlayers could give a new boost to Pmapper, which I find
one of the best "technical oriented" WebGIS out there.
This could give a chance to develop more on it. It's a long time I'm
thinking to an admin API, for an example, but was discouraged to invest on
it by the lack of some foundamental features for nowday's WebGIS platforms,
with OL being the biggest.

Armin, do you have any plans about it? Will you put it out when things are
done, or will you share the code while working on it?

Thanks for you precious work,
Giovanni
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] resutlayer rendering very very slow....

[G. Allegri]

The problem wasn't the indexes (they're already there) but the use of
the following:

DATA the_geom from (select * from my_table where year='mean') as foo
using unique gid

where my_table contains millions of rows and the 'mean' filtered rows
are the actual features I want (a couple of thousands). While this
doesn't hurt the speed of the internal layer rendering (I mean on the
map image creation), performances drop drastically when data are
accessed thorugh layer->getShape / layer->getFeature. That's why I was
confused.

A note: since Mapserver 5.0 layer->getShape is deprecated in favour of
layer-getFeature [1]

have a good day!
giovanni

[1] http://mapserver.org/mapscript/php/index.html#layerobj-class

2009/12/30 Armin Burger :
> On 29/12/2009 18:57, G. Allegri wrote:
>>
>> I'm using a polygonal postgis layer, composed of simple rectangular
>> cells (a grid). I'm quite worried by the performances in rendering
>> search results in map.php->pmap_addResultLayer(). I've profiled a
>> search query which returns 380 grids/polygons, and I've found it takes
>> 17.5-18 seconds to do the foreach loop at lines 797-816 of map.php. Is
>> it normal??? I hope there is a bottleneck I've missed...
>>
>
> check this and see if it speeds up things:
>
> http://postgis.refractions.net/documentation/manual-1.4/ch05.html#id2542540
>
> armin
>

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[pmapper-users] resutlayer rendering very very slow....

[G. Allegri]

I'm using a polygonal postgis layer, composed of simple rectangular
cells (a grid). I'm quite worried by the performances in rendering
search results in map.php->pmap_addResultLayer(). I've profiled a
search query which returns 380 grids/polygons, and I've found it takes
17.5-18 seconds to do the foreach loop at lines 797-816 of map.php. Is
it normal??? I hope there is a bottleneck I've missed...

bye,
giovanni

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] a simple plugin to set searchitems info window not visible

[G. Allegri]

Ops, don't consider this download, it refers to a previous release. I
will share the new one next days.

Giovanni

2009/12/23, G. Allegri :
> Just to share another piece of code...
> A litlle plugin to configure certain searchitems to not show search
> results info window.
>
> Hideinfowin - test release
> http://www.geospatial.it/allegri/hideinfowin-0.1.zip
>
> bye,
> giovanni
>

-- 
Inviato dal mio dispositivo mobile

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[pmapper-users] a simple plugin to set searchitems info window not visible

[G. Allegri]

Just to share another piece of code...
A litlle plugin to configure certain searchitems to not show search
results info window.

Hideinfowin - test release
http://www.geospatial.it/allegri/hideinfowin-0.1.zip

bye,
giovanni

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] attribute table

[G. Allegri]

I've just created a simple (really not optimized but working!) plugin
to set certain searchitems search info window not visible.
Here it is: http://www.geospatial.it/allegri/hideinfowin-0.1.zip

bye,
giovanni

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[pmapper-users] paginator plugin alpha release for testing

[G. Allegri]

Hello list.
Before leaving for Christmas I wanted to share a "paginator" plugin.
It's still a test release, and I would appreciate if someone could try
it.

You can download it here: http://www.geospatial.it/allegri/paginator-0.1.zip

A happy Christmas to everyone,
giovanni

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[pmapper-users] patch to correct wrong numerical fieldType in export shapefile

[G. Allegri]

I attach a one-row patch to correct a little bug in error.shp.php
There was a typo and a wrong definition of field header lengths.

giovanni


export.xls.php_patch
Description: Binary data
--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev ___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

[G. Allegri]

I don't want to bother you more, but...

I have set my mapfile with PM_RESULT_DATASUBSTITION, but if I
query/search I obtain only one result. I don't see
PM_RESULT_DATASUBSTITION in the query code (search.php, query.php and
squery.php), so it seems it's rever used during the query phase...

Ok, probably I miss something foundamental of the pmapper logic. I
apologize for asking so much...

bye,
giovanni

2009/12/18 Thomas Raffin :
> Hi,
>
> I mean pmapper will use the "DATA" definition when it needs to draw object
> and "PM_RESULT_DATASUBSTITION" definition when it needs to search object
> (attributes queries) or show attributes values (results in the table,
> iquery, ...).
>
> So it will draw only one object of your main table witch contains geometry,
> but when you will click on 1 object you will get many results (with the same
> geometry but different attributes due to the join made in the view).
>
> G. Allegri a écrit :
>
> Hi Thomas. it' not clear how DATASUBSTITUTION works. AFAICS it's only
> used inside pmap_addResultLayer to retrieve the shapes, so after the
> query/select have run. So what you mean with "This way pmapper will
> use the DATASUBSTITION  when you will search / query objects"?
>
> thanks again,
> giovanni
>
> 2009/12/17 Thomas Raffin :
>
>
> Hi,
>
> You should try to define a view that will join the tables (for instance
> "SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid =
> rainfall_ts.gid").
>
> So you will have 2 ways to use your data in your mapfile :
> - DATA "the_geom FROM grid USING UNIQUE gid" --> only 1 object without the
> rainfall attribute
> - DATA "the_geom FROM your_view USING UNIQUE gid" --> many objects at the
> same place with different rainfall values, and surely longer to execute
>
> What you should do in your mapfile is :
> LAYER
>     METADATA
>        .
>        PM_RESULT_DATASUBSTITION "the_geom FROM your_view USING UNIQUE gid"
>     END
>     DATA "the_geom FROM grid USING UNIQUE gid"
>     
> END
>
> This way pmapper will use the DATASUBSTITION  when you will search / query
> objects and use DATA when it will draw images.
>
>
>
> G. Allegri a écrit :
>
> Thanks Armin for the quick reply.
> The problem is not with the join, my doubt is about how to use it :)
>
> I have the following structure:
>
> GRID
> 
> |  gid |the_geom   |
> 
> |   1   | MULTYPOLYGON..|
> |   2   | MULTYPOLYGON. |
> |   3   | MULTYPOLYGON..|
> |    | .  |
>
>
> RAINFALL_TS
> 
> |  gid |  rainfall   |
> 
> |   1   |   5  |
> |   1   |   10.4 |
> |   1   |   1.3   |
> |    | . |
>
> >From the docs it's not clear to me how to query RAINFALL_TS to
> retrieve tha unique "gid" values to select/highlight the cells from
> GRID...
>
> I've read:
> http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables
> http://svn.pmapper.net/trac/wiki/DocManualsearch
>
> both seem to refer on the reverse need: retrieve attributes from
> joined tables, while I need to retrieve the unique gids from them.
>
> Am I missing something?
> I'm sorry if I'm asking stupid questions...
> giovanni
>
>
>
>
> 2009/12/16 Armin Burger :
>
>
> On 16/12/2009 20:04, G. Allegri wrote:
>
>
> Hello list.
> Before spending too much time on this, I would like to know if the
> trunk beta supports this thing:
>
> I have a big postgis table with a time series (TS) associated with a
> polygonal grid layer. For each polygon/cell I have multiple rows in
> the TS table. Let's say I have the list od daily rainfall.
> I need to let the user query the TS table to see if there is ANY cell
> where the daily rainfall have exceeded a certain threshold.
> (The truth is that I have many TS tables, coming from different
> simulations, and one single vector layer...)
>
> So, the user should be able to do a Search for Rainfall values higher
> then X, and receive all the cells where it happens.
>
> The actual code seems to offer many ways to deal with multiple joins,
> but nothing seems to respond to my need. Am I wrong? Is this already
> available or should I code it?
>
>
> There is no special support for joins in Postgis layers in p.mapper, just
> use the f

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

[G. Allegri]

Hi Thomas. it' not clear how DATASUBSTITUTION works. AFAICS it's only
used inside pmap_addResultLayer to retrieve the shapes, so after the
query/select have run. So what you mean with "This way pmapper will
use the DATASUBSTITION  when you will search / query objects"?

thanks again,
giovanni

2009/12/17 Thomas Raffin :
> Hi,
>
> You should try to define a view that will join the tables (for instance
> "SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid =
> rainfall_ts.gid").
>
> So you will have 2 ways to use your data in your mapfile :
> - DATA "the_geom FROM grid USING UNIQUE gid" --> only 1 object without the
> rainfall attribute
> - DATA "the_geom FROM your_view USING UNIQUE gid" --> many objects at the
> same place with different rainfall values, and surely longer to execute
>
> What you should do in your mapfile is :
> LAYER
>     METADATA
>        .
>        PM_RESULT_DATASUBSTITION "the_geom FROM your_view USING UNIQUE gid"
>     END
>     DATA "the_geom FROM grid USING UNIQUE gid"
>     
> END
>
> This way pmapper will use the DATASUBSTITION  when you will search / query
> objects and use DATA when it will draw images.
>
>
>
> G. Allegri a écrit :
>
> Thanks Armin for the quick reply.
> The problem is not with the join, my doubt is about how to use it :)
>
> I have the following structure:
>
> GRID
> 
> |  gid |the_geom   |
> 
> |   1   | MULTYPOLYGON..|
> |   2   | MULTYPOLYGON. |
> |   3   | MULTYPOLYGON..|
> |    | .  |
>
>
> RAINFALL_TS
> 
> |  gid |  rainfall   |
> 
> |   1   |   5  |
> |   1   |   10.4 |
> |   1   |   1.3   |
> |    | . |
>
> >From the docs it's not clear to me how to query RAINFALL_TS to
> retrieve tha unique "gid" values to select/highlight the cells from
> GRID...
>
> I've read:
> http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables
> http://svn.pmapper.net/trac/wiki/DocManualsearch
>
> both seem to refer on the reverse need: retrieve attributes from
> joined tables, while I need to retrieve the unique gids from them.
>
> Am I missing something?
> I'm sorry if I'm asking stupid questions...
> giovanni
>
>
>
>
> 2009/12/16 Armin Burger :
>
>
> On 16/12/2009 20:04, G. Allegri wrote:
>
>
> Hello list.
> Before spending too much time on this, I would like to know if the
> trunk beta supports this thing:
>
> I have a big postgis table with a time series (TS) associated with a
> polygonal grid layer. For each polygon/cell I have multiple rows in
> the TS table. Let's say I have the list od daily rainfall.
> I need to let the user query the TS table to see if there is ANY cell
> where the daily rainfall have exceeded a certain threshold.
> (The truth is that I have many TS tables, coming from different
> simulations, and one single vector layer...)
>
> So, the user should be able to do a Search for Rainfall values higher
> then X, and receive all the cells where it happens.
>
> The actual code seems to offer many ways to deal with multiple joins,
> but nothing seems to respond to my need. Am I wrong? Is this already
> available or should I code it?
>
>
> There is no special support for joins in Postgis layers in p.mapper, just
> use the functionality of the database for all sorts of joins and be aware of
> the special settings for this in the DATA parameter map file. I usually use
> DB views that do all the join definitions instead of defining the join in
> the map file. If the search does exactly what you want I cannot say, but you
> can define the full SQL statement in the search definition. Just check the
> docs and samples.
>
> armin
>
>
>
>
>
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> ___
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-us

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

[G. Allegri]

Thanks Thomas. I will take a look to this "PM_RESULT_DATASUBSTITION".
Is it documented? I didn't see it anywhere... except into map.php, now
that you indicated it :)

giovanni

2009/12/17 Thomas Raffin :
> Hi,
>
> You should try to define a view that will join the tables (for instance
> "SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid =
> rainfall_ts.gid").
>
> So you will have 2 ways to use your data in your mapfile :
> - DATA "the_geom FROM grid USING UNIQUE gid" --> only 1 object without the
> rainfall attribute
> - DATA "the_geom FROM your_view USING UNIQUE gid" --> many objects at the
> same place with different rainfall values, and surely longer to execute
>
> What you should do in your mapfile is :
> LAYER
>     METADATA
>        .
>        PM_RESULT_DATASUBSTITION "the_geom FROM your_view USING UNIQUE gid"
>     END
>     DATA "the_geom FROM grid USING UNIQUE gid"
>     
> END
>
> This way pmapper will use the DATASUBSTITION  when you will search / query
> objects and use DATA when it will draw images.
>
>
>
> G. Allegri a écrit :
>
> Thanks Armin for the quick reply.
> The problem is not with the join, my doubt is about how to use it :)
>
> I have the following structure:
>
> GRID
> 
> |  gid |the_geom   |
> 
> |   1   | MULTYPOLYGON..|
> |   2   | MULTYPOLYGON. |
> |   3   | MULTYPOLYGON..|
> |    | .  |
>
>
> RAINFALL_TS
> 
> |  gid |  rainfall   |
> 
> |   1   |   5  |
> |   1   |   10.4 |
> |   1   |   1.3   |
> |    | . |
>
> >From the docs it's not clear to me how to query RAINFALL_TS to
> retrieve tha unique "gid" values to select/highlight the cells from
> GRID...
>
> I've read:
> http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables
> http://svn.pmapper.net/trac/wiki/DocManualsearch
>
> both seem to refer on the reverse need: retrieve attributes from
> joined tables, while I need to retrieve the unique gids from them.
>
> Am I missing something?
> I'm sorry if I'm asking stupid questions...
> giovanni
>
>
>
>
> 2009/12/16 Armin Burger :
>
>
> On 16/12/2009 20:04, G. Allegri wrote:
>
>
> Hello list.
> Before spending too much time on this, I would like to know if the
> trunk beta supports this thing:
>
> I have a big postgis table with a time series (TS) associated with a
> polygonal grid layer. For each polygon/cell I have multiple rows in
> the TS table. Let's say I have the list od daily rainfall.
> I need to let the user query the TS table to see if there is ANY cell
> where the daily rainfall have exceeded a certain threshold.
> (The truth is that I have many TS tables, coming from different
> simulations, and one single vector layer...)
>
> So, the user should be able to do a Search for Rainfall values higher
> then X, and receive all the cells where it happens.
>
> The actual code seems to offer many ways to deal with multiple joins,
> but nothing seems to respond to my need. Am I wrong? Is this already
> available or should I code it?
>
>
> There is no special support for joins in Postgis layers in p.mapper, just
> use the functionality of the database for all sorts of joins and be aware of
> the special settings for this in the DATA parameter map file. I usually use
> DB views that do all the join definitions instead of defining the join in
> the map file. If the search does exactly what you want I cannot say, but you
> can define the full SQL statement in the search definition. Just check the
> docs and samples.
>
> armin
>
>
>
>
>
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> ___
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>
>
>
>
>

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

[G. Allegri]

Ok, I've read again the docs and the squery,php code. Now it's clear
how things work, and I see that the actual code doesn't permit what
I'm looking for...
I will try to code it and I will share if somthing useful comes out.

giovanni

2009/12/16 G. Allegri :
> Thanks Armin for the quick reply.
> The problem is not with the join, my doubt is about how to use it :)
>
> I have the following structure:
>
> GRID
> 
> |  gid     |    the_geom           |
> 
> |   1       | MULTYPOLYGON..|
> |   2       | MULTYPOLYGON. |
> |   3       | MULTYPOLYGON..|
> |        | .                          |
>
>
> RAINFALL_TS
> 
> |  gid     |          rainfall           |
> 
> |   1       |   5                          |
> |   1       |   10.4                     |
> |   1       |   1.3                       |
> |        | .                         |
>
> From the docs it's not clear to me how to query RAINFALL_TS to
> retrieve tha unique "gid" values to select/highlight the cells from
> GRID...
>
> I've read:
> http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables
> http://svn.pmapper.net/trac/wiki/DocManualsearch
>
> both seem to refer on the reverse need: retrieve attributes from
> joined tables, while I need to retrieve the unique gids from them.
>
> Am I missing something?
> I'm sorry if I'm asking stupid questions...
> giovanni
>
>
>
>
> 2009/12/16 Armin Burger :
>> On 16/12/2009 20:04, G. Allegri wrote:
>>>
>>> Hello list.
>>> Before spending too much time on this, I would like to know if the
>>> trunk beta supports this thing:
>>>
>>> I have a big postgis table with a time series (TS) associated with a
>>> polygonal grid layer. For each polygon/cell I have multiple rows in
>>> the TS table. Let's say I have the list od daily rainfall.
>>> I need to let the user query the TS table to see if there is ANY cell
>>> where the daily rainfall have exceeded a certain threshold.
>>> (The truth is that I have many TS tables, coming from different
>>> simulations, and one single vector layer...)
>>>
>>> So, the user should be able to do a Search for Rainfall values higher
>>> then X, and receive all the cells where it happens.
>>>
>>> The actual code seems to offer many ways to deal with multiple joins,
>>> but nothing seems to respond to my need. Am I wrong? Is this already
>>> available or should I code it?
>>
>>
>> There is no special support for joins in Postgis layers in p.mapper, just
>> use the functionality of the database for all sorts of joins and be aware of
>> the special settings for this in the DATA parameter map file. I usually use
>> DB views that do all the join definitions instead of defining the join in
>> the map file. If the search does exactly what you want I cannot say, but you
>> can define the full SQL statement in the search definition. Just check the
>> docs and samples.
>>
>> armin
>>
>>
>>
>

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

[G. Allegri]

Thanks Armin for the quick reply.
The problem is not with the join, my doubt is about how to use it :)

I have the following structure:

GRID

|  gid |the_geom   |

|   1   | MULTYPOLYGON..|
|   2   | MULTYPOLYGON. |
|   3   | MULTYPOLYGON..|
|    | .  |


RAINFALL_TS

|  gid |  rainfall   |

|   1   |   5  |
|   1   |   10.4 |
|   1   |   1.3   |
|    | . |

>From the docs it's not clear to me how to query RAINFALL_TS to
retrieve tha unique "gid" values to select/highlight the cells from
GRID...

I've read:
http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables
http://svn.pmapper.net/trac/wiki/DocManualsearch

both seem to refer on the reverse need: retrieve attributes from
joined tables, while I need to retrieve the unique gids from them.

Am I missing something?
I'm sorry if I'm asking stupid questions...
giovanni




2009/12/16 Armin Burger :
> On 16/12/2009 20:04, G. Allegri wrote:
>>
>> Hello list.
>> Before spending too much time on this, I would like to know if the
>> trunk beta supports this thing:
>>
>> I have a big postgis table with a time series (TS) associated with a
>> polygonal grid layer. For each polygon/cell I have multiple rows in
>> the TS table. Let's say I have the list od daily rainfall.
>> I need to let the user query the TS table to see if there is ANY cell
>> where the daily rainfall have exceeded a certain threshold.
>> (The truth is that I have many TS tables, coming from different
>> simulations, and one single vector layer...)
>>
>> So, the user should be able to do a Search for Rainfall values higher
>> then X, and receive all the cells where it happens.
>>
>> The actual code seems to offer many ways to deal with multiple joins,
>> but nothing seems to respond to my need. Am I wrong? Is this already
>> available or should I code it?
>
>
> There is no special support for joins in Postgis layers in p.mapper, just
> use the functionality of the database for all sorts of joins and be aware of
> the special settings for this in the DATA parameter map file. I usually use
> DB views that do all the join definitions instead of defining the join in
> the map file. If the search does exactly what you want I cannot say, but you
> can define the full SQL statement in the search definition. Just check the
> docs and samples.
>
> armin
>
>
>

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[pmapper-users] search distinct features on one-to-many join query (for time series)

[G. Allegri]

Hello list.
Before spending too much time on this, I would like to know if the
trunk beta supports this thing:

I have a big postgis table with a time series (TS) associated with a
polygonal grid layer. For each polygon/cell I have multiple rows in
the TS table. Let's say I have the list od daily rainfall.
I need to let the user query the TS table to see if there is ANY cell
where the daily rainfall have exceeded a certain threshold.
(The truth is that I have many TS tables, coming from different
simulations, and one single vector layer...)

So, the user should be able to do a Search for Rainfall values higher
then X, and receive all the cells where it happens.

The actual code seems to offer many ways to deal with multiple joins,
but nothing seems to respond to my need. Am I wrong? Is this already
available or should I code it?

Thanks a lot,
giovanni

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[pmapper-users] firefox skype plugin conflicts with scalebar

[G. Allegri]

After a hour of debugging I've finally solved a problem with the
scalebar plugin on pmapper 4.
The skype plugin for firefox conflicts inside the scalebar.js
styleValue function.
I write it for anyone that could face this problem... I hope nobody
will loose so much time for this!

bye,
giovanni

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users