{"id":1700,"date":"2012-06-27T05:49:20","date_gmt":"2012-06-27T05:49:20","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1700"},"modified":"2017-02-11T17:32:19","modified_gmt":"2017-02-11T08:32:19","slug":"%eb%8f%84%eb%a1%9c%eb%aa%85-%ec%a3%bc%ec%86%8c-%ea%b2%80%ec%83%89%ec%97%90-%ec%82%ac%ec%9a%a9%eb%90%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1700","title":{"rendered":"[GIS] \ub3c4\ub85c\uba85 \uc8fc\uc18c \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ub41c \ub370\uc774\ud130 \ubc0f \ub3c4\ub85c\uba85 \uc8fc\uc18c \ud604\uc7a5\uc870\uc0ac \uc2dc\uc2a4\ud15c \uc18c\uac1c"},"content":{"rendered":"<p>\ud611\ub825\uc0ac\ub97c \ud1b5\ud574 \uac1c\ubc1c \ubc0f \ub0a9\ud488 \uc694\uccad\uc744 \ubc1b\uace0 \uac1c\ubc1c\ud55c &#8220;\ub3c4\ub85c\uba85 \uc8fc\uc18c \ud604\uc7a5\uc870\uc0ac \uc2dc\uc2a4\ud15c&#8221;\uc5d0\uc11c \ub3c4\ub85c\uba85\uc5d0 \uae30\ubc18\ud55c \uc0c8\uc8fc\uc18c \uac80\uc0c9 \uae30\ub2a5\uc744 \uac1c\ubc1c\ud558\uba74\uc11c.. \uc774 \uc0c8\uc8fc\uc18c \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc815\ub9ac\ub97c \ud574\ubd05\ub2c8\ub2e4.<\/p>\n<p>\uc2dc\uc2a4\ud15c \uac1c\ubc1c\uc744 \uc704\ud574 \uc81c\uacf5 \ubc1b\uc740 \ub370\uc774\ud130\ub294 KLIS\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \uc9c0\uc801\ub3c4, 25cm\uae09 \ud56d\uacf5\uc601\uc0c1(77 \uae30\uac00\ubc14\uc774\ud2b8) \uadf8\ub9ac\uace0 \uc0c8\uc8fc\uc18c \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \uc0c8\uc8fc\uc18c \ub370\uc774\ud130\uc5d0\ub294 \uac74\ubb3c, \ub3c4\ub85c, \ucd9c\uc785\uad6c \ub4f1\uc5d0 \ub300\ud55c SHP \ud30c\uc77c\uc785\ub2c8\ub2e4. \uc774 \ub370\uc774\ud130 \uc911\uc5d0\uc11c \uc0c8\uc8fc\uc18c \uac80\uc0c9 \uae30\ub2a5\uc5d0\uc11c \uc0ac\uc6a9\ub41c \ub370\uc774\ud130\ub294 \uc624\uc9c1 \uac74\ubb3c\uc5d0 \ub300\ud55c SHP \ud30c\uc77c \ud558\ub098\uc785\ub2c8\ub2e4. \uc774 \uac74\ubb3c\uc758 \uc18d\uc131 \ud544\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub9e4\uc6b0 \ub9ce\uc740 \ud544\ub4dc\ub85c \uad6c\uc131\ub418\uc5b4\uc838 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1169265181.png\" class=\"aligncenter\" width=\"473\" height=\"410\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ud558\uc9c0\ub9cc \ub298 \uadf8\ub807\ub4ef&#8230; \ud544\uc694\ud55c \uac83\uc740 \uc774 \uc911 \uc77c\ubd80\uc785\ub2c8\ub2e4.. \ub370\uc774\ud130 \uc6a9\ub7c9\uacfc \uc18d\ub3c4\ub97c \ucd5c\uc801\ud654 \uc2dc\ud0a4\uae30\uae30 \uc704\ud574\uc11c \uc0c8\uc8fc\uc18c \uac80\uc0c9\uc5d0 \ud544\uc694\ud55c \ud544\ub4dc\ub9cc\uc744 \ub0a8\uae30\uace0 \uc815\ub9ac\ub97c \ud558\uba74 \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\/1156030681.png\" class=\"aligncenter\" width=\"297\" height=\"130\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ubcf4\uc2dc\uba74.. \uac74\ubb3c\uc758 \uba85\uce6d\uc744 \uc704\ud55c BULD_NM\uacfc \uc74d\uba74 \ub2e8\uc704 \uba85\uce6d\uc778 EMD \uadf8\ub9ac\uace0 \ub3c4\ub85c\uba85\uc5d0 \ub300\ud55c DORON, \uc8fc\uc18c\uc758 \ubc88\uc9c0\ub97c \ub098\ud0c0\ub0b4\ub294 BULD_MN\uacfc BULD_SL \ud544\ub4dc\uac00 \uc804\ubd80\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 DP_NAME\uc774\ub77c\ub294 \uc0c8\ub85c\uc6b4 \ud544\ub4dc\uac00 \ucd94\uac00\ub418\uc5c8\ub294\ub370 \uc774 \ud544\ub4dc\ub294 BULD_MN\uacfc BULD_SL\ub85c \uacc4\uc0b0\ub41c \ud544\ub4dc\uc785\ub2c8\ub2e4. \uc0c8\uc8fc\uc18c\uc5d0\ub3c4 \uac74\ubb3c\uc5d0 \ub300\ud55c \ubc88\uc9c0\uac00 \uc874\uc7ac\ud558\ub294 \ubc14\ub85c \uc774 \ubc88\uc9c0\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc73c\ub85c \uac74\ubb3c \uc704\uc5d0 \ub77c\ubca8\ub85c \ud45c\uc2dc\ud558\uae30 \uc704\ud55c \ubaa9\uc801\uc73c\ub85c \ucd94\uac00\ud55c \ud544\ub4dc\uc785\ub2c8\ub2e4. \uc774 DP_NAME\uc740 \uc8fc\uc18c \uac80\uc0c9\uc5d0 \ud65c\uc6a9\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uac74\ubb3c \uc704\uc5d0 \ub77c\ubca8 \ud45c\uc2dc\uac00 \ud544\uc694\uce58 \uc54a\uc73c\uba74 \ucd94\uac00\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub429\ub2c8\ub2e4. \uc8fc\uc18c \uac80\uc0c9\uc5d0 \ud544\uc694\ud55c \ub370\uc774\ud130, \ub9e4\uc6b0 \ub2e8\uc21c\ud558\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uace0&#8230; \uc774\uc81c UI\ub97c \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1348341230.png\" class=\"aligncenter\" width=\"400\" height=\"413\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ubcf4\uc2dc\uba74.. \uc74d\uba74\uc5d0\ub294 \uac80\uc0c9 \ub300\uc0c1 \uc9c0\uc5ed\uc758 \uc74d\uba74\uc5d0 \ub300\ud55c \uba85\uce6d\uc774 \ub9ac\uc2a4\ud2b8\uc5c5\ub418\uba70.. \ud558\ub098\uc758 \uc74d\uba74\uc744 \uc120\ud0dd\ud558\uba74 \ub3c4\ub85c\uba85\uc5d0 \uc120\ud0dd\ub41c \uc74d\uba74\uc5d0 \ud574\ub2f9\ub418\ub294 \ub3c4\ub85c\uba85\uc774 \ub9ac\uc2a4\ud2b8\uc5c5\ub429\ub2c8\ub2e4. \uc74d\uba74 \ubc0f \ub3c4\ub85c\uba85\uc758 \ub9ac\uc2a4\ud2b8\uc5c5\uc740 \uc55e\uc11c \uc5b8\uae09\ud55c \ub370\uc774\ud130\uc758 \ud544\ub4dc\ub85c \uad6c\uc131\uc774 \uc27d\uac8c \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc774\uc911 \uc120\ud0dd\ub41c \uc74d\uba74\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc758 \ubaa9\ub85d\uc744 \uc870\ud68c\ud558\ub294 SQL\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>SELECT \r\n    DISTINCT DORON \r\nFROM \r\n    ADDRESSDB \r\nWHERE \r\n    EMD = '\uc6a9\ubb38\uba74' AND DORON <> ''<\/pre>\n<p>\uc704\uc758 UI\uc5d0\uc11c \ubc88\uc9c0\uc5d0 4 \ub97c \uc785\ub825\ud558\uace0 \uac80\uc0c9 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \uac80\uc0c9 \uacb0\uacfc\uc5d0 4 \uac00 \ud3ec\ud568\ub41c \uc6a9\ubb38\uba74 \uac1c\ubc29\uae38\uc5d0 \ub300\ud55c \uc8fc\uc18c\uac00 \uc544\ub798\uc758 \ud654\uba74\ucc98\ub7fc \uac80\uc0c9\ub429\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1099901017.png\" class=\"aligncenter\" width=\"400\" height=\"409\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\uc774 \uc911 42\ub97c \uc120\ud0dd\ud558\uace0 \uc774\ub3d9 \ubc84\ud2bc\uc744 \ub204\ub974\uba74.. \ud574\ub2f9 \uc704\uce58\ub85c \ube60\ub974\uac8c \uc9c0\ub3c4\uac00 \uc774\ub3d9\ub429\ub2c8\ub2e4. <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1171230915.png\" class=\"aligncenter\" width=\"510\" height=\"333\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ud574\ub2f9 \uc704\uce58\ub85c \uc9c0\ub3c4\ub97c \uc774\ub3d9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uac74\uc0c9\ub41c \uac74\ubb3c \ub3c4\ud615\uc5d0 \ub300\ud55c MBR\uc744 \uc54c\uc544\uc57c \ud558\ub294\ub370 \uc774 MBR\uc740 \ubc14\ub85c \uc54c\uae30\ub294 \uc5b4\ub835\uace0.. \uba3c\uc800 \ud574\ub2f9 \uac74\ubb3c\uc758 FID\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4. \uc774 FID\ub97c \uc870\ud68c\ud558\ub294 SQL\uc5d0 \ub300\ud55c \uc2e4\uc81c \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ucf54\ub4dc\ub294 \uc2dc\uc2a4\ud15c\uc758 \uad6c\ub3d9 \ud658\uacbd\uc778 \uc548\ub4dc\ub85c\uc774\ub4dc SDK\uc758 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<pre>Cursor cursor = rawDb.rawQuery(\r\n    \"SELECT FID, BULD_NM, DP_NAME FROM ADDRESSDB WHERE EMD='\" + \r\n    emdName +  \"' AND DORON='\" + \r\n    roadName + \"' AND BULD_MN LIKE '%\" + \r\n    BonBun + \"%' AND BULD_SL LIKE '%\" + \r\n    BuBun + \"'\", null);<\/pre>\n<p>\uc5ec\uae30\uc11c FID\ub97c \uc5bb\uc5b4 \uc62c \uc218 \uc788\uace0.. \uc774 FID\ub97c \ud1b5\ud574 \ud574\ub2f9 \ub3c4\ud615\uc758 MBR\uc744 \ub2e4\uc2dc \uc5bb\uc5b4\uc624\uac8c \ub429\ub2c8\ub2e4.<\/p>\n<p>\ub05d\uc73c\ub85c.. \ub3c4\ub85c\uba85 \uc8fc\uc18c \ud604\uc7a5\uc870\uc0ac\uc2dc\uc2a4\ud15c\uc740 \uc548\ub4dc\ub85c\uc774\ub4dc \uae30\ubc18\uc758 GIS \uc2dc\uc2a4\ud15c\uc73c\ub85c <a href=\"http:\/\/www.geoservice.co.kr\" target=\"_blank\">\uc9c0\uc624\uc11c\ube44\uc2a4<\/a>\uc758 \ube14\ub799\ud3ec\uc778\ud2b8\ub77c\ub294 \ubaa8\ubc14\uc77c GIS \uc5d4\uc9c4\uc744 \uc774\uc6a9\ud574 \uac1c\ubc1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud604\uc7a5\uc870\uc0ac\uc2dc\uc2a4\ud15c\uc740 \uacf5\uac04 \ub370\uc774\ud130\ub9cc \uc2dc\uc2a4\ud15c\uc5d0 \ub9de\uac8c \uac00\uacf5\ud558\uace0 \uc801\uc6a9\ud568\uc73c\ub85c\uc368 \uc2dc\uc2a4\ud15c\uc5d0 \ub300\ud55c \uc7ac\uac1c\ubc1c\uc744 \ud558\uc9c0 \uc54a\uace0 \ubc14\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uac1c\ubc1c\ub41c \uc81c\ud488\uc785\ub2c8\ub2e4.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1173083697.png\" class=\"aligncenter\" width=\"710\" \/><\/p>\n<p>\uc7a0\uc2dc \uc18c\uac1c\ud574 \ub4dc\ub9b0 \ud604\uc7a5\uc870\uc0ac \uc2dc\uc2a4\ud15c\uc774\ub098 \uc774 \uc2dc\uc2a4\ud15c \uac1c\ubc1c\uc5d0 \uc0ac\uc6a9\ub41c \ube14\ub799\ud3ec\uc778\ud2b8 \uc5d4\uc9c4\uc5d0 \ub300\ud574 \uad00\uc2ec \uc788\uc73c\uc2e0 \ubd84\uc740 <a href=\"http:\/\/www.geoservice.co.kr\" target=\"_blank\">\uc9c0\uc624\uc11c\ube44\uc2a4<\/a>\ub85c \ubb38\uc758\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud611\ub825\uc0ac\ub97c \ud1b5\ud574 \uac1c\ubc1c \ubc0f \ub0a9\ud488 \uc694\uccad\uc744 \ubc1b\uace0 \uac1c\ubc1c\ud55c &#8220;\ub3c4\ub85c\uba85 \uc8fc\uc18c \ud604\uc7a5\uc870\uc0ac \uc2dc\uc2a4\ud15c&#8221;\uc5d0\uc11c \ub3c4\ub85c\uba85\uc5d0 \uae30\ubc18\ud55c \uc0c8\uc8fc\uc18c \uac80\uc0c9 \uae30\ub2a5\uc744 \uac1c\ubc1c\ud558\uba74\uc11c.. \uc774 \uc0c8\uc8fc\uc18c \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc815\ub9ac\ub97c \ud574\ubd05\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c \uac1c\ubc1c\uc744 \uc704\ud574 \uc81c\uacf5 \ubc1b\uc740 \ub370\uc774\ud130\ub294 KLIS\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \uc9c0\uc801\ub3c4, 25cm\uae09 \ud56d\uacf5\uc601\uc0c1(77 \uae30\uac00\ubc14\uc774\ud2b8) \uadf8\ub9ac\uace0 \uc0c8\uc8fc\uc18c \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \uc0c8\uc8fc\uc18c \ub370\uc774\ud130\uc5d0\ub294 \uac74\ubb3c, \ub3c4\ub85c, \ucd9c\uc785\uad6c \ub4f1\uc5d0 \ub300\ud55c SHP \ud30c\uc77c\uc785\ub2c8\ub2e4. \uc774 \ub370\uc774\ud130 \uc911\uc5d0\uc11c \uc0c8\uc8fc\uc18c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1700\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] \ub3c4\ub85c\uba85 \uc8fc\uc18c \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ub41c \ub370\uc774\ud130 \ubc0f \ub3c4\ub85c\uba85 \uc8fc\uc18c \ud604\uc7a5\uc870\uc0ac \uc2dc\uc2a4\ud15c \uc18c\uac1c&#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":[72],"tags":[71,5,53],"class_list":["post-1700","post","type-post","status-publish","format-standard","hentry","category-smartpoint-xr","tag-blackpoint","tag-gis","tag-xr"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1700","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=1700"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1700\/revisions"}],"predecessor-version":[{"id":4488,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1700\/revisions\/4488"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1700"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}