| 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 or temporary alternative |
| Reach | Reach name (REACHSEQ) |
| 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, in meters |
| CFWIDRM | Channel Feature Width Remark - method used to measure width of channel feature |
| DOMSUB | Dominant substrate, code |
| SUBSUB | Subdominant substrate, text |
| WVAREA | Woody-vegetation area, percent |
| HVAREA | Herbaceous-vegetation area, percent coverage |
| Column Name | Column Description |
| ReachID | Reach name (REACHSEQ) |
| SUID | Four-letter abbreviation for NAWQA study unit |
| STAID | USGS station id number or temporary alternative |
| Reach | Reach name (REACHSEQ) |
| 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, in 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 or temporary alternative |
| Reach | Reach name (REACHSEQ) |
| ReachCollectionDate | Date and time when sample collection began |
| SampleType | Sample category or type |
| ReviewStatus | Study unit data review status for the sample (DQI) |
| 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, m |
| TRANDIS | Distance between transects, m |
| USRCHEND | Curvilinear distance from ref. location to upstream end of reach, m |
| DSRCHEND | Downstream Reach End - curvilinear distance from reference location to the downstream end of reach, in meters |
| USBMBK | Upstream boundary marker bank, text |
| DSBMBK | Downstream Boundary Marker Bank - bank where reach boundary marker is located (Left, Right, Both) |
| USBMDESC | Upstream boundary marker description, text |
| DSBMDESC | Downstream Boundary Marker Description - 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 or temporary alternative |
| Reach | Reach name (REACHSEQ) |
| 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 (DQI) |
| 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 |
| CHWIDRM | Channel Width Remark - method used to measure channel width |
| CHANHEAD | Channel heading (aspect), in degrees |
| LCANANG | Left Bank Canopy Angle, degrees |
| RCANANG | Right Bank Canopy Angle, text |
| EYEHIGH | Canopy Angle Eye Height, meters |
| LBSHAD | Left Bank Rip Canopy Closure |
| RBSHAD | Right Bank Rip Canopy Closure, text |
| LBLULC | Left Bank Land Cover |
| RBLULC | Right Bank Land Cover, text |
| LBANGLE | Left-bank angle, in degrees |
| RBANGLE | Right-bank angle, degrees |
| LBHIGH | Left-bank height, in meters |
| RBHIGH | Right-bank height, meters |
| LBSUB | Left Bank Substrate, code |
| RBSUB | Right Bank Substrate, text |
| LBVEG | Left Bank Vegetative cover |
| RBVEG | Right Bank Cover, text |
| LBEFLAG | Left Bank Erosion Flag |
| RBEFLAG | Right Bank Erosion Flag, text |
| CANANGLE | open canopy angle, in degrees |
| LBWIDTH | Left Bank Width, in meters |
| LBWIDRM | Left Band Width Remark - method used to measure left bank width |
| RBWIDTH | Right-bank width, meters |
| RBWIDRM | Right-bank width, remark |
| LBSHAPE | Left-bank shape |
| RBSHAPE | Right-bank shape, text |
| LBSUBSUB | Left-bank subdominant substrate, code |
| RBSUBSUB | Right-bank subdominant substrate, text |
| 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, in meters |
| RFPWRM | Right flood-plain width Method, text |
| LFPWRM | Left Flood Plain Width Remark - method used to measure left flood plain width |
| RFPWIDTH | Right flood-plain width, meters |
| 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 or temporary alternative |
| Reach | Reach name (REACHSEQ) |
| 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 |
| ThalwegFlag | Thalweg Flag, boolean |
| LEWDist | Left Edge of Water Distance - distance from left edge of water, in meters |
| DepthM | Depth of water, in meters |
| Velocity | Velocity, stream, feet per second |
| BEDSUB | Code for dominant bed substrate |
| EmbedPct | Substrate Embeddedness, percent |
| SILT | Silt covering, text |
| 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, text |
|
Table of Contents |
Introduction |
Station Descriptions |
Surface-Water Data |
Ground-Water Data |
Meteorological Data |
Biological Data |