The goal of the script is to associate each population (defined by
the fields POP_ID = IndexId, the latter also
specifying the species acronym) in the cleaned NuSEDS
dataset (i.e., NuSEDS_escapement_data_collated_DATE.csv) to the
conservation unit identidication number cuid, as defined in
the Pacific Salmon explorer (PSE). The cleaning procedure
is coded in the script 1_nuseds_collation.rmd and is visible in
1_nuseds_collation.html.
Import the latest nuseds_cuid_streamid.csv dataset with the following decisions made concerning zeros:
## [1] "Time series only composed of NAs AND/OR zeros were removed from NUSEDS in the early cleaning process in 1_nuseds_collation.rmd."## [1] "Zeros were replaced by NAs in the late cleaning process in 1_nuseds_collation.rmd."The conservationunits_decoder.csv dataset is imported.
Import the streamlocationids.csv to access the location names, coordinates and identification number for maintaining consistency.
## [1] "Date last modification of streamlocationids.csv: 2025-03-18 14:18:59.444315"## region sys_nm GFE_ID latitude longitude
## 1 Fraser HOPEDALE SLOUGH 67 49.09193 -122.0348
## 2 Vancouver Island & Mainland Inlets ANDERSON CREEK 2615 49.63934 -123.9835
## 3 Vancouver Island & Mainland Inlets GLENORA CREEK 2624 48.74320 -123.7102
## 4 Vancouver Island & Mainland Inlets KELVIN CREEK 2625 48.74925 -123.6891
## 5 Vancouver Island & Mainland Inlets MESACHIE CREEK 2627 48.81571 -124.1253
## 6 Vancouver Island & Mainland Inlets MYERS CREEK 2616 49.64093 -123.9865
## cu_name_pse cuid streamid
## 1 Lower Fraser 701 1
## 2 Georgia Strait 904 2
## 3 Georgia Strait 904 3
## 4 Georgia Strait 904 4
## 5 Georgia Strait 904 5
## 6 Georgia Strait 904 6The DFO file of the stream locations and coordinates (emailed from Wu
Zhipeng, DFO, 09/04/2024) is imported. The columns NME and
ID correspond to SYSTEM_SITE and
GFE_ID in NuSEDS, respectively.
The spawner survey data for Northern Transboundary (TBR) is imported:
## [1] "File imported: dataset2_spawner-surveys_Transboundary_2025-04-11.csv ; Date modified: 2025-04-11 11:39:58"## region species_name cuid
## 1 Northern Transboundary Chinook 1004
## 2 Northern Transboundary Chinook 1010
## 3 Northern Transboundary Chinook 1011
## 4 Northern Transboundary Chinook 1006
## 5 Northern Transboundary Chinook 1008
## 6 Northern Transboundary Chinook 1007
## 7 Northern Transboundary Chinook 1005
## 8 Northern Transboundary Chum 1001
## 9 Northern Transboundary Coho 1013
## 10 Northern Transboundary Coho 1017
## 11 Northern Transboundary Coho 1015
## 12 Northern Transboundary Coho 1035
## 13 Northern Transboundary Coho 1034
## 14 Northern Transboundary Lake sockeye 1039
## 15 Northern Transboundary Lake sockeye 1038
## 16 Northern Transboundary Lake sockeye 1029
## 17 Northern Transboundary Lake sockeye 1025
## 18 Northern Transboundary Lake sockeye 1036
## 19 Northern Transboundary Lake sockeye 1026
## 20 Northern Transboundary Lake sockeye 1033
## 21 Northern Transboundary Lake sockeye 1027
## 22 Northern Transboundary Lake sockeye 1028
## 23 Northern Transboundary Pink (even) 1019
## 24 Northern Transboundary Pink (odd) 1020
## 25 Northern Transboundary River sockeye 1021
## 26 Northern Transboundary River sockeye 1023
## 27 Northern Transboundary Steelhead 1081
## cu_name_pse
## 1 Alsek
## 2 Stikine-Early Timing
## 3 Stikine-Late Timing
## 4 Taku-Early Timing
## 5 Taku-Late Timing
## 6 Taku-Mid Timing
## 7 Lynn Canal
## 8 Taku
## 9 Alsek
## 10 Lower Stikine
## 11 Taku-Late Timing
## 12 Taku-Mid Timing
## 13 Taku-Early Timing
## 14 Nesketahin
## 15 Klukshu
## 16 Tatsamenie
## 17 Christina
## 18 Chutine
## 19 Tahltan
## 20 King Salmon
## 21 Kuthai
## 22 Little Trapper
## 23 Transboundary Fjords (even)
## 24 Transboundary Fjords (odd)
## 25 Alsek (river-type)
## 26 Northern Transboundary Fjords (river-type)
## 27 Taku SummerNote that the TBR data set is the only one containing the steelhead data (the SH data is in the SH data source for the other regions):
## region species_name cuid cu_name_pse stream_name_pse
## 1 Northern Transboundary Steelhead 1081 Taku Summer Canyon Island
## source_id
## 1 TTC_20240313The spawner survey data for Steelhead is imported:
## [1] "File imported: dataset2_spawner-surveys_Steelhead_2025-03-26.csv ; Date modified: 2025-03-26 15:21:18"## region species_name cuid
## 1 Central Coast Steelhead 680
## 2 Central Coast Steelhead 683
## 3 Columbia Steelhead 1380
## 4 Columbia Steelhead 1380
## 5 Columbia Steelhead 1380
## 6 Fraser Steelhead 780
## 7 Fraser Steelhead 780
## 8 Fraser Steelhead 781
## 9 Fraser Steelhead 781
## 10 Fraser Steelhead 784
## 11 Fraser Steelhead 785
## 12 Nass Steelhead 480
## 13 Nass Steelhead 481
## 14 Northern Transboundary Steelhead 1081
## 15 Skeena Steelhead 280
## 16 Skeena Steelhead 281
## 17 Skeena Steelhead 281
## 18 Skeena Steelhead 287
## 19 Vancouver Island & Mainland Inlets Steelhead 980
## 20 Vancouver Island & Mainland Inlets Steelhead 981
## 21 Vancouver Island & Mainland Inlets Steelhead 981
## 22 Vancouver Island & Mainland Inlets Steelhead 981
## 23 Vancouver Island & Mainland Inlets Steelhead 984
## 24 Vancouver Island & Mainland Inlets Steelhead 984
## 25 Vancouver Island & Mainland Inlets Steelhead 985
## 26 Vancouver Island & Mainland Inlets Steelhead 985
## 27 Vancouver Island & Mainland Inlets Steelhead 683
## cu_name_pse source_id
## 1 North Coast Winter
## 2 Transition Summer
## 3 Mid Columbia Summer ONA_20110201
## 4 Mid Columbia Summer
## 5 Mid Columbia Summer OBMEP_20250228
## 6 Mid Fraser Summer
## 7 Mid Fraser Summer Bison_20241129
## 8 Thompson Summer
## 9 Thompson Summer Bison_20241129
## 10 Lower Fraser Summer
## 11 Boundary Bay Winter
## 12 Nass Summer
## 13 Nass Winter
## 14 Taku Summer
## 15 Upper Skeena Headwaters
## 16 Upper Sustut
## 17 Upper Sustut Miyazaki_20241212
## 18 Bulkley
## 19 South Coast Winter
## 20 East Vancouver Island Winter McCulloch_20250113
## 21 East Vancouver Island Winter
## 22 East Vancouver Island Winter Davies_20241129
## 23 West Vancouver Island Summer
## 24 West Vancouver Island Summer McCulloch_20250113
## 25 East Vancouver Island Summer
## 26 East Vancouver Island Summer McCulloch_20250113
## 27 Transition Summer## [1] "The SH data for TBR is present in both the SH and the TBR datasets; the data is identical; the data is removed from the TBR dataset."
## [1] "The source_id field is filled in the TBR dataset and not in the SH one, so the data in the former replaces the data in the latter."The spawner survey data for Columbia: NONE (beside for SH).
The spawner survey data for Central Coast is imported. This data source only concerns one Sockeye CU:
## [1] "File imported: dataset2_spawner-surveys_CentralCoast_2025-04-03.csv ; Date modified: 2025-04-03 09:11:32"## region species_name cuid cu_name_pse
## 1 Central Coast Sockeye 528 South Atnarko LakeThe spawner survey data for Yukon is imported:
## [1] "File imported: dataset2_spawner_surveys_Yukon_2025-04-09.csv ; Date modified: 2025-04-09 16:18:03.314632"## region species_name cuid cu_name_pse
## 1 Yukon Chinook 1201 Big Salmon
## 2 Yukon Chinook 1202 Nordenskiold
## 3 Yukon Chinook 1203 Pelly
## 4 Yukon Chinook 1204 Middle Yukon
## 5 Yukon Chinook 1205 Stewart
## 6 Yukon Chinook 1206 White
## 7 Yukon Chinook 1207 Northern Yukon
## 8 Yukon Chinook 1209 Porcupine
## 9 Yukon Chinook 1211 Upper Yukon
## 10 Yukon Chinook 1212 Teslin
## 11 Yukon Chum 1213 Middle Yukon
## 12 Yukon Chum 1214 North Yukon
## 13 Yukon Chum 1215 White
## 14 Yukon Chum 1216 Donjek Kluane
## 15 Yukon Chum 1217 Porcupine
## 16 Yukon Chum 1219 TeslinFOR FUTURE UPDATE: find the GFE_ID (if it exists) 1st and then streamid.
There remains 1 streamid with NA, out of 152. These
populations will be attributed a streamid value below.
We create the final dataset2_spawner_surveys dataset.
We update the following fields:
## old new
## 1 SPECIES species_name
## 2 SPECIES_QUALIFIED species_qualified
## 3 IS_INDICATOR indicator
## 4 Year year
## 5 MAX_ESTIMATE stream_observed_count
## 6 ESTIMATE_METHOD stream_survey_method
## 7 stream_survey_quality stream_survey_quality
## 8 sys_nm stream_name_pse
## 9 Y_LAT latitude
## 10 X_LONGT longitudeWe define the field sourceid for
dataset2_spawner_surveys:
## [1] "NuSEDS_20250221"We only keep the following fields:
## [1] "region" "species_name" "species_qualified"
## [4] "cuid" "cu_name_pse" "streamid"
## [7] "stream_name_pse" "GFE_ID" "indicator"
## [10] "latitude" "longitude" "year"
## [13] "stream_observed_count" "stream_survey_method" "stream_survey_quality"
## [16] "source_id"There are 0 row removed in dataset2_spawner_surveys, and 689 were added from the Steelhead dataset. Note that there were not any SH data in dataset2_spawner_surveys because those were removed early on in script 1_nuseds_collation.rmd.
There are 1468 row removed in dataset2_spawner_surveys, and 1529 were added from the TBR dataset.
There are 600 row removed in dataset2_spawner_surveys, and 657 were added from the Yukon dataset.
There are 1 row removed in dataset2_spawner_surveys, and 75 were added from the Yukon dataset.
There are 22 CU_NAME in
nuseds_cuid_streamid.csv that are not associated to a
cuid, which corresponds to 2020 data points:
## region SPECIES cuid FULL_CU_IN
## 1 Central Coast Sockeye NA SEL-18-11
## 2 Central Coast Sockeye NA SEL-15-03
## 3 Fraser Chinook NA CK-9006
## 4 Fraser Chinook NA CK-9004
## 5 Fraser Chinook NA CK-9008
## 6 Fraser Chum NA CM-9004
## 7 Fraser Pink NA PKE-9005
## 8 Fraser Sockeye NA SER-06
## 9 Fraser Sockeye NA SEL-03-xx
## 10 Fraser Sockeye NA SEL-06-18
## 11 Fraser Sockeye NA SEL-06-05
## 12 Fraser Sockeye NA SEL-06-04
## 13 Fraser Sockeye NA SER-05
## 14 Fraser Sockeye NA SEL-07-02
## 15 Haida Gwaii Chinook NA CK-9002
## 16 Vancouver Island & Mainland Inlets Chinook NA CK-9005
## 17 Vancouver Island & Mainland Inlets Chinook NA CK-9007
## 18 Vancouver Island & Mainland Inlets Sockeye NA SEL-13-xx
## 19 Vancouver Island & Mainland Inlets Sockeye NA SEL-13-21
## 20 Vancouver Island & Mainland Inlets Sockeye NA SEL-11-11
## 21 Vancouver Island & Mainland Inlets Sockeye NA SEL-11-12
## 22 Vancouver Island & Mainland Inlets Sockeye NA SEL-11-10
## CU_NAME
## 1 WHALEN
## 2 OWIKENO-LATE TIMING
## 3 FRASER-CROSS-CU SUPPLEMENTATION EXCLUSION<<BIN>>
## 4 FRASER-MISCELLANEOUS<<BIN>>
## 5 FRASER-HARRISON FALL TRANSPLANT_FA_0.3<<BIN>>
## 6 INTERIOR FRASER<<BIN>>
## 7 FRASER RIVER<<BIN>>
## 8 UPPER FRASER
## 9 FRASER RIVER MIGRATORY COUNTS<<BIN>>
## 10 CARIBOO-SUMMER TIMING
## 11 FRANCOIS-LATE TIMING
## 12 FRANCOIS-EARLY SUMMER TIMING
## 13 MIDDLE FRASER
## 14 INDIAN/KRUGER-EARLY SUMMER TIMING
## 15 (P)HATCHERY EXCLUSION-PALLANT CREEK
## 16 SOUTH-MISCELLANEOUS<<BIN>>
## 17 SOUTHERN BC-CROSS-CU SUPPLEMENTATION EXCLUSION<<BIN>>
## 18 GREAT CENTRAL/SPROAT<<BIN>>
## 19 OWOSSITSA
## 20 PACK
## 21 (N)GLENDALE
## 22 VILLAGE BAYThese data points are removed from dataset2_spawner_surveys.
There remains 1 population(s) without a streamid:
## region species_name cuid cu_name_pse stream_name_pse latitude
## 1 Central Coast Sockeye 528 South Atnarko Lake Atnarko River 52.34185
## longitude streamid
## 1 -125.7716 NAWe provide them a new value by incrementing from the maximum
streamid already present in the dataset.
The dataset2_spawner_surveys_DATE.csv is exported to
/output/archive in Dropbox; the
dataset2_spawner_surveys_DATE_dummy.csv is exported locally in
/output to be pushed to Github.
The view streamspawnersurveys_output.csv is imported (from the database) to be compared to the updated data.
## [1] "Date last modification of streamspawnersurveys_output.csv: 2025-04-10 12:03:04.090553"Number of additional rows in the updated dataset2_spawner_surveys = 159779
There are 4 CUs gained:
## region species_name cuid cu_name_pse
## 1 Skeena Chum 242 Upper Skeena
## 2 Fraser Sockeye 760 Adams-Early Summer
## 3 Fraser Sockeye 761 Momich-Early Summer
## 4 Central Coast Sockeye 528 South Atnarko LakeThere are 0 CUs lost:
## [1] region species_name cuid cu_name_pse
## <0 rows> (or 0-length row.names)There are 123 new streamid gained (other than the one
related to the CU gained):
## region species_name cuid
## 1 Central Coast Chinook 515
## 2 Central Coast Chinook 515
## 3 Central Coast Chum 503
## 4 Central Coast Chum 503
## 5 Central Coast Chum 503
## 6 Central Coast Chum 504
## 7 Central Coast Coho 518
## 8 Central Coast Coho 518
## 9 Central Coast Coho 520
## 10 Central Coast Coho 520
## 11 Central Coast Coho 520
## 12 Central Coast Coho 522
## 13 Central Coast Coho 522
## 14 Central Coast Coho 523
## 15 Central Coast Pink 608
## 16 Central Coast Pink 608
## 17 Central Coast Pink 608
## 18 Central Coast Pink 608
## 19 Central Coast Pink 609
## 20 Central Coast Pink 609
## 21 Central Coast Pink 609
## 22 Central Coast Pink 609
## 23 Central Coast Pink 609
## 24 Central Coast Pink 610
## 25 Central Coast Pink 611
## 26 Central Coast Pink 611
## 27 Central Coast Pink 611
## 28 Central Coast Pink 611
## 29 Central Coast Pink 611
## 30 Central Coast Pink 612
## 31 Central Coast Pink 612
## 32 Central Coast Sockeye 599
## 33 Central Coast Sockeye 614
## 34 Central Coast Sockeye 614
## 35 Central Coast Sockeye 614
## 36 Central Coast Sockeye 614
## 37 Central Coast Sockeye 614
## 38 Central Coast Sockeye 614
## 39 Central Coast Sockeye 615
## 40 Central Coast Sockeye 615
## 41 Columbia Chinook 301
## 42 Columbia Sockeye 1300
## 43 Fraser Chinook 302
## 44 Fraser Chinook 310
## 45 Fraser Chinook 310
## 46 Fraser Chinook 311
## 47 Fraser Chum 701
## 48 Fraser Chum 701
## 49 Fraser Chum 701
## 50 Fraser Chum 701
## 51 Fraser Chum 701
## 52 Fraser Chum 701
## 53 Fraser Chum 701
## 54 Fraser Chum 701
## 55 Fraser Chum 701
## 56 Fraser Chum 701
## 57 Fraser Coho 708
## 58 Fraser Coho 709
## 59 Fraser Coho 749
## 60 Fraser Coho 749
## 61 Fraser Coho 749
## 62 Fraser Coho 750
## 63 Fraser Coho 750
## 64 Fraser Sockeye 714
## 65 Fraser Sockeye 715
## 66 Fraser Sockeye 716
## 67 Haida Gwaii Chum 801
## 68 Haida Gwaii Coho 808
## 69 Haida Gwaii Pink 813
## 70 Haida Gwaii Pink 814
## 71 Haida Gwaii Sockeye 816
## 72 Haida Gwaii Sockeye 818
## 73 Haida Gwaii Sockeye 818
## 74 Nass Chum 406
## 75 Nass Coho 408
## 76 Nass Coho 410
## 77 Nass Coho 410
## 78 Nass Pink 414
## 79 Nass Sockeye 426
## 80 Skeena Coho 202
## 81 Skeena Coho 215
## 82 Skeena Coho 215
## 83 Skeena Pink 209
## 84 Skeena Pink 209
## 85 Skeena Pink 218
## 86 Skeena Pink 219
## 87 Skeena Pink 219
## 88 Skeena Sockeye 226
## 89 Vancouver Island & Mainland Inlets Chinook 323
## 90 Vancouver Island & Mainland Inlets Chinook 324
## 91 Vancouver Island & Mainland Inlets Chinook 326
## 92 Vancouver Island & Mainland Inlets Chinook 328
## 93 Vancouver Island & Mainland Inlets Chum 900
## 94 Vancouver Island & Mainland Inlets Chum 904
## 95 Vancouver Island & Mainland Inlets Chum 904
## 96 Vancouver Island & Mainland Inlets Chum 905
## 97 Vancouver Island & Mainland Inlets Chum 977
## 98 Vancouver Island & Mainland Inlets Chum 978
## 99 Vancouver Island & Mainland Inlets Chum 978
## 100 Vancouver Island & Mainland Inlets Coho 907
## 101 Vancouver Island & Mainland Inlets Coho 910
## 102 Vancouver Island & Mainland Inlets Coho 914
## 103 Vancouver Island & Mainland Inlets Coho 915
## 104 Vancouver Island & Mainland Inlets Coho 915
## 105 Vancouver Island & Mainland Inlets Coho 915
## 106 Vancouver Island & Mainland Inlets Coho 915
## 107 Vancouver Island & Mainland Inlets Coho 915
## 108 Vancouver Island & Mainland Inlets Pink 917
## 109 Vancouver Island & Mainland Inlets Pink 917
## 110 Vancouver Island & Mainland Inlets Pink 918
## 111 Vancouver Island & Mainland Inlets Pink 920
## 112 Vancouver Island & Mainland Inlets Pink 920
## 113 Vancouver Island & Mainland Inlets Pink 922
## 114 Vancouver Island & Mainland Inlets Pink 922
## 115 Vancouver Island & Mainland Inlets Pink 922
## 116 Vancouver Island & Mainland Inlets Pink 922
## 117 Vancouver Island & Mainland Inlets Pink 926
## 118 Vancouver Island & Mainland Inlets Sockeye 958
## 119 Vancouver Island & Mainland Inlets Sockeye 971
## 120 Vancouver Island & Mainland Inlets Sockeye 971
## 121 Vancouver Island & Mainland Inlets Sockeye 972
## 122 Vancouver Island & Mainland Inlets Sockeye 973
## 123 Vancouver Island & Mainland Inlets Sockeye 973
## cu_name_pse
## 1 North & Central Coast-Early
## 2 North & Central Coast-Early
## 3 Spiller-Fitz-Hugh-Burke
## 4 Spiller-Fitz-Hugh-Burke
## 5 Spiller-Fitz-Hugh-Burke
## 6 Bella Coola-Dean Rivers
## 7 Bella Coola-Dean Rivers
## 8 Bella Coola-Dean Rivers
## 9 Hecate Strait Mainland
## 10 Hecate Strait Mainland
## 11 Hecate Strait Mainland
## 12 Douglas Channel-Kitimat Arm
## 13 Douglas Channel-Kitimat Arm
## 14 Northern Coastal Streams
## 15 Hecate Lowlands (even)
## 16 Hecate Lowlands (even)
## 17 Hecate Lowlands (even)
## 18 Hecate Lowlands (even)
## 19 Hecate Strait-Fjords (even)
## 20 Hecate Strait-Fjords (even)
## 21 Hecate Strait-Fjords (even)
## 22 Hecate Strait-Fjords (even)
## 23 Hecate Strait-Fjords (even)
## 24 Homathko-Klinaklini-Smith-Rivers-Bella Coola-Dean (odd)
## 25 Hecate Strait-Lowlands (odd)
## 26 Hecate Strait-Lowlands (odd)
## 27 Hecate Strait-Lowlands (odd)
## 28 Hecate Strait-Lowlands (odd)
## 29 Hecate Strait-Lowlands (odd)
## 30 Hecate Strait-Fjords (odd)
## 31 Hecate Strait-Fjords (odd)
## 32 Tsimtack/Moore/Roger
## 33 Northern Coastal Fjords (river-type)
## 34 Northern Coastal Fjords (river-type)
## 35 Northern Coastal Fjords (river-type)
## 36 Northern Coastal Fjords (river-type)
## 37 Northern Coastal Fjords (river-type)
## 38 Northern Coastal Fjords (river-type)
## 39 Northern Coastal Streams (river-type)
## 40 Northern Coastal Streams (river-type)
## 41 Okanagan
## 42 Osoyoos
## 43 Boundary Bay (Fall 4-1)
## 44 Middle Fraser River (Spring 5-2)
## 45 Middle Fraser River (Spring 5-2)
## 46 Middle Fraser River (Summer 5-2)
## 47 Lower Fraser
## 48 Lower Fraser
## 49 Lower Fraser
## 50 Lower Fraser
## 51 Lower Fraser
## 52 Lower Fraser
## 53 Lower Fraser
## 54 Lower Fraser
## 55 Lower Fraser
## 56 Lower Fraser
## 57 South Thompson
## 58 North Thompson
## 59 Interior Fraser
## 60 Interior Fraser
## 61 Interior Fraser
## 62 Lower Fraser
## 63 Lower Fraser
## 64 Harrison-Upstream Migrating-Late
## 65 Pitt-Early Summer
## 66 Lillooet-Harrison-Late
## 67 East Haida Gwaii
## 68 West Haida Gwaii
## 69 East Haida Gwaii (odd)
## 70 North Haida Gwaii (odd)
## 71 East Haida Gwaii (river-type)
## 72 West Haida Gwaii (river-type)
## 73 West Haida Gwaii (river-type)
## 74 Portland Canal-Observatory
## 75 Lower Nass
## 76 Portland Sound-Observatory Inlet-Portland Canal
## 77 Portland Sound-Observatory Inlet-Portland Canal
## 78 Nass-Portland-Observatory (odd)
## 79 Lower Nass-Portland (river-type)
## 80 Lower Skeena
## 81 Middle Skeena
## 82 Middle Skeena
## 83 Lower Skeena River (odd)
## 84 Lower Skeena River (odd)
## 85 Middle-Upper Skeena (even)
## 86 Nass-Skeena Estuary (even)
## 87 Nass-Skeena Estuary (even)
## 88 Skeena River (river-type)
## 89 East Vancouver Island-Nanaimo (Spring x-2)
## 90 East Vancouver Island-Nanaimo and Chemainus (Fall x-1)
## 91 Southern Mainland-Southern Fjords (Fall x-1)
## 92 West Vancouver Island-South (Fall x-1)
## 93 Southern Coastal Streams
## 94 Georgia Strait
## 95 Georgia Strait
## 96 Howe Sound-Burrard Inlet
## 97 Northwest Vancouver Island
## 98 Southwest & West Vancouver Island
## 99 Southwest & West Vancouver Island
## 100 Howe Sound-Burrard Inlet
## 101 East Vancouver Island-Georgia Strait
## 102 West Vancouver Island
## 103 Clayoquot
## 104 Clayoquot
## 105 Clayoquot
## 106 Clayoquot
## 107 Clayoquot
## 108 Georgia Strait (even)
## 109 Georgia Strait (even)
## 110 West Vancouver Island (even)
## 111 Southern Fjords (even)
## 112 Southern Fjords (even)
## 113 Georgia Strait (odd)
## 114 Georgia Strait (odd)
## 115 Georgia Strait (odd)
## 116 Georgia Strait (odd)
## 117 Southern Fjords (odd)
## 118 Kennedy
## 119 Southern Fjords (river-type)
## 120 Southern Fjords (river-type)
## 121 West Vancouver Island (river-type)
## 122 East Vancouver Island & Georgia Strait (river-type)
## 123 East Vancouver Island & Georgia Strait (river-type)
## stream_name_pse GFE_ID streamid
## 1 CASCADE RIVER 983 10315
## 2 HUGH CREEK 1041 10316
## 3 FANCY COVE HEAD CREEK 2685 10312
## 4 FANCY COVE RIGHT HAND CREEK 2684 10313
## 5 FELL CREEK 3554 10314
## 6 NOOSGULCH RIVER 2252 10311
## 7 CLAYTON FALLS CREEK 2239 10321
## 8 MCLELLAN CREEK 2681 10323
## 9 COOPER INLET-ADA COVE CREEK 2683 10318
## 10 KLEMTU CREEK 2030 10319
## 11 COOPER INLET-FANNIE COVE LH CREEK 2687 10324
## 12 WATHLSTO CREEK 2655 10317
## 13 MCKAY CREEK 1073 10320
## 14 JENNY BAY WEST CREEK 2692 10322
## 15 COOPER INLET-FANNIE COVE RH CREEK 2708 10326
## 16 KLEMTU CREEK 2030 10327
## 17 ALVIN CREEK 1096 10332
## 18 FANCY COVE HEAD CREEK 2685 10333
## 19 GOBEIL BAY CREEK 11572 10325
## 20 RAINBOW CREEK 990 10328
## 21 MCKAY CREEK 1073 10329
## 22 TETLOCK CREEK 1075 10330
## 23 HUNTER CREEK 1076 10331
## 24 NOOSGULCH RIVER 2252 10337
## 25 ALVIN CREEK 1096 10336
## 26 FANCY COVE HEAD CREEK 2685 10338
## 27 BULLOCK CHANNEL EAST CREEK 2688 10339
## 28 FANCY COVE RIGHT HAND CREEK 2684 10340
## 29 FELL CREEK 3554 10341
## 30 MCKAY CREEK 1073 10334
## 31 HUNTER CREEK 1076 10335
## 32 MOORE LAKE 2792 10349
## 33 TURTLE CREEK 1903 10343
## 34 GRIBBELL ISLAND CREEK 1904 10344
## 35 FISHTRAP BAY CREEK 1908 10345
## 36 LITTLE TILLHORN CREEK 1909 10346
## 37 WATHL CREEK 1046 10347
## 38 HUNTER CREEK 1076 10348
## 39 WEBSTER LAKE CREEK 1807 10342
## 40 COOPER INLET-FANNIE COVE LH CREEK 2687 10350
## 41 OKANAGAN RIVER 442 10352
## 42 OKANAGAN RIVER 442 10353
## 43 CAMPBELL RIVER 64739 10367
## 44 PUNKUTLAENKUT CREEK 2454 10364
## 45 CHILCOTIN RIVER - UPPER 2462 10365
## 46 CARIBOO RIVER - UPPER 2466 10366
## 47 MAPLE CREEK 11 10354
## 48 STONEY CREEK 4 10355
## 49 ANDERSON CREEK CHANNEL 2529 10356
## 50 EAGLE CREEK 441 10357
## 51 BYRNE CREEK 2716 10358
## 52 HOLACHTEN CREEK 52748 10359
## 53 MYSTERY CREEK 189 10360
## 54 SILVERMERE LAKE 52749 10361
## 55 CULTUS LAKE 2441 10362
## 56 CAMILOS CREEK 55417 10363
## 57 TETO CREEK 23726 10371
## 58 ENGINEERED CHANNEL 63379 10369
## 59 BLUE LEAD CREEK 2422 10372
## 60 WASKO CREEK 11491 10373
## 61 HAZELTINE CREEK 2397 10374
## 62 NEVIN CREEK 99 10368
## 63 SEMMIHAULT CREEK 95 10370
## 64 SAKWI CREEK 185 10381
## 65 OLSEN CREEK 3505 10375
## 66 JOFFRE CREEK 58219 10382
## 67 TLELL RIVER 1497 10383
## 68 DOUGLAS INLET CREEK-HEAD 1662 10384
## 69 BAG HARBOUR CREEK 1624 10386
## 70 KUMDIS CREEK 1574 10385
## 71 MATHESON CREEK-R/H 1613 10388
## 72 SECURITY INLET CREEK-L/H 1671 10387
## 73 LOUSCOONE INLET CREEK 1642 10389
## 74 CASCADE CREEK 1766 10390
## 75 ANUDOL CREEK 640 10393
## 76 DONAHUE CREEK 1776 10391
## 77 CRAG CREEK 2312 10392
## 78 DAK RIVER 2236 10394
## 79 Ksi Sii Aks 2 652 10395
## 80 SHANNON CREEK 481 10420
## 81 DEEP CREEK 2656 10419
## 82 TAHLO CREEK - LOWER 602 10421
## 83 WHITEBOTTOM CREEK 2737 10425
## 84 DASQUE CREEK 2601 10426
## 85 BABINE LAKE 2107 10423
## 86 DAK RIVER 2236 10422
## 87 DASQUE CREEK 2601 10424
## 88 DASQUE CREEK 2601 10427
## 89 NANAIMO RIVER 1194 10436
## 90 MILLSTONE RIVER 1191 10438
## 91 GRASSY CREEK 826 10437
## 92 CLAYOQUOT RIVER 2487 10435
## 93 HEALTH LAGOON CREEK 865 10431
## 94 CARRINGTON COVE CREEK 2076 10429
## 95 IRGENS CREEK 2837 10433
## 96 WEST BAY CREEK 752 10430
## 97 HANSEN CREEK 57042 10434
## 98 OKTWANCH RIVER 1362 10428
## 99 KENNEDY LAKE BEACHES 1303 10432
## 100 COTTONWOOD CREEK 208 10446
## 101 BEAR CREEK 32077 10443
## 102 WATERSHED ABOVE STAMP FALLS 11486 10440
## 103 CLAYOQUOT RIVER 2487 10439
## 104 KENNEDY LAKE BEACHES 1303 10441
## 105 MEARES CREEK 1320 10442
## 106 COHO CREEK 55413 10444
## 107 ENGLISH COVE CREEK 55420 10445
## 108 ROBERTS CREEK 757 10448
## 109 WILSON CREEK 759 10449
## 110 WATERSHED ABOVE STAMP FALLS 11486 10447
## 111 WAHKANA BAY CREEK 869 10450
## 112 OWEN BAY CREEK 1125 10451
## 113 MYERS CREEK 2616 10452
## 114 GOLDSTREAM RIVER 1211 10453
## 115 STORE CREEK 801 10454
## 116 MCNAIR CREEK 744 10455
## 117 OWEN BAY CREEK 1125 10456
## 118 KENNEDY LAKE BEACHES 1303 10459
## 119 EMBLEY CREEK 878 10458
## 120 OWEN BAY CREEK 1125 10461
## 121 CLAYOQUOT ARM BEACHES 1307 10460
## 122 COWICHAN RIVER 1208 10457
## 123 MENZIES CREEK 1139 10462There are 0 new streamid lost (other than the one
related to the CU lost):
## [1] region species_name cuid cu_name_pse
## [5] stream_name_pse streamid
## <0 rows> (or 0-length row.names)