Epic - Open Data Publishing 2026

[edasmalchi]

Epic Information - Open Data Publishing 2026

Summary

• Easily track the PRs related to monthly updates to open data portal
• 2024 work: Epic - Open Data Publishing 2025 #1399
• reference dates: https://github.com/cal-itp/data-analyses/blob/main/_shared_utils/shared_utils/rt_dates.py
• Publish 6 geospatial datasets each month:
  • ca_hq_transit_areas (HQTA polygons)
  • ca_hq_transit_stops (HQTA points)
  • ca_transit_routes (initially Traffic Ops request)
  • ca_transit_stops (initially Traffic Ops request)
  • speeds_by_stop_segments
  • speeds_route_time_of_day
• Steps to produce open data portal:
  • add current month's date in shared_utils/rt_dates
  • download GTFS scheduled trips, stops, shapes, stop_times, and vehicle_locations tables for a single day: cd gtfs_funnel/ && make funnel_gtfs_data
  • HQ areas/stops datasets: cd high_quality_transit_areas/ && make hqta_data (interspersed with notebook checks)
  • GTFS stops/routes geospatial datasets: cd open_data/ && make create_gtfs_schedule_geospatial_open_data
  • update metadata XML and publish to enterprise geodatabaes: cd open_data/ && make compile_open_data_portal (this step is more manual)

PR Links

2026 open data

• Jan 2026:

Start using sub issues for visibility on project board