crash record system
Download
Skip this Video
Download Presentation
Crash Record System

Loading in 2 Seconds...

play fullscreen
1 / 86

Crash Record System - PowerPoint PPT Presentation


  • 223 Views
  • Uploaded on

Crash Record System. JB Technology Inc. Introduction. Crash Record System (CRS) was designed specifically for the State of Washington and was developed by a traffic engineer. JB Technology Inc. Crash Record System. Features Numerous reports Determine High Crash Intersections

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Crash Record System' - tate-holcomb


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
crash record system
Crash Record System

JB Technology Inc.

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

JB Technology Inc.

crash record system1
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.

crash record system2
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.

crash record system3
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 Technology’s Services

JB Technology Inc.

crash record system4
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 System’s manual data entry form.

JB Technology Inc.

crash record system5
Crash Record System

The form closely resembles the State Patrol’s Collision Report form.

JB Technology Inc.

crash record system6
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 TDO’s data into the Crash Record System

JB Technology Inc.

crash record system7
Crash Record System

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

Back

JB Technology Inc.

crash record system8
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.

crash record system9
Crash Record System

The following slides will illustrate the five ways to filter the data.

crash record system10
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.

crash record system11
Crash Record System

The above Standard Filter will display only Rear-End crashes.

JB Technology Inc.

crash record system12
Crash Record System

This Standard Filter will display Rear End crashes that occurred after 5:00 pm in the afternoon.

JB Technology Inc.

crash record system13
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.

crash record system14
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.

crash record system15
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.

crash record system16
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.

crash record system17
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.

crash record system18
Crash Record System

JB Technology Inc.

crash record system19
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.

crash record system20
Crash Record System

This example will display crash records that are Property Damage Only and occurred at dawn.

Back

JB Technology Inc.

crash record system21
Crash Record System
  • Working with Intersections
    • City Traffic Engineer’s 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.

crash record system22
Crash Record System

The following slides will illustrate the intersection related features.

JB Technology Inc.

crash record system23
Crash Record System

The beginning and ending dates can be set by either the keyboard or a “pop up” calendar.

JB Technology Inc.

crash record system24
Crash Record System

Double clicking on an intersection’s 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.

crash record system25
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.

crash record system26
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.

crash record system27
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.

crash record system28
Crash Record System

JB Technology Inc.

crash record system29
Crash Record System

JB Technology Inc.

crash record system30
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.

crash record system31
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.

Back

JB Technology Inc.

crash record system32
Crash Record System
  • Browsing Crash Records
    • Crash records can be filtered, viewed, reports generated, and exported.

JB Technology Inc.

crash record system33
Crash Record System

The first step in browsing crash records is the filtering of data.

JB Technology Inc.

crash record system34
Crash Record System

The following slides will illustrate the available options when browsing crash records.

JB Technology Inc.

crash record system35
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.

crash record system36
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.

crash record system37
Crash Record System

The crash records can be re-filtered.

The filter criteria can be saved for future use.

JB Technology Inc.

crash record system38
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.

Back

JB Technology Inc.

crash record system39
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.

crash record system40
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.

crash record system41
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.

crash record system42
Crash Record System

A corridor can be created by selecting the corridor street and selecting the intersecting streets.

Back

JB Technology Inc.

crash data system
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.

crash record system43
Reports

Corridor Report

High Crash Location

High Crash Corridor

Statistical Report

Warrants Report

Crash Record System

Back

JB Technology Inc.

crash record system44
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.

crash record system45
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.

crash record system46
Crash Record System

All reports are displayed for preview. After review, the report can be printed.

Back

JB Technology Inc.

crash record system47
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.

crash record system48
Crash Record System

A sample form illustrating the required data for processing

JB Technology Inc.

crash record system49
Crash Record System

The following slides will describe the many available options

JB Technology Inc.

crash record system50
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.

crash record system51
Crash Record System

A crash diagram and graphs can be generated for the highlighted intersection.

JB Technology Inc.

crash record system52
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.

crash record system53
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.

crash record system54
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.

Back

JB Technology Inc.

crash record system55
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.

crash record system56
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.

crash record system57
Crash Record System

The following slides will describe the available options

JB Technology Inc.

crash record system58
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.

crash record system59
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.

Back

JB Technology Inc.

crash record system60
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.

crash record system61
Crash Record System

Overall statistics are listed as well as crashes by month.

JB Technology Inc.

crash record system62
Crash Record System

Crashes are compiled by Day of Week and Type of Crash

JB Technology Inc.

crash record system63
Crash Record System

Crashes are sorted by Time of Day

JB Technology Inc.

crash record system64
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

Crash Record System

Other statistical data comparison included in the Statistical Report are:

Back

JB Technology Inc.

crash record system65
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.

crash record system66
Crash Record System

Those non-signalized intersections that meet the minimum crash experience are listed as shown above.

JB Technology Inc.

crash record system67
Crash Record System

Those non-all-way stop intersections that meet the minimum crash experience are listed as shown above.

Back

JB Technology Inc.

crash record system68
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.

crash record system69
Crash Record System

This is the Trends Form. The next series of slides will illustrate the power of Trends.

JB Technology Inc.

crash record system70
Crash Record System

The most simple Trend is to graph the total number of crashes for a series of years.

JB Technology Inc.

crash record system71
Crash Record System

The values of the graphs can also be viewed in a tabular format.

JB Technology Inc.

crash record system72
Crash Record System

Over 40 pre-defined Trends can be selected from the drop down list.

JB Technology Inc.

crash record system73
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.

crash record system74
Crash Record System

The above graph is the result of the filter shown on the previous slide.

JB Technology Inc.

crash record system75
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.

Back

JB Technology Inc.

crash record system76
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.

crash record system77
Crash Record System

The associated scanned image can be viewed, printed, copied to the clipboard or saved as a graphic file.

Back

JB Technology Inc.

crash record system78
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.

crash record system79
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.

crash record system80
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.

crash record system81
Crash Record System
  • JB Technology\'s Services
    • If your agency wants to use WSDOT TDO’s 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.

crash record system82
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.

crash record system83
Crash Record System
  • Let JB Technology Help You!
    • E-Mail: [email protected]
    • Fax: (360) 887-3410
    • Address: 28701 NW Main Ave., Ridgefield, WA 98642

JB Technology Inc.

ad