Data Management Reference Guide

2019 Surface Water Quality Monitoring Data Management Reference Guide

The purpose of the DMRG is to assist TCEQ staff as well as any external data providers submitting data to the Surface Water Quality Monitoring Information System (SWQMIS). The guide outlines the processes for requesting new monitoring codes or data reports; explains data review, qualification, reporting, and data corrections; and includes reference maps, tables, and descriptions.

Chapter 1 – Introduction to the SWQM Data Management Reference Guide

Why the DMRG was created and an introduction to its contents.

Chapter 2 – Parameter and Constituent Code Requests

Requesting Parameter and Constituent Codes be added to SWQMIS.

Chapter 3 – SWQM Station Location (SLOC) Request

Requesting a new location for Surface Water Quality data collection.

Chapter 4 – Submitting Entity and Collecting Entity Codes

A list of Existing collecting entities for TCEQ and their respective codes.

Chapter 5 – Tag Prefixes

A List of Tag Prefixes and their associated Submitting Entity Codes.

Chapter 6 – Commonly Used Parameter Codes

A list of commonly used parameters for Surface Water Quality monitoring and their associated SWQMIS parameter codes.

Chapter 7 – Data Reporting

Reporting Surface Water Quality data to TCEQ.

Chapter 8 – Data Review

The data review process and who is responsible for each part.

Chapter 9 – Data Corrections

Submitting data corrections to the TCEQ.

Chapter 10 – Data Qualification

Quality control and qualifying data.

Chapter 11 – Database Reports

Extracting data from the Surface Water Quality Monitoring Information System.

Chapter 12 – Biological Data Recording and Reporting

Reporting Biological Surface Water Quality Data to TCEQ.

Chapter 13 – Monitoring Type Codes

Surface Water Quality Monitoring Types and their associated codes.

Chapter 14 – Request for Analysis Form

Requesting lab analysis of a sample.

Appendix A – Maps

Maps of Texas depicting TCEQ Regions, Ecoregions, and River and Coastal Basins of Texas

Appendix B – EPA Stream Station Types

EPA stream station type codes and definitions.

Appendix C – Fish Tissue Data Reporting Guidance

Guidance for reporting fish tissue data to TCEQ.

Appendix D – Geographic Information Codes

SWQMIS Geographic Information Codes for Station Location Requests and their definitions.

Appendix E – Data Qualifiers

Quality Control related codes for Surface Water Quality Monitoring and their definitions.

DMRG – References

References used in the Data Management Reference Guide.