WQX: Activity Report

Report Name: WQX: Activity

File Name: schema.WQX.xme

Dependencies: EQuIS WQX Schema

Software: EQuIS Professional and EQuIS Enterprise

Source: Available in the EQuIS WQX package (EQEDD_WQX_FormatPackage.zip) on the EarthSoft Community Center downloads dashboard from the All Items > Formats folder for users who have Download access.

Language: English

Output Type: Report Grid1

Description: The Water Quality eXchange (WQX) is a standardized data framework and submission mechanism for sharing water quality data that is administered by the United States Environmental Protection Agency (USEPA). The fields in the output of the WQX: Activity report gives a summary of a sampling activity.

See the EQuIS WQX Package Overview for more information on WQX, related terminology, and anticipated workflow for using EQuIS to submit data to WQX.

Installation Instructions: This report is automatically created when the EQuIS WQX Schema is applied to the EQuIS database. The EQuIS WQX Schema available as part of a format package (EQEDD_WQX_FormatPackage.zip). See the WQX Package Installation and Configuration article for more details.

Notes:

•The EQuIS WQX Schema (schema.WQX.xme) is not included with the standard EQuIS installation and must be manually applied. See Apply Additional Modules/Schemas to a Database for additional information.  

•A Premium Enterprise license is required to apply the EQuIS WQX Schema to an EQuIS Enterprise site. See Applying Licenses in EQuIS Enterprise for additional information.

Overview: Many fields in the WQX.Activity views table are also present in the WQX: Activity report. This report automatically filters by ORIGID (facility where the report is being generated).

Tables: DT_BIOLOGICAL_SAMPLE, DT_COORDINATE, DT_FACILITY, DT_FIELD_SAMPLE, DT_SAMPLE, DT_TEST, RT_PREP_METHOD, RT_SAMPLE_METHOD

Report Parameters

Project
Identifier	Code used to identify the parent task under which the field sample was retrieved (aka DT_TASK.PARENT_TASK_CODE associated with DT_SAMPLE.TASK_CODE).
Monitoring Location
HUC (Eight Digit)	Parameter for the 8-digit Hydraulic Unit Code (LOC_MAJOR_BASIN).
HUC (Eight Digit)
HUC (Twelve Digit)	Parameter for the 12-digit Hydraulic Unit Code (LOC_MINOR_BASIN).
State	The monitoring location’s state code (LOC_STATE_CODE).
State
County	The monitoring location’s county code (LOC_COUNTY_CODE).
Identifier	Name of the monitoring location (SYS_LOC_CODE).
Activity
Type	Parameter for the WQX activity type (SAMPLE_TYPE_CODE).
Media	Parameter for the WQX activity media (MEDIUM_CODE).
Media
Subdivision	Parameter for the WQX activity media subdivision (MATRIX_CODE).
Biological
Assemblage	Parameter for the WQX activity assemblage (ASSEMBLAGE).
Date Range
Start	Start date of the WQX activity.
End	End date of the WQX activity.

Report Output
ASSEMBLAGE BOAT_SPEED BOAT_SPPED_UNIT COMPONENT_NAME COMPONENT_SEQUENCE CONTAINER_COLOR CONTAINER_TYPE CONTEXT COUNTYCODE CURRENT_SPEED CURRENT_SPEED_UNIT CUSTOM_FIELD_1 DATA_PROVIDER DEPTH_REFERENCE DEPTH_UNIT DURATION DURATION_UNIT END_DEPTH EQUIPMENT_DESC EQUIPMENT_TYPE FACILITY_CODE HORZ_ACCURACY_UNIT HORZ_ACCURACY_VALUE	HORZ_COLLECT_METHOD_CODE HORZ_DATUM_CODE HUCEIGHTDIGITCODE LATITUDEMEASURE LONGITUDEMEASURE MATRIX_CODE MEDIUM_CODE METHOD_DESC MONLOCDESC MONLOCNAME MONLOCTYPE NET_MESH_SIZE NET_MESH_SIZE_UNIT NET_SURFACE_AREA NET_SURFACE_AREA_UNIT NET_TYPE PASS_COUNT PREFERRED_NAME PRESERVATIVE PREP_METHOD PROJECTNAME REACH_LENGTH REACH_LENGTH_UNIT	REACH_WIDTH REACH_WIDTH_UNIT RELATIVE_DEPTH REMARK SAMPLE_DATE SAMPLE_DATE_TIMEZONE SAMPLE_END_DATE SAMPLE_ID SAMPLE_METHOD SAMPLE_TYPE_CODE SAMPLER SOURCE_SCALE START_DEPTH STATECODE SYS_LOC_CODE SYS_SAMPLE_CODE TASK_CODE TEMP_PRESERVE_TYPE TOXICITY_TYPE X_COORD Y_COORD

Report Output

ASSEMBLAGE

BOAT_SPEED

BOAT_SPPED_UNIT

COMPONENT_NAME

COMPONENT_SEQUENCE

CONTAINER_COLOR

CONTAINER_TYPE

CONTEXT

COUNTYCODE

CURRENT_SPEED

CURRENT_SPEED_UNIT

CUSTOM_FIELD_1

DATA_PROVIDER

DEPTH_REFERENCE

DEPTH_UNIT

DURATION

DURATION_UNIT

END_DEPTH

EQUIPMENT_DESC

EQUIPMENT_TYPE

FACILITY_CODE

HORZ_ACCURACY_UNIT

HORZ_ACCURACY_VALUE

HORZ_COLLECT_METHOD_CODE

HORZ_DATUM_CODE

HUCEIGHTDIGITCODE

LATITUDEMEASURE

LONGITUDEMEASURE

MATRIX_CODE

MEDIUM_CODE

METHOD_DESC

MONLOCDESC

MONLOCNAME

MONLOCTYPE

NET_MESH_SIZE

NET_MESH_SIZE_UNIT

NET_SURFACE_AREA

NET_SURFACE_AREA_UNIT

NET_TYPE

PASS_COUNT

PREFERRED_NAME

PRESERVATIVE

PREP_METHOD

PROJECTNAME

REACH_LENGTH

REACH_LENGTH_UNIT

REACH_WIDTH

REACH_WIDTH_UNIT

RELATIVE_DEPTH

REMARK

SAMPLE_DATE

SAMPLE_DATE_TIMEZONE

SAMPLE_END_DATE

SAMPLE_ID

SAMPLE_METHOD

SAMPLE_TYPE_CODE

SAMPLER

SOURCE_SCALE

START_DEPTH

STATECODE

SYS_LOC_CODE

SYS_SAMPLE_CODE

TASK_CODE

TEMP_PRESERVE_TYPE

TOXICITY_TYPE

X_COORD

Y_COORD

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.