Category Archives: Spatialite

Spatialite helps creating an index of LIDAR tiles

We have a large set of LIDAR data, in separate *.las file, each covering a small rectangular area. I wanted to create a polygon shapefile of the coverage of each tile for reference so I know which files to choose when we need a subset of the whole region. Using a bash “one-liner” and a simple function in Spatialite I had my polygon layer.
Continue reading Spatialite helps creating an index of LIDAR tiles

Spatialite: Speedup your query with spatial indexing

Spatialite, like any good spatial data management system, can build a spatial index for your layers. Using this index in your spatial queries will dramatically shorten the runtime for that query. The latest version of Spatialite offers a nice compact format for using a spatial index. To demonstrate, I created a point layer of 20,000 theoretical store locations, with sales data for each store, and a polygon layer of over 280 “local councils”. My mission it to sum up the total sales in each local council. So I need to find which stores are located in each local council and aggregate sales for those stores.
Continue reading Spatialite: Speedup your query with spatial indexing

Get your GPS locations into Spatialite

Spatialite, built on the shoulders of the popular sqlite single-file database, offers a broad feature set of GIS analysis tools. Getting data into a spatialite database is a snap when you’re starting from a shapefile. But what about GPS data. Here’s a few tips on how to upload data from the standard “GPX” format into a spatialite DB.

Continue reading Get your GPS locations into Spatialite