This report provides an analysis of transit systems’ financials, ridership, and efficiency metrics. The data is sourced from ridership, fare revenue, and expenses datasets for 2022.
Rows: 3744 Columns: 29
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (10): Agency, City, State, NTD ID, Organization Type, Reporter Type, UZA...
dbl (2): Report Year, UACE Code
num (10): Primary UZA Population, Agency VOMS, Mode VOMS, Vehicle Operations...
lgl (7): Vehicle Operations Questionable, Vehicle Maintenance Questionable,...
ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
`summarise()` has grouped output by 'NTD ID'. You can override using the `.groups` argument.
Code
FINANCIALS <-inner_join(FARES, EXPENSES, join_by(`NTD ID`, `Mode`))TRIPS <- readxl::read_xlsx("ridership.xlsx", sheet="UPT") |>filter(`Mode/Type of Service Status`=="Active") |>select(-`Legacy NTD ID`, -`Reporter Type`, -`Mode/Type of Service Status`, -`UACE CD`, -`TOS`) |>pivot_longer(-c(`NTD ID`:`3 Mode`), names_to="month", values_to="UPT") |>drop_na() |>mutate(month=my(month)) MILES <- readxl::read_xlsx("ridership.xlsx", sheet="VRM") |>filter(`Mode/Type of Service Status`=="Active") |>select(-`Legacy NTD ID`, -`Reporter Type`, -`Mode/Type of Service Status`, -`UACE CD`, -`TOS`) |>pivot_longer(-c(`NTD ID`:`3 Mode`), names_to="month", values_to="VRM") |>drop_na() |>group_by(`NTD ID`, `Agency`, `UZA Name`, `Mode`, `3 Mode`, month) |>summarize(VRM =sum(VRM)) |>ungroup() |>mutate(month=my(month))
`summarise()` has grouped output by 'NTD ID', 'Agency', 'UZA Name', 'Mode', '3
Mode'. You can override using the `.groups` argument.
The MTA New York City transportation is the transportation company with the most total Vehicle Revenue Miles (VRM) in our dataset. This agency has a total VRM of 1,083,285,350 on file. This suggests that MTA New York City Transit is a major participant in terms of operational reach since it offers a wide range of vehicle services.
2. What transit mode had the most total VRM in our data set?
The ‘Bus’ mode is the transportation mode with the largest total Vehicle Revenue Miles (VRM) in our dataset, with 4,944,449,088 VRM. This shows how many service kilometers buses go, underscoring their important function in the transportation network.
3. How many trips were taken on the NYC Subway (Heavy Rail) in May 2024?
1,804,588,19 unlinked passenger journeys were made on the MTA New York City Transit-operated NYC Subway (Heavy Rail) in May 2024. This graph illustrates how frequently the subway system was used in that particular month.
Code
nyc_subway_may_2024 <- USAGE %>%filter(Agency =="MTA New York City Transit", Mode =="Heavy Rail", month ==as.Date("2024-05-01")) %>%summarize(total_trips =sum(Unlinked_Passenger_Trips, na.rm =TRUE))
5. How much did NYC subway ridership fall between April 2019 and April 2020?
There was a notable decline in the number of riders of the NYC subway system from April 2019 to April 2020. There was a 2,119,696,600 reduction in unlinked passenger journeys overall. The COVID-19 epidemic, which resulted in significant cutbacks in public transportation utilization during that time, is blamed for this steep fall.
Code
nyc_subway_ridership_fall <- USAGE %>%filter(Agency =="MTA New York City Transit", Mode =="Heavy Rail", month %in%as.Date(c("2019-04-01", "2020-04-01"))) %>%group_by(month) %>%summarize(total_trips =sum(Unlinked_Passenger_Trips, na.rm =TRUE))fall_in_ridership <-diff(nyc_subway_ridership_fall$total_trips)
Task 4
Which agency recorded the highest number of unlinked passenger trips (UPT) in 2022.
With 2,278,853,098 unlinked passenger journeys (UPT) in total, the MTA New York City Transit was the agency that logged the most UPT in 2022. In a heavily populated urban region, this emphasizes the critical role the NYC transportation system plays in facilitating passenger movement.
Identify the mode of transport that showed the highest percentage growth in unlinked passenger trips (UPT) from 2021 to 2022.
According to the available statistics, Cable Car demonstrated the greatest percentage growth in unlinked passenger trips (UPT) between 2021 and 2022, growing at a pace of almost 221.15%. When compared to other forms of transportation, this suggests a notable comeback or rise in the use of cable cars during this time.
Which transit mode was the most common in terms of vehicle revenue miles (VRM) in 2022.
With a total of 2,178,902,024 vehicle revenue miles in 2022, bus travel was the most popular mode of transportation (VRM). This suggests that, in terms of distance traveled in revenue-generating services, buses were the most popular form of transportation.
# A tibble: 1,043 × 9
`NTD ID` Agency metro_area Mode UPT VRM `Agency Name` `Total Fares`
<dbl> <chr> <chr> <chr> <dbl> <dbl> <chr> <dbl>
1 1 King Cou… Seattle--… MB 5.40e7 6.16e7 King County … 56846337
2 1 King Cou… Seattle--… DR 6.63e5 1.29e7 King County … 832327
3 1 King Cou… Seattle--… FB 4.00e5 5.12e4 King County … 1715265
4 1 King Cou… Seattle--… SR 1.12e6 1.80e5 King County … 588495
5 1 King Cou… Seattle--… TB 9.58e6 2.64e6 King County … 10123486
6 1 King Cou… Seattle--… VP 7.03e5 4.41e6 King County … 5484481
7 2 Spokane … Spokane, … MB 6.60e6 6.49e6 Spokane Tran… 6135110
8 2 Spokane … Spokane, … DR 3.10e5 4.04e6 Spokane Tran… 531284
9 2 Spokane … Spokane, … VP 9.06e4 9.06e5 Spokane Tran… 247718
10 3 Pierce C… Seattle--… MB 4.95e6 4.23e6 Pierce Count… 4356831
# ℹ 1,033 more rows
# ℹ 1 more variable: Expenses <dbl>
Farebox Recovery Among Major Systems
Task 6
Which transit system (agency and mode) had the most UPT in 2022?
With a total of 1,793,073,801 journeys, the MTA New York City Transit operating in the Heavy Rail (HR) mode was the transit system with the most unlinked passenger trips (UPT) in 2022. This suggests that New York City’s subway system is used rather frequently.
Which transit system (agency and mode) had the highest farebox recovery, defined as the highest ratio of Total Fares to Expenses?
With a farebox recovery ratio of 2.38—the ratio of total fares to expenses—the Transit Authority, which operated the Vanpool (VP) mode, was the transit system with the greatest farebox recovery. This implies that the vanpool service is quite effective at using fare income to pay for its operating costs.
Which transit system (agency and mode) has the lowest expenses per UPT?
With costs of around 1.18 per trip, the North Carolina State Agency, which runs the Bus (MB) mode, is the transportation system with the lowest expenses per unlinked passenger trip (UPT). This suggests a very economical bus service.
Which transit system (agency and mode) has the highest total fares per UPT?
With an average fee of 660.12 per trip, Altoona Metro Transit, which operates in the Demand Response (DR) mode, is the transit system with the highest total charges per UPT. This points to a demand-responsive fare structure that is expensive or premium services.
Which transit system (agency and mode) has the lowest expenses per VRM?
The New Mexico Department of Transportation, which uses the Vanpool (VP) mode, is the transportation system with the lowest costs per vehicle revenue mile (VRM), spending only 0.34 per VRM. This suggests a particularly economical operation in relation to the miles of the vehicle.
Which transit system (agency and mode) has the highest total fares per VRM?
The Chicago Water Taxi, which uses the Ferry Boat (FB) mode and generates around 237.46 in revenues per VRM, is the transportation system with the highest total fares per VRM. This implies a high income generation per mile traveled, which might be brought about by a high amount of passengers or premium services.
Based on all of this, what do you believe to be the most efficient transit system in the country? (Your answer may differ depending on which form of ‘efficiency’ you care most about)?
Farebox Recovery (income Efficiency): If you were to rank the transit systems based on how much revenue they generate relative to their expenses, the system with the largest farebox recovery would be considered the most efficient. This illustrates how effectively fare income offsets system expenses. The system with the lowest expenses per Vehicle Revenue Mile (VRM) or Unlinked is the one with the most operational efficiency (Cost per Vehicle Revenue Mile, or UPT). If operational efficiency is more important, passenger trip (UPT). This demonstrates which system can continue to provide services with low operational expenses. If the objective is to maximize fare income per trip or mile, the system with the greatest total fares per UPT or per VRM may be examined. This is known as user efficiency (total fares per UPT or per VRM).