Watershed Assessment, Tracking & Environmental ResultS

WATERS Data

• Data Downloads - Download spatial extracts from the RAD for use in GIS applications.
  
  
• Locating Attribute Data - Where to find attribute data and how to link that data to the spatial extracts downloaded from the RAD.
  
  
• WATERS Expert Query Tool - Create your own reports or data extracts of impaired and assessed water related data with associated Total Maximum Daily Load information.
  
  
• Office of Water Program Databases - OW Programs currently linked or planning to link to WATERS. Attribute information can be obtained from each individual program database.
  
  
• Availability of data - This table shows the status of data availability by State for each water program that is accessible through EnviroMapper for Water.
  
  
• Direct Connect to RAD - Instructions for technical EPA employees to connect directly to the RAD via the EPA Intranet. The RAD can be accessed to view tables via SQL queries or SDE layers via GIS SDE connect.
  
  
• WQSDB v. 9.1 Download Files
  • WQSDB in MS Access Format
    All the WQSDB data from Release 9.1 is available in a MS Access database. The tables in this database have the same relationships as the ones shown on the Data Model Diagram.
    

    a. File Name: WQSDB_R91.mdb
    b. File Size: 87 MB
    c. Version: WQSDB Release 9.1
    d. MS Access Version: 2003
    

  • WQSDB in Oracle 10g Format
    The Oracle version of the WQSDB data from Release 9.1 is also available for download. The tables in this database have the same relationships as the ones shown on the Data Model Diagram.
    
    The file details are:
    

    a. File Name: wqsdb_rel91.dmp
    b. File Size: 43 MB
    c. Oracle Version: 10g
    d. Schema Name: WQSDB
    e. Import guidelines:

    i. Log in as a user with DBA privileges
    ii. Create a new schema named WQSDB
    iii. Use Oracle version 10g import utility and import the contents into the newly created WQSDB schema (full user mode import).

    f. An Operating Guideline Document is in development and will be posted in the future.

  • WQSDB Reports in Excel Format
    All the reports that were available in WQSDB Release 9.1 have been extracted and saved in an MS Excel format. The files are available for download in a zipped format. The report files are organized by Report type, with state level data listed alphabetically for each of those reports, where available. In a few instances multiple files were necessary to support the volume of data.

    The report types are:

    Report Title	File Size
    Designated Use and Class Data by State	244 KB
    State wide General Use Provisions	63 KB
    Designated Use and Class Data by State Waterbody	11 MB
    State Designated Use and class data by National Designated Use	201 KB
    State Numeric Criteria	523 KB
    EPA Numeric Criteria	164 KB
    State Vs. EPA Numeric Criteria	1 MB

    
    

    a. Usage guidelines: Unzip the files using a file decompression utility. The report file names contain the State abbreviation where applicable.

  • WQS Waterbody Reaches in ESRI Geodatabase Format
    A national geodatabase file of Water Quality Data from the Reach Address Database (RAD) is available as an ESRI file geodatabase.
    

  a. File Name: WQS_National.zip
  b. File Size: 348 MB
  c. Number of Files: 1
  d. Geodatabase Version: 9.2
  e. Usage guidelines: Unzip the file geodatabase and place it in a location accessible to your ESRI ArcGIS client.

  
  

  The WQSDB National geodatabase file contains both the event spatial data and the supporting event attribute tables. To find information about linking together spatial and attribute datasets, please visit the Water Program Data Download page.