[mapserver-users] TIme support on mapserver 5.6.3, it's working?

[rai 8]

hello,

I discovered a bit more about how the things works, but I'm little confusing
with this...


with this url
http://mapserver-tutorial/cgi-bin/mapserv?map=/home/vbox/Downloads/mapserver-tutorial/ms4w/apps/tutorial/htdocs/tile_time.map&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=time_w,sat_w&WIDTH=800&HEIGHT=400&FORMAT=image/png&TRANSPARENT=false&srs=EPSG:4326&BBOX=-126,24,-66,50&TIME=2007-05-11T10:00:00


looking to log I found two querys to database, the first from tile_w layer
has a correct result if you check in postgresql directly, also in mapserver
log says that got 1 record in the result. I changed
'find_srid('','satellite','the_geom'))' that appears in log by '4326'
because in postgresql seems that it doesn't work.

 select
    "image_time",
    encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64')
as geom,
    "oid"
    from satellite
    where
    the_geom &&
    GeomFromText('POLYGON((-2639868.99029283
-2322020.83542886,-2639868.99029283 1072412.78850334,3408818.1364184
1072412.78850334,3408818.1364184 -2322020.83542886,-2639868.99029283
-2322020.83542886))', 4326 ) and (date_trunc('second', image_time) =
'2007-05-11T10:00:00')

the other query from sat_w layer has no results, note that the polygon
parameter has the same points as the url
 select
    "image_time",
    encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64')
as geom,
    "oid" 2
    from satellite
    where
    the_geom &&
    GeomFromText('POLYGON((-126 24,-126 50,-66 50,-66 24,-126 24))',4326)
and (date_trunc('second', image_time) = '2007-05-11T10:00:00')




with this url log says that 1 result have been found in both querys, it's
the same but changing the points of the bounding box, but it doesn't show
any image, I think that the problem is in the coordinates or the projection
used, in mapfile or in url.. I'll try to change something :)


http://mapserver-tutorial/cgi-bin/mapserv?map=/home/vbox/Downloads/mapserver-tutorial/ms4w/apps/tutorial/htdocs/tile_time.map&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=time_w,sat_w&WIDTH=1000&HEIGHT=600&FORMAT=image/png&TRANSPARENT=false&srs=EPSG:4326&BBOX=-2639868.99029283,-2322020.83542886,3408818.1364184,1072412.78850334&TIME=2007-05-11T10:00:00

[Tue Jul  6 10:49:01 2010].865473 msPostGISLayerWhichShapes query: select
"image_time","image_path",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64')
as geom,"oid" from satellite where the_geom &&
GeomFromText('POLYGON((-2639868.99029283 -2322020.83542886,-2639868.99029283
1072412.78850334,3408818.1364184 1072412.78850334,3408818.1364184
-2322020.83542886,-2639868.99029283
-2322020.83542886))',find_srid('','satellite','the_geom')) and
(date_trunc('second', image_time) = '2007-05-11T10:00:00')
[Tue Jul  6 10:49:01 2010].929571 msPostGISLayerWhichShapes query status: 2
[Tue Jul  6 10:49:01 2010].929611 msPostGISLayerWhichShapes got 1 records in
result.
[Tue Jul  6 10:49:01 2010].929632 msPostGISLayerNextShape called.
[Tue Jul  6 10:49:01 2010].929651 msPostGISReadShape called.
[Tue Jul  6 10:49:01 2010].929675 msPostGISReadShape: [image_time]
"2007-05-11 10:00:00"
[Tue Jul  6 10:49:01 2010].929694 msPostGISReadShape: [image_path]
"/home/vbox/Downloads/animacio/sat1.tif"



thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100706/2b10639a/attachment.htm>