ybakos
commented
10 months ago After inspecting production, there seems to be missing organization affiliations for projects that "used to have" the string-based affiliation attribute filled in. In other words, before deleting the affiliation_legacy field, let's ensure that all proper affiliations are established. We'll need to do this manually, since names are not consistent.
These are the 105 projects that have values in their affiliation_legacy field.
{9=>
{:name=>"South Fork John Day River",
:affiliation_legacy=>"South Fork John Day Watershed Council",
:affiliations=>[]},
47=>{:name=>"Campbell Creek", :affiliation_legacy=>"MDWC", :affiliations=>[]},
50=>
{:name=>"Summit Creek",
:affiliation_legacy=>"Malheur National Forest and Oregon Natural Desert Association",
:affiliations=>[]},
46=>{:name=>"Fox Creek", :affiliation_legacy=>"CTWSRO", :affiliations=>[]},
48=>
{:name=>"Pine Creek",
:affiliation_legacy=>
"Confederated Tribes of Warm Springs, Oregon Natural Desert Association",
:affiliations=>[]},
79=>{:name=>"Station Creek", :affiliation_legacy=>"PacifiCorps", :affiliations=>[]},
98=>
{:name=>"Mill Creek",
:affiliation_legacy=>"City of Atlanta Department of Watershed Management",
:affiliations=>[]},
86=>
{:name=>"Tumalum Creek",
:affiliation_legacy=>
"Snake River Salmon Recovery Board, Anabranch Solutions, Pomeroy Conservation District, Herres Land Company, Washington Department of Fish and Wildlife, US Forest Service, ",
:affiliations=>[]},
74=>
{:name=>"Basin Creek, Mahogany Creek",
:affiliation_legacy=>"Utah State University",
:affiliations=>[]},
75=>
{:name=>"San Rafael River",
:affiliation_legacy=>"Bureau of Land Managment & Utah State University",
:affiliations=>[]},
66=>
{:name=>"SF Beaver Creek",
:affiliation_legacy=>"Methow Beaver Project, USFS, WA Recreation & Conservation",
:affiliations=>[]},
73=>
{:name=>"Basin Creek, Mahogany Creek",
:affiliation_legacy=>"Utah Department of Wildlife Resources",
:affiliations=>[]},
83=>
{:name=>"Tenmile Creek",
:affiliation_legacy=>
"Asotin County Conservation District, Anabranch Solutions, Bonneville Power Company",
:affiliations=>[]},
85=>
{:name=>"North Fork Palouse ",
:affiliation_legacy=>"Anabranch Solutions, Palouse Conservation District",
:affiliations=>[]},
95=>
{:name=>"Chimney Creek", :affiliation_legacy=>"Blackfoot Challenge", :affiliations=>[]},
91=>
{:name=>"Tributary to Wildcat Creek",
:affiliation_legacy=>"East Bay Regional Park District",
:affiliations=>[]},
92=>
{:name=>"Jack Creek",
:affiliation_legacy=>"Oregon Natural Desert Association",
:affiliations=>[]},
97=>{:name=>"Nogal Canyon", :affiliation_legacy=>"Chaunte Canyon ", :affiliations=>[]},
88=>
{:name=>"Rodeo Creek", :affiliation_legacy=>"John Muir Land Trust", :affiliations=>[]},
89=>
{:name=>"North Fork Tincup",
:affiliation_legacy=>"USDA Forest Service",
:affiliations=>[]},
93=>
{:name=>"Wildcat Creek", :affiliation_legacy=>"City of San Pablo", :affiliations=>[]},
170=>{:name=>"Trail Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
149=>
{:name=>"Schafer Creek",
:affiliation_legacy=>"Grays Harbor Conservation District",
:affiliations=>[]},
157=>{:name=>"Big Atkinson Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
158=>{:name=>"Badger Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
171=>{:name=>"Reeder Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
160=>{:name=>"Cave Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
162=>
{:name=>"Castle Creek ",
:affiliation_legacy=>"Nez Perce Tribe Fisheries Watershed",
:affiliations=>[]},
159=>{:name=>"Badger Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
177=>
{:name=>"Cottonwood Creek",
:affiliation_legacy=>"Bureau of Land Managment - Simplot Land and Livestock",
:affiliations=>[]},
183=>
{:name=>"Tenmile Creek",
:affiliation_legacy=>"Asotin County Conservation District",
:affiliations=>[]},
184=>
{:name=>"Couse Creek",
:affiliation_legacy=>"Asotin County Conservation District",
:affiliations=>[]},
169=>{:name=>"Bear Creek", :affiliation_legacy=>"NRCS", :affiliations=>[]},
163=>
{:name=>"East Foster Creek",
:affiliation_legacy=>
"United States Fish and Wildlife Service, Foster Creek Conservation District, Anabranch Solutions, Conservation Northwest, Pheasants Forever",
:affiliations=>[]},
167=>{:name=>"Madison Creek", :affiliation_legacy=>"OSU-Cascades", :affiliations=>[]},
172=>{:name=>"Sheep Creek", :affiliation_legacy=>"EcoMetrics", :affiliations=>[]},
189=>{:name=>"Thirtymile Creek", :affiliation_legacy=>"Gilliam SWCD", :affiliations=>[]},
190=>{:name=>"Hay Creek", :affiliation_legacy=>"Gilliam SWCD", :affiliations=>[]},
191=>{:name=>"NF Butte Creek", :affiliation_legacy=>"Gilliam SWCD", :affiliations=>[]},
192=>
{:name=>"Ferry Canyon Creek", :affiliation_legacy=>"Gilliam SWCD", :affiliations=>[]},
194=>{:name=>"Straight Fork", :affiliation_legacy=>"SITLA", :affiliations=>[]},
201=>
{:name=>"Jim Brown Creek",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed",
:affiliations=>[]},
90=>
{:name=>"Rio Chamita",
:affiliation_legacy=>"NM Dept of Game and Fish",
:affiliations=>[]},
96=>
{:name=>"10-Mile Creek (headwaters)",
:affiliation_legacy=>"Aquatic & Wetland Company (previous employer)",
:affiliations=>[]},
67=>
{:name=>"Frazer Creek",
:affiliation_legacy=>
"Methow Beaver Project, Confederated Tribes of the Colville Reservation",
:affiliations=>[]},
72=>{:name=>"Kimbell Creek", :affiliation_legacy=>"Jay Tanner", :affiliations=>[]},
80=>
{:name=>"Penawawa Creek",
:affiliation_legacy=>"Anabranch Solutions, LLC",
:affiliations=>[]},
101=>
{:name=>"Musselshell Creek",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed",
:affiliations=>[]},
99=>
{:name=>"Musselshell Creek",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed",
:affiliations=>[]},
102=>
{:name=>"Musselshell Creek",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed",
:affiliations=>[]},
161=>
{:name=>"Deer Gulch",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed",
:affiliations=>[]},
165=>
{:name=>"Twisp River",
:affiliation_legacy=>"Methow Beaver Project and Methow Salmon Recovery Foundation",
:affiliations=>[]},
44=>
{:name=>"Myers Creek",
:affiliation_legacy=>
"Okanogan Highlands Alliance, US Fish and Wildlife Service, Trout Unlimited",
:affiliations=>[]},
49=>
{:name=>"Hay Creek",
:affiliation_legacy=>"Oregon Natural Desert Association, Oregon State Parks",
:affiliations=>[]},
100=>
{:name=>"Musselshell Creek",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed",
:affiliations=>[]},
200=>
{:name=>"Musselshell Creek",
:affiliation_legacy=>"Nez Perce Tribe DFRM Watershed Division",
:affiliations=>[]},
178=>
{:name=>"Willow Creek",
:affiliation_legacy=>"Idaho Fish and Game & Idaho Department of Lands",
:affiliations=>
["Idaho Department of Fish and Game",
"Idaho Department of Lands",
"Anabranch Solutions"]},
113=>
{:name=>"East Canyon Creek",
:affiliation_legacy=>
"Utah State University, Swaner Preserve & EcoCenter, and Wild Utah Project",
:affiliations=>[]},
4=>
{:name=>"Parrish Creek",
:affiliation_legacy=>"Mid John Day - Bridge Creek Watershed Council ",
:affiliations=>
["Oregon Watershed Enhancement Board",
"Mid John Day - Bridge Creek Watershed Council",
"Anabranch Solutions"]},
5=>
{:name=>"Bear Creek",
:affiliation_legacy=>"Wheeler County Soil and Water Conservation District",
:affiliations=>
["Eco Logical Research",
"Wheeler Soil and Water Conservation District",
"Oregon Watershed Enhancement Board",
"Mid John Day - Bridge Creek Watershed Council",
"NOAA Fisheries",
"Anabranch Solutions"]},
6=>
{:name=>"Bridge Creek",
:affiliation_legacy=>"NOAA Fisheries",
:affiliations=>
["Oregon Natural Desert Association",
"Eco Logical Research",
"NOAA Fisheries",
"Anabranch Solutions"]},
7=>
{:name=>"South Fork Crooked River",
:affiliation_legacy=>"OSU-Cascades",
:affiliations=>
["OSU-Cascades", "Oregon Watershed Enhancement Board", "Anabranch Solutions"]},
51=>
{:name=>"Whychus Creek",
:affiliation_legacy=>"Upper Deschutes Watershed Council",
:affiliations=>["Upper Deschutes Watershed Council", "Anabranch Solutions"]},
179=>
{:name=>"East Fork Dry Creek",
:affiliation_legacy=>"Idaho Fish and Game & US Forest Service",
:affiliations=>["Idaho Department of Fish and Game", "Anabranch Solutions"]},
52=>
{:name=>"Birch Creek",
:affiliation_legacy=>"Anabranch Solutions, USFS, IDFG, Utah State University",
:affiliations=>["Utah State University"]},
53=>
{:name=>"Birch Creek",
:affiliation_legacy=>"Anabranch Solutions, USFS, IDFG, Utah State University",
:affiliations=>["U.S. Forest Service", "Anabranch Solutions"]},
54=>
{:name=>"West Branch Carrabassett River",
:affiliation_legacy=>"USFWS, Maine ",
:affiliations=>["Anabranch Solutions"]},
55=>
{:name=>"Little Bear Creek",
:affiliation_legacy=>"NRCS & Private Landowners",
:affiliations=>["Natural Resource Conservation Service", "Anabranch Solutions"]},
56=>
{:name=>"Little Tucannon River",
:affiliation_legacy=>"Columbia Conservation District",
:affiliations=>
["Snake River Salmon Recovery Board",
"Columbia Conservation District",
"Anabranch Solutions"]},
57=>
{:name=>"Charley Creek",
:affiliation_legacy=>
"Eco Logical Research, Anabranch Solutions, Snake River Salmon Recovery Board, WDFW Asotin Wildlife Area, Pacific State Marine Fisheries Commission, Recreation and Conservation Office, Asotin County Conservation District",
:affiliations=>["Eco Logical Research", "Anabranch Solutions"]},
180=>
{:name=>"Coal Pit Creek",
:affiliation_legacy=>"Idaho Fish and Game - US Forest Service",
:affiliations=>["Idaho Department of Fish and Game", "Anabranch Solutions"]},
59=>
{:name=>"South Fork Asotin Creek",
:affiliation_legacy=>
"Eco Logical Research, Anabranch Solutions, Snake River Salmon Recovery Board, WDFW Asotin Wildlife Area, Pacific State Marine Fisheries Commission, Recreation and Conservation Office, Asotin County Conservation District",
:affiliations=>
["Eco Logical Research",
"Washington Department of Fish and Wildlife",
"Anabranch Solutions"]},
60=>
{:name=>"North Fork Asotin Creek",
:affiliation_legacy=>
"Eco Logical Research, Anabranch Solutions, Snake River Salmon Recovery Board, WDFW Asotin Wildlife Area, Pacific State Marine Fisheries Commission, Recreation and Conservation Office, Asotin County Conservation District",
:affiliations=>
["Eco Logical Research",
"Washington Department of Fish and Wildlife",
"Snake River Salmon Recovery Board",
"Anabranch Solutions"]},
61=>
{:name=>"Alpowa Creek",
:affiliation_legacy=>
"Pomeroy Conservation District, Private Landowners, Palouse Conservation District, Snake River Salmon Recovery Board, WDFW, Recreation and Conservation Office, US Forest Service, Eco Logical Research, Anabranch Solutions ",
:affiliations=>
["Pomeroy Conservation District",
"Natural Resource Conservation Service",
"Snake River Salmon Recovery Board",
"Palouse Conservation District",
"Washington Department of Ecology",
"Anabranch Solutions"]},
63=>
{:name=>"Deadman Creek",
:affiliation_legacy=>"Pomeroy Conservation District, Anabranch Solutions",
:affiliations=>["Pomeroy Conservation District", "Anabranch Solutions"]},
64=>
{:name=>"Meadow Creek",
:affiliation_legacy=>"Pomeroy Conservation District, Anabranch Solutions",
:affiliations=>["Pomeroy Conservation District", "Anabranch Solutions"]},
181=>
{:name=>"McMullen Creek",
:affiliation_legacy=>"Idaho Fish and Game - US Forest Service",
:affiliations=>["Idaho Department of Fish and Game", "Anabranch Solutions"]},
65=>
{:name=>"Tumalum Creek",
:affiliation_legacy=>"Pomeroy Conservation District, Anabranch Solutions, WDFW",
:affiliations=>
["Pomeroy Conservation District",
"Washington Department of Fish and Wildlife",
"Anabranch Solutions"]},
68=>
{:name=>"Kimbell Creek",
:affiliation_legacy=>"Bureau of Land Management",
:affiliations=>["Bureau of Land Management", "Anabranch Solutions"]},
69=>
{:name=>"Birch Creek",
:affiliation_legacy=>"Bureau of Land Management",
:affiliations=>["Bureau of Land Management", "Anabranch Solutions"]},
70=>
{:name=>"Cotton Creek, Kimbell Creek, Pine Creek",
:affiliation_legacy=>"Jay Tanner and the Utah Division of Wildlife Resources",
:affiliations=>["Utah Division of Wildlife Resources", "Anabranch Solutions"]},
71=>
{:name=>"Cotton Creek, Kimbell Creek, Pine Creek",
:affiliation_legacy=>"Jay Tanner and Utah Department of Wildlife Resources",
:affiliations=>["Utah Division of Wildlife Resources", "Anabranch Solutions"]},
76=>
{:name=>"Josephine Creek",
:affiliation_legacy=>
"Idaho Department of Fish and Game & US Fish and Wildlife Service",
:affiliations=>
["Idaho Department of Fish and Game",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
77=>
{:name=>"Rose Creek",
:affiliation_legacy=>"Idaho Department of Fish and Game",
:affiliations=>
["Idaho Department of Fish and Game",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
78=>
{:name=>"Baugh Creek, Hailey Creek, Sheep Creek",
:affiliation_legacy=>
"Idaho Department of Fish and Wildlife, US Fish and Wildlife Service, Trout Unlimited, ID Offices of Species Conservation",
:affiliations=>
["Idaho Department of Fish and Game",
"Trout Unlimited",
"Idaho Governor's Office of Species Conservation",
"The Nature Conservancy",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
81=>
{:name=>"Curtis Creek",
:affiliation_legacy=>"Utah Watersheds Coordinating Council, Utah State University",
:affiliations=>["Utah Division of Wildlife Resources", "Utah State University"]},
82=>
{:name=>"Pataha Creek",
:affiliation_legacy=>
"Anabranch Solutions, Pomeroy Conservation District, Salmon Recovery Funding Board, US Forest Service, Washington Department of Ecology",
:affiliations=>["Snake River Salmon Recovery Board", "Anabranch Solutions"]},
84=>
{:name=>"South Fork Palouse",
:affiliation_legacy=>"Anabranch Solutions, Palouse Conservation District",
:affiliations=>["Anabranch Solutions"]},
164=>
{:name=>"East Willow Creek",
:affiliation_legacy=>"Utah Division of Wildlife Resources, Anabranch Solutions",
:affiliations=>["Utah Division of Wildlife Resources", "Anabranch Solutions"]},
168=>
{:name=>"Nuck Woodward Creek",
:affiliation_legacy=>"Utah Division of Wildlife Resources, Anabranch Solutions ",
:affiliations=>["Utah Division of Wildlife Resources", "Anabranch Solutions"]},
173=>
{:name=>"Pataha Creek",
:affiliation_legacy=>"Anabranch Solutions",
:affiliations=>
["Pomeroy Conservation District",
"Natural Resource Conservation Service",
"Anabranch Solutions"]},
174=>
{:name=>"Straight Fork",
:affiliation_legacy=>"SITLA - Trust Lands Administration",
:affiliations=>
["Utah Division of Wildlife Resources",
"SITLA School & Institutional Trust Lands Administration",
"Anabranch Solutions"]},
175=>
{:name=>"Kimbell Creek",
:affiliation_legacy=>"Bureau of Land Management",
:affiliations=>
["Utah Division of Wildlife Resources",
"Bureau of Land Management",
"Anabranch Solutions"]},
176=>
{:name=>"Thompson Creek",
:affiliation_legacy=>"Wood River Land Trust - Muldoon Grazing Association",
:affiliations=>
["Idaho Department of Fish and Game",
"Wood River Land Trust",
"The Nature Conservancy",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
182=>
{:name=>"2V Meadow",
:affiliation_legacy=>"Mountain Island Ranch",
:affiliations=>
["Colorado West Land Trust",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
185=>
{:name=>"Price River",
:affiliation_legacy=>"Bureau of Land Management - Utah State University",
:affiliations=>
["Utah Division of Wildlife Resources",
"Bureau of Land Management",
"Anabranch Solutions"]},
186=>
{:name=>"High Five Creek",
:affiliation_legacy=>"Wood River Land Trust, Idaho Fish and Game",
:affiliations=>
["Idaho Department of Fish and Game",
"Wood River Land Trust",
"The Nature Conservancy",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
187=>
{:name=>"Cold Springs Creek",
:affiliation_legacy=>"Wood River Land Trust",
:affiliations=>
["Idaho Department of Fish and Game",
"Wood River Land Trust",
"The Nature Conservancy",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
188=>
{:name=>"Mancos River",
:affiliation_legacy=>"NPS MVNP",
:affiliations=>["Anabranch Solutions"]},
193=>
{:name=>"NF Sprague River",
:affiliation_legacy=>"Trout Unlimited",
:affiliations=>
["Trout Unlimited",
"Swiftwater Design",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
195=>
{:name=>"Reservoir Creek",
:affiliation_legacy=>"The Nature Conservancy, Beaverhead Watershed Committee",
:affiliations=>
["Beaverhead Watershed Committee", "The Nature Conservancy", "Anabranch Solutions"]},
196=>
{:name=>"Baugh Creek, Hailey Creek",
:affiliation_legacy=>"USFWS, IDFG, Pheasants Forever",
:affiliations=>
["Idaho Department of Fish and Game",
"Idaho Governor's Office of Species Conservation",
"U.S. Fish and Wildlife Service",
"Anabranch Solutions"]},
197=>
{:name=>"Baugh Creek and Hailey Creek",
:affiliation_legacy=>"IDFG, WRLT",
:affiliations=>
["Idaho Department of Fish and Game",
"Wood River Land Trust",
"Anabranch Solutions"]},
198=>
{:name=>"Bear Creek",
:affiliation_legacy=>"OSU-Cascades",
:affiliations=>["Idaho Department of Fish and Game", "NOAA Fisheries"]},
199=>
{:name=>"Bear Creek",
:affiliation_legacy=>"OSU Cascades",
:affiliations=>
["Idaho Department of Fish and Game",
"Utah Division of Wildlife Resources",
"NOAA Fisheries"]}}
Audit first, then remove.