Hello List,
I'm trying to define a Stored Query for INSPIRE („Get Spatial Dataset Operation“), which return all FeatureTypes („a Dataset“) in one response.
I tried the following Stored Query Definition without success --> Join query must specify a filter
<wfs:CreateStoredQuery service="WFS" version="2.0.0"
xmlns="http://www.opengis.net/wfs/2.0"
xmlns:wfs="http://www.opengis.net/wfs/2.0"
xmlns:gml="http://www.opengis.net/gml/3.2"
xmlns:fes="http://www.opengis.net/fes/2.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:bvv="http://www.geodaten.bayern.de"
xsi:schemaLocation="http://www.opengis.net/wfs/2.0 http://schemas.opengis.net/wfs/2.0/wfs.xsd http://www.opengis.net/gml/3.2 http://schemas.opengis.net/gml/3.2.1/gml.xsd" xmlns:ns1="http://www.opengis.net/ows/1.1">
<wfs:StoredQueryDefinition id="InspireStoredQueryBeispiel">
<Title>INSPIRE pre-defined WFS Stored Query Example</Title>
<!-- Definition Variablen -->
<wfs:Parameter name="CRS" type="xsd:string" />
<wfs:Parameter name="DataSetId" type="xsd:string" />
<wfs:Parameter name="Language" type="xsd:string" />
<wfs:QueryExpressionText returnFeatureTypes="bvv:bayern_ex bvv:lkr_ex bvv:gmd_ex bvv:regbez_ex bvv:vg_ex" language="urn:ogc:def:queryLanguage:OGC-WFS::WFS_QueryExpression">
<wfs:Query typeNames="bvv:bayern_ex bvv:lkr_ex bvv:gmd_ex bvv:regbez_ex bvv:vg_ex" srsName="${CRS}" />
</wfs:QueryExpressionText>
</wfs:StoredQueryDefinition>
</wfs:CreateStoredQuery>
DataSetId and Language will be ignored.
Thanks in advance.
Juergen
Hi Juergen,
In WFS 2.0 when you specify a single query with multiple type names it implies you are doing a join which requires a filter to define the join condition. Is that what you are actually wanting to do?
If you just want to dump all the data without ajoin you need to use multiple Query elements, each with a single type name:
<wfs:Query typeNames=“bvv:bayern_ex” srsName=“${CRS}” />
<wfs:Query typeNames=“bvv:lkr_ex” srsName=“${CRS}” />
etc…
-Justin
···
On Tue, Dec 4, 2012 at 4:49 AM, Jürgen Weichand <juergen.weichand@…4926…> wrote:
Hello List,
I’m trying to define a Stored Query for INSPIRE („Get Spatial Dataset
Operation“), which return all FeatureTypes („a Dataset“) in one response.
I tried the following Stored Query Definition without success → Join
query must specify a filter
<wfs:CreateStoredQuery service=“WFS” version=“2.0.0”
xmlns=“http://www.opengis.net/wfs/2.0”
xmlns:wfs=“http://www.opengis.net/wfs/2.0”
xmlns:gml=“http://www.opengis.net/gml/3.2”
xmlns:fes=“http://www.opengis.net/fes/2.0”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:xsd=“http://www.w3.org/2001/XMLSchema”
xmlns:bvv=“http://www.geodaten.bayern.de”
xsi:schemaLocation=“http://www.opengis.net/wfs/2.0
http://schemas.opengis.net/wfs/2.0/wfs.xsd
http://www.opengis.net/gml/3.2
http://schemas.opengis.net/gml/3.2.1/gml.xsd”
xmlns:ns1=“http://www.opengis.net/ows/1.1”>
<wfs:StoredQueryDefinition id=“InspireStoredQueryBeispiel”>
INSPIRE pre-defined WFS Stored Query Example
DataSetId and Language will be ignored.
Thanks in advance.
Juergen
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Hello Justin,
I want to dump all the data. Also tried the following statements (GeoServer 2.2).
Best regards
Juergen
<wfs:CreateStoredQuery service=“WFS” version=“2.0.0”
xmlns=“http://www.opengis.net/wfs/2.0”
xmlns:wfs=“http://www.opengis.net/wfs/2.0”
xmlns:gml=“http://www.opengis.net/gml/3.2”
xmlns:fes=“http://www.opengis.net/fes/2.0”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:xsd=“http://www.w3.org/2001/XMLSchema”
xmlns:bvv=“http://www.geodaten.bayern.de”
xsi:schemaLocation=“http://www.opengis.net/wfs/2.0 http://schemas.opengis.net/wfs/2.0/wfs.xsd http://www.opengis.net/gml/3.2 http://schemas.opengis.net/gml/3.2.1/gml.xsd” xmlns:ns1=“http://www.opengis.net/ows/1.1”>
<wfs:StoredQueryDefinition id=“urn:wei:def:query:OGC-WFS::InspireStoredQueryExample”>
INSPIRE pre-defined WFS - Stored Query Beispiel
Stored Query für den Download des Geodatensatzes 'OpenData Verwaltungsgrenzen Bayern'
------> Response
<ows:Exception exceptionCode=“OperationProcessingFailed” locator=“CreateStoredQuery”>
ows:ExceptionTextError validating stored query org.xml.sax.SAXParseException: The markup in the document following the root element must be well-formed. The markup in the document following the root element must be well-formed.</ows:ExceptionText>
</ows:Exception>
Hmmm… the first error indicates a syntax error but i don’t see one in your document so probably a bug. Which isn’t surprising, afaik stored queries haven’t see much use yet from users, the implemetation there was sort of the minimum to tick off that requirement for wfs 2.0
Could you open a bug report in JIRA. Ideally using examples that will work against the vanilla GeOServer configuration. Thanks.
-Justin
···
On Thu, Dec 6, 2012 at 1:35 AM, Jürgen Weichand <juergen.weichand@anonymised.com> wrote:
Hello Justin,
I want to dump all the data. Also tried the following statements (GeoServer 2.2).
Best regards
Juergen
<wfs:CreateStoredQuery service=“WFS” version=“2.0.0”
xmlns=“http://www.opengis.net/wfs/2.0”
xmlns:wfs=“http://www.opengis.net/wfs/2.0”
xmlns:gml=“http://www.opengis.net/gml/3.2”
xmlns:fes=“http://www.opengis.net/fes/2.0”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:xsd=“http://www.w3.org/2001/XMLSchema”
xmlns:bvv=“http://www.geodaten.bayern.de”
xsi:schemaLocation=“http://www.opengis.net/wfs/2.0 http://schemas.opengis.net/wfs/2.0/wfs.xsd http://www.opengis.net/gml/3.2 http://schemas.opengis.net/gml/3.2.1/gml.xsd” xmlns:ns1=“http://www.opengis.net/ows/1.1”>
<wfs:StoredQueryDefinition id=“urn:wei:def:query:OGC-WFS::InspireStoredQueryExample”>
INSPIRE pre-defined WFS - Stored Query Beispiel
Stored Query für den Download des Geodatensatzes 'OpenData Verwaltungsgrenzen Bayern'
<wfs:Parameter name=“CRS” type=“xsd:string” />
<wfs:Parameter name=“DataSetId” type=“xsd:string” />
<wfs:Parameter name=“Language” type=“xsd:string” />
<wfs:QueryExpressionText returnFeatureTypes=“bvv:bayern_ex bvv:lkr_ex bvv:gmd_ex bvv:regbez_ex bvv:vg_ex” language=“urn:ogc:def:queryLanguage:OGC-WFS::WFS_QueryExpression”>
<wfs:Query typeNames=“bvv:bayern_ex” srsName=“${CRS}”/>
<wfs:Query typeNames=“bvv:lkr_ex” srsName=“${CRS}”/>
<wfs:Query typeNames=“bvv:gmd_ex” srsName=“${CRS}”/>
<wfs:Query typeNames=“bvv:regbez_ex” srsName=“${CRS}”/>
<wfs:Query typeNames=“bvv:vg_ex” srsName=“${CRS}”/>
</wfs:QueryExpressionText>
</wfs:StoredQueryDefinition>
</wfs:CreateStoredQuery>
------> Response
<ows:Exception exceptionCode=“OperationProcessingFailed” locator=“CreateStoredQuery”>
ows:ExceptionTextError validating stored query org.xml.sax.SAXParseException: The markup in the document following the root element must be well-formed. The markup in the document following the root element must be well-formed.</ows:ExceptionText>
</ows:Exception>
<wfs:CreateStoredQuery service="WFS" version="2.0.0"
xmlns=["http://www.opengis.net/wfs/2.0"](http://www.opengis.net/wfs/2.0)
xmlns:wfs=["http://www.opengis.net/wfs/2.0"](http://www.opengis.net/wfs/2.0)
xmlns:gml=["http://www.opengis.net/gml/3.2"](http://www.opengis.net/gml/3.2)
xmlns:fes=["http://www.opengis.net/fes/2.0"](http://www.opengis.net/fes/2.0)
xmlns:xsi=["http://www.w3.org/2001/XMLSchema-instance"](http://www.w3.org/2001/XMLSchema-instance)
xmlns:xsd=["http://www.w3.org/2001/XMLSchema"](http://www.w3.org/2001/XMLSchema)
xmlns:bvv=["http://www.geodaten.bayern.de"](http://www.geodaten.bayern.de)
xsi:schemaLocation=["http://www.opengis.net/wfs/2.0 http://schemas.opengis.net/wfs/2.0/wfs.xsd http://www.opengis.net/gml/3.2 http://schemas.opengis.net/gml/3.2.1/gml.xsd"](http://www.opengis.net/wfs/2.0http://schemas.opengis.net/wfs/2.0/wfs.xsdhttp://www.opengis.net/gml/3.2http://schemas.opengis.net/gml/3.2.1/gml.xsd) xmlns:ns1=["http://www.opengis.net/ows/1.1"](http://www.opengis.net/ows/1.1)>
<wfs:StoredQueryDefinition id="urn:wei:def:query:OGC-WFS::InspireStoredQueryExample">
<Title>INSPIRE pre-defined WFS - Stored Query Beispiel</Title>
<Abstract>Stored Query für den Download des Geodatensatzes 'OpenData Verwaltungsgrenzen Bayern'</Abstract>
<!-- Koordinatenreferenzsystem z.B: urn:ogc:def:crs:EPSG::31468 -->
<wfs:Parameter name="CRS" type="xsd:string" />
<!-- Datensatzidentifikator - im Beispiel ohne Funktion -->
<wfs:Parameter name="DataSetId" type="xsd:string" />
<!-- Sprache - im Beispiel ohne Funktion -->
<wfs:Parameter name="Language" type="xsd:string" />
<wfs:QueryExpressionText returnFeatureTypes="bvv:bayern_ex bvv:lkr_ex bvv:gmd_ex bvv:regbez_ex bvv:vg_ex" language="urn:ogc:def:queryLanguage:OGC-WFS::WFS_QueryExpression">
<wfs:Query typeNames="schema-element(gml:AbstractFeature)" srsName="${CRS}"/>
</wfs:QueryExpressionText>
</wfs:StoredQueryDefinition>
</wfs:CreateStoredQuery>
------> Response
<ows:Exception exceptionCode="OperationProcessingFailed" locator="CreateStoredQuery">
<ows:ExceptionText>Error validating stored query org.geoserver.wfs.WFSException: Unknown namespace [schema-element(gml] Unknown namespace [schema-element(gml]</ows:ExceptionText>
</ows:Exception>
Am 05.12.2012 16:17, schrieb Justin Deoliveira:
> Hi Juergen,
>
> In WFS 2.0 when you specify a single query with multiple type names it implies you are doing a join which requires a filter to define the join condition. Is that what you are actually wanting to do?
>
> If you just want to dump all the data without ajoin you need to use multiple Query elements, each with a single type name:
>
> <wfs:Query typeNames="bvv:bayern_ex" srsName="${CRS}" />
>
> <wfs:Query typeNames="bvv:lkr_ex" srsName="${CRS}" />
>
> etc....
>
> -Justin
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
On Tue, Dec 4, 2012 at 4:49 AM, Jürgen Weichand <juergen.weichand@anonymised.com> wrote:
Hello List,
I’m trying to define a Stored Query for INSPIRE („Get Spatial Dataset
Operation“), which return all FeatureTypes („a Dataset“) in one response.
I tried the following Stored Query Definition without success → Join
query must specify a filter
<wfs:CreateStoredQuery service=“WFS” version=“2.0.0”
xmlns=“http://www.opengis.net/wfs/2.0”
xmlns:wfs=“http://www.opengis.net/wfs/2.0”
xmlns:gml=“http://www.opengis.net/gml/3.2”
xmlns:fes=“http://www.opengis.net/fes/2.0”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:xsd=“http://www.w3.org/2001/XMLSchema”
xmlns:bvv=“http://www.geodaten.bayern.de”
xsi:schemaLocation=“http://www.opengis.net/wfs/2.0
http://schemas.opengis.net/wfs/2.0/wfs.xsd
http://www.opengis.net/gml/3.2
http://schemas.opengis.net/gml/3.2.1/gml.xsd”
xmlns:ns1=“http://www.opengis.net/ows/1.1”>
<wfs:StoredQueryDefinition id=“InspireStoredQueryBeispiel”>
INSPIRE pre-defined WFS Stored Query Example
DataSetId and Language will be ignored.
Thanks in advance.
Juergen
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.