An official website of the United States government.

This is not the current EPA website. To navigate to the current EPA website, please go to www.epa.gov. This website is historical material reflecting the EPA website as it existed on January 19, 2021. This website is no longer updated and links to external websites and some internal pages may not work. More information »

WATERS Program Data

GIS from the Reach Address Database (RAD) must be joined/linked to corresponding program attributes using the below "Relational Key" information. The relational key for the RAD features is either source_featureid alone or a combination of source_originator, source_featureid and start_date/cycle_year.

Example of how to Join Reach Address Database GIS Datafiles and Attribute Table Data

To join 303(d) program attribute information to the Listed As Impaired Waters events

  1. Download the Listed Impaired Waters event GIS datafile for a given state from the RAD download page.
  2. Download the corresponding Listed Impaired Waters (303(d)) attribute information from the WATERS Expert Query Tool in either a comma separated file (.CSV) or a tab delimited file (.TAB).
  3. Take both the event shapefile and the attribute database file into a GIS software package such as ArcGIS Desktop, and link the attribute information to the GIS datafile using the LIST_ID field (see "Relational Keys" field in the table below for the correct field to use for other programs) in the attribute information table and the source_featureid field in the GIS datafile.
Water Program Water Program Database Relational Keys (RAD -> Program) Download Data Attributes
303(d) Listed Impaired Waters Water Quality Assessment and Total Maximum Daily Loads Information (ATTAINS) source_featureid -> LISTED_WATER_ID Use our Expert Query tool.
source_featureid -> LISTED_WATER_ID
cycle_year -> CYCLE
Use our Expert Query tool.
305(b) Assessed Waters Water Quality Assessment and Total Maximum Daily Loads Information (ATTAINS) source_featureid -> ASSESSMENT_UNIT_ID Use our Expert Query tool.
source_featureid -> ASSESSMENT_UNIT_ID
cycle_year -> CYCLE
Use our Expert Query tool.
Impaired Waters with TMDLs Water Quality Assessment and Total Maximum Daily Loads Information (ATTAINS) source_featureid -> TMDL_ID Use our Expert Query tool.
STORET Water Monitoring Locations STORET/WQX source_originator -> ORGANIZATIONIDENTIFIER
source_featureid -> MONITORINGLOCATIONIDENTIFIER
STORET/WQX Web Services
Fish Consumption Advisories National Listing of Fish and Wildlife Advisories (NLFWA) For Fish Consumption Advisories: source_featureid -> ADVNUM (Advisory Number) in the NLFWA_ADVISORY table

Note: The NLFWA_ADVISORY table is linked to the NLFWA_DETAILS table, which provides much of the information on fish advisories such as species, human population, size, and meal advice.
For batch downloads, contact the National Listing of Fish Advisories with your request.
Facilities that Discharge to Water ICIS National Pollutant Discharge Elimination System (ICIS-NPDES) For Facilities: source_featureid -> NPDES ID EPA Enforcement & Compliance History Online (ECHO)
For Pipe Schedules (concatenated relational key):
source_featureid -> NPDES ID + PERM_FEATURE_NMBR
Nonpoint Source Projects Grants Reporting and Tracking System (GRTS) source_featureid -> PRJDRAR_SEQ (Unique ID for 319 project area) Grants Reporting and Tracking System (GRTS)
Beaches BEACH Program source_featureid -> BEACH_ID Use the Beach Season Data downloads.