It works!!!!!!!!!!!!!!!! yeahhhhhhhhhhhh<br><br>I changed the EXTENT in the beginnig "EXTENT 199949.651166 -371954.772084 1472121.6862 632767.19157" by "EXTENT -180 -90 180 90" and also in the url and now it works<br>
<br><br> <br>MAP
<br> IMAGETYPE PNG24<br> EXTENT -180 -90 180 90
<br> SIZE 400 300
<br> CONFIG "MS_ERRORFILE" "/var/log/mapserver/mapserver.log"<br> <br> PROJECTION
<br> "init=epsg:4326"
<br> END # End of the output Projection definition ---<br><br> LAYER<br> NAME "time_w"<br> TYPE POLYGON<br> STATUS ON<br> DEBUG 3<br> CONNECTIONTYPE POSTGIS<br> CONNECTION "dbname=tile_index host=127.0.0.1 user=postgres password=xxxxxx"<br>
DATA "the_geom from satellite using unique oid using srid = 4326" <br> METADATA<br> "wms_title" "time_index_w"<br> "wms_srs" "EPSG:4326"<br> "wms_timeextent" "2007-01-01/2007-12-31"<br>
# "wms_timeextent" "2007-05-11T10:00:00Z,2007-05-11T11:00:00Z"<br> "wms_timedefault" "2007-05-11T10:00:00Z" <br> "wms_timeitem" "image_time" #a column in postgis table of type <br>
END<br> END<br><br> LAYER<br> NAME "sat_w"<br> STATUS ON<br> DEBUG 3<br> TYPE RASTER<br> METADATA<br> "wms_title" "Satellite"<br> "wms_timeextent" "2007-01-01/2007-12-31"<br>
# "wms_extent" "-126 24 -66 50"<br> "wms_extent" "-180 -90 180 90"<br> END<br> PROJECTION<br> "init=epsg:4326"<br> END<br> TILEINDEX "time_w" # Layer name containing time index<br>
TILEITEM "image_path" # DB column containing path to image <br> END<br><br>END<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=800&HEIGHT=400&FORMAT=image/png&TRANSPARENT=false&srs=EPSG:4326&BBOX=-180,-90,180,90&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=-180,-90,180,90&TIME=2007-05-11T10:00:00</a><br>
<br><br>thanks.<br><br><div class="gmail_quote">2010/7/6 rai 8 <span dir="ltr"><<a href="mailto:max1000@gmail.com">max1000@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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><div class="im"><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" target="_blank">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></div>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.<div class="im">
<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></div> 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<div class="im"><br> select <br> "image_time",<br> encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64') as geom,<br>
</div>
"oid" 2<div class="im"><br> from satellite <br> where <br> the_geom && <br></div> 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" target="_blank">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>
</blockquote></div><br>