[저장용] Oracle Spatital geojson insert

1. Oracle Spatial 공간테이블 생성

CREATE TABLE 테이블명 (
   ID NUMBER PRIMARY KEY, 
   NAME VARCHAR2 (20), 
   X VARCHAR2 (100), 
   Y VARCHAR2 (100),
   GEOM  MDSYS.SDO_GEOMETRY 
);

2. USER_SDO_GEOM_METADATA 테이블에 등록

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES
    ( '테이블명', '지오메트리컬럼명', SDO_DIM_ARRAY(
            SDO_DIM_ELEMENT('LONGITUDE', -180, 180, 0.05), 
            SDO_DIM_ELEMENT('LATITUYDE', -90, 90, 0.05)),    
     4326 );

3. GEOJSON으로 데이터 인서트

경계좌표라 데이터가 많아 geojson을 clob으로 잘라 붙여 인서트함.

INSERT INTO 테이블명 (id, name, geom) VALUES (
11, 'AREA', SDO_UTIL.FROM_GEOJSON(to_clob('{ "type": "MultiPolygon", "coordinates": [ [ [ [ 126.772867870547557, 37.540926477142975 ], [ 126.77111475511073, 37.540829357048551 ], [ 126.770975748719735, 37.540840060476633 ], [ 126.769083897902348, 37.541235500775244 ], [ 126.767355919308343, 37.54210127356513 ], [ 126.767298506623263, 37.542140021416394 ], [ 126.766354603328963, 37.542963548538324 ], [ 126.765871869820089, 37.543265181846316 ], [ 126.765811580803941, 37.543322781543196 ], [ 126.764562574221912, 37.545006511091906 ], [ 126.763603980451222, 37.545636541381931 ], [ 126.763078143949244, 37.545866432078007 ], [ 126.762992708282439, 37.545929890593563 ], [ 126.761325428036116, 37.547642791593056 ], [ 126.76078327404683, 37.548759933438475 ], [ 126.759315901572222, 37.549848285087265 ], [ 126.759217983911441, 37.549945224114943 ], [ 126.757750268363438, 37.551994206245183 ], [ 126.757044212788685, 37.55441371078647 ], [ 126.757033309905367, 37.554508013354273 ], [ 126.757114148363982, 37.556762232882811 ], [ 126.757861590876374, 37.558890464597148 ], [ 126.759208028237154, 37.560700201310802 ], [ 126.759283289490455, 37.560774683891893 ], [ 126.760477311770856, 37.561536761818104 ], [ 126.760892548801323, 37.562130641635896 ], [ 126.76278548518161, 37.563551054835678 ], [ 126.765026774731879, 37.564310925186284 ], [ 126.765177533045289, 37.564336561211412 ], [ 126.765207233442567, 37.564341550345027 ], [ 126.765367009123082, 37.56436806005722 ], [ 126.765375352005734, 37.564317776985774 ], [ 126.766956103605864, 37.564344584652794 ], [ 126.767089512230584, 37.564491247128814 ], [ 126.767447516854787, 37.564694126480553 ], [ 126.767520835367662, 37.564792699545571 ], [ 126.767706018873668, 37.564921800268941 ], [ 126.767703323507945, 37.564937502873534 ], [ 126.767450513951118, 37.565596178367223 ], [ 126.767298307925017, 37.567201788947415 ], [ 126.767274155564294, 37.567200454240876 ], [ 126.767270047805184, 37.567274786745273 ], [ 126.767277897969791, 37.567417092118319 ], [ 126.767258611705898, 37.56762054154909 ], [ 126.767267841543216, 37.567842994824929 ], [ 126.767301315942461, 37.567841605934348 ], [ 126.767361005407139, 37.568923638217115 ], [ 126.76736429610412, 37.568943349111215 ], [ 126.768362333472567, 37.571619262566671 ], [ 126.770120061148106, 37.573543808265462 ], [ 126.770096763910288, 37.57357183118787 ], [ 126.770351453025725, 37.573783570449237 ], [ 126.770421981748953, 37.573842595804422 ], [ 126.770436643088388, 37.573854834144498 ], [ 126.770583072374151, 37.573976747861927 ], [ 126.771794560722114, 37.574724246717466 ], [ 126.771777228004268, 37.574754955346357 ], [ 126.771843795625244, 37.574792527775784 ], [ 126.772005554230603, 37.574854431548701 ], [ 126.772382877687761, 37.575087243406003 ], [ 126.773216738880862, 37.575317942589606 ], [ 126.773914487188279, 37.57558496549499 ], [ 126.774270570654494, 37.575609499663912 ], [ 126.774421137268007, 37.575651155991252 ], [ 126.77450298805806, 37.575661728137952 ], [ 126.774507624446102, 37.575625832682206 ], [ 126.775141324502258, 37.575669494648288 ], [ 126.775466753981419, 37.576592987979097 ], [ 126.775500160517623, 37.576658092210586 ], [ 126.775928398592569, 37.577388068917308 ], [ 126.776061353784755, 37.577587938257395 ], [ 126.776079296088511, 37.577576002847771 ], [ 126.776359763079668, 37.578042001473733 ], [ 126.776412094972414, 37.578111645694399 ], [ 126.778011801107681, 37.579682664252061 ], [ 126.779835659986858, 37.580623566747846 ], [ 126.779831409763219, 37.580633619504681 ], [ 126.779897801431019, 37.58066168936061 ], [ 126.779982316008628, 37.580699224474699 ], [ 126.780004404209265, 37.580710619458898 ], [ 126.780019385737262, 37.58071568810184 ], [ 126.780249425532119, 37.580817854736161 ], [ 126.780696963333085, 37.580991072532875 ], [ 126.780738556494612, 37.581014348759489 ], [ 126.781484639543095, 37.581358605380046 ], [ 126.781484606782783, 37.581358675336581 ], [ 126.781571974500338, 37.581399589215529 ], ')||
to_clob('[ 126.781667106048246, 37.581451298976539 ], [ 126.783098379348516, 37.582042730418266 ], [ 126.783315153890854, 37.582274980824465 ], [ 126.783479403465662, 37.582443527377926 ], [ 126.783619794055895, 37.582590509240561 ], [ 126.783893476809382, 37.583702027684083 ], [ 126.783914752222898, 37.583749088064039 ], [ 126.784464550707014, 37.584753150793205 ], [ 126.784533593395579, 37.584859139745866 ], [ 126.785267516911901, 37.585677368168945 ], [ 126.785611038695023, 37.586243819119268 ], [ 126.786366837842479, 37.586902014736722 ], [ 126.786410546550769, 37.587132248549487 ], [ 126.787666947726962, 37.589306372467831 ], [ 126.789570569111305, 37.590943926849498 ], [ 126.790927336961374, 37.59147644186308 ], [ 126.790505202154421, 37.592375352392089 ], [ 126.790481331350833, 37.592438100611886 ], [ 126.790273836356874, 37.593065383687239 ], [ 126.790257932074766, 37.593121667608152 ], [ 126.790196319879939, 37.593353855906386 ], [ 126.790173959681525, 37.593443915510612 ], [ 126.790011039737919, 37.594319599768511 ], [ 126.790003075605455, 37.594383222399159 ], [ 126.789974070476006, 37.594655042883076 ], [ 126.78997133628279, 37.594686004926928 ], [ 126.789968450611298, 37.594748341828918 ], [ 126.78995480484862, 37.594817174725627 ], [ 126.789951703230003, 37.59483465531374 ], [ 126.789940240448402, 37.594888405899177 ], [ 126.789916742912794, 37.59500493434409 ], [ 126.789872738472539, 37.595242914114337 ], [ 126.789865728634368, 37.595284572419686 ], [ 126.789861985188651, 37.59530702730202 ], [ 126.789849573077902, 37.595382183792246 ], [ 126.789835792918879, 37.595468768961084 ], [ 126.78982173878876, 37.595560527712117 ], [ 126.789823941153941, 37.595560865035004 ], [ 126.789816295863403, 37.595604536557062 ], [ 126.789805645943417, 37.595666919537535 ], [ 126.789791082375729, 37.595754451789482 ], [ 126.789766399728691, 37.595913300354027 ], [ 126.789757373853803, 37.59597579488166 ], [ 126.789727930917408, 37.596221454444525 ], [ 126.789716182919562, 37.596288088643838 ], [ 126.789681483978541, 37.596503115059413 ], [ 126.789670844952568, 37.596575733819925 ], [ 126.789648500547699, 37.596741048205175 ], [ 126.789639086501964, 37.596817056778569 ], [ 126.789716240086364, 37.599150456128577 ], [ 126.79041240920111, 37.601083907611425 ], [ 126.790634968494004, 37.601956883318799 ], [ 126.790645503631197, 37.601984489583494 ], [ 126.790680034044939, 37.602073276116755 ], [ 126.79069234753122, 37.60210435156457 ], [ 126.790717234953306, 37.602176884891307 ], [ 126.790784124126304, 37.60236845897419 ], [ 126.791151548093481, 37.603239895786295 ], [ 126.791209796917244, 37.603356844614346 ], [ 126.791531158372209, 37.603936389809462 ], [ 126.791559873068209, 37.603983173265739 ], [ 126.791749477312592, 37.604276536528346 ], [ 126.791850275957799, 37.604424804717127 ], [ 126.792179137132734, 37.604872000175078 ], [ 126.792248090387062, 37.604958838519892 ], [ 126.793361570175506, 37.606073990235465 ], [ 126.794774185460767, 37.607981322873499 ], [ 126.795212584722236, 37.608397936810903 ], [ 126.795236604141763, 37.60842066208086 ], [ 126.795898937724957, 37.609044548330452 ], [ 126.796323728812098, 37.609446986194911 ], [ 126.796390300210561, 37.609509291020828 ], [ 126.796585022328728, 37.609689325461687 ], [ 126.796953885779388, 37.610035615088258 ], [ 126.797167971012087, 37.610237174843462 ], [ 126.797438542623169, 37.610492049001039 ], [ 126.799614350602084, 37.611921023180521 ], [ 126.802147547340482, 37.612520207502229 ], [ 126.80473297348567, 37.612217421745441 ], [ 126.807059177914724, 37.611049140734288 ], [ 126.807355453048416, 37.610828620054761 ], [ 126.807378880918847, 37.61081111135509 ], [ 126.807862598670113, 37.610448135254103 ], [ 126.80837290601373, 37.610066889302203 ], [ 126.808385781293069, 37.610057248769373 ], [ 126.808908563290956, 37.60966493337871 ], [ 126.809315699962696, 37.60936245162663 ], [ 126.809323933151106, 37.609356326042096 ], ')
, NULL, 4326))