0:00:00.000,0:00:22.680
Music
0:00:22.680,0:00:26.910
Herald: We'll do some live querying with him[br]so you were told to think of some ideas that
0:00:26.910,0:00:32.620
we could search for in Wikidata and when[br]we get to that point I would ask you to
0:00:32.620,0:00:36.690
raise your hand and wait till I get to you[br]with the microphone so that the people in
0:00:36.690,0:00:44.379
the stream can also hear what we're[br]talking about so that's the thing I'll go
0:00:44.379,0:00:48.580
back to Lucas and we still have[br]translations. Wenn ihr es auf deutsch hören wollt
0:00:48.580,0:00:58.120
wir haben immen noch Übersetzter, die alles versuchen[br]es Euch nochmal auf Deutsch zu erzählen. Also hört mal rein.
0:00:58.120,0:01:10.449
Lucas: Does anyone have a query?[br]Yes, in the front there. We have a question allready.
0:01:10.449,0:01:13.881
Audience member: Is it possible to find all circular family trees?
0:01:13.881,0:01:15.080
[br]L: All circular what?
0:01:15.080,0:01:19.895
AM: Family trees[br]L: It's certainly possible to find
0:01:19.895,0:01:23.800
some. Finding all it's probably going to[br]be a timeout but there would be something
0:01:23.800,0:01:35.020
like select, probably child would be[br]the simplest, so item child plus item
0:01:35.020,0:01:39.170
again. So if we put the star like earlier[br]then you could then every Tree would
0:01:39.170,0:01:44.043
match that, but with the plus it means it[br]has to be at least one child link or more,
0:01:44.043,0:01:48.740
and let's just add a "limit 1" because I'm[br]not that optimistic that this is even
0:01:48.740,0:01:54.120
going to find one, but I'm pretty sure we[br]cannot find all of them, but let's see if
0:01:54.120,0:02:03.810
we can find one and this might just take a[br]while, but I don't think there is a good
0:02:03.810,0:02:09.619
way to do this otherwise unless you[br]download one of the dumps either the JSON
0:02:09.619,0:02:13.870
data dumps or the RDF dumps which is the[br]same data format used here and then you
0:02:13.870,0:02:21.170
can do it locally without an timeout. [br]I don't think there's much I can optimize
0:02:21.170,0:02:28.599
about this query is pretty short unless[br]like I had an idea that people named John
0:02:28.599,0:02:33.849
are more likely to have these kinds of[br]cycles, then we could filter it down first
0:02:33.849,0:02:51.560
but you men. I'm afraid that is not going[br]to work it looks like. Yes, timeout. And
0:02:51.560,0:02:58.900
you can see the thing is written in Java[br]the server dragazines. One thing we
0:02:58.900,0:03:03.340
can do with this "P40+" is something like[br]search start with a certain mythical
0:03:03.340,0:03:14.790
creature such as King Arthur. I hope I can[br]find him like this. Search is being alright
0:03:14.790,0:03:21.910
3d map of EDT. There we go, that's the[br]legendary British or Welsh king and then
0:03:21.910,0:03:26.970
we are searching for an item who is[br]definitely a real human and who has a date
0:03:26.970,0:03:41.090
of birth and we say the date of birth[br]should be greater than at say 1950 and
0:03:41.090,0:03:51.349
this is a date time value and this let's[br]even say 1980. I think that might be
0:03:51.349,0:03:57.569
No more efficient. There we go. No[br]results, okay. I thought King Arthur had
0:03:57.569,0:04:05.590
some real descendants. Though then it was[br]some other mythical creatures. Let's just
0:04:05.590,0:04:14.050
start with any ancestor who has the item[br]as child and the ancestor is also instance
0:04:14.050,0:04:23.050
of mythical creature, mythical character.[br]Let's see if we have any mythical
0:04:23.050,0:04:30.460
characters with children who are born[br]after 1950. Oh I still have the "limit 1"
0:04:30.460,0:04:35.199
here could make that a "limit 10" probably[br]or something, but I'm optimistic I think
0:04:35.199,0:04:38.860
there are some people here, especially, I[br]think, even British MPs, there's some
0:04:38.860,0:04:41.669
that's already on the list of example[br]queries British MPs with mythical
0:04:41.669,0:04:47.610
ancestors and there's lovely have traced[br]their lineage back to some 6th or 5th
0:04:47.610,0:04:54.870
century person and you have all the[br]apparent links in there and then it's kind
0:04:54.870,0:04:59.560
of tricky to figure out where it starts[br]being wrong. Oh that's not working out so
0:04:59.560,0:05:13.085
well. Does anyone else have ideas in the[br]meantime? There, way in the back.
0:05:13.085,0:05:15.340
Someone: Thank you[br]Audience member: We all know that stupid
0:05:15.340,0:05:20.270
game in Wikipedia where you try to find[br]the Adolf Hitler page by only clicking
0:05:20.270,0:05:26.120
links, so can you find the number of pages[br]that are directly connected to the Adolf
0:05:26.120,0:05:33.450
Hitler page in Wikipedia?[br]L: You can. Oh that was a timeout, dammit.
0:05:33.450,0:05:39.790
So that would be kind of ... It's a one funny[br]story about that for example is there's
0:05:39.790,0:05:45.360
the first example we[br]have here is cats and why do we have cats
0:05:45.360,0:05:51.050
and not dogs? Because if you search for[br]dogs the second result, no, it's the
0:05:51.050,0:05:54.130
fourth result by now, but that's the[br]thought of Hitler and we don't really want
0:05:54.130,0:05:59.600
that and normally so we usually use cats[br]as the example instead but let's just
0:05:59.600,0:06:06.250
search for anything where the item has any[br]connection and we don't care which
0:06:06.250,0:06:17.740
property it is to Adolf Hitler, like that,[br]and we are going to find 920 results. ok
0:06:17.740,0:06:28.230
some of these are site links so we also[br]want the item to have some label which
0:06:28.230,0:06:36.169
uses this new namespace and we want only[br]the English label so the language of the
0:06:36.169,0:06:43.419
label should be in English and we then we[br]just select the item and the label and
0:06:43.419,0:06:47.570
hopefully that's still pretty efficient.[br]Here we go NSDAP membership number
0:06:47.570,0:06:54.289
that's actually a property but I assume it[br]has as the example yep there's a property
0:06:54.289,0:07:01.039
example here as NSDAP number 1. World War[br]two has probably of cause of death do we
0:07:01.039,0:07:08.190
have him as an example on cause of death[br]really? and we have nitric acid poisoning,
0:07:08.190,0:07:16.229
stroke, cholera, shot to the head, cyanide[br]poisoning, hanging, That's a very pleasant
0:07:16.229,0:07:21.039
list. Do we need to have that many[br]projects handfuls of closet yeah then we
0:07:21.039,0:07:26.229
have Nazi Party, Klara Hitler, I don't[br]know who that is, 1936 Summer Olympics,
0:07:26.229,0:07:31.630
all kinds of things, so that's how[br]you can find all the things with a direct
0:07:31.630,0:07:43.150
connection to Hitler. Any other[br]examples? Yes, over there in the right, or
0:07:43.150,0:07:48.900
was there already somewhere someone back[br]there that I missed
0:07:48.900,0:07:52.620
AM: Can you find the[br]cheapest public infrastructure projects in
0:07:52.620,0:07:54.870
Germany?[br]L: The cheapest public infrastructure
0:07:54.870,0:07:56.870
what?[br]AM: Projects
0:07:56.870,0:07:58.960
L: Projects[br]AM: Like a bridge building
0:07:58.960,0:08:03.910
L: I don't think we're going to have a[br]full dataset about that but you can try.
0:08:03.910,0:08:07.620
Let's start with a more expensive one and[br][crackling noise]
0:08:07.620,0:08:14.889
L: see - perhaps move away from the box,[br]that might help. Let's start with a very
0:08:14.889,0:08:19.669
expensive project and see just what the[br]data model looks like so what does
0:08:19.669,0:08:24.349
infrastructure project look like what's[br]what was the cost so the cost is probably
0:08:24.349,0:08:29.800
going to be in euro and I don't know how[br]to write here over there okay it's a
0:08:29.800,0:08:36.389
property called cost in Euro and does it[br]have something like instance of
0:08:36.389,0:08:40.099
international airport, building under[br]construction, Greenfield Airport, proposed
0:08:40.099,0:08:52.980
airport being built, so we could check[br]first is Berlin Brandenburg Airport, is
0:08:52.980,0:09:03.249
that an instance of some subclass of[br]public infrastructure? Is that a thing?
0:09:03.249,0:09:13.050
that looks like the wrong item what is[br]this this is nothing. Okay. There's anything
0:09:13.050,0:09:20.310
linked to this item? no nothing like[br]suicide. Okay. So it could be an
0:09:20.310,0:09:25.910
international airport is a subclass of[br]airport which is a subclass of an
0:09:25.910,0:09:34.649
aerodrome which is an architectural[br]structure, and we can search for
0:09:34.649,0:09:42.899
architectural structures, so the structure[br]would be an instance of subclass of
0:09:42.899,0:09:54.769
architectural structure, and it would have[br]a cost, and order by the singing costs I
0:09:54.769,0:10:02.319
think it's 10 and we're probably going to[br]get things in like yen or some other
0:10:02.319,0:10:07.850
currency where this number is just going[br]to be very high because we're not taking
0:10:07.850,0:10:15.980
any conversions into account right now but[br]let's see if we find something there. What
0:10:15.980,0:10:26.779
is it doing? Okay... not sure why this is[br]taking so long. Let's try a second version
0:10:26.779,0:10:42.949
in the mean time where we quantity amount[br]is cost and various quantities units
0:10:42.949,0:10:57.009
should be the euro they're still running[br]and yeah let's try this that works any
0:10:57.009,0:11:08.899
better or not? Okay, this was a timeout. This[br]looks like it's going to be a timeout as
0:11:08.899,0:11:16.220
well. I don't know, we can just search for[br]the most expensive things at all. Remove
0:11:16.220,0:11:27.899
this part, there we go. This costs 55[br]billion euros. What is this thing? Power
0:11:27.899,0:11:39.689
of Siberia, natural gas pipeline. That's,[br]that's in euro, the costs? Apparently. And
0:11:39.689,0:11:44.589
then this is 15 billion euros and then[br]8.77 find something that's the channel, oh
0:11:44.589,0:11:49.059
the Channel Tunnel is expensive. The[br]Brenner Tunnel was also expensive.
0:11:49.059,0:11:54.709
laughter[br]And Stuttgart 21 took about 21 whatever
0:11:54.709,0:12:00.989
was also- or is projected to be expensive.[br]Do we have one cost or several? Okay in
0:12:00.989,0:12:06.829
2018 we have a cost of 7 billion. Yeah, so[br]let's sort by the ascending constant set
0:12:06.829,0:12:10.949
because that was what we actually wanted[br]and then we get... okay now we're going to
0:12:10.949,0:12:16.139
get a lot of things that aren't really[br]infrastructure projects we have the whole
0:12:16.139,0:12:24.000
and a hot and energetic universe. Does[br]that mean it's a no budget film or what?
0:12:24.000,0:12:30.609
Okay. So we would need some kind of ...[br]Let's say, let's do duck typing instead of
0:12:30.609,0:12:35.239
saying it is an infrastructure project,[br]let's say it has, I don't know, a
0:12:35.239,0:12:40.279
coordinate location. And if it has a[br]coordinate location, we're going to call
0:12:40.279,0:12:42.810
it some kind of infrastructure project, or[br]at least it's not going to be a
0:12:42.810,0:12:49.110
documentary film. Perhaps that works[br]better. Yeah, so 21,000 euros cost this
0:12:49.110,0:13:00.350
thing which was in France. Oh, okay,[br]right, it should also be country Germany.
0:13:00.350,0:13:10.540
Here we go. That's 400,000 euros for[br]fountain in Stuttgart. Does that count? I
0:13:10.540,0:13:14.450
guess. And that's the engines of something[br]it doesn't even have a German la- an
0:13:14.450,0:13:21.879
English label, just a German one. Wait...[br]Oh, so this is the class of all the
0:13:21.879,0:13:27.259
fountains with exactly this name which are[br]a subclass of well and are all named after
0:13:27.259,0:13:37.389
this goddess, okay, cool. Yeah so then we[br]have some of these cheap projects, which
0:13:37.389,0:13:42.829
is… this public square… a bridge – oh[br]yeah, there's this tiny bridge, a
0:13:42.829,0:13:52.629
footbridge, has even an image, that's what[br]it looks like, and it costs, what was it,
0:13:52.629,0:13:59.399
1.6 million euros already. Wow. And then[br]we have another public square. Yeah. So,
0:13:59.399,0:14:08.851
"cheap public infrastructure projects".[br]And also probably "infrastructure" in
0:14:08.851,0:14:12.649
quotes, because we're really just saying[br]it has a location and "Country: Germany".
0:14:12.649,0:14:19.939
And, yeah, I can send this query around[br]afterwards. And this didn't work, this
0:14:19.939,0:14:33.079
didn't work. Okay, any other ideas? That's[br]bad news. We could try to continue with
0:14:33.079,0:14:40.809
some of these. Was there something? Oh,[br]from the Camera Angel!
0:14:40.809,0:14:45.689
AM: I have a question! I saw that with[br]Wikidata Query Service we can draw these
0:14:45.689,0:14:53.049
nice trees and have images in them, and[br]one example that came to my mind was all
0:14:53.049,0:14:59.149
the programming patterns – programming[br]design patterns, but grouped by their
0:14:59.149,0:15:05.569
kind, like they're structural patterns,[br]convenience patterns, and so on, and like,
0:15:05.569,0:15:08.499
can we draw a graph and maybe put an image[br]in them.
0:15:08.499,0:15:12.929
L: We can try that. So let's see how[br]that's modeled, I don't know, with the
0:15:12.929,0:15:20.899
visitor pattern for example. That's a[br]design pattern what kind of statements
0:15:20.899,0:15:24.749
does have. It's a subclass of behavioral[br]pattern, is this a programming thing or
0:15:24.749,0:15:32.690
already…? Oh yeah it's a soft… okay it's a[br]software design pattern. So we should say ...
0:15:32.690,0:15:40.980
We're going to have a pattern with[br]its label and a pattern kind with its
0:15:40.980,0:15:51.389
label and the pattern is going to be a[br]subclass of the pattern kinds, which is
0:15:51.389,0:16:02.230
going to be some subclass of – what was[br]it? Of software design pattern – and I'm
0:16:02.230,0:16:08.689
just going to copy this ID so it's the[br]right one – label service, and say, I
0:16:08.689,0:16:15.509
would like to see this by default in the[br]graph view. Here we go. Well that looks
0:16:15.509,0:16:19.619
not as bad as I thought. We have a lot of[br]structural patterns, behavioral patterns,
0:16:19.619,0:16:25.319
one architectural pattern, a few[br]creational patterns, and one fundamental
0:16:25.319,0:16:37.239
pattern. Yeah. And… yeah what we could[br]also do is, if we do this, then we should
0:16:37.239,0:16:42.429
also see connections of all of these.[br]Now we have the tree rooted at
0:16:42.429,0:16:46.910
software design patterns, we have monads,[br]and fundamental pattern is a kind of
0:16:46.910,0:16:50.419
software design pattern. Structural[br]pattern… and it's all linked there and
0:16:50.419,0:16:56.129
this is working… very well, I… That's much[br]better than I expected. I expected a huge
0:16:56.129,0:17:00.889
mess of… because it sometimes gets[br]different to determine when should you use
0:17:00.889,0:17:04.709
"instance of" and when should use[br]"subclass off", like if it's software or
0:17:04.709,0:17:08.250
patterns like this, I expected we would[br]have to account for both of these, but
0:17:08.250,0:17:14.000
this looks very good to me. I think we[br]don't need to do anything with this query.
0:17:14.000,0:17:28.350
Yeah, so that is, uhm, software design[br]patterns by a pattern tree.
0:17:28.350,0:17:41.253
Okay. Any other ideas? Or I can try to[br]keep optimizing this one
0:17:41.253,0:17:45.940
AM: Which cities have applied to be host[br]city of the Eurovision Song Contest the
0:17:45.940,0:17:48.720
most times but were never successful?[br]L: Oh!
0:17:48.720,0:17:52.590
Laughter from Audience[br]L: That's a very good question. I don't
0:17:52.590,0:17:58.259
know if we have– do you know who applied[br]for this year or for some year? But I
0:17:58.259,0:18:09.390
could check if the state if that's modeled[br]anywhere. Uhm, I need some example cities
0:18:09.390,0:18:20.059
so… let's check ESC 2018 if it has[br]information on where it took place, which
0:18:20.059,0:18:25.580
one won the bid, but also who was[br]nominated or something, or who applied… We
0:18:25.580,0:18:29.580
have "presenters", we have "followed by ",[br]"start time", "end time", "participants",
0:18:29.580,0:18:41.820
we have the winner, do we have a location[br]at all? Oh yeah, there it is. Okay, we
0:18:41.820,0:18:48.490
have a country, and a location, but I'm[br]not seeing any other countries here, and I
0:18:48.490,0:18:55.179
assume that information is not going to be[br]on the country item. It's possible that we
0:18:55.179,0:19:06.429
have some separate item for "Eurovision[br]2018 Bid" or… Well wait, it would have to
0:19:06.429,0:19:11.320
be "which city", because the country is[br]determined by the winner isn't it? So the
0:19:11.320,0:19:21.600
city, but I suspect we don't have that[br]information. We have a list of host
0:19:21.600,0:19:31.080
cities, but that's just… a Wikipedia list[br]article.
0:19:31.080,0:19:41.050
Interference noise[br]Do we have to switch to the other mic? Oh
0:19:41.050,0:19:45.820
no, that sounds great! Okay. Yeah, so we[br]don't have any of the structured
0:19:45.820,0:19:49.910
information here. It's just linking all of[br]these Wikipedia articles together, and
0:19:49.910,0:19:55.841
then here is the actual list with the[br]different venues. But I don't think we
0:19:55.841,0:20:00.019
have that information in Wikidata at the[br]moment. We could add it, you'd have to
0:20:00.019,0:20:04.460
figure out the data model, but it would[br]probably be relevant enough, I think.
0:20:04.460,0:20:12.840
I wonder if we have that for the Olympic[br]Games. So, Olympics 2020, do we have the
0:20:12.840,0:20:28.200
process of who applied to host those? Uhm.[br]We have a location. We have parts. Let's
0:20:28.200,0:20:33.130
check. Perhaps English Wikipedia has a[br]separate article about the selection
0:20:33.130,0:20:44.370
process for the 2020 Summer Olympics.[br]Doesn't look like it. "Host city
0:20:44.370,0:20:49.720
selection". No I don't see a main… oh no,[br]there! "Bids for the 2020 Summer
0:20:49.720,0:20:53.490
Olympics", that's the Wikipedia article.[br]Does that have any useful information on
0:20:53.490,0:21:02.350
Wikidata? Bids for Olympic Games no.[br]Damnit. So you can see, when these bids
0:21:02.350,0:21:08.419
all happened, but we don't have the[br]bidding countries and cities apparently on
0:21:08.419,0:21:20.579
Wikidata, at least not as far as I can[br]see. Bids for the… 2012 for example…
0:21:20.579,0:21:30.530
No, sadly, we don't have that information[br]yet. Did this one run by way? No.
0:21:30.530,0:21:34.563
Any other questions?[br]Herald: Our translation angels had a question.
0:21:34.563,0:21:39.409
H: They want to know, if can give them the[br]countries with the most colorful flags
0:21:39.409,0:21:53.070
L: Yes! That [interference noise] should[br]be possible. So "select country", and the
0:21:53.070,0:21:59.970
"count of the colors as counts"[br][interference noise] the country has,
0:21:59.970,0:22:13.059
oops, has a flag, not the "flag image", a[br]flag, and the flag has color. And it
0:22:13.059,0:22:18.370
should be "color" and not "colors", and[br]then we group by country so this is a bit
0:22:18.370,0:22:21.580
like a [noise] grouping and aggregate[br]functions
0:22:21.580,0:22:31.889
[Interference noise][br]Interferene noise*
0:22:31.889,0:22:48.600
Do we need to use the other microphone?[br][Noise] Okay [Noise] But then you can't
0:22:48.600,0:23:05.649
really walk around anymore.[br]H: Hello hello? Hello hello? Muss man da
0:23:05.649,0:23:18.800
noch was machen?[br]L: Okay so now… This could be really fun!
0:23:18.800,0:23:22.350
Yeah, so we are searching for countries[br]with flags, and hope that the flags have
0:23:22.350,0:23:33.139
colors and been counting them, and what I[br]didn't do is… what's this? Do I want to
0:23:33.139,0:23:39.960
know? Okay, okay it's at least it's not[br]the straight pride flag, I guess. Does
0:23:39.960,0:23:43.809
this have 14 colors? No, what was it? No,[br]eight, I guess, one, two, three, four,
0:23:43.809,0:23:47.130
five, six, seven, eight, yeah. That's[br]accurate. Yeah, I didn't filter for
0:23:47.130,0:23:54.850
countries here, the thing is, country is[br]really a stupidly complicated term, so
0:23:54.850,0:24:03.129
what I did was… queries… I have a pre-[br]prepared query for the UN member states
0:24:03.129,0:24:16.980
somewhere, which I just copy all the time.[br]And this is now going to be called a
0:24:16.980,0:24:25.850
state, and then we only get state flags,[br]uhm, and there's exactly– oh, right. I
0:24:25.850,0:24:39.250
need to group by "state" and "state label"[br]and copy these up here as well, and then
0:24:39.250,0:24:50.440
it will hopefully work, and we will find[br]out that… the United Kingdom has… 12?
0:24:50.440,0:24:55.929
I suspect that's because it has four flags,[br]which all have the same rank, or a no– no
0:24:55.929,0:25:01.029
it should be five, right? United Kingdom[br]and Northern Ireland, Scotland, Wales and
0:25:01.029,0:25:11.899
England. Let's search for "flag". Flag is[br]the flag of the United Kingdom, no? Why
0:25:11.899,0:25:25.179
does it have 12 colors? It has blue, red,[br]white… wat. I see. But that still doesn't
0:25:25.179,0:25:33.820
explain the 12. Let's count only the[br]distinct colours "distinct", there's auto-
0:25:33.820,0:25:39.809
completion, thank God, perhaps that helps[br]. Though I don't know why it would have…
0:25:39.809,0:25:44.659
oh it would have had the state multiple[br]times because it's a sovereign state
0:25:44.659,0:25:51.529
multiple times probably. Let's check. Yeah[br]the United Kingdom is, it's a Commonwealth
0:25:51.529,0:25:54.480
realm, and an island nation, and a[br]sovereign state, and that's probably why
0:25:54.480,0:26:00.129
we got it multiple times, and, yeah that[br]looks more reasonable. South Africa,
0:26:00.129,0:26:15.940
Ecuador, South Sudan, and what we can also[br]do is, add the, of the flag, the image and
0:26:15.940,0:26:22.970
call that I, because I can't be bothered[br]to type the whole thing, and add that
0:26:22.970,0:26:27.200
here, and also add it to the "group by",[br]because otherwise it's not the right
0:26:27.200,0:26:31.231
aggregate and I can't be bothered to write[br]"sample" with one hand, and then we can
0:26:31.231,0:26:40.640
hopefully also see it. Oh, we get two[br]images of the flag of South Africa. That
0:26:40.640,0:26:43.120
also looks like one of them should be[br]"preferred rank", but anyways, we can
0:26:43.120,0:26:47.700
switch to image grid, and then we can see[br]all these colorful flags. One, two, three,
0:26:47.700,0:26:53.700
four, five, six, yeah. That's six. And[br]this is more than six, so I guess, I would
0:26:53.700,0:26:57.200
say that should actually be two separate[br]items, for this old flag and– no, this old
0:26:57.200,0:27:04.870
flag and the new flag, but… This is six…[br]is that only six colors? I'll believe it.
0:27:04.870,0:27:09.821
This is six colors, six, and then we have[br]five colors, yeah. So here are the, let's
0:27:09.821,0:27:17.450
just add a comment there, and I will tweet[br]this out later as well, "colorful state
0:27:17.450,0:27:32.369
flags". Yeah. And also we can use[br]the image grid as the default view.
0:27:32.369,0:27:37.499
We probably have time for one more question,[br]if it's a short one. Though I won't be
0:27:37.499,0:27:46.749
able to type very fast. Yes, let's[br]hope this works. Otherwise I can repeat it
0:27:46.749,0:27:53.789
for the stream if I hear you.[br]AM: So does it work? Yep seems so. I don't
0:27:53.789,0:27:59.519
know if it's possible, but the smallest[br]images that are on Wikipedia? So, by image
0:27:59.519,0:28:01.900
size?[br]L: That would not be possible with the
0:28:01.900,0:28:08.799
Query Service I think. But I think on[br]Commons you can search… can you search?
0:28:08.799,0:28:13.730
Whoops, I don't have that search shortcut[br]set up here. Can you search by image size?
0:28:13.730,0:28:27.560
I think that might be possible. Advanced[br]search, file type, sorting order… No.
0:28:27.560,0:28:33.919
You could probably sort by a file size in an[br]SQL query. Which is not a thing from the
0:28:33.919,0:28:39.789
Wikidata Query Service, but it's possible[br]with something else and as it happens I am
0:28:39.789,0:28:44.309
going to have another talk later, where I[br]talk, about among other things, how you
0:28:44.309,0:28:48.169
can write SQL queries against the[br]Wikipedia databases, and then we might be
0:28:48.169,0:28:53.360
able to find a solution for that, and[br]that's I think at 6 p.m. today over in the
0:28:53.360,0:29:05.520
Esszimmer, or you come over to me after[br]the talk and then I can try to figure it out there.
0:29:05.520,0:29:10.370
H: A last emergency idea that we have to[br]try out?
0:29:10.370,0:29:15.969
H: I'm muted. Do you have ano– one more[br]idea? A small idea maybe we could do but
0:29:15.969,0:29:18.010
other than that I think we are, so– filled[br]the time quite well.
0:29:18.010,0:29:23.149
L: Yeah I think we're done. But if you[br]have any other ideas, you can always
0:29:23.149,0:29:30.120
contact me on Twitter @wikidatafacts, or[br]on Mastodon as well, and then I will see
0:29:30.120,0:29:39.489
what I can do for you. Yeah. Thanks.[br]H: Thank you very much, Lucas, that was a
0:29:39.489,0:29:42.439
great introduction to Wikidata querying!
0:29:42.439,0:29:44.429
Music
0:29:44.429,0:30:10.000
Subtitles created by c3subtitles.de[br]in the year 2021. Join, and help us!