Questions tagged [spatialite-gui]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
50 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 ...
user avatar
  • 1,021
2 votes
0 answers
23 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 ...
user avatar
  • 763
0 votes
0 answers
85 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 ...
user avatar
0 votes
1 answer
230 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 ...
user avatar
  • 763
1 vote
1 answer
586 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 ...
user avatar
  • 346
12 votes
1 answer
871 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-...
user avatar
2 votes
1 answer
781 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....
user avatar
  • 403
7 votes
1 answer
346 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 ...
user avatar
  • 7,219
0 votes
1 answer
365 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 ...
user avatar
  • 437
0 votes
0 answers
595 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 ...
user avatar
  • 233
2 votes
0 answers
474 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-...
user avatar
  • 350
1 vote
1 answer
287 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 ...
user avatar
  • 323
11 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) ...
user avatar
1 vote
0 answers
768 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 ...
user avatar
  • 1,386
3 votes
3 answers
716 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). ...
user avatar
  • 2,860
3 votes
1 answer
630 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 ...
user avatar
  • 5,531
3 votes
2 answers
476 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 ...
user avatar
  • 193
7 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 ...
user avatar
  • 865
3 votes
1 answer
503 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 ...
user avatar
  • 9,203