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: |
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: |
route_color | String |
| Route color pulled from agency GTFS feed of target modeled season. This hexadecimal code represents the color used in public facing material |
Updated 16 days ago