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

learn more… | top users | synonyms

0
votes
0answers
10 views

High-performance k-nearest neighbor MBRs from given point using spatialite?

I've built an 2-dimensional spatialite db with millions of polygons inside. What I want to do is to find the polygon which is the nearest from given (x,y) coordinate. This is what I want to do. ...
0
votes
1answer
27 views

How can I load sqlite file into oracle 11g?

I have SQLite file which I have taken it from Sptialite DB. I need to convert this file into SDO. Plz help me
1
vote
1answer
31 views

Loading multiple SpatiaLite layers into a single database

I have many SpatiaLite layers, each in a separate database. I want to load all these SpatiaLite layers into a single database. How can this be done?
0
votes
0answers
15 views

Newline appears after when converting shapefile to spatialite

I converted a layer from a shapefile format to spatialite. A line is added in the spatialite layer but record is not created in the attribute table (similar to multipart geometry). Shape file to ...
1
vote
1answer
38 views

In QGIS how do I edit/save data which has no geometries?

In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save). ...
0
votes
1answer
14 views

which spatial server goes better with raster images stored in DB Spatialite?

I would like to serve images from Spatialite as WMS services. As far as I know: Geoserver is compatible with vector features only -if you install the extension-, but not with spatialite BLOBs (in ...
-2
votes
0answers
44 views

GUI that queries from Spatialite Database

I am developing a GUI that has three drop down say state, cities and distance. The output needs to be a CSV file with the cities within that radius. What I want is the full data is placed in ...
1
vote
0answers
12 views

geodjango difficulties with srid

I'm trying to make geodjango app. I'm using SQLite and SpatialLite. I want to add shops, and be able to sort them from closest to furthest from my location. When in my model I have: location = ...
1
vote
1answer
70 views

Adding Nodes to Linestrings at Overlapping Points with Polygon Layer in Spatialite

I have two Spatialite tables. A table called 'lines' which contains a PK column called OGC_FID and a LINESTRING column called GEOM. A table called polys which contains a PK column called OGC_FID and ...
1
vote
1answer
54 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
2answers
32 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
18 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
48 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
1answer
43 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, ...
0
votes
0answers
33 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 ...
3
votes
0answers
85 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
18 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
3answers
59 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 ...
0
votes
0answers
56 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 ...
0
votes
1answer
78 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 ...
1
vote
1answer
48 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
1answer
36 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] ...
1
vote
0answers
86 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 ...
2
votes
0answers
48 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 ...
0
votes
0answers
48 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
49 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
87 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
56 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
10 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
58 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
1answer
37 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
80 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
266 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
42 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
38 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
75 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?
0
votes
1answer
64 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
72 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
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 ...
2
votes
1answer
104 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 ...
2
votes
1answer
114 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
46 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
0answers
69 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 ...
9
votes
3answers
275 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 ...
3
votes
1answer
141 views

Moving SpatiaLite Table into PostgreSQL using ogr2ogr?

How can I move a Spatialite table from a Spatialite db to a PostgreSQL db using ogr2ogr?
1
vote
3answers
62 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 ...
1
vote
1answer
40 views

Get DE-9IM matrix in spatialite?

Is there a way to get the DE-9IM matrix between two geometries in a Spatialite function, analogous to the st_relate() function in PostGIS? (I find it very helpful to spatially join using intersect() ...
2
votes
1answer
36 views

Is there an equivalent to ST_Rotate in spatialite?

I'd like to do some arbitrary rotation of spatial objects in spatialite (accessed through QGIS). In PostGIS I'd use something like: ... SELECT geom AS ST_Rotate(geom, radians, originX, originY) Is ...
1
vote
0answers
138 views

Can't install pyspatialite with python3 and sqlite3

I can't install pyspatialite. When I try it gives me this error: pip install pyspatialite Downloading/unpacking pyspatialite Could not find a version that satisfies the requirement pyspatialite (from ...
2
votes
0answers
92 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 ...