2_nuseds_cuid_pse
Bruno S. Carturan, Eric Hertz, Stephanie J. Peacock
2025-02-27
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 AND/OR zeros were removed from NUSEDS in the early cleaning process in 1_nuseds_collation.rmd."## [1] "Zeros were replaced by NAs in the late cleaning process in 1_nuseds_collation.rmd."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 6Import 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 09We 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 292.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-162.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 968to:
## SPECIES_QUALIFIED CU_NAME SYSTEM_SITE GFE_ID
## 1 SER SOUTH ATNARKO LAKES BELLA COOLA RIVER 9682.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 Method3 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 508There 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 InletsThe 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 CREEKWe 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 LAKEWe 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 6484.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 6We 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 229 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 sys_nm
## 1 Central Coast 2252 NOOSGULCH RIVER
## 2 Central Coast 2685 FANCY COVE HEAD CREEK
## 3 Central Coast 2684 FANCY COVE RIGHT HAND CREEK
## 4 Central Coast 3554 FELL CREEK
## 5 Central Coast 983 CASCADE RIVER
## 6 Central Coast 1041 HUGH CREEK
## 7 Central Coast 2655 WATHLSTO CREEK
## 8 Central Coast 2683 COOPER INLET-ADA COVE CREEK
## 9 Central Coast 2030 KLEMTU CREEK
## 10 Central Coast 1073 MCKAY CREEK
## 11 Central Coast 2239 CLAYTON FALLS CREEK
## 12 Central Coast 2692 JENNY BAY WEST CREEK
## 13 Central Coast 2681 MCLELLAN CREEK
## 14 Central Coast 2687 COOPER INLET-FANNIE COVE LH CREEK
## 15 Central Coast 11572 GOBEIL BAY CREEK
## 16 Central Coast 2708 COOPER INLET-FANNIE COVE RH CREEK
## 17 Central Coast 2030 KLEMTU CREEK
## 18 Central Coast 990 RAINBOW CREEK
## 19 Central Coast 1073 MCKAY CREEK
## 20 Central Coast 1075 TETLOCK CREEK
## 21 Central Coast 1076 HUNTER CREEK
## 22 Central Coast 1096 ALVIN CREEK
## 23 Central Coast 2685 FANCY COVE HEAD CREEK
## 24 Central Coast 1073 MCKAY CREEK
## 25 Central Coast 1076 HUNTER CREEK
## 26 Central Coast 1096 ALVIN CREEK
## 27 Central Coast 2252 NOOSGULCH RIVER
## 28 Central Coast 2685 FANCY COVE HEAD CREEK
## 29 Central Coast 2688 BULLOCK CHANNEL EAST CREEK
## 30 Central Coast 2684 FANCY COVE RIGHT HAND CREEK
## 31 Central Coast 3554 FELL CREEK
## 32 Central Coast 1807 WEBSTER LAKE CREEK
## 33 Central Coast 1903 TURTLE CREEK
## 34 Central Coast 1904 GRIBBELL ISLAND CREEK
## 35 Central Coast 1908 FISHTRAP BAY CREEK
## 36 Central Coast 1909 LITTLE TILLHORN CREEK
## 37 Central Coast 1046 WATHL CREEK
## 38 Central Coast 1076 HUNTER CREEK
## 39 Central Coast 2792 MOORE LAKE
## 40 Central Coast 2687 COOPER INLET-FANNIE COVE LH CREEK
## 41 Central Coast 64745 ATNARKO LAKES
## 42 Columbia 442 OKANAGAN RIVER
## 43 Columbia 442 OKANAGAN RIVER
## 44 Fraser 11 MAPLE CREEK
## 45 Fraser 4 STONEY CREEK
## 46 Fraser 2529 ANDERSON CREEK CHANNEL
## 47 Fraser 441 EAGLE CREEK
## 48 Fraser 2716 BYRNE CREEK
## 49 Fraser 52748 HOLACHTEN CREEK
## 50 Fraser 189 MYSTERY CREEK
## 51 Fraser 52749 SILVERMERE LAKE
## 52 Fraser 2441 CULTUS LAKE
## 53 Fraser 55417 CAMILOS CREEK
## 54 Fraser 2454 PUNKUTLAENKUT CREEK
## 55 Fraser 2462 CHILCOTIN RIVER - UPPER
## 56 Fraser 2466 CARIBOO RIVER - UPPER
## 57 Fraser 64739 CAMPBELL RIVER
## 58 Fraser 99 NEVIN CREEK
## 59 Fraser 63379 ENGINEERED CHANNEL
## 60 Fraser 95 SEMMIHAULT CREEK
## 61 Fraser 23726 TETO CREEK
## 62 Fraser 2422 BLUE LEAD CREEK
## 63 Fraser 11491 WASKO CREEK
## 64 Fraser 2397 HAZELTINE CREEK
## 65 Fraser 3505 OLSEN CREEK
## 66 Fraser 2391 BURTON CREEK
## 67 Fraser 2433 MOMICH RIVER - UPPER
## 68 Fraser 221 ADAMS RIVER - UPPER
## 69 Fraser 223 MOMICH RIVER
## 70 Fraser 224 CAYENNE CREEK
## 71 Fraser 185 SAKWI CREEK
## 72 Fraser 58219 JOFFRE CREEK
## 73 Haida Gwaii 1497 TLELL RIVER
## 74 Haida Gwaii 1662 DOUGLAS INLET CREEK-HEAD
## 75 Haida Gwaii 1574 KUMDIS CREEK
## 76 Haida Gwaii 1624 BAG HARBOUR CREEK
## 77 Haida Gwaii 1671 SECURITY INLET CREEK-L/H
## 78 Haida Gwaii 1613 MATHESON CREEK-R/H
## 79 Haida Gwaii 1642 LOUSCOONE INLET CREEK
## 80 Nass 1766 CASCADE CREEK
## 81 Nass 1776 DONAHUE CREEK
## 82 Nass 2312 CRAG CREEK
## 83 Nass 640 ANUDOL CREEK
## 84 Nass 2236 DAK RIVER
## 85 Nass 652 Ksi Sii Aks 2
## 86 Northern Transboundary 2203 TAKU RIVER
## 87 Northern Transboundary 2118 STIKINE RIVER
## 88 Northern Transboundary 2199 TAHLTAN RIVER
## 89 Northern Transboundary 2212 TATSATUA CREEK
## 90 Northern Transboundary 2216 NAKINA RIVER
## 91 Northern Transboundary 2221 KOWATUA CREEK
## 92 Northern Transboundary 2203 TAKU RIVER
## 93 Northern Transboundary 2208 FLANAGAN SLOUGH
## 94 Northern Transboundary 2211 TATSAMENIE LAKE
## 95 Northern Transboundary 2212 TATSATUA CREEK
## 96 Northern Transboundary 2222 LITTLE TRAPPER LAKE
## 97 Northern Transboundary 2233 HACKETT RIVER
## 98 Northern Transboundary 2216 NAKINA RIVER
## 99 Northern Transboundary 2216 NAKINA RIVER
## 100 Northern Transboundary 2324 ALSEK RIVER
## 101 Northern Transboundary 2570 VERRETT SLOUGHS
## 102 Northern Transboundary 2338 VILLAGE CREEK
## 103 Northern Transboundary 2119 KATETE RIVER
## 104 Northern Transboundary 2199 TAHLTAN RIVER
## 105 Northern Transboundary 2211 TATSAMENIE LAKE
## 106 Northern Transboundary 2212 TATSATUA CREEK
## 107 Northern Transboundary 2216 NAKINA RIVER
## 108 Skeena 499 DAMSHILGWIT CREEK
## 109 Skeena 2656 DEEP CREEK
## 110 Skeena 481 SHANNON CREEK
## 111 Skeena 602 TAHLO CREEK - LOWER
## 112 Skeena 2236 DAK RIVER
## 113 Skeena 2107 BABINE LAKE
## 114 Skeena 2601 DASQUE CREEK
## 115 Skeena 2737 WHITEBOTTOM CREEK
## 116 Skeena 2601 DASQUE CREEK
## 117 Skeena 2601 DASQUE CREEK
## 118 Vancouver Island & Mainland Inlets 1362 OKTWANCH RIVER
## 119 Vancouver Island & Mainland Inlets 2076 CARRINGTON COVE CREEK
## 120 Vancouver Island & Mainland Inlets 752 WEST BAY CREEK
## 121 Vancouver Island & Mainland Inlets 865 HEALTH LAGOON CREEK
## 122 Vancouver Island & Mainland Inlets 1303 KENNEDY LAKE BEACHES
## 123 Vancouver Island & Mainland Inlets 2837 IRGENS CREEK
## 124 Vancouver Island & Mainland Inlets 57042 HANSEN CREEK
## 125 Vancouver Island & Mainland Inlets 2487 CLAYOQUOT RIVER
## 126 Vancouver Island & Mainland Inlets 1194 NANAIMO RIVER
## 127 Vancouver Island & Mainland Inlets 826 GRASSY CREEK
## 128 Vancouver Island & Mainland Inlets 1191 MILLSTONE RIVER
## 129 Vancouver Island & Mainland Inlets 2487 CLAYOQUOT RIVER
## 130 Vancouver Island & Mainland Inlets 11486 WATERSHED ABOVE STAMP FALLS
## 131 Vancouver Island & Mainland Inlets 1303 KENNEDY LAKE BEACHES
## 132 Vancouver Island & Mainland Inlets 1320 MEARES CREEK
## 133 Vancouver Island & Mainland Inlets 32077 BEAR CREEK
## 134 Vancouver Island & Mainland Inlets 55413 COHO CREEK
## 135 Vancouver Island & Mainland Inlets 55420 ENGLISH COVE CREEK
## 136 Vancouver Island & Mainland Inlets 208 COTTONWOOD CREEK
## 137 Vancouver Island & Mainland Inlets 11486 WATERSHED ABOVE STAMP FALLS
## 138 Vancouver Island & Mainland Inlets 757 ROBERTS CREEK
## 139 Vancouver Island & Mainland Inlets 759 WILSON CREEK
## 140 Vancouver Island & Mainland Inlets 869 WAHKANA BAY CREEK
## 141 Vancouver Island & Mainland Inlets 1125 OWEN BAY CREEK
## 142 Vancouver Island & Mainland Inlets 2616 MYERS CREEK
## 143 Vancouver Island & Mainland Inlets 1211 GOLDSTREAM RIVER
## 144 Vancouver Island & Mainland Inlets 801 STORE CREEK
## 145 Vancouver Island & Mainland Inlets 744 MCNAIR CREEK
## 146 Vancouver Island & Mainland Inlets 1125 OWEN BAY CREEK
## 147 Vancouver Island & Mainland Inlets 1208 COWICHAN RIVER
## 148 Vancouver Island & Mainland Inlets 878 EMBLEY CREEK
## 149 Vancouver Island & Mainland Inlets 1303 KENNEDY LAKE BEACHES
## 150 Vancouver Island & Mainland Inlets 1307 CLAYOQUOT ARM BEACHES
## 151 Vancouver Island & Mainland Inlets 1125 OWEN BAY CREEK
## 152 Vancouver Island & Mainland Inlets 1139 MENZIES CREEK
## 153 Yukon 2491 YUKON RIVER
## 154 Yukon 2567 LOWER YUKON RIVER
## 155 Yukon 2491 YUKON RIVER
## 156 Yukon 2499 TESLIN RIVER
## 157 Yukon 2501 JENNINGS RIVER
## 158 Yukon 2516 BIG SALMON RIVER
## 159 Yukon 2567 LOWER YUKON RIVER
## cuid cu_name_pse streamid
## 1 504 Bella Coola-Dean Rivers NA
## 2 503 Spiller-Fitz-Hugh-Burke NA
## 3 503 Spiller-Fitz-Hugh-Burke NA
## 4 503 Spiller-Fitz-Hugh-Burke NA
## 5 515 North & Central Coast-Early NA
## 6 515 North & Central Coast-Early NA
## 7 522 Douglas Channel-Kitimat Arm NA
## 8 520 Hecate Strait Mainland NA
## 9 520 Hecate Strait Mainland NA
## 10 522 Douglas Channel-Kitimat Arm NA
## 11 518 Bella Coola-Dean Rivers NA
## 12 523 Northern Coastal Streams NA
## 13 518 Bella Coola-Dean Rivers NA
## 14 520 Hecate Strait Mainland NA
## 15 609 Hecate Strait-Fjords (even) NA
## 16 608 Hecate Lowlands (even) NA
## 17 608 Hecate Lowlands (even) NA
## 18 609 Hecate Strait-Fjords (even) NA
## 19 609 Hecate Strait-Fjords (even) NA
## 20 609 Hecate Strait-Fjords (even) NA
## 21 609 Hecate Strait-Fjords (even) NA
## 22 608 Hecate Lowlands (even) NA
## 23 608 Hecate Lowlands (even) NA
## 24 612 Hecate Strait-Fjords (odd) NA
## 25 612 Hecate Strait-Fjords (odd) NA
## 26 611 Hecate Strait-Lowlands (odd) NA
## 27 610 Homathko-Klinaklini-Smith-Rivers-Bella Coola-Dean (odd) NA
## 28 611 Hecate Strait-Lowlands (odd) NA
## 29 611 Hecate Strait-Lowlands (odd) NA
## 30 611 Hecate Strait-Lowlands (odd) NA
## 31 611 Hecate Strait-Lowlands (odd) NA
## 32 615 Northern Coastal Streams (river-type) NA
## 33 614 Northern Coastal Fjords (river-type) NA
## 34 614 Northern Coastal Fjords (river-type) NA
## 35 614 Northern Coastal Fjords (river-type) NA
## 36 614 Northern Coastal Fjords (river-type) NA
## 37 614 Northern Coastal Fjords (river-type) NA
## 38 614 Northern Coastal Fjords (river-type) NA
## 39 599 Tsimtack/Moore/Roger NA
## 40 615 Northern Coastal Streams (river-type) NA
## 41 528 South Atnarko Lakes NA
## 42 301 Okanagan NA
## 43 1300 Osoyoos NA
## 44 701 Lower Fraser NA
## 45 701 Lower Fraser NA
## 46 701 Lower Fraser NA
## 47 701 Lower Fraser NA
## 48 701 Lower Fraser NA
## 49 701 Lower Fraser NA
## 50 701 Lower Fraser NA
## 51 701 Lower Fraser NA
## 52 701 Lower Fraser NA
## 53 701 Lower Fraser NA
## 54 310 Middle Fraser River (Spring 5-2) NA
## 55 310 Middle Fraser River (Spring 5-2) NA
## 56 311 Middle Fraser River (Summer 5-2) NA
## 57 302 Boundary Bay (Fall 4-1) NA
## 58 750 Lower Fraser NA
## 59 709 North Thompson NA
## 60 750 Lower Fraser NA
## 61 708 South Thompson NA
## 62 749 Interior Fraser NA
## 63 749 Interior Fraser NA
## 64 749 Interior Fraser NA
## 65 715 Pitt-Early Summer NA
## 66 760 Adams-Early Summer NA
## 67 761 Momich-Early Summer NA
## 68 760 Adams-Early Summer NA
## 69 761 Momich-Early Summer NA
## 70 761 Momich-Early Summer NA
## 71 714 Harrison-Upstream Migrating-Late NA
## 72 716 Lillooet-Harrison-Late NA
## 73 801 East Haida Gwaii NA
## 74 808 West Haida Gwaii NA
## 75 814 North Haida Gwaii (odd) NA
## 76 813 East Haida Gwaii (odd) NA
## 77 818 West Haida Gwaii (river-type) NA
## 78 816 East Haida Gwaii (river-type) NA
## 79 818 West Haida Gwaii (river-type) NA
## 80 406 Portland Canal-Observatory NA
## 81 410 Portland Sound-Observatory Inlet-Portland Canal NA
## 82 410 Portland Sound-Observatory Inlet-Portland Canal NA
## 83 408 Lower Nass NA
## 84 414 Nass-Portland-Observatory (odd) NA
## 85 426 Lower Nass-Portland (river-type) NA
## 86 1008 Taku-Late Timing NA
## 87 1011 Stikine-Late Timing NA
## 88 1010 Stikine-Early Timing NA
## 89 1008 Taku-Late Timing NA
## 90 1007 Taku-Mid Timing NA
## 91 1008 Taku-Late Timing NA
## 92 1034 Taku-Early Timing NA
## 93 1034 Taku-Early Timing NA
## 94 1034 Taku-Early Timing NA
## 95 1034 Taku-Early Timing NA
## 96 1034 Taku-Early Timing NA
## 97 1034 Taku-Early Timing NA
## 98 1019 Transboundary Fjords (even) NA
## 99 1020 Transboundary Fjords (odd) NA
## 100 1021 Alsek (river-type) NA
## 101 1023 Northern Transboundary Fjords (river-type) NA
## 102 1021 Alsek (river-type) NA
## 103 1023 Northern Transboundary Fjords (river-type) NA
## 104 1026 Tahltan NA
## 105 1029 Tatsamenie NA
## 106 1023 Northern Transboundary Fjords (river-type) NA
## 107 1023 Northern Transboundary Fjords (river-type) NA
## 108 242 Upper Skeena NA
## 109 215 Middle Skeena NA
## 110 202 Lower Skeena NA
## 111 215 Middle Skeena NA
## 112 219 Nass-Skeena Estuary (even) NA
## 113 218 Middle-Upper Skeena (even) NA
## 114 219 Nass-Skeena Estuary (even) NA
## 115 209 Lower Skeena River (odd) NA
## 116 209 Lower Skeena River (odd) NA
## 117 226 Skeena River (river-type) NA
## 118 978 Southwest & West Vancouver Island NA
## 119 904 Georgia Strait NA
## 120 905 Howe Sound-Burrard Inlet NA
## 121 900 Southern Coastal Streams NA
## 122 978 Southwest & West Vancouver Island NA
## 123 904 Georgia Strait NA
## 124 977 Northwest Vancouver Island NA
## 125 328 West Vancouver Island-South (Fall x-1) NA
## 126 323 East Vancouver Island-Nanaimo (Spring x-2) NA
## 127 326 Southern Mainland-Southern Fjords (Fall x-1) NA
## 128 324 East Vancouver Island-Nanaimo and Chemainus (Fall x-1) NA
## 129 915 Clayoquot NA
## 130 914 West Vancouver Island NA
## 131 915 Clayoquot NA
## 132 915 Clayoquot NA
## 133 910 East Vancouver Island-Georgia Strait NA
## 134 915 Clayoquot NA
## 135 915 Clayoquot NA
## 136 907 Howe Sound-Burrard Inlet NA
## 137 918 West Vancouver Island (even) NA
## 138 917 Georgia Strait (even) NA
## 139 917 Georgia Strait (even) NA
## 140 920 Southern Fjords (even) NA
## 141 920 Southern Fjords (even) NA
## 142 922 Georgia Strait (odd) NA
## 143 922 Georgia Strait (odd) NA
## 144 922 Georgia Strait (odd) NA
## 145 922 Georgia Strait (odd) NA
## 146 926 Southern Fjords (odd) NA
## 147 973 East Vancouver Island & Georgia Strait (river-type) NA
## 148 971 Southern Fjords (river-type) NA
## 149 958 Kennedy NA
## 150 972 West Vancouver Island (river-type) NA
## 151 971 Southern Fjords (river-type) NA
## 152 973 East Vancouver Island & Georgia Strait (river-type) NA
## 153 1214 North Yukon NA
## 154 1214 North Yukon NA
## 155 1207 Northern Yukon NA
## 156 1211 Upper Yukon NA
## 157 1212 Teslin NA
## 158 1204 Middle Yukon NA
## 159 1207 Northern Yukon NAWe 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 124 more time series in the updated cleaned NuSEDS dataset"Check the locations:
## [1] "There are 41 new locations in the updated NuSEDS:"
## region sys_nm GFE_ID
## 9 Central Coast NOOSGULCH RIVER 2252
## 11 Central Coast FANCY COVE HEAD CREEK 2685
## 12 Central Coast FANCY COVE RIGHT HAND CREEK 2684
## 13 Central Coast FELL CREEK 3554
## 27 Central Coast MCLELLAN CREEK 2681
## 33 Central Coast MOORE LAKE 2792
## 34 Central Coast ATNARKO LAKES 64745
## 1 Fraser MAPLE CREEK 11
## 2 Fraser EAGLE CREEK 441
## 4 Fraser BYRNE CREEK 2716
## 6 Fraser HOLACHTEN CREEK 52748
## 7 Fraser SILVERMERE LAKE 52749
## 8 Fraser CAMILOS CREEK 55417
## 14 Fraser PUNKUTLAENKUT CREEK 2454
## 15 Fraser CHILCOTIN RIVER - UPPER 2462
## 16 Fraser CARIBOO RIVER - UPPER 2466
## 17 Fraser CAMPBELL RIVER 64739
## 18 Fraser NEVIN CREEK 99
## 20 Fraser ENGINEERED CHANNEL 63379
## 21 Fraser SEMMIHAULT CREEK 95
## 22 Fraser TETO CREEK 23726
## 25 Fraser WASKO CREEK 11491
## 30 Fraser OLSEN CREEK 3505
## 35 Fraser JOFFRE CREEK 58219
## 19 Skeena DEEP CREEK 2656
## 29 Skeena WHITEBOTTOM CREEK 2737
## 3 Vancouver Island & Mainland Inlets KENNEDY LAKE BEACHES 1303
## 5 Vancouver Island & Mainland Inlets IRGENS CREEK 2837
## 10 Vancouver Island & Mainland Inlets HANSEN CREEK 57042
## 23 Vancouver Island & Mainland Inlets BEAR CREEK 32077
## 24 Vancouver Island & Mainland Inlets COHO CREEK 55413
## 26 Vancouver Island & Mainland Inlets ENGLISH COVE CREEK 55420
## 28 Vancouver Island & Mainland Inlets COTTONWOOD CREEK 208
## 32 Vancouver Island & Mainland Inlets CLAYOQUOT ARM BEACHES 1307
## 31 <NA> CARIBOO RIVER - UPPER 2466
## Y_LAT X_LONGT
## 9 52.43367 -126.3915
## 11 52.05897 -128.0088
## 12 52.05959 -128.0162
## 13 52.43358 -128.0791
## 27 52.38783 -126.6197
## 33 53.40953 -129.5011
## 34 52.16383 -125.7139
## 1 49.26403 -122.7845
## 2 49.24336 -122.9351
## 4 49.19248 -122.9999
## 6 49.22489 -122.0086
## 7 49.17497 -122.4088
## 8 49.38667 -121.3931
## 14 52.50968 -124.3801
## 15 52.33929 -124.0284
## 16 52.82510 -121.2772
## 17 49.01309 -122.7784
## 18 49.17598 -121.8066
## 20 51.58644 -119.8602
## 21 49.15306 -121.9561
## 22 50.99018 -118.6458
## 25 52.56677 -121.0077
## 30 49.59717 -122.6315
## 35 50.30000 -122.5833
## 19 54.58592 -126.8526
## 29 54.40481 -128.8642
## 3 49.04913 -125.5804
## 5 49.49690 -123.7463
## 10 50.77889 -128.3464
## 23 49.86550 -125.1504
## 24 49.10727 -125.7845
## 26 49.09423 -125.8433
## 28 49.76252 -123.1456
## 32 49.09903 -125.5919
## 31 52.82510 -121.2772## [1] "There is no location in the previous cleaned NuSEDS that is not in the updated one"Check the populations:
## [1] "There are 117 new IndexId (POP_ID) in the updated NuSEDS:"
## region IndexId
## 17 Central Coast CM_7775
## 19 Central Coast CM_7796
## 20 Central Coast CM_7812
## 21 Central Coast CM_7816
## 22 Central Coast CN_3103
## 26 Central Coast CN_50319
## 31 Central Coast CO_3027
## 32 Central Coast CO_3169
## 39 Central Coast CO_45303
## 45 Central Coast CO_52376
## 48 Central Coast CO_7729
## 54 Central Coast CO_7776
## 56 Central Coast CO_7793
## 57 Central Coast CO_7814
## 60 Central Coast PKE_3432
## 61 Central Coast PKE_3447
## 62 Central Coast PKE_45304
## 67 Central Coast PKE_51882
## 68 Central Coast PKE_52377
## 69 Central Coast PKE_52387
## 70 Central Coast PKE_52392
## 71 Central Coast PKE_52492
## 73 Central Coast PKE_7797
## 83 Central Coast PKO_52377
## 84 Central Coast PKO_52392
## 85 Central Coast PKO_52492
## 87 Central Coast PKO_7792
## 88 Central Coast PKO_7797
## 89 Central Coast PKO_7811
## 90 Central Coast PKO_7813
## 91 Central Coast PKO_7817
## 98 Central Coast SX_43770
## 99 Central Coast SX_44135
## 100 Central Coast SX_44140
## 101 Central Coast SX_44160
## 102 Central Coast SX_44165
## 104 Central Coast SX_50340
## 108 Central Coast SX_52390
## 111 Central Coast SX_7805
## 113 Central Coast SX_7815
## 114 Central Coast SX_7818
## 1 Fraser CM_1622
## 2 Fraser CM_2434
## 10 Fraser CM_562
## 12 Fraser CM_7736
## 13 Fraser CM_7737
## 14 Fraser CM_7739
## 15 Fraser CM_7768
## 16 Fraser CM_7769
## 25 Fraser CN_46841
## 29 Fraser CN_7808
## 30 Fraser CO_1826
## 46 Fraser CO_572
## 47 Fraser CO_7420
## 51 Fraser CO_7771
## 52 Fraser CO_7772
## 55 Fraser CO_7780
## 93 Fraser SX_1874
## 112 Fraser SX_7807
## 115 Fraser SX_7822
## 4 Haida Gwaii CM_42458
## 35 Haida Gwaii CO_43196
## 79 Haida Gwaii PKO_41037
## 80 Haida Gwaii PKO_43007
## 95 Haida Gwaii SX_42680
## 96 Haida Gwaii SX_42950
## 97 Haida Gwaii SX_43095
## 5 Nass CM_43568
## 36 Nass CO_43616
## 38 Nass CO_44840
## 41 Nass CO_48205
## 77 Nass PKO_3277
## 103 Nass SX_48264
## 7 Skeena CM_47648
## 37 Skeena CO_44441
## 40 Skeena CO_48090
## 42 Skeena CO_49415
## 59 Skeena PKE_3277
## 63 Skeena PKE_45454
## 74 Skeena PKE_88092422
## 76 Skeena PKO_3195
## 92 Skeena PKO_88092422
## 116 Skeena SX_80808204
## 3 Vancouver Island & Mainland Inlets CM_41371
## 6 Vancouver Island & Mainland Inlets CM_45393
## 8 Vancouver Island & Mainland Inlets CM_51026
## 9 Vancouver Island & Mainland Inlets CM_52086
## 11 Vancouver Island & Mainland Inlets CM_7009
## 18 Vancouver Island & Mainland Inlets CM_7784
## 23 Vancouver Island & Mainland Inlets CN_3213
## 24 Vancouver Island & Mainland Inlets CN_3324
## 27 Vancouver Island & Mainland Inlets CN_50638
## 28 Vancouver Island & Mainland Inlets CN_51488
## 33 Vancouver Island & Mainland Inlets CO_3211
## 34 Vancouver Island & Mainland Inlets CO_3321
## 43 Vancouver Island & Mainland Inlets CO_52082
## 44 Vancouver Island & Mainland Inlets CO_52242
## 49 Vancouver Island & Mainland Inlets CO_7747
## 50 Vancouver Island & Mainland Inlets CO_7764
## 53 Vancouver Island & Mainland Inlets CO_7773
## 58 Vancouver Island & Mainland Inlets CO_792
## 64 Vancouver Island & Mainland Inlets PKE_48638
## 65 Vancouver Island & Mainland Inlets PKE_48658
## 66 Vancouver Island & Mainland Inlets PKE_51064
## 72 Vancouver Island & Mainland Inlets PKE_52754
## 75 Vancouver Island & Mainland Inlets PKO_180
## 78 Vancouver Island & Mainland Inlets PKO_40049
## 81 Vancouver Island & Mainland Inlets PKO_49088
## 82 Vancouver Island & Mainland Inlets PKO_50124
## 86 Vancouver Island & Mainland Inlets PKO_52754
## 94 Vancouver Island & Mainland Inlets SX_40015
## 105 Vancouver Island & Mainland Inlets SX_51145
## 106 Vancouver Island & Mainland Inlets SX_52080
## 107 Vancouver Island & Mainland Inlets SX_52120
## 109 Vancouver Island & Mainland Inlets SX_52750
## 110 Vancouver Island & Mainland Inlets SX_52890
## POPULATION cuid
## 17 Noosgulch River (Bella Coola) Chum 504
## 19 Fancy Cove (Head) Creek (Bella Bella) Chum 503
## 20 Fancy Cove Right Hand Creek (Bella Bella) Chum 503
## 21 Fell Creek (Bella Bella) Chum 503
## 22 Cascade River (Bella Colla) Chinook 515
## 26 Hugh Creek (Kitimat-Butedale) Chinook 515
## 31 Wathlsto Creek (Kitimat-Butedale) Coho 522
## 32 Ada Cove Creek (Bella Bella) Coho 520
## 39 Klemtu Creek (Bella Bella) Coho 520
## 45 Mckay Creek (Kitimat-Butedale) Coho 522
## 48 Clayton Falls Creek (Bella Coola) Coho 518
## 54 Jenny Bay West Creek (Bella Coola) Coho 523
## 56 Mclellan Creek (Bella Coola) Coho 518
## 57 Fannie Cove Left Hand Creek (Bella Bella) Coho 520
## 60 Gobeil Bay Creek Pink 609
## 61 Fannie Cove Right Hand Creek (Bella Bella) Pink 608
## 62 Klemtu Creek (Bella Bella) Pink 608
## 67 Rainbow Creek (Bella Bella) Pink 609
## 68 Mckay Creek (Kitimat-Butedale) Pink 609
## 69 Tetlock Creek (Kitimat-Butedale) Pink 609
## 70 Hunter Creek (Kitimat-Butedale) Pink 609
## 71 Alvin Creek (Grenville Principe) Pink 608
## 73 Fancy Cove (Head) Creek (Bella Bella) Pink 608
## 83 Mckay Creek (Kitimat-Butedale) Pink 612
## 84 Hunter Creek (Kitimat-Butedale) Pink 612
## 85 Alvin Creek (Grenville Principe) Pink 611
## 87 Noosgulch River (Bella Coola) Pink 610
## 88 Fancy Cove (Head) Creek (Bella Bella) Pink 611
## 89 Bullock Channel East Creek (Bella Bella) Pink 611
## 90 Fancy Cove Right Hand Creek (Bella Bella) Pink 611
## 91 Fell Creek (Bella Bella) Pink 611
## 98 Webster Lake Creek (Bella Bella) Sockeye 615
## 99 Turtle Creek (Kitimat-Butedale) Sockeye 614
## 100 Gribble Island Creek (Kitimat-Butedale) Sockeye 614
## 101 Fishtrap Bay Creek (Kitimat-Butedale) Sockeye 614
## 102 Little Tillhorn Creek (Kitimat-Butedale) Sockeye 614
## 104 Wathl Creek (Kitimat-Butedale) Sockeye 614
## 108 Hunter Creek (Kitimat-Butedale) Sockeye 614
## 111 Moore Lake (Grenville Principe) Sockeye 599
## 113 Fannie Cove Left Hand Creek (Bella Bella) Sockeye 615
## 114 Atnarko Lakes Sockeye 528
## 1 Maple Creek (Coquitlam) Chum Run 1 701
## 2 Stoney Creek (Coquitlam) Chum Run 1 701
## 10 Byrne Creek (Coquitlam) Chum Run 1 701
## 12 Holachten Creek (Mission) Chum 701
## 13 Mystery Creek (Mission) Chum 701
## 14 Silvermere Lake (Mission) Chum 701
## 15 Cultus Lake (Chilliwack) Chum 701
## 16 Camilos Creek (Chilliwack) Chum 701
## 25 Chilcotin River (Williams Lake Area) Chinook Run 1 310
## 29 Little Campbell River (Boundary Bay) Chinook 302
## 30 Nevin Creek (Chilliwack) Coho 750
## 46 Calkins Creek (Chilliwack) Coho 750
## 47 Teto Creek (Salmon Arm) Coho 708
## 51 Blue Lead Creek (Williams Lake) Coho 749
## 52 Wasko Creek (Williams Lake) Coho 749
## 55 Hazeltine Creek (Williams Lake) Coho 749
## 93 Olsen Creek (Coquitlam) Early Summer Sockeye Run 1 715
## 112 Sawki Creek (Mission) Sockeye 714
## 115 Joffre Creek Sockeye 716
## 4 Tlell River (Sandspit) Chum 801
## 35 Douglas Inlet Head Creek (West Coast QCI) Coho 808
## 79 Kumdis Creek (Masset) Pink 814
## 80 Bag Harbour Creek (Sandspit) Pink 813
## 95 Security Inlet Left Hand Creek (West Coast QCI) Sockeye 818
## 96 Werner Bay South Right Hand Creek (Sandspit) Sockeye 816
## 97 Louscoone Inlet Creek (West Coast QCI) Sockeye 818
## 5 Cascade Creek (Lower Nass) Chum 406
## 36 Donahue Creek (Lower Nass) Coho 410
## 38 Crag Creek (Lower Nass) Coho 410
## 41 Anudol Creek (Upper Nass) Coho 408
## 77 Dak River Pink 414
## 103 Tseax Slough (Upper Nass) Sockeye 426
## 7 Damshilgwit Creek (Smithers) Chum 242
## 37 Deep Creek (Smithers) Coho 215
## 40 Shannon Creek (Terrace) Coho 202
## 42 Lower Tahlo Creek (Smithers) Coho 215
## 59 Dak River Pink 219
## 63 Babine Lake (Smithers) Pink 218
## 74 Dasque Creek (Terrace) Pink 219
## 76 Whitebottom Creek Pink 209
## 92 Dasque Creek (Terrace) Pink 209
## 116 Dasque Creek (Terrace) Sockeye 226
## 3 Oktwanch River Chum 978
## 6 Carrington Creek (Campbell River Area) Chum Run 1 904
## 8 Health Lagoon Creek (Alert Bay) Chum Run 1 900
## 9 Kennedy Lake Chum 978
## 11 Irgens Creek (Pender Harbour) Chum 904
## 18 Hansen Creek (Campbell River) Chum 977
## 23 Clayoquot River Chinook 328
## 24 Upper Stamp Chinook 328
## 27 Grassy Creek (Campbell River Area) Chinook Run 1 326
## 28 Millstone River (Nanaimo) Chinook 324
## 33 Clayoquot River Coho 915
## 34 Upper Stamp Coho 914
## 43 Kennedy Lake Coho 915
## 44 Meares Creek Coho 915
## 49 Bear Creek (Comox) Coho 910
## 50 Coho Creek (Tofino) Coho 915
## 53 English Cove Creek (Tofino) Coho 915
## 58 Cottonwood Creek (Squamish) Coho Run 1 907
## 64 Roberts Creek (Pender Harbour) Pink 917
## 65 Wilson Creek (Pender Harbour) Pink 917
## 66 Wahkana Bay Creek (Alert Bay) Pink Run 1 920
## 72 Owen Creek (Campbell River Area) Pink Run 1 920
## 75 Myers Creek (Pender Harbour) Pink Run 1 922
## 78 Goldstream River (Victoria/Saanich) Pink 922
## 81 Store Creek (Powell River Area) Pink Run 1 922
## 82 Mcnair Creek (Vancouver) Pink Run 1 922
## 86 Owen Creek (Campbell River Area) Pink Run 1 926
## 94 Cowichan River (Duncan) Sockeye Run 1 973
## 105 Embley Creek (Alert Bay) Sockeye Run 1 971
## 106 Kennedy Lake Sockeye 958
## 107 Clayoquot Arm Beaches Sockeye 972
## 109 Owen Creek (Campbell River Area) Sockeye Run 1 971
## 110 Menzies Creek (Campbell River Area) Sockeye Run 1 973
## cu_name_pse
## 17 Bella Coola-Dean Rivers
## 19 Spiller-Fitz-Hugh-Burke
## 20 Spiller-Fitz-Hugh-Burke
## 21 Spiller-Fitz-Hugh-Burke
## 22 North & Central Coast-Early
## 26 North & Central Coast-Early
## 31 Douglas Channel-Kitimat Arm
## 32 Hecate Strait Mainland
## 39 Hecate Strait Mainland
## 45 Douglas Channel-Kitimat Arm
## 48 Bella Coola-Dean Rivers
## 54 Northern Coastal Streams
## 56 Bella Coola-Dean Rivers
## 57 Hecate Strait Mainland
## 60 Hecate Strait-Fjords (even)
## 61 Hecate Lowlands (even)
## 62 Hecate Lowlands (even)
## 67 Hecate Strait-Fjords (even)
## 68 Hecate Strait-Fjords (even)
## 69 Hecate Strait-Fjords (even)
## 70 Hecate Strait-Fjords (even)
## 71 Hecate Lowlands (even)
## 73 Hecate Lowlands (even)
## 83 Hecate Strait-Fjords (odd)
## 84 Hecate Strait-Fjords (odd)
## 85 Hecate Strait-Lowlands (odd)
## 87 Homathko-Klinaklini-Smith-Rivers-Bella Coola-Dean (odd)
## 88 Hecate Strait-Lowlands (odd)
## 89 Hecate Strait-Lowlands (odd)
## 90 Hecate Strait-Lowlands (odd)
## 91 Hecate Strait-Lowlands (odd)
## 98 Northern Coastal Streams (river-type)
## 99 Northern Coastal Fjords (river-type)
## 100 Northern Coastal Fjords (river-type)
## 101 Northern Coastal Fjords (river-type)
## 102 Northern Coastal Fjords (river-type)
## 104 Northern Coastal Fjords (river-type)
## 108 Northern Coastal Fjords (river-type)
## 111 Tsimtack/Moore/Roger
## 113 Northern Coastal Streams (river-type)
## 114 South Atnarko Lakes
## 1 Lower Fraser
## 2 Lower Fraser
## 10 Lower Fraser
## 12 Lower Fraser
## 13 Lower Fraser
## 14 Lower Fraser
## 15 Lower Fraser
## 16 Lower Fraser
## 25 Middle Fraser River (Spring 5-2)
## 29 Boundary Bay (Fall 4-1)
## 30 Lower Fraser
## 46 Lower Fraser
## 47 South Thompson
## 51 Interior Fraser
## 52 Interior Fraser
## 55 Interior Fraser
## 93 Pitt-Early Summer
## 112 Harrison-Upstream Migrating-Late
## 115 Lillooet-Harrison-Late
## 4 East Haida Gwaii
## 35 West Haida Gwaii
## 79 North Haida Gwaii (odd)
## 80 East Haida Gwaii (odd)
## 95 West Haida Gwaii (river-type)
## 96 East Haida Gwaii (river-type)
## 97 West Haida Gwaii (river-type)
## 5 Portland Canal-Observatory
## 36 Portland Sound-Observatory Inlet-Portland Canal
## 38 Portland Sound-Observatory Inlet-Portland Canal
## 41 Lower Nass
## 77 Nass-Portland-Observatory (odd)
## 103 Lower Nass-Portland (river-type)
## 7 Upper Skeena
## 37 Middle Skeena
## 40 Lower Skeena
## 42 Middle Skeena
## 59 Nass-Skeena Estuary (even)
## 63 Middle-Upper Skeena (even)
## 74 Nass-Skeena Estuary (even)
## 76 Lower Skeena River (odd)
## 92 Lower Skeena River (odd)
## 116 Skeena River (river-type)
## 3 Southwest & West Vancouver Island
## 6 Georgia Strait
## 8 Southern Coastal Streams
## 9 Southwest & West Vancouver Island
## 11 Georgia Strait
## 18 Northwest Vancouver Island
## 23 West Vancouver Island-South (Fall x-1)
## 24 West Vancouver Island-South (Fall x-1)
## 27 Southern Mainland-Southern Fjords (Fall x-1)
## 28 East Vancouver Island-Nanaimo and Chemainus (Fall x-1)
## 33 Clayoquot
## 34 West Vancouver Island
## 43 Clayoquot
## 44 Clayoquot
## 49 East Vancouver Island-Georgia Strait
## 50 Clayoquot
## 53 Clayoquot
## 58 Howe Sound-Burrard Inlet
## 64 Georgia Strait (even)
## 65 Georgia Strait (even)
## 66 Southern Fjords (even)
## 72 Southern Fjords (even)
## 75 Georgia Strait (odd)
## 78 Georgia Strait (odd)
## 81 Georgia Strait (odd)
## 82 Georgia Strait (odd)
## 86 Southern Fjords (odd)
## 94 East Vancouver Island & Georgia Strait (river-type)
## 105 Southern Fjords (river-type)
## 106 Kennedy
## 107 West Vancouver Island (river-type)
## 109 Southern Fjords (river-type)
## 110 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 124 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_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_45393 - 2076: 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_52086 - 1303: 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_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_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_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_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_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_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_1826 - 99: No alternative series found but CU found using the PSE's CU shape files"
## [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_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_45303 - 2030: 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_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_52376 - 1073: No alternative series found but CU found using the PSE's CU shape files"
## [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_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_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_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_49088 - 801: 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_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_45141 - 2119: Series not in CUSS and not merged with SX_45141 - 2119 because of different location"
## [1] "For series SX_48264 - 652: 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_51145 - 878: 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_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 0 time series only found in the previous NuSEDS: