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 <armin.bur...@gmail.com>: > 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
