RT_GEO_UNIT_TYPE

<< Click to Display Table of Contents >>

Navigation:  Professional > Tables & Views > Reference Value (RT) Tables >

RT_GEO_UNIT_TYPE

RT_GEO_UNIT_TYPE is the classification or category for the units in RT_GEO_UNIT. RT_GEO_UNIT_TYPE might be described as Generalized Hydrostratigraphy, Hydrostratigraphy, Geologic Epoch, Horizons, and MODFLOW Layers in the below example.

 

15627_GeoUnits

 

An example of Hydrostratigraphy and Soil Horizons in relevant fields of the populated RT_GEO_UNIT_TYPE, RT_GEOLOGIC_UNIT, and AT_GEO_UNIT tables are:

 

RT_GEO_UNIT_TYPE

geo_unit_type

geo_unit_type_desc

geo_unit_number

GEOLOGICUNIT1

Hydrostratigraphic unit

1

GEOLOGICUNIT2

Soil Horizons

2

RT_GEOLOGIC_UNIT

geologic_unit_code

geologic_unit_desc

MISSISSIPPIAN

Mississippian Aquifer

CLAY

Clay Confining Unit

FLORIDIAN

Floridian Aquifer

A

Horizon A

B

Horizon B

C

Horizon C

D

Horizon D

E

Horizon E

F

Horizon F

AT_GEO_UNIT

geologic_unit_code

geo_unit_type

MISSISSIPPIAN

GEOLOGICUNIT1

CLAY

GEOLOGICUNIT1

FLORIDIAN

GEOLOGICUNIT1

A

GEOLOGICUNIT2

B

GEOLOGICUNIT2

C

GEOLOGICUNIT2

D

GEOLOGICUNIT2

E

GEOLOGICUNIT2

F

GEOLOGICUNIT2

 

RT_GEO_UNIT_TYPE.GEO_UNIT_NUMBER field corresponds to the GEO_UNIT_CODE_1 through _5 fields in DT_LITHOLOGY, as shown here:

 

15128-geo_unit_code

 

For ease of use with third-party interfaces, renaming the RT_GEO_UNIT_TYPE.GEO_UNIT_TYPE fields (e.g. "GEOLOGICUNIT1") is not recommended. The GEO_UNIT_TYPE_DESC fields may be changed instead to add descriptions of each type as needed.

 

The DT_LITHOLOGY.GEO_UNIT_CODE fields are designed to store additional types of geologic data and are populated by RT_GEOLOGIC_UNIT. Several geology-based third-party interfaces, such as EQuIS for EVS and Rockworks make use of these additional layer types.