New answers tagged

3

Concerning your first request (concatenate the list of unique lot id's which are bound within a radius of 30m from the given lot), I guess you can do that with a SQL query in QGIS : SELECT b.id as ID_ref, group_concat(a.id) AS ID_within_30m FROM city_lots a, city_lots b WHERE b.id = 1 AND b.id != a.id AND ST_Distance(a.GEOM, b.GEOM) < 30; ...


4

QGIS has its own internal handling of layers and features. Different data "providers" are used to pull layers in from a variety of sources (eg PostGIS, OGR file types, WFS servers, etc) and translate them into QGIS' own internal formats. Once you have a project fully loaded, including a .shp file plus a .dbf, plus another CSV joined, are all the data in ...


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


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



Top 50 recent answers are included