Park_Census_Maps.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import gmaps\n",
    "\n",
    "from config import gkey"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/hannahlee/opt/anaconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3063: DtypeWarning: Columns (1,2,3,6,7,8,9,10,11,12,13,14,15) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "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>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>Date established as park</th>\n",
       "      <th>Area, acres</th>\n",
       "      <th>area, acres</th>\n",
       "      <th>area, km^2</th>\n",
       "      <th>Recreation visitors</th>\n",
       "      <th>...</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Total_POP</th>\n",
       "      <th>TMale</th>\n",
       "      <th>TMale21</th>\n",
       "      <th>TMale35</th>\n",
       "      <th>TMale65</th>\n",
       "      <th>TFemale21</th>\n",
       "      <th>TFemale35</th>\n",
       "      <th>TFemale65</th>\n",
       "      <th>TFemal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Arches</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.68°N 109.57°W</td>\n",
       "      <td>38.6800</td>\n",
       "      <td>-109.5700</td>\n",
       "      <td>12-Nov-71</td>\n",
       "      <td>76,678.98 acres (310.3 km2)</td>\n",
       "      <td>76,678.98</td>\n",
       "      <td>310.3</td>\n",
       "      <td>1,663,557</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.493920</td>\n",
       "      <td>10043.0</td>\n",
       "      <td>4929.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>5114.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Canyonlands</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.2°N 109.93°W</td>\n",
       "      <td>38.2000</td>\n",
       "      <td>-109.9300</td>\n",
       "      <td>12-Sep-64</td>\n",
       "      <td>337,597.83 acres (1,366.2 km2)</td>\n",
       "      <td>337,597.83</td>\n",
       "      <td>1,366.20</td>\n",
       "      <td>739,449</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.493920</td>\n",
       "      <td>10043.0</td>\n",
       "      <td>4929.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>5114.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Badlands</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.75°N 102.50°W</td>\n",
       "      <td>43.7500</td>\n",
       "      <td>-102.5000</td>\n",
       "      <td>10-Nov-78</td>\n",
       "      <td>242,755.94 acres (982.4 km2)</td>\n",
       "      <td>242,755.94</td>\n",
       "      <td>982.4</td>\n",
       "      <td>1,008,942</td>\n",
       "      <td>...</td>\n",
       "      <td>-101.943550</td>\n",
       "      <td>224.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Big Bend</td>\n",
       "      <td>Texas</td>\n",
       "      <td>29.25°N 103.25°W</td>\n",
       "      <td>29.2500</td>\n",
       "      <td>-103.2500</td>\n",
       "      <td>12-Jun-44</td>\n",
       "      <td>801,163.21 acres (3,242.2 km2)</td>\n",
       "      <td>801,163.21</td>\n",
       "      <td>3,242.20</td>\n",
       "      <td>440,091</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.210850</td>\n",
       "      <td>213.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>102.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Biscayne</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.65°N 80.08°W</td>\n",
       "      <td>25.6500</td>\n",
       "      <td>-80.0800</td>\n",
       "      <td>28-Jun-80</td>\n",
       "      <td>172,971.11 acres (700.0 km2)</td>\n",
       "      <td>172,971.11</td>\n",
       "      <td>700</td>\n",
       "      <td>469,253</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.426920</td>\n",
       "      <td>58224.0</td>\n",
       "      <td>28526.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>1966.0</td>\n",
       "      <td>506.0</td>\n",
       "      <td>457.0</td>\n",
       "      <td>2416.0</td>\n",
       "      <td>599.0</td>\n",
       "      <td>29698.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Black Canyon of The Gunnison</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>38.57°N 107.72°W</td>\n",
       "      <td>38.5700</td>\n",
       "      <td>-107.7200</td>\n",
       "      <td>21-Oct-99</td>\n",
       "      <td>30,779.83 acres (124.6 km2)</td>\n",
       "      <td>30,779.83</td>\n",
       "      <td>124.6</td>\n",
       "      <td>308,962</td>\n",
       "      <td>...</td>\n",
       "      <td>-107.862500</td>\n",
       "      <td>22633.0</td>\n",
       "      <td>10950.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>590.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>598.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>11683.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bryce Canyon</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.57°N 112.18°W</td>\n",
       "      <td>37.5700</td>\n",
       "      <td>-112.1800</td>\n",
       "      <td>25-Feb-28</td>\n",
       "      <td>35,835.08 acres (145.0 km2)</td>\n",
       "      <td>35,835.08</td>\n",
       "      <td>145</td>\n",
       "      <td>2,679,478</td>\n",
       "      <td>...</td>\n",
       "      <td>-112.208570</td>\n",
       "      <td>270.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>142.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Capitol Reef</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.20°N 111.17°W</td>\n",
       "      <td>38.2000</td>\n",
       "      <td>-111.1700</td>\n",
       "      <td>18-Dec-71</td>\n",
       "      <td>241,904.50 acres (979.0 km2)</td>\n",
       "      <td>241,904.50</td>\n",
       "      <td>979</td>\n",
       "      <td>1,227,627</td>\n",
       "      <td>...</td>\n",
       "      <td>-111.002200</td>\n",
       "      <td>301.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Carlsbad Caverns</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>32.17°N 104.44°W</td>\n",
       "      <td>32.1700</td>\n",
       "      <td>-104.4400</td>\n",
       "      <td>14-May-30</td>\n",
       "      <td>46,766.45 acres (189.3 km2)</td>\n",
       "      <td>46,766.45</td>\n",
       "      <td>189.3</td>\n",
       "      <td>465,912</td>\n",
       "      <td>...</td>\n",
       "      <td>-104.291340</td>\n",
       "      <td>36708.0</td>\n",
       "      <td>18602.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>1236.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1060.0</td>\n",
       "      <td>366.0</td>\n",
       "      <td>18106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Channel Islands</td>\n",
       "      <td>California</td>\n",
       "      <td>34.01°N 119.42°W</td>\n",
       "      <td>34.0100</td>\n",
       "      <td>-119.4200</td>\n",
       "      <td>5-Mar-80</td>\n",
       "      <td>249,561.00 acres (1,009.9 km2)</td>\n",
       "      <td>249,561.00</td>\n",
       "      <td>1,009.90</td>\n",
       "      <td>366,250</td>\n",
       "      <td>...</td>\n",
       "      <td>-119.301640</td>\n",
       "      <td>33185.0</td>\n",
       "      <td>16763.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>1077.0</td>\n",
       "      <td>369.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>897.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>16422.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Congaree</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td>33.78°N 80.78°W</td>\n",
       "      <td>33.7800</td>\n",
       "      <td>-80.7800</td>\n",
       "      <td>10-Nov-03</td>\n",
       "      <td>26,476.47 acres (107.1 km2)</td>\n",
       "      <td>26,476.47</td>\n",
       "      <td>107.1</td>\n",
       "      <td>145,929</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.845350</td>\n",
       "      <td>14605.0</td>\n",
       "      <td>7235.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>457.0</td>\n",
       "      <td>206.0</td>\n",
       "      <td>7370.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Crater Lake</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>42.94°N 122.1°W</td>\n",
       "      <td>42.9400</td>\n",
       "      <td>-122.1000</td>\n",
       "      <td>22-May-02</td>\n",
       "      <td>183,224.05 acres (741.5 km2)</td>\n",
       "      <td>183,224.05</td>\n",
       "      <td>741.5</td>\n",
       "      <td>720,659</td>\n",
       "      <td>...</td>\n",
       "      <td>-122.274430</td>\n",
       "      <td>152.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Cuyahoga Valley</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>41.24°N 81.55°W</td>\n",
       "      <td>41.2400</td>\n",
       "      <td>-81.5500</td>\n",
       "      <td>11-Oct-00</td>\n",
       "      <td>32,571.88 acres (131.8 km2)</td>\n",
       "      <td>32,571.88</td>\n",
       "      <td>131.8</td>\n",
       "      <td>2,096,053</td>\n",
       "      <td>...</td>\n",
       "      <td>-81.618350</td>\n",
       "      <td>13830.0</td>\n",
       "      <td>6861.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>6969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Death Valley</td>\n",
       "      <td>California, Nevada</td>\n",
       "      <td>36.24°N 116.82°W</td>\n",
       "      <td>36.2400</td>\n",
       "      <td>-116.8200</td>\n",
       "      <td>31-Oct-94</td>\n",
       "      <td>3,408,406.73 acres (13,793.3 km2)</td>\n",
       "      <td>3,408,406.73</td>\n",
       "      <td>13,793.30</td>\n",
       "      <td>1,678,660</td>\n",
       "      <td>...</td>\n",
       "      <td>-117.202960</td>\n",
       "      <td>354.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Denali</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>63.33°N 150.50°W</td>\n",
       "      <td>63.3300</td>\n",
       "      <td>-150.5000</td>\n",
       "      <td>26-Feb-17</td>\n",
       "      <td>4,740,911.16 acres (19,185.8 km2)</td>\n",
       "      <td>4,740,911.16</td>\n",
       "      <td>19,185.80</td>\n",
       "      <td>594,660</td>\n",
       "      <td>...</td>\n",
       "      <td>-148.833960</td>\n",
       "      <td>856.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>442.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Dry Tortugas</td>\n",
       "      <td>Florida</td>\n",
       "      <td>24.63°N 82.87°W</td>\n",
       "      <td>24.6300</td>\n",
       "      <td>-82.8700</td>\n",
       "      <td>26-Oct-92</td>\n",
       "      <td>64,701.22 acres (261.8 km2)</td>\n",
       "      <td>64,701.22</td>\n",
       "      <td>261.8</td>\n",
       "      <td>56,810</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.513820</td>\n",
       "      <td>23281.0</td>\n",
       "      <td>12004.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>904.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>679.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>11277.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Everglades</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.32°N 80.93°W</td>\n",
       "      <td>25.3200</td>\n",
       "      <td>-80.9300</td>\n",
       "      <td>30-May-34</td>\n",
       "      <td>1,508,938.57 acres (6,106.5 km2)</td>\n",
       "      <td>1,508,938.57</td>\n",
       "      <td>6,106.50</td>\n",
       "      <td>597,124</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.513820</td>\n",
       "      <td>23281.0</td>\n",
       "      <td>12004.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>904.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>679.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>11277.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Gates of The Arctic</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>67.78°N 153.30°W</td>\n",
       "      <td>67.7800</td>\n",
       "      <td>-153.3000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>7,523,897.45 acres (30,448.1 km2)</td>\n",
       "      <td>7,523,897.45</td>\n",
       "      <td>30,448.10</td>\n",
       "      <td>9,591</td>\n",
       "      <td>...</td>\n",
       "      <td>-147.720450</td>\n",
       "      <td>17510.0</td>\n",
       "      <td>8941.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>603.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>8569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Gateway Arch</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>38.63°N 90.19°W</td>\n",
       "      <td>38.6300</td>\n",
       "      <td>-90.1900</td>\n",
       "      <td>February 22, 2018[45]</td>\n",
       "      <td>192.83 acres (0.8 km2)</td>\n",
       "      <td>192.83</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2,016,180</td>\n",
       "      <td>...</td>\n",
       "      <td>-90.187020</td>\n",
       "      <td>2201.0</td>\n",
       "      <td>1551.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>650.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Glacier</td>\n",
       "      <td>Montana</td>\n",
       "      <td>48.80°N 114.00°W</td>\n",
       "      <td>48.8000</td>\n",
       "      <td>-114.0000</td>\n",
       "      <td>11-May-10</td>\n",
       "      <td>1,013,125.99 acres (4,100.0 km2)</td>\n",
       "      <td>1,013,125.99</td>\n",
       "      <td>4,100.00</td>\n",
       "      <td>2,965,309</td>\n",
       "      <td>...</td>\n",
       "      <td>-113.925990</td>\n",
       "      <td>401.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>193.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Glacier Bay</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>58.50°N 137.00°W</td>\n",
       "      <td>58.5000</td>\n",
       "      <td>-137.0000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>3,223,383.43 acres (13,044.6 km2)</td>\n",
       "      <td>3,223,383.43</td>\n",
       "      <td>13,044.60</td>\n",
       "      <td>597,915</td>\n",
       "      <td>...</td>\n",
       "      <td>-135.730880</td>\n",
       "      <td>416.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Grand Canyon</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>36.06°N 112.14°W</td>\n",
       "      <td>36.0600</td>\n",
       "      <td>-112.1400</td>\n",
       "      <td>26-Feb-19</td>\n",
       "      <td>1,201,647.03 acres (4,862.9 km2)</td>\n",
       "      <td>1,201,647.03</td>\n",
       "      <td>4,862.90</td>\n",
       "      <td>6,380,495</td>\n",
       "      <td>...</td>\n",
       "      <td>-112.064980</td>\n",
       "      <td>2485.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1273.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Grand Teton</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>43.73°N 110.80°W</td>\n",
       "      <td>43.7300</td>\n",
       "      <td>-110.8000</td>\n",
       "      <td>26-Feb-29</td>\n",
       "      <td>310,044.36 acres (1,254.7 km2)</td>\n",
       "      <td>310,044.36</td>\n",
       "      <td>1,254.70</td>\n",
       "      <td>3,491,151</td>\n",
       "      <td>...</td>\n",
       "      <td>-110.832150</td>\n",
       "      <td>226.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>151.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Great Basin</td>\n",
       "      <td>Nevada</td>\n",
       "      <td>38.98°N 114.30°W</td>\n",
       "      <td>38.9800</td>\n",
       "      <td>-114.3000</td>\n",
       "      <td>27-Oct-86</td>\n",
       "      <td>77,180.00 acres (312.3 km2)</td>\n",
       "      <td>77,180.00</td>\n",
       "      <td>312.3</td>\n",
       "      <td>153,094</td>\n",
       "      <td>...</td>\n",
       "      <td>-114.125920</td>\n",
       "      <td>121.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Great Sand Dunes</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>37.73°N 105.51°W</td>\n",
       "      <td>37.7300</td>\n",
       "      <td>-105.5100</td>\n",
       "      <td>13-Sep-04</td>\n",
       "      <td>107,341.87 acres (434.4 km2)</td>\n",
       "      <td>107,341.87</td>\n",
       "      <td>434.4</td>\n",
       "      <td>442,905</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.731010</td>\n",
       "      <td>772.0</td>\n",
       "      <td>377.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>395.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Great Smoky Mountains</td>\n",
       "      <td>North Carolina, Tennessee</td>\n",
       "      <td>35.68°N 83.53°W</td>\n",
       "      <td>35.6800</td>\n",
       "      <td>-83.5300</td>\n",
       "      <td>15-Jun-34</td>\n",
       "      <td>522,426.88 acres (2,114.2 km2)</td>\n",
       "      <td>522,426.88</td>\n",
       "      <td>2,114.20</td>\n",
       "      <td>11,421,200</td>\n",
       "      <td>...</td>\n",
       "      <td>-83.471560</td>\n",
       "      <td>5555.0</td>\n",
       "      <td>2802.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>2753.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Guadalupe Mountains</td>\n",
       "      <td>Texas</td>\n",
       "      <td>31.92°N 104.87°W</td>\n",
       "      <td>31.9200</td>\n",
       "      <td>-104.8700</td>\n",
       "      <td>15-Oct-66</td>\n",
       "      <td>86,367.10 acres (349.5 km2)</td>\n",
       "      <td>86,367.10</td>\n",
       "      <td>349.5</td>\n",
       "      <td>172,347</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.308820</td>\n",
       "      <td>156.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Haleakala</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>20.72°N 156.17°W</td>\n",
       "      <td>20.7200</td>\n",
       "      <td>-156.1700</td>\n",
       "      <td>1-Jul-61</td>\n",
       "      <td>33,264.62 acres (134.6 km2)</td>\n",
       "      <td>33,264.62</td>\n",
       "      <td>134.6</td>\n",
       "      <td>1,044,084</td>\n",
       "      <td>...</td>\n",
       "      <td>-156.331580</td>\n",
       "      <td>18155.0</td>\n",
       "      <td>9313.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>8842.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Hot Springs</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>34.51°N 93.05°W</td>\n",
       "      <td>34.5100</td>\n",
       "      <td>-93.0500</td>\n",
       "      <td>4-Mar-21</td>\n",
       "      <td>5,554.15 acres (22.5 km2)</td>\n",
       "      <td>5,554.15</td>\n",
       "      <td>22.5</td>\n",
       "      <td>1,506,887</td>\n",
       "      <td>...</td>\n",
       "      <td>-93.019410</td>\n",
       "      <td>30003.0</td>\n",
       "      <td>14240.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>671.0</td>\n",
       "      <td>268.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1198.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>15763.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Indiana Dunes</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>41.6533°N 87.0524°W</td>\n",
       "      <td>41.6533</td>\n",
       "      <td>-87.0524</td>\n",
       "      <td>15-Feb-19</td>\n",
       "      <td>15,349.08 acres (62.1 km2)</td>\n",
       "      <td>15,349.08</td>\n",
       "      <td>62.1</td>\n",
       "      <td>1,756,079</td>\n",
       "      <td>...</td>\n",
       "      <td>-87.058830</td>\n",
       "      <td>24906.0</td>\n",
       "      <td>12714.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>851.0</td>\n",
       "      <td>444.0</td>\n",
       "      <td>12192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Isle Royale</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>48.10°N 88.55°W</td>\n",
       "      <td>48.1000</td>\n",
       "      <td>-88.5500</td>\n",
       "      <td>3-Apr-40</td>\n",
       "      <td>571,790.30 acres (2,314.0 km2)</td>\n",
       "      <td>571,790.30</td>\n",
       "      <td>2,314.00</td>\n",
       "      <td>25,798</td>\n",
       "      <td>...</td>\n",
       "      <td>-88.572590</td>\n",
       "      <td>9642.0</td>\n",
       "      <td>6043.0</td>\n",
       "      <td>628.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Joshua Tree</td>\n",
       "      <td>California</td>\n",
       "      <td>33.79°N 115.90°W</td>\n",
       "      <td>33.7900</td>\n",
       "      <td>-115.9000</td>\n",
       "      <td>31-Oct-94</td>\n",
       "      <td>795,155.85 acres (3,217.9 km2)</td>\n",
       "      <td>795,155.85</td>\n",
       "      <td>3,217.90</td>\n",
       "      <td>2,942,382</td>\n",
       "      <td>...</td>\n",
       "      <td>-116.033430</td>\n",
       "      <td>23517.0</td>\n",
       "      <td>11950.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>755.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>359.0</td>\n",
       "      <td>529.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>11567.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Katmai</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>58.50°N 155.00°W</td>\n",
       "      <td>58.5000</td>\n",
       "      <td>-155.0000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>3,674,529.33 acres (14,870.3 km2)</td>\n",
       "      <td>3,674,529.33</td>\n",
       "      <td>14,870.30</td>\n",
       "      <td>37,818</td>\n",
       "      <td>...</td>\n",
       "      <td>-156.640070</td>\n",
       "      <td>455.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>189.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Kenai Fjords</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>59.92°N 149.65°W</td>\n",
       "      <td>59.9200</td>\n",
       "      <td>-149.6500</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>669,650.05 acres (2,710.0 km2)</td>\n",
       "      <td>669,650.05</td>\n",
       "      <td>2,710.00</td>\n",
       "      <td>321,596</td>\n",
       "      <td>...</td>\n",
       "      <td>-149.412710</td>\n",
       "      <td>4575.0</td>\n",
       "      <td>2670.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>1905.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Kings Canyon</td>\n",
       "      <td>California</td>\n",
       "      <td>36.80°N 118.55°W</td>\n",
       "      <td>36.8000</td>\n",
       "      <td>-118.5500</td>\n",
       "      <td>4-Mar-40</td>\n",
       "      <td>461,901.20 acres (1,869.2 km2)</td>\n",
       "      <td>461,901.20</td>\n",
       "      <td>1,869.20</td>\n",
       "      <td>699,023</td>\n",
       "      <td>...</td>\n",
       "      <td>-118.862960</td>\n",
       "      <td>2432.0</td>\n",
       "      <td>1292.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Sequoia</td>\n",
       "      <td>California</td>\n",
       "      <td>36.43°N 118.68°W</td>\n",
       "      <td>36.4300</td>\n",
       "      <td>-118.6800</td>\n",
       "      <td>September 25, 1890</td>\n",
       "      <td>404,062.63 acres (1,635.2 km2)</td>\n",
       "      <td>404,062.63</td>\n",
       "      <td>1,635.20</td>\n",
       "      <td>1,229,594</td>\n",
       "      <td>...</td>\n",
       "      <td>-118.862960</td>\n",
       "      <td>2432.0</td>\n",
       "      <td>1292.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Kobuk Valley</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>67.55°N 159.28°W</td>\n",
       "      <td>67.5500</td>\n",
       "      <td>-159.2800</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>1,750,716.16 acres (7,084.9 km2)</td>\n",
       "      <td>1,750,716.16</td>\n",
       "      <td>7,084.90</td>\n",
       "      <td>14,937</td>\n",
       "      <td>...</td>\n",
       "      <td>-162.585440</td>\n",
       "      <td>3370.0</td>\n",
       "      <td>1811.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Lake Clark</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>60.97°N 153.42°W</td>\n",
       "      <td>60.9700</td>\n",
       "      <td>-153.4200</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>2,619,816.49 acres (10,602.0 km2)</td>\n",
       "      <td>2,619,816.49</td>\n",
       "      <td>10,602.00</td>\n",
       "      <td>14,479</td>\n",
       "      <td>...</td>\n",
       "      <td>-154.557080</td>\n",
       "      <td>151.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Lassen Volcanic</td>\n",
       "      <td>California</td>\n",
       "      <td>40.49°N 121.51°W</td>\n",
       "      <td>40.4900</td>\n",
       "      <td>-121.5100</td>\n",
       "      <td>9-Aug-16</td>\n",
       "      <td>106,589.02 acres (431.4 km2)</td>\n",
       "      <td>106,589.02</td>\n",
       "      <td>431.4</td>\n",
       "      <td>499,435</td>\n",
       "      <td>...</td>\n",
       "      <td>-121.582450</td>\n",
       "      <td>292.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Mammoth Cave</td>\n",
       "      <td>Kentucky</td>\n",
       "      <td>37.18°N 86.10°W</td>\n",
       "      <td>37.1800</td>\n",
       "      <td>-86.1000</td>\n",
       "      <td>1-Jul-41</td>\n",
       "      <td>54,011.91 acres (218.6 km2)</td>\n",
       "      <td>54,011.91</td>\n",
       "      <td>218.6</td>\n",
       "      <td>533,206</td>\n",
       "      <td>...</td>\n",
       "      <td>-86.198180</td>\n",
       "      <td>1256.0</td>\n",
       "      <td>732.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>524.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Mesa Verde</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>37.18°N 108.49°W</td>\n",
       "      <td>37.1800</td>\n",
       "      <td>-108.4900</td>\n",
       "      <td>29-Jun-06</td>\n",
       "      <td>52,485.17 acres (212.4 km2)</td>\n",
       "      <td>52,485.17</td>\n",
       "      <td>212.4</td>\n",
       "      <td>563,420</td>\n",
       "      <td>...</td>\n",
       "      <td>-108.504240</td>\n",
       "      <td>94.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Mount Rainier</td>\n",
       "      <td>Washington</td>\n",
       "      <td>46.85°N 121.75°W</td>\n",
       "      <td>46.8500</td>\n",
       "      <td>-121.7500</td>\n",
       "      <td>March 2, 1899</td>\n",
       "      <td>236,381.64 acres (956.6 km2)</td>\n",
       "      <td>236,381.64</td>\n",
       "      <td>956.6</td>\n",
       "      <td>1,518,491</td>\n",
       "      <td>...</td>\n",
       "      <td>-122.015440</td>\n",
       "      <td>634.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>278.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>North Cascades</td>\n",
       "      <td>Washington</td>\n",
       "      <td>48.70°N 121.20°W</td>\n",
       "      <td>48.7000</td>\n",
       "      <td>-121.2000</td>\n",
       "      <td>2-Oct-68</td>\n",
       "      <td>504,780.94 acres (2,042.8 km2)</td>\n",
       "      <td>504,780.94</td>\n",
       "      <td>2,042.80</td>\n",
       "      <td>30,085</td>\n",
       "      <td>...</td>\n",
       "      <td>-122.165450</td>\n",
       "      <td>26961.0</td>\n",
       "      <td>13470.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>964.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>658.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>13491.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Olympic</td>\n",
       "      <td>Washington</td>\n",
       "      <td>47.97°N 123.50°W</td>\n",
       "      <td>47.9700</td>\n",
       "      <td>-123.5000</td>\n",
       "      <td>29-Jun-38</td>\n",
       "      <td>922,649.41 acres (3,733.8 km2)</td>\n",
       "      <td>922,649.41</td>\n",
       "      <td>3,733.80</td>\n",
       "      <td>3,104,455</td>\n",
       "      <td>...</td>\n",
       "      <td>-123.406280</td>\n",
       "      <td>23740.0</td>\n",
       "      <td>11671.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>537.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>534.0</td>\n",
       "      <td>465.0</td>\n",
       "      <td>12069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Petrified Forest</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>35.07°N 109.78°W</td>\n",
       "      <td>35.0700</td>\n",
       "      <td>-109.7800</td>\n",
       "      <td>9-Dec-62</td>\n",
       "      <td>221,390.21 acres (895.9 km2)</td>\n",
       "      <td>221,390.21</td>\n",
       "      <td>895.9</td>\n",
       "      <td>644,922</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.522950</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Pinnacles</td>\n",
       "      <td>California</td>\n",
       "      <td>36.48°N 121.16°W</td>\n",
       "      <td>36.4800</td>\n",
       "      <td>-121.1600</td>\n",
       "      <td>10-Jan-13</td>\n",
       "      <td>26,685.73 acres (108.0 km2)</td>\n",
       "      <td>26,685.73</td>\n",
       "      <td>108</td>\n",
       "      <td>222,152</td>\n",
       "      <td>...</td>\n",
       "      <td>-121.015150</td>\n",
       "      <td>732.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>356.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Redwood</td>\n",
       "      <td>California</td>\n",
       "      <td>41.30°N 124.00°W</td>\n",
       "      <td>41.3000</td>\n",
       "      <td>-124.0000</td>\n",
       "      <td>2-Oct-68</td>\n",
       "      <td>138,999.37 acres (562.5 km2)</td>\n",
       "      <td>138,999.37</td>\n",
       "      <td>562.5</td>\n",
       "      <td>482,536</td>\n",
       "      <td>...</td>\n",
       "      <td>-124.167030</td>\n",
       "      <td>23470.0</td>\n",
       "      <td>12672.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1146.0</td>\n",
       "      <td>359.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>654.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>10798.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Rocky Mountain</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>40.40°N 105.58°W</td>\n",
       "      <td>40.4000</td>\n",
       "      <td>-105.5800</td>\n",
       "      <td>26-Jan-15</td>\n",
       "      <td>265,807.25 acres (1,075.7 km2)</td>\n",
       "      <td>265,807.25</td>\n",
       "      <td>1,075.70</td>\n",
       "      <td>4,590,493</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.517220</td>\n",
       "      <td>10012.0</td>\n",
       "      <td>4717.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>5295.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Saguaro</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>32.25°N 110.50°W</td>\n",
       "      <td>32.2500</td>\n",
       "      <td>-110.5000</td>\n",
       "      <td>14-Oct-94</td>\n",
       "      <td>91,715.72 acres (371.2 km2)</td>\n",
       "      <td>91,715.72</td>\n",
       "      <td>371.2</td>\n",
       "      <td>957,405</td>\n",
       "      <td>...</td>\n",
       "      <td>-110.810320</td>\n",
       "      <td>38219.0</td>\n",
       "      <td>18411.0</td>\n",
       "      <td>469.0</td>\n",
       "      <td>1086.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>384.0</td>\n",
       "      <td>1153.0</td>\n",
       "      <td>709.0</td>\n",
       "      <td>19808.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Shenandoah</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>38.53°N 78.35°W</td>\n",
       "      <td>38.5300</td>\n",
       "      <td>-78.3500</td>\n",
       "      <td>26-Dec-35</td>\n",
       "      <td>199,223.77 acres (806.2 km2)</td>\n",
       "      <td>199,223.77</td>\n",
       "      <td>806.2</td>\n",
       "      <td>1,264,880</td>\n",
       "      <td>...</td>\n",
       "      <td>-78.456210</td>\n",
       "      <td>11636.0</td>\n",
       "      <td>5750.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>282.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>5886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Theodore Roosevelt</td>\n",
       "      <td>North Dakota</td>\n",
       "      <td>46.97°N 103.45°W</td>\n",
       "      <td>46.9700</td>\n",
       "      <td>-103.4500</td>\n",
       "      <td>10-Nov-78</td>\n",
       "      <td>70,446.89 acres (285.1 km2)</td>\n",
       "      <td>70,446.89</td>\n",
       "      <td>285.1</td>\n",
       "      <td>749,389</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.568720</td>\n",
       "      <td>282.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Voyageurs</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>48.50°N 92.88°W</td>\n",
       "      <td>48.5000</td>\n",
       "      <td>-92.8800</td>\n",
       "      <td>8-Jan-71</td>\n",
       "      <td>218,222.35 acres (883.1 km2)</td>\n",
       "      <td>218,222.35</td>\n",
       "      <td>883.1</td>\n",
       "      <td>239,656</td>\n",
       "      <td>...</td>\n",
       "      <td>-93.381420</td>\n",
       "      <td>9210.0</td>\n",
       "      <td>4587.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>4623.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>White Sands</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>32.78°N 106.17°W</td>\n",
       "      <td>32.7800</td>\n",
       "      <td>-106.1700</td>\n",
       "      <td>December 20, 2019[107]</td>\n",
       "      <td>146,344.31 acres (592.2 km2)</td>\n",
       "      <td>146,344.31</td>\n",
       "      <td>592.2</td>\n",
       "      <td>603,008</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.975610</td>\n",
       "      <td>36282.0</td>\n",
       "      <td>17986.0</td>\n",
       "      <td>480.0</td>\n",
       "      <td>962.0</td>\n",
       "      <td>434.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>1213.0</td>\n",
       "      <td>524.0</td>\n",
       "      <td>18296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Wind Cave</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.57°N 103.48°W</td>\n",
       "      <td>43.5700</td>\n",
       "      <td>-103.4800</td>\n",
       "      <td>9-Jan-03</td>\n",
       "      <td>33,970.84 acres (137.5 km2)</td>\n",
       "      <td>33,970.84</td>\n",
       "      <td>137.5</td>\n",
       "      <td>656,397</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.505100</td>\n",
       "      <td>5915.0</td>\n",
       "      <td>2936.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>2979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Wrangell</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>61.00°N 142.00°W</td>\n",
       "      <td>61.0000</td>\n",
       "      <td>-142.0000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>8,323,146.48 acres (33,682.6 km2)</td>\n",
       "      <td>8,323,146.48</td>\n",
       "      <td>33,682.60</td>\n",
       "      <td>79,450</td>\n",
       "      <td>...</td>\n",
       "      <td>-145.230800</td>\n",
       "      <td>540.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>279.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Yellowstone</td>\n",
       "      <td>Wyoming, Montana, Idaho</td>\n",
       "      <td>44.60°N 110.50°W</td>\n",
       "      <td>44.6000</td>\n",
       "      <td>-110.5000</td>\n",
       "      <td>March 1, 1872</td>\n",
       "      <td>2,219,790.71 acres (8,983.2 km2)</td>\n",
       "      <td>2,219,790.71</td>\n",
       "      <td>8,983.20</td>\n",
       "      <td>4,115,000</td>\n",
       "      <td>...</td>\n",
       "      <td>-110.894210</td>\n",
       "      <td>1075.0</td>\n",
       "      <td>533.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>542.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Yosemite</td>\n",
       "      <td>California</td>\n",
       "      <td>37.83°N 119.50°W</td>\n",
       "      <td>37.8300</td>\n",
       "      <td>-119.5000</td>\n",
       "      <td>October 1, 1890</td>\n",
       "      <td>761,747.50 acres (3,082.7 km2)</td>\n",
       "      <td>761,747.50</td>\n",
       "      <td>3,082.70</td>\n",
       "      <td>4,009,436</td>\n",
       "      <td>...</td>\n",
       "      <td>-119.675290</td>\n",
       "      <td>1392.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>510.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Zion</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.30°N 113.05°W</td>\n",
       "      <td>37.3000</td>\n",
       "      <td>-113.0500</td>\n",
       "      <td>19-Nov-19</td>\n",
       "      <td>147,242.66 acres (595.9 km2)</td>\n",
       "      <td>147,242.66</td>\n",
       "      <td>595.9</td>\n",
       "      <td>4,320,033</td>\n",
       "      <td>...</td>\n",
       "      <td>-113.013922</td>\n",
       "      <td>540.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>249.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>58 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Name                   Location  \\\n",
       "0                         Arches                       Utah   \n",
       "1                    Canyonlands                       Utah   \n",
       "2                       Badlands               South Dakota   \n",
       "3                       Big Bend                      Texas   \n",
       "4                       Biscayne                    Florida   \n",
       "5   Black Canyon of The Gunnison                   Colorado   \n",
       "6                   Bryce Canyon                       Utah   \n",
       "7                   Capitol Reef                       Utah   \n",
       "8               Carlsbad Caverns                 New Mexico   \n",
       "9                Channel Islands                 California   \n",
       "10                      Congaree             South Carolina   \n",
       "11                   Crater Lake                     Oregon   \n",
       "12               Cuyahoga Valley                       Ohio   \n",
       "13                  Death Valley         California, Nevada   \n",
       "14                        Denali                     Alaska   \n",
       "15                  Dry Tortugas                    Florida   \n",
       "16                    Everglades                    Florida   \n",
       "17           Gates of The Arctic                     Alaska   \n",
       "18                  Gateway Arch                   Missouri   \n",
       "19                       Glacier                    Montana   \n",
       "20                   Glacier Bay                     Alaska   \n",
       "21                  Grand Canyon                    Arizona   \n",
       "22                   Grand Teton                    Wyoming   \n",
       "23                   Great Basin                     Nevada   \n",
       "24              Great Sand Dunes                   Colorado   \n",
       "25         Great Smoky Mountains  North Carolina, Tennessee   \n",
       "26           Guadalupe Mountains                      Texas   \n",
       "27                     Haleakala                     Hawaii   \n",
       "28                   Hot Springs                   Arkansas   \n",
       "29                 Indiana Dunes                    Indiana   \n",
       "30                   Isle Royale                   Michigan   \n",
       "31                   Joshua Tree                 California   \n",
       "32                        Katmai                     Alaska   \n",
       "33                  Kenai Fjords                     Alaska   \n",
       "34                  Kings Canyon                 California   \n",
       "35                       Sequoia                 California   \n",
       "36                  Kobuk Valley                     Alaska   \n",
       "37                    Lake Clark                     Alaska   \n",
       "38               Lassen Volcanic                 California   \n",
       "39                  Mammoth Cave                   Kentucky   \n",
       "40                    Mesa Verde                   Colorado   \n",
       "41                 Mount Rainier                 Washington   \n",
       "42                North Cascades                 Washington   \n",
       "43                       Olympic                 Washington   \n",
       "44              Petrified Forest                    Arizona   \n",
       "45                     Pinnacles                 California   \n",
       "46                       Redwood                 California   \n",
       "47                Rocky Mountain                   Colorado   \n",
       "48                       Saguaro                    Arizona   \n",
       "49                    Shenandoah                   Virginia   \n",
       "50            Theodore Roosevelt               North Dakota   \n",
       "51                     Voyageurs                  Minnesota   \n",
       "52                   White Sands                 New Mexico   \n",
       "53                     Wind Cave               South Dakota   \n",
       "54                      Wrangell                     Alaska   \n",
       "55                   Yellowstone    Wyoming, Montana, Idaho   \n",
       "56                      Yosemite                 California   \n",
       "57                          Zion                       Utah   \n",
       "\n",
       "            coordinates      lat       lon Date established as park  \\\n",
       "0      38.68°N 109.57°W  38.6800 -109.5700                12-Nov-71   \n",
       "1       38.2°N 109.93°W  38.2000 -109.9300                12-Sep-64   \n",
       "2      43.75°N 102.50°W  43.7500 -102.5000                10-Nov-78   \n",
       "3      29.25°N 103.25°W  29.2500 -103.2500                12-Jun-44   \n",
       "4       25.65°N 80.08°W  25.6500  -80.0800                28-Jun-80   \n",
       "5      38.57°N 107.72°W  38.5700 -107.7200                21-Oct-99   \n",
       "6      37.57°N 112.18°W  37.5700 -112.1800                25-Feb-28   \n",
       "7      38.20°N 111.17°W  38.2000 -111.1700                18-Dec-71   \n",
       "8      32.17°N 104.44°W  32.1700 -104.4400                14-May-30   \n",
       "9      34.01°N 119.42°W  34.0100 -119.4200                 5-Mar-80   \n",
       "10      33.78°N 80.78°W  33.7800  -80.7800                10-Nov-03   \n",
       "11      42.94°N 122.1°W  42.9400 -122.1000                22-May-02   \n",
       "12      41.24°N 81.55°W  41.2400  -81.5500                11-Oct-00   \n",
       "13     36.24°N 116.82°W  36.2400 -116.8200                31-Oct-94   \n",
       "14     63.33°N 150.50°W  63.3300 -150.5000                26-Feb-17   \n",
       "15      24.63°N 82.87°W  24.6300  -82.8700                26-Oct-92   \n",
       "16      25.32°N 80.93°W  25.3200  -80.9300                30-May-34   \n",
       "17     67.78°N 153.30°W  67.7800 -153.3000                 2-Dec-80   \n",
       "18      38.63°N 90.19°W  38.6300  -90.1900    February 22, 2018[45]   \n",
       "19     48.80°N 114.00°W  48.8000 -114.0000                11-May-10   \n",
       "20     58.50°N 137.00°W  58.5000 -137.0000                 2-Dec-80   \n",
       "21     36.06°N 112.14°W  36.0600 -112.1400                26-Feb-19   \n",
       "22     43.73°N 110.80°W  43.7300 -110.8000                26-Feb-29   \n",
       "23     38.98°N 114.30°W  38.9800 -114.3000                27-Oct-86   \n",
       "24     37.73°N 105.51°W  37.7300 -105.5100                13-Sep-04   \n",
       "25      35.68°N 83.53°W  35.6800  -83.5300                15-Jun-34   \n",
       "26     31.92°N 104.87°W  31.9200 -104.8700                15-Oct-66   \n",
       "27     20.72°N 156.17°W  20.7200 -156.1700                 1-Jul-61   \n",
       "28      34.51°N 93.05°W  34.5100  -93.0500                 4-Mar-21   \n",
       "29  41.6533°N 87.0524°W  41.6533  -87.0524                15-Feb-19   \n",
       "30      48.10°N 88.55°W  48.1000  -88.5500                 3-Apr-40   \n",
       "31     33.79°N 115.90°W  33.7900 -115.9000                31-Oct-94   \n",
       "32     58.50°N 155.00°W  58.5000 -155.0000                 2-Dec-80   \n",
       "33     59.92°N 149.65°W  59.9200 -149.6500                 2-Dec-80   \n",
       "34     36.80°N 118.55°W  36.8000 -118.5500                 4-Mar-40   \n",
       "35     36.43°N 118.68°W  36.4300 -118.6800       September 25, 1890   \n",
       "36     67.55°N 159.28°W  67.5500 -159.2800                 2-Dec-80   \n",
       "37     60.97°N 153.42°W  60.9700 -153.4200                 2-Dec-80   \n",
       "38     40.49°N 121.51°W  40.4900 -121.5100                 9-Aug-16   \n",
       "39      37.18°N 86.10°W  37.1800  -86.1000                 1-Jul-41   \n",
       "40     37.18°N 108.49°W  37.1800 -108.4900                29-Jun-06   \n",
       "41     46.85°N 121.75°W  46.8500 -121.7500            March 2, 1899   \n",
       "42     48.70°N 121.20°W  48.7000 -121.2000                 2-Oct-68   \n",
       "43     47.97°N 123.50°W  47.9700 -123.5000                29-Jun-38   \n",
       "44     35.07°N 109.78°W  35.0700 -109.7800                 9-Dec-62   \n",
       "45     36.48°N 121.16°W  36.4800 -121.1600                10-Jan-13   \n",
       "46     41.30°N 124.00°W  41.3000 -124.0000                 2-Oct-68   \n",
       "47     40.40°N 105.58°W  40.4000 -105.5800                26-Jan-15   \n",
       "48     32.25°N 110.50°W  32.2500 -110.5000                14-Oct-94   \n",
       "49      38.53°N 78.35°W  38.5300  -78.3500                26-Dec-35   \n",
       "50     46.97°N 103.45°W  46.9700 -103.4500                10-Nov-78   \n",
       "51      48.50°N 92.88°W  48.5000  -92.8800                 8-Jan-71   \n",
       "52     32.78°N 106.17°W  32.7800 -106.1700   December 20, 2019[107]   \n",
       "53     43.57°N 103.48°W  43.5700 -103.4800                 9-Jan-03   \n",
       "54     61.00°N 142.00°W  61.0000 -142.0000                 2-Dec-80   \n",
       "55     44.60°N 110.50°W  44.6000 -110.5000            March 1, 1872   \n",
       "56     37.83°N 119.50°W  37.8300 -119.5000          October 1, 1890   \n",
       "57     37.30°N 113.05°W  37.3000 -113.0500                19-Nov-19   \n",
       "\n",
       "                          Area, acres   area, acres area, km^2  \\\n",
       "0         76,678.98 acres (310.3 km2)     76,678.98      310.3   \n",
       "1      337,597.83 acres (1,366.2 km2)    337,597.83   1,366.20   \n",
       "2        242,755.94 acres (982.4 km2)    242,755.94      982.4   \n",
       "3      801,163.21 acres (3,242.2 km2)    801,163.21   3,242.20   \n",
       "4        172,971.11 acres (700.0 km2)    172,971.11        700   \n",
       "5         30,779.83 acres (124.6 km2)     30,779.83      124.6   \n",
       "6         35,835.08 acres (145.0 km2)     35,835.08        145   \n",
       "7        241,904.50 acres (979.0 km2)    241,904.50        979   \n",
       "8         46,766.45 acres (189.3 km2)     46,766.45      189.3   \n",
       "9      249,561.00 acres (1,009.9 km2)    249,561.00   1,009.90   \n",
       "10        26,476.47 acres (107.1 km2)     26,476.47      107.1   \n",
       "11       183,224.05 acres (741.5 km2)    183,224.05      741.5   \n",
       "12        32,571.88 acres (131.8 km2)     32,571.88      131.8   \n",
       "13  3,408,406.73 acres (13,793.3 km2)  3,408,406.73  13,793.30   \n",
       "14  4,740,911.16 acres (19,185.8 km2)  4,740,911.16  19,185.80   \n",
       "15        64,701.22 acres (261.8 km2)     64,701.22      261.8   \n",
       "16   1,508,938.57 acres (6,106.5 km2)  1,508,938.57   6,106.50   \n",
       "17  7,523,897.45 acres (30,448.1 km2)  7,523,897.45  30,448.10   \n",
       "18             192.83 acres (0.8 km2)        192.83        0.8   \n",
       "19   1,013,125.99 acres (4,100.0 km2)  1,013,125.99   4,100.00   \n",
       "20  3,223,383.43 acres (13,044.6 km2)  3,223,383.43  13,044.60   \n",
       "21   1,201,647.03 acres (4,862.9 km2)  1,201,647.03   4,862.90   \n",
       "22     310,044.36 acres (1,254.7 km2)    310,044.36   1,254.70   \n",
       "23        77,180.00 acres (312.3 km2)     77,180.00      312.3   \n",
       "24       107,341.87 acres (434.4 km2)    107,341.87      434.4   \n",
       "25     522,426.88 acres (2,114.2 km2)    522,426.88   2,114.20   \n",
       "26        86,367.10 acres (349.5 km2)     86,367.10      349.5   \n",
       "27        33,264.62 acres (134.6 km2)     33,264.62      134.6   \n",
       "28          5,554.15 acres (22.5 km2)      5,554.15       22.5   \n",
       "29         15,349.08 acres (62.1 km2)     15,349.08       62.1   \n",
       "30     571,790.30 acres (2,314.0 km2)    571,790.30   2,314.00   \n",
       "31     795,155.85 acres (3,217.9 km2)    795,155.85   3,217.90   \n",
       "32  3,674,529.33 acres (14,870.3 km2)  3,674,529.33  14,870.30   \n",
       "33     669,650.05 acres (2,710.0 km2)    669,650.05   2,710.00   \n",
       "34     461,901.20 acres (1,869.2 km2)    461,901.20   1,869.20   \n",
       "35     404,062.63 acres (1,635.2 km2)    404,062.63   1,635.20   \n",
       "36   1,750,716.16 acres (7,084.9 km2)  1,750,716.16   7,084.90   \n",
       "37  2,619,816.49 acres (10,602.0 km2)  2,619,816.49  10,602.00   \n",
       "38       106,589.02 acres (431.4 km2)    106,589.02      431.4   \n",
       "39        54,011.91 acres (218.6 km2)     54,011.91      218.6   \n",
       "40        52,485.17 acres (212.4 km2)     52,485.17      212.4   \n",
       "41       236,381.64 acres (956.6 km2)    236,381.64      956.6   \n",
       "42     504,780.94 acres (2,042.8 km2)    504,780.94   2,042.80   \n",
       "43     922,649.41 acres (3,733.8 km2)    922,649.41   3,733.80   \n",
       "44       221,390.21 acres (895.9 km2)    221,390.21      895.9   \n",
       "45        26,685.73 acres (108.0 km2)     26,685.73        108   \n",
       "46       138,999.37 acres (562.5 km2)    138,999.37      562.5   \n",
       "47     265,807.25 acres (1,075.7 km2)    265,807.25   1,075.70   \n",
       "48        91,715.72 acres (371.2 km2)     91,715.72      371.2   \n",
       "49       199,223.77 acres (806.2 km2)    199,223.77      806.2   \n",
       "50        70,446.89 acres (285.1 km2)     70,446.89      285.1   \n",
       "51       218,222.35 acres (883.1 km2)    218,222.35      883.1   \n",
       "52       146,344.31 acres (592.2 km2)    146,344.31      592.2   \n",
       "53        33,970.84 acres (137.5 km2)     33,970.84      137.5   \n",
       "54  8,323,146.48 acres (33,682.6 km2)  8,323,146.48  33,682.60   \n",
       "55   2,219,790.71 acres (8,983.2 km2)  2,219,790.71   8,983.20   \n",
       "56     761,747.50 acres (3,082.7 km2)    761,747.50   3,082.70   \n",
       "57       147,242.66 acres (595.9 km2)    147,242.66      595.9   \n",
       "\n",
       "   Recreation visitors  ...   Longitude Total_POP    TMale TMale21  TMale35  \\\n",
       "0            1,663,557  ... -109.493920   10043.0   4929.0     80.0   317.0   \n",
       "1              739,449  ... -109.493920   10043.0   4929.0     80.0   317.0   \n",
       "2            1,008,942  ... -101.943550     224.0    100.0      0.0    11.0   \n",
       "3              440,091  ... -103.210850     213.0    111.0      0.0     9.0   \n",
       "4              469,253  ...  -80.426920   58224.0  28526.0    343.0  1966.0   \n",
       "5              308,962  ... -107.862500   22633.0  10950.0    183.0   590.0   \n",
       "6            2,679,478  ... -112.208570     270.0    128.0      3.0     6.0   \n",
       "7            1,227,627  ... -111.002200     301.0    113.0      4.0     0.0   \n",
       "8              465,912  ... -104.291340   36708.0  18602.0    233.0  1236.0   \n",
       "9              366,250  ... -119.301640   33185.0  16763.0    189.0  1077.0   \n",
       "10             145,929  ...  -80.845350   14605.0   7235.0    138.0   336.0   \n",
       "11             720,659  ... -122.274430     152.0    110.0      0.0     0.0   \n",
       "12           2,096,053  ...  -81.618350   13830.0   6861.0     38.0   292.0   \n",
       "13           1,678,660  ... -117.202960     354.0    205.0      2.0    30.0   \n",
       "14             594,660  ... -148.833960     856.0    414.0     20.0     8.0   \n",
       "15              56,810  ...  -80.513820   23281.0  12004.0    188.0   904.0   \n",
       "16             597,124  ...  -80.513820   23281.0  12004.0    188.0   904.0   \n",
       "17               9,591  ... -147.720450   17510.0   8941.0    279.0   603.0   \n",
       "18           2,016,180  ...  -90.187020    2201.0   1551.0     57.0   156.0   \n",
       "19           2,965,309  ... -113.925990     401.0    208.0      6.0     2.0   \n",
       "20             597,915  ... -135.730880     416.0    192.0      0.0     8.0   \n",
       "21           6,380,495  ... -112.064980    2485.0   1212.0     38.0   162.0   \n",
       "22           3,491,151  ... -110.832150     226.0     75.0      0.0     0.0   \n",
       "23             153,094  ... -114.125920     121.0     57.0     11.0     0.0   \n",
       "24             442,905  ... -105.731010     772.0    377.0      9.0    39.0   \n",
       "25          11,421,200  ...  -83.471560    5555.0   2802.0     56.0    96.0   \n",
       "26             172,347  ... -105.308820     156.0    129.0      0.0    19.0   \n",
       "27           1,044,084  ... -156.331580   18155.0   9313.0     68.0   548.0   \n",
       "28           1,506,887  ...  -93.019410   30003.0  14240.0    119.0   671.0   \n",
       "29           1,756,079  ...  -87.058830   24906.0  12714.0    106.0   882.0   \n",
       "30              25,798  ...  -88.572590    9642.0   6043.0    628.0   153.0   \n",
       "31           2,942,382  ... -116.033430   23517.0  11950.0    286.0   755.0   \n",
       "32              37,818  ... -156.640070     455.0    266.0      1.0    29.0   \n",
       "33             321,596  ... -149.412710    4575.0   2670.0     23.0   187.0   \n",
       "34             699,023  ... -118.862960    2432.0   1292.0      8.0    47.0   \n",
       "35           1,229,594  ... -118.862960    2432.0   1292.0      8.0    47.0   \n",
       "36              14,937  ... -162.585440    3370.0   1811.0     39.0   116.0   \n",
       "37              14,479  ... -154.557080     151.0     72.0      0.0    10.0   \n",
       "38             499,435  ... -121.582450     292.0    184.0      0.0    18.0   \n",
       "39             533,206  ...  -86.198180    1256.0    732.0     38.0    32.0   \n",
       "40             563,420  ... -108.504240      94.0     47.0      0.0     0.0   \n",
       "41           1,518,491  ... -122.015440     634.0    356.0      0.0    26.0   \n",
       "42              30,085  ... -122.165450   26961.0  13470.0    312.0   964.0   \n",
       "43           3,104,455  ... -123.406280   23740.0  11671.0    204.0   537.0   \n",
       "44             644,922  ... -109.522950       0.0      0.0      0.0     0.0   \n",
       "45             222,152  ... -121.015150     732.0    376.0      0.0    15.0   \n",
       "46             482,536  ... -124.167030   23470.0  12672.0     48.0  1146.0   \n",
       "47           4,590,493  ... -105.517220   10012.0   4717.0     37.0   227.0   \n",
       "48             957,405  ... -110.810320   38219.0  18411.0    469.0  1086.0   \n",
       "49           1,264,880  ...  -78.456210   11636.0   5750.0     34.0   282.0   \n",
       "50             749,389  ... -103.568720     282.0    160.0      0.0    17.0   \n",
       "51             239,656  ...  -93.381420    9210.0   4587.0    117.0   236.0   \n",
       "52             603,008  ... -105.975610   36282.0  17986.0    480.0   962.0   \n",
       "53             656,397  ... -103.505100    5915.0   2936.0      0.0    96.0   \n",
       "54              79,450  ... -145.230800     540.0    261.0      0.0    15.0   \n",
       "55           4,115,000  ... -110.894210    1075.0    533.0     34.0     3.0   \n",
       "56           4,009,436  ... -119.675290    1392.0    882.0     19.0   136.0   \n",
       "57           4,320,033  ... -113.013922     540.0    291.0      0.0    31.0   \n",
       "\n",
       "    TMale65 TFemale21 TFemale35  TFemale65   TFemal  \n",
       "0     103.0      29.0     321.0      162.0   5114.0  \n",
       "1     103.0      29.0     321.0      162.0   5114.0  \n",
       "2       0.0       0.0       3.0        0.0    124.0  \n",
       "3       0.0       0.0       4.0        8.0    102.0  \n",
       "4     506.0     457.0    2416.0      599.0  29698.0  \n",
       "5     312.0      83.0     598.0      466.0  11683.0  \n",
       "6       0.0       0.0       0.0        0.0    142.0  \n",
       "7       0.0       7.0       6.0        0.0    188.0  \n",
       "8     345.0     240.0    1060.0      366.0  18106.0  \n",
       "9     369.0     141.0     897.0      490.0  16422.0  \n",
       "10    220.0      37.0     457.0      206.0   7370.0  \n",
       "11      0.0       0.0       0.0        0.0     42.0  \n",
       "12    315.0       8.0     273.0      227.0   6969.0  \n",
       "13      0.0       2.0      15.0       10.0    149.0  \n",
       "14      0.0      15.0      87.0        5.0    442.0  \n",
       "15    148.0      82.0     679.0      433.0  11277.0  \n",
       "16    148.0      82.0     679.0      433.0  11277.0  \n",
       "17    271.0     243.0     431.0      244.0   8569.0  \n",
       "18     43.0       0.0      69.0       15.0    650.0  \n",
       "19      4.0       0.0       0.0       17.0    193.0  \n",
       "20     23.0       0.0       4.0       19.0    224.0  \n",
       "21     61.0      44.0     118.0        0.0   1273.0  \n",
       "22      0.0       0.0       0.0        0.0    151.0  \n",
       "23      9.0       0.0       0.0        0.0     64.0  \n",
       "24     11.0       0.0      50.0       11.0    395.0  \n",
       "25     75.0      10.0     149.0      108.0   2753.0  \n",
       "26      0.0       0.0       0.0        0.0     27.0  \n",
       "27    228.0      50.0     522.0      336.0   8842.0  \n",
       "28    268.0      73.0    1198.0      376.0  15763.0  \n",
       "29    283.0       0.0     851.0      444.0  12192.0  \n",
       "30     58.0     141.0     149.0       30.0   3599.0  \n",
       "31    121.0     359.0     529.0      225.0  11567.0  \n",
       "32      5.0       3.0      15.0        0.0    189.0  \n",
       "33     34.0      45.0      61.0       67.0   1905.0  \n",
       "34     72.0       0.0      74.0       70.0   1140.0  \n",
       "35     72.0       0.0      74.0       70.0   1140.0  \n",
       "36     21.0      30.0      87.0       24.0   1559.0  \n",
       "37      1.0       0.0       7.0        0.0     79.0  \n",
       "38      2.0       0.0       0.0        0.0    108.0  \n",
       "39     11.0       2.0      16.0       14.0    524.0  \n",
       "40      0.0       0.0      22.0        0.0     47.0  \n",
       "41     15.0       0.0       0.0       29.0    278.0  \n",
       "42    321.0     105.0     658.0      291.0  13491.0  \n",
       "43    356.0     129.0     534.0      465.0  12069.0  \n",
       "44      0.0       0.0       0.0        0.0      0.0  \n",
       "45     15.0       8.0      23.0       13.0    356.0  \n",
       "46    359.0      75.0     654.0      290.0  10798.0  \n",
       "47    229.0      43.0     179.0      234.0   5295.0  \n",
       "48    364.0     384.0    1153.0      709.0  19808.0  \n",
       "49    194.0      47.0     419.0      172.0   5886.0  \n",
       "50      6.0       0.0       5.0        7.0    122.0  \n",
       "51    104.0      65.0     172.0      122.0   4623.0  \n",
       "52    434.0     196.0    1213.0      524.0  18296.0  \n",
       "53    120.0       5.0      70.0      135.0   2979.0  \n",
       "54      1.0       2.0      27.0        5.0    279.0  \n",
       "55      7.0      29.0       4.0        9.0    542.0  \n",
       "56     39.0       5.0      21.0        0.0    510.0  \n",
       "57      6.0      13.0       8.0       12.0    249.0  \n",
       "\n",
       "[58 rows x 29 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_census_forheat_df = pd.read_csv('../bootcamp_project_1/Park_Census_forHeat.csv')\n",
    "park_census_forpin_df = pd.read_csv('../bootcamp_project_1/NationalPark_Census_Merge.csv')\n",
    "\n",
    "park_census_forheat_df = park_census_forheat_df.drop(columns = ['Unnamed: 0'])\n",
    "\n",
    "park_census_forheat_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    " # Configure gmaps\n",
    "gmaps.configure(api_key=gkey)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "575dbe1b964c4307b11f8c17543999bc",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Map(configuration={'api_key': 'AIzaSyDF0IwRzkFUJYOwBTEfq0NBdWAAmIlGhcQ'}, data_bounds=[(20.69298877871267, -15…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Store latitude and longitude\n",
    "locations = park_census_forheat_df[['lat', 'lon']]\n",
    "\n",
    "tot_pop = park_census_forheat_df['Total_POP']\n",
    "\n",
    "# Plot Heatmap\n",
    "fig = gmaps.Map()\n",
    "\n",
    "# Create heat layer\n",
    "heat_layer = gmaps.heatmap_layer(locations, weights=tot_pop)\n",
    "\n",
    "# Add layer\n",
    "fig.add_layer(heat_layer)\n",
    "\n",
    "fig"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "58224.0"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_census_forheat_df['Total_POP'].max()\n",
    "#Biscayne National Park, Florida area should be most populated"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4     58224.0\n",
       "48    38219.0\n",
       "8     36708.0\n",
       "Name: Total_POP, dtype: float64"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_census_forheat_df['Total_POP'].nlargest(3)\n",
    "#1. Biscayne National Park, Florida area should be most populated\n",
    "#2. Saguaro National Park, Arizona should be second most populated\n",
    "#3. Carlsbad Caverns National Park, New Mexico"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(40.71, -74.0),\n",
       " (30.26, -97.74),\n",
       " (46.87, -96.78),\n",
       " (47.6, -122.33),\n",
       " (32.71, -117.16)]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "coordinates = [\n",
    "    (40.71, -74.00),\n",
    "    (30.26, -97.74),\n",
    "    (46.87, -96.78),\n",
    "    (47.60, -122.33),\n",
    "    (32.71, -117.16)\n",
    "]\n",
    "\n",
    "coordinates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        (38.68, -109.57)\n",
       "1         (38.2, -109.93)\n",
       "2         (43.75, -102.5)\n",
       "3        (29.25, -103.25)\n",
       "4         (25.65, -80.08)\n",
       "5        (38.57, -107.72)\n",
       "6        (37.57, -112.18)\n",
       "7         (38.2, -111.17)\n",
       "8        (32.17, -104.44)\n",
       "9        (34.01, -119.42)\n",
       "10        (33.78, -80.78)\n",
       "11        (42.94, -122.1)\n",
       "12        (41.24, -81.55)\n",
       "13       (36.24, -116.82)\n",
       "14        (63.33, -150.5)\n",
       "15        (24.63, -82.87)\n",
       "16        (25.32, -80.93)\n",
       "17        (67.78, -153.3)\n",
       "18        (38.63, -90.19)\n",
       "19         (48.8, -114.0)\n",
       "20         (58.5, -137.0)\n",
       "21       (36.06, -112.14)\n",
       "22        (43.73, -110.8)\n",
       "23        (38.98, -114.3)\n",
       "24       (37.73, -105.51)\n",
       "25        (35.68, -83.53)\n",
       "26       (31.92, -104.87)\n",
       "27       (20.72, -156.17)\n",
       "28        (34.51, -93.05)\n",
       "29    (41.6533, -87.0524)\n",
       "30         (48.1, -88.55)\n",
       "31        (33.79, -115.9)\n",
       "32         (58.5, -155.0)\n",
       "33       (59.92, -149.65)\n",
       "34        (36.8, -118.55)\n",
       "35       (36.43, -118.68)\n",
       "36       (67.55, -159.28)\n",
       "37       (60.97, -153.42)\n",
       "38       (40.49, -121.51)\n",
       "39         (37.18, -86.1)\n",
       "40       (37.18, -108.49)\n",
       "41       (46.85, -121.75)\n",
       "42         (48.7, -121.2)\n",
       "43        (47.97, -123.5)\n",
       "44       (35.07, -109.78)\n",
       "45       (36.48, -121.16)\n",
       "46         (41.3, -124.0)\n",
       "47        (40.4, -105.58)\n",
       "48        (32.25, -110.5)\n",
       "49        (38.53, -78.35)\n",
       "50       (46.97, -103.45)\n",
       "51         (48.5, -92.88)\n",
       "52       (32.78, -106.17)\n",
       "53       (43.57, -103.48)\n",
       "54         (61.0, -142.0)\n",
       "55         (44.6, -110.5)\n",
       "56        (37.83, -119.5)\n",
       "57        (37.3, -113.05)\n",
       "Name: combined, dtype: object"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_census_forheat_df['combined'] = list(zip(park_census_forheat_df.lat, park_census_forheat_df.lon))\n",
    "park_census_forheat_df['combined']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "figure_layout = {\n",
    "    'width': '400px',\n",
    "    'height': '300px',\n",
    "    'border': '1px solid black',\n",
    "    'padding': '1px',\n",
    "    'margin': '0 auto 0 auto'\n",
    "}\n",
    "fig = gmaps.figure(layout=figure_layout)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "054c972e2a2a40bbbce4922f6ca944c8",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Figure(layout=FigureLayout(border='1px solid black', height='300px', margin='0 auto 0 auto', padding='1px', wi…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Assign the marker layer to a variable\n",
    "markers = gmaps.marker_layer(park_census_forheat_df['combined'])\n",
    "# Add the layer to the map\n",
    "fig.add_layer(markers)\n",
    "fig"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_census_forpin_df['combined'] = list(zip(park_census_forpin_df.Latitude, park_census_forpin_df.Longitude))\n",
    "#park_census_forpin_df['combined']\n",
    "park_census_forpin_df['combined'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}