Department of Water Resources Home
IEP Banner

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

1.  File names: 1) jv93fd=juvenile 1993 field data;
                2) jv93den=juvenile 1993 density; 
                3) jv93len=juvenile 1993 length.

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

3.  Size of file in bytes:  csv:   1) jv93fd=75,708; 2) jv93den=65,418; 
                                   3) jv93len=211,528.
                         
4.  Width of file:  1) jv93fd=189; 2) jv93den=138; 3) jv93len=260.

5.  Structure of jv93fd file:

     a.)  number of variables:  30.

     b.)  number of records:  463.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv93fd, "juvenile 1993 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; 
                    2B=Bacon Island, 14" outfall pipe; 
                    4=Naglee Burk Irrigation District, 20" outfall pipe; 
                    5=McMullin Tract, 16" outfall pipe; 
                    10=Bouldin Island, 12" 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, 
                    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 59 10.217/121 32 06.191"; 2B=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.                    
                   *"37 43 43.075/121 16 26.956" & 
                    "37 43 43.146/121 16 26.929"; 5=McMullin Tract, San 
                     Joaquin River, reclamation district 2075, intersection of 
                     Perrin and Depue Roads, near Manteca.  Two discharge 
                     columns go into a concrete distribution box which then 
                     allows water to be released north or east.
                   *"38 06 58.177/121 32 47.129"; 10=Bouldin Island, South 
                    fork of the Mokelumne River, west of the terminus bridge.
7) EC            5  Surface specific conductance.
8) Temperature   4  Water temperature recorded in degrees Fahrenheit.
9) Flow readings 4  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 7 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 54 characters wide.

5.  Structure of jv93den file:

     a.)  number of variables:  24.

     b.)  number of records:  463.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of jv93den, "juvenile 1993 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; 
                    2B=Bacon Island, 14" outfall pipe; 
                    4=Naglee Burk Irrigation District, 20" outfall pipe; 
                    5=McMullin Tract, 16" outfall pipe; 
                    10=Bouldin Island, 12" 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 59 10.217/121 32 06.191"; 2B=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.                    
                   *"37 43 43.075/121 16 26.956" & 
                    "37 43 43.146/121 16 26.929"; 5=McMullin Tract, San 
                     Joaquin River, reclamation district 2075, intersection of 
                     Perrin and Depue Roads, near Manteca.  Two discharge 
                     columns go into a concrete distribution box which then 
                     allows water to be released north or east.
                   *"38 06 58.177/121 32 47.129"; 10=Bouldin Island, South 
                    fork of the Mokelumne River, west of the terminus bridge.
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 jv93len file:

     a.)  number of variables:  46.

     b.)  number of records:  1,947.

     c., d., & e.)  Variable names, variable format and variable length: 
                    Starting with column 1 of jv93len, "juvenile 1993 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; 
                    2B=Bacon Island, 14" outfall pipe; 
                    4=Naglee Burk Irrigation District, 20" outfall pipe; 
                    5=McMullin Tract, 16" outfall pipe; 
                    10=Bouldin Island, 12" 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 59 10.217/121 32 06.191"; 2B=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.                    
                   *"37 43 43.075/121 16 26.956" & 
                    "37 43 43.146/121 16 26.929"; 5=McMullin Tract, San 
                     Joaquin River, reclamation district 2075, intersection of 
                     Perrin and Depue Roads, near Manteca.  Two discharge 
                     columns go into a concrete distribution box which then 
                     allows water to be released north or east.
                   *"38 06 58.177/121 32 47.129"; 10=Bouldin Island, South 
                    fork of the Mokelumne River, west of the terminus bridge.

*7 through 46 are species codes and lengths.  Lengths were measured to the 
 nearest millimeter (mm).  All columns are 5 characters wide.

7) AS-7        American Shad, total length.
8) AS-7        American Shad, standard length.
9) TFS-8       Threadfin Shad, total length.
10) TFS-8      Threadfin Shad, standard length.
11) TFS-8      Threadfin Shad, fork length.
12) LFS-25     Longfin Smelt, total length. 
13) LFS-25     Longfin Smelt, standard length. 
14) DS-26      Delta Smelt, total length. 
15) DS-26      Delta Smelt, standard length. 
16) ISS-31     Inland Silverside, total length.
17) ISS-31     Inland Silverside, standard length.
18) ISS-31     Inland Silverside, fork length.
19) STF-32     Starry Flounder, total length. 
20) STF-32     Starry Flounder, standard length. 
21) NA-90      Northern Anchovy, total length. 
22) NA-90      Northern Anchovy, standard length. 
23) CYPRIN-90  Cyprinid, total length. 
24) CYPRIN-90  Cyprinid, standard length. 
25) SPT-9      Splittail, total length. 
26) SPT-9      Splittail, standard length.
27) CENTR-90   Centrarchid, total length. 
28) CENTR-90   Centrarchid, standard length. 
29) PSC-29     Prickly Sculpin, total length. 
30) PSC-29     Prickly Sculpin, standard length. 
31) LP-23      Bigscale Logperch, total length. 
32) LP-23      Bigscale Logperch, standard length. 
33) CF-56      All catfish species, total length. 
34) CF-56      All catfish species, standard length.
35) CF-56      All catfish species, fork length.
36) SSU-50     Sacramento Sucker, total length. 
37) SSU-50     Sacramento Sucker, standard length. 
38) YFG-30     Yellowfin Goby,  total length.
39) YFG-30     Yellowfin Goby, standard length.
40) CG-61      Chameleon Goby, total length. 
41) CG-61      Chameleon Goby, standard length. 
42) SB-3       Striped Bass, total length. 
43) SB-3       Striped Bass, standard length.
44) SB-3       Striped Bass, fork length.
45) OTHER-90   Species not listed, miscellaneous, explained in field data                          
                comments, total length.
46) OTHER-90   Species not listed, miscellaneous, explained in field data                          
                comments, standard length.
47) Comments   Species breakdown.  
                Column 17 characters wide.

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