Back to project details

Caltrain Performance Dashboard

Real-time analytics and historical performance data for the Caltrain system

Export Data

Historical Performance Trends

Loading historical data...

About This Data

Data Collection

Real-time train location data collected every minute from the 511.org GTFS-RT API.

Performance Metrics

  • On-time: Arrivals within 4 minutes of schedule
  • Minor delays: 5-14 minutes late
  • Major delays: 15+ minutes late

Database Size

Currently storing 200MB+ of historical performance data.

Update Frequency

Data is processed and updated every 5 minutes with real-time arrivals.

Technical Implementation

Backend Services

  • • Python FastAPI application
  • • PostgreSQL database
  • • Prefect workflow orchestration
  • • Docker containerization

Data Processing

  • • Real-time GTFS-RT parsing
  • • Geospatial arrival detection
  • • Automated delay calculation
  • • Performance aggregation

Frontend Integration

  • • Next.js React application
  • • REST API consumption
  • • Real-time data updates
  • • Responsive visualizations