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
