Regional Transportation Safety Information Management System

The Regional Transportation Safety Information Management System (RTSIMS) Version 2.0

The Regional Transportation Safety Information Management System (RTSIMS) software is MAG’s tool for performing crash data analyses. This helps regional transportation safety planning. The RTSIMS software was developed through on-call consultant projects and with state funds from the Arizona Department of Transportation (ADOT). This effort received input from local agencies in the MAG region. It is constantly improved based on user feedback. Oversight is provided by the ADOT and MAG’s Transportation Safety Committee.

The RTSIMS development process has produced useful reference documents and fruitful discussions among road safety practitioners in the MAG region. These outcomes have contributed much towards improving the state of practice in transportation safety planning in Arizona.

Key Functions of RTSIMS

RTSIMS has an interface that offers users the ability to search the crash database and perform many macro-level crash data analyses. RTSIMS can perform macro-level of crash analysis for one jurisdiction or for the entire MAG planning area. It can also do micro-level analysis at a specific intersection. MAG staff provide assistance to local agencies that submit requests for performing crash data analyses. Presently, intersection collision diagrams cannot be generated using RTSIMS.

An RTSIMS user has two options to construct and run queries on the crash database. (1) Standard Reports – these are the basic and most common queries in any crash data analysis. The user selects variables from drop down menus to construct and submit these queries. (2) Custom Reports – these provide the user the ability to construct a wide range of queries by defining desired report type and building applicable data filters. Standard Reports are easy to generate and will provide answers to most questions on citywide crash occurrence trends. Custom Reports require a higher level of knowledge in crash data analysis and the data structure of the ADOT ALISS database. RTSIMS can generate reports with statistics and the corresponding graphics (tables, bar/pie charts and trend lines). Upon generating a report a user may export the results shown in the report in a preferred format. Another feature that is part of RTSIMS 2.0 provides the ability to export raw data from any RTSIMS query.

Historical Crash Data Archive

The RTSIMS software runs queries on an archive of crash data related to the MAG planning area. The source of this crash data is the ALISS crash database maintained by ADOT. As new crash data are released by ADOT it is incorporated into the MAG crash data archive. As of February 2017, the crash database at MAG covers the years 1999 through 2015. Updating the crash database for the previous year generally occurs mid-year.

User Guide

A user guide has been developed for RTSIMS 2.0 and is for use by end users. Any comments and suggestions from end users to improve it are welcome.

Technical Support

Users may contact Margaret Boone at MAG for assistance with building complex queries.

Current Capabilities of RTSIMS 2.0

RTSIMS 2.0 has the following capabilities:

  • Use standard queries that are incorporated in RTSIMS to examine historical crash data, produce reports and charts, export reports in several formats, and export raw data from a query.
  • Construct and run custom queries (requires familiarity with the ALISS database and crash data coding) to perform complex crash data analyses.
  • Perform network screening analysis for all intersections in a local agency’s jurisdiction. The MAG Network Screening Method is used for selected years of crash data to produce a ranked list of intersections based on crash risk.
  • Perform intersection ranking based on Equivalent PDO by defining a custom KABCO weighting scale.

Disclaimer

RTSIMS software generates reports by running SQL queries on an archive of crash data that represents all reported crashes in the MAG region. The source of this crash data is the ALISS crash database maintained by ADOT. As with any large database, there may be some errors in the data. MAG does not, at present, perform any data scrubbing to eliminate errors.

Gov Delivery Envelope Get e-mail updates! /

Senior Program Manager - ITS and Safety
Sarath Joshua

ITS Safety Engineer III
Margaret Boone

There are currently no projects associated with this project

About MAG

The Maricopa Association of Governments (MAG) is a Council of Governments (COG) that serves as the regional planning agency for the metropolitan Phoenix area.

Title VI

Title VI requires that no person in the United States of America shall, on the grounds of race, color, or national origin, be excluded from the participation in, be denied the benefits of, or be otherwise subjected to discrimination under any program or activity for which MAG receives federal financial assistance.

Get in Touch

  • Address: 302 N. 1st Ave., Suite 300
    Phoenix, Arizona 85003

  • Phone: (602) 254-6300

  • FAX: (602) 254-6490

  • Email: mag@azmag.gov