DataWar Project
Denis BÉDIN, Samuel GIRARDEAU, François LÉPINE
A Semantic Web project of M1 Info
https://gitlab.univ-nantes.fr/E156756M/datawar
Data Set
https://public.opendatasoft.com/explore/dataset/124920_1ucdpprio-armed-conflict-dataset_v4-2015/table/
UCDP/PRIO Armed Conflict Dataset v.4-2015, 1946 – 2014
2168 lines
Ignored Colomns
- Year
- SideBID
- IntensityLevel
- CumulativeIntensity
- StartDate2
- StartPrec2
- EpEndA
- GWNoA
- GWNoA2nd
- GWNoB
- GWNoB2nd
- GWNoLoc
- Region
- Version
Knowledge Graph
ConflictId
StartDate
EpEndDate
StartPrec
EpEndPrec
Location
Sides
dbo:combattant
dbo:country
dbo:startDate
dbo:endDate
xsd:integer
xsd:integer
TypeOfConflict
rdf:type
Incompatibility
TerritoryName
dbo:place
xsd:string
Location is the initiator country !
(not the location)
See the original data documentation for more details.
Transcription in RDF-Triples with Tarql
CONSTRUCT {
#mapping
?URI a dbo:MilitaryConflict;
dbo:year ?Year;
dbo:country ?Location;
dbo:combattant ?SideA;
dbo:combattant ?SideB;
dbo:combattant ?SideA2nd;
dbo:combattant ?SideB2nd;
dbo:opponent ?SideA;
dbo:opponent ?SideB;
xsd:string ?Incompatibility;
dbo:place ?TerritoryName;
rdf:type ?TypeOfConflict;
dbo:startDate ?StartDate;
dbo:endDate ?EpEndDate.
?Start xsd:integer ?StartPrec.
?End xsd:integer ?EpEndPrec.
}
FROM <file:ucdprio.csv>
WHERE {
BIND (URI(CONCAT('http://dbpedia.org/ontology/MilitaryConflict/', ?ConflictId)) AS ?URI)
BIND (URI(CONCAT('http://dbpedia.org/ontology/StartDate/', ?StartDate)) AS ?Start)
BIND (URI(CONCAT('http://dbpedia.org/ontology/EndDate/', ?EpEndDate)) AS ?End)
}
Transcription in RDF-Triples with Tarql
A First Request
PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT ?MilitaryConflict ?Participants ?Location
WHERE
{ ?MilitaryConflict dbo:startDate "2001-09-11";
dbo:combattant ?Participants;
dbo:country ?Location;
}
Who participated to the conflict started the 11 september 2001, and who initiated it ?
Result of First Request
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| MilitaryConflict | Participants | Location |
===============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Jordan& Government of Pakistan" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Canada& Government of Denmark& Government of France& Government of Italy& Government of Lithuania& Government of Netherlands& Government of New Zealand& Government of Norway& Government of Pakistan& Government of Poland& Government of Rumania& Government of Slovakia& Government of Spain& Government of United Kingdom" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of France& Government of Jordan& Government of Pakistan" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Australia& Government of Canada& Government of Denmark& Government of France& Government of Germany& Government of Greece& Government of Italy& Government of Japan& Government of Jordan& Government of Lithuania& Government of Netherlands& Government of New Zealand& Government of Norway& Government of Pakistan& Government of Poland& Government of Rumania& Government of Spain& Government of Turkey& Government of United Kingdom" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "al-Qaida" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Belgium& Government of Canada& Government of Croatia& Government of Denmark& Government of Estonia& Government of France& Government of Italy& Government of Kuwait& Government of Netherlands& Government of Norway& Government of Pakistan& Government of Poland& Government of Rumania& Government of Saudi Arabia& Government of Slovakia& Government of Spain& Government of United Kingdom" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Canada& Government of Czech Republic& Government of France& Government of Jordan& Government of Netherlands& Government of Pakistan& Government of Rumania" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Australia& Government of Canada& Government of France& Government of Germany& Government of Italy& Government of Poland& Government of Turkey& Government of United Kingdom" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Pakistan& Government of Saudi Arabia& Government of United Kingdom" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Czech Republic& Government of Pakistan& Government of Rumania" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Pakistan" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Belgium& Government of Canada& Government of Czech Republic& Government of France& Government of Germany& Government of Italy& Government of Pakistan& Government of Poland& Government of Portugal& Government of Rumania& Government of Saudi Arabia& Government of Slovakia& Government of Spain& Government of United Kingdom" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of United States of America" | "United States of America" |
| <http://dbpedia.org/ontology/MilitaryConflict/1-224> | "Government of Afghanistan& Government of Canada& Government of France& Government of Jordan& Government of Netherlands& Government of Pakistan& Government of Rumania" | "United States of America" |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
A Second Request
SELECT ?Country
WHERE{
?MilitaryConflict dbo:startDate ?Start;
dbo:country ?Country.
BIND (URI(CONCAT('http://dbpedia.org/ontology/StartDate/',?Start)) AS ?StartDate)
?StartDate xsd:integer ?prec.
FILTER(?prec > "2")
}
What are the countries that started conflicts that we don't know the exact date ?
Result of the Second Request
Step 2 : shared requests
-----------------------------------------
| ConflictRate | Year1 | country1 |
=========================================
| 3.1480 | "1997" | "Rwanda" |
| 3.4340 | "1992" | "Azerbaijan" |
| 3.4670 | "1999" | "Ethiopia" |
| 3.9650 | "1992" | "Croatia" |
| 4.2960 | "1994" | "Afghanistan" |
| 4.8440 | "1998" | "Afghanistan" |
| 5.3740 | "2000" | "Ethiopia" |
| 5.8440 | "1996" | "Tajikistan" |
| 5.8750 | "2002" | "Liberia" |
| 5.9290 | "1990" | "Ethiopia" |
| 7.8130 | "1992" | "Tajikistan" |
| 8.5130 | "2014" | "Libya" |
| 8.5500 | "2003" | "Liberia" |
| 8.8800 | "1991" | "Somalia" |
| 8.8820 | "1990" | "Lebanon" |
| 10.8830 | "1990" | "Liberia" |
| 37.5340 | "1999" | "Eritrea" |
| 63.5170 | "2011" | "Libya" |
| 82.3170 | "1994" | "Rwanda" |
-----------------------------------------
Step 2 : shared requests
SELECT DISTINCT ?ConflictRate ?Year1 ?country1
WHERE
{
?MilitaryConflict dbo:country ?country1;
dbo:year ?Year1.
?Location owl:sameAs ?country2;
dbpedia:Year ?Year2;
dbpedia:Conflict ?ConflictRate
FILTER (?Year2 = ?Year1 && ?country1=?country2
&& (xsd:decimal(?ConflictRate) > 3) ).
}
ORDER BY ?ConflictRateLinked with Global causes of mortality by countries of conflicts.
Step 3 : Inferences
We create our classes with Protege.
For each class, we create some instances and we add links between them using Object Properties.
We activate the reasoner to see inferences.
We can see that Protege add some properties with Inferences.
Step 4 : Link to the Cloud
Datawar
Has Equivalences With
Specializes
schema
dqm
dbpedia-owl
Pext
Step 5 : Description with VOID Vocabulary
We describe our datasets with VOID Vocabulary