low_income.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Which college district has the fewest low-income families?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Note:\n",
    "This example presents an approach to using ArcGIS to find out how many low-income families are within each community college district. While the data is real, the scenario, analysis, and resulting decisions are hypothetical. The purpose of the example is to illustrate the type of problem that can be addressed by summarizing information by area features.\n",
    "\n",
    "### Doing well by doing good\n",
    "A local cable provider has been running a pilot program in the county to provide low-cost computers and Internet access to low-income families with kids in high school. There has been a marked improvement in school performance for these kids, and the program has brought the company a fair amount of positive publicity and goodwill in the community.\n",
    "\n",
    "Company officials are now considering setting up a similar program for community college students. The company provides Internet access to the five community college districts in the county, and officials are aware that the colleges are under a lot of pressure—they are facing funding cuts at the same time as increased demand for enrollment. To try to improve the situation the colleges are turning more and more to distance learning, primarily via the Internet. By providing computers and Internet access, the cable company can enable more low-income students to take advantage of online classes.\n",
    "\n",
    "### Starting small\n",
    "The company wants to start with a small pilot program in one district. To be fair they will have to offer the low-cost computers and Internet access to any low-income students in the district—if they pick a district with many such students the program may be overwhelmed from the start. So they will set up the pilot program in the district that has the fewest low-income households.\n",
    "The program is run out of the company's marketing division, so an analyst in that division is tasked with finding out which district has the fewest low-income families. To do the analysis, he'll use ArcGIS to sum the number of low-income families in census tracts that fall within each district.\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Workflow using Python ArcGIS\n",
    "Establish a connection to your organization which could be an ArcGIS Online organization or an ArcGIS Enterprise. To be able to run the code using ArcGIS python, you would need to provide credentials of a user within an ArcGIS Online organization."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from arcgis.gis import GIS\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "gis = GIS(\"https://deldev.maps.arcgis.com\", \"demos_deldev\", \"DelDevs12\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Search the data and begin performing the analysis\n",
    "\n",
    "Accessing the content property of your gis object you can use the search() method. Search for **CensusTractIncome**."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "income_data = gis.content.search('title:CensusTractIncome', 'Feature layer')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Serch for **Community_College_dist**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "dist_data = gis.content.search('title:Community_College_Dist', 'Feature layer')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "Import the display module to display the items"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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://deldev.maps.arcgis.com/home/item.html?id=4c1133c028b24ae0bcfdfebd4c4984bb' target='_blank'>\n",
       "                        <img src='http://static.arcgis.com/images/desktopapp.png' class=\"itemThumbnail\">\n",
       "                       </a>\n",
       "                    </div>\n",
       "\n",
       "                    <div class=\"item_right\"     style=\"float: none; width: auto; overflow: hidden;\">\n",
       "                        <a href='https://deldev.maps.arcgis.com/home/item.html?id=4c1133c028b24ae0bcfdfebd4c4984bb' target='_blank'><b>CensusTractIncome</b>\n",
       "                        </a>\n",
       "                        <br/><img src='https://deldev.maps.arcgis.com/home/js/jsapi/esri/css/images/item_type_icons/featureshosted16.png' style=\"vertical-align:middle;\">Feature Layer Collection by demos_deldev\n",
       "                        <br/>Last Modified: October 19, 2018\n",
       "                        <br/>0 comments, 1 views\n",
       "                    </div>\n",
       "                </div>\n",
       "                "
      ],
      "text/plain": [
       "<Item title:\"CensusTractIncome\" type:Feature Layer Collection owner:demos_deldev>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.display import display\n",
    "\n",
    "for item in income_data:\n",
    "    display(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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://deldev.maps.arcgis.com/home/item.html?id=671d31e7f8ed413285ce127367d61d7d' target='_blank'>\n",
       "                        <img src='data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAACFCAYAAAAenrcsAAAJt0lEQVR42u3dWVAUdwLH8bxs1VZtbVUedl/ytI9bqdp92q2tWOpmd7OrMZsI3geegIIMIucMDAOIKCCHHCIMBhlwBoSAYhANh0QxigeHgIjcIIigwXiCJOhvu/9DRvFA0Vkzx+9T9S/Pp6G/0/3v/nf3eyCil3qPHwERAyFiIEQMhIiBEDEQIgZCxECIGAgRAyEiBkLEQIgYCBEDIWIgRAyEiIEQMRAiBkLEQIiIgRAxECIGQsRAiBgIEQMhYiBEDISIgRARAyFiIEQMhIiBWLLHjx/zQ2AgNJXZSzVwjzwCtx3FprEpqgSe4To5IX5ADMS+zXSKgVrfhaDsjidjfwe8U84irbAGiUkp/JAYiP14JB1W3b13HyOjD6GJTIEqqxOBWW0vGe1SPN1YFrAfs2fOwP0HI/wAGYht6+m/geUBmXCOKIZS1zZFHE+Gen+ntFfpxgIfHc6cq+eHyEBs17GKM/BJv/RaYTw7grLb4R5XhZWhRdI4PDGK4BpZitWqDKwJ0omxPiQH/5zvgtn/XWOR429znBAfG4Nj35SisvJbjI+PMxAyik0vQmB25xsF8nMkk+YrE8O4l3kygnN6LXoopUNL34wrUH15EQMD1xkIGX3k6Cc28jcNxLZGKzS6Bly/PshAyOjmjSGUVDVhqSpXnK1iIAyEXqC3tw8BqWefO2ulzGwRG448VJlXGAgDsV/dHS1YocyU5g9dYoMJyx/Ap85R2BR/Eht2lsNJnSvmFgyEgdit/v5r8Bd7klaE5V3DQi+tOPRS6a5gdWiBuIhoy3sRdaY0SWcgNJVTZ85jRXi52IOYApEOr9aGHUJoXj9CDvRJwbTaZCAB6bXoG7jBQGhqnr7BCPtq0BSIfKbLNbIM6yOK8YlTqIjHJgPZW8dAaGryqt6HYz9hsasaS1U54rqG8ZqH8fqGW0yFNI7D/8tLDISB2K/6C2egSLn43Jktr93nsdgnwxQOA2EgdktfdAJeqZMjkfccf/jTxzZ5RouB0LTcu3sbYZm1k662b/1qAJ+6xtpkIL5p59HTx6UmNA3Nl5rgGV9pCsI7tRbO24pt8hDLJaoCjc1tDISm53JrF1x3VoqNKDT3KmYuC4Fy32WbC8Q1+jiaLrczEJqeH8ceQr2rABopDvkaiCqzBXPX7RCTdgbCQEhy/WoHVm8/bpqPyIdY/1qhgVrfyUAYCMl2ZxZBqWsXexGX7SVYLw15+Yk8P9Hk9DIQBmLfevuH4Jd6QQSyPCAbn22IxTppwi4vQ/n74oCJ1b8MhIHYqbt3bmNrdsNTD3HogmdSNTwTz2BFoAGKhFMItNIbsJRZHfCJ0KG7p4+B0JtbuC5ALFh8dgML1ndjiV+m1d54FVowjJSEKJv8mTGQd6i6+izck+uf28DkaJb6Z1ltIGGFt5Act4OB0NtTxR+UDqU6ngnkqpUHMsxAyEx7kZrLkx4XJEexSlMAlx1HrfYhEAyEzKbxcrs44/P0w+QWeadDk9Mz7dtcAy3k5isGQmYzMPg91JmNkwKRJ+gRRbeMe5CX7EX80huwdmuROC28Tvp13sYEzFrgBeftJca/Dz0o1noxEAZi1e7fvY3QzJonZ7AMPfjz7CX41a9/A8/E7+CnvfjCjXBLynn4pNWL08Jz10cieNI97q3Sv9Vhc3I1A2Eg1m/JxjA4BeeZrqLPc41DeOENeO+pwZy127AmtABLpb3K04safw5E3sMEG7qfO9wyBnLWuMYr+6nBQBiItYlIzIZn8nlskQ6J5PvU5cOnSXOLifVan7vtwtaCwcmBvGQ+4p1WC7fYSvhKe6Cnx7tYOcxAyKz0eYcRkjeI5So9fLR1Lzx75b+3EfM9kuGxqwobd5ZjrrRnUU31FPmJZ/1O3nu0S4G0iDnOoi3pZhsLvNKwLvwwPOKrxLO/nMJL0dxwgYGQeVy88B28M6a+5uG1+5xx0m0Fjwny1/Xg27JiBkJv7+7tWwiO1UNtmPq0rnxI5autt4rrICp9Hw7mZTMQenuanfvEaw1etdEZ5xx1pjmJJQ95+UxXaxMDobeX/3Xlaz0XS56XbIgug4NHovT/mxgIA7EfMelF4p2Frzx0kSbl8l7E5xe6AMhAGMgvIrfwCNQ5/VO+y9BlxzFxFmtDVKnFT9Td5EDaGAiZSVZO4ZSByEO+6CcvK7GGRwQpUpvReaWRgZB5pOw1IDh3ij2IvgtLAvTPXEC03BF+6DZitocwEDIP7f5iBOl7TFfMn93g5OUn/1mzDZuTqq0iED9dN06WlzAQMo89WV+L96XLT3p33LwHLpHfmJa7y8FoDD1iEaPDpkTMc4kWdxzKFw590y9a5PO03JLq0NPezEDIPE5UlECxpxEzHLzgFlsl1lA5KFLEvenye0Q+/MgRK4NysDV/ALMW+eGPf50n/f0RbIo7AZ+0Wou7sYpnscjsnJXJKKkZxunTpxEWl4VNCacx4wsF/PY2IrxwCP9eFQ5HLy3CC4YQmncN6v0dYhWv/NigVZp8OAUZxF7G+Jq3VgbCQGzL+Pj4pD+7anSY5eglHU4ZJ+8q01tyn98gxeGXYrdY7fu5W7z4fbChh4EwENt1ob4Zc9ZHISS375UbpLwn+cw5EopdVWLvsTG6/J2eDg6aWDksX68Jzb+GjclN6GhpYCD0/3N9cAgfL9qC7UXDr39PunwGSTokc5fmJuafl7SbltDLISilP/tntMBb2wCPxLNwjynHcv8MvP+7DxAQEGCzPxcGYiF+GL4JVcoJ/GNl+LResPOqQMS3vfwyUfnbXprLKLM64bevDVu0l7B5Tz0USefgElkGR0UiNkfoEZNdBUNZK/IrO3Cg/BK0hmOISsrGyYojaL/ShNF7P9jVz4WBWIjBoSGotNXiverTugYhBSKf3RLP1JJj0HeJodS1Sd/2jdK3fTXWaPKwzG8vfvv+7xEdHY3S0jIMD9/C2E+PMPbjuHjx6MjoKMbGxsTcSH4ZKTEQy/J4HL5xxeJhDOKwRvpVfqeI2tArfeO3im98z901cN91Cmu3FcPRIxGBCUXQHqrFvsM1OHC8FYajdYhPNSA+NhonKo7hzvAgP1cGYjvC47Pgnd4El4hiLFQk4MO/fAIHh/koKTmKm98P48HomPi2H304hgcjI+Ib/9GjR/zgGIj9GBu5ww+BgRAxECIGQsRAiBgIETEQIgZCxECIGAgRAyFiIEQMhIiBEDEQImIgRAyEiIEQMRAiBkLEQIgYCBEDIWIgRAyEiBgIEQMhYiBEDISIgRAxECIGQsRAiBgIEQMhIgZCxECIGAgRAyFiIEQMhIiBEDEQIgZCRAyEiIEQva3/AZWveg30L4QzAAAAAElFTkSuQmCC' 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://deldev.maps.arcgis.com/home/item.html?id=671d31e7f8ed413285ce127367d61d7d' target='_blank'><b>Community_College_Dist</b>\n",
       "                        </a>\n",
       "                        <br/>Used as an overlay to locate and identify parcels that correspond to their specific district.<img src='https://deldev.maps.arcgis.com/home/js/jsapi/esri/css/images/item_type_icons/featureshosted16.png' style=\"vertical-align:middle;\">Feature Layer Collection by demos_deldev\n",
       "                        <br/>Last Modified: October 19, 2018\n",
       "                        <br/>0 comments, 1 views\n",
       "                    </div>\n",
       "                </div>\n",
       "                "
      ],
      "text/plain": [
       "<Item title:\"Community_College_Dist\" type:Feature Layer Collection owner:demos_deldev>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.display import display\n",
    "\n",
    "for item in dist_data:\n",
    "    display(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "inc_item = income_data[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "dist_item = dist_data[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CensusTractIncome\n"
     ]
    }
   ],
   "source": [
    "for lyr in inc_lyr.layers:\n",
    "    print(lyr.properties.name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Community_College_Dist\n"
     ]
    }
   ],
   "source": [
    "for lyr in dist_lyr.layers:\n",
    "    print(lyr.properties.name)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Since the item is a Feature Layer Collection, accessing the layers property will give us a list of FeatureLayer objects."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "inc_lyr = inc_item.layers[0]\n",
    "dis_lyr = dist_item.layers[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "53a69c5157c54d80ba02c0c742aec9be",
       "version_major": 2,
       "version_minor": 0
      },
      "text/html": [
       "<p>Failed to display Jupyter Widget of type <code>MapView</code>.</p>\n",
       "<p>\n",
       "  If you're reading this message in the Jupyter Notebook or JupyterLab Notebook, it may mean\n",
       "  that the widgets JavaScript is still loading. If this message persists, it\n",
       "  likely means that the widgets JavaScript library is either not installed or\n",
       "  not enabled. See the <a href=\"https://ipywidgets.readthedocs.io/en/stable/user_install.html\">Jupyter\n",
       "  Widgets Documentation</a> for setup instructions.\n",
       "</p>\n",
       "<p>\n",
       "  If you're reading this message in another frontend (for example, a static\n",
       "  rendering on GitHub or <a href=\"https://nbviewer.jupyter.org/\">NBViewer</a>),\n",
       "  it may mean that your frontend doesn't currently support widgets.\n",
       "</p>\n"
      ],
      "text/plain": [
       "MapView(basemaps=['dark-gray', 'dark-gray-vector', 'gray', 'gray-vector', 'hybrid', 'national-geographic', 'oceans', 'osm', 'satellite', 'streets', 'streets-navigation-vector', 'streets-night-vector', 'streets-relief-vector', 'streets-vector', 'terrain', 'topo', 'topo-vector'], center=[0, 0])"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "m = gis.map('San Diego')\n",
    "m"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](low_inc_img/2.PNG)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "m.add_layer(inc_lyr)\n",
    "m.add_layer(dis_lyr)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Find the community college district with the fewest low-income families"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "From the regional association of governments GIS database, the analyst loads a layer of the community college district boundaries and a layer of census tracts. The census tract data includes the number of households in each of several income categories, such as less than $10,000, $10,000 to $15,000, $15,000 to $20,000, and so on.\n",
    "\n",
    "The standard the company has been using for the high school program is to provide support to families with an annual income less than $30,000.\n",
    "\n",
    "They will use this same standard for the community college program.The analyst adds a field to the census tract layer and sums the number of households in each tract with income less than $30,000."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Convert the layer into pandas dataframe to calculate the number of households in each tract with less than $30,000."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "from arcgis.features import SpatialDataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "sdf = SpatialDataFrame.from_layer(inc_lyr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>FID</th>\n",
       "      <th>INCOME_100</th>\n",
       "      <th>INCOME_10K</th>\n",
       "      <th>INCOME_125</th>\n",
       "      <th>INCOME_150</th>\n",
       "      <th>INCOME_15K</th>\n",
       "      <th>INCOME_200</th>\n",
       "      <th>INCOME_20K</th>\n",
       "      <th>INCOME_25K</th>\n",
       "      <th>INCOME_30K</th>\n",
       "      <th>...</th>\n",
       "      <th>INCOME_45K</th>\n",
       "      <th>INCOME_50K</th>\n",
       "      <th>INCOME_60K</th>\n",
       "      <th>INCOME_75K</th>\n",
       "      <th>INCOME_ALL</th>\n",
       "      <th>INCOME_LES</th>\n",
       "      <th>Shape__Area</th>\n",
       "      <th>Shape__Length</th>\n",
       "      <th>TRACT</th>\n",
       "      <th>SHAPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>379</td>\n",
       "      <td>205</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>158</td>\n",
       "      <td>125</td>\n",
       "      <td>195</td>\n",
       "      <td>229</td>\n",
       "      <td>279</td>\n",
       "      <td>...</td>\n",
       "      <td>304</td>\n",
       "      <td>445</td>\n",
       "      <td>526</td>\n",
       "      <td>370</td>\n",
       "      <td>4148</td>\n",
       "      <td>243</td>\n",
       "      <td>1.724049e+06</td>\n",
       "      <td>6919.424522</td>\n",
       "      <td>7700</td>\n",
       "      <td>{'rings': [[[-13051046.6746253, 3866695.333166...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>107</td>\n",
       "      <td>132</td>\n",
       "      <td>64</td>\n",
       "      <td>52</td>\n",
       "      <td>180</td>\n",
       "      <td>9</td>\n",
       "      <td>160</td>\n",
       "      <td>135</td>\n",
       "      <td>250</td>\n",
       "      <td>...</td>\n",
       "      <td>115</td>\n",
       "      <td>280</td>\n",
       "      <td>263</td>\n",
       "      <td>178</td>\n",
       "      <td>2510</td>\n",
       "      <td>294</td>\n",
       "      <td>2.889814e+06</td>\n",
       "      <td>11223.567885</td>\n",
       "      <td>7800</td>\n",
       "      <td>{'rings': [[[-13049196.649225, 3869830.7042951...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>150</td>\n",
       "      <td>156</td>\n",
       "      <td>49</td>\n",
       "      <td>42</td>\n",
       "      <td>154</td>\n",
       "      <td>25</td>\n",
       "      <td>191</td>\n",
       "      <td>209</td>\n",
       "      <td>233</td>\n",
       "      <td>...</td>\n",
       "      <td>188</td>\n",
       "      <td>325</td>\n",
       "      <td>393</td>\n",
       "      <td>233</td>\n",
       "      <td>2953</td>\n",
       "      <td>240</td>\n",
       "      <td>1.785775e+06</td>\n",
       "      <td>5749.634908</td>\n",
       "      <td>7901</td>\n",
       "      <td>{'rings': [[[-13051806.5792234, 3868598.509832...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>124</td>\n",
       "      <td>163</td>\n",
       "      <td>30</td>\n",
       "      <td>43</td>\n",
       "      <td>184</td>\n",
       "      <td>19</td>\n",
       "      <td>174</td>\n",
       "      <td>171</td>\n",
       "      <td>139</td>\n",
       "      <td>...</td>\n",
       "      <td>143</td>\n",
       "      <td>288</td>\n",
       "      <td>145</td>\n",
       "      <td>310</td>\n",
       "      <td>2429</td>\n",
       "      <td>154</td>\n",
       "      <td>1.075471e+06</td>\n",
       "      <td>4651.499315</td>\n",
       "      <td>7903</td>\n",
       "      <td>{'rings': [[[-13050375.5212048, 3868973.977334...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>162</td>\n",
       "      <td>219</td>\n",
       "      <td>53</td>\n",
       "      <td>67</td>\n",
       "      <td>187</td>\n",
       "      <td>19</td>\n",
       "      <td>208</td>\n",
       "      <td>218</td>\n",
       "      <td>199</td>\n",
       "      <td>...</td>\n",
       "      <td>172</td>\n",
       "      <td>304</td>\n",
       "      <td>316</td>\n",
       "      <td>326</td>\n",
       "      <td>3157</td>\n",
       "      <td>335</td>\n",
       "      <td>1.318394e+06</td>\n",
       "      <td>4961.527797</td>\n",
       "      <td>7904</td>\n",
       "      <td>{'rings': [[[-13050786.6266337, 3868042.625540...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   FID  INCOME_100  INCOME_10K  INCOME_125  INCOME_150  INCOME_15K  \\\n",
       "0    1         379         205          73         127         158   \n",
       "1    2         107         132          64          52         180   \n",
       "2    3         150         156          49          42         154   \n",
       "3    4         124         163          30          43         184   \n",
       "4    5         162         219          53          67         187   \n",
       "\n",
       "   INCOME_200  INCOME_20K  INCOME_25K  INCOME_30K  \\\n",
       "0         125         195         229         279   \n",
       "1           9         160         135         250   \n",
       "2          25         191         209         233   \n",
       "3          19         174         171         139   \n",
       "4          19         208         218         199   \n",
       "\n",
       "                         ...                          INCOME_45K  INCOME_50K  \\\n",
       "0                        ...                                 304         445   \n",
       "1                        ...                                 115         280   \n",
       "2                        ...                                 188         325   \n",
       "3                        ...                                 143         288   \n",
       "4                        ...                                 172         304   \n",
       "\n",
       "   INCOME_60K  INCOME_75K  INCOME_ALL  INCOME_LES   Shape__Area  \\\n",
       "0         526         370        4148         243  1.724049e+06   \n",
       "1         263         178        2510         294  2.889814e+06   \n",
       "2         393         233        2953         240  1.785775e+06   \n",
       "3         145         310        2429         154  1.075471e+06   \n",
       "4         316         326        3157         335  1.318394e+06   \n",
       "\n",
       "   Shape__Length  TRACT                                              SHAPE  \n",
       "0    6919.424522   7700  {'rings': [[[-13051046.6746253, 3866695.333166...  \n",
       "1   11223.567885   7800  {'rings': [[[-13049196.649225, 3869830.7042951...  \n",
       "2    5749.634908   7901  {'rings': [[[-13051806.5792234, 3868598.509832...  \n",
       "3    4651.499315   7903  {'rings': [[[-13050375.5212048, 3868973.977334...  \n",
       "4    4961.527797   7904  {'rings': [[[-13050786.6266337, 3868042.625540...  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "sdf['income_lt_30k'] = sdf['INCOME_LES'] + sdf['INCOME_10K'] + sdf['INCOME_15K'] + sdf['INCOME_20K'] + sdf['INCOME_25K']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1030\n",
       "1     901\n",
       "2     950\n",
       "3     846\n",
       "4    1167\n",
       "Name: income_lt_30k, dtype: int64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sdf.income_lt_30k.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>FID</th>\n",
       "      <th>INCOME_100</th>\n",
       "      <th>INCOME_10K</th>\n",
       "      <th>INCOME_125</th>\n",
       "      <th>INCOME_150</th>\n",
       "      <th>INCOME_15K</th>\n",
       "      <th>INCOME_200</th>\n",
       "      <th>INCOME_20K</th>\n",
       "      <th>INCOME_25K</th>\n",
       "      <th>INCOME_30K</th>\n",
       "      <th>...</th>\n",
       "      <th>INCOME_50K</th>\n",
       "      <th>INCOME_60K</th>\n",
       "      <th>INCOME_75K</th>\n",
       "      <th>INCOME_ALL</th>\n",
       "      <th>INCOME_LES</th>\n",
       "      <th>Shape__Area</th>\n",
       "      <th>Shape__Length</th>\n",
       "      <th>TRACT</th>\n",
       "      <th>SHAPE</th>\n",
       "      <th>income_lt_30k</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>379</td>\n",
       "      <td>205</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>158</td>\n",
       "      <td>125</td>\n",
       "      <td>195</td>\n",
       "      <td>229</td>\n",
       "      <td>279</td>\n",
       "      <td>...</td>\n",
       "      <td>445</td>\n",
       "      <td>526</td>\n",
       "      <td>370</td>\n",
       "      <td>4148</td>\n",
       "      <td>243</td>\n",
       "      <td>1.724049e+06</td>\n",
       "      <td>6919.424522</td>\n",
       "      <td>7700</td>\n",
       "      <td>{'rings': [[[-13051046.6746253, 3866695.333166...</td>\n",
       "      <td>1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>107</td>\n",
       "      <td>132</td>\n",
       "      <td>64</td>\n",
       "      <td>52</td>\n",
       "      <td>180</td>\n",
       "      <td>9</td>\n",
       "      <td>160</td>\n",
       "      <td>135</td>\n",
       "      <td>250</td>\n",
       "      <td>...</td>\n",
       "      <td>280</td>\n",
       "      <td>263</td>\n",
       "      <td>178</td>\n",
       "      <td>2510</td>\n",
       "      <td>294</td>\n",
       "      <td>2.889814e+06</td>\n",
       "      <td>11223.567885</td>\n",
       "      <td>7800</td>\n",
       "      <td>{'rings': [[[-13049196.649225, 3869830.7042951...</td>\n",
       "      <td>901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>150</td>\n",
       "      <td>156</td>\n",
       "      <td>49</td>\n",
       "      <td>42</td>\n",
       "      <td>154</td>\n",
       "      <td>25</td>\n",
       "      <td>191</td>\n",
       "      <td>209</td>\n",
       "      <td>233</td>\n",
       "      <td>...</td>\n",
       "      <td>325</td>\n",
       "      <td>393</td>\n",
       "      <td>233</td>\n",
       "      <td>2953</td>\n",
       "      <td>240</td>\n",
       "      <td>1.785775e+06</td>\n",
       "      <td>5749.634908</td>\n",
       "      <td>7901</td>\n",
       "      <td>{'rings': [[[-13051806.5792234, 3868598.509832...</td>\n",
       "      <td>950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>124</td>\n",
       "      <td>163</td>\n",
       "      <td>30</td>\n",
       "      <td>43</td>\n",
       "      <td>184</td>\n",
       "      <td>19</td>\n",
       "      <td>174</td>\n",
       "      <td>171</td>\n",
       "      <td>139</td>\n",
       "      <td>...</td>\n",
       "      <td>288</td>\n",
       "      <td>145</td>\n",
       "      <td>310</td>\n",
       "      <td>2429</td>\n",
       "      <td>154</td>\n",
       "      <td>1.075471e+06</td>\n",
       "      <td>4651.499315</td>\n",
       "      <td>7903</td>\n",
       "      <td>{'rings': [[[-13050375.5212048, 3868973.977334...</td>\n",
       "      <td>846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>162</td>\n",
       "      <td>219</td>\n",
       "      <td>53</td>\n",
       "      <td>67</td>\n",
       "      <td>187</td>\n",
       "      <td>19</td>\n",
       "      <td>208</td>\n",
       "      <td>218</td>\n",
       "      <td>199</td>\n",
       "      <td>...</td>\n",
       "      <td>304</td>\n",
       "      <td>316</td>\n",
       "      <td>326</td>\n",
       "      <td>3157</td>\n",
       "      <td>335</td>\n",
       "      <td>1.318394e+06</td>\n",
       "      <td>4961.527797</td>\n",
       "      <td>7904</td>\n",
       "      <td>{'rings': [[[-13050786.6266337, 3868042.625540...</td>\n",
       "      <td>1167</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   FID  INCOME_100  INCOME_10K  INCOME_125  INCOME_150  INCOME_15K  \\\n",
       "0    1         379         205          73         127         158   \n",
       "1    2         107         132          64          52         180   \n",
       "2    3         150         156          49          42         154   \n",
       "3    4         124         163          30          43         184   \n",
       "4    5         162         219          53          67         187   \n",
       "\n",
       "   INCOME_200  INCOME_20K  INCOME_25K  INCOME_30K      ...        INCOME_50K  \\\n",
       "0         125         195         229         279      ...               445   \n",
       "1           9         160         135         250      ...               280   \n",
       "2          25         191         209         233      ...               325   \n",
       "3          19         174         171         139      ...               288   \n",
       "4          19         208         218         199      ...               304   \n",
       "\n",
       "   INCOME_60K  INCOME_75K  INCOME_ALL  INCOME_LES   Shape__Area  \\\n",
       "0         526         370        4148         243  1.724049e+06   \n",
       "1         263         178        2510         294  2.889814e+06   \n",
       "2         393         233        2953         240  1.785775e+06   \n",
       "3         145         310        2429         154  1.075471e+06   \n",
       "4         316         326        3157         335  1.318394e+06   \n",
       "\n",
       "   Shape__Length  TRACT                                              SHAPE  \\\n",
       "0    6919.424522   7700  {'rings': [[[-13051046.6746253, 3866695.333166...   \n",
       "1   11223.567885   7800  {'rings': [[[-13049196.649225, 3869830.7042951...   \n",
       "2    5749.634908   7901  {'rings': [[[-13051806.5792234, 3868598.509832...   \n",
       "3    4651.499315   7903  {'rings': [[[-13050375.5212048, 3868973.977334...   \n",
       "4    4961.527797   7904  {'rings': [[[-13050786.6266337, 3868042.625540...   \n",
       "\n",
       "   income_lt_30k  \n",
       "0           1030  \n",
       "1            901  \n",
       "2            950  \n",
       "3            846  \n",
       "4           1167  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "cols = sdf.columns.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "cols = cols[-1:] + cols[:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = sdf[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>income_lt_30k</th>\n",
       "      <th>FID</th>\n",
       "      <th>INCOME_100</th>\n",
       "      <th>INCOME_10K</th>\n",
       "      <th>INCOME_125</th>\n",
       "      <th>INCOME_150</th>\n",
       "      <th>INCOME_15K</th>\n",
       "      <th>INCOME_200</th>\n",
       "      <th>INCOME_20K</th>\n",
       "      <th>INCOME_25K</th>\n",
       "      <th>...</th>\n",
       "      <th>INCOME_45K</th>\n",
       "      <th>INCOME_50K</th>\n",
       "      <th>INCOME_60K</th>\n",
       "      <th>INCOME_75K</th>\n",
       "      <th>INCOME_ALL</th>\n",
       "      <th>INCOME_LES</th>\n",
       "      <th>Shape__Area</th>\n",
       "      <th>Shape__Length</th>\n",
       "      <th>TRACT</th>\n",
       "      <th>SHAPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1030</td>\n",
       "      <td>1</td>\n",
       "      <td>379</td>\n",
       "      <td>205</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>158</td>\n",
       "      <td>125</td>\n",
       "      <td>195</td>\n",
       "      <td>229</td>\n",
       "      <td>...</td>\n",
       "      <td>304</td>\n",
       "      <td>445</td>\n",
       "      <td>526</td>\n",
       "      <td>370</td>\n",
       "      <td>4148</td>\n",
       "      <td>243</td>\n",
       "      <td>1.724049e+06</td>\n",
       "      <td>6919.424522</td>\n",
       "      <td>7700</td>\n",
       "      <td>{'rings': [[[-13051046.6746253, 3866695.333166...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>901</td>\n",
       "      <td>2</td>\n",
       "      <td>107</td>\n",
       "      <td>132</td>\n",
       "      <td>64</td>\n",
       "      <td>52</td>\n",
       "      <td>180</td>\n",
       "      <td>9</td>\n",
       "      <td>160</td>\n",
       "      <td>135</td>\n",
       "      <td>...</td>\n",
       "      <td>115</td>\n",
       "      <td>280</td>\n",
       "      <td>263</td>\n",
       "      <td>178</td>\n",
       "      <td>2510</td>\n",
       "      <td>294</td>\n",
       "      <td>2.889814e+06</td>\n",
       "      <td>11223.567885</td>\n",
       "      <td>7800</td>\n",
       "      <td>{'rings': [[[-13049196.649225, 3869830.7042951...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>950</td>\n",
       "      <td>3</td>\n",
       "      <td>150</td>\n",
       "      <td>156</td>\n",
       "      <td>49</td>\n",
       "      <td>42</td>\n",
       "      <td>154</td>\n",
       "      <td>25</td>\n",
       "      <td>191</td>\n",
       "      <td>209</td>\n",
       "      <td>...</td>\n",
       "      <td>188</td>\n",
       "      <td>325</td>\n",
       "      <td>393</td>\n",
       "      <td>233</td>\n",
       "      <td>2953</td>\n",
       "      <td>240</td>\n",
       "      <td>1.785775e+06</td>\n",
       "      <td>5749.634908</td>\n",
       "      <td>7901</td>\n",
       "      <td>{'rings': [[[-13051806.5792234, 3868598.509832...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>846</td>\n",
       "      <td>4</td>\n",
       "      <td>124</td>\n",
       "      <td>163</td>\n",
       "      <td>30</td>\n",
       "      <td>43</td>\n",
       "      <td>184</td>\n",
       "      <td>19</td>\n",
       "      <td>174</td>\n",
       "      <td>171</td>\n",
       "      <td>...</td>\n",
       "      <td>143</td>\n",
       "      <td>288</td>\n",
       "      <td>145</td>\n",
       "      <td>310</td>\n",
       "      <td>2429</td>\n",
       "      <td>154</td>\n",
       "      <td>1.075471e+06</td>\n",
       "      <td>4651.499315</td>\n",
       "      <td>7903</td>\n",
       "      <td>{'rings': [[[-13050375.5212048, 3868973.977334...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1167</td>\n",
       "      <td>5</td>\n",
       "      <td>162</td>\n",
       "      <td>219</td>\n",
       "      <td>53</td>\n",
       "      <td>67</td>\n",
       "      <td>187</td>\n",
       "      <td>19</td>\n",
       "      <td>208</td>\n",
       "      <td>218</td>\n",
       "      <td>...</td>\n",
       "      <td>172</td>\n",
       "      <td>304</td>\n",
       "      <td>316</td>\n",
       "      <td>326</td>\n",
       "      <td>3157</td>\n",
       "      <td>335</td>\n",
       "      <td>1.318394e+06</td>\n",
       "      <td>4961.527797</td>\n",
       "      <td>7904</td>\n",
       "      <td>{'rings': [[[-13050786.6266337, 3868042.625540...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>966</td>\n",
       "      <td>6</td>\n",
       "      <td>253</td>\n",
       "      <td>197</td>\n",
       "      <td>171</td>\n",
       "      <td>119</td>\n",
       "      <td>218</td>\n",
       "      <td>91</td>\n",
       "      <td>234</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>174</td>\n",
       "      <td>301</td>\n",
       "      <td>404</td>\n",
       "      <td>395</td>\n",
       "      <td>3654</td>\n",
       "      <td>200</td>\n",
       "      <td>2.415333e+06</td>\n",
       "      <td>7715.823845</td>\n",
       "      <td>8001</td>\n",
       "      <td>{'rings': [[[-13054490.4325811, 3870586.577816...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>220</td>\n",
       "      <td>7</td>\n",
       "      <td>139</td>\n",
       "      <td>41</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>42</td>\n",
       "      <td>44</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>68</td>\n",
       "      <td>129</td>\n",
       "      <td>143</td>\n",
       "      <td>1048</td>\n",
       "      <td>101</td>\n",
       "      <td>1.554710e+06</td>\n",
       "      <td>6048.096718</td>\n",
       "      <td>8002</td>\n",
       "      <td>{'rings': [[[-13050627.5009782, 3870107.420239...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>626</td>\n",
       "      <td>8</td>\n",
       "      <td>171</td>\n",
       "      <td>120</td>\n",
       "      <td>48</td>\n",
       "      <td>145</td>\n",
       "      <td>98</td>\n",
       "      <td>167</td>\n",
       "      <td>129</td>\n",
       "      <td>106</td>\n",
       "      <td>...</td>\n",
       "      <td>132</td>\n",
       "      <td>142</td>\n",
       "      <td>193</td>\n",
       "      <td>265</td>\n",
       "      <td>2191</td>\n",
       "      <td>173</td>\n",
       "      <td>1.663333e+06</td>\n",
       "      <td>5476.224492</td>\n",
       "      <td>8101</td>\n",
       "      <td>{'rings': [[[-13054685.3064826, 3872808.524061...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>246</td>\n",
       "      <td>9</td>\n",
       "      <td>109</td>\n",
       "      <td>31</td>\n",
       "      <td>89</td>\n",
       "      <td>125</td>\n",
       "      <td>73</td>\n",
       "      <td>265</td>\n",
       "      <td>57</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>154</td>\n",
       "      <td>137</td>\n",
       "      <td>160</td>\n",
       "      <td>1408</td>\n",
       "      <td>64</td>\n",
       "      <td>1.956280e+06</td>\n",
       "      <td>7842.229636</td>\n",
       "      <td>8102</td>\n",
       "      <td>{'rings': [[[-13055272.813358, 3871408.7886397...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>400</td>\n",
       "      <td>10</td>\n",
       "      <td>161</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "      <td>64</td>\n",
       "      <td>104</td>\n",
       "      <td>139</td>\n",
       "      <td>83</td>\n",
       "      <td>88</td>\n",
       "      <td>...</td>\n",
       "      <td>45</td>\n",
       "      <td>206</td>\n",
       "      <td>209</td>\n",
       "      <td>239</td>\n",
       "      <td>1780</td>\n",
       "      <td>70</td>\n",
       "      <td>1.838454e+06</td>\n",
       "      <td>6662.390637</td>\n",
       "      <td>8200</td>\n",
       "      <td>{'rings': [[[-13054984.3942046, 3874078.987216...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>169</td>\n",
       "      <td>11</td>\n",
       "      <td>165</td>\n",
       "      <td>5</td>\n",
       "      <td>89</td>\n",
       "      <td>67</td>\n",
       "      <td>25</td>\n",
       "      <td>152</td>\n",
       "      <td>27</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>82</td>\n",
       "      <td>95</td>\n",
       "      <td>151</td>\n",
       "      <td>194</td>\n",
       "      <td>1314</td>\n",
       "      <td>80</td>\n",
       "      <td>3.374119e+06</td>\n",
       "      <td>9184.803866</td>\n",
       "      <td>8301</td>\n",
       "      <td>{'rings': [[[-13051253.0713894, 3871205.926138...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>171</td>\n",
       "      <td>12</td>\n",
       "      <td>132</td>\n",
       "      <td>32</td>\n",
       "      <td>125</td>\n",
       "      <td>173</td>\n",
       "      <td>25</td>\n",
       "      <td>465</td>\n",
       "      <td>29</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>46</td>\n",
       "      <td>47</td>\n",
       "      <td>145</td>\n",
       "      <td>128</td>\n",
       "      <td>1533</td>\n",
       "      <td>65</td>\n",
       "      <td>6.394057e+06</td>\n",
       "      <td>11216.945555</td>\n",
       "      <td>8303</td>\n",
       "      <td>{'rings': [[[-13053352.1699691, 3873160.584997...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>420</td>\n",
       "      <td>13</td>\n",
       "      <td>18</td>\n",
       "      <td>62</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>167</td>\n",
       "      <td>9</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>52</td>\n",
       "      <td>24</td>\n",
       "      <td>18</td>\n",
       "      <td>806</td>\n",
       "      <td>55</td>\n",
       "      <td>6.333392e+06</td>\n",
       "      <td>10690.986601</td>\n",
       "      <td>8305</td>\n",
       "      <td>{'rings': [[[-13050863.3957248, 3878300.666601...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>179</td>\n",
       "      <td>14</td>\n",
       "      <td>112</td>\n",
       "      <td>17</td>\n",
       "      <td>88</td>\n",
       "      <td>125</td>\n",
       "      <td>42</td>\n",
       "      <td>92</td>\n",
       "      <td>25</td>\n",
       "      <td>52</td>\n",
       "      <td>...</td>\n",
       "      <td>78</td>\n",
       "      <td>80</td>\n",
       "      <td>124</td>\n",
       "      <td>189</td>\n",
       "      <td>1189</td>\n",
       "      <td>43</td>\n",
       "      <td>3.885693e+06</td>\n",
       "      <td>8030.980054</td>\n",
       "      <td>8306</td>\n",
       "      <td>{'rings': [[[-13048823.4033755, 3874913.162689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>288</td>\n",
       "      <td>15</td>\n",
       "      <td>197</td>\n",
       "      <td>55</td>\n",
       "      <td>133</td>\n",
       "      <td>138</td>\n",
       "      <td>49</td>\n",
       "      <td>104</td>\n",
       "      <td>75</td>\n",
       "      <td>60</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>89</td>\n",
       "      <td>120</td>\n",
       "      <td>171</td>\n",
       "      <td>1495</td>\n",
       "      <td>49</td>\n",
       "      <td>3.133490e+06</td>\n",
       "      <td>7807.047576</td>\n",
       "      <td>8307</td>\n",
       "      <td>{'rings': [[[-13047615.2935363, 3874885.452239...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>364</td>\n",
       "      <td>16</td>\n",
       "      <td>218</td>\n",
       "      <td>17</td>\n",
       "      <td>173</td>\n",
       "      <td>295</td>\n",
       "      <td>41</td>\n",
       "      <td>393</td>\n",
       "      <td>34</td>\n",
       "      <td>118</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>132</td>\n",
       "      <td>148</td>\n",
       "      <td>254</td>\n",
       "      <td>2199</td>\n",
       "      <td>154</td>\n",
       "      <td>7.265318e+06</td>\n",
       "      <td>14868.314100</td>\n",
       "      <td>8310</td>\n",
       "      <td>{'rings': [[[-13051182.3297173, 3871541.918906...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>108</td>\n",
       "      <td>17</td>\n",
       "      <td>117</td>\n",
       "      <td>36</td>\n",
       "      <td>78</td>\n",
       "      <td>133</td>\n",
       "      <td>14</td>\n",
       "      <td>330</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>40</td>\n",
       "      <td>61</td>\n",
       "      <td>94</td>\n",
       "      <td>1112</td>\n",
       "      <td>31</td>\n",
       "      <td>3.542382e+06</td>\n",
       "      <td>10063.516408</td>\n",
       "      <td>8311</td>\n",
       "      <td>{'rings': [[[-13054260.8210188, 3872983.109533...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>341</td>\n",
       "      <td>18</td>\n",
       "      <td>145</td>\n",
       "      <td>31</td>\n",
       "      <td>79</td>\n",
       "      <td>137</td>\n",
       "      <td>79</td>\n",
       "      <td>404</td>\n",
       "      <td>56</td>\n",
       "      <td>91</td>\n",
       "      <td>...</td>\n",
       "      <td>41</td>\n",
       "      <td>74</td>\n",
       "      <td>135</td>\n",
       "      <td>182</td>\n",
       "      <td>1685</td>\n",
       "      <td>84</td>\n",
       "      <td>1.284507e+07</td>\n",
       "      <td>28561.618793</td>\n",
       "      <td>8312</td>\n",
       "      <td>{'rings': [[[-13052867.6717771, 3875430.066969...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>113</td>\n",
       "      <td>19</td>\n",
       "      <td>90</td>\n",
       "      <td>22</td>\n",
       "      <td>47</td>\n",
       "      <td>119</td>\n",
       "      <td>26</td>\n",
       "      <td>214</td>\n",
       "      <td>13</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>26</td>\n",
       "      <td>82</td>\n",
       "      <td>72</td>\n",
       "      <td>859</td>\n",
       "      <td>34</td>\n",
       "      <td>3.392996e+06</td>\n",
       "      <td>11181.722853</td>\n",
       "      <td>8313</td>\n",
       "      <td>{'rings': [[[-13051512.5514892, 3874954.005932...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>869</td>\n",
       "      <td>20</td>\n",
       "      <td>190</td>\n",
       "      <td>153</td>\n",
       "      <td>120</td>\n",
       "      <td>135</td>\n",
       "      <td>135</td>\n",
       "      <td>75</td>\n",
       "      <td>107</td>\n",
       "      <td>159</td>\n",
       "      <td>...</td>\n",
       "      <td>122</td>\n",
       "      <td>260</td>\n",
       "      <td>459</td>\n",
       "      <td>432</td>\n",
       "      <td>3022</td>\n",
       "      <td>315</td>\n",
       "      <td>2.020695e+06</td>\n",
       "      <td>7158.672579</td>\n",
       "      <td>8315</td>\n",
       "      <td>{'rings': [[[-13050682.508639, 3877033.6211176...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>240</td>\n",
       "      <td>21</td>\n",
       "      <td>388</td>\n",
       "      <td>27</td>\n",
       "      <td>208</td>\n",
       "      <td>352</td>\n",
       "      <td>54</td>\n",
       "      <td>466</td>\n",
       "      <td>71</td>\n",
       "      <td>53</td>\n",
       "      <td>...</td>\n",
       "      <td>63</td>\n",
       "      <td>166</td>\n",
       "      <td>181</td>\n",
       "      <td>445</td>\n",
       "      <td>2847</td>\n",
       "      <td>35</td>\n",
       "      <td>7.921623e+06</td>\n",
       "      <td>16142.228554</td>\n",
       "      <td>8324</td>\n",
       "      <td>{'rings': [[[-13053387.0672709, 3888281.990188...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>330</td>\n",
       "      <td>22</td>\n",
       "      <td>276</td>\n",
       "      <td>39</td>\n",
       "      <td>181</td>\n",
       "      <td>148</td>\n",
       "      <td>28</td>\n",
       "      <td>289</td>\n",
       "      <td>48</td>\n",
       "      <td>60</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>104</td>\n",
       "      <td>218</td>\n",
       "      <td>259</td>\n",
       "      <td>2027</td>\n",
       "      <td>155</td>\n",
       "      <td>9.048742e+06</td>\n",
       "      <td>13586.341474</td>\n",
       "      <td>8327</td>\n",
       "      <td>{'rings': [[[-13052561.1888173, 3892646.667145...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>46</td>\n",
       "      <td>23</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>116</td>\n",
       "      <td>23</td>\n",
       "      <td>348</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>56</td>\n",
       "      <td>717</td>\n",
       "      <td>23</td>\n",
       "      <td>9.987781e+06</td>\n",
       "      <td>16549.055560</td>\n",
       "      <td>8328</td>\n",
       "      <td>{'rings': [[[-13048972.3929177, 3889477.213342...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>428</td>\n",
       "      <td>24</td>\n",
       "      <td>162</td>\n",
       "      <td>65</td>\n",
       "      <td>92</td>\n",
       "      <td>99</td>\n",
       "      <td>24</td>\n",
       "      <td>82</td>\n",
       "      <td>88</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>57</td>\n",
       "      <td>216</td>\n",
       "      <td>244</td>\n",
       "      <td>509</td>\n",
       "      <td>2247</td>\n",
       "      <td>151</td>\n",
       "      <td>3.546258e+06</td>\n",
       "      <td>8363.732309</td>\n",
       "      <td>8329</td>\n",
       "      <td>{'rings': [[[-13049863.8607747, 3889041.288344...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>232</td>\n",
       "      <td>25</td>\n",
       "      <td>281</td>\n",
       "      <td>51</td>\n",
       "      <td>230</td>\n",
       "      <td>130</td>\n",
       "      <td>32</td>\n",
       "      <td>243</td>\n",
       "      <td>31</td>\n",
       "      <td>52</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>172</td>\n",
       "      <td>179</td>\n",
       "      <td>302</td>\n",
       "      <td>2010</td>\n",
       "      <td>66</td>\n",
       "      <td>2.183874e+06</td>\n",
       "      <td>5724.244445</td>\n",
       "      <td>8330</td>\n",
       "      <td>{'rings': [[[-13048122.8159571, 3888625.190454...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>87</td>\n",
       "      <td>26</td>\n",
       "      <td>99</td>\n",
       "      <td>24</td>\n",
       "      <td>93</td>\n",
       "      <td>109</td>\n",
       "      <td>7</td>\n",
       "      <td>82</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>43</td>\n",
       "      <td>90</td>\n",
       "      <td>180</td>\n",
       "      <td>872</td>\n",
       "      <td>34</td>\n",
       "      <td>1.386796e+06</td>\n",
       "      <td>4922.698757</td>\n",
       "      <td>8331</td>\n",
       "      <td>{'rings': [[[-13048544.8978956, 3888039.948292...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>430</td>\n",
       "      <td>27</td>\n",
       "      <td>129</td>\n",
       "      <td>59</td>\n",
       "      <td>65</td>\n",
       "      <td>50</td>\n",
       "      <td>95</td>\n",
       "      <td>13</td>\n",
       "      <td>62</td>\n",
       "      <td>144</td>\n",
       "      <td>...</td>\n",
       "      <td>95</td>\n",
       "      <td>102</td>\n",
       "      <td>226</td>\n",
       "      <td>172</td>\n",
       "      <td>1559</td>\n",
       "      <td>70</td>\n",
       "      <td>6.335647e+06</td>\n",
       "      <td>13558.591428</td>\n",
       "      <td>19602</td>\n",
       "      <td>{'rings': [[[-13048577.9139601, 3919892.552196...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>675</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>109</td>\n",
       "      <td>40</td>\n",
       "      <td>30</td>\n",
       "      <td>89</td>\n",
       "      <td>22</td>\n",
       "      <td>127</td>\n",
       "      <td>195</td>\n",
       "      <td>...</td>\n",
       "      <td>164</td>\n",
       "      <td>206</td>\n",
       "      <td>255</td>\n",
       "      <td>198</td>\n",
       "      <td>2070</td>\n",
       "      <td>155</td>\n",
       "      <td>4.389532e+06</td>\n",
       "      <td>9064.923364</td>\n",
       "      <td>19701</td>\n",
       "      <td>{'rings': [[[-13055105.3144289, 3919782.699823...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>416</td>\n",
       "      <td>29</td>\n",
       "      <td>129</td>\n",
       "      <td>74</td>\n",
       "      <td>42</td>\n",
       "      <td>23</td>\n",
       "      <td>94</td>\n",
       "      <td>53</td>\n",
       "      <td>89</td>\n",
       "      <td>78</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>196</td>\n",
       "      <td>196</td>\n",
       "      <td>250</td>\n",
       "      <td>1638</td>\n",
       "      <td>81</td>\n",
       "      <td>5.786023e+06</td>\n",
       "      <td>11817.855340</td>\n",
       "      <td>19702</td>\n",
       "      <td>{'rings': [[[-13052304.967358, 3919090.9721004...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>328</td>\n",
       "      <td>30</td>\n",
       "      <td>94</td>\n",
       "      <td>49</td>\n",
       "      <td>54</td>\n",
       "      <td>31</td>\n",
       "      <td>52</td>\n",
       "      <td>24</td>\n",
       "      <td>47</td>\n",
       "      <td>68</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>144</td>\n",
       "      <td>251</td>\n",
       "      <td>260</td>\n",
       "      <td>1495</td>\n",
       "      <td>112</td>\n",
       "      <td>5.436744e+06</td>\n",
       "      <td>10856.812385</td>\n",
       "      <td>19803</td>\n",
       "      <td>{'rings': [[[-13060096.020693, 3918104.8252378...</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>575</th>\n",
       "      <td>132</td>\n",
       "      <td>576</td>\n",
       "      <td>114</td>\n",
       "      <td>25</td>\n",
       "      <td>34</td>\n",
       "      <td>64</td>\n",
       "      <td>35</td>\n",
       "      <td>65</td>\n",
       "      <td>21</td>\n",
       "      <td>38</td>\n",
       "      <td>...</td>\n",
       "      <td>38</td>\n",
       "      <td>58</td>\n",
       "      <td>81</td>\n",
       "      <td>172</td>\n",
       "      <td>864</td>\n",
       "      <td>13</td>\n",
       "      <td>1.183300e+06</td>\n",
       "      <td>4489.139456</td>\n",
       "      <td>7302</td>\n",
       "      <td>{'rings': [[[-13052170.2306954, 3859938.784224...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576</th>\n",
       "      <td>1011</td>\n",
       "      <td>577</td>\n",
       "      <td>118</td>\n",
       "      <td>187</td>\n",
       "      <td>69</td>\n",
       "      <td>52</td>\n",
       "      <td>180</td>\n",
       "      <td>50</td>\n",
       "      <td>210</td>\n",
       "      <td>194</td>\n",
       "      <td>...</td>\n",
       "      <td>245</td>\n",
       "      <td>252</td>\n",
       "      <td>353</td>\n",
       "      <td>341</td>\n",
       "      <td>3119</td>\n",
       "      <td>240</td>\n",
       "      <td>2.142908e+06</td>\n",
       "      <td>6685.816281</td>\n",
       "      <td>7400</td>\n",
       "      <td>{'rings': [[[-13051639.1183524, 3861076.222574...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>577</th>\n",
       "      <td>963</td>\n",
       "      <td>578</td>\n",
       "      <td>52</td>\n",
       "      <td>182</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>186</td>\n",
       "      <td>6</td>\n",
       "      <td>189</td>\n",
       "      <td>212</td>\n",
       "      <td>...</td>\n",
       "      <td>119</td>\n",
       "      <td>191</td>\n",
       "      <td>236</td>\n",
       "      <td>149</td>\n",
       "      <td>2255</td>\n",
       "      <td>194</td>\n",
       "      <td>1.580955e+06</td>\n",
       "      <td>6143.574777</td>\n",
       "      <td>7501</td>\n",
       "      <td>{'rings': [[[-13052516.6880596, 3862709.919096...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>578</th>\n",
       "      <td>667</td>\n",
       "      <td>579</td>\n",
       "      <td>89</td>\n",
       "      <td>93</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>163</td>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>97</td>\n",
       "      <td>156</td>\n",
       "      <td>158</td>\n",
       "      <td>82</td>\n",
       "      <td>1758</td>\n",
       "      <td>185</td>\n",
       "      <td>9.795364e+05</td>\n",
       "      <td>4756.038809</td>\n",
       "      <td>7502</td>\n",
       "      <td>{'rings': [[[-13051558.7172011, 3861187.577056...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579</th>\n",
       "      <td>1400</td>\n",
       "      <td>580</td>\n",
       "      <td>161</td>\n",
       "      <td>342</td>\n",
       "      <td>103</td>\n",
       "      <td>136</td>\n",
       "      <td>178</td>\n",
       "      <td>93</td>\n",
       "      <td>199</td>\n",
       "      <td>242</td>\n",
       "      <td>...</td>\n",
       "      <td>149</td>\n",
       "      <td>291</td>\n",
       "      <td>247</td>\n",
       "      <td>312</td>\n",
       "      <td>3405</td>\n",
       "      <td>439</td>\n",
       "      <td>2.530105e+07</td>\n",
       "      <td>27527.986138</td>\n",
       "      <td>7600</td>\n",
       "      <td>{'rings': [[[-13049325.694417, 3863176.5217676...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td>735</td>\n",
       "      <td>581</td>\n",
       "      <td>47</td>\n",
       "      <td>171</td>\n",
       "      <td>32</td>\n",
       "      <td>29</td>\n",
       "      <td>150</td>\n",
       "      <td>21</td>\n",
       "      <td>117</td>\n",
       "      <td>195</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>189</td>\n",
       "      <td>167</td>\n",
       "      <td>140</td>\n",
       "      <td>1864</td>\n",
       "      <td>102</td>\n",
       "      <td>4.079916e+06</td>\n",
       "      <td>10789.426209</td>\n",
       "      <td>18905</td>\n",
       "      <td>{'rings': [[[-13053099.4576755, 3944665.420913...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>713</td>\n",
       "      <td>582</td>\n",
       "      <td>85</td>\n",
       "      <td>107</td>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>172</td>\n",
       "      <td>14</td>\n",
       "      <td>151</td>\n",
       "      <td>189</td>\n",
       "      <td>...</td>\n",
       "      <td>101</td>\n",
       "      <td>131</td>\n",
       "      <td>173</td>\n",
       "      <td>125</td>\n",
       "      <td>1791</td>\n",
       "      <td>94</td>\n",
       "      <td>6.410247e+06</td>\n",
       "      <td>13338.543854</td>\n",
       "      <td>18906</td>\n",
       "      <td>{'rings': [[[-13052187.1415777, 3943940.829139...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>582</th>\n",
       "      <td>382</td>\n",
       "      <td>583</td>\n",
       "      <td>168</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>106</td>\n",
       "      <td>86</td>\n",
       "      <td>95</td>\n",
       "      <td>...</td>\n",
       "      <td>101</td>\n",
       "      <td>204</td>\n",
       "      <td>263</td>\n",
       "      <td>228</td>\n",
       "      <td>1931</td>\n",
       "      <td>51</td>\n",
       "      <td>2.467171e+08</td>\n",
       "      <td>125461.005433</td>\n",
       "      <td>19001</td>\n",
       "      <td>{'rings': [[[-13049513.6109623, 3948347.310351...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>583</th>\n",
       "      <td>186</td>\n",
       "      <td>584</td>\n",
       "      <td>49</td>\n",
       "      <td>33</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>66</td>\n",
       "      <td>14</td>\n",
       "      <td>44</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>47</td>\n",
       "      <td>32</td>\n",
       "      <td>64</td>\n",
       "      <td>516</td>\n",
       "      <td>27</td>\n",
       "      <td>5.396583e+07</td>\n",
       "      <td>42650.424427</td>\n",
       "      <td>19002</td>\n",
       "      <td>{'rings': [[[-13036112.4026521, 3952563.500473...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>584</th>\n",
       "      <td>712</td>\n",
       "      <td>585</td>\n",
       "      <td>110</td>\n",
       "      <td>153</td>\n",
       "      <td>42</td>\n",
       "      <td>54</td>\n",
       "      <td>132</td>\n",
       "      <td>46</td>\n",
       "      <td>156</td>\n",
       "      <td>148</td>\n",
       "      <td>...</td>\n",
       "      <td>95</td>\n",
       "      <td>155</td>\n",
       "      <td>251</td>\n",
       "      <td>213</td>\n",
       "      <td>2094</td>\n",
       "      <td>123</td>\n",
       "      <td>3.582940e+08</td>\n",
       "      <td>141602.532541</td>\n",
       "      <td>19101</td>\n",
       "      <td>{'rings': [[[-13027993.5990003, 3934184.569905...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>403</td>\n",
       "      <td>586</td>\n",
       "      <td>237</td>\n",
       "      <td>46</td>\n",
       "      <td>70</td>\n",
       "      <td>59</td>\n",
       "      <td>65</td>\n",
       "      <td>87</td>\n",
       "      <td>91</td>\n",
       "      <td>113</td>\n",
       "      <td>...</td>\n",
       "      <td>79</td>\n",
       "      <td>158</td>\n",
       "      <td>354</td>\n",
       "      <td>252</td>\n",
       "      <td>1875</td>\n",
       "      <td>88</td>\n",
       "      <td>8.999233e+07</td>\n",
       "      <td>60917.984388</td>\n",
       "      <td>19103</td>\n",
       "      <td>{'rings': [[[-13034772.0836383, 3929052.198000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td>470</td>\n",
       "      <td>587</td>\n",
       "      <td>188</td>\n",
       "      <td>53</td>\n",
       "      <td>142</td>\n",
       "      <td>60</td>\n",
       "      <td>104</td>\n",
       "      <td>79</td>\n",
       "      <td>49</td>\n",
       "      <td>165</td>\n",
       "      <td>...</td>\n",
       "      <td>106</td>\n",
       "      <td>247</td>\n",
       "      <td>186</td>\n",
       "      <td>362</td>\n",
       "      <td>2154</td>\n",
       "      <td>99</td>\n",
       "      <td>6.512923e+07</td>\n",
       "      <td>41899.419402</td>\n",
       "      <td>19105</td>\n",
       "      <td>{'rings': [[[-13029082.5555324, 3925571.374612...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td>417</td>\n",
       "      <td>588</td>\n",
       "      <td>220</td>\n",
       "      <td>103</td>\n",
       "      <td>202</td>\n",
       "      <td>103</td>\n",
       "      <td>68</td>\n",
       "      <td>87</td>\n",
       "      <td>72</td>\n",
       "      <td>53</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>147</td>\n",
       "      <td>255</td>\n",
       "      <td>214</td>\n",
       "      <td>1979</td>\n",
       "      <td>121</td>\n",
       "      <td>1.032499e+08</td>\n",
       "      <td>52207.974139</td>\n",
       "      <td>19106</td>\n",
       "      <td>{'rings': [[[-13026993.5637122, 3930975.596354...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>236</td>\n",
       "      <td>589</td>\n",
       "      <td>39</td>\n",
       "      <td>64</td>\n",
       "      <td>17</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>73</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>66</td>\n",
       "      <td>58</td>\n",
       "      <td>112</td>\n",
       "      <td>758</td>\n",
       "      <td>26</td>\n",
       "      <td>1.717457e+08</td>\n",
       "      <td>66582.882893</td>\n",
       "      <td>19107</td>\n",
       "      <td>{'rings': [[[-13005412.7581819, 3929352.534492...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>284</td>\n",
       "      <td>590</td>\n",
       "      <td>103</td>\n",
       "      <td>22</td>\n",
       "      <td>36</td>\n",
       "      <td>28</td>\n",
       "      <td>69</td>\n",
       "      <td>14</td>\n",
       "      <td>69</td>\n",
       "      <td>71</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>122</td>\n",
       "      <td>146</td>\n",
       "      <td>114</td>\n",
       "      <td>991</td>\n",
       "      <td>53</td>\n",
       "      <td>5.456098e+06</td>\n",
       "      <td>10293.692470</td>\n",
       "      <td>19203</td>\n",
       "      <td>{'rings': [[[-13051359.9295364, 3927490.044136...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>900</td>\n",
       "      <td>591</td>\n",
       "      <td>56</td>\n",
       "      <td>199</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>213</td>\n",
       "      <td>26</td>\n",
       "      <td>162</td>\n",
       "      <td>169</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>141</td>\n",
       "      <td>93</td>\n",
       "      <td>175</td>\n",
       "      <td>1955</td>\n",
       "      <td>157</td>\n",
       "      <td>2.787910e+06</td>\n",
       "      <td>7622.915896</td>\n",
       "      <td>19205</td>\n",
       "      <td>{'rings': [[[-13049554.7052835, 3924950.002713...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>498</td>\n",
       "      <td>592</td>\n",
       "      <td>16</td>\n",
       "      <td>69</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>78</td>\n",
       "      <td>7</td>\n",
       "      <td>109</td>\n",
       "      <td>121</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>149</td>\n",
       "      <td>150</td>\n",
       "      <td>114</td>\n",
       "      <td>1334</td>\n",
       "      <td>121</td>\n",
       "      <td>2.070763e+06</td>\n",
       "      <td>6525.017242</td>\n",
       "      <td>19206</td>\n",
       "      <td>{'rings': [[[-13051645.7853143, 3923507.502663...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>742</td>\n",
       "      <td>593</td>\n",
       "      <td>131</td>\n",
       "      <td>136</td>\n",
       "      <td>139</td>\n",
       "      <td>85</td>\n",
       "      <td>195</td>\n",
       "      <td>82</td>\n",
       "      <td>173</td>\n",
       "      <td>120</td>\n",
       "      <td>...</td>\n",
       "      <td>142</td>\n",
       "      <td>271</td>\n",
       "      <td>194</td>\n",
       "      <td>356</td>\n",
       "      <td>2572</td>\n",
       "      <td>118</td>\n",
       "      <td>3.464590e+07</td>\n",
       "      <td>28891.410144</td>\n",
       "      <td>19207</td>\n",
       "      <td>{'rings': [[[-13047720.5121139, 3923492.540695...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>130</td>\n",
       "      <td>594</td>\n",
       "      <td>86</td>\n",
       "      <td>15</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>52</td>\n",
       "      <td>44</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21</td>\n",
       "      <td>76</td>\n",
       "      <td>144</td>\n",
       "      <td>151</td>\n",
       "      <td>919</td>\n",
       "      <td>48</td>\n",
       "      <td>4.318942e+07</td>\n",
       "      <td>37725.503259</td>\n",
       "      <td>19208</td>\n",
       "      <td>{'rings': [[[-13043900.5325018, 3924846.732163...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>282</td>\n",
       "      <td>595</td>\n",
       "      <td>323</td>\n",
       "      <td>93</td>\n",
       "      <td>98</td>\n",
       "      <td>57</td>\n",
       "      <td>41</td>\n",
       "      <td>45</td>\n",
       "      <td>59</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>202</td>\n",
       "      <td>285</td>\n",
       "      <td>442</td>\n",
       "      <td>2074</td>\n",
       "      <td>38</td>\n",
       "      <td>5.026164e+06</td>\n",
       "      <td>11830.205749</td>\n",
       "      <td>19301</td>\n",
       "      <td>{'rings': [[[-13056720.2788921, 3924816.373175...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td>1087</td>\n",
       "      <td>596</td>\n",
       "      <td>126</td>\n",
       "      <td>221</td>\n",
       "      <td>19</td>\n",
       "      <td>35</td>\n",
       "      <td>228</td>\n",
       "      <td>13</td>\n",
       "      <td>178</td>\n",
       "      <td>265</td>\n",
       "      <td>...</td>\n",
       "      <td>140</td>\n",
       "      <td>259</td>\n",
       "      <td>433</td>\n",
       "      <td>463</td>\n",
       "      <td>3050</td>\n",
       "      <td>195</td>\n",
       "      <td>3.595653e+06</td>\n",
       "      <td>9505.725497</td>\n",
       "      <td>19302</td>\n",
       "      <td>{'rings': [[[-13055467.7480167, 3925119.263405...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>460</td>\n",
       "      <td>597</td>\n",
       "      <td>241</td>\n",
       "      <td>99</td>\n",
       "      <td>81</td>\n",
       "      <td>34</td>\n",
       "      <td>73</td>\n",
       "      <td>25</td>\n",
       "      <td>78</td>\n",
       "      <td>126</td>\n",
       "      <td>...</td>\n",
       "      <td>95</td>\n",
       "      <td>232</td>\n",
       "      <td>166</td>\n",
       "      <td>400</td>\n",
       "      <td>2077</td>\n",
       "      <td>84</td>\n",
       "      <td>1.212032e+07</td>\n",
       "      <td>19162.843787</td>\n",
       "      <td>19303</td>\n",
       "      <td>{'rings': [[[-13052345.4125801, 3924694.464127...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>333</td>\n",
       "      <td>598</td>\n",
       "      <td>83</td>\n",
       "      <td>76</td>\n",
       "      <td>78</td>\n",
       "      <td>38</td>\n",
       "      <td>94</td>\n",
       "      <td>38</td>\n",
       "      <td>41</td>\n",
       "      <td>69</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>164</td>\n",
       "      <td>190</td>\n",
       "      <td>272</td>\n",
       "      <td>1497</td>\n",
       "      <td>53</td>\n",
       "      <td>4.625056e+06</td>\n",
       "      <td>9634.323841</td>\n",
       "      <td>19403</td>\n",
       "      <td>{'rings': [[[-13052757.5335329, 3922954.842143...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>165</td>\n",
       "      <td>599</td>\n",
       "      <td>48</td>\n",
       "      <td>23</td>\n",
       "      <td>27</td>\n",
       "      <td>7</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>43</td>\n",
       "      <td>...</td>\n",
       "      <td>90</td>\n",
       "      <td>94</td>\n",
       "      <td>101</td>\n",
       "      <td>91</td>\n",
       "      <td>826</td>\n",
       "      <td>21</td>\n",
       "      <td>1.600955e+06</td>\n",
       "      <td>6124.998819</td>\n",
       "      <td>19404</td>\n",
       "      <td>{'rings': [[[-13052601.7705112, 3923488.058120...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>599</th>\n",
       "      <td>304</td>\n",
       "      <td>600</td>\n",
       "      <td>14</td>\n",
       "      <td>40</td>\n",
       "      <td>14</td>\n",
       "      <td>32</td>\n",
       "      <td>52</td>\n",
       "      <td>6</td>\n",
       "      <td>88</td>\n",
       "      <td>85</td>\n",
       "      <td>...</td>\n",
       "      <td>139</td>\n",
       "      <td>128</td>\n",
       "      <td>128</td>\n",
       "      <td>90</td>\n",
       "      <td>1176</td>\n",
       "      <td>39</td>\n",
       "      <td>1.573882e+06</td>\n",
       "      <td>6639.041801</td>\n",
       "      <td>19405</td>\n",
       "      <td>{'rings': [[[-13054854.7811202, 3921549.964804...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>322</td>\n",
       "      <td>601</td>\n",
       "      <td>94</td>\n",
       "      <td>65</td>\n",
       "      <td>47</td>\n",
       "      <td>18</td>\n",
       "      <td>53</td>\n",
       "      <td>20</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>...</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>247</td>\n",
       "      <td>201</td>\n",
       "      <td>1478</td>\n",
       "      <td>85</td>\n",
       "      <td>2.806946e+06</td>\n",
       "      <td>7392.782002</td>\n",
       "      <td>19406</td>\n",
       "      <td>{'rings': [[[-13052730.4914816, 3921273.833950...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>331</td>\n",
       "      <td>602</td>\n",
       "      <td>8</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>113</td>\n",
       "      <td>67</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "      <td>65</td>\n",
       "      <td>775</td>\n",
       "      <td>77</td>\n",
       "      <td>1.124992e+06</td>\n",
       "      <td>5088.690205</td>\n",
       "      <td>19501</td>\n",
       "      <td>{'rings': [[[-13051533.6392657, 3922083.914222...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>651</td>\n",
       "      <td>603</td>\n",
       "      <td>25</td>\n",
       "      <td>70</td>\n",
       "      <td>18</td>\n",
       "      <td>11</td>\n",
       "      <td>130</td>\n",
       "      <td>17</td>\n",
       "      <td>172</td>\n",
       "      <td>168</td>\n",
       "      <td>...</td>\n",
       "      <td>38</td>\n",
       "      <td>163</td>\n",
       "      <td>86</td>\n",
       "      <td>71</td>\n",
       "      <td>1335</td>\n",
       "      <td>111</td>\n",
       "      <td>1.122228e+06</td>\n",
       "      <td>4167.173741</td>\n",
       "      <td>19502</td>\n",
       "      <td>{'rings': [[[-13050799.740359, 3923451.9523159...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>575</td>\n",
       "      <td>604</td>\n",
       "      <td>23</td>\n",
       "      <td>132</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>104</td>\n",
       "      <td>45</td>\n",
       "      <td>158</td>\n",
       "      <td>83</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>139</td>\n",
       "      <td>162</td>\n",
       "      <td>81</td>\n",
       "      <td>1520</td>\n",
       "      <td>98</td>\n",
       "      <td>2.526340e+06</td>\n",
       "      <td>8434.798843</td>\n",
       "      <td>19503</td>\n",
       "      <td>{'rings': [[[-13051642.3301841, 3921457.625820...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>720</td>\n",
       "      <td>605</td>\n",
       "      <td>116</td>\n",
       "      <td>98</td>\n",
       "      <td>49</td>\n",
       "      <td>81</td>\n",
       "      <td>112</td>\n",
       "      <td>18</td>\n",
       "      <td>201</td>\n",
       "      <td>157</td>\n",
       "      <td>...</td>\n",
       "      <td>93</td>\n",
       "      <td>211</td>\n",
       "      <td>289</td>\n",
       "      <td>176</td>\n",
       "      <td>2175</td>\n",
       "      <td>152</td>\n",
       "      <td>5.028331e+06</td>\n",
       "      <td>10703.585053</td>\n",
       "      <td>19601</td>\n",
       "      <td>{'rings': [[[-13047720.5121139, 3923492.540695...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>605 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     income_lt_30k  FID  INCOME_100  INCOME_10K  INCOME_125  INCOME_150  \\\n",
       "0             1030    1         379         205          73         127   \n",
       "1              901    2         107         132          64          52   \n",
       "2              950    3         150         156          49          42   \n",
       "3              846    4         124         163          30          43   \n",
       "4             1167    5         162         219          53          67   \n",
       "5              966    6         253         197         171         119   \n",
       "6              220    7         139          41          63         100   \n",
       "7              626    8         171         120          48         145   \n",
       "8              246    9         109          31          89         125   \n",
       "9              400   10         161          55          33          64   \n",
       "10             169   11         165           5          89          67   \n",
       "11             171   12         132          32         125         173   \n",
       "12             420   13          18          62           6           5   \n",
       "13             179   14         112          17          88         125   \n",
       "14             288   15         197          55         133         138   \n",
       "15             364   16         218          17         173         295   \n",
       "16             108   17         117          36          78         133   \n",
       "17             341   18         145          31          79         137   \n",
       "18             113   19          90          22          47         119   \n",
       "19             869   20         190         153         120         135   \n",
       "20             240   21         388          27         208         352   \n",
       "21             330   22         276          39         181         148   \n",
       "22              46   23          36           0          36         116   \n",
       "23             428   24         162          65          92          99   \n",
       "24             232   25         281          51         230         130   \n",
       "25              87   26          99          24          93         109   \n",
       "26             430   27         129          59          65          50   \n",
       "27             675   28          70         109          40          30   \n",
       "28             416   29         129          74          42          23   \n",
       "29             328   30          94          49          54          31   \n",
       "..             ...  ...         ...         ...         ...         ...   \n",
       "575            132  576         114          25          34          64   \n",
       "576           1011  577         118         187          69          52   \n",
       "577            963  578          52         182           7           0   \n",
       "578            667  579          89          93          16          12   \n",
       "579           1400  580         161         342         103         136   \n",
       "580            735  581          47         171          32          29   \n",
       "581            713  582          85         107          36          19   \n",
       "582            382  583         168          70         115          65   \n",
       "583            186  584          49          33          10          12   \n",
       "584            712  585         110         153          42          54   \n",
       "585            403  586         237          46          70          59   \n",
       "586            470  587         188          53         142          60   \n",
       "587            417  588         220         103         202         103   \n",
       "588            236  589          39          64          17           8   \n",
       "589            284  590         103          22          36          28   \n",
       "590            900  591          56         199           0           0   \n",
       "591            498  592          16          69          21           8   \n",
       "592            742  593         131         136         139          85   \n",
       "593            130  594          86          15          56          56   \n",
       "594            282  595         323          93          98          57   \n",
       "595           1087  596         126         221          19          35   \n",
       "596            460  597         241          99          81          34   \n",
       "597            333  598          83          76          78          38   \n",
       "598            165  599          48          23          27           7   \n",
       "599            304  600          14          40          14          32   \n",
       "600            322  601          94          65          47          18   \n",
       "601            331  602           8          52           0           0   \n",
       "602            651  603          25          70          18          11   \n",
       "603            575  604          23         132           0          22   \n",
       "604            720  605         116          98          49          81   \n",
       "\n",
       "     INCOME_15K  INCOME_200  INCOME_20K  INCOME_25K  \\\n",
       "0           158         125         195         229   \n",
       "1           180           9         160         135   \n",
       "2           154          25         191         209   \n",
       "3           184          19         174         171   \n",
       "4           187          19         208         218   \n",
       "5           218          91         234         117   \n",
       "6            42          44          16          20   \n",
       "7            98         167         129         106   \n",
       "8            73         265          57          21   \n",
       "9           104         139          83          88   \n",
       "10           25         152          27          32   \n",
       "11           25         465          29          20   \n",
       "12          167           9          67          69   \n",
       "13           42          92          25          52   \n",
       "14           49         104          75          60   \n",
       "15           41         393          34         118   \n",
       "16           14         330           6          21   \n",
       "17           79         404          56          91   \n",
       "18           26         214          13          18   \n",
       "19          135          75         107         159   \n",
       "20           54         466          71          53   \n",
       "21           28         289          48          60   \n",
       "22           23         348           0           0   \n",
       "23           24          82          88         100   \n",
       "24           32         243          31          52   \n",
       "25            7          82          15           7   \n",
       "26           95          13          62         144   \n",
       "27           89          22         127         195   \n",
       "28           94          53          89          78   \n",
       "29           52          24          47          68   \n",
       "..          ...         ...         ...         ...   \n",
       "575          35          65          21          38   \n",
       "576         180          50         210         194   \n",
       "577         186           6         189         212   \n",
       "578         163           0         133          93   \n",
       "579         178          93         199         242   \n",
       "580         150          21         117         195   \n",
       "581         172          14         151         189   \n",
       "582          80         106          86          95   \n",
       "583          66          14          44          16   \n",
       "584         132          46         156         148   \n",
       "585          65          87          91         113   \n",
       "586         104          79          49         165   \n",
       "587          68          87          72          53   \n",
       "588          23          18          73          50   \n",
       "589          69          14          69          71   \n",
       "590         213          26         162         169   \n",
       "591          78           7         109         121   \n",
       "592         195          82         173         120   \n",
       "593          52          44          15           0   \n",
       "594          41          45          59          51   \n",
       "595         228          13         178         265   \n",
       "596          73          25          78         126   \n",
       "597          94          38          41          69   \n",
       "598          29           0          49          43   \n",
       "599          52           6          88          85   \n",
       "600          53          20          51          68   \n",
       "601          22           0         113          67   \n",
       "602         130          17         172         168   \n",
       "603         104          45         158          83   \n",
       "604         112          18         201         157   \n",
       "\n",
       "                           ...                          INCOME_45K  \\\n",
       "0                          ...                                 304   \n",
       "1                          ...                                 115   \n",
       "2                          ...                                 188   \n",
       "3                          ...                                 143   \n",
       "4                          ...                                 172   \n",
       "5                          ...                                 174   \n",
       "6                          ...                                  24   \n",
       "7                          ...                                 132   \n",
       "8                          ...                                  26   \n",
       "9                          ...                                  45   \n",
       "10                         ...                                  82   \n",
       "11                         ...                                  46   \n",
       "12                         ...                                  39   \n",
       "13                         ...                                  78   \n",
       "14                         ...                                  72   \n",
       "15                         ...                                  56   \n",
       "16                         ...                                  58   \n",
       "17                         ...                                  41   \n",
       "18                         ...                                  13   \n",
       "19                         ...                                 122   \n",
       "20                         ...                                  63   \n",
       "21                         ...                                  59   \n",
       "22                         ...                                   0   \n",
       "23                         ...                                  57   \n",
       "24                         ...                                  55   \n",
       "25                         ...                                  40   \n",
       "26                         ...                                  95   \n",
       "27                         ...                                 164   \n",
       "28                         ...                                  64   \n",
       "29                         ...                                  81   \n",
       "..                         ...                                 ...   \n",
       "575                        ...                                  38   \n",
       "576                        ...                                 245   \n",
       "577                        ...                                 119   \n",
       "578                        ...                                  97   \n",
       "579                        ...                                 149   \n",
       "580                        ...                                  99   \n",
       "581                        ...                                 101   \n",
       "582                        ...                                 101   \n",
       "583                        ...                                  10   \n",
       "584                        ...                                  95   \n",
       "585                        ...                                  79   \n",
       "586                        ...                                 106   \n",
       "587                        ...                                  73   \n",
       "588                        ...                                  51   \n",
       "589                        ...                                  55   \n",
       "590                        ...                                  76   \n",
       "591                        ...                                  64   \n",
       "592                        ...                                 142   \n",
       "593                        ...                                  21   \n",
       "594                        ...                                 100   \n",
       "595                        ...                                 140   \n",
       "596                        ...                                  95   \n",
       "597                        ...                                  59   \n",
       "598                        ...                                  90   \n",
       "599                        ...                                 139   \n",
       "600                        ...                                 113   \n",
       "601                        ...                                  25   \n",
       "602                        ...                                  38   \n",
       "603                        ...                                  99   \n",
       "604                        ...                                  93   \n",
       "\n",
       "     INCOME_50K  INCOME_60K  INCOME_75K  INCOME_ALL  INCOME_LES   Shape__Area  \\\n",
       "0           445         526         370        4148         243  1.724049e+06   \n",
       "1           280         263         178        2510         294  2.889814e+06   \n",
       "2           325         393         233        2953         240  1.785775e+06   \n",
       "3           288         145         310        2429         154  1.075471e+06   \n",
       "4           304         316         326        3157         335  1.318394e+06   \n",
       "5           301         404         395        3654         200  2.415333e+06   \n",
       "6            68         129         143        1048         101  1.554710e+06   \n",
       "7           142         193         265        2191         173  1.663333e+06   \n",
       "8           154         137         160        1408          64  1.956280e+06   \n",
       "9           206         209         239        1780          70  1.838454e+06   \n",
       "10           95         151         194        1314          80  3.374119e+06   \n",
       "11           47         145         128        1533          65  6.394057e+06   \n",
       "12           52          24          18         806          55  6.333392e+06   \n",
       "13           80         124         189        1189          43  3.885693e+06   \n",
       "14           89         120         171        1495          49  3.133490e+06   \n",
       "15          132         148         254        2199         154  7.265318e+06   \n",
       "16           40          61          94        1112          31  3.542382e+06   \n",
       "17           74         135         182        1685          84  1.284507e+07   \n",
       "18           26          82          72         859          34  3.392996e+06   \n",
       "19          260         459         432        3022         315  2.020695e+06   \n",
       "20          166         181         445        2847          35  7.921623e+06   \n",
       "21          104         218         259        2027         155  9.048742e+06   \n",
       "22           23          25          56         717          23  9.987781e+06   \n",
       "23          216         244         509        2247         151  3.546258e+06   \n",
       "24          172         179         302        2010          66  2.183874e+06   \n",
       "25           43          90         180         872          34  1.386796e+06   \n",
       "26          102         226         172        1559          70  6.335647e+06   \n",
       "27          206         255         198        2070         155  4.389532e+06   \n",
       "28          196         196         250        1638          81  5.786023e+06   \n",
       "29          144         251         260        1495         112  5.436744e+06   \n",
       "..          ...         ...         ...         ...         ...           ...   \n",
       "575          58          81         172         864          13  1.183300e+06   \n",
       "576         252         353         341        3119         240  2.142908e+06   \n",
       "577         191         236         149        2255         194  1.580955e+06   \n",
       "578         156         158          82        1758         185  9.795364e+05   \n",
       "579         291         247         312        3405         439  2.530105e+07   \n",
       "580         189         167         140        1864         102  4.079916e+06   \n",
       "581         131         173         125        1791          94  6.410247e+06   \n",
       "582         204         263         228        1931          51  2.467171e+08   \n",
       "583          47          32          64         516          27  5.396583e+07   \n",
       "584         155         251         213        2094         123  3.582940e+08   \n",
       "585         158         354         252        1875          88  8.999233e+07   \n",
       "586         247         186         362        2154          99  6.512923e+07   \n",
       "587         147         255         214        1979         121  1.032499e+08   \n",
       "588          66          58         112         758          26  1.717457e+08   \n",
       "589         122         146         114         991          53  5.456098e+06   \n",
       "590         141          93         175        1955         157  2.787910e+06   \n",
       "591         149         150         114        1334         121  2.070763e+06   \n",
       "592         271         194         356        2572         118  3.464590e+07   \n",
       "593          76         144         151         919          48  4.318942e+07   \n",
       "594         202         285         442        2074          38  5.026164e+06   \n",
       "595         259         433         463        3050         195  3.595653e+06   \n",
       "596         232         166         400        2077          84  1.212032e+07   \n",
       "597         164         190         272        1497          53  4.625056e+06   \n",
       "598          94         101          91         826          21  1.600955e+06   \n",
       "599         128         128          90        1176          39  1.573882e+06   \n",
       "600         109         247         201        1478          85  2.806946e+06   \n",
       "601          56          85          65         775          77  1.124992e+06   \n",
       "602         163          86          71        1335         111  1.122228e+06   \n",
       "603         139         162          81        1520          98  2.526340e+06   \n",
       "604         211         289         176        2175         152  5.028331e+06   \n",
       "\n",
       "     Shape__Length  TRACT                                              SHAPE  \n",
       "0      6919.424522   7700  {'rings': [[[-13051046.6746253, 3866695.333166...  \n",
       "1     11223.567885   7800  {'rings': [[[-13049196.649225, 3869830.7042951...  \n",
       "2      5749.634908   7901  {'rings': [[[-13051806.5792234, 3868598.509832...  \n",
       "3      4651.499315   7903  {'rings': [[[-13050375.5212048, 3868973.977334...  \n",
       "4      4961.527797   7904  {'rings': [[[-13050786.6266337, 3868042.625540...  \n",
       "5      7715.823845   8001  {'rings': [[[-13054490.4325811, 3870586.577816...  \n",
       "6      6048.096718   8002  {'rings': [[[-13050627.5009782, 3870107.420239...  \n",
       "7      5476.224492   8101  {'rings': [[[-13054685.3064826, 3872808.524061...  \n",
       "8      7842.229636   8102  {'rings': [[[-13055272.813358, 3871408.7886397...  \n",
       "9      6662.390637   8200  {'rings': [[[-13054984.3942046, 3874078.987216...  \n",
       "10     9184.803866   8301  {'rings': [[[-13051253.0713894, 3871205.926138...  \n",
       "11    11216.945555   8303  {'rings': [[[-13053352.1699691, 3873160.584997...  \n",
       "12    10690.986601   8305  {'rings': [[[-13050863.3957248, 3878300.666601...  \n",
       "13     8030.980054   8306  {'rings': [[[-13048823.4033755, 3874913.162689...  \n",
       "14     7807.047576   8307  {'rings': [[[-13047615.2935363, 3874885.452239...  \n",
       "15    14868.314100   8310  {'rings': [[[-13051182.3297173, 3871541.918906...  \n",
       "16    10063.516408   8311  {'rings': [[[-13054260.8210188, 3872983.109533...  \n",
       "17    28561.618793   8312  {'rings': [[[-13052867.6717771, 3875430.066969...  \n",
       "18    11181.722853   8313  {'rings': [[[-13051512.5514892, 3874954.005932...  \n",
       "19     7158.672579   8315  {'rings': [[[-13050682.508639, 3877033.6211176...  \n",
       "20    16142.228554   8324  {'rings': [[[-13053387.0672709, 3888281.990188...  \n",
       "21    13586.341474   8327  {'rings': [[[-13052561.1888173, 3892646.667145...  \n",
       "22    16549.055560   8328  {'rings': [[[-13048972.3929177, 3889477.213342...  \n",
       "23     8363.732309   8329  {'rings': [[[-13049863.8607747, 3889041.288344...  \n",
       "24     5724.244445   8330  {'rings': [[[-13048122.8159571, 3888625.190454...  \n",
       "25     4922.698757   8331  {'rings': [[[-13048544.8978956, 3888039.948292...  \n",
       "26    13558.591428  19602  {'rings': [[[-13048577.9139601, 3919892.552196...  \n",
       "27     9064.923364  19701  {'rings': [[[-13055105.3144289, 3919782.699823...  \n",
       "28    11817.855340  19702  {'rings': [[[-13052304.967358, 3919090.9721004...  \n",
       "29    10856.812385  19803  {'rings': [[[-13060096.020693, 3918104.8252378...  \n",
       "..             ...    ...                                                ...  \n",
       "575    4489.139456   7302  {'rings': [[[-13052170.2306954, 3859938.784224...  \n",
       "576    6685.816281   7400  {'rings': [[[-13051639.1183524, 3861076.222574...  \n",
       "577    6143.574777   7501  {'rings': [[[-13052516.6880596, 3862709.919096...  \n",
       "578    4756.038809   7502  {'rings': [[[-13051558.7172011, 3861187.577056...  \n",
       "579   27527.986138   7600  {'rings': [[[-13049325.694417, 3863176.5217676...  \n",
       "580   10789.426209  18905  {'rings': [[[-13053099.4576755, 3944665.420913...  \n",
       "581   13338.543854  18906  {'rings': [[[-13052187.1415777, 3943940.829139...  \n",
       "582  125461.005433  19001  {'rings': [[[-13049513.6109623, 3948347.310351...  \n",
       "583   42650.424427  19002  {'rings': [[[-13036112.4026521, 3952563.500473...  \n",
       "584  141602.532541  19101  {'rings': [[[-13027993.5990003, 3934184.569905...  \n",
       "585   60917.984388  19103  {'rings': [[[-13034772.0836383, 3929052.198000...  \n",
       "586   41899.419402  19105  {'rings': [[[-13029082.5555324, 3925571.374612...  \n",
       "587   52207.974139  19106  {'rings': [[[-13026993.5637122, 3930975.596354...  \n",
       "588   66582.882893  19107  {'rings': [[[-13005412.7581819, 3929352.534492...  \n",
       "589   10293.692470  19203  {'rings': [[[-13051359.9295364, 3927490.044136...  \n",
       "590    7622.915896  19205  {'rings': [[[-13049554.7052835, 3924950.002713...  \n",
       "591    6525.017242  19206  {'rings': [[[-13051645.7853143, 3923507.502663...  \n",
       "592   28891.410144  19207  {'rings': [[[-13047720.5121139, 3923492.540695...  \n",
       "593   37725.503259  19208  {'rings': [[[-13043900.5325018, 3924846.732163...  \n",
       "594   11830.205749  19301  {'rings': [[[-13056720.2788921, 3924816.373175...  \n",
       "595    9505.725497  19302  {'rings': [[[-13055467.7480167, 3925119.263405...  \n",
       "596   19162.843787  19303  {'rings': [[[-13052345.4125801, 3924694.464127...  \n",
       "597    9634.323841  19403  {'rings': [[[-13052757.5335329, 3922954.842143...  \n",
       "598    6124.998819  19404  {'rings': [[[-13052601.7705112, 3923488.058120...  \n",
       "599    6639.041801  19405  {'rings': [[[-13054854.7811202, 3921549.964804...  \n",
       "600    7392.782002  19406  {'rings': [[[-13052730.4914816, 3921273.833950...  \n",
       "601    5088.690205  19501  {'rings': [[[-13051533.6392657, 3922083.914222...  \n",
       "602    4167.173741  19502  {'rings': [[[-13050799.740359, 3923451.9523159...  \n",
       "603    8434.798843  19503  {'rings': [[[-13051642.3301841, 3921457.625820...  \n",
       "604   10703.585053  19601  {'rings': [[[-13047720.5121139, 3923492.540695...  \n",
       "\n",
       "[605 rows x 23 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Importing the spatial dataframe back into a layer, Accessing the content property of your gis object you can use the `import_data()` method."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "census_tract = gis.content.import_data(df, title='census_tract', tags='deeplearning')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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://deldev.maps.arcgis.com/home/item.html?id=681edf51f7b54dd98e85bf986cf47b21' target='_blank'>\n",
       "                        <img src='http://static.arcgis.com/images/desktopapp.png' class=\"itemThumbnail\">\n",
       "                       </a>\n",
       "                    </div>\n",
       "\n",
       "                    <div class=\"item_right\"     style=\"float: none; width: auto; overflow: hidden;\">\n",
       "                        <a href='https://deldev.maps.arcgis.com/home/item.html?id=681edf51f7b54dd98e85bf986cf47b21' target='_blank'><b>census_tract</b>\n",
       "                        </a>\n",
       "                        <br/><img src='https://deldev.maps.arcgis.com/home/js/jsapi/esri/css/images/item_type_icons/featureshosted16.png' style=\"vertical-align:middle;\">Feature Layer Collection by demos_deldev\n",
       "                        <br/>Last Modified: October 19, 2018\n",
       "                        <br/>0 comments, 0 views\n",
       "                    </div>\n",
       "                </div>\n",
       "                "
      ],
      "text/plain": [
       "<Item title:\"census_tract\" type:Feature Layer Collection owner:demos_deldev>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_tract"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "He then summarizes census tracts by community college districts to sum the number of low-income households in each district. If a tract falls in two or more districts, the value for that tract will be split proportionally between the districts (based on the area of the tract in each district)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "from arcgis.features.summarize_data import summarize_within"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "summary = summarize_within(dis_lyr, census_tract, summary_fields=[\"income_lt_ SUM\"],\n",
    "                 shape_units='SquareMiles', output_name='district_summary')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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://deldev.maps.arcgis.com/home/item.html?id=5752b123f206419290a9bee9b7420b94' target='_blank'>\n",
       "                        <img src='http://static.arcgis.com/images/desktopapp.png' class=\"itemThumbnail\">\n",
       "                       </a>\n",
       "                    </div>\n",
       "\n",
       "                    <div class=\"item_right\"     style=\"float: none; width: auto; overflow: hidden;\">\n",
       "                        <a href='https://deldev.maps.arcgis.com/home/item.html?id=5752b123f206419290a9bee9b7420b94' target='_blank'><b>district_summary</b>\n",
       "                        </a>\n",
       "                        <br/><img src='https://deldev.maps.arcgis.com/home/js/jsapi/esri/css/images/item_type_icons/featureshosted16.png' style=\"vertical-align:middle;\">Feature Layer Collection by demos_deldev\n",
       "                        <br/>Last Modified: October 19, 2018\n",
       "                        <br/>0 comments, 1 views\n",
       "                    </div>\n",
       "                </div>\n",
       "                "
      ],
      "text/plain": [
       "<Item title:\"district_summary\" type:Feature Layer Collection owner:demos_deldev>"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "summary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "428bdb3cdc044b3592aeacc42923ccab",
       "version_major": 2,
       "version_minor": 0
      },
      "text/html": [
       "<p>Failed to display Jupyter Widget of type <code>MapView</code>.</p>\n",
       "<p>\n",
       "  If you're reading this message in the Jupyter Notebook or JupyterLab Notebook, it may mean\n",
       "  that the widgets JavaScript is still loading. If this message persists, it\n",
       "  likely means that the widgets JavaScript library is either not installed or\n",
       "  not enabled. See the <a href=\"https://ipywidgets.readthedocs.io/en/stable/user_install.html\">Jupyter\n",
       "  Widgets Documentation</a> for setup instructions.\n",
       "</p>\n",
       "<p>\n",
       "  If you're reading this message in another frontend (for example, a static\n",
       "  rendering on GitHub or <a href=\"https://nbviewer.jupyter.org/\">NBViewer</a>),\n",
       "  it may mean that your frontend doesn't currently support widgets.\n",
       "</p>\n"
      ],
      "text/plain": [
       "MapView(basemaps=['dark-gray', 'dark-gray-vector', 'gray', 'gray-vector', 'hybrid', 'national-geographic', 'oceans', 'osm', 'satellite', 'streets', 'streets-navigation-vector', 'streets-night-vector', 'streets-relief-vector', 'streets-vector', 'terrain', 'topo', 'topo-vector'], center=[0, 0])"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "m1 = gis.map('San Diego')\n",
    "m1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](low_inc_img/1.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The map displays the census tracts color-coded by the number of households in each census tract with income less than $30,000 per year."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "m1.add_layer(summary)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "summ_lyr = summary.layers[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "sdf2 = SpatialDataFrame.from_layer(summ_lyr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "sdf2.sort_values(['SUM_income_lt_'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>AnalysisArea</th>\n",
       "      <th>DISTRICT</th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>OBJECTID_1</th>\n",
       "      <th>SUM_Area_SquareMiles</th>\n",
       "      <th>SUM_income_lt_</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>Shape__Area</th>\n",
       "      <th>Shape__Length</th>\n",
       "      <th>SHAPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>180.057307</td>\n",
       "      <td>MIRA COSTA COMMUNITY COLLEGE</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>179.904967</td>\n",
       "      <td>28288</td>\n",
       "      <td>5.292542e+05</td>\n",
       "      <td>6.666802e+08</td>\n",
       "      <td>193041.705158</td>\n",
       "      <td>{'rings': [[[-13069560.2323, 3941041.6565], [-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>171.343530</td>\n",
       "      <td>SOUTHWESTERN COMMUNITY COLLEGE</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>171.085801</td>\n",
       "      <td>40861</td>\n",
       "      <td>4.845452e+05</td>\n",
       "      <td>6.272847e+08</td>\n",
       "      <td>175596.854611</td>\n",
       "      <td>{'rings': [[[-13045570.4191, 3857253.9374], [-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1137.329793</td>\n",
       "      <td>GROSSMONT-CUYAMACA COMMUNITY COLLEGE</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1137.093733</td>\n",
       "      <td>48777</td>\n",
       "      <td>9.623860e+05</td>\n",
       "      <td>4.176966e+09</td>\n",
       "      <td>349055.694465</td>\n",
       "      <td>{'rings': [[[-13000869.2404, 3890488.4302], [-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2554.787820</td>\n",
       "      <td>PALOMAR COMMUNITY COLLEGE</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2554.695554</td>\n",
       "      <td>56549</td>\n",
       "      <td>1.538205e+06</td>\n",
       "      <td>9.475183e+09</td>\n",
       "      <td>560765.010295</td>\n",
       "      <td>{'rings': [[[-13078663.7712, 3962536.5573], [-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>217.585900</td>\n",
       "      <td>SAN DIEGO COMMUNITY COLLEGE</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>217.566586</td>\n",
       "      <td>127843</td>\n",
       "      <td>6.086365e+05</td>\n",
       "      <td>7.999274e+08</td>\n",
       "      <td>221005.474787</td>\n",
       "      <td>{'rings': [[[-13039483.6168, 3888486.6244], [-...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   AnalysisArea                              DISTRICT  OBJECTID  OBJECTID_1  \\\n",
       "1    180.057307          MIRA COSTA COMMUNITY COLLEGE         3           2   \n",
       "0    171.343530        SOUTHWESTERN COMMUNITY COLLEGE         5           1   \n",
       "3   1137.329793  GROSSMONT-CUYAMACA COMMUNITY COLLEGE         1           4   \n",
       "4   2554.787820             PALOMAR COMMUNITY COLLEGE         2           5   \n",
       "2    217.585900           SAN DIEGO COMMUNITY COLLEGE         4           3   \n",
       "\n",
       "   SUM_Area_SquareMiles  SUM_income_lt_    Shape_Leng   Shape__Area  \\\n",
       "1            179.904967           28288  5.292542e+05  6.666802e+08   \n",
       "0            171.085801           40861  4.845452e+05  6.272847e+08   \n",
       "3           1137.093733           48777  9.623860e+05  4.176966e+09   \n",
       "4           2554.695554           56549  1.538205e+06  9.475183e+09   \n",
       "2            217.566586          127843  6.086365e+05  7.999274e+08   \n",
       "\n",
       "   Shape__Length                                              SHAPE  \n",
       "1  193041.705158  {'rings': [[[-13069560.2323, 3941041.6565], [-...  \n",
       "0  175596.854611  {'rings': [[[-13045570.4191, 3857253.9374], [-...  \n",
       "3  349055.694465  {'rings': [[[-13000869.2404, 3890488.4302], [-...  \n",
       "4  560765.010295  {'rings': [[[-13078663.7712, 3962536.5573], [-...  \n",
       "2  221005.474787  {'rings': [[[-13039483.6168, 3888486.6244], [-...  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sdf2.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This shows that one of the community college districts has by far the fewest households with income less than $30,000—this district will be used for the cable provider's pilot program. The values were calculated by summing the values for the tracts within each community college district."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Visualization to show district with fewest households"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "82904973d38a47edaf3b681cd6d39049",
       "version_major": 2,
       "version_minor": 0
      },
      "text/html": [
       "<p>Failed to display Jupyter Widget of type <code>MapView</code>.</p>\n",
       "<p>\n",
       "  If you're reading this message in the Jupyter Notebook or JupyterLab Notebook, it may mean\n",
       "  that the widgets JavaScript is still loading. If this message persists, it\n",
       "  likely means that the widgets JavaScript library is either not installed or\n",
       "  not enabled. See the <a href=\"https://ipywidgets.readthedocs.io/en/stable/user_install.html\">Jupyter\n",
       "  Widgets Documentation</a> for setup instructions.\n",
       "</p>\n",
       "<p>\n",
       "  If you're reading this message in another frontend (for example, a static\n",
       "  rendering on GitHub or <a href=\"https://nbviewer.jupyter.org/\">NBViewer</a>),\n",
       "  it may mean that your frontend doesn't currently support widgets.\n",
       "</p>\n"
      ],
      "text/plain": [
       "MapView(basemaps=['dark-gray', 'dark-gray-vector', 'gray', 'gray-vector', 'hybrid', 'national-geographic', 'oceans', 'osm', 'satellite', 'streets', 'streets-navigation-vector', 'streets-night-vector', 'streets-relief-vector', 'streets-vector', 'terrain', 'topo', 'topo-vector'], center=[0, 0])"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "m2 = gis.map('San Diego')\n",
    "m2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](low_inc_img/3.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "m2.add_layer(summary, {\"renderer\":\"ClassedSizeRenderer\", \"field_name\": \"SUM_income_lt_\"})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It's clear that the Mira Costa district has by far the fewest low-income households. That's where the pilot program will be set up."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}