Simon Willison’s Weblog

Items tagged sqlite, geospatial

Filters: sqlite × 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]

3:52 pm / 12th December 2017 / geospatial, openstreetmap, sqlite, timezones, datasette

Types

Years

Tags