\o/

I won't be on Wikimania but if any help is needed I would be glad to assist.

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! :)

Yes please!

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

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)
• I'd like to get lists of items that have specific statements *with specific qualifiers* (so I'd like to learn to integrate qualifiers in a query)
• 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
• Give me all the public artworks (genre: public art) in an area 3 km around a given point
• 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?

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.webm

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.

Our Etherpad: https://etherpad.wikimedia.org/p/SPARQLatWikimania2016

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.

I am completely a newbie and my first query thanks to this session is this. Now I have 43 entries of people born in Ukraine before year 1890 with no death date which I will need to check :) Thanks a lot for the session.