query-c3a1bd9cd0fdc8c1fcbcdbfdfcb58620

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 schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?id ?geo                (concat('[[:de:', '', '#', substr(str(?id),32,13), '|', ?idLabel, ']]', '\\n', '[[File:Wikidata-logo S.svg|16px|link=d:', substr(str(?id),32,13), ']]', (SAMPLE(?idBild))) as ?description)
                ('building' as ?marker_symbol) ('small' as ?marker_size) ?marker_color
    WHERE {?id wdt:P2817 ?list.
           ?id wdt:P625 ?geo.
           #VALUES ?list {wd:}.
           VALUES ?list {wd:Q1859286}.
           SERVICE wikibase:label { bd:serviceParam wikibase:language 'de,en' .
                                   ?id rdfs:label ?idLabel . }
           OPTIONAL { ?id wdt:P18 ?img .}
           optional {?id p:P18 [a wdno:P18]. }
           BIND(IF(BOUND(?img), concat('\\n', '[[File:', substr(str(?img), 52, 400), '|250px]]'), '') AS ?idBild) .
           OPTIONAL {
             ?id p:P1435 ?statement.
             ?statement ps:P1435 wd:Q1188447.
             ?statement pq:P582 ?end.}
             bind(if(BOUND(?img), if(BOUND(?end), '#80F080', '#008000'), if(BOUND(?end), '#F08080', '#800000')) as ?marker_color).
           ?link schema:about ?list .
           ?link schema:isPartOf <https://de.wikipedia.org/> .}
GROUP BY ?id ?geo ?link ?idLabel ?marker_color

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v11("?_anon_d00291b7e9a143df8ec0be8c8ebd714c11635"):::projected v12("?description") v8("?end") v3("?geo"):::projected v1("?id"):::projected v6("?idBild") v4("?idLabel"):::projected v5("?img") v10("?link") v4("?list") v9("?marker_color"):::projected v14("?marker_size") v13("?marker_symbol") v7("?statement") a1((" ")) c18([https://de.wikipedia.org/]):::iri c10(["p:novalue/P18"]):::iri c4(["bd:serviceParam"]):::iri c6(["de,en"]):::literal c14(["wd:Q1188447"]):::iri v1 --"p:direct/P2817"--> v4 v1 --"p:direct/P625"--> v3 bind0[/VALUES ?list/] bind0-->v4 bind00(["wd:Q1859286"]) bind00 --> bind0 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 v1 --"rdfs:label"--> v4 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P18".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; a1 -."a".-> c10 v1 --"p:P18"--> a1 end bind1[/"if(bound(?img),concat('\n','#91;#91;File:',substring(str(?img),'52^^xsd:integer','400^^xsd:integer'),'|250px#93;#93;'),'')"/] v5 --o bind1 bind1 --as--o v6 subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:P1435".-> v7 v7 --"p:statement/P1435"--> c14 v7 --"p:qualifier/P582"--> v8 end bind2[/"if(bound(?img),if(bound(?end),'#80F080','#008000'),if(bound(?end),'#F08080','#800000'))"/] v5 --o bind2 v8 --o bind2 bind2 --as--o v9 v10 --"schema:about"--> v4 v10 --"schema:isPartOf"--> c18 bind4[/"sample(?idBild)"/] v6 --o bind4 bind4 --as--o v11 bind5[/"concat('#91;#91;:de:','','#',substring(str(?id),'32^^xsd:integer','13^^xsd:integer'),'|',?idLabel,'#93;#93;','\n','#91;#91;File:Wikidata-logo S.svg|16px|link=d:',substring(str(?id),'32^^xsd:integer','13^^xsd:integer'),'#93;#93;',)"/] v1 --o bind5 v4 --o bind5 null --o bind5 bind5 --as--o v12 bind6[/"'building'"/] bind6 --as--o v13 bind7[/"'small'"/] bind7 --as--o v14