Table

route_stops

Route-stop bridge with service frequency metrics. Produced by Data Ingestion.

Owner: Produced by Data Ingestion. · Freshness: Updated when the producing pipeline step is rerun.

Built 2026-03-03 02:23 UTC · Commit defd5c8

Lineage

flowchart LR
  src["route_stops"]
  src --> c1["01 - System-Wide OTP Trend"]
  src --> c2["02 - Mode Comparison"]
  src --> c3["03 - Route Ranking"]
  src --> c4["04 - Neighborhood Equity"]
  src --> c5["06: Seasonal Patterns"]
  src --> c6["07: Stop Count vs OTP"]
  src --> c7["08: Hot-Spot Map"]
  src --> c8["09: Incline Investigation"]
  src --> c9["10: Trip Frequency vs OTP"]
  src --> c10["11: Directional Asymmetry"]
  src --> c11["12: Route Geographic Span vs OTP"]
  src --> c12["13: Cross-Route Correlation Clustering"]
  src --> c13["14: COVID Recovery Trajectories"]
  src --> c14["15: Municipal/County Equity"]
  src --> c15["16: Transfer Hub Performance"]
  src --> c16["17: Weekend vs Weekday Service Profile"]
  src --> c17["18: Multivariate OTP Model"]
  src --> c18["19 - Ridership-Weighted OTP"]
  src --> c19["23 - Garage-Level Performance"]
  src --> c20["26 - Ridership in Multivariate OTP Model"]
  src --> c21["27 - Traffic Congestion and OTP"]
  src --> c22["28 - Weather Impact"]
  src --> c23["31 - Stop Consolidation Candidates"]

Context

Why It MattersCaveat
Primary analytical table used in this page's computations. Coverage depends on upstream source availability and ETL assumptions.

Consumed By