With increasingly heavy rainfall and climate change, the need to control and monitor the infrastructure that removes surface water in urban areas has become increasingly important. In urban areas, there are many "hard surfaces" such as asphalt, concrete and roofs.

Our customer has deployed sensors in a number of basins, collection basins and stream inlets. Together, this forms a network of sensors that monitor the infrastructure and uncover bottlenecks and capacity challenges. We have also developed alerts for when basins need to be emptied or cleaned due to poor throughput.

These sensors send data streams in various formats, which are not necessarily designed for data analysis. We have taken all these data streams, collected them in a data lake and distributed them in a medallion architecture. Where data in the gold lake is data that can be used in further analysis.

We have also collected meteorological data and weather forecasts into the same system and can use machine learning to predict where there may be floods or bottlenecks.

The solution is a SaaS solution based on MS Azure, Databricks and PowerBI.