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