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 |
| 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 | 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 name |
| 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 |