WQX: Monitoring Location Report

Report Name: WQX: Monitoring Location

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: Monitoring Location report gives the details of locations associated with 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.MONITORINGLOCATION views table are also present in the WQX: Monitoring Location report. This report automatically filters by ORIGID (facility where this report is being generated).

Tables: DT_COORDINATE, DT_FACILITY, DT_LOCATION, DT_LOCATION_VAR, DT_WELL, RT_COUNTY, RT_STATE

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

Report Output
CONTEXT COUNTY_CODE ELEV ELEV_COLLECT_METHOD_CODE ELEV_DATUM_CODE ELEV_UNIT FACILITY_CODE FACILITY_ID FIPS_CODE GEOLOGIC_UNIT_CODE GEOLOGIC_UNIT_TYPE	HORZ_ACCURACY_UNIT HORZ_ACCURACY_VALUE HORZ_COLLECT_METHOD_CODE HORZ_DATUM_CODE LATITUDE LOC_COUNTRY LOC_COUNTY_CODE LOC_DESC LOC_MAJOR_BASIN LOC_MINOR_BASIN LOC_NAME	LOC_STATE_CODE LOC_TYPE LOC_TYPE_2 LONGITUDE SOURCE_SCALE STATE_CODE SYS_LOC_CODE SYS_LOC_CODE_VAR TOTAL_DEPTH TRIBAL_LAND_NAME TRIBAL_LAND_YN UNITS

Report Output

CONTEXT

COUNTY_CODE

ELEV

ELEV_COLLECT_METHOD_CODE

ELEV_DATUM_CODE

ELEV_UNIT

FACILITY_CODE

FACILITY_ID

FIPS_CODE

GEOLOGIC_UNIT_CODE

GEOLOGIC_UNIT_TYPE

HORZ_ACCURACY_UNIT

HORZ_ACCURACY_VALUE

HORZ_COLLECT_METHOD_CODE

HORZ_DATUM_CODE

LATITUDE

LOC_COUNTRY

LOC_COUNTY_CODE

LOC_DESC

LOC_MAJOR_BASIN

LOC_MINOR_BASIN

LOC_NAME

LOC_STATE_CODE

LOC_TYPE

LOC_TYPE_2

LONGITUDE

SOURCE_SCALE

STATE_CODE

SYS_LOC_CODE

SYS_LOC_CODE_VAR

TOTAL_DEPTH

TRIBAL_LAND_NAME

TRIBAL_LAND_YN

UNITS

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