User:Wvdp

Userboxes 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

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

Youtubers without a Youtube channel

 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

 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

 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

   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
    }