oracle spatial 에 한국좌표계 정보 추가하기.

오라클 공간타입을 쓰기 위해서는 한국 좌표계 정보를 입력하여야 함. 

아래와 같이 한국좌표계를 입력하여 사용.

--구글 좌표계

INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Google Projection',900913,900913,null,'PROJCS["Google Projection", GEOGCS [ "WGS 84", DATUM ["WGS 84", SPHEROID ["Popular Visualisation Sphere", 6378137, 0]],PRIMEM["Greenwich",0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["Standard_Parallel_1",0],PARAMETER["Central_Meridian",0],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],UNIT["Meter",1]]');

INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Google Projection',3857,3857,null,'PROJCS["Google Projection", GEOGCS [ "WGS 84", DATUM ["WGS 84", SPHEROID ["Popular Visualisation Sphere", 6378137, 0]],PRIMEM["Greenwich",0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["Standard_Parallel_1",0],PARAMETER["Central_Meridian",0],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],UNIT["Meter",1]]');

--서부원점(bassel)- EPSG:5173

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korean 1985 Modified West Belt',5173,5173,null,'PROJCS["Korean 1985 Modified Korea West Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",125.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--중부원점(bassel)- EPSG:5174

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korean 1985 Modified Central Belt',5174,5174,null,'PROJCS["Korean 1985 Modified Korea Central Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",127.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--제주원점(bassel)- EPSG:5175

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korean 1985 Modified Central Belt Jeju',5175,5175,null,'PROJCS["Korean 1985_Modified Korea Central Belt Jeju",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",550000.0],PARAMETER["Central_Meridian",127.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--동부원점(bassel)- EPSG:5176

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korean 1985 Modified East Belt',5176,5176,null,'PROJCS["Korean_1985 Modified Korea East Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",129.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--동해울릉원점(bassel)- EPSG:5177

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korean 1985 Modified East Sea Belt',5177,5177,null,'PROJCS["Korean 1985 Modified Korea East Sea Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",131.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--UTM-K(Bessel 1841) EPSG:5178

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korean_1985_Korea_Unified_Coordinate_System',5178,5178,null,'PROJCS["Korean 1985 Korea Unified Coordinate System",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",1000000.0],PARAMETER["False_Northing",2000000.0],PARAMETER["Central_Meridian",127.5],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--UTM-K(GRS80) EPSG: 5179

INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korea_2000_Korea_Unified_Coordinate_System',5179,5179,null,'PROJCS["Korea 2000 Korea Unified Coordinate System",GEOGCS["ITRF2000",DATUM["IERS Terrestrial Reference Frame 2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.017453293]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",1000000.0],PARAMETER["False_Northing",2000000.0],PARAMETER["Central_Meridian",127.5],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--서부원점(GRS80) EPSG: 5180 (False_Easting: 200000.0 , False_Northing: 500000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)            

VALUES ('Korea_2000_Korea_West_Belt',5180,5180,null,'PROJCS["Korea 2000 Korea West Belt",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",125.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--중부원점(GRS80) EPSG: 5181 (False_Easting: 200000.0 , False_Northing: 500000.0)

INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) 

VALUES ('Korea_2000_Korea_Central_Belt',5181,5181,null,'PROJCS["Korea 2000 Korea Central Belt",GEOGCS["ITRF2000",DATUM["IERS Terrestrial Reference Frame 2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.017453293]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",127.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--제주원점(GRS80) EPSG: 5182 (False_Easting: 200000.0 , False_Northing: 550000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)            

VALUES ('Korea_2000_Korea_Central_Belt_Jeju',5182,5182,null,'PROJCS["Korea 2000 Korea Central Belt Jeju",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",550000.0],PARAMETER["Central_Meridian",127.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--동부원점(GRS80) EPSG: 5183 (False_Easting: 200000.0 , False_Northing: 500000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)            

VALUES ('Korea_2000_Korea_East_Belt',5183,5183,null,'PROJCS["Korea 2000 Korea East Belt",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",129.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--동해울릉원점(GRS80) EPSG: 5184 (False_Easting: 200000.0 , False_Northing: 500000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)            

VALUES ('Korea_2000_Korea_East_Sea_Belt',5184,5184,null,'PROJCS["Korea 2000 Korea East Sea Belt",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",131.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--서부원점_2010(GRS80)  EPSG: 5185 (False_Easting: 200000.0 , False_Northing: 600000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)            

VALUES ('Korea_2000_Korea_West_Belt_2010',5185,5185,null,'PROJCS["Korea 2000 Korea West Belt 2010",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",600000.0],PARAMETER["Central_Meridian",125.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--중부원점_2010(GRS80) EPSG:5186 (False_Easting: 200000.0 , False_Northing: 600000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)             

VALUES ('Korea_2000_Korea_Central_Belt_2010',5186,5186,null,'PROJCS["Korea 2000 Korea Central Belt 2010",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",600000.0],PARAMETER["Central_Meridian",127.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--동부원점_2010(GRS80)-EPSG:5187  (False_Easting: 200000.0 , False_Northing: 600000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)  

VALUES ('Korea_2000_Korea_East_Belt_2010',5187,5187,null, 'PROJCS["Korea 2000 Korea East Belt 2010",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",600000.0],PARAMETER["Central_Meridian",129.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');

--동해(울릉)원점_2010(GRS80)-EPSG:5188  (False_Easting: 200000.0 , False_Northing: 600000.0)

INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)            

VALUES ('Korea_2000_Korea_East_Sea_Belt_2010',5188,5188,null,'PROJCS["Korea 2000 Korea East Sea Belt 2010",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",600000.0],PARAMETER["Central_Meridian",131.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]')

*PostGIS 에 한국좌표계추가 => http://www.osgeo.kr/205