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
2
votes
0 answers

Stuck on pyenv with Django, sqlite and pysqlite with spatialite

I have tries every combination of brew, Django, python and sqlite I can think of. Possible the built-in version of sqlite is messing with me. I am trying to run the test suite for django-geojson (https://github.com/makinacorpus/django-geojson). The…
dyve
  • 5,893
  • 2
  • 30
  • 44
2
votes
1 answer

Sqlite: Execute Spatialite Functions in Intellij

Does anyone know whether it is possible to execute spatialite functions on sqlite-databases in intellij? Reference of spatialite functions: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html In particular, I would be interested in using…
user3116232
  • 433
  • 5
  • 17
2
votes
0 answers

How to use Spatialite on Android or load extension on SQLite

I'm working on an ArcGIS with Android application. I have a SQLite database that uses geometryblob, but obviously, SQLite doesn't recognize these blob. I found two solutions to that. Use SQLite and Spatialite which uses compatible blob type. Use…
kbonnelly
  • 189
  • 1
  • 1
  • 11
2
votes
1 answer

Does not raise exception on "Unknown SRID"

Take this model: from django.contrib.gis.db import models class Location(models.Model): point = models.PointField(null=True, blank=True) Then try to execute this, deliberately giving it a wrong SRID: from django.contrib.gis.geos import…
Antonis Christofides
  • 6,990
  • 2
  • 39
  • 57
2
votes
2 answers

Adding ".so" library to my android studio project

I am having issues when i try to add a spatialite database to my android studio projet.I followed this tutorial https://www.gaia-gis.it/fossil/libspatialite/wiki?name=spatialite-android-tutorial , as mentioned i added two folders to my project…
Mehdi Boukhechba
  • 2,471
  • 2
  • 19
  • 24
2
votes
4 answers

Performance issue with SQLite database (.db)

I am having a performance issue with SQLite database (.db) I am trying to update 1,00,000 records in database (.db) which taking around 50 minutes. Too much slow. my code is like below :: for (int q = 0; q < list.Count; q++) …
Hardik
  • 259
  • 1
  • 2
  • 17
2
votes
0 answers

Configuring spatialite database access for Python 2.6.6

I'm working on a GIS project, and I would like to implement and test some geo-spatial algorithms in Python. For this purpose, I will not only need sqlite, but also spatialite, in order to store and query the location data. Now I've tried to install…
Michał Szydłowski
  • 3,261
  • 5
  • 33
  • 55
2
votes
2 answers

SQLite bind arguments - are they restricted to the WHERE clause only?

Up to now I've been trying a lot of times to bind SQLite selection arguments in queries like the best practices suggest. But it rarely worked. I'm curious about the exact reason. Now I realized that it may be caused by the sub-queries in the FROM…
WindRider
  • 11,958
  • 6
  • 50
  • 57
2
votes
0 answers

spatialite compile error under ubuntu

I'm trying to build the following project for Android: http://code.google.com/p/spatialite-android/ but it has error after excute "ndk-build -j10 " command. the detail error inforamtion is : In file included from…
zhengfazhen
  • 31
  • 4
2
votes
2 answers

How to add EPSG 900913 to geodjango spatialite database?

I'm trying to include a Google Maps widget in my admin-interface using this snippet on a Linux system (presently running locally on a Bitnami django stack in VMWare Player). The map renders, but point features (any features really) in my database…
thin
  • 71
  • 8
1
vote
2 answers

android - prompt user for path/filename

I want to ask user to select a file to open from external storage and receive it's path. Preferably I'd like to avoid excesive coding and use some standard method (well known, system-provided intent or similar). Said file is to be SpatiaLite db file…
Lewy
  • 13
  • 3
1
vote
2 answers

SpatialLite for Android NDK Geos Configure Error

I'm trying to build the following project for Android: http://code.google.com/p/spatialite-android/ Does anyone know why there may be errors when running ndk-build for LineIntersector.cpp? jni/geos-3.2.2/source/algorithm/LineIntersector.cpp:223:…
tetriscodes
  • 53
  • 3
1
vote
4 answers

Get nearest geometry in spatiality using spatial index

I'd like to get the nearest feature to a given point in Spatialite using a spatial SQL query. I'd like to speed it up using index table. Spatial index boundary should be calculated from defined point and a given tolerance, all features that are…
Tom
  • 3,899
  • 22
  • 78
  • 137
1
vote
2 answers

Django - No such column: rowid when migrating Spatialite database

I am trying to create a database using GeoDjango, but when I try to migrate the database I get "error in trigger ISO_metadata_reference_row_id_value_insert: no such column: rowid". I have added the right database engine and included…
Viljan
  • 23
  • 6
1
vote
0 answers

Unable to load mod_spatialite extension into sqlite connection on .NET 7 (win)

I am trying to load spatialite to sqlite connection (in memory db) and it is failing with strange error without any message: Microsoft.Data.Sqlite.SqliteException: 'SQLite Error 1: ''.' I isolated the problem to this short console app example: using…
sokolik745
  • 21
  • 2
1 2 3
…
15 16