Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

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

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

Hi, I mean pmapper will use the DATA definition when it needs to draw object and PM_RESULT_DATASUBSTITION definition when it needs to search object (attributes queries) or show attributes values (results in the table, iquery, ...). So it will draw only one object of your main table witch

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

I don't want to bother you more, but... I have set my mapfile with PM_RESULT_DATASUBSTITION, but if I query/search I obtain only one result. I don't see PM_RESULT_DATASUBSTITION in the query code (search.php, query.php and squery.php), so it seems it's rever used during the query phase... Ok,

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

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

Re: [pmapper-users] search distinct features on one-to-many join query (for time series)

I don't know if it is documented. I'm sure we have discuss about it with Armin, but that's it... G. Allegri a écrit : Thanks Thomas. I will take a look to this PM_RESULT_DATASUBSTITION. Is it documented? I didn't see it anywhere... except into map.php, now that you indicated it :) giovanni

[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

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

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 |