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. |