{"id":1436,"date":"2011-06-19T03:16:57","date_gmt":"2011-06-19T03:16:57","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1436"},"modified":"2017-01-27T20:57:54","modified_gmt":"2017-01-27T11:57:54","slug":"geoservice-xr%ec%97%90%ec%84%9c-%ec%83%88%eb%a1%9c%ec%9a%b4-dbms-%ec%b6%94%ea%b0%80-%ed%99%95%ec%9e%a5-%ec%9e%91%ec%97%85","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1436","title":{"rendered":"[GIS] GeoService-Xr\uc5d0\uc11c \uc0c8\ub85c\uc6b4 DBMS \ucd94\uac00\ub97c \uc704\ud55c \uc778\ud130\ud398\uc774\uc2a4 \uad6c\ud604"},"content":{"rendered":"<p>\uc0c8\ub85c\uc6b4 DBMS\ub97c GeoService-Xr\uc5d0 \ucd94\uac00\ud558\uae30 \uc704\ud55c \ud074\ub798\uc2a4 \uac04\uc758 \uad00\uacc4\ub97c \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uc774\ubc88\uc5d0 \uc0c8\ub86d\uac8c \ucd94\uac00\ud574\uc57c\ud560 DBMS\ub294 PostgreSQL\uc5d0 \uae30\ubc18\ud55c PostGIS\uc785\ub2c8\ub2e4. PostGIS\uc774\ubbc0\ub85c \uacf5\uac04\uac80\uc0c9\uc774\ub098 \uacf5\uac04 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uad00\ub9ac\ub294 \ubaa8\ub450 PostGIS\uc758 \uae30\ub2a5\uc744 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc2dc\uac04 \uc0c1\uc73c\ub85c PostGIS\ub97c \uae4a\uc774 \uc788\uac8c \uc0b4\ud3b4\ubcf8 \uc0c1\ud0dc\ub294 \uc544\ub2c8\uc9c0\ub9cc.. \uc9c0\uae08\uae4c\uc9c0\uc758 \ub290\ub08c\uc73c\ub85c\ub294 \uae54\ub054\ud569\ub2c8\ub2e4. \uc18d\ub3c4 \uc5ed\uc2dc \ube60\ub985\ub2c8\ub2e4. \uc544\ub798 \uadf8\ub9bc\uc740 \uc0c8\ub85c\uc6b4 DBMS \ucd94\uac00 \ud655\uc7a5\uc5d0 \ub300\ud574 \uad00\ub828\uc774 \uc788\ub294 \ud074\ub798\uc2a4\ub9cc\uc744 \ub5bc\uc5b4 \ub193\uc740 GeoService-Xr\uc758 \ud074\ub798\uc2a4 \uad00\uacc4\ub3c4\uc785\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1308528039.png\" class=\"aligncenter\" width=\"426\" height=\"408\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ubcf4\uc2dc\uba74&#8230; GeoService-Xr\uc774 \uc9c0\uc6d0\ud558\uace0 \uc788\ub294 \uacf5\uac04 \ub370\uc774\ud130\uc758 \uc18c\uc2a4\uac00 \uc5b4\ub5a4 \uac83\uc778\uc9c0\ub97c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud604\uc7ac\ub294 \ud30c\uc77c\uae30\ubc18, MySQL \uadf8\ub9ac\uace0 ArcSDE\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc5d0 \ub354\ud574\uc9c8 PostGIS\uac00 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ub610\ud55c \ud3b8\uc9d1\uc774 \uac00\ub2a5\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\ub294 MySQL\uacfc PostGIS\ub77c\ub294 \uac83\ub3c4 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \ud3b8\uc9d1\uc744 \uc704\ud55c \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc120\uc5b8\ud558\uace0 \uc788\ub294 \ud074\ub798\uc2a4\uac00 XrEditableSpatialAccess\uc778\ub370 \uc774 \ud074\ub798\uc2a4\ub97c \uc0c1\uc18d\ubc1b\uace0 \uc788\ub294 \ud074\ub798\uc2a4\uac00 XrMySqlAccess\uc640 XrPostGISAccess\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. <\/p>\n<p>\uacf5\uac04 \ub370\uc774\ud130 \uc11c\ube44\uc2a4 \ubc0f \uacf5\uac04 \ub370\uc774\ud130\uc758 \ud3b8\uc9d1\uc774 \uac00\ub2a5\ud55c \uacf5\uac04 DBMS\ub97c \uc0c8\ub86d\uac8c \ucd94\uac00\ud558\uae30 \uc704\ud574\uc11c XrEditableSpatialAccess\ub97c \uc0c1\uc18d\ubc1b\uc544\uc57c \ud558\uba70.. \uc774\ub54c \uad6c\ud604\ud574\uc57c\ud560 \uc778\ud130\ud398\uc774\uc2a4 \ub9e4\uc11c\ub4dc\uc758 \uac1c\uc218\ub294 13\uac1c\uc785\ub2c8\ub2e4. \uba3c\uc800 \ucd5c\uc0c1\uc704\uc758 Access \ud074\ub798\uc2a4\uc5d0 \ub300\ud574 \uad6c\ud604\ud574\uc57c\ud560 \ucd94\uc0c1 \ub9e4\uc11c\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>getAccessType : Access\uc758 \ud0c0\uc785 \ubc18\ud658\ud568(AccessType\uc774\ub77c\ub294 enum \ud0c0\uc785\uc758 \uac12 \ubc18\ud658)<\/li>\n<li>connect : \ud30c\uc77c \uc5f4\uae30, \uc18c\ucf13 \uc624\ud508 \ub4f1\uacfc \uac19\uc740 \ub370\uc774\ud130 \uc18c\uc2a4 \uc811\uadfc \uc900\ube44<\/li>\n<li>build : \ud30c\uc77c\uc774\ub098 DB\ub85c\ubd80\ud130 \uacf5\uac04 \ucffc\ub9ac\uac00 \uc2e4\uc81c \uac00\ub2a5\ud558\ub3c4\ub85d \uc900\ube44<\/li>\n<\/ul>\n<p>\uadf8\ub9ac\uace0 SpatialAccess\uc5d0 \ub300\ud574 \uad6c\ud604\ud574\uc57c \ud560 \ucd94\uc0c1 \ub9e4\uc11c\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>getMBR : \uc9c0\uc815\ub41c row\uc5d0 \ub300\ud55c MBR\uc744 \uc5bb\uc74c<\/li>\n<li>collectConnectionInfo : \ud544\ub4dc\uad6c\uc131, \uc804\uccb4 row \uc218, \uacf5\uac04 \ub3c4\ud615 \ud0c0\uc785, MBR \uc815\ubcf4\ub97c \uc5bb\uc74c<\/li>\n<li>queryByMBR : MBR\uc5d0 \ud3ec\ud568\ub418\ub294 \uacf5\uac04 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud568<\/li>\n<\/ul>\n<p>\uadf8\ub9ac\uace0 \ucd5c\uc885\uc801\uc73c\ub85c XrEditableSpatialAccess\uc5d0 \ub300\ud574 \uad6c\ud604\ud574 \uc918\uc57c\ud560 \ucd94\uc0c1 \ub9e4\uc11c\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ud3b8\uc9d1 \uae30\ub2a5\uc774 \ud544\uc694\uce58 \uc54a\uc744 \uacbd\uc6b0 \uc774 \ud074\ub798\uc2a4\uc758 \ucd94\uc0c1 \ub9e4\uc11c\ub4dc\ub294 \uad6c\ud604\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>updateFeature : \ud3b8\uc9d1\ub41c \uacf5\uac04 \ub370\uc774\ud130\ub97c update \uc2dc\ud0b4<\/li>\n<li>deleteFeature : \uc9c0\uc815\ub41c \uacf5\uac04 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud568<\/li>\n<li>insertFeature : \uc0c8\ub85c\uc6b4 \uacf5\uac04 \ub370\uc774\ud130\ub97c \ucd94\uac00\uc2dc\ud0b4<\/li>\n<li>checkExistFID : \uc9c0\uc815\ud55c FID\uac00 \uc774\ubbf8 \uc874\uc7ac\ud558\ub294\uc9c0 \uac80\uc0ac\ud568<\/li>\n<li>checkExistFIDs : \uc9c0\uc815\ud55c FID \ub9ac\uc2a4\ud2b8\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \uac80\uc0ac\ud568<\/li>\n<li>writeEditedHistoryData : \uacf5\uac04 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ud3b8\uc9d1 \uc774\ub825\uc744 \uae30\ub85d\ud568(\ubc18\ub4dc\uc2dc \uad6c\ud604\ud560 \ud544\uc694\ub294 \uc5c6\uc74c)<\/li>\n<li>getDBResource : \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0 \uc811\uadfc\ud558\uae30 \uc704\ud55c DB \ub9ac\uc18c\uc2a4\ub97c \uc5bb\uc74c<\/li>\n<\/ul>\n<p>\uc774\uc0c1\uc73c\ub85c XrGeoService-Xr \uacf5\uac04 \uc11c\ubc84\uc5d0\uc11c \uc0c8\ub85c\uc6b4 DBMS\ub97c \uc0c8\ub86d\uac8c \uc9c0\uc6d0\ud558\uae30 \uc704\ud574 \uad6c\ud604\ud574\uc57c\ud560 \uc778\ud130\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \uc815\ub9ac\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc0c8\ub85c\uc6b4 DBMS\ub97c GeoService-Xr\uc5d0 \ucd94\uac00\ud558\uae30 \uc704\ud55c \ud074\ub798\uc2a4 \uac04\uc758 \uad00\uacc4\ub97c \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uc774\ubc88\uc5d0 \uc0c8\ub86d\uac8c \ucd94\uac00\ud574\uc57c\ud560 DBMS\ub294 PostgreSQL\uc5d0 \uae30\ubc18\ud55c PostGIS\uc785\ub2c8\ub2e4. PostGIS\uc774\ubbc0\ub85c \uacf5\uac04\uac80\uc0c9\uc774\ub098 \uacf5\uac04 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uad00\ub9ac\ub294 \ubaa8\ub450 PostGIS\uc758 \uae30\ub2a5\uc744 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc2dc\uac04 \uc0c1\uc73c\ub85c PostGIS\ub97c \uae4a\uc774 \uc788\uac8c \uc0b4\ud3b4\ubcf8 \uc0c1\ud0dc\ub294 \uc544\ub2c8\uc9c0\ub9cc.. \uc9c0\uae08\uae4c\uc9c0\uc758 \ub290\ub08c\uc73c\ub85c\ub294 \uae54\ub054\ud569\ub2c8\ub2e4. \uc18d\ub3c4 \uc5ed\uc2dc \ube60\ub985\ub2c8\ub2e4. \uc544\ub798 \uadf8\ub9bc\uc740 \uc0c8\ub85c\uc6b4 DBMS \ucd94\uac00 \ud655\uc7a5\uc5d0 \ub300\ud574 \uad00\ub828\uc774 \uc788\ub294 \ud074\ub798\uc2a4\ub9cc\uc744 \ub5bc\uc5b4 \ub193\uc740 GeoService-Xr\uc758 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1436\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] GeoService-Xr\uc5d0\uc11c \uc0c8\ub85c\uc6b4 DBMS \ucd94\uac00\ub97c \uc704\ud55c \uc778\ud130\ud398\uc774\uc2a4 \uad6c\ud604&#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":[53],"class_list":["post-1436","post","type-post","status-publish","format-standard","hentry","category-gis-working-history","tag-xr"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1436","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=1436"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1436\/revisions"}],"predecessor-version":[{"id":3181,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1436\/revisions\/3181"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1436"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}