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

learn more… | top users | synonyms

1
vote
1answer
16 views

assigning random points to unique values

I have generated random points in qgis and would like to assign the value of their geometry to a unique column in another table. I would like to do this in qgis or postgres or spatialite. Table A ...
1
vote
1answer
27 views

SQLite db with FDO geometries: how to assign ID of point in layer A to closest point in Layer B with SpatiaLite?

How can I assign ID of point in layer A to closest point in Layer B with SpatiaLite (find nearest neighbors for each point in A)? For each point stored in table fdo_fc1 I would like to select one, ...
-3
votes
0answers
32 views

what is the shape of the data that saved in GIS files ? [closed]

i want to know the shape of the data that stored in GIS Raster Files like GeoTIFF,ADRG,etc.. , and the data that stored in GIS Vector Files like Spatialite , ... ?? in deep view to this files
1
vote
1answer
24 views

Buffer View With SpatiaLite and QGIS

Creating a dynamic buffer with PostGIS the following view is working: CREATE VIEW buffer500m AS SELECT gid, st_buffer(geom,500)::geometry(polygon,31492) AS geom FROM point; Unfortunately this query ...
4
votes
1answer
32 views

Dump a GeoJSON FeatureCollection from Spatialite query with Python

Given a Spatialite database, holding a table with a geometry column and some other attribute columns. I want to query that table in a Python script and get a GeoJSON FeatureCollection string in return ...
0
votes
1answer
35 views

Insert Geopandas GeoDataFrame into Spatialite database

Is it possible to insert a Geopandas GeoDataFrame directly into a Spatialite database with Python so that the geometry column of the GeoDataFrame becomes a proper geometry table in the database which ...
1
vote
0answers
33 views

Something changed in QgsVectorDataProvider().changeAttributeValues() in QGIS 2.8?

I have a plugin that works with QGIS 2.2 but does not work with 2.8. Only deleteFeatures() works fine, but changeAttributeValues(), changeGeometryValues() and addFeatures() not. I receive r == False ...
2
votes
2answers
47 views

Is a multi-database select possible with DB Manager?

I have data in two locations: geometry data (with attributes) on a PostGIS server (read only) a geometryless table on a local SpatiaLite DB (read+write) I need to select features based on data ...
0
votes
1answer
29 views

ogr2ogr Spatialite to csv very slow

I am using ogr2ogr to extract point data from a Spatialite db to a csv file:- ogr2ogr -f "CSV" commandtmp.csv dtm2.sqlite -lco GEOMETRY=AS_XYZ -progress -explodecollections the Spatialite db is 7GB ...
0
votes
1answer
25 views

Map Positioning and Routing on Android

I have been instructed to create an small offline application in Android that have to: a) Use our own map in JPEG format as the basemap (Google Map / OpenStreet Map is not applicable) b) Show the ...
2
votes
1answer
23 views

Spatialite, NULL when using Distance

When using Spatialite, I cannot run a Distance query. I've tried investigating the data stored in the database, however it doesn't appear to be related to my database. If I run a Distance query on two ...
2
votes
1answer
48 views

Is there Data Loader for QGIS or Spatialite?

Is there a tool that works like the data loader of ArcGIS for QGIS (or via Spatialite )? To integrate data in a database or a shapefile without having the same structure (and the tool allows to ...
1
vote
1answer
58 views

Is there a way to save a spatial join as .sqlite?

I'm joining data from PostGIS and SpatiaLite databases in QGIS using the "Join attributes by location" (Vector -> Data management Tools) tool. However, this has a big limitation - I can only save the ...
0
votes
0answers
19 views

Showing large number of polygons in SpatiaLite on Android map?

I have 2,300 complex multipolygon features in an offline SpatiaLite database. How can I show them on an Android map without slowing the map to a halt?
0
votes
0answers
29 views

How to overwrite/change attribute values with QspatiaLite in qgis 2.6

I tried to work on the "tbl_datum_transform" table which is included srs.db data file. Just to let you know... i try to fill in the ntv2 - BETA2007 grid. How can i fill in something in the ...
2
votes
1answer
52 views

How to delete a column from the attribute table of a SpatiaLite layer?

I want to delete a column from Attribute table but the function "Delete columns" isn't highlighted. (When I am adding new layers I use New SpatiaLite layer, not Shapefile layer). So I have installed ...
0
votes
0answers
22 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
49 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
36 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
18 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 ...
2
votes
2answers
54 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
21 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
27 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
87 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
92 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
35 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
20 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
67 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
53 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
40 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
93 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
21 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
62 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
97 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
118 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
66 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
42 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
102 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
73 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
50 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
62 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
107 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
76 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
77 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
40 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
105 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
390 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
55 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 ...