Formatted inputs for hydrofixr

<p>**Consolidated input data for hydrofixr** (https://github.com/pnnl/hydrofixr)<br> Prepared: 2021-12-21<br> Contact: sean.turner@pnnl.gov</p> <p>--------------------------------------------------------------------------<br> **HydroSource_HYC.csv**<br> --------------------------------------------------------------------------<br> Description: Locations and key characteristics of U.S. hydropower plants<br> Original data source: ORNL HydroSource &quot;Existing Hydropower Assets&quot;<br> URL: https://hydrosource.ornl.gov/dataset/EHA2021<br> Cite: Johnson et al., Existing Hydropower Assets, 2021. HydroSource. ORNL.<br> DOI: 10.21951/EHA_FY2021/1782791<br> Downloaded: 2021-10-13<br> Procedure:<br> - Select key data columns<br> - Filter for conventional hydro<br> --------------------------------------------------------------------------</p> <p><br> --------------------------------------------------------------------------<br> **EIA_NetGEN_HYC.csv**<br> --------------------------------------------------------------------------<br> Description: Observed, plant-level, monthly hydropower generation (MWh)<br> Period of coverage: 2001 - 2019<br> Original data source: EIA Form 923 (906/920)<br> URL: https://www.eia.gov/electricity/data/eia923/<br> Downloaded: 2021-10-13<br> Procedure:<br> - Filter for EIA IDs listed in HydroSource<br> - Filter for type &quot;HY&quot; / &quot;HYC&quot; (conventional hydro).<br> - Clean and convert to long format.<br> --------------------------------------------------------------------------</p> <p><br> --------------------------------------------------------------------------<br> **USACE_PNW_monthly_mmm.csv** and **USACE_PNW_weekly_mmm.csv**<br> --------------------------------------------------------------------------<br> Description: Observed, plant-level, monthly and weekly mean/max/min (&quot;mmm&quot;)<br> Period of coverage: 2011 - 2020<br> Original data source: USACE Data Query<br> URL: https://www.nwd-wc.usace.army.mil/dd/common/dataquery/www/<br> Downloaded: 2021-10-14<br> Procedure:<br> - Compute mean, max, and min of hourly generation for months and weeks.<br> --------------------------------------------------------------------------</p> <p><br> --------------------------------------------------------------------------<br> **WM_dev_base_case_cropped_2004_2010/**<br> --------------------------------------------------------------------------<br> Description: Output from MOSART-WM simulation; average daily flow rate.<br> Period of coverage: 2004 - 2010<br> Units: m3/s<br> Spatial resolution: 0.125 grid<br> Temporal resolution: daily.<br> Notes: these MOSART-WM outputs have been filtered and cropped...<br> ...for relevant variables and spatial extent to reduce file size.<br> --------------------------------------------------------------------------</p> <p><br> --------------------------------------------------------------------------<br> **EIA_plant_capabilitiy.csv**<br> --------------------------------------------------------------------------<br> Description: Monthly plant capabilities<br> Data source: EIA form 860 (2019) 3_1_Generator file.<br> Approach:<br> - Filter for EIA IDs contained in HydroSource (i.e., hydropower dams).<br> - Summer and winter capabilities assumed to be JJA and DJF, respectively.<br> - Fall and spring capabilities interpolated from summer/winter.<br> - Unit: MW.<br> -------------------------------------------------------------------------</p>