Department of Water Resources Home
IEP Banner

Data File Format


North Bay Aqueduct- Format File 


List of file names or naming convention(s):

          nbasppre.dat  species data pre-project
          nbasppst.dat  species data post-project
          nbafldpr.dat  physical-chemical data pre-project
          nbafldps.dat  physical-chemical data post-project

Date of last update:    12/13/94

Size of file in bytes:
          nbasppre.dat=37,429;
          nbasppst.dat=116,527;   
          nbafldpr.dat=4,457;
          nbafldps.dat=11,517

5.  Structure of each file:
         a) number of variables:
            nbasppre=24; nbasppst=24; nbafldpr=11; nbafldps=11
         
         b) number of records:
            nbasppre=439; nbasppst=1379; nbafldpr=98; nbafldps=249

5.  Structure of nbafldpr and nbafldps file:
c)  Variable names, variable format and variable length:
   

1)  RKI                 River Kilometer Index
                                      Column 2 characters wide.
2)  Station             BS1=Barker Slough, station #1; BS2=Barker Slough,
                        station #2; BS3=#3; BS4=#4; BS5=#5. 
                        LS_=Lindsey Slough sites.
                                      Column 3 character wide.
3)  Date                Year, month, day.
                                      Column 8 characters wide.
4)  Time                N/A
5)  Depth               Depth in feet.
                                      Column 3 character wide.
6)  Secchi              Turbidity readings in centimeters (cm) using
                        a secchi disc.
                                      Column 4 characters wide.
7)  Temperature         Water temperature in degrees Fahrenheit.
                                      Column 3 character wide
8)  Temperature         Water temperature in degrees Celsius.
                                      Column 3 character wide
9)  Dissolved oxygen    In parts per million (ppm). 
                                      Column 3 characters wide.
10) EC                  Electrical conductivity.
                                      Column 3 characters wide.
11) Width               Channel width
                                      Column 2 characters wide.

5.  Structure of nbasppre and nbasppst file:
c)  Variable names, variable format and variable length:
    

1)  RKI                 River Kilometer Index
                                      Column 2 characters wide.
2)  Station             BS1=Barker Slough, station #1; BS2=Barker Slough,
                        station #2; BS3=#3; BS4=#4; BS5=#5.
                        LS_=Lindsey Slough sites.
                                      Column 3 character wide.
3)  Date                Year, month, day.
                                      Column 8 characters wide.
4)  Time                N/A
5)  Depth               N/A
6)  Gear                Gear used: OT=otter trawl; GNLM=gill net, large-mesh;
                        GNSM=gill net, small mesh.
                                      Column 4 character wide.             
7)  Species             Species code of fish caught. See Fish Facilities
                        Species Codes list.    
8)  # fish caught       Total number of fish caught.
                                      Column 3 characters wide.
9)  # measured          Number of that species measured.
                                      Column 2 characters wide.     
10-24) Fork length      Forklength of fish in millimeters (mm).
                                      Column 4 characters wide.