Research in programming Wikidata/Natural disaster

This chapter is devoted to the study of natural disaster properties based on the knowledge base of the Wikidata international project. SPARQL queries were used in order to analyze and compute "natural disaster" objects on Wikidata. A list of all natural disasters and their types was built. A list of all earthquakes was constructed and their number in each country was calculated. In addition, the conclusions regarding the completeness of Wikidata on this topic are stated.

List of natural disasters

 * Items: natural disasters (Q8065)
 * Properties: instance of (P31)

Let's list all natural disasters.

SPARQL query, 16 results.

👍 > Examples of the most complete and well-developed natural disasters on the Wikidata: 2002 European floods, May 2004 Caribbean floods, Christmas flood of 1717.

👎 > Almost empty and uninformative natural disasters: 2013 China–Russia floods, 2007 Nevelsk earthquake, 2012 Krasnodar Krai floods.

Types of natural disasters
Construct a table with the number of natural disasters by types of catastrophes.
 * Items: natural disasters (Q8065)
 * Properties: instance of (P31)

SPARQL query 9 Results

Types of catastrophes were obtained: flood, earthquake, landslide, drought, storm surge.

Completeness of Wikidata
According to the training manual "Basic safety training and first aid", natural disasters can be divided into:
 * Meteorological - storm, hurricane, tornado, cyclone, frost, drought, extraordinary heat, fire.
 * Telluric and tectonic - volcanic eruption, earthquake.
 * Topological - flood, mudslides, landslips, avalanche.

In the sources one can find different classifications of natural disasters, so it is difficult to calculate the precise number of types of disasters.

Nine types of natural disasters are received, by means of SPARQL script. As a result of the script represented floods, earthquakes, landslides, drought, from the book Aizman. There are no storms, hurricanes, tornadoes, cyclones, frosts, unusual heat, fires, volcanic eruptions, mudflows and snow falls in this book. As a result of the script it turned out that on Wikidata most presented floods (seven). The least represented are droughts, earthquakes and landslides (one).

the most number of disasters at wikidata belong to the types: floods and landslides by classification presented in the book of Aizaman, and the smallest number of disasters  belong to the  types: storms, hurricanes, tornadoes, cyclones, frosts, an extraordinary heat, the fires.

According to the category "Natural disasters" of Russian Wikipedia, there are 10 types of natural disasters. According to the category "Natural disasters" of the English Wikipedia, there are 15 types of natural disasters.

Earthquakes





 * Items: earthquake (Q7944)

Let's build a list of all earthquakes.

SPARQL query 1547 Results

Calculate the number of earthquakes by country.


 * Items: earthquake (Q7944)
 * Properties: country (P17)

SPARQL query 72 Results

Completeness of Wikidata
By means of the first SPARQL script 1547 records are received. According to the textbook "General geology for ecologists" during one year around 100 strong earthquakes occur in the world, therefore on Wikidata there are records of the most famous and strongest earthquakes in the world. Seismographs register more than 100 thousand earthquakes per year.

By means of the second SPARQL script Wikidata contains information about earthquakes in 72 countries. America, Japan, China have the maximum number of earthquakes: 76, 51 and 31, respectively. The fewest are in the countries: Romania, Palestine, Slovenia.

The are two earthquakes in Russia: Earthquake in Baikal (2008), Neftegorsk earthquake.

According to RIA Novosti there are six earthquakes in 2013, five in 2012, three in 2011. These are only the most famous earthquakes.

According to category "Earthquakes in Russia" of the Russian Wikipedia there are 27 earthquakes which have occurred in Russia. According to the category "Earthquakes in Russia" on the English Wikipedia there are 14 objects.

We filled in the Wikidata objects that corresponded to earthquakes, 1568 records were received. Now Wikidata contains 30 earthquakes which occur in Russia. Also, the number of earthquakes in other countries increased on the Wikidata: Romania, Moldova, Nepal, People's Republic of China, Bhutan, Bangladesh, India, Croatia, Uzbegistan, Indonesia, Singapore, Malaysia, Thailand, Slovenia, Italy, Pakistan, Afghanistan, Iran, Kyrgyzstan, Ukraine, Bulgaria, Portugal, Algeria, New Zealand, Bhutan, Philippines, Japan, Greece, Guatemala, Venezuela. Number of countries with earthquakes on Wikidata increased from 72 to 82.

Future work

 * 1) Calculate the number of floods for each country and display the result in a diagram.
 * 2) Find the year with the largest number of floods.
 * 3) Create a top-10 of natural disasters which have caused to people the most economic damage.

Tests
{Choose what magnitude (on the Richter scale) corresponds to the earthquakes which have occurred in Russia. -+- 2003 Altai earthquake +-- Earthquake in Baikal (2008) --+ 1995 Neftegorsk earthquake
 * type=""}
 * 6.3 | 7.3 | 7.6

{Indicate the floods in which most people died, in order of increasing mortality. -+-- 1938 Yellow River flood ---+ Great Mississippi Flood of 1927 +--- 1931 China floods --+- May 2004 Caribbean floods
 * type=""}
 * 1 (4000000) | 2 (900000) | 3 (2000) | 4 (246)

{ Write the name of the country in which there were floods presented in photos:

{ People's Republic of China| China | PRC }
 * type="{}"}

SPARQL-questions with answers:
 * value of magnitude of earthquakes in Russia,
 * number of deaths in floods, in descending order,
 * images of floods.