SRS should be automatically populated from the SRID database metadata for the oracle (and others?) datastore for new featuretypes

Description

Very minor thing, but if the SRID/SRS is stored in the database, why shouldn't geoserver pick it up from there.

Environment

None

Activity

codehaus 
April 10, 2015 at 4:38 PM

CodeHaus Comment From: aaime - Time: Mon, 6 Oct 2008 12:39:08 -0500
---------------------
<p>Closing for the moment, the major surgery needed to support Oracle "proprietary" SRS codes is arguably too much work for not much gain. Use the official EPSG codes and all should be fine. Anyways, I'm totally open to anyone that wants to implement this kind of functionality and provide a patch, or is willing to sponsor someone to code it for him.</p>

codehaus 
April 10, 2015 at 4:38 PM

CodeHaus Comment From: ivanprice - Time: Sun, 5 Oct 2008 23:36:51 -0500
---------------------
<p>OK thanks Andrea. The reason i assumed this wasn't happening is coz i am using oracle SRID 8307 (WGS 84 lat/long), which i assumed if anything would be recognised that would be. With 1 minutes research i see that oracle also have an SRID of 4326 which is identical.. and yes geoserver populates the srid for me.. fantastic !</p>

<p>cheers,</p>

<p>-i</p>

codehaus 
April 10, 2015 at 4:38 PM

CodeHaus Comment From: aaime - Time: Sun, 5 Oct 2008 14:59:40 -0500
---------------------
<p>Actually GeoServer is doing exactly that, provided that the SRS is one of the official EPSG ones. Oracle has a lot of "home made" ones that are also broken at the definition level (syntactically invalid WKT), in that case GeoServer won't be able to pick it up automatically.

If you have a epsg official code and it's not being picked up, please advise and provide some more details, otherwise I have no quick solution.</p>

<p>We could try to use all the srs related metadata tables to build a definition, but that would be a lot of work, and we would have to build traslation tables because they did not get right even the projection names (compared to the names used by the EPSG official authority). So there is a possibility, but it would be a lot of work, in the case you want to pursue that you can either try to do it yourself (a patch in that direction would be most welcomed) or fall back on commercial support providers for a custom extension.</p>

Won't Fix

Details

Assignee

Reporter

Components

Priority

Created October 5, 2008 at 7:40 AM
Updated October 31, 2015 at 4:52 PM
Resolved May 26, 2015 at 2:36 PM