Revisión de obstáculos aeronáuticos: apoyo técnico y gestión de base de datos

Abstract

The internship was carried out at the Special Administrative Unit of Civil Aviation of Colombia, focusing on the management and review of aeronautical obstacles, which are essential for aviation safety. By 2022, the available information was scattered across 1,327 Excel files, making consultation, analysis, and traceability difficult. The project involved designing and implementing an automated mechanism through the development of two Python scripts that enabled the extraction, cleaning, and consolidation of technical, administrative, and geographical data. One program processed files with a single coordinate point, while the other handled files with multiple points. The outcome was the creation of the BASE_2022 database, consolidating 4,405 records structured into administrative, technical, and georeferenced fields. This solution improved efficiency, reduced human errors, and strengthened decision-making in operational safety. The internship highlighted the importance of automation in aeronautical data management, providing a modern and reliable tool for the civil aviation authority.