SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.
1
vote
0answers
27 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
46 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
17 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
17 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
11 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
0answers
39 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
53 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
13 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
27 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
37 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
15 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
36 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
34 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
16 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
42 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
17 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
21 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
78 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
74 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
33 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
19 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
53 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
51 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
37 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
90 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
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
71 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
99 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
57 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
40 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
90 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
60 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
54 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
98 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
63 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
66 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
39 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
93 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
329 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
48 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
79 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
71 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
82 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
13 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
130 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
128 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 ...
