Malline:Esimerkkikaaviot/Long lakes map example

{{Esimerkkikaaviot/Long lakes map example}}
[ source data ]

Description

Map of lakes with name "Long lake" in Sweden and different colors are different spellings. Map is remake of File:Laangsjoen.svg.

Graph template

{{Esimerkkikaaviot/Long lakes map example/graph}}

Query

SELECT DISTINCT ?city ?cityLabel  ?gps (?layer as ?fill)
WHERE 
{
  ?city (wdt:P31/wdt:P279*) wd:Q23397.
  ?city wdt:P17 wd:Q34.  
  ?city wdt:P625 ?gps .
  ?city rdfs:label ?layer .  
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "sv" .
  }
  FILTER regex(?layer, "Långsjön|Långtjärn|Långträsket|Gukkesjaure|Kukkajaure|Kukkesjaure|Kukasjärvi|Pitkäjärvi|Långetjärn|Långatjärn|Kukkesjauratj|Gukkejaure|Gukkisträsket|Gukkesjauratj|Kukkajauratj", "i") 

}
ORDER BY DESC(?cityLabel)

Kokeile