User talk:James Allison/Archive 38

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


 * Discussions
 * Open request for adminship: Hazard-SJ, Gnoeee, Wagino 20100516
 * Closed request for adminship: Wiki13 (successful)


 * Events
 * Past: Wikibase Live Session - August 2020. This session had a few people present on some of their work with modeling GLAM data in Wikibase or Wikidata. (replay)
 * Upcoming: Next Linked Data for Libraries LD4 Wikidata Affinity Group call: Daniel Mietchen and Lane Rasberry about Scholia, a project to present bibliographic information and scholarly profiles of authors and institutions, 11 August. [Agenda]
 * Upcoming: Online Wikidata editathon in Swedish #25, August 16


 * Press, articles, blog posts, videos
 * Video: Wikipedia Weekly Network - QuickStatements and Distributed Wikidata games Facebook, YouTube
 * Video: Collaboration, contribution and use of Wikidata and Wikipedia by academic libraries (in Greek). YouTube
 * Librarians work to broaden Vanderbilt’s research reputation with Wikidata tools. "To speed up the creation of metadata about faculty and their publications, Steven Baskauf, data science and data curation specialist for libraries, developed “VanderBot,” a set of scripts that can read and write to Wikidata, greatly improving the efficiency by which Vanderbilt’s faculty are discoverable through Wikidata".


 * Tool of the week
 * OSM ↔ Wikidata matcher links Wikidata entries to places in OpenStreetMap.


 * Other Noteworthy Stuff
 * wikidata2df, a Python package for easily turning a Wikidata SPARQL query into a pandas dataframe
 * With Wikidata Concept Tree Generator, you can enter any concept and instantly see a visualization of its extended relations. (Source)


 * Did you know?


 * Newest properties:
 * General datatypes: size comparison diagram, view
 * External identifiers: Legacy.com newspaper ID, ChemSynthesis ID, Dizionario Biografico dei Protestanti in Italia ID, Maitron des fusillés ID, Fototeka person ID, LibraryThing series ID, TOPCMB ID, Swiss Industrial Heritage ID, Library of Congress Medium of Performance Thesaurus ID


 * New property proposals to review:
 * General datatypes: image of entrance, extinction date, notation writer, raga, tala, SMARTS, Editio princeps, recording location
 * External identifiers: Sochy a města ID osoby, Sochy a města ID sochy, podvignaroda, Have I Been Pwned breach ID, European Investment Bank project ID, WordNet 3.1 Synset Id, cadastral municipality ID, NPR station ID, NYARC Discovery ID, Nasjonalt skoleregister-ID, ERIC Thesaurus ID, American Folklore Society Ethnographic Thesaurus ID, Trismegistos Texts ID


 * Query examples:
 * Ancestors of the current King of Spain color coded by sex or gender
 * Political alignments of the parties of world leaders (Source)
 * Female Mathematicians whose birth/death anniversary is today (Source)
 * Commons queries:
 * Map of images found in the medieval Atlas De Wit (source)
 * [https://wcqs-beta.wmflabs.org/#%23%20Things%20depicted%20with%20cats%0A%0A%23%20Things%20depicted%20with%20cats%0A%0A%23defaultView%3AImageGrid%0ASELECT%20%3Fcount%20%3Fdepicted%20%3FdepictedLabel%20%3FsampleImg%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Ftarget%20WHERE%20%7B%0A%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%20%20%20%0A%20%20%20%20%20%20%20%20%7B%20%3Ftarget%20wdt%3AP31%3F%2Fwdt%3AP279%2a%20wd%3AQ146%20%7D%20%20%20%20%20%23%23%20include%20specific%20sorts%20of%20cats%20and%20individual%20cats%0A%20%20%20%20%20%20%20%20UNION%0A%20%20%20%20%20%20%20%20%7B%20%3Ftarget%20wdt%3AP31%3F%20wd%3AQ43577%20%7D%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%23%20and%20also%20breeds%20of%20cat%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D%20AS%20%25targets%0A%20%20%20%20%0AWITH%20%7B%0A%20%20SELECT%20%28COUNT%28DISTINCT%28%3Ffile%29%29%20AS%20%3Fcount%29%20%3Fdepicted%20%28SAMPLE%28%3Ffile%29%20AS%20%3Fsample%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25targets%20.%0A%20%20%20%20%3Ffile%20p%3AP180%20%3Fstmt%20.%0A%20%20%20%20%3Fstmt%20ps%3AP180%20%3Ftarget%20.%0A%20%23%20%20%20%3Fstmt%20wikibase%3Arank%20wikibase%3APreferredRank%20.%20%20%20%20%20%20%20%23%23%20%20Make%20sure%20the%20cat%20is%20marked%20as%20prominent%20--%20%2a%2acommented%20out%20for%20now%2a%2a%0A%20%20%20%20%0A%20%20%20%20%3Ffile%20p%3AP180%20%3Fstmt2.%20%20FILTER%20%28%3Fstmt2%20%21%3D%20%3Fstmt%29%20.%20%20%20%20%23%23%20%20now%20get%20another%20depicts%20statement%0A%20%20%20%20%3Fstmt2%20ps%3AP180%20%3Fdepicted%20.%20%0A%20%20%7D%20GROUP%20BY%20%3Fdepicted%0A%7D%20AS%20%25things%20%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Fcount%20%3Fdepicted%20%3Fsample%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25things%20.%0A%20%20%20%20MINUS%20%7B%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%23%20exclude%20anything%20that%20was%20an%20original%20target%0A%20%20%20%20%20%20SELECT%20%28%3Ftarget%20AS%20%3Fdepicted%29%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20INCLUDE%20%25targets%20.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D%20AS%20%25things1%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25things1%20.%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%0A%20%20%20%20%20%20%3Fdepicted%20rdfs%3Alabel%20%3FdepictedLabel%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20%3Fsample%20schema%3AcontentUrl%20%3Furl%20%3B%0A%20%20bind%28iri%28concat%28%22http%3A%2F%2Fcommons.wikimedia.org%2Fwiki%2FSpecial%3AFilePath%2F%22%2C%20wikibase%3AdecodeUri%28substr%28str%28%3Furl%29%2C53%29%29%29%29%20AS%20%3FsampleImg%29%0A%7D%20ORDER%20BY%20DESC%28%3Fcount%29 Things depicted with cats] (source)


 * Development
 * finalized designs for the query builder to start coding at the beginning of September
 * wrapping up the initial work on the design system so that we can start using the first pieces of it in the query builder development
 * working on properly linking redirects in recent changes, watchlist and co (T255387)
 * addressed remaining security review comments about the Wikidata Bridge so that we can deploy it finally on the first Wikipedia
 * fixed a bug where string values had the wrong length limit (T259440)
 * finishing the work of untangling Wikibase Client and Wikibase Repository extensions to make development easier

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:06, 10 August 2020 (UTC)

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


 * Discussions
 * Closed requests for adminship: Hazard-SJ, Gnoeee, Wagino 20100516 (all successful)
 * New request for comments: How (un)important is preserving the historic character of an item?


 * Events
 * Upcoming: Online Wikidata editathon in Swedish #26, August 23


 * Press, articles, blog posts, videos
 * Video: Editing Wikidata with information from Son jarocho (in Spanish). YouTube


 * Tool of the week
 * Entity Explosion: a new multilingual Chrome browser extension. "Taking the power of Wikidata with me wherever I go across the web!". Uses API calls to the Wikidata Query Service to match the URL you are browsing on to a Wikidata item, and then displays data and links to other sites about the same entity. (Video)


 * Other Noteworthy Stuff
 * Wikidata Bridge v1 will be deployed on Catalan Wikipedia on August 18th
 * New description and screenshots for the Simple Query Builder project, feedback welcome
 * Help:Dataset sizing


 * Did you know?


 * Newest properties:
 * General datatypes: alternative form
 * External identifiers: Henrik Ibsen writings ID, RKD thesaurus ID, TCLF ID, Sculptures and cities database ID for sculptures, Manioc book ID, Presence compositrices ID of composer, Offizielle Deutsche Charts song ID, ToS;DR service numerical identifier, Have I Been Pwned breach ID, Unsplash User ID, EIB project ID, ANZSRC 2020 FoR ID


 * New property proposals to review:
 * General datatypes: latest start date, earliest end date, Number of votes after transferring, map URL, type of archaeological site, record number, front and back matter
 * External identifiers: Sports-Reference.com college football school ID, Panteono de edukado.net, LSG local body code, MobyGames attribute ID, Dictionary of Occupational Titles ID, Frauen in Bewegung 1848–1938, Anais do Museu Paulista article ID, Dictionary of Occupational Titles Code (fourth edition, revised), Proballers player ID, Linked Open Data Cloud identifier, Chrome Webstore extension ID, CTHS publication ID, LBS Physical ID, GBIF occurence ID


 * Query examples:
 * Largest collections of Picasso content (Source). The National Gallery of Art holds the most with 303 objects
 * Bubble chart of snooker world champions (Source)
 * Map of streets in Tillydrone named after WW2 military leaders (Source)


 * Development
 * Fixed a bug where a length limit for strings seems to have reverted itself back from 1500 to its default 400 (T259440)
 * Fixed a bug that Wikibase is not always adding &redirect=no in situations when MediaWiki usually does (T255387)
 * Wrapping up the initial work on the design system so it is ready for use in the first new feature (Query Builder)
 * Fixed the serialization of statements on Forms and Senses not containing the datatype (T249206)
 * Wrapping up work on the first version of Federated Properties so that other Wikibase installations can use Wikidata's Properties instead of having to maintain their own
 * Worked on ensuring the data from the linked data interface at Special:EntityData is always up to date after an edit has been made (T128486)
 * Enabling clients to use Lua to request labels, descriptions and aliases in some (often minority) languages even when they are not content languages (T259340, T260118)

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:03, 17 August 2020 (UTC)

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


 * Events
 * Upcoming: Wikidata distributed birthday in October. You can organize an (online) event with your local group or favorite WikiProject! See also: calendar in progress, information for organizers, 24-hours online meetup
 * Upcoming: Next Linked Data for Libraries LD4 Wikidata Affinity Group call: We will talk about gadgets and user scripts. 25 August. Agenda
 * Upcoming: Online Wikidata editathon in Swedish #27, August 30
 * Upcoming video: Wikipedia Weekly Network - LIVE Wikidata editing #17 Facebook, YouTube


 * Press, articles, blog posts, videos
 * Commonsense Knowledge in Wikidata (via ArXiv)
 * Wikidata-focused presentations at the Workshop "Data Science in Climate and Climate Impact Research" taking place on 20-21 August 2020 in Zurich and online.
 * Sarasua, Cristina, & Mietchen, Daniel. (2020, August). Multilingual Structured Climate Research Data in Wikidata - The Community Perspective. Zenodo. http://doi.org/10.5281/zenodo.3994272
 * Mietchen, Daniel, & Sarasua, Cristina. (2020, August). Multilingual Structured Climate Research Data in Wikidata - The Data Perspective. Zenodo. http://doi.org/10.5281/zenodo.3994266 (also on YouTube)
 * Video: How to add missing descriptions to Wikidata using QuickStatments tool (in Arabic) - YouTube
 * Video: Wikipedia Weekly Network - LIVE Wikidata editing #16 Facebook, YouTube
 * Video: Introduction to Wikidata (in Malayalam) - YouTube
 * Video: Wikidata editing basics (in Chinese) - YouTube


 * Tool of the week
 * Sophox allows for SPARQL querying of Wikidata and OpenStreetMap in a single query


 * Other Noteworthy Stuff
 * Two new grant programs from WikiCite, in support of open citations and linked bibliographic data.
 * Full documentation, eligibility requirements, selection criteria, program design principles, and contacts at the links. Apply by 1 October.


 * Project & events [$2-10k]
 * e-Scholarships [per-diem calculated on your city; 1-5 people (single, or as a 'remote group') for 2-4 days, for COVID-era "stay at home" projects. Paid in advance living allowance, no expense report required.]


 * Did you know?


 * Newest properties:
 * General datatypes: SMARTS notation, tala, raga, recording location, law or regulation identifying number, earliest end date, latest start date, extinction date
 * External identifiers: Filmstarts title ID, Trismegistos text ID, SPLC Individual ID, ERIC Thesaurus ID, American Folklore Society Ethnographic Thesaurus ID, BHF magazine ID, Macedonian cadastral municipality ID, Monumentbrowser ID, Frauen in Bewegung 1848–1938 ID, Nasjonalt skoleregister ID, BHF author ID, Proballers ID, Opera Online work ID, Opera Online composer ID, Opera Online opera house ID, CTHS publication ID


 * New property proposals to review:
 * General datatypes: Namesakes, Engineer's Line Reference, bibliography, external auditor, ITF-identificatiecode voor speler 2020, rotated image, mirrored image, combined from, overlaid from, number of deaths in senior care homes, number of cases intensive care, negotiated by, is solution to, Commons category for the exterior of the item, Number of taxpayers, medium
 * External identifiers: Abbreviations related to ancient authors and works and to academic works regarding classical antiquity, YIVO Encyclopedia of Jews in Eastern Europe ID, Emporis company ID, Sports-Reference.com college basketball box score ID, FBref.com squad ID, Operator licence number, Jewish Virtual Library person ID, Spanish Artists from the Fourth to the Twentieth Century ID, JSTOR publisher ID, Istrapedia ID, monumenta.ch ID, Microsoft MVP profile ID, Art Bonus ID, The Living New Deal ID, TracesOfWar person ID, Hrvatski biografski leksikon ID, UG Digital Collections, jewishencyclopedia.com ID, Fancyclopedia 3 ID, Hrvatska tehnička enciklopedija ID, Grandterrier.net ID


 * Query examples:
 * British MPs with sons- or daughters-in-law who were also MPs (source)
 * MPs with the largest number of children or childen-in-law who became MPs (source)
 * Descendants of Robert Emett (born 1729), with counts of sitelinks and external IDs for them and their spouses (source)
 * Programming languages written by women (Source)
 * Bar chart showing the number of research output (articles, etc) annotated with a SARSCoV2 proteins as 'main subject' (Source)
 * Female soccer players who have a (known) social media account (Source)
 * Largest cities in France by population (Source)
 * Commons queries:
 * [https://wcqs-beta.wmflabs.org/#%23defaultView%3AImageGrid%0Aselect%20%3Fimage%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fthumb%20%28%3Fp170Label%20as%20%3Fauthor%29%20%28YEAR%28%3Fp570%29%20as%20%3Fdeath%29%20%3Fcopyright_statusLabel%20with%20%7B%0A%20%20select%20%2a%20%7B%0A%20%20%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP131%2a%20wd%3AQ1757%20.%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP170%20%3Fp170%20.%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel%20filter%20%28lang%28%3FitemLabel%29%20%3D%20%22en%22%29%20%7D%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20schema%3Adescription%20%3FitemDescription%20filter%20%28lang%28%3FitemDescription%29%20%3D%20%22en%22%29%20%7D%20%20%20%20%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fp170%20rdfs%3Alabel%20%3Fp170Label%20filter%20%28lang%28%3Fp170Label%29%20%3D%20%22en%22%29%20%7D%20%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fp170%20wdt%3AP570%20%3Fp570%20%7D%20.%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fp170%20wdt%3AP7763%20%3Fcopyright_status.%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Fcopyright_status%20rdfs%3Alabel%20%3Fcopyright_statusLabel%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20filter%20%28lang%28%3Fcopyright_statusLabel%29%20%3D%20%22en%22%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D%20as%20%25works%20where%20%7B%0A%20%20include%20%25works.%0A%20%20%3Fimage%20wdt%3AP180%20%3Fitem.%0A%20%20%3Fimage%20schema%3AcontentUrl%20%3Furl.%20%0A%20%20bind%28iri%28concat%28%22http%3A%2F%2Fcommons.wikimedia.org%2Fwiki%2FSpecial%3AFilePath%2F%22%2C%20wikibase%3AdecodeUri%28substr%28str%28%3Furl%29%2C53%29%29%29%29%20AS%20%3Fthumb%29%0A%7D Works in Helsinki, and their copyright status] (source)
 * Newest WikiProjects: WikiProject Gazetteer


 * Development
 * Deployed the first version of the Wikidata Bridge to Catalan Wikipedia
 * Creating Grafana Dashboards for the new Wikidata Bridge so we have some data to help us determine which datatypes to support next for example (T260532)
 * Finished working on ensuring Labels of Items in some unusual, often minority, languages are still available on Wikipedia and other clients ( T259340)
 * Fixed error messages for API modules that will not work with the first version of Federated Properties (T258558)
 * Working on improving how ORES judges the quality of an Item to make it more accurate
 * Started coding on Automated Configuration Discovery to make it easier for tool builders to make their tools work for other Wikibase instances as well

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:09, 24 August 2020 (UTC)

The Signpost: 30 August 2020
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 17:32, 30 August 2020 (UTC)

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


 * Events
 * Past: Editing contest - Members of the 3rd Parliament of the 4th Republic of Ghana. By Global Open Initiative - YouTube (1), (2)
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, September 1 at 18:00 CEST
 * Upcoming: WMF search platform team office hour, September 2nd at 17:00 CEST (15:00 GMT). Etherpad, Google Meet. You can come and chat about the Wikidata & Commons Query Service.
 * Upcoming: Wikidata birthday events organizers call, September 2nd at 19:00 CEST.
 * Upcoming: Online Wikidata editathon in Swedish #28, September 6
 * Upcoming video: Wikipedia Weekly Network - LIVE Wikidata editing #18 Facebook, YouTube, September 5 at 19.00 UTC
 * Upcoming: Onam label-a-thon (September 1st and 2nd): Online label-a-thon to improve Wikidata items related to Kerala and Malayalam on this Onam holidays.


 * Press, articles, blog posts, videos
 * Video: How to use the Wikidata Query Service, by Dr Chris Langley
 * Video: Wikipedia Weekly Network - LIVE Wikidata editing #17 Facebook, YouTube
 * Video: Creating a Wikidata item (in Spanish) - YouTube
 * WikiCite and bibliographic data on Wikidata, how to contribute and how to view it with Scholia (in Spanish) - YouTube
 * Wikipedia's not so little sister is finding its own way - article by Lydia Pintscher in the Wikipedia Signpost


 * Tool of the week
 * Wikidata for Firefox is a browser extension that displays Wikidata items while browsing the web, adds missing IDs and extracts information from websites to Wikidata.


 * Other Noteworthy Stuff
 * Entity Explosion, the browser add-on for Chrome is now also available for Firefox. When the user visits a web page, it displays data from Wikidata, about the subject of that page.
 * WMF will be performing data center maintenance operations by switching all traffic to the secondary data centre on Tuesday, September 1st 2020. You will be able to read, but not edit, all wikis for up to an hour from 14:00 UTC
 * The Wikidata community now has a channel on the newly-established Wikimedia Chat service.
 * reconciler, a Python wrapper for Open Refine's API to reconcile pandas data frames with Wikidata items.


 * Did you know?


 * Newest properties:
 * General datatypes: Butcher tableau, front and back matter, external auditor
 * External identifiers: edukado.net Panteono ID, Chrome Webstore extension ID, PARADISEC Catalog, NPR station ID, JSTOR publisher ID, Emporis company ID, Art Bonus ID, British Museum object ID, monumenta.ch ID, The Living New Deal ID, Jewish Virtual Library person ID, YIVO Encyclopedia of Jews in Eastern Europe ID, Spanish Artists from the Fourth to the Twentieth Century ID


 * New property proposals to review:
 * General datatypes: parent superproperty, publisher of, performed at, Barcelona Public art identifier, opening hours (v.3), Fanbase name, aerial view, ground clearance, axle track, placeholder text element ID, displacement, Deutsche Bahn station abbreviation, entry in abbreviations table, Liturgical rank
 * External identifiers: NHK Archives Portal person ID, EPA Ecoregion Level 1 Code, EPA Ecoregion Level 2 Code, EPA Ecoregion Level 3 Code, EPA Ecoregion US Level 3 Code, EPA Ecoregion US Level 4 Code, Encyclopaedia of Architects, Vienna 1770–1945, Firefox add-on ID, London Stock Exchange company, Fatcat ID, NDL law ID, e-Gov law ID, OFAC sanction ID, British and Irish Furniture Makers Online ID, Library of Congress Children's Subject Headings ID, Occupational Outlook Handbook ID, Regesta Ecclesiastica Salisburgensia ID, Wisconsin Historical Society NRHP ID, YUAG ID, Grove Music Online ID, Carl-Maria-von-Weber-Gesamtausgabe person ID, McClintock and Strong Biblical Cyclopedia ID, Dostoyevsky and His Entourage ID


 * Query examples:
 * Map of cities and towns in the San Jose–San Francisco–Oakland combined statistical area - OSM/Wikidata query
 * Map of structures that have won architectural awards - OSM/Wikidata query
 * Birth places of Buffalo Sabres players (Source)
 * Timeline of all of Bird’s tunes (Source)
 * Approximate proportion of people called "John" in any given UK Parliament since 1372 (Source)
 * People born in Czechia who died in Germany and vice versa, by decade of birth (Source)
 * [https://sophox.org/#%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%20decommissioned%20aircraft%0A%20%20%3Fosm%20osmt%3Ahistoric%20%22aircraft%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%3Aaircraft%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%20UNION%20%7B%0A%20%20%20%20%20%20%20%20%23%20Or%20it%20must%20be%20part%20of%20an%20industry%20%28e.g.%2C%20Wright%20Brothers%29%0A%20%20%20%20%20%20%20%20%3FmakeModel%20%28wdt%3AP106%7Cwdt%3AP452%29%20%5B%5D.%0A%20%20%20%20%20%20%20%20BIND%28%3FmakeModel%20AS%20%3Fmake%29%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%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 Location of decommissioned aircraft] - OSM/Wikidata query (Source)
 * Railway network in Czechia (Source)
 * People born in Czechia who died in Germany and vice versa, by decade (of birth) (Source)
 * List of locations of Woolf's books (Source)


 * Development
 * Working on Automated Configuration Discovery to make it easier for tool builders to make their tools work for other Wikibase instances as well
 * Polishing remaining pieces of the first version of Federated Properties to make it possible to use Wikidata's Properties in other Wikibase instances
 * Continuing to work on improving the way ORES automatically scores the quality of an Item to make it more accurate

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:49, 31 August 2020 (UTC)

Editing news 2020 #4
Read this in another language • Subscription list for this newsletter

Reply tool


The Reply tool  has been available as a Beta Feature at the Arabic, Dutch, French and Hungarian Wikipedias since 31 March 2020. The first analysis showed positive results.


 * More than 300 editors used the Reply tool at these four Wikipedias. They  posted more than 7,400 replies during the study period.
 * Of the people who posted a comment with the Reply tool, about 70% of them used the tool multiple times. About 60% of them used it on multiple days.
 * Comments from Wikipedia editors are positive. One said, أعتقد أن الأداة تقدم فائدة ملحوظة؛ فهي تختصر الوقت لتقديم رد بدلًا من التنقل بالفأرة إلى وصلة تعديل القسم أو الصفحة، التي تكون بعيدة عن التعليق الأخير في الغالب، ويصل المساهم لصندوق التعديل بسرعة باستخدام الأداة.  ("I think the tool has a significant impact; it saves time to reply while the classic way is to move with a mouse to the Edit link to edit the section or the page which is generally far away from the comment. And the user reaches to the edit box so quickly to use the Reply tool.")

The Editing team released the Reply tool as a Beta Feature at eight other Wikipedias in early August. Those Wikipedias are in the Chinese, Czech, Georgian, Serbian, Sorani Kurdish, Swedish, Catalan, and Korean languages. If you would like to use the Reply tool at your wiki, please tell User talk:Whatamidoing (WMF).

The Reply tool is still in active development. Per request from the Dutch Wikipedia and other editors, you will be able to customize the edit summary. (The default edit summary is "Reply".) A "ping" feature is available in the Reply tool's visual editing mode. This feature searches for usernames. Per request from the Arabic Wikipedia, each wiki will be able to set its own preferred symbol for pinging editors. Per request from editors at the Japanese and Hungarian Wikipedias, each wiki can define a preferred signature prefix in the page MediaWiki:Discussiontools-signature-prefix. For example, some languages omit spaces before signatures. Other communities want to add a dash or a non-breaking space.

New requirements for user signatures

 * The new requirements for custom user signatures began on 6 July 2020. If you try to create a custom signature that does not meet the requirements, you will get an error message.
 * Existing custom signatures that do not meet the new requirements will be unaffected temporarily . Eventually, all custom signatures will need to meet the new requirements. You can check your signature and see lists of active editors whose custom signatures need to be corrected.  Volunteers have been contacting editors who need to change their custom signatures.  If you need to change your custom signature, then please read the help page.

Next: New discussion tool
Next, the team will be working on a tool for quickly and easily starting a new discussion section to a talk page. To follow the development of this new tool, please put the New Discussion Tool project page on your watchlist.

Whatamidoing (WMF) (talk) 18:48, 31 August 2020 (UTC)

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


 * Events
 * Upcoming: Next Linked Data for Libraries LD4 Wikidata Affinity Group call: Rob Fernandez (Wikimedia District of Columbia) on Listeria, a tool that uses SPARQL queries to define a list, and provides a bot that will update a wiki page containing that list if the results of that SPARQL query change, all based on Wikidata, 08 September. Agenda
 * Upcoming: live SPARQL queries on Twitch and in French by Vigneron, September 8 at 18:00 CEST
 * Upcoming video: Wikipedia Weekly Network - LIVE Wikidata editing #19 Facebook, YouTube, September 10
 * Upcoming: Online Wikidata editathon in Swedish #29, September 13


 * Press, articles, blog posts, videos
 * Semantic Wikibase has been released by Professional.Wiki (Demo video)
 * Video: Wikipedia Weekly Network - LIVE Wikidata editing #18, workflows for SPARQL queries and QuickStatements Facebook, YouTube
 * OpenRefine 3.4 was released
 * How can I get data on all the dams in the world? Use Wikidata. By Addshore
 * Wikidata Training Workshop 2, by Canadian Arts Presenting Association - YouTube
 * Contributing to Wikidata - (Parts 1, 2, 3 & 4)
 * Contributing to Wikidata (in French) - (Parts 1, 2, 3 & 4)
 * Video: How to use QuickStatements - a tool to bulk upload data onto Wikidata. By Dr Sara Thomas


 * Tool of the week
 * is a dashboard that measures Wikidata's usage and coverage on Wikimedia Foundation projects.


 * Other Noteworthy Stuff
 * Entity Explosion, the browser add-on for Chrome is now also available for Firefox. When the user visits a web page, it displays data from Wikidata, about the subject of that page.


 * Did you know?


 * Newest properties:
 * General datatypes: none
 * External identifiers: LSG local body code, NYARC Discovery ID, Encyclopaedia of Architects, Vienna 1770–1945 ID, Hrvatska tehnička enciklopedija ID, ICP artist ID, TracesOfWar person ID, Firefox add-on ID, NHK Archives Portal person ID, Hrvatski biografski leksikon ID, InciWeb ID, YUAG ID, Wikipedia Library partner ID, FIPRESCI person ID, Anais do Museu Paulista article ID, Legacies of British Slave-ownership place ID, Wisconsin Historical Society NRHP ID, Carl-Maria-von-Weber-Gesamtausgabe ID


 * New property proposals to review:
 * General datatypes: applies to form or aspect, blocked on the territory of, Liturgical category, Flickr image URL, turning radius, number of reboots, financials URL, SI base units, rank insignia2
 * External identifiers: Syro-Malabar Church Parish ID, Database of Umgebinde houses in Bohemian Switzerland ID, Re-Member ID, DIL ID, Naver Vibe Artist ID, American Battlefield Trust battlefield ID, American Battlefield Trust person ID, L'Officiel des spectacles ID, VA facility ID, Hikr Waypoint ID, tvmaze ID, Thomas Jefferson Encyclopedia ID, Danish educational institution number, Past Fellow of the Royal Society ID, photoLondon ID, uta-net.com song ID, Historic Montana ID, KHRI ID, Seattle Art Museum ID, Nelson-Atkins Museum of Art artwork ID


 * Query examples:
 * Map of companies developing/manufacturing a COVID-19 vaccine candidate that is at least in a phase 1 clinical trial
 * [https://sophox.org/embed.html#SELECT%20%3Fosm%20%3Famount%20%3Fiso4217%20%3FamountUSD%20WHERE%20%7B%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22%20.%0A%20%20%0A%20%20%23%20Query%20Wikidata%20for%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%23%20Currencies%0A%20%20%20%20%3Fcurrency%20wdt%3AP31%20wd%3AQ8142%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Their%20ISO%204217%20codes%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP498%20%3Fiso4217%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Their%20exchange%20rate%20statements%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20p%3AP2284%20%3FrateStatement.%0A%20%20%20%20%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%23%20Preferred%20statement%20about%20a%20USD%20exchange%20rate%0A%20%20%20%20%20%20%3FrateStatement%20wikibase%3Arank%20wikibase%3APreferredRank%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20psv%3AP2284%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AquantityAmount%20%3FpreferredConversion%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AquantityUnit%20wd%3AQ4917%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D.%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%23%20Normal%20statement%20about%20a%20USD%20exchange%20rate%0A%20%20%20%20%20%20%3FrateStatement%20wikibase%3Arank%20wikibase%3ANormalRank%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20psv%3AP2284%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AquantityAmount%20%3FnormalConversion%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AquantityUnit%20wd%3AQ4917%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D.%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Normally%20a%20triple%20would%20use%20the%20preferred%20statement%20if%20available%2C%20falling%20back%20to%20a%20normal%20statement%0A%20%20%20%20%23%20However%2C%20we%20have%20to%20do%20the%20fallback%20manually%20because%20we%20got%20the%20raw%20statements%20in%20order%20to%20filter%20by%20qualifier%0A%20%20%20%20BIND%28COALESCE%28%3FpreferredConversion%2C%20%3FnormalConversion%29%20AS%20%3Fconversion%29%0A%20%20%20%20FILTER%20BOUND%28%3Fconversion%29%0A%20%20%7D%0A%20%20%0A%20%20%23%20Query%20OpenStreetMap%20for%20prices%20of%20services%0A%20%20%3Fosm%20osmt%3Acharge%20%3Fcharge.%0A%20%20%0A%20%20%23%20Only%20flat%20fees%2C%20since%20rates%20by%20time%20are%20difficult%20to%20compare%20across%20service%20types%0A%20%20FILTER%20REGEX%28%3Fcharge%2C%20%22%5E%5B0-9%5D%2B%28%3F%3A%5C%5C.%5B0-9%5D%2B%29%3F%20%5BA-Z%5D%7B3%7D%24%22%29%0A%20%20%0A%20%20%23%20Parse%20the%20price%20and%20convert%20it%20from%20the%20local%20currency%20to%20USD%0A%20%20BIND%28xsd%3Adecimal%28STRBEFORE%28%3Fcharge%2C%20%22%20%22%29%29%20AS%20%3Famount%29%0A%20%20BIND%28STRAFTER%28%3Fcharge%2C%20%22%20%22%29%20AS%20%3Fiso4217%29%0A%20%20BIND%28%3Famount%20%2A%20%3Fconversion%20AS%20%3FamountUSD%29%0A%7D%0AORDER%20BY%20DESC%28%3FamountUSD%29%0ALIMIT%20100 A table of the 100 highest fees charged for using various kinds of facilities, normalized to United States dollars] - OSM/Wikidata query
 * Youngest age of UK MPs leaving office since 1900 (Source)
 * Longest time UK MPs lived after leaving office since 1900 (Source)
 * British cabinet members with past military service (Source)
 * Earliest written record of 10 largest Czech cities (Source)
 * Churches dedicated to Czech patron St. Wenceslas (blue) and Moravian patrons St. Cyril and Methodeus (orange) (Source)
 * German municipality names ending with -in, -ing, -heim (Source)


 * Development
 * Added Wikidata support to Japanese Wikivoyage. T261451
 * Investigating the nature of our training outliers to improve the way ORES automatically scores the quality of an Item.
 * Working on error that sometimes causes Wikidata UI to report 2 error messages when saving a sitelink in an item. T260869
 * Completed various investigations to make an informed decision on the output format of WikibaseManifest files (automated configuration detection for toolbuilders) T261285
 * Completed various bug fixes and wrap-up tasks to conclude the major engineering work on the Federated Properties project
 * More work on Item Quality Scoring and Federated Properties

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:43, 7 September 2020 (UTC)

Wikidata weekly summary #433
<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
 * 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!

<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:16, 14 September 2020 (UTC)