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.