View Name: VW_LITHOLOGY
View Type: Standard
Description: VW_LITHOLOGY combines lithology data from several tables to provide a summary view of lithology information.
Language: English
Output Columns:
SEGMENT = DT_LITHOLOGY.SYS_LOC_CODE "-" DT_LITHOLOGY.START_DEPTH "-" DT_LITHOLOGY.FACILITY_ID
X_COORD = VW_LOCATION.X_COORD
Y_COORD = VW_LOCATION.Y_COORD
SURF_ELEV = VW_LOCATION.SURF_ELEV
START_ELEV = VW_LOCATION.SURF_ELEV - (DT_LITHOLOGY.START_DEPTH converted to VW_LITHOLOGY.ELEV_UNIT)
END_ELEV = VW_LOCATION.SURF_ELEV - (DT_LITHOLOGY.END_DEPTH converted to VW_LITHOLOGY.ELEV_UNIT)
ELEV_UNIT = VW_LOCATION.ELEV_UNIT or DT_LOCATION.UNITS, the first non-null value will be used
FACILITY_ID = DT_LITHOLOGY.FACILITY_ID = VW_LOCATION.FACILITY_ID = DT_LOCATION.FACILITY_ID
SYS_LOC_CODE = DT_LITHOLOGY.SYS_LOC_CODE = VW_LOCATION.SYS_LOC_CODE = DT_LOCATION.SYS_LOC_CODE
BEARING = DT_LITHOLOGY.BEARING
PLUNGE = DT_LITHOLOGY.PLUNGE
START_DEPTH = DT_LITHOLOGY.START_DEPTH
MATERIAL_NAME = DT_LITHOLOGY.MATERIAL_NAME, required for associated rows to be populated in VW_LITHOLOGY
GEO_UNIT_CODE_1 = DT_LITHOLOGY.GEO_UNIT_CODE_1
GEO_UNIT_CODE_2 = DT_LITHOLOGY.GEO_UNIT_CODE_2
GEO_UNIT_CODE_3 = DT_LITHOLOGY.GEO_UNIT_CODE_3
GEO_UNIT_CODE_4 = DT_LITHOLOGY.GEO_UNIT_CODE_4
GEO_UNIT_CODE_5 = DT_LITHOLOGY.GEO_UNIT_CODE_5
REMARK_1 = DT_LITHOLOGY.REMARK_1
REMARK_2 = DT_LITHOLOGY.REMARK_2
MOISTURE = DT_LITHOLOGY.MOISTURE
PERMEABLE = DT_LITHOLOGY.PERMEABLE
CONSOLIDATED_YN = DT_LITHOLOGY.CONSOLIDATED_YN
COLOR = DT_LITHOLOGY.COLOR
OBSERVATION = DT_LITHOLOGY.OBSERVATION
CONSISTENCY = DT_LITHOLOGY.CONSISTENCY
SORTING = DT_LITHOLOGY.SORTING
ANGULARITY = DT_LITHOLOGY.ANGULARITY
CEMENTATION = DT_LITHOLOGY.CEMENTATION
GRAINSIZE = DT_LITHOLOGY.GRAINSIZE
ODOR = DT_LITHOLOGY.ODOR
CUSTOM_FIELD_1 = DT_LITHOLOGY.CUSTOM_FIELD_1
CUSTOM_FIELD_2 = DT_LITHOLOGY.CUSTOM_FIELD_2
CUSTOM_FIELD_3 = DT_LITHOLOGY.CUSTOM_FIELD_3
CUSTOM_FIELD_4 = DT_LITHOLOGY.CUSTOM_FIELD_4
CUSTOM_FIELD_5 = DT_LITHOLOGY.CUSTOM_FIELD_5
EBATCH = DT_LITHOLOGY.EBATCH
END_DEPTH = DT_LITHOLOGY.END_DEPTH
Tables: DT_LITHOLOGY, DT_LOCATION, VW_LOCATION
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 6.0+
Data Requirements: Since this view is largely based on VW_LOCATION, please see the VW_LOCATION data requirements and troubleshooting documentation here.
Output Type: Grid
Example Output: View the following example or download the attachment.
