Tag Info

Hot answers tagged

2

Error means that your program is compiled with such Spatialite version that does not have ST_MakeValid function. Only way to fix is to recompile with a proper version. Notice that ST_MakeValid is a LWGEOM function so Spatialite must be compiled accordingly with liblwgeom. Notice also that liblwgeom is using GPL license. If you can't compile yourself as a ...


1

Got it - use Spatialite 4.3 I tried Select ExportKML() from GUI, but doesn't seem to work. However the command-line .dumpkml works fine. See .help in Spatialite 4.3 for syntax.


1

got it - never mind: To export an SQLite table (or part of a table) as CSV, simply set the "mode" to "csv" and then run a query to extract the desired rows of the table. sqlite> .header on sqlite> .mode csv sqlite> .once c:/work/dataout.csv sqlite> SELECT * FROM tab1; sqlite> .system c:/work/dataout.csv In the example above, the ".header ...


1

The problem is that your geometries have to match in terms of reference (the Spatial Reference System, which is identified by a number, the SRID). So if you want to look up a point in degrees (longitude, latitude), but the data is in a UTM zone, you need to use a transformation to get from something referenced to SRID of 4326 to SRID of 26914. In your ...


1

Have you tried using the Offline plugin for QGIS? This syncs your PostGIS database to SpatiaLite and then syncs it back. https://docs.qgis.org/2.2/en/docs/user_manual/plugins/plugins_offline_editing.html If you need something custom, then go Spatialite; QGIS can edit it and you can setup triggers, views, querys etc that you have in your PostGIS database ...



Only top voted, non community-wiki answers of a minimum length are eligible