2_nuseds_cuid_pse
Bruno S. Carturan, Eric Hertz, Stephanie J. Peacock
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 identification 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.
IMPORTANT NOTE: This is the script that PSF maintains actively and it is updated annually as new versions of NuSEDS are released. The corresponding script used in Atkinson et al. 2025. Monitoring for fisheries or for fish? Declines in monitoring of salmon spawners continue despite a conservation crisis is accessible at: b_nuseds_cuid_pse.Rmd.
1 Import datasets
Import the cleaned NuSEDS dataset with the following decisions made concerning zeros:
## [1] "Time series only composed of NAs were removed from NUSEDS in the early cleaning process in 1_nuseds_collation.rmd, the ones also including zeros are kept."## [1] "Zeros are NOT replaced by NAs."The PSE file conservationunits_decoder.csv is imported; this
is the file containing the current cuid associated to
NuSEDS’s FULL_CU_IN (named cu_index in the
decoder file).
Import the streamlocationids.csv to access the location names, coordinates and identification number for maintaining consistency.
## [1] "Date last modification of streamlocationids.csv: 2026-01-29 15:46:44.22537"## region sys_nm GFE_ID latitude
## 1 Fraser HOPEDALE SLOUGH 67 49.09298
## 2 East Vancouver Island & Mainland Inlets ANDERSON CREEK 2615 49.64048
## 3 East Vancouver Island & Mainland Inlets GLENORA CREEK 2624 48.74283
## 4 East Vancouver Island & Mainland Inlets KELVIN CREEK 2625 48.74980
## 5 East Vancouver Island & Mainland Inlets MESACHIE CREEK 2627 48.81603
## 6 East Vancouver Island & Mainland Inlets MYERS CREEK 2616 49.64041
## longitude cu_name_pse cuid streamid
## 1 -122.0322 Lower Fraser 701 1
## 2 -123.9876 Georgia Strait 904 2
## 3 -123.7127 Georgia Strait 904 3
## 4 -123.6892 Georgia Strait 904 4
## 5 -124.1260 Georgia Strait 904 5
## 6 -123.9886 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 Corrections on certain Skeena Sockeye river CUs
The time series for Skeena Sockeye with POPULATION =
Babine Lake (Smithers) Sockeye and Babine River - Unaccounted (Smithers)
Sockeye are assigned to CU_NAME = BABINE
(FULL_CU_IN = SEL-21-02) but they should not because they
represent “timing groups” and not CUs (emailed from Andy Rosenberger
sent in 2026-03-11). So we remove these time series. Here is the data
removed:
## [1] "Number of rows removed: 33"
## [1] "Number of rows removed: 59"Additionally, the time series for Skeena Sockeye with
POPULATION = Morrison Creek (Smithers) Sockeye is assigned
to CU_NAME = BABINE (FULL_CU_IN = SEL-21-02)
but it should be assigned to CU CU_NAME = TAHLO/MORRISON
(FULL_CU_IN = SEL-21-11) (emailed from Andy Rosenberger
sent in 2026-03-11). So we change the CU-related fields from:
## FULL_CU_IN cuid cu_name_pse CU_NAME CU_ACRO CU_LAT CU_LONGT CU_TYPE
## 1 SEL-21-02 180 Babine/Onerka BABINE Babine 54.75203 -125.9835 Current
## CU_INDEX
## 1 L-21-02to:
## FULL_CU_IN cuid cu_name_pse CU_NAME CU_ACRO CU_LAT
## 1 SEL-21-11 189 Tahlo/Morrison TAHLO/MORRISON Tahlo/Morrison 55.27534
## CU_LONGT CU_TYPE CU_INDEX
## 1 -126.3943 Current L-21-112.3 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 Sockeye BABINE Babine/Onerka
## 2 Skeena Sockeye BABINE Nilkitkwa
## 3 Skeena Sockeye BABINE Babine (enhanced)
## 4 Central Coast Chum BELLA COOLA-DEAN RIVERS 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-16 CM-162.4 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 CENSUS_SITE GFE_ID
## 1 SER NORTHERN COASTAL FJORDS BELLA COOLA RIVER 968to:
## SPECIES_QUALIFIED CU_NAME CENSUS_SITE GFE_ID
## 1 SER SOUTH ATNARKO LAKES BELLA COOLA RIVER 9682.5 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 <NA>2.6 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 FULL_CU_IN not matching any cuid
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:
There are 22 FULL_CU_IN that are not in
conservationunits_decoder.csv. We use the regions’ shape file
to find their respective region:
## FULL_CU_IN CU_NAME
## 1 CK-9006 FRASER-CROSS-CU SUPPLEMENTATION EXCLUSION
## 2 CK-9008 FRASER-HARRISON FALL TRANSPLANT_FA_0.3
## 3 CK-9004 FRASER-MISCELLANEOUS
## 4 CK-9007 SOUTHERN BC-CROSS-CU SUPPLEMENTATION EXCLUSION
## 5 CK-9005 SOUTH-MISCELLANEOUS
## 6 CK-9002 HATCHERY EXCLUSION-PALLANT CREEK
## 7 CM-9004 INTERIOR FRASER
## 8 PKE-9005 FRASER RIVER
## 9 SER-06 UPPER FRASER
## 10 SEL-03-xx FRASER RIVER MIGRATORY COUNTS
## 11 SER-05 MIDDLE FRASER
## 12 SEL-07-02 INDIAN/KRUGER-EARLY SUMMER TIMING
## 13 SEL-06-18 CARIBOO-SUMMER TIMING
## 14 SEL-06-04 FRANCOIS-EARLY SUMMER TIMING
## 15 SEL-06-05 FRANCOIS-LATE TIMING
## 16 SEL-11-12 GLENDALE
## 17 SEL-11-11 PACK
## 18 SEL-11-10 VILLAGE BAY
## 19 SEL-15-03 OWIKENO-LATE TIMING
## 20 SEL-18-11 WHALEN
## 21 SEL-13-xx GREAT CENTRAL/SPROAT
## 22 SEL-13-21 OWOSSITSA
## region
## 1 Fraser
## 2 Fraser
## 3 Fraser
## 4 East Vancouver Island & Mainland Inlets
## 5 East Vancouver Island & Mainland Inlets
## 6 Haida Gwaii
## 7 Fraser
## 8 Fraser
## 9 Fraser
## 10 Fraser
## 11 Fraser
## 12 Fraser
## 13 Fraser
## 14 Fraser
## 15 Fraser
## 16 East Vancouver Island & Mainland Inlets
## 17 East Vancouver Island & Mainland Inlets
## 18 East Vancouver Island & Mainland Inlets
## 19 Central Coast
## 20 Central Coast
## 21 West Vancouver Island
## 22 West Vancouver IslandWe 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
We also create the field sys_nm, which is equivalent of
CENSUS_SITE but the following corrections or modification
for the following locations:
## CENSUS_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 BEDWELL RIVER
## 11 BIG LOON CREEK
## 12 BIG SLIDE - SHORE
## 13 BIG SLIDE - SHORE 1KM W
## 14 BILL MINER CREEK - SHORE
## 15 BILL MINER CREEK - SHORE 3KM W
## 16 BLUE LEAD CREEK - SHORE
## 17 BOISE CREEK - NORTH
## 18 BOTANY INLET HEAD CREEK
## 19 BOTANY INLET OUTER CREEK
## 20 BOUGHEY CREEK
## 21 BOULDERY CREEK - SHORE
## 22 BOULDERY CREEK - SHORE 2KM E
## 23 BOWLING POINT - GOOSE POINT
## 24 BOYDEN CREEK
## 25 BRENNAN CHANNEL
## 26 BUCK CHANNEL CREEK #EIGHT
## 27 BUCK CHANNEL CREEK #FIVE
## 28 BUCK CHANNEL CREEK #ONE
## 29 BUCK CHANNEL CREEK #SEVEN
## 30 BUCK CHANNEL CREEK #SIX
## 31 BUCK CHANNEL CREEK #THREE
## 32 BUCK CHANNEL CREEK #TWO
## 33 BURNABY NARROWS FIRST R.H. CR.
## 34 BURNABY NARROWS SECOND R.H. CR.
## 35 BURNABY STRAITS CREEK
## 36 BUSH CREEK - SHORE
## 37 CARRINGTON CREEK
## 38 CENTENNIAL CHANNEL
## 39 CHAMISS CREEK
## 40 CHILKO CHANNEL
## 41 CHILLIWACK RIVER
## 42 CHOKE PASS CREEKS (3)
## 43 CHONAT CREEK
## 44 CLOSE CREEKS (2)
## 45 COHOE CREEK
## 46 CONE CREEKS (2)
## 47 COOPER INLET CREEKS
## 48 COTTONWOOD RIVER - UPPER
## 49 CROSS CREEK
## 50 CROWN ZELLERBACK CREEK
## 51 CRUICKSHANK POINT WEST
## 52 DANA #1 CREEK
## 53 DANA #2 CREEK
## 54 DANA #3 CREEK
## 55 DEVOE CREEK - SHORE
## 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 FALL CREEK
## 63 FANNIE COVE LEFT HAND CREEK
## 64 FANNIE COVE RIGHT HAND CREEK
## 65 FORTUNE CREEK
## 66 FOUR MILE CREEK - SHORE
## 67 FRANKS CREEK - SHORE
## 68 FURLONG CREEK
## 69 GOOSE POINT - SHORE .8KM S
## 70 GOOSE POINT - SHORE 5KM S
## 71 GRAIN CREEK - SHORE
## 72 GRAY BAY CREEK OTHERS (3)
## 73 GRIBBLE ISLAND CREEK
## 74 HAIG-BROWN KINGFISHER CREEK
## 75 HARTIE CREEK
## 76 HENDERSON LAKE
## 77 HESQUIAT HARBOUR #1 CREEKS
## 78 HESQUIAT HARBOUR #2 CREEKS
## 79 HESQUIAT HARBOUR #3 CREEKS
## 80 HESQUIAT HARBOUR #4 CREEKS
## 81 HEVENOR CREEK
## 82 HLINA CREEK - SHORE
## 83 HOCHSTADER BASIN CREEKS (2)
## 84 HOEYA EAST CREEK
## 85 HURRICANE POINT
## 86 HUSTON R.H. AND L.H. CREEKS
## 87 HUTTON HEAD CREEK
## 88 HUTTON LEFT HAND CREEK
## 89 INDIAN CABIN CREEK RIGHT HAND
## 90 INNER BASIN RIVER (RANSOM)
## 91 ISLAND BAY LEFT HAND CREEK
## 92 ISLAND BAY RIGHT HAND CREEK
## 93 JOHNNY SANDY CREEK
## 94 JONES CREEK CHANNEL
## 95 JUNCTION - SHORE
## 96 KAISUN CREEK
## 97 KILDIDT LAGOON #2 CREEK
## 98 KILLDOG CREEK - SHORE
## 99 KNIGHT CREEK - SHORE
## 100 KSEMAMAITH CREEK
## 101 KSGA'MAAL
## 102 KSI HLGINX
## 103 KSI MAT'IN
## 104 KSI SGASGINIST
## 105 KSI SGAWBAN
## 106 KSI X'ANMAS
## 107 LAGINS RIGHT HAND CREEK
## 108 LASSITER AND ROWLEY CREEKS
## 109 LEE CREEK - SHORE
## 110 LIMESTONE POINT
## 111 LIMESTONE POINT - SHORE .5KM S
## 112 LITTLE WHITEPINE COVE #1 CREEK
## 113 LONG CREEK - SHORE
## 114 LOST VALLEY CREEK - SHORE SPAWNERS
## 115 LOWER AHWHICHAOLTO CREEK
## 116 LOWER PARADISE CHANNEL
## 117 LYNX CREEK - SHORE
## 118 MACDOUGALL CREEK
## 119 MAMQUAM SPAWNING CHANNEL
## 120 MARSHALL INLET RIGHT HAND CREEK
## 121 MARTEN CREEK - SHORE
## 122 MATHESON L.H. CREEK
## 123 MATHESON RIGHT HAND CREEK
## 124 MCKAY COVE CREEK
## 125 MESACHIE RIVER
## 126 MIDDLE NORTH THOMPSON RIVER MAINSTEM
## 127 MIKADO CREEK
## 128 MOMICH RIVER - SHORE
## 129 MOODY CHANNEL
## 130 NESTO INLET OUTER CREEK
## 131 NOBLE CREEK
## 132 NORRISH CREEK
## 133 NORTH ARM CREEK RIGHT HAND
## 134 ONYX CREEK - SHORE
## 135 OPA BEACH
## 136 OWEN CREEK
## 137 PASS CREEK - LAKE SHORE
## 138 PEACH SPAWNING CHANNEL
## 139 PEEL INLET 1ST LEFT HAND CREEK
## 140 PEEL INLET 2ND LEFT HAND CREEK
## 141 PENFOLD CAMP - SHORE
## 142 PIG CHANNEL COMBINED
## 143 POOLE INLET CREEKS (4)
## 144 QUEEST CREEK - SHORE
## 145 QUESNEL LAKE EAST ARM - UNNAMED CREEK 1
## 146 QUESNEL LAKE NORTH ARM - UNNAMED COVE
## 147 RAINEY CREEK
## 148 REINECKER CREEK
## 149 RESCUE BAY CREEKS
## 150 ROARING POINT
## 151 ROARING RIVER - DECEPTION POINT
## 152 ROARING RIVER - SHORE
## 153 ROCK SLIDE TO PENINSULA POINT - SHORE
## 154 ROSS CREEK - SHORE
## 155 SALTSPRING BAY L.H. CREEK
## 156 SCOTCH CREEK - SHORE
## 157 SECTION COVE RIGHT HAND CREEK
## 158 SECURITY INLET LEFT HAND CREEK
## 159 SECURITY INLET RIGHT HAND CREEK
## 160 SETON CHANNELS - UPPER AND LOWER
## 161 SHUSWAP LAKE SEYMOUR ARM
## 162 SHUSWAP LAKE ANSTEY ARM
## 163 SHUSWAP LAKE MAIN ARM
## 164 SHUSWAP LAKE MAIN ARM - NORTH SHORE
## 165 SHUSWAP LAKE MAIN ARM - SOUTH SHORE
## 166 SHUSWAP LAKE SALMON ARM
## 167 SHUSWAP LAKE SALMON ARM - EAST SHORE
## 168 SHUSWAP LAKE SALMON ARM - NORTH SHORE
## 169 SHUSWAP LAKE SALMON ARM - SOUTH SHORE
## 170 SKAAT HARBOUR HEAD CREEK
## 171 SKAAT HARBOUR L.H.CREEK
## 172 SKAAT HARBOUR R.H. CREEK
## 173 SLATE BAY - SHORE 1KM E
## 174 SOUTH BAY #1 CREEK
## 175 SQUEAH LAKE CREEK
## 176 STEPHENS CREEK (DOWNSTREAM OF STEPHENS LAKE)
## 177 SURPRISE CREEK
## 178 SWAN LAKE CREEK #2 UNNAMED
## 179 TARTU INLET HEAD CREEK
## 180 TARTU INLET OUTER CREEK
## 181 TASEKO LAKES
## 182 TASSE CREEK - SHORE
## 183 TRACY BAY #2 CREEK
## 184 TSEAX SLOUGH
## 185 TSUIUS CREEK - SHORE SPAWNERS
## 186 TUNO CREEK
## 187 UNNAMED CREEK - SHORE SPAWNERS
## 188 UNNAMED POINT
## 189 UPPER AHWHICHAOLTO CREEK
## 190 UPPER PARADISE CHANNEL
## 191 VANISHING CREEK - SHORE
## 192 WASKO CREEK - SHORE
## 193 WATT CREEK - SHORE
## 194 WEAVER CHANNEL
## 195 WHISPERING CREEK
## 196 WRIGHT LAKE CREEK
## 197 XNUKW
## 198 YOHETTA CREEK - LOWER
## 199 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 BEDWELL SYSTEM 7990630
## 11 Big Loon Creek 607
## 12 BIG SLIDE-LAKE SHORE 11492
## 13 BIG SLIDE-LAKE SHORE-1KM W 11493
## 14 BILL MINER CREEK-LAKE SHORE 11494
## 15 BILL MINER CREEK-LAKE SHORE-3KM W 11495
## 16 BLUE LEAD CREEK-LAKE SHORE 11496
## 17 NORTH BOISE CREEK 26776
## 18 BOTANY INLET CREEK-HEAD 1652
## 19 BOTANY INLET CREEK-OUTER 1651
## 20 BOUGHEY BAY UNNAMED CREEK #2 838
## 21 BOULDERY CREEK-LAKE SHORE 11497
## 22 BOULDERY CREEK-E-LAKE SHORE 11498
## 23 BOWLING POINT TO GOOSE POINT 11532
## 24 QUATSESE RIVER 1107
## 25 BRENNAN PARK SPAWNING CHANNEL 712
## 26 BUCK CHANNEL CREEK #8 1676
## 27 BUCK CHANNEL CREEK #5 2341
## 28 BUCK CHANNEL CREEK #1 1674
## 29 BUCK CHANNEL CREEK #7 7990641
## 30 BUCK CHANNEL CREEK #6 2651
## 31 BUCK CHANNEL CREEK #3 1675
## 32 BUCK CHANNEL CREEK #2 2342
## 33 BURNABY NARROWS CREEK-FIRST R/H 1717
## 34 BURNABY NARROWS CREEK-SECOND R/H 1718
## 35 BURNABY STRAIGHTS CREEK 1623
## 36 BUSH CREEK-LAKE SHORE 11555
## 37 CARRINGTON COVE CREEK 2076
## 38 CENTENNIAL SPAWNING CHANNEL 2532
## 39 CHEENIS LAKE CREEK 998
## 40 CHILKO SPAWNING CHANNELS 2429
## 41 CHILLIWACK/VEDDER RIVER 62
## 42 CHOKE PASS CREEKS 7990621
## 43 CHONAT LAKE CREEK 1138
## 44 CLOSE CREEKS 1321
## 45 COHO CREEK 182
## 46 CONE CREEKS 1323
## 47 COOPER INLET-FANNIE COVE CREEKS 1791
## 48 SWIFT RIVER 2457
## 49 Cross Creek 612
## 50 CROWN ZELLERBACH CREEK 1066
## 51 CRUIKSHANK POINT-LAKE SHORE W 11542
## 52 DANA CREEK #1 1599
## 53 DANA CREEK #2 1600
## 54 DANA CREEK #3 1601
## 55 DEVOE CREEK-LAKE SHORE 11517
## 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 Gossen Creek 2352
## 63 COOPER INLET-FANNIE COVE LH CREEK 2687
## 64 COOPER INLET-FANNIE COVE RH CREEK 2708
## 65 Fortune Creek 359
## 66 FOUR MILE CREEK-LAKE SHORE 11538
## 67 FRANKS CREEK-LAKE SHORE 11501
## 68 Furlong Creek 515
## 69 GOOSE POINT-LAKE SHORE 11519
## 70 GOOSE POINT-LAKE SHORE-5 KM S 11520
## 71 GRAIN CREEK-LAKE SHORE 11521
## 72 GRAY BAY CREEKS-OTHERS 7990619
## 73 GRIBBELL ISLAND CREEK 1904
## 74 KINGFISHER CREEK 1143
## 75 CHARLIE HARTIE CREEK 1507
## 76 HENDERSON LAKE CREEK 1273
## 77 HESQUIAT HARBOUR CREEK #1 2471
## 78 HESQUIAT HARBOUR CREEK #2 1347
## 79 HESQUIAT HARBOUR CREEK #3 2472
## 80 HESQUIAT HARBOUR CREEK #4 2291
## 81 Hevenor Creek 568
## 82 HLINA CREEK-LAKE SHORE 11543
## 83 HOCHSTADER BASIN CREEK 7990583
## 84 N. CREEK 856
## 85 HURRICANE POINT SHORE 11502
## 86 HUSTON INLET CREEKS 1628
## 87 HUTTON CREEK-HEAD 1609
## 88 HUTTON CREEK-L/H 1610
## 89 INDIAN CABIN CREEK-R/H 1518
## 90 RANSOM RIVER 1385
## 91 ISLAND BAY CREEKS-L/H 1622
## 92 ISLAND BAY CREEKS-R/H 1621
## 93 JOHN SANDY CREEK 206
## 94 JONES' SPAWNING CHANNEL 2481
## 95 JUNCTION CREEK-LAKE SHORE 11503
## 96 BOOMCHAIN BAY CREEK 1673
## 97 KILDIDT LAGOON CREEK #2 1788
## 98 KILLDOG CREEK-LAKE SHORE 11504
## 99 KNIGHT CREEK-LAKE SHORE 11550
## 100 Ksemamaith Creek 642
## 101 Ksga'Maal 650
## 102 Ksi Hlginx 661
## 103 Ksi Mat'In 641
## 104 Ksi Sgasginist 655
## 105 KSI SGAWBAN CREEK 3548
## 106 Ksi X'Anmas 1756
## 107 LAGINS CREEK-RH 1516
## 108 LASSITER CREEK 7990609
## 109 LEE CREEK-LAKE SHORE 11544
## 110 LIMESTONE PIONT-LAKE SHORE-S 11523
## 111 LIMESTONE PIONT-LAKE SHORE 11524
## 112 LITTLE WHITEPINE COVE CREEK #1 1332
## 113 LONG CREEK-LAKE SHORE 11526
## 114 LOST VALLEY CREEK-LAKE SHORE 26778
## 115 AHWHICHAOLTO CREEK-LOWER 1481
## 116 PARADISE SPAWNING CHANNEL-LOWER 721
## 117 LYNX CREEK-LAKE SHORE 11505
## 118 MCDOUGALL CREEK 326
## 119 MAMQUAM RIVER SPAWNING CHANNEL 715
## 120 MARSHALL INLET CREEK 1612
## 121 MARTEN CREEK-LAKE SHORE 11527
## 122 MATHESON CREEK-L/H 1614
## 123 MATHESON CREEK-R/H 1613
## 124 MCKAY COVE CREEK #1 1424
## 125 MESACHIE CREEK 2627
## 126 NORTH THOMPSON RIVER@VAVENBY 1754239945
## 127 MIKADO LAKE CREEK 1923
## 128 MOMICH RIVER-LAKE SHORE 11559
## 129 MOODY'S SPAWNING CHANNEL 722
## 130 NESTO INLET CREEK-OUTER 1546
## 131 NOBLE CREEK 1879
## 132 HAWKINS CREEK 54
## 133 NORTH ARM CREEK-RH 1523
## 134 ONYX CREEK-LAKE SHORE 11547
## 135 OPA BEACH-LAKE SHORE 11528
## 136 OWEN BAY CREEK 1125
## 137 SINMAX CREEK-LAKE SHORE 11560
## 138 PEACH CREEK SIDE CHANNEL 2537
## 139 PEEL INLET CREEK-L/H #1 1668
## 140 PEEL INLET CREEK-L/H #2 1667
## 141 PENFOLD CAMP-LAKE SHORE 11529
## 142 NORTH THOMPSON RIVER-PIG CHANNEL 719256264
## 143 POOLE INLET CREEKS 1716
## 144 QUEEST CREEK-LAKE SHORE 11539
## 145 QUESNEL LAKE EAST ARM-UNNAMED CREEK #1 2756
## 146 NORTH ARM UNNAMED COVE-LAKE SHORE 11536
## 147 Rainy Creek 1781
## 148 RIENECKER CREEK 235
## 149 RESCUE BAY CREEK 7990591
## 150 ROARING POINT-LAKE SHORE 11530
## 151 ROARING RIVER TO DECEPTION POINT-LAKE SHORE 11533
## 152 ROARING RIVER-LAKE SHORE 11531
## 153 ROCK SLIDE TO PENINSULA POINT-LAKE SHORE 11508
## 154 ROSS CREEK-LAKE SHORE 11548
## 155 SALTSPRING BAY CREEK-L/H 1521
## 156 SCOTCH CREEK-LAKE SHORE 11549
## 157 SECTION COVE CREEK-RH 1720
## 158 SECURITY INLET CREEK-L/H 1671
## 159 SECURITY INLET CREEK-R/H 1670
## 160 UPPER and LOWER SETON CHANNELS 2451
## 161 SHUSWAP LAKE-MAIN ARM-LAKE SHORE 11565
## 162 SHUSWAP LAKE-ANSTEY ARM-LAKE SHORE 11562
## 163 SHUSWAP LAKE-SEYMOUR ARM-LAKE SHORE 11563
## 164 SHUSWAP LAKE MAIN ARM-N-LAKE SHORE 11545
## 165 SHUSWAP LAKE MAIN ARM-S-LAKE SHORE 11546
## 166 SHUSWAP LAKE-SALMON ARM-LAKE SHORE 11564
## 167 SHUSWAP LAKE SALMON ARM-E-LAKE SHORE 11551
## 168 SHUSWAP LAKE-SALMON ARM-N-LAKE SHORE 11552
## 169 SHUSWAP LAKE-SALMON ARM-S-LAKE SHORE 11553
## 170 SKAAT HARBOUR CREEK-HEAD 1618
## 171 SKAAT HARBOUR CREEK-L/H 1619
## 172 SKAAT HARBOUR CREEK-R/H 1617
## 173 SLATE BAY-LAKE SHORE 1KM E 11510
## 174 SOUTH BAY CREEK #1 1301
## 175 UNNAMED CREEK NEAR SQUEAH LAKE 119
## 176 Stephens Creek 585
## 177 SURPRISE CREEKS 1629
## 178 Swan Lake Creek #2 2736
## 179 TARTU INLET CREEK-HEAD 1544
## 180 TARTU INLET CREEK-OUTER 1543
## 181 TASEKO LAKE 287
## 182 TASSE CREEK-LAKE SHORE 11537
## 183 TRACY BAY CREEK #2 2309
## 184 Ksi Sii Aks 2 652
## 185 TSUIUS CREEK-LAKE SHORE 26774
## 186 TUNO CREEK-EAST 1002
## 187 UNNAMED CREEK-LAKE SHORE 26770
## 188 UNNAMED POINT-LAKE SHORE 11512
## 189 AHWHICHAOLTO CREEK-UPPER 1480
## 190 PARADISE SPAWNING CHANNEL-UPPER 723
## 191 VANISHING CREEK-LAKE SHORE 11540
## 192 WASKO CREEK-LAKE SHORE 11534
## 193 WATT CREEK-LAKE SHORE 11535
## 194 WEAVER SPAWNING CHANNEL 2436
## 195 WEST BAY CREEK 752
## 196 WRIGHT CREEK 2745
## 197 Xnukw 635
## 198 YOHETTA CREEK 26766
## 199 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)
(populationid would be a more accurate name but we leave it
as is for now). 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.09298
## 2 East Vancouver Island & Mainland Inlets ANDERSON CREEK 2615 49.64048
## 3 East Vancouver Island & Mainland Inlets GLENORA CREEK 2624 48.74283
## 4 East Vancouver Island & Mainland Inlets KELVIN CREEK 2625 48.74980
## 5 East Vancouver Island & Mainland Inlets MESACHIE CREEK 2627 48.81603
## 6 East Vancouver Island & Mainland Inlets MYERS CREEK 2616 49.64041
## longitude cu_name_pse cuid streamid
## 1 -122.0322 Lower Fraser 701 1
## 2 -123.9876 Georgia Strait 904 2
## 3 -123.7127 Georgia Strait 904 3
## 4 -123.6892 Georgia Strait 904 4
## 5 -124.1260 Georgia Strait 904 5
## 6 -123.9886 Georgia Strait 904 6We match the locations using GFE_ID if available in
streamlocationids, and CENSUS_SITE,
Y_LAT and X_LONGT otherwise (because the
GFE_ID is missing several of the locations). In case of the
latter, the matched locations are shown below:
## 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 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 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 TAHLTAN RIVER 2199 58.00995 -130.9813
## 2 streamlocationids Tahltan River NA 58.00995 -130.9813
## [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 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 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 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 ALSEK RIVER 2324 59.44397 -137.9908
## 2 streamlocationids Alsek River NA 59.44397 -137.9908
## [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 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 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 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 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 FLANNIGAN SLOUGH 2208 58.60894 -133.5666
## 2 streamlocationids Flannigan Slough NA 58.60894 -133.5666
## [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 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 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 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 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 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 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 TUYA RIVER 2155 58.04072 -130.8514
## 2 streamlocationids Tuya River NA 58.04072 -130.8514
## [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 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 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 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 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 ALSEK RIVER 2324 59.44397 -137.9908
## 2 streamlocationids Alsek River NA 59.44397 -137.9908
## [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 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 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 KLUKSHU RIVER 2332 60.11586 -137.0362
## 2 streamlocationids Klukshu River NA 60.11586 -137.0362
## [1] ""There remains 143 unique stream (GFE_ID) and CU
(cuid) combinations without an existing
streamid (not accounting for the time series in
nuseds without a cuid):
## region GFE_ID
## 1 Central Coast 7990588
## 2 Central Coast 968
## 3 Central Coast 2692
## 4 Central Coast 7990588
## 5 Central Coast 7990588
## 6 Central Coast 2245
## 7 Central Coast 2250
## 8 East Vancouver Island & Mainland Inlets 723
## 9 East Vancouver Island & Mainland Inlets 832
## 10 East Vancouver Island & Mainland Inlets 802
## 11 East Vancouver Island & Mainland Inlets 1208
## 12 East Vancouver Island & Mainland Inlets 23735
## 13 East Vancouver Island & Mainland Inlets 54261
## 14 East Vancouver Island & Mainland Inlets 63350
## 15 East Vancouver Island & Mainland Inlets 879
## 16 East Vancouver Island & Mainland Inlets 199
## 17 East Vancouver Island & Mainland Inlets 403
## 18 East Vancouver Island & Mainland Inlets 67553
## 19 East Vancouver Island & Mainland Inlets 54261
## 20 East Vancouver Island & Mainland Inlets 63350
## 21 East Vancouver Island & Mainland Inlets 3490
## 22 East Vancouver Island & Mainland Inlets 31035
## 23 East Vancouver Island & Mainland Inlets 723
## 24 East Vancouver Island & Mainland Inlets 724
## 25 East Vancouver Island & Mainland Inlets 724
## 26 East Vancouver Island & Mainland Inlets 747
## 27 East Vancouver Island & Mainland Inlets 63350
## 28 East Vancouver Island & Mainland Inlets 2616
## 29 East Vancouver Island & Mainland Inlets 1211
## 30 East Vancouver Island & Mainland Inlets 1190
## 31 East Vancouver Island & Mainland Inlets 1174
## 32 East Vancouver Island & Mainland Inlets 1154
## 33 East Vancouver Island & Mainland Inlets 1154
## 34 East Vancouver Island & Mainland Inlets 3446
## 35 East Vancouver Island & Mainland Inlets 723
## 36 East Vancouver Island & Mainland Inlets 724
## 37 East Vancouver Island & Mainland Inlets 879
## 38 East Vancouver Island & Mainland Inlets 869
## 39 East Vancouver Island & Mainland Inlets 863
## 40 East Vancouver Island & Mainland Inlets 1146
## 41 Fraser 263
## 42 Fraser 2463
## 43 Fraser 2466
## 44 Fraser 5
## 45 Fraser 182
## 46 Fraser 52747
## 47 Fraser 2716
## 48 Fraser 11
## 49 Fraser 134
## 50 Fraser 2037
## 51 Fraser 2461
## 52 Fraser 54283
## 53 Fraser 57040
## 54 Fraser 3477
## 55 Fraser 227
## 56 Fraser 2374
## 57 Fraser 261
## 58 Fraser 33103
## 59 Fraser 2463
## 60 Fraser 2381
## 61 Fraser 2636
## 62 Fraser 287
## 63 Fraser 288
## 64 Fraser 2574
## 65 Fraser 3510
## 66 Fraser 21574
## 67 Fraser 2826
## 68 Fraser 1991
## 69 Fraser 223
## 70 Fraser 224
## 71 Fraser 26773
## 72 Fraser 227
## 73 Fraser 26771
## 74 Fraser 2434
## 75 Fraser 2396
## 76 Fraser 2398
## 77 Fraser 2405
## 78 Fraser 2761
## 79 Fraser 2485
## 80 Fraser 2753
## 81 Fraser 426
## 82 Nass 432
## 83 Nass 432
## 84 Nass 1760
## 85 Northern Transboundary 2118
## 86 Northern Transboundary 2203
## 87 Northern Transboundary 2221
## 88 Northern Transboundary 2212
## 89 Northern Transboundary 2216
## 90 Northern Transboundary 2571
## 91 Northern Transboundary 2138
## 92 Northern Transboundary 2203
## 93 Northern Transboundary 2222
## 94 Northern Transboundary 2224
## 95 Northern Transboundary 2225
## 96 Northern Transboundary 2211
## 97 Northern Transboundary 2212
## 98 Northern Transboundary 2233
## 99 Northern Transboundary 2216
## 100 Northern Transboundary 2216
## 101 Northern Transboundary 2119
## 102 Northern Transboundary 2138
## 103 Northern Transboundary 2570
## 104 Northern Transboundary 31363
## 105 Northern Transboundary 2211
## 106 Northern Transboundary 2212
## 107 Northern Transboundary 2216
## 108 Northern Transboundary 2324
## 109 Northern Transboundary 2338
## 110 Skeena 19723
## 111 Skeena 3559
## 112 Skeena 601
## 113 West Vancouver Island 11488
## 114 West Vancouver Island 11487
## 115 West Vancouver Island 1333
## 116 West Vancouver Island 11487
## 117 West Vancouver Island 11488
## 118 West Vancouver Island 2024
## 119 West Vancouver Island 55420
## 120 West Vancouver Island 55413
## 121 West Vancouver Island 2488
## 122 West Vancouver Island 2486
## 123 West Vancouver Island 2487
## 124 West Vancouver Island 1312
## 125 West Vancouver Island 1314
## 126 West Vancouver Island 7990617
## 127 West Vancouver Island 2473
## 128 West Vancouver Island 1349
## 129 West Vancouver Island 11487
## 130 West Vancouver Island 11488
## 131 West Vancouver Island 2637
## 132 West Vancouver Island 1322
## 133 West Vancouver Island 1323
## 134 West Vancouver Island 1490
## 135 West Vancouver Island 64745
## 136 West Vancouver Island 3416
## 137 West Vancouver Island 1433
## 138 Yukon 2491
## 139 Yukon 2567
## 140 Yukon 2516
## 141 Yukon 2499
## 142 Yukon 2491
## 143 Yukon 2567
## sys_nm cuid
## 1 RETURN CHANNEL CREEKS 503
## 2 BELLA COOLA RIVER 505
## 3 JENNY BAY WEST CREEK 518
## 4 RETURN CHANNEL CREEKS 608
## 5 RETURN CHANNEL CREEKS 611
## 6 NOOKLIKONNIK CREEK 609
## 7 NUSATSUM RIVER 609
## 8 PARADISE SPAWNING CHANNEL-UPPER 320
## 9 WORTLEY CREEK 326
## 10 HANSON'S CREEK 320
## 11 COWICHAN RIVER 334
## 12 NANAIMO RIVER - UPPER 334
## 13 MALCOLM CREEK 904
## 14 COLVIN CREEK 904
## 15 CARRIDEN CREEK 900
## 16 FEE CREEK 907
## 17 WHALETOWN CREEK 908
## 18 GIBSON CREEK 907
## 19 MALCOLM CREEK 907
## 20 COLVIN CREEK 908
## 21 BINGS CREEK 910
## 22 AVERILL CREEK 910
## 23 PARADISE SPAWNING CHANNEL-UPPER 921
## 24 TENDERFOOT CREEK 917
## 25 TENDERFOOT CREEK 921
## 26 SOUTH TWIN CREEK 922
## 27 COLVIN CREEK 917
## 28 MYERS CREEK 917
## 29 GOLDSTREAM RIVER 917
## 30 DEPARTURE CREEK 917
## 31 COOK CREEK 917
## 32 LITTLE RIVER 917
## 33 LITTLE RIVER 922
## 34 CYPRESS CREEK 973
## 35 PARADISE SPAWNING CHANNEL-UPPER 973
## 36 TENDERFOOT CREEK 973
## 37 CARRIDEN CREEK 971
## 38 WAHKANA BAY CREEK 971
## 39 GILFORD CREEK 971
## 40 WILLOW CREEK 973
## 41 DUNN CREEK 319
## 42 CHILCOTIN RIVER - LOWER 310
## 43 CARIBOO RIVER - UPPER 310
## 44 BOOTH CREEK 701
## 45 COHO CREEK 701
## 46 EAGLE CREEK 701
## 47 BYRNE CREEK 750
## 48 MAPLE CREEK 750
## 49 YALAKOM RIVER 749
## 50 WILLIAMS LAKE RIVER 749
## 51 NICOLA RIVER - LOWER 707
## 52 NICOLA RIVER (DOT) 707
## 53 QUILCHENA CREEK 707
## 54 ADAMS RIVER - LOWER 708
## 55 ROSS CREEK 708
## 56 PALMER CREEK 708
## 57 FENNELL CREEK 709
## 58 BLUE RIVER - LOWER 709
## 59 CHILCOTIN RIVER - LOWER 749
## 60 MINTON CREEK 749
## 61 TASEKO RIVER 749
## 62 TASEKO LAKE 749
## 63 ELKIN CREEK 749
## 64 GASPARD CREEK 710
## 65 BLUE CREEK 715
## 66 BOWRON RIVER - LOWER 735
## 67 POMEROY CREEK 735
## 68 SUS CREEK 735
## 69 MOMICH RIVER 738
## 70 CAYENNE CREEK 739
## 71 HLINA CREEK 739
## 72 ROSS CREEK 738
## 73 FOUR MILE CREEK 739
## 74 LOFTUS CREEK 739
## 75 RAFT CREEK 728
## 76 WINKLEY CREEK 728
## 77 AMOS CREEK 728
## 78 TARNEZELL CREEK 732
## 79 MIDDLE RIVER 731
## 80 BUTTERFIELD CREEK 732
## 81 NANCUT CREEK 731
## 82 WIMINASIK LAKE SYSTEM 402
## 83 WIMINASIK LAKE SYSTEM 421
## 84 ILLIANCE RIVER 426
## 85 STIKINE RIVER 1011
## 86 TAKU RIVER 1008
## 87 KOWATUA CREEK 1008
## 88 TATSATUA CREEK 1008
## 89 NAKINA RIVER 1007
## 90 KATETE RIVER 1017
## 91 PORCUPINE RIVER 1017
## 92 TAKU RIVER 1015
## 93 LITTLE TRAPPER LAKE 1015
## 94 NAHLIN RIVER 1015
## 95 DUDIDONTU RIVER 1015
## 96 TATSATUA CREEK 1015
## 97 TATSATUA CREEK 1015
## 98 HACKETT RIVER 1015
## 99 NAKINA RIVER 1019
## 100 NAKINA RIVER 1020
## 101 KATETE RIVER 1023
## 102 PORCUPINE RIVER 1023
## 103 VERRETT SLOUGHS 1023
## 104 TAHLTAN LAKE 1026
## 105 TATSATUA CREEK 1029
## 106 TATSATUA CREEK 1023
## 107 NAKINA RIVER 1023
## 108 ALSEK RIVER 1021
## 109 VILLAGE CREEK 1021
## 110 SKEENA RIVER - NORTH 210
## 111 STEPHENS CREEK 187
## 112 MORRISON CREEK 189
## 113 SPROAT RIVER BELOW FALLS 328
## 114 STAMP RIVER BELOW FALLS 328
## 115 WHITEPINE COVE CREEK 328
## 116 STAMP RIVER BELOW FALLS 978
## 117 SPROAT RIVER BELOW FALLS 978
## 118 DRAW CREEK 978
## 119 ENGLISH COVE CREEK 978
## 120 COHO CREEK 978
## 121 MURIEL LAKE CREEK 978
## 122 MURIEL S1 CREEK 978
## 123 CLAYOQUOT RIVER 978
## 124 COLD CREEK 978
## 125 ANGORA CREEK 978
## 126 KENNEDY LAKE FEEDER STREAMS 978
## 127 HESQUIAT POINT CREEK 978
## 128 SATCHIE CREEK 978
## 129 STAMP RIVER BELOW FALLS 914
## 130 SPROAT RIVER BELOW FALLS 914
## 131 PACILTH CREEK 914
## 132 SHARP CREEK 915
## 133 CONE CREEKS 915
## 134 RUSSELL CREEK 919
## 135 ATNARKO LAKES 528
## 136 GREAT CENTRAL LAKE 952
## 137 EAST CREEK 974
## 138 YUKON RIVER 1207
## 139 LOWER YUKON RIVER 1207
## 140 BIG SALMON RIVER 1204
## 141 TESLIN RIVER 1211
## 142 YUKON RIVER 1214
## 143 LOWER YUKON RIVER 1214
## cu_name_pse streamid
## 1 Spiller-Fitz-Hugh-Burke NA
## 2 Bella Coola River-Late NA
## 3 Bella Coola-Dean Rivers NA
## 4 Hecate Lowlands (even) NA
## 5 Hecate Strait-Lowlands (odd) NA
## 6 Hecate Strait-Fjords (even) NA
## 7 Hecate Strait-Fjords (even) NA
## 8 Southern Mainland-Georgia Strait (Fall x-1) NA
## 9 Southern Mainland-Southern Fjords (Fall x-1) NA
## 10 Southern Mainland-Georgia Strait (Fall x-1) NA
## 11 East Vancouver Island-Georgia Strait (Summer 4-1) NA
## 12 East Vancouver Island-Georgia Strait (Summer 4-1) NA
## 13 Georgia Strait NA
## 14 Georgia Strait NA
## 15 Southern Coastal Streams NA
## 16 Howe Sound-Burrard Inlet NA
## 17 Georgia Strait Mainland NA
## 18 Howe Sound-Burrard Inlet NA
## 19 Howe Sound-Burrard Inlet NA
## 20 Georgia Strait Mainland NA
## 21 East Vancouver Island-Georgia Strait NA
## 22 East Vancouver Island-Georgia Strait NA
## 23 East Howe Sound-Burrard Inlet (odd) NA
## 24 Georgia Strait (even) NA
## 25 East Howe Sound-Burrard Inlet (odd) NA
## 26 Georgia Strait (odd) NA
## 27 Georgia Strait (even) NA
## 28 Georgia Strait (even) NA
## 29 Georgia Strait (even) NA
## 30 Georgia Strait (even) NA
## 31 Georgia Strait (even) NA
## 32 Georgia Strait (even) NA
## 33 Georgia Strait (odd) NA
## 34 East Vancouver Island & Georgia Strait (river-type) NA
## 35 East Vancouver Island & Georgia Strait (river-type) NA
## 36 East Vancouver Island & Georgia Strait (river-type) NA
## 37 Southern Fjords (river-type) NA
## 38 Southern Fjords (river-type) NA
## 39 Southern Fjords (river-type) NA
## 40 East Vancouver Island & Georgia Strait (river-type) NA
## 41 North Thompson River (Summer 5-2) NA
## 42 Middle Fraser River (Spring 5-2) NA
## 43 Middle Fraser River (Spring 5-2) NA
## 44 Lower Fraser NA
## 45 Lower Fraser NA
## 46 Lower Fraser NA
## 47 Lower Fraser NA
## 48 Lower Fraser NA
## 49 Interior Fraser NA
## 50 Interior Fraser NA
## 51 Lower Thompson NA
## 52 Lower Thompson NA
## 53 Lower Thompson NA
## 54 South Thompson NA
## 55 South Thompson NA
## 56 South Thompson NA
## 57 North Thompson NA
## 58 North Thompson NA
## 59 Interior Fraser NA
## 60 Interior Fraser NA
## 61 Interior Fraser NA
## 62 Interior Fraser NA
## 63 Interior Fraser NA
## 64 Fraser River (odd) NA
## 65 Pitt-Early Summer NA
## 66 Bowron-Early Summer NA
## 67 Bowron-Early Summer NA
## 68 Bowron-Early Summer NA
## 69 Shuswap-Early Summer (cyclic) NA
## 70 Shuswap-Late (cyclic) NA
## 71 Shuswap-Late (cyclic) NA
## 72 Shuswap-Early Summer (cyclic) NA
## 73 Shuswap-Late (cyclic) NA
## 74 Shuswap-Late (cyclic) NA
## 75 Quesnel-Summer (cyclic) NA
## 76 Quesnel-Summer (cyclic) NA
## 77 Quesnel-Summer (cyclic) NA
## 78 Takla-Trembleur-Early Stuart (cyclic) NA
## 79 Takla-Trembleur-Stuart-Summer (cyclic) NA
## 80 Takla-Trembleur-Early Stuart (cyclic) NA
## 81 Takla-Trembleur-Stuart-Summer (cyclic) NA
## 82 Upper Nass NA
## 83 Damdochax NA
## 84 Lower Nass-Portland (river-type) NA
## 85 Stikine-Late Timing NA
## 86 Taku-Late Timing NA
## 87 Taku-Late Timing NA
## 88 Taku-Late Timing NA
## 89 Taku-Mid Timing NA
## 90 Lower Stikine NA
## 91 Lower Stikine NA
## 92 Taku-Late Timing NA
## 93 Taku-Late Timing NA
## 94 Taku-Late Timing NA
## 95 Taku-Late Timing NA
## 96 Taku-Late Timing NA
## 97 Taku-Late Timing NA
## 98 Taku-Late Timing NA
## 99 Transboundary Fjords (even) NA
## 100 Transboundary Fjords (odd) NA
## 101 Northern Transboundary Fjords (river-type) NA
## 102 Northern Transboundary Fjords (river-type) NA
## 103 Northern Transboundary Fjords (river-type) NA
## 104 Tahltan NA
## 105 Tatsamenie NA
## 106 Northern Transboundary Fjords (river-type) NA
## 107 Northern Transboundary Fjords (river-type) NA
## 108 Alsek (river-type) NA
## 109 Alsek (river-type) NA
## 110 Lower Skeena NA
## 111 Stephens NA
## 112 Tahlo/Morrison NA
## 113 West Vancouver Island-South (Fall x-1) NA
## 114 West Vancouver Island-South (Fall x-1) NA
## 115 West Vancouver Island-South (Fall x-1) NA
## 116 Southwest & West Vancouver Island NA
## 117 Southwest & West Vancouver Island NA
## 118 Southwest & West Vancouver Island NA
## 119 Southwest & West Vancouver Island NA
## 120 Southwest & West Vancouver Island NA
## 121 Southwest & West Vancouver Island NA
## 122 Southwest & West Vancouver Island NA
## 123 Southwest & West Vancouver Island NA
## 124 Southwest & West Vancouver Island NA
## 125 Southwest & West Vancouver Island NA
## 126 Southwest & West Vancouver Island NA
## 127 Southwest & West Vancouver Island NA
## 128 Southwest & West Vancouver Island NA
## 129 West Vancouver Island NA
## 130 West Vancouver Island NA
## 131 West Vancouver Island NA
## 132 Clayoquot NA
## 133 Clayoquot NA
## 134 Northwest Vancouver Island (even) NA
## 135 South Atnarko Lakes NA
## 136 Great Central NA
## 137 NW Vancouver Island (river-type) NA
## 138 Northern Yukon NA
## 139 Northern Yukon NA
## 140 Middle Yukon NA
## 141 Upper Yukon NA
## 142 North Yukon NA
## 143 North 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
## [1] "File imported: 2_nuseds_cuid_streamid_2026-03-12.csv ; Date modified: 2026-03-12 16:44:19.196857"## [1] "File imported: All Areas NuSEDS_20251103.csv ; Date modified: 2026-01-08 09:04:18.530449"## [1] "File imported: all_areas_nuseds_2025-02-21.csv ; Date modified: 2025-02-21 09:28:25.445271"## [1] "File imported: conservation_unit_system_sites_2025-02-20.csv ; Date modified: 2025-02-20 15:55:05.475634"Import the previous clean NuSEDS dataset, exported in 2025-04-15.
## [1] "There are 37 more time series in the updated cleaned NuSEDS dataset"6.1 Check the locations
## [1] "There are 29 new locations in the updated NuSEDS:"
## region sys_nm GFE_ID
## 5 Central Coast RETURN CHANNEL CREEKS 7990588
## 7 East Vancouver Island & Mainland Inlets MALCOLM CREEK 54261
## 8 East Vancouver Island & Mainland Inlets COLVIN CREEK 63350
## 9 East Vancouver Island & Mainland Inlets FEE CREEK 199
## 14 East Vancouver Island & Mainland Inlets GIBSON CREEK 67553
## 15 East Vancouver Island & Mainland Inlets BINGS CREEK 3490
## 16 East Vancouver Island & Mainland Inlets AVERILL CREEK 31035
## 6 Fraser BOOTH CREEK 5
## 10 Fraser NICOLA RIVER - LOWER 2461
## 11 Fraser NICOLA RIVER (DOT) 54283
## 12 Fraser ADAMS RIVER - LOWER 3477
## 13 Fraser BLUE RIVER - LOWER 33103
## 17 Fraser BOWRON RIVER - LOWER 21574
## 4 Nass WIMINASIK LAKE SYSTEM 432
## 19 Northern Transboundary TAHLTAN LAKE 31363
## 3 Skeena SKEENA RIVER - NORTH 19723
## 18 Skeena STEPHENS CREEK 3559
## 1 West Vancouver Island SPROAT RIVER BELOW FALLS 11488
## 2 West Vancouver Island STAMP RIVER BELOW FALLS 11487
## Y_LAT X_LONGT
## 5 52.27628 -128.1352
## 7 49.41704 -123.6294
## 8 49.47871 -123.8859
## 9 50.06878 -123.3425
## 14 49.40606 -123.4992
## 15 48.79351 -123.7057
## 16 48.80107 -123.7098
## 6 49.23388 -122.8543
## 10 50.14528 -121.0219
## 11 50.42445 -121.3157
## 12 50.89386 -119.5506
## 13 52.10461 -119.2796
## 17 54.05074 -121.8495
## 4 56.48975 -128.0494
## 19 57.97601 -131.5830
## 3 54.50102 -128.6369
## 18 55.75964 -128.5361
## 1 49.29007 -124.9023
## 2 49.32792 -124.9119## [1] "There are 2 locations in the previous cleaned NuSEDS not in the updated one:"
## region sys_nm GFE_ID Y_LAT X_LONGT
## 1 Haida Gwaii WINDY BAY CREEK 1709 52.69261 -131.4581
## 2 Skeena DENISE CREEK 1735 54.28488 -130.1464
## 3 Skeena SHAWATLAN RIVER 1736 54.32419 -130.2554## [1] "The following time series with these locations were removed for the following reasons:"
## IndexId GFE_ID dataset
## 4465 CO_46602 2746 NUSEDS
## 4512 SX_3416 2746 NUSEDS
## 4514 CO_46632 2746 NUSEDS
## comment
## 4465 Series merged by summing to series CO_46632 & GFE_ID = 2746 of the same CU: CU_NAME: NORTH THOMPSON
## 4512 Series not in CUSS, merged to series SX_3416 & GFE_ID = 261 because same POP_ID and locations have the same coordinates.
## 4514 Series merged to series CO_46632 & GFE_ID = 2746 because same POP_ID and locations have the same coordinates.
## [1] "The following locations were in the last raw NUSEDS dataset but not in the new raw NUSEDS dataset:"
## GFE_ID WATERBODY SPECIES
## 25086 64739 CAMPBELL RIVER Chinook
## POPULATION POP_ID
## 25086 Little Campbell River (Boundary Bay) Chinook 7808
## [1] "So these locations were removed by DFO."
## [1] "No problen here :-)"6.2 Check the populations
## [1] "There are 34 new IndexId (POP_ID) in the updated NuSEDS:"
## region IndexId
## 5 Central Coast CM_45931
## 8 Central Coast CM_51772
## 16 Central Coast PKE_45930
## 17 Central Coast PKO_45930
## 21 Central Coast PKE_3167
## 22 Central Coast PKE_3168
## 3 East Vancouver Island & Mainland Inlets CN_40024
## 4 East Vancouver Island & Mainland Inlets CN_7751
## 6 East Vancouver Island & Mainland Inlets CM_7827
## 7 East Vancouver Island & Mainland Inlets CM_7801
## 9 East Vancouver Island & Mainland Inlets CO_959
## 10 East Vancouver Island & Mainland Inlets CO_7828
## 11 East Vancouver Island & Mainland Inlets CO_7826
## 12 East Vancouver Island & Mainland Inlets CO_7802
## 13 East Vancouver Island & Mainland Inlets CO_7730
## 14 East Vancouver Island & Mainland Inlets CO_7759
## 18 East Vancouver Island & Mainland Inlets PKO_50154
## 19 East Vancouver Island & Mainland Inlets PKE_7824
## 20 East Vancouver Island & Mainland Inlets PKE_180
## 23 East Vancouver Island & Mainland Inlets PKE_40049
## 24 East Vancouver Island & Mainland Inlets PKE_51474
## 25 East Vancouver Island & Mainland Inlets PKE_51314
## 26 East Vancouver Island & Mainland Inlets PKE_53044
## 27 East Vancouver Island & Mainland Inlets PKO_53044
## 29 Fraser SX_46279
## 30 Fraser SX_7823
## 31 Fraser SX_7490
## 2 Nass CN_7834
## 33 Nass SX_7833
## 34 Nass SX_7835
## 32 Skeena SX_7491
## 1 West Vancouver Island CN_3320
## 15 West Vancouver Island CO_41343
## 28 West Vancouver Island PKE_54793433
## POPULATION cuid
## 5 Return Channel Creeks (Bella Bella) Chum 503
## 8 Bella Coola River System (Bella Coola) Chum Run 2 505
## 16 Return Channel Creeks (Bella Bella) Pink 608
## 17 Return Channel Creeks (Bella Bella) Pink 611
## 21 Nooklikonnik Creek (Bella Coola) Pink 609
## 22 Nusatsum River (Bella Coola) Pink 609
## 3 Cowichan River Fall Chinook 322
## 4 Cowichan River (Cowichan) Summer Chinook 334
## 6 Malcolm Creek Chum 904
## 7 Colvin Creek (Pender Harbour) Chum 904
## 9 Fee Creek (Squamish) Coho Run 1 907
## 10 Gibson Creek Coho 907
## 11 Malcolm Creek Coho 907
## 12 Colvin Creek (Pender Harbour) Coho 908
## 13 Bings Creek (Cowichan) Coho 910
## 14 Averill Creek (Cowichan) Coho 910
## 18 South Twin Creek (Vancouver) Pink Run 1 922
## 19 Colvin Creek (Pender Harbour) Pink 917
## 20 Myers Creek (Pender Harbour) Pink Run 1 917
## 23 Goldstream River (Victoria/Saanich) Pink 917
## 24 Departure Creek (Nanaimo) Pink Run 1 917
## 25 Cook Creek Pink 917
## 26 Little River (Comox) Pink Run 1 917
## 27 Little River (Comox) Pink Run 1 922
## 29 Cayenne Creek (Clearwater) Late Sockeye 739
## 30 Ormond Creek (Prince George) Early Summer Sockeye 753
## 31 Middle River Sockeye 731
## 2 Whiminasik Lake System (Upper Nass) Chinook 402
## 33 Whiminaski Lake System (Upper Nass) Sockeye 421
## 34 Illiance River (Lower Nass) Sockeye 426
## 32 Stephens Creek Sockeye 187
## 1 Lower Stamp River Chinook 328
## 15 Gold River Fall Coho 914
## 28 Dominic Creek (Quatsino Sound) Pink Run 1 919
## cu_name_pse
## 5 Spiller-Fitz-Hugh-Burke
## 8 Bella Coola River-Late
## 16 Hecate Lowlands (even)
## 17 Hecate Strait-Lowlands (odd)
## 21 Hecate Strait-Fjords (even)
## 22 Hecate Strait-Fjords (even)
## 3 East Vancouver Island-Cowichan and Koksilah (Fall x-1)
## 4 East Vancouver Island-Georgia Strait (Summer 4-1)
## 6 Georgia Strait
## 7 Georgia Strait
## 9 Howe Sound-Burrard Inlet
## 10 Howe Sound-Burrard Inlet
## 11 Howe Sound-Burrard Inlet
## 12 Georgia Strait Mainland
## 13 East Vancouver Island-Georgia Strait
## 14 East Vancouver Island-Georgia Strait
## 18 Georgia Strait (odd)
## 19 Georgia Strait (even)
## 20 Georgia Strait (even)
## 23 Georgia Strait (even)
## 24 Georgia Strait (even)
## 25 Georgia Strait (even)
## 26 Georgia Strait (even)
## 27 Georgia Strait (odd)
## 29 Shuswap-Late (cyclic)
## 30 Fraser-Early Summer
## 31 Takla-Trembleur-Stuart-Summer (cyclic)
## 2 Upper Nass
## 33 Damdochax
## 34 Lower Nass-Portland (river-type)
## 32 Stephens
## 1 West Vancouver Island-South (Fall x-1)
## 15 West Vancouver Island
## 28 Northwest Vancouver Island (even)## [1] "There are 12 IndexId (POP_ID) in the previous cleaned NuSEDS not in the updated one:"
## region IndexId
## 10 Central Coast CO_50271
## 16 Central Coast SX_44055
## 17 Central Coast SX_44060
## 1 East Vancouver Island & Mainland Inlets CM_49650
## 2 East Vancouver Island & Mainland Inlets CM_49660
## 3 East Vancouver Island & Mainland Inlets CM_52631
## 4 East Vancouver Island & Mainland Inlets CM_40181
## 5 East Vancouver Island & Mainland Inlets CM_40141
## 6 East Vancouver Island & Mainland Inlets CM_40211
## 7 Haida Gwaii CM_43288
## 14 Nass SX_48284
## 15 Nass SX_48289
## 8 Skeena CO_48545
## 9 Skeena CO_48550
## 11 Skeena PKE_48521
## 12 Skeena PKO_48521
## 13 Skeena SX_49184
## 18 West Vancouver Island SX_41825
## 19 West Vancouver Island SX_41835
## 20 West Vancouver Island SX_41855
## POPULATION cuid
## 10 Kitlope River (Kitimat-Butedale) Coho 523
## 16 Eagle Creek (Kitimat-Butedale) Sockeye 615
## 17 Treneman Creek (Kitimat-Butedale) Sockeye 598
## 1 Quashella River (Port Hardy) Chum Run 1 900
## 2 Pack Lake Creek (Port Hardy) Chum Run 1 900
## 3 Nimpkish River (Alert Bay) Chum Run 1 903
## 4 Charters River Chum 904
## 5 Lannon Creek Chum 904
## 6 Kirby Creek Chum 904
## 7 Windy Bay Creek (Sandspit) Chum 801
## 14 Tchitin River (Upper Nass) Sockeye 427
## 15 Brown Bear Creek (Upper Nass) Sockeye 427
## 8 Magar Creek (Terrace) Coho 202
## 9 Kadeen Creek (Terrace) Coho 202
## 11 Kwinitsa Creek (Terrace) Pink 219
## 12 Kwinitsa Creek (Terrace) Pink 209
## 13 Morice River (Smithers) Sockeye 185
## 18 Narrowgut Creek Sockeye 972
## 19 Amai Creek Sockeye 972
## 20 Kaouk River Sockeye 972
## cu_name_pse
## 10 Northern Coastal Streams
## 16 Northern Coastal Streams (river-type)
## 17 Treneman Creek
## 1 Southern Coastal Streams
## 2 Southern Coastal Streams
## 3 Northeast Vancouver Island
## 4 Georgia Strait
## 5 Georgia Strait
## 6 Georgia Strait
## 7 East Haida Gwaii
## 14 Upper Nass River (river-type)
## 15 Upper Nass River (river-type)
## 8 Lower Skeena
## 9 Lower Skeena
## 11 Nass-Skeena Estuary (even)
## 12 Lower Skeena River (odd)
## 13 Morice/Atna
## 18 West Vancouver Island (river-type)
## 19 West Vancouver Island (river-type)
## 20 West Vancouver Island (river-type)## [1] "The following time series with these IndexId/POP_ID were removed for the following reasons:"
## IndexId GFE_ID dataset
## 207 CN_40063 1212 NUSEDS
## 4442 CN_3324 11486 NUSEDS
## 4449 SX_46023 298 NUSEDS
## 4451 CN_40023 1208 NUSEDS
## 4453 CO_41342 1358 NUSEDS
## 4467 CM_47928 15 NUSEDS
## 4519 CO_45152 2211 NUSEDS
## comment
## 207 Only NAs for MAX_ESTIMATE
## 4442 The one data point was merged to series CN_3306 & GFE_ID = 11486 as it is the same CU: CU_NAME: WEST VANCOUVER ISLAND-SOUTH_FA_0.x
## 4449 Series merged by summing to series SX_7823 & GFE_ID = 298 of the same CU: CU_NAME: FRASER-EARLY SUMMER TIMING
## 4451 Series merged by summing to series CN_40024 & GFE_ID = 1208 of the same CU: CU_NAME: EAST VANCOUVER ISLAND-COWICHAN AND KOKSILAH_FA_0.x
## 4453 Series merged by summing to series CO_41343 & GFE_ID = 1358 of the same CU: CU_NAME: WEST VANCOUVER ISLAND
## 4467 Series merged by summing to series CM_47925 & GFE_ID = 15 of the same CU: CU_NAME: LOWER FRASER
## 4519 Manual correction: CO_45152 & 2211 --> CO_45154 & 2211 year <= 1994, rest of points deleted
## [1] "The following IndexId/POP_ID were in the last raw NUSEDS dataset but not in the new raw NUSEDS dataset:"
## SPECIES POP_ID POPULATION GFE_ID
## 25086 Chinook 7808 Little Campbell River (Boundary Bay) Chinook 64739
## WATERBODY
## 25086 CAMPBELL RIVER
## [1] "So these locations were removed by DFO."
## [1] "NEED TO INVESTIGATE WHY THOSE LOCATIONS ARE NOT IN THE NEW DATASET:"
## [1] "SX_45452" "SX_49354"6.3 Check the time series
6.3.1 Time series in new dataset only
There are 54 time series only found in the updated NuSEDS. We show these time series below with explanation in figure or below it.
## [1] "For series CN_3306 - 11488: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CN_3320 - 11487: CU found"
## [1] "For series CN_46841 - 285: CU found"
## [1] "For series CN_46842 - 2463: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CN_46892 - 2466: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CN_48448 - 19723: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CN_7834 - 432: CU found"
## [1] "For series CN_40024 - 1208: it was previously:Series merged by summing to series CN_40023 & GFE_ID = 1208 of the same CU: EAST VANCOUVER ISLAND-COWICHAN AND KOKSILAH_FA_0.x"
## [1] "For series CN_7751 - 1208: it was previously:Not merged to alternative series IndexId = CN_40023 or CN_40024 & GFE_ID = 1208 because of his Summer timing (vs. fall)"
## [1] "For series CM_3305 - 11487: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CM_3305 - 11488: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CM_45931 - 7990588: CU found"
## [1] "For series CM_47907 - 5: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CM_47925 - 15: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CM_7827 - 54261: CU found"
## [1] "For series CM_7801 - 63350: CU found"
## [1] "For series CM_51772 - 968: it was previously:Series merged by summing to series CM_51771 & GFE_ID = 968 of the same CU: BELLA COOLA RIVER-LATE"
## [1] "For series CO_3303 - 11487: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CO_3303 - 11488: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CO_959 - 199: CU found"
## [1] "For series CO_46170 - 2461: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series CO_46170 - 54283: it was previously:Series not in CUSS, removed because no coordinates and unknow meaning of 'DOT'; only two data points; not merged to alternative series IndexId = CO_46170 & GFE_ID = 213"
## [1] "For series CO_46240 - 3477: it was previously:Series not in CUSS, merged to alternative series IndexId = CO_46240 & GFE_ID = 220 because almost same coordinates"
## [1] "For series CO_46632 - 261: it was previously:Series not in CUSS, merged to series CO_46632 & GFE_ID = 2746"
## [1] "For series CO_46795 - 33103: it was previously:Series not in CUSS, merged to series CO_46795 & GFE_ID = 281"
## [1] "NOT SURE WHY IT APPEARS NOW AND NOT PREVIOUSLY"
## [1] "For series CO_7828 - 67553: CU found"
## [1] "For series CO_7826 - 54261: CU found"
## [1] "For series CO_7802 - 63350: CU found"
## [1] "For series CO_7730 - 3490: CU found"
## [1] "For series CO_7759 - 31035: CU found"
## [1] "For series CO_41343 - 1358: it was previously:Series merged by summing to series CO_41342 & GFE_ID = 1358 of the same CU: WEST VANCOUVER ISLAND"
## [1] "For series PKE_45930 - 7990588: CU found"
## [1] "For series PKO_45930 - 7990588: CU found"
## [1] "For series PKO_50154 - 747: CU found"
## [1] "For series PKE_7824 - 63350: CU found"
## [1] "For series PKE_180 - 2616: CU found"
## [1] "For series PKE_3167 - 2245: CU found"
## [1] "For series PKE_3168 - 2250: CU found"
## [1] "For series PKE_40049 - 1211: it was previously:Only NAs for MAX_ESTIMATE"
## [1] "For series PKE_51474 - 1190: CU found"
## [1] "For series PKE_51314 - 1174: CU found"
## [1] "For series PKE_53044 - 1154: CU found"
## [1] "For series PKO_53044 - 1154: CU found"
## [1] "For series PKE_54793433 - 1490: CU found"
## [1] "For series SX_47954 - 21: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series SX_47419 - 21574: FULL_CU_IN already in CUSS (so it is the IndexId & GFE_ID that in not in CUSS)"
## [1] "For series SX_46279 - 224: CU found: More than one CU layer: Shuswap Complex-Early Summer Timing; Shuswap Complex-Late Timing; Momich-Early summer; Adams-Early Summer; CU selected: Shuswap Complex-Late Timing"
## [1] "For series SX_7823 - 298: CU found: More than one CU layer: Francois/Fraser-Summer Timing; Fraser_Early Summer<<Extirpated>>; CU selected: Fraser_Early Summer<<Extirpated>>"
## [1] "For series SX_7490 - 2485: CU found: More than one CU layer: Takla/Trembleur/Stuart-Summer Timing; Takla/Trembleur-Early Stuart Timing; CU selected: Takla/Trembleur/Stuart-Summer Timing"
## [1] "For series SX_7491 - 3559: CU found: More than one CU layer: Skeena River; Stephens; CU selected: Stephens"
## [1] "For series SX_7833 - 432: CU found: More than one CU layer: Upper Nass River; Damdochax/Winimasik; CU selected: Damdochax/Winimasik"
## [1] "NOT SURE WHY IT APPEARS NOW AND NOT PREVIOUSLY"
## [1] "For series SX_7835 - 1760: CU found"6.3.2 Time series in old dataset only
There are 17 time series only found in the previous NuSEDS:
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4467 CM_47928 15 NUSEDS
## comment
## 4467 Series merged by summing to series CM_47925 & GFE_ID = 15 of the same CU: CU_NAME: LOWER FRASER
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4442 CN_3324 11486 NUSEDS
## comment
## 4442 The one data point was merged to series CN_3306 & GFE_ID = 11486 as it is the same CU: CU_NAME: WEST VANCOUVER ISLAND-SOUTH_FA_0.x
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4445 CN_3333 1194 NUSEDS
## comment
## 4445 Series merged by summing to series CN_51518 & GFE_ID = 1194 of the same CU: CU_NAME: EAST VANCOUVER ISLAND-GEORGIA STRAIT_SU_0.3
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4451 CN_40023 1208 NUSEDS
## comment
## 4451 Series merged by summing to series CN_40024 & GFE_ID = 1208 of the same CU: CU_NAME: EAST VANCOUVER ISLAND-COWICHAN AND KOKSILAH_FA_0.x
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset comment
## 207 CN_40063 1212 NUSEDS Only NAs for MAX_ESTIMATE
## [1] "We changed the references of two time series to CN_46842 - 285 in the previous update, which we did not in this update:"
## IndexId GFE_ID dataset comment
## 4425 CN_46842 2463 NUSEDS Alternative series for CN_46842 & GFE_ID = 285
## 4426 CN_46841 285 NUSEDS Alternative series for CN_46842 & GFE_ID = 285
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4517 CN_46892 290 NUSEDS
## comment
## 4517 Merged to series CN_46892 & GFE_ID = 2466 with which 3 data points were duplicated; one was duplicated with CN_46891 & GFE_ID = 290
## [1] "Probably DFO either removed the series or updated the POP_ID or GFE_ID."
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4453 CO_41342 1358 NUSEDS
## comment
## 4453 Series merged by summing to series CO_41343 & GFE_ID = 1358 of the same CU: CU_NAME: WEST VANCOUVER ISLAND
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4519 CO_45152 2211 NUSEDS
## comment
## 4519 Manual correction: CO_45152 & 2211 --> CO_45154 & 2211 year <= 1994, rest of points deleted
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4514 CO_46632 2746 NUSEDS
## comment
## 4514 Series merged to series CO_46632 & GFE_ID = 2746 because same POP_ID and locations have the same coordinates.
## [1] "We changed the references of one time (PKE_54793433 - 1490) series to PKE_42409 - 1490 in the previous update, which we did not in this update:"
## [1] IndexId GFE_ID dataset comment
## <0 rows> (or 0-length row.names)
## [1] "For some unexplained reasons the reference is not in series_removed_old despite the previous code clearly execute the change... Oh well."
## [1] "Probably DFO either removed the series or updated the POP_ID or GFE_ID."
## [1] "The reference of the series was changed during the cleaning process:"
## [1] "BUT it is not in series_removed_new --> need to check the code to add it."
## [1] "The reference of the series was changed during the cleaning process:"
## IndexId GFE_ID dataset
## 4449 SX_46023 298 NUSEDS
## comment
## 4449 Series merged by summing to series SX_7823 & GFE_ID = 298 of the same CU: CU_NAME: FRASER-EARLY SUMMER TIMING
## [1] "The reference of the series was changed during the cleaning process:"
## [1] "BUT it is not in series_removed_new --> need to check the code to add it."
## [1] "We changed the references of one time (SX_47954 - 21) series to SX_7763 - 21 in the previous update, which we did not in this update:"
## IndexId GFE_ID dataset comment
## 4427 SX_47954 21 NUSEDS Alternative series for SX_7763 & GFE_ID = 21END