Social Environment Characteristics of Bogota, Colombia, 2005 & 2018

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 sociodemographic data by city block from census data for Bogota, Colombia in 2005 and 2018 from DANE: National Administrative Department of Statistics (https://geoportal.dane.gov.co/) from the national population and demographic censuses. These data include proportion of individuals by sex, age, educational level, employment status from individual data, proportion of households in poverty or inadequate housing, and proportion of households with utility connections and dwelling quality within a city block. Data cleaning included: (1) Census data were provided at the level of persons, households, dwellings and spatial data (city blocks). To relate non-spatial and spatial data, city block codes (22 characters) were generated by concatenating the department code (2 characters), municipality (3 characters), class (1 character), rural sector (3 characters),rural section (2 characters), population center (3 characters), urban sector (4 characters), urban section (2 characters) and city block (2 characters).These codes were linked to the persons database. (2) The 2005 and 2018 census had some records with missing information on water and sewer connection which were filled with the category "Not reported". Regarding the wall material variable, the 2005 census did not report this information, so for that year this variable was filled in its entirety by the category “Not reported”. That same variable had some missing records in the 2018 census, which were managed in the same way. (3) The 2005 and 2018 census data were merged into one dataset with the following attributes: city block code, census year, water connection, sewer connection and wall durability categories. Poverty and inadequate housing datasets were merged using the city block ID, and only the attributes of interest were kept.The 2005 and 2018 educational level and employment status census data had two additional categories with no clear definition in the census documentation ("Not applicable" and "Not reported"). Those categories were merged into the "Not reported" category. The 2005 and 2018 census data were merged into one dataset with the following attributes: city block code, census year, sex, educational level, and employment status, combining the multiple categories of socioeconomic variables.