[SKIP NAV]


SWAMP Data Management Plan

The SWAMP Data Management Team (DMT) has established this document to describe business rules as well as field sampling guides, data formats, and data management processes that are helpful in collecting and sharing SWAMP-comparable data.

The links below open individual sections of the SWAMP Data Management Plan as well as the availability to download the entire document either as an Adobe PDF or Microsoft Word file.

As sections of this document are completed, they will become available as links for downloading.

Adobe PDF (In Review)

Microsoft Word(In Review)

  1. SUGGESTION / EXPLANATION / READ ME DOC FOR USERS
  2. INTRODUCTION AND APPROACH TO INFORMATION MANAGEMENT
    1. Program Description
    2. Approach to Information Management
    3. Roles and Responsibilities
  3. SWAMP-COMPARABILITY
    1. Minimum Required Fields for SWAMP-comparability
  4. STRUCTURE AND PROTOCOLS
    1. General Structure of Database
    2. Form Entry/Editing Protocols
    3. Standardized Data Transfer Protocols
    4. Data Flow
    5. Verification and Validation Processes
  5. DATABASE USAGE
    1. System Requirements

  1. Database Program Setup 
  2. Data Entry
  3. Field Data Entry
    1. Programs Needed for SWAMP Data Entry Forms
    2. Station Template – Needed Before Data Entry (updated 01/12/12)
    3. Water Quality and Tissue Using the Forms
    4. Water Quality and Tissue Using the Template
    5. Bioassessment, Physical Habitat, and Algae Data (updated 03/28/12)
  4. Analytical Data
    1. Water Quality and Tissue Analysis Authorization Forms
    2. Taxonomy Analysis Authorization Forms
    3. Water Quality (Chemistry including Bacteria) Data (updated 05/02/14) updated!
    4. Toxicity Data (updated 04/15/09)
    5. CETIS/SWAMP Toxicity Data Translator (updated 10/27/08)
    6. Tissue Data (updated 06/23/09)
    7. Taxonomy Data (updated 10/20/10)
    8. Submitting Data to SWAMP Database Management Team
  • QUERYING THE DATA
    1. Query Tool Program and Database Set-up
    2. Standard Query Overview
    3. SWAMP Regional Board Queries

      1. Water Quality (Chemistry and Toxicity) Queries (updated 09/30/09)
      2. Tissue Queries
      3. Taxonomic/Bioassessment Queries
  • DATA MANAGEMENT PROCESSES
    1. Working with Permissions
    2. Customizing SWAMP Data Entry Forms
    3. Data Loading
      1. Chemistry Data (updated 06/08/09)
      2. Toxicity Data
      3. Tissue Data
      4. Taxonomic/Bioassessment Data
    4. Data Verification
    5. Data Validation
    6. Data Management Replication Process
    7. Database Backup Procedures
    8. Specific Query Usage
      1. Completeness Check Queries
      2. Quality Assurance Check Queries
      3. Global Check Queries
    9. Correcting Data Mistakes
    10. Temp to Perm Data Transfer
    11. Export Data to CEDEN
  • APPENDICES
    1. ER Diagrams (updated 05/05/14)  updated!
    2. Database Table Properties
    3. Database LookUp Lists
    4. Business Rules for Populating and Maintaining Tables
    5. Data Management Team SOPs

SWAMP website

For comprehensive SWAMP content, visit the SWRCB's official website

CEDEN

California Environmental Data Exchange Network CEDEN Link

FTP

Allows file sharing when conducting State and Regional Board SWAMP business on the FTP site