Population Projection by Locality, Age, Sex and Year in Bogota, Colombia 2005-2035

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 counts by locality, year, sex and age in the municipal area of Bogota, Colombia, 2005-2035. This data was acquired from data openly published at datosabiertos.bogota.gov.co. These data are based on the 2018 census conducted in Colombia, retro-projections compared to the 2005 census and projections were estimated for Bogotá, its localities. While these data do not provide the exact count for each year, they are considered an approximation of the true counts. Population projections by locality, 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. 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 locality. (2) Adjust each variable by assigning the names specified in the data dictionary and categorizing them according to the defined domains.