BANCO DE DADOS GEOGRÁFICOS PARA GESTÃO INTEGRADA APLICADA AO SANEAMENTO BÁSICO EM UM BAIRRO DA METRÓPOLE DA AMAZÔNIA

Abstract

Basic sanitation aims to achieve four aspects of providing essential services to society: water supply, sanitary sewage, rainwater drainage and solid waste management. In this sense, developing a geographic database (BDG) will help as a tool for integrated management by sanitation managers. The objective of this work is to propose a BDG containing information on sanitation and urban and environmental characteristics to improve integrated management in the neighborhood of Marambaia in Belém / PA. For this, data was acquired from public agencies and health service providers, in spatial formats dwg, pdf and shp. Then, they were processed and validated by the AutoCAD and ArcMap tools, and later, stored in the BDG through PostgreSQL and its PostGIS spatial extension and managed by pgAdmin 4, resulting in the systematization in a single BDG containing data for the generation of tables and cartographic maps sanitation and urban and environmental characteristics. The BDG proved to be an excellent instrument for integrated sanitation management, as it allows to produce, verify and analyze jointly and safely sanitation information and data, helping to make decisions and mitigate problems.