User talk:Mike Peel/Archive 21

This Month in GLAM: September 2016
About This Month in GLAM · Subscribe/Unsubscribe · Global message delivery · Romaine 15:01, 13 October 2016 (UTC)

The Signpost: 14 October 2016
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 19:29, 14 October 2016 (UTC)

Infobox telescope
To save you experimenting, I've made a fork of Template:Infobox telescope at Template:Infobox telescope/optin. That uses WikidataIB for most of the fields and therefore has WikidataIB functionality for those fields. At the article level, fetching Wikidata is enabled by adding the parameter ALL to the article infobox. I've make a demo for you at LIGO. Feel free to revert when you're happy with how it works.

As a bonus, I've implemented extra functionality. By adding the parameter yes to the article infobox, it will only fetch Wikidata values that are sourced (and sourced to something other than Wikipedia). You can test that, of course, at LIGO and see the shorter infobox resulting.

I still need to incorporate handling units into Module:WikidataIB in order to usurp all of the functionality of Module:Wikidata, but that's a job for another day. The two modules inter-operate well, so no problem in the meantime. What do you think? --RexxS (talk) 15:22, 10 October 2016 (UTC)
 * Thanks RexxS. I'll test the new version soon - sorry that I haven't had the time to do so yet. Thanks. Mike Peel (talk) 20:23, 14 October 2016 (UTC)

Wikidata weekly summary #231
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) 21:56, 17 October 2016 (UTC)
 * Events/Blogs/Press
 * Upcoming: Connected Data London meetup with Navino Evans
 * Upcoming: Andy Mabbett & Liam Wyatt speaking about GLAM-Wiki (including Wikidata) at Muzeum Cyfrowe in Warsaw, 19 October.
 * Upcoming: Andy Mabbett speaking about Wikidata & running a GLAM-Wiki workshop at SFK 16 ("Software Freedom Kosova Conference") in Pristina, 21-23 October.
 * Past: CCBWIKI
 * Other Noteworthy Stuff
 * World Spider Catalog has been added to Mix'n'match
 * Mix’n’match can now limit auto-matches to instances of a specific item and its subclasses
 * Sitelinks for the new Livvi-Karelian Wikipedia (olowiki) can be added
 * There is now a "userbox" for Wikidatans wishing to mark Wikidata's fourth birthday on their user pages
 * myMuseum was created at the hack4heritage hackathon and won a prize
 * Did you know?
 * Newest properties: DRÚSOP ID, code, encoding, BALaT image ID, DocCheck Flexikon De ID, DocCheck Flexikon En ID, biography at the Landtag of Mecklenburg-Vorpommern, Cellosaurus ID, World Spider Catalog ID, Squash Info ID, MSC ID, Yahoo! Japan Talent Database ID, Bandcamp artist ID, French National Assembly Lobbyist ID, BanQ author ID, statistical leader, Sandbox-Monolingual text II
 * Query examples:
 * [https://query.wikidata.org/#%23%20First%20Nobel%20Prize%20winner%20born%20after%20Alfred%20Nobel%E2%80%99s%20death%0A%23%20Nobel%20Prize%20data%20seems%20to%20be%20a%20bit%20messy%20right%20now%2C%20so%20we%20cover%20three%20different%20ways%20to%20represent%20%E2%80%9Cawardee%20got%20prize%20on%20date%20X%E2%80%9D%20%E2%80%93%20hopefully%20that%E2%80%99s%20enough%E2%80%A6%0ASELECT%20%3Fawardee%20%3FawardeeLabel%20%3FawardeeBorn%20%3Fawarded%20%3FprizeLabel%20WHERE%20%7B%0A%20%20wd%3AQ23810%20wdt%3AP570%20%3FnobelDied.%0A%20%20%3Fawardee%20wdt%3AP31%20wd%3AQ5%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3FawardeeBorn.%0A%20%20%3Fprize%20wdt%3AP279%20wd%3AQ7191.%0A%20%20FILTER%28%3FawardeeBorn%20%3E%20%3FnobelDied%29.%0A%20%20%7B%0A%20%20%20%20%23%20awardee%20has%20award%20received%3A%20nobel%20prize%20with%20point%20in%20time%0A%20%20%20%20%3Fawardee%20p%3AP166%20%5B%0A%20%20%20%20%20%20ps%3AP166%2Fwdt%3AP31%3F%20%3Fprize%3B%0A%20%20%20%20%20%20pq%3AP585%20%3Fawarded%0A%20%20%20%20%5D.%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20%23%20nobel%20prize%20has%20winner%3A%20awardee%20with%20point%20in%20time%0A%20%20%20%20%3Fprize%20p%3AP1346%20%5B%0A%20%20%20%20%20%20ps%3AP1346%20%3Fawardee%3B%0A%20%20%20%20%20%20pq%3AP585%20%3Fawarded%0A%20%20%20%20%5D.%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20%23%20awardee%20has%20award%20received%3A%20%3Cyear%3E%20nobel%20prize%0A%20%20%20%20%3Fawardee%20wdt%3AP166%20%3FyearPrize.%0A%20%20%20%20%3FyearPrize%20wdt%3AP31%20%3Fprize%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP585%20%3Fawarded.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fawarded%0ALIMIT%201 first Nobel Prize winner who was born after Alfred Nobel’s death] (source)
 * streets in Paris named after doctors (source)
 * international land tripoints (source)
 * national flags depicting stars or constellations (source)
 * national flags with inscriptions (source)
 * people who died the furthest away from where they were born (source)
 * closest pairs of capitals (of UN member states, <500km) (source)
 * [https://query.wikidata.org/#%23%20People%20who%20received%20military%20decorations%20from%20two%20different%20countries%0ASELECT%0A%3Fperson%20%3FpersonLabel%0A%28SAMPLE%28CONCAT%28%3Faward1Label%2C%20%22%20%28%22%2C%20%3Fcountry1Label%2C%20%22%29%22%29%29%20AS%20%3FfirstAward%29%0A%28SAMPLE%28CONCAT%28%3Faward2Label%2C%20%22%20%28%22%2C%20%3Fcountry2Label%2C%20%22%29%22%29%29%20AS%20%3FsecondAward%29%0AWHERE%20%7B%0A%20%20%3Fperson%20wdt%3AP31%20wd%3AQ5%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP166%20%3Faward1%2C%20%3Faward2.%0A%20%20wd%3AQ1788716%20%5E%28wdt%3AP31%7Cwdt%3AP279%29%2a%20%3Faward1%2C%20%3Faward2.%0A%20%20FILTER%28%3Faward1%20%21%3D%20%3Faward2%29.%0A%20%20%3Faward1%20wdt%3AP17%20%3Fcountry1.%0A%20%20%3Faward2%20wdt%3AP17%20%3Fcountry2.%0A%20%20FILTER%28%3Fcountry1%20%21%3D%20%3Fcountry2%29.%0A%20%20FILTER%28%28%3Fcountry1%20%21%3D%20wd%3AQ159%20%7C%7C%20%3Fcountry2%20%21%3D%20wd%3AQ15180%29%20%26%26%20%28%3Fcountry1%20%21%3D%20wd%3AQ15180%20%7C%7C%20%3Fcountry2%20%21%3D%20wd%3AQ159%29%29.%0A%20%20%0A%20%20OPTIONAL%20%7B%20%3Fperson%20rdfs%3Alabel%20%3FpersonLabel.%20FILTER%28LANG%28%3FpersonLabel%29%20%3D%20%22en%22%29.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Faward1%20rdfs%3Alabel%20%3Faward1Label.%20FILTER%28LANG%28%3Faward1Label%29%20%3D%20%22en%22%29.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Faward2%20rdfs%3Alabel%20%3Faward2Label.%20FILTER%28LANG%28%3Faward2Label%29%20%3D%20%22en%22%29.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fcountry1%20rdfs%3Alabel%20%3Fcountry1Label.%20FILTER%28LANG%28%3Fcountry1Label%29%20%3D%20%22en%22%29.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fcountry2%20rdfs%3Alabel%20%3Fcountry2Label.%20FILTER%28LANG%28%3Fcountry2Label%29%20%3D%20%22en%22%29.%20%7D%0A%7D%0AGROUP%20BY%20%3Fperson%20%3FpersonLabel%0ALIMIT%2050 people who received military decorations from two different countries] (source)
 * volcanoes and earthquakes (source)
 * [https://query.wikidata.org/#SELECT%20%3Fratio%20%28COUNT%28%3Fitem%29%20AS%20%3Fcount%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ3305213%20.%0A%0A%20%20%3Fitem%20p%3AP2048%2Fpsv%3AP2048%20%5B%0A%20%20%20%20wikibase%3AquantityAmount%20%3FbaseHeight%3B%0A%20%20%20%20wikibase%3AquantityUnit%20%5B%0A%20%20%20%20%20%20p%3AP2370%2Fpsv%3AP2370%20%5B%0A%20%20%20%20%20%20%20%20wikibase%3AquantityAmount%20%3FunitHeight%3B%0A%20%20%20%20%20%20%20%20wikibase%3AquantityUnit%20wd%3AQ11573%0A%20%20%20%20%20%20%5D%0A%20%20%20%20%5D%0A%20%20%5D.%0A%20%20BIND%28%3FbaseHeight%20%2a%20%3FunitHeight%20AS%20%3Fheight%29.%0A%0A%20%20%3Fitem%20p%3AP2049%2Fpsv%3AP2049%20%5B%0A%20%20%20%20wikibase%3AquantityAmount%20%3FbaseWidth%3B%0A%20%20%20%20wikibase%3AquantityUnit%20%5B%0A%20%20%20%20%20%20p%3AP2370%2Fpsv%3AP2370%20%5B%0A%20%20%20%20%20%20%20%20wikibase%3AquantityAmount%20%3FunitWidth%3B%0A%20%20%20%20%20%20%20%20wikibase%3AquantityUnit%20wd%3AQ11573%0A%20%20%20%20%20%20%5D%0A%20%20%20%20%5D%0A%20%20%5D.%0A%20%20BIND%28%3FbaseWidth%20%2a%20%3FunitWidth%20AS%20%3Fwidth%29.%0A%20%20%0A%20%20BIND%28%3Fheight%20%2F%20%3Fwidth%20AS%20%3Fr%29%20.%0A%20%20%0A%20%20BIND%28IF%28%3Fr%3C0.5%2C%22%3C%200.5%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C0.6%2C%220.5%20-%200.6%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C0.7%2C%220.6%20-%200.7%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C0.8%2C%220.7%20-%200.8%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C0.9%2C%220.8%20-%200.9%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C1.0%2C%220.9%20-%201.0%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C1.1%2C%221.0%20-%201.1%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C1.2%2C%221.1%20-%201.2%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C1.3%2C%221.2%20-%201.3%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C1.4%2C%221.3%20-%201.4%22%2C%0A%20%20%20%20%20%20%20IF%28%3Fr%3C1.5%2C%221.4%20-%201.5%22%2C%20%22%3E%201.5%22%29%29%29%29%29%29%29%29%29%29%29%20AS%20%3Fratio%29%20.%0A%0A%7D%0AGROUP%20BY%20%3Fratio%0AORDER%20BY%20DESC%28%3Fcount%29%0A height/width ratios of paintings] (source)
 * birthplaces of Members of the European Parliament (source)
 * birthplaces of US Senators (source)
 * New template: d:Template:Poland properties. Please add labels in your own languages, and consider making a similar template for your country or region.
 * Development
 * Worked further on automatic linking of pages between Wiktionary language editions
 * Worked further on making it possible to use Wikidata's items and properties to describe files on Commons
 * Reviewed error messages and made them easier to understand
 * Added tooltips in some places in the UI to make them more understandable (e.g. ranks, special values)
 * Made the loading animation clearer in embedded query results (T148042)
 * Making it possible to paste the full URL of an image on Commons into image properties (T147917)
 * Worked on a small birthday present
 * Fixed run button not being reenabled after some queries (T147114)
 * More work on better parser function and Lua functions that return formatted values (T142940)
 * Undoing the last edit to an item will now show a undo summary, not a restore one (T147631) Thanks Matěj!
 * Lule Sami and Pite Sami are now supported languages in Wikidata (T146707)
 * Brainstormed about how to make it easier to write queries without knowing SPARQL
 * Fixed a bug with spaces in language codes in queries (T147729)
 * 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.
 * Comment on property proposals: all open proposals - proposals needing attention

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

 Wikidata celebrates its 4th anniversary on October 29th. Around this date, a lot of events will happen online and offline.
 * Wikidata's birthday is coming!

Birthday events

Editors all around the world organize meetups to celebrate the birthday. You can join one of them or create an event in your own town!
 * San Francisco (USA), October 26th
 * Torino (Italy), October 26th
 * Tokyo (Japan), October 28th
 * Paris (France), October 29th
 * Utrecht (NL), October 29th
 * Berlin (Germany), November 4th
 * Rennes (France), November 5th

Online

A lot of surprises, stories and presents will be shared between October 29th and November 4th. Check the project chat or the mailing-list every day to see what happens!

You can also participate by posting a story (more info here), a tweet with #WikidataBirthday, let a message or a present on the birthday page.

If you're participating to Wikidata's birthday, you can add this template to your user page.


 * Events/Press/Blogs
 * Wikidata workshops in Paris : every month, Wikimédia France and editors organize a workshop about Wikidata and related tools. Check out the schedule
 * Upcoming: Ladies that FOSS October 29th in Berlin, organized by Lucie and Julia from the Wikidata team


 * Other Noteworthy Stuff
 * WikiCite 2016 report


 * Did you know?


 * Newest properties: Third-party formatter URL, Open Media Database film ID, broadcast by, musical conductor, Student register of the University of Helsinki 1640–1852 ID, Belgian Senate person ID, Flemish Parliament person ID, DRÚSOP ID


 * Query examples:
 * places of birth of living US senators (compare with last week's)
 * Wikidata map of filming locations (source)
 * Streets in Paris named after a physician (source)
 * Moons of trans-Neptunian objects (source)
 * Newest WikiProjects: Chess


 * Development
 * Fixed a rounding error in the geo coordinate formatter (see [//github.com/DataValues/Geo/pull/78 GitHub]). Thanks, 0x686578!
 * Improvements to technical error messages, e.g. "illegal value" when editing a Commons media statement (T141880).
 * Continued working on a new parser function to get rich, formatted statements.
 * Continued working on making entity usage information visible to users.

You can see all open tickets related to Wikidata here.


 * 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.
 * Comment on property proposals: all open proposals - proposals needing attention

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 10:37, 24 October 2016 (UTC)

Wikidata weekly summary #233
Here's your quick overview of what has been happening around Wikidata over the last week.  The birthday week started and already a lot of events happened, presents have been shared, stories have been told! Here's what you may have missed:
 * Wikidata's birthday: presents, stories and events
 * a word from the development team by Lydia
 * a new version of the map showing all the Wikidata items with geolocalisation, by Addshore, who explains how he generated it in a blog post
 * The 4th birthday logo by Incabell
 * A new release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on has made working with Wikidata a lot easier for Google Sheets users, by Tomayac
 * A guide to SPARQL and the Wikidata Query Service, by TweetsFactsAndQueries
 * Four new types of charts for the Query Service: line chart, bar chart, scatter chart and area chart (read more and try examples in the documentation) by Jonas
 * , a new parser function is currently in development with better features that you can try on beta by the Wikidata dev team and volunteers
 * Search field added in Scholia, a tool to create scholarship profiles, by fnielsen
 * 10 cool queries for Wikidata that will blow your mind. Number 7 will shock you, by Jens and Cornelius
 * 4 years of Wikidata by Stryn
 * A lot of people celebrating and posting pictures on Twitter or on Commons!

The birthday party is not finished yet, every day until November 4th you will discover new presents and stories. Follow the project chat or the mailing-list or #Wikidatabirthday to get the news!


 * Events/Press/Blogs
 * Wikidata birthday in Kanpur (India), November 3rd
 * Wikidata birthday in Berlin (Germany), November 4th
 * Wikidata birthday in Rennes (France), November 5th
 * OKlab Berlin hacknights, October 31st and November 7th
 * Pidapalooza, Reykjavik, November 9-10
 * Past: Ladies that FOSS (livetweet report)


 * Did you know?


 * Newest properties: SummitPost ID, lib.reviews ID, Galiciana Author ID, ICAA rating, KINENOTE person ID, NGS pumping station ID, third-party formatter URL, Open Media Database film ID, broadcast by


 * Query examples:
 * Deities and their families
 * [https://query.wikidata.org/#PREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20v%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20q%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20psv%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2Fvalue%2F%3E%0A%0A%20%20%20%23%20%20Query%20to%20find%20the%20most-frequently%20represented%0A%20%20%20%23%20%20variants%20of%20the%20male%20given%20name%20%3Ftgt_name%0A%20%20%20%23%20%20when%20%3Ftgt_name%20%3D%20Q2958359%0A%20%20%20%23%20%20Query%20generated%20by%20%5B%5BTemplate%3ANameVariantStatsM%5D%5D%0A%0ASELECT%20%3Fname%20%3FnameLabel%20%3Fcount%20WHERE%20%7B%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22%20.%20%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fname%20%28COUNT%28DISTINCT%20%3Fa%29%20AS%20%3Fcount%29%20WHERE%20%7B%0A%20%20%20%20%20%20%20%7B%20%0A%20%20%20%20%20%20%20%20%20SELECT%20DISTINCT%20%3Fname%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%7B%3Fname%20wdt%3AP460%2A%20wd%3AQ15235674%20%7D%20UNION%20%7B%20wd%3AQ15235674%20wdt%3AP460%2A%20%3Fname%7D%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fname%20wdt%3AP31%20wd%3AQ12308941%20.%0A%20%20%20%20%20%20%20%20%20%7D%20LIMIT%20100%0A%20%20%20%20%20%20%20%7D%20.%0A%20%20%20%20%20%20%20%3Fa%20wdt%3AP735%20%3Fname%20.%0A%20%20%20%20%20%20%20%3Fa%20wdt%3AP31%20wd%3AQ5%20.%0A%20%20%20%20%7D%20GROUP%20BY%20%3Fname%0A%20%20%7D%20.%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%20%20%7D%0A%7D%0A%23%20HAVING%20%28%3Fcount%20%3E%201%29%0AORDER%20BY%20DESC%28%3Fcount%29%20%3FitemLabel%0A Most frequently variants of given names] (source)
 * Cheese made with cow milk (source)
 * Abandoned villages in the Czech Republic (source)
 * Newest WikiProjects: WikiProject Informatics: File Formats
 * Newest database reports: Liam Neeson filmography


 * Development
 * We proposed a meaningful initial order for the statementSort gadget (T147062)
 * Commons media file properties now support pasting full Wikimedia Commons URLs (T147917)
 * Added distinct hover tooltips to rank and snak type selectors, as well as some of the "add" buttons (T139356)
 * Our concept base URI will be exposed as part of the [#action=query&meta=siteinfo&siprop=general ] API (T143910). Thanks, user Lokal Profil!
 * Progress on the  API module to query entity usage information (T145880)
 * Progress on the new parser function for rich, formatted statements (T142940)
 * Released [//github.com/wmde/WikibaseDataModel/releases/tag/6.2.0 Wikibase DataModel 6.2.0]
 * Released [//phabricator.wikimedia.org/diffusion/GDVV/browse/master/RELEASE-NOTES.md ValueView 0.18.0]

You can see all open tickets related to Wikidata here.


 * 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.
 * Comment on property proposals: all open proposals - proposals needing attention

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:06, 31 October 2016 (UTC)

The Signpost: 4 November 2016
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 17:51, 4 November 2016 (UTC)

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

Thanks to everyone who celebrated the birthday by organizing or attending to an event, letting a message on Wikidata or on the social networks, writing a story or creating a present!
 * Fourth birthday: thank you!

Here's the list of the birthday presents from the community and development team:
 * d:Template:User Wikidata birthday 2016 (Pigsonthewing)
 * A new version of the map showing all the Wikidata items with geolocalisation (Addshore)
 * Wikidata's 4th birthday logo (Incabell)
 * A new release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on has made working with Wikidata a lot easier for Google Sheets users. (Tomayac)
 * A guide to SPARQL and the Wikidata Query Service (TweetsFactsAndQueries)
 * Four new types of charts for the Query Service: line chart, bar chart, scatter chart and area chart! Read more and try examples in the documentation (Jonas)
 * , a new parser function is currently in development with better features: try it here! (Thiemo, Wikidata dev team and volunteers)
 * Search field added in Scholia, a tool to create scholarship profiles (fnielsen)
 * Technical documentation about Wikibase for PHP and JS scripts (Ladsgroup and Jonas)
 * new feature for the graph view in the Query Service: it can now browse the properties of items. see in the video (Jonas)
 * graph builder tool for the query service to create and export graphs (demo video) (Jonas, [[d:user:Smalyshev (WMF)|Smalyshev)
 * d:Module:PropertyPath and d:Template:Show Path Items (TomT0m)
 * Everything is connected, a knowledge game based on Wikidata and Commons (list of levels) (Denny)


 * Discussions
 * New request for comments: Editing descriptions from Wikipedia Android app


 * Events/Press/Blogs
 * Histropedia: “The power of data visualisation combined with free knowledge” on WMF's blog
 * Presenting the Wikidata Human Gender Indicators by Max Klein
 * How the world’s first Wikidata Visiting Scholar created linked open data for five thousand works of art on WMF's blog


 * Other Noteworthy Stuff
 * Music in Canada at 150 Wikipedia Project, a multifaceted campaign to increase the amount and quality of content about Canadian music in Wikipedia and Wikidata
 * 400,000,000th edit was made.
 * The average amount of statements per item became higher than five and is still growing.
 * Wikidata entities usage on Wikimedia projects


 * Did you know?


 * Newest properties: DRÚSOP ID, code, encoding, BALaT image ID, DocCheck Flexikon De ID, DocCheck Flexikon En ID, biography at the Landtag of Mecklenburg-Vorpommern, Cellosaurus ID, World Spider Catalog ID, Squash Info ID, MSC ID, Yahoo! Japan Talent Database ID, Bandcamp artist ID, French National Assembly Lobbyist ID, BanQ author ID, statistical leader, Sandbox-Monolingual text II


 * Query examples:
 * Continents on Wikidata (All eleven of them) (source)
 * Sluices on the river "Vilaine" in Brittany (source)
 * Countries with most cities named after saints (source)
 * Disney characters who share name with their actors (source)
 * 204 items that cite themselves (source)
 * [https://query.wikidata.org/#%23%20statements%20with%20two%20references%20where%20one%20source%20cites%20the%20other%0ASELECT%20%3Fsubject%20%3FsubjectLabel%20%3FpropertyLabel%20%3FobjectLabel%20%3Fsource1Label%20%3Fsource2Label%0AWITH%20%7B%20%23%20subquery%20that%20actually%20finds%20the%20statements%20and%20sources%20%28written%20as%20named%20subquery%20to%20ensure%20it%E2%80%99s%20only%20run%20once%2C%20independently%20of%20the%20rest%20of%20the%20query%3B%20see%20https%3A%2F%2Fwiki.blazegraph.com%2Fwiki%2Findex.php%2FNamedSubquery%29%0A%20%20SELECT%20%3Fstatement%20%3Fsource1%20%3Fsource2%20WHERE%20%7B%0A%20%20%20%20%3Fstatement%20prov%3AwasDerivedFrom%2Fpr%3AP248%20%3Fsource1%2C%20%3Fsource2.%20%23%20statement%20has%20two%20%E2%80%9Cstated%20in%E2%80%9D%20references%0A%20%20%20%20%3Fsource1%20wdt%3AP2860%20%3Fsource2.%20%23%20first%20source%20cites%20the%20second%20one%0A%20%20%20%20FILTER%28%3Fsource1%20%21%3D%20%3Fsource2%29.%20%23%20apparently%20some%20items%20cite%20themselves%3F%0A%20%20%7D%0A%7D%20AS%20%25results%20WHERE%20%7B%0A%20%20INCLUDE%20%25results.%0A%20%20%23%20auxiliary%20query%20to%20find%20the%20subject%2C%20property%20and%20object%20of%20the%20statement%2C%20as%20well%20as%20labels%0A%20%20%3Fsubject%20%3Fp%20%3Fstatement.%0A%20%20%3Fstatement%20%3Fps%20%3Fobject.%0A%20%20%3Fproperty%20a%20wikibase%3AProperty%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Aclaim%20%3Fp%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AstatementProperty%20%3Fps.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D Statements with two references where one source cites the other] (source)


 * Development
 * Stable interface policy update
 * More work on federation in order to be able to use Wikidata's items and properties to describe media files on Wikimedia Commons in the future (T149580)
 * Worked on first version of Lexeme entity type (T148139)
 * Worked more on linking values in Lua and the property parser function instead of just returning the label (T142940) You can test it here: https://de.wikipedia.beta.wmflabs.org/wiki/Statements
 * Improved map layer colors in the query service (T148022)
 * Improved size of map markers in the query service (T148496)
 * Upcoming: quantity changes
 * Worked more on automated sitelinks for Wiktionary (T987) Test system is coming in the next days.

You can see all open tickets related to Wikidata here.


 * 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.
 * Comment on property proposals: all open proposals - proposals needing attention

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:08, 7 November 2016 (UTC)

This Month in GLAM: October 2016
About This Month in GLAM · Subscribe/Unsubscribe · Global message delivery · Romaine 03:09, 10 November 2016 (UTC)

Two-Factor Authentication now available for admins
Hello,

Please note that TOTP based two-factor authentication is now available for all administrators. In light of the recent compromised accounts, you are encouraged to add this additional layer of security to your account. It may be enabled on your preferences page in the "User profile" tab under the "Basic information" section. For basic instructions on how to enable two-factor authentication, please see the developing help page for additional information. Important: Be sure to record the two-factor authentication key and the single use keys. If you lose your two factor authentication and do not have the keys, it's possible that your account will not be recoverable. Furthermore, you are encouraged to utilize a unique password and two-factor authentication for the email account associated with your Wikimedia account. This measure will assist in safeguarding your account from malicious password resets. Comments, questions, and concerns may be directed to the thread on the administrators' noticeboard. MediaWiki message delivery (talk) 20:33, 12 November 2016 (UTC)

Wikidata weekly summary #235
<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;"> This is the Wikidata summary of the week before 2016-11-12.


 * Discussions
 * Current request for comments: Editing descriptions from Wikipedia Android app


 * Events/Press/Blogs
 * Wikidata and the Chain of Death, by Karl Beecher
 * Scaling multilingual name tags with Wikidata OpenStreetMap contributor blog post
 * Wikidata and Persistent Identifiers was presented at PIDapalooza November 9th.
 * Wikidata in OpenStreetMap
 * Wikidata and the Semantic Web of Food


 * Other Noteworthy Stuff
 * A new Wikidata PageRank dataset has been published. The dataset was computed in August 2016 and provides PageRank scores for 10,364,840 Wikidata entities.
 * Due to a possible hack, please consider resetting your passwords.


 * Did you know?


 * Newest properties: generation time, hazard on site,	ACM Digital Library event ID,	ACM Digital Library citation ID,	HGVS nomenclature,	Supermodels.nl ID,	CIViC variant ID,	wurvoc.org measure ID,	Réserves Naturelles de France ID,	World Waterfall Database ID,	Ylioppilasmatrikkeli 1853–1899 ID,	ID petit-patrimoine.com,	opponent during disputation,	Vlindernet ID,	male form of label,	board member,	Patrimonio Inmueble de Andalucía ID,	BDI ID,	ICCF ID,	chesstempo ID,	365chess player ID,	plan image,	muscle action,	SummitPost ID,	lib.reviews ID,	Galiciana Author ID,	ICAA rating,	KINENOTE person ID,	NGS pumping station ID,	third-party formatter URL,	Open Media Database film ID,	broadcast by,	musical conductor,	Student register of the University of Helsinki 1640–1852 ID,	Belgian Senate person ID,	Flemish Parliament person ID


 * Query examples:
 * Map of educational institutes from all over the world (source)
 * Current US Supreme Court justices by their date of birth (source)
 * Death dates of people with Wikidata items (source)
 * French towns that a street in Paris is name after(source)
 * Statements with “reason for deprecation” rank that aren’t deprecated(source)


 * Development
 * More work on federation (T76007)
 * Worked on first basic version of Lexeme entity type for Wiktionary support (T148139)
 * Test system for automated language links for Wiktionary (T987)
 * Analysed feedback prototype for editing on Wikipedia in order to refine it
 * Worked on mapping Commons workflows and needs
 * Analysed queries used with Listeria
 * More work on making ArticlePlaceholder pages indexeable by search engines (T117693)
 * More work on enabling translations from existing articles in other languages on ArticlePlaceholder pages (T124036)
 * Link to local articles in ArticlePlaceholders (T113955)
 * Fix for bug that prevented editing (T150401)
 * Experimented with improvements for property suggestions (T132839)

You can see all open tickets related to Wikidata here.


 * 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.
 * Comment on property proposals: all open proposals - proposals needing attention

<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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 17:20, 14 November 2016 (UTC)

A new user right for New Page Patrollers
Hi.

A new user group, New Page Reviewer, has been created in a move to greatly improve the standard of new page patrolling. The user right can be granted by any admin at PERM. It is highly recommended that admins look beyond the simple numerical threshold and satisfy themselves that the candidates have the required skills of communication and an advanced knowledge of notability and deletion. Admins are automatically included in this user right.

It is anticipated that this user right will significantly reduce the work load of admins who patrol the performance of the patrollers. However,due to the complexity of the rollout, some rights may have been accorded that may later need to be withdrawn, so some help will still be needed to some extent when discovering wrongly applied deletion tags or inappropriate pages that escape the attention of less experienced reviewers, and above all, hasty and bitey tagging for maintenance. User warnings are available here but very often a friendly custom message works best.

If you have any questions about this user right, don't hesitate to join us at WT:NPR. (Sent to all admins) .MediaWiki message delivery (talk) 13:47, 15 November 2016 (UTC)

Wikidata weekly summary #236
<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: How to make new languages enabled on Wikidata


 * Events/Press/Blogs
 * Problematizing and Addressing the Article as Concept Assumption in Wikipedia (Q27827559)
 * schema.org, Wikidata, Knowledge Graph: strands of the modern semantic web by Dan Scott


 * Other Noteworthy Stuff
 * Parlement & Politiek ID (P1749) has been completed in Mix'n'match. Over 5000 politicians from the Netherlands (and also Belgium) now have a link to this resource
 * Two policies about abandoned tools on Tool Labs are currently voted on
 * The Community Wishlist Survey is now closed and the vote phase will start on November 28. Here's the category for Wikidata
 * Data import hub and Data import guide: feel free to give feedbacks on these documents!


 * Did you know?


 * Newest properties: musipedia tune ID, Adult Film Database person ID, WHO international non-proprietary names ID, designed to carry, National Library of Greece ID, PermID, HKMDb person ID, RxNorm CUI, Vote Smart ID, legislation.gov.uk ID, significant person, Kvikmyndir person ID, Kvikmyndir film ID, World Surf League ID, Encyclopedia of Surfing ID


 * Query examples:
 * Occupations of women, with French female-form labels (source, database report)
 * Documents with most signatories (source)
 * [https://query.wikidata.org/#%23%20Wikidata%20map%20of%20James%20Bond%20filming%20locations%0A%23%20SPARQL%20by%20Jura1%2C%202016-11-05%0A%23defaultView%3AMap%0ASELECT%20%09%3Ffilm%20%28CONCAT%28str%28%3FactorLabel%29%2C%20%22%20%2Fin%2F%20%22%2C%20str%28%3FfilmLabel%29%2C%20%22%20--%20the%20%22%2C%20str%28%3FfilmDescription%29%29%20as%20%3Flayer%29%20%0A%09%09%3Fenwiki_article%09%3Fcoor%09%0A%09%09%3Ffilminglocation%09%3FfilminglocationLabel%0A%7B%09SELECT%20DISTINCT%20%3Ffilm%09%3FfilmLabel%20%3FfilmDescription%20%09%3Fenwiki_article%09%3Fcoor%09%3Ffilminglocation%09%3FfilminglocationLabel%20%3FactorLabel%20%3FpropertyLabel%20%0A%09%7B%0A%20%20%09%3Fstatement%20pq%3AP453%20wd%3AQ2009573%20.%0A%20%20%09%3Ffilm%20p%3AP161%20%3Fstatement%20.%20%3Fstatement%20ps%3AP161%20%3Factor%20.%0A%20%20%09%3Ffilm%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ11424%20.%0A%20%20%09%3Ffilm%20wdt%3AP915%20%3Ffilminglocation%20.%0A%20%20%09%3Ffilminglocation%20wdt%3AP625%20%3Fcoor%20.%20%0A%20%20%20%20filter%20not%20exists%20%7B%20%3Ffilminglocation%20wdt%3AP17%20%3Ffilminglocation%20%7D%20%20%0A%09OPTIONAL%20%7B%20%3Fenwiki_article%20schema%3Aabout%20%3Ffilm%20%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E%20%7D%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%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%3Ffilm%20rdfs%3Alabel%20%3FfilmLabel%20.%20%3Ffilm%20schema%3Adescription%20%3FfilmDescription%20.%20%0A%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%3Ffilminglocation%20rdfs%3Alabel%20%3FfilminglocationLabel%20.%20%3Factor%20rdfs%3Alabel%20%3FactorLabel%20%20%7D%0A%09%7D%0A%7D Filming locations of James Bond films] (source)
 * United States National Historic Landmarks not actually located in the United States (source)
 * Items with VIAF, but no P31/279 (source)
 * Newest database reports: List of Italian language films without articles in Italian Wikipedia


 * Development
 * Unit conversion has been rolled out for the first dimension for a short while now.
 * Undo diffs now utilize language fallbacks for property and item labels (315291). Thanks to Matěj Suchánek!
 * Reworked database schema for Cognate (the extension that will do automatic interwiki links for Wiktionary). It is still waiting for security review before it can be deployed.
 * Worked more on basic version of Lexeme entity type
 * Fixed a bug where the links on action=info where wrong (T149598)
 * Getting close to finishing the groundwork for Federation so that in the future you'll be able to use Wikidata's items and properties to describe files on Commons.
 * Added Innu-aimun as a language for monolingual text values (T151129)
 * Worked on linking to Wikipedia articles in the statements on an ArticlePlaceholder (T113955)
 * ArticlePlaceholder got a button to translate articles via the ContentTranslation extension (T124036)
 * Prepared a bot to fix quantity values after the recent changes to precisions (T142087)
 * Did user interviews for use cases and workflows on Commons
 * Analyzed more Listeria queries in order to figure out steps forward for easier query writing

You can see all open tickets related to Wikidata here.

<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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:07, 21 November 2016 (UTC)
 * Monthly Tasks
 * Hack on one of these.
 * Help write 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.
 * Comment on property proposals: all open proposals - proposals needing attention

The Signpost: 4 November 2016
<div class="hlist" style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;"> * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 09:06, 26 November 2016 (UTC)

Wikidata weekly summary #237
<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
 * Closed request for comments: Semi-automatic Addition of References to Wikidata Statements


 * Events/Press/Blogs
 * Past: Wikidata introduction by Pigsonthewing at DJUK 2016


 * Other Noteworthy Stuff
 * Items without statements is down to 5% for enwiki (source)
 * Wikidata:WikiProject Biographical Identifiers


 * Did you know?


 * Newest properties: Auckland Art Gallery artist ID, Observatoire du Patrimoine Religieux ID, Géopatronyme ID, Prabook ID, GECD film ID, GECD person ID, Enciclopedia Treccani, stereoisomer of, Tennishof ID, operating income, PictoRight ID code, Nobel Prize People Nomination ID, negative prognostic predictor, positive prognostic predictor, negative diagnostic predictor, positive diagnostic predictor, negative therapeutic predictor, positive therapeutic predictor, National Recreation Trails Database ID


 * Query example : List of sovereign state flags by proportion (source)
 * Newest tool: Display the link to Wikiversity in the title of Wikipedia using Wikidata
 * Newest database report: Unique films: film items with a link to a single Wikipedia


 * Development
 * Adding new wikis to interwiki sort order and move sort orders to WMF config. T111023

You can see all open tickets related to Wikidata here.


 * 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.
 * Comment on property proposals: all open proposals - proposals needing attention

<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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 14:54, 28 November 2016 (UTC)