User:Wvdp

From Wikidata
Jump to navigation Jump to search
Babel user information
nl-N Deze gebruiker heeft het Nederlands als moedertaal.
en-5 This user has professional knowledge of English.
de-1 Dieser Benutzer beherrscht Deutsch auf grundlegendem Niveau.
fr-1 Cet utilisateur dispose de connaissances de base en français.
Users by language
11,000+This user has made over 11,000 contributions to Wikidata.
This user uses Mix'n'match.

personal sandbox: Q109370709

Apps made by wvdp

[edit]

Cartocams A map displaying all webcams in OpenStreetMap

Is OSM Complete An app that tracks how complete osm really is by counting objects in OpenStreetMap

Welcome to my Dong Map An unofficial map of all the places visited in the Welcome to my dong series

Maintenace queries

[edit]

Youtubers without a Youtube channel

[edit]
 SELECT ?YouTuber ?YouTuberLabel WHERE {
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   ?YouTuber wdt:P106 wd:Q17125263.
   MINUS { ?YouTuber wdt:P2397 ?x. }
 }
 LIMIT 100

Twitch streamers without a Twitch channel

[edit]
 SELECT ?Twitcher ?TwitcherLabel WHERE {
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   ?Twitcher wdt:P106 wd:Q50279140.
   MINUS { ?Twitcher wdt:P5797 ?x. }
 }
 LIMIT 100

Dutch members of parliament without a start date

[edit]
 SELECT ?mp ?mpLabel WHERE {
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   ?mp p:P39 ?possition.
   ?possition ps:P39 wd:Q18887908.
   FILTER(NOT EXISTS {
     ?possition ?pq_pred ?pq_obj.
     ?prop wikibase:qualifier ?pq_pred.
   })
 }

Pro Gamers

[edit]
   SELECT DISTINCT ?pro_gamer ?pro_gamerLabel WHERE {
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
      ?pro_gamer wdt:P31 wd:Q5
      { ?pro_gamer wdt:P106 wd:Q4379701. } # occupation: pro gamer
      UNION
      { ?pro_gamer wdt:P641 wd:Q300920. } # sport: esports
      UNION
      { ?pro_gamer wdt:P106 wd:Q63349295. } # occupation: esports commentator
    }