An official website of the United States government.

We've made some changes to EPA.gov. If the information you are looking for is not here, you may be able to find it on the EPA Web Archive or the January 19, 2017 Web Snapshot.

Water Quality Exchange Web Template files

Note About Template Files

The templates are made up of two Microsoft Excel spreadsheet files that are meant to be used together to assist with data tracking and entry. The WQX Web Template Dictionary file provides guidance on the appropriate use of each data element, highlighting the data elements that are available in the WQX Web Template and showing the additional data elements that a user may add to the template. The dictionary covers data elements for all templates including:

  • Physical-Chemical Results
  • Biological Results
  • Habitat Results, Activity Metrics and Indices
  • Continuous Monitoring Results
  • Lab Results

Many of the templates contain sample data that can be imported into WQX Web using the following import configurations (for more information regarding how to use Import Configuration files in WQX Web, please see the WQX Web tutorials).

drawing of a ketone compound

WQX Web Physical/Chemical Results Template (ZIP)(1 pg, 920 K)

Import Configuration:

Import & Submit

Type of Data

.Training User Template Owner ~ WQX Web NEW Template REGULAR Results w/o Data Logger Line (Template) ~ 6600

Results & Activities

.Training User Template Owner ~ WQX Web NEW Template MONITORING LOCATIONs (Template) ~ 6334

Monitoring Locations

The Physical-Chemical Results Template is provided to assist in formatting the regular results data, such as physical and chemical results that have been sampled and analyzed.

WQX Web Template User Guide

This is a step by step guide to use the WQX Web Template for Physical/Chemical data. The document will assist in preparing data for import into the WQX Web tool, and subsequent transfer to the STORET Data Warehouse.

A Prerequisite to Importing & Submitting Activities and Results is #1 Import Projects, #2 Import Monitoring Locations (Stations).  Sample Collection Method and all user owned methods are edited and registered via WQX Web's "domains value menu."

Import Configuration: (common to all spreadsheet templates)

Import & Submit

Type of Data

.Training User Template Owner ~ WQX Web Template PROJECTs (Template) ~ 1005

Projects

.Training User Template Owner ~ Import MONITORING LOCATION (Template) ~ 1118

Monitoring Locations


microphoto of a diatom closterium dianae

WQX Web Biological Template (ZIP)(1 pg, 1 MB)

 

The Biological Template is provided to assist in formatting biological results.
*Note this template does not include the data elements for submitting biological metrics or indexes; these are handled using a separate WQX Web template file.

Import Configuration:

Element

Type of Data

.Training User Template Owner ~ WQX Web Template BIOLOGICAL Results (Template) ~ 1120

Results & Activities


Photo of a reference stream

WQX Web Habitat Template (ZIP)(1 pg, 465 K)

 

The Habitat Template is provided to assist in formatting habitat results.
*Note this template does not include the data elements for submitting metrics or habitat Indexes; these are handled using the WQX Web Metric-Index Template.

Import Configuration:

Element

Type of Data

.Training User Template Owner ~ WQX Web Template HABITAT Results (Template) ~ 3620

Results & Activities


Photo of Blue Heron

WQX Web Bio-Habitat Indices and Activity Metric Template (ZIP)(1 pg, 272 K)

The Metric- Index Template is provided to assist in formatting biological and habitat metrics and indices.

Import Configuration:

Element

Type of Data

.Training User Template Owner ~ WQX Web Template BioHabitat INDEX (Template) ~ 3294

Indexes

.Training User Template Owner ~ WQX Web Template METRIC Results (Template) ~ 3300

Metrics & Activities


drawing of a ketone compound

WQX Web Lab Results Template (ZIP)(1 pg, 367 K)

 

The Lab Template is provided to assist in formatting physical and chemical results.

Import Configuration:

Element

Type of Data

.Training User Template Owner ~ WQX Web Template CONTINUOUS Logger Results (Template) ~ 1848

Results & Activities


WQX Web Continuous Monitoring Template version 2.01 (ZIP)(1 pg, 2 MB)

Our recommendation for continuous monitoring data is to report to WQX a single activity in which you store the actual probe readings using every (4 hours, 2 hours or evenly distributed) intervals and to which you attach at the activity level a binary object formatted as text (".txt") file or compressed (".zip") file format for archiving the complete raw set of probe readings downloaded from the data logger.  This works equally well for the fixed data logger and for the so-called CTD cast, when the data logger is deployed off the side of a ship or pier and allowed to freely descend through the water column and report continuously the readings of its probes.

The CTD typically also yields results for thermocline, halocline and pycnocline depths, which can be added to the results associated with the activity. An additional comment could be included to indicate that this activity is a fixed data logger. The activity information and the "Document/Graphic" file will be available on the Water Quality Portal after export to EPA.

The Continuous Monitor Data Results Template is provided to assist in formatting the regular results obtained using a portable data logger, such as YSI probe.