The goal of the script is to associate each population (defined by the fields POP_ID = IndexId, the latter also specifying the species acronym) in the cleaned NuSEDS dataset (i.e., NuSEDS_escapement_data_collated_DATE.csv) to the conservation unit identidication number cuid, as defined in the Pacific Salmon explorer (PSE). The cleaning procedure is coded in the script 1_nuseds_collation.rmd and is visible in 1_nuseds_collation.html.

1 Import datasets

Import the cleaned NuSEDS dataset with the following decisions made concerning zeros:

## [1] "Time series only composed of NAs were removed from NUSEDS in the early cleaning process in 1_nuseds_collation.rmd, the ones also including zeros are kept."
## [1] "Zeros are NOT replaced by NAs."

The PSE file conservationunits_decoder.csv is imported; this is the file containing the current cuid associated to NuSEDS’s FULL_CU_IN (named cu_index in the decoder file).

Import the streamlocationids.csv to access the location names, coordinates and identification number for maintaining consistency.

## [1] "Date last modification of streamlocationids.csv: 2025-03-18 14:18:59.444315"
##                               region          sys_nm GFE_ID latitude longitude
## 1                             Fraser HOPEDALE SLOUGH     67 49.09193 -122.0348
## 2 Vancouver Island & Mainland Inlets  ANDERSON CREEK   2615 49.63934 -123.9835
## 3 Vancouver Island & Mainland Inlets   GLENORA CREEK   2624 48.74320 -123.7102
## 4 Vancouver Island & Mainland Inlets    KELVIN CREEK   2625 48.74925 -123.6891
## 5 Vancouver Island & Mainland Inlets  MESACHIE CREEK   2627 48.81571 -124.1253
## 6 Vancouver Island & Mainland Inlets     MYERS CREEK   2616 49.64093 -123.9865
##      cu_name_pse cuid streamid
## 1   Lower Fraser  701        1
## 2 Georgia Strait  904        2
## 3 Georgia Strait  904        3
## 4 Georgia Strait  904        4
## 5 Georgia Strait  904        5
## 6 Georgia Strait  904        6

Import the regions’ shape files. These represent the geographic boundaries as displayed in the PSE.

2 Modifications

2.1 Add the field StatArea

This new StatArea field is equivalent to the original field AREA with the following changes made:

##    AREA StatArea
## 1     1       01
## 2    2W      02W
## 3    3A        3
## 4    3B        3
## 5    4A        4
## 6    4B        4
## 7    4C        4
## 8    4D        4
## 9     5       05
## 10    6       06
## 11    7       07
## 12    8       08
## 13    9       09

We also make the following changes for certain IndexId/POP_ID:

# Make corrections for populations with discrepancies in area assignments #
# These errors become apparent when merging data frames later on #
nuseds[nuseds$IndexId == "CO_46240",]$StatArea <- "29"    # vs. "29J" "29K"
nuseds[nuseds$IndexId == "PKO_51094",]$StatArea <- "12"  # BSC: there is one ""
nuseds[nuseds$IndexId == "SX_45495",]$StatArea <- "120"  # BSC: already "120"

cond <- nuseds$IndexId %in% c("CO_46240","PKO_51094","SX_45495")
cond2 <- nuseds$AREA != nuseds$StatArea

show <- nuseds[cond & cond2,c("IndexId","AREA","StatArea")]|> unique()
rownames(show) <- NULL
show
##    IndexId AREA StatArea
## 1 CO_46240  29K       29

2.2 Add the field FULL_CU_IN_PSE

The FULL_CU_IN of several population is updated to reflect (1) partition of the Sockeye CU FULL_CU_IN = “SEL-21-02” into sub-groups (EW: ‘Early Wild’, for Babine/Onerka; LW: ‘Late Wild’ for Nilkitkwa, and F: Fulton and Pinkut) as in DFO 2023; (2) recent corrections for the Bella Coola River-Late CU (CM-17) and Bella Coola-Dean Rivers (CM-16) (personal communication from Carrie Holt, DFO, May 2023). The field FULL_CU_IN_PSE is created to reflect these changes.

##          region species_name                CU_NAME             cu_name_pse
## 1        Skeena Lake sockeye                 BABINE           Babine/Onerka
## 2        Skeena Lake sockeye                 BABINE               Nilkitkwa
## 3        Skeena Lake sockeye                 BABINE       Babine (enhanced)
## 4 Central Coast         Chum BELLA COOLA RIVER-LATE Bella Coola-Dean Rivers
##   FULL_CU_IN FULL_CU_IN_PSE
## 1  SEL-21-02   SEL-21-02-EW
## 2  SEL-21-02   SEL-21-02-LW
## 3  SEL-21-02    SEL-21-02-F
## 4      CM-17          CM-16

2.3 CU_NAME updates

Additionally, the CU_NAME of the river Sockeye at SYSTEM = “BELLA COOLA RIVER” (GFE_ID = 968) is changed from:

##   SPECIES_QUALIFIED                 CU_NAME       SYSTEM_SITE GFE_ID
## 1               SER NORTHERN COASTAL FJORDS BELLA COOLA RIVER    968

to:

##   SPECIES_QUALIFIED             CU_NAME       SYSTEM_SITE GFE_ID
## 1               SER SOUTH ATNARKO LAKES BELLA COOLA RIVER    968

2.4 Add the field stream_survey_quality

We create the field stream_survey_quality from ESTIMATE_CLASSIFICATION such as:

##                  ESTIMATE_CLASSIFICATION stream_survey_quality
## 1                TRUE ABUNDANCE (TYPE-1)                  High
## 2                TRUE ABUNDANCE (TYPE-2)           Medium-High
## 3            RELATIVE ABUNDANCE (TYPE-3)                Medium
## 4            RELATIVE ABUNDANCE (TYPE-4)            Medium-Low
## 5            RELATIVE ABUNDANCE (TYPE-5)                   Low
## 6              PRESENCE-ABSENCE (TYPE-6)                   Low
## 7  RELATIVE: CONSTANT MULTI-YEAR METHODS                   Low
## 8   RELATIVE: VARYING MULTI-YEAR METHODS                   Low
## 9                                UNKNOWN               Unknown
## 10                   NO SURVEY THIS YEAR                  <NA>
## 11                             NO SURVEY                  <NA>
## 12             PRESENCE/ABSENCE (TYPE-6)                   Low
## 13                                                        <NA>

2.5 Fixes on ESTIMATE_METHOD

We make the following corrections to the field ESTIMATE_METHOD:

##            ESTIMATE_METHOD              correction
## 1              Cummulative              Cumulative
## 2                  Unknown Unknown Estimate Method
## 3        Fixed Site Census             Fence Count
## 4                   Aerial           Aerial Survey
## 5                    Fence             Fence Count
## 6 Insufficient Information Unknown Estimate Method

3 Find the cuid from FULL_CU_IN_PSE

We associate the previously defined field FULL_CU_IN_PSE to the PSE’s cuid, cu_name_pse, cu_name_dfo, region, using the conservationunits_decoder.csv. For instance:

##                               region SPECIES                CU_NAME
## 1                             Fraser    Chum           LOWER FRASER
## 2 Vancouver Island & Mainland Inlets    Chum         GEORGIA STRAIT
## 3                             Fraser    Chum           Lower Fraser
## 4                               <NA>    Chum INTERIOR FRASER<<BIN>>
## 5                        Haida Gwaii    Chum              SKIDEGATE
## 6                      Central Coast    Chum        DOUGLAS-GARDNER
##              cu_name_dfo     cu_name_pse FULL_CU_IN_PSE cuid
## 1           Lower Fraser    Lower Fraser           CM-2  701
## 2         Georgia Strait  Georgia Strait           CM-4  904
## 3           Lower Fraser    Lower Fraser           CM-2  701
## 4                   <NA>            <NA>        CM-9004   NA
## 5              Skidegate       Skidegate          CM-22  804
## 6 Douglas-Gardner (Chum) Douglas-Gardner          CM-20  508

There are 23 FULL_CU_IN that are not in conservationunits_decoder.csv. We use the regions’ shape file to find their respective region:

##                                                  CU_NAME FULL_CU_IN cuid
## 1                                 INTERIOR FRASER<<BIN>>    CM-9004   NA
## 2       FRASER-CROSS-CU SUPPLEMENTATION EXCLUSION<<BIN>>    CK-9006   NA
## 3                             SOUTH-MISCELLANEOUS<<BIN>>    CK-9005   NA
## 4                    (P)HATCHERY EXCLUSION-PALLANT CREEK    CK-9002   NA
## 5                            FRASER-MISCELLANEOUS<<BIN>>    CK-9004   NA
## 6  SOUTHERN BC-CROSS-CU SUPPLEMENTATION EXCLUSION<<BIN>>    CK-9007   NA
## 7          FRASER-HARRISON FALL TRANSPLANT_FA_0.3<<BIN>>    CK-9008   NA
## 8                                    FRASER RIVER<<BIN>>   PKE-9005   NA
## 9                                           UPPER FRASER     SER-06   NA
## 10                  FRASER RIVER MIGRATORY COUNTS<<BIN>>  SEL-03-xx   NA
## 11                           GREAT CENTRAL/SPROAT<<BIN>>  SEL-13-xx   NA
## 12                                 CARIBOO-SUMMER TIMING  SEL-06-18   NA
## 13                                             OWOSSITSA  SEL-13-21   NA
## 14                                                WHALEN  SEL-18-11   NA
## 15                                  FRANCOIS-LATE TIMING  SEL-06-05   NA
## 16         (P)ADAMS AND MOMICH LAKES-EARLY SUMMER TIMING  SEL-09-xx   NA
## 17                          FRANCOIS-EARLY SUMMER TIMING  SEL-06-04   NA
## 18                                         MIDDLE FRASER     SER-05   NA
## 19                     INDIAN/KRUGER-EARLY SUMMER TIMING  SEL-07-02   NA
## 20                                                  PACK  SEL-11-11   NA
## 21                                           (N)GLENDALE  SEL-11-12   NA
## 22                                   OWIKENO-LATE TIMING  SEL-15-03   NA
## 23                                           VILLAGE BAY  SEL-11-10   NA
##      CU_LAT  CU_LONGT                             region
## 1  49.83262 -121.4864                             Fraser
## 2  49.20557 -122.2647                             Fraser
## 3  48.62104 -123.6267 Vancouver Island & Mainland Inlets
## 4  53.05171 -132.0330                        Haida Gwaii
## 5  49.93296 -122.1751                             Fraser
## 6  49.67006 -123.9409 Vancouver Island & Mainland Inlets
## 7  49.06245 -121.6467                             Fraser
## 8  50.49251 -122.4648                             Fraser
## 9  53.61510 -120.8006                             Fraser
## 10 50.62197 -121.9441                             Fraser
## 11 49.24618 -124.8201 Vancouver Island & Mainland Inlets
## 12 52.78683 -121.3466                             Fraser
## 13 49.82836 -126.9177 Vancouver Island & Mainland Inlets
## 14 53.24728 -129.0723                      Central Coast
## 15 53.92982 -126.7652                             Fraser
## 16 51.30204 -119.4039                             Fraser
## 17 53.97423 -126.6841                             Fraser
## 18 52.39530 -122.6734                             Fraser
## 19 53.44522 -121.5672                             Fraser
## 20 51.17131 -127.4701 Vancouver Island & Mainland Inlets
## 21 50.65101 -125.7236 Vancouver Island & Mainland Inlets
## 22 51.72770 -127.0454                      Central Coast
## 23 50.20400 -125.2333 Vancouver Island & Mainland Inlets

The CU above with FULL_CU_IN = SEL-09-xx is split into the two following CUs to reflect COSEWIC’s grouping (note the creation of the field cu_name_pse):

##   FULL_CU_IN FULL_CU_IN_PSE                                       CU_NAME
## 1  SEL-09-xx      SEL-09-04 (P)ADAMS AND MOMICH LAKES-EARLY SUMMER TIMING
## 3  SEL-09-xx      SEL-09-04 (P)ADAMS AND MOMICH LAKES-EARLY SUMMER TIMING
## 2  SEL-09-xx      SEL-09-05 (P)ADAMS AND MOMICH LAKES-EARLY SUMMER TIMING
## 4  SEL-09-xx      SEL-09-05 (P)ADAMS AND MOMICH LAKES-EARLY SUMMER TIMING
## 5  SEL-09-xx      SEL-09-05 (P)ADAMS AND MOMICH LAKES-EARLY SUMMER TIMING
##           cu_name_pse cuid            WATERBODY
## 1  Adams-Early Summer  760         BURTON CREEK
## 3  Adams-Early Summer  760  ADAMS RIVER - UPPER
## 2 Momich-Early Summer  761 MOMICH RIVER - UPPER
## 4 Momich-Early Summer  761         MOMICH RIVER
## 5 Momich-Early Summer  761        CAYENNE CREEK

We show below the corresponding time series for the rest of the unmatched CUs:

These time series are kept in the dataset but will be removed in the next step/script.

4 Work on locations

4.1 Corrections

There are two LOCAL_NAME_1 with typos, which we replace by the value in SYSTEM_SITE:

##      SYSTEM_SITE      WATERBODY      LOCAL_NAME_1 LOCAL_NAME_2
## 1 BARRIERE RIVER BARRIERE RIVER BARRI\xc8RE RIVER             
## 2  FRANCOIS LAKE  FRANCOIS LAKE  FRAN\xc7OIS LAKE

We also create the field sys_nm, which is equivalent of SYSTEM_SITE but the following corrections or modification for the following locations:

##                                      SYSTEM_SITE
## 1                                 ADA COVE CREEK
## 2                                  ADAMS CHANNEL
## 3                   ADAMS LAKE EAST SIDE - SHORE
## 4                   ADAMS LAKE NORTH END - SHORE
## 5                   ADAMS LAKE SOUTH END - SHORE
## 6                           ANSTEY RIVER - SHORE
## 7                     BABINE RIVER - SECTION 1-3
## 8                     BABINE RIVER - UNACCOUNTED
## 9                           BEALE'S LAGOON CREEK
## 10                             BIG SLIDE - SHORE
## 11                       BIG SLIDE - SHORE 1KM W
## 12                      BILL MINER CREEK - SHORE
## 13                BILL MINER CREEK - SHORE 3KM W
## 14                       BLUE LEAD CREEK - SHORE
## 15                           BOISE CREEK - NORTH
## 16                       BOTANY INLET HEAD CREEK
## 17                      BOTANY INLET OUTER CREEK
## 18                                 BOUGHEY CREEK
## 19                        BOULDERY CREEK - SHORE
## 20                  BOULDERY CREEK - SHORE 2KM E
## 21                   BOWLING POINT - GOOSE POINT
## 22                               BRENNAN CHANNEL
## 23                     BUCK CHANNEL CREEK #EIGHT
## 24                      BUCK CHANNEL CREEK #FIVE
## 25                       BUCK CHANNEL CREEK #ONE
## 26                     BUCK CHANNEL CREEK #SEVEN
## 27                       BUCK CHANNEL CREEK #SIX
## 28                     BUCK CHANNEL CREEK #THREE
## 29                       BUCK CHANNEL CREEK #TWO
## 30                BURNABY NARROWS FIRST R.H. CR.
## 31               BURNABY NARROWS SECOND R.H. CR.
## 32                         BURNABY STRAITS CREEK
## 33                                  BURTON CREEK
## 34                            BUSH CREEK - SHORE
## 35                              CAPE SCOTT CREEK
## 36                              CARRINGTON CREEK
## 37                            CENTENNIAL CHANNEL
## 38                                 CHAMISS CREEK
## 39                                CHILKO CHANNEL
## 40                              CHILLIWACK RIVER
## 41                         CHOKE PASS CREEKS (3)
## 42                                  CHONAT CREEK
## 43                              CLOSE CREEKS (2)
## 44                                   COHOE CREEK
## 45                               CONE CREEKS (2)
## 46                           COOPER INLET CREEKS
## 47                      COTTONWOOD RIVER - UPPER
## 48                        CROWN ZELLERBACK CREEK
## 49                        CRUICKSHANK POINT WEST
## 50                                 DANA #1 CREEK
## 51                                 DANA #2 CREEK
## 52                                 DANA #3 CREEK
## 53                           DEVOE CREEK - SHORE
## 54                                    DOME CREEK
## 55                                 DOMINIC CREEK
## 56                              DOUBLE T - SHORE
## 57                      DOUGLAS INLET HEAD CREEK
## 58                DOUGLAS INLET RIGHT HAND CREEK
## 59                      ELYSIA - SHORE 1 KM WEST
## 60                          EVANS INLET #3 CREEK
## 61                           FAIRFAX OUTER CREEK
## 62                   FANNIE COVE LEFT HAND CREEK
## 63                  FANNIE COVE RIGHT HAND CREEK
## 64                              FILLONGLEY CREEK
## 65                                FORSYTHE CREEK
## 66                       FOUR MILE CREEK - SHORE
## 67                          FRANKS CREEK - SHORE
## 68                                 GIRRARD CREEK
## 69                    GOOSE POINT - SHORE .8KM S
## 70                     GOOSE POINT - SHORE 5KM S
## 71                                  GOSSAN CREEK
## 72                           GRAIN CREEK - SHORE
## 73                     GRAY BAY CREEK OTHERS (3)
## 74                          GRIBBLE ISLAND CREEK
## 75                                  GROUSE CREEK
## 76                             HARTLEY BAY CREEK
## 77                                HENDERSON LAKE
## 78                    HESQUIAT HARBOUR #1 CREEKS
## 79                    HESQUIAT HARBOUR #2 CREEKS
## 80                    HESQUIAT HARBOUR #3 CREEKS
## 81                    HESQUIAT HARBOUR #4 CREEKS
## 82                           HLINA CREEK - SHORE
## 83                   HOCHSTADER BASIN CREEKS (2)
## 84                               HURRICANE POINT
## 85                   HUSTON R.H. AND L.H. CREEKS
## 86                             HUTTON HEAD CREEK
## 87                        HUTTON LEFT HAND CREEK
## 88                               HYACINTHE CREEK
## 89                                  IKNOUK RIVER
## 90                 INDIAN CABIN CREEK RIGHT HAND
## 91                     INNER BASIN CREEK (BLACK)
## 92                    INNER BASIN RIVER (RANSOM)
## 93                            ISHKHEENICKH RIVER
## 94                    ISLAND BAY LEFT HAND CREEK
## 95                   ISLAND BAY RIGHT HAND CREEK
## 96                                   JAMES CREEK
## 97                            JOHNNY SANDY CREEK
## 98                           JONES CREEK CHANNEL
## 99                              JUNCTION - SHORE
## 100                                 KAISUN CREEK
## 101                      KILDIDT LAGOON #2 CREEK
## 102                        KILLDOG CREEK - SHORE
## 103                              KINCOLITH RIVER
## 104                                 KITASU CREEK
## 105                         KNIGHT CREEK - SHORE
## 106                                 KSEDIN CREEK
## 107                              KWINAMASS RIVER
## 108                               KWINYIAK RIVER
## 109                      LAGINS RIGHT HAND CREEK
## 110                   LASSITER AND ROWLEY CREEKS
## 111                            LEE CREEK - SHORE
## 112                                 LILMAC CREEK
## 113                              LIMESTONE POINT
## 114               LIMESTONE POINT - SHORE .5KM S
## 115               LITTLE WHITEPINE COVE #1 CREEK
## 116                              LOCKEPORT CREEK
## 117                           LONG CREEK - SHORE
## 118                                  LONZO CREEK
## 119           LOST VALLEY CREEK - SHORE SPAWNERS
## 120                            LOWE INLET SYSTEM
## 121                     LOWER AHWHICHAOLTO CREEK
## 122                       LOWER PARADISE CHANNEL
## 123                           LYNX CREEK - SHORE
## 124                               M.E.S.S. CREEK
## 125                             MACDOUGALL CREEK
## 126                     MAMQUAM SPAWNING CHANNEL
## 127              MARSHALL INLET RIGHT HAND CREEK
## 128                         MARTEN CREEK - SHORE
## 129                          MATHESON L.H. CREEK
## 130                    MATHESON RIGHT HAND CREEK
## 131                             MCKAY COVE CREEK
## 132                                MCQUEEN CREEK
## 133                               MESACHIE RIVER
## 134         MIDDLE NORTH THOMPSON RIVER MAINSTEM
## 135                                 MIKADO CREEK
## 136                                 MILLER CREEK
## 137                         MOMICH RIVER - SHORE
## 138                                MOODY CHANNEL
## 139                      NESTO INLET OUTER CREEK
## 140                                 NIGGER CREEK
## 141                   NORTH ARM CREEK RIGHT HAND
## 142                         NORTH HATCHERY CREEK
## 143                           ONYX CREEK - SHORE
## 144                                    OPA BEACH
## 145                                   OWEN CREEK
## 146                      PASS CREEK - LAKE SHORE
## 147                       PEACH SPAWNING CHANNEL
## 148               PEEL INLET 1ST LEFT HAND CREEK
## 149               PEEL INLET 2ND LEFT HAND CREEK
## 150                              PENDELTON CREEK
## 151                         PENFOLD CAMP - SHORE
## 152                         PIG CHANNEL COMBINED
## 153                       POOLE INLET CREEKS (4)
## 154                                 POPKUM CREEK
## 155                         QUEEST CREEK - SHORE
## 156      QUESNEL LAKE EAST ARM - UNNAMED CREEK 1
## 157        QUESNEL LAKE NORTH ARM - UNNAMED COVE
## 158                                 RAINEY CREEK
## 159                              REINECKER CREEK
## 160                            RESCUE BAY CREEKS
## 161                                ROARING POINT
## 162              ROARING RIVER - DECEPTION POINT
## 163                        ROARING RIVER - SHORE
## 164        ROCK SLIDE TO PENINSULA POINT - SHORE
## 165                           ROSS CREEK - SHORE
## 166                    SALTSPRING BAY L.H. CREEK
## 167                            SCHOOLHOUSE CREEK
## 168                         SCOTCH CREEK - SHORE
## 169                            SEASKINNISH CREEK
## 170                SECTION COVE RIGHT HAND CREEK
## 171               SECURITY INLET LEFT HAND CREEK
## 172              SECURITY INLET RIGHT HAND CREEK
## 173             SETON CHANNELS - UPPER AND LOWER
## 174                                SGAWBAN CREEK
## 175                                 SHUMAL CREEK
## 176                    SHUSWAP LAKE  SEYMOUR ARM
## 177                      SHUSWAP LAKE ANSTEY ARM
## 178                        SHUSWAP LAKE MAIN ARM
## 179          SHUSWAP LAKE MAIN ARM - NORTH SHORE
## 180          SHUSWAP LAKE MAIN ARM - SOUTH SHORE
## 181                      SHUSWAP LAKE SALMON ARM
## 182         SHUSWAP LAKE SALMON ARM - EAST SHORE
## 183        SHUSWAP LAKE SALMON ARM - NORTH SHORE
## 184        SHUSWAP LAKE SALMON ARM - SOUTH SHORE
## 185                     SKAAT HARBOUR HEAD CREEK
## 186                      SKAAT HARBOUR L.H.CREEK
## 187                     SKAAT HARBOUR R.H. CREEK
## 188                      SLATE BAY - SHORE 1KM E
## 189                             SLIM INLET CREEK
## 190                           SOUTH BAY #1 CREEK
## 191                      SOUTH BAY CULVERT CREEK
## 192                            SQUEAH LAKE CREEK
## 193 STEPHENS CREEK (DOWNSTREAM OF STEPHENS LAKE)
## 194                               SURPRISE CREEK
## 195                   SWAN LAKE CREEK #2 UNNAMED
## 196                       TARTU INLET HEAD CREEK
## 197                      TARTU INLET OUTER CREEK
## 198                                 TASEKO LAKES
## 199                          TASSE CREEK - SHORE
## 200                             TATSAMENIE RIVER
## 201                           TRACY BAY #2 CREEK
## 202                                  TSEAX RIVER
## 203                                 TSEAX SLOUGH
## 204                TSUIUS CREEK - SHORE SPAWNERS
## 205                                   TUNO CREEK
## 206               UNNAMED CREEK - SHORE SPAWNERS
## 207                                UNNAMED POINT
## 208                     UPPER AHWHICHAOLTO CREEK
## 209                       UPPER PARADISE CHANNEL
## 210                      VANISHING CREEK - SHORE
## 211                            VILLAGE BAY CREEK
## 212                          WASKO CREEK - SHORE
## 213                           WATT CREEK - SHORE
## 214                               WEAVER CHANNEL
## 215                              WEST ROAD RIVER
## 216                                 WRIGHT CREEK
## 217                            WRIGHT LAKE CREEK
## 218                        YOHETTA CREEK - LOWER
## 219                                 ZOLZAP CREEK
## 220                                ZOLZAP SLOUGH
##                                          sys_nm     GFE_ID
## 1                   COOPER INLET-ADA COVE CREEK       2683
## 2                  ADAMS RIVER MOUTH-LAKE SHORE       2432
## 3                       ADAMS LAKE-E-LAKE SHORE      11556
## 4                       ADAMS LAKE-N-LAKE SHORE      11557
## 5                       ADAMS LAKE-S-LAKE SHORE      11558
## 6                       ANSTEY RIVER-LAKE SHORE      17212
## 7                  Babine River-Sections 1 To 3        592
## 8                            Babine-Unaccounted        591
## 9                                SCRIBNER CREEK       1803
## 10                         BIG SLIDE-LAKE SHORE      11492
## 11                   BIG SLIDE-LAKE SHORE-1KM W      11493
## 12                  BILL MINER CREEK-LAKE SHORE      11494
## 13            BILL MINER CREEK-LAKE SHORE-3KM W      11495
## 14                   BLUE LEAD CREEK-LAKE SHORE      11496
## 15                            NORTH BOISE CREEK      26776
## 16                      BOTANY INLET CREEK-HEAD       1652
## 17                     BOTANY INLET CREEK-OUTER       1651
## 18                 BOUGHEY BAY UNNAMED CREEK #2        838
## 19                    BOULDERY CREEK-LAKE SHORE      11497
## 20                  BOULDERY CREEK-E-LAKE SHORE      11498
## 21                 BOWLING POINT TO GOOSE POINT      11532
## 22                BRENNAN PARK SPAWNING CHANNEL        712
## 23                        BUCK CHANNEL CREEK #8       1676
## 24                        BUCK CHANNEL CREEK #5       2341
## 25                        BUCK CHANNEL CREEK #1       1674
## 26                        BUCK CHANNEL CREEK #7    7990641
## 27                        BUCK CHANNEL CREEK #6       2651
## 28                        BUCK CHANNEL CREEK #3       1675
## 29                        BUCK CHANNEL CREEK #2       2342
## 30              BURNABY NARROWS CREEK-FIRST R/H       1717
## 31             BURNABY NARROWS CREEK-SECOND R/H       1718
## 32                      BURNABY STRAIGHTS CREEK       1623
## 33                                  KSGYUKWSA'A        634
## 34                        BUSH CREEK-LAKE SHORE      11555
## 35                                 HANSEN CREEK       1492
## 36                        CARRINGTON COVE CREEK       2076
## 37                  CENTENNIAL SPAWNING CHANNEL       2532
## 38                           CHEENIS LAKE CREEK        998
## 39                     CHILKO SPAWNING CHANNELS       2429
## 40                      CHILLIWACK/VEDDER RIVER         62
## 41                            CHOKE PASS CREEKS    7990621
## 42                            CHONAT LAKE CREEK       1138
## 43                                 CLOSE CREEKS       1321
## 44                                   COHO CREEK        182
## 45                                  CONE CREEKS       1323
## 46              COOPER INLET-FANNIE COVE CREEKS       1791
## 47                                  SWIFT RIVER       2457
## 48                       CROWN ZELLERBACH CREEK       1066
## 49                CRUIKSHANK POINT-LAKE SHORE W      11542
## 50                                DANA CREEK #1       1599
## 51                                DANA CREEK #2       1600
## 52                                DANA CREEK #3       1601
## 53                       DEVOE CREEK-LAKE SHORE      11517
## 54                                   HEAD CREEK       1022
## 55                                RUSSELL CREEK       1490
## 56                          DOUBLE T-LAKE SHORE      11499
## 57                     DOUGLAS INLET CREEK-HEAD       1662
## 58                      DOUGLAS INLET CREEK-R/H       1661
## 59                           ELYSIA SHORE-1KM W      11561
## 60                         EVANS INLET CREEK #3       1795
## 61                    FAIRFAX INLET CREEK-OUTER       1649
## 62            COOPER INLET-FANNIE COVE LH CREEK       2687
## 63            COOPER INLET-FANNIE COVE RH CREEK       2708
## 64                          LITTLE GEORGE CREEK       1167
## 65                                 LOVELL CREEK        340
## 66                   FOUR MILE CREEK-LAKE SHORE      11538
## 67                      FRANKS CREEK-LAKE SHORE      11501
## 68                                 MILLER CREEK       1501
## 69                       GOOSE POINT-LAKE SHORE      11519
## 70                GOOSE POINT-LAKE SHORE-5 KM S      11520
## 71                                 Gossen Creek       2352
## 72                       GRAIN CREEK-LAKE SHORE      11521
## 73                       GRAY BAY CREEKS-OTHERS    7990619
## 74                        GRIBBELL ISLAND CREEK       1904
## 75                          GROUSE (MOUL) CREEK      15948
## 76                                 GABION RIVER       1090
## 77                         HENDERSON LAKE CREEK       1273
## 78                    HESQUIAT HARBOUR CREEK #1       2471
## 79                    HESQUIAT HARBOUR CREEK #2       1347
## 80                    HESQUIAT HARBOUR CREEK #3       2472
## 81                    HESQUIAT HARBOUR CREEK #4       2291
## 82                       HLINA CREEK-LAKE SHORE      11543
## 83                       HOCHSTADER BASIN CREEK    7990583
## 84                        HURRICANE POINT SHORE      11502
## 85                          HUSTON INLET CREEKS       1628
## 86                            HUTTON CREEK-HEAD       1609
## 87                             HUTTON CREEK-L/H       1610
## 88                              MCKERCHER CREEK       1134
## 89                                        Xnukw        635
## 90                       INDIAN CABIN CREEK-R/H       1518
## 91                                  BLACK CREEK       1386
## 92                                 RANSOM RIVER       1385
## 93                                   Ksi Hlginx        661
## 94                        ISLAND BAY CREEKS-L/H       1622
## 95                        ISLAND BAY CREEKS-R/H       1621
## 96                      BAD RIVER (JAMES CREEK)        154
## 97                             JOHN SANDY CREEK        206
## 98                      JONES' SPAWNING CHANNEL       2481
## 99                    JUNCTION CREEK-LAKE SHORE      11503
## 100                         BOOMCHAIN BAY CREEK       1673
## 101                     KILDIDT LAGOON CREEK #2       1788
## 102                    KILLDOG CREEK-LAKE SHORE      11504
## 103                                 KSI GINGOLX        630
## 104                               KITASOO CREEK       1820
## 105                     KNIGHT CREEK-LAKE SHORE      11550
## 106                            Ksemamaith Creek        642
## 107                                 Ksi X'Anmas       1756
## 108                                  Ksi Mat'In        641
## 109                             LAGINS CREEK-RH       1516
## 110                              LASSITER CREEK    7990609
## 111                        LEE CREEK-LAKE SHORE      11544
## 112                               Fortune Creek        359
## 113                LIMESTONE PIONT-LAKE SHORE-S      11523
## 114                  LIMESTONE PIONT-LAKE SHORE      11524
## 115              LITTLE WHITEPINE COVE CREEK #1       1332
## 116                            LONGFELLOW CREEK       1603
## 117                       LONG CREEK-LAKE SHORE      11526
## 118                              MARSHALL CREEK         87
## 119                LOST VALLEY CREEK-LAKE SHORE      26778
## 120                              KUMOWDAH RIVER       1092
## 121                    AHWHICHAOLTO CREEK-LOWER       1481
## 122             PARADISE SPAWNING CHANNEL-LOWER        721
## 123                       LYNX CREEK-LAKE SHORE      11505
## 124                           MINETTE BAY CREEK       1047
## 125                             MCDOUGALL CREEK        326
## 126              MAMQUAM RIVER SPAWNING CHANNEL        715
## 127                        MARSHALL INLET CREEK       1612
## 128                     MARTEN CREEK-LAKE SHORE      11527
## 129                          MATHESON CREEK-L/H       1614
## 130                          MATHESON CREEK-R/H       1613
## 131                         MCKAY COVE CREEK #1       1424
## 132                               Hevenor Creek        568
## 133                              MESACHIE CREEK       2627
## 134                NORTH THOMPSON RIVER@VAVENBY 1754239945
## 135                           MIKADO LAKE CREEK       1923
## 136                            CHINUKUNDL CREEK       1502
## 137                     MOMICH RIVER-LAKE SHORE      11559
## 138                    MOODY'S SPAWNING CHANNEL        722
## 139                     NESTO INLET CREEK-OUTER       1546
## 140                                    N. CREEK        856
## 141                          NORTH ARM CREEK-RH       1523
## 142                               Furlong Creek        515
## 143                       ONYX CREEK-LAKE SHORE      11547
## 144                        OPA BEACH-LAKE SHORE      11528
## 145                              OWEN BAY CREEK       1125
## 146                     SINMAX CREEK-LAKE SHORE      11560
## 147                    PEACH CREEK SIDE CHANNEL       2537
## 148                     PEEL INLET CREEK-L/H #1       1668
## 149                     PEEL INLET CREEK-L/H #2       1667
## 150                                 Cross Creek        612
## 151                     PENFOLD CAMP-LAKE SHORE      11529
## 152            NORTH THOMPSON RIVER-PIG CHANNEL  719256264
## 153                          POOLE INLET CREEKS       1716
## 154                                BRIDAL CREEK        103
## 155                     QUEEST CREEK-LAKE SHORE      11539
## 156      QUESNEL LAKE EAST ARM-UNNAMED CREEK #1       2756
## 157           NORTH ARM UNNAMED COVE-LAKE SHORE      11536
## 158                                 Rainy Creek       1781
## 159                             RIENECKER CREEK        235
## 160                            RESCUE BAY CREEK    7990591
## 161                    ROARING POINT-LAKE SHORE      11530
## 162 ROARING RIVER TO DECEPTION POINT-LAKE SHORE      11533
## 163                    ROARING RIVER-LAKE SHORE      11531
## 164    ROCK SLIDE TO PENINSULA POINT-LAKE SHORE      11508
## 165                       ROSS CREEK-LAKE SHORE      11548
## 166                    SALTSPRING BAY CREEK-L/H       1521
## 167                                  COMO CREEK          7
## 168                     SCOTCH CREEK-LAKE SHORE      11549
## 169                              Ksi Sgasginist        655
## 170                       SECTION COVE CREEK-RH       1720
## 171                    SECURITY INLET CREEK-L/H       1671
## 172                    SECURITY INLET CREEK-R/H       1670
## 173             UPPER and  LOWER SETON CHANNELS       2451
## 174                           KSI SGAWBAN CREEK       3548
## 175                                   Ksga'Maal        650
## 176            SHUSWAP LAKE-MAIN ARM-LAKE SHORE      11565
## 177          SHUSWAP LAKE-ANSTEY ARM-LAKE SHORE      11562
## 178         SHUSWAP LAKE-SEYMOUR ARM-LAKE SHORE      11563
## 179          SHUSWAP LAKE MAIN ARM-N-LAKE SHORE      11545
## 180          SHUSWAP LAKE MAIN ARM-S-LAKE SHORE      11546
## 181          SHUSWAP LAKE-SALMON ARM-LAKE SHORE      11564
## 182        SHUSWAP LAKE SALMON ARM-E-LAKE SHORE      11551
## 183        SHUSWAP LAKE-SALMON ARM-N-LAKE SHORE      11552
## 184        SHUSWAP LAKE-SALMON ARM-S-LAKE SHORE      11553
## 185                    SKAAT HARBOUR CREEK-HEAD       1618
## 186                     SKAAT HARBOUR CREEK-L/H       1619
## 187                     SKAAT HARBOUR CREEK-R/H       1617
## 188                  SLATE BAY-LAKE SHORE 1KM E      11510
## 189                                OXALIS CREEK       1627
## 190                          SOUTH BAY CREEK #1       1301
## 191                             SOUTH BAY CREEK       1685
## 192              UNNAMED CREEK NEAR SQUEAH LAKE        119
## 193                              Stephens Creek        585
## 194                             SURPRISE CREEKS       1629
## 195                          Swan Lake Creek #2       2736
## 196                      TARTU INLET CREEK-HEAD       1544
## 197                     TARTU INLET CREEK-OUTER       1543
## 198                                 TASEKO LAKE        287
## 199                      TASSE CREEK-LAKE SHORE      11537
## 200                             TATSAMENIE LAKE       2211
## 201                          TRACY BAY CREEK #2       2309
## 202                                 KSI SII AKS        651
## 203                               Ksi Sii Aks 2        652
## 204                     TSUIUS CREEK-LAKE SHORE      26774
## 205                             TUNO CREEK-EAST       1002
## 206                    UNNAMED CREEK-LAKE SHORE      26770
## 207                    UNNAMED POINT-LAKE SHORE      11512
## 208                    AHWHICHAOLTO CREEK-UPPER       1480
## 209             PARADISE SPAWNING CHANNEL-UPPER        723
## 210                  VANISHING CREEK-LAKE SHORE      11540
## 211                                 CLEAR CREEK       1132
## 212                      WASKO CREEK-LAKE SHORE      11534
## 213                       WATT CREEK-LAKE SHORE      11535
## 214                     WEAVER SPAWNING CHANNEL       2436
## 215                WEST ROAD (BLACKWATER) RIVER        294
## 216                              Big Loon Creek        607
## 217                                WRIGHT CREEK       2745
## 218                               YOHETTA CREEK      26766
## 219                           KSI TS'OOHL TS'AP        647
## 220                         Ksi Ts'Oohl Ts'Ap 2        648

4.2 Attribute streamid to nuseds

The field streamid is a unique combination between a stream (GFE_ID) and CU (cuid). We use the PSE file streamlocationids.csv to match the existing streamid, for instance:

##                               region          sys_nm GFE_ID latitude longitude
## 1                             Fraser HOPEDALE SLOUGH     67 49.09193 -122.0348
## 2 Vancouver Island & Mainland Inlets  ANDERSON CREEK   2615 49.63934 -123.9835
## 3 Vancouver Island & Mainland Inlets   GLENORA CREEK   2624 48.74320 -123.7102
## 4 Vancouver Island & Mainland Inlets    KELVIN CREEK   2625 48.74925 -123.6891
## 5 Vancouver Island & Mainland Inlets  MESACHIE CREEK   2627 48.81571 -124.1253
## 6 Vancouver Island & Mainland Inlets     MYERS CREEK   2616 49.64093 -123.9865
##      cu_name_pse cuid streamid
## 1   Lower Fraser  701        1
## 2 Georgia Strait  904        2
## 3 Georgia Strait  904        3
## 4 Georgia Strait  904        4
## 5 Georgia Strait  904        5
## 6 Georgia Strait  904        6

We match the locations using GFE_ID if available in streamlocationids, and SYSTEM_SITE, Y_LAT and X_LONGT otherwise. In case of the latter, the matched locations are shown below:

##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS ALSEK RIVER   2324 59.44396 -137.9908
## 2 streamlocationids Alsek River     NA 59.44397 -137.9908
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS KLUKSHU RIVER   2332 60.11586 -137.0362
## 2 streamlocationids Klukshu River     NA 60.11586 -137.0362
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS TAKHANNE RIVER   2333 60.09443 -136.9919
## 2 streamlocationids Takhanne River     NA 60.09443 -136.9919
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS BLANCHARD RIVER   2334 60.03215 -136.8936
## 2 streamlocationids Blanchard River     NA 60.03215 -136.8936
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS GOAT CREEK   2335 59.85175 -136.6454
## 2 streamlocationids Goat Creek     NA 59.85175 -136.6454
## [1] ""
##             dataset           location GFE_ID latitude longitude
## 1            NuSEDS TATSHENSHINI RIVER   2325 59.47055 -137.7415
## 2 streamlocationids Tatshenshini River     NA 59.47055 -137.7415
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS KLUKSHU RIVER   2332 60.11586 -137.0362
## 2 streamlocationids Klukshu River     NA 60.11586 -137.0362
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS VILLAGE CREEK   2338 60.12637 -137.0778
## 2 streamlocationids Village Creek     NA 60.12637 -137.0778
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS KLUKSHU RIVER   2332 60.11586 -137.0362
## 2 streamlocationids Klukshu River     NA 60.11586 -137.0362
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS NESKETAHIN LAKE   2339 60.17403 -137.0755
## 2 streamlocationids Nesketahin Lake     NA 60.17403 -137.0755
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS TUYA RIVER   2155 58.04071 -130.8514
## 2 streamlocationids Tuya River     NA 58.04072 -130.8514
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS CRAIG RIVER   2186 56.69595 -131.3067
## 2 streamlocationids Craig River     NA 56.69595 -131.3067
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS BRONSON CREEK   2192 56.68307 -131.0695
## 2 streamlocationids Bronson Creek     NA 56.68307 -131.0695
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS VERRETT RIVER   2193  56.6978 -130.9972
## 2 streamlocationids Verrett River     NA  56.6978 -130.9972
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS TAKU RIVER   2203 58.58142 -133.6556
## 2 streamlocationids Taku River     NA 58.58142 -133.6556
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS NAHLIN RIVER   2224 58.77672 -132.0934
## 2 streamlocationids Nahlin River     NA 58.77672 -132.0934
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS HACKETT RIVER   2233 58.26375 -131.8121
## 2 streamlocationids Hackett River     NA 58.26375 -131.8121
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS STIKINE RIVER   2118 56.65764 -131.8489
## 2 streamlocationids Stikine River     NA 56.65764 -131.8489
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS PORCUPINE RIVER   2138 57.06458 -131.7452
## 2 streamlocationids Porcupine River     NA 57.06458 -131.7452
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS SCUD RIVER   2148 57.28014 -131.8232
## 2 streamlocationids Scud River     NA 57.28014 -131.8232
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS CHRISTINA CREEK   2145 57.24131 -131.8531
## 2 streamlocationids Christina Creek     NA 57.24131 -131.8531
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS CHUTINE RIVER   2196   57.653 -131.6324
## 2 streamlocationids Chutine River     NA   57.653 -131.6324
## [1] ""
##             dataset          location GFE_ID latitude longitude
## 1            NuSEDS WEST KATETE RIVER   2571 56.63627 -131.8437
## 2 streamlocationids West Katete River     NA 56.63627 -131.8437
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS CRAIG RIVER   2186 56.69595 -131.3067
## 2 streamlocationids Craig River     NA 56.69595 -131.3067
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS BRONSON CREEK   2192 56.68307 -131.0695
## 2 streamlocationids Bronson Creek     NA 56.68307 -131.0695
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS VERRETT RIVER   2193  56.6978 -130.9972
## 2 streamlocationids Verrett River     NA  56.6978 -130.9972
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS KATETE RIVER   2119 56.66608 -131.8159
## 2 streamlocationids Katete River     NA 56.66608 -131.8159
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS PORCUPINE RIVER   2138 57.06458 -131.7452
## 2 streamlocationids Porcupine River     NA 57.06458 -131.7452
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS CHRISTINA CREEK   2145 57.24131 -131.8531
## 2 streamlocationids Christina Creek     NA 57.24131 -131.8531
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS SCUD RIVER   2148 57.28014 -131.8232
## 2 streamlocationids Scud River     NA 57.28014 -131.8232
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS BEATTY CREEK   2200 58.10229 -131.1908
## 2 streamlocationids Beatty Creek     NA 58.10229 -131.1908
## [1] ""
##             dataset             location GFE_ID latitude longitude
## 1            NuSEDS LITTLE TAHLTAN RIVER   2201 58.12105 -131.3203
## 2 streamlocationids Little Tahltan River     NA 58.12105 -131.3203
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS CHRISTINA CREEK   2145 57.24131 -131.8531
## 2 streamlocationids Christina Creek     NA 57.24131 -131.8531
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS ISKUT RIVER   2178 56.74863 -131.7832
## 2 streamlocationids Iskut River     NA 56.74863 -131.7832
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS KATETE RIVER   2119 56.66608 -131.8159
## 2 streamlocationids Katete River     NA 56.66608 -131.8159
## [1] ""
##             dataset         location GFE_ID latitude longitude
## 1            NuSEDS KING SALMON LAKE   2818 58.71622 -132.9435
## 2 streamlocationids King Salmon Lake     NA 58.71622 -132.9435
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS KUTHAI LAKE   2490 59.23089 -133.2336
## 2 streamlocationids Kuthai Lake     NA 59.23089 -133.2336
## [1] ""
##             dataset            location GFE_ID latitude longitude
## 1            NuSEDS LITTLE TRAPPER LAKE   2222  58.4961  -132.605
## 2 streamlocationids Little Trapper Lake     NA  58.4961  -132.605
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS NAHLIN RIVER   2224 58.77672 -132.0934
## 2 streamlocationids Nahlin River     NA 58.77672 -132.0934
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS DUDIDONTU RIVER   2225 58.78941 -131.9852
## 2 streamlocationids Dudidontu River     NA 58.78941 -131.9852
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS TSETA CREEK   2228 58.90606 -131.9437
## 2 streamlocationids Tseta Creek     NA 58.90606 -131.9437
## [1] ""
##             dataset            location GFE_ID latitude longitude
## 1            NuSEDS LITTLE TRAPPER LAKE   2222  58.4961  -132.605
## 2 streamlocationids Little Trapper Lake     NA  58.4961  -132.605
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS NAHLIN RIVER   2224 58.77672 -132.0934
## 2 streamlocationids Nahlin River     NA 58.77672 -132.0934
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS DUDIDONTU RIVER   2225 58.78941 -131.9852
## 2 streamlocationids Dudidontu River     NA 58.78941 -131.9852
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS HACKETT RIVER   2233 58.26375 -131.8121
## 2 streamlocationids Hackett River     NA 58.26375 -131.8121
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS HACKETT RIVER   2233 58.26375 -131.8121
## 2 streamlocationids Hackett River     NA 58.26375 -131.8121
## [1] ""
##             dataset         location GFE_ID latitude longitude
## 1            NuSEDS BIG SALMON RIVER   2516 61.88026 -134.9225
## 2 streamlocationids BIG SALMON RIVER     NA 61.88026 -134.9225
## [1] ""
##             dataset            location GFE_ID latitude longitude
## 1            NuSEDS LITTLE SALMON RIVER   2495 62.05418 -135.6667
## 2 streamlocationids LITTLE SALMON RIVER     NA 62.05418 -135.6667
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS TATCHUN RIVER   2493 62.28531  -136.326
## 2 streamlocationids TATCHUN RIVER     NA 62.28531  -136.326
## [1] ""
##             dataset           location GFE_ID latitude longitude
## 1            NuSEDS NORDENSKIOLD RIVER   2494 62.10211 -136.3017
## 2 streamlocationids NORDENSKIOLD RIVER     NA 62.10211 -136.3017
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS CHANDINDU RIVER   2492 64.25318 -139.7152
## 2 streamlocationids CHANDINDU RIVER     NA 64.25318 -139.7152
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS KLONDIKE RIVER   2548 64.05314 -139.4408
## 2 streamlocationids KLONDIKE RIVER     NA 64.05314 -139.4408
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS BLIND CREEK   2514 62.17795 -133.2105
## 2 streamlocationids BLIND CREEK     NA 62.17794 -133.2105
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS EARN RIVER   2544 62.73636 -134.6972
## 2 streamlocationids EARN RIVER     NA 62.73636 -134.6972
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS GLENLYON RIVER   2545  62.4833 -134.1626
## 2 streamlocationids GLENLYON RIVER     NA  62.4833 -134.1626
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS HOOLE RIVER   2546 61.74932 -131.7104
## 2 streamlocationids HOOLE RIVER     NA 61.74932 -131.7104
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS HUSKY DOG CREEK   2547 63.09676 -132.4632
## 2 streamlocationids HUSKY DOG CREEK     NA 63.09676 -132.4632
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS KALZAS RIVER   2543 62.89222 -135.4848
## 2 streamlocationids KALZAS RIVER     NA 62.89222 -135.4848
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS LEWIS LAKE   2551 62.61685 -131.0809
## 2 streamlocationids LEWIS LAKE     NA 62.61685 -131.0809
## [1] ""
##             dataset            location GFE_ID latitude longitude
## 1            NuSEDS LITTLE KALZAS RIVER   2552  62.8902 -135.4708
## 2 streamlocationids LITTLE KALZAS RIVER     NA  62.8902 -135.4708
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS MACMILLAN RIVER   2555 62.86881  -135.902
## 2 streamlocationids MACMILLAN RIVER     NA 62.86881  -135.902
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS MOOSE RIVER   2572 62.99193  -134.731
## 2 streamlocationids MOOSE RIVER     NA 62.99193  -134.731
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS PELLY RIVER   2510 62.78744 -137.3308
## 2 streamlocationids PELLY RIVER     NA 62.78744 -137.3308
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS PREVOST RIVER   2559 62.60372 -131.1714
## 2 streamlocationids PREVOST RIVER     NA 62.60372 -131.1714
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS RIDDELL RIVER   2561 62.84644 -132.4266
## 2 streamlocationids RIDDELL RIVER     NA 62.84644 -132.4266
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS ROSS RIVER   2515 61.98364 -132.4222
## 2 streamlocationids ROSS RIVER     NA 61.98364 -132.4222
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS RUSSELL CREEK   2562 63.03621 -133.3904
## 2 streamlocationids RUSSELL CREEK     NA 63.03621 -133.3904
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS SHELDON LAKE   2563 62.69167   -131.05
## 2 streamlocationids SHELDON LAKE     NA 62.69167   -131.05
## [1] ""
##             dataset  location GFE_ID latitude longitude
## 1            NuSEDS TAY RIVER   2565 62.56921 -134.3586
## 2 streamlocationids TAY RIVER     NA 62.56921 -134.3586
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS MINER RIVER   2556  66.5061 -138.4169
## 2 streamlocationids MINER RIVER     NA  66.5061 -138.4169
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS MAYO RIVER   2554 63.58861 -135.9146
## 2 streamlocationids MAYO RIVER     NA 63.58861 -135.9146
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS MCQUESTEN RIVER   2504 63.55015 -137.4432
## 2 streamlocationids MCQUESTEN RIVER     NA 63.55015 -137.4432
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS OLLIE LAKE   2557 63.05635 -130.9002
## 2 streamlocationids OLLIE LAKE     NA 63.05635 -130.9002
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS PLEASANT CREEK   2558 63.51947 -133.9113
## 2 streamlocationids PLEASANT CREEK     NA 63.51947 -133.9113
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS CROOKED CREEK   2503 63.38025 -136.6894
## 2 streamlocationids CROOKED CREEK     NA 63.38025 -136.6894
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS GLADYS LAKE   2500 59.88538 -132.9205
## 2 streamlocationids GLADYS LAKE     NA 59.88538 -132.9205
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS MORLEY RIVER   2520 60.09464 -132.4956
## 2 streamlocationids MORLEY RIVER     NA 60.09464 -132.4956
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS NISUTLIN RIVER   2517 60.22545 -132.5788
## 2 streamlocationids NISUTLIN RIVER     NA 60.22545 -132.5788
## [1] ""
##             dataset  location GFE_ID latitude longitude
## 1            NuSEDS RED RIVER   2560 60.73566 -132.1133
## 2 streamlocationids RED RIVER     NA 60.73566 -132.1133
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS SIDNEY CREEK   2519 60.75392 -132.9352
## 2 streamlocationids SIDNEY CREEK     NA 60.75392 -132.9352
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS SWIFT RIVER   2564  59.7372 -132.1856
## 2 streamlocationids SWIFT RIVER     NA  59.7372 -132.1856
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS WOLF RIVER   2518  60.2762 -132.5525
## 2 streamlocationids WOLF RIVER     NA  60.2762 -132.5525
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS LAKE LABERGE   2550  61.3508 -135.2613
## 2 streamlocationids LAKE LABERGE     NA  61.3508 -135.2613
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS MARSH LAKE   2553 60.46647 -134.3002
## 2 streamlocationids MARSH LAKE     NA 60.46647 -134.3002
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS MCINTYRE CREEK   2496 60.76852 -135.0884
## 2 streamlocationids MCINTYRE CREEK     NA 60.76852 -135.0884
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS MICHIE CREEK   2498 60.67352 -134.4723
## 2 streamlocationids MICHIE CREEK     NA 60.67352 -134.4723
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS TAKHINI RIVER   2521 60.84139 -135.1816
## 2 streamlocationids TAKHINI RIVER     NA 60.84139 -135.1816
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS TESLIN RIVER   2499 61.57244 -134.9003
## 2 streamlocationids TESLIN RIVER     NA 61.57244 -134.9003
## [1] ""
##             dataset   location GFE_ID latitude longitude
## 1            NuSEDS WOLF CREEK   2497 60.62497 -134.9132
## 2 streamlocationids WOLF CREEK     NA 60.62497 -134.9132
## [1] ""
##             dataset            location GFE_ID latitude longitude
## 1            NuSEDS YUKON RIVER - UPPER   2568 60.69361 -135.0395
## 2 streamlocationids YUKON RIVER - UPPER     NA 60.69361 -135.0395
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS NISLING RIVER   2506 62.46361 -139.4848
## 2 streamlocationids NISLING RIVER     NA 62.46361 -139.4848
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS TINCUP CREEK   2508 61.88759 -139.5463
## 2 streamlocationids TINCUP CREEK     NA 61.88759 -139.5463
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS KLUANE RIVER   2509 61.87738 -139.7212
## 2 streamlocationids KLUANE RIVER     NA 61.87738 -139.7212
## [1] ""
##             dataset      location GFE_ID latitude longitude
## 1            NuSEDS KOIDERN RIVER   2549 62.03296 -140.4413
## 2 streamlocationids KOIDERN RIVER     NA 62.03296 -140.4413
## [1] ""
##             dataset             location GFE_ID latitude longitude
## 1            NuSEDS YUKON RIVER - MIDDLE   2569 63.17821 -139.5738
## 2 streamlocationids YUKON RIVER - MIDDLE     NA 63.17821 -139.5738
## [1] ""
##             dataset        location GFE_ID latitude longitude
## 1            NuSEDS CHANDINDU RIVER   2492 64.25318 -139.7152
## 2 streamlocationids CHANDINDU RIVER     NA 64.25318 -139.7152
## [1] ""
##             dataset       location GFE_ID latitude longitude
## 1            NuSEDS KLONDIKE RIVER   2548 64.05314 -139.4408
## 2 streamlocationids KLONDIKE RIVER     NA 64.05314 -139.4408
## [1] ""
##             dataset             location GFE_ID latitude longitude
## 1            NuSEDS FISHING BRANCH RIVER   2522 66.45098 -138.5879
## 2 streamlocationids FISHING BRANCH RIVER     NA 66.45098 -138.5879
## [1] ""
##             dataset    location GFE_ID latitude longitude
## 1            NuSEDS MINER RIVER   2556  66.5061 -138.4169
## 2 streamlocationids MINER RIVER     NA  66.5061 -138.4169
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS TESLIN RIVER   2499 61.57244 -134.9003
## 2 streamlocationids TESLIN RIVER     NA 61.57244 -134.9003
## [1] ""
##             dataset     location GFE_ID latitude longitude
## 1            NuSEDS DONJEK RIVER   2505 62.60336 -139.9887
## 2 streamlocationids DONJEK RIVER     NA 62.60336 -139.9887
## [1] ""

There remains 289 unique stream (GFE_ID) and CU (cuid) combinations without an existing streamid (not accounting for the time series in nuseds without a cuid):

##                                 region  GFE_ID
## 1                        Central Coast    2252
## 2                        Central Coast    2685
## 3                        Central Coast    2684
## 4                        Central Coast    3554
## 5                        Central Coast     983
## 6                        Central Coast    1041
## 7                        Central Coast    2655
## 8                        Central Coast    2683
## 9                        Central Coast    2030
## 10                       Central Coast    1073
## 11                       Central Coast    2239
## 12                       Central Coast    2692
## 13                       Central Coast    2681
## 14                       Central Coast    2687
## 15                       Central Coast   11572
## 16                       Central Coast    2708
## 17                       Central Coast    2030
## 18                       Central Coast     990
## 19                       Central Coast    1073
## 20                       Central Coast    1075
## 21                       Central Coast    1076
## 22                       Central Coast    1096
## 23                       Central Coast    2685
## 24                       Central Coast    1073
## 25                       Central Coast    1076
## 26                       Central Coast    1096
## 27                       Central Coast    2252
## 28                       Central Coast    2685
## 29                       Central Coast    2688
## 30                       Central Coast    2684
## 31                       Central Coast    3554
## 32                       Central Coast    1807
## 33                       Central Coast    1903
## 34                       Central Coast    1904
## 35                       Central Coast    1908
## 36                       Central Coast    1909
## 37                       Central Coast    1046
## 38                       Central Coast    1076
## 39                       Central Coast    2792
## 40                       Central Coast    2687
## 41                       Central Coast   64745
## 42                            Columbia     442
## 43                            Columbia     442
## 44                              Fraser      11
## 45                              Fraser       4
## 46                              Fraser    2529
## 47                              Fraser     441
## 48                              Fraser    2716
## 49                              Fraser     182
## 50                              Fraser   52747
## 51                              Fraser   52748
## 52                              Fraser     189
## 53                              Fraser   52749
## 54                              Fraser    2441
## 55                              Fraser   55417
## 56                              Fraser    2454
## 57                              Fraser    2462
## 58                              Fraser    2466
## 59                              Fraser   64739
## 60                              Fraser      11
## 61                              Fraser      99
## 62                              Fraser    2636
## 63                              Fraser    2374
## 64                              Fraser    2381
## 65                              Fraser    2037
## 66                              Fraser     227
## 67                              Fraser   63379
## 68                              Fraser    2463
## 69                              Fraser     287
## 70                              Fraser     288
## 71                              Fraser     134
## 72                              Fraser    2716
## 73                              Fraser      95
## 74                              Fraser   23726
## 75                              Fraser    2422
## 76                              Fraser   11491
## 77                              Fraser   57040
## 78                              Fraser    2397
## 79                              Fraser    2574
## 80                              Fraser    3505
## 81                              Fraser    2753
## 82                              Fraser    2761
## 83                              Fraser     426
## 84                              Fraser    2826
## 85                              Fraser    1991
## 86                              Fraser    2434
## 87                              Fraser    2391
## 88                              Fraser    2396
## 89                              Fraser    2398
## 90                              Fraser    2405
## 91                              Fraser    2433
## 92                              Fraser     221
## 93                              Fraser     223
## 94                              Fraser     224
## 95                              Fraser     227
## 96                              Fraser   26771
## 97                              Fraser   26773
## 98                              Fraser    3510
## 99                              Fraser     185
## 100                             Fraser   58219
## 101                        Haida Gwaii    1497
## 102                        Haida Gwaii    1662
## 103                        Haida Gwaii    1574
## 104                        Haida Gwaii    1624
## 105                        Haida Gwaii    1671
## 106                        Haida Gwaii    1613
## 107                        Haida Gwaii    1642
## 108                               Nass    1766
## 109                               Nass    1776
## 110                               Nass    2312
## 111                               Nass     640
## 112                               Nass    2236
## 113                               Nass     652
## 114             Northern Transboundary    2203
## 115             Northern Transboundary    2118
## 116             Northern Transboundary    2199
## 117             Northern Transboundary    2212
## 118             Northern Transboundary    2216
## 119             Northern Transboundary    2221
## 120             Northern Transboundary    2203
## 121             Northern Transboundary    2208
## 122             Northern Transboundary    2211
## 123             Northern Transboundary    2212
## 124             Northern Transboundary    2222
## 125             Northern Transboundary    2233
## 126             Northern Transboundary    2216
## 127             Northern Transboundary    2216
## 128             Northern Transboundary    2324
## 129             Northern Transboundary    2570
## 130             Northern Transboundary    2338
## 131             Northern Transboundary    2119
## 132             Northern Transboundary    2199
## 133             Northern Transboundary    2211
## 134             Northern Transboundary    2212
## 135             Northern Transboundary    2216
## 136                             Skeena     499
## 137                             Skeena    2656
## 138                             Skeena     481
## 139                             Skeena     602
## 140                             Skeena    2236
## 141                             Skeena    2107
## 142                             Skeena    2601
## 143                             Skeena    2737
## 144                             Skeena    2601
## 145                             Skeena    2601
## 146 Vancouver Island & Mainland Inlets    2487
## 147 Vancouver Island & Mainland Inlets    1349
## 148 Vancouver Island & Mainland Inlets    1362
## 149 Vancouver Island & Mainland Inlets    2473
## 150 Vancouver Island & Mainland Inlets    2486
## 151 Vancouver Island & Mainland Inlets    2024
## 152 Vancouver Island & Mainland Inlets    2076
## 153 Vancouver Island & Mainland Inlets    2488
## 154 Vancouver Island & Mainland Inlets     752
## 155 Vancouver Island & Mainland Inlets     865
## 156 Vancouver Island & Mainland Inlets     879
## 157 Vancouver Island & Mainland Inlets    1303
## 158 Vancouver Island & Mainland Inlets 7990617
## 159 Vancouver Island & Mainland Inlets    1312
## 160 Vancouver Island & Mainland Inlets    1314
## 161 Vancouver Island & Mainland Inlets    2837
## 162 Vancouver Island & Mainland Inlets   55413
## 163 Vancouver Island & Mainland Inlets   55420
## 164 Vancouver Island & Mainland Inlets   57042
## 165 Vancouver Island & Mainland Inlets    2487
## 166 Vancouver Island & Mainland Inlets    1194
## 167 Vancouver Island & Mainland Inlets    1333
## 168 Vancouver Island & Mainland Inlets     802
## 169 Vancouver Island & Mainland Inlets     723
## 170 Vancouver Island & Mainland Inlets     826
## 171 Vancouver Island & Mainland Inlets     832
## 172 Vancouver Island & Mainland Inlets    1191
## 173 Vancouver Island & Mainland Inlets    2487
## 174 Vancouver Island & Mainland Inlets    2637
## 175 Vancouver Island & Mainland Inlets   11486
## 176 Vancouver Island & Mainland Inlets     403
## 177 Vancouver Island & Mainland Inlets    1303
## 178 Vancouver Island & Mainland Inlets    1320
## 179 Vancouver Island & Mainland Inlets    1322
## 180 Vancouver Island & Mainland Inlets    1323
## 181 Vancouver Island & Mainland Inlets   32077
## 182 Vancouver Island & Mainland Inlets   55413
## 183 Vancouver Island & Mainland Inlets   55420
## 184 Vancouver Island & Mainland Inlets     208
## 185 Vancouver Island & Mainland Inlets   11486
## 186 Vancouver Island & Mainland Inlets    1490
## 187 Vancouver Island & Mainland Inlets     757
## 188 Vancouver Island & Mainland Inlets     759
## 189 Vancouver Island & Mainland Inlets     724
## 190 Vancouver Island & Mainland Inlets     869
## 191 Vancouver Island & Mainland Inlets    1125
## 192 Vancouver Island & Mainland Inlets    2616
## 193 Vancouver Island & Mainland Inlets    1211
## 194 Vancouver Island & Mainland Inlets     801
## 195 Vancouver Island & Mainland Inlets     723
## 196 Vancouver Island & Mainland Inlets     724
## 197 Vancouver Island & Mainland Inlets     744
## 198 Vancouver Island & Mainland Inlets    1125
## 199 Vancouver Island & Mainland Inlets    1433
## 200 Vancouver Island & Mainland Inlets    1208
## 201 Vancouver Island & Mainland Inlets     723
## 202 Vancouver Island & Mainland Inlets     724
## 203 Vancouver Island & Mainland Inlets     863
## 204 Vancouver Island & Mainland Inlets     869
## 205 Vancouver Island & Mainland Inlets     878
## 206 Vancouver Island & Mainland Inlets     879
## 207 Vancouver Island & Mainland Inlets    1303
## 208 Vancouver Island & Mainland Inlets    1307
## 209 Vancouver Island & Mainland Inlets    1125
## 210 Vancouver Island & Mainland Inlets    1139
## 211 Vancouver Island & Mainland Inlets    1146
## 212 Vancouver Island & Mainland Inlets    3446
## 213                              Yukon    2491
## 214                              Yukon    2567
## 215                              Yukon    2491
## 216                              Yukon    2499
## 217                              Yukon    2501
## 218                              Yukon    2516
## 219                              Yukon    2567
##                                sys_nm cuid
## 1                     NOOSGULCH RIVER  504
## 2               FANCY COVE HEAD CREEK  503
## 3         FANCY COVE RIGHT HAND CREEK  503
## 4                          FELL CREEK  503
## 5                       CASCADE RIVER  515
## 6                          HUGH CREEK  515
## 7                      WATHLSTO CREEK  522
## 8         COOPER INLET-ADA COVE CREEK  520
## 9                        KLEMTU CREEK  520
## 10                        MCKAY CREEK  522
## 11                CLAYTON FALLS CREEK  518
## 12               JENNY BAY WEST CREEK  523
## 13                     MCLELLAN CREEK  518
## 14  COOPER INLET-FANNIE COVE LH CREEK  520
## 15                   GOBEIL BAY CREEK  609
## 16  COOPER INLET-FANNIE COVE RH CREEK  608
## 17                       KLEMTU CREEK  608
## 18                      RAINBOW CREEK  609
## 19                        MCKAY CREEK  609
## 20                      TETLOCK CREEK  609
## 21                       HUNTER CREEK  609
## 22                        ALVIN CREEK  608
## 23              FANCY COVE HEAD CREEK  608
## 24                        MCKAY CREEK  612
## 25                       HUNTER CREEK  612
## 26                        ALVIN CREEK  611
## 27                    NOOSGULCH RIVER  610
## 28              FANCY COVE HEAD CREEK  611
## 29         BULLOCK CHANNEL EAST CREEK  611
## 30        FANCY COVE RIGHT HAND CREEK  611
## 31                         FELL CREEK  611
## 32                 WEBSTER LAKE CREEK  615
## 33                       TURTLE CREEK  614
## 34              GRIBBELL ISLAND CREEK  614
## 35                 FISHTRAP BAY CREEK  614
## 36              LITTLE TILLHORN CREEK  614
## 37                        WATHL CREEK  614
## 38                       HUNTER CREEK  614
## 39                         MOORE LAKE  599
## 40  COOPER INLET-FANNIE COVE LH CREEK  615
## 41                      ATNARKO LAKES  528
## 42                     OKANAGAN RIVER  301
## 43                     OKANAGAN RIVER 1300
## 44                        MAPLE CREEK  701
## 45                       STONEY CREEK  701
## 46             ANDERSON CREEK CHANNEL  701
## 47                        EAGLE CREEK  701
## 48                        BYRNE CREEK  701
## 49                         COHO CREEK  701
## 50                        EAGLE CREEK  701
## 51                    HOLACHTEN CREEK  701
## 52                      MYSTERY CREEK  701
## 53                    SILVERMERE LAKE  701
## 54                        CULTUS LAKE  701
## 55                      CAMILOS CREEK  701
## 56                PUNKUTLAENKUT CREEK  310
## 57            CHILCOTIN RIVER - UPPER  310
## 58              CARIBOO RIVER - UPPER  311
## 59                     CAMPBELL RIVER  302
## 60                        MAPLE CREEK  750
## 61                        NEVIN CREEK  750
## 62                       TASEKO RIVER  749
## 63                       PALMER CREEK  708
## 64                       MINTON CREEK  749
## 65                WILLIAMS LAKE RIVER  749
## 66                         ROSS CREEK  708
## 67                 ENGINEERED CHANNEL  709
## 68            CHILCOTIN RIVER - LOWER  749
## 69                        TASEKO LAKE  749
## 70                        ELKIN CREEK  749
## 71                      YALAKOM RIVER  749
## 72                        BYRNE CREEK  750
## 73                   SEMMIHAULT CREEK  750
## 74                         TETO CREEK  708
## 75                    BLUE LEAD CREEK  749
## 76                        WASKO CREEK  749
## 77                    QUILCHENA CREEK  707
## 78                    HAZELTINE CREEK  749
## 79                      GASPARD CREEK  710
## 80                        OLSEN CREEK  715
## 81                  BUTTERFIELD CREEK  732
## 82                    TARNEZELL CREEK  732
## 83                       NANCUT CREEK  731
## 84                      POMEROY CREEK  735
## 85                          SUS CREEK  735
## 86                       LOFTUS CREEK  739
## 87                       BURTON CREEK  760
## 88                         RAFT CREEK  728
## 89                      WINKLEY CREEK  728
## 90                         AMOS CREEK  728
## 91               MOMICH RIVER - UPPER  761
## 92                ADAMS RIVER - UPPER  760
## 93                       MOMICH RIVER  761
## 94                      CAYENNE CREEK  761
## 95                         ROSS CREEK  738
## 96                    FOUR MILE CREEK  739
## 97                        HLINA CREEK  739
## 98                         BLUE CREEK  715
## 99                        SAKWI CREEK  714
## 100                      JOFFRE CREEK  716
## 101                       TLELL RIVER  801
## 102          DOUGLAS INLET CREEK-HEAD  808
## 103                      KUMDIS CREEK  814
## 104                 BAG HARBOUR CREEK  813
## 105          SECURITY INLET CREEK-L/H  818
## 106                MATHESON CREEK-R/H  816
## 107             LOUSCOONE INLET CREEK  818
## 108                     CASCADE CREEK  406
## 109                     DONAHUE CREEK  410
## 110                        CRAG CREEK  410
## 111                      ANUDOL CREEK  408
## 112                         DAK RIVER  414
## 113                     Ksi Sii Aks 2  426
## 114                        TAKU RIVER 1008
## 115                     STIKINE RIVER 1011
## 116                     TAHLTAN RIVER 1010
## 117                    TATSATUA CREEK 1008
## 118                      NAKINA RIVER 1007
## 119                     KOWATUA CREEK 1008
## 120                        TAKU RIVER 1034
## 121                   FLANAGAN SLOUGH 1034
## 122                   TATSAMENIE LAKE 1034
## 123                    TATSATUA CREEK 1034
## 124               LITTLE TRAPPER LAKE 1034
## 125                     HACKETT RIVER 1034
## 126                      NAKINA RIVER 1019
## 127                      NAKINA RIVER 1020
## 128                       ALSEK RIVER 1021
## 129                   VERRETT SLOUGHS 1023
## 130                     VILLAGE CREEK 1021
## 131                      KATETE RIVER 1023
## 132                     TAHLTAN RIVER 1026
## 133                   TATSAMENIE LAKE 1029
## 134                    TATSATUA CREEK 1023
## 135                      NAKINA RIVER 1023
## 136                 DAMSHILGWIT CREEK  242
## 137                        DEEP CREEK  215
## 138                     SHANNON CREEK  202
## 139               TAHLO CREEK - LOWER  215
## 140                         DAK RIVER  219
## 141                       BABINE LAKE  218
## 142                      DASQUE CREEK  219
## 143                 WHITEBOTTOM CREEK  209
## 144                      DASQUE CREEK  209
## 145                      DASQUE CREEK  226
## 146                   CLAYOQUOT RIVER  978
## 147                     SATCHIE CREEK  978
## 148                    OKTWANCH RIVER  978
## 149              HESQUIAT POINT CREEK  978
## 150                   MURIEL S1 CREEK  978
## 151                        DRAW CREEK  978
## 152             CARRINGTON COVE CREEK  904
## 153                 MURIEL LAKE CREEK  978
## 154                    WEST BAY CREEK  905
## 155               HEALTH LAGOON CREEK  900
## 156                    CARRIDEN CREEK  900
## 157              KENNEDY LAKE BEACHES  978
## 158       KENNEDY LAKE FEEDER STREAMS  978
## 159                        COLD CREEK  978
## 160                      ANGORA CREEK  978
## 161                      IRGENS CREEK  904
## 162                        COHO CREEK  978
## 163                ENGLISH COVE CREEK  978
## 164                      HANSEN CREEK  977
## 165                   CLAYOQUOT RIVER  328
## 166                     NANAIMO RIVER  323
## 167              WHITEPINE COVE CREEK  328
## 168                    HANSON'S CREEK  320
## 169   PARADISE SPAWNING CHANNEL-UPPER  320
## 170                      GRASSY CREEK  326
## 171                     WORTLEY CREEK  326
## 172                   MILLSTONE RIVER  324
## 173                   CLAYOQUOT RIVER  915
## 174                     PACILTH CREEK  914
## 175       WATERSHED ABOVE STAMP FALLS  914
## 176                   WHALETOWN CREEK  908
## 177              KENNEDY LAKE BEACHES  915
## 178                      MEARES CREEK  915
## 179                       SHARP CREEK  915
## 180                       CONE CREEKS  915
## 181                        BEAR CREEK  910
## 182                        COHO CREEK  915
## 183                ENGLISH COVE CREEK  915
## 184                  COTTONWOOD CREEK  907
## 185       WATERSHED ABOVE STAMP FALLS  918
## 186                     RUSSELL CREEK  919
## 187                     ROBERTS CREEK  917
## 188                      WILSON CREEK  917
## 189                  TENDERFOOT CREEK  917
## 190                 WAHKANA BAY CREEK  920
## 191                    OWEN BAY CREEK  920
## 192                       MYERS CREEK  922
## 193                  GOLDSTREAM RIVER  922
## 194                       STORE CREEK  922
## 195   PARADISE SPAWNING CHANNEL-UPPER  921
## 196                  TENDERFOOT CREEK  921
## 197                      MCNAIR CREEK  922
## 198                    OWEN BAY CREEK  926
## 199                        EAST CREEK  974
## 200                    COWICHAN RIVER  973
## 201   PARADISE SPAWNING CHANNEL-UPPER  973
## 202                  TENDERFOOT CREEK  973
## 203                     GILFORD CREEK  971
## 204                 WAHKANA BAY CREEK  971
## 205                      EMBLEY CREEK  971
## 206                    CARRIDEN CREEK  971
## 207              KENNEDY LAKE BEACHES  958
## 208             CLAYOQUOT ARM BEACHES  972
## 209                    OWEN BAY CREEK  971
## 210                     MENZIES CREEK  973
## 211                      WILLOW CREEK  973
## 212                     CYPRESS CREEK  973
## 213                       YUKON RIVER 1214
## 214                 LOWER YUKON RIVER 1214
## 215                       YUKON RIVER 1207
## 216                      TESLIN RIVER 1211
## 217                    JENNINGS RIVER 1212
## 218                  BIG SALMON RIVER 1204
## 219                 LOWER YUKON RIVER 1207
##                                                 cu_name_pse streamid
## 1                                   Bella Coola-Dean Rivers       NA
## 2                                   Spiller-Fitz-Hugh-Burke       NA
## 3                                   Spiller-Fitz-Hugh-Burke       NA
## 4                                   Spiller-Fitz-Hugh-Burke       NA
## 5                               North & Central Coast-Early       NA
## 6                               North & Central Coast-Early       NA
## 7                               Douglas Channel-Kitimat Arm       NA
## 8                                    Hecate Strait Mainland       NA
## 9                                    Hecate Strait Mainland       NA
## 10                              Douglas Channel-Kitimat Arm       NA
## 11                                  Bella Coola-Dean Rivers       NA
## 12                                 Northern Coastal Streams       NA
## 13                                  Bella Coola-Dean Rivers       NA
## 14                                   Hecate Strait Mainland       NA
## 15                              Hecate Strait-Fjords (even)       NA
## 16                                   Hecate Lowlands (even)       NA
## 17                                   Hecate Lowlands (even)       NA
## 18                              Hecate Strait-Fjords (even)       NA
## 19                              Hecate Strait-Fjords (even)       NA
## 20                              Hecate Strait-Fjords (even)       NA
## 21                              Hecate Strait-Fjords (even)       NA
## 22                                   Hecate Lowlands (even)       NA
## 23                                   Hecate Lowlands (even)       NA
## 24                               Hecate Strait-Fjords (odd)       NA
## 25                               Hecate Strait-Fjords (odd)       NA
## 26                             Hecate Strait-Lowlands (odd)       NA
## 27  Homathko-Klinaklini-Smith-Rivers-Bella Coola-Dean (odd)       NA
## 28                             Hecate Strait-Lowlands (odd)       NA
## 29                             Hecate Strait-Lowlands (odd)       NA
## 30                             Hecate Strait-Lowlands (odd)       NA
## 31                             Hecate Strait-Lowlands (odd)       NA
## 32                    Northern Coastal Streams (river-type)       NA
## 33                     Northern Coastal Fjords (river-type)       NA
## 34                     Northern Coastal Fjords (river-type)       NA
## 35                     Northern Coastal Fjords (river-type)       NA
## 36                     Northern Coastal Fjords (river-type)       NA
## 37                     Northern Coastal Fjords (river-type)       NA
## 38                     Northern Coastal Fjords (river-type)       NA
## 39                                     Tsimtack/Moore/Roger       NA
## 40                    Northern Coastal Streams (river-type)       NA
## 41                                      South Atnarko Lakes       NA
## 42                                                 Okanagan       NA
## 43                                                  Osoyoos       NA
## 44                                             Lower Fraser       NA
## 45                                             Lower Fraser       NA
## 46                                             Lower Fraser       NA
## 47                                             Lower Fraser       NA
## 48                                             Lower Fraser       NA
## 49                                             Lower Fraser       NA
## 50                                             Lower Fraser       NA
## 51                                             Lower Fraser       NA
## 52                                             Lower Fraser       NA
## 53                                             Lower Fraser       NA
## 54                                             Lower Fraser       NA
## 55                                             Lower Fraser       NA
## 56                         Middle Fraser River (Spring 5-2)       NA
## 57                         Middle Fraser River (Spring 5-2)       NA
## 58                         Middle Fraser River (Summer 5-2)       NA
## 59                                  Boundary Bay (Fall 4-1)       NA
## 60                                             Lower Fraser       NA
## 61                                             Lower Fraser       NA
## 62                                          Interior Fraser       NA
## 63                                           South Thompson       NA
## 64                                          Interior Fraser       NA
## 65                                          Interior Fraser       NA
## 66                                           South Thompson       NA
## 67                                           North Thompson       NA
## 68                                          Interior Fraser       NA
## 69                                          Interior Fraser       NA
## 70                                          Interior Fraser       NA
## 71                                          Interior Fraser       NA
## 72                                             Lower Fraser       NA
## 73                                             Lower Fraser       NA
## 74                                           South Thompson       NA
## 75                                          Interior Fraser       NA
## 76                                          Interior Fraser       NA
## 77                                           Lower Thompson       NA
## 78                                          Interior Fraser       NA
## 79                                       Fraser River (odd)       NA
## 80                                        Pitt-Early Summer       NA
## 81                    Takla-Trembleur-Early Stuart (cyclic)       NA
## 82                    Takla-Trembleur-Early Stuart (cyclic)       NA
## 83                   Takla-Trembleur-Stuart-Summer (cyclic)       NA
## 84                                      Bowron-Early Summer       NA
## 85                                      Bowron-Early Summer       NA
## 86                                    Shuswap-Late (cyclic)       NA
## 87                                       Adams-Early Summer       NA
## 88                                  Quesnel-Summer (cyclic)       NA
## 89                                  Quesnel-Summer (cyclic)       NA
## 90                                  Quesnel-Summer (cyclic)       NA
## 91                                      Momich-Early Summer       NA
## 92                                       Adams-Early Summer       NA
## 93                                      Momich-Early Summer       NA
## 94                                      Momich-Early Summer       NA
## 95                            Shuswap-Early Summer (cyclic)       NA
## 96                                    Shuswap-Late (cyclic)       NA
## 97                                    Shuswap-Late (cyclic)       NA
## 98                                        Pitt-Early Summer       NA
## 99                         Harrison-Upstream Migrating-Late       NA
## 100                                  Lillooet-Harrison-Late       NA
## 101                                        East Haida Gwaii       NA
## 102                                        West Haida Gwaii       NA
## 103                                 North Haida Gwaii (odd)       NA
## 104                                  East Haida Gwaii (odd)       NA
## 105                           West Haida Gwaii (river-type)       NA
## 106                           East Haida Gwaii (river-type)       NA
## 107                           West Haida Gwaii (river-type)       NA
## 108                              Portland Canal-Observatory       NA
## 109         Portland Sound-Observatory Inlet-Portland Canal       NA
## 110         Portland Sound-Observatory Inlet-Portland Canal       NA
## 111                                              Lower Nass       NA
## 112                         Nass-Portland-Observatory (odd)       NA
## 113                        Lower Nass-Portland (river-type)       NA
## 114                                        Taku-Late Timing       NA
## 115                                     Stikine-Late Timing       NA
## 116                                    Stikine-Early Timing       NA
## 117                                        Taku-Late Timing       NA
## 118                                         Taku-Mid Timing       NA
## 119                                        Taku-Late Timing       NA
## 120                                       Taku-Early Timing       NA
## 121                                       Taku-Early Timing       NA
## 122                                       Taku-Early Timing       NA
## 123                                       Taku-Early Timing       NA
## 124                                       Taku-Early Timing       NA
## 125                                       Taku-Early Timing       NA
## 126                             Transboundary Fjords (even)       NA
## 127                              Transboundary Fjords (odd)       NA
## 128                                      Alsek (river-type)       NA
## 129              Northern Transboundary Fjords (river-type)       NA
## 130                                      Alsek (river-type)       NA
## 131              Northern Transboundary Fjords (river-type)       NA
## 132                                                 Tahltan       NA
## 133                                              Tatsamenie       NA
## 134              Northern Transboundary Fjords (river-type)       NA
## 135              Northern Transboundary Fjords (river-type)       NA
## 136                                            Upper Skeena       NA
## 137                                           Middle Skeena       NA
## 138                                            Lower Skeena       NA
## 139                                           Middle Skeena       NA
## 140                              Nass-Skeena Estuary (even)       NA
## 141                              Middle-Upper Skeena (even)       NA
## 142                              Nass-Skeena Estuary (even)       NA
## 143                                Lower Skeena River (odd)       NA
## 144                                Lower Skeena River (odd)       NA
## 145                               Skeena River (river-type)       NA
## 146                       Southwest & West Vancouver Island       NA
## 147                       Southwest & West Vancouver Island       NA
## 148                       Southwest & West Vancouver Island       NA
## 149                       Southwest & West Vancouver Island       NA
## 150                       Southwest & West Vancouver Island       NA
## 151                       Southwest & West Vancouver Island       NA
## 152                                          Georgia Strait       NA
## 153                       Southwest & West Vancouver Island       NA
## 154                                Howe Sound-Burrard Inlet       NA
## 155                                Southern Coastal Streams       NA
## 156                                Southern Coastal Streams       NA
## 157                       Southwest & West Vancouver Island       NA
## 158                       Southwest & West Vancouver Island       NA
## 159                       Southwest & West Vancouver Island       NA
## 160                       Southwest & West Vancouver Island       NA
## 161                                          Georgia Strait       NA
## 162                       Southwest & West Vancouver Island       NA
## 163                       Southwest & West Vancouver Island       NA
## 164                              Northwest Vancouver Island       NA
## 165                  West Vancouver Island-South (Fall x-1)       NA
## 166              East Vancouver Island-Nanaimo (Spring x-2)       NA
## 167                  West Vancouver Island-South (Fall x-1)       NA
## 168             Southern Mainland-Georgia Strait (Fall x-1)       NA
## 169             Southern Mainland-Georgia Strait (Fall x-1)       NA
## 170            Southern Mainland-Southern Fjords (Fall x-1)       NA
## 171            Southern Mainland-Southern Fjords (Fall x-1)       NA
## 172  East Vancouver Island-Nanaimo and Chemainus (Fall x-1)       NA
## 173                                               Clayoquot       NA
## 174                                   West Vancouver Island       NA
## 175                                   West Vancouver Island       NA
## 176                                 Georgia Strait Mainland       NA
## 177                                               Clayoquot       NA
## 178                                               Clayoquot       NA
## 179                                               Clayoquot       NA
## 180                                               Clayoquot       NA
## 181                    East Vancouver Island-Georgia Strait       NA
## 182                                               Clayoquot       NA
## 183                                               Clayoquot       NA
## 184                                Howe Sound-Burrard Inlet       NA
## 185                            West Vancouver Island (even)       NA
## 186                       Northwest Vancouver Island (even)       NA
## 187                                   Georgia Strait (even)       NA
## 188                                   Georgia Strait (even)       NA
## 189                                   Georgia Strait (even)       NA
## 190                                  Southern Fjords (even)       NA
## 191                                  Southern Fjords (even)       NA
## 192                                    Georgia Strait (odd)       NA
## 193                                    Georgia Strait (odd)       NA
## 194                                    Georgia Strait (odd)       NA
## 195                     East Howe Sound-Burrard Inlet (odd)       NA
## 196                     East Howe Sound-Burrard Inlet (odd)       NA
## 197                                    Georgia Strait (odd)       NA
## 198                                   Southern Fjords (odd)       NA
## 199                        NW Vancouver Island (river-type)       NA
## 200     East Vancouver Island & Georgia Strait (river-type)       NA
## 201     East Vancouver Island & Georgia Strait (river-type)       NA
## 202     East Vancouver Island & Georgia Strait (river-type)       NA
## 203                            Southern Fjords (river-type)       NA
## 204                            Southern Fjords (river-type)       NA
## 205                            Southern Fjords (river-type)       NA
## 206                            Southern Fjords (river-type)       NA
## 207                                                 Kennedy       NA
## 208                      West Vancouver Island (river-type)       NA
## 209                            Southern Fjords (river-type)       NA
## 210     East Vancouver Island & Georgia Strait (river-type)       NA
## 211     East Vancouver Island & Georgia Strait (river-type)       NA
## 212     East Vancouver Island & Georgia Strait (river-type)       NA
## 213                                             North Yukon       NA
## 214                                             North Yukon       NA
## 215                                          Northern Yukon       NA
## 216                                             Upper Yukon       NA
## 217                                                  Teslin       NA
## 218                                            Middle Yukon       NA
## 219                                          Northern Yukon       NA

We give them a new streamid value by simply incrementing from the maximum current streamid value.

5 Export datasets

The following files are exported:

  • *2_nuseds_cuid_streamid__DATE.csv*: the cleaned NuSEDS dataset with the PSE’s field: cuid, streamid, cu_name_pse, etc.

  • log_file.csv: the log file reporting the name of the main file exported, the date of the export, the name of the present script, the name of the original NUSEDS or CUSS files and the choices related to removing zeros or not.

6 Check: compared with previous version

Import the previous clean NuSEDS dataset, exported in 2024-04-19.

## [1] "There are 183 more time series in the updated cleaned NuSEDS dataset"

Check the locations:

## [1] "There are 61 new locations in the updated NuSEDS:"
##                                region                      sys_nm GFE_ID
## 12                      Central Coast             NOOSGULCH RIVER   2252
## 14                      Central Coast       FANCY COVE HEAD CREEK   2685
## 15                      Central Coast FANCY COVE RIGHT HAND CREEK   2684
## 16                      Central Coast                  FELL CREEK   3554
## 32                      Central Coast              MCLELLAN CREEK   2681
## 48                      Central Coast                  MOORE LAKE   2792
## 49                      Central Coast               ATNARKO LAKES  64745
## 1                              Fraser                 MAPLE CREEK     11
## 2                              Fraser                 EAGLE CREEK    441
## 4                              Fraser                 BYRNE CREEK   2716
## 6                              Fraser                 EAGLE CREEK  52747
## 7                              Fraser             HOLACHTEN CREEK  52748
## 8                              Fraser             SILVERMERE LAKE  52749
## 10                             Fraser               CAMILOS CREEK  55417
## 17                             Fraser         PUNKUTLAENKUT CREEK   2454
## 18                             Fraser     CHILCOTIN RIVER - UPPER   2462
## 19                             Fraser       CARIBOO RIVER - UPPER   2466
## 20                             Fraser              CAMPBELL RIVER  64739
## 21                             Fraser                 NEVIN CREEK     99
## 24                             Fraser                PALMER CREEK   2374
## 25                             Fraser                MINTON CREEK   2381
## 26                             Fraser          ENGINEERED CHANNEL  63379
## 27                             Fraser            SEMMIHAULT CREEK     95
## 28                             Fraser                  TETO CREEK  23726
## 30                             Fraser                 WASKO CREEK  11491
## 31                             Fraser             QUILCHENA CREEK  57040
## 35                             Fraser               GASPARD CREEK   2574
## 36                             Fraser                 OLSEN CREEK   3505
## 37                             Fraser           BUTTERFIELD CREEK   2753
## 38                             Fraser             TARNEZELL CREEK   2761
## 39                             Fraser                NANCUT CREEK    426
## 40                             Fraser               POMEROY CREEK   2826
## 41                             Fraser                  RAFT CREEK   2396
## 42                             Fraser               WINKLEY CREEK   2398
## 43                             Fraser                  AMOS CREEK   2405
## 45                             Fraser                 HLINA CREEK  26773
## 46                             Fraser                  BLUE CREEK   3510
## 50                             Fraser                JOFFRE CREEK  58219
## 23                             Skeena                  DEEP CREEK   2656
## 34                             Skeena           WHITEBOTTOM CREEK   2737
## 3  Vancouver Island & Mainland Inlets        KENNEDY LAKE BEACHES   1303
## 5  Vancouver Island & Mainland Inlets                IRGENS CREEK   2837
## 9  Vancouver Island & Mainland Inlets                  COHO CREEK  55413
## 11 Vancouver Island & Mainland Inlets          ENGLISH COVE CREEK  55420
## 13 Vancouver Island & Mainland Inlets                HANSEN CREEK  57042
## 22 Vancouver Island & Mainland Inlets               PACILTH CREEK   2637
## 29 Vancouver Island & Mainland Inlets                  BEAR CREEK  32077
## 33 Vancouver Island & Mainland Inlets            COTTONWOOD CREEK    208
## 44 Vancouver Island & Mainland Inlets       CLAYOQUOT ARM BEACHES   1307
## 47 Vancouver Island & Mainland Inlets               CYPRESS CREEK   3446
##       Y_LAT   X_LONGT
## 12 52.43367 -126.3915
## 14 52.05897 -128.0088
## 15 52.05959 -128.0162
## 16 52.43358 -128.0791
## 32 52.38783 -126.6197
## 48 53.40953 -129.5011
## 49 52.16383 -125.7139
## 1  49.26403 -122.7845
## 2  49.24336 -122.9351
## 4  49.19248 -122.9999
## 6  49.50492 -122.0143
## 7  49.22489 -122.0086
## 8  49.17497 -122.4088
## 10 49.38667 -121.3931
## 17 52.50968 -124.3801
## 18 52.33929 -124.0284
## 19 52.82510 -121.2772
## 20 49.01309 -122.7784
## 21 49.17598 -121.8066
## 24 50.69082 -119.3314
## 25 51.94267 -123.1501
## 26 51.58644 -119.8602
## 27 49.15306 -121.9561
## 28 50.99018 -118.6458
## 30 52.56677 -121.0077
## 31 50.16073 -120.5209
## 35 51.11516 -122.0359
## 36 49.59717 -122.6315
## 37 54.75034 -125.3968
## 38 54.83055 -125.0632
## 39 54.59869 -125.0755
## 40 53.18780 -121.2597
## 41 52.50693 -121.5109
## 42 52.49960 -121.3996
## 43 52.63524 -121.0026
## 45 50.94218 -119.3537
## 46 49.71314 -122.7177
## 50 50.30000 -122.5833
## 23 54.58592 -126.8526
## 34 54.40481 -128.8642
## 3  49.04913 -125.5804
## 5  49.49690 -123.7463
## 9  49.10727 -125.7845
## 11 49.09423 -125.8433
## 13 50.77889 -128.3464
## 22 49.45101 -126.4613
## 29 49.86550 -125.1504
## 33 49.76252 -123.1456
## 44 49.09903 -125.5919
## 47 49.33914 -123.2414
## [1] "There is no location in the previous cleaned NuSEDS that is not in the updated one"

Check the populations:

## [1] "There are 176 new IndexId (POP_ID) in the updated NuSEDS:"
##                                 region      IndexId
## 31                       Central Coast      CM_7775
## 33                       Central Coast      CM_7796
## 34                       Central Coast      CM_7812
## 35                       Central Coast      CM_7816
## 36                       Central Coast      CN_3103
## 43                       Central Coast     CN_50319
## 51                       Central Coast      CO_3027
## 52                       Central Coast      CO_3169
## 62                       Central Coast     CO_45303
## 76                       Central Coast     CO_52376
## 80                       Central Coast      CO_7729
## 86                       Central Coast      CO_7776
## 89                       Central Coast      CO_7793
## 90                       Central Coast      CO_7814
## 93                       Central Coast     PKE_3432
## 94                       Central Coast     PKE_3447
## 96                       Central Coast    PKE_45304
## 102                      Central Coast    PKE_51882
## 103                      Central Coast    PKE_52377
## 104                      Central Coast    PKE_52387
## 105                      Central Coast    PKE_52392
## 106                      Central Coast    PKE_52492
## 108                      Central Coast     PKE_7797
## 121                      Central Coast    PKO_52377
## 122                      Central Coast    PKO_52392
## 123                      Central Coast    PKO_52492
## 125                      Central Coast     PKO_7792
## 126                      Central Coast     PKO_7797
## 127                      Central Coast     PKO_7811
## 128                      Central Coast     PKO_7813
## 129                      Central Coast     PKO_7817
## 143                      Central Coast     SX_43770
## 144                      Central Coast     SX_44135
## 145                      Central Coast     SX_44140
## 146                      Central Coast     SX_44160
## 147                      Central Coast     SX_44165
## 155                      Central Coast     SX_50340
## 162                      Central Coast     SX_52390
## 170                      Central Coast      SX_7805
## 172                      Central Coast      SX_7815
## 173                      Central Coast      SX_7818
## 1                               Fraser      CM_1622
## 2                               Fraser      CM_2434
## 20                              Fraser       CM_562
## 22                              Fraser      CM_7734
## 23                              Fraser      CM_7735
## 24                              Fraser      CM_7736
## 25                              Fraser      CM_7737
## 26                              Fraser      CM_7739
## 28                              Fraser      CM_7768
## 29                              Fraser      CM_7769
## 40                              Fraser     CN_46841
## 47                              Fraser      CN_7808
## 48                              Fraser      CO_1624
## 49                              Fraser      CO_1826
## 50                              Fraser      CO_2511
## 60                              Fraser     CO_44988
## 61                              Fraser     CO_44998
## 63                              Fraser     CO_45309
## 65                              Fraser     CO_46310
## 66                              Fraser     CO_46855
## 67                              Fraser     CO_46865
## 68                              Fraser     CO_47232
## 77                              Fraser       CO_564
## 78                              Fraser       CO_572
## 79                              Fraser      CO_7420
## 83                              Fraser      CO_7771
## 84                              Fraser      CO_7772
## 87                              Fraser      CO_7779
## 88                              Fraser      CO_7780
## 116                             Fraser    PKO_44654
## 131                             Fraser      SX_1874
## 132                             Fraser      SX_3077
## 133                             Fraser      SX_3085
## 134                             Fraser      SX_3092
## 135                             Fraser      SX_3220
## 136                             Fraser      SX_3221
## 137                             Fraser      SX_3438
## 148                             Fraser     SX_45038
## 149                             Fraser     SX_45040
## 150                             Fraser     SX_45056
## 151                             Fraser     SX_46308
## 166                             Fraser      SX_7639
## 167                             Fraser      SX_7640
## 168                             Fraser      SX_7689
## 171                             Fraser      SX_7807
## 174                             Fraser      SX_7822
## 6                          Haida Gwaii     CM_42458
## 56                         Haida Gwaii     CO_43196
## 114                        Haida Gwaii    PKO_41037
## 115                        Haida Gwaii    PKO_43007
## 140                        Haida Gwaii     SX_42680
## 141                        Haida Gwaii     SX_42950
## 142                        Haida Gwaii     SX_43095
## 7                                 Nass     CM_43568
## 57                                Nass     CO_43616
## 59                                Nass     CO_44840
## 70                                Nass     CO_48205
## 112                               Nass     PKO_3277
## 152                               Nass     SX_48264
## 13                              Skeena     CM_47648
## 58                              Skeena     CO_44441
## 69                              Skeena     CO_48090
## 71                              Skeena     CO_49415
## 92                              Skeena     PKE_3277
## 97                              Skeena    PKE_45454
## 109                             Skeena PKE_88092422
## 111                             Skeena     PKO_3195
## 130                             Skeena PKO_88092422
## 175                             Skeena  SX_80808204
## 3   Vancouver Island & Mainland Inlets      CM_3212
## 4   Vancouver Island & Mainland Inlets     CM_41256
## 5   Vancouver Island & Mainland Inlets     CM_41371
## 8   Vancouver Island & Mainland Inlets     CM_44524
## 9   Vancouver Island & Mainland Inlets     CM_44558
## 10  Vancouver Island & Mainland Inlets     CM_45283
## 11  Vancouver Island & Mainland Inlets     CM_45393
## 12  Vancouver Island & Mainland Inlets  CM_46787933
## 14  Vancouver Island & Mainland Inlets     CM_51026
## 15  Vancouver Island & Mainland Inlets     CM_51161
## 16  Vancouver Island & Mainland Inlets     CM_52086
## 17  Vancouver Island & Mainland Inlets     CM_52096
## 18  Vancouver Island & Mainland Inlets     CM_52171
## 19  Vancouver Island & Mainland Inlets     CM_52186
## 21  Vancouver Island & Mainland Inlets      CM_7009
## 27  Vancouver Island & Mainland Inlets      CM_7765
## 30  Vancouver Island & Mainland Inlets      CM_7774
## 32  Vancouver Island & Mainland Inlets      CM_7784
## 37  Vancouver Island & Mainland Inlets      CN_3213
## 38  Vancouver Island & Mainland Inlets      CN_3324
## 39  Vancouver Island & Mainland Inlets     CN_41103
## 41  Vancouver Island & Mainland Inlets     CN_49102
## 42  Vancouver Island & Mainland Inlets     CN_50009
## 44  Vancouver Island & Mainland Inlets     CN_50638
## 45  Vancouver Island & Mainland Inlets     CN_50698
## 46  Vancouver Island & Mainland Inlets     CN_51488
## 53  Vancouver Island & Mainland Inlets      CO_3211
## 54  Vancouver Island & Mainland Inlets      CO_3260
## 55  Vancouver Island & Mainland Inlets      CO_3321
## 64  Vancouver Island & Mainland Inlets     CO_45879
## 72  Vancouver Island & Mainland Inlets     CO_52082
## 73  Vancouver Island & Mainland Inlets     CO_52242
## 74  Vancouver Island & Mainland Inlets     CO_52262
## 75  Vancouver Island & Mainland Inlets     CO_52272
## 81  Vancouver Island & Mainland Inlets      CO_7747
## 82  Vancouver Island & Mainland Inlets      CO_7764
## 85  Vancouver Island & Mainland Inlets      CO_7773
## 91  Vancouver Island & Mainland Inlets       CO_792
## 95  Vancouver Island & Mainland Inlets    PKE_42409
## 98  Vancouver Island & Mainland Inlets    PKE_48638
## 99  Vancouver Island & Mainland Inlets    PKE_48658
## 100 Vancouver Island & Mainland Inlets    PKE_50012
## 101 Vancouver Island & Mainland Inlets    PKE_51064
## 107 Vancouver Island & Mainland Inlets    PKE_52754
## 110 Vancouver Island & Mainland Inlets      PKO_180
## 113 Vancouver Island & Mainland Inlets    PKO_40049
## 117 Vancouver Island & Mainland Inlets    PKO_49088
## 118 Vancouver Island & Mainland Inlets    PKO_50007
## 119 Vancouver Island & Mainland Inlets    PKO_50012
## 120 Vancouver Island & Mainland Inlets    PKO_50124
## 124 Vancouver Island & Mainland Inlets    PKO_52754
## 138 Vancouver Island & Mainland Inlets     SX_39730
## 139 Vancouver Island & Mainland Inlets     SX_40015
## 153 Vancouver Island & Mainland Inlets     SX_50005
## 154 Vancouver Island & Mainland Inlets     SX_50010
## 156 Vancouver Island & Mainland Inlets     SX_51000
## 157 Vancouver Island & Mainland Inlets     SX_51060
## 158 Vancouver Island & Mainland Inlets     SX_51145
## 159 Vancouver Island & Mainland Inlets     SX_51155
## 160 Vancouver Island & Mainland Inlets     SX_52080
## 161 Vancouver Island & Mainland Inlets     SX_52120
## 163 Vancouver Island & Mainland Inlets     SX_52750
## 164 Vancouver Island & Mainland Inlets     SX_52890
## 165 Vancouver Island & Mainland Inlets     SX_52960
## 169 Vancouver Island & Mainland Inlets      SX_7694
##                                                  POPULATION cuid
## 31                       Noosgulch River (Bella Coola) Chum  504
## 33               Fancy Cove (Head) Creek (Bella Bella) Chum  503
## 34           Fancy Cove Right Hand Creek (Bella Bella) Chum  503
## 35                            Fell Creek (Bella Bella) Chum  503
## 36                      Cascade River (Bella Colla) Chinook  515
## 43                    Hugh Creek (Kitimat-Butedale) Chinook  515
## 51                   Wathlsto Creek (Kitimat-Butedale) Coho  522
## 52                        Ada Cove Creek (Bella Bella) Coho  520
## 62                          Klemtu Creek (Bella Bella) Coho  520
## 76                      Mckay Creek (Kitimat-Butedale) Coho  522
## 80                   Clayton Falls Creek (Bella Coola) Coho  518
## 86                  Jenny Bay West Creek (Bella Coola) Coho  523
## 89                        Mclellan Creek (Bella Coola) Coho  518
## 90           Fannie Cove Left Hand Creek (Bella Bella) Coho  520
## 93                                    Gobeil Bay Creek Pink  609
## 94          Fannie Cove Right Hand Creek (Bella Bella) Pink  608
## 96                          Klemtu Creek (Bella Bella) Pink  608
## 102                        Rainbow Creek (Bella Bella) Pink  609
## 103                     Mckay Creek (Kitimat-Butedale) Pink  609
## 104                   Tetlock Creek (Kitimat-Butedale) Pink  609
## 105                    Hunter Creek (Kitimat-Butedale) Pink  609
## 106                   Alvin Creek (Grenville Principe) Pink  608
## 108              Fancy Cove (Head) Creek (Bella Bella) Pink  608
## 121                     Mckay Creek (Kitimat-Butedale) Pink  612
## 122                    Hunter Creek (Kitimat-Butedale) Pink  612
## 123                   Alvin Creek (Grenville Principe) Pink  611
## 125                      Noosgulch River (Bella Coola) Pink  610
## 126              Fancy Cove (Head) Creek (Bella Bella) Pink  611
## 127           Bullock Channel East Creek (Bella Bella) Pink  611
## 128          Fancy Cove Right Hand Creek (Bella Bella) Pink  611
## 129                           Fell Creek (Bella Bella) Pink  611
## 143                Webster Lake Creek (Bella Bella) Sockeye  615
## 144                 Turtle Creek (Kitimat-Butedale) Sockeye  614
## 145         Gribble Island Creek (Kitimat-Butedale) Sockeye  614
## 146           Fishtrap Bay Creek (Kitimat-Butedale) Sockeye  614
## 147        Little Tillhorn Creek (Kitimat-Butedale) Sockeye  614
## 155                  Wathl Creek (Kitimat-Butedale) Sockeye  614
## 162                 Hunter Creek (Kitimat-Butedale) Sockeye  614
## 170                 Moore Lake (Grenville Principe) Sockeye  599
## 172       Fannie Cove Left Hand Creek (Bella Bella) Sockeye  615
## 173                                   Atnarko Lakes Sockeye  528
## 1                        Maple Creek (Coquitlam) Chum Run 1  701
## 2                       Stoney Creek (Coquitlam) Chum Run 1  701
## 20                       Byrne Creek (Coquitlam) Chum Run 1  701
## 22                                Coho Creek (Mission) Chum  701
## 23                               Eagle Creek (Mission) Chum  701
## 24                           Holachten Creek (Mission) Chum  701
## 25                             Mystery Creek (Mission) Chum  701
## 26                           Silvermere Lake (Mission) Chum  701
## 28                            Cultus Lake (Chilliwack) Chum  701
## 29                          Camilos Creek (Chilliwack) Chum  701
## 40       Chilcotin River (Williams Lake Area) Chinook Run 1  310
## 47             Little Campbell River (Boundary Bay) Chinook  302
## 48                             Maple Creek (Coquitlam) Coho  750
## 49                            Nevin Creek (Chilliwack) Coho  750
## 50                        Taseko River (Williams Lake) Coho  749
## 60                           Palmer Creek (Salmon Arm) Coho  708
## 61                        Minton Creek (Williams Lake) Coho  749
## 63                 Williams Lake River (Williams Lake) Coho  749
## 65                             Ross Creek (Salmon Arm) Coho  708
## 66                         Taseko Lake (Williams Lake) Coho  749
## 67                         Elkin Creek (Williams Lake) Coho  749
## 68                            Yalakom River (Lillooet) Coho  749
## 77                             Byrne Creek (Coquitlam) Coho  750
## 78                          Calkins Creek (Chilliwack) Coho  750
## 79                            Teto Creek (Salmon Arm) Coho   708
## 83                     Blue Lead Creek (Williams Lake) Coho  749
## 84                         Wasko Creek (Williams Lake) Coho  749
## 87                          Quilchena Creek (Lillooet) Coho  707
## 88                     Hazeltine Creek (Williams Lake) Coho  749
## 116                           Gaspard Creek (Lillooet) Pink  710
## 131      Olsen Creek (Coquitlam) Early Summer Sockeye Run 1  715
## 132                  Butterfield Creek Early Stuart Sockeye  732
## 133                    Tarnezell Creek Early Stuart Sockeye  732
## 134                       Nancut Creek Early Stuart Sockeye  731
## 135                      Pomeroy Creek Early Summer Sockeye  735
## 136                          Sus Creek Early Summer Sockeye  735
## 137                               Loftus Creek Late Sockeye  739
## 148          Raft Creek (Williams Lake Area) Summer Sockeye  728
## 149       Winkley Creek (Williams Lake Area) Summer Sockeye  728
## 150          Amos Creek (Williams Lake Area) Summer Sockeye  728
## 151            Ross Creek (Salmon Arm) Early Summer Sockeye  738
## 166               Four Mile Creek (Salmon Arm) Late Sockeye  739
## 167                   Hlina Creek (Salmon Arm) Late Sockeye  739
## 168             Blue Creek (Coquitlam) Early Summer Sockeye  715
## 171                           Sawki Creek (Mission) Sockeye  714
## 174                                    Joffre Creek Sockeye  716
## 6                               Tlell River (Sandspit) Chum  801
## 56           Douglas Inlet Head Creek (West Coast QCI) Coho  808
## 114                              Kumdis Creek (Masset) Pink  814
## 115                       Bag Harbour Creek (Sandspit) Pink  813
## 140 Security Inlet Left Hand Creek (West Coast QCI) Sockeye  818
## 141    Werner Bay South Right Hand Creek (Sandspit) Sockeye  816
## 142          Louscoone Inlet Creek (West Coast QCI) Sockeye  818
## 7                           Cascade Creek (Lower Nass) Chum  406
## 57                          Donahue Creek (Lower Nass) Coho  410
## 59                             Crag Creek (Lower Nass) Coho  410
## 70                           Anudol Creek (Upper Nass) Coho  408
## 112                                          Dak River Pink  414
## 152                       Tseax Slough (Upper Nass) Sockeye  426
## 13                        Damshilgwit Creek (Smithers) Chum  242
## 58                               Deep Creek (Smithers) Coho  215
## 69                             Shannon Creek (Terrace) Coho  202
## 71                        Lower Tahlo Creek (Smithers) Coho  215
## 92                                           Dak River Pink  219
## 97                              Babine Lake (Smithers) Pink  218
## 109                             Dasque Creek (Terrace) Pink  219
## 111                                  Whitebottom Creek Pink  209
## 130                             Dasque Creek (Terrace) Pink  209
## 175                          Dasque Creek (Terrace) Sockeye  226
## 3                                      Clayoquot River Chum  978
## 4                                        Satchie Creek Chum  978
## 5                                       Oktwanch River Chum  978
## 8                                 Hesquiat Point Creek Chum  978
## 9                                      Muriel S1 Creek Chum  978
## 10                                          Draw Creek Chum  978
## 11        Carrington Creek (Campbell River Area) Chum Run 1  904
## 12                                   Muriel Lake Creek Chum  978
## 14               Health Lagoon Creek (Alert Bay) Chum Run 1  900
## 15                    Carriden Creek (Alert Bay) Chum Run 1  900
## 16                                        Kennedy Lake Chum  978
## 17                         Kennedy Lake Feeder Streams Chum  978
## 18                                          Cold Creek Chum  978
## 19                                        Angora Creek Chum  978
## 21                       Irgens Creek (Pender Harbour) Chum  904
## 27                                 Coho Creek (Tofino) Chum  978
## 30                         English Cove Creek (Tofino) Chum  978
## 32                       Hansen Creek (Campbell River) Chum  977
## 37                                  Clayoquot River Chinook  328
## 38                                      Upper Stamp Chinook  328
## 39                            White Pine Cove Creek Chinook  328
## 41       Hanson's Creek (Campbell River Area) Chinook Run 1  320
## 42                Upper Paradise Channel (Squamish) Chinook  320
## 44         Grassy Creek (Campbell River Area) Chinook Run 1  326
## 45        Wortley Creek (Campbell River Area) Chinook Run 1  326
## 46                        Millstone River (Nanaimo) Chinook  324
## 53                                     Clayoquot River Coho  915
## 54                                       Pacilth Creek Coho  914
## 55                                         Upper Stamp Coho  914
## 64         Whaletown Creek (Campbell River Area) Coho Run 1  908
## 72                                        Kennedy Lake Coho  915
## 73                                        Meares Creek Coho  915
## 74                                         Sharp Creek Coho  915
## 75                                     Cone Creeks (2) Coho  915
## 81                                  Bear Creek (Comox) Coho  910
## 82                                 Coho Creek (Tofino) Coho  915
## 85                         English Cove Creek (Tofino) Coho  915
## 91                   Cottonwood Creek (Squamish) Coho Run 1  907
## 95                Dominic Creek (Quatsino Sound) Pink Run 1  919
## 98                      Roberts Creek (Pender Harbour) Pink  917
## 99                       Wilson Creek (Pender Harbour) Pink  917
## 100                        Tenderfoot Creek (Squamish) Pink  917
## 101                Wahkana Bay Creek (Alert Bay) Pink Run 1  920
## 107             Owen Creek (Campbell River Area) Pink Run 1  920
## 110                 Myers Creek (Pender Harbour) Pink Run 1  922
## 113                Goldstream River (Victoria/Saanich) Pink  922
## 117              Store Creek (Powell River Area) Pink Run 1  922
## 118                  Upper Paradise Channel (Squamish) Pink  921
## 119                        Tenderfoot Creek (Squamish) Pink  921
## 120                     Mcnair Creek (Vancouver) Pink Run 1  922
## 124             Owen Creek (Campbell River Area) Pink Run 1  926
## 138               East Creek (Quatsino Sound) Sockeye Run 1  974
## 139                   Cowichan River (Duncan) Sockeye Run 1  973
## 153               Upper Paradise Channel (Squamish) Sockeye  973
## 154                     Tenderfoot Creek (Squamish) Sockeye  973
## 156                 Gilford Creek (Alert Bay) Sockeye Run 1  971
## 157             Wahkana Bay Creek (Alert Bay) Sockeye Run 1  971
## 158                  Embley Creek (Alert Bay) Sockeye Run 1  971
## 159                Carriden Creek (Alert Bay) Sockeye Run 1  971
## 160                                    Kennedy Lake Sockeye  958
## 161                           Clayoquot Arm Beaches Sockeye  972
## 163          Owen Creek (Campbell River Area) Sockeye Run 1  971
## 164       Menzies Creek (Campbell River Area) Sockeye Run 1  973
## 165        Willow Creek (Campbell River Area) Sockeye Run 1  973
## 169          Cypress Creek (Coquitlam) Early Summer Sockeye  973
##                                                 cu_name_pse
## 31                                  Bella Coola-Dean Rivers
## 33                                  Spiller-Fitz-Hugh-Burke
## 34                                  Spiller-Fitz-Hugh-Burke
## 35                                  Spiller-Fitz-Hugh-Burke
## 36                              North & Central Coast-Early
## 43                              North & Central Coast-Early
## 51                              Douglas Channel-Kitimat Arm
## 52                                   Hecate Strait Mainland
## 62                                   Hecate Strait Mainland
## 76                              Douglas Channel-Kitimat Arm
## 80                                  Bella Coola-Dean Rivers
## 86                                 Northern Coastal Streams
## 89                                  Bella Coola-Dean Rivers
## 90                                   Hecate Strait Mainland
## 93                              Hecate Strait-Fjords (even)
## 94                                   Hecate Lowlands (even)
## 96                                   Hecate Lowlands (even)
## 102                             Hecate Strait-Fjords (even)
## 103                             Hecate Strait-Fjords (even)
## 104                             Hecate Strait-Fjords (even)
## 105                             Hecate Strait-Fjords (even)
## 106                                  Hecate Lowlands (even)
## 108                                  Hecate Lowlands (even)
## 121                              Hecate Strait-Fjords (odd)
## 122                              Hecate Strait-Fjords (odd)
## 123                            Hecate Strait-Lowlands (odd)
## 125 Homathko-Klinaklini-Smith-Rivers-Bella Coola-Dean (odd)
## 126                            Hecate Strait-Lowlands (odd)
## 127                            Hecate Strait-Lowlands (odd)
## 128                            Hecate Strait-Lowlands (odd)
## 129                            Hecate Strait-Lowlands (odd)
## 143                   Northern Coastal Streams (river-type)
## 144                    Northern Coastal Fjords (river-type)
## 145                    Northern Coastal Fjords (river-type)
## 146                    Northern Coastal Fjords (river-type)
## 147                    Northern Coastal Fjords (river-type)
## 155                    Northern Coastal Fjords (river-type)
## 162                    Northern Coastal Fjords (river-type)
## 170                                    Tsimtack/Moore/Roger
## 172                   Northern Coastal Streams (river-type)
## 173                                     South Atnarko Lakes
## 1                                              Lower Fraser
## 2                                              Lower Fraser
## 20                                             Lower Fraser
## 22                                             Lower Fraser
## 23                                             Lower Fraser
## 24                                             Lower Fraser
## 25                                             Lower Fraser
## 26                                             Lower Fraser
## 28                                             Lower Fraser
## 29                                             Lower Fraser
## 40                         Middle Fraser River (Spring 5-2)
## 47                                  Boundary Bay (Fall 4-1)
## 48                                             Lower Fraser
## 49                                             Lower Fraser
## 50                                          Interior Fraser
## 60                                           South Thompson
## 61                                          Interior Fraser
## 63                                          Interior Fraser
## 65                                           South Thompson
## 66                                          Interior Fraser
## 67                                          Interior Fraser
## 68                                          Interior Fraser
## 77                                             Lower Fraser
## 78                                             Lower Fraser
## 79                                           South Thompson
## 83                                          Interior Fraser
## 84                                          Interior Fraser
## 87                                           Lower Thompson
## 88                                          Interior Fraser
## 116                                      Fraser River (odd)
## 131                                       Pitt-Early Summer
## 132                   Takla-Trembleur-Early Stuart (cyclic)
## 133                   Takla-Trembleur-Early Stuart (cyclic)
## 134                  Takla-Trembleur-Stuart-Summer (cyclic)
## 135                                     Bowron-Early Summer
## 136                                     Bowron-Early Summer
## 137                                   Shuswap-Late (cyclic)
## 148                                 Quesnel-Summer (cyclic)
## 149                                 Quesnel-Summer (cyclic)
## 150                                 Quesnel-Summer (cyclic)
## 151                           Shuswap-Early Summer (cyclic)
## 166                                   Shuswap-Late (cyclic)
## 167                                   Shuswap-Late (cyclic)
## 168                                       Pitt-Early Summer
## 171                        Harrison-Upstream Migrating-Late
## 174                                  Lillooet-Harrison-Late
## 6                                          East Haida Gwaii
## 56                                         West Haida Gwaii
## 114                                 North Haida Gwaii (odd)
## 115                                  East Haida Gwaii (odd)
## 140                           West Haida Gwaii (river-type)
## 141                           East Haida Gwaii (river-type)
## 142                           West Haida Gwaii (river-type)
## 7                                Portland Canal-Observatory
## 57          Portland Sound-Observatory Inlet-Portland Canal
## 59          Portland Sound-Observatory Inlet-Portland Canal
## 70                                               Lower Nass
## 112                         Nass-Portland-Observatory (odd)
## 152                        Lower Nass-Portland (river-type)
## 13                                             Upper Skeena
## 58                                            Middle Skeena
## 69                                             Lower Skeena
## 71                                            Middle Skeena
## 92                               Nass-Skeena Estuary (even)
## 97                               Middle-Upper Skeena (even)
## 109                              Nass-Skeena Estuary (even)
## 111                                Lower Skeena River (odd)
## 130                                Lower Skeena River (odd)
## 175                               Skeena River (river-type)
## 3                         Southwest & West Vancouver Island
## 4                         Southwest & West Vancouver Island
## 5                         Southwest & West Vancouver Island
## 8                         Southwest & West Vancouver Island
## 9                         Southwest & West Vancouver Island
## 10                        Southwest & West Vancouver Island
## 11                                           Georgia Strait
## 12                        Southwest & West Vancouver Island
## 14                                 Southern Coastal Streams
## 15                                 Southern Coastal Streams
## 16                        Southwest & West Vancouver Island
## 17                        Southwest & West Vancouver Island
## 18                        Southwest & West Vancouver Island
## 19                        Southwest & West Vancouver Island
## 21                                           Georgia Strait
## 27                        Southwest & West Vancouver Island
## 30                        Southwest & West Vancouver Island
## 32                               Northwest Vancouver Island
## 37                   West Vancouver Island-South (Fall x-1)
## 38                   West Vancouver Island-South (Fall x-1)
## 39                   West Vancouver Island-South (Fall x-1)
## 41              Southern Mainland-Georgia Strait (Fall x-1)
## 42              Southern Mainland-Georgia Strait (Fall x-1)
## 44             Southern Mainland-Southern Fjords (Fall x-1)
## 45             Southern Mainland-Southern Fjords (Fall x-1)
## 46   East Vancouver Island-Nanaimo and Chemainus (Fall x-1)
## 53                                                Clayoquot
## 54                                    West Vancouver Island
## 55                                    West Vancouver Island
## 64                                  Georgia Strait Mainland
## 72                                                Clayoquot
## 73                                                Clayoquot
## 74                                                Clayoquot
## 75                                                Clayoquot
## 81                     East Vancouver Island-Georgia Strait
## 82                                                Clayoquot
## 85                                                Clayoquot
## 91                                 Howe Sound-Burrard Inlet
## 95                        Northwest Vancouver Island (even)
## 98                                    Georgia Strait (even)
## 99                                    Georgia Strait (even)
## 100                                   Georgia Strait (even)
## 101                                  Southern Fjords (even)
## 107                                  Southern Fjords (even)
## 110                                    Georgia Strait (odd)
## 113                                    Georgia Strait (odd)
## 117                                    Georgia Strait (odd)
## 118                     East Howe Sound-Burrard Inlet (odd)
## 119                     East Howe Sound-Burrard Inlet (odd)
## 120                                    Georgia Strait (odd)
## 124                                   Southern Fjords (odd)
## 138                        NW Vancouver Island (river-type)
## 139     East Vancouver Island & Georgia Strait (river-type)
## 153     East Vancouver Island & Georgia Strait (river-type)
## 154     East Vancouver Island & Georgia Strait (river-type)
## 156                            Southern Fjords (river-type)
## 157                            Southern Fjords (river-type)
## 158                            Southern Fjords (river-type)
## 159                            Southern Fjords (river-type)
## 160                                                 Kennedy
## 161                      West Vancouver Island (river-type)
## 163                            Southern Fjords (river-type)
## 164     East Vancouver Island & Georgia Strait (river-type)
## 165     East Vancouver Island & Georgia Strait (river-type)
## 169     East Vancouver Island & Georgia Strait (river-type)
## [1] "There is no new IndexId (POP_ID) in the previous cleaned NuSEDS that is not in the updated one"

Check the time series:

There are 184 time series only found in the updated NuSEDS:

## [1] "For series CM_1622 - 11: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_2434 - 4: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_3212 - 2487: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_41256 - 1349: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_41371 - 1362: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_42458 - 1497: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_43568 - 1766: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_44524 - 2473: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_44558 - 2486: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_45283 - 2024: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_45393 - 2076: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_46787933 - 2488: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_46984 - 2529: Series not in CUSS and not merged with CM_46984 - 62 because of different location"

## [1] "For series CM_47648 - 499: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_47906 - 441: Series not in CUSS and not merged with CM_47906 - 3 because of different location and points are conflictual"

## [1] "For series CM_51026 - 865: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_51161 - 879: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_52086 - 1303: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_52096 - 7990617: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_52171 - 1312: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_52186 - 1314: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_562 - 2716: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7009 - 2837: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7734 - 182: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7735 - 52747: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7736 - 52748: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7737 - 189: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7739 - 52749: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7765 - 55413: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7768 - 2441: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7769 - 55417: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7774 - 55420: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7775 - 2252: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7784 - 57042: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7796 - 2685: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7812 - 2684: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CM_7816 - 3554: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_3103 - 983: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CN_3213 - 2487: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_3324 - 11486: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_3333 - 1194: Series not in CUSS and not merged with CN_3333 - 23735 because of different location"

## [1] "For series CN_41103 - 1333: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_46841 - 2454: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_46841 - 2462: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_46891 - 2466: Series not in CUSS and not merged with CN_46891 - 290 because of different location"

## [1] "For series CN_49102 - 802: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_50009 - 723: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_50319 - 1041: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_50638 - 826: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_50698 - 832: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CN_51488 - 1191: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CN_7808 - 64739: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_1624 - 11: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_1826 - 99: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_2511 - 2636: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CO_3027 - 2655: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_3169 - 2683: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CO_3211 - 2487: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_3260 - 2637: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CO_3321 - 11486: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_43196 - 1662: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_43616 - 1776: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_44441 - 2656: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_44840 - 2312: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_44988 - 2374: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_44998 - 2381: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CO_45303 - 2030: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_45309 - 2037: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CO_45879 - 403: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_46310 - 227: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_46582 - 63379: Series not in CUSS and not merged with CO_46582 - 256 because of different location"

## [1] "For series CO_46835 - 2463: it was previously:Alternative series for CO_46835 & GFE_ID = 285"

## [1] "For series CO_46855 - 287: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_46865 - 288: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_47232 - 134: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_48090 - 481: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_48205 - 640: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_49415 - 602: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_52082 - 1303: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_52242 - 1320: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_52262 - 1322: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_52272 - 1323: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_52376 - 1073: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_564 - 2716: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series CO_572 - 95: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7420 - 23726: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7729 - 2239: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7747 - 32077: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7764 - 55413: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7771 - 2422: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7772 - 11491: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7773 - 55420: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7776 - 2692: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7779 - 57040: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7780 - 2397: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7793 - 2681: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_7814 - 2687: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series CO_792 - 208: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_3277 - 2236: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_3304 - 11486: Series not in CUSS, not merged to altenative series INdexId = PKE_3304 & GHE_ID = 11485 because upper location; GFE_ID not in CUSS so coordinates were define by hand"

## [1] "For series PKE_3432 - 11572: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_3447 - 2708: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_42409 - 1490: it was previously:Removed because not in all_area_nuseds and alternative series PKE_54793433 & GFE_ID = 1490 ahs only one data point as was removed"

## [1] "For series PKE_45304 - 2030: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_45454 - 2107: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_48638 - 757: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_48658 - 759: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_50012 - 724: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_51064 - 869: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_51882 - 990: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_52377 - 1073: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_52387 - 1075: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_52392 - 1076: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_52492 - 1096: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_52754 - 1125: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_7797 - 2685: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKE_88092422 - 2601: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_180 - 2616: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_3195 - 2737: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_3277 - 2236: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_40049 - 1211: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_41037 - 1574: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_43007 - 1624: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_44654 - 2574: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_49088 - 801: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_50007 - 723: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_50012 - 724: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_50124 - 744: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series PKO_52377 - 1073: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_52392 - 1076: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_52492 - 1096: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_52754 - 1125: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_7792 - 2252: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_7797 - 2685: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_7811 - 2688: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_7813 - 2684: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_7817 - 3554: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series PKO_88092422 - 2601: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_1874 - 3505: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_3077 - 2753: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_3085 - 2761: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_3092 - 426: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_3220 - 2826: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series SX_3221 - 1991: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_3438 - 2434: Series not in CUSS, not merged to altenative series IndexId = SX_45085 & GHE_ID = 2434 because different run timing and associated to CU_NAME 'SHUSWAP COMPLEX-LATE TIMING'"

## [1] "For series SX_39730 - 1433: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_40015 - 1208: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_42680 - 1671: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_42950 - 1613: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_43095 - 1642: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_43770 - 1807: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_44135 - 1903: it was previously:Only NAs and/or 0s for MAX_ESTIMATE"

## [1] "For series SX_44140 - 1904: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_44160 - 1908: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_44165 - 1909: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_45038 - 2396: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_45040 - 2398: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_45056 - 2405: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_45141 - 2119: Series not in CUSS and not merged with SX_45141 - 2119 because of different location"

## [1] "For series SX_46308 - 227: Series not in CUSS, not merged to altenative series IndexId = SX_46309 & GHE_ID = 227 because different run timing and associated to CU_NAME 'SHUSWAP COMPLEX-EARLY SUMMER TIMING'"

## [1] "For series SX_48264 - 652: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_50005 - 723: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_50010 - 724: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_50340 - 1046: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_51000 - 863: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_51060 - 869: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_51145 - 878: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_51155 - 879: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_52080 - 1303: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_52120 - 1307: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_52390 - 1076: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_52750 - 1125: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_52890 - 1139: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_52960 - 1146: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7639 - 26771: Series not in CUSS, not merged to altenative series IndexId = SX_7636 & GHE_ID = 26771 because different run timing and associated to CU_NAME 'SHUSWAP COMPLEX-LATE TIMING'"

## [1] "For series SX_7640 - 26773: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7689 - 3510: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7694 - 3446: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7805 - 2792: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7807 - 185: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7815 - 2687: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7818 - 64745: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_7822 - 58219: No alternative series found but CU found using the PSE's CU shape files"

## [1] "For series SX_80808204 - 2601: No alternative series found but CU found using the PSE's CU shape files"

There are 1 time series only found in the previous NuSEDS: