{"id":9163,"date":"2020-04-29T13:41:57","date_gmt":"2020-04-29T04:41:57","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=9163"},"modified":"2020-05-28T09:30:18","modified_gmt":"2020-05-28T00:30:18","slug":"dbms%ec%97%90%ec%84%9c-st_extent-%ed%95%a8%ec%88%98%eb%a5%bc-%ec%a0%9c%ea%b3%b5%ed%95%98%ec%a7%80-%ec%95%8a%ec%9d%84-%ea%b2%bd%ec%9a%b0%ec%9d%98-%eb%8c%80%ec%95%88","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=9163","title":{"rendered":"DBMS\uc5d0\uc11c ST_EXTENT \ud568\uc218\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc758 \ub300\uc548"},"content":{"rendered":"<p>PostgreSQL \ub4f1\uacfc \uac19\uc740 \uacf5\uac04 DB\uc5d0\uc11c\ub294 ST_EXTENT\ub97c \uc9c0\uc6d0\ud558\uc9c0\ub9cc, \uc624\ub77c\ud074\uc774\ub098 \ud2f0\ubca0\ub85c \ub4f1\uacfc \uac19\uc740 DBMS\uc5d0\uc11c\ub294 \uc774 \ud568\uc218\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\ud589\uc774 \uc624\ub77c\ud074\uc740 SDO_AGGR_MBR\ub77c\ub294 \ud568\uc218\ub97c \uc81c\uacf5\ud568\uc73c\ub85c\uc368 ST_EXTENT \ub300\uc2e0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\ucd5c\uadfc\uc758 \uc624\ub77c\ud074\uc740 ST_EXTENT\ub97c \uc9c0\uc6d0\ud560\uc9c0\ub3c4 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4) \uadf8\ub7ec\ub098 \uc624\ub77c\ud074\ucc98\ub7fc \uc790\uccb4\uc801\uc778 \ud568\uc218 \uc870\ucc28\ub3c4 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \ud2f0\ubca0\ub85c\uc640 \uac19\uc740 \uacbd\uc6b0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub300\uc548\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT * \r\nFROM \r\n    (SELECT * FROM (SELECT ST_MINX(the_geom) MinX FROM TSTTABLE ORDER BY ST_MINX(the_geom) ASC) WHERE ROWNUM = 1 ), \r\n    (SELECT * FROM (SELECT ST_MAXX(the_geom) MaxX FROM TSTTABLE ORDER BY ST_MAXX(the_geom) DESC) WHERE ROWNUM = 1),\r\n    (SELECT * FROM (SELECT ST_MINY(the_geom) MinY FROM TSTTABLE ORDER BY ST_MINY(the_geom) ASC) WHERE ROWNUM = 1),\r\n    (SELECT * FROM (SELECT ST_MAXY(the_geom) MaxY FROM TSTTABLE ORDER BY ST_MAXY(the_geom) DESC) WHERE ROWNUM = 1);\r\n<\/pre>\n<p>\ub300\uc0c1 \ud14c\uc774\ube14\uc758 \uc774\ub984\uc740 TSTTABLE\uc774\uace0 Geometry \ud544\ub4dc\ub294 the_gem\uc785\ub2c8\ub2e4. \uacb0\uacfc\uc758 \uc608\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/2020\/04\/st_extent_.png\" alt=\"\" width=\"1165\" height=\"256\" class=\"aligncenter size-full wp-image-9164\" \/><\/p>\n<p>\uc704\uc758 \ucffc\ub9ac\ub294 \ud2f0\ubca0\ub85c\uc5d0\uc11c \uc2e4\ud589\ud55c \uacb0\uacfc\uc785\ub2c8\ub2e4. \uc704\ucc98\ub7fc \ud558\ub098\uc758 Row\ub85c \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218\ub3c4 \uc788\uc9c0\ub9cc MinX, MaxX, MinY, MaxY \uac01\uac01\uc744 \ud558\ub098\uc758 Row\ub85c \uc5bb\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798\ucc98\ub7fc\uc694.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT * FROM (SELECT ST_MINX(the_geom) FROM TSTTABLE  ORDER BY ST_MINX(the_geom) ASC) WHERE ROWNUM = 1 \r\nUNION SELECT * FROM (SELECT ST_MAXX(the_geom) FROM TSTTABLE  ORDER BY ST_MAXX(the_geom) DESC) WHERE ROWNUM = 1\r\nUNION SELECT * FROM (SELECT ST_MINY(the_geom) FROM TSTTABLE  ORDER BY ST_MINY(the_geom) ASC) WHERE ROWNUM = 1\r\nUNION SELECT * FROM (SELECT ST_MAXY(the_geom) FROM TSTTABLE  ORDER BY ST_MAXY(the_geom) DESC) WHERE ROWNUM = 1;\r\n<\/pre>\n<p>\ucc38\uace0\ub85c \uc774 \ub300\uc548\ub4e4\uc740 \uc18d\ub3c4\uac00 \ub290\ub9bd\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130\uac00 \uac1c\uc218\uac00 \ub9ce\uc744 \uc218\ub85d \uadf8 \uc18d\ub3c4\ub294 \ub354\uc6b1 \ub290\ub824\uc9d1\ub2c8\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \ud574\ub2f9 DBMS\uc5d0\uc11c ST_EXTENT\ub97c \uc81c\uacf5\ud55c\ub2e4\uba74, ST_EXTENT\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\uba70 ST_EXTENT\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 \ud574\ub2f9 DBMS\uc5d0\uc11c \uc790\uccb4\uc801\uc778 \ubc29\ubc95\uc744 \uc81c\uacf5\ud558\ub294\uc9c0 \ud655\uc778\ud558\uc5ec \uadf8 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \uc790\uccb4\uc801\uc778 \ubc29\ubc95\uae4c\uc9c0\ub3c4 \uc5c6\ub2e4\uba74 \uc704\uc758 \ub300\uc548\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \ub4f1\uacfc \uac19\uc740 \uacf5\uac04 DB\uc5d0\uc11c\ub294 ST_EXTENT\ub97c \uc9c0\uc6d0\ud558\uc9c0\ub9cc, \uc624\ub77c\ud074\uc774\ub098 \ud2f0\ubca0\ub85c \ub4f1\uacfc \uac19\uc740 DBMS\uc5d0\uc11c\ub294 \uc774 \ud568\uc218\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\ud589\uc774 \uc624\ub77c\ud074\uc740 SDO_AGGR_MBR\ub77c\ub294 \ud568\uc218\ub97c \uc81c\uacf5\ud568\uc73c\ub85c\uc368 ST_EXTENT \ub300\uc2e0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\ucd5c\uadfc\uc758 \uc624\ub77c\ud074\uc740 ST_EXTENT\ub97c \uc9c0\uc6d0\ud560\uc9c0\ub3c4 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4) \uadf8\ub7ec\ub098 \uc624\ub77c\ud074\ucc98\ub7fc \uc790\uccb4\uc801\uc778 \ud568\uc218 \uc870\ucc28\ub3c4 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \ud2f0\ubca0\ub85c\uc640 \uac19\uc740 \uacbd\uc6b0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub300\uc548\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. SELECT * FROM (SELECT * FROM (SELECT ST_MINX(the_geom) &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=9163\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;DBMS\uc5d0\uc11c ST_EXTENT \ud568\uc218\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc758 \ub300\uc548&#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-9163","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\/9163","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=9163"}],"version-history":[{"count":6,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9163\/revisions"}],"predecessor-version":[{"id":9319,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9163\/revisions\/9319"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9163"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}