[mapserver-users] Mapserver WMS time support with Oracle
D. Nappo
domenico.nappo at gmail.com
Mon Jan 20 05:44:29 PST 2014
Hi there,
I couldn't figure out how to solve this. I have a layer so configured:
LAYER
NAME "layer"
TYPE point
CONNECTION "conn_string...."
CONNECTIONTYPE ORACLESPATIAL
TEMPLATE "templates/hotspot_template.html"
DATA "SHAPE FROM (SELECT POINT as SHAPE, ACQ_DATE, ACQ_TIME,
SATELLITE, CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM
gwsprd.HOT_SPOTS_MODIS) using unique OGR_FID"
METADATA
"wms_title" "WMS test"
"wms_srs" "EPSG:4326"
"wms_extent" "-180 -90 180 90"
"wms_timeextent" "2000-01-01/2020-12-31"
"wms_timeitem" "acq_date"
"wms_timedefault" "2014-01-01"
"wms_timeformat" "YYYY-MM-DD"
"wms_enable_request" "*"
END
CLASS
SYMBOL 'circle'
SIZE 2
COLOR 255 0 0
END
END
Now, the date column in the oracle table is the acq_date field.
The problem is that Mapserver translates that with a wrong oracle query
(which it works in postgreslq, I guess):
SELECT OGR_FID,rownum, SHAPE FROM
(SELECT OGR_FID, POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE,
CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS)
WHERE acq_date = '2014-01-16'
The query above uses a wrong filter and it gives the error:
ORA-01861: literal does not match format string
How can I tell to Mapserver to use a correct query??? Or do I missing
anyhting???
Something like:
WHERE acq_date = to_date('2014-01-16','YYYY-MM-DD')
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140120/98fe89b3/attachment.htm>
More information about the MapServer-users
mailing list