MN/DOT PIT SHEET - SUMMARY OF
QUALITY DATA
Field |
Description |
Main ID Information |
Metadata Updated 2007 |
Title |
Nicollet County Aggregate Evaluation - MN/DOT Pit Labels |
Filename |
Dot_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 |
Nicollet County, Minnesota |
Theme Keywords |
MN/DOT, Gravel Pits, Quality, Soundness, Durability |
Time Period of Content |
1935-1992 (compiled in 1998) |
Parent Theme |
NA |
Spatial Extent of the Data |
Nicollet County, Minnesota |
Contact Person |
Aggregate Resource Mapping
Program (Geologist or GIS Specialist) St. Paul, MN 55155-4045 |
Contact Person Organization/Division |
Department of Natural Resources, Division of Lands and 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 Lands and 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 |
1999-2000 |
Maintenance Frequency |
None planned |
Access Constraints |
NA |
Use Constraints |
NA |
Associated Data Sets |
Gvl_pits.shp (Gravel Pit Locations) |
Data Quality |
|
Attribute Accuracy |
The ranges of values were 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 ranges of values were 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 / ArcInfo 8.0.2 |
Vendor Specific Object Type |
NA |
Tiling Scheme |
NA |
Spatial Object Type |
NA |
Transfer Size |
7 kb |
Entities -- Attributes |
|
Entity-Attribute Overview |
The ranges of values were 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. These data can be related to their locations, stored in the gvl_pits shapefile, by relating on the sourcexx field in dot_qual.dbf and the asis_number field in gvl_pits. |
Entity-Attribute Detailed Citation |
See table below: |
Table Name |
Field Name |
Begin Column |
Definition |
Valid Values |
Descriptions |
Dot_qual.dbf |
Mndot_old |
|
Text, 8 |
Ex: 4217A |
Unique identifier used by MN/DOT to identify a pit - old numbering scheme. |
|
Sourcexx |
|
Number,5,0 |
Ex: 52041 |
Unique identifier used by MN/DOT to identify a pit - new numbering scheme. |
|
Pitno |
|
Number,5,0 |
Ex: 4217 |
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.9, 3.6 |
Average amount of shale found in the sand fraction (percent). |
|
Shale_grvl |
|
Number,4,1 |
Ex: 1.4, 3.9 |
Average amount of shale found in the gravel fraction (percent). |
|
Feoxidepct |
|
Number,4,1 |
Ex: 1.4, 2.3 |
Average amount of iron oxide found in sample (percent). |
|
Unchertpct |
|
Number,4,1 |
Ex: 0.2, 0.6 |
Average amount of unsound chert found in sample (percent). |
|
Lar_a |
|
Number,4,1 |
Ex: 7.7, 28.5 |
Average amount of material lost in the Los Angeles Rattler test (percent). |
|
Lar_b |
|
Number,4,1 |
Ex: 24.2, 28.3 |
Average amount of material lost in the Los Angeles Rattler test (percent). |
|
Lar_c |
|
Number,4,1 |
Ex: 23.5, 26.0 |
Average amount of material lost in the Los Angeles Rattler test (percent). |
|
Highshsand |
|
Number,4,1 |
Ex: 3.3, 8.6 |
Highest amount of shale found in the sand fraction (percent). |
|
Lowshsand |
|
Number,4,1 |
Ex: 1.1, 4.4 |
Lowest amount of shale found in the sand fraction (percent). |
|
Rangeshsnd |
|
Text, 16 |
Ex: 1.1-3.3, 2.7-8.8 |
Range of shale found in the sand fraction (percent). |
|
High_shgvl |
|
Number,4,1 |
Ex: 2.4, 6.8 |
Highest amount of shale found in the gravel fraction (percent). |
|
Low_sh_gvl |
|
Number,4,1 |
Ex: 1.3, 6.3 |
Lowest amount of shale found in the gravel fraction (percent). |
|
Rangeshgvl |
|
Text, 16 |
Ex: 1.0-2.6, 2.8-6.3 |
Range of shale found in the gravel fraction (percent). |
|
Highfeoxid |
|
Number,4,1 |
Ex: 1.1-3.2 |
Highest amount of iron oxide found in sample (percent). |
|
Lowfeoxide |
|
Number,4,1 |
Ex: 0.2, 1.4 |
Lowest amount of iron oxide found in sample (percent). |
|
Range_feox |
|
Text, 16 |
Ex: 0.5-1.1, 1.3-2.3 |
Range of iron oxide found in sample (percent). |
|
Highunchrt |
|
Number,4,1 |
Ex: 0.0, 0.4 |
Highest amount of unsound chert found in sample (percent). |
|
Lowunchert |
|
Number,4,1 |
Ex: 0.0, 0.6 |
Lowest amount of unsound chert found in sample (percent). |
|
Range_unch |
|
Text, 16 |
Ex: 0.1-0.2, 0.4-0.4 |
Range of unsound chert found in sample (percent). |
|
High_lar |
|
Number,4,1 |
Ex: 25.3, 30.6 |
Highest amount of material lost in the Los Angeles Rattler test (percent). |
|
Low_lar |
|
Number,4,1 |
Ex: 7.0, 26.6 |
Lowest amount of material lost in the Los Angeles Rattler test (percent). |
|
Range_lar |
|
Text, 16 |
Ex: 19.9-25.3, 7.7-26.0 |
Range of material lost in the Los Angeles Rattler test (percent). |