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. |