WFS does not work with gdal where clause

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

WFS does not work with gdal where clause

niels@lat/lon

Hello list members,

 

i am trying to configure a deegree wfs to connect a data pool (postgis db) to an existing tool with gdal driver for wfs Client.

The client map a specific where clause to the GetFeature  request but deegree simply ignore the where clause.

The result is that every case contains the same Feature set  instead of beeing filtered by the where clause.

With Geoserver everythink works fine with the same infrastructure.

 

Perhaps someone of you can help me with this Problem ?

 

Furthermore here are the Capabilities of my WFS:

 

<WFS_Capabilities version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"><ows:ServiceIdentification><ows:Title>My own OGC service</ows:Title><ows:Abstract>An OGC service with unconfigured metadata (needs configuration)</ows:Abstract><ows:ServiceType>WFS</ows:ServiceType><ows:ServiceTypeVersion>1.1.0</ows:ServiceTypeVersion></ows:ServiceIdentification><ows:ServiceProvider><ows:ProviderName>lat/lon GmbH</ows:ProviderName><ows:ProviderSite xlink:href="http://www.lat-lon.de"/><ows:ServiceContact><ows:IndividualName>Andreas Schmitz</ows:IndividualName><ows:PositionName>Software developer</ows:PositionName><ows:ContactInfo><ows:Phone><ows:Voice>0228/18496-0</ows:Voice><ows:Facsimile>0228/18496-29</ows:Facsimile></ows:Phone><ows:Address><ows:DeliveryPoint>Aennchenstr. 19</ows:DeliveryPoint><ows:City>Bonn</ows:City><ows:AdministrativeArea>NRW</ows:AdministrativeArea><ows:PostalCode>53177</ows:PostalCode><ows:Country>Germany</ows:Country><ows:ElectronicMailAddress>[hidden email]</ows:ElectronicMailAddress></ows:Address><ows:OnlineResource xlink:href="http://www.deegree.org"/><ows:HoursOfService>24x7</ows:HoursOfService><ows:ContactInstructions>Do not hesitate to call</ows:ContactInstructions></ows:ContactInfo><ows:Role>PointOfContact</ows:Role></ows:ServiceContact></ows:ServiceProvider><ows:OperationsMetadata><ows:Operation name="DescribeFeatureType"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetCapabilities"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="AcceptVersions"><ows:Value>1.1.0</ows:Value></ows:Parameter><ows:Parameter name="AcceptFormats"><ows:Value>text/xml</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetFeature"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="resultType"><ows:Value>results</ows:Value><ows:Value>hits</ows:Value></ows:Parameter><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetFeatureWithLock"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="resultType"><ows:Value>results</ows:Value><ows:Value>hits</ows:Value></ows:Parameter><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetGmlObject"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="LockFeature"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="lockAction"><ows:Value>ALL</ows:Value><ows:Value>SOME</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="Transaction"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="inputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter><ows:Parameter name="idgen"><ows:Value>GenerateNew</ows:Value><ows:Value>UseExisting</ows:Value><ows:Value>ReplaceDuplicate</ows:Value></ows:Parameter><ows:Parameter name="releaseAction"><ows:Value>ALL</ows:Value><ows:Value>SOME</ows:Value></ows:Parameter></ows:Operation></ows:OperationsMetadata><FeatureTypeList><FeatureType><Name>app:mview_gafgdi_sss_irs_r2deeg</Name><Title>app:mview_gafgdi_sss_irs_r2deeg</Title><DefaultSRS>urn:ogc:def:crs:EPSG::4326</DefaultSRS><OutputFormats><Format>application/gml+xml; version=3.2</Format><Format>text/xml; subtype=gml/3.2.1</Format></OutputFormats><ows:WGS84BoundingBox><ows:LowerCorner>-48.799999 -29.664999</ows:LowerCorner><ows:UpperCorner>69.453000 81.052000</ows:UpperCorner></ows:WGS84BoundingBox></FeatureType></FeatureTypeList><ogc:Filter_Capabilities><ogc:Spatial_Capabilities><ogc:GeometryOperands><ogc:GeometryOperand>gml:Envelope</ogc:GeometryOperand><ogc:GeometryOperand>gml:Point</ogc:GeometryOperand><ogc:GeometryOperand>gml:LineString</ogc:GeometryOperand><ogc:GeometryOperand>gml:Polygon</ogc:GeometryOperand><ogc:GeometryOperand>gml:ArcByCenterPoint</ogc:GeometryOperand><ogc:GeometryOperand>gml:CircleByCenterPoint</ogc:GeometryOperand><ogc:GeometryOperand>gml:Arc</ogc:GeometryOperand><ogc:GeometryOperand>gml:Circle</ogc:GeometryOperand><ogc:GeometryOperand>gml:ArcByBulge</ogc:GeometryOperand></ogc:GeometryOperands><ogc:SpatialOperators><ogc:SpatialOperator name="BBOX"/><ogc:SpatialOperator name="Equals"/><ogc:SpatialOperator name="Disjoint"/><ogc:SpatialOperator name="Intersects"/><ogc:SpatialOperator name="Touches"/><ogc:SpatialOperator name="Crosses"/><ogc:SpatialOperator name="Within"/><ogc:SpatialOperator name="Contains"/><ogc:SpatialOperator name="Overlaps"/><ogc:SpatialOperator name="Beyond"/><ogc:SpatialOperator name="DWithin"/></ogc:SpatialOperators></ogc:Spatial_Capabilities><ogc:Scalar_Capabilities><ogc:LogicalOperators/><ogc:ComparisonOperators><ogc:ComparisonOperator>LessThan</ogc:ComparisonOperator><ogc:ComparisonOperator>GreaterThan</ogc:ComparisonOperator><ogc:ComparisonOperator>LessThanEqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>GreaterThanEqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>EqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>NotEqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>Like</ogc:ComparisonOperator><ogc:ComparisonOperator>Between</ogc:ComparisonOperator><ogc:ComparisonOperator>NullCheck</ogc:ComparisonOperator></ogc:ComparisonOperators><ogc:ArithmeticOperators><ogc:SimpleArithmetic/><ogc:Functions><ogc:FunctionNames><ogc:FunctionName nArgs="1">Area</ogc:FunctionName><ogc:FunctionName nArgs="1">Centroid</ogc:FunctionName><ogc:FunctionName nArgs="1">ExtraProp</ogc:FunctionName><ogc:FunctionName nArgs="2">GeometryFromWKT</ogc:FunctionName><ogc:FunctionName nArgs="0">GetCurrentScale</ogc:FunctionName><ogc:FunctionName nArgs="2">IDiv</ogc:FunctionName><ogc:FunctionName nArgs="2">IMod</ogc:FunctionName><ogc:FunctionName nArgs="1">InteriorPoint</ogc:FunctionName><ogc:FunctionName nArgs="1">IsCurve</ogc:FunctionName><ogc:FunctionName nArgs="1">IsPoint</ogc:FunctionName><ogc:FunctionName nArgs="1">IsSurface</ogc:FunctionName><ogc:FunctionName nArgs="1">Length</ogc:FunctionName><ogc:FunctionName nArgs="1">Lower</ogc:FunctionName><ogc:FunctionName nArgs="1">MoveGeometry</ogc:FunctionName><ogc:FunctionName nArgs="1">Upper</ogc:FunctionName></ogc:FunctionNames></ogc:Functions></ogc:ArithmeticOperators></ogc:Scalar_Capabilities><ogc:Id_Capabilities><ogc:EID/><ogc:FID/></ogc:Id_Capabilities></ogc:Filter_Capabilities></WFS_Capabilities>


------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users
Reply | Threaded
Open this post in threaded view
|

Re: WFS does not work with gdal where clause

jratike80
Hi,

I suppose that you are using ogr2ogr as WFS client with -where parameter, right? You should show the whole command or even better, capture the WFS request and especially the filter that GDAL builds. Adding "--debug on" into ogr2ogr command may also give some more information.

Jukka Rahkonen

Lähettäjä: [hidden email]
Lähetetty: ‎11.‎5.‎2016 12:19
Vastaanottaja: [hidden email]
Aihe: [deegree-users] WFS does not work with gdal where clause

Hello list members,

 

i am trying to configure a deegree wfs to connect a data pool (postgis db) to an existing tool with gdal driver for wfs Client.

The client map a specific where clause to the GetFeature  request but deegree simply ignore the where clause.

The result is that every case contains the same Feature set  instead of beeing filtered by the where clause.

With Geoserver everythink works fine with the same infrastructure.

 

Perhaps someone of you can help me with this Problem ?

 

Furthermore here are the Capabilities of my WFS:

 

<WFS_Capabilities version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"><ows:ServiceIdentification><ows:Title>My own OGC service</ows:Title><ows:Abstract>An OGC service with unconfigured metadata (needs configuration)</ows:Abstract><ows:ServiceType>WFS</ows:ServiceType><ows:ServiceTypeVersion>1.1.0</ows:ServiceTypeVersion></ows:ServiceIdentification><ows:ServiceProvider><ows:ProviderName>lat/lon GmbH</ows:ProviderName><ows:ProviderSite xlink:href="http://www.lat-lon.de"/><ows:ServiceContact><ows:IndividualName>Andreas Schmitz</ows:IndividualName><ows:PositionName>Software developer</ows:PositionName><ows:ContactInfo><ows:Phone><ows:Voice>0228/18496-0</ows:Voice><ows:Facsimile>0228/18496-29</ows:Facsimile></ows:Phone><ows:Address><ows:DeliveryPoint>Aennchenstr. 19</ows:DeliveryPoint><ows:City>Bonn</ows:City><ows:AdministrativeArea>NRW</ows:AdministrativeArea><ows:PostalCode>53177</ows:PostalCode><ows:Country>Germany</ows:Country><ows:ElectronicMailAddress>[hidden email]</ows:ElectronicMailAddress></ows:Address><ows:OnlineResource xlink:href="http://www.deegree.org"/><ows:HoursOfService>24x7</ows:HoursOfService><ows:ContactInstructions>Do not hesitate to call</ows:ContactInstructions></ows:ContactInfo><ows:Role>PointOfContact</ows:Role></ows:ServiceContact></ows:ServiceProvider><ows:OperationsMetadata><ows:Operation name="DescribeFeatureType"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetCapabilities"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="AcceptVersions"><ows:Value>1.1.0</ows:Value></ows:Parameter><ows:Parameter name="AcceptFormats"><ows:Value>text/xml</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetFeature"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="resultType"><ows:Value>results</ows:Value><ows:Value>hits</ows:Value></ows:Parameter><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetFeatureWithLock"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="resultType"><ows:Value>results</ows:Value><ows:Value>hits</ows:Value></ows:Parameter><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="GetGmlObject"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="outputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="LockFeature"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="lockAction"><ows:Value>ALL</ows:Value><ows:Value>SOME</ows:Value></ows:Parameter></ows:Operation><ows:Operation name="Transaction"><ows:DCP><ows:HTTP><ows:Get xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS?"/><ows:Post xlink:href="http://genztsv00151:8080/deegree-test/services/TestDB_ViewFeature_WFS"/></ows:HTTP></ows:DCP><ows:Parameter name="inputFormat"><ows:Value>application/gml+xml; version=3.2</ows:Value><ows:Value>text/xml; subtype=gml/3.2.1</ows:Value></ows:Parameter><ows:Parameter name="idgen"><ows:Value>GenerateNew</ows:Value><ows:Value>UseExisting</ows:Value><ows:Value>ReplaceDuplicate</ows:Value></ows:Parameter><ows:Parameter name="releaseAction"><ows:Value>ALL</ows:Value><ows:Value>SOME</ows:Value></ows:Parameter></ows:Operation></ows:OperationsMetadata><FeatureTypeList><FeatureType><Name>app:mview_gafgdi_sss_irs_r2deeg</Name><Title>app:mview_gafgdi_sss_irs_r2deeg</Title><DefaultSRS>urn:ogc:def:crs:EPSG::4326</DefaultSRS><OutputFormats><Format>application/gml+xml; version=3.2</Format><Format>text/xml; subtype=gml/3.2.1</Format></OutputFormats><ows:WGS84BoundingBox><ows:LowerCorner>-48.799999 -29.664999</ows:LowerCorner><ows:UpperCorner>69.453000 81.052000</ows:UpperCorner></ows:WGS84BoundingBox></FeatureType></FeatureTypeList><ogc:Filter_Capabilities><ogc:Spatial_Capabilities><ogc:GeometryOperands><ogc:GeometryOperand>gml:Envelope</ogc:GeometryOperand><ogc:GeometryOperand>gml:Point</ogc:GeometryOperand><ogc:GeometryOperand>gml:LineString</ogc:GeometryOperand><ogc:GeometryOperand>gml:Polygon</ogc:GeometryOperand><ogc:GeometryOperand>gml:ArcByCenterPoint</ogc:GeometryOperand><ogc:GeometryOperand>gml:CircleByCenterPoint</ogc:GeometryOperand><ogc:GeometryOperand>gml:Arc</ogc:GeometryOperand><ogc:GeometryOperand>gml:Circle</ogc:GeometryOperand><ogc:GeometryOperand>gml:ArcByBulge</ogc:GeometryOperand></ogc:GeometryOperands><ogc:SpatialOperators><ogc:SpatialOperator name="BBOX"/><ogc:SpatialOperator name="Equals"/><ogc:SpatialOperator name="Disjoint"/><ogc:SpatialOperator name="Intersects"/><ogc:SpatialOperator name="Touches"/><ogc:SpatialOperator name="Crosses"/><ogc:SpatialOperator name="Within"/><ogc:SpatialOperator name="Contains"/><ogc:SpatialOperator name="Overlaps"/><ogc:SpatialOperator name="Beyond"/><ogc:SpatialOperator name="DWithin"/></ogc:SpatialOperators></ogc:Spatial_Capabilities><ogc:Scalar_Capabilities><ogc:LogicalOperators/><ogc:ComparisonOperators><ogc:ComparisonOperator>LessThan</ogc:ComparisonOperator><ogc:ComparisonOperator>GreaterThan</ogc:ComparisonOperator><ogc:ComparisonOperator>LessThanEqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>GreaterThanEqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>EqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>NotEqualTo</ogc:ComparisonOperator><ogc:ComparisonOperator>Like</ogc:ComparisonOperator><ogc:ComparisonOperator>Between</ogc:ComparisonOperator><ogc:ComparisonOperator>NullCheck</ogc:ComparisonOperator></ogc:ComparisonOperators><ogc:ArithmeticOperators><ogc:SimpleArithmetic/><ogc:Functions><ogc:FunctionNames><ogc:FunctionName nArgs="1">Area</ogc:FunctionName><ogc:FunctionName nArgs="1">Centroid</ogc:FunctionName><ogc:FunctionName nArgs="1">ExtraProp</ogc:FunctionName><ogc:FunctionName nArgs="2">GeometryFromWKT</ogc:FunctionName><ogc:FunctionName nArgs="0">GetCurrentScale</ogc:FunctionName><ogc:FunctionName nArgs="2">IDiv</ogc:FunctionName><ogc:FunctionName nArgs="2">IMod</ogc:FunctionName><ogc:FunctionName nArgs="1">InteriorPoint</ogc:FunctionName><ogc:FunctionName nArgs="1">IsCurve</ogc:FunctionName><ogc:FunctionName nArgs="1">IsPoint</ogc:FunctionName><ogc:FunctionName nArgs="1">IsSurface</ogc:FunctionName><ogc:FunctionName nArgs="1">Length</ogc:FunctionName><ogc:FunctionName nArgs="1">Lower</ogc:FunctionName><ogc:FunctionName nArgs="1">MoveGeometry</ogc:FunctionName><ogc:FunctionName nArgs="1">Upper</ogc:FunctionName></ogc:FunctionNames></ogc:Functions></ogc:ArithmeticOperators></ogc:Scalar_Capabilities><ogc:Id_Capabilities><ogc:EID/><ogc:FID/></ogc:Id_Capabilities></ogc:Filter_Capabilities></WFS_Capabilities>


------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users