U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000


Skip to content
Facebook iconYouTube iconTwitter iconFlickr iconLinkedInInstagram

Federal Highway Administration Research and Technology
Coordinating, Developing, and Delivering Highway Transportation Innovations

 
REPORT
This report is an archived publication and may contain dated technical, contact, and link information
Back to Publication List        
Publication Number:  FHWA-HRT-13-088    Date:  May 2014
Publication Number: FHWA-HRT-13-088
Date: May 2014

 

Photographic Data Extraction Feasibility and Pilot Study in Support of Roadside Safety and Roadway Departure Research

 

APPENDIX B: DATA EXTRACTION SPREADSHEET

This appendix presents the spreadsheet that was used to extract the data. The spreadsheet is shown in figure 59 and figure 60. The figures allow researchers to determine which variables had a limited set of attributes and which ones were not restricted to a set of attributes.

As observed in the figures, each color represents the part of the roadway that is being described. In figure 59, the seven center orange columns concern the shoulder, and the six columns in white (shown in bottom columns) correspond to the roadway. In figure 60, the 12 columns in purple (seven columns in top columns, five columns in center graphic) correspond to the barrier, the column in teal (figure 59, top column) corresponds to the precipitation, and the remaining columns in white (figure 60, bottom columns) correspond to additional information.

Figure 59. Illustration. Spreadsheet employed for data extraction (first 15 columns).
Figure 59. Illustration. Spreadsheet employed for data extraction (first 15 columns).

 

Figure 60. Illustration. Spreadsheet employed for data extraction (last 18 columns)
Figure 60. Illustration. Spreadsheet employed for data extraction
(last 18 columns)

 

Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000
Turner-Fairbank Highway Research Center | 6300 Georgetown Pike | McLean, VA | 22101