Wvdp
Joined 6 September 2014
|
personal sandbox: Q109370709
Apps made by wvdp
editCartocams 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
editYoutubers without a Youtube channel
editSELECT ?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
editSELECT ?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
editSELECT ?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
editSELECT 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 }