I managed to display polygons fom a GeoPackage database file today, using SpatiaLite and Datasette. …
I was playing around with datanews/amtrak-geojson, which provides GeoJSON for Amtrak stations and track segments. …
When writing a test for datasette-leaflet-freedraw I realized I didn't have a simple tiny recipe for creating an in-memory SpatiaLite database in Python. I came up with this: …
The latest version of SpatiaLite adds KNN support, which makes it easy to efficiently answer the question "what are the X closest records to this point". …