Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

millobmodl.dbf

Modl_ID

 

Number, 4, 0

Ex: 25

Unique identifiers used in the database

 

Modl_Sourc

 

Text, 50

 

Specific source the data was gathered from.  See metadata for detail about each source. 

 

 

 

 

CWI-MGS Located

Well that contains bedrock or minima information located by the Minnesota Geological Survey (MGS)

 

 

 

 

CWI-DNR Located

Well that contains bedrock or minima information located approximately by the Minnesota Department of Natural Resources, Division of Lands and Minerals (See Metadata for Specific Locating Methodology)

 

 

 

 

Field Observation

MN DNR observed granite bedrock outcrops

 

 

 

 

Drilling-MGS

Drill holed by MGS that encountered bedrock

 

 

 

 

Drilling-Explorer

MN DNR Exploratory drill hole that encountered bedrock

 

 

 

 

MGS Outcrop

MGS observed bedrock outcrop

 

 

 

 

USDA/NRCS - Outcrop

Soil Survey observed bedrock outcrop

 

Surf_Elev

 

Number, 4, 0

Ex. 1250

Surface elevation (feet) of data point, calculated from 30 Meter DEM or extracted from CWI data if available

 

Overburden

 

Number, 4, 0

Ex. 100

The data point’s depth to (In Feet) hard bedrock or minima interpreted from the CWI stratigraphy table or from the MGS and Exploratory drilling database.  Outcrop points values equal ‘0’. 

 

Modl_Elev

 

Number, 4, 0

Ex. 1150

The model’s hard bedrock and minima elevations (Surf_Elev – Overburden)

 

Geo_Desc

 

Text, 75

Ex. Granite – Dk. Gray/Hard

A geologic description of bedrock and minima data taken directly from CWI stratigraphy (i.e., Material – Color/Hardness).  If source of point was an outcrop, the description further defines the source. 

 

Bdrk_Conf

 

Text, 3

Ex. Yes/No

A yes/no record answering the question, did the well drilled hit hard bedrock.  

 

Confidence

 

Text, 10

 

Confidence class (high, moderate, low) of data point accuracy related to actual location.   

 

 

 

 

High

It is probable that the point location is within 0-5 acres of actual location.

 

 

 

 

Moderate

It is probable that the point location is within 0-40 acres of actual location

 

 

 

 

Low

It is probable that the point location is within 0-160 acres of actual location

 

Relateid

 

Text, 10

Ex. 0000645232, Not CWI

These are the unique identifiers for the CWI wells (Relate item with millcwistrat.dbf).  An overburden point with ‘Not CWI’ can not be used to relate to millcwistrat.dbf