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?
--
Kyle Wilcox
NOAA Chesapeake Bay Office
410 Severn Avenue
Suite 107A
Annapolis, MD 21403
office: (410) 295-3151
[EMAIL PROTECTED]
"It is from the wellspring of our despair and the places
that we are broken that we come to repair the world."
- Murray Waas
-------------------------------------------------------------------------
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
