[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Edgars2007 added a comment. In T137743#2392404, @Multichill wrote: Resources: Even more queries at https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries You can also point out talk page. There are also many examples, which probably could be ported to queries page itself some day, but that is another story.TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Edgars2007Cc: Edgars2007, OrenBochman, Ata, Esh77, Jonas, Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Spinster added a comment. Our Etherpad: https://etherpad.wikimedia.org/p/SPARQLatWikimania2016TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SpinsterCc: OrenBochman, Ata, Esh77, Jonas, Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Smalyshev added a comment. I think we also need to mention how the completion works, both when writing and reading, not everybody is aware of it. And give some insight in the data model - i.e. how wdt: works, how statements work, etc.TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Jonas, Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Jonas added a comment. Here is a video showing how to use the query explanation box and different result views: https://commons.wikimedia.org/wiki/File:Wikidata_Query_Service_Introduction.webmTASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: JonasCc: Jonas, Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Jonas added a comment. Here is a video showing how to use the query explanation box and different result views: https://commons.wikimedia.org/wiki/File:Wikidata_Query_Service_Introduction.webmTASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: JonasCc: Jonas, Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Spinster added a comment. I’m not going to the hackathon but will be there on Wednesday and would love to attend this. I'm not a programmer. I’m able to take existing queries and modify them a bit. I'm also able to build WDQ queries and then use the converter. Would like to learn to build SPARQL queries from scratch. Haven’t been able to figure out the scenarios and questions below, though, and would like to learn this (if it is doable via Wikidata’s SPARQL engine): Give me all the paintings that are depicted in https://www.wikidata.org/wiki/Q17337965 and put them on a map - this should be retrieved via the coordinates of their collections Give me all the artworks in one art collection + all their inventory numbers + the reference URLs in the references for the inventory numbers (that last part is something I can’t do yet) Give me all the artists who are creators of artworks of one art collection, show each artist only once, and put them on a map based on their birth date I’d like to see an interesting and working use case for the Graph and the Dimensions display mode Is it possible to generate a graph visualization of 8 different art collections and their connected artists (so that you see which artists are represented in multiple collections)? I'd like to work with pagepiles and/or with sets of handpicked Wikidata items, but have a hunch that this is not possible, is this correct? If it is possible, how to do it? TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SpinsterCc: Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Multichill added a comment. Resources: User manual at https://www.mediawiki.org/wiki/Wikidata_query_service/User_Manual Example queries at https://www.mediawiki.org/wiki/Wikibase/Indexing/SPARQL_Query_Examples More queries at https://www.wikidata.org/wiki/Wikidata:List_of_queries Even more queries at https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries About the format: We probably need a couple of slides, but more important, we need people to bring their laptops and have a couple of people walk around. We need to start with the basics (like https://query.wikidata.org/#%23Can%20I%20have%2010%20triples%20please%3F%0ASELECT%20%3Fa%20%3Fb%20%3Fc%0AWHERE%20%7B%20%3Fa%20%3Fb%20%3Fc%20%7D%0ALIMIT%2010 ) and add the pieces for people who to build queries. Components we probably want to explain: basic SELECT .. WHERE .. LIMIT Label service OPTIONAL DISTINCT ORDER BY GROUP BY MINUS FILTER UNION BIND Visualizations! Maps, external, on Wikidata TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MultichillCc: Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Legoktm added a comment. Yes please!TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LegoktmCc: Legoktm, Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Lucie added a comment. Yay! Let me know if you need any held and/or presentations on the topic and/or basic explanation of how this whole SPARQL thing works! :)TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LucieCc: Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T137743: SPARQL or: How I Learned to Stop Worrying and Love the Triples
Smalyshev added a comment.I won't be on Wikimania but if any help is needed I would be glad to assist.TASK DETAILhttps://phabricator.wikimedia.org/T137743EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Kghbln, Base, Lydia_Pintscher, Lucie, Spinster, Aklapper, Multichill, Zppix, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Izno, Psychoslave, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331 ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
