User:Arjoopy
| |||||||||||||||||||
Welcome on my user page. I'm from Thuringia between Jena and Ilmenau. Active here on Wikidata since July 2019, especially regarding the WikiProject Mountains.
General[edit]
Sample query[edit]
SELECT DISTINCT ?item ?item_label
WHERE
{
?item wdt:P279 wd:Q186131.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
?item rdfs:label ?item_label.
}
}
Quicklinks[edit]
- https://w.wiki/9NhC
- https://github.com/akirmse
- http://everymountainintheworld.com/
- https://www.andrewkirmse.com/
WikiProject Mountains: Ultras[edit]
Ultras of the Alps[edit]
SELECT DISTINCT ?item ?item_label ?peakbaggerID ?coordinate (ROUND(AVG(?elevation)) AS ?elev) (0.1*ROUND(10*?isolation) AS ?iso) (ROUND(?prominence) AS ?prom)
WHERE
{
hint:Query hint:optimizer "None".
?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)
WikiProject Mountains: Classification[edit]
Wikidata currently lacks clear definitions and classifications of elevations into classes like mountains, hills or summits. While editing hundreds or thousands of such items, I very often encountered this problem so I'm trying to find a classification scheme. See here for more.
WikiProject Mountains: Data Acquisition[edit]
While the frequently climbed mountains of countries like Austria and Switzerland are meanwhile well described here on Wikidata, other parts of the world are pretty much neglected so far. This part of my work is supposed to depict an approach to systematically and comprehensive gather data about mountains in specific areas.
To sufficiently describe a mountain, I add or review the following six properties:
- instance of (P31) – (in most cases mountain (Q8502))
- country (P17)
- located in the administrative territorial entity (P131)
- mountain range (P4552) (for massif (Q1061151) and mountain (Q8502)) or located in/on physical feature (P706) (for summit (Q207326))
- coordinate location (P625) (in DM only for mountain range (Q46831) and massif (Q1061151), in DMS for mountain (Q8502) and summit (Q207326))
- elevation above sea level (P2044)
In case of a mountain range or a massif, additionally
My work is focusing on the following specific areas:
- Thuringia (Last edit: 2024/04/26)
- Caucasia (Last edit: 2023/09)
- Dinaric Alps (Last edit: 2022/08/10)
- Pamir mountains (Last edit: 2021/12/14)