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 <traf...@sirap.fr>: > 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 <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 > > > > > > ------------------------------------------------------------------------------ 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
