Wikimedia Hackathon 2021/Data Challenge

From mediawiki.org

Welcome to the Wikimedia Hackathon "Data Challenge" a set of SPARQL tasks that should be completed within one and a half hours by teams of two-three people. The event starts at 19:00 UTC and the questions will be made available here at that time.

The answers should be one SPARQL query per question and must be sent to Abbe98(Abbe98 on Telegram) before 21:00 UTC, include the short links to the queries as well as the usernames of your team members. You can do the questions in any order you want and even skip some. Your answers will be graded on a scale of 0-5 based on, does it work, precision (how well does the query answer the question), performance (time to execute), and elegance.

The results will be announced on #wikimedia-hackathon (IRC) and Wikimedia Hackathon (Telegram) later this weekend. Do you have questions about this challenge our are you looking for a team? Let us know in one of the channels above or reach out to one of the organizers (User:Abbe98, User:Ainali, User:VIGNERON, and User:Fuzheado).


# Tasks
1 Create a list of all the water bodies (sea, lake or river) in Sweden.
2 Create a list of all the rivers in France that end in the Mediterranean and rank them in descending order of length (high to low).
3 Map out the coordinates of all the rivers in France, highlight the ones that end in the Mediterranean (in the WDQS-GUI map)
4 Showcase all the images of different goat species.
5 List all of the goat species and sort them by their status of conservation. Hint: The conservation status assigned by the International Union for Conservation of Nature.
6 Map out the coordinates of all the shipwrecks on the Earth.
7 Pinpoint/highlight the coordinates of the RMS Titanic among all of the shipwrecks on Earth.
8 Which films have been named after the RMS Titanic incident? Showcase them on a timeline based on when the film was published/released.
9 How many Academy awards did the film Titanic (1997) film win?
10 Which other films have won the same number of Academy awards as the Titanic film (1997)?
11 Showcase a timeline of the films that Leonardo DiCaprio has cast in before the movie Titanic (1997)?
12 In which films have Leonardo DiCaprio and Kate Winslet been cast in together?
13 Create a list of all the COVID-19 vaccines and include the developers of these vaccines.
14 Create a list of all the scholarly articles on COVID-19 with "Wikipedia" in the title?
15 Create a map of all volcanoes on Earth and color them by country.
16 Make a list of the 100 least common properties used on volcanoes (items that represents volcanoes).