Questions tagged [spatialite-gui]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
84 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 ...
raylight's user avatar
  • 1,231
2 votes
0 answers
33 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 ...
marcp's user avatar
  • 895
0 votes
0 answers
128 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 ...
Matthias's user avatar
0 votes
1 answer
463 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 ...
marcp's user avatar
  • 895
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 ...
Torsten's user avatar
  • 396
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-...
alphabetasoup's user avatar
4 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....
Novvier's user avatar
  • 444
7 votes
1 answer
384 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 ...
she_weeds's user avatar
  • 12.3k
0 votes
1 answer
415 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 ...
user15741's user avatar
  • 437
0 votes
0 answers
679 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 ...
SaraZanni's user avatar
  • 243
2 votes
0 answers
489 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-...
Ralf's user avatar
  • 380
1 vote
1 answer
314 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 ...
EliseB's user avatar
  • 353
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) ...
Lee Hachadoorian's user avatar
1 vote
0 answers
1k 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 ...
kflaw's user avatar
  • 1,416
3 votes
3 answers
933 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). ...
Rostranimin's user avatar
  • 2,980
3 votes
1 answer
686 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 ...
SS_Rebelious's user avatar
  • 5,611
3 votes
2 answers
512 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 ...
bodman's user avatar
  • 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 ...
Damien's user avatar
  • 915
3 votes
1 answer
523 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 ...
Ryan Garnett's user avatar
  • 9,459