Timeline for How to make a Spatialite View (with geometries) for QGIS based on two table
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 28, 2017 at 5:35 | vote | accept | Stefan | ||
| Mar 17, 2017 at 12:15 | comment | added | user30184 | Yes, -update is for datasource and in this case it means that the same Spatialite database is updated - otherwise it will be overwritten. Take a backup if you want to try. For re-creating a layer use -overwrite, for adding new records use -append. Options are mostly documented in gdal.org/ogr2ogr.html. | |
| Mar 17, 2017 at 11:29 | comment | added | Stefan |
Nice solution. I've had it done more cumbersome. One short question: I've to use -overwrite in addition to -update to "update" the table (otherwise Error 1: Layer test already exists). Doesn't take the -update this into account?
|
|
| Mar 17, 2017 at 10:28 | comment | added | user30184 | Try the ogr2ogr solution that I added to my answer. | |
| Mar 17, 2017 at 10:26 | history | edited | user30184 | CC BY-SA 3.0 |
Show an ogr2ogr solution
|
| Mar 17, 2017 at 9:23 | comment | added | Stefan | Thank you. I see, I have to create a workaround: create table, update table with ogr2ogr, put these things in a QGIS Plugin (PyQGIS). | |
| Mar 17, 2017 at 9:12 | history | answered | user30184 | CC BY-SA 3.0 |