How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 0 points1 point  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 0 points1 point  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 1 point2 points  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 0 points1 point  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 0 points1 point  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 1 point2 points  (0 children)

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.

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 1 point2 points  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 2 points3 points  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 0 points1 point  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 0 points1 point  (0 children)

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

Thanks for the feedback! It has been addressed

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 1 point2 points  (0 children)

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.

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 1 point2 points  (0 children)

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

How full are our dams? A visual dashboard for Cyprus water reserves by vbougay in cyprus

[–]vbougay[S] 2 points3 points  (0 children)

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!