User talk:Andrew Gray/Archives/136

Wikidata weekly summary #433
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Discussions
 * New request for comments: Alternate disclosure policy


 * Events
 * Past: The Workshop On Open Citations And Open Scholarly Metadata 2020 took place in Bologna and online on September 9 and included a talk State of WikiCite in 2020, available on Zenodo via doi:10.5281/zenodo.4019954.
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, September 15 at 18:00 CEST
 * Upcoming: Wikidata birthday organizers call, September 16th at 13:00 UTC/GMT
 * Upcoming video: Wikipedia Weekly Network - LIVE Wikidata editing #20: Facebook, YouTube, September 19
 * Upcoming: Online Wikidata editathon in Swedish #30, September 20


 * Press, articles, blog posts, videos
 * Video: Youtuber Tom Scott tries to answer the question What Is The Best Thing?, using Wikidata to curate a collection of "things", and an online poll for people to vote on those things.
 * "Our admiration for Wikidata and for the people who work with it knows no bounds. Having a single source of well modelled, massively interlinked, well managed data that anyone can query at the press of a button is a real thing of wonder." - says the UK Parliament data team
 * Houcemeddine Turki, et al. (2020). Using logical constraints to validate information in collaborative knowledge graphs: a study of COVID-19 on Wikidata (Zenodo Preprint).
 * Video: Wikidata basics short videos by Wikimedian in Residence at University of Edinburgh (YouTube)
 * A brief intro to Wikidata and how to set up an account
 * How to add a new item to Wikidata
 * How to add an image to Wikidata
 * Video: Creating a Mix'n'Match set for Queensland Biota on Wikidata - YouTube
 * Video: Wikipedia Weekly Network - LIVE Wikidata editing #19: Cradle and colours in queries. Facebook, YouTube


 * Tool of the week
 * Mbabel is a tool that simplifies article creation by providing pre-made sentences based on Wikidata statements.


 * Other Noteworthy Stuff
 * The consultation phase for the Wikimedia movement Universal Code of Conduct (UCoC) is in progress until 6 October 2020. The UCoC drafting committee wants to learn which parts of the draft would present challenges for you or your work. What is missing from this draft? What do you like, and what could be improved?
 * All the lists of languages used on Wikidata: feel free to improve this draft documentation page.
 * The Wikidata development team is seeking to evaluate and improve the process of collecting and reacting to bug reports and feature requests. You can give feedback about your experience using this anonymous form until September 30th or add feedback publically to Wikidata talk:Contact the development team/Process review 2020.
 * WikiMap, a tool by User:DB111 that maps geocoded images from Commons and Wikipedia articles, now supports Wikidata items as well (Q99232292)
 * Wikidata QID's are approaching 9 digits. Now is the time to fix any code or schemas that assume that Q numbers are smaller than 9 characters.


 * Did you know?


 * Newest properties:
 * General datatypes: aerial view, ride height, category for the exterior of the item, axle track
 * External identifiers: Anais do Museu Paulista article ID, Legacies of British Slave-ownership place ID, Wisconsin Historical Society NRHP ID, Carl-Maria-von-Weber-Gesamtausgabe ID, Jewish Encyclopedia ID, Grove Music Online ID, Hikr waypoint ID, DIL ID, Seattle Art Museum ID, Nelson-Atkins Museum of Art artwork ID


 * New property proposals to review:
 * General datatypes: expansion of, Oakeshott typology, Slack URL, TDD number, Hill size, K point, number of negative votes, number of support votes
 * External identifiers: Historic Montana ID, KHRI ID, KinoWiki ID, BD Gest' series ID, Portugal. Dicionário Histórico ID, Discord username, China Treaty Database ID, Discord channel, Bollywood Hungama movie, NMC Heritage ID, identifiant d'un artiste département des arts graphiques du musée du Louvre, SPoT skater ID, Canadian Women Artists History Initiative ID, Lambiek Special pages, Lambiek comic magazines, Rheinland-Pfälzische Personendatenbank ID, Delft municipal monument ID


 * Query examples:
 * Shortest path of descent from Charlemagne to George Washington, George W. Bush, Barack Obama, Elizabeth II
 * List of most recent common ancestors (ordered by number of total degrees separated) between George Washington and George W. Bush (9th cousin 8 times removed), George Washington and Barack Obama (12th cousin 9 times removed), George Washington and Elizabeth II (2th consin 7 times removed), George W. Bush and Barack Obama (11th cousin), George W. Bush and Elizabeth II (14th cousin once removed), Barack Obama and Elizabeth II (19th cousin 3 times removed)
 * Artists that have recorded songs in several languages, by number of different languages used (Source)
 * Average age of companies listed on major indices (Source)
 * Basque Country sister cities with world municipalities (Source)
 * Map of companies developing/manufacturing a COVID-19 vaccine candidate that is at least in a phase 1 clinical trial (Source)
 * [https://query.wikidata.org/embed.html#%23%20The%20heights%20of%20mountains%20in%20Switzerland%0A%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fx_coords%22%2C%22%3Frgb%22%5D%7D%0ASELECT%20%3Fx%20%3FxLabel%20%3Fdescription%20%3Fx_coords%20%3Frgb%20%20WITH%20%7B%0A%23%20extract%20the%20data%0ASELECT%20%3Fdata%20%3Fx%20%3Fx_coords%20WHERE%20%7B%0A%20%20%3Fx%20wdt%3AP31%20wd%3AQ8502%20.%0A%20%20%3Fx%20%20p%3AP2044%2Fpsn%3AP2044%20%5B%20%0A%20%20%20%20%20wikibase%3AquantityAmount%20%3Fdata%20%0A%20%20%5D%20.%0A%20%20%3Fx%20wdt%3AP17%20wd%3AQ40%20.%0A%20%20%3Fx%20wdt%3AP625%20%3Fx_coords%20.%0A%20%20%7D%0A%7D%20AS%20%25totals%0A%23%20determine%20the%20max%20and%20min%20values%20%28used%20to%20calculate%20the%20spread%0AWITH%20%7B%20%0A%20%20SELECT%20%28MAX%28%3Fdata%29%20AS%20%3Fmax_data%29%20%20%28MIN%28%3Fdata%29%20AS%20%3Fmin_data%29%20WHERE%20%7B%0A%20%20INCLUDE%20%25totals%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%7D%7D%20AS%20%25min_max%0AWHERE%20%7B%0A%20%20INCLUDE%20%25totals%0A%20%20INCLUDE%20%25min_max%20%20%20%0A%20%20%3Fx%20rdfs%3Alabel%20%3FxLabel.%20FILTER%20%28LANG%28%3FxLabel%29%20%3D%20%22en%22%29%20.%0A%20%20BIND%20%28CONCAT%28%22The%20height%20of%20%22%2C%20%3FxLabel%2C%20%22%20is%20about%20%22%2C%20STR%28ROUND%28%3Fdata%29%29%2C%20%22%20metres%22%20%29%20AS%20%3Fdescription%29%20%0A%20%20BIND%20%28%20%3Fmax_data%20-%20%3Fmin_data%20AS%20%3Fspread%20%29%0A%20%20BIND%20%28%20xsd%3Ainteger%28%20100%20%2a%20%28%3Fdata%20-%20%3Fmin_data%29%20%2F%20%3Fspread%29%20AS%20%3Fpercent%20%29%20%23%200%20-%3E%20100%20%0A%23%20some%20example%20hues%200%3Ared%2C%2020%3Aorange%2C%2050%3Ayellow%2C%2090%3Agreen%2C%20180%3Acyan%2C%20220%3Ablue%2C%20280%3Aindigo%2C%20330%3Aviolet%2C%20340%3Ared%0A%23%20varying%20hue%20%20%20%20%20%20%20%20%0A%23%20%20%20BIND%20%28%20255%20%2a%20%3Fpercent%20%2F%20100%20%2B%200%20AS%20%3Fhue%20%29%20%0A%23%20%20%20BIND%20%281%20AS%20%3Fvalue%29%20%23%20%0A%23%20%20%20BIND%20%281%20AS%20%3Fsaturation%29%20.%20%23%200%20-%3E%201%0A%23%20varying%20the%20hue%27s%20value%0A%20%20BIND%20%28%20%281%20-%20%3Fpercent%20%2F%20100%20%2B%200%29%20AS%20%3Fvalue%20%29%20%23%20to%20black%0A%20%20BIND%20%28%20255%20%2a%20%3Fpercent%20%2F%20100%20%2B%200%20AS%20%3Fhue%20%29%20%0A%20%20BIND%20%281%20AS%20%3Fsaturation%29%20.%20%23%200%20-%3E%201%0A%23%20varying%20the%20hue%27s%20saturation%0A%23%20%20%20BIND%20%28%20%281%20-%20%3Fpercent%20%2F%20100%20%2B%200%29%20AS%20%3Fsaturation%20%29%20%23%20to%20-%3E%20white%0A%23%20%20%20BIND%20%280%20AS%20%3Fhue%29%20%23%20red%0A%23%20%20%20BIND%20%281%20AS%20%3Fvalue%29%20.%20%23%200%20-%3E%201%20%20%0A%23%20the%20following%20algorithm%20based%20on%20https%3A%2F%2Fstackoverflow.com%2Fquestions%2F3018313%2Falgorithm-to-convert-rgb-to-hsv-and-hsv-to-rgb-in-range-0-255-for-both%0A%20%20BIND%20%28%20%3Fhue%20%2F%2060%20AS%20%3Fhh%20%29%0A%20%20BIND%20%28%20FLOOR%20%28%3Fhh%29%20AS%20%3Fi%20%29%20.%0A%20%20BIND%20%28%20%3Fhh%20-%20%3Fi%20%20AS%20%3Fff%29%20.%0A%20%20BIND%20%28%20%3Fvalue%20%2a%20%28%201%20-%20%3Fsaturation%20%29%20AS%20%3Fp%29%20.%0A%20%20BIND%20%28%20%3Fvalue%20%2a%20%28%201%20-%20%28%20%3Fsaturation%20%2a%20%3Fff%29%29%20AS%20%3Fq%20%29%20.%0A%20%20BIND%20%28%20%3Fvalue%20%2a%20%28%201%20-%20%28%20%3Fsaturation%20%2a%20%281%20-%20%3Fff%20%29%29%29%20AS%20%3Ft%20%29%20.%20%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fi%20%3D%200%2C%20%3Fvalue%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%201%2C%20%3Fq%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%202%2C%20%3Fp%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%203%2C%20%3Fp%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%204%2C%20%3Ft%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%205%2C%20%3Fvalue%2C%201%2F0%29%2C%0A%20%20%20%20%3Fvalue%0A%20%20%29%20AS%20%3Fr%20%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fi%20%3D%200%2C%20%3Ft%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%201%2C%20%3Fvalue%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%202%2C%20%3Fvalue%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%203%2C%20%3Fq%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%204%2C%20%3Fp%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%205%2C%20%3Fp%2C%201%2F0%29%2C%0A%20%20%20%20%3Fp%0A%20%20%29%20AS%20%3Fg%20%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fi%20%3D%200%2C%20%3Fp%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%201%2C%20%3Fp%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%202%2C%20%3Ft%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%203%2C%20%3Fvalue%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%204%2C%20%3Fvalue%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fi%20%3D%205%2C%20%3Fq%2C%201%2F0%29%2C%0A%20%20%20%20%3Fq%0A%20%20%29%20AS%20%3Fb%20%29%0A%20%20BIND%20%28FLOOR%28255%20%2a%20%3Fr%29%20AS%20%3Fred%29%20%0A%20%20BIND%20%28FLOOR%28255%20%2a%20%3Fg%29%20AS%20%3Fgreen%29%20%20%0A%20%20BIND%20%28FLOOR%28255%20%2a%20%3Fb%29%20AS%20%3Fblue%29%0A%20%20%23%20red%0A%20%20BIND%20%28%20FLOOR%20%28%3Fred%20%2F%2016%29%20AS%20%3Fred_1%20%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fred_1%20%3C%2010%2C%20STR%28%3Fred_1%29%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_1%20%3D%2010%2C%20%22a%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_1%20%3D%2011%2C%20%22b%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_1%20%3D%2012%2C%20%22c%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_1%20%3D%2013%2C%20%22d%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_1%20%3D%2014%2C%20%22e%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_1%20%3D%2015%2C%20%22f%22%2C%201%2F0%29%2C%0A%20%20%20%20%22ERROR%22%0A%20%20%29%20AS%20%3Fred_hex1%20%29%0A%20%20BIND%20%28FLOOR%28%3Fred%20-%20%2816%20%2a%20xsd%3Ainteger%28%20%3Fred%20%2F%2016%20%29%29%29%20AS%20%3Fred_2%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fred_2%20%3C%2010%2C%20STR%28%3Fred_2%29%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_2%20%3D%2010%2C%20%22a%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_2%20%3D%2011%2C%20%22b%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_2%20%3D%2012%2C%20%22c%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_2%20%3D%2013%2C%20%22d%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_2%20%3D%2014%2C%20%22e%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fred_2%20%3D%2015%2C%20%22f%22%2C%201%2F0%29%2C%0A%20%20%20%20%22ERROR%22%0A%20%20%29%20AS%20%3Fred_hex2%20%29%0A%20%20BIND%20%28CONCAT%28STR%28%3Fred_hex1%29%2C%20STR%28%3Fred_hex2%29%29%20AS%20%3Fred_hex%20%29%0A%20%20%23%20green%0A%20%20BIND%20%28%20FLOOR%20%28%3Fgreen%20%2F%2016%29%20AS%20%3Fgreen_1%20%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fgreen_1%20%3C%2010%2C%20STR%28%3Fgreen_1%29%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_1%20%3D%2010%2C%20%22a%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_1%20%3D%2011%2C%20%22b%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_1%20%3D%2012%2C%20%22c%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_1%20%3D%2013%2C%20%22d%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_1%20%3D%2014%2C%20%22e%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_1%20%3D%2015%2C%20%22f%22%2C%201%2F0%29%2C%0A%20%20%20%20%22ERROR%22%0A%20%20%29%20AS%20%3Fgreen_hex1%20%29%0A%20%20BIND%20%28FLOOR%28%3Fgreen%20-%20%2816%20%2a%20xsd%3Ainteger%28%20%3Fgreen%20%2F%2016%20%29%29%29%20AS%20%3Fgreen_2%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fgreen_2%20%3C%2010%2C%20STR%28%3Fgreen_2%29%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_2%20%3D%2010%2C%20%22a%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_2%20%3D%2011%2C%20%22b%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_2%20%3D%2012%2C%20%22c%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_2%20%3D%2013%2C%20%22d%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_2%20%3D%2014%2C%20%22e%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fgreen_2%20%3D%2015%2C%20%22f%22%2C%201%2F0%29%2C%0A%20%20%20%20%22ERROR%22%0A%20%20%29%20AS%20%3Fgreen_hex2%20%29%0A%20%20BIND%20%28CONCAT%28STR%28%3Fgreen_hex1%29%2C%20STR%28%3Fgreen_hex2%29%29%20AS%20%3Fgreen_hex%20%29%0A%20%20%23%20blue%0A%20%20BIND%20%28%20FLOOR%20%28%3Fblue%20%2F%2016%29%20AS%20%3Fblue_1%20%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fblue_1%20%3C%2010%2C%20STR%28%3Fblue_1%29%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_1%20%3D%2010%2C%20%22a%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_1%20%3D%2011%2C%20%22b%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_1%20%3D%2012%2C%20%22c%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_1%20%3D%2013%2C%20%22d%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_1%20%3D%2014%2C%20%22e%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_1%20%3D%2015%2C%20%22f%22%2C%201%2F0%29%2C%0A%20%20%20%20%22ERROR%22%0A%20%20%29%20AS%20%3Fblue_hex1%20%29%0A%20%20BIND%20%28FLOOR%28%3Fblue%20-%20%2816%20%2a%20xsd%3Ainteger%28%20%3Fblue%20%2F%2016%20%29%29%29%20AS%20%3Fblue_2%29%0A%20%20BIND%20%28%20COALESCE%28%0A%20%20%20%20IF%28%3Fblue_2%20%3C%2010%2C%20STR%28%3Fblue_2%29%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_2%20%3D%2010%2C%20%22a%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_2%20%3D%2011%2C%20%22b%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_2%20%3D%2012%2C%20%22c%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_2%20%3D%2013%2C%20%22d%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_2%20%3D%2014%2C%20%22e%22%2C%201%2F0%29%2C%0A%20%20%20%20IF%28%3Fblue_2%20%3D%2015%2C%20%22f%22%2C%201%2F0%29%2C%0A%20%20%20%20%22ERROR%22%0A%20%20%29%20AS%20%3Fblue_hex2%20%29%0A%20%20BIND%20%28CONCAT%28STR%28%3Fblue_hex1%29%2C%20STR%28%3Fblue_hex2%29%29%20AS%20%3Fblue_hex%20%29%0A%20%20BIND%20%28CONCAT%28STR%28%3Fred_hex%29%2C%20STR%28%3Fgreen_hex%29%2C%20STR%28%3Fblue_hex%29%29%20AS%20%3Frgb%29%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%7D%0A%0A Map of mountains in Austria showing their heights; from red for the lowest through green to black for the highest] (Source)
 * Top World Heritage sites by number of paintings depicting them (Source)
 * [https://sophox.org/embed.html#%23defaultView%3AMap%0ASELECT%20%3Fosm%20%3FwdLabel%20%3FmaxPlayers%20%3Fcoordinates%20WHERE%20%7B%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22%20.%0A%20%20%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fv%20%3FwdLabel%20%3FmaxPlayers%20WHERE%20%7B%0A%20%20%20%20%20%20%23%20Query%20the%20OpenStreetMap%20Wiki%20for%20data%20items%20of%20tags%0A%20%20%20%20%20%20%3Fosmd%20osmdt%3AP10%20osmd%3AQ723%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20their%20key-value%20pairs%0A%20%20%20%20%20%20%20%20%20%20%20%20osmdt%3AP19%20%3Fkv%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20their%20corresponding%20Wikidata%20concepts%0A%20%20%20%20%20%20%20%20%20%20%20%20osmdt%3AP12%20%3Fqid.%0A%0A%20%20%20%20%20%20%23%20Convert%20the%20Wikidata%20QID%20from%20a%20string%20into%20a%20URL%2C%20which%20is%20how%20entities%20are%20normally%20represented%0A%20%20%20%20%20%20BIND%28IRI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3Fqid%29%29%20AS%20%3Fwd%29%0A%20%20%20%20%20%20%0A%20%20%20%20%20%20%23%20Isolate%20the%20value%0A%20%20%20%20%20%20BIND%28STRAFTER%28%3Fkv%2C%20%22%3D%22%29%20AS%20%3Fv%29%0A%0A%20%20%20%20%20%20%23%20Query%20Wikidata%20for%0A%20%20%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%20%20%23%20The%20matching%20Wikidata%20item%20as%20long%20as%20it%20is%20a%20team%20sport%0A%20%20%20%20%20%20%20%20%3Fwd%20%28wdt%3AP31%7Cwdt%3AP279%29%2B%20wd%3AQ216048%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP1873%20%3FmaxPlayers.%0A%0A%20%20%20%20%20%20%20%20%23%20As%20long%20as%20between%2010%20and%2020%20players%20would%20be%20on%20the%20field%0A%20%20%20%20%20%20%20%20FILTER%28%3FmaxPlayers%20%3E%3D%2010%20%26%26%20%3FmaxPlayers%20%3C%3D%2020%29%0A%0A%20%20%20%20%20%20%20%20%23%20Get%20the%20item%E2%80%99s%20label%0A%20%20%20%20%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fwd%20rdfs%3Alabel%20%3FwdLabel.%0A%20%20%20%20%20%20%20%20%20%20FILTER%28LANG%28%3FwdLabel%29%20%3D%20%22en%22%29%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20%0A%20%20%23%20Query%20OpenStreetMap%20for%20features%20tagged%20with%20this%20sport%0A%20%20%3Fosm%20osmt%3Asport%20%3Fv%3B%0A%20%20%20%20%20%20%20osmm%3Aloc%20%3Fcoordinates.%0A%7D Map of sports pitches for team sports that require between 10 and 20 players on the field] - Wikidata/OSM query


 * Development
 * Fixing an error that sometimes causes Wikidata UI to report 2 error messages when saving a sitelink in an Item instead of just one. (T260869)
 * Development of version one of Federated Properties has concluded! Expect an announcement with timing of the release of this feature soon. Wikibase users who want an early look at the feature are invited to reach out to participate in the pre-release testing round.
 * Development of the WikibaseManifest extension has continued into its second sprint; we focused on determining a product specification for the Manifest output.
 * Finishing a draft documentation for a REST API to get it ready for a feedback round before implementation.
 * Finished improvements to the automated scoring of the quality of Items with ORES. Still need to retrain ORES and deploy the changes before the scores are actually different though.

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report · Unsubscribe · Mohammed Sadat (WMDE) 15:16, 14 September 2020 (UTC)

Wikidata weekly summary #434
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Events
 * Upcoming: Online Wikidata Introduction Workshop (German) (September 29)
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, September 21 at 18:00 CEST
 * Upcoming: Next Linked Data for Libraries LD4 Wikidata Affinity Group call: A starting point for newer institutions to think through what is involved in coordinating a Wikidata project, including shared infrastructure, training, and documentation, 22 September. Agenda
 * Upcoming video: Wikipedia Weekly Network - LIVE Wikidata editing #21 WikiDojo: Facebook, YouTube, September 25


 * Press, articles, blog posts, videos
 * "Representing COVID-19 information in collaborative knowledge graphs: a study of Wikidata"
 * ProWD: Detecting Knowledge Imbalances on Wikidata on blog.wikimedia.de
 * Video: Wikipedia Weekly Network - LIVE Wikidata editing #20 WLM: Facebook, YouTube
 * Video: Wikidata Training Workshop 3, by Canadian Arts Presenting Association (YouTube)
 * Wikidata Query Service - (Parts 1, 2 & 3)
 * Wikidata Query Service (in French) - (Parts 1, 2 & 3)


 * Tool of the week
 * copy-qid is a user script by Abbe98 that allows you to copy the Qid with one click.


 * Other Noteworthy Stuff
 * The Wikidata development team is seeking to evaluate and improve the process of collecting and reacting to bug reports and feature requests. You can give feedback about your experience using this anonymous form until September 30th or add feedback publically to Wikidata talk:Contact the development team/Process review 2020.
 * WDQS/WCQS Status update (September 2): "We are planning to spend more time doing some analytics on our data. (1) What are the most expensive queries, what are they trying to achieve and is that reasonable? (2) Do we have performant subgraphs that we could expose independently?"


 * Did you know?


 * Newest properties:
 * General datatypes: category for the exterior of the item, axle track, Stairway To Hell ID, Oakeshott typology, construction point, turning radius, hill size, bibliography
 * External identifiers: Seattle Art Museum ID, Nelson-Atkins Museum of Art artwork ID, TV Maze series ID, Barcelona Public art ID, University of Ghana Digital Collections (UGSpace) ID, Istrapedia ID, OnlyFans person ID, Linked Open Data Cloud identifier, The Cutting Room Floor ID, Fatcat ID, China Treaty Database ID, e-GOV law ID, Portugal. Dicionário Histórico ID, past Fellow of the Royal Society ID, Regesta Ecclesiastica Salisburgensia ID, Slack organization ID, Kansas Historic Resources Inventory ID, Historic Montana ID, ITF player ID 2020, BD Gest' series ID, American Battlefield Trust battlefield ID, P8624


 * New property proposals to review:
 * General datatypes: defining mutations, nombre d'essais marqués, Netflix maturity rating, held event, number of paying subscribers, has census
 * External identifiers: Rheinland-Pfälzische Personendatenbank ID, Delft municipal monument ID, identificativo Ministero dell'interno, Dallas Museum of Art ID, Cincinnati Art Museum ID, Energy Identification Code, Wikimedia Chat channel, Symptom Ontology ID, MnDOT Historic Bridges ID, monumentsauxmorts.fr ID, monumentsdememoire.fr ID, Lower Sorbian place name ID, Région Île-de-France ID, Museen Dresden article ID, Turkey's Culture Portal ID, NPS place ID, SSYK 2012


 * Query examples:
 * Map of anything that memorializes or is named after a Whig Party member - OSM/Wikidata query
 * Map of every railway station presently connected directly or indirectly to St Pancras on Wikidata
 * Age of the winners of the Tour de France (Source)
 * Location and date of death of Danish rulers (Source)
 * Map of the places & causes of death of Roman Emperors (Source)
 * Images of members of the 16th Odisha Assembly (2019-24) (Source)
 * Star signs of Japanese Prime Ministers (Source)
 * Video game series with the longest time gap between a game and its direct sequel (Source)


 * Development
 * WQS now supports mwapi service request for Wikibooks (T261125)
 * The language codes lij-mc, ja-Hira, ja-Kana, ja-Hrkt, ja-Hani, ojp, ojp-Hira and ojp-Hani" have been added for use in monolingual text property values (T254968, T195816)
 * The language codes de-1901, eo-hsistemo and eo-xsistemo, ja-hira, ja-kana and ja-hrkt have been added for Lexemes (T262330,T257422, T250559)
 * P1438 has been converted from string to external ID datatype (T262198)
 * Worked on fixing an input issue with invisible characters (T261071)
 * Investigating what work would be needed to get the new termbox that's available on mobile to also work on desktop
 * Fixing several issues with Special:Undelete (T261747)
 * Fixing an error message being shown twice (T260869)
 * Starting the coding work on the Query Builder
 * Continuing to write a draft for a REST API specification
 * Finishing the remaining work needed to get the improved quality scoring for Items deployed to ORES
 * Continuing work on WikibaseManifest: Determined the essential metadata that will be included in the WikibaseManifest file, added some new features (mostly MediaWiki metadata) to the Manifest that were requested by the OpenRefine team (T262805 and T262804) and set up a test system that will soon be ready for tool builders to use for testing the integration of their tools with WikibaseManifest

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report · Unsubscribe · Mohammed Sadat (WMDE) 14:59, 21 September 2020 (UTC)

The Signpost: 27 September 2020
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 22:46, 27 September 2020 (UTC)

The Signpost: 27 September 2020
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 22:53, 27 September 2020 (UTC)

Wikidata weekly summary #435
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Events
 * Linking the 20th century paper history to the sum of all knowledge (Best practice presentation at DCMI Virtual 2020)
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, September 29 at 18:00 CEST
 * Upcoming: WikiNeocomensia: Wikidata + OpenRefine, workshop in Neuchâtel (Switzerland) and in French, October 3
 * Upcoming: Online Wikidata editathon in Swedish #32, October 4


 * Press, articles, blog posts, videos
 * The International Federation of Library Associations and Institutions [IFLA] have published a series of six videos "discussions with professionals in order to discuss projects, issues, progress of Wikidata, Wikibase and bibliographic data in the field of libraries." Currently available as a playlist on YouTube under CC-By (Wikimedia Commons upload soon), with subtitles in English, Spanish, Portuguese, and French (Arabic and Chinese coming soon). The production was made by the IFLA Wikidata Working Group and funded by a WikiCite grant.
 * Sidestepping the limitations of collection catalogues with machine learning and Wikidata
 * Navigating the maze of Wikidata query logs by Angela Bonifati, Wim Martens, Thomas Timm
 * Video: Wikipedia Weekly Network - LIVE Wikidata editing #21 - WikiDojo on the Global Climate Strike: Facebook, YouTube
 * Video: Wikidata tutorial for lecturers (in Czech) - YouTube
 * Video: Creating and enriching linked data with Wikidata - YouTube
 * Video: Mix'n'Match Tutorial - YouTube
 * Video: Introduction to Wikidata for librarians (in Portuguese) - YouTube


 * Tool of the week
 * omeka-s-wikidata is an Omeka-S module for auto-suggesting Wikidata URIs and labels.


 * Other Noteworthy Stuff
 * The Wikidata development team is seeking to evaluate and improve the process of collecting and reacting to bug reports and feature requests. You can give feedback about your experience using this anonymous form until September 30th or add feedback publically to Wikidata talk:Contact the development team/Process review 2020.
 * Nominate your favorite tools for the Coolest Tool Award 2020 before October 14th.
 * Wikidata Walkabout is a new site that lets you browse and drill down through different "classes" of data on Wikidata: wikidatawalkabout.org
 * Como is a new Android app, that uses Wikidata lexemes and senses to create a word-guessing game. It let's players create new senses and tests them on other players to finally save them in Wikidata. The app is developed as part of a BA thesis, to determine if this concept is useful to create more lexicographical data, and testers would be very welcome.


 * Did you know?


 * Newest properties:
 * General datatypes: construction point, turning radius, hill size, bibliography, opening time, closing time, engine displacement, expansion of, Netflix maturity rating, TDD number
 * External identifiers: American Battlefield Trust battlefield ID, American Battlefield Trust ID (person), Occupational Outlook Handbook ID, Thomas Jefferson Encyclopedia ID, Canadian Women Artists History Initiative ID, Book Marks ID, Re-Member ID, SPoT skater ID, NDL law ID, McClintock and Strong Biblical Cyclopedia ID, L'Officiel des spectacles ID, British and Irish Furniture Makers Online ID, Cincinnati Art Museum ID, Dallas Museum of Art ID, FBref.com squad ID, Dostoyevsky and His Entourage ID, Lambiek comic magazines ID, Energy Identification Code, Library of Congress Children's Subject Headings ID, Ministry of the Interior of Italy ID, National Park Service place ID, MnDOT Historic Bridges ID, Open Civic Data Division ID, Museen Dresden article ID, SSYK 2012 The Swedish Standard Classification of Occupations, LoC HABS/HAER/HALS place ID, Symptom Ontology ID, photoLondon ID, Syro-Malabar Catholic Church ID


 * New property proposals to review:
 * General datatypes: Regional Council of Tuscany ID, level of professionalness, defined in terms of, form of property constraint, Attraction to, group identity, analog television standard, ritual object, number of rooms
 * External identifiers: USA Water Polo Hall of Fame ID, Encyclopaedia Beliana ID, Indonesian prison database ID, LinkedIn group ID, Naver movie ID, CINE21 film ID, Movist film ID, KOBIS-ID, Max Movie film ID, The Boardr profile ID, Slovník českých nakladatelství 1848-1949 person ID, Google Play developer slug, Passion Patrimoine ID, FVLB work ID, BBC Sound Effects Asset ID, ITHL author ID, Quebec Dams Directory ID, Doktori.hu ID


 * Query examples:
 * [https://sophox.org/embed.html#SELECT%20%2A%20WHERE%20%7B%0A%20%20%23%20Prevent%20optimizer%20from%20querying%20for%20everything%20tagged%20with%20wikidata%3D%2A%20before%20querying%20the%20service%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22.%0A%20%20%0A%20%20%23%20Query%20the%20MediaWiki%20API%20Query%20Service%20through%20the%20Wikidata%20Query%20Service%2C%20where%20it%20is%20enabled%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Amwapi%20%7B%0A%20%20%20%20%20%20%23%20Get%20the%20100%20most%20recent%20%3Cmapframe%3E%20or%20%3Cmaplink%3E%20additions%20to%20English%20Wikipedia%20articles%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3Aapi%20%22Generator%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Aendpoint%20%22en.wikipedia.org%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Alimit%20100%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Agenerator%20%22categorymembers%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Inserting%20%3Cmapframe%3E%20and%20%3Cmaplink%3E%20automatically%20adds%20an%20article%20to%20this%20category%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Agcmtitle%20%22Category%3APages%20using%20the%20Kartographer%20extension%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Articles%2C%20not%20other%20namespaces%20like%20portals%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Agcmnamespace%20%220%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Sort%20by%20most%20recent%20addition%20to%20the%20category%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Agcmsort%20%22timestamp%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Agcmdir%20%22descending%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Agcmprop%20%22ids%7Ctitle%7Ctimestamp%22.%0A%20%20%20%20%20%20%23%20Output%20the%20title%2C%20Wikidata%20item%2C%20and%20last-edited%20timestamp%0A%20%20%20%20%20%20%3Ftitle%20wikibase%3AapiOutput%20mwapi%3Atitle.%0A%20%20%20%20%20%20%3Fwd%20wikibase%3AapiOutputItem%20mwapi%3Aitem.%0A%20%20%20%20%20%20%3Ftimestamp%20wikibase%3AapiOutput%20mwapi%3Atimestamp.%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Some%20articles%20have%20no%20linked%20Wikidata%20item%20yet%0A%20%20%20%20%23%20Leaving%20this%20variable%20unbound%20would%20cause%20the%20query%20to%20search%20for%20all%20Wikidata-tagged%20features%20in%20OpenStreetMap%0A%20%20%20%20FILTER%28BOUND%28%3Fwd%29%29%0A%20%20%7D%0A%20%20%0A%20%20%23%20Query%20OpenStreetMap%20for%20features%20representing%20the%20subject%20of%20the%20article%0A%20%20%3Fosm%20osmt%3Awikidata%20%3Fwd.%0A%7D%0A%23%20Uncomment%20this%20line%20to%20sort%20the%20most%20recently%20edited%20articles%20to%20the%20top%2C%20regardless%20of%20when%20a%20map%20was%20added%20to%20the%20article%0A%23ORDER%20BY%20DESC%28%3Ftimestamp%29 Table of the 100 most recent additions of interactive OpenStreetMap maps to English Wikipedia articles] - OSM/Wikidata query
 * Map of the birthplace of persons with an ELEM id on Wikidata (Source)


 * Development
 * A long-standing bug has been fixed (T217144) where Items and Lexemes created via OAuth would not be added to the user’s watchlist even if the user had the  setting enabled. (The  setting was probably likewise ineffective, but this was not tested specifically.) Affected tools include QuickStatements, Mix'n'Match, and Wikidata Lexeme Forms; users of these and other tools may see more pages being added to their watchlists now. (This only applies to new edits and page creations; previously created or edited pages will not be automatically added to the watchlist retroactively.)
 * Working on the basic building blocks of the Query Builder towards making it possible to create the first very simple query with it
 * Talking to people about comparing Wikidata's data against other databases and flagging mismatches
 * Fixing an issue with Item creations via the API by blocked users leading to skipped entity IDs (T232620)
 * Fixed an input issue with invisible characters (T261071)
 * Finishing the draft of the REST API spec to get it ready for feedback
 * WikibaseManifest: created a separate key for local entities and decided what we do about non-local entity sources based on tool-builder feedback (T263527) and specifying the API in OpenApi format (T262919)

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report · Unsubscribe · Mohammed Sadat (WMDE) 15:00, 28 September 2020 (UTC)

Feedback request: History Good Article nomination
Your feedback is requested &#32;at Talk:Wolfgang Clement&#32; on a "History" Good Article nomination. Thank you for helping out! You were randomly selected to receive this invitation from the list of Feedback Request Service subscribers. If you'd like not to receive these messages any more, you can opt out at any time by removing your name. Message delivered to you with love by Yapperbot :) &#124; Is this wrong? Contact my bot operator. &#124; Sent at 01:33, 1 October 2020 (UTC)

Feedback request: Natural sciences Good Article nomination
Your feedback is requested &#32;at Talk:Tropical Storm Ampil&#32; on a "Natural sciences" Good Article nomination. Thank you for helping out! You were randomly selected to receive this invitation from the list of Feedback Request Service subscribers. If you'd like not to receive these messages any more, you can opt out at any time by removing your name. Message delivered to you with love by Yapperbot :) &#124; Is this wrong? Contact my bot operator. &#124; Sent at 09:31, 2 October 2020 (UTC)

Wikidata weekly summary #436
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Discussions
 * Open request for adminship: Fuzheado


 * Events
 * Upcoming: Next Linked Data for Libraries LD4 Wikidata Affinity Group call: Professor Toby Hudson on Entity Explosion, a browser extension which allows you to get information about entities on the web page you’re visiting, 06 October. Agenda
 * Upcoming: Wikidata & Wikibase office hour, October 27th at 17:00 CEST (15:00 GMT)
 * Upcoming: plenty of events for the Wikidata birthday, check the calendar and feel free to organise one!


 * Press, articles, blog posts, videos
 * What does/doesn’t follow Benford’s law: An analysis of hundreds of sets of numbers from Wikidata.
 * Video: How to create and edit items on Wikidata (in Spanish) - YouTube
 * Video: Introduction to Wikidata and wikiprojects of interest to librarians (in Spanish) - YouTube


 * Tool of the week
 * IllWill.js is a userscript that searches Wikidata for foreign-language sitelinks, to populate Template:ill and replace plain red links on other Wikimedia projects.


 * Other Noteworthy Stuff
 * omeka-s-wikidata is a new module for the open source GLAM collection management software Omeka, that allows cataloguers to use Wikidata as a vocabulary for persons, places, subjects, etc.


 * Did you know?


 * Newest properties:
 * General datatypes: TDD number, twin town sign, character designer, Deutsche Bahn station code
 * External identifiers: Museen Dresden article ID, SSYK 2012 The Swedish Standard Classification of Occupations, LoC HABS/HAER/HALS place ID, Symptom Ontology ID, photoLondon ID, Syro-Malabar Catholic Church ID, Native Plants Database ID, Lower Sorbian place name ID, Les roses cultivées à l'Haÿ en 1902 ID, Maniadb album ID, USA Water Polo Hall of Fame ID, Présence Compositrices work ID, Regional Council of Tuscany ID, Indonesian prison database ID, Encyclopaedia Beliana ID, Twitter topics ID, Naver movie ID, Bollywood Hungama movie ID, BoardGameGeek family ID, London Stock Exchange company ID, Région Île-de-France ID, Slovník českých nakladatelství 1848-1949 person ID


 * New property proposals to review:
 * General datatypes: Infobox based on, CompositionToday composers showcase ID, parallel street, World Factbook country code, port calls, described at Wikipedia page, erected by, PIM award ID, Stadtwiki Dresden article
 * External identifiers: Quebec Dams Directory ID, Doktori.hu ID, CompositionToday composer ID, Slovník českých nakladatelství 1848-1949 publishing house ID, ACER code, Dictionnaire biographique du fouriérisme ID, NSW State Archives and Records Authority ID, SwissLipids identifier, Scottish Brick History Brick & Tileworks ID, Minecraft UUID, Minecraft username, Science Museum Group ID, Kicker.de player ID (actual scheme), RNACentral ID, NPS people ID, Directory of Belgian Photographers-ID, Dresden Street ID, Spotify playlist ID


 * Query examples:
 * Birthplace of people named Michael or any other variant of the name (Source)
 * [https://sophox.org/embed.html#%23defaultView%3AMap%0ASELECT%20DISTINCT%20%3Fosm%20%3FmakeLabel%20%3FmodelLabel%20%3Flayer%20%3Fcoordinates%20WHERE%20%7B%0A%20%20%23%20Prevent%20optimizer%20from%20querying%20for%20everything%20tagged%20with%20wikidata%3D%2A%20before%20querying%20the%20service.%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22%20.%0A%20%20%0A%20%20%23%20Query%20OpenStreetMap%20for%20outdoor%20warning%20sirens%0A%20%20%3Fosm%20osmt%3Aemergency%20%22siren%22.%0A%20%20%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%23%20Get%20the%20make%20and%2For%20model%0A%20%20%20%20%3Fosm%20%28osmt%3Amanufacturer%3Awikidata%7Cosmt%3Asiren%3Amodel%3Awikidata%29%20%3FmakeModel.%0A%20%20%20%20%0A%20%20%20%20%23%20Query%20Wikidata%20for%20the%20make%2Fmodel%0A%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%23%20If%20it%E2%80%99s%20a%20model%2C%20get%20the%20make%0A%20%20%20%20%20%20%20%20%3FmakeModel%20wdt%3AP31%20wd%3AQ76920834%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP176%20%3Fmake.%0A%20%20%20%20%20%20%20%20BIND%28%3FmakeModel%20AS%20%3Fmodel%29%0A%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%23%20Get%20the%20model%20name%0A%20%20%20%20%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fmodel%20rdfs%3Alabel%20%3FmodelLabel.%0A%20%20%20%20%20%20%20%20%20%20FILTER%28LANG%28%3FmodelLabel%29%20%3D%20%22en%22%29%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%7D%20UNION%20%7B%0A%20%20%20%20%20%20%20%20%23%20A%20make%20must%20be%20a%20business%20to%20distinguish%20it%20from%20a%20model%0A%20%20%20%20%20%20%20%20%3FmakeModel%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ4830453.%0A%20%20%20%20%20%20%20%20BIND%28%3FmakeModel%20AS%20%3Fmake%29%0A%20%20%20%20%20%20%7D%0A%0A%20%20%20%20%20%20%23%20Get%20the%20manufacturer%E2%80%99s%20name%0A%20%20%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%20%20%3Fmake%20rdfs%3Alabel%20%3FmakeLabel.%0A%20%20%20%20%20%20%20%20FILTER%28LANG%28%3FmakeLabel%29%20%3D%20%22en%22%29%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20BIND%28COALESCE%28%3FmakeLabel%2C%20%22Unknown%22%29%20AS%20%3Flayer%29%0A%20%20%0A%20%20%23%20Get%20coordinates%20to%20display%20on%20a%20map%0A%20%20%3Fosm%20osmm%3Aloc%20%3Fcoordinates.%0A%7D%0AORDER%20BY%20ASC%28%3FmakeLabel%29 Map of outdoor warning sirens, color-coded by manufacturer. A layer selector lets you toggle individual manufacturers on and off. Clicking a siren shows its make and model if available.] - OSM/Wikidata query
 * Soviet cartoons in descending order of popularity in the world (Source)
 * List of ISO countries showing each country's synonyms, labels, etc. (Source)
 * Norwegian politicians who have been members of at least 3 parties (Source)
 * Streets in Leiden named after people/things (Source)
 * Maps of arts and humanities research grants funded by Arts and Humanities Research Council in UK between 2013-2019. Sorted by year, Sorted by budget (Source)
 * Newest database reports:
 * EntitySchema directory - feedback welcome on the report talk page.


 * Development
 * First pieces of the Query Builder are coming together and we are working towards making it generate the first dumb query
 * Talking to people about their thoughts on checking Wikidata's data against other databases. If you're interested reach out to Mohammed.
 * Got some first internal feedback for the REST API specification draft. We'll publish it for feedback in the next days.
 * Fixing an issue with certain language codes no longer being available (T264294)
 * Working on making sure blocked bots don't waste Item IDs when trying to create new Items (T232620)

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report · Unsubscribe · Mohammed Sadat (WMDE) 16:06, 5 October 2020 (UTC)

Wikidata weekly summary #437
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Discussions
 * Open request for adminship: MsynABot
 * Closed request for adminship: Fuzheado (successful)


 * Events
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, October 13 at 18:00 CEST
 * Upcoming: Wikidata birthday organizers call, October 14 at 12:00 GMT
 * Upcoming: Online Wikidata editathon in Swedish #34, October 18
 * Search Platform Office Hours happens first Wednesday of each month. Come with questions related to Wikimedia search, Wikidata Query Service, Wikimedia Commons Query Service, etc.


 * Press, articles, blog posts, videos
 * Wikidata reaches Q100000000, by Lydia Pintscher and Denny Vrandečić
 * A new extension can add support for linking to local media files in Statements (and not just files on Wikimedia Commons) to a Wikibase instance (Demo video, developed by Professional.Wiki)
 * LD4 Wikidata Affinity Group presentation: How Entity Explosion fits into the Wikidata ecosystem, by Toby Hudson
 * Video: Wikidata and COVID-19: Creating a collaborative knowledge graph from CORD-19, by Csisc


 * Tool of the week
 * OD2WD automatically converts CSV files from Open Data portals into QuickStatements for Wikidata republishing. Demo video


 * Other Noteworthy Stuff
 * noratelimit for bots to be removed on October 20th
 * The new Wikibase/Consultants and Support Providers' directory on Meta lists people/companies that provide professional help with Wikibase -- be it technical support (installation and setup), custom development, or data modeling services.
 * The 2020 Coolest Tool Award is still accepting nominations until October 14th. Please use this form to recommend tools. You can nominate as many tools as you want by filling out the form multiple times.


 * Did you know?


 * Newest properties:
 * General datatypes: number of negative votes, number of support votes, x-offset, y-offset, social media followers, fandom, has census, parallel street, entry in abbreviations table
 * External identifiers: Dictionary of Occupational Titles Code (fourth edition, revised), FVLB work ID, Passion Patrimoine ID, Biographical dictionary of Fourierism ID, CompositionToday composer ID, ITHL author ID, Quebec Dams Directory ID, SwissLipids identifier, ACER code, Science Museum Group ID, Slovník českých nakladatelství 1848-1949 publishing house ID, Directory of Belgian Photographers ID, RNACentral ID, Turkey's Culture Portal ID, NSW State Archives and Records Authority ID, Scottish Brick History Brick & Tileworks ID


 * New property proposals to review:
 * General datatypes: ship's captain, planetary coordinates, Date of signature, Unicode name
 * External identifiers: CPV Supplementary, PeoplePill person ID, O*NET OnLine code, Emojipedia ID, GADM ID, CTAN package ID, MinDat taxon ID, AniList anime ID, AniList manga and light novel ID, Normattiva ID, ILO Thesaurus ID


 * Query examples:
 * Map of trees whose species is categorized as threatened on the IUCN Red List - OSM/Wikidata query
 * Women actress less than 70 years old who are descendants of the first king of Navarre, ordered by number of sitelinks
 * Dead Social Democratic Party members who have been ministers in 1992 or later (Source)
 * Artworks with an image in Wikidata by year of creation (Source)
 * Map of mountains in Switzerland (Source)
 * Map of markets in the city of Surabaya (Source)
 * National Anthems by tonality (Source)


 * Development
 * The RFC to semi-protect all property pages has been implemented, all properties now require the “autoconfirmed” right to edit (T254280)
 * Working on enabling JSON dumps for Lexemes (T220883)
 * Finishing preventing blocked users from making us skip QIDs (T232620)
 * Continuing work on the Wikibase Manifest extension that allows toolbuilders to easily access configurations of a specific Wikibase instance so it is easier for them to make their tools work with not just Wikidata but also other Wikibase instances
 * Started analyzing what we consider a mismatch for our work around checking Wikidata's data against other databases
 * Continued work on the Query Builder to get it to create the first very simple query. It can do that now but not yet visualize the result.

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

<div style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Read the full report · Unsubscribe · Mohammed Sadat (WMDE) 15:28, 12 October 2020 (UTC)

This Month in GLAM: September 2020
<div style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">About This Month in GLAM · Subscribe/Unsubscribe · Global message delivery · Romaine 02:44, 13 October 2020 (UTC)

Wikidata weekly summary #438
<div style="margin-top:10px; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Here's your quick overview of what has been happening around Wikidata over the last week. <div style="-moz-column-count:2; -webkit-column-count:2; column-count:2; -webkit-column-width: 400px; -moz-column-width: 400px; column-width: 400px;">


 * Discussions
 * Other: Proposal to spin-off non-Earth coordinates from property P625 (coordinates location), currently only 7000 of 8 million values: see Property proposal/planetary coordinates


 * Events
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, October 20 at 18:00 CEST
 * Upcoming: Next Linked Data for Libraries LD4 Wikidata Affinity Group call: hands-on work with Wikidata on creating items for authors of COVID 19 papers and brainstorming for future hands-on work, 20 October. Agenda
 * Upcoming: Wikidata Lab XXV: Interoperabilidade e acesso aos dados, in Portuguese by Ederporto (Wiki Movimento Brasil) - October 22 17:00 UTC (14:00 BRT)
 * WikiCite 2020: Virtual Conference happening 26-28 October 2020. Many live-stream sessions across several languages and timezones. LWyatt (WMF)


 * Press, articles, blog posts, videos
 * Tisane Labs announce new feature in Tisane API, allowing tagging and extraction of Wikidata entities: blog post
 * Video: LIVE Wikidata editing at HACK4OPENGLAM - YouTube
 * Video: Wikidata Lexeme BY Mahir256 - YouTube
 * Video: Introduction to Wikidata (in Swedish) - YouTube
 * Video: Introduction to SPARQL (in Swedish) - YouTube
 * Video: Bibliographic data on Wikidata (in Swedish) - YouTube


 * Tool of the week
 * Prepbio tool uses Wikidata to create the beginnings of a Wikipedia stub biography article. (2020-10-19)


 * Did you know?


 * Newest properties:
 * General datatypes: ritual object
 * External identifiers: Scottish Brick History Brick & Tileworks ID, Spotify playlist ID, Artist ID of the department of Prints and Drawings of the Louvre, NBIC taxon ID, Danish educational institution number, CTAN package ID, Dresden Street ID, Emojipedia ID, FIBA Hall of Fame ID, Stadtwiki Dresden article


 * New property proposals to review:
 * General datatypes: Unicode name, branch or affiliate, economy of topic, checkin and checkout times (v.2), maximum current, Skipsrevyen ID, route operated, power plant unit, annual average daily traffic, Humanitarian OpenStreetMap Tasking Manager project ID, isotopically modified form of, Numérisé par
 * External identifiers: Kramerius of Moravian Library UUID, Hungarian Water Polo Federation player ID, Irish Statute Book ID, Mir@bel publisher ID, CCFr library ID, Decorati onorificenze repubblica, BHL name ID, AWMDB person ID, AVN person ID, American Heritage ID, xHamster ID, Great Places ID, Famepedia ID, Nachlässe in Austria, Archivio Storico Ricordi opera ID, PAN member, DC Historic Sites ID, Literary Encyclopedia (1929-1939), Concise Literary Encyclopedia, aagm people ID, aagm sites ID, Yandex Zen ID, GeoGuessr ID, Polski Słownik Judaistyczny ID, SMB-digital ID, identifiant station Vélib' Métropole


 * Query examples:
 * [https://sophox.org/embed.html#%23defaultView%3AImageGrid%0ASELECT%20DISTINCT%20%3Fosm%20%3Fmodel%20%3Flicense%20WHERE%20%7B%0A%20%20%23%20Prevent%20optimizer%20from%20querying%20for%20everything%20tagged%20with%20wikidata%3D%2A%20before%20querying%20the%20service.%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22.%0A%20%20%0A%20%20%23%20Query%20the%20Wikidata%20Query%20Service%20for%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%23%20Models%20of%20things%0A%20%20%20%20%3Fwd%20wdt%3AP4896%20%3Fmodel.%0A%20%20%7D%0A%20%20%0A%20%20%23%20Query%20OpenStreetMap%20for%20features%20corresponding%20to%20these%20things%0A%20%20%23%20This%20greatly%20narrows%20the%20set%20of%20results%2C%20making%20the%20subsequent%20MediaWiki%20API%20call%20much%20faster%0A%20%20%3Fosm%20osmt%3Awikidata%20%3Fwd.%0A%20%20%0A%20%20%23%20Query%20the%20Wikidata%20Query%20Service%20again%20for%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%23%20The%20same%20model%20of%20the%20same%20thing%0A%20%20%20%20%3Fwd%20wdt%3AP4896%20%3Fmodel.%0A%20%20%20%20%0A%20%20%20%20%23%20Convert%20the%20file%20path%20URL%20into%20a%20file%20description%20page%20title%0A%20%20%20%20BIND%28CONCAT%28%22File%3A%22%2C%20wikibase%3AdecodeUri%28STRAFTER%28STR%28%3Fmodel%29%2C%20%22%2FSpecial%3AFilePath%2F%22%29%29%29%20AS%20%3Ftitle%29%0A%20%20%20%20%0A%20%20%20%20%23%20Query%20the%20MediaWiki%20API%20Query%20Service%20for%0A%20%20%20%20SERVICE%20wikibase%3Amwapi%20%7B%0A%20%20%20%20%20%20%23%20Categories%20that%20contain%20these%20pages%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3Aapi%20%22Categories%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Aendpoint%20%22commons.wikimedia.org%22%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Alimit%2050%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20mwapi%3Atitles%20%3Ftitle.%0A%20%20%20%20%20%20%23%20Output%20the%20page%20title%20and%20category%0A%20%20%20%20%20%20%3Ftitle%20wikibase%3AapiOutput%20mwapi%3Atitle.%0A%20%20%20%20%20%20%3Fcategory%20wikibase%3AapiOutput%20mwapi%3Acategory.%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Only%20include%20the%20model%20if%20it%20has%20been%20categorized%20with%20a%20Creative%20Commons%20license%0A%20%20%20%20FILTER%20STRSTARTS%28%3Fcategory%2C%20%22Category%3ACC-%22%29%0A%20%20%20%20%0A%20%20%20%20%23%20Extract%20a%20%E2%80%9Clicense%E2%80%9D%20name%20out%20of%20the%20category%20page%20title%0A%20%20%20%20BIND%28STRAFTER%28%3Fcategory%2C%20%22Category%3A%22%29%20AS%20%3Flicense%29%0A%20%20%7D%0A%7D Gallery of 3D models of structures mapped in OpenStreetMap that are available under Creative Commons licenses at Wikimedia Commons] - OSM/Wikidata query (sophox.org)
 * Item named after item named after item named after item named after item named after item
 * UK parliament members' opposition posts, start dates and end dates where Wikidata has a Parliament ID for that member (Source)
 * Count of Irish Statutory Instruments, 1948-2020 (Source)
 * [https://query.wikidata.org/#SELECT%20%3Fdecade%20%3Fgenre%20%3FgenreLabel%20%3Fcount%20%3FdecadeCount%20%28100%20%2a%20%3Fcount%20%2F%20%3FdecadeCount%20AS%20%3Fpercentage%29%20WHERE%20%7B%20%20%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fdecade%20%3Fgenre%20%28count%28%3Fx%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%23%20TOP%2020%20Genres%0A%20%20%20%20%20%20%20%20SELECT%20%3Ftop20Genre%20%3Fcount%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20SELECT%20%3Fgenre%20%28count%28%3Fx%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Fx%20%20wdt%3AP31%20wd%3AQ11424.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Fx%20%20wdt%3AP136%20%3Fgenre.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Exclude%20silent%20film%3B%20doesn%27t%20make%20a%20ton%20of%20sense%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20in%20this%20context%2C%20since%20it%27s%20more%20about%20the%20medium%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20than%20the%20content%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20FILTER%28%3Fgenre%20%21%3D%20wd%3AQ226730%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20GROUP%20BY%20%3Fgenre%0A%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20BIND%28%3Fgenre%20as%20%3Ftop20Genre%29%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20ORDER%20BY%20DESC%28%3Fcount%29%0A%20%20%20%20%20%20%20%20LIMIT%2020%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20SELECT%20%3Fx%20%28min%28%3FpubDate%29%20as%20%3FfirstPubDate%29%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fx%20%20wdt%3AP31%20wd%3AQ11424.%0A%20%20%20%20%20%20%20%20%20%20%3Fx%20%20wdt%3AP577%20%3FpubDate.%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20GROUP%20BY%20%3Fx%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%0A%20%20%20%20%20%20%3Fx%20%20wdt%3AP136%20%3Ftop20Genre.%0A%20%20%20%20%20%20BIND%28%3Ftop20Genre%20as%20%3Fgenre%29%0A%20%20%20%20%20%20BIND%28concat%28str%28floor%28year%28%3FfirstPubDate%29%20%2F%2010%29%29%2C%20%220s%22%29%20as%20%3Fdecade%29%0A%20%20%20%20%20%20FILTER%28%21isBlank%28%3Fdecade%29%29%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fdecade%20%3Fgenre%0A%20%20%7D%0A%0A%20%20%7B%0A%20%20%20%20%23%20Movies%20per%20decade%0A%20%20%20%20SELECT%20%3Fdecade%20%28count%28%3Fx%29%20as%20%3FdecadeCount%29%20WHERE%20%7B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20SELECT%20%3Fx%20%28min%28%3FpubDate%29%20as%20%3FfirstPubDate%29%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fx%20%20wdt%3AP31%20wd%3AQ11424.%0A%20%20%20%20%20%20%20%20%20%20%3Fx%20%20wdt%3AP577%20%3FpubDate.%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20GROUP%20BY%20%3Fx%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20BIND%28concat%28str%28floor%28year%28%3FfirstPubDate%29%20%2F%2010%29%29%2C%20%220s%22%29%20as%20%3Fdecade%29%0A%20%20%20%20%20%20%23%20This%20filter%20is%20very%20important%20%28in%20both%20subqueries%29%21%20Otherwise%0A%20%20%20%20%20%20%23%20the%20results%20of%20the%20sub%20queries%20can%27t%20be%20properly%20aligned.%0A%20%20%20%20%20%20FILTER%28%21isBlank%28%3Fdecade%29%29%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fdecade%0A%20%20%7D%0A%20%20%0A%20%20%23%20See%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FQ22917333%0A%20%20FILTER%28%3Fdecade%20%21%3D%20%222110s%22%29%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Movie genre trends] (Source)
 * Scientific papers explaining backward contact tracing (Source)
 * List of sovereign states in en, fr, de, ru (Source)
 * Locations depicted in paintings (Source)
 * The most commonly depicted locations (Source)


 * Development
 * Blocked users trying to create new Items no longer make us skip QIDs (T232620)
 * So far we don't have JSON dumps for Lexemes. We're working on regularly generating them as well now (T264883)
 * Continuing work on getting the Query Builder to generate the first query. Almost there.
 * Started the feedback round for the REST API. Please provide your input if you are currently using the action API or plan to develop against Wikidata's API in the future.

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

<div style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Read the full report · Unsubscribe · Mohammed Sadat (WMDE) 15:56, 19 October 2020 (UTC)