Spatialite is a library extending the basic SQLite core in order to get a full fledged Spatial DBMS.
Spatialite is a library extending the basic SQLite core in order to get a full fledged Spatial DBMS.
Questions tagged [spatialite]
236 questions
0
votes
2 answers
How to filter SQL by time (greater and less than)?
I want to query a subset from a dataset. Each row has a time stamp of the following format:
2014-04-25T17:25:14
2014-04-25T18:40:16
2014-04-25T18:44:57
2014-04-25T19:10:32
2014-04-25T20:22:12
...
Currently, I use the following query to select a…
JJD
- 50,076
- 60
- 203
- 339
0
votes
0 answers
Create a shared object file (.so) from a C project
I have downloaded a C project for Spatialite (extension of SQLITE database).
http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-amalgamation-3.0.1.zip
How would I go about creating a .so (shared object library) for Unity3D from…
programmer
- 4,571
- 13
- 49
- 59
0
votes
1 answer
Qt custom form for QGIS and autocompleted data entering with “validation check”
In Qt-Designer I created a custom form where I can choose several species names in two different combo boxes. This combo boxes are linked via "value relation" to the accordant non spatial tables (gattung and art) in my SpatiaLite database. The whole…
parallax
- 119
- 9
0
votes
1 answer
How to install and load libspatialite and spatiality-tools on NetBSD w/ pkgsrc?
I am trying to use the library libspatialite to extend sqlite on a NetBSD platform. I've taken the first step of creating a package for libspatialite in pkgsrc (libspatialite-4.1.1). The package appears to work; pkg_info says it's installed and I've…
Gregory
- 4,147
- 7
- 33
- 44
0
votes
1 answer
How to query multiple values from a joined table in a select statment?
I’ve the following tables in a spatialite database:
This tables are filled as follows:
boden_verd:
boden_verd_ID,boden_verd
1,value1
2,value2
3,value3
baumkataster:
baum_ID, boden_verd
1,{2}
2,{1,3}
3,{1,2,3} …
parallax
- 119
- 9
0
votes
1 answer
I would like to know if Spatialite is considered as a NoSQL database?
I would like to know if Spatialite is considered as a NoSQL database.
What is NoSQL?
NoSQL encompasses a wide variety of different database technologies
and were developed in response to a rise in the volume of data stored
about users, objects…
Frank
- 1,406
- 2
- 16
- 42
0
votes
0 answers
SQLite (Spatialite) query on iOS works on 64-bit simulator but nothing else
I have a Spatialite database generated by a Django management command, which I'm embedding in an iOS app. The db opens perfectly, but I've found that querying the database on iOS only works if I'm running on a 64-bit device. Any other devices,…
majackson
- 2,823
- 6
- 22
- 38
0
votes
2 answers
How to use/install rtree in sqlite3 module in python 2.7 on windows
I'm trying to use spatialite database with my django project that is using contrib.gis application (GeoDjango). When syncing database django gives an error "no such module: rtree". Apparently the sqlite3 module that ships with python 2.7.3 doesn't…
LauriK
- 259
- 2
- 10
0
votes
0 answers
ImportError: path/to/_spatialite.so: undefined symbol: sqlite3_bind_int64
I know, simmilar questions have been asked, but I didn't really find any help.
I used pip install pyspatialite to build the pyspatialite library.
Since this doesn't work, I had to build it manualy with:
python setup.py install
Therefore I first had…
0
votes
1 answer
How to disabled direction for routing in Spatialite Dijkstra-algorithm ?
i'm using Spatialite in my application to provide an offline routing service from OSM data.
This works perfectly, specially for car drivers because it takes care of the way direction.
But, how to provide a route by the shortest path, with no care…
user2194515
- 1
- 1
0
votes
1 answer
Load spatialite extension in RSQLite crashes R (OS X & Ubuntu)
I am running some queries against a spatialite database, and would like to get the data directly into R. This page suggests I can do something like this:
library(RSQLite)
sqldrv <- dbDriver("SQLite")
con <- dbConnect(sqldrv, dbname =…
Peter
- 4,219
- 4
- 28
- 40
0
votes
1 answer
Transfer format between geodatabase and OpenLayers
I was curious ab your opinions whats the most efficient transfer format between SpatiaLite and OpenLayers. Currently Im developing an application based on SpatiaLite (extension of SQLite) and OpenLayers and as a transfer format I use GeoJSON.
My…
Ondrej Zvara
- 3
- 2
0
votes
1 answer
SpatiaLite Support on Windows Phone 7/8?
Is it possible to get SpatiaLite running on either Windows Phone 7 or 8? I cant find any documentation on this and Google is failing me
David Hayes
- 7,402
- 14
- 50
- 62
0
votes
1 answer
SQLite Access is denied - works local but not public
when i access my ASP.Net IIS site (W2K3) from i get the following error:
SQLite error
Access is denied.
[SQLiteException (0x80004005): SQLite error Access is denied.]
It happens when i call:
Object retVal = new…
pxp
- 87
- 1
- 10
0
votes
1 answer
Error was: No module named backends.spatialite.base
For testing purposes I'm trying to use SQLite, but it seems I'm missing the spatialite backend:
django.core.exceptions.ImproperlyConfigured: 'django.contrib.gis.backends.spatialite' isn't an available database backend.
Try using…
webjay
- 5,358
- 9
- 45
- 62