My Oracle Support Banner

Example Adding A New Coordinate System based on the EPSG model introduced in 10gR2 (Doc ID 395171.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Spatial and Graph - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


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.

SRID: 51000000 
AUTH_SRID: 51000000 
AUTH_NAME: VDOT Custom Lambert Conformal Conic 
SPHEROID["GRS_1980", 6378137.0, 298.257222101]], 
PRIMEM["Greenwich", 0.0], 
UNIT["Decimal Degree",0.0174532925199433]], 
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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.