All work
Lepton Software · open-source sample2025
Route Registration Tool
Road-selection companion to Google RMI — pick road segments on a Google Map, persist to BigQuery, drive downstream traffic analytics.
ReactGoogle Maps JS APIFastAPIPostgreSQLBigQueryCloud RunDocker Compose
Context
The RMI program needs a way for customers to register the road segments they care about before any of the analytics light up. The Route Registration Tool is that companion app — a React + Google Maps interface for selecting and editing road segments, with a FastAPI backend that syncs the selections to BigQuery for downstream Roads Management Insights analytics.
Published alongside the RMI demo in the googlemaps-samples org.
What I built
- React + Google Maps JavaScript API frontend with polyline-aware selection and edit affordances.
- FastAPI backend persisting selections to SQLite (default) or PostgreSQL (production) and syncing to BigQuery for the RMI analytics pipeline.
- ADC-minted OAuth bearer tokens for all backend Roads API calls — no server-side API key, no secret-in-env footgun.
- Cloud Run liveness/readiness probes that verify DB, Roads API, and BigQuery in parallel with per-check timeouts so a slow dependency surfaces as 503 rather than a silent hang.
- One-command Docker Compose + Cloud Build deploy to Cloud Run, with Secret Manager managing only the browser-side Maps JS key.