Transit Routes
Overview
The Transit routes table contains the transit routes modeled within a given Replica region. This table can be joined to the seasonal trip tableusing the unique route_id field. For instance, transit route names and agencies associated with trips can be obtained by joining the seasonal trip table’s transit_route_ids to the transit routes table on this common field.
Schema
| Field Name | Content Type | Sample Value | Description |
|---|---|---|---|
| agency_name | String | MTA Bus Company | Agency name pulled from agency GTFS feed of target modeled season |
| route_id | String | MTA Bus Company:Q06 | Concatenation of: • agency_name • route_id Pulled from agency GTFS feed of target season |
| route_long_name | String | Sutphin Boulevard | Long name of route pulled from agency GTFS feed of target modeled season |
| route_short_name | String | Q6 | Short name of route pulled from agency GTFS feed of target modeled season |
| route_type | Integer | 3 | Route type pulled from agency GTFS feed of target modeled season, using the google GTFS specifications: https://developers.google.com/transit/gtfs/reference#routestxt but incremented by one by account for an unknown type. See mapping list below: • 0 - Unknown • 1 - Light Rail • 2 - Subway, Metro • 3 - Rail • 4 - Bus • 5 - Ferry • 6 - Cable car • 7 - Gondola • 8 - Funicular • 12 - Trolley Bus • 13 - Monorail |
| route_color | String | # FFDB00 | Route color pulled from agency GTFS feed of target modeled season. This hexadecimal code represents the color used in public facing material |
Updated 9 months ago