New answers tagged

4

Use Spatialite Database! It is a lightweight file based spatial DB supported out of the box by QGIS. First set-up a spatialite DB following theses instructions Push your two tables to this spatialite DB using QGIS DB manager Assuming that your tables are called "polygon" and "line" run the following SQL command in DB manager query interface. SELECT ...


0

The Windows command was useful to help to port to Linux Bash. You will find this Bash version below: for file in *.tab; do if [[ ! -f "merged.sqlite" ]]; then ogr2ogr -f "SQLite" "merged.sqlite" $file -nln merged -nlt PROMOTE_TO_MULTI -dsco SPATIALITE=YES; else ogr2ogr -f "SQLite" -update -append "merged.sqlite" $file -nln merged ...


2

I do this with: echo [% "id" %]," [% "name" %], [% "year" %] OBSERVATION: If you have two or more point in the same local, you will get only one response. I need the next response, if someone knows how to do: id name year (for point 3) id name year (for point 3) id name year (for point 3) example: 17 Elsa 1985 ...


3

The "read_only" table obviously needs some input, as I could not find anything in the cookbook, after some search I found this insightful discussion with mr. furieri himself: https://groups.google.com/forum/#!topic/spatialite-users/n8l977RL9-0 conclusion: 1 = TRUE = ReadOnly View (unsupported write ops) 0 = FALSE = Not ReadOnly, thus Writable View So ...


0

Not sure but a workaround could be: Export the layer as a shapefile (right-click > "Save As...") Try and delete the desired feature now Save and import the layer back into the Spatialite database using the QspatialLite plugin (You may need to install this from the toolbar: Plugins > Manage and Install Plugins)



Top 50 recent answers are included