Questions tagged [qspatialite]

QSpatiaLite is a plugin for managing SpatiaLite databases directly within QGIS.

Filter by
Sorted by
Tagged with
3
votes
1answer
420 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( ...
2
votes
1answer
82 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 ...
2
votes
1answer
71 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 ...
3
votes
2answers
307 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 ...
3
votes
1answer
348 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, ...
2
votes
1answer
52 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
2answers
45 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 ...
1
vote
0answers
62 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 ...
1
vote
0answers
65 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 ...
1
vote
1answer
373 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 ...
0
votes
1answer
261 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
votes
2answers
966 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 ...
0
votes
1answer
56 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 ...
1
vote
1answer
210 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, ...
0
votes
1answer
495 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
vote
1answer
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?
1
vote
0answers
44 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 |...
2
votes
1answer
334 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 ...
1
vote
1answer
334 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\...
0
votes
1answer
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 ...
0
votes
1answer
37 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
vote
1answer
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?
1
vote
1answer
1k 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 ...
2
votes
1answer
963 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 ...