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

learn more… | top users | synonyms

0
votes
1answer
26 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
26 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 ...
0
votes
2answers
46 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
32 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
36 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
72 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 ...
1
vote
1answer
33 views

Qspatialite not loading in QGIS 2.6.1 for Mac

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? Any ...
1
vote
0answers
23 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
163 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
115 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 ...
0
votes
1answer
194 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
33 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
477 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. How is it possible to do that ? I found nothing on the internet. Thanks
1
vote
1answer
637 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
vote
1answer
450 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 ...