{"id":10803,"date":"2021-01-08T16:53:53","date_gmt":"2021-01-08T07:53:53","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=10803"},"modified":"2021-01-09T20:01:18","modified_gmt":"2021-01-09T11:01:18","slug":"c%ec%97%90%ec%84%9c-spatialite-%ec%82%ac%ec%9a%a9%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=10803","title":{"rendered":"C#\uc5d0\uc11c Spatialite \uc0ac\uc6a9\ud558\uae30"},"content":{"rendered":"

Spatialite\ub294 SQLite\ub97c \uae30\ubc18\uc73c\ub85c \ud558\ubbc0\ub85c \uba3c\uc800 SQLite\ub97c \uc124\uce58\ud574\uc57c \ud569\ub2c8\ub2e4. SQLite \uc0ac\uc774\ud2b8<\/a>\uc5d0\uc11c Precompiled Binaries for 32-bit Windows (.NET Framework 4.6) \uc911 \ub450\ubc88\uc9f8\uc778 sqlite-netFx46-binary-Win32-2015-1.0.113.0.zip \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc2b5\ub2c8\ub2e4. (Visual Studio\uc5d0\uc11c .NET WinForm \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uac83\uc778\ub370 .NET \ubc84\uc804\uc740 4.6\uc73c\ub85c \ud558\uace0 32Bits\ub85c \uc124\uc815\ud568). \uc555\ucd95\uc744 \ud480\uace0 System.Data.SQLite.dll \ud30c\uc77c \ud504\ub85c\uc81d\ud2b8 \ucc38\uc870\uc5d0 \ucd94\uac00\ud558\uace0, SQLite.Interop.dll \ud30c\uc77c\uc740 \ud504\ub85c\uc81d\ud2b8\uc758 \uc2e4\ud589 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\ub294 Debug \ubc0f Release\uc5d0 \ubcf5\uc0ac\ud558\uba74 SQLite\uc758 \uae30\ubcf8 \uae30\ub2a5\uc740 \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

\uc774\uc81c Spatialite\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc774 \ud30c\uc77c<\/a>\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544 \uc555\ucd95\uc744 \ud480\uace0 \uc804\uccb4 \ud30c\uc77c\uc744 \ud504\ub85c\uc81d\ud2b8\uc758 \uc2e4\ud589 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\ub294 Debug \ubc0f Release \ud3f4\ub354\uc5d0 \ubcf5\uc0ac\ud569\ub2c8\ub2e4. \ucd5c\uc885\uc801\uc73c\ub85c \uc544\ub798\ucc98\ub7fc \ud30c\uc77c\uc774 \uad6c\uc131\ub420 \uac83\uc785\ub2c8\ub2e4. (\ubcf5\uc0ac\ub418\uc5b4\uc9c4 \ud30c\uc77c\uc740 \uc120\ud0dd \uc0c1\ud0dc\ub85c \ub460)<\/p>\n

\"\"<\/p>\n

\uc774\uc81c \ub2e4\uc74c \ucf54\ub4dc\ub97c \ud14c\uc2a4\ud2b8\ud558\uba74 \uc815\uc0c1 \uc791\ub3d9\ub429\ub2c8\ub2e4.<\/p>\n

\r\nconn = new SQLiteConnection(\"Data Source=d:\/db.sqlite;Version=3;\");\r\nconn.Open();\r\n\r\nconn.LoadExtension(\"mod_spatialite\");\r\n\r\nString sql = \"select sig_cd, ST_AsText(geometry) from TL_SCCO_SIG\";\r\n\/\/String sql = \"select sig_cd, geometry from TL_SCCO_SIG\";\r\nSQLiteCommand cmd = new SQLiteCommand(sql, conn);\r\nSQLiteDataReader rdr = cmd.ExecuteReader();\r\n            \r\nwhile (rdr.Read())\r\n{\r\n    MessageBox.Show(rdr[\"sig_cd\"] + \" \" + rdr.GetString(1));\r\n    break;\r\n}\r\n\r\nrdr.Close();\r\nconn.Close();\r\nconn.Dispose();\r\n<\/pre>\n
\uc704\uc758 \ucf54\ub4dc \uc911 4\ubc88 \ucf54\ub4dc\uac00 Spatialite \ubaa8\ub4c8\uc744 \ud655\uc7a5 \uae30\ub2a5\uc73c\ub85c \uc801\uc7ac\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
Spatialite\ub294 SQLite\ub97c \uae30\ubc18\uc73c\ub85c \ud558\ubbc0\ub85c \uba3c\uc800 SQLite\ub97c \uc124\uce58\ud574\uc57c \ud569\ub2c8\ub2e4. SQLite \uc0ac\uc774\ud2b8\uc5d0\uc11c Precompiled Binaries for 32-bit Windows (.NET Framework 4.6) \uc911 \ub450\ubc88\uc9f8\uc778 sqlite-netFx46-binary-Win32-2015-1.0.113.0.zip \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc2b5\ub2c8\ub2e4. (Visual Studio\uc5d0\uc11c .NET WinForm \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uac83\uc778\ub370 .NET \ubc84\uc804\uc740 4.6\uc73c\ub85c \ud558\uace0 32Bits\ub85c \uc124\uc815\ud568). \uc555\ucd95\uc744 \ud480\uace0 System.Data.SQLite.dll \ud30c\uc77c \ud504\ub85c\uc81d\ud2b8 \ucc38\uc870\uc5d0 \ucd94\uac00\ud558\uace0, SQLite.Interop.dll \ud30c\uc77c\uc740 \ud504\ub85c\uc81d\ud2b8\uc758 \uc2e4\ud589 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\ub294 Debug \ubc0f Release\uc5d0 \ubcf5\uc0ac\ud558\uba74 SQLite\uc758 \uae30\ubcf8 … <\/p>\n
\ub354 \ubcf4\uae30 “C#\uc5d0\uc11c Spatialite \uc0ac\uc6a9\ud558\uae30”<\/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-10803","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\/10803","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=10803"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/10803\/revisions"}],"predecessor-version":[{"id":10808,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/10803\/revisions\/10808"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10803"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}