cityofnewyork-us/school-bus-report-october202121993-jbtw-tj3x
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 2 years ago
Indexed 2 hours ago

School Bus Report October_2021_21-993

For the 2020-2021 school year, only students who were enrolled in blended learning were assigned to bus routes. Therefore, students who are routed are assumed to be enrolled in blended learning.

Students are reported as those who were planned and routed, but may or may not have used the service provided.

Routes were determined by those routed with a vendor and student(s) assigned

Vehicles are identified by school bus company reported data. This data is subject to data entry error and is dependent on the school bus companies to maintain.

All transportation sites were included, and reported by type. A transportation site was defined by a unique location identified by a street address. Please note: multiple students or schools can be located in the same address and would therefore represent a stop for multiple students at the same site.

MetroCard passes are assigned at the school. For public and charter schools, OPT reports students assigned to MetroCard, which includes those assigned a MetroCard by serial number or "T'd" for MetroCard, meaning the school indicated the student as eligible for a MetroCard but did not yet assign a serial number. For Non-Public schools, OPT reports on students who are eligible for MetoCards if they are not assigned to yellow bus service

Some special education schools do not classify students by grade level. Students attending such schools are identified as “NG.”

Service type is representative only of the type of busing a student is assigned to and is not reflective of the educational classification of a student. Students who are classified as special education but do not have an IEP mandate for specific transportation accommodations may be assigned to general education busing. General education students under certain circumstances including, but not limited to temporary housing status, orders of protection and medical conditions may be assigned to special education busing.

OPT assigns students to busing but cannot confirm student ridership. This reporting would have to be captured at the school level.

Students in temporary housing (STH) situations other than those reported to be living in a DHS shelter* were excluded from the report due to data quality issues. While the DOE student data system (ATS) has a housing indicator flag, it is often inaccurate and unreliable. Therefore, OPT cannot reliably report on the temporary housing status of students other than those residing in DHS shelters, where a daily report indicating shelter status is provided.

*Transportation data for students in Foster Care is also provided. Please see section 21-993 B7 for reporting.

Stop to school bus service is typically not provided to students after the 6th grade. Those assigned to this service are students who are granted individual or school-wide exceptions.

In addition to students who applied for transportation because of foster care placement, also reported were students known to be in foster care who received busing or A MetroCard to provide a more complete report of students in foster care who received service.

Students in foster care were identified by a monthly data feed from ACS to OPT via DIIT. Source is subject to error due to data matching to identify OSIS based on name and data of birth.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/school-bus-report-october202121993-jbtw-tj3x\".\"school_bus_report_october202121993\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • school_bus_report_october202121993
     
     
     
     
     
Upstream Metadata