Thanks ben, there was indeed a subtle problem in the mapping.
Outlook voor iOS<https://aka.ms/o0ukef> downloaden
________________________________
From: Ben Caradoc-Davies <b...@transient.nz>
Sent: Wednesday, November 1, 2017 8:44:09 PM
To: Verbeeck Bart; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] inspire-appscheme-wms-sqlserver
Bart,
WMS should be supported. Does WFS work for this layer? I suspect either
a subtle problem in your mapping or a bug in the app-schema joining
implementation.
Kind regards,
Ben.
On 31/10/17 20:13, Verbeeck Bart wrote:
> Hi again
>
> I moved my data to postgresql and I received the same error doing a getmap
> request. So this problem is not sqlserver related.
>
> Is it a wrong idea to do wms requests to an application scheme based layer?
>
>
> Geoserver sends the following query to my postgis database, and it has an
> error at "AND "uidn" FROM "public"."bekken"
>
> SELECT
> "public"."bekken"."ogc_fid",encode(ST_AsEWKB("public"."bekken"."wkb_geometry"),'base64')
> as "wkb_geometry","public"."bekken"."uidn","public"."bekken"."oidn"
> FROM "public"."bekken" INNER JOIN ( SELECT DISTINCT "oidn" FROM
> "public"."bekken"
> WHERE "wkb_geometry" && ST_GeomFromText('POLYGON ((-80016.3310434809
> -54667.64601825603, -80016.3310434809 322203.1650796655, 391530.2915944371
> 322203.1650796655, 391530.2915944371 -54667.64601825603, -80016.3310434809
> -54667.64601825603))', 31370) ) "temp_alias_used_for_filter"
> ON ( "bekken"."oidn" = "temp_alias_used_for_filter"."oidn" AND "uidn" FROM
> "public"."bekken"
> WHERE "wkb_geometry" && ST_GeomFromText('POLYGON ((-80016.3310434809
> -54667.64601825603, -80016.3310434809 322203.1650796655, 391530.2915944371
> 322203.1650796655, 391530.2915944371 -54667.64601825603, -80016.3310434809
> -54667.64601825603))', 31370) ) "temp_alias_used_for_filter"
> ON ( "bekken"."uidn" = "temp_alias_used_for_filter"."uidn" ) ORDER BY
> "public"."bekken"."oidn" ASC, "public"."bekken"."uidn" ASC,
> "public"."bekken"."ogc_fid"
>
> -----Original Message-----
> From: Verbeeck Bart [mailto:bart.verbe...@kb.vlaanderen.be]
> Sent: dinsdag 31 oktober 2017 7:35
> To: Ben Caradoc-Davies <b...@transient.nz>;
> geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] inspire-appscheme-wms-sqlserver
>
> Thanks Ben
>
> Yes, I have configured the secondary namespace. The problem occurs with "
> &outputFormat=gml3", not with " &outputFormat=gml32"
> I will follow up the GEOS-8250 issue. Hopefully it will be solved in a future
> release
>
> Bart
>
> -----Original Message-----
> From: Ben Caradoc-Davies [mailto:b...@transient.nz]
> Sent: maandag 30 oktober 2017 21:02
> To: Verbeeck Bart <bart.verbe...@kb.vlaanderen.be>;
> geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] inspire-appscheme-wms-sqlserver
>
> Bart,
>
> I have no experience with sqlserver, but in relation to the null GML
> namespace, have you configured a secondary namespace for GML 3.2.1?
> http://docs.geoserver.org/latest/en/user/data/app-schema/supported-gml-versions.html#secondary-namespace-for-gml-3-2-1-required
>
> The DescribeFeatureType problem is reported here:
>
> [GEOS-8250] WFS 2.0 DescribeFeatureType responses for app-schema types
> contain a spurious WFS 2.0 jar import
> https://osgeo-org.atlassian.net/browse/GEOS-8250
>
> Kind regards,
> Ben.
>
> On 30/10/17 23:22, Verbeeck Bart wrote:
>> Hi List
>>
>> In our organization we try to use geoserver (2.11) to serve harmonized
>> services using the application scheme extension.
>> Our data is stored in a SQLSERVER db. The documentation refers to postgres
>> and oracle databases, not to sqlserver.
>>
>> The wfs services seem to work, although
>>
>> * there is the null namespace problem (null:identifier [
>> xmlns:null=http://www.opengis.net/gml/3.2
>> codeSpace=http://inspire.ec.europa.eu/ids ])
>> * the describefeaturetype (2.0.0) result is not as I would expect,
>> schemaLocation="jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.0/webapps/overdrachtdiensten/WEB-INF/lib/gt-xsd-wfs-17.2.jar!/org/geotools/wfs/v2_0/wfs.xsd
>>
>> The wms getfeaturetype result is ok, but the getmap request causes an
>> erroneous sql request (at "FROM") (see below) The wms getmap result is
>> successful on a shapefile based layer.
>>
>> Does anyone have experience using the app scheme on a sql server database?
>>
>> Thanks
>>
>> Bart
>>
>>
>> SELECT "RT"."BEKKEN"."OBJECTID","RT"."BEKKEN"."UIDN","RT"."BEKKEN"."SHAPE"
>> as "SHAPE","RT"."BEKKEN"."OIDN"
>> FROM "RT"."BEKKEN"
>> INNER JOIN (
>> SELECT DISTINCT "OIDN"
>> FROM "RT"."BEKKEN"
>> WHERE "SHAPE".Filter(geometry::STGeomFromText('POLYGON
>> ((12127.108205075114 2103.1082012057304, 12127.108205075114
>> 395097.58538683876, 267800.38165359845 395097.58538683876,
>> 267800.38165359845 2103.1082012057304, 12127.108205075114
>> 2103.1082012057304))', 31370)) = 1 ) "temp_alias_used_for_filter"
>> ON ( "BEKKEN"."OIDN" = "temp_alias_used_for_filter"."OIDN"
>> AND "UIDN" FROM "RT"."BEKKEN" WHERE
>> "SHAPE".Filter(geometry::STGeomFromText('POLYGON ((12127.108205075114
>> 2103.1082012057304, 12127.108205075114 395097.58538683876,
>> 267800.38165359845 395097.58538683876, 267800.38165359845
>> 2103.1082012057304, 12127.108205075114 2103.1082012057304))', 31370)) = 1 )
>> "temp_alias_used_for_filter"
>> ON ( "BEKKEN"."UIDN" = "temp_alias_used_for_filter"."UIDN" )
>> ORDER BY "RT"."BEKKEN"."OIDN" ASC, "RT"."BEKKEN"."UIDN" ASC,
>> "RT"."BEKKEN"."OBJECTID"
>>
>>
>>
>>
>> ----------------------------------------------------------------------
>> -------- Check out the vibrant tech community on one of the world's
>> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>
>>
>>
>> _______________________________________________
>> 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
>>
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
> --
> Ben Caradoc-Davies <b...@transient.nz>
> Director
> Transient Software Limited <http://transient.nz/> New Zealand
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most engaging tech
> sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> 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
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ben Caradoc-Davies <b...@transient.nz>
Director
Transient Software Limited <http://transient.nz/>
New Zealand
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
