01590024

Component

https://doi.org/10.3141/2584-02

State departments of transportation across the nation fund selective enforcement campaigns aimed at intensifying law enforcement at certain locations to improve traffic safety. At the same time, many states passively collect large data sets, such as officer GPS location tracks. To evaluate the effectiveness of selective enforcement, an approach was developed to employ structured query language (SQL) and geographic information system (GIS) technology to mine and integrate police patrol patterns, citations issued, crash occurrences, and selective enforcement periods. This information was analyzed in a relational database within a spatial and temporal analysis framework. The intent was to use solely GIS technology; however, the size of the data sets was prohibitive, and SQL was used as a big data analytic. The SQL techniques successfully turned more than 37 million points of GPS data into 1.3 million points of selective enforcement location information, enabled the geolocation of 72.6% of electronic citations, and identified 21 selective enforcement areas across the state of Alabama. With big data analytics, GIS technology was reestablished as useful for the evaluation of changes in crash and citation frequencies before and during selective enforcement. Paired difference t-tests confirmed the decrease of crash frequency with 85% confidence at urban and rural locations. The analysis of the number of citations at the locations confirmed that citations increased during selective enforcement by an average of 254%. The developed methodology is a successful approach using large data sets for an unintended purpose to make valuable engineering conclusions and data-driven discoveries.

01590544

16-2886

English

0000-0002-7073-8751

pp 8–15

2016

Transportation Research Record: Journal of the Transportation Research Board

9780309441162

Print

Figures (3) ; References (18) ; Tables (3)

Crash rates; Data analysis; Data mining; Databases; Evaluation and assessment; Global Positioning System; Police operations; Traffic crashes; Traffic law enforcement

Alabama

Data and Information Technology; Highways; Operations and Traffic Management; Safety and Human Factors

PRP, TRIS, TRB, ATRI

Jan 12 2016 5:18PM

• A Priori Evaluation of Policy Measures Against Alcohol-Impaired Driving: French Case Study
• Aging Population–Focused Accessibility Assessment of Multimodal Facilities in Florida
• Are Perceptions About Driving Risk and Driving Skill Prospectively Associated with Risky Driving Among Teenagers?
• Effects of Alcohol and Fatigue on Driving Performance in Different Roadway Geometries
• Evaluation of Confirmation Lights on Red Light Running Violations by Time-into-Red Phase
• Evaluation of Intersection Confirmation Lights with Targeted Enforcement to Reduce Red Light Running Violations at Freeway Ramp Intersections
• Evaluation of Training Interventions to Mitigate Effects of Fatigue and Sleepiness on Driving Performance
• Finite Element Approach to Identify the Potential of Improved Heavy-Truck Crashworthiness and Occupant Protection in Frontal Impacts
• Impact of Red Light Enforcement Cameras on Safety Performance at Signalized Intersections in Abu Dhabi, United Arab Emirates
• Longitudinal Associations Between Changes in Physical Function and Driving Mobility Behaviors of Older Adults
• Traffic Crash History of Cognitively Impaired Drivers in Missouri