{"id":2012,"date":"2014-03-13T07:09:20","date_gmt":"2014-03-13T07:09:20","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2012"},"modified":"2017-01-27T11:04:29","modified_gmt":"2017-01-27T02:04:29","slug":"oracle-spatial-sql-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2012","title":{"rendered":"Oracle Spatial SQL \uc815\ub9ac"},"content":{"rendered":"<p>\uacf5\uac04\uc11c\ubc84\uc5d0 Spatial \uc624\ub77c\ud074\uc744 \uc9c0\uc6d0\ud558\uba74\uc11c \ud30c\uc545\ud55c SQL\ubb38\uc744 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uba3c\uc800 \uc624\ub77c\ud074\uc5d0 \uc815\uc758\ub41c Spatial Table\uc758 \uc804\uccb4 MBR\uc744 \uc5bb\ub294 SQL \ubb38\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nSELECT \r\n    SDO_AGGR_MBR(geometry) \r\nFROM {SCHEMA}.{TABLE};\r\n<\/pre>\n<p>\uc774 SDO_AGGR_MBR\uc740 \ub808\ucf54\ub4dc \ud558\ub098 \ud558\ub098\uc5d0 \ub300\ud55c \uc9c0\uc624\uba54\ud2b8\ub9ac\uc758 MBR\uc744 \uc5bb\uc5b4 \ud569\ud558\ub294 \ubc29\uc2dd \uac19\ub2e4\ub294 \uc0dd\uac01\uc73c\ub85c \uc0c1\ub2f9\ud788 \ube44\ud6a8\uc728\uc801\uc778 \uad6c\ubb38\uac19\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \ud55c\ubc88\uc5d0 MBR\uc744 \uc5bb\ub294 \ubc29\ubc95\uc774 \uc788\uc744\ub4ef\ud558\ub2c8 \ucd94\ud6c4\uc5d0 \ud30c\uc545\ud574 \ubcf4\ub835\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud544\ub4dc\uba85\uacfc \ud544\ub4dc \ud0c0\uc785\uc744 \uc5bb\ub294 SQL \ubb38\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nSELECT \r\n    COLUMN_NAME, DATA_TYPE \r\nFROM \r\n    ALL_TAB_COLUMNS \r\nWHERE \r\n    OWNER='{SCHEMA}' AND TABLE_NAME='{TABLE}';\r\n<\/pre>\n<p>\ub2e4\uc74c\uc740 \uc9c0\uc815\ub41c MBR\uc5d0 \ub300\ud574 \uc911\ucca9\ub41c \uc9c0\uc624\uba54\ud2b8\ub9ac\ub9cc\uc744 \uac80\uc0c9\ud574 \uc8fc\ub294 SQL \ubb38\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nSELECT \r\n    GEOMETRY \r\nFROM \r\n    {SCHEMA}.{TABLE}\r\nWHERE \r\n    SDO_ANYINTERACT(\r\n        GEOMETRY, \r\n        SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), \r\n        SDO_ORDINATE_ARRAY({MinX},{MinY},{MaxX},{MaxY))\r\n    ) = 'TRUE';\r\n<\/pre>\n<p>\uc774 SQL \ubb38\uc740 \uc2e4\uc6b4\uc601\ub418\ub294 \uc624\ub77c\ud074 \uc11c\ubc84\uc5d0\uc11c \uac04\ub2e8\ud788 \ud14c\uc2a4\ud2b8\ub294 \ud588\ub294\ub370 \uc880\ub354 \ub2e4\uc591\ud55c \ud658\uacbd\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ud574 \ubcfc \ud544\uc694\uac00 \uc788\uc744\ub4ef\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc624\ub77c\ud074\uc740 \uacf5\uac04DB\uc5d0 \ub300\ud574\uc11c \uc77c\ubc18\uc801\uc778 GIS\uc758 Simple Feature \uc815\uc758\ub97c \ub530\ub974\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud558\ub098\uc758 \ud14c\uc774\ube14\uc5d0 \ud3f4\ub9ac\uace4, \ud3ec\uc778\ud2b8, \ucee4\ube0c\uc774 \uc11e\uc5ec \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ucee4\ube0c(Curve)\ub294 GIS\uc5d0\uc11c \ud754\ud788 \ub9d0\ud558\ub294 \ud3f4\ub9ac\ub77c\uc778\uc774\ub098 \ub77c\uc778\uc2a4\ud2b8\ub9c1\uc744 \ud3ec\ud568\ud558\ub294 \uac83\uc73c\ub85c \ud638(Arc)\uc640 \uac19\uc740 \ud45c\ud604\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/p>\n<p>\ub610\ud55c \ud558\ub098\uc758 Geometry\uc5d0 \ub300\ud574\uc11c\ub3c4 \ucee4\ube0c\uc640 \ud3ec\uc778\ud2b8 \uadf8\ub9ac\uace0 \ud3f4\ub9ac\uace4\uc774 \uc11e\uc5ec \uc788\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub3c4\ud615\uc758 \ud68c\uc804\uc744 \uc704\ud55c \ub9e4\ud2b8\ub9ad\uc2a4 \uc815\ubcf4\uac00 \uc88c\ud45c\uac12\uc744 \ub2f4\ub294 \uad6c\uc870\uccb4\uc5d0 \uc874\uc7ac\ud569\ub2c8\ub2e4. <\/p>\n<p>\uc624\ub77c\ud074\uc758 \uacf5\uac04DB \uad6c\uc870&#8230; \uba85\ud655\ud558\uace0 \uc2ec\ud50c\ud55c GIS \ubd84\uc57c\uc5d0\uc11c\ub294 \ub9cc\ub9cc\uce58 \uc54a\ub294 \ub188\uc774\ub124\uc694. \uc544\uc9c1 \uc815\ub9ac\ub418\uc9c0 \uc54a\ub294 \uae00\uc778\ub370 \uba38\ub9ac\uac00 \uc544\ud30c \uc870\uae08\uc774\ub77c\ub3c4 \uc815\ub9ac\ub97c \ud574\ubcf4\uace0\uc790 \uae00\uc744 \ub0a8\uaca8\ubd05\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uacf5\uac04\uc11c\ubc84\uc5d0 Spatial \uc624\ub77c\ud074\uc744 \uc9c0\uc6d0\ud558\uba74\uc11c \ud30c\uc545\ud55c SQL\ubb38\uc744 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uba3c\uc800 \uc624\ub77c\ud074\uc5d0 \uc815\uc758\ub41c Spatial Table\uc758 \uc804\uccb4 MBR\uc744 \uc5bb\ub294 SQL \ubb38\uc785\ub2c8\ub2e4. SELECT SDO_AGGR_MBR(geometry) FROM {SCHEMA}.{TABLE}; \uc774 SDO_AGGR_MBR\uc740 \ub808\ucf54\ub4dc \ud558\ub098 \ud558\ub098\uc5d0 \ub300\ud55c \uc9c0\uc624\uba54\ud2b8\ub9ac\uc758 MBR\uc744 \uc5bb\uc5b4 \ud569\ud558\ub294 \ubc29\uc2dd \uac19\ub2e4\ub294 \uc0dd\uac01\uc73c\ub85c \uc0c1\ub2f9\ud788 \ube44\ud6a8\uc728\uc801\uc778 \uad6c\ubb38\uac19\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \ud55c\ubc88\uc5d0 MBR\uc744 \uc5bb\ub294 \ubc29\ubc95\uc774 \uc788\uc744\ub4ef\ud558\ub2c8 \ucd94\ud6c4\uc5d0 \ud30c\uc545\ud574 \ubcf4\ub835\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud544\ub4dc\uba85\uacfc \ud544\ub4dc \ud0c0\uc785\uc744 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2012\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;Oracle Spatial SQL \uc815\ub9ac&#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":[],"class_list":["post-2012","post","type-post","status-publish","format-standard","hentry","category-gis-working-history"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2012","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=2012"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2012\/revisions"}],"predecessor-version":[{"id":2880,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2012\/revisions\/2880"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2012"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}