Bruno -- <br><br>You'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> <<a href="mailto:b.canessa@iol.it">b.canessa@iol.it</a>> 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 process the TIME<br>
parameter:<br><br>LAYER<br> NAME "Anomalie"<br> GROUP "Anomalie"<br> TYPE RASTER<br> STATUS ON<br> METADATA<br> "queryable" "true"<br> "tile_source" "nocache"
<br> "wms_title" "Anomalie"<br> "wms_timeextent" "2006-05-01/2006-10-31"<br> "wms_timeitem" "datetime"<br> "wms_timedefault" "2006-05-10"
<br> "wms_srs" "EPSG:4326"<br> END<br> TILEINDEX "epluie_a_idx.shp"<br> TILEITEM "Location"<br> CLASSITEM "[pixel]"<br> CLASS<br> (......)<br>
END<br> 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> NAME "anomalie_idx"
<br> STATUS ON<br> TYPE POLYGON<br> DATA "wkb_geometry from tileindex_table"<br> METADATA<br> "wms_title" "ANOMALIE INDEX"<br> "wms_srs" "EPSG:4326"
<br> "wms_timeextent" "2006-05-01/2006-10-31"<br> "wms_timeitem" "datetime" #column in postgis table of type date<br> "wms_timedefault" "2006-05-10"
<br> "tile_source" "nocache"<br> END<br> CONNECTION "dbname=test user=xxx host=localhost port=5432"<br> CONNECTIONTYPE postgis<br> END<br><br> LAYER<br> NAME "Anomalie"
<br> GROUP "Anomalie"<br> TYPE RASTER<br> STATUS ON<br> DEBUG ON<br> PROJECTION<br> "init=epsg:4326"<br> END<br> METADATA<br> "queryable" "true"<br> "tile_source" "nocache"
<br> "wms_title" "Anomalie"<br> "wms_timeextent" "2006-05-01/2006-10-31"<br> "wms_timeitem" "datetime"<br> "wms_timedefault" "2006-05-10"
<br> "wms_srs" "EPSG:4326"<br> END<br> TILEINDEX "anomalie_idx"<br> TILEITEM "Location"<br> CLASSITEM "[pixel]"<br> CLASS<br> (...)<br> END
<br> END<br><br>I tried to perform queries in PostgreSQL such as<br>SELECT * FROM tileindex_table WHERE date_trunc('day', datetime) =<br>'2006-10-10';<br>and it works fine.<br><br>I use mapserver 4.8.4, PostgreSQL
8.1.4 and 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> <mailto:<a href="mailto:b.canessa@ibimet.cnr.it">b.canessa@ibimet.cnr.it</a>><br><br><br><br><br></blockquote>
</div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner