Watershed Assessment, Tracking & Environmental ResultS

Water Quality Standards Database Attributes

• 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. WQSDB_Clone_Description_Paper.pdf - A PDF document describing the "Transition from a Centralized EPA WQSDB to a Distributed Set of State Databases"

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