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
1
vote
0 answers
bus error on usage of rusqlite with spatialite extension
I'm seeing a bus error on cargo run when attempting to load the spatialite extension with rusqlite:
Finished dev [unoptimized + debuginfo] target(s) in 1.19s
Running `target/debug/rust-spatialite-example`
[1] 33253 bus error cargo run…
Seth Vincent
- 174
- 7
1
vote
1 answer
Installation of Spatialite with Django on windows 10
I am struggling to find out how to install spatialite for geodjango on windows but I don't know what I am doing wrong. I follow the instructions as per the django page https://docs.djangoproject.com/en/4.0/ref/contrib/gis/install/spatialite/ but the…
1
vote
1 answer
How can I allow loading sqlite extensions with a sqlalchemy engine?
Overview
I want to include sqlite extensions in sqlalchemy.
Issues
When I try to load the extension I get a not authorized error.
MVE
Setup engine
import sqlalchemy
engine = sqlalchemy.create_engine('sqlite:///:memory:')
extension =…
benrussell80
- 297
- 4
- 10
1
vote
2 answers
Random syntax error on SQLite3 INSERT query
I'm doing an insertion query using SQLite3 with Spatialite on Qt and sometimes it just fails returning random syntax errors.
If I run the queries on SpatialiteGUI it never fails.
I'm using SQLite3 version 3.27.2.
The method that builds and runs the…
JonatasCV
- 53
- 5
1
vote
0 answers
.so file is not loading, when running the app on the virtual device
I used a physical machine to develop and try to load the .so file. I put all .so file under the "app/libs" folder and add the code at build.gradle
sourceSets {
main {
jniLibs.srcDirs = ['libs']
}
}
The application …
leomessi
- 69
- 6
1
vote
0 answers
How to load mod_spatialite QGIS extention on macOS
I am using the latest version to have python on my macOS. I load the database in QGIS but I didn't work mod_spatialite. I always got an error: error: image not fou
import sqlite3
conn =…
Ayse Karacaorenli
- 11
- 1
1
vote
0 answers
Running Spatialite on iOS in Java Giving Error Although I Have Packages Installed
I use iOS Catalina and I need to run some tests in Java for loading data to Spatialite. I am encountering with this error:
java.lang.UnsatisfiedLinkError: Error looking up function 'sqlite3_enable_load_extension, symbol not found
I have already…
Melih
- 666
- 1
- 9
- 24
1
vote
0 answers
Cordova: How to use two sqlite plugins at once?
I'm building an cordova app which uses some plugins that need to use different cordova-sqlite-plugins. One plugin needs cordova-sqlite-ext installed, another plugin needs cordova-spatialite-storage.
My problem now is, that I can't get both plugins…
Hollul
- 319
- 4
- 16
1
vote
0 answers
Python + Spatialite + Virualknn
So, I'm playing around with the Spatialite Virtualknn to try my hand at some routing using open street maps data and Python.
After downloading the Australian osm data, I've extracted a roads layer and created a separate Spatialite…
Darin
- 11
- 1
1
vote
1 answer
Sqlite no results for query with a bound parameter, works with identical query with hardcoded value
I am coming up against a strange problem with Sqlite 3. I have a relatively simple query that takes a bound parameter in its WHERE predicate. When executing the query with the bound parameter, I get 0 results, but running the exact same query with…
old greg
- 799
- 8
- 19
1
vote
0 answers
Using spatialite with xerial/sqlite-jdbc on MacOS
I'm having some problems loading the spatialite extension in Java to read a GeoPackage, I have the following snippet:
import org.sqlite.SQLiteConfig;
import java.net.URI;
import java.net.URISyntaxException;
import java.sql.Connection;
import…
choffa
- 51
- 4
1
vote
0 answers
decode the blob geometry using java
In my table I have two columns, Data and Range.
Range field is encoded binary from ArcGIS.
this format is supposed to be a standard format with in the Geo spatial…
JavaDev
- 79
- 1
- 8
1
vote
1 answer
Impossible to enable extensions with Python SQlite3
After checking some related posts with SQlite3 and how to enabling extensions, I found myself with no answer to my needs and, desesperately, I am asking you guys here.
I am using Python 3.7 in an specific pipenv environment (I think those are venv…
joueswant
- 136
- 10
1
vote
1 answer
select geometry from geopackage in dbbrowser for sqlite
I'm using dbmanager for sqlite with spatialite module loaded and I'm trying to read a geopackage I exported before from qgis 3.12.
I perform this both selections bellow and get the 'geometry' with hex function, and them as supposed WKT text (I'm not…
Tobias McTelson
- 31
- 6
1
vote
0 answers
SqLite-WebSQL select and add to leaflet map as geojson layer
I tried to save data using SqLite-WebSql and JavaScript to save polygon geometry in wkt format. So far I have managed to save data with the following script:
var db = openDatabase("spatial", "1.0", "local spatial data", 32678);
// Create…
Jymo
- 25
- 6