> Hi there, > > There is no explicit support of a TIME parameter in wfs but I believe > It should be possible on a postgis layer to use the FilterEncoding to > limit the request: would something like this work for you: > > Filter=<Filter><And><PropertyIsGreaterThan><PropertyName>your_time_field</PropertyName><Literal>2007-01-02</Literal></PropertyIsGreaterThan><PropertyIsLessThan><PropertyName>your_time_field</PropertyName><Literal>2007-01-03</Literal></PropertyIsLessThan></And></Filter> > > > regards,
Thanks very much for the suggestion. It does not work that easy (of course ;-) ) but you can filter using the following converting the date to UNIX epochs first and compare the integers. Unfortunatly the WFS part of MS 5.6.1 does not handle the type 'date' <YYYY-MM-DD> for comparison or calculus. This works: http://localhost/cgi-bin/mapserv.patched/?map=/var/www/localhost/mapserver/wfs6_include.map&SERVICE=WFS&VERSION=1.0.0&REQUEST=getfeature&TYPENAME=BRO_V32_TIMED&FILTER=<Filter><And><PropertyIsGreaterThan><PropertyName>date_part('epoch',datum::timestamp without time zone)</PropertyName><Literal>1191359000</Literal></PropertyIsGreaterThan><PropertyIsLessThan><PropertyName>date_part('epoch',datum::timestamp without time zone)</PropertyName><Literal>1191359640</Literal></PropertyIsLessThan></And></Filter> Still quite ugly to mee. Is there a deeper reason for not having a time spec within WFS ? To me you usually have data points in space _and_ time. But i'am not a GEO man either (daily satellite based measurements we have). Thanks and Regards Heiko The LAYER definition is as follows. Funny enough one needs not to specify the FILTER at all ... ok, one learns something new every day: LAYER EXTENT -180 -90 180 90 CONNECTIONTYPE POSTGIS NAME "BRO_V32_TIMED" PROCESSING "CLOSE_CONNECTION=DEFER" OPACITY 60 STATUS ON DUMP TRUE METADATA "wfs_title" "bro_v32_timed" "wfs_maxfeatures" "10" "gml_featureid" "ID" ## REQUIRED "gml_include_items" "all" ## Optional (serves all attributes for layer) "gml_geometries" "rechteck" "gml_rechteck_type" "polygon" END PROJECTION "init=epsg:4326" END CONNECTION "user={BF961C25A57BA226} password={C9748CA35D48D049} dbname={6B40E65B12B92106} host=localhost" DATA "rechteck from bro_v32_timed using srid=-1 using unique datum" TYPE POLYGON SIZEUNITS meters CLASS NAME "bro_v32_timed_total_class" STYLE OUTLINECOLOR 0 0 0 COLOR [farbe] END END END # Layer _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
