b_nuseds_cuid_pse (Supplement A - Part 2)
Bruno S. Carturan, Eric Hertz, Stephanie J. Peacock
2025-08-19
This is the second part of the NuSEDS cleaning procedure. The goal of
the script is to import the cleaned merge of NUSEDS and
CUSS
(1_NuSEDS_escapement_data_collated_2025-04-15.csv) generated in
the first part (Supplement
A - Part 1; script a_nuseds_collation.rmd) and to associate
each population (POP_ID = IndexId, the latter
also specifying the species acronym) to the conservation unit
identification number cuid, as defined in the Pacific
Salmon explorer (PSE).
It is at the end of this script that the file nuseds_cuid_streamid_2025-04-15.csv used for the analyses in Atkinson et al. 2025. Monitoring for fisheries or for fish? Declines in monitoring of salmon spawners continue despite a conservation crisis is produced. The file can be accessed on Zenodo at Cleaned spawner survey data v3 and inside salmon_data_demise/data_output.
The NuSEDS dataset version corresponding to this script is:
Fisheries and Oceans Canada. 2025. NuSEDS - New Salmon Escapement Database System. Pacific Biological Station. Retrieved February 21, 2025, from https://open.canada.ca/data/en/dataset/c48669a3-045b-400d-b730-48aafe8c5ee6.
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 a_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 with the PSE.
## region sys_nm GFE_ID latitude
## 1 Fraser HOPEDALE SLOUGH 67 49.091933
## 2 Vancouver Island & Mainland Inlets ANDERSON CREEK 2615 49.639344
## 3 Vancouver Island & Mainland Inlets GLENORA CREEK 2624 48.743204
## 4 Vancouver Island & Mainland Inlets KELVIN CREEK 2625 48.749251
## 5 Vancouver Island & Mainland Inlets MESACHIE CREEK 2627 48.815708
## 6 Vancouver Island & Mainland Inlets MYERS CREEK 2616 49.640934
## longitude cu_name_pse cuid streamid
## 1 -122.034798 Lower Fraser 701 1
## 2 -123.983482 Georgia Strait 904 2
## 3 -123.710228 Georgia Strait 904 3
## 4 -123.689058 Georgia Strait 904 4
## 5 -124.125347 Georgia Strait 904 5
## 6 -123.986515 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:
## 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 22 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 FRANCOIS-EARLY SUMMER TIMING SEL-06-04 NA
## 17 MIDDLE FRASER SER-05 NA
## 18 INDIAN/KRUGER-EARLY SUMMER TIMING SEL-07-02 NA
## 19 PACK SEL-11-11 NA
## 20 (N)GLENDALE SEL-11-12 NA
## 21 OWIKENO-LATE TIMING SEL-15-03 NA
## 22 VILLAGE BAY SEL-11-10 NA
## CU_LAT CU_LONGT region
## 1 49.8326244 -121.486364 Fraser
## 2 49.2055667 -122.264657 Fraser
## 3 48.6210405 -123.626667 Vancouver Island & Mainland Inlets
## 4 53.0517086 -132.033046 Haida Gwaii
## 5 49.9329639 -122.175071 Fraser
## 6 49.6700560 -123.940879 Vancouver Island & Mainland Inlets
## 7 49.0624529 -121.646678 Fraser
## 8 50.4925101 -122.464757 Fraser
## 9 53.6151045 -120.800625 Fraser
## 10 50.6219665 -121.944076 Fraser
## 11 49.2461764 -124.820148 Vancouver Island & Mainland Inlets
## 12 52.7868324 -121.346601 Fraser
## 13 49.8283561 -126.917713 Vancouver Island & Mainland Inlets
## 14 53.2472844 -129.072309 Central Coast
## 15 53.9298171 -126.765161 Fraser
## 16 53.9742320 -126.684115 Fraser
## 17 52.3952991 -122.673443 Fraser
## 18 53.4452184 -121.567202 Fraser
## 19 51.1713069 -127.470073 Vancouver Island & Mainland Inlets
## 20 50.6510121 -125.723640 Vancouver Island & Mainland Inlets
## 21 51.7277005 -127.045381 Central Coast
## 22 50.2039980 -125.233277 Vancouver Island & Mainland InletsThe CU 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.
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
## 1 Fraser HOPEDALE SLOUGH 67 49.091933
## 2 Vancouver Island & Mainland Inlets ANDERSON CREEK 2615 49.639344
## 3 Vancouver Island & Mainland Inlets GLENORA CREEK 2624 48.743204
## 4 Vancouver Island & Mainland Inlets KELVIN CREEK 2625 48.749251
## 5 Vancouver Island & Mainland Inlets MESACHIE CREEK 2627 48.815708
## 6 Vancouver Island & Mainland Inlets MYERS CREEK 2616 49.640934
## longitude cu_name_pse cuid streamid
## 1 -122.034798 Lower Fraser 701 1
## 2 -123.983482 Georgia Strait 904 2
## 3 -123.710228 Georgia Strait 904 3
## 4 -123.689058 Georgia Strait 904 4
## 5 -124.125347 Georgia Strait 904 5
## 6 -123.986515 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 cuid
## 1 NuSEDS ALSEK RIVER 2324 59.4439650 -137.990785 1004
## 2 streamlocationids Alsek River NA 59.4439652 -137.990785 1004
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KLUKSHU RIVER 2332 60.1158630 -137.036216 1004
## 2 streamlocationids Klukshu River NA 60.1158633 -137.036216 1004
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TAKHANNE RIVER 2333 60.0944290 -136.991918 1004
## 2 streamlocationids Takhanne River NA 60.0944291 -136.991918 1004
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS BLANCHARD RIVER 2334 60.0321490 -136.893564 1004
## 2 streamlocationids Blanchard River NA 60.0321487 -136.893564 1004
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS GOAT CREEK 2335 59.8517550 -136.645447 1004
## 2 streamlocationids Goat Creek NA 59.8517549 -136.645447 1004
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TATSHENSHINI RIVER 2325 59.4705540 -137.741475 1021
## 2 streamlocationids Tatshenshini River NA 59.4705544 -137.741475 1021
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KLUKSHU RIVER 2332 60.1158630 -137.036216 1013
## 2 streamlocationids Klukshu River NA 60.1158633 -137.036216 1013
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KLUKSHU RIVER 2332 60.1158630 -137.036216 1038
## 2 streamlocationids Klukshu River NA 60.1158633 -137.036216 1038
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NESKETAHIN LAKE 2339 60.1740260 -137.075463 1039
## 2 streamlocationids Nesketahin Lake NA 60.1740256 -137.075463 1039
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TUYA RIVER 2155 58.0407150 -130.851366 1023
## 2 streamlocationids Tuya River NA 58.0407152 -130.851366 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CRAIG RIVER 2186 56.695946 -131.306744 1023
## 2 streamlocationids Craig River NA 56.695946 -131.306744 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS BRONSON CREEK 2192 56.6830670 -131.069523 1023
## 2 streamlocationids Bronson Creek NA 56.6830666 -131.069523 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS VERRETT RIVER 2193 56.6977970 -130.997244 1023
## 2 streamlocationids Verrett River NA 56.6977969 -130.997244 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TAKU RIVER 2203 58.5814190 -133.655591 1023
## 2 streamlocationids Taku River NA 58.5814187 -133.655591 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NAHLIN RIVER 2224 58.776725 -132.093396 1023
## 2 streamlocationids Nahlin River NA 58.776725 -132.093397 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS HACKETT RIVER 2233 58.2637470 -131.812126 1023
## 2 streamlocationids Hackett River NA 58.2637466 -131.812126 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS STIKINE RIVER 2118 56.6576360 -131.848936 1023
## 2 streamlocationids Stikine River NA 56.6576357 -131.848937 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS PORCUPINE RIVER 2138 57.0645810 -131.745164 1023
## 2 streamlocationids Porcupine River NA 57.0645809 -131.745164 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS SCUD RIVER 2148 57.2801370 -131.823164 1023
## 2 streamlocationids Scud River NA 57.2801373 -131.823164 1023
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CHRISTINA CREEK 2145 57.2413070 -131.85307 1025
## 2 streamlocationids Christina Creek NA 57.2413066 -131.85307 1025
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CHUTINE RIVER 2196 57.6530010 -131.632405 1036
## 2 streamlocationids Chutine River NA 57.6530013 -131.632405 1036
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS WEST KATETE RIVER 2571 56.63627 -131.843732 1017
## 2 streamlocationids West Katete River NA 56.63627 -131.843732 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CRAIG RIVER 2186 56.695946 -131.306744 1017
## 2 streamlocationids Craig River NA 56.695946 -131.306744 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS BRONSON CREEK 2192 56.6830670 -131.069523 1017
## 2 streamlocationids Bronson Creek NA 56.6830666 -131.069523 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS VERRETT RIVER 2193 56.6977970 -130.997244 1017
## 2 streamlocationids Verrett River NA 56.6977969 -130.997244 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KATETE RIVER 2119 56.6660830 -131.815945 1017
## 2 streamlocationids Katete River NA 56.6660832 -131.815945 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS PORCUPINE RIVER 2138 57.0645810 -131.745164 1017
## 2 streamlocationids Porcupine River NA 57.0645809 -131.745164 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CHRISTINA CREEK 2145 57.2413070 -131.85307 1017
## 2 streamlocationids Christina Creek NA 57.2413066 -131.85307 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS SCUD RIVER 2148 57.2801370 -131.823164 1017
## 2 streamlocationids Scud River NA 57.2801373 -131.823164 1017
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS BEATTY CREEK 2200 58.1022900 -131.190767 1010
## 2 streamlocationids Beatty Creek NA 58.1022897 -131.190766 1010
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS LITTLE TAHLTAN RIVER 2201 58.1210540 -131.320286 1010
## 2 streamlocationids Little Tahltan River NA 58.1210543 -131.320286 1010
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CHRISTINA CREEK 2145 57.2413070 -131.85307 1010
## 2 streamlocationids Christina Creek NA 57.2413066 -131.85307 1010
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS ISKUT RIVER 2178 56.7486260 -131.783170 1011
## 2 streamlocationids Iskut River NA 56.7486259 -131.783171 1011
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KATETE RIVER 2119 56.6660830 -131.815945 1011
## 2 streamlocationids Katete River NA 56.6660832 -131.815945 1011
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KING SALMON LAKE 2818 58.7162170 -132.943549 1033
## 2 streamlocationids King Salmon Lake NA 58.7162171 -132.943549 1033
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KUTHAI LAKE 2490 59.2308880 -133.233638 1027
## 2 streamlocationids Kuthai Lake NA 59.2308876 -133.233638 1027
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS LITTLE TRAPPER LAKE 2222 58.4961010 -132.60495 1028
## 2 streamlocationids Little Trapper Lake NA 58.4961014 -132.60495 1028
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NAHLIN RIVER 2224 58.776725 -132.093396 1006
## 2 streamlocationids Nahlin River NA 58.776725 -132.093397 1006
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS DUDIDONTU RIVER 2225 58.7894140 -131.985226 1006
## 2 streamlocationids Dudidontu River NA 58.7894135 -131.985226 1006
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TSETA CREEK 2228 58.9060590 -131.943667 1006
## 2 streamlocationids Tseta Creek NA 58.9060592 -131.943667 1006
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NAHLIN RIVER 2224 58.776725 -132.093396 1034
## 2 streamlocationids Nahlin River NA 58.776725 -132.093397 1034
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS DUDIDONTU RIVER 2225 58.7894140 -131.985226 1034
## 2 streamlocationids Dudidontu River NA 58.7894135 -131.985226 1034
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS HACKETT RIVER 2233 58.2637470 -131.812126 1008
## 2 streamlocationids Hackett River NA 58.2637466 -131.812126 1008
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS LITTLE SALMON RIVER 2495 62.0541750 -135.666719 1204
## 2 streamlocationids LITTLE SALMON RIVER NA 62.0541754 -135.666719 1204
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TATCHUN RIVER 2493 62.2853070 -136.325979 1204
## 2 streamlocationids TATCHUN RIVER NA 62.2853071 -136.325979 1204
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NORDENSKIOLD RIVER 2494 62.1021060 -136.30169 1202
## 2 streamlocationids NORDENSKIOLD RIVER NA 62.1021063 -136.30169 1202
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CHANDINDU RIVER 2492 64.2531800 -139.715179 1207
## 2 streamlocationids CHANDINDU RIVER NA 64.2531799 -139.715179 1207
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KLONDIKE RIVER 2548 64.0531440 -139.440789 1207
## 2 streamlocationids KLONDIKE RIVER NA 64.0531437 -139.440789 1207
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS BLIND CREEK 2514 62.1779450 -133.210517 1203
## 2 streamlocationids BLIND CREEK NA 62.1779448 -133.210517 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS EARN RIVER 2544 62.7363640 -134.6972 1203
## 2 streamlocationids EARN RIVER NA 62.7363643 -134.6972 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS GLENLYON RIVER 2545 62.4832990 -134.162555 1203
## 2 streamlocationids GLENLYON RIVER NA 62.4832992 -134.162555 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS HOOLE RIVER 2546 61.7493170 -131.710366 1203
## 2 streamlocationids HOOLE RIVER NA 61.7493167 -131.710366 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS HUSKY DOG CREEK 2547 63.0967610 -132.463228 1203
## 2 streamlocationids HUSKY DOG CREEK NA 63.0967605 -132.463228 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KALZAS RIVER 2543 62.8922190 -135.484785 1203
## 2 streamlocationids KALZAS RIVER NA 62.8922192 -135.484785 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS LEWIS LAKE 2551 62.616847 -131.080857 1203
## 2 streamlocationids LEWIS LAKE NA 62.616847 -131.080857 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS LITTLE KALZAS RIVER 2552 62.8902000 -135.470849 1203
## 2 streamlocationids LITTLE KALZAS RIVER NA 62.8902004 -135.470849 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MACMILLAN RIVER 2555 62.8688090 -135.901978 1203
## 2 streamlocationids MACMILLAN RIVER NA 62.8688086 -135.901978 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MOOSE RIVER 2572 62.9919260 -134.731012 1203
## 2 streamlocationids MOOSE RIVER NA 62.9919258 -134.731012 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS PELLY RIVER 2510 62.7874430 -137.330828 1203
## 2 streamlocationids PELLY RIVER NA 62.7874434 -137.330828 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS PREVOST RIVER 2559 62.6037160 -131.171368 1203
## 2 streamlocationids PREVOST RIVER NA 62.6037155 -131.171368 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS RIDDELL RIVER 2561 62.8464370 -132.426618 1203
## 2 streamlocationids RIDDELL RIVER NA 62.8464373 -132.426618 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS ROSS RIVER 2515 61.9836430 -132.422225 1203
## 2 streamlocationids ROSS RIVER NA 61.9836428 -132.422225 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS RUSSELL CREEK 2562 63.0362090 -133.390369 1203
## 2 streamlocationids RUSSELL CREEK NA 63.0362095 -133.390369 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS SHELDON LAKE 2563 62.6916670 -131.05 1203
## 2 streamlocationids SHELDON LAKE NA 62.6916668 -131.05 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TAY RIVER 2565 62.5692090 -134.358571 1203
## 2 streamlocationids TAY RIVER NA 62.5692085 -134.358571 1203
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MINER RIVER 2556 66.5060990 -138.416867 1209
## 2 streamlocationids MINER RIVER NA 66.5060986 -138.416867 1209
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MAYO RIVER 2554 63.5886140 -135.91465 1205
## 2 streamlocationids MAYO RIVER NA 63.5886137 -135.91465 1205
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MCQUESTEN RIVER 2504 63.5501530 -137.443171 1205
## 2 streamlocationids MCQUESTEN RIVER NA 63.5501532 -137.443171 1205
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS OLLIE LAKE 2557 63.0563490 -130.900151 1205
## 2 streamlocationids OLLIE LAKE NA 63.0563486 -130.900151 1205
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS PLEASANT CREEK 2558 63.5194660 -133.911306 1205
## 2 streamlocationids PLEASANT CREEK NA 63.5194658 -133.911306 1205
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CROOKED CREEK 2503 63.3802470 -136.689428 1205
## 2 streamlocationids CROOKED CREEK NA 63.3802473 -136.689428 1205
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS GLADYS LAKE 2500 59.8853830 -132.920473 1212
## 2 streamlocationids GLADYS LAKE NA 59.8853835 -132.920473 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MORLEY RIVER 2520 60.0946410 -132.495623 1212
## 2 streamlocationids MORLEY RIVER NA 60.0946414 -132.495623 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NISUTLIN RIVER 2517 60.2254480 -132.578771 1212
## 2 streamlocationids NISUTLIN RIVER NA 60.2254478 -132.578771 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS RED RIVER 2560 60.735664 -132.113346 1212
## 2 streamlocationids RED RIVER NA 60.735664 -132.113346 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS SIDNEY CREEK 2519 60.753917 -132.935167 1212
## 2 streamlocationids SIDNEY CREEK NA 60.753917 -132.935167 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS SWIFT RIVER 2564 59.7372020 -132.185571 1212
## 2 streamlocationids SWIFT RIVER NA 59.7372021 -132.185571 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS WOLF RIVER 2518 60.2762030 -132.552546 1212
## 2 streamlocationids WOLF RIVER NA 60.2762033 -132.552546 1212
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS LAKE LABERGE 2550 61.3507980 -135.261344 1211
## 2 streamlocationids LAKE LABERGE NA 61.3507979 -135.261344 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MARSH LAKE 2553 60.4664690 -134.300238 1211
## 2 streamlocationids MARSH LAKE NA 60.4664691 -134.300238 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MCINTYRE CREEK 2496 60.7685240 -135.088445 1211
## 2 streamlocationids MCINTYRE CREEK NA 60.7685241 -135.088445 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MICHIE CREEK 2498 60.673516 -134.472256 1211
## 2 streamlocationids MICHIE CREEK NA 60.673516 -134.472256 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TAKHINI RIVER 2521 60.841385 -135.181563 1211
## 2 streamlocationids TAKHINI RIVER NA 60.841385 -135.181563 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS WOLF CREEK 2497 60.6249680 -134.913199 1211
## 2 streamlocationids WOLF CREEK NA 60.6249684 -134.913199 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS YUKON RIVER - UPPER 2568 60.6936090 -135.039501 1211
## 2 streamlocationids YUKON RIVER - UPPER NA 60.6936087 -135.039501 1211
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS NISLING RIVER 2506 62.4636130 -139.484794 1206
## 2 streamlocationids NISLING RIVER NA 62.4636126 -139.484794 1206
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TINCUP CREEK 2508 61.8875940 -139.546345 1206
## 2 streamlocationids TINCUP CREEK NA 61.8875942 -139.546345 1206
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KLUANE RIVER 2509 61.8773760 -139.721235 1216
## 2 streamlocationids KLUANE RIVER NA 61.8773765 -139.721235 1216
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KOIDERN RIVER 2549 62.0329650 -140.441326 1216
## 2 streamlocationids KOIDERN RIVER NA 62.0329646 -140.441326 1216
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS YUKON RIVER - MIDDLE 2569 63.1782140 -139.573813 1213
## 2 streamlocationids YUKON RIVER - MIDDLE NA 63.1782143 -139.573813 1213
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS CHANDINDU RIVER 2492 64.2531800 -139.715179 1214
## 2 streamlocationids CHANDINDU RIVER NA 64.2531799 -139.715179 1214
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS KLONDIKE RIVER 2548 64.0531440 -139.440789 1214
## 2 streamlocationids KLONDIKE RIVER NA 64.0531437 -139.440789 1214
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS FISHING BRANCH RIVER 2522 66.4509820 -138.587915 1217
## 2 streamlocationids FISHING BRANCH RIVER NA 66.4509822 -138.587915 1217
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS MINER RIVER 2556 66.5060990 -138.416867 1217
## 2 streamlocationids MINER RIVER NA 66.5060986 -138.416867 1217
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS TESLIN RIVER 2499 61.5724440 -134.900263 1219
## 2 streamlocationids TESLIN RIVER NA 61.5724442 -134.900263 1219
## [1] ""
## dataset location GFE_ID latitude longitude cuid
## 1 NuSEDS DONJEK RIVER 2505 62.6033640 -139.988676 1215
## 2 streamlocationids DONJEK RIVER NA 62.6033638 -139.988676 1215
## [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 sys_nm cuid
## 1 Central Coast 2252 NOOSGULCH RIVER 504
## 2 Central Coast 2685 FANCY COVE HEAD CREEK 503
## 3 Central Coast 2684 FANCY COVE RIGHT HAND CREEK 503
## 4 Central Coast 3554 FELL CREEK 503
## 5 Central Coast 983 CASCADE RIVER 515
## 6 Central Coast 1041 HUGH CREEK 515
## 7 Central Coast 2655 WATHLSTO CREEK 522
## 8 Central Coast 2683 COOPER INLET-ADA COVE CREEK 520
## 9 Central Coast 2030 KLEMTU CREEK 520
## 10 Central Coast 1073 MCKAY CREEK 522
## 11 Central Coast 2239 CLAYTON FALLS CREEK 518
## 12 Central Coast 2692 JENNY BAY WEST CREEK 523
## 13 Central Coast 2681 MCLELLAN CREEK 518
## 14 Central Coast 2687 COOPER INLET-FANNIE COVE LH CREEK 520
## 15 Central Coast 11572 GOBEIL BAY CREEK 609
## 16 Central Coast 2708 COOPER INLET-FANNIE COVE RH CREEK 608
## 17 Central Coast 2030 KLEMTU CREEK 608
## 18 Central Coast 990 RAINBOW CREEK 609
## 19 Central Coast 1073 MCKAY CREEK 609
## 20 Central Coast 1075 TETLOCK CREEK 609
## 21 Central Coast 1076 HUNTER CREEK 609
## 22 Central Coast 1096 ALVIN CREEK 608
## 23 Central Coast 2685 FANCY COVE HEAD CREEK 608
## 24 Central Coast 1073 MCKAY CREEK 612
## 25 Central Coast 1076 HUNTER CREEK 612
## 26 Central Coast 1096 ALVIN CREEK 611
## 27 Central Coast 2252 NOOSGULCH RIVER 610
## 28 Central Coast 2685 FANCY COVE HEAD CREEK 611
## 29 Central Coast 2688 BULLOCK CHANNEL EAST CREEK 611
## 30 Central Coast 2684 FANCY COVE RIGHT HAND CREEK 611
## 31 Central Coast 3554 FELL CREEK 611
## 32 Central Coast 1807 WEBSTER LAKE CREEK 615
## 33 Central Coast 1903 TURTLE CREEK 614
## 34 Central Coast 1904 GRIBBELL ISLAND CREEK 614
## 35 Central Coast 1908 FISHTRAP BAY CREEK 614
## 36 Central Coast 1909 LITTLE TILLHORN CREEK 614
## 37 Central Coast 1046 WATHL CREEK 614
## 38 Central Coast 1076 HUNTER CREEK 614
## 39 Central Coast 2792 MOORE LAKE 599
## 40 Central Coast 2687 COOPER INLET-FANNIE COVE LH CREEK 615
## 41 Central Coast 64745 ATNARKO LAKES 528
## 42 Columbia 442 OKANAGAN RIVER 301
## 43 Columbia 442 OKANAGAN RIVER 1300
## 44 Fraser 11 MAPLE CREEK 701
## 45 Fraser 4 STONEY CREEK 701
## 46 Fraser 2529 ANDERSON CREEK CHANNEL 701
## 47 Fraser 441 EAGLE CREEK 701
## 48 Fraser 2716 BYRNE CREEK 701
## 49 Fraser 182 COHO CREEK 701
## 50 Fraser 52747 EAGLE CREEK 701
## 51 Fraser 52748 HOLACHTEN CREEK 701
## 52 Fraser 189 MYSTERY CREEK 701
## 53 Fraser 52749 SILVERMERE LAKE 701
## 54 Fraser 2441 CULTUS LAKE 701
## 55 Fraser 55417 CAMILOS CREEK 701
## 56 Fraser 2454 PUNKUTLAENKUT CREEK 310
## 57 Fraser 2462 CHILCOTIN RIVER - UPPER 310
## 58 Fraser 2466 CARIBOO RIVER - UPPER 311
## 59 Fraser 64739 CAMPBELL RIVER 302
## 60 Fraser 11 MAPLE CREEK 750
## 61 Fraser 99 NEVIN CREEK 750
## 62 Fraser 2636 TASEKO RIVER 749
## 63 Fraser 2374 PALMER CREEK 708
## 64 Fraser 2381 MINTON CREEK 749
## 65 Fraser 2037 WILLIAMS LAKE RIVER 749
## 66 Fraser 227 ROSS CREEK 708
## 67 Fraser 63379 ENGINEERED CHANNEL 709
## 68 Fraser 2463 CHILCOTIN RIVER - LOWER 749
## 69 Fraser 287 TASEKO LAKE 749
## 70 Fraser 288 ELKIN CREEK 749
## 71 Fraser 134 YALAKOM RIVER 749
## 72 Fraser 2716 BYRNE CREEK 750
## 73 Fraser 95 SEMMIHAULT CREEK 750
## 74 Fraser 23726 TETO CREEK 708
## 75 Fraser 2422 BLUE LEAD CREEK 749
## 76 Fraser 11491 WASKO CREEK 749
## 77 Fraser 57040 QUILCHENA CREEK 707
## 78 Fraser 2397 HAZELTINE CREEK 749
## 79 Fraser 2574 GASPARD CREEK 710
## 80 Fraser 3505 OLSEN CREEK 715
## 81 Fraser 2753 BUTTERFIELD CREEK 732
## 82 Fraser 2761 TARNEZELL CREEK 732
## 83 Fraser 426 NANCUT CREEK 731
## 84 Fraser 2826 POMEROY CREEK 735
## 85 Fraser 1991 SUS CREEK 735
## 86 Fraser 2434 LOFTUS CREEK 739
## 87 Fraser 2391 BURTON CREEK 760
## 88 Fraser 2396 RAFT CREEK 728
## 89 Fraser 2398 WINKLEY CREEK 728
## 90 Fraser 2405 AMOS CREEK 728
## 91 Fraser 2433 MOMICH RIVER - UPPER 761
## 92 Fraser 221 ADAMS RIVER - UPPER 760
## 93 Fraser 223 MOMICH RIVER 761
## 94 Fraser 224 CAYENNE CREEK 761
## 95 Fraser 227 ROSS CREEK 738
## 96 Fraser 26771 FOUR MILE CREEK 739
## 97 Fraser 26773 HLINA CREEK 739
## 98 Fraser 3510 BLUE CREEK 715
## 99 Fraser 185 SAKWI CREEK 714
## 100 Fraser 58219 JOFFRE CREEK 716
## 101 Haida Gwaii 1497 TLELL RIVER 801
## 102 Haida Gwaii 1662 DOUGLAS INLET CREEK-HEAD 808
## 103 Haida Gwaii 1574 KUMDIS CREEK 814
## 104 Haida Gwaii 1624 BAG HARBOUR CREEK 813
## 105 Haida Gwaii 1671 SECURITY INLET CREEK-L/H 818
## 106 Haida Gwaii 1613 MATHESON CREEK-R/H 816
## 107 Haida Gwaii 1642 LOUSCOONE INLET CREEK 818
## 108 Nass 1766 CASCADE CREEK 406
## 109 Nass 1776 DONAHUE CREEK 410
## 110 Nass 2312 CRAG CREEK 410
## 111 Nass 640 ANUDOL CREEK 408
## 112 Nass 2236 DAK RIVER 414
## 113 Nass 652 Ksi Sii Aks 2 426
## 114 Skeena 499 DAMSHILGWIT CREEK 242
## 115 Skeena 2656 DEEP CREEK 215
## 116 Skeena 481 SHANNON CREEK 202
## 117 Skeena 602 TAHLO CREEK - LOWER 215
## 118 Skeena 2236 DAK RIVER 219
## 119 Skeena 2107 BABINE LAKE 218
## 120 Skeena 2601 DASQUE CREEK 219
## 121 Skeena 2737 WHITEBOTTOM CREEK 209
## 122 Skeena 2601 DASQUE CREEK 209
## 123 Skeena 2601 DASQUE CREEK 226
## 124 Transboundary 2203 TAKU RIVER 1008
## 125 Transboundary 2118 STIKINE RIVER 1011
## 126 Transboundary 2199 TAHLTAN RIVER 1010
## 127 Transboundary 2212 TATSATUA CREEK 1008
## 128 Transboundary 2216 NAKINA RIVER 1007
## 129 Transboundary 2221 KOWATUA CREEK 1008
## 130 Transboundary 2203 TAKU RIVER 1034
## 131 Transboundary 2208 FLANAGAN SLOUGH 1034
## 132 Transboundary 2211 TATSAMENIE LAKE 1034
## 133 Transboundary 2212 TATSATUA CREEK 1034
## 134 Transboundary 2222 LITTLE TRAPPER LAKE 1034
## 135 Transboundary 2233 HACKETT RIVER 1034
## 136 Transboundary 2216 NAKINA RIVER 1019
## 137 Transboundary 2216 NAKINA RIVER 1020
## 138 Transboundary 2324 ALSEK RIVER 1021
## 139 Transboundary 2570 VERRETT SLOUGHS 1023
## 140 Transboundary 2338 VILLAGE CREEK 1021
## 141 Transboundary 2119 KATETE RIVER 1023
## 142 Transboundary 2199 TAHLTAN RIVER 1026
## 143 Transboundary 2211 TATSAMENIE LAKE 1029
## 144 Transboundary 2212 TATSATUA CREEK 1023
## 145 Transboundary 2216 NAKINA RIVER 1023
## 146 VIMI 2487 CLAYOQUOT RIVER 978
## 147 VIMI 1349 SATCHIE CREEK 978
## 148 VIMI 1362 OKTWANCH RIVER 978
## 149 VIMI 2473 HESQUIAT POINT CREEK 978
## 150 VIMI 2486 MURIEL S1 CREEK 978
## 151 VIMI 2024 DRAW CREEK 978
## 152 VIMI 2076 CARRINGTON COVE CREEK 904
## 153 VIMI 2488 MURIEL LAKE CREEK 978
## 154 VIMI 752 WEST BAY CREEK 905
## 155 VIMI 865 HEALTH LAGOON CREEK 900
## 156 VIMI 879 CARRIDEN CREEK 900
## 157 VIMI 1303 KENNEDY LAKE BEACHES 978
## 158 VIMI 7990617 KENNEDY LAKE FEEDER STREAMS 978
## 159 VIMI 1312 COLD CREEK 978
## 160 VIMI 1314 ANGORA CREEK 978
## 161 VIMI 2837 IRGENS CREEK 904
## 162 VIMI 55413 COHO CREEK 978
## 163 VIMI 55420 ENGLISH COVE CREEK 978
## 164 VIMI 57042 HANSEN CREEK 977
## 165 VIMI 2487 CLAYOQUOT RIVER 328
## 166 VIMI 1194 NANAIMO RIVER 323
## 167 VIMI 1333 WHITEPINE COVE CREEK 328
## 168 VIMI 802 HANSON'S CREEK 320
## 169 VIMI 723 PARADISE SPAWNING CHANNEL-UPPER 320
## 170 VIMI 826 GRASSY CREEK 326
## 171 VIMI 832 WORTLEY CREEK 326
## 172 VIMI 1191 MILLSTONE RIVER 324
## 173 VIMI 2487 CLAYOQUOT RIVER 915
## 174 VIMI 2637 PACILTH CREEK 914
## 175 VIMI 11486 WATERSHED ABOVE STAMP FALLS 914
## 176 VIMI 403 WHALETOWN CREEK 908
## 177 VIMI 1303 KENNEDY LAKE BEACHES 915
## 178 VIMI 1320 MEARES CREEK 915
## 179 VIMI 1322 SHARP CREEK 915
## 180 VIMI 1323 CONE CREEKS 915
## 181 VIMI 32077 BEAR CREEK 910
## 182 VIMI 55413 COHO CREEK 915
## 183 VIMI 55420 ENGLISH COVE CREEK 915
## 184 VIMI 208 COTTONWOOD CREEK 907
## 185 VIMI 11486 WATERSHED ABOVE STAMP FALLS 918
## 186 VIMI 1490 RUSSELL CREEK 919
## 187 VIMI 757 ROBERTS CREEK 917
## 188 VIMI 759 WILSON CREEK 917
## 189 VIMI 724 TENDERFOOT CREEK 917
## 190 VIMI 869 WAHKANA BAY CREEK 920
## 191 VIMI 1125 OWEN BAY CREEK 920
## 192 VIMI 2616 MYERS CREEK 922
## 193 VIMI 1211 GOLDSTREAM RIVER 922
## 194 VIMI 801 STORE CREEK 922
## 195 VIMI 723 PARADISE SPAWNING CHANNEL-UPPER 921
## 196 VIMI 724 TENDERFOOT CREEK 921
## 197 VIMI 744 MCNAIR CREEK 922
## 198 VIMI 1125 OWEN BAY CREEK 926
## 199 VIMI 1433 EAST CREEK 974
## 200 VIMI 1208 COWICHAN RIVER 973
## 201 VIMI 723 PARADISE SPAWNING CHANNEL-UPPER 973
## 202 VIMI 724 TENDERFOOT CREEK 973
## 203 VIMI 863 GILFORD CREEK 971
## 204 VIMI 869 WAHKANA BAY CREEK 971
## 205 VIMI 878 EMBLEY CREEK 971
## 206 VIMI 879 CARRIDEN CREEK 971
## 207 VIMI 1303 KENNEDY LAKE BEACHES 958
## 208 VIMI 1307 CLAYOQUOT ARM BEACHES 972
## 209 VIMI 1125 OWEN BAY CREEK 971
## 210 VIMI 1139 MENZIES CREEK 973
## 211 VIMI 1146 WILLOW CREEK 973
## 212 VIMI 3446 CYPRESS CREEK 973
## 213 Yukon 2491 YUKON RIVER 1214
## 214 Yukon 2567 LOWER YUKON RIVER 1214
## 215 Yukon 2491 YUKON RIVER 1207
## 216 Yukon 2499 TESLIN RIVER 1211
## 217 Yukon 2501 JENNINGS RIVER 1212
## 218 Yukon 2516 BIG SALMON RIVER 1204
## 219 Yukon 2567 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 Upper Skeena NA
## 115 Middle Skeena NA
## 116 Lower Skeena NA
## 117 Middle Skeena NA
## 118 Nass-Skeena Estuary (even) NA
## 119 Middle-Upper Skeena (even) NA
## 120 Nass-Skeena Estuary (even) NA
## 121 Lower Skeena River (odd) NA
## 122 Lower Skeena River (odd) NA
## 123 Skeena River (river-type) NA
## 124 Taku-Late Timing NA
## 125 Stikine-Late Timing NA
## 126 Stikine-Early Timing NA
## 127 Taku-Late Timing NA
## 128 Taku-Mid Timing NA
## 129 Taku-Late Timing NA
## 130 Taku-Early Timing NA
## 131 Taku-Early Timing NA
## 132 Taku-Early Timing NA
## 133 Taku-Early Timing NA
## 134 Taku-Early Timing NA
## 135 Taku-Early Timing NA
## 136 Transboundary Fjords (even) NA
## 137 Transboundary Fjords (odd) NA
## 138 Alsek (river-type) NA
## 139 Northern Transboundary Fjords (river-type) NA
## 140 Alsek (river-type) NA
## 141 Northern Transboundary Fjords (river-type) NA
## 142 Tahltan NA
## 143 Tatsamenie NA
## 144 Northern Transboundary Fjords (river-type) NA
## 145 Northern Transboundary Fjords (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 NAWe give them a new streamid value by simply incrementing
from the maximum current streamid value.
5 Export datasets
The following file is exported:
- nuseds_cuid_streamid_2025-04-15.csv: the cleaned NuSEDS
dataset with the PSE’s field:
cuid,streamid,cu_name_pse, etc.