Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database
DOI:
https://doi.org/10.11137/1982-3908_2023_46_55179Abstract
Investment in sanitation and infrastructure is essential to ensure quality of human life, so its absence or fragility can lead to a scenario of calamities. Among the elements that constitute the infrastructure of a sanitation system is the technical register responsible for gathering all the information inherent to the system from the implementation of the network to the final destination of the effluent, provided for in the stages of design, execution and continuity of operations. As a result, GIS have become fundamental tools for the registration of sanitation networks, as they provide the integration of descriptive and graphic data in the same base. In this context, the objective of this study was the implementation of a database in free software through the SpatiaLite extension, aggregated georeferenced spatial information of components of a sanitary sewage network, producing a proposal for a Technical Registry. Processing was developed in the software QGIS 3.16, in which the elements of “Inspection Box” were used in the model, being represented vectorially by geometry of “Point” and “Extension” represented by “Line” to form a spatial system on the structure and location by means of vectorization on screen. As a result, the implementation of the register through the SpatiaLite platform, ensured fast processing, positional accuracy, conformity of cartographic representation, topology between classes, format consistency and completeness. However, the database enabled to analyze together all the components interrelated with the sewage system, through technical information for the management and efficiency of basic sanitation services.
References
ABNT NBR 12.586, de 30 de abril de 1992, Cadastro de sistema de abastecimento de água – Procedimento, Associação Brasileira de Normas Técnicas, São Paulo.
ABNT NBR 12.587, de 30 de abril de 1992, Cadastro de sistema de esgotamento sanitário – Procedimento, Associação Brasileira de Normas Técnicas, São Paulo.
Abraham, M. 2017, Encyclopedia of sustainable technologies, Elsevier.
Aragão, H.G. 2020, 'Desenvolvimento de um sistema de informação geográfica Web (SIG Web) para a área de saneamento básico utilizando tecnologias livres', Brazilian Journal Of Development, vol. 6, no. 2, pp. 6835-40, DOI:10.34117/bjdv6n2-108
Bonavita, G.D.O. & Fonseca, P.L. 2019, 'Análise de sistemas de microdrenagem', Labor e Engenho, vol. 13, pp. 19007-29, DOI:10.20396/labore.v13i0.8655745
Burrough, P. 1986, Principles of Geographical Information Systems for Land Resources Assessment, Clarendon Press.
Calijuri, M.C. & Cunha, D.G.F. 2013, Engenharia Ambiental: Conceitos, tecnologias e gestão, Elsevier Editora Ltda, Rio de Janeiro.
Caminha, P.R. 2005, 'O Cadastro Técnico Multifinalitário para controle de perda de receita numa Empresa de Saneamento', Dissertação, Universidade Federal de Santa Catarina, Florianópolis.
COMPESA 2021, Procedimentos para Cadastro de Sistema de Esgotamento Sanitário em Sistema de Informações Geográficas, Companhia Pernambucana de Saneamento.
Faria, M.T.S., Pereira, L.M.S.; Dias, A.P., Gomes, U.A.F. & Moura, P. 2022, 'Panorama dos Planos Municipais de Saneamento Básico e Planos Diretores de Drenagem Urbana em municípios de pequeno porte de Minas Gerais', Engenharia Sanitaria e Ambiental, vol. 27, no. 1, pp. 185-93, DOI:10.1590/s1413-415220200357
Massa, K.H.C., Chiavegatto Filho, A.D.P. 2020, 'Saneamento básico e saúde autoavaliada nas capitais brasileiras: uma análise multinível', Revista Brasileira de Epidemiologia, vol. 23, pp. 100-15, DOI:10.1590/1980-549720200050
Medeiros, D.L., Queiroz, L.M., Cohim, E., Almeida-Neto, J.A. & Kiperstok, A. 2020, 'Human urine fertiliser in the Brazilian semi-arid: environmental assessment and water-energy-nutrient nexus', Science of The Total Environment, vol. 713, pp. 136145-59, DOI:10.1016/j.scitotenv.2019.136145
Pereira, M.S., Magalhães Filho, F.J.C., Lima, P.M., Tabak, B.M. & Constantino, M. 2022, 'Sanitation and water services: who is the most efficient provider public or private? Evidences for Brazil', Socio-Economic Planning Sciences, vol. 79, pp. 101149-56, DOI:10.1016/j.seps.2021.101149
Rocco, J. 2006, 'Métodos e procedimentos para a execução e o georreferenciamento de redes subterrâneas da infra-estrutura urbana', Dissertação de Mestrado, Universidade de São Paulo.
Silva, S.A., Gama, J.A.S., Callado, N.H. & Souza, V.C.B. 2017, 'Saneamento básico e saúde pública na Bacia Hidrográfica do Riacho Reginaldo em Maceió, Alagoas', Engenharia Sanitaria e Ambiental, vol. 22, no. 4, p. 699-709, DOI:10.1590/s1413-41522017146971
SPATIALITE 2018, SpatiaLite - GeoServer 2.6.X User Manual.
Valdevino, D.S. 2010, 'Modelagem de dados espaciais para cartas de sensibilidade ambiental ao óleo no padrão OMT-G', Dissertação, Universidade Federal de Pernambuco.
Downloads
Published
Issue
Section
License
This journal is licensed under a Creative Commons — Attribution 4.0 International — CC BY 4.0, which permits use, distribution and reproduction in any medium, provided the original work is properly cited.