As I promised yesterday, I’ve compiled what I consider to be the most important data in the 2015 National Transit Database into one spreadsheet. These data include trips, passenger miles, vehicle revenue miles & hours, weekday trips, fares, operating costs, maintenance costs, capital costs, BTUs of energy consumption, and grams of carbon dioxide emissions.
The 2015 database is expanded from previous years, which just included data from transit systems in major urban areas over 50,000 people. The 2015 data also include transit systems in minor urban areas of under 50,000 people, rural areas, and Indian reservations. The major urban area data fill the first 2,066 lines of the spreadsheet, while the rest fill the next 1,549 lines. The major urban areas accounted for 10.377 billion transit trips in 2015, while the smaller areas accounted for a mere 128 million trips.
Rows 3617 to 3637 are totals by transit mode, including the minor areas. Only some transit systems submitted energy data, and these are totaled in rows 3639 to 3959. The rest of the spreadsheet, rows 3651 to 4148, summarize trips and other data by urban area for the major urban areas. The minor urban areas and rural areas are totaled in row 4149.
Carbon dioxide emissions were based on the Department of Energy’s state electricity profiles, which calculate CO2 emissions per megawatt hour by state. This assumes that each transit agency buys an average mix of the electricity generated in the state in which the agency is headquartered. This isn’t exactly true, but electricity is fungible, so any errors are minor.
I haven’t done any other calculations in the spreadsheet, such as BTUs per passenger mile, costs per trip or passenger mile, etc. I’ll eventually do such calculations, and may upload them, but you can easily do your own. If I find any errors, I’ll correct them and re-upload the spreadsheet and provide a notice here.
The Antiplanner wishes everyone a safe and happy new year.