CO dr3447 value discrepancy – Alley Related

Table of Contents
Issue

As of May 2021, CDOR is now requiring all CO agencies to submit their crash data using the new dr3447 report format. Pd’ Programming has identified a discrepancy in the new Road Description field codes. This article addresses that discrepancy.

Explanation

In the older dr2447 report, the “Road Description” field contains a value for “Alley Related” represented with a value of “5”.  The dr3447 adds a new value to that field called “Crossover-Related”.  In the CDOR “Data Model” spreadsheet, this new value is represented with the value “11”.  This value keeps with the STRAC stated commitment to not re-use or change old values when adding new ones.  Pd’ Programming believes this to be the “correct” and intended values for those fields.

STRAC dr3447 web site: www.codot.gov/about/committees/strac/dr3447

However, in the final published documentation for the dr3447, the two values were swapped.  On the printed crash report forms and the online report form images, “Alley Related” is represented by an “11”.  “Crossover-Related” is represented as a “5”.  The final “Data Model” documents do not reflect the same values. They still have the original, and we believe, correct values.

Here is the Data Model for Road Description provided by the DOR:

Here is the section for Road Description on the dr3447 officer report form:

Solution

Until the DOR provides guidance on how to address this issue, each agency / crash report vendor / data provider will have to document whether they are representing Alley related as a 5 or as an 11.  Pd’ Programming will use the value 5.  When necessary, we will convert data during import if the opposite values are used.

 

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