Avalanche Danger Report

data_sources.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. Select a weather station\n",
    "    1. Go to [NWAC Weather Data Map](https://nwac.us/weatherdata/map/#/)\n",
    "    2. For this example, [Crystal Mountain Summit](https://nwac.us/weatherdata/map/#/29) was selected\n",
    "2. You can see seasonal weather data\n",
    "    - Note that this is not formatted into CSV\n",
    "3. Select \"Custom Date\" > \"Season\" to get seasonal weather data\n",
    "    - Note that this data does not include all the information we will need (precipitation amounts)\n",
    "4. Format into CSV by importing as tab-separated into a spreadsheet software and downloading as CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Date PDT</th>\n",
       "      <th>Temp F</th>\n",
       "      <th>RH %</th>\n",
       "      <th>Min mph</th>\n",
       "      <th>Spd mph</th>\n",
       "      <th>Gust mph</th>\n",
       "      <th>Dir deg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apr 24 6:00</td>\n",
       "      <td>23</td>\n",
       "      <td>98</td>\n",
       "      <td>7</td>\n",
       "      <td>18</td>\n",
       "      <td>31</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apr 24 5:00</td>\n",
       "      <td>23</td>\n",
       "      <td>98</td>\n",
       "      <td>6</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apr 24 4:00</td>\n",
       "      <td>23</td>\n",
       "      <td>98</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>29</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apr 24 3:00</td>\n",
       "      <td>23</td>\n",
       "      <td>98</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apr 24 2:00</td>\n",
       "      <td>25</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>NW</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Date PDT  Temp F  RH %  Min mph  Spd mph  Gust mph Dir deg\n",
       "0  Apr 24 6:00      23    98        7       18        31       W\n",
       "1  Apr 24 5:00      23    98        6       19        30       W\n",
       "2  Apr 24 4:00      23    98        7       16        29       W\n",
       "3  Apr 24 3:00      23    98        4       12        21       W\n",
       "4  Apr 24 2:00      25    97        0        2         9      NW"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "\n",
    "df = pd.read_csv('seasonal_weather_crystal_summit.csv')\n",
    "df.head()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "4. Select a SNOTEL station on the map (Green circle icon)\n",
    "    - Selected [Morse Lake](https://nwac.us/weatherdata/map/#/642), near the above weather station\n",
    "5. These sites give us precipitation information\n",
    "    - Also not CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Date PDT</th>\n",
       "      <th>Temp F</th>\n",
       "      <th>SWE in</th>\n",
       "      <th>∆SWE in</th>\n",
       "      <th>SnoHt in</th>\n",
       "      <th>∆SnoHt in</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apr 24 6:00</td>\n",
       "      <td>30</td>\n",
       "      <td>57.0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>126</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apr 24 5:00</td>\n",
       "      <td>30</td>\n",
       "      <td>57.1</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>126</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apr 24 4:00</td>\n",
       "      <td>31</td>\n",
       "      <td>57.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>123</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apr 24 3:00</td>\n",
       "      <td>31</td>\n",
       "      <td>57.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>122</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apr 24 2:00</td>\n",
       "      <td>31</td>\n",
       "      <td>57.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>124</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Date PDT  Temp F  SWE in  ∆SWE in  SnoHt in  ∆SnoHt in\n",
       "0  Apr 24 6:00      30    57.0     -0.5       126        1.0\n",
       "1  Apr 24 5:00      30    57.1     -0.2       126        1.0\n",
       "2  Apr 24 4:00      31    57.2      0.0       123       -2.0\n",
       "3  Apr 24 3:00      31    57.2      0.2       122       -3.0\n",
       "4  Apr 24 2:00      31    57.2      0.3       124       -2.0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "snow = pd.read_csv('weekly_snotel_morse_lake.csv')\n",
    "snow.head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.10"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}

seasonal_weather_crystal_summit.csv

spitballing.py

import os
import time

from selenium import webdriver
from selenium.webdriver.firefox.options import Options
from selenium.webdriver.firefox.service import Service
from selenium.webdriver.common.by import By

def init_driver():
    # snap install firefox
    install_dir = "/snap/firefox/current/usr/lib/firefox"
    driver_loc = os.path.join(install_dir, "geckodriver")
    binary_loc = os.path.join(install_dir, "firefox")

    service = Service(driver_loc)
    opts = Options()
    opts.add_argument('-headless')
    opts.binary_location = binary_loc
    driver = webdriver.Firefox(service=service, options=opts)
    return driver

def print_danger_ratings(url):
    driver = init_driver()
    driver.get(url)
    time.sleep(2)
    res = driver.find_elements(By.CLASS_NAME, 'nac-dangerLabel')
    print('actual:')
    for danger in res:
        if danger.text:
            print('\t'+danger.text)

def test_danger_ratings(driver, url, expected):
    print('expected:')
    print(expected)
    print_danger_ratings(driver, url)

driver = init_driver()

def run_some_tests():
    test_danger_ratings(driver, 'https://nwac.us/avalanche-forecast/#/forecast/6/124162', \
                        '\tmoderate\n\tmoderate\n\tlow')
    print('---')
    test_danger_ratings(driver, 'https://nwac.us/avalanche-forecast/#/forecast/4/124286',\
                        '\tconsiderable\n\tconsiderable\n\tmoderate')
    print('---')
    test_danger_ratings(driver, 'https://nwac.us/avalanche-forecast/#/forecast/4/123859',\
                        '\thigh\n\thigh\n\tconsiderable')
    print('---')
    test_danger_ratings(driver, 'https://nwac.us/avalanche-forecast/#/forecast/2/123737',\
                        '\tmoderate\n\tmoderate\n\tmoderate')
    print('---')

# run_some_tests()

archive = 'https://nwac.us/avalanche-forecast/#/archive/'
driver.get(archive)
time.sleep(2)

table = driver.find_elements(By.XPATH, "//a[contains(@href, '#/forecast/')]")
for t in table[15:20]:
    print('link:', t.get_attribute('href'))
    print_danger_ratings(t.get_attribute('href'))

driver.close()

weekly_snotel_morse_creek.csv