Assessment Database Version 2 (ADB v.2) - Reference

This page provides several reference materials for ADB v.2 users.

ADB v.2 Users Guide and Install Manual

  • State User Guide - for Access, Oracle and SQL Server versions of ADB v.2. This document also includes the installation instructions for Windows XP.
  • Installation instructions for Windows 7 - Note: There are known compatibility issues with Windows 7.
  • EPA Region User Guide - for Access version of ADB v.2. This document includes information for EPA Regions using the ADB v.2. It focuses more on using ADB data provided by States, rather than data entry.
  • Best Practices Document - examples related to data entry for the ADB v.2.

Design Documentation

  • ADB v.2 Data Dictionary
  • ADB v.2 Entity Relationship Diagram
  • ADB Domain Value Lists: Please visit Ask WATERS to obtain the ADB data elements; available data elements lists include the following:
    • States
    • Water Type, Water Type Group, Size Unit
    • Trophic Status of Publicly Owned Lakes
    • Trend of Publicly Owned Lakes
    • Assessment Type
    • Assessment Confidence
    • Causes
    • Sources
    • Delisting Reasons
    • Uses

Integrated Reporting Guidance and Memos

Clean Water Act Sections 303(d), 305(b) and 314 Integrated Reporting Guidance

ADB Listserver

An ADB Listserver has been set up to enable users to share information about the ADB.