Adam Roberts

SQLite Geospatial - getting started

SQLite Geospatial - buffers!

SQLite Geospatial - intersections!

Spatialite

Geospatial

A collection of Observable Canvases that we share on Instagram.   https://www.instagram.com/observablehq/

Observable

Observable's Instagram Shares

I updated the db with a spatially indexed version (I thought ogr2ogr created automatically - I was wrong!) That said, the performance is still pretty laggy... the ability to drag the marker all over is _cool_, but it really sets the stage for poor performance. Maybe I should remove that ability and just allow for the buffer width slider...

lights.sqlite

proj.db

lights@1.sqlite