Bruno -- <br><br>You&#39;ll need to upgrade to MapServer 4.10 for PostGIS + WMST.<br><br><a href="http://mapserver.gis.umn.edu/docs/howto/wms_time_support/#example-of-wms-t-with-postgis-tile-index-for-raster-imagery">http://mapserver.gis.umn.edu/docs/howto/wms_time_support/#example-of-wms-t-with-postgis-tile-index-for-raster-imagery
</a><br><br>David<br><br><div><span class="gmail_quote">On 1/18/07, <b class="gmail_sendername">Bruno Canessa</b> &lt;<a href="mailto:b.canessa@iol.it">b.canessa@iol.it</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi all,<br><br>I have a problem with WMS with TIME support and Postgis.<br>Inilially I created a map file where layers access direct to files, and<br>it works fine. I mean, the web service is able to&nbsp;&nbsp;process the TIME<br>
parameter:<br><br>LAYER<br>&nbsp;&nbsp;&nbsp;&nbsp;NAME &quot;Anomalie&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;GROUP &quot;Anomalie&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;TYPE RASTER<br>&nbsp;&nbsp;&nbsp;&nbsp;STATUS ON<br>&nbsp;&nbsp;&nbsp;&nbsp;METADATA<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;queryable&quot; &quot;true&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;tile_source&quot; &quot;nocache&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_title&quot; &quot;Anomalie&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timeextent&quot; &quot;2006-05-01/2006-10-31&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timeitem&quot; &quot;datetime&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timedefault&quot; &quot;2006-05-10&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_srs&quot; &quot;EPSG:4326&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;END<br>&nbsp;&nbsp;&nbsp;&nbsp;TILEINDEX &quot;epluie_a_idx.shp&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;TILEITEM &quot;Location&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;CLASSITEM &quot;[pixel]&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CLASS<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(......)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END<br>&nbsp;&nbsp;END<br><br>On the contrary, if I try to access through Postgis it seems that the<br>TIME parameter is not recognised, it always shows the last image of the<br>index list.<br><br> LAYER<br>&nbsp;&nbsp;&nbsp;&nbsp;NAME &quot;anomalie_idx&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;STATUS ON<br>&nbsp;&nbsp;&nbsp;&nbsp;TYPE POLYGON<br>&nbsp;&nbsp;&nbsp;&nbsp;DATA &quot;wkb_geometry from tileindex_table&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;METADATA<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_title&quot; &quot;ANOMALIE INDEX&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_srs&quot;&nbsp;&nbsp; &quot;EPSG:4326&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timeextent&quot; &quot;2006-05-01/2006-10-31&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timeitem&quot; &quot;datetime&quot;&nbsp;&nbsp;#column in postgis table of type date<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timedefault&quot; &quot;2006-05-10&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;tile_source&quot; &quot;nocache&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;END<br>&nbsp;&nbsp;&nbsp;&nbsp;CONNECTION &quot;dbname=test user=xxx host=localhost port=5432&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;CONNECTIONTYPE postgis<br>&nbsp;&nbsp;END<br><br>&nbsp;&nbsp;LAYER<br>&nbsp;&nbsp;&nbsp;&nbsp;NAME &quot;Anomalie&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;GROUP &quot;Anomalie&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;TYPE RASTER<br>&nbsp;&nbsp;&nbsp;&nbsp;STATUS ON<br>&nbsp;&nbsp;&nbsp;&nbsp;DEBUG ON<br>&nbsp;&nbsp;&nbsp;&nbsp;PROJECTION<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;init=epsg:4326&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;END<br>&nbsp;&nbsp;&nbsp;&nbsp;METADATA<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;queryable&quot; &quot;true&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;tile_source&quot; &quot;nocache&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_title&quot; &quot;Anomalie&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timeextent&quot; &quot;2006-05-01/2006-10-31&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timeitem&quot; &quot;datetime&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_timedefault&quot; &quot;2006-05-10&quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;wms_srs&quot; &quot;EPSG:4326&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;END<br>&nbsp;&nbsp;&nbsp;&nbsp;TILEINDEX &quot;anomalie_idx&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;TILEITEM &quot;Location&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;CLASSITEM &quot;[pixel]&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CLASS<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(...)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END
<br>&nbsp;&nbsp;END<br><br>I tried to perform queries in PostgreSQL such as<br>SELECT * FROM tileindex_table WHERE date_trunc(&#39;day&#39;, datetime) =<br>&#39;2006-10-10&#39;;<br>and it works fine.<br><br>I use mapserver 4.8.4, PostgreSQL 
8.1.4 and&nbsp;&nbsp;PostGIS 1.1.3<br><br>Any suggestion?<br><br>Thanks,<br><br>Bruno.<br>--------<br>Dott. Bruno Canessa<br>National Research Council - Institute of Biometeorology (CNR-IBIMET)<br>Via G.Caproni, 8<br>50145 Firenze (Italy)
<br>Tel. +39 055 3033719<br>Fax +39 055 308910<br>E-mail: <a href="mailto:b.canessa@iol.it">b.canessa@iol.it</a> &lt;mailto:<a href="mailto:b.canessa@ibimet.cnr.it">b.canessa@ibimet.cnr.it</a>&gt;<br><br><br><br><br></blockquote>
</div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner