Geotechnical Combined Results

Report Name: Geotechnical Combined Results

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

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Software: EQuIS Professional, EQuIS Enterprise, and EnviroInsite

Source: EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: Report Grid1

Description: The Geotechnical Combined Results report compiles results from multiple geotechnical tests linked to a sample. The report returns information from the DT_SAMPLE, DT_GEO_STANDARD_PENETRATION, DT_GEO_CORING, DT_GEO_TEST, and DT_GEO_RESULT tables based on the available data in the facility.

Each data point in the report is tied to a single depth value from the sample, not an interval. Using the Return Depth report parameter, users can choose how this depth is calculated:

•Start Depth - Uses the beginning of the sample interval.

•Midpoint - Calculates the midpoint between start and end depths.

•End Depth - Uses the end of the sample interval.

This report can be run in EQuIS Professional or published to EQuIS Enterprise.

Note: A user report version of this report can also be used in EnviroInsite through the Reports tab, in the Boring Log Template Design Window, to visualize geotechnical data in either string or chart formats.

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Combined Results report (EarthSoft.Reports.Library.d45594.dll) is available for download in the Products\EQuIS Geotech folder on the Downloads Dashboard on the EarthSoft Community Center. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Tables: DT_TASK, DT_LOCATION, DT_SAMPLE, DT_GEO_STANDARD_PENETRATION, DT_GEO_CORING, DT_GEO_RESULT, DT_GEO_TEST

Report Parameters

FACILITY_ID	Hidden. Login facility or facility group.
Location
Individual(s)	Parameter for selecting individual locations, mapped to DT_LOCATION.SYS_LOC_CODE.
Group(s)	Parameter for selecting location groups, mapped to RT_GROUP.GROUP_CODE.
Return Depth	Parameter for selecting one of the following depth values to be associated with the data point in the report.
Start (default)	- Select this depth value to use the beginning depth of the sample interval.
Midpoint	- Select this depth value to use the midpoint (between the start and end depths) value of the sample interval.
End	- Select this depth value to use the end depth of the sample interval.

Report Output: FACILITY_ID, SYS_LOC_CODE, DEPTH, DEPTH_UNIT, WATER_CONTENT, PERCENT_FINES, IL, PL, PI, STRENGTH, UNDERDRAIN_SHEAR_STRENGTH, N_VALUE, N60_VALUE, RECOVERY_PERCENT

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

Notes:

•Start and end depth in the database are assumed to be the same across the different tables. Mismatched start and end depths may result in incomplete output.

•Records in DT_SAMPLE that do not have data returned by the report will be excluded from the report.