Research in programming Wikidata/Academic institution

From Wikiversity
Jump to: navigation, search

This research is devoted to the study of Academic institution presented at Wikidata. With the help of SPARQL queries to Wikidata, the following tasks are solved:

  • Building a list of all academic institutions;
  • The date of the founding of academic institutions in countries around the world;
  • Building of a bar chart showing the ratio of languages spoken by various academic institutions;
  • Display on the map all academic institutions around the world.

In the course of the work, the following information was added to the Wikidata objects (Academic institution) - the coordinates of the location of academic institutions all around the world. Was made conclusions about the completeness and incompleteness of this information, presented in Wikipedia and the Wikimedia .

List of academic institutions[edit]

Given:

Let's build a list of all academic institutions.

#added 2017-02
#added 2017-02
#List of `instances of` "academic institution" 
SELECT ?academic_institution ?academic_institutionLabel
WHERE
{
    ?academic_institution wdt:P31 wd:Q4671277.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

SPARQL query, 3892 records.

👍 The most complete and well-developed academic institutions on the Wikimedia: Balashov branch of Saratov State University, Moscow State Institute of Culture, Samara State Regional Academy.

👎 Almost empty and uninformative academic institutions: Novorossiysk Polytechnic Institute, Rostov College of Arts, Omsk State Institute of Service.

The date of the founding of academic institutions in countries around the world[edit]

We will construct a histogram of academic institutions, sorted by the date of foundation and located in different countries.

Given:

#defaultView:BarChart
SELECT DISTINCT  (SAMPLE(?year) AS ?year) (COUNT(?year) AS ?count) (SAMPLE(?_academicLabel) AS ?_academicLabel) WHERE {
  ?object (wdt:P31) wd:Q4671277. 
  BIND(str(YEAR(?_inception)) AS ?year) 
  ?object wdt:P571 ?_inception. 
  ?object wdt:P17 ?_country. 
  ?_country rdfs:label ?_academicLabel.
  FILTER((LANG(?_academicLabel)) = "en") 
}
GROUP BY ?_inception ?_country 
ORDER BY ?year ?_inception

SPARQL query, 381 records.

bar chart of academic institutions around the world


Academic institutions of Russia[edit]

Build a SPARQL query to find how many information about Russian academic institutions can be found in Wikipedia.

Given:

#added 2017-05
#Number of academic institutions  in Russia
SELECT ?academic_institution ?academic_institutionLabel ?country 
WHERE
{
	?academic_institution wdt:P31 wd:Q4671277; # instance of academic institution  
        wdt:P17 wd:Q159;          # with country Russia
        rdfs:label ?item_label.    

    FILTER (LANG(?item_label) = "ru") .
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "ru".
	}
}

SPARQL query, 12 records.

Category Academic institutions in Russia of English Wikipedia contains information about several dozen academic institutions located in Russia. Russian Wikipedia does not have pages that are associated with the concept of an academic institution. Thus, most of the information about academic institutions in Russia is presented in the English Wikipedia

Academic institutions on the world map[edit]

Display on the map academic institutions and higher educational institutions around the world.

Given:

#List of `coordinate location` "academic institution and higher educarional institution" 
SELECT ?academic_institution ?academic_institutionDescription ?coord
WHERE
{
  { ?academic_institution wdt:P31 wd:Q4671277; wdt:P625 ?coord } UNION  
  { ?academic_institution wdt:P31 wd:Q38723; wdt:P625 ?coord } 
                            
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

SPARQL query, 1395 records.

Completeness of Wikidata: academic institutions around the world[edit]

Academic institution ( according to the English Wikipedia) at the end of studying allows a person to obtain a certain academic degree or graduate qualification(like Bachelor, Master). Thus, all higher educational institutions can be academic institutions.

Statistics of universities:

As you can see from SPARQL query, only 1395 higher educational institutions have the filled property coordinate location (P625). This is due to the fact that 10% of pages are filled correctly and fully.

A list of academic institutions with the empty property coordinate location[edit]

We will list the academic institutions and higher educational institutions with the empty property coordinate location (P625).

Given:

#List of `coordinate location` "academic_institution without a coordinate location" 
SELECT ?academic_institution ?academic_institutionLabel ?academic_institutionDescription ?coord 
WHERE
{
    {?academic_institution wdt:P31 wd:Q4671277} UNION #academic_institution
    {?academic_institution wdt:P31 wd:Q38723}
    MINUS { ?academic_institution wdt:P625 [] } . #coordinate location of academic_institution
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

SPARQL query, 3113 records.

Incompleteness of Wikidata: academic institutions around the world[edit]

Objects with a filled property "coordinate location" v1.0.


As we can see, only 1395 academic institutions and higher educational institutions have the filled coordinate location property. The data is visible on the version 1.0 image. Let's improve this situation.


Objects with a filled property "coordinate location" v1.1.


Was added property - coordinate location - to 100 objects academic institution (Q4671277), which is reflected in the fact that the number of records returned by SPARQL query has grown from 1395 to 1495. The data is visible on the version 1.1 image.

Future work[edit]

1. Find out the most popular language among acedemic institution (property "language used"). For clarity, build a bubble diagram.

2. Find academic institutions with a website (property "official website"). Mark them on the map.

3. Rate of academic institutions by the number of awards according to the Wikidata (property "award received").

Tests[edit]


SPARQL-запросы с ответами:


Notes[edit]

References[edit]