Table Name | Field Name | Begin Column | Definition | Valid Values | Descriptions
lesufobs.dbf | Field_ID |  | Text, 6 | e.g., JM-002, JM-006, RV-071 | Unique Identifiers used in the field.
| Site_type1 |  | Text, 20 |  | The type of field observation.
|  |  |  | Excavation | Material exposed through excavation as a badger hole, basement, construction, drill hole, exploration, foundation, road construction, road cut, tiling trench, trench, water hole, or well.
|  |  |  | Exposure | Material exposed along/at a/the bank, basement, construction, gully, judicial ditch, river, road, road construction, road cut, rodent hole, slump, stream, surface, tiling trench, tree tip, trench, water hole.
|  |  |  | Gravel Pit | Material seen at a gravel pit.
|  |  |  | Observation | An observation was made at a drill hole, tiling trench, or of vegetation.
|  |  |  | Outcrop | An outcrop was seen along a bank, river, road cut, or stream.
|  |  |  | Pit | An observation at a pit.
|  |  |  | Quarry | An observation at a quarry.
|  |  |  | Sand pit | An observation at a sand pit.
| Site_type2 |  | Text, 20 |  | Type of location where there was an excavation, exposure, gravel pit, observation, outcrop, pit quarry, or sand pit.
|  |  |  | Badger Hole | The excavation made by a badger or other rodent while digging a burrow. Includes the mound and the material observed in the hole.
|  |  |  | Bank | Exposure of material on a steep bank or slope.
|  |  |  | Basement | Excavation of a basement.
|  |  |  | Construction | Mining for fill material and/or other construction.
|  |  |  | Drill Hole | Test hole drilled with an 8 inch auger.
|  |  |  | Exploration | Material exposed while doing exploration for mineral resources.
|  |  |  | Foundation | Material exposed in the digging of a basement/foundation.
|  |  |  | Gravel Pit | Materials exposed in gravel pit.
|  |  |  | Gully | Material exposed in a gully.
|  |  |  | Judicial Ditch | Materials exposed in manmade ditch.
|  |  |  | Pit | A very small gravel, sand, or clay pit.
|  |  |  | Quarry | Bedrock units exposed in a quarry.
|  |  |  | River | Stream exposed an area.
|  |  |  | Road | Material exposed at the base of a road during excavation or a new road.
|  |  |  | Road Cut | Materials exposed in a road cut
|  |  |  | Rodent Hole | The excavation made by a small rodent while digging a burrow. Includes the mound and the material observed in the hole.
|  |  |  | Sand Pit | Material exposed in a sand pit.
|  |  |  | Slump | The material exposed when the surface slumped.
|  |  |  | Stream | The material exposed by a small river or stream.
|  |  |  | Surface | Exposures of bedrock/material on the ground surface.
|  |  |  | Tiling Trench | Trenches for pipelines, tiling, cables, etc.
|  |  |  | Tree Tip | Bedrock or glacial material exposed in the roots of a tree tip.
|  |  |  | Trench | Any trench exposure of material.
|  |  |  | Vegetation | Noting material by type of vegetation that grows on surface.
|  |  |  | Water Hole | The material observed in the mound of a water hole dug for cattle to drink water or for a recreational water hole.
|  |  |  | Well | Material exposed while digging a well.
| Material_1 |  | Text, 20 | e.g., Alluvial sand, Cobbly gravel, Limestone, Sand/Clay/Gravel, Till | Describes the primary type of material encountered at each observation site.
| Material_2 |  | Text, 20 | e.g., Alluvium, Gravel, Limestone, Sand with Gravel, Silt, Silty sand, Superior Lobe till | Describes the secondary (not primary) type of material at each observation site.
| Fielddesc |  | Text, 80 | e.g., Excavation - Basement - >8 feet - Sand; Excavation - Drill Hole - >6 feet - Till; Exposure - Bank - >15 feet - Cobbly Sand & Gravel; Outcrop - Bank - >10 feet Limestone | A short field description of the observation site.
| Thickmod |  | Text, 1 |  | Modifies the Thickval
|  |  |  | > | Greater than …
|  |  |  | < | Less than …
| Thickval |  | Integer, 4 | e.g., 4, 15, 20, 28, 50 | Describes the thickness of the unit at the observation site in feet.
| Overmod |  | Text, 1 |  | Modifies the Overval field.
|  |  |  | > | Greater than …
|  |  |  | < | Less than …
| Overval |  | Integer, 4 | e.g., 2, 4, 5, 25, 30 | The thickness of the overburden observed and estimated in feet.
| Unitthick |  | Text, 15 | e.g., 15, <25, >1, >28, >30 | A description of the thickness of the unit in feet, combining the Thickmod and Thickval fields.
| Overthick |  | Text, 15 | e.g., 2, <1, <4, >25, >40 | A description of the thickness of the overburden covering the unit, combining the Overmod and Overval fields.