{"id":1994,"date":"2014-02-15T06:02:14","date_gmt":"2014-02-15T06:02:14","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1994"},"modified":"2017-01-27T11:14:09","modified_gmt":"2017-01-27T02:14:09","slug":"dbf%eb%a5%bc-sqlite-db-%ed%8c%8c%ec%9d%bc%eb%a1%9c-%eb%a7%8c%eb%93%a4%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1994","title":{"rendered":"DBF\ub97c SQLite DB \ud30c\uc77c\ub85c \ub9cc\ub4e4\uae30"},"content":{"rendered":"<p>DBF \ud30c\uc77c\uc744 \uc5d1\uc140\ub85c \ubd88\ub7ec\uc628 \ud6c4 \uccab\ud589\uc5d0\uc11c <strong>FID \ub77c\ub294 \uc774\ub984\uc758 \uceec\ub7fc\uc744 \ucd94\uac00<\/strong>\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 FID \uceec\ub7fc\uc758 \uac12\uc744 0\ubd80\ud130 \uc2dc\uc791\ud558\uc5ec 1\uc529 \uc99d\uac00\ud558\ub3c4\ub85d \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc544\ub798\uac00 \uc774\uc640 \uac19\uc740 \uc791\uc5c5\uc758 \uc608\uc2dc\uc785\ub2c8\ub2e4. \uc774 FID \uceec\ub7fc\uc774 \ud544\uc694\ud55c \uc774\uc720\ub294 SHP \ud30c\uc77c\uc758 \ub3c4\ud615\uc640\uc758 1:1 \uad00\uacc4\ud0a4\ub85c \uc0ac\uc6a9\ud558\uae30 \uc704\ud568\uc785\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1276251033.png\" width=\"492\" height=\"415\" \/><\/p>\n<p>\uadf8\ub9ac\uace0 \uc774 \ud30c\uc77c\uc744<strong> \ud14d\uc2a4\ud2b8(\ud0ed\uc73c\ub85c \ubd84\ub9ac)\ub85c \uc800\uc7a5<\/strong>\ud569\ub2c8\ub2e4. \uc774 \ud30c\uc77c\uc744 \uc778\ucf54\ub529\uc740 ANSI\ub85c \ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370 \uc774\ub97c<strong> UTF-8\ub85c \ubcc0\ud658<\/strong>\ud569\ub2c8\ub2e4. \uc800 \uac19\uc740 \uacbd\uc6b0 \uba54\ubaa8\uc7a5\uc5d0\uc11c \ubd88\ub7ec\uc640 UTF-8\ub85c \uc778\ucf54\ub529\uc744 \uc9c0\uc815\ud558\uc5ec \uc800\uc7a5\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>SQLite Expert Professional \ubc84\uc804\uc744 \uc2e4\ud589<\/strong>\ud569\ub2c8\ub2e4.<strong> [File]-[New Database]\ub97c \uc2e4\ud589<\/strong>\ud558\uc5ec \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c0\uc815\ud558\uace0 OK \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1140209131.png\" width=\"499\" height=\"214\" \/><\/p>\n<p><font color=\"#8E8E8E\">\uc77c\ubc18\uc801\uc73c\ub85c Database File \uc548\uc5d0\ub294 \ub2e4\uc218\uc758 \ud14c\uc774\ube14\uc774 \uc874\uc7ac\ud558\uc9c0\ub9cc \ub2e8 \ud558\ub098\uc758 \ud14c\uc774\ube14\ub9cc \uc874\uc7ac\ud558\uba70 \uc774 \ud14c\uc774\ube14\uc758 \uc774\ub984\uacfc Database File\uc758 \uc774\ub984\uc740 \uac19\ub2e4\ub77c\uace0 \uc57d\uc18d\ud569\ub2c8\ub2e4. \uc774 \ubd80\ubd84\uc740 \ubaa8\ubc14\uc77c GIS \uc5d4\uc9c4\uc778 \ube14\ub799\ud3ec\uc778\ud2b8\uc5d0\uc11c \ud544\uc694\ud55c \uc57d\uc18d\uc774\ubbc0\ub85c \ube14\ub799\ud3ec\uc778\ud2b8\ub97c \uc704\ud55c \ubcc0\ud658\uc774 \uc544\ub2c8\ub77c\uba74 \uad00\uacc4\uc5c6\uc2b5\ub2c8\ub2e4.<\/font><\/p>\n<p>\uadf8\ub9ac\uace0 <strong>[Import\/Export]-[Import Text File]<\/strong>\uc744 \uc2e4\ud589\ud558\uace0 \ub2e4\uc74c\ucc98\ub7fc \uc55e\uc11c \ub9cc\ub4e4\uc5b4 \ub193\uc740 \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc744 \uc9c0\uc815\ud55c \ud6c4 Start \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1237394433.png\" width=\"510\" height=\"318\" \/><\/p>\n<p>\ud14c\uc774\ube14\uc774 \ub9cc\ub4e4\uc5b4 \uc84c\uace0 \ub9cc\ub4e4\uc5b4\uc9c4 <strong>\ud544\ub4dc\ub97c \ubcf4\ub2e4 \uc815\ud655\ud558\uac8c \uc870\uc815<\/strong>\ud558\uae30 \uc704\ud574 Design \ud0ed \uc548\uc758 Fields \ud0ed\uc744 \uc120\ud0dd\ud558\uc5ec Type, Size\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ud544\uc694\ud558\ub2e4\uba74 Not Null\uc744 \uccb4\ud06c\ud558\ub3c4\ub85d \ud558\uc5ec Null \uac12\uc744 \uacbd\uc6b0 \uae30\ubcf8\uac12\uc744 \uac00\uc9c0\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uc774\ub294 Null \uc77c \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uc608\uc678\ub97c \ub300\ube44\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<font color=\"#8E8E8E\">. \ube14\ub799\ud3ec\uc778\ud2b8\uc5d0\uc11c\ub294 \uc774\ub7f0 Not Null \ucc98\ub9ac\uac00 \ubc18\ub4dc\uc2dc \ud544\uc694\ud558\uba70 Type\uc740 Size\uac00 0\uc778 INTEGER, Size\uac00 0\uc774 \uc544\ub2cc CHAR, Size\uac00 0\uc778 FLOAT\ub9cc\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/font><\/p>\n<p>\uadf8\ub9ac\uace0 \uc778\ub371\uc2a4\ub97c \uac78\uae30 \uc704\ud574\uc11c Desing \ud0ed \uc548\uc758 Indexes \ud0ed\uc744 \uc120\ud0dd\ud558\uc5ec <strong>\uc778\ub371\uc2a4\ub97c \ucd94\uac00<\/strong>\ud569\ub2c8\ub2e4. \ucd5c\uc18c\ud55c FID\ub294 \uc778\ub371\uc2a4\ub97c \uac78\uc5b4\uc8fc\ub294 \uac83\uc774 \uc88b\uc73c\uba70 \uac80\uc0c9\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ud544\ub4dc\uac00 \uc788\ub2e4\uba74 \uc778\ub371\uc2a4\ub97c \uac78\uc5b4\uc90d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBF \ud30c\uc77c\uc744 \uc5d1\uc140\ub85c \ubd88\ub7ec\uc628 \ud6c4 \uccab\ud589\uc5d0\uc11c FID \ub77c\ub294 \uc774\ub984\uc758 \uceec\ub7fc\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 FID \uceec\ub7fc\uc758 \uac12\uc744 0\ubd80\ud130 \uc2dc\uc791\ud558\uc5ec 1\uc529 \uc99d\uac00\ud558\ub3c4\ub85d \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc544\ub798\uac00 \uc774\uc640 \uac19\uc740 \uc791\uc5c5\uc758 \uc608\uc2dc\uc785\ub2c8\ub2e4. \uc774 FID \uceec\ub7fc\uc774 \ud544\uc694\ud55c \uc774\uc720\ub294 SHP \ud30c\uc77c\uc758 \ub3c4\ud615\uc640\uc758 1:1 \uad00\uacc4\ud0a4\ub85c \uc0ac\uc6a9\ud558\uae30 \uc704\ud568\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 \ud30c\uc77c\uc744 \ud14d\uc2a4\ud2b8(\ud0ed\uc73c\ub85c \ubd84\ub9ac)\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc774 \ud30c\uc77c\uc744 \uc778\ucf54\ub529\uc740 ANSI\ub85c \ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370 \uc774\ub97c UTF-8\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1994\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;DBF\ub97c SQLite DB \ud30c\uc77c\ub85c \ub9cc\ub4e4\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":[7],"tags":[],"class_list":["post-1994","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\/1994","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=1994"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1994\/revisions"}],"predecessor-version":[{"id":2891,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1994\/revisions\/2891"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1994"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}