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