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