Department of Water Resources Home
IEP Banner

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

1.  File names:  1) el93fd=1994 egg & larval field data; 
                 2) el93m3=1994 egg & larval density in meters cubed; 
                 3) el93len=1994 egg & larval length.

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

3.  Size of file in bytes:  csv:   1) el93fd=20,516; 
				   2) el93m3=17,678; 
                                   3) el93len=108,863.
                         
4.  Width of file:  1) el93fd=191; 2) el93m3=193; 3) el93len=220.

5.  Structure of el93fd file:

     a.)  number of variables:  36.

     b.)  number of records:  120.

     c., d., & e.) Variable names, variable format and variable length:  
                   Starting with column 1 of el93fd, "egg & larval 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; 
                      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, 
                      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. 
                     *"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     5  Water temperature recorded in degrees Fahrenheit.
9) Volume Sampled  6  Volume of water measured through net in meters cubed (m3).  
10) Flow readings  3  Flow readings from the siphon recorded as cubic feet per 
                      second (cfs). 
11) Sampled Volume 5  Volume of water measured through the siphon recorded in 
                      acre feet (AF).
12) Fish Screen    3  0=none; 1=on-down; 2=off-up.

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

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

5.  Structure of el93m3 file:

     a.)  number of variables:  30.

     b.)  number of records:  120.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of el93m3, "egg & larval 1993 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; 
                      2B=Bacon Island, 14" outfall pipe; 
                      4=Naglee Burk Irrigation District, 20" outfall pipe; 
                      10=Bouldin Island, 12" outfall pipe.  
3) Date            8  Year, month, day.
4) Time            5  Pacific Standard Time (PST).
		      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. 
                     *"38 06 58.177/121 32 47.129"; 10=Bouldin Island, 
                      South fork of the Mokelumne River, west of the terminus 
                      bridge.
                        Column maximum 30 characters wide.
7) Volume Sampled  6  Volume of water measured through net in meters cubed (m3).

*8 through 31 are densities for individual species caught, recorded per meters
 cubed (m3).  All columns are 6 characters wide.

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

5.  Structure of el93len file:

     a.)  number of variables:  40.

     b.)  number of records:  679.

     c., d., & e.)  Variable names, variable format and variable length:  
                    Starting with column 1 of el93len, "egg & larval 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; 
                   8  10=Bouldin Island, 12" outfall pipe.  
3) Date               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. 
                     *"38 06 58.177/121 32 47.129"; 10=Bouldin Island, 
                      South fork of the Mokelumne River, west of the terminus 
                      bridge.

*7 through 40 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) LFS-25     Longfin Smelt, total length.
12) LFS-25     Longfin Smelt, standard length.
13) DS-26      Delta Smelt, total length.
14) DS-26      Delta Smelt, standard length.
15) ISS-31     Inland Silverside, total length.
16) ISS-31     Inland Silverside, standard length.
17) STF-32     Starry Flounder, total length.
18) STF-32     Starry Flounder, standard length.
19) NA-90      Northern Anchovy, total length.
20) NA-90      Northern Anchovy, standard length.
21) CYPRIN-90  Cyprinid, total length.
22) CYPRIN-90  Cyprinid, standard length.
23) SPT-9      Splittail, total length.
24) SPT-9      Splittail, standard length.
25) CENTR-90   Centrarchid, total length.
26) CENTR-90   Centrarchid, standard length. 
27) PSC-29     Prickly Sculpin, total length.
28) PSC-29     Prickly Sculpin, standard length.
29) LP-23      Bigscale Logperch, total length.
30) LP-23      Bigscale Logperch, standard length.
31) CF-56      All catfish species, total length.
32) CF-56      All catfish species, standard length.
33) SSU-50     Sacramento Sucker, total length.
34) SSU-50     Sacramento Sucker, standard length.
35) YFG-30     Yellowfin Goby,  total length.
36) YFG-30     Yellowfin Goby, standard length.
37) CG-61      Chameleon Goby, total length.
38) CG-61      Chameleon Goby, standard length.
39) SB-3       Striped Bass, total length.
40) SB-3       Striped Bass, standard length.
41) Comments   Species breakdown.
                 Column 7 characters wide.

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