Department of Water Resources Home
IEP Banner

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

1.  File names:  1) el92fd=egg & larval 1992 field data; 
                 2) el92m3=egg & larval 1992 density in meters cubed; 
                 3) el92len=egg & larval 1992 length.

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

3.  Size of file in bytes:  csv:  1) el92fd=44,117 
				  2) el92m3=36,259 
                                  3) el92len=31,313.

4.  Width of file:  1) el92fd=177; 2) el92m3=199; 3) el92len=184.

5.  Structure of el92fd:

     a.)  number of variables:  37.

     b.)  number of records:  226.

     c., d., & e.) Variable names, variable format and variable length:  
                   Starting with column 1 of el92fd, "egg & larval 1992 
                   field data" file. 

VARIABLE      COLUMN  DESCRIPTION
	       WIDTH

1) RKI             4  River Kilometer Index.
2) Station         4  1=Twitchell Island 14" outfall pipe; 
                      2=Bacon Island, 16" outfall pipe; 
                      3=McDonald Tract, 12" outfall pipe; 
                      4=Naglee Burk Irrigation District, 20" 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 46.899/121 37 57.967"; 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.  
                      *"37 58 40.740/121 28 32.163"; 3=McDonald Tract, on 
                       southeastern side of McDonald Tract adjacent to Turner 
                       Cut.
                      *"37 46 55.484/121 29 00.939"; 4=Naglee Burk Irrigation
                       District, on Old River upstream of the temporary barrier 
                       site near Tracy Pumping Plant.
7) EC              5   Surface specific conductance.
8) Temperature     5   Water temperature recorded in degrees Celsius.
                         Column 5 characters wide.
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 5   Volume of water measured through the siphon in acre feet 
                       (AF).
12) Water measurement  Recorded in acre feet=AF or gallons=GAL.
                         Column 5 characters wide.
13) Fish Screen    3   0=none; 1=on-down; 2=off-up.

*Columns 14 through 38 are numbers of individual species caught. All columns are 
 4 characters wide.

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

5.  Structure of el92m3:

     a.)  number of variables:  31.

     b.)  number of records:  226.

     c., d., & e.) Variable names, variable format and variable length:  
                   Starting with column 1 of el92m3, "egg & larval 1992 
                   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=McDonald Tract, 12" outfall pipe; 
                       4=Naglee Burk Irrigation District, 20" 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.  
                      *"37 58 40.740/121 28 32.163"; 3=McDonald Tract, on 
                       southeastern side of McDonald Tract adjacent to Turner 
                       Cut.
                      *"37 46 55.484/121 29 00.939"; 4=Naglee Burk Irrigation
                       District, on Old River upstream of the temporary barrier 
                       site near Tracy Pumping Plant.
7) EC              5   Surface specific conductance.
8) Temperature     5   Water temperature recorded in degrees Celsius.
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 5   Volume of water measured through the siphon in acre feet 
                       (AF).
12) Water measurement  Recorded in acre feet=AF or gallons=GAL.
                         Column 5 characters wide.
13) Fish Screen    3   0=none; 1=on-down; 2=off-up.

*Columns 14 through 38 are numbers of individual species caught. All columns are 
 4 characters wide.

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

5.  Structure of el92len:

     a.)  number of variables:  33.

     b.)  number of records:  227.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of el92len, "egg & larval 1992 
                    length" file.

VARIABLE      COLUMN   DESCRIPTION
	       WIDTH

1) RKI             2  River Kilometer Index.
2) Station            1=Twitchell Island 16" outfall pipe; 
                      2=Bacon Island, 16" outfall pipe; 
                      3=McDonald Tract, 12" outfall pipe; 
                      4=Naglee Burk Irrigation District, 20" outfall pipe. 
                        Column 4 characters wide.
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.  
                      *"37 58 40.740/121 28 32.163"; 3=McDonald Tract, on 
                       southeastern side of McDonald Tract adjacent to Turner 
                       Cut.
                      *"37 46 55.484/121 29 00.939"; 4=Naglee Burk Irrigation
                       District, on Old River upstream of the temporary barrier 
                       site near Tracy Pumping Plant.
7) Species code    8   TFS-8=Threadfin Shad; PSC-29=Prickly Sculpin; 
                       LP-23=Bigscale Logperch; CG-61=Chameleon Goby;
                       SB-3=Striped Bass; CP-14=Carp; BCR-18=Black Crappie; 
                       BG-21=Bluegill; GAM-34=Mosquitofish; SF-89=Sunfish.
8) Count #         4   The number of fish caught in a sample.
9) Measure #       4   The number of fish measured in a sample.
10 through 34)     5   Length 1 through length 25.  Total lengths (TL) were 
                       measured to the nearest millimeter (mm).

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