GetFeature sortBy problems

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

GetFeature sortBy problems

Heikkilä Janne (MML)

GetFeature sortBy doesn't seem to work when using WFS 2.0.0

 

My setting:

- deegree version 3.3.20

- INSPIRE GeographicalNames schema

- PostGIS FeatureStore, 800k rows in the table - one of our smallest datasets. The column mapped to 'localId' is an integer column and is also the primary key of the table. The column is btree indexed (obviously since it’s the primary key).

 

These three requests return exactly the same FeatureCollection with same Features in the same order. They aren’t either the first nor the last 10 rows in the table when actually sorted by the column mapped to  the ‘localId’

 

http://wfs.myhost.com/deegree/services/gn?service=WFS&version=2.0.0&request=GetFeature&srsName=EPSG:4326&outputFormat=text/xml;%20subtype=gml/3.2.1&typenames=gn:NamedPlace&count=10&sortBy=gn:inspireId/base:Identifier/base:localId%20DESC

http://wfs.myhost.com/deegree/services/gn?service=WFS&version=2.0.0&request=GetFeature&srsName=EPSG:4326&outputFormat=text/xml;%20subtype=gml/3.2.1&typenames=gn:NamedPlace&count=10&sortBy=gn:inspireId/base:Identifier/base:localId%20ASC

http://wfs.myhost.com/deegree/services/gn?service=WFS&version=2.0.0&request=GetFeature&srsName=EPSG:4326&outputFormat=text/xml;%20subtype=gml/3.2.1&typenames=gn:NamedPlace&count=10&sortBy=gn:inspireId/base:Identifier/base:localId

 

So it seems like sortBy is ignored totally when using WFS version 2.0.0.

Corresponding WFS 1.1.0 requests:

 

http://wfs.myhost.com/deegree/services/gn?service=WFS&version=1.1.0&request=GetFeature&srsName=EPSG:4326&outputFormat=text/xml;%20subtype=gml/3.2.1&typename=gn:NamedPlace&maxFeatures=10&sortBy=gn:inspireId/base:Identifier/base:localId%20DESC

http://wfs.myhost.com/deegree/services/gn?service=WFS&version=1.1.0&request=GetFeature&srsName=EPSG:4326&outputFormat=text/xml;%20subtype=gml/3.2.1&typename=gn:NamedPlace&maxFeatures=10&sortBy=gn:inspireId/base:Identifier/base:localId%20ASC

http://wfs.myhost.com/deegree/services/gn?service=WFS&version=1.1.0&request=GetFeature&srsName=EPSG:4326&outputFormat=text/xml;%20subtype=gml/3.2.1&typename=gn:NamedPlace&maxFeatures=10&sortBy=gn:inspireId/base:Identifier/base:localId

 

These are actually processing something but unfortunately all of them result in an Exception:

 

<?xml version='1.0' encoding='UTF-8'?>

<ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/ows http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd" version="1.0.0">

  <ows:Exception exceptionCode="NoApplicableCode">

    <ows:ExceptionText>GC overhead limit exceeded</ows:ExceptionText>

  </ows:Exception>

</ows:ExceptionReport>

 

Ideas, comments?

 

br,

Janne


------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users