A couple of weeks ago I experimented with the WMS time support in Mapserver,
and got a simple example going on one machine.
Now I am trying to implement time support on a different machine (using the
mapserv from the fgs distribution), but I am getting a strange error I don't
fully understand:
------------------------------------
msDrawMap(): Image handling error. Failed to draw layer named 'sat_time_idx'.
prepare_database(): Query error. Error executing POSTGIS DECLARE (the actual
query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
image_time::text,asbinary(force_collection(force_2d(geometry)),'NDR'),image_path::text
from satellite WHERE (image_time = 'date_trunc('minute', image_time) =
'2007-06-12T11:00:00'') and (geometry && setSRID( 'BOX3D(-20012461.4573608
-44133305.4068053,20012461.4573608
44133305.4068064)'::BOX3D,find_srid('','satellite','geometry') ))'
Postgresql reports the error as 'ERROR: syntax error at or near "minute" at
character 178
------------------------------------
I can see what the syntax error is, but I've no idea why it's happening! Can
anyone help?
The URL I'm using, if it helps, is:
http://pb-vmap2:8080/cgi-bin/mapserv?map=map/satellite.map&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=satellite&SRS=EPSG:4326&BBOX=-180,-90,180,90&WIDTH=800&HEIGHT=400&FORMAT=image/png&TRANSPARENT=false&TIME=2007-06-12T11:00
My map file is as follows:
MAP
NAME "Satellite"
STATUS ON
EXTENT -20037508.34 -20037508.34 20037508.34 20037508.34
SIZE 800 400
SHAPEPATH "/home/map/shapes"
IMAGECOLOR 100 100 200
TRANSPARENT ON
WEB
IMAGEPATH "/home/map/fgs/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
METADATA
"wms_title" "Satellite"
"wms_onlineresource"
"http://pb-vmap2:8080/cgi-bin/mapserv.exe?map=satellite.map";
"wms_srs" "EPSG:4326 EPSG:54004"
END
END
PROJECTION
"init=epsg:54004"
END
OUTPUTFORMAT
NAME PNG24
DRIVER "GD/PNG"
MIMETYPE "image/png"
EXTENSION PNG
IMAGEMODE RGBA
END
LAYER
NAME "sat_time_idx"
TYPE POLYGON
STATUS DEFAULT
CONNECTIONTYPE POSTGIS
CONNECTION "dbname=map" # host=localhost"
DATA "geometry from satellite using unique image_path using
srid
= 4326"
METADATA
"wms_title" "sat_time_idx"
"wms_srs" "EPSG:4326 EPSG:54004"
"wms_timeitem" "image_time" #a column in postgis table of type
timestamp
"wms_timeextent" "2007-01-01/2099-12-31"
"wms_timedefault" "2007-06-12T08:00:00Z"
END
END
LAYER
NAME satellite
TYPE RASTER
STATUS ON
METADATA
"wms_title" "satellite"
"wms_srs" "EPSG:4326 EPSG:54004"
END
TRANSPARENCY 60
TILEINDEX "sat_time_idx"
TILEITEM "image_path"
PROJECTION
"init=epsg:4326"
END
END
END
Many Thanks,
Dave.
