ProcessAICC_explore.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "import glob\n",
    "import datetime as dt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import blmfire as blm\n",
    "from importlib import reload\n",
    "from sklearn.feature_extraction.text import CountVectorizer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "testfile_current = \"./testdata/blmfiredata.txt\"\n",
    "testfile_prev = \"./testdata/20170713_065905_blmfiredata.txt\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fieldmap = blm.FIELDMAP\n",
    "fieldmap['lastupdatedatetime'] = 'firesadmin.dailyfirerecord.lastupdatedatetime'\n",
    "fieldmap['discoverydatetime'] = 'firesadmin.fire.discoverydatetime'\n",
    "fieldmap['guid'] = 'firesadmin.fire.irwinid'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def get_data(fn):\n",
    "    data = blm.get_raw_fire_data(fn, tryremote=False)\n",
    "    fieldnames = blm.sanitize_dataline(data[0], blanks=3, lower=True)\n",
    "    rawdata = [blm.sanitize_dataline(\n",
    "                item.strip(), blanks=2, lower=False) for item in data[1::2]]\n",
    "    \n",
    "    # the transformed data will be a list of dictionaries\n",
    "    data = blm.get_firedata(fieldnames, rawdata)\n",
    "    return fieldnames, data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fieldnames, data = get_data(testfile_current)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "_, data_prev = get_data(testfile_prev)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def cleanup_df(dataframe):\n",
    "    dataframe['discoverydatetime'] = pd.to_datetime(dataframe['discoverydatetime'], unit='ms')\n",
    "    dataframe['lastupdatedatetime'] = pd.to_datetime(dataframe['lastupdatedatetime'], unit='ms')\n",
    "    dataframe['containmentdatetime'] = pd.to_datetime(dataframe['containmentdatetime'], unit='ms')\n",
    "    try:\n",
    "        dataframe['controldatetime'] = pd.to_datetime(dataframe['controldatetime'], unit='ms')\n",
    "    except KeyError:  # can be empty\n",
    "        pass\n",
    "    dataframe['acreage'] = pd.to_numeric(dataframe['acreage'])\n",
    "    return dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_current = pd.DataFrame(data)[list(fieldmap.values())]\n",
    "df_current.columns = [list(fieldmap.keys())]\n",
    "df_prev = pd.DataFrame(data_prev)[list(fieldmap.values())]\n",
    "df_prev.columns = [list(fieldmap.keys())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'containmentdatetime'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m/Users/cwaigl/anaconda2/envs/snowflakes35/lib/python3.5/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2441\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2442\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2443\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc (pandas/_libs/index.c:5280)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc (pandas/_libs/index.c:5126)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item (pandas/_libs/hashtable.c:20523)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item (pandas/_libs/hashtable.c:20477)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'containmentdatetime'",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-11-66b05a9498d3>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf_current\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcleanup_df\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf_current\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0mdf_prev\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcleanup_df\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf_prev\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-7-a2a5741fa519>\u001b[0m in \u001b[0;36mcleanup_df\u001b[0;34m(dataframe)\u001b[0m\n\u001b[1;32m      2\u001b[0m     \u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'discoverydatetime'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_datetime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'discoverydatetime'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0munit\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ms'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m     \u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'lastupdatedatetime'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_datetime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'lastupdatedatetime'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0munit\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ms'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m     \u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'containmentdatetime'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_datetime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'containmentdatetime'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0munit\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ms'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m     \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m         \u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'controldatetime'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_datetime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdataframe\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'controldatetime'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0munit\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ms'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/cwaigl/anaconda2/envs/snowflakes35/lib/python3.5/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   1962\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1963\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1964\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1965\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1966\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_getitem_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/cwaigl/anaconda2/envs/snowflakes35/lib/python3.5/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m_getitem_column\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   1969\u001b[0m         \u001b[0;31m# get column\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1970\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_unique\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1971\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_item_cache\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1972\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1973\u001b[0m         \u001b[0;31m# duplicate columns & possible reduce dimensionality\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/cwaigl/anaconda2/envs/snowflakes35/lib/python3.5/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m_get_item_cache\u001b[0;34m(self, item)\u001b[0m\n\u001b[1;32m   1643\u001b[0m         \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcache\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1644\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mres\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1645\u001b[0;31m             \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1646\u001b[0m             \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_box_item_values\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1647\u001b[0m             \u001b[0mcache\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mres\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/cwaigl/anaconda2/envs/snowflakes35/lib/python3.5/site-packages/pandas/core/internals.py\u001b[0m in \u001b[0;36mget\u001b[0;34m(self, item, fastpath)\u001b[0m\n\u001b[1;32m   3588\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3589\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misnull\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3590\u001b[0;31m                 \u001b[0mloc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3591\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3592\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0marange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0misnull\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/cwaigl/anaconda2/envs/snowflakes35/lib/python3.5/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2442\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2443\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2444\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_maybe_cast_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2445\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2446\u001b[0m         \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc (pandas/_libs/index.c:5280)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc (pandas/_libs/index.c:5126)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item (pandas/_libs/hashtable.c:20523)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item (pandas/_libs/hashtable.c:20477)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'containmentdatetime'"
     ]
    }
   ],
   "source": [
    "df_current = cleanup_df(df_current)\n",
    "df_prev = cleanup_df(df_prev)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "',cause,maintext,discoverydatetime,structuresburned,structuresthreatened,longitude,guid,lastupdatedatetime,numberpeople,designation,primaryfueltype,acreage,latitude\\n36,Lightning,Zone aircraft N309VS flew the fire area today. Fire personnel reported no change in size or fire behavior. Update in acreage due to more accurate mapping.,1497633911529,0,0,-153.4959444,8976669B-225E-490A-B614-1C4177A29BCB,1497962880529,0,North Kusko,Black Spruce,19.6,63.6799445\\n55,Lightning,Landsat imagery confirmed initial coordinates and fire size.,1499015708544,0,0,-141.9646944,D5E3FDDD-7110-4B2E-BFDD-309649EA21F1,1499514660544,0,Martin Creek,Tundra,3.1,68.0495556\\n56,Lightning,The fire was flown by zone aircraft N9011N. No fire activity was observed.,1499015926544,0,0,-141.9171667,D078470D-8A60-480F-8647-45B43214A593,1499626560544,0,Coleen River,Tundra,0.1,68.0861667\\n'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prev[~df_prev['designation'].isin(df_current['designation'])].to_csv()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cause</th>\n",
       "      <th>maintext</th>\n",
       "      <th>discoverydatetime</th>\n",
       "      <th>structuresburned</th>\n",
       "      <th>structuresthreatened</th>\n",
       "      <th>longitude</th>\n",
       "      <th>guid</th>\n",
       "      <th>lastupdatedatetime</th>\n",
       "      <th>numberpeople</th>\n",
       "      <th>designation</th>\n",
       "      <th>primaryfueltype</th>\n",
       "      <th>acreage</th>\n",
       "      <th>latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>The fire was discovered by zone aircraft N222M...</td>\n",
       "      <td>2017-07-13 17:15:04.730</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-144.6955833</td>\n",
       "      <td>C6ED6EFA-EBCF-4B58-8AAA-260BEBBDA871</td>\n",
       "      <td>2017-07-13 19:52:00.730</td>\n",
       "      <td>0</td>\n",
       "      <td>WL 543T</td>\n",
       "      <td>Black Spruce</td>\n",
       "      <td>1</td>\n",
       "      <td>67.0030278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>A small column of smoke was reported to the du...</td>\n",
       "      <td>2017-07-13 08:10:24.731</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-144.316667</td>\n",
       "      <td>607BB758-6C06-4E35-8A4A-9B5EFEF53D52</td>\n",
       "      <td>2017-07-14 04:03:45.731</td>\n",
       "      <td>0</td>\n",
       "      <td>George Lake Hills</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0</td>\n",
       "      <td>63.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        cause                                           maintext  \\\n",
       "46  Lightning  The fire was discovered by zone aircraft N222M...   \n",
       "47  Lightning  A small column of smoke was reported to the du...   \n",
       "\n",
       "         discoverydatetime structuresburned structuresthreatened  \\\n",
       "46 2017-07-13 17:15:04.730                0                    0   \n",
       "47 2017-07-13 08:10:24.731                0                    0   \n",
       "\n",
       "       longitude                                  guid  \\\n",
       "46  -144.6955833  C6ED6EFA-EBCF-4B58-8AAA-260BEBBDA871   \n",
       "47   -144.316667  607BB758-6C06-4E35-8A4A-9B5EFEF53D52   \n",
       "\n",
       "        lastupdatedatetime numberpeople        designation primaryfueltype  \\\n",
       "46 2017-07-13 19:52:00.730            0            WL 543T    Black Spruce   \n",
       "47 2017-07-14 04:03:45.731            0  George Lake Hills         Unknown   \n",
       "\n",
       "   acreage    latitude  \n",
       "46       1  67.0030278  \n",
       "47       0       63.75  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_current[~df_current['designation'].isin(df_prev['designation'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cause</th>\n",
       "      <th>maintext</th>\n",
       "      <th>discoverydatetime</th>\n",
       "      <th>structuresburned</th>\n",
       "      <th>structuresthreatened</th>\n",
       "      <th>longitude</th>\n",
       "      <th>guid</th>\n",
       "      <th>lastupdatedatetime</th>\n",
       "      <th>numberpeople</th>\n",
       "      <th>designation</th>\n",
       "      <th>primaryfueltype</th>\n",
       "      <th>acreage</th>\n",
       "      <th>latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [cause, maintext, discoverydatetime, structuresburned, structuresthreatened, longitude, guid, lastupdatedatetime, numberpeople, designation, primaryfueltype, acreage, latitude]\n",
       "Index: []"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "today = dt.datetime.now()\n",
    "df_current.loc[(today - df_current['lastupdatedatetime'] < dt.timedelta(days=2))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>lastupdatedatetime</th>\n",
       "      <th>acreage</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>guid</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>231B0E11-EA79-4FFD-A44C-84130064B858</th>\n",
       "      <td>1499591820513</td>\n",
       "      <td>178.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8719131D-F468-481F-A61A-8DF15C13887B</th>\n",
       "      <td>1499164800513</td>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3CE4F630-EF46-49EF-9A2D-3186E3DCE0C7</th>\n",
       "      <td>1499551500513</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E1963C4B-0888-4A60-B5B8-D8FFA8B8DF3A</th>\n",
       "      <td>1499892540513</td>\n",
       "      <td>356.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B18CE0AB-470E-49A5-97B5-3B1790C668C9</th>\n",
       "      <td>1499206260513</td>\n",
       "      <td>332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5F36D2F7-347D-4FBA-8C2C-0B21984A7607</th>\n",
       "      <td>1499449860513</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1E5D3F64-62ED-4149-AB71-53535BDD0504</th>\n",
       "      <td>1499892360513</td>\n",
       "      <td>22227.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8FC76EFB-5229-42B5-8ED8-D1F9B325106A</th>\n",
       "      <td>1499881380513</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21207F32-B0BD-42F8-A1FA-C4A7AC6EC464</th>\n",
       "      <td>1499754660513</td>\n",
       "      <td>235.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7391C476-78BC-4C8D-A100-61644BBF6828</th>\n",
       "      <td>1499889060513</td>\n",
       "      <td>10188.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55246098-9363-4C87-83DC-9365AAE42444</th>\n",
       "      <td>1499668440513</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3D216138-6824-46B8-9254-835C46E21EF1</th>\n",
       "      <td>1499584140513</td>\n",
       "      <td>21.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86A07501-8395-4D5D-B812-A18DA398F01D</th>\n",
       "      <td>1499815980513</td>\n",
       "      <td>23673.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E62589A2-BEEB-4C62-B7E3-B5AB44788049</th>\n",
       "      <td>1499583900513</td>\n",
       "      <td>514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0B2B8CCE-46B4-4A29-8D4E-4E05EBE30105</th>\n",
       "      <td>1499801460513</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1A9701F4-2CC0-4B80-8456-92F8BB4CD593</th>\n",
       "      <td>1499400005513</td>\n",
       "      <td>1016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F9D1A784-3DDF-438E-831C-C3772FF4D5EA</th>\n",
       "      <td>1499552880513</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1C166729-9871-415C-AB4E-D72CA0EAB2B1</th>\n",
       "      <td>1499668500513</td>\n",
       "      <td>8344.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DF352EC9-385F-45EE-A1D6-028A5144C433</th>\n",
       "      <td>1499626080513</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9F95EFE7-6DB9-43C3-8984-9E2BEA50B6BE</th>\n",
       "      <td>1499616900513</td>\n",
       "      <td>14.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F86DF691-23C6-40D2-BB4C-52E624145FAF</th>\n",
       "      <td>1499469060513</td>\n",
       "      <td>2876.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C0BD59B1-6D5C-4552-9E7C-201571B6EFCB</th>\n",
       "      <td>1499616900513</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C1446D0C-39BF-46C9-BD52-E709BD0B7902</th>\n",
       "      <td>1499894400513</td>\n",
       "      <td>33100.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <td>1497931205513</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94939C6A-B76A-4926-859B-88FAB24F67FA</th>\n",
       "      <td>1497931205529</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C65F6C92-E038-4C72-BB2E-990EE1B4532B</th>\n",
       "      <td>1497651120529</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC5D8B8C-8437-4C56-8822-187E33619168</th>\n",
       "      <td>1499895060529</td>\n",
       "      <td>23383.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2B4F6923-8854-45F4-86B3-501F635FE76F</th>\n",
       "      <td>1499583660529</td>\n",
       "      <td>2583.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A5ED7846-822B-48D6-811C-6958088DE0CD</th>\n",
       "      <td>1496965920529</td>\n",
       "      <td>5.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D3AAABF1-D21F-4768-A605-4698B313BEEB</th>\n",
       "      <td>1499313606529</td>\n",
       "      <td>16514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B272457B-0306-41B4-903F-ABE3D6DC12F3</th>\n",
       "      <td>1497521460529</td>\n",
       "      <td>51.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91068E54-7C07-4C4F-AA8A-B44162E3903D</th>\n",
       "      <td>1499313605529</td>\n",
       "      <td>12945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8976669B-225E-490A-B614-1C4177A29BCB</th>\n",
       "      <td>1497962880529</td>\n",
       "      <td>19.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89EDCE37-D59E-4073-BA8F-28348BBFA492</th>\n",
       "      <td>1499895180529</td>\n",
       "      <td>338.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4E655EFA-5A64-4442-93BC-20A0CDA12342</th>\n",
       "      <td>1499881772529</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0B8D7795-C042-4165-A540-C22C3FFEFA8B</th>\n",
       "      <td>1499431620529</td>\n",
       "      <td>45.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CB846635-C8CB-4734-8DC9-2C787C6C58F6</th>\n",
       "      <td>1499888460529</td>\n",
       "      <td>56227.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14025835-30F7-4E28-B709-4B1A34BBC458</th>\n",
       "      <td>1499164500529</td>\n",
       "      <td>1647.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CD900D9B-9773-49E1-A693-F8B11B5C378E</th>\n",
       "      <td>1499076960529</td>\n",
       "      <td>2870.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7E55427E-8529-44D4-B927-C1DCE2BE0B45</th>\n",
       "      <td>1499313605529</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142D0B21-2C27-4B8A-875A-BC2E0B63ECF5</th>\n",
       "      <td>1499313606529</td>\n",
       "      <td>16823.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1D8128D1-BB46-4052-A5FB-8CF15924AC7E</th>\n",
       "      <td>1499409000529</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3BCA8DE3-A9AE-4617-999D-6DC536FB9362</th>\n",
       "      <td>1499626140529</td>\n",
       "      <td>2549.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1BFBD1FA-A1C2-44AF-872F-F3F33B20D146</th>\n",
       "      <td>1499723520529</td>\n",
       "      <td>11757.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>022B3833-8BAA-4CF8-AC50-CF235F065649</th>\n",
       "      <td>1499754960529</td>\n",
       "      <td>15797.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5D51BD09-96C4-4973-868C-9DB8D08EA242</th>\n",
       "      <td>1497785760529</td>\n",
       "      <td>11.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A61F4906-8340-4905-AC58-E9F2007E95CC</th>\n",
       "      <td>1499843640529</td>\n",
       "      <td>514.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2C007BB1-9855-425F-A852-6C69C2DE4A9A</th>\n",
       "      <td>1499313605529</td>\n",
       "      <td>13924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DB9F9DD4-AA84-41A2-9DBD-321A58BF6D90</th>\n",
       "      <td>1499771040529</td>\n",
       "      <td>491.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBEEBD25-594D-43BD-B474-263954852A86</th>\n",
       "      <td>1498708805544</td>\n",
       "      <td>832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42B24ADA-4F12-4E48-BA50-D52A1D8E7311</th>\n",
       "      <td>1499616420544</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D5E3FDDD-7110-4B2E-BFDD-309649EA21F1</th>\n",
       "      <td>1499514660544</td>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D078470D-8A60-480F-8647-45B43214A593</th>\n",
       "      <td>1499626560544</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D9326B52-1219-470D-A745-D0B75A5271E8</th>\n",
       "      <td>1498576920544</td>\n",
       "      <td>306.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C98E06E8-0F8C-45AF-949D-70CF6458E703</th>\n",
       "      <td>1499313606544</td>\n",
       "      <td>2653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6BE59E0A-1E92-4FDE-8112-4E03D05C4B94</th>\n",
       "      <td>1499889240544</td>\n",
       "      <td>3130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B5454133-E82F-4255-81C4-AAE28C7E284C</th>\n",
       "      <td>1499537580544</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A2974B0D-45D4-4B36-BB53-7FB91EC100F9</th>\n",
       "      <td>1498855740544</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4EEFEF37-FCD0-48B1-844C-31AA9507A756</th>\n",
       "      <td>1499754720544</td>\n",
       "      <td>380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BF193C80-A9FC-41DE-A790-0756CB58450C</th>\n",
       "      <td>1499809500544</td>\n",
       "      <td>2228.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     lastupdatedatetime  acreage\n",
       "guid                                                            \n",
       "231B0E11-EA79-4FFD-A44C-84130064B858      1499591820513    178.2\n",
       "8719131D-F468-481F-A61A-8DF15C13887B      1499164800513      4.7\n",
       "3CE4F630-EF46-49EF-9A2D-3186E3DCE0C7      1499551500513       20\n",
       "E1963C4B-0888-4A60-B5B8-D8FFA8B8DF3A      1499892540513    356.8\n",
       "B18CE0AB-470E-49A5-97B5-3B1790C668C9      1499206260513      332\n",
       "5F36D2F7-347D-4FBA-8C2C-0B21984A7607      1499449860513       25\n",
       "1E5D3F64-62ED-4149-AB71-53535BDD0504      1499892360513  22227.3\n",
       "8FC76EFB-5229-42B5-8ED8-D1F9B325106A      1499881380513        4\n",
       "21207F32-B0BD-42F8-A1FA-C4A7AC6EC464      1499754660513    235.4\n",
       "7391C476-78BC-4C8D-A100-61644BBF6828      1499889060513  10188.8\n",
       "55246098-9363-4C87-83DC-9365AAE42444      1499668440513        1\n",
       "3D216138-6824-46B8-9254-835C46E21EF1      1499584140513     21.8\n",
       "86A07501-8395-4D5D-B812-A18DA398F01D      1499815980513  23673.6\n",
       "E62589A2-BEEB-4C62-B7E3-B5AB44788049      1499583900513      514\n",
       "0B2B8CCE-46B4-4A29-8D4E-4E05EBE30105      1499801460513       25\n",
       "1A9701F4-2CC0-4B80-8456-92F8BB4CD593      1499400005513     1016\n",
       "F9D1A784-3DDF-438E-831C-C3772FF4D5EA      1499552880513       30\n",
       "1C166729-9871-415C-AB4E-D72CA0EAB2B1      1499668500513   8344.9\n",
       "DF352EC9-385F-45EE-A1D6-028A5144C433      1499626080513        1\n",
       "9F95EFE7-6DB9-43C3-8984-9E2BEA50B6BE      1499616900513     14.6\n",
       "F86DF691-23C6-40D2-BB4C-52E624145FAF      1499469060513   2876.5\n",
       "C0BD59B1-6D5C-4552-9E7C-201571B6EFCB      1499616900513      200\n",
       "C1446D0C-39BF-46C9-BD52-E709BD0B7902      1499894400513  33100.3\n",
       "                                          1497931205513      0.5\n",
       "94939C6A-B76A-4926-859B-88FAB24F67FA      1497931205529      1.5\n",
       "C65F6C92-E038-4C72-BB2E-990EE1B4532B      1497651120529      0.4\n",
       "DC5D8B8C-8437-4C56-8822-187E33619168      1499895060529  23383.9\n",
       "2B4F6923-8854-45F4-86B3-501F635FE76F      1499583660529   2583.5\n",
       "A5ED7846-822B-48D6-811C-6958088DE0CD      1496965920529      5.2\n",
       "D3AAABF1-D21F-4768-A605-4698B313BEEB      1499313606529    16514\n",
       "...                                                 ...      ...\n",
       "B272457B-0306-41B4-903F-ABE3D6DC12F3      1497521460529     51.6\n",
       "91068E54-7C07-4C4F-AA8A-B44162E3903D      1499313605529    12945\n",
       "8976669B-225E-490A-B614-1C4177A29BCB      1497962880529     19.6\n",
       "89EDCE37-D59E-4073-BA8F-28348BBFA492      1499895180529    338.6\n",
       "4E655EFA-5A64-4442-93BC-20A0CDA12342      1499881772529      2.8\n",
       "0B8D7795-C042-4165-A540-C22C3FFEFA8B      1499431620529     45.2\n",
       "CB846635-C8CB-4734-8DC9-2C787C6C58F6      1499888460529  56227.4\n",
       "14025835-30F7-4E28-B709-4B1A34BBC458      1499164500529   1647.4\n",
       "CD900D9B-9773-49E1-A693-F8B11B5C378E      1499076960529   2870.3\n",
       "7E55427E-8529-44D4-B927-C1DCE2BE0B45      1499313605529      127\n",
       "142D0B21-2C27-4B8A-875A-BC2E0B63ECF5      1499313606529  16823.9\n",
       "1D8128D1-BB46-4052-A5FB-8CF15924AC7E      1499409000529      0.2\n",
       "3BCA8DE3-A9AE-4617-999D-6DC536FB9362      1499626140529   2549.3\n",
       "1BFBD1FA-A1C2-44AF-872F-F3F33B20D146      1499723520529  11757.7\n",
       "022B3833-8BAA-4CF8-AC50-CF235F065649      1499754960529  15797.9\n",
       "5D51BD09-96C4-4973-868C-9DB8D08EA242      1497785760529     11.5\n",
       "A61F4906-8340-4905-AC58-E9F2007E95CC      1499843640529    514.5\n",
       "2C007BB1-9855-425F-A852-6C69C2DE4A9A      1499313605529    13924\n",
       "DB9F9DD4-AA84-41A2-9DBD-321A58BF6D90      1499771040529    491.6\n",
       "CBEEBD25-594D-43BD-B474-263954852A86      1498708805544      832\n",
       "42B24ADA-4F12-4E48-BA50-D52A1D8E7311      1499616420544      200\n",
       "D5E3FDDD-7110-4B2E-BFDD-309649EA21F1      1499514660544      3.1\n",
       "D078470D-8A60-480F-8647-45B43214A593      1499626560544      0.1\n",
       "D9326B52-1219-470D-A745-D0B75A5271E8      1498576920544    306.8\n",
       "C98E06E8-0F8C-45AF-949D-70CF6458E703      1499313606544     2653\n",
       "6BE59E0A-1E92-4FDE-8112-4E03D05C4B94      1499889240544     3130\n",
       "B5454133-E82F-4255-81C4-AAE28C7E284C      1499537580544       90\n",
       "A2974B0D-45D4-4B36-BB53-7FB91EC100F9      1498855740544      0.2\n",
       "4EEFEF37-FCD0-48B1-844C-31AA9507A756      1499754720544      380\n",
       "BF193C80-A9FC-41DE-A790-0756CB58450C      1499809500544   2228.8\n",
       "\n",
       "[64 rows x 2 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prev.set_index('guid')[['lastupdatedatetime', 'acreage']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_joined = df_current.join(df_prev.set_index('guid')[['lastupdatedatetime', 'acreage', 'maintext']], on='guid', rsuffix='_prev')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_joined['delta_acres'] = df_joined['acreage'] - df_joined['acreage_prev']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_joined.iloc[[6, 9,12, 22, 23, 27, 47, 49, 51, 55]][['designation', 'latitude', 'longitude', 'delta_acres']].to_csv('testout')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cause</th>\n",
       "      <th>longitude</th>\n",
       "      <th>guid</th>\n",
       "      <th>structuresburned</th>\n",
       "      <th>acreage</th>\n",
       "      <th>maintext</th>\n",
       "      <th>designation</th>\n",
       "      <th>discoverydatetime</th>\n",
       "      <th>latitude</th>\n",
       "      <th>primaryfueltype</th>\n",
       "      <th>numberpeople</th>\n",
       "      <th>structuresthreatened</th>\n",
       "      <th>lastupdatedatetime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>-141.3181389</td>\n",
       "      <td>CB846635-C8CB-4734-8DC9-2C787C6C58F6</td>\n",
       "      <td>0</td>\n",
       "      <td>62800.9</td>\n",
       "      <td>The fire was flown by surveillance aircraft N2...</td>\n",
       "      <td>White Mountain Creek</td>\n",
       "      <td>2017-07-03 14:09:32.724</td>\n",
       "      <td>67.4532778</td>\n",
       "      <td>Black Spruce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-07-14 09:48:00.724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>-141.0150278</td>\n",
       "      <td>C1446D0C-39BF-46C9-BD52-E709BD0B7902</td>\n",
       "      <td>0</td>\n",
       "      <td>45521.7</td>\n",
       "      <td>At 1500 the fire was flown by zone surveillanc...</td>\n",
       "      <td>Campbell River</td>\n",
       "      <td>2017-06-26 17:14:24.711</td>\n",
       "      <td>67.2183056</td>\n",
       "      <td>Black Spruce</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-07-13 21:05:00.711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>-142.0123333</td>\n",
       "      <td>022B3833-8BAA-4CF8-AC50-CF235F065649</td>\n",
       "      <td>0</td>\n",
       "      <td>27629.4</td>\n",
       "      <td>Zone aircraft N222ME flew the fire and reporte...</td>\n",
       "      <td>Lois Creek</td>\n",
       "      <td>2017-07-02 17:28:36.733</td>\n",
       "      <td>68.2916667</td>\n",
       "      <td>Tussock</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-07-13 18:40:00.733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>-141.3226944</td>\n",
       "      <td>86A07501-8395-4D5D-B812-A18DA398F01D</td>\n",
       "      <td>0</td>\n",
       "      <td>23673.6</td>\n",
       "      <td>Zone aircraft N222ME flew the fire and reporte...</td>\n",
       "      <td>Ammerman Creek</td>\n",
       "      <td>2017-06-23 17:05:48.701</td>\n",
       "      <td>68.4175833</td>\n",
       "      <td>Black Spruce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-07-13 18:51:00.701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Lightning</td>\n",
       "      <td>-143.7333333</td>\n",
       "      <td>DC5D8B8C-8437-4C56-8822-187E33619168</td>\n",
       "      <td>0</td>\n",
       "      <td>23383.9</td>\n",
       "      <td>Zone surveillance aircraft N222ME flew the fir...</td>\n",
       "      <td>Boulder Creek</td>\n",
       "      <td>2017-07-02 15:12:31.714</td>\n",
       "      <td>67.45</td>\n",
       "      <td>Black Spruce</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-07-14 09:49:00.714</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        cause     longitude                                  guid  \\\n",
       "39  Lightning  -141.3181389  CB846635-C8CB-4734-8DC9-2C787C6C58F6   \n",
       "23  Lightning  -141.0150278  C1446D0C-39BF-46C9-BD52-E709BD0B7902   \n",
       "49  Lightning  -142.0123333  022B3833-8BAA-4CF8-AC50-CF235F065649   \n",
       "12  Lightning  -141.3226944  86A07501-8395-4D5D-B812-A18DA398F01D   \n",
       "27  Lightning  -143.7333333  DC5D8B8C-8437-4C56-8822-187E33619168   \n",
       "\n",
       "   structuresburned  acreage  \\\n",
       "39                0  62800.9   \n",
       "23                0  45521.7   \n",
       "49                0  27629.4   \n",
       "12                0  23673.6   \n",
       "27                0  23383.9   \n",
       "\n",
       "                                             maintext           designation  \\\n",
       "39  The fire was flown by surveillance aircraft N2...  White Mountain Creek   \n",
       "23  At 1500 the fire was flown by zone surveillanc...        Campbell River   \n",
       "49  Zone aircraft N222ME flew the fire and reporte...            Lois Creek   \n",
       "12  Zone aircraft N222ME flew the fire and reporte...        Ammerman Creek   \n",
       "27  Zone surveillance aircraft N222ME flew the fir...         Boulder Creek   \n",
       "\n",
       "         discoverydatetime    latitude primaryfueltype numberpeople  \\\n",
       "39 2017-07-03 14:09:32.724  67.4532778    Black Spruce            0   \n",
       "23 2017-06-26 17:14:24.711  67.2183056    Black Spruce           35   \n",
       "49 2017-07-02 17:28:36.733  68.2916667         Tussock            0   \n",
       "12 2017-06-23 17:05:48.701  68.4175833    Black Spruce            0   \n",
       "27 2017-07-02 15:12:31.714       67.45    Black Spruce           75   \n",
       "\n",
       "   structuresthreatened      lastupdatedatetime  \n",
       "39                    0 2017-07-14 09:48:00.724  \n",
       "23                    0 2017-07-13 21:05:00.711  \n",
       "49                    0 2017-07-13 18:40:00.733  \n",
       "12                    0 2017-07-13 18:51:00.701  \n",
       "27                    0 2017-07-14 09:49:00.714  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_current.sort_values('acreage', ascending=False, axis=0).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "condition_recent = (today - df_current['lastupdatedatetime'] < dt.timedelta(days=2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2,Zone surveillance aircraft N309VS flew the fire and reported no visible smoke.\\n3,\"On 7/13, the fire received precipitation and no dominant smokes were visible from the highway; however, drift smoke was present in the area. An unmanned UAS flew the fire and captured infrared images indicating areas of heat. On 7/14, all resources will demobilize from the fire and the fire will remain in monitor status. Fire size decreased to 332 acres due to more accurate mapping.\"\\n6,Zone surveillance aircraft N222ME flew the area of the fire but was unable to observe it due to heavy smoke.\\n7,The fire was demobilized and placed into monitor status.\\n9,Zone surveillance aircraft N222ME flew the fire and reported it with a 10 percent active perimeter. The fire behavior was described as smoldering in a spruce/hardwood/brush mix. Observations were taken under 40 percent cloud cover.\\n11,\"The fire was flown by zone aircraft N22ME. No smoke, growth or active perimeter was reported.\"\\n12,\"Zone aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering and creeping.  Personnel on board identified the largest amount activity on the southeast corner.  The fire remains west of Ammerman Creek and north of the Old Crow River.\"\\n15,\"Two recon flights were conducted over fire 231, neither found smoke. Personnel took approximately four tons of equipment and supplies off the fire by helicopter and ground. None of the connected suppression equipment was dismantled or taken off the fire.\"\\n20,\"Fire is contained and controlled, and will be placed into monitor status.\"\\n21,At 1545 zone surveillance aircraft N222ME flew reconnaissance over the fire. No smokes and no active perimeter were observed.\\n22,Increase in acreage matches latest perimeter.\\n23,At 1500 the fire was flown by zone surveillance aircraft N222ME. The fire was 25 percent active and was spreading to the north. Observed fire behavior included backing and torching in black spruce with 10 foot flame lengths. Weather observed included wind out of the north at 10 mph with 10 percent cloud cover and no precipitation.  Fire is most active on the SW edge.  A 12 mile line of fire has burned 2.10 miles south of the Salmon Trout allotment.   Resources on scene of the allotment and cabin continued to monitor weather and fuel conditions in preparation for a burnout operation. Higher relative humidities kept fuels damp and no burn was attempted. The Midnight Sun IHC began to pretreat areas around the allotment with water.  Tommorow personnel will continue monitoring conditions. A helicopter reconnaissance flight has been scheduled for tomorrow (7/14).\\n27,Zone surveillance aircraft N222ME flew the fire and reported it with a 30 percent active perimeter and spreading to the north. The fire was creeping and backing with isolated torching in black spruce. Observations were taken under 30 percent cloud cover with calm winds.   Personnel on the ground continued to improve upon the saw line around the allotment. An UAS (unmanned aircraft system) was launched and performed a recon over the fire.\\n30,The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\\n36,The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\\n37,The fire was flown by surveillance aircraft N222ME. Fire 312 has consumed fire 303.\\n39,The fire was flown by surveillance aircraft N222ME. The fire area was too smokey to make observations. New fire size result of update imaging.\\n43,Personnel began backhauling structure protection equipment.\\n46,\"The fire was discovered by zone aircraft N222ME during a detection flight. Personnel on board reported a 1 acre fire, 100 percent active, burning on flat terrain in black spruce. The fire plotted in a Limited suppression area and no values at risk were identified. The Upper Yukon Zone will continue to monitor this fire with aerial resources.\"\\n47,A small column of smoke was reported to the duty officer around 22:30 on 7/12 by a resident on Sand Lake.  Helitack responded after the fog and mist lifted on 7/13.  The reporter could no longer see any smoke once helitack was launched.  Helicopter 873HL thoroughly scanned the area and did not find any blackened ground or smoke.  It is planned to search the area on 7/14 when the weather is forecasted to be warmer and clearer.\\n49,\"Zone aircraft N222ME flew the fire and reported a 10 percent active perimeter.  Active burning was observed on the NE, NW and SE corners of the fire.  The fire continues to burn north of the Colleen River and west of Lois Creek.  Increase in acres reflects newer perimeter data.\"\\n51,\"Resources are facing a very active fire while protecting a cabin and 2 allotments.  Eight smokejumpers have been placed on the eastern portion of the allotments and are planning to burn out the area either late tonight or in the morning. The remaining 8 smokejumpers are prepping the rest of the allotments with hose lay and plumbing.  Zone aircraft H-361EH assisted the fire with supplies and bucket drops while N864SF assisted the smokejumpers on the ground with aerial observations and updates of the fire activity.  Depending on the success of the burnout operations, the fire could be mopped up within a few days time.\"\\n52,The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\\n55,\"Zone surveillance in aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering along the ridgetop. No additional growth was visible. The fire remained 2.15 miles northeast of a National Park Service cabin. Decrease in acreage due to more accurate mapping.\"\\n58,Identified areas of growth using Landsat 8 image acquired 7/11 @ 2300.  Updated size to 3130 acres.\\n59,Zone surveillance in aircraft N309VS flew the fire and reported no active perimeter. The western interior of the fire was smoldering.\\n61,Fire was flown by zone detection aircraft N222ME and no visible smoke or active perimeter was observed. Update in acreage is due to more accurate mapping.\\n62,Zone surveillance aircraft N22ME flew the fire and reported no activity. Observations were taken under clear skies.\\n'"
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_current[condition_recent]['maintext'].to_csv()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "count_vect = CountVectorizer()\n",
    "firetextcounts = count_vect.fit_transform(df_current[condition_recent]['maintext'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "count_vect.vocabulary_.get('no smoke')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2,Zone surveillance aircraft N309VS flew the fire and reported no visible smoke.\n",
      "3,\"On 7/13, the fire received precipitation and no dominant smokes were visible from the highway; however, drift smoke was present in the area. An unmanned UAS flew the fire and captured infrared images indicating areas of heat. On 7/14, all resources will demobilize from the fire and the fire will remain in monitor status. Fire size decreased to 332 acres due to more accurate mapping.\"\n",
      "6,Zone surveillance aircraft N222ME flew the area of the fire but was unable to observe it due to heavy smoke.\n",
      "7,The fire was demobilized and placed into monitor status.\n",
      "9,Zone surveillance aircraft N222ME flew the fire and reported it with a 10 percent active perimeter. The fire behavior was described as smoldering in a spruce/hardwood/brush mix. Observations were taken under 40 percent cloud cover.\n",
      "11,\"The fire was flown by zone aircraft N22ME. No smoke, growth or active perimeter was reported.\"\n",
      "12,\"Zone aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering and creeping.  Personnel on board identified the largest amount activity on the southeast corner.  The fire remains west of Ammerman Creek and north of the Old Crow River.\"\n",
      "15,\"Two recon flights were conducted over fire 231, neither found smoke. Personnel took approximately four tons of equipment and supplies off the fire by helicopter and ground. None of the connected suppression equipment was dismantled or taken off the fire.\"\n",
      "20,\"Fire is contained and controlled, and will be placed into monitor status.\"\n",
      "21,At 1545 zone surveillance aircraft N222ME flew reconnaissance over the fire. No smokes and no active perimeter were observed.\n",
      "22,Increase in acreage matches latest perimeter.\n",
      "23,At 1500 the fire was flown by zone surveillance aircraft N222ME. The fire was 25 percent active and was spreading to the north. Observed fire behavior included backing and torching in black spruce with 10 foot flame lengths. Weather observed included wind out of the north at 10 mph with 10 percent cloud cover and no precipitation.  Fire is most active on the SW edge.  A 12 mile line of fire has burned 2.10 miles south of the Salmon Trout allotment.   Resources on scene of the allotment and cabin continued to monitor weather and fuel conditions in preparation for a burnout operation. Higher relative humidities kept fuels damp and no burn was attempted. The Midnight Sun IHC began to pretreat areas around the allotment with water.  Tommorow personnel will continue monitoring conditions. A helicopter reconnaissance flight has been scheduled for tomorrow (7/14).\n",
      "27,Zone surveillance aircraft N222ME flew the fire and reported it with a 30 percent active perimeter and spreading to the north. The fire was creeping and backing with isolated torching in black spruce. Observations were taken under 30 percent cloud cover with calm winds.   Personnel on the ground continued to improve upon the saw line around the allotment. An UAS (unmanned aircraft system) was launched and performed a recon over the fire.\n",
      "30,The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\n",
      "36,The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\n",
      "37,The fire was flown by surveillance aircraft N222ME. Fire 312 has consumed fire 303.\n",
      "39,The fire was flown by surveillance aircraft N222ME. The fire area was too smokey to make observations. New fire size result of update imaging.\n",
      "43,Personnel began backhauling structure protection equipment.\n",
      "46,\"The fire was discovered by zone aircraft N222ME during a detection flight. Personnel on board reported a 1 acre fire, 100 percent active, burning on flat terrain in black spruce. The fire plotted in a Limited suppression area and no values at risk were identified. The Upper Yukon Zone will continue to monitor this fire with aerial resources.\"\n",
      "47,A small column of smoke was reported to the duty officer around 22:30 on 7/12 by a resident on Sand Lake.  Helitack responded after the fog and mist lifted on 7/13.  The reporter could no longer see any smoke once helitack was launched.  Helicopter 873HL thoroughly scanned the area and did not find any blackened ground or smoke.  It is planned to search the area on 7/14 when the weather is forecasted to be warmer and clearer.\n",
      "49,\"Zone aircraft N222ME flew the fire and reported a 10 percent active perimeter.  Active burning was observed on the NE, NW and SE corners of the fire.  The fire continues to burn north of the Colleen River and west of Lois Creek.  Increase in acres reflects newer perimeter data.\"\n",
      "51,\"Resources are facing a very active fire while protecting a cabin and 2 allotments.  Eight smokejumpers have been placed on the eastern portion of the allotments and are planning to burn out the area either late tonight or in the morning. The remaining 8 smokejumpers are prepping the rest of the allotments with hose lay and plumbing.  Zone aircraft H-361EH assisted the fire with supplies and bucket drops while N864SF assisted the smokejumpers on the ground with aerial observations and updates of the fire activity.  Depending on the success of the burnout operations, the fire could be mopped up within a few days time.\"\n",
      "52,The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\n",
      "55,\"Zone surveillance in aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering along the ridgetop. No additional growth was visible. The fire remained 2.15 miles northeast of a National Park Service cabin. Decrease in acreage due to more accurate mapping.\"\n",
      "58,Identified areas of growth using Landsat 8 image acquired 7/11 @ 2300.  Updated size to 3130 acres.\n",
      "59,Zone surveillance in aircraft N309VS flew the fire and reported no active perimeter. The western interior of the fire was smoldering.\n",
      "61,Fire was flown by zone detection aircraft N222ME and no visible smoke or active perimeter was observed. Update in acreage is due to more accurate mapping.\n",
      "62,Zone surveillance aircraft N22ME flew the fire and reported no activity. Observations were taken under clear skies.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(df_current[condition_recent]['maintext'].to_csv())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_current.to_csv('current.csv', sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<module 'blmfire' from '/Users/chris/Dropbox/Coding/Python/aiccfiredata/blmfire.py'>"
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reload(blm)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Test JavaScript generation "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "FIRETEMPLATE = 'templates/firetemplate.js'\n",
    "HTMLTEMPLATE = 'templates/current_fires_template.js'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "data = blm.get_raw_fire_data(testfile_current, tryremote=False)\n",
    "fieldnames = blm.sanitize_dataline(data[0], blanks=3, lower=True)\n",
    "rawdata = [blm.sanitize_dataline(\n",
    "            item.strip(), blanks=2, lower=False) for item in data[1::2]]\n",
    "\n",
    "# the transformed data will be a list of dictionaries\n",
    "data = blm.get_firedata(fieldnames, rawdata)\n",
    "finalfirelist = blm.select_relevant_values(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'acreage': '178.2',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'North Hills',\n",
       "  'discovered': '08 Jun 2017, 06:00',\n",
       "  'discoverydatetime': '1496930437689',\n",
       "  'guid': '231B0E11-EA79-4FFD-A44C-84130064B858',\n",
       "  'lastupdated': '09 Jul 2017, 01:17',\n",
       "  'lastupdatedatetime': '1499591820689',\n",
       "  'latitude': '62.1606667',\n",
       "  'longitude': '-163.1690833',\n",
       "  'maintext': 'Decrease in acreage with updated perimeter.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '4.7',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Kowlak',\n",
       "  'discovered': '28 Jun 2017, 09:36',\n",
       "  'discoverydatetime': '1498671372689',\n",
       "  'guid': '8719131D-F468-481F-A61A-8DF15C13887B',\n",
       "  'lastupdated': '04 Jul 2017, 02:47',\n",
       "  'lastupdatedatetime': '1499164800690',\n",
       "  'latitude': '69.9508333',\n",
       "  'longitude': '-157.8397222',\n",
       "  'maintext': 'Decrease in acreage due to new LandSat perimeter.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '20',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Garnet Creek',\n",
       "  'discovered': '06 Jul 2017, 08:29',\n",
       "  'discoverydatetime': '1499358556690',\n",
       "  'guid': '3CE4F630-EF46-49EF-9A2D-3186E3DCE0C7',\n",
       "  'lastupdated': '13 Jul 2017, 11:25',\n",
       "  'lastupdatedatetime': '1499973900690',\n",
       "  'latitude': '65.3315',\n",
       "  'longitude': '-150.6751667',\n",
       "  'maintext': 'Zone surveillance aircraft N309VS flew the fire and reported no visible smoke.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': '',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '332',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Dietrich River',\n",
       "  'discovered': '05 Jul 2017, 03:00',\n",
       "  'discoverydatetime': '1499252431691',\n",
       "  'guid': 'E1963C4B-0888-4A60-B5B8-D8FFA8B8DF3A',\n",
       "  'lastupdated': '13 Jul 2017, 13:06',\n",
       "  'lastupdatedatetime': '1499979960691',\n",
       "  'latitude': '67.8851389',\n",
       "  'longitude': '-149.8075556',\n",
       "  'maintext': 'On 7/13, the fire received precipitation and no dominant smokes were visible from the highway; however, drift smoke was present in the area. An unmanned UAS flew the fire and captured infrared images indicating areas of heat. On 7/14, all resources will demobilize from the fire and the fire will remain in monitor status. Fire size decreased to 332 acres due to more accurate mapping.',\n",
       "  'numberpeople': '5',\n",
       "  'primaryfueltype': '',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '332',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'Blair Lakes',\n",
       "  'discovered': '01 Jun 2017, 05:52',\n",
       "  'discoverydatetime': '1496325163692',\n",
       "  'guid': 'B18CE0AB-470E-49A5-97B5-3B1790C668C9',\n",
       "  'lastupdated': '04 Jul 2017, 14:11',\n",
       "  'lastupdatedatetime': '1499206260692',\n",
       "  'latitude': '64.3393333',\n",
       "  'longitude': '-147.4405',\n",
       "  'maintext': 'Zone detection aircraft N309VS flew the fire today. No smoke was observed. The fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '25',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Medicine Lake',\n",
       "  'discovered': '05 Jul 2017, 08:00',\n",
       "  'discoverydatetime': '1499270447693',\n",
       "  'guid': '5F36D2F7-347D-4FBA-8C2C-0B21984A7607',\n",
       "  'lastupdated': '07 Jul 2017, 09:51',\n",
       "  'lastupdatedatetime': '1499449860693',\n",
       "  'latitude': '65.4828333',\n",
       "  'longitude': '-144.4725',\n",
       "  'maintext': 'Fire was flown by zone surveillance aircraft N9011N and confirmed at 25 acres with no visible smoke. The fire plotted in a Limited suppression area and will be monitored by zone aircraft.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': '',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '22227.3',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Helmet',\n",
       "  'discovered': '06 Jul 2017, 05:55',\n",
       "  'discoverydatetime': '1499349300694',\n",
       "  'guid': '1E5D3F64-62ED-4149-AB71-53535BDD0504',\n",
       "  'lastupdated': '14 Jul 2017, 01:48',\n",
       "  'lastupdatedatetime': '1500025680694',\n",
       "  'latitude': '67.5596667',\n",
       "  'longitude': '-144.0433333',\n",
       "  'maintext': 'Zone surveillance aircraft N222ME flew the area of the fire but was unable to observe it due to heavy smoke.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '4',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Vunle Lakes',\n",
       "  'discovered': '08 Jul 2017, 02:57',\n",
       "  'discoverydatetime': '1499511453694',\n",
       "  'guid': '8FC76EFB-5229-42B5-8ED8-D1F9B325106A',\n",
       "  'lastupdated': '12 Jul 2017, 09:44',\n",
       "  'lastupdatedatetime': '1499881380695',\n",
       "  'latitude': '66.4856667',\n",
       "  'longitude': '-143.6733334',\n",
       "  'maintext': 'The fire was demobilized and placed into monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '235.4',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Paddle Creek',\n",
       "  'discovered': '06 Jul 2017, 07:26',\n",
       "  'discoverydatetime': '1499354789695',\n",
       "  'guid': '21207F32-B0BD-42F8-A1FA-C4A7AC6EC464',\n",
       "  'lastupdated': '10 Jul 2017, 22:31',\n",
       "  'lastupdatedatetime': '1499754660695',\n",
       "  'latitude': '65.8865',\n",
       "  'longitude': '-143.5688333',\n",
       "  'maintext': 'Flown today by N222ME. The fire perimeter was 30% active, smoldering in tundra. Observed a 50 + acres increase to the west.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '10188.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Bear Mountain',\n",
       "  'discovered': '09 Jul 2017, 00:45',\n",
       "  'discoverydatetime': '1499589905696',\n",
       "  'guid': '7391C476-78BC-4C8D-A100-61644BBF6828',\n",
       "  'lastupdated': '14 Jul 2017, 01:47',\n",
       "  'lastupdatedatetime': '1500025620696',\n",
       "  'latitude': '65.9666666',\n",
       "  'longitude': '-142.85',\n",
       "  'maintext': 'Zone surveillance aircraft N222ME flew the fire and reported it with a 10 percent active perimeter. The fire behavior was described as smoldering in a spruce/hardwood/brush mix. Observations were taken under 40 percent cloud cover.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '1',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Gardiner Creek 2',\n",
       "  'discovered': '07 Jul 2017, 07:25',\n",
       "  'discoverydatetime': '1499441138697',\n",
       "  'guid': '55246098-9363-4C87-83DC-9365AAE42444',\n",
       "  'lastupdated': '09 Jul 2017, 22:34',\n",
       "  'lastupdatedatetime': '1499668440697',\n",
       "  'latitude': '63.0870278',\n",
       "  'longitude': '-141.3386667',\n",
       "  'maintext': 'The fire was flown today during a detection flight.  No flames and no smoke was visible.  The fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed (Hardwoods/Softwoods)',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '21.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Pass Creek',\n",
       "  'discovered': '18 Jun 2017, 05:34',\n",
       "  'discoverydatetime': '1497792898698',\n",
       "  'guid': '3D216138-6824-46B8-9254-835C46E21EF1',\n",
       "  'lastupdated': '13 Jul 2017, 07:29',\n",
       "  'lastupdatedatetime': '1499959740698',\n",
       "  'latitude': '65.0452778',\n",
       "  'longitude': '-141.215',\n",
       "  'maintext': 'The fire was flown by zone aircraft N22ME. No smoke, growth or active perimeter was reported.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Brush',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '23673.6',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Ammerman Creek',\n",
       "  'discovered': '23 Jun 2017, 09:05',\n",
       "  'discoverydatetime': '1498237548701',\n",
       "  'guid': '86A07501-8395-4D5D-B812-A18DA398F01D',\n",
       "  'lastupdated': '13 Jul 2017, 10:51',\n",
       "  'lastupdatedatetime': '1499971860701',\n",
       "  'latitude': '68.4175833',\n",
       "  'longitude': '-141.3226944',\n",
       "  'maintext': 'Zone aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering and creeping.  Personnel on board identified the largest amount activity on the southeast corner.  The fire remains west of Ammerman Creek and north of the Old Crow River.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '514',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Andreafsky',\n",
       "  'discovered': '08 Jun 2017, 04:45',\n",
       "  'discoverydatetime': '1496925945702',\n",
       "  'guid': 'E62589A2-BEEB-4C62-B7E3-B5AB44788049',\n",
       "  'lastupdated': '08 Jul 2017, 23:05',\n",
       "  'lastupdatedatetime': '1499583900702',\n",
       "  'latitude': '62.2646667',\n",
       "  'longitude': '-163.021',\n",
       "  'maintext': 'Decrease in acreage is due to more accurate mapping.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '25',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Point Lay',\n",
       "  'discovered': '28 Jun 2017, 06:44',\n",
       "  'discoverydatetime': '1498661068703',\n",
       "  'guid': '0B2B8CCE-46B4-4A29-8D4E-4E05EBE30105',\n",
       "  'lastupdated': '11 Jul 2017, 11:31',\n",
       "  'lastupdatedatetime': '1499801460703',\n",
       "  'latitude': '69.6728334',\n",
       "  'longitude': '-162.8638334',\n",
       "  'maintext': 'The Assistant Director of the North Slope Fire Department Borough in Barrow, received a smoke report from locals in Point Lay.  Several thunderstorms and lightning had moved through the area and locals were seeing a large plume of white smoke approximately 5-6 miles SE of Point Lay.  N864SF responded to the smoke report from Kotzebue and confirmed a 25 acre tundra fire of DOF ownership, plotting in Limited.  The fire is currently being held up by 2 water sources on the north and east ends of the fire and will continue to spread south and west.  There are currently no values at risk, so the fire will remain in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '1016',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'East Fork',\n",
       "  'discovered': '15 Jun 2017, 10:25',\n",
       "  'discoverydatetime': '1497551101704',\n",
       "  'guid': '1A9701F4-2CC0-4B80-8456-92F8BB4CD593',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1500005025704',\n",
       "  'latitude': '60.596333',\n",
       "  'longitude': '-150.521167',\n",
       "  'maintext': 'Two recon flights were conducted over fire 231, neither found smoke. Personnel took approximately four tons of equipment and supplies off the fire by helicopter and ground. None of the connected suppression equipment was dismantled or taken off the fire.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Dead White Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '30',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Sand Hills',\n",
       "  'discovered': '06 Jul 2017, 07:25',\n",
       "  'discoverydatetime': '1499354702704',\n",
       "  'guid': 'F9D1A784-3DDF-438E-831C-C3772FF4D5EA',\n",
       "  'lastupdated': '08 Jul 2017, 14:28',\n",
       "  'lastupdatedatetime': '1499552880705',\n",
       "  'latitude': '66.333',\n",
       "  'longitude': '-148.129',\n",
       "  'maintext': 'At 1450 the fire was flown by zone helicopter H-73HJ. The fire was 100 percent active burning in black spruce. Observed fire behavior included running, crowning, torching, and spotting approximately 200 yards ahead. The fire size had increased to approximately 30 acres.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '8344.9',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'South Fork Salcha',\n",
       "  'discovered': '08 Jun 2017, 03:09',\n",
       "  'discoverydatetime': '1496920159705',\n",
       "  'guid': '1C166729-9871-415C-AB4E-D72CA0EAB2B1',\n",
       "  'lastupdated': '09 Jul 2017, 22:35',\n",
       "  'lastupdatedatetime': '1499668500706',\n",
       "  'latitude': '64.4436389',\n",
       "  'longitude': '-145.5533889',\n",
       "  'maintext': 'H-120SH flew the fire, 1 acre of growth was noted on the northside, no other smokes found.  Fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed (Hardwoods/Softwoods)',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '3'},\n",
       " {'acreage': '1',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Loper 2',\n",
       "  'discovered': '09 Jul 2017, 03:37',\n",
       "  'discoverydatetime': '1499600270706',\n",
       "  'guid': 'DF352EC9-385F-45EE-A1D6-028A5144C433',\n",
       "  'lastupdated': '09 Jul 2017, 10:48',\n",
       "  'lastupdatedatetime': '1499626080706',\n",
       "  'latitude': '65.57975',\n",
       "  'longitude': '-145.7041667',\n",
       "  'maintext': 'The fire was discovered by Zone surveillance aircraft N309VS. The fire was 1 acre in tundra with no active perimeter or smokes showing. The fire plotted in Limited and was placed in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '14.6',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Charley',\n",
       "  'discovered': '28 Jun 2017, 08:04',\n",
       "  'discoverydatetime': '1498665886707',\n",
       "  'guid': '9F95EFE7-6DB9-43C3-8984-9E2BEA50B6BE',\n",
       "  'lastupdated': '09 Jul 2017, 08:15',\n",
       "  'lastupdatedatetime': '1499616900707',\n",
       "  'latitude': '65.6901667',\n",
       "  'longitude': '-143.0935',\n",
       "  'maintext': 'At 1315 the fire was flown by zone surveillance aircraft N9011N. No smokes were visible and no change observed.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'East Tetlin',\n",
       "  'discovered': '10 Jul 2017, 08:12',\n",
       "  'discoverydatetime': '1499703160708',\n",
       "  'guid': '4E655EFA-5A64-4442-93BC-20A0CDA12342',\n",
       "  'lastupdated': '13 Jul 2017, 21:58',\n",
       "  'lastupdatedatetime': '1500011880708',\n",
       "  'latitude': '63.0278889',\n",
       "  'longitude': '-142.2871667',\n",
       "  'maintext': 'Fire is contained and controlled, and will be placed into monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed (Hardwoods/Softwoods)',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2876.5',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Dorothy Creek',\n",
       "  'discovered': '30 Jun 2017, 07:08',\n",
       "  'discoverydatetime': '1498835336709',\n",
       "  'guid': 'F86DF691-23C6-40D2-BB4C-52E624145FAF',\n",
       "  'lastupdated': '13 Jul 2017, 10:50',\n",
       "  'lastupdatedatetime': '1499971800709',\n",
       "  'latitude': '67.6928056',\n",
       "  'longitude': '-142.2386944',\n",
       "  'maintext': 'At 1545 zone surveillance aircraft N222ME flew reconnaissance over the fire. No smokes and no active perimeter were observed.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '226.2',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Trout Creek',\n",
       "  'discovered': '21 Jun 2017, 11:37',\n",
       "  'discoverydatetime': '1498073849710',\n",
       "  'guid': 'C0BD59B1-6D5C-4552-9E7C-201571B6EFCB',\n",
       "  'lastupdated': '12 Jul 2017, 22:07',\n",
       "  'lastupdatedatetime': '1499926020710',\n",
       "  'latitude': '65.1022222',\n",
       "  'longitude': '-141.6383333',\n",
       "  'maintext': 'Increase in acreage matches latest perimeter.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed Trees',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '45521.7',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Campbell River',\n",
       "  'discovered': '26 Jun 2017, 09:14',\n",
       "  'discoverydatetime': '1498497264711',\n",
       "  'guid': 'C1446D0C-39BF-46C9-BD52-E709BD0B7902',\n",
       "  'lastupdated': '13 Jul 2017, 13:05',\n",
       "  'lastupdatedatetime': '1499979900711',\n",
       "  'latitude': '67.2183056',\n",
       "  'longitude': '-141.0150278',\n",
       "  'maintext': 'At 1500 the fire was flown by zone surveillance aircraft N222ME. The fire was 25 percent active and was spreading to the north. Observed fire behavior included backing and torching in black spruce with 10 foot flame lengths. Weather observed included wind out of the north at 10 mph with 10 percent cloud cover and no precipitation.  Fire is most active on the SW edge.  A 12 mile line of fire has burned 2.10 miles south of the Salmon Trout allotment.   Resources on scene of the allotment and cabin continued to monitor weather and fuel conditions in preparation for a burnout operation. Higher relative humidities kept fuels damp and no burn was attempted. The Midnight Sun IHC began to pretreat areas around the allotment with water.  Tommorow personnel will continue monitoring conditions. A helicopter reconnaissance flight has been scheduled for tomorrow (7/14).',\n",
       "  'numberpeople': '35',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '0.5',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'Coal Creek 17',\n",
       "  'discovered': '06 Jun 2017, 02:01',\n",
       "  'discoverydatetime': '1496743273711',\n",
       "  'guid': '',\n",
       "  'lastupdated': '07 Jul 2017, 05:18',\n",
       "  'lastupdatedatetime': '1497931205711',\n",
       "  'latitude': '64.0361333',\n",
       "  'longitude': '-148.5646333',\n",
       "  'maintext': 'H120SH flew fire, currently 1/2 acre barely smoking.  Little to no spread.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '1.5',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'Coal Creek South',\n",
       "  'discovered': '06 Jun 2017, 04:18',\n",
       "  'discoverydatetime': '1496751505712',\n",
       "  'guid': '94939C6A-B76A-4926-859B-88FAB24F67FA',\n",
       "  'lastupdated': '07 Jul 2017, 05:10',\n",
       "  'lastupdatedatetime': '1497931205712',\n",
       "  'latitude': '64.029783',\n",
       "  'longitude': '-148.56375',\n",
       "  'maintext': 'H120SH flew fire, currently 1.5 acres, 1-2` flame lengths on the uphill west side.  No action taken, remaining in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '0.4',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'Live Valley',\n",
       "  'discovered': '16 Jun 2017, 04:56',\n",
       "  'discoverydatetime': '1497617787713',\n",
       "  'guid': 'C65F6C92-E038-4C72-BB2E-990EE1B4532B',\n",
       "  'lastupdated': '17 Jun 2017, 02:41',\n",
       "  'lastupdatedatetime': '1497651120713',\n",
       "  'latitude': '64.7073889',\n",
       "  'longitude': '-146.5471111',\n",
       "  'maintext': 'Range Control reported the fire as two small grass fires adjacent to one another and just under one half acre in size. Skies were overcast with a 7 mph SSW wind. Zone detection aircraft N9011N flew a reconnaissance mission over the area in the evening but were unable to locate any sign of the fire.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Grass',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '23383.9',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Boulder Creek',\n",
       "  'discovered': '02 Jul 2017, 07:12',\n",
       "  'discoverydatetime': '1499008351714',\n",
       "  'guid': 'DC5D8B8C-8437-4C56-8822-187E33619168',\n",
       "  'lastupdated': '14 Jul 2017, 01:49',\n",
       "  'lastupdatedatetime': '1500025740714',\n",
       "  'latitude': '67.45',\n",
       "  'longitude': '-143.7333333',\n",
       "  'maintext': 'Zone surveillance aircraft N222ME flew the fire and reported it with a 30 percent active perimeter and spreading to the north. The fire was creeping and backing with isolated torching in black spruce. Observations were taken under 30 percent cloud cover with calm winds.   Personnel on the ground continued to improve upon the saw line around the allotment. An UAS (unmanned aircraft system) was launched and performed a recon over the fire.',\n",
       "  'numberpeople': '75',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2583.5',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Allen',\n",
       "  'discovered': '07 Jun 2017, 00:03',\n",
       "  'discoverydatetime': '1496822606715',\n",
       "  'guid': '2B4F6923-8854-45F4-86B3-501F635FE76F',\n",
       "  'lastupdated': '09 Jul 2017, 01:13',\n",
       "  'lastupdatedatetime': '1499583660715',\n",
       "  'latitude': '62.5551667',\n",
       "  'longitude': '-163.1535',\n",
       "  'maintext': 'Increase in acreage due to uploaded perimeter.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': '',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '5.2',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Wolf Creek',\n",
       "  'discovered': '03 Jun 2017, 11:11',\n",
       "  'discoverydatetime': '1496517088716',\n",
       "  'guid': 'A5ED7846-822B-48D6-811C-6958088DE0CD',\n",
       "  'lastupdated': '04 Jul 2017, 03:49',\n",
       "  'lastupdatedatetime': '1496965920716',\n",
       "  'latitude': '62.2952778',\n",
       "  'longitude': '-161.4383333',\n",
       "  'maintext': 'Change in acreage due to more accurate, digitized mapping.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '16514',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Little Yetna River',\n",
       "  'discovered': '04 Jun 2017, 07:52',\n",
       "  'discoverydatetime': '1496591548716',\n",
       "  'guid': 'D3AAABF1-D21F-4768-A605-4698B313BEEB',\n",
       "  'lastupdated': '13 Jul 2017, 20:04',\n",
       "  'lastupdatedatetime': '1499975290717',\n",
       "  'latitude': '62.570333',\n",
       "  'longitude': '-158.577333',\n",
       "  'maintext': 'The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '4.2',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'Kobe Field',\n",
       "  'discovered': '27 Jun 2017, 19:40',\n",
       "  'discoverydatetime': '1498621234717',\n",
       "  'guid': '0DA16144-D242-4186-A372-10C3D12EF97E',\n",
       "  'lastupdated': '07 Jul 2017, 05:02',\n",
       "  'lastupdatedatetime': '1499140805717',\n",
       "  'latitude': '64.25645',\n",
       "  'longitude': '-149.354467',\n",
       "  'maintext': 'Prevention engine checked fire, found smoke in the NE corner of the slop over.  Added water, will have Forestry engine check 7/4/17.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '3',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Old Lost Creek',\n",
       "  'discovered': '07 Jul 2017, 06:52',\n",
       "  'discoverydatetime': '1499439161718',\n",
       "  'guid': '61F067C5-7993-4618-BEDC-82ED2315B094',\n",
       "  'lastupdated': '08 Jul 2017, 10:01',\n",
       "  'lastupdatedatetime': '1499536860718',\n",
       "  'latitude': '66.0363333',\n",
       "  'longitude': '-148.0646667',\n",
       "  'maintext': 'At 1350 the fire was flown by zone surveillance aircraft N9011N. The fire was active with 3 foot flame lengths. Single tree torching was observed. Fire size had increased to approximately 3 acres.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '74.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Preacher Creek',\n",
       "  'discovered': '08 Jul 2017, 04:19',\n",
       "  'discoverydatetime': '1499516349719',\n",
       "  'guid': 'FFBF237B-E597-4125-876B-7986EA00D4D7',\n",
       "  'lastupdated': '11 Jul 2017, 14:52',\n",
       "  'lastupdatedatetime': '1499813520719',\n",
       "  'latitude': '65.95',\n",
       "  'longitude': '-144.8',\n",
       "  'maintext': 'Increase in acreage from updated infrared imaging.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '322.6',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Deadmans Slough',\n",
       "  'discovered': '04 Jun 2017, 11:22',\n",
       "  'discoverydatetime': '1496604137720',\n",
       "  'guid': '8952DB38-90BB-4D90-8EC3-A06ED9206D14',\n",
       "  'lastupdated': '23 Jun 2017, 23:49',\n",
       "  'lastupdatedatetime': '1498111680720',\n",
       "  'latitude': '62.6342222',\n",
       "  'longitude': '-160.2121944',\n",
       "  'maintext': 'As off 1100, the fire has been called controlled and placed into monitor status. All resources have been demobilized from this fire.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed Trees',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '51.6',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Tenmile',\n",
       "  'discovered': '07 Jun 2017, 11:17',\n",
       "  'discoverydatetime': '1496863030721',\n",
       "  'guid': 'B272457B-0306-41B4-903F-ABE3D6DC12F3',\n",
       "  'lastupdated': '27 Jun 2017, 02:40',\n",
       "  'lastupdatedatetime': '1497521460721',\n",
       "  'latitude': '64.0763889',\n",
       "  'longitude': '-159.5341667',\n",
       "  'maintext': 'Decrease in acreage due to more accurate mapping.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': '',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '12945',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'American Creek',\n",
       "  'discovered': '04 Jun 2017, 06:59',\n",
       "  'discoverydatetime': '1496588380722',\n",
       "  'guid': '91068E54-7C07-4C4F-AA8A-B44162E3903D',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1500005030722',\n",
       "  'latitude': '63.173333',\n",
       "  'longitude': '-156.842833',\n",
       "  'maintext': 'The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '338.6',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'White Snow',\n",
       "  'discovered': '04 Jul 2017, 08:40',\n",
       "  'discoverydatetime': '1499186440723',\n",
       "  'guid': '89EDCE37-D59E-4073-BA8F-28348BBFA492',\n",
       "  'lastupdated': '14 Jul 2017, 01:48',\n",
       "  'lastupdatedatetime': '1500025680723',\n",
       "  'latitude': '67.5953055',\n",
       "  'longitude': '-144.0851667',\n",
       "  'maintext': 'The fire was flown by surveillance aircraft N222ME. Fire 312 has consumed fire 303.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '45.2',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': '2017 Windfall Mountain Overwinter _1',\n",
       "  'discovered': '31 Dec 2016, 15:01',\n",
       "  'discoverydatetime': '1483228895723',\n",
       "  'guid': '0B8D7795-C042-4165-A540-C22C3FFEFA8B',\n",
       "  'lastupdated': '07 Jul 2017, 04:46',\n",
       "  'lastupdatedatetime': '1499431620723',\n",
       "  'latitude': '65.0298056',\n",
       "  'longitude': '-141.2518611',\n",
       "  'maintext': 'Fire was flown today by zone aircraft N309VS.  The observer on board reported no active perimeter or acreage gain. Some visible smoke within the fissure.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Grass',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '62800.9',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'White Mountain Creek',\n",
       "  'discovered': '03 Jul 2017, 06:09',\n",
       "  'discoverydatetime': '1499090972724',\n",
       "  'guid': 'CB846635-C8CB-4734-8DC9-2C787C6C58F6',\n",
       "  'lastupdated': '14 Jul 2017, 01:48',\n",
       "  'lastupdatedatetime': '1500025680724',\n",
       "  'latitude': '67.4532778',\n",
       "  'longitude': '-141.3181389',\n",
       "  'maintext': 'The fire was flown by surveillance aircraft N222ME. The fire area was too smokey to make observations. New fire size result of update imaging.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '1647.4',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Omikmuktusuk',\n",
       "  'discovered': '28 Jun 2017, 09:24',\n",
       "  'discoverydatetime': '1498670694725',\n",
       "  'guid': '14025835-30F7-4E28-B709-4B1A34BBC458',\n",
       "  'lastupdated': '04 Jul 2017, 03:02',\n",
       "  'lastupdatedatetime': '1499164500725',\n",
       "  'latitude': '69.679',\n",
       "  'longitude': '-159.622',\n",
       "  'maintext': 'Increase in acreage due to updated LandSat perimeter.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2870.3',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Ketik River',\n",
       "  'discovered': '28 Jun 2017, 09:24',\n",
       "  'discoverydatetime': '1498670677726',\n",
       "  'guid': 'CD900D9B-9773-49E1-A693-F8B11B5C378E',\n",
       "  'lastupdated': '04 Jul 2017, 03:03',\n",
       "  'lastupdatedatetime': '1499076960726',\n",
       "  'latitude': '69.7545',\n",
       "  'longitude': '-159.0356667',\n",
       "  'maintext': 'Increase in acreage due to new LandSat perimeter.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '127',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Wayne Taylor',\n",
       "  'discovered': '25 Jun 2017, 11:53',\n",
       "  'discoverydatetime': '1498420394727',\n",
       "  'guid': '7E55427E-8529-44D4-B927-C1DCE2BE0B45',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1499313605727',\n",
       "  'latitude': '61.019074',\n",
       "  'longitude': '-157.429832',\n",
       "  'maintext': 'The fire was flown by 35E.  No activity was observed and the fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Dead White Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '16823.9',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Pitka Fork',\n",
       "  'discovered': '04 Jun 2017, 09:18',\n",
       "  'discoverydatetime': '1496596727728',\n",
       "  'guid': '142D0B21-2C27-4B8A-875A-BC2E0B63ECF5',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1500005025728',\n",
       "  'latitude': '62.425',\n",
       "  'longitude': '-154.057167',\n",
       "  'maintext': 'Personnel began backhauling structure protection equipment.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '30'},\n",
       " {'acreage': '0.2',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'Kroto Creek',\n",
       "  'discovered': '06 Jul 2017, 00:07',\n",
       "  'discoverydatetime': '1499328472728',\n",
       "  'guid': '1D8128D1-BB46-4052-A5FB-8CF15924AC7E',\n",
       "  'lastupdated': '06 Jul 2017, 22:30',\n",
       "  'lastupdatedatetime': '1499409000729',\n",
       "  'latitude': '62.0549444',\n",
       "  'longitude': '-150.43525',\n",
       "  'maintext': 'The fire was reported by a private pilot.  Forestry`s helitack responded to the reported coordinates and located a .2 acre smoldering fire.  The helitack crew suppressed the fire and placed it in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2549.3',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Loper Creek',\n",
       "  'discovered': '27 Jun 2017, 06:51',\n",
       "  'discoverydatetime': '1498575073729',\n",
       "  'guid': '3BCA8DE3-A9AE-4617-999D-6DC536FB9362',\n",
       "  'lastupdated': '09 Jul 2017, 10:49',\n",
       "  'lastupdatedatetime': '1499626140729',\n",
       "  'latitude': '65.6925',\n",
       "  'longitude': '-145.5515',\n",
       "  'maintext': 'Fire flown by Zone aircraft N309VS, personnel on board reported no visible smokes.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '1',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'WL 543T',\n",
       "  'discovered': '13 Jul 2017, 09:15',\n",
       "  'discoverydatetime': '1499966104730',\n",
       "  'guid': 'C6ED6EFA-EBCF-4B58-8AAA-260BEBBDA871',\n",
       "  'lastupdated': '14 Jul 2017, 01:39',\n",
       "  'lastupdatedatetime': '1499975520730',\n",
       "  'latitude': '67.0030278',\n",
       "  'longitude': '-144.6955833',\n",
       "  'maintext': 'The fire was discovered by zone aircraft N222ME during a detection flight. Personnel on board reported a 1 acre fire, 100 percent active, burning on flat terrain in black spruce. The fire plotted in a Limited suppression area and no values at risk were identified. The Upper Yukon Zone will continue to monitor this fire with aerial resources.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '0',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'George Lake Hills',\n",
       "  'discovered': '13 Jul 2017, 00:10',\n",
       "  'discoverydatetime': '1499933424731',\n",
       "  'guid': '607BB758-6C06-4E35-8A4A-9B5EFEF53D52',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1500005025731',\n",
       "  'latitude': '63.75',\n",
       "  'longitude': '-144.316667',\n",
       "  'maintext': 'A small column of smoke was reported to the duty officer around 22:30 on 7/12 by a resident on Sand Lake.  Helitack responded after the fog and mist lifted on 7/13.  The reporter could no longer see any smoke once helitack was launched.  Helicopter 873HL thoroughly scanned the area and did not find any blackened ground or smoke.  It is planned to search the area on 7/14 when the weather is forecasted to be warmer and clearer.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Unknown',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '11757.7',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Rat Creek',\n",
       "  'discovered': '29 Jun 2017, 05:11',\n",
       "  'discoverydatetime': '1498741880732',\n",
       "  'guid': '1BFBD1FA-A1C2-44AF-872F-F3F33B20D146',\n",
       "  'lastupdated': '10 Jul 2017, 13:51',\n",
       "  'lastupdatedatetime': '1499723520732',\n",
       "  'latitude': '66.8833333',\n",
       "  'longitude': '-142.4833333',\n",
       "  'maintext': 'Zone surveillance aircraft N22ME flew the fire and reported the perimeter to be 5% active, smoldering in tundra. No change is size was observed.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Black Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '27629.4',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Lois Creek',\n",
       "  'discovered': '02 Jul 2017, 09:28',\n",
       "  'discoverydatetime': '1499016516733',\n",
       "  'guid': '022B3833-8BAA-4CF8-AC50-CF235F065649',\n",
       "  'lastupdated': '13 Jul 2017, 10:40',\n",
       "  'lastupdatedatetime': '1499971200733',\n",
       "  'latitude': '68.2916667',\n",
       "  'longitude': '-142.0123333',\n",
       "  'maintext': 'Zone aircraft N222ME flew the fire and reported a 10 percent active perimeter.  Active burning was observed on the NE, NW and SE corners of the fire.  The fire continues to burn north of the Colleen River and west of Lois Creek.  Increase in acres reflects newer perimeter data.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tussock',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '11.5',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Pastolik',\n",
       "  'discovered': '08 Jun 2017, 12:44',\n",
       "  'discoverydatetime': '1496954676734',\n",
       "  'guid': '5D51BD09-96C4-4973-868C-9DB8D08EA242',\n",
       "  'lastupdated': '27 Jun 2017, 04:16',\n",
       "  'lastupdatedatetime': '1497785760734',\n",
       "  'latitude': '62.7103889',\n",
       "  'longitude': '-163.032',\n",
       "  'maintext': 'Increase in acreage due to more accurate mapping',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '514.5',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Khotol',\n",
       "  'discovered': '06 Jun 2017, 10:05',\n",
       "  'discoverydatetime': '1496772332734',\n",
       "  'guid': 'A61F4906-8340-4905-AC58-E9F2007E95CC',\n",
       "  'lastupdated': '14 Jul 2017, 01:05',\n",
       "  'lastupdatedatetime': '1500023160735',\n",
       "  'latitude': '64.3261111',\n",
       "  'longitude': '-158.2422222',\n",
       "  'maintext': 'Resources are facing a very active fire while protecting a cabin and 2 allotments.  Eight smokejumpers have been placed on the eastern portion of the allotments and are planning to burn out the area either late tonight or in the morning. The remaining 8 smokejumpers are prepping the rest of the allotments with hose lay and plumbing.  Zone aircraft H-361EH assisted the fire with supplies and bucket drops while N864SF assisted the smokejumpers on the ground with aerial observations and updates of the fire activity.  Depending on the success of the burnout operations, the fire could be mopped up within a few days time.',\n",
       "  'numberpeople': '16',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '13924',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Ball Creek',\n",
       "  'discovered': '04 Jun 2017, 12:53',\n",
       "  'discoverydatetime': '1496609615735',\n",
       "  'guid': '2C007BB1-9855-425F-A852-6C69C2DE4A9A',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1500005025735',\n",
       "  'latitude': '62.468167',\n",
       "  'longitude': '-157.64295',\n",
       "  'maintext': 'The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Other',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '31'},\n",
       " {'acreage': '491.6',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Narvak Lake',\n",
       "  'discovered': '27 Jun 2017, 12:15',\n",
       "  'discoverydatetime': '1498594525736',\n",
       "  'guid': 'DB9F9DD4-AA84-41A2-9DBD-321A58BF6D90',\n",
       "  'lastupdated': '11 Jul 2017, 12:09',\n",
       "  'lastupdatedatetime': '1499771040736',\n",
       "  'latitude': '66.946',\n",
       "  'longitude': '-155.6475',\n",
       "  'maintext': 'Updated acreage due to more accurate mapping.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed Trees',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '832',\n",
       "  'cause': 'Human',\n",
       "  'current': 'false',\n",
       "  'designation': 'North Robertson',\n",
       "  'discovered': '01 Jun 2017, 02:21',\n",
       "  'discoverydatetime': '1496312507737',\n",
       "  'guid': 'CBEEBD25-594D-43BD-B474-263954852A86',\n",
       "  'lastupdated': '28 Jun 2017, 20:00',\n",
       "  'lastupdatedatetime': '1498708805737',\n",
       "  'latitude': '63.527733',\n",
       "  'longitude': '-143.916883',\n",
       "  'maintext': 'The fire was flown today, no smokes were seen. The fire will remain in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Dead White Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '135.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Seven Mile',\n",
       "  'discovered': '29 Jun 2017, 07:08',\n",
       "  'discoverydatetime': '1498748906738',\n",
       "  'guid': '42B24ADA-4F12-4E48-BA50-D52A1D8E7311',\n",
       "  'lastupdated': '13 Jul 2017, 07:25',\n",
       "  'lastupdatedatetime': '1499959500738',\n",
       "  'latitude': '65.4047778',\n",
       "  'longitude': '-142.4603889',\n",
       "  'maintext': 'Zone surveillance in aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering along the ridgetop. No additional growth was visible. The fire remained 2.15 miles northeast of a National Park Service cabin. Decrease in acreage due to more accurate mapping.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'White Spruce',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '306.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'North Fork',\n",
       "  'discovered': '06 Jun 2017, 12:10',\n",
       "  'discoverydatetime': '1496779811739',\n",
       "  'guid': 'D9326B52-1219-470D-A745-D0B75A5271E8',\n",
       "  'lastupdated': '27 Jun 2017, 07:27',\n",
       "  'lastupdatedatetime': '1498576920739',\n",
       "  'latitude': '64.202',\n",
       "  'longitude': '-159.9615',\n",
       "  'maintext': 'N864SF flew the fire and observed there to be no smokes showing.The fire will remain in monitor status',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2653',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Bell Creek',\n",
       "  'discovered': '04 Jun 2017, 11:05',\n",
       "  'discoverydatetime': '1496603154740',\n",
       "  'guid': 'C98E06E8-0F8C-45AF-949D-70CF6458E703',\n",
       "  'lastupdated': '13 Jul 2017, 20:03',\n",
       "  'lastupdatedatetime': '1499313606740',\n",
       "  'latitude': '61.918633',\n",
       "  'longitude': '-158.081667',\n",
       "  'maintext': 'The fire was flown by 35E.  No activity was observed and the fire remains in monitor status.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Mixed (Hardwoods/Softwoods)',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '55'},\n",
       " {'acreage': '3130',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Kihovilik Creek',\n",
       "  'discovered': '27 Jun 2017, 13:15',\n",
       "  'discoverydatetime': '1498598129741',\n",
       "  'guid': '6BE59E0A-1E92-4FDE-8112-4E03D05C4B94',\n",
       "  'lastupdated': '12 Jul 2017, 11:54',\n",
       "  'lastupdatedatetime': '1499889240741',\n",
       "  'latitude': '66.6346667',\n",
       "  'longitude': '-157.1596667',\n",
       "  'maintext': 'Identified areas of growth using Landsat 8 image acquired 7/11 @ 2300.  Updated size to 3130 acres.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '90',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Larsen Creek',\n",
       "  'discovered': '04 Jul 2017, 08:03',\n",
       "  'discoverydatetime': '1499184190742',\n",
       "  'guid': 'B5454133-E82F-4255-81C4-AAE28C7E284C',\n",
       "  'lastupdated': '13 Jul 2017, 11:35',\n",
       "  'lastupdatedatetime': '1499974500742',\n",
       "  'latitude': '65.4581667',\n",
       "  'longitude': '-151.1717778',\n",
       "  'maintext': 'Zone surveillance in aircraft N309VS flew the fire and reported no active perimeter. The western interior of the fire was smoldering.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '0.2',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Potholes',\n",
       "  'discovered': '28 Jun 2017, 11:02',\n",
       "  'discoverydatetime': '1498676571743',\n",
       "  'guid': 'A2974B0D-45D4-4B36-BB53-7FB91EC100F9',\n",
       "  'lastupdated': '30 Jun 2017, 12:49',\n",
       "  'lastupdatedatetime': '1498855740743',\n",
       "  'latitude': '63.912',\n",
       "  'longitude': '-146.0013333',\n",
       "  'maintext': 'Zone detection aircraft N700FW flew the fire area today. Smoke observed in the northeast corner of the 1/4 acre. No change in size.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '426.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Monument Creek',\n",
       "  'discovered': '05 Jul 2017, 07:22',\n",
       "  'discoverydatetime': '1499268146744',\n",
       "  'guid': '4EEFEF37-FCD0-48B1-844C-31AA9507A756',\n",
       "  'lastupdated': '13 Jul 2017, 11:16',\n",
       "  'lastupdatedatetime': '1499973360744',\n",
       "  'latitude': '68.062',\n",
       "  'longitude': '-143.8425833',\n",
       "  'maintext': 'Fire was flown by zone detection aircraft N222ME and no visible smoke or active perimeter was observed. Update in acreage is due to more accurate mapping.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'},\n",
       " {'acreage': '2228.8',\n",
       "  'cause': 'Lightning',\n",
       "  'current': 'false',\n",
       "  'designation': 'Lake Creek',\n",
       "  'discovered': '02 Jul 2017, 08:07',\n",
       "  'discoverydatetime': '1499011677744',\n",
       "  'guid': 'BF193C80-A9FC-41DE-A790-0756CB58450C',\n",
       "  'lastupdated': '13 Jul 2017, 11:08',\n",
       "  'lastupdatedatetime': '1499972880745',\n",
       "  'latitude': '67.5075',\n",
       "  'longitude': '-142.1595',\n",
       "  'maintext': 'Zone surveillance aircraft N22ME flew the fire and reported no activity. Observations were taken under clear skies.',\n",
       "  'numberpeople': '0',\n",
       "  'primaryfueltype': 'Tundra',\n",
       "  'structuresburned': '0',\n",
       "  'structuresthreatened': '0'}]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "finalfirelist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "blm.PROJECTPATH = '.'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fires = blm.fill_template(finalfirelist, template=FIRETEMPLATE)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\tfire = {\n",
      "\t\tdesignation: \"North Hills\",\n",
      "\t\tcenter: new google.maps.LatLng(62.1606667, -163.1690833),\n",
      "\t\tacreage: 178.2,\n",
      "\t\tmaintext: \"Decrease in acreage with updated perimeter.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 01:17\",\n",
      "\t\tdiscovered: \"08 Jun 2017, 06:00\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Kowlak\",\n",
      "\t\tcenter: new google.maps.LatLng(69.9508333, -157.8397222),\n",
      "\t\tacreage: 4.7,\n",
      "\t\tmaintext: \"Decrease in acreage due to new LandSat perimeter.\",\n",
      "\t\tlastupdated: \"04 Jul 2017, 02:47\",\n",
      "\t\tdiscovered: \"28 Jun 2017, 09:36\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Garnet Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.3315, -150.6751667),\n",
      "\t\tacreage: 20,\n",
      "\t\tmaintext: \"Zone surveillance aircraft N309VS flew the fire and reported no visible smoke.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 11:25\",\n",
      "\t\tdiscovered: \"06 Jul 2017, 08:29\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Dietrich River\",\n",
      "\t\tcenter: new google.maps.LatLng(67.8851389, -149.8075556),\n",
      "\t\tacreage: 332,\n",
      "\t\tmaintext: \"On 7/13, the fire received precipitation and no dominant smokes were visible from the highway; however, drift smoke was present in the area. An unmanned UAS flew the fire and captured infrared images indicating areas of heat. On 7/14, all resources will demobilize from the fire and the fire will remain in monitor status. Fire size decreased to 332 acres due to more accurate mapping.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 13:06\",\n",
      "\t\tdiscovered: \"05 Jul 2017, 03:00\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Blair Lakes\",\n",
      "\t\tcenter: new google.maps.LatLng(64.3393333, -147.4405),\n",
      "\t\tacreage: 332,\n",
      "\t\tmaintext: \"Zone detection aircraft N309VS flew the fire today. No smoke was observed. The fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"04 Jul 2017, 14:11\",\n",
      "\t\tdiscovered: \"01 Jun 2017, 05:52\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Medicine Lake\",\n",
      "\t\tcenter: new google.maps.LatLng(65.4828333, -144.4725),\n",
      "\t\tacreage: 25,\n",
      "\t\tmaintext: \"Fire was flown by zone surveillance aircraft N9011N and confirmed at 25 acres with no visible smoke. The fire plotted in a Limited suppression area and will be monitored by zone aircraft.\",\n",
      "\t\tlastupdated: \"07 Jul 2017, 09:51\",\n",
      "\t\tdiscovered: \"05 Jul 2017, 08:00\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Helmet\",\n",
      "\t\tcenter: new google.maps.LatLng(67.5596667, -144.0433333),\n",
      "\t\tacreage: 22227.3,\n",
      "\t\tmaintext: \"Zone surveillance aircraft N222ME flew the area of the fire but was unable to observe it due to heavy smoke.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:48\",\n",
      "\t\tdiscovered: \"06 Jul 2017, 05:55\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Vunle Lakes\",\n",
      "\t\tcenter: new google.maps.LatLng(66.4856667, -143.6733334),\n",
      "\t\tacreage: 4,\n",
      "\t\tmaintext: \"The fire was demobilized and placed into monitor status.\",\n",
      "\t\tlastupdated: \"12 Jul 2017, 09:44\",\n",
      "\t\tdiscovered: \"08 Jul 2017, 02:57\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Paddle Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.8865, -143.5688333),\n",
      "\t\tacreage: 235.4,\n",
      "\t\tmaintext: \"Flown today by N222ME. The fire perimeter was 30% active, smoldering in tundra. Observed a 50 + acres increase to the west.\",\n",
      "\t\tlastupdated: \"10 Jul 2017, 22:31\",\n",
      "\t\tdiscovered: \"06 Jul 2017, 07:26\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Bear Mountain\",\n",
      "\t\tcenter: new google.maps.LatLng(65.9666666, -142.85),\n",
      "\t\tacreage: 10188.8,\n",
      "\t\tmaintext: \"Zone surveillance aircraft N222ME flew the fire and reported it with a 10 percent active perimeter. The fire behavior was described as smoldering in a spruce/hardwood/brush mix. Observations were taken under 40 percent cloud cover.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:47\",\n",
      "\t\tdiscovered: \"09 Jul 2017, 00:45\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Gardiner Creek 2\",\n",
      "\t\tcenter: new google.maps.LatLng(63.0870278, -141.3386667),\n",
      "\t\tacreage: 1,\n",
      "\t\tmaintext: \"The fire was flown today during a detection flight.  No flames and no smoke was visible.  The fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 22:34\",\n",
      "\t\tdiscovered: \"07 Jul 2017, 07:25\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Pass Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.0452778, -141.215),\n",
      "\t\tacreage: 21.8,\n",
      "\t\tmaintext: \"The fire was flown by zone aircraft N22ME. No smoke, growth or active perimeter was reported.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 07:29\",\n",
      "\t\tdiscovered: \"18 Jun 2017, 05:34\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Ammerman Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(68.4175833, -141.3226944),\n",
      "\t\tacreage: 23673.6,\n",
      "\t\tmaintext: \"Zone aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering and creeping.  Personnel on board identified the largest amount activity on the southeast corner.  The fire remains west of Ammerman Creek and north of the Old Crow River.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 10:51\",\n",
      "\t\tdiscovered: \"23 Jun 2017, 09:05\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Andreafsky\",\n",
      "\t\tcenter: new google.maps.LatLng(62.2646667, -163.021),\n",
      "\t\tacreage: 514,\n",
      "\t\tmaintext: \"Decrease in acreage is due to more accurate mapping.\",\n",
      "\t\tlastupdated: \"08 Jul 2017, 23:05\",\n",
      "\t\tdiscovered: \"08 Jun 2017, 04:45\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Point Lay\",\n",
      "\t\tcenter: new google.maps.LatLng(69.6728334, -162.8638334),\n",
      "\t\tacreage: 25,\n",
      "\t\tmaintext: \"The Assistant Director of the North Slope Fire Department Borough in Barrow, received a smoke report from locals in Point Lay.  Several thunderstorms and lightning had moved through the area and locals were seeing a large plume of white smoke approximately 5-6 miles SE of Point Lay.  N864SF responded to the smoke report from Kotzebue and confirmed a 25 acre tundra fire of DOF ownership, plotting in Limited.  The fire is currently being held up by 2 water sources on the north and east ends of the fire and will continue to spread south and west.  There are currently no values at risk, so the fire will remain in monitor status.\",\n",
      "\t\tlastupdated: \"11 Jul 2017, 11:31\",\n",
      "\t\tdiscovered: \"28 Jun 2017, 06:44\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"East Fork\",\n",
      "\t\tcenter: new google.maps.LatLng(60.596333, -150.521167),\n",
      "\t\tacreage: 1016,\n",
      "\t\tmaintext: \"Two recon flights were conducted over fire 231, neither found smoke. Personnel took approximately four tons of equipment and supplies off the fire by helicopter and ground. None of the connected suppression equipment was dismantled or taken off the fire.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"15 Jun 2017, 10:25\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Sand Hills\",\n",
      "\t\tcenter: new google.maps.LatLng(66.333, -148.129),\n",
      "\t\tacreage: 30,\n",
      "\t\tmaintext: \"At 1450 the fire was flown by zone helicopter H-73HJ. The fire was 100 percent active burning in black spruce. Observed fire behavior included running, crowning, torching, and spotting approximately 200 yards ahead. The fire size had increased to approximately 30 acres.\",\n",
      "\t\tlastupdated: \"08 Jul 2017, 14:28\",\n",
      "\t\tdiscovered: \"06 Jul 2017, 07:25\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"South Fork Salcha\",\n",
      "\t\tcenter: new google.maps.LatLng(64.4436389, -145.5533889),\n",
      "\t\tacreage: 8344.9,\n",
      "\t\tmaintext: \"H-120SH flew the fire, 1 acre of growth was noted on the northside, no other smokes found.  Fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 22:35\",\n",
      "\t\tdiscovered: \"08 Jun 2017, 03:09\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Loper 2\",\n",
      "\t\tcenter: new google.maps.LatLng(65.57975, -145.7041667),\n",
      "\t\tacreage: 1,\n",
      "\t\tmaintext: \"The fire was discovered by Zone surveillance aircraft N309VS. The fire was 1 acre in tundra with no active perimeter or smokes showing. The fire plotted in Limited and was placed in monitor status.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 10:48\",\n",
      "\t\tdiscovered: \"09 Jul 2017, 03:37\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Charley\",\n",
      "\t\tcenter: new google.maps.LatLng(65.6901667, -143.0935),\n",
      "\t\tacreage: 14.6,\n",
      "\t\tmaintext: \"At 1315 the fire was flown by zone surveillance aircraft N9011N. No smokes were visible and no change observed.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 08:15\",\n",
      "\t\tdiscovered: \"28 Jun 2017, 08:04\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"East Tetlin\",\n",
      "\t\tcenter: new google.maps.LatLng(63.0278889, -142.2871667),\n",
      "\t\tacreage: 2.8,\n",
      "\t\tmaintext: \"Fire is contained and controlled, and will be placed into monitor status.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 21:58\",\n",
      "\t\tdiscovered: \"10 Jul 2017, 08:12\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Dorothy Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(67.6928056, -142.2386944),\n",
      "\t\tacreage: 2876.5,\n",
      "\t\tmaintext: \"At 1545 zone surveillance aircraft N222ME flew reconnaissance over the fire. No smokes and no active perimeter were observed.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 10:50\",\n",
      "\t\tdiscovered: \"30 Jun 2017, 07:08\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Trout Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.1022222, -141.6383333),\n",
      "\t\tacreage: 226.2,\n",
      "\t\tmaintext: \"Increase in acreage matches latest perimeter.\",\n",
      "\t\tlastupdated: \"12 Jul 2017, 22:07\",\n",
      "\t\tdiscovered: \"21 Jun 2017, 11:37\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Campbell River\",\n",
      "\t\tcenter: new google.maps.LatLng(67.2183056, -141.0150278),\n",
      "\t\tacreage: 45521.7,\n",
      "\t\tmaintext: \"At 1500 the fire was flown by zone surveillance aircraft N222ME. The fire was 25 percent active and was spreading to the north. Observed fire behavior included backing and torching in black spruce with 10 foot flame lengths. Weather observed included wind out of the north at 10 mph with 10 percent cloud cover and no precipitation.  Fire is most active on the SW edge.  A 12 mile line of fire has burned 2.10 miles south of the Salmon Trout allotment.   Resources on scene of the allotment and cabin continued to monitor weather and fuel conditions in preparation for a burnout operation. Higher relative humidities kept fuels damp and no burn was attempted. The Midnight Sun IHC began to pretreat areas around the allotment with water.  Tommorow personnel will continue monitoring conditions. A helicopter reconnaissance flight has been scheduled for tomorrow (7/14).\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 13:05\",\n",
      "\t\tdiscovered: \"26 Jun 2017, 09:14\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Coal Creek 17\",\n",
      "\t\tcenter: new google.maps.LatLng(64.0361333, -148.5646333),\n",
      "\t\tacreage: 0.5,\n",
      "\t\tmaintext: \"H120SH flew fire, currently 1/2 acre barely smoking.  Little to no spread.\",\n",
      "\t\tlastupdated: \"07 Jul 2017, 05:18\",\n",
      "\t\tdiscovered: \"06 Jun 2017, 02:01\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Coal Creek South\",\n",
      "\t\tcenter: new google.maps.LatLng(64.029783, -148.56375),\n",
      "\t\tacreage: 1.5,\n",
      "\t\tmaintext: \"H120SH flew fire, currently 1.5 acres, 1-2` flame lengths on the uphill west side.  No action taken, remaining in monitor status.\",\n",
      "\t\tlastupdated: \"07 Jul 2017, 05:10\",\n",
      "\t\tdiscovered: \"06 Jun 2017, 04:18\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Live Valley\",\n",
      "\t\tcenter: new google.maps.LatLng(64.7073889, -146.5471111),\n",
      "\t\tacreage: 0.4,\n",
      "\t\tmaintext: \"Range Control reported the fire as two small grass fires adjacent to one another and just under one half acre in size. Skies were overcast with a 7 mph SSW wind. Zone detection aircraft N9011N flew a reconnaissance mission over the area in the evening but were unable to locate any sign of the fire.\",\n",
      "\t\tlastupdated: \"17 Jun 2017, 02:41\",\n",
      "\t\tdiscovered: \"16 Jun 2017, 04:56\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Boulder Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(67.45, -143.7333333),\n",
      "\t\tacreage: 23383.9,\n",
      "\t\tmaintext: \"Zone surveillance aircraft N222ME flew the fire and reported it with a 30 percent active perimeter and spreading to the north. The fire was creeping and backing with isolated torching in black spruce. Observations were taken under 30 percent cloud cover with calm winds.   Personnel on the ground continued to improve upon the saw line around the allotment. An UAS (unmanned aircraft system) was launched and performed a recon over the fire.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:49\",\n",
      "\t\tdiscovered: \"02 Jul 2017, 07:12\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Allen\",\n",
      "\t\tcenter: new google.maps.LatLng(62.5551667, -163.1535),\n",
      "\t\tacreage: 2583.5,\n",
      "\t\tmaintext: \"Increase in acreage due to uploaded perimeter.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 01:13\",\n",
      "\t\tdiscovered: \"07 Jun 2017, 00:03\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Wolf Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(62.2952778, -161.4383333),\n",
      "\t\tacreage: 5.2,\n",
      "\t\tmaintext: \"Change in acreage due to more accurate, digitized mapping.\",\n",
      "\t\tlastupdated: \"04 Jul 2017, 03:49\",\n",
      "\t\tdiscovered: \"03 Jun 2017, 11:11\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Little Yetna River\",\n",
      "\t\tcenter: new google.maps.LatLng(62.570333, -158.577333),\n",
      "\t\tacreage: 16514,\n",
      "\t\tmaintext: \"The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:04\",\n",
      "\t\tdiscovered: \"04 Jun 2017, 07:52\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Kobe Field\",\n",
      "\t\tcenter: new google.maps.LatLng(64.25645, -149.354467),\n",
      "\t\tacreage: 4.2,\n",
      "\t\tmaintext: \"Prevention engine checked fire, found smoke in the NE corner of the slop over.  Added water, will have Forestry engine check 7/4/17.\",\n",
      "\t\tlastupdated: \"07 Jul 2017, 05:02\",\n",
      "\t\tdiscovered: \"27 Jun 2017, 19:40\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Old Lost Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(66.0363333, -148.0646667),\n",
      "\t\tacreage: 3,\n",
      "\t\tmaintext: \"At 1350 the fire was flown by zone surveillance aircraft N9011N. The fire was active with 3 foot flame lengths. Single tree torching was observed. Fire size had increased to approximately 3 acres.\",\n",
      "\t\tlastupdated: \"08 Jul 2017, 10:01\",\n",
      "\t\tdiscovered: \"07 Jul 2017, 06:52\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Preacher Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.95, -144.8),\n",
      "\t\tacreage: 74.8,\n",
      "\t\tmaintext: \"Increase in acreage from updated infrared imaging.\",\n",
      "\t\tlastupdated: \"11 Jul 2017, 14:52\",\n",
      "\t\tdiscovered: \"08 Jul 2017, 04:19\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Deadmans Slough\",\n",
      "\t\tcenter: new google.maps.LatLng(62.6342222, -160.2121944),\n",
      "\t\tacreage: 322.6,\n",
      "\t\tmaintext: \"As off 1100, the fire has been called controlled and placed into monitor status. All resources have been demobilized from this fire.\",\n",
      "\t\tlastupdated: \"23 Jun 2017, 23:49\",\n",
      "\t\tdiscovered: \"04 Jun 2017, 11:22\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Tenmile\",\n",
      "\t\tcenter: new google.maps.LatLng(64.0763889, -159.5341667),\n",
      "\t\tacreage: 51.6,\n",
      "\t\tmaintext: \"Decrease in acreage due to more accurate mapping.\",\n",
      "\t\tlastupdated: \"27 Jun 2017, 02:40\",\n",
      "\t\tdiscovered: \"07 Jun 2017, 11:17\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"American Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(63.173333, -156.842833),\n",
      "\t\tacreage: 12945,\n",
      "\t\tmaintext: \"The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"04 Jun 2017, 06:59\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"White Snow\",\n",
      "\t\tcenter: new google.maps.LatLng(67.5953055, -144.0851667),\n",
      "\t\tacreage: 338.6,\n",
      "\t\tmaintext: \"The fire was flown by surveillance aircraft N222ME. Fire 312 has consumed fire 303.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:48\",\n",
      "\t\tdiscovered: \"04 Jul 2017, 08:40\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"2017 Windfall Mountain Overwinter _1\",\n",
      "\t\tcenter: new google.maps.LatLng(65.0298056, -141.2518611),\n",
      "\t\tacreage: 45.2,\n",
      "\t\tmaintext: \"Fire was flown today by zone aircraft N309VS.  The observer on board reported no active perimeter or acreage gain. Some visible smoke within the fissure.\",\n",
      "\t\tlastupdated: \"07 Jul 2017, 04:46\",\n",
      "\t\tdiscovered: \"31 Dec 2016, 15:01\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"White Mountain Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(67.4532778, -141.3181389),\n",
      "\t\tacreage: 62800.9,\n",
      "\t\tmaintext: \"The fire was flown by surveillance aircraft N222ME. The fire area was too smokey to make observations. New fire size result of update imaging.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:48\",\n",
      "\t\tdiscovered: \"03 Jul 2017, 06:09\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Omikmuktusuk\",\n",
      "\t\tcenter: new google.maps.LatLng(69.679, -159.622),\n",
      "\t\tacreage: 1647.4,\n",
      "\t\tmaintext: \"Increase in acreage due to updated LandSat perimeter.\",\n",
      "\t\tlastupdated: \"04 Jul 2017, 03:02\",\n",
      "\t\tdiscovered: \"28 Jun 2017, 09:24\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Ketik River\",\n",
      "\t\tcenter: new google.maps.LatLng(69.7545, -159.0356667),\n",
      "\t\tacreage: 2870.3,\n",
      "\t\tmaintext: \"Increase in acreage due to new LandSat perimeter.\",\n",
      "\t\tlastupdated: \"04 Jul 2017, 03:03\",\n",
      "\t\tdiscovered: \"28 Jun 2017, 09:24\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Wayne Taylor\",\n",
      "\t\tcenter: new google.maps.LatLng(61.019074, -157.429832),\n",
      "\t\tacreage: 127,\n",
      "\t\tmaintext: \"The fire was flown by 35E.  No activity was observed and the fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"25 Jun 2017, 11:53\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Pitka Fork\",\n",
      "\t\tcenter: new google.maps.LatLng(62.425, -154.057167),\n",
      "\t\tacreage: 16823.9,\n",
      "\t\tmaintext: \"Personnel began backhauling structure protection equipment.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"04 Jun 2017, 09:18\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Kroto Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(62.0549444, -150.43525),\n",
      "\t\tacreage: 0.2,\n",
      "\t\tmaintext: \"The fire was reported by a private pilot.  Forestry`s helitack responded to the reported coordinates and located a .2 acre smoldering fire.  The helitack crew suppressed the fire and placed it in monitor status.\",\n",
      "\t\tlastupdated: \"06 Jul 2017, 22:30\",\n",
      "\t\tdiscovered: \"06 Jul 2017, 00:07\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Loper Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.6925, -145.5515),\n",
      "\t\tacreage: 2549.3,\n",
      "\t\tmaintext: \"Fire flown by Zone aircraft N309VS, personnel on board reported no visible smokes.\",\n",
      "\t\tlastupdated: \"09 Jul 2017, 10:49\",\n",
      "\t\tdiscovered: \"27 Jun 2017, 06:51\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"WL 543T\",\n",
      "\t\tcenter: new google.maps.LatLng(67.0030278, -144.6955833),\n",
      "\t\tacreage: 1,\n",
      "\t\tmaintext: \"The fire was discovered by zone aircraft N222ME during a detection flight. Personnel on board reported a 1 acre fire, 100 percent active, burning on flat terrain in black spruce. The fire plotted in a Limited suppression area and no values at risk were identified. The Upper Yukon Zone will continue to monitor this fire with aerial resources.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:39\",\n",
      "\t\tdiscovered: \"13 Jul 2017, 09:15\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"George Lake Hills\",\n",
      "\t\tcenter: new google.maps.LatLng(63.75, -144.316667),\n",
      "\t\tacreage: 0,\n",
      "\t\tmaintext: \"A small column of smoke was reported to the duty officer around 22:30 on 7/12 by a resident on Sand Lake.  Helitack responded after the fog and mist lifted on 7/13.  The reporter could no longer see any smoke once helitack was launched.  Helicopter 873HL thoroughly scanned the area and did not find any blackened ground or smoke.  It is planned to search the area on 7/14 when the weather is forecasted to be warmer and clearer.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"13 Jul 2017, 00:10\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Rat Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(66.8833333, -142.4833333),\n",
      "\t\tacreage: 11757.7,\n",
      "\t\tmaintext: \"Zone surveillance aircraft N22ME flew the fire and reported the perimeter to be 5% active, smoldering in tundra. No change is size was observed.\",\n",
      "\t\tlastupdated: \"10 Jul 2017, 13:51\",\n",
      "\t\tdiscovered: \"29 Jun 2017, 05:11\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Lois Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(68.2916667, -142.0123333),\n",
      "\t\tacreage: 27629.4,\n",
      "\t\tmaintext: \"Zone aircraft N222ME flew the fire and reported a 10 percent active perimeter.  Active burning was observed on the NE, NW and SE corners of the fire.  The fire continues to burn north of the Colleen River and west of Lois Creek.  Increase in acres reflects newer perimeter data.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 10:40\",\n",
      "\t\tdiscovered: \"02 Jul 2017, 09:28\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Pastolik\",\n",
      "\t\tcenter: new google.maps.LatLng(62.7103889, -163.032),\n",
      "\t\tacreage: 11.5,\n",
      "\t\tmaintext: \"Increase in acreage due to more accurate mapping\",\n",
      "\t\tlastupdated: \"27 Jun 2017, 04:16\",\n",
      "\t\tdiscovered: \"08 Jun 2017, 12:44\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Khotol\",\n",
      "\t\tcenter: new google.maps.LatLng(64.3261111, -158.2422222),\n",
      "\t\tacreage: 514.5,\n",
      "\t\tmaintext: \"Resources are facing a very active fire while protecting a cabin and 2 allotments.  Eight smokejumpers have been placed on the eastern portion of the allotments and are planning to burn out the area either late tonight or in the morning. The remaining 8 smokejumpers are prepping the rest of the allotments with hose lay and plumbing.  Zone aircraft H-361EH assisted the fire with supplies and bucket drops while N864SF assisted the smokejumpers on the ground with aerial observations and updates of the fire activity.  Depending on the success of the burnout operations, the fire could be mopped up within a few days time.\",\n",
      "\t\tlastupdated: \"14 Jul 2017, 01:05\",\n",
      "\t\tdiscovered: \"06 Jun 2017, 10:05\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Ball Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(62.468167, -157.64295),\n",
      "\t\tacreage: 13924,\n",
      "\t\tmaintext: \"The fire was flown by 904AK.  Personnel observed no activity and the fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"04 Jun 2017, 12:53\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Narvak Lake\",\n",
      "\t\tcenter: new google.maps.LatLng(66.946, -155.6475),\n",
      "\t\tacreage: 491.6,\n",
      "\t\tmaintext: \"Updated acreage due to more accurate mapping.\",\n",
      "\t\tlastupdated: \"11 Jul 2017, 12:09\",\n",
      "\t\tdiscovered: \"27 Jun 2017, 12:15\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"North Robertson\",\n",
      "\t\tcenter: new google.maps.LatLng(63.527733, -143.916883),\n",
      "\t\tacreage: 832,\n",
      "\t\tmaintext: \"The fire was flown today, no smokes were seen. The fire will remain in monitor status.\",\n",
      "\t\tlastupdated: \"28 Jun 2017, 20:00\",\n",
      "\t\tdiscovered: \"01 Jun 2017, 02:21\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Seven Mile\",\n",
      "\t\tcenter: new google.maps.LatLng(65.4047778, -142.4603889),\n",
      "\t\tacreage: 135.8,\n",
      "\t\tmaintext: \"Zone surveillance in aircraft N222ME flew the fire and reported a 5 percent active perimeter, smoldering along the ridgetop. No additional growth was visible. The fire remained 2.15 miles northeast of a National Park Service cabin. Decrease in acreage due to more accurate mapping.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 07:25\",\n",
      "\t\tdiscovered: \"29 Jun 2017, 07:08\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"North Fork\",\n",
      "\t\tcenter: new google.maps.LatLng(64.202, -159.9615),\n",
      "\t\tacreage: 306.8,\n",
      "\t\tmaintext: \"N864SF flew the fire and observed there to be no smokes showing.The fire will remain in monitor status\",\n",
      "\t\tlastupdated: \"27 Jun 2017, 07:27\",\n",
      "\t\tdiscovered: \"06 Jun 2017, 12:10\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Bell Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(61.918633, -158.081667),\n",
      "\t\tacreage: 2653,\n",
      "\t\tmaintext: \"The fire was flown by 35E.  No activity was observed and the fire remains in monitor status.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 20:03\",\n",
      "\t\tdiscovered: \"04 Jun 2017, 11:05\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Kihovilik Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(66.6346667, -157.1596667),\n",
      "\t\tacreage: 3130,\n",
      "\t\tmaintext: \"Identified areas of growth using Landsat 8 image acquired 7/11 @ 2300.  Updated size to 3130 acres.\",\n",
      "\t\tlastupdated: \"12 Jul 2017, 11:54\",\n",
      "\t\tdiscovered: \"27 Jun 2017, 13:15\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Larsen Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(65.4581667, -151.1717778),\n",
      "\t\tacreage: 90,\n",
      "\t\tmaintext: \"Zone surveillance in aircraft N309VS flew the fire and reported no active perimeter. The western interior of the fire was smoldering.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 11:35\",\n",
      "\t\tdiscovered: \"04 Jul 2017, 08:03\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Potholes\",\n",
      "\t\tcenter: new google.maps.LatLng(63.912, -146.0013333),\n",
      "\t\tacreage: 0.2,\n",
      "\t\tmaintext: \"Zone detection aircraft N700FW flew the fire area today. Smoke observed in the northeast corner of the 1/4 acre. No change in size.\",\n",
      "\t\tlastupdated: \"30 Jun 2017, 12:49\",\n",
      "\t\tdiscovered: \"28 Jun 2017, 11:02\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Monument Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(68.062, -143.8425833),\n",
      "\t\tacreage: 426.8,\n",
      "\t\tmaintext: \"Fire was flown by zone detection aircraft N222ME and no visible smoke or active perimeter was observed. Update in acreage is due to more accurate mapping.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 11:16\",\n",
      "\t\tdiscovered: \"05 Jul 2017, 07:22\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\tfire = {\n",
      "\t\tdesignation: \"Lake Creek\",\n",
      "\t\tcenter: new google.maps.LatLng(67.5075, -142.1595),\n",
      "\t\tacreage: 2228.8,\n",
      "\t\tmaintext: \"Zone surveillance aircraft N22ME flew the fire and reported no activity. Observations were taken under clear skies.\",\n",
      "\t\tlastupdated: \"13 Jul 2017, 11:08\",\n",
      "\t\tdiscovered: \"02 Jul 2017, 08:07\",\n",
      "\t\tcurrent: false\n",
      "\t};\n",
      "\tfiremap.push(fire);\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(fires)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Globbedy-glob glob glob ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "ALREADYLOADED = 'aiccfilelist.txt'\n",
    "LASTFIREDATA = 'firedata.pickle'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "try:\n",
    "    with open(ALREADYLOADED, 'r') as source:\n",
    "        oldfilelist = [\n",
    "            fn.strip() for fn in source.readlines()\n",
    "        ]\n",
    "except IOError:\n",
    "    oldfilelist = []\n",
    "filelist = sorted(\n",
    "    set(glob.glob('archive/2017*_blmfiredata.txt')) - set(oldfilelist)\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "for file in filelist:\n",
    "    print(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fieldmap = blm.FIELDMAP\n",
    "fieldmap['lastupdatedatetime'] = 'firesadmin.dailyfirerecord.lastupdatedatetime'\n",
    "fieldmap['discoverydatetime'] = 'firesadmin.fire.discoverydatetime'\n",
    "fieldmap['controldatetime'] = 'firesadmin.fire.controldatetime'\n",
    "fieldmap['containmentdatetime'] = 'firesadmin.fire.containmentdatetime'\n",
    "fieldmap['guid'] = 'firesadmin.fire.irwinid'\n",
    "fieldmap['totalcost'] = 'firesadmin.fire.estimatedtotalcost'\n",
    "fieldmap['cause'] = 'firesadmin.fire.generalcause'\n",
    "fieldmap['id'] = 'firesadmin.fire.id'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(filelist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def getfiredf(filepath):\n",
    "    data = blm.get_raw_fire_data(filepath, tryremote=False)\n",
    "    fieldnames = blm.sanitize_dataline(data[0], blanks=3, lower=True)\n",
    "    rawdata = [blm.sanitize_dataline(\n",
    "                item.strip(), blanks=2, lower=False) for item in data[1::2]]\n",
    "\n",
    "    # the transformed data will be a list of dictionaries\n",
    "    data = blm.get_firedata(fieldnames, rawdata)\n",
    "    firedf = pd.DataFrame(data, columns=list(fieldmap.values()))\n",
    "    firedf.columns = [list(fieldmap.keys())]\n",
    "    firedf = cleanup_df(firedf)\n",
    "    firedf['id'] = firedf['id'].astype('int')\n",
    "    firedf.set_index('id', inplace=True)\n",
    "    return firedf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def mergefireupdate(basefiredf, newfiredf):\n",
    "    now = dt.datetime.now()\n",
    "    for index, row in newfiredf.iterrows():\n",
    "        try: \n",
    "            comparecond = (~(\n",
    "                basefiredf.loc[index, ['acreage', 'maintext']] == newfiredf.loc[index, ['acreage', 'maintext']])).any()\n",
    "            if comparecond:\n",
    "                basefiredf.loc[index, 'prev_acreage'] = basefiredf.loc[index, 'acreage'] \n",
    "                basefiredf.loc[index, 'prev_text'] = basefiredf.loc[index, 'maintext'] \n",
    "                basefiredf.loc[index, basefields] = newfiredf.loc[index, basefields]\n",
    "                basefiredf.loc[index, 'updatecount'] += 1\n",
    "        except KeyError:\n",
    "                basefiredf.loc[index] = newfiredf.loc[index]\n",
    "                basefiredf.loc[index, 'updatecount'] = 1\n",
    "                basefiredf.loc[index, 'prev_acreage'] = np.nan\n",
    "                basefiredf.loc[index, 'prev_text'] = ''\n",
    "                basefiredf.loc[index, 'current'] = True\n",
    "        if ((now - basefiredf.loc[index, 'lastupdatedatetime']).days > 8):\n",
    "            basefiredf.loc[index, 'current'] = False\n",
    "    return basefiredf\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "try:\n",
    "    firedf = pd.read_pickle(LASTFIREDATA)\n",
    "    startidx = 0\n",
    "except FileNotFoundError:\n",
    "    firedf = getfiredf(filelist[0])\n",
    "    firedf['prev_acreage'] = np.nan\n",
    "    firedf['prev_text'] = ''\n",
    "    firedf['current'] = True\n",
    "    firedf['updatecount'] = 1\n",
    "    startidx = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "basefields = list(fieldmap.keys())\n",
    "basefields.remove('id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "for fn in filelist[startidx:]:\n",
    "    print(\"Opening {}\".format(fn))\n",
    "    try:\n",
    "        newfiredf = getfiredf(fn)\n",
    "        newfiredf['prev_acreage'] = np.nan\n",
    "        newfiredf['prev_text'] = ''\n",
    "        newfiredf['current'] = True\n",
    "        newfiredf['updatecount'] = 1\n",
    "    except IOError:\n",
    "        continue\n",
    "    except IndexError:\n",
    "        continue\n",
    "    firedf0 = mergefireupdate(firedf, newfiredf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def savecurrentstate(filelist, firedf0, outfile, outdataframe):\n",
    "    with open(outfile, 'w') as dest:\n",
    "        for line in oldfilelist:\n",
    "            print(line, file=dest)\n",
    "        for line in filelist:\n",
    "            print(line, file=dest)\n",
    "    firedf0.to_pickle(outdataframe)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "savecurrentstate(filelist, firedf, 'aiccfilelist.txt', 'firedata.pickle')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.04659065932137042"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sqkm(215, .4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'acreage': 1.0,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Red Hill Creek',\n",
       "  'discoverydatetime': Timestamp('2017-09-16 17:00:39.221000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-09-16 20:45:38.221000'),\n",
       "  'latitude': '62.08415',\n",
       "  'longitude': '-142.017017',\n",
       "  'maintext': 'A Chisana resident report smoke to the Tok Forestry fire line.  Tok forestry contacted the duty officer for the Copper River office.  The fire was reported to be east of Chisana in the Red Hills Creek drainage.  The fire was flown by the National Parks Service.  Reported at 1 acre on a hill top in black spruce, brush and muskeg. One tree torched and settled down. The fire was not traveling at that time. The Park Service would like full suppression action taken on the fire. Fire suppression activities will take place on the next shift.',\n",
       "  'prev_acreage': 1.0,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Tanana River 15 Mile',\n",
       "  'discoverydatetime': Timestamp('2017-09-14 10:05:59.356000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-09-15 15:45:49.356000'),\n",
       "  'latitude': '64.74712',\n",
       "  'longitude': '-149.11415',\n",
       "  'maintext': 'Personnel accessed the fire via boat and began extinguishment and mop up. Observed fire behavior included smoldering in tundra and spruce/hardwood mix. No resources were threatened. Personnel will mop up and containment efforts during next operational shift.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': 'A fire was reported on the bank of the Tanana River approximately 15 miles downriver from Nenana. Reporting party stated the fire was approximately 50`x50` and smoldering in black spruce and moss. During next operational shift, DOF personnel will go to the fire via boat and begin mop up.'},\n",
       " {'acreage': 5.0,\n",
       "  'cause': '',\n",
       "  'designation': 'Blair Lakes 3',\n",
       "  'discoverydatetime': Timestamp('2017-08-17 16:26:21.793000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-17 16:31:00.793000'),\n",
       "  'latitude': '64.3333333',\n",
       "  'longitude': '-147.4205',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Cottonwood Lake',\n",
       "  'discoverydatetime': Timestamp('2017-08-15 19:38:21.079000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-15 20:33:25.079000'),\n",
       "  'latitude': '61.598317',\n",
       "  'longitude': '-149.320333',\n",
       "  'maintext': 'The fire was reported by MatCom (911) as a fire on Cottonwood Lake Island.  One Forestry prevention officer responded to the closest public boat launch and unified command with Central Mat Su Fire Dept.  After a short boat trip personnel located a deep seeded root fire.  The fire was suppressed and and called out.',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Lasoda Road',\n",
       "  'discoverydatetime': Timestamp('2017-08-11 10:26:41.644000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-12 16:11:25.644000'),\n",
       "  'latitude': '64.741683',\n",
       "  'longitude': '-148.22915',\n",
       "  'maintext': 'Personnel returned to the fire to grid for heat. One hot spot was found and extinguished. The fire was placed in monitor status.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': 'At 1015, a fire was reported near Bonanza Creek approximately 10 miles southeast of Ester. A DOF engine responded and personnel made access to the fire on four wheelers. The fire was 20`x20` burning in white spruce and hardwoods. Observed fire behavior included a 70% active perimeter with 1` flame lengths. The fire plotted in Full suppression management area and it was determined that action needed to be taken. A squad arrived to assist DOF engine personnel with extinguishment and mop up. During the next operational shift, personnel will return to the fire to continue mop up and begin gridding the area.'},\n",
       " {'acreage': 0.8,\n",
       "  'cause': 'Human',\n",
       "  'designation': '.5 Tok Cut-Off',\n",
       "  'discoverydatetime': Timestamp('2017-08-10 00:17:37.314000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-12 06:48:00.314000'),\n",
       "  'latitude': '62.2889722',\n",
       "  'longitude': '-145.3394722',\n",
       "  'maintext': 'Personnel checked the fire and found no heat or smoke.',\n",
       "  'prev_acreage': 0.8,\n",
       "  'prev_text': 'Personnel checked the fire and found no heat or smoke.  The fire remains in monitor status.'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': '',\n",
       "  'designation': 'Sixmile Creek',\n",
       "  'discoverydatetime': Timestamp('2017-08-11 15:31:39.164000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-11 15:43:00.164000'),\n",
       "  'latitude': '65.7986945',\n",
       "  'longitude': '-144.0829722',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Surrey',\n",
       "  'discoverydatetime': Timestamp('2017-08-08 09:13:40.628000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-10 05:29:00.628000'),\n",
       "  'latitude': '61.5203333',\n",
       "  'longitude': '-149.5266111',\n",
       "  'maintext': 'The fire was checked today, significant heat was still showing in parts of the structure.  Water was distributed around the perimeter and the fire will remain in monitor status.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': 'The fire was checked today, significate heat was still showing in parts of the structure.  Water was distributed around the perimter and the fire will remain in monitor status.'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Middle Nenana River',\n",
       "  'discoverydatetime': Timestamp('2017-08-08 18:47:32.498000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-09 20:09:07.498000'),\n",
       "  'latitude': '64.571833',\n",
       "  'longitude': '-149.15',\n",
       "  'maintext': 'A squad of 7 personnel were shuttled to the fire via boat to assist with mop up efforts. Observed fire behavior included smoldering approximately 1 foot deep in the duff layer; however, there was no active perimeter and the fire did not increase in size. The fire was contained and personnel will continue mop up during next operational shift.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': 'At 1842 a fire was reported one mile up the Middle Nenana River west of the City of Nenana. Air attack N5035E and UYT H-580SH responded to the fire as well as a DOF engine with a boat. The fire was approximately 100` x 50` in size, smoldering and creeping in white spruce and moss. The fire plotted in Full suppression management area and it was determined that action needed to be taken. H-580 conducted bucket work and DOF personnel arrived at the fire via boat. No additional resources were requested. DOF personnel set up a pump and began containment efforts. During the next operational shift, personnel will continue efforts to contain the fire and begin mopping up.'},\n",
       " {'acreage': 0.0,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Chistochina River',\n",
       "  'discoverydatetime': Timestamp('2017-08-04 15:02:51.594000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-05 08:22:00.594000'),\n",
       "  'latitude': '62.61744',\n",
       "  'longitude': '-144.61928',\n",
       "  'maintext': 'At 1502 a dark smoke column wiht flames visible above the trees was reported north the Tok Cutoff at mile 36.5. Forestry engines, A/A 35E, FIRB 208/209 & 242/243, H-83230, J-17, J-12 and Gakona VFD worked together to stop the spread of teh fire towards residences and the highway. Good progress was made and the fire was knocked down. Suppression efforts will continue 8/5 with the help of the UAF Nanooks and the Minto T2 Crew.',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Hope',\n",
       "  'discoverydatetime': Timestamp('2017-08-01 18:23:18.753000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-04 05:31:00.753000'),\n",
       "  'latitude': '60.9195',\n",
       "  'longitude': '-149.62',\n",
       "  'maintext': 'Fire was checked by Fuels Crew, found no smokes or heat, will continue to monitor it.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': 'Fire was checked by Fuels Crew, found not smokes or heat, will continue to moniter it.'},\n",
       " {'acreage': 50.0,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Fisher Creek',\n",
       "  'discoverydatetime': Timestamp('2017-07-30 19:00:43.233000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-01 22:35:00.233000'),\n",
       "  'latitude': '65.0736389',\n",
       "  'longitude': '-142.43825',\n",
       "  'maintext': 'Zone surveillance aircraft N9011N flew the fire area; personnel aboard the aircraft observed no smoke. Sky weather was one hundred percent cloud cover and light precipitation.',\n",
       "  'prev_acreage': 50.0,\n",
       "  'prev_text': 'Discovered by zone detection aircraft N309VS the fire plotted in a Limited protection area. Burned in a black spruce fuel type; there was no activity and no smoke showing.'},\n",
       " {'acreage': 5.0,\n",
       "  'cause': '',\n",
       "  'designation': 'Shovun Lake',\n",
       "  'discoverydatetime': Timestamp('2017-07-29 15:13:11.752000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-08-01 19:22:00.752000'),\n",
       "  'latitude': '66.74575',\n",
       "  'longitude': '-145.3830278',\n",
       "  'maintext': 'Fire behavior observed today was creeping in the interior. The observed weather conditions were mostly cloudy, with 5-10 mph winds. The plan for the morning is to continue gridding for hot spots and demobilization is planned for tomorrow evening.',\n",
       "  'prev_acreage': 5.0,\n",
       "  'prev_text': 'Smokejumper personnel on scene made good progress mopping up today with the support of H-580SH. The helicopter was utilized to deliver water to a portable tank set up near the fire in order to enable mop up using pumps and hose. Thunder cells throughout the day impacted the area though no precipitation had been received at last report. Updated acreage due to more accurate mapping.'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': '38 Mile Steese Hwy',\n",
       "  'discoverydatetime': Timestamp('2017-07-29 19:11:55.100000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-29 21:32:05.100000'),\n",
       "  'latitude': '65.1875',\n",
       "  'longitude': '-147.288056',\n",
       "  'maintext': 'A smoke was reported in the area of milepost 38 of the Steese Highway. A DOF engine responded and found a single tree on fire with no active perimeter and minimal fire behavior. No resources were threatened and the fire received precipitation. The fire was across the Chatanika River and personnel were unable to make access to the fire. During the next operational shift, DOF personnel will access the fire by boat and begin mopping up.',\n",
       "  'prev_acreage': 0.0,\n",
       "  'prev_text': 'A smoke was reported in the area of milepost 38 of the Steese Highway. A DOF engine responded and found a single tree on fire with no active perimeter and minimal fire behavior. No resources were threatened and the fire received precipitation. The fire was across the Chatanika River and personnel were unable to make access to the fire. During the next operational shift, DOF personnel will access the fire by boat and begin mopping up.'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Bear',\n",
       "  'discoverydatetime': Timestamp('2017-07-26 14:14:07.184000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-28 05:42:00.184000'),\n",
       "  'latitude': '60.1988333',\n",
       "  'longitude': '-149.3458333',\n",
       "  'maintext': 'Fire was Contained and Controled today. CGF fire crew will take a boat across the lake and check the fire on Friday to hopefully declair it out..',\n",
       "  'prev_acreage': 0.0,\n",
       "  'prev_text': 'Fire was Contained and Controled today.  Fire CGF fire crew will take a boat across the lake and check the fire on Friday to hopefully declair it out..'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Grand Ave',\n",
       "  'discoverydatetime': Timestamp('2017-07-26 13:32:38.434000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-27 09:48:00.434000'),\n",
       "  'latitude': '61.7135278',\n",
       "  'longitude': '-148.8896944',\n",
       "  'maintext': '911 reported a structure fire with possible wildland involvement.  On location Forestry located minimal wildland fire activity.  Engine crew members suppressed the fire and placed it in monitor status.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': '911 reported a structure fire with possible wildland involvement.  On location Forestry located minimal wildland in fire.  Engine crew members suppressed the fire and placed it on monitor status.'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Twelve Mile',\n",
       "  'discoverydatetime': Timestamp('2017-07-23 17:34:08.913000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-24 06:58:00.913000'),\n",
       "  'latitude': '64.1333333',\n",
       "  'longitude': '-141.5333334',\n",
       "  'maintext': 'This fire was a False Alarm.',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.4,\n",
       "  'cause': 'Human',\n",
       "  'designation': '0.5 Mile Murphy Dome Road',\n",
       "  'discoverydatetime': Timestamp('2017-07-23 15:11:54.249000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-23 22:43:34.249000'),\n",
       "  'latitude': '64.916422',\n",
       "  'longitude': '-147.94623',\n",
       "  'maintext': 'At 1511, two DOF engines and Chena Goldstream Fire and Rescue responded to a structure fire with wildland involvement on Murphy Dome Road. The structure was fully involved upon arrival and the wildland fire was approximately 0.25 acre in size and burning in black spruce with 1-4 foot flame lengths. The fire was located in a Critical suppression management area and a structure adjacent to the fire was threatened. DOF Helicopter H120SH responded and conducted bucket work over the fire. The fire was contained at 0.4 acres. During the next operational shift, DOF personnel will return to the fire to continue mop up.',\n",
       "  'prev_acreage': 0.4,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.2,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Lower Birch',\n",
       "  'discoverydatetime': Timestamp('2017-07-21 17:51:49.281000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-23 21:04:00.281000'),\n",
       "  'latitude': '66.4308055',\n",
       "  'longitude': '-146.8511111',\n",
       "  'maintext': 'Personnel mopped up the fire throughout the shift, minimal heat was found. All resources will be demobilized tomorrow (7/24).',\n",
       "  'prev_acreage': 0.2,\n",
       "  'prev_text': 'Personnel worked to secure the fire line and clean up downed trees. Progress continues through the mop up phase. Tentative demobilization on Monday (7/24).'},\n",
       " {'acreage': 11.8,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Jack White',\n",
       "  'discoverydatetime': Timestamp('2017-07-16 18:14:24.172000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-22 21:25:00.172000'),\n",
       "  'latitude': '66.965',\n",
       "  'longitude': '-151.28',\n",
       "  'maintext': 'Zone aircraft N309VS flew the fire area and observed no smoke or change in size. Resources performed a final grid of the fire and found no heat.  Helicopter N405AE was utilized to transport excess supplies to Bettles to prepare for demobilization.  All resources will demobilize from the incident tomorrow (7/23).',\n",
       "  'prev_acreage': 11.8,\n",
       "  'prev_text': 'Zone aircraft N309VS flew the fire area annd observed no smoke or change in size. Resources performed a final grid of the fire and found no heat.  Helicopter N405AE was utilized to transport excess supplies to Bettles to prepare for demobilization.  All resources will demobilize from the incident tomorrow (7/23).'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'MPMG 19',\n",
       "  'discoverydatetime': Timestamp('2017-07-21 16:15:09.649000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-21 16:20:00.649000'),\n",
       "  'latitude': '64.8023333',\n",
       "  'longitude': '-147.6473333',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 3.0,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Owens',\n",
       "  'discoverydatetime': Timestamp('2017-07-20 18:30:17.810000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-20 21:46:00.810000'),\n",
       "  'latitude': '67.6232778',\n",
       "  'longitude': '-143.2066944',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': '33 Mile Loop',\n",
       "  'discoverydatetime': Timestamp('2017-07-19 17:02:02.266000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-20 08:15:00.266000'),\n",
       "  'latitude': '63.9553889',\n",
       "  'longitude': '-145.5297222',\n",
       "  'maintext': 'A dozer contracted by the military caught fire in the Donnelly Training Area along the 33 Mile Loop road. Range control personnel responded and were able to suppress the fire before it advanced further  into the wildland. Additional resources from Delta responded but were not needed as range control reported they had contained the fire. Range personnel will check the site tomorrow (7/19).',\n",
       "  'prev_acreage': 0.1,\n",
       "  'prev_text': 'A dozer contracted by the military caught fire in the Donnelly Training Area along the 33 Mile Loop road. Range control personnel responded and were able to suppress the fire before it advanced to the wildland. Additional resources from Delta responded but were not needed as range control reported they had contained the fire. Range personnel will check the site tomorrow (7/19).'},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'McCoy Creek',\n",
       "  'discoverydatetime': Timestamp('2017-07-18 13:46:53.348000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-20 06:36:00.348000'),\n",
       "  'latitude': '64.49',\n",
       "  'longitude': '-146.356667',\n",
       "  'maintext': 'Received a report of a small fire smoldering just east of the pipeline.  H120SH flew the fire and dropped off the helitack load to begin suppression operations.  Fire was a 10 x 10 spot, rank 1 in black spruce 100 percent active.  Fire was extinguished and they began to green grid and cold trail the area.  3 Forestry personnel will remain overnight to ensure no further heats pop up and prepare for demobilization on Thursday.',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'SARKAR RIVER BRIDGE',\n",
       "  'discoverydatetime': Timestamp('2017-07-18 11:43:00.679000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-19 06:37:00.679000'),\n",
       "  'latitude': '55.9508333',\n",
       "  'longitude': '-133.2344444',\n",
       "  'maintext': 'Fire was called in by local citizen 7/18/17 at 0822.  Forest Service personnel responded and worked the fire and called it contained and in monitor status at 1400.  Will recheck tomorrow or next day.  All resources have been released.',\n",
       "  'prev_acreage': 0.0,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 3.0,\n",
       "  'cause': '',\n",
       "  'designation': 'Paddle Creek 2',\n",
       "  'discoverydatetime': Timestamp('2017-07-18 17:45:06.108000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-18 17:55:00.108000'),\n",
       "  'latitude': '65.9113333',\n",
       "  'longitude': '-143.2696667',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 3.6,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'John River',\n",
       "  'discoverydatetime': Timestamp('2017-07-14 13:51:48.163000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-17 13:02:00.163000'),\n",
       "  'latitude': '66.9699166',\n",
       "  'longitude': '-151.6166111',\n",
       "  'maintext': 'Four smokejumpers were demobilized from this incident and reassigned to fire 344.',\n",
       "  'prev_acreage': 3.6,\n",
       "  'prev_text': 'After performing a check of the fire in the morning hours, an area of heat was discovered.  The demobilization plan was adjusted to a later date to allow for full suppression of the newly discovered heat. Plans for tomorrow include the demobilization of the all 4 smokejumpers.'},\n",
       " {'acreage': 22.0,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Montana Creek',\n",
       "  'discoverydatetime': Timestamp('2017-07-14 19:03:52.758000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-15 21:16:11.758000'),\n",
       "  'latitude': '62.5425',\n",
       "  'longitude': '-157.453333',\n",
       "  'maintext': 'Fire personnel worked the fire through most the evening, and continued throughout the day. The fire was under 100 percent cloud cover, but never received any precipitation by evening time of 7/15. Tentative demob is planned for tomorrow, 7/16,  around mid afternoon. Acreage change due to gps mapping.',\n",
       "  'prev_acreage': 18.0,\n",
       "  'prev_text': 'The fire was found by multiple modis spots. BD-840 was launched from Palmer, and sized the fire up as 15 acres, 60 percent active, burning in grass and brush. J-07 responded, deploying 8 jumpers and sizing the fire up as 18 acres and 30 percent active. Personnel will take advantage of the high evening humidity, working late into the evening to help make significant progress towards their full suppression goals.'},\n",
       " {'acreage': 0.0,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'George Lake Hills',\n",
       "  'discoverydatetime': Timestamp('2017-07-13 08:10:24.348000'),\n",
       "  'lastupdatedatetime': Timestamp('2017-07-13 15:57:52.348000'),\n",
       "  'latitude': '63.75',\n",
       "  'longitude': '-144.316667',\n",
       "  'maintext': 'A small column of smoke was reported to the duty officer around 22:30 on 7/12 by a resident on Sand Lake.  Helitack responded after the fog and mist lifted on 7/13.  The reporter could no longer see any smoke once helitack was launched.  Helicopter 873HL thoroughly scanned the area and did not find any blackened ground or smoke.  It is planned to search the area on 7/14 when the weather is forecasted to be warmer and clearer.',\n",
       "  'prev_acreage': 0.0,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Salchaket Subdivision',\n",
       "  'discoverydatetime': Timestamp('2017-06-21 12:21:15.934000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '64.39848',\n",
       "  'longitude': '-146.777772',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 5.0,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'North Ladue River',\n",
       "  'discoverydatetime': Timestamp('2017-06-23 16:19:45.177000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '63.525883',\n",
       "  'longitude': '-140.87755',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Crooked Creek',\n",
       "  'discoverydatetime': Timestamp('2017-06-27 11:36:43.341000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '61.870333',\n",
       "  'longitude': '-158.105167',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Boulder Creek',\n",
       "  'discoverydatetime': Timestamp('2017-06-29 12:21:44.502000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '64.9',\n",
       "  'longitude': '-144.95',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Parks Pullout',\n",
       "  'discoverydatetime': Timestamp('2017-07-02 19:50:34.397000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '64.757317',\n",
       "  'longitude': '-148.3757',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Lac Viex',\n",
       "  'discoverydatetime': Timestamp('2017-07-04 11:27:19.262000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '61.516047',\n",
       "  'longitude': '-150.042347',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Hog Heaven',\n",
       "  'discoverydatetime': Timestamp('2017-07-05 11:02:33.983000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '61.925617',\n",
       "  'longitude': '-145.428167',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'False Alarm _11',\n",
       "  'discoverydatetime': Timestamp('2017-07-07 11:16:44.853000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '65.200167',\n",
       "  'longitude': '-148.054317',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Lightning',\n",
       "  'designation': 'Denali Hwy',\n",
       "  'discoverydatetime': Timestamp('2017-08-06 18:20:47.108000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '63.377153',\n",
       "  'longitude': '-148.785684',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'MP 1321',\n",
       "  'discoverydatetime': Timestamp('2017-08-15 19:51:55.094000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '63.34805',\n",
       "  'longitude': '-143.156417',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.1,\n",
       "  'cause': 'Human',\n",
       "  'designation': 'Handsome Hanson',\n",
       "  'discoverydatetime': Timestamp('2017-08-28 09:24:20.752000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '61.675629',\n",
       "  'longitude': '-149.51847',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''},\n",
       " {'acreage': 0.0,\n",
       "  'cause': 'Human',\n",
       "  'designation': '',\n",
       "  'discoverydatetime': Timestamp('2017-08-29 08:38:31.467000'),\n",
       "  'lastupdatedatetime': NaT,\n",
       "  'latitude': '61.58258',\n",
       "  'longitude': '-149.710078',\n",
       "  'maintext': '',\n",
       "  'prev_acreage': nan,\n",
       "  'prev_text': ''}]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "firedf[firedf['current']][[\n",
    "    'designation', 'cause', 'acreage', 'prev_acreage', \n",
    "    'lastupdatedatetime', 'discoverydatetime', 'maintext', 'prev_text', 'longitude', 'latitude']].sort_values(\n",
    "    by='lastupdatedatetime', ascending=False).to_dict('records')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import math\n",
    "def sqkm(acres, perc):\n",
    "    return math.sqrt(acres/2.5/100) * perc * 3.14 * 2 * 0.02"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.32781744367498206"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sqkm(2661, .8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda env:snowflakes35]",
   "language": "python",
   "name": "conda-env-snowflakes35-py"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}