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