• 1

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


Question

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 

13 answers to this question

Recommended Posts

  • 0

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

 

 

 

  • 0

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

  • 0
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? 

  • 0
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

  • 0
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. 

  • 0
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
  • 0
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 

 

 

  • 0
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? 

  • 0

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
  • 0
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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Can you read? I've said I'm willing to pay more for a notchless (no notch) 3:2 screen.
    • Not even an OLED display on the laptops. Also it seems that the laptop design isn't the same as the Surface Ultra model. Looks like bargain bin at high prices.
    • make your own notch - it's not that hard
    • VirtualBox 7.2.10 by Razvan Serea VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use. Targeted at server, desktop and embedded use, it is now the only professional-quality virtualization solution that is also Open Source Software. Presently, VirtualBox runs on Windows, Linux, macOS, and Solaris hosts and supports a large number of guest operating systems including but not limited to Windows (NT 4.0, 2000, XP, Server 2003, Vista, 7, 8, Windows 10 and Windows 11), DOS/Windows 3.x, Linux (2.4, 2.6, 3.x, 4.x, 5.x and 6.x), Solaris and OpenSolaris, OS/2, OpenBSD, NetBSD and FreeBSD. Some of the features of VirtualBox are: Modularity. VirtualBox has an extremely modular design with well-defined internal programming interfaces and a client/server design. This makes it easy to control it from several interfaces at once: for example, you can start a virtual machine in a typical virtual machine GUI and then control that machine from the command line, or possibly remotely. VirtualBox also comes with a full Software Development Kit: even though it is Open Source Software, you don't have to hack the source to write a new interface for VirtualBox. Virtual machine descriptions in XML. The configuration settings of virtual machines are stored entirely in XML and are independent of the local machines. Virtual machine definitions can therefore easily be ported to other computers. VirtualBox 7.2.10 changelog: VMM: Fixed issue when CentOS 10 VM was not booting due to the message "Fatal glibc error: CPU does not support x86-64-v3" (​github:gh-642) Devices/EFI: Fixed booting issue when ARM VM had less than 1024 MiB of RAM assigned (​github:gh-679) USB: Fixed issue when it was not possible to attach USB device to headless VM on Apple Silicon/macOS 26.4.1 (​github:gh-631) Storage: Fixed issue when VIRTIO-SCSI device was not recognized as SSD device by guest system (​github:gh-634) Network: Fixed issue in E1000 emulation code which triggered debug log creation (​github:gh-645) Network: Fixed issue in E1000 emulation code which prevented OS/2 guest from booting (​github:gh-683) Linux Host: Fixed issue when VMs could not be started due to kernel oops (​github:gh-639) Linux Host and Guest: Fixed issue when kernel modules were failing to build with openSUSE 16.0 kernel Linux Host and Guest: Added initial support for kernel 7.1 Linux Host and Guest: Added extra fixes for RHEL 9.8 kernel (​github:gh-676) Linux Host and Guest: Added possibility to build source code using NASM instead of YASM as the assembler (​github:gh-520) Linux Guest Additions: Added initial support for Extended Data Control Protocol for clipboard sharing with Plasma on Wayland guests (​github:gh-33) Linux Guest Additions: Added extra fixes for preventing vboxvideo kernel module build with kernel version 7.0 and newer (​github:gh-655) OS/2 Guest Additions: Fixed issue when Shared Folders automount and clipboard sharing stopped working (​github:gh-551) Download: VirtualBox 7.2.10 | 170.0 MB (Open Source) Download: VirtualBox 7.2.10 Extension Pack | 19.1 MB View: VirtualBox Home Page | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • OK, now ask yourself how are they going to enforce that law? By requiring every single adult to prove their age and provide their legal identity documents to an UNREGULATED 3rd party company that already has a long track record of multiple data breaches. Not to mention, parliament have voted AGAINST this ban, twice, and Starmer is going ahead anyway. So, where's the democracy here, because that looks like dictatorship to me. The solution here is parental responsibility, not government control. Run some public service announcements on TV and UK social media teaching parents how to setup parental controls. That's already been proven to actually work. But the, this is not and has NEVER been about keeping kids safe. It's about control and monitoring. Watching what you're doing online and controlling what you can see and what you can say.
  • Recent Achievements

    • Week One Done
      suprememobiles48 earned a badge
      Week One Done
    • One Month Later
      Windows Guy earned a badge
      One Month Later
    • One Month Later
      Prasann earned a badge
      One Month Later
    • Week One Done
      Prasann earned a badge
      Week One Done
    • First Post
      Dys Topia earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      525
    2. 2
      +Edouard
      180
    3. 3
      PsYcHoKiLLa
      105
    4. 4
      Steven P.
      90
    5. 5
      ATLien_0
      70
  • Tell a friend

    Love Neowin? Tell a friend!