MN/DOT PITS - LABELS



Field

Description

Main ID Information

Metadata Updated 2007

Title

Blue Earth County Aggregate Evaluation - MN/DOT Pit Labels

Filename

Dpitslbl (ArcView Shapefile)

Abstract

This dataset consists of information about the Minnesota Department of Transportation Gravel Pit Locations and their identification.

Place Keywords

Blue Earth County, Minnesota

Theme Keywords

MN/DOT, Gravel Pits, ASIS, Pit Locations, Pit Labels

Time Period of Content

1935-1987 (compiled in 1998)

Parent Theme

NA

Spatial Extent of the Data

Blue Earth County, Minnesota

Contact Person

Aggregate Resources Mapping Program

Contact Person Organization/Division

Department of Natural Resources, Division of 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 Minerals, Mineral Potential Section

Purpose

This dataset is used to uniquely identify each known and existing MN/DOT aggregate resource where test holes were drilled by auger. Use associated shapefile, DOTPITS, to identify the locations of the test holes.

Progress

Complete

Currentness Reference

1998-1999

Maintenance Frequency

None planned

Access Constraints

NA

Use Constraints

NA

Associated Data Sets

Dotpits.shp and pit_qual.dbf

Data Quality

 

Attribute Accuracy

Theses pit locations are the centroid of a gravel pit or centroid of an area of test holes. Most of these locations were digitized off surveyed pit sheets, and are very accurate. However, it was difficult to obtain 4 reference points for all these pits, so some may not be as accurate. A column within the database describes the accuracy.

Logical Consistency

NA

Completeness

These locations were digitized off surveyed point locations, thus the information should be fairly accurate (within 10 meters).

Horizontal Positional Accuracy

1:1000

Vertical Positional Accuracy

NA

Lineage

Theses pit locations are the centroid of a gravel pit or centroid of an area of test holes. Most of these locations were digitized off surveyed pit sheets, thus are very accurate, however, it was difficult to obtain 4 reference points for all these pits, thus some may not be as accurate. A column within the database describes the accuracy.

Source Scale Denominator

1:1000

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

Raster only

 

Cell Width

NA

Cell Height

NA

Spatial Data Organization

 

Geographic Reference for Tabular Data

These points represent the centroid of a gravel pit or the centroid of a series of test holes. Each of these pits were digitized from MN/DOT pit sheets, thus have a unique pit number.

Native Dataset Environment

ArcView 3.1 / ArcInfo7.2.1

Vendor Specific Object Type

NA

Tiling Scheme

County

Spatial Object Type

Point

Transfer Size

6.29 kb

Entities -- Attributes

 

Entity-Attribute Overview

These points represent the centroid of a gravel pit or the centroid of a series of test holes. Each of these pits were digitized from MN/DOT pit sheets, thus have a unique pit number.

Entity-Attribute Detailed Citation

See table below: Arcview specific fields include shape (i.e., feature type = point), area (0 for points), perimeter (0 for points), filename (unique id for point, assigned by the software), filename_i or filename_id if filename is less than 8 characters (an id usually assigned during theme creation).





Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

Dpitslbl.shp

Pitno

 

Number,5,0

Ex: 1035,1046, 4866, 5058,5251, 7049

This is the unique identifier that MN/DOT assigned to its pits (OLD numbering scheme).

 

Pitnoltr

 

Text, 2

Ex: A, AB, B, or C

Sometimes 2 or three pits grow together, or a pit expands so they put a modifier on the unique identifier instead of a new pit number (Ex: 1035A and 1035B). OLD numbering scheme.

 

Plotyn

 

Text, 1

Y

Several gravel pits were close together so that on a 1:100,000 scale map they were on top of each other. Where this occurred only one location was plotted and thus represented more than one pit location.

 

 

 

 

N

The pit was not plotted on the 1:100,000 scale map due to clustering.

 

Shale_spec

 

Text, 1

Y

If the MN/DOT pit samples passed the specifications for shale/deleterious material then Y = yes.

 

Locat_qual

 

Text, 4

good

The Mn/DOT pit sheets have the drill hole locations surveyed and plotted on a grid. As these points were digitized, the quality of given X, Y, and Z coordinates varied. Good quality locations are probably accurate to within a few meters; at least 4 good quality x and y known surveyed reference points were used.

 

 

 

 

mod

The quality of the location is within a 10-20 meters, only 2 or 3 known x and y reference locations were used.

 

 

 

 

poor

There was not sufficient evidence to pinpoint the hole locations, however they are located as best as they could be with reference points such as road intersections, fence lines, trees, home locations, etc.

 

Sourcexx

 

Text, 5

Ex: 07010, 07018

This is the new numbering scheme used by MN/DOT. These numbers are the unique identifiers of the pits.

 

Sourcexx2

 

Text, 5

Ex: 07052, 07063

This is the new numbering scheme used by MN/DOT. These numbers are the unique identifiers of the pits that have more than one identifier (Example 1045AB). This file would represent the new unique identifier for 1045B.

 

Rec_Status

 

Text_9

Dead File

If the pit sheet had a stamp "DEAD FILE", the pit was not assigned a new unique identifier (sourcexx).

 

Asisrec

 

Text, 1

Y

MN/DOT has aggregate information about its pits stored in the ASIS (Aggregate Source Information System) database. If the pit sheets are included in this file, then Y = yes

 

 

 

 

N

If these pits are not included in the ASIS database, then N = No.

 

Year

 

Number,4,0

Ex: 1935, 1941, 1987

This represents the year that the drilling took place; the year is listed on the pit sheet.