{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "58eeec7f",
   "metadata": {},
   "source": [
    "# First Test\n",
    "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.\n",
    "\n",
    "Please hand in your results by `2023-12-01 18:00`.\n",
    "\n",
    "| Group | People | Topic  / Key | user id |points |\n",
    "|-------| ------ |--------------|---------|--- |\n",
    "| 01    | Clara + Vincent | amenity      | 10655925 |7 / 29 / 5 / 5 |\n",
    "| 02    | Amir + Simon  | building     | 10710752 | 10 / 30 / 25 / 30 |\n",
    "| 03    | Melissa + Johanna  | healthcare   | 570635   |10 / 15 / 15 / 10 |\n",
    "| 04    | Lars + Celina | highway      | 10722817 | 10 / 30 / 30 / 30 |\n",
    "| 05    | Joel + Matthias | landuse      | 651065   | 10 / 30 / 30 / 30  |\n",
    "| 06    | Teo + Philipp H. | man_made     | 4256181  | 9 / 30 / 30 /  25 |\n",
    "| 07    | Maxi + Max  | natural      | 10688626 | 10 / 30 / 30 / 30 |\n",
    "| 08    | Tim + Lara  | place        | 10683628 | 10 / 30 / 30 / 30 |\n",
    "| 09    | Philipp T. + Hannah | railway      | 10716141 | 5 / 30 / 30 / 10 | \n",
    "| 10    | Tobi + Sebastian  | shop         | 10683903 | 10 / 30 / 30 / 30 |"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "117fae45",
   "metadata": {},
   "source": [
    "## Data Structure (10P)\n",
    "What is the most common OSM type used for your topic on a global level? Provide an overview on the number of nodes, ways and relations for this topic. (5P)\n",
    "\n",
    "List the five most common values used in OSM for your topic. (5P)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "68e9c939",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "c3ceeb1c",
   "metadata": {},
   "source": [
    "## Data Download (30P)\n",
    "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.553,49.35,8.756,49.481`. Provide the download link you got via e-mail. (15P)\n",
    "\n",
    "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. (15P)\n",
    "\n",
    "(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.) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2fcb3e2e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "225ebf5a",
   "metadata": {},
   "source": [
    "## Simple Counts (30P)\n",
    "Visualize the number of all OSM features related to your topic on a monthly basis since 2012-01-01 for Denmark and distinguish this by OSM type. (15P)\n",
    "\n",
    "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 Denmark and distinguish this by tag (value). (15P)\n",
    "\n",
    "In case your query runs into timeouts you can neglect `relations` in this part of the exercise."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2b358e2c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "9fec251d",
   "metadata": {},
   "source": [
    "## Analyzing Changesets (30P)\n",
    "Count the number of change sets and the overall number of changes (`num_changes`) created at 02.02.2020 in the given [geopackage file](https://heibox.uni-heidelberg.de/f/87fe1933837e4e5491fd/). (10P)\n",
    "\n",
    "Visualize the global distribution of changesets using the changeset centroid for the OSM user ID assigned to your group. Consider the full time range of the changeset data. Use a heatmap representation and add a basemap. Then export your map (including legend, title and information about the data source) as a `.png` file. (20P)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "164d9309",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}