Diagnóstico del registro administrativo censo arbóreo de Bucaramanga

Abstract

The Bucaramanga mayor's office has among its functions the generation of high-quality, consistent, and coherent data for the production of national statistics; in this case, a diagnostic assessment is carried out on the administrative record of Bucaramanga's tree census, which contains 71,586 records and 45 variables that must be evaluated using the methodology established by the National Department of Statistics (DANE). The following document describes the review of the database, the completion of the "ficha-revisión-base-de-datos" (database review form) through an automated process in Microsoft Excel, and the calculation of six quality indicators (variable type, length, allowed values, completeness, domain, and thematic validation rules). The completeness (99%) and variable type correspondence (93%) indicators received excellent and good ratings, respectively; field length reached 88% (good); while the allowed values (74%), domain (74%), and validation rules (77%) indicators showed poor and acceptable performance. The findings show that the registry is structurally suitable for statistical use, but it requires standardizing variables such as fecha (date), n_arbol (tree number), and comuna (district), and implementing data capture validations to strengthen data quality for the 2026 census update.