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

ActiveRecord set field to SQL expression

I am using Ruby 1.8.7 and Rails 2.3.8 and have a number of locations represented by a latitude and a longitude. I am using the SQLite SpatiaLite extension to convert the coordinates to the well-known binary (WKB) format. My concern is how to have…
Laurens
  • 2,078
  • 5
  • 29
  • 46
3
votes
1 answer

activating spatialite when calling sqlite3 on a gpkg from power query

I'm trying to make a spatial query on a table with a geometry column, stored in a gpkg, through excel's power query. when trying to run the query, as such: = Odbc.Query("database=path/to/gpkg;dsn=SQLite3 Datasource", "select *,st_centroid(geom) as…
ido klein
  • 137
  • 2
  • 11
3
votes
1 answer

Alembic generates arbitrary type changes for Geometry columns

I'm working on a project that uses SQLite as a database and Alembic as a database migration tool. It includes spatial data and therefore, spatial extensions and geoalchemy2 are included in the project. I'm using autogenerate command and it detects…
Baris
  • 397
  • 5
  • 12
3
votes
1 answer

Error when using GeoDjango with SpatiaLite on Ubuntu

I'm trying to get GeoDjango running on SpatiaLite on Ubuntu 11.04, and even with a very minimal setup, I'm hitting a strange error. Saving an instance of a model with geo-fields works, but loading it again fails with an exception: Error encountered…
Benjamin Wohlwend
  • 30,958
  • 11
  • 90
  • 100
3
votes
0 answers

How to use "Spatialite" database extension in Swift/Objective-C on Xcode 11?

I wanted to use GIS features using spatial queries to sqlite. I tried below possible methods which are outdated: static library of spatialite spatialite pod SpatialDBKit pod Tried to use above possible methods but end up with many build errors,…
Akash
  • 89
  • 4
3
votes
0 answers

How to submit Xamarin iOS app with Native Reference to AppStore?

I'm working on a Xamarin Forms app which includes this SpatialiteForms library. https://github.com/breekmd/SpatialiteForms When I try to submit the iOS app to the AppStore it is rejected during the validation. Just wondering if anybody else have/had…
ssrodnas
  • 31
  • 2
3
votes
1 answer

Sqlite on Python 3 with Spatialite and full support for spatial indices (i.e. rtree)

This is the scenario: I am using Python 3 (3.6 through 3.8 on Windows 10, using Pipenv and vanilla Python) to create an SQLite file with Spatial support and several triggers based on Spatial Indices. Creating the database and adding records works…
PCamargo
  • 584
  • 6
  • 26
3
votes
1 answer

How to fix "SQLite Error 1: 'The specified module could not be found." with EF and Spatialite

I am creating a spatial database with EntityFrameworkCore.Sqlite.NetTopologySuite to store a point for now but will eventually be for lines etc. I have used the Spatial Data documentation as reference…
Jarb
  • 45
  • 6
3
votes
1 answer

pyspatialite symbol not found for _iconv

I am trying to compile pyspatialite 2.6.1 using the command sudo python setup.py install It compiles successfully but the resulting binary is missing a symbol. When I import the dbapi2 module from it I get the following error. Python 2.7.1…
Aaron
  • 2,403
  • 1
  • 24
  • 25
3
votes
2 answers

Could not load Spatialite extension in qSqlite ( QT 5.9)

I am trying to load Spatialite as extension in qSqlite ( Qt 5.9), I have done that before with Qt4.8, but I failed with the QT5.9. I changed the sqlite.pri by removing "SQLITE_OMIT_LOAD_EXTENSION", and I did some change on the sqlite.c by removing…
Mhd Djeralfia
  • 101
  • 7
3
votes
0 answers

Django : sort by distance, spatialite does not load C extentions

I want to filter results according to their distance so I used GeoDjango and added a field PointField to my model: from django.contrib.gis.db import models location = models.PointField(u"longitude/latitude", …
A2maridz
  • 341
  • 1
  • 4
  • 11
3
votes
1 answer

GeoDjango Segmentation Fault

I have a Django App that was working greatly until I installed GeoDjango. I'm running MacOS Sierra 10.12.2 with Python 2.7.13 (installed via mac ports), Django 1.10.4 and followed GeoDjango's tutorial (homebrew). After installing the packages…
pekapa
  • 881
  • 1
  • 11
  • 25
3
votes
1 answer

GeoDjango & SpatiaLite - filtering nearby objects

My models.py has User and Business models that have this field: location = PointField(geography=True) I'm getting Google Maps coordinates (in EPSG 4326) via Geocode service from an address which the user specifies. Then I'm saving it in the above…
softzer0
  • 445
  • 2
  • 7
  • 25
3
votes
2 answers

SQLite extract string from text in column

I have a Spatialite Database and I've imported OSM Data into this database. With the following query I get all motorways: SELECT * FROM lines WHERE other_tags GLOB '*A [0-9]*' AND highway='motorway' I use GLOB '*A [0-9]*' here, because in…
Stefan
  • 1,383
  • 2
  • 15
  • 25
3
votes
1 answer

mapnik + sqlite with spatialite enabled extension

I could need some help from an experienced unix user. As far as I understand, the mapnik library only uses the common sqlite3 library by default. Though mapnik supports spatial sqlite databases, spatialite has to be a statically linked extension for…
01Track1mp3
  • 31
  • 2
1 2
3
…
15 16