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.