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