I might not understand it completely. Your layers are always using the same Postgis table, just setting another FILTER. Is that correct? I would guess that the queryByPoint() call does not consider the FILTER specifications. I thought that this is only the case for attribute queries (therefore attribute queries on Postgis tables use standard PHP functions, not Mapscript), but maybe also for point queries.
The whole filter part was messed up in Mapserver 4.8/4.10 and they said it has been fixed in 5.0. But in general this kind of issue would be best asked on the Mapserver mailing list. When loading you application it reminds me that I wanted to add again the possibility to specify the legend icon image for a class in the map file. Otherwise one has to download hundreds of icon images that are always the same. Armin Kyle Wilcox wrote: > Did the usual searching without finding anything relevant. > > The pmapper application I am referencing is at: > http://155.206.18.162/mapping/map/map.phtml > > I have time series data in a PostGIS enabled database (current and wind > fields from model output). I can display the point data without > problems (try any of the current or wind layers). > > The problem is that when querying a point layer, the data that is always > extracted from the first timestamp, rather than the timestamp associated > with the layer I am trying to query. I understand what is happening.. > the query by point functionality is querying the database at the > specific POINT and displaying the first row that returns (the first > timestamp). If I delete the first timestep data, the second timestep > data is displayed and so on. I have different tables for the model grid > and the data and would like to keep it this way if possible. > > > Here is my layer definition: > > LAYER > TYPE POINT > CONNECTIONTYPE postgis > NAME 'eta-One' > CONNECTION 'host=HOST user=USER dbname=DATABASE' > DATA "the_geom from (SELECT * from forecast left join > grid on grid.gid=forecast.grid_id) as data USING UNIQUE gid USING SRID=4326" > FILTER "time=TIMESTAMP'2007-11-06 00:00:00'" > METADATA > 'DESCRIPTION' '2007-11-06 00:00:00' > 'RESULT_FIELDS' > 'wind_speed,wind_from_direction,rotation' > 'RESULT_HEADERS' 'Wind Speed (m/s), Wind > Direction (from TN), Rotation of Image (from TN)' > 'LAYER_ENCODING' 'UTF-8' > END > STATUS OFF > PROJECTION > 'init=epsg:4326' > END > TOLERANCE 10 > TOLERANCEUNITS pixels > LABELMAXSCALE 60000 > TEMPLATE void > CLASS > NAME ">= 0.95 m/s" > EXPRESSION ([wind_speed] >= 0.95) > STYLE > SYMBOL "arrow2" > ANGLE [wind_from_direction] > COLOR 118 0 0 > OUTLINECOLOR 0 0 0 > SIZE 10 > END > TEXT ([wind_speed] m/s - [wind_from_direction] TN) > LABEL > COLOR 118 0 0 > OUTLINECOLOR 0 0 0 > POSITION AUTO > SIZE small > PARTIALS TRUE > END > END > ... > END > > > How can I change query.php to select only the data that has to do with > the current timestep, rather than selecting all of the timesteps at that > POINT and using the first row as the result? > > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
