{"id":1791,"date":"2024-12-03T14:43:14","date_gmt":"2024-12-03T05:43:14","guid":{"rendered":"https:\/\/skanto.co.kr\/?p=1791"},"modified":"2024-12-03T14:47:14","modified_gmt":"2024-12-03T05:47:14","slug":"how-to-load-the-network-data-to-the-postgresql-db","status":"publish","type":"post","link":"https:\/\/skanto.co.kr\/?p=1791","title":{"rendered":"How to load the network data to the Postgresql DB"},"content":{"rendered":"\n<p>\ubaa9\ucc28<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-%EB%8F%84%EB%A1%9C%EB%84%A4%ED%8A%B8%EC%9B%8C%ED%81%AC%EB%8D%B0%EC%9D%B4%ED%84%B0DB%EC%83%9D%EC%84%B1\">\ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130 DB\uc0dd\uc131<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-%ED%95%9C%EA%B5%AD%EC%97%90%EC%84%9C%EC%82%AC%EC%9A%A9%ED%95%98%EB%8A%94%EC%A2%8C%ED%91%9C%EA%B3%84(UTMK,Katech%EC%9E%90%EB%8F%99%EC%B0%A8%EC%97%B0%EA%B5%AC%EC%9B%90)%EB%93%B1%EB%A1%9D\">\ud55c\uad6d\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc88c\ud45c\uacc4(UTMK, Katech\uc790\ub3d9\ucc28\uc5f0\uad6c\uc6d0) \ub4f1\ub85d<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-Commandline%ED%88%B4%EC%9D%84%EC%9D%B4%EC%9A%A9%ED%95%9C%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A1%9C%EB%94%A9\">Command line \ud234\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ub85c\ub529<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-shp\/dbf%ED%8C%8C%EC%9D%BC%EB%A1%9C%EB%93%9C\">shp\/dbf \ud30c\uc77c \ub85c\ub4dc<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-ShellScript%EB%A5%BC%ED%99%9C%EC%9A%A9%ED%95%9C%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A1%9C%EB%94%A9%EC%9E%90%EB%8F%99%ED%99%94\">Shell Script\ub97c \ud65c\uc6a9\ud55c \ub370\uc774\ud130 \ub85c\ub529 \uc790\ub3d9\ud654<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-%EC%B6%94%EA%B0%80%EA%B2%80%ED%86%A0%ED%95%B4%EB%B3%BC%EB%A7%8C%ED%95%9C%EC%9E%91%EC%97%85\">\ucd94\uac00 \uac80\ud1a0\ud574 \ubcfc\ub9cc \ud55c \uc791\uc5c5<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/How+to+load+the+network+data+to+the+Postgresql+DB#HowtoloadthenetworkdatatothePostgresqlDB-Reference\">Reference<\/a><\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-\ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c\ub370\uc774\ud130DB\uc0dd\uc131\">\ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130 DB\uc0dd\uc131<\/h1>\n\n\n\n<p>PostgreSQL DBMS\uc5d0 \ubc30\ud3ec\ub418\ub294 \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc801\uc7ac\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uba3c\uc800 \uc0dd\uc131\ud55c\ub2e4. \uc774 \uacfc\uc815\uc740&nbsp;<a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/PostgreSQL+for+Geospatial+Data\">PostgreSQL \uc124\uce58\uc2dc<\/a>&nbsp;\uc0dd\uc131\ud55c postgres \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud558\uc5ec \uc791\uc5c5\uc744 \uc9c4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uc608\uc81c\uc5d0\uc11c\ub294 \uc0dd\uc131\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uc744 &#8220;<strong>network<\/strong>&#8221; \ub85c \ud55c\ub2e4. \uc774 \uc774\ub984\uc740 \ud544\uc694\uc5d0 \ub530\ub77c \ubcc0\uacbd\ud574\ub3c4 \ubb34\ubc29\ud558\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>sudo \uad8c\ud55c\uc73c\ub85c postgres \uacc4\uc815\uc73c\ub85c \uc811\uc18d<\/li>\n\n\n\n<li><a href=\"https:\/\/wikidocs.net\/215484\">psql \uc811\uc18d<\/a><\/li>\n\n\n\n<li>\uc544\ub798\uc640 \uac19\uc774 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0dd\uc131 (DDL) \uc2e4\ud589<code>CREATE<\/code>&nbsp;<code>DATABASE<\/code>&nbsp;<code>&lt;DATABASE_NAME&gt;<\/code><code>WITH<\/code>&nbsp;<code>ENCODING =&nbsp;<\/code><code>'UTF8'<\/code><code>TEMPLATE = template0<\/code><code>LC_COLLATE =&nbsp;<\/code><code>'ko_KR.UTF-8'<\/code><code>LC_CTYPE =&nbsp;<\/code><code>'ko_KR.UTF-8'<\/code><code>CONNECTION<\/code>&nbsp;<code>LIMIT = -1;<\/code><\/li>\n\n\n\n<li>\uc0dd\uc131\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0&nbsp;<a href=\"https:\/\/www.devkuma.com\/docs\/postgresql\/%EC%8A%A4%ED%82%A4%EB%A7%88-%EC%83%9D%EC%84%B1-create-schema\/\">\uc2a4\ud0a4\ub9c8\ub97c \uc0dd\uc131<\/a>\ud55c\ub2e4.<br>\uc2a4\ud0a4\ub9c8\ub294 \uc704\uc5d0\uc11c \uc0dd\uc131\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ubc30\ud3ec\ub41c \ubc84\uc804\ubcc4\ub85c \uad00\ub9ac\ud558\uae30 \uc704\ud55c \uc6a9\ub3c4\ub85c \ud65c\uc6a9\ud55c\ub2e4. \ubcf4\ud1b5 \ub370\uc774\ud130 \ubc30\ud3ec\ub294 \uc555\ucd95\ud30c\uc77c \ud615\ud0dc(<em>\uc608: Network_20240118_V10.0_Full.zip<\/em>)\ub85c \ubc30\ud3ec\ub418\uba70&nbsp; \uc5ec\uae30\uc11c\ub294 \ubc30\ud3ec\uc77c \uae30\uc900\uc73c\ub85c \uc2a4\ud0a4\ub9c8(<em>\uc608: v_20240118<\/em>)\ub97c \uc0dd\uc131\ud55c\ub2e4.&nbsp; \uc2a4\ud0a4\ub9c8 \uc0dd\uc131 \ud6c4 \\dn \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec \uc2a4\ud0a4\ub9c8\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc0dd\uc131\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<code>CREATE<\/code>&nbsp;<code>SCHEMA<\/code>&nbsp;<code>&lt;schema_name&gt;;<\/code><\/li>\n\n\n\n<li>\uc0dd\uc131\ub41c DB(<em>network<\/em>)\uc73c\ub85c \uc811\uc18d (\\c network)<\/li>\n\n\n\n<li>PostGIS extension \uc124\uce58<code>CREATE<\/code>&nbsp;<code>EXTENSION postgis;<\/code><\/li>\n<\/ol>\n\n\n\n<p>\uc544\ub798\ub294 \uc704\uc5d0\uc11c \uc124\uba85\ud55c(1~6) \uc77c\ub828\uc758 \uacfc\uc815\uc73c\ub85c \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>skanto@skanto-HP-ZBook:~$ sudo su - postgres\npostgres@skanto-HP-ZBook:~$ psql\npsql (16.1 (Ubuntu 16.1-1.pgdg20.04+1))\nType \"help\" for help.\n \npostgres=# CREATE DATABASE network\npostgres-# WITH ENCODING = 'UTF8'\npostgres-# TEMPLATE = template0\npostgres-# LC_COLLATE = 'ko_KR.UTF-8'\npostgres-# LC_CTYPE = 'ko_KR.UTF-8'\npostgres-# CONNECTION LIMIT = -1;\nCREATE DATABASE\npostgres-#\npostgres=# \\c network\nYou are now connected to database \"network\" as user \"postgres\".\nnetwork=#\nnetwork=# CREATE SCHEMA v_20240118;\nCREATE SCHEMA\nnetwork=#\nnetwork=# \\dn\n        List of schemas\n    Name    |       Owner      \n------------+-------------------\n public     | pg_database_owner\n v_20240118 | postgres\n(2 rows)\nnetwork=# CREATE EXTENSION postgis;\nCREATE EXTENSION\nnetwork=#<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-\ud55c\uad6d\uc5d0\uc11c\uc0ac\uc6a9\ud558\ub294\uc88c\ud45c\uacc4(UTMK,Katech\uc790\ub3d9\ucc28\uc5f0\uad6c\uc6d0)\ub4f1\ub85d\">\ud55c\uad6d\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc88c\ud45c\uacc4(<a href=\"https:\/\/www.biz-gis.com\/index.php?mid=pds&amp;document_srl=65754\">UTMK<\/a>,&nbsp;<a href=\"https:\/\/hmjkor.tistory.com\/377\">Katech<\/a><sup><a href=\"https:\/\/www.katech.re.kr\/\">\uc790\ub3d9\ucc28\uc5f0\uad6c\uc6d0<\/a><\/sup>) \ub4f1\ub85d<\/h1>\n\n\n\n<p>\uacbd\ub85c\ud0d0\uc0c9\uc5d4\uc9c4\uacfc KT\uc9c0\ub3c4\uc5d0\uc11c UTMK\uc88c\ud45c\ub97c \uc0ac\uc6a9\ud558\uace0 \ud604\uc7ac\ub294 \ub9ce\uc774 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc9c0\ub9cc \uc0ac\uc6a9\ud560 \uac00\ub2a5\uc131\uc774 \uc788\uc5b4 Katech\uc88c\ud45c\uacc4\ub3c4 \uac19\uc774 \ub4f1\ub85d\ud55c\ub2e4. \ucc38\uace0\ub85c \ub9f5\ud37c\uc2a4\ub85c\ubd80\ud130 \uc218\uae09\ubc1b\ub294 \uc6d0\ubcf8 \ub370\uc774\ud130\ub294 WGS84 \uc88c\ud45c\uacc4\ub85c \uc81c\uc791\ub418\uc5b4 \uc788\uc5b4 \uc88c\ud45c\uacc4 \ubcc0\ud658\uc2dc \ub0b4\ubd80\uc801\uc73c\ub85c \ucc38\uc870\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- UTMK \uc88c\ud45c\uacc4 \ub4f1\ub85d\nnetwork=# INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 97165, 'sr-org', 7165, '+proj=tmerc +lat_0=38 +lon_0=127.5 +k=0.9996 +x_0=1000000 +y_0=2000000 +ellps=GRS80 +units=m +no_defs ','PROJCS&#91;\"UTMK\",GEOGCS&#91;\"GCS_ITRF_2000\",DATUM&#91;\"D_ITRF_2000\",SPHEROID&#91;\"GRS_1980\",6378137.0,298.257222101]],PRIMEM&#91;\"Greenwich\",0.0],UNIT&#91;\"Degree\",0.0174532925199433]],PROJECTION&#91;\"Transverse_Mercator\"],PARAMETER&#91;\"False_Easting\",1000000.0],PARAMETER&#91;\"False_Northing\",2000000.0],PARAMETER&#91;\"Central_Meridian\",127.5],PARAMETER&#91;\"Scale_Factor\",0.9996],PARAMETER&#91;\"Latitude_Of_Origin\",38.0],UNIT&#91;\"Meter\",1.0]]');\n \n-- KATECH \uc88c\ud45c\uacc4 \ub4f1\ub85d\nnetwork=# INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 98030, 'sr-org', 8030, '+proj=tmerc +lat_0=38 +lon_0=128 +k=0.9999 +x_0=400000 +y_0=600000 +ellps=bessel +towgs84=-145.907,505.034,685,0,0,0,0 +units=m +no_defs ', 'PROJCS&#91;\"Katech\",GEOGCS&#91;\"Bessel 1841\",DATUM&#91;\"unknown\",SPHEROID&#91;\"bessel\",6377397.155,299.1528128],TOWGS84&#91;-145.907,505.034,685,0,0,0,0]],PRIMEM&#91;\"Greenwich\",0],UNIT&#91;\"degree\",0.0174532925199433]],PROJECTION&#91;\"Transverse_Mercator\"],PARAMETER&#91;\"latitude_of_origin\",38],PARAMETER&#91;\"central_meridian\",128],PARAMETER&#91;\"scale_factor\",0.9999],PARAMETER&#91;\"false_easting\",400000],PARAMETER&#91;\"false_northing\",600000],UNIT&#91;\"Meter\",1]]');<\/code><\/pre>\n\n\n\n<p>\uc704\uc5d0\uc11c \uc0ac\uc6a9\ub41c spatial_ref_sys DB \ud14c\uc774\ube14\uc740 PostGIS Extension \uc124\uce58\uc2dc \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ub418\ub294 \ud14c\uc774\ube14\uc774\ub2e4.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-Commandline\ud234\uc744\uc774\uc6a9\ud55c\ub370\uc774\ud130\ub85c\ub529\">Command line \ud234\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ub85c\ub529<\/h1>\n\n\n\n<p>Command line\ud234\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ub85c\ub529\uc740 shp2pgsql \uba85\ub839\uc5b4\ub97c \ud65c\uc6a9\ud558\uba70 \ubc30\ud3ec\ub41c \uc6d0\ubcf8 \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130\ub97c \uc55e\uc5d0\uc11c \uc0dd\uc131\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub85c\ub529\ud55c\ub2e4. shp2pgsql \ub294 PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 Extension\uc778&nbsp;<a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/PostgreSQL+for+Geospatial+Data\">PostGIS\ub97c \uc124\uce58<\/a>\ud558\uba74 \uac19\uc774 \uc124\uce58\ub418\ub294 \uba85\ub839\uc5b4\uc774\ub2e4. \ub9cc\uc57d \uc124\uce58\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc124\uce58 \uac00\ub2a5\ud558\ub2e4(\uc124\uce58 \ud6c4 \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c DB\uc0dd\uc131\ubd80\ud130 \uc2dc\uc791!).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt-get install postgis<\/code><\/pre>\n\n\n\n<p>shp2pgsql\uc774 \uc124\uce58\ub418\uc5b4 \uc788\ub2e4\uba74 shp2pgsql \uba85\ub839\uc5b4 \uc2e4\ud589 \uc2dc \uc544\ub798\uc640 \uac19\uc774 \ucd9c\ub825\ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>network=# quit\npostgres@skanto-HP-ZBook:~$ shp2pgsql\nRELEASE: 3.4.1 (ca035b9)\nUSAGE: shp2pgsql &#91;&lt;options&gt;] &lt;shapefile&gt; &#91;&#91;&lt;schema&gt;.]&lt;table&gt;]\nOPTIONS:\n  -s &#91;&lt;from&gt;:]&lt;srid&gt; Set the SRID field. Defaults to 0.\n      Optionally reprojects from given SRID.\n (-d|a|c|p) These are mutually exclusive options:\n     -d  Drops the table, then recreates it and populates\n         it with current shape file data.\n     -a  Appends shape file into current table, must be\n         exactly the same table schema.\n     -c  Creates a new table and populates it, this is the\n         default if you do not specify any options.\n     -p  Prepare mode, only creates the table.\n  -g &lt;geocolumn&gt; Specify the name of the geometry\/geography column\n      (mostly useful in append mode).\n..\n..<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-shp\/dbf\ud30c\uc77c\ub85c\ub4dc\">shp\/dbf \ud30c\uc77c \ub85c\ub4dc<\/h2>\n\n\n\n<p>shp2pgsql command\ub97c \uc774\uc6a9\ud558\uc5ec \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub85c\ub529\ud55c\ub2e4. shp2pgsql \uba85\ub839\uc5b4\uc5d0\uc11c \ud65c\uc6a9\ud558\ub294 \uc635\uc158\uc740 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>-D: postgresql dump \ud3ec\uba67\uc744 \uc0ac\uc6a9(default\ub294 SQL insert\ubb38 \uc0ac\uc6a9)<\/li>\n\n\n\n<li>-s: SRID (srid:&nbsp;<a href=\"https:\/\/www.cockroachlabs.com\/docs\/stable\/srid-4326\">4326<\/a>&nbsp;&#8211; WGS84 \uc88c\ud45c\uacc4)<\/li>\n\n\n\n<li>-W: \uc778\ucf54\ub529 (Linux\ub294 UTF-8\uc774 default\uc784, \ub9f5\ud37c\uc2a4 \uc6d0\ub3c4 \ub370\uc774\ud130\ub294 UTF-8\ub85c \uc778\ucf54\ub529\ub418\uc5b4 \uc788\uc5b4 \uc6b4\uc601\uccb4\uc81c Encoding\uc774 UTF-8\uc77c \uacbd\uc6b0 \uc774 \uc635\uc158\uc744 \uc0dd\ub7b5\ud574\ub3c4 \ubb34\ubc29)<\/li>\n\n\n\n<li>-I: \uacf5\uac04 \uc778\ub371\uc2a4(GIST) \uc0dd\uc131 \uc5ec\ubd80<\/li>\n\n\n\n<li>-S: simple geometry \uc0ac\uc6a9\uc5ec\ubd80<\/li>\n\n\n\n<li><strong>-n: DBF \ud30c\uc77c\ub9cc \ub85c\ub4dc\ud560 \uacbd\uc6b0 \uc124\uc815 (\uc774 \uacbd\uc6b0\uc5d0\ub294 -s, -I, -S\uac00 \ubd88\ud544\uc694)<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@skanto-HP-ZBook:~$ shp2pgsql -D -s 4326 -I -S &lt;shapefile&gt; &#91;&#91;&lt;schema&gt;.]&lt;table&gt;] | psql -d &lt;database_name&gt;<\/code><\/pre>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4 NET_LINK_L.shp\ud30c\uc77c\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub85c\ub529\ud558\ub824\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc218\ud589\ud558\uba74 \ub41c\ub2e4. \uc774\ub54c&nbsp;<a href=\"https:\/\/en.wikipedia.org\/wiki\/Shapefile\">shp \ud30c\uc77c\uc744 \uc9c0\uc815\ud558\uba74 \uba85\ub839\uc5b4\uac00 dbf(\ub370\uc774\ud130), shx(\uc778\ub371\uc2a4)<\/a>\ub97c \uc790\ub3d9\uc73c\ub85c \ucc3e\uc544 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub85c\ub529\ud55c\ub2e4.<\/p>\n\n\n\n<p><strong>\ud65c\uc6a9\uc608<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@skanto-HP-ZBook:~$\npostgres@skanto-HP-ZBook:~$ shp2pgsql -D -s 4326 -I -S \/home\/skanto\/Documents\/00.Development\/data\/Network_20240118_V10.0_Full\/NET_LINK_L.shp v_20240118.NET_LINK_L | psql -d network\nField link_l is an FTDouble with width 11 and precision 0\nField road_num is an FTDouble with width 11 and precision 0\nShapefile type: Arc\nPostgis type: LINESTRING&#91;2]\nSET\nSET\nBEGIN\nCREATE TABLE\nALTER TABLE\n                    addgeometrycolumn                    \n----------------------------------------------------------\n public.net_link_l.geom SRID:4326 TYPE:LINESTRING DIMS:2\n(1 row)\n \nCOPY 3698757\nCREATE INDEX\nCOMMIT\nANALYZE<\/code><\/pre>\n\n\n\n<p>shp\ud30c\uc77c\uc774 \uc544\ub2cc dbf\ud30c\uc77c\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub85c\ub529\ud560 \uacbd\uc6b0 \uc704\uc5d0\uc11c \uc124\uba85\ud55c \uac83\ucc98\ub7fc \ubd88\ud544\uc694\ud55c \uc635\uc158\uc744 \uc81c\uac70 \ud6c4 \uc2e4\ud589\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@skanto-HP-ZBook:~$ shp2pgsql -D \/home\/skanto\/Documents\/00.Development\/data\/Network_20240118_V10.0_Full\/NET_CNINFO.dbf v_20240118.NET_CNINFO | psql -d network\nUnable to open \/home\/skanto\/Documents\/00.Development\/data\/Network_20240118_V10.0_Full\/NET_CNINFO.shp or \/home\/skanto\/Documents\/00.Development\/data\/Network_20240118_V10.0_Full\/NET_CNINFO.SHP.\n\/home\/skanto\/Documents\/00.Development\/data\/Network_20240118_V10.0_Full\/NET_CNINFO.dbf: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.\nSET\nSET\nBEGIN\nCREATE TABLE\nALTER TABLE\nCOPY 20750040\nCOMMIT\nANALYZE<\/code><\/pre>\n\n\n\n<p>\ucc38\uace0\ub85c \ubc30\ud3ec\ub418\ub294 \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130 \uc885\ub958\ub294 \uc544\ub798\uc640 \uac19\ub2e4.&nbsp;<em>(2024.1\uc6d4 \ub370\uc774\ud130 \uae30\uc900)<\/em><\/p>\n\n\n\n<p><strong>\ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \uc6d0\ubcf8 \ub370\uc774\ud130 \uc885\ub958<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>skanto@skanto-HP-ZBook:~\/Documents\/00.Development\/data\/Network_20240118_V10.0_Full$ ls -l\ntotal 6372940\n-rw-rw-r-- 1 skanto skanto 3195506481  1\uc6d4 19 11:11 NET_CNINFO.dbf\n-rw-rw-r-- 1 skanto skanto   93339225  1\uc6d4 19 11:11 NET_DIR.dbf\n-rw-rw-r-- 1 skanto skanto   79247465  1\uc6d4 19 11:13 NET_FARE.dbf\n-rw-rw-r-- 1 skanto skanto   79247465  1\uc6d4 19 11:13 NET_FARE_EV.dbf\n-rw-rw-r-- 1 skanto skanto   80876241  1\uc6d4 19 11:13 NET_FARE_EV_HI.dbf\n-rw-rw-r-- 1 skanto skanto   80876241  1\uc6d4 19 11:13 NET_FARE_HI.dbf\n-rw-rw-r-- 1 skanto skanto     203679  1\uc6d4 19 11:13 NET_FERRY_INFO.dbf\n-rw-rw-r-- 1 skanto skanto      75768  1\uc6d4 19 11:13 NET_FERRY_LINK.dbf\n-rw-rw-r-- 1 skanto skanto    5083165  1\uc6d4 19 11:12 NET_GUIDEPT_P.dbf\n-rw-rw-r-- 1 skanto skanto    1949684  1\uc6d4 19 11:12 NET_GUIDEPT_P.shp\n-rw-rw-r-- 1 skanto skanto     557124  1\uc6d4 19 11:12 NET_GUIDEPT_P.shx\n-rw-rw-r-- 1 skanto skanto    1527988  1\uc6d4 19 11:14 NET_IMAGE.dbf\n-rw-rw-r-- 1 skanto skanto   10323681  1\uc6d4 19 11:11 NET_LANE.dbf\n-rw-rw-r-- 1 skanto skanto   26382177  1\uc6d4 19 11:02 NET_LINKIN.dbf\n-rw-rw-r-- 1 skanto skanto 1335252526  1\uc6d4 19 11:02 NET_LINK_L.dbf\n-rw-rw-r-- 1 skanto skanto  567197260  1\uc6d4 19 11:02 NET_LINK_L.shp\n-rw-rw-r-- 1 skanto skanto   29590156  1\uc6d4 19 11:02 NET_LINK_L.shx\n-rw-rw-r-- 1 skanto skanto  682972565  1\uc6d4 19 11:04 NET_NODE_P.dbf\n-rw-rw-r-- 1 skanto skanto   86923832  1\uc6d4 19 11:04 NET_NODE_P.shp\n-rw-rw-r-- 1 skanto skanto   24835452  1\uc6d4 19 11:04 NET_NODE_P.shx\n-rw-rw-r-- 1 skanto skanto   16455785  1\uc6d4 19 11:13 NET_OIL_LINK.dbf\n-rw-rw-r-- 1 skanto skanto     357268  1\uc6d4 19 11:13 NET_OIL_LINK.shp\n-rw-rw-r-- 1 skanto skanto     102148  1\uc6d4 19 11:13 NET_OIL_LINK.shx\n-rw-rw-r-- 1 skanto skanto    2948381  1\uc6d4 19 11:12 NET_SAFETY_L.dbf\n-rw-rw-r-- 1 skanto skanto      24435  1\uc6d4 19 11:12 NET_SAFETY_PAIR.dbf\n-rw-rw-r-- 1 skanto skanto   76003615  1\uc6d4 19 11:12 NET_SAFETY_P.dbf\n-rw-rw-r-- 1 skanto skanto   31762684  1\uc6d4 19 11:12 NET_SAFETY_P.shp\n-rw-rw-r-- 1 skanto skanto    9075124  1\uc6d4 19 11:12 NET_SAFETY_P.shx\n-rw-rw-r-- 1 skanto skanto      76563  1\uc6d4 19 11:13 NET_SCENIC_INFO.dbf\n-rw-rw-r-- 1 skanto skanto     284252  1\uc6d4 19 11:13 NET_SCENIC_LINK.dbf\n-rw-rw-r-- 1 skanto skanto     152161  1\uc6d4 19 11:13 NET_SVCAREA.dbf\n-rw-rw-r-- 1 skanto skanto    4760321  1\uc6d4 19 11:13 NET_TD_LINK.dbf\n-rw-rw-r-- 1 skanto skanto     561209  1\uc6d4 19 11:13 NET_TD_PASS.dbf\n-rw-rw-r-- 1 skanto skanto      73392  1\uc6d4 19 11:12 NET_TOLL.dbf\n-rw-rw-r-- 1 skanto skanto     274145  1\uc6d4 19 11:12 NET_TOLLLINK.dbf\n-rw-rw-r-- 1 skanto skanto     512865  1\uc6d4 19 11:04 NET_TURN_P.dbf\n-rw-rw-r-- 1 skanto skanto     293092  1\uc6d4 19 11:04 NET_TURN_P.shp<\/code><\/pre>\n\n\n\n<p>\ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub85c\ub529\ud558\ub294 \uc77c\ub828\uc758 \uacfc\uc815\uc744 \ubc30\ud3ec\ub418\ub294 \ub370\uc774\ud130\ud30c\uc77c\ubcc4(\uc704 \ubaa9\ub85d \ucc38\uace0)\ub85c \uac01\uac01 \uc218\ud589\ud574\uc57c \uc804\uccb4 \uc791\uc5c5\uc774 \ub9c8\ubb34\ub9ac \ub41c\ub2e4. \uc774 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654 \ud55c Shell \uc2a4\ud2b8\ub9bd\ud2b8\uac00 \uc788\uc73c\uba70&nbsp;<a href=\"https:\/\/gitlab.dspace.kt.co.kr\/GISRPMM\/dbexporter\/-\/blob\/master\/docs\/dataload.md#%EB%8F%84%EB%A1%9C%EB%84%A4%ED%8A%B8%EC%9B%8C%ED%81%AC%EB%8D%B0%EC%9D%B4%ED%84%B0-%EC%A0%84%EC%B2%B4-shp%ED%8C%8C%EC%9D%BC-db-import\">Git \uc5d0 \uc815\ub9ac\ub41c \ub0b4\uc6a9\uc744 \ucc38\uace0<\/a>\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-ShellScript\ub97c\ud65c\uc6a9\ud55c\ub370\uc774\ud130\ub85c\ub529\uc790\ub3d9\ud654\">Shell Script\ub97c \ud65c\uc6a9\ud55c \ub370\uc774\ud130 \ub85c\ub529 \uc790\ub3d9\ud654<\/h2>\n\n\n\n<p>\uc9c0\uae08\uae4c\uc9c0 Manual\ud55c \ubc29\ubc95\uc73c\ub85c \ub370\uc774\ud130\ub97c \ub85c\ub529\ud588\ub2e4. \uc774 \uacbd\uc6b0 \uc2dc\uac04\ub3c4 \ub9ce\uc774 \uac78\ub9ac\uace0 \uc2e4\uc218\ub85c \uc778\ud55c \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \uac00\ub2a5\uc131\uc774 \ub192\ub2e4. Shell Script\ub97c \ud65c\uc6a9\ud558\uba74 Manual\ud558\uac8c \ucc98\ub9ac\ud588\ub358 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654 \ud560 \uc218 \uc788\ub2e4.&nbsp; \uc544\ub798\uc758 \uc21c\uc11c\ub300\ub85c \uc9c4\ud589\ud55c\ub2e4. (\ub85c\uceec\uc5d0 DB\uc640 \ub370\uc774\ud130\uac00 \uac19\uc774 \uc788\ub2e4\ub294 \uac00\uc815\ud558\uc5d0)<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>&#8220;sudo su postgres&#8221; \uba85\ub839\uc5b4\ub85c postgres \uacc4\uc815\uc73c\ub85c \ubcc0\uacbd<\/li>\n\n\n\n<li>\uc6d0\ubcf8 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc555\ucd95\ud574\uc81c\ud55c \ub514\ub809\ud130\ub9ac\ub85c \uc774\ub3d9(\uc774 \uacbd\uc6b0 \ub514\ub809\ud130\ub9ac \uc774\ub984\uc774 &#8220;Network_20240118_V10.0_Full&#8221;\uc758 \ud615\ud0dc\ub97c \uac00\uc9d0)<\/li>\n\n\n\n<li>\ud574\ub2f9 \ub514\ub809\ud130\ub9ac\uc5d0&nbsp;<a href=\"https:\/\/wiki.dspace.kt.co.kr\/download\/attachments\/192479945\/install.sh?version=1&amp;modificationDate=1706860871654&amp;api=v2\">\ucca8\ubd80\ub41c Script\ud30c\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc<\/a>&nbsp;\ubc1b\uc740 \ub2e4\uc74c \uc2e4\ud589 \uad8c\ud55c\uc744 \uc900\ub2e4.<\/li>\n\n\n\n<li>command line\uc5d0\uc11c install.sh \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p><strong>install.sh<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n# This script loads data files for road network into the database\n \necho \"\"\necho \"##### LOADS ROAD NETWORK DATA INTO THE DATBASE #####\"\necho \"\"\nread -p 'Enter the name for the database to create(default: network): ' db\nif &#91; \"$db\" = \"\" ]; then\n  db=\"network\"\nfi\n# schema name will be extracted from the current directory name\nschema=\"\"\nif &#91;&#91; $(pwd) =~ _&#91;0-9]{8} ]]; then\n  schema=\"v${BASH_REMATCH&#91;0]}\"\nfi\n \nread -p \"Enter the name for the schema to create(default: $schema): \" _schema\nif &#91; \"$_schema\" != \"\" ]; then\n  schema=\"$_schema\"\nfi\necho \"\"\necho \"The database name to create is '$db'\"\necho \"The schema name of the database($db) is '$schema'\"\n \necho \"\"\nread -p 'If the information is correct hit the &#91;ENTER] key to do the jobs or &#91;Ctrl-C] to exit! '\n \necho \"\"\necho \"Now creates database using the name: $db\"\necho \"select 'create database $db with encoding = \\\"UTF8\\\" template = template0 connection limit = -1' where not exists (select from pg_database where datname = '$db')\\gexec\" | psql\n \necho \"\"\necho \"Now creates schema using the name: $schema\"\necho \"create schema if not exists $schema ;\" | psql -d \"$db\"\n \necho \"\"\necho \"Now creates postgis extension...\"\necho \"create extension postgis;\" | psql -d \"$db\"\n \necho \"\"\necho \"Now inserts CRS(UTMK, KATECH) to extension table...\"\n# Insert UTMK Coordinates\necho \"INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 97165, 'sr-org', 7165, '+proj=tmerc +lat_0=38 +lon_0=127.5 +k=0.9996 +x_0=1000000 +y_0=2000000 +ellps=GRS80 +units=m +no_defs ','PROJCS&#91;\"UTMK\",GEOGCS&#91;\"GCS_ITRF_2000\",DATUM&#91;\"D_ITRF_2000\",SPHEROID&#91;\"GRS_1980\",6378137.0,298.257222101]],PRIMEM&#91;\"Greenwich\",0.0],UNIT&#91;\"Degree\",0.0174532925199433]],PROJECTION&#91;\"Transverse_Mercator\"],PARAMETER&#91;\"False_Easting\",1000000.0],PARAMETER&#91;\"False_Northing\",2000000.0],PARAMETER&#91;\"Central_Meridian\",127.5],PARAMETER&#91;\"Scale_Factor\",0.9996],PARAMETER&#91;\"Latitude_Of_Origin\",38.0],UNIT&#91;\"Meter\",1.0]]');\" | psql -d \"$db\"\n \n# Insert KATECH Coordinates\necho \"INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 98030, 'sr-org', 8030, '+proj=tmerc +lat_0=38 +lon_0=128 +k=0.9999 +x_0=400000 +y_0=600000 +ellps=bessel +towgs84=-145.907,505.034,685,0,0,0,0 +units=m +no_defs ', 'PROJCS&#91;\"Katech\",GEOGCS&#91;\"Bessel 1841\",DATUM&#91;\"unknown\",SPHEROID&#91;\"bessel\",6377397.155,299.1528128],TOWGS84&#91;-145.907,505.034,685,0,0,0,0]],PRIMEM&#91;\"Greenwich\",0],UNIT&#91;\"degree\",0.0174532925199433]],PROJECTION&#91;\"Transverse_Mercator\"],PARAMETER&#91;\"latitude_of_origin\",38],PARAMETER&#91;\"central_meridian\",128],PARAMETER&#91;\"scale_factor\",0.9999],PARAMETER&#91;\"false_easting\",400000],PARAMETER&#91;\"false_northing\",600000],UNIT&#91;\"Meter\",1]]');\" | psql -d \"$db\"\n \nfiles=(*)\nidx=1\nfor file in \"${files&#91;@]}\"; do\n  table=\"${file:0:(-4)}\"\n  shp=\"$table.shp\"\n  echo \"\"\n  if &#91;&#91; ${files&#91;@]} =~ $shp ]]; then # if files array contains .shp file\n    if &#91; \"$file\" = \"$shp\" ]; then # if the extension of the file is .shp\n      echo \"### ($idx) Now loads shp data file... &#91;$file]\"\n      shp2pgsql -D -s 4326 -I -S \"$file\" \"$schema.$table\" | psql -d \"$db\"\n      idx=$(expr $idx + 1)\n    fi\n  elif &#91; \"${file:(-3)}\" = \"dbf\" ]; then\n    echo \"### ($idx) Now loads dbf data file... &#91;$file]\"\n    shp2pgsql -D \"$file\" \"$schema.$table\" | psql -d \"$db\"\n    idx=$(expr $idx + 1)\n  fi\ndone\n \necho \"\"\necho \"The jobs for loading data into database are all completed!!!\"\necho \"\"\n# End of Script<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-\ucd94\uac00\uac80\ud1a0\ud574\ubcfc\ub9cc\ud55c\uc791\uc5c5\">\ucd94\uac00 \uac80\ud1a0\ud574 \ubcfc\ub9cc \ud55c \uc791\uc5c5<\/h1>\n\n\n\n<p>\ub370\uc774\ud130 \ub85c\ub529\uc791\uc5c5\uc744 \uc790\ub3d9\ud654 \ud558\uae30 \uc704\ud574 Shell Script\ub97c \ub9ce\uc774 \ud65c\uc6a9\ud55c \ubd80\ubd84\uc774 \uc788\ub2e4. \uc774 \ubd80\ubd84\uc740 Shell Script\uc5d0 \uc775\uc219\ud558\uc9c0 \uc54a\uc740 \uc0ac\ub78c\uc774\ub77c\uba74 \ub7ec\ub2dd\ucee4\ube0c\uac00 \uc788\uc744 \uac83\uc73c\ub85c \uc608\uc0c1\ub418\uba70 \uc708\ub3c4\uc6b0 \ud658\uacbd\uc774\ub77c\ub4e0\uac00 Shell Script\ub97c \uc2e4\ud589\ud558\uae30 \uc5b4\ub824\uc6b4 \ud658\uacbd\uc5d0\uc11c\ub294 \ud65c\uc6a9\uc774 \uc81c\uc57d\uc801\uc774\ub2e4. \uc774\ub7f0 \uacbd\uc6b0\ub97c \ub300\ube44\ud574\uc11c Java \uc774\uc6a9\ud558\uc5ec \uc77c\ubc18 Install \ud504\ub85c\uadf8\ub7a8\ucc98\ub7fc \ub370\uc774\ud130 \ub85c\ub529 \uacfc\uc815 \uc790\ub3d9\ud654 \ud504\ub85c\uadf8\ub7a8 \uc81c\uc791\uc744 \uace0\ub824\ud574 \ubcfc\ub9cc\ud55c \ud558\ub2e4.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"HowtoloadthenetworkdatatothePostgresqlDB-Reference\">Reference<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/display\/GISRPMM2021\/PostgreSQL+for+Geospatial+Data\">PostgreSQL for Geospatial Data<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/pages\/viewpage.action?pageId=8978627\">\ub370\uc774\ud130 Import<\/a>&nbsp;(\uacfc\uac70 \ub370\uc774\ud130)\n<ul class=\"wp-block-list\">\n<li>\uacfc\uac70\uc5d0 \uc791\uc131\ub41c \uc790\ub8cc\ub85c CP949\uad00\ub828 Characterset \uc124\uc815\uc740 \ubb34\uc2dc\ud574\uc57c \ud55c\ub2e4. \uadfc\ub798 \ubc30\ud3ec\ub418\ub294 \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130\uc758 Characterset\uc740 UTF-8\ub85c \ub9de\ucdb0\uc838 \uc788\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/wiki.dspace.kt.co.kr\/pages\/viewpage.action?pageId=11338336\">Aporia \uac1c\ubc1c \ud658\uacbd \uad6c\ucd95<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/gitlab.dspace.kt.co.kr\/GISRPMM\/dbexporter\/-\/blob\/master\/docs\/dataload.md#%EB%8F%84%EB%A1%9C%EB%84%A4%ED%8A%B8%EC%9B%8C%ED%81%AC-%EB%8D%B0%EC%9D%B4%ED%84%B0-db-load\">[Git] \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130 db load<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/gitlab.dspace.kt.co.kr\/GISRPMM\/dbexporter\/-\/tree\/master\/db-script\">\uad00\ub828 Script \ucc38\uace0<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ubaa9\ucc28 \ub3c4\ub85c\ub124\ud2b8\uc6cc\ud06c \ub370\uc774\ud130 DB\uc0dd\uc131 PostgreSQL DBMS\uc5d0 \ubc30\ud3ec\ub418\ub294 \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc801\uc7ac\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uba3c\uc800 \uc0dd\uc131\ud55c\ub2e4. \uc774 \uacfc\uc815\uc740&nbsp;PostgreSQL \uc124\uce58\uc2dc&nbsp;\uc0dd\uc131\ud55c postgres \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud558\uc5ec \uc791\uc5c5\uc744 \uc9c4\ud589\ud55c\ub2e4. \uc774 \uc608\uc81c\uc5d0\uc11c\ub294 \uc0dd\uc131\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uc744 &#8220;network&#8221; \ub85c \ud55c\ub2e4. \uc774 \uc774\ub984\uc740 \ud544\uc694\uc5d0 \ub530\ub77c \ubcc0\uacbd\ud574\ub3c4 \ubb34\ubc29\ud558\ub2e4. \uc544\ub798\ub294 \uc704\uc5d0\uc11c \uc124\uba85\ud55c(1~6) \uc77c\ub828\uc758 \uacfc\uc815\uc73c\ub85c \ubcf4\uc5ec\uc900\ub2e4. \ud55c\uad6d\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc88c\ud45c\uacc4(UTMK,&nbsp;Katech\uc790\ub3d9\ucc28\uc5f0\uad6c\uc6d0) \ub4f1\ub85d \uacbd\ub85c\ud0d0\uc0c9\uc5d4\uc9c4\uacfc KT\uc9c0\ub3c4\uc5d0\uc11c UTMK\uc88c\ud45c\ub97c \uc0ac\uc6a9\ud558\uace0 \ud604\uc7ac\ub294 \ub9ce\uc774 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc9c0\ub9cc \uc0ac\uc6a9\ud560 \uac00\ub2a5\uc131\uc774 \uc788\uc5b4 Katech\uc88c\ud45c\uacc4\ub3c4 \uac19\uc774 \ub4f1\ub85d\ud55c\ub2e4. \ucc38\uace0\ub85c \ub9f5\ud37c\uc2a4\ub85c\ubd80\ud130 \uc218\uae09\ubc1b\ub294 \uc6d0\ubcf8 \ub370\uc774\ud130\ub294 WGS84 \uc88c\ud45c\uacc4\ub85c \uc81c\uc791\ub418\uc5b4 \uc788\uc5b4 \uc88c\ud45c\uacc4 \ubcc0\ud658\uc2dc \ub0b4\ubd80\uc801\uc73c\ub85c \ucc38\uc870\uac00 \ud544\uc694\ud558\ub2e4. \uc704\uc5d0\uc11c \uc0ac\uc6a9\ub41c spatial_ref_sys DB \ud14c\uc774\ube14\uc740&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/skanto.co.kr\/?p=1791\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[14],"tags":[172],"class_list":["post-1791","post","type-post","status-publish","format-standard","hentry","category-sw-development","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/skanto.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skanto.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skanto.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skanto.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skanto.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1791"}],"version-history":[{"count":3,"href":"https:\/\/skanto.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1791\/revisions"}],"predecessor-version":[{"id":1794,"href":"https:\/\/skanto.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1791\/revisions\/1794"}],"wp:attachment":[{"href":"https:\/\/skanto.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skanto.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skanto.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}