query-3bc245d0d33875abb87fb010d3084667

rq turtle/ttl

Berge in Europa < 4000 mH

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
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#>
#defaultView:Map
SELECT DISTINCT ?subj ?label ?article ?page_title ?coord ?height ?continent (GROUP_CONCAT(DISTINCT ?country; SEPARATOR = ", ") AS ?staat) WHERE {
  ?subj wdt:P31 wd:Q8502;
    wdt:P17 ?cy;
    wdt:P625 ?coord;
    (p:P2044/psn:P2044/wikibase:quantityAmount) ?height.
  OPTIONAL { ?subj wdt:P30 ?con. }
  OPTIONAL {
    ?article schema:about ?subj;
      schema:isPartOf <https://de.wikipedia.org/>;
      schema:name ?page_title.
  }
  # Filtern ?subj oder ?cy nach wdt:P30 (Kontinent) scheitert beides, nicht alle Berge sind zu Europa zugeordnet
  # und auch Kasachstan und die Türkei sind zu Europa zugeordnet, deren Berge aber sind in (Klein)Asien 
  FILTER((?height > 4000 ) && (?cy IN(wd:Q230, wd:Q39, wd:Q38, wd:Q142, wd:Q227)))
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en,de".
    ?subj rdfs:label ?label.
    ?cy rdfs:label ?country.
    ?con rdfs:label ?continent.
  }
}
GROUP BY ?subj ?label ?article ?page_title ?coord ?height ?continent
ORDER BY DESC (?height)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?article"):::projected v5("?con") v10("?continent"):::projected v4("?coord"):::projected v9("?country"):::projected v2("?cy") v1("?height"):::projected v8("?label"):::projected v7("?page_title"):::projected v11("?staat") v3("?subj"):::projected a1((" ")) a2((" ")) c17([https://de.wikipedia.org/]):::iri c22(["en,de"]):::literal c20(["bd:serviceParam"]):::iri c8(["wd:Q8502"]):::iri list0c2(["wd:Q39"]):::iri list0c3(["wd:Q38"]):::iri list0c5(["wd:Q227"]):::iri list0c1(["wd:Q230"]):::iri list0c4(["wd:Q142"]):::iri list0c1 --o f0 list0c2 --o f0 list0c3 --o f0 list0c4 --o f0 list0c5 --o f0 f0[["?height > '4000^^xsd:integer' in "]] f0 --> v1 f0 --> v2 v3 --"p:direct/P31"--> c8 v3 --"p:direct/P17"--> v2 v3 --"p:direct/P625"--> v4 v3 --"p:P2044"--> a1 a1 --"p:statement/value-normalized/P2044"--> a2 a2 --"wikibase:quantityAmount"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P30".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."schema:about".-> v3 v6 --"schema:isPartOf"--> c17 v6 --"schema:name"--> v7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c20 --"wikibase:language"--> c22 v3 --"rdfs:label"--> v8 v2 --"rdfs:label"--> v9 v5 --"rdfs:label"--> v10 end bind2[/"?country"/] v9 --o bind2 bind2 --as--o v11