BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-europe-2025//talk//9CNP7
 Q
BEGIN:VTIMEZONE
TZID:CET
BEGIN:STANDARD
DTSTART:20001029T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:CET
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000326T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:CEST
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-europe-2025-9CNP7Q@talks.staging.osgeo.org
DTSTART;TZID=CET:20250717T140000
DTEND;TZID=CET:20250717T143000
DESCRIPTION:BSEQ originates from the need to provide the local government w
 ith a simple visualization tool to monitor water consumption per inhabitan
 t across different drought scenarios.\nDuring 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 l
 eaks\, and simulates consumption scenarios. In addition to these basic fun
 ctions\, GIS combined with PostGIS facilitates large-scale data processing
 \, aiding decision-making in real-world situations. Based on QGIS\, with i
 ts Giswater extension and PostgreSQL integration\, we already have a speci
 alized GIS for managing potable water supply and sewage networks. Therefor
 e\, analysing drought-related parameters is a logical progression toward i
 mproving water cycle management—an increasingly urgent issue in Spain\, 
 particularly in Andalusia and Catalonia. In these regions\, we are activel
 y collaborating with local administrations to mitigate the effects of this
  unprecedented drought. Unfortunately\, the information provided by GIS do
 es not always reach government teams clearly\, as processing the data requ
 ires significant time and technical expertise.\nThis is precisely why we d
 eveloped 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\, mun
 icipal registers\, and individual water consumption data—including detai
 ls such as the square meters of gardens and swimming pools on each propert
 y—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 unauthoriz
 ed occupations.\nBSEQ features a reporting system powered by the open-sour
 ce technology Apache Superset\, which allows for quick and intuitive graph
 ical analysis of results. This enhances decision-making while also providi
 ng the option to export data for further processing with other application
 s. The platform's web-based environment ensures easy access and transparen
 cy\, as it can be viewed from any browser with an internet connection.\nOu
 r philosophy is built on three core principles: simplicity\, speed\, and a
 ffordability. Implementing BSEQ in a corporate environment requires only t
 he aforementioned data\, which all municipalities should have easy access 
 to. Within a maximum of two weeks\, the system can process this data and b
 e fully operational.
DTSTAMP:20260527T222702Z
LOCATION:SA02
SUMMARY:BSEQ: A new approach to draught managing - Edgar
URL:https://talks.staging.osgeo.org/foss4g-europe-2025/talk/9CNP7Q/
END:VEVENT
END:VCALENDAR