Department of Water Resources Home
IEP Banner

File Format for 1994 Delta Agricultural Diversion Evaluation, Egg & Larval Sampling.

1.  File names:  1) el94fd=egg & larval 1994 field data; 
                 2) el94m3=egg & larval 1994 density in meters cubed; 
                 3) el 94af=egg & larval 1994 density in acre feet; 
                 4) el94len=egg & larval 1994 length.

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

3.  Size of file in bytes:  csv:   1) el94fd=14,929 
				   2) el94m3=12,610 
                                   3) el94af=12,393 
				   4) el94len=8,613.                          

4.  Width of file:  1) el94fd=219; 2) el94m3=193; 3) el94af=193; 
                    4) el94len=137.

5.  Structure of el94fd file:

     a.)  number of variables:  36.
     b.)  number of records:  84.
     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of el94fd, "egg & larval 1994 field 
                    data" file. 

VARIABLE     COLUMN  DESCRIPTION
	      WIDTH

1) RKI            2  River Kilometer Index.
2) Station        4  1=Twitchell Island, 16' outfall pipe; 
                     2=Bacon Island, 16" outfall pipe.
3) Date           8  Year, month, day.
4) Time           5  Pacific Standard Time (PST).
		      Military time format.  
		      Example:  0 = midnight
			       10 = ten minutes after midnight
			     1300 = 1 pm			
5) Depth	  2  Not recorded.
6) Lat/Long      30  degrees minutes seconds (decimal)/degrees minutes seconds (decimal)         
		    *"38 05 26.406/121 38 18.558"; 1=Twitchell Island, 
                     San Joaquin River, south side of Twitchell Island at
		     Oulton Point. 
                    *"37 59 11.423/1210 32 06.065"; 2=Bacon Island, east side
                     of island on Middle River at windmill, north of temporary 
                     barriers project area. 
7) EC             5  Surface specific conductance.
8) Temperature    5  Water temperature recorded in degrees Fahrenheit.
9) Volume Sampled 6  Volume of water measured through net in meters cubed (m3).
10) Flow readings 5  Flow readings from the siphon recorded as cubic feet per 
                     second (cfs).
11) Sampled Volume   Volume of water measured through the siphon recorded in 
                     acre feet (AF).  
                       Column 5 characters wide.
12) Fish Screen   3  0=none; 1=on-down; 2=off-up.

*13 through 36 are numbers of individual species caught.  All columns are 4 
 characters wide.

13) AS Egg      American Shad egg.
14) X Egg       All other species of eggs except American Shad and Striped Bass.
15) Morula      Striped Bass egg, morula. 
16) Early Emby  Striped Bass egg, early  embryo. 
17) Late Emby   Striped Bass egg, late embryo. 
18) SBD Egg     Striped Bass dead egg. 
19) AS-7        American Shad. 
20) TFS-8       Threadfin Shad. 
21) LFS-25      Longfin Smelt. 
22) DS-26       Delta Smelt. 
23) ISS-31      Inland Silverside. 
24) STF-32      Starry Flounder.
25) NA-90       Northern Anchovy. 
26) CYPRIN-90   Cyprinid. 
27) SPT-9       Splittail. 
28) CENTR-90    Centrarchid. 
29) PSC-29      Prickly Sculpin.
30) LP-23       Bigscale Logperch. 
31) CF-56       All catfish species. 
32) SSU-50      Sacramento Sucker. 
33) YFG-30      Yellowfin Goby. 
34) CG-61       Chameleon Goby. 
35) SB-3        Striped Bass. 
36) OTHER-90    Species not listed, miscellaneous, explained in field data 
                 comments.                     
37) Comments    Information collected during sample and species breakdown. 
                  Column 31 characters wide.

5.  Structure of el94m3 file:

     a.)  number of variables:  30.
     b.)  number of records:  84.
 
     c., d. & e.)  Variable names, variable format and variable length:
                   Starting with column 1 of el94m3, "egg & larval 1994 density
                   in meters cubed" file.

VARIABLE     COLUMN  DESCRIPTION
	      WIDTH

1) RKI            2  River Kilometer Index.
2) Station        4  1=Twitchell Island, 16' outfall pipe; 
                     2=Bacon Island, 16" outfall pipe.
3) Date           8  Year, month, day.
4) Time           5  Pacific Standard Time (PST).
		     Military time format.  
		     Example:  0 = midnight
  		              10 = ten minutes after midnight
		            1300 = 1 pm			
5) Depth	  2  Not recorded.
6) Lat/Long      30  degrees minutes seconds (decimal)/degrees minutes seconds (decimal) 
	            *"38 05 26.406/121 38 18.558"; 1=Twitchell Island, 
                     downstream of light 35 opposite Fishermans Cut. 
                    *"37 59 11.423/121 32 06.065"; 2=Bacon Island, east side
                     of island on Middle River at windmill, north of temporary 
                     barriers project area. 
7) Volume Sampled 6  Volume of water measured through net in meters cubed (m3).

*8 through 31 are densities for individual species caught, recorded per meters 
 cubed (m3).  All columns are 6 characters wide. 

8) AS Egg       American Shad egg. 
9) X Egg        All other species of eggs except American Shad and Striped Bass.
10) Morula      Striped Bass egg, morula.   
11) Early Emby  Striped Bass egg, early  embryo.
12) Late Emby   Striped Bass egg, late embryo.
13) SBD Egg     Striped Bass dead egg. 
14) AS-7        American Shad. 
15) TFS-8       Threadfin Shad. 
16) LFS-25      Longfin Smelt. 
17) DS-26       Delta Smelt.
18) ISS-31      Inland Silverside.
19) STF-32      Starry Flounder. 
20) NA-90       Northern Anchovy. 
21) CYPRIN-90   Cyprinid. 
22) SPT-9       Splittail. 
23) CENTR-90    Centrarchid. 
24) PSC-29      Prickly Sculpin. 
25) LP-23       Bigscale Logperch. 
26) CF-56       All catfish species. 
27) SSU-50      Sacramento Sucker. 
28) YFG-30      Yellowfin Goby. 
29) CG-61       Chameleon Goby. 
30) SB-3        Striped Bass. 
31) OTHER-90    Species not listed, miscellaneous, explained in field data 
                  comments.                     

5.  Structure of el94af file:

     a.)  number of variables:  30.
     b.)  number of records:  84.
 
     c., d., & e.)  Variable names, variable format and variable length: 
                    Starting with column 1 of el94af, "egg & larval 1994 density
                    in acre feet" file.     

VARIABLE     COLUMN  DESCRIPTION
	      WIDTH

1) RKI            2  River Kilometer Index.
2) Station        4  1=Twitchell Island, 16' outfall pipe; 
                     2=Bacon Island, 16" outfall pipe.
3) Date           8  Year, month, day.
4) Time           5  Pacific Standard Time (PST).
                     Military time format.  
	             Example:  0 = midnight
		     	      10 = ten minutes after midnight
		     	    1300 = 1 pm			
5) Depth	  2  Not recorded.
6) Lat/Long      30  degrees minutes seconds (decimal)/degrees minutes seconds (decimal) 
	            *"38 05 26.406/121 38 18.558"; 1=Twitchell Island, 
                     downstream of light 35 opposite Fishermans Cut. 
                    *"37 59 11.423/121 32 06.065"; 2=Bacon Island, east side
                     of island on Middle River at windmill, north of temporary 
                     barriers project area. 
7) Sampled Volume 6  Volume of water measured through the siphon recorded in 
                     acre feet (AF).

*8 through 31 are densities for individual species caught, recorded per acre 
 feet (AF).  All columns are 6 characters wide.

8) AS Egg       American Shad egg. 
9) X Egg        All other species of eggs except American Shad and Striped Bass.
10) Morula      Striped Bass egg, morula.
11) Early Emby  Striped Bass egg, early  embryo.
12) Late Emby   Striped Bass egg, late embryo.
13) SBD Egg     Striped Bass dead egg.
14) AS-7        American Shad.
15) TFS-8       Threadfin Shad.
16)  LFS-25     Longfin Smelt.
17) DS-26       Delta Smelt.
18) ISS-31      Inland Silverside.
19) STF-32      Starry Flounder.
20) NA-90       Northern Anchovy. 
21) CYPRIN-90   Cyprinid. 
22) SPT-9       Splittail.
23) CENTR-90    Centrarchid. 
24) PSC-29      Prickly Sculpin. 
25) LP-23       Bigscale Logperch.
26) CF-56       All catfish species. 
27) SSU-50      Sacramento Sucker. 
28) YFG-30      Yellowfin Goby.
29) CG-61       Chameleon Goby.
30) SB-3        Striped Bass.
31) OTHER-90    Species not listed, miscellaneous, explained in field data 
                  comments.                     

5.  Structure of el94len file:

     a.)  number of variables:  23.
     b.)  number of records:  81.
 
     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of el94len, "egg & larval 1994 
                    length" file.  

VARIABLE     COLUMN  DESCRIPTION
	      WIDTH

1) RKI            2  River Kilometer Index.
2) Station        4  1=Twitchell Island, 16' outfall pipe; 
                     2=Bacon Island, 16" outfall pipe.
3) Date           8  Year, month, day.
4) Time           5  Pacific Standard Time (PST).
		     Military time format.  
		     Example:  0 = midnight
			      10 = ten minutes after midnight
			    1300 = 1 pm			
5) Depth	  2  Not recorded.
6) Lat/Long      30  degrees minutes seconds (decimal)/degrees minutes seconds (decimal)   
	            *"38 05 26.406/121 38 18.558"; 1=Twitchell Island, 
                     downstream of light 35 opposite Fishermans Cut. 
                    *"37 59 11.423/121 32 06.065"; 2=Bacon Island, east side
                     of island on Middle River at windmill, north of temporary 
                     barriers project area. 
7) Species code   8  CG-61=Chameleon Goby; CP-14=Carp; GS-13=Golden Shiner; 
                     LMB-22=Largemouth Bass; LP-23=Bigscale Logperch;
                     PSC-29=Prickly Sculpin; SB-3=Striped Bass; 
                     TFS-8=Threadfin Shad; YFG-30=Yellowfin Goby;         
                     OTHER-90=Miscellaneous species not listed separately.
8) Count #        3  The number of certain fish species caught in a sample.
9) Measure #      3  The number of a certain fish species measured in a sample.
10 through 23)    5  Length 1 through length 18.  Total lengths (TL) were 
                     measured to the nearest millimeter (mm). 
24) Comments     10  Information collected during sample and species breakdown.

6.  Reference to REF table:  1) Gear type used;  2) Screen codes and type used;  
                             3) Species codes.