hello,<br><br>I discovered a bit more about how the things works, but I'm little confusing with this...<br><br><br>with this url <br><a href="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">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</a><br>
<br> <br>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.<br>
<br> select <br> "image_time",<br> encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64') as geom,<br> "oid" <br> from satellite <br> where <br>
the_geom && <br> 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')<br>
<br>the other query from sat_w layer has no results, note that the polygon parameter has the same points as the url<br> select <br> "image_time",<br> encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64') as geom,<br>
"oid" 2<br> from satellite <br> where <br> the_geom && <br> GeomFromText('POLYGON((-126 24,-126 50,-66 50,-66 24,-126 24))',4326) and (date_trunc('second', image_time) = '2007-05-11T10:00:00')<br>
<br><br><br><br>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 :)<br>
<br><br><a href="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">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</a><br>
<br>[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')<br>
[Tue Jul 6 10:49:01 2010].929571 msPostGISLayerWhichShapes query status: 2<br>[Tue Jul 6 10:49:01 2010].929611 msPostGISLayerWhichShapes got 1 records in result.<br>[Tue Jul 6 10:49:01 2010].929632 msPostGISLayerNextShape called.<br>
[Tue Jul 6 10:49:01 2010].929651 msPostGISReadShape called.<br>[Tue Jul 6 10:49:01 2010].929675 msPostGISReadShape: [image_time] "2007-05-11 10:00:00"<br>[Tue Jul 6 10:49:01 2010].929694 msPostGISReadShape: [image_path] "/home/vbox/Downloads/animacio/sat1.tif"<br>
<br><br><br>thanks!<br><br>