FMCSA Tools To Improve State Data Quality

1
FMCSA Tools To Improve State Data
Quality Presented By Shaun Dagle
2
Agenda

• FMCSA systems
• Systems Overview
• SAFETYNET Data Quality Tools
• MCMIS Data Quality Tools
• AI Online Data Quality Tools
• DataQs

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 (AI) 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

4
Systems Overview
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

6
SAFETYNET Data Quality Tools
SAFETYNET Match Process Batch mode

Potential matches
7
SAFETYNET Data Quality Tools
SAFETYNET Match Process Interactive mode
Carrier search on current inspection record
8
SAFETYNET Data Quality Tools

• SAFETYNET Reports
• Data Entry Reports
• 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)

9
SAFETYNET Data Quality Tools
Data Entry Reports
10
SAFETYNET Data Quality Tools
Upload Status Reports
11
SAFETYNET Data Quality Tools

• SAFETYNET Query Tool
• Record (menu) -gt Query
• Uses SAFETYNETs 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

12
SAFETYNET Query Tool
SAFETYNET Data Quality Tools
Example Display all crashes that occurred
between 01/01/2006 and 07/31/2006 with fatalities
13
SAFETYNET Data Quality Tools

• SAFETYNET Activity Logs
• System (menu) -gt Activity Logs
• Provides a summary of records imported, prepared,
  and confirmation file processing
• Identifies fatal errors and warnings
• Identifies specific records with issues
• Includes summary report at the end of the activity

14
MCMIS Data Quality Tools

• MCMIS Reports
• Management Reports (Monthly 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 Inspection records

15
MCMIS Data Quality Tools
Management Reports
16
MCMIS Reports
17
AI Online Data Quality Tools
http//ai.fmcsa.dot.gov
18
AI Data Quality Tools

• AI Online - Data Quality Module

19
AI Data Quality Tools

• AI 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)

20
AI 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
• Link to University of Michigan Transportation
  Research Institute (UMTRI) Reports on Truck and
  Bus data quality
• Quarterly snapshot of MCMIS and FARS data
  available for download in EXCEL format (password
  protected)

21
AI Data Quality Module

• Evaluation

22
AI 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

23
AI Data Quality Module

• Monitoring

24
AI 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.

25
AI Data Quality Module

• Improvement

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

27
DataQs Features

• DataQs On-line reports provide summaries of data
  challenges received by MCSAP Agencies.

28
Contact Information
Shaun Dagle
617-494-3034
http//ai.fmcsa.dot.gov