1
vote
1answer
29 views

How to save multiple layers from QGIS to a Spatialite db?

I thought I had asked this before but I can't find any trace of it. Each time I save a layer from QGIS as a spatialite it insists on creating a new db ( if you select a existing db you are asked ...
3
votes
1answer
44 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 ...
2
votes
0answers
35 views

QGIS “Fill Ring” tool error on SpatiaLite DB?

I´m try Fill Ring tool on a SpatiaLite DB and I get a error on the Primary Key. The Primary Key is integer auto increment. When I insert the ring and try to save editing I receive error message ...
1
vote
1answer
27 views

Spatialite error: obsolete libspatialite

I am learning to use QGIS with the QGIS training manual (from the QGIS website). One of the excercises is to load vector data from a database (ch 3.1.3 in case you have the manual). When I try to do ...
2
votes
1answer
74 views

Layer with custom UI not working properly

I have a problem with QGIS 2.4 when introducing layers with a custom UI. More precisely, widgets such as CheckBoxes are not recognised as such (appear as Text Edit in Attributes) and the corresponding ...
1
vote
0answers
46 views

Loading SQLite extensions in QGIS

I have an extension which can be loaded in SQLite using the load_extension function. It would be useful for me if I could load it in QGIS to use in queries made via Database Manager. The Python ...
2
votes
0answers
71 views

Exporting spatialite view to shapefile from QGIS modifies the original data types

We have a spatialite .sqlite database where we have views which are nicely rendered by QGis, with all the symbols and everything!! There are integer fields on the view which are based on fields of ...
0
votes
1answer
89 views

PyQGis - Working with Spatialite

I wrote a Vector layer to a spatialite file/db using the dedicated API tool, using valid driver names supported formats by OGR. When connecting to that db, I can't retrieve properly the geometry ...
3
votes
2answers
66 views

Is it possible to decrease detail level (decrease file size) in Spatialite OSM export?

I currently use Spatialite exports from OSM data (together with Google maps like styles by Underdark) which are very useful for me as the files are easily portable with the project and I do not need ...
3
votes
2answers
99 views

Incorrect display of national characters from Spatialite in QGIS, Windows

I used this tutorial by Underdark (thanks much :-) ) to convert my area of interest from OSM file (whole Czech Republic downloaded from Geofabrik.de server). Used OSGEO4W shell (saying "GDAL 1.11.0, ...
1
vote
1answer
41 views

What causes this error when loading plugin

After installing pyspatialite on my Mac two plugins fail to load with this error:: This plugin is broken invalid literal for int() with base 10: '2-spatialite' I am fairly sure that the offending ...
3
votes
1answer
55 views

Does QGIS automatically use spatialite spatial indexes?

When you write a query in spatialite you have to manually join your query to the spatial index for that index to be used to speed up the query. When QGIS displays data does it take advantage of any ...
1
vote
2answers
127 views

TatukGIS SQLite Spatial vs. Spatialite

I must apologize in advance, I'm just getting into GIS and trying to figure things out. I have an SQLite spatial database that I'm pretty sure was created in TatukGIS. I've tried to open it in QGIS ...
0
votes
0answers
42 views

How to overlay polygons that are in the same layer

I need to INTERSECT many polygons that are in the same layer. Actually each polygons from my layer represent an area of influence from one specific bird species. Since I used to use ArcMap, I found ...
3
votes
2answers
154 views

Combining MS Office with GIS

I would like to incorporate MS Office into my GIS program. I have been using QGIS and was wondering if this would be possible? I am trying to create a one stop shop for my staff to be able to ...
1
vote
3answers
123 views

How to add columns with x/y data to Spatialite Layer? [closed]

I´m new here and I am also quite new at working with QGIS. My Spatialite Database looks like this (arch_locations.sqlite) Fields: pkuid short_ID name geometry I´d also like to have two additional ...
0
votes
0answers
88 views

QGIS custom form and autocompleted data entering with “validation check”

In Qt-Designer I created a custom form where I can choose serveral species names in two different combo boxes. This combo boxes are linked via "value relation" to the accordant non spatial tables ...
1
vote
1answer
95 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 ...
1
vote
0answers
50 views

joining polylines on geometry and attribute

I have dowloaded an Open street Map shapefile containing streets and their attributes, for my whole country. I have qgis and spatialite_gui and a very basic understanding of SQL The problem I have is ...
0
votes
2answers
103 views

Have I created a valid Spatialite database?

I didn't manage to find the better way to populate the exisiting Spatialite database with new computed data than just creating new columns and filling them in the Python script. You can see that the ...
2
votes
0answers
114 views

How to eliminate gaps and overlaps in a layer of SpatiaLite table?

I'm try to snap all polygons in a table to remove gaps and overlaps. I can remove gaps but get new overlaps. I have no idea what doing wrong... sorry, I'm new in SpatiaLite. I tried the following: ...
3
votes
0answers
127 views

Why does the QgsVectorFileWriter have probelms creating vector files? [closed]

I am using QGis 2.0.1 and have tried to create a new GIS feature file (SQLite, Spatialite, and Shapefile) of a subset of the data. I am then saving a copy of the style of this layer and applying it to ...
0
votes
1answer
47 views

Fail to get heatmap from MULTIPOINT column of Spatialite layer in QGIS?

I got a heatmap from a POINT column of spatialite layer. But, when I made another heatmap from MULTIPOINT column, it was blank. What is the possible reason of this problem?
1
vote
0answers
54 views

Problems with connecting QDateEdit and QTimeEdit widgets to corresponding Field in QGIS Layer (shp/spatialite)

Could anybody give me a hint how to connect the QDateEdit and the QTimeEdit widgets with a field in a QGIS layer (shp or spatialite). The fields in the QGIS layers are from datatype "date" ...
4
votes
2answers
306 views

Binding between QGIS custom form (Qt Designer) and date/time field in a SpatiaLite database table

For my attribute table I created a custom form in Qt Designer. The table has a date field and a time field. In Qt Designer there are widgets for entering date and time. But what data type is expected ...
0
votes
2answers
96 views

Robust importing of shapefile into spatialite database?

I am trying to import shapefiles into a spatialite database using spatialite-gui. I am having problems with the types of the variables since spatialite-gui has no obvious way to handle shapes which ...
1
vote
1answer
74 views

draw multipart polygon with one surrounding border

As you can see on the image below, the waterbody is divided by the border line because it consists of several polygons. I could merge the polygon, but I dont want to change the shapefile. Is there ...
0
votes
2answers
151 views

QGIS 2.0, SpatiaLite: labels disappear after setting data defined position (x,y)

I added to my SpatiaLite table (.osm-import with the "standard" QGIS-OSM-Plugin) two empty columns x and y (double) to define manually the position of my labels (data defined labeling). But after ...
1
vote
0answers
132 views

How to create a spatial view when allowing multiple selection in qgis’s edit widget “value relation”?

I've a point layer in qgis and serveral non spatial tables in a spatialite database. In qgis the fields were filled using the edit widget "value relation" (multiple selection allowed for some fields). ...
0
votes
0answers
63 views

Is there a limitation in quantity of joined tables using spatialite views?

I've one point layer in qgis and several non spatial tables in a spatialite database. Now I want to create a view as you can see in the following: CREATE VIEW testansicht10 AS SELECT ...
3
votes
1answer
74 views

Rasterlite db with multi table

When working with Spatialite DBs, I can store multiple tables in single DB. But now I want to store multiple raster tables on a single Rasterlite DB. I tried QGIS for conversion but it converts only ...
1
vote
2answers
197 views

QGIS export ESRI Shapefile to SpatiaLite format issue

I am trying to export a shapefile of 3221 mixed POLYGON and MULTIPOLYGON geometry elements and every time, I get this same error: Does anyone have any idea what's going on? And no, this is not an ...
2
votes
2answers
59 views

How can I display a spatialLite view in a custom data sheet with print composer

I created a spatiaLite Database with a point layer (every point is a tree). Additional I created several tables to fill the columns of the spatial layer with attributes using the editing widget “value ...
3
votes
1answer
71 views

How to create a printable data sheet when using edit widget “value realtion” in QGIS 2.0?

I created a spatiaLite Database with a point layer (every point is a tree). Additional I created several tables to fill the columns of the spatial layer with attributes using the editing widget “value ...
0
votes
1answer
147 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 ...
7
votes
2answers
462 views

How do I use the Natural Earth SQLite DB with QGIS?

I just downloaded the Natural Earth data in SQLite format from http://www.naturalearthdata.com/downloads/. I had assumed that this would be a SpatiaLite database, but it appears not to be! QGIS is ...
0
votes
0answers
80 views

QGIS, SpatiaLite and GPS integration

I have QGIS an, access database and a Haicom gps all connected and running on a windows 8 machine. I want to integrate all 3 items so that while in the field i can enter information into the ...
0
votes
0answers
26 views

The names of all the tables created are forced to be converted into lowercase in Pyspatialite 3.0.1

after the update of PYSPATIALITE from 2.3.1-3 to 3.0.1-1 in QGIS, the names of the all the table created by SQLite3 are forced to be converted into lowercase. After fallback to 2.3.1-3, the issue ...
0
votes
1answer
57 views

QGIS Save as Spatialite layer from FileGDB does not add OGC_FID

I have previously (yesterday) been able to save a Spatialite layer from a FileGDB feature class using the Right click/Save as... method in QGIS. Today, however, with no changes to any software (tried ...
3
votes
0answers
136 views

Handling non-spatial data for QGIS projects with Camelot

Most of my projects include data which is non-spatial or which is point data and can be managed by a regular relational database. Previously I found Manifold and ms-access were a good combination ...
4
votes
2answers
176 views

can Well Known Text tables be used effectively, stored in Access or Base?

My question is: How do I import WKT text data back into QGIS, and how useful could Base or Access be in storing the data using WKT rather than spatially enabling it within a proper GIS database, like ...
4
votes
1answer
381 views

Can Spatialite SQL statements be issued with a python script in QGIS?

In my previous scripting environments (ms-access and Manifold GIS), it was possible to create and execute SQL queries from withing VBA or VB Script procedures. This is really useful for things such ...
1
vote
1answer
125 views

Can SQLite and SpatialLite files be linked

Coming from a ms-access background, it is common to split up larger applications into several database files. An ms-access database can then access data that is in another database via a linked ...
1
vote
0answers
206 views

Qgis 1.8.0 throws error “Can not find the entry point sqlite3_rtree_geometry_callback”

Loading QGIS on Window 8 causes this problem: Can not find the entry point sqlite3_rtree_geometry_callback in the procedure of dynamic loading C:\....\Quantum GIS Lisboa \ bin \ spatialite.dll ...
3
votes
2answers
384 views

Is it possible to embed QGIS layer styles in a Spatialite database?

Spatialite is a great alternative to shapefiles - but how could I store the QGIS layer style together with the data so that it has a default style? For a shapefile I would just save a [name].qml with ...
6
votes
0answers
199 views

How does Spatialite handle concurrent access?

I understand that Spatialite is meant to be used by a single user/machine at a time. However if the data is stored on server, there is no guarantee that someone on another machine will not also open ...
2
votes
2answers
104 views

How to hand over polygon attribute to new point while digitizing?

My task is to work with bird observation data in an area, that is divided into zones as different polygons (A1, A2, etc.). I have the hand-written lists of observations and want to bring all entries ...
1
vote
1answer
294 views

QGIS - adding timestamps to spatialite data during data collection

I am trying to do field data collection using QGIS. One of the features that I regard as necessary for data management is timestamps. For example, a timestamp can indicate that an inspection record ...
6
votes
1answer
700 views

Is SpatiaLite or SQLite Spatial an Accepted Standard?

The reason why I ask this is because I have been undertaking some testing and have found that there seems to be many implementation and not all of them are interchangeable. For example: FME can read ...
0
votes
0answers
169 views

Point in polygon analysis fails with “TypeError: arguments did not match any overloaded call”

I am using QGIS 1.8 on Windows 7 I want to perform a point in polygon analysis using the Vector > Analysis Tools menu. My point layer is the result of a SpatiaLite query which returns 10'000 points. ...