Column Explanations for Phytoplankton Quantitative Data
File type: Sample Description
| Column Name | Column Description |
| SampleID | Sample ID - an arbitrary, unique integer used to identify the sample |
| SUID | Four-letter abbreviation for NAWQA study unit |
| OrigSUID | Original four-letter abbreviation for NAWQA study unit |
| CollectionYear | Calendar year when sample was collected |
| STAID | USGS station id number |
| StationName | USGS station name |
| Reach | Reach name |
| LocNum | Number of sample location |
| CollectionDate | Date and time when sample collection began |
| SampleMediumCode | Code for sampling medium |
| SampleType | Sample category or type (RTH, quantitative; QMH, qualitative) |
| Collector | Person or persons responsible for collecting the sample |
| ReplicateFlag | Replicate flag-indicates whether sample is a repeated-sampling replicate (Y) of a primary environmental sample (N) |
| ReviewStatus | Study unit data review status for the sample |
| PrgmProjCode | Program code |
| AreaSampTot | Total area sampled for invertebrate sample, square centimeters |
| RSAAlgaeFlg | Related Sampling Activity, Algae Survey Flag |
| RSAChemFlg | Related Sampling Activity, Water Chemistry Flag |
| RSADischargFlg | Related Sampling Activity, Discharge Flag |
| RSAHabFlg | Related Sampling Activity, Habitat Survey Flag |
| RSATissFlg | Related Sampling Activity, Tissues Flag |
| RSAInvertFlg | Related Sampling Activity, Invertebrate Survey Flag |
| RSAFishFlg | Related Sampling Activity, Fish Survey Flag |
| RSABedSedFlg | Related Sampling Activity, Bed Sediment Flag |
| RSAOther | Related Sampling Activity, Other Sample Activity |
| CloudCover | Cloud coverage, percent |
| WindIntensity | Wind Description, text |
| PrecipDescrip | Precipitation description, text |
| PrecipIntensity | Precipitation intensity, text |
| OtherSiteCond | Other site conditions, text |
| QWTime1 | Time when observation or measurement was taken |
| WaterTemp1 | Temperature, water, unfiltered, degrees centigrade |
| WaterPH1 | pH, water, unfiltered, field, standard units |
| WaterDO1 | Dissolved Oxygen - measurement taken for first set of field water-quality measurements. Milligrams per liter. |
| SpecConductance1 | Specific conductance, water, unfiltered, 25 deg c, field, microsiemens per centimeter |
| QWTime2 | Time when observation or measurement was taken |
| WaterTemp2 | Temperature, water, unfiltered, degrees centigrade |
| WaterPH2 | ph, water, unfiltered, field, standard units |
| WaterDO2 | Dissolved Oxygen - measurement taken for second set of field water-quality measurements. Milligrams per liter. |
| SpecConductance2 | Specific conductance, water, unfiltered, 25 deg c, field, microsiemens per centimeter |
| Discharge | Discharge - instantaneous discharge in cubic feet per second |
| Stage | Stage, stream, feet |
| RiparianShading | Riparian shading description, text |
| WaterClarity | Water clarity description, text |
| WaterColor | Water Color, text |
| PhysSiteCondNotes | Notes about physical conditions at site when sample was collected |
| MeshSize | Sampler mesh size, microsiemens |
| TotSampVol | Total Sample Volume, before any subsamples are removed or preservative is added |
| PhotoSampComments | Photo documentation comments |
| InsertDate | Date and time when record for sample was inserted in Sample table |
| UpdateDate | Date and time record in table was last updated |
File type: Sample Bottle Description
| Column Name | Column Description |
| BottleID | Bottle or filter identification number. An arbitrary, unique integer that identifies the bottle or subsample |
| SampleID | Sample ID - a unique integer used to identify the composite (multi-bottle) algae or invertebrate sample |
| SMCOD | NAWQA sample identification code |
| SUID | Four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number |
| Reach | Reach name |
| CollectionDate | Date and time when sample collection began |
| NWISTime | Time recorded in NWIS system for sample or data |
| SampleMediumCode | Code for sampling medium |
| SampleType | Sample Category or type |
| SampleAnalysisPlan | Where the sample will be analyzed |
| SampleComponent | Sample component, full text |
| SampleAnalysisType | Code for type of analysis requested or planned |
| SplitFlag | Flag to indicate analytical subsample splits of algae sample component |
| SplitRatio | Field-splitting ratio for invertebrate samples |
| SampleVol | Volume of algae sample or subsample before any preservative is added, milliliters |
| PreservativeVol | Volume of preservative added to sample, milliliters |
| PreservativeType | Type of preservative |
| DecantBeforeVol | Volume before sample is decanted to reduce volume shipped to lab, milliliters |
| DecantAfterVol | Volume remaining after sample is decanted in order to reduce volume shipped to lab, milliliters |
| ASRDate | Date and time when electronic Analytical Services Request (ASR) was generated |
| PrgmProjCode | Program code |
| Collector | Person or persons responsible for collecting the sample |
| InsertDate | Date and time when record for bottle or subsample was inserted in Sample table |
| UpdateDate | Date and time record in table was last updated |
File type: Sample Data
| Column Name | Column Description |
| BottleID | Bottle or filter identification number. An arbitrary, unique integer that identifies the bottle or subsample |
| SampleID | Sample ID - an arbitrary, unique integer used to identify the sample |
| SMCOD | NAWQA sample identification code |
| STAID | USGS station id number |
| Reach | Reach name |
| Group | Code indicating diatom (D) or non-diatom (N) algal taxon |
| AlgaeGroup | Membership of taxon within a major algal group: (e.g. diatoms, red algae, green algae, etc.) |
| Phylum | Taxonomic Phylum |
| Family | Taxonomic Family |
| Genus | Taxonomic Genus |
| Species | Taxonomic Species |
| Variety | Taxonomic Variety |
| TaxonAuthority | Taxonomic authority |
| ScientificName | Scientific name of taxon |
| Quantity | Number of individuals counted on a particular slide prepared for a particular sample |
| Cells_cm2 | Number of cells per centimeter squared |
| Cells_mL | Number of cells per millileter |
| Biovolume_cm2 | Biovolume per centimeter squared |
| Biovolume_mL | Biovolume per millileter |
| NADEDID | Identification code for the North American Diatom Ecological Database |
| ShortName | 8-character code for taxon for use in CANOCO |
| SampleProcessingStatusText | ANSP sample-processing status of sample |
Table of Contents |
Introduction |
Station Descriptions |
Surface-Water Data |
Ground-Water Data |
Meteorological Data |
Biological Data |