Wvdp
Joined 6 September 2014
|
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 }