Lithology Data

Report Name: Lithology Data (example)

File Name: EarthSoft.Reports.Library.d34009.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Lithology Data report compiles information from the DT_LITHOLOGY table and its associated DT_LITHOLOGY_COMPONENT table. This report includes, among other information, an overview of each lithology depth interval. This report can be used to review lithology data within a facility or across multiple facilities. The resulting summary may be helpful to users with EQuIS Geotech or producing lithology visuals in EnviroInsite (separate licensing applies).

Notes:

•Users will only be able to access facilities to which they have permission to view/edit.

•Only User Reports of the Lithology Data report can be loaded into the Data Grid widget.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

The depth values (START_DEPTH, END_DEPTH, and TOTAL_DEPTH) included in the output units are initialized in the following order:

•first from DT_LOCATION.UNITS,

•then from DT_COORDINATE.ELEV_UNIT, and

•finally from DT_FACILITY.ELEV_UNIT.

In instances where a particular unit is not available in the preceding order, the initialization proceeds to the next viable option in the sequence. In the final report output, the depths are converted from their initialized units to the selected unit from the Depth Unit report parameter. If the Depth Unit parameter is left empty, the final output converts the measured unit to either DT_FACILITY.ELEV_UNIT, DT_COORDINATE.ELEV_UNIT or DT_LOCATION.UNITS in that respective order.

For databases with EQuIS Geotech applied (includes Geotech Schema, Geotechnical_v2 format, and associated reference values), the lithology component codes in the summary can include:

USCS_SYMBOL	TOUGHNESS	ROCK_TYPE_ORIGIN
MATERIAL_TYPE	COLOR	ROCK_MODIFIER
FILL_YN	JOINING_WORD	ROCK_NAME
SPLITFILL_YN	ADDITIONAL_COLOR	ROCK_GRAIN_SIZE
MODIFIER	MUNSELL_COLOR	ROCK_CONTINUITY
MODIFYING_MATERIAL	MUNSELL_JOIN_WORD	ROCK_TEXTURE
PARTICLE_SIZE_RNGE_SAND	SECOND_MUNSELL_COL	ROCK_FRACTURE_SPACING
PARTICLE_SIZE_RNGE_GRVL	ODOR	ROCK_BEDDING_SPACING
ANGULARITY_SAND	MOISTURE	ROCK_JOINT_PLANE_SEPARATION
ANGULARITY_GRAVEL	CONSISTENCY	ROCK_JOINT_ORIENTATION
PARTICLE_SHAPE	RELATIVE_DENSITY	ROCK_WEATHERING
MAX_PARTICLE_SIZE	SOIL_STRUCTURE	ROCK_STRENGTH
HARDNESS	CEMENTATION	ROCK_INFILLING
PLASTICITY	OBSERVATION	ROCK_INFILL_MATERIAL
DRY_STRENGTH	STRATIGRAPHY_LAYER	ROCK_APERTURE
DILATANCY	GEOLOGIC_FORMATION

The LITHOLOGY_INTERVAL_SUMMARY field uses the COMPONENT_CODEs listed above to generate an interval summary. The interval summary is a concatenation of the values associated with the COMPONENT_CODEs listed above separated by commas. Conditional formatting logic is present for the following COMPONENT_CODEs: FILL_YN, MATERIAL_NAME, USCS_SYMBOL, MODIFIER_MODIFYING_MATERIAL, COLOR, JOINING_WORD, and ADDITIONAL_COLOR. The logic for these values is similar to that used in the EI_LITHOLOGY_DESCRIPTION function.

Note: The LITHOLOGY_INTERVAL_SUMMARY field does not include bold and underlined formatting in its output. If a database does not include the COMPONENT_CODEs listed above, then the LITHOLOGY_INTERVAL_SUMMARY field is empty in the output.

Tables: DT_FACILITY, DT_LOCATION, DT_COORDINATE, DT_LITHOLOGY, DT_LITHOLOGY_COMPONENT, RT_ LITHOLOGY_COMPONENT, RT_MATERIAL

Report Parameters

FACILITY_ID	Hidden. Login facility.
Facility/Individual(s)	Multi-select and defaults to the login facility. Select one or more DT_FACILITY.FACILITY_ID fields.
Facility/Group(s)	Multi-select and defaults to empty. Select one or more facility groups from RT_GROUP.GROUP_CODE, where FACILTY_ID < 0 and STATUS_FLAG = 'A'. Note: Report generates the results of the login facility if both Facility/Individual(s) and Group are not selected, or a warning message if no section facility is selected in Enterprise.
Material Name(s)	Multi-select and defaults to empty. Select one or more RT_MATERIAL.MATERIAL_NAME, which then filters the output to only display lithology records that include the selected MATERIAL_NAME(s).
Component Type(s)	REQUIRED, multi-select, and defaults to ‘Geotechnical’. Select one or more RT_LITHOLOGY_COMPONENT.COMPONENT_TYPE fields, which then filters DT_LITHOLOGY_COMPONENT. If ‘Geotechnical’ COMPONENT_TYPE is not present in database, user must select an alternative COMPONENT_TYPE. Note: This parameter does not impact the LITHOLOGY_INTERVAL_SUMMARY output, which is obtained with the ‘Geotechnical’ COMPONENT_TYPE.
Component Code(s)	Multi-select and defaults to empty. Select one or more RT_LITHOLOGY_COMPONENT.COMPONENT_CODE fields, which then filters DT_LITHOLOGY_COMPONENT.COMPONENT_CODE. Note: Report gets all of COMPONENT_CODEs filtered by the selected COMPONENT_TYPE parameter and uses them as default when the value of this parameter is empty.
Depth Unit	Single-select and defaults to empty. Converts the measured unit for START_DEPTH, END_DEPTH, and TOTAL_DEPTH into the selected unit in parameter. Options for parameter come from RT_UNIT, where RT_UNIT.UNIT_TYPE = 'length'.
Location/Coordinate Type Code	REQUIRED, single-select and defaults to LAT LONG. Options for parameter come from RT_COORD_TYPE.COORD_TYPE_CODE.
Location/Identifier	REQUIRED, single-select and defaults to PRIMARY.

Report Output	Data Mapping	Remark
FACILITY_ID	DT_FACILITY.FACILITY_ID
FACILITY_CODE	DT_FACILITY.FACILITY_CODE
FACILITY_NAME	DT_FACILITY.FACILITY_NAME
TASK_CODE	DT_TASK.TASK_CODE
FACILITY_LOCATION	DT_FACILITY.FACILITY_CODE, ‘_’, DT_LITHOLOGY.SYS_LOC_CODE	Concatenated FACILITY_CODE and SYS_LOC_CODE
SYS_LOC_CODE	DT_LITHOLOGY.SYS_LOC_CODE
START_DEPTH	DT_LITHOLOGY.START_DEPTH
END_DEPTH	DT_LITHOLOGY.END_DEPTH
TOTAL_DEPTH	DT_LOCATION.TOTAL_DEPTH
UNITS	Selected input Depth Unit, DT_FACILITY.ELEV_UNIT, DT_COORDINATE.ELEV_UNIT or DT_LOCATION.UNITS in order
MATERIAL_NAME	DT_LITHOLOGY.MATERIAL_NAME
COMPONENT_CODE(s)	DT_LITHOLOGY_COMPONENT.DESCRIPTION	Selected by the Component Type(s) and Component Code(s) parameters
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
X_COORD	DT_COORDINATE.X_COORD	Converted to decimal(19, 10)
Y_COORD	DT_COORDINATE.Y_COORD	Converted to decimal(19, 10)
LONGITUDE	DT_COORDINATE.X_COORD	Converted to float. If the value of the selected 'Location/Coordinate Type Code' parameter is of '%LAT%LONG%', X_COORD for LONGITUDE is determined by the selected 'Location/Coordinate Type Code' and Identifier parameters. Otherwise, it's determined by the PRIMARY identifier and the coord_type_code of Type '%LAT%LONG%'.
LATITUDE	DT_COORDINATE.Y_COORD	Converted to float. If the value of the selected 'Location/Coordinate Type Code' parameter is of '%LAT%LONG%', Y_COORD for LATITUDE is determined by the selected 'Location/Coordinate Type Code' and Identifier parameters. Otherwise, it's determined by the PRIMARY identifier and the coord_type_code of Type '%LAT%LONG%'.
LITHOLOGY_INTERVAL_SUMMARY	Multiple DT_LITHOLOGY_COMPONENT. COMPONENT_CODEs used in EQuIS Geotech

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.