SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.

learn more… | top users | synonyms

3
votes
2answers
162 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
34 views

How to Set SRID in Spatialite

How do you update the SRID in a SpatiaLite table? I am using the QspatiaLite plugin or the SpatiaLite_Gui program to send this SQL to the table: UPDATE myTable SET geom = SETSRID(geom,26910) ...but ...
0
votes
1answer
125 views

Can't build x64 SQLite with spatiaLite

I need a spatial-enabled SQLite solution for a x64 Windows application I am developing. I have examined and downloaded and attempted to compile the SQLite amalgamation package; I've looked at the ...
0
votes
1answer
21 views

Not able to load a DEM raster into Spatialite

I am using Spatialite to store a DEM raster with terrain values (GMTED2010 from Nasa). To be more precise, I am using the version: spatialite_gui-1.7.1-win-x86.zip plus rasterlite_load ...
0
votes
0answers
96 views

QGIS spatial query cryptic error message

I tried running a spatial query plugin to return features in SpatialLite layer that fall within selected feature on MapInfo .TAB layer, which worked fine, selecting 3 items. But when I tried creating ...
1
vote
1answer
237 views

Create Buffer in meters Spatialite query

I am new to Spatialite. I have following query: select A.* from linka as A, pointa as B where Contains(Buffer(B.Geometry, 100), A.Geometry) Here, A.Geometry = LINESTRING(23.2161 69.95237, ...
0
votes
0answers
14 views

Running SQL on already opened SpatiaLite database

I am updating a plugin in QGIS 2.2 and would like to run sql on a SpatiaLite layer (nodes). The database is already loaded and the table is loaded as a vector layer in QGIS. Is there a way I can ...
2
votes
1answer
36 views

Creating Spatialite DB from Swedish OSM

Good afternoon, I have just started to use GDAL/OGR and I am trying to create a spatialite DB from OSM data. I am using a cut of the Swedish OSM data downloaded from Geofabrik in .osm format. I have ...
2
votes
0answers
169 views

Performance issue with SQLite + Spatialite + C#

I am having a performance issue with SQLite database (.db) which extends to SPATIALITE I am trying to update Geometry of 1,00,000 records in database (.db) which taking around 50 minutes. Too much ...
1
vote
1answer
12 views

Can't understand Return value in gaiaLineLocatePoint_r

I am trying to develop a C application that finds the nearest point on a linestring from another point, in spatialite. I found the two API's gaiaLineLocatePoint_r and gaiaLineLocatePoint , but I am ...
4
votes
2answers
365 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 ...
14
votes
2answers
2k views

How to turn sqlite lat/lon columns to spatialite geometry?

I have a sqlite database with a table that has a column for longitude and one for latitude. Is there a way to make this data base 'spatial'?
2
votes
1answer
34 views

Why can't I add a Spatialite table with clip results in QGIS?

I have 2 layers and I want to make a clip of layer 1 with layer 2 in SpatiaLite (I'm using the DB Manager within QGIS). That's the code I'm using: create table clipped_lines as select * from lines, ...
2
votes
1answer
99 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 ...
2
votes
1answer
318 views

Configuring spatialite database access for Python 2.6.6

I'm working on a GIS project, and I would like to implement and test some geo-spatial algorithms in Python. For this purpose, I will not only need sqlite, but also spatialite, in order to store and ...
3
votes
2answers
472 views

What's a good way store borehole data in SQLite / SpatiaLite?

I have a bunch of bores / wells with downhole data. The 'header' info for each borehole can easily go into a single table, but I'm wondering how best to store the downhole log data. Typically they are ...
0
votes
0answers
31 views

QspatiaLite Snapping fails if multiple target vertices within tolerance distance

I assumed that SpatiaLite's Snapping would snap to the nearest candidate vertex - however, it turned out that the result becomes unpredictable, if there are several target vertices within tolerance ...
4
votes
1answer
138 views

ST_Touches function in Spatialite

I'm a newbie to Spatialite so forgive me if the answer to my question is obvious...(I tried looking online but couldn't find the answer to this question). I am trying to use the function ST_touches in ...
2
votes
3answers
55 views

Need to extract OSM data for my area from 2 neighbor countries

I need to prepare offline background data for my area of interest which is located around border between Czech Republic and Germany. I need to convert the OSM data to spatialite and then to use in ...
3
votes
0answers
77 views

Preserve datatypes when using SQLite and QGIS

Following Nathan's SpatiaLite/DBManager solution in this answer, I find that once the layer is loaded from DB Manager into QGIS (2.6.1), any calculated fields are appearing as text values instead of ...
1
vote
0answers
15 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 ...
9
votes
3answers
266 views

A global, grid-like projection for creating heatmaps

I'm putting together an application where I need to create a vector grid which will be used to store and display a heatmap. It has the following requirements: Can cover the entire planet. The vast ...
0
votes
1answer
60 views

Spatialite in GeoDjango - “…they do not properly define db_type…”

I've started a new project and choose GeoDjango for it. Because I already developed with Django and sqlite as a DBMS and all worked perfectly fine for me, I found it a great option to use spatialite ...
0
votes
0answers
25 views

QGIS 2.4 - DB Manager - Spatialite Database - Added columns not shown - How to apply fix by Kuhn?

First: I´m only using the built in menus of QGIS 2.4, not entering code manually. I have a simple Spatialite Database with a Polygon Layer and two columns (Text_ID and Description). I used DB Manager ...
2
votes
1answer
124 views

spatialite - azimuth function not available

I am working with last spatialite versions on both Windows (7) and Ubuntu (13.10). I installed these from reference spatialite website. For both, version that I downloaded is 4.1.1 (nevertheless in ...
9
votes
5answers
1k views

How to build a geographic database of GPS logs?

On our aerial wildlife surveys we typically generate dozens of GPX files, and usually convert most of them into shapefiles for display in a GIS application. GPX files are a terrific way of keeping all ...
1
vote
1answer
41 views

How to create temporary tables in spatialite?

How do you create a temporary table with geometry column in spatialite? I have tried: CREATE TEMP TABLE rivers (code INTEGER, id INTEGER, name TEXT); Followed by: SELECT ...
1
vote
0answers
76 views

Simplifying geometries and calculating non-spatial averages

I'm quite new to using proper spatial tools, and have a simple question that doesn't immediately show up on google. I have a table that contains multiple rows of empiric data (say, speed of a ...
1
vote
1answer
34 views

Splitting multiline into several same-length multilines

Is there a method to convert a multiline geometry into several multiline geometries having the same length? For example break this: MULTILINESTRING((1 1, 3 1, 3 1.5, 2.5 1.5)) Into [approximately] ...
2
votes
0answers
34 views

ogr2ogr fileGDB translating points

I am converting data from spatialite to fileGDB (and reverse) for a project using QGIS and ArcGIS. When I convert using ogr2ogr (or QGIS) from spatialite to fileGDB, the points are translated ...
8
votes
1answer
257 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 ...
0
votes
0answers
46 views

QGIS vector edition corrupts SpatiaLite attribute table

I have a problem with edit SpatiaLite Layer on QGIS. When I make a this set of editions: cut line, delete a part, insert a new line and save it, the attribute table is corrupted. I was thought that ...
0
votes
1answer
43 views

SpatiaLite - WITH, view or sub-query?

I am running on Windows 8.1 SpatiaLite_gui 1.8.0, SpatiaLite version 4.2.0 and SQLite 3.8.5. I need to interrogate one single spatial table whith those attributes: ID | val | val_1 | val_2 | Geom ...
3
votes
1answer
71 views

QGIS Quantile method

I have a question about the quantile classification in QGIS (2.6 and master, windows or linux). I used the points in polygon fonction. I have 100 polygons. In the attributes of my 100 polygon I get ...
0
votes
1answer
43 views

Check if point is near a linestring Spatialite

I have a LINESTRING made of two points start point and end point in spatialite. UPDATE points SET road_geometry = GeomFromText('LINESTRING(24.889142 67.196188, 24.889673 67.196579)',4326) where ...
0
votes
1answer
9 views

How to drop a table in spatialite that starts with a certain string?

I am using spatialite (v4.2.0) on a Windows 7 (64bit) PC. I need a way to drop a specific table that always begins with "_old" from my database. The file may not be in the database in the first ...
1
vote
1answer
44 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 ...
1
vote
2answers
228 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 ...
1
vote
1answer
36 views

How to create non-duplicate lines between all selected points in Spatialite?

There is a nice answer for the similar question for PostGIS. I tried to adapt it for my case where I need to connect all points from a point layer, but unfortunately I get duplicate geometries: lines ...
3
votes
1answer
72 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
212 views

Sqlite insert java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: SRID)

I'm trying to connect to two DBs and then copy tables by inserting rows from one table to another through java using JDBC. I'm using sqlite-jdbc-3.7.2.jar plugin.The setup is in Eclipse Luna. I'm ...
1
vote
1answer
34 views

Only my geometry layers are exported from spatialite to postgis

I have a spatialite database (v4.1.1 / SQlite v3.7.17) consisting of one geometry table and several attribute tables linked to the geometry table by foreign keys. I want to export all tables to a ...
2
votes
0answers
37 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
62 views

How can I reproject a layer in a spatialite database

I'm writing an android mobile application and, for performance reasons, I want to reproject my layers to match the basemap's projection. Is there a command to do that?
2
votes
1answer
81 views

How do I link OGR with spatialite?

Problem & Evidence: I'm trying to create a spatialite file with the code snippet below. However the outDataSource object gets assigned NoneType and all subsequent (unshown) code fails. I'm ...
0
votes
1answer
53 views

Explicitly close a OGR result object from a call to ExecuteSQL

How can I explicitly close/release the result of an ExecuteSQL statement when querying a Spatialite database with OGR via Python? I have a simple query to return the SRID of a dataset. This works as ...
1
vote
1answer
53 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 ...
1
vote
0answers
63 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
1answer
43 views

How to rename ogr2ogr tables on export to Spatialite?

I'm exporting data from PostGIS to Spatialite using ogr2ogr. The export is working properly, except I need to be able to rename the tables that are being exported. Here's the command I'm using: ...
1
vote
3answers
59 views

Is there a way to add an autoincrementing primary key field to an existing spatialite table/layer?

I know that I can add a new column to a spatialite table either through the Database Manager (Edit Table – Add Column) or through the Attribute Table – Field Calculator (create new field) but I don´t ...