Questions tagged [spatialite-gui]
The spatialite-gui tag has no usage guidance.
19
questions
1
vote
1
answer
79
views
Is there any way of making queries that contain special characters like 'ã' in spatialite-gui?
I have a Spatialite database file that has some special characters inside their columns as the following:
Here there's the word "Itapoã"... The problem is that all the times that I try to ...
- 1,221
2
votes
0
answers
29
views
How to remove 'orphan' tables in SpatiaLite database
I have a SpatiaLite (4.3) database created in QGIS that I have modified numerous times using the SpatiaLite-GUI. I've realized today that when I add a table within QGIS from that DB, the selection ...
- 853
0
votes
0
answers
127
views
Geometry loss/mix up of 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 ...
- 41
0
votes
1
answer
431
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 ...
- 853
2
votes
1
answer
1k
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 ...
- 386
12
votes
1
answer
1k
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-...
- 8,608
3
votes
1
answer
1k
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....
- 424
7
votes
1
answer
380
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 ...
- 10.8k
0
votes
1
answer
408
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 ...
- 437
0
votes
0
answers
668
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 ...
- 243
2
votes
0
answers
488
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-...
- 370
1
vote
1
answer
311
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 ...
- 343
12
votes
1
answer
2k
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) ...
- 4,605
1
vote
0
answers
989
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 ...
- 1,396
3
votes
3
answers
880
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).
...
- 2,982
3
votes
1
answer
681
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 ...
- 5,601
3
votes
2
answers
503
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 ...
- 193
8
votes
3
answers
4k
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 ...
- 895
3
votes
1
answer
521
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 ...
- 9,461