Colorado Form Changes – technical info

Table of Contents

Colorado Form Changes – technical info

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

2 ratings

5 Stars 0%
4 Stars 100%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
How Can We Improve This Article?