Post-event Connected Vehicle Data Exploration - Lessons Learned

Printable version [PDF 1 MB]

Travel Monitoring and Surveys
Office of Highway Policy Information
2024

[ Technical Report Documentation Page | Notice | Quality Assurance Statement ]

Table of Contents

1. Abstract
2. Introduction
3. CV Data and Size
4. Platform to Conduct Post-CV Data Analysis
   1. 4.1: Data Storage Concept
   2. 4.2: Data Analytics
5. Data Insights Explored
   1. 5.1: Identification of Vehicle Hard Brake and Acceleration Geolocations
      1. 5.1.a: OEM CV Data
      2. 5.1.b: JPO CV Pilot Data
   2. 5.2: Seatbelt Usage Exploration
      1. 5.2.a: OEM CV Seatbelt Data
      2. 5.2.b: JPO CV Pilot Data
   3. 5.3: Trip Distribution by Length
      1. 5.3.a: OEM CV Data
   4. 5.4: Posted Speed Limits vs. the 85th Actual Travel Speed
      1. 5.4.a: JPO Pilot Post-CV Pilot Data
   5. 5.5: Roadway Curvature and Frequency of Vehicle Maneuvers
6. CV Data Quality
7. Summary
8. Acknowledgements

List of Figures

1. Figure 1: Databricks architecture illustration
2. Figure 2: Illustrating hard acceleration densities in 4 square km by hour of the day and average speed
3. Figure 3: Hard brake densities per 4 square km by hour of the day and average speed
4. Figure 4: Hard brake counts and average speed in the highest frequency area (4 km²) by hour of the day
5. Figure 5: Counts of HA and HB events by wiper and seatbelt states
6. Figure 6: Maximum speed of HA and HB events by wiper and seatbelt states
7. Figure 7: Longitudinal acceleration points with different maneuver categories
8. Figure 8: Lateral acceleration points with different maneuver categories
9. Figure 9: Driver seatbelt usage by average speed thresholds
10. Figure 10: Passenger seatbelt usage by average speed thresholds
11. Figure 11: Driver seatbelt usage by travel distances
12. Figure 12: Passenger seatbelt usage by travel distances
13. Figure 13: Number of journeys by travel distances
14. Figure 14: Travel speed and travel time by travel distances
15. Figure 15: Frequencies of journeys occupied with front passenger by travel distances
16. Figure 16: Speed differences between the speed limits in TIM and the 85^th percentile of actual speeds
17. Figure 17: Actual 85^th percentile traffic speed vs posted speed by hour of the day
18. Figure 18: Wrong Path history of BSM data
19. Figure 19: OEM CV data records duplicated in one area

List of Tables

1. Table 1: Seatbelt usages in percentage by average travel speed thresholds
2. Table 2: Seatbelt usages in percentage by travel distances
3. Table 3: Wrong locations in vehicle movements

Next