Table Name |
Field Name |
Begin Column |
Definition |
Valid Values |
Descriptions |
carlfobs.dbf |
FIELD_ID |
Text, 8 |
Ex: QQ-215, ZZ-912,
CD-001, DD-008 |
Unique identifiers used
in the field. |
|
SITETYPE_1 |
Text, 25 |
See Below |
|||
Borrow Pit |
A pit usually dug in
material that is not sand and gravel. |
||||
Drill Hole |
Test hole drilled with
a Giddings Soil probe. |
||||
Excavation |
Badger holes, trenches,
construction areas, or foundations. |
||||
Exposure |
Outcrop of material
from erosional processes. |
||||
Gravel Pit |
Gravel pits exposing
sand and gravel material. |
||||
Other |
Based on communication
or observation. |
||||
Sand Pit |
Pit exposing sand with
little to no gravel. |
||||
SITETYPE_2 |
Text, 25 |
See Below |
Further description of
the observation site specified in Site_type1. |
||
Animal Hole |
A hole dug by an animal
which exposes sediment. |
||||
ATV Trail |
Sediment exposed within
trail for ATVs. |
||||
Backhoe |
A hole dug by a
backhoe. |
||||
Basement |
Excavation of a
basement. |
||||
Borrow Pit |
A mined pit for
construction material. |
||||
Cemetery |
Excavation in cemetery. |
||||
Communication |
Contact with
landowners, drillers, and experts verifying well records. |
||||
Construction |
Mining or digging due
to construction. |
||||
Ditch |
Material exposed in a
ditch due to a slump or landscaping that has removed vegetation. |
||||
Drainage |
Material exposed in a
small water drainage feature. |
||||
Drill Hole |
Material extracted from
drilling. Test hole drilled with an 8-inch auger. |
||||
Driveway |
Surficial material
exposed in driveway. |
||||
Embankment |
Sediment exposed in a
slope or hill where vegetation is patchy or lacking. |
||||
Fence Post |
Exposure in and around
fence post. |
||||
Field |
Exposure of sediment in
tilled agricultural field. |
||||
Foundation |
Sediment exposed
through excavation of material for future building foundation. |
||||
Generalization |
A general observation
made about the landscape, vegetation, and other features. |
||||
Gravel Pit |
Materials exposed in
gravel pit. |
||||
Livestock Trail |
Material exposed by
livestock in trail through pasture. |
||||
Observation |
Generalized observation
based on aerial photos or of presence of bedrock boulders. |
||||
Outcrop |
Exposure of bedrock
outcrop. |
||||
Parking Lot |
Surficial material
exposed in parking lot. |
||||
Peat Farm |
Sediment exposed in
farming area. |
||||
River Cut |
Stream exposed an area. |
||||
Road Cut |
Materials exposed in a
road cut. |
||||
Sand Pit |
Pit excavation
revealing sand with little to no gravel. |
||||
Slump |
Exposure of sediment
due to erosion. |
||||
Surface |
Exposures of
bedrock/material on the ground surface. |
||||
Telephone Pole |
Sediment exposed due to
drilling and installation of new telephone poles. |
||||
Tree Tip |
Exposure after a tree
blows over and roots are tilted out of the ground revealing underlying
sediment. |
||||
Trowel |
Exposure by excavating
material with hand held trowel. |
||||
Vegetation |
Sediment texture
inferred and generalized based on vegetation assemblage observed. |
||||
MATERIAL_1 |
Text, 25 |
See Below |
Describes the primary
type of material encountered at each observation site and does not
necessarily reflect stratigraphic order. |
||
Bedrock |
Outcrop of bedrock, or
presence of bedrock boulders. |
||||
Boulders |
Presence of bedrock
boulders. |
||||
Clay |
Clay is a very
fine-grained sediment that is less than.0.004 mm in size. |
||||
Did not observe |
Material could not be
viewed, either due to heavy vegetation or lack of access. |
||||
Gravel with Sand |
Sediment that contains
a mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains greater than 50% by volume gravel. |
||||
N/A |
A generalized
observation and/or inference based on vegetation or exposure. |
||||
Organics |
Soil that contains
decaying organic matter. |
||||
Peat |
Specific unique type of
vegetation observed that indicates high water table. |
||||
Rocky Soil |
Observation based on
surficial exposure usually within tilled field or pasture with little
vegetation. |
||||
Sand |
Sand is composed of
rocks and minerals that range in diameter from 0.0625 to 2 mm. |
||||
Sand and Gravel |
Sediment that contains
a mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains greater than 15% by volume gravel. |
||||
Sand minor Gravel |
Sediment that contains
a mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains approximately less than 7% by volume gravel. |
||||
Sand with Gravel |
Sediment that contains
a mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains less than 15% by volume gravel. |
||||
Silty Sand |
Sand that contains some
silt. |
||||
Silty Sand and Gravel |
Sediment that contains
a mixture of rocks in varying sizes ranging from 0.004 to 64 mm. This description is given to sediment that
contains a high amount of silt as well as sand and gravel. |
||||
Till |
A term used to describe
the unsorted sediment deposited by glaciers- contains a mixture of clay,
silt, sand, gravel and boulders. |
||||
MATERIAL_2 |
Text, 25 |
See Below |
Describes the secondary
(not primary) type of material at each observation site. |
||
Bedrock |
Outcrop of bedrock or
presence of bedrock within drillhole. |
||||
Clay |
Clay is a very
fine-grained sediment that is less than.0.004 mm in size. |
||||
Clay Balls |
Spherical balls of clay
present within granular deposit, observed sizes less than 1 cm. |
||||
Loam |
Unsorted sediment
containing a combination of one or more of the following: silt, clay, sand,
and/or rocks. |
||||
Organic top soil |
Well-developed soil horizon,
including O and A horizons. |
||||
Organics |
Developed P soil
horizon, indicating organic material and a high water table. |
||||
Sand |
Sand is composed of
rocks and minerals that range in diameter from 0.0625 to 2 mm. |
||||
Sand and Gravel |
Sediment that contains
a mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains greater than 15% by volume gravel. |
||||
Sand minor Gravel |
Sediment that contains a
mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains approximately less than 7% by volume gravel. |
||||
Sand with Gravel |
Sediment that contains a
mixture of rocks in varying sizes ranging from 0.0625 to 64 mm. This description is given to sediment that
contains less than 15% by volume gravel. |
||||
Silt |
A fine grained sediment
that has a diameter between 0.004 to 0.0625 mm. |
||||
Till |
A term used to describe
the unsorted sediment deposited by glaciers- contains a mixture of clay,
silt, sand, gravel and boulders. Within Carlton County and Fond du Lac
Reservation almost all till is sourced from the Superior Basin or intermixed
with it. This till typically consists of red-brown, loam with varying clay
and sand content containing rhyolites, basalts, and
other North Shore Minnesota rock types. |
||||
FIELDDESC |
Text, 100 |
Ex: Drill Hole (0-9 ft)
0-6 Till, 6-9 Gravel. |
A short field description
of the observation site. |
||
THICKNESS |
Text, 15, 0 |
+7, 5-15, Not Available |
A description of
thickness of the geological unit. Not Available indicates that the
measurement does not apply or was not observed. |
||
THICK_MOD |
|
Text, 1 |
See Below |
Modifies the thick_min or thick_max (i.e.,
Thickness field). |
|
+ |
Greater Than |
||||
- |
To, as in 10-20 |
||||
THICK_MIN |
Number, 19, 5 |
Ex: 2, 6, 50, -999 |
The minimum thickness
of the observed unit (–999 value is null). |
||
THICK_MAX |
Number, 19, 5 |
Ex: 20, 50, -999 |
The maximum thickness
of the observed unit (–999 value is null). |
||
OVERBURDEN |
Text, 15, 0 |
5-15, +5, ~10, Not
Available |
A description of the
overburden covering an aggregate unit.
Not Available indicates that the measurement does not apply or was not
observed. |
||
OVER_MOD |
Text, 1 |
See Below |
Modifies the Ob_min or Ob_max (i.e.,
Thickness field). |
||
+ |
Greater Than |
||||
- |
To, as in 10-20 |
||||
~ |
Approximately |
||||
OVER_MIN |
Number, 19, 5 |
Ex: 2, 9, 35, -999 |
A description of the
minimum thickness of the overburden covering the unit (–999 value is null). |
||
OVER_MAX |
Number, 19, 5 |
Ex: 3, 5, 10, -999 |
A description of the
maximum thickness of the overburden covering the unit (–999 value is null). |
||
SAMPLED |
Text, 3 |
Yes or No |
Indicates whether the
material was sampled. Not all sampled
material was tested. |
||
GRAVEL_PCT |
Number, 19, 5 |
Ex. 44 |
Percent gravel
retrieved from the sieve analysis on sampled units (–999 value
is null). |