Hello :)
This is the Wikidata summary of the week before 2016-09-10.
Events <https://www.wikidata.org/wiki/Wikidata:Events>/Press/Blogs
<https://www.wikidata.org/wiki/Wikidata:Press_coverage>
- Upcoming: Keynote by Lydia Pintscher at DBpedia conference
<http://wiki.dbpedia.org/meetings/Leipzig2016>, September 15th, Leipzig.
- Upcoming: Wikidata workshop for beginners
<http://www.agendadulibre.org/events/11770>, September 16, Paris
- Upcoming: Semantic MediaWiki Conference
<https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016>, September
28-30, Frankfurt
- Upcoming: Andy Mabbett (User:Pigsonthewing
<https://www.wikidata.org/wiki/User:Pigsonthewing>) & Liam Wyatt (
User:Wittylama <https://www.wikidata.org/wiki/User:Wittylama>) speaking
about GLAM-Wiki (including Wikidata) in Warsaw, 19 October. Details tbc.
- Upcoming: Andy Mabbett (User:Pigsonthewing
<https://www.wikidata.org/wiki/User:Pigsonthewing>) speaking & running
workshop about Wikidata at SFK 16 <http://sfk.flossk.org> ("Software
Freedom Kosova Conference") in Pristina, 21-23 October.
- Research on WikiProject Knowledge Organization Systems
<https://www.wikidata.org/wiki/Wikidata:WikiProject_Knowledge_Organization_Systems>
presented at 15th NKOS workshop at TPDL: *Classification of Knowledge
Organization Systems with Wikidata*: Presentation
<http://dx.doi.org/10.5281/zenodo.61767> and Paper
<http://ceur-ws.org/Vol-1676/paper2.pdf>.
- Being a Volunteer Developer for Wikimedia projects: An Interview with
Tpt
<https://blog.wikimedia.de/2016/09/08/i-dont-have-to-find-tasks-tasks-are-coming-to-me-being-a-volunteer-developer-for-wikimedia-projects-an-interview-with-tpt/>
- Sunday Query: The 200 Oldest Living French Actresses
<https://blog.ash.bzh/sunday-query-the-200-oldest-alive-french-actresses/>,
query tutorial by Harmonia Amanda
- How to prototype Wikidata entities
<https://blog.ash.bzh/prototypage-rapide-dentites-wikidata/> (in French)
by Poulpy
Other Noteworthy Stuff
- We have new graphic material to present Wikidata
<https://commons.wikimedia.org/wiki/Category:Wikidata_information_materials>.
Feel free to use these files in your slides/talks/documents :)
- #SundayQuery on Twitter
<https://twitter.com/search?f=tweets&vertical=default&q=%23SundayQuery&src=typd>:
every Sunday, you can ask for help or advice about SPARQL queries, how to
build or fix it, some SPARQL-ninjas will be there to answer you!
- Researcher? You can participate in the WSDM Cup 2017
<http://www.wsdm-cup-2017.org> challenge and improve Wikidata vandalism
detection
- How to build a query
<https://www.wikidata.org/wiki/Help:SPARQL/Building_a_query/Museums_on_Instagram>
by Pigsonthewing
- Wikipedia gets Map links and Geoshapes service using Wikidata
<https://en.wikipedia.org/wiki/Wikipedia:Village_pump_%28technical%29#Wikipedia_gets_Map_links_and_Geoshapes_service>
Did you know?
- Newest properties
<https://www.wikidata.org/wiki/Special:ListProperties>: Scottish Charity
number <https://www.wikidata.org/wiki/Property:P3163>, Rock Hall of Fame
ID <https://www.wikidata.org/wiki/Property:P3162>, has grammatical mood
<https://www.wikidata.org/wiki/Property:P3161>, Minnesota legislator ID
<https://www.wikidata.org/wiki/Property:P3160>, UGent Memorialis id
<https://www.wikidata.org/wiki/Property:P3159>, enclosure
<https://www.wikidata.org/wiki/Property:P3158>, event distance
<https://www.wikidata.org/wiki/Property:P3157>, Australian Classification
<https://www.wikidata.org/wiki/Property:P3156>, Runeberg book ID
<https://www.wikidata.org/wiki/Property:P3155>, Runeberg author ID
<https://www.wikidata.org/wiki/Property:P3154>, Crossref funder ID
<https://www.wikidata.org/wiki/Property:P3153>, Findsmiley ID
<https://www.wikidata.org/wiki/Property:P3152>, iNaturalist taxon ID
<https://www.wikidata.org/wiki/Property:P3151>, birthday
<https://www.wikidata.org/wiki/Property:P3150>, molecule conformation
<https://www.wikidata.org/wiki/Property:P3149>, repeals
<https://www.wikidata.org/wiki/Property:P3148>, United States Reports ID
<https://www.wikidata.org/wiki/Property:P3147>, CiNetMag person ID
<https://www.wikidata.org/wiki/Property:P3146>, YouTheater ID
<https://www.wikidata.org/wiki/Property:P3145>, elFilm person ID
<https://www.wikidata.org/wiki/Property:P3144>, elFilm film ID
<https://www.wikidata.org/wiki/Property:P3143>, EDb person ID
<https://www.wikidata.org/wiki/Property:P3142>, EDb film ID
<https://www.wikidata.org/wiki/Property:P3141>, SourehCinema person ID
<https://www.wikidata.org/wiki/Property:P3140>, SourehCinema film ID
<https://www.wikidata.org/wiki/Property:P3139>, OFDb ID
<https://www.wikidata.org/wiki/Property:P3138>
- Query examples:
- Posthumous marriages
<https://query.wikidata.org/#%23%20Posthumous%20marriages%0ASELECT%20%3FaliveSpouse%20%3FaliveSpouseLabel%20%3FdeadSpouse%20%3FdeadSpouseLabel%20%3Fdeath%20%3Fmarriage%0AWHERE%0A%7B%0A%20%20%23%20%3FaliveSpouse%20has%20spouse%20%3FdeadSpouse%2C%20with%20qualifier%20start%20time%3A%20%3Fmarriage%0A%20%20%3FaliveSpouse%20p%3AP26%20%5B%20ps%3AP26%20%3FdeadSpouse%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20pqv%3AP580%20%5B%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%20wikibase%3AtimeValue%20%3Fmarriage%3B%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%20wikibase%3AtimePrecision%20%3FmarriagePrecision%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D.%0A%20%20%23%20%3FdeadSpouse%20has%20date%20of%20death%20%3Fdeath%0A%20%20%3FdeadSpouse%20p%3AP570%2Fpsv%3AP570%20%5B%0A%20%20%20%20wikibase%3AtimeValue%20%3Fdeath%3B%0A%20%20%20%20wikibase%3AtimePrecision%20%3FdeathPrecision%0A%20%20%5D.%0A%20%20%23%20%3Fdeath%20prior%20to%20%3Fmarriage%0A%20%20FILTER%28%3Fdeath%20%3C%20%3Fmarriage%29.%0A%20%20%23%20Optional%3A%20remove%20results%20with%20missing%20precision%20%E2%80%93%0A%20%20%23%20only%20include%20matches%20over%20a%20year%20apart%2C%20or%20where%20both%20statements%20are%20precise%20to%20the%20day%0A%20%20%23FILTER%28YEAR%28%3Fmarriage%29%20-%20YEAR%28%3Fdeath%29%20%3E%201%20%7C%7C%20%0A%20%20%23%20%20%20%20%20%20%20%3FmarriagePrecision%20%3D%2011%20%26%26%20%3FdeathPrecision%20%3D%2011%29.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fmarriage%20-%20%3Fdeath%29>
(source <https://twitter.com/WikidataFacts/status/772847757489045504>)
- Communes of France with more than one railway station
<https://query.wikidata.org/#SELECT%20%3Fplace%20%3FplaceLabel%20%28count%28%3Fitem%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ55488%20.%0A%20%20%3Fitem%20wdt%3AP131*%20%3Fplace%20.%0A%20%20%3Fplace%20wdt%3AP31%2Fwdt%3AP131*%20wd%3AQ484170%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%22%20.%20%7D%0A%7D%0AGROUP%20BY%20%3Fplace%20%3FplaceLabel%0AHAVING%20%28%3Fcount%20%3E%201%29%0AORDER%20BY%20DESC%28%3Fcount%29%20%3FplaceLabel>
(source <https://twitter.com/PoulpyWP/status/772843171340554240>)
- Languages and their grammatical cases they have in common
<https://query.wikidata.org/#%23%20Languages%20and%20the%20grammatical%20cases%20they%20have%20in%20common%0A%23defaultView%3AGraph%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fcase%20%3FcaseLabel%20%28concat%28%22F3A2FF%22%29%20as%20%3Frgb%29%0AWHERE%0A%7B%0A%09%3Fitem%20wdt%3AP2989%20%3Fcase%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D>
(source <https://twitter.com/tobias47n9e/status/772059985912160256>)
- Cocktails recipes
<https://query.wikidata.org/#%23%20cocktail%20recipes%20on%20Wikidata%0ASELECT%20%3Fcocktail%20%3FcocktailLabel%20%28GROUP_CONCAT%28%3Fingredient%3B%20separator%3D%22%2C%20%22%29%20AS%20%3Fingredients%29%20%23%20concatenate%20all%20ingredients%20together%2C%20separated%20by%20comma%0AWHERE%0A%7B%0A%20%20%23%20find%20a%20cocktail%0A%20%20%3Fcocktail%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ134768%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20get%20its%20material%20statement%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP186%20%3FmaterialStat.%0A%20%20%23%20get%20the%20statement%20value%20from%20the%20statement%0A%20%20%3FmaterialStat%20ps%3AP186%20%3Fmaterial.%0A%20%20%23%20get%20the%20material%E2%80%99s%20English%20label%0A%20%20%3Fmaterial%20rdfs%3Alabel%20%3FmaterialLabel.%0A%20%20FILTER%28LANG%28%3FmaterialLabel%29%20%3D%20%22en%22%29.%0A%20%20%23%20assign%20label%20to%20solo%20ingredient%20variable%0A%20%20BIND%28%3FmaterialLabel%20AS%20%3FingredientSolo%29.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%23%20for%20some%20reason%2C%20we%20have%20to%20get%20the%20material%20and%20materialLabel%20again%20%E2%80%93%20copy%2Bpasted%20from%20above%0A%20%20%20%20%3FmaterialStat%20ps%3AP186%20%3Fmaterial.%0A%20%20%20%20%3Fmaterial%20rdfs%3Alabel%20%3FmaterialLabel.%0A%20%20%20%20FILTER%28LANG%28%3FmaterialLabel%29%20%3D%20%22en%22%29.%0A%20%20%20%20%23%20get%20the%20quantity%20value%20from%20the%20statement%20%28if%20present%29%0A%20%20%20%20%3FmaterialStat%20pqv%3AP1114%20%3FquantityValue.%0A%20%20%20%20%23%20get%20the%20actual%20quantity%20from%20the%20quantity%20value%0A%20%20%20%20%3FquantityValue%20wikibase%3AquantityAmount%20%3Fquantity.%0A%20%20%20%20%23%20assign%20quantity%20and%20material%20to%20ingredient%20with%20quantity%20variable%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Fquantity%29%2C%20%22%20%22%2C%20%3FmaterialLabel%29%20AS%20%3FingredientWithQuantity%29.%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%23%20same%20here%20for%20material%20and%20quantity%0A%20%20%20%20%20%20%3FmaterialStat%20ps%3AP186%20%3Fmaterial.%0A%20%20%20%20%20%20%3Fmaterial%20rdfs%3Alabel%20%3FmaterialLabel.%0A%20%20%20%20%20%20FILTER%28LANG%28%3FmaterialLabel%29%20%3D%20%22en%22%29.%0A%20%20%20%20%20%20%3FmaterialStat%20pqv%3AP1114%20%3FquantityValue.%0A%20%20%20%20%20%20%3FquantityValue%20wikibase%3AquantityAmount%20%3Fquantity.%0A%20%20%20%20%20%20%23%20get%20the%20unit%20from%20the%20quantity%20value%0A%20%20%20%20%20%20%3FquantityValue%20wikibase%3AquantityUnit%20%3Funit.%0A%20%20%20%20%20%20%23%20throw%20out%20the%20unit%20%E2%80%9C1%E2%80%9D%20%28no%20unit%29%0A%20%20%20%20%20%20FILTER%28%3Funit%20%21%3D%20wd%3AQ199%29.%0A%20%20%20%20%20%20%23%20get%20the%20unit%E2%80%99s%20English%20label%0A%20%20%20%20%20%20%3Funit%20rdfs%3Alabel%20%3FunitLabel.%0A%20%20%20%20%20%20FILTER%28LANG%28%3FunitLabel%29%20%3D%20%22en%22%29.%0A%20%20%20%20%20%20%23%20assign%20quantity%2C%20unit%2C%20and%20material%20to%20ingredient%20with%20unit%20variable%20%20%28note%3A%20we%E2%80%99re%20not%20bothering%20with%20pluralization%20here%2C%20so%20it%20may%20sound%20a%20bit%20weird%29%0A%20%20%20%20%20%20BIND%28CONCAT%28STR%28%3Fquantity%29%2C%20%22%20%22%2C%20%3FunitLabel%2C%20%22%20%22%2C%20%3FmaterialLabel%29%20AS%20%3FingredientWithUnit%29.%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20%23%20assign%20ingredient%20with%20unit%2C%20else%20ingredient%20with%20quantity%2C%20else%20just%20solo%20ingredient%20to%20ingredient%20variable%0A%20%20BIND%28COALESCE%28%3FingredientWithUnit%2C%20%3FingredientWithQuantity%2C%20%3FingredientSolo%29%20AS%20%3Fingredient%29.%0A%20%20%23%20get%20the%20cocktail%E2%80%99s%20English%20label%0A%20%20%3Fcocktail%20rdfs%3Alabel%20%3FcocktailLabel.%0A%20%20FILTER%28LANG%28%3FcocktailLabel%29%20%3D%20%22en%22%29.%0A%7D%0A%23%20group%20by%20cocktail%0AGROUP%20BY%20%3Fcocktail%20%3FcocktailLabel%0A%23%20show%20most%20%E2%80%9Ccomplicated%E2%80%9D%20cocktails%20first%0AORDER%20BY%20DESC%28COUNT%28%3Fingredient%29%29>
(source <https://twitter.com/WikidataFacts/status/775495442352185346>)
- People who died in the last seven days
<https://query.wikidata.org/#SELECT%20%3Fperson%20%3FpersonLabel%20%3Fdied%0AWHERE%0A%7B%0A%20%20%3Fperson%20wdt%3AP31%20wd%3AQ5%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP570%20%3Fdied.%0A%20%20FILTER%28%3Fdied%20%3E%3D%20NOW%28%29%20-%20%22P7D%22%5E%5Exsd%3Aduration%29.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fdied>
(source <https://twitter.com/WikidataFacts/status/775424695776776192>)
- Places of birth of 20th century saints
<https://query.wikidata.org/#%23defaultView%3AMap%0Aselect%20%3Fp%20%3FpLabel%20%3Fborn%20%3Floc%20%7B%0A%20%20%3Fp%20wdt%3AP411%20wd%3AQ43115%20.%0A%20%20%3Fp%20wdt%3AP569%20%3Fborn%20.%0A%20%20%3Fp%20wdt%3AP19%20%3Fo%20.%0A%20%20%3Fo%20wdt%3AP625%20%3Floc%20.%0A%20%20filter%20%28%3Fborn%20%3E%20%221899-12-31%22%5E%5Exsd%3AdateTime%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D>
(source <https://twitter.com/vrandezo/status/773286824747814912>)
- New templates: {{Denmark properties
<https://www.wikidata.org/wiki/Template:Denmark_properties>}}, {{Greece
properties <https://www.wikidata.org/wiki/Template:Greece_properties>}}.
Please add labels in your own languages, and consider making a similar
template for your country or region.
Development
- Lowered relevance threshold for ArticlePlaceholder search results from
3 to 2 sitelinks (T144188 <https://phabricator.wikimedia.org/T144188>)
- Added 'otk' as an available language for monolingual text values (
T137809 <https://phabricator.wikimedia.org/T137809>)
- Working on making it possible to paste partial URLs into the site
selector (T144310 <https://phabricator.wikimedia.org/T144310>)
- A Grafana board now tracks general usage and error metrics of the
Query Service UI
<https://grafana.wikimedia.org/dashboard/db/wikidata-query-service-ui>
- Made progress on showing editors on all Wikimedia projects which
articles on their project use data from a given Wikidata item. We will also
show in the page information (action=info) which items a given article
uses. Also worked on showing which projects use a given item in the page
information. (T103091 <https://phabricator.wikimedia.org/T103091>)
- Added meta information to the html header of item pages (T88475
<https://phabricator.wikimedia.org/T88475>)
- Made progress on making ArticlePlaceholders indexable for search
engines (T144590 <https://phabricator.wikimedia.org/T144590>)
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/Special:MyLanguage/Wikidata:Showcase_items>
- Help translate <https://www.wikidata.org/wiki/Special:LanguageStats>
or proofread pages in your own language!
- Help merge identical items
<https://www.wikidata.org/wiki/User:Pasleim/projectmerge> across
Wikimedia projects.
- Add labels, in your own language(s), for the new properties listed
above.
- Comment on property proposals: all open proposals
<https://www.wikidata.org/wiki/Wikidata:Property_proposal/Overview>
- proposals
needing attention
<https://www.wikidata.org/wiki/Wikidata:Property_proposal/Attention_needed>
--
Léa Lacroix
Community Communication 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.