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