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)
<[email protected]> a scris:
<!--#yiv2640464635 _filtered #yiv2640464635 {font-family:Wingdings;panose-1:5
0 0 0 0 0 0 0 0 0;} _filtered #yiv2640464635 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv2640464635
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv2640464635
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #yiv2640464635
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv2640464635
#yiv2640464635 p.yiv2640464635MsoNormal, #yiv2640464635
li.yiv2640464635MsoNormal, #yiv2640464635 div.yiv2640464635MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv2640464635 a:link, #yiv2640464635
span.yiv2640464635MsoHyperlink
{color:blue;text-decoration:underline;}#yiv2640464635 a:visited, #yiv2640464635
span.yiv2640464635MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv2640464635
p.yiv2640464635MsoAcetate, #yiv2640464635 li.yiv2640464635MsoAcetate,
#yiv2640464635 div.yiv2640464635MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
sans-serif;}#yiv2640464635 p.yiv2640464635MsoListParagraph, #yiv2640464635
li.yiv2640464635MsoListParagraph, #yiv2640464635
div.yiv2640464635MsoListParagraph
{margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv2640464635 p.yiv2640464635msonormal0, #yiv2640464635
li.yiv2640464635msonormal0, #yiv2640464635 div.yiv2640464635msonormal0
{margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv2640464635 span.yiv2640464635BalloonTextChar
{font-family:"Tahoma", sans-serif;}#yiv2640464635
span.yiv2640464635EmailStyle21 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv2640464635 span.yiv2640464635EmailStyle23
{font-family:"Calibri", sans-serif;color:windowtext;}#yiv2640464635
.yiv2640464635MsoChpDefault {font-size:10.0pt;} _filtered #yiv2640464635
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv2640464635
div.yiv2640464635WordSection1 {}#yiv2640464635 _filtered #yiv2640464635 {}
_filtered #yiv2640464635 {font-family:Symbol;} _filtered #yiv2640464635
{font-family:"Courier New";} _filtered #yiv2640464635 {font-family:Wingdings;}
_filtered #yiv2640464635 {font-family:Symbol;} _filtered #yiv2640464635
{font-family:"Courier New";} _filtered #yiv2640464635 {font-family:Wingdings;}
_filtered #yiv2640464635 {font-family:Symbol;} _filtered #yiv2640464635
{font-family:"Courier New";} _filtered #yiv2640464635
{font-family:Wingdings;}#yiv2640464635 ol {margin-bottom:0cm;}#yiv2640464635 ul
{margin-bottom:0cm;}-->
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
<targetTypes>
<FeatureType>
<schemaUri>http://inspire.ec.europa.eu/schemas/hy-n/4.0/HydroNetwork.xsd</schemaUri>
</FeatureType>
</targetTypes>
<typeMappings>
<FeatureTypeMapping>
<sourceDataStore>dataStore</sourceDataStore>
<sourceType>WatercourseLink</sourceType>
<targetElement>hy-n:WatercourseLink</targetElement>
<attributeMappings>
<AttributeMapping>
<targetAttribute>nns:beginLifespanVersion</targetAttribute>
<sourceExpression>
<OCQL>beginLifespanVersion</OCQL>
</sourceExpression>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>nns:centrelineGeometry</targetAttribute>
<idExpression>
<OCQL>strConcat('centrelineGeometry.', getId())</OCQL>
</idExpression>
<sourceExpression>
<OCQL>SHAPE</OCQL>
</sourceExpression>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>nns:fictitious</targetAttribute>
<sourceExpression>
<OCQL>fictitious</OCQL>
</sourceExpression>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>hy-n:flowDirection</targetAttribute>
<ClientProperty>
<name>xlink:href</name>
<value>flowDirection_href</value>
</ClientProperty>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>hy-n:WatercourseLink</targetAttribute>
<idExpression>
<OCQL>gml_id</OCQL>
</idExpression>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>gml:identifier</targetAttribute>
<sourceExpression>
<OCQL>gml_identifier</OCQL>
</sourceExpression>
<ClientProperty>
<name>codeSpace</name>
<value>gml_codespace</value>
</ClientProperty>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>nns:inNetwork</targetAttribute>
<ClientProperty>
<name>nilReason</name>
<value>inNetwork</value>
</ClientProperty>
<ClientProperty>
<name>xsi:nil</name>
<value>if_then_else(isNull(inNetwork), Expression.NIL, 'true')</value>
</ClientProperty>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>nns:inspireId/base:Identifier/base:localId</targetAttribute>
<sourceExpression>
<OCQL>inspireId_localId</OCQL>
</sourceExpression>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>nns:inspireId/base:Identifier/base:namespace</targetAttribute>
<sourceExpression>
<OCQL>inspireId_namespace</OCQL>
</sourceExpression>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>hy-n:length</targetAttribute>
<sourceExpression>
<OCQL>length</OCQL>
</sourceExpression>
<ClientProperty>
<name>xsi:nil</name>
<value>if_then_else(isNull(length), 'true', Expression.NIL)</value>
</ClientProperty>
<ClientProperty>
<name>uom</name>
<value>length_uom</value>
</ClientProperty>
</AttributeMapping>
<AttributeMapping>
<targetAttribute>nns:inspireId/base:Identifier/base:versionId</targetAttribute>
<sourceExpression>
<OCQL>inspireId_versionId</OCQL>
</sourceExpression>
</AttributeMapping>
</attributeMappings>
</FeatureTypeMapping>
</typeMappings>
_______________________________________________
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
