Column Explanations for Habitat Data

File Type: Channel Features

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

File Type: GCU

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

File Type: Reach

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

File Type: Transect

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

File Type: Transect Points

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