query-6ae370415eccf5112de1da03682743a2

rq turtle/ttl

title:find UNESCO stuff for karthographer SELECT ?id ?geo (concat(?articleLink, '[[File:Wikidata-logo S.svg|16px|link=d:', substr(str(?id),32,13), ']]', (SAMPLE(?idBild))) as ?description) ('small' as ?marker_size) ?marker_color WHERE { ?id wdt:P17 ?country. VALUES ?country {wd:Q40}. # {wd:}.Q843 ?id wdt:P1435 wd:Q9259. ?id wdt:P757 []. ?id wdt:P625 ?geo. SERVICE wikibase:label { bd:serviceParam wikibase:language 'de,en' . ?id rdfs:label ?idLabel . } OPTIONAL { ?id wdt:P18 ?img .} BIND(IF(BOUND(?img), concat('\n', '[[File:', substr(str(?img), 52, 400), '|250px]]'), '') AS ?idBild) . OPTIONAL { ?id p:P1435 ?statement. ?statement ps:P1435 wd:Q9259. ?statement pq:P580 []. #VALUES ?year {1997}. } bind(if(BOUND(?img), if(BOUND(?end), '#80F080', '#008000'), if(BOUND(?end), '#F08080', '#800000')) as ?marker_color). optional { ?link schema:about ?id . ?link schema:isPartOf https://de.wikipedia.org/ . ?link schema:name ?lemma . } bind (if(Bound(?link), concat('[[:de:', ?lemma, '|',?idLabel,']]\n'), concat(?idLabel,'\n')) as ?articleLink). } GROUP BY ?id ?geo ?articleLink ?marker_color

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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#>
#title:find UNESCO stuff for karthographer 
SELECT ?id ?geo 
                (concat(?articleLink, '[[File:Wikidata-logo S.svg|16px|link=d:', substr(str(?id),32,13), ']]', (SAMPLE(?idBild))) as ?description)
                ('small' as ?marker_size) ?marker_color
         WHERE { ?id wdt:P17 ?country.
                 VALUES ?country {wd:Q40}. # {wd:}.Q843
                 ?id wdt:P1435 wd:Q9259.
                 ?id wdt:P757 [].
                 ?id wdt:P625 ?geo.
                 SERVICE wikibase:label { bd:serviceParam wikibase:language 'de,en' .
                                          ?id rdfs:label ?idLabel . }
                 OPTIONAL { ?id wdt:P18 ?img .}
                 BIND(IF(BOUND(?img), concat('\\n', '[[File:', substr(str(?img), 52, 400), '|250px]]'), '') AS ?idBild) .
                 OPTIONAL {
                    ?id p:P1435 ?statement.
                    ?statement ps:P1435 wd:Q9259.
                    ?statement pq:P580 [].
                    #VALUES ?year {1997}.
                    }
                 bind(if(BOUND(?img), if(BOUND(?end), '#80F080', '#008000'), if(BOUND(?end), '#F08080', '#800000')) as ?marker_color).
                 optional {
                    ?link schema:about ?id .
                    ?link schema:isPartOf <https://de.wikipedia.org/> .
                    ?link schema:name ?lemma .
                 }
                    bind (if(Bound(?link), concat('[[:de:', ?lemma, '|',?idLabel,']]\\n'), concat(?idLabel,'\\n')) as ?articleLink).
               }
         GROUP BY ?id ?geo ?articleLink ?marker_color

Query found at

• https://www.wikidata.org/wiki/User:Herzi_Pinki/Sparql