VTechWorks staff will be away for the Thanksgiving holiday beginning at noon on Wednesday, November 27, through Friday, November 29. We will resume normal operations on Monday, December 2. Thank you for your patience.
 

Integrating the Adaptive Lighting Database with SHRP 2 Naturalistic Driving Data

Simple item page
dc.contributor.authorLi, Yingfengen
dc.contributor.authorGibbons, Ronald B.en
dc.contributor.authorFlintsch, Alejandra Medinaen
dc.date.accessioned2015-09-18T23:41:50Zen
dc.date.available2015-09-18T23:41:50Zen
dc.date.issued2015-09-16en
dc.description.abstractThis report details efforts to integrate the Adaptive Lighting Database (ALD) with the Second Strategic Highway Research Program (SHRP 2) Naturalistic Driving Study (NDS) and the Roadway Information Database. The ALD provides detailed in situ lighting performance data and associated safety, traffic, and roadway data for seven states: Washington (WA), North Carolina (NC), California (CA), Delaware (DE), Minnesota (MN), Vermont (VT), and Virginia (VA). The SHRP 2 database provides naturalistic driving data from a large-scale study carried out at six sites around the nation: Bloomington, Indiana; central Pennsylvania; Tampa Bay, Florida; Buffalo, New York; Durham, North Carolina; and Seattle, Washington. The RID, which was developed as part of the SHRP 2 program, provides detailed traffic and roadway information for the SHRP 2 sites. The integration of these datasets would make it possible for researchers to investigate relationships between different lighting characteristics, roadway configurations, and roadway safety. With this objective in mind, the research team developed an in-depth description of the NDS database structure, data elements, and database relationships; documented in detail the data entities, format, and content of the ALD; and developed and demonstrated two Geographic Information System (GIS) approaches for integrating NDS and ALD data. The two GIS approaches target different needs and requirements. The first approach involved data integration directly between the ALD and NDS time series data. By matching both lighting and time series data points onto the same roadway network, simple spatial joins or linear referencing mechanisms could be used to relate individual points from both datasets. The approach involved both existing and custom tools developed on the ArcGIS platform. Data in both databases could then be integrated through spatial and relational joins. The researchers used data for the State of Washington to demonstrate the approach and associated advantages and challenges. Time series data representing approximately 2,800 nighttime NDS trips were matched to the ALD roadway network. The second approach involved data integration of the ALD and NDS data based on the roadway segments in the RID. Within the NDS database, time series data points were matched to a digital map of the roadway network defined by links (uniquely identified by a LINKID), directly isolating time series data on the links of interest and eliminating the need for additional spatial processing. The RID roadway network was then matched with the ALD roadway network and each ALD roadway segment was assigned the LINKID of the corresponding RID roadway segment, allowing relational database joins to be used, which are many orders of magnitude faster than spatial joins. To demonstrate this approach, the research team used a draft version of the RID roadway data and lighting data for the State of North Carolina.en
dc.format.mimetypeapplication/pdfen
dc.identifier.urihttp://hdl.handle.net/10919/56612en
dc.language.isoenen
dc.publisherNational Surface Transportation Safety Center for Excellenceen
dc.relation.ispartofseriesNSTSCE;15-UR-039en
dc.rightsIn Copyright (InC)en
dc.rights.urihttp://rightsstatements.org/vocab/InC/1.0/en
dc.subjectAdaptive Lighting Database (ALD)en
dc.subjectRoadway Information Database (RID)en
dc.subjectSHRP 2en
dc.subjectSecond Strategic Highway Research Program (SHRP 2)en
dc.subjectGeographic Information System (GIS)en
dc.subjectnaturalistic driving studiesen
dc.titleIntegrating the Adaptive Lighting Database with SHRP 2 Naturalistic Driving Dataen
dc.typeReporten
dc.type.dcmitypeTexten

Files

Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
Intgrtng_Adptve_Lghtng_Dtbse_SHRP2.pdf
Size:
14.1 MB
Format:
Adobe Portable Document Format
Description:
Download

Collections

National Surface Transportation Safety Center for Excellence Reports (NSTSCE, VTTI)