Simon Willison’s Weblog

Subscribe

Entries tagged sqlite, tommacwright

Filters: Type: entry × sqlite × tommacwright × Sorted by date


Serving map tiles from SQLite with MBTiles and datasette-tiles

Working on datasette-leaflet last week re-kindled my interest in using Datasette as a GIS (Geographic Information System) platform. SQLite already has strong GIS functionality in the form of SpatiaLite and datasette-cluster-map is currently the most downloaded plugin. Most importantly, maps are fun!

[... 1334 words]

1:09 am / 4th February 2021 / gis, mapping, projects, sqlite, datasette, tommacwright

Things I learned about shapefiles building shapefile-to-sqlite

The latest in my series of x-to-sqlite tools is shapefile-to-sqlite. I learned a whole bunch of things about the ESRI shapefile format while building it.

[... 1073 words]

5:25 am / 19th February 2020 / gis, projects, shapefiles, spatialite, sqlite, geojson, weeknotes, tommacwright

Types

Years

Tags