Stack Overflow
Stack Overflow

Questions tagged [spatialite]

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.

236 questions
6
votes
1 answer

How to use Spatialite with Xamarin on Android

I want to use Spatialite instead of plain SQLite with Xamarin on Android, to manage and display geographical data. Built-in SQLite does not allow to load extensions. How can I do it?
JaakL
  • 4,107
  • 5
  • 24
  • 37
6
votes
2 answers

Getting GeoDjango + Spatialite running on Windows

I continue to have problems setting up a GeoDjango installation that uses Spatialite as a backend on a Windows machine. I used the GeoDjango installer and downloaded the precompiled libraries from http://www.gaia-gis.it/spatialite/binaries.html, and…
Hans
  • 71
  • 1
  • 3
5
votes
1 answer

Do I need specific configuration for Spatialite with GeoDjango?

According to https://docs.djangoproject.com/en/1.3/ref/contrib/gis/db-api/, Spatialite supports GeoQuerySet.distance(). However, having imported an area list (MultiPolygon as mpoly attribute), I'm trying to do the…
Nikolai Prokoschenko
  • 8,465
  • 11
  • 58
  • 97
5
votes
1 answer

django.core.exceptions.ImproperlyConfigured: SpatiaLite requires SQLite to be configured to allow extension loading

I installed spatialite for Django project but when I try to migrate it show me this error : File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/django/contrib/gis/db/backends/spatialite/base.py", line 44, in…
emale sdm
  • 51
  • 5
5
votes
4 answers

how to compile spatialite for iOS

I am new here and this is my first topic. I am very new on iOS platform and i am trying to use spatialiate extension with sqlite3 but i couldn't do this. It is making me crazy. I don't know how and where do i start. Can someone give me…
Nacrug
  • 133
  • 3
  • 9
5
votes
1 answer

How do I use a prepared statement in Spatialite Android?

I'm looking at the tutorial for Spatialite-Android, and I'm noticing the following code samples: String query = "SELECT AsText(Transform(MakePoint(" + TEST_LON + ", " + TEST_LAT + ", 4326), 32632));"; sb.append("Execute query:…
PearsonArtPhoto
  • 38,970
  • 17
  • 111
  • 142
5
votes
2 answers

Python: The pysqlite library does not support C extension loading

I'm trying to get Spatialite to work with my django app, however, I've hit the following wall: raise ImproperlyConfigured('The pysqlite library does not support C extension loading. ' django.core.exceptions.ImproperlyConfigured: The pysqlite…
rebelliard
  • 9,592
  • 6
  • 47
  • 80
4
votes
2 answers

Build a static library for iOS - specifically spatialite

First, please forgive and point out if I am to use some other protocol for referencing another thread/post. There was a previous thread how to compile spatialite for iOS where the top answer partly described building spatialite as a static library…
Ted Spradley
  • 3,414
  • 3
  • 22
  • 26
4
votes
4 answers

Django Unable to load the SpatiaLite library extension mod_spatialite on Ubuntu

I'm trying to run sqlite3 with spatialite but when i run $ python manage.py makemigrations im getting the error: django.core.exceptions.ImproperlyConfigured: Unable to load the SpatiaLite library extension "mod_spatialite" because: …
Marcelo Fonseca
  • 1,705
  • 2
  • 19
  • 38
4
votes
1 answer

How to load Spatialite SQLite extension on macOS

I am attempting to load the libspatialite extension in SQLite. As per the installation guide, I downloaded the latest libspatialite and moved the included libspatialite.1.1.3.dylib file to /usr/local/lib. greg /usr/local/lib $ls | grep…
Gregology
  • 1,625
  • 2
  • 18
  • 32
4
votes
2 answers

java.lang.UnsatisfiedLinkError in jsqlite.Database.internal_init in Android Spatialite

I'm new to developing for Android and using Spatialite and can't figure out why my app is crashing on a few devices because of this error: java.lang.UnsatisfiedLinkError: No implementation found for void jsqlite.Database.internal_init() (tried…
Jisike
  • 383
  • 1
  • 3
  • 11
4
votes
4 answers

Performance problems using Sqlite function InitSpatialMetaData() to create a Spatialite database through Python

I'm creating a dynamic database through python. The code above work's fine but when I use the function InitSpatialMetadata() in query, the database is created very slowly. The file starts with 0kb and it's increases something like 2-5kb per second…
Renan
  • 129
  • 10
4
votes
1 answer

SpatiaLite v4.0.0 RecoverGeometryColumn violates Geometry constraint [geom-type or SRID not allowed]'

When creating a spatial table and recovering the geometry using the RecoverGeometryColumn function if you don't specify the geometry column as lower case you end up getting a 'violates Geometry constraint [geom-type or SRID not allowed]' error. Am I…
jared
  • 141
  • 2
  • 8
4
votes
0 answers

GeoDjango and Spatialite on Mac: issue with C extension Loading

I'm following the GeoDjango Tutorial to set up a dev spatial DB for my project on my home machine, a Mac Mini running OSX 10.8.2. I installed the KyngChaos packages (UnixImageIO, PROJ, GEOS, SQLite3 and GDAL) and spatialite as detailed in the OSX…
ergelo
  • 923
  • 2
  • 9
  • 15
4
votes
2 answers

Spatialite and iOS

I am trying to build the latest version of Spatialite for use on the iOS platform and am not making much progress. I have downloaded the latest version of the following libraries, and have attempted to bring them into one project (each as their own…
Aaron
  • 7,055
  • 2
  • 38
  • 53
1
2
3
…
15 16