Jump to main content.

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 shapefiles, available for download from the RAD IMS download page, show the spatial extent of the hydrology.  Attribute information available here must be joined/linked from the corresponding program attribute table to the shapefile by the data element provided in the "Relational Key" column below. The relational key for the shapefiles is source_featureid.
Example of how to Join Event Shapefiles and Attribute Table Data

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

  1. Download the Impaired Waters event shapefile for a given state from the RAD IMS download page.
  2. 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).
  3. Convert the .CSV or .TAB file to a database file (.DBF) in Excel. This can be done by choosing the "File" menu, selecting "Save As", and changing the data file type in the drop down box to one of the dBASE (.DBF) options.
  4. Take both the event shapefile and the attribute database file into a GIS software package such as ArcView 3.x or ArcGIS 9.x, and link the attribute information to the shapefile using the LIST_ID field (see "Relational Key" field in the table below for the correct field to use for other shapefiles) in the attribute information table and the source_featureid field in the shapefile.



Water Program Feature Water Program Database Relational Key Download Data Attributes
Assessed Waters National Assessment Database (NAD) ID305B Use our Expert Query tool.
Impaired Waters National TMDL Tracking System (NTTS) LISTID Use our Expert Query tool.
Water Quality Standards Water Quality Standards Database (WQSDB) WQS_ENTITY_ID WQSDB Release 9.1 Download Files
Fish Consumption Advisories National Listing of Fish and Wildlife Advisories (NLFWA) For Fish Consumption Advisories: 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.
Sewage No-Discharge Zones No-Discharge Zone (NDZ) ENTITYID
*Coming Soon*
Facilities that Discharge to Water Permit Compliance System (PCS) For Facilities: NPDES ID
For Pipe Schedules (concatenated relational key):
NPDES ID + "_" + discharge_num + "_" + report_desig + "_" + pipe_set_qualifier 		Use the customized Envirofacts Warehouse for PCS.
Nonpoint Source Projects Grants Reporting and Tracking System (GRTS) (concatenated relational key):
Grant Number + "_" + Project Number + "_" + Drainage Area Number 		Contact the Nonpoint Source Program.
Beaches BEACH Program PRAWN Database BEACH_ID The BEACON mapping and querying application allows the public to query and view information on state beach advisory and closing information contained in the PRAWN database.

For batch downloads, contact
ost-beaches@epa.gov with your request.

You will need Adobe Acrobat Reader to view the Adobe PDF files on this page.
See EPA's PDF page to learn more about PDF, and for a link to the free Acrobat Reader.

Local Navigation

Jump to main content.