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!
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
