[Script Info]
Title: 
[Events]
Format: Layer, Start, End, Style, Name, MarginL, MarginR, MarginV, Effect, Text
Dialogue: 0,0:00:00.00,0:00:22.68,Default,,0000,0000,0000,,{\i1}Music{\i0}
Dialogue: 0,0:00:22.68,0:00:26.91,Default,,0000,0000,0000,,Herald: We'll do some live querying with him\Nso you were told to think of some ideas that
Dialogue: 0,0:00:26.91,0:00:32.62,Default,,0000,0000,0000,,we could search for in Wikidata and when\Nwe get to that point I would ask you to
Dialogue: 0,0:00:32.62,0:00:36.69,Default,,0000,0000,0000,,raise your hand and wait till I get to you\Nwith the microphone so that the people in
Dialogue: 0,0:00:36.69,0:00:44.38,Default,,0000,0000,0000,,the stream can also hear what we're\Ntalking about so that's the thing I'll go
Dialogue: 0,0:00:44.38,0:00:48.58,Default,,0000,0000,0000,,back to Lucas and we still have\Ntranslations. Wenn ihr es auf deutsch hören wollt
Dialogue: 0,0:00:48.58,0:00:58.12,Default,,0000,0000,0000,,wir haben immen noch Übersetzter, die alles versuchen\Nes Euch nochmal auf Deutsch zu erzählen. Also hört mal rein.
Dialogue: 0,0:00:58.12,0:01:10.45,Default,,0000,0000,0000,,Lucas: Does anyone have a query?\NYes, in the front there. We have a question allready.
Dialogue: 0,0:01:10.45,0:01:13.88,Default,,0000,0000,0000,,Audience member: Is it possible to find all circular family trees?
Dialogue: 0,0:01:13.88,0:01:15.08,Default,,0000,0000,0000,,\NL: All circular what?
Dialogue: 0,0:01:15.08,0:01:19.90,Default,,0000,0000,0000,,AM: Family trees\NL: It's certainly possible to find
Dialogue: 0,0:01:19.90,0:01:23.80,Default,,0000,0000,0000,,some. Finding all it's probably going to\Nbe a timeout but there would be something
Dialogue: 0,0:01:23.80,0:01:35.02,Default,,0000,0000,0000,,like select, probably child would be\Nthe simplest, so item child plus item
Dialogue: 0,0:01:35.02,0:01:39.17,Default,,0000,0000,0000,,again. So if we put the star like earlier\Nthen you could then every Tree would
Dialogue: 0,0:01:39.17,0:01:44.04,Default,,0000,0000,0000,,match that, but with the plus it means it\Nhas to be at least one child link or more,
Dialogue: 0,0:01:44.04,0:01:48.74,Default,,0000,0000,0000,,and let's just add a "limit 1" because I'm\Nnot that optimistic that this is even
Dialogue: 0,0:01:48.74,0:01:54.12,Default,,0000,0000,0000,,going to find one, but I'm pretty sure we\Ncannot find all of them, but let's see if
Dialogue: 0,0:01:54.12,0:02:03.81,Default,,0000,0000,0000,,we can find one and this might just take a\Nwhile, but I don't think there is a good
Dialogue: 0,0:02:03.81,0:02:09.62,Default,,0000,0000,0000,,way to do this otherwise unless you\Ndownload one of the dumps either the JSON
Dialogue: 0,0:02:09.62,0:02:13.87,Default,,0000,0000,0000,,data dumps or the RDF dumps which is the\Nsame data format used here and then you
Dialogue: 0,0:02:13.87,0:02:21.17,Default,,0000,0000,0000,,can do it locally without an timeout. \NI don't think there's much I can optimize
Dialogue: 0,0:02:21.17,0:02:28.60,Default,,0000,0000,0000,,about this query is pretty short unless\Nlike I had an idea that people named John
Dialogue: 0,0:02:28.60,0:02:33.85,Default,,0000,0000,0000,,are more likely to have these kinds of\Ncycles, then we could filter it down first
Dialogue: 0,0:02:33.85,0:02:51.56,Default,,0000,0000,0000,,but you men. I'm afraid that is not going\Nto work it looks like. Yes, timeout. And
Dialogue: 0,0:02:51.56,0:02:58.90,Default,,0000,0000,0000,,you can see the thing is written in Java\Nthe server dragazines. One thing we
Dialogue: 0,0:02:58.90,0:03:03.34,Default,,0000,0000,0000,,can do with this "P40+" is something like\Nsearch start with a certain mythical
Dialogue: 0,0:03:03.34,0:03:14.79,Default,,0000,0000,0000,,creature such as King Arthur. I hope I can\Nfind him like this. Search is being alright
Dialogue: 0,0:03:14.79,0:03:21.91,Default,,0000,0000,0000,,3d map of EDT. There we go, that's the\Nlegendary British or Welsh king and then
Dialogue: 0,0:03:21.91,0:03:26.97,Default,,0000,0000,0000,,we are searching for an item who is\Ndefinitely a real human and who has a date
Dialogue: 0,0:03:26.97,0:03:41.09,Default,,0000,0000,0000,,of birth and we say the date of birth\Nshould be greater than at say 1950 and
Dialogue: 0,0:03:41.09,0:03:51.35,Default,,0000,0000,0000,,this is a date time value and this let's\Neven say 1980. I think that might be
Dialogue: 0,0:03:51.35,0:03:57.57,Default,,0000,0000,0000,,No more efficient. There we go. No\Nresults, okay. I thought King Arthur had
Dialogue: 0,0:03:57.57,0:04:05.59,Default,,0000,0000,0000,,some real descendants. Though then it was\Nsome other mythical creatures. Let's just
Dialogue: 0,0:04:05.59,0:04:14.05,Default,,0000,0000,0000,,start with any ancestor who has the item\Nas child and the ancestor is also instance
Dialogue: 0,0:04:14.05,0:04:23.05,Default,,0000,0000,0000,,of mythical creature, mythical character.\NLet's see if we have any mythical
Dialogue: 0,0:04:23.05,0:04:30.46,Default,,0000,0000,0000,,characters with children who are born\Nafter 1950. Oh I still have the "limit 1"
Dialogue: 0,0:04:30.46,0:04:35.20,Default,,0000,0000,0000,,here could make that a "limit 10" probably\Nor something, but I'm optimistic I think
Dialogue: 0,0:04:35.20,0:04:38.86,Default,,0000,0000,0000,,there are some people here, especially, I\Nthink, even British MPs, there's some
Dialogue: 0,0:04:38.86,0:04:41.67,Default,,0000,0000,0000,,that's already on the list of example\Nqueries British MPs with mythical
Dialogue: 0,0:04:41.67,0:04:47.61,Default,,0000,0000,0000,,ancestors and there's lovely have traced\Ntheir lineage back to some 6th or 5th
Dialogue: 0,0:04:47.61,0:04:54.87,Default,,0000,0000,0000,,century person and you have all the\Napparent links in there and then it's kind
Dialogue: 0,0:04:54.87,0:04:59.56,Default,,0000,0000,0000,,of tricky to figure out where it starts\Nbeing wrong. Oh that's not working out so
Dialogue: 0,0:04:59.56,0:05:13.08,Default,,0000,0000,0000,,well. Does anyone else have ideas in the\Nmeantime? There, way in the back.
Dialogue: 0,0:05:13.08,0:05:15.34,Default,,0000,0000,0000,,Someone: Thank you\NAudience member: We all know that stupid
Dialogue: 0,0:05:15.34,0:05:20.27,Default,,0000,0000,0000,,game in Wikipedia where you try to find\Nthe Adolf Hitler page by only clicking
Dialogue: 0,0:05:20.27,0:05:26.12,Default,,0000,0000,0000,,links, so can you find the number of pages\Nthat are directly connected to the Adolf
Dialogue: 0,0:05:26.12,0:05:33.45,Default,,0000,0000,0000,,Hitler page in Wikipedia?\NL: You can. Oh that was a timeout, dammit.
Dialogue: 0,0:05:33.45,0:05:39.79,Default,,0000,0000,0000,,So that would be kind of ... It's a one funny\Nstory about that for example is there's
Dialogue: 0,0:05:39.79,0:05:45.36,Default,,0000,0000,0000,,the first example we\Nhave here is cats and why do we have cats
Dialogue: 0,0:05:45.36,0:05:51.05,Default,,0000,0000,0000,,and not dogs? Because if you search for\Ndogs the second result, no, it's the
Dialogue: 0,0:05:51.05,0:05:54.13,Default,,0000,0000,0000,,fourth result by now, but that's the\Nthought of Hitler and we don't really want
Dialogue: 0,0:05:54.13,0:05:59.60,Default,,0000,0000,0000,,that and normally so we usually use cats\Nas the example instead but let's just
Dialogue: 0,0:05:59.60,0:06:06.25,Default,,0000,0000,0000,,search for anything where the item has any\Nconnection and we don't care which
Dialogue: 0,0:06:06.25,0:06:17.74,Default,,0000,0000,0000,,property it is to Adolf Hitler, like that,\Nand we are going to find 920 results. ok
Dialogue: 0,0:06:17.74,0:06:28.23,Default,,0000,0000,0000,,some of these are site links so we also\Nwant the item to have some label which
Dialogue: 0,0:06:28.23,0:06:36.17,Default,,0000,0000,0000,,uses this new namespace and we want only\Nthe English label so the language of the
Dialogue: 0,0:06:36.17,0:06:43.42,Default,,0000,0000,0000,,label should be in English and we then we\Njust select the item and the label and
Dialogue: 0,0:06:43.42,0:06:47.57,Default,,0000,0000,0000,,hopefully that's still pretty efficient.\NHere we go NSDAP membership number
Dialogue: 0,0:06:47.57,0:06:54.29,Default,,0000,0000,0000,,that's actually a property but I assume it\Nhas as the example yep there's a property
Dialogue: 0,0:06:54.29,0:07:01.04,Default,,0000,0000,0000,,example here as NSDAP number 1. World War\Ntwo has probably of cause of death do we
Dialogue: 0,0:07:01.04,0:07:08.19,Default,,0000,0000,0000,,have him as an example on cause of death\Nreally? and we have nitric acid poisoning,
Dialogue: 0,0:07:08.19,0:07:16.23,Default,,0000,0000,0000,,stroke, cholera, shot to the head, cyanide\Npoisoning, hanging, That's a very pleasant
Dialogue: 0,0:07:16.23,0:07:21.04,Default,,0000,0000,0000,,list. Do we need to have that many\Nprojects handfuls of closet yeah then we
Dialogue: 0,0:07:21.04,0:07:26.23,Default,,0000,0000,0000,,have Nazi Party, Klara Hitler, I don't\Nknow who that is, 1936 Summer Olympics,
Dialogue: 0,0:07:26.23,0:07:31.63,Default,,0000,0000,0000,,all kinds of things, so that's how\Nyou can find all the things with a direct
Dialogue: 0,0:07:31.63,0:07:43.15,Default,,0000,0000,0000,,connection to Hitler. Any other\Nexamples? Yes, over there in the right, or
Dialogue: 0,0:07:43.15,0:07:48.90,Default,,0000,0000,0000,,was there already somewhere someone back\Nthere that I missed
Dialogue: 0,0:07:48.90,0:07:52.62,Default,,0000,0000,0000,,AM: Can you find the\Ncheapest public infrastructure projects in
Dialogue: 0,0:07:52.62,0:07:54.87,Default,,0000,0000,0000,,Germany?\NL: The cheapest public infrastructure
Dialogue: 0,0:07:54.87,0:07:56.87,Default,,0000,0000,0000,,what?\NAM: Projects
Dialogue: 0,0:07:56.87,0:07:58.96,Default,,0000,0000,0000,,L: Projects\NAM: Like a bridge building
Dialogue: 0,0:07:58.96,0:08:03.91,Default,,0000,0000,0000,,L: I don't think we're going to have a\Nfull dataset about that but you can try.
Dialogue: 0,0:08:03.91,0:08:07.62,Default,,0000,0000,0000,,Let's start with a more expensive one and\N[crackling noise]
Dialogue: 0,0:08:07.62,0:08:14.89,Default,,0000,0000,0000,,L: see - perhaps move away from the box,\Nthat might help. Let's start with a very
Dialogue: 0,0:08:14.89,0:08:19.67,Default,,0000,0000,0000,,expensive project and see just what the\Ndata model looks like so what does
Dialogue: 0,0:08:19.67,0:08:24.35,Default,,0000,0000,0000,,infrastructure project look like what's\Nwhat was the cost so the cost is probably
Dialogue: 0,0:08:24.35,0:08:29.80,Default,,0000,0000,0000,,going to be in euro and I don't know how\Nto write here over there okay it's a
Dialogue: 0,0:08:29.80,0:08:36.39,Default,,0000,0000,0000,,property called cost in Euro and does it\Nhave something like instance of
Dialogue: 0,0:08:36.39,0:08:40.10,Default,,0000,0000,0000,,international airport, building under\Nconstruction, Greenfield Airport, proposed
Dialogue: 0,0:08:40.10,0:08:52.98,Default,,0000,0000,0000,,airport being built, so we could check\Nfirst is Berlin Brandenburg Airport, is
Dialogue: 0,0:08:52.98,0:09:03.25,Default,,0000,0000,0000,,that an instance of some subclass of\Npublic infrastructure? Is that a thing?
Dialogue: 0,0:09:03.25,0:09:13.05,Default,,0000,0000,0000,,that looks like the wrong item what is\Nthis this is nothing. Okay. There's anything
Dialogue: 0,0:09:13.05,0:09:20.31,Default,,0000,0000,0000,,linked to this item? no nothing like\Nsuicide. Okay. So it could be an
Dialogue: 0,0:09:20.31,0:09:25.91,Default,,0000,0000,0000,,international airport is a subclass of\Nairport which is a subclass of an
Dialogue: 0,0:09:25.91,0:09:34.65,Default,,0000,0000,0000,,aerodrome which is an architectural\Nstructure, and we can search for
Dialogue: 0,0:09:34.65,0:09:42.90,Default,,0000,0000,0000,,architectural structures, so the structure\Nwould be an instance of subclass of
Dialogue: 0,0:09:42.90,0:09:54.77,Default,,0000,0000,0000,,architectural structure, and it would have\Na cost, and order by the singing costs I
Dialogue: 0,0:09:54.77,0:10:02.32,Default,,0000,0000,0000,,think it's 10 and we're probably going to\Nget things in like yen or some other
Dialogue: 0,0:10:02.32,0:10:07.85,Default,,0000,0000,0000,,currency where this number is just going\Nto be very high because we're not taking
Dialogue: 0,0:10:07.85,0:10:15.98,Default,,0000,0000,0000,,any conversions into account right now but\Nlet's see if we find something there. What
Dialogue: 0,0:10:15.98,0:10:26.78,Default,,0000,0000,0000,,is it doing? Okay... not sure why this is\Ntaking so long. Let's try a second version
Dialogue: 0,0:10:26.78,0:10:42.95,Default,,0000,0000,0000,,in the mean time where we quantity amount\Nis cost and various quantities units
Dialogue: 0,0:10:42.95,0:10:57.01,Default,,0000,0000,0000,,should be the euro they're still running\Nand yeah let's try this that works any
Dialogue: 0,0:10:57.01,0:11:08.90,Default,,0000,0000,0000,,better or not? Okay, this was a timeout. This\Nlooks like it's going to be a timeout as
Dialogue: 0,0:11:08.90,0:11:16.22,Default,,0000,0000,0000,,well. I don't know, we can just search for\Nthe most expensive things at all. Remove
Dialogue: 0,0:11:16.22,0:11:27.90,Default,,0000,0000,0000,,this part, there we go. This costs 55\Nbillion euros. What is this thing? Power
Dialogue: 0,0:11:27.90,0:11:39.69,Default,,0000,0000,0000,,of Siberia, natural gas pipeline. That's,\Nthat's in euro, the costs? Apparently. And
Dialogue: 0,0:11:39.69,0:11:44.59,Default,,0000,0000,0000,,then this is 15 billion euros and then\N8.77 find something that's the channel, oh
Dialogue: 0,0:11:44.59,0:11:49.06,Default,,0000,0000,0000,,the Channel Tunnel is expensive. The\NBrenner Tunnel was also expensive.
Dialogue: 0,0:11:49.06,0:11:54.71,Default,,0000,0000,0000,,{\i1}laughter{\i0}\NAnd Stuttgart 21 took about 21 whatever
Dialogue: 0,0:11:54.71,0:12:00.99,Default,,0000,0000,0000,,was also- or is projected to be expensive.\NDo we have one cost or several? Okay in
Dialogue: 0,0:12:00.99,0:12:06.83,Default,,0000,0000,0000,,2018 we have a cost of 7 billion. Yeah, so\Nlet's sort by the ascending constant set
Dialogue: 0,0:12:06.83,0:12:10.95,Default,,0000,0000,0000,,because that was what we actually wanted\Nand then we get... okay now we're going to
Dialogue: 0,0:12:10.95,0:12:16.14,Default,,0000,0000,0000,,get a lot of things that aren't really\Ninfrastructure projects we have the whole
Dialogue: 0,0:12:16.14,0:12:24.00,Default,,0000,0000,0000,,and a hot and energetic universe. Does\Nthat mean it's a no budget film or what?
Dialogue: 0,0:12:24.00,0:12:30.61,Default,,0000,0000,0000,,Okay. So we would need some kind of ...\NLet's say, let's do duck typing instead of
Dialogue: 0,0:12:30.61,0:12:35.24,Default,,0000,0000,0000,,saying it is an infrastructure project,\Nlet's say it has, I don't know, a
Dialogue: 0,0:12:35.24,0:12:40.28,Default,,0000,0000,0000,,coordinate location. And if it has a\Ncoordinate location, we're going to call
Dialogue: 0,0:12:40.28,0:12:42.81,Default,,0000,0000,0000,,it some kind of infrastructure project, or\Nat least it's not going to be a
Dialogue: 0,0:12:42.81,0:12:49.11,Default,,0000,0000,0000,,documentary film. Perhaps that works\Nbetter. Yeah, so 21,000 euros cost this
Dialogue: 0,0:12:49.11,0:13:00.35,Default,,0000,0000,0000,,thing which was in France. Oh, okay,\Nright, it should also be country Germany.
Dialogue: 0,0:13:00.35,0:13:10.54,Default,,0000,0000,0000,,Here we go. That's 400,000 euros for\Nfountain in Stuttgart. Does that count? I
Dialogue: 0,0:13:10.54,0:13:14.45,Default,,0000,0000,0000,,guess. And that's the engines of something\Nit doesn't even have a German la- an
Dialogue: 0,0:13:14.45,0:13:21.88,Default,,0000,0000,0000,,English label, just a German one. Wait...\NOh, so this is the class of all the
Dialogue: 0,0:13:21.88,0:13:27.26,Default,,0000,0000,0000,,fountains with exactly this name which are\Na subclass of well and are all named after
Dialogue: 0,0:13:27.26,0:13:37.39,Default,,0000,0000,0000,,this goddess, okay, cool. Yeah so then we\Nhave some of these cheap projects, which
Dialogue: 0,0:13:37.39,0:13:42.83,Default,,0000,0000,0000,,is… this public square… a bridge – oh\Nyeah, there's this tiny bridge, a
Dialogue: 0,0:13:42.83,0:13:52.63,Default,,0000,0000,0000,,footbridge, has even an image, that's what\Nit looks like, and it costs, what was it,
Dialogue: 0,0:13:52.63,0:13:59.40,Default,,0000,0000,0000,,1.6 million euros already. Wow. And then\Nwe have another public square. Yeah. So,
Dialogue: 0,0:13:59.40,0:14:08.85,Default,,0000,0000,0000,,"cheap public infrastructure projects".\NAnd also probably "infrastructure" in
Dialogue: 0,0:14:08.85,0:14:12.65,Default,,0000,0000,0000,,quotes, because we're really just saying\Nit has a location and "Country: Germany".
Dialogue: 0,0:14:12.65,0:14:19.94,Default,,0000,0000,0000,,And, yeah, I can send this query around\Nafterwards. And this didn't work, this
Dialogue: 0,0:14:19.94,0:14:33.08,Default,,0000,0000,0000,,didn't work. Okay, any other ideas? That's\Nbad news. We could try to continue with
Dialogue: 0,0:14:33.08,0:14:40.81,Default,,0000,0000,0000,,some of these. Was there something? Oh,\Nfrom the Camera Angel!
Dialogue: 0,0:14:40.81,0:14:45.69,Default,,0000,0000,0000,,AM: I have a question! I saw that with\NWikidata Query Service we can draw these
Dialogue: 0,0:14:45.69,0:14:53.05,Default,,0000,0000,0000,,nice trees and have images in them, and\None example that came to my mind was all
Dialogue: 0,0:14:53.05,0:14:59.15,Default,,0000,0000,0000,,the programming patterns – programming\Ndesign patterns, but grouped by their
Dialogue: 0,0:14:59.15,0:15:05.57,Default,,0000,0000,0000,,kind, like they're structural patterns,\Nconvenience patterns, and so on, and like,
Dialogue: 0,0:15:05.57,0:15:08.50,Default,,0000,0000,0000,,can we draw a graph and maybe put an image\Nin them.
Dialogue: 0,0:15:08.50,0:15:12.93,Default,,0000,0000,0000,,L: We can try that. So let's see how\Nthat's modeled, I don't know, with the
Dialogue: 0,0:15:12.93,0:15:20.90,Default,,0000,0000,0000,,visitor pattern for example. That's a\Ndesign pattern what kind of statements
Dialogue: 0,0:15:20.90,0:15:24.75,Default,,0000,0000,0000,,does have. It's a subclass of behavioral\Npattern, is this a programming thing or
Dialogue: 0,0:15:24.75,0:15:32.69,Default,,0000,0000,0000,,already…? Oh yeah it's a soft… okay it's a\Nsoftware design pattern. So we should say ...
Dialogue: 0,0:15:32.69,0:15:40.98,Default,,0000,0000,0000,,We're going to have a pattern with\Nits label and a pattern kind with its
Dialogue: 0,0:15:40.98,0:15:51.39,Default,,0000,0000,0000,,label and the pattern is going to be a\Nsubclass of the pattern kinds, which is
Dialogue: 0,0:15:51.39,0:16:02.23,Default,,0000,0000,0000,,going to be some subclass of – what was\Nit? Of software design pattern – and I'm
Dialogue: 0,0:16:02.23,0:16:08.69,Default,,0000,0000,0000,,just going to copy this ID so it's the\Nright one – label service, and say, I
Dialogue: 0,0:16:08.69,0:16:15.51,Default,,0000,0000,0000,,would like to see this by default in the\Ngraph view. Here we go. Well that looks
Dialogue: 0,0:16:15.51,0:16:19.62,Default,,0000,0000,0000,,not as bad as I thought. We have a lot of\Nstructural patterns, behavioral patterns,
Dialogue: 0,0:16:19.62,0:16:25.32,Default,,0000,0000,0000,,one architectural pattern, a few\Ncreational patterns, and one fundamental
Dialogue: 0,0:16:25.32,0:16:37.24,Default,,0000,0000,0000,,pattern. Yeah. And… yeah what we could\Nalso do is, if we do this, then we should
Dialogue: 0,0:16:37.24,0:16:42.43,Default,,0000,0000,0000,,also see connections of all of these.\NNow we have the tree rooted at
Dialogue: 0,0:16:42.43,0:16:46.91,Default,,0000,0000,0000,,software design patterns, we have monads,\Nand fundamental pattern is a kind of
Dialogue: 0,0:16:46.91,0:16:50.42,Default,,0000,0000,0000,,software design pattern. Structural\Npattern… and it's all linked there and
Dialogue: 0,0:16:50.42,0:16:56.13,Default,,0000,0000,0000,,this is working… very well, I… That's much\Nbetter than I expected. I expected a huge
Dialogue: 0,0:16:56.13,0:17:00.89,Default,,0000,0000,0000,,mess of… because it sometimes gets\Ndifferent to determine when should you use
Dialogue: 0,0:17:00.89,0:17:04.71,Default,,0000,0000,0000,,"instance of" and when should use\N"subclass off", like if it's software or
Dialogue: 0,0:17:04.71,0:17:08.25,Default,,0000,0000,0000,,patterns like this, I expected we would\Nhave to account for both of these, but
Dialogue: 0,0:17:08.25,0:17:14.00,Default,,0000,0000,0000,,this looks very good to me. I think we\Ndon't need to do anything with this query.
Dialogue: 0,0:17:14.00,0:17:28.35,Default,,0000,0000,0000,,Yeah, so that is, uhm, software design\Npatterns by a pattern tree.
Dialogue: 0,0:17:28.35,0:17:41.25,Default,,0000,0000,0000,,Okay. Any other ideas? Or I can try to\Nkeep optimizing this one
Dialogue: 0,0:17:41.25,0:17:45.94,Default,,0000,0000,0000,,AM: Which cities have applied to be host\Ncity of the Eurovision Song Contest the
Dialogue: 0,0:17:45.94,0:17:48.72,Default,,0000,0000,0000,,most times but were never successful?\NL: Oh!
Dialogue: 0,0:17:48.72,0:17:52.59,Default,,0000,0000,0000,,{\i1}Laughter from Audience{\i0}\NL: That's a very good question. I don't
Dialogue: 0,0:17:52.59,0:17:58.26,Default,,0000,0000,0000,,know if we have– do you know who applied\Nfor this year or for some year? But I
Dialogue: 0,0:17:58.26,0:18:09.39,Default,,0000,0000,0000,,could check if the state if that's modeled\Nanywhere. Uhm, I need some example cities
Dialogue: 0,0:18:09.39,0:18:20.06,Default,,0000,0000,0000,,so… let's check ESC 2018 if it has\Ninformation on where it took place, which
Dialogue: 0,0:18:20.06,0:18:25.58,Default,,0000,0000,0000,,one won the bid, but also who was\Nnominated or something, or who applied… We
Dialogue: 0,0:18:25.58,0:18:29.58,Default,,0000,0000,0000,,have "presenters", we have "followed by ",\N"start time", "end time", "participants",
Dialogue: 0,0:18:29.58,0:18:41.82,Default,,0000,0000,0000,,we have the winner, do we have a location\Nat all? Oh yeah, there it is. Okay, we
Dialogue: 0,0:18:41.82,0:18:48.49,Default,,0000,0000,0000,,have a country, and a location, but I'm\Nnot seeing any other countries here, and I
Dialogue: 0,0:18:48.49,0:18:55.18,Default,,0000,0000,0000,,assume that information is not going to be\Non the country item. It's possible that we
Dialogue: 0,0:18:55.18,0:19:06.43,Default,,0000,0000,0000,,have some separate item for "Eurovision\N2018 Bid" or… Well wait, it would have to
Dialogue: 0,0:19:06.43,0:19:11.32,Default,,0000,0000,0000,,be "which city", because the country is\Ndetermined by the winner isn't it? So the
Dialogue: 0,0:19:11.32,0:19:21.60,Default,,0000,0000,0000,,city, but I suspect we don't have that\Ninformation. We have a list of host
Dialogue: 0,0:19:21.60,0:19:31.08,Default,,0000,0000,0000,,cities, but that's just… a Wikipedia list\Narticle.
Dialogue: 0,0:19:31.08,0:19:41.05,Default,,0000,0000,0000,,{\i1}Interference noise{\i0}\NDo we have to switch to the other mic? Oh
Dialogue: 0,0:19:41.05,0:19:45.82,Default,,0000,0000,0000,,no, that sounds great! Okay. Yeah, so we\Ndon't have any of the structured
Dialogue: 0,0:19:45.82,0:19:49.91,Default,,0000,0000,0000,,information here. It's just linking all of\Nthese Wikipedia articles together, and
Dialogue: 0,0:19:49.91,0:19:55.84,Default,,0000,0000,0000,,then here is the actual list with the\Ndifferent venues. But I don't think we
Dialogue: 0,0:19:55.84,0:20:00.02,Default,,0000,0000,0000,,have that information in Wikidata at the\Nmoment. We could add it, you'd have to
Dialogue: 0,0:20:00.02,0:20:04.46,Default,,0000,0000,0000,,figure out the data model, but it would\Nprobably be relevant enough, I think.
Dialogue: 0,0:20:04.46,0:20:12.84,Default,,0000,0000,0000,,I wonder if we have that for the Olympic\NGames. So, Olympics 2020, do we have the
Dialogue: 0,0:20:12.84,0:20:28.20,Default,,0000,0000,0000,,process of who applied to host those? Uhm.\NWe have a location. We have parts. Let's
Dialogue: 0,0:20:28.20,0:20:33.13,Default,,0000,0000,0000,,check. Perhaps English Wikipedia has a\Nseparate article about the selection
Dialogue: 0,0:20:33.13,0:20:44.37,Default,,0000,0000,0000,,process for the 2020 Summer Olympics.\NDoesn't look like it. "Host city
Dialogue: 0,0:20:44.37,0:20:49.72,Default,,0000,0000,0000,,selection". No I don't see a main… oh no,\Nthere! "Bids for the 2020 Summer
Dialogue: 0,0:20:49.72,0:20:53.49,Default,,0000,0000,0000,,Olympics", that's the Wikipedia article.\NDoes that have any useful information on
Dialogue: 0,0:20:53.49,0:21:02.35,Default,,0000,0000,0000,,Wikidata? Bids for Olympic Games no.\NDamnit. So you can see, when these bids
Dialogue: 0,0:21:02.35,0:21:08.42,Default,,0000,0000,0000,,all happened, but we don't have the\Nbidding countries and cities apparently on
Dialogue: 0,0:21:08.42,0:21:20.58,Default,,0000,0000,0000,,Wikidata, at least not as far as I can\Nsee. Bids for the… 2012 for example…
Dialogue: 0,0:21:20.58,0:21:30.53,Default,,0000,0000,0000,,No, sadly, we don't have that information\Nyet. Did this one run by way? No.
Dialogue: 0,0:21:30.53,0:21:34.56,Default,,0000,0000,0000,,Any other questions?\NHerald: Our translation angels had a question.
Dialogue: 0,0:21:34.56,0:21:39.41,Default,,0000,0000,0000,,H: They want to know, if can give them the\Ncountries with the most colorful flags
Dialogue: 0,0:21:39.41,0:21:53.07,Default,,0000,0000,0000,,L: Yes! That [interference noise] should\Nbe possible. So "select country", and the
Dialogue: 0,0:21:53.07,0:21:59.97,Default,,0000,0000,0000,,"count of the colors as counts"\N[interference noise] the country has,
Dialogue: 0,0:21:59.97,0:22:13.06,Default,,0000,0000,0000,,oops, has a flag, not the "flag image", a\Nflag, and the flag has color. And it
Dialogue: 0,0:22:13.06,0:22:18.37,Default,,0000,0000,0000,,should be "color" and not "colors", and\Nthen we group by country so this is a bit
Dialogue: 0,0:22:18.37,0:22:21.58,Default,,0000,0000,0000,,like a [noise] grouping and aggregate\Nfunctions
Dialogue: 0,0:22:21.58,0:22:31.89,Default,,0000,0000,0000,,{\i1}[Interference noise]\N{\i0}Interferene noise*
Dialogue: 0,0:22:31.89,0:22:48.60,Default,,0000,0000,0000,,Do we need to use the other microphone?\N[Noise] Okay [Noise] But then you can't
Dialogue: 0,0:22:48.60,0:23:05.65,Default,,0000,0000,0000,,really walk around anymore.\NH: Hello hello? Hello hello? Muss man da
Dialogue: 0,0:23:05.65,0:23:18.80,Default,,0000,0000,0000,,noch was machen?\NL: Okay so now… This could be really fun!
Dialogue: 0,0:23:18.80,0:23:22.35,Default,,0000,0000,0000,,Yeah, so we are searching for countries\Nwith flags, and hope that the flags have
Dialogue: 0,0:23:22.35,0:23:33.14,Default,,0000,0000,0000,,colors and been counting them, and what I\Ndidn't do is… what's this? Do I want to
Dialogue: 0,0:23:33.14,0:23:39.96,Default,,0000,0000,0000,,know? Okay, okay it's at least it's not\Nthe straight pride flag, I guess. Does
Dialogue: 0,0:23:39.96,0:23:43.81,Default,,0000,0000,0000,,this have 14 colors? No, what was it? No,\Neight, I guess, one, two, three, four,
Dialogue: 0,0:23:43.81,0:23:47.13,Default,,0000,0000,0000,,five, six, seven, eight, yeah. That's\Naccurate. Yeah, I didn't filter for
Dialogue: 0,0:23:47.13,0:23:54.85,Default,,0000,0000,0000,,countries here, the thing is, country is\Nreally a stupidly complicated term, so
Dialogue: 0,0:23:54.85,0:24:03.13,Default,,0000,0000,0000,,what I did was… queries… I have a pre-\Nprepared query for the UN member states
Dialogue: 0,0:24:03.13,0:24:16.98,Default,,0000,0000,0000,,somewhere, which I just copy all the time.\NAnd this is now going to be called a
Dialogue: 0,0:24:16.98,0:24:25.85,Default,,0000,0000,0000,,state, and then we only get state flags,\Nuhm, and there's exactly– oh, right. I
Dialogue: 0,0:24:25.85,0:24:39.25,Default,,0000,0000,0000,,need to group by "state" and "state label"\Nand copy these up here as well, and then
Dialogue: 0,0:24:39.25,0:24:50.44,Default,,0000,0000,0000,,it will hopefully work, and we will find\Nout that… the United Kingdom has… 12?
Dialogue: 0,0:24:50.44,0:24:55.93,Default,,0000,0000,0000,,I suspect that's because it has four flags,\Nwhich all have the same rank, or a no– no
Dialogue: 0,0:24:55.93,0:25:01.03,Default,,0000,0000,0000,,it should be five, right? United Kingdom\Nand Northern Ireland, Scotland, Wales and
Dialogue: 0,0:25:01.03,0:25:11.90,Default,,0000,0000,0000,,England. Let's search for "flag". Flag is\Nthe flag of the United Kingdom, no? Why
Dialogue: 0,0:25:11.90,0:25:25.18,Default,,0000,0000,0000,,does it have 12 colors? It has blue, red,\Nwhite… wat. I see. But that still doesn't
Dialogue: 0,0:25:25.18,0:25:33.82,Default,,0000,0000,0000,,explain the 12. Let's count only the\Ndistinct colours "distinct", there's auto-
Dialogue: 0,0:25:33.82,0:25:39.81,Default,,0000,0000,0000,,completion, thank God, perhaps that helps\N. Though I don't know why it would have…
Dialogue: 0,0:25:39.81,0:25:44.66,Default,,0000,0000,0000,,oh it would have had the state multiple\Ntimes because it's a sovereign state
Dialogue: 0,0:25:44.66,0:25:51.53,Default,,0000,0000,0000,,multiple times probably. Let's check. Yeah\Nthe United Kingdom is, it's a Commonwealth
Dialogue: 0,0:25:51.53,0:25:54.48,Default,,0000,0000,0000,,realm, and an island nation, and a\Nsovereign state, and that's probably why
Dialogue: 0,0:25:54.48,0:26:00.13,Default,,0000,0000,0000,,we got it multiple times, and, yeah that\Nlooks more reasonable. South Africa,
Dialogue: 0,0:26:00.13,0:26:15.94,Default,,0000,0000,0000,,Ecuador, South Sudan, and what we can also\Ndo is, add the, of the flag, the image and
Dialogue: 0,0:26:15.94,0:26:22.97,Default,,0000,0000,0000,,call that I, because I can't be bothered\Nto type the whole thing, and add that
Dialogue: 0,0:26:22.97,0:26:27.20,Default,,0000,0000,0000,,here, and also add it to the "group by",\Nbecause otherwise it's not the right
Dialogue: 0,0:26:27.20,0:26:31.23,Default,,0000,0000,0000,,aggregate and I can't be bothered to write\N"sample" with one hand, and then we can
Dialogue: 0,0:26:31.23,0:26:40.64,Default,,0000,0000,0000,,hopefully also see it. Oh, we get two\Nimages of the flag of South Africa. That
Dialogue: 0,0:26:40.64,0:26:43.12,Default,,0000,0000,0000,,also looks like one of them should be\N"preferred rank", but anyways, we can
Dialogue: 0,0:26:43.12,0:26:47.70,Default,,0000,0000,0000,,switch to image grid, and then we can see\Nall these colorful flags. One, two, three,
Dialogue: 0,0:26:47.70,0:26:53.70,Default,,0000,0000,0000,,four, five, six, yeah. That's six. And\Nthis is more than six, so I guess, I would
Dialogue: 0,0:26:53.70,0:26:57.20,Default,,0000,0000,0000,,say that should actually be two separate\Nitems, for this old flag and– no, this old
Dialogue: 0,0:26:57.20,0:27:04.87,Default,,0000,0000,0000,,flag and the new flag, but… This is six…\Nis that only six colors? I'll believe it.
Dialogue: 0,0:27:04.87,0:27:09.82,Default,,0000,0000,0000,,This is six colors, six, and then we have\Nfive colors, yeah. So here are the, let's
Dialogue: 0,0:27:09.82,0:27:17.45,Default,,0000,0000,0000,,just add a comment there, and I will tweet\Nthis out later as well, "colorful state
Dialogue: 0,0:27:17.45,0:27:32.37,Default,,0000,0000,0000,,flags". Yeah. And also we can use\Nthe image grid as the default view.
Dialogue: 0,0:27:32.37,0:27:37.50,Default,,0000,0000,0000,,We probably have time for one more question,\Nif it's a short one. Though I won't be
Dialogue: 0,0:27:37.50,0:27:46.75,Default,,0000,0000,0000,,able to type very fast. Yes, let's\Nhope this works. Otherwise I can repeat it
Dialogue: 0,0:27:46.75,0:27:53.79,Default,,0000,0000,0000,,for the stream if I hear you.\NAM: So does it work? Yep seems so. I don't
Dialogue: 0,0:27:53.79,0:27:59.52,Default,,0000,0000,0000,,know if it's possible, but the smallest\Nimages that are on Wikipedia? So, by image
Dialogue: 0,0:27:59.52,0:28:01.90,Default,,0000,0000,0000,,size?\NL: That would not be possible with the
Dialogue: 0,0:28:01.90,0:28:08.80,Default,,0000,0000,0000,,Query Service I think. But I think on\NCommons you can search… can you search?
Dialogue: 0,0:28:08.80,0:28:13.73,Default,,0000,0000,0000,,Whoops, I don't have that search shortcut\Nset up here. Can you search by image size?
Dialogue: 0,0:28:13.73,0:28:27.56,Default,,0000,0000,0000,,I think that might be possible. Advanced\Nsearch, file type, sorting order… No.
Dialogue: 0,0:28:27.56,0:28:33.92,Default,,0000,0000,0000,,You could probably sort by a file size in an\NSQL query. Which is not a thing from the
Dialogue: 0,0:28:33.92,0:28:39.79,Default,,0000,0000,0000,,Wikidata Query Service, but it's possible\Nwith something else and as it happens I am
Dialogue: 0,0:28:39.79,0:28:44.31,Default,,0000,0000,0000,,going to have another talk later, where I\Ntalk, about among other things, how you
Dialogue: 0,0:28:44.31,0:28:48.17,Default,,0000,0000,0000,,can write SQL queries against the\NWikipedia databases, and then we might be
Dialogue: 0,0:28:48.17,0:28:53.36,Default,,0000,0000,0000,,able to find a solution for that, and\Nthat's I think at 6 p.m. today over in the
Dialogue: 0,0:28:53.36,0:29:05.52,Default,,0000,0000,0000,,Esszimmer, or you come over to me after\Nthe talk and then I can try to figure it out there.
Dialogue: 0,0:29:05.52,0:29:10.37,Default,,0000,0000,0000,,H: A last emergency idea that we have to\Ntry out?
Dialogue: 0,0:29:10.37,0:29:15.97,Default,,0000,0000,0000,,H: I'm muted. Do you have ano– one more\Nidea? A small idea maybe we could do but
Dialogue: 0,0:29:15.97,0:29:18.01,Default,,0000,0000,0000,,other than that I think we are, so– filled\Nthe time quite well.
Dialogue: 0,0:29:18.01,0:29:23.15,Default,,0000,0000,0000,,L: Yeah I think we're done. But if you\Nhave any other ideas, you can always
Dialogue: 0,0:29:23.15,0:29:30.12,Default,,0000,0000,0000,,contact me on Twitter @wikidatafacts, or\Non Mastodon as well, and then I will see
Dialogue: 0,0:29:30.12,0:29:39.49,Default,,0000,0000,0000,,what I can do for you. Yeah. Thanks.\NH: Thank you very much, Lucas, that was a
Dialogue: 0,0:29:39.49,0:29:42.44,Default,,0000,0000,0000,,great introduction to Wikidata querying!
Dialogue: 0,0:29:42.44,0:29:44.43,Default,,0000,0000,0000,,{\i1}Music{\i0}
Dialogue: 0,0:29:44.43,0:30:10.00,Default,,0000,0000,0000,,Subtitles created by c3subtitles.de\Nin the year 2021. Join, and help us!