Ok. The problem for timedefault is due to the timestamp format that I wrongly 
deduced from qgis which read the timestamp with the T which is not present in 
the PostGIS table Nevertheless the filter do not works:  I try:       FILTER 
(`[day]` = `2018-01-01 00:00:00`) (reading the manual of mapserver 7.2.0 even 
if I use mapserver 7.0.7)  FILTER ("[day]" = '2018-01-01 00:00:00') FILTER 
('[day]' = '2018-01-01 00:00:00') PROCESSING "NATIVE_FILTER= 'day'='2018-01-01 
00:00:00'" FILTERITEM 'day'     FILTER '2018-01-01 00:00:00' No parsing error, 
but the filter is ignored My update version of layer definition; # 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/PT5M"        "wms_timeitem" "day" 
#datetime is a column in postgis table of type timestamp        
"wms_timedefault" "2018-08-17 00: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-01 00:00:00'      #FILTER (`[day]` = `2018-01-01 00:00:00`)      
#FILTER ("day" = '2018-01-01 00:00:00')      #FILTER ("[day]" = '2018-01-01 
00:00:00')      #PROCESSING "NATIVE_FILTER= 'day'='2018-01-01 00:00:00'"     
END ---- On ven, 24 ago 2018 15:23:59 +0200 Roberto Marzocchi 
<[email protected]> wrote ---- No I use a mapfile where I have defined 
the time index layer and the raster layer. 
http://demo.gter.it/cgi-bin/mapserv?map=/home/rasdaman/bui_mapfile_test.map&; An 
example of my request is  
http://demo.gter.it/cgi-bin/mapserv?map=/home/rasdaman/bui_mapfile_test.map&LAYERS=bui_20180101&TRANSPARENT=TRUE&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&SRS=EPSG%3A3003&BBOX=1436300.0000000000000000,4916700.0000000000000000,1701800.0000000000000000,5177700.0000000000000000&WIDTH=1088&HEIGHT=621
 R ---- On ven, 24 ago 2018 15:04:57 +0200 Seth G <[email protected]> 
wrote ---- _______________________________________________ mapserver-users 
mailing list [email protected] 
https://lists.osgeo.org/mailman/listinfo/mapserver-users How are you accessing 
the service? Do you have an example URL? Are you setting the TIME parameter as 
part of this? 
https://mapserver.org/ogc/wcs_server.html#test-with-a-getcoverage-request 
http://my.host.com/cgi-bin/mapserv?map=mywcs.map&SERVICE=WCS   
&VERSION=1.0.0&REQUEST=GetCoverage&coverage=bathymetry   
&CRS=EPSG:42304&TIME=2018-01-01T00:00:00&WIDTH=3199   &HEIGHT=2833&FORMAT=GTiff 
-- web:http://geographika.co.uk twitter: @geographika On Fri, Aug 24, 2018, at 
2:56 PM, Roberto Marzocchi wrote: Thanks for your answer.. I try your 
suggestion  using " instead of ' (otherwise I have a parsing error) but 
unfortunately no difference (the filter is "ignored"      PROCESSING 
"NATIVE_FILTER= 'day'='2018-01-01T00:00:00'" 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: [email protected]
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 ven, 24 ago 
2018 14:37:00 +0200 Seth G <[email protected]> wrote ---- 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: [email protected]
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 <[email protected]> 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: [email protected]
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 
[email protected] 
https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to