[pmapper-users] patch to correct wrong numerical fieldType in export shapefile
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)
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 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 i
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
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 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 >> __
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
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-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 pm