Roadway Information Database (RID)

The Roadway Information Database enables safety researchers to explore the relationships between driver, vehicle, and roadway.

Existing State Metadata

Florida (PDF)

Indiana (PDF)

New York (PDF)

North Carolina (PDF)

Pennsylvania (PDF)

Washington (PDF)

Supplemental Data

The supplemental data effort initiated with a feasibility study before SHRP 2 gave permission to proceed with data acquisition. The feasibility study addressed the availability and cost of acquiring data items specific to the SHRP 2 Safety and Reliability focus areas and integrating these data into the SHRP 2 RID. An initial list of over 30 potential supplemental data items was expanded to include roughly 125 items within four categories, including safety, reliability, common items to both safety and reliability, and policy. Input from both safety and reliability professionals helped to narrow this comprehensive list down to approximately 32 items. Using this prioritized list as a starting point, the research team contacted agency staff within the six NDS sites and private data sources, and recommended 20 data items for acquisition across the six NDS sites. Table below presents the top priority data items acquired by the project team that are included in the RID. The rest of the tables provide a summary by study site.

Data items for supplemental data

Priority	Item	Category
1	Crash data	Common
1	Traffic information: AADT	Safety
1	Aerial imagery	Common
1	Speed limit data	Safety
1	Speed limit laws	Policy
1	Cell phone and text messaging laws	Policy
1	Automated enforcement laws	Policy
1	Alcohol-impaired and drugged driver laws	Policy
1	Graduated driver licensing (GDL) laws	Policy
1	State motor cycle helmet use laws	Policy
1	Seat belt use laws	Policy
1	Local climatological data (LCD) from NOAA	Common
1	Cooperative weather observer/other sources	Common
2	Winter road conditions (from DOTs)	Common
2	Work zone	Common
2	511 information	Common
2	Trafic data: continuous counts (annual traffic report [ATR])	Safety
2	Traffic data: short duration counts	Safety
2	Changes to existing infrastructure condition	Safety
2	Roadway capacity improvements	Common

Summary for Florida

No.	Item	Priority	Category	Data Description	Integration	Data Frequency
20	Roadway Capacity Improvements	2	Common	Kml data from FL DOT of projects completed within 2011 – 2013	Convert to GIS then conflate	Yearly
19	Change in existing infrastructure condition	2	Safety	Kml data from FL DOT of projects completed within 2011 – 2013	Convert to GIS then conflate	Yearly
18	Traffic Data – Short Duration Counts	2	Safety	2011 – 2013 short duration shapefile data from FL DOT	Conflate to network	Yearly
17	Traffic Data – Continuous Counts (ATR)	2	Safety	2011 – 2013 ATR shapefile data from FL DOT	Conflate to network	Yearly
16	511 Information	2	Common	2011 – 2013 511 data including work zones impacting roadway	TBD	Yearly
15	Work Zone	2	Common	2011 – 2013 511 data including work zones impacting roadway	TBD	Yearly
14	Winter Road Conditions (DOT)	2	Common	Not Applicable	None	NA
13	Cooperative Weather Observer / Other Sources	1	Common	Monthly Global Historical Climatology Network (GHCN) data from 2011 – 2013. Includes 3 COOP stations, 120 CoCoRaHS stations, and 12 ASOS stations. Also have severe weather events for surrounding counties of NDS study site.	Access Database by Station	Monthly
12	Local Climatological Data (LCD) NOAA	1	Common	Monthly Quality Controlled Local Climatological Data (QCLCD) from 2011 – 2013 for 7 stations around NDS study site	Access Database by Station	Monthly
11	Seat Bet Use Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
10	State motor cycle helmet use laws	1	Policy	Documented laws from 2011 – 2013	Non	Yearly
9	Graduated driver licensing (GDL)laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
8	Alcohol-Impaired and Drugged Drivers laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
7	Automated enforcement laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
6	Cell phone and text messaging laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
5	Speed Limit Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
4	Speed Limit Data	1	Safety	2013 speed limit data from FL DOT	Conflate to network	Single Year
3	Aerial Imagery	1	Common	2009 – 2013 FL DOT aerial imagery by county in 1 foot resolution. 2013 NAIP aerial imagery by county in 1 meter resolution.	None	Single Year
2	Traffic Information – AADT	1	Safety	2011 – 2013 Shapefile from FL DOT	Conflate to network	Yearly
1	Crash Data	1	Common	2006 – 2013 Shapefile from FL DOT	Conflate to network	Yearly

Summary for Indiana

No.	Item	Priority	Category	Data Description	Integration	Data Frequency
20	Roadway Capacity Improvements	2	Common	TBD	TBD	Yearly
19	Change in existing infrastructure condition	2	Safety	TBD	TBD	Yearly
18	Traffic Data – Short Duration Counts	2	Safety	2011 – 2013 short duration count data from IN DOT	Conflate to network	Yearly
17	Traffic Data – Continuous Counts (ATR)	2	Safety	2011 – 2013 ATR data from IN DOT	Conflate to network	Yearly
16	511 Information	2	Common	2011 – 2013 511 data from CARS Program	TBD	Yearly
15	Work Zone	2	Common	2011 – 2013 511 data from CARS Program including work zone impact	TBD	Yearly
14	Winter Road Conditions (DOT)	2	Common	2011 – 2013 511 data from CARS Program	TBD	NA
13	Cooperative Weather Observer / Other Sources	1	Common	Monthly Global Historical Climatology Network (GHCN) data from 2011 – 2013. Includes 16 COOP stations, 81 CoCoRaHS stations, and 3 ASOS stations. Also have severe weather events for surrounding counties of NDS study site.	Access Database by Station	Monthly
12	Local Climatological Data (LCD) NOAA	1	Common	Monthly Quality Controlled Local Climatological Data (QCLCD) from 2011 – 2013 for 5 stations around NDS study site	Access Database by Station	Monthly
11	Seat Bet Use Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
10	State motor cycle helmet use laws	1	Policy	Documented laws from 2011 – 2013	Non	Yearly
9	Graduated driver licensing (GDL)laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
8	Alcohol-Impaired and Drugged Drivers laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
7	Automated enforcement laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
6	Cell phone and text messaging laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
5	Speed Limit Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
4	Speed Limit Data	1	Safety	2011 speed limit data from FL DOT	Conflate to network	Single Year
3	Aerial Imagery	1	Common	2012 Indiana University GIS aerial imagery by county in 1 meter resolution	None	Single Year
2	Traffic Information – AADT	1	Safety	2011 – 2013 Shapefile from FL DOT	Conflate to network	Yearly
1	Crash Data	1	Common	2006 – 2013 data delivered as a .DAT file from IN DOT	Extract data, convert to GIS, conflate to network	Yearly

Summary for New York

No.	Item	Priority	Category	Data Description	Integration	Data Frequency
1	Crash Data	1	Common	2006 – 2013 data delivered in access from NY DOT	Convert to GIS using Lat/Long, conflate to network	Yearly
2	Traffic Information – AADT	1	Safety	2011 – 2013 data in Excel from NY DOT	Joined to GIS, conflate to network	Yearly
3	Aerial Imagery	1	Common	2011 NAIP aerial imagery by county in 1 meter resolution	None	Single Year
4	Speed Limit Data	1	Safety	2011 speed limit data from FL DOT	Conflate to network	Single Year
5	Speed Limit Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
6	Cell phone and text messaging laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
7	Automated enforcement laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
8	Alcohol-Impaired and Drugged Drivers laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
9	Graduated driver licensing (GDL)laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
10	State motor cycle helmet use laws	1	Policy	Documented laws from 2011 – 2013	Non	Yearly
11	Seat Bet Use Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
12	Local Climatological Data (LCD) NOAA	1	Common	Monthly Quality Controlled Local Climatological Data (QCLCD) from 2011 – 2013 for 3 stations around NDS study site	Access Database by Station	Monthly
13	Cooperative Weather Observer / Other Sources	1	Common	Monthly Global Historical Climatology Network (GHCN) data from 2011 – 2013. Includes 14 COOP stations, 68 CoCoRaHS stations, and 14 ASOS stations. Also have severe weather events for surrounding counties of NDS study site.	Access Database by Station	Monthly
14	Winter Road Conditions (DOT)	2	Common	2011 – 2013 511 data including weather events from NYDOT and NITTEC	Convert to GIS using Lat/Long, conflate to network	NA
15	Work Zone	2	Common	2011 – 2013 data including work zones impacting roadway from NYDOT and NITTEC	Convert to GIS using Lat/Long, conflate to network	Yearly
16	511 Information	2	Common	2011 – 2013 511 data from NY DOT and NITTEC	Convert to GIS using Lat/Long, conflate to network	Yearly
17	Traffic Data – Continuous Counts (ATR)	2	Safety	2011 – 2013 ATR data from NY DOT	Join data to shapefile, conflate to network	Yearly
18	Traffic Data – Short Duration Counts	2	Safety	2011 – 2013 short duration count data from NY DOT	Join data to shapefile, conflate to network	Yearly
19	Change in existing infrastructure condition	2	Safety	Changes to Roadway Data	Conflate to network	Yearly
20	Roadway Capacity Improvements	2	Common	Roadway Improvement Data	Conflate to network	Yearly

Summary for North Carolina

No.	Item	Priority	Category	Data Description	Integration	Data Frequency
20	Roadway Capacity Improvements	2	Common	TBD	TBD	Yearly
19	Change in existing infrastructure condition	2	Safety	TBD	TBD	Yearly
18	Traffic Data – Short Duration Counts	2	Safety	2011 – 2013 short duration count data from NC DOT	Conflate to network	Yearly
17	Traffic Data – Continuous Counts (ATR)	2	Safety	2011 – 2013 ATR data from NC DOT	Convert to GIS, conflate to network	Yearly
16	511 Information	2	Common	2011 – 2013 Traffic Incident Management System data from NC DOT in shapefile	Conflate to network	Yearly
15	Work Zone	2	Common	2011 – 2013 Traffic Incident Management System data from NC DOT in shapefile with work zone impacts	Conflate to network	Yearly
14	Winter Road Conditions (DOT)	2	Common	2011 – 2013 Traffic Incident Management System data from NC DOT in shapefile with weather events	Conflate to network	NA
13	Cooperative Weather Observer / Other Sources	1	Common	Monthly Global Historical Climatology Network (GHCN) data from 2011 – 2013. Includes 18 COOP stations, 129 CoCoRaHS stations, and 2 ASOS stations. Also have severe weather events for surrounding counties of NDS study site.	Access Database by Station	Monthly
12	Local Climatological Data (LCD) NOAA	1	Common	Monthly Quality Controlled Local Climatological Data (QCLCD) from 2011 – 2013 for 6 stations around NDS study site	Access Database by Station	Monthly
11	Seat Bet Use Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
10	State motor cycle helmet use laws	1	Policy	Documented laws from 2011 – 2013	Non	Yearly
9	Graduated driver licensing (GDL)laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
8	Alcohol-Impaired and Drugged Drivers laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
7	Automated enforcement laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
6	Cell phone and text messaging laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
5	Speed Limit Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
4	Speed Limit Data	1	Safety	2011 speed limit data from FL DOT	Conflate to network	Single Year
3	Aerial Imagery	1	Common	2012 NAIP aerial imagery by county in 1 meter resolution	None	Single Year
2	Traffic Information – AADT	1	Safety	2011 – 2013 Shapefile from NC DOT	Conflate to network	Yearly
1	Crash Data	1	Common	2006 – 2013 data delivered as Excel from HSIS	Convert to GIS using LRS, conflate to network	Yearly

Summary for Pennsylvania

No.	Item	Priority	Category	Data Description	Integration	Data Frequency
20	Roadway Capacity Improvements	2	Common	2011 – 2013 projects in shapefile from PA DOT	Conflate to network	Yearly
19	Change in existing infrastructure condition	2	Safety	2011 – 2013 projects in shapefile from PA DOT	Conflate to network	Yearly
18	Traffic Data – Short Duration Counts	2	Safety	2011 – 2013 short duration count data from PA DOT	Conflate to network	Yearly
17	Traffic Data – Continuous Counts (ATR)	2	Safety	2011 – 2013 ATR data from PA DOT	Reduce data, convert to GIS, conflate to network	Yearly
16	511 Information	2	Common	2011 – 2013 511 data from PA DOT	Convert to GIS using Lat/Long, conflate to network	Yearly
15	Work Zone	2	Common	2011 – 2013 511 data including work zones from PA DOT	Convert to GIS using Lat/Long, conflate to network	Yearly
14	Winter Road Conditions (DOT)	2	Common	2011 – 2013 511 data including weather events from PA DOT	Convert to GIS using Lat/Long, conflate to network	NA
13	Cooperative Weather Observer / Other Sources	1	Common	Monthly Global Historical Climatology Network (GHCN) data from 2011 – 2013. Includes 8 COOP stations, 10 CoCoRaHS stations, and 0 ASOS stations. Also have severe weather events for surrounding counties of NDS study site.	Access Database by Station	Monthly
12	Local Climatological Data (LCD) NOAA	1	Common	Monthly Quality Controlled Local Climatological Data (QCLCD) from 2011 – 2013 for 1 station around NDS study site	Access Database by Station	Monthly
11	Seat Bet Use Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
10	State motor cycle helmet use laws	1	Policy	Documented laws from 2011 – 2013	Non	Yearly
9	Graduated driver licensing (GDL)laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
8	Alcohol-Impaired and Drugged Drivers laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
7	Automated enforcement laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
6	Cell phone and text messaging laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
5	Speed Limit Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
4	Speed Limit Data	1	Safety	2013 speed limit data from FL DOT	Conflate to network	Single Year
3	Aerial Imagery	1	Common	2013 NAIP aerial imagery by county in 1 meter resolution	None	Single Year
2	Traffic Information – AADT	1	Safety	2011 – 2013 Shapefile from PA DOT	Conflate to network	Yearly
1	Crash Data	1	Common	2006 – 2013 data delivered in access from PA DOT	Convert to GIS using Lat/Long, conflate to network	Yearly

Summary for Washington

No.	Item	Priority	Category	Data Description	Integration	Data Frequency
20	Roadway Capacity Improvements	2	Common	2011 – 2013 projects completed from WA DOT	Convert to GIS using Lat/Long, conflate to network	Yearly
19	Change in existing infrastructure condition	2	Safety	2011 – 2013 projects completed from WA DOT	Convert to GIS using Lat/Long, conflate to network	Yearly
18	Traffic Data – Short Duration Counts	2	Safety	2011 – 2013 short duration count data in shapefile from WA DOT	Conflate to network	Yearly
17	Traffic Data – Continuous Counts (ATR)	2	Safety	2011 – 2013 ATR data in shapefile from WA DOT	Conflate to network	Yearly
16	511 Information	2	Common	2011 – 2013 data from WA DOT	Data feed to GIS, conflate to network	Yearly
15	Work Zone	2	Common	2011 – 2013 511 data including work zones from WA DOT	Data feed to GIS, conflate to network	Yearly
14	Winter Road Conditions (DOT)	2	Common	2011 – 2013 511 data including weather events from WA DOT	Data feed to GIS, conflate to network	NA
13	Cooperative Weather Observer / Other Sources	1	Common	Monthly Global Historical Climatology Network (GHCN) data from 2011 – 2013. Includes 22 COOP stations, 123 CoCoRaHS stations, and 5 ASOS stations. Also have severe weather events for surrounding counties of NDS study site.	Access Database by Station	Monthly
12	Local Climatological Data (LCD) NOAA	1	Common	Monthly Quality Controlled Local Climatological Data (QCLCD) from 2011 – 2013 for 7 stations around NDS study site	Access Database by Station	Monthly
11	Seat Bet Use Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
10	State motor cycle helmet use laws	1	Policy	Documented laws from 2011 – 2013	Non	Yearly
9	Graduated driver licensing (GDL)laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
8	Alcohol-Impaired and Drugged Drivers laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
7	Automated enforcement laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
6	Cell phone and text messaging laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
5	Speed Limit Laws	1	Policy	Documented laws from 2011 – 2013	None	Yearly
4	Speed Limit Data	1	Safety	2011 speed limit data from WA DOT	Conflate to network	Single Year
3	Aerial Imagery	1	Common	2011 NAIP aerial imagery by county in 1 meter resolution	None	Single Year
2	Traffic Information – AADT	1	Safety	2011 – 2013 Shapefile from WA DOT	Conflate to network	Yearly
1	Crash Data	1	Common	2006 – 2013 data in Excel from WA DOT	Convert to GIS using LRS, conflate to network	Yearly

Mobile Data S04B

Mobile Data Dictionary

The mobile data collection contractor, Fugro Roadware, was required to collect the following roadway attributes:

Horizontal curvature:
- Radius
- Length
- PC
- PT
- Direction of curve (left or right based on driving direction)
Grade
Cross-slope/Superelevation
Lanes: number, width, and type (thru, turn, passing, acceleration, car pool, etc.)
Shoulder type/curb (and paved width, if it exists)
All MUTCD signs
Guardrails/Barriers
Median presence: type (depressed, raised, flush, barrier)
Intersection: location, number of approaches, and control (uncontrolled, all-way stop, two-way stop, yield, signalized, roundabout). Ramp termini are considered intersections. Median presence: type (depressed, raised, flush, barrier
Rumble strip presence: location (centerline, edgeline, shoulder)
Lighting presence

Mobile Data Accuracy Requirements

Data Element	Minimum Accuracy Requirement (+/-)
Curvature Radius	100 ft. (curves less than 1,500 ft. radius) 250 ft. (curves between 1,500 ft. and 6,000 ft. radius) Difference between radii <13% of radius as defined by S04A team (curves over 6,000 ft. radius)
Curvature Length	100 ft.
PC	50 ft.
PT	50 ft.
Grade (+ or -)	0.5%
Cross-slope / Superelevation	1.0%
Lane Width	1 ft.
Paved Shoulder Width	1 ft.
Inventory Features (Signs) Location	7 ft.

Technology

Fugro is the world’s leading, independent provider of geo-intelligence and asset integrity solutions for large constructions, infrastructure and natural resources. We provide the technical data and information required to design, construct and maintain your structures and infrastructure in a safe, reliable and efficient manner.

Visit the Fugro website

Downloads

SO4B Metadata (XLS Spreadsheet)

Common Elements with State Data (PDF)

Data Collection Plans
Florida Collection Plan (PDF)
Indiana Collection Plan (PDF)
New York Collection Plan (PDF)
North Carolina Collection Plan (PDF)
Pennsylvania Collection Plan (PDF)
Washington Collection Plan (PDF)

CTRE

Center for Transportation Research and Education