Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our User Agreement and Privacy Policy.

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our Privacy Policy and User Agreement for details.

3.
WQX - Organizations
What are Organizations?
“The particular word(s) regularly connected with a unique framework of authority within
which a person or persons act, or are designated to act, towards some purpose.”
In other words, Organizations are the groups responsible for submission of WQX data to
EPA.
Where is this information stored in EQuIS?
The Organization information is mapped to DT_FACILITY.
Examples:
Example A: The client is submitting data to EPA for only one Organization and therefore,
there is only one EQuIS facility to store all water data for that Organization.
Example B: The client submits data to EPA from many Organizations, each organization is
stored in its own facility in EQuIS and facility groups are used to report across facilities.

4.
WQX - Projects
What are Projects?
“A designator used to uniquely identify a data collection project within a context of an
organization. Projects can have more than one sampling event over time. Some projects
have approved QAPPs.”
Where is this information stored in EQuIS?
Projects are stored in DT_TASK in EQuIS.
“Project A”

5.
WQX – Monitoring Locations
What are Monitoring Locations?
“A designator used to describe the unique name, number, or code assigned to identify the
monitoring location. Also referred to as stations, they carry the identification and
description of the physical location at which monitoring occurs.”
Where is this information stored in EQuIS?
Monitoring Locations are stored in DT_LOCATION. Station ID = SYS_LOCE_CODE
Examples:
Example A: The monitoring locations are Stations located throughout the facility and all are
uniquely identified.
Example B: Each Organization (Facility) contains many Stations (locations). Some of the
stations are used by another Organization and identified with a different Station ID. It is
important to know how the data will be queried/viewed for these locations so that the
facilities and location groups are setup properly.

6.
WQX – Activities
What are Activities?
“The WQX schema and STORET Warehouse use the term "Activity" to refer to any
individual action one does at a monitoring location to collect data. So, a series of field
measurements or a set of habitat observations are considered activities, along with a
collected water sample.”
Where is this information stored in EQuIS?
Activities are stored in DT_SAMPLE and DT_BIOLOGICAL_SAMPLE tables.

7.
WQX – Results
What are Results?
“This section describes the results of a field measurement, observation, or laboratory
analysis.”
Where is this information stored in EQuIS?
Results are stored in DT_RESULT and DT_BIOLOGICAL_RESULT. Characteristics in WQX are
mapped to analytes (identified by CAS_RN) in EQuIS.

8.
WQX – Binary Objects
What are Binary Objects?
Binary Objects can be documents or graphic objects. These are documents that can be
stored along with the WQX data, such as QAPP documents.
Where is this information stored in EQuIS?
Binary Objects are stored in DT_FILE

9.
Other sections in the WQX EDD
•Project Monitoring Location Weighting
•This section describes the probability weighting information for a given
Project / Monitoring Location Assignment.
•Biological Habitat Index
•Index used to assess the biological integrity of a habitat using samples of
living organisms .
•Activity Loc, Metric and Group
•Loc – This section allows for the geospatial description of actual
monitoring site, if it is different from that described in the formal station
description.
•Metric – Metrics are used to analyze and interpret biological data by
condensing lists of organisms into relevant biological information. An
example is the Benthic Index of Biotic Integrity (B-IBI).
www.epa.gov/volunteers/stream/108.html
•Group- The Activity Group section of the WQX schema allows users to
group together different monitoring activities for reasons such as QC
events, grouping results data from the lab with field measurements using
Field Sets, grouping samples as Replicates, or grouping parent samples
with subsamples.
•Result Detection Quantitation Limit
•Defines the quantitation limits used for the results. WQX has upper and
lower limits which can be used as well as various business rules related to
these limits.