NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

sorry for the newbie question.

What would be the overpass query to get the following:

For example https://www.openstreetmap.org/node/7158766201

it should be found by solely handing over "Q83630092" and the query should return the "Location" coordinates and optionally also '7158766201'

as a collateral, we might restrict the results to amentiy "fountain" or "drinking_water" .

Any help would be highly appreciated.

asked 26 Jan '20, 09:03

ralfhauser's gravatar image

ralfhauser
26113
accept rate: 0%

edited 29 Jan '20, 10:30


Hi

This is the correct place for newbie questions.

This will return what you want:

node[amenity=fountain][wikidata=Q83630092];
out center;

https://overpass-turbo.eu/s/Q62

If you don't know if the entity was mapped as a single point, swap node for nwr (Node, Way, Relation),

If you want to search for all in area of visible screen:

[bbox:{{bbox}}];
nwr[amenity=fountain][wikidata];
out geom;

https://overpass-turbo.eu/s/Q64

You should be able to work out how to filter for drinking_water from these examples.

If you want to output as a CSV list, add [out:csv(::id, "name", "wikidata"; false; ",")] as line one.

To tie in with your other posted question - to find entities which don't have name (or wikipedia) tags add an exclamation mark:

[bbox:{{bbox}}];
nwr[amenity=fountain][wikidata][!name];
out geom;
permanent link

answered 26 Jan '20, 11:19

DaveF's gravatar image

DaveF
3.3k8498133
accept rate: 16%

edited 26 Jan '20, 11:43

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×483
×19

question asked: 26 Jan '20, 09:03

question was seen: 1,451 times

last updated: 29 Jan '20, 10:30

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum