query-179f78fba708c0249f82f043d006bc47
title: Smallest mountains in France SELECT DISTINCT ?item ?itemLabel ?elevation ?unit ?unitLabel ?conversion ?elevation_in_m WHERE { ?item (wdt:P31/(wdt:P279*)) wd:Q8502; wdt:P17 wd:Q142; p:P2044 ?elevation_statement. ?elevation_statement psv:P2044 ?elevation_value. ?elevation_value wikibase:quantityAmount ?elevation; wikibase:quantityUnit ?unit. ?unit p:P2370 ?unit_statement. ?unit_statement psv:P2370 ?unit_value. ?unit_value wikibase:quantityAmount ?conversion; wikibase:quantityUnit wd:Q11573. BIND(?elevation * ?conversion AS ?elevation_in_m) FILTER(?elevation_in_m >= 0) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". } } ORDER BY (?elevation_in_m) LIMIT 100
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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Smallest mountains in France
SELECT DISTINCT ?item ?itemLabel ?elevation ?unit ?unitLabel ?conversion ?elevation_in_m WHERE {
?item (wdt:P31/(wdt:P279*)) wd:Q8502;
wdt:P17 wd:Q142;
p:P2044 ?elevation_statement.
?elevation_statement psv:P2044 ?elevation_value.
?elevation_value wikibase:quantityAmount ?elevation;
wikibase:quantityUnit ?unit.
?unit p:P2370 ?unit_statement.
?unit_statement psv:P2370 ?unit_value.
?unit_value wikibase:quantityAmount ?conversion;
wikibase:quantityUnit wd:Q11573.
BIND(?elevation * ?conversion AS ?elevation_in_m)
FILTER(?elevation_in_m >= 0)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
}
ORDER BY (?elevation_in_m)
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?conversion"):::projected
v5("?elevation"):::projected
v10("?elevation_in_m"):::projected
v3("?elevation_statement")
v4("?elevation_value")
v2("?item"):::projected
v6("?unit"):::projected
v7("?unit_statement")
v8("?unit_value")
a1((" "))
c17(["#91;AUTO_LANGUAGE#93;, en"]):::literal
c13(["wd:Q11573"]):::iri
c15(["bd:serviceParam"]):::iri
c4(["wd:Q8502"]):::iri
c6(["wd:Q142"]):::iri
f0[["?elevation_in_m >= '0^^xsd:integer'"]]
f0 --> v10
v2 --"p:direct/P31"--> a1
a1 --"p:direct/P279"--> c4
v2 --"p:direct/P17"--> c6
v2 --"p:P2044"--> v3
v3 --"p:statement/value/P2044"--> v4
v4 --"wikibase:quantityAmount"--> v5
v4 --"wikibase:quantityUnit"--> v6
v6 --"p:P2370"--> v7
v7 --"p:statement/value/P2370"--> v8
v8 --"wikibase:quantityAmount"--> v9
v8 --"wikibase:quantityUnit"--> c13
bind1[/"?elevation * ?conversion"/]
v5 --o bind1
v9 --o bind1
bind1 --as--o v10
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c15 --"wikibase:language"--> c17
end