{"id":1875,"date":"2013-07-30T12:39:36","date_gmt":"2013-07-30T12:39:36","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1875"},"modified":"2017-01-27T13:58:25","modified_gmt":"2017-01-27T04:58:25","slug":"shp2sql-%e3%85%a1-mssqlserver-version","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1875","title":{"rendered":"[GIS] SHP2SQL \u3161 MSSQLServer Version"},"content":{"rendered":"<p>SHP \ud30c\uc77c\uc5d0 \ub300\ud55c \uc18d\uc131\uc815\ubcf4\uc640 MBR \uc815\ubcf4\ub97c MSSQL Server\uc758 DB \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud574 \uc8fc\ub294 SQL\ubb38\uc744 \uc0dd\uc131\ud574 \uc8fc\ub294 \ud234\uc785\ub2c8\ub2e4. \ud3ec\uc778\ud2b8 SHP \ud30c\uc77c\uc740 MBR \uc815\ubcf4\uc5d0 \ub300\ud574\uc11c \ud3ec\uc778\ud2b8(X, Y) \uac12\uc744 \uc800\uc7a5\ud558\uace0 \ud3f4\ub9ac\ub77c\uc778\uacfc \ud3f4\ub9ac\uace4\uc758 \uacbd\uc6b0 MinX, MinY, MaxX, MaxY \uac12\uc744 \uc800\uc7a5\ud574 \uc90d\ub2c8\ub2e4.<\/p>\n<p>(\uc8fc)\uc9c0\uc624\uc11c\ube44\uc2a4\uc758 \uacf5\uac04\uc11c\ubc84\uc778 GeoService-Xr\uc774 \uacf5\uac04 \ub370\uc774\ud130\uc5d0 \ub300\ud574 MSSQLServer\ub97c \uc9c0\uc6d0\ud558\uac8c \ub418\uba74\uc11c \ubd80\ucc28\uc801\uc778 \ubaa9\uc801\uc73c\ub85c \ud544\uc694\ud558\uc5ec \ub9cc\ub4e4\uc5b4\uc9c4 \ud234\uc785\ub2c8\ub2e4. \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 \ub4c0\ub77c\ub9f5(DuraMap-Xr)\uc744 \uae30\ubc18\uc73c\ub85c SHP \ud30c\uc77c\uc744 \ucc98\ub9ac\ud558\ubbc0\ub85c \ub4c0\ub77c\ub9f5\uc774 \uba3c\uc800 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1088328212.png\" class=\"aligncenter\" width=\"490\" height=\"430\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\uc704\uc758 \ud654\uba74\uc5d0\uc11c\ucc98\ub7fc \uc18d\uc131 \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud560 CREATE SQL\ubb38\uacfc \ub808\ucf54\ub4dc\ub97c \uc785\ub825\ud560 INSERT SQL\uc5d0 \ub300\ud574\uc11c \ub530\ub85c \uc800\uc7a5\ud558\ub3c4\ub85d \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc704\uc758 \ud654\uba74\uc5d0 \ub300\ud55c \uc2e4\ud589 \uacb0\uacfc\ub85c\uc368 CREATE SQL \ubb38\uc5d0 \ub300\ud55c \uacb0\uacfc\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\/1\/1093827895.png\" class=\"aligncenter\" width=\"510\" height=\"91\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\uadf8\ub9ac\uace0 INSERT SQL \ubb38\uc5d0 \ub300\ud55c \uacb0\uacfc\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\/1\/1393355297.png\" class=\"aligncenter\" width=\"510\" height=\"533\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\uc2e4\ud589 \ud30c\uc77c\uacfc \uc18c\uc2a4 \ud30c\uc77c\uc740 \uc544\ub798\uc758 \uacbd\ub85c\ub97c \ud1b5\ud574 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc73c\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. \ube44\ub85d \uc774 \ud234\uc740 MSSQL Server\uc5d0 \ub300\ud55c SQL\ubb38\uc744 \uc0dd\uc131\ud558\uc9c0\ub9cc \ub2e4\ub978 DBMS\uc758 \uacbd\uc6b0 \uc18c\uc2a4\ucf54\ub4dc\ub97c \uc57d\uac04 \ubcc0\uacbd\ud558\uc5ec \ub2e4\ub978 DBMS\uc5d0 \ub9de\ub294 SQL \uad6c\ubb38\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p style='text-align:center'><a href=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1177214303.zip\"><img width='64' src='\/images\/download.svg' \/><\/a><a href=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1247003293.zip\"><img width='64' src='\/images\/download.svg' \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SHP \ud30c\uc77c\uc5d0 \ub300\ud55c \uc18d\uc131\uc815\ubcf4\uc640 MBR \uc815\ubcf4\ub97c MSSQL Server\uc758 DB \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud574 \uc8fc\ub294 SQL\ubb38\uc744 \uc0dd\uc131\ud574 \uc8fc\ub294 \ud234\uc785\ub2c8\ub2e4. \ud3ec\uc778\ud2b8 SHP \ud30c\uc77c\uc740 MBR \uc815\ubcf4\uc5d0 \ub300\ud574\uc11c \ud3ec\uc778\ud2b8(X, Y) \uac12\uc744 \uc800\uc7a5\ud558\uace0 \ud3f4\ub9ac\ub77c\uc778\uacfc \ud3f4\ub9ac\uace4\uc758 \uacbd\uc6b0 MinX, MinY, MaxX, MaxY \uac12\uc744 \uc800\uc7a5\ud574 \uc90d\ub2c8\ub2e4. (\uc8fc)\uc9c0\uc624\uc11c\ube44\uc2a4\uc758 \uacf5\uac04\uc11c\ubc84\uc778 GeoService-Xr\uc774 \uacf5\uac04 \ub370\uc774\ud130\uc5d0 \ub300\ud574 MSSQLServer\ub97c \uc9c0\uc6d0\ud558\uac8c \ub418\uba74\uc11c \ubd80\ucc28\uc801\uc778 \ubaa9\uc801\uc73c\ub85c \ud544\uc694\ud558\uc5ec \ub9cc\ub4e4\uc5b4\uc9c4 \ud234\uc785\ub2c8\ub2e4. \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 \ub4c0\ub77c\ub9f5(DuraMap-Xr)\uc744 \uae30\ubc18\uc73c\ub85c SHP &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1875\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] SHP2SQL \u3161 MSSQLServer Version&#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],"class_list":["post-1875","post","type-post","status-publish","format-standard","hentry","category-gis-tools","tag-gis"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1875","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=1875"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1875\/revisions"}],"predecessor-version":[{"id":2963,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1875\/revisions\/2963"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1875"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}