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

Streamflow sequences (or traces) for adjusted paleo-conditioned ensemble were developed to characterize plausible future warming-driven streamflow conditions in the Colorado River Basin as described by Salehabadi, Tarboton et al. (in preparation) and Prairie et al. (2008). 


The dataset is available in two different 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, Tarboton et al. (in preparation)

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