Department of Water Resources Home
IEP Banner

File Format for 1993 Georgiana Slough Acoustic Barrier Test.

1.  File name:  GS93.TXT 

2.  Last update of data files:  07/11/95

3.  Size of file in bytes:  cvs:  56,301

4.  Width of file:  130

5.  Structure of each file:
	a)  number of variables:  22
	b)  number of records:  629

Variable names, variable format and variable length of the database 
are explained below.

Column	Width	Description
  1	10	River Kilometer Index
 12	 2	Station identifier.  1= Sacramento River downstream of 
                the barrier, 2= Georgiana Slough, 3= Sacramento River
                upstream of the barrier
 15	 8	Sample date. Year, month and day as YYYYMMDD
 24	 4	Sample time. Military, pacific daylight savings time.
 29	 2	Depth of sample.  None for this project
 32	 2	Location of sampling within the channel.  1= right bank,
                2= middle, 3= left bank (facing upstream)
 35	 2	Barrier operation.  1= on, 2= off
 38	 2	Temperature (Fahrenheit)
 41	 6	Flow in the Sacramento River (CFS) at Walnut Grove with 
                the Delta Cross Channel closed.
 48	 6	Flow in the Sacramento River (CFS) below Georgiana Slough
 55	 6	Flow in Georgiana Slough.  Calculated by subtracting 
                column 10 from column 9
		Note:  negative flow = upstream
 62	 3	Tide.  E= ebb, F= flood
 66	 6	Actual tide stage at Walnut Grove, derived from USGS tide stage data  
 73	 6	Trawling duration.  Actual time of each trawl in minutes
 80	 8	Flow meter end number for each trawl
 89	 8	Flow meter start number for each trawl
 98	 8	Volume of water sampled in cubic meters
105	 2	Number of Chinook salmon caught
108	 2	Number of fish besides salmon caught
111	 4	Salmon catch per unit effort.  Number of salmon caught
                averaged over the trawling time.  Number of fish/ minute.
116	 4	Salmon catch per unit effort.  Number of salmon caught 
                averaged over the volume of water sampled.  
                Number of fish/ 1000 cubic meters.
121	10	Comments.  If the flow had to be estimated, the term 'flow est' was used.