Hydraulic Containment

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Water Level Reports >

Hydraulic Containment

Report Name: Hydraulic Containment (example1) (example2) (example3:kmz)

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

Dependencies: EarthSoft.Reports.Library.64102.dll

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1 or Keyhole Markup Language (*.kmz)2,3,4

 

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.

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary. For Enterprise use, 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).

 

Overview:

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. 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.

 

Notes:

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.

 

Data Mappings - Common to Both Report Output Types

 

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

 

Data Mappings of Non-Tile Invert Level Report (Default)

 

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.

 

Data Mappings of Tile Invert Level Report

 

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.

 

 

Tables: DT_WATER_LEVEL, DT_WELL, RT_ANALYTE_DETAIL, DT_LOCATION, RT_GROUP, RT_GROUP_MEMBER, VW_LOCATION, DT_WELL_SEGMENT

 

Report Parameters

Location


Group(s)

Parameter for selecting location groups.

Water Level


Date Range

Section to select the water levels start date, and end date.

Task(s)

Select one or more tasks

Reported Value

Parameter for selecting which water levels are reported: calculate, corrected_elevation, water_level_elev

Calculation

This section is available when selecting calculate in reported value.

Elevation

Elevation parameter used for calculated water levels: historical_reference_elev, measure_datum, surf_elev, or top_casing_elev

Depth

Depth parameter used for calculated water levels: calculate, corrected_depth, or water_level_depth

Reportable

Parameter selection for reportable results.

Compare to Tile Invert Level

Checkbox to compare to tile invert level. Default: False

Output File Type

Parameter for output file type: Excel, Google Earth

Minimus radius of circles

Input for minimum radius of circles. Default: 6

Maximum radius of circles

Input for maximum radius of circles. Default: 20

* This report includes hidden parameter: Label Font Size

 

1Excel report output requires a valid license of Microsoft Excel to view the output.

2Using Google Earth for commercial purposes requires a commercial license from Google which must be obtained separately by the end user.

3EQuIS Google Earth reports do not require Google Earth or Google Services to generate KML files. Charts may be generated by Google Charts.

4KML is an open standard that may be read or viewed in other applications. These reports have only been tested in Googl Earth.