On Fri, Mar 23, 2012 at 9:03 AM, Lucas Heezen - Covadis <[email protected]>wrote:
> 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? > I can think of two ways: - manually add it among the extra codes that GeoServer can recognize here, and then restart GeoServer: http://docs.geoserver.org/latest/en/user/advanced/crshandling/customcrs.html - make it so that the Oracle data store becomes (or provides) also a SRS authority so that every Oracle code is contributed to the ones that GeoServer knows. Not an easy task though, Orale is filled with WKT definitions of spatial reference systems that are _not even sintactically correct_ (shame). There is a set of tables that describes how to build them, querying it we could rebuild the SRS programmatically, it's a sizable chunk of work though (likely days) Cheers Andrea > **** > > ** ** > > Met vriendelijke groet, > Lucas Heezen**** > > [image: 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]**** > > ** ** > > ** ** > > *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**** > > [image: 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]**** > > ** ** > > ** ** > > *Van:* Lucas Heezen - Covadis > *Verzonden:* woensdag 21 maart 2012 15:23 > *Aan:* Lucas Heezen - Covadis; Andrea Aime > *CC:* [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**** > > [image: 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]**** > > ** ** > > ** ** > > *Van:* Lucas Heezen - Covadis [mailto:[email protected]] > *Verzonden:* woensdag 21 maart 2012 14:51 > *Aan:* Andrea Aime > *CC:* [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**** > > [image: 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]**** > > ** ** > > ** ** > > *Van:* Lucas Heezen - Covadis > *Verzonden:* woensdag 21 maart 2012 14:42 > *Aan:* Lucas Heezen - Covadis; Andrea Aime > *CC:* [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**** > > [image: 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]**** > > ** ** > > ** ** > > *Van:* Lucas Heezen - Covadis [mailto:[email protected]] > *Verzonden:* woensdag 21 maart 2012 13:38 > *Aan:* Andrea Aime > *CC:* [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**** > > [image: 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]**** > > ** ** > > ** ** > > *Van:* [email protected] [mailto:[email protected]] *Namens *Andrea > Aime > *Verzonden:* woensdag 21 maart 2012 12:01 > *Aan:* Lucas Heezen - Covadis > *CC:* Raymond Nijssen; [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]> 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 > > -------------------------------------------------------**** > > > ------------------------------------------------------------------------------ > 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 > > -- ------------------------------------------------------- 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 -------------------------------------------------------
<<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
