Explanation

Here is the new data model from the state (Excel download):

dr3447-data-model

Here is the new .xsd schema the state requires (zip/text download):

Incoming-DR3447-schema

Here’s our new table definitions for Crash Magic:

CreateTableScript

Here’s the differences between our fields and the fields listed in CDOTs Data Model Spreadsheet (xlsx download):

CM_diffs_from_Dr3447_Data_Model