It's ridiculously rainy here in California but reservoir levels in the state are still not to historical levels because of the prolonged drought we've been in.

Here's the interactive version, which is updated hourly

​

Data and Tools
The data on water storage comes from the California Department of Water Resources’ (DWR) Data Exchange Center. Python is used to extract the data from this page hourly and wrangle the data in to a clean format. Visualization was done in javascript, HTML and CSS and specifically the D3.js visualization library.

Really really cool. Going to share with a bunch of people at my work.

Haven't they had 3 massive rain events recently? Interested to see how this changes after all that adds in.

thanks! glad you are finding it interesting.

it's going up, but not that fast. In the last 10 days or so, Shasta, the biggest reservoir, has gone up from 1.44 million acre feet to 1.58 million acre feet. This increase is 3% of the total reservoir storage capacity.

Nice effort. Put the lake size in a logarithmic scale and we have a shot at reading the names of the smaller lakes

yeah, I tried something like that, but there are 48 reservoirs represented on the graph and so you aren't going to be able to read all of them regardless. I did add the ability to select which reservoirs to show on the graph (in the interactive version) which can let you visualize the smaller reservoirs.

But the overall goal was to show the amount of water in reservoirs so it's not that helpful if a tiny reservoir (amounting to less than 1% of state storage capacity) is full

Where do you get current data? My bookmark to water.ca.gov forces me to add a reservoir by code e.g. HHY for hetch hetchy to get the current levels then I’d have to have stored historical data for comparison

Oh nm, your first comment gives the tools used. Thanks!

In case you still need it, here's Hetch Hetchy storage data

https://cdec.water.ca.gov/dynamicapp/QueryDaily?s=HTH&end=2023-01-05

Yup that’s what was looking at but your python/js must grab the data and store it. That was what I was missing.

Great job on this

Unless that's the reservoir for the 1% of the state in which you live

if you want something machine readable (csv or json) you can choose that here:

https://cdec.water.ca.gov/dynamicapp/wsSensorData

The cdec website is great and has all sorts of visualizations like these. California data exchange center - google it, highly recommended