Research in programming Wikidata/Aircraft

From Wikiversity
Jump to: navigation, search

Researching aircrafts in the international project Wikidata. With the SPARQL-query was build list of aircrafts and diagram of aircraft manufacturers grouped by country.

List of "Aircrafts"[edit]

Making list with all Aircrafts

#List of `instances of` "aircraft" 
SELECT ?item ?itemLabel
    ?item wdt:P31 wd:Q11436.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }

SPARQL-query, 1564 result.

SPARQL-query, 153 have label in russian language.

Examples of the most complete and well-developed aircrafts on the Wikidata: Mikoyan-Gurevich MiG-3, Yakovlev Yak-36, Mitsubishi A5M

Almost empty and uninformative aircafts: Mikoyan-Gurevich MiG-1, Sukhoi Su-6, Ilyushin Il-103

Aircraft manufacturers[edit]

Making list of aircrafts manufacurers

# Count aircraft having property manufacture
# Group by manufacture
SELECT ?manufactureLabel (COUNT(?item) AS ?count) 
  ?item wdt:P31 wd:Q11436.     # instance of aircraft
  ?item wdt:P176 ?manufacture. # show manufacture
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
GROUP BY ?manufacture ?manufactureLabel # group by manufacture

SPARQL-query, 300 results.

From the SPARQL-query we get 300 manufacturers that engaged in making aircrafts.

Origin countries of aircraft manufacturers[edit]

# Count manufacture having property country
# group by country
SELECT ?countryLabel (count(?item) as ?count)
    ?item wdt:P31 wd:Q936518.   # instance of manufacture
    ?item wdt:P17 ?country.     # show country
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
GROUP BY ?country ?countryLabel # group by country

SPARQL-query 39 results.

Bubble graph

Aircraft manufacturers group by country

As we can see from the sparql-query, origin countries of aircraft manufacturers less informative that they could be. Most of the aircraft manufacturers come from USA (115), Great Britain (30), Germany (17), Russia (17).

Completeness of Wikidata[edit]

According to site there are exist near the 1700 aircraft manufacturers[1], but SPARQL-query find only 300 entries. From this fact we can conclude that Wikidata is uncomplete. May be this thousand of manufacturers made much little amount of planes or don't do them at all so the not listed in Wikidata.

In category Aircraft_manufacturers_of_Russia listed 58 russian aircraft manufacturers, but on the site listed [2] 61 manufacturers.

Filling wikidata[edit]

I choose field label and description from objects of category Aircraft manufacturers of Russia. I decide to automatize this work because there are many objects. And so i wrote special program for this. At first there must be created json file with objects from category and empty fields for filling:

  "121 авиационный ремонтный завод": {
    "description": "",
    "descriptionen": "",
    "nameen": "",
    "qid": "Q4028573"

First part of the program get from wikidata already filled fields. After that we need to fill empty one. At the end json look like this:

  "121 авиационный ремонтный завод": {
    "description": "авиаремонтное предприятие, расположенное посёлке Старый Городок",
    "descriptionen": "aircraft repair facility, located in the village Stary Gorodok",
    "nameen": "121 aircraft repair plant",
    "qid": "Q4028573"

Second part of the program write data from json to wikidata.

With help of the god and this program i simplify work with wikidata because i shouldn't go to the pages and write changes there by hand if it was needed.

Future work[edit]

  • Find plane with maximum fly range.
  • Concentration map of aircraft manufacturers, shown with dots on political map headquarters of the companies.
  • Find manufacturer with max builded plane, using property manufacturer from aircraft object.


1 What russian manufacturers have web site?

Saratov Aviation Plant

2 Choose date of manufacturers foundation.

1.12.1939 18.11.1949 1.01.1922 1.01.1939

3 Choose sity with headquarter of manufacturers.

Kazan Saratov Ulan-Ude Moscow
Kazan Helicopters Plant
Saratov Aviation Plant
Ulan-Ude Aviation Plant

4 How named aircraft that lighter than air, flying by dint of big balloon with deadly dangerously gas right up of passengers head?

5 How airship look like?

LAPD Bell 206 Jetranger.jpg
W-6 Ossoaviachim wiki.jpg
Airliners 28.07.2009 10-01-28.JPG

SPARQL-query manufacturers with web sites

SPARQL-query date of manufacturers foundation

SPARQL-query headquarters of manufacturers

SPARQL-query airship

SPARQL-query airship with pictures


  1. List of all Manufacturers.
  2. List of Russian Manufacturers.

"List of all Manufacturers". 

"List of Russian Manufacturers".