BSEQ originates from the need to provide the local government with a simple visualization tool to monitor water consumption per inhabitant across different drought scenarios.
During times of water scarcity, it is more crucial than ever to have a GIS system that displays an inventory of network assets, enables hydraulic balance calculations, identifies leaks, and simulates consumption scenarios. In addition to these basic functions, GIS combined with PostGIS facilitates large-scale data processing, aiding decision-making in real-world situations. Based on QGIS, with its Giswater extension and PostgreSQL integration, we already have a specialized GIS for managing potable water supply and sewage networks. Therefore, analysing drought-related parameters is a logical progression toward improving water cycle management—an increasingly urgent issue in Spain, particularly in Andalusia and Catalonia. In these regions, we are actively collaborating with local administrations to mitigate the effects of this unprecedented drought. Unfortunately, the information provided by GIS does not always reach government teams clearly, as processing the data requires significant time and technical expertise.
This is precisely why we developed BSEQ—an automated solution designed to address this challenge, recognizing that local administrations often lack the human resources to carry out such data analysis. By cross-referencing cadastral records, municipal registers, and individual water consumption data—including details such as the square meters of gardens and swimming pools on each property—BSEQ makes it easier to identify areas with high water usage potential. As a secondary benefit, this data integration also helps detect second homes, irregularities in the municipal register, and possible unauthorized occupations.
BSEQ features a reporting system powered by the open-source technology Apache Superset, which allows for quick and intuitive graphical analysis of results. This enhances decision-making while also providing the option to export data for further processing with other applications. The platform's web-based environment ensures easy access and transparency, as it can be viewed from any browser with an internet connection.
Our philosophy is built on three core principles: simplicity, speed, and affordability. Implementing BSEQ in a corporate environment requires only the aforementioned data, which all municipalities should have easy access to. Within a maximum of two weeks, the system can process this data and be fully operational.