EPA - WATERS Program Data

This site provides data downloads of attribute data contained in the following water program databases. Some program database attribute data comes from a static extract at a given point in time, while others directly access the relevant databases and return the most up-to-date publicly available information. In order for the data to be included in a given dataset, states and other jurisdictions must have submitted information to the program database.

The GIS datafiles, available for download from the RAD download page, show the spatial extent of the event hydrology. Attribute information available here must be joined/linked from the corresponding program attribute table to the GIS feature by the data elements provided in the "Relational Key" column below. The relational key for the Reach Address Database 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 tie 303(d) program attribute information to the Impaired Waters events, you would use the following steps. Download the Impaired Waters event GIS datafile for a given state from the RAD download page. Download the corresponding 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). Take both the event shapefile and the attribute database file into a GIS software package such as ArcGIS, 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.

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

To tie 303(d) program attribute information to the Impaired Waters events, you would use the following steps.

Download the Impaired Waters event GIS datafile for a given state from the RAD download page.
Download the corresponding 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).
Take both the event shapefile and the attribute database file into a GIS software package such as ArcGIS, 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.
303(d) Listed Impaired Waters		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.
305(b) Assessed Waters		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
Water Quality Standards	Water Quality Standards Database (WQSDB)	source_featureid -> WQS_ENTITY_ID	WQSDB Release 9.1 Download Files
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.
No-Discharge Zones for Vessel Sewage	No-Discharge Zones for Vessel Sewage	source_featureid -> ENTITYID	Coming Soon
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)
Facilities that Discharge to Water		For Pipe Schedules (concatenated relational key): source_featureid -> NPDES ID + PERM_FEATURE_NMBR	EPA Enforcement & Compliance History Online (ECHO)
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 PRAWN Database	source_featureid -> BEACH_ID	Use the Beach Season Data downloads.

Local Navigation