MN DOT TEST PIT DATA AND ASSOCIATED TABLES

EASTERN CLAY COUNTY, MINNESOTA

Field | Description
Main ID Information | Metadata Updated 2007
Title | Aggregate Resource Potential of Eastern Clay County, Minnesota - MNDOT test pit data. These layers are part of Minnesota Department of Natural Resources, Minerals Division, Report 306, from 1997.
Filename | Shapefiles: gp97bpt3 (test holes in gravel pits) and glb97pt3 (one label per gravel pit) Access 97 database: dotpit97.mdb
Abstract | This dataset consists of MNDOT test hole locations, captured from MNDOT test pit sheets, at a scale of 1":1000ft. DNR did not verify the accuracy of the test hole locations as marked on the pit sheets.
Place Keywords | Clay County, Minnesota; eastern 18 townships of county (Barnesville, Cromwell, Eglon, Elkton, Felton, Flowing, Goose Prairie, Hagen, Hawley, Highland Grove, Humboldt, Keene, Parke, Riverton, Skree, Spring Prairie, Tansem, Ulen)
Theme Keywords | Gravel pits
Time Period of Content | 1934-1991
Parent Theme |
Spatial Extent of the Data | Eastern 18 townships of Clay County, Minnesota
Contact Person | Aggregate Resources Mapping Program
Contact Person Organization/Division | Minnesota 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, MN
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 | To display the MNDOT test hole locations in Clay County, Minnesota. The shapefile, glb97pt3, consists of one of the test hole locations that can serve as a label point for the entire gravel pit in which the test hole locations are found.
Progress | Complete
Currentness Reference | 1934-1995
Maintenance Frequency | None planned
Access Constraints | NA
Use Constraints | NA
Associated Data Sets | shapefiles: agg97py3 - aggregate potential and surficial geology, agg97ln3 - aggregate potential and surficial geology polygon lines, sym97ln3 - surficial geology/aggregate potential lines, gp97apt3 - gravel pits
Data Quality |
Attribute Accuracy |
Logical Consistency |
Completeness |
Horizontal Positional Accuracy | Varies. Some of the pit sheets had a reference point, such as a section corner (1/4 section, 1/4-1/4 section), that could be identified using the control point inventory (of the MN DNR GIS Core Library) and then, using the base grid lines, three other points could be found for registration. Other pit sheets were less accurately registered due to a lack of a "known" point (such as a section corner).
Vertical Positional Accuracy | NA
Lineage | These shapefiles and Access database file are part of Minnesota Department of Natural Resources, Minerals Division, Report 306, Aggregate Resource Potential of Eastern Clay County, 1997, by JD Lehr. Known registration points were found on the pit sheets, then using the base grid lines (1":100ft), other registration points could be found. Next, the test hole locations were digitized and the pit number and test hole number were entered. Since the digitizing was done in State Plane Coordinates, Arc/INFO was used to project the points into UTM extended zone 15, NAD 83.
Source Scale Denominator | 1 inch to 100 feet
Spatial Reference |
Horizontal Coordinate Scheme | UTM
Ellipsoid | GRS80
Horizontal Datum | NAD83
Horizontal Units | Meters
Distance Resolution | NA
Altitude Datum | NA
Altitude Units | NA
Depth Datum | NA
Depth Units | NA
UTM Zone Number | 15, extended
Raster only |
Cell Width | NA
Cell Height | NA
Spatial Data Organization |
Geographic Reference for Tabular Data | NA
Native Dataset Environment | ArcView 3.1 / Arc/INFO 7.2.1
Vendor Specific Object Type | NA
Tiling Scheme | NA
Spatial Object Type | NA
Transfer Size |
Entities -- Attributes |
Entity-Attribute Overview | The dataset includes locational information about the MNDOT test holes in Clay County, Minnesota.
Entity-Attribute Detailed Citation | Complete table below:

Table Name | Field Name | Begin Column | Definition | Valid Values | Descriptions
gp97bpt3 shapefile |  |  |  |  | Shapefile of MN DOT test holes.
| source_num |  | Number,5,0 | 14001...14072, where 14 is the assigned county code. | The unique ID for gravel pits. The gravel pit may consist of several non-contiguous parts.
| tpit_num |  | Number,3,0 | 1...n, where n is the number of test holes drilled in a gravel pit. In most cases, n is <50. One gravel pit has over 100 test holes, and one gravel pit has tpit numbers of 301-305. | For each gravel pit, the unique ID of each test hole drilled.
| src_tpit |  | Text,9 | e.g., 14001_46, 14057_8, 14071_16 | A unique identifier that combines the source_num and the tpit_num. Use to relate this file with the hole and sieve tables in dotpit97.mdb.
glb97pt3 shapefile |  |  |  |  | Label point for each group of MN DOT test pits.
| source_num |  | Number,5,0 | 14001...14072, where 14 is the assigned county code. | The unique ID for gravel pits. The gravel pit may consist of several non-contiguous parts.
| tpit_num |  | Number,3,0 | e.g., 1, 9, 18, 23, 55 | For each gravel pit, one of the test pits was selected to serve as the label point for the gravel pit.
dotpit97.mdb |  |  |  |  | Access database of sieve data related to the MN DOT test pits.
hole table |  |  |  |  | Information about each hole drilled.
| source_num |  | Number, integer | 14xxx, where 14 is the county number and xxx represents the pit number. | The source that was drilled, identified by a unique ID.
| tpit_num |  | Number, integer | 1...n, where n is the number of test holes drilled in a source (generally a gravel pit). In most cases, n is <50. | For each source, the unique ID of each test hole drilled.
| src_tpit |  | Text,9 | e.g., 14001_46, 14057_8, 14071_16 | A unique identifier that combines the source_num and the tpit_num. Use to relate this table with the gp97bpt3 shapefile.
| ovr_burd |  | Number, single, 1 | e.g., 0.5, 2, 2.5, 5 | The depth, in feet, of the overburden for the drill hole.
| bottom |  | Text,6 | e.g., CLT,WS,C,S&G, CS,G,R,VFS Si,SiL | The material found at the bottom of the hole (ClayLoamTill,WetSand, Clay,Sand&Gravel, CoarseSand,Gravel,Rock, VeryFineSandy Silt, SiltyLoam)
| elev |  | Number, single,1 | e.g., 96.84, 407.2,409.7, 996.4,1000.3 | Units ??, Units ??, Given in feet
| h2o |  | Number, integer | e.g., 6,13,21,22 | Given in feet below the surface
| date_drill |  | Date/time | e.g., 10/10/38, 4/15/54, 10/8/85 | Date of test hole drilling
| comments |  | Text,35 | e.g., G to 20', S28' to 31'; S&G to 30'; 26' to 44' S&G | Additional information about the test pit
sieve table |  |  |  |  | The sieve analysis data for each test pit drilled in a source
| source_num |  | Number, integer | 14xxx, where 14 is the county number and xxx represents the pit number | The source that was drilled
| tpit_num |  | Number, integer | 1...4, where n is the number of test holes drilled in a source (generally a gravel pit). In most cases, n is <50. | For each source, the unique ID of each test hole drilled.
| src_tpit |  | Text,9 | e.g., 14001_46, 14057_8, 14071_16 | A unique identifier that combines the source_num and the tpit_num. Use to relate this table with the gp97bpt3 shapefile in a 1-to-many relate (where the shapefile records are the 1 and the sieve records are the many).
| depth_top |  | Number, single, 1 decimal | e.g., 1.5, 5, 15, 25 | Top of a given profile (in relation to depth_bot, the bottom of the given profile). Given in feet below the surface.
| depth_bot |  | Number, single, 1 decimal | e.g., 5, 15, 25, 33 | Bottom of a given profile (in relation to depth_top, the top of the given profile). Given in feet below the surface.
| mesh_125 |  | Number, integer | Numbers range from 0 to 100. | Percentage of material passing through 125 mesh sieve, square openings. Note: if oldv_newv = o, sieve is 150 mesh.
| mesh_75 |  | Number, single, 1 decimal | Numbers range from 0 to 100. | Percentage of material passing through 75 mesh sieve, square openings. Note: if oldv_newv = o, sieve is 75 mesh.
| mesh_no4 |  | Number, single, 1 decimal | Numbers range from 0 to 100. | Percentage of material passing through No. 4 mesh sieve, square openings. Note: if oldv_newv = o, sieve is .25".
| mesh_no10 |  | Number, single, 1 decimal | Numbers range from 0 to 100. | Percentage of material passing through No. 10 (2mm) sieve, square openings. Note: if oldv_newv = o, sieve is No. 10.
| mesh_no40 |  | Number, single, 1 decimal | Numbers range from 0 to 100. | Percentage of material passing through No. 40 (420 microns) sieve, square openings. Note: if oldv_newv = o, sieve is P.
| mesh_no200 |  | Number, single, 1 decimal | Numbers range from 0 to 100. | Percentage of material passing through No. 200 (74 microns) sieve, square openings.
| oldv_newv |  | Text,1 | o=old format, n=new format | Indicates sieve sizes used, see note listed in mesh_xxx fields.
| grav_pct |  | Number, single, 1 decimal | Numbers range from 0 to 95.9. Some test pits have no data. | Percentage of gravel in the test hole profile, derived from the amount of material passing through various sieves; equals percent (%) by weight of paticles greater than 2 mm diameter (10 mesh sieve) divided by total sample weight.
| fines_pct |  | Number, single, 1 decimal | Numbers range from 1.3 to 99. Some test pits have no data. | Percentage of fines in the test hole profile, derived from the amount of material passing through various sieves; equals percent (%) by weight of particles smaller than 2 mm diameter (10 mesh sieve) divided by total sample weight.
| cssand_pct |  | Number, single, 1 decimal | Numbers range from .7 to 93.8. Some test pits have no data. | Percentage of coarse sand in the test hole profile, derived from the amount of material passing through various sieves; equals percent (%) by weight of particles in the size range >0.5 mm and <2 mm.
| csgrav_pct |  | Number, single, 1 decimal | Numbers range from 0 to 94.2. Some test pits have no data. | Percentage of coarse gravel in the test hole profile, derived from the amount of material passing through various sieves; equals percent (%) by weight of particles in the size range >9.50 mm (3/8 inch) and <50 mm (~2 mm).
| fngrav_pct |  | Number, single, 1 decimal | Numbers range from 0 to 71.8. Some test pits have no data. | Percentage of fine gravel in the test hole profile, derived from the amount of material passing through various sieves; equals percent (%) by weight of particles in the size range >2 mm and <9.50 mm (3/8 inch).