MN/DOT PIT SHEET - SUMMARY OF QUALITY DATA



Field

Description

Main ID Information

Metadata Updated 2007

Title

Blue Earth County Aggregate Evaluation - MN/DOT Pit Labels

Filename

Pit_qual (DataBase File)

Abstract

This dataset consists of information about the quality of Minnesota Department of Transportation Gravel Pits and aggregate sources. The soundness, durability, and mineral content. Includes the averages and ranges of values for the different quality tests. This information was summarized off the MN/DOT pit sheets.

Place Keywords

Blue Earth County, Minnesota

Theme Keywords

MN/DOT, Gravel Pits, Quality, Soundness, Durability

Time Period of Content

1935-1987 (compiled in 1998)

Parent Theme

NA

Spatial Extent of the Data

Blue Earth County, Minnesota

Contact Person

Aggregate Resources Mapping Program

Contact Person Organization/Division

Department of Natural Resources, Division of Minerals

Contact Person Position

Geologist or GIS Specialist

Contact Address

500 Lafayette Road, Box 45

Contact City

St. Paul

Contact Zip Code

55155-4045

Contact Voice Phone

651-259-5959

Contact Fax Phone

651-296-5939

Additional ID Information

 

Originator

Department of Natural Resources, Division of Minerals, Mineral Potential Section

Purpose

This table summarized the quality data that is presented on the MN/DOT pit sheets. MN/DOT has specifications that the aggregate must meet to be used for specific jobs. This table summarizes the quality data by averaging the values of the pit and giving the range of values.

Progress

Complete

Currentness Reference

1998-1999

Maintenance Frequency

None planned

Access Constraints

NA

Use Constraints

NA

Associated Data Sets

dpitslbl.shp (one-to-one relate with dpitslbl on sourcexx or combination of pitno, pitnoltr.

Data Quality

 

Attribute Accuracy

The range of values was taken directly from MN/DOT pit sheets. These numbers were also averaged to represent the entire pit. However, a pit may meet specifications on one end and not the other, or the top 10 feet may meet specs and the bottom layers do not. Thus, care must be taken with interpreting this information. For further detail please see pit sheets from MN/DOT.

Logical Consistency

NA

Completeness

All available data were summarized and are incorporated within this table.

Horizontal Positional Accuracy

NA

Vertical Positional Accuracy

NA

Lineage

The range of values was taken directly from MN/DOT pit sheets. These numbers were also averaged to represent the entire pit. However, a pit may meet specifications on one end and not the other, or the top 10 feet may meet specs and the bottom layers do not. Thus, care must be taken with interpreting this information. For further detail please see pit sheets.

Source Scale Denominator

NA

Spatial Reference

 

Horizontal Coordinate Scheme

NA

Ellipsoid

NA

Horizontal Datum

NA

Horizontal Units

NA

Distance Resolution

NA

Altitude Datum

NA

Altitude Units

NA

Depth Datum

NA

Depth Units

NA

UTM Zone Number

NA

Raster only

 

Cell Width

NA

Cell Height

NA

Spatial Data Organization

 

Geographic Reference for Tabular Data

NA

Native Dataset Environment

ArcView 3.1 / ArcInfo7.2.1

Vendor Specific Object Type

NA

Tiling Scheme

NA

Spatial Object Type

NA

Transfer Size

6 kb

Entities -- Attributes

 

Entity-Attribute Overview

The range of values was taken directly from MN/DOT pit sheets. These numbers were also averaged to represent the entire pit. However, a pit may meet specifications on one end and not the other, or the top 10 feet may meet specs and the bottom layers do not meets specs. Thus, care must be taken with interpreting this information. For further detail please see pit sheets.

Entity-Attribute Detailed Citation

See table below:





Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

Pit_qual.dbf

Mndot_old

 

Text, 8

Ex: 4307A

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

 

Sourcexx

 

Text, 5

Ex: 07051

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

 

Pitno

 

Number,5,0

Ex: 4307

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

 

Pitnoltr

 

Text, 2

Ex: A

Unique identifier used by MN/DOT to identify a pit

- if more than one pit (A, B, or C).

 

Shale_sand

 

Number,4,1

Ex: 0.2, 1.9

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

 

Shale_grvl

 

Number,4,1

Ex: 0.7, 5.4

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

 

Feoxidepct

 

Number,4,1

Ex: 1.4, 2.5

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

 

Unchertpct

 

Number,4,1

Ex: 0.3, 0.5

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

 

Lar_a

 

Number,4,1

Ex: 19.4, 23.2

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

 

Lar_b

 

Number,4,1

Ex: 20.4, 24.8

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

 

Lar_c

 

Number,4,1

Ex: 24.3, 28.9

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

 

Highshsand

 

Number,4,1

Ex: 7.1, 3.5

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

 

Lowshsand

 

Number,4,1

Ex: 3.7, 1.1

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

 

Rangeshsnd

 

Text, 16

Ex: 3.7-7.1, 1.1-3,5

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

 

High_shgvl

 

Number,4,1

Ex: 11.1, 18.4

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

 

Low_sh_gvl

 

Number,4,1

Ex: 4.5, 2.1

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

 

Rangeshgvl

 

Text, 16

Ex: 4.5-11.1, 2.1-18.4

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

 

Highfeoxid

 

Number,4,1

Ex: 0.6, 2.3

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

 

Lowfeoxide

 

Number,4,1

Ex: 0.1, 1.2

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

 

Range_feox

 

Text, 16

Ex: 0.1-0.6, 1.2-2.3

Range of iron oxide found in sample (percent).

 

Highunchrt

 

Number,4,1

Ex: 0.3, 1.4

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

 

Lowunchert

 

Number,4,1

Ex: 0.3, 0.8

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

 

Range_unch

 

Text, 16

Ex: 0.3-0.3, 0.8 -1.4

Range of unsound chert found in sample (percent).

 

High_lar

 

Number,4,1

Ex: 23.4, 32.1

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

 

Low_lar

 

Number,4,1

Ex: 22.1, 28.3

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

 

Range_lar

 

Text, 16

Ex: 22.1-23.4, 28.3-32.1

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