300 likes | 307 Views
The Evolution of FMCSA’s Data Quality Program July 2007. Evolution of the Data Quality Program. Yesterday. Today. Tomorrow. COLLECTION DATA DRIVEN DECISIONS DISSEMINATION. EVALUATION IMPROVEMENT DATA CORRECTION. INCREASED DATA USE IMPROVED EVALUATION IMPROVEMENT.
E N D
Evolution of the Data Quality Program Yesterday Today Tomorrow • COLLECTION • DATA DRIVEN DECISIONS • DISSEMINATION • EVALUATION • IMPROVEMENT • DATA CORRECTION • INCREASED DATA USE • IMPROVED EVALUATION • IMPROVEMENT
YESTERDAY (1980s and 1990s) 1. Safety Data Collection Compliance Reviews Crashes Moving Violations Roadside Inspections Carrier Registration Closed Enforcement Cases 2.Data Driven Decisions 3. Dissemination
TODAY Data Quality Program • DQ Evaluation and Monitoring • State Safety Data Quality (SSDQ) • Monthly Progress Report (MPR) • State Crash Data Analysis • DQ Improvement • Analysis and Improvement of State Police Accident Reporting (PAR) / Training • State Reviews • Technical Assistance • Funding • Data Correction • DataQs Online Tool • MCMIS/FARS Matching Tool
Jack was hired as a State Safety Program Manager. One of his performance objectives is to improve data quality.
How can Jack evaluate how his state is doing in terms of Data Quality?
State Safety Data Quality Monthly Progress Report State Crash Data Analysis
What is available to help Jack improve his state’s data quality?
Training State Reviews
Technical Assistance Grants
What can Jack do to correct his state’s safety data quality problems?
DataQs website FARS/MCMIS Matching Tool
Jack wants to know if the Data Quality Program has been helpful to states?
38 States achieved a Good Overall State Rating (June 2007) • 24,000+ data challenges filed (67% resulting in updates) • 7 State Reviews were conducted since 2005
Jack wants to know how tomorrow’s FMCSA data quality program will be enhanced?
TOMORROWImprovements • DQ Evaluation and Monitoring • Enhance State Safety Data Quality Evaluation • Continue State Crash Data Analysis • DQ Improvement • Conduct more State Reviews • Expand Technical Assistance • Continue PAR Analysis and Training
State Safety Data Quality Evaluation New SSDQ Crash Measures • Crash Record Completeness • Driver Identification • Vehicle Identification • Non-fatal Crash Completeness
New SSDQ Crash Measures Crash Record Completeness • Evaluates the completeness of driver and vehicle identification data on reported crash records Driver Identification • Driver License # • Driver Date-of-Birth • Driver First Name • Driver Last Name • License Class Vehicle Identification • VIN • License plate # • Vehicle configuration • Cargo body type • Gross Vehicle Weight Rating
New SSDQ Crash Measures Crash Record Completeness Measure Rating Criteria
New SSDQ Crash Measures Non-Fatal Crash Completeness Measure # Reported Non-Fatals # Predicted Non-Fatals % Non-Fatal Crash Completeness = Rating Criteria
Impact of New Measures Example: State of Mississippi June 2007 - New Methodology June 2007 June 2006 • 1 Good measure • 4 Poor measures • Red Flagged • 4 Good measures • 1 Fair measure • 4 Good measures • 2 Fair measures • 1 Poor measure
Implementation Incremental Approach • Post New Measure Analyses on A&I Online website • Integrate new measures into SSDQ methodology first quarter 2008 • Re-evaluate rating criteria of the new measures and new measure weights relative to the overall map rating during 2008
FARS/MCMIS Fatal Crash Record Matching Tool A tool designed to help reconcile differences between the number of fatal crash records in the FARS and MCMIS databases. • "match" fatal large truck and bus crash records • records must contain the same information in several key fields (e.g., county, date, time, VIN, DOT #, etc.).
FARS/MCMIS Fatal Crash Record Matching Tool Individual Results • Step by Step approach to review results • Determine if crash records were categorized incorrectly in MCMIS • Identify missing or incomplete data fields • Take action to upload new information or records to MCMIS
No need to worry, Jack! The FMCSA Data Quality Program will help.
Analysis and Information (A&I) Online website: http://ai.fmcsa.dot.gov Data Quality Module Betsy Benkowski 202-366-5387 Dana Larkin 617-494-2821 Candy Brown 617-494-3856