Wyoming State Water Plan, Wyoming Water Development Office
Rafting on Snake River Lake Marie, Snowy Mountains Wyoming Wind River Range picture

Bear River Basin Water Plan
Final Report

5.0 Available Water Determination

Water supply planning requires consideration of many factors, including hydrology, water quality, physical facilities, and legal and institutional requirements. Surface water spreadsheet models were developed to:

Existing mapping and previous ground water studies and planning documents were reviewed and summarized into a discussion on the potential for additional ground water development. Existing well locations and yields were important in projecting future ground water development opportunities.

5.1 Surface Water Spreadsheet Models

The Bear River Spreadsheet Model is a complex system of spreadsheets which incorporate diversions, reservoirs, streamflow gaging stations, and historic legal and institutional constraints. Individual spreadsheet models were developed which reflect each of three hydrologic conditions: dry, normal, and wet year water supply. Each model relies on historical data from the 1971 to 1998 study period to estimate the hydrologic conditions.

Although the models do not explicitly account for water rights or compact allocations, historic operations based on these constraints are represented by the models. The individual models were used to identify water that could be put to future use in the Bear River Basin based on physical and legal availability. The development of the models relied on the following information, discussed in previous sections:

The models were developed in Microsoft Excel 2000 with a user-friendly menu-driven approach that will allow the State of Wyoming to easily update and maintain the model and to make initial assessments of water development projects proposed in the future. Figure 27 shows the Bear River Basin Planning Model initial screen. This interface directs the user to the individual spreadsheet for each hydrologic condition. Appendix P provides a detailed memorandum on the spreadsheet development and use.


Figure 27
Bear River Planning Model Initial Screen

5.1.1 Surface Water Spreadsheet Model Development

To mathematically represent the Bear River system, the river system was divided into twelve reaches based primarily on the location of USGS streamflow gaging stations. These reaches are shown in Figure 28, which is a screen captured directly from the spreadsheet models.

Other key locations, such as reservoirs or confluences with major tributaries, were also used to determine the extent of reaches. Each reach was then sub-divided by identifying a series of individual nodes representing locations where diversions occur, tributaries converge, or other significant water resources features are located.


Figure 28
Bear River Spreadsheet Model River Reaches

At each node, a water budget, or mass balance, computation is completed to determine the amount of water that flows downstream out of the node using the following mathematical equation:

where:

Total flow into the node and diversions or other losses from the node are calculated. At non-storage nodes, the difference between all inflows and outflows is the amount of flow available to the next node downstream. For storage nodes, an additional loss calculation for evaporation and the change in storage are evaluated. Mass balance calculations are repeated for all nodes in a reach, with the outflow of the last node being the inflow to the top node in the next reach.

5.1.2 Input Worksheets

The spreadsheet models represent 100 percent of the surface water use on the Bear River mainstem in Wyoming, either as explicit key structures or aggregate structures described in Section 3.2.1. In addition, water use from Smith's Fork, and Sulphur Creek are also modeled. Sulphur Creek, and Woodruff Narrows Reservoirs are represented in the model. Other Bear River tributaries, not administered under the Bear River Compact, are not specifically modeled, but are represented by gaged and ungaged streamflows.

Specific inputs used by the model to calculate the basin water balance include:

Because the Bear River Compact accounting requires total diversions within the Upper and Central Divisions, diversions in the Utah portions of the Upper Division and diversions in the Idaho portion of the Central Division were represented in the modeling effort as aggregate structures. Specific details regarding the inputs to the spreadsheet model are included in Appendix P.

5.1.3 Results Worksheets

Results of the surface water spreadsheet models are provided in tabular form. The "Outflow Calculations: By Node" table summarizes the net flow for each node. The nodes are grouped by reach and a comparison of simulated flows with historic gaged flows are provided at USGS streamflow locations.

The "Summary of Diversion Calculation: By Node" table summarizes the computed diversion at each node. In addition, the "Comparison of Estimated vs. Historic Diversions" table presents comparison results and indicates any shortages occurring to target diversion volumes.

An effort was made to incorporate sufficient detail in the spreadsheet models to determine whether water emergency conditions exist as defined in the Bear River Compact for either the Upper or Central Divisions. The Water Commissioners worksheets for both divisions were computerized and all appropriate flows and diversions were tabulated. These tables determine whether an emergency condition exists; however, no attempt was made in the model to restrict diversions based on this determination. Figure 29 shows the "Bear River Commission Water Allocation: Central Division" table from the wet year spreadsheet model.


Figure 29
Bear River Spreadsheet Model Water Allocation Table

The results were reviewed, and compared to historic trends and known operations. This was to assure that the models provide a basis for assessing available water during dry, normal, and wet hydrologic conditions. The procedures and results are detailed in the "Surface Water Calibration" memorandum provided in Appendix P. This review determined that the Bear River Basin Spreadsheet Model can be used to reasonably estimate water availability in various reaches of the river during dry, normal and wet conditions on a monthly basis.

5.2 Surface Water Availability

An effort was made to incorporate sufficient detail in the spreadsheet models to determine whether water emergency conditions exist as defined in the Bear River Compact for either the Upper or Central Divisions. In addition, output tables were developed that would help facilitate the assessment of available water. The following general procedures were followed to assess surface water availability:

A detailed discussion on available water and compact and administration constraints to development of that water is provided in the "Task 3D Available Surface Water Determination" memorandum provided in Appendix P.

5.2.1 Upper Division Available Flows

Table 19 shows the water availability for the Upper Division. The table presents the following information for dry, normal, and wet year hydrologic conditions:

Table 19
Bear River Basin Water Availability - Upper Division

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1. Flow below Pixley Dam (AF)
Dry 1,972 1,665 3,744 3,934 1,693 7,601 6,842 2,572 1,492 1,735 2,255 1,959
Normal 4,745 4,836 11,520 18,627 40,023 38,213 25,526 9,038 5,950 6,162 5,932 5,260
Wet 6,098 7,736 20,226 32,192 83,950 92,935 40,990 20,293 18,027 15,040 13,319 8,975
2. Total Divertiable Flow (AF)
Dry - - - - 56,919 83,905 33,057 12,208 7,619 - - -
Normal - - - - 95,910 140,578 76,958 23,128 19,250 - - -
Wet - - - - 144,576 213,983 90,951 35,618 28,889 - - -
3. Min. Compact Flow Required (AF) 0 0 0 0 76,861 74,381 76,861 76,861 74,381 0 0 0
(cfs) 0 0 0 0 1,250 1,250 1,250 1,250 1,250 0 0 0
4. Available Flow for WY (AF)
Dry 1,972 1,665 3,744 3,934 0 9,524 0 0 0 1,735 2,255 1,959
Normal 4,745 4,836 11,520 18,627 19,049 66,197 97 0 0 6,162 5,932 5,260
Wet 6,098 7,736 20,226 32,192 67,715 139,602 14,090 0 0 15,040 13,319 8,975
5. Preferable Reaches 7,8,3,4,5 7,8,3,4,5 7,8,3,4,5 7,8,3,4,5 4,5,6,7 4,5,6,7 4,5,6,7 none none 7,8,3,4,5 7,8,3,4,5 7,8,3,4,5
Notes:
  1. Flow below Pixley Dam is gage 10028500 Bear River below Pixley Dam. This constitutes the flow out of the Upper Division.
  2. Total Divertible Flow is combined diversions (present development) of Wyoming and Utah in Upper Division including flow below Pixley Dam (1,250 cfs limit).
  3. Minimum Compact Flow is minimum of flow above 1,250 cfs (Total Divertible Flow, including Pixley Dam release) or zero for non-irrigation season.
  4. Available Flow is physically available flow, based on present development, above required Compact flows, which is flow in item 1 during non-irrigation season or flow in item 2 minus item 3 in irrig. season.
  5. Preferable reaches are stream reaches where flow physically occurs, but may be impacted by potential projects in other reaches of this division.

Figure 30 shows the total available monthly flow in the Upper Division for dry, normal, and wet hydrologic years.

Figure 30
Upper Division Available Monthly Streamflow during Dry, Normal, and Wet Hydrologic Years

The following summarizes the Upper Division available flows:

5.2.2 Central Division Available Flows

Table 20 shows the water availability for the Central Division. The table presents similar information to the Upper Division table for dry, normal, and wet year hydrologic conditions as follows:

Table 20
Bear River Basin Water Availability - Central Division

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1. Flow at WY/ID Border (AF)
Dry 8,348 7,587 12,348 13,549 18,140 22,467 14,131 6,274 5,638 6,792 8,400 8,060
Normal 14,320 14,374 28,460 55,596 89,113 91,543 50,541 19,337 13,898 17,291 16,919 15,260
Wet 18,950 22,400 51,690 75,760 156,070 218,602 81,847 37,510 32,103 34,320 32,543 24,390
2. Flow below Stewart Dam (AF)
Dry 581 644 624 451 490 666 663 796 706 721 407 309
Normal 299 291 485 378 646 2,506 1,004 691 949 659 513 422
Wet 188 201 495 430 11,587 20,122 13,762 640 742 511 384 314
3. Total Divertiable Flow (AF)
Dry - - - - 35,843 43,034 29,962 15,945 10,623 - - -
Normal - - - - 106,795 121,001 77,046 36,155 24,631 - - -
Wet - - - - 197,323 257,533 110,055 57,043 43,434 - - -
4. Min. Compact Flow Required (AF) 21,521 19,438 21,521 20,827 53,495 51,769 53,495 53,495 51,769 21,521 20,827 21,521
(cfs) 350 350 350 350 870 870 870 870 870 350 350 350
4. Available Flow for WY (AF)
Dry 0 0 0 0 0 0 0 0 0 0 0 0
Normal 0 0 6,939 34,769 53,300 69,232 23,551 0 0 0 0 0
Wet 0 2,962 30,169 54,933 134,549 197,775 56,560 3,548 0 12,799 11,716 2,889
6. Preferable Reaches none 9,11,12 9,11,12 9,11,12 9,11,12 9,11,12 9,11,12 9,11,12 none 9,11,12 9,11,12 9,11,12
Notes:
  1. Flow at WY/ID Border Gage is gage 10039500 Bear River at Border, above Idaho diversions.
  2. Flow below Stewart Dam reported by PP&L, is referenced in compact as part of other minimum of 870 cfs in item 4.
  3. Total Divertible Flow is combined diversions (present development) of Wyoming and Idaho in Central Division plus flow below Stewart Dam.
  4. Minimum Compact Flow is minimum of flow above 350 cfs at Border Gage or flow above 870 cfs (Total Divertible Flow, including Stewart Dam release).
  5. Available Flow is physically available flow, based on present development, above required Compact flows, which are minimum of flow in item 3 above 870 cfs or flow in item 1 above 350 cfs.
  6. Preferable reaches are stream reaches where flow physically occurs, but may be impacted by potential projects in Upper Division and potential projects in other reaches of this division.

Figure 31 shows the total available monthly flow in the Central Division for dry, normal, and wet hydrologic years.

Figure 31
Central Division Available Monthly Streamflow
during Dry, Normal, and Wet Hydrologic Years

The following summarizes the Central Division available flows:

5.2.3 Use of the Bear River Spreadsheet Model

Direct Diversion Assessment

The spreadsheet modeling effort shows that there is not a reliable year-round source of water for a new diversion in most years. The model can be used to identify the shortages for a proposed water use that may be supplemented by purchase of existing storage shares or ground water. In addition, the model can be used to determine the increased available flow due to retirement of existing diversions.

Storage Assessment

Based on the results of the spreadsheet modeling effort, new surface water uses will likely require storage. There is essentially no available water for diversion during dry years. In addition, storage is required for normal and wet years if future water use is to occur in other than the high runoff months.

There are limitations and restrictions to additional storage outlined in the Bear River Compact. These have been summarized in Section 2.2.1 and discussed in detail in the storage memorandum included in Appendix I. Although these restrictions are difficult to assess basin-wide, the spreadsheet model can be used to screen new storage projects and determine if they meet the Compact requirements for additional storage.

5.3 Ground Water Availability

The ground water resources technical memorandum, attached as Appendix O, provides an analysis of the geology and associated aquifer systems in the Bear River Basin. The following general approach was used to identify the potential for future ground water development in the Bear River Basin in Wyoming:

  1. Existing hydrogeologic reports and basic data were collected and summarized

  2. Available data was compiled into graphical decision-making tools (GIS coverages)

  3. The collected and complied data was used to analyze the ground water resources

Existing reports, identified in Appendix O, were helpful in understanding the hydrogeology in the basin, however, the primary source of data used to analyze ground water development potential came from the USGS Ground Water Site Inventory (GWSI) database and the Wyoming State Engineer's Water Well Inventory database. Information stored in these databases include:

5.3.1 Data Compilation and Use

Information stored in both databases pertain to specific geographic points, i.e. well locations. Therefore, their usefulness as a tool for understanding ground water issues was greatly enhanced by placing them into a GIS format. GIS point coverages were created from both the GWSI database and the State database showing the location of the wells and springs. The attributes from the respective database are assigned to each point in the GIS coverages, and maps were generated as analysis tools.

Because data are limited, the GIS coverages are useful tools with which to base general conclusions concerning the ground water resources in the basin. Planners can use the tool to identify the aquifers that have been developed in the vicinity of proposed new developments. Qualified hydrogeologists can use the coverage to extrapolate the data and come to more educated conclusions concerning site specific aquifer potential. Note that site specific investigations will still need to be done to come to more definite conclusions concerning a specific area's ground water development potential.

5.3.2 Well Yield

Well yield is important to consider when planning the number of wells for development. Well yield can be defined as the maximum rate at which a well can pump without lowering the water in the well below the pump intake. The maximum amount a well can produce is a function of well construction; aquifer characteristics; and the location, number, and pumping amounts of nearby wells. Well yield is also a function of how long the well is pumped. Since these data are scarce, reported well yield data were used as a subjective measure of the physical well potential from various aquifers. Reported well yields are either permitted amounts; instantaneous measurements by the pump installer (a function of the pump size); or actual long-term test data. Reported well yields are used as a measure of well yield considering the following qualifying assumptions:

Figure 32 shows the database coverage of reported well yield ranges in the basin. Based on the available information, it appears that


click to enlarge

5.3.3 Long-term Aquifer Yield

The physical ability of an aquifer to produce water is a function of the same aquifer properties that are important in determining well yield. In addition, long-term aquifer yield is a function of the amount of recharge that occurs. If pumping exceeds recharge, aquifer dewatering (lowering water table) will result and yields will diminish. Recharge includes:

Any reduction in these inflows will eventually reduce the long-term yield and development potential of ground water in the basin.

Alluvial Aquifer Yield

The Bear River alluvial aquifer is defined as the aquifer that consists of saturated stream alluvium generally within 2 miles of the Bear River. Wells in the alluvial aquifer can sustain high well yields because aquifer drawdown is minimized by recharge from Bear River surface water. Because of this, long-term well yield is probably not constrained by declining aquifer water levels. Additional aquifer development is possible as long as water from the Bear River is available for recharge. The amount of additional development that can occur is dependent on assuring that existing water rights and interstate compacts are satisfied. Therefore, the quantity of water in the alluvial aquifer available for development is equal to the amount of surface water available to augment surface water depletions due to that development. In other words, the available surface water identified in Section 5.2 is the total that can be consumed from river withdrawals and alluvial aquifer wells combined.

Bedrock Aquifer Yields

Aquifers that are not within the stream alluvium are generally referred to as bedrock aquifers. Producing wells have been identified in at least 17 different bedrock formations. Limited recharge and relatively low permeability are the primary reasons why most bedrock aquifers have low well yields and low long-term aquifer yields. Bedrock aquifer recharge generally consists of effective precipitation and seepage between aquifers. These amounts are usually low. Therefore, additional bedrock development could exceed these inflows and cause unacceptable water level declines or reduced spring yields. As discussed in Appendix O, it is conservatively estimated that around 14,000 acre-feet per year can likely be removed from bedrock aquifers without causing a decrease in overall aquifer storage.

Like alluvial aquifers, the ground water development potential for bedrock aquifers is also constrained by depletions to the surface water system caused by pumping. Additional withdrawals could reduce spring discharges to unacceptable levels. Bedrock pumping also reduces the amount of subsurface recharge to the alluvial aquifer, which discharges into the Bear River. Bedrock well depletions take longer to occur the further away (distance and depth) the well is from the surface water system. However, the amount of additional development that can occur is also dependent on assuring that existing water rights and interstate compacts are satisfied.

5.3.4 Ground Water Availability Summary

Current ground water withdrawal estimates indicate that, on average, less than 3,000 acre-feet per year of ground water is currently used in the Bear River Basin. The majority of this use is from the alluvial aquifer. Future development of this aquifer could provide additional water to meet increased demands, however there are limitations and restrictions to additional depletions outlined in the Bear River Compact. These restrictions consider withdrawals from the alluvial aquifer similar to river withdrawals.

It is estimated that additional development in the bedrock aquifers up to 14,000 acre-feet per year would be sustainable. Well development in the bedrock aquifers needs to be studied in greater detail to determine the impact on Bear River flows and the extent to which compact restrictions may apply.