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
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"