Database Management Systems
The SWAMP data management strategy is built on the foundation that ambient monitoring data and information should be available to all stakeholders in a timely manner. SWAMP’s goal has subsequently been tailored to ensure that SWAMP data are stored in and readily accessible from a SWAMP database, which ensures both the comparability and quality of housed data, so that it can be used effectively in assessing the quality of waters within the state of California. Where possible, data are made comparable by sharing common lookup values and business rules and by following documented data management procedures available on this website.
There are two versions of the SWAMP database; v2.2 and v2.5. In May 2008, SWAMP switched from using the v2.2 to the newer v2.5 database. The SWAMP v2.2 database held only Water Quality Chemistry and Toxicity data. The newer SWAMP v2.5 database holds Water Quality Chemistry and Toxicity data as well as Tissue, Benthic, and Bioassessment data. Each version has its own unique set of associated documents and business rules. Click on the appropriate link below for templates and documentation on how to be comparable with each specific version of the SWAMP database.
Contact your DMT liaison if you are unsure which version of the database is correct for you.