Department of Water Resources Home
IEP Banner

File Format for 1992 Delta Agricultural Diversion Evaluation, Juvenile and Older Fish Sampling.

1.  File names: 1) jv92fd=juvenile 1992 field data; 
                2) jv92den=juvenile 1992 density;
                3) jv92len=juvenile 1992 length.

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

3.  Size of file in bytes:  csv:  1) jv92fd=31,802;  2) jv92den=19,560; 
                                  3) jv92len=11,500.

4.  Width of file:  1) jv92fd=98; 2) jv92den=68; 3) jv92len=159.

5.  Structure of jv92fd file:

     a.)  number of variables:  16.

     b.)  number of records:  229.

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

VARIABLE     COLUMN  DESCRIPTION
	      WIDTH

1) RKI            2  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 (0C).
9) Flow readings  5  Flow readings from the siphon.
10) Measure of flow   Recorded in cubic feet per second=CFS, gallons per minute
                     =GPM or used egg & larval propeller flowmeter reading
                     cubic feet per second=EL.
                        Column 5 characters wide.
11) Sampled Volume   Volume of water measured through the siphon recorded in 
                     acre feet=AF.     
                        Column 7 characters wide.
12) Sampled Volume   Volume of water measured through the siphon recorded in 
                     gallons=GAL.    
                        Column 7 characters wide.     
13) Fish Screen   3  0=none; 1=on-down; 3=off-up. 
14) Net Type      3  Winged fyke-type nets made of 1/8-inch delta-type mesh; 
                     1=1m X 1m; 2=1m X 1.5m wing type; 3=Other; fyke-type net
                     secured directly over the outfall pipe or egg & larval net.  
15) Net End       3  1=Small cod-end; 2=Large cod-end; 3=Mesh live-box; 
                     4=Tied off.                 
16) Species Caught   TFS-8=Threadfin Shad; ISS-31=Inland Silverside; 
                     LP-23=Bigscale Logperch; YFG-30=Yellowfin Goby; 
                     CG-61=Chameleon Goby; SB-3=Striped Bass;  
                     PSC-29=Prickly Sculpin; WCF-4=White Catfish; 
                     GSF-19=Green Sunfish; BG-21=Bluegill; GAM-34=Mosquitofish;
                     SMB-36=Smallmouth Bass; OTHER-90=Miscellaneous species not
                     listed separately. 
                       Column 8 characters wide.
17) Count #       4  The number of a certain fish species caught in a sample.

5.  Structure of jv92den file:

     a.)  number of variables:  8.

     b.)  number of records:  229.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv92den, "juvenile 1992 density" 
                    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.
                       Column maximum 30 characters wide.
7) Sampled Volume 7  Volume of water measured through the siphon recorded in
                     acre feet=AF.      
8) Species Caught 8  TFS-8=Threadfin Shad; ISS-31=Inland Silverside; 
                     LP-23=Bigscale Logperch; YFG-30=Yellowfin Goby; 
                     CG-61=Chameleon Goby; SB-3=Striped Bass; 
                     PSC-29=Prickly Sculpin; WCF-4=White Catfish; 
                     GSF-19=Green Sunfish; BG-21=Bluegill; GAM-34=Mosquitofish;
                     SMB-36=Smallmouth Bass; OTHER-90=Miscellaneous species not
                     listed separately. 
9) Species Density   Densities for individual species caught, recorded in acre
                     feet (AF).  
                       Column 10 characters wide.

5.  Structure of jv92len file:

     a.)  number of variables:  28.

     b.)  number of records:  104.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv92len, "juvenile 1992 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=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).
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 Caught 8  TFS-8=Threadfin Shad; ISS-31=Inland Silverside; 
                     LP-23=Bigscale Logperch; YFG-30=Yellowfin Goby; 
                     CG-61=Chameleon Goby; SB-3=Striped Bass; 
                     PSC-29=Prickly Sculpin; WCF-4=White Catfish; 
                     GSF-19=Green Sunfish; BG-21=Bluegill; GAM-34=Mosquitofish;
                     SMB-36=Smallmouth Bass; OTHER-90=Miscellaneous species not
                     listed separately. 
8) Count #        4  The number of a certain fish species caught in a sample.
9) Measure #      4  The number of  a certain fish species measured in a sample.
                     No more than 20 fish were measured in any one sample.
10 through 29)    5  Length 1 through length 20.  Fork lengths were measured to
                     the nearest millimeter (mm).  

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