> 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