<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > GWSDAT (Groundwater Spatiotemporal Data Analysis Tool)

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

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

Dependencies: EarthSoft.Reports.Library.44408.dll, EarthSoft.Reports.Library.50943.dll, and EarthSoft.Reports.Library.64102.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.

 

 

 

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.

 

 

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.

GW = water_level of the 'Analytical and Water Results' or 'Water Level II' report.

NAPL = lnapl_thickness of the 'Analytical and Water Results' or 'Water Level II' report.

The unit of GW or NAPL = report_result_unit of the 'Analytical and Water Results' report or depth_unit of the 'Water Level II' report.

•If the unit is any of the following, it is remapped to "metres":

om

om.

ometre

ometers

ometer

•If the unit is any of the following, it is remapped to "feet":

oft

oft.

ofoot

 

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:

 

Report parameters are from Analytical and Water Results except for the below customizations:

 

'Water Level\Reported Value' defaults to 'calculate'

'Water Level\Calculation\Depth defaults to 'calculate'

'Custom Template' parameter: Select a custom template file from DT_FILE where PLACE_TYPE = 'GWSDAT' and FILE_TYPE = '.xlsx'. Note the 1-9 rows of the template are allowed to be customized over the custom template.

 

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

 

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