DBAccess.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[(1, 1, 'FS-1418826', 'FED', 'FS-FIRESTAT', 'FS', 'USCAPNF', 'Plumas National Forest', '0511', 'Plumas National Forest', '1', 'PNF-47', 'BJ8K', 'FOUNTAIN', None, None, None, None, None, 2005, 2453403.5, 33, '1300', 9.0, 'Miscellaneous', 2453403.5, 33, '1730', 0.1, 'A', 40.03694444, -121.00583333, 5.0, 'USFS', 'CA', '63', '063', 'Plumas', b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0\\xe0\\xc8l\\x98\\xba\\x04D@\\xe8d\\xc2\\x92_@^\\xc0\\xe0\\xc8l\\x98\\xba\\x04D@|\\x01\\x00\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0\\xe0\\xc8l\\x98\\xba\\x04D@\\xfe', 1602.956920091647, 14642.41169988774)]\n"
     ]
    }
   ],
   "source": [
    "import sqlite3\n",
    "conn = sqlite3.connect(r\"C:\\Users\\oisin\\Code\\CS185CProject\\FPA_FOD_20170508.sqlite\")\n",
    "c = conn.cursor()\n",
    "c.execute(''' SELECT *, (LATITUDE * LATITUDE) as val1, (LONGITUDE * LONGITUDE) as val2 FROM Fires WHERE STATE = 'CA' LIMIT 1; ''')\n",
    "rows = c.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from scipy import spatial"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_sql_query(\"SELECT * FROM Fires\", conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "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>OBJECTID</th>\n",
       "      <th>FOD_ID</th>\n",
       "      <th>FPA_ID</th>\n",
       "      <th>SOURCE_SYSTEM_TYPE</th>\n",
       "      <th>SOURCE_SYSTEM</th>\n",
       "      <th>NWCG_REPORTING_AGENCY</th>\n",
       "      <th>NWCG_REPORTING_UNIT_ID</th>\n",
       "      <th>NWCG_REPORTING_UNIT_NAME</th>\n",
       "      <th>SOURCE_REPORTING_UNIT</th>\n",
       "      <th>SOURCE_REPORTING_UNIT_NAME</th>\n",
       "      <th>...</th>\n",
       "      <th>FIRE_SIZE_CLASS</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>OWNER_CODE</th>\n",
       "      <th>OWNER_DESCR</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>FIPS_CODE</th>\n",
       "      <th>FIPS_NAME</th>\n",
       "      <th>Shape</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>FS-1418826</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAPNF</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>0511</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.036944</td>\n",
       "      <td>-121.005833</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>63</td>\n",
       "      <td>063</td>\n",
       "      <td>Plumas</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>FS-1418827</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.933056</td>\n",
       "      <td>-120.404444</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>61</td>\n",
       "      <td>061</td>\n",
       "      <td>Placer</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>FS-1418835</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.984167</td>\n",
       "      <td>-120.735556</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>FS-1418845</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.559167</td>\n",
       "      <td>-119.913333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>003</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>FS-1418847</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.559167</td>\n",
       "      <td>-119.933056</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>003</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>FS-1418849</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.635278</td>\n",
       "      <td>-120.103611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0&lt;~\\x90\\xa1\\x06^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>FS-1418851</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.688333</td>\n",
       "      <td>-120.153333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00$o\\x996\\xd0\\t^\\xc0h\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>FS-1418854</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCASHF</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>0514</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.968056</td>\n",
       "      <td>-122.433889</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00t)\\xe8\\xd5\\xc4\\x9b^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>FS-1418856</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCASHF</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>0514</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>41.233611</td>\n",
       "      <td>-122.283333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xdc\\x8d\\x1e\"\"\\x92^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>FS-1418859</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.548333</td>\n",
       "      <td>-120.149167</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\t^\\xc0\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>FS-1418861</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.691667</td>\n",
       "      <td>-120.159722</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x0c\\xd6\\x8b\\xe38\\n^...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>FS-1418863</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.527500</td>\n",
       "      <td>-120.106111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00L\\xcc@\\x86\\xca\\x06^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>FS-1418865</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.786667</td>\n",
       "      <td>-120.193333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_\\x0c^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>FS-1418872</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.433333</td>\n",
       "      <td>-120.510000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3 ^\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>FS-1418874</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.675833</td>\n",
       "      <td>-120.279722</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb7\\x06\\xf8\\xe6\\x1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>FS-1418876</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.564167</td>\n",
       "      <td>-120.542222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x84\\xd3\\xc4\\xb3\"^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>FS-1418878</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>G</td>\n",
       "      <td>38.523333</td>\n",
       "      <td>-120.211667</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\r^\\xc0\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>FS-1418881</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>G</td>\n",
       "      <td>38.780000</td>\n",
       "      <td>-120.260000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3\\x10^\\xc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>FS-1418884</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.945000</td>\n",
       "      <td>-120.411667</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x004 )\\xbfX\\x1a^\\xc00\\\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>FS-1418887</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.440833</td>\n",
       "      <td>-105.720556</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xa8I\\x11\\x95\\x1dnZ\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>FS-1418888</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.307222</td>\n",
       "      <td>-105.628611</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x88\\xd6\\x17*;hZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>FS-1418893</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.444444</td>\n",
       "      <td>-105.768056</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b\"\\x00\\x01\\xad\\x10\\x00\\x00|\\xed\\x81\\xd2'qZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>FS-1418894</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.559444</td>\n",
       "      <td>-105.766111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xa3\\xe4\\xf6\\x07qZ\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>FS-1418895</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.308056</td>\n",
       "      <td>-105.526111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xe0\\xee\\xcd\\xab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>FS-1418896</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>33.545278</td>\n",
       "      <td>-105.229444</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x83\\xbb7\\xafNZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>FS-1418897</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>C</td>\n",
       "      <td>33.315833</td>\n",
       "      <td>-105.512222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xcc\\xcb\\xb4?\\xc8`Z\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>FS-1418898</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>33.444444</td>\n",
       "      <td>-105.631111</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe4e\\xda\\x1fdhZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>FS-1418903</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.368056</td>\n",
       "      <td>-105.507222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x14\\xad/Tv`Z\\xc0\\xd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>FS-1418904</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.385278</td>\n",
       "      <td>-105.638611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf8\\x13\"\\x01\\xdfhZ\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>FS-1418905</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.382778</td>\n",
       "      <td>-105.700278</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xcd\\xe4Y\\xd1lZ\\...</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>1880435</th>\n",
       "      <td>1880436</td>\n",
       "      <td>300348217</td>\n",
       "      <td>2015CAIRS28664200</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>CALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.159780</td>\n",
       "      <td>-122.451750</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0\\xfd\\xd4x\\xe9\\x9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880436</th>\n",
       "      <td>1880437</td>\n",
       "      <td>300348237</td>\n",
       "      <td>2015CAIRS26850166</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>CANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>39.143821</td>\n",
       "      <td>-121.036533</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00`\\x0e\\x82\\x8eVB^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880437</th>\n",
       "      <td>1880438</td>\n",
       "      <td>300348240</td>\n",
       "      <td>2015CAIRS27248589</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>CAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>41.224483</td>\n",
       "      <td>-123.763317</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc4\\xde\\x8b/\\xda\\xf...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880438</th>\n",
       "      <td>1880439</td>\n",
       "      <td>300348242</td>\n",
       "      <td>2015CAIRS29017324</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>CANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>39.005712</td>\n",
       "      <td>-121.260759</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xccH\\x84F\\xb0P^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880439</th>\n",
       "      <td>1880440</td>\n",
       "      <td>300348247</td>\n",
       "      <td>2015CAIRS27699480</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAKRN</td>\n",
       "      <td>Kern County Fire Department</td>\n",
       "      <td>CAKRN</td>\n",
       "      <td>Kern County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.933333</td>\n",
       "      <td>-118.883333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x90\\x9e\"\\x87\\x88\\xb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880440</th>\n",
       "      <td>1880441</td>\n",
       "      <td>300348248</td>\n",
       "      <td>2015CAIRS28587133</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.716666</td>\n",
       "      <td>-118.800000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x0003333\\xb3]\\xc0\\xe0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880441</th>\n",
       "      <td>1880442</td>\n",
       "      <td>300348249</td>\n",
       "      <td>2015CAIRS29152556</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>C</td>\n",
       "      <td>34.450000</td>\n",
       "      <td>-118.583333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xa5]\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880442</th>\n",
       "      <td>1880443</td>\n",
       "      <td>300348255</td>\n",
       "      <td>2015CAIRS26850725</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCACZU</td>\n",
       "      <td>San Mateo-Santa Cruz Unit</td>\n",
       "      <td>CACZU</td>\n",
       "      <td>San Mateo-Santa Cruz Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.090126</td>\n",
       "      <td>-122.074684</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x004bf\\x9f\\xc7\\x84^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880443</th>\n",
       "      <td>1880444</td>\n",
       "      <td>300348257</td>\n",
       "      <td>2015CAIRS28268055</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>CALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.297000</td>\n",
       "      <td>-120.528000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00l\\x12\\x83\\xc0\\xca!^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880444</th>\n",
       "      <td>1880445</td>\n",
       "      <td>300348258</td>\n",
       "      <td>2015CAIRS28291406</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>CASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.701111</td>\n",
       "      <td>-122.021111</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00|\\xa5\\xf3\\xe1Y\\x81^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880445</th>\n",
       "      <td>1880446</td>\n",
       "      <td>300348259</td>\n",
       "      <td>2015CAIRS27092196</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>37.361417</td>\n",
       "      <td>-118.465150</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00o\\x81\\x04\\xc5\\x9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880446</th>\n",
       "      <td>1880447</td>\n",
       "      <td>300348260</td>\n",
       "      <td>2015CAIRS29015247</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>34.244444</td>\n",
       "      <td>-116.658889</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00l\\xac\\xc4&lt;+*]\\xc0\\x1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880447</th>\n",
       "      <td>1880448</td>\n",
       "      <td>300348274</td>\n",
       "      <td>2015CAIRS26084391</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAMVU</td>\n",
       "      <td>Monte Vista Unit</td>\n",
       "      <td>CAMVU</td>\n",
       "      <td>CDF - Monte Vista Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>32.576754</td>\n",
       "      <td>-116.627539</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8}V\\x99)(]\\xc00\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880448</th>\n",
       "      <td>1880449</td>\n",
       "      <td>300348276</td>\n",
       "      <td>2015CAIRS27560317</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>CALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.443000</td>\n",
       "      <td>-120.664433</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84X\\xfd\\x11\\x86*^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880449</th>\n",
       "      <td>1880450</td>\n",
       "      <td>300348289</td>\n",
       "      <td>2015CAIRS28493610</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAVNC</td>\n",
       "      <td>Ventura County Fire Department</td>\n",
       "      <td>CAVNC</td>\n",
       "      <td>Ventura County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>34.666666</td>\n",
       "      <td>-119.333333</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xd5]\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880450</th>\n",
       "      <td>1880451</td>\n",
       "      <td>300348290</td>\n",
       "      <td>2015CAIRS27653046</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>CASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.041150</td>\n",
       "      <td>-121.985283</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x80\\x93m\\xe0\\x0e\\x7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880451</th>\n",
       "      <td>1880452</td>\n",
       "      <td>300348291</td>\n",
       "      <td>2015CAIRS27458005</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAAEU</td>\n",
       "      <td>Amador-El Dorado Unit</td>\n",
       "      <td>CAAEU</td>\n",
       "      <td>Amador-El Dorado Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.644183</td>\n",
       "      <td>-120.863673</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\\\\\x1ekF7^\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880452</th>\n",
       "      <td>1880453</td>\n",
       "      <td>300348293</td>\n",
       "      <td>2015CAIRS27587395</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.163117</td>\n",
       "      <td>-118.693303</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0A\\t\\x12_\\xac]\\xc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880453</th>\n",
       "      <td>1880454</td>\n",
       "      <td>300348297</td>\n",
       "      <td>2015CAIRS28589435</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.278180</td>\n",
       "      <td>-118.621180</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00h\\x0c\\xdfg\\xc1\\xa7]\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880454</th>\n",
       "      <td>1880455</td>\n",
       "      <td>300348310</td>\n",
       "      <td>2015CAIRS28424493</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.048577</td>\n",
       "      <td>-120.313090</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x18\\xad\\xa3\\xaa\\t\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880455</th>\n",
       "      <td>1880456</td>\n",
       "      <td>300348311</td>\n",
       "      <td>2015CAIRS27458827</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.936253</td>\n",
       "      <td>-120.613743</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b\"\\x00\\x01\\xad\\x10\\x00\\x00\\x84I\\xb8\\x90G'^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880456</th>\n",
       "      <td>1880457</td>\n",
       "      <td>300348328</td>\n",
       "      <td>2015CAIRS27369138</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATGU</td>\n",
       "      <td>Tehama-Glenn Unit</td>\n",
       "      <td>CATGU</td>\n",
       "      <td>Tehama-Glenn Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.019907</td>\n",
       "      <td>-122.391398</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x10n2\\xaa\\x0c\\x99^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880457</th>\n",
       "      <td>1880458</td>\n",
       "      <td>300348354</td>\n",
       "      <td>2015CAIRS28234594</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>CASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.588583</td>\n",
       "      <td>-123.069617</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8\\x8f\\xdc\\x9at\\xc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880458</th>\n",
       "      <td>1880459</td>\n",
       "      <td>300348361</td>\n",
       "      <td>2015CAIRS27957490</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>CAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.244833</td>\n",
       "      <td>-123.544167</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xfc#\\xd3\\xa1\\xd3\\xe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880459</th>\n",
       "      <td>1880460</td>\n",
       "      <td>300348362</td>\n",
       "      <td>2015CAIRS28291374</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>CALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.415608</td>\n",
       "      <td>-122.660044</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0z0)&gt;\\xaa^\\xc0h\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880460</th>\n",
       "      <td>1880461</td>\n",
       "      <td>300348363</td>\n",
       "      <td>2015CAIRS29019636</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>CASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.481637</td>\n",
       "      <td>-122.389375</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880461</th>\n",
       "      <td>1880462</td>\n",
       "      <td>300348373</td>\n",
       "      <td>2015CAIRS29217935</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>37.617619</td>\n",
       "      <td>-120.938570</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880462</th>\n",
       "      <td>1880463</td>\n",
       "      <td>300348375</td>\n",
       "      <td>2015CAIRS28364460</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>37.617619</td>\n",
       "      <td>-120.938570</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880463</th>\n",
       "      <td>1880464</td>\n",
       "      <td>300348377</td>\n",
       "      <td>2015CAIRS29218079</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.672235</td>\n",
       "      <td>-120.898356</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00x\\xba_\\xaa~9^\\xc0\\xb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880464</th>\n",
       "      <td>1880465</td>\n",
       "      <td>300348399</td>\n",
       "      <td>2015CAIRS26733926</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.263217</td>\n",
       "      <td>-116.830950</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x1c\\xa7\\xe8H.5]\\xc0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1880465 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         OBJECTID     FOD_ID             FPA_ID SOURCE_SYSTEM_TYPE  \\\n",
       "0               1          1         FS-1418826                FED   \n",
       "1               2          2         FS-1418827                FED   \n",
       "2               3          3         FS-1418835                FED   \n",
       "3               4          4         FS-1418845                FED   \n",
       "4               5          5         FS-1418847                FED   \n",
       "5               6          6         FS-1418849                FED   \n",
       "6               7          7         FS-1418851                FED   \n",
       "7               8          8         FS-1418854                FED   \n",
       "8               9          9         FS-1418856                FED   \n",
       "9              10         10         FS-1418859                FED   \n",
       "10             11         11         FS-1418861                FED   \n",
       "11             12         12         FS-1418863                FED   \n",
       "12             13         13         FS-1418865                FED   \n",
       "13             14         14         FS-1418872                FED   \n",
       "14             15         15         FS-1418874                FED   \n",
       "15             16         16         FS-1418876                FED   \n",
       "16             17         17         FS-1418878                FED   \n",
       "17             18         18         FS-1418881                FED   \n",
       "18             19         19         FS-1418884                FED   \n",
       "19             20         20         FS-1418887                FED   \n",
       "20             21         21         FS-1418888                FED   \n",
       "21             22         22         FS-1418893                FED   \n",
       "22             23         23         FS-1418894                FED   \n",
       "23             24         24         FS-1418895                FED   \n",
       "24             25         25         FS-1418896                FED   \n",
       "25             26         26         FS-1418897                FED   \n",
       "26             27         27         FS-1418898                FED   \n",
       "27             28         28         FS-1418903                FED   \n",
       "28             29         29         FS-1418904                FED   \n",
       "29             30         30         FS-1418905                FED   \n",
       "...           ...        ...                ...                ...   \n",
       "1880435   1880436  300348217  2015CAIRS28664200             NONFED   \n",
       "1880436   1880437  300348237  2015CAIRS26850166             NONFED   \n",
       "1880437   1880438  300348240  2015CAIRS27248589             NONFED   \n",
       "1880438   1880439  300348242  2015CAIRS29017324             NONFED   \n",
       "1880439   1880440  300348247  2015CAIRS27699480             NONFED   \n",
       "1880440   1880441  300348248  2015CAIRS28587133             NONFED   \n",
       "1880441   1880442  300348249  2015CAIRS29152556             NONFED   \n",
       "1880442   1880443  300348255  2015CAIRS26850725             NONFED   \n",
       "1880443   1880444  300348257  2015CAIRS28268055             NONFED   \n",
       "1880444   1880445  300348258  2015CAIRS28291406             NONFED   \n",
       "1880445   1880446  300348259  2015CAIRS27092196             NONFED   \n",
       "1880446   1880447  300348260  2015CAIRS29015247             NONFED   \n",
       "1880447   1880448  300348274  2015CAIRS26084391             NONFED   \n",
       "1880448   1880449  300348276  2015CAIRS27560317             NONFED   \n",
       "1880449   1880450  300348289  2015CAIRS28493610             NONFED   \n",
       "1880450   1880451  300348290  2015CAIRS27653046             NONFED   \n",
       "1880451   1880452  300348291  2015CAIRS27458005             NONFED   \n",
       "1880452   1880453  300348293  2015CAIRS27587395             NONFED   \n",
       "1880453   1880454  300348297  2015CAIRS28589435             NONFED   \n",
       "1880454   1880455  300348310  2015CAIRS28424493             NONFED   \n",
       "1880455   1880456  300348311  2015CAIRS27458827             NONFED   \n",
       "1880456   1880457  300348328  2015CAIRS27369138             NONFED   \n",
       "1880457   1880458  300348354  2015CAIRS28234594             NONFED   \n",
       "1880458   1880459  300348361  2015CAIRS27957490             NONFED   \n",
       "1880459   1880460  300348362  2015CAIRS28291374             NONFED   \n",
       "1880460   1880461  300348363  2015CAIRS29019636             NONFED   \n",
       "1880461   1880462  300348373  2015CAIRS29217935             NONFED   \n",
       "1880462   1880463  300348375  2015CAIRS28364460             NONFED   \n",
       "1880463   1880464  300348377  2015CAIRS29218079             NONFED   \n",
       "1880464   1880465  300348399  2015CAIRS26733926             NONFED   \n",
       "\n",
       "        SOURCE_SYSTEM NWCG_REPORTING_AGENCY NWCG_REPORTING_UNIT_ID  \\\n",
       "0         FS-FIRESTAT                    FS                USCAPNF   \n",
       "1         FS-FIRESTAT                    FS                USCAENF   \n",
       "2         FS-FIRESTAT                    FS                USCAENF   \n",
       "3         FS-FIRESTAT                    FS                USCAENF   \n",
       "4         FS-FIRESTAT                    FS                USCAENF   \n",
       "5         FS-FIRESTAT                    FS                USCAENF   \n",
       "6         FS-FIRESTAT                    FS                USCAENF   \n",
       "7         FS-FIRESTAT                    FS                USCASHF   \n",
       "8         FS-FIRESTAT                    FS                USCASHF   \n",
       "9         FS-FIRESTAT                    FS                USCAENF   \n",
       "10        FS-FIRESTAT                    FS                USCAENF   \n",
       "11        FS-FIRESTAT                    FS                USCAENF   \n",
       "12        FS-FIRESTAT                    FS                USCAENF   \n",
       "13        FS-FIRESTAT                    FS                USCAENF   \n",
       "14        FS-FIRESTAT                    FS                USCAENF   \n",
       "15        FS-FIRESTAT                    FS                USCAENF   \n",
       "16        FS-FIRESTAT                    FS                USCAENF   \n",
       "17        FS-FIRESTAT                    FS                USCAENF   \n",
       "18        FS-FIRESTAT                    FS                USCAENF   \n",
       "19        FS-FIRESTAT                    FS                USNMLNF   \n",
       "20        FS-FIRESTAT                    FS                USNMLNF   \n",
       "21        FS-FIRESTAT                    FS                USNMLNF   \n",
       "22        FS-FIRESTAT                    FS                USNMLNF   \n",
       "23        FS-FIRESTAT                    FS                USNMLNF   \n",
       "24        FS-FIRESTAT                    FS                USNMLNF   \n",
       "25        FS-FIRESTAT                    FS                USNMLNF   \n",
       "26        FS-FIRESTAT                    FS                USNMLNF   \n",
       "27        FS-FIRESTAT                    FS                USNMLNF   \n",
       "28        FS-FIRESTAT                    FS                USNMLNF   \n",
       "29        FS-FIRESTAT                    FS                USNMLNF   \n",
       "...               ...                   ...                    ...   \n",
       "1880435      ST-CACDF                ST/C&L                USCALNU   \n",
       "1880436      ST-CACDF                ST/C&L                USCANEU   \n",
       "1880437      ST-CACDF                ST/C&L                USCAHUU   \n",
       "1880438      ST-CACDF                ST/C&L                USCANEU   \n",
       "1880439      ST-CACDF                ST/C&L                USCAKRN   \n",
       "1880440      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880441      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880442      ST-CACDF                ST/C&L                USCACZU   \n",
       "1880443      ST-CACDF                ST/C&L                USCALMU   \n",
       "1880444      ST-CACDF                ST/C&L                USCASCU   \n",
       "1880445      ST-CACDF                ST/C&L                USCABDU   \n",
       "1880446      ST-CACDF                ST/C&L                USCABDU   \n",
       "1880447      ST-CACDF                ST/C&L                USCAMVU   \n",
       "1880448      ST-CACDF                ST/C&L                USCALMU   \n",
       "1880449      ST-CACDF                ST/C&L                USCAVNC   \n",
       "1880450      ST-CACDF                ST/C&L                USCASCU   \n",
       "1880451      ST-CACDF                ST/C&L                USCAAEU   \n",
       "1880452      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880453      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880454      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880455      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880456      ST-CACDF                ST/C&L                USCATGU   \n",
       "1880457      ST-CACDF                ST/C&L                USCASHU   \n",
       "1880458      ST-CACDF                ST/C&L                USCAHUU   \n",
       "1880459      ST-CACDF                ST/C&L                USCALNU   \n",
       "1880460      ST-CACDF                ST/C&L                USCASHU   \n",
       "1880461      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880462      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880463      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880464      ST-CACDF                ST/C&L                USCABDU   \n",
       "\n",
       "                   NWCG_REPORTING_UNIT_NAME SOURCE_REPORTING_UNIT  \\\n",
       "0                    Plumas National Forest                  0511   \n",
       "1                  Eldorado National Forest                  0503   \n",
       "2                  Eldorado National Forest                  0503   \n",
       "3                  Eldorado National Forest                  0503   \n",
       "4                  Eldorado National Forest                  0503   \n",
       "5                  Eldorado National Forest                  0503   \n",
       "6                  Eldorado National Forest                  0503   \n",
       "7            Shasta-Trinity National Forest                  0514   \n",
       "8            Shasta-Trinity National Forest                  0514   \n",
       "9                  Eldorado National Forest                  0503   \n",
       "10                 Eldorado National Forest                  0503   \n",
       "11                 Eldorado National Forest                  0503   \n",
       "12                 Eldorado National Forest                  0503   \n",
       "13                 Eldorado National Forest                  0503   \n",
       "14                 Eldorado National Forest                  0503   \n",
       "15                 Eldorado National Forest                  0503   \n",
       "16                 Eldorado National Forest                  0503   \n",
       "17                 Eldorado National Forest                  0503   \n",
       "18                 Eldorado National Forest                  0503   \n",
       "19                  Lincoln National Forest                  0308   \n",
       "20                  Lincoln National Forest                  0308   \n",
       "21                  Lincoln National Forest                  0308   \n",
       "22                  Lincoln National Forest                  0308   \n",
       "23                  Lincoln National Forest                  0308   \n",
       "24                  Lincoln National Forest                  0308   \n",
       "25                  Lincoln National Forest                  0308   \n",
       "26                  Lincoln National Forest                  0308   \n",
       "27                  Lincoln National Forest                  0308   \n",
       "28                  Lincoln National Forest                  0308   \n",
       "29                  Lincoln National Forest                  0308   \n",
       "...                                     ...                   ...   \n",
       "1880435               Sonoma-Lake Napa Unit                 CALNU   \n",
       "1880436             Nevada-Yuba-Placer Unit                 CANEU   \n",
       "1880437             Humboldt-Del Norte Unit                 CAHUU   \n",
       "1880438             Nevada-Yuba-Placer Unit                 CANEU   \n",
       "1880439         Kern County Fire Department                 CAKRN   \n",
       "1880440  Los Angeles County Fire Department                 CALAC   \n",
       "1880441  Los Angeles County Fire Department                 CALAC   \n",
       "1880442           San Mateo-Santa Cruz Unit                 CACZU   \n",
       "1880443                   Lassen-Modoc Unit                 CALMU   \n",
       "1880444                    Santa Clara Unit                 CASCU   \n",
       "1880445                 San Bernardino Unit                 CABDU   \n",
       "1880446                 San Bernardino Unit                 CABDU   \n",
       "1880447                    Monte Vista Unit                 CAMVU   \n",
       "1880448                   Lassen-Modoc Unit                 CALMU   \n",
       "1880449      Ventura County Fire Department                 CAVNC   \n",
       "1880450                    Santa Clara Unit                 CASCU   \n",
       "1880451               Amador-El Dorado Unit                 CAAEU   \n",
       "1880452  Los Angeles County Fire Department                 CALAC   \n",
       "1880453  Los Angeles County Fire Department                 CALAC   \n",
       "1880454             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880455             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880456                   Tehama-Glenn Unit                 CATGU   \n",
       "1880457                 Shasta-Trinity Unit                 CASHU   \n",
       "1880458             Humboldt-Del Norte Unit                 CAHUU   \n",
       "1880459               Sonoma-Lake Napa Unit                 CALNU   \n",
       "1880460                 Shasta-Trinity Unit                 CASHU   \n",
       "1880461             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880462             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880463             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880464                 San Bernardino Unit                 CABDU   \n",
       "\n",
       "                 SOURCE_REPORTING_UNIT_NAME  ... FIRE_SIZE_CLASS   LATITUDE  \\\n",
       "0                    Plumas National Forest  ...               A  40.036944   \n",
       "1                  Eldorado National Forest  ...               A  38.933056   \n",
       "2                  Eldorado National Forest  ...               A  38.984167   \n",
       "3                  Eldorado National Forest  ...               A  38.559167   \n",
       "4                  Eldorado National Forest  ...               A  38.559167   \n",
       "5                  Eldorado National Forest  ...               A  38.635278   \n",
       "6                  Eldorado National Forest  ...               A  38.688333   \n",
       "7            Shasta-Trinity National Forest  ...               B  40.968056   \n",
       "8            Shasta-Trinity National Forest  ...               B  41.233611   \n",
       "9                  Eldorado National Forest  ...               A  38.548333   \n",
       "10                 Eldorado National Forest  ...               A  38.691667   \n",
       "11                 Eldorado National Forest  ...               A  38.527500   \n",
       "12                 Eldorado National Forest  ...               A  38.786667   \n",
       "13                 Eldorado National Forest  ...               B  38.433333   \n",
       "14                 Eldorado National Forest  ...               A  38.675833   \n",
       "15                 Eldorado National Forest  ...               A  38.564167   \n",
       "16                 Eldorado National Forest  ...               G  38.523333   \n",
       "17                 Eldorado National Forest  ...               G  38.780000   \n",
       "18                 Eldorado National Forest  ...               A  38.945000   \n",
       "19                  Lincoln National Forest  ...               A  33.440833   \n",
       "20                  Lincoln National Forest  ...               A  33.307222   \n",
       "21                  Lincoln National Forest  ...               A  33.444444   \n",
       "22                  Lincoln National Forest  ...               A  33.559444   \n",
       "23                  Lincoln National Forest  ...               A  33.308056   \n",
       "24                  Lincoln National Forest  ...               B  33.545278   \n",
       "25                  Lincoln National Forest  ...               C  33.315833   \n",
       "26                  Lincoln National Forest  ...               B  33.444444   \n",
       "27                  Lincoln National Forest  ...               A  33.368056   \n",
       "28                  Lincoln National Forest  ...               A  33.385278   \n",
       "29                  Lincoln National Forest  ...               A  33.382778   \n",
       "...                                     ...  ...             ...        ...   \n",
       "1880435               Sonoma-Lake Napa Unit  ...               A  38.159780   \n",
       "1880436             Nevada-Yuba-Placer Unit  ...               A  39.143821   \n",
       "1880437             Humboldt-Del Norte Unit  ...               A  41.224483   \n",
       "1880438             Nevada-Yuba-Placer Unit  ...               A  39.005712   \n",
       "1880439         Kern County Fire Department  ...               A  34.933333   \n",
       "1880440  Los Angeles County Fire Department  ...               A  34.716666   \n",
       "1880441  Los Angeles County Fire Department  ...               C  34.450000   \n",
       "1880442           San Mateo-Santa Cruz Unit  ...               B  37.090126   \n",
       "1880443                   Lassen-Modoc Unit  ...               A  40.297000   \n",
       "1880444                    Santa Clara Unit  ...               B  37.701111   \n",
       "1880445           CDF - San Bernardino Unit  ...               A  37.361417   \n",
       "1880446           CDF - San Bernardino Unit  ...               B  34.244444   \n",
       "1880447              CDF - Monte Vista Unit  ...               A  32.576754   \n",
       "1880448                   Lassen-Modoc Unit  ...               A  40.443000   \n",
       "1880449      Ventura County Fire Department  ...               B  34.666666   \n",
       "1880450                    Santa Clara Unit  ...               A  38.041150   \n",
       "1880451               Amador-El Dorado Unit  ...               B  38.644183   \n",
       "1880452  Los Angeles County Fire Department  ...               A  34.163117   \n",
       "1880453  Los Angeles County Fire Department  ...               A  34.278180   \n",
       "1880454             Tuolumne-Calaveras Unit  ...               B  38.048577   \n",
       "1880455             Tuolumne-Calaveras Unit  ...               B  37.936253   \n",
       "1880456                   Tehama-Glenn Unit  ...               B  40.019907   \n",
       "1880457                 Shasta-Trinity Unit  ...               B  40.588583   \n",
       "1880458             Humboldt-Del Norte Unit  ...               B  40.244833   \n",
       "1880459               Sonoma-Lake Napa Unit  ...               B  38.415608   \n",
       "1880460                 Shasta-Trinity Unit  ...               A  40.481637   \n",
       "1880461             Tuolumne-Calaveras Unit  ...               A  37.617619   \n",
       "1880462             Tuolumne-Calaveras Unit  ...               A  37.617619   \n",
       "1880463             Tuolumne-Calaveras Unit  ...               B  37.672235   \n",
       "1880464           CDF - San Bernardino Unit  ...               A  34.263217   \n",
       "\n",
       "          LONGITUDE OWNER_CODE            OWNER_DESCR STATE COUNTY FIPS_CODE  \\\n",
       "0       -121.005833        5.0                   USFS    CA     63       063   \n",
       "1       -120.404444        5.0                   USFS    CA     61       061   \n",
       "2       -120.735556       13.0       STATE OR PRIVATE    CA     17       017   \n",
       "3       -119.913333        5.0                   USFS    CA      3       003   \n",
       "4       -119.933056        5.0                   USFS    CA      3       003   \n",
       "5       -120.103611        5.0                   USFS    CA      5       005   \n",
       "6       -120.153333        5.0                   USFS    CA     17       017   \n",
       "7       -122.433889       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "8       -122.283333       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "9       -120.149167        5.0                   USFS    CA      5       005   \n",
       "10      -120.159722        5.0                   USFS    CA     17       017   \n",
       "11      -120.106111        5.0                   USFS    CA      5       005   \n",
       "12      -120.193333        5.0                   USFS    CA     17       017   \n",
       "13      -120.510000       14.0  MISSING/NOT SPECIFIED    CA      5       005   \n",
       "14      -120.279722        5.0                   USFS    CA     17       017   \n",
       "15      -120.542222        5.0                   USFS    CA     17       017   \n",
       "16      -120.211667        5.0                   USFS    CA      5       005   \n",
       "17      -120.260000        5.0                   USFS    CA     17       017   \n",
       "18      -120.411667       13.0       STATE OR PRIVATE    CA     17       017   \n",
       "19      -105.720556        5.0                   USFS    NM     27       027   \n",
       "20      -105.628611       13.0       STATE OR PRIVATE    NM     27       027   \n",
       "21      -105.768056        5.0                   USFS    NM     27       027   \n",
       "22      -105.766111        5.0                   USFS    NM     27       027   \n",
       "23      -105.526111        5.0                   USFS    NM     27       027   \n",
       "24      -105.229444        5.0                   USFS    NM     27       027   \n",
       "25      -105.512222        5.0                   USFS    NM     27       027   \n",
       "26      -105.631111       14.0  MISSING/NOT SPECIFIED    NM     27       027   \n",
       "27      -105.507222        5.0                   USFS    NM     27       027   \n",
       "28      -105.638611        5.0                   USFS    NM     27       027   \n",
       "29      -105.700278        5.0                   USFS    NM     27       027   \n",
       "...             ...        ...                    ...   ...    ...       ...   \n",
       "1880435 -122.451750       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880436 -121.036533       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880437 -123.763317       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880438 -121.260759       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880439 -118.883333       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880440 -118.800000       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880441 -118.583333       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880442 -122.074684       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880443 -120.528000       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880444 -122.021111       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880445 -118.465150       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880446 -116.658889       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880447 -116.627539       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880448 -120.664433       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880449 -119.333333       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880450 -121.985283       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880451 -120.863673       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880452 -118.693303       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880453 -118.621180       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880454 -120.313090       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880455 -120.613743       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880456 -122.391398       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880457 -123.069617       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880458 -123.544167       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880459 -122.660044       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880460 -122.389375       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880461 -120.938570       12.0        MUNICIPAL/LOCAL    CA   None      None   \n",
       "1880462 -120.938570       12.0        MUNICIPAL/LOCAL    CA   None      None   \n",
       "1880463 -120.898356       12.0        MUNICIPAL/LOCAL    CA   None      None   \n",
       "1880464 -116.830950       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "\n",
       "         FIPS_NAME                                              Shape  \n",
       "0           Plumas  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...  \n",
       "1           Placer  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...  \n",
       "2        El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...  \n",
       "3           Alpine  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...  \n",
       "4           Alpine  b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...  \n",
       "5           Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0<~\\x90\\xa1\\x06^\\...  \n",
       "6        El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00$o\\x996\\xd0\\t^\\xc0h\\...  \n",
       "7             None  b'\\x00\\x01\\xad\\x10\\x00\\x00t)\\xe8\\xd5\\xc4\\x9b^\\...  \n",
       "8             None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xdc\\x8d\\x1e\"\"\\x92^\\...  \n",
       "9           Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\t^\\xc0\\...  \n",
       "10       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x0c\\xd6\\x8b\\xe38\\n^...  \n",
       "11          Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00L\\xcc@\\x86\\xca\\x06^\\...  \n",
       "12       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_\\x0c^\\...  \n",
       "13          Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3 ^\\xc0\\x...  \n",
       "14       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb7\\x06\\xf8\\xe6\\x1...  \n",
       "15       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x84\\xd3\\xc4\\xb3\"^\\...  \n",
       "16          Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\r^\\xc0\\...  \n",
       "17       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3\\x10^\\xc...  \n",
       "18       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x004 )\\xbfX\\x1a^\\xc00\\\\...  \n",
       "19         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xa8I\\x11\\x95\\x1dnZ\\...  \n",
       "20         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x88\\xd6\\x17*;hZ\\xc0...  \n",
       "21         Lincoln  b\"\\x00\\x01\\xad\\x10\\x00\\x00|\\xed\\x81\\xd2'qZ\\xc0...  \n",
       "22         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xa3\\xe4\\xf6\\x07qZ\\...  \n",
       "23         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xe0\\xee\\xcd\\xab...  \n",
       "24         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x83\\xbb7\\xafNZ\\xc0...  \n",
       "25         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xcc\\xcb\\xb4?\\xc8`Z\\...  \n",
       "26         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe4e\\xda\\x1fdhZ\\xc0...  \n",
       "27         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x14\\xad/Tv`Z\\xc0\\xd...  \n",
       "28         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf8\\x13\"\\x01\\xdfhZ\\...  \n",
       "29         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xcd\\xe4Y\\xd1lZ\\...  \n",
       "...            ...                                                ...  \n",
       "1880435       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0\\xfd\\xd4x\\xe9\\x9...  \n",
       "1880436       None  b'\\x00\\x01\\xad\\x10\\x00\\x00`\\x0e\\x82\\x8eVB^\\xc0...  \n",
       "1880437       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc4\\xde\\x8b/\\xda\\xf...  \n",
       "1880438       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xccH\\x84F\\xb0P^\\xc0...  \n",
       "1880439       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x90\\x9e\"\\x87\\x88\\xb...  \n",
       "1880440       None  b'\\x00\\x01\\xad\\x10\\x00\\x0003333\\xb3]\\xc0\\xe0\\x...  \n",
       "1880441       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xa5]\\xc0\\x...  \n",
       "1880442       None  b'\\x00\\x01\\xad\\x10\\x00\\x004bf\\x9f\\xc7\\x84^\\xc0...  \n",
       "1880443       None  b'\\x00\\x01\\xad\\x10\\x00\\x00l\\x12\\x83\\xc0\\xca!^\\...  \n",
       "1880444       None  b'\\x00\\x01\\xad\\x10\\x00\\x00|\\xa5\\xf3\\xe1Y\\x81^\\...  \n",
       "1880445       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00o\\x81\\x04\\xc5\\x9...  \n",
       "1880446       None  b'\\x00\\x01\\xad\\x10\\x00\\x00l\\xac\\xc4<+*]\\xc0\\x1...  \n",
       "1880447       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8}V\\x99)(]\\xc00\\x...  \n",
       "1880448       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84X\\xfd\\x11\\x86*^\\...  \n",
       "1880449       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xd5]\\xc0\\x...  \n",
       "1880450       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x80\\x93m\\xe0\\x0e\\x7...  \n",
       "1880451       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\\\\\x1ekF7^\\xc0\\x...  \n",
       "1880452       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0A\\t\\x12_\\xac]\\xc...  \n",
       "1880453       None  b'\\x00\\x01\\xad\\x10\\x00\\x00h\\x0c\\xdfg\\xc1\\xa7]\\...  \n",
       "1880454       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x18\\xad\\xa3\\xaa\\t\\x...  \n",
       "1880455       None  b\"\\x00\\x01\\xad\\x10\\x00\\x00\\x84I\\xb8\\x90G'^\\xc0...  \n",
       "1880456       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x10n2\\xaa\\x0c\\x99^\\...  \n",
       "1880457       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8\\x8f\\xdc\\x9at\\xc...  \n",
       "1880458       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xfc#\\xd3\\xa1\\xd3\\xe...  \n",
       "1880459       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0z0)>\\xaa^\\xc0h\\x...  \n",
       "1880460       None  b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x9...  \n",
       "1880461       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...  \n",
       "1880462       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...  \n",
       "1880463       None  b'\\x00\\x01\\xad\\x10\\x00\\x00x\\xba_\\xaa~9^\\xc0\\xb...  \n",
       "1880464       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x1c\\xa7\\xe8H.5]\\xc0...  \n",
       "\n",
       "[1880465 rows x 39 columns]"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "station_df = pd.read_sql_query(\"\"\"SELECT * FROM station_data WHERE state='CA'\"\"\", conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_closest_station(row):\n",
    "#     print(row[['LATITUDE', 'LONGITUDE']])\n",
    "    coords = np.array(row[['LATITUDE', 'LONGITUDE']]) ** 2\n",
    "#     print(coords)\n",
    "#     print((station_df[['lat', 'lon']]).pow(2) - coords)\n",
    "    idx = ((station_df[['lat', 'lon']]).pow(2) - coords).apply(np.linalg.norm, axis=1).idxmin()\n",
    "#     print(idx)\n",
    "    return station_df.loc[idx]['usaf']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 309,
   "metadata": {
    "scrolled": true
   },
   "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>OBJECTID</th>\n",
       "      <th>FOD_ID</th>\n",
       "      <th>FPA_ID</th>\n",
       "      <th>SOURCE_SYSTEM_TYPE</th>\n",
       "      <th>SOURCE_SYSTEM</th>\n",
       "      <th>NWCG_REPORTING_AGENCY</th>\n",
       "      <th>NWCG_REPORTING_UNIT_ID</th>\n",
       "      <th>NWCG_REPORTING_UNIT_NAME</th>\n",
       "      <th>SOURCE_REPORTING_UNIT</th>\n",
       "      <th>SOURCE_REPORTING_UNIT_NAME</th>\n",
       "      <th>...</th>\n",
       "      <th>FIRE_SIZE_CLASS</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>OWNER_CODE</th>\n",
       "      <th>OWNER_DESCR</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>FIPS_CODE</th>\n",
       "      <th>FIPS_NAME</th>\n",
       "      <th>Shape</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>FS-1418826</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAPNF</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>0511</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.036944</td>\n",
       "      <td>-121.005833</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>63</td>\n",
       "      <td>063</td>\n",
       "      <td>Plumas</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>FS-1418827</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.933056</td>\n",
       "      <td>-120.404444</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>61</td>\n",
       "      <td>061</td>\n",
       "      <td>Placer</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>FS-1418835</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.984167</td>\n",
       "      <td>-120.735556</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>FS-1418845</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.559167</td>\n",
       "      <td>-119.913333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>003</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>FS-1418847</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.559167</td>\n",
       "      <td>-119.933056</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>003</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>FS-1418849</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.635278</td>\n",
       "      <td>-120.103611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0&lt;~\\x90\\xa1\\x06^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>FS-1418851</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.688333</td>\n",
       "      <td>-120.153333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00$o\\x996\\xd0\\t^\\xc0h\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>FS-1418854</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCASHF</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>0514</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.968056</td>\n",
       "      <td>-122.433889</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00t)\\xe8\\xd5\\xc4\\x9b^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>FS-1418856</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCASHF</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>0514</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>41.233611</td>\n",
       "      <td>-122.283333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xdc\\x8d\\x1e\"\"\\x92^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>FS-1418859</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.548333</td>\n",
       "      <td>-120.149167</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\t^\\xc0\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>FS-1418861</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.691667</td>\n",
       "      <td>-120.159722</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x0c\\xd6\\x8b\\xe38\\n^...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>FS-1418863</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.527500</td>\n",
       "      <td>-120.106111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00L\\xcc@\\x86\\xca\\x06^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>FS-1418865</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.786667</td>\n",
       "      <td>-120.193333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_\\x0c^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>FS-1418872</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.433333</td>\n",
       "      <td>-120.510000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3 ^\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>FS-1418874</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.675833</td>\n",
       "      <td>-120.279722</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb7\\x06\\xf8\\xe6\\x1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>FS-1418876</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.564167</td>\n",
       "      <td>-120.542222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x84\\xd3\\xc4\\xb3\"^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>FS-1418878</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>G</td>\n",
       "      <td>38.523333</td>\n",
       "      <td>-120.211667</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\r^\\xc0\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>FS-1418881</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>G</td>\n",
       "      <td>38.780000</td>\n",
       "      <td>-120.260000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3\\x10^\\xc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>FS-1418884</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.945000</td>\n",
       "      <td>-120.411667</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x004 )\\xbfX\\x1a^\\xc00\\\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>FS-1418887</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.440833</td>\n",
       "      <td>-105.720556</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xa8I\\x11\\x95\\x1dnZ\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>FS-1418888</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.307222</td>\n",
       "      <td>-105.628611</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x88\\xd6\\x17*;hZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>FS-1418893</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.444444</td>\n",
       "      <td>-105.768056</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b\"\\x00\\x01\\xad\\x10\\x00\\x00|\\xed\\x81\\xd2'qZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>FS-1418894</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.559444</td>\n",
       "      <td>-105.766111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xa3\\xe4\\xf6\\x07qZ\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>FS-1418895</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.308056</td>\n",
       "      <td>-105.526111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xe0\\xee\\xcd\\xab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>FS-1418896</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>33.545278</td>\n",
       "      <td>-105.229444</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x83\\xbb7\\xafNZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>FS-1418897</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>C</td>\n",
       "      <td>33.315833</td>\n",
       "      <td>-105.512222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xcc\\xcb\\xb4?\\xc8`Z\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>FS-1418898</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>33.444444</td>\n",
       "      <td>-105.631111</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe4e\\xda\\x1fdhZ\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>FS-1418903</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.368056</td>\n",
       "      <td>-105.507222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x14\\xad/Tv`Z\\xc0\\xd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>FS-1418904</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.385278</td>\n",
       "      <td>-105.638611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf8\\x13\"\\x01\\xdfhZ\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>FS-1418905</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>33.382778</td>\n",
       "      <td>-105.700278</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xcd\\xe4Y\\xd1lZ\\...</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>1880435</th>\n",
       "      <td>1880436</td>\n",
       "      <td>300348217</td>\n",
       "      <td>2015CAIRS28664200</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>CALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.159780</td>\n",
       "      <td>-122.451750</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0\\xfd\\xd4x\\xe9\\x9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880436</th>\n",
       "      <td>1880437</td>\n",
       "      <td>300348237</td>\n",
       "      <td>2015CAIRS26850166</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>CANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>39.143821</td>\n",
       "      <td>-121.036533</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00`\\x0e\\x82\\x8eVB^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880437</th>\n",
       "      <td>1880438</td>\n",
       "      <td>300348240</td>\n",
       "      <td>2015CAIRS27248589</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>CAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>41.224483</td>\n",
       "      <td>-123.763317</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc4\\xde\\x8b/\\xda\\xf...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880438</th>\n",
       "      <td>1880439</td>\n",
       "      <td>300348242</td>\n",
       "      <td>2015CAIRS29017324</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>CANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>39.005712</td>\n",
       "      <td>-121.260759</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xccH\\x84F\\xb0P^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880439</th>\n",
       "      <td>1880440</td>\n",
       "      <td>300348247</td>\n",
       "      <td>2015CAIRS27699480</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAKRN</td>\n",
       "      <td>Kern County Fire Department</td>\n",
       "      <td>CAKRN</td>\n",
       "      <td>Kern County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.933333</td>\n",
       "      <td>-118.883333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x90\\x9e\"\\x87\\x88\\xb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880440</th>\n",
       "      <td>1880441</td>\n",
       "      <td>300348248</td>\n",
       "      <td>2015CAIRS28587133</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.716666</td>\n",
       "      <td>-118.800000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x0003333\\xb3]\\xc0\\xe0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880441</th>\n",
       "      <td>1880442</td>\n",
       "      <td>300348249</td>\n",
       "      <td>2015CAIRS29152556</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>C</td>\n",
       "      <td>34.450000</td>\n",
       "      <td>-118.583333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xa5]\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880442</th>\n",
       "      <td>1880443</td>\n",
       "      <td>300348255</td>\n",
       "      <td>2015CAIRS26850725</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCACZU</td>\n",
       "      <td>San Mateo-Santa Cruz Unit</td>\n",
       "      <td>CACZU</td>\n",
       "      <td>San Mateo-Santa Cruz Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.090126</td>\n",
       "      <td>-122.074684</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x004bf\\x9f\\xc7\\x84^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880443</th>\n",
       "      <td>1880444</td>\n",
       "      <td>300348257</td>\n",
       "      <td>2015CAIRS28268055</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>CALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.297000</td>\n",
       "      <td>-120.528000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00l\\x12\\x83\\xc0\\xca!^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880444</th>\n",
       "      <td>1880445</td>\n",
       "      <td>300348258</td>\n",
       "      <td>2015CAIRS28291406</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>CASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.701111</td>\n",
       "      <td>-122.021111</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00|\\xa5\\xf3\\xe1Y\\x81^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880445</th>\n",
       "      <td>1880446</td>\n",
       "      <td>300348259</td>\n",
       "      <td>2015CAIRS27092196</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>37.361417</td>\n",
       "      <td>-118.465150</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00o\\x81\\x04\\xc5\\x9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880446</th>\n",
       "      <td>1880447</td>\n",
       "      <td>300348260</td>\n",
       "      <td>2015CAIRS29015247</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>34.244444</td>\n",
       "      <td>-116.658889</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00l\\xac\\xc4&lt;+*]\\xc0\\x1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880447</th>\n",
       "      <td>1880448</td>\n",
       "      <td>300348274</td>\n",
       "      <td>2015CAIRS26084391</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAMVU</td>\n",
       "      <td>Monte Vista Unit</td>\n",
       "      <td>CAMVU</td>\n",
       "      <td>CDF - Monte Vista Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>32.576754</td>\n",
       "      <td>-116.627539</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8}V\\x99)(]\\xc00\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880448</th>\n",
       "      <td>1880449</td>\n",
       "      <td>300348276</td>\n",
       "      <td>2015CAIRS27560317</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>CALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.443000</td>\n",
       "      <td>-120.664433</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84X\\xfd\\x11\\x86*^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880449</th>\n",
       "      <td>1880450</td>\n",
       "      <td>300348289</td>\n",
       "      <td>2015CAIRS28493610</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAVNC</td>\n",
       "      <td>Ventura County Fire Department</td>\n",
       "      <td>CAVNC</td>\n",
       "      <td>Ventura County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>34.666666</td>\n",
       "      <td>-119.333333</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xd5]\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880450</th>\n",
       "      <td>1880451</td>\n",
       "      <td>300348290</td>\n",
       "      <td>2015CAIRS27653046</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>CASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>38.041150</td>\n",
       "      <td>-121.985283</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x80\\x93m\\xe0\\x0e\\x7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880451</th>\n",
       "      <td>1880452</td>\n",
       "      <td>300348291</td>\n",
       "      <td>2015CAIRS27458005</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAAEU</td>\n",
       "      <td>Amador-El Dorado Unit</td>\n",
       "      <td>CAAEU</td>\n",
       "      <td>Amador-El Dorado Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.644183</td>\n",
       "      <td>-120.863673</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\\\\\x1ekF7^\\xc0\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880452</th>\n",
       "      <td>1880453</td>\n",
       "      <td>300348293</td>\n",
       "      <td>2015CAIRS27587395</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.163117</td>\n",
       "      <td>-118.693303</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0A\\t\\x12_\\xac]\\xc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880453</th>\n",
       "      <td>1880454</td>\n",
       "      <td>300348297</td>\n",
       "      <td>2015CAIRS28589435</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.278180</td>\n",
       "      <td>-118.621180</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00h\\x0c\\xdfg\\xc1\\xa7]\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880454</th>\n",
       "      <td>1880455</td>\n",
       "      <td>300348310</td>\n",
       "      <td>2015CAIRS28424493</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.048577</td>\n",
       "      <td>-120.313090</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x18\\xad\\xa3\\xaa\\t\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880455</th>\n",
       "      <td>1880456</td>\n",
       "      <td>300348311</td>\n",
       "      <td>2015CAIRS27458827</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.936253</td>\n",
       "      <td>-120.613743</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b\"\\x00\\x01\\xad\\x10\\x00\\x00\\x84I\\xb8\\x90G'^\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880456</th>\n",
       "      <td>1880457</td>\n",
       "      <td>300348328</td>\n",
       "      <td>2015CAIRS27369138</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATGU</td>\n",
       "      <td>Tehama-Glenn Unit</td>\n",
       "      <td>CATGU</td>\n",
       "      <td>Tehama-Glenn Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.019907</td>\n",
       "      <td>-122.391398</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x10n2\\xaa\\x0c\\x99^\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880457</th>\n",
       "      <td>1880458</td>\n",
       "      <td>300348354</td>\n",
       "      <td>2015CAIRS28234594</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>CASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.588583</td>\n",
       "      <td>-123.069617</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8\\x8f\\xdc\\x9at\\xc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880458</th>\n",
       "      <td>1880459</td>\n",
       "      <td>300348361</td>\n",
       "      <td>2015CAIRS27957490</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>CAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>40.244833</td>\n",
       "      <td>-123.544167</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xfc#\\xd3\\xa1\\xd3\\xe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880459</th>\n",
       "      <td>1880460</td>\n",
       "      <td>300348362</td>\n",
       "      <td>2015CAIRS28291374</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>CALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>38.415608</td>\n",
       "      <td>-122.660044</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0z0)&gt;\\xaa^\\xc0h\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880460</th>\n",
       "      <td>1880461</td>\n",
       "      <td>300348363</td>\n",
       "      <td>2015CAIRS29019636</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>CASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>40.481637</td>\n",
       "      <td>-122.389375</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880461</th>\n",
       "      <td>1880462</td>\n",
       "      <td>300348373</td>\n",
       "      <td>2015CAIRS29217935</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>37.617619</td>\n",
       "      <td>-120.938570</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880462</th>\n",
       "      <td>1880463</td>\n",
       "      <td>300348375</td>\n",
       "      <td>2015CAIRS28364460</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>37.617619</td>\n",
       "      <td>-120.938570</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880463</th>\n",
       "      <td>1880464</td>\n",
       "      <td>300348377</td>\n",
       "      <td>2015CAIRS29218079</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>37.672235</td>\n",
       "      <td>-120.898356</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00x\\xba_\\xaa~9^\\xc0\\xb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880464</th>\n",
       "      <td>1880465</td>\n",
       "      <td>300348399</td>\n",
       "      <td>2015CAIRS26733926</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>34.263217</td>\n",
       "      <td>-116.830950</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x1c\\xa7\\xe8H.5]\\xc0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1880465 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         OBJECTID     FOD_ID             FPA_ID SOURCE_SYSTEM_TYPE  \\\n",
       "0               1          1         FS-1418826                FED   \n",
       "1               2          2         FS-1418827                FED   \n",
       "2               3          3         FS-1418835                FED   \n",
       "3               4          4         FS-1418845                FED   \n",
       "4               5          5         FS-1418847                FED   \n",
       "5               6          6         FS-1418849                FED   \n",
       "6               7          7         FS-1418851                FED   \n",
       "7               8          8         FS-1418854                FED   \n",
       "8               9          9         FS-1418856                FED   \n",
       "9              10         10         FS-1418859                FED   \n",
       "10             11         11         FS-1418861                FED   \n",
       "11             12         12         FS-1418863                FED   \n",
       "12             13         13         FS-1418865                FED   \n",
       "13             14         14         FS-1418872                FED   \n",
       "14             15         15         FS-1418874                FED   \n",
       "15             16         16         FS-1418876                FED   \n",
       "16             17         17         FS-1418878                FED   \n",
       "17             18         18         FS-1418881                FED   \n",
       "18             19         19         FS-1418884                FED   \n",
       "19             20         20         FS-1418887                FED   \n",
       "20             21         21         FS-1418888                FED   \n",
       "21             22         22         FS-1418893                FED   \n",
       "22             23         23         FS-1418894                FED   \n",
       "23             24         24         FS-1418895                FED   \n",
       "24             25         25         FS-1418896                FED   \n",
       "25             26         26         FS-1418897                FED   \n",
       "26             27         27         FS-1418898                FED   \n",
       "27             28         28         FS-1418903                FED   \n",
       "28             29         29         FS-1418904                FED   \n",
       "29             30         30         FS-1418905                FED   \n",
       "...           ...        ...                ...                ...   \n",
       "1880435   1880436  300348217  2015CAIRS28664200             NONFED   \n",
       "1880436   1880437  300348237  2015CAIRS26850166             NONFED   \n",
       "1880437   1880438  300348240  2015CAIRS27248589             NONFED   \n",
       "1880438   1880439  300348242  2015CAIRS29017324             NONFED   \n",
       "1880439   1880440  300348247  2015CAIRS27699480             NONFED   \n",
       "1880440   1880441  300348248  2015CAIRS28587133             NONFED   \n",
       "1880441   1880442  300348249  2015CAIRS29152556             NONFED   \n",
       "1880442   1880443  300348255  2015CAIRS26850725             NONFED   \n",
       "1880443   1880444  300348257  2015CAIRS28268055             NONFED   \n",
       "1880444   1880445  300348258  2015CAIRS28291406             NONFED   \n",
       "1880445   1880446  300348259  2015CAIRS27092196             NONFED   \n",
       "1880446   1880447  300348260  2015CAIRS29015247             NONFED   \n",
       "1880447   1880448  300348274  2015CAIRS26084391             NONFED   \n",
       "1880448   1880449  300348276  2015CAIRS27560317             NONFED   \n",
       "1880449   1880450  300348289  2015CAIRS28493610             NONFED   \n",
       "1880450   1880451  300348290  2015CAIRS27653046             NONFED   \n",
       "1880451   1880452  300348291  2015CAIRS27458005             NONFED   \n",
       "1880452   1880453  300348293  2015CAIRS27587395             NONFED   \n",
       "1880453   1880454  300348297  2015CAIRS28589435             NONFED   \n",
       "1880454   1880455  300348310  2015CAIRS28424493             NONFED   \n",
       "1880455   1880456  300348311  2015CAIRS27458827             NONFED   \n",
       "1880456   1880457  300348328  2015CAIRS27369138             NONFED   \n",
       "1880457   1880458  300348354  2015CAIRS28234594             NONFED   \n",
       "1880458   1880459  300348361  2015CAIRS27957490             NONFED   \n",
       "1880459   1880460  300348362  2015CAIRS28291374             NONFED   \n",
       "1880460   1880461  300348363  2015CAIRS29019636             NONFED   \n",
       "1880461   1880462  300348373  2015CAIRS29217935             NONFED   \n",
       "1880462   1880463  300348375  2015CAIRS28364460             NONFED   \n",
       "1880463   1880464  300348377  2015CAIRS29218079             NONFED   \n",
       "1880464   1880465  300348399  2015CAIRS26733926             NONFED   \n",
       "\n",
       "        SOURCE_SYSTEM NWCG_REPORTING_AGENCY NWCG_REPORTING_UNIT_ID  \\\n",
       "0         FS-FIRESTAT                    FS                USCAPNF   \n",
       "1         FS-FIRESTAT                    FS                USCAENF   \n",
       "2         FS-FIRESTAT                    FS                USCAENF   \n",
       "3         FS-FIRESTAT                    FS                USCAENF   \n",
       "4         FS-FIRESTAT                    FS                USCAENF   \n",
       "5         FS-FIRESTAT                    FS                USCAENF   \n",
       "6         FS-FIRESTAT                    FS                USCAENF   \n",
       "7         FS-FIRESTAT                    FS                USCASHF   \n",
       "8         FS-FIRESTAT                    FS                USCASHF   \n",
       "9         FS-FIRESTAT                    FS                USCAENF   \n",
       "10        FS-FIRESTAT                    FS                USCAENF   \n",
       "11        FS-FIRESTAT                    FS                USCAENF   \n",
       "12        FS-FIRESTAT                    FS                USCAENF   \n",
       "13        FS-FIRESTAT                    FS                USCAENF   \n",
       "14        FS-FIRESTAT                    FS                USCAENF   \n",
       "15        FS-FIRESTAT                    FS                USCAENF   \n",
       "16        FS-FIRESTAT                    FS                USCAENF   \n",
       "17        FS-FIRESTAT                    FS                USCAENF   \n",
       "18        FS-FIRESTAT                    FS                USCAENF   \n",
       "19        FS-FIRESTAT                    FS                USNMLNF   \n",
       "20        FS-FIRESTAT                    FS                USNMLNF   \n",
       "21        FS-FIRESTAT                    FS                USNMLNF   \n",
       "22        FS-FIRESTAT                    FS                USNMLNF   \n",
       "23        FS-FIRESTAT                    FS                USNMLNF   \n",
       "24        FS-FIRESTAT                    FS                USNMLNF   \n",
       "25        FS-FIRESTAT                    FS                USNMLNF   \n",
       "26        FS-FIRESTAT                    FS                USNMLNF   \n",
       "27        FS-FIRESTAT                    FS                USNMLNF   \n",
       "28        FS-FIRESTAT                    FS                USNMLNF   \n",
       "29        FS-FIRESTAT                    FS                USNMLNF   \n",
       "...               ...                   ...                    ...   \n",
       "1880435      ST-CACDF                ST/C&L                USCALNU   \n",
       "1880436      ST-CACDF                ST/C&L                USCANEU   \n",
       "1880437      ST-CACDF                ST/C&L                USCAHUU   \n",
       "1880438      ST-CACDF                ST/C&L                USCANEU   \n",
       "1880439      ST-CACDF                ST/C&L                USCAKRN   \n",
       "1880440      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880441      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880442      ST-CACDF                ST/C&L                USCACZU   \n",
       "1880443      ST-CACDF                ST/C&L                USCALMU   \n",
       "1880444      ST-CACDF                ST/C&L                USCASCU   \n",
       "1880445      ST-CACDF                ST/C&L                USCABDU   \n",
       "1880446      ST-CACDF                ST/C&L                USCABDU   \n",
       "1880447      ST-CACDF                ST/C&L                USCAMVU   \n",
       "1880448      ST-CACDF                ST/C&L                USCALMU   \n",
       "1880449      ST-CACDF                ST/C&L                USCAVNC   \n",
       "1880450      ST-CACDF                ST/C&L                USCASCU   \n",
       "1880451      ST-CACDF                ST/C&L                USCAAEU   \n",
       "1880452      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880453      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880454      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880455      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880456      ST-CACDF                ST/C&L                USCATGU   \n",
       "1880457      ST-CACDF                ST/C&L                USCASHU   \n",
       "1880458      ST-CACDF                ST/C&L                USCAHUU   \n",
       "1880459      ST-CACDF                ST/C&L                USCALNU   \n",
       "1880460      ST-CACDF                ST/C&L                USCASHU   \n",
       "1880461      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880462      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880463      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880464      ST-CACDF                ST/C&L                USCABDU   \n",
       "\n",
       "                   NWCG_REPORTING_UNIT_NAME SOURCE_REPORTING_UNIT  \\\n",
       "0                    Plumas National Forest                  0511   \n",
       "1                  Eldorado National Forest                  0503   \n",
       "2                  Eldorado National Forest                  0503   \n",
       "3                  Eldorado National Forest                  0503   \n",
       "4                  Eldorado National Forest                  0503   \n",
       "5                  Eldorado National Forest                  0503   \n",
       "6                  Eldorado National Forest                  0503   \n",
       "7            Shasta-Trinity National Forest                  0514   \n",
       "8            Shasta-Trinity National Forest                  0514   \n",
       "9                  Eldorado National Forest                  0503   \n",
       "10                 Eldorado National Forest                  0503   \n",
       "11                 Eldorado National Forest                  0503   \n",
       "12                 Eldorado National Forest                  0503   \n",
       "13                 Eldorado National Forest                  0503   \n",
       "14                 Eldorado National Forest                  0503   \n",
       "15                 Eldorado National Forest                  0503   \n",
       "16                 Eldorado National Forest                  0503   \n",
       "17                 Eldorado National Forest                  0503   \n",
       "18                 Eldorado National Forest                  0503   \n",
       "19                  Lincoln National Forest                  0308   \n",
       "20                  Lincoln National Forest                  0308   \n",
       "21                  Lincoln National Forest                  0308   \n",
       "22                  Lincoln National Forest                  0308   \n",
       "23                  Lincoln National Forest                  0308   \n",
       "24                  Lincoln National Forest                  0308   \n",
       "25                  Lincoln National Forest                  0308   \n",
       "26                  Lincoln National Forest                  0308   \n",
       "27                  Lincoln National Forest                  0308   \n",
       "28                  Lincoln National Forest                  0308   \n",
       "29                  Lincoln National Forest                  0308   \n",
       "...                                     ...                   ...   \n",
       "1880435               Sonoma-Lake Napa Unit                 CALNU   \n",
       "1880436             Nevada-Yuba-Placer Unit                 CANEU   \n",
       "1880437             Humboldt-Del Norte Unit                 CAHUU   \n",
       "1880438             Nevada-Yuba-Placer Unit                 CANEU   \n",
       "1880439         Kern County Fire Department                 CAKRN   \n",
       "1880440  Los Angeles County Fire Department                 CALAC   \n",
       "1880441  Los Angeles County Fire Department                 CALAC   \n",
       "1880442           San Mateo-Santa Cruz Unit                 CACZU   \n",
       "1880443                   Lassen-Modoc Unit                 CALMU   \n",
       "1880444                    Santa Clara Unit                 CASCU   \n",
       "1880445                 San Bernardino Unit                 CABDU   \n",
       "1880446                 San Bernardino Unit                 CABDU   \n",
       "1880447                    Monte Vista Unit                 CAMVU   \n",
       "1880448                   Lassen-Modoc Unit                 CALMU   \n",
       "1880449      Ventura County Fire Department                 CAVNC   \n",
       "1880450                    Santa Clara Unit                 CASCU   \n",
       "1880451               Amador-El Dorado Unit                 CAAEU   \n",
       "1880452  Los Angeles County Fire Department                 CALAC   \n",
       "1880453  Los Angeles County Fire Department                 CALAC   \n",
       "1880454             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880455             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880456                   Tehama-Glenn Unit                 CATGU   \n",
       "1880457                 Shasta-Trinity Unit                 CASHU   \n",
       "1880458             Humboldt-Del Norte Unit                 CAHUU   \n",
       "1880459               Sonoma-Lake Napa Unit                 CALNU   \n",
       "1880460                 Shasta-Trinity Unit                 CASHU   \n",
       "1880461             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880462             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880463             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880464                 San Bernardino Unit                 CABDU   \n",
       "\n",
       "                 SOURCE_REPORTING_UNIT_NAME  ... FIRE_SIZE_CLASS   LATITUDE  \\\n",
       "0                    Plumas National Forest  ...               A  40.036944   \n",
       "1                  Eldorado National Forest  ...               A  38.933056   \n",
       "2                  Eldorado National Forest  ...               A  38.984167   \n",
       "3                  Eldorado National Forest  ...               A  38.559167   \n",
       "4                  Eldorado National Forest  ...               A  38.559167   \n",
       "5                  Eldorado National Forest  ...               A  38.635278   \n",
       "6                  Eldorado National Forest  ...               A  38.688333   \n",
       "7            Shasta-Trinity National Forest  ...               B  40.968056   \n",
       "8            Shasta-Trinity National Forest  ...               B  41.233611   \n",
       "9                  Eldorado National Forest  ...               A  38.548333   \n",
       "10                 Eldorado National Forest  ...               A  38.691667   \n",
       "11                 Eldorado National Forest  ...               A  38.527500   \n",
       "12                 Eldorado National Forest  ...               A  38.786667   \n",
       "13                 Eldorado National Forest  ...               B  38.433333   \n",
       "14                 Eldorado National Forest  ...               A  38.675833   \n",
       "15                 Eldorado National Forest  ...               A  38.564167   \n",
       "16                 Eldorado National Forest  ...               G  38.523333   \n",
       "17                 Eldorado National Forest  ...               G  38.780000   \n",
       "18                 Eldorado National Forest  ...               A  38.945000   \n",
       "19                  Lincoln National Forest  ...               A  33.440833   \n",
       "20                  Lincoln National Forest  ...               A  33.307222   \n",
       "21                  Lincoln National Forest  ...               A  33.444444   \n",
       "22                  Lincoln National Forest  ...               A  33.559444   \n",
       "23                  Lincoln National Forest  ...               A  33.308056   \n",
       "24                  Lincoln National Forest  ...               B  33.545278   \n",
       "25                  Lincoln National Forest  ...               C  33.315833   \n",
       "26                  Lincoln National Forest  ...               B  33.444444   \n",
       "27                  Lincoln National Forest  ...               A  33.368056   \n",
       "28                  Lincoln National Forest  ...               A  33.385278   \n",
       "29                  Lincoln National Forest  ...               A  33.382778   \n",
       "...                                     ...  ...             ...        ...   \n",
       "1880435               Sonoma-Lake Napa Unit  ...               A  38.159780   \n",
       "1880436             Nevada-Yuba-Placer Unit  ...               A  39.143821   \n",
       "1880437             Humboldt-Del Norte Unit  ...               A  41.224483   \n",
       "1880438             Nevada-Yuba-Placer Unit  ...               A  39.005712   \n",
       "1880439         Kern County Fire Department  ...               A  34.933333   \n",
       "1880440  Los Angeles County Fire Department  ...               A  34.716666   \n",
       "1880441  Los Angeles County Fire Department  ...               C  34.450000   \n",
       "1880442           San Mateo-Santa Cruz Unit  ...               B  37.090126   \n",
       "1880443                   Lassen-Modoc Unit  ...               A  40.297000   \n",
       "1880444                    Santa Clara Unit  ...               B  37.701111   \n",
       "1880445           CDF - San Bernardino Unit  ...               A  37.361417   \n",
       "1880446           CDF - San Bernardino Unit  ...               B  34.244444   \n",
       "1880447              CDF - Monte Vista Unit  ...               A  32.576754   \n",
       "1880448                   Lassen-Modoc Unit  ...               A  40.443000   \n",
       "1880449      Ventura County Fire Department  ...               B  34.666666   \n",
       "1880450                    Santa Clara Unit  ...               A  38.041150   \n",
       "1880451               Amador-El Dorado Unit  ...               B  38.644183   \n",
       "1880452  Los Angeles County Fire Department  ...               A  34.163117   \n",
       "1880453  Los Angeles County Fire Department  ...               A  34.278180   \n",
       "1880454             Tuolumne-Calaveras Unit  ...               B  38.048577   \n",
       "1880455             Tuolumne-Calaveras Unit  ...               B  37.936253   \n",
       "1880456                   Tehama-Glenn Unit  ...               B  40.019907   \n",
       "1880457                 Shasta-Trinity Unit  ...               B  40.588583   \n",
       "1880458             Humboldt-Del Norte Unit  ...               B  40.244833   \n",
       "1880459               Sonoma-Lake Napa Unit  ...               B  38.415608   \n",
       "1880460                 Shasta-Trinity Unit  ...               A  40.481637   \n",
       "1880461             Tuolumne-Calaveras Unit  ...               A  37.617619   \n",
       "1880462             Tuolumne-Calaveras Unit  ...               A  37.617619   \n",
       "1880463             Tuolumne-Calaveras Unit  ...               B  37.672235   \n",
       "1880464           CDF - San Bernardino Unit  ...               A  34.263217   \n",
       "\n",
       "          LONGITUDE OWNER_CODE            OWNER_DESCR STATE COUNTY FIPS_CODE  \\\n",
       "0       -121.005833        5.0                   USFS    CA     63       063   \n",
       "1       -120.404444        5.0                   USFS    CA     61       061   \n",
       "2       -120.735556       13.0       STATE OR PRIVATE    CA     17       017   \n",
       "3       -119.913333        5.0                   USFS    CA      3       003   \n",
       "4       -119.933056        5.0                   USFS    CA      3       003   \n",
       "5       -120.103611        5.0                   USFS    CA      5       005   \n",
       "6       -120.153333        5.0                   USFS    CA     17       017   \n",
       "7       -122.433889       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "8       -122.283333       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "9       -120.149167        5.0                   USFS    CA      5       005   \n",
       "10      -120.159722        5.0                   USFS    CA     17       017   \n",
       "11      -120.106111        5.0                   USFS    CA      5       005   \n",
       "12      -120.193333        5.0                   USFS    CA     17       017   \n",
       "13      -120.510000       14.0  MISSING/NOT SPECIFIED    CA      5       005   \n",
       "14      -120.279722        5.0                   USFS    CA     17       017   \n",
       "15      -120.542222        5.0                   USFS    CA     17       017   \n",
       "16      -120.211667        5.0                   USFS    CA      5       005   \n",
       "17      -120.260000        5.0                   USFS    CA     17       017   \n",
       "18      -120.411667       13.0       STATE OR PRIVATE    CA     17       017   \n",
       "19      -105.720556        5.0                   USFS    NM     27       027   \n",
       "20      -105.628611       13.0       STATE OR PRIVATE    NM     27       027   \n",
       "21      -105.768056        5.0                   USFS    NM     27       027   \n",
       "22      -105.766111        5.0                   USFS    NM     27       027   \n",
       "23      -105.526111        5.0                   USFS    NM     27       027   \n",
       "24      -105.229444        5.0                   USFS    NM     27       027   \n",
       "25      -105.512222        5.0                   USFS    NM     27       027   \n",
       "26      -105.631111       14.0  MISSING/NOT SPECIFIED    NM     27       027   \n",
       "27      -105.507222        5.0                   USFS    NM     27       027   \n",
       "28      -105.638611        5.0                   USFS    NM     27       027   \n",
       "29      -105.700278        5.0                   USFS    NM     27       027   \n",
       "...             ...        ...                    ...   ...    ...       ...   \n",
       "1880435 -122.451750       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880436 -121.036533       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880437 -123.763317       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880438 -121.260759       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880439 -118.883333       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880440 -118.800000       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880441 -118.583333       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880442 -122.074684       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880443 -120.528000       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880444 -122.021111       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880445 -118.465150       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880446 -116.658889       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880447 -116.627539       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880448 -120.664433       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880449 -119.333333       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880450 -121.985283       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880451 -120.863673       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880452 -118.693303       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880453 -118.621180       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880454 -120.313090       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880455 -120.613743       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880456 -122.391398       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880457 -123.069617       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880458 -123.544167       15.0      UNDEFINED FEDERAL    CA   None      None   \n",
       "1880459 -122.660044       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880460 -122.389375       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "1880461 -120.938570       12.0        MUNICIPAL/LOCAL    CA   None      None   \n",
       "1880462 -120.938570       12.0        MUNICIPAL/LOCAL    CA   None      None   \n",
       "1880463 -120.898356       12.0        MUNICIPAL/LOCAL    CA   None      None   \n",
       "1880464 -116.830950       13.0       STATE OR PRIVATE    CA   None      None   \n",
       "\n",
       "         FIPS_NAME                                              Shape  \n",
       "0           Plumas  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...  \n",
       "1           Placer  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...  \n",
       "2        El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...  \n",
       "3           Alpine  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...  \n",
       "4           Alpine  b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...  \n",
       "5           Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0<~\\x90\\xa1\\x06^\\...  \n",
       "6        El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00$o\\x996\\xd0\\t^\\xc0h\\...  \n",
       "7             None  b'\\x00\\x01\\xad\\x10\\x00\\x00t)\\xe8\\xd5\\xc4\\x9b^\\...  \n",
       "8             None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xdc\\x8d\\x1e\"\"\\x92^\\...  \n",
       "9           Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\t^\\xc0\\...  \n",
       "10       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x0c\\xd6\\x8b\\xe38\\n^...  \n",
       "11          Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00L\\xcc@\\x86\\xca\\x06^\\...  \n",
       "12       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_\\x0c^\\...  \n",
       "13          Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3 ^\\xc0\\x...  \n",
       "14       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb7\\x06\\xf8\\xe6\\x1...  \n",
       "15       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x84\\xd3\\xc4\\xb3\"^\\...  \n",
       "16          Amador  b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\r^\\xc0\\...  \n",
       "17       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3\\x10^\\xc...  \n",
       "18       El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x004 )\\xbfX\\x1a^\\xc00\\\\...  \n",
       "19         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xa8I\\x11\\x95\\x1dnZ\\...  \n",
       "20         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x88\\xd6\\x17*;hZ\\xc0...  \n",
       "21         Lincoln  b\"\\x00\\x01\\xad\\x10\\x00\\x00|\\xed\\x81\\xd2'qZ\\xc0...  \n",
       "22         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xa3\\xe4\\xf6\\x07qZ\\...  \n",
       "23         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xe0\\xee\\xcd\\xab...  \n",
       "24         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x83\\xbb7\\xafNZ\\xc0...  \n",
       "25         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xcc\\xcb\\xb4?\\xc8`Z\\...  \n",
       "26         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe4e\\xda\\x1fdhZ\\xc0...  \n",
       "27         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x14\\xad/Tv`Z\\xc0\\xd...  \n",
       "28         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf8\\x13\"\\x01\\xdfhZ\\...  \n",
       "29         Lincoln  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xcd\\xe4Y\\xd1lZ\\...  \n",
       "...            ...                                                ...  \n",
       "1880435       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0\\xfd\\xd4x\\xe9\\x9...  \n",
       "1880436       None  b'\\x00\\x01\\xad\\x10\\x00\\x00`\\x0e\\x82\\x8eVB^\\xc0...  \n",
       "1880437       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc4\\xde\\x8b/\\xda\\xf...  \n",
       "1880438       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xccH\\x84F\\xb0P^\\xc0...  \n",
       "1880439       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x90\\x9e\"\\x87\\x88\\xb...  \n",
       "1880440       None  b'\\x00\\x01\\xad\\x10\\x00\\x0003333\\xb3]\\xc0\\xe0\\x...  \n",
       "1880441       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xa5]\\xc0\\x...  \n",
       "1880442       None  b'\\x00\\x01\\xad\\x10\\x00\\x004bf\\x9f\\xc7\\x84^\\xc0...  \n",
       "1880443       None  b'\\x00\\x01\\xad\\x10\\x00\\x00l\\x12\\x83\\xc0\\xca!^\\...  \n",
       "1880444       None  b'\\x00\\x01\\xad\\x10\\x00\\x00|\\xa5\\xf3\\xe1Y\\x81^\\...  \n",
       "1880445       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00o\\x81\\x04\\xc5\\x9...  \n",
       "1880446       None  b'\\x00\\x01\\xad\\x10\\x00\\x00l\\xac\\xc4<+*]\\xc0\\x1...  \n",
       "1880447       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8}V\\x99)(]\\xc00\\x...  \n",
       "1880448       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84X\\xfd\\x11\\x86*^\\...  \n",
       "1880449       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xd5]\\xc0\\x...  \n",
       "1880450       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x80\\x93m\\xe0\\x0e\\x7...  \n",
       "1880451       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\\\\\x1ekF7^\\xc0\\x...  \n",
       "1880452       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0A\\t\\x12_\\xac]\\xc...  \n",
       "1880453       None  b'\\x00\\x01\\xad\\x10\\x00\\x00h\\x0c\\xdfg\\xc1\\xa7]\\...  \n",
       "1880454       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x18\\xad\\xa3\\xaa\\t\\x...  \n",
       "1880455       None  b\"\\x00\\x01\\xad\\x10\\x00\\x00\\x84I\\xb8\\x90G'^\\xc0...  \n",
       "1880456       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x10n2\\xaa\\x0c\\x99^\\...  \n",
       "1880457       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8\\x8f\\xdc\\x9at\\xc...  \n",
       "1880458       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xfc#\\xd3\\xa1\\xd3\\xe...  \n",
       "1880459       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0z0)>\\xaa^\\xc0h\\x...  \n",
       "1880460       None  b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x9...  \n",
       "1880461       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...  \n",
       "1880462       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...  \n",
       "1880463       None  b'\\x00\\x01\\xad\\x10\\x00\\x00x\\xba_\\xaa~9^\\xc0\\xb...  \n",
       "1880464       None  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x1c\\xa7\\xe8H.5]\\xc0...  \n",
       "\n",
       "[1880465 rows x 39 columns]"
      ]
     },
     "execution_count": 309,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "metadata": {},
   "outputs": [],
   "source": [
    "tree = spatial.KDTree(np.array(station_df[['lat', 'lon']]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 319,
   "metadata": {},
   "outputs": [],
   "source": [
    "_, idx = tree.query(df[['LATITUDE', 'LONGITUDE']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 323,
   "metadata": {},
   "outputs": [],
   "source": [
    "closest_station = station_df.iloc[idx]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "*https://www.fs.usda.gov/rds/archive/products/RDS-2013-0009.4/_metadata_RDS-2013-0009.4.html* <br>\n",
    "FIRE_SIZE_CLASS = Code for fire size based on the number of acres within the final fire perimeter expenditures (A=greater than 0 but less than or equal to 0.25 acres, B=0.26-9.9 acres, C=10.0-99.9 acres, D=100-299 acres, E=300 to 999 acres, F=1000 to 4999 acres, and G=5000+ acres)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 424,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df = df.drop(['OBJECTID', 'FOD_ID', 'Shape', 'FIPS_CODE', \n",
    "         'LOCAL_INCIDENT_ID', 'LOCAL_FIRE_REPORT_ID', \n",
    "         'FPA_ID', 'SOURCE_SYSTEM_TYPE','SOURCE_SYSTEM', \n",
    "         'NWCG_REPORTING_AGENCY', 'NWCG_REPORTING_UNIT_ID', \n",
    "         'NWCG_REPORTING_UNIT_NAME', 'SOURCE_REPORTING_UNIT',\n",
    "        'FIRE_CODE', 'ICS_209_INCIDENT_NUMBER', 'ICS_209_NAME', \n",
    "         'MTBS_ID', 'MTBS_FIRE_NAME', 'COMPLEX_NAME', 'STAT_CAUSE_CODE', \n",
    "         'COUNTY'],\n",
    "        axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 425,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "\"['level_0' 'wban' 'fips' 'call'] not found in axis\"",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-425-b10bb1b4885f>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m closest_station = closest_station.reset_index().drop(\n\u001b[1;32m----> 2\u001b[1;33m     ['level_0', 'index', 'wban', 'fips', 'call'], axis=1)\n\u001b[0m",
      "\u001b[1;32mC:\\tools\\Anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36mdrop\u001b[1;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[0;32m   3938\u001b[0m                                            \u001b[0mindex\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3939\u001b[0m                                            \u001b[0mlevel\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minplace\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0minplace\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3940\u001b[1;33m                                            errors=errors)\n\u001b[0m\u001b[0;32m   3941\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3942\u001b[0m     @rewrite_axis_style_signature('mapper', [('copy', True),\n",
      "\u001b[1;32mC:\\tools\\Anaconda3\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36mdrop\u001b[1;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[0;32m   3778\u001b[0m         \u001b[1;32mfor\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mlabels\u001b[0m \u001b[1;32min\u001b[0m \u001b[0maxes\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3779\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mlabels\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3780\u001b[1;33m                 \u001b[0mobj\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mobj\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_drop_axis\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3781\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3782\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0minplace\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\tools\\Anaconda3\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36m_drop_axis\u001b[1;34m(self, labels, axis, level, errors)\u001b[0m\n\u001b[0;32m   3810\u001b[0m                 \u001b[0mnew_axis\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3811\u001b[0m             \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3812\u001b[1;33m                 \u001b[0mnew_axis\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3813\u001b[0m             \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreindex\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m**\u001b[0m\u001b[1;33m{\u001b[0m\u001b[0maxis_name\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mnew_axis\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3814\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\tools\\Anaconda3\\lib\\site-packages\\pandas\\core\\indexes\\base.py\u001b[0m in \u001b[0;36mdrop\u001b[1;34m(self, labels, errors)\u001b[0m\n\u001b[0;32m   4963\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0merrors\u001b[0m \u001b[1;33m!=\u001b[0m \u001b[1;34m'ignore'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   4964\u001b[0m                 raise KeyError(\n\u001b[1;32m-> 4965\u001b[1;33m                     '{} not found in axis'.format(labels[mask]))\n\u001b[0m\u001b[0;32m   4966\u001b[0m             \u001b[0mindexer\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mindexer\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m~\u001b[0m\u001b[0mmask\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   4967\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdelete\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mKeyError\u001b[0m: \"['level_0' 'wban' 'fips' 'call'] not found in axis\""
     ]
    }
   ],
   "source": [
    "closest_station = closest_station.reset_index().drop(\n",
    "    ['level_0', 'index', 'wban', 'fips', 'call'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 384,
   "metadata": {},
   "outputs": [],
   "source": [
    "closest_station = closest_station.rename(columns=dict(zip(closest_station.columns, [\"CS-\" + c.upper() for c in closest_station.columns])))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 418,
   "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>CS-USAF</th>\n",
       "      <th>CS-NAME</th>\n",
       "      <th>CS-COUNTRY</th>\n",
       "      <th>CS-STATE</th>\n",
       "      <th>CS-LAT</th>\n",
       "      <th>CS-LON</th>\n",
       "      <th>CS-ELEV</th>\n",
       "      <th>CS-BEGIN</th>\n",
       "      <th>CS-END</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>725837</td>\n",
       "      <td>SUSANVILLE MUNI</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.383</td>\n",
       "      <td>-120.567</td>\n",
       "      <td>12650</td>\n",
       "      <td>19770301</td>\n",
       "      <td>19960718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>720645</td>\n",
       "      <td>PLACERVILLE AIRPORT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.717</td>\n",
       "      <td>-120.750</td>\n",
       "      <td>7870</td>\n",
       "      <td>20090711</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>721027</td>\n",
       "      <td>TRINITY CENTER</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.983</td>\n",
       "      <td>-122.694</td>\n",
       "      <td>7280</td>\n",
       "      <td>20120302</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>725957</td>\n",
       "      <td>MOUNT SHASTA</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>41.317</td>\n",
       "      <td>-122.317</td>\n",
       "      <td>10770</td>\n",
       "      <td>20000101</td>\n",
       "      <td>20031231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>725847</td>\n",
       "      <td>LAKE TAHOE</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.883</td>\n",
       "      <td>-120.000</td>\n",
       "      <td>19090</td>\n",
       "      <td>19730101</td>\n",
       "      <td>19991231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>745010</td>\n",
       "      <td>FRESHPOND</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.750</td>\n",
       "      <td>-120.517</td>\n",
       "      <td>11470</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>999999</td>\n",
       "      <td>NEEDLES AIRPORT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.768</td>\n",
       "      <td>-114.619</td>\n",
       "      <td>2786</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19650101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>999999</td>\n",
       "      <td>NEEDLES AIRPORT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.768</td>\n",
       "      <td>-114.619</td>\n",
       "      <td>2786</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19650101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>999999</td>\n",
       "      <td>BLYTHE RIVERSIDE CO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>33.619</td>\n",
       "      <td>-114.714</td>\n",
       "      <td>1195</td>\n",
       "      <td>19481101</td>\n",
       "      <td>19721231</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880435</th>\n",
       "      <td>720406</td>\n",
       "      <td>GNOSS FIELD AIRPORT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.150</td>\n",
       "      <td>-122.550</td>\n",
       "      <td>10</td>\n",
       "      <td>20071114</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880436</th>\n",
       "      <td>749486</td>\n",
       "      <td>NEVADA CO AIR PARK</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>39.224</td>\n",
       "      <td>-121.003</td>\n",
       "      <td>9610</td>\n",
       "      <td>20110921</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880437</th>\n",
       "      <td>725948</td>\n",
       "      <td>TRINIDAD HEAD(CGLS)</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>41.050</td>\n",
       "      <td>-124.150</td>\n",
       "      <td>580</td>\n",
       "      <td>19760130</td>\n",
       "      <td>19960701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880438</th>\n",
       "      <td>745000</td>\n",
       "      <td>SHERIDAN</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>39.000</td>\n",
       "      <td>-121.333</td>\n",
       "      <td>600</td>\n",
       "      <td>20020226</td>\n",
       "      <td>20020226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880439</th>\n",
       "      <td>999999</td>\n",
       "      <td>SANDBERG</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.744</td>\n",
       "      <td>-118.724</td>\n",
       "      <td>13786</td>\n",
       "      <td>19480101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880440</th>\n",
       "      <td>999999</td>\n",
       "      <td>SANDBERG</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.744</td>\n",
       "      <td>-118.724</td>\n",
       "      <td>13786</td>\n",
       "      <td>19480101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880441</th>\n",
       "      <td>999999</td>\n",
       "      <td>NEWHALL AP</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.400</td>\n",
       "      <td>-118.550</td>\n",
       "      <td>3700</td>\n",
       "      <td>19480901</td>\n",
       "      <td>19490801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880442</th>\n",
       "      <td>745095</td>\n",
       "      <td>SANTA CRUZ HARBOR</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>36.967</td>\n",
       "      <td>-122.000</td>\n",
       "      <td>10</td>\n",
       "      <td>19760130</td>\n",
       "      <td>19960701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880443</th>\n",
       "      <td>725837</td>\n",
       "      <td>SUSANVILLE MUNI</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.383</td>\n",
       "      <td>-120.567</td>\n",
       "      <td>12650</td>\n",
       "      <td>19770301</td>\n",
       "      <td>19960718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880444</th>\n",
       "      <td>724935</td>\n",
       "      <td>HAYWARD AIR TERM</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>37.654</td>\n",
       "      <td>-122.115</td>\n",
       "      <td>143</td>\n",
       "      <td>20000101</td>\n",
       "      <td>20100731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880445</th>\n",
       "      <td>999999</td>\n",
       "      <td>BISHOP AIRPORT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>37.371</td>\n",
       "      <td>-118.358</td>\n",
       "      <td>12634</td>\n",
       "      <td>19480104</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880446</th>\n",
       "      <td>722864</td>\n",
       "      <td>BIG BEAR ARPT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.267</td>\n",
       "      <td>-116.683</td>\n",
       "      <td>20590</td>\n",
       "      <td>19801202</td>\n",
       "      <td>19840614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880447</th>\n",
       "      <td>747186</td>\n",
       "      <td>CAMPO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>32.623</td>\n",
       "      <td>-116.473</td>\n",
       "      <td>7971</td>\n",
       "      <td>20060101</td>\n",
       "      <td>20120619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880448</th>\n",
       "      <td>725837</td>\n",
       "      <td>SUSANVILLE MUNI</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.383</td>\n",
       "      <td>-120.567</td>\n",
       "      <td>12650</td>\n",
       "      <td>19770301</td>\n",
       "      <td>19960718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880449</th>\n",
       "      <td>725671</td>\n",
       "      <td>LOS ANGELES(NEXRAD)</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.417</td>\n",
       "      <td>-119.183</td>\n",
       "      <td>8560</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880450</th>\n",
       "      <td>724958</td>\n",
       "      <td>PORT CHICAGO</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.033</td>\n",
       "      <td>-122.033</td>\n",
       "      <td>120</td>\n",
       "      <td>19750916</td>\n",
       "      <td>19960607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880451</th>\n",
       "      <td>720697</td>\n",
       "      <td>CAMERON AIRPARK</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.684</td>\n",
       "      <td>-120.988</td>\n",
       "      <td>3920</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880452</th>\n",
       "      <td>722916</td>\n",
       "      <td>MALIBU BEACH</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.033</td>\n",
       "      <td>-118.683</td>\n",
       "      <td>1390</td>\n",
       "      <td>19780823</td>\n",
       "      <td>19820702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880453</th>\n",
       "      <td>720046</td>\n",
       "      <td>NEWHALL</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.367</td>\n",
       "      <td>-118.567</td>\n",
       "      <td>4270</td>\n",
       "      <td>20040224</td>\n",
       "      <td>20110905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880454</th>\n",
       "      <td>720615</td>\n",
       "      <td>COLUMBIA</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.033</td>\n",
       "      <td>-120.417</td>\n",
       "      <td>6460</td>\n",
       "      <td>20090120</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880455</th>\n",
       "      <td>720681</td>\n",
       "      <td>CALAVERAS CO RASMUSS</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.146</td>\n",
       "      <td>-120.648</td>\n",
       "      <td>4040</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880456</th>\n",
       "      <td>999999</td>\n",
       "      <td>RED BLUFF MUNICIPAL ARPT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.152</td>\n",
       "      <td>-122.254</td>\n",
       "      <td>1076</td>\n",
       "      <td>19480101</td>\n",
       "      <td>19721231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880457</th>\n",
       "      <td>720193</td>\n",
       "      <td>LONNIE POOL FLD/WEAV</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.747</td>\n",
       "      <td>-122.922</td>\n",
       "      <td>7160</td>\n",
       "      <td>20101030</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880458</th>\n",
       "      <td>999999</td>\n",
       "      <td>SHELTER COVE AIRPORT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.033</td>\n",
       "      <td>-124.068</td>\n",
       "      <td>210</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880459</th>\n",
       "      <td>999999</td>\n",
       "      <td>SANTA ROSA NAAS</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>38.417</td>\n",
       "      <td>-122.750</td>\n",
       "      <td>421</td>\n",
       "      <td>19450301</td>\n",
       "      <td>19470416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880460</th>\n",
       "      <td>725915</td>\n",
       "      <td>REDDING MUNICIPAL ARPT</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>40.518</td>\n",
       "      <td>-122.299</td>\n",
       "      <td>1530</td>\n",
       "      <td>19440901</td>\n",
       "      <td>19910331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880461</th>\n",
       "      <td>724926</td>\n",
       "      <td>MODESTO CITY CO HAR</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>37.624</td>\n",
       "      <td>-120.951</td>\n",
       "      <td>296</td>\n",
       "      <td>19730101</td>\n",
       "      <td>20120619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880462</th>\n",
       "      <td>724926</td>\n",
       "      <td>MODESTO CITY CO HAR</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>37.624</td>\n",
       "      <td>-120.951</td>\n",
       "      <td>296</td>\n",
       "      <td>19730101</td>\n",
       "      <td>20120619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880463</th>\n",
       "      <td>724926</td>\n",
       "      <td>MODESTO CITY CO HAR</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>37.624</td>\n",
       "      <td>-120.951</td>\n",
       "      <td>296</td>\n",
       "      <td>19730101</td>\n",
       "      <td>20120619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880464</th>\n",
       "      <td>720165</td>\n",
       "      <td>BIG BEAR CITY</td>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>34.264</td>\n",
       "      <td>-116.854</td>\n",
       "      <td>20570</td>\n",
       "      <td>20070307</td>\n",
       "      <td>20120618</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1880465 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        CS-USAF                   CS-NAME CS-COUNTRY CS-STATE  CS-LAT  \\\n",
       "0        725837           SUSANVILLE MUNI         US       CA  40.383   \n",
       "1        745010                 FRESHPOND         US       CA  38.750   \n",
       "2        720645       PLACERVILLE AIRPORT         US       CA  38.717   \n",
       "3        725847                LAKE TAHOE         US       CA  38.883   \n",
       "4        725847                LAKE TAHOE         US       CA  38.883   \n",
       "5        725847                LAKE TAHOE         US       CA  38.883   \n",
       "6        725847                LAKE TAHOE         US       CA  38.883   \n",
       "7        721027            TRINITY CENTER         US       CA  40.983   \n",
       "8        725957              MOUNT SHASTA         US       CA  41.317   \n",
       "9        725847                LAKE TAHOE         US       CA  38.883   \n",
       "10       725847                LAKE TAHOE         US       CA  38.883   \n",
       "11       725847                LAKE TAHOE         US       CA  38.883   \n",
       "12       725847                LAKE TAHOE         US       CA  38.883   \n",
       "13       745010                 FRESHPOND         US       CA  38.750   \n",
       "14       745010                 FRESHPOND         US       CA  38.750   \n",
       "15       745010                 FRESHPOND         US       CA  38.750   \n",
       "16       745010                 FRESHPOND         US       CA  38.750   \n",
       "17       745010                 FRESHPOND         US       CA  38.750   \n",
       "18       745010                 FRESHPOND         US       CA  38.750   \n",
       "19       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "20       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "21       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "22       999999           NEEDLES AIRPORT         US       CA  34.768   \n",
       "23       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "24       999999           NEEDLES AIRPORT         US       CA  34.768   \n",
       "25       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "26       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "27       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "28       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "29       999999       BLYTHE RIVERSIDE CO         US       CA  33.619   \n",
       "...         ...                       ...        ...      ...     ...   \n",
       "1880435  720406       GNOSS FIELD AIRPORT         US       CA  38.150   \n",
       "1880436  749486        NEVADA CO AIR PARK         US       CA  39.224   \n",
       "1880437  725948       TRINIDAD HEAD(CGLS)         US       CA  41.050   \n",
       "1880438  745000                  SHERIDAN         US       CA  39.000   \n",
       "1880439  999999                  SANDBERG         US       CA  34.744   \n",
       "1880440  999999                  SANDBERG         US       CA  34.744   \n",
       "1880441  999999                NEWHALL AP         US       CA  34.400   \n",
       "1880442  745095         SANTA CRUZ HARBOR         US       CA  36.967   \n",
       "1880443  725837           SUSANVILLE MUNI         US       CA  40.383   \n",
       "1880444  724935          HAYWARD AIR TERM         US       CA  37.654   \n",
       "1880445  999999            BISHOP AIRPORT         US       CA  37.371   \n",
       "1880446  722864             BIG BEAR ARPT         US       CA  34.267   \n",
       "1880447  747186                     CAMPO         US       CA  32.623   \n",
       "1880448  725837           SUSANVILLE MUNI         US       CA  40.383   \n",
       "1880449  725671       LOS ANGELES(NEXRAD)         US       CA  34.417   \n",
       "1880450  724958              PORT CHICAGO         US       CA  38.033   \n",
       "1880451  720697           CAMERON AIRPARK         US       CA  38.684   \n",
       "1880452  722916              MALIBU BEACH         US       CA  34.033   \n",
       "1880453  720046                   NEWHALL         US       CA  34.367   \n",
       "1880454  720615                  COLUMBIA         US       CA  38.033   \n",
       "1880455  720681      CALAVERAS CO RASMUSS         US       CA  38.146   \n",
       "1880456  999999  RED BLUFF MUNICIPAL ARPT         US       CA  40.152   \n",
       "1880457  720193      LONNIE POOL FLD/WEAV         US       CA  40.747   \n",
       "1880458  999999      SHELTER COVE AIRPORT         US       CA  40.033   \n",
       "1880459  999999           SANTA ROSA NAAS         US       CA  38.417   \n",
       "1880460  725915    REDDING MUNICIPAL ARPT         US       CA  40.518   \n",
       "1880461  724926       MODESTO CITY CO HAR         US       CA  37.624   \n",
       "1880462  724926       MODESTO CITY CO HAR         US       CA  37.624   \n",
       "1880463  724926       MODESTO CITY CO HAR         US       CA  37.624   \n",
       "1880464  720165             BIG BEAR CITY         US       CA  34.264   \n",
       "\n",
       "          CS-LON CS-ELEV  CS-BEGIN    CS-END  \n",
       "0       -120.567   12650  19770301  19960718  \n",
       "1       -120.517   11470      None      None  \n",
       "2       -120.750    7870  20090711  20120618  \n",
       "3       -120.000   19090  19730101  19991231  \n",
       "4       -120.000   19090  19730101  19991231  \n",
       "5       -120.000   19090  19730101  19991231  \n",
       "6       -120.000   19090  19730101  19991231  \n",
       "7       -122.694    7280  20120302  20120618  \n",
       "8       -122.317   10770  20000101  20031231  \n",
       "9       -120.000   19090  19730101  19991231  \n",
       "10      -120.000   19090  19730101  19991231  \n",
       "11      -120.000   19090  19730101  19991231  \n",
       "12      -120.000   19090  19730101  19991231  \n",
       "13      -120.517   11470      None      None  \n",
       "14      -120.517   11470      None      None  \n",
       "15      -120.517   11470      None      None  \n",
       "16      -120.517   11470      None      None  \n",
       "17      -120.517   11470      None      None  \n",
       "18      -120.517   11470      None      None  \n",
       "19      -114.714    1195  19481101  19721231  \n",
       "20      -114.714    1195  19481101  19721231  \n",
       "21      -114.714    1195  19481101  19721231  \n",
       "22      -114.619    2786  19481101  19650101  \n",
       "23      -114.714    1195  19481101  19721231  \n",
       "24      -114.619    2786  19481101  19650101  \n",
       "25      -114.714    1195  19481101  19721231  \n",
       "26      -114.714    1195  19481101  19721231  \n",
       "27      -114.714    1195  19481101  19721231  \n",
       "28      -114.714    1195  19481101  19721231  \n",
       "29      -114.714    1195  19481101  19721231  \n",
       "...          ...     ...       ...       ...  \n",
       "1880435 -122.550      10  20071114  20120618  \n",
       "1880436 -121.003    9610  20110921  20120618  \n",
       "1880437 -124.150     580  19760130  19960701  \n",
       "1880438 -121.333     600  20020226  20020226  \n",
       "1880439 -118.724   13786  19480101  19721231  \n",
       "1880440 -118.724   13786  19480101  19721231  \n",
       "1880441 -118.550    3700  19480901  19490801  \n",
       "1880442 -122.000      10  19760130  19960701  \n",
       "1880443 -120.567   12650  19770301  19960718  \n",
       "1880444 -122.115     143  20000101  20100731  \n",
       "1880445 -118.358   12634  19480104  19721231  \n",
       "1880446 -116.683   20590  19801202  19840614  \n",
       "1880447 -116.473    7971  20060101  20120619  \n",
       "1880448 -120.567   12650  19770301  19960718  \n",
       "1880449 -119.183    8560      None      None  \n",
       "1880450 -122.033     120  19750916  19960607  \n",
       "1880451 -120.988    3920      None      None  \n",
       "1880452 -118.683    1390  19780823  19820702  \n",
       "1880453 -118.567    4270  20040224  20110905  \n",
       "1880454 -120.417    6460  20090120  20120618  \n",
       "1880455 -120.648    4040      None      None  \n",
       "1880456 -122.254    1076  19480101  19721231  \n",
       "1880457 -122.922    7160  20101030  20120618  \n",
       "1880458 -124.068     210      None      None  \n",
       "1880459 -122.750     421  19450301  19470416  \n",
       "1880460 -122.299    1530  19440901  19910331  \n",
       "1880461 -120.951     296  19730101  20120619  \n",
       "1880462 -120.951     296  19730101  20120619  \n",
       "1880463 -120.951     296  19730101  20120619  \n",
       "1880464 -116.854   20570  20070307  20120618  \n",
       "\n",
       "[1880465 rows x 9 columns]"
      ]
     },
     "execution_count": 418,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "closest_station"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 426,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_data = pd.concat([new_df, closest_station], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 430,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_data[total_data['STATE'] == 'CA'].to_sql('aggregate_data', con=conn)"
   ]
  }
 ],
 "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.3"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": true,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}