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!