Arjoopy

de-N	Dieser Benutzer spricht Deutsch als Muttersprache.

en-3	This user has advanced knowledge of English.

Wikidata statistics

	Number of pages	114,838,456
	User total	6,484,368
	Active users list	25,151
	Administrators	71
	Users/administrator	354

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.
                         }  
}

Try it!

Quicklinks edit

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)

Try it!

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

Quicklink mountain query 2023

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

highest point (P610)

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)