{"id":17330,"date":"2026-10-16T13:31:41","date_gmt":"2026-10-16T04:31:41","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=17330"},"modified":"2026-10-16T13:49:40","modified_gmt":"2026-10-16T04:49:40","slug":"cli-%eb%b0%a9%ec%8b%9d%ec%9c%bc%eb%a1%9c-shp-%ed%8c%8c%ec%9d%bc%ec%9d%84-postgresql%ec%97%90-import-%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=17330","title":{"rendered":"CLI \ubc29\uc2dd\uc73c\ub85c SHP \ud30c\uc77c\uc744 PostgreSQL\uc5d0 import \ud558\uae30"},"content":{"rendered":"<p>d:\/_t\/LSMD_CONT_LDREG_11_202607.shp \uacbd\ub85c\uc758 SHP \ud30c\uc77c\uc744 temp2\ub77c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 cadastral\uc774\ub77c\ub294 \ud14c\uc774\ube14 \uc774\ub984\uc73c\ub85c import \ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\nshp2pgsql -I -s 0 -W \"CP949\" -g the_geom \"d:\/_t\/LSMD_CONT_LDREG_11_202607.shp\" public.cadastral | psql -h localhost -p 5432 -U postgres -d temp2\r\n<\/pre>\n<p>\uc774\ub807\uac8c import\ub41c \ud14c\uc774\ube14\uc744 GeoService-Xr\uc5d0\uc11c \uc9c0\uc624\ub370\uc774\ud130\ub85c\uc368 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 \ub2e4\uc74c \ucffc\ub9ac \uc2e4\ud589\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nALTER TABLE public.cadastral RENAME COLUMN gid TO fid;\r\nCREATE INDEX cadastral_Index ON public.cadastral (fid);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>d:\/_t\/LSMD_CONT_LDREG_11_202607.shp \uacbd\ub85c\uc758 SHP \ud30c\uc77c\uc744 temp2\ub77c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 cadastral\uc774\ub77c\ub294 \ud14c\uc774\ube14 \uc774\ub984\uc73c\ub85c import \ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. shp2pgsql -I -s 0 -W &#8220;CP949&#8221; -g the_geom &#8220;d:\/_t\/LSMD_CONT_LDREG_11_202607.shp&#8221; public.cadastral | psql -h localhost -p 5432 -U postgres -d temp2 \uc774\ub807\uac8c import\ub41c \ud14c\uc774\ube14\uc744 GeoService-Xr\uc5d0\uc11c \uc9c0\uc624\ub370\uc774\ud130\ub85c\uc368 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 \ub2e4\uc74c \ucffc\ub9ac \uc2e4\ud589\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. ALTER TABLE public.cadastral RENAME COLUMN gid TO fid; CREATE INDEX &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=17330\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;CLI \ubc29\uc2dd\uc73c\ub85c SHP \ud30c\uc77c\uc744 PostgreSQL\uc5d0 import \ud558\uae30&#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":[50],"tags":[],"class_list":["post-17330","post","type-post","status-publish","format-standard","hentry","category-gisdev"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/17330","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=17330"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/17330\/revisions"}],"predecessor-version":[{"id":17334,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/17330\/revisions\/17334"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17330"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}