forked from the-qa-company/2022-04-12-SEMIC-Workshop
-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathindex.html
358 lines (349 loc) · 17.3 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<title>The EU Knowledge Graph</title>
<link rel="stylesheet" href="dist/reset.css">
<link rel="stylesheet" href="dist/reveal.css">
<link rel="stylesheet" href="dist/theme/white.css">
<!-- Theme used for syntax highlighted code -->
<link rel="stylesheet" href="plugin/highlight/monokai.css">
</head>
<body>
<div class="reveal">
<header style="position: absolute;top: 50px; left: 100px; z-index:500; font-size:100px;background-color: rgba(0,0,0,0.5)"></header>
<div class="slides">
<!-- First slide -->
<section ch="-1" style="position: relative; height: 100%;">
<h3 style="color: rgb(10,100,147); margin: 5%">The EU Knowledge Graph</h3>
<h4 style="color: rgb(10,100,147); margin: 5%">For structured information<br>about the European Union</h4>
<div style="font-size: 25px; padding-top: 10px;">Max De Wilde<br>Data Oriented Services (DORIS)<br>CNECT.R3</div>
<div style="font-size: 25px; padding-top: 50px;">@ Co-innovation iTalks series</div>
<div style="font-size: 25px; padding-top: 25px;">11.05.2023</div>
<!--<img src="http://commons.wikimedia.org/wiki/Special:FilePath/European%20Commission.svg" style="margin-top: 5%; height: 100px; border: none; box-shadow: none;">-->
<!--<h4>From BibTeX input:</h4>-->
<div id="key1" class="cite" data-type="bib" ></div>
<div id="key2" class="cite" data-type="bib" ></div>
</section>
<!-- Outline -->
<section ch="0">
<h2>Outline</h2>
<ol>
<li><a href="#/wikibase"><div style="display: inline-block; background: darkcyan; width: 35px; height: 35px"></div> Wikibase</a></li>
<li><a href="#/eukg"><div style="display: inline-block; background: rebeccapurple; width: 35px; height: 35px"></div> The EU Knowledge Graph</a></li>
<li><a href="#/kohesio"><div style="display: inline-block; background: #cd0027; width: 35px; height: 35px"></div> Kohesio</a></li>
<li><a href="#/usecases"><div style="display: inline-block; background: orange; width: 35px; height: 35px"></div> Other use cases</a></li>
</ol>
</section>
<section ch="1" id="wikibase">
<h2>What is Wikibase?</h2>
</section>
<section ch="1">
<div>The Wikimedia Foundation hosts many wikis...</div>
<img src="assets/wikimedia_projects.png" style="width: 60%;">
</section>
<section ch="1" data-background-iframe="https://www.wikidata.org/wiki/Q458" data-background-interactive>
<div style="margin-bottom: 90%">Wikidata is one of them</div>
</section>
<section ch="1" data-background-iframe="https://wikiba.se" data-background-interactive>
<div style="margin-bottom: 90%">Wikibase is the software behind Wikidata</div>
</section>
<section ch="1" >
<div>Architecture</div>
<img src="assets/wikibase_architecture.png" style="width: 80%;">
</section>
<section ch="1" >
<div>Docker image</div>
<img src="assets/wikibase_docker.png" style="width: 80%;">
</section>
<section ch="1" >
<div>Comparison with other solutions</div>
<img src="assets/classical_vs_wikibase.png" style="width: 70%;">
<div style="font-size: 15pt">Source: Dennis Diefenbach, Max De Wilde and Samantha Alipio (ISWC 2021)<br><a href="https://hal.archives-ouvertes.fr/hal-03353225/document">Wikibase as an Infrastructure for Knowledge Graphs: the EU Knowledge Graph</a></div>
</section>
<section ch="2" id="eukg">
<h2>The EU Knowledge Graph<div style="vertical-align: top; font-size: smaller; display: inline;"></div></h2>
</section>
<section ch="2">
<div>A repository to store structured information<br>about the European Union</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/The_EU_Knowledge_Graph" data-background-interactive>
<div style="margin-bottom: 90%"><a href="https://linkedopendata.eu/">https://knowledgegraph.eu/</a> </div>
</section>
<section>
<section ch="2">
<h3> Why use Wikibase?</h3>
</section>
<section ch="2">
<div>User-friendly interface</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q1" data-background-interactive>
</section>
<section ch="2">
<div>Graph structure</div>
</section>
<section ch="2" data-background-iframe="https://query.wikidata.org/embed.html#%23defaultView%3AGraph%0ASELECT%20%3Fitem%20%3FitemLabel%0AWHERE%0A%7B%0A%20%20%3Fitem%20%3FpDirect%20%3FlinkTo%20.%0A%20%20VALUES%20%3Fitem%20%7B%20wd%3AQ458%20%7D%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel%20.%0A%20%20FILTER%28lang%28%3FitemLabel%29%3D%22en%22%29%0A%7D" data-background-interactive>
</section>
<section ch="2">
<div>Can be queried</div>
</section>
<section ch="2" data-background-iframe="https://query.linkedopendata.eu/#%20SELECT%20DISTINCT%20%3Fcountry%20%3Fpopulation%20WHERE%20%7B%20%0A%20%20%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fentity%2FQ1%3E%20%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fprop%2Fdirect%2FP104%3E%20%20%3Fo1%20.%20%0A%20%20%20%3Fo1%20rdfs%3Alabel%20%3Fcountry%20.%0A%20%20%20FILTER%20%28lang%28%3Fcountry%29%3D%22en%22%29%0A%20%20%20%3Fo1%20%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fprop%2Fdirect%2FP9%3E%20%20%3Fpopulation%20.%20%0A%20%7D%20%20order%20by%20desc%28%3Fpopulation%29" data-background-interactive>
</section>
<section ch="2">
<div>Can be edited by humans and by bots</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q1" data-background-interactive>
</section>
<section ch="2">
<div>Scales well</div>
</section>
<section ch="2">
<div>Wikibase hosts Wikidata, one of the largest existing KG which contains billions of triples</div>
</section>
<section ch="2">
<div>Multilingual</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q1" data-background-interactive>
</section>
<section ch="2">
<div>Full track of changes</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q74781" data-background-interactive>
</section>
</section>
<section>
<section ch="2">
<h3>Current content</h3>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q65" data-background-interactive>
<div style="margin-bottom: 90%">European institutions</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q23" data-background-interactive>
<div style="margin-bottom: 90%">European countries</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q52" data-background-interactive>
<div style="margin-bottom: 90%">Capital cities</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q131" data-background-interactive>
<div style="margin-bottom: 90%">Heads of States</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q8361" data-background-interactive>
<div style="margin-bottom: 90%">DGs</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q244787" data-background-interactive>
<div style="margin-bottom: 90%">Buildings and canteens</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q19837" data-background-interactive>
<div style="margin-bottom: 90%">Projects funded by the EU</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q214193" data-background-interactive>
<div style="margin-bottom: 90%">Beneficiaries of EU funds</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q2837746" data-background-interactive>
<div style="margin-bottom: 90%">Linked Data solutions</div>
</section>
</section>
<section>
<section ch="2">
<h3>Importing data</h3>
</section>
<section ch="2">
<h3>1. Take any structured data</h3>
<img src="assets/buildings.png" style="width: 80%;">
</section>
<section ch="2">
<h3>2. Model the data</h3>
<ul>
<li>We need entities like buildings, offices...</li>
<li>We need properties like address, opening hours, occupant...</li>
<li>Whenever possible, reuse Wikidata entities/properties or other existing ones</li>
</ul>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q244596" data-background-interactive>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Property:P641" data-background-interactive>
</section>
<section ch="2">
<h3> 3. Keep identifiers</h3>
<div> Use external identifiers so that one can use them to link to other resources!</div>
</section>
<section ch="2">
<h3> 4. Import using Wikibase APIs</h3>
<div> We always use Pywikibot</div>
<div> But there are alternatives...</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q242378" data-background-interactive>
</section>
<section ch="2">
<div> The data imported is understandable, aligned with existing concepts, queryable, and easy to reuse</div>
</section>
<section ch="2">
<div> But DG REGIO moved to another building!<br>How to stay in line with reality?</div>
</section>
</section>
<section>
<section ch="2">
<h3> Keeping the data in sync</h3>
</section>
<section ch="2" data-background-iframe="https://www.wikidata.org/wiki/Q38" data-background-interactive>
<div style="margin-bottom: 90%">Wikidata</div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q15" data-background-interactive>
<div style="margin-bottom: 90%">EU Knowledge Graph</div>
</section>
<section ch="2">
<h3> For this we use Wikibase Sync</h3>
<a href="https://github.com/the-qa-company/WikibaseSync" target="_blank">https://github.com/the-qa-company/WikibaseSync</a>
</section>
<section ch="2">
<h3>What is it?</h3>
<div>Similar to WikibaseImport but...</div>
<ol>
<li>you can run it locally</li>
<li>it can sync items and properties</li>
<li>local changes are not overwritten</li>
</ol>
</section>
<section ch="2">
<h3 style="text-transform: none;">WikibaseUpdater</h3>
<ul>
<li>A bot based on WikibaseSync that checks that the data is synchronised</li>
<li>Refreshed every 5 minutes</li>
</ul>
</section>
</section>
<section>
<section ch="2">
<h3>Services provided</h3>
</section>
<section ch="2">
<h3> Data exports</h3>
<div>Available at <a href="https://data.linkedopendata.eu">https://data.linkedopendata.eu</a></div>
</section>
<section ch="2" data-background-iframe="https://linkedopendata.eu/data/" data-background-interactive>
</section>
<section ch="2">
<h3> Query service</h3>
<div>SPARQL endpoint</div>
<div>Available at <a href="https://query.linkedopendata.eu">https://query.linkedopendata.eu</a></div>
</section>
<section ch="2" data-background-iframe="https://query.linkedopendata.eu/#%23defaultView%3AMap%20%0ASELECT%20DISTINCT%20%3Fs1%20%3Fcoordinates%20WHERE%20%7B%0A%20%20%20%20%20%3Fs1%20%20%3Fp1%20%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fentity%2FQ63%3E%20.%20%0A%09%20%3Fs1%20%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fprop%2Fdirect%2FP35%3E%20%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fentity%2FQ8636%3E%20.%20%0A%20%20%20%20%20%3Fs1%20%3Chttps%3A%2F%2Flinkedopendata.eu%2Fprop%2Fdirect%2FP127%3E%20%3Fcoordinates%20.%0A%20%7D%20%20LIMIT%201000" data-background-interactive>
</section>
<!--<section ch="2">
<h3> 3. Question Answering</h3>
<div>Allows to explore the data using natural language</div>
<div>Available at <a href="https://qa.linkedopendata.eu">https://qa.linkedopendata.eu</a></div>
</section>
<section ch="2" data-background-iframe="https://qa.linkedopendata.eu/qa/full?query=buildings%20by%20dg%20connect&tags=%5B%5D&lang=en&kb=eu&user=commission" data-background-interactive>
</section>
<section ch="2" data-background-iframe="https://qa.linkedopendata.eu/qa/full?query=who%20is%20the%20president%20of%20france&tags=%5B%5D&lang=en&kb=eu&user=commission" data-background-interactive>
</section>
<section ch="2" data-background-iframe="https://qa.linkedopendata.eu/qa/full?query=who%20is%20the%20director%20of%20dg%20connect&tags=%5B%5D&lang=en&kb=eu&user=commission" data-background-interactive>
</section>
<section ch="2">
<h3> Can be integrated in chatbots</h3>
<div>Available at <a href="https://chatbot.cnect.eu/">https://chatbot.cnect.eu/</a></div>
</section>
<section ch="4" data-background="assets/dori.png">
</section>-->
</section>
<section ch="3" id="kohesio">
<h2>Use case: Kohesio</h2>
<h3>Transparent communication on projects co-funded by the EU</h3>
</section>
<!--<section ch="3">
<h2>EU Cohesion Policy</h2>
<ul>
<li>EU Cohesion Policy supports every year tens of thousands of projects across Europe</li>
<li>Cohesion Policy makes up approximately 32.5 % of the EU budget 2014-2020 (about 350 billion euros)</li>
</ul>
</section>-->
<section ch="3">
<h2>What is Kohesio?</h2>
<ul>
<li>Cohesion funds are managed together with national and local authorities in the 27 EU member states</li>
<li>The member states have a legal obligation to publish the list of projects and beneficiaries on their national websites</li>
<li>The goal of Kohesio is to aggregate this data and make it publicly available in an easy, open way</li>
</ul>
</section>
<section ch="3">
<h2>Data sources</h2>
<ol>
<li>Dozens of Excel files describing the projects</li>
<li>Additional vocabularies specific to Cohesion Policy: categories of intervention, thematic objectives, etc.</li>
<li>Data about geographic entities (NUTS)</li>
<li>Wikidata</li>
</ol>
</section>
<section ch="3" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q3139917" data-background-interactive>
</section>
<section ch="3">
<h2>Enriching the data</h2>
<ol>
<li>Translating project labels and descriptions</li>
<li>Computing location on the map (geocoding)</li>
<li>Inferring the NUTS region</li>
<li>Linking beneficiaries to Wikidata</li>
</ol>
</section>
<section ch="3" data-background-iframe="https://linkedopendata.eu/wiki/Item:Q3139917" data-background-interactive>
</section>
<section ch="3">
<h2>Building a website on top</h2>
<div>Available at <a href="https://kohesio.ec.europa.eu/">https://kohesio.ec.europa.eu/</a> </div>
</section>
<section ch="3" data-background-iframe="https://kohesio.ec.europa.eu/en/" data-background-interactive>
</section>
<!--<section ch="3">
<h2>To summarize</h2>
<ol>
<li>We integrated structured data from different sources into one uniform model</li>
<li>The data is enriched in various ways, thereby increasing its value</li>
<li>The data is openly accessible by citizens, showing the impact of EU funds in their region</li>
</ol>
</section>-->
<section id="usecases" ch="4">
<h2>Other use cases</h2>
<ul>
<li>with OP: linking more vocabularies like Eurovoc</li>
<li>with RTD: closer integration with Horizon projects</li>
<li>with Eurostat: Local Administrative Units (LAUs)</li>
<li>with OIB: historical archives about organisations</li>
<li>with GROW: platform for single market obstacles</li>
</ul>
</section>
<section id="usecases" ch="4">
<div>More ideas welcome but we need to prioritise! 😊</div>
</section>
<section ch="0">
<h3>Acknowledgements</h3>
<ul>
<li>Dennis Diefenbach @ The QA Company</li>
<li>Knowledge Management Team @ DG REGIO</li>
<li>Wikimedia Deutschland (WMDE)</li>
</ul>
</section>
<section ch="-1">
<div>Thank you! Questions?</div>
</section>
</div>
</div>
<script src="dist/reveal.js"></script>
<script src="plugin/notes/notes.js"></script>
<script src="plugin/markdown/markdown.js"></script>
<script src="plugin/highlight/highlight.js"></script>
<script>
// More info about initialization & config:
// - https://revealjs.com/initialization/
// - https://revealjs.com/config/
Reveal.initialize({
hash: true,
slideNumber: true,
preloadIframes: true,
// Learn about plugins: https://revealjs.com/plugins/
plugins: [ RevealMarkdown, RevealHighlight, RevealNotes ]
});
</script>
</body>
</html>