Baselight

Routes

City of New York

@usgov.city_of_new_york_routes

Loading...
Loading...

About this Dataset

Routes

One of OPT’s main functions is to plan efficient and fiscally responsible school bus routes. OPT staff use a variety of systems to generate and share bus route information with bus vendors and the public. Specific bus route paths cannot be publicly disclosed because they could reveal personally identifiable information about individual students. In this dataset, OPT has provided all the route information that does not risk disclosing personally identifiable information.
School-age service for students in grades K through 12 are contracted with bus vendors on a per route basis. OPT also manages bus service for Pre-K students who require curb-to-curb service as per a student’s Individualized Education Plan (IEP). This Pre-K bus service is contracted on a per student basis, instead of per route. As a consequence of this difference, OPT does not design bus routes for Pre-K service, so those routes are not included in this dataset.
There are a variety of different vehicles used on routes that serve students requiring curb-to-curb service because an Individualized Education Plan (IEP) indicates specific transportation needs. The standard bus is the only vehicle used for general education routes with students eligible for bus service but who do not have an IEP.
Users may occasionally see a route without a garage assignment. Because this dataset is derived from a snapshot of a transactional system, there may be routes that are in the process of being assigned to a garage. In those cases, the garage information will appear as NULL until the assignment is complete.
Organization: City of New York
Last updated: 2020-11-10T17:01:25.657593

Tables

Table 1

@usgov.city_of_new_york_routes.table_1
  • 473.86 KB
  • 53422 rows
  • 14 columns
Loading...

CREATE TABLE table_1 (
  "school_year" VARCHAR,
  "route_number" VARCHAR,
  "service_type" VARCHAR,
  "vehicle_typedescription" VARCHAR,
  "route_start_date" TIMESTAMP,
  "vendor_code" VARCHAR,
  "vendor_name" VARCHAR,
  "vendor_affiliation" VARCHAR,
  "garage_street_address" VARCHAR,
  "garage_city" VARCHAR,
  "garage_state" VARCHAR,
  "garage_zip" DOUBLE,
  "xcoordinates" DOUBLE,
  "ycoordinates" DOUBLE
);

Share link

Anyone who has the link will be able to view this.