Mexico City Transit System Dashboard
2023 · Urban Planning
Full-stack geospatial platform that visualizes GTFS data for Mexico City's 9 public transport modes (Metro, Metrobus, Trolebus, Light Rail, Cable Car, PUMA Bus, RTP, Corredores Concesionados, Suburbano).
A full-stack geospatial dashboard for Mexico City's public transit network, covering all 9 transport modes.
The backend is an Express 5 (Node.js) REST API with 7 endpoints and 6 controllers. A Python ETL script fetches and loads GTFS data into a PostgreSQL + PostGIS database. The frontend visualizes routes, stops, and transit coverage across the city on interactive maps.