{"id":2193,"date":"2015-05-28T03:42:20","date_gmt":"2015-05-28T03:42:20","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2193"},"modified":"2017-01-26T22:51:17","modified_gmt":"2017-01-26T13:51:17","slug":"postgresql%ec%97%90%ec%84%9c-%ea%b3%b5%ea%b0%84-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4spatial-database-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2193","title":{"rendered":"PostgreSQL\uc5d0\uc11c \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Spatial Database) \uc0dd\uc131"},"content":{"rendered":"<p><P>PostgreSQL\uc640 PostGIS\ub97c \uac01\uac01 \ucd5c\uc2e0\ubc84\uc804(\uae00\uc791\uc131 \uae30\uc900\uc73c\ub85c 9.4.2-1 64Bits)\uc744 \uc124\uce58 \ud558\uc600\uc2b5\ub2c8\ub2e4. PostGIS \uc774\uc804\ubc84\uc804\uc5d0\uc11c\ub294 \uc124\uce58 \ub2e8\uacc4\uc5d0\uc11c \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58\ub97c \uccb4\ud06c\ud558\uba74 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud574 \uc8fc\uc5c8\uc73c\ub098 \ucd5c\uc2e0\ubc84\uc804\uc5d0\uc11c\ub294 \uccb4\ud06c\ub97c \ud558\uc5ec\ub3c4 \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131 \ub418\uc9c0 \uc54a\uc544 \uc9c1\uc811 SQL\ubb38\uc744 \ud1b5\ud574 \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud574 \uc918\uc57c \ud569\ub2c8\ub2e4. \uc77c\ub2e8 PostgreSQL\uacfc PostGIS\ub97c \ubaa8\ub450 \uc124\uce58\ub97c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 pgAdmin\uc744 \uc2e4\ud589\ud558\uace0 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\uc744 \uc704\ud574 \uc544\ub798 \ud654\uba74\ucc98\ub7fc Databases\uc5d0\uc11c \uba54\ub274\ub97c \ud638\ucd9c\ud558\uace0 New Database&#8230;\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/P><\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1370295270.png\" \/><\/p>\n<p><P>\uc0c8\ub86d\uac8c \ud45c\uc2dc\ub41c New Database&#8230; \ub300\ud654\uc0c1\uc790\uc5d0\uc11c \uc0dd\uc131\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc774\ub984\uacfc \uc18c\uc720\uc790\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uba85\uc740 gis\ub85c \uc785\ub825 \ud558\uc600\uace0 \uc18c\uc720\uc790\ub294 postgres\ub97c \uc120\ud0dd\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/P><\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1273460366.png\" \/><\/p>\n<p><P>\uc0dd\uc131\ub41c gis \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 SQL\ubb38\uc744 \uc785\ub825\ud558\uae30 \uc704\ud574 SQL \uc785\ub825\uae30\ub97c \uc544\ub798 \ud654\uba74\uc758 \ud234 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/P><\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1310727663.png\" \/><\/p>\n<p><P>\ud45c\uc2dc\ub41c Query \ub300\ud654\uc0c1\uc790\uc5d0\uc11c \uc544\ub798\ud654\uba74\ucc98\ub7fc \uc785\ub825\ud558\uace0 \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/P><\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1045051131.png\" \/><\/p>\n<p><P>\uadf8\ub9ac\uace0 \ub610 \uc544\ub798\ucc98\ub7fc \uc785\ub825\ud558\uace0 \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/P><\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1156402510.png\" \/><\/p>\n<p><P>\uc5ec\uae30\uae4c\uc9c0\uac00 \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud55c \uc808\ucc28\uc778\ub370\uc694. \uc9c0\uae08\uae4c\uc9c0 \uc633\ubc14\ub974\uac8c \uc9c4\ud589\uc774 \ub418\uc5c8\ub2e4\uba74 \uc544\ub798\ud654\uba74\ucc98\ub7fc spatial_ref_sys \ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub41c \uac83\uc774 \ubcf4\uc785\ub2c8\ub2e4.<\/P><\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1037367410.png\" \/><\/p>\n<p><P>\uc774\uc0c1\uc73c\ub85c \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud55c \uacfc\uc815\uc744 \uc815\ub9ac\ud574 \ubd24\uc2b5\ub2c8\ub2e4.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\uc640 PostGIS\ub97c \uac01\uac01 \ucd5c\uc2e0\ubc84\uc804(\uae00\uc791\uc131 \uae30\uc900\uc73c\ub85c 9.4.2-1 64Bits)\uc744 \uc124\uce58 \ud558\uc600\uc2b5\ub2c8\ub2e4. PostGIS \uc774\uc804\ubc84\uc804\uc5d0\uc11c\ub294 \uc124\uce58 \ub2e8\uacc4\uc5d0\uc11c \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58\ub97c \uccb4\ud06c\ud558\uba74 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud574 \uc8fc\uc5c8\uc73c\ub098 \ucd5c\uc2e0\ubc84\uc804\uc5d0\uc11c\ub294 \uccb4\ud06c\ub97c \ud558\uc5ec\ub3c4 \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131 \ub418\uc9c0 \uc54a\uc544 \uc9c1\uc811 SQL\ubb38\uc744 \ud1b5\ud574 \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud574 \uc918\uc57c \ud569\ub2c8\ub2e4. \uc77c\ub2e8 PostgreSQL\uacfc PostGIS\ub97c \ubaa8\ub450 \uc124\uce58\ub97c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 pgAdmin\uc744 \uc2e4\ud589\ud558\uace0 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\uc744 \uc704\ud574 \uc544\ub798 \ud654\uba74\ucc98\ub7fc Databases\uc5d0\uc11c \uba54\ub274\ub97c \ud638\ucd9c\ud558\uace0 New &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2193\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL\uc5d0\uc11c \uacf5\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Spatial Database) \uc0dd\uc131&#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-2193","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\/2193","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=2193"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2193\/revisions"}],"predecessor-version":[{"id":2751,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2193\/revisions\/2751"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2193"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}