User talk:Jianhui67/Archive March 2016

Wikidata weekly summary #199
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) 20:40, 7 March 2016 (UTC)
 * Events/Blogs/Press
 * Oscars 2016: Movies that got the most attention on Wikipedia (followup with most famous cats)
 * Statements per item
 * Other Noteworthy Stuff
 * COOL-WD has been announced to help assess the completeness of various parts of the knowledge base
 * You can apply for a grant as part of the Inspire Campaign around the topic of content review and curation
 * Wikimedia was accepted for Google Summer of Code. If you're a student this can be your chance to work on Wikidata code this summer.
 * A catalog of Uruguayan authors has been added to Mix'n'match
 * Listeria bot now has experimental support for references (example)
 * Self-portraits of women through the ages, powered by Wikidata
 * Did you know?
 * Newest properties: Québec cultural heritage directory people identifier, grammatical option indicates, Statistics Indonesia language code, Statistics Indonesia ethnicity code, village code of Indonesia, has phoneme, INSEE departement code, INSEE region code, Australian Wetlands Database Directory of Important Wetlands Reference Code, distance from Earth, J. Paul Getty Museum object id, BabelNet id, Baltisches Biographisches Lexikon digital ID, studied by, studies, admissible rule in, UCSC Genome Browser assembly ID, measures, National-Football-Teams.com player ID, number of out of school children, Twitter hashtag, uncertainty corresponds to, Saros cycle of eclipse, contact times of eclipse, repealed by, amended by, ECHA InfoCard ID, global-warming potential
 * Query example: [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%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%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3FpositionLabel%20%3Fas%20%3Fstart%20%3Fend%20%3Fdays%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ5%20.%0A%20%20%3Fitem%20p%3AP39%20%3Fposition_statement%20.%0A%20%20%3Fposition_statement%20v%3AP39%20%3Fposition%20.%0A%20%20%3Fposition%20wdt%3AP279*%20wd%3AQ15135541%20.%0A%20%20%3Fposition_statement%20pq%3AP580%20%3Fstart%20FILTER%20(%3Fstart%20%3E%3D%20%221815-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime)%20.%0A%20%20OPTIONAL%20%7B%20%3Fposition_statement%20pq%3AP582%20%3Fx%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fposition_statement%20pq%3AP794%20%3Fast%20.%0A%20%20%20%20%3Fast%20rdfs%3Alabel%20%3Fas%20filter%20(lang(%3Fas)%20%3D%20%22en%22)%20.%0A%20%20%7D%0A%20%20bind(if(bound(%3Fx)%2C%20%3Fx%2C%20NOW)%20as%20%3Fend%20)%0A%20%20BIND(FLOOR(%3Fend%20-%20%3Fstart)%20as%20%3Fdays)%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%0A%7D%20ORDER%20BY%20DESC(%3Fdays)%20%3FitemLabel French heads of government by length of service], Metro stations in Paris
 * Development
 * Lucie and Charlie handed in their Bachelor theses on the Article Placeholder and Editing Wikidata from Wikipedia. Work on both topics will continue. We'll publish both theses soon. A big congrats to both of them!
 * More work on the first prototype for Commons support (T125822)
 * Continued working on improving language support for monolingual text and labels/descriptions/aliases (T125066)
 * Conversion of properties from string to external identifier datatype is ongoing
 * Experimenting with putting query results on a map in query.wikidata.org (earthquakes, ski resorts)
 * 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!
 * Add labels, in your own language(s), for the new properties listed above.

The Signpost: 02 March 2016
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 01:00, 8 March 2016 (UTC)

The Signpost: 09 March 2016

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

Wikidata weekly summary #200
Wikidata weekly summary #186

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) 12:00, 15 March 2016 (UTC)
 * Events/Blogs/Press
 * Upcoming: WikiArabia
 * Upcoming: Wikimedia Hackathon
 * Upcoming: digikult.se
 * Wikidata Tour Down-Under
 * Open culture session at Open Belgium
 * Other Noteworthy Stuff
 * Coming to Wikimania? Consider submitting a Wikidata related poster, training or discussion! Deadline is on the 20th.
 * Wikidata has passed the milestone of 1 Billion Datapoints (Triples) on Wednesday, 9th of March.
 * Wikidata Graph Builder now supports arbitrary SPARQL queries (example)
 * ESWC 2016 has a new Wikidata Bonus Challenge
 * Playing with Wikidata in BigQuery
 * There will be server maintenance work next week on all Wikimedia servers that will prevent editing for a short time.
 * Wikidata external ID resolver now uses SPARQL and supports lookup of properties via English name (fragment)
 * iSpecies now has multilingual summaries and links to Wikidata (example)
 * Awarder lets you add awards to a biographical item, or use the Wikipedia text of the award to add all recipients]
 * A new version of the Wikidata nuclide chart is online
 * Did you know?
 * Newest properties: thickness, World Heritage criteria (2005), Valencian Property of Local Relevance id, BookBrainz creator ID, PlayStation ID, ČSFD person ID, Kinopoisk person ID, Kinopoisk film ID, Hockeydb.com player ID, Eurohockey.com player ID, Geni.com profile ID, block size, serial number, Gram staining, culture, maximum gradient, Latvian Olympic Committee athlete ID
 * Query examples: [http://yasgui.org/#query=SELECT+%3FstateLabel+(COUNT(%3Fitem)+as+%3Fcnt)+%7B%0A%09%3Fitem+wdt%3AP31%2Fwdt%3AP279*+wd%3AQ33506+.%0A%09%3Fstate+wdt%3AP31+wd%3AQ35657+.%0A%09%3Fitem+wdt%3AP131*+%3Fstate+.%0A%09SERVICE+wikibase%3Alabel+%7B+bd%3AserviceParam+wikibase%3Alanguage+%22en%22++%7D++++%0A%7D%0AGROUP+BY+%3FstateLabel&contentTypeConstruct=text%2Fturtle&contentTypeSelect=application%2Fsparql-results%2Bjson&endpoint=https%3A%2F%2Fquery.wikidata.org%2Fsparql&requestMethod=GET&tabTitle=Query&headers=%7B%7D&outputFormat=gchart&outputSettings=%7B%22chartConfig%22%3A%7B%22options%22%3A%7B%22hAxis%22%3A%7B%22useFormatFromData%22%3Atrue%2C%22viewWindow%22%3A%7B%22max%22%3Anull%2C%22min%22%3Anull%7D%2C%22minValue%22%3Anull%2C%22maxValue%22%3Anull%7D%2C%22vAxes%22%3A%5B%7B%22useFormatFromData%22%3Atrue%2C%22viewWindow%22%3A%7B%22max%22%3Anull%2C%22min%22%3Anull%7D%2C%22minValue%22%3Anull%2C%22maxValue%22%3Anull%7D%2C%7B%22useFormatFromData%22%3Atrue%2C%22viewWindow%22%3A%7B%22max%22%3Anull%2C%22min%22%3Anull%7D%2C%22minValue%22%3Anull%2C%22maxValue%22%3Anull%7D%5D%2C%22displayMode%22%3A%22regions%22%2C%22booleanRole%22%3A%22certainty%22%2C%22colors%22%3A%5B%22%23f9cb9c%22%2C%22%23ffe599%22%2C%22%23b6d7a8%22%5D%2C%22defaultColor%22%3A%22%23f5f5f5%22%2C%22width%22%3A%22100%25%22%2C%22height%22%3A%22100%25%22%2C%22region%22%3A%22US%22%2C%22resolution%22%3A%22provinces%22%7D%2C%22state%22%3A%7B%7D%2C%22view%22%3A%7B%7D%2C%22isDefaultVisualization%22%3Afalse%2C%22chartType%22%3A%22GeoChart%22%2C%22containerId%22%3A%22yasq_qqpsgffguswqbnzmpldi_gchartWrapper%22%7D%2C%22motionChartState%22%3Anull%7D Number of museums by U. S. state on map], Film directors ranked by number of sitelinks multiplied by their number of films, all museums in Barcelona with coordinates, women mushers, women scientists, women artists, air accidents, Twitter accounts of biologists, torture devices, [https://query.wikidata.org/#SELECT%20DISTINCT%0A%20%20%3Fitem%0A%20%20(SAMPLE%20(%3FtitleL)%20AS%20%3Ftitle)%0A%20%20(group_concat(distinct%20%3FcreatorL%20%3B%20separator%20%3D%20%22%2C%20%22)%20as%20%3Fcreator)%0A%20%20(group_concat(distinct%20%3FgenreL%20%3B%20separator%20%3D%20%22%2C%20%22)%20as%20%3Fgenre)%0A%20%20(group_concat(distinct%20%3FplaceL%20%3B%20separator%20%3D%20%22%2C%20%22)%20as%20%3Fplace)%0A%20%20(group_concat(distinct%20%3Farr%20%3B%20separator%20%3D%20%22%2C%20%22)%20as%20%3Farrondissement)%0A%20%20(SAMPLE%20(%3Fimg)%20AS%20%3Fimage)%0A%20%20(SAMPLE%20(%3Fcoord)%20AS%20%3Fcoordinates)%0A%7B%0A%20%20SELECT%20%3Fitem%20%3FtitleL%20%3FcreatorL%20%3FgenreL%20%3FplaceL%20%3Farr%20%3Fimg%20%3Fcoord%0A%20%20WHERE%20%7B%0A%20%20%20%20%23%20selecting%20items...%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20items%20in%20Paris...%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP131%20wd%3AQ90%20.%0A%20%20%20%20%7D%20UNION%20%7B%0A%20%20%20%20%20%20%23%20...or%20in%20an%20arrondissement%20of%20Paris%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP131%2Fwdt%3AP131*%20wd%3AQ90%20.%0A%20%20%20%20%7D%0A%20%20%20%20%23%20genre%3A%20public%20art%0A%20%20%20%20%3Fitem%20wdt%3AP136%20wd%3AQ557141%20.%0A%20%20%20%20%0A%20%20%20%20%23%20creators%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP170%20%3Fc.%0A%20%20%20%20%20%20%3Fc%20rdfs%3Alabel%20%3FcreatorL%20filter%20(lang(%3FcreatorL)%20%3D%20%22fr%22)%20.%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23genre%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP136%20%3Fg%20.%0A%20%20%20%20%20%20%20%20FILTER%20(%20STR(%3Fg)%20!%3D%20'http%3A%2F%2Fwww.wikidata.org%2Fentity%2FQ557141')%20%0A%20%20%20%20%20%20%7D%20UNION%20%7B%0A%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP31%20%3Fg%20.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%3Fg%20rdfs%3Alabel%20%3FgenreL%20filter%20(lang(%3FgenreL)%20%3D%20%22fr%22)%20.%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20place%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP276%20%3Fp%20.%0A%20%20%20%20%20%20%3Fp%20rdfs%3Alabel%20%3FplaceL%20filter%20(lang(%3FplaceL)%20%3D%20%22fr%22)%20.%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20arrondissement%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP131%20%3Fa%20.%0A%20%20%20%20%20%20%3Fa%20wdt%3AP131%20wd%3AQ90%20.%0A%20%20%20%20%20%20%3Fa%20rdfs%3Alabel%20%3FarrL%20filter%20(lang(%3FarrL)%20%3D%20%22fr%22).%0A%20%20%20%20%20%20BIND(REPLACE(%3FarrL%2C%20'%5E(%5B0-9%5D%2B).*%24'%2C%20%22%241%22%2C%20%22si%22)%20AS%20%3Farr)%20%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20image%0A%20%20%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP18%20%20%3Fimg.%7D%0A%20%20%20%20%23%20coordinates%0A%20%20%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP625%20%3Fcoord.%7D%0A%20%20%20%20%23%20title%0A%20%20%20%20OPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FtitleL%20filter%20(lang(%3FtitleL)%20%3D%20%22fr%22)%20.%7D%0A%20%20%7D%20ORDER%20BY%20xsd%3Ainteger(%3Farr)%20%3FtitleL%20%3FgenreL%20%3FcreateurL%20%3FlieuL%0A%7D%0AGROUP%20BY%20%3Fitem%0AORDER%20BY%20xsd%3Ainteger(REPLACE(%3Farrondissement%2C'%5E(%5B0-9%5D%2B)%2C.*%24'%2C%20%22%241%22%2C%20%22si%22))%20%3Fplace%20%3Ftitle%0A%0A public art in Paris], Locations of Pablo Picasso works
 * Development
 * We reduced the loading time of items significantly. Enjoy a faster Wikidata :) Wikidata item loading time.png
 * Wikidata Query GUI now supports maps. Check it out with one of the example queries above. (Select Map under Display results menu).
 * Pywikibot now has SPARQL endpoint support.
 * We worked on getting the first pieces of Commons support on a test system. Nothing shiny to see yet but we're making progress.
 * Converted more identifier to the new identifier datatype. Still some to go but 450 properties have been converted by now.
 * Updated the data that generates suggestions when adding a new statement
 * 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!
 * Add labels, in your own language(s), for the new properties listed above.

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

Wikidata weekly summary #201
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) 11:50, 21 March 2016 (UTC)
 * Discussions
 * New request for comments: Reforming the property creation process
 * Events/Blogs/Press
 * Past: Color History with the Smithsonian!
 * Past: Accessibility Edit-a-Thon at the DC Public Library
 * Past: Admin meetup of the German-language Wikipedia
 * Automatic Extraction of Knowledge from Biomedical literature
 * Identifying problematic statements in Wikidata via multi-level modeling theory
 * Wikidata as a semantic framework for the Gene Wiki initiative
 * Adding disclosures to Wikidata with Bioclipse
 * Other Noteworthy Stuff
 * Dutch language Wikipedia has a consistently low number of articles unconnected to Wikidata: Duplicity statistics for nlwiki
 * MusicBrainz now uses Wikidata to fetch images for their entities
 * The query service is now linked in the sidebar
 * Mix'n'match has new catalogs among them TED speakers
 * Maarten made some reports to make it easier to connect paintings on Wikidata with images on Wikimedia Commons
 * Did you know?
 * Newest properties: BBFC rating, German tax authority ID, ISO 9362 SWIFT/BIC code, DNF person ID, PASE ID, MetroLyrics ID, MEK ID, Companies House ID, Site of Special Scientific Interest (England) ID, ISO 15924 numeric code, Hungarian company ID, SHOWA ID, formatterURL for Wikidata ID, World Heritage criteria (2005), TED talk ID, TED topic ID, TED speaker ID
 * Query examples: distribution of public art by place
 * Development
 * The query service now has Ctrl+enter as a shortcut to run a query
 * Started working on improving input for geocoordinates and dates (changing the advanced settings)
 * Worked on database performance improvements for the client (Wikipedia and co) (T125838)
 * Experimenting with arbitrary access for Wikimedia Commons on http://commons.wikimedia.beta.wmflabs.org
 * Converted more identifiers from string datatype to identifier datatype
 * Worked on improved localization of dates that are very far in the past or future (T127820)
 * Fixed undo actions going through abuse filter (T126861)
 * Fixed issues in the query service with Internet Explorer 11
 * Improved query service display on small screens
 * Improved autocompletion in the query service
 * Fixed a bug with an add button for qualifiers being shown when it shouldn't (T128317)
 * Further work on Wikimedia Commons support (Special Pages, API)
 * You can now add a default view to a query like here. This then shows the defined view (map, table, image grid) when executing the query.
 * 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!
 * Add labels, in your own language(s), for the new properties listed above.

The Signpost: 23 March 2016
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 03:24, 27 March 2016 (UTC)

Wikidata weekly summary #202
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:21, 28 March 2016 (UTC)
 * Events/Blogs/Press
 * Past: Wikidata intro at the École de Bibliothécaires Documentalistes (slides)
 * Upcoming: IRC office hour
 * Upcoming: MediaWiki hackathon
 * Migrating pKa data from DrugMet to Wikidata
 * Other Noteworthy Stuff
 * A little Easter present for the WikiVerse from Magnus
 * The page for institutions, companies, etc who want to donate data to Wikidata has been reworked and expanded by John and Jens
 * WMDE is looking for a product management intern to work with Lydia
 * Arbitrary access for Commons is getting ready and needs testing
 * Did you know?
 * Newest properties: next crossing downstream, next crossing upstream, SOATO ID, Google Knowledge Graph identifier, has parts of the class, discontinued date, variability of property value, corresponding template, Datahub page, alcohol by volume, units sold, tier 1 capital ratio (CETI), consumption rate per capita, target interest rate, topographic prominence, topographic isolation, Scoville grade, EU transparency register ID, FIFA World Ranking, Estyn ID, partnership with, CRICOS Provider Code, interested in, Cycling Quotient url (mens team), Cycling Quotient identifier (races for men), source of material, mirTarBase ID, mean lifetime, Carnegie Classification of Institutions of Higher Education, FedCup player ID, Davis Cup player ID, Swimrankings.net swimmer ID, Filmportal ID, TV.com ID, RARS rating, Minkultury Film ID, number of parts of a work of art, model, geography, place of detention, Turner Classic Movies film ID, cost of damage
 * Query examples: Library and Information Science journals, number of statements backed by a reference with a DOI
 * Development
 * You see that you can now show labels/descriptions/aliases for all languages that have been added to an item by clicking "more languages"
 * Preparation for arbitrary access on Commons
 * Getting ready for the hackathon in Israel
 * More work on making the extended input for geocoordinates and dates less complicated to understand
 * Worked on making scrolling of large items less laggy
 * Made the query service map visualization no longer show coordinates that are not on earth
 * Fixed a bug where the removal of a sitelink couldn't be done (T129450)
 * Query service no longer restores previous query as requested
 * Fixed a bug where adding a statement would leave a stray "add qualifier" link (T128317)
 * 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!
 * Add labels, in your own language(s), for the new properties listed above.