# NOT RUN {
if (requireNamespace("sf", quietly = TRUE)) {
library(sf)
data(urban_agglomerations)
}
# Code used to download the data:
# }
# NOT RUN {
download.file(destfile = "WUP2014-F11a-30_Largest_Cities.xls",
url = "https://esa.un.org/unpd/wup/CD-ROM/WUP2014_XLS_CD_FILES/WUP2014-F11a-30_Largest_Cities.xls")
library(dplyr)
library(sf)
urban_agglomerations = readxl::read_excel("WUP2014-F11a-30_Largest_Cities.xls", skip = 16) %>%
st_as_sf(coords = c("Longitude", "Latitude"), crs = 4326)
names(urban_agglomerations) <- gsub(" ", "_", tolower(names(urban_agglomerations)) ) %>%
gsub("\\(|\\)", "", .)
devtools::use_data(urban_agglomerations, overwrite = TRUE)
file.remove("WUP2014-F11a-30_Largest_Cities.xls")
# }
Run the code above in your browser using DataLab