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-06-15 11:52 UTC · Commit e5cf673

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 - Tract 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"]
  src --> c24["42 - Allegheny Go Equity"]
  src --> c25["44 - Route Population Reach"]
  src --> c26["45 - Population-Weighted System OTP"]
  src --> c27["49 - Transit Service & Boardings vs Population Density"]
  src --> c28["51 - Traffic Signals and OTP"]
  src --> c29["53 - Near-Side vs. Far-Side Stop Placement"]
  src --> c30["55 - Road Classification and OTP"]
  src --> c31["56 - City Centerline and OTP"]
  src --> c32["57 - Pavement Condition and OTP"]

Context

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

Consumed By