• 1

getting back both: the map and the data from a request via overpass-turbo.eu


Question

tarifa

for a little (!) project i need to have the data (in DB ) and the maps- 

this request delivers the Map

 

 

 

[timeout:600];
area["ISO3166-1"="BR"]->.brazil;
area["ISO3166-1"="AR"]->.argentina;
area["ISO3166-1"="VE"]->.venezuela;
area["ISO3166-1"="PE"]->.peru;
area["ISO3166-1"="CL"]->.chile;

/* more areas..*/

(
  nwr[amenity=hospital](area.brazil);
  nwr[amenity=hospital](area.argentina);
  nwr[amenity=hospital](area.venezuela);
  nwr[amenity=hospital](area.peru);
  nwr[amenity=hospital](area.chile);
  /* other queries... */
);
out center;


this request delivers the data;

 

 

 

[out:csv(::id,::type,::lon, ::lat, "name","addr:postcode","addr:city","addr:street","addr:housenumber","contact:website"," contact:email=*")][timeout:600];
area["ISO3166-1"="BR"]->.brazil;
area["ISO3166-1"="AR"]->.argentina;
area["ISO3166-1"="VE"]->.venezuela;
area["ISO3166-1"="PE"]->.peru;
area["ISO3166-1"="CL"]->.chile;


/* more areas..*/

(
  nwr[amenity=hospital](area.brazil);
  nwr[amenity=hospital](area.argentina);
  nwr[amenity=hospital](area.venezuela);
  nwr[amenity=hospital](area.peru);
  nwr[amenity=hospital](area.chile);
  /* other queries... */
);
out center;

 

 

question 

how to achive that i get back both data -set with the request via overpass-turbo.eu 

Link to post
Share on other sites

13 answers to this question

Recommended Posts

  • 0
tarifa

How can I export or query all euroean hospitals from Open Street Map?

 

 

by the way this can be regarded as a contribution to the COVID-19 response - fiding a list of all European Hospitals: Find all datasets available for download on COVID-19.

 

how can we download data on hospital. - very important: i need the maps and (!!) the data like adress, webiste, location etc. etx. I am looking for a (european) dataset of hospitals: mainly locations, but if possible also names, sizes, number of beds. As far as I can tell, this does not exist yet, but perhaps there are good starting points!

 

btw: some approaches:

healthsites.io is an open data effort to map healthcare entities (hospitals, clinics, pharmacies, private practices, etc.) worldwide. The data is drawn from OpenStreetMap and at a minimum provides the name and geographic coordinates of each healthcare entity. There is a OSM data model for health sites, details provided here. The data is released under the Open Data License.

 

which options do we have!?

can i exort maps - created by requests to the overpass-turbo.eu page: and export the kml-results into a plugin or a block in Wordpress!? That would be more than great

At the moment i am in the early planning stages of a new project.

 

again – the approaches:

well i want to export the maps in kml or geojson.

 

a. southamerica or

b. europe

 

for a overview or for retrival …

for example a: … showing a map that i have gathered – from http://www.overpass-turbo.eu

 


area["ISO3166-1"="BR"]->.brazil;

area["ISO3166-1"="AR"]->.argentina;

 

/* more areas..*/

(

nwr[amenity=hospital](area.brazil);

nwr[amenity=hospital](area.argentina);

/* other queries... */

);

out center;

 

for example b:

 


[out:csv(::id,::type,"name","addr:postcode","addr:city","addr:street","addr:housenumber","website"," contact:email=*")][timeout:600];

area["ISO3166-1"="CL"]->.chile;

 

/* more areas..*/

 

(

nwr[amenity=hospital](area.chile);

);

out center;

 

and besides showing some maps i want to offer a retrival: eg with a plugin like

 

wp-jobmanager or wp-participants database ( cf; https://wordpress.org/support/plugin/participants-database/ )

 


812380089 way Clínica Tarapacá Iquique Barros Arana 1550 https://www.clinicatarapaca.cl/

812714508 way Hospital Clínico Viña del Mar Viña del Mar Limache 1741

817842590 way Hospital de Fresia San José 301

819315869 way Nueva Clínica Madre e Hijo Avenida Santa Rosa 1503

822509761 way SurMédica

828332217 way Consalud

829563034 way Hospital de Niños Dr. Roberto del Río

831654714 way Clínica Reñaca

832118050 way Clínica Alemana Beauchef 765

832203189 way Clínica Curicó Curicó Villota

840220768 way Hospital Angol General Óscar Bonilla 750

840359494 way

844876695 way SOS RESCATE ANIMAL 100000 La Huaica Bernardo O'Higgins S/N

4587756 relation Clínica Portada Antofagasta Avenida José Manuel Balmaceda 2648 http://www.clinicaportada.cl/

6066032 relation Complejo Asistencial Doctor Víctor Ríos Ruiz Avenida Ricardo Vicuña 0147

6634378 relation Preuniversitario Pedro de Valdivia Lo Barnechea Avenida José Alcalde Délano 10581 https://www.preuniversitariopedrodevaldivia.cl/

7133551 relation

 

well do you think that i can do some thing – eg the import of data that is derived eg

.from healthsites.io or openstreetmap (the GeoJSON or KML data )?

look forward to hear from you

 

regards

 

 

 

Link to post
Share on other sites
  • 0
tarifa

hello again - well this is what i have got back - but this looks a bit too complex. 

 

i can save this as 

 

kml 

geojson 

or shapefile 

 

but at the moment i think that this is way too complex - 

 

 

question -how to lower the rate of records in the result list

 

note: i want both - the map and the data - here in t his case the d ata of the hospitals

 

 

image.png.cab7c6b48540240d9c861b0da54af73b.png

Link to post
Share on other sites
  • 0
FrankenSter
5 hours ago, tarifa said:

hello again - well this is what i have got back - but this looks a bit too complex. 

 

i can save this as 

 

kml 

geojson 

or shapefile 

 

but at the moment i think that this is way too complex - 

 

 

question -how to lower the rate of records in the result list

 

note: i want both - the map and the data - here in t his case the d ata of the hospitals

 

 

image.png.cab7c6b48540240d9c861b0da54af73b.png

How? Read the docs that tell you how. All this covered in the openstreetmap docs but you have to actually do some work to make it happen so instead of asking us how to write code for you why don't you just experiment on your own to get the results you want? 

  • Like 1
Link to post
Share on other sites
  • 0
tarifa
18 hours ago, FrankenSter said:

How? Read the docs that tell you how. All this covered in the openstreetmap docs but you have to actually do some work to make it happen so instead of asking us how to write code for you why don't you just experiment on your own to get the results you want? 

good day dear Frankenster - thanks for the quick reply. 

 

i do some tests. i will digg deeper. 

 

again - thanks for the encouraging to do so. 

 

have a good day

Link to post
Share on other sites
  • 0
FrankenSter
6 hours ago, tarifa said:

good day dear Frankenster - thanks for the quick reply. 

 

i do some tests. i will digg deeper. 

 

again - thanks for the encouraging to do so. 

 

have a good day

Ya, doing your own work and learning would be a good thing for you for a change. 

Link to post
Share on other sites
  • 0
tarifa

howdy - Frankster your pretty new here - food for thought 

Your are novice - and a cool dude...

 

 

Link to post
Share on other sites
  • 0
+NJ Louch
31 minutes ago, tarifa said:

howdy - Frankster your pretty new here - food for thought 

Your are novice - and a cool dude...

 

 

For someone who cannot even setup a simple webserver with Wordpress without posting 500 errors, it's a bit rich you calling someone a novice.

  • Like 1
Link to post
Share on other sites
  • 0
tarifa
2 hours ago, NJ Louch said:

For someone who cannot even setup a simple webserver with Wordpress without posting 500 errors, it's a bit rich you calling someone a novice.

thx for the reply - 

 

oh no - with novice i meant new to this site. 

i never ever would talk about others like so:  - you have questions -  and i am the cool dude 

 

This is seriously  a nasty habit.  

 

You have 41 K postings  i have 299  so i think you are very very clever -   since you have spend 150 x times here. ... 

 

cheers 

 

 

Link to post
Share on other sites
  • 0
+NJ Louch
41 minutes ago, tarifa said:

You have 41 K postings  i have 299  so i think you are very very clever

What an odd pairing of metrics

  • Like 1
Link to post
Share on other sites
  • 0
FrankenSter
9 hours ago, tarifa said:

howdy - Frankster your pretty new here - food for thought 

Your are novice - and a cool dude...

 

 

What are you talking about with your food for thought comment? Ya, I'm new here so what? 

 

You're a novice at reading instructions but not at wanting people to do your job for you. Bro, youve been 

using osm for how long? How many yrs? 

  • Like 1
Link to post
Share on other sites
  • 0
tarifa
Posted (edited)

hello dear Fankster hello dear NJ-Loch, 

 

 

 

seven years buddy - and you can read my history here .- with 

- fields of interest and 
- some examples and own experiments. etc. etx. 

 

see my wikipage - which shows some of my interests in osm-things: https://wiki.openstreetmap.org/wiki/User:Tagtheworld

 

and besides - some more of my interests - in knowledge-ecology and networks of innovation. http://flosshub.org/biblio   - with the collected papers of the research... of the last 35 years.. - this is the center of open-source-meta-reflection. 

 

 

...back to openstreetmap - one of my interests - and to my wiki-page covering the topics of interests: https://wiki.openstreetmap.org/wiki/User:Tagtheworld 


belive me: the osm is not the only field of interest - besides this i have lots of more. 

and yes: since the development is changing things constantly - i feel like a novice - even after so long time. 

btw my other interests are - learning ... and i am interested in communities of practice (cop) 

 

see here the fileds of interest in networks of knowldge and innovation:  cf: https://wiki.openstreetmap.org/wiki/User:Tagtheworld/Open-source-research

 

some topics and some keywords that might describe this field of interest a bit. 

 

- discourse of universe / universe of discourse (G.H.Mead)
- Cathedral or Bazaar - Eric Raymond
- Network of innovation - Illka Tuomi
- Community of Practice CoP Lave & Wenger and furthermore...- there are even more interesting concepts:
LPP: Building upon Lave and Wenger's theory of legitimate peripheral participation (LPP), this paper offers a longitudinal investigation of one OSS community in which sustained participation is hypothesized to be associated with the coevolution of two major elements of LPP theory: "situated learning" (the process of acting knowledgeably and purposefully in the world) and "identity construction" (the process of being identified within the community).
SECI model of knowledge dimensions: Nonaka Takeuchi The SECI model of knowledge dimensions is a model of knowledge creation that explains how tacit and explicit knowledge are converted into organisational knowledge. The SECI model distinguishes four knowledge dimensions – socialization, externalization, combination, and internalization – which together form the acronym "SECI". The SECI model was originally developed by Ikujiro Nonaka in 1990 and later further refined by Hirotaka Takeuchi.
liminal approach – cf. the movement of individuals engaged in open source communities. open source communities and growing body of knowledge on corporate engagement in open source communities, our understanding of the movements of individuals within these communities is limited. To analyze these movements, we build on Arnold Van Gennep and Victor Turners’ theories on liminality. Through this lens, we build an understanding of the movements of individual members within open source communities.


so - i myself regard me as a learner - .... 

and i will be probably a learner till the end of my live. 

but this might be a good thing. 

 

 

that said - i am glad to be in this community - i like the free and open minded people and the idea sharing and exchange. 

i like the exchange and the friendly commnity.... 

 

on a sidenote: i am member of stackoverflow - and dev.to too:  but regarding the atmoshere in the various communities of practice (cop senso lave & wenger) might be rearded different. 

 

if we compare 

neowin.net 

dev.to 

stackoverflow (so) then we have very different communities of practice (cop senso lave & wenger)

 

 

there -(at dev.to is a bit different - compaed to stackoverflow (so) 


to deepen these ideas see for the further ideas here: https://dev.to/peledzohar/differences-between-dev-and-stackoverflow-6o3

Quote

 


In Dev, we get to write articles - in Stackoverflow, we write questions and answers.

In Dev, we have hearts and unicorns - in Stackoverflow we have down votes.

In Dev, discussion is encouraged - in Stackoverflow, comments aren't for discussion. You'll get banished to the chat.

In Dev, we can write (almost) anything we want - in Stackoverflow, your post gets closed as off topic and deleted.

In Dev, human interaction is encouraged - in Stackoverflow, words like "Thanks" and "Good day" in your post are considered as noise.

In Dev, the community is all about the developers - in Stackoverflow, we are only here for the questions and answers.

In Dev, every person is considered equal - in Stackoverflow, We're keeping score.

In Dev, we're here to write, read, communicate and share ideas - in Stackoverflow, we're here to solve problems.

This post was inspired by a sketch of one of my personal all times favorites comedians - George Carlin. I know I'm not half as funny as he was, but I hope I did make you smile.

And yes - neowin seems to be a community with open mindes ppl - here - at this site discussion is encouraged - it is a great place… 
- and here we have the free discussion and the option to write a question - without being downvoted.. 
for me this is pretty important: - i need this method and this ability to write. 

 


note: Heinrich von Kleist a german novelist talks about the gradual production of thoughts  cf https://pure.mpg.de/rest/items/item_2352284/component/file_2352283/content - sorry; only in German). To develope a thought it is (at least to me) very important to use free speech.. without limitation or the SO based regulations… 
and to avoid a misunderstanding: the idea is not to steal the content from SO - but the idea to extract some stuff in order to create them to longer content with explanations etc. etx.  see such an example with enrichment and explantion…  cf https://stackoverflow.com/questions/60885198/beautifulsoup-web-scrape-get-children/60886597#comment107723844_60886597 - very interesting - it is a great example..


have a great day - and stay at home, stay safe,  stay healthy,;)

regards, 

 

 

 

 

Edited by tarifa
Link to post
Share on other sites
  • 0
FrankenSter
7 hours ago, tarifa said:

hello dear Fankster hello dear NJ-Loch, 

 

 

 

seven years buddy - and you can read my history here .- with 

- fields of interest and 
- some examples and own experiments. etc. etx. 

 

see my wikipage - which shows some of my interests in osm-things: https://wiki.openstreetmap.org/wiki/User:Tagtheworld

 

and besides - some more of my interests - in knowledge-ecology and networks of innovation. http://flosshub.org/biblio   - with the collected papers of the research... of the last 35 years.. - this is the center of open-source-meta-reflection. 

 

 

...back to openstreetmap - one of my interests - and to my wiki-page covering the topics of interests: https://wiki.openstreetmap.org/wiki/User:Tagtheworld 


belive me: the osm is not the only field of interest - besides this i have lots of more. 

and yes: since the development is changing things constantly - i feel like a novice - even after so long time. 

btw my other interests are - learning ... and i am interested in communities of practice (cop) 

 

see here the fileds of interest in networks of knowldge and innovation:  cf: https://wiki.openstreetmap.org/wiki/User:Tagtheworld/Open-source-research

 

some topics and some keywords that might describe this field of interest a bit. 

 

- discourse of universe / universe of discourse (G.H.Mead)
- Cathedral or Bazaar - Eric Raymond
- Network of innovation - Illka Tuomi
- Community of Practice CoP Lave & Wenger and furthermore...- there are even more interesting concepts:
LPP: Building upon Lave and Wenger's theory of legitimate peripheral participation (LPP), this paper offers a longitudinal investigation of one OSS community in which sustained participation is hypothesized to be associated with the coevolution of two major elements of LPP theory: "situated learning" (the process of acting knowledgeably and purposefully in the world) and "identity construction" (the process of being identified within the community).
SECI model of knowledge dimensions: Nonaka Takeuchi The SECI model of knowledge dimensions is a model of knowledge creation that explains how tacit and explicit knowledge are converted into organisational knowledge. The SECI model distinguishes four knowledge dimensions – socialization, externalization, combination, and internalization – which together form the acronym "SECI". The SECI model was originally developed by Ikujiro Nonaka in 1990 and later further refined by Hirotaka Takeuchi.
liminal approach – cf. the movement of individuals engaged in open source communities. open source communities and growing body of knowledge on corporate engagement in open source communities, our understanding of the movements of individuals within these communities is limited. To analyze these movements, we build on Arnold Van Gennep and Victor Turners’ theories on liminality. Through this lens, we build an understanding of the movements of individual members within open source communities.


so - i myself regard me as a learner - .... 

and i will be probably a learner till the end of my live. 

but this might be a good thing. 

 

 

that said - i am glad to be in this community - i like the free and open minded people and the idea sharing and exchange. 

i like the exchange and the friendly commnity.... 

 

on a sidenote: i am member of stackoverflow - and dev.to too:  but regarding the atmoshere in the various communities of practice (cop senso lave & wenger) might be rearded different. 

 

if we compare 

neowin.net 

dev.to 

stackoverflow (so) then we have very different communities of practice (cop senso lave & wenger)

 

 

there -(at dev.to is a bit different - compaed to stackoverflow (so) 


to deepen these ideas see for the further ideas here: https://dev.to/peledzohar/differences-between-dev-and-stackoverflow-6o3


note: Heinrich von Kleist a german novelist talks about the gradual production of thoughts  cf https://pure.mpg.de/rest/items/item_2352284/component/file_2352283/content - sorry; only in German). To develope a thought it is (at least to me) very important to use free speech.. without limitation or the SO based regulations… 
and to avoid a misunderstanding: the idea is not to steal the content from SO - but the idea to extract some stuff in order to create them to longer content with explanations etc. etx.  see such an example with enrichment and explantion…  cf https://stackoverflow.com/questions/60885198/beautifulsoup-web-scrape-get-children/60886597#comment107723844_60886597 - very interesting - it is a great example..


have a great day - and stay at home, stay safe,  stay healthy,;)

regards, 

 

 

 

 

What are you even talking about? I don't care about your supposed resume what you read or why and I doubt anyone else does either. The only thing I get from above is that the other forums make you actually work, and you like it here where you don't actually have to.

 

 You admit you've been at this for 7 yrs, and haven't bothered to read their docs? Or be able to do simple mapping, which is what the entire setup does? And I'm sure not your buddy so don't address me as one.

  • Like 1
Link to post
Share on other sites
  • 0
Nick H.

Well it looks like this is going nowhere...

 

<Thread locked>

  • Like 1
Link to post
Share on other sites
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.