APTA Infrastructure Database - Real-Time Transit Data Systems

Name: APTA Infrastructure Database - Real-Time Transit Data Systems
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Agency-level real-time passenger information and vehicle-location system records from the APTA Infrastructure Database. One row is an organization with fields describing real-time data, AVL, arrival information, and related vendor or system attributes; the profile contains 407 organization rows.

american-public-transportation-association-infrastructure-real-time-data-systems·42 columns·43 KB·APTA statistical publication reuse terms / site copyright notice·updated 15d ago

Source: American Public Transportation Association · connector code

Schema

new_2018_data	string
last_data_reported_year	string
organization_name	string
organization_short_name	string
city	string
state	string
country	string
member_id	int64
avl_vendor_avail	int64
avl_vendor_trapeze	int64
avl_vendor_clever_devices	int64
avl_vendor_acs_xerox	int64
avl_vendor_mentor	int64
avl_vendor_init	int64
avl_vendor_routematch	int64
avl_nextbus	int64
avl_transloc	int64
avl_any	int64
avl_vendor_other	string
real_time_system_provided	string
real_time_vendor_transloc	int64
real_time_vendor_avail	int64
real_time_vendor_trapeze	int64
real_time_vendor_nextbus	int64
real_time_vendor_clever_devices	int64
real_time_vendor_xerox_smarttraveler	int64
real_time_vendor_transitapp	int64
real_time_any	int64
real_time_vendor_other	string
real_time_info_refresh_rate	int64
real_time_system_phone	int64
real_time_system_text_sms	int64
real_time_system_website	int64
real_time_system_smartphone_app	int64
api_nextbus	int64
api_gtfs_rt	int64
api_tcip	int64
api_in_house_developed	int64
api_other_proprietary_from_vendor	int64
api_any	int64
api_other	string
app_gallery_url	string

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"american-public-transportation-association-infrastructure-real-time-data-systems\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.