Table Name |
Field Name |
Begin Column |
Definition |
Valid Values |
Descriptions |
Renvgpits.shp |
Pit_q_id |
|
Number, 3,0 |
e.g., 1, 2, 3, 10, 25, 101, 341 |
Gravel pit and quarry unique ID (1-202). |
|
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 April 2002. |
|
|
|
|
Soil Survey |
The Soil Survey of Renville, 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 1981. |
|
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
Renville County (6) and xxx refers to the MN/DOT assigned pit number. Use this field to join the renvqual.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. |