topic Re: How to construct a WFS-URL that both filters on an attribute and uses a boudingbox filter in ArcGIS JavaScript Maps SDK Questions

How to construct a WFS-URL that both filters on an attribute and uses a boudingbox filter

basboers1 — Fri, 06 Feb 2015 22:00:35 GMT

Dear community,

In an attempt not to request too many features from a WFS i'd like to apply both a attribute filter and a bounding box/envelope. Although these two types of filters seem to be "mutually exclusive" according to the OGC specification, I was wondering if they could somehow be combined within a single filter through for example the use of the AND-operator. Anyone any advise? I am working on the following WFS: http://geodata.nationaalgeoregister.nl/bag/wfs?request=getcapabilities

What I've tried, but doesn't work out is:

1:Via the url

http://geodata.nationaalgeoregister.nl/bag/wfs?&typename=bag:pand&version=2.0.0&request=getfeature&Filter=<ogc:Filter xmlns="http://www.opengis.net/wfs/2.0 xmlns:gml=http://schemas.opengis.net/gml xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xmlns:bag=http://bag.geonovum.nl xsi:schemaLocation=http://www.opengis.net/wfs/2.0 "><And><ogc:BBOX><ogc:PropertyName>Shape</ogc:PropertyName><gml:Box srsName="urn:x-ogc:def:crs:EPSG:28992"><gml:coordinates>508576,107240 510167,109000</gml:coordinates></gml:Box></ogc:BBOX><Within><PropertyIsEqualTo><PropertyName>status</PropertyName><Literal>Bouwvergunning verleend</Literal></PropertyIsEqualTo></Within></And></ogc:Filter>

2:via use of the xml-filter expression

<ogc:Filter>

<ogc:And>

<ogc:PropertyIsEqualTo>

<ogc:PropertyName>status</ogc:PropertyName>

<ogc:Literal>Bouwvergunning verleend</ogc:Literal>

</ogc:PropertyIsEqualTo>

<gml:boundedBy>

<gml:Envelope srsDimension="2" srsName="urn:ogc:def:crs:EPSG::28992">

<gml:lowerCorner>107240 508576</gml:lowerCorner>

<gml:upperCorner>109000 510167</gml:upperCorner>

</gml:Envelope>

</gml:boundedBy>

</ogc:And>

</ogc:Filter>

source used: http://gdsc.nlr.nl/gdsc/en/software/excat/manual/ogcfilter_examples

Any advice is much appreciated!

Cheers!

Re: How to construct a WFS-URL that both filters on an attribute and uses a boudingbox filter

basboers1 — Wed, 25 Feb 2015 21:36:50 GMT

Together with my colleague Gert-Jan van Weijden I found a solution for combining a spatial filter and an attribute filter in a WFS-request. As expected this only works when integrating both query-expressions within the filter-statement, as these criteria rule eachother out otherwise:

After extensive experimenting with formulating ogc-compliant requests, Gert-Jan pointed out the option of using a much more straightforward CQL-filter, which is an extension on Geoserver.

Using the cql-approach worked fine when combining a bounding box with an attribute filter for: http://geodata.nationaalgeoregister.nl/bestuurlijkegrenzen/wfs?

The full successful request (which as intended renders only the municipality of Almere and not Breda, because only Almere lies within de defined bounding box):

http://geodata.nationaalgeoregister.nl/bestuurlijkegrenzen/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&TYPENAME=bestuurlijkegrenzen:gemeenten&SRSNAME=EPSG:28992&cql_filter=(bbox(geom,100000,450000,200000,500000,%27EPSG:28992%27)and((gemeentenaam=%27Almere%27)or(gemeentenaam=%27Breda%27)))

However using the same formula for the BAG-WFS, wasn’t directly successful. As it turned out “geom.” - from the URL above - refers to the property name of the geometry-field (and should do so). Since the geometry-field of the BAG-WFS is “geometrie” , “geom” should be replaced here for “geometrie”. Having made this substitution renders the following successful request for the BAG-WFS.

http://geodata.nationaalgeoregister.nl/bag/wfs?REQUEST=GetFeature&SERVICE=WFS&VERSION=2.0.0&TYPENAME=bag:pand&SRSNAME=EPSG:28992&cql_filter=(bbox(geometrie,107240,507000,109000,509000,%27EPSG:28992%27)and(status=%27Bouwvergunning verleend%27))