query-8457b692c165d16af527b98f2e2100cd

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?item_label ?peakbaggerID ?coordinate (ROUND(AVG(?elevation)) AS ?elev) (0.1*ROUND(10*?isolation) AS ?iso) (ROUND(?prominence) AS ?prom)
WHERE 
{

  ?item wdt:P4552+ wd:Q1286.
  ?item wdt:P31/wdt:P279* wd:Q106589819.
  ?item p:P2660 ?stmnode.
  ?stmnode psn:P2660 ?valuenode.                                     # convert foot values to metres
  ?valuenode wikibase:quantityAmount ?prominence.
  ?valuenode wikibase:quantityUnit ?unit.
  FILTER(?prominence > 1500)
  MINUS { ?item wdt:P610 ?highpoint . }                              # exclude massifs of which the summit has its own item
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
                          ?item rdfs:label ?item_label.
                         }  
  OPTIONAL { ?item wdt:P625 ?coordinate . }
  OPTIONAL { ?item wdt:P2044 ?elevation . }
  OPTIONAL { ?item wdt:P2659 ?isolation . }
  OPTIONAL { ?item wdt:P3109 ?peakbaggerID . }
}
GROUP BY ?item ?item_label ?continent ?peakbaggerID ?coordinate ?isolation ?prominence
ORDER BY DESC(?prom)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v9("?coordinate"):::projected v13("?elev") v10("?elevation") v7("?highpoint") v14("?iso") v11("?isolation"):::projected v3("?item"):::projected v8("?item_label"):::projected v12("?peakbaggerID"):::projected v15("?prom") v2("?prominence"):::projected v4("?stmnode") v6("?unit") v5("?valuenode") a1((" ")) c15(["en"]):::literal c13(["bd:serviceParam"]):::iri c6(["wd:Q106589819"]):::iri c3(["wd:Q1286"]):::iri f0[["?prominence > '1500^^xsd:integer'"]] f0 --> v2 v3 --"p:direct/P4552"--> c3 v3 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c6 v3 --"p:P2660"--> v4 v4 --"p:statement/value-normalized/P2660"--> v5 v5 --"wikibase:quantityAmount"--> v2 v5 --"wikibase:quantityUnit"--> v6 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v3 --"p:direct/P610"--> v7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 v3 --"rdfs:label"--> v8 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P625".-> v9 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P2044".-> v10 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P2659".-> v11 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P3109".-> v12 end bind3[/"numeric-round()"/] null --o bind3 bind3 --as--o v13 bind4[/"'0.1^^xsd:decimal' * numeric-round('10^^xsd:integer' * ?isolation)"/] v11 --o bind4 bind4 --as--o v14 bind5[/"numeric-round(?prominence)"/] v2 --o bind5 bind5 --as--o v15