User talk:TCN7JM/Archive 28

Wikidata weekly summary #216
Here's your quick overview of what has been happening around Wikidata over the last week.  Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 16:51, 4 July 2016 (UTC)
 * Events/Blogs/Press
 * Europeana280 Art History Challenge has finished
 * Europeana blog post
 * video
 * Wikimedia blog post
 * The life and times of Mr Herbert Ellerby: Linking Llandudno, Lancashire, and Moggill, Australia
 * Wikidata auf der GPN
 * Past: PSESHSF (You can sign up to be notified about more Wikidata workshops in France)
 * Past: Swiss Open Cultural Data Hackathon
 * Upcoming: office hour on IRC
 * Upcoming: State of the Map US in Seattle - http://stateofthemap.us/
 * Upcoming: Wikimedia UK AGM with Wikidata training
 * Other Noteworthy Stuff
 * There is now a 100wikidatadays challenge based on the 100wikidays challenge for Wikipedia. The goal: convert 100 templates to make use of Wikidata over the course of 100 days.
 * Tobias started writing a tutorial on how to write infoboxes that make use of Wikidata's data and could use your help expanding it.
 * Thiemo wrote a user script to pre-fill "date retrieved" in a reference with the current date. Please test and let us know what you think ont he linked page. If you like it it can become a gadget.
 * Did you know?
 * Newest properties: British Book Trade Index ID, Plarr ID, warheroes.ru ID, Dailymotion channel ID, Munk's Roll ID, Catalogus Professorum Rostochensium ID, CageMatch tag team ID, Pleiades place type identifier, parliamentary term
 * Query examples: Ancestors of Guðni Jóhannesson (note the last names), movies with Bud Spencer (source), largest cities per country (source), longest river of each continent (source), rivers in Antarctica (source), continents (source), and some other continents (source), places with continent Antarctica more than 3000 km north of south pole (source), files used as “image” in more than 10 items (source), monuments historiques in Loire-Atlantique (source), music composers by birth place (source), places of whorship (source), teachers with most students (source), buildings in more than one country (source), sandwiches (source), [https://query.wikidata.org/#%23%20Each%20composer%E2%80%99s%20most%20used%20tonality%2C%20with%20number%20of%20works%20in%20that%20tonality.%0A%23%20%28If%20this%20is%20ambiguous%20%E2%80%93%20multiple%20tonalities%20with%20the%20same%20number%20%E2%80%93%20there%20are%20multiple%20results%20for%20one%20composer.%29%0A%23%20%0A%23%20The%20SPARQL%20for%20this%20is%20an%20evil%20perversion%20of%20three%20subqueries%20%28one%20of%20them%20nested%20in%20another%29.%0A%23%20To%20understand%20it%2C%20you%20have%20to%20go%20inside%20out%E2%80%A6%20follow%20the%20numbers.%0A%0ASELECT%20%3FcomposerLabel%20%3FtonalityLabel%20%3Fcount%0AWHERE%0A%7B%0A%20%20%7B%0A%20%20%20%20%23%204.%20Group%20again%2C%20this%20time%20just%20by%20the%20composer.%0A%20%20%20%20%23%20%20%20%20We%20also%20select%20the%20highest%20count%20of%20a%20tonality.%0A%20%20%20%20%23%20%20%20%20Notice%20that%20we%20don%E2%80%99t%20know%20what%20tonality%20this%20count%20is%20associated%20with%20%E2%80%93%20we%E2%80%99ll%20get%20to%20that.%0A%20%20%20%20%23%20%20%20%20So%20now%20we%20have%20each%20composer%2C%20along%20with%20how%20often%20they%20used%20whatever%20tonality%20they%20used%20most.%0A%20%20%20%20SELECT%20%3Fcomposer%20%28MAX%28%3Fcount%29%20AS%20%3Fcount%29%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%23%202.%20Group%20by%20composer%20and%20tonality%2C%20so%20that%20for%20each%20composer%20and%20tonality%2C%20we%20get%20a%20count%20of%20how%20often%20the%20composer%20used%20this%20tonality.%0A%20%20%20%20%20%20%20%20SELECT%20%3Fcomposer%20%3Ftonality%20%28COUNT%28%3Fcomposition%29%20AS%20%3Fcount%29%0A%20%20%20%20%20%20%20%20WHERE%0A%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%23%201.%20Extremely%20straightforward%3A%20the%20%3Fcomposition%20has%20the%20composer%20%3Fcomposer%20and%20the%20tonality%20%3Ftonality.%0A%20%20%20%20%20%20%20%20%20%20%23%20%20%20%20%28I%E2%80%99m%20not%20bothering%20with%20any%20%E2%80%9Cinstance%20of%E2%80%9D%20because%20the%20presence%20of%20these%20two%20properties%20is%20a%20sufficient%20indicator%20of%20%3Fcomposition%20being%20a%20composition.%29%0A%20%20%20%20%20%20%20%20%20%20%3Fcomposition%20wdt%3AP86%20%3Fcomposer%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP826%20%3Ftonality.%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20GROUP%20BY%20%3Fcomposer%20%3Ftonality%0A%20%20%20%20%20%20%20%20HAVING%28%3Fcount%20%3E%201%29%20%23%203.%20Limit%20that%20to%20counts%20%3E%201%2C%20because%20using%20a%20tonality%20once%20is%20hardly%20%E2%80%9Cmost%20used%E2%80%9D.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fcomposer%0A%20%20%7D%0A%20%20%7B%0A%20%20%20%20%23%206.%20Identical%20to%202.%0A%20%20%20%20SELECT%20%3Fcomposer%20%3Ftonality%20%28COUNT%28%3Fcomposition%29%20AS%20%3Fcount%29%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%205.%20Identical%20to%201.%0A%20%20%20%20%20%20%3Fcomposition%20wdt%3AP86%20%3Fcomposer%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP826%20%3Ftonality.%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fcomposer%20%3Ftonality%0A%20%20%20%20HAVING%28%3Fcount%20%3E%201%29%20%23%207.%20Identical%20to%203.%0A%20%20%7D%0A%20%20%23%208.%20That%E2%80%99s%20it.%20Wait%2C%20what%3F%0A%20%20%23%20%20%20%20From%204%2C%20we%20now%20have%20%3Fcomposer%2C%20any%20composer%2C%20and%20%3Fcount%2C%20the%20count%20of%20how%20often%20they%20used%20whatever%20tonality%20they%20used%20most.%0A%20%20%23%20%20%20%20From%206%2C%20we%20also%20have%20a%20%3Fcomposer%2C%20as%20well%20as%20a%20%3Ftonality%2C%20and%20the%20count%20of%20how%20often%20they%20used%20that%20particular%20tonality.%0A%20%20%23%20%20%20%20The%20trick%20is%20that%20%3Fcomposer%20and%20%3Fcount%20are%20the%20same%20variable%20in%20each%20subquery%2C%20and%20so%20now%2C%20when%20the%20two%20subqueries%20are%20joined%2C%0A%20%20%23%20%20%20%20we%20select%20only%20that%20%3Ftonality%20from%206%20where%20the%20%3Fcomposer%20and%20the%20%3Fcount%20are%20identical%20to%20those%20from%204%20%E2%80%93%0A%20%20%23%20%20%20%20that%20is%2C%20where%20this%20tonality%20was%20used%20as%20often%20as%20the%20composer%E2%80%99s%20most-used%20tonality.%0A%20%20%23%20%20%20%20In%20other%20words%2C%20this%20must%20%2abe%2a%20the%20composer%E2%80%99s%20most-used%20tonality%20%28except%20when%20there%20are%20multiple%20tonalities%20with%20the%20same%20count%29.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20%23%209.%20Order%20by%20count%20%28highest%20first%29%2C%20because%20the%20result%20isn%E2%80%99t%20very%20meaningful%20for%20low%20counts%20%28many%20compositions%20aren%E2%80%99t%20on%20Wikidata%20or%20don%E2%80%99t%20have%20a%20tonality%20statement%29. composers and their most-used tonality] (source), former capitals (source), list of suicide attacks (source), birthplaces of people named Antoine (source), ||%0A%20%20%20%20%20%20%20%20%20%28%3Fel%20%3C%20%3Fkm*3281%20%26%26%20%3Funit%20%3D%20wd%3AQ3710%29%0A%20%20%20%20%20%20%20||%20%28%3Fel%20%3C%20%3Fkm%20%26%26%20%3Funit%20%3D%20wd%3AQ828224%29%20%29.%20%0A%20%20%3Fp%20wdt%3AP625%20%3Flocation.%0A%20%20optional%20%7B%20%3Fp%20wdt%3AP18%20%3Fimage%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%0A places that are below 10 meters above sea level (source)
 * Newest WikiProjects: Etymology, Knowledge Organization Systems
 * Newest external tools: Navel Gazer (users statement addition counts)
 * Development
 * More groundwork for Commons. We can now save a statement in the new MediaInfo entity type \o/ (Some minor issues still with the demo system but should be solved next week.)
 * Fixed a display issue with description tooltips in recent changes. Thanks Matěj Suchánek! (T89663)
 * Refactored quite some of the sitelinks-related JavaScript code (T127056 and 294687. This may break some existing gadgets and user scripts temporarily.
 * Updated the graphic representing the data model in Wikidata: long, medium, short
 * Fixed problem with editing statements on Wikidata, after last week's deployment (T138974)
 * Started interviews to find user needs and workflows for automated list generation (T139284)
 * Monthly Tasks
 * Hack on one of these.
 * Help develop the next summary here!
 * Contribute to a Showcase item
 * Help translate or proofread pages in your own language!
 * Help merge identical items across Wikimedia projects.
 * Add labels, in your own language(s), for the new properties listed above.

The Signpost: 04 July 2016
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 18:47, 4 July 2016 (UTC)

Wikidata weekly summary #217
Here's your quick overview of what has been happening around Wikidata over the last week.  Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 15:33, 11 July 2016 (UTC)
 * Events/Blogs/Press
 * Connecting OpenStreetMap and Wikidata, blog post by Mapbox
 * Past: office hour on IRC (log)
 * Now: ISMB 2016 Editathon
 * Upcoming: Viquimarató de Wikidata sobre Ramon Llull
 * Upcoming: OpenSym
 * Monitoring the Gender Gap with Wikidata Human Gender Indicators
 * An Empirical Evaluation of Property Recommender Systems for Wikidata and Collaborative Knowledge Bases
 * Mapping street names to Wikidata entities they refer to and enriching OpenStreetMap with linked data
 * Other Noteworthy Stuff
 * The removal of Persondata from the English Wikipedia is completed. There are still much information to migrate to Wikidata at KasparBot's tool.
 * Tour de France data is coming from Wikidata in at least 3 Wikipedias
 * Freebase API will be shut down on August 31
 * TXT Werk is now using Wikidata to identify entities (previously Freebase)
 * Magnus' reference drag and drop script is now a gadget
 * Got an idea for a cool project around Wikidata but need some funding? A project grant might be an option.
 * There are several full PhD/postdoc positions available at TU Dresden with Markus including work on Wikidata
 * Magnus' Wiki Loves Monuments tool now also reads cultural identifiers from Wikidata and was switched to use SPARQL
 * Did you know?
 * Newest properties: archive date, permanent duplicated item, throughput, NAIF ID, point of penalty, Transferred Account Data Interchange Group Code, Estonian Research Portal person ID, bateau d'intérêt patrimonial, Cultural heritage database in Austria ObjektID, Nomisma ID, WikiTree ID, Estonian cultural monument ID, BacDive ID
 * Query examples: timeline of space probes (source), countries with most UNESCO World Heritage Sites (source), places in America named after places in England (source), emergency number by country size (source)
 * Development
 * Working on an infographic to represent the flow of data in Wikidata
 * Work on multi-content revisions in order to be able to store an entity (item, property, mediainfo) and wiki text in the same page (This is needed for Commons) (T107595)
 * Did more interviews with editors as preparation for the work on automated list generation for Wikipedia and co based on Wikidata data
 * Fixed a bug with data parsing in Korean and a few other languages (T139509)
 * Added "non" as a language code for monolingual text values (T137115)
 * Removed display of calendar model for dates with precision of 10 years or larger (T133973)
 * Fixed issues in some of the forms on special pages on mobile (T138413)
 * Disabled PDF export in item and property pages (T136814)
 * Worked on making it possible to have quantities with no bounds set (T115270)
 * Monthly Tasks
 * Hack on one of these.
 * Help develop the next summary here!
 * Contribute to a Showcase item
 * Help translate or proofread pages in your own language!
 * Help merge identical items across Wikimedia projects.
 * Add labels, in your own language(s), for the new properties listed above.

Wikidata weekly summary #218
Here's your quick overview of what has been happening around Wikidata over the last week.  Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 17:06, 18 July 2016 (UTC)
 * Events/Blogs/Press
 * From Damascus to Berlin: A very special internship at Wikimedia Deutschland
 * Wikidata als Universalbibliographie: ein Kommentar
 * First image, good image?
 * Other Noteworthy Stuff
 * Since Pokémon is all the rage at the moment here is a short reminder that we have WikiProject Pokémon for them
 * TIB is looking for a Wikimedian in Residence in the Open Science Lab
 * The code for the Primary Sources Tool has been moved from the Google to the Wikidata organisation on github.
 * The ISCB competition for 2016 has been announced
 * Use Wikipedia “article main images” to find candidate images for Wikidata
 * StrepHit fact extraction agent v.1.1-beta has been released
 * Did you know?
 * Newest properties: GCatholic church ID, GoodReads book ID, QUDT unit ID, Queensland Heritage Register ID, National Library of Wales Archives and Manuscripts, EU River Basin District code, right to vote, GoodReads author ID, title of chess player, BVPH ID
 * Query examples: letters with more than two forms (source), metro stations (source), railway incidents (source), pyramids in Egypt (source), women described as wife and men described as husband (source), neuroinformatics coauthor network (source), nationalities of people with an article in the Bavarian Wikipedia (source), Irish general elections and their winners (source), types of historical monuments (source), Alpine four-thousanders (source), Alpine peaks (source), language statements that point to a country instead of a language (source)
 * Newest database reports: list of people who died on their birthday
 * Development
 * Map layers are coming soon to the Query Service
 * A lot of clean-up under the hood for the user interface
 * More interviews with editors in preparation for automated list generation
 * Fixed a bug where forms on the mobile site looked broken (T138413)
 * More work on Citoid integration for easier reference adding
 * Added Cape Verdean Creole (T127435)
 * Monthly Tasks
 * Hack on one of these.
 * Help develop the next summary here!
 * Contribute to a Showcase item
 * Help translate or proofread pages in your own language!
 * Help merge identical items across Wikimedia projects.
 * Add labels, in your own language(s), for the new properties listed above.

The Signpost: 21 July 2016
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 13:19, 21 July 2016 (UTC)