postgresql에 좌표계 추가하기

좌표가 없는 경우에 좌표계를 추가

-- GRS80 타원체의 UTM-K 직각 좌표계
INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text) VALUES (5179, 'EPSG', 5179,   'PROJCS["Korea 2000 / Unified CS",GEOGCS["Korea 2000",DATUM["Geocentric_datum_of_Korea",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6737"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4737"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",38],PARAMETER["central_meridian",127.5],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",1000000],PARAMETER["false_northing",2000000],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","5179"]]',    '+proj=tmerc +lat_0=38 +lon_0=127.5 +k=0.9996 +x_0=1000000 +y_0=2000000 +ellps=bessel +towgs84=0,0,0,0,0,0,0 +units=m +no_defs'); 


-- 중부원점(GRS80)-EPSG:5186
INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text) VALUES (5186, 'EPSG', 5186, 'PROJCS["ITRF_2000_TM_Korea_Central_Belt", GEOGCS["GCS_ITRF_2000", DATUM["D_ITRF_2000", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["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]]', '+proj=tmerc +lat_0=38 +lon_0=127 +k=1 +x_0=200000 +y_0=600000 +ellps=GRS80 +units=m +no_defs'); 


-- 동부원점(GRS80)-EPSG:5187
INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text) VALUES (5187, 'EPSG', 5187, 'PROJCS["ITRF_2000_TM_Korea_East_Belt", GEOGCS["GCS_ITRF_2000", DATUM["D_ITRF_2000", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["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]]', '+proj=tmerc +lat_0=38 +lon_0=129 +k=1 +x_0=200000 +y_0=600000 +ellps=GRS80 +units=m +no_defs');

-- 동해(울릉)원점(GRS80)-EPSG:5188
INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text)  VALUES (5188, 'EPSG', 5188, 'PROJCS["ITRF_2000_TM_Korea_DongHae_Belt", GEOGCS["GCS_ITRF_2000", DATUM["D_ITRF_2000", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["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]]', '+proj=tmerc +lat_0=38 +lon_0=131 +k=1 +x_0=200000 +y_0=600000 +ellps=GRS80 +units=m +no_defs');