FTA Historic Times Series Through 2016

Since 1992, taxpayers have spent $364 billion (in 2016 dollars) on transit capital improvements. More than $257 billion of this went to rail transit, while $94 billion went to bus transit. The Antiplanner calculated this information on the Federal Transit Administration’s historic time series capital costs spreadsheet.

The official data show that transit ridership peaked in 2014 at 10.5 billion trips and by 2016 had declined 2.5 percent to 10.2 billion trips. This ridership includes urban, rural, and tribal transit agencies, but rural and tribal together add up to only about a million trips per year. The Antiplanner calculated this information on the Federal Transit Administration’s operations spreadsheet.

Tuesday’s post about the 2016 National Transit Database mentioned that the Federal Transit Administration has also posted the 2016 update to its historic time series, which has operating and ridership data back to 1991, capital costs back to 1992, and fares back to 2002 broken down by transit agency and mode. Except for the capital costs, which are in a separate file, all of the information is on worksheets that can be sorted in the same order, allowing users to make such calculations as operating cost per trip or fare per passenger mile.

I’ve modified the two files to add totals for each agency and urban area. I’ve also added GDP price deflators allowing for conversion of historic dollars to 2016 dollars.

The capital costs file is 2.5 megabytes and has raw data in rows 1 through 2515. Row 2517 has totals, 2518 has the GDP deflators, and 2519 has totals converted to 2016 dollars. Column AO also has totals in 2016 dollars for all agencies and modes.

Rows 2521 through 2539 has totals for each mode: commuter bus, cable car, commuter rail, etc. Row 2541 sums the principal kinds of rail (commuter, heavy, light, streetcar, and hybrid) and 2542 sums the various kinds of buses (commuter, motor, rapid, and trolley). Rows 2551 through 3503 provide totals for each agency and rows 3511 through 3999 has totals by urban area.

The operations spreadsheet (13.7-MB) has a dozen individual worksheets:

  • Total operating costs;
  • Vehicle operating costs;
  • Vehicle maintenance costs;
  • Other maintenance costs
  • Overhead costs;
  • Fares;
  • Directional route miles of rail lines (DRM);
  • Vehicles operated in maximum service (VOMS);
  • Vehicle revenue miles (VRM);
  • Vehicle revenue hours (VRH);
  • Trips; and
  • Passenger miles.

The raw data are in rows 1 through 2966. For the sake of completeness, I added the GDP deflators to row 2969 of the total operating expenses worksheet, but did not perform any calculations with them. Rows 2971 through 3923 have agency totals and rows 3931 through 4419 have urban area totals. To these rows I added a column showing the change in ridership between 2014 and 2016 and a column showing the change between the peak year, whatever it was, from 2009 to 2015 and 2016.

All of these calculations make for a very large and slow spreadsheet. If you make one change, it can take a minute or so to recalculate the entire spreadsheet. If you plan to make changes, it would be easiest to change to manual calculation and then recalculate only after you have made all the changes you want.

To sum the data by urban areas, I had to go through and correct some of the urban area identification numbers. The Federal Transit Administration assigns new numbers to each urban area after each decennial census, in rank order by population. New York has always been 1, Los Angeles has always been 2, and Chicago has always been 3. After that it gets confusing because Philadelphia was once 4 but after 2000 was bumped to 5 by Miami, which had previously been 16.

The problem is that when an agency stops operating, the FTA stops updating the urban area numbers for that agency with each new census. So an agency that operated in Miami only during the 1990s would still have the number 16 in the database while an agency that operated in Philadelphia only in that decade would still have the number 4. I went through and corrected all of these numbers in both the operations and capital cost spreadsheets. I may have missed one or two, but it should be reliable for at least the first couple of hundred urban areas.

I’ll probably refer to these data in many posts in the upcoming year. I hope you find them useful as well.

Share

9 thoughts on “FTA Historic Times Series Through 2016

  1. metrosucks

    I hope this downturn is the beginning of the end for the transit “industry”. Too long has it leeched off taxpayers and cost drivers the roads they need to efficiently move around and grow the economy.

    To throw a bone to the assburgers idiot, does this spreadsheet let one calculate how many miles of rail were “stolen” in the US?

  2. LazyReader

    Whether the Antiplanner’s wetdream fantasy of robotic automobiles happen in a discernable time frame is irrelevant. Urban transit will collapse when the big four (New York, Chicago, DC or Boston) suffer some sort of infrastructural crisis and some accident due to preventable maintenance. They now wanna under take a massive 100 Billion dollars worth of new infrastructure for a host of ambitious projects to move a few thousand extra people. Trump Admin should pass a law, NO NEW INFRASTRUCTURE UNTIL YOU FIX WHAT YOU’VE GOT. Since DC’s Redline will never be repaired we can safely say no new boondoggles will ever be built.

  3. prk166

    A little different but I caught this gem that I had forgotten about. Milwaukee’s trolley — The Hop — wasn’t designed to work with other forms of transportation, eh?

    http://www.jsonline.com/story/news/columnists/jim-stingl/2017/10/11/stingl-now-weve-named-hop-milwaukee-streetcar-starting-feel-real/749981001/
    . And you don’t need a transfer, mostly because the route is just 2.5 miles long and there’s no other route to transfer to.

  4. prk166

    It’s sad seeing so many people losing their lives in these fires. I’m curious as what happened sinks in if the public in general will realize how bad it is. With all the people still missing, just in northern California you could see a death toll in the same neighborhood as Hurricane Harvey.

    Being able to shelter in place is especially important for the elderly.

    http://www.sandiegouniontribune.com/business/sdut-carlsbad-costa-glen-shelter-fire-2014may14-story.html

    Activating an emergency plan last used during the 2007 fires, La Costa Glen kept residents informed throughout the day over a loud speaker system and checked on residents room by room.

    Staff planned to sleep on the floor overnight at a command center in Catalina Hall and be ready to activate a general evacuation by bus, starting with residents in the health center.

    But the facility is designed as a “shelter-in-place” location with landscaping and buildings intended to withstand fire to a greater extent than other facilities. Spieker said the Carlsbad Fire Department advised him to maintain operations and not encourage residents to leave.

    “We’re not telling them they can’t leave,” he said, and a few residents did drive away. But staff also laid out the precautions that are taken and most chose to remain.

    In fact a nearby retirement home called to ask if its 90 residents could relocate to La Costa Glen temporarily. Spieker said that option was being considered.

    Although the fire did not threaten La Costa Glen, the gas was turned off as a precaution and a cold buffet was planned for dinnertime. SDG&E said it might have to turn off the power but that had not occurred in the early afternoon. Windows were closed and regular outdoor activities were cancelled.

Leave a Reply