Groundwater Spatiotemporal Data Analysis Tool (GWSDAT)

Report Name: GWSDAT (Groundwater Spatiotemporal Data Analysis Tool) (example)

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

Dependencies: EarthSoft.Reports.Library.50943.dll

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: The Groundwater Spatiotemporal Data Analysis Tool (GWSDAT) Report generates Excel output in the Basic Example.xlsx template used by GWSDAT. For more information on the tool, see the GWSDAT Getting Started page.

The Enterprise EZView widget can display a button to export to GWSDAT online. For more information, see the GWSDAT Reports section of the Enterprise EZView help article.

Warning: While the standard GWSDAT online tool will not store the data transmitted by API, configuring EQuIS to link to a locally hosted version of the tool is recommended for confidential data. For information on deploying GWSDAT as an API, see the GWSDAT Github page.

The GWSDAT Report uses the EQuIS Analytical Results II Report to obtain the data. Data mapping between report results and EQuIS database tables or Analytical Results II report output is shown below.

Note: With the release of EQuIS 7.23.3, GWSDAT Report results without locations or coordinates are removed.

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

Overview:

This is a standard Report used with an EQuIS Plus Graphics License Library or higher. It is also available as the GWSDAT button of the Graphics tab in the Professional Interface.

Historical Monitoring Data Mapping:

WellName = DT_SAMPLE.SYS_LOC_CODE

Constituent = RT_ANALYTE.CHEMICAL_NAME

SampleDate = DT_SAMPLE.SAMPLE_DATE

Result = Analytical Results II output: report_result_value from

•DT_RESULT.REPORT_RESULT_TEXT (Build 7.22.1 and up).

•DT_RESULT.REPORT_RESULT_VALUE (prior to Build 7.22.1). Since REPORT_RESULT_VALUE is used, Non-Detects will not be displayed with the selection from the Non-Detect Symbol report parameter, such as the '<' less than symbol. Users may wish to use the Detect Flag report parameter to run exports with detect and non-detect values separately so that non-detect values can be differentiated and formatted appropriately.

Well Coordinates Mapping:

WellName = DT_SAMPLE.SYS_LOC_CODE

XCoord = DT_COORDINATE.X_COORD

YCoord = DT_COORDINATE.Y_COORD

CoordUnits = DT_FACILITY.COORD_UNIT

Aquifer = <null>

Tables: Tables used by Analytical Results II. Fields displayed in the report, as listed above, are from DT_COORDINATE, DT_FACILITY, DT_RESULT, DT_SAMPLE, and RT_ANALYTE.

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Use DT_GEOGRAPHY for coordinate data	Toggle to use DT_GEOGRAPHY for coordinate data.
Sample
Type(s)	Select one or more sample types.
Date Range	Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events.
Matrix(es)	Select one or more sample matrices.
Task(s)	Select one or more tasks.
Task_Code_2(s)
Field SDG(s)	Select one or more Field SDGs.
Depth	Section for selecting the minimum and maximum start and end depths as well as depth unit.
Minimum Start Depth	If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) above that value will be included. Sample with null START_DEPTH will be excluded.
Maximum End Depth	If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) below that value will be included. Sample with null END_DEPTH will be excluded.
Maximum Start Depth	If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) below that value will be included. Sample with null START_DEPTH will be excluded.
Minimum End Depth	If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) above that value will be included. Sample with null END_DEPTH will be excluded.
Unit	Select the desired unit for sample depth min/max.
DQM Status	Parameter for selecting DQM status.
Test
Method(s)	Select one or more test method.
Fraction(s)	Select one or more fraction.
Column Number(s)	Select one or more column number.
Type(s)	Select one or more test type.
Lab Matrix(es)	Select one or more lab matrixes.
Prep Method(s)	Select one or more prep methods.
Lab SDG(s)	Select one or more Lab SDGs.
Result
Analyte	Section for selecting analytes and/or analyte groups.
Unit	Selection for report result units.
Type(s)	Select one or more result type.
Detect Flag(s)	Select one or more options for detect flag.
Non-Detect Multiplier	Enter the desired non-detect multiplier value.
Non-Detect Symbol	Enter the desired non-detect symbol ("< ?", "ND", ...). A "?" will be replaced with reporting limit multiplied by non-detect multiplier.
Non-Detect Qualifier	Enter the desired non-detect qualifier (e.g., "U") to have that qualifier override the DETECT_FLAG column.
Reportable	Select one or more options for reportable result.
Validated	Selection for whether the result is validated or not.
Reporting Limit	Select which reporting limit to use (REPORTING_DETECTION_LIMIT, METHOD_DETECITON_LIMIT, etc.).
Format Results\Format Code:	Select one format code (e.g., 0.########, 0.0E-00 etc.) predefined or defined in RT_LOOKUP.LOOKUP_DESC with LOOKUP_TYPE = 'ARII_FORMAT'.
Additional Fields	Additional fields parameter.

* Only the fields listed above will appear in the GWSDAT export. Additional Fields parameter selections will not be reflected in this report.

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