Monitoramento da qualidade da água de consumo humano em Belém-PA/: uso de dashboards visando aprimorar a gestão municipal

Abstract

The present study aims to monitor water for human consumption in the Municipality of Belém/PA through dashboards, which are visual panels where relevant information is condensed and presented to facilitate data analysis. The idea of the work is to develop a strategic tool for monitoring the quality of water for human consumption for the Municipality of Belém/PA that is dynamic and interactive, considering data from the Water Quality Surveillance Information System (SISAGUA). The methodology used consisted of 3 distinct stages. In stage 1, monitoring data were extracted from the SISAGUA system, referring to the variables residual free chlorine, turbidity, total coliforms and Escherichia Coli, registered between the years 2018 and 2023. In stage 2, with the data extracted in Excel spreadsheet format, The physical-chemical index (IFQ) for turbidity and free residual chlorine was determined, with the aim of evaluating whether the water meets the maximum permitted values. For the variables Total Coliforms and Escherichia Coli, whose laboratory results are presence or absence, the bacteriological index (BI) was calculated to assess whether the water meets the bacteriological standard for potability. In stage 3, dashboards were created to assist in monitoring water for human consumption, using the Microsoft Excel program, through which it is possible to observe and make comparisons with current potability criteria. For the water supply system (SAA), 3,518 samples were extracted, and for collective alternative solutions (SAC), 785 samples were extracted. The designation of these forms of supply as SAA or SAC is the responsibility of Environmental Surveillance when entering the data into SISAGUA, according to the criteria established in the potability ordinance. The results at the station outlet showed that the IFQ for free residual chlorine ranged from 34.02% to 66.67%, while in the distribution network it ranged from 18.40% to 35.60%, both below the ideal IFQ of 100%. The results at the station outlet showed that the IFQ for turbidity ranged from 82.86% to 100%, while in the distribution network it ranged from 92.96% to 95.06%. The results at the station exit showed that the BI for Escherichia coli ranged from 86.05% to 96.67%, while in the distribution network it ranged from 86.10% to 90.54%, values below the ideal BI of 100%. There were worrying non conformities in relation to residual free chlorine and Escherichia coli, as these are important indicators of the sanitary quality of the water. This demonstrates the advantage of using a dashboard compared to traditional reports. The use of this tool by the Health and Environmental Surveillance of the Municipality of Belém/PA can positively contribute as an instrument to support municipal management, facilitating decision-making and monitoring water for human consumption.