Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

meekgpits.shp

Type

 

Text, 16

Gravel Pit

Gravel Pit

 

 

 

 

Sand Pit

Sand Pit

 

Source

 

Text, 16

Ex:  MNDOT ASIS, Air photo, Field Work, Soil Survey, Topographic Map, etc…

This is where the gravel pit location came from or was observed (ex: soil - found on the soil map).

 

Pit_q_id

 

Number, 6,0

Ex:  1,2,3,4,5,6,7.... 341, 342, 343, 344

Gravel pit unique ID (1-215).

 

Asis_numbr

 

Number, 9,0

Ex:  0, 47035, 47036, 47070, etc…

Aggregate Source Information System Number (MN/DOT Database).  An empty field means that is does not have an ASIS number. 47xxx refers to Meeker County (47) and xxx refers to the pit number.  Use this field to join with dot_qual.dbf for the gravel pits that list the Source as  “ASIS”.

 

Size

 

Text, 8

Small

Refers to the relative size of the pit or quarry.  Small pits are generally less than a couple of acres or so.  These pits are usually used by private landowners or for small jobs.

 

 

 

 

Medium

Generally less than 10 acres in size.  These pits are used by landowners and for small construction jobs, They are generally used for short periods of time by contractors.

 

 

 

 

Large

These pits are generally greater than 10 acres and are typically used by commercial aggregate operators.

 

Thickmod

 

Text, 1

Ex: ~, >, <

Modifiers to express numeric approximations observed for deposit thickness: ~ means approximate, < means less than, and > means greater than.

 

Thickval

 

Number, 4

Ex: 5, 10. 15…

Gives a value for thickness.

 

Wattabmod

 

Text, 1

Ex: ~, >, <

Modifiers to express numeric approximations for the depth to the water table: ~ means approximate, < means less than, and > means greater than.

 

Wattabval

 

Text, 4

Ex: 5, 10. 15…

Describes the depth to the water table within a pit or quarry.  If 20 feet of gravel was exposed and there was no water table encountered, then >20 were used.

 

Thickness

 

Text, 15

Ex: >10, >20, >25, 10, 25, <20, etc

The thickness of the deposit expressed in combination with a modifier.

 

Watertable

 

Text, 15

Ex: >10, >20, >25, 10, 25, <20, etc

The depth of the water table expressed in combination with a modifier.

 

Status_a

 

Text, 16

Active

Refers to the status of the gravel pit at the time of mapping.  Active indicates that the pit is either being actively mined or used for other mining related usage like stockpiling material.

 

 

 

 

Inactive

Refers to a pit that does not appear to have been active for some time.

 

 

 

 

Reclaimed

The pit has been passively or actively reclaimed. Status_b further describes type of reclamation or what it ha

 

Dom_litho

 

Text, 20

Des Moines Lobe

Sand and gravel associated with a glacier called the Des Moines Lobe.  These sands and gravels contain deleterious rocks (like shale, iron oxides, and soft limestones) that can degrade the quality of the deposit.

 

 

 

 

Superior Lobe

Sand and gravel associated with a glacier called the Superior Lobe.  The quality of these deposits tends to be good to very good due to the rock types found within the deposits (basalt, granite, gabbro).  Also, these deposits have undergone some degree of mixing with rock types associated the Rainy Lobe (granites).

 

 

 

 

Undetermined

The source of the sand and gravel could not be determined.  This is primarily due to the deposit could not be access and was not observed and the surrounding geology is too complex to extrapolate the source.

 

Dom_text

 

Text, 25

Gravel with Sand

An approximation to characterized the amount of gravel vs. sand within a deposit.  These approximations are based on field observations and not laboratory tested.  Gravel with sand indicates the deposit contains a very significant portion (by percent weight) of gravel and the deposit has an overall very coarse texture.

 

 

 

 

Gravel and Sand

Indicates the deposit contains a large amount of gravel by percent weight and has coarse texture.

 

 

 

 

Sand and Gravel

Indicates the deposit has approximately equal or slightly more sand than gravel by percent weight.

 

 

 

 

Sand with Gravel

Indicates the deposit has more overall more sand than gravel by percent weight and has an overall fine texture

 

 

 

 

Sand occasional Gravel

Indicates the deposit contains mostly sand with few gravel-sized rocks and has a fine texture.

 

 

 

 

Sand

Indicates the deposit is composed of sand and has a fine texture.

 

 

 

 

Undetermined

The texture of the gravel pit was undetermined due to lack of exposure or geologic evidence to make a determination.

 

Ob_mod

 

Text, 1

Ex: ~, >, <

Modifiers to express numeric approximations for the overburden thickness at a gravel pit

 ~  approximate,

<  less than

 > greater than

 

Ob_val

 

Number, 4

 

Gives a value for overburden thickness

 

Overbrdn

 

Text, 15

 

Expresses overburden thickness by possibly using one or both the modifier and value.

 

Zstatus_b

 

Text, 40

 

Associated with the field status_a.  Usually this field further explains the condition of a partially or fully reclaimed gravel pit.  Examples include the following: sloped indicates the pit walls were sloped, naturally vegetated means the gravel pit is being reclaimed naturally through the revegetation of grass, shrubs or trees, agriculture, parks, dump indicates the current land use.