Department of Water Resources Home
IEP Banner

Tagging - Data File Format


  File Format for File(s) of Program Element: Sturgeon Tagging
 
     Program manager
          Name:     David Kohlhorst
          Agency:   Department of Fish and Game
          Address:  4001 N. Wilson Way
                    Stockton, CA 95205-2424
          Phone:    (209) 948-7800
 
 
1.Individual file name(s):    a.) TAG7484
                              b.) TAG8593                                                           
2.Date of creation of data files (last update): 05/18/95
 
3.Size of file(s) in bytes:   a.) 600 KB 
                              b.) 590 KB
 
4.Maximum record length (width of file): 92
 
5.Structure of file (format/legend/header): 
a.) number of variables: 27 
b.) number of records:   a.)4689
                         b.)4634   
c.) variable names, formats, and lengths: 
 
Field Field Name    Type Width Decimal  Comments

 1   RKI            Char 8              LSBB08 - Suisun Bay
                                        LSPC09 - San Pablo Bay
 2   STATION        Char 3              same as REL_LOC
 3   DATE           Date 8              Release date   
 4   TIME           Char 4              Release time
 5   DEPTH          Num  2
 6   TAG_NO         Char 7              Tag number
 7   REL_DATE       Num  7              Release date
 8   REL_LOC        Char 3              Release location: 7 = Suisun Bay,
                                        10 = San Pablo Bay
 9   REL_CM         Char 2              Release capture method:
                                        1 = Trammel net
10   TAGGER         Char 3              See table of taggers (REFTAGR)
11   SPECIES        Char 2              2 = White Sturgeon, 3 = Green S.
12   TAG_CODE       Char 1              See table of tag codes below
13   REL_TL         Num  3              Total length at tagging in cm
14   REWARD         Num  2              Dollar amount for reward; 
                                        except 1984 when 21 = $20 tags
                                        released at same time as $10 tags
15   REL_COND       Char 1              Release condition: 
                                        1 = good, 2 = poor
16   OTC            Num  5    1         Amount of oxytetracycline injected 
                                        at tagging in ml
17   REC_DATE       Num  6              Recapture date
18   REC_LOC        Char 2              Location of Recapture (see table)
19   D_N            Char 1              Daytime: 1 = day, 2 = night
20   REC_METH       Char 1              Recapture method (see table below)
21   REC_TL         Num  3              Total length reported at recapture
                                        in cm
22   RET_YR         Num  2              Return year: 1 = returned within
                                        one year of tagging, 2 = returned
                                        in 2nd year after tagging, etc.
23   YR_RETD        Char 2              Calendar year of recapture
24   MESH_SIZE      Num  1              Stetched-mesh size of gill webbing
                                        in trammel net used to capture fish 
                                        for tagging
25   RET_MONTH      Char 2              Month of recapture
26   SEASON         Char 8              See table of seasons
27   REL_YR         Char 2              Calendar year when fish was tagged
 
 
Table of Tagger Codes
see AREFTAGR
 
 
Table of Tag Codes
 1 - Single (no oxytetracycline)
 2 - Double (1984 & 85 with oxytetracycline)
 3 - Single released at same time as double (1984 & 85)
 4 - Single injected with oxytetracycline
 5 - Single surgically examined and sutured
 6 - Single sutured and injected with oxytetracycline
 7 - Single first pectoral fin ray removed (1974)
 4 - With TC 
 
 
Table of Recapture Locations
 1 - Lower San Joaquin Delta
 2 - Upper San Joaquin Delta
 3 - San Joaquin River above Mossdale
 4 - Lower Sacramento Delta
 5 - Sacramento River: Courtland to Feather River
 6 - Northeast Delta
 7 - Suisun Bay
 8 - Suisun Marsh
 9 - Carquinez Strait
10 - San Pablo Bay
11 - Napa River and Marsh
12 - North San Francisco Bay
13 - Pacific Ocean
14 - Unknown
15 - Petaluma Creek and Marsh
16 - Tomales Bay
17 - South San Francisco Bay
18 - San Francisco Bay
19 - Sacramento River above Feather River
20 - Feather River
21 - Oregon 
22 - Washington
 
 
Table of Recapture Method
 1 - Party boat
 2 - Private boat (Skiff)
 3 - Shore
 4 - Dead
 5 - Commercial gear
 
 
Table of Season Codes
 a_Fall   - September through November
 b_Winter - December through February
 c_Spring - March through May
 d_Summer - June through August