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

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 03/17/10) updated!
A Microsoft Excel file that contains specific information related to the station (e.g., StationCode, Waterbody, Hydrologic Subarea) which allows for stations to be categorized by geographic area. This provides continuity and consistency among tables within the database.

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. A zip file containing GIS Shapefile Layers is available for use in software such as ArcGIS to help populate fields associated with CalWater, Counties, Ecoregion, HBASA, and NHD. We plan to make these layers available in Google Earth format soon. If you have any questions concerning this file, contact Cassandra Lamerdin.

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
SWAMP Bioassessment full version data sheets for bioassessment sampling.

Field Collection and Results Template (updated 02/18/10) updated!
(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.

An 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

Chemistry Results Template (updated 04/02/09)
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 03/17/10) updated!
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 03/17/10) updated!
(Benthic/Bioassessment/Algae)
A Microsoft Excel file for submitting lab effort and species results data. Documentation on how to fill out the template will also be available. Use the following links for taxonomic reference:  Marine - SCAMIT and Freshwater - SAFIT.