| Column Name | Column Description |
| TranSampleID | Sample ID - an arbitrary, unique integer used as primary key for Sample table |
| SUID | Four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number |
| Reach | Reach name |
| TranNum | Transect Number, text |
| CollectionDate | Date and time when sample collection began |
| SampleType | Sample category or type |
| Collector | Person or persons responsible for collecting the sample |
| CHFEAT | Channel feature type |
| CFWIDTH | Channel width, meters |
| CFWIDRM | Channel Feature Width Remark - method used to measure width of channel feature |
| DOMSUB | Dominant substrate, code |
| SUBSUB | Subdominant substrate, code |
| WVAREA | Woody-vegetation area, percent |
| HVAREA | Herbaceous-vegetation area, percent |
| Column Name | Column Description |
| ReachID | Reach identifer |
| SUID | Four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number or temporary alternative |
| Reach | Reach name |
| CollectionDate | Date and time when sample collection began |
| SampleType | Sample category or type |
| Collector | Person or persons responsible for collecting the sample |
| GCUTYPE | Type of geomorphic channel unit |
| GCULEN | Length of geomorphic channel unit, meters |
| Column Name | Column Description |
| ReachSampleID | Reach Sample ID - an arbitrary, unique integer that identifies the reach characterization sample |
| SUID | Four-letter abbreviation for NAWQA study unit |
| OrigSUID | Original four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number |
| Reach | Reach name |
| ReachCollectionDate | Date and time when sample collection began |
| SampleType | Sample category or type |
| ReviewStatus | Study unit data review status for the sample |
| REFLOC | Description of reference location, text |
| Collector | Person or persons responsible for collecting the sample |
| HABQUAL | Habitat Sample Quality - overall quality of habitat data |
| REACHCOM | Stream-Reach Comments, text |
| STAGE | Stage, stream, feet |
| STAGEMD | Stage stream method, text |
| DISCH | Discharge - instantaneous discharge in cubic feet per second |
| DISCHMD | Discharge Method - method used to determine instantaneous discharge |
| CHMOD | Channel modification observed at sampling reach |
| REACHLEN | Curvilinear length of stream reach, meters |
| TRANDIS | Distance between transects, meters |
| USRCHEND | Curvilinear distance from reference location to upstream end of reach, meters |
| DSRCHEND | Downstream Reach End - curvilinear distance from reference location to the downstream end of reach, meters |
| USBMBK | Upstream Boundary Marker Bank, text - bank where reach boundary marker is located (Left, Right, Both) |
| DSBMBK | Downstream Boundary Marker Bank, text - bank where reach boundary marker is located (Left, Right, Both) |
| USBMDESC | Upstream Boundary Marker Description, text - description of upstream boundary marker |
| DSBMDESC | Downstream Boundary Marker Description, text - description of downstream boundary marker |
| RCHGRAD | Water-surface gradient, dimensionless |
| THGRAD | Thalweg gradient, dimensionless |
| RCHGRAMD | Gradient method, text |
| STRMTYP | Stream type, code |
| Comments | Comments about the reach and/or habitat sampling effort |
| InsertDate | Date and time when reach sample record was inserted in Sample table |
| UpdateDate | Date and time when reach sample record in Sample table was last updated |
| Column Name | Column Description |
| TranSampleID | Sample ID - an arbitrary, unique integer used as primary key for Sample table |
| ReachSampleID | Reach Sample ID - an arbitrary, unique integer that identifies the reach characterization sample |
| SUID | Four-letter abbreviation for NAWQA study unit |
| OrigSUID | Original four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number |
| Reach | Reach name |
| ReachCollectionDate | Date and time when sample collection began |
| TCTNO | Transect Number |
| TransectCollectionDate | Date and time when sample collection began |
| SampleType | Sample category or type |
| ReviewStatus | Study unit data review status for the sample |
| HABTYPE | Habitat Type - habitat type of geomorphic channel unit |
| PhotoUs | Photodoc Upstream, text |
| PhotoDs | Photodoc Downstream, text |
| PhotoOther | Photodoc Other, text |
| CHWIDTH | Channel width, meters |
| BFWIDTH | Bankfull channel width, meters |
| CHWIDRM | Channel Width Remark - method used to measure channel width |
| CHANHEAD | Channel heading (aspect), degrees |
| LCANANG | Left Bank Canopy Angle, degrees |
| RCANANG | Right Bank Canopy Angle, degrees |
| EYEHIGH | Canopy Angle Eye Height, meters |
| LBSHAD | Left Bank Rip Canopy Closure |
| RBSHAD | Right Bank Rip Canopy Closure |
| USSHAD | Upstream Rip Canopy Closure |
| DSSHAD | Downstream Rip Canopy Closure |
| LBLULC | Left Bank Land Cover, text |
| RBLULC | Right Bank Land Cover, text |
| LBANGLE | Left-bank angle, degrees |
| RBANGLE | Right-bank angle, degrees |
| LBHIGH | Left-bank height, meters |
| RBHIGH | Right-bank height, meters |
| LBSUB | Left Bank Substrate, code |
| RBSUB | Right Bank Substrate, code |
| LBVEG | Left Bank Vegetative Cover, percent |
| RBVEG | Right Bank Vegetative Cover, percent |
| LBEFLAG | Left Bank Erosion Flag, text |
| RBEFLAG | Right Bank Erosion Flag, text |
| CANANGLE | Open canopy angle, degrees |
| LBWIDTH | Left Bank Width, meters |
| LBWIDRM | Left Bank Width Remark - method used to measure left bank width |
| RBWIDTH | Right-bank width, meters |
| RBWIDRM | Right-bank Width, Remark - method used to measure right bank width |
| LBSHAPE | Left-bank shape, code |
| RBSHAPE | Right-bank shape, code |
| LBSUBSUB | Left-bank subdominant substrate, code |
| RBSUBSUB | Right-bank subdominant substrate, code |
| WSAREA | Woody-snags area, square meters |
| OVAREA | Over-hanging vegetation area, square meters |
| UBAREA | Undercut-banks area, square meters |
| BDAREA | Boulders area, square meters |
| SHAREA | Sloughs area, square meters |
| MEAREA | Emergent-macrophyte area, square meters |
| MSAREA | Submerged macrophyte area, square meters |
| MFAREA | Floating-macrophyte area, square meters |
| RBAREA | Rubbish area, square meters |
| OTAREA | Other habitat features, area, square meters |
| LFPWIDTH | Left Flood-Plain Width, meters |
| RFPWIDTH | Right flood-plain width, meters |
| LFPWRM | Left Flood Plain Width Remark - method used to measure left flood plain width |
| RFPWRM | Right Flood-Plain Width Remark - method used to measure right flood plain width |
| Collector | Person or persons responsible for collecting the sample |
| InsertDate | Date and time when record for transect sample was inserted in Sample table |
| UpdateDate | Date and time when record in Sample table for transect sample was last updated |
| Column Name | Column Description |
| TranPtSampleID | Sample ID - an arbitrary, unique integer used as primary key for Sample table |
| TranSampleID | Sample ID - an arbitrary, unique integer used as primary key for Sample table |
| ReachSampleID | Reach Sample ID - an arbitrary, unique integer that identifies the reach characterization sample |
| SUID | Four-letter abbreviation for NAWQA study unit |
| OrigSUID | Original four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number |
| Reach | Reach name |
| ReachCollectionDate | Date and time when sample collection began |
| TCTNO | Transect number |
| Transect CollectionDate | Date and time when sample collection began |
| TPNum | Transcect Point number |
| SampleType | Type of sample collected |
| TransPointType | Type of transect point collected |
| ThalwegFlag | Thalweg Flag, boolean |
| LEWDist | Left Edge of Water Distance - distance from left edge of water, in meters |
| DepthM | Depth of water, meters |
| Velocity | Velocity, stream, feet per second |
| BEDSUB | Dominant bed substrate, code |
| EmbedPct | Substrate Embeddedness, percent |
| SILT | Silt covering, text |
| MphyMalgCvr | Macrophyte or Macroalgae covering, percent |
| HabWDFlag | Habitat Woody Debris Flag - flag indicating presence of woody debris habitat feature |
| HabOVFlag | Habitat Overhanging Vegetation Flag - flag indicating presence of overhanging vegetation habitat cover feature |
| HabUBFlag | Habitat Undercut Bank Flag - flag indicating presence of undercut bank |
| HabBOFlag | Habitat Boulder Flag - flag that indicates presence of boulder habitat cover feature |
| HabAMFlag | Habitat Aquatic Macrophyte Flag - flag that indicates presence of aquatic macrophyte habitat cover feature |
| HabMSFlag | Habitat Manmade Structure Flag - flag that indicates presence of manmade structure habitat cover feature |
| HabTBFlag | Habitat To Turbid Flag - flag indicating that stream was too turbid to evaluate habitat cover features |
| HabNOFlag | Habitat No Cover Flag - flag that indicates that no habitat cover features were present. |
| HabNCFlag | Habitat No Characterization Flag - flag that indicates habitat features were not evaluated. |
| SUBSUB | Subdominant substrate, code |
Table of Contents |
Introduction |
Station Descriptions |
Surface-Water Data |
Ground-Water Data |
Meteorological Data |
Biological Data |