Updated 9/26/2023

The file RMJOCII_StreamflowProj_FileGDB.gdb and files in the nc_files folder include results presented in the report "Streamflow Projections to Inform Climate-Adapted Culvert Designs in Washington State" prepared by the University of Washington Climate Impacts Group for the Washington Department of Fish and Wildlife. See Phase 4 at: https://cig.uw.edu/projects/climate-robust-culvert-design/

ESRI ArcMap 10.8.2. and the arcpy library were used to extract the tifs included in this geodatabase from the NetCDF files used in the project analyses shared in the above report, and in the nc_files folder.

Three variables from the netCDF files are included in this geodatabase "100yr_event", "BFQ" (bankfull flow), and "BFW" (bankfull width). All units in these files are percent change for 2070-2099 relative to 1990-2019.

The naming convention of the netcdf files are as follows:
- VIC/PRMS - hydrologic model
- (For VIC) P1/P2/P3 - calibration method used
- MACA/BCSD - downscaling method
- RCP45/RCP85 - emissions scenario
- 100yr_event/BFQ/BFW - NetCDF variable (see above)

The ASCII_files folder also includes individual ascii grid files for each of the model-calibration, downscaling, and future greenhouse gas scenario combinations, and utilize the same naming conventions do identify the model-calibration, downscaling, and future greenhouse gas scenario combination. The "change" folders are percent change for 2070-2099 relative to 1990-2019. All other folders include raw values. The directory structure is as follows:

ASCII_files
      |
      |______100year_event_change
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______BFQ_change
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______BFW_change
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______future_100yr_event
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______future_BFQ
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______future_BFW
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______hist_100yr_event
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______hist_BFQ
      |       |
      |       |___RCP45
      |       |
      |       |___RCP85
      |
      |
      |
      |______hist_BFW
              |
              |___RCP45
              |
              |___RCP85