Re: [Wikidata] How to get direct link to image
Hi Laura, If a spreadsheet is an option, you can use the WIKICOMMONSLINK function ( https://tomayac.github.io/wikipedia-tools-for-google-spreadsheets/Documentation.html, select it in the select box) function of my Google sheets add-on ( https://chrome.google.com/webstore/detail/wikipedia-tools/aiilcelhmpllcgkhhpifagfehbddkdfp?utm_source=permalink ). Cheers, Tom ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] SQID now supports PrimarySources
Hi Markus, Regarding David's question, a random Primary Sources item can be retrieved via the endpoint https://tools.wmflabs.org/wikidata-primary-sources/entities/any. Cheers, Tom -- Dr. Thomas Steiner, Employee (https://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.1.15 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] #WikidataBirthday present: new release of Wikipedia and Wikidata Tools for Google Spreadsheets add-on
Hi again,
> I find the WIKISEARCH a bit overly permissive for general use, but it did
> find some useful matches.
The underlying Wikipedia API request is to the best of my
understanding essentially the same as a regular on-Wikipedia search.
You might get better results by setting the optional second parameter
"opt_didYouMean" to true like so: =WIKISEARCH("search term", TRUE). In
some cases it then shows the most probable alternative result that you
might have wanted to actually search for instead. Give it a spin.
Also, together with the pipeline I have set up for you in the sheet,
you can filter on type, so when you know you are looking for "instance
of: human", you can exclude anything non-human. Hope this helps!
Cheers,
Tom
--
Dr. Thomas Steiner, Employee (http://blog.tomayac.com,
https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany
Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle
Registration office and registration number: Hamburg, HRB 86891
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom
hTtPs://xKcd.cOm/1181/
-END PGP SIGNATURE-
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] #WikidataBirthday present: new release of Wikipedia and Wikidata Tools for Google Spreadsheets add-on
Hi David, I made some additions to your document (red column headers). This shows the workflow to first search, then lookup the qid, and then the WIkidata fact "instance of". I will add the descriptions to a new function WIKIDATADESCRIPTIONS, let me work on that. It is easily possible via the API (https://www.wikidata.org/w/api.php?action=wbgetentities=Q42=json=descriptions). Hope this helps! Cheers, Tom -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] #WikidataBirthday present: new release of Wikipedia and Wikidata Tools for Google Spreadsheets add-on
Hi David, Mind sharing (privately if necessary) your spreadsheet? My recommended workflow would be to pair free-form terms (like your names) with the WIKISEARCH function and only then feed its output into WIKIDATAQID (or rather directly WIKIDATAFACTS, as it accepts qids or article titles directly). If this doesn't help, again the offer to share your spreadsheet so I can have a direct look. Cheers, Tom -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
[Wikidata] #WikidataBirthday present: new release of Wikipedia and Wikidata Tools for Google Spreadsheets add-on
Dear Wikidata Community, Following user feedback [0], I have made working with Wikidata data from within a Google Sheets context a lot easier by creating a special #WikidataBirthday release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on [1]. See a concrete example in [2]. Happy birthday, Wikidata ! Humbled by all the work the Wikidata team are doing; thank you all! Cheers, Tom -- [0] https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/12 [1] https://chrome.google.com/webstore/detail/wikipedia-and-wikidata-to/aiilcelhmpllcgkhhpifagfehbddkdfp [2] https://docs.google.com/spreadsheets/d/1QuUVFl6x3c1Yj3J7jd_OTHYD2haVFVtebIw2It4KNoA/edit?usp=sharing -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] Terms - search for corresponding WD-item and WP-article
Hi Markus, This is a lighthouse case for my Google Sheets add-on Wikipedia Tools for Google Spreadsheets (bit.ly/wikipedia-tools-add-on). Here is an editable sheet (https://docs.google.com/spreadsheets/d/1zAZBS09XAYzzL0e6ltTEc943ATvddN6DUgi076xe8qs/edit?usp=sharing) that you can continue to use, just add new terms to the "Terms" column, everything else fills automagically. Enjoy! Cheers, Tom -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] RFC - Primary Sources?
Hi Tom, all, > Have you considered asking > Google to transfer ownership of the project since they're no longer doing > anything with it? Denny wrote [1] that we are open to transferring the project to a new owner: "If anyone wants to take over the project, we would invite you to contribute a bit for a while, and then let’s discuss about it. I would be thrilled to see this tool develop.". This still stands :-) Cheers, Tom -- [1] https://lists.wikimedia.org/pipermail/wikidata/2016-February/008316.html -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] [ANN] Wikipedia Tools for Google Spreadsheets
Hi Lane, all, > I wanted to make an on-wiki place to host discussion of the tool so I set up > this project page on meta. > <https://meta.wikimedia.org/wiki/Wikipedia_Tools_for_Google_Spreadsheets> Thanks for creating this, I reworded it slightly, mostly removed mentions of Google Chrome, as Google Sheets add-ons work independently from the Web browser. I also left a clarifying comment on the Discussion page. Cheers, Tom -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] question on claim-filtered search/dump and works on a Wikidata subset search engine
[+Ruben Verborgh] Salut Maxime, I wonder if this is something Ruben's Linked Data Fragments (http://linkeddatafragments.org/) could solve in a fast enough manner?! I let Ruben chime in (if he wants). Cheers, Tom On Thu, Apr 28, 2016 at 12:26 PM, Maxime Lathuilière <gro...@maxlath.eu> wrote: > Hello! > > Context: > For the needs of inventaire.io, I'm working on a type-filtered autocomplete, > that is, a field with suggestions but with suggestions matching a given > claim, typically an "author" input where I would like to suggest only > entities that match the claim P31:Q5 (instance of -> human). > > The dream would be to have "filter" option in the wbsearchentities module, > to be able to do things like > https://www.wikidata.org/w/api.php?action=wbsearchentities=10=json=victor=P31:Q5 > > As far as I know, this isn't possible yet. One could search without filter, > then fetch the related entities with their claims data, then filter on those > claims, but this is rather slow for such an autocomplete feature that needs > to be snappy. So the alternative approach I have been working on to is to > get a subset of a Wikidata dump and put it in an ElasticSearch instance. > > Question: > What is the best way to get all the entities matching a given claim? > My answer so far was downloading a dump, then filtering the entities by > claim, but are there better/less resource-intensive ways? > The only other alternative I see would be a SPARQL query without specifying > a LIMIT (which in the case of P31:Q5 is probably in the millions(?)) to get > all the desired ids, then using wbgetentities to get the data 50 by 50 to > work around the API limitations, but those limitations are there for > something right? > As those who manage the servers that would be stressed by one or the other > way, what seems the less painful to recommend? ^^ > > Thanks in advance for any clue! > > New tools: > - To make a filtered dump, I wrote a small command-line tool: > wikidata-filter > It can filter a dump but also any set of Wikidata entities in a > newline-delimited json file, hope it can be helpful to other people! > - The whole search engine setup can be found here: > wikidata-subset-search-engine > > Clues and comments welcome! > > Greetings, > > Maxime > > -- > Maxime Lathuilière > maxlath.eu - twitter > inventaire.io - roadmap - code - twitter - facebook > wiki(pedia|data): Zorglub27 > for personal emails use m...@maxlath.eu instead -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata-tech] Adding reference re-adds claim
Is this answer from TPT related? https://github.com/google/primarysources/issues/90#issuecomment-206256966. Sorry, I am at a multi-day event this week and am a bit behind on emails. If it is, I am happy to quickly merge a pull request if anyone creates it :-) -- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -END PGP SIGNATURE- ___ Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
Re: [Wikidata] Freebase to Wikidata: Results from Tpt internship
Hi Tom, all, > This is now, finally, available: > http://static.googleusercontent.com/media/research.google.com/en//pubs/archive/44818.pdf Yes. > I'm going to assume that the lack of answer to this question over the last > four months, the lack of updates on the project, and the fact no one is even > bothering to respond to issues means that this project is dead and > abandoned. That's pretty sad. For an internship, it sounds like a cool > project and a decent result. As an actual serious attempt to make productive > use of the Freebase data, it's a weak, half-hearted effort by Google. You have a very fair point and I apologize for our silence. Thomas P.-T. was working on this full-time during his internship, all other project members based on Google's famous-infamous (1)20% time agreement. Not as an excuse, but as an explanation. I have started triaging, assigning, and working on issues yesterday, and plan to do more work in the coming days. > Is there any interest in the Wikidata community for making use of the > Freebase data now that Google has abandoned their effort, or is there too > much negative sentiment against it to make it worth the effort? Please see Marco Fossati's email and my explanations from above. > p.s. I'm surprised that none of the stuff mentioned below is addressed in > the paper. Was it already submitted by the beginning of October? This is the fact indeed, it was initially submitted to the WWW Research Track (http://www2016.ca/calls-for-papers/call-for-research-papers.html) and then re-routed to the Industry Track. Cheers, Tom -- Dr. Thomas Steiner, Employee (blog.tomayac.com, twitter.com/tomayac) Google Germany GmbH, ABC-Str. 19, 20354 Hamburg Geschäftsführer: Matthew Scott Sucherman, Paul Terence Manicle Registergericht und -nummer: Hamburg, HRB 86891 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.29 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] mobile improvements going live soon
Great work! Tiny visual thing: left and right margins are not balanced. On an iPhone 6 at least. Thanks, Tom -- Dr. Thomas Steiner, Employee, Google Inc. http://blog.tomayac.com, http://twitter.com/tomayac -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] Update frequency on the Wikidata Query API
Hi there, Are you aware of the revision URL parameter? Last paragraph of https://www.wikidata.org/wiki/Wikidata:Data_access#Linked_Data_interface. This hopefully should help. Cheers, Tom -- Dr. Thomas Steiner, Employee, Google Inc. http://blog.tomayac.com, http://twitter.com/tomayac -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata] Update frequency on the Wikidata Query API
Sorry, realizing only now that this is for the Query API, not the Linked Data interface. My bad, please ignore my previous reply. -- Dr. Thomas Steiner, Employee, Google Inc. http://blog.tomayac.com, http://twitter.com/tomayac -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Re: [Wikidata-l] Autocomplete API for a search field in an external app
Hi Maxime, After some quick reverse engineering of the site with the Chrome Developer Tools, here's the API it is using: http://www.wikidata.org/w/api.php ?callback=[YOUR CALLBACK NAME] action=wbsearchentities format=json language=en type=item continue=0 _=[TIMESTAMP (as a cache buster)] search=[YOUR QUERY] If you don't need the callback, then the API is as follows (note the missing cache buster): http://www.wikidata.org/w/api.php action=wbsearchentities format=json language=en type=item continue=0 search=[YOUR QUERY] Hope this helps. Best, Tom -- Thomas Steiner, Employee, Google Inc. http://blog.tomayac.com, http://twitter.com/tomayac -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] Autocomplete API for a search field in an external app
Small correction: If you don't need the callback, then the API is as follows (note the missing cache buster): http://www.wikidata.org/w/api.php action=wbsearchentities ?action=wbsearchentities (replace '' with '?', copy and paste oversight, sorry). -- Thomas Steiner, Employee, Google Inc. http://blog.tomayac.com, http://twitter.com/tomayac -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] qLabel
It's called JsonP. We could support it, but it would render the URL uncacheable... bah, annoying. CORS to the rescue? Or did I miss something? Sorry in that case. -- Thomas Steiner, Employee, Google Inc. http://blog.tomayac.com, http://twitter.com/tomayac -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom.hTtP5://xKcd.c0m/1181/ -END PGP SIGNATURE- ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
