flows_cfs: Flow in cfs
In FlowWest/cvpiaFlow: Modeled Flow Data for the CVPIA SIT Model

A dataset containing the flow in cubic feet per second within watersheds for use with the CVPIA SIT Salmon Population Model to develop habitat inputs.

flows_cfs

dataframe with 985 rows and 33 variables:

date: CALSIM II date
Upper Sacramento River: C104
Antelope Creek: C11307
Battle Creek: C10803
Bear Creek: C11001*
Big Chico Creek: C11501
Butte Creek: C217A
Clear Creek: C3
Cottonwood Creek: C10802
Cow Creek: C10801
Deer Creek: C11309
Elder Creek: C11303
Mill Creek: C11308
Paynes Creek: C11001
Stony Creek: C142A
Thomes Creek: C11304
Upper-mid Sacramento River: C115
Bear River: C285
Feather River: C203
Yuba River: C230
Lower-mid Sacramento River1: C134
Lower-mid Sacramento River2: C160
American River: C9
Lower Sacramento River: C166
Calaveras River: C92
Cosumnes River: C501
Mokelumne River: C91**
Merced River: C561
Stanislaus River: C520
Tuolumne River: C540
San Joaquin River: C630

The flow is represented using 'FLOW-CHANNEL' and 'FLOW-DELIVERY' nodes from CALSIM II. The nodes and calculation for each watershed are outlined above.

The Sutter and Yolo Bypasses' flows are stored in a seperate dataset bypass_flows to enable the habitat segmentation in the bypasses according to weir locations.

The Lower-mid Sacramento River has two nodes, one above Fremont Weir (C134) and one below (C160). When calculating habitat for the Lower-Mid Sacramento river, calculate the habitat at each flow node and sum them proportion to the length of stream above and below the weir:

35.6/58 * (habitat at C134) + 22.4/58 * (habitat at C160)

*Because there are no modeled flows at Bear Creek, flows at Paynes Creek are used

**Mokelumne River flow is from a separate model provided by EBMUD.

CALSIM II schematic

Data Wrangling: Sadie Gill sgill@flowwest.com
Node Selection: Mark Tompkins mtompkins@flowwest.com and Mike Urkov mike.urkov@gmail.com
CALSIM Model Output: Michael Wright mwright@usbr.gov