Data%20Available%20for%20Map%203

1
Data Available for Map 3

• Data available on corridor level
• Bubble charts
• Catalog data for route(s)

2
Example Data
3
Data Available
4
Zooming in to View Specific Sites

• Attributes of specific sites displayed
• Length
• Type of guardrail
• Location
• Upgrade needed
• Accident data

5
Zoomed In (Map 4)
6
Data Available for Map 4

• User able to retrieve data on a site
• Site attributes
• Accident data
• Citizen Complaints

7
Example data
8
New Kent Guardrail Catalog

• Catalog of guardrails currently in place on
  routes
• 30
• 33
• 60
• 106
• 155
• 249
• 273

9
Guardrail Catalog (cont.)
10
Preliminary Alteration of Catalog

• All routes put in one workbook
• Worksheet for each route
• Column labels aligned vertically to conserve
  space
• Experimentation using queries
• Guardrails needing upgrades

11
Analysis of Catalog Data

• Data analysis for each route
• Total number of guardrails
• Number of substandard guardrails
• Percentage of substandard guardrails
• Total length of guardrails
• Number of each type of end treatment
• Ultimately will be able to aggregate routes

12
Guardrails Needing Improvement
13
Improvements Needed For Different Routes
14
Addition of HTRIS Data

• HTRIS data added to a few locations for
  evaluation
• Graphs to compare accidents at different nodes

15
Location Key
16
Accident Types at Locations
Note Bubble size is value of property damage ()
17
Accident Types at Locations
Note Bubble size is value of property damage ()
18
Cost Analysis

• Observations
• End treatments
• Needed on all guardrails
• Similar cost for all end treatments (2500)
• Costs that cannot be determined from data
• Removal costs
• Landscaping cost
• Cost variability comes from difference in length

19
Visualization of Costs-Risk Tradeoffs

• Compare number and type of accidents vs. the cost
  of replacing the substandard guardrail

20
Accident Types at Locations
Note Bubble size is cost to upgrade ()
21
Adoption of Quantitative and Qualitative
Factors/Endpoints

• Identify factors considered in decision

22
Future Work

• Develop a fully detailed version of the map
• Investigate different integration methods between
  the catalog and map

23
Immediate Future Activities

• Screening for sites without guardrail currently
  in place
• Visual comparison between potential upgrades and
  construction

24
Resources

• Comparison Tool (Center for Risk Management of
  Engineering Systems, 1999)
• Graphical Aids to Decision Making (Tufte,
  )
• Transportation Planning ()
• Selection of Performance Metrics ()

25
Guardrail Prevalence vs. Accidents
Bubble size is DVMT