Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

Lesuqual.dbf

Mndot_old

 

Text, 8

E.g., 4217A

Unique identifier used by MN/DOT to identify a pit - old numbering scheme.

 

Sourcexx

 

Number,5,0

E.g., 52041

Unique identifier used by MN/DOT to identify a pit - new numbering scheme.

 

Pitno

 

Number,11,0

E.g., 4217

Unique identifier used by MN/DOT to identify a pit - without letter (A or B)

 

Pitnoltr

 

Text, 2

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,13,1

E.g., 0.9, 3.6

Average amount of shale found in the sand fraction (percent).

 

Shale_grvl

 

Number,13,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

 

Number,13,1

e.g., 7.7, 28.5

Average amount of material lost in the Los Angeles Rattler test (percent).

 

Lar_b

 

Number,13,1

e.g., 24.2, 28.3

Average amount of material lost in the Los Angeles Rattler test (percent).

 

Lar_c

 

Number,13,1

e.g., 23.5, 26.0

Average amount of material lost in the Los Angeles Rattler test (percent).

 

Highshsand

 

Number,13,1

e.g., 3.3, 8.6

Highest amount of shale found in the sand fraction (percent).

 

Lowshsand

 

Number,13,1

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

 

Number,13,1

e.g., 2.4, 6.8

Highest amount of shale found in the gravel fraction (percent).

 

Low_sh_gvl

 

Number,13,1

e.g., 1.3, 6.3

Lowest amount of shale found in the gravel fraction (percent).

 

Rangeshgvl

 

Text, 16

e.g., 1.0-2.6, 2.8-6.3

Range of shale found in the gravel fraction (percent).

 

Highfeoxid

 

Number,13,1

e.g., 1.1-3.2

Highest amount of iron oxide found in sample (percent).

 

Lowfeoxide

 

Number,13,1

e.g., 0.2, 1.4

Lowest amount of iron oxide found in sample (percent).

 

Range_feox

 

Text, 16

e.g., 0.5-1.1, 1.3-2.3

Range of iron oxide found in sample (percent).

 

Highunchrt

 

Number,13,1

e.g., 0.0, 0.4

Highest amount of unsound chert found in sample (percent).

 

Lowunchert

 

Number,13,1

e.g., 0.0, 0.6

Lowest amount of unsound chert found in sample (percent).

 

Range_unch

 

Text, 16

e.g., 0.1-0.2, 0.4-0.4

Range of unsound chert found in sample (percent).

 

High_lar

 

Number,13,1

e.g., 25.3, 30.6

Highest amount of material lost in the Los Angeles Rattler test (percent).

 

Low_lar

 

Number,13,1

e.g., 7.0, 26.6

Lowest amount of material lost in the Los Angeles Rattler test (percent).

 

Range_lar

 

Text, 16

e.g., 19.9-25.3, 7.7-26.0

Range of material lost in the Los Angeles Rattler test (percent).