Questions tagged [qspatialite]
QSpatiaLite is a plugin for managing SpatiaLite databases directly within QGIS.
24
questions
4
votes
1
answer
1k
views
Spatialite view appears 'filtered' in attribute table, won't load in canvas
I have a points table (all_trees) and polygons table (workareas) and a view (affected_trees_view) as follows:
SELECT * FROM all_trees, workareas
WHERE intersects(st_buffer(
...
- 10.8k
2
votes
1
answer
212
views
Spatialite return XY coordinate in Double Precision
I'm trying to return the first vertex of a polyline in QspatiaLite. The spatial function x() is used, but it returns an integer coordinate value. How can I return the coordinate value as double ...
- 687
2
votes
1
answer
93
views
QGis QSpatialite plugin corrupting dates when importing layers
I'm using Qspatialite version 7.0.4 in QGis 2.14. We use QSpatialite to save selected polygons from an MSSQL (2008) layer into spatialite databases.
Since Qgis 2.14 we have noticed that any dates ...
- 21
3
votes
2
answers
395
views
How to save a Spatialite join in QGIS?
I've loaded a v.large shapefile (~2GB) into Spatialite in QGIS and a non-spatial table (from a csv, 8 MB) in there as well (via the QSpatialite GUI).
They have successfully been joined in QGIS. They ...
- 510
3
votes
1
answer
390
views
QSpatialite broken after update to QGIS 2.18
Lately I updated from QGIS 2.14 (LTS) to 2.18 on Mac OS X. Since then, the QSpatiaLite plugin has ceased to work, yielding following error message:
I have tried the following to repair the problem, ...
- 83
2
votes
1
answer
53
views
Identifying type of QspatiaLite field?
I am using QspatiaLite in QGIS 2.14.
I am having problem updating a column of my table and I suspect that the types (integer, real, text etc.) are not consistent.
How can I know which are the types ...
2
votes
2
answers
84
views
Correct syntax for loading virtualxl spatialite table?
I believe I have successfully loaded a virtual Excel table into a spatialite database using the SQL below - typed into the qspatialite plugin for QGIS.
create VIRTUAL TABLE MyVirtualTable1 USING ...
- 2,982
1
vote
0
answers
68
views
Why does QSpatialite show the same table twice?
I have created a point table in QSpatialite, by creating a new table first and then adding a geometry column, as described here.
The table shows up twice in QSpatialite, which surprised me a bit:
I ...
- 329
1
vote
0
answers
78
views
Finding point on line closest to other point: unexpected results [closed]
I'm basically trying to do the same thing as outlined here: Finding the point closest to a point on a near feature
However, the results I'm getting with the queries suggested in the accepted answer ...
- 329
1
vote
1
answer
558
views
Create primary and foreign key on Spatialite
I try to create a database on spatialite (for various reason, I can't use PostGis). I need to link a table to another one using a foreign key.
The problem with spatialite is that it is not possible to ...
- 449
0
votes
1
answer
543
views
Error doing st_union in spatialite
I have a multipolygon layer in which I want to dissolved based on a class column. The steps I'm doing are:
create table tc_2010_00567 (gid int primary key, tc_2010 text(32));
select addGeometryColumn(...
- 2,433
2
votes
2
answers
2k
views
Performing spatial join in Spatialite (QspatiaLite for QGIS)
I'm trying to spatially join and summarize the attributes of a set of buildings to a set of containing parcels. There are (potentially) many buildings to each one parcel.
Here is the query as I'm ...
- 21
0
votes
1
answer
62
views
Spatialite table column is function in itself
GOAL: I'm trying to filter all the 1's in a spatial boolean operation in Qspatialite, the spatialite plugin for QGIS.
ATTEMPTED SOLUTION: My solution is to perform the boolean query first, export the ...
- 271
1
vote
1
answer
403
views
Spatialite ST_area(geom) won't compute for GeomObject
I extracted a dataset from Wikimapia via API using .kml download --> ogr2ogr .kml to GML -explodecollections --> GML to .shp only LINESTRING part of geometry collection.
Running QSpatiatlie in QGIS, ...
- 271
0
votes
1
answer
608
views
QSpatiaLite Plugin: LINESTRINGZ(x y z, ...) supported?
I get an error when trying to import this query as a spatial table in QGIS:
select geomFromText('LINESTRING Z(13.091464 47.061328 2597, 13.092059 47.061287 2580)') as geometry
'The result can't be ...
- 1,856
1
vote
1
answer
52
views
Qspatialite not loading in QGIS 2.6.1 for Mac [closed]
I am running QGIS 2.6.1 on MacOS (Mavricks). I have reinstalled the Qspatialite plugin, and am still encountering the same issue. The plugin will not open. Has anyone seen/over come this issue?
- 9,461
1
vote
0
answers
47
views
SpatiaLite / QspatiaLite: get subgroup row ids
I'm using QspatiaLite plugin to join polygon ids to points that are within those polygons. Now I' d like to get subgroup rownumbers for each subgroup of points with same polygon id! Like so..
grp_ID |...
- 1,856
2
votes
1
answer
346
views
Python Error while installing QSpatiaLite in QGIS 2.0
I'd like to install QSpatiaLite to my QGIS2.0 but the following error massage occured while installing with the pluginmanager:
Couldn't load plugin QspatiaLite due an error when calling its ...
- 8,254
1
vote
1
answer
405
views
Can't open Spatialite plugin in QGIS
After installation, I got the error messages below when I click the Spatialite (V.7) Plugins:
An error has occurred while executing Python code:
Traceback (most recent call last):
File "C:\Users\...
- 109
0
votes
1
answer
1k
views
No module named pyspatialite- plugin:Qspatialite, OpenSUSE 13.1
I cannot run the plugin because of module missing.
I can't find that module in the OpenSuse repository, and python community repository.
I'm using QGIS 2,0 and OpenSuse 13,1
Where can I find ...
- 193
0
votes
1
answer
40
views
Is the Qspatialite 6.0.8 font for SQL free text supposed to be huge?
A week ago I upgraded my Qspatialite plugin in QGIS 1.8, which I frequently use in parallel with Spatialite_GUI, to get the best of both Sqlite worlds. I immediately noticed that my SQL free text ...
- 1,620
1
vote
1
answer
1k
views
QSpatialite : Import multiple TXT / CSV?
I'm using QSpatialite only. I don't have spatialite-gui, neither the shell.
I want to import multiple TXT/CSV at one time, but I found nothing on the internet.
How is it possible to do this?
- 269
1
vote
1
answer
2k
views
Why doesn't SQL sum(dollar) work in SQLITE?
I've got a sqlite table with real numbers, two decimal place precision, in a mydollar_column. (There are no null values, but some of the values are negative numbers) For some reason, using sql on ...
- 1,620
2
votes
1
answer
1k
views
How to save a joined spatialite table when each table contains PKUID fields?
QGIS 1.8.0 --
QSpatialite 6.0.7 --
Windows XP
I have spatialite tables joined together that I need to save as a single table, but an error-message says that QGIS can't save the table because there ...
- 1,620