query-98bb90191fe58dba8c930a46b08d8a51
Superficie J'ai réverté tes changement de superficie parce que tu as mis une incertitude (±1) et que la superficie était exacte et sourcé. D'ailleurs on peut très bien dans un recher mettre le tout à la même unité:
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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?park ?parkLabel ?countryLabel ?size WHERE {
# Aire protégée par ordre décroissant par hectare
?park wdt:P31/wdt:P279* wd:Q473972 .
?park p:P2046 ?sizeS .
?sizeS ?sp ?sv .
?park wdt:P17 ?country .
?sv rdf:type wikibase:QuantityValue .
{
?sv wikibase:quantityAmount ?size .
?sv wikibase:quantityUnit wd:Q35852 . # hectare
} UNION {
?sv wikibase:quantityAmount ?ha.
?sv wikibase:quantityUnit wd:Q712226 . # kilomètre carré
BIND(ROUND((?ha *100)) AS ?size)
} UNION {
?sv wikibase:quantityAmount ?sqmi.
?sv wikibase:quantityUnit wd:Q232291 . # mille carré
BIND(ROUND((?sqmi *258.999)) AS ?size)
} UNION {
?sv wikibase:quantityAmount ?ac.
?sv wikibase:quantityUnit wd:Q81292 . # acre
BIND(ROUND((?ac *0.404686)) AS ?size)
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "fr, en" .
}
} ORDER BY DESC(?size)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?ac")
v6("?country")
v7("?ha")
v2("?park"):::projected
v10("?size"):::projected
v3("?sizeS")
v4("?sp")
v8("?sqmi")
v5("?sv")
a1((" "))
c17(["fr, en"]):::literal
c3(["wd:Q473972"]):::iri
c7(["wikibase:QuantityValue"]):::iri
c12(["wd:Q232291"]):::iri
c15(["bd:serviceParam"]):::iri
c10(["wd:Q35852"]):::iri
c13(["wd:Q81292"]):::iri
c11(["wd:Q712226"]):::iri
v2 --"p:direct/P31"--> a1
a1 --"p:direct/P279"--> c3
v2 --"p:P2046"--> v3
v3 -->v4--> v5
v2 --"p:direct/P17"--> v6
v5 --"a"--> c7
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
v5 --"wikibase:quantityAmount"--> v9
v5 --"wikibase:quantityUnit"--> c13
bind0[/"numeric-round(?ac * '0.404686^^xsd:decimal')"/]
v9 --o bind0
bind0 --as--o v10
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
v5 --"wikibase:quantityAmount"--> v8
v5 --"wikibase:quantityUnit"--> c12
bind1[/"numeric-round(?sqmi * '258.999^^xsd:decimal')"/]
v8 --o bind1
bind1 --as--o v10
end
union2r <== or ==> union2l
end
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v5 --"wikibase:quantityAmount"--> v7
v5 --"wikibase:quantityUnit"--> c11
bind2[/"numeric-round(?ha * '100^^xsd:integer')"/]
v7 --o bind2
bind2 --as--o v10
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v5 --"wikibase:quantityAmount"--> v10
v5 --"wikibase:quantityUnit"--> c10
end
union0r <== or ==> union0l
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c15 --"wikibase:language"--> c17
end