Wikimedia CEE Meeting 2016/Programme/Submissions/Sparql for Wikidata

Title of your proposal

Name(s) and/or username(s)

Tobias Schönberg, User:Tobias1984

Coinstructors welcome!

Topic

Wikidata

Type of submission (Please choose one)

Workshop (work in groups)

Summary

I would like to do a 1 hour Sparql workshop with people that haven't used it or only know it a little. No prior programming experience is needed. We will go through some simple query examples and then everyone can work on queries of their own. We will use http://query.wikidata.org to build the queries. An example of a query is shown in the image to the right. It is build with this query:

SELECT ?item ?itemLabel ?sisterCity ?sisterCityLabel ?coord 
WHERE {
  ?item wdt:P17 wd:Q399 .
  ?item wdt:P190 ?sisterCity .
  ?sisterCity wdt:P625 ?coord .
  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "en" . 
    ?item rdfs:label ?itemLabel .
    ?sisterCity rdfs:label ?sisterCityLabel .

  }
}

We can also look at queries that help guide translation efforts:

# Items that have country = Armenia, have an Armenian label and are missing and English label
SELECT ?item ?itemLabel ?armenianLabel WHERE {
    ?item wdt:P17 wd:Q399 .
    ?item rdfs:label ?armenianLabel filter (lang(?armenianLabel) = "hy") .
	filter not exists { ?item rdfs:label ?missinglabel filter (lang(?missinglabel) = "en") } .
  	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en" .
	}
}