Research in programming Wikidata/Aircraft

From Wikiversity
Jump to navigation Jump to search

This research is devoted to the analysis of aircraft on Wikidata. A list of aircraft was generated, a diagram of aircraft manufacturers grouped by country was drawn with the help of SPARQL query. The computer program (script) was written which fills labels and descriptions of aircraft manufacturer on Wikidata. The data about Russian aircraft manufacturers was added to Wikidata with the help of this script.

List of "Aircraft"[edit]

Lets' make a list with all Aircraft.

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

SPARQL-query, 1564 records.

SPARQL-query, 153 records have labels in Russian language.

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

Almost empty and uninformative aircraft instances are Mikoyan-Gurevich MiG-1, Sukhoi Su-6, Ilyushin Il-103

Aircraft manufacturers[edit]

Let's make a list of aircraft manufacturers.

# 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 records.

By dint of the SPARQL-query we got 300 manufacturers that make aircraft.

Origin countries of aircraft manufacturers[edit]

Let's make a list of manufacturers grouped by countries.

# 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 records.

Bubble graph, where circles relate to countries and there sizes correlate with number of aircraft manufacturers in the country. This graph shows the difference between objects.

Aircraft manufacturers grouped by country

As can be seen from the SPARQL-query, origin countries of aircraft manufacturers are less informative than they could be. Most of the aircraft manufacturers are located in USA (115), Great Britain (30), Germany (17), Russia (17) for 29 may 2017.

Completeness of Wikidata[edit]

According to the site there are about 1700 aircraft manufacturers[1], but SPARQL-query returns only 300 entries. From this fact follows the conclusion that Wikidata is uncomplete.

There are 58 Russian aircraft manufacturers listed in the category Aircraft manufacturers of Russia, but on the site listed [2] 61 manufacturers like Irkut, Mikoyan, Tupolev.

Filling Wikidata[edit]

Label and description fields from objects of category Aircraft manufacturers of Russia was chosen for filling. There were too many objects with empty fields to write them by hands so the special program was written for this. At first JSON file with objects from this category and empty fields for filling must be created:

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

First part of the program read from Wikidata already filled fields. After that the empty one must be filled. At the end JSON file looks 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 writes data from JSON file to Wikidata.

With help of the God and this program work with Wikidata can be simplified because there no more need in go to the pages and write changes manually if fields in Wikidata are empty or contain incorrect information.

Future work[edit]

  • Find plane with maximum fly range.
  • Draw headquarters of the companies on map.
  • Find manufacturer with maximum number of built plane, using property manufacturer from aircraft object.



What Russian manufacturers have web site?

Saratov Aviation Plant


Choose date of manufacturers foundation.



Choose city with headquarter of manufacturers.

Kazan Helicopters Plant
Saratov Aviation Plant
Ulan-Ude Aviation Plant


What is name of aircraft that lighter than air, flying by dint of big balloon with deadly dangerously gas right up of passengers head?


How airship looks 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


External links[edit]

  • "List of all Manufacturers". Aviation Fanatic. Retrieved 2017-05-29.
  • "List of Russian Manufacturers". Aviation Fanatic. Retrieved 2017-05-29.
  • Rybin E.I., Krizhanovsky A.A... Два с половиной SPARQL-запроса и воздушные суда; Two and a half SPARQL-request and aircraft.. Authorea. 
  • Rybin E.I. "Code of the program to fill Wikidata". GitHub.