query-cd80a019ebb3b1ddffc802ac1849f36d
Highest point per county in FinlandHow do I get the highest point (in meters) per (currently existing) county in Finland? I tried this, but I can't figure out how to limit it to just one highest point per country. Thank you for help!
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?point ?pointLabel (MAX(?height) AS ?maxheight) ?countyLabel WHERE {
?point wdt:P2044 ?height.
?point wdt:P131 ?county.
?county wdt:P17 wd:Q33.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fi,en". }
}GROUP BY ?point ?pointLabel ?countyLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?county")
v2("?height"):::projected
v4("?maxheight")
v1("?point"):::projected
c6(["bd:serviceParam"]):::iri
c8(["#91;AUTO_LANGUAGE#93;,fi,en"]):::literal
c4(["wd:Q33"]):::iri
v1 --"wdt:P2044"--> v2
v1 --"wdt:P131"--> v3
v3 --"wdt:P17"--> c4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end
bind1[/"max(?height)"/]
v2 --o bind1
bind1 --as--o v4