![Page 1: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/1.jpg)
Integrating State and Local Safety Data
1
Roadway Safety Data Program
![Page 2: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/2.jpg)
2
Integration of State and Local Safety Data• Requires States to maintain a database to
support analysis of the safety of all public roadways.
Map 21
• Requires States to maintain an all-public-roads linear referencing system and all-public-roads basemap.
FHWA
States must undertake projects to collect and integrate local roadway
inventory data into a statewide database.
![Page 3: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/3.jpg)
3
Capabilities Assessment - Peer Exchanges
• Four regional State peer exchanges• Local data integration identified as a challenge• Data Collection rated 2.6 on 5 point scale,
Roadway Data Completeness Element: “Many States attributed their identification of a lower capability due to a lack of complete roadway inventories on locally maintained roadways and fewer roadway inventory elements collected.”
![Page 4: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/4.jpg)
What is Transportation Data Integration?
• Defined as the art and science of taking data from various sources and combining it all together to provide a unified database
• It is a key ingredient for overall information management in transportation organizations
• Data integration is essential to transform data into information that is used to support decision making at the various management levels
III-4
![Page 5: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/5.jpg)
Objective• The objective of this project is to build on the
results of the RSDPCA to develop guidance based on research, case studies, and pilot studies, to help agencies improve the integration of local road data into State systems.
![Page 6: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/6.jpg)
6
Task
• Develop Data Integration Case Studies• Conduct Local and State Data Integration Pilot Studies• Develop a Guide for Integration of Local and State Data• Develop strategic plan for further expansion of
integration of local data
![Page 7: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/7.jpg)
Case Studies
Real-world examples:• Challenges• Benefits• Reasons for
success/lessons learned• Applicability to other
agencies
Case studies: Michigan Roadsoft System for Local Roadway Data and AnalysisOhio Location Based Response SystemWisconsin information System for Local RoadsTennessee Roadway Information Management System
7
![Page 8: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/8.jpg)
Michigan’s Integration of State and Local Data
8
![Page 9: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/9.jpg)
Michigan’s Data Integration Challenges
• Varied capabilities among local agencies.• Interest in preserving local ownership and
control.• Lack of consistency in data structures and
data definitions.
9
![Page 10: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/10.jpg)
Solution: Michigan Roadsoft System for Local Roadway Data and Analysis
• Local agencies maintain separate databases.• CTT provides updates/support.• Similar structure and data definitions.
10
![Page 11: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/11.jpg)
Results
• Meets most – not all – local analysis needs.• No software cost for local agencies.• Improves data quality and consistency.
11
![Page 12: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/12.jpg)
Key Findings
• Long-term support is key.• Increased functionality increased the
user base.• Rapid prototyping is important for this
user base.
12
![Page 13: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/13.jpg)
Ohio’s Integration of State and Local Data
13
![Page 14: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/14.jpg)
Ohio’s Data Integration Challenges
• No single standard for creating local road maps.• No consistent linear referencing system. • No local address ranges in State road database.
14
![Page 15: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/15.jpg)
Solution: Ohio Location Based Response System
• State assigned route numbers and mileposts.• Local agencies collected data.• Information is available immediately.• Digital maps are available within six months.
15
![Page 16: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/16.jpg)
Results• Road centerline and milepost data improvement.• Crash location accuracy.• Mapping and data standards consistency.• Data collection streamlining.• 911 services routing improvement.
16
![Page 17: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/17.jpg)
Key Findings
• It is possible to integrate local road addressing and mile posting into a State system.
• Good communication is key.
17
![Page 18: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/18.jpg)
Wisconsin’s Integration of State and Local Data
18
![Page 19: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/19.jpg)
Wisconsin’s Data Integration Challenges
• Multiple maps.• Duplicate/incompatible systems.• No linear referencing system for local roads.• Lack of local support.
19
![Page 20: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/20.jpg)
Solution: Wisconsin Information System for Local Roads (WISLR)
“On/at/towards” linear referencing system.
• Local agencies collect/own data.• Centralized system available to all authorized users.
20
![Page 21: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/21.jpg)
Results• Statewide local roadway data consistency.• Redundancy reduction.• Expanded use.• Safety analysis efficiency.
21
![Page 22: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/22.jpg)
Key Findings• Local ownership is key.• WisDOT continually invests.• Cost-avoidance helps local agencies.• Continuous expansion builds the user base.
22
![Page 23: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/23.jpg)
Tennessee’s Integration of State and Local Data
23
![Page 24: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/24.jpg)
Tennessee’s Data Integration Challenges
• Majority of serious crashes occurred on local roads.
• Lack of/unavailable local data.• Data consistency.
24
![Page 25: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/25.jpg)
Solution: Tennessee Roadway Information Management System
• Contractor inventoried local roads and integrated data into TRIMS database.
• TDOT developed web-based eTRIMS.
25
![Page 26: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/26.jpg)
Results• Data accuracy.• Roadway information access.• Data analysis availability.• Location data accuracy.
26
![Page 27: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/27.jpg)
Key Findings• Data should be “real time.”• Data standards ensure quality.• State system updates may be necessary.• Data collection efforts should be improved
continuously.
27
![Page 28: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/28.jpg)
Pilot Studies
•Navajo Nation: Enterprise GIS Integration & Analysis•Rhode Island: Safety Data Integration Assistance•Arizona: Safety Data Integration for Safety Analysis•Indiana Local Technical Assistance Program•Northern Planes Tribal Technical Assistance Program
![Page 29: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/29.jpg)
Navajo Nation
• Top-Level Objective Integrate safety and roadway data through the creation of an enterprise GIS database in support of transportation safety analysis.
• Key Feature Incorporate a web-based system to share data and potentially collect future data.
• Expected Outcome Geo-located data to aid in resource management and safety analysis and increased data sharing among stakeholders and neighboring jurisdictions (e.g., internal Navajo enterprises, local agencies, State DOTs, and USDOT).
![Page 30: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/30.jpg)
Rhode Island State
• Top-Level Objective Integrate safety and roadway data in support of using HSM methodologies to support RIDOT’s reporting to the Highway Safety Improvement Program.
• Key Feature Integrate MIRE elements into a format usable for advanced analytical methods.
• Expected Outcome A tested protocol for the integration, governance, use, and continued maintenance of safety data for both the State and local agencies.
![Page 31: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/31.jpg)
Arizona State
• Top-Level Objective Integrate safety and roadway data in support of using HSM methodologies to support RIDOT’s reporting to the Highway Safety Improvement Program.
• Key Feature Integrate MIRE elements into a format usable for advanced analytical methods.
• Expected Outcome A tested protocol for the integration, governance, use, and continued maintenance of safety data for both the State and local agencies.
![Page 32: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/32.jpg)
Indiana and Montana Pilot Studies• Under Development
![Page 33: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/33.jpg)
Next Steps• Development of an informational guide– Introduction– Data Management, Governance, Stewardship, Maintenance– Data Integration– Data Collection– Data Analysis and Reporting– Promoting Data Integration
• Develop strategic plan for further expansion of integration of local data
• Technical Assistance
![Page 34: Integrating State and Local Safety Data 1 Roadway Safety Data Program](https://reader031.vdocuments.us/reader031/viewer/2022013012/5697bf991a28abf838c91ba2/html5/thumbnails/34.jpg)
For More Information
Contact:Stuart ThompsonFederal Highway Administration(202) [email protected]
State and Local Data Integrationhttp://safety.fhwa.dot.gov/rsdp/data_activities_state.aspx
34