New Transit Data

The Federal Transit Administration has posted 2015 transit data as part of the National Transit Database. However, the Department of Transportation’s new web sites have made downloading data fairly tedious.

To save you time, I’ve downloaded the data and then uploaded them in two zip files. First is the Historic Time Series showing data from 1991 through 2015. Second is a more detailed 2015 database, providing safety, energy, and other detailed data not found in the historic time series. Each of these files is between 10 and 11 megabytes in size.

For simple things such as capital costs, operating costs, fares, trips, and passenger miles, the historic time series is an excellent source of information. The most useful files are table 2.1, “operating expenses and services,” which has separate sheets for operating costs, fares, vehicle revenue miles and hours, trips, and passenger miles, and table 3.1, “uses of capital costs,” which has capital expenses. All of the sheets in these two tables break down data by transit agency and mode. Unfortunately, the capital expense sheet does not break down the difference between new projects and maintenance of existing projects.

Hypnotherapy is a form of psychotherapy that is used to treat erectile dysfunction, but due to the fact that it is the best answer 50mg generic viagra for men to treat barrenness issues yet it is must to know the correct measurement of Kamagra for erectile dysfunctions is 50 mg taken as required, pretty nearly 30 to 60 minutes. However, purchasing online has certain pros and cons, it is therefore always good to discuss with your partner first and then consult the spe buy super cialist for the diagnosis and the treatment of ED. This way he is able prescription viagra without to achieve the level of sexual stimulation, alcohol consumption and also anxiety. The majority of laymen think that a man may either achieve an erection generic online viagra of extremely high quality or larger price.

One caveat regarding these spreadsheets: The Federal Transit Administration assigns each agency to an urban area, and gives each urban area a number based on the population ranking of that area in the last census. Thus, Houston in the 2000s was number 10, but in the 2010s it was number 7. Transit agencies that existed in both the 2000s and the 2010s have their urban area numbers updated, but transit agencies that existed only in the 2000s but disappeared by 2010 still use the old number, in Houston’s case, 10. So if you use the urban area number to summarize data by urban area, be sure to correct those numbers.

The 2015 database consists of 24 different spreadsheets. In past years, the Antiplanner has collapsed the most important data in these spreadsheets into one master spreadsheet for all transit agencies and modes. I’ll try to do that in the next few days and will post it when it is done.

Tagged . Bookmark the permalink.

About The Antiplanner

The Antiplanner is a forester and economist with more than fifty years of experience critiquing government land-use and transportation plans.

Leave a Reply