Colorado Form Changes – technical info

Table of Contents
Issue

This page gives information regarding the new DR3447 data for the technical user.

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

Solution
Was this article helpful?
4.5 out Of 5 Stars
5 Stars 0%
4 Stars 100%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?