Questions tagged [spatialite-gui]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
34 views

Geometry loss/mix up of a spatialite view joining two tables

I have two Spatialite tables: - Sites (with geometry column) (ca. 5000 single sites) - Samples (ca. 6800 samples) To display the samples in QGIS I want to create a spatial view showing all samples at ...
0
votes
1answer
61 views

Spatialite - update query for bounding polygon using WITHIN

I have 2 spatialite polygon layers which represent land parcels and municipalities. Each parcel is within or intersects 0, 1 or 2 municipalities. I am trying to update a field within the parcel layer ...
1
vote
1answer
114 views

Find and split Multipolygons in spatialite

I have a spatialite table with more than 1100 Polygons. The geometry type in that table is multipolygon. There are only some real Multipolygons inside and I need only polygons. How can I find the ...
9
votes
1answer
300 views

Spatialite spatial queries do not function on GeoPackage

I have downloaded some data (as GeoPackages) from this excellent website: https://data.mfe.govt.nz/layer/52757-petroleum-wells/ and https://data.mfe.govt.nz/layer/52675-location-and-extent-of-nzs-...
1
vote
1answer
221 views

Why does the AddGeometryColumn function not exist in RSQLite?

I am trying to add the geometry to a new table with the following statement: library(RSQLite) # db.sqlite was created with spatialite-gui con <- dbConnect(RSQLite::SQLite(), dbname = "C:/GIS/db....
6
votes
1answer
248 views

Spatialite KNN view in QGIS

My task is to calculate the average ground survey level for each tree in my dataset, using the 3 closest survey points (optionally within a 3m radius of the tree). I want to write this in a Spatial ...
0
votes
1answer
254 views

Dissolve polygons in Spatialite - New Table has no Geometry

I have followed some examples for dissolving polygons in Spatialite and successfully created my simpler polygons: SELECT "col1" sum("total") AS "total", st_union("GEOMETRY") AS "GEOMETRY" FROM ...
0
votes
0answers
515 views

Spatialite: how to add column with reference key?

I'm quite new to Spatialite but I need to build a small geographical database. I created a table and now I need to add a new column to it and to associate to this column a foreign key. Is it possible ...
2
votes
0answers
450 views

Geopaparazzi does not recognize spatialite vector data

I have failed to use geometry data from a spatialite database in geopaparazzi. I have tried following steps as described in http://jgrasstechtips.blogspot.de/2015/01/how-to-properly-create-spatialite-...
1
vote
1answer
258 views

Problem when building network with spatialite-gui

I would like to find the shortest path between two points in the following graph and corresponding table: I am using spatialite-gui for windows version 1.2.1 and I am having a problem when building ...
11
votes
1answer
1k views

How can I properly rename a table in a SpatiaLite DB?

Spatial layers (tables) in SpatiaLite include various supporting objects and metadata, including triggers, indices, and entries in (at minimum) the geometry_columns table. I'm looking for (preferably) ...
1
vote
0answers
680 views

Using spatial index in spatialite query?

I posted this question originally Using nearest neighbor query in SpatiaLite? Using the answer given I was able to get the query working on some test data. However I am having trouble applying a ...
2
votes
3answers
427 views

In QGIS how do I edit/save data which has no geometries?

In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save). ...
3
votes
1answer
566 views

Spatialite WITH clause issue

I've encountered an issue: when I try to execute in Spatialite_GUI query that contains WITH clause I get SQL error: near "with": syntax error. Also WITH unlike SELECT and other keywords is not ...
3
votes
2answers
418 views

problem merging polygons based on a column value - using Spatialite

As I am unfamiliar with any tools I decided to try my luck with PostGis. I imported my data. and executed the query : create merged as select delomrade_code, st_union(geometry) from grunnkrets group ...
7
votes
3answers
3k views

Finding point closest to point on near feature?

I have a dataset osmMajor containing road data (from OSM; 670,780 features) and another dataset points containing some points of interest (500,000 points). For each feature in my point layer, I want ...
3
votes
1answer
490 views

Spatialite Table Difference in QGIS

I am see differences between tables when I view them in spatialite-gui and in QGIS. I have created a table, added columns, and updated the columns in spatialite-gui. Within spatialite-gui I can view ...