afrimapr / afrihealthsites

access to geographic locations of african health sites from different sources
https://wellcomeopenresearch.org/articles/5-157
GNU General Public License v3.0
31 stars 4 forks source link

[Existing data] KEMRI/WHO coordinates #4

Closed anelda closed 3 years ago

anelda commented 4 years ago

Which dataset KEMRI-WHO

Short description of the error or suggestion The dataset is downloaded as SF object. In the original spreadsheet, there are two columns for coordinates called Lat and Long which isn't present in the object that is downloaded via afrihealthsites.

> ah_kemri_who_tb <- afrihealthsites(country="south africa", datasource = "who")
> colnames(ah_kemri_who_tb)
[1] "Country"       "Admin1"        "Facility name" "Facility type" "Ownership"     "LL source"     "geometry"     
[8] "iso3c"   
> kemri_excel <- read_excel('data/raw_data/who-cds-gmp-2019-01-eng.xlsx') %>% filter(Country == 'South Africa')
> colnames(kemri_excel)
[1] "Country"       "Admin1"        "Facility name" "Facility type" "Ownership"     "Lat"           "Long"         
[8] "LL source" 

Suggested actions Please is it possible to add the two columns with Lat and Long as per the original Excel file?