heat map of all trails in national parks.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['C:\\\\Users\\\\thead\\\\Documents\\\\bootcamp\\\\bootcamp_project_1', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\python37.zip', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\DLLs', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\lib', 'C:\\\\Users\\\\thead\\\\anaconda3', '', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\lib\\\\site-packages', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\lib\\\\site-packages\\\\win32', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\lib\\\\site-packages\\\\win32\\\\lib', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\lib\\\\site-packages\\\\Pythonwin', 'C:\\\\Users\\\\thead\\\\anaconda3\\\\lib\\\\site-packages\\\\IPython\\\\extensions', 'C:\\\\Users\\\\thead\\\\.ipython', 'C:\\\\Users\\\\thead\\\\Documents\\\\bootcamp\\\\python\\\\API']\n"
     ]
    }
   ],
   "source": [
    "# Dependencies and Setup\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests\n",
    "import gmaps\n",
    "import os\n",
    "import sys\n",
    "\n",
    "module_path = os.path.abspath('C:\\\\Users\\\\thead\\\\Documents\\\\bootcamp\\\\python\\\\API')\n",
    "#Frank wrote this for me.  Allows me to use one file for all API_keys\n",
    "if module_path not in sys.path:\n",
    "    sys.path.append(module_path)\n",
    "\n",
    "print(sys.path)\n",
    "#  New York Times API key\n",
    "#nyt_key = \n",
    "#  OMDB API key\n",
    "#omdb_key = \n",
    "# Openweathermap.org API key\n",
    "#openweather_key = \n",
    "# google location information API key\n",
    "#google_key = \n",
    "#census api key\n",
    "#census_key = \n",
    "#national park\n",
    "#national_park_key = \n",
    "#national park\n",
    "#national_park_key_2 = \n",
    "#national park\n",
    "#national_park_key_3 = \n",
    "#hikingproject\n",
    "#hikingproject_api_key = \n",
    "#formatting is api_key.hikingproject_api_key for example\n",
    "import all_api as api_key\n",
    "\n",
    "\n",
    "# Output File (CSV)\n",
    "#output_data_file_2 = \"../output_data/cities_clean.csv\"\n",
    "\n",
    "#from api_keys import google_key\n",
    "\n",
    "gmaps.configure(api_key = api_key.google_key)\n",
    "\n",
    "csv_all_park_trails = 'complete_list_of_all_trails_for_all_parks.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "trails_df = pd.read_csv(csv_all_park_trails , index_col = 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>NP Name</th>\n",
       "      <th>trail_id</th>\n",
       "      <th>name</th>\n",
       "      <th>trail_type</th>\n",
       "      <th>summary</th>\n",
       "      <th>difficulty</th>\n",
       "      <th>stars</th>\n",
       "      <th>starVotes</th>\n",
       "      <th>location</th>\n",
       "      <th>url</th>\n",
       "      <th>...</th>\n",
       "      <th>length, miles</th>\n",
       "      <th>ascent, ft</th>\n",
       "      <th>descent, ft</th>\n",
       "      <th>high, ft</th>\n",
       "      <th>low, ft</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>conditionStatus</th>\n",
       "      <th>conditionDetails</th>\n",
       "      <th>conditionDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Acadia</td>\n",
       "      <td>7019232</td>\n",
       "      <td>Precipice Loop</td>\n",
       "      <td>Recommended Route</td>\n",
       "      <td>An adventurous loop with brilliant views using...</td>\n",
       "      <td>black</td>\n",
       "      <td>4.7</td>\n",
       "      <td>32</td>\n",
       "      <td>Bar Harbor, Maine</td>\n",
       "      <td>https://www.hikingproject.com/trail/7019232/pr...</td>\n",
       "      <td>...</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1072</td>\n",
       "      <td>-1071</td>\n",
       "      <td>1042</td>\n",
       "      <td>127</td>\n",
       "      <td>44.3495</td>\n",
       "      <td>-68.1880</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acadia</td>\n",
       "      <td>7019354</td>\n",
       "      <td>Dorr Mountain Ladder Trail Loop</td>\n",
       "      <td>Recommended Route</td>\n",
       "      <td>An exciting loop up the  Dorr Mountain Ladder ...</td>\n",
       "      <td>black</td>\n",
       "      <td>4.8</td>\n",
       "      <td>16</td>\n",
       "      <td>Bar Harbor, Maine</td>\n",
       "      <td>https://www.hikingproject.com/trail/7019354/do...</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1142</td>\n",
       "      <td>-1142</td>\n",
       "      <td>1248</td>\n",
       "      <td>114</td>\n",
       "      <td>44.3519</td>\n",
       "      <td>-68.2046</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Acadia</td>\n",
       "      <td>7019235</td>\n",
       "      <td>Gorham Mountain Loop</td>\n",
       "      <td>Recommended Route</td>\n",
       "      <td>A short but challenging tour that passes a num...</td>\n",
       "      <td>blueBlack</td>\n",
       "      <td>4.7</td>\n",
       "      <td>44</td>\n",
       "      <td>Bar Harbor, Maine</td>\n",
       "      <td>https://www.hikingproject.com/trail/7019235/go...</td>\n",
       "      <td>...</td>\n",
       "      <td>3.6</td>\n",
       "      <td>774</td>\n",
       "      <td>-781</td>\n",
       "      <td>522</td>\n",
       "      <td>37</td>\n",
       "      <td>44.3305</td>\n",
       "      <td>-68.1846</td>\n",
       "      <td>All Clear</td>\n",
       "      <td>Dry</td>\n",
       "      <td>2020-06-09 13:04:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Acadia</td>\n",
       "      <td>7007506</td>\n",
       "      <td>Great Head Trail</td>\n",
       "      <td>Recommended Route</td>\n",
       "      <td>A great trail to escape the crowds at Sand Bea...</td>\n",
       "      <td>blue</td>\n",
       "      <td>4.6</td>\n",
       "      <td>50</td>\n",
       "      <td>Bar Harbor, Maine</td>\n",
       "      <td>https://www.hikingproject.com/trail/7007506/gr...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>232</td>\n",
       "      <td>-235</td>\n",
       "      <td>145</td>\n",
       "      <td>35</td>\n",
       "      <td>44.3297</td>\n",
       "      <td>-68.1805</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Acadia</td>\n",
       "      <td>7039413</td>\n",
       "      <td>Cadillac Mountain Summit Loop</td>\n",
       "      <td>Recommended Route</td>\n",
       "      <td>Enjoy a scenic loop hike to the summit of Cadi...</td>\n",
       "      <td>black</td>\n",
       "      <td>4.4</td>\n",
       "      <td>14</td>\n",
       "      <td>Bar Harbor, Maine</td>\n",
       "      <td>https://www.hikingproject.com/trail/7039413/ca...</td>\n",
       "      <td>...</td>\n",
       "      <td>4.9</td>\n",
       "      <td>1324</td>\n",
       "      <td>-1327</td>\n",
       "      <td>1515</td>\n",
       "      <td>203</td>\n",
       "      <td>44.3727</td>\n",
       "      <td>-68.2217</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5806</th>\n",
       "      <td>Zion</td>\n",
       "      <td>7039707</td>\n",
       "      <td>Goosebump Connector</td>\n",
       "      <td>Trail</td>\n",
       "      <td>A simple connector between Goosebump and Jems.</td>\n",
       "      <td>blue</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Hurricane, Utah</td>\n",
       "      <td>https://www.hikingproject.com/trail/7039707/go...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0</td>\n",
       "      <td>-196</td>\n",
       "      <td>3954</td>\n",
       "      <td>3758</td>\n",
       "      <td>37.1624</td>\n",
       "      <td>-113.2267</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5807</th>\n",
       "      <td>Zion</td>\n",
       "      <td>7001602</td>\n",
       "      <td>La Verkin Creek Trail</td>\n",
       "      <td>Trail</td>\n",
       "      <td>Head up La Verkin Creek to experience amazing ...</td>\n",
       "      <td>black</td>\n",
       "      <td>4.6</td>\n",
       "      <td>5</td>\n",
       "      <td>Toquerville, Utah</td>\n",
       "      <td>https://www.hikingproject.com/trail/7001602/la...</td>\n",
       "      <td>...</td>\n",
       "      <td>10.9</td>\n",
       "      <td>1742</td>\n",
       "      <td>-1718</td>\n",
       "      <td>6411</td>\n",
       "      <td>5052</td>\n",
       "      <td>37.4522</td>\n",
       "      <td>-113.1914</td>\n",
       "      <td>All Clear</td>\n",
       "      <td>Mostly Dry</td>\n",
       "      <td>2020-04-01 19:47:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5808</th>\n",
       "      <td>Zion</td>\n",
       "      <td>7035241</td>\n",
       "      <td>Hurricane Rim Trail</td>\n",
       "      <td>Trail</td>\n",
       "      <td>Fun rocky singletrack that meanders above the ...</td>\n",
       "      <td>black</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Hurricane, Utah</td>\n",
       "      <td>https://www.hikingproject.com/trail/7035241/hu...</td>\n",
       "      <td>...</td>\n",
       "      <td>6.4</td>\n",
       "      <td>553</td>\n",
       "      <td>-421</td>\n",
       "      <td>3789</td>\n",
       "      <td>3514</td>\n",
       "      <td>37.1833</td>\n",
       "      <td>-113.2780</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5809</th>\n",
       "      <td>Zion</td>\n",
       "      <td>7037607</td>\n",
       "      <td>Goosebump</td>\n",
       "      <td>Trail</td>\n",
       "      <td>A \"roller coaster\" of a trail.</td>\n",
       "      <td>blue</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Hurricane, Utah</td>\n",
       "      <td>https://www.hikingproject.com/trail/7037607/go...</td>\n",
       "      <td>...</td>\n",
       "      <td>3.6</td>\n",
       "      <td>219</td>\n",
       "      <td>-272</td>\n",
       "      <td>4025</td>\n",
       "      <td>3924</td>\n",
       "      <td>37.1519</td>\n",
       "      <td>-113.2519</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5810</th>\n",
       "      <td>Zion</td>\n",
       "      <td>7037609</td>\n",
       "      <td>More Cowbell</td>\n",
       "      <td>Trail</td>\n",
       "      <td>A great beginner loop that's fun for everyone,...</td>\n",
       "      <td>blue</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Hurricane, Utah</td>\n",
       "      <td>https://www.hikingproject.com/trail/7037609/mo...</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>176</td>\n",
       "      <td>-221</td>\n",
       "      <td>4296</td>\n",
       "      <td>4207</td>\n",
       "      <td>37.1414</td>\n",
       "      <td>-113.2439</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5811 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NP Name  trail_id                             name         trail_type  \\\n",
       "0     Acadia   7019232                   Precipice Loop  Recommended Route   \n",
       "1     Acadia   7019354  Dorr Mountain Ladder Trail Loop  Recommended Route   \n",
       "2     Acadia   7019235             Gorham Mountain Loop  Recommended Route   \n",
       "3     Acadia   7007506                 Great Head Trail  Recommended Route   \n",
       "4     Acadia   7039413    Cadillac Mountain Summit Loop  Recommended Route   \n",
       "...      ...       ...                              ...                ...   \n",
       "5806    Zion   7039707              Goosebump Connector              Trail   \n",
       "5807    Zion   7001602            La Verkin Creek Trail              Trail   \n",
       "5808    Zion   7035241              Hurricane Rim Trail              Trail   \n",
       "5809    Zion   7037607                        Goosebump              Trail   \n",
       "5810    Zion   7037609                     More Cowbell              Trail   \n",
       "\n",
       "                                                summary difficulty  stars  \\\n",
       "0     An adventurous loop with brilliant views using...      black    4.7   \n",
       "1     An exciting loop up the  Dorr Mountain Ladder ...      black    4.8   \n",
       "2     A short but challenging tour that passes a num...  blueBlack    4.7   \n",
       "3     A great trail to escape the crowds at Sand Bea...       blue    4.6   \n",
       "4     Enjoy a scenic loop hike to the summit of Cadi...      black    4.4   \n",
       "...                                                 ...        ...    ...   \n",
       "5806     A simple connector between Goosebump and Jems.       blue    3.0   \n",
       "5807  Head up La Verkin Creek to experience amazing ...      black    4.6   \n",
       "5808  Fun rocky singletrack that meanders above the ...      black    4.0   \n",
       "5809                     A \"roller coaster\" of a trail.       blue    4.0   \n",
       "5810  A great beginner loop that's fun for everyone,...       blue    5.0   \n",
       "\n",
       "      starVotes           location  \\\n",
       "0            32  Bar Harbor, Maine   \n",
       "1            16  Bar Harbor, Maine   \n",
       "2            44  Bar Harbor, Maine   \n",
       "3            50  Bar Harbor, Maine   \n",
       "4            14  Bar Harbor, Maine   \n",
       "...         ...                ...   \n",
       "5806          1    Hurricane, Utah   \n",
       "5807          5  Toquerville, Utah   \n",
       "5808          1    Hurricane, Utah   \n",
       "5809          1    Hurricane, Utah   \n",
       "5810          2    Hurricane, Utah   \n",
       "\n",
       "                                                    url  ... length, miles  \\\n",
       "0     https://www.hikingproject.com/trail/7019232/pr...  ...           2.3   \n",
       "1     https://www.hikingproject.com/trail/7019354/do...  ...           3.4   \n",
       "2     https://www.hikingproject.com/trail/7019235/go...  ...           3.6   \n",
       "3     https://www.hikingproject.com/trail/7007506/gr...  ...           1.5   \n",
       "4     https://www.hikingproject.com/trail/7039413/ca...  ...           4.9   \n",
       "...                                                 ...  ...           ...   \n",
       "5806  https://www.hikingproject.com/trail/7039707/go...  ...           1.7   \n",
       "5807  https://www.hikingproject.com/trail/7001602/la...  ...          10.9   \n",
       "5808  https://www.hikingproject.com/trail/7035241/hu...  ...           6.4   \n",
       "5809  https://www.hikingproject.com/trail/7037607/go...  ...           3.6   \n",
       "5810  https://www.hikingproject.com/trail/7037609/mo...  ...           2.7   \n",
       "\n",
       "     ascent, ft descent, ft high, ft  low, ft  latitude  longitude  \\\n",
       "0          1072       -1071     1042      127   44.3495   -68.1880   \n",
       "1          1142       -1142     1248      114   44.3519   -68.2046   \n",
       "2           774        -781      522       37   44.3305   -68.1846   \n",
       "3           232        -235      145       35   44.3297   -68.1805   \n",
       "4          1324       -1327     1515      203   44.3727   -68.2217   \n",
       "...         ...         ...      ...      ...       ...        ...   \n",
       "5806          0        -196     3954     3758   37.1624  -113.2267   \n",
       "5807       1742       -1718     6411     5052   37.4522  -113.1914   \n",
       "5808        553        -421     3789     3514   37.1833  -113.2780   \n",
       "5809        219        -272     4025     3924   37.1519  -113.2519   \n",
       "5810        176        -221     4296     4207   37.1414  -113.2439   \n",
       "\n",
       "      conditionStatus  conditionDetails        conditionDate  \n",
       "0             Unknown               NaN  1970-01-01 00:00:00  \n",
       "1             Unknown               NaN  1970-01-01 00:00:00  \n",
       "2           All Clear               Dry  2020-06-09 13:04:33  \n",
       "3             Unknown               NaN  1970-01-01 00:00:00  \n",
       "4             Unknown               NaN  1970-01-01 00:00:00  \n",
       "...               ...               ...                  ...  \n",
       "5806          Unknown               NaN  1970-01-01 00:00:00  \n",
       "5807        All Clear        Mostly Dry  2020-04-01 19:47:34  \n",
       "5808          Unknown               NaN  1970-01-01 00:00:00  \n",
       "5809          Unknown               NaN  1970-01-01 00:00:00  \n",
       "5810          Unknown               NaN  1970-01-01 00:00:00  \n",
       "\n",
       "[5811 rows x 24 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trails_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "834142a9b35643418cdf40819e10ea55",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Figure(layout=FigureLayout(height='420px'))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig = gmaps.figure()\n",
    "heatmap_layer = gmaps.heatmap_layer(trails_df[['latitude','longitude']])\n",
    "fig.add_layer(heatmap_layer)\n",
    "#heatmap_layer = gmaps.WeightedHeatmap(humidity)\n",
    "#fig.add_layer(heatmap_layer)\n",
    "heatmap_layer.max_intensity = 200\n",
    "heatmap_layer.point_radius = 10\n",
    "fig"
   ]
  }
 ],
 "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.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}