MBTA Heavy Rail Excess Trip Time

Definition of terms: Trip time: the sum of wait time and travel time Data Dictionary: Field Name Field Type Field Definition svc_date date The service date, defined as 3 AM-2:59 AM the following day. day character varying Day type, one of Weekday, Saturday, Sunday, Holiday halfhour character varying The service time, by half hour blocks. peak character varying The simplified service period as defined in the SDP. One of AM PEAK, PM PEAK, or OFF-PEAK. route_id character varying The route ID, one of Blue, Orange, Red. In the future, will include Green. dir_id character The direction of travel. est_pax real The estimated number of passengers by the above groupings. weighted_bl_trip_time real Minutes. Total estimated minutes of baseline trip time. Can be divided by est_pax to get baseline trip time per passenger. weighted_bl_wait_time real Minutes. Total estimated minutes of baseline wait time. Can be divided by est_pax to get baseline wait time per passenger. weighted_bl_travel_time real Minutes. Total estimated minutes of baseline travel time. Can be divided by est_pax to get baseline travel time per passenger. weighted_trip_time real Minutes. Total estimated minutes of actual trip time. Can be divided by est_pax to get actual trip time per passenger. weighted_wait_time real Minutes. Total estimated minutes of actual wait time. Can be divided by est_pax to get actual wait time per passenger. weighted_travel_time real Minutes. Total estimated minutes of actual travel time. Can be divided by est_pax to get actual travel time per passenger. five_min_thresh real The number of passengers in this grouping who arrived at their destination within 5 minutes of the baseline. Can be divided by est_pax to get a percentage of passenger trips that meet the threshold. twenty_min_thresh real The number of passengers in this grouping who arrived at their destination within 20 minutes of the baseline. Can be divided by est_pax to get a percentage of passenger trips that meet the threshold. twenty_pct_thresh real The number of passengers in this grouping who arrived at their destination within 20% excess of the baseline. Can be divided by est_pax to get a percentage of passenger trips that meet the threshold. thirty_pct_thresh real The number of passengers in this grouping who arrived at their destination within 30% excess of the baseline. Can be divided by est_pax to get a percentage of passenger trips that meet the threshold.术语定义：行程时长（Trip time）：等待时长与出行时长之和。 数据字典： 字段名 字段类型 字段定义 svc_date 日期型 服务日期，定义为当日3时至次日2时59分。 day 变长字符型 日期类型，可选值为工作日、周六、周日、节假日。 halfhour 变长字符型 按半小时块划分的服务时段。 peak 变长字符型 SDP中定义的简化服务时段，可选值为早高峰、晚高峰或平峰。 route_id 变长字符型 线路ID，可选值为蓝线、橙线、红线，未来将新增绿线。 dir_id 字符型 出行方向。 est_pax 实数型 上述分组下的预估乘客数量。 weighted_bl_trip_time 实数型 单位：分钟。基准行程总预估时长，可通过除以est_pax得到单乘客基准行程时长。 weighted_bl_wait_time 实数型 单位：分钟。基准等待总预估时长，可通过除以est_pax得到单乘客基准等待时长。 weighted_bl_travel_time 实数型 单位：分钟。基准出行总预估时长，可通过除以est_pax得到单乘客基准出行时长。 weighted_trip_time 实数型 单位：分钟。实际行程总预估时长，可通过除以est_pax得到单乘客实际行程时长。 weighted_wait_time 实数型 单位：分钟。实际等待总预估时长，可通过除以est_pax得到单乘客实际等待时长。 weighted_travel_time 实数型 单位：分钟。实际出行总预估时长，可通过除以est_pax得到单乘客实际出行时长。 five_min_thresh 实数型 该分组下，抵达目的地时间较基准时长偏差不超过5分钟的乘客数量，可通过除以est_pax得到符合该阈值的乘客出行占比。 twenty_min_thresh 实数型 该分组下，抵达目的地时间较基准时长偏差不超过20分钟的乘客数量，可通过除以est_pax得到符合该阈值的乘客出行占比。 twenty_pct_thresh 实数型 该分组下，抵达目的地时间较基准时长超额不超过20%的乘客数量，可通过除以est_pax得到符合该阈值的乘客出行占比。 thirty_pct_thresh 实数型 该分组下，抵达目的地时间较基准时长超额不超过30%的乘客数量，可通过除以est_pax得到符合该阈值的乘客出行占比。