Simon Willison’s Weblog

Entries tagged openstreetmap, sqlite

Filters: Type: entry × openstreetmap × sqlite ×


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