Submitted by EngagingData t3_104804j in dataisbeautiful
Comments
smauryholmes t1_j33gbkk wrote
Really really cool. Going to share with a bunch of people at my work.
EngagingData OP t1_j33puar wrote
thanks! glad you are finding it interesting.
twisted_cistern t1_j33v4w7 wrote
Nice effort. Put the lake size in a logarithmic scale and we have a shot at reading the names of the smaller lakes
EngagingData OP t1_j33z5xu wrote
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
twisted_cistern t1_j34hleq wrote
Unless that's the reservoir for the 1% of the state in which you live
iohognbdfh t1_j33h8zx wrote
Haven't they had 3 massive rain events recently? Interested to see how this changes after all that adds in.
EngagingData OP t1_j33qz3s wrote
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.
Aberdogg t1_j34324t wrote
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
Aberdogg t1_j3438en wrote
Oh nm, your first comment gives the tools used. Thanks!
EngagingData OP t1_j3483wx wrote
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
Aberdogg t1_j34f8ut wrote
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
EngagingData OP t1_j34nip3 wrote
if you want something machine readable (csv or json) you can choose that here:
sakredfire t1_j3ft35q wrote
The cdec website is great and has all sorts of visualizations like these. California data exchange center - google it, highly recommended
EngagingData OP t1_j33cezs wrote
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.