Research in programming Wikidata/Archive
The article is devoted to the investigation of the Wikidata object — "Archives". With the help of SPARQL queries, computed on objects of the "archives" type in the Wikidata, the following tasks were solved: all archives in Russia were listed, a map of the archives located in the Russian Federation was generated. Conclusions were made about the completeness of the Wikidata on this topic and a map of the archives of the world was draw after adding geographic coordinates to archives.
Instances of the Archive object
edit- Item: archive (Q166118).
- Property: instance (P31).
#List of archive in English and Russian
SELECT ?archive ?label_en ?label_ru
WHERE {
?archive wdt:P31 wd:Q166118. #instance of archive
?archive rdfs:label ?label_en.
?archive rdfs:label ?label_ru.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
SPARQL-query, 32 results.
The most complete and elaborated archives on the Wikidata are: Internet Archive, Wikimedia Commons, Presidential Library of Ronald Reagan.
Almost empty and uninformative archives were: National Archives of the Republic of Karelia, Federal Archival Agency, Russian State Military Archive.
According to ProWD the Internet Archive is the leader in terms of the number of properties (32 properties) among archives around the world. Russian State Archive of Economy contains 12 properties. This is the maximum number of properties for Russian archives.
Distribution of archives on the world map
editLet's show the geographic location of archives on the world map based on the "location" property, determine the geographic coordinates of the archives and put the archives on the world map.
#List of archives on the world map
#defaultView:Map
#28 October 2017
SELECT ?archive ?archiveLabel ?location WHERE {
?archive wdt:P31 wd:Q166118. #instance of archive
?archive wdt:P625 ?location. #instance location of archive
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
SPARQL-query, 672 results.
This map shows that most of the archives based on the Wikidata (on October 28, 2017) were located in Europe.
Completeness of the Wikidata
editThere are 5 archives according to the category List of archives in Russia in English Wikipedia. Apparently, this section includes a list of the largest archives in Russia.
According to the category of List of national archives in English Wikipedia there are 147 archives in the world.
According to the Archives of Russia portal, state and municipal archives from institutions for permanent storage have taken about 1.5 million items [1]. Only in the federal archives there were about 100 thousand cases of management documentation and over 100 thousand cases of personnel.
The total number of countries in the world is 193. According to the category List of archives in English Wikipedia, there are 190 countries in which there are archives.
The following script shows the number of archives in each country in the world.
SELECT ?countryLabel (COUNT(?org) AS ?count) WHERE {
?org wdt:P31 wd:Q166118. #instance of archive
?org wdt:P17 ?country. #instance country of archive
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?country ?countryLabel
ORDER BY DESC(?count)
SPARQL-query, 70 results.
As a result, the script issues 70 countries, which indicates that the Wikidata are not complete enough for archives, because not all archives have the "state" property. The top ten countries by number of archives include:
- Germany (486 archives),
- Spain (141 archives),
- Bulgaria (110 archives),
- United Kingdom (75 archives),
- United States of America (61 archives),
- Belgium (54 archives),
- Russia (46 archives - after adding data, 2 archives - before work),
- Poland (35 archives),
- Switzerland (28 archives),
- The Netherlands (26 archives).
Wikidata editing
editAccording to the script written above, in Russia there are 9 archives. The information about the Russian archives is not complete enough in the Wikidata. It should be corrected.
A script finds these 9 archives.
#Russian archiveson the map
#28 October 2017
SELECT ?archive?archiveLabel WHERE {
?archive wdt:P31 wd:Q166118. #instance of archive
?archive wdt:P17 wd:Q159. #instance country Russia of archive
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
SPARQL-query, 9 results.
Let's show Russian archives on the map.
#List of archives in Russia
#defaultView:Map
SELECT ?archive ?archiveLabel ?location WHERE {
?archive wdt:P31 wd:Q166118. #instance of archive
?archive wdt:P17 wd:Q159. #instance country Russia of archive
?archive wdt:P625 ?location. #geographical coordinates of archive
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
SPARQL-query, 2 results.
It turned out that not all the Russian archives presented in the Wikidata are depicted on the map. Therefore, it is necessary for each Russian archive presented in the Wikidata to add the properties: "instance of", "country", "coordinate location".
After adding geographic coordinates, the archives recorded 46 items on the map.
#Archives on the map
#29 October 2017
SELECT ?archive ?archiveLabel ?location WHERE {
?archive wdt:P31 wd:Q166118. #instance of archive
?archive wdt:P17 wd:Q159. #Russia
?archive wdt:P625 ?location. #geographical coordinates of archive
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
SPARQL-query, 46 results.
Let's build a map of the world with newly added national archives.
#Archives on the world map
SELECT ?archive ?location WHERE {
?archive wdt:P31 wd:Q166118. #instance of archive
?archive wdt:P625 ?location. #geographical coordinates of archive
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
SPARQL-query, 723 results.
Future work
edit- Display the list of the founders of the archives of the world.
- Draw archives on the world map with an indication of the volume of the archive (the size of the circle on the map corresponds to the volume of the archive).
- Count the volume of archives by continents.
Exercises
edit
SPARQL queries with replies:
References
edit- "Federal Law of the Russian Federation of October 22, 2004 N 125-FZ". October 22, 2004.
- "Archives of Russia portal". 2001.
- Krizhanovsky A.A., Anisimova M.S. (2017). "Geographical Investigation of the Archives of Russia and the World". Authorea.
- Krizhanovsky A. (2020). "Archives in Russia". ProWD.