Simon Willison’s Weblog

Items tagged openstreetmap, sqlite, datasette, geospatial

Filters: openstreetmap × sqlite × datasette × geospatial ×


Building a location to time zone API with SpatiaLite, OpenStreetMap and Datasette

Given a latitude and longitude, how can we tell what time zone that point lies within? Here’s how I built a simple JSON API to answer that question, using a combination of data from OpenStreetMap, the SpatiaLite extension for SQLite and my Datasette API tool.

[... 2152 words]

Types

Years

Tags