Example Adding A New Coordinate System based on the EPSG model introduced in 10gR2
Last updated on NOVEMBER 17, 2016
Applies to:Oracle Spatial and Graph - Version 10.2.0.1 to 220.127.116.11 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 24-Dec-2013
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.
AUTH_NAME: VDOT Custom Lambert Conformal Conic
SPHEROID["GRS_1980", 6378137.0, 298.257222101]],
The goal is to create the equivalent coordinate system in the 10.2 release.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms