Employee-owned since 1981 / Cincinnati, Ohio

UTA APC Software

On-time performance and ridership.

UTA APC software turns raw on-vehicle records into on-time performance, ridership, running-time, and stop-activity reporting. UTA's software package provides 60+ reports, processed automatically every night, hosted on a secure AWS server and supported by UTA. Where a national reporting requirement applies, the same data meets it; in the U.S. that is FTA's NTD.

01 / Web reporting

What agency staff see when they log in.

Password-protected, cloud-hosted, and built to drill from a system-level summary all the way down to a single observation.

System OTP · AM peak, weekday
UTA on-time performance report showing per-timepoint OTP percentages plotted on a map
On-time performance mapped by timepoint, with drill-down by system, route, and direction, down to the individual observation.
Route ridership · NTD statistics
UTA route ridership report table showing UPT, PMT, revenue miles and revenue hours by route and day type
Day-type average and monthly-total UPT, PMT, VRM, VRH, deadhead and total miles/hours for any date range, with one-click CSV export.
Real-time passenger load
UTA live map showing vehicle locations with real-time passenger load percentages
Live vehicle location and current passenger load, published to rider-facing apps via GTFS-Realtime.

02 / Overnight processing

Five processing steps, every night.

Processing starts after the last vehicle returns to the garage and finishes before staff arrive. Each module runs its own data-validity checks, so the output is auditable at every step.

Step 01

Concatenate

Raw APC records from every vehicle are collected and assembled into a single day's dataset.

Step 02

Diagnostics

Hardware status, sensor communication, and data-quality checks flag anomalies before they contaminate results.

Step 03

Automated assignment

Each bus is matched to the block it actually operated. No manual driver login required.

Step 04

File creation

Validated observations are structured into analytic files, with non-revenue door activity filtered out.

Step 05

Database load

The finished set loads into the reporting database, complete before staff arrive each morning.

GTFS-Realtime REST API Power BI / Tableau / Excel / GIS export AWS-hosted · TLS 1.2 2FA / SSO authentication Automated email alerts

03 / Reports

What the reports cover.

60+ standard reports (trip, timepoint segment, schedule adherence, deadhead, productivity, wheelchair and bike usage), exportable to Excel, GIS, Tableau and more.

On-time performance analytics

OTP from every vehicle in revenue service, with drill-down by system, route, direction, and timepoint, mapped through Google Maps. Schedule deviation is computed from three measured times: first door open (arrival), last door close, and the moment the vehicle pulls away.

OTP service consistency

Goes beyond Early/On-Time/Late buckets to show whether a stop is consistently on time or randomly variable throughout the day, down to the minute.

Running time and schedule adherence

Segment running-time plots compare actual against scheduled running time; schedule adherence reports summarize by system, time period, and timepoint, down to the individual observation.

Bus stop and ridecheck reporting

Automated Ridecheck and Bus Stop Summary reports, including a cumulative-load column, replace manual ridechecks and support accuracy certification.

Web-based ridership reporting

UTA's password-protected reporting site is where the ridership reports live: day-type average and monthly-total UPT, PMT, VRM, VRH, deadhead and total miles/hours for any date range, with one-click CSV export.

National reporting (FTA NTD in the U.S.)

Processed APC data meets national ridership reporting requirements. In the U.S. that is FTA's National Transit Database: 100% of UTA APC agencies that have applied for NTD approval have received it, with non-revenue door activity filtered out of UPT and PMT automatically.

04 / Quality control and integration

How the data is checked, connected and kept secure.

APC administrative control reports

Proprietary control modules monitor the quality and quantity of APC data being collected and flag what needs attention. They are the controls behind three decades of certified ridership reporting. The methods are UTA's own; the output is a data set that holds up to audit.

APC diagnostics and exception reporting

Daily hardware-status totals, anomaly detection, and non-conforming bus exception reports, delivered by automated email alerts.

Data quality diagnostics

Every processing module runs its own data-validity checks, so the output is transparent and auditable at each step.

AVL and scheduling compatibility

UTA works with virtually all AVL and scheduling systems, and processes APC data from non-UTA counting systems.

GTFS-RT and API export

Publishes real-time passenger load and vehicle location as GTFS-RT feeds and REST APIs for rider-facing displays and third-party applications.

AWS-hosted data security

All processing, storage, and reporting run in AWS, controlled by security group rules, access control lists, and user/password, 2FA, or SSO authentication. A third-party AWS security partner monitors it.

A rider at a transit stop checking her phone

Real-time data

Passenger load and vehicle location, in real time.

Current passenger load and vehicle location are published as GTFS-Realtime feeds and REST APIs for rider-facing displays and third-party applications.

GTFS-RT · REST API

Already have an AVL/APC system?

UTA works with virtually all AVL and scheduling systems, processes non-UTA APC data, and diagnoses and remediates underperforming installs.

Contact us