New answers tagged spatialite
If you're working with spatialite, here's how to do what you want: The SQL format is INSERT INTO ... SELECT FROM ... So, suppose you have a permanent spatial table "trees" with columns attrib1, attrib2, attrib3. Now one of the field guys brings a new shapefile "new_trees" with equivalent fields col_x, col_y, col_z. You would import the new shapefile into ...
Maybe you can start to have a look at Vespucci. It is an opensource OSM editor for Android devices who can display map tiles mainly from OSM based sources, but it should be possible to display any other non-tiled map imagery, I assume. And inside Vespucci you can display the current GPS position, but I am not aware whether this is using any google service ...
It works quite fast for me. I used http://download.geofabrik.de/europe-latest.osm.pbf as sample data and converted the points layer into Spatialite database as ogr2ogr -f sqlite -dsco spatialite=yes europe_points.sqlite europe-latest.osm.pbf points -progress -lco spatial_index=no Then I created CSV file as ogr2ogr -f "CSV" commandtmp.csv ...
You can use Foreign Data Wrappers, as of Postgres 9.2 (I think), from within Postgres to register a connection to another data source, either a Postgres server on another machine, or a completely separate data source. CREATE EXTENSION postgres_fdw; CREATE SERVER foreign_spatial_lite FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'some_dbname', ...
You can only connected to one (and only one) database in the DB Manager to run the SQL window. So this is not possibly. Either your way of cloning the data, or making the join inside QGIS in the Properties > Joins tab of one of the layers.
Sandro Furieri, the author of Spatialite, explains in this post how to initialize Spatialite correctly: So the "new style" initialization is as follows: invoke first of all spatialite_alloc_connection() this will create an independent "connection object" containing any thread specific memory allocation. (this including XML and GEOS ...
If you're after a GUI solution, you can use the "Add Part" tool (QGIS >=2.2 only). First, make your layer editable. Then in an Attribute Table select a single row with a null geometry that you want to add a geometry to. Back in the map canvas, select the "Add Part" tool and draw your geometry. The null geometry will be replaced by your newly drawn shape.
Go to Processing -> Toolbox -> QGIS geoalgorithms -> Vector general tools -> Join attributes by location (if you don't see this algorithm, you might need to activate the "advanced interface" option at the bottom of the Processing Toolbox dock widget). This way you can save your results to several formats, including .sqlite.
Top 50 recent answers are included