New answers tagged spatialite
I'll show how to do this in just spatialite. Lets start with creating the same schema as you showed in the question: -- The schema provided in the question CREATE TABLE site_investigation ( fid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, report_id TEXT UNIQUE NOT NULL ); SELECT AddGeometryColumn('site_investigation', 'geometry', ...
You can download the spatialite binary from http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/ You can download the .net assemblies from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki, or just use NuGet after reading which bits you need. Open the connection, enable extension loading, and then load the SpatiaLite extension using ...
Run: SELECT RecoverGeometryColumn(<new table>, <geom column name>, <SRID>, <geom type>);
Top 50 recent answers are included