Spatial (MOSC)

MOSC Banner

add a custom projected coordinate system

edited Jun 10, 2011 8:27AM in Spatial (MOSC) 3 commentsAnswered
How do I add a new projected coordinate system in 11g?  This is how I did it in 10g.
insert into cs_srs (cs_name, srid, auth_srid, auth_name, wktext) values 
  ('Mercator37', 49155000, 49155000, 'EDR', 
'PROJCS["Mercator",
   GEOGCS [
    "NAD 83 (Continental US)",
    DATUM [
     "NAD 83 (Continental US)",
     SPHEROID ["GRS 80", 6378137, 298.257222101]],
    PRIMEM [ "Greenwich", 0.000000 ],
    UNIT ["Decimal Degree", 0.01745329251994330]],
   PROJECTION ["Mercator"],
   PARAMETER ["Latitude_Of_Origin", 37.000000],
   PARAMETER ["False_Easting", 0.000000],
   PARAMETER ["False_Northing", 0.000000],
   UNIT["U.S. Foot",0.3048006096012192]]');
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center