Roadway Safety Data and Analysis Case Study: Arizona Importing Local and Tribal Data for Safety Analysis

The Arizona Department of Transportation (ADOT) and the Federal Highway Administration (FHWA) Office of Safety completed a pilot project that allows the State to acquire roadway data elements from local and Tribal agencies and load the data into the Arizona Transportation Information System (ATIS) database. ADOT created a new process that allowed business users to import the data from local agencies, export combined State and local/tribal data, and load data into AASHTOWare Safety Analyst™ for analysis. ADOT used contractor support to establish data integration procedures for crash, roadway, and traffic volume data for both roadway segments and intersections. The results from the pilot created processes for the data submissions to ADOT, data integration in ATIS, the ETL process for bringing data into AASHTOWare Safety Analyst™, and quality control checks prior to analysis.

• Record URL:
  https://safety.fhwa.dot.gov/rsdp/downloads/fhwasa16061.pdf
• 
• Corporate Authors:

  VHB

  8300 Boone Boulevard, Suite 700
  Vienna, VA  United States  22182-2626

  Federal Highway Administration

  Office of Safety
  1200 New Jersey Avenue SE
  Washington, DC  United States  20590
• Authors:
  • Brown, Richard
  • Scopatz, Robert
• Publication Date: 2016-10

Language

• English

Media Info

• Media Type: Web
• Edition: Case Study
• Features: Figures; References; Tables;
• Pagination: 16p

Subject/Index Terms

• TRT Terms: Case studies; Crash data; Data analysis; Data collection; Data fusion; Data sharing; Highway safety; Traffic data
• Identifier Terms: AASHTOWare (Software); Arizona Department of Transportation; Arizona Transportation Information System
• Geographic Terms: Arizona
• Subject Areas: Data and Information Technology; Highways; Safety and Human Factors;

Filing Info

• Accession Number: 01637642
• Record Type: Publication
• Report/Paper Numbers: FHWA-SA-16-061
• Contract Numbers: DTFH61-10-D-00022 Task Order T-13-003
• Files: TRIS, ATRI, USDOT
• Created Date: Jun 1 2017 2:19PM