A New Data Acquisition Portal for the Sacramento River Settlement Contractors
In 1964, the United States Bureau of Reclamation (Reclamation) executed settlement contracts with the Sacramento River Settlement Contractors (SRSC), entities which hold water rights along the Sacramento River with area of origin protection or that are senior to Reclamation's water rights for Shasta Reservoir. Shasta is the cornerstone of the federal Central Valley Project (CVP), one of the nation's largest multi-purpose water conservation programs. In order to optimize CVP operations for multiple beneficial uses including water supply, fisheries, water quality, and waterfowl habitat, the SRSC voluntarily agreed to adaptively manage diversions throughout the year in close coordination with Reclamation. MBK Engineers assists the SRSC throughout this process by collecting, organizing, compiling, and distributing diversion data to Reclamation and others involved in operational decisions related to Shasta Reservoir and the CVP.
To improve and expand participation in diversions reporting, we have developed the SRSC Web Portal, which launches a data-entry dashboard for members of the SRSC to facilitate recording and transmittal of both predicted and observed monthly and daily flow diversion data. This cloud-hosted system leverages a combination of Javascript interactive visualization libraries with a database-backed Python web framework to present streamlined data-entry forms and valuable SRSC program summary illustrations. SRSC program totals, which can now be aggregated through queries to the web-app's database backend, are used by Reclamation, SRSC, fish agencies, and others to inform operational decisions. By submitting diversion schedules and tracking actual diversions through the portal, contractors will also be directly contributing to the development of a richer and more consistently-formatted historical record for demand hydrology in the Sacramento River Watershed; this may be useful in future water supply studies. Adoption of this technology will foster an increased appreciation for the historical record of individual and combined Sacramento River diversions relative to the overall system.