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
77
votes
4 answers

How to open .SQLite files

I'm trying to open a .sqlite file on Windows, but I don't know how to. Do you know a good program for it? It contains data for statistical analysis, but I prefer having a .txt file. I also have a .spatialite file. Can you help me?
Darko
  • 1,448
  • 4
  • 27
  • 44
39
votes
7 answers

NoSQL and spatial data

Has any of you had any experience with using NoSQL (non-relational) databases to store spatial data? Are there any potential benefits (speed, space, ...) of using such databases to hold data for, say, a desktop application (compared to using…
Igor Brejc
  • 18,714
  • 13
  • 76
  • 95
13
votes
2 answers

cannot create column with spatialite -> unexpected metadata layout

I'm very new with spatialite. I'm running on Max OS Mountain lion and I have installed SQLite version 3.7.17 and libspatialite 4.1.1 (using homebrew) I can load without error the extension libspatialite in SQLite : SELECT…
sebastien
  • 2,489
  • 5
  • 26
  • 47
12
votes
4 answers

Sqlite load_extension fail for spatialite in Python

I am trying to use the Spatialite beta version 3.0 because I am using Windows 7 on a 64-bit machine. I consistently get the dreaded sqlite3.OperationalError: The specified module could not be found. error when I try to load libspatialite-4.dll. I…
MappaGnosis
  • 1,179
  • 1
  • 11
  • 25
11
votes
2 answers

Get Distance in Meters instead of degrees in Spatialite

I have the following query: select distance(GeomFromText('POINT(8 49)',4326),GeomFromText('LINESTRING(8.329969 49.919323,8.330181 49.919468)',4326)) this gives me 0.97 degrees. But I need it in meters and do not know which SRID to transform to. Can…
tmanthey
  • 4,547
  • 6
  • 35
  • 42
10
votes
1 answer

SQL/SpatiaLite: how to declare a column as geometry?

I am creating a new table through a SQL query from a spatial table: CREATE TABLE SomeShapes AS SELECT ash.id, ash.Geometry FROM AllShapes ash WHERE ash.id = 30 However, this returns a "normal" table, so when I try to load it in a GIS program…
MapEngine
  • 553
  • 1
  • 9
  • 21
10
votes
3 answers

Getting a working SpatiaLite + SQLite system for x64 c#

I need to create and access a spatialite-extended SQLite database under x64 windows. I have downloaded the latest version 1.0.92.0 called sqlite-netFx45-static-binary-bundle-x64-2012-1.0.92.0.zip of System.Data.SQLite. It is referenced from my…
DefenestrationDay
  • 3,712
  • 2
  • 33
  • 61
10
votes
3 answers

Install Spatialite for python (GeoDjango) on OS X

I am tearing my hair out trying to install Spatialite for GeoDjango! I am already using Homebrew, it's generally easy and convenient so I initially tried to follow the Homebrew instructions for GeoDjango. But this stops short of installing any…
Anentropic
  • 32,188
  • 12
  • 99
  • 147
8
votes
1 answer

Is there a way to tell Room about custom sqlite functions?

I've implemented SupportSQLiteOpenHelper.Factory to open a spatialite database (sqlite with spatial functions). However when my queries use spatialite functions such as ST_AREA, Room complains that no such function exists. Is there a way to tell…
kptlronyttcna
  • 1,461
  • 1
  • 16
  • 22
8
votes
2 answers

SQLite + SpatiaLite problems

I'm trying to access a SpatiaLite from C# using System.Data.SQLite provider. When I try to load the SpatiaLite extension, I always get the System.Data.SQLite.SQLiteException: SQLite error The specified module could not be found. error, even though…
Igor Brejc
  • 18,714
  • 13
  • 76
  • 95
7
votes
1 answer

Spatialite with Python 2 and 3

I am attempting to use spatialite with both Python 2 and 3 on Windows 7. Rather than try to patch pyspatialite for Python 3, I decided to use the load_extension approach with sqlite3 Python built-in package, similar to how is done here: Sqlite…
gmas80
  • 1,218
  • 1
  • 14
  • 44
7
votes
0 answers

Install Spatialite on OS X Yosemite

I have problems installing Spatialite tools on OS X Yosemite, first of all I have read Install Spatialite for python (GeoDjango) on OS X but it didn't help me to resolve the issue. Here I will provide steps that I did in order to install spatialite…
endryha
  • 7,166
  • 8
  • 40
  • 64
7
votes
2 answers

Use spatialite extension for SQLite on Windows

I know that this has been asked in some similar ways before. However, all questions I found on this dealt with some very specific system setups which were not applicable for me (because so is mine). System: Windows 7 64bit Python 3.4 64bit sqlite3…
Dirk
  • 9,381
  • 17
  • 70
  • 98
7
votes
2 answers

UPDATE faster in SQLite + BEGIN TRANSACTION

This one is related to spatilite also (not only SQLite) I have a file database (xyz.db) which I am using by SQLiteconnection (SQLiteconnection is extends to spatialite). I have so many records needs to update into database. for (int…
Hardik
  • 259
  • 1
  • 2
  • 17
6
votes
4 answers

Android NDK build of spatialite?

I'm attempting to build a copy of sqlite with spatialite extensions. I've seen the one or two related posts online related to this issue, but no one seems to have gone all the way. I've downloaded the spatialite amalgamation, GEOS and PROJ sources.…
magneticMonster
  • 2,373
  • 6
  • 30
  • 46
1
2 3
…
15 16