Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
Report Name: Hydraulic Containment (126862)
Report Type: Standard
Description: This report produces a table in Excel or a map in Google Earth showing the Gradient Reversal, which is determined by comparing measured water levels in primary wells to measured water levels in secondary wells, where the water level samples are taken on the same day.
The Gradient Reversal is calculated with the logic below, where P represents the primary location and S represents the secondary. The remark input (RT_GROUP_MEMBER.REMARK) is an optional predefined adjustment value, which can be used to reduce the actual gradient reversal value. This allows for flagging gradients before they reach a minimal point of concern. If the adjustment (remark) of the comparison is not needed, do not populate RT_GROUP_MEMBER.REMARK with any non-zero numeric value. Also see the output mapping section, which is under the Data Mappings of Tile Invert Level Report heading in this article.
1.When P is dry and its max of DT_WELL_SEGMENT.END_DEPTH with segment_type=SCREEN is measured, Gradient Reversal = S's water level elevation – (P's Top of Casing - P's max end_depth) – remark.
2.When P is dry and its measured_depth_of_well is measured, Gradient Reversal = S's water level elevation – (P's Top of Casing - P's measured_depth_of_well) – remark.
3.Otherwise, when P is wet, Gradient Reversal = S's water level elevation – P's water level elevation – remark.
•This report requires the EQuIS Water Levels II Report (EarthSoft.Reports.Library.64102.dll), which is used as a basis to retrieve source data.
•The remark is a predefined adjustment to the calculation as explained in number three above.
•The samples of S and P locations in the equations are taken on the same day.
By default, comparison wells are related by creating a location group of GROUP_TYPE = hydraulic_containment, with group members assigned MEMBER_TYPE = hydraulic_containment. Optionally, users may update the report to enable using the standard EQuIS location groups (publish the report and change the hydraulic_containment to SYS_LOC_CODE in the datasource of the location groups parameter).
The Primary Well is denoted by RT_GROUP_MEMBER.REPORT_ORDER =1. The secondary wells used for comparison are included in the same group with RT_GROUP_MEMBER.REPORT_ORDER <>1.
The report converts units where possible. The target output unit is from DT_FACILITY.ELEV_UNIT, DT_WELL.DEPTH_UNIT, DT_WATER_LEVEL.DEPTH_UNIT in order (first unit populated is used). The input units are as follows.
•Static Water Level (water_level_depth) from DT_WATER_LEVEL.DEPTH_UNIT, DT_WELL.DEPTH_UNIT, DT_FACILITY.ELEV_UNIT
•Top of Casing (DT_MEASURE_DATUM.DATUM_VALUE) from DT_MEASURE_DATUM.DATUM_UNIT
•For non-TileInvert results, DT_WELL_SEGMENT.END_DEPTH from DT_WELL_SEGMENT.DEPTH_UNIT, DT_WELL.DEPTH_UNIT, DT_FACILITY.ELEV_UNIT
•For TileInvert results, tile_invert (DT_LOCATION_PARAMETER.PARAM_VALUE) from
DT_LOCATION_PARAMETER.PARAM_UNIT, DT_WATER_LEVEL.DEPTH_UNIT, DT_WELL.DEPTH_UNIT, DT_FACILITY.ELEV_UNIT in order.
The DT_MEASURE_DATUM.DATUM_UNIT for “Top of Casing” output cannot be dynamic. This is because Top of Casing is calculated from the equis.measure_datum() function, which does not have any dynamic unit conversion processing.
The RT_GROUP_MEMBER.REMARK, which is used to calculate "Gradient Reversal" (as noted above) must have the unit used by the report output, because the report does not convert remark values.
The report can generate two types of results: Non-Tile Invert Level, and Tile Invert Level (by unchecking or checking the box of the “Compare to Tile Invert Level” parameter). Their data mappings are listed in the following.
Output columns for main columns (with and without Tile Invert option) mapped to database:
1.Location = SYS_LOC_CODE
2.Date = DT_WATER_LEVEL.MEASUREMENT_DATE
3.Static Water Level = DT_WATER_LEVEL.WATER_LEVEL_DEPTH
4.Top of Casing = DT_MEASURE_DATUM.DATUM_VALUE
5.USGS Groundwater Elevation = calculated WATER_LEVEL_ELEV = WATER_LEVEL of EQuIS Water Levels II Report
6.Comments = 'DRY' when DT_WATER_LEVEL.DRY_INDICATOR_YN=Y, otherwise = DT_WATER_LEVEL.REMARK
1.Cluster = RT_GROUP.GROUP_CODE, followed by GROUP.GROUP_DESC. Note if GROUP_DESC is not populated, the GROUP_CODE will display as DESC also.
2.Prime Location = P where RT_GROUP_MEMBER.DISPLAY_ORDER = 1 for the associated location.
3.Gradient Reversal = calculated as with the following logic, where P = primary location and S = secondary location.
When P is dry (DT_WATER_LEVEL.DRY_INDICATOR_YN=Y) and its max of DT_WELL_SEGMENT.END_DEPTH with segment_type=SCREEN is measured:
WATER_LEVEL_ELEV for S - (DT_MEASURE_DATUM.DATUM_VALUE for P - max of DT_WELL_SEGMENT.END_DEPTH for P) - RT_GROUP_MEMBER.REMARK for S
If not 1, and P is dry and its measured_depth_of_well is measured:
WATER_LEVEL_ELEV for S - (DT_MEASURE_DATUM.DATUM_VALUE for P - DT_WATER_LEVEL.measured_depth_of_well for P) - RT_GROUP_MEMBER.REMARK for S
When p is wet:
WATER_LEVEL_ELEV for S – WATER_LEVEL_ELEV for P - RT_GROUP_MEMBER.REMARK for S
The Gradient Reversal may be negative or zero.
•For KML output, it is used to draw a circle in a Google Earth Map where the radius (in linear-scaled feet) of each circle = absolute of Gradient Reversal * slope + intercept. If the value is negative, the color of a circle is red to represent poor containment. Otherwise, a positive value makes a green circle for good containment.
•For Excel output, Gradient Reversals of <=0 are highlighted with red and equal 0.
When the report produces a tabular table, there is an option to generate a Tile Invert Level Report by selecting the "Compare to Tile Invert Level" parameter.
Output mappings specific to the Tile Invert Level Report:
1.Tile Invert = DT_LOCATION_PARAMETER.PARAM_VALUE where:
DT_LOCATION_PARAMETER.PARAM_CODE = 'tile_invert' and
DT_LOCATION_PARAMETER.SYS_LOC_CODE = DT_WATER_LEVEL.SYS_LOC_CODE and
DT_LOCATION_PARAMETER.MEASUREMENT_DATE matches the closest subsequent DT_WATER_LEVEL.MEASUREMENT_DATE
2.Water Over Tile Invert = DT.WATER_LEVEL.WATER_LEVEL_ELEV - Tile Invert.
Report Dependencies: EarthSoft.Reports.Library.64102.dll
File Name: EarthSoft.Reports.Library.126862.dll
Note for Enterprise Use: Since this report depends on the Water Levels II Report, enabling it in Enterprise requires storing both the EarthSoft.Reports.Library.64102.dll and EarthSoft.Reports.Library.126862.dll in the Enterprise bin folder (typically at C:\Program Files\EarthSoft\Enterprise\bin).
User reports will save Outupt File Type, so if a user report is run in Enterprise, it will only download the file type that is selected in the Output File Type parameter.
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
Note: *refers to hidden parameters; Label Font Size applies to KML output only; others are from the EQuIS Water Level (Extra Fields) Report.
Tables: DT_WATER_LEVEL, DT_WELL, RT_ANALYTE_DETAIL, DT_LOCATION, RT_GROUP, RT_GROUP_MEMBER, VW_LOCATION, DT_WELL_SEGMENT
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 7
Data Requirements: N/A
Report Requirements: Excel or Google Earth
Output Type: Excel or KMZ (zipped KML)
Example Output: View the following examples.
Excel Output when "Compare to Tile Invert Level" Parameter is Not Checked
Excel Output when "Compare to Tile Invert Level" Parameter is Checked