# RDB Table: Reach definition rdb table
# Created by Cathy M. Tate
# Contains level 1 habitat reach definition data for 1993, 1994 and 1996.
# NOTE: The column REACHID is not defined for this table in the data dictionary but is added here for clarification.
# NOTE: No letter label = BFS reach only in 1993
#   For 1994 (multiple reaches done), C = BFS reach, A = Downstream from
#   BFS reach, and B = Upstream from BFS reach (e.g. upstream to downstream = B-C-A)
# 
SEGCODE REACHID REACHNO STAID   DSRCHEND        USRCHEND        DSBMBK  USBMBK  DATE    STRMTYP REACHCOM
15N     4S      4N      15N     10N.1   10N.1   12S     12S     10D     1N      160S
06719505        1       1       06719505        0       150     right   left    1993.08.23      2       Habitat features are in square meters; 
06752000        2       3       06752000        0       179     left    left    1993.08.26      2       Habitat features are in square meters; 
06753400        3       1       06753400        5.2     183.2   left    left    1993.07.20      2       Habitat features are in square meters; 
06753990        4       1       06753990        15.5    209.2   left    left    1993.07.21      1       Habitat features are in square meters; 
06759910        5       3       06759910        114     379     right   left    1993.07.27      3       Habitat features are in square meters; 
06713500        6       1       06713500        0       152                     1993.08.04      4       Habitat features are in square meters; 
06714000        7       1       06714000        0       337.8   left    left    1993.07.23      4       Habitat features are in square meters; 
06754000        8       1       06754000        303     536     right   left    1993.08.02      2       Habitat features are in square meters; 
06765500        9       1       06765500        24.3    256.6   left    right   1993.07.28      3       Habitat features are in square meters; 
06731000        10      3       06731000        104.5   329.3   left    left    1993.08.25      2       Habitat features are in square meters; 
06720500        11      3       06720500        92      362     left    left    1993.07.27      2       Habitat features are in square meters; 
06713500        12      1       06713500        0       156.6                   1994.07.12      4       Habitat features are in square meters; 
06714000        13      1       06714000        0       293     left            1994.07.07      4       Habitat features are in square meters; 
06753400        14      1       06753400        0       178     left    left    1994.07.20      2       Habitat features are in square meters; 
06719505        15      1       06719505        0       150     right   left    1994.08.11      2       Habitat features are in square meters; 
06720500-C      16      3       06720500        0       270     left    left    1994.07.18      2       Habitat features are in square meters; 
06720500-A      17      1       06720500        0       349.6   left    left    1994.07.22      2       Habitat features are in square meters; 
06720500-B      18      2       06720500        308     0       left    left    1994.07.19      2       Habitat features are in square meters; 
06753990        19      1       06753990        0       193.7   left            1994.07.20      1       Habitat features are in square meters; 
06754000        20      1       06754000        0       233     right   left    1994.07.21      2       Habitat features are in square meters; 
06752000-C      21      3       06752000        0       179     left    left    1994.08.17      2       Habitat features are in square meters; 
06752000-A      22      1       06752000        0       191     left    left    1994.07.17      2       Habitat features are in square meters; 
06752000-B      23      2       06752000        0       155     right   left    1994.08.17      2       Habitat features are in square meters; 
06765500        24      1       06765500        0       232.3   left    left    1994.07.25      3       Habitat features are in square meters; 
06731000-A      25      1       06731000        0       190     right   right   1994.07.28      2       Habitat features are in square meters; 
06731000-B      26      2       06731000        0       175     left    left    1994.07.29      2       Habitat features are in square meters; 
06731000-C      27      3       06731000        0       224.8   left            1994.07.28      2       Habitat features are in square meters; 
06759910-C      28      3       06759910        0       265     right           1994.07.27      3       Habitat features are in square meters; 
06759910-A      29      1       06759910        0       220     right   right   1994.07.26      3       Habitat features are in square meters; 
06759910-B      30      2       06759910        0       220     right   right   1994.07.26      3       Habitat features are in square meters; 
402114105350101 31      1       402114105350101 166     0       left    right   1996.08.08      2       Habitat features are in square meters; bank angels = 0 represent negative bank angles (bank undercut)