[SKIP NAV]


Templates v2.5

This page contains both data sheets and data templates. Data sheets are used in the field and are entered directly into the SWAMP database by the field collection agency using the data entry forms. Data templates are filled out in the laboratory and loaded into the database, usually by the Data Management Team (DMT).

Valid values from the SWAMP database Lookup Lists are also available for reference.

PRIOR TO SAMPLING

Station Reconnaissance Template (updated 07/22/05)
A two page Microsoft Excel file used for field reconnaissance of SWAMP stations. It can be completed in the office and/or field in hard copy, or in soft copy if a laptop is used. If a hard copy is produced, it is helpful to transfer that information to soft copy and then rename the file with the SWAMP station code. There is a description of some of the items at the bottom of the second page. If possible, please attach maps, pictures, and/or drawings that will help the field crew find the station.

Station Template (updated 12/07/12
A Microsoft Excel file that contains specific information related to the station (e.g., StationCode, Waterbody, County) which allows for stations to be categorized by geographic area. This provides continuity and consistency among tables within the database. Documentation on how to fill out the template is also available.

It is critical that this form be completed prior to sampling and loaded into the database so that laboratory results are correctly loaded to the database. Zip files containing GIS Shapefile Layers are available for use in software such as ArcGIS to help populate fields associated with CalWater, Counties, Ecoregion, HBASA, and NHD. An Excel file under the CalWater section on the GIS Shapefile Layers page is also available to help populate specific fields if the corresponding CalWater information is known. If you have any questions concerning these files, contact Cassandra Lamerdin or Marco Sigala.

FIELD SUBMISSIONS

Field Data Sheets
These links open a new page containing SWAMP field data sheets for field observations, discrete probe measurements, water, sediment, tissue, and bioassessment sampling. For questions about water, sediment, and tissue field data sheets, contact Cassandra Lamerdin. For questions about bioassessment field data sheets, contact Marco Sigala.

Water Quality Field Data Sheet
SWAMP Water Quality data sheets for water and sediment sampling.

Tissue Field Data Sheets
SWAMP Tissue data sheets for bioaccumulation sampling.

Bioassessment Field Data Sheet and Data Entry Tool
SWAMP Bioassessment full version data sheets for bioassessment sampling. The Bioassessment Data Entry tool can also be accessed through this link for data entry into a Microsoft Access database.

Field Collection and Results Template (updated 03/15/13)
(Field/Habitat/Benthic/Bioassessment/Algae Collections
& Field/Habitat Results)

A Microsoft Excel file that contains multiple worksheets with the appropriate fields required to load historic and current field and habitat results into the database.  While this template was developed for loading SWAMP Bioassessment data, if a user followed the SWAMP Wadeable Streams protocol, it can be used for all water quality and bioassessment sampling. Documentation on how to fill out the template will be forthcoming.

A benthic/bioassessment example of a completed Field Collection and Results Template is available for reference.

A water quality example of a completed Field Collection and Results Template is available for reference.

The Bioassessment Analyte and Location Crosswalk is also available to help the user populate the correct constituent parameters for corresponding analytes and locations.

LABORATORY SUBMISSIONS

Valid values from the SWAMP database Lookup Lists are also available for reference.

Chemistry Results Template  (updated 08/21/13)
A Microsoft Excel file that contains two worksheets including Results and LabBatch as well as a data submission example. Documentation on how to fill out the template is also available.

Toxicity Results Template (updated 12/07/12)
A Microsoft Excel file that contains three worksheets including Results, Summary, and ToxBatch as well as a data submission example. Documentation on how to fill out the template is also available.

Tissue Data Templates
This link opens a new page containing data templates for submitting tissue data.

Taxonomy Results Template (updated 10/10/13)
(Benthic/Bioassessment/Algae)
A Microsoft Excel file for submitting lab effort and species results data. Documentation on how to fill out the template is also available as well as the current SWAMP OrganismLookUp list values for SAFIT Benthic Macroinvertebrate (BMI) and CAD-TWG Soft Algae taxa. Use the following links for taxonomic reference:

MarineSCAMIT So. California Association of Marine Invertebrate Taxonomists
Freshwater BMISAFIT SW Association of Freshwater Invertebrate Taxonomists
Freshwater AlgaeCAD-TWG California Algae & Diatom Taxonomic Working Group

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