Table Name |
Field Name |
Begin Column |
Definition |
Valid Values |
Descriptions |
Renvqual.dbf |
Mndot_old |
|
Text, 18 |
E.g., 104A |
Unique identifier used by MN/DOT to identify
a pit - old numbering scheme. |
|
Sourcexx |
|
Number,9,0 |
E.g., 65010 |
Unique identifier used by MN/DOT to identify
a pit - new numbering scheme. |
|
Pitno |
|
Number,9,0 |
E.g., 104 |
Unique identifier used by MN/DOT to identify
a pit - without letter (A or B) |
|
Pitnoltr |
|
Text,12 |
E.g., A |
Unique identifier used by MN/DOT to identify
a pit - if more than one pit (A, B, or C). |
|
Shale_sand |
|
Number,11,1 |
E.g., 0.9, 3.6 |
Average amount of shale found in the sand
fraction (percent). |
|
Shale_grvl |
|
Number,9,1 |
E.g., 1.4, 3.9 |
Average amount of shale found in the gravel
fraction (percent). |
|
Feoxidepct |
|
Number,13,1 |
e.g., 1.4, 2.3 |
Average amount of iron oxide found in sample
(percent). |
|
Unchertpct |
|
Number,13,1 |
e.g., 0.2, 0.6 |
Average amount of unsound chert found in
sample (percent). |
|
Lar_a |
|
Text,12 |
e.g., 7.7, 28.5 |
Average amount of material lost in the Los
Angeles Rattler test (percent). |
|
Lar_b |
|
Text,12 |
e.g., 24.2, 28.3 |
Average amount of material lost in the Los
Angeles Rattler test (percent). |
|
Lar_c |
|
Text,11 |
e.g., 23.5, 26.0 |
Average amount of material lost in the Los
Angeles Rattler test (percent). |
|
Highshsand |
|
Text,11 |
e.g., 3.3, 8.6 |
Highest amount of shale found in the sand
fraction (percent). |
|
Lowshsand |
|
Text,13 |
e.g., 1.1, 4.4 |
Lowest amount of shale found in the sand
fraction (percent). |
|
Rangeshsnd |
|
Text, 16 |
e.g., 1.1-3.3, 2.7-8.8 |
Range of shale found in the sand fraction
(percent). |
|
High_shgvl |
|
Text,12 |
e.g., 2.4, 6.8 |
Highest amount of shale found in the gravel
fraction (percent). |
|
Low_sh_gvl |
|
Text,9 |
e.g., 1.3, 6.3 |
Lowest amount of shale found in the gravel
fraction (percent). |
|
Rangeshgvl |
|
Text, 11 |
e.g., 1.0-2.6, 2.8-6.3 |
Range of shale found in the gravel fraction
(percent). |
|
Highfeoxid |
|
Text,12 |
e.g., 1.1-3.2 |
Highest amount of iron oxide found in sample
(percent). |
|
Lowfeoxide |
|
Text,12 |
e.g., 0.2, 1.4 |
Lowest amount of iron oxide found in sample
(percent). |
|
Range_feox |
|
Text, 14 |
e.g., 0.5-1.1, 1.3-2.3 |
Range of iron oxide found in sample (percent). |
|
Highunchrt |
|
Text,13 |
e.g., 0.0, 0.4 |
Highest amount of unsound chert found in
sample (percent). |
|
Lowunchert |
|
Text,13 |
e.g., 0.0, 0.6 |
Lowest amount of unsound chert found in
sample (percent). |
|
Range_unch |
|
Text, 12 |
e.g., 0.1-0.2, 0.4-0.4 |
Range of unsound chert found in sample
(percent). |
|
High_lar |
|
Text,9 |
e.g., 25.3, 30.6 |
Highest amount of material lost in the Los
Angeles Rattler test (percent). |
|
Low_lar |
|
Text,9 |
e.g., 7.0, 26.6 |
Lowest amount of material lost in the Los
Angeles Rattler test (percent). |
|
Range_lar |
|
Text,9 |
e.g., 19.9-25.3, 7.7-26.0 |
Range of material lost in the Los Angeles
Rattler test (percent). |