User:YaguraStation/Hospitals in South Africa
Free State
[edit]In April 2020 we still didn't have hospitals in the Free State province with their coordinate location in Wikidata. The Free State Health Department publishes their data in an obscure form which the Seeking Shelter project has scraped and formatted as CSV.
Although importing data from OSM to Wikidata and vice versa is not permitted, I will try to identify bad data by checking the delta of the two locations, from the Free State Health Department and from OSM via Nominatin which allows API access at 1query/sec and support for phrases such as
https://nominatim.openstreetmap.org/search?format=json&email=[email-address]&app=google-refine&q=Batho+%20+Clinic+in+free+state+south+africa
Openrefine has the feature to "Add Column By Fetching URLs..." with throttling rate with the the following syntax:
https://nominatim.openstreetmap.org/search?format=json&email=[email-address]&app=google-refine&q=" + escape(value, 'url')
.
For Free State (250 facilities in above CSV)
- Using
Name
+"+in+free+state+south+africa"
only yields 30 useful results.
I ended up adding one central hospital and the regional hospitals manually. Scraping, vetting, and adding the district hospitals and clinics.