User talk:TCN7JM/Archive 90

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)

WikiCup 2020 September newsletter
The fourth round of the competition has finished, with 865 points being required to qualify for the final round, nearly twice as many points as last year. It was a hotly competitive round with two contestants with 598 and 605 points being eliminated, and all but two of the contestants who reached the final round having achieved an FA during the round. The highest scorers were


 * Free Hong Kong flag.svg Bloom6132, with 1478 points gained mainly from 5 featured lists, 12 DYKs and 63 in the news items;
 * 🇮🇩HaEr48 with 1318 points gained mainly from 2 featured articles, 5 good articles and 8 DYKs;
 * 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Lee Vilenski with 1201 points mainly gained from 2 featured articles and 10 good articles.

Between them, contestants achieved 14 featured articles, 14 featured lists, 2 featured pictures, 87 good articles, 90 DYK entries, 75 ITN entries, 95 featured article candidate reviews and 81 good article reviews. Congratulations to all who participated! It was a generally high-scoring and productive round and I think we can expect a highly competitive finish to the competition.

Remember that any content promoted after the end of round 4 but before the start of round 5 can be claimed in round 5. Remember too that you must claim your points within 10 days of "earning" them. If you are concerned that your nomination will not receive the necessary reviews, please list it on WikiCup/Reviews. It would be helpful if this list could be cleared of any items no longer relevant. If you want to help out with the WikiCup, please do your bit to keep down the review backlogs! Questions are welcome on Wikipedia talk:WikiCup, and the judges are reachable on their talk pages or by email. If you wish to start or stop receiving this newsletter, please feel free to add or remove yourself from WikiCup/Newsletter/Send. Godot13 (talk), Sturmvogel 66 (talk), Vanamonde (talk), Cwmhiraeth (talk) MediaWiki message delivery (talk) 19:53, 1 September 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)