Desarrollo de una herramienta automática en Python sobre ArcGIS Pro para garantizar la integridad de la geodatabase de los sistemas de alcantarillado sanitario y pluvial de Interagua

Abstract

In Geographic Information Systems (GIS), predefined tools are used to control the topology of coverages related to stormwater and sanitary sewer systems, which comprise pipes, chambers, inspection boxes, catch basins, and other components. However, the alphanumeric attributes of these elements, entered and updated by technical personnel, frequently lack the required consistency. Given that multiple linear elements can converge at a point element, manual review proves extremely complex and tedious. To address this problem, a geoprocessing tool was developed using the ArcPy module of ArcGISPro and Python, which significantly streamlines the process of reviewing and updating the coverages of the sanitary and stormwater sewer system. The results exceeded expectations, as in addition to calculating the invert elevations at the inlet and outlet of pipes, the tool validates that elements are correctly mapped—that is, properly connected, oriented according to the direction of flow, and free of duplicates. This comprehensive validation is reflected in the report table, which details the inconsistencies found in each system. In this way, the tool not only automates invert elevation calculations but also functions as a quality control mechanism for geospatial data, facilitating the early identification of errors that could compromise the accuracy of subsequent analyses and decision-making.