MN/DOT PIT SHEET - SUMMARY OF QUALITY DATA

DODGE COUNTY, MINNESOTA

Field | Description
Main ID Information | Metadata Updated 2007
Title | Dodge County Aggregate Evaluation - MN/DOT Quality Data
Filename | Dotqual.dbf (dbase 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 | Dodge County, Minnesota
Theme Keywords | MN/DOT, Gravel Pits, Quality, Soundness, Durability
Time Period of Content | 1937-1995 (compiled in 2000)
Parent Theme | NA
Spatial Extent of the Data | Dodge County, Minnesota
Contact Person | Aggregate Resources Mapping Program
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 summarizes 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 | 2001
Maintenance Frequency | None planned
Access Constraints | NA
Use Constraints | NA
Associated Data Sets | Gvl_pits.shp (Gravel Pit Locations) and sieve.dbf
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 specifications and the bottom layers do not. Thus, care must be taken when 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 when 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 | 5 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 specifications and the bottom layers do not meet specifications. Thus, care must be taken when interpreting this information. For further detail, please see the pit sheets. These data can be related to their locations, stored in the gvl_pits shapefile, by relating on the sourcexx field in dotqual.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
Dotqual.dbf | Mndot_old |  | Text, 8 | Ex: 437 | Unique identifier used by MN/DOT to identify a pit - old numbering scheme.
| Sourcexx |  | Number,11,0 | Ex: 20004 | Unique identifier used by MN/DOT to identify a pit - new numbering scheme.
| Pitno |  | Number,5,0 | Ex: 437 | 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).
| Highshgvl |  | Number,4,1 | Ex: 2.4, 6.8 | Highest amount of shale found in the gravel fraction (percent).
| Lowshgvl |  | 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).
| Asis_num |  | Number,5,0 | Ex: 20041, 20030 | Field to use to relate dotqual.dbf to the gvl_pits shapefile. Unique identifier used by MN/DOT to identify a pit.