[Geoserver-users] urn:ogc:def:query:OGC-WFS::GetFeatureById

Bart_Verbeeck · April 16, 2019, 11:10am

Dear list

I have a service providing harmonized data.

The service works, only the storedquery urn:ogc:def:query:OGC-WFS::GetFeatureById throws an error

I get the first record to find an ID

https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&count=1

GetFeature/FeatureID works ok

https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&FeatureID=vha_waterloopsegment_100000

The stored query throws an error: Could not find feature with specified id

https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?SERVICE=WFS&REQUEST=GetFeature&VERSION=2.0.0&storedquery_id=urn%3Aogc%3Adef%3Aquery%3AOGC-WFS%3A%3AGetFeatureById&outputformat=application%2Fgml%2Bxml%3B%20version%3D3.2&id=vha_waterloopsegment_100000&typename=hy-n%3AWatercourseLink

I use Geoserver 2.15

Data is stored in sqlserver

I use the AppSchema extension (And I paste the definition below)

Is there something wrong in this definition. The storedquery works all right in my other services, that don’t use the app schema extension.

For example

https://geoservices.beta.informatievlaanderen.be/overdrachtdiensten/Adressen/wfs?service=WFS&REQUEST=GetFeature&STOREDQUERY_ID=urn:ogc:def:query:OGC-WFS::GetFeatureById&ID=Adrespos.1000320856&typename=Adressen:Adrespos&outputformat=GML2

I examined the log files, but I couldn’t find anyting more than “Could not find feature with specified id” (GEOTOOLS_DEVELOPER_LOGGING)

Thanks

Bart

http://inspire.ec.europa.eu/schemas/hy-n/4.0/HydroNetwork.xsd

dataStore

WatercourseLink

hy-n:WatercourseLink

nns:beginLifespanVersion

beginLifespanVersion

nns:centrelineGeometry

strConcat(‘centrelineGeometry.’, getId())

SHAPE

nns:fictitious

fictitious

hy-n:flowDirection

xlink:href

flowDirection_href

hy-n:WatercourseLink

gml_id

gml:identifier

gml_identifier

codeSpace

gml_codespace

nns:inNetwork

nilReason

inNetwork

xsi:nil

if_then_else(isNull(inNetwork), Expression.NIL, ‘true’)

nns:inspireId/base:Identifier/base:localId

inspireId_localId

nns:inspireId/base:Identifier/base:namespace

inspireId_namespace

hy-n:length

length

xsi:nil

if_then_else(isNull(length), ‘true’, Expression.NIL)

uom

length_uom

nns:inspireId/base:Identifier/base:versionId

inspireId_versionId

Rusu_Sorin · April 17, 2019, 11:10am

Hi Bart,

I am pretty sure this is a known, un-fixed issue when using complex features served from Geoserver + AppSchema, due to the fact that gml:id isn’t getting resolved. I believe this is regardless of the underlying DB: we were working on PG + PostGIS, but should replicate on SQL Server.

With my previous team, we tried to figure out a way to fix the broken Stored Query, however we couldn’t achieve a clear resolution, and I am unsure if this was addressed.

Sorin RUSU
GIS

Pe marți, 16 aprilie 2019, 19:46:14 EEST, Verbeeck Bart (AIV) bart.verbeeck@anonymised.com a scris:

Dear list

I have a service providing harmonized data.

The service works, only the storedquery urn:ogc:def:query:OGC-WFS::GetFeatureById throws an error

I get the first record to find an ID

https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&count=1

GetFeature/FeatureID works ok

https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&FeatureID=vha_waterloopsegment_100000

The stored query throws an error: Could not find feature with specified id

https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?SERVICE=WFS&REQUEST=GetFeature&VERSION=2.0.0&storedquery_id=urn%3Aogc%3Adef%3Aquery%3AOGC-WFS%3A%3AGetFeatureById&outputformat=application%2Fgml%2Bxml%3B%20version%3D3.2&id=vha_waterloopsegment_100000&typename=hy-n%3AWatercourseLink

I use Geoserver 2.15

Data is stored in sqlserver

I use the AppSchema extension (And I paste the definition below)

Is there something wrong in this definition. The storedquery works all right in my other services, that don’t use the app schema extension.

For example

https://geoservices.beta.informatievlaanderen.be/overdrachtdiensten/Adressen/wfs?service=WFS&REQUEST=GetFeature&STOREDQUERY_ID=urn:ogc:def:query:OGC-WFS::GetFeatureById&ID=Adrespos.1000320856&typename=Adressen:Adrespos&outputformat=GML2

I examined the log files, but I couldn’t find anyting more than “Could not find feature with specified id” (GEOTOOLS_DEVELOPER_LOGGING)

Thanks

Bart

http://inspire.ec.europa.eu/schemas/hy-n/4.0/HydroNetwork.xsd

dataStore

WatercourseLink

hy-n:WatercourseLink

nns:beginLifespanVersion

beginLifespanVersion

nns:centrelineGeometry

strConcat(‘centrelineGeometry.’, getId())

SHAPE

nns:fictitious

fictitious

hy-n:flowDirection

xlink:href

flowDirection_href

hy-n:WatercourseLink

gml_id

gml:identifier

gml_identifier

codeSpace

gml_codespace

nns:inNetwork

nilReason

inNetwork

xsi:nil

if_then_else(isNull(inNetwork), Expression.NIL, ‘true’)

nns:inspireId/base:Identifier/base:localId

inspireId_localId

nns:inspireId/base:Identifier/base:namespace

inspireId_namespace

hy-n:length

length

xsi:nil

if_then_else(isNull(length), ‘true’, Expression.NIL)

uom

length_uom

nns:inspireId/base:Identifier/base:versionId

inspireId_versionId

Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/
The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Andrea_Aime4 · April 18, 2019, 7:47am

Hi,
I did a quick check, there are a couple of issues open related to GetFeatureById but none of them
returns the same error message:
https://osgeo-org.atlassian.net/browse/GEOS-8734

https://osgeo-org.atlassian.net/browse/GEOS-6233

It would be useful to have a ticket for this case as well, with a self-contained package (data, config, request) that
helps reproduce the problem

Cheers
Andrea

···

Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

brtvrbck · November 22, 2024, 11:16am

I know that this is an old issue, but there seem to be other issues with urn:ogc:def:query:OGC-WFS::GetFeatureById in our cofiguration.

I am using 2.25.4 now, and the data is stored in sql server.

I get the “Could not find feature with specified id” error in two cases i think I foud out:

if the sql view layer refers to a sql view and not a table
or if the layer has a name that exists in more than 1 workspace.

GetFeature/FeatureID works ok, but the stored quey doesnt find the feature.

Anyone any idea?