{"id":10500,"date":"2020-10-16T15:12:18","date_gmt":"2020-10-16T06:12:18","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=10500"},"modified":"2022-09-18T15:06:13","modified_gmt":"2022-09-18T06:06:13","slug":"%ec%9e%98%eb%aa%bb%eb%90%9c-geometry%eb%a5%bc-%ec%88%98%ec%a0%95%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=10500","title":{"rendered":"\uc798\ubabb\ub41c Geometry\ub97c \uc218\uc815\ud558\uae30"},"content":{"rendered":"<p>PostGIS\uc758 \uacf5\uac04 \ud568\uc218 \uc911 ST_MakeValid\ub294 \uc774\ubbf8 \uc800\uc7a5\ub41c \uc62c\ubc14\ub974\uc9c0 \ubabb\ud55c Geometry\ub97c \uc218\uc815\ud574 \uc900\ub2e4. \uc544\ub798\uc758 \ucffc\ub9ac\ub294 \uc774\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nselect ST_IsValid(the_geom) from sify_li;\r\nupdate sify_li set the_geom = ST_MakeValid(the_geom);\r\n<\/pre>\n<p>\uc704\uc758 SQL \uad6c\ubb38 \uc911 sify_li\ub294 Table \uc774\ub984\uc774\uba70 the_geom\uc740 Geometry \ud0c0\uc785\uc5d0 \ub300\ud55c \ud544\ub4dc\uba85\uc5d0 \ub300\ud55c \uc608\uc2dc\uc774\ub2e4.<\/p>\n<p>\uba40\ud2f0 \ud3f4\ub9ac\uace4\uc758 \uacbd\uc6b0 \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370 \uc544\ub798\uc758 SQL\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ud574\uacb0\ub418\ub294 \uacbd\uc6b0\uac00 \uc788\uc74c<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nupdate sig set the_geom = st_multi(st_collectionextract(st_makevalid(the_geom),3)) where not st_isvalid(the_geom);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PostGIS\uc758 \uacf5\uac04 \ud568\uc218 \uc911 ST_MakeValid\ub294 \uc774\ubbf8 \uc800\uc7a5\ub41c \uc62c\ubc14\ub974\uc9c0 \ubabb\ud55c Geometry\ub97c \uc218\uc815\ud574 \uc900\ub2e4. \uc544\ub798\uc758 \ucffc\ub9ac\ub294 \uc774\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4. select ST_IsValid(the_geom) from sify_li; update sify_li set the_geom = ST_MakeValid(the_geom); \uc704\uc758 SQL \uad6c\ubb38 \uc911 sify_li\ub294 Table \uc774\ub984\uc774\uba70 the_geom\uc740 Geometry \ud0c0\uc785\uc5d0 \ub300\ud55c \ud544\ub4dc\uba85\uc5d0 \ub300\ud55c \uc608\uc2dc\uc774\ub2e4. \uba40\ud2f0 \ud3f4\ub9ac\uace4\uc758 \uacbd\uc6b0 \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370 \uc544\ub798\uc758 SQL\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ud574\uacb0\ub418\ub294 \uacbd\uc6b0\uac00 \uc788\uc74c update sig &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=10500\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;\uc798\ubabb\ub41c Geometry\ub97c \uc218\uc815\ud558\uae30&#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-10500","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\/10500","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=10500"}],"version-history":[{"count":8,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/10500\/revisions"}],"predecessor-version":[{"id":12793,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/10500\/revisions\/12793"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10500"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}