{"id":2018,"date":"2014-03-21T02:57:23","date_gmt":"2014-03-21T02:57:23","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2018"},"modified":"2017-01-27T11:02:41","modified_gmt":"2017-01-27T02:02:41","slug":"oracle-spatial-geometry-type-%eb%b0%8f-spatial-table-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2018","title":{"rendered":"Oracle Spatial Geometry Type \ubc0f Spatial Table \uc0dd\uc131"},"content":{"rendered":"<p>[\ucd9c\ucc98] \uc774 \uae00\uc740 \uc624\ub77c\ud074\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Oracle Spatial User.s Guide\ub97c \ucc38\uace0\ub85c \ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc624\ub77c\ud074\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \uc9c0\uc624\uba54\ud2b8\ub9ac\ub294 \ucd1d 9\uac00\uc9c0\ub85c Point, LineString, Polygon, Arc Line Stringm Arc Polygon, Compound Polygon, Compound Line String, Circle, Rectangle\ub85c \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1228634491.png\" width=\"510\" height=\"399\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" title=\"\" \/><\/p>\n<p>\uc774 \uc911 Point, Line String, Polygon\uc740 GIS\uc758 Simple Feature \uc815\uc758\ub97c \ub530\ub974\ub294 \uac83\uc740 Point, Line String, Polygon\uc785\ub2c8\ub2e4. \uc624\ub77c\ud074\uc5d0\uc11c\ub294 Line String\uc744 \uad6c\uc131\ud558\ub294 \uc120\ubd84\uc758 \uad50\ucc28\ub97c \ud5c8\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uacf5\uac04 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 SQL \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uacf5\uac04 \ub370\uc774\ud130\ub294 \ub3c4\ud615\uacfc \uc18d\uc131\uc73c\ub85c \uad6c\uc131\ub418\ub294 \ud53c\uccd0(Feature) \uc774\ubbc0\ub85c \uc608\ub97c\ub4e4\uc5b4 \ud14c\uc774\ube14\uba85\uc774 cola_markets\ub77c\uace0 \ud560\ub54c \ub3c4\ud615\uc5d0 \ub300\ud55c \ud544\ub4dc\uba85\uc740 shape\uc774\uba70  SDO_GEOMETRY \ud0c0\uc785\uc73c\ub85c \uc815\uc758\ub418\uba70 \uc18d\uc131\uc740 \uc608\ub97c \ub4e4\uc5b4 mkt_id\uc640 name\uc774\ub77c\ub294 \ud544\ub4dc\uba85\uc73c\ub85c\uc368 \uac01\uac01 NUMBER\uc640 VARCHAR2 \ud0c0\uc785\uc73c\ub85c \uc815\uc758\ud55c\ub2e4\uace0 \ud560\ub54c \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nCREATE TABLE cola_markets \r\n(\r\n  mkt_id NUMBER PRIMARY KEY,\r\n  name VARCHAR2(32),\r\n  shape SDO_GEOMETRY\r\n);\r\n<\/pre>\n<p>\uc774\ub807\uac8c \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc5d0 \ud558\ub098\uc758 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\ub294 SQL \ubb38\uc758 \uc608\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nINSERT INTO cola_markets VALUES\r\n(\r\n  1,\r\n  'cola_a',\r\n  SDO_GEOMETRY(\r\n    2003, -- 2\ucc28\uc6d0\uc758 \ud3f4\ub9ac\uace4\r\n    NULL,\r\n    NULL,\r\n    SDO_ELEM_INFO_ARRAY(1,1003,3), -- 1\uac1c\uc758 \uc0ac\uac01\ud615(1003 = exterior)\r\n    SDO_ORDINATE_ARRAY(1,1, 5,7) -- \uc0ac\uac01\ud615\uc744 \uc815\uc758\ud558\uae30 \uc704\ud574 \uc624\uc9c1 2\uac1c\uc758 \ud3ec\uc778\ud2b8 \ud544\uc694\r\n  )\r\n);\r\n<\/pre>\n<p>\ub2e4\uc74c\uc740 \ub610 \ub2e4\ub978 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\ub294 \uc608\ub85c, \ub3c4\ud615\uc758 \ud0c0\uc785\uc774 Polygon\uc778 SQL \ubb38\uc758 \uc608\uc785\ub2c8\ub2e4. <\/p>\n<pre>\r\nINSERT INTO cola_markets VALUES\r\n(\r\n  3,\r\n  'cola_c',\r\n  SDO_GEOMETRY(\r\n    2003,\r\n    NULL,\r\n    NULL,\r\n    SDO_ELEM_INFO_ARRAY(1,1003,1), -- 1\uac1c\uc758 \ud3f4\ub9ac\uace4\r\n    SDO_ORDINATE_ARRAY(3,3, 6,3, 6,5, 4,5, 3,3)\r\n  )\r\n);\r\n<\/pre>\n<p>\ub2e4\uc74c\uc740 \ub610 \ub2e4\ub978 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\ub294 \uc608\ub85c\uc368, \ub3c4\ud615\uc758 \ud0c0\uc785\uc774 \uc6d0(Circle)\uc778 SQL \ubb38\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nINSERT INTO cola_markets VALUES\r\n(\r\n  4,\r\n  'cola_d',\r\n  SDO_GEOMETRY(\r\n     2003,\r\n     NULL,\r\n     NULL,\r\n     SDO_ELEM_INFO_ARRAY(1,1003,4), -- 1\uac1c\uc758 \uc6d0\r\n     SDO_ORDINATE_ARRAY(8,7, 10,9, 8,11) -- 1\uac1c\uc758 \uc6d0\uc740 \ucd5c\uc18c 3\uac1c\uc758 \uc810\uc73c\ub85c \uc815\uc758\ub428\r\n  )\r\n);\r\n<\/pre>\n<p>\uacf5\uac04 \ud14c\uc774\ube14\uc740 R-Tree \ub4f1\uacfc \uac19\uc740 \uacf5\uac04 \uc778\ub371\uc2f1\uc774 \uc801\uc6a9\ub418\uc5b4\uc838\uc57c \ube60\ub978 \uacf5\uac04 \uac80\uc0c9 \ub4f1\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc544\ub798\ub294 \uc55e\uc11c \uc0dd\uc131\ud55c \uacf5\uac04 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \uacf5\uac04 \uc778\ub371\uc2f1\uc744 \uc0dd\uc131\ud574 \uc8fc\ub294 SQL \ubb38\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nINSERT INTO user_sdo_geom_metadata\r\n(\r\n  TABLE_NAME,\r\n  COLUMN_NAME,\r\n  DIMINFO,\r\n  SRID\r\n)\r\nVALUES \r\n(\r\n  'cola_markets',\r\n  'shape',\r\n  SDO_DIM_ARRAY -- 20 X 20 \uadf8\ub9ac\ub4dc\r\n  ( \r\n    SDO_DIM_ELEMENT('X', 0, 20, 0.005),\r\n    SDO_DIM_ELEMENT('Y', 0, 20, 0.005)\r\n  ),\r\n  NULL -- SRID\r\n);\r\n\r\nCREATE INDEX cola_spatial_idx\r\nON cola_markets(shape) INDEXTYPE IS MDSYS.SPATIAL_INDEX;\r\n<\/pre>\n<p>\uc774\uc81c \uc774\ub807\uac8c \uacf5\uac04 \uc778\ub371\uc2f1\uc774 \uc801\uc6a9\ub41c \uacf5\uac04 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \ub2e4\uc591\ud55c \uacf5\uac04 \uc5f0\uc0b0\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc73c\uba70 \uc544\ub798\uc758 \uc608\uc640 \uac19\uc740 SQL\ubb38\uc744 \ud1b5\ud574 \uacf5\uac04 \uc5f0\uc0b0\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\n-- 2\uac1c\uc758 \ub3c4\ud615\uacfc \uad50\ucc28\ud558\ub294 \ub3c4\ud615 \uc5bb\uae30\r\nSELECT SDO_GEOM.SDO_INTERSECTION(c_a.shape, c_c.shape, 0.005)\r\nFROM cola_markets c_a, cola_markets c_c\r\nWHERE c_a.name = 'cola_a' AND c_c.name = 'cola_c';\r\n\r\n-- 2\uac1c\uc758 \ub3c4\ud615(\uc9c0\uc624\uba54\ud2b8\ub9ac, Geometry)\uc5d0 \ub300\ud55c \uacf5\uac04\uad00\uacc4 \uc5f0\uc0b0\uc758 \uacb0\uacfc \uc5bb\uae30\r\nSELECT SDO_GEOM.RELATE(c_b.shape, 'anyinteract', c_d.shape, 0.005)\r\nFROM cola_markets c_b, cola_markets c_d\r\nWHERE c_b.name = 'cola_b' AND c_d.name = 'cola_d';\r\n\r\n-- \ud574\ub2f9 \uacf5\uac04 \ud14c\uc774\ube14\uc758 \uc804\uccb4 \uba74\uc801 \uc5bb\uae30\r\nSELECT name, SDO_GEOM.SDO_AREA(shape, 0.005) FROM cola_markets;\r\n\r\n-- \ud2b9\uc815 \ub3c4\ud615\uc5d0 \ub300\ud55c \uba74\uc801 \uc5bb\uae30\r\nSELECT c.name, SDO_GEOM.SDO_AREA(c.shape, 0.005) FROM cola_markets c\r\nWHERE c.name = 'cola_a';\r\n\r\n-- 2\uac1c\uc758 \ub3c4\ud615 \uac04\uc758 \uac70\ub9ac \uc5bb\uae30\r\nSELECT SDO_GEOM.SDO_DISTANCE(c_b.shape, c_d.shape, 0.005)\r\nFROM cola_markets c_b, cola_markets c_d\r\nWHERE c_b.name = 'cola_b' AND c_d.name = 'cola_d';\r\n\r\n-- \ud2b9\uc815 \uc9c0\uc624\uba54\ud2b8\ub9ac\uac00 \uc633\ubc14\ub978\uac00?\r\nSELECT c.name, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.shape, 0.005)\r\nFROM cola_markets c WHERE c.name = 'cola_c';\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>[\ucd9c\ucc98] \uc774 \uae00\uc740 \uc624\ub77c\ud074\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Oracle Spatial User.s Guide\ub97c \ucc38\uace0\ub85c \ud558\uc600\uc2b5\ub2c8\ub2e4. \uc624\ub77c\ud074\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \uc9c0\uc624\uba54\ud2b8\ub9ac\ub294 \ucd1d 9\uac00\uc9c0\ub85c Point, LineString, Polygon, Arc Line Stringm Arc Polygon, Compound Polygon, Compound Line String, Circle, Rectangle\ub85c \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc774 \uc911 Point, Line String, Polygon\uc740 GIS\uc758 Simple Feature \uc815\uc758\ub97c \ub530\ub974\ub294 \uac83\uc740 Point, Line String, Polygon\uc785\ub2c8\ub2e4. \uc624\ub77c\ud074\uc5d0\uc11c\ub294 Line String\uc744 \uad6c\uc131\ud558\ub294 \uc120\ubd84\uc758 \uad50\ucc28\ub97c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2018\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;Oracle Spatial Geometry Type \ubc0f Spatial Table \uc0dd\uc131&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[5,101],"class_list":["post-2018","post","type-post","status-publish","format-standard","hentry","category-gis-working-history","tag-gis","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2018"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2018\/revisions"}],"predecessor-version":[{"id":2877,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2018\/revisions\/2877"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2018"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}