Question Acquire The POI Of Every Hospital In Africa, Asia, America From OSM

Apr 30, 2020
17
0
10
0
the question of today: acquire the POI of every hospital in Africa, Asia, America from OSM


I need to acquire the POI if every hospital in Africa, Asia, America from OSM: which approach should i choose?

At this point, I've only played with downloading extracts from other services like geofabrik, I haven't actually pulled any data down myself. What's the best way to do this in a pinch? I'm looking for a crash course. Thanks in advance for your help!

on a sidenote; there is a high likelihood that many non-hospital medical facilities have been mapped for example. One other issue which is also common is multiple hospital objects existing on one hospital site: this is frequently, but not always, incorrect. See an example in Tanzania.

https://wiki.openstreetmap.org/wiki/Downloading_data#Huge_amounts_of_data

some approaches:

- osmconvert: https://wiki.openstreetmap.org/wiki/Osmconvert

- osmfilter: https://wiki.openstreetmap.org/wiki/Osmfilter

- XAPI, Overpass API: https://wiki.openstreetmap.org/wiki/Xapi

- overpass-turbo: http://overpass-turbo.eu/

- osmium https://osmcode.org/osmium-tool/

"XAPI, Overpass API and the Export Tool allow to download custom data sets like arbitrary bounding boxes, elements with specific tags, public transport networks or other features." might take a bit of experimenting with parameters and validation because you're relying on consistent tagging by other users

we can try with overpass turbo http://overpass-turbo.eu/ but I suspect that it will be too much data and we would need to use suitably defined bounding boxes. What should work is doing this on a country by country base, which would also allow us to define exactly which ones us believe belong to Africa and which not (we will need to convert the output to a shapefile).

The other approach is to download an extract - let us take Africa for example:
- that just contains "Africa" for example http://download.geofabrik.de/africa.html (the fsvo bit: this contains the Canary Islands which you may want to or may not want to include), and filter it with a suitable command line tool (and then convert to a shapefile).

Examples: osmium https://osmcode.org/osmium-tool/ osmfilter https://wiki.openstreetmap.org/wiki/Osmfilter

healthsites.io: hat is actually a hospital? amenity=hospital is a fairly sure bet, but you might want to include amenity=clinic and potentially give the healthcare tags a look too. see the Data of healthsites.io : etc https://healthsites.io/map Healthsites.io is supposed to curate healthcare data based on OSM for more widespread usage by healthcare specialists.

btw: For some reason OSM tagging is quite weak regardivng nuances of healthcare facilities (for instance how should one map a private hair transplant practice?). It's also extremely difficult to judge the validity of tagging without good knowledge of the local healthcare system. see more of healthsites.io-Projcet: http://www.healthsites.io


note: once downloaded i want to maintain the dataset in a PostgreSQL db.
btw: when trying to get the data from overpass-turbo i get somewhat full set of POI data


Code:
[out:csv(::id,::type,"name","addr:postcode","addr:city","addr:street","addr:housenumber","website","contact:email=*")][timeout:600];
area["ISO3166-1"="AT"]->.a;
( node(area.a)[amenity=hospital];
  way(area.a)[amenity=hospital];
  rel(area.a)[amenity=hospital];)/>;
out;
see the results:
Code:
    @id    @type    name    addr:postcode    addr:city    addr:street    addr:housenumber    website     contact:email=*
    2656877    relation    Unfallkrankenhaus Lorenz Böhler    1200    Wien    Donaueschingenstraße    13    https://www.auva.at/ukhboehler/   
    2685003    relation    Landeskrankenhaus Hörgas-Enzenbach                    [url=http://www.lkh-hoergas.at]http://www.lkh-hoergas.at[/url]   
    2685004    relation    Landeskrankenhaus Judenburg-Knittelfeld                    [url=http://www.lkh-judenburg.at]http://www.lkh-judenburg.at[/url]   
    2685005    relation    Landeskrankenhaus Hochsteiermark                    [url=http://www.lkh-hochsteiermark.at]http://www.lkh-hochsteiermark.at[/url]   
    2685006    relation    Landeskrankenhaus Mürzzuschlag-Mariazell                    [url=http://www.lkh-muerzzuschlag.at]http://www.lkh-muerzzuschlag.at[/url]   
    2685007    relation    Landeskrankenhaus Rottenmann-Bad Aussee                    [url=http://www.lkh-rottenmann.at]http://www.lkh-rottenmann.at[/url]   
    2755244    relation    Landesklinikum Scheibbs    3270    Scheibbs    Feldgasse    26       
    2764083    relation    Allgemeines Krankenhaus Wien    1090    Wien    Währinger Gürtel    18-20    [url=https://www.akhwien.at]https://www.akhwien.at[/url]   
    2882269    relation    Unfallkrankenhaus Salzburg                    [url=http://www.ukh-salzburg.at]http://www.ukh-salzburg.at[/url]   
    3333391    relation    Krankenhaus St. Josef    5280    Braunau am Inn    Ringstraße    60    https://www.khbr.at/

or to take a second example:


Code:
    30850910 way Hôpital Nord Guillaume et René Laennec 44093 Nantes Cedex 1 Bd professeur Jacques-Monod - Saint-Herblain https://www.chu-nantes.fr/ 
    30979413 way Hôpital Albert Chenevier 94010 Créteil rue de Mesly 40 http://chu-mondor.aphp.fr/hopital-albert-chenevier1/ 
    31150222 way Centre de Psychiatrie Les Tournesols 
    31150223 way Clinique du Saint-Coeur http://www.saint-coeur.groupe-elsan.com/ 
    31252310 way Hôpital Avicenne http://chu93.aphp.fr/hopital-avicenne-bobigny/ 
    32229408 way Centre hospitalier du Rouvray 76300 Sotteville-lès-Rouen Rue Paul Éluard 4 www.ch-lerouvray.fr 
    32354044 way Centre hospitalier intercommunal Fréjus Saint-Raphaël https://www.chi-fsr.fr/ 
    32388820 way Clinique des Cèdres https://clinique-cedres.capio.fr/ 
    32471086 way Hôpital Saint-Jacques 
    32522247 way Centre hospitalier de Dieppe 76200 Dieppe Avenue Pasteur [url=http://www.ch-dieppe.fr]http://www.ch-dieppe.fr[/url] 
    32617022 way Hôpital Désandrouins 55100 Verdun Avenue d'Étain 
    32679701 way Hôpital Belle-Isle [url=https://www.hpmetz.fr/fr/etablissement/hopital-belle-isle]https://www.hpmetz.fr/fr/etablissement/hopital-belle-isle[/url] 
    32851894 way Clinique d'Occitanie 31600 Muret Avenue Bernard IV 20 http://www.clinique-occitanie.com/
question: why do i get such a detailed list while running an request against overpass-turbo.eu - the output is very very detailed.

should i stick to overpass-turbo.eu? and run a request contry by country... and then put all the data to a MySQL or PostGreSQL-DB to maintain all the data!?



Look forward to hear from you
 

ASK THE COMMUNITY