Last updated on NOVEMBER 17, 2016
Applies to:
Oracle Spatial and Graph - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]Information in this document applies to any platform.
Checked for relevance on 24-Dec-2013
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
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