Port Authority Monthly On Time Performance By Route by US Government | Transportation and Logistics

About this Dataset

Port Authority Monthly On Time Performance By Route

This dataset contains the monthly average on time performance (OTP) percentage by route and service day type (weekday, Saturday, and Sunday/Holiday service). A bus is considered on time if it is no more than one minute early or five minutes late to a timepoint.

Port Authority has an OTP goal of 73% for bus and 80% for rail service.

Starting in October 2018, Port Authority moved to a different OTP recording system called Clever. OTP data from the Clever system is more accurate because it uses more timepoints; the previous system excluded a large portion of data from OTP processing due to minor technical issues with rider counts on certain trips.

The Mon Incline is not included in this dataset because it does not have a schedule. Service runs every 15 minutes.

OTP only goes back as far as November 2018 for the "T" light rail line because the railcars did not have Automated Vehicle Locators installed until then.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:50:15.729523
Tags: _etl, bus, calls-for-service, on-time-performance, otp, performance, rail, reliability, transit

Tables

Monthly OTP By Route

@usgov.allegheny_county_city_of_pitts_port_authority_monthly__75bbd5da.monthly_otp_by_route

219.24 KB
22258 rows
11 columns


CREATE TABLE monthly_otp_by_route (
  "n__id" BIGINT,
  "route" VARCHAR,
  "ridership_route_code" VARCHAR,
  "route_full_name" VARCHAR,
  "current_garage" VARCHAR,
  "mode" VARCHAR,
  "month_start" TIMESTAMP,
  "year_month" BIGINT,
  "day_type" VARCHAR,
  "on_time_percent" DOUBLE,
  "data_source" VARCHAR
);

OTP Data Dictionary

@usgov.allegheny_county_city_of_pitts_port_authority_monthly__75bbd5da.otp_data_dictionary

4.06 KB
10 rows
2 columns


CREATE TABLE otp_data_dictionary (
  "field_name" VARCHAR,
  "description" VARCHAR
);