User:1ucyp/Queries/Museums by number of sitelinks to different language wikipedias

From Wikidata
Jump to navigation Jump to search

Also with help from TweetsFactsAndQueries

# Map of Germanophone Museums by number of sitelinks to different language wikipedias
#defaultView:Map
SELECT ?GLAM ?GLAMLabel ?coord ?layer ?image 
WHERE {
    ?GLAM wdt:P31/wdt:P279* wd:Q33506;                                                    # find all museums
    {?GLAM wdt:P17 wd:Q39} UNION {?GLAM wdt:P17 wd:Q40} UNION  {?GLAM wdt:P17 wd:Q183}    # located in Switzerland, Austria & Germany  
  
OPTIONAL { ?GLAM wdt:P625 ?coord. }                                                       # get the geographical location, if available
OPTIONAL { ?GLAM wdt:P18 ?image. }                                                        # get an image of the museum, if available
  
  ?GLAM wikibase:sitelinks ?sitelinks.
  BIND(IF(?sitelinks >= 5, "5+", ?sitelinks) AS ?layer)
  
SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
Try it!