As a Thanksgiving gift to all my faithful allies and loyal opponents, the Antiplanner has summarized the recently posted National Transit Data for 2007 into one file. The original data are contained in about 21 different files, many of which are hard to read because you have to cross-reference to other files.
The 1.6 MB spreadsheet I’ve posted is in three parts. The first 1438 rows include data for every mode (light rail, bus, etc.) offered by every transit agency in the country (or at least every one that reports to the FTA). The data are also sorted into “DO,” meaning directly operated by the transit agency, and “PT,” meaning contracted out to private companies.
Rows 1442 through 1456 summarize the data by mode: cable car, commuter rail, and so forth. Some of the data (employee hours and BTUs) are only available for directly operated systems, so rows 1459 through 1473 summarize the DO data only by mode.
Rows 1477 through 1828 summarize the data by urbanized area.
A – Agency ID number
B – Mode abbreviation (see rows 1442 through 1456 for translation)
C – DO or PT
D – Transit agency name
E – City and state (agency headquarters)
F – The number of the urbanized area primarily served by the agency
G – Transit trips in 2007
H – Passenger miles
I – Vehicle revenue miles
J – Fare revenues
K – Capital costs
L – Operating costs
M – Employee hours
N – BTUs of energy
O – Number of vehicles in the active fleet
P – Number of seats in those vehicles
Q – Standing room in those vehicles
R – Directional route miles (rail only – a route mile is usually two directional route miles)
All of the above columns are straight from the data base (except BTUs which I calculated from the kilowatt hours, gallons of fuel, etc. using standard conversion factors). The rest are calculated:
S – Average trip length (passenger miles per trip)
T – Average vehicle occupancy (passenger miles per vehicle revenue mile)
U – Average vehicle capacity (seats and standing room divided by number of vehicles)
V – Operating cost per passenger mile
W – Operating cost per trip
X – Employee hours per thousands of passenger miles
Y – BTUs per passenger mile
In the urbanized area rows, columns X and Y may be low in any areas that contract out some of their transit because the hours and BTUs of directly operated transit will be divided by the passenger miles of all transit. I’ll try to fix this in future editions of this spreadsheet.
For now, have a safe and happy holiday.