CWQMC Data Swaps. Dr. Holly L.O. Huyck CWQMC Coordinator [email protected] CWQMC Data Swaps. January 2001: Clear Creek Watershed and Henderson site metadata March 2002: South Platte Basin data needs swap May 2002: South Platte Basing metadata swap.
Chemical Variables Field parameters: pH, DO, conductivity, etc. Major ions:major cations and anions, including Fe, Mn, but NOT nutrient-related ions. Nutrients: all forms of nitrogen and phosphorous (including iron). Organics:TOC, TOD. Minor and Trace elements:minor elements, and metal (EXCEPT for Fe and Mn). Chemistry of Sediments:analyses of the sediments themselves, as opposed to water chemistry.
~130 sites excluding Superfund
109 sites related to Superfund (sampled 1-5x)
Include nutrients, metals, sediments, fish, flow
~900 sites (past and current)
Project Name: character field.
Project agency name: unique name for each agency or group.
Project Description: memo-type field that can include whatever comments are desired.
Project Purpose: character field with ,e.g. basic screening, regulatory compliance, site trends.
Project QA/QC: memo-type field with # of field duplicates, field blanks, analytical lab name, and corrective actions for problems—e.g. bad blanks.
ProjectContact: Name, address, telephone, email. Person who supplied data. (These may differ.)
Station ID: character field, no duplicates allowed.
Station Name: character field. If no name exists, can just repeat the station ID.
Station Type: stream, well, lake, canal, etc.
Station Latitude: standardize this as Degree-Minute-Second or decimal degree.
Station Longitude: standardize this as Degree-Minute-Second or decimal degree.
Location Datum: NAD27 or NAD83. Define which datum was used for lat./long. (e.g. pre-1983 USGS maps would be NAD27; GPS systems should tell users which datum was used.)
Location Description: memo-type field with local permanent landmarks or other descriptive comments—e.g. sample in the thalweg, upstream of bridge.
Sample ID: character field, must be a unique identifier.Sample Date: representative date or date that sample collection was started. Sample Time: representative time or time that sample collection was started (military time).Sample Type: grab, composite; if composite, code for duration of composite (hours, days, etc).SampleMedium: water, sediment, fish tissue, etc.SampleDepth: character field that contains depth, or range in depth. SampleDepth Units: meters, feet, etc.
Result Name: e.g. pH, Temp., Calcium, Nitrate, etc.
Result Value: measured characteristic. Prefer numeric field, but could be character field.
Result Units: degrees, mg/l, ppm, ppb, ug/l, etc.
Result Fraction: total, total recoverable, dissolved (filter size?), etc.
Result Detection Limit:
Result Detection Limit Units: mg/l, ppb, etc.
Result Comments: memo-type field to include user-defined information, e.g. whether the result is an estimate, average, less than (for below detection limit), how user made an average, sample preparation, analytical method, etc.