{"id":1258,"date":"2010-08-19T04:13:11","date_gmt":"2010-08-19T04:13:11","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1258"},"modified":"2017-01-28T13:40:42","modified_gmt":"2017-01-28T04:40:42","slug":"shp%ec%9d%84-sql-%eb%ac%b8%ec%9c%bc%eb%a1%9c-%eb%b3%80%ed%99%98%ed%95%b4-%ec%a3%bc%eb%8a%94-%ed%88%b4-shp2sql","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1258","title":{"rendered":"[GIS] SHP\uc744 SQL \ubb38\uc73c\ub85c \ubcc0\ud658\ud574 \uc8fc\ub294 \ud234 &#8211; SHP2SQL"},"content":{"rendered":"<p>SHP \ud30c\uc77c\uc758 \uc88c\ud45c \uc815\ubcf4\uc640 \uc18d\uc131 \uc815\ubcf4\ub97c DBMS\uc5d0 \ud14c\uc774\ube14 \uad6c\uc870\ub97c \uc0dd\uc131\ud558\uace0 \uac12\uc744 \ucd94\uac00\ud558\ub294\ub370 \ud544\uc694\ud55c SQL\ubb38\uc744 \uc0dd\uc131\ud574 \uc8fc\ub294 \ud234\uc785\ub2c8\ub2e4. \ud604\uc7ac\ub294 \ud3ec\uc778\ud2b8 \ud0c0\uc785\uc5d0 \ub300\ud55c SHP \ud30c\uc77c\uc5d0 \ub300\ud574\uc11c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \uc2e4\ud589 \ud654\uba74\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1204509391.png\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"350\" height=\"267\" \/><br \/>\n\uc704\uc758 UI \ud654\uba74\uc5d0\uc11c Export Fields\uc5d0 DBMS\ub85c \ub0b4\ubcf4\ub0b4\uace0\uc790 \ud558\ub294 \ud544\ub4dc\ub97c \uc120\ud0dd\ud558\uba74 \ub429\ub2c8\ub2e4.. \ud544\uc694\uc5c6\ub294 \ud544\ub4dc\uac12\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc81c\uc678\uc2dc\ucf1c\ub3c4 \ub429\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \uc774\uc6a9\ud574\uc11c DBMS\uc5d0 \ub530\ub77c \ud544\ub4dc\uba85\uc73c\ub85c\uc368 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \ud544\ub4dc\ub294 \uc774\uacf3\uc744 \ud1b5\ud574 \uc81c\uc678\uc2dc\ucf1c\uc904 \uc218 \ub3c4 \uc788\uc2b5\ub2c8\ub2e4.. \uc704\uc758 \ud654\uba74 \uc608\uc2dc\ucc98\ub7fc \uc785\ub825\uac12\ub4e4\uc744 \uc9c0\uc815\ud55c \ud6c4 \ubcc0\ud658 \ubc84\ud2bc\uc744 \ub204\ub974\uac8c \ub418\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 sql \ubb38\uc774 \ub2f4\uae34 \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc774 \ub9cc\ub4e4\uc5b4 \uc9d1\ub2c8\ub2e4..<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1052424549.png\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"510\" height=\"212\" \/><br \/>\n\ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc5d0 \uc18d\uc131\uac12\uc744 \ucd94\uac00\ud558\uae30 \uc704\ud55c Ansi SQL \uad6c\ubb38\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.. \uc774 \ub0b4\uc6a9\uc744 \uc218\uc815\ud574 \uc904 \ud544\uc694(\ud14c\uc774\ube14\uba85)\ub3c4 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.. \u00a0\uc774\ub807\uac8c \uc0dd\uc131\ub41c SQL \ud30c\uc77c\uc744 \uac01 DBMS\uc5d0\uc11c \ubd88\ub7ec\uc640 \uc2e4\ud589\ud574\uc8fc\uba74 \uac04\ub2e8\ud558\uac8c DBMS\uc5d0 SHP \ud30c\uc77c\uc5d0 \ub300\ud55c \ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.. MySQL\uc758 \uacbd\uc6b0 soruce \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574\uc11c \uc678\ubd80\uc758 sql \ubb38\uc774 \ub2f4\uae34 \ud30c\uc77c\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>\uc774 \ud234\uc758 \uc2e4\ud589\uc744 \uc704\ud574\uc11c\ub294 \ucd5c\uc2e0 \ubc84\uc804\uc758 \ub4c0\ub77c\ub9f5\uc744 \uc124\uce58\ud558\uc154\uc57c \ud569\ub2c8\ub2e4.<\/strong> \ub2e4\uc74c url\uc744 \ud1b5\ud574 \ub4c0\ub77c\ub9f5\uc744 \uc124\uce58\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n<p align='center'><a href=\"http:\/\/www.gisdeveloper.co.kr\/notice\/574\">http:\/\/www.gisdeveloper.co.kr\/notice\/574<\/a><\/p>\n<p>\uc18c\uc2a4 \ucf54\ub4dc\uc640 \ucef4\ud30c\uc77c\ub41c \uc2e4\ud589 \ud30c\uc77c \ubaa8\ub450\ub97c \uc81c\uacf5\ud574 \ub4dc\ub9ac\ub2c8.. \uac1c\ubc1c\uc790 \ubd84\uc774\ub77c\uba74 \ubaa9\uc801\uc5d0 \ub9de\uac8c \ucee4\uc2a4\ud130\ub9c8\uc9d5\ud574 \uc0ac\uc6a9\ud558\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4..<\/p>\n<p style='text-align:center'><a href=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1216137714.zip\"><img width='64' src='\/images\/download.svg' \/><\/a><a href=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1283726506.zip\"><img width='64' src='\/images\/download.svg' \/><\/a><\/p>\n<p>\uc544\ub798\uc758 \uc774\ubbf8\uc9c0\ub294 \uc704\uc5d0\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 sql \uad6c\ubb38\uc774 \ub2f4\uae34 text \ud30c\uc77c\uc744 MySQL\uc5d0\uc11c \uc2e4\ud589\uc2dc\ucf1c \ub9cc\ub4e4\uc5b4\uc9c4 \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud574 \ubcf8 \ud654\uba74\uc785\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1064511095.png\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"400\" height=\"347\" \/><br \/>\n\uc704\uc758 \uc774\ubbf8\uc9c0\ub97c \ubcf4\uc2dc\uba74.. X, Y \ud544\ub4dc\uba85\uc73c\ub85c POI\uc758 \uc88c\ud45c\uac00 \uc790\ub3d9\uc73c\ub85c \ucd94\uac00\ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SHP \ud30c\uc77c\uc758 \uc88c\ud45c \uc815\ubcf4\uc640 \uc18d\uc131 \uc815\ubcf4\ub97c DBMS\uc5d0 \ud14c\uc774\ube14 \uad6c\uc870\ub97c \uc0dd\uc131\ud558\uace0 \uac12\uc744 \ucd94\uac00\ud558\ub294\ub370 \ud544\uc694\ud55c SQL\ubb38\uc744 \uc0dd\uc131\ud574 \uc8fc\ub294 \ud234\uc785\ub2c8\ub2e4. \ud604\uc7ac\ub294 \ud3ec\uc778\ud2b8 \ud0c0\uc785\uc5d0 \ub300\ud55c SHP \ud30c\uc77c\uc5d0 \ub300\ud574\uc11c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \uc2e4\ud589 \ud654\uba74\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc704\uc758 UI \ud654\uba74\uc5d0\uc11c Export Fields\uc5d0 DBMS\ub85c \ub0b4\ubcf4\ub0b4\uace0\uc790 \ud558\ub294 \ud544\ub4dc\ub97c \uc120\ud0dd\ud558\uba74 \ub429\ub2c8\ub2e4.. \ud544\uc694\uc5c6\ub294 \ud544\ub4dc\uac12\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc81c\uc678\uc2dc\ucf1c\ub3c4 \ub429\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \uc774\uc6a9\ud574\uc11c DBMS\uc5d0 \ub530\ub77c \ud544\ub4dc\uba85\uc73c\ub85c\uc368 \uc0ac\uc6a9\ud560 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1258\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] SHP\uc744 SQL \ubb38\uc73c\ub85c \ubcc0\ud658\ud574 \uc8fc\ub294 \ud234 &#8211; SHP2SQL&#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":[44],"tags":[5,53],"class_list":["post-1258","post","type-post","status-publish","format-standard","hentry","category-gis-tools","tag-gis","tag-xr"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1258","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=1258"}],"version-history":[{"count":3,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1258\/revisions"}],"predecessor-version":[{"id":3319,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1258\/revisions\/3319"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1258"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}