The Regional Transportation Safety Information Management System (RTSIMS) software currently serves as the key analytical tool at MAG for performing crash data analyses in support of transportation safety planning at the regional level. The RTSIMS software was developed through several on-call consultant projects , utilizing state funds provided by the Arizona DOT. The software development effort was carried out with input from local agencies in the MAG region, using both consultant and in-house staff expertise. It is being continuously improved based on feedback from end users. Oversight for this undertaking is provided by the Arizona DOT and the MAG Transportation Safety Committee. The first version of the RTSIMS software, Version 1.0, was installed at a number of local agencies in 2009, at the request of safety planning staff at these agencies. The current version, RTSIMS 2.0, is a much improved version planned to be made available in Spring 2017 with secure online access. Online access to the software will be available to interested local agencies in the MAG region, provided the agency has signed a Data Agreement with the Arizona DOT (a list of agencies is posted under Resources). It is recommended that local agencies interested in using RTSIMS should have agency staff familiar with crash data formats, Arizona ALISS definitions and crash analysis methods. Interested local agencies may submit a request to MAG using the RTSIMS Access Request Form posted under Resources.
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.
RTSIMS has an intuitive and user-friendly interface that provides end users with the ability to query the crash database and perform various macro-level crash data analyses. RTSIMS is capable of performing macro-level of crash analysis for an entire jurisdiction or for the entire MAG planning area. It also has some ability to perform micro-level analysis such as at a specific intersection. MAG staff will provide assistance to local agencies that submit requests for performing crash data analyses, provided such analyses can be performed efficiently using RTSIMS. At present, intersection collision diagrams cannot be generated using RTSIMS.
A user of RTSIMS 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 can select 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 very easy to generate and will provide answers to most questions on citywide crash occurrence trends. Custom Reports are complicated to construct and require a higher level of knowledge in crash data analysis and the data structure of the ADOT ALISS database. RTSIMS has the capability to 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. A new feature that was added to RTSIMS 2.0 in 2016 provides the ability to export raw data from any RTSIMS query.
The RTSIMS software runs queries on an archive of crash data, pertinent to the MAG Planning Area, maintained by MAG. The source of this crash data is the ALISS crash database maintained by Arizona DOT. As new crash data are released by Arizona DOT, it is downloaded and incorporated into the MAG crash data archive. As of February 2017, the crash database at MAG covers the years 1999 through 2015. Updating of the crash database for the previous year generally occurs mid-year.
A User Guide has been developed for RTSIMS 2.0 and is posted below in the Resource Library for use by end users. It is a not a perfect document and any comments and suggestions from end users are always welcome.
A training workshop on RTSIMS is planned following the initial rollout and periodically thereafter. Users may also contact Margaret Boone at MAG for assistance with building complex queries.
As of February 2017 RTSIMS 2.0 has the following capabilities:
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 the Arizona DOT. As with any large database, there will be some errors in the data. MAG does not, at present, perform any data scrubbing to eliminate errors.
Webpage Last Updated – Feb 10, 2017
Get e-mail updates! /
In an effort to make information delivery faster, MAG has implemented an e-mail notification system that will make it easier to receive documents such as agendas, minutes and reports. Through a free subscription service called GovDelivery, MAG member agencies and the public will have better access to information that is posted on the MAG Web site.
The subscription service monitors specific Web pages for changes, and when a change is detected, the service sends an e-mail to subscribers notifying them of the change. Users can choose to subscribe to as many of the pages as they wish. There are about 130 monitored pages on the MAG Web site.
As a subscriber, you can choose not only what information you receive, you can also choose how often you receive it—immediately, daily, or weekly.
To subscribe, simply click on the link on the page that says “Sign up to receive email updates.” Users can also click on a Quick Subscribe link on various pages to see a full list and subscribe to any of the MAG pages. To subscribe, only a few pieces of information will be required, such as e-mail address, delivery preferences and organization.
Look for the red envelope icon on pages of interest.
Senior Program Manager - ITS and Safety
ITS Safety Engineer III