@metadata | sourceLanguage | "en" |
---|
priorityLanguages | |
---|
allowOnlyPriorityLanguages | true |
---|
description | "video in Test Rerun Course - Learn the skills Topics for Impact organizers need to run consistent, high-impact campaigns that invite new contributors, partners, and supporters to the movement. " |
---|
|
---|
display_name | "Video" |
---|
subtitle-5939-9509-1 | "So I'm going to show you a query that I created that" |
---|
subtitle-9576-13980-2 | "I think might be a really good example of something you might want to do." |
---|
subtitle-14080-17083-3 | "So I'm going to I'm going to tell you a scenario and then I'm going" |
---|
subtitle-17083-20487-4 | "to show you how I built this query to match that scenario." |
---|
subtitle-20553-25091-5 | "So say I'm in Nigeria and I'm running editathons about the impacts" |
---|
subtitle-25091-28628-6 | "of climate change in Nigeria, like agriculture," |
---|
subtitle-28728-31631-7 | "every city in Nigeria." |
---|
subtitle-31631-35735-8 | "It just like how all food is affected by climate change." |
---|
subtitle-35835-39606-9 | "All cities are affected by climate change and other environmental issues." |
---|
subtitle-39706-45211-10 | "So what I would need to do is discover which city articles" |
---|
subtitle-45311-49516-11 | "mention climate change or some other environmental issue" |
---|
subtitle-49549-53787-12 | "like plastic pollution or other types of pollution?" |
---|
subtitle-53853-55188-13 | "And what I want" |
---|
subtitle-55188-58758-14 | "new editors to do, because I don't want to throw new ideas at writing" |
---|
subtitle-58892-63329-15 | "new articles, is edit these existing city pages," |
---|
subtitle-63396-66199-16 | "particularly I want them to edit city pages that don't have" |
---|
subtitle-66199-69969-17 | "a lot of content to make the pages more useful for a public." |
---|
subtitle-70070-71337-18 | "So what do I do?" |
---|
subtitle-71337-73339-19 | "Well, the first step" |
---|
subtitle-73339-75275-20 | "for this is running a wiki" |
---|
subtitle-75275-78278-21 | "data query asking I want all items" |
---|
subtitle-78378-82749-22 | "which are a subclass instance of or a subclass of" |
---|
subtitle-82849-87654-23 | "human settlement that have the country of Nigeria." |
---|
subtitle-87720-91758-24 | "This wiki data query produces about 839 results on" |
---|
subtitle-91925-95228-25 | " a little over" |
---|
subtitle-95395-98765-26 | "a thousand or something on the query service." |
---|
subtitle-98865-104070-27 | "When I run the query and then I combine it with" |
---|
subtitle-104137-106773-28 | "yeah, so if I run the query and I combine it with this" |
---|
subtitle-106773-111377-29 | "filter links to climate change or climate change in Nigeria," |
---|
subtitle-111444-115915-30 | "you and I make sure that I use the wiki English Wikipedia." |
---|
subtitle-115982-118751-31 | "I get this result 839 pages" |
---|
subtitle-118751-121754-32 | "that don't talk about climate change." |
---|
subtitle-121754-126226-33 | "Now if I am running an event for new editors," |
---|
subtitle-126292-129929-34 | "sending them to, say, Port Harcourt" |
---|
subtitle-129929-133766-35 | "or Benin City, which are big cities" |
---|
subtitle-133833-138972-36 | "that have lots of page views and lots of content, might not be" |
---|
subtitle-138972-144511-37 | "very smart on my part as an organizer because these are the cities that are" |
---|
subtitle-144577-149249-38 | "more likely to have good, high quality content on them already." |
---|
subtitle-149315-153887-39 | "And they're also, you know, kind of probably watched" |
---|
subtitle-153953-155955-40 | "by existing community members." |
---|
subtitle-155955-159025-41 | "Well, Benin City, not as much because this is a higher quality" |
---|
subtitle-159025-162028-42 | "of an article, less citations, etc.." |
---|
subtitle-162028-165698-43 | "But if I set new editors to work on the Port Harcourt article," |
---|
subtitle-165765-172172-44 | "probably not going to have the best result from a community reception standpoint." |
---|
subtitle-172272-174741-45 | "But many of these smaller cities" |
---|
subtitle-174741-179112-46 | "that have much smaller articles are like great places to start." |
---|
subtitle-179179-181748-47 | "And if ... but I probably don't want" |
---|
subtitle-181748-187887-48 | "a list of 839 results so I could, like I did with the other articles" |
---|
subtitle-187954-191391-49 | "filter for articles that aren't too big but not too small." |
---|
subtitle-191524-194761-50 | "This gets rid of stubs that are under like" |
---|
subtitle-194761-198164-51 | "3000 4000 bytes and" |
---|
subtitle-198231-201534-52 | "smaller than 2000 bytes." |
---|
subtitle-201601-207040-53 | "And this might give me a much more manageable list that I could work from." |
---|
subtitle-207140-210410-54 | "And once I have this list, so we'll see the query run" |
---|
subtitle-210410-222422-55 | "on the second one." |
---|
subtitle-222522-226960-56 | "So I have a similar list that I ran earlier right here." |
---|
subtitle-226993-229796-57 | "So I see I only filter by 5000 bytes." |
---|
subtitle-229796-231431-58 | "So everything bigger than that." |
---|
subtitle-231431-235768-59 | "So these are cities that, you know, probably worth editing on." |
---|
subtitle-235768-239472-60 | "Write about 330 city articles" |
---|
subtitle-239539-240740-61 | "and then we'll see the query." |
---|
subtitle-240740-245211-62 | "I just ran 296 so I got a similar result by removing" |
---|
subtitle-245211-249482-63 | "big and small articles and just removing the smaller ones." |
---|
subtitle-249582-252252-64 | "Once I have that, I can go to mass" |
---|
subtitle-252252-257590-65 | "use with those articles and I can ask like" |
---|
subtitle-257690-261961-66 | "which of these articles are going to have the most impact?" |
---|
subtitle-262061-264797-67 | "Wow, that rain is loud." |
---|
subtitle-264797-268835-68 | "I hope you all are hearing that and you'll see that here." |
---|
subtitle-268835-272305-69 | "The couple of cities have about 10,000 pageviews a month." |
---|
subtitle-272372-277110-70 | "And then we have a whole bunch of them that are like medium sized cities." |
---|
subtitle-277110-281180-71 | "You know, I'm not from Nigeria, but I can obviously throw away" |
---|
subtitle-281414-285051-72 | "like the articles that really don't have a lot of page views because it's" |
---|
subtitle-285051-289422-73 | "probably not going to help like improve public awareness about climate change." |
---|
subtitle-289489-293459-74 | "If I say drop the ones that have less than 200 page views," |
---|
subtitle-293559-296262-75 | "and so that gives me about 100 articles to work on," |
---|
subtitle-296262-299532-76 | "which is a very manageable list for a community event." |
---|
subtitle-299599-300800-77 | "Right?" |
---|
subtitle-300800-304137-78 | "And what's nice about this is I could start from the wiki" |
---|
subtitle-304137-309142-79 | "data query if I had started from the category" |
---|
subtitle-309208-309776-80 | "cities in" |
---|
subtitle-309776-313212-81 | "Nigeria, you'll realize very quickly that it introduces" |
---|
subtitle-313212-316215-82 | "a lot of like bad baggage" |
---|
subtitle-316282-318918-83 | "because of the depth of articles." |
---|
subtitle-318918-324457-84 | "So cities in Nigeria," |
---|
subtitle-324557-325224-85 | "when you" |
---|
subtitle-325224-329329-86 | "when you look at this category, it becomes very obvious very quick" |
---|
subtitle-329395-332131-87 | "that this is not going to be very good content." |
---|
subtitle-332131-337804-88 | "For example, the subcategory in Lagos has all of the buildings in economy" |
---|
subtitle-337804-342942-89 | "and people from Lagos and every single one of these subcategories" |
---|
subtitle-343009-347714-90 | "has some weird mix of like city articles and not city articles." |
---|
subtitle-347714-348214-91 | "Right?" |
---|
subtitle-348214-351417-92 | "So it makes no sense to use categories to do this." |
---|
subtitle-351417-352018-93 | "A wiki data" |
---|
subtitle-352018-355855-94 | "query is going to be much more accurate, and then you can do the filtering" |
---|
subtitle-355888-362595-95 | "from information that you have on Wikipedia." |
---|
subtitle-362662-375641-96 | "Any questions about using wiki data to like modify one of these queries?" |
---|
subtitle-375708-376309-97 | "Yeah, go ahead." |
---|
subtitle-376309-379479-98 | "Bukola." |
---|
subtitle-379579-380513-99 | "Okay." |
---|
subtitle-380513-383816-100 | "I think I'm kind of lost at the point" |
---|
subtitle-383816-390022-101 | "where you move from page well to Mass View." |
---|
subtitle-390089-392425-102 | "Mm hmm. I don't know how you do." |
---|
subtitle-392425-399165-103 | "Did you, like, copy the link from the web page scan" |
---|
subtitle-399232-403169-104 | "and then move to the massviews?" |
---|
subtitle-403269-404737-105 | "Yeah." |
---|
subtitle-404737-407740-106 | "So if we take this query where I have about" |
---|
subtitle-407840-411844-107 | "296 articles from" |
---|
subtitle-411944-412979-108 | "from Nigeria." |
---|
subtitle-412979-415381-109 | "So these are cities in Nigeria" |
---|
subtitle-415381-419085-110 | "based on the wiki data query output for English Wikipedia." |
---|
subtitle-419085-422422-111 | "So our articles exist on English Wikipedia." |
---|
subtitle-422488-426292-112 | "I modified it so that it tells me all the articles" |
---|
subtitle-426292-431764-113 | "that don't link to climate change or climate change in Nigeria and also" |
---|
subtitle-431798-436469-114 | "made sure that they're bigger than 5000 bytes and smaller than 2000 bytes." |
---|
subtitle-436536-439338-115 | "Once I run that query, which is the result" |
---|
subtitle-439338-443242-116 | "I just shared there, that's that's here, I click do it there." |
---|
subtitle-443309-446312-117 | "I'm like, okay, so I don't want the HTML output." |
---|
subtitle-446479-448548-118 | "What I want is the PagePile output." |
---|
subtitle-448548-451484-119 | "So I click do it." |
---|
subtitle-451551-453219-120 | "When I click, do it right." |
---|
subtitle-453219-456222-121 | "So I pick PagePile, format, output and do it." |
---|
subtitle-456456-459959-122 | "It creates a PagePile for me." |
---|
subtitle-460026-466299-123 | "After it runs the query." |
---|
subtitle-466399-467300-124 | "Okay, I got." |
---|
subtitle-467300-468234-125 | "I got that part." |
---|
subtitle-468234-472472-126 | "More like how would you move it to a mass view?" |
---|
subtitle-472572-476609-127 | "So once I know what the the number for the query is," |
---|
subtitle-476676-480246-128 | "what I can do is go to MassViews." |
---|
subtitle-480346-482915-129 | "And mass views has a number of options." |
---|
subtitle-482915-487353-130 | "Practically most people only use categories and page pile" |
---|
subtitle-487453-490089-131 | "unless you're doing something a little bit more complex." |
---|
subtitle-490089-491624-132 | "Right." |
---|
subtitle-491624-495194-133 | "And you just select the source for page pile." |
---|
subtitle-495261-498264-134 | "You select the time window that you want to track." |
---|
subtitle-498264-501267-135 | "So last month," |
---|
subtitle-501267-509609-136 | "and then I can drop the PagePile in there and click submit." |
---|
subtitle-509675-509976-137 | "Great." |
---|
subtitle-509976-511644-138 | "Thanks. Yeah." |
---|
subtitle-511644-517250-139 | "And this is like really a good way to do prioritization, right through page views." |
---|
subtitle-517316-520119-140 | "And I think this is something that, you know," |
---|
subtitle-520119-523189-141 | "I notice a lot of organizers like working on big language" |
---|
subtitle-523189-527727-142 | "Wikipedias from the Global South are often like trying" |
---|
subtitle-527727-532932-143 | "to create new articles on the edges which don't get a lot of interaction." |
---|
subtitle-533099-536068-144 | "When we have articles like Port Harcourt," |
---|
subtitle-536068-540606-145 | "which is a pretty important city in Nigeria," |
---|
subtitle-540640-541574-146 | "right," |
---|
subtitle-541574-544577-147 | "It's very likely to have," |
---|
subtitle-544577-547146-148 | "you know, news coverage outside of Nigeria," |
---|
subtitle-547146-550082-149 | "so it's like a good representation of cultural context." |
---|
subtitle-550082-551851-150 | "Like expanding this article," |
---|
subtitle-551851-555288-151 | "adding things like air pollution, adding things like climate change," |
---|
subtitle-555521-560192-152 | "adding things like, you know, plastic pollution and stuff is like a powerful way" |
---|
subtitle-560293-564830-153 | "to like both teach people how to edit on Wikipedia," |
---|
subtitle-564897-570870-154 | "Make sure those edits have impact and then also reach a public." |
---|
subtitle-570937-572905-155 | "Now, that might not be your goal." |
---|
subtitle-572905-576342-156 | "Your goal might not be like reach people with content." |
---|
subtitle-576409-579045-157 | "But I think this is like a good strategic move" |
---|
subtitle-579045-587219-158 | "if that's the kind of change you want to make." |
---|
subtitle-587286-590389-159 | "And it's not to say you shouldn't be doing other cultural documentation too," |
---|
subtitle-590623-593659-160 | "but I think campaigns like WikiforHumanRights provide you" |
---|
subtitle-593659-596662-161 | "this opportunity to prioritize differently." |
---|
subtitle-596729-602101-162 | "Now Bukolo, did you still have question your hand and start?" |
---|
subtitle-602168-606939-163 | "You can also do some pretty cool stuff once you have this query." |
---|
subtitle-606973-608107-164 | "Right." |
---|
subtitle-608107-611444-165 | "So instead of doing that enwiki output here," |
---|
subtitle-611510-614513-166 | "I could do a WikiData output" |
---|
subtitle-614714-617550-167 | "for for the results from the articles." |
---|
subtitle-617550-623322-168 | "So I and the other sources I go from use enwiki to WikiData" |
---|
subtitle-623389-625524-169 | "and if I go" |
---|
subtitle-625524-628361-170 | "do it," |
---|
subtitle-628361-635067-171 | "it'll give me the the output from wiki data." |
---|
subtitle-635134-638137-172 | "And if I were say" |
---|
subtitle-638270-642308-173 | "so there's a property on" |
---|
subtitle-642408-645011-174 | "WikiData called i." |
---|
subtitle-645011-648014-175 | "It's 500." |
---|
subtitle-648014-651017-176 | "I forget what it is. I'll look it up for" |
---|
subtitle-651083-658557-177 | "wikimedia project property data." |
---|
subtitle-658624-662828-178 | "So I'm focus list of Wikimedia project." |
---|
subtitle-662928-667166-179 | "So I could go P5008" |
---|
subtitle-667233-688287-180 | "and once I have the result from the query" |
---|
subtitle-688354-691657-181 | " that's about what I want." |
---|
subtitle-691757-692892-182 | "Here it is." |
---|
subtitle-692892-696429-183 | "Once I have the result from the query," |
---|
subtitle-696529-700466-184 | "which is going to be a different number because it's wiki data" |
---|
subtitle-700533-705838-185 | "I could drop, I can actually like initiate batch edits here." |
---|
subtitle-705938-708140-186 | "So if I wanted to say" |
---|
subtitle-708140-713879-187 | "I create a climate change in Nigeria," |
---|
subtitle-713979-719418-188 | "kind of Wikimedia project like focus project," |
---|
subtitle-719485-720319-189 | "I could say" |
---|
subtitle-720319-726592-190 | "P5008" |
---|
subtitle-726659-730362-191 | "q101421920." |
---|
subtitle-730429-735167-192 | "And I can actually, like, take me directly to edit quick statements." |
---|
subtitle-735234-738771-193 | "So I can do a batch edit, I can edit all 600 of these pages" |
---|
subtitle-738771-741741-194 | "based on sorting and filtering I just did" |
---|
subtitle-741907-744877-195 | "with," |
---|
subtitle-744877-745911-196 | "with the tool." |
---|
subtitle-745911-750249-197 | "Now I'm not going to make this edit, but you can use quick statements to then edit" |
---|
subtitle-750349-754120-198 | "and then that makes WikiData queries simpler, which means and then you can go" |
---|
subtitle-754120-757623-199 | "do something else with PET scan that allows you to filter." |
---|
subtitle-757857-761060-200 | "So you can go back and forth between WikiData" |
---|
subtitle-761060-765030-201 | "and PET scan in a way that allows you to refine the data" |
---|
subtitle-765097-768634-202 | "that then, you know, leaves a public mark" |
---|
subtitle-768734-772004-203 | "on WikiData to for that impact." |
---|
subtitle-772071-774306-204 | "Yeah, go ahead." |
---|
subtitle-774406-774774-205 | "Yeah." |
---|
subtitle-774774-775374-206 | "Abigail." |
---|
subtitle-775374-781080-207 | "The main purpose of PET scan is queries, but it has this nice side effect, right?" |
---|
subtitle-781080-784650-208 | "Where it makes it very easy to edit WikiData" |
---|
subtitle-784717-786986-209 | "in batch that I think" |
---|
subtitle-786986-789922-210 | "a lot of people don't quite notice" |
---|
subtitle-789922-794193-211 | "because you have to have the settings set up right?" |
---|
subtitle-794293-798097-212 | "The previous CatScan tool, which I don't think is still supported." |
---|
subtitle-798264-799598-213 | "Right." |
---|
subtitle-799598-802101-214 | "Was basically just this page" |
---|
subtitle-802101-805638-215 | "like this first set of options." |
---|
subtitle-805704-809842-216 | "The PETScan is really powerful because it allows you" |
---|
subtitle-809842-813145-217 | "to grab these other things and it allows you to kind of" |
---|
subtitle-813145-816649-218 | "take advantage of all of the data that mediawiki has, right?" |
---|
subtitle-816649-822688-219 | "So size of page, links, when pages were edited, things like that." |
---|
subtitle-822688-823022-220 | "Right?" |
---|
subtitle-823022-827026-221 | "So you can actually like as an organizer be a bit more intentional" |
---|
subtitle-827126-831630-222 | "about the recommendations you're making or for like personal use," |
---|
subtitle-831697-834266-223 | "you can kind of set up like" |
---|
subtitle-834333-834600-224 | "kind of" |
---|
subtitle-834600-837603-225 | "queues of content you want to work on." |
---|
subtitle-837670-839772-226 | "That's that's easy to do." |
---|
subtitle-839772-842942-227 | "I also find that like" |
---|
subtitle-843042-845377-228 | "I really like the Tabernacle tool," |
---|
subtitle-845377-850416-229 | "like this is a really good tool for like taking some kind of conclusion" |
---|
subtitle-850583-855654-230 | "based on Wikipedia categories or something else" |
---|
subtitle-855721-860626-231 | "and putting it into WikiData in a more manual way" |
---|
subtitle-860693-863429-232 | "so you can decide like what other kinds of properties" |
---|
subtitle-863429-867466-233 | "you want to add, or if you want to translate labels or whatnot," |
---|
subtitle-867533-870202-234 | "you don't need to use PagePile" |
---|
subtitle-870202-871370-235 | "to do this right." |
---|
subtitle-871370-875507-236 | "You can do it with a SPARQL query, but sometimes, often" |
---|
subtitle-875574-878811-237 | "there's a lot of information on, say, Wikipedia or Commons" |
---|
subtitle-878878-881313-238 | "that is not yet on Wikipedia." |
---|
subtitle-881313-892858-239 | "And so knowing how to like, make these connections is really it's really powerful." |
---|
subtitle-892958-893425-240 | "Yeah." |
---|
subtitle-893425-895628-241 | "So so" |
---|
subtitle-895628-898097-242 | "PETScan, you know," |
---|
subtitle-898097-902067-243 | "first, like the simple PETScan, you really want to pay attention." |
---|
subtitle-902067-905704-244 | "So Abigail is asking Tabernacle a little bit friendlier with the column." |
---|
subtitle-905804-909575-245 | "Yeah, I think, like once you have a list" |
---|
subtitle-909675-912678-246 | "or a query that someone has produced for you," |
---|
subtitle-912711-915614-247 | "Tabernacles a really good way to edit WikiData." |
---|
subtitle-915614-918918-248 | "And it's also if like a lot of things are exactly the same, you can actually" |
---|
subtitle-918918-922121-249 | "copy and paste data" |
---|
subtitle-922221-923789-250 | "things too as well." |
---|
subtitle-923789-928227-251 | "It's not great if you want to add reference statements to WikiData." |
---|
subtitle-928227-929028-252 | "And so." |
---|
subtitle-929028-931964-253 | "So this is where it's" |
---|
subtitle-931964-933666-254 | "useful" |
---|
subtitle-933666-934600-255 | "for PETScan." |
---|
subtitle-934600-938537-256 | "Again kind of things where places where I break queries" |
---|
subtitle-938704-941840-257 | "a lot and, and I think most users of PETScan" |
---|
subtitle-941840-944910-258 | " will tell you depth of articles." |
---|
subtitle-944910-951717-259 | "So if I try to go too deep on categories, this will create a lot of problems." |
---|
subtitle-951784-953819-260 | "...." |
---|
subtitle-953819-955554-261 | "like having the wrong" |
---|
subtitle-955554-958557-262 | "wiki for the output can create problems" |
---|
subtitle-958791-963829-263 | "trying to do the wrong combination of different features." |
---|
subtitle-963829-968267-264 | "Like if you do categories and SPARQL and it doesn't make a lot of sense." |
---|
subtitle-968334-970970-265 | "Yeah, that that might break." |
---|
subtitle-970970-971437-266 | "I don't." |
---|
subtitle-971437-975274-267 | "I don't know if catscan can still work so I think he might have retired it" |
---|
subtitle-975274-979611-268 | "many years ago which I mean yeah so" |
---|
subtitle-979678-984550-269 | "At one point I did do a training on on CATScan" |
---|
subtitle-984650-987353-270 | "but I think Yeah." |
---|
subtitle-987353-990356-271 | "So it's been replaced by PET scan." |
---|
subtitle-990456-996028-272 | "So so CAT scan was 2013 or 11 tool" |
---|
subtitle-996095-1000232-273 | "PET scan is is the modern one" |
---|
subtitle-1000332-1003569-274 | "and you know he's always" |
---|
subtitle-1003669-1008040-275 | "adding features and updates and so sometimes" |
---|
subtitle-1008140-1010909-276 | "things break or change" |
---|
subtitle-1010909-1016015-277 | "which is you know, kind of a challenge with many of the volunteer" |
---|
subtitle-1016015-1021286-278 | "built tools around that we rely on for list building." |
---|
subtitle-1021353-1024690-279 | "Now. Yeah, but" |
---|
subtitle-1024857-1028027-280 | "You can tell the documentation" |
---|
subtitle-1028027-1032297-281 | "is not very good on meta but as you saw" |
---|
subtitle-1032531-1037002-282 | "like it took me over an hour just to walk through all the features" |
---|
subtitle-1037069-1039638-283 | "of PET scan" |
---|
subtitle-1039638-1042141-284 | "and I was breaking it" |
---|
subtitle-1042141-1046345-285 | "occasionally and like the queries didn't perform the way I wanted to." |
---|
subtitle-1046445-1051383-286 | "I don't think this is a tool that documentation helps you figure out." |
---|
subtitle-1051383-1054386-287 | "I think it's best to watch someone else build a query" |
---|
subtitle-1054520-1058424-288 | "and look at the sections and then try it yourself." |
---|
subtitle-1058490-1060526-289 | "It's a bit like writing a Wikidata query." |
---|