Questions tagged [spatialite-gui]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
24 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
186 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
212 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
391 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
414 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
233 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
606 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
308 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
530 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
394 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
480 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 ...