Tagged Questions

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

learn more… | top users | synonyms

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 ...
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 ...
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 ...
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 ...
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:
2
votes
1answer
265 views

How to configure wampserver for spatialite

I am in windows 7. I installed WAMPServer. Now, I can not load spatialite libraries. It is showing warning.. Warning: SQLite3::loadExtension() [sqlite3.loadextension]: Not supported in ...
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 ...
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 ...
2
votes
1answer
416 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 ...
1
vote
1answer
75 views

Mapnik - Weird tiles rendering when used with spatialite

I use Mapnik in an GeoDjango App with Spatialite 4.0 as backend. There is something weird with the tiles that I suspect might be related with a bad handling of mbr with spatialite. If you look at ...
1
vote
2answers
162 views

Can't open Spatialite db from openstreetmap in Quantum GIS

I am new to QGIS, OpenStreetmap and Spatialite. I'm trying to get the (OSM) map data into a (SQLite) compact form I can eventually use for realtime reverse geocoding in a vehicle. Quantum is just for ...
1
vote
2answers
257 views

Why is Spatialite delivering “Invalid SRID” error message

Qspatialite in QGIS 1.8 (and also Spatialite-gui) delivers an "Invalid SRID" error message when I try to load shapefiles with a SRID value of 3814 (Mississippi Transverse Mercatur). The SRID is ...
0
votes
1answer
70 views

Using the API of QSpatiaLite plugin

I am using the popular QSpatiaLite plugin for QGIS. Since I am creating and modifying SpatiaLite tables directly with Python (using pyspatialite), I wonder whether I can automate tasks such as ...