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