SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.
23
votes
6answers
2k views
Options for ArcGIS Desktop SpatiaLite support?
SpatiaLite is playing an increasing role in my organization. As it stands now, using SpatiaLite alongside ArcGIS Desktop requires an amount of importing and exporting of data that isn't always ...
13
votes
2answers
3k views
Looking for fastest solution for Point in Polygon analysis of 200 million points
Apologies for asking a question that has been asked before -- I've read through answers, and I'm left wondering how to implement the recommendations. I've never used SQL, Python, C, and have only ...
13
votes
6answers
725 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.
11
votes
6answers
2k 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 ...
11
votes
2answers
1k 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'?
8
votes
3answers
311 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.
8
votes
4answers
455 views
How to build a geographic database of GPS logs?
On our aerial wildlife surveys we typically generate dozens of GPX files, and usually convert most of them into shapefiles for display in a GIS application. GPX files are a terrific way of keeping all ...
7
votes
3answers
550 views
Is Spatialite Really Slow?
I have a couple of thousand polygons in SpatiaLite. I am trying to do a "touches" query:
select map1.* from map1,map2
where touches(map1."Geometry",map2."Geometry")
and wow, is it SLOW!
...
7
votes
2answers
261 views
What is an “XYZM” measurement model?
SpatiaLite supports a remarkable number of different dimension models.
Interestingly, some of their values support a "measure" coordinate (XYM, XYZM). How would this measure-coordinate be used, and ...
7
votes
2answers
322 views
Can QGIS Read Spatialite Views?
I have a spatialite database I created that spans several years of crime data. To facilitate a real-world scenario where I may simplify the interaction for a user by introducing a View that simply ...
6
votes
2answers
193 views
Why is this spatialite polygon layer not displayed properly?
In QGIS, I have a spatialite multipolygon layer that have full objects in attribute table but do not display random ones as I scroll and pan around:
Vietnam map at zoom level 1:16000000 - some ...
6
votes
3answers
918 views
How to create a new Spatialite database in QGIS
I've been trying to create a new spatialite database within QGIS 1.8 (SpatiaLite Version 3.0.1; QSpatialite 6.0.3) and keep getting this error: "The SQL query seems to be invalid.
no such table: ...
6
votes
1answer
85 views
Finding all neighbors for all polygons in Spatialite
Excuse me if this is a basic question but I'm new to Spatialite...
I have a dataset with zip code polygons and I would like to create a list where for each zip code we have listed all the neighboring ...
5
votes
3answers
1k views
How to export shape file to SpatiaLite
I have a shapefile with one layer. I can open it with QGis. Now I want to convert this shapefile or layer to Spatialite database. How can I do it? Is it possible to do with QGis?
5
votes
1answer
76 views
Where is the Spatial reference ID stored in SpatiaLite?
I have loaded a shapefile into a SpatiaLite Database using the spatialite-gui. In which table is the Spatial reference ID or EPSG code (of the stored data)stored in SpatiaLite?
5
votes
1answer
547 views
SQL Query to Reverse Geocoding in PostGIS
I try to do Reverse Geocode from my shapefile on the database.
I'd already try with Spatialite and PostGIS to put shapefile (.shp) into it. But I'm still can't delivered my objection about reverse ...
5
votes
1answer
1k 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.
...
4
votes
2answers
131 views
Is it possible to add a new line in a non-spatial table using Qgis?
While using QGIS, and having loaded a non spatial table (from a dbf or a Spatialite table), is it possible to add a new row to its table attributes?
Normally in a spatial layer you have to use "add ...
4
votes
2answers
481 views
How do I split polygons into line segments?
How can I split my polygon file into "segements"? The lines should be broken up like this picture shows:
4
votes
2answers
423 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 ...
4
votes
2answers
134 views
How do I reduce the number of drawn polygons on an Android Map?
We're using spatialite-android and Nutiteq to render Archaeological datasets. One of our sample data sets has 7000 polygons that turn into 400,000 objects in our renderer.
Is there a common GIS ...
4
votes
1answer
485 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. ...
4
votes
1answer
126 views
Where are the Spatialite settings stored?
after moving a spatialite-database to another directory, qspatialite says "Can't connect to Database" / Error unable to open database file. Even no project is open or I try to create a new project.
In ...
4
votes
1answer
155 views
How to add a geometry to an existing feature that was created with NULL geometry?
I have a simple SpatiaLite geodb loaded in QGIS with one table. There is a POINT geometry field and some alphanumeric data. In some cases I can record data about a specific site, but the coordinates ...
4
votes
1answer
60 views
Is it possible to have a single foreign key column referenced to two or more different tables?
In Spatialite (3.0.1), having a normal (non-spatial) table, I would like to relate it to two different spatial tables, with different geometries types (multipolygons and polylines), using the same ...
4
votes
1answer
377 views
How to store raster data in spatialite?
I want to cache my raster data(large geotiff files) on local database. I thought to use spatialite. I found librasterlite which provide functionality to do that.
Can anybody point to some tutorial on ...
4
votes
1answer
776 views
Help importing osm data into spatialite
I am trying to import OSM data into Spatialite.
The data is a query from overpass called features.osm
I'm using spatialite 3.0, and following examples, I have created a new database with:
$ ...
4
votes
1answer
590 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 ...
3
votes
2answers
1k views
How can I use R-Tree to find points within a distance in Spatialite?
Create a table with 3D points:
create table points (coords pointz);
select CreateSpatialIndex('points', 'coords');
Insert 13k rows:
insert into points values (geometryfromtext('pointz(...)'))
Do
...
3
votes
3answers
632 views
How do I add (and map) a non-spatial table to QGIS from SQLite?
I have an sqlite file from my Wigle Android app (wiglewifi.sqlite). It's not a spatial file, just tables with lat/lon and other data.
I can add spatialite layers just fine, but cannot seem to find a ...
3
votes
1answer
114 views
Why is my Polygon (WGS84) in SpatiaLite 4 not displayed by QGIS? [closed]
I made a polygon in a SpatiaLite 4 database as follows:
INSERT INTO test_pg (id, name, geom) VALUES (3, 'test', ST_PolyFromText('POLYGON((8.556824 47.185269, 8.611009 47.185269, 8.611009 47.218568, ...
3
votes
1answer
194 views
How to open a Spatialite non-spatial view in QGIS
I'm using Qgis 1.8.0, and spatialite 2.3 in a Windows Vista machine.
I have a database in Spatialite, and I have created a view from one of its tables. When I open it in QGIS, using add Spatialite ...
3
votes
1answer
182 views
Create new polygon layer based on areas of varying numbers of stacked polygons
I have several species range maps (as polygons) that overlap/stack. From this, I am trying to identify areas of highest biodiversity. Ideally, I'd like to create a new polygon layer, where 1 part is ...
3
votes
1answer
221 views
how to add a custom SRID to Spatialite
I'd like to create a spatialite database and load it with shapefiles using the Mississippi Transverse Mercator (MSTM) projection, but it doesn't have an EPSG definition in the spatialite library of ...
3
votes
1answer
362 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 ...
3
votes
1answer
119 views
storing jpeg in spatialite database
How to store jpeg file in spatialite blob column so that spatialite gui and Qgis can recognise the format and show the image.
I have created in memory jpeg from raster bands using jpeglib and stored ...
3
votes
0answers
42 views
Can layers from Spatialite db be used as input for a Sextante model?
I'm trying to build my first models in SEXTANTE and already fail at the start. It seems not to be possible to add a vector layer which derives from a database. Orginally, the layers are from a .mdb. I ...
3
votes
0answers
47 views
QGIS Workflow Problem
I have 3 SpatiaLite layers (one without geometry but with fields that need to be filtered, one with points and one with polygons, both without any non-geometry fields) that need to be combined to a ...
3
votes
0answers
71 views
ST_Touches function in Spatialite
I'm a newbie to Spatialite so forgive me if the answer to my question is obvious...(I tried looking online but couldn't find the answer to this question).
I am trying to use the function ST_touches in ...
2
votes
4answers
122 views
How to convert multipoint layer to point
I have a Spatialite layer which is multipoint (following a QGIS Save As from shapefile). I need it to be PostGIS and POINT. I have tried ogr2ogr -nlt POINT and got 'new row for relation "xxx" violates ...
2
votes
3answers
236 views
How to embed metadata into a spatialite layer in QGIS?
Example usage:
I have a spatialite layer which contain my fiber optic cable routes. In that layer there is a column named 'Cable types' with coded integer data: 1 for aerial cable, 2 for underground ...
2
votes
2answers
132 views
Can I import a .gml file into Spatialite in QGIS?
I have some Ordnance Survey Address Base data files which have a .gml extension. I have imported them to GGIS as vector layers along with some mapping data but would like to explore them with ...
2
votes
3answers
541 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 ...
2
votes
2answers
363 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: ...
2
votes
1answer
102 views
In what situations would SpatiaLite be selected over PostGIS, and vice versa?
I know that SpatiaLite is a lightweight solution. Would it be a problem if I put it on a 5K pageview/day site? Is PostGIS too resources-consuming for such usage?
The dataset is something like < ...
2
votes
2answers
279 views
What's a good way store borehole data in SQLite / SpatiaLite?
I have a bunch of bores / wells with downhole data. The 'header' info for each borehole can easily go into a single table, but I'm wondering how best to store the downhole log data. Typically they are ...
2
votes
2answers
207 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
794 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.
$ ...
2
votes
2answers
51 views
Spatialite as a DBMS-server with GeoDjango?
I would like to add a spatial component to my Django application. I turned out to GeoDjango immediatly. I am wondering now if spatialite could be used as DBMS-server for an application in Prod. Grosso ...
2
votes
1answer
170 views
What is the efficient way to dissolve polygons using Spatialite 3.0
I have polygon table called "tableA" with 72000 records. It has a geometry column called "geometry", and a text column called "field1". I want to aggregate\dissolve all polygons with the same ...
