1
00:00:00,000 --> 00:00:22,680
Music
2
00:00:22,680 --> 00:00:26,910
Herald: We'll do some live querying with him
so you were told to think of some ideas that
3
00:00:26,910 --> 00:00:32,620
we could search for in Wikidata and when
we get to that point I would ask you to
4
00:00:32,620 --> 00:00:36,690
raise your hand and wait till I get to you
with the microphone so that the people in
5
00:00:36,690 --> 00:00:44,379
the stream can also hear what we're
talking about so that's the thing I'll go
6
00:00:44,379 --> 00:00:48,580
back to Lucas and we still have
translations. Wenn ihr es auf deutsch hören wollt
7
00:00:48,580 --> 00:00:58,120
wir haben immen noch Übersetzter, die alles versuchen
es Euch nochmal auf Deutsch zu erzählen. Also hört mal rein.
8
00:00:58,120 --> 00:01:10,449
Lucas: Does anyone have a query?
Yes, in the front there. We have a question allready.
9
00:01:10,449 --> 00:01:13,881
Audience member: Is it possible to find all circular family trees?
10
00:01:13,881 --> 00:01:15,080
L: All circular what?
11
00:01:15,080 --> 00:01:19,895
AM: Family trees
L: It's certainly possible to find
12
00:01:19,895 --> 00:01:23,800
some. Finding all it's probably going to
be a timeout but there would be something
13
00:01:23,800 --> 00:01:35,020
like select, probably child would be
the simplest, so item child plus item
14
00:01:35,020 --> 00:01:39,170
again. So if we put the star like earlier
then you could then every Tree would
15
00:01:39,170 --> 00:01:44,043
match that, but with the plus it means it
has to be at least one child link or more,
16
00:01:44,043 --> 00:01:48,740
and let's just add a "limit 1" because I'm
not that optimistic that this is even
17
00:01:48,740 --> 00:01:54,120
going to find one, but I'm pretty sure we
cannot find all of them, but let's see if
18
00:01:54,120 --> 00:02:03,810
we can find one and this might just take a
while, but I don't think there is a good
19
00:02:03,810 --> 00:02:09,619
way to do this otherwise unless you
download one of the dumps either the JSON
20
00:02:09,619 --> 00:02:13,870
data dumps or the RDF dumps which is the
same data format used here and then you
21
00:02:13,870 --> 00:02:21,170
can do it locally without an timeout.
I don't think there's much I can optimize
22
00:02:21,170 --> 00:02:28,599
about this query is pretty short unless
like I had an idea that people named John
23
00:02:28,599 --> 00:02:33,849
are more likely to have these kinds of
cycles, then we could filter it down first
24
00:02:33,849 --> 00:02:51,560
but you men. I'm afraid that is not going
to work it looks like. Yes, timeout. And
25
00:02:51,560 --> 00:02:58,900
you can see the thing is written in Java
the server dragazines. One thing we
26
00:02:58,900 --> 00:03:03,340
can do with this "P40+" is something like
search start with a certain mythical
27
00:03:03,340 --> 00:03:14,790
creature such as King Arthur. I hope I can
find him like this. Search is being alright
28
00:03:14,790 --> 00:03:21,910
3d map of EDT. There we go, that's the
legendary British or Welsh king and then
29
00:03:21,910 --> 00:03:26,970
we are searching for an item who is
definitely a real human and who has a date
30
00:03:26,970 --> 00:03:41,090
of birth and we say the date of birth
should be greater than at say 1950 and
31
00:03:41,090 --> 00:03:51,349
this is a date time value and this let's
even say 1980. I think that might be
32
00:03:51,349 --> 00:03:57,569
No more efficient. There we go. No
results, okay. I thought King Arthur had
33
00:03:57,569 --> 00:04:05,590
some real descendants. Though then it was
some other mythical creatures. Let's just
34
00:04:05,590 --> 00:04:14,050
start with any ancestor who has the item
as child and the ancestor is also instance
35
00:04:14,050 --> 00:04:23,050
of mythical creature, mythical character.
Let's see if we have any mythical
36
00:04:23,050 --> 00:04:30,460
characters with children who are born
after 1950. Oh I still have the "limit 1"
37
00:04:30,460 --> 00:04:35,199
here could make that a "limit 10" probably
or something, but I'm optimistic I think
38
00:04:35,199 --> 00:04:38,860
there are some people here, especially, I
think, even British MPs, there's some
39
00:04:38,860 --> 00:04:41,669
that's already on the list of example
queries British MPs with mythical
40
00:04:41,669 --> 00:04:47,610
ancestors and there's lovely have traced
their lineage back to some 6th or 5th
41
00:04:47,610 --> 00:04:54,870
century person and you have all the
apparent links in there and then it's kind
42
00:04:54,870 --> 00:04:59,560
of tricky to figure out where it starts
being wrong. Oh that's not working out so
43
00:04:59,560 --> 00:05:13,085
well. Does anyone else have ideas in the
meantime? There, way in the back.
44
00:05:13,085 --> 00:05:15,340
Someone: Thank you
Audience member: We all know that stupid
45
00:05:15,340 --> 00:05:20,270
game in Wikipedia where you try to find
the Adolf Hitler page by only clicking
46
00:05:20,270 --> 00:05:26,120
links, so can you find the number of pages
that are directly connected to the Adolf
47
00:05:26,120 --> 00:05:33,450
Hitler page in Wikipedia?
L: You can. Oh that was a timeout, dammit.
48
00:05:33,450 --> 00:05:39,790
So that would be kind of ... It's a one funny
story about that for example is there's
49
00:05:39,790 --> 00:05:45,360
the first example we
have here is cats and why do we have cats
50
00:05:45,360 --> 00:05:51,050
and not dogs? Because if you search for
dogs the second result, no, it's the
51
00:05:51,050 --> 00:05:54,130
fourth result by now, but that's the
thought of Hitler and we don't really want
52
00:05:54,130 --> 00:05:59,600
that and normally so we usually use cats
as the example instead but let's just
53
00:05:59,600 --> 00:06:06,250
search for anything where the item has any
connection and we don't care which
54
00:06:06,250 --> 00:06:17,740
property it is to Adolf Hitler, like that,
and we are going to find 920 results. ok
55
00:06:17,740 --> 00:06:28,230
some of these are site links so we also
want the item to have some label which
56
00:06:28,230 --> 00:06:36,169
uses this new namespace and we want only
the English label so the language of the
57
00:06:36,169 --> 00:06:43,419
label should be in English and we then we
just select the item and the label and
58
00:06:43,419 --> 00:06:47,570
hopefully that's still pretty efficient.
Here we go NSDAP membership number
59
00:06:47,570 --> 00:06:54,289
that's actually a property but I assume it
has as the example yep there's a property
60
00:06:54,289 --> 00:07:01,039
example here as NSDAP number 1. World War
two has probably of cause of death do we
61
00:07:01,039 --> 00:07:08,190
have him as an example on cause of death
really? and we have nitric acid poisoning,
62
00:07:08,190 --> 00:07:16,229
stroke, cholera, shot to the head, cyanide
poisoning, hanging, That's a very pleasant
63
00:07:16,229 --> 00:07:21,039
list. Do we need to have that many
projects handfuls of closet yeah then we
64
00:07:21,039 --> 00:07:26,229
have Nazi Party, Klara Hitler, I don't
know who that is, 1936 Summer Olympics,
65
00:07:26,229 --> 00:07:31,630
all kinds of things, so that's how
you can find all the things with a direct
66
00:07:31,630 --> 00:07:43,150
connection to Hitler. Any other
examples? Yes, over there in the right, or
67
00:07:43,150 --> 00:07:48,900
was there already somewhere someone back
there that I missed
68
00:07:48,900 --> 00:07:52,620
AM: Can you find the
cheapest public infrastructure projects in
69
00:07:52,620 --> 00:07:54,870
Germany?
L: The cheapest public infrastructure
70
00:07:54,870 --> 00:07:56,870
what?
AM: Projects
71
00:07:56,870 --> 00:07:58,960
L: Projects
AM: Like a bridge building
72
00:07:58,960 --> 00:08:03,910
L: I don't think we're going to have a
full dataset about that but you can try.
73
00:08:03,910 --> 00:08:07,620
Let's start with a more expensive one and
[crackling noise]
74
00:08:07,620 --> 00:08:14,889
L: see - perhaps move away from the box,
that might help. Let's start with a very
75
00:08:14,889 --> 00:08:19,669
expensive project and see just what the
data model looks like so what does
76
00:08:19,669 --> 00:08:24,349
infrastructure project look like what's
what was the cost so the cost is probably
77
00:08:24,349 --> 00:08:29,800
going to be in euro and I don't know how
to write here over there okay it's a
78
00:08:29,800 --> 00:08:36,389
property called cost in Euro and does it
have something like instance of
79
00:08:36,389 --> 00:08:40,099
international airport, building under
construction, Greenfield Airport, proposed
80
00:08:40,099 --> 00:08:52,980
airport being built, so we could check
first is Berlin Brandenburg Airport, is
81
00:08:52,980 --> 00:09:03,249
that an instance of some subclass of
public infrastructure? Is that a thing?
82
00:09:03,249 --> 00:09:13,050
that looks like the wrong item what is
this this is nothing. Okay. There's anything
83
00:09:13,050 --> 00:09:20,310
linked to this item? no nothing like
suicide. Okay. So it could be an
84
00:09:20,310 --> 00:09:25,910
international airport is a subclass of
airport which is a subclass of an
85
00:09:25,910 --> 00:09:34,649
aerodrome which is an architectural
structure, and we can search for
86
00:09:34,649 --> 00:09:42,899
architectural structures, so the structure
would be an instance of subclass of
87
00:09:42,899 --> 00:09:54,769
architectural structure, and it would have
a cost, and order by the singing costs I
88
00:09:54,769 --> 00:10:02,319
think it's 10 and we're probably going to
get things in like yen or some other
89
00:10:02,319 --> 00:10:07,850
currency where this number is just going
to be very high because we're not taking
90
00:10:07,850 --> 00:10:15,980
any conversions into account right now but
let's see if we find something there. What
91
00:10:15,980 --> 00:10:26,779
is it doing? Okay... not sure why this is
taking so long. Let's try a second version
92
00:10:26,779 --> 00:10:42,949
in the mean time where we quantity amount
is cost and various quantities units
93
00:10:42,949 --> 00:10:57,009
should be the euro they're still running
and yeah let's try this that works any
94
00:10:57,009 --> 00:11:08,899
better or not? Okay, this was a timeout. This
looks like it's going to be a timeout as
95
00:11:08,899 --> 00:11:16,220
well. I don't know, we can just search for
the most expensive things at all. Remove
96
00:11:16,220 --> 00:11:27,899
this part, there we go. This costs 55
billion euros. What is this thing? Power
97
00:11:27,899 --> 00:11:39,689
of Siberia, natural gas pipeline. That's,
that's in euro, the costs? Apparently. And
98
00:11:39,689 --> 00:11:44,589
then this is 15 billion euros and then
8.77 find something that's the channel, oh
99
00:11:44,589 --> 00:11:49,059
the Channel Tunnel is expensive. The
Brenner Tunnel was also expensive.
100
00:11:49,059 --> 00:11:54,709
laughter
And Stuttgart 21 took about 21 whatever
101
00:11:54,709 --> 00:12:00,989
was also- or is projected to be expensive.
Do we have one cost or several? Okay in
102
00:12:00,989 --> 00:12:06,829
2018 we have a cost of 7 billion. Yeah, so
let's sort by the ascending constant set
103
00:12:06,829 --> 00:12:10,949
because that was what we actually wanted
and then we get... okay now we're going to
104
00:12:10,949 --> 00:12:16,139
get a lot of things that aren't really
infrastructure projects we have the whole
105
00:12:16,139 --> 00:12:24,000
and a hot and energetic universe. Does
that mean it's a no budget film or what?
106
00:12:24,000 --> 00:12:30,609
Okay. So we would need some kind of ...
Let's say, let's do duck typing instead of
107
00:12:30,609 --> 00:12:35,239
saying it is an infrastructure project,
let's say it has, I don't know, a
108
00:12:35,239 --> 00:12:40,279
coordinate location. And if it has a
coordinate location, we're going to call
109
00:12:40,279 --> 00:12:42,810
it some kind of infrastructure project, or
at least it's not going to be a
110
00:12:42,810 --> 00:12:49,110
documentary film. Perhaps that works
better. Yeah, so 21,000 euros cost this
111
00:12:49,110 --> 00:13:00,350
thing which was in France. Oh, okay,
right, it should also be country Germany.
112
00:13:00,350 --> 00:13:10,540
Here we go. That's 400,000 euros for
fountain in Stuttgart. Does that count? I
113
00:13:10,540 --> 00:13:14,450
guess. And that's the engines of something
it doesn't even have a German la- an
114
00:13:14,450 --> 00:13:21,879
English label, just a German one. Wait...
Oh, so this is the class of all the
115
00:13:21,879 --> 00:13:27,259
fountains with exactly this name which are
a subclass of well and are all named after
116
00:13:27,259 --> 00:13:37,389
this goddess, okay, cool. Yeah so then we
have some of these cheap projects, which
117
00:13:37,389 --> 00:13:42,829
is… this public square… a bridge – oh
yeah, there's this tiny bridge, a
118
00:13:42,829 --> 00:13:52,629
footbridge, has even an image, that's what
it looks like, and it costs, what was it,
119
00:13:52,629 --> 00:13:59,399
1.6 million euros already. Wow. And then
we have another public square. Yeah. So,
120
00:13:59,399 --> 00:14:08,851
"cheap public infrastructure projects".
And also probably "infrastructure" in
121
00:14:08,851 --> 00:14:12,649
quotes, because we're really just saying
it has a location and "Country: Germany".
122
00:14:12,649 --> 00:14:19,939
And, yeah, I can send this query around
afterwards. And this didn't work, this
123
00:14:19,939 --> 00:14:33,079
didn't work. Okay, any other ideas? That's
bad news. We could try to continue with
124
00:14:33,079 --> 00:14:40,809
some of these. Was there something? Oh,
from the Camera Angel!
125
00:14:40,809 --> 00:14:45,689
AM: I have a question! I saw that with
Wikidata Query Service we can draw these
126
00:14:45,689 --> 00:14:53,049
nice trees and have images in them, and
one example that came to my mind was all
127
00:14:53,049 --> 00:14:59,149
the programming patterns – programming
design patterns, but grouped by their
128
00:14:59,149 --> 00:15:05,569
kind, like they're structural patterns,
convenience patterns, and so on, and like,
129
00:15:05,569 --> 00:15:08,499
can we draw a graph and maybe put an image
in them.
130
00:15:08,499 --> 00:15:12,929
L: We can try that. So let's see how
that's modeled, I don't know, with the
131
00:15:12,929 --> 00:15:20,899
visitor pattern for example. That's a
design pattern what kind of statements
132
00:15:20,899 --> 00:15:24,749
does have. It's a subclass of behavioral
pattern, is this a programming thing or
133
00:15:24,749 --> 00:15:32,690
already…? Oh yeah it's a soft… okay it's a
software design pattern. So we should say ...
134
00:15:32,690 --> 00:15:40,980
We're going to have a pattern with
its label and a pattern kind with its
135
00:15:40,980 --> 00:15:51,389
label and the pattern is going to be a
subclass of the pattern kinds, which is
136
00:15:51,389 --> 00:16:02,230
going to be some subclass of – what was
it? Of software design pattern – and I'm
137
00:16:02,230 --> 00:16:08,689
just going to copy this ID so it's the
right one – label service, and say, I
138
00:16:08,689 --> 00:16:15,509
would like to see this by default in the
graph view. Here we go. Well that looks
139
00:16:15,509 --> 00:16:19,619
not as bad as I thought. We have a lot of
structural patterns, behavioral patterns,
140
00:16:19,619 --> 00:16:25,319
one architectural pattern, a few
creational patterns, and one fundamental
141
00:16:25,319 --> 00:16:37,239
pattern. Yeah. And… yeah what we could
also do is, if we do this, then we should
142
00:16:37,239 --> 00:16:42,429
also see connections of all of these.
Now we have the tree rooted at
143
00:16:42,429 --> 00:16:46,910
software design patterns, we have monads,
and fundamental pattern is a kind of
144
00:16:46,910 --> 00:16:50,419
software design pattern. Structural
pattern… and it's all linked there and
145
00:16:50,419 --> 00:16:56,129
this is working… very well, I… That's much
better than I expected. I expected a huge
146
00:16:56,129 --> 00:17:00,889
mess of… because it sometimes gets
different to determine when should you use
147
00:17:00,889 --> 00:17:04,709
"instance of" and when should use
"subclass off", like if it's software or
148
00:17:04,709 --> 00:17:08,250
patterns like this, I expected we would
have to account for both of these, but
149
00:17:08,250 --> 00:17:14,000
this looks very good to me. I think we
don't need to do anything with this query.
150
00:17:14,000 --> 00:17:28,350
Yeah, so that is, uhm, software design
patterns by a pattern tree.
151
00:17:28,350 --> 00:17:41,253
Okay. Any other ideas? Or I can try to
keep optimizing this one
152
00:17:41,253 --> 00:17:45,940
AM: Which cities have applied to be host
city of the Eurovision Song Contest the
153
00:17:45,940 --> 00:17:48,720
most times but were never successful?
L: Oh!
154
00:17:48,720 --> 00:17:52,590
Laughter from Audience
L: That's a very good question. I don't
155
00:17:52,590 --> 00:17:58,259
know if we have– do you know who applied
for this year or for some year? But I
156
00:17:58,259 --> 00:18:09,390
could check if the state if that's modeled
anywhere. Uhm, I need some example cities
157
00:18:09,390 --> 00:18:20,059
so… let's check ESC 2018 if it has
information on where it took place, which
158
00:18:20,059 --> 00:18:25,580
one won the bid, but also who was
nominated or something, or who applied… We
159
00:18:25,580 --> 00:18:29,580
have "presenters", we have "followed by ",
"start time", "end time", "participants",
160
00:18:29,580 --> 00:18:41,820
we have the winner, do we have a location
at all? Oh yeah, there it is. Okay, we
161
00:18:41,820 --> 00:18:48,490
have a country, and a location, but I'm
not seeing any other countries here, and I
162
00:18:48,490 --> 00:18:55,179
assume that information is not going to be
on the country item. It's possible that we
163
00:18:55,179 --> 00:19:06,429
have some separate item for "Eurovision
2018 Bid" or… Well wait, it would have to
164
00:19:06,429 --> 00:19:11,320
be "which city", because the country is
determined by the winner isn't it? So the
165
00:19:11,320 --> 00:19:21,600
city, but I suspect we don't have that
information. We have a list of host
166
00:19:21,600 --> 00:19:31,080
cities, but that's just… a Wikipedia list
article.
167
00:19:31,080 --> 00:19:41,050
Interference noise
Do we have to switch to the other mic? Oh
168
00:19:41,050 --> 00:19:45,820
no, that sounds great! Okay. Yeah, so we
don't have any of the structured
169
00:19:45,820 --> 00:19:49,910
information here. It's just linking all of
these Wikipedia articles together, and
170
00:19:49,910 --> 00:19:55,841
then here is the actual list with the
different venues. But I don't think we
171
00:19:55,841 --> 00:20:00,019
have that information in Wikidata at the
moment. We could add it, you'd have to
172
00:20:00,019 --> 00:20:04,460
figure out the data model, but it would
probably be relevant enough, I think.
173
00:20:04,460 --> 00:20:12,840
I wonder if we have that for the Olympic
Games. So, Olympics 2020, do we have the
174
00:20:12,840 --> 00:20:28,200
process of who applied to host those? Uhm.
We have a location. We have parts. Let's
175
00:20:28,200 --> 00:20:33,130
check. Perhaps English Wikipedia has a
separate article about the selection
176
00:20:33,130 --> 00:20:44,370
process for the 2020 Summer Olympics.
Doesn't look like it. "Host city
177
00:20:44,370 --> 00:20:49,720
selection". No I don't see a main… oh no,
there! "Bids for the 2020 Summer
178
00:20:49,720 --> 00:20:53,490
Olympics", that's the Wikipedia article.
Does that have any useful information on
179
00:20:53,490 --> 00:21:02,350
Wikidata? Bids for Olympic Games no.
Damnit. So you can see, when these bids
180
00:21:02,350 --> 00:21:08,419
all happened, but we don't have the
bidding countries and cities apparently on
181
00:21:08,419 --> 00:21:20,579
Wikidata, at least not as far as I can
see. Bids for the… 2012 for example…
182
00:21:20,579 --> 00:21:30,530
No, sadly, we don't have that information
yet. Did this one run by way? No.
183
00:21:30,530 --> 00:21:34,563
Any other questions?
Herald: Our translation angels had a question.
184
00:21:34,563 --> 00:21:39,409
H: They want to know, if can give them the
countries with the most colorful flags
185
00:21:39,409 --> 00:21:53,070
L: Yes! That [interference noise] should
be possible. So "select country", and the
186
00:21:53,070 --> 00:21:59,970
"count of the colors as counts"
[interference noise] the country has,
187
00:21:59,970 --> 00:22:13,059
oops, has a flag, not the "flag image", a
flag, and the flag has color. And it
188
00:22:13,059 --> 00:22:18,370
should be "color" and not "colors", and
then we group by country so this is a bit
189
00:22:18,370 --> 00:22:21,580
like a [noise] grouping and aggregate
functions
190
00:22:21,580 --> 00:22:31,889
[Interference noise]
Interferene noise*
191
00:22:31,889 --> 00:22:48,600
Do we need to use the other microphone?
[Noise] Okay [Noise] But then you can't
192
00:22:48,600 --> 00:23:05,649
really walk around anymore.
H: Hello hello? Hello hello? Muss man da
193
00:23:05,649 --> 00:23:18,800
noch was machen?
L: Okay so now… This could be really fun!
194
00:23:18,800 --> 00:23:22,350
Yeah, so we are searching for countries
with flags, and hope that the flags have
195
00:23:22,350 --> 00:23:33,139
colors and been counting them, and what I
didn't do is… what's this? Do I want to
196
00:23:33,139 --> 00:23:39,960
know? Okay, okay it's at least it's not
the straight pride flag, I guess. Does
197
00:23:39,960 --> 00:23:43,809
this have 14 colors? No, what was it? No,
eight, I guess, one, two, three, four,
198
00:23:43,809 --> 00:23:47,130
five, six, seven, eight, yeah. That's
accurate. Yeah, I didn't filter for
199
00:23:47,130 --> 00:23:54,850
countries here, the thing is, country is
really a stupidly complicated term, so
200
00:23:54,850 --> 00:24:03,129
what I did was… queries… I have a pre-
prepared query for the UN member states
201
00:24:03,129 --> 00:24:16,980
somewhere, which I just copy all the time.
And this is now going to be called a
202
00:24:16,980 --> 00:24:25,850
state, and then we only get state flags,
uhm, and there's exactly– oh, right. I
203
00:24:25,850 --> 00:24:39,250
need to group by "state" and "state label"
and copy these up here as well, and then
204
00:24:39,250 --> 00:24:50,440
it will hopefully work, and we will find
out that… the United Kingdom has… 12?
205
00:24:50,440 --> 00:24:55,929
I suspect that's because it has four flags,
which all have the same rank, or a no– no
206
00:24:55,929 --> 00:25:01,029
it should be five, right? United Kingdom
and Northern Ireland, Scotland, Wales and
207
00:25:01,029 --> 00:25:11,899
England. Let's search for "flag". Flag is
the flag of the United Kingdom, no? Why
208
00:25:11,899 --> 00:25:25,179
does it have 12 colors? It has blue, red,
white… wat. I see. But that still doesn't
209
00:25:25,179 --> 00:25:33,820
explain the 12. Let's count only the
distinct colours "distinct", there's auto-
210
00:25:33,820 --> 00:25:39,809
completion, thank God, perhaps that helps
. Though I don't know why it would have…
211
00:25:39,809 --> 00:25:44,659
oh it would have had the state multiple
times because it's a sovereign state
212
00:25:44,659 --> 00:25:51,529
multiple times probably. Let's check. Yeah
the United Kingdom is, it's a Commonwealth
213
00:25:51,529 --> 00:25:54,480
realm, and an island nation, and a
sovereign state, and that's probably why
214
00:25:54,480 --> 00:26:00,129
we got it multiple times, and, yeah that
looks more reasonable. South Africa,
215
00:26:00,129 --> 00:26:15,940
Ecuador, South Sudan, and what we can also
do is, add the, of the flag, the image and
216
00:26:15,940 --> 00:26:22,970
call that I, because I can't be bothered
to type the whole thing, and add that
217
00:26:22,970 --> 00:26:27,200
here, and also add it to the "group by",
because otherwise it's not the right
218
00:26:27,200 --> 00:26:31,231
aggregate and I can't be bothered to write
"sample" with one hand, and then we can
219
00:26:31,231 --> 00:26:40,640
hopefully also see it. Oh, we get two
images of the flag of South Africa. That
220
00:26:40,640 --> 00:26:43,120
also looks like one of them should be
"preferred rank", but anyways, we can
221
00:26:43,120 --> 00:26:47,700
switch to image grid, and then we can see
all these colorful flags. One, two, three,
222
00:26:47,700 --> 00:26:53,700
four, five, six, yeah. That's six. And
this is more than six, so I guess, I would
223
00:26:53,700 --> 00:26:57,200
say that should actually be two separate
items, for this old flag and– no, this old
224
00:26:57,200 --> 00:27:04,870
flag and the new flag, but… This is six…
is that only six colors? I'll believe it.
225
00:27:04,870 --> 00:27:09,821
This is six colors, six, and then we have
five colors, yeah. So here are the, let's
226
00:27:09,821 --> 00:27:17,450
just add a comment there, and I will tweet
this out later as well, "colorful state
227
00:27:17,450 --> 00:27:32,369
flags". Yeah. And also we can use
the image grid as the default view.
228
00:27:32,369 --> 00:27:37,499
We probably have time for one more question,
if it's a short one. Though I won't be
229
00:27:37,499 --> 00:27:46,749
able to type very fast. Yes, let's
hope this works. Otherwise I can repeat it
230
00:27:46,749 --> 00:27:53,789
for the stream if I hear you.
AM: So does it work? Yep seems so. I don't
231
00:27:53,789 --> 00:27:59,519
know if it's possible, but the smallest
images that are on Wikipedia? So, by image
232
00:27:59,519 --> 00:28:01,900
size?
L: That would not be possible with the
233
00:28:01,900 --> 00:28:08,799
Query Service I think. But I think on
Commons you can search… can you search?
234
00:28:08,799 --> 00:28:13,730
Whoops, I don't have that search shortcut
set up here. Can you search by image size?
235
00:28:13,730 --> 00:28:27,560
I think that might be possible. Advanced
search, file type, sorting order… No.
236
00:28:27,560 --> 00:28:33,919
You could probably sort by a file size in an
SQL query. Which is not a thing from the
237
00:28:33,919 --> 00:28:39,789
Wikidata Query Service, but it's possible
with something else and as it happens I am
238
00:28:39,789 --> 00:28:44,309
going to have another talk later, where I
talk, about among other things, how you
239
00:28:44,309 --> 00:28:48,169
can write SQL queries against the
Wikipedia databases, and then we might be
240
00:28:48,169 --> 00:28:53,360
able to find a solution for that, and
that's I think at 6 p.m. today over in the
241
00:28:53,360 --> 00:29:05,520
Esszimmer, or you come over to me after
the talk and then I can try to figure it out there.
242
00:29:05,520 --> 00:29:10,370
H: A last emergency idea that we have to
try out?
243
00:29:10,370 --> 00:29:15,969
H: I'm muted. Do you have ano– one more
idea? A small idea maybe we could do but
244
00:29:15,969 --> 00:29:18,010
other than that I think we are, so– filled
the time quite well.
245
00:29:18,010 --> 00:29:23,149
L: Yeah I think we're done. But if you
have any other ideas, you can always
246
00:29:23,149 --> 00:29:30,120
contact me on Twitter @wikidatafacts, or
on Mastodon as well, and then I will see
247
00:29:30,120 --> 00:29:39,489
what I can do for you. Yeah. Thanks.
H: Thank you very much, Lucas, that was a
248
00:29:39,489 --> 00:29:42,439
great introduction to Wikidata querying!
249
00:29:42,439 --> 00:29:44,429
Music
250
00:29:44,429 --> 00:30:10,000
Subtitles created by c3subtitles.de
in the year 2021. Join, and help us!