Column Explanations for Benthic Macroinvertebrate Community 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
Temp1 Temperature, water, unfiltered, degrees centigrade
PH1 pH, water, unfiltered, field, standard units
DO1 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
Temp2 Temperature, water, unfiltered, degrees centigrade
PH2 ph, water, unfiltered, field, standard units
DO2 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
TotSampVol Total Sample Volume, before any subsamples are removed or preservative is added
PhotoSampComments Photodocumentation 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 Data

Column name Column Description
SampleID Sample ID - an arbitrary, unique integer used to identify the sample
SMCOD NAWQA sample identification code
STAID USGS station id number 
Reach Reach identifier
CollectionDate  Date and time when sample collection began
Phylum Taxonomic Phylum
Class Taxonomic Class
Order Taxonomic Order
SubOrder Taxonomic Suborder
Family Taxonomic Family
SubFamily  Taxonomic Subfamily
Tribe Taxonomic Tribe
Genus Taxonomic Genus
Species Taxonomic Species
BU_ID NWQL unique ID for invertebrate taxon
SortCode NWQL phylogenetic sort code for invertebrate taxon. Sort code can change if invertebrate taxonomic hierarchy changes
Lifestage Lifestage of organism(s)
Notes Laboratory identification/enumeration notes
LabCount Estimated number of individuals in the bottle submitted to lab - value accounts for lab subsampling but not for field subsampling.
Abundance  Estimated number of individuals captured in sample. Accounts for field processing (i.e. field splitting). This quantity is calculated by multiplying LabCount by the reciprocal of  SplitRatio (LabCount * (1/SplitRatio)


Table of Contents

Introduction

Station Descriptions

Surface-Water Data

Ground-Water Data

Meteorological Data

Biological Data