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).
WQX Web Physical/Chemical Results Template (ZIP)(1 pg, 907 K)
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.
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.
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.
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.
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.
WQX Web Lab Results Template (ZIP)(1 pg, 367 K)
The Lab Template is provided to assist in formatting physical and chemical results.
WQX Web Continuous Monitoring Template version 2.01 (ZIP)(1 pg, 2 MB)
Our recommendation for continuous monitoring data is to report to STORET a single activity in which you record the summary statistics of the probe readings (Mean, Min, Max, etc.) and to which you attach a binary object in the form of the flat text ".txt" file typically 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 pycnoclie 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 STORET Warehouse 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.