Crash Record System

1
Crash Record System
JB Technology Inc.
2
Introduction

• Crash Record System (CRS) was designed
  specifically for the State of Washington and was
  developed by a traffic engineer.

JB Technology Inc.
3
Crash Record System

• Features
• Numerous reports
• Determine High Crash Intersections
• Determine High Crash Corridors
• Graph Trends
• Plot Intersection Crash Diagrams
• Import Data from WSDOT TDO

JB Technology Inc.
4
Crash Record System

• The following slide will list some of the the
  Crash Record System tasks.
• Click on a task for a detailed explanation

JB Technology Inc.
5
Crash Record System

• Entering/Importing Crash Records
• Filtering Data
• Working with Intersections
• Browsing Crash Records
• Creating a Street System
• Creating Reports
• Graphing Trends
• Scanned Reports
• JB Technologys Services

JB Technology Inc.
6
Crash Record System

• Entering Data
• Data can be entered manually, and quickly, with
  the help of many quick key macros. The next
  slide will show the Crash Record Systems manual
  data entry form.

JB Technology Inc.
7
Crash Record System

• The form closely resembles the State Patrols
  Collision Report form.

JB Technology Inc.
8
Crash Record System

• Importing Data
• The Washington State Department of Transportation
  Department Traffic Data Office (TDO) provides
  traffic crashes in electronic format.
• The program, TDO2CRS, which is included with the
  purchase of CRS, imports the TDOs data into the
  Crash Record System

JB Technology Inc.
9
Crash Record System

• The program, TDO2CRS, also converts crashes on
  State Routes that are coded by the TDO using the
  milepost system.

JB Technology Inc.
Back
10
Crash Record System

• Filtering Data
• One of the most important feature of any database
  application is the filtering of data. The Crash
  Record System provides many ways of filtering
  data.
• Appendix A of the manual provides a detailed
  explanation of filtering data with many examples.

JB Technology Inc.
11
Crash Record System
The following slides will illustrate the five
ways to filter the data.
12
Crash Record System

• Standard Filter
• The most common way to filter data. Using drop
  down lists, database fields can be selected with
  valid options with minimal user input.

JB Technology Inc.
13
Crash Record System
The above Standard Filter will display only
Rear-End crashes.
JB Technology Inc.
14
Crash Record System
This Standard Filter will display Rear End
crashes that occurred after 500 pm in the
afternoon.
JB Technology Inc.
15
Crash Record System

• Quick Filter
• Many times crash records are to be filtered by
  either the report number,date of the crash, or
  the case number. The Quick Filter provides the
  means to accomplish a quick filter.

JB Technology Inc.
16
Crash Record System
Enter the data to be filtered in the appropriate
box and click Go. The matching data records
will be displayed.
JB Technology Inc.
17
Crash Record System

• Intersection
• The intersection filter is used when performing a
  detailed analysis of an intersection. Some
  crashes that occur a distance from an
  intersection are intersection related.

JB Technology Inc.
18
Crash Record System
This example will find all the crashes at 30th
Ave. and Ocean Beach Hwy and all crashes within
75 feet of the intersection.
JB Technology Inc.
19
Crash Record System

• Saved
• Filters can be saved and reused. To reuse a
  saved filter, the appropriate filter is selected
  from the list.

JB Technology Inc.
20
Crash Record System
JB Technology Inc.
21
Crash Record System

• Advanced
• The advance filter option is used for those who
  are familiar with SQL queries. Appendix A
  contains all the data field names and their valid
  values.

JB Technology Inc.
22
Crash Record System
This example will display crash records that are
Property Damage Only and occurred at dawn.
JB Technology Inc.
Back
23
Crash Record System

• Working with Intersections
• City Traffic Engineers primary use of crash data
  is intersection analysis. The Main Menu contains
  a data grid that contains all the intersections
  that have a least on reported crash.

JB Technology Inc.
24
Crash Record System
The following slides will illustrate the
intersection related features.
JB Technology Inc.
25
Crash Record System
The beginning and ending dates can be set by
either the keyboard or a pop up calendar.
JB Technology Inc.
26
Crash Record System
Double clicking on an intersections name will
pop up this form. Intersection geometrics are
required to plot a crash diagram. Entering ADTs
are used in calculating crash rates. Traffic
control and speed limits are commonly miscoded.
JB Technology Inc.
27
Crash Record System
Clicking Coordinates allows GIS coordinates to
be entered. Crashes can be exported from several
reports in a format that can be easily imported
into GIS programs.
JB Technology Inc.
28
Crash Record System
Clicking Quick Report will display this form
which gives a summary of the crashes for the
highlighted intersection. This format is
similar to the format found on federal and state
grant applications.
JB Technology Inc.
29
Crash Record System
The Intersection Report will generate a tabular
report, a summary report and five graphs. The
next two slides will show a portion of a summary
report and a graph.
JB Technology Inc.
30
Crash Record System
JB Technology Inc.
31
Crash Record System
JB Technology Inc.
32
Crash Record System
Five different graphs can be generated, each
displayed as a pie chart or a bar graph. The
graphs can be printed, copied to the clipboard or
saved as a graphic file.
JB Technology Inc.
33
Crash Record System
A crash diagram of an intersection can be
generated. The diagram can be copied into other
applications and a report can be produced.
JB Technology Inc.
Back
34
Crash Record System

• Browsing Crash Records
• Crash records can be filtered, viewed, reports
  generated, and exported.

JB Technology Inc.
35
Crash Record System
The first step in browsing crash records is the
filtering of data.
JB Technology Inc.
36
Crash Record System
The following slides will illustrate the
available options when browsing crash records.
JB Technology Inc.
37
Crash Record System
The highlighted crash record can be edited by
clicking Edit. All the displayed crash records
can be edited by clicking Edit All
JB Technology Inc.
38
Crash Record System
The crash records can be exported in a text
format (csv) that can be imported directly into
Excel. Assigning coordinates to the crash records
will allow the exported records to be imported in
many GIS programs.
JB Technology Inc.
39
Crash Record System
The crash records can be re-filtered. The filter
criteria can be saved for future use.
JB Technology Inc.
40
Crash Record System

• The Crash Record System allows a scanned image of
  the crash record to be viewed.
• A one page Detailed Report can be generated for
  the highlighted file.
• A General Summary Report can be generated for all
  the UNCHECKED crash records.

JB Technology Inc.
Back
41
Crash Record System

• Creating a Street System
• The backbone to the Crash Record System is a
  standardized street name list and corridors.
• Street Names can be entered manually or imported
  from either an ASCII file or a Microsoft Access
  Database
• Corridors are defined using the developed street
  list.

JB Technology Inc.
42
Crash Record System
New street names can be manually entered. The
Crash Record System will check the existing
street name database table to ensure no duplicate
names.
JB Technology Inc.
43
Crash Record System
Street names can be imported from the Database
Import-Street Names menu option.
Street names can be imported from either a Text
file or a Microsoft Access database.
JB Technology Inc.
44
Crash Record System
A corridor can be created by selecting the
corridor street and selecting the intersecting
streets.
JB Technology Inc.
Back
45
Crash Data System

• Creating Reports
• One of the strengths of the Crash Record System
  is its reports. The program was designed by a
  traffic engineer.
• Sample of the reports can be found in the PDF
  file, Reports
• The following slides shows the reports that can
  be generated from the Report menu option.

JB Technology Inc.
46
Crash Record System

• Reports
• Corridor Report
• High Crash Location
• High Crash Corridor
• Statistical Report
• Warrants Report

JB Technology Inc.
Back
47
Crash Record System

• Corridor Report
• A corridor report can be generated for any
  defined corridor.
• Filters can be applied.
• Example Show only night time crashes

JB Technology Inc.
48
Crash Record System
The limits of the corridor is defined by simply
checking the beginning and ending points of the
corridor. Filters can be applied by clicking the
Filter.
JB Technology Inc.
49
Crash Record System
All reports are displayed for preview. After
review, the report can be printed.
JB Technology Inc.
Back
50
Crash Record System

• High Crash Location
• This report is the most important report for
  Traffic Engineers when applying for federal
  funds. The intersections are ranked three ways
• Number of Crashes
• Crash Rate
• Societal Cost

JB Technology Inc.
51
Crash Record System
A sample form illustrating the required data for
processing
JB Technology Inc.
52
Crash Record System
The following slides will describe the many
available options
JB Technology Inc.
53
Crash Record System

• Three reports can be generated from the high
  crash location list.
• High Location Report The report will list the
  high crash locations ranked three ways Number of
  Crashes, Crash Rate, and Societal Cost.
• Quick Report The highlighted intersection can
  have a Quick Report generated.
• Intersection Report The highlighted
  intersection can have an Intersection Report
  generated.

JB Technology Inc.
54
Crash Record System
A crash diagram and graphs can be generated for
the highlighted intersection.
JB Technology Inc.
55
Crash Record System
Entering ADT volumes are required to calculate
crash rates. Clicking Volumes will allow ADTs
for the highlighted intersection to be
entered. Clicking Calc. Rates will re-calculate
the crash rates and re-rank the list accordingly.
Selecting the Intersection Geometrics is required
for plotting a crash diagram
JB Technology Inc.
56
Crash Record System
The X, Y coordinates can be entered for the
highlighted intersection. The coordinates can be
used for importing the data into a GIS program.
JB Technology Inc.
57
Crash Record System

• The High Crash Location list can exported to a
  text file that can be imported into Excel. The
  Excel spreadsheet is formatted for easy use in
  GIS programs.
• The High Crash Location list can be saved and
  recalled later for further analysis.

JB Technology Inc.
Back
58
Crash Record System

• High Crash Corridors Report
• The High Crash Location Report is important for
  intersection improvements. The High Crash
  Corridors Report provides a bigger picture of
  areas that have a significant number of crashes.

JB Technology Inc.
59
Crash Record System
The minimum number of crashes required for the
report and the number of intersections to
comprise a corridor are the primary data required
to generate a High Crash Corridor Report.
JB Technology Inc.
60
Crash Record System
The following slides will describe the available
options
JB Technology Inc.
61
Crash Record System

• Two reports can be generated from the high crash
  corridor list.
• High Corridor Report The report will list the
  high crash locations ranked two ways Number of
  Crashes and Societal Cost.
• Corridor Report The highlighted corridor can
  have an Corridor Report generated.

JB Technology Inc.
62
Crash Record System

• The High Corridor list can exported to a text
  file that can be imported into Excel.
• The High Corridor list can be saved and recalled
  later for further analysis.

JB Technology Inc.
Back
63
Crash Record System

• Statistical Report
• The Statistical Report will generate a report
  that provides a myriad of statistical data.
• The following slides will shown some of the
  reports generated as part of the Statistical
  Report.

JB Technology Inc.
64
Crash Record System
Overall statistics are listed as well as crashes
by month.
JB Technology Inc.
65
Crash Record System
Crashes are compiled by Day of Week and Type of
Crash
JB Technology Inc.
66
Crash Record System
Crashes are sorted by Time of Day
JB Technology Inc.
67
Crash Record System
Other statistical data comparison included in the
Statistical Report are

• Severity
• Weather
• Roadway Surface Condition
• Light Condition
• Restraints
• Age
• Sex of Unit 01/Unit 02

• Time of Day vs Day of Week Matrix
• Time of Day vs Type of Crash Matrix
• Type of Crash vs Day of Week Matrix
• Pedestrian/Pedacycle Action

JB Technology Inc.
Back
68
Crash Record System

• Warrants Report
• One of the criteria for both traffic signal and
  all-way stop sign warrants is a specified amount
  of crashes during a 12 month period.
• The Crash Record System can scan the database and
  list those intersections which meet the minimum
  crash experience.

JB Technology Inc.
69
Crash Record System
Those non-signalized intersections that meet the
minimum crash experience are listed as shown
above.
JB Technology Inc.
70
Crash Record System
Those non-all-way stop intersections that meet
the minimum crash experience are listed as shown
above.
JB Technology Inc.
Back
71
Crash Record System

• Graphing Trends
• A picture is worth a 1,000 words. Presentation
  quality graphs are worth 1,000,000. The Trends
  menu option provides unlimited options on
  graphing standard and user defined trends.

JB Technology Inc.
72
Crash Record System
This is the Trends Form. The next series of
slides will illustrate the power of Trends.
JB Technology Inc.
73
Crash Record System
The most simple Trend is to graph the total
number of crashes for a series of years.
JB Technology Inc.
74
Crash Record System
The values of the graphs can also be viewed in a
tabular format.
JB Technology Inc.
75
Crash Record System
Over 40 pre-defined Trends can be selected from
the drop down list.
JB Technology Inc.
76
Crash Record System
Filters can be applied. Above, the filter is to
graph the number of crashes in which driver of
Unit 01 is less than 21 years old and has been
drinking.
JB Technology Inc.
77
Crash Record System
The above graph is the result of the filter shown
on the previous slide.
JB Technology Inc.
78
Crash Record System

• The Trends Graphs can be displayed as either a
  bar graph or a pie chart.
• The Trends Graphs can be
• Copied to the clipboard and pasted into other
  programs such as PowerPoint.
• Saved to a graphic file.
• Printed.

JB Technology Inc.
Back
79
Crash Record System

• Scanned Reports
• The Crash Record System can display a scanned
  image of the Collision Report
• Typically the sketch of the crash and the
  narrative is scanned.
• When conducting a detailed analysis, reviewing
  the scanned images of the crashes can be critical.

JB Technology Inc.
80
Crash Record System
The associated scanned image can be viewed,
printed, copied to the clipboard or saved as a
graphic file.
JB Technology Inc.
Back
81
Crash Record System

• JB Technology's Services
• JB Technology provides other services that
  compliment the purchase of the Crash Record
  System software. The following slides will
  provide a description of these services.

JB Technology Inc.
82
Crash Record System

• Crash Record System Setup
• Existing users of the UTEC version of CRS will
  have their existing data converted by JB
  Technology at no cost.
• JB Technology can set up the street name list and
  define corridors for new users.

JB Technology Inc.
83
Crash Record System

• JB Technology's Services
• JB Technology can manually enter all your crash
  records for your agency and e-mail, FTP, or send
  a CD with the database file. This service will
  provide the most current and accurate data.

JB Technology Inc.
84
Crash Record System

• JB Technology's Services
• If your agency wants to use WSDOT TDOs
  electronic data, JB Technology can set up your
  state route intersections and download the data
  on a monthly basis. This will ensure that all
  valid TDO data will be processed.

JB Technology Inc.
85
Crash Record System

• JB Technology's Services
• The Crash Record System can view scanned images
  of the collision record report. The scanned
  images are essential when performing a detailed
  analysis. JB Technology can scan your reports.

JB Technology Inc.
86
Crash Record System

• Let JB Technology Help You!
• E-Mail jbtech_at_jbtinc.com
• Fax [phone]
• Address 28701 NW Main Ave., Ridgefield, WA
  98642

JB Technology Inc.