3 ms·
I wrote a tutorial on SpatiaLite here: https://datasette.io/tutorials/spatialite https://datasette.io/tutorials/spatialite - "Building a location to time zone A
by simonw 3y ago
I wrote a tutorial on SpatiaLite here: https://datasette.io/tutorials/spatialite https://datasette.io/tutorials/spatialite - "Building a location to time zone API with SpatiaLite"
It shows how to use SpatiaLite + Datasette to build an API that can tell you what timezone a latitude/longitude point is in, using data derived from OpenStreetMap via https://github.com/evansiroky/timezone-boundary-builder https://github.com/evansiroky/timezone-boundary-builder
Here's a demo: https://timezones.datasette.io/timezones/by_point?longitude=-73.9855&latitude=40.7580 https://timezones.datasette.io/timezones/by_point?longitude=... - add ".json" to the URL for the JSON output.