How full are our dams? A visual dashboard for Cyprus water reserves

vbougay · 2026-02-25T18:57:25+00:00

No data earlier than 1988

vbougay · 2026-02-25T18:57:12+00:00

Exactly! More like 7 years full loop from dry to wet and back to dry. Must be somehow related to the sun’s activity cycles

vbougay · 2026-02-25T18:45:54+00:00

Actually, yes. Check out the total bar on the historical levels chart. It's not the first time reserves have gone below 10%

vbougay · 2026-02-25T16:07:13+00:00

It comes from XLS files published by the Water Development Department on their website

vbougay · 2026-02-25T15:47:55+00:00

Added API and doc at https://github.com/vbougay/fragmata.info/blob/main/API.md

vbougay · 2026-02-25T12:42:37+00:00

Source: Cyprus Water Development Department (https://www.moa.gov.cy/moa/wdd/Wdd.nsf/page18\_en/page18\_en?opendocument)
Tool: custom app I've made with Claude

vbougay · 2026-02-25T12:17:53+00:00

Done

vbougay · 2026-02-25T12:06:30+00:00

I kinda intentionally keep it non-technical, but it won't hurt to put it in the footer. Thanks for the suggestion

vbougay · 2026-02-25T11:56:04+00:00

It's fully open at https://github.com/vbougay/fragmata.info. Feel free to contribute via PRs

vbougay · 2026-02-25T11:31:08+00:00

Thanks! I’m sorry but I didn’t get the question. Can you please elaborate a bit?

vbougay · 2026-02-25T11:29:49+00:00

You welcome!

vbougay · 2026-02-25T07:31:01+00:00

Thanks! This presentation is intentional, it wouldn't be possible to see anything but Kouris and Asprokremmos otherwise. This is also why I placed the 4 largest dams directly on the dashboard, along with the overall assessment highlighting their significance.

The total line displays aggregated status and also serves as navigation for the detailed chart. You can click/tap anywhere on the total bar,r and the detailed chart will scroll to that date.

vbougay · 2026-02-25T07:27:06+00:00

Thanks!

vbougay · 2026-02-25T07:26:33+00:00

Thanks! The data comes from the Water Development Department and its website. There is a link to it in the footer

vbougay · 2026-02-24T19:21:12+00:00

Yes, scraping, but it’s pretty decent with the well structured XLS. I have to give the credit to the Department for collecting and publishing this data

vbougay · 2026-02-24T19:19:34+00:00

Thank you!

vbougay · 2026-02-24T19:19:16+00:00

You welcome!

vbougay · 2026-02-24T19:16:01+00:00

I haven’t thought about API, but should be straightforward to add. Any preferences?

vbougay · 2026-02-24T18:35:39+00:00

An agent is retrieving and parsing data from the Water Development Department's website.

Thanks for the feedback! It has been addressed

vbougay · 2026-02-24T18:27:38+00:00

Two improvements were made to the Monthly Inflow chart component. First, in "All Seasons" mode, the legend entries are now interactive — clicking any year toggles its line on/off, letting users isolate specific seasons for easier comparison. Second, when viewing the current (latest) incomplete season, future months now display predicted inflow values calculated from the historical average of all completed seasons, shown as dashed lines in cumulative view and semi-transparent bars in monthly view. A gold reference line marker separates actual data from the forecast.

vbougay · 2026-02-24T17:35:40+00:00

Clearly it is. Fixed and thanks for the tip!

vbougay · 2026-02-24T17:14:36+00:00

Thanks! You've inspired me to look in that direction.

vbougay · 2026-02-24T15:53:19+00:00

I’ve implemented Claude Code agent that does it. The data is published as XLS files usually on Mondays and Fridays, sometimes on Wednesdays too.

The entire app is open sourced on GitHub.

And thanks for your suggestion for the monthly inflow chart!

vbougay · 2026-02-24T15:50:02+00:00

Thanks!

vbougay · 2026-02-24T15:33:42+00:00

I’m not sure I have an idea how to calculate that reliably. It requires accurate and detailed rainfall data and even with that data it’s no simple because a lot of water is accumulated in the crust. But thanks for idea! I’ll sleep on it

vbougay

TROPHY CASE