[mapserver-users] Problem with WMS time (filter do not works)

[Seth G]

Hi,

Is there any difference if you use a native filter? E.g. 

PROCESSING 'NATIVE_FILTER=day= '2018-01-01T00:00:00''

Seth

--
web:http://geographika.co.uk
twitter: @geographika


On Fri, Aug 24, 2018, at 2:14 PM, Roberto Marzocchi wrote:
> Dear all, 
> 
> i have done more test 
> 
> if I uncomment the "wms_timedefault" "2018-01-01T00:00:00" line it
> give me the following error:> 
> *msWMSApplyTime: WMS server error. No Time value was given, and no
> default time value defined.*> 
> otherwise it give me no error but my WMS use always the last line of
> the postgis table not considering the FILTER.> 
> I try a lot of fiter syntaxes.
> 
> 
> my raster layer definition is the following: 
> 
> # raster layer
>     LAYER
>      NAME "bui_20180101"
>      TYPE RASTER
>      STATUS ON
>      DEBUG ON
>      PROJECTION
>        "init=epsg:3003"
>      END
>      METADATA
>        "wms_title" "bui_20180101"
>        "wms_srs"   "EPSG:3003"
>        "wms_extent" "1436301.37500 4916704.50000 1701801.37500
>        5177704.50000">        "wms_timeextent" "2017-08-01/2100-12-31/PT24H"
>        "wms_timeitem" "day" #datetime is a column in postgis table of
>        type timestamp>        #"wms_timedefault" "2018-01-01T00:00:00"
>        "wms_enable_request" "*"
>        "ows_include_items"     "all"
>      END
>      OFFSITE 0 0 0
>      TILEITEM "location" #filepath is a column in postgis table with
>      varchar of the filepath to each image>      TILEINDEX "time_idx"
>      #FILTERITEM "day"
>      #FILTER "2018-01-01T00:00:00"
>      #FILTER (`[day]` = `2018-01-01T00:00:00`)
>      #FILTER ('[day]' = '2018-01-01T00:00:00')
>      FILTER ("day" = '2018-01-01T00:00:00')
>     END
> 
> 
> Thanks in advanced for your help. 
> 
> R
> 
> Eng. Roberto Marzocchi, PhD GIS Project Coordinator Gter srl (Unige
> spin-off) Piazza De Marini 3/61 - 16123 Genova
> P.IVA/CF 01998770992 ph: 010-8694830 - mob: 349-8786575 E-mail:
>   roberto.marzocchi at gter.it skype: roberto.marzocchi84 www.gter.it  --
>   Gter social www.twitter.com/Gteronline - www.facebook.com/Gteronline
>   - https://plus.google.com/+GterIt/posts www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-
>   gis  -----------------------------------------------------------------
>   Please consider the environment before printing this email!> 
> 
> 
> ---- On mar, 21 ago 2018 13:26:23 +0200 *Roberto Marzocchi
> <roberto.marzocchi at gter.it>* wrote ----> 
>> Dear all, 
>> 
>> I am following the guide to create WMS/WCS time [1]. (Mapserver 7.0.7
>> on Ubuntu Xenìal server)>> 
>> I created a PostGIS view with the following field:
>> - id
>> - location
>> - day
>> - geom
>> 
>> I create a mapfile but when I create the layer the filter do not
>> works (I see always the last row e.g the map of yesterday).>> 
>> I try: 
>>      FILTERITEM "day"
>>      FILTER "20180101"
>> 
>> and 
>> 
>> FILTER (`[day]` = `20180101`)
>> 
>> like in the example
>>      
>> 
>> I try to change the day format in the PostGIS table from text to
>> timestamp (e.g20180101 -->  2018-01-01 00:00:00) but nothing change.>> 
>> 
>> There is something not clear to me. 
>> 
>> R
>> 
>> [1] -
>>     https://mapserver.org/ogc/wms_time.html#example-of-wms-t-with-postgis-tile-index-for-raster-imagery>> 
>> 
>> 
>> 
>> Eng. Roberto Marzocchi, PhD GIS Project Coordinator Gter srl (Unige
>> spin-off) Piazza De Marini 3/61 - 16123 Genova
>> P.IVA/CF 01998770992 ph: 010-8694830 - mob: 349-8786575 E-mail:
>>   roberto.marzocchi at gter.it skype: roberto.marzocchi84 www.gter.it
>>   -- Gter social www.twitter.com/Gteronline -
>>   www.facebook.com/Gteronline - https://plus.google.com/+GterIt/posts
>>   www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-
>>   gis  -----------------------------------------------------------------
>>   Please consider the environment before printing this email!>> 
>> 
> 
> 
> _________________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180824/04a0f384/attachment.htm>