An update about this problem.

What is figured out was that with an oracle connection my nativeCRS is never 
discovered. It keeps saying 'UNKNOWN'. My oracle tables are in SRID 90112.
I changed the SRID in Oracle to 28992 (RD) with the following steps:


1.       Remove spatial index from table.

2.       update user_sdo_geom_metadata set srid = 28992 where table_name = 
'GEMEENTEGRENZEN_XML' and column_name = 'GEOMETRIE';

3.       update GEMEENTEGRENZEN_XML t set t.GEOMETRIE.sdo_srid = 28992;

4.       Create spatial index on table.

Now I load the layer into geoserver and make a REST call 
geoserver/rest/workspaces/topp/datastores/O10004_CRAORC2GISP/featuretypes/O10004_GEMEENTEGRENZEN_XML.xml.
 Now the data is loaded very fast with projectionPolicy on 'FORCE_DECLARED'.

Is there a way to make geoserver accept/recognize SRID 90112?

Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: [email protected]<mailto:[email protected]>



Van: Lucas Heezen - Covadis [mailto:[email protected]]
Verzonden: woensdag 21 maart 2012 16:16
Aan: Andrea Aime
CC: [email protected]
Onderwerp: Re: [Geoserver-users] EPSG 28992 native to declared

Andrea,

Could you point me to the direction where the featuretype is generate by REST 
(featuretypes/name.xml) so that i can debug what is slowing down the generation 
of the featuretype?


Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: [email protected]<mailto:[email protected]>



Van: Lucas Heezen - Covadis
Verzonden: woensdag 21 maart 2012 15:23
Aan: Lucas Heezen - Covadis; Andrea Aime
CC: 
[email protected]<mailto:[email protected]>
Onderwerp: RE: [Geoserver-users] EPSG 28992 native to declared

Or could it be the problem that the NATIVE SRS is set to UNKNOWN?


Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: [email protected]<mailto:[email protected]>



Van: Lucas Heezen - Covadis 
[mailto:[email protected]]<mailto:[mailto:[email protected]]>
Verzonden: woensdag 21 maart 2012 14:51
Aan: Andrea Aime
CC: 
[email protected]<mailto:[email protected]>
Onderwerp: Re: [Geoserver-users] EPSG 28992 native to declared

Its only by a Oracle DataStore postgres or shape no problem.


Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: [email protected]<mailto:[email protected]>



Van: Lucas Heezen - Covadis
Verzonden: woensdag 21 maart 2012 14:42
Aan: Lucas Heezen - Covadis; Andrea Aime
CC: 
[email protected]<mailto:[email protected]>
Onderwerp: RE: [Geoserver-users] EPSG 28992 native to declared

Hello Andrea,

Could it be the problem in this piece of code?

FeatureTypeResource.java

if(fti.getNativeCRS() != null) {
            builder.setCRS(fti.getNativeCRS());
        } else if(fti.getCRS() != null) {
            builder.setCRS(fti.getCRS());
        } else if(fti.getSRS() != null) {
            builder.setSRS(fti.getSRS());
        }



Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: [email protected]<mailto:[email protected]>



Van: Lucas Heezen - Covadis 
[mailto:[email protected]]<mailto:[mailto:[email protected]]>
Verzonden: woensdag 21 maart 2012 13:38
Aan: Andrea Aime
CC: 
[email protected]<mailto:[email protected]>
Onderwerp: Re: [Geoserver-users] EPSG 28992 native to declared

Hello Andrea,

It seems geoserver loads my EPSG correct but the map is still shifted when we 
use it in OpenLayers.
When is change to SRS handling FORCE_DECLARED then it just works fine.

http://permalink.gmane.org/gmane.comp.gis.openstreetmap.region.nl/11568


Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: [email protected]<mailto:[email protected]>



Van: [email protected]<mailto:[email protected]> 
[mailto:[email protected]]<mailto:[mailto:[email protected]]> Namens 
Andrea Aime
Verzonden: woensdag 21 maart 2012 12:01
Aan: Lucas Heezen - Covadis
CC: Raymond Nijssen; 
[email protected]<mailto:[email protected]>
Onderwerp: Re: [Geoserver-users] EPSG 28992 native to declared

On Wed, Mar 21, 2012 at 11:49 AM, Lucas Heezen - Covadis 
<[email protected]<mailto:[email protected]>> wrote:
Hello Raymond,

How can i see if the right EPSG is loaded into geoserver? Because this 
modification doesn't seem to work (nothing changed)...

Look up the code in the srs list in the demo section and check the WKT of that 
code.
For changes to the EPSG properties files to be read GeoServer needs to be 
restarted,
we don't have a hot reload mechanism for those at the moment (changes to 
GeoTools
would be required to do that).

Cheers
Andrea


--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead

Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy

phone: +39 0584 962313
fax:      +39 0584 962313
mob:    +39 339 8844549

http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf

-------------------------------------------------------

<<inline: image001.gif>>

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to