How to work with the overpass turbo tool

Help and support
#1

hello dear all
how to work with the overpass turbo tool

1 Like
#2

Hi,

Do you know the wiki page?

2 Likes
#3

there is a video on the HOT youtube channel. it will be of help

1 Like
#4

Also, this might help you to create queries right away if you are not still familiar with the syntax:

2 Likes
#5

hello dear @Qwajo_OSM , @nukeador, @dcapillae

many many thanks - awesome
one question - can i use overpass-turbo to get maps of - lets say schools if i hand over #data
like so:


Schule;Ort;Latitude;Longitude
A;Heidelberg;49.40393697530618;8.688512976737254
B;Leimen;49.349312445097624;8.690722638917252
C;Schwetzingen;49.39313202528569;8.571030734964701
D;Ladenburg;49.46880190621661;8.609880602597833
E;BrĂźhl;49.38861264700501;8.531234227967852
F;Schriesheim;49.47619047474756;8.666059341183772

and get maps like so
is this possible.

image
note this is done with umap …

well is there something similar possible with overpass turbo

is this possible.? Look forward to hear from you

#6

Overpass (& Overpass Tubo) can easily query OpenStreetMap data (overpass can’t upload your own data).
Here’s a sample Overpass Turbo Query showing amenity=school. You can start with that

1 Like
#7

hello dear Amanda
many thanks for the quick reply. Awesome: thats just great and i am really impressed.
if i got you right - then i am able to cet a certain amount of schools - that is - can i get a visualized output of - let us say only a certain number of the shools that you get back with your (great) query.

That said - i think that, if i got you right then i would be able to pick some certain schools here and do the vizualization - while handing over the data of those schools - eg those here:



a. Weg: 148345076 Städtisches Gymnasium Porta Westfalica / Realschule Hasberge
https://www.openstreetmap.org/way/148345076


b. Weg: Schule BBS (257150895): Schule BBS Kreisberufschule
https://www.openstreetmap.org/way/257150895


c. Weg: Eine-Welt-Schule (48788425) Herdergymnasium 
https://www.openstreetmap.org/way/48788425

is this possible - with Overpass and overpass-turbo.

look forward to hear from you

regards Tagthe world

#8

I’m not sure I understand you 100%. You can style an Overpass Turbo with MapCSS. However it’s also possible to download the data in a variety of popular fileformats, such GeoJSON, GPX or KML (click on the “Export”) button.

You can also filter the original query based on certain names, or OSM objects, if you only want to get the details for a small subset of schools.

1 Like
#9

hello dear Amanda,

many many thanks for the quick reply - awesome. i am very glad to hear form you.

well the purpose is here: can i use overpass-turbo to get maps of - lets say ony a certain amount of schools if i hand over #data
like so:

Schule;Ort;Latitude;Longitude
A;Heidelberg;49.40393697530618;8.688512976737254
B;Leimen;49.349312445097624;8.690722638917252
C;Schwetzingen;49.39313202528569;8.571030734964701
D;Ladenburg;49.46880190621661;8.609880602597833
E;BrĂźhl;49.38861264700501;8.531234227967852
F;Schriesheim;49.47619047474756;8.666059341183772

r
well the question is: h ow (!!) to build this special repuest - so that overpass-turbo understands that i only want to have some shools

look forward to hear from you

reagads `

#10

No Overpass Turbo shows data that has been added to OSM, and is relatively close to the OSM tagging scheme.

I think you might be better using a search tool like Nominatim.

OTOH if you have the data already, you probably want to use uMap to display your data on a map.

Or a javascript library like Leaflet.

1 Like
#11

hello dear Amanda,

many thanks for the reply. Glad to hear from you.

thanks for the hints - thanks for remembering nominatim: https://nominatim.org

Find places by name or address (Geocoding)
Nominatim can power the search box on your website, allowing your users to type free-form queries (“Cafe Paris, New York”) in any language. It also offers a structured query mode (“postcode=12345”, “city=London”, “type=cafe”) that helps you to automate geocoding of extensive address lists.

and

Look up addresses for a location (Reverse geocoding)
Given a latitude and longitude anywhere on the planet, Nominatim can find the nearest address. It can do the same for any OSM object given its ID.

great thing - and i think this is a hint towards the right direction.

if i for example look for the data for three schools in Heidelberg : eg. the following:

a. Bunsengymnasium
b. HĂślderlin-Gymnaisum
c. KurfĂźrst Friedrich Gymnasium

then i can run some queries at the page - openstreetmap.org - and here i get back the following data:

a.

Knoten: Bunsengymnasium (107479229) Version #17
Bearbeitet vor etwa 2 Jahren von EvanE
Änderungssatz #98435270
Standort: 49,4168625, 8,6756639
https://www.openstreetmap.org/node/107479229#map=18/49.41677/8.67632

and secondly

Knoten: HĂślderlin-Gymnasium (1029574412)
Version #13
update website of feature #maproulette https://maproulette.org/browse/challenges/38361Änderungssatz #133684495
Standort: 49,4092888, 8,7006167
https://www.openstreetmap.org/node/1029574412#map=19/49.40929/8.70062

and thirdly


Relation: KurfĂźrst-Friedrich-Gymnasium (13561009)
Version #1 Schule verbessert
Bearbeitet vor Ăźber einem Jahr von whb
Änderungssatz #115050392
Weg: Eine-Welt-Schule (48788425)
https://www.openstreetmap.org/relation/13561009

that said - i guess that i now am able to take some parts of this dataset and build a query for the overpass -turbo to run a request for vizualization

see the above mentioned example - ( of course with other datasets)

[out:json][timeout:25];
(
  way(148345076);
  way(257150895);
  way(48788425);
);
out body
>;
out skel qt;

and finally i get some visualziation like this .

image
image1180×471 63.4 KB

i guess that this is a way to go … what do you say

look forward to hear from you

regards

#12

Perhaps another approach with overpass-turbo might also be suitable

/* Define cities/areas: */
area[name="Heidelberg"]->.HD;
area[name="Mannheim"]->.MA;
area[name="Bruchsal"]->.BR;

/* search school by name and city/area: */
(
  nwr ["amenity"="school"] ["name" = "KurfĂźrst-Friedrich-Gymnasium"](area.HD)  ;
  nwr ["amenity"="school"]["name"="Geschwister-Scholl-Gymnasium"](area.MA)  ;
  nwr ["amenity"="school"]["name"="Käthe-Kollwitz-Schule"] (area.BR);
); 

(._;>;);
out;
2 Likes
#13

hello dear @msoosm many thanks for your reply and for sharing your ideas. That is a great idea. I am glad.

Regards tagtheworld