CALIFORNIA
Computerized Collision Database and Analysis System

 

PROJECT CHARACTERISTICS PROGRAM AREA(S)
  Innovative or non-traditional approach   Traffic Records
       
TYPE OF JURISDICTION    
  City    
       
TARGETED POPULATION(S) JURISDICTION SIZE
  General Population
  120,000


PROBLEM IDENTIFICATION
The city of Rancho Cucamonga, California averaged 1,313 motor vehicle crashes per year for 1993, 1994 and 1995, with each year increasing the number of crashes from the previous year. This high rate of traffic crashes combined with a 210 percent population increase and a 206 percent increase in new roadway miles traveled since 1980, to produce a traffic safety situation which was not easily managed by city law enforcement or engineering personnel. Although the city maintained a collision record system, this system did not the provide quick and accurate data necessary to determine where scarce resources could best be used. City police and traffic engineers frequently were forced to respond to existing traffic safety situations, rather than being able to plan effective prevention strategies.


GOALS AND OBJECTIVES
The Computerized Collision Database and Analysis System (the System) was developed in 1996 by the Rancho Cucamonga Community Development Department, to reduce the frequency and severity of traffic crashes citywide. Specific objectives of the System were to:

  • Identify and purchase computer hardware to operate a traffic crash tracking system
  • Develop a database and crash analysis system to meet the requirements of city staff
  • Transfer all data from the previous data collection system to the new System
  • Train city staff in the proper use and maintenance of the System


STRATEGIES AND ACTIVITIES
Engineers from the Traffic Management Section of the Community Development Department researched the qualifications of computer software consulting companies that were qualified to provide a new crash data tracking system. Following selection of the software vendor, city staff and the software consultant developed a list of requirements for the new System. These included:

  • Developing a list of software-specific computer equipment necessary for the System
  • Upgrading existing computers rather than obtaining a new database-specific computer with limited access for city personnel
  • Purchasing ancillary hardware, including two printers and a color plotter, with the savings realized through upgrading existing computers
  • Developing data input methodologies, designing custom reports and creating mapping capabilities
  • Following the initial System installation on Traffic Management Section computers, the decision was made to install the System on police department computers, as well. Police department computers were equipped with software to track citations issued
  • Training was provided for city staff and the police department


RESULTS
The data provided by the System has enabled city staff to identify primary crash factors, and discover inefficiencies in crash count as well as speed survey programs. Analysis of System data has also helped to detect inadequacies of the former system, and to identify critical crash locations. Specific results include the following:

  • The ability to enter data quickly has saved the city approximately $25,000 each year
  • Timely reports of crash specifics provide city engineers and police officers with information necessary for accurate planning
  • Reports generated by the new System indicate that the frequency and severity of traffic crashes in Rancho Cucamonga have been reduced
 

FUNDING
  Section 402: $45,969
CONTACT  
 

James T. Harris
Associate Engineer
City of Rancho Cucamonga
Community Development Department
Traffic Management Section
10500 Civic Center Drive
Rancho Cucamonga, CA 91729-0807
(909) 477–2740, Ext. 4052


NATIONAL HIGHWAY TRAFFIC SAFETY ADMINISTRATION

SPRING 2000