Last Updated on 11/27/2023 by Homa Salehabadi (homa.salehabadi@gmail.com)

Streamflow sequences (or traces or time series) for the adjusted paleo-conditioned ensemble developed to represent the plausible storyline of warming-driven declining streamflow with increasing variability in the Colorado River Basin, as described by Salehabadi, Tarboton et al. (2024) and Prairie et al. (2008). 


The dataset is available in two formats:

1- CRSS-Ready-To-Use Input Files (CRSSInputFileFormat_AdjPaleoCond.zip)
-------------------------------------------------------------

This format includes all the water supply input files that are required to run CRSS. These data are ready to be directly imported into CRSS.

In the "CRSSInputFileFormat_AdjPaleoCond" folder, there is a folder containing 100 subfolders, each associated with a specific streamflow trace. Each trace folder contains 29 "Inflow Files" that provide flow data for 29 CRSS gages. Additionally, there are five other required input files within each trace folder included:

      •  HydrologyParameters.SupplyScenario
      •  HydrologyParameters.TraceNumber
      •  MeadFloodControlData.hydrologyIncrement
      •  MWD_ICS.SacWYType
      •  TMD_East_Slope_Supply.St_Vrain_Annual_Flow

The input file names are aligned with CRSS V.6 (CRSS.Mar2023).


2- Excel File Format (ExcelFiles_AdjPaleoCond folder)
-------------------------------------------------------------

This format includes the generated data in Excel files that provide the following information:

      •  AdjPaleoCond_MonthlyIntervNF.xlsx:  Monthly Intervening Natural Flows at 29 CRSS sites.
      •  AdjPaleoCond_AnnualWYIntervNF.xlsx:  Annual Water Year Intervening Natural Flows at 29 CRSS sites.
      •  AdjPaleoCond_LeesFerryAnnualWYTotalNF.xlsx:  Annual Water Year Total Natural Flows at Lees Ferry.
      •  AdjPaleoCond_MWD_ICS.SacWYType.xlsx:  Sacramento Water Year Type (MWD_ICS.SacWYType in CRSS)
      •  AdjPaleoCond_TMD_East_Slope_Supply.St_Vrain_Annual_Flow.xlsx:  St Vrain Annual Flows (TMD_East_Slope_Supply.St_Vrain_Annual_Flow in CRSS)

The Excel files for Monthly and Annual Intervening Natural Flows are comprised of 100 sheets, each containing a 77-year sequence (trace) of monthly or annual streamflow at the 29 CRSS sites. USGS Gage Numbers (streamflow gaging site number) are used to identify each CRSS natural inflow site for which flow is simulated. The corresponding USGS Gage Numbers and a map of their locations are provided in an Excel file (USGSGages_CRSSSites.xlsx).

For the Monthly and Annual Flows, the first one or two columns (A and B) hold the water year and month selected from historical flows to simulate that year.  The remaining columns contain intervening natural flow for the corresponding site, in acre-ft.  Intervening natural flow refers to the streamflow originating directly from the subwatershed that drains into the site, without passing any upstream site.  


Data 
-------------------------------------------------------------

These files were generated using R programming, the US Bureau of Reclamation Natural Flow Database Excel file (last updated on 12/15/2022), Tree-Ring Reconstructed flow at Lees Ferry from the most skillful model of Meko et al. (2017), and historical data for Sacramento Water Year Type and St Vrain Annual Flows from CRSS.Mar2023.  



References
-------------------------------------------------------------

Meko, D. M., C. A. Woodhouse and E. R. Bigio, (2017), "Southern California Tree-Ring Study," California Department of Water Resources, https://pdfs.semanticscholar.org/fbaf/487604e2537c8f51037035e59c13113edeeb.pdf.

Salehabadi, H., Tarboton, D. G., Wheeler, K. G., Prairie, J., Smith, R., & Baker, S. (2024). Developing Storylines of Plausible Future Streamflow and Generating a New Warming-Driven Declining Streamflow Ensemble: Colorado River Case Study. ESS Open Archive. https://doi.org/10.22541/essoar.172469147.74897971/v1

Prairie, J., K. Nowak, B. Rajagopalan, U. Lall and T. Fulp, (2008), "A stochastic nonparametric approach for streamflow generation combining observational and paleoreconstructed data," Water Resour. Res., 44(6): W06423, http://dx.doi.org/10.1029/2007WR006684 

U.S. Bureau of Reclamation, (2023), Colorado River Basin Natural Flow and Salt Data, Colorado River Basin Natural Flow Database. Last updated December 15, 2022, https://www.usbr.gov/lc/region/g4000/NaturalFlow/current.html