README for Leading in Sustainable Safety with V2X technology in Oakland County Michigan dataset from the Road Commission of Oakland County (RCOC) ---------------------------------------------------------------- LINKS TO DATASET ---------------------------------------------------------------- A. Dataset archive link: https://doi.org/10.21949/y6t3-e908 ---------------------------------------------------------------- SUMMARY OF DATASET ---------------------------------------------------------------- The Road Commission for Oakland County was awarded a USDOT SMART Planning Grant in 2023. P3Mobility was chosen to create a blueprint for building V2X (vehicle-to-everything) infrastructure that supports private investment while developing the plans for a larger scale V2X deployment. This was a "Planning Grant" so the majority of the data included are the foundational plans that were created for RCOC that have read-across to any jurisdiction looking to deploy V2X. Included in the project data repository for the PLANNING GRANT work stream are: 1. Stakeholder Interviews Report 2. Community Engagement Plan 3. Workforce Development Plan 4. Business and Financial Plan 5. Project Evaluation Plan 6. Final Implementation Report The project included a small "Pilot Deployment" at five intersections and with ten equipped vehicles. Included in the project data repository for the PILOT DEMONSTRATION work stream are: 1. Intersection Selection Analysis Data 2. Safety Crash Analysis 3. Installation Guideline Report & Site Survey 4. Prototype Demonstration Plan 5. Perception Object Message Plots ---------------------------------------------------------------- TABLE OF CONTENTS ---------------------------------------------------------------- A. General Information B. Sharing/Access & Policies Information C. Data and Related File Overview D. Methodological Information E. Update Log ---------------------------------------------------------------- A. GENERAL INFORMATION ---------------------------------------------------------------- 0. Title of Dataset: Leading in Sustainable Safety with V2X technology in Oakland County Michigan dataset from the Road Commission of Oakland County (RCOC) 1. Description of Dataset: All text reports are labeled in the following format: SMARTFY22N1P1G34_DMP_xxxx where xxxx is the name of the report. Example: SMARTFY22N1P1G34_DMP_Stakeholder Interviews 2. Dataset archive link: https://doi.org/10.21949/y6t3-e908 3. Authorship Information: Principal Data Manager Contact Information Jeremy Ward ORCiD: https://orcid.org/0009-0004-2170-6480 P3Mobility, Ann Arbor Michigan Email: jeremy.ward@p3mobility.com Contributor to the Dataset and Project Manager Contact Information Tom Tracz ORCiD: https://orcid.org/0009-0001-3851-175X P3Mobility, Ann Arbor Michigan Email: tom.tracz@p3mobility.com Dataset Reviewer and Approver Contact Information Danielle Deneau Road Commission of Oakland County, Waterford Michigan Email:ddeneau@rcoc.org 4. Date of data collection and update interval: Data collection from October 2023 until February 2025. Updates made from February 2025 until June 2025. 5. Geographic location of data collection: Oakland County, Michigan USA 6. Information about funding sources that supported the collection of the data: USDOT SMART Grant: 69A3552341011 ---------------------------------------------------------------- B. SHARING/ACCESS & POLICIES INFORMATION ---------------------------------------------------------------- 0. Recommended citation for the data: Ward, Jeremy, Tracz, Tom, and Danielle Deneau (2025). "Leading in Sustainable Safety with V2X technology in Oakland County Michigan dataset from the Road Commission of Oakland County (RCOC)", Strengthening Mobility and Revolutionizing Transportation (SMART) Program. https://doi.org/10.21949/y6t3-e908 1. Licenses/restrictions placed on the data: Data are in the Public Domain covered by Creative Commons License CC-BY. This categorization enables users to distribute, remix, adapt, and build upon the material in any medium or format, so long as attribution is given to the creator. 2. Was data derived from another source?: Transportation Improvement Association (TIA) Traffic Crash Analysis Tool (TCAT) SEMCOG bicycle and pedestrian demand areas analysis: https://bicycle-and-pedestrian-mobility-maps-semcog.hub.arcgis.com/pages/equity-and-demand-analysis SEMCOG safety plan: https://www.semcog.org/safety Pedestrian scores are from https://www.walkscore.com. Disadvantaged indicators are from https://screeningtool.geoplatform.gov/. Financial Impact of Crashs are from the National Safety Council USDOT V2X Hub Source Code ---------------------------------------------------------------- C. DATA & RELATED FILE OVERVIEW ---------------------------------------------------------------- 1. File List for the [PLANNING GRANT].zip collection A. SMARTFY22N1P1G34_DMP_Stakeholder Interviews.pdf This report is a summary of the OEM, Supplier, Fleet Management stakeholder interviews conducted to enable a more comprehensive understanding of the details required in the development, deployment and adoption of C-V2X technologies. These interviews were conducted on-line and individually with a consultant facilitator. B. SMARTFY22N1P1G34_DMP__Community Engagement Plan.pdf This document summarizes the plan to engage and educate the wider community on the benefits of C-V2X technology for Stage 2. It includes key messages, communication sequencing and methods, and stakeholder identification and considerations. C. SMARTFY22N1P1G34_DMP_Workforce Development Plan This document identifies the plan to educate RCOC and the wider community workforce on deploying and maintaining C-V2X technology for Stage 2. The emphasis is on the IOO fleet vehicle / aftermarket installations for the vehicle OBU system. D. SMARTFY22N1P1G34_DMP_Business Plan This document lays out how a business plan would be developed for V2X applications. It shows different models with recommendations for scaling V2X with public, private partnerships. E. SMARTFY22N1P1G34_DMP_Evaluation Plan This document introduces the V2X system piloted, targeted use cases, and the evaluation methodology from pre-deployment to intersection / vehicle validation to post deployment monitoring. The performance measures and evaluation plan for the Proof-of-Concept / Prototype are established. F. SMARTFY22N1P1G34_DMP_Final Implementation Report This document is the overall project summary and report out respecting the USDOT template. This pulls together the critical work packages, deliverables, and summary plans in a cohesive manner that highlights Stage 1 results and identifies the scaled Stage 2 recommendations. It includes the results of the prototype evaluation, challenges and lessons learned, and a holistic look at deployment readiness. 2. File List for the [PROTOTYPE DEMONSTRATION].zip collection A. SMARTFY22N1P1G34_DMP_Intersection Analysis This data set includes the GIS shapefiles that were used in the first phase of the project to help select the 5 pilot intersections from the more than 1400 signalized options inside Oakland County. It includes (2) shape files, each including their associated files (.shp, .shx, .dbf, etc.). These fed a custom tableau analytics tool that allowed visualization and reviews with the IOO. Shapefile 1: Crash data Shapefile 2: Includes all the intersections with fields for bike lanes, disadvantaged areas, adaptive traffic SCATS, salt routes, truck routes. Also shows Michigan DOT owned intersections. File 3: is an intersection criteria matrix that was helpful when trying to prioritize the different stakeholder inputs received. It used the Tableau data analysis for accidents and pedestrian counts but then overlaid key inputs like cabinet space, strong wireless backhauls, room in conduit for new cables with intangibles often missed (is the intersection convenient to do field testing at?). B. SMARTFY22N1P1G34_DMP_Intersection Crash Analysis This document is the crash analysis that was conducted for each of the five (5) intersections for a ten (10)-year period and within 250-ft of each intersection. The crash data was obtained using the RCOC's preferred database, the Transportation Improvement Association (TIA) Traffic Crash Analysis Tool (TCAT). C. SMARTFY22N1P1G34_DMP_Installation Plan This document is the hardware installation guide for the intersection upgrades for the V2x pilot intersections. Topics covered include RSU preparation and installation, and traffic cabinet device installation (edge computer, power distribution unit). A site survey was conducted as a pre-requisite and is included in the appendix. The survey details the cabinet space, existing equipment capability, and RSU mounting pole observations and recommendations, including photos. D. SMARTFY22N1P1G34_DMP_Prototype Demonstration Plan The "Prototype Demonstration Plan" serves as a comprehensive guide and blueprint for the successful prototype demonstration of C-V2X technology in Oakland County, Michigan. This document outlines the objectives of the prototype, technology architecture, deployment area, and integration considerations necessary for an effective V2X system. Importantly, this document not only guides the current prototype process but also serves as input for the future County-Wide Deployment plan, which will be developed in the final Implementation Report and executed in Stage 2 of the project. E. SMARTFY22N1P1G34_DMP_POM Plots This folder contains a visualization of Perception Object Messages (POMs), which are the outputs of a computer vision system that detected, classified, and tracked objects (e.g., pedestrians, vehicles) using fisheye cameras installed at the intersection. ---------------------------------------------------------------- D. METHODOLOGICAL INFORMATION ---------------------------------------------------------------- 1. Description of methods used for collection/generation of data: Support information on the DMP_POM Plots: Each POM includes information such as object type and estimated GPS location. This data was overlayed on a satellite photo of the intersection, enabling manual review and analysis. This process was used to identify performance issues such as blind spots, miscalibration, false positives, and misclassifications, and directly contributed to refining the performance of the system. The POM data was later converted to SAE J3224 Sensor Data Sharing Messages (SDSM) and broadcast via C-V2X Roadside Units (RSUs) as part of the system’s real-time V2X communications. 2. Instrument- or software-specific information needed to interpret the data: The following file types are standard for GIS mapping software: AUX, CSF, DBF, PRJ, SBN, SBX, SGML, SHP, LOCK, SHX, CSF, CPG, LYR, MXD, FDBINDEXES, GDBTABLE, GDBTABLX, ATX, SPX. Because the files pertain to map layers and images, they are best viewed using the software that the team used or with any open source 2D and 3D mapping software. The .shp file extension is used for ESRI Shape format, a popular geospatial vector data format for geographic information systems software. A shapefile stores non-topological geometry and attribute information for the spatial features in a data set. A shapefile consists of a set of 3 mandatory files, along with several optional files. Each file in the set shares the shapefile name with a different extension. The main file .shp stores the geometry and must always have an index file .shx. A dBASE file .dbf stores all the attributes of the shapes in the main file. Additionally, a projection file .prj stores the projection information (for more information on .shp files and software, please visit https://www.file-extensions.org/shp-file-extension). The .dbf file extension is traditionally used for database file by many database applications. The original program, which used the DBF file extension for its database, was dBAse. A major legacy of dBase is its dbf file format, which has been adopted in a number of other applications. For example, the shapefile format developed by ESRI for spatial data in a geographic information system uses .dbf files to store feature attribute data (for more information on .dbf files and software, please visit https://www.file-extensions.org/dbf-file-extension). A .shx file contains compiled shape data (building blocks, fonts) in form of the machine language compiled version of an .shp file. The file type is associated with AutoCAD, a CAD development platform, developed and sold by Autodesk, Inc (for more information on .shx files and software, please visit https://www.file-extensions.org/shx-file-extension). The Portable Document Format (PDF) file format was developed by Adobe Systems and represents two-dimensional documents in a device-independent and resolution-independent format. There are PDF readers available on many platforms, such as Xpdf, Foxit, and Adobe's own Adobe Acrobat Reader. PDF readers/viewers or online services for basic functions are generally free (for more information on .pdf files and software, please visit https://www.file-extensions.org/pdf-file-extension). ---------------------------------------------------------------- E. UPDATE LOG ---------------------------------------------------------------- This README for SMARTFY22N1P1G34_DMP file was originally created on June 14, 2025 by Tom Tracz, [0009-0001-3851-175X], P3Mobility Project Manager, tom.tracz@p3mobility.com 2025-05-14: Original file created