Department of Water Resources Home
IEP Banner

File Format for 1995 Delta Agricultural Diversion Evaluation Juvenile and Adult Fish Sampling

                                  
1.   File names: 1) jv95fd=juvenile 1995 field data 
		 2) jv95den=juvenile 1995 density 
                 3) jv95len=juvenile 1995 length.

2.   Last update of data files: 1/16/96.

3.   Size of file in bytes:  csv:  1) jv95fd=15,459 
				   2) jv95den=14,234 
				   3) jv95len=35,447.

4.   Width of file:  1) jv95fd=222 
		     2) jv95den=178 
		     3) jv95len=162.

5.   Structure of each file:
     a.)  number of variables:  1) jv95fd=40 
				2) jv95den=34 
				3) jv95len=29.

     b.)  number of records:  1) jv95fd=107 
			      2) jv95den=107 
			      3) jv95len=272.

5.   Structure of jv95fd file:
     c., d. & e.)  variable names, variable format and variable length:  
     Starting with column 1 of jv95fd, "juvenile 1995 field data" file. 

VARIABLE	COLUMN	DESCRIPTION
		WIDTH

1) RKI         	    8	River Kilometer Index.
2) Station     	    1	1=Twitchell Island, 16" outfall pipe; 2=Bacon 
			Island, 16" outfall pipe; 
               		4=Naglee-Burk Irrigation District, 20" outfall pipe.
3) Date        	    8	Year, month, day.
4) Time        	    4	Pacific Standard Time (PST).
               		Military time format.
			Example:  0 = midnight
				 10 = ten minutes after midnight
			       1300 = 1 pm.
5)  Depth      	    2	No depth reading taken.
6)  Lat/Long  	   24	degrees minutes seconds (decimal)/degrees minutes 	
			seconds (decimal) 
			"38 05 26.406/121 38 18.558"; 1=San Joaquin 
			River, south side of Twitchell Island at Oulton 
                        Point.
               		"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 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 	    4	Water temperature recorded in degrees Fahrenheit 
			(F).
9) Flow readings    5	Flow readings from the siphon recorded as cubic 
			feet per second (cfs).
10) Sampled Volume  5	Volume of water measured through the siphon recorded 
			in acre feet (af).                   
11) Fish Screen     1	0= none; 1= on-down; 2= off-up. 
12) Net End         1	1=Mesh box; 2=Wood box; 3=Other.
     *13 through 39 are numbers of individual species caught.
13) CS-1       	    4	Chinook Salmon, "Comments" column:  est'd=estimated.  
14) SB-3       	    4	Striped Bass.  
15) SPT-9      	    4	Splittail.  
16) LFS-25          4 	Longfin Smelt.  
17) DS-26      	    4	Delta Smelt. 
18) WS-65      	    4	Wakasagi. 
19) WCF-4      	    4	White Catfish. 
20) BBH-5      	    4	Brown Bullhead. 
21) CCF-6      	    4	Channel Catfish. 
22) AS-7       	    4	American Shad.
23) TFS-8      	    4	Threadfin Shad.
24) TP-24      	    4	Tule Perch. 
25) TSB-11          4	Threespine Stickleback. 
26) SF-89      	    4	Sunfish.  
27) BG-21      	    4	Bluegill. 
28) RSF-49          4	Redear Sunfish. 
29) LMB-22          4	Largemouth Bass.  
30) LP-23      	    4	Bigscale Logperch.  
31) PSC-29          4	Prickly Sculpin.  
32) RSC-40          4	Riffle Sculpin. 
33) ISS-31          4	Inland Silverside. 
34) GAM-34          4	Mosquitofish. 
35) PBL-48          4	Pacific Brook Lamprey.  
36) SSU-50          4	Sacramento Sucker.  
37) YFG-30          4	Yellowfin Goby.  
38) SG-66      	    4	Shimofuri Goby. 
39) MIS-90          4	Species not listed, miscellaneous, explained in 
			field data comments.
40) Comments   	   47	Information collected during sample, etc.  


5.   Structure of jv95den file:
     c., d. & e.)  variable names, variable format and variable length:  
     Starting with column 1 of jv95den, "juvenile 1995 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; 
               		4=Naglee-Burk Irrigation District, 20" outfall pipe.             
3) Date        	    8	Year, month, day.
4) Time        	    4	Pacific Standard Time (PST).
			Military time format.
			Example:  0 = midnight
				 10 = ten minutes after midnight
			       1300 = 1 pm
5) Depth      	    2	No depth readings taken.
6) Lat/Long        26 	degrees minutes seconds (decimal)/degrees minutes 	
			seconds (decimal) 
			"38 05 26.406/121 38 18.558"; 1=San Joaquin 
			River, south side of Twitchell Island at Oulton 
			Point.
               		"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 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) Sampled Volume   5	Volume of water measured through the siphon recorded 
			in acre feet (af).  

     *8 through 34 are densities for individual species caught, recorded 
	per acre feet (af).
8) CS-1        	    9	Chinook Salmon, EST=estamite, see "Comment" column 
			in the jv95fd.dat file.  
9) SB-3        	    4	Striped Bass.  
10) SPT-9      	    4	Splittail.  
11) LFS-25          4	Longfin Smelt. 
12) DS-26      	    4	Delta Smelt. 
13) WS-65      	    4	Wakasagi.  
14) WCF-4      	    4	White Catfish.  
15) BBH-5      	    4	Brown Bullhead.  
16) CCF-6      	    4	Channel Catfish.  
17) AS-7       	    4	American Shad. 
18) TFS-8      	    4	Threadfin Shad.  
19) TP-24      	    4	Tule Perch.  
20) TSB-11          4	Threespine Stickleback. 
21) SF-89      	    4	Sunfish.  
22) BG-21      	    4	Bluegill. 
23) RSF-49          4	Redear Sunfish.  
24) LMB-22          4	Largemouth Bass. 
25) LP-23      	    4	Bigscale Logperch. 
26) PSC-29          4	Prickly Sculpin.   
27) RSC-40          4	Riffle Sculpin. 
28) ISS-31          4	Inland Silverside.  
29) GAM-34          4	Mosquitofish.  
30) PBL-48          4	Pacific Brook Lamprey. 
31) SSU-50          4	Sacramento Sucker. 
32) YFG-30          4	Yellowfin Goby.  
33) SG-66      	    4	Shimofuri Goby.  
34) MIS-90          4	Species not listed, miscellaneous, explained in 
			field data comments.



5.   Structure of jv95len file:
     c., d. & e.)  variable names, variable format and variable length:  
     Starting with column 1 of jv95len, "juvenile 1995 length" file.

VARIABLE	COLUMN	DESCRIPTION
		WIDTH

1) RKI         	    8	River Kilometer Index.
2) Station          4	1=Twitchell Island, 16" outfall pipe; 2=Bacon 
			Island, 16" outfall pipe; 
               		4=Naglee-Burk Irrigation District, 20" outfall pipe.             
3) Date        	    8	Year, month, day.
4) Time        	    4	Pacific Standard Time (PST).
			Military time format.
			Example:   0 = midnight
				  10 = ten minutes after midnight
				1300 = 1 pm.
5)  Depth      	    2	No depth readings taken.
6)  Lat/Long       26 	degrees minutes seconds (decimal)/degrees minutes 	
			seconds (decimal) 
			"38 05 26.406/121 38 18.558"; 1=San Joaquin 
			River, south side of Twitchell Island at Oulton 
			Point.
               		"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 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	CS-1=Chinook Salmon 
			SB-3=Striped Bass 
			WCF-4=White Catfish 
			BBH-5=Brown Bullhead 
			CCF-6=Channel Catfish 
			AS-7=American Shad 
			TFS-8=Threadfin Shad 
			SPT-9=Splittail 
			TSB-11=Threespine Stickleback 
               		BG-21=Bluegill 
			LMB-22=Largemouth Bass 
			LP-23=Bigscale Logperch 
			TP-24=Tule Perch 
			PSC-29=Prickly Sculpin 
			YFG-30=Yellowfin Goby
               		ISS-31=Inland Sliverside 
			GAM-34=Mosquitofish 
			RSC-40=Riffle Sculpin 
			PBL-48=Pacific Brook Lamprey 
			RSF-49=Redear Sunfish 
			SSU-50=Sacramento Sucker 
			SG-66=Shimofuri Goby 
			SF-89=Sunfish 
			TTLCNT-98=Total Fish Count.  
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.  Total lengths (TL) 
			were measured to the nearest tenth of a 
			millimeter (mm).  

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