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
1 answer
Upgrading libspatialite for Spatialite Android
Hi I looked at this http://code.google.com/p/spatialite-android/ about using the spatialite for android. I tried it and works fine.
Is it possible to upgrade the examples to use libspatialite-4.0.0 instead of libspatialite-amalgamation-3.0.1? If…
dtheo
- 123
- 5
0
votes
0 answers
GeoDjango: Geographic query causes segmentation fault
On Django development server with SpatiaLite, I am trying to do a basic geographic query:
Location.objects.filter(geom__within=loc.geom)
This causes a Segmentation error and the server dies. loc is an instance of the Location model:
from…
onurmatik
- 5,105
- 7
- 42
- 67
0
votes
2 answers
Android: Failing to update row using SQL Extension function or builtin
I'm having a lot of trouble with SQLiteDatabase command. I have loaded up spatialite and enabled the extension. I want one of my values to be the output of the MakePoint function so I have a content value like this:
values.put("Location",…
Jeremy
- 601
- 4
- 14
0
votes
1 answer
Django and Spatialite crash
I followed the instructions here to add Spatialite to my django app, but, when I try to run syncdb all crash.
Here is the only model that uses geographical points:
from django.db import models
from django.contrib.gis.db import models
class…
Marco Fedele
- 2,090
- 2
- 25
- 45
0
votes
1 answer
How to load shapefile to spatialite using c#?
I am trying to write a code in c-sharp to import shapefile to spatialite database.
Code written to initialize sqlite connection as follows,
SQLiteConnection conn = new SQLiteConnection(@"Data Source=" + sqLiteFile +…
Chandan Kumar Rath
- 147
- 1
- 14
-1
votes
1 answer
When can I initialize spatialite on an existing database or table?
I'm trying to use spatialite to add a geometry column to an existing sqlite3 table. Can I simply call "select initspatialmetadata()" on my existing database and then AddGeometryColumn on my existing table? Or do I need to drop the table? Or do I…
flowbar
- 1
-1
votes
1 answer
No idea what SpatiaLite is, and how to get it
I'm trying to get SpatiaLite, because I need it for this https://pythonrepo.com/repo/caioariede-django-location-field--python-django-utilities
I have read this, but no idea what all that stuff means.
How do I install SpatiaLite on MacOS?
AnonymousUser
- 690
- 7
- 26
-1
votes
1 answer
SQL many-to-one join using two foreign keys
I have two tables (Table A & Table B) that I have in a database (SpatiaLite database). I would like to join all the entries in Table A with Table B using two foreign keys (TableA.Location & TableB.LSD, TableA.LICENCE_NO & TableB.Licence_No);…
MJM
- 123
- 8
-1
votes
1 answer
How to view partial results in spatialite-gui?
I'm running a query to create a table using the spatialite gui on my Windows 7 machine. It has been going for days and I would like to cancel it and try something different. Is there a way for me to view the results of the query so far? The .sqlite…
EnKay
- 48
- 6
-1
votes
1 answer
whether or not to use sqlite/spatialite on Android with only 29k rows
I'm trying to figure out whether or not to use sqlite/spatialite on Android with only 29k rows. I just need to find the nearest locations from the user everytime they move outside 100 meters which could be about every 10 minutes. I feel like running…
Jisike
- 383
- 1
- 3
- 11
-3
votes
2 answers
SQLite/SpatiaLite : wrong datatypes with CREATE TABLE .. AS
With SQLite 3.35.2 and SpatiaLite (actually, the setup is the DBManager of QGIS 3.16), I have the following problem :
When creating a table using a CREATE TABLE .. AS SELECT ... , the created table has different datatypes than the original table…
Darth Kangooroo
- 372
- 1
- 3
- 18