Roadway Epochs: Documentation and User Manual

This report describes the contents of the Roadway Epochs Database, which is a collection of tables providing indices for users to access vehicle data from the 100-Car and Second Strategic Highway Research Program (SHRP 2) Naturalistic Driving Studies based on the characteristics of the roadways traveled by study vehicles. This document is designed to give an overview of the organization of the tables as well as a brief introduction to the available vehicle and infrastructure data. The document opens with a section outlining intended uses and general information regarding the Roadway Epochs Database. The database contains 35 tables containing data from five state Departments of Transportation (DOTs), Nokia/Navteq, the SHRP 2 Roadway Information Database (RID), and the Federal Highway Administration (FHWA) Office of Highway Performance Monitoring. Epochs of naturalistic data are tied to information such as the number of lanes, average annual daily traffic counts for heavy trucks and light vehicles, International Roughness Index scores, vehicle miles traveled, functional class, and identified features such as transition zones, frontage roads, bridges, and tunnels. The document closes with a few sample queries and a brief introduction to Structured Query Language (SQL).