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

learn more… | top users | synonyms

2
votes
1answer
610 views

Open source software for car navigation on iOS platform

I'm trying to make a car offline navigation app for iOS. Now I analyze OpenStreetMap features what to use. I would like to know if there is open source solution for the following parts of app: best ...
2
votes
1answer
542 views

How to configure wampserver for spatialite

I am in windows 7. I installed WAMPServer. Now, I can not load spatialite libraries. It is showing warning.. Warning: SQLite3::loadExtension() [sqlite3.loadextension]: Not supported in ...
2
votes
1answer
982 views

integrating spatialite and php (sqlite3) on windows platform

anyone can give me an explanation about how to integrate spatialite with php(sqlite3)-windows platforms. I have tried to refer from this link ...
2
votes
0answers
35 views

How to use ST_VoronojDiagram for points that are almost aligned?

I am trying to use the spatialite ST_VoronojDiagram function on a table containing four 4 points that are almost aligned: (1.01 2.02, 2.02 3.03, 10.01 10.02, 11.01 11.02). I wrote the following script ...
2
votes
1answer
28 views

QGIS 'Save As' to Spatialite is changing integers into strings

Using QGIS 2.14.0, Windows 10, when I use 'Save As' to save a polygon shapefile as a Spatialite layer (all options left as default), all of the input integer fields are incorrectly output as text ...
2
votes
0answers
37 views

How to speed up work with local maps in QGIS?

within one project we are distributing a QGIS project including offline maps (you can get it here - has about 1GB) to display measurement data. Looks this way: I need to keep it as easy as possible ...
2
votes
0answers
43 views

how to register view geometry made by MakeLine function?

I am trying to to create a spatial view on my spatialite database. CREATE VIEW v2_pump_view AS SELECT pump.ROWID AS ROWID, pump.id AS pump_id, MakeLine( ...
2
votes
1answer
114 views

QGIS Spatialite Views problems

I am trying to wrap my head around spatialite views in QGIS. However there are severe limitations that make it very cumbersome: Spatialite views in QGIS do no update, if the corresponding tables in ...
2
votes
0answers
85 views

Export shapefile from spatialite

I am using a spatialite db to perform a union and dissolve over a vector file. The vector inside the db looks like this: when I export the table with: ogr2ogr -f "ESRI Shapefile" -overwrite ...
2
votes
0answers
69 views

Relative path in layer styles in spatialite

is there way to store default style in relative path in spatialite??it has layer styles table,and a column 'f_table_catalog'.and in this column pathes are absolute,In Qgis project options i set ...
2
votes
1answer
147 views

Converting sqlite (spatialite) data to oracle sdo_geometry (using .NET)

Using .NET, I have a sqlite file that I have to import to oracle. The geometry needs to be converted from sqlite (spatialite) geometry column to a sdo_geometry column in oracle: // Loop through all ...
2
votes
0answers
138 views

Enable LWGEOM for OGR tools (QGIS 2.8)

I am doing some scripted operations on a Spatialite DB using OGRINFO, OGR2OGR etc. in the QGIS 2.8 OSGEO4W shell. Unfortunately, LWGEOM functions such as ST_Split() are unavailable and ...
2
votes
1answer
66 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 ...
2
votes
0answers
134 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 = ...
2
votes
0answers
142 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 ...
2
votes
0answers
1k 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 ...
2
votes
0answers
471 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
231 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 ...
2
votes
0answers
385 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 ...
2
votes
0answers
172 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: ...
2
votes
1answer
439 views

Added columns in SpatiaLite wont appear in QGIS (attribute table)

I have a SpatiaLite Database with OSM-Data from planet osm (imported with the OSM import tool from QGIS2.0) Everything is fine so far. I can create, export, delete tables and draw them in qgis... but ...
2
votes
0answers
212 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). ...
2
votes
0answers
788 views

Building java based desktop map application using embedded database such as spatialite

I am relatively very new to building GIS based applications and have a very limited understanding in this area. So I need some help in building a java based desktop application which would generate ...
2
votes
0answers
111 views

QSpatiaLite: Cannot create table

I am running QGIS 1.8 (SpatiaLite 3.0.1) and QSpatiaLite 6.0.1. I have a spatial table EventPrecise (with geometry column p in EPSG:4326). I want to join this table with another, non-spatial table ...
2
votes
0answers
761 views

Spatialite - get geometry from WKB

I have a table of WKB HexString values, of the form: 01010000000812368FA5D106C01C25B4DAE5AE4A40 in a column called 'Centroid' in spatialite I want to create a geometry from these values. When I ...
1
vote
3answers
273 views

Copying schema of Postgis or Spatialite DB to blank one

I want to copy a Postgis or Spatialite DB sctructure (features, tables) to a blank DB. In ArcGIS i can easily handle it by using XML Workspace Document. Fisrtly extact it from a Geodatabase and than ...
1
vote
1answer
580 views

In what situations would SpatiaLite be selected over PostGIS, and vice versa?

I know that SpatiaLite is a lightweight solution. Would it be a problem if I put it on a 5K pageview/day site? Is PostGIS too resources-consuming for such usage? The dataset is something like < ...
1
vote
2answers
127 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 ...
1
vote
1answer
96 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 ...
1
vote
1answer
903 views

Problem loading spatialite extension with sqlite3 Python connector

I am trying to load the Spaltialite extension using SQLite3 python module. I am getting the following error when I run my script. EOFError: [Errno 10054] An existing connection was forcibly closed ...
1
vote
2answers
342 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 ...
1
vote
3answers
657 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 ...
1
vote
2answers
454 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
2answers
341 views

Can GRASS read Spatialite geometry fields?

I've looked at the question: How to import SpatiaLite data into GRASS? already. The links there talk about two separate tasks: Passing SQL to a Spatialite DB from GRASS and connecting to Spatialite ...
1
vote
1answer
64 views

How to create a new database in spatialite and insert the data using python in Qgis

I want to create a new database in spatialite and want to connect to the database and execute the sql queries. conn = db.connect('myDB.sqlite') # creating a Cursor cur = conn.cursor() sql = 'select * ...
1
vote
1answer
101 views

How to convert a complex project of shape files to a spatialite database?

We have a QGIS project made of ~10 shape file layers. The layers are saved on a shared server, and the project is used on different computers. Recently polygons and polylines have been been ...
1
vote
1answer
360 views

nearest neighbor query in SpatiaLite

I am trying to find the nearest line to each point in a layer, and I have over 1 million points. I want to be able to associated the closest unique line ID with the point unique IDs. I have tried to ...
1
vote
2answers
845 views

How to speed up spatialite-query using spatialindex?

I have got 2 tables, one of type LineLayer called strlayer, the other one is a PolygonLayer called blayer. The LineLayer contains two rows called fromBland and toBland that should be filled with an ...
1
vote
1answer
251 views

Failed connection with .sqlite file in QGIS converted from osm by spatialite

I have converted a *.osm file to a *.sqlite file using the spatialite_tool i.e sspatialite_osm_map.. Now I want to view the map using QGIS. However, at the time of using the add spatialite table ...
1
vote
2answers
65 views

Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)

I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
1
vote
2answers
707 views

Why is every SELECT via a geometry function null?

I'm using Spatialite (2.3.1, binary from the website) on Windows XP via Java ("Xerial Driver"). SQLite loads fine, also Spatialite seems to be loading successfully. I can even do SELECT-statements. ...
1
vote
1answer
40 views

How to get the long/lat information from a NodeID and vice versa

In the SpatiaLite website they explain how to use .osm data to create a SpatiaLite database, that contains a single table, where each row is an arc of the road graph. Then, they explain the procedure ...
1
vote
1answer
54 views

Open Street Map export to QGIS Lines not Polylines

I recently updated to QGIS 2.10.1 and have found that I can no longer view .OSM files. Before I simply dropped and dragged downloaded .OSM files into QGIS and it automatically split into four ...
1
vote
1answer
118 views

ST_MakeValid is not working?

I have a polyline spatialite database, tried to perform repair geometry in QGIS using python with the following code: from pyspatialite import dbapi2 as db conn = db.connect(r'D:\db.sqlite') cur = ...
1
vote
2answers
149 views

Is there any tool to execute Postgis-like queries without a postgres server?

I would like to know if there is any way/tool of using geoprocesing queries like the ones you use with POSTGIS but without the need of having an actual database server available. The particular ...
1
vote
1answer
89 views

ogr2ogr does not set osm_id for all multipolygons

I used ogr2ogr to convert from osm data (pbf) to spatialite : ogr2ogr -progress -f SQLite -dsco spatialite=yes france.simple.spatialite france-latest.osm.pbf then, a large part of the imported data ...
1
vote
1answer
110 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, ...
1
vote
2answers
204 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
191 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
59 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 ...