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, Granite/Gneiss, Sand/Clay/Gravel, Till

Describes the primary type of material encountered at each observation site.

 

Material_2

 

Text, 20

e.g., Alluvium, Gravel, Granite/Gneiss, 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 Thickmin

 

 

 

 

>

Greater than …

 

 

 

 

<

Less than …

 

Thickmin

 

Integer, 6

 

The  minimum observed thickness of a unit at an observation site (in feet).

 

Thickmax

 

Integer, 6

 

The  maximum observed thickness of a unit at an observation site (in feet).

 

Overmod

 

Text, 1

 

Modifies the Overval field.

 

 

 

 

>

Greater than …

 

 

 

 

<

Less than …

 

Overmin

 

Integer, 6

 

The  minimum observed overburden thickness of a unit at an observation site (in feet).

 

Overmax

 

Integer, 6

 

The  maximum observed overburden thickness of a unit at an observation site (in feet).

 

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 Thickmin and Thickmax fields.

 

Overthick

 

Text, 15

e.g., 2, <1, <4, >25, >40

A description of the thickness of the overburden covering the unit, combining the Overmin and Overmax fields.