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.