Department of Water Resources Home
IEP Banner

File Format for Delta Egg and Larval Entrainment Study, 1988-1994

1. File names:  
     1) el1988 = 1988 field data and egg and larval densities
     2) el1989 = 1989 field data and egg and larval densities
     3) el1990 = 1990 field data and egg and larval densities
     4) el1991 = 1991 field data and egg and larval densities
     5) el1992 = 1992 field data and egg and larval densities
     6) el1993 = 1993 field data and egg and larval densities
     7) el1994 = 1994 field data and egg and larval densities
     8) el1995 = 1995 field data and egg and larval densities

2.   Last update of  data files:  12-19-95.

3.   Size of file in bytes:  
     1) el1988 = 1988 field data and egg and larval densities = 69660 
     2) el1989 = 1989 field data and egg and larval densities = 53839
     3) el1990 = 1990 field data and egg and larval densities = 46797
     4) el1991 = 1991 field data and egg and larval densities = 48449
     5) el1992 = 1992 field data and egg and larval densities = 124977
     6) el1993 = 1993 field data and egg and larval densities = 136038
     7) el1994 = 1994 field data and egg and larval densities = 129411
     8) el1995 = 1995 field data and egg and larval densities = 45679

4.   Width of file:  
     1) el1988 = 515
     2) el1989 = 515
     3) el1990 = 515
     4) el1991 = 515
     5) el1992 = 515
     6) el1993 = 515
     7) el1994 = 515
     8) el1995 = 515

5.   Structure of each file:

a.)  number of variables: 

     1) el1988 = 71
     2) el1989 = 71
     3) el1990 = 71
     4) el1991 = 71
     5) el1992 = 71
     6) el1993 = 71
     7) el1994 = 71
     8) el1995 = 71

b.)  number of records:  

     1) el1988 = 305
     2) el1989 = 241
     3) el1990 = 212
     4) el1991 = 234
     5) el1992 = 595
     6) el1993 = 662
     7) el1994 = 537
     8) el1995 = 251

c., d. & e.)  variable names, variable format, variable length:  

1) RKI         River Kilometer Index.  Column maximum 9 characters wide.

2) Station     Column 3 characters wide.

               Station 49 - Twitchell Is.
               Station 91 - Old River
               Station 92 - SWP (West Canal)
               Station 93 - Old River
               Station 94 - Grant Line
               Station 95 - North Canal
               Station 96 - CVP (Old River)
               Station 98 - Salmon Slough
               Station 930 - Holland Cut
               Station 718 - Lindsey Slough 
               Station 719 - Lindsey Slough
               Station 720 - Barker Slough
               Station 721 - Barker Slough
               Station 931 - Rock Slough
               Station 932 - Middle River at Bacon Is.
               Station 933 - Turner Cut
               Station 934 - Twitchell Is.   

     NOT IN FIELD FILES - LONGITUDE/LATITUDE
            Station 49 - Twitchell Is.     121 38 45/38 05 30
            Station 91 - Old River    121 34 30/37 52 30 
            Station 92 - SWP (West Canal)    121 33 15/37 49 45
            Station 93 - Old River    121 32 00/37 48 30
            Station 94 - Grant Line   121 31 00/37 49 00 
            Station 95 - North Canal    121 33 00/37 51 45    
            Station 96 - CVP (Old River)    121 33 15/37 49 15 
            Station 98 - Salmon Slough    121 26 00/37 49 00
            Station 930 - Holland Cut  121 35 00/38 01 30 
            Station 931 - Rock Slough  121 36 30/37 58 30
            Station 932 - Middle River   121 32 00/37 59 30 
            Station 933 - Turner Cut  121 28 30/37 58 30
            Station 934 - Twitchell Is.  121 40 15/38 05 45  
          

3) Date        Year, month, day.  Column 8 characters wide.
4) Time        Pacific Standard Time (PST).  Column 4 characters wide.
               Military time format.
	       Example:  0 = midnight
		        10 = ten minutes after midnight
		      1300 = 1 pm
5) Depth       Feet. Column 2 characters wide.
6) Tow length  Minutes.  Column 2 characters wide.
7) EC          Surface specific conductance.  Column 4 characters wide.
8) Secchi      Centimeters. Column 3 characters wide.
9) Temperature Water temperature recorded in degrees Fahrenheit.  Column 4 
	       characters wide.
10) Tide        
               1- high slack
               2- ebb
               3- low slack
               4- flood
               Column 1 character wide.
11) Volume Sampled      Volume of water measured through net in meters cubed.  
		        Column 9 characters wide. 

The following variables are maximum 7 characters wide.

12) AS Egg           	American Shad egg.  
13) X Egg      	     	All other species of eggs except American Shad 
			and Striped Bass. 
14) Morula           	Striped Bass egg, morula.  
15) Early Emby 		Striped Bass egg, early  embryo. 
16) Late Emby  		Striped Bass egg, late embryo.  
17) SBD Egg      	Striped Bass dead egg.  
18) AS-7       		American Shad.  
19) TFS-8      		Threadfin Shad.  
20) LFS-25   		Longfin Smelt.  
21) DS-26      		Delta Smelt. 
22) ISS-31      	Inland Silverside. 
23) STF-32       	Starry Flounder. 
24) NA-90      		Northern Anchovy. 
25) CYPRIN-90  		Cyprinid. 
26) SPT-9      		Splittail.  
27) CENTR-90   		Centrarchid. 
28) PSC-29       	Prickly Sculpin.
29) LP-23      		Bigscale Logperch.  
30) CATF-56   		All catfish species.  
31) SSU-50          	Sacramento Sucker. 
32) YFG-30          	Yellowfin Goby.  
33) CG-61      		Chameleon Goby. 
34) SB-3       		Striped Bass.  
35) OTHER-90   		Species not listed, miscellaneous, explained 
			in field data comments.  
36) MM3        		Striped bass 3mm long.  
37) MM4        		Striped bass 4mm long.  
38) MM5        		Striped bass 5mm long.  
39) MM6        		Striped bass 6mm long. 
40) MM7        		Striped bass 7mm long.  
41) MM8        		Striped bass 8mm long.  
42) MM9        		Striped bass 9mm long.  
43) MM10       		Striped bass 10mm long.  
44) MM11       		Striped bass 11mm long.  
45) MM12       		Striped bass 12mm long.  
46) MM13       		Striped bass 13mm long.  
47) MM14       		Striped bass 14mm long.  
48) MM15       		Striped bass 15mm long.  
49) MM16       		Striped bass 16mm long.  
50) MM17       		Striped bass 17mm long.  
51) MM18       		Striped bass 18mm long.  
52) MM19       		Striped bass 19mm long.  
53) MM20       		Striped bass 20mm long.  
54) MM21       		Striped bass 21mm long.  
55) MM22       		Striped bass 22mm long.  
56) MM23       		Striped bass 23mm long.  
57) MM24       		Striped bass 24mm long.  
58) MM25       		Striped bass 25mm long.  
59) MM26       		Striped bass 26mm long.  
60) MM27       		Striped bass 27mm long.  
61) MM28       		Striped bass 28mm long.  
62) MM29       		Striped bass 29mm long.  
63) MM30       		Striped bass 30mm long.  
64) MM31       		Striped bass 31mm long.  
65) MM32       		Striped bass 32mm long.  
66) MM33       		Striped bass 33mm long.  
67) MM34       		Striped bass 34mm long.  
68) MM35       		Striped bass 35mm long.  
79) MM36       		Striped bass 36mm long.  
70) MM37       		Striped bass 37mm long.  
71) MM38       		Striped bass 38mm long.