TODO: Pre-seed McDonald's locations into Postgres

todo-mcd-preseed-locations Doc

todo done

Project

Pre-seed McDonald's locations into Postgres

What

One-time batch load of McDonald's locations from Overpass/OSM into a mcdonalds_locations table in Postgres. This eliminates runtime dependency on the Overpass API, which is unreliable (504 timeouts on 25km radius queries).

Why

McDonald's locations don't change. Querying a public API in real-time for static data is architecturally wrong. Pre-seeding means the nearby feature always works, sub-millisecond, no external dependency.

Approach

New table: mcdonalds_locations (osm_id, name, address, city, state, lat, lng, created_at, updated_at)
Alembic migration to create the table
Management script or one-time seed: batch Overpass query for Denver metro (or wider — full US is ~13k rows, trivial)
Optional: periodic refresh (monthly cron) to catch new openings/closures

Depends on

Nothing — can start immediately. Prerequisite for todo-mcd-smart-proximity.