Table Name | Field Name | Begin Column | Definition | Valid Values | Descriptions
carldotqual.dbf | ASIS_NUMBR |  | Text, 10, 0 | E.g., 09014 | Unique identifier used by MN/DOT to identify a pit - new numbering scheme. This is the primary key used to join this data to carlpits.shp or carlasis0108.shp
| SOURCEXX |  | Text, 10, 0 | E.g., 09014 | Unique identifier used by MN/DOT to identify a pit - new numbering scheme.
| PITNO |  | Text, 10,0 | E.g., 587 | Unique identifier used by MN/DOT to identify a pit - without letter (A or B).
| PITNOLTR |  | Text, 3 | E.g., A, B, NA (none listed) | Unique identifier used by MN/DOT to identify a pit - if more than one pit (A, B, or C).
| SHALE_SAND |  | Number,19,1 | E.g., 0.9, 3.6 | Average amount of shale found in the sand fraction (percent). Null values are displayed as -999
| SHALE_GRVL |  | Number,19,1 | E.g., 1.4, 3.9 | Average amount of shale found in the gravel fraction (percent). Null values are displayed as -999
| FEOXIDEPCT |  | Number,19,1 | e.g., 1.4, 2.3 | Average amount of iron oxide found in sample (percent).
| UNCHERTPCT |  | Number,19,1 | e.g., 0.2, 0.6 | Average amount of unsound chert found in sample (percent). Null values are displayed as -999
| LAR_A |  | Number,19,1 | e.g., 7.7, 28.5 | Average amount of material lost in the Los Angeles Rattler test (percent). Null values are displayed as -999
| LAR_B |  | Number,19,1 | e.g., 24.2, 28.3 | Average amount of material lost in the Los Angeles Rattler test (percent). Null values are displayed as -999
| LAR_C |  | Number,19,1 | e.g., 23.5, 26.0 | Average amount of material lost in the Los Angeles Rattler test (percent). Null values are displayed as -999
| HIGHSHSAND |  | Number,19,1 | e.g., 3.3, 8.6 | Highest amount of shale found in the sand fraction (percent). Null values are displayed as -999
| LOWSHSAND |  | Number,19,1 | e.g., 1.1, 4.4 | Lowest amount of shale found in the sand fraction (percent). Null values are displayed as -999
| RANGESHSND |  | Text, 10 | e.g., 1.1-3.3, 2.7-8.8, No Range, NA | Range of shale found in the sand fraction (percent). ‘No Range’ indicates that the high and low values were the same. NA indicates there were null values in the high and low.
| HIGH_SHGVL |  | Number,19,1 | e.g., 2.4, 6.8 | Highest amount of shale found in the gravel fraction (percent). Null values are displayed as -999
| LOW_SH_GVL |  | Number,19,1 | e.g., 1.3, 6.3 | Lowest amount of shale found in the gravel fraction (percent).
| RANGESHGVL |  | Text, 10 | e.g., 1.0-2.6, 2.8-6.3, No Range, NA | Range of shale found in the gravel fraction (percent). ‘No Range’ indicates that the high and low values were the same. NA indicates there were null values in the high and low.
| HIGHFEOXID |  | Number,19,1 | e.g., 1.1-3.2 | Highest amount of iron oxide found in sample (percent). Null values are displayed as -999
| LOWFEOXIDE |  | Number,19,1 | e.g., 0.2, 1.4 | Lowest amount of iron oxide found in sample (percent). Null values are displayed as -999
| RANGE_FEOX |  | Text, 10 | e.g., 0.5-1.1, 1.3-2.3, No Range, NA | Range of iron oxide found in sample (percent). ‘No Range’ indicates that the high and low values were the same. NA indicates there were null values in the high and low.
| HIGHUNCHRT |  | Number,19,1 | e.g., 0.0, 0.4 | Highest amount of unsound chert found in sample (percent). Null values are displayed as -999
| LOWUNCHERT |  | Number,19,1 | e.g., 0.0, 0.6 | Lowest amount of unsound chert found in sample (percent). Null values are displayed as -999
| RANGE_UNCH |  | Text, 10 | e.g., 0.1-0.2, 0.4-0.4, No Range, NA | Range of unsound chert found in sample (percent). ‘No Range’ indicates that the high and low values were the same. NA indicates there were null values in the high and low.
| HIGH_LAR |  | Number,19,1 | e.g., 25.3, 30.6 | Highest amount of material lost in the Los Angeles Rattler test (percent). Null values are displayed as -999
| LOW_LAR |  | Number,19,1 | e.g., 7.0, 26.6 | Lowest amount of material lost in the Los Angeles Rattler test (percent). Null values are displayed as -999
| RANGE_LAR |  | Text,12 | e.g., 19.9-25.3, 7.7-26.0, No Range, NA | Range of material lost in the Los Angeles Rattler test (percent). ‘No Range’ indicates that the high and low values were the same. NA indicates there were null values in the high and low.