GWSDAT (Groundwater Spatio-Temporal Data Analysis Tool)

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports >

GWSDAT (Groundwater Spatio-Temporal Data Analysis Tool)

Report Name: GWSDAT (Groundwater Spatio-Temporal Data Analysis Tool) (example)

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: The Groundwater Spatio-Temporal Data Analysis Tool (GWSDAT) Report generates Excel output in the Basic Example.xlsx template used by the GWSDAT (See Groundwater Spatiotemporal Data Analysis Tool (GWSDAT), Vers. 2.1). It uses the EQuIS Analytical Results II Report (previously known as (Beta) Analytical Results Report) to obtain the data. Data mapping between report results and EQuIS Database tables or Analytical Results II 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 with an EQuIS Graphics License Library and the Ultimate License Library. It is also available as the GWSDAT tool or button of the Misc. Exports 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.RESULT_NUMERIC

Units = Analytical Results II output: report_result_unit from DT_RESULT.RESULT_UNIT

Flags = <null>

 

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:        The tables used by Analytical Results II

 

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 matrix

Task(s)

Select one or more tasks

Task_Code_2(s)


Field SDG(s)

Select one or more Field SDG

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", ...).  "?" 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 you desire 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'. It applies to REPORT_RESULT_TEXT, REPORT_RESULT_VALUE and REPORT_RESULT_LIMIT and defaults to empty with no formats applied.

Additional Fields

Additional fields parameter

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

 

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