query-81e11e6efab9d685fc6b40fc2cbbfed6

rq turtle/ttl

Fehlende Straßennamen

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?entity ?entityLabel 
WHERE { 
  VALUES ?instance_of {
    wd:Q34442      # Straße
    wd:Q79007      # Innerortstraße
    wd:Q21000333   # Einkaufsstraße 
    wd:Q174782     # Platz
    wd:Q537127     # Straßenbrücke
    wd:Q3397519    # Spannbetonbrücke 
    wd:Q1055465    # Balkenbrücke
    wd:Q57577442   # Feldweg
    wd:Q207934     # Allee
    wd:Q628179     # Weg
    wd:Q5004679    # Weg
    wd:Q221722     # Radweg
    wd:Q787113     # Promenade
    wd:Q1320830    # Ladenpassage
    } 
  ?entity wdt:P31 ?instance_of ;
          FILTER NOT EXISTS{ ?entity wdt:P5816 wd:Q63065035 } .  
  ?entity wdt:P8138 wd:Q76356866 .  
  MINUS { { ?entity a wdno:P138 . } UNION { ?entity wdt:P138 ?prop . } }  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?entity"):::projected v2("?instance_of") v3("?prop") c10(["bd:serviceParam"]):::iri c5(["wd:Q76356866"]):::iri c7(["wdno:P138"]):::iri c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q63065035"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P5816"--> e0c2 e0v1("?entity"):::projected e0c2(["wd:Q63065035"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"wdt:P5816"--> c2 bind1[/VALUES ?instance_of/] bind1-->v2 bind10(["wd:Q34442"]) bind10 --> bind1 bind11(["wd:Q79007"]) bind11 --> bind1 bind12(["wd:Q21000333"]) bind12 --> bind1 bind13(["wd:Q174782"]) bind13 --> bind1 bind14(["wd:Q537127"]) bind14 --> bind1 bind15(["wd:Q3397519"]) bind15 --> bind1 bind16(["wd:Q1055465"]) bind16 --> bind1 bind17(["wd:Q57577442"]) bind17 --> bind1 bind18(["wd:Q207934"]) bind18 --> bind1 bind19(["wd:Q628179"]) bind19 --> bind1 bind110(["wd:Q5004679"]) bind110 --> bind1 bind111(["wd:Q221722"]) bind111 --> bind1 bind112(["wd:Q787113"]) bind112 --> bind1 bind113(["wd:Q1320830"]) bind113 --> bind1 v1 --"wdt:P31"--> v2 v1 --"wdt:P8138"--> c5 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v1 --"wdt:P138"--> v3 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v1 --"a"--> c7 end union0r <== or ==> union0l end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end