Utah Transportation Data Wiki ‐ Data - utahDEST/Resources GitHub Wiki

Utah Transportation Data Wiki        Data        Tools        Products

Operations

Utah Transit Authority (UTA) Data Portal

Website: https://data-rideuta.opendata.arcgis.com/

Contact: Jim Wadley, UTA

Automated Traffic Signal Performance Measures

ATSPM's show real-time and historical functionality at signalized intersections. This allows traffic engineers to directly measure what previously could only be estimated and modeled.

Website: https://udottraffic.utah.gov/atspm

UDOT Traffic Operations Data

UDOT’s Traffic Management Division manages two data sources: Point sensors and aggregate probe data.

Raw and aggregated speed, volume and classification data in 5-minute bins for all Traffic Monitoring Station (TMS) sensors on UDOT roads. Data is available within five minutes using the Freeway PeMS website. See training videos for additional information. Statewide speed, travel time, delay and reliability data are available through the ClearGuide website. Data is available with 20 minutes. Access is restricted to UDOT projects. See training videos for additional information.

Source Website: https://www.udot.utah.gov/connect/business/traffic-data/traffic-operations-data/

Statewide Speed Data (Probe data)

UDOT purchases aggregated speed data for all state roads. This data is used for traffic operations analysis and travel time messaging on Variable Message Signs and UDOT Traffic maps.

This data is available through the ClearGuide website. Access is currently limited to UDOT staff and consultants working on UDOT projects.

Website: https://www.iteris-clearguide.com

Traffic Monitoring Stations (Point data)

UDOT has over 720 Traffic Monitoring Stations (TMS) installed on state roads, concentrated in urban areas. These sensors collect vehicle speed, volume and classification data by lane, including ramps.

The primary purpose of the TMS sensors is to provide real-time data to UDOT’s ramp meters, Express Lanes system, and travel time messaging on Variable Message Signs and UDOT Traffic maps. This data is also used extensively for traffic operations analysis and transportation planning.

Data from TMS can be accessed through the Freeway PeMS website. Click here to apply for an account.

Safety

Planning

Planning Data Resources at Utah Geospatial Resource Center (URGC)

Website: https://gis.utah.gov/data/planning/

Contact: Bert Granberg, WFRC

Surveys

Utah Household Travel Survey (2012, 2023)

Access questionnaire, codebook, data explorer: https://unifiedplan.org/household-travel-surveys/

BigQuery example of accessing data via API in jupyter notebook: https://github.com/WFRCAnalytics/Resources/tree/master/BigQuery/HTS

uDEST April 2024 Meeting recording: https://drive.google.com/file/d/16LVWwxNDR82ghMVAGWqzr_38rN0_vArR/view

UTA On-Board Travel Survey (2023)

UDOT Traffic Statistics

Traffic statistics include Annual Average Daily Traffic (AADT) and Vehicle Miles Traveled (VMT). Due to the large amount of statistically significant calculations and reporting regulations, this data typically takes several months to prepare.

Source Website: https://www.udot.utah.gov/connect/business/traffic-data/traffic-statistics/

Annual Average Daily Traffic (AADT)

The total volume of vehicle traffic of a highway or road for a year divided by 365 days. It is meant to represent traffic on a typical day of the year. The AADT reports and map are updated annually and are available in the summer/fall after the completed year. Google Earth Map – Click on the roadway sections colored in red, blue, and green to display the current and historical AADT. (NOTE: You must have Google Earth installed on your computer to view this map. Please click here to download a free copy of Google Earth Pro for Desktop.) Updated annually by August after the previous year has been completed.

AADT History – Rounded and Unrounded AADT history for State and Federal-Aided roadways. Updated annually by August after the previous year has been completed.

Truck Traffic – Unrounded AADT’s with Single Unit and Combination truck percentages for State routes only. Updated annually by August after the previous year has been completed.

Hourly Volumes from Continuous Count Station (CCS)

CCS Hourly Volumes (1990-Present) – Google Sheet files that contain hourly volumes by lane. Updated annually within 6 weeks after the end each month.

WFRC processes the CCS factors for a statewide dataset of planning factors. These resources include:

Vehicle Miles of Travel (VMT)

Vehicle Miles of Travel (VMT) are a measure of the total amount of miles traveled in a year. This is calculated by taking Annual Average Daily Traffic (AADT) and mile length for a specific section and summing them by all sections being used and reported for. A key point in Daily VMT is that it is the daily average, not yearly. For yearly averages of VMT (Annual VMT), the daily calculation is multiplied by 365.25. Historical VMT Dashboard – Annual VMT matching UDOT’s HPMS submission to FHWA. Data within the dashboard is reported by Year, Functional Class, and Ownership. Updated Annually by August after the previous year has completed. Annual VMT by County (Google Sheet) – Historical VMT and Cumulative Estimated VMT for the current year up to the present Month. Updated Monthly within 6 weeks after the end of each month.

Origin-Destination Data

StreetLight

StreetLight data is from GPS and location information from cell phones and other GPS devices through an agreement with data providers. The service can help analyze traffic over different time periods ranging from days to weeks to months.

StreetLight data is available in two formats, a 2019 dataset purchase and data obtained via ad hoc through the insights platform.

2019 Dataset Purchase

The data from the 2019 dataset purchase is still available for use by partner agencies. The data contains Origin-Destination flows by vehicle type for the entire state at the Utah Statewide Travel Model (USTM) Transportation Analysis Zone (TAZ) level.

Additionally, some TAZs were further split to obtain more refined data for recreational and education uses. The additional TAZ splits contained in the StreetLight data can be found at this webmap: StreetLight TAZ 2019 Splits - Trailheads, High Schools, Etc.

The data ownership is shared among Utah's partner transportation agencies. Agencies can use and publish data as needed, as long as any original StreetLight data files remain private. The data is housed in BigQuery by UDOT.

Contact Natalia Brown at UDOT for access to the data.

The following documentation was provided from the data vendor:

Data tables in BigQuery ut-udot-adap-prod project include the following:

  • streetlight_taz: Transportation Analysis Zones (TAZ) and additional splits for streetlight analysis including all districting and other information included in original shapefile. Includes geometry field for polygon shape.
  • udot_commercial_all_year_2019: Commercial vehicle trips separated by truck weight (medium and heavy) averaged over entire year of 2019
  • udot_commercial_fall_2019: Commercial vehicle trips separated by truck weight (medium and heavy) averaged over fall of 2019 (September-November)
  • udot_commercial_spring_2019: Commercial vehicle trips separated by truck weight (medium and heavy) averaged over spring of 2019 (March-May)
  • udot_commercial_summer_2019: Commercial vehicle trips separated by truck weight (medium and heavy) averaged over summer of 2019 (June-August)
  • udot_commercial_winter_2019: Commercial vehicle trips separated by truck weight (medium and heavy) for winter of 2019 (January-February, December)
  • udot_entries_2019: pass-through polygons for border locations around the state for entering side of roadway
  • udot_exits_2019: pass-through polygons for border locations around the state for existing side of roadway
  • udot_personal_all_year_2019: Personal vehicle trips averaged over all of 2019
  • udot_personal_fall_2019: Personal vehicle trips averaged over fall of 2019 (September-November)
  • udot_personal_spring_2019: Personal vehicle trips averaged over spring of 2019 (March-May)
  • udot_personal_summer_2019: Personal vehicle trips averaged over summer of 2019 (June-August)
  • udot_personal_winter_2019: Personal vehicle trips averaged over winter of 2019 (January-February, December)
  • udot_zones_2019: Zones used in analysis. This only includes name and geometry field for polygon shape. Should be the same name and geometry as found in streetlight_taz.

To link the data tables with the geometry tables use the following key fields

  • streetlight_taz: SL_COTAZID
  • udot_entries_2019, udot_exits_2019: name
  • udot_zones_2019: zone_name
  • commercial and personal tables: origin_zone_name and destination_zone_name

One example of the data can be found in this WFRC app that looks at trips to and from TDM special generators: Origin-Destination Data for Special Generator TAZs - StreetLight Data 2019

Ad Hoc Queries through 2021

In addition to the 2019 data purchase, a license to the Insights platform was available to partner agencies through 2023. Numerous ad hoc queries were run using this platform. The scope of these queries much more limited with only 500 custom zones shared amongst partner agencies being available for analysis.

Though more limited in geographic scope, there was an added ability to query a few additional modes, including bus transit, rail transit, bicycle, and pedestrian.

Toward the end of the contract the following queries were automated via StreetLight API to gather data through a range of hundreds of queries that could be compiled and used further:

WFRC

  • Roadway and transit segments
  • Socioeconomic forecast data
  • Access to Opportunities forecasts
  • Origin/destination flow forecasts
  • Ridership forecasts
  • Roadway volume forecasts
  • Transit ridership forecasts
  • Travel demand model results

WFRC Data Portal: https://data.wfrc.org/

Storing data

  • Google BigQuery
  • SQL Databases