Department of Water Resources Home
IEP Banner

File Format for the Contra Costa Canal Intake Entrainment Study

 
File Names	Description

CCPOP93.TXT  	1993-1994 Contra Costa Canal Fish Entrainment Sampling
		- plankton net operations database

CCPCT93.TXT    	1993-1994 Contra Costa Canal Fish Entrainment Sampling 
		- plankton net counts database

CCPLT93.TXT    	1993-1994 Contra Costa Canal Fish Entrainment Sampling 
		- plankton net lengths database

CCSOP93.TXT    	1993-1994 Contra Costa Canal Fish Entrainment Sampling 
		- sieve-net operations database

CCSCT93.TXT    	1993-1994 Contra Costa Canal Fish Entrainment Sampling 
		- sieve-net counts database

CCSLT93.TXT    	1993-1994 Contra Costa Canal Fish Entrainment Sampling 
		- sieve-net lengths database


File  		Last Update    Size (B)   Record    Variables

CCPOP93.TXT     10/03/95	 1,210 	    29		 8
CCPCT93.TXT     09/19/95 	   927 	    29		 7
CCPLT93.TXT     09/19/95 	 1,104 	    37		 6
CCSOP93.TXT     09/19/95 	 4,842 	    82		11
CCSCT93.TXT     09/19/95	11,107 	   348		 7
CCSLT93.TXT     09/19/95	79,267 	  2304		 7


Structure of files

Variable Name and Format

CCPOP93.TXT
Name           Type      Width     Decimal        Units
RKI         Character      10        0            River Km Index
Station     Character      2         0            CC (Contra Costa)
Date        Date           8         0            MMDDYY
StartTime   Character      4         0            24 hr clock (PST)
StopTime    Character      4         0            24 hr clock (PST)
HrsSampled  Numeric        4         2            Total hours
WaterTemp   Numeric        2         0            Fahrenheit
VolSampled  Numeric        9         2            Volume(cubic meters)


CCPCT93.TXT
Name           Type      Width     Decimal        Units
RKI         Character     10         0            River Km Index
Station     Character      2         0            CC (Contra Costa)
Date        Date           8         0            MMDDYY
Time        Character      4         0            24 hr clock (PST)
SpCode      Numeric        2         0            Species code
Count       Numeric        4         0            Number captured
Partial     Numeric        2         0            Partial fish collected


CCPLT93.TXT
Name           Type      Width     Decimal        Units
RKI         Character     10         0            River Km Index
Station     Character      2         0            CC (Contra Costa)
Date        Date           8         0            MMDDYY
Time        Character      4         0            24 hr clock (PST)
SpCode      Numeric        2         0            Species code
Lgt         Numeric        3         0            Fork length (mm)


CCSOP93.TXT
Name           Type      Width     Decimal        Units
RKI         Character     10         0            River Km Index
Station     Character      2         0            CC (Contra Costa)
StartDate   Date           8         0            MMDDYY
StartTime   Character      4         0            24 hr clock (PST)
BegTemp     Numeric        2         0            Fahrenheit
EndDate     Date           8         0            MMDDYY
EndTime     Character      4         0            24 hr clock (PST)
EndTemp     Numeric        2         0            Fahrenheit
HrsSampled  Numeric        5         2            Total hrs sampled
AcreFt1     Numeric        6         2            Daily acre-ft pumped
                                                  on start date
AcreFt2     Numeric        6         2            Daily acre-ft pumped
                                                  on end date


CCPCT93.TXT
Name           Type      Width     Decimal        Units
RKI         Character     10         0            River Km Index
Station     Character      2         0            CC (Contra Costa)
Date        Date           8         0            MMDDYY
Time        Character      4         0            24 hr clock (PST)
SpCode      Numeric        2         0            Species code
Count       Numeric        6         0            Total no. captured
Partial     Numeric        2         0            Partial fish collected


CCSLT93.TXT
Name           Type      Width     Decimal        Units
RKI         Character     10         0            River Km Index
Station     Character      2         0            CC (Contra Costa)
Date        Date           8         0            MMDDYY
Time        Character      4         0            24 hr clock (PST)
SpCode      Numeric        2         0            Species code
Lgt         Numeric        3         0            Fork length (mm)
AdClip      Character      1         0            "C" = adipose-clipped
                                                  "N" = non adipose-clipped

Latitude/Longitude: N/A