The Regional Transportation Safety Information Management
System (RTSIMS) Version 2.0
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.
Key Functions of RTSIMS
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.
Historical Crash Data Archive
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.
Current Capabilities of RTSIMS 2.0
As of February 2017 RTSIMS 2.0 has the following capabilities:
- Utilize standard queries that are incorporated in RTSIMS to help examine historical crash data and produce reports and charts, export reports in several preferred 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, using the MAG Network Screening Method 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
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