Tag Info

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


0

QGIS expects the CRS to either be defined within the dataset or by the user. If it doesn't have this information, it won't know what CRS to render the dataset in as the coordinates within the dataset itself could be rendered using any CRS.


0

You can create an empty SpatiaLite database using Layer > Create Layer > New SpatiaLite Layer. Once you've done so, it will appear in the DB Manager (an included plugin; enable from the plugin manager if it is disabled). Alternatively, if you have an existing database you would like to add layers to, add it with Layer > Add Layer > Add Spatialite ...


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


0

My issue relates to differing coordinate systems. My source data (the shapefiles) is using SRID 26914. Most GPS coordinates are using SRID 4326. I used this service to convert my GPS points into SRID points and with this query: select * from zones where within(GeomFromText('POINT(611646.08 3365787.37)'),zones.Geometry); I got the results I expected. I ...


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



Top 50 recent answers are included