query-a9609971139c21dd54cb1bc533579e66

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#---------------------------------------------------------------------------------------
# Objekte sortiert nach Schlüsselereignissen
#---------------------------------------------------------------------------------------


#defaultView:Table;Map
SELECT DISTINCT ?item ?itemLabel ?time  ?coordinate ?layer ?image (CONCAT(?street," ", ?housenumber) as ?str)
#?altesdresden
WHERE {

   {
      ?item (wdt:P131/wdt:P279*) wd:Q1731.  # in Dresden
      ?item wdt:P571 ?time.               # erbaut
      BIND("erbaut" AS ?layer ) .
   }
   union
   {
      ?item (wdt:P131/wdt:P279*) wd:Q1731.  
      ?item wdt:P1249 ?time.                # ?erste schrift
      BIND("ErstErwähnung" AS ?layer ) .
   }
   union
   {
      ?item (wdt:P131/wdt:P279*) wd:Q1731.  
      ?item wdt:P813 ?time.                # ?auflösung
      BIND("Auflösung" AS ?layer ) .
   } 
   union
   {
      ?item (wdt:P131/wdt:P279*) wd:Q1731.  
      ?item wdt:P1619 ?time.                # ?Einweihung
      BIND("Einweihung" AS ?layer ) .
   } 
   #union
   #{
   #   ?item (wdt:P131/wdt:P279*) wd:Q1731.  
   #   ?item wdt:P793 [  pq:* ?time ].                # ?Schluesselereignis
   #   BIND("Schluesselereignis" AS ?layer ) .
   #}   




  FILTER (?time <= "1946-01-01T00:00:00Z"^^xsd:dateTime)  # vor 1945

  #OPTIONAL { ?item wdt:P11855 ?altesdresden. }
  MINUS { ?item wdt:P11855 [] } . # kein altesdresden

  OPTIONAL { ?item wdt:P18 ?image . }
  OPTIONAL { ?item wdt:P625 ?coordinate . }
  OPTIONAL { ?item wdt:P669 ?street.  }                     # Straße
  OPTIONAL { ?item p:P669 [  pq:P670 ?housenumber ]  . }    # Hausnummer    
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en,[AUTO_LANGUAGE]". }
}
order by ?time

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?coordinate"):::projected v7("?housenumber"):::projected v4("?image"):::projected v2("?item"):::projected v4("?layer"):::projected v8("?str") v6("?street"):::projected v1("?time"):::projected a5((" ")) a1((" ")) a2((" ")) a3((" ")) a4((" ")) a6((" ")) c16(["bd:serviceParam"]):::iri c4(["wd:Q1731"]):::iri c18(["de,en,#91;AUTO_LANGUAGE#93;"]):::literal f0[["?time <= '1946-01-01T00:00:00Z^^xsd:dateTime'"]] f0 --> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P131"--> a4 a4 --"p:direct/P279"--> c4 v2 --"p:direct/P1619"--> v1 bind1[/"'Einweihung'"/] bind1 --as--o v4 end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P131"--> a3 a3 --"p:direct/P279"--> c4 v2 --"p:direct/P813"--> v1 bind2[/"'Auflösung'"/] bind2 --as--o v4 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P131"--> a2 a2 --"p:direct/P279"--> c4 v2 --"p:direct/P1249"--> v1 bind3[/"'ErstErwähnung'"/] bind3 --as--o v4 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P131"--> a1 a1 --"p:direct/P279"--> c4 v2 --"p:direct/P571"--> v1 bind4[/"'erbaut'"/] bind4 --as--o v4 end union0r <== or ==> union0l end subgraph minus5["MINUS"] style minus5 stroke-width:6px,fill:pink,stroke:red; v2 --"p:direct/P11855"--> a5 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P18".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P625".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P669".-> v6 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; a6 -."p:qualifier/P670".-> v7 v2 --"p:P669"--> a6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c16 --"wikibase:language"--> c18 end bind6[/"concat(?street,' ',?housenumber)"/] v6 --o bind6 v7 --o bind6 bind6 --as--o v8