Long-form mapping from each parent subway station to the GTFS
routes that call at it. One row per (stop_id, route_id) pair.
Format
nyc_subway_stop_routes_df
A tibble with one row per parent stop and route:
- stop_id
GTFS parent station identifier (
location_type == 1); joins to nyc_subway_stops_parent_sf.- route_id
GTFS route identifier; joins to nyc_subway_routes_df.
Details
Built by joining stop_times.txt to trips.txt and rolling the
platform-level stop_id up to its parent_station. Includes any
express or branch service variants (e.g., 7X, FX) that call at
the stop in the GTFS schedule, even when those variants do not
appear in the route bullets in nycsubwayhourly's
station_complex text.
See also
nyc_subway_complex_routes_df for the same information rolled up to MTA station complexes.