Evaluating Transportation Impacts Due to Enhancing Salmon Habitat Along the Snake River in the State of Washington

Abstract

Studies are currently underway to evaluate the feasibility of lowering water levels in several dams along the Snake River to facilitate enhancing salmon spawning runs in the river. The resulting elimination of barge traffic may impact other modes of transportation in the State of Washington including rail, truck, and alternate barge routes for the transport of goods to and from the eastern Washington area. This paper presents an integrated approach to evaluating these potential impacts using three major tools: a linear programming module to MS Excel, MS Access, and ArcView GIS for analysis and display of results.

Introduction

During the later part of this century, the Federal Government constructed numerous dams in the Western United States. These were constructed for hydropower, flood control, irrigation, and navigation. Four of these dams were constructed along the Snake River in Eastern Washington. These allowed barge traffic to utilize the Snake River from as far inland as Lewiston, Idaho to Portalnd and the Pacific Ocean. These dams also had the effect of hindering salmon migration along the river.

Based on the decline of the population of the sockeye and chinook salmon along the Snake River, the Federal Government listed the two fish as endangered under the Endangered Species Act. As one possible means of preventing extintion of these species, the federal Government is investigating the permanent drawdown of the four dams along the Snake River. These dams are the Ice Harbor, Lower Monumental, Little Goose, and Lower Granite. This paper presents a portion of the methodology used to evaluate the impacts on transportation systems by this proposed alternative.

Location Map

Figure 1 - Location Map

Transportation Impacts

Currently 4.4 million tons of commodities are barge annually along the Snake River. These commodities include wheat, barley, wood products, containers, petroleum, and fertilizers. Wheat and barley alone make up 3.2 million tons of the total barged along the river. Following a permanent drawdown of the four dams along the river, these commodities will require an alternative means of transportation. These alternative mdens of transportation include trucks via highway, railroads, and barge traffic at locations further downstream of the dams to be drawndown.

Methodology

In order to evaluate the impacts on the transportation systems in eastern Washington, a model was developed that would allow analysis of traffic patterns both before and after drawdown of the dams. This model was based on previous work done by the Washington State University. The previous model was created in the GAMS programing language and consisted of a linear program specifing the production of wheat at various locations throught eastern Washington, the unit cost of trucking wheat to various location in the system such as local and regional elevators, railroad stations, and river ports for barges. Also included in the model were unit costs for shipping by rail and barge to the various locations including the final destination of Portland.

production Locations

Figure 2 - Location of Wheat and Barley Production Locations

Constraints were also included in the model to represent maximum allowable rail traffic and barge traffic at selected location. These allowed the before and after analysis of impacts on the transportation system. The model first found the optimal means of transporting all wheat to Portland at minimal cost under existing conditions, then the constraints were modified prevent any barge traffic upstream of the four dams and re-run. The difference between the two runs were then used as potential impact of the proposed drawdown on the transportation system. HDR Engineering, Inc. was hired to review the previous model and make recommendations to update the model and include revised figures available in 1998. It was decided first to rewrite the model in an Excel spreadsheet using a commercially available optimizer add-in called "What's Best". The ease of developing and modifing the model in Excel proved invaluable in revisions and analysis that would have been far more difficult in GAMS. As an added benefit, the spreadsheet format is easier to read, print, and integrate into a database, especially to the user unfamiliar with GAMS.

Integrating GIS in the Analysis

Several revisions were made to the model uaing the ArcView GIS program. The previous model had used ArcPlot to find routes from each production center to various destination locations along a road coverage. The arcs traversed along these routes were summarized in table which consisted of each route number and every arc id associated with it. This table had almost 1.5 million records. Display of the previous model was done using ArcPlot and dynamic segmentation.

For the revised model, numerous routes had to be added to the model to assure the full impact of the drawdowns were represented. The Network Analyst extensison was use to find the shortest route from the two points specified and an Avenue script identified each arc associated with that route. These values were then added to the original table for later analysis.

Route Analysis

Figure 3 - Alternative Route Analysis

Once the optimization model was run in Excel, the results were summarized in a table consisting of the total amount of wheat for each available route in the model. The result required the total amount trucked (or shipped by rail or barge) for each segment of the road network. This was quickly done using an Access database. The two tables involved were the table listing the routes with assciated road arcs and the table of total traffic by route. These tables were then joined via the route field and summarized by the arc id. Figure-4 shows the design of the Access query that accomplished this operation.

Attribute Table

Figure 4 - Totaling Results by Road Segment

Displaying Model Results

Through the use of an ODBC connection to Access, the table listing the total traffic for each road segment was joined to the road coverage of the area. This allowed a visual display of results on a standard ArcView interface. The display used a graduated red line symbol to show the total traffic keyed to the width of the line symbol. A dramatic display of the pattern of truck traffic was easily created in this manner. Figure-5 shows the traffic under the existing conditions while Figure-6 show the traffic pattern after the proposed drawdown. The obvious relocation of traffic to the west or downstream of the Snake River is evident.

Existing Traffic

Figure 5 - Estimated Truck Traffic (Existing Conditions)

Drawdown Results

Figure 6 - Estimated Truck Traffic (After Drawdown)

Additional Analysis

In addition to the standard display of total truck traffic on the ArcView interface, the difference in total truck traffic for each segment could also be displayed. Figure-7 shows this difference with an incerase in traffic shown in red with a decrease in traffic shown in green. This allows a visual display of the areas most impacted by the proposed drawdown.

As an added result of the linear programming model, a dual value is also computed for each constraint in the model. For the contraint of total wheat shipped must equal the total wheat produced, the dual value gives the transportation cost from each production zone. These values can be directly joined to the shapefile of the production zones to show the increase in transportation costs for each area in the state. Figure-8 shows the relative increas in transportation cost by production location. The maximum increas shown is approximately 9 percent. The display shows what was expected, i.e. the greatest impact occurs the further upstream along the Snake River.

The model was also used in a similar fashion to analyze and display the impacts of the proposed drawdown all the other commodities currently barged along the Snake River. Similar methods were used to display the impacts on rail traffic and barge traffic.

Traffic Difference

Figure 7 - Difference in Truck Traffic

Traffic Difference

Figure 7 - Increase in Transportation Costs

Summary and Conclusions

Using the results of the analysis described in this paper the total costs associated with the proposed drawdown of the four dams along the Snake River in Eastern Washington were estimated due to numerous factors including infastructure improvements, paving thickness, interchange improvements, and impacts to local traffic in the cities located downstream of the dams in question. Improvements required to upgrade the railroad system in the area were also analyzed to estimate the cost to handle increases in their systems. The use of an integrated approach using Excel, Access, and ArcView GIS allowed a simplified interface for analyzing and displaying the results and comparing various alternatives in the project. The methods described here could also be used for other studies and would not be limited to transportation studies.

Author

Bruce Rindahl, Water Resources Project Manager
HDR Engineering, Inc.
303 E 17th Ave. Suite 300
Denver, CO 80203
Phone: (303) 764-1552
Fax: (303) 890-7139
E-mail: brindahl@hdrinc.com