Routes by Transportation Sites
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.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Monthly
- Actually updates about every
- 30.5 days
- Publisher last updated the data
- Oct 1, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 1, 2026, 6:32 AM
- Rows in our copy
- 181,155
- Rows at the source
- 181,155
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
The publisher has not provided a data dictionary.
0 of 3 columns carry a concept; 3 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
route_number | Route_Number | 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. | Not bound | Text | route_number | text | — | |
opt_code | OPT_Code | 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. | Not bound | Text | opt_code | text | — | |
school_year | School_Year | Indicates the school year the record refers to. The DOE school year starts in September every year. | Not bound | Text | school_year | text | — |
Download
This file was produced on Oct 1, 2026, 10:02 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/fgqh-vfzz
- Version
- Content hash:
33a9c4c6b9c4f5ae2501bac24c426ccb7610be271e0bcee936e843ec4dacff9f - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 1, 2026, 6:32 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 1, 2026, 12:30 PM | full_replace | success | 181,155 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 1, 2026, 10:23 AM | full_replace | success | 181,155 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 13, 2026, 11:24 PM | full_replace | success | 181,155 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.58 |