Wikidata: information about streets and squares (named after, images, ...)

A Wikidata SPARQL query which lists als streets and squares in Meidling, with who/what they are named after and since when, if the street/square has an image and/or a image of the sign and the ID of the Wien Geschichte Page. To change the district, replace the wd:Q... value in the "# Meidling" row by the ID of the place.

Try it!

SELECT DISTINCT ?item ?itemLabel ?namedAfterLabel ?namedAfterStart ?image ?sign ?wienGeschichte WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
    { ?item wdt:P31 wd:Q174782. } # Platz 
    UNION
    { ?item wdt:P31 wd:Q79007. } # Innerortstraße
    UNION
    { ?item wdt:P31/wdt:P279* wd:Q12280. } # Brücke
  OPTIONAL {?item wdt:P18 ?image}.
  OPTIONAL {?item wdt:P1766 ?sign}.
  OPTIONAL {?item wdt:P7842 ?wienGeschichte.}
  OPTIONAL {?item wdt:P625 ?coord.}

  ?item wdt:P131 wd:Q697557; # Meidling

  OPTIONAL {
    ?item p:P138 ?namedAfterProp.
    ?namedAfterProp ps:P138 ?namedAfter.
    OPTIONAL { ?namedAfterProp pq:P580 ?namedAfterStart. }  
  }
}
ORDER BY ?itemLabel