Simon Willison’s Weblog

Subscribe

Wednesday, 30th May 2018

SpatiaLite — Datasette documentation. Datasette’s documentation now includes extensive coverage of the SpatiaLite extension for SQLite: how to install it, how to import latitude/longitude points, shapefiles and GeoJSON data into SpatiaLite tables, and how to run SQL queries against it that take advantage of spatial indexes. I’m learning SpatiaLite at the moment and filling out the documentation with each new trick I learn as I go—as Mark Pilgrim once taught me, the best way to learn a new technology is to write about it.

# 4:34 am / sqlite, spatialite, datasette, mark-pilgrim, documentation

2018 » May

MTWTFSS
 123456
78910111213
14151617181920
21222324252627
28293031