1 / 15

Linking State Data Files: Challenges and Successes

This presentation discusses the challenges and successes of linking state data files, specifically in terms of traffic records. The goal is to make high-quality exposure data accessible to DOT, state agencies, and the public, and to develop a standardized state data repository accessible on the web. The presentation covers the development of standardized data structures, data transformation challenges, and the process of linking state files. Conclusions highlight the importance of a standardized repository for exposure data at the county and city level.

markcarter
Download Presentation

Linking State Data Files: Challenges and Successes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Linking State Data Files:Challenges and Successes Demetra Collia, M.S., M.H.S. 30th International Traffic Record Forum Nashville, Tennessee U.S. Department of Transportation Bureau of Transportation Statistics

  2. Purpose • Make high quality exposure data available to the U.S. DOT, state agencies, and the public • Evaluate the feasibility and desirability of developing a standardized state data repository accessible on the web

  3. Goal • Transform files into a common format • Facilitate analysis at the state level, and comparisons across states • Make state data accessible to all with minimum effort

  4. Key Factors • Technology is available • Process is manageable (administratively, financially) • Stakeholder/state interest to participate

  5. Scope 1. Develop standardized files of traffic records: Crash Vehicle registration Driver licensing/history • Combine data across states • Add other state data

  6. Pilot States • Alabama, Alaska, Arizona, Connecticut, Iowa, Kentucky, Louisiana, Ohio, Wisconsin, West Virginia

  7. Phase I: Develop Data Structures • Crash files (person, vehicle, event) • Vehicle registration • Driver – licensing, history

  8. Phase II: Data Transformation Easier for some data fields than others. Gender, Age Race, fuel type

  9. Phase II: Challenges Data not collected Data collected at a more aggregate level than the standardized structure requires Lack of internal QC data checks

  10. Phase III: Linking State Files Deterministic Linking vs. Probabilistic Linking

  11. Matching Data Fields SSN Name Date of Birth Driver License Number Address License Plate Number VIN

  12. Linking Files: Results Crash - Driver licensing/history files driver license number: 93.6% additional fields: 98% For current year data: driver license number is a better matching field than SSN

  13. Linking Files: Results Crash - Vehicle registration files plate number: 62.3% For current year data: plate number is a better matching field than owner SSN

  14. Conclusions Linking state files can be done. Linking crash data to vehicle registration data still a challenge A standardized repository of vehicle registration files is a useful source of exposure data at the county and city level.

  15. Questions ? Demetra Collia Bureau of Transportation Statistics 202-366-1610 demetra.collia@bts.gov 21

More Related