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
|
| 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. |