Made this map as a figure for my research. Data was collected from U.S. Census, Washington State, Idaho, Oregon, and Montana GIS portals for waterways and lakes. Canada streams and lakes data was collected from British Columbia GIS portal.

Nameplate capacity was gathered from the U.S. Army Core of Engineers and British Columbia Hydro and Power Authority. Presented at 8 different even percentiles.

Map was produced with Python and the Geopandas, libpysal, and mapclassify libraries.

As a note, this is not a comprehensive map of all the dams or hydroelectric facilities in the CRB.

For those interested there’s 13 dams on the Columbia River in BC, along with the headwaters of the whole river system which has led to a lot of negotiations between us and the the Americans and the creation of the Columbia River treaty.As well as a community trust has been established with proceeds from the sale of hydro  to fund community infrastructure, culture and other initiative to residents of the Columbia basin. I believe this only available to those on the Canadian side but I am not 100% on that point.