Tree Inventory of Bogota, Colombia, 2005-2023

This dataset is part of the ESCALA (Study of Urban Health and Climate Change in Informal Settlements in Latin America) project that was funded by the Lacuna Fund of the Meridian Institute https://lacunafund.org/.

This dataset contains an inventory of trees in Bogota, Colombia, 2005-2023. Detailed attributes of individual trees located in the urban areas of Bogotá D.C., representing species classified as trees, shrubs, palms, or tree ferns. Each record corresponds to a single plant and includes information on its characteristics, such as species, size, health condition, location, and environmental context. This information is collected by the Bogotá Botanical Garden and consolidated by SIGAU, which publishes it openly on their website. Data were provided by the SIGAU (By its Spanish acronym: Urban Tree Management Information System). Each tree was recorded from the moment of planting, minimizing errors. It is only necessary to correctly identify the tree ID to determine whether it corresponds to the same tree in different years or to a newly planted tree with its respective attributes. Data cleaning included: (1) Extraction of the raw database and loading of the attribute table for each point recorded in the vector layer. (2) Conversion of the date column, which originally comes in DATE format, into three new columns separating year, month, and day. Months are recorded as integers. (3) Selection of the variables of interest and renaming them according to the parameters established in the data dictionary and categorization based on the defined domains.

本数据集隶属于拉丁美洲非正规定居点城市健康与气候变化研究（Study of Urban Health and Climate Change in Informal Settlements in Latin America，简称ESCALA）项目，该项目由子午线研究所湖蓝基金（Lacuna Fund of the Meridian Institute）资助，资助官网为https://lacunafund.org/。
本数据集包含2005年至2023年哥伦比亚波哥大市的树木名录，涵盖波哥大首都特区（Bogotá D.C.）城区范围内的乔木、灌木、棕榈类植物及树蕨的单株详细属性信息。每条记录对应单株植物，包含物种、尺寸、健康状况、地理位置与环境背景等特征数据。该数据由波哥大植物园采集，由城市树木管理信息系统（SIGAU，西班牙语缩写）完成整合并公开发布于其官方网站，数据亦由SIGAU提供。所有树木均自种植之时起即被记录，最大限度降低了数据误差；仅需通过正确识别树木ID，即可判定该记录对应不同年份的同一株树木，或是对应新种植且带有完整属性信息的树木。本次数据清洗流程包括：(1) 提取原始数据库，并加载矢量图层（vector layer）中各记录点的属性表（attribute table）；(2) 将原始DATE格式的日期列（date column）拆分为年、月、日三个新列，其中月份以整数形式记录；(3) 筛选目标变量，并依据数据字典（data dictionary）中的既定参数完成变量重命名，同时根据预定义值域完成分类赋值。