VolcanoesAviationColorCodes.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The Icelandic Met Office issues color codes for aviation safety for each of the volcanoes it monitors. You can grab a list of those volcanoes and their color code through our API."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.epos-iceland.is/v1/volcano/products/aviation_color_codes?bbox=62,-25,67,-11&format_type=JSON\n"
     ]
    }
   ],
   "source": [
    "# string to get volcanoes and their colors\n",
    "# https://api.epos-iceland.is/v1/volcano/products/aviation_color_codes?bbox=62%2C-25%2C67%2C-11&format_type=JSON\n",
    "# docs:\n",
    "# https://docs.epos-iceland.is/#/Volcano%20obervations%20%3E%20Products%2C%20reports%20%26%20information/volcanoes_callaviationcolorcodes\n",
    "\n",
    "\n",
    "# build request string\n",
    "base_url = 'https://api.epos-iceland.is/v1/volcano/products/aviation_color_codes?'\n",
    "bounding_box = \"bbox=62,-25,67,-11\"\n",
    "file_format = \"format_type=JSON\"\n",
    "\n",
    "string = base_url + bounding_box + '&' + file_format\n",
    "print(string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'volcano_name': 'Fagradalsfjall',\n",
       "  'volcano_name_si': 'Fagradalsfjall',\n",
       "  'volcano_id': '371032',\n",
       "  'latitude': 63.895,\n",
       "  'longitude': -22.258,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2023-08-16T11:44:35.261605Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Eldey',\n",
       "  'volcano_name_si': 'Reykjanes',\n",
       "  'volcano_id': '371022',\n",
       "  'latitude': 63.733,\n",
       "  'longitude': -23.0,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2023-07-11T16:40:08.713479Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Katla',\n",
       "  'volcano_name_si': 'Katla',\n",
       "  'volcano_id': '372030',\n",
       "  'latitude': 63.633,\n",
       "  'longitude': -19.117,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2023-05-05T11:04:51.372791Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Grímsvötn',\n",
       "  'volcano_name_si': 'Grimsvotn',\n",
       "  'volcano_id': '373010',\n",
       "  'latitude': 64.417,\n",
       "  'longitude': -17.333,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2022-11-09T07:57:50.154155Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Askja',\n",
       "  'volcano_name_si': 'Askja',\n",
       "  'volcano_id': '373060',\n",
       "  'latitude': 65.05,\n",
       "  'longitude': -16.783,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2022-11-09T07:54:42.992339Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Krýsuvík',\n",
       "  'volcano_name_si': 'Krysuvik',\n",
       "  'volcano_id': '371030',\n",
       "  'latitude': 63.917,\n",
       "  'longitude': -22.067,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2022-09-15T15:29:52.108190Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Reykjanes',\n",
       "  'volcano_name_si': 'Reykjanes',\n",
       "  'volcano_id': '371020',\n",
       "  'latitude': 63.817,\n",
       "  'longitude': -22.717,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2022-06-02T11:49:38.513240Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Helgrindur',\n",
       "  'volcano_name_si': 'Helgrindur',\n",
       "  'volcano_id': '370020',\n",
       "  'latitude': 64.867,\n",
       "  'longitude': -23.25,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2020-11-12T14:36:08.129673Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Snæfellsjökull',\n",
       "  'volcano_name_si': 'Snaefellsjokull',\n",
       "  'volcano_id': '370010',\n",
       "  'latitude': 64.8,\n",
       "  'longitude': -23.783,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2020-11-12T14:33:34.946495Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Fremrinámar',\n",
       "  'volcano_name_si': 'Fremrinamar',\n",
       "  'volcano_id': '373070',\n",
       "  'latitude': 65.433,\n",
       "  'longitude': -16.667,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2020-10-28T14:38:01.123294Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Öræfajökull',\n",
       "  'volcano_name_si': 'Oraefajokull',\n",
       "  'volcano_id': '374010',\n",
       "  'latitude': 64.0,\n",
       "  'longitude': -16.65,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2018-05-04T11:24:22.418449Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Hofsjökull',\n",
       "  'volcano_name_si': 'Hofsjokull',\n",
       "  'volcano_id': '371090',\n",
       "  'latitude': 64.8,\n",
       "  'longitude': -18.9,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Hrómundartindur',\n",
       "  'volcano_name_si': 'Hromundartindur',\n",
       "  'volcano_id': '371051',\n",
       "  'latitude': 64.067,\n",
       "  'longitude': -21.2,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Esjufjöll',\n",
       "  'volcano_name_si': 'Esjufjoll',\n",
       "  'volcano_id': '374020',\n",
       "  'latitude': 64.283,\n",
       "  'longitude': -16.583,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Krafla',\n",
       "  'volcano_name_si': 'Krafla',\n",
       "  'volcano_id': '373080',\n",
       "  'latitude': 65.717,\n",
       "  'longitude': -16.783,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Kverkfjöll',\n",
       "  'volcano_name_si': 'Kverkfjoll',\n",
       "  'volcano_id': '373050',\n",
       "  'latitude': 64.65,\n",
       "  'longitude': -16.667,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Ljósufjöll',\n",
       "  'volcano_name_si': 'Ljosufjoll',\n",
       "  'volcano_id': '370030',\n",
       "  'latitude': 64.917,\n",
       "  'longitude': -22.633,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Langjökull',\n",
       "  'volcano_name_si': 'Langjokull',\n",
       "  'volcano_id': '371080',\n",
       "  'latitude': 64.85,\n",
       "  'longitude': -19.783,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Prestahnúkur',\n",
       "  'volcano_name_si': 'Prestahnukur',\n",
       "  'volcano_id': '371070',\n",
       "  'latitude': 64.6,\n",
       "  'longitude': -20.633,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Snæfell',\n",
       "  'volcano_name_si': 'Snaefell',\n",
       "  'volcano_id': '374801',\n",
       "  'latitude': 64.8,\n",
       "  'longitude': -15.567,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Tindfjallajökull',\n",
       "  'volcano_name_si': 'Tindfjallajokull',\n",
       "  'volcano_id': '372040',\n",
       "  'latitude': 63.783,\n",
       "  'longitude': -19.567,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Torfajökull',\n",
       "  'volcano_name_si': 'Torfajokull',\n",
       "  'volcano_id': '372050',\n",
       "  'latitude': 63.933,\n",
       "  'longitude': -19.1,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Tungnafellsjökull',\n",
       "  'volcano_name_si': 'Tungnafellsjokull',\n",
       "  'volcano_id': '373040',\n",
       "  'latitude': 64.75,\n",
       "  'longitude': -17.917,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Vestmannaeyjar',\n",
       "  'volcano_name_si': 'Vestmannaeyjar',\n",
       "  'volcano_id': '372010',\n",
       "  'latitude': 63.417,\n",
       "  'longitude': -20.35,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Þeistareykir',\n",
       "  'volcano_name_si': 'Theistareykir',\n",
       "  'volcano_id': '373090',\n",
       "  'latitude': 65.883,\n",
       "  'longitude': -16.967,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Þórðarhyrna',\n",
       "  'volcano_name_si': 'Grimsvotn',\n",
       "  'volcano_id': '373012',\n",
       "  'latitude': 64.267,\n",
       "  'longitude': -17.617,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Brennisteinsfjöll',\n",
       "  'volcano_name_si': 'Brennisteinsfjoll',\n",
       "  'volcano_id': '371040',\n",
       "  'latitude': 63.95,\n",
       "  'longitude': -21.75,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Bárðarbunga',\n",
       "  'volcano_name_si': 'Bardarbunga',\n",
       "  'volcano_id': '373030',\n",
       "  'latitude': 64.633,\n",
       "  'longitude': -17.517,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Grímsnes',\n",
       "  'volcano_name_si': 'Grimsnes',\n",
       "  'volcano_id': '371060',\n",
       "  'latitude': 64.05,\n",
       "  'longitude': -20.883,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Eyjafjallajökull',\n",
       "  'volcano_name_si': 'Eyjafjallajokull',\n",
       "  'volcano_id': '372020',\n",
       "  'latitude': 63.628,\n",
       "  'longitude': -19.625,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Heiðarsporðar',\n",
       "  'volcano_name_si': 'Heidarspordar ',\n",
       "  'volcano_id': '373082',\n",
       "  'latitude': 65.583,\n",
       "  'longitude': -16.817,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Hekla',\n",
       "  'volcano_name_si': 'Hekla',\n",
       "  'volcano_id': '372070',\n",
       "  'latitude': 63.992,\n",
       "  'longitude': -19.667,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'},\n",
       " {'volcano_name': 'Hengill',\n",
       "  'volcano_name_si': 'Hengill',\n",
       "  'volcano_id': '371050',\n",
       "  'latitude': 64.083,\n",
       "  'longitude': -21.3,\n",
       "  'status': 'green',\n",
       "  'publication_date': '2015-03-01T00:00:00Z',\n",
       "  'end_date': None,\n",
       "  'source_of_information': 'IMO'}]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r = requests.get(string)\n",
    "r.encoding = 'utf-8'\n",
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = r.json()\n",
    "with open(os.path.join('data/','VolcanoColors.json'), 'w') as f:\n",
    "    json.dump(data, f)\n",
    "f.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>volcano_name</th>\n",
       "      <th>volcano_name_si</th>\n",
       "      <th>volcano_id</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>status</th>\n",
       "      <th>publication_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>source_of_information</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fagradalsfjall</td>\n",
       "      <td>Fagradalsfjall</td>\n",
       "      <td>371032</td>\n",
       "      <td>63.895</td>\n",
       "      <td>-22.258</td>\n",
       "      <td>green</td>\n",
       "      <td>2023-08-16T11:44:35.261605Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Eldey</td>\n",
       "      <td>Reykjanes</td>\n",
       "      <td>371022</td>\n",
       "      <td>63.733</td>\n",
       "      <td>-23.000</td>\n",
       "      <td>green</td>\n",
       "      <td>2023-07-11T16:40:08.713479Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Katla</td>\n",
       "      <td>Katla</td>\n",
       "      <td>372030</td>\n",
       "      <td>63.633</td>\n",
       "      <td>-19.117</td>\n",
       "      <td>green</td>\n",
       "      <td>2023-05-05T11:04:51.372791Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Grímsvötn</td>\n",
       "      <td>Grimsvotn</td>\n",
       "      <td>373010</td>\n",
       "      <td>64.417</td>\n",
       "      <td>-17.333</td>\n",
       "      <td>green</td>\n",
       "      <td>2022-11-09T07:57:50.154155Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Askja</td>\n",
       "      <td>Askja</td>\n",
       "      <td>373060</td>\n",
       "      <td>65.050</td>\n",
       "      <td>-16.783</td>\n",
       "      <td>green</td>\n",
       "      <td>2022-11-09T07:54:42.992339Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Krýsuvík</td>\n",
       "      <td>Krysuvik</td>\n",
       "      <td>371030</td>\n",
       "      <td>63.917</td>\n",
       "      <td>-22.067</td>\n",
       "      <td>green</td>\n",
       "      <td>2022-09-15T15:29:52.108190Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Reykjanes</td>\n",
       "      <td>Reykjanes</td>\n",
       "      <td>371020</td>\n",
       "      <td>63.817</td>\n",
       "      <td>-22.717</td>\n",
       "      <td>green</td>\n",
       "      <td>2022-06-02T11:49:38.513240Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Helgrindur</td>\n",
       "      <td>Helgrindur</td>\n",
       "      <td>370020</td>\n",
       "      <td>64.867</td>\n",
       "      <td>-23.250</td>\n",
       "      <td>green</td>\n",
       "      <td>2020-11-12T14:36:08.129673Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Snæfellsjökull</td>\n",
       "      <td>Snaefellsjokull</td>\n",
       "      <td>370010</td>\n",
       "      <td>64.800</td>\n",
       "      <td>-23.783</td>\n",
       "      <td>green</td>\n",
       "      <td>2020-11-12T14:33:34.946495Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Fremrinámar</td>\n",
       "      <td>Fremrinamar</td>\n",
       "      <td>373070</td>\n",
       "      <td>65.433</td>\n",
       "      <td>-16.667</td>\n",
       "      <td>green</td>\n",
       "      <td>2020-10-28T14:38:01.123294Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Öræfajökull</td>\n",
       "      <td>Oraefajokull</td>\n",
       "      <td>374010</td>\n",
       "      <td>64.000</td>\n",
       "      <td>-16.650</td>\n",
       "      <td>green</td>\n",
       "      <td>2018-05-04T11:24:22.418449Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Hofsjökull</td>\n",
       "      <td>Hofsjokull</td>\n",
       "      <td>371090</td>\n",
       "      <td>64.800</td>\n",
       "      <td>-18.900</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Hrómundartindur</td>\n",
       "      <td>Hromundartindur</td>\n",
       "      <td>371051</td>\n",
       "      <td>64.067</td>\n",
       "      <td>-21.200</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Esjufjöll</td>\n",
       "      <td>Esjufjoll</td>\n",
       "      <td>374020</td>\n",
       "      <td>64.283</td>\n",
       "      <td>-16.583</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Krafla</td>\n",
       "      <td>Krafla</td>\n",
       "      <td>373080</td>\n",
       "      <td>65.717</td>\n",
       "      <td>-16.783</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kverkfjöll</td>\n",
       "      <td>Kverkfjoll</td>\n",
       "      <td>373050</td>\n",
       "      <td>64.650</td>\n",
       "      <td>-16.667</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ljósufjöll</td>\n",
       "      <td>Ljosufjoll</td>\n",
       "      <td>370030</td>\n",
       "      <td>64.917</td>\n",
       "      <td>-22.633</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Langjökull</td>\n",
       "      <td>Langjokull</td>\n",
       "      <td>371080</td>\n",
       "      <td>64.850</td>\n",
       "      <td>-19.783</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Prestahnúkur</td>\n",
       "      <td>Prestahnukur</td>\n",
       "      <td>371070</td>\n",
       "      <td>64.600</td>\n",
       "      <td>-20.633</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Snæfell</td>\n",
       "      <td>Snaefell</td>\n",
       "      <td>374801</td>\n",
       "      <td>64.800</td>\n",
       "      <td>-15.567</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Tindfjallajökull</td>\n",
       "      <td>Tindfjallajokull</td>\n",
       "      <td>372040</td>\n",
       "      <td>63.783</td>\n",
       "      <td>-19.567</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Torfajökull</td>\n",
       "      <td>Torfajokull</td>\n",
       "      <td>372050</td>\n",
       "      <td>63.933</td>\n",
       "      <td>-19.100</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Tungnafellsjökull</td>\n",
       "      <td>Tungnafellsjokull</td>\n",
       "      <td>373040</td>\n",
       "      <td>64.750</td>\n",
       "      <td>-17.917</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Vestmannaeyjar</td>\n",
       "      <td>Vestmannaeyjar</td>\n",
       "      <td>372010</td>\n",
       "      <td>63.417</td>\n",
       "      <td>-20.350</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Þeistareykir</td>\n",
       "      <td>Theistareykir</td>\n",
       "      <td>373090</td>\n",
       "      <td>65.883</td>\n",
       "      <td>-16.967</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Þórðarhyrna</td>\n",
       "      <td>Grimsvotn</td>\n",
       "      <td>373012</td>\n",
       "      <td>64.267</td>\n",
       "      <td>-17.617</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Brennisteinsfjöll</td>\n",
       "      <td>Brennisteinsfjoll</td>\n",
       "      <td>371040</td>\n",
       "      <td>63.950</td>\n",
       "      <td>-21.750</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Bárðarbunga</td>\n",
       "      <td>Bardarbunga</td>\n",
       "      <td>373030</td>\n",
       "      <td>64.633</td>\n",
       "      <td>-17.517</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Grímsnes</td>\n",
       "      <td>Grimsnes</td>\n",
       "      <td>371060</td>\n",
       "      <td>64.050</td>\n",
       "      <td>-20.883</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Eyjafjallajökull</td>\n",
       "      <td>Eyjafjallajokull</td>\n",
       "      <td>372020</td>\n",
       "      <td>63.628</td>\n",
       "      <td>-19.625</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Heiðarsporðar</td>\n",
       "      <td>Heidarspordar</td>\n",
       "      <td>373082</td>\n",
       "      <td>65.583</td>\n",
       "      <td>-16.817</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Hekla</td>\n",
       "      <td>Hekla</td>\n",
       "      <td>372070</td>\n",
       "      <td>63.992</td>\n",
       "      <td>-19.667</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Hengill</td>\n",
       "      <td>Hengill</td>\n",
       "      <td>371050</td>\n",
       "      <td>64.083</td>\n",
       "      <td>-21.300</td>\n",
       "      <td>green</td>\n",
       "      <td>2015-03-01T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         volcano_name    volcano_name_si  volcano_id  latitude  longitude  \\\n",
       "0      Fagradalsfjall     Fagradalsfjall      371032    63.895    -22.258   \n",
       "1               Eldey          Reykjanes      371022    63.733    -23.000   \n",
       "2               Katla              Katla      372030    63.633    -19.117   \n",
       "3           Grímsvötn          Grimsvotn      373010    64.417    -17.333   \n",
       "4               Askja              Askja      373060    65.050    -16.783   \n",
       "5            Krýsuvík           Krysuvik      371030    63.917    -22.067   \n",
       "6           Reykjanes          Reykjanes      371020    63.817    -22.717   \n",
       "7          Helgrindur         Helgrindur      370020    64.867    -23.250   \n",
       "8      Snæfellsjökull    Snaefellsjokull      370010    64.800    -23.783   \n",
       "9         Fremrinámar        Fremrinamar      373070    65.433    -16.667   \n",
       "10        Öræfajökull       Oraefajokull      374010    64.000    -16.650   \n",
       "11         Hofsjökull         Hofsjokull      371090    64.800    -18.900   \n",
       "12    Hrómundartindur    Hromundartindur      371051    64.067    -21.200   \n",
       "13          Esjufjöll          Esjufjoll      374020    64.283    -16.583   \n",
       "14             Krafla             Krafla      373080    65.717    -16.783   \n",
       "15         Kverkfjöll         Kverkfjoll      373050    64.650    -16.667   \n",
       "16         Ljósufjöll         Ljosufjoll      370030    64.917    -22.633   \n",
       "17         Langjökull         Langjokull      371080    64.850    -19.783   \n",
       "18       Prestahnúkur       Prestahnukur      371070    64.600    -20.633   \n",
       "19            Snæfell           Snaefell      374801    64.800    -15.567   \n",
       "20   Tindfjallajökull   Tindfjallajokull      372040    63.783    -19.567   \n",
       "21        Torfajökull        Torfajokull      372050    63.933    -19.100   \n",
       "22  Tungnafellsjökull  Tungnafellsjokull      373040    64.750    -17.917   \n",
       "23     Vestmannaeyjar     Vestmannaeyjar      372010    63.417    -20.350   \n",
       "24       Þeistareykir      Theistareykir      373090    65.883    -16.967   \n",
       "25        Þórðarhyrna          Grimsvotn      373012    64.267    -17.617   \n",
       "26  Brennisteinsfjöll  Brennisteinsfjoll      371040    63.950    -21.750   \n",
       "27        Bárðarbunga        Bardarbunga      373030    64.633    -17.517   \n",
       "28           Grímsnes           Grimsnes      371060    64.050    -20.883   \n",
       "29   Eyjafjallajökull   Eyjafjallajokull      372020    63.628    -19.625   \n",
       "30      Heiðarsporðar     Heidarspordar       373082    65.583    -16.817   \n",
       "31              Hekla              Hekla      372070    63.992    -19.667   \n",
       "32            Hengill            Hengill      371050    64.083    -21.300   \n",
       "\n",
       "   status             publication_date  end_date source_of_information  \n",
       "0   green  2023-08-16T11:44:35.261605Z       NaN                   IMO  \n",
       "1   green  2023-07-11T16:40:08.713479Z       NaN                   IMO  \n",
       "2   green  2023-05-05T11:04:51.372791Z       NaN                   IMO  \n",
       "3   green  2022-11-09T07:57:50.154155Z       NaN                   IMO  \n",
       "4   green  2022-11-09T07:54:42.992339Z       NaN                   IMO  \n",
       "5   green  2022-09-15T15:29:52.108190Z       NaN                   IMO  \n",
       "6   green  2022-06-02T11:49:38.513240Z       NaN                   IMO  \n",
       "7   green  2020-11-12T14:36:08.129673Z       NaN                   IMO  \n",
       "8   green  2020-11-12T14:33:34.946495Z       NaN                   IMO  \n",
       "9   green  2020-10-28T14:38:01.123294Z       NaN                   IMO  \n",
       "10  green  2018-05-04T11:24:22.418449Z       NaN                   IMO  \n",
       "11  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "12  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "13  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "14  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "15  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "16  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "17  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "18  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "19  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "20  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "21  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "22  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "23  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "24  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "25  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "26  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "27  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "28  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "29  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "30  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "31  green         2015-03-01T00:00:00Z       NaN                   IMO  \n",
       "32  green         2015-03-01T00:00:00Z       NaN                   IMO  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df = pd.read_json('data/VolcanoColors.json')\n",
    "display(df)"
   ]
  }
 ],
 "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.9.13"
  },
  "vscode": {
   "interpreter": {
    "hash": "393893efe096ee2fc5764a4956f32082cb1dba0a8e0e3b28c3e69b0223e5d8b7"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}