Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

Lesugpits.shp

Pit_q_id

 

Number, 3,0

e.g., 1, 2, 3, 10, 25, 101, 341

Gravel pit and quarry unique ID (1-344).

 

Source

 

Text, 16

 

The source of the gravel pit location.

 

 

 

 

Air Photo

1:40000 color infrared photos from the National Aerial Photography Program (NAPP) from 1991-1992 or 1:12000 Digital Orthophoto Quads (DOQs) from the U.S. Geological Survey from 1991.

 

 

 

 

MNDOT ASIS

Aggregate Source Information System from the Minnesota Department of Transportation, downloaded in March 2001.

 

 

 

 

Soil Survey

The Soil Survey of Le Sueur County, 1989 (soil conditions from 1985), from the United States Department of Agriculture, Natural Resources Conservation Service (USDA-NRCS).

 

 

 

 

Topographic Map

1:24000 Digital Raster Graphics (DRGs) from U.S. Geological Survey, based on the 7.5-minute topographic map series, with individual quads dating from 1965 to 1993.

 

Type

 

Text, 16

Gravel Pit

Gravel Pit

 

 

 

 

Sand Pit

Sand Pit

 

 

 

 

Quarry

Quarry

 

Asis_numbr

 

Number, 5,0

e.g., 40001, 40014, 40053

Aggregate Source Information System Number (MN/DOT Database).  An empty field means that this pit or quarry does not have an ASIS number.40xxx refers to Le Sueur County (4) and xxx refers to the MN/DOT assigned pit number.  Use this field to join the lesuqual.dbf table (joining on the Sourcexx field) for the gravel pits that list the Source as  “MNDOT ASIS”.

 

Size

 

Text, 8

 

The relative size of the pit or quarry

 

 

 

 

Small

Small pits are less than 5 acres in size.

 

 

 

 

Medium

Medium pits are 5 to 15 acres in size.

 

 

 

 

Large

Large pits are larger than 15 acres in size.

 

Thickmod

 

Text, 1

>

The modifier used in conjunction with the Thickval field to indicate the relative thickness of the aggregate observed in the pit or quarry.

In this case, greater than.

 

Thickval

 

Integer, 4

e.g., 5, 10, 18, 25, 30

The thickness, in feet, of the aggregate observed in the pit or quarry.  Consider this field in conjunction with the Thickmod field. 

 

Wattabmod

 

Text, 1

>

The modifier used in conjunction with the Wattabval field to indicate the relative depth to the watertable observed in the pit or quarry.

In this case, greater than.

 

Wattabval

 

Integer, 4

e.g., 8, 12, 15, 25, 30, 50

The depth, in feet, of the watertable observed in the pit or quarry.  Consider this field in conjunction with the Wattabmod field. 

 

Thickness

 

Text, 15

e.g., >5, >28, >40

The approximate thickness, in feet, of the aggregate observed at the pit or quarry.  This field combines the Thickmod and Thickval fields.

 

Watertable

 

Text, 15

e.g., >8, >10, >18, >45

The approximate depth of the watertable observed in a pit or quarry.  This field combines the Wattabmod and Wattabval fields.