This dataset allows users to link the information in the Route dataset to the information in the Transportation Site dataset. Please note that because OPT does not design routes for Pre-K service, those routes are not included in this dataset.
This dataset has the following 3 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| School_Year | school_year | text | Indicates the school year the record refers to. The DOE school year starts in September every year. | 2018-2019 2017-2018 2016-2017 2019-2020 2015-2016 view top 100 |
| Route_Number | route_number | text | Either four (1 alpha + 3 numeric) or five (1 alpha + 4 numeric) character unique route ID that represent a contracted service with a school bus or ambulance vendor. In this table, Route Number is not unique if the route serves more than one school. | Q9323 Q8323 Q8314 K8083 Q9314 view top 100 |
| OPT_Code | opt_code | text | The unique ID for a location receiving any transportation service from OPT. Transportation service may include busing, ambulance or MetroCard shipments for distribution amongst eligible recipients. An OPT Code represents an organization in a specific location; it is possible to have more than one OPT Code associated with the same location, but there are no instances of a single OPT Code being in multiple locations. In this table, OPT Code is not unique if the transportation site is served by more than one route. | 30227 31007 12084 24005 31072 view top 100 |