Flat join between MTA station complexes and the GTFS routes that
call at any of their constituent parent stops. One row per
(station_complex_id, route_id) pair.
Format
nyc_subway_complex_routes_df
A tibble with one row per (complex, route):
- station_complex_id
MTA complex identifier; joins to nyc_subway_complexes_df.
- route_id
GTFS route identifier; joins to nyc_subway_routes_df.
Details
Equivalent to
nyc_subway_complex_stops_df |> inner_join(nyc_subway_stop_routes_df, by = "stop_id") |> distinct().
Provided directly because almost every consuming script wants it.
Includes express and branch service variants (e.g., 7X, FX)
that may not appear in the route bullets in nycsubwayhourly's
station_complex text.