Slide 1: FMCSA Tools To Improve State Data Quality Presented by: Shaun Dagle Slide 2: Agenda FMCSA Systems Systems Overview SAFETYNET Data Quality Tools MCMIS Data Quality Tools A&I Online Data Quality Tools DataQs Slide 3: FMCSA Systems SAFETYNET - Used by State and Federal offices to collect, manage, and transfer roadside inspection and crash data to the FMCSA Motor Carrier Management Information System (MCMIS) - FMCSA repository for motor carrier registration, roadside inspection, crash compliance review, and other motor carrier enforcement information Analysis and Information (A&I) Online - Web based tool designed to provide access to descriptive statistics and analyses regarding commercial vehicle, driver, and carrier safety information DataQs - Electronic means for filing concerns about Federal and State data released by the FMCSA Slide 4: Systems Overview Data Collection Roadside Inspection and Crash Data Slide 5: SAFETYNET Data Quality Tools SAFETYNET Match Process Matches crash and inspection records to motor carriers - Batch mode: runs against groups of crash or inspection records at a single time - Interactive mode: runs against the currently viewed crash or inspection record Slide 6: SAFETYNET Data Quality Tools SAFETYNET Match Process: Batch mode Slide 7: SAFETYNET Data Quality Tools SAFETYNET Match Process: Interactive mode Carrier search on current inspection record Slide 8: SAFETYNET Data Quality Tools SAFETYNET Reports Data Entry Report - Data Entry Verification Report - Data Entry Status Report - Data Entry Workload Report - Duplicate Inspection Numbers Upload Status Reports - Upload Summary Report - Upload Timeline Report MCMIS Upload Edit Result Messages (crash only) Slide 9: SAFETYNET Data Quality Tools Data Entry Reports Slide 10: SAFETYNET Data Quality Tools Upload Status Reports Slide 11: SAFETYNET Data Quality Tools SAFETYNET Query Tool Record (menu) Query - Uses SAFETYNET's built in Query by Example builder - Used for selecting distinct groups of records - Queries can be built using multiple fields and multiple conditions. Example: Display all crashes that occurred between 01/01/2006 and 07/31/2006 with fatalities. - Reports can be generated based on query results Slide 12: SAFETYNET Data Quality Tools SAFETYNET Query Tool: Example: Display all crashes that occurred between 01/01/2006 and 07/31/2006 with fatalities Slide 13: SAFETYNET Data Quality Tools SAFETYNET Activity Logs System (menu) Activity Logs - Provides a summary of records imported, prepared, and confirmation file processing 1) Identifies fatal errors and warnings 2) Identifies specific records with issues - Includes summary report at the end of the activity Slide 14: MCMIS Data Quality Tools MCMIS Reports: Management Reports (Montly basis) - Summary of Non-Matched Inspections - Timeliness of Inspection Uploads - Summary of Non-Matched Crashes - Timeliness of Crash Uploads Real Time Reports (Requested by user) - Timeliness of Inspection Uploads by Safety Inspector - Non-match Crash & Inspection Records - Duplicate Crash and Inspection Records Slide 15: MCMIS Data Quality Tools Management Reports Slide 16: MCMIS Reports Slide 17: A&I Online Data Quality Tools http://ai.fmcsa.dot.gov A&I Main Menu Screen Click on Data Quality on the main menu (Graphic of A&I Main Menu - highlighting the Data Quality button) Slide 18: A&I Data Quality Tools A&I Online - Data Quality Module Show the Evaluation, Monitoring, and Improvement sections Slide 19: A&I Data Quality Tools A&I Online - Data Quality Module Evaluation - State Safety Data Quality (SSDQ) - Data and Reports Monitoring - Monthly Progress Report (MPR) Improvement - DataQs (link) - Guidance on Police Accident Reporting - Training and Outreach (Presentations) Slide 20: Data Quality Module Evaluation State Safety Data Quality (SSDQ) - Evaluation of the completeness, timeliness, accuracy, and consistency of State reported data to MCMIS - Results are updated quarterly - Available to the General Public Data and Reports - Access to data and reports that can be used to analyze data quality issues and to monitor trends in reporting 1) Link to University of Michigan Transportation Research Institute (UMTRI) Reports on Truck and Bus data quality 2) Quarterly snapshot of MCMIS and FARS data available for download in EXCEL format (password protected). Slide 21: A&I Data Quality Module Evaluation Show colored state map Show Summary Report: State Rating of Crash and Inspection Reporting Slide 22: A&I Data Quality Module Monitoring Monthly Progress Report (MPR) - Monthly SSDQ evaluation results to Federal and State enforcement agencies - Historical SSDQ evaluation results (for the previous 12 months) to enable users to track their data quality improvements - Supplemental Reports with additional information on the quality of State-reported data in MCMIS and DataQs summary statistics Slide 23: A&I Data Quality Module Monitoring Show Overall State Rating graph and colored rating report Slide 24: A&I Data Quality Module Improvement Police Accident Reporting (PAR) - Web based educational resource for law enforcement officers, CMV inspection authorities, accident investigation trainers, and State Department of Transportation accident record developers and users. - Five lessons that define and provide examples of FMCSA related crash data collected and reported to SAFETYNET. Slide 25: A&I Data Quality Module Improvement Show graphic of PAR Main Page Slide 26: What is DataQs? http://dataqs.fmcsa.dot.gov - Electronic means for filing concerns about Federal and State data released by the FMCSA - Allows motor carriers to submit data quality challenges related to motor carrier safety data - Routes the challenges to the appropriate organization for resolution based on the type of challenge Slide 27: DataQs Features - DataQs On-line reports provide summaries of data challenges received by MCSAP Agencies Show graphic of the Crash Challenge Type Breakdown pie chart Slide 28: Contact Information Shaun Dagle 617-494-3034 http://ai.fmcsa.dot.gov