[pmapper-users] Multiple search items in a layer ?
Hi all, I want to show multiple selection areas (hi-lighted) on the map like when search and found a polygon (I'm using MapInfo .TAB layer data). I found PM can show multiple hi-lighted items, ex: when I input id "1079", it found "10791" "10792" "10793" and hi-lighted them all; So I try to do my goal by modify PM Search function. I found that the search begin in pm.search.js with: setSearchInput() and the url is: var url = PM_XAJAX_LOCATION + 'x_search.php?' + SID +'&action=searchitem&searchitem=' + searchitem; Can I made some changes to input multiple items in ONE search (ex: itemA, itemB, itemC, ...) , or to search continued but still remain the previous hi-light (ex: search itemA --> show on map, then search itemB --> show on map both A & B, ... and go on) ?? Thanks, i-boy -- 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)
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)
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)
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)
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
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