{"id":10590,"date":"2020-11-05T13:36:15","date_gmt":"2020-11-05T04:36:15","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=10590"},"modified":"2020-11-05T13:36:15","modified_gmt":"2020-11-05T04:36:15","slug":"spatialite%ec%97%90%ec%84%9c-%ea%b3%b5%ea%b0%84-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a5%bc-%ea%b0%80%ec%a7%80%eb%8a%94-table-%ec%83%9d%ec%84%b1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=10590","title":{"rendered":"Spatialite\uc5d0\uc11c \uacf5\uac04 \ub370\uc774\ud130\ub97c \uac00\uc9c0\ub294 Table \uc0dd\uc131\ud558\uae30"},"content":{"rendered":"<p>Spatialite\uc5d0\uc11c\ub294 \ud14c\uc774\ube14 \uc0dd\uc131\uc2dc \ubc14\ub85c \uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\ub97c \ucd94\uac00\ud560 \uc218 \uc5c6\ub2e4. \uba3c\uc800 \uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\ub97c \uc81c\uc678\ud558\uace0 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nCREATE TABLE  main_item (\r\n    id INTEGER PRIMARY KEY AUTOINCREMENT, \r\n    layer TEXT,\r\n    title TEXT,\r\n    feature_id INTEGER\r\n);\r\n<\/pre>\n<p>\uc774\uc81c \uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\ub97c \ucd94\uac00\ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT AddGeometryColumn('main_item', 'geometry', -1, 'GEOMETRY', 'XY');\r\n<\/pre>\n<p>AddGeometryColumn \ud568\uc218\uc758 3\ubc88\uc9f8\ub294 EPSG \ucf54\ub4dc\uac12\uc774\uba70, 4\ubc88\uc9f8\ub294 POINT, LINESTRING, POLYGON, MULTIPOINT \ub4f1\uc774 \uc62c \uc218 \uc788\ub2e4. GEOMETRY\ub294 \ubaa8\ub4e0 \ud0c0\uc785\uc758 \uacf5\uac04 \ub370\uc774\ud130\ub97c \ubc1b\uc744 \uc218 \uc788\ub2e4.<\/p>\n<p>\uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\uc5d0 \uacf5\uac04 \uc778\ub371\uc2a4\ub97c \uac74\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT CreateSpatialIndex('main_item', 'geometry');\r\n<\/pre>\n<p>\ub05d\uc73c\ub85c Row\ub97c \ucd94\uac00\ud558\ub294 SQL\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nINSERT INTO main_item (layer, title, feature_id, geometry) \r\nVALUES ('layer1', 'title1', 100, ST_GEOMFROMTEXT('POINT(128.32132 37.34322)', -1));\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Spatialite\uc5d0\uc11c\ub294 \ud14c\uc774\ube14 \uc0dd\uc131\uc2dc \ubc14\ub85c \uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\ub97c \ucd94\uac00\ud560 \uc218 \uc5c6\ub2e4. \uba3c\uc800 \uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\ub97c \uc81c\uc678\ud558\uace0 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud55c\ub2e4. CREATE TABLE main_item ( id INTEGER PRIMARY KEY AUTOINCREMENT, layer TEXT, title TEXT, feature_id INTEGER ); \uc774\uc81c \uacf5\uac04 \ub370\uc774\ud130 \ud544\ub4dc\ub97c \ucd94\uac00\ud55c\ub2e4. SELECT AddGeometryColumn(&#8216;main_item&#8217;, &#8216;geometry&#8217;, -1, &#8216;GEOMETRY&#8217;, &#8216;XY&#8217;); AddGeometryColumn \ud568\uc218\uc758 3\ubc88\uc9f8\ub294 EPSG \ucf54\ub4dc\uac12\uc774\uba70, 4\ubc88\uc9f8\ub294 POINT, LINESTRING, POLYGON, MULTIPOINT \ub4f1\uc774 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=10590\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;Spatialite\uc5d0\uc11c \uacf5\uac04 \ub370\uc774\ud130\ub97c \uac00\uc9c0\ub294 Table \uc0dd\uc131\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":[7],"tags":[],"class_list":["post-10590","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\/10590","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=10590"}],"version-history":[{"count":2,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/10590\/revisions"}],"predecessor-version":[{"id":10826,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/10590\/revisions\/10826"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10590"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}