SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.

learn more… | top users | synonyms

2
votes
3answers
749 views

Accessing GEOS functions in Python

The issue: I am using Windows 7, 64-bit operating system with Python 3.2. I must continue to use Python 3.2 because of a dependency with another API. I need some functions in GEOS that are not ...
4
votes
1answer
915 views

Split line using line/point in PostGIS 1.5

I have a layer that contains a master line (one big polyline) and a another layer that contains "break lines". I need to be able to split the master line at the intersection of each of these break ...
2
votes
3answers
2k views

Spatialite in .NET Application - AccessViolationException was unhandled

I am trying to use Spatialite in a .NET application using the System.Data.SQLite provider. Interestingly enough, everything works as expected except an error gets thrown at the very end when the ...
6
votes
3answers
2k views

How to find nearest neighbors between two tables with point locations in SpatiaLite?

I have started playing with SpatiaLite today and already stumbled upon a problem. For each point location stored in tableOne I would like to select one, nearest (linear distance) point from tableTwo. ...
1
vote
0answers
143 views

How to retrieve the value of a cell in RasterLite?

Just wanting to know the SQL statement needed to find out the pixel value for a location, when the raster is loaded into SpatialLite as a Raster? I loaded the Raster using rasterlite_load -d ...
2
votes
1answer
849 views

How to combine MapInfo tab files into one spatialite DB?

I have many folders, each with a collection of MapInfo tab files (each folder has the same table names). For each folder I want to merge the tab files into one spatialite DB. My current method is to ...
2
votes
1answer
516 views

How do I query for all polygons within a distance from a point?

Call me stupid, but somehow I couldn't figure out how to do the following. I've got a testing shapefile with 18 features, which I successfully imported into GeoDjango (1.3, running on Spatialite). As ...
4
votes
1answer
489 views

Shorter Version of this SpatiaLite Query

I've been doing some spatial queries using spatialite, and they're large enough that a spatial index becomes a must. An example of using an index is given in the tutorial spatialite> SELECT ...
2
votes
2answers
299 views

Specifying a file for VirtualShape in SpatiaLite [closed]

I'm fairly very new to spatialite, and am stuck on something very basic. I'm creating a virtual table from a shapefile using virtualshape. This works fine when the shapefiles are in the same folder ...
2
votes
1answer
668 views

integrating spatialite and php (sqlite3) on windows platform

anyone can give me an explanation about how to integrate spatialite with php(sqlite3)-windows platforms. I have tried to refer from this link ...
5
votes
2answers
589 views

Access to SpatiaLite .dumpshp via Python?

I'm trying to interact with a SpatiaLite database via Python on my Windows machine. I've managed to connect to the database and load the SpatiaLite extension, which means that I can pass SQL queries ...
2
votes
1answer
1k views

Queries on virtual network in Spatialite only make errors

I've installed Spatialite 2.4 in Ubuntu. I try to convert an osm file into a roads network using this tutorial and make searches on it, but the queries only produce "no column" errors. $ ...
13
votes
6answers
959 views

Is SpatiaLite the only single file/db spatially enabled exchange format?

I am trying to figure out if there are other viable exchange formats for spatially enabled data. So far, it seems SpatiaLite is the only one out there, but it has yet to be adopted by the industry.
8
votes
3answers
397 views

Remove duplicates from Spatialite

I have a Spatialite database with points. From time to time now points are added. What would be the easiest way to remove duplicates based on the coordinates? Hints are greatly appreciated.
4
votes
1answer
623 views

Spatialite SpatialSQL Query

I've been flummoxed by this query. I have a table of points, and a table of lines, and I am trying to return the point id and line id whenever the point is contained within a buffer of the line (i.e. ...
1
vote
2answers
555 views

Why is every SELECT via a geometry function null?

I'm using Spatialite (2.3.1, binary from the website) on Windows XP via Java ("Xerial Driver"). SQLite loads fine, also Spatialite seems to be loading successfully. I can even do SELECT-statements. ...
13
votes
2answers
2k views

sqlite to spatialite

I have a sqlite database with a table that has a column for longitude and one for latitude. Is there a way to make this data base 'spatial'?
11
votes
6answers
3k views

How to run Spatialite on Android?

Does anyone know if it is possible to get Spatialite running on Android? Specifically for either Android 2.1 or 2.2. I've been browsing the web, and although it seems technically possible, I haven't ...
2
votes
1answer
509 views

How to import SpatiaLite data into GRASS?

How can I import SpatiaLite tables into GRASS? Are there any restrictions I should be aware of? How does GRASS cope with columns that don't have a specific type (Sqlite tends to create such columns ...
3
votes
2answers
550 views

How to delete a broken index in SpatiaLite?

I managed to screw up an index in my SpatiaLite database. The index was created using spatialite-gui. In the meantime, I deleted the original table and three out of four index files: ...
28
votes
5answers
2k views

Does ArcGIS for Desktop support SpatiaLite?

SpatiaLite is playing an increasing role in my organization. As it stood in 2012, using SpatiaLite alongside ArcGIS Desktop required an amount of importing and exporting of data that was not always ...