Data_Cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: geopandas in /opt/anaconda3/lib/python3.9/site-packages (0.12.2)\n",
      "Requirement already satisfied: packaging in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (21.3)\n",
      "Requirement already satisfied: pyproj>=2.6.1.post1 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (3.4.1)\n",
      "Requirement already satisfied: pandas>=1.0.0 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (1.4.4)\n",
      "Requirement already satisfied: fiona>=1.8 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (1.8.22)\n",
      "Requirement already satisfied: shapely>=1.7 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (2.0.0)\n",
      "Requirement already satisfied: six>=1.7 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (1.16.0)\n",
      "Requirement already satisfied: certifi in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (2022.9.24)\n",
      "Requirement already satisfied: click-plugins>=1.0 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (1.1.1)\n",
      "Requirement already satisfied: munch in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (2.5.0)\n",
      "Requirement already satisfied: attrs>=17 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (22.1.0)\n",
      "Requirement already satisfied: setuptools in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (65.5.0)\n",
      "Requirement already satisfied: cligj>=0.5 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (0.7.2)\n",
      "Requirement already satisfied: click>=4.0 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (8.0.4)\n",
      "Requirement already satisfied: python-dateutil>=2.8.1 in /opt/anaconda3/lib/python3.9/site-packages (from pandas>=1.0.0->geopandas) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2020.1 in /opt/anaconda3/lib/python3.9/site-packages (from pandas>=1.0.0->geopandas) (2022.1)\n",
      "Requirement already satisfied: numpy>=1.18.5 in /opt/anaconda3/lib/python3.9/site-packages (from pandas>=1.0.0->geopandas) (1.21.5)\n",
      "Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /opt/anaconda3/lib/python3.9/site-packages (from packaging->geopandas) (3.0.9)\n",
      "Requirement already satisfied: folium in /opt/anaconda3/lib/python3.9/site-packages (0.14.0)\n",
      "Requirement already satisfied: jinja2>=2.9 in /opt/anaconda3/lib/python3.9/site-packages (from folium) (2.11.3)\n",
      "Requirement already satisfied: branca>=0.6.0 in /opt/anaconda3/lib/python3.9/site-packages (from folium) (0.6.0)\n",
      "Requirement already satisfied: requests in /opt/anaconda3/lib/python3.9/site-packages (from folium) (2.28.1)\n",
      "Requirement already satisfied: numpy in /opt/anaconda3/lib/python3.9/site-packages (from folium) (1.21.5)\n",
      "Requirement already satisfied: MarkupSafe>=0.23 in /opt/anaconda3/lib/python3.9/site-packages (from jinja2>=2.9->folium) (2.0.1)\n",
      "Requirement already satisfied: charset-normalizer<3,>=2 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (2.0.4)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (1.26.13)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (2022.9.24)\n",
      "Requirement already satisfied: idna<4,>=2.5 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (3.4)\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "import plotly.express as px\n",
    "import plotly.graph_objects as go\n",
    "from plotly.subplots import make_subplots\n",
    "import datetime as datetime\n",
    "from datetime import datetime\n",
    "\n",
    "!pip install geopandas   # If geopandas is not installed, this code should be activated.\n",
    "import geopandas as gpd # For working with geospatial data\n",
    "!pip install folium\n",
    "import folium as fm     # folium has more dynamic maps - but requires internet connection\n",
    "import matplotlib.pyplot as plt\n",
    "from shapely.geometry import Point, Polygon\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>MasterIncidentNumber</th>\n",
       "      <th>CalendarYear</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayOfMonth</th>\n",
       "      <th>Call_Type</th>\n",
       "      <th>Problem</th>\n",
       "      <th>Battalion</th>\n",
       "      <th>Jurisdiction</th>\n",
       "      <th>ResponseArea</th>\n",
       "      <th>PriorityDescription</th>\n",
       "      <th>Response Status</th>\n",
       "      <th>Districts</th>\n",
       "      <th>Location 1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16,000,015</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2004</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(30218836, 97806156)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16,000,017</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3606</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30183275, 97786233)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16,000,038</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BBQ - Unsafe Cooking</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3102</td>\n",
       "      <td>4F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30363743, 97791275)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16,000,045</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(30318719, 97665985)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16,000,069</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2402</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30195769, 97739084)</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>16,003,972</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>14</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4003</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(30379306, 9.765421E+7)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>16,008,080</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>27</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3501</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(3.02153E+7, 97751378)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>16,027,714</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Mar</td>\n",
       "      <td>27</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2606</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(3.029124E+7, 97627952)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>16,014,050</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Feb</td>\n",
       "      <td>15</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0701</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(3.026215E+7, 97726965)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>16,027,523</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Mar</td>\n",
       "      <td>26</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2205</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(3.022632E+7, 97693756)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>690 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    MasterIncidentNumber CalendarYear Month  DayOfMonth Call_Type  \\\n",
       "0             16,000,015        2,016   Jan           1      Fire   \n",
       "1             16,000,017        2,016   Jan           1      Fire   \n",
       "2             16,000,038        2,016   Jan           1      Fire   \n",
       "3             16,000,045        2,016   Jan           1      Fire   \n",
       "4             16,000,069        2,016   Jan           1      Fire   \n",
       "..                   ...          ...   ...         ...       ...   \n",
       "685           16,003,972        2,016   Jan          14      Fire   \n",
       "686           16,008,080        2,016   Jan          27      Fire   \n",
       "687           16,027,714        2,016   Mar          27      Fire   \n",
       "688           16,014,050        2,016   Feb          15      Fire   \n",
       "689           16,027,523        2,016   Mar          26      Fire   \n",
       "\n",
       "                      Problem Battalion Jurisdiction ResponseArea  \\\n",
       "0          TRASH - Trash Fire        B4          AFD      00-2004   \n",
       "1          TRASH - Trash Fire        B4          AFD      00-3606   \n",
       "2        BBQ - Unsafe Cooking        B2          AFD      00-3102   \n",
       "3        DUMP - Dumpster Fire        B3          AFD      00-1801   \n",
       "4          TRASH - Trash Fire        B5          AFD      00-2402   \n",
       "..                        ...       ...          ...          ...   \n",
       "685  GRASS - Small Grass Fire        B3          AFD      00-4003   \n",
       "686          AUTO - Auto Fire        B5          AFD      00-3501   \n",
       "687          AUTO - Auto Fire        B3          AFD      00-2606   \n",
       "688        TRASH - Trash Fire        B5          AFD      00-0701   \n",
       "689      DUMP - Dumpster Fire        B5          AFD      00-2205   \n",
       "\n",
       "    PriorityDescription Response Status  Districts               Location 1  \n",
       "0                    3F          Code 3        5.0     (30218836, 97806156)  \n",
       "1                    3F          Code 1        2.0     (30183275, 97786233)  \n",
       "2                    4F          Code 1       10.0     (30363743, 97791275)  \n",
       "3                    3F          Code 3        1.0     (30318719, 97665985)  \n",
       "4                    3F          Code 1        2.0     (30195769, 97739084)  \n",
       "..                  ...             ...        ...                      ...  \n",
       "685                  3F          Code 3        1.0  (30379306, 9.765421E+7)  \n",
       "686                  2F          Code 3        2.0   (3.02153E+7, 97751378)  \n",
       "687                  2F          Code 3        1.0  (3.029124E+7, 97627952)  \n",
       "688                  3F          Code 3        3.0  (3.026215E+7, 97726965)  \n",
       "689                  3F          Code 3        3.0  (3.022632E+7, 97693756)  \n",
       "\n",
       "[690 rows x 13 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2016 = pd.read_csv(\"/Users/akhil/Documents/Fire Vulnerability Project/Input Data/2016.csv\")\n",
    "data_2017 = pd.read_csv(\"/Users/akhil/Documents/Fire Vulnerability Project/Input Data/2017.csv\")\n",
    "\n",
    "data_2016\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>MasterIncidentNumber</th>\n",
       "      <th>CalendarYear</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayOfMonth</th>\n",
       "      <th>Call_Type</th>\n",
       "      <th>Problem</th>\n",
       "      <th>Battalion</th>\n",
       "      <th>Jurisdiction</th>\n",
       "      <th>ResponseArea</th>\n",
       "      <th>PriorityDescription</th>\n",
       "      <th>Response Status</th>\n",
       "      <th>Districts</th>\n",
       "      <th>Location 1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17,093,562</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Sep</td>\n",
       "      <td>22</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B1</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0202</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(3.027827E+7, 97750572)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17,000,052</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1805</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(3.03285E+7, 97689363)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17,020,652</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Feb</td>\n",
       "      <td>28</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1102</td>\n",
       "      <td>3F</td>\n",
       "      <td>Left Blank</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(3.023976E+7, 97787699)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17,088,693</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Sep</td>\n",
       "      <td>8</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1903</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30337419, 9.775705E+7)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17,008,374</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jan</td>\n",
       "      <td>24</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3901</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(3.041475E+7, 97848298)</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2786</th>\n",
       "      <td>17,028,757</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>23</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2101</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30358688, 97746673)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2787</th>\n",
       "      <td>17,062,308</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jun</td>\n",
       "      <td>26</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Other</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(30372163, 97723397)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2788</th>\n",
       "      <td>17,072,490</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jul</td>\n",
       "      <td>25</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(30402761, 97679086)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2789</th>\n",
       "      <td>17,028,592</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>23</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2503</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30394168, 97748314)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>17,127,292</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Dec</td>\n",
       "      <td>29</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4204</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30202269, 97670862)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2791 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     MasterIncidentNumber CalendarYear Month  DayOfMonth Call_Type  \\\n",
       "0              17,093,562        2,017   Sep          22      Fire   \n",
       "1              17,000,052        2,017   Jan           1      Fire   \n",
       "2              17,020,652        2,017   Feb          28      Fire   \n",
       "3              17,088,693        2,017   Sep           8      Fire   \n",
       "4              17,008,374        2,017   Jan          24      Fire   \n",
       "...                   ...          ...   ...         ...       ...   \n",
       "2786           17,028,757        2,017   Mar          23      Fire   \n",
       "2787           17,062,308        2,017   Jun          26      Fire   \n",
       "2788           17,072,490        2,017   Jul          25      Fire   \n",
       "2789           17,028,592        2,017   Mar          23      Fire   \n",
       "2790           17,127,292        2,017   Dec          29      Fire   \n",
       "\n",
       "                       Problem Battalion Jurisdiction ResponseArea  \\\n",
       "0       ELEC - Electrical Fire        B1          AFD      00-0202   \n",
       "1         DUMP - Dumpster Fire        B3          AFD      00-1805   \n",
       "2       ELEC - Electrical Fire        B4          AFD      00-1102   \n",
       "3             AUTO - Auto Fire        B3          AFD      00-1903   \n",
       "4             AUTO - Auto Fire        B2          AFD      00-3901   \n",
       "...                        ...       ...          ...          ...   \n",
       "2786  GRASS - Small Grass Fire        B3          AFD      00-2101   \n",
       "2787    ELEC - Electrical Fire        B3          AFD      00-0801   \n",
       "2788    ELEC - Electrical Fire        B3          AFD      00-2801   \n",
       "2789  GRASS - Small Grass Fire        B2          AFD      00-2503   \n",
       "2790    ELEC - Electrical Fire        B5          AFD      00-4204   \n",
       "\n",
       "     PriorityDescription Response Status  Districts               Location 1  \n",
       "0                     3F          Code 3        9.0  (3.027827E+7, 97750572)  \n",
       "1                     3F          Code 3        1.0   (3.03285E+7, 97689363)  \n",
       "2                     3F      Left Blank        5.0  (3.023976E+7, 97787699)  \n",
       "3                     2F          Code 3       10.0  (30337419, 9.775705E+7)  \n",
       "4                     2F          Code 3        6.0  (3.041475E+7, 97848298)  \n",
       "...                  ...             ...        ...                      ...  \n",
       "2786                  3F          Code 3       10.0     (30358688, 97746673)  \n",
       "2787                  3F           Other        4.0     (30372163, 97723397)  \n",
       "2788                  3F          Code 3        7.0     (30402761, 97679086)  \n",
       "2789                  3F          Code 3       10.0     (30394168, 97748314)  \n",
       "2790                  3F          Code 3        2.0     (30202269, 97670862)  \n",
       "\n",
       "[2791 rows x 13 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_2016_2017 = data_2016 + data_2017\n",
    "\n",
    "def string_parser(string):\n",
    "\n",
    "    #Finds the comma separating the two values\n",
    "    separator_location = string.rfind(\",\")\n",
    "    \n",
    "    #Separate individual values from the combined string\n",
    "    lat_output = string[1:separator_location]\n",
    "    long_output = string[separator_location+2:(len(string)-1)]\n",
    "\n",
    "    #Prep for float conversion by adding decimal places\n",
    "    #lat_output = lat_output[:2] + \".\" + lat_output[2:]\n",
    "    #long_output = long_output[:2] + \".\" + long_output[2:]\n",
    "\n",
    "    #Convert to float\n",
    "    lat_output = float(lat_output)/(10**6)\n",
    "    long_output = float(long_output)/(10**6)\n",
    "\n",
    "\n",
    "    #Correct back to the western hemisphere\n",
    "    long_output = long_output*-1\n",
    "    \n",
    "    return [lat_output,long_output]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>MasterIncidentNumber</th>\n",
       "      <th>CalendarYear</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayOfMonth</th>\n",
       "      <th>Call_Type</th>\n",
       "      <th>Problem</th>\n",
       "      <th>Battalion</th>\n",
       "      <th>Jurisdiction</th>\n",
       "      <th>ResponseArea</th>\n",
       "      <th>PriorityDescription</th>\n",
       "      <th>Response Status</th>\n",
       "      <th>Districts</th>\n",
       "      <th>Location 1</th>\n",
       "      <th>lat</th>\n",
       "      <th>long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16,000,015</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2004</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(30218836, 97806156)</td>\n",
       "      <td>30.218836</td>\n",
       "      <td>-97.806156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16,000,017</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3606</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30183275, 97786233)</td>\n",
       "      <td>30.183275</td>\n",
       "      <td>-97.786233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16,000,038</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BBQ - Unsafe Cooking</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3102</td>\n",
       "      <td>4F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30363743, 97791275)</td>\n",
       "      <td>30.363743</td>\n",
       "      <td>-97.791275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16,000,045</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(30318719, 97665985)</td>\n",
       "      <td>30.318719</td>\n",
       "      <td>-97.665985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16,000,069</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2402</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30195769, 97739084)</td>\n",
       "      <td>30.195769</td>\n",
       "      <td>-97.739084</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>16,003,972</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>14</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4003</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(30379306, 9.765421E+7)</td>\n",
       "      <td>30.379306</td>\n",
       "      <td>-97.654210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>16,008,080</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>27</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3501</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(3.02153E+7, 97751378)</td>\n",
       "      <td>30.215300</td>\n",
       "      <td>-97.751378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>16,027,714</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Mar</td>\n",
       "      <td>27</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2606</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(3.029124E+7, 97627952)</td>\n",
       "      <td>30.291240</td>\n",
       "      <td>-97.627952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>16,014,050</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Feb</td>\n",
       "      <td>15</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0701</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(3.026215E+7, 97726965)</td>\n",
       "      <td>30.262150</td>\n",
       "      <td>-97.726965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>16,027,523</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Mar</td>\n",
       "      <td>26</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2205</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(3.022632E+7, 97693756)</td>\n",
       "      <td>30.226320</td>\n",
       "      <td>-97.693756</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>690 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    MasterIncidentNumber CalendarYear Month  DayOfMonth Call_Type  \\\n",
       "0             16,000,015        2,016   Jan           1      Fire   \n",
       "1             16,000,017        2,016   Jan           1      Fire   \n",
       "2             16,000,038        2,016   Jan           1      Fire   \n",
       "3             16,000,045        2,016   Jan           1      Fire   \n",
       "4             16,000,069        2,016   Jan           1      Fire   \n",
       "..                   ...          ...   ...         ...       ...   \n",
       "685           16,003,972        2,016   Jan          14      Fire   \n",
       "686           16,008,080        2,016   Jan          27      Fire   \n",
       "687           16,027,714        2,016   Mar          27      Fire   \n",
       "688           16,014,050        2,016   Feb          15      Fire   \n",
       "689           16,027,523        2,016   Mar          26      Fire   \n",
       "\n",
       "                      Problem Battalion Jurisdiction ResponseArea  \\\n",
       "0          TRASH - Trash Fire        B4          AFD      00-2004   \n",
       "1          TRASH - Trash Fire        B4          AFD      00-3606   \n",
       "2        BBQ - Unsafe Cooking        B2          AFD      00-3102   \n",
       "3        DUMP - Dumpster Fire        B3          AFD      00-1801   \n",
       "4          TRASH - Trash Fire        B5          AFD      00-2402   \n",
       "..                        ...       ...          ...          ...   \n",
       "685  GRASS - Small Grass Fire        B3          AFD      00-4003   \n",
       "686          AUTO - Auto Fire        B5          AFD      00-3501   \n",
       "687          AUTO - Auto Fire        B3          AFD      00-2606   \n",
       "688        TRASH - Trash Fire        B5          AFD      00-0701   \n",
       "689      DUMP - Dumpster Fire        B5          AFD      00-2205   \n",
       "\n",
       "    PriorityDescription Response Status  Districts               Location 1  \\\n",
       "0                    3F          Code 3        5.0     (30218836, 97806156)   \n",
       "1                    3F          Code 1        2.0     (30183275, 97786233)   \n",
       "2                    4F          Code 1       10.0     (30363743, 97791275)   \n",
       "3                    3F          Code 3        1.0     (30318719, 97665985)   \n",
       "4                    3F          Code 1        2.0     (30195769, 97739084)   \n",
       "..                  ...             ...        ...                      ...   \n",
       "685                  3F          Code 3        1.0  (30379306, 9.765421E+7)   \n",
       "686                  2F          Code 3        2.0   (3.02153E+7, 97751378)   \n",
       "687                  2F          Code 3        1.0  (3.029124E+7, 97627952)   \n",
       "688                  3F          Code 3        3.0  (3.026215E+7, 97726965)   \n",
       "689                  3F          Code 3        3.0  (3.022632E+7, 97693756)   \n",
       "\n",
       "           lat       long  \n",
       "0    30.218836 -97.806156  \n",
       "1    30.183275 -97.786233  \n",
       "2    30.363743 -97.791275  \n",
       "3    30.318719 -97.665985  \n",
       "4    30.195769 -97.739084  \n",
       "..         ...        ...  \n",
       "685  30.379306 -97.654210  \n",
       "686  30.215300 -97.751378  \n",
       "687  30.291240 -97.627952  \n",
       "688  30.262150 -97.726965  \n",
       "689  30.226320 -97.693756  \n",
       "\n",
       "[690 rows x 15 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2016['lat'] = data_2016.apply(lambda row : string_parser(row[\"Location 1\"])[0], axis = 1)\n",
    "data_2016['long'] = data_2016.apply(lambda row : string_parser(row[\"Location 1\"])[1], axis = 1)\n",
    "#data_2016[\"output_lat_long\"] = string_parser(data_2016[\"Location 1\"])\n",
    "#data_2016[\"lat\"] = string_parser(data_2016[\"Location 1\"][0])[0]\n",
    "#data_2016[\"long\"] = string_parser(data_2016[\"Location 1\"][1])[1]\n",
    "\n",
    "data_2016"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2017 has worse data quality and thus requires a different approach"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0       (3.027827E+7, 97750572)\n",
      "1        (3.03285E+7, 97689363)\n",
      "2       (3.023976E+7, 97787699)\n",
      "3       (30337419, 9.775705E+7)\n",
      "4       (3.041475E+7, 97848298)\n",
      "                 ...           \n",
      "2786       (30358688, 97746673)\n",
      "2787       (30372163, 97723397)\n",
      "2788       (30402761, 97679086)\n",
      "2789       (30394168, 97748314)\n",
      "2790       (30202269, 97670862)\n",
      "Name: Location 1, Length: 2791, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(data_2017[\"Location 1\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "def string_2017_parser(string):\n",
    "\n",
    "    #Finds the comma separating the two values\n",
    "    separator_location = string.rfind(\",\")\n",
    "    \n",
    "    #Separate individual values from the combined string\n",
    "    lat_output = string[1:separator_location]\n",
    "    long_output = string[separator_location+2:(len(string)-1)]\n",
    "\n",
    "    lat_output = float(lat_output)/(10**6)\n",
    "    long_output = float(long_output)/(10**6)\n",
    "\n",
    "\n",
    "    #Correct back to the western hemisphere\n",
    "    long_output = long_output*-1\n",
    "    \n",
    "    return [lat_output,long_output]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "#data_2017[\"lat\"] = string_2017_parser(data_2017[\"Location 1\"][0])[0]\n",
    "#data_2017[\"long\"] = string_2017_parser(data_2017[\"Location 1\"][1])[1]\n",
    "\n",
    "data_2017['lat'] = data_2017.apply(lambda row : string_2017_parser(row[\"Location 1\"])[0], axis = 1)\n",
    "data_2017['long'] = data_2017.apply(lambda row : string_2017_parser(row[\"Location 1\"])[1], axis = 1)\n",
    "\n",
    "data_2017\n",
    "\n",
    "all_data = pd.concat([data_2016,data_2017])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>MasterIncidentNumber</th>\n",
       "      <th>CalendarYear</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayOfMonth</th>\n",
       "      <th>Call_Type</th>\n",
       "      <th>Problem</th>\n",
       "      <th>Battalion</th>\n",
       "      <th>Jurisdiction</th>\n",
       "      <th>ResponseArea</th>\n",
       "      <th>PriorityDescription</th>\n",
       "      <th>Response Status</th>\n",
       "      <th>Districts</th>\n",
       "      <th>Location 1</th>\n",
       "      <th>lat</th>\n",
       "      <th>long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17,093,562</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Sep</td>\n",
       "      <td>22</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B1</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0202</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(3.027827E+7, 97750572)</td>\n",
       "      <td>30.278270</td>\n",
       "      <td>-97.750572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17,000,052</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1805</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(3.03285E+7, 97689363)</td>\n",
       "      <td>30.328500</td>\n",
       "      <td>-97.689363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17,020,652</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Feb</td>\n",
       "      <td>28</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1102</td>\n",
       "      <td>3F</td>\n",
       "      <td>Left Blank</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(3.023976E+7, 97787699)</td>\n",
       "      <td>30.239760</td>\n",
       "      <td>-97.787699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17,088,693</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Sep</td>\n",
       "      <td>8</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1903</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30337419, 9.775705E+7)</td>\n",
       "      <td>30.337419</td>\n",
       "      <td>-97.757050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17,008,374</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jan</td>\n",
       "      <td>24</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3901</td>\n",
       "      <td>2F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(3.041475E+7, 97848298)</td>\n",
       "      <td>30.414750</td>\n",
       "      <td>-97.848298</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2786</th>\n",
       "      <td>17,028,757</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>23</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2101</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30358688, 97746673)</td>\n",
       "      <td>30.358688</td>\n",
       "      <td>-97.746673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2787</th>\n",
       "      <td>17,062,308</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jun</td>\n",
       "      <td>26</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Other</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(30372163, 97723397)</td>\n",
       "      <td>30.372163</td>\n",
       "      <td>-97.723397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2788</th>\n",
       "      <td>17,072,490</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jul</td>\n",
       "      <td>25</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(30402761, 97679086)</td>\n",
       "      <td>30.402761</td>\n",
       "      <td>-97.679086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2789</th>\n",
       "      <td>17,028,592</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>23</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2503</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30394168, 97748314)</td>\n",
       "      <td>30.394168</td>\n",
       "      <td>-97.748314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>17,127,292</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Dec</td>\n",
       "      <td>29</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4204</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30202269, 97670862)</td>\n",
       "      <td>30.202269</td>\n",
       "      <td>-97.670862</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2791 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     MasterIncidentNumber CalendarYear Month  DayOfMonth Call_Type  \\\n",
       "0              17,093,562        2,017   Sep          22      Fire   \n",
       "1              17,000,052        2,017   Jan           1      Fire   \n",
       "2              17,020,652        2,017   Feb          28      Fire   \n",
       "3              17,088,693        2,017   Sep           8      Fire   \n",
       "4              17,008,374        2,017   Jan          24      Fire   \n",
       "...                   ...          ...   ...         ...       ...   \n",
       "2786           17,028,757        2,017   Mar          23      Fire   \n",
       "2787           17,062,308        2,017   Jun          26      Fire   \n",
       "2788           17,072,490        2,017   Jul          25      Fire   \n",
       "2789           17,028,592        2,017   Mar          23      Fire   \n",
       "2790           17,127,292        2,017   Dec          29      Fire   \n",
       "\n",
       "                       Problem Battalion Jurisdiction ResponseArea  \\\n",
       "0       ELEC - Electrical Fire        B1          AFD      00-0202   \n",
       "1         DUMP - Dumpster Fire        B3          AFD      00-1805   \n",
       "2       ELEC - Electrical Fire        B4          AFD      00-1102   \n",
       "3             AUTO - Auto Fire        B3          AFD      00-1903   \n",
       "4             AUTO - Auto Fire        B2          AFD      00-3901   \n",
       "...                        ...       ...          ...          ...   \n",
       "2786  GRASS - Small Grass Fire        B3          AFD      00-2101   \n",
       "2787    ELEC - Electrical Fire        B3          AFD      00-0801   \n",
       "2788    ELEC - Electrical Fire        B3          AFD      00-2801   \n",
       "2789  GRASS - Small Grass Fire        B2          AFD      00-2503   \n",
       "2790    ELEC - Electrical Fire        B5          AFD      00-4204   \n",
       "\n",
       "     PriorityDescription Response Status  Districts               Location 1  \\\n",
       "0                     3F          Code 3        9.0  (3.027827E+7, 97750572)   \n",
       "1                     3F          Code 3        1.0   (3.03285E+7, 97689363)   \n",
       "2                     3F      Left Blank        5.0  (3.023976E+7, 97787699)   \n",
       "3                     2F          Code 3       10.0  (30337419, 9.775705E+7)   \n",
       "4                     2F          Code 3        6.0  (3.041475E+7, 97848298)   \n",
       "...                  ...             ...        ...                      ...   \n",
       "2786                  3F          Code 3       10.0     (30358688, 97746673)   \n",
       "2787                  3F           Other        4.0     (30372163, 97723397)   \n",
       "2788                  3F          Code 3        7.0     (30402761, 97679086)   \n",
       "2789                  3F          Code 3       10.0     (30394168, 97748314)   \n",
       "2790                  3F          Code 3        2.0     (30202269, 97670862)   \n",
       "\n",
       "            lat       long  \n",
       "0     30.278270 -97.750572  \n",
       "1     30.328500 -97.689363  \n",
       "2     30.239760 -97.787699  \n",
       "3     30.337419 -97.757050  \n",
       "4     30.414750 -97.848298  \n",
       "...         ...        ...  \n",
       "2786  30.358688 -97.746673  \n",
       "2787  30.372163 -97.723397  \n",
       "2788  30.402761 -97.679086  \n",
       "2789  30.394168 -97.748314  \n",
       "2790  30.202269 -97.670862  \n",
       "\n",
       "[2791 rows x 15 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>MasterIncidentNumber</th>\n",
       "      <th>CalendarYear</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayOfMonth</th>\n",
       "      <th>Call_Type</th>\n",
       "      <th>Problem</th>\n",
       "      <th>Battalion</th>\n",
       "      <th>Jurisdiction</th>\n",
       "      <th>ResponseArea</th>\n",
       "      <th>PriorityDescription</th>\n",
       "      <th>Response Status</th>\n",
       "      <th>Districts</th>\n",
       "      <th>Location 1</th>\n",
       "      <th>lat</th>\n",
       "      <th>long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16,000,015</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2004</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(30218836, 97806156)</td>\n",
       "      <td>30.218836</td>\n",
       "      <td>-97.806156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16,000,017</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B4</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3606</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30183275, 97786233)</td>\n",
       "      <td>30.183275</td>\n",
       "      <td>-97.786233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16,000,038</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BBQ - Unsafe Cooking</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3102</td>\n",
       "      <td>4F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30363743, 97791275)</td>\n",
       "      <td>30.363743</td>\n",
       "      <td>-97.791275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16,000,045</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(30318719, 97665985)</td>\n",
       "      <td>30.318719</td>\n",
       "      <td>-97.665985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16,000,069</td>\n",
       "      <td>2,016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>1</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2402</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30195769, 97739084)</td>\n",
       "      <td>30.195769</td>\n",
       "      <td>-97.739084</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2786</th>\n",
       "      <td>17,028,757</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>23</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2101</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30358688, 97746673)</td>\n",
       "      <td>30.358688</td>\n",
       "      <td>-97.746673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2787</th>\n",
       "      <td>17,062,308</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jun</td>\n",
       "      <td>26</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Other</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(30372163, 97723397)</td>\n",
       "      <td>30.372163</td>\n",
       "      <td>-97.723397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2788</th>\n",
       "      <td>17,072,490</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Jul</td>\n",
       "      <td>25</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B3</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2801</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(30402761, 97679086)</td>\n",
       "      <td>30.402761</td>\n",
       "      <td>-97.679086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2789</th>\n",
       "      <td>17,028,592</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>23</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>B2</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2503</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(30394168, 97748314)</td>\n",
       "      <td>30.394168</td>\n",
       "      <td>-97.748314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>17,127,292</td>\n",
       "      <td>2,017</td>\n",
       "      <td>Dec</td>\n",
       "      <td>29</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>B5</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4204</td>\n",
       "      <td>3F</td>\n",
       "      <td>Code 3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(30202269, 97670862)</td>\n",
       "      <td>30.202269</td>\n",
       "      <td>-97.670862</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3481 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     MasterIncidentNumber CalendarYear Month  DayOfMonth Call_Type  \\\n",
       "0              16,000,015        2,016   Jan           1      Fire   \n",
       "1              16,000,017        2,016   Jan           1      Fire   \n",
       "2              16,000,038        2,016   Jan           1      Fire   \n",
       "3              16,000,045        2,016   Jan           1      Fire   \n",
       "4              16,000,069        2,016   Jan           1      Fire   \n",
       "...                   ...          ...   ...         ...       ...   \n",
       "2786           17,028,757        2,017   Mar          23      Fire   \n",
       "2787           17,062,308        2,017   Jun          26      Fire   \n",
       "2788           17,072,490        2,017   Jul          25      Fire   \n",
       "2789           17,028,592        2,017   Mar          23      Fire   \n",
       "2790           17,127,292        2,017   Dec          29      Fire   \n",
       "\n",
       "                       Problem Battalion Jurisdiction ResponseArea  \\\n",
       "0           TRASH - Trash Fire        B4          AFD      00-2004   \n",
       "1           TRASH - Trash Fire        B4          AFD      00-3606   \n",
       "2         BBQ - Unsafe Cooking        B2          AFD      00-3102   \n",
       "3         DUMP - Dumpster Fire        B3          AFD      00-1801   \n",
       "4           TRASH - Trash Fire        B5          AFD      00-2402   \n",
       "...                        ...       ...          ...          ...   \n",
       "2786  GRASS - Small Grass Fire        B3          AFD      00-2101   \n",
       "2787    ELEC - Electrical Fire        B3          AFD      00-0801   \n",
       "2788    ELEC - Electrical Fire        B3          AFD      00-2801   \n",
       "2789  GRASS - Small Grass Fire        B2          AFD      00-2503   \n",
       "2790    ELEC - Electrical Fire        B5          AFD      00-4204   \n",
       "\n",
       "     PriorityDescription Response Status  Districts            Location 1  \\\n",
       "0                     3F          Code 3        5.0  (30218836, 97806156)   \n",
       "1                     3F          Code 1        2.0  (30183275, 97786233)   \n",
       "2                     4F          Code 1       10.0  (30363743, 97791275)   \n",
       "3                     3F          Code 3        1.0  (30318719, 97665985)   \n",
       "4                     3F          Code 1        2.0  (30195769, 97739084)   \n",
       "...                  ...             ...        ...                   ...   \n",
       "2786                  3F          Code 3       10.0  (30358688, 97746673)   \n",
       "2787                  3F           Other        4.0  (30372163, 97723397)   \n",
       "2788                  3F          Code 3        7.0  (30402761, 97679086)   \n",
       "2789                  3F          Code 3       10.0  (30394168, 97748314)   \n",
       "2790                  3F          Code 3        2.0  (30202269, 97670862)   \n",
       "\n",
       "            lat       long  \n",
       "0     30.218836 -97.806156  \n",
       "1     30.183275 -97.786233  \n",
       "2     30.363743 -97.791275  \n",
       "3     30.318719 -97.665985  \n",
       "4     30.195769 -97.739084  \n",
       "...         ...        ...  \n",
       "2786  30.358688 -97.746673  \n",
       "2787  30.372163 -97.723397  \n",
       "2788  30.402761 -97.679086  \n",
       "2789  30.394168 -97.748314  \n",
       "2790  30.202269 -97.670862  \n",
       "\n",
       "[3481 rows x 15 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017 = gpd.GeoDataFrame(\n",
    "    all_data, geometry=gpd.points_from_xy(all_data.long, all_data.lat), crs=\"EPSG:4326\")\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Import the 2018-2021 Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2018_2021 = gpd.read_file(\"/Users/akhil/Documents/Fire Vulnerability Project/Input Data/AFD Fire Incidents 2018-2021/geo_export_11a4046f-83de-4712-b666-24e7911446ab.shp\", crs=\"EPSG:4326\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2018_2021[\"calendarye\"] = pd.to_numeric(gdf_2018_2021[\"calendarye\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2018_2020 = gdf_2018_2021.loc[gdf_2018_2021[\"calendarye\"] < 2021]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>incidentnu</th>\n",
       "      <th>calendarye</th>\n",
       "      <th>month</th>\n",
       "      <th>date_incda</th>\n",
       "      <th>time_incda</th>\n",
       "      <th>call_type</th>\n",
       "      <th>problem</th>\n",
       "      <th>responsear</th>\n",
       "      <th>jurisdicti</th>\n",
       "      <th>priorityde</th>\n",
       "      <th>council_di</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20139377</td>\n",
       "      <td>2020</td>\n",
       "      <td>Dec</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>00-0701</td>\n",
       "      <td>AFD</td>\n",
       "      <td>2F</td>\n",
       "      <td>3</td>\n",
       "      <td>POINT (-97.72651 30.25049)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18050381</td>\n",
       "      <td>2018</td>\n",
       "      <td>May</td>\n",
       "      <td>2018-05-20</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>00-0501</td>\n",
       "      <td>AFD</td>\n",
       "      <td>3F</td>\n",
       "      <td>3</td>\n",
       "      <td>POINT (-97.68956 30.26480)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20046163</td>\n",
       "      <td>2020</td>\n",
       "      <td>May</td>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>00-3111</td>\n",
       "      <td>AFD</td>\n",
       "      <td>2F</td>\n",
       "      <td>10</td>\n",
       "      <td>POINT (-97.83031 30.32466)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18011035</td>\n",
       "      <td>2018</td>\n",
       "      <td>Jan</td>\n",
       "      <td>2018-01-29</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>00-4004</td>\n",
       "      <td>AFD</td>\n",
       "      <td>3F</td>\n",
       "      <td>7</td>\n",
       "      <td>POINT (-97.67304 30.39916)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>18078725</td>\n",
       "      <td>2018</td>\n",
       "      <td>Aug</td>\n",
       "      <td>2018-08-01</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BBQ - Unsafe Cooking</td>\n",
       "      <td>00-2101</td>\n",
       "      <td>AFD</td>\n",
       "      <td>4F</td>\n",
       "      <td>10</td>\n",
       "      <td>POINT (-97.74799 30.36069)</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19540</th>\n",
       "      <td>18046570</td>\n",
       "      <td>2018</td>\n",
       "      <td>May</td>\n",
       "      <td>2018-05-11</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>00-1603</td>\n",
       "      <td>AFD</td>\n",
       "      <td>2F</td>\n",
       "      <td>4</td>\n",
       "      <td>POINT (-97.70707 30.32507)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19541</th>\n",
       "      <td>19000553</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jan</td>\n",
       "      <td>2019-01-02</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>00-2901</td>\n",
       "      <td>AFD</td>\n",
       "      <td>3F</td>\n",
       "      <td>8</td>\n",
       "      <td>POINT (-97.84954 30.19812)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19543</th>\n",
       "      <td>20025519</td>\n",
       "      <td>2020</td>\n",
       "      <td>Mar</td>\n",
       "      <td>2020-03-04</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>00-4901</td>\n",
       "      <td>AFD</td>\n",
       "      <td>2F</td>\n",
       "      <td>5</td>\n",
       "      <td>POINT (-97.81206 30.10195)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19550</th>\n",
       "      <td>20046507</td>\n",
       "      <td>2020</td>\n",
       "      <td>May</td>\n",
       "      <td>2020-05-02</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>00-0601</td>\n",
       "      <td>AFD</td>\n",
       "      <td>3F</td>\n",
       "      <td>9</td>\n",
       "      <td>POINT (-97.73705 30.24897)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19551</th>\n",
       "      <td>18107045</td>\n",
       "      <td>2018</td>\n",
       "      <td>Oct</td>\n",
       "      <td>2018-10-16</td>\n",
       "      <td>00:00:00.000</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BOX -Structure Fire</td>\n",
       "      <td>00-1504</td>\n",
       "      <td>AFD</td>\n",
       "      <td>1F</td>\n",
       "      <td>1</td>\n",
       "      <td>POINT (-97.70264 30.27809)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13718 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      incidentnu  calendarye month  date_incda    time_incda call_type  \\\n",
       "0       20139377        2020   Dec  2020-12-29  00:00:00.000      Fire   \n",
       "1       18050381        2018   May  2018-05-20  00:00:00.000      Fire   \n",
       "2       20046163        2020   May  2020-05-01  00:00:00.000      Fire   \n",
       "3       18011035        2018   Jan  2018-01-29  00:00:00.000      Fire   \n",
       "5       18078725        2018   Aug  2018-08-01  00:00:00.000      Fire   \n",
       "...          ...         ...   ...         ...           ...       ...   \n",
       "19540   18046570        2018   May  2018-05-11  00:00:00.000      Fire   \n",
       "19541   19000553        2019   Jan  2019-01-02  00:00:00.000      Fire   \n",
       "19543   20025519        2020   Mar  2020-03-04  00:00:00.000      Fire   \n",
       "19550   20046507        2020   May  2020-05-02  00:00:00.000      Fire   \n",
       "19551   18107045        2018   Oct  2018-10-16  00:00:00.000      Fire   \n",
       "\n",
       "                        problem responsear jurisdicti priorityde council_di  \\\n",
       "0              AUTO - Auto Fire    00-0701        AFD         2F          3   \n",
       "1            TRASH - Trash Fire    00-0501        AFD         3F          3   \n",
       "2              AUTO - Auto Fire    00-3111        AFD         2F         10   \n",
       "3      GRASS - Small Grass Fire    00-4004        AFD         3F          7   \n",
       "5          BBQ - Unsafe Cooking    00-2101        AFD         4F         10   \n",
       "...                         ...        ...        ...        ...        ...   \n",
       "19540          AUTO - Auto Fire    00-1603        AFD         2F          4   \n",
       "19541    ELEC - Electrical Fire    00-2901        AFD         3F          8   \n",
       "19543          AUTO - Auto Fire    00-4901        AFD         2F          5   \n",
       "19550  GRASS - Small Grass Fire    00-0601        AFD         3F          9   \n",
       "19551       BOX -Structure Fire    00-1504        AFD         1F          1   \n",
       "\n",
       "                         geometry  \n",
       "0      POINT (-97.72651 30.25049)  \n",
       "1      POINT (-97.68956 30.26480)  \n",
       "2      POINT (-97.83031 30.32466)  \n",
       "3      POINT (-97.67304 30.39916)  \n",
       "5      POINT (-97.74799 30.36069)  \n",
       "...                           ...  \n",
       "19540  POINT (-97.70707 30.32507)  \n",
       "19541  POINT (-97.84954 30.19812)  \n",
       "19543  POINT (-97.81206 30.10195)  \n",
       "19550  POINT (-97.73705 30.24897)  \n",
       "19551  POINT (-97.70264 30.27809)  \n",
       "\n",
       "[13718 rows x 12 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf_2018_2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017.drop(columns=[\"Battalion\",\"Response Status\"],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017.rename(columns={'MasterIncidentNumber': 'incidentnu','CalendarYear': 'calendarye','Month':'month','Call_Type':'call_type','Problem':'problem','Jurisdiction':'jurisdicti','PriorityDescription':'priorityde'}, inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017.rename(columns={'Districts':'council_di','ResponseArea':'responsear'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017[\"incidentnu\"] = gdf_2016_2017[\"incidentnu\"].str.replace(',', '').astype(int)\n",
    "gdf_2016_2017[\"calendarye\"] = gdf_2016_2017[\"calendarye\"].str.replace(',', '').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017[\"rough_date\"] = gdf_2016_2017[\"calendarye\"].apply(str) + \" \" + gdf_2016_2017[\"month\"] + \" \" + gdf_2016_2017[\"DayOfMonth\"].apply(str)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017[\"date_incda\"] = pd.to_datetime(gdf_2016_2017[\"rough_date\"], errors=\"raise\", format=\"%Y %b %d\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/anaconda3/lib/python3.9/site-packages/geopandas/geodataframe.py:1443: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  super().__setitem__(key, value)\n"
     ]
    }
   ],
   "source": [
    "gdf_2018_2020[\"date_incda\"] = pd.to_datetime(gdf_2018_2020[\"date_incda\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017.drop(columns=[\"DayOfMonth\",\"lat\",\"long\",\"Location 1\",\"rough_date\"],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>incidentnu</th>\n",
       "      <th>calendarye</th>\n",
       "      <th>month</th>\n",
       "      <th>call_type</th>\n",
       "      <th>problem</th>\n",
       "      <th>jurisdicti</th>\n",
       "      <th>responsear</th>\n",
       "      <th>priorityde</th>\n",
       "      <th>council_di</th>\n",
       "      <th>geometry</th>\n",
       "      <th>date_incda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16000015</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2004</td>\n",
       "      <td>3F</td>\n",
       "      <td>5.0</td>\n",
       "      <td>POINT (-97.80616 30.21884)</td>\n",
       "      <td>2016-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16000017</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3606</td>\n",
       "      <td>3F</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POINT (-97.78623 30.18327)</td>\n",
       "      <td>2016-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16000038</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BBQ - Unsafe Cooking</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3102</td>\n",
       "      <td>4F</td>\n",
       "      <td>10.0</td>\n",
       "      <td>POINT (-97.79127 30.36374)</td>\n",
       "      <td>2016-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16000045</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1801</td>\n",
       "      <td>3F</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POINT (-97.66599 30.31872)</td>\n",
       "      <td>2016-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16000069</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2402</td>\n",
       "      <td>3F</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POINT (-97.73908 30.19577)</td>\n",
       "      <td>2016-01-01</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2786</th>\n",
       "      <td>17028757</td>\n",
       "      <td>2017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2101</td>\n",
       "      <td>3F</td>\n",
       "      <td>10.0</td>\n",
       "      <td>POINT (-97.74667 30.35869)</td>\n",
       "      <td>2017-03-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2787</th>\n",
       "      <td>17062308</td>\n",
       "      <td>2017</td>\n",
       "      <td>Jun</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0801</td>\n",
       "      <td>3F</td>\n",
       "      <td>4.0</td>\n",
       "      <td>POINT (-97.72340 30.37216)</td>\n",
       "      <td>2017-06-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2788</th>\n",
       "      <td>17072490</td>\n",
       "      <td>2017</td>\n",
       "      <td>Jul</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2801</td>\n",
       "      <td>3F</td>\n",
       "      <td>7.0</td>\n",
       "      <td>POINT (-97.67909 30.40276)</td>\n",
       "      <td>2017-07-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2789</th>\n",
       "      <td>17028592</td>\n",
       "      <td>2017</td>\n",
       "      <td>Mar</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2503</td>\n",
       "      <td>3F</td>\n",
       "      <td>10.0</td>\n",
       "      <td>POINT (-97.74831 30.39417)</td>\n",
       "      <td>2017-03-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>17127292</td>\n",
       "      <td>2017</td>\n",
       "      <td>Dec</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4204</td>\n",
       "      <td>3F</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POINT (-97.67086 30.20227)</td>\n",
       "      <td>2017-12-29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3481 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      incidentnu  calendarye month call_type                   problem  \\\n",
       "0       16000015        2016   Jan      Fire        TRASH - Trash Fire   \n",
       "1       16000017        2016   Jan      Fire        TRASH - Trash Fire   \n",
       "2       16000038        2016   Jan      Fire      BBQ - Unsafe Cooking   \n",
       "3       16000045        2016   Jan      Fire      DUMP - Dumpster Fire   \n",
       "4       16000069        2016   Jan      Fire        TRASH - Trash Fire   \n",
       "...          ...         ...   ...       ...                       ...   \n",
       "2786    17028757        2017   Mar      Fire  GRASS - Small Grass Fire   \n",
       "2787    17062308        2017   Jun      Fire    ELEC - Electrical Fire   \n",
       "2788    17072490        2017   Jul      Fire    ELEC - Electrical Fire   \n",
       "2789    17028592        2017   Mar      Fire  GRASS - Small Grass Fire   \n",
       "2790    17127292        2017   Dec      Fire    ELEC - Electrical Fire   \n",
       "\n",
       "     jurisdicti responsear priorityde  council_di                    geometry  \\\n",
       "0           AFD    00-2004         3F         5.0  POINT (-97.80616 30.21884)   \n",
       "1           AFD    00-3606         3F         2.0  POINT (-97.78623 30.18327)   \n",
       "2           AFD    00-3102         4F        10.0  POINT (-97.79127 30.36374)   \n",
       "3           AFD    00-1801         3F         1.0  POINT (-97.66599 30.31872)   \n",
       "4           AFD    00-2402         3F         2.0  POINT (-97.73908 30.19577)   \n",
       "...         ...        ...        ...         ...                         ...   \n",
       "2786        AFD    00-2101         3F        10.0  POINT (-97.74667 30.35869)   \n",
       "2787        AFD    00-0801         3F         4.0  POINT (-97.72340 30.37216)   \n",
       "2788        AFD    00-2801         3F         7.0  POINT (-97.67909 30.40276)   \n",
       "2789        AFD    00-2503         3F        10.0  POINT (-97.74831 30.39417)   \n",
       "2790        AFD    00-4204         3F         2.0  POINT (-97.67086 30.20227)   \n",
       "\n",
       "     date_incda  \n",
       "0    2016-01-01  \n",
       "1    2016-01-01  \n",
       "2    2016-01-01  \n",
       "3    2016-01-01  \n",
       "4    2016-01-01  \n",
       "...         ...  \n",
       "2786 2017-03-23  \n",
       "2787 2017-06-26  \n",
       "2788 2017-07-25  \n",
       "2789 2017-03-23  \n",
       "2790 2017-12-29  \n",
       "\n",
       "[3481 rows x 11 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf_2016_2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/z3/kchg1fx10r126g5rwh_ntl5w0000gp/T/ipykernel_4783/4010629409.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  gdf_2018_2020.drop(columns=[\"time_incda\"],inplace=True)\n"
     ]
    }
   ],
   "source": [
    "gdf_2018_2020.drop(columns=[\"time_incda\"],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2017 = gdf_2016_2017.to_crs(\"EPSG:4326\")\n",
    "gdf_2018_2020 = gdf_2018_2020.to_crs(\"EPSG:4326\")\n",
    "gdf_2016_2020 = pd.concat([gdf_2016_2017,gdf_2018_2020])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_2016_2020.drop(columns=[\"date_incda\"],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>incidentnu</th>\n",
       "      <th>calendarye</th>\n",
       "      <th>month</th>\n",
       "      <th>call_type</th>\n",
       "      <th>problem</th>\n",
       "      <th>jurisdicti</th>\n",
       "      <th>responsear</th>\n",
       "      <th>priorityde</th>\n",
       "      <th>council_di</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16000015</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2004</td>\n",
       "      <td>3F</td>\n",
       "      <td>5.0</td>\n",
       "      <td>POINT (-97.80616 30.21884)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16000017</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3606</td>\n",
       "      <td>3F</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POINT (-97.78623 30.18327)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16000038</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BBQ - Unsafe Cooking</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-3102</td>\n",
       "      <td>4F</td>\n",
       "      <td>10.0</td>\n",
       "      <td>POINT (-97.79127 30.36374)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16000045</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>DUMP - Dumpster Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1801</td>\n",
       "      <td>3F</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POINT (-97.66599 30.31872)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16000069</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>TRASH - Trash Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2402</td>\n",
       "      <td>3F</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POINT (-97.73908 30.19577)</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19540</th>\n",
       "      <td>18046570</td>\n",
       "      <td>2018</td>\n",
       "      <td>May</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1603</td>\n",
       "      <td>2F</td>\n",
       "      <td>4</td>\n",
       "      <td>POINT (-97.70707 30.32507)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19541</th>\n",
       "      <td>19000553</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Fire</td>\n",
       "      <td>ELEC - Electrical Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-2901</td>\n",
       "      <td>3F</td>\n",
       "      <td>8</td>\n",
       "      <td>POINT (-97.84954 30.19812)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19543</th>\n",
       "      <td>20025519</td>\n",
       "      <td>2020</td>\n",
       "      <td>Mar</td>\n",
       "      <td>Fire</td>\n",
       "      <td>AUTO - Auto Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-4901</td>\n",
       "      <td>2F</td>\n",
       "      <td>5</td>\n",
       "      <td>POINT (-97.81206 30.10195)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19550</th>\n",
       "      <td>20046507</td>\n",
       "      <td>2020</td>\n",
       "      <td>May</td>\n",
       "      <td>Fire</td>\n",
       "      <td>GRASS - Small Grass Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-0601</td>\n",
       "      <td>3F</td>\n",
       "      <td>9</td>\n",
       "      <td>POINT (-97.73705 30.24897)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19551</th>\n",
       "      <td>18107045</td>\n",
       "      <td>2018</td>\n",
       "      <td>Oct</td>\n",
       "      <td>Fire</td>\n",
       "      <td>BOX -Structure Fire</td>\n",
       "      <td>AFD</td>\n",
       "      <td>00-1504</td>\n",
       "      <td>1F</td>\n",
       "      <td>1</td>\n",
       "      <td>POINT (-97.70264 30.27809)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17199 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      incidentnu  calendarye month call_type                   problem  \\\n",
       "0       16000015        2016   Jan      Fire        TRASH - Trash Fire   \n",
       "1       16000017        2016   Jan      Fire        TRASH - Trash Fire   \n",
       "2       16000038        2016   Jan      Fire      BBQ - Unsafe Cooking   \n",
       "3       16000045        2016   Jan      Fire      DUMP - Dumpster Fire   \n",
       "4       16000069        2016   Jan      Fire        TRASH - Trash Fire   \n",
       "...          ...         ...   ...       ...                       ...   \n",
       "19540   18046570        2018   May      Fire          AUTO - Auto Fire   \n",
       "19541   19000553        2019   Jan      Fire    ELEC - Electrical Fire   \n",
       "19543   20025519        2020   Mar      Fire          AUTO - Auto Fire   \n",
       "19550   20046507        2020   May      Fire  GRASS - Small Grass Fire   \n",
       "19551   18107045        2018   Oct      Fire       BOX -Structure Fire   \n",
       "\n",
       "      jurisdicti responsear priorityde council_di                    geometry  \n",
       "0            AFD    00-2004         3F        5.0  POINT (-97.80616 30.21884)  \n",
       "1            AFD    00-3606         3F        2.0  POINT (-97.78623 30.18327)  \n",
       "2            AFD    00-3102         4F       10.0  POINT (-97.79127 30.36374)  \n",
       "3            AFD    00-1801         3F        1.0  POINT (-97.66599 30.31872)  \n",
       "4            AFD    00-2402         3F        2.0  POINT (-97.73908 30.19577)  \n",
       "...          ...        ...        ...        ...                         ...  \n",
       "19540        AFD    00-1603         2F          4  POINT (-97.70707 30.32507)  \n",
       "19541        AFD    00-2901         3F          8  POINT (-97.84954 30.19812)  \n",
       "19543        AFD    00-4901         2F          5  POINT (-97.81206 30.10195)  \n",
       "19550        AFD    00-0601         3F          9  POINT (-97.73705 30.24897)  \n",
       "19551        AFD    00-1504         1F          1  POINT (-97.70264 30.27809)  \n",
       "\n",
       "[17199 rows x 10 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf_2016_2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "#gdf_2016_2020.to_file(\"fire_incidents_v2.shp\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.15"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "40d3a090f54c6569ab1632332b64b2c03c39dcf918b08424e98f38b5ae0af88f"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}