Example Adding A New Coordinate System based on the EPSG model introduced in 10gR2

Last updated on NOVEMBER 17, 2016

Applies to:

Goal

Creating a user-defined coordinate system was done by adding a new row to the MDSYS.CS_SRS table before the 10.2 release. As of 10.2 coordinate system support is based upon the EPSG(European Petroleum Survey Group) model which is implemented using a different table structure.

For more information about this new implementation: 
                 Spatial User's Guide and Reference 11g Release 2.

This note provides an sample script to create a user-defined coordinate system based upon this new EPSG model. 

Assume we have a user-defined coordinate system in a pre-10.2 database release having the following definition.

CS_NAME: VDOT_LAMBERT 
SRID: 51000000 
AUTH_SRID: 51000000 
AUTH_NAME: VDOT Custom Lambert Conformal Conic 
WKTEXT: 
 
PROJCS[ 
"VDOT_Lambert", 
GEOGCS[ 
"GCS_North_American_1983", 
DATUM[ 
"D_North_American_1983", 
SPHEROID["GRS_1980", 6378137.0, 298.257222101]], 
PRIMEM["Greenwich", 0.0], 
UNIT["Decimal Degree",0.0174532925199433]], 
PROJECTION["Lambert_Conformal_Conic"], 
PARAMETER["False_Easting", 0.0], 
PARAMETER["False_Northing", 0.0], 
PARAMETER["Central_Meridian", -79.5], 
PARAMETER["Standard_Parallel_1", 37.0], 
PARAMETER["Standard_Parallel_2", 39.5], 
PARAMETER["Scale_Factor", 1.0], 
PARAMETER["Latitude_Of_Origin", 36.0], 
UNIT["Meter", 1.0]] 

The goal is to create the equivalent coordinate system in the 10.2 release.

Solution