CODEWITHSUNDEEP
oracle-databasereferenceoracle-spatialgis
Mehmet Emin Yalçın
Mehmet Emin Yalçın

Reputation: 138

Oracle Define New Spatial referance SRID

I have a wkt text about one spatial reference system. But I dont know how can I import this into oracle. Any one can help me to convert this wkt to srid for oracle spatial and transform actions. I use oracle 11g spatial wkt link : http://spatialreference.org/ref/sr-org/8775/

Upvotes: 1

Views: 1635

Answers (1)

Albert Godfrind
Albert Godfrind

Reputation: 2078

You did not say what exact version you are using, so I will assume 11.2 (11.2.0.3 or 11.2.0.4).

Can you try the following definition:

delete from sdo_coord_ref_system where srid=8775;
insert into sdo_coord_ref_system (
  SRID,
  COORD_REF_SYS_NAME,
  COORD_REF_SYS_KIND,
  GEOG_CRS_DATUM_ID,
  SOURCE_GEOG_SRID,
  IS_LEGACY,
  LEGACY_WKTEXT,
  IS_VALID,
  SUPPORTS_SDO_GEOMETRY 
)
values (
  8775,
  'ITRF96-IZMIR',
  'PROJECTED',
  1000000123,        
  1000000123,
  'TRUE',
  'PROJCS["ITRF96-IZMIR",GEOGCS ["WGS 84", DATUM ["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563]], PRIMEM [ "Greenwich", 0.000000], UNIT ["Decimal Degree", 0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting", 500000.0],PARAMETER["False_Northing", 0.0],PARAMETER["Central_Meridian",27.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',
  'TRUE',           
  'TRUE'
);
commit;

There are actually two ways to define a new coordinate system in Oracle:

  • One is to define it fully along the EPSG data model, i.e define the individual components (operation, operation method, parameter values)
  • The other is to define it as a "legacy" coordinate system, by providing the WKT encoding.

Here I used the second technique since you had already the WKT. Note that I had to tweak it a bit to match the datum, projection, parameter names expected by Oracle.

Upvotes: 1

Related Questions