Population Projections by Age, Sex, Year and Neighborhood in Bogota, Colombia, 2018-2024

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 population projection count by sex and age in the municipal area of Bogota, Colombia by UPZ (Unidad de Planeamiento Zonal, Zoning Planning Unit), 2018-2024. Population projections by UPZ, Inter-administrative Agreement 095 of 2020 DANE-FONDANE and SDP (District Planning Secretariat), based on the 2018 National Population and Housing Census (CNPV) by DANE, openly published at datosabiertos.bogota.gov.co. While these data do not provide the exact count for each unit, they offer an approximation close to the true figures. Data cleaning included: (1) Remove rows containing total values for Bogotá, as they are redundant, given that a column is already provided as a foreign key for the urban unit layers by UPZ. (2) Adjust each variable by assigning the names specified in the data dictionary and categorizing them according to the defined domains.