flowchart LR
  02_scheduled_trips(["Scheduled Trips ETL"])
  f1_02_scheduled_trips[/"data/wprdc-schedule/schedule_monthly_agg.csv"/] --> 02_scheduled_trips
  f2_02_scheduled_trips[/"data/wprdc-schedule/paac_pick_lookup.csv"/] --> 02_scheduled_trips
  a1_02_scheduled_trips{"WPRDC Schedule Monthly Aggregate"} --> 02_scheduled_trips
  a2_02_scheduled_trips{"WPRDC Pick Lookup"} --> 02_scheduled_trips
  t_routes[("routes")] --> 02_scheduled_trips
  01_data_ingestion[["Data Ingestion"]] --> t_routes
  02_scheduled_trips --> tp_scheduled_trips_monthly[("scheduled_trips_monthly")]
  02_scheduled_trips --> tp_schedule_periods[("schedule_periods")]
  classDef page fill:#dbeafe,stroke:#1d4ed8,color:#1e3a8a,stroke-width:2px;
  classDef table fill:#ecfeff,stroke:#0e7490,color:#164e63;
  classDef dep fill:#fff7ed,stroke:#c2410c,color:#7c2d12,stroke-dasharray: 4 2;
  classDef file fill:#eef2ff,stroke:#6366f1,color:#3730a3;
  classDef api fill:#f0fdf4,stroke:#16a34a,color:#14532d;
  classDef pipeline fill:#f5f3ff,stroke:#7c3aed,color:#4c1d95;
  class 02_scheduled_trips page;
  class t_routes,tp_schedule_periods,tp_scheduled_trips_monthly table;
  class f1_02_scheduled_trips,f2_02_scheduled_trips file;
  class a1_02_scheduled_trips,a2_02_scheduled_trips api;
  class 01_data_ingestion pipeline;