Department of Water Resources Home
IEP Banner

                                                               AFMTFISH
                                                               O1/31/95 crr
                                                               08/17/95 crr
                                                               09/20/95 och
 
            CALIFORNIA DEPARTMENT OF FISH AND GAME
 
           STRIPED BASS EGG AND LARVAE SURVEY (ELS)
               * * * FISH DENSITY DATA * * *
 
               ASCII FILE FORMAT DOCUMENTATION
 
           Contact:  Lee Miller, CDFG, (209)942-6107
 
 
 
         *========================================================*
         *                                                        *
         *    FISH DATA SETS AVAILABLE AND NAMING CONVENTIONS     *
         *                                                        *
         *========================================================*
 
EL93DJ       \
EL92DJ       -\
EL9091DJ     - >  EL8893DJ.SSD  8-11-95 7:13a
EL8889DJ     -/
 
EL86DJ       -\
EL8485DJ     - >  EL8486DJ.SSD  8-11-95 7:08
 
EL7577DJ     -\
EL7173DJ     - >  EL6777DJ.SSD  8-11-95 7:02a
EL6770DJ     -/
 
 
EL=Striped Bass Egg and Larval Study
D =Density data (number of organisms per cubic meter of river water.)
####= Years the data spans (8892=data from 1988-1992).
J= This data set includes estimated data. Estimated data are remarked with a
   'J' code in fields(variables) which end with '_rmk' (eg. bio_rmk).  Data
   are estimated when scheduled data could not be collected and were needed
   to calculate index values.
 
 
 
===== TABLE OF INDIVIDUAL FILE NAMES AND DESCRIPTIVE INFORMATION
 
============================================================================+
Support File Names:         � Format &      �               �               �
                            �Reference files� Created       �Last Update    �
                            +---------------+---------------+---------------+
                            � AFMTFISH      �01/17/95       �8/17/95        �
                            � AREFRKI       �12/28/94 11:24a�6/05/95 12:38p �
                            � AREFFISH      �01/17/95       �8/17/95  8:26a �
----------------------------+---------------+---------------+---------------+
 
 
============================================================================+
ASCII File Names �  Size  �# records�  # of   �max record�  Date  �  Date   �
                 � (bytes)�  (obs)  �variables�  length *� Created�Modified �
-----------------+--------+---------+---------+----------+--------+---------+
 EL93DJ          � 791,402�  2,601  �  105    �  396     �08/11/95�         �
 EL92DJ          � 853,817�  2,747  �  105    �  392     �01/18/95�08/11/95 �
 EL9091DJ        � 967,129�  2,991  �  105    �  383     �08/16/95�         �
 EL8889DJ        � 636,875�  1,929  �  105    �  389     �08/16/95�         �
 
 EL86DJ          � 393,208�  1,678  �   72    �  321     �01/30/95�08/11/95 �
 EL8485DJ        � 712,624�  3,088  �   72    �  307     �01/30/95�08/11/95 �
 
 EL7577DJ        � 776,263�  3,241  �   73    �  359     �01/24/95�08/11/95 �
 EL7173DJ        � 931,178�  3,957  �   73    �  342     �01/24/95�08/11/95 �
 EL6770DJ        � 888,784�  3,874  �   73    �  307     �01/24/95�08/11/95 �
-----------------+--------+---------+---------+----------+--------+---------+
Note: All files are sorted on field(variable) STATION
Note: All organism density values are rounded to the nearest 0.0001
      organisms per cubic meter of river water in the ASCII data sets.
      This is not true of the master SAS data sets. Differences due to
      rounding may occur when comparing calculations from SAS data
      sets and those created from the ASCII data sets.
 
* The maximum record length is the length of the longest record (line)
  in the data set formated as the DMC has requested the data (ie
  free format, comma separated etc.) The final line length in a specific
  software package will be much longer, and will depend on the specific
  software package. For example, the numeric variable MONTH can have a value
  of 1 thru 12. In the DMC ascii format it will take 2 or 3 spaces
  (1, or 12,). In SAS the variable MONTH has a length of 8.
 
 
 
============================+===============+===============+===============+
Master file information     �                                               �
----------------------------+---------------+---------------+---------------+
SAS File Name:              �EL6777DJ.SSD   �EL8486DJ.SSD   �EL8893DJ.SSD   �
SAS File Originally Created:�01/24/95  9:50a�01/24/95  2:02p�01/04/95  2:00p�
SAS File Last Modified:     �08/11/95  7:02a�08/11/95  7:08a�08/11/95  7:13a�
                            �               �               �               �
SAS Program For Structure:  �crtasc2f.sas   � crtasc3f.sas  �crtasc1f.sas   �
                            �spl_6777.sas   � spl_8486.sas  �spl_8893.sas   �
SAS Files For Structure:    �test2f.ssd     � test3f.ssd    �test1f.ssd     �
                            �               �               �               �
----------------------------+---------------+---------------+---------------+
DBMS Copy Version 4.0       � file format=free                              �
                            � variables names in row 1=no                   �
  Settings used to create   � numeric missing value string=""               �
  the ASCII files           � free format separator= ,                      �
                            � free format surround character = (blank)      �
                            � every field must be surrounded=no             �
----------------------------------------------------------------------------+
 
SAS DATA SET LOG OF MODIFICATIONS:
  8/95 changes: 1967-77 data set - STURG was renamed to STURGEON.
                1984-86 data set - SURVEY was created from YEAR MONTH DAY
                1988-93 data set - 1993 data was added
                1988-93 data set - TEMPF was corrected in 1992 data (39
                                   corrected to 69)
                1988-93 data set - remark code values "." (missing numeric
                                   string value) were replaced with a blank
                                   value " ".
 
 
   * ===============================================================*
   *                                                                *
   *              ALPHABETIC LIST OF VARIABLES AND ATTRIBUTES       *
   *                        ELS fish density data                   *
   * ===============================================================*
 
- includes variables from all three ELS fish SAS data sets (8 ascii files).
    The order and number of variables vary in the SAS data sets.
 
- see lists by data set for the order of the variables in the ascii files.
 
- see AREFFISH     for detailed taxonomic cross reference to fish
      variable names and codes for numeric code variables
 
Note: The MAXIMUM LENGTH for a character variable in the ASCII data files
      including the " " is calculated by adding 2 to the format value.
      The maximum length for a numeric variable is the non decimal portion
      of the format value.
 
 Variable  Type   Format   Label
 ----------------------------------------------------------------------------
 ANCHOVY   Num     8.4   Northern anchovy
 ASHAD     Num     8.4   American shad
 ASHADEGG  Num     8.4   American shad eggs
 ATHER     Num     8.4   Atherinidae family
 BAYGOBY   Num     8.4   Bay Goby
 BGSCLOGP  Num     8.4   Bigscale Logperch
 BIO_RMK   Char    1.    Remark code for biological data 'J'=estimated
 CENTR     Num     8.4   Centrarchidae family
 CHARGOBY  Num     8.4   Cheekspot & Arrow gobies (+1992)
 CYPRINID  Num     8.4   Cyprinidae family
 DATE      Num     8.    Date sample was collected (YYYYMMDD)
 DAY       Num     2.    Day of month sample was collected (dd)
 DEPTH     Num     3.1   Net depth in feet for sample collection
 DEPTH_B   Num     3.    Bottom depth in feet (new 1993)
 DLTSMELT  Num     8.4   Delta smelt larvae (new 1990)
 EC_BOT    Num     5.    BOTTOM  EC uS/cm at 25 C standard
 EC_B_RMK  Char    1.    Remark code for EC_BOT J=estimated datum
 EC_RMK    Char    1.    Remark code for EC_SURF J=estimated datum
 EC_SURF   Num     5.    SURFACE EC uS/cm at 25 C standard
 EL_RMK    Char    1.    Remark code for field EL_VOL J=estimated
 EL_VOL    Num    16.8   Egg and Larval net sample volume (cubic M)
 HERRING   Num     8.4   Herring            (new 1991)
 JULDAY    Num     3.    Calc from survey (no leap day)
 LAMPREY   Num     8.4   Lamprey family
 LFNSMELT  Num     8.4   Longfin smelt      (new 1990)
 LJ_MSUCK  Num     8.4   Longjaw mudsucker  (new 1992)
 MONTH     Num     2.    month the sample was collected (mm)
 NEODEN    Num     8.2   Total Neomysis density (round=.01)
 NEOLT6MM  Num     8.2   Density of Neomysis<6mm (round=.01)
 NEOLTPCT  Num     5.1   (neomysis lt 6mm/neomysis total)*100
 OTHEGG    Num     8.4   other eggs (not sb or a.shad)
 OTHLARV   Num     8.4   other larvae not identified
 RKI       Char   15.    River kilometer index
 SB03      Num     8.4   striped bass 3 mm standard length
 SB04      Num     8.4   striped bass 3.5-4.4 mm std length
 SB05      Num     8.4   striped bass 4.5-5.4 mm std length
 SB06      Num     8.4   striped bass 5.5-6.4 mm std length
 SB07      Num     8.4   striped bass 6.5-7.4 mm std length
 SB08      Num     8.4   striped bass 7.5-8.4 mm std length
 SB09      Num     8.4   striped bass 8.5-9.4 mm std length
 SB10      Num     8.4   striped bass 9.5-10.4 mm std length
 SB11      Num     8.4   striped bass 11 mm standard length
 SB12      Num     8.4   striped bass 12 mm standard length
 SB13      Num     8.4   striped bass 13 mm standard length
 SB14      Num     8.4   striped bass 14 mm standard length
 SB15      Num     8.4   striped bass 15 mm standard length
 SB16      Num     8.4   striped bass 16 mm standard length
 SB17      Num     8.4   striped bass 17 mm standard length
 SB18      Num     8.4   striped bass 18 mm standard length
 SB19      Num     8.4   striped bass 19 mm standard length
 SB20      Num     8.4   striped bass 20 mm standard length
 SB21      Num     8.4   striped bass 21 mm standard length
 SB22      Num     8.4   striped bass 22 mm standard length
 SB23      Num     8.4   striped bass 23 mm standard length
 SB24      Num     8.4   striped bass 24 mm standard length
 SB25      Num     8.4   striped bass 25 mm standard length
 SB26      Num     8.4   striped bass 26 mm standard length
 SB27      Num     8.4   striped bass 27 mm standard length
 SB28      Num     8.4   striped bass 28 mm standard length
 SB29      Num     8.4   striped bass 29 mm standard length
 SB30      Num     8.4   striped bass 30 mm standard length
 SB31      Num     8.4   striped bass 31 mm standard length
 SB32      Num     8.4   striped bass 32 mm standard length
 SB33      Num     8.4   striped bass 33 mm standard length
 SB34      Num     8.4   striped bass 34 mm standard length
 SB35      Num     8.4   striped bass 35 mm standard length
 SB36      Num     8.4   striped bass 36 mm standard length
 SB37      Num     8.4   striped bass 37 mm standard length
 SB38      Num     8.4   striped bass 38 mm standard length
 SB39      Num     8.4   striped bass 39 mm standard length
 SB40      Num     8.4   striped bass 40 mm standard length
 SB41      Num     8.4   striped bass 41 mm standard length
 SB42      Num     8.4   striped bass 42 mm standard length
 SB43      Num     8.4   striped bass 43 mm standard length
 SB44      Num     8.4   striped bass 44 mm standard length
 SB45      Num     8.4   striped bass 45 mm standard length
 SB46      Num     8.4   striped bass 46 mm standard length
 SB47      Num     8.4   striped bass 47 mm standard length
 SB48      Num     8.4   striped bass 48 mm standard length
 SB49      Num     8.4   striped bass 49 mm standard length
 SB50      Num     8.4   striped bass 50 mm standard length
 SB51      Num     8.4   striped bass 51 mm standard length
 SB52      Num     8.4   striped bass 52 mm standard length
 SBDEGG    Num     8.4   striped bass eggs dead
 SBJUV     Nun     8.4   striped bass juvenile
 SBOEGG    Num     8.4   striped bass eggs 9-36 hours
 SBPYSAC   Num     8.4   striped bass post yolk sac
 SBYEGG    Num     8.4   striped bass eggs 0-8 hrs
 SBYSAC    Num     8.4   striped bass yolk sac
 SCULPIN   Num     8.4   Cottidae family
 SECCHI    Num     4.2   Depth in METERS secchi reading
 SEC_RMK   Char    1.    Remark code for field SECCHI J=estimated
 SHIMGOBY  Num     8.4   Shimo furi goby     (new 1991)
 STATION   Char    3.    Sample station
 STF       Num     8.4   Starry flounder
 STICKLE   Num     8.4   Three spine Stickleback
 STIME     Num     4.    Starting time for sample tow-24 hr clock
 STURGEON  Num     8.4   Acipenser sp.
 SUBSAMP   Char    1.    The fraction of sample counted (4=1/4)
 SURVEY    Char    6.
 TEMPF     Num     8.1   Temperature degrees F of the river water
 TEMP_RMK  Char    1.    Remark code for field TEMPF J=estimated
 TFINSHAD  Num     8.4   Threadfin Shad
 TIDE      Char    1.    Code for tidal phase
 TOW_DUR   Num     2.    Duration of the sample tow - minutes
 TURBID    Num     3.    Turbidity (Jackson Turbidity units)
 TURB_RMK  Char    1.    Remark code for TURBID
 UNKCLUP   Num     8.4   Clupedae not identified to species
 UNKGOBY   Num     8.4   Gobidae not id to species (new 1991)
 UNKSMELT  Num     8.4   smelt not id to species   (new 1990)
 YEAR      Num     4.    Year the sample was collected (yyyy)
 YF_GOBY   Num     8.4   Yellowfin Goby            (new 1991)
 
 
 
        *==========================================================*
        *          LIST OF VARIABLES IN POSITION ORDER             *
        *           ELS fish ASCII data files                      *
        *==========================================================*
                                                   EL93DJ
 EL7577DJ                   EL8485DJ               EL92DJ
 EL7173DJ                   EL86DJ                 EL9091DJ
 EL6770DJ                                          EL8889DJ
 
  #  Variable  Type        #  Variable  Type       #  Variable  Type
 
 01  RKI       Char       01  RKI       Char      01  RKI       Char
 02  STATION   Char       02  STATION   Char      02  STATION   Char
 03  DATE      Num        03  DATE      Num       03  DATE      Num
 04  STIME     Num        04  STIME     Num       04  STIME     Num
 05  DEPTH     Num        05  DEPTH     Num       05  DEPTH     Num
 06  BIO_RMK   Char       06  BIO_RMK   Char      06  BIO_RMK   Char
 07  TEMP_RMK  Char       07  TEMP_RMK  Char      07  EL_RMK    Char
 08  TURB_RMK  Char       08  SEC_RMK   Char      08  TEMP_RMK  Char
 09  SEC_RMK   Char       09  EC_RMK    Char      09  SEC_RMK   Char
 10  EC_RMK    Char       10  YEAR      Num       10  EC_RMK    Char
 11  SBYEGG    Num        11  MONTH     Num       11  EC_B_RMK  Char
 12  SBOEGG    Num        12  DAY       Num       12  TIDE      Char
 13  SBDEGG    Num        13  EL_VOL    Num       13  MONTH     Num
 14  SB03      Num        14  SUBSAMP   Num       14  DAY       Num
 15  SB04      Num        15  ASHAD     Num       15  YEAR      Num
 16  SB05      Num        16  TFINSHAD  Num       16  SECCHI    Num
 17  SB06      Num        17  UNKCLUP   Num       17  TEMPF     Num
 18  SB07      Num        18  ASHADEGG  Num       18  TOW_DUR   Num
 19  SB08      Num        19  UNKSMELT  Num       19  EC_SURF   Num
 20  SB09      Num        20  STF       Num       20  EC_BOT    Num
 21  SB10      Num        21  CYPRINID  Num       21  SUBSAMP   Num
 22  SB11      Num        22  CENTR     Num       22  ASHADEGG  Num
 23  SB12      Num        23  UNKGOBY   Num       23  OTHEGG    Num
 24  SB13      Num        24  ATHER     Num       24  SBYEGG    Num
 25  SB14      Num        25  OTHLARV   Num       25  SBOEGG    Num
 26  SB15      Num        26  SBYEGG    Num       26  SBDEGG    Num
 27  SB16      Num        27  SBOEGG    Num       27  ASHAD     Num
 28  SB17      Num        28  SBDEGG    Num       28  CENTR     Num
 29  SB18      Num        29  SB03      Num       29  SCULPIN   Num
 30  SB19      Num        30  SB04      Num       30  SHIMGOBY  Num
 31  SB20      Num        31  SB05      Num       31  UNKGOBY   Num
 32  SB21      Num        32  SB06      Num       32  DLTSMELT  Num
 33  SB22      Num        33  SB07      Num       33  TFINSHAD  Num
 34  SB23      Num        34  SB08      Num       34  ATHER     Num
 35  SB24      Num        35  SB09      Num       35  ANCHOVY   Num
 36  SB25      Num        36  SB10      Num       36  YF_GOBY   Num
 37  SB26      Num        37  SB11      Num       37  OTHLARV   Num
 38  SB27      Num        38  SB12      Num       38  LFNSMELT  Num
 39  SB28      Num        39  SB13      Num       39  HERRING   Num
 40  SB29      Num        40  SB14      Num       40  CYPRINID  Num
 41  SB30      Num        41  SB15      Num       41  STF       Num
 42  SB31      Num        42  SB16      Num       42  BAYGOBY   Num
 43  SB32      Num        43  SB17      Num       43  UNKSMELT  Num
 44  SB33      Num        44  SB18      Num       44  UNKCLUP   Num
 45  SB34      Num        45  SB19      Num       45  BGSCLOGP  Num
 46  SB35      Num        46  SB20      Num       46  LJ_MSUCK  Num
 47  SB36      Num        47  SB21      Num       47  CHARGOBY  Num
 48  SB37      Num        48  SB22      Num       48  SB04      Num
 49  SB38      Num        49  SB23      Num       49  SB05      Num
 50  ANCHOVY   Num        50  SB24      Num       50  SB06      Num
 51  ASHADEGG  Num        51  SB25      Num       51  SB07      Num
 52  UNKCLUP   Num        52  SB26      Num       52  SB08      Num
 53  CYPRINID  Num        53  SB27      Num       53  SB09      Num
 54  UNKGOBY   Num        54  SB28      Num       54  SB10      Num
 55  LAMPREY   Num        55  SB29      Num       55  SB11      Num
 56  STICKLE   Num        56  SB30      Num       56  SB12      Num
 57  SCULPIN   Num        57  SB31      Num       57  SB13      Num
 58  UNKSMELT  Num        58  SB32      Num       58  SB14      Num
 59  STF       Num        59  SB33      Num       59  SB15      Num
 60  STURGEON  Num        60  SB34      Num       60  SB16      Num
 61  NEODEN    Num        61  SB35      Num       61  SB17      Num
 62  NEOLT6MM  Num        62  SB36      Num       62  SB18      Num
 63  EC_SURF   Num        63  SB37      Num       63  SB19      Num
 64  SECCHI    Num        64  SB38      Num       64  SB20      Num
 65  TURBID    Num        65  SCULPIN   Num       65  SB21      Num
 66  TEMPF     Num        66  ANCHOVY   Num       66  SB22      Num
 67  EL_VOL    Num        67  OTHEGG    Num       67  SB23      Num
 68  JULDAY    Num        68  JULDAY    Num       68  SB24      Num
 69  YEAR      Num        69  EC_SURF   Num       69  SB25      Num
 70  MONTH     Num        70  SECCHI    Num       70  SB26      Num
 71  DAY       Num        71  TEMPF     Num       71  SB27      Num
 72  NEOLTPCT  Num        72  SURVEY    Char      72  SB28      Num
 73  SURVEY    Char                               73  SB29      Num
                                                  74  SB30      Num
                                                  75  SB31      Num
                                                  76  SB32      Num
                                                  77  SB33      Num
                                                  78  SB34      Num
                                                  79  SB35      Num
                                                  80  SB36      Num
                                                  81  SB37      Num
                                                  82  SB38      Num
                                                  83  SB39      Num
                                                  84  SB40      Num
                                                  85  SB41      Num
                                                  86  SB42      Num
                                                  87  SB43      Num
                                                  88  EL_VOL    Num
                                                  89  JULDAY    Num
                                                  90  SB03      Num
                                                  91  SBYSAC    Num
                                                  92  SBPYSAC   Num
                                                  93  SBJUV     Num
                                                  94  DEPTH_B   Num *  new
                                                  95  STURGEON  Num *  or
                                                  96  SB44      Num *  returning
                                                  97  SB45      Num *  variable
                                                  98  SB46      Num *  for
                                                  99  SB47      Num *  1993
                                                 100  SB48      Num *  data
                                                 101  SB49      Num *
                                                 102  SB50      Num *
                                                 103  SB51      Num *
                                                 104  SB52      Num *
                                                 105  SURVEY    Char
 
********************* end of the file *************************************