query-b70b746a20964c8574b025cf6ffc8c78

rq turtle/ttl

Map showing artist-run initiativesShowing how few are identified by Wikipedia articles or Wikidata items

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:Map
SELECT DISTINCT ?loc ?placeLabel ?place ?placeURI ?layer WHERE {  
 { {?place wdt:P31 wd:Q3325736 } UNION { ?place wdt:P31 wd:Q4034417} UNION { ?place wdt:P31 wd:Q1400264} }  . 
  ?place wdt:P625 ?loc .
  ?place rdfs:label ?placeLabel. FILTER(LANG(?placeLabel) = "en").
  optional { ?place wdt:P18 ?placeURI } .
  optional { ?place wdt:P571 ?placeDate . bind (year(?placeDate) AS ?placeYr). }.
  BIND (IF(?placeYr < 1970, "early", IF(?placeYr < 1980, "1970s", IF(?placeYr < 1990, "1980s", IF(?placeYr < 2000, "1990s", IF(?placeYr < 2010, "2000s", "recent"))) ) ) AS ?layer)
} LIMIT 3000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?layer"):::projected v3("?loc"):::projected v2("?place"):::projected v5("?placeDate") v1("?placeLabel"):::projected v4("?placeURI"):::projected v6("?placeYr") c3(["wd:Q3325736"]):::iri c4(["wd:Q4034417"]):::iri c5(["wd:Q1400264"]):::iri f0[["?placeLabel = 'en'"]] 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; v2 --"wdt:P31"--> c5 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> c4 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> c3 end union0r <== or ==> union0l end v2 --"wdt:P625"--> v3 v2 --"rdfs:label"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P18".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P571".-> v5 bind1[/"year-from-dateTime(?placeDate)"/] v5 --o bind1 bind1 --as--o v6 end bind2[/"if(?placeYr < '1970^^xsd:integer','early',if(?placeYr < '1980^^xsd:integer','1970s',if(?placeYr < '1990^^xsd:integer','1980s',if(?placeYr < '2000^^xsd:integer','1990s',if(?placeYr < '2010^^xsd:integer','2000s','recent')))))"/] v6 --o bind2 bind2 --as--o v7