I try to fix time_extends with layer and the behaivor are the same, also I logged the postgresql & mapserver:<br><br>with this query show always the first image , at the 11:00:00, in the log of postgresql the query has not time parameter<br>
<br><a href="http://mapserver-tutorial/cgi-bin/mapserv?map=/home/vbox/Downloads/mapserver-tutorial/ms4w/apps/tutorial/htdocs/tile_time.map&LAYERS=sat_w,time_w&mode=map&TIME=2007-05-11T11:00:00">http://mapserver-tutorial/cgi-bin/mapserv?map=/home/vbox/Downloads/mapserver-tutorial/ms4w/apps/tutorial/htdocs/tile_time.map&LAYERS=sat_w,time_w&mode=map&TIME=2007-05-11T11:00:00</a><br>
<br>postgresql<br>2010-07-05 16:14:26 CEST LOG: statement: select attname from pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid = pg_class.oid and pg_class.oid = pg_attribute.attrelid and pg_constraint.contype = 'p' and pg_constraint.conkey[1] = pg_attribute.attnum and pg_class.relname = 'tile_index' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null<br>
2010-07-05 16:14:26 CEST LOG: statement: select encode(AsBinary(force_collection(force_2d("tile_geom")),'NDR'),'base64') as geom,"oid" from tile_index where tile_geom && GeomFromText('POLYGON((165660.980559345 -371954.772084,165660.980559345 632767.19157,1506410.35680666 632767.19157,1506410.35680666 -371954.772084,165660.980559345 -371954.772084))',find_srid('','tile_index','tile_geom'))<br>
2010-07-05 16:14:27 CEST LOG: statement: select attname from pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid = pg_class.oid and pg_class.oid = pg_attribute.attrelid and pg_constraint.contype = 'p' and pg_constraint.conkey[1] = pg_attribute.attnum and pg_class.relname = 'tile_index' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null<br>
2010-07-05 16:14:27 CEST LOG: statement: select "tile_filepath",encode(AsBinary(force_collection(force_2d("tile_geom")),'NDR'),'base64') as geom,"oid" from tile_index where tile_geom && GeomFromText('POLYGON((-98.0072083861835 40.1776647603121,-98.0072083861835 50.6708031292285,-79.1036733841116 50.6708031292285,-79.1036733841116 40.1776647603121,-98.0072083861835 40.1776647603121))',find_srid('','tile_index','tile_geom'))<br>
<br><br><br>with this url selects first image but show the second, in this case the query take into account time parameter<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=-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>postgresql<br>2010-07-05 16:05:29 CEST LOG: statement: select attname from pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid = pg_class.oid and pg_class.oid = pg_attribute.attrelid and pg_constraint.contype = 'p' and pg_constraint.conkey[1] = pg_attribute.attnum and pg_class.relname = 'tile_index' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null<br>
2010-07-05 16:05:30 CEST LOG: statement: select "tile_timestamp","tile_filepath",encode(AsBinary(force_collection(force_2d("tile_geom")),'NDR'),'base64') as geom,"oid" from tile_index where tile_geom && GeomFromText('POLYGON((-126 24,-126 50,-66 50,-66 24,-126 24))',find_srid('','tile_index','tile_geom')) and (date_trunc('second', tile_timestamp) = '2004-01-01T10:10:00Z') and (date_trunc('second', tile_timestamp) = '2004-01-01T10:10:00Z')<br>
2010-07-05 16:05:30 CEST LOG: statement: 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))',find_srid('','satellite','the_geom')) and (date_trunc('second', image_time) = '2007-05-11T10:00:00')<br>
2010-07-05 16:05:30 CEST LOG: statement: 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((-126 24,-126 50,-66 50,-66 24,-126 24))',find_srid('','satellite','the_geom')) and (date_trunc('second', image_time) = '2007-05-11T10:00:00')<br>
<br>mapserver<br>[Mon Jul 5 16:44:46 2010].254344 msPostGISLayerWhichShapes query: select "image_time",encode(AsBinary(force_colle<br>ction(force_2d("the_geom")),'NDR'),'base64') as geom,"oid" from satellite where the_geom && GeomFromText('POLYGON(<br>
(-2639868.99029283 -2322020.83542886,-2639868.99029283 1072412.78850334,3408818.1364184 1072412.78850334,3408818.1<br>364184 -2322020.83542886,-2639868.99029283 -2322020.83542886))',find_srid('','satellite','the_geom')) and (date_tr<br>
unc('second', image_time) = '2007-05-11T11:00:00')<br>[Mon Jul 5 16:44:46 2010].352763 msPostGISLayerWhichShapes query status: 2<br>[Mon Jul 5 16:44:46 2010].352796 msPostGISLayerWhichShapes got 1 records in result.<br>
[Mon Jul 5 16:44:46 2010].352817 msPostGISLayerNextShape called.<br>[Mon Jul 5 16:44:46 2010].352835 msPostGISReadShape called.<br>[Mon Jul 5 16:44:46 2010].352858 msPostGISReadShape: [image_time] "2007-05-11 11:00:00"<br>
<br><br>the same above but with "&mode=map" will have the same behavior than the first url, show always the first image<br><br>when you put seconds in the url postgresql recives a query with date_trunc('second', image_time) , If put only minute date_trunc('minute', image_time), it seems that mapserver detect what kind of time parameter is.<br>
<br><br>It's so tricky this mapserver :/ , thanks daryl & alexander<br><br><br><div class="gmail_quote">2010/7/3 Alexander Petkov <span dir="ltr"><<a href="mailto:greenkov@gmail.com">greenkov@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;">I suggest that you carefully inspect your definitions in your mapfile,<br>
as well as the data in the Postgis DB itself.<br>
Turn debugging on, and inspect the log file closely.<br>
Also, if you already haven't, enable PostgreSQL logging, inspect<br>
incoming requests to your database as well.<br>
<br>
For example, one inconsistency that is evident from your map file is<br>
the date format--the "wms_timeextent" item for the "sat_w" layer<br>
contains a date range, while your Postgis data also has a timestamp<br>
data type with HH24:MI data. I would eliminate those inconsistensies<br>
first.<br>
<br>
List each time step individually (comma separated) in your mapfile ,<br>
since your number of records for the time being is small, rather than<br>
specifying a date range.<br>
<br>
Again, do not be shy about inspecting the log files. Randomly trying<br>
"a lot of combinations", as well as different Mapserver versions<br>
hoping that something will work will likely not help.<br>
<br>
Alex<br>
<div><div></div><div class="h5"><br>
On Fri, Jul 2, 2010 at 6:20 AM, rai 8 <<a href="mailto:max1000@gmail.com">max1000@gmail.com</a>> wrote:<br>
>> Could you provide an example URL you are using to test out the WMS-T? I<br>
>> am using WMS-T on 5.6.3 without any known issues. Please note that if your<br>
>> time table gets very large, you may hit this quirk:<br>
><br>
> I am using URL like:<br>
> <a href="http://mapserver-tutorial/cgi-bin/mapserv?map=/home/vbox/map_directory/tile_time_2.map&layer=radar&layer=time_idx_pg&mode=map&TIME=2004-01-01T10:10:00" target="_blank">http://mapserver-tutorial/cgi-bin/mapserv?map=/home/vbox/map_directory/tile_time_2.map&layer=radar&layer=time_idx_pg&mode=map&TIME=2004-01-01T10:10:00</a><br>
><br>
> It shows an image but always the first -><br>
> /home/vbox/Downloads/animacio/sat1.tif , that have the timestamp: 2007-05-11<br>
> 10:00Z<br>
><br>
> My table its very little, I was wrong about the version, is the 5.4.2, i'll<br>
> try to do the same with the 5.6 but it's very strange that any configuration<br>
> that I tried doesn't work.<br>
><br>
>> need to be in the METADATA section of the "sat_w" layer.<br>
><br>
> I tried a lot of combinations, also with all the metadata in sat_w like<br>
> "official" tutorial<br>
><br>
><br>
> thanks a lot!<br>
><br>
><br>
><br>
><br>
> 2010/7/1 Alexander Petkov <<a href="mailto:greenkov@gmail.com">greenkov@gmail.com</a>><br>
>><br>
>> On Thu, Jul 1, 2010 at 6:27 AM, rai 8 <<a href="mailto:max1000@gmail.com">max1000@gmail.com</a>> wrote:<br>
>> > Hello,<br>
>> ><br>
>> > I've been working with mapserver to get a map with time support, time<br>
>> > parameter, I followed the tutorial in documetation<br>
>> > <a href="http://mapserver.org/ogc/wms_time.html" target="_blank">http://mapserver.org/ogc/wms_time.html</a> and this post<br>
>> ><br>
>> > <a href="http://osgeo-org.1803224.n2.nabble.com/Accessing-images-using-time-dimension-td1991324.html#a1991324" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Accessing-images-using-time-dimension-td1991324.html#a1991324</a><br>
>> > and I can't run the mapserver to change the image with a time parameter.<br>
>> ><br>
>> > I test several configurations but any works, the last is the same like<br>
>> > the<br>
>> > post in the maillist, this is what i've done:<br>
>> ><br>
>> > in a postgis database<br>
>> ><br>
>> > create table satellite (image_path text, image_time timestamp);<br>
>> > select AddGeometryColumn('satellite', 'the_geom', 4326, 'POLYGON', 2);<br>
>> ><br>
>> > insert into satellite (image_path, image_time, the_geom)<br>
>> > values ('/home/vbox/Downloads/animacio/sat1.tif', '2007-05-11 10:00Z',<br>
>> > GeomFromText('POLYGON((-31.82 75.55, -31.82 26.5, 51.31 26.5,51.31<br>
>> > 75.55,<br>
>> > -31.82 75.55))', 4326));<br>
>> ><br>
>> > insert into satellite (image_path, image_time, the_geom)<br>
>> > values ('/home/vbox/Downloads/animacio/sat2.tif', '2007-05-11 11:00Z',<br>
>> > GeomFromText('POLYGON((-31.82 75.55, -31.82 26.5, 51.31 26.5,51.31<br>
>> > 75.55,<br>
>> > -31.82 75.55))', 4326));<br>
>> ><br>
>> ><br>
>> > and the map file:<br>
>> ><br>
>> > LAYER<br>
>> > NAME "time_w"<br>
>> > TYPE POLYGON<br>
>> > STATUS ON<br>
>> > CONNECTIONTYPE POSTGIS<br>
>> > CONNECTION "dbname=tile_index host=127.0.0.1 user=postgres<br>
>> > 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_timedefault" "2007-05-11T11:00:00Z"<br>
>> > "wms_timeitem" "image_time" #a column in postgis table of<br>
>> > type<br>
>> > END<br>
>> > END<br>
>> ><br>
>> > LAYER<br>
>> > NAME "sat_w"<br>
>> > STATUS ON<br>
>> > TYPE RASTER<br>
>> > METADATA<br>
>> > "wms_title" "Satellite"<br>
>> > "wms_timeextent" "2007-01-01/2007-12-31"<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>
>> ><br>
>> > anyone finds some error?<br>
>> ><br>
>> ><br>
>> > thanks<br>
>><br>
>> The time-related metadata items:<br>
>><br>
>> "wms_timeextent" "2007-01-01/2007-12-31"<br>
>> "wms_timedefault" "2007-05-11T11:00:00Z"<br>
>> "wms_timeitem" "image_time" #a column in postgis table of type<br>
>><br>
>><br>
>> need to be in the METADATA section of the "sat_w" layer.<br>
>><br>
>> Alex<br>
><br>
><br>
</div></div></blockquote></div><br>