i. .\File_Mapping.csv: This file relates historical reconstructed hydrology streamflow from the U.S. Army Corps of Engineers () to the appropriate stochastic streamflow file for disaggregation of streamflow. Column A is an assigned ID, column B is named “Stochastic” and is the stochastic streamflow file needed for disaggregation, column c is called “RH_Ratio_Col” and is the name of the column in the reconstructed hydrology dataset associated with a stochastic streamflow file, and column D is named “Col_Num” and is the column number in the reconstructed hydrology dataset with the name given in column C. ii. .\Original_Draw_YearDat.csv: This file contains the historical year from 1930 to 2017 with the closest total streamflow for the Souris River Basin to each year in the stochastic streamflow dataset. Column A is an index number, column B is named “V1” and is the year in a simulation, column C is called “V2” and is the stochastic simulation number, column D is an integer that can be related to historical years by adding 1929, and column D is named “year” and is the historical year with the closest total Souris River Basin streamflow volume to the associated year in the stochastic traces. iii. .\revdrawyr.csv: This file is setup the same way that .\Original_Draw_YearDat.csv was except that, when a year had over 400 occurrences, it was randomly replaced with one of the 20 other closest years. The replacement process was completed until there were less than 400 occurrences of each reconstructed hydrology year associated with stochastic simulation years. Column A is an index number, column B is named “V1” and is the year in a simulation, column C is called “V2” and is the stochastic simulation number, column D is called “V3” and is the historical year who’s streamflow ratios will be multiplied by stochastic streamflow, and column E is called “Stoch_yr” and is the total of 2999 and the year in column B. iv. .\RH_1930_2017.csv: This file contains the daily streamflow from the U.S. Army Corps of Engineers (2020), reconstructed hydrology for the Souris River Basin for the period of 1930 to 2017. Column A is the date and columns B through AA are the daily streamflow in cubic feet per second. v. .\rhmoflow_1930Present.csv: This file was created based on .\RH_1930_2017.csv and provides streamflow for each site in cubic meters for a given month. Column A is an unnamed index column, column B is historical year, column C is the historical month associated with the historical year, column D provides a day equal to 1 but does not have particular significance and columns E through AD are monthly streamflow volume for each site location. vi. .\Stoch_Annual_TotVol_CubicDecameters.csv: This file contains the total volume of streamflow for each of the 26 sites for each month in the stochastic streamflow time timeseries and provides a total streamflow volume divided by 100,000 on a monthly basis for the entire Souris River Basin. Column A is unnamed and contains an index number, column B is month and is named “V1”, column C is the year in a simulation, column D is the simulation number, columns E (V4 through V29) through AD are streamflow volume in cubic meters, and column AE (V30) is total Souris River Basin monthly streamflow volume in cubic decameters/1,000.

.\Stochastic Meteorology\ I. .\genpet.csv: This file contains stochastic monthly PET values for each weather station used to develop stochastic climate data in Kolars and others (2016). Column A is the weather station number, column B is the year in a stochastic simulation, column’s C through N are January through December PET values in millimeters, respectively. Simulations are stacked in order from 1 to 100 for each weather station. II. .\genprec.csv: This file contains stochastic monthly precipitation values for each weather station used to develop stochastic climate data in Kolars and others (2016). Column A is the weather station number, column B is the year in a stochastic simulation, column’s C through N are January through December precipitation values in millimeters, respectively. Simulations are stacked in order from 1 to 100 for each weather station. III. .\ grid_pet_stoch.csv: This file provides monthly stochastic PET values for each grid point used in the WBM presented in Kolars and others (2016). Column A is an unnamed index, column B, “lat”, is the latitude for a grid point, column C, “lon”, is the longitude for a grid point, column D is the year in a stochastic simulation, and columns E through P are the values of PET for January through December in millimeters, respectively. Simulations are ordered and placed on top of one another. IV. .\ grid_prec_stoch.csv: This file provides monthly stochastic precipitation values for each grid point used in the WBM presented in Kolars and others (2016). Column A is an unnamed index, column B, “lat”, is the latitude for a grid point, column C, “lon”, is the longitude for a grid point, column D is the year in a stochastic simulation, and columns E through P are the values of precipitation for January through December in millimeters, respectively. Simulations are ordered and placed on top of one another. V. .\PETMM_basinAv_stoch.csv: This file contains the Souris River Basin average PET for each month of the stochastic PET time series. Column A is an unnamed index, column B, “simnum” is the simulation number, column C, “yr”, is the year in a stochastic simulation, and columns D through O are the PET values in millimeters for January through December, respectively. VI. .\PrecipMM_basinAv_stoch.csv: This file contains the Souris River Basin average precipitation for each month of the stochastic precipitation time series. Column A is an unnamed index, column B, “simnum” is the simulation number, column C, “yr”, is the year in a stochastic simulation, and columns D through O are the precipitation values in millimeters for January through December, respectively.

.\Stochastic Meteorology\ I. .\genpet.csv: This file contains stochastic monthly PET values for each weather station used to develop stochastic climate data in Kolars and others (2016). Column A is the weather station number, column B is the year in a stochastic simulation, column’s C through N are January through December PET values in millimeters, respectively. Simulations are stacked in order from 1 to 100 for each weather station. II. .\genprec.csv: This file contains stochastic monthly precipitation values for each weather station used to develop stochastic climate data in Kolars and others (2016). Column A is the weather station number, column B is the year in a stochastic simulation, column’s C through N are January through December precipitation values in millimeters, respectively. Simulations are stacked in order from 1 to 100 for each weather station. III. .\ grid_pet_stoch.csv: This file provides monthly stochastic PET values for each grid point used in the WBM presented in Kolars and others (2016). Column A is an unnamed index, column B, “lat”, is the latitude for a grid point, column C, “lon”, is the longitude for a grid point, column D is the year in a stochastic simulation, and columns E through P are the values of PET for January through December in millimeters, respectively. Simulations are ordered and placed on top of one another. IV. .\ grid_prec_stoch.csv: This file provides monthly stochastic precipitation values for each grid point used in the WBM presented in Kolars and others (2016). Column A is an unnamed index, column B, “lat”, is the latitude for a grid point, column C, “lon”, is the longitude for a grid point, column D is the year in a stochastic simulation, and columns E through P are the values of precipitation for January through December in millimeters, respectively. Simulations are ordered and placed on top of one another. V. .\PETMM_basinAv_stoch.csv: This file contains the Souris River Basin average PET for each month of the stochastic PET time series. Column A is an unnamed index, column B, “simnum” is the simulation number, column C, “yr”, is the year in a stochastic simulation, and columns D through O are the PET values in millimeters for January through December, respectively. VI. .\PrecipMM_basinAv_stoch.csv: This file contains the Souris River Basin average precipitation for each month of the stochastic precipitation time series. Column A is an unnamed index, column B, “simnum” is the simulation number, column C, “yr”, is the year in a stochastic simulation, and columns D through O are the precipitation values in millimeters for January through December, respectively.

This directory contains file for each of the 26 site locations required for simulation of streamflow in HEC-ResSim. Each file contains the 100, 100-year streamflow time series in monthly streamflow volume format. Streamflow volume is presented in cubic meters. In column A, there is a row number, column B is the month of the stochastic streamflow volume, column C is the year in the stochastic timeseries, column D is named “simnum” and is the simulation number, and column E is named “monthly_tot” and is the total streamflow volume for the given month, year, and simulation number in cubic meters.

This directory contains file for each of the 26 site locations required for simulation of streamflow in HEC-ResSim. Each file contains the 100, 100-year streamflow time series in monthly streamflow volume format. Streamflow volume is presented in cubic meters. In column A, there is a row number, column B is the month of the stochastic streamflow volume, column C is the year in the stochastic timeseries, column D is named “simnum” and is the simulation number, and column E is named “monthly_tot” and is the total streamflow volume for the given month, year, and simulation number in cubic meters.

A comprehensive study to evaluate water-quality trends in the International Souris River Basin, Saskatchewan and Manitoba, Canada and North Dakota, United States was completed by the U.S. Geological Survey (USGS) in cooperation with the International Joint Commission and International Souris River Board. This child page contains seven csv files, site_flow, which contain daily streamflow values for each site. Each file includes a station identifier, date of observation, measured value of streamflow and qualifier code for the measured value. The format of the csv file (date format and column headings) is designed to meet the specific requirements of file format for R-QWTREND. If csv files are opened directly in excel, the format of the data can change. To ensure the data are in the proper format for R-QWTREND, files should be opened in a text editor. The "site" in site_flow can be cross-referenced to the main report by navigating to the file siteinfo.table.csv.

A comprehensive study to evaluate water-quality trends in the International Souris River Basin, Saskatchewan and Manitoba, Canada and North Dakota, United States was completed by the U.S. Geological Survey (USGS) in cooperation with the International Joint Commission and International Souris River Board. This child page contains seven csv files, site_flow, which contain daily streamflow values for each site. Each file includes a station identifier, date of observation, measured value of streamflow and qualifier code for the measured value. The format of the csv file (date format and column headings) is designed to meet the specific requirements of file format for R-QWTREND. If csv files are opened directly in excel, the format of the data can change. To ensure the data are in the proper format for R-QWTREND, files should be opened in a text editor. The "site" in site_flow can be cross-referenced to the main report by navigating to the file siteinfo.table.csv.

A comprehensive study to evaluate water-quality trends in the International Souris River Basin, Saskatchewan and Manitoba, Canada and North Dakota, United States was completed by the U.S. Geological Survey (USGS) in cooperation with the International Joint Commission and International Souris River Board. This child page contains seven csv files, site_flow, which contain daily streamflow values for each site. Each file includes a station identifier, date of observation, measured value of streamflow and qualifier code for the measured value. The format of the csv file (date format and column headings) is designed to meet the specific requirements of file format for R-QWTREND. If csv files are opened directly in excel, the format of the data can change. To ensure the data are in the proper format for R-QWTREND, files should be opened in a text editor. The "site" in site_flow can be cross-referenced to the main report by navigating to the file siteinfo.table.csv.

This folder contains streamflow timeseries in cubic meters per second for each trace time series at each of the 26 site locations. In column A, there is a row number, column B contains “flow” and is streamflow in cubic meters per second, column C is the month that the streamflow occurs in the stochastic streamflow time series, column D is the year in a given stochastic time series, and column E is “simnum” which is the simulation number. The streamflow is ordered for each year in a timeseries and have 3 streamflow values for each month. The 3 streamflow for each month refer to the first, second, and third 10-day period in a month regardless of whether the month does or does not contain 30-days.

.\Spring 30 day\ I. .\GrantDevine_Comb.csv: This file contains the total inflow volume to Grant Devine Reservoir for the 30 days with the largest streamflow volume between March and May and the mean of the 3- and 12-month SPEI values for each November 1st. Spring streamflow volume for a given calendar year is paired with SPEI from the previous November 1st value. Column A is an unnamed index number, column B is a year in a stochastic simulation, column C is named “simnum” and is the stochastic simulation number, column D is named “mnspei” and is the mean of the 3- and 12-month SPEI for November 1 of each year in a stochastic simulation, and column E is named “SprintgThirtyTot” and is the total inflow volume for the 30 days with the largest streamflow volume between March and May of the following calendar year. II. .\LakeDarling_Comb.csv: has the same layout as .\GrantDevine_Comb.csv except that it is for local inflows to Lake Darling. III. .\Rafferty_Comb.csv: has the same layout as .\GrantDevine_Comb.csv except that it is for local inflows to Rafferty.