Department of Water Resources Home
IEP Banner

File Format for 1995 Delta Agricultural Diversion Evaluation Egg & Larval Sampling

1.   File names:   1) el95fd=egg & larval 1995 field data 
                   2) el95m3=egg & larval 1995 density in meters cubed 
                   3) el95af=egg & larval 1995 density in acre feet 
                   4) el95len=egg & larval 1995 length.

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

3.   Size of file in bytes: csv:  1) el95fd=3,115 
                          	  2) el95m3=2,757
                          	  3) el95af=2,664 
                          	  4) el95len=2,599.                         

4.   Width of file:  1) el95fd=175 
               	     2) el95m3=153 
               	     3) el95af=149 
                     4) el95len=113.

5.   Structure of each file:
     a.)  number of variables:  1) el95fd=45 
                         	2) el95m3=39 
                         	3) el95af=39 
                         	4) el95len=24.

     b.)  number of records:  1) el95fd=20 
			      2) el95m3=20 
  			      3) el95af=20 
                       	      4) el95len=24.

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

VARIABLE	COLUMN	DESCRIPTION
		WIDTH
	
1) RKI  	    8   River Kilometer Index.
2) Station          1	2=Bacon Island, 16" 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) 
			"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. 
7) EC               5	Surface specific conductance.
8) Temperature 	    4	Water temperature recorded in degrees Fahrenheit 
			(F).
9) Volume Sampled   8	Volume of water measured through net in meters 
			cubed (m3).
10) Flow readings   4	Flow readings from the siphon recorded as cubic 
			feet per second (cfs).
11) Sampled Volume  4	Volume of water measured through the siphon recorded 
			in acre feet (af).
12) Fish Screen     1	0= none; 1= on-down; 2= off-up.
     *13 through 44 are numbers of individual species caught.
13) AS Egg          4	American Shad egg. 
14) X Egg           4	All other species of eggs except American Shad and 
			Striped Bass.
15) Morula          4	Striped Bass egg, morula.  
16) Early Emby 	    4	Striped Bass egg, early  embryo.  
17) Late Emby       4	Striped Bass egg, late embryo.  
18) Dead Egg        4 	Striped Bass dead egg.  
19) CS-1            4	Chinook Salmon.  
20) SB-3            4	Striped Bass.  
21) SPT-9           4	Splittail.  
22) LFS-25          4	Longfin Smelt.  
23) DS-26           4	Delta Smelt.  
24) WS-65           4	Wakasagi.  
25) WCF-4           4	White Catfish.  
26) BBH-5           4	Brown Bullhead.  
27) CCF-6      	    4	Channel Catfish.  
28) AS-7            4	American Shad.  
29) TFS-8      	    4	Threadfin Shad.  
30) TP-24      	    4	Tule Perch.  
31) TSB-11          4	Threespine Stickleback.  
32) CP-14           4	Carp.  
33) SF-89           4	Sunfish.  
34) BG-21           4	Bluegill.  
35) RSF-49          4	Redear Sunfish.  
36) LMB-22          4	Largemouth Bass.  
37) LP-23           4	Bigscale Logperch.  
38) PSC-29          4	Prickly Sculpin.  
39) RSC-40          4	Riffle Sculpin. 
40) ISS-31          4	Inland Silverside.  
41) GAM-34          4	Mosquitofish.  
42) SSU-50          4	Sacramento Sucker.  
43) YFG-30          4	Yellowfin Goby.  
44) SG-66      	    4	Shimofuri Goby.  

45) Comments   	   22	Information collected during sample, etc.  


5.   Structure of el95m3 file:
     c., d. & e.)  variable names, variable format and variable length:  
     Starting with column 1 of el95m3, "egg & larval 1995 density in 
     meters cubed" file.

VARIABLE	COLUMN	DESCRIPTION
		WIDTH


1) RKI              8	River Kilometer Index.
2) Station          1	2=Bacon Island, 16' 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)         
			"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. 
7) Volume Sampled   8	Volume of water measured through net in meters cubed 
			(m3).
*8 through 39 are densities for individual species caught, recorded per 
			meters cubed (m3).
8) AS Egg      	    4	American Shad egg.  
9) X Egg       	    4	All other species of eggs except American Shad and 
			Striped Bass.
10) Morula          4	Striped Bass egg, morula. 
11) Early Emby 	    4	Striped Bass egg, early  embryo.  
12) Late Emby  	    4	Striped Bass egg, late embryo.  
13) Dead Egg        4	Striped Bass dead egg. 
14) CS-1       	    4	Chinook Salmon.  
15) SB-3       	    4	Striped Bass.  
16) SPT-9           4	Splittail. 
17) LFS-25          4	Longfin Smelt. 
18) DS-26      	    4	Delta Smelt.  
19) WS-65      	    4	Wakasagi.  
20) WCF-4           4	White Catfish.  
21) BBH-5      	    4	Brown Bullhead.  
22) CCF-6           4	Channel Catfish.  
23) AS-7       	    4	American Shad. 
24) TFS-8      	    4	Threadfin Shad. 
25) TP-24           4	Tule Perch.  
26) TSB-11          4	Threespine Stickleback. 
27) CP-14           4 	Carp.  
28) SF-89      	    4	Sunfish.  
29) BG-21           4	Bluegill.  
30) RSF-49          4	Redear Sunfish.  
31) LMB-22          4	Largemouth Bass.  
32) LP-23      	    4 	Bigscale Logperch.  
33) PSC-29          4	Prickly Sculpin.  
34) RSC-40          4	Riffle Sculpin. 
35) ISS-31          4	Inland Silverside. 
36) GAM-34          4	Mosquitofish.  
37) SSU-50          4	Sacramento Sucker.  
38) YFG-30          4	Yellowfin Goby.  
39) SG-66      	    4	Shimofuri Goby.  


5.   Structure of el95af file:
     c., d. & e.)  variable names, variable format and variable length:  
     Starting with column 1 of el95af, "egg & larval 1995 density in acre 
     feet" file.

VARIABLE	COLUMN	DESCRIPTION
		WIDTH

1) RKI         	    8	River Kilometer Index.
2) Station          1	2=Bacon Island, 16" 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) 
			"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. 
7) Sampled Volume   6	Volume of water measured through the siphon 
			recorded in acre feet (af).
     *8 through 38 are densities for individual species caught, recorded 
	per acre feet (af).
8) AS Egg           4	American Shad egg. 
9) X Egg            4	All other species of eggs except American Shad and 
			Striped Bass.
10) Morula          4	Striped Bass egg, morula. 
11) Early Emby      4	Striped Bass egg, early  embryo.  
12) Late Emby  	    4	Striped Bass egg, late embryo.  
13) Dead Egg        4	Striped Bass dead egg.  
14) CS-1            4	Chinook Salmon.  
15) SB-3            4	Striped Bass.  
16) SPT-9           4 	Splittail.  
17) LFS-25          4	Longfin Smelt. 
18) DS-26           4	Delta Smelt.  
19) WS-65      	    4	Wakasagi.  
20) WCF-4           4	White Catfish.  
21) BBH-5           4	Brown Bullhead.  
22) CCF-6           4	Channel Catfish.  
23) AS-7            4	American Shad.  
24) TFS-8           4	Threadfin Shad.  
25) TP-24           4	Tule Perch.  
26) TSB-11          4	Threespine Stickleback.  
27) CP-14           4	Carp.  
28) SF-89      	    4	Sunfish.  
29) BG-21      	    4	Bluegill.  
30) RSF-49          4	Redear Sunfish.  
31) LMB-22          4	Largemouth Bass. 
32) LP-23           4	Bigscale Logperch.  
33) PSC-29          4	Prickly Sculpin.  
34) RSC-40          4	Riffle Sculpin. 
35) ISS-31          4	Inland Silverside.  
36) GAM-34          4	Mosquitofish.  
37) SSU-50          4	Sacramento Sucker. 
38) YFG-30          4	Yellowfin Goby.  
39) SG-66           4	Shimofuri Goby.  

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

VARIABLE	COLUMN	DESCRIPTION
		WIDTH

1) RKI              8	River Kilometer Index.
2) Station          1	2=Bacon Island, 16" 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) 
			"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. 
7) Species code     2	BBH-5=Brown Bullhead 
			TFS-8=Threadfin Shad 
			CP-14=Carp 
			BG-21=Bluegill 
			LP-23=Bigscale Logperch
		 	SF-89=Sunfish 
			TTLCNT-98=Total Fish Count = 0
8) Count #          3	The number of certain fish species caught in a 
			sample.
9) Measure #        2	The number of a certain fish species measured in a 
			sample.
10 through 29) 	    4	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) Screen codes and type used  
			      3) Species codes.