First Test#

This is the first test. You work in teams of two persons. Find your partner in the table below. Make sure to hand-in your finished test as a .pdf file (or the .ipynb file) via e-mail.

Please hand in your results by Friday 06-12-2024 18:00.

Group

People

Topic / Key

user id

points (max 100)

01

Finn + Milena

amenity

2115242

10 / 30 / 30 / 30

02

Jakob + Robin

building

18512759

10 / 30 / 30 / 30

03

Marius + Paul

healthcare

21883015

10 / 30 / 30 / 30

04

Levi + Sarah

highway

21870918

10 / 28 / 30 / 30

05

Guillaume + Veronika

landuse

21874926

10 / 30 / 30 / 30

06

Leon + Suzanne

man_made

20208509

5 / 20 / 30 / 20

07

Sylvia + Marlene

natural

205595

10 / 30 / 30 / 28

08

Pui-Yi + Julia

place

4868399

10 / 27 / 30 / 30

09

Julian + Diego

railway

21890681

10 / 30 / 30 / 30

10

Arin + Antonia

shop

1702531

10 / 30 / 25 /27

11

Dominik

waterway

5589

10 / 30 / 30 / 30

Data Structure (10P)#

(5P) What is the most common OSM type used for your topic (OSM tag key) on a global level? Provide an overview on the number of nodes, ways and relations for this topic.

(5P) List the five most common tag values used in OSM for your topic.

Data Download (30P)#

(15P) Download OSM data through the HOT Export tool as a geopackage file. Make sure to only download data related to your topic and the five most commonly used values for the given bounding box: 8.3306475,49.4169067,8.5336475,49.5479067. Provide the download link you got via e-mail.

(15P) Download OSM data through the Overpass-Turbo. Make sure to only download data related to your topic and the five most commonly used values. Provide a link to Overpass-Turbo which directly runs the query in a web browser. Use the same bounding box.

(If the download fails due to data size restrictions, first try to adjust the timeout parameter. If this doesn’t work make sure to reduce the size of the area of interest by adjusting the bounding box.)

Simple Counts (30P)#

(15P) Visualize the number of all OSM features related to your topic on a monthly basis since 2012-01-01 for Northern Ireland and distinguish this by OSM type. Ideally all are visualized in a single plot.

(15P) Visualize the number of OSM features related to your topic which contain the 5 most common values on a monthly basis since 2012-01-01 for Northern Ireland and distinguish this by tag (value). Ideally all are visualized in a single plot.

In case your query runs into timeouts you can neglect relations in this part of the exercise.

Analyzing Changesets (30P)#

(5P) Count the number of changesets and the overall number of changes (num_changes) in the given geopackage file

(10P) Furthermore, report the date range this dataset is covering. Finally, provide the number of changesets, number of distinct users and number of changes for all edits which happened on 2024-09-03.

(15P) Visualize the spatial distribution of changesets for the OSM user ID assigned to your group. Consider the full time range of the changeset data. Derive the changeset centroid to create a heatmap representation and add a basemap. Then export your map (including legend, title and information about the data source) as a .png file.