← Back to Musings

Fastest Commute: Cycling vs Public Transport Across London

· London · Maps · Open Data

The question: From a fixed home in North London, where is cycling faster than the tube or bus—and where does public transport still win? I queried the TFL Journey Planner API for morning-peak travel times to a dense grid of destinations and built interactive maps from the results.

Origin: Hilldrop Crescent, London N7 · Grid: ~20 km radius, 200 m spacing, ~31,400 points · When: Monday 9:00 departure · Modes compared: cycle vs public transport

Interactive results

Full-screen Leaflet visualisations (open in a new tab for the best experience):

Method

A Python script walks the grid, throttles requests to stay under TFL rate limits, and stores every response in SQLite (fastest_commute/results/commute.db), including the raw API JSON—so a full re-run is never required to explore or re-visualise the data. The run is resumable after interruption: progress is tracked in the database, not a one-shot export.

The analysis pipeline, commands, and CSV export are documented in fastest_commute/README.md in this site's repository.

Why it's fun

Commute choices are usually anecdotal—your line, your office, this week's engineering works. A full-grid comparison turns that into a landscape: where the bike is genuinely competitive in the morning peak, and where the network still dominates. The maps are the point; the database is the receipt.


Data: Transport for London Journey Planner API

← Back to Musings