WEBVTT

00:00:00.000 --> 00:00:22.680
<i>Music</i>

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

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

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

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

00:00:44.379 --> 00:00:48.580
back to Lucas and we still have
translations. Wenn ihr es auf deutsch hören wollt

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.

00:00:58.120 --> 00:01:10.449
Lucas: Does anyone have a query?
Yes, in the front there. We have a question allready.

00:01:10.449 --> 00:01:13.881
Audience member: Is it possible to find all circular family trees?

00:01:13.881 --> 00:01:15.080

L: All circular what?

00:01:15.080 --> 00:01:19.895
AM: Family trees
L: It's certainly possible to find

00:01:19.895 --> 00:01:23.800
some. Finding all it's probably going to
be a timeout but there would be something

00:01:23.800 --> 00:01:35.020
like select, probably child would be
the simplest, so item child plus item

00:01:35.020 --> 00:01:39.170
again. So if we put the star like earlier
then you could then every Tree would

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,

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

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

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

00:02:03.810 --> 00:02:09.619
way to do this otherwise unless you
download one of the dumps either the JSON

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

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

00:02:21.170 --> 00:02:28.599
about this query is pretty short unless
like I had an idea that people named John

00:02:28.599 --> 00:02:33.849
are more likely to have these kinds of
cycles, then we could filter it down first

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

00:02:51.560 --> 00:02:58.900
you can see the thing is written in Java
the server dragazines. One thing we

00:02:58.900 --> 00:03:03.340
can do with this "P40+" is something like
search start with a certain mythical

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

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

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

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

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

00:03:51.349 --> 00:03:57.569
No more efficient. There we go. No
results, okay. I thought King Arthur had

00:03:57.569 --> 00:04:05.590
some real descendants. Though then it was
some other mythical creatures. Let's just

00:04:05.590 --> 00:04:14.050
start with any ancestor who has the item
as child and the ancestor is also instance

00:04:14.050 --> 00:04:23.050
of mythical creature, mythical character.
Let's see if we have any mythical

00:04:23.050 --> 00:04:30.460
characters with children who are born
after 1950. Oh I still have the "limit 1"

00:04:30.460 --> 00:04:35.199
here could make that a "limit 10" probably
or something, but I'm optimistic I think

00:04:35.199 --> 00:04:38.860
there are some people here, especially, I
think, even British MPs, there's some

00:04:38.860 --> 00:04:41.669
that's already on the list of example
queries British MPs with mythical

00:04:41.669 --> 00:04:47.610
ancestors and there's lovely have traced
their lineage back to some 6th or 5th

00:04:47.610 --> 00:04:54.870
century person and you have all the
apparent links in there and then it's kind

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

00:04:59.560 --> 00:05:13.085
well. Does anyone else have ideas in the
meantime? There, way in the back.

00:05:13.085 --> 00:05:15.340
Someone: Thank you
Audience member: We all know that stupid

00:05:15.340 --> 00:05:20.270
game in Wikipedia where you try to find
the Adolf Hitler page by only clicking

00:05:20.270 --> 00:05:26.120
links, so can you find the number of pages
that are directly connected to the Adolf

00:05:26.120 --> 00:05:33.450
Hitler page in Wikipedia?
L: You can. Oh that was a timeout, dammit.

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

00:05:39.790 --> 00:05:45.360
the first example we
have here is cats and why do we have cats

00:05:45.360 --> 00:05:51.050
and not dogs? Because if you search for
dogs the second result, no, it's the

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

00:05:54.130 --> 00:05:59.600
that and normally so we usually use cats
as the example instead but let's just

00:05:59.600 --> 00:06:06.250
search for anything where the item has any
connection and we don't care which

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

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

00:06:28.230 --> 00:06:36.169
uses this new namespace and we want only
the English label so the language of the

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

00:06:43.419 --> 00:06:47.570
hopefully that's still pretty efficient.
Here we go NSDAP membership number

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

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

00:07:01.039 --> 00:07:08.190
have him as an example on cause of death
really? and we have nitric acid poisoning,

00:07:08.190 --> 00:07:16.229
stroke, cholera, shot to the head, cyanide
poisoning, hanging, That's a very pleasant

00:07:16.229 --> 00:07:21.039
list. Do we need to have that many
projects handfuls of closet yeah then we

00:07:21.039 --> 00:07:26.229
have Nazi Party, Klara Hitler, I don't
know who that is, 1936 Summer Olympics,

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

00:07:31.630 --> 00:07:43.150
connection to Hitler. Any other
examples? Yes, over there in the right, or

00:07:43.150 --> 00:07:48.900
was there already somewhere someone back
there that I missed

00:07:48.900 --> 00:07:52.620
AM: Can you find the
cheapest public infrastructure projects in

00:07:52.620 --> 00:07:54.870
Germany?
L: The cheapest public infrastructure

00:07:54.870 --> 00:07:56.870
what?
AM: Projects

00:07:56.870 --> 00:07:58.960
L: Projects
AM: Like a bridge building

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.

00:08:03.910 --> 00:08:07.620
Let's start with a more expensive one and
[crackling noise]

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

00:08:14.889 --> 00:08:19.669
expensive project and see just what the
data model looks like so what does

00:08:19.669 --> 00:08:24.349
infrastructure project look like what's
what was the cost so the cost is probably

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

00:08:29.800 --> 00:08:36.389
property called cost in Euro and does it
have something like instance of

00:08:36.389 --> 00:08:40.099
international airport, building under
construction, Greenfield Airport, proposed

00:08:40.099 --> 00:08:52.980
airport being built, so we could check
first is Berlin Brandenburg Airport, is

00:08:52.980 --> 00:09:03.249
that an instance of some subclass of
public infrastructure? Is that a thing?

00:09:03.249 --> 00:09:13.050
that looks like the wrong item what is
this this is nothing. Okay. There's anything

00:09:13.050 --> 00:09:20.310
linked to this item? no nothing like
suicide. Okay. So it could be an

00:09:20.310 --> 00:09:25.910
international airport is a subclass of
airport which is a subclass of an

00:09:25.910 --> 00:09:34.649
aerodrome which is an architectural
structure, and we can search for

00:09:34.649 --> 00:09:42.899
architectural structures, so the structure
would be an instance of subclass of

00:09:42.899 --> 00:09:54.769
architectural structure, and it would have
a cost, and order by the singing costs I

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

00:10:02.319 --> 00:10:07.850
currency where this number is just going
to be very high because we're not taking

00:10:07.850 --> 00:10:15.980
any conversions into account right now but
let's see if we find something there. What

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

00:10:26.779 --> 00:10:42.949
in the mean time where we quantity amount
is cost and various quantities units

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

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

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

00:11:16.220 --> 00:11:27.899
this part, there we go. This costs 55
billion euros. What is this thing? Power

00:11:27.899 --> 00:11:39.689
of Siberia, natural gas pipeline. That's,
that's in euro, the costs? Apparently. And

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

00:11:44.589 --> 00:11:49.059
the Channel Tunnel is expensive. The
Brenner Tunnel was also expensive.

00:11:49.059 --> 00:11:54.709
<i>laughter</i>
And Stuttgart 21 took about 21 whatever

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

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

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

00:12:10.949 --> 00:12:16.139
get a lot of things that aren't really
infrastructure projects we have the whole

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?

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

00:12:30.609 --> 00:12:35.239
saying it is an infrastructure project,
let's say it has, I don't know, a

00:12:35.239 --> 00:12:40.279
coordinate location. And if it has a
coordinate location, we're going to call

00:12:40.279 --> 00:12:42.810
it some kind of infrastructure project, or
at least it's not going to be a

00:12:42.810 --> 00:12:49.110
documentary film. Perhaps that works
better. Yeah, so 21,000 euros cost this

00:12:49.110 --> 00:13:00.350
thing which was in France. Oh, okay,
right, it should also be country Germany.

00:13:00.350 --> 00:13:10.540
Here we go. That's 400,000 euros for
fountain in Stuttgart. Does that count? I

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

00:13:14.450 --> 00:13:21.879
English label, just a German one. Wait...
Oh, so this is the class of all the

00:13:21.879 --> 00:13:27.259
fountains with exactly this name which are
a subclass of well and are all named after

00:13:27.259 --> 00:13:37.389
this goddess, okay, cool. Yeah so then we
have some of these cheap projects, which

00:13:37.389 --> 00:13:42.829
is… this public square… a bridge – oh
yeah, there's this tiny bridge, a

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,

00:13:52.629 --> 00:13:59.399
1.6 million euros already. Wow. And then
we have another public square. Yeah. So,

00:13:59.399 --> 00:14:08.851
"cheap public infrastructure projects".
And also probably "infrastructure" in

00:14:08.851 --> 00:14:12.649
quotes, because we're really just saying
it has a location and "Country: Germany".

00:14:12.649 --> 00:14:19.939
And, yeah, I can send this query around
afterwards. And this didn't work, this

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

00:14:33.079 --> 00:14:40.809
some of these. Was there something? Oh,
from the Camera Angel!

00:14:40.809 --> 00:14:45.689
AM: I have a question! I saw that with
Wikidata Query Service we can draw these

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

00:14:53.049 --> 00:14:59.149
the programming patterns – programming
design patterns, but grouped by their

00:14:59.149 --> 00:15:05.569
kind, like they're structural patterns,
convenience patterns, and so on, and like,

00:15:05.569 --> 00:15:08.499
can we draw a graph and maybe put an image
in them.

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

00:15:12.929 --> 00:15:20.899
visitor pattern for example. That's a
design pattern what kind of statements

00:15:20.899 --> 00:15:24.749
does have. It's a subclass of behavioral
pattern, is this a programming thing or

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 ...

00:15:32.690 --> 00:15:40.980
We're going to have a pattern with
its label and a pattern kind with its

00:15:40.980 --> 00:15:51.389
label and the pattern is going to be a
subclass of the pattern kinds, which is

00:15:51.389 --> 00:16:02.230
going to be some subclass of – what was
it? Of software design pattern – and I'm

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

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

00:16:15.509 --> 00:16:19.619
not as bad as I thought. We have a lot of
structural patterns, behavioral patterns,

00:16:19.619 --> 00:16:25.319
one architectural pattern, a few
creational patterns, and one fundamental

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

00:16:37.239 --> 00:16:42.429
also see connections of all of these.
Now we have the tree rooted at

00:16:42.429 --> 00:16:46.910
software design patterns, we have monads,
and fundamental pattern is a kind of

00:16:46.910 --> 00:16:50.419
software design pattern. Structural
pattern… and it's all linked there and

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

00:16:56.129 --> 00:17:00.889
mess of… because it sometimes gets
different to determine when should you use

00:17:00.889 --> 00:17:04.709
"instance of" and when should use
"subclass off", like if it's software or

00:17:04.709 --> 00:17:08.250
patterns like this, I expected we would
have to account for both of these, but

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.

00:17:14.000 --> 00:17:28.350
Yeah, so that is, uhm, software design
patterns by a pattern tree.

00:17:28.350 --> 00:17:41.253
Okay. Any other ideas? Or I can try to
keep optimizing this one

00:17:41.253 --> 00:17:45.940
AM: Which cities have applied to be host
city of the Eurovision Song Contest the

00:17:45.940 --> 00:17:48.720
most times but were never successful?
L: Oh!

00:17:48.720 --> 00:17:52.590
<i>Laughter from Audience</i>
L: That's a very good question. I don't

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

00:17:58.259 --> 00:18:09.390
could check if the state if that's modeled
anywhere. Uhm, I need some example cities

00:18:09.390 --> 00:18:20.059
so… let's check ESC 2018 if it has
information on where it took place, which

00:18:20.059 --> 00:18:25.580
one won the bid, but also who was
nominated or something, or who applied… We

00:18:25.580 --> 00:18:29.580
have "presenters", we have "followed by ",
"start time", "end time", "participants",

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

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

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

00:18:55.179 --> 00:19:06.429
have some separate item for "Eurovision
2018 Bid" or… Well wait, it would have to

00:19:06.429 --> 00:19:11.320
be "which city", because the country is
determined by the winner isn't it? So the

00:19:11.320 --> 00:19:21.600
city, but I suspect we don't have that
information. We have a list of host

00:19:21.600 --> 00:19:31.080
cities, but that's just… a Wikipedia list
article.

00:19:31.080 --> 00:19:41.050
<i>Interference noise</i>
Do we have to switch to the other mic? Oh

00:19:41.050 --> 00:19:45.820
no, that sounds great! Okay. Yeah, so we
don't have any of the structured

00:19:45.820 --> 00:19:49.910
information here. It's just linking all of
these Wikipedia articles together, and

00:19:49.910 --> 00:19:55.841
then here is the actual list with the
different venues. But I don't think we

00:19:55.841 --> 00:20:00.019
have that information in Wikidata at the
moment. We could add it, you'd have to

00:20:00.019 --> 00:20:04.460
figure out the data model, but it would
probably be relevant enough, I think.

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

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

00:20:28.200 --> 00:20:33.130
check. Perhaps English Wikipedia has a
separate article about the selection

00:20:33.130 --> 00:20:44.370
process for the 2020 Summer Olympics.
Doesn't look like it. "Host city

00:20:44.370 --> 00:20:49.720
selection". No I don't see a main… oh no,
there! "Bids for the 2020 Summer

00:20:49.720 --> 00:20:53.490
Olympics", that's the Wikipedia article.
Does that have any useful information on

00:20:53.490 --> 00:21:02.350
Wikidata? Bids for Olympic Games no.
Damnit. So you can see, when these bids

00:21:02.350 --> 00:21:08.419
all happened, but we don't have the
bidding countries and cities apparently on

00:21:08.419 --> 00:21:20.579
Wikidata, at least not as far as I can
see. Bids for the… 2012 for example…

00:21:20.579 --> 00:21:30.530
No, sadly, we don't have that information
yet. Did this one run by way? No.

00:21:30.530 --> 00:21:34.563
Any other questions?
Herald: Our translation angels had a question.

00:21:34.563 --> 00:21:39.409
H: They want to know, if can give them the
countries with the most colorful flags

00:21:39.409 --> 00:21:53.070
L: Yes! That [interference noise] should
be possible. So "select country", and the

00:21:53.070 --> 00:21:59.970
"count of the colors as counts"
[interference noise] the country has,

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

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

00:22:18.370 --> 00:22:21.580
like a [noise] grouping and aggregate
functions

00:22:21.580 --> 00:22:31.889
<i>[Interference noise]
</i>Interferene noise*

00:22:31.889 --> 00:22:48.600
Do we need to use the other microphone?
[Noise] Okay [Noise] But then you can't

00:22:48.600 --> 00:23:05.649
really walk around anymore.
H: Hello hello? Hello hello? Muss man da

00:23:05.649 --> 00:23:18.800
noch was machen?
L: Okay so now… This could be really fun!

00:23:18.800 --> 00:23:22.350
Yeah, so we are searching for countries
with flags, and hope that the flags have

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

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

00:23:39.960 --> 00:23:43.809
this have 14 colors? No, what was it? No,
eight, I guess, one, two, three, four,

00:23:43.809 --> 00:23:47.130
five, six, seven, eight, yeah. That's
accurate. Yeah, I didn't filter for

00:23:47.130 --> 00:23:54.850
countries here, the thing is, country is
really a stupidly complicated term, so

00:23:54.850 --> 00:24:03.129
what I did was… queries… I have a pre-
prepared query for the UN member states

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

00:24:16.980 --> 00:24:25.850
state, and then we only get state flags,
uhm, and there's exactly– oh, right. I

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

00:24:39.250 --> 00:24:50.440
it will hopefully work, and we will find
out that… the United Kingdom has… 12?

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

00:24:55.929 --> 00:25:01.029
it should be five, right? United Kingdom
and Northern Ireland, Scotland, Wales and

00:25:01.029 --> 00:25:11.899
England. Let's search for "flag". Flag is
the flag of the United Kingdom, no? Why

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

00:25:25.179 --> 00:25:33.820
explain the 12. Let's count only the
distinct colours "distinct", there's auto-

00:25:33.820 --> 00:25:39.809
completion, thank God, perhaps that helps
. Though I don't know why it would have…

00:25:39.809 --> 00:25:44.659
oh it would have had the state multiple
times because it's a sovereign state

00:25:44.659 --> 00:25:51.529
multiple times probably. Let's check. Yeah
the United Kingdom is, it's a Commonwealth

00:25:51.529 --> 00:25:54.480
realm, and an island nation, and a
sovereign state, and that's probably why

00:25:54.480 --> 00:26:00.129
we got it multiple times, and, yeah that
looks more reasonable. South Africa,

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

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

00:26:22.970 --> 00:26:27.200
here, and also add it to the "group by",
because otherwise it's not the right

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

00:26:31.231 --> 00:26:40.640
hopefully also see it. Oh, we get two
images of the flag of South Africa. That

00:26:40.640 --> 00:26:43.120
also looks like one of them should be
"preferred rank", but anyways, we can

00:26:43.120 --> 00:26:47.700
switch to image grid, and then we can see
all these colorful flags. One, two, three,

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

00:26:53.700 --> 00:26:57.200
say that should actually be two separate
items, for this old flag and– no, this old

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.

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

00:27:09.821 --> 00:27:17.450
just add a comment there, and I will tweet
this out later as well, "colorful state

00:27:17.450 --> 00:27:32.369
flags". Yeah. And also we can use
the image grid as the default view.

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

00:27:37.499 --> 00:27:46.749
able to type very fast. Yes, let's
hope this works. Otherwise I can repeat it

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

00:27:53.789 --> 00:27:59.519
know if it's possible, but the smallest
images that are on Wikipedia? So, by image

00:27:59.519 --> 00:28:01.900
size?
L: That would not be possible with the

00:28:01.900 --> 00:28:08.799
Query Service I think. But I think on
Commons you can search… can you search?

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?

00:28:13.730 --> 00:28:27.560
I think that might be possible. Advanced
search, file type, sorting order… No.

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

00:28:33.919 --> 00:28:39.789
Wikidata Query Service, but it's possible
with something else and as it happens I am

00:28:39.789 --> 00:28:44.309
going to have another talk later, where I
talk, about among other things, how you

00:28:44.309 --> 00:28:48.169
can write SQL queries against the
Wikipedia databases, and then we might be

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

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.

00:29:05.520 --> 00:29:10.370
H: A last emergency idea that we have to
try out?

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

00:29:15.969 --> 00:29:18.010
other than that I think we are, so– filled
the time quite well.

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

00:29:23.149 --> 00:29:30.120
contact me on Twitter @wikidatafacts, or
on Mastodon as well, and then I will see

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

00:29:39.489 --> 00:29:42.439
great introduction to Wikidata querying!

00:29:42.439 --> 00:29:44.429
<i>Music</i>

00:29:44.429 --> 00:30:10.000
Subtitles created by c3subtitles.de
in the year 2021. Join, and help us!