Análisis georreferenciado de fallas en las redes de acueducto y alcantarillado de Bogotá

Abstract

The Bogotá Aqueduct and Sewer Company has approximately 153 stations, within which there is a large amount of electromechanical equipment. For the conservation of this equipment, maintenance plans are launched monthly that are executed by crews that record the relevant information through work orders (OT), after carrying out the assigned visits. The methodology used consists of collecting the data stored in the information base of the SAP-PM® application, followed by data analysis with Python and ending with the generation of maps containing the EAAB stations georeferenced with the use of the Geopandas libraries and Fiona libraries that facilitate access to additional Python functions to generate files, which will be used on the Google Earth tool. The final results of this article are made up of the statistical analysis of the georeferenced data; two maps, one with the locations of all the pumping stations and the second with the locations of the pumping stations under study, each of the above also contains information on the number of failures reported per station during the analyzed period. Finally, there are the recommendations corresponding to each equipment/station detected as critical.