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

2016Strawder, EstherPDFTech ReportFHWA-SA-16-061DTFH61-10-D-00022, Task Order T-13-003Highway safetyData analysisData collectionData fusionData sharingTraffic dataCase studiesUnited StatesUnited States. Federal Highway Administration. Office of SafetyBrown, RichardScopatz, Robert A.United States. Federal Highway Administration. Office of SafetyVHB/Vanasse Hangen Brustlin, Inc.Strawder, EstherFederal Highway AdministrationThe 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\u2122 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\u2122, and quality control checks prior to analysis.84