Department of Water Resources Home
IEP Banner

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

1.  File names:  1) jv94fd=juvenile 1994 field data; 
                 2) jv94den=juvenile 1994 density; 
                 3) jv94len=juvenile 1994 length.

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

3.  Size of file in bytes:  csv:  1) jv94fd=57,376; 2) jv94den=45,728; 
                                  3) jv94len=39,130.

4.  Width of file:  1) jv94fd=174; 2) jv94den=138; 3) jv94len=159.

5.  Structure of jv94fd file:

     a.)  number of variables:  30.

     b.)  number of records:  357.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv94fd, "juvenile 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; 
                    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, 
                    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   5  Water temperature recorded in degrees Fahrenheit (0F).
9) Flow readings 5  Flow readings from the siphon recorded as cubic feet per second (cfs).
10) Sampled Volume  Volume of water measured through the siphon recorded in acre feet (AF).    
                      Column 5 characters wide.
11) Fish Screen  3  0=none; 1=on-down; 2=off-up. 
12) Net End      3  1=Mesh box; 2=Wood box; 3=Other.

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

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

5.  Structure of jv94den file:

     a.)  number of variables:  24.

     b.)  number of records:  357.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv94den, "juvenile 1994 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          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 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   Volume of water measured through the siphon recorded in acre feet (AF).    
                      Column 5 characters wide.

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

8) AS-7        American Shad. 
9) TFS-8       Threadfin Shad. 
10) LFS-25     Longfin Smelt. 
11) DS-26      Delta Smelt. 
12) ISS-31     Inland Silverside. 
13) STF-32     Starry Flounder. 
14) NA-90      Northern Anchovy. 
15) CYPRIN-90  Cyprinid. 
16) SPT-9      Splittail. 
17) CENTR-90   Centrarchid. 
18) PSC-29     Prickly Sculpin. 
19) LP-23      Bigscale Logperch. 
20) CF-56      All catfish species. 
21) SSU-50     Sacramento Sucker. 
22) YFG-30     Yellowfin Goby. 
23) CG-61      Chameleon Goby. 
24) SB-3       Striped Bass. 
25) OTHER-90   Species not listed, miscellaneous, explained in field data comments.
              
5.  Structure of jv94len file:

     a.)  number of variables:  28.

     b.)  number of records:  347.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv94len, "juvenile 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; 
                    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 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; 
                    TFS-8=Threadfin Shad; TSB-11=Threespine Stickleback; 
                    CP-14=Carp; BG-21=Bluegill; LMB-22=Largemouth Bass; 
                    LP-23=Bigscale Logperch; TP-24=Tule Perch; DS-26=Delta Smelt;
                    PSC-29=Prickly Sculpin; YFG-30=Yellowfin Goby;
                    ISS-31=Inland Silverside; GAM-34=Mosquitofish; 
                    SSC-39=Staghorn Sculpin; CG-61=Chameleon Goby;  
                    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)      Length 1 through length 20.  Total lengths (TL) were 
                    measured to the nearest millimeter (mm).  
                      Columns are 5 characters wide.

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