User talk:Timathom/Archive 1/Archive 22

Wikidata weekly summary #286
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Events/Press/Blogs
 * Upcoming: IRC office hour, November 14th, 19:00 (UTC+2) in the channel #wikimedia-office
 * Review of the WikidataCon by Sean McBirnie (Histropedia)
 * Blogpost on workflow co-documentation with community members during the WikidataCon, by Jan Dittrich
 * Completeness and the Age of Abundance of free tools, in Basque language, by Theklan
 * Report about the first WikidataCon in Hungarian language, by Texaner
 * Report of the WikidataCon 2017 in German, by MB-one
 * Visualising Wikidata on Interactive Timelines using HistropediaJS by Sean McBirnie
 * Wikidata: A growing community behind open data by John Samuel
 * Report about the 2017 WikidataCon in Polish, by Yarl
 * Report about WikidataCon 2017 for WMAM community in Armenian, by Kareyac
 * WikidataCon - my résumé by Ahoerstemeier


 * Other Noteworthy Stuff
 * Wikidata training material and sample SPARQL queries by Geertivp
 * A new version of Unicode CLDR was released, including data about languages from Wikidata
 * research article where Wikidata is used to unify metabolite identifiers: WikiPathways


 * Did you know?


 * Newest properties: vertical depth, describes a project that uses, National Monuments of Namibia Site Reference, CycleBase cyclist ID, California Sports Hall of Fame athlete ID, Formal Public Identifier, IAFD male performer ID, IWRP athlete ID, Wimbledon player ID, Snooker.org ID, albedo, family relationship degree, World Snooker athlete ID, Microsoft Store artist ID, NACE code, Xenopus Anatomical Ontology ID


 * Query examples:
 * [https://query.wikidata.org/#%23defaultView%3ATimeline%0ASELECT%20DISTINCT%20%3Ft%20%3Fvalue%20%20%3FvalueLabel%20%3FrrLabel%20%20%3Frr%20%28SAMPLE%28%3Fimage%29%20as%20%3Fimg%29%0AWHERE%0A%7B%0A%20%20VALUES%20%3Fperson%20%7Bwd%3AQ1512%7D%0A%20%20%7B%3Fperson%20wdt%3AP570%20%3Fdeath%20.%20%0A%20%20%20%3Fperson%20%3Fprop%20%3Ft%20FILTER%20%28datatype%28%3Ft%29%3Dxsd%3AdateTime%29%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29%20.%0A%20%20%20%3Fvalue%20wikibase%3AdirectClaim%20%3Fprop.%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%3Fperson%20%3Fq%20%3Fstatement%20%20FILTER%20regex%20%28STR%28%3Fq%29%2C%22prop%2FP%22%29%20.%20%23exclude%20P%3AdescribedBy%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20.%20%0A%20%20%20%3Fstatement%20%3Fp%20%3Ft%20FILTER%20regex%20%28STR%28%3Fp%29%2C%20%22prop%2Fqualifier%2FP%22%29%20FILTER%20%28datatype%28%3Ft%29%3Dxsd%3AdateTime%29%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29.%0A%20%20%20%3Fstatement%20%3Fr%20%3Fvalue%20FILTER%20regex%20%28STR%28%3Fr%29%2C%22prop%2Fstatement%2F%22%29%20.%0A%20%20%20BIND%28IRI%28CONCAT%28CONCAT%28SUBSTR%28STR%28%3Fr%29%2C1%2C29%29%2C%22direct%2F%22%29%2CSUBSTR%28STR%28%3Fr%29%2C40%29%29%29%20as%20%3Frprop%29%20%0A%20%20%20%3Frr%20wikibase%3AdirectClaim%20%3Frprop%20.%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP18%20%3Fimage%7D%0A%20%20%7D%0A%20%20UNION%20%7B%20%23%20author%20of%20%2F%20creator%20of%0A%20%20%20%3Fvalue%20wdt%3AP50%7Cwdt%3AP98%7Cwdt%3AP655%7Cwdt%3AP1773%7Cwdt%3AP170%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Fvalue%20wdt%3AP571%7Cwdt%3AP577%20%3Ft%20.%20%0A%20%20%20%20%20%20%20%20%20%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29%20%0A%20%20%20%23FILTER%20NOT%20EXISTS%20%7B%3Fvalue%20wdt%3AP629%20%3Fx%20%7D%20%0A%20%20%20FILTER%20NOT%20EXISTS%20%7B%3Fperson%20wdt%3AP800%20%3Fvalue%20%7D%20.%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP1433%20%3Frr%20.%7D%20%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20UNION%20%23Notable%20Works%0A%20%20%7B%0A%20%20%20%3Fperson%20wdt%3AP800%20%3Frr%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20%20wdt%3AP577%7Cwdt%3AP571%7Cwdt%3AP1191%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20%20%20UNION%20%23discoverer%20or%20inventor%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP61%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP575%7Cwdt%3AP571%7Cwdt%3AP585%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20%20UNION%20%23architect%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP84%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP571%7Cwdt%3AP1619%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20UNION%20%23composer%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP86%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP571%7Cwdt%3AP1191%7Cwdt%3AP577%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2C%20fr%2C%20de%22.%20%7D%0A%7D%20GROUP%20BY%20%3Ft%20%3Fvalue%20%3Frr%20%3FrrLabel%20%3FvalueLabel%0AORDER%20BY%20%3Ft%0A%20 Timeline of the works of Robert Louis Stevenson] (source)
 * Canals within 800 kilometres of Glasgow (source)
 * File systems by developer, date, and OS (source)
 * Map of metro stations of Bilbao (source)
 * Highest point of each department of France (source)
 * Newest database reports: properties count by datatype, Mayflower voyage participants, film archives

You can see all open tickets related to Wikidata here.
 * Development
 * Fixed a series of smaller regressions after switching to Cirrus based search backend (T179045, T179061, T179130)
 * Latitudes, longitudes, as well as coordinate precisions have accidentally been exported to RDF as xsd:decimal, and are going to be exported as xsd:double soon (T179228)
 * Continue on refactoring PropertySuggester-python for better maintainability and performance (T179664)
 * Make AffectedPagesFinder take DESCRIPTION_USAGE into account (T176417)
 * Add  area where gadgets and user scripts can safely add indicators instead of directly appending to the value (T95403, d:WD:PC)
 * Accessing  will trigger a deprecation warning, gadgets and user script should use the   hook instead (T169771)
 * Work on caching constraint check results (T179849) and indicating that they are cached (T179844)
 * Work on JSON-LD support in the Purtle library used for exports (379669)


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * 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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 14:36, 13 November 2017 (UTC)

Wikidata weekly summary #287
Wikidata weekly summary #287 Global message delivery/Targets/Wikidata

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


 * Discussions
 * Monolingual language code creation process


 * Events/Press/Blogs
 * Past: IRC office hour (log)
 * Past: Wikidata Lab II, a workshop to teach users how to create lists using Wikidata in São Paulo (images from the event)
 * Upcoming: IRC office hour about Structured Data on Commons, November 21, 18:00 UTC in the channel #wikimedia-office
 * Upcoming: WLM-Wikidata-Editathon 2017 in Berlin, November 24-26
 * Upcoming: Wiki4MediaFreedom edit-a-thon - II edition (with Wikidata track) in Sofia, November 27
 * Upcoming: Wikidata-Hackathon at WikiMUC in Munich, November 30
 * WikidataCon 2017
 * Fünf Jahre Wikidata at Chaosradio
 * "Turning a historical book into a data set"
 * "Creating Wikipedia articles from research data"


 * Other Noteworthy Stuff
 * New tool by Magnus: Wikidata SPARQL Recent Changes - get diffs for all items matching a SPARQL query, for a date range
 * New tool by Magnus: WD edit stats - get edit stats for all items matching a SPARQL query
 * Wikidata coverage for 'place' in OpenStreetMap (as of October 2017)
 * OpenRefine 2.8 was released. Adding columns from Wikidata and importing Wikitables is now possible. Let's write tutorials for it.
 * Mix'n'match now shows for a catalog which user originally imported it and if it is updated regularly (example)
 * A breaking change to the wbcheckconstraints API output format was announced


 * Did you know?
 * Newest properties: CGF athlete ID, OKS athlete ID, Gymn Forum athlete ID, sexually homologous with, Tennis Temple player ID, has listed ingredient, World of O athlete ID, HOO athlete ID, IBTrACS cyclone ID, Collective Biographies of Women ID, Snooker Database player ID, Spider Ontology ID, EThOS thesis ID, EUTA theatre ID, EUTA person ID, Czech Street ID, Survey of Scottish Witchcraft - Trial ID, ChinesePosters artist ID, Bangladesh administrative division code, Douban movie ID, REGINE water system number, UK Parliament thesaurus ID, ABA bird ID, MuIS ID, Survey of Scottish Witchcraft - Person ID, Vermont Sports Hall of Fame athlete ID, Alaska Sports Hall of Fame athlete ID, Radio Radicale person ID, SUNCAT ID, payload mass, Melon album ID, ctext work ID, Mémoire du cyclisme cyclist ID, Prisma ID, Africultures person ID, Africultures movie ID, Scottish Cemetery Kolkata ID
 * Query examples:
 * List of subclasses of Matrices
 * Works of art in which the artists depicts their spouse (source)
 * locations Van Gogh depicted in his paintings (source)
 * Gender split of past Google Doodles (source)
 * Newest database reports: expeditions


 * Development
 * Fixed Commons media suggester not loading all preview thumbnails (T160528)
 * RDF exports can handle entity references to foreign Wikibase repositories now, needed for Structured Data on Commons (T161592)
 * Worked on making statements on Forms editable and persistent (T163724)
 * Worked on fine-grained usage tracking in Wikibase' Lua library (T172914)
 * Worked on caching constraint check results (T179849) and indicating when constraint check results are cached (T179844)
 * Wikibase code base does not use Composer class autoloading any more (T180067) as another step towards getting rid of our own build process and being more in line with the rest of Wikimedia


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * 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 &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 10:29, 21 November 2017 (UTC)

Wikidata weekly summary #288
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Discussions
 * New request for comments: start time / end time vs. publication date of 1st / last episode
 * Proposal to add some order and structure to the various bibliographic corpora we currently have in Wikidata (mailing list post)


 * Events/Press/Blogs
 * Past: IRC office hour about Structured Data on Wikimedia Commons. You can read the log on meta.
 * Upcoming: Wikidata workshop in Prague, December 1st
 * Well structured political data for the whole world: impossible utopia, or Wikidata at its best?
 * Spatial-based Topic Modelling using Wikidata Knowledge Base (in Wikidata as Q43662744)
 * Cleaning BNF identifier in Wikidata by Envlh (in French)
 * Monitoring changes to Wikidata pages of your interest by Egon Willighagen


 * Other Noteworthy Stuff
 * Sandra is co-ordinating an inventory of crucial volunteer tools for Wikimedia Commons, GLAM, and structured data in general. You can provide input and prioritize your favorite tools in this Google spreadsheet.
 * Q43649390 is an item about our concept of "QID"s
 * OpenRefine 2.8 was released. Adding columns from Wikidata and importing Wikitables is now possible.


 * Did you know?


 * Newest properties: type foundry, Accademia della Crusca ID, first appearance, USGHOF athlete ID, Kulturelles Erbe Köln object ID, Städel Museum artist ID, Berlinische Galerie artist ID, Tidal video ID, Tidal track ID, Tidal album ID, Tidal artist ID, HTML entity, Norwegian historical register of persons ID, Merchant Category Code, SS KL Auschwitz Garrison ID, West Australian Football League player ID, Wikidata project, BPH journal ID, SNCZI-IPE reservoir ID, BTO five-letter code, awarded for period, electoral district number, Art Museum of Estonia artwork ID, Art Museum of Estonia artist ID, Japanese Baseball Hall of Fame ID, Basketball-Reference.com WNBA ID, National Collegiate Basketball Hall of Fame ID, IJF ID, SNCZI-IPE dam ID, Indiana Basketball Hall of Fame ID, FAI ID, Canada Games ID, ICRC PoW ID, RA Collections ID, mountain range, Everyone Remembered ID, CNRS research group ID, ARLIMA ID


 * Query examples:
 * People who were Time Person of the Year in two consecutive years (source)
 * Fictional characters “said to be the same as” other fictional characters from the same fictional universe (source)
 * Map of places of birth of deceased sociologists (source)
 * Map of libraries in India (source)
 * [https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Ftrain_station%20%3Fcoordinate_location%20%3Flayer%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22eu%22.%20%7D%0A%20%20%3Ftrain_station%20%28wdt%3AP31%2Fwdt%3AP279%2a%29%20wd%3AQ719456.%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ10862037.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ123955.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ149274.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ2946410.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP81%20wd%3AQ43283383.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ3239365.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP81%20wd%3AQ43283518.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP81%20wd%3AQ43325427.%20%7D%0A%20%20MINUS%20%7B%20%3Ftrain_station%20%28wdt%3AP131%2Fwdt%3AP131%29%20wd%3AQ55180.%20%7D%0A%20%20MINUS%20%7B%20%3Ftrain_station%20%28wdt%3AP131%2Fwdt%3AP131%29%20wd%3AQ55271.%20%7D%0A%20%20%3Ftrain_station%20wdt%3AP625%20%3Fcoordinate_location.%0A%20%20%3Ftrain_station%20wdt%3AP81%20%3Fconnecting_line.%0A%20%20MINUS%20%7B%20%3Fconnecting_line%20wdt%3AP81%20wd%3AQ5852245.%20%7D%0A%20%20MINUS%20%7B%20%3Fconnecting_line%20wdt%3AP81%20wd%3AQ801991.%20%7D%0A%20%20%3Fconnecting_line%20rdfs%3Alabel%20%3Flayer.%0A%20%20FILTER%28%28LANG%28%3Flayer%29%29%20%3D%20%22eu%22%29%0A%7D Train and subway stations in Basque Country] (source)
 * Newest database reports: Decameron editions and translations


 * Development
 * Result views in the Wikidata Query Service UI can now be configured with options (T155973, Special:Diff/580233265/596922582)
 * Worked more on introducing the concept of sub.entities in the APIs in order to make edits to Forms persistent
 * Worked on edit summaries for edits to Forms

You can see all open tickets related to Wikidata here.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * 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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:44, 27 November 2017 (UTC)

Wikidata weekly summary #289
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Events/Press/Blogs
 * Past: Using the Digital to Engage Archival Radio Collections: Part II (Wikidata Workshop), Washington, D.C., November 2, 2017 with Andrew Lih and Alex Stinson
 * Past: Wikidata Clinic (slides) in Washington, D.C., December 1, 2017, with Andrew Lih and Rosie Stephenson-Goodknight
 * Past: Wikikonference in Prague with a Wikidata workshop in Czech and a introduction of Wikidata and its community
 * Wikipedia Weekly audio podcast coverage of Wikidata:
 * Episode 126 - Introduction to Wikidata, with Andrew Lih and Rob Fernandez
 * Episode 127 - WikidataCon 2017 roundtable discussion, with Andrew Lih, Liam Wyatt, Stacy Allison-Cassin, Rosie Stephenson-Goodknight, Rob Fernandez
 * Wikidata as authority linking hub: Connecting RePEc and GND researcher identifiers by Joachim Neubert
 * Importing data into Wikidata - Current challenges and ideas future development by Navino Evans
 * The Wikidata map in November 2017 and what changed during the last four months, by Addshore


 * Other Noteworthy Stuff
 * You can now vote for your favorite proposals on the Community Wishlist Survey. The voting phase is open until December 10th.
 * If you run any functionality on Wikimedia sites that uses queries to the Wikidata Query Service, please add it here (more information)
 * The 600,000,000th edit has been made.
 * The first content made specifically for Wikimedia projects in space has been added to Wikidata (see Close encounters of the Wikipedia kind)
 * The Aaron Swartz Fellowship at OSA, Budapest, Hungary, is open for applications (deadline Dec. 31). The second focus area of the fellowship may be of interest to Wikidata folks.


 * Did you know?


 * Newest properties: set designer, Swedish Musical Heritage composer ID, National Film Board of Canada movie ID, South Dakota Sports Hall of Fame ID, World Rugby Hall of Fame ID, Microsoft Store album ID, date of burial or cremation, Lives of WWI ID, polymer of, monomer of, FAPESP researcher ID, FAPESP institution ID, NIOSH Publication Number, post town, arXiv author ID, CPE athlete ID, Mountain Project ID, National Inventory of Canadian Military Memorials ID, Atomic Heritage Foundation ID, Dreadnought Project page, IWGA athlete ID, Argentinian Historic Heritage ID


 * Query examples:
 * [https://query.wikidata.org/#%23defaultView%3ATimeline%0ASELECT%20DISTINCT%20%3Ft%20%3Fvalue%20%20%3FvalueLabel%20%3FrrLabel%20%20%3Frr%20%28SAMPLE%28%3Fimage%29%20as%20%3Fimg%29%0AWHERE%0A%7B%0A%20%20VALUES%20%3Fperson%20%7Bwd%3AQ1512%7D%0A%20%20%7B%3Fperson%20wdt%3AP570%20%3Fdeath%20.%20%0A%20%20%20%3Fperson%20%3Fprop%20%3Ft%20FILTER%20%28datatype%28%3Ft%29%3Dxsd%3AdateTime%29%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29%20.%0A%20%20%20%3Fvalue%20wikibase%3AdirectClaim%20%3Fprop.%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%3Fperson%20%3Fq%20%3Fstatement%20%20FILTER%20regex%20%28STR%28%3Fq%29%2C%22prop%2FP%22%29%20.%20%23exclude%20P%3AdescribedBy%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20.%20%0A%20%20%20%3Fstatement%20%3Fp%20%3Ft%20FILTER%20regex%20%28STR%28%3Fp%29%2C%20%22prop%2Fqualifier%2FP%22%29%20FILTER%20%28datatype%28%3Ft%29%3Dxsd%3AdateTime%29%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29.%0A%20%20%20%3Fstatement%20%3Fr%20%3Fvalue%20FILTER%20regex%20%28STR%28%3Fr%29%2C%22prop%2Fstatement%2F%22%29%20.%0A%20%20%20BIND%28IRI%28CONCAT%28CONCAT%28SUBSTR%28STR%28%3Fr%29%2C1%2C29%29%2C%22direct%2F%22%29%2CSUBSTR%28STR%28%3Fr%29%2C40%29%29%29%20as%20%3Frprop%29%20%0A%20%20%20%3Frr%20wikibase%3AdirectClaim%20%3Frprop%20.%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP18%20%3Fimage%7D%0A%20%20%7D%0A%20%20UNION%20%7B%20%23%20author%20of%20%2F%20creator%20of%0A%20%20%20%3Fvalue%20wdt%3AP50%7Cwdt%3AP98%7Cwdt%3AP655%7Cwdt%3AP1773%7Cwdt%3AP170%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20.%0A%20%20%20%3Fvalue%20wdt%3AP571%7Cwdt%3AP577%20%3Ft%20.%20%0A%20%20%20%20%20%20%20%20%20%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29%20%0A%20%20%20%23FILTER%20NOT%20EXISTS%20%7B%3Fvalue%20wdt%3AP629%20%3Fx%20%7D%20%0A%20%20%20FILTER%20NOT%20EXISTS%20%7B%3Fperson%20wdt%3AP800%20%3Fvalue%20%7D%20.%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP1433%20%3Frr%20.%7D%20%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20UNION%20%23Notable%20Works%0A%20%20%7B%0A%20%20%20%3Fperson%20wdt%3AP800%20%3Frr%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20%20wdt%3AP577%7Cwdt%3AP571%7Cwdt%3AP1191%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20%20%20UNION%20%23discoverer%20or%20inventor%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP61%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP575%7Cwdt%3AP571%7Cwdt%3AP585%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20%20UNION%20%23architect%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP84%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP571%7Cwdt%3AP1619%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20UNION%20%23composer%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP86%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP571%7Cwdt%3AP1191%7Cwdt%3AP577%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2C%20fr%2C%20de%22.%20%7D%0A%7D%20GROUP%20BY%20%3Ft%20%3Fvalue%20%3Frr%20%3FrrLabel%20%3FvalueLabel%0AORDER%20BY%20%3Ft%0A%20 Timeline for the writer Robert Louis Stephenson] (source)
 * Movies with Bud Spencer and Terence Hill (source)
 * Photographers born before the inception of the earliest photograph (source)
 * Newest WikiProjects: Stolpersteine, Jasmerah
 * Newest database reports: Q5 with identical P18


 * Development
 * Wikidata will get dedicated database resources, and go read-only for 30 minutes on 9th January 2018 (T181645)
 * There were no RDF dumps last week due to problems generating them, investigation is still going on (T181385)
 * Improved the threshold for ORES on Wikidata (T180450)
 * Working on fixing a regression after a change in MediaWiki core that makes edit links show up on diff pages (T181807)
 * More work on persistent editing of statements on Forms of a Lexeme (specifically T180467)
 * Improved size of the diff that we sent to Wikipedia and co for changes happening on Wikidata. This is one more needed step towards only showing meaningful edits in the watchlists and recent changes there. (T113468)

You can see all open tickets related to Wikidata here.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * 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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 16:31, 4 December 2017 (UTC)

Wikidata weekly summary #290
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Events/Press/Blogs
 * Incoming: Wikidata workshop in Rennes, France, December 12th
 * Incoming:Next Structured Commons IRC office hour will be on Tuesday, February 13, 2018, at 18:00 UTC.
 * Past: Tech-talk about knowledge technologies, featuring Wikidata, DBpedia, and Histropedia at Jakarta Digital Valley, Jakarta, Indonesia on Dec 8, 2017. Slides are available at Slideshare link.
 * My vision of a possible strategy. How could we change Wikidata’s core infrastructure to be able to scale better in the future? by ChristianKl.
 * Using WikiData as a multi-lingual multi-dialectal dictionary for Arabic dialects - conference paper
 * WikiCite 2017 report by Dario Taborelli and the organization team


 * Other Noteworthy Stuff
 * Structured Data on Commons: Participate in this survey to help the team understand which tools and functionalities are most important to the Commons and Wikidata communities
 * QuickStatements now has a CSV-like import function (under "import commands")
 * wikidata-cli now support dynamic SPARQL requests using JS files
 * New wikidata-sdk function: wdk.getSitelinkUrl, a function to easily build URLs from Wikidata API sitelinks data
 * Musik Lovers (de) is a project created during Coding da Vinci 2017 and reuses data from Wikidata about composers played in the Koncerthaus of Berlin


 * Did you know?


 * Newest properties: premiere type, name of the character role, Bechdel Test Movie List ID, Iowa Sports Hall of Fame ID, DORIS ID, Online Books Page author ID, ICTV virus genome composition, EK number, identity of object in context, Museum of Fine Arts, Boston object ID, squadron embarked, South Australian Football Hall of Fame inductee ID, trophy awarded, Württembergische Kirchengeschichte person ID, Merkelstiftung person ID, National Library of Brazil ID, AUSNUT 2011–13 Food Group ID, DVV player ID, UniProt journal ID, WAFL FootyFacts ID, watershed, Encyclopedia of Modern Ukraine ID, LKL player ID, LACMA ID, Art Institute of Chicago artwork ID, Queensland Australian Football Hall of Fame inductee ID


 * Query examples:
 * Place of birth of author with pages on the French Wikisource (source)
 * Number of movies passing or failing the Bechdel test by year (source)
 * 100 of the earliest 1000 works created by women on Wikidata with an image on Commons (source)
 * Chemical entities, whom discovered them, and when (source)
 * Sister-city and twin-city relationships of the largest cities (source)
 * Cast age at date of film publication (source)
 * Male saints that are the most used to name French cities after them (source)


 * Development
 * Add anchors to Special:ListDatatypes (T181371)
 * Data Types library has been integrated to Wikibase (T180454)
 * Investigate on the slow problems encountered on Wikidata (T182322)

You can see all open tickets related to Wikidata here.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * 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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 16:06, 11 December 2017 (UTC)

Books and Bytes - Issue 25
 The Wikipedia Library <span style="font-size: 2em; font-family: Copperplate, 'Copperplate Gothic Light', serif">Books & Bytes

Issue 25, October – November 2017

<div style = "margin-top: 1.5em; border: 3px solid #ae8c55; border-radius: .5em; padding: 1em 1.5em; font-size: .9em"> Arabic, Korean and French versions of Books & Bytes are now available in meta! Read the full newsletter Sent by MediaWiki message delivery on behalf of The Wikipedia Library team --MediaWiki message delivery (talk) 18:57, 15 December 2017 (UTC)
 * OAWiki & #1Lib1Ref
 * User Group update
 * Global branches update
 * Spotlight: Research libraries and Wikimedia
 * Bytes in brief

Wikidata weekly summary #291
<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: Mapping and improving the data import process


 * Events/Press/Blogs
 * Upcoming: Introduction to Wikidata for local OpenStreetMap community & others, Riga, Latvia, December 19th
 * Upcoming: 34th Chaos Communication Congress, 27-30 December, Leipzig, Germany. The Wikidata team will be there
 * Wikidata in Collections: Building a Universal Language for Connecting GLAM Catalogs
 * A purposeful #strategy for #Wikidata
 * WikidataCon: Giving more people more access to more knowledge by Peter Kraker
 * Review of the Global Legislative Openness Week by MySociety


 * Other Noteworthy Stuff
 * A script to add links to Wikidata on Twitter by Envlh
 * Resolver can now open an item in tools/third-party sites listed on Q43649390#3303, using the  attribute - for example https://tools.wmflabs.org/wikidata-todo/resolver.php?prop=P496&value=0000-0003-4402-5296&project=scholia
 * New edition of the Structured Data on Commons newsletter


 * Did you know?


 * Newest properties: Wiki Aves bird ID, DACS ID, SAN ID, reservoir, CPDOC ID, Musée d'Orsay artwork ID, Coflein ID, The Numbers person ID, Wikimedia import URL, Flathub ID, partition type identifier, partition table type, ESCO Occupation ID, Welsh assembly ID, BSD Portal athlete ID, identity of subject in context, location of first performance, representation of, RCR number, ESCO skill ID, Philadelphia Museum of Art ID, Colorado Sports Hall of Fame ID, Welsh Chapels ID, photosphere image, Estonian Football Association team ID, The Peerage person ID, FoodEx2 code, Sherpa Juliet ID, Indian Financial System Code


 * Query examples:
 * [https://query.wikidata.org/#%23%20this%20query%20identifies%20the%20date-weekday%20cominations%20for%20when%20disasters%20happened%0A%23%20eg%20%22Tuesday%2012th%22%0A%23%20original%20by%20Mat%C4%9Bj%20Such%C3%A1nek%20%26%20Larske%20-%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FWikidata%3ARequest_a_query%23Disasters_starting_on_Friday_13%0A%0ASELECT%20%28%3Fq%20AS%20%3FDate%29%20%28SUM%28%3Fmon%29%20AS%20%3FMon%29%20%28SUM%28%3Ftue%29%20AS%20%3FTue%29%20%28SUM%28%3Fwed%29%20AS%20%3FWed%29%20%28SUM%28%3Fthu%29%20AS%20%3FThu%29%20%28SUM%28%3Ffri%29%20AS%20%3FFri%29%20%28SUM%28%3Fsat%29%20AS%20%3FSat%29%20%28SUM%28%3Fsun%29%20AS%20%3FSun%29%20%20%28COUNT%28%3Fstart_time%29%20AS%20%3FTot%29%20%20WHERE%20%7B%0A%20%7B%20%0A%20%20%3Fdisaster%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ3839081%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP580%20%3Fstart_time_stm%20.%20%20%20%20%20%20%20%20%20%20%23%20find%20the%20date%20multi-day%20disasters%20started%0A%20%20%3Fstart_time_stm%20ps%3AP580%20%3Fstart_time%20.%0A%20%20%3Fstart_time_stm%20psv%3AP580%20%3Fstart_time_node%20.%0A%20%20%3Fstart_time_node%20wikibase%3AtimePrecision%20%3Ftp%20.%20FILTER%28%3Ftp%3D11%29%20%0A%20%7D%0A%20UNION%20%0A%20%7B%0A%20%20%3Fdisaster%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ3839081%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP585%20%3Fstart_time_stm%20.%20%20%20%20%20%20%20%20%20%20%23%20find%20all%20those%20which%20have%20%22point%20in%20time%22%20%28ie%20one-day%20events%29%0A%20%20%3Fstart_time_stm%20ps%3AP585%20%3Fstart_time%20.%0A%20%20%3Fstart_time_stm%20psv%3AP585%20%3Fstart_time_node%20.%0A%20%20%3Fstart_time_node%20wikibase%3AtimePrecision%20%3Ftp%20.%20FILTER%28%3Ftp%3D11%29%20%0A%20%7D%0A%20%20%23%20this%20beautiful%20bit%20of%20code%20finds%20all%20the%20relevant%20days%20of%20the%20week%0A%20%20%23%20using%20https%3A%2F%2Fcs.wikipedia.org%2Fwiki%2FAlgoritmus_pro_v%25C3%25BDpo%25C4%258Det_dne_v_t%25C3%25BDdnu%23Zeller%25C5%25AFv_algoritmus%0A%20%20BIND%28%20DAY%28%20%3Fstart_time%20%29%20AS%20%3Fq%20%29%20.%0A%20%20BIND%28%20MONTH%28%20%3Fstart_time%20%29%20%2B%20IF%28%20MONTH%28%20%3Fstart_time%20%29%20%3C%203%2C%2012%2C%200%20%29%20AS%20%3Fm%20%29%20.%0A%20%20BIND%28%20YEAR%28%20%3Fstart_time%20%29%20-%20IF%28%20MONTH%28%20%3Fstart_time%20%29%20%3C%203%2C%201%2C%200%20%29%20AS%20%3F_year%20%29%20.%0A%20%20BIND%28%20%3F_year%20-%20FLOOR%28%20%3F_year%20%2F%20100%20%29%20%2a%20100%20AS%20%3FK%20%29%20.%20%23%20modulo%0A%20%20BIND%28%20FLOOR%28%20YEAR%28%20%3Fstart_time%20%29%20%2F%20100%20%29%20AS%20%3FJ%20%29%20.%0A%20%20BIND%28%20%3Fq%20%2B%20FLOOR%28%2013%20%2a%20%28%20%3Fm%20%2B%201%20%29%20%2F%205%20%29%20%2B%20%3FK%20%2B%20FLOOR%28%20%3FK%20%2F%204%20%29%20%2B%20FLOOR%28%20%3FJ%20%2F%204%20%29%20-%202%20%2a%20%3FJ%20AS%20%3F_h%20%29%20.%0A%20%20BIND%28%20%3F_h%20-%20FLOOR%28%20%3F_h%20%2F%207%20%29%20%2a%207%20AS%20%3Fweekday%29%20.%20%23%20modulo%2C%200%20is%20Saturday%0A%20%20BIND%28IF%28%3Fweekday%3D2%2C1%2C0%29%20AS%20%3Fmon%29%0A%20%20BIND%28IF%28%3Fweekday%3D3%2C1%2C0%29%20AS%20%3Ftue%29%0A%20%20BIND%28IF%28%3Fweekday%3D4%2C1%2C0%29%20AS%20%3Fwed%29%0A%20%20BIND%28IF%28%3Fweekday%3D5%2C1%2C0%29%20AS%20%3Fthu%29%0A%20%20BIND%28IF%28%3Fweekday%3D6%2C1%2C0%29%20AS%20%3Ffri%29%0A%20%20BIND%28IF%28%3Fweekday%3D0%2C1%2C0%29%20AS%20%3Fsat%29%0A%20%20BIND%28IF%28%3Fweekday%3D1%2C1%2C0%29%20AS%20%3Fsun%29%0A%7D%0AGROUP%20BY%20%3Fq%0AORDER%20BY%20%3FDate Number of disasters by date and day of the week] (source)
 * Map with buildings by Brazilian architect Oscar Niemeyer (source)
 * Properties most used for “no value” statements/qualifiers/references (source)
 * Scientific papers with an animal credited as co-author (source)
 * Image grid of what different cryptocurrencies are named after (source)
 * Newest WikiProjects: Narration
 * Newest database reports: Brigata del Decameron


 * Development
 * Additional languages for monolingual values got approved by the language committee: ami (Amis), bnn (Bunun), fos (Siraya), ppu (Papora / Hoanya), pwn (Paiwan), pyu (Puyuma), ssf (Thao), trv (Seediq / Taroko), uun (Pazeh) (see 374052, T144272)
 * More work on caching constraint results so we can enable the constraints checks for all logged-in users by default
 * Fixed a bug when edit links showed up in diff views (T181807)
 * Final step towards being able to store statements on Forms of a Lexeme
 * Disabled RDF support for Lexemes as the mapping isn't defined yet (T182660)
 * Adding some more smart tracking for Lua usage so we better know which properties from an item are used on a Wikipedia article even when the whole item is loaded (T179923)

You can see all open tickets related to Wikidata here.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * 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 &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:53, 18 December 2017 (UTC)