Image of a barn with 2 grain silos in the background.




Attachment A

Recreation

Use Estimation Modeling (Webster Reservoir)

Use estimating models apply multiple regression techniques to estimate statistical relationships between recreation visitation and a wide range of explanatory variables, including reservoir water levels.

Monthly data on visitation by recreation activity from January 1980 to December 2000 was obtained from the reservoir manager at Webster. Recreation activities include camping, swimming, boating and waterskiing, picnicking, warm water fishing, and wildlife observation. Monthly information for the same time period was gathered on reservoir water levels, total monthly precipitation, and average monthly air temperature. Using this data, the following monthly model was statistically estimated for each activity.

Monthly Visitationam =

f (Year, WL, WL2, Precipitation, Temperature, Monthly Dummy Variables)
(?) (+) (-) (-) (+) (?)

where:

Activity: a = 1,...,l

Month: m = 1,...,n

(Note: Given the various recreation activities are pursued at different times of the year, each model was designed to reflect the sequence of months associated with that activity.)

Dependent variable: Total visitation in activity a in month m

Explanatory variables:

Year = Year of monthly data. This variable was intended to reflect a trend variable, used in lieu of socioeconomic variables. Expected sign: unknown. Both population and income could potentially affect recreation use. Populations in the adjacent counties to Webster have been fairly stable or even declining in recent years. Conversely, income levels have been gradually rising. The combined effect leads to an unknown sign for this variable.

WL = End of month (EOM) water levels measured in terms of feet above mean sea level. Expected sign: Positive. This implies that as WL increases, so would visitation. While this relationship typically holds across most water level ranges experienced by recreators, it may become negative at high water levels.

WL2 = EOM water levels squared. Expected sign: Negative. The positive and negative signs on the WL and WL2 variables produces a bell-shaped function where visitation increases, peaks, and decreases with increasing water level.

Precipitation = Total monthly precipitation in inches. Expected sign: Typically negative, but may be positive for some activities (e.g., fishing).

Temperature = Average monthly air temperature. Expected sign: Positive.

Monthly A series of qualitative (0,1) variables for each month of the recreation dummy season for each activity. Expected sign: unknown since certain months

variables = may be positive but others negative.

Information on average water levels by month for each alternative was modeled by Reclamation hydrologists. This water level information, along with historic monthly averages for temperature and precipitation, were multiplied by each model's coefficients to estimate visitation by activity and month for each alternative.

Model Selection

Model Selection Criteria

For each recreation activity, the following criteria were used to select the "best" model:

Significant Water Level Variable - Since water levels were the primary factor under control of reservoir managers, it was critical to have a significant water level variable within the model. Fortunately, many of the different models attempted resulted in significant water level variables. Significance was assumed at the 90 per-cent confidence level or higher (P[|Z|>z] column at .10 or lower).

Quadratic Water Level Term - Based on existing literature, it is generally hypothesized that the relationship between water level and recreation visitation would be bell-shaped. The quadratic function with a positive water level variable and a negative water level squared variable results in such a function.

Number of Significant Variables - In addition to the water level variables, the number of other significant variables influenced model selection.

Expected Signs - Based on the literature, a positive or negative relationship for each explanatory variable was assigned. Given these assumed relationships, statistically significant variables for each of the models were evaluated in terms of expected signs.

Coefficient of Determination (Adjusted R2) - A commonly used measure of the goodness of fit of the estimated function to the underlying data.

Model Selections

Based on a comparison using the above criteria, the following models for each activity at Webster Reservoir were selected as "best":

Camping.--

Dependent variable: Visits

Model is usable across the following water level range: 1859.2 feet to 1906.8 feet

Explanatory variables: # of observations: 105

Variable Coefficient Standard error b/St. Er. P[|Z|>z] Mean of x
Constant 354822.7751 173482.52 2.045 .0408  
Year -296.3978817 109.87287 -2.698 .0070 1989.5000
BOMWL 126.7400128 46.706119 2.714 .0067 1877.6407
Precipitation 32.70044294 70.770531 .462 .6440 3.2207000
Temperature 6.944888693 61.254679 .113 .9097 71.201900
May 4074.446294 550.01173 7.408 .0000 .20000000
June 1168.073708 641.13705 1.822 .0685 .20000000
July 3085.336261 920.61365 3.351 .0008 .20000000
August 380.8691822 737.86084 .516 .6057 .20000000
Adjusted R2: .438

Swimming.--

Dependent variable: Natural log of visits (Note: The analyst will need to take the antilog of predicted values to estimate predicted visits)

Model is usable across the following water level range: 1859.2 feet to 1906.8 feet

Explanatory variables: # of observations: 105

Variable Coefficient Standard error b/St. Er. P[|Z|>z] Mean of x
Constant -3759.311241 1795.0042 -2.094 .0362  
Year -.5732598252E-01 .28392320E-01 -2.019 .0435 1990.0000
EOMWL 4.097087466 1.9079447 2.147 .0318 1878.0247
EOMWLSQ -.1081492417E-02 .50719490E-03 -2.132 .0330 3527141.0
Precipitation .4501403316E-02 .17294803E-01 .260 .7947 3.1548571
May .6594524545 .11425951 5.772 .0000 .20000000
June 1.132850417 .13084576 8.658 .0000 .20000000
July 1.542211071 .13179640 11.701 .0000 .20000000
August .9473763819 .10688358 8.864 .0000 .20000000
Adjusted R2: .542

Boating and Waterskiing.--

Dependent variable: Visits

Model is usable across the following water level range: 1859.2 feet to 1906.8 feet

Explanatory variables: # of observations: 105

Variable Coefficient Standard error b/St. Er. P[|Z|>z] Mean of x
Constant -5146552.085 2982036.3 -1.726 .0844  
Year -35.78905901 49.040505 -.730 .4655 1990.0000
EOMWL 5508.238560 3169.9544 1.738 .0823 1878.0247
EOMWLSQ -1.453118055 .84263057 -1.725 .0846 3527141.0
Precipitation -23.64260068 28.560392 -.828 .4078 3.1548571
May 847.8021483 188.89729 4.488 .0000 .20000000
June 734.4946316 216.36550 3.395 .0007 .20000000
July 1573.479461 217.60418 7.231 .0000 .20000000
August 313.2592337 176.22141 1.778 .0755 .20000000
Adjusted R2: .356

Picnicking.--

Dependent variable: Visits

Model is usable across the following water level range: 1859.2 feet to 1906.8 feet

Explanatory variables: # of observations: 105

Variable Coefficient Standard error b/St. Er. P[|Z|>z] Mean of x
Constant -3115075.887 1338278.7 -2.328 .0199  
Year -24.74983097 22.528746 -1.099 .2719 1990.0000
EOMWL 3353.505998 1422.6853 2.357 .0184 1878.0247
EOMWLSQ -.8882077813 .37816244 -2.349 .0188 3527141.0
Precipitation 8.029640983 12.775827 .629 .5297 3.1548571
May -233.3972152 84.564392 -2.760 .0058 .20000000
June 396.3904697 96.862897 4.092 .0000 .20000000
July 826.8044319 97.327972 8.495 .0000 .20000000
August 143.4596040 78.757344 1.822 .0685 .20000000
Adjusted R2: .452

Warm Water Fishing.--

Dependent variable: Visits

Model is usable across the following water level range: 1859.0 feet to 1906.8 feet

Explanatory variables: # of observations: 168

Variable Coefficient Standard error b/St. Er. P[|Z|>z] Mean of x
Constant -36762946.49 13432311.0 -2.737 .0062  
Year -273.8889553 179.23775 -1.528 .1265 1990.0000
EOMWL 39569.52696 14283.125 2.770 .0056 1877.7470
EOMWLSQ -10.49048999 3.7969786 -2.763 .0057 3526097.2
Precipitation -76.40858263 112.94956 -.676 .4987 2.6613095
March 3166.588131 801.00385 3.953 .0001 .12500000
April 3083.055004 1018.6277 3.027 .0025 .12500000
May 13613.15019 1147.6526 11.862 .0000 .12500000
June 9605.154207 1157.3502 8.299 .0000 .12500000
July 13429.00363 1137.9147 11.801 .0000 .12500000
August 6756.056857 1016.0461 6.649 .0000 .12500000
September 4814.871100 774.62268 6.216 .0000 .12500000
Adjusted R2: .567

Wildlife Observation.--

Dependent variable: Natural log of visits (Note: The analyst will need to take the antilog of predicted values to estimate predicted visits)

Model is usable across the following water level range: 1858.8 feet to 1906.8 feet

Explanatory variables: # of observations: 252

Variable Coefficient Standard error b/St. Er. P[|Z|>z] Mean of x
Constant -5126.354997 1762.4121 -2.909 .0036  
Year -.4608436702E-01 .22522774E-01 -2.046 .0407 1990.0000
EOMWL 5.529904484 1.8746757 2.950 .0032 1877.3169
EOMWLSQ -.1463349982E-02 .49841533E-03 -2.936 .0033 3524484.8
Precipitation .2876909508E-02 .13462844E-01 .214 .8308 2.0393254
January .4327437941 .10232904 4.229 .0000 .83333333E-01
February .7639609739 .13153589 5.808 .0000 .83333333E-01
March 2.779239347 .14957801 18.581 .0000 .83333333E-01
April 2.775397396 .16112947 17.225 .0000 .83333333E-01
May 3.703280630 .17069896 21.695 .0000 .83333333E-01
June 3.440207178 .17005124 20.230 .0000 .83333333E-01
July 3.732954422 .17017754 21.936 .0000 .83333333E-01
August 3.216138944 .16207447 19.844 .0000 .83333333E-01
September 2.929993185 .14807000 19.788 .0000 .83333333E-01
October 1.938027154 .13007982 14.899 .0000 .83333333E-01
November .5397293507 .99376891E-01 5.431 .0000 .83333333E-01
Adjusted R2: .845

Facility Availability Analysis (Kirwin Reservoir)

The facility availability analysis used for Kirwin Reservoir forecasts recreation use by water- based activity through evaluation of changes in water access. Basically, the approach fore-casts the availability of water access facilities, such as boat ramps, marinas, and swimming beaches, using high- and low-end usability thresholds for each facility in conjunction with end-of-month water level forecasts by alternative developed by Reclamation hydrologists. Table A-1 lists water access facilities and their respective high- and low-end water usability thresholds.

Forecasted monthly availability of each facility is linked with estimates of historical visitation by facility and activity to estimate monthly visitation by activity and alternative. After linking forecasted facility availability by alternative with historical visitation by activity and facility, a final adjustment is made to account for possible movement of visitation between facilities (i.e., facility substitution). Table A-1 also provides information as to the percentage of use by facility at different water levels.

Given the approach centers on water access, only water-based activities, such as boating, fishing, and swimming, are evaluated. While land-based, but water-influenced activities, such as picnicking and camping, may be somewhat affected by fluctuating water levels, it was assumed the impact would be fairly negligible except with severe drawdowns. As a result, water-based activities were assumed to incur the majority of the impact. Furthermore,

Table A-1.--Recreation facility usability thresholds and percent of use by facility
  Facility usability thresholds Percentage of use by facility
(used to account for facility substitution)
Recreation facility
(boat ramps)
Low end High end Water level:
>1724.5 feet
Water level:
1720.5 feet to 1724.5 feet
Water level:
1695.5 feet to 1720.5 feet
South Shore
(Concessions Cove)
1725.0 1736.0 50 0 0
North Shore
(Cottonwood Cove)
1720.5 1735.0 40 50 0
Gary's Park 1724.5 1735.0 10 0 0
Rocky Flats 1695.5 1725.0 0 50 50
1 For the South Shore and Rocky Flats ramps, the usable range actually extends beyond the ramp since rocky areas around the ramps are often used for launching.
2 There are no marinas or beaches at Kirwin.

it was decided, in consultation with recreation planners working at Kirwin, that the primary impacts of fluctuating reservoir water levels would accrue to motorized boating and boat fishing. The assumption was made that shoreline activities, such as swimming and shoreline fishing, would not be significantly impacted by declining water levels since the recreators could simply walk out to the water if necessary. Potential impacts by recreation activity are summarized in table A-2. These assumptions, at least to some extent, limit the scope of the recreation analysis at Kirwin, but as noted previously, the lack of data precluded a full- scale modeling effort.

Table A-2.--Potential impact by recreation activity
Recreation activity Potential impact
Camping/picnicking Assumption was made that this would not be significantly affected given this is a land based activity.1
Swimming/boating Swimming and boating visitation figures have been collected in combination. It was estimated that 25% reflects boating and 75% swimming. Nearly all boating activity is motorized and makes use of the boat ramps. Swimming activity occurs in a dispersed fashion from shore. The assumption was made that shoreline activities would not be significantly impacted.
Warm water fishing Warm water fishing activity includes both boat based and shoreline activity (35% shoreline, 65% boat based). As with swimming, the impact to shoreline fishing was assumed negligible. Boat based fishing would vary with boat ramp availability.
Recreation activity Potential impact
Wildlife observation As with camping/picnicking, impacts to wildlife observation was assumed insignificant given this is a land based activity.
Hunting As with camping/picnicking, impacts to hunting was assumed insignificant given this is a land based activity.
1 All assumptions were developed in conjunction with on-site recreation planners.

Table of Contents Chapter 1 Chapter 2 Chapter 3
Chapter 4 Tables Figures Attachments