Wikidata

User:Daniel Mietchen/FSCI 2018

< User:Daniel Mietchen
A Wikidata query that was developed during the course. See #Map of institutions where Canadian citizens got their PhD for details.
Selection of Wikidata-related activities for coursework. See #Tailoring educational workflows for details.

About edit

This page is auxiliary to two summer courses taking place in the framework of the FORCE11 Scholarly Communication Institute (FSCI) 2018 in July/ August 2018:

Both parts are suitable for people who have no prior experience with Wikidata. In Part 2, participants of Part 1 will provide the necessary background about Wikidata to those who are new to the topic.

Requirements edit

Prior to the start of their course, participants are expected to

Facilities edit

Besides seats, tables and power outlets for everyone in the room, a stable WiFi would be needed, and for the speaker a projector and a stable Ethernet connection. Since Daniel will attend remotely via Zoom, access to an A/V system would be needed.

Participants edit

 
The Monday-Tuesday team
 
The Wednesday-Thursday team

Please sign and date your post (by typing *  or clicking the signature icon:   in the edit toolbar).

Monday-Tuesday edit

Wednesday-Thursday edit

Introductions to Wikidata edit

 
Wikimania 2018 overview of Wikidata progress over the last year

Wishlist edit

Queries edit

Help edit

 
Wikidata URIs for different formats

Example queries edit

Institutions around the globe where people who have/ had a doctoral advisor have been educated edit

The following query uses these:

Features: map (Q24515275)     

#defaultView:Map
SELECT ?academics ?academicsLabel ?geoloc ?institution ?institutionLabel ?image WHERE {
  ?academics wdt:P31 wd:Q5 . # instances (P31) of humans (Q5)
  ?academics wdt:P184 ?advisor . # PhD supervisor (P184)
  # possible other route to identify people with PhD: Property:P512 (academic degree): Q752297
  ?academics wdt:P69 ?institution . # educated at
  ?academics wdt:P18 ?image . #image
  #?institution wdt:P17 wd:Q16 . # institution is in Canada
  ?institution wdt:P625 ?geoloc . #gets the geolocation of the institution
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 100
Try it!

Map of institutions where Canadian citizens got their PhD edit

The following query uses these:

Features: map (Q24515275)     

#defaultView:Map
SELECT DISTINCT ?institution ?institutionLabel ?academics ?academicsLabel ?degree ?degreeLabel ?geoloc  ?image WHERE {
  ?academics wdt:P31 wd:Q5 ; # instances (P31) of humans (Q5)
             wdt:P27 wd:Q16 ; # country of citizenship
             p:P69 ?statement . # check for an "educated at" (P69) statement
  OPTIONAL { ?academics wdt:P18 ?image }. #image
  
  ?statement ps:P69 ?institution . # get value of the "educated at" statement, i.e. the institution
  ?institution wdt:P625 ?geoloc . # get the geolocation of the institution

  ?statement pq:P512 ?degree . # get qualifier "academic degree" (P512) 
  ?degree wdt:P31*/wdt:P279* wd:Q849697 . # filter for doctoral degrees
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}
Try it!

Maps based on Wikidata queries edit

Disasters by location and disaster type edit

The following query uses these:

Features: map (Q24515275)     

#defaultView:Map{"layer":"?typeLabel"}
SELECT ?item ?itemLabel ?geo ?type ?typeLabel (SAMPLE(?_image) AS ?image) WHERE {
  ?type wdt:P279* wd:Q3839081 .
  ?item wdt:P31 ?type ;
        wdt:P625 ?geo .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  OPTIONAL { ?item wdt:P18 ?_image }
}
GROUP BY ?item ?itemLabel ?geo ?type ?typeLabel
Try it!
Disasters by location and disaster type, with number of casualties edit

The following query uses these:

Features: map (Q24515275)     

#defaultView:Map{"layer":"?typeLabel"}
SELECT ?item ?itemLabel ?geo ?type ?typeLabel ?casualties (SAMPLE(?_image) AS ?image) WHERE {
  ?type wdt:P279* wd:Q3839081 .
  ?item wdt:P31 ?type ;
        wdt:P1120 ?casualties ;
        wdt:P625 ?geo .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  OPTIONAL { ?item wdt:P18 ?_image }
}
GROUP BY ?item ?itemLabel ?geo ?type ?typeLabel ?casualties
Try it!

Wikidata-powered infoboxes edit

Introduction edit

 
Wikidatacon 2017. Wikidata-powered infoboxes (demo pages for Catalan, Basque, English)

Examples for Wikidata-driven infoboxes edit

Technical details edit

 
Wikimania2018 CommonsInfobox
 
Wikidata-enabled Infobox Workshop

WikiCite edit

 
Lifting a veil on the sources of free knowledge a WikiCite workshop

More on Wikidata:Scholia edit

University of California at San Diego edit

Tools edit

Education edit

Starting points edit

Etherpad edit

Games edit

Ideas for Wikidata-related activities that could be made part of coursework edit

FSCI Doathon edit

Logistics edit

Ideas about what to work on edit

Background reading edit

Some more practice edit

Set up a new lexeme edit

Set up a new item for a publication edit

  • Pick a DOI or PMCID
  • Enter it into SourceMD
  • Check and run

Annotate some publication items as to what they are about edit

Some further customization of our Wikidata user interface edit
Geolocated topics of scholarly articles edit

The following query uses these:

Features: map (Q24515275)     

#source: https://gist.github.com/floatingpurr/490df22fdbeff0f127f71f83eff6a284
#defaultView:Map{"layer":"?topicsBin"}
SELECT ?topic ?topicLabel ?geoloc ?topicsBin ?topicCitations
WHERE{
   BIND(
      IF(?topicCitations < 10, "Log < 1",
            IF(?topicCitations < 100, "Log < 2",
                IF(?topicCitations < 1000, "Log < 3",
                    "Log >= 3")))
    AS ?topicsBin)

  {
  SELECT ?topic ?geoloc (count(?topic) as ?topicCitations) 
  
  WHERE {
    
  ?paper wdt:P921 ?topic ; 
         wdt:P31 wd:Q13442814 .
  ?topic wdt:P625 ?geoloc.
  } 

  GROUP BY ?topic ?geoloc
   
                
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!
Scaling this up edit
List of publications with a certain string in the title that have not been tagged as being about a topic described by the string edit

The following query uses these:

  • Properties: main subject (P921)     
    SELECT DISTINCT ?item ?itemLabel 
WHERE {
  hint:Query hint:optimizer "None".
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "\"data sharing\" haswbstatement:P31=Q13442814" .
    ?title wikibase:apiOutput mwapi:title.
  }
  BIND(IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  FILTER NOT EXISTS { ?item wdt:P921 wd:Q5227350. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
# LIMIT 10000
Try it!
Tool: QuickStatements edit
Tool: Mix'n'Match edit

Tailoring educational workflows edit

By the kind of involvement of Wikidata edit

  • Building generic Wikidata-based modules that can be inserted into coursework on a broad range of subjects with minimal customization
  • Adding a Wikidata component to existing courses that involve Wikipedia or some other Wikimedia-related activity
  • Building a largely Wikidata-based curriculum for data science or other data-centric fields

By age group edit

  • K-12
  • Secondary
  • Tertiary
  • Professional education
  • Seniors

By level of knowledge or skills edit

Levels edit
  • Beginner
  • Intermediate
  • Experienced
  • Expert
Dimensions of knowledge/ skills edit
  • Domain knowledge
  • Wikidata knowledge
  • Language skills
  • Software development skills
  • Design skills
  • Communication skills

By field of knowledge edit

  • Art history
  • Epidemiology
  • Linguistics
  • Goats

By jurisdiction edit

  • California
  • France
  • Kerala

Course summary edit

This will be presented on Friday in the summary plenary session.

See also edit

 
Wikidata's data model
 
Wikidata - A Gentle Introduction for Complete Beginners
 
An overview of Wikidata as given at Wikimania 2017
 
Wikidata-in-brief-1.0
 
Wikidata Query Service in Brief
 
Wikidata introduction - Celtic Knot Conference 2018
 
Topics co-occurring with 'Zika virus', as per Wikidata
Querying Wikidata with SPARQL for Absolute Beginners
 
Structured Data on Wikimedia Commons - what is happening
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Daniel_Mietchen/FSCI_2018&oldid=733816051"