User:Nortix08/Stadttafeln Hannover
Jump to navigation
Jump to search
Try it!
Commons
[edit]{{On OSM |type=node |OSM_ID= }}
{{Open Plaques|plaqueid= }}
{{Wikidata Infobox}}
Dokumentation bei Commons:
OSM
[edit]siehe DE:Tag:memorial=plaque
Fortschritt
[edit]all entities | count | all groupings | without grouping property | below threshold (1) | Querying about commemorative plaque (Q721747) 
, Stadttafel in Hannover, Germany (Q67506051) , preserved (Q56557591) Grouping by located in the administrative territorial entity (P131)
, Stadttafel in Hannover, Germany (Q67506051) , preserved (Q56557591) Grouping by located in the administrative territorial entity (P131)| Top groupings (Minimum 1 items) | Top Properties (used at least 0 times per grouping) | ||||
|---|---|---|---|---|---|
| Name | Count | main subject (P921) | OpenStreetMap node ID (P11693) | image (P18) | Open Plaques plaque ID (P1893) |
| Mitte (Q883803) | 63 | 76.19% (48) 🔍 | 73.02% (46) 🔍 | 100.0% (63) 🔍 | 100.0% (63) 🔍 |
| Linden-Limmer (Q1826001) | 14 | 92.86% (13) 🔍 | 100.0% (14) 🔍 | 100.0% (14) 🔍 | 100.0% (14) 🔍 |
| Nord (Q1997469) | 9 | 88.89% (8) 🔍 | 88.89% (8) 🔍 | 100.0% (9) 🔍 | 100.0% (9) 🔍 |
| Südstadt-Bult (Q2381488) | 9 | 77.78% (7) 🔍 | 100.0% (9) 🔍 | 100.0% (9) 🔍 | 100.0% (9) 🔍 |
| Buchholz-Kleefeld (Q998471) | 7 | 71.43% (5) 🔍 | 100.0% (7) 🔍 | 100.0% (7) 🔍 | 100.0% (7) 🔍 |
| Herrenhausen-Stöcken (Q470577) | 7 | 57.14% (4) 🔍 | 100.0% (7) 🔍 | 100.0% (7) 🔍 | 100.0% (7) 🔍 |
| Vahrenwald-List (Q915149) | 5 | 100.0% (5) 🔍 | 80.0% (4) 🔍 | 100.0% (5) 🔍 | 80.0% (4) 🔍 |
| Kirchrode-Bemerode-Wülferode (Q1743368) | 2 | 100.0% (2) 🔍 | 100.0% (2) 🔍 | 100.0% (2) 🔍 | 100.0% (2) 🔍 |
| Ricklingen (Q1417763) | 1 | 100.0% (1) 🔍 | 100.0% (1) 🔍 | 100.0% (1) 🔍 | 100.0% (1) 🔍 |
| Bothfeld-Vahrenheide (Q894709) | 1 | 100.0% (1) 🔍 | 100.0% (1) 🔍 | 100.0% (1) 🔍 | 100.0% (1) 🔍 |
| Ahlem-Badenstedt-Davenstedt (Q400430) | 1 | 100.0% (1) 🔍 | 100.0% (1) 🔍 | 100.0% (1) 🔍 | 100.0% (1) 🔍 |
| Totals (all items) | 119 | 79.83% (95) 🔍 | 84.03% (100) 🔍 | 100.0% (119) 🔍 | 99.16% (118) 🔍 |
Liste der Stadttafeln
[edit]This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q721747; wdt:P361 wd:Q67506051. }
erhalten
[edit]
_Stadttafel_117_f%C3%BCr_Nr._28,_hier_ehemals_Brauergildehaus.JPG)
.JPG)
,_Historisches_Museum_Hannover.jpg)
_IMG_3207.JPG)
.jpg)
.jpg)
verlassen
[edit]
Misc
[edit]| # | WD-Item | Stadtteil | OSM Node | Commons-Kategorie | Bild |
|---|---|---|---|---|---|
| 1 | Stadttafel Herschelstraße 31 | Mitte | Stadttafel Herschelstraße (Hannover) |  |
End of automatically generated list.
Abfragen
[edit]#defaultView:Map{"hide":["?geographische_Koordinaten", "?layer", "?StadttafelOrdnungsnummer"]}
#---------------------------
# Erhaltene Stadttafeln in Hannover mit und ohne Bild
#---------------------------
SELECT ?Stadttafel ?StadttafelLabel ?StadttafelOrdnungsnummer ?geographische_Koordinaten ?Bild ?layer
WHERE {
?Stadttafel wdt:P31 wd:Q721747;
wdt:P361 wd:Q67506051;
wdt:P5816 wd:Q56557591.
OPTIONAL {
?Stadttafel wdt:P625 ?geographische_Koordinaten;
MINUS {?Stadttafel wdt:P18 ?Bild}
BIND ("Kein Bild vorhanden/No picture available" AS ?layer)
}
OPTIONAL {
?Stadttafel wdt:P18 ?Bild;
wdt:P625 ?geographische_Koordinaten.
BIND ("Bild vorhanden/Picture available" AS ?layer)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY ?StadttafelOrdnungsnummer