Finding the most critical DC bridge infrastructure - v2.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"img/Act2_Pic01_Short.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"img/Act2_Pic02_Alt.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Setup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import arcpy\n",
    "import arcgis\n",
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "gis = arcgis.gis.GIS(url=\"https://ndirt.maps.arcgis.com\", username=\"ANieto_ndirt\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "bridge_item = gis.content.search(\"DCVAMD_NBI_Bridges\", item_type=\"feature service\")[0]\n",
    "bridge_item"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "deficient_bridge_item = gis.content.search(\"DCVAMD_CBSA_DeficientBridges\", item_type=\"feature service\")[0]\n",
    "deficient_bridge_item"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div class=\"item_container\" style=\"height: auto; overflow: hidden; border: 1px solid #cfcfcf; border-radius: 2px; background: #f6fafa; line-height: 1.21429em; padding: 10px;\">\n",
       "                    <div class=\"item_left\" style=\"width: 210px; float: left;\">\n",
       "                       <a href='https://ndirt.maps.arcgis.com/home/item.html?id=4ecd9a0456c4452fad039c34da4d479f' target='_blank'>\n",
       "                        <img src='data:image/png;base64,/9j/4AAQSkZJRgABAQEAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3PyE371UFiOzVHKr3AUKSCNnPpn3pgISFXYgXaOP8+1ACM+xGcgAKMk+wFIZFPfQLHP5n3Y+JAUzkHj8qYhYJo5kbylACttxjFJjLKMSRuxjj86aEUpZM6lFGAQpUsT1Gfz96AHwRbbu5dI9pZgS24nd17dv/AK9AE6D94OnT39KBle6iHnWpKEkOSGBIC/WgQ26lkjkjCuFRjgvjODQMcttGHy+6Q+rnNFwJlx5TYGBkYpAV90n2lt2PJCZ565/OgCSBk8jzNykHknPSmBKkiyIXVlZG5yOh5oAgls45yxLyLu5+V8DOMU7gQDS1UMDNM2T18wmhsB89uXgjhWeRHQ5D7jknBHPryc4PFTfURXlsL9miMepugR2YhowdwOcD8M/pTAdZ6fexXKvcX4lRXJ2iLbkYwBnPOPelZAaTYPpigZXaGMysPLAHXqRU8iFYhmUrwqEjqTk1Eo22QmT2cn7sQkYkTqpHPWtmMLi+eCYRi3klXbkuo4yTjGKaAbFqIlkCG3niJAJYoMDr1/L+VFhlzDMp2kN06AUhENxci2Kh+DK4jUgDqemaNQJMtzyOvtQAyKdjdvBg/Lg5wMEH3oVwIyJRexq0jfMCQAox+NCT6gOhiaK4uZCJG8xgQCBjgdqYFjzHLcgAY9+tK7Aq3MMkrW5RMBJMtnsKAHzW++F1ZQQQaLAMt97WsTnklRzxSGSqG8ps46j0oAzJmzPKNmAoC7g3Xv0p9ARPbbRpxCHeMsMhcZ5PbmhiJbXCWiKUZMDG0jJHP0FDAV7hI3jQhsudowOM5osMaL6H7S1vuYSggfd759fwosItYGCT1z2OKADbxkUDGGRR8oYevFICC3eZ2l8zAXcfLwQePw6UwJ8YLEdSaQFZkyWHOSMGkAXW1GjK/NKxwPde4+lUhFBbJssqWchUE4BuOoyQP0qhgbeZWEn2STPUqLjheSf54/OldAa8aiKERqThcAZJPakwIr0sVT7xxJxtz/hQIrOrGTO0nOO1YNa7CH2Ssb9pGQBiACx6np29PwraL0GWHhR5kmYnemQDk96Bj5JEQjMiqScAE9aUpRi7N7jSb2M9od9hKgkiIMuchCoHI64HJq+pJpA4j5b19akYwOHiZlbPynHX0pJ31QiOwkY2casAV2Dr61fQZaABQ7GAyR1FIRBOAclsAKec0rjI7WOd7MrMyl2zyBt47dOlMRLbxeVAIyANoxjOcc+uOaBkdxgSwf6v72OTz+HH+FAirtkN8QRb4Vwc8Aj9euPb1oWwFuQN9siYYZRnJIGB/WgCwpO4cjAOeBQMglZY4Wdh05x60gIrSIJHs8soeMnJ5/PntS5ruwiztIBwx/HmqGR7WDFsgHHXpikIgRg9yJkZS+7YgPUAjr+dUgLSvMHkV3yRgjip1GL5soJxtP1IouxEnmuVOME56GncCpfl32bZCmHycY+YenWhgQMxD48vJ6Z7msRElrH/AKaZNg7Ddjk/r/StFsMs+Yd2MAincZkaxG817BHE6KLkGBwwyQo+Ysvvx/KvJzChUqVYqD+L3X5Le6/rsd2Fmowk2vh1/TUsxhjaSDG4ibADRg8cc4Ht3r1zgNA5VAMHn1OKQxn8LDP8J7+1AEdllrZCOMD14FADpp1UbEbnru/wqXLohEf2lyPv7lyRhiOaXMxEsiSuwELBF2dB6447f59DWgwMN4Xz5y44yNv+1yQf93imAs1u0skLLNsEZ3EAg7vrSAr/AGEm8klYK25sgnHy/Q5/pR0AfMmb+FcDJDEOJANo+nei2gFiRhFEXzlU5ODyaBlV7qLzHhbeGRDIQp6gAHjH1osxEltcJeReZCxKAkZJAzRYZNJ5iISkZc56A5FJ3WwijLNI+RIcDP3cYrNt9RFW28Q2UUiwkxiQfL0xn8a6aqSleJjSq3VpbmobrcjMjptP3AQKxcjcrm9kJOAmP92pvJ7InmQ03sx7R/8AfNbwUbLmTv6GUpyvo0LJqTwWlxcyBWWGMu2F6AdT+AyaiT95pGkG3HUyYPE8kkcYmsvId5GTymAzlQMnnAxk/lzU69Cy1a6+80sO22BjcoN64xlmC4/DPWmgIj4kYCMm3wzgkIcAnChgPfgjp0pagZ+satBeM2+3ndrYlka2kAOChY4II4IHGevasq1BVbcz27aG9DEzoX5ba91f8zT8OTyCCeFpWcRzyqvmEswA6cn2rHCNpOLezZvj7OcZJJXinpp6mj9tlxgOuPZa6ednBckS63BwVQkKeQuKakMr2l0wtAMAgcYKiqneK9SVK9yVLkk/NHHjB/hFZqQ7iC5LR5EUXXjgU+bTYC8CxA6AYHA+laDGkEbsYB/D1oAUEn74B49qADaNrHIH1+tAANpjODnnnAoAhN3FGX6KEOGJHTgH+RoAhOoW5PMuTyPun1x/OiwxJLuNBMSxzH975emelKwhiRTXcIlaR1TazDYwU5wR2+tTaXURnIHnk8ordsxbIl80YOTnB78VKakI8vlZQ07O9z9tEi+SABsK98981nK7ep5UnJT0PT/DJWfSkadwJBj7w5rdU2o3Z6cJqS8zT+zQdrlce4pXfSRXJFi/ZogebmMCrjGctmS1CO9iZPs0KlVdG3DBLNj+lWqL6pi9pBbNCLb2knCTHd6ZrOVLldmXGUZbMmigjhZVXfnd3x2oUUiiJrS1klSR4Q0iElGKAlc9cHtRZAOkgQu5LuOckADFJxCxj6TJbpLqF5I7Kj3TIo2g/dATP4kVzYZKUpy83+Gh24xcsacO0V+N3+prfZosZ3N+CiujlRxWHCCMFvvnII+6KfKgsVbaKNI3Rw5KnkKBRLXcVkiZEgHzbZj2wVqUkAwxwFRhJwM9MUWQFtFTly7AbRw3QcVaQx4RcE4ODz2p2AaDHkYViMdMUlYCOGaV5p1dCka42EDGeT/9amBOSCCCWPPcUAMxE2PlI59KNAIJ3igRWBABbHKjv/XNAE22PH8XQ9hSGV4o4UJIMhGCCDjkVKSQrEBkjgLCCMq3Tcx5/D0qXaOwjnLbTLO9RbkoMnnpXowpwkro82Tadma0UawoFQYAreytYm/UVf3RYkkocE5PSuKth+sTsp11LSW5M2HO5OhpUa6guWSFVouT5kR13RkpK6ORpp2YoJHSpnTjP4hxnKGxqWtysy5lyGjGd3Y1yVaXK9Dto1edakF5d/ZFRnRQGP3mbAH4/UisbG4QXcNwpZnQDtmTgjP+INFgMTT7qyjtLqKWWHP22UhTKFP3jjv0riwtSMVJN295/meljaVScoOMW/dj08jYa7sxGSLuEcHpID/Wur2ke5w+yn/K/uIrS9tY7VFN3aHaCOGCj8qHUh3Q/Y1P5X9wi6hbm/SSOZCNuCAw54//AFU1OL2ZLpzW6ZoM0Zi3lY1GRz1puyIHqVK7kC4PPAo9AGTYMMofGwrg4HOMUdQEs/3dpHGhYhUA5B5/OncCcBGGSpU+31oAq2yj7ZeBY3ypUFiOG78UWAlZ23MNrYBHOKSd3YB3LAHuDzxQMr3SM6R4TdhweuMc9aaAsbTt59D25pAQ4ABIGPakBUlIDux7nAq6VLnn5IwrVOVGdp9ube0SMHkfwkYxV05Spq8dUFSEZaS+8tV2U6kZrQ46lKUNwrQzGkMSm2QoFI4ABGO4/GsKlBT1RvTruOj1JiqsSQ4A96iEnRjaY5RVWV4AqxtwZAGz3Bx+dcs51JS5k7HRCilGzRNJLEkYgVsqOrL3NClJST3LcFy8qKc0BljUSg7Mhlwe4711RSrO7Zzyl7FWSLVnHaJH5XkhD6+v4dPwGKipRcVdGlOup6PRhd6Pa3LD/Q7Yk8lygLMAPXBrjdKEneUU/kdsMRWgrRm0vVjZNF03yzs0y03e8IrN4aj0gvuNPruJ/wCfj+9kdrpGny26tLpdsGOeDCo78cVTw1H+Rfcg+uYn/n4/vYs/h/Spoih063XPQqm0/mKiWEoNfAvuKWPxUdVUf3mFDpdzaa6LC3v7qGKS3aaNWw4BVlBGD2ww9/eqWFvS54ScWnbune/R+nSwLHc0rVoKV/k/vXr1ubIttfRNqXVkyjnLRMp/Q1PLiOjX3P8AzHfBveMl81/kIZPEECsXtba6UjpDKVb8m4qVLEQd3FNeT/z/AMx+zwc/hm4vzV1+H+Qtvr9tDEkeoRz2cuME3EZCk/7wGP5VX1umvjvH1X67A8BVetO0/R3/AA3/AANOC8tbhcwTxSj1Rwe/1reE4zV4u5yzpzpu000/MilRre8Vo94Mz/NjAzjnHT696szLxJYHfHkZ69KAFVEyCh5B6GgCvdQo6KJMRgNkH3/GgCJpwThQWA44qXIBktzHGgMjCMMdqlj1P+RRcLlP7RBKwbz49pOAQwx611xqxpw9045U3OfvFTw7KdQ0tfM2+Yq/K2ORXJSk1qdS96OpdC7zgkBlOCfcdaua9m1OOzM1u4SG5454I612Uq6nuc1Sg46x1QVs2krsxUW3ZCdeccdhXLKXPq9jsjHk92O/VkqqoOXwHPtxWbpSavEv20U7McqDkEbSP4q5HfZmoCTb8oGVPUHvSjNxd4ktJqzGvHhd6ZKe/UV6VHEKpo9zjq0eXVbE9tdlf3cnKnjNFWjfWJdGu17si20YwMMv4+lcdjtFChSfmXFADWh3Sq28fL/DUuN3e4jJnH/FaWfT/jwm/wDQ466V/AfqvykT9tej/NG1lc9Rg1gWICF9P8/hQIz77VrW3uZbeeKYKib2fZlNufb3IGKbVxp2M6SPQL+Ur9jKOM/vIozGTjBPK4Pf9K55YSjLeP3afkdUMdiIaKTa89V9zM/z47GG3vNO1C4miMir5c4LAgnB25GQf8KylTlQtKMm1dKz13dvU3hUjiuaNSCTs3dK2yvr0OlaW72gqUcHpxXbdHmkT3t3GyAxJyeoHT9acVzOyFKSjuQvcXEnJKZ+7hhkAZGcfr2rZUJMxeIghfMkIxywHcc0OkoO8ldE+0dRe47MT5WA3OMdeea0dSnFaIzVKrJ6sheIhz5cyKvUDywcHHr/AJ7+tcc25u9jpjDlVi3FYw20ISBQjLypAxk0LQ0IAxJJOAxJJA9ya7aXLOHKzjxClGfMhGzvU8nqMdv88VNWnGK90vDVHK6YmdvByRxwB0rFSvo9jdx3a3JVG0b25J6VtGLkznlJQVhpOTmulK2iORtt3ZIrZAVjx2PpXNiKHOrx3NqVXl0ewEYOK8yx1ihyvHH401JrVDGMMHjoeRXr0anPBM8+pHllYuW83mLhuorkrQ5Z+p20J80fQnIye1ZG5EX8iZEcl3kJC8dB71Ki1qxGVeTLD4wtWcqB9hmH/kSOuhP9w/VflIn7a9H+aNeOeKRDhkIHoaxWpTdhPtMWDlu/pWiozfQzdaC6lS8El0Q1tei3IDDBTcGzjBIyOmP1NDpTW6BVYPZka2d4u8S6jI6tHhWCKCrEjBGPT9c1HWxpfS5nalp88duLlZhNHbSrOlukIG1A3IHc8fyrmxV+RSXRp/cduBa9o4N25k1960NX7eLiNZICPLcblYc5Fd1CkqkVO+jPLxFSVKbptWaGbWb5mOO+T3rolVp0lY5o051NWISq8AZPbP8AhXJLE1J/CrI6IYeK31J0hmkxk+Wnb1/Kotd3bubqKWxL9gTGC7ZPcU7jLMVvBEgGMHv3zQAwoXwOwpAUxb+b5xxtfeQv+fyqlJrYGr7lZk29c7xkH2qnJvcEkthyruOXY8cfQVnFucuWKJlJRV2OMBSISqR5ZODzyDXVBunLlkYzSrQ5o7jK6zhCgBstwYwv7mSTg5KDJ/KuDFUteZHXQndcrGi5YxhxbTYI+6QAwOfTNcVjoBrolB/otzgHrsHcgevv+hrqw1TkutzGtDmVyxCf3g64NddZc1O5jQfLUsXEO44yeD2FcJ6AXAYzwEBCAeSx6dOnPWmI8/8AG9zcJrVtJDIEIBiLMeArEc/gQKynUai4d/6/U5sRNwXMiromqzJrMlhJdxT7HKho2yr+49RWmGdpanOqkqiaZ3iozDPb3NejOrCG7JjTlLZAY3H8PHqOaI1oS2Y5Upx3QgYjoSKtpMhNrYerSuwwxyOck9Kyl7Omnc0i6lRqzM21KQa1Pa2REkDJ5jooyIZCeQPTPXHavHoz5KsqVN+7v6Pt8+x7+Ih7XDwrVl7+1+67/La5sJbSv8z/AC/TrXTypHDYtRQJGPlXnnk9aBkuAOCT04GaAFzgcA4+vNAFaO6WVXUqUkXqjYyKGBWmvVkiK+Um8fdy3Q1VhGbZyXsrlEhZIznMglDHr/EM/LxQ7bgX4isIwh+Yjlj2+lY8zm+WJLlYSXbwFbPr9a9HD0+SOqOKvNSdky5DD/oJSQcSHOPasa8k5aHRh4uMdTP574z0OK6qcrxTOWvHlm0grQyFUlSCKTSasxptO6GzWsMrh2U5IGCGIOPTivHqRdOTiehGSkrokRFjiKLwoHHOe9aYZ/vURW+BiwDMy16Fb4Gc1H+IizjCv835GvPPSHqu9YyTnbzzQBh6/pNvqbbcDIPJrWnh1UXMzkxFRfCZtl4Rsf8AVTwJKpP8Q6e/tW8IKh76MILnfKjU0uFotU1bTYriSWGCKJ7czuXMZYNkZ6kcDqazrKM6caltXdaeVv8AM7Y6ScfT9f8AIs3El3bgBzZxgjKnLDnjqfqa5HsW7kRupXfYZ7UH7vckNnHQ01KS2ZLSe5Wmub68uFsLd4w8y7i8ecwJ/e57noPzrlqzlOXsoPV7vsv8+x34WjGEXiKq91bLu+3oupsR2Y0rT1isLUSOpB25xn1JPrjP14rqp04048sVZGFatOtNzm7sjOpXoA/4lLDIJP73oeeOn0/P6ZvQyHHUb8P/AMgtlXgD95yck57fT8/TmgDRxwCRSGI2QAaAM67kV5Y26FWADhSeKhTbbSJuXZYlkUCTnB9SKsoldVjRI0ACgZxnvTYGVfv5alwh9SFxzW1CMYpz6nNXu5KHcoQ6oBKP9Eud3y4LxYUZ9ee3f0qp1nJWCGHUXd6mlJc3QP71lVjzkLxj2qIQjLdm05OOyuQAAZx3JP5812QioqyPOqycpXYtWQFAD4zkbfxFcmKp80eZbo3oTs+UX+FvpXJhv4qOir8DEhOJVNejW+BnLR/iIsS4SM8cnpnBrjpwU3ZnbWnywuiP7U4jCKqrjuAK2WFXfQ5vrTtsQ8sfUmurRI59WywibUxn5j1rhrVOd2Wx6FClyK73MW2u5rTWNfnt4VnmWO3RIycbjhiefYHNLESnDCxcFd66fcv0N8PGnPEWqStHTX7yG+8TXdu9tBeaUkE8wPl7nMh45JCoC2OM/hXn0p4qtL2appO19XoehWw+DpQdV1W1e2kdfxL9vp9/fwxT/wBpW6W8ih1NnDjKnkEMxP54qnQr3tUnbyS/zuZKvhIq9Onfzb/RWNaw0200yAx28e0HlmJyzH1JrWlRhSVomNavUrSvN/5L0RaMinJHPbOc49q0MSu80gukjABU96m7vYRNncFYflVDK11cywOpAXa3fPNZzm4sTYqXkdxEMBgx447Ue0UlYLjLiyIgzEokkBB5/wA8VUYKIJWL37tuMn8BVaDHT7fNGc57U3uBDDbrIxaTBUHoacW1sS4p7labBlLkD246VDLGM7E4GQMc0rgMkg+XfHnOPu9jW9Oq4mdSlGa1Ia707q6PMlFxdmFMQUATnDIWA6jn615yp+zrJHa5c9Jsg6V6DSasziTad0BJPWhJLRDcnLVkiQl8HoD0wMk1lUrRjp1NqdCU9ehKkYUlh0H51yTqynudcKMYbD0LHoASegxWZqYUHh66F5c3EGtXMCTTs5CxISc8feI7AAD0xXS68OVJwTsrbv8Az+Znyu91L8v8vkZeueGNUUJLpdzK14JQYr5XPmxg/Kyv6rgnp6CuHAt4Ss3OPPGWjfXyPQxso42ilCXs5R1S+y+9vP1+87PTLT+zbaGzjYNbQokaKeoxxnP61tKUpzc5dTgjHlSii464cnpzSLKLQGGV3tsFWHzR5/l+tPcCSKaJyezqASrdVyOn1pWAqvPKuUbIB74rncpLRk6ladm8oqvzE8DmsxE9j+4baQT/ALQrSm7MaNRCpZQp710FEUsjo8YQRglwDu9Pz600BLIcynJHB9KTAWAbkdQcHdx9aaEV5QGOcYzyfrSYyscrJjP51IyWM5Qe1NAVZU8uXAHynLD8+a7MPP7LOTE07rnQyuo4goAUMQCOxrOdNSafYuM3FNdxK0IHpEJQysWVcEEr1/CsK9TlVkdGHp8zu+hHOrRRuyyXUmTwiuOOp4GPf6dK4rnfYhyZPlK6lg/LzjJ5Xn9P1NAFswGNfM8+43Z+VdwOTnOMY/zihAX4lEcaRgdB19+9JiFaPDhlO0nqPWgZFdyGMQ84y4/mKmbshMllk/0llDcjqAf6U762AXfzxn8eKYxk0MczZI2vgqHHUZouA3yw8CpKS7Y64pSSe4iO4t44oVZU6HvmspwSV0JoW2RQS6HLHse1OmluCLUe3zFIPf8AOtSiKUM9zbhFb74ZiG6D06j+vSmhDp2KB3SMuw6KDjOf/wBdIZDHdyIhP2Wb5jnOB0wB/X9KYiM3MmCGtpM9fl57DP8An2oGMEpdkYxun+8MVLGPUErkHGKQFW4wskUnIDNtxn2OK1ou0kZ1VeLQV6R5YUAFABSbtqCV9ETxlTGdrA4615s588rnqU4ckbDgM8ngetSaDgdz579hQIajo94iMwAT7oP8RobS0EXTkHIGRQMFww4H4nvQASRqyAP8ynIIxwaAII3EwferF0+TzFxkj3zwaXmFhygBR+9wP9qHkflS+f4CIJ5rje0aRl0zw+0gAY9Op57U7oLkcNjJcYllkKEYAAHIH/1+tCSetgIZbJprlmhZlyxY7eh5PrnHXtUczk7W0EXLVZYrjyjCSNuWbsSOuPXtx9auKS2GXIyCBJkge4x+FNa6gESKZ0cqpYdCRyOKaAU4lIGNpZsEihagZN+lvYTEJCW+XzMbyBnPTHYcUwIPNiDn90flBGN555A/pQBoTxrEQij5Qe9RIpDDxkDj5jSAhnLOikED5hnjrzV09WKWwyvUPICgAoAfGMtn0rnxEmo2XU6MNFOd30JRhc8da4TvHucErgEDgcUwFQDa5AwQrHr7U0BRgtUuwwckFVBBHrXPKPPN36EWuyPT72XaI3O9S2BnqPxrOnUd7MEzb3HHPNdZY9wDGM+poAgwA3A4c80gH+tADu3PT0oAo32oLbXf2doA48oPndjrn2/2abimIfJfiGVo1h4A/ve6j0/2v0ppAVxrh2oRbgbgD97pkIfT/a/SgDX2rcfeyGHGQaNwP//Z' width='200' height='133' class=\"itemThumbnail\">\n",
       "                       </a>\n",
       "                    </div>\n",
       "\n",
       "                    <div class=\"item_right\"     style=\"float: none; width: auto; overflow: hidden;\">\n",
       "                        <a href='https://ndirt.maps.arcgis.com/home/item.html?id=4ecd9a0456c4452fad039c34da4d479f' target='_blank'><b>DCVAMD_CBSA_DeficientBridges_Analyzed</b>\n",
       "                        </a>\n",
       "                        <br/>Bridges in the DCVAMD CBSA analyzed by impact to commuters if impaired. <img src='https://ndirt.maps.arcgis.com/home/js/jsapi/esri/css/images/item_type_icons/featureshosted16.png' style=\"vertical-align:middle;\">Feature Layer Collection by ANieto_ndirt\n",
       "                        <br/>Last Modified: March 09, 2018\n",
       "                        <br/>0 comments, 0 views\n",
       "                    </div>\n",
       "                </div>\n",
       "                "
      ],
      "text/plain": [
       "<Item title:\"DCVAMD_CBSA_DeficientBridges_Analyzed\" type:Feature Layer Collection owner:ANieto_ndirt>"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyzed_bridges_item = gis.content.search(\"DCVAMD_CBSA_DeficientBridges_Analyzed\", item_type=\"feature service\")[0]\n",
    "analyzed_bridges_item"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "commute_df = pd.DataFrame.from_csv(\"commute_table.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "tract_polys = gis.content.search(\"DCVAMD_CBSA_Tracts_Polygons\", item_type=\"feature service\")[0]\n",
    "tract_points = gis.content.search(\"DCVAMD_CBSA_Tracts_Centroids\", item_type=\"feature service\")[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "tract_polys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "tract_points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "route_items = gis.content.search(\"Test Routes\", item_type=\"feature service\")\n",
    "origin_dest_points = route_items[0]\n",
    "normal_route = route_items[2]\n",
    "impaired_route = route_items[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "normal_route"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "impaired_route"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    "\n",
    "def animate_layer_addition_to_map(map_widget, list_of_items, zoom_level, basemap='gray-vector'):\n",
    "    # The map widget\n",
    "    m = map_widget\n",
    "    m.basemap = basemap\n",
    "    \n",
    "    # 1. Parse the find-routes analysis results\n",
    "    # Extract the output data from the analysis results\n",
    "    # Store the output points and lines in pandas dataframes\n",
    "    lines_df = result.output_routes.df\n",
    "    lines_fset = arcgis.features.FeatureSet.from_dataframe(lines_df)\n",
    "    \n",
    "    # 2. Define the map symbology\n",
    "    # Allocation lines\n",
    "    allocation_line_symbol_1 = {'type': 'esriSLS', 'style': 'esriSLSSolid',\n",
    "                                'color': [255,255,255,153], 'width': 0.7}\n",
    "\n",
    "    allocation_line_symbol_2 = {'type': 'esriSLS', 'style': 'esriSLSSolid',\n",
    "                                'color': [0,255,197,39], 'width': 3}\n",
    "\n",
    "    allocation_line_symbol_3 = {'type': 'esriSLS', 'style': 'esriSLSSolid',\n",
    "                                'color': [0,197,255,39], 'width': 5}\n",
    "    \n",
    "    allocation_line_symbol_4 = {'type': 'esriSLS', 'style': 'esriSLSSolid',\n",
    "                                'color': [0,92,230,39], 'width': 7}\n",
    "    \n",
    "    time.sleep(1.5)\n",
    "    m.draw(shape=result.output_routes, symbol=allocation_line_symbol_4)\n",
    "    m.draw(shape=result.output_routes, symbol=allocation_line_symbol_2)\n",
    "    m.draw(shape=result.output_routes, symbol=allocation_line_symbol_1)\n",
    "    \n",
    "    m.add_layer(stops_layer)\n",
    "    \n",
    "    m.zoom = zoom_level"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Let's Explore our Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Exploring Bridge Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Structurally Deficient Bridges in our Area"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "4911167703f549bc99a97eae5dd86cd6"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "deficient_bridges_map = gis.map('Fairfax County', zoomlevel=8)\n",
    "deficient_bridges_map.basemap = 'gray-vector'\n",
    "display(deficient_bridges_map)\n",
    "deficient_bridges_map.add_layer(deficient_bridge_item)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Exploring Commuting Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Table of Commuting Patterns by Tract"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>EST</th>\n",
       "      <th>MOE</th>\n",
       "      <th>RES_STATE</th>\n",
       "      <th>WORK_STATE</th>\n",
       "      <th>RESIDENCE_TRACT</th>\n",
       "      <th>WORK_TRACT</th>\n",
       "      <th>ORIGIN_DESTINATION_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1630</td>\n",
       "      <td>444</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089011100</td>\n",
       "      <td>1089011100</td>\n",
       "      <td>01089011100 - 01089011100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>1300</td>\n",
       "      <td>340</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003011502</td>\n",
       "      <td>1003011502</td>\n",
       "      <td>01003011502 - 01003011502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1070</td>\n",
       "      <td>209</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1051030400</td>\n",
       "      <td>1051030400</td>\n",
       "      <td>01051030400 - 01051030400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>1055</td>\n",
       "      <td>263</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1081041100</td>\n",
       "      <td>1081041100</td>\n",
       "      <td>01081041100 - 01081041100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>1055</td>\n",
       "      <td>330</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1115040501</td>\n",
       "      <td>1115040501</td>\n",
       "      <td>01115040501 - 01115040501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>995</td>\n",
       "      <td>214</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1043964900</td>\n",
       "      <td>1043964900</td>\n",
       "      <td>01043964900 - 01043964900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>925</td>\n",
       "      <td>208</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089010501</td>\n",
       "      <td>1089001402</td>\n",
       "      <td>01089010501 - 01089001402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>925</td>\n",
       "      <td>199</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089010621</td>\n",
       "      <td>1089001402</td>\n",
       "      <td>01089010621 - 01089001402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>890</td>\n",
       "      <td>262</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1009050102</td>\n",
       "      <td>1009050102</td>\n",
       "      <td>01009050102 - 01009050102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>885</td>\n",
       "      <td>219</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003010703</td>\n",
       "      <td>1003010703</td>\n",
       "      <td>01003010703 - 01003010703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>870</td>\n",
       "      <td>294</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1001020500</td>\n",
       "      <td>1001020500</td>\n",
       "      <td>01001020500 - 01001020500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>825</td>\n",
       "      <td>292</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003010905</td>\n",
       "      <td>1003010905</td>\n",
       "      <td>01003010905 - 01003010905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>825</td>\n",
       "      <td>254</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1077011101</td>\n",
       "      <td>1077010900</td>\n",
       "      <td>01077011101 - 01077010900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>820</td>\n",
       "      <td>235</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1121011300</td>\n",
       "      <td>1121011300</td>\n",
       "      <td>01121011300 - 01121011300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>815</td>\n",
       "      <td>187</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089010622</td>\n",
       "      <td>1089001402</td>\n",
       "      <td>01089010622 - 01089001402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>815</td>\n",
       "      <td>299</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089010622</td>\n",
       "      <td>1089010622</td>\n",
       "      <td>01089010622 - 01089010622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>815</td>\n",
       "      <td>215</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089011011</td>\n",
       "      <td>1089011100</td>\n",
       "      <td>01089011011 - 01089011100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>795</td>\n",
       "      <td>309</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003010800</td>\n",
       "      <td>1003010800</td>\n",
       "      <td>01003010800 - 01003010800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>780</td>\n",
       "      <td>260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1009050101</td>\n",
       "      <td>1009050102</td>\n",
       "      <td>01009050101 - 01009050102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>780</td>\n",
       "      <td>181</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089010901</td>\n",
       "      <td>1089001402</td>\n",
       "      <td>01089010901 - 01089001402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>780</td>\n",
       "      <td>202</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089011200</td>\n",
       "      <td>1089011100</td>\n",
       "      <td>01089011200 - 01089011100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>765</td>\n",
       "      <td>201</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1081041700</td>\n",
       "      <td>1081041100</td>\n",
       "      <td>01081041700 - 01081041100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>760</td>\n",
       "      <td>245</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1043964200</td>\n",
       "      <td>1043964900</td>\n",
       "      <td>01043964200 - 01043964900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>750</td>\n",
       "      <td>191</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1123962300</td>\n",
       "      <td>1123962300</td>\n",
       "      <td>01123962300 - 01123962300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>730</td>\n",
       "      <td>193</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003011403</td>\n",
       "      <td>1003011403</td>\n",
       "      <td>01003011403 - 01003011403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>730</td>\n",
       "      <td>190</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1021060102</td>\n",
       "      <td>1021060101</td>\n",
       "      <td>01021060102 - 01021060101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>720</td>\n",
       "      <td>210</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1089011200</td>\n",
       "      <td>1089011200</td>\n",
       "      <td>01089011200 - 01089011200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>710</td>\n",
       "      <td>255</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1077010900</td>\n",
       "      <td>1077010900</td>\n",
       "      <td>01077010900 - 01077010900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>690</td>\n",
       "      <td>314</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003010703</td>\n",
       "      <td>1003010705</td>\n",
       "      <td>01003010703 - 01003010705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>690</td>\n",
       "      <td>241</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1003010705</td>\n",
       "      <td>1003010705</td>\n",
       "      <td>01003010705 - 01003010705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156396</th>\n",
       "      <td>4156397</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72051540200</td>\n",
       "      <td>72127006500</td>\n",
       "      <td>72051540200 - 72127006500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156397</th>\n",
       "      <td>4156398</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72055961300</td>\n",
       "      <td>72055961300</td>\n",
       "      <td>72055961300 - 72055961300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156398</th>\n",
       "      <td>4156399</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72055961400</td>\n",
       "      <td>72055961400</td>\n",
       "      <td>72055961400 - 72055961400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156399</th>\n",
       "      <td>4156400</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72057270600</td>\n",
       "      <td>72057270600</td>\n",
       "      <td>72057270600 - 72057270600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156400</th>\n",
       "      <td>4156401</td>\n",
       "      <td>4</td>\n",
       "      <td>19</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72061040411</td>\n",
       "      <td>72127010500</td>\n",
       "      <td>72061040411 - 72127010500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156401</th>\n",
       "      <td>4156402</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72061040442</td>\n",
       "      <td>72127010032</td>\n",
       "      <td>72061040442 - 72127010032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156402</th>\n",
       "      <td>4156403</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72063210100</td>\n",
       "      <td>72063210100</td>\n",
       "      <td>72063210100 - 72063210100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156403</th>\n",
       "      <td>4156404</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72063210400</td>\n",
       "      <td>72063210400</td>\n",
       "      <td>72063210400 - 72063210400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156404</th>\n",
       "      <td>4156405</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72075710600</td>\n",
       "      <td>72075710600</td>\n",
       "      <td>72075710600 - 72075710600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156405</th>\n",
       "      <td>4156406</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72085190201</td>\n",
       "      <td>72085190201</td>\n",
       "      <td>72085190201 - 72085190201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156406</th>\n",
       "      <td>4156407</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72093960200</td>\n",
       "      <td>72093960200</td>\n",
       "      <td>72093960200 - 72093960200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156407</th>\n",
       "      <td>4156408</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72097080100</td>\n",
       "      <td>72097080100</td>\n",
       "      <td>72097080100 - 72097080100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156408</th>\n",
       "      <td>4156409</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72097080200</td>\n",
       "      <td>72097080200</td>\n",
       "      <td>72097080200 - 72097080200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156409</th>\n",
       "      <td>4156410</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72097081100</td>\n",
       "      <td>72097081100</td>\n",
       "      <td>72097081100 - 72097081100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156410</th>\n",
       "      <td>4156411</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72097082102</td>\n",
       "      <td>72097082102</td>\n",
       "      <td>72097082102 - 72097082102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156411</th>\n",
       "      <td>4156412</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72113072000</td>\n",
       "      <td>72113071200</td>\n",
       "      <td>72113072000 - 72113071200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156412</th>\n",
       "      <td>4156413</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72119130200</td>\n",
       "      <td>72119130200</td>\n",
       "      <td>72119130200 - 72119130200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156413</th>\n",
       "      <td>4156414</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72123952700</td>\n",
       "      <td>72123952700</td>\n",
       "      <td>72123952700 - 72123952700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156414</th>\n",
       "      <td>4156415</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72123953200</td>\n",
       "      <td>72123953200</td>\n",
       "      <td>72123953200 - 72123953200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156415</th>\n",
       "      <td>4156416</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72127002600</td>\n",
       "      <td>72127002600</td>\n",
       "      <td>72127002600 - 72127002600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156416</th>\n",
       "      <td>4156417</td>\n",
       "      <td>4</td>\n",
       "      <td>22</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72127004200</td>\n",
       "      <td>72127004200</td>\n",
       "      <td>72127004200 - 72127004200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156417</th>\n",
       "      <td>4156418</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72127005800</td>\n",
       "      <td>72127005800</td>\n",
       "      <td>72127005800 - 72127005800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156418</th>\n",
       "      <td>4156419</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72127007900</td>\n",
       "      <td>72127007300</td>\n",
       "      <td>72127007900 - 72127007300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156419</th>\n",
       "      <td>4156420</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72127008300</td>\n",
       "      <td>72127008300</td>\n",
       "      <td>72127008300 - 72127008300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156420</th>\n",
       "      <td>4156421</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72129220402</td>\n",
       "      <td>72129220402</td>\n",
       "      <td>72129220402 - 72129220402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156421</th>\n",
       "      <td>4156422</td>\n",
       "      <td>4</td>\n",
       "      <td>123</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72133953300</td>\n",
       "      <td>72133953300</td>\n",
       "      <td>72133953300 - 72133953300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156422</th>\n",
       "      <td>4156423</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72137121801</td>\n",
       "      <td>72137121801</td>\n",
       "      <td>72137121801 - 72137121801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156423</th>\n",
       "      <td>4156424</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72153750102</td>\n",
       "      <td>72153750102</td>\n",
       "      <td>72153750102 - 72153750102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156424</th>\n",
       "      <td>4156425</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72153750202</td>\n",
       "      <td>72153750202</td>\n",
       "      <td>72153750202 - 72153750202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156425</th>\n",
       "      <td>4156426</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72153750502</td>\n",
       "      <td>72153750502</td>\n",
       "      <td>72153750502 - 72153750502</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4156426 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         OBJECTID   EST  MOE  RES_STATE  WORK_STATE  RESIDENCE_TRACT  \\\n",
       "0               1  1630  444          1           1       1089011100   \n",
       "1               2  1300  340          1           1       1003011502   \n",
       "2               3  1070  209          1           1       1051030400   \n",
       "3               4  1055  263          1           1       1081041100   \n",
       "4               5  1055  330          1           1       1115040501   \n",
       "5               6   995  214          1           1       1043964900   \n",
       "6               7   925  208          1           1       1089010501   \n",
       "7               8   925  199          1           1       1089010621   \n",
       "8               9   890  262          1           1       1009050102   \n",
       "9              10   885  219          1           1       1003010703   \n",
       "10             11   870  294          1           1       1001020500   \n",
       "11             12   825  292          1           1       1003010905   \n",
       "12             13   825  254          1           1       1077011101   \n",
       "13             14   820  235          1           1       1121011300   \n",
       "14             15   815  187          1           1       1089010622   \n",
       "15             16   815  299          1           1       1089010622   \n",
       "16             17   815  215          1           1       1089011011   \n",
       "17             18   795  309          1           1       1003010800   \n",
       "18             19   780  260          1           1       1009050101   \n",
       "19             20   780  181          1           1       1089010901   \n",
       "20             21   780  202          1           1       1089011200   \n",
       "21             22   765  201          1           1       1081041700   \n",
       "22             23   760  245          1           1       1043964200   \n",
       "23             24   750  191          1           1       1123962300   \n",
       "24             25   730  193          1           1       1003011403   \n",
       "25             26   730  190          1           1       1021060102   \n",
       "26             27   720  210          1           1       1089011200   \n",
       "27             28   710  255          1           1       1077010900   \n",
       "28             29   690  314          1           1       1003010703   \n",
       "29             30   690  241          1           1       1003010705   \n",
       "...           ...   ...  ...        ...         ...              ...   \n",
       "4156396   4156397     4   10         72          72      72051540200   \n",
       "4156397   4156398     4   13         72          72      72055961300   \n",
       "4156398   4156399     4   17         72          72      72055961400   \n",
       "4156399   4156400     4   10         72          72      72057270600   \n",
       "4156400   4156401     4   19         72          72      72061040411   \n",
       "4156401   4156402     4   15         72          72      72061040442   \n",
       "4156402   4156403     4   13         72          72      72063210100   \n",
       "4156403   4156404     4    6         72          72      72063210400   \n",
       "4156404   4156405     4   11         72          72      72075710600   \n",
       "4156405   4156406     4   11         72          72      72085190201   \n",
       "4156406   4156407     4   15         72          72      72093960200   \n",
       "4156407   4156408     4   10         72          72      72097080100   \n",
       "4156408   4156409     4   11         72          72      72097080200   \n",
       "4156409   4156410     4   13         72          72      72097081100   \n",
       "4156410   4156411     4   18         72          72      72097082102   \n",
       "4156411   4156412     4   14         72          72      72113072000   \n",
       "4156412   4156413     4   13         72          72      72119130200   \n",
       "4156413   4156414     4   10         72          72      72123952700   \n",
       "4156414   4156415     4   10         72          72      72123953200   \n",
       "4156415   4156416     4   16         72          72      72127002600   \n",
       "4156416   4156417     4   22         72          72      72127004200   \n",
       "4156417   4156418     4   11         72          72      72127005800   \n",
       "4156418   4156419     4   21         72          72      72127007900   \n",
       "4156419   4156420     4   11         72          72      72127008300   \n",
       "4156420   4156421     4   16         72          72      72129220402   \n",
       "4156421   4156422     4  123         72          72      72133953300   \n",
       "4156422   4156423     4   14         72          72      72137121801   \n",
       "4156423   4156424     4   10         72          72      72153750102   \n",
       "4156424   4156425     4   10         72          72      72153750202   \n",
       "4156425   4156426     4   11         72          72      72153750502   \n",
       "\n",
       "          WORK_TRACT      ORIGIN_DESTINATION_ID  \n",
       "0         1089011100  01089011100 - 01089011100  \n",
       "1         1003011502  01003011502 - 01003011502  \n",
       "2         1051030400  01051030400 - 01051030400  \n",
       "3         1081041100  01081041100 - 01081041100  \n",
       "4         1115040501  01115040501 - 01115040501  \n",
       "5         1043964900  01043964900 - 01043964900  \n",
       "6         1089001402  01089010501 - 01089001402  \n",
       "7         1089001402  01089010621 - 01089001402  \n",
       "8         1009050102  01009050102 - 01009050102  \n",
       "9         1003010703  01003010703 - 01003010703  \n",
       "10        1001020500  01001020500 - 01001020500  \n",
       "11        1003010905  01003010905 - 01003010905  \n",
       "12        1077010900  01077011101 - 01077010900  \n",
       "13        1121011300  01121011300 - 01121011300  \n",
       "14        1089001402  01089010622 - 01089001402  \n",
       "15        1089010622  01089010622 - 01089010622  \n",
       "16        1089011100  01089011011 - 01089011100  \n",
       "17        1003010800  01003010800 - 01003010800  \n",
       "18        1009050102  01009050101 - 01009050102  \n",
       "19        1089001402  01089010901 - 01089001402  \n",
       "20        1089011100  01089011200 - 01089011100  \n",
       "21        1081041100  01081041700 - 01081041100  \n",
       "22        1043964900  01043964200 - 01043964900  \n",
       "23        1123962300  01123962300 - 01123962300  \n",
       "24        1003011403  01003011403 - 01003011403  \n",
       "25        1021060101  01021060102 - 01021060101  \n",
       "26        1089011200  01089011200 - 01089011200  \n",
       "27        1077010900  01077010900 - 01077010900  \n",
       "28        1003010705  01003010703 - 01003010705  \n",
       "29        1003010705  01003010705 - 01003010705  \n",
       "...              ...                        ...  \n",
       "4156396  72127006500  72051540200 - 72127006500  \n",
       "4156397  72055961300  72055961300 - 72055961300  \n",
       "4156398  72055961400  72055961400 - 72055961400  \n",
       "4156399  72057270600  72057270600 - 72057270600  \n",
       "4156400  72127010500  72061040411 - 72127010500  \n",
       "4156401  72127010032  72061040442 - 72127010032  \n",
       "4156402  72063210100  72063210100 - 72063210100  \n",
       "4156403  72063210400  72063210400 - 72063210400  \n",
       "4156404  72075710600  72075710600 - 72075710600  \n",
       "4156405  72085190201  72085190201 - 72085190201  \n",
       "4156406  72093960200  72093960200 - 72093960200  \n",
       "4156407  72097080100  72097080100 - 72097080100  \n",
       "4156408  72097080200  72097080200 - 72097080200  \n",
       "4156409  72097081100  72097081100 - 72097081100  \n",
       "4156410  72097082102  72097082102 - 72097082102  \n",
       "4156411  72113071200  72113072000 - 72113071200  \n",
       "4156412  72119130200  72119130200 - 72119130200  \n",
       "4156413  72123952700  72123952700 - 72123952700  \n",
       "4156414  72123953200  72123953200 - 72123953200  \n",
       "4156415  72127002600  72127002600 - 72127002600  \n",
       "4156416  72127004200  72127004200 - 72127004200  \n",
       "4156417  72127005800  72127005800 - 72127005800  \n",
       "4156418  72127007300  72127007900 - 72127007300  \n",
       "4156419  72127008300  72127008300 - 72127008300  \n",
       "4156420  72129220402  72129220402 - 72129220402  \n",
       "4156421  72133953300  72133953300 - 72133953300  \n",
       "4156422  72137121801  72137121801 - 72137121801  \n",
       "4156423  72153750102  72153750102 - 72153750102  \n",
       "4156424  72153750202  72153750202 - 72153750202  \n",
       "4156425  72153750502  72153750502 - 72153750502  \n",
       "\n",
       "[4156426 rows x 8 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "commute_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Map of all DC CBSA Tracts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "453c6a98522f4c22adde89a9d5cc4f33"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tracts_map = gis.map('Arlington, VA', zoomlevel=9)\n",
    "tracts_map.basemap = 'streets-night-vector'\n",
    "display(tracts_map)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "tracts_map.add_layer(tract_points)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Map of a few representative commute routes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Let's use Spatial Analysis to find the most important bridges for DC's commuters..."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"img/odmc_restriction_01.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Exploring a Commuting Interaction With an Impaired Bridge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "a1a61d8e703b49d386e92c2e0705b699"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "m2 = gis.map('Washington Navy Yard', zoomlevel=12)\n",
    "m2.basemap = 'gray-vector'\n",
    "display(m2)\n",
    "m2.add_layer(origin_dest_points)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "m2.add_layer(normal_route)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "m2.add_layer(deficient_bridge_item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "m2.add_layer(impaired_route)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### This difference in the route, magnified by how many people have to resort to each new route, can be tied to the relative importance of each bridge."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### This shows an example of a single commute affected by the potential loss of this bridge. To better understand the overall impacts to all bridge infrastructure in DC, we can prototype and implement an automated version of this analysis, using the ArcGIS API for Python. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Spatial Analysis from the Notebook"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Process Workflow"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"img/Analysis_Process.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "### 1. Set Environment and Retrieve Bridge and Commute Pattern Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# Set workspace\n",
    "processing_workspace = r\"D:\\ANieto_SolutionEngineer\\Projects\\FedGIS\\ArcGISAPIforPython_Workspace\\bridge_processing\"\n",
    "workspace_gdb = r\"D:\\ANieto_SolutionEngineer\\Projects\\FedGIS\\ArcGISAPIforPython_Workspace\\BridgeCriticality_Arcpy_Workspace.gdb\"\n",
    "# workspace_gdb = \"C:\\\\Users\\\\albe9057\\\\Documents\\\\ANieto_SolutionEngineering\\\\Projects\\\\FedGIS\\\\FedGIS_2018\\\\Plenary_ArcGISAPIforPython\\\\Work\\\\Bridge_Criticality_Analysis\\\\BridgeCriticality_Arcpy_Workspace.gdb\"\n",
    "\n",
    "# Set Arcpy environment\n",
    "arcpy.env.workspace = workspace_gdb\n",
    "arcpy.env.overwriteOutput = True\n",
    "\n",
    "# Set reference to origins\n",
    "origin_tracts = r\"D:\\ANieto_SolutionEngineer\\Projects\\FedGIS\\ArcGISAPIforPython_Workspace\\BridgeCriticality_Arcpy_Workspace.gdb\\DCVAMD_CBSA_Tracts_Centroids\"\n",
    "# origin_tracts = \"C:\\\\Users\\\\albe9057\\\\Documents\\\\ANieto_SolutionEngineering\\\\Projects\\\\FedGIS\\\\FedGIS_2018\\\\Plenary_ArcGISAPIforPython\\\\Work\\\\Bridge_Criticality_Analysis\\\\Bridge_Criticality_Analysis.gdb\\\\DCVAMD_CBSA_Tracts_Centroids\"\n",
    "origins_id_field = \"ID\"\n",
    "origins_name_field = \"NAME\"\n",
    "\n",
    "# Set reference to destinations\n",
    "dest_tracts = r\"D:\\ANieto_SolutionEngineer\\Projects\\FedGIS\\ArcGISAPIforPython_Workspace\\BridgeCriticality_Arcpy_Workspace.gdb\\DCVAMD_CBSA_Tracts_Centroids\"\n",
    "# dest_tracts = \"C:\\\\Users\\\\albe9057\\\\Documents\\\\ANieto_SolutionEngineering\\\\Projects\\\\FedGIS\\\\FedGIS_2018\\\\Plenary_ArcGISAPIforPython\\\\Work\\\\Bridge_Criticality_Analysis\\\\Bridge_Criticality_Analysis.gdb\\\\DCVAMD_CBSA_Tracts_Centroids\"\n",
    "dest_id_field = \"ID\"\n",
    "dest_name_field = \"NAME\"\n",
    "\n",
    "# Set reference to bridges\n",
    "bridges_fc = \"C:\\\\Users\\\\albe9057\\\\Documents\\\\ANieto_SolutionEngineering\\\\Projects\\\\FedGIS\\\\FedGIS_2018\\\\Plenary_ArcGISAPIforPython\\\\Work\\\\Bridge_Criticality_Analysis\\\\Bridge_Criticality_Analysis.gdb\\\\DCVAMD_CBSA_DeficientBridges\"\n",
    "polybarrier_bridges_fc = \"C:\\\\Users\\\\albe9057\\\\Documents\\\\ANieto_SolutionEngineering\\\\Projects\\\\FedGIS\\\\FedGIS_2018\\\\Plenary_ArcGISAPIforPython\\\\Work\\\\Bridge_Criticality_Analysis\\\\Bridge_Criticality_Analysis.gdb\\\\DCVAMD_CBSA_DeficientBridges_Polybarriers\"\n",
    "polybarriers_id_field = \"OBJECTID\"\n",
    "\n",
    "# Set reference to the network dataset\n",
    "network_dataset = \"C:\\\\ArcGIS\\\\Business Analyst\\\\US_2015\\\\Data\\\\Streets Data\\\\NAVTEQ_2014_Q3_NA.gdb\\\\Routing\\\\Routing_ND\"\n",
    "\n",
    "# Set reference to commute table\n",
    "commute_table = \"C:\\\\Users\\\\albe9057\\\\Documents\\\\ANieto_SolutionEngineering\\\\Projects\\\\FedGIS\\\\FedGIS_2018\\\\Plenary_ArcGISAPIforPython\\\\Work\\\\Bridge_Criticality_Analysis\\\\Bridge_Criticality_Analysis.gdb\\\\ctpp_journey_to_work\"\n",
    "\n",
    "# Set reference to impedance values needed for odcm\n",
    "impedance_value=99999\n",
    "impedance_attribute=\"Minutes\"\n",
    "accumulate_attributes = [\"Minutes\", \"Miles\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "### 2. Perform Bridge Commuting Impacts Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "arcgis.network.analysis.generate_origin_destination_cost_matrix?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "hidden": true
   },
   "source": [
    "Run ODCM for Nominal Commute"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "if os.path.isfile(\"nominal_odcm.csv\"):\n",
    "    print(\"Found nominal ODCM. Using processed data...\")\n",
    "    nominal_odcm_df = pd.DataFrame.from_csv(\"nominal_odcm.csv\")\n",
    "    \n",
    "else:\n",
    "\n",
    "    # Run nominal ODCM using tracts to tracts\n",
    "    nominal_odcm = create_odcm(gdb=workspace_gdb,\n",
    "                               origins_fc=origin_tracts,\n",
    "                               origins_id_field=origins_id_field,\n",
    "                               origins_name_field=origins_name_field,\n",
    "                               destinations_fc=dest_tracts,\n",
    "                               destinations_id_field=dest_id_field,\n",
    "                               destinations_name_field=dest_name_field,\n",
    "                               odcm_name=\"nominal_baseline\",\n",
    "                               network_dataset=network_dataset,\n",
    "                               impedance_value=impedance_value,\n",
    "                               impedance_attribute=impedance_attribute,\n",
    "                               accumulate_attribute_name=accumulate_attributes,\n",
    "                               polybarrier_fc=None,\n",
    "                               polybarrier_id_field=None,\n",
    "                               polybarrier_name_field=None,\n",
    "                               impedance_attribute_field_name=\"Dij\",\n",
    "                               use_lines=False,\n",
    "                               out_na_layer_name=\"Origins2Destinations\",\n",
    "                               validate_inputs=False,\n",
    "                               method_message=\"create_odcm: \",\n",
    "                               output_origin_id_field_name='origin_id',\n",
    "                               output_origin_name_field_name='origin_name',\n",
    "                               output_dest_id_field_name='destination_id',\n",
    "                               output_dest_name_field_name='destination_name',\n",
    "                               logger_object=None)\n",
    "\n",
    "    # Convert the odcm gis table to a pandas dataframe\n",
    "    print(\"Calculating ID Fields...\")\n",
    "    nominal_odcm_df = convert_gis_table_to_pddataframe(nominal_odcm)\n",
    "    nominal_odcm_df['OriginID'] = nominal_odcm_df.apply(lambda row: get_origin_id_from_odid(row['Name']), axis=1)\n",
    "    nominal_odcm_df['DestinationID'] = nominal_odcm_df.apply(lambda row: get_dest_id_from_odid(row['Name']), axis=1)\n",
    "    nominal_odcm_df.to_csv(\"nominal_odcm.csv\")\n",
    "\n",
    "nominal_odcm_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "hidden": true
   },
   "source": [
    "Run Iteration: For each Bridge, Run ODCM with Bridge Feature as a Barrier in the ODCM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# Set iteration: Structurally Deficient Bridges in DC Metropolitan Region from NBI data\n",
    "\n",
    "# Build list of buffered bridges\n",
    "bridges_list = [row[0] for row in arcpy.da.SearchCursor(polybarrier_bridges_fc, polybarriers_id_field)]\n",
    "\n",
    "# Make bridges processing directory\n",
    "bridge_dir_path = r\"D:\\ANieto_SolutionEngineer\\Projects\\FedGIS\\ArcGISAPIforPython_Workspace\\bridge_processing\"\n",
    "\n",
    "if not os.path.isdir(bridge_dir_path):\n",
    "    os.mkdir(bridge_dir_path)\n",
    "    brigde_dir = bridge_dir_path\n",
    "else:\n",
    "    bridge_dir = bridge_dir_path\n",
    "\n",
    "os.chdir(bridge_dir)\n",
    "\n",
    "# For each bridge\n",
    "for bridge in bridges_list:\n",
    "    \n",
    "    print(\"\\nChecking bridge {0} of {1}...\".format(str(bridge), str(len(bridges_list))))\n",
    "    if os.path.isfile(\"impacted_commuters_odcm_{0}.csv\".format(str(bridge))):\n",
    "        print(\"Found bridge. Using processed data...\")\n",
    "        impacted_commuters_df = pd.DataFrame.from_csv(\"impacted_commuters_odcm_{0}.csv\".format(str(bridge)))\n",
    "\n",
    "    else:\n",
    "\n",
    "        print(\"\\nProcessing bridge {0} of {1}...\".format(str(bridge), str(len(bridges_list))))\n",
    "        # Set where clause\n",
    "        bridge_sql = \"{0} = {1}\".format(arcpy.AddFieldDelimiters(polybarrier_bridges_fc, polybarriers_id_field), bridge)\n",
    "\n",
    "        # Export feature to act as a single polyline barrier\n",
    "        polybarrier_bridge_fc = arcpy.Select_analysis(polybarrier_bridges_fc, \"{0}/Bridge_{1}\".format(workspace_gdb, str(bridge)), bridge_sql)\n",
    "\n",
    "        # Run impaired ODCM using tracts to tracts, using a bridge feature as a polygon barrier\n",
    "        impaired_odcm = create_odcm(gdb=workspace_gdb,\n",
    "                                origins_fc=origin_tracts,\n",
    "                                origins_id_field=origins_id_field,\n",
    "                                origins_name_field=origins_name_field,\n",
    "                                destinations_fc=dest_tracts,\n",
    "                                destinations_id_field=dest_id_field,\n",
    "                                destinations_name_field=dest_name_field,\n",
    "                                odcm_name=\"impaired_test\",\n",
    "                                network_dataset=network_dataset,\n",
    "                                impedance_value=impedance_value,\n",
    "                                impedance_attribute=impedance_attribute,\n",
    "                                accumulate_attribute_name=accumulate_attributes,\n",
    "                                polybarrier_fc=polybarrier_bridge_fc,\n",
    "                                polybarrier_id_field=polybarriers_id_field,\n",
    "                                polybarrier_name_field=\"ITEM6A\",\n",
    "                                impedance_attribute_field_name=\"Dij\",\n",
    "                                use_lines=False,\n",
    "                                out_na_layer_name=\"Origins2Destinations\",\n",
    "                                validate_inputs=False,\n",
    "                                method_message=\"create_odcm: \",\n",
    "                                output_origin_id_field_name='origin_id',\n",
    "                                output_origin_name_field_name='origin_name',\n",
    "                                output_dest_id_field_name='destination_id',\n",
    "                                output_dest_name_field_name='destination_name',\n",
    "                                logger_object=None)\n",
    "\n",
    "        # Convert the odcm gis table to a pandas dataframe\n",
    "        impaired_odcm_csv = gis_table_to_csv(impaired_odcm, bridge_dir, \"impaired_odcm_{0}.csv\".format(str(bridge)))\n",
    "        impaired_odcm_df = pd.DataFrame.from_csv(impaired_odcm_csv)\n",
    "        \n",
    "#         impaired_odcm_df = convert_gis_table_to_pddataframe(impaired_odcm)\n",
    "        impaired_odcm_df['OriginID'] = impaired_odcm_df.apply(lambda row: get_origin_id_from_odid(row['Name']), axis=1)\n",
    "        impaired_odcm_df['DestinationID'] = impaired_odcm_df.apply(lambda row: get_dest_id_from_odid(row['Name']), axis=1)\n",
    "        impaired_odcm_df.to_csv(\"impaired_odcm_{0}.csv\".format(str(bridge)))\n",
    "\n",
    "        # Join nominal and impaired ODCM dataframes\n",
    "        nom_imp_odcm_df = pd.merge(nominal_odcm_df, impaired_odcm_df, how=\"left\", on=\"Name\")\n",
    "\n",
    "        # Join nominal+impaired ODCM dataframe to commute dataframe (inner join; remove anything not common)\n",
    "        commute_impacts_df = pd.merge(commute_df, nom_imp_odcm_df, how=\"inner\", left_on=\"ORIGIN_DESTINATION_ID\", right_on=\"Name\")\n",
    "        commute_impacts_df.to_csv(\"commute_impacts_odcm_{0}.csv\".format(str(bridge)))\n",
    "\n",
    "        # Identify deltas in impedance\n",
    "        commute_impacts_df['minutes_diff'] = commute_impacts_df['Total_Minutes_x'] - commute_impacts_df['Total_Minutes_y']\n",
    "        commute_impacts_df['miles_diff'] = commute_impacts_df['Total_Miles_x'] - commute_impacts_df['Total_Miles_y']\n",
    "        impacted_commuters_df = commute_impacts_df.loc[commute_impacts_df['minutes_diff'] > 0]\n",
    "        impacted_commuters_df.to_csv(\"impacted_commuters_odcm_{0}.csv\".format(str(bridge)))\n",
    "\n",
    "    # Calculate count and impedance sum in deltas\n",
    "    routes_impacted = impacted_commuters_df.shape[0]\n",
    "    commuters_impacted = commuters_impacted = impacted_commuters_df['EST'].sum()\n",
    "    total_additional_minutes = impacted_commuters_df['minutes_diff'].sum()\n",
    "    total_additional_miles = impacted_commuters_df['miles_diff'].sum()\n",
    "\n",
    "    bridges_df.loc[bridge, \"routes_impacted\"] = routes_impacted\n",
    "    bridges_df.loc[bridge, \"commuters_impacted\"] = commuters_impacted\n",
    "    bridges_df.loc[bridge, \"total_additional_minutes\"] = total_additional_minutes\n",
    "    bridges_df.loc[bridge, \"total_additional_miles\"] = total_additional_miles\n",
    "    \n",
    "    \n",
    "print(\"Complete!! GO GATORS\")\n",
    "bridges_df.to_csv(r\"C:\\Users\\albe9057\\Documents\\GitHub\\ArcGISPythonAPI_Projects\\Presentation\\FedGIS2018\\bridges_processed.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "hidden": true
   },
   "source": [
    "Compare differences in nominal and impacted commute tables in Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "hidden": true
   },
   "source": [
    "This could be done manually, but writing Python code to let us document, design, prototype, and run our workflow helped us get to an analysis that can now be deployed. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "### 3. Publish Outputs to WebGIS"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Let's Explore and Interpret the Results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div class=\"item_container\" style=\"height: auto; overflow: hidden; border: 1px solid #cfcfcf; border-radius: 2px; background: #f6fafa; line-height: 1.21429em; padding: 10px;\">\n",
       "                    <div class=\"item_left\" style=\"width: 210px; float: left;\">\n",
       "                       <a href='https://ndirt.maps.arcgis.com/home/item.html?id=4ecd9a0456c4452fad039c34da4d479f' target='_blank'>\n",
       "                        <img src='data:image/png;base64,/9j/4AAQSkZJRgABAQEAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3PyE371UFiOzVHKr3AUKSCNnPpn3pgISFXYgXaOP8+1ACM+xGcgAKMk+wFIZFPfQLHP5n3Y+JAUzkHj8qYhYJo5kbylACttxjFJjLKMSRuxjj86aEUpZM6lFGAQpUsT1Gfz96AHwRbbu5dI9pZgS24nd17dv/AK9AE6D94OnT39KBle6iHnWpKEkOSGBIC/WgQ26lkjkjCuFRjgvjODQMcttGHy+6Q+rnNFwJlx5TYGBkYpAV90n2lt2PJCZ565/OgCSBk8jzNykHknPSmBKkiyIXVlZG5yOh5oAgls45yxLyLu5+V8DOMU7gQDS1UMDNM2T18wmhsB89uXgjhWeRHQ5D7jknBHPryc4PFTfURXlsL9miMepugR2YhowdwOcD8M/pTAdZ6fexXKvcX4lRXJ2iLbkYwBnPOPelZAaTYPpigZXaGMysPLAHXqRU8iFYhmUrwqEjqTk1Eo22QmT2cn7sQkYkTqpHPWtmMLi+eCYRi3klXbkuo4yTjGKaAbFqIlkCG3niJAJYoMDr1/L+VFhlzDMp2kN06AUhENxci2Kh+DK4jUgDqemaNQJMtzyOvtQAyKdjdvBg/Lg5wMEH3oVwIyJRexq0jfMCQAox+NCT6gOhiaK4uZCJG8xgQCBjgdqYFjzHLcgAY9+tK7Aq3MMkrW5RMBJMtnsKAHzW++F1ZQQQaLAMt97WsTnklRzxSGSqG8ps46j0oAzJmzPKNmAoC7g3Xv0p9ARPbbRpxCHeMsMhcZ5PbmhiJbXCWiKUZMDG0jJHP0FDAV7hI3jQhsudowOM5osMaL6H7S1vuYSggfd759fwosItYGCT1z2OKADbxkUDGGRR8oYevFICC3eZ2l8zAXcfLwQePw6UwJ8YLEdSaQFZkyWHOSMGkAXW1GjK/NKxwPde4+lUhFBbJssqWchUE4BuOoyQP0qhgbeZWEn2STPUqLjheSf54/OldAa8aiKERqThcAZJPakwIr0sVT7xxJxtz/hQIrOrGTO0nOO1YNa7CH2Ssb9pGQBiACx6np29PwraL0GWHhR5kmYnemQDk96Bj5JEQjMiqScAE9aUpRi7N7jSb2M9od9hKgkiIMuchCoHI64HJq+pJpA4j5b19akYwOHiZlbPynHX0pJ31QiOwkY2casAV2Dr61fQZaABQ7GAyR1FIRBOAclsAKec0rjI7WOd7MrMyl2zyBt47dOlMRLbxeVAIyANoxjOcc+uOaBkdxgSwf6v72OTz+HH+FAirtkN8QRb4Vwc8Aj9euPb1oWwFuQN9siYYZRnJIGB/WgCwpO4cjAOeBQMglZY4Wdh05x60gIrSIJHs8soeMnJ5/PntS5ruwiztIBwx/HmqGR7WDFsgHHXpikIgRg9yJkZS+7YgPUAjr+dUgLSvMHkV3yRgjip1GL5soJxtP1IouxEnmuVOME56GncCpfl32bZCmHycY+YenWhgQMxD48vJ6Z7msRElrH/AKaZNg7Ddjk/r/StFsMs+Yd2MAincZkaxG817BHE6KLkGBwwyQo+Ysvvx/KvJzChUqVYqD+L3X5Le6/rsd2Fmowk2vh1/TUsxhjaSDG4ibADRg8cc4Ht3r1zgNA5VAMHn1OKQxn8LDP8J7+1AEdllrZCOMD14FADpp1UbEbnru/wqXLohEf2lyPv7lyRhiOaXMxEsiSuwELBF2dB6447f59DWgwMN4Xz5y44yNv+1yQf93imAs1u0skLLNsEZ3EAg7vrSAr/AGEm8klYK25sgnHy/Q5/pR0AfMmb+FcDJDEOJANo+nei2gFiRhFEXzlU5ODyaBlV7qLzHhbeGRDIQp6gAHjH1osxEltcJeReZCxKAkZJAzRYZNJ5iISkZc56A5FJ3WwijLNI+RIcDP3cYrNt9RFW28Q2UUiwkxiQfL0xn8a6aqSleJjSq3VpbmobrcjMjptP3AQKxcjcrm9kJOAmP92pvJ7InmQ03sx7R/8AfNbwUbLmTv6GUpyvo0LJqTwWlxcyBWWGMu2F6AdT+AyaiT95pGkG3HUyYPE8kkcYmsvId5GTymAzlQMnnAxk/lzU69Cy1a6+80sO22BjcoN64xlmC4/DPWmgIj4kYCMm3wzgkIcAnChgPfgjp0pagZ+satBeM2+3ndrYlka2kAOChY4II4IHGevasq1BVbcz27aG9DEzoX5ba91f8zT8OTyCCeFpWcRzyqvmEswA6cn2rHCNpOLezZvj7OcZJJXinpp6mj9tlxgOuPZa6ednBckS63BwVQkKeQuKakMr2l0wtAMAgcYKiqneK9SVK9yVLkk/NHHjB/hFZqQ7iC5LR5EUXXjgU+bTYC8CxA6AYHA+laDGkEbsYB/D1oAUEn74B49qADaNrHIH1+tAANpjODnnnAoAhN3FGX6KEOGJHTgH+RoAhOoW5PMuTyPun1x/OiwxJLuNBMSxzH975emelKwhiRTXcIlaR1TazDYwU5wR2+tTaXURnIHnk8ordsxbIl80YOTnB78VKakI8vlZQ07O9z9tEi+SABsK98981nK7ep5UnJT0PT/DJWfSkadwJBj7w5rdU2o3Z6cJqS8zT+zQdrlce4pXfSRXJFi/ZogebmMCrjGctmS1CO9iZPs0KlVdG3DBLNj+lWqL6pi9pBbNCLb2knCTHd6ZrOVLldmXGUZbMmigjhZVXfnd3x2oUUiiJrS1klSR4Q0iElGKAlc9cHtRZAOkgQu5LuOckADFJxCxj6TJbpLqF5I7Kj3TIo2g/dATP4kVzYZKUpy83+Gh24xcsacO0V+N3+prfZosZ3N+CiujlRxWHCCMFvvnII+6KfKgsVbaKNI3Rw5KnkKBRLXcVkiZEgHzbZj2wVqUkAwxwFRhJwM9MUWQFtFTly7AbRw3QcVaQx4RcE4ODz2p2AaDHkYViMdMUlYCOGaV5p1dCka42EDGeT/9amBOSCCCWPPcUAMxE2PlI59KNAIJ3igRWBABbHKjv/XNAE22PH8XQ9hSGV4o4UJIMhGCCDjkVKSQrEBkjgLCCMq3Tcx5/D0qXaOwjnLbTLO9RbkoMnnpXowpwkro82Tadma0UawoFQYAreytYm/UVf3RYkkocE5PSuKth+sTsp11LSW5M2HO5OhpUa6guWSFVouT5kR13RkpK6ORpp2YoJHSpnTjP4hxnKGxqWtysy5lyGjGd3Y1yVaXK9Dto1edakF5d/ZFRnRQGP3mbAH4/UisbG4QXcNwpZnQDtmTgjP+INFgMTT7qyjtLqKWWHP22UhTKFP3jjv0riwtSMVJN295/meljaVScoOMW/dj08jYa7sxGSLuEcHpID/Wur2ke5w+yn/K/uIrS9tY7VFN3aHaCOGCj8qHUh3Q/Y1P5X9wi6hbm/SSOZCNuCAw54//AFU1OL2ZLpzW6ZoM0Zi3lY1GRz1puyIHqVK7kC4PPAo9AGTYMMofGwrg4HOMUdQEs/3dpHGhYhUA5B5/OncCcBGGSpU+31oAq2yj7ZeBY3ypUFiOG78UWAlZ23MNrYBHOKSd3YB3LAHuDzxQMr3SM6R4TdhweuMc9aaAsbTt59D25pAQ4ABIGPakBUlIDux7nAq6VLnn5IwrVOVGdp9ube0SMHkfwkYxV05Spq8dUFSEZaS+8tV2U6kZrQ46lKUNwrQzGkMSm2QoFI4ABGO4/GsKlBT1RvTruOj1JiqsSQ4A96iEnRjaY5RVWV4AqxtwZAGz3Bx+dcs51JS5k7HRCilGzRNJLEkYgVsqOrL3NClJST3LcFy8qKc0BljUSg7Mhlwe4711RSrO7Zzyl7FWSLVnHaJH5XkhD6+v4dPwGKipRcVdGlOup6PRhd6Pa3LD/Q7Yk8lygLMAPXBrjdKEneUU/kdsMRWgrRm0vVjZNF03yzs0y03e8IrN4aj0gvuNPruJ/wCfj+9kdrpGny26tLpdsGOeDCo78cVTw1H+Rfcg+uYn/n4/vYs/h/Spoih063XPQqm0/mKiWEoNfAvuKWPxUdVUf3mFDpdzaa6LC3v7qGKS3aaNWw4BVlBGD2ww9/eqWFvS54ScWnbune/R+nSwLHc0rVoKV/k/vXr1ubIttfRNqXVkyjnLRMp/Q1PLiOjX3P8AzHfBveMl81/kIZPEECsXtba6UjpDKVb8m4qVLEQd3FNeT/z/AMx+zwc/hm4vzV1+H+Qtvr9tDEkeoRz2cuME3EZCk/7wGP5VX1umvjvH1X67A8BVetO0/R3/AA3/AANOC8tbhcwTxSj1Rwe/1reE4zV4u5yzpzpu000/MilRre8Vo94Mz/NjAzjnHT696szLxJYHfHkZ69KAFVEyCh5B6GgCvdQo6KJMRgNkH3/GgCJpwThQWA44qXIBktzHGgMjCMMdqlj1P+RRcLlP7RBKwbz49pOAQwx611xqxpw9045U3OfvFTw7KdQ0tfM2+Yq/K2ORXJSk1qdS96OpdC7zgkBlOCfcdaua9m1OOzM1u4SG5454I612Uq6nuc1Sg46x1QVs2krsxUW3ZCdeccdhXLKXPq9jsjHk92O/VkqqoOXwHPtxWbpSavEv20U7McqDkEbSP4q5HfZmoCTb8oGVPUHvSjNxd4ktJqzGvHhd6ZKe/UV6VHEKpo9zjq0eXVbE9tdlf3cnKnjNFWjfWJdGu17si20YwMMv4+lcdjtFChSfmXFADWh3Sq28fL/DUuN3e4jJnH/FaWfT/jwm/wDQ466V/AfqvykT9tej/NG1lc9Rg1gWICF9P8/hQIz77VrW3uZbeeKYKib2fZlNufb3IGKbVxp2M6SPQL+Ur9jKOM/vIozGTjBPK4Pf9K55YSjLeP3afkdUMdiIaKTa89V9zM/z47GG3vNO1C4miMir5c4LAgnB25GQf8KylTlQtKMm1dKz13dvU3hUjiuaNSCTs3dK2yvr0OlaW72gqUcHpxXbdHmkT3t3GyAxJyeoHT9acVzOyFKSjuQvcXEnJKZ+7hhkAZGcfr2rZUJMxeIghfMkIxywHcc0OkoO8ldE+0dRe47MT5WA3OMdeea0dSnFaIzVKrJ6sheIhz5cyKvUDywcHHr/AJ7+tcc25u9jpjDlVi3FYw20ISBQjLypAxk0LQ0IAxJJOAxJJA9ya7aXLOHKzjxClGfMhGzvU8nqMdv88VNWnGK90vDVHK6YmdvByRxwB0rFSvo9jdx3a3JVG0b25J6VtGLkznlJQVhpOTmulK2iORtt3ZIrZAVjx2PpXNiKHOrx3NqVXl0ewEYOK8yx1ihyvHH401JrVDGMMHjoeRXr0anPBM8+pHllYuW83mLhuorkrQ5Z+p20J80fQnIye1ZG5EX8iZEcl3kJC8dB71Ki1qxGVeTLD4wtWcqB9hmH/kSOuhP9w/VflIn7a9H+aNeOeKRDhkIHoaxWpTdhPtMWDlu/pWiozfQzdaC6lS8El0Q1tei3IDDBTcGzjBIyOmP1NDpTW6BVYPZka2d4u8S6jI6tHhWCKCrEjBGPT9c1HWxpfS5nalp88duLlZhNHbSrOlukIG1A3IHc8fyrmxV+RSXRp/cduBa9o4N25k1960NX7eLiNZICPLcblYc5Fd1CkqkVO+jPLxFSVKbptWaGbWb5mOO+T3rolVp0lY5o051NWISq8AZPbP8AhXJLE1J/CrI6IYeK31J0hmkxk+Wnb1/Kotd3bubqKWxL9gTGC7ZPcU7jLMVvBEgGMHv3zQAwoXwOwpAUxb+b5xxtfeQv+fyqlJrYGr7lZk29c7xkH2qnJvcEkthyruOXY8cfQVnFucuWKJlJRV2OMBSISqR5ZODzyDXVBunLlkYzSrQ5o7jK6zhCgBstwYwv7mSTg5KDJ/KuDFUteZHXQndcrGi5YxhxbTYI+6QAwOfTNcVjoBrolB/otzgHrsHcgevv+hrqw1TkutzGtDmVyxCf3g64NddZc1O5jQfLUsXEO44yeD2FcJ6AXAYzwEBCAeSx6dOnPWmI8/8AG9zcJrVtJDIEIBiLMeArEc/gQKynUai4d/6/U5sRNwXMiromqzJrMlhJdxT7HKho2yr+49RWmGdpanOqkqiaZ3iozDPb3NejOrCG7JjTlLZAY3H8PHqOaI1oS2Y5Upx3QgYjoSKtpMhNrYerSuwwxyOck9Kyl7Omnc0i6lRqzM21KQa1Pa2REkDJ5jooyIZCeQPTPXHavHoz5KsqVN+7v6Pt8+x7+Ih7XDwrVl7+1+67/La5sJbSv8z/AC/TrXTypHDYtRQJGPlXnnk9aBkuAOCT04GaAFzgcA4+vNAFaO6WVXUqUkXqjYyKGBWmvVkiK+Um8fdy3Q1VhGbZyXsrlEhZIznMglDHr/EM/LxQ7bgX4isIwh+Yjlj2+lY8zm+WJLlYSXbwFbPr9a9HD0+SOqOKvNSdky5DD/oJSQcSHOPasa8k5aHRh4uMdTP574z0OK6qcrxTOWvHlm0grQyFUlSCKTSasxptO6GzWsMrh2U5IGCGIOPTivHqRdOTiehGSkrokRFjiKLwoHHOe9aYZ/vURW+BiwDMy16Fb4Gc1H+IizjCv835GvPPSHqu9YyTnbzzQBh6/pNvqbbcDIPJrWnh1UXMzkxFRfCZtl4Rsf8AVTwJKpP8Q6e/tW8IKh76MILnfKjU0uFotU1bTYriSWGCKJ7czuXMZYNkZ6kcDqazrKM6caltXdaeVv8AM7Y6ScfT9f8AIs3El3bgBzZxgjKnLDnjqfqa5HsW7kRupXfYZ7UH7vckNnHQ01KS2ZLSe5Wmub68uFsLd4w8y7i8ecwJ/e57noPzrlqzlOXsoPV7vsv8+x34WjGEXiKq91bLu+3oupsR2Y0rT1isLUSOpB25xn1JPrjP14rqp04048sVZGFatOtNzm7sjOpXoA/4lLDIJP73oeeOn0/P6ZvQyHHUb8P/AMgtlXgD95yck57fT8/TmgDRxwCRSGI2QAaAM67kV5Y26FWADhSeKhTbbSJuXZYlkUCTnB9SKsoldVjRI0ACgZxnvTYGVfv5alwh9SFxzW1CMYpz6nNXu5KHcoQ6oBKP9Eud3y4LxYUZ9ee3f0qp1nJWCGHUXd6mlJc3QP71lVjzkLxj2qIQjLdm05OOyuQAAZx3JP5812QioqyPOqycpXYtWQFAD4zkbfxFcmKp80eZbo3oTs+UX+FvpXJhv4qOir8DEhOJVNejW+BnLR/iIsS4SM8cnpnBrjpwU3ZnbWnywuiP7U4jCKqrjuAK2WFXfQ5vrTtsQ8sfUmurRI59WywibUxn5j1rhrVOd2Wx6FClyK73MW2u5rTWNfnt4VnmWO3RIycbjhiefYHNLESnDCxcFd66fcv0N8PGnPEWqStHTX7yG+8TXdu9tBeaUkE8wPl7nMh45JCoC2OM/hXn0p4qtL2appO19XoehWw+DpQdV1W1e2kdfxL9vp9/fwxT/wBpW6W8ih1NnDjKnkEMxP54qnQr3tUnbyS/zuZKvhIq9Onfzb/RWNaw0200yAx28e0HlmJyzH1JrWlRhSVomNavUrSvN/5L0RaMinJHPbOc49q0MSu80gukjABU96m7vYRNncFYflVDK11cywOpAXa3fPNZzm4sTYqXkdxEMBgx447Ue0UlYLjLiyIgzEokkBB5/wA8VUYKIJWL37tuMn8BVaDHT7fNGc57U3uBDDbrIxaTBUHoacW1sS4p7labBlLkD246VDLGM7E4GQMc0rgMkg+XfHnOPu9jW9Oq4mdSlGa1Ia707q6PMlFxdmFMQUATnDIWA6jn615yp+zrJHa5c9Jsg6V6DSasziTad0BJPWhJLRDcnLVkiQl8HoD0wMk1lUrRjp1NqdCU9ehKkYUlh0H51yTqynudcKMYbD0LHoASegxWZqYUHh66F5c3EGtXMCTTs5CxISc8feI7AAD0xXS68OVJwTsrbv8Az+Znyu91L8v8vkZeueGNUUJLpdzK14JQYr5XPmxg/Kyv6rgnp6CuHAt4Ss3OPPGWjfXyPQxso42ilCXs5R1S+y+9vP1+87PTLT+zbaGzjYNbQokaKeoxxnP61tKUpzc5dTgjHlSii464cnpzSLKLQGGV3tsFWHzR5/l+tPcCSKaJyezqASrdVyOn1pWAqvPKuUbIB74rncpLRk6ladm8oqvzE8DmsxE9j+4baQT/ALQrSm7MaNRCpZQp710FEUsjo8YQRglwDu9Pz600BLIcynJHB9KTAWAbkdQcHdx9aaEV5QGOcYzyfrSYyscrJjP51IyWM5Qe1NAVZU8uXAHynLD8+a7MPP7LOTE07rnQyuo4goAUMQCOxrOdNSafYuM3FNdxK0IHpEJQysWVcEEr1/CsK9TlVkdGHp8zu+hHOrRRuyyXUmTwiuOOp4GPf6dK4rnfYhyZPlK6lg/LzjJ5Xn9P1NAFswGNfM8+43Z+VdwOTnOMY/zihAX4lEcaRgdB19+9JiFaPDhlO0nqPWgZFdyGMQ84y4/mKmbshMllk/0llDcjqAf6U762AXfzxn8eKYxk0MczZI2vgqHHUZouA3yw8CpKS7Y64pSSe4iO4t44oVZU6HvmspwSV0JoW2RQS6HLHse1OmluCLUe3zFIPf8AOtSiKUM9zbhFb74ZiG6D06j+vSmhDp2KB3SMuw6KDjOf/wBdIZDHdyIhP2Wb5jnOB0wB/X9KYiM3MmCGtpM9fl57DP8An2oGMEpdkYxun+8MVLGPUErkHGKQFW4wskUnIDNtxn2OK1ou0kZ1VeLQV6R5YUAFABSbtqCV9ETxlTGdrA4615s588rnqU4ckbDgM8ngetSaDgdz579hQIajo94iMwAT7oP8RobS0EXTkHIGRQMFww4H4nvQASRqyAP8ynIIxwaAII3EwferF0+TzFxkj3zwaXmFhygBR+9wP9qHkflS+f4CIJ5rje0aRl0zw+0gAY9Op57U7oLkcNjJcYllkKEYAAHIH/1+tCSetgIZbJprlmhZlyxY7eh5PrnHXtUczk7W0EXLVZYrjyjCSNuWbsSOuPXtx9auKS2GXIyCBJkge4x+FNa6gESKZ0cqpYdCRyOKaAU4lIGNpZsEihagZN+lvYTEJCW+XzMbyBnPTHYcUwIPNiDn90flBGN555A/pQBoTxrEQij5Qe9RIpDDxkDj5jSAhnLOikED5hnjrzV09WKWwyvUPICgAoAfGMtn0rnxEmo2XU6MNFOd30JRhc8da4TvHucErgEDgcUwFQDa5AwQrHr7U0BRgtUuwwckFVBBHrXPKPPN36EWuyPT72XaI3O9S2BnqPxrOnUd7MEzb3HHPNdZY9wDGM+poAgwA3A4c80gH+tADu3PT0oAo32oLbXf2doA48oPndjrn2/2abimIfJfiGVo1h4A/ve6j0/2v0ppAVxrh2oRbgbgD97pkIfT/a/SgDX2rcfeyGHGQaNwP//Z' width='200' height='133' class=\"itemThumbnail\">\n",
       "                       </a>\n",
       "                    </div>\n",
       "\n",
       "                    <div class=\"item_right\"     style=\"float: none; width: auto; overflow: hidden;\">\n",
       "                        <a href='https://ndirt.maps.arcgis.com/home/item.html?id=4ecd9a0456c4452fad039c34da4d479f' target='_blank'><b>DCVAMD_CBSA_DeficientBridges_Analyzed</b>\n",
       "                        </a>\n",
       "                        <br/>Bridges in the DCVAMD CBSA analyzed by impact to commuters if impaired. <img src='https://ndirt.maps.arcgis.com/home/js/jsapi/esri/css/images/item_type_icons/featureshosted16.png' style=\"vertical-align:middle;\">Feature Layer Collection by ANieto_ndirt\n",
       "                        <br/>Last Modified: March 09, 2018\n",
       "                        <br/>0 comments, 0 views\n",
       "                    </div>\n",
       "                </div>\n",
       "                "
      ],
      "text/plain": [
       "<Item title:\"DCVAMD_CBSA_DeficientBridges_Analyzed\" type:Feature Layer Collection owner:ANieto_ndirt>"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyzed_bridges_item"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DATE</th>\n",
       "      <th>DT</th>\n",
       "      <th>EXTRA</th>\n",
       "      <th>FEDERAL</th>\n",
       "      <th>FUNDED</th>\n",
       "      <th>ITEM10</th>\n",
       "      <th>ITEM100</th>\n",
       "      <th>ITEM101</th>\n",
       "      <th>ITEM102</th>\n",
       "      <th>ITEM103</th>\n",
       "      <th>...</th>\n",
       "      <th>cbsa_impact_rank</th>\n",
       "      <th>cd_impact_rank</th>\n",
       "      <th>congressional_district</th>\n",
       "      <th>county</th>\n",
       "      <th>county_impact_rank</th>\n",
       "      <th>impairment_affected_commuters</th>\n",
       "      <th>impairment_affected_routes</th>\n",
       "      <th>impairment_impact_score</th>\n",
       "      <th>impairment_impedance_delta_sum</th>\n",
       "      <th>SHAPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.10337200021758, 'y': 39.11935799987185}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0403</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.21765799961696, 'y': 38.66366399989374}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.23828300016027, 'y': 38.6813859996642}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.18044700042867, 'y': 38.52673100023554}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.1143389996451, 'y': 38.58010600019179}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.17384700003896, 'y': 38.628681000028...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.17027800002961, 'y': 38.67330300013339}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.2355419996635, 'y': 38.714106000391666}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.15158599959415, 'y': 38.70582499982396}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.15671100031238, 'y': 38.71942200002536}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.20739700037126, 'y': 38.64695299998101}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.11963900033953, 'y': 38.77170299989359}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.11746399986367, 'y': 38.72085000022736}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.25058299990548, 'y': 38.8687860000739}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0403</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.06959400016297, 'y': 39.19227499989137}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0403</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>0439</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.90755600020918, 'y': 38.69554699979426}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.89528600004883, 'y': 38.94360599971719}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0403</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.99715000037219, 'y': 38.847018999926...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0403</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.90939999981009, 'y': 38.87821699971482}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.90520799984927, 'y': 38.87955000003251}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.98534199993333, 'y': 38.90514699963438}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -78.09307500021106, 'y': 38.78860799975945}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.81362199955561, 'y': 38.53009199964612}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0403</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.78479999962025, 'y': 38.85370299969372}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.83652800006712, 'y': 38.9535250002786}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.69330299983352, 'y': 38.44719399980329}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.7880920003455, 'y': 38.74085600010437}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.83068300032016, 'y': 38.90002800009216}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.8163719995681, 'y': 38.765463999963686}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.73106700024181, 'y': 39.28516400001865}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>0313</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.31198599975403, 'y': 38.9474580001866}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>0203</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.03642200037496, 'y': 38.96265799966699}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>0503</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>0434</td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.05761700022435, 'y': 38.882358000021...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>0310</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.05374999996246, 'y': 38.88755599960973}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>0314</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.04500000024979, 'y': 39.00166699993213}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>0313</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.12999999990006, 'y': 39.00000000039972}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>0314</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.08999999980011, 'y': 39.213332999718...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>0314</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.08999999980011, 'y': 39.04166700003208}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>0313</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.09500000014987, 'y': 39.008332999768...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>0313</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.07333300011783, 'y': 39.01000000019991}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.07337200011767, 'y': 38.866027999692...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.05711400041076, 'y': 38.876774999766...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.11798299971565, 'y': 38.92899200028063}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>0309</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.14402800019201, 'y': 38.95811100042238}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.13229200037546, 'y': 38.7094030002483}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>0203</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -77.00738599956418, 'y': 38.869596999701...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>0313</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.86999999970021, 'y': 38.45333299961828}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.93333300021777, 'y': 39.016667000082...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.91999999960024, 'y': 38.97499999955039}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.9016670004317, 'y': 39.02000000000004}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.92333300041759, 'y': 39.07333299981815}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.89333300011782, 'y': 38.930000000000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.94000000009987, 'y': 38.80166700033186}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.97166699993204, 'y': 38.79000000009995}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>0303</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.84641700034427, 'y': 39.09476099962046}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.74166700003201, 'y': 38.68833299986812}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.84666700018187, 'y': 38.74666700008203}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.82666699968223, 'y': 38.87666700018195}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>0311</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.69333299961818, 'y': 38.9516670000321}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>1202</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>9999</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>{'x': -76.65180800023899, 'y': 38.70924200001832}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 143 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    DATE DT EXTRA FEDERAL FUNDED ITEM10 ITEM100 ITEM101 ITEM102 ITEM103  \\\n",
       "0   1202        1       N      N   9999       0       N       3           \n",
       "1   0403        1       N      N   9999       0       L       1           \n",
       "2   1202        1       N      N   9999       0       N       2           \n",
       "3   1202        1       N      N   9999       0       N       2           \n",
       "4   1202        1       N      N   9999       0       N       3           \n",
       "5   1202        1       N      N   9999       0       N       2           \n",
       "6   1202        1       N      N   9999       0       N       2           \n",
       "7   1202        1       N      N   9999       0       N       2           \n",
       "8   1202        1       N      N   9999       0       N       2           \n",
       "9   1202        1       N      N   9999       0       N       2           \n",
       "10  1202        1       N      N   9999       0       N       3           \n",
       "11  1202        1       N      N   9999       0       N       2           \n",
       "12  1202        1       N      N   9999       0       N       2           \n",
       "13  1202        1       N      N   9999       0       N       2           \n",
       "14  0403        1       N      N   9999       0       N       2           \n",
       "15  0403        1       N      N   0439       0       N       3           \n",
       "16  1202        1       N      N   9999       0       N       3           \n",
       "17  0403        1       N      N   9999       0       N       2           \n",
       "18  0403        1       N      N   9999       0       N       3           \n",
       "19  1202        1       N      N   9999       0       N       2           \n",
       "20  1202        1       N      N   9999       0       N       3       T   \n",
       "21  1202        1       N      N   9999       0       N       3           \n",
       "22  1202        1       N      N   9999       0       N       2           \n",
       "23  0403        1       N      N   9999       0       N       2           \n",
       "24  1202        1       N      N   9999       0       N       3           \n",
       "25  1202        1       N      N   9999       0       N       2           \n",
       "26  1202        1       N      N   9999       0       N       2           \n",
       "27  1202        1       N      N   9999       0       N       2           \n",
       "28  1202        1       N      N   9999       0       N       2           \n",
       "29  1202        1       N      N   9999       0       N       2       T   \n",
       "..   ... ..   ...     ...    ...    ...     ...     ...     ...     ...   \n",
       "66  0313        1       Y      N   9999       0       R       1           \n",
       "67  0203        1       N      N   9999       0       N       2           \n",
       "68  0503        1       N      N   0434       1       N       2           \n",
       "69  0310        1       Y      N   9999       0       N       2           \n",
       "70  0314        1       N      N   9999       0       N       3           \n",
       "71  0313        1       N      N   9999       0       N       2           \n",
       "72  0314        1       N      N   9999       0       N       3           \n",
       "73  0314        1       N      N   9999       0       N       2           \n",
       "74  0313        1       N      N   9999       0       N       2           \n",
       "75  0313        1       N      N   9999       0       N       2           \n",
       "76  1202        1       N      N   9999       1       N       2           \n",
       "77  1202        1       N      N   9999       1       N       2           \n",
       "78  1202        1       N      N   9999       1       N       2           \n",
       "79  0309        1       Y      N   9999       0       N       2           \n",
       "80  1202        1       Y      N   9999       0       N       2           \n",
       "81  0203        1       N      N   9999       0       N       2           \n",
       "82  0313        1       N      N   9999       0       N       2           \n",
       "83  0311        1       N      N   9999       0       N       2           \n",
       "84  0311        1       N      N   9999       0       N       2           \n",
       "85  0311        1       N      N   9999       0       N       2           \n",
       "86  0311        1       N      N   9999       0       N       2           \n",
       "87  0311        1       N      N   9999       0       N       2           \n",
       "88  0311        1       N      N   9999       0       N       2           \n",
       "89  0311        1       N      N   9999       0       N       2           \n",
       "90  0303        1       N      N   9999       0       N       2           \n",
       "91  0311        1       N      N   9999       0       N       3           \n",
       "92  0311        1       N      N   9999       0       N       3           \n",
       "93  0311        1       N      N   9999       0       N       2           \n",
       "94  0311        1       N      N   9999       0       N       3           \n",
       "95  1202        1       N      N   9999       0       L       1           \n",
       "\n",
       "                          ...                         cbsa_impact_rank  \\\n",
       "0                         ...                                     None   \n",
       "1                         ...                                     None   \n",
       "2                         ...                                     None   \n",
       "3                         ...                                     None   \n",
       "4                         ...                                     None   \n",
       "5                         ...                                     None   \n",
       "6                         ...                                     None   \n",
       "7                         ...                                     None   \n",
       "8                         ...                                     None   \n",
       "9                         ...                                     None   \n",
       "10                        ...                                     None   \n",
       "11                        ...                                     None   \n",
       "12                        ...                                     None   \n",
       "13                        ...                                     None   \n",
       "14                        ...                                     None   \n",
       "15                        ...                                     None   \n",
       "16                        ...                                     None   \n",
       "17                        ...                                     None   \n",
       "18                        ...                                     None   \n",
       "19                        ...                                     None   \n",
       "20                        ...                                     None   \n",
       "21                        ...                                     None   \n",
       "22                        ...                                     None   \n",
       "23                        ...                                     None   \n",
       "24                        ...                                     None   \n",
       "25                        ...                                     None   \n",
       "26                        ...                                     None   \n",
       "27                        ...                                     None   \n",
       "28                        ...                                     None   \n",
       "29                        ...                                     None   \n",
       "..                        ...                                      ...   \n",
       "66                        ...                                     None   \n",
       "67                        ...                                     None   \n",
       "68                        ...                                     None   \n",
       "69                        ...                                     None   \n",
       "70                        ...                                     None   \n",
       "71                        ...                                     None   \n",
       "72                        ...                                     None   \n",
       "73                        ...                                     None   \n",
       "74                        ...                                     None   \n",
       "75                        ...                                     None   \n",
       "76                        ...                                     None   \n",
       "77                        ...                                     None   \n",
       "78                        ...                                     None   \n",
       "79                        ...                                     None   \n",
       "80                        ...                                     None   \n",
       "81                        ...                                     None   \n",
       "82                        ...                                     None   \n",
       "83                        ...                                     None   \n",
       "84                        ...                                     None   \n",
       "85                        ...                                     None   \n",
       "86                        ...                                     None   \n",
       "87                        ...                                     None   \n",
       "88                        ...                                     None   \n",
       "89                        ...                                     None   \n",
       "90                        ...                                     None   \n",
       "91                        ...                                     None   \n",
       "92                        ...                                     None   \n",
       "93                        ...                                     None   \n",
       "94                        ...                                     None   \n",
       "95                        ...                                     None   \n",
       "\n",
       "   cd_impact_rank congressional_district county county_impact_rank  \\\n",
       "0            None                   None   None               None   \n",
       "1            None                   None   None               None   \n",
       "2            None                   None   None               None   \n",
       "3            None                   None   None               None   \n",
       "4            None                   None   None               None   \n",
       "5            None                   None   None               None   \n",
       "6            None                   None   None               None   \n",
       "7            None                   None   None               None   \n",
       "8            None                   None   None               None   \n",
       "9            None                   None   None               None   \n",
       "10           None                   None   None               None   \n",
       "11           None                   None   None               None   \n",
       "12           None                   None   None               None   \n",
       "13           None                   None   None               None   \n",
       "14           None                   None   None               None   \n",
       "15           None                   None   None               None   \n",
       "16           None                   None   None               None   \n",
       "17           None                   None   None               None   \n",
       "18           None                   None   None               None   \n",
       "19           None                   None   None               None   \n",
       "20           None                   None   None               None   \n",
       "21           None                   None   None               None   \n",
       "22           None                   None   None               None   \n",
       "23           None                   None   None               None   \n",
       "24           None                   None   None               None   \n",
       "25           None                   None   None               None   \n",
       "26           None                   None   None               None   \n",
       "27           None                   None   None               None   \n",
       "28           None                   None   None               None   \n",
       "29           None                   None   None               None   \n",
       "..            ...                    ...    ...                ...   \n",
       "66           None                   None   None               None   \n",
       "67           None                   None   None               None   \n",
       "68           None                   None   None               None   \n",
       "69           None                   None   None               None   \n",
       "70           None                   None   None               None   \n",
       "71           None                   None   None               None   \n",
       "72           None                   None   None               None   \n",
       "73           None                   None   None               None   \n",
       "74           None                   None   None               None   \n",
       "75           None                   None   None               None   \n",
       "76           None                   None   None               None   \n",
       "77           None                   None   None               None   \n",
       "78           None                   None   None               None   \n",
       "79           None                   None   None               None   \n",
       "80           None                   None   None               None   \n",
       "81           None                   None   None               None   \n",
       "82           None                   None   None               None   \n",
       "83           None                   None   None               None   \n",
       "84           None                   None   None               None   \n",
       "85           None                   None   None               None   \n",
       "86           None                   None   None               None   \n",
       "87           None                   None   None               None   \n",
       "88           None                   None   None               None   \n",
       "89           None                   None   None               None   \n",
       "90           None                   None   None               None   \n",
       "91           None                   None   None               None   \n",
       "92           None                   None   None               None   \n",
       "93           None                   None   None               None   \n",
       "94           None                   None   None               None   \n",
       "95           None                   None   None               None   \n",
       "\n",
       "   impairment_affected_commuters impairment_affected_routes  \\\n",
       "0                           None                       None   \n",
       "1                           None                       None   \n",
       "2                           None                       None   \n",
       "3                           None                       None   \n",
       "4                           None                       None   \n",
       "5                           None                       None   \n",
       "6                           None                       None   \n",
       "7                           None                       None   \n",
       "8                           None                       None   \n",
       "9                           None                       None   \n",
       "10                          None                       None   \n",
       "11                          None                       None   \n",
       "12                          None                       None   \n",
       "13                          None                       None   \n",
       "14                          None                       None   \n",
       "15                          None                       None   \n",
       "16                          None                       None   \n",
       "17                          None                       None   \n",
       "18                          None                       None   \n",
       "19                          None                       None   \n",
       "20                          None                       None   \n",
       "21                          None                       None   \n",
       "22                          None                       None   \n",
       "23                          None                       None   \n",
       "24                          None                       None   \n",
       "25                          None                       None   \n",
       "26                          None                       None   \n",
       "27                          None                       None   \n",
       "28                          None                       None   \n",
       "29                          None                       None   \n",
       "..                           ...                        ...   \n",
       "66                          None                       None   \n",
       "67                          None                       None   \n",
       "68                          None                       None   \n",
       "69                          None                       None   \n",
       "70                          None                       None   \n",
       "71                          None                       None   \n",
       "72                          None                       None   \n",
       "73                          None                       None   \n",
       "74                          None                       None   \n",
       "75                          None                       None   \n",
       "76                          None                       None   \n",
       "77                          None                       None   \n",
       "78                          None                       None   \n",
       "79                          None                       None   \n",
       "80                          None                       None   \n",
       "81                          None                       None   \n",
       "82                          None                       None   \n",
       "83                          None                       None   \n",
       "84                          None                       None   \n",
       "85                          None                       None   \n",
       "86                          None                       None   \n",
       "87                          None                       None   \n",
       "88                          None                       None   \n",
       "89                          None                       None   \n",
       "90                          None                       None   \n",
       "91                          None                       None   \n",
       "92                          None                       None   \n",
       "93                          None                       None   \n",
       "94                          None                       None   \n",
       "95                          None                       None   \n",
       "\n",
       "   impairment_impact_score impairment_impedance_delta_sum  \\\n",
       "0                     None                           None   \n",
       "1                     None                           None   \n",
       "2                     None                           None   \n",
       "3                     None                           None   \n",
       "4                     None                           None   \n",
       "5                     None                           None   \n",
       "6                     None                           None   \n",
       "7                     None                           None   \n",
       "8                     None                           None   \n",
       "9                     None                           None   \n",
       "10                    None                           None   \n",
       "11                    None                           None   \n",
       "12                    None                           None   \n",
       "13                    None                           None   \n",
       "14                    None                           None   \n",
       "15                    None                           None   \n",
       "16                    None                           None   \n",
       "17                    None                           None   \n",
       "18                    None                           None   \n",
       "19                    None                           None   \n",
       "20                    None                           None   \n",
       "21                    None                           None   \n",
       "22                    None                           None   \n",
       "23                    None                           None   \n",
       "24                    None                           None   \n",
       "25                    None                           None   \n",
       "26                    None                           None   \n",
       "27                    None                           None   \n",
       "28                    None                           None   \n",
       "29                    None                           None   \n",
       "..                     ...                            ...   \n",
       "66                    None                           None   \n",
       "67                    None                           None   \n",
       "68                    None                           None   \n",
       "69                    None                           None   \n",
       "70                    None                           None   \n",
       "71                    None                           None   \n",
       "72                    None                           None   \n",
       "73                    None                           None   \n",
       "74                    None                           None   \n",
       "75                    None                           None   \n",
       "76                    None                           None   \n",
       "77                    None                           None   \n",
       "78                    None                           None   \n",
       "79                    None                           None   \n",
       "80                    None                           None   \n",
       "81                    None                           None   \n",
       "82                    None                           None   \n",
       "83                    None                           None   \n",
       "84                    None                           None   \n",
       "85                    None                           None   \n",
       "86                    None                           None   \n",
       "87                    None                           None   \n",
       "88                    None                           None   \n",
       "89                    None                           None   \n",
       "90                    None                           None   \n",
       "91                    None                           None   \n",
       "92                    None                           None   \n",
       "93                    None                           None   \n",
       "94                    None                           None   \n",
       "95                    None                           None   \n",
       "\n",
       "                                                SHAPE  \n",
       "0   {'x': -78.10337200021758, 'y': 39.11935799987185}  \n",
       "1   {'x': -78.21765799961696, 'y': 38.66366399989374}  \n",
       "2    {'x': -78.23828300016027, 'y': 38.6813859996642}  \n",
       "3   {'x': -78.18044700042867, 'y': 38.52673100023554}  \n",
       "4    {'x': -78.1143389996451, 'y': 38.58010600019179}  \n",
       "5   {'x': -78.17384700003896, 'y': 38.628681000028...  \n",
       "6   {'x': -78.17027800002961, 'y': 38.67330300013339}  \n",
       "7   {'x': -78.2355419996635, 'y': 38.714106000391666}  \n",
       "8   {'x': -78.15158599959415, 'y': 38.70582499982396}  \n",
       "9   {'x': -78.15671100031238, 'y': 38.71942200002536}  \n",
       "10  {'x': -78.20739700037126, 'y': 38.64695299998101}  \n",
       "11  {'x': -78.11963900033953, 'y': 38.77170299989359}  \n",
       "12  {'x': -78.11746399986367, 'y': 38.72085000022736}  \n",
       "13   {'x': -78.25058299990548, 'y': 38.8687860000739}  \n",
       "14  {'x': -78.06959400016297, 'y': 39.19227499989137}  \n",
       "15  {'x': -77.90755600020918, 'y': 38.69554699979426}  \n",
       "16  {'x': -77.89528600004883, 'y': 38.94360599971719}  \n",
       "17  {'x': -77.99715000037219, 'y': 38.847018999926...  \n",
       "18  {'x': -77.90939999981009, 'y': 38.87821699971482}  \n",
       "19  {'x': -77.90520799984927, 'y': 38.87955000003251}  \n",
       "20  {'x': -77.98534199993333, 'y': 38.90514699963438}  \n",
       "21  {'x': -78.09307500021106, 'y': 38.78860799975945}  \n",
       "22  {'x': -77.81362199955561, 'y': 38.53009199964612}  \n",
       "23  {'x': -77.78479999962025, 'y': 38.85370299969372}  \n",
       "24   {'x': -77.83652800006712, 'y': 38.9535250002786}  \n",
       "25  {'x': -77.69330299983352, 'y': 38.44719399980329}  \n",
       "26   {'x': -77.7880920003455, 'y': 38.74085600010437}  \n",
       "27  {'x': -77.83068300032016, 'y': 38.90002800009216}  \n",
       "28  {'x': -77.8163719995681, 'y': 38.765463999963686}  \n",
       "29  {'x': -77.73106700024181, 'y': 39.28516400001865}  \n",
       "..                                                ...  \n",
       "66   {'x': -77.31198599975403, 'y': 38.9474580001866}  \n",
       "67  {'x': -77.03642200037496, 'y': 38.96265799966699}  \n",
       "68  {'x': -77.05761700022435, 'y': 38.882358000021...  \n",
       "69  {'x': -77.05374999996246, 'y': 38.88755599960973}  \n",
       "70  {'x': -77.04500000024979, 'y': 39.00166699993213}  \n",
       "71  {'x': -77.12999999990006, 'y': 39.00000000039972}  \n",
       "72  {'x': -77.08999999980011, 'y': 39.213332999718...  \n",
       "73  {'x': -77.08999999980011, 'y': 39.04166700003208}  \n",
       "74  {'x': -77.09500000014987, 'y': 39.008332999768...  \n",
       "75  {'x': -77.07333300011783, 'y': 39.01000000019991}  \n",
       "76  {'x': -77.07337200011767, 'y': 38.866027999692...  \n",
       "77  {'x': -77.05711400041076, 'y': 38.876774999766...  \n",
       "78  {'x': -77.11798299971565, 'y': 38.92899200028063}  \n",
       "79  {'x': -77.14402800019201, 'y': 38.95811100042238}  \n",
       "80   {'x': -77.13229200037546, 'y': 38.7094030002483}  \n",
       "81  {'x': -77.00738599956418, 'y': 38.869596999701...  \n",
       "82  {'x': -76.86999999970021, 'y': 38.45333299961828}  \n",
       "83  {'x': -76.93333300021777, 'y': 39.016667000082...  \n",
       "84  {'x': -76.91999999960024, 'y': 38.97499999955039}  \n",
       "85   {'x': -76.9016670004317, 'y': 39.02000000000004}  \n",
       "86  {'x': -76.92333300041759, 'y': 39.07333299981815}  \n",
       "87  {'x': -76.89333300011782, 'y': 38.930000000000...  \n",
       "88  {'x': -76.94000000009987, 'y': 38.80166700033186}  \n",
       "89  {'x': -76.97166699993204, 'y': 38.79000000009995}  \n",
       "90  {'x': -76.84641700034427, 'y': 39.09476099962046}  \n",
       "91  {'x': -76.74166700003201, 'y': 38.68833299986812}  \n",
       "92  {'x': -76.84666700018187, 'y': 38.74666700008203}  \n",
       "93  {'x': -76.82666699968223, 'y': 38.87666700018195}  \n",
       "94   {'x': -76.69333299961818, 'y': 38.9516670000321}  \n",
       "95  {'x': -76.65180800023899, 'y': 38.70924200001832}  \n",
       "\n",
       "[96 rows x 143 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyzed_bridges_item.layers[0].query().df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Map of Analyzed Bridges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "1a4554d033be451aa57df99dda0f6f0c"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "analyzed_bridges_map = gis.map('Fairfax County', zoomlevel=8)\n",
    "analyzed_bridges_map.basemap = 'gray-vector'\n",
    "display(analyzed_bridges_map)\n",
    "analyzed_bridges_map.add_layer(analyzed_bridges_item)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Map of Most Critical Bridge, with nominal commutes, and alternative commutes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "468888c03f76445a8c1e6c0d2e9c2da0"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "most_critical_bridge_map = gis.map('Fairfax County', zoomlevel=8)\n",
    "most_critical_bridge_map.basemap = 'gray-vector'\n",
    "display(most_critical_bridge_map)\n",
    "most_critical_bridge_map.add_layer(analyzed_bridges_item)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Map of Top Three Most Critical Bridges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "abbc803170ed4e29ab803ec2520d04d1"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "topthree_bridges_map = gis.map('Fairfax County', zoomlevel=8)\n",
    "topthree_bridges_map.basemap = 'gray-vector'\n",
    "display(topthree_bridges_map)\n",
    "topthree_bridges_map.add_layer(analyzed_bridges_item)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Group-by To Calculate Statistics by Groups (Top-five per Congressional District)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now that we have rankings for each Congressional District, this takes me to the third notebook... "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}