query-f9266b5ec0a9db77ed742f27104ff2b3
Query optimization - getting and ordering elevation in metresHi, I'm trying to retrieve the elevation in metres and order it. This works and returns within a reasonable time, but contains values in both feet and metres:
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT distinct ?elevation ?item
WHERE
{?item wdt:P31 wd:Q8502.
?item wdt:P2044 ?elevation.
}order by desc(?elevation) limit 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?elevation"):::projected
v2("?item"):::projected
c2(["wd:Q8502"]):::iri
v2 --"wdt:P31"--> c2
v2 --"wdt:P2044"--> v1