Formatting and Instructions - DOC - DOC by tyndale


									                               Formatting and Instructions:
                           Electro-fishing Survey Data Template

        Electro-fishing surveys are conducted for many different reasons, from presence-absence
surveys to census counts to collecting fish for tagging purposes. This template contains data
elements commonly collected when electro-fishing surveys are conducted for population
estimates where multiple passes are conducted in a specific segment or habitat unit of a stream.
This template has been designed assuming that a stream has been divided into reaches and a
specific stream reach has been divided into habitat units, and habitat units are electro-shocked.
The template can still be utilized if only reaches are electro-fished or if the stream has been
divided into reaches and segments, not based on habitat typing. If the latter is the case, just treat
the habitat units as stream segments. If only reaches are surveyed, then ignore the habitat unit
fields. If only certain habitat units (such as pools) are surveyed and no reaches are designated
(such a presence/absence survey or census survey), then create a generic reach for the entire
stream, and enter data for each unit that is electro-fished.

Excel worksheets containing drop-down list choices (in bold) are currently hidden. To unhide
them, go to Format >Sheet>Unhide, and select whichever Table you wish to view. You must
unhide sheets one at a time.

You may also wish to add choices to the drop-down options that better fit your particular project.
To add a choice, go to the relevant Table; create a new number, abbreviation, and definition; put
them in the appropriate columns.

Adding Data Elements
If you collect data elements other than those listed within the template, please feel free to add
them and label them as you wish, or delete data elements you do not collect, provided that you
retain the minimum core data elements. We ask that you do not change the field names, as this
will keep data collected by all entities comparable. Changing field names may also render the
Pivot Table reports unusable. If the field name is unclear, you can always change the caption so
it makes more sense.


Required Data Elements
Required data elements are listed in bold below. Data elements that are required depending on
circumstances are in bold and italics. Notes below each data Dictionary table describe when the
conditional data elements are required.

KLB                                            1                                            06/20/2008
Field Name       Field Description                                                    Data Type      Codes/Conventions
ProjDocNum       Individual number identifying the project                            Long Integer
Basin            A unique 6 digit code for the third level of classification          Text 6         See attached tables and maps. 170900 is the BasinID for the
                 (accounting unit) or 3rd field HUC (Hydrologic Unit Code).                          Willamette
Subbasin         A unique 8 digit code for the fourth level of classification         Text 8         See attached tables and maps. 17090003 is the SubbasinID
                 (cataloging unit) or 4th field HUC (Hydrologic Unit Code).                          for the Upper Willamette
                 Generally represents part or all of a surface drainage basin,
                 combination of drainage basins, or a distinct hydrologic
                 feature. Sometimes also called a “watershed”.
LLID             A standard, unique 13 digit code that identifies an individual       Text 13        1227618456580 is the LLID for the Willamette River
                 stream or body of water. LLID as used in this document
                 refers to a stream code assigned at the 1:100,000 scale
                 hydrography. LLIDs are created by GIS personnel in state
                 Fish and Wildlife Agencies (such as ODFW in Oregon).
Stream Name      Name of Stream                                                       Text
Date             Date of Survey                                                       Date           MM/DD/YYYY
Time             Time at start of survey                                              Time           24 hr clock
Crew             ID assigned to crew members that conducted the survey                Byte           If crews are often the same, a lookup table could be created.
Weather          Describes the weather observed during the survey                     Text 2         SU = Sunny
                                                                                                     O = Overcast
                                                                                                     P = Partly-Cloudy
                                                                                                     R = Raining
                                                                                                     S = Snow
                                                                                                     ST = Sleet
ReachID          Name, number or description of reach                                 Text 50        Each ReachID is unique within a stream
Start Latitude   Latitude at start of reach, in decimal degrees                       Single         12.34567
Start            Longitude at start of reach, in decimal degrees                      Single         123.45678
End Latitude     Latitude at end of reach, in decimal degrees                         Single         12.34567
End Longitude    Longitude at end of reach, in decimal degrees                        Single         123.45678
Reach Length     Length of reach in miles                                             Single
Habitat Unit     Number identifying the habitat unit that is being electro-           Text 50        Habitat units are numbered starting at the bottom of the
Number           fished.                                                                             reach travelling upstream to the top of the reach
Habitat Type     Type of physical habitat being surveyed                              Text 3         See Habitat Type table
Habitat Unit     Length of habitat unit (m)                                           Single         In meters
Habitat Unit     Maximum width (m) of habitat unit                                    Single         Width measured at the widest part of the unit/section being
Width                                                                                                electro-fished

KLB                                                                               2                                                                  06/20/2008
Habitat Unit     Maximum depth (m) of the habitat unit/section                    Single
Water Temp       Water temperature (°C)                                           Single
Conductivity     Water conductivity in micro-Siemens per centimeter (mS/cm)       Single
                 at electro-fishing site
Voltage          Voltage setting used during electro-fishing passes               Integer   Setting on electro-fishing unit
Pulse Width      Time duration of a single electric pulse (micro-seconds)         Text 25   Setting on electro-fishing unit
Pulse Rate       Rate at which pulses are emitted per second                      Text 25   Setting on electro-fishing unit
Pass Number      Number of the current electro-fishing pass through the habitat   Byte
Species          Species of fish capturing during electro-fishing pass            Text 3    See Species table
Count            Total number of fish                                             Integer   Includes mortalities
Number of        Number of mortalities                                            Integer   Number of mortalities
Number of Fish   Number of fish marked during each electro-fishing pass           Integer   If fish are marked during electro-fishing, additional fields
Marked                                                                                      can be included in table to describe the marks applied –
                                                                                            otherwise marks can be described in the comments section
Number of        Number marked fish recaptured during the electro-fishing         Integer   If marked fish are recaptured additional fields can be added
Recaptures       pass                                                                       to the table to describe the marks observed on the fish –
                                                                                            otherwise marks can be described in the comments section
Comments         Any additional comments regarding the fish capturing during      Memo      Any additional comments regarding the fish capturing
                 electro-fishing.                                                           during electro-fishing.
**If fish are marked, then these fields should be filled in. Additional fields should be added to describe the marks or tags.

Project Documentation Table – this table includes the information about the project and documents methods and purpose.
Field Name               Field Description                                                  Data Type           Codes/Conventions
ProjDocID                Individual number identifying the project documentation            AutoNumber
ProjName                 Descriptive name of project                                        Text
OrgName                  Name of the organization undertaking data collection               Text
Methods                  Name of or brief description of methods used, may also             Memo
                         include citation for methods
Purpose                  Brief description of purpose, or citation for purpose              Memo

KLB                                                                           3                                                             06/20/2008
Basin Table:
BasinID Basin_Name
160402   Black Rock Desert
170501   Middle Snake-Boise
170502   Middle Snake-Powder
170601   Lower Snake
170701   Middle Columbia
170702   John Day
170703   Deschutes
170800   Lower Columbia
170900   Willamette
171002   Northern Oregon Coastal
171003   Southern Oregon Coastal
171200   Oregon Closed Basins
180101   Northern California Coastal
180102   Klamath
180200   Upper Sacramento

KLB                                    4   06/20/2008
Subbasin Table:
SubbasinID             Subbasin_Name        SubbasinID          Subbasin_Name        SubbasinID        Subbasin_Name
 16040201    Upper Quinn                     17070304    Upper Crooked                17100308    Middle Rogue
 16040205    Thousand-Virgin                 17070305    Lower Crooked                17100309    Applegate
 17050103    Middle Snake-Succor             17070306    Lower Deschutes              17100310    Lower Rogue
 17050105    South Fork Owyhee               17070307    Trout                        17100311    Illinois
 17050106    East Little Owyhee              17080001    Lower Columbia-Sandy         17100312    Chetco
 17050107    Middle Owyhee                   17080003    Lower Columbia-Clatskanie    17120001    Harney-Malheur Lakes
 17050108    Jordan                          17080006    Lower Columbia               17120002    Silvies
 17050109    Crooked-Rattlesnake             17090001    Middle Fork Willamette       17120003    Donner und Blitzen
 17050110    Lower Owyhee                    17090002    Coast Fork Willamette        17120004    Silver
 17050115    Middle Snake-Payette            17090003    Upper Willamette             17120005    Summer Lake
 17050116    Upper Malheur                   17090004    McKenzie                     17120006    Lake Abert
 17050117    Lower Malheur                   17090005    North Santiam                17120007    Warner Lakes
 17050118    Bully                           17090006    South Santiam                17120008    Guano
 17050119    Willow                          17090007    Middle Willamette            17120009    Alvord Lake
 17050201    Brownlee Reservoir              17090008    Yamhill                      18010101    Smith River
 17050202    Burnt River                     17090009    Molalla-Pudding              18010201    Williamson
 17050203    Powder River                    17090010    Tualatin                     18010202    Sprague
 17060101    Hells Canyon                    17090011    Clackamas                    18010203    Upper Klamath Lake
 17060102    Imnaha River                    17090012    Lower Willamette             18010204    Lost River
 17060103    Lower Snake-Asotin              17100201    Necanicum                    18010205    Butte
 17060104    Upper Grande Ronde River        17100202    Nehalem                      18010206    Upper Klamath River
 17060105    Wallowa River                   17100203    Wilson-Trask-Nestucca        18010209    Lower Klamath River
 17060106    Lower Grande Ronde              17100204    Siletz-Yaquina               18020001    Goose Lake
 17070101    Middle Columbia-Lake Wallula    17100205    Alsea
 17070102    Walla Walla                     17100206    Siuslaw
 17070103    Umatilla                        17100207    Siltcoos
 17070104    Willow                          17100301    North Umpqua
 17070105    Middle Columbia-Hood            17100302    South Umpqua
 17070106    Klickitat                       17100303    Umpqua
 17070201    Upper John Day                  17100304    Coos
 17070202    North Fork John Day             17100305    Coquille
 17070203    Middle Fork John Day            17100306    Sixes
 17070204    Lower John Day                  17100307    Upper Rogue

KLB                                                         5                                                06/20/2008
Species Table:
SpeciesID        Species Name                  Scientific Name        SpeciesID          Species Name                 Scientific Name
   AM       ammocoetes                 Petromyzontidae                   OC       Oregon chub                Oregonichthys crameri
   AS       Atlantic salmon            Salmo salar                      PGS       pacific giant salamander   Dicamptodon tenebrosus
  ATF       adult tailed frog          Ascaphus truei                    PK       pumpkinseed                Lepomis gibbosus
   BG       bluegill                   Lepomis macrochirus               PL       Pacific lamprey
  BLB       black bullhead             Ameiurus melas                    PM       peamouth                   Mylocheilus caurinus
   BR       brown trout                Salmo trutta                      PS       pink salmon                Oncorhynchus gorbuscha
  BRB       brown bullhead             Ameiurus nebulosus                RB       rainbow trout              Oncorhynchus mykiss
  BSU       bridgelip sucker           Catostomus columbianus            RO       roach
   BT       brook trout                Salvelinus confluentus           RSN       rough skin newt
  BTH       brook/bull hybrid          Salvelinus fontinalis x          RSS       redside shiner             Richardsonius balteatus
  BUT       bull trout                 Salvelinus confluentus            RT       redband trout              Oncorhynchus mykiss subsp.
    C       crappie                    Pomoxis sp                       RTS       reticulate sculpin         Cottus perplexus
   CC       channel catfish            Ictalurus punctatus              SAL       salamander
   CF       crayfish                                                     SB       smallmouth bass            Micropterus dolomieu
   CH       chinook salmon             Oncorhynchus tshawytscha          SF       salmonid fry (age 0+)
  CLM       chiselmouth                Acrocheilus alutaceus            SH        shiner spp.
   CO       coho salmon                Oncorhynchus kisutch             SKB       threespine stickleback     Gasterosteus aculeatus aculeatus
  COT       sculpin                    Cottus sp                        SNF       sunfish
   CP       carp                       Cyprinus sp                      SPD       speckled dace              Rhinichthys osculus
   CS       chum salmon                Oncorhynchus keta                SQ        northern pikeminnow        Ptychocheilus oregonensis
  CSU       largescale sucker          Catostomus rimiculus             SR        sandroller                 Percopsis transmontana
   CT       cutthroat trout            Oncorhynchus clarki clarki        SS       sockeye salmon             Oncorhynchus nerka
  CTH       cutthroat/rainbow hybrid   Oncorhynchus clarki x mykiss      ST       steelhead                  Oncorhynchus mykiss
    D       dace                       Cyprinidae                       SU        sucker
  FRG       frog (species unknown)                                       TC       tui chub                   Gila bicolor
  JSU       Jenny lake sucker          Catostomus rimiculus              TF       trout fry (age 0+)
  LAM       lamprey                    Petromyzontidae                  TFT       tailed frog tadpole        Ascaphus truei
   LB       largemouth bass            Micropterus salmoides              U       Unknown
  LND       longnose dace              Rhinichthys cataractae           US        unknown salmonid
   MF       mosquitofish               Gambusia sp                       UT       unknown trout
  MMS       Malheur mottled sculpin    Cottus bairdi bendirei           WF        mountain whitefish         Prosopium williamsoni
   MS       mottled sculpin            Cottus bairdii                     X       no fish found
  MSU       mountain sucker            Catostomus platyrhynchus          YP       yellow perch               Perca flavescens
    O       Other

KLB                                                                     6                                                              06/20/2008
Habitat Type Table:
 HabitatTypeID       HabitatType                                                           HabitatTypeDesc
A                Alcove                 Most protected type of subunit pool. Alcoves are laterally displaced from the general bounds of the active channel.
                                        Substrate is typically sand and organic matter. Formed during extreme flow events or by beaver activity; not scoured
                                        during typical high flows
BP               Beaver Dam Pool        Dammed pool formed by beaver activity
BW               Backwater Pool         Found along channel margins; created by eddies around obstructions such as boulders, root wads, or woody debris.
                                        Part of active channel at most flows; scoured at high flow. Substrate typically sand, gravel, and cobble
CB               Cascade over           Much of the exposed substrate composed of boulders organized into clusters, partial bars, or step-pool sequences.
                 Boulders               Fast, turbulent, flow; many hydraulic jumps, strong chutes, and eddies; 30-80% white water. High gradient; usually
                                        3.5-10.0% slope, sometimes greater
CR               Cascade over           Same flow characteristics as Cascade over Boulders but the structure is derived from sequence of bedrock steps.
                 Bedrock                Slope 3.5% or greater
DP               Dammed Pool            Water impounded upstream of channel blockage (debris jams, rock landslides).
GL               Glide                  An area with generally uniform depth and flow with no surface turbulence. Low gradient; 0-1 % slope. Glides may
                                        have some small scour areas but are distinguished from pools by their overall homogeneity and lack of structure.
                                        Generally deeper than riffles with few major flow obstructions and low habitat complexity. There is a general lack of
                                        consensus regarding the definition of glides (Hawkins et al. 1993)
IP               Isolated Pool          Pools formed outside the primary wetted channel, but within the active channel. Isolated pools are usually associated
                                        with gravel bars and may dry up or be dependent on inter-gravel flow during late summer. Substrate is highly
                                        variable. Isolated pool subunits do not include pools of ponded or perched water found in bedrock depressions
LP               Lateral Scour Pool     Formed by flow impinging against one stream bank or partial obstruction (logs, root wad, or bedrock). Asymmetrical
                                        cross section. Includes corner pools in meandering lowland or valley bottom streams
O                Other                  Other Habitat
PP               Plunge Pool            Formed by scour below a complete or nearly complete channel obstruction (logs, boulders, or bedrock). Substrate is
                                        highly variable. Frequently, but not always, shorter than the active channel width
RB               Rapid with protuding   Swift, turbulent flow including chutes and some hydraulic jumps swirling around boulders. Exposed substrate
                 Boulders               composed of individual boulders, boulder clusters, and partial bars. Moderate gradient; usually 2.0-4.0% slope,
                                        occasionally 7.0-8.0%
RI               Riffle                 Fast, turbulent, shallow flow over submerged or partially submerged gravel and cobble substrates. Generally broad,
                                        uniform cross section. Low gradient; usually 0.5-2.0% slope, rarely up to 6% Same flow and gradient as Riffle but
                                        with numerous sub-unit sized pools or pocket water created by scour associated with small boulders, wood, or
                                        stream bed dunes and ridges. Sub-unit sized pools comprise 20% or more of the total unit area
RP               Riffle with Pockets    Same flow and gradient as Riffle but with numerous sub-unit sized pools or pocket water created by scour
                                        associated with small boulders, wood, or stream bed dunes and ridges. Sub-unit sized pools comprise 20% or more
                                        of the total unit area
RR               Rapid over Bedrock     Swift, turbulent, "sheeting" flow over smooth bedrock. Sometimes called chutes. Little or no exposed substrate.
                                        Moderate to steep gradient; 2.0-30.0% slope
SP               Straight Scour Pool    Formed by mid-channel scour. Generally with a broad scour hole and symmetrical cross section.
TP               Trench Pool            Slow flow with U or V-shaped cross section typically flanked by bedrock walls. Often very long and narrow with at
                                        least half of the substrate comprised of bedrock
U                Unknown                Habitat Type is unknown

KLB                                                                         7                                                                   06/20/2008
Minimum Core Data Elements:
Electro-fishing surveys can be conducted at many different levels of effort and can include many data elements, or just a few, depending on the
protocol used. This template has been created based on survey protocols designed to conduct population estimates. Since we realize that some
entities will not have the need or desire to collect as much data, we propose the following list as minimum core data elements.

Minimum Data Elements:
Reach Number/Habitat Unit Number
Habitat Type (if applicable)
Survey Reach start/end latitude and longitude
Survey Reach Length
Date of Survey
Water Temperature (°C)
Pass Number
Species Observed
Number of fish caught (including mortalities)

KLB                                                                     8                                                             06/20/2008

To top