Tag Info

Hot answers tagged

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 ...



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