[Wikidata] weekly summary #208

Hey everyone :) Here's your summary of what happened around Wikidata over the past week. Events <https://www.wikidata.org/wiki/Wikidata:Events>/Press/Blogs <https://www.wikidata.org/wiki/Wikidata:Press_coverage> - Past: OpenTechSummit <http://opentechsummit.net/> (slides <https://commons.wikimedia.org/wiki/File:Mining_the_knowledge_of_the_world_with_Wikidata.pdf> ) - Past: CSVConf <http://csvconf.com> - Past: Subscribe7 <https://fahrplan.subscribe.de/sub7/events/196> ( slides <https://docs.google.com/presentation/d/1VF0ml3nWFRsYN-hwRgVfnXGi5w1iQ8CdJ3OKbEJsrVs/edit> ) Other Noteworthy Stuff - Our Main Page <http://wikidata.org> now has a section for popular items to show you what is trending on Wikidata based on several people editing an item over the last few days - More constraint templates <https://www.wikidata.org/wiki/Category:Constraint_templates> now generate SPARQL links - Europeana Art History Challenge <https://www.wikidata.org/wiki/Wikidata:Europeana_Art_History_Challenge> is still going on until the end of the month - Freebase has been shut down <https://groups.google.com/d/msg/freebase-discuss/WEnyO8f7xOQ/VucJKFVhBAAJ> - Wikiversity now has access to the data on Wikidata as well - The 24,000,000th item was created: Q24000000 <https://www.wikidata.org/wiki/Q24000000> - The ArticlePlaceholder <https://www.mediawiki.org/wiki/Extension:ArticlePlaceholder> will go live on the first Wikipedias on Wednesday (Esperanto, Haitian Creole, Neapolitan Wikipedia) - Quora: Why isn't Wikimedia Commons using structured data via Wikidata? <https://www.quora.com/Why-isnt-Wikimedia-Commons-using-structured-data-via-Wikidata/answer/Lydia-Pintscher> - Newest trend on Twitter: annotating <https://twitter.com/WikidataFacts/status/728628300147503104> books <https://twitter.com/ReaderMeter/status/728998057216385024> with Wikidata statements <https://twitter.com/WikidataFacts/status/729053802054193152> ;-) Did you know? - Newest properties <https://www.wikidata.org/wiki/Special:ListProperties>: flower color <https://www.wikidata.org/wiki/Property:P2827>, Megogo ID <https://www.wikidata.org/wiki/Property:P2826>, via <https://www.wikidata.org/wiki/Property:P2825>, Gazetteer of Planetary Nomenclature ID <https://www.wikidata.org/wiki/Property:P2824>, Belgian Football ID <https://www.wikidata.org/wiki/Property:P2823>, by-product of <https://www.wikidata.org/wiki/Property:P2822>, by-product <https://www.wikidata.org/wiki/Property:P2821>, cardinality of this set <https://www.wikidata.org/wiki/Property:P2820>, Yandex.Music album ID <https://www.wikidata.org/wiki/Property:P2819>, Sherdog ID <https://www.wikidata.org/wiki/Property:P2818>, appears in the heritage monument list <https://www.wikidata.org/wiki/Property:P2817>, HowLongToBeat identifier <https://www.wikidata.org/wiki/Property:P2816>, ESR station code <https://www.wikidata.org/wiki/Property:P2815>, P-number <https://www.wikidata.org/wiki/Property:P2814>, mouthpiece <https://www.wikidata.org/wiki/Property:P2813>, MathWorld identifier <https://www.wikidata.org/wiki/Property:P2812>, PGA Tour ID <https://www.wikidata.org/wiki/Property:P2811>, LPGA Tour ID <https://www.wikidata.org/wiki/Property:P2810>, Australasian Pollen and Spore Atlas Code <https://www.wikidata.org/wiki/Property:P2809>, wavelength <https://www.wikidata.org/wiki/Property:P2808>, molar volume <https://www.wikidata.org/wiki/Property:P2807>, vibration <https://www.wikidata.org/wiki/Property:P2806>, goratings ID <https://www.wikidata.org/wiki/Property:P2805>, International Sailing Federation ID <https://www.wikidata.org/wiki/Property:P2804>, Wikidata time precision <https://www.wikidata.org/wiki/Property:P2803>, fleet or registration number <https://www.wikidata.org/wiki/Property:P2802>, FIVB beach volleyball player ID <https://www.wikidata.org/wiki/Property:P2801>, Beach Volleyball Database ID <https://www.wikidata.org/wiki/Property:P2800>, BVMC person ID <https://www.wikidata.org/wiki/Property:P2799> - Query examples: most frequent occupations without a label in a given language <https://query.wikidata.org/#%23Most%20frequent%20occupations%20without%20a%20label%20in%20Latvian%20%28lv%29%0A%23by%20Edgars2007%2FJura1%2C%202016-05-09%0ASELECT%20%3Foccup%20%3FoccupLabel%20%3Fcount%0AWHERE%0A%7B%0A%09%7B%0A%09%09SELECT%20%3Foccup%20%28COUNT%28%3Fperson%29%20as%20%3Fcount%29%0A%09%09WHERE%0A%09%09%7B%0A%09%09%09%3Fperson%20wdt%3AP106%20%3Foccup%0A%09%09%7D%0A%09%09GROUP%20BY%20%3Foccup%0A%09%09ORDER%20BY%20DESC%28%3Fcount%29%0A%09%09LIMIT%201000%0A%09%7D%0A%20%20%09OPTIONAL%20%7B%3Foccup%20rdfs%3Alabel%20%3Flabel1%20%09filter%28lang%28%3Flabel1%29%20%3D%20%22lv%22%29%7D%0A%09FILTER%28%21BOUND%28%3Flabel1%29%29%0A%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Ces%2Cpl%2Cja%2Czh%2Cru%22%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%0ALIMIT%2050>, map of places of birth of economists <https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Fperson%20%3Fname%20%3Fcoord%20%3Fplace%20%3Fbirthplace%20%3Fbirthyear%20WHERE%20%7B%0A%20%20%20%7B%3Fperson%20wdt%3AP106%20wd%3AQ188094%20.%7D%20UNION%20%7B%3Fperson%20wd%3AP101%20wd%3AQ8134.%7D.%20MINUS%20%7B%3Fperson%20wdt%3AP106%20wd%3AQ188094.%20%3Fperson%20wd%3AP101%20wd%3AQ8134.%7D%0A%20%20%20%3Fperson%20wdt%3AP19%20%3Fplace%20.%0A%20%20%20%3Fplace%20wdt%3AP625%20%3Fcoord%20.%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fperson%20wdt%3AP569%20%3Fdob%20.%7D.%0A%09BIND%28YEAR%28%3Fdob%29%20as%20%3Fbirthyear%29.%0A%20%20%20%3Fperson%20rdfs%3Alabel%20%3Fname%20filter%20%28lang%28%3Fname%29%20%3D%20%22en%22%29%0A%20%20%20%3Fplace%20rdfs%3Alabel%20%3Fbirthplace%20filter%20%28lang%28%3Fbirthplace%29%20%3D%20%22en%22%29%0A%7D> (source <https://twitter.com/economics_net/status/727480376193605632>), map of all the paintings for which we know a location with the count per location <https://query.wikidata.org/#%23Map%20of%20all%20the%20paintings%20for%20which%20we%20know%20a%20location%20with%20the%20count%20per%20location%0A%23defaultView%3AMap%0ASELECT%20%3FlocationLabel%20%3Fcoord%20%28count%28*%29%20as%20%3Fcount%29%0AWHERE%20%7B%0A%20%20%20%20%3Fpainting%20wdt%3AP31%20wd%3AQ3305213%20.%20%0A%20%20%20%20%3Fpainting%20wdt%3AP276%20%3Flocation%20.%0A%09%3Flocation%20wdt%3AP625%20%3Fcoord%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%20%20%20%20%20%20%20%0A%7D%0A%20%20%20%20GROUP%20BY%20%3FlocationLabel%20%3Fcoord> (source <https://twitter.com/mdammers/status/727910405637582848>), scientists who have worked together but whose Erdős numbers don’t reflect that <https://query.wikidata.org/#%23%20Finds%20authors%20who%20have%20published%20scientific%20articles%20together%2C%0A%23%20but%20whose%20Erd%C5%91s%20numbers%20are%20more%20than%20one%20apart.%0A%23%20These%20would%20appear%20to%20violate%20the%20definition%20of%20the%20Erd%C5%91s%20number.%0A%0ASELECT%0A%23%20Q%23s%0A%3Fpaper%0A%3Fauthor1%0A%3Fauthor2%0A%23%20title%20%28either%20from%20title%20statement%20or%20label%29%0A%28IF%28BOUND%28%3Ftitle%29%2C%20%3Ftitle%2C%20%3FpaperLabel%29%20AS%20%3Ftitle%29%0A%23%20author%20labels%20%28should%20be%20names%29%20and%20their%20Erd%C5%91s%20numbers%0A%3Fauthor1Label%0A%3Ferd%C5%91s1%0A%3Fauthor2Label%0A%3Ferd%C5%91s2%0A%23%20distance%20between%20Erd%C5%91s%20numbers%0A%3Fdistance%0AWHERE%0A%7B%0A%20%20%23%20paper%2C%20instance%20of%20or%20subclass%20of%20scientific%20article%3B%20also%20has%20two%20authors%0A%20%20%3Fpaper%20wdt%3AP31%2Fwdt%3AP279*%20wd%3AQ13442814%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP50%20%3Fauthor1%2C%20%3Fauthor2.%0A%20%20%23%20if%20it%20has%20a%20title%2C%20we%E2%80%99ll%20grab%20that%20as%20well%2C%20but%20it%E2%80%99s%20also%20okay%20if%20there%E2%80%99s%20no%20title%0A%20%20OPTIONAL%20%7B%20%3Fpaper%20wdt%3AP1476%20%3Ftitle.%20%7D%0A%20%20%23%20grab%20Erd%C5%91s%20numbers%20of%20the%20two%20authors%0A%20%20%3Fauthor1%20wdt%3AP2021%20%3Ferd%C5%91s1.%0A%20%20%3Fauthor2%20wdt%3AP2021%20%3Ferd%C5%91s2.%0A%20%20%23%20introduce%20a%20new%20variable%20for%20the%20difference%20of%20the%20Erd%C5%91s%20numbers%0A%20%20BIND%28%3Ferd%C5%91s2%20-%20%3Ferd%C5%91s1%20AS%20%3Fdistance%29.%0A%20%20%23%20select%20those%20cases%20where%20the%20distance%20is%20%3E%201%0A%20%20%23%20%28note%3A%20by%20*not*%20taking%20the%20absolute%20value%20of%20the%20distance%2C%20we%20avoid%20getting%20duplicated%20cases%20because%20the%20author%20variables%20might%20be%20swapped%29%0A%20%20FILTER%28%3Fdistance%20%3E%201%29.%0A%20%20%23%20get%20*Label%20variables%20automagically%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0A%23%20sort%20by%20distance%20first%20%28descending%29%2C%20then%20by%20first%20author%2C%20then%20by%20second%20author%0AORDER%20BY%20DESC%28%3Fdistance%29%20%3Fauthor1Label%20%3Fauthor2Label> (source <https://twitter.com/WikidataFacts/status/728623992693731328>), members of the French National Assembly born out of France <https://query.wikidata.org/#PREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%20%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3FplaceLabel%20%3FcountryLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP39%20wd%3AQ3044918%20.%0A%20%20%3Fitem%20wdt%3AP19%20%3Fplace%20.%0A%20%20%3Fplace%20wdt%3AP17%20%3Fcountry%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fplace%20wdt%3AP17%20wd%3AQ142%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%22%20.%20%7D%0A%7D%20ORDER%20BY%20%3FcountryLabel%20%3FitemLabel> (source <https://twitter.com/PoulpyWP/status/729048824203886592>), mathematical proofs <https://query.wikidata.org/#SELECT%20%3Fproof%20%3FproofLabel%0AWHERE%0A%7B%0A%20%20%3Fproof%20wdt%3AP31%20wd%3AQ11538.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D> (source <https://twitter.com/WikidataFacts/status/729078702965952513>), items that depict most things <https://query.wikidata.org/#SELECT%20%3Fwork%20%28COUNT%28%3Fdepicted%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%20%20%3Fwork%20wdt%3AP180%20%3Fdepicted.%0A%7D%0AGROUP%20BY%20%3Fwork%0AORDER%20BY%20DESC%28%3Fcount%29%0ALIMIT%2010> (source <https://twitter.com/WikidataFacts/status/728636613182525440>) Development - Finished remaining blockers for deploying the ArticlePlaceholder on the first Wikipedias - More work on initial Commons prototype - Further work on textual representation of SPARQL queries to allow you to read/edit more of an existing query without having to touch SPARQL - Show label instead of URI for globes in coordinate diffs - thanks Ricordisamoa! (phabricator:T110193 <https://phabricator.wikimedia.org/T110193>) - Improve recent changes entries formatting on Wikipedia and co ( phabricator:T52893 <https://phabricator.wikimedia.org/T52893>) - No longer showing a restore link for inaccessible revdel'ed entity revisions - thanks Matěj! (phabricator:T55496 <https://phabricator.wikimedia.org/T55496>) - Investigated and worked around issues with the suggestions for new statements - needs more work (phabricator:T132839 <https://phabricator.wikimedia.org/T132839>) You can see all open tickets related to Wikidata here <https://phabricator.wikimedia.org/maniphest/query/4RotIcw5oINo/#R>. Monthly Tasks - Hack on one of these <https://phabricator.wikimedia.org/maniphest/query/R8GRzX1eH0tb/#R>. - Help develop the next summary here! <https://www.wikidata.org/wiki/Wikidata:Status_updates/Next> - Contribute to a Showcase item <https://www.wikidata.org/wiki/Wikidata:Showcase_items> - Help translate <https://www.wikidata.org/wiki/Special:LanguageStats> or proofread pages in your own language! - Add labels, in your own language(s), for the new properties listed above. Anything to add? Please share! :) Cheers Lydia -- Lydia Pintscher - http://about.me/lydia.pintscher Product Manager for Wikidata Wikimedia Deutschland e.V. Tempelhofer Ufer 23-24 10963 Berlin www.wikimedia.de Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207.