Bus Route Profiles Released By NYC Comptroller Scott Stringer (326875) | |||
Home > BusChat | |||
[ Read Responses | Post a New Response | Return to the Index ] |
|
Bus Route Profiles Released By NYC Comptroller Scott Stringer |
|
Posted by checkmatechamp13 on Fri Dec 29 23:15:43 2017 A letter to the people is available here: https://comptroller.nyc.gov/reports/bus-route-profiles/The actual route profiles are available here: https://comptroller.nyc.gov/wp-content/uploads/documents/Bus_Route_Profiles_2017.pdf There's an interactive chart available showing the data towards the bottom of the page, and from that interactive chart, there's a link that says "Download Data" (as a CSV file, but I converted it to Excel). From that data, I created the per-mile ridership, average runtime, and ranked the speed of routes across the city. The Excel file I created is available here: https://www.docdroid.net/f0tuP0n/nyct-data.xlsx It should be noted that I didn't change the data, so errors such as the S74/84 being different lengths, and not having the speeds available for some of the newer SBS routes were left in there (so sometimes, you see the "Division By Zero" error). If anybody wants to update those (or if I feel like doing it later), I'll do so. Also, keep in mind that SI limited-stop routes and pairs like the Bx1/2, Bx12 LCL/SBS and Bx40/42 have ridership listed together (so the per-mile ridership can be interpreted as assuming all ridership went to one of those routes or the other). The speed of the SI limiteds vs. the locals is interesting (though I'm not sure why they don't have data for the PM-only S81/84/86). Anyway, here's the rankings that I felt like doing (I didn't bother to do the overall ridership rankings. Using Excel's "Sort" Command, you can also rank them by number of turns, by length, etc). Also, I didn't separate NYCT from MTA Bus (MTA Bus is marked by an asterisk *). Per-Mile Ridership (2016) Overall Top 10 M86 SBS M14A/D M96 B46 SBS M34/34A SBS Bx12 LCL/SBS M79 SBS M66 M15 LCL/SBS M42 Overall Bottom 10 (Highest to Lowest) BX20 S66 BX24 M12 B39 S57 S54 S89 S56 S55 Brooklyn Top 10 B46 LCL/SBS B35 B44 LCL/SBS B12 B6 B42 B1 B74 B41 B52 Brooklyn Bottom 10 (Highest to Lowest) B13 B69 B4 B48 B67 B37 B24 B84 B32 B39 Manhattan Top 10 M86 SBS M14A/D M96 M34/34A SBS M79 SBS M66 M15/SBS M42 M23 SBS M116 Manhattan Bottom 10 (Highest to Lowest) M5 M106 M22 M8 M2 M21 M20 M35 M98 M12 Queens Top 10 Q64* Q49* Q33* Q58 Q23* Q25* Q46 Q10* Q27 Q65* Queens Bottom 10 (Highest to Lowest) Q42 Q102* Q70 SBS* Q113* Q26 Q52* Q103* Q67* Q50* Q21* Staten Island Top 10 S48/98 S53 S46/96 S79 SBS S44/94 S40/90 S51/81 S62/92 S76/86 S61/91 Staten Island Bottom 10 (Highest to Lowest) S78 S74/84 S42 S59 S66 S57 S54 S89 S56 S55 Bronx Top 10 BX12 LCL/SBS BX1/2 BX41 LCL/SBS BX19 BX35 BX9 BX1 BX6 BX15 BX3 Bronx Bottom 10 (Highest to Lowest) BX16 BX34 BX33 BX8 BX18 BX23* BX29 BX46 BX20 BX24 Runtime Overall Top 10 M101 M4 B15 M3 B6 B82 Q60* B44 B8 M1 Overall Bottom 10 (Highest to Lowest) S42 Q64* BX18 Q42 B39 BX46 M35 B84 B74 B42 Brooklyn Top 10 B15 B6 B82 B44 B8 B41 B63 B49 B103* B57 Brooklyn Bottom 10 (Highest to Lowest) B70 B65 B100* B32 B31 B2 B39 B84 B74 B42 Manhattan Top 10 M101 M4 M3 M1 M15 M2 M103 M102 M7 M11 Manhattan Bottom 10 M34A SBS M50 M106 M21 M86 SBS M66 M8 M34 SBS M96 M35 Queens Top 10 Q60* Q44 SBS Q58 Q54 Q114* Q32 Q20B Q65* Q27 Q10* Queens Bottom 10 (Highest to Lowest) Q09* Q15 Q49* Q103* Q33* Q40* Q26 Q104* Q64* Q42 Staten Island Top 10 S78 S74 S59 S44 S94 S46 S79 SBS S54 S57 S91 Staten Island Bottom 10 S62 S48 S51 S98 S55 S93 S56 S40 S90 S42 Bronx Top 10 BX36 BX28 BX42 BX40 BX15 BX2 BX38 BX19 BX1 BX39 Bronx Bottom 10 (Highest to Lowest) BX23* BX41 SBS BX33 BX27 BX34 BX24 BX20 BX29 BX18 BX46 Speed Overall Top 10 Q35* S55 S79 SBS BX29 S56 S89 Q52* S59 S90 S78 Overall Bottom 10 (Highest to Lowest) M14D M34A SBS M14A M22 M50 M116 M66 M57 M31 M42 Brooklyn Top 10 B84 B100* B44 SBS B32 B103* B74 B31 B64 B1 B82 Brooklyn Bottom 10 B57 B48 B25 B14 B11 B54 B63 B45 B35 B12 Manhattan Top 10 M35 M60 SBS M98 M15 SBS M5 M2 M12 M10 M4 M11 Manhattan Bottom 10 (Highest to Lowest) M14D M34A SBS M14A M116 M50 M22 M66 M57 M31 M42 Queens Top 10 Q35* Q52* Q50* Q53* Q46 Q113* Q88 Q22* Q100* Q16 Queens Bottom 10 (Highest to Lowest) Q112* Q09* Q23* Q60* Q101* Q56 Q33* Q49* Q72* Q32 Staten Island Top 10 S55 S79 SBS S56 S89 S59 S90 S78 S93 S74 S40 Staten Island Bottom 10 (Highest to Lowest) S96 S44 S91 S42 S53 S46 S52 S94 S98 S48 Bronx Top 10 BX29 BX23* BX12 SBS BX46 BX41 SBS BX24 BX10 BX16 BX8 BX5 Bronx Bottom 10 (Highest to Lowest) BX2 BX4 BX13 BX32 BX4A BX15 BX11 BX19 BX35 BX33 |