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:
  • Corporate Authors:


    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


  • English

Media Info

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

Subject/Index Terms

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: May 17 2017 8:05AM