Charlottenbrücke (Q5086224)

  • matcher place: Spandau (relation 16343), Berlin (relation 62422)
  • view on Wikidata
  • Wikipedia: English, German
  • Wikimedia Commons
  • English Wikipedia categories: Berlin building and structure stubs, Bridges in Berlin, European bridge (structure) stubs, German building and structure stubs, Germany transport stubs, Road bridges in Germany
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,52.53510,13.20620)[bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53510,13.20620)[bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53510,13.20620)[bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53510,13.20620)["bridge:structure"="arch"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53510,13.20620)["bridge:structure"="arch"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53510,13.20620)["bridge:structure"="arch"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53510,13.20620)[building=bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53510,13.20620)[building=bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53510,13.20620)[building=bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53510,13.20620)["man_made"="bridge"][name];
    way(around:1000,52.53510,13.20620)["man_made"="bridge"][name];
    rel(around:1000,52.53510,13.20620)["man_made"="bridge"][name];
    node(around:1000,52.53510,13.20620)["seamark:type"="bridge"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53510,13.20620)["seamark:type"="bridge"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53510,13.20620)["seamark:type"="bridge"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53510,13.20620)[type=bridge][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from Deutsch / German Wikipedia (dewiki)

Die Charlottenbrücke ist eine stählerne Stabbogenbrücke ohne Windverband im Berliner Ortsteil Spandau über die Havel. Sie ist eingetragen in die Liste der Kulturdenkmale in Berlin-Spandau mit der Objekt-Dokumentations Nr. 09085524.

Summary from English Wikipedia (enwiki)

Charlotten Bridge (German Charlottenbrücke) in Spandau links the old town of Spandau on the west bank of the Havel with the east bank.

Wikidata location: 52.5351, 13.2062 view on OSM or edit on OSM

matches

login to upload wikidata tags

found 2 match candidates

way: Charlottenbrücke (OSM)exact location match [show tags]
name: Charlottenbrücke
layer: 1
ref:lda: 09085524
heritage: 4
man_made: bridge
wikidata: Q5086224
wikipedia: de:Charlottenbrücke
start_date: 1928
lda:criteria: Baudenkmal
bridge:structure: beam
heritage:operator: lda
wikimedia_commons: Category:Charlottenbrücke (Berlin-Spandau)
name:etymology:wikidata: Q57674

wikidata match: Q5086224
node: Charlottenbrücke (OSM), 10 m from Wikidata [show tags]
name: Charlottenbrücke
source: http://www.wsa-berlin.wsv.de/wasserstrassen/bruecken/Durchfahrtshoehen_u._breiten_an_Bruecken05.pdf
obstacle: bridge
maxheight: 5.90
addr:country: DE
seamark:name: Charlottenbrücke
seamark:type: bridge
river:waterway_distance: 0.09
seamark:bridge:category: fixed
maxheight_referencelevel: 114
seamark:bridge:clearance_height: 5.90

Search criteria from Wikidata

view with query.wikidata.org

bridge (Q12280) bridge, seamark:type=bridge, man_made=bridge
arch bridge (Q158438) bridge:structure=arch

Search criteria from categories

Bridges in Berlin building=bridge, bridge, man_made=bridge, type=bridge
Road bridges in Germany building=bridge, bridge, man_made=bridge, type=bridge