{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Setup supporting packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from arcgis.gis import GIS\n",
    "from arcgis.features import FeatureLayer\n",
    "from arcgis.geocoding import geocode\n",
    "\n",
    "import requests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## HUC12 of interest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#huc12 = '051302030106' # Tennessee\n",
    "huc12 = '010900010704'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Query ArcGIS based watershed web service"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>AREAACRES</th>\n",
       "      <th>AREASQKM</th>\n",
       "      <th>GNIS_ID</th>\n",
       "      <th>HUC12</th>\n",
       "      <th>HUMOD</th>\n",
       "      <th>HUTYPE</th>\n",
       "      <th>LOADDATE</th>\n",
       "      <th>METASOURCEID</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NONCONTRIBUTINGAREAACRES</th>\n",
       "      <th>...</th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>SHAPE</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "      <th>SHAPE_Length</th>\n",
       "      <th>SOURCEDATADESC</th>\n",
       "      <th>SOURCEFEATUREID</th>\n",
       "      <th>SOURCEORIGINATOR</th>\n",
       "      <th>STATES</th>\n",
       "      <th>TNMID</th>\n",
       "      <th>TOHUC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>36639.444604</td>\n",
       "      <td>148.274556</td>\n",
       "      <td>None</td>\n",
       "      <td>010900010704</td>\n",
       "      <td>PD</td>\n",
       "      <td>F</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>Charles River-Frontal Boston Harbor</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>79751</td>\n",
       "      <td>{\"rings\": [[[-71.25066850628518, 42.3499071889...</td>\n",
       "      <td>2.714994e+08</td>\n",
       "      <td>153951.448827</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>MA</td>\n",
       "      <td>-334536</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      AREAACRES    AREASQKM GNIS_ID         HUC12 HUMOD HUTYPE LOADDATE  \\\n",
       "0  36639.444604  148.274556    None  010900010704    PD      F      NaT   \n",
       "\n",
       "  METASOURCEID                                 NAME  NONCONTRIBUTINGAREAACRES  \\\n",
       "0         None  Charles River-Frontal Boston Harbor                         0   \n",
       "\n",
       "   ...  OBJECTID                                              SHAPE  \\\n",
       "0  ...     79751  {\"rings\": [[[-71.25066850628518, 42.3499071889...   \n",
       "\n",
       "     SHAPE_Area   SHAPE_Length  SOURCEDATADESC SOURCEFEATUREID  \\\n",
       "0  2.714994e+08  153951.448827            None            None   \n",
       "\n",
       "  SOURCEORIGINATOR STATES    TNMID TOHUC  \n",
       "0             None     MA  -334536  None  \n",
       "\n",
       "[1 rows x 21 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "huc_result = None\n",
    "\n",
    "lyr_url = 'https://watersgeo.epa.gov/arcgis/rest/services/Support/HydrologicUnits/MapServer/6'\n",
    "huc12_conus = FeatureLayer(lyr_url)\n",
    "\n",
    "huc_result = huc12_conus.query(where=\"HUC12='\" + huc12 + \"'\", \n",
    "                                    out_fields='*',out_sr=4326)\n",
    "huc_result.sdf"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Display watershed result on map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "328914c386464df4a879d7395840d406",
       "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 Jupyter Notebook or JupyterLab, 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 notebook 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(layout=Layout(height='400px', width='100%'))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div class=\"map-static-img-preview-743cb9a1-5faf-4905-82b9-c0f318be5416\"><img src=\"\"></img></div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "gis = GIS()\n",
    "map1 = gis.map()\n",
    "map1.basemap = \"gray\"\n",
    "map1.height = '650px'\n",
    "map1.clear_graphics()\n",
    "\n",
    "huc_symbol = {\n",
    "  \"type\": \"esriSFS\",\n",
    "  \"color\": [230, 76, 0, 50],\n",
    "  \"outline\": {\n",
    "    \"type\": \"esriSLS\",\n",
    "    \"color\": [0, 0, 0, 255],\n",
    "    \"width\": 0.75,\n",
    "    \"style\": \"esriSLSSolid\"\n",
    "  },\n",
    "  \"style\": \"esriSFSSolid\"\n",
    "}\n",
    "\n",
    "map1.draw(huc_result,symbol=huc_symbol)\n",
    "\n",
    "map1.extent = huc_result.sdf.spatial.full_extent\n",
    "\n",
    "map1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve ATTAINS assessment LINES from ATTAINS ArcGIS based web service (this is NOT the approach as it does not conform to the NHDPlus WBD to Catchment crosswalk)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>algal_growth</th>\n",
       "      <th>ammonia</th>\n",
       "      <th>assessmentunitidentifier</th>\n",
       "      <th>assessmentunitname</th>\n",
       "      <th>biotoxins</th>\n",
       "      <th>cause_unknown</th>\n",
       "      <th>cause_unknown_fish_kills</th>\n",
       "      <th>cause_unknown_impaired_biota</th>\n",
       "      <th>chlorine</th>\n",
       "      <th>...</th>\n",
       "      <th>state</th>\n",
       "      <th>submissionid</th>\n",
       "      <th>taste_color_and_odor</th>\n",
       "      <th>temperature</th>\n",
       "      <th>total_toxics</th>\n",
       "      <th>toxic_inorganics</th>\n",
       "      <th>toxic_organics</th>\n",
       "      <th>trash</th>\n",
       "      <th>turbidity</th>\n",
       "      <th>visionpriority303d</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MT1-L0135</td>\n",
       "      <td>PRAIRIE VIEW LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LB1-L0020</td>\n",
       "      <td>CRYSTAL SPRINGS NORTHWEST LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-BB3-L0050</td>\n",
       "      <td>LAKE HASTINGS</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MT1-L0023</td>\n",
       "      <td>HALLECK PARK (PAPILLION)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-BB1-10000</td>\n",
       "      <td>BIG BLUE RIVER</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-NE2-L0195</td>\n",
       "      <td>MAYBERRY LAKE (WMA)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-RE1-L0040</td>\n",
       "      <td>HOLDREGE PARK LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MT1-10250</td>\n",
       "      <td>WEST PAPILLION CREEK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MT2-L0060</td>\n",
       "      <td>PLAINVIEW COUNTRY CLUB LAKE</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-BB1-L0040</td>\n",
       "      <td>ARROWHEAD LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LP1-L0060</td>\n",
       "      <td>JERRY NEWMAN LAKE (PLATTE RIVER STATE PARK)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-SP1-L0070</td>\n",
       "      <td>EAST SUTHERLAND LAKE (WMA)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-WH1-11820</td>\n",
       "      <td>WEST ASH CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LO1-L0130</td>\n",
       "      <td>PIBEL LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MT2-12500</td>\n",
       "      <td>BAZILE CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MT2-10100</td>\n",
       "      <td>ELK CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-RE1-10200</td>\n",
       "      <td>LOST CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-WH1-11300</td>\n",
       "      <td>CHADRON CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-RE3-L0060</td>\n",
       "      <td>HUGH BUTLER LAKE (RED WILLOW RESERVOIR)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-NI3-L0070</td>\n",
       "      <td>CUB CREEK LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-EL1-21000</td>\n",
       "      <td>ROCK CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LO4-L0010</td>\n",
       "      <td>RAVENNA LAKE (SRA)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MP2-20400</td>\n",
       "      <td>PLUM CREEK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-MP2-L0430</td>\n",
       "      <td>BLUE HOLE LAKE (ELM CREEK)(WMA)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>NE-LP2-L0260</td>\n",
       "      <td>WEST TWIN LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LB2-10100</td>\n",
       "      <td>BIG SANDY CREEK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-NE2-12330</td>\n",
       "      <td>LONG BRANCH CREEK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LP2-L0060</td>\n",
       "      <td>OAK LAKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-LO4-10100</td>\n",
       "      <td>MUD CREEK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NE-BB1-L0100</td>\n",
       "      <td>WALNUT CREEK LAKE (2A)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NE</td>\n",
       "      <td>{c92ee4b6-0fb4-a64a-556c-e98040793b15}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</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>256913</th>\n",
       "      <td>257081</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0133</td>\n",
       "      <td>Rockwood Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256914</th>\n",
       "      <td>257082</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0134</td>\n",
       "      <td>Sprite Creek, Lower, and tribs</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256915</th>\n",
       "      <td>257083</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0135</td>\n",
       "      <td>Sprite Creek, Upper, and tribs</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256916</th>\n",
       "      <td>257084</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0136</td>\n",
       "      <td>Mud Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256917</th>\n",
       "      <td>257085</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0137</td>\n",
       "      <td>Peck Creek and tribs</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256918</th>\n",
       "      <td>257086</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0138</td>\n",
       "      <td>Tribs to Peck Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256919</th>\n",
       "      <td>257087</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0139</td>\n",
       "      <td>Vandenburg Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256920</th>\n",
       "      <td>257088</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0140</td>\n",
       "      <td>Woodworth Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256921</th>\n",
       "      <td>257089</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0141</td>\n",
       "      <td>Hinds Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256922</th>\n",
       "      <td>257090</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1201-0142</td>\n",
       "      <td>Mountain Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256923</th>\n",
       "      <td>257091</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0140</td>\n",
       "      <td>Wallace Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256924</th>\n",
       "      <td>257092</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0141</td>\n",
       "      <td>Canopus Creek and tribs</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256925</th>\n",
       "      <td>257093</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0142</td>\n",
       "      <td>Lake Celeste</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256926</th>\n",
       "      <td>257094</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0143</td>\n",
       "      <td>Indian Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256927</th>\n",
       "      <td>257095</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0144</td>\n",
       "      <td>Cortlandt Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256928</th>\n",
       "      <td>257096</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0145</td>\n",
       "      <td>Canopus Lake, Pelton Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256929</th>\n",
       "      <td>257097</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0146</td>\n",
       "      <td>Gregory Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256930</th>\n",
       "      <td>257098</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0147</td>\n",
       "      <td>Lake Peekskill</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256931</th>\n",
       "      <td>257099</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0148</td>\n",
       "      <td>Mud Lake, Clear Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256932</th>\n",
       "      <td>257100</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0149</td>\n",
       "      <td>Lake Mohegan</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256933</th>\n",
       "      <td>257101</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0150</td>\n",
       "      <td>Oceola Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256934</th>\n",
       "      <td>257102</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0151</td>\n",
       "      <td>Bryant Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256935</th>\n",
       "      <td>257103</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0152</td>\n",
       "      <td>Wiccopee Brook and tribs</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256936</th>\n",
       "      <td>257104</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0153</td>\n",
       "      <td>Wiccopee Reservoir</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256937</th>\n",
       "      <td>257105</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0154</td>\n",
       "      <td>Tribs to Wiccopee Reservoir</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256938</th>\n",
       "      <td>257106</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0155</td>\n",
       "      <td>Stillwater Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256939</th>\n",
       "      <td>257107</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0156</td>\n",
       "      <td>Lake Ossi</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256940</th>\n",
       "      <td>257108</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0157</td>\n",
       "      <td>Dickiebusch Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256941</th>\n",
       "      <td>257109</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0158</td>\n",
       "      <td>Brocey Pond</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256942</th>\n",
       "      <td>257110</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY1301-0159</td>\n",
       "      <td>Hessian Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NY</td>\n",
       "      <td>{f894344e-7181-d1d6-9526-fe1ebb3b9b12}</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>256943 rows × 57 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        OBJECTID algal_growth ammonia assessmentunitidentifier  \\\n",
       "0              1         None    None             NE-MT1-L0135   \n",
       "1              2         None    None             NE-LB1-L0020   \n",
       "2              3         None    None             NE-BB3-L0050   \n",
       "3              4         None    None             NE-MT1-L0023   \n",
       "4              5         None    None             NE-BB1-10000   \n",
       "5              6         None    None             NE-NE2-L0195   \n",
       "6              7         None    None             NE-RE1-L0040   \n",
       "7              8         None    None             NE-MT1-10250   \n",
       "8              9         None    None             NE-MT2-L0060   \n",
       "9             10         None    None             NE-BB1-L0040   \n",
       "10            11         None    None             NE-LP1-L0060   \n",
       "11            12         None    None             NE-SP1-L0070   \n",
       "12            13         None    None             NE-WH1-11820   \n",
       "13            14         None    None             NE-LO1-L0130   \n",
       "14            15         None    None             NE-MT2-12500   \n",
       "15            16         None    None             NE-MT2-10100   \n",
       "16            17         None    None             NE-RE1-10200   \n",
       "17            18         None    None             NE-WH1-11300   \n",
       "18            19         None    None             NE-RE3-L0060   \n",
       "19            20         None    None             NE-NI3-L0070   \n",
       "20            21         None    None             NE-EL1-21000   \n",
       "21            22         None    None             NE-LO4-L0010   \n",
       "22            23         None    None             NE-MP2-20400   \n",
       "23            24         None    None             NE-MP2-L0430   \n",
       "24            25         None   Cause             NE-LP2-L0260   \n",
       "25            26         None    None             NE-LB2-10100   \n",
       "26            27         None    None             NE-NE2-12330   \n",
       "27            28         None    None             NE-LP2-L0060   \n",
       "28            29         None    None             NE-LO4-10100   \n",
       "29            30         None    None             NE-BB1-L0100   \n",
       "...          ...          ...     ...                      ...   \n",
       "256913    257081         None    None              NY1201-0133   \n",
       "256914    257082         None    None              NY1201-0134   \n",
       "256915    257083         None    None              NY1201-0135   \n",
       "256916    257084         None    None              NY1201-0136   \n",
       "256917    257085         None    None              NY1201-0137   \n",
       "256918    257086         None    None              NY1201-0138   \n",
       "256919    257087         None    None              NY1201-0139   \n",
       "256920    257088         None    None              NY1201-0140   \n",
       "256921    257089         None    None              NY1201-0141   \n",
       "256922    257090         None    None              NY1201-0142   \n",
       "256923    257091        Cause    None              NY1301-0140   \n",
       "256924    257092         None    None              NY1301-0141   \n",
       "256925    257093         None    None              NY1301-0142   \n",
       "256926    257094         None    None              NY1301-0143   \n",
       "256927    257095         None    None              NY1301-0144   \n",
       "256928    257096         None    None              NY1301-0145   \n",
       "256929    257097         None    None              NY1301-0146   \n",
       "256930    257098         None    None              NY1301-0147   \n",
       "256931    257099         None    None              NY1301-0148   \n",
       "256932    257100        Cause    None              NY1301-0149   \n",
       "256933    257101         None    None              NY1301-0150   \n",
       "256934    257102         None    None              NY1301-0151   \n",
       "256935    257103         None    None              NY1301-0152   \n",
       "256936    257104         None    None              NY1301-0153   \n",
       "256937    257105         None    None              NY1301-0154   \n",
       "256938    257106         None    None              NY1301-0155   \n",
       "256939    257107         None    None              NY1301-0156   \n",
       "256940    257108         None    None              NY1301-0157   \n",
       "256941    257109         None    None              NY1301-0158   \n",
       "256942    257110         None    None              NY1301-0159   \n",
       "\n",
       "                                 assessmentunitname biotoxins cause_unknown  \\\n",
       "0                                 PRAIRIE VIEW LAKE      None          None   \n",
       "1                    CRYSTAL SPRINGS NORTHWEST LAKE      None          None   \n",
       "2                                     LAKE HASTINGS      None          None   \n",
       "3                          HALLECK PARK (PAPILLION)      None          None   \n",
       "4                                    BIG BLUE RIVER      None          None   \n",
       "5                               MAYBERRY LAKE (WMA)      None          None   \n",
       "6                                HOLDREGE PARK LAKE      None          None   \n",
       "7                              WEST PAPILLION CREEK      None          None   \n",
       "8                       PLAINVIEW COUNTRY CLUB LAKE     Cause          None   \n",
       "9                                    ARROWHEAD LAKE      None          None   \n",
       "10      JERRY NEWMAN LAKE (PLATTE RIVER STATE PARK)      None          None   \n",
       "11                       EAST SUTHERLAND LAKE (WMA)      None          None   \n",
       "12                                   WEST ASH CREEK     Cause          None   \n",
       "13                                       PIBEL LAKE      None          None   \n",
       "14                                     BAZILE CREEK     Cause          None   \n",
       "15                                        ELK CREEK     Cause          None   \n",
       "16                                       LOST CREEK     Cause          None   \n",
       "17                                    CHADRON CREEK     Cause          None   \n",
       "18          HUGH BUTLER LAKE (RED WILLOW RESERVOIR)      None          None   \n",
       "19                                   CUB CREEK LAKE      None          None   \n",
       "20                                       ROCK CREEK     Cause          None   \n",
       "21                               RAVENNA LAKE (SRA)      None          None   \n",
       "22                                       PLUM CREEK      None          None   \n",
       "23                  BLUE HOLE LAKE (ELM CREEK)(WMA)      None          None   \n",
       "24                                   WEST TWIN LAKE      None          None   \n",
       "25                                  BIG SANDY CREEK      None          None   \n",
       "26                                LONG BRANCH CREEK      None          None   \n",
       "27                                         OAK LAKE      None          None   \n",
       "28                                        MUD CREEK      None          None   \n",
       "29                           WALNUT CREEK LAKE (2A)      None          None   \n",
       "...                                             ...       ...           ...   \n",
       "256913                                Rockwood Lake      None          None   \n",
       "256914               Sprite Creek, Lower, and tribs      None          None   \n",
       "256915               Sprite Creek, Upper, and tribs      None          None   \n",
       "256916                                     Mud Lake      None          None   \n",
       "256917                         Peck Creek and tribs      None          None   \n",
       "256918                           Tribs to Peck Lake      None          None   \n",
       "256919                              Vandenburg Pond      None          None   \n",
       "256920                               Woodworth Lake      None          None   \n",
       "256921                                   Hinds Pond      None          None   \n",
       "256922                                Mountain Lake      None          None   \n",
       "256923                                 Wallace Pond      None          None   \n",
       "256924                      Canopus Creek and tribs      None          None   \n",
       "256925                                 Lake Celeste      None          None   \n",
       "256926                                  Indian Lake      None          None   \n",
       "256927                               Cortlandt Lake      None          None   \n",
       "256928                    Canopus Lake, Pelton Lake      None          None   \n",
       "256929                                 Gregory Pond      None          None   \n",
       "256930                               Lake Peekskill      None          None   \n",
       "256931                         Mud Lake, Clear Lake      None          None   \n",
       "256932                                 Lake Mohegan      None          None   \n",
       "256933                                  Oceola Lake      None          None   \n",
       "256934                                  Bryant Pond      None          None   \n",
       "256935                     Wiccopee Brook and tribs      None          None   \n",
       "256936                           Wiccopee Reservoir      None          None   \n",
       "256937                  Tribs to Wiccopee Reservoir      None          None   \n",
       "256938                              Stillwater Pond      None          None   \n",
       "256939                                    Lake Ossi      None          None   \n",
       "256940                             Dickiebusch Lake      None          None   \n",
       "256941                                  Brocey Pond      None          None   \n",
       "256942                                 Hessian Lake      None          None   \n",
       "\n",
       "       cause_unknown_fish_kills cause_unknown_impaired_biota chlorine  ...  \\\n",
       "0                          None                         None     None  ...   \n",
       "1                          None                         None     None  ...   \n",
       "2                          None                         None     None  ...   \n",
       "3                          None                         None     None  ...   \n",
       "4                          None                         None     None  ...   \n",
       "5                          None                         None     None  ...   \n",
       "6                          None                         None     None  ...   \n",
       "7                          None                         None     None  ...   \n",
       "8                          None                         None     None  ...   \n",
       "9                          None                         None     None  ...   \n",
       "10                         None                         None     None  ...   \n",
       "11                         None                         None     None  ...   \n",
       "12                         None                         None     None  ...   \n",
       "13                         None                         None     None  ...   \n",
       "14                         None                         None     None  ...   \n",
       "15                         None                         None     None  ...   \n",
       "16                         None                         None     None  ...   \n",
       "17                         None                         None     None  ...   \n",
       "18                         None                         None     None  ...   \n",
       "19                         None                         None     None  ...   \n",
       "20                         None                        Cause     None  ...   \n",
       "21                         None                         None     None  ...   \n",
       "22                         None                        Cause     None  ...   \n",
       "23                         None                         None     None  ...   \n",
       "24                         None                         None     None  ...   \n",
       "25                         None                         None     None  ...   \n",
       "26                         None                        Cause     None  ...   \n",
       "27                         None                         None     None  ...   \n",
       "28                         None                        Cause     None  ...   \n",
       "29                         None                         None     None  ...   \n",
       "...                         ...                          ...      ...  ...   \n",
       "256913                     None                         None     None  ...   \n",
       "256914                     None                         None     None  ...   \n",
       "256915                     None                         None     None  ...   \n",
       "256916                     None                         None     None  ...   \n",
       "256917                     None                         None     None  ...   \n",
       "256918                     None                         None     None  ...   \n",
       "256919                     None                         None     None  ...   \n",
       "256920                     None                         None     None  ...   \n",
       "256921                     None                         None     None  ...   \n",
       "256922                     None                         None     None  ...   \n",
       "256923                     None                         None     None  ...   \n",
       "256924                     None                         None     None  ...   \n",
       "256925                     None                         None     None  ...   \n",
       "256926                     None                         None     None  ...   \n",
       "256927                     None                         None     None  ...   \n",
       "256928                     None                         None     None  ...   \n",
       "256929                     None                         None     None  ...   \n",
       "256930                     None                         None     None  ...   \n",
       "256931                     None                         None     None  ...   \n",
       "256932                     None                         None     None  ...   \n",
       "256933                     None                         None     None  ...   \n",
       "256934                     None                         None     None  ...   \n",
       "256935                     None                         None     None  ...   \n",
       "256936                     None                         None     None  ...   \n",
       "256937                     None                         None     None  ...   \n",
       "256938                     None                         None     None  ...   \n",
       "256939                     None                         None     None  ...   \n",
       "256940                     None                         None     None  ...   \n",
       "256941                     None                         None     None  ...   \n",
       "256942                     None                         None     None  ...   \n",
       "\n",
       "       state                            submissionid taste_color_and_odor  \\\n",
       "0         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "1         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "2         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "3         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "4         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "5         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "6         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "7         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "8         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "9         NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "10        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "11        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "12        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "13        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "14        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "15        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "16        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "17        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "18        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "19        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "20        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "21        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "22        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "23        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "24        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "25        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "26        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "27        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "28        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "29        NE  {c92ee4b6-0fb4-a64a-556c-e98040793b15}                 None   \n",
       "...      ...                                     ...                  ...   \n",
       "256913    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256914    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256915    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256916    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256917    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256918    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256919    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256920    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256921    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256922    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256923    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256924    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256925    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256926    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256927    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256928    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256929    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256930    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256931    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256932    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256933    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256934    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256935    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256936    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256937    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256938    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256939    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256940    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256941    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "256942    NY  {f894344e-7181-d1d6-9526-fe1ebb3b9b12}                 None   \n",
       "\n",
       "       temperature total_toxics toxic_inorganics toxic_organics trash  \\\n",
       "0             None         None             None           None  None   \n",
       "1             None         None             None           None  None   \n",
       "2             None         None             None           None  None   \n",
       "3             None         None             None           None  None   \n",
       "4             None         None             None           None  None   \n",
       "5             None         None             None           None  None   \n",
       "6             None         None             None           None  None   \n",
       "7             None         None             None           None  None   \n",
       "8             None         None             None           None  None   \n",
       "9             None         None             None           None  None   \n",
       "10            None         None             None           None  None   \n",
       "11            None         None             None           None  None   \n",
       "12            None         None             None           None  None   \n",
       "13            None         None             None           None  None   \n",
       "14            None         None             None           None  None   \n",
       "15            None         None             None           None  None   \n",
       "16            None         None             None           None  None   \n",
       "17            None         None             None           None  None   \n",
       "18            None         None             None           None  None   \n",
       "19            None         None             None           None  None   \n",
       "20            None         None             None           None  None   \n",
       "21            None         None             None           None  None   \n",
       "22            None         None             None           None  None   \n",
       "23            None         None             None           None  None   \n",
       "24            None         None             None           None  None   \n",
       "25            None         None             None           None  None   \n",
       "26            None         None             None           None  None   \n",
       "27            None         None             None           None  None   \n",
       "28            None         None             None           None  None   \n",
       "29            None         None             None           None  None   \n",
       "...            ...          ...              ...            ...   ...   \n",
       "256913        None         None             None           None  None   \n",
       "256914        None         None             None           None  None   \n",
       "256915        None         None             None           None  None   \n",
       "256916        None         None             None           None  None   \n",
       "256917        None         None             None           None  None   \n",
       "256918        None         None             None           None  None   \n",
       "256919        None         None             None           None  None   \n",
       "256920        None         None             None           None  None   \n",
       "256921        None         None             None           None  None   \n",
       "256922        None         None             None           None  None   \n",
       "256923        None         None             None           None  None   \n",
       "256924        None         None             None           None  None   \n",
       "256925        None         None             None           None  None   \n",
       "256926        None         None             None           None  None   \n",
       "256927        None         None             None           None  None   \n",
       "256928        None         None             None           None  None   \n",
       "256929        None         None             None           None  None   \n",
       "256930        None         None             None           None  None   \n",
       "256931        None         None             None           None  None   \n",
       "256932        None         None             None           None  None   \n",
       "256933        None         None             None           None  None   \n",
       "256934        None         None             None           None  None   \n",
       "256935        None         None             None           None  None   \n",
       "256936        None         None             None           None  None   \n",
       "256937        None         None             None           None  None   \n",
       "256938        None         None             None           None  None   \n",
       "256939        None         None             None           None  None   \n",
       "256940        None         None             None           None  None   \n",
       "256941        None         None             None           None  None   \n",
       "256942        None         None             None           None  None   \n",
       "\n",
       "       turbidity visionpriority303d  \n",
       "0           None                  N  \n",
       "1           None                  N  \n",
       "2           None                  N  \n",
       "3           None                  N  \n",
       "4           None                  N  \n",
       "5           None                  N  \n",
       "6           None                  N  \n",
       "7           None                  N  \n",
       "8           None                  N  \n",
       "9           None                  N  \n",
       "10          None                  N  \n",
       "11          None                  N  \n",
       "12          None                  Y  \n",
       "13          None                  N  \n",
       "14          None                  Y  \n",
       "15          None                  Y  \n",
       "16          None                  Y  \n",
       "17          None                  Y  \n",
       "18          None                  N  \n",
       "19          None                  N  \n",
       "20          None                  Y  \n",
       "21          None                  N  \n",
       "22          None                  N  \n",
       "23          None                  N  \n",
       "24          None                  N  \n",
       "25          None                  Y  \n",
       "26          None                  N  \n",
       "27          None                  N  \n",
       "28          None                  N  \n",
       "29          None                  N  \n",
       "...          ...                ...  \n",
       "256913      None                  N  \n",
       "256914      None                  N  \n",
       "256915      None                  N  \n",
       "256916      None                  N  \n",
       "256917      None                  N  \n",
       "256918      None                  N  \n",
       "256919      None                  N  \n",
       "256920      None                  N  \n",
       "256921      None                  N  \n",
       "256922      None                  N  \n",
       "256923      None                  N  \n",
       "256924      None                  N  \n",
       "256925      None                  N  \n",
       "256926      None                  N  \n",
       "256927      None                  N  \n",
       "256928      None                  N  \n",
       "256929      None                  N  \n",
       "256930      None                  N  \n",
       "256931      None                  N  \n",
       "256932      None                  N  \n",
       "256933      None                  N  \n",
       "256934      None                  N  \n",
       "256935      None                  N  \n",
       "256936      None                  N  \n",
       "256937      None                  N  \n",
       "256938      None                  N  \n",
       "256939      None                  N  \n",
       "256940      None                  N  \n",
       "256941      None                  N  \n",
       "256942      None                  N  \n",
       "\n",
       "[256943 rows x 57 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from arcgis.geometry import filters\n",
    "\n",
    "attains_lines_result = None\n",
    "\n",
    "lines_lyr_url = 'https://gispub.epa.gov/arcgis/rest/services/OW/ATTAINS_Assessment/MapServer/1'\n",
    "attains_lines_featurelayer = FeatureLayer(lines_lyr_url)\n",
    "attains_lines_result = attains_lines_featurelayer.query(out_fields='*', out_sr=4326,\n",
    "                                                 geometry_filter=filters.intersects(huc_result.features[0].geometry))\n",
    "\n",
    "attains_lines_result.sdf"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Show assessments from direct spatial query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "c8d0302f70e34ca5ad54b9ba1a7fb4ff",
       "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 Jupyter Notebook or JupyterLab, 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 notebook 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(layout=Layout(height='400px', width='100%'))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div class=\"map-static-img-preview-3aa5704d-cb7a-43fa-9967-ef8cd7513fef\"><img src=\"\"></img></div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "gis = GIS()\n",
    "map2 = gis.map()\n",
    "map2.basemap = \"gray\"\n",
    "map2.height = '650px'\n",
    "map2.clear_graphics()\n",
    "\n",
    "symbol_attains = {\n",
    "    \"color\": [\n",
    "        0,\n",
    "        92,\n",
    "        230,\n",
    "        255\n",
    "    ],\n",
    "    \"width\": 2,\n",
    "    \"type\": \"esriSLS\",\n",
    "    \"style\": \"esriSLSSolid\"\n",
    "}\n",
    "\n",
    "map2.draw(huc_result,symbol=huc_symbol)\n",
    "\n",
    "map2.draw(attains_result,symbol=symbol_attains)\n",
    "\n",
    "map2.extent = attains_result.sdf.spatial.full_extent\n",
    "\n",
    "map2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve assessments from ATTAINS Java based web service"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://54.209.48.156/attains-public/api/huc12summary?huc=010900010704\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "''"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = 'http://54.209.48.156/attains-public/api/huc12summary?huc=' + huc12\n",
    "print(url)\n",
    "response = requests.get(url)        # To execute get request \n",
    "#print(response.status_code)     # To print http response code  \n",
    "#print(response.text)            # To print formatted JSON response \n",
    "\n",
    "data = response.json()\n",
    "\n",
    "assessmentUnits = data['items'][0]['assessmentUnits']\n",
    "\n",
    "assessmentUnitList = []\n",
    "for unit in assessmentUnits:\n",
    "    assessmentUnitList.append(unit['assessmentUnitId'])\n",
    "\n",
    "assessmentUnitList = \",\".join(map(lambda x: \"'\" + str(x) + \"'\",assessmentUnitList))\n",
    "assessmentUnitList"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve linear features from ArcGIS based on assessment list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>SHAPE</th>\n",
       "      <th>Shape_Length</th>\n",
       "      <th>abnormalflow</th>\n",
       "      <th>acidity</th>\n",
       "      <th>ammonia</th>\n",
       "      <th>assessmentunitidentifier</th>\n",
       "      <th>assessmentunitname</th>\n",
       "      <th>bacteriaandothermicrobes</th>\n",
       "      <th>biologicalpoisons</th>\n",
       "      <th>...</th>\n",
       "      <th>reportingcycle</th>\n",
       "      <th>salts</th>\n",
       "      <th>state</th>\n",
       "      <th>tastecolorandodor</th>\n",
       "      <th>temperature</th>\n",
       "      <th>totaltoxicchemicals</th>\n",
       "      <th>toxicinorganicchemicals</th>\n",
       "      <th>toxicorganicchemicals</th>\n",
       "      <th>trash</th>\n",
       "      <th>visionpriority303d</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>{\"paths\": [[[-76.9667505038364, 38.87766563515...</td>\n",
       "      <td>1806.020444</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTPB01R_00</td>\n",
       "      <td>POPES BRANCH (HAWES RUN)</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9</td>\n",
       "      <td>{\"paths\": [[[-76.9534825065659, 38.86617797618...</td>\n",
       "      <td>668.726683</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTFD01R_00</td>\n",
       "      <td>FORT DAVIS TRIBUTARY</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11</td>\n",
       "      <td>{\"paths\": [[[-76.94546523758953, 38.8862434426...</td>\n",
       "      <td>750.146112</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTFC01R_00</td>\n",
       "      <td>FORT CHAPLIN RUN</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>14</td>\n",
       "      <td>{\"paths\": [[[-76.94936394748217, 38.9130061189...</td>\n",
       "      <td>2268.004148</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTNA01R_00</td>\n",
       "      <td>NASH RUN</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>19</td>\n",
       "      <td>{\"paths\": [[[-76.95356791029826, 38.9067868554...</td>\n",
       "      <td>5764.890523</td>\n",
       "      <td>Cause</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTWB00R_02</td>\n",
       "      <td>WATTS BRANCH DC</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Insufficient Information</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>20</td>\n",
       "      <td>{\"paths\": [[[-76.95753384381857, 38.9059979239...</td>\n",
       "      <td>522.760347</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTWB00R_01</td>\n",
       "      <td>WATTS BRANCH DC</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Insufficient Information</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>21</td>\n",
       "      <td>{\"paths\": [[[-76.9634179059476, 38.86311088822...</td>\n",
       "      <td>1289.339591</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTTX27R_00</td>\n",
       "      <td>TEXAS AVENUE TRIBUTARY</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22</td>\n",
       "      <td>{\"paths\": [[[-76.96914131606617, 38.9170628668...</td>\n",
       "      <td>1968.783871</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTHR01R_00</td>\n",
       "      <td>HICKEY RUN</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>23</td>\n",
       "      <td>{\"paths\": [[[-76.97693208831835, 38.8574268728...</td>\n",
       "      <td>1186.674177</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTFS01R_00</td>\n",
       "      <td>FORT STANTON TRIBUTARY</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>24</td>\n",
       "      <td>{\"paths\": [[[-76.96316734605192, 38.8820414342...</td>\n",
       "      <td>2916.979367</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DCTDU01R_00</td>\n",
       "      <td>FORT DUPONT CREEK</td>\n",
       "      <td>Cause</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2020</td>\n",
       "      <td>None</td>\n",
       "      <td>DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   OBJECTID                                              SHAPE  Shape_Length  \\\n",
       "0         5  {\"paths\": [[[-76.9667505038364, 38.87766563515...   1806.020444   \n",
       "1         9  {\"paths\": [[[-76.9534825065659, 38.86617797618...    668.726683   \n",
       "2        11  {\"paths\": [[[-76.94546523758953, 38.8862434426...    750.146112   \n",
       "3        14  {\"paths\": [[[-76.94936394748217, 38.9130061189...   2268.004148   \n",
       "4        19  {\"paths\": [[[-76.95356791029826, 38.9067868554...   5764.890523   \n",
       "5        20  {\"paths\": [[[-76.95753384381857, 38.9059979239...    522.760347   \n",
       "6        21  {\"paths\": [[[-76.9634179059476, 38.86311088822...   1289.339591   \n",
       "7        22  {\"paths\": [[[-76.96914131606617, 38.9170628668...   1968.783871   \n",
       "8        23  {\"paths\": [[[-76.97693208831835, 38.8574268728...   1186.674177   \n",
       "9        24  {\"paths\": [[[-76.96316734605192, 38.8820414342...   2916.979367   \n",
       "\n",
       "  abnormalflow acidity ammonia assessmentunitidentifier  \\\n",
       "0         None    None    None              DCTPB01R_00   \n",
       "1         None    None    None              DCTFD01R_00   \n",
       "2         None    None    None              DCTFC01R_00   \n",
       "3        Cause    None    None              DCTNA01R_00   \n",
       "4        Cause   Cause    None              DCTWB00R_02   \n",
       "5        Cause    None    None              DCTWB00R_01   \n",
       "6        Cause    None    None              DCTTX27R_00   \n",
       "7        Cause    None    None              DCTHR01R_00   \n",
       "8         None    None    None              DCTFS01R_00   \n",
       "9         None    None    None              DCTDU01R_00   \n",
       "\n",
       "         assessmentunitname bacteriaandothermicrobes biologicalpoisons  \\\n",
       "0  POPES BRANCH (HAWES RUN)                    Cause              None   \n",
       "1      FORT DAVIS TRIBUTARY                    Cause              None   \n",
       "2          FORT CHAPLIN RUN                    Cause              None   \n",
       "3                  NASH RUN                    Cause              None   \n",
       "4           WATTS BRANCH DC                    Cause              None   \n",
       "5           WATTS BRANCH DC                    Cause              None   \n",
       "6    TEXAS AVENUE TRIBUTARY                    Cause              None   \n",
       "7                HICKEY RUN                    Cause              None   \n",
       "8    FORT STANTON TRIBUTARY                    Cause              None   \n",
       "9         FORT DUPONT CREEK                    Cause              None   \n",
       "\n",
       "         ...         reportingcycle salts state tastecolorandodor temperature  \\\n",
       "0        ...                   2020  None    DC              None        None   \n",
       "1        ...                   2020  None    DC              None        None   \n",
       "2        ...                   2020  None    DC              None        None   \n",
       "3        ...                   2020  None    DC              None        None   \n",
       "4        ...                   2020  None    DC              None        None   \n",
       "5        ...                   2020  None    DC              None        None   \n",
       "6        ...                   2020  None    DC              None        None   \n",
       "7        ...                   2020  None    DC              None        None   \n",
       "8        ...                   2020  None    DC              None        None   \n",
       "9        ...                   2020  None    DC              None        None   \n",
       "\n",
       "  totaltoxicchemicals toxicinorganicchemicals     toxicorganicchemicals trash  \\\n",
       "0                None                    None                     Cause  None   \n",
       "1                None                    None                      None  None   \n",
       "2                None                    None                      None  None   \n",
       "3                None                    None                     Cause  None   \n",
       "4                None                    None  Insufficient Information  None   \n",
       "5                None                    None  Insufficient Information  None   \n",
       "6                None                    None                     Cause  None   \n",
       "7                None                    None                     Cause  None   \n",
       "8                None                    None                     Cause  None   \n",
       "9                None                    None                      None  None   \n",
       "\n",
       "  visionpriority303d  \n",
       "0                  Y  \n",
       "1                  Y  \n",
       "2                  Y  \n",
       "3                  Y  \n",
       "4                  Y  \n",
       "5                  Y  \n",
       "6                  Y  \n",
       "7                  Y  \n",
       "8                  Y  \n",
       "9                  Y  \n",
       "\n",
       "[10 rows x 55 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from arcgis.geometry import filters\n",
    "\n",
    "lyr_url = 'https://inlandwaters.geoplatform.gov/arcgis/rest/services/BETA/hmw_cip/MapServer/1'\n",
    "attains_lines_featurelayer = FeatureLayer(lyr_url)\n",
    "query_result3 = attains_lines_featurelayer.query(where=\"assessmentunitidentifier in (\" + assessmentUnitList + \")\", \n",
    "                                                 out_fields='*',out_sr=4326)\n",
    "\n",
    "query_result3.sdf"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Display linear features on map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "7acd0c9574014cc0a73bfbcce17cd011",
       "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 Jupyter Notebook or JupyterLab, 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 notebook 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(layout=Layout(height='400px', width='100%'))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "gis = GIS()\n",
    "map3 = gis.map()\n",
    "map3.basemap = \"gray\"\n",
    "map3.height = '650px'\n",
    "map3.clear_graphics()\n",
    "\n",
    "symbol = {\n",
    "    \"color\": [\n",
    "        0,\n",
    "        92,\n",
    "        230,\n",
    "        255\n",
    "    ],\n",
    "    \"width\": 2,\n",
    "    \"type\": \"esriSLS\",\n",
    "    \"style\": \"esriSLSSolid\"\n",
    "}\n",
    "\n",
    "map3.draw(query_result3,symbol=symbol)\n",
    "\n",
    "map3.extent = query_result3.sdf.spatial.full_extent\n",
    "\n",
    "map3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve point features from ArcGIS based on assessment list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No point features found.\n"
     ]
    }
   ],
   "source": [
    "from arcgis.geometry import filters\n",
    "\n",
    "lyr_url = 'https://inlandwaters.geoplatform.gov/arcgis/rest/services/BETA/hmw_cip/MapServer/0'\n",
    "attains_point_featurelayer = FeatureLayer(lyr_url)\n",
    "query_result4 = attains_point_featurelayer.query(where=\"assessmentunitidentifier in (\" + assessmentUnitList + \")\", \n",
    "                                                 out_fields='*',out_sr=4326)\n",
    "\n",
    "if len(query_result4.features) == 0:\n",
    "    print(\"No point features found.\")\n",
    "else:\n",
    "    query_result4.sdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No point features found.\n"
     ]
    }
   ],
   "source": [
    "if len(query_result4.features) == 0:\n",
    "    print(\"No point features found.\")\n",
    "else:\n",
    "    gis = GIS()\n",
    "    map4 = gis.map()\n",
    "    map4.basemap = \"gray\"\n",
    "    map4.height = '650px'\n",
    "    map4.clear_graphics()\n",
    "\n",
    "    symbol = {\n",
    "        \"color\": [\n",
    "            0,\n",
    "            92,\n",
    "            230,\n",
    "            255\n",
    "        ],\n",
    "        \"width\": 2,\n",
    "        \"type\": \"esriSLS\",\n",
    "        \"style\": \"esriSLSSolid\"\n",
    "    }\n",
    "\n",
    "    map4.draw(query_result4,symbol=symbol)\n",
    "\n",
    "    map4.extent = query_result4.sdf.spatial.full_extent\n",
    "\n",
    "    map4"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve area features from ArcGIS based on assessment list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"features\": [{\"geometry\": {\"rings\": [[[-76.97944572899354, 38.8775942904239], [-76.9793449694597, 38.87762191248607], [-76.97882819023631, 38.877756818321224], [-76.97563198265878, 38.87850024902246], [-76.97540715590274, 38.878589652048966], [-76.974887258627, 38.8787426152104], [-76.97456439602905, 38.87885620097714], [-76.97428030831205, 38.87897814127485], [-76.97410767187735, 38.87905314412901], [-76.9740162853652, 38.87912226707872], [-76.97375658241654, 38.879383453793146], [-76.97363015801504, 38.87946218004469], [-76.97327196018539, 38.87977008411757], [-76.97320195178034, 38.879974001002054], [-76.97319495570092, 38.88017685296246], [-76.9731457082604, 38.880258779040474], [-76.97300558365251, 38.880441355378935], [-76.97275981447223, 38.88084196657399], [-76.972078769316, 38.881786049464324], [-76.97172078079382, 38.8823237110277], [-76.97062514516763, 38.88377936918393], [-76.9704073189826, 38.88381007680539], [-76.9701056709984, 38.88392329434984], [-76.96999316599221, 38.8840107913492], [-76.96995111495544, 38.88409259413178], [-76.96993681647108, 38.88420096043705], [-76.96929063762595, 38.88440108160227], [-76.9692204459646, 38.88442929608964], [-76.96784386852153, 38.88552474781576], [-76.96643927082812, 38.88661164353865], [-76.96575814033191, 38.887348452864636], [-76.96544909022977, 38.88779516577837], [-76.96528755966696, 38.88797358892646], [-76.9647539136758, 38.88868988862065], [-76.96464840744399, 38.88896648166019], [-76.96454347882893, 38.889486344304764], [-76.9644380184112, 38.88981699982009], [-76.96436791658137, 38.889953334753585], [-76.96304148040251, 38.894224049190534], [-76.96259241798187, 38.89619586589122], [-76.96258571565154, 38.89663298199003], [-76.96252244101787, 38.89717466937157], [-76.96252254073086, 38.897426958272085], [-76.96251545571822, 38.89756223339658], [-76.96256497444995, 38.89803895153589], [-76.96266345226297, 38.898487815533315], [-76.96276921271799, 38.89916181546265], [-76.96277631659525, 38.89945903840124], [-76.96275534452664, 38.89963959879592], [-76.96265704278342, 38.899943099824505], [-76.96262884915822, 38.89996609978396], [-76.96251632888068, 38.90021127165964], [-76.96248152814658, 38.90022987765462], [-76.9622636938767, 38.90058945114673], [-76.9619689045297, 38.90095482113961], [-76.96160328571747, 38.901470053329646], [-76.96149819450733, 38.90156642816122], [-76.96138549726169, 38.90175303522345], [-76.96089372983076, 38.902319941489466], [-76.96068307040505, 38.90252170828257], [-76.96031075824565, 38.90295145001055], [-76.9600299071586, 38.90335262355252], [-76.95914481866873, 38.90483166986191], [-76.95847068784524, 38.90605488035318], [-76.95816144370698, 38.9067088158651], [-76.95814737159805, 38.90682618695964], [-76.95817552300241, 38.90689329202002], [-76.95807773958711, 38.90742654557002], [-76.95802131191255, 38.907431997340574], [-76.95790899016268, 38.90765914125967], [-76.95769837655106, 38.9077978291326], [-76.95760713826091, 38.907966051426726], [-76.95751579396955, 38.90830096884535], [-76.95719964627835, 38.908454941732934], [-76.9571361892867, 38.90853259352204], [-76.95705183029499, 38.908597080526064], [-76.95586427904894, 38.91009018368006], [-76.95502834906638, 38.91106830003908], [-76.9549651040771, 38.9111144108732], [-76.95468384245996, 38.911529094582136], [-76.95451529695309, 38.91174366100951], [-76.95437492171523, 38.91205236459728], [-76.95423463900383, 38.91264038738816], [-76.95424164945629, 38.912698837741125], [-76.95421347918729, 38.912762382227264], [-76.95410111701325, 38.91343553648935], [-76.95386279217173, 38.91443066780162], [-76.95381375763195, 38.91453510786595], [-76.95359591078568, 38.914831591948015], [-76.95346932019584, 38.91495985619061], [-76.95326552120395, 38.91509842215944], [-76.95294227322874, 38.915284038876855], [-76.95275233883496, 38.91533677517879], [-76.95249934989477, 38.91537704905191], [-76.95230962031685, 38.91538472848427], [-76.95188066668385, 38.91536937730718], [-76.94977216799842, 38.91547219930634], [-76.94671462526647, 38.91557279638487], [-76.9462224320341, 38.91563056214389], [-76.94585708271647, 38.91574027334193], [-76.94544233324474, 38.91596794144735], [-76.94511189874726, 38.91622123575467], [-76.94437412498083, 38.916855244441486], [-76.94428981988804, 38.91704136259643], [-76.94419825011956, 38.91713299146168], [-76.94396635182558, 38.91731255705083], [-76.94380440803774, 38.91740085303741], [-76.9436781462313, 38.917515586144226], [-76.94352353718774, 38.91762178018703], [-76.94331974358577, 38.91781439220858], [-76.94320730235997, 38.91794691384034], [-76.94315788873112, 38.91805135571926], [-76.94295426580905, 38.91832956284455], [-76.94279938457598, 38.91838620388343], [-76.94275041291826, 38.91842756635091], [-76.94260260501972, 38.91846606809074], [-76.94253936092878, 38.91853920295717], [-76.94252546668628, 38.9185980021078], [-76.94241992362355, 38.918626790106096], [-76.94235677834727, 38.918663882008346], [-76.94227083742236, 38.91873739618617], [-76.94171471737941, 38.918368212810066], [-76.94163189091358, 38.918225425408885], [-76.94175909145952, 38.91806562716858], [-76.941913802911, 38.917923392013115], [-76.94187858625692, 38.917874421380645], [-76.94180135988857, 38.91785768476027], [-76.94139344839279, 38.91791402912997], [-76.94121081820057, 38.917957613075025], [-76.94109853687489, 38.91796398592653], [-76.94085246047082, 38.91794104701342], [-76.94069054722569, 38.91788517234719], [-76.94064850337544, 38.91786334610809], [-76.94060630501497, 38.91778295422725], [-76.94060640382965, 38.91774691096296], [-76.94068360055358, 38.917709585137686], [-76.94076104880581, 38.91769478172839], [-76.9410209314175, 38.91770848082303], [-76.9414077316058, 38.917697541816615], [-76.94172406704489, 38.91773282606466], [-76.94208958075423, 38.91766817682097], [-76.94234267479732, 38.91757836587682], [-76.94244108433838, 38.917473109041694], [-76.94262377112445, 38.91732590185813], [-76.94272916416853, 38.9172520647066], [-76.94289094446297, 38.91709168974624], [-76.94294696520075, 38.9169916427901], [-76.94296096544443, 38.91691031683523], [-76.94294003739326, 38.91685660248528], [-76.9428906579004, 38.91681687812139], [-76.94285546639917, 38.91680845377157], [-76.94268001194943, 38.91679785850602], [-76.94253219057617, 38.916809329546126], [-76.942208874329, 38.91674262666604], [-76.94208926814049, 38.916744617954194], [-76.94187145902346, 38.91679329371372], [-76.94172399877293, 38.91680475776512], [-76.94143563507515, 38.9167509867209], [-76.94064833000058, 38.91673254511373], [-76.9402757833809, 38.916671161820986], [-76.94000166426859, 38.91674329555437], [-76.93975572171347, 38.916738373598676], [-76.9394183585102, 38.916671897808556], [-76.93938302238017, 38.916618421618054], [-76.93940438611426, 38.91659554098136], [-76.93951676355968, 38.91655312693212], [-76.93960811683421, 38.91649304212458], [-76.93986100965466, 38.91647532316001], [-76.94007191521875, 38.916530384665485], [-76.94066944490135, 38.91648891415351], [-76.94136540388793, 38.91658095750716], [-76.94159728062232, 38.91655908054294], [-76.94188565060831, 38.9166263658159], [-76.9419909681939, 38.916629118956216], [-76.9421034678102, 38.91659120473081], [-76.94230736561676, 38.91657429586745], [-76.94266587156855, 38.916649422576484], [-76.94288383699246, 38.91665930983426], [-76.94318584789605, 38.91664527154934], [-76.94339692593665, 38.91658769463226], [-76.94355856789058, 38.916594012390185], [-76.94385372195359, 38.91636834248458], [-76.94467616642712, 38.915561728441574], [-76.94548400519245, 38.915039178366584], [-76.9457229031591, 38.914931576247085], [-76.94601117343211, 38.914850181530035], [-76.94634125758662, 38.914808635946294], [-76.94679829884362, 38.914810023385634], [-76.95228811644559, 38.9145606389408], [-76.95257641636299, 38.91453328985904], [-76.95271699551841, 38.91448138123373], [-76.95278730665571, 38.9144036157303], [-76.95283621992293, 38.914294672727515], [-76.95295558176967, 38.91365293847988], [-76.95294868630155, 38.91358547704228], [-76.95305372091784, 38.91289442540459], [-76.95313796851845, 38.91251007442392], [-76.95323638794098, 38.912287673274754], [-76.95341897950563, 38.91174399442875], [-76.95352451807679, 38.91157103142522], [-76.95361549316056, 38.91135325957971], [-76.95390357388902, 38.91089791819551], [-76.95439547606722, 38.91020038785465], [-76.95499982845442, 38.90943789893418], [-76.95490828024549, 38.9093718545886], [-76.95483802660037, 38.90935951556709], [-76.95459922295682, 38.909390546957844], [-76.95445168724781, 38.909438070192785], [-76.95426181124452, 38.909544867687984], [-76.95407908672921, 38.90974165096465], [-76.95386116262783, 38.90991649596711], [-76.95336215926726, 38.91011857180194], [-76.95320075716354, 38.910251924244356], [-76.95300379345267, 38.910521025961785], [-76.95297605347669, 38.910679171972305], [-76.952982989369, 38.91080069625942], [-76.95293397549048, 38.91093216641115], [-76.95279311336571, 38.911078689256414], [-76.95268071975062, 38.91123825159048], [-76.95272998515743, 38.911444666518605], [-76.95268099014352, 38.911603167656835], [-76.9526036416043, 38.91173961734025], [-76.95248424831652, 38.91185424426599], [-76.9523364592826, 38.91189275865904], [-76.9520695177094, 38.91188370742907], [-76.95159157714733, 38.91168446264679], [-76.9514018287048, 38.91165159320832], [-76.95118366205827, 38.91167326128853], [-76.95103599609357, 38.9117162765916], [-76.9509025217137, 38.911790590623085], [-76.95080412295243, 38.911882339504224], [-76.95077620690665, 38.91196840478044], [-76.95079730114614, 38.91208068133653], [-76.95088154964509, 38.91218289229212], [-76.95108543577354, 38.912337166410204], [-76.95116288402576, 38.91266475044503], [-76.95130339041765, 38.91284711347918], [-76.95138077578781, 38.91292240839424], [-76.95147230153884, 38.91311910681748], [-76.95147236981082, 38.91321371489667], [-76.95141607329028, 38.913408378493386], [-76.95131770237676, 38.913540673497614], [-76.95122650091754, 38.91378998394059], [-76.95116317597822, 38.913899168164065], [-76.951064774522, 38.91399091571741], [-76.95095227490572, 38.914015323044794], [-76.95081871877916, 38.913981513872045], [-76.95074150319061, 38.91397829860979], [-76.95059369888533, 38.91400329587203], [-76.95013002895985, 38.914128179302686], [-76.94991220457143, 38.914136322985314], [-76.94955370490784, 38.91406121877873], [-76.94873839934588, 38.91379551420623], [-76.94851309648273, 38.91375422312997], [-76.94819704041969, 38.91375499409636], [-76.94783837995767, 38.91379251701482], [-76.94747327138855, 38.913884208788346], [-76.94736750913687, 38.913931025151335], [-76.94718471814623, 38.914073735919054], [-76.94705136773389, 38.91416606478829], [-76.9466504684872, 38.914253845357], [-76.94642587798806, 38.9143837364389], [-76.94632022982245, 38.91442154000906], [-76.94606746905433, 38.9144437762016], [-76.94539932460388, 38.914445904551464], [-76.94522380457714, 38.914511902237884], [-76.9449987361743, 38.91465080947651], [-76.94490047395693, 38.91478760208294], [-76.94471770991575, 38.91498437152354], [-76.94453516596181, 38.91514959922279], [-76.94429606138264, 38.91531577012922], [-76.94388838344882, 38.91552529473124], [-76.9436919003366, 38.91568174441517], [-76.94364991667351, 38.91595275464978], [-76.94358667707412, 38.91602589070859], [-76.94351632102108, 38.91604958860108], [-76.94332657257856, 38.916030221402046], [-76.94300320243246, 38.916067142719896], [-76.94292573980721, 38.91605491669422], [-76.94286963732276, 38.91601980844626], [-76.94272910487972, 38.9157698579074], [-76.94256703173447, 38.9156419047652], [-76.94238435033829, 38.91559088252575], [-76.94202585875955, 38.91552927038624], [-76.94196242961564, 38.91548977942934], [-76.94191337171968, 38.91538247155462], [-76.94189201157883, 38.915207124185855], [-76.94192711324857, 38.91506687952894], [-76.94210994376509, 38.91476649412334], [-76.94219421112864, 38.914512800407664], [-76.9423628743148, 38.914221661397754], [-76.9426581864813, 38.91406807496783], [-76.94286902018017, 38.91401500850841], [-76.94316416795496, 38.91398756904925], [-76.94343832210158, 38.91399651935928], [-76.94376186472421, 38.91405870947908], [-76.94407116186305, 38.91419321830055], [-76.9441763707525, 38.914218497171056], [-76.94432407983635, 38.91422955204338], [-76.94458404599138, 38.914207200454115], [-76.9447177952557, 38.91416892985899], [-76.94479508181117, 38.914095559129855], [-76.94480897425704, 38.91403676044238], [-76.94475990288632, 38.91391593787071], [-76.94475994959872, 38.91379880216986], [-76.94473181616067, 38.91374520778494], [-76.94467547023277, 38.91370109492627], [-76.94466846786514, 38.91364264539871], [-76.94468970493676, 38.91361525891759], [-76.94476703371305, 38.913609465823775], [-76.94483705289788, 38.91362632017469], [-76.94492151609414, 38.91369699475172], [-76.94503395552331, 38.913762698867295], [-76.94515330928522, 38.91375169983999], [-76.94535025053821, 38.913572715174936], [-76.94548373300292, 38.91349840720321], [-76.9456030795783, 38.91347389205596], [-76.94600371292367, 38.91335007690773], [-76.9461302271567, 38.91327137982627], [-76.94619357635055, 38.91318922970713], [-76.94620777422361, 38.913049331950226], [-76.94629896759798, 38.91294419211719], [-76.94629895053001, 38.912917161147625], [-76.94627103538255, 38.912832028065075], [-76.94627807278448, 38.912575114904605], [-76.94618636198048, 38.91243698297198], [-76.94602491316436, 38.91234506565315], [-76.94571552349905, 38.91224660499712], [-76.94493512377406, 38.91205687866836], [-76.94485090941114, 38.91199520893968], [-76.94470321739527, 38.91181295695326], [-76.94463306795474, 38.911778084963], [-76.9443380118081, 38.91174245385021], [-76.94409868444671, 38.91172841948562], [-76.9439301766691, 38.91166815374816], [-76.94383156231216, 38.91162023847308], [-76.94389488006495, 38.911484029014375], [-76.94393709639172, 38.91120850856054], [-76.94400741381723, 38.91113074855801], [-76.94407049261815, 38.91099904740529], [-76.9441267774606, 38.91094855236888], [-76.94433783124671, 38.91087745845065], [-76.94439375496643, 38.91082697031783], [-76.94440104030336, 38.910763776395775], [-76.94438695831298, 38.91070994834935], [-76.9442391710757, 38.91056373929457], [-76.94384518526344, 38.910349546763456], [-76.94378195554555, 38.91023797066992], [-76.9435291004543, 38.91008449934387], [-76.94348654456437, 38.91000411472842], [-76.94350776456798, 38.909949698238755], [-76.94353596897297, 38.90992670361043], [-76.9436412766771, 38.90992945421461], [-76.9438735657382, 38.910029205659534], [-76.94443585091894, 38.9103622337177], [-76.94444967958442, 38.91039353937928], [-76.94468189857695, 38.91056987864381], [-76.94492826603519, 38.91070993926232], [-76.94504042788493, 38.910726091804655], [-76.94519520401514, 38.910719006719034], [-76.94555381506981, 38.91062743038587], [-76.94565200003206, 38.91056722662396], [-76.94572214048944, 38.910403870677946], [-76.9456725615706, 38.910238004222236], [-76.94551800912092, 38.9100288365828], [-76.9455037851967, 38.909943475653705], [-76.94552508335376, 38.90982598528936], [-76.94567961244725, 38.90944046711444], [-76.94572182877403, 38.90936317491341], [-76.94579898687041, 38.90928530104667], [-76.9459327091853, 38.9092199989151], [-76.9461855391237, 38.90914820494696], [-76.94633334342896, 38.90913672987252], [-76.94653712265792, 38.90915585709263], [-76.94677614279546, 38.909264501115004], [-76.9469799229227, 38.90928362690263], [-76.94712752600535, 38.90933072241146], [-76.94738037660501, 38.909470670137715], [-76.94759149776476, 38.90969240696477], [-76.94768291571795, 38.90975395427014], [-76.94813319086424, 38.909917636052555], [-76.94823135875849, 38.91001511223947], [-76.94827370174771, 38.910127035391284], [-76.94829469627422, 38.91027535634537], [-76.9483720951191, 38.91037768313962], [-76.94843528531113, 38.91042168063102], [-76.94881505618233, 38.91055049527029], [-76.9489063546596, 38.910607538153734], [-76.9492367729874, 38.91107957139271], [-76.94939138742085, 38.911185113115486], [-76.94951104032175, 38.911264208142356], [-76.94965145328887, 38.91132493556029], [-76.95010121190384, 38.91141653615733], [-76.95047385194832, 38.91146887620707], [-76.95086741195914, 38.9113902154845], [-76.9509798981007, 38.9113522942663], [-76.95132424480698, 38.91113479365996], [-76.95135942373183, 38.91112969936183], [-76.95140849869578, 38.911079322549156], [-76.95144374229933, 38.91099763962043], [-76.95141556574214, 38.91088998593849], [-76.95124668067209, 38.910645024291], [-76.95121155654448, 38.910560012905755], [-76.95095856850259, 38.91024437287387], [-76.95093742575406, 38.91006451888446], [-76.95095868618189, 38.90990648194813], [-76.95107792675607, 38.90974680687543], [-76.95164026314079, 38.909449072684616], [-76.95187212729876, 38.909283008972224], [-76.95201978697527, 38.90923999289356], [-76.95220229409829, 38.90923243512422], [-76.95242042391389, 38.909170219105995], [-76.95251848760357, 38.90911902095464], [-76.95266627034927, 38.909080507153604], [-76.95320717562625, 38.90888223802409], [-76.95334076588878, 38.908812424739715], [-76.95369934640074, 38.90870730868845], [-76.95400135191443, 38.90857610773399], [-76.9545850861692, 38.90849425066377], [-76.95470445071089, 38.908510272992814], [-76.95480284228563, 38.90857620280115], [-76.9550490273859, 38.908932494067585], [-76.9551964400257, 38.909038149427815], [-76.95537202113786, 38.909080259701106], [-76.95551285631316, 38.90906438499361], [-76.95553374843175, 38.90906403478537], [-76.95562528316592, 38.90895888205866], [-76.95561129460032, 38.90888252741848], [-76.95621540803563, 38.908151573554704], [-76.95632776212483, 38.908109143274764], [-76.95635581651118, 38.90805461139073], [-76.95633483815433, 38.90794683860438], [-76.9563554185575, 38.907856389725936], [-76.95650307823401, 38.907669201731814], [-76.95655908819197, 38.907438497662476], [-76.95651712249516, 38.9072094362787], [-76.95657320611498, 38.90707333998852], [-76.95697373435745, 38.906737747096315], [-76.95707928999659, 38.90660532616737], [-76.95719152191492, 38.90641422581731], [-76.95728281320567, 38.90631358080557], [-76.95734594051564, 38.90627648105044], [-76.95747260027575, 38.90611217011785], [-76.95751478066994, 38.90600784278922], [-76.95759184893477, 38.905691187066], [-76.95766217893669, 38.90565396674866], [-76.95766909147281, 38.905590778008055], [-76.95764095264484, 38.90553718791133], [-76.95754965506589, 38.905480150740075], [-76.95754247573012, 38.905363136734366], [-76.95759154350759, 38.90531275722733], [-76.95762690029883, 38.90523557517715], [-76.95771097901618, 38.90497736852625], [-76.95785856413252, 38.904709087462976], [-76.95804110898477, 38.90446724957359], [-76.95821011263244, 38.904113009329485], [-76.95840644392936, 38.903848414690515], [-76.9584977756443, 38.903657663445905], [-76.95869461089609, 38.903424596752366], [-76.95894756749695, 38.9029653267205], [-76.95912988956701, 38.90275502821081], [-76.95931984282542, 38.90248152848227], [-76.95936206364377, 38.90243126227926], [-76.95950934512956, 38.90238824344691], [-76.95957255688116, 38.90231509822929], [-76.95965020994925, 38.9022822580084], [-76.95970597017558, 38.90220022939569], [-76.95969931815088, 38.902141773194124], [-76.95964273506777, 38.90210217621741], [-76.95939700182012, 38.90199817716016], [-76.9591509308059, 38.901921214516], [-76.95891911066539, 38.90179895985879], [-76.95892583186033, 38.90165017517393], [-76.9588979068314, 38.90156504535669], [-76.95901702613304, 38.901441405881066], [-76.95912276053691, 38.901394579183226], [-76.95976213284712, 38.90145142389054], [-76.95990978443879, 38.90142191305368], [-76.95994497953333, 38.90129968200508], [-76.96002205678133, 38.901298387980354], [-76.96019778881048, 38.90125489028041], [-76.96038737825118, 38.90126972717968], [-76.96050010154798, 38.90125431772131], [-76.96064049026057, 38.90115735103061], [-76.96120236041966, 38.90044059611438], [-76.96139231188143, 38.90018060887988], [-76.96151157760843, 38.899957849609386], [-76.96168005125008, 38.89971624372056], [-76.9617504818633, 38.899525841417336], [-76.96178537871715, 38.899340542836576], [-76.96178516312146, 38.89895309967679], [-76.96172885761779, 38.89867472361787], [-76.96162329838538, 38.898361134404595], [-76.96148998749891, 38.89816514664782], [-76.96139857313895, 38.89810360957001], [-76.96130715877902, 38.89804207243886], [-76.96102614060531, 38.89793866938417], [-76.96094161542528, 38.897931079650064], [-76.96061848512937, 38.89799958018673], [-76.9603725847951, 38.89796766850896], [-76.96033714266386, 38.89793672720653], [-76.96033021934797, 38.89769806826683], [-76.96076574056401, 38.897654712382334], [-76.96098359010526, 38.89759698932304], [-76.96111015015238, 38.89748223310756], [-76.96115221915544, 38.89740043315932], [-76.9611733645989, 38.897278438486985], [-76.96117304120543, 38.8969000071548], [-76.96097605144338, 38.895790533226254], [-76.96098983249817, 38.89547944263143], [-76.9610807581746, 38.89482916796243], [-76.96113684808262, 38.89472010053199], [-76.96127032605574, 38.89413668782345], [-76.96186654599464, 38.89197318390589], [-76.96203506545037, 38.89124951984935], [-76.96244223583604, 38.8897064025147], [-76.96251923762557, 38.88949336368581], [-76.96254729830011, 38.889321694556], [-76.96268092000366, 38.8889274954444], [-76.96315799189486, 38.88786976146529], [-76.96342553264437, 38.88743276344353], [-76.96409241765677, 38.88643941014948], [-76.96426797900601, 38.886247238127915], [-76.96428917655177, 38.88619281881368], [-76.96461219545658, 38.885795430552534], [-76.96497685756303, 38.88539283484048], [-76.96518087394719, 38.88521369756631], [-76.96704910563346, 38.8836955150871], [-76.96849569327821, 38.88265746062351], [-76.96897361856892, 38.8822484375069], [-76.9690649754367, 38.88213877315049], [-76.96917722981291, 38.882042269859284], [-76.96927516594182, 38.8819099665102], [-76.96938070181803, 38.88181808309556], [-76.96968953183291, 38.88144344555678], [-76.96997753979784, 38.881136737533645], [-76.97008300919873, 38.88097727538362], [-76.97022341677594, 38.88083073937101], [-76.9704832032679, 38.88038935049894], [-76.97051811718973, 38.88037524560139], [-76.97079223091215, 38.87998317028652], [-76.97088328055611, 38.87981043620906], [-76.97105167694264, 38.879568817028456], [-76.97125531154282, 38.87915540612592], [-76.97174678432634, 38.8782866122366], [-76.97191532623995, 38.8780765259734], [-76.972092340165, 38.8779383800738], [-76.97244888599283, 38.87766204411057], [-76.9729265319075, 38.877388165918134], [-76.97334102446106, 38.87721446744793], [-76.97648093102646, 38.8762603106498], [-76.97662526693644, 38.87621731932446], [-76.97667228655503, 38.87620361641971], [-76.97944572899354, 38.8775942904239]], [[-76.94361419606453, 38.914696401449575], [-76.94365643395088, 38.914646140400556], [-76.94365615457482, 38.91458307219759], [-76.9436000125645, 38.91448038800429], [-76.94336124215863, 38.914407775276146], [-76.94323467133174, 38.91440537712428], [-76.94312228310655, 38.91442076415717], [-76.94288337346178, 38.91451484627762], [-76.942665251731, 38.91463110639315], [-76.94258774868155, 38.91474953170405], [-76.94252467976209, 38.91490826310868], [-76.94253178633429, 38.91494418619562], [-76.9427919689833, 38.91487678260122], [-76.94284811907845, 38.91479475456174], [-76.94291126076146, 38.91475766203508], [-76.94306604497649, 38.91475058014775], [-76.94316423712525, 38.914690377087226], [-76.94326989607066, 38.914666092310625], [-76.94354395589416, 38.91471108666067], [-76.94361419606453, 38.914696401449575]], [[-76.94412752306228, 38.91503024566208], [-76.94423278046075, 38.91493838831752], [-76.94421857450287, 38.914880057234434], [-76.94418362105515, 38.91486712435438], [-76.94398690797424, 38.91484337015005], [-76.94387439578153, 38.914854254378525], [-76.94366346326798, 38.91494336631486], [-76.94348775908662, 38.914910250254515], [-76.94338927947696, 38.914893869405134], [-76.94315020454218, 38.914915871297794], [-76.94305188932424, 38.91497157006707], [-76.94283384754354, 38.915024757430224], [-76.9427919689833, 38.91507501122155], [-76.94279186298209, 38.91509753937417], [-76.94291835924884, 38.91517652659522], [-76.94305875963954, 38.91521023035498], [-76.94314318151329, 38.91521333023335], [-76.94328395021327, 38.915260544125296], [-76.94333316711105, 38.915426416317764], [-76.94335407809423, 38.91545309964972], [-76.94342434341745, 38.91547896030123], [-76.94364936959948, 38.915457192733236], [-76.94370554484746, 38.91541571041085], [-76.94376900453409, 38.91531103469607], [-76.94386023024782, 38.915246441259576], [-76.94411344376684, 38.91517464639749], [-76.94414128884571, 38.91515165625776], [-76.94412752306228, 38.91503024566208]], [[-76.94663670809368, 38.91323590184018], [-76.94667865312924, 38.91310905690341], [-76.94665760111056, 38.91305084104632], [-76.94660126147087, 38.91302024392407], [-76.94653115604778, 38.91305294916757], [-76.94649588729142, 38.91310760023195], [-76.94650279443765, 38.91320209369412], [-76.94640452862701, 38.913325372985575], [-76.94642570461322, 38.913388092119234], [-76.94653114975958, 38.91340886008761], [-76.94657327176327, 38.913367610026], [-76.94663670809368, 38.91323590184018]], [[-76.94668567795476, 38.91265391480964], [-76.94669245933683, 38.91255919274884], [-76.94668570310758, 38.91250974869713], [-76.94656605020668, 38.912430650864316], [-76.9464535335224, 38.91242802198053], [-76.94643265757352, 38.9124554019299], [-76.94642540098265, 38.91255914172298], [-76.94656632509115, 38.912664916803], [-76.94660823509243, 38.91266872276536], [-76.94668567795476, 38.91265391480964]], [[-76.94667142887772, 38.9128974331187], [-76.94669973748726, 38.9128519091891], [-76.94669250604923, 38.91281148290301], [-76.9466221275383, 38.912794636047416], [-76.9465592266038, 38.91282722186912], [-76.94652383567654, 38.9128773688744], [-76.94660130459002, 38.91290310814288], [-76.94667142887772, 38.9128974331187]], [[-76.94806278989543, 38.910927974507636], [-76.94806300908436, 38.91089643421767], [-76.94803465645735, 38.91087438214892], [-76.94790109763586, 38.91082705419797], [-76.9478658998464, 38.91080511534592], [-76.94782382186018, 38.910729229625005], [-76.94775356013024, 38.91070337143682], [-76.94764129227929, 38.910709749133716], [-76.94738834286494, 38.91079055934093], [-76.94719164415707, 38.910951522419445], [-76.94713504490429, 38.911069601574695], [-76.94704370600282, 38.91112969237183], [-76.947064899057, 38.91121944367423], [-76.94717730884177, 38.91124459918241], [-76.94731802723608, 38.91122423040716], [-76.94743024208641, 38.91113675924252], [-76.94762037860114, 38.911038977735366], [-76.94806278989543, 38.910927974507636]], [[-76.94833037017078, 38.91258141904003], [-76.94834427788801, 38.912549650916965], [-76.94831625584104, 38.912487045675896], [-76.94819671702618, 38.91239893789361], [-76.94790861383983, 38.912354188819876], [-76.94771155580585, 38.912343961954015], [-76.94731114793763, 38.91225152936123], [-76.94716335620878, 38.912290036548825], [-76.94705798382594, 38.91237739305646], [-76.94709320856487, 38.91243987886782], [-76.94740943620613, 38.912524705566625], [-76.94758543683155, 38.91264791473833], [-76.9477116698919, 38.912690859552455], [-76.94813361307243, 38.91266129187703], [-76.94827420121102, 38.912622903718066], [-76.94833037017078, 38.91258141904003]], [[-76.94837237719011, 38.91202207390089], [-76.94837926098013, 38.91190482463391], [-76.94832315130915, 38.911856203537695], [-76.94825288688426, 38.91183034576007], [-76.94816851890943, 38.911723629291714], [-76.94819643944676, 38.911637564417745], [-76.94825284556178, 38.91159157135436], [-76.94823850755152, 38.91134402444495], [-76.94832305069784, 38.91118042633656], [-76.94832325102216, 38.91112185520447], [-76.9482597949288, 38.91104182126333], [-76.94823181150939, 38.91103327809718], [-76.94818955026685, 38.91104299418358], [-76.94795046814555, 38.91120917121004], [-76.94771170762114, 38.91132128050906], [-76.94759219395911, 38.91144491536082], [-76.94753590193014, 38.91148189638171], [-76.94714244073403, 38.911538018640385], [-76.94698777868986, 38.91153609361062], [-76.94680491224075, 38.91155716478529], [-76.94669230033504, 38.9115905794825], [-76.94660819287162, 38.91169109678584], [-76.94657300496362, 38.91186738599438], [-76.94653091080771, 38.911949180459565], [-76.94648171726614, 38.91200856942562], [-76.94637630984899, 38.91204186368419], [-76.94630604542412, 38.91201600387725], [-76.94625686086569, 38.91190419484344], [-76.94625678181394, 38.911782555714026], [-76.94627763889821, 38.91172814548066], [-76.94624264322968, 38.911647635509915], [-76.94589816447103, 38.9115047073696], [-76.94553957767089, 38.91126740535366], [-76.94527946509047, 38.91123119451583], [-76.94499846218812, 38.91101061864059], [-76.94485794681307, 38.910972412726736], [-76.94471014699937, 38.91099740126165], [-76.94433765607522, 38.91117480429842], [-76.94422543763164, 38.911262272620185], [-76.94416922914598, 38.91143440666893], [-76.94424649953177, 38.911532233764945], [-76.9444222126963, 38.91159237939097], [-76.94483678609824, 38.911689090677065], [-76.94490729486489, 38.911723957818126], [-76.9450054609625, 38.911821436417384], [-76.9451319554326, 38.91190042169268], [-76.94538523452864, 38.91195026249615], [-76.94572962704902, 38.91195803666302], [-76.94579977559124, 38.911992909962834], [-76.94590538512931, 38.91208575739272], [-76.94614430016395, 38.91220341387058], [-76.94642557435749, 38.91227531169353], [-76.94658001092452, 38.91229526287215], [-76.94679085360653, 38.91226922002294], [-76.94726183761505, 38.912135216418534], [-76.9474374995756, 38.912114265641485], [-76.94756418898012, 38.91212116186095], [-76.94799280035501, 38.912190596534714], [-76.94823892616644, 38.91213693173558], [-76.94830914387893, 38.912095212612364], [-76.94837237719011, 38.91202207390089]], [[-76.94890672117224, 38.91340075196929], [-76.94916695861849, 38.913256744643654], [-76.94896314076196, 38.9130258790966], [-76.94887843861383, 38.912959715068965], [-76.94863246192274, 38.912887233591356], [-76.94852012669814, 38.912799006081066], [-76.9484076001324, 38.91278286379622], [-76.94809135721978, 38.912855720733276], [-76.94782418298291, 38.91286468446664], [-76.94757125872141, 38.912814842907295], [-76.94739576923739, 38.912736677856884], [-76.94728311960246, 38.91271603201375], [-76.9470794167303, 38.91264734646502], [-76.94704423690716, 38.912652438557295], [-76.94689644338166, 38.91269094552733], [-76.94682600468361, 38.912764205172444], [-76.94686854170894, 38.912988754191346], [-76.94686129499955, 38.91310601005553], [-76.94680509010718, 38.913278145224645], [-76.94667886692827, 38.913433426981534], [-76.94659436869772, 38.91349340394147], [-76.94643962400855, 38.91355455233156], [-76.94580712560689, 38.91370025476095], [-76.94563134417041, 38.91373021622406], [-76.94552605622921, 38.9137680131527], [-76.94539223869292, 38.91388287445272], [-76.94537820521154, 38.91391013781172], [-76.94539227193059, 38.91393693494696], [-76.9454486205534, 38.91398104835804], [-76.94555407468292, 38.91401533143242], [-76.94571582443469, 38.91401263480721], [-76.94606038583832, 38.914078973294515], [-76.94626410847339, 38.91398997700077], [-76.9469248570941, 38.913888852751526], [-76.94695270127465, 38.913865862894255], [-76.94693861479269, 38.913812035802415], [-76.94687542280401, 38.91376803831566], [-76.94686121415117, 38.913709706969634], [-76.94686840067344, 38.913682556068274], [-76.94695975304964, 38.9136359799883], [-76.94714263297348, 38.913628424085], [-76.94741679520493, 38.91365088070254], [-76.94756460040853, 38.91362588890801], [-76.9479158767189, 38.91350289112641], [-76.94799296833996, 38.91350160501285], [-76.94820398349852, 38.91354764017489], [-76.94840086636101, 38.91347226973486], [-76.94867479143724, 38.91349923269245], [-76.94885752044414, 38.913446625034496], [-76.94890672117224, 38.91340075196929]], [[-76.94968705082863, 38.912941704446446], [-76.94970790701457, 38.91288729370368], [-76.94963052164442, 38.91281199875144], [-76.94941984874401, 38.912738928579884], [-76.94918756237783, 38.91266622040627], [-76.94908240109909, 38.91270852354335], [-76.94906118468872, 38.91276294001496], [-76.94932840473965, 38.91299274676393], [-76.94944104539145, 38.91299987565833], [-76.94951128286687, 38.912985187996235], [-76.94960959988147, 38.91294299755992], [-76.94968705082863, 38.912941704446446]], [[-76.95038278074482, 38.91257867552847], [-76.95039681063292, 38.91255140956107], [-76.95037551786575, 38.91249770239669], [-76.9502212322157, 38.91235160956123], [-76.9502068789341, 38.91226174645458], [-76.95022804683545, 38.912139752851914], [-76.95019990980411, 38.91208616070921], [-76.95004524596334, 38.912084239888195], [-76.949932549616, 38.912167215393104], [-76.94981352104422, 38.912295349546504], [-76.94974990145748, 38.912327948878136], [-76.94960260380203, 38.91238447168571], [-76.94934926272224, 38.912424744438184], [-76.94929333181601, 38.91246172075463], [-76.94930033687861, 38.91252017055578], [-76.94932845324867, 38.91254673265814], [-76.9494898966749, 38.912625129980206], [-76.94975026258024, 38.91267033741599], [-76.94984140295401, 38.91266881503111], [-76.9499608968531, 38.91268934345887], [-76.95018567510013, 38.91267207299064], [-76.9503337039842, 38.912629052674916], [-76.95038278074482, 38.91257867552847]], [[-76.95082563940011, 38.913418250126256], [-76.95083268219192, 38.91335956411182], [-76.9507763748916, 38.913040636648184], [-76.95073418820924, 38.9129872800429], [-76.95066391300455, 38.912947907896125], [-76.95055152837263, 38.91296330153582], [-76.95054434185035, 38.91299045271229], [-76.95063581729573, 38.91311957443413], [-76.95066409626088, 38.913204700880975], [-76.95065719630118, 38.91329491997084], [-76.95061488924456, 38.91340825687164], [-76.9505658789593, 38.91355324175484], [-76.95064286637577, 38.9135744807834], [-76.95077646741808, 38.91350467001714], [-76.95082563940011, 38.913418250126256]], [[-76.95384731060614, 38.90938511560918], [-76.95389621848346, 38.909276172592385], [-76.95387505866695, 38.90924048500134], [-76.95381212269814, 38.90921901260223], [-76.95360801288918, 38.90924045005048], [-76.95317935031032, 38.90940530596432], [-76.9529824431933, 38.90942662172775], [-76.95277164183378, 38.90949322173868], [-76.95238517492047, 38.90956726478338], [-76.95225181911822, 38.90963256799353], [-76.95201290498188, 38.90984380307657], [-76.95173157599109, 38.91001970542811], [-76.95169667284905, 38.910074351138924], [-76.95168233394048, 38.9101692002402], [-76.95178792281729, 38.910392694281796], [-76.95197064194271, 38.91066896024316], [-76.95211152023714, 38.91070715024328], [-76.952146699162, 38.91070205731243], [-76.95220282500263, 38.9106065092209], [-76.95223768772048, 38.91049780084716], [-76.95232222008704, 38.91033420008931], [-76.95238548034766, 38.91014392412153], [-76.95242061974662, 38.9100847691611], [-76.9525539351247, 38.90996540428696], [-76.95264539170545, 38.9099098113335], [-76.95271575853829, 38.90991314001968], [-76.95287748583215, 38.91005459995154], [-76.95298988573543, 38.91006623495057], [-76.9530250538805, 38.91004762524228], [-76.95327781824187, 38.9098947238971], [-76.95332712856445, 38.909839836889255], [-76.95339062059041, 38.90980273268588], [-76.95345357722049, 38.909693554043905], [-76.95384731060614, 38.90938511560918]], [[-76.96147421487915, 38.89433148973011], [-76.96149516898146, 38.89426806578211], [-76.96145286282315, 38.89421020852714], [-76.96136852449271, 38.89427469875207], [-76.96136857030679, 38.894328759496496], [-76.96144613623831, 38.89434547789328], [-76.96147421487915, 38.89433148973011]], [[-76.9617125603819, 38.89340842427931], [-76.9617268947989, 38.893327090182396], [-76.96170547716588, 38.89326888257393], [-76.96167737516885, 38.89325583948208], [-76.9616072302199, 38.89335162766893], [-76.9616001308342, 38.893473386474135], [-76.96163556038901, 38.893490812634134], [-76.9617125603819, 38.89340842427931]], [[-76.96226123428946, 38.893890268634486], [-76.96227520938032, 38.89380894068277], [-76.96218379951196, 38.89374740472433], [-76.96216934741567, 38.89369358475094], [-76.96223960465404, 38.893588784713835], [-76.96219742156492, 38.89353543026839], [-76.96202194106407, 38.893430255241476], [-76.9618743891854, 38.8935543764113], [-76.96175471562323, 38.89370956427498], [-76.96167778480063, 38.893873044632045], [-76.96166360309724, 38.89427424429538], [-76.96169906858465, 38.89433221686012], [-76.96177613864613, 38.89433092131012], [-76.96185354557585, 38.894302589800056], [-76.96195922158924, 38.89420169829375], [-76.96202240010317, 38.89410152258986], [-76.96217008852578, 38.89399542060684], [-76.96226123428946, 38.893890268634486]]]}, \"attributes\": {\"OBJECTID\": 1, \"state\": \"DC\", \"region\": \"03\", \"organizationid\": \"DOEE\", \"reportingcycle\": 2020, \"assessmentunitidentifier\": \"DCANA00E_01\", \"assessmentunitname\": \"ANACOSTIA DC\", \"ircategory\": \"4A\", \"isassessed\": \"Y\", \"isimpaired\": \"N\", \"on303dlist\": \"Y\", \"hastmdl\": \"Y\", \"hasotherplan\": \"N\", \"visionpriority303d\": \"Y\", \"drinkingwater_use\": null, \"ecological_use\": \"Not Supporting\", \"fishconsumption_use\": \"Not Supporting\", \"recreation_use\": \"Not Supporting\", \"other_use\": \"Fully Supporting\", \"abnormalflow\": null, \"acidity\": null, \"ammonia\": null, \"bacteriaandothermicrobes\": \"Cause\", \"biologicalpoisons\": null, \"causeunknown\": null, \"chlorine\": null, \"degradedaquaticlife\": null, \"degradedhabitat\": null, \"dioxins\": null, \"excessalgae\": \"Cause\", \"excessaquaticweeds\": null, \"excesssediment\": null, \"fishkills\": null, \"fishunsafetoeat\": null, \"lowoxygen\": \"Cause\", \"mercury\": null, \"metalsotherthanmercury\": \"Cause\", \"murkywater\": \"Cause\", \"nitrogenandphosphorus\": \"Cause\", \"nuisanceplantsoranimalsforeign\": null, \"nuisanceplantsoranimalsnative\": null, \"oilandgrease\": \"Cause\", \"pcbs\": \"Cause\", \"pesticides\": \"Cause\", \"pollutedothercause\": null, \"radiation\": null, \"salts\": null, \"tastecolorandodor\": null, \"temperature\": null, \"totaltoxicchemicals\": null, \"toxicinorganicchemicals\": null, \"toxicorganicchemicals\": \"Cause\", \"trash\": \"Cause\", \"Shape_Length\": 29490.07097772748, \"Shape_Area\": 1796695.9579795303}}, {\"geometry\": {\"rings\": [[[-77.02240907409976, 38.85666456235], [-77.02211986598563, 38.85677769652329], [-77.02201787036995, 38.85691461879622], [-77.02189107496423, 38.857002412770605], [-77.02183476856221, 38.85712502783194], [-77.02183483683419, 38.85716557395779], [-77.01861958676926, 38.86154168169349], [-77.0184932117751, 38.861453762519034], [-77.01835243858355, 38.86136609295306], [-77.01820493251896, 38.86126952857897], [-77.01814888393342, 38.86126148655488], [-77.0180853586698, 38.86123104898586], [-77.01782563236496, 38.86119048559231], [-77.01781157193412, 38.86117721277484], [-77.01771292074626, 38.861165402588306], [-77.017699263659, 38.86117915385895], [-77.01753738634648, 38.86117294169006], [-77.01736871327884, 38.861193876718055], [-77.01735446330349, 38.86121214388722], [-77.01731245358921, 38.861203859133774], [-77.0169819283619, 38.86130868385714], [-77.0166868919782, 38.86147146163805], [-77.01667259978201, 38.86146269916521], [-77.01661648831443, 38.86149069892397], [-77.01617352904785, 38.861746134221285], [-77.0161311806687, 38.861751371259224], [-77.01569516448095, 38.86199767388689], [-77.01548422478086, 38.86207790439436], [-77.01538597603825, 38.86209311530494], [-77.01534403010436, 38.86212537535105], [-77.01533662079991, 38.86222011222182], [-77.01532247592745, 38.86222936703484], [-77.01532836707908, 38.86404485532345], [-77.01531413776496, 38.86407663745146], [-77.01528606002245, 38.86407712147866], [-77.01524417517403, 38.86407333949151], [-77.01469578064253, 38.864064783680426], [-77.01469586418584, 38.863965668534924], [-77.01438662184424, 38.863957488322214], [-77.01435862764504, 38.8639354454596], [-77.01435153364923, 38.8638499696732], [-77.01425325885546, 38.86377507667863], [-77.01419682758763, 38.86375352408406], [-77.01385256172972, 38.86352519334287], [-77.01379663890833, 38.863521653341884], [-77.01355736185263, 38.86351676966504], [-77.0129741171797, 38.86354935221872], [-77.01272799945309, 38.86354458535468], [-77.0124326288961, 38.86358121360788], [-77.01212353747145, 38.863591046702155], [-77.01203214467107, 38.863619652759034], [-77.01174405406114, 38.863786803195474], [-77.01172976096665, 38.86377803960907], [-77.0114415625589, 38.86395420224759], [-77.01131504024103, 38.86400143483396], [-77.01131506090226, 38.8640149498375], [-77.0111108864146, 38.864131096785066], [-77.01111080107464, 38.864153623613696], [-77.01092803254188, 38.86430093753764], [-77.01085762079329, 38.86439675986652], [-77.01083661279205, 38.86446920480483], [-77.01083641785763, 38.86457733174387], [-77.01078745787802, 38.864654763616606], [-77.01071687814445, 38.86471905194842], [-77.01054797151485, 38.86498776664175], [-77.01037940444841, 38.865242959956255], [-77.01024555547109, 38.86520922268715], [-77.01008401862005, 38.86543275890035], [-77.0102031909223, 38.8655208109458], [-77.01018232844814, 38.86561127387314], [-77.01006250396901, 38.865883648179846], [-77.00997114889788, 38.8659392832918], [-77.00982340208478, 38.866000394294474], [-77.00968277082706, 38.8660839083599], [-77.00953496921673, 38.86634775329705], [-77.00935908986388, 38.86661208126496], [-77.00912729307954, 38.867039557972], [-77.00897252233923, 38.86729901743639], [-77.00879691607425, 38.86750927754166], [-77.00879683073427, 38.86753180469873], [-77.00876866405855, 38.8675548151528], [-77.00873333421674, 38.86768156870579], [-77.00868420265891, 38.86772746571119], [-77.00850170451903, 38.867744121125], [-77.00838893361153, 38.867845175402245], [-77.00816405654984, 38.867930137205164], [-77.00812168211957, 38.867921855332774], [-77.00805854492813, 38.86807161222332], [-77.00812219326097, 38.86818314755683], [-77.00810092205334, 38.86832317427316], [-77.00797390476374, 38.8686091859086], [-77.00789679248143, 38.86872314177531], [-77.00770693264784, 38.868875077750914], [-77.00749595791346, 38.8690318820124], [-77.00748179866795, 38.86919431268902], [-77.00751006595502, 38.86923887843903], [-77.00750326031842, 38.869342614924946], [-77.00751744741169, 38.86936039111343], [-77.00752402218126, 38.86950444410024], [-77.00751036239905, 38.86951819515688], [-77.00750296207774, 38.86962644660473], [-77.00745409462459, 38.8697714530411], [-77.0074260348484, 38.86978545093605], [-77.00741876837606, 38.86982161716443], [-77.0073132531611, 38.86996309191525], [-77.00715176931067, 38.87007399272079], [-77.0071516830724, 38.87009652116336], [-77.00712347507418, 38.870092500300935], [-77.00691262251068, 38.870253806715674], [-77.00691253627241, 38.870276333702435], [-77.00688445493664, 38.870276816988024], [-77.00683521378433, 38.87033172478319], [-77.00680713244856, 38.8703322080684], [-77.00632202782208, 38.87079557006121], [-77.006188846293, 38.87097806650253], [-77.00618876005473, 38.87100059325978], [-77.00616046581824, 38.87101909989926], [-77.00608297983678, 38.871209649954835], [-77.00592834384376, 38.871410535072606], [-77.00568976388072, 38.87157231547863], [-77.0056543747501, 38.871581933455055], [-77.00558435736191, 38.87162818812647], [-77.00548611131423, 38.871656907047665], [-77.00545794374017, 38.87167991756521], [-77.0051911611688, 38.871761088311004], [-77.00501573636348, 38.87186321532893], [-77.00473561560673, 38.872097790652624], [-77.00473589767775, 38.872210415599326], [-77.00472187587447, 38.87222417172758], [-77.00472213997917, 38.872323280254946], [-77.00462372864146, 38.872320465249906], [-77.00460284640437, 38.8723208247313], [-77.00451150840124, 38.87231338262674], [-77.00419545772807, 38.87243594261083], [-77.00416728925573, 38.87245895287617], [-77.00337973265286, 38.872760802722766], [-77.00338689222569, 38.873067031459485], [-77.00336566952711, 38.873080911910215], [-77.00318290279097, 38.87308855255623], [-77.00318306089446, 38.87286329058041], [-77.00316900046363, 38.87285001644527], [-77.00301482261142, 38.87287518764435], [-77.00290884835735, 38.87287250134611], [-77.0029086453381, 38.872813936382165], [-77.00290905766481, 38.872597681517775], [-77.0028666625733, 38.87257588261946], [-77.00248041574721, 38.872623054926265], [-77.00226944191117, 38.87262667350371], [-77.00225554677034, 38.87264493283974], [-77.00217083384241, 38.87265539551831], [-77.00214997855478, 38.87275937249916], [-77.00217093625037, 38.87281307545113], [-77.00215678868295, 38.87282232888521], [-77.0021566503424, 38.87289441345217], [-77.00217071077323, 38.8729076889778], [-77.00216425637791, 38.87301141871077], [-77.00214269321783, 38.87303881945419], [-77.00196734117606, 38.873028310673426], [-77.00196718846246, 38.87292018959429], [-77.0019462559197, 38.8727133094936], [-77.00190360840159, 38.872682504758956], [-77.00155971624284, 38.8727244428639], [-77.00154510065316, 38.8727427140642], [-77.00147500331492, 38.87273490553076], [-77.00146098061333, 38.87274866085807], [-77.00139088327509, 38.87274085302467], [-77.00138406236712, 38.872754484561284], [-77.00101115192975, 38.87281493998571], [-77.00099700436235, 38.87282419272017], [-77.00094083989416, 38.87282515506041], [-77.00092669142842, 38.87283440779353], [-77.00085612696623, 38.87283561771245], [-77.00084197939883, 38.87284487044421], [-77.0004412014247, 38.87288777988467], [-77.00042046381635, 38.872906155949146], [-77.00025173864645, 38.87291355253231], [-77.00024462668435, 38.87289114807248], [-76.99972406375696, 38.872836994082604], [-76.99960453482359, 38.87283904115342], [-76.99920413144693, 38.87280535154981], [-76.99892311237492, 38.8727515968382], [-76.99845934273647, 38.87262888563355], [-76.99889474986647, 38.87245924451712], [-76.9987960636443, 38.87234380006489], [-76.99812212326363, 38.872549060083095], [-76.99753169925494, 38.87239247059654], [-76.99831819764238, 38.87209067863324], [-76.99814975993336, 38.87204400463305], [-76.99727179688031, 38.87233384509035], [-76.99680083263472, 38.872211250660534], [-76.9975101980786, 38.87193330972244], [-76.9973277026337, 38.87187335990258], [-76.99648475052054, 38.872140069002214], [-76.9958663592621, 38.87197493984132], [-76.99666691987701, 38.87168643374851], [-76.99644912603132, 38.87161357093741], [-76.99562087933936, 38.87192957850889], [-76.9950373049847, 38.87177286106878], [-76.99575376622101, 38.87150381953051], [-76.99553572264368, 38.87142194770311], [-76.99469998579889, 38.871702037057204], [-76.99432785330255, 38.87162279585277], [-76.99425881777296, 38.872889933958305], [-76.99420245477708, 38.87292243318685], [-76.9941602258739, 38.872842061054826], [-76.99404658988877, 38.871560023042576], [-76.9928032766198, 38.87126588866905], [-76.99126548571921, 38.872125588997285], [-76.99089313044067, 38.87215446507835], [-76.99082992497728, 38.87218708004116], [-76.99073887623167, 38.872409387184575], [-76.99073210293442, 38.87246356527912], [-76.98782486182422, 38.87416650974413], [-76.98614675497457, 38.875114130529525], [-76.98603436046118, 38.875165600069565], [-76.98592138833104, 38.875235099555006], [-76.98512112056692, 38.87564066280784], [-76.9841939352262, 38.876106944918476], [-76.98343617933457, 38.87644870108054], [-76.98265667433164, 38.87666918151263], [-76.98226323379674, 38.876756955990075], [-76.98208064043547, 38.87682312927676], [-76.981862371381, 38.876862876018514], [-76.98144103097002, 38.87700968945711], [-76.98111083093283, 38.877091882135964], [-76.9808230214956, 38.87719588059967], [-76.98068250612053, 38.877220790108225], [-76.97957269957075, 38.877559483449296], [-76.97944572899354, 38.8775942904239], [-76.97667228655503, 38.87620361641971], [-76.97854554521363, 38.87565768212616], [-76.97971901177434, 38.87527737184229], [-76.97997860692514, 38.87516934999576], [-76.98038625790949, 38.87502277473162], [-76.98072338575417, 38.87491794085583], [-76.98185393620048, 38.87449779115138], [-76.98252835358656, 38.8742295439116], [-76.98314627143283, 38.873989283502155], [-76.98354641160311, 38.87379326766286], [-76.98413645921768, 38.8735354544364], [-76.98438224995753, 38.87343666721098], [-76.98440310075358, 38.87340928270645], [-76.98450159204134, 38.87337607174207], [-76.98474052594061, 38.87326388574921], [-76.98513370865899, 38.87307699262569], [-76.98579361735493, 38.87274139504103], [-76.9859061160729, 38.87268091297781], [-76.98624290974426, 38.872512997351706], [-76.98629207543809, 38.87248062452343], [-76.98636944823183, 38.872452275906525], [-76.98639737326074, 38.87242026532904], [-76.98660800034709, 38.87232657713279], [-76.98670655092366, 38.872243806149875], [-76.98705750473886, 38.872080150828964], [-76.98738757721529, 38.87191685111774], [-76.98759815309765, 38.871782616097654], [-76.98792127171546, 38.871628442703305], [-76.98872880595192, 38.87122724313539], [-76.98943111333261, 38.87085035576103], [-76.98985951629834, 38.87063581543848], [-76.99018949175674, 38.87040493161381], [-76.99028767492233, 38.87032216398836], [-76.99037174196157, 38.87027567836439], [-76.9906735974566, 38.87001824124675], [-76.99072996045247, 38.86998574348792], [-76.99107380949208, 38.869723083557396], [-76.99121432935873, 38.86962157243951], [-76.99136871202681, 38.8694747731143], [-76.99155828439953, 38.869349899274056], [-76.99188807031338, 38.86907396145429], [-76.99216890433244, 38.86890247729117], [-76.99264673440176, 38.86869158903466], [-76.99296953771089, 38.86859147038157], [-76.99368564680762, 38.86843958205965], [-76.99428980695531, 38.86839322179938], [-76.99490087694419, 38.86840080279932], [-76.99532940657238, 38.86848808810378], [-76.99554737019965, 38.86851589905078], [-76.99580045166634, 38.86860167697082], [-76.99615876358203, 38.868676645313826], [-76.99615163545026, 38.868730829051195], [-76.99636281410218, 38.868979509284856], [-76.99655952179323, 38.86908427008843], [-76.99669983504734, 38.86910439636517], [-76.99698805591298, 38.869081445163346], [-76.99726857192844, 38.86895050112365], [-76.99752162105577, 38.869009244823474], [-76.99806253262095, 38.86913514389999], [-76.99835759595412, 38.869202176864924], [-76.99889181507042, 38.869346207791224], [-76.99946068669884, 38.86946711739223], [-76.99962949720872, 38.869527299346636], [-76.9997209394164, 38.8695257319741], [-76.99981927799057, 38.86956459524911], [-77.00002290181098, 38.86963319028341], [-77.00026236391963, 38.869669634253505], [-77.00030452275422, 38.86969594311364], [-77.00034664385959, 38.86969522132664], [-77.00039587602873, 38.86971690290887], [-77.0004872104386, 38.86972434948173], [-77.00050126997112, 38.86973762280182], [-77.00069823278368, 38.86976127949184], [-77.00071205785592, 38.86977906326901], [-77.00079640786444, 38.86976860716113], [-77.00081046649866, 38.86978188187178], [-77.00122532376821, 38.869779275888185], [-77.00159800333857, 38.86973684576226], [-77.0018228058401, 38.86967442378724], [-77.00193543211884, 38.86963194603906], [-77.00196327899434, 38.869635973921625], [-77.00230806318018, 38.86947237904017], [-77.00249092064614, 38.86936562409347], [-77.00310952750024, 38.86884592476832], [-77.00347496485277, 38.86844319805241], [-77.00352425631073, 38.868338732857836], [-77.00356621212606, 38.868306475630995], [-77.00357313993355, 38.868283831916294], [-77.003615455075, 38.86825156906913], [-77.00361563114481, 38.86820651380515], [-77.0040586083777, 38.867487090299285], [-77.00427684509282, 38.86720402224886], [-77.0048254911526, 38.86637465721002], [-77.00534621218345, 38.865577305961416], [-77.00537463128578, 38.86556330304115], [-77.00560677841308, 38.86519890020152], [-77.00636656719219, 38.86402801088783], [-77.00676082249903, 38.8634220443145], [-77.00678913380351, 38.86341705291277], [-77.00678884005441, 38.86338101632504], [-77.00683123873921, 38.8633262255682], [-77.00685222338423, 38.86331685478615], [-77.00714057809886, 38.862915440435394], [-77.00717568875176, 38.86288330035767], [-77.0071970803336, 38.86282436553591], [-77.00831523492732, 38.86173290137814], [-77.00855435028626, 38.86155308541612], [-77.00910278973352, 38.86120576034626], [-77.01005898436973, 38.86072076204756], [-77.01012951649257, 38.86070603209559], [-77.01054439083013, 38.8605141759058], [-77.01061456272855, 38.86049945220645], [-77.01117007461204, 38.86023759312834], [-77.01120518256997, 38.86020545184018], [-77.01123325851586, 38.86020496778662], [-77.01136705988249, 38.86013508566865], [-77.0114722732635, 38.86012426300323], [-77.01147259126712, 38.860097225918516], [-77.01155674005305, 38.860041713544234], [-77.01158494266139, 38.86004573287664], [-77.01162712305555, 38.860008965000425], [-77.01165519989976, 38.860008480945524], [-77.01171861646723, 38.85997134651122], [-77.0117885323458, 38.85994761591384], [-77.0118870784308, 38.859891855798935], [-77.011957608757, 38.85987712497569], [-77.0120278444358, 38.85982635785862], [-77.01205604794247, 38.85983037650369], [-77.01208395590339, 38.859798359543035], [-77.01215461289209, 38.8597881314043], [-77.01215433800759, 38.859765609488164], [-77.01218254151425, 38.85976962953564], [-77.01245687262897, 38.859638755782974], [-77.01249881856286, 38.85960649670725], [-77.01252689630537, 38.859606012649614], [-77.01254101871996, 38.85958324235133], [-77.01256932912614, 38.85957824998061], [-77.01285752663559, 38.85941559937307], [-77.01289949412904, 38.85939685537793], [-77.01320208983586, 38.85923395672937], [-77.01328644613261, 38.85916041871945], [-77.01332858250933, 38.8591732085523], [-77.01335687045763, 38.85915469952849], [-77.01338486196188, 38.85910015454059], [-77.01354658745912, 38.859011766472996], [-77.01365192660428, 38.85892885617342], [-77.0136662394617, 38.85887454744749], [-77.01358897716074, 38.85880379732533], [-77.01358891338036, 38.85876325143398], [-77.01382811138433, 38.85857441330802], [-77.0138561873302, 38.85857392854383], [-77.01389163125806, 38.85852826556326], [-77.01393359695487, 38.85850952133422], [-77.01413768879753, 38.85835282467455], [-77.01416574228553, 38.858338824528516], [-77.01432729530623, 38.85821890260918], [-77.01441173424799, 38.85819942520261], [-77.0145733528457, 38.85827322442717], [-77.01474932113177, 38.85808998046186], [-77.01514311470457, 38.857560582337236], [-77.01529079414402, 38.85731925826903], [-77.01531884763202, 38.85730525931859], [-77.0158608111244, 38.856399369848276], [-77.0165503417668, 38.85512150472927], [-77.01722589552172, 38.853821350289984], [-77.01742334791611, 38.853430491954455], [-77.0177823650093, 38.852716973042945], [-77.01801459747655, 38.852321008023566], [-77.01809158938461, 38.85215298484464], [-77.01814788051526, 38.85209344508832], [-77.01822531529274, 38.85190288787104], [-77.01825370385235, 38.85187536564912], [-77.01863383494798, 38.85117049064073], [-77.01863366426808, 38.85113895669495], [-77.01866886924405, 38.85109780198892], [-77.01873226964187, 38.85098407602201], [-77.01890807353622, 38.85064314678513], [-77.01903478989023, 38.85043822159086], [-77.01905578621334, 38.85036577565016], [-77.01909806182893, 38.85031999266557], [-77.0191473191509, 38.8502155218316], [-77.01917547504685, 38.85019250856461], [-77.01918258521233, 38.85013832329258], [-77.01921050844462, 38.85011981961297], [-77.01923165478641, 38.8500653915247], [-77.01925993734481, 38.85004688152978], [-77.01928802676544, 38.84998332360767], [-77.01973796953506, 38.84913757507064], [-77.01989273847872, 38.8492880746292], [-77.02008941742365, 38.849316208608634], [-77.02027232339866, 38.84921392956989], [-77.02046887657946, 38.849021309885885], [-77.02060264111515, 38.84887482902703], [-77.0207995437406, 38.84860561618586], [-77.02082773646748, 38.84853304524673], [-77.02082756399093, 38.84850151083138], [-77.02079264647584, 38.84842552706307], [-77.02072935746914, 38.848313992919465], [-77.02063118867655, 38.848293166038516], [-77.02051851838037, 38.848281599977426], [-77.0204061256636, 38.848292555273325], [-77.02020947995632, 38.848354525178706], [-77.02031492240775, 38.848276112184394], [-77.0205188139261, 38.84802479893453], [-77.0205752209394, 38.84789317176588], [-77.02057519219332, 38.847803068990764], [-77.02058933257422, 38.84779381299989], [-77.02058216581487, 38.847667792180076], [-77.0205751787186, 38.847649891632365], [-77.02056825989429, 38.8474562889384], [-77.02064551770366, 38.847310785732944], [-77.0207231195678, 38.8472283487331], [-77.02075806672728, 38.84717818685982], [-77.02240907409976, 38.85666456235]]]}, \"attributes\": {\"OBJECTID\": 4, \"state\": \"DC\", \"region\": \"03\", \"organizationid\": \"DOEE\", \"reportingcycle\": 2020, \"assessmentunitidentifier\": \"DCANA00E_02\", \"assessmentunitname\": \"ANACOSTIA DC\", \"ircategory\": \"4A\", \"isassessed\": \"Y\", \"isimpaired\": \"N\", \"on303dlist\": \"Y\", \"hastmdl\": \"Y\", \"hasotherplan\": \"N\", \"visionpriority303d\": \"Y\", \"drinkingwater_use\": null, \"ecological_use\": \"Not Supporting\", \"fishconsumption_use\": \"Not Supporting\", \"recreation_use\": \"Not Supporting\", \"other_use\": \"Fully Supporting\", \"abnormalflow\": null, \"acidity\": null, \"ammonia\": null, \"bacteriaandothermicrobes\": \"Cause\", \"biologicalpoisons\": null, \"causeunknown\": null, \"chlorine\": null, \"degradedaquaticlife\": null, \"degradedhabitat\": null, \"dioxins\": null, \"excessalgae\": \"Cause\", \"excessaquaticweeds\": null, \"excesssediment\": null, \"fishkills\": null, \"fishunsafetoeat\": null, \"lowoxygen\": \"Cause\", \"mercury\": null, \"metalsotherthanmercury\": \"Cause\", \"murkywater\": \"Cause\", \"nitrogenandphosphorus\": \"Cause\", \"nuisanceplantsoranimalsforeign\": null, \"nuisanceplantsoranimalsnative\": null, \"oilandgrease\": \"Cause\", \"pcbs\": \"Cause\", \"pesticides\": \"Cause\", \"pollutedothercause\": null, \"radiation\": null, \"salts\": null, \"tastecolorandodor\": null, \"temperature\": null, \"totaltoxicchemicals\": null, \"toxicinorganicchemicals\": null, \"toxicorganicchemicals\": \"Cause\", \"trash\": \"Cause\", \"Shape_Length\": 17251.032595546614, \"Shape_Area\": 3030722.399938932}}, {\"geometry\": {\"rings\": [[[-76.95807773958711, 38.90742654557002], [-76.95817552300241, 38.90689329202002], [-76.95825994397788, 38.9070540633121], [-76.95833720717715, 38.90712484998799], [-76.95854129722318, 38.907234054949974], [-76.95868194644721, 38.90729026235444], [-76.95875939110618, 38.90728896214762], [-76.95899849119377, 38.9071903399908], [-76.95921612334273, 38.907123615487635], [-76.95940586190378, 38.90701230485136], [-76.95975678068466, 38.906668523791545], [-76.95986221774619, 38.90654511410083], [-76.95996771050326, 38.90634511404428], [-76.96007298766467, 38.906032487741946], [-76.96010784589096, 38.90579312760195], [-76.9601781722996, 38.905611739099236], [-76.96033272744424, 38.90536135763959], [-76.96052246959856, 38.905119395442725], [-76.96083146849672, 38.904915976464956], [-76.96086689266164, 38.90491988700264], [-76.96135141697644, 38.9047045079119], [-76.9614991269586, 38.904598405692326], [-76.96185024696213, 38.90423659451918], [-76.96199087103334, 38.903990950690066], [-76.96216618983743, 38.90360506247526], [-76.96232085277991, 38.903215015456944], [-76.96241920123553, 38.902821410076236], [-76.96258077491747, 38.902512341270345], [-76.96285464250151, 38.902106774112596], [-76.96300206053122, 38.901951118033054], [-76.96317750150621, 38.901713898031744], [-76.96333238184097, 38.901580642104314], [-76.96369038563452, 38.90115563684641], [-76.96381682261244, 38.90103637510573], [-76.96415420557865, 38.90051710594675], [-76.96437868827995, 38.90008533535801], [-76.9644703101507, 38.89997116342336], [-76.96473680795616, 38.89927287833663], [-76.96475100582923, 38.89917352565412], [-76.96487016196178, 38.898842640341584], [-76.96498246035546, 38.89862900599915], [-76.96501774617981, 38.89835359505259], [-76.9651298119098, 38.897883169085425], [-76.96522129274508, 38.89775097843417], [-76.965607482079, 38.89759129909261], [-76.96566388999064, 38.89744167781777], [-76.9656777123679, 38.89732881530534], [-76.96567802408332, 38.897274747056706], [-76.96557941601458, 38.89722685073107], [-76.96556522083645, 38.89719555394508], [-76.96540362379832, 38.89705861417685], [-76.96533325786379, 38.89691112694754], [-76.965332999149, 38.89649665358556], [-76.96522759083354, 38.89609746673388], [-76.96523459589612, 38.89601174996757], [-76.96514291024498, 38.895652877615206], [-76.9651290285789, 38.89543686285015], [-76.96494592048295, 38.89487229065484], [-76.96493190227295, 38.89463825615169], [-76.9648544998348, 38.89440528919808], [-76.96486863302918, 38.894369009631376], [-76.96491754539807, 38.89389514113518], [-76.96487533535951, 38.89381475846497], [-76.964805035002, 38.89373484834227], [-76.96473464750791, 38.89369098104255], [-76.96467817132431, 38.893498208473034], [-76.96459386533321, 38.893328429099476], [-76.96461527937295, 38.89311181995697], [-76.96454482181028, 38.892856209314104], [-76.96459340359915, 38.89214807616328], [-76.96455118996734, 38.89179287600296], [-76.96462850077731, 38.89139511773203], [-76.96474778267398, 38.8910822515052], [-76.96483198446053, 38.89073843876254], [-76.96495110376215, 38.89038052354201], [-76.96515502312826, 38.89007974770182], [-76.96525326378607, 38.88986634920164], [-76.9654850839266, 38.889493020373166], [-76.96594145234543, 38.88894020650392], [-76.96611695260923, 38.88881110513275], [-76.96615919768209, 38.88880138250771], [-76.96626438770691, 38.888709507306196], [-76.96629242592357, 38.88865497240932], [-76.96644718768071, 38.88855775637355], [-76.96677729429311, 38.88816925309836], [-76.96699476025373, 38.88786373972097], [-76.96717750632861, 38.88765792679476], [-76.96736695473383, 38.88730332859566], [-76.96771767588537, 38.88689194992568], [-76.96779494537284, 38.8867284597939], [-76.96811818256828, 38.88632655392752], [-76.9682583907195, 38.88608090897735], [-76.96841279315053, 38.885866560774225], [-76.96864468695291, 38.885601348537186], [-76.96870802626529, 38.88555973339286], [-76.96880632711019, 38.88542742540567], [-76.96902414071883, 38.88525255436072], [-76.96912235622379, 38.88515628815028], [-76.96915039174547, 38.88510175262343], [-76.96929792565784, 38.88499113958582], [-76.96955084991936, 38.88475710748766], [-76.96960007849525, 38.884648151156945], [-76.9695858581643, 38.884589824554844], [-76.96947330824236, 38.88450612455248], [-76.96929063762595, 38.88440108160227], [-76.96993681647108, 38.88420096043705], [-76.97001409763664, 38.88418163489629], [-76.97005634001457, 38.884419698032595], [-76.97014079871927, 38.884621006622915], [-76.97014814424334, 38.8847695542748], [-76.97011272457, 38.88488278147832], [-76.9698391588199, 38.88524330953769], [-76.9697619944353, 38.88538427250525], [-76.96957217053432, 38.88558119826275], [-76.9694385991364, 38.8858582698039], [-76.96917190190497, 38.88612857437723], [-76.96903157248116, 38.886369717443436], [-76.96886284012473, 38.886534750924866], [-76.96849822383237, 38.88747347618188], [-76.96838611408491, 38.88773216322236], [-76.96822444697817, 38.88800970604338], [-76.9682174967128, 38.88814948393033], [-76.96814038622713, 38.88822737188922], [-76.96805590955614, 38.88826033328249], [-76.96745229288918, 38.88973019239944], [-76.96742436786026, 38.88990636553339], [-76.96743874449807, 38.890388178409644], [-76.96755801022508, 38.8905843966894], [-76.96773382849248, 38.89079317762424], [-76.96781828629886, 38.890863837875415], [-76.9681417651411, 38.89133142896447], [-76.96835985812577, 38.89155751687383], [-76.96847932597372, 38.891708678973316], [-76.96857045646605, 38.89185130786204], [-76.96869015248608, 38.892115095598456], [-76.96883066516618, 38.8924280887221], [-76.96890139132515, 38.89282335283263], [-76.96883804302962, 38.89311275405544], [-76.96875405234718, 38.89328086291909], [-76.96858540712732, 38.893554018435644], [-76.96852938818621, 38.89360001549401], [-76.96838178869682, 38.89378721750901], [-76.968297435095, 38.89395533246702], [-76.96815708411164, 38.894065823175914], [-76.96795314138932, 38.894339573458275], [-76.96737050667245, 38.89493957551041], [-76.96729317789617, 38.89504900266938], [-76.96711040217687, 38.89524130119782], [-76.96701209684039, 38.895387124414796], [-76.96697694037344, 38.89540573726698], [-76.96659078248057, 38.89610153856088], [-76.96637339377507, 38.89677647421519], [-76.96621163683682, 38.89711708924502], [-76.96613453982586, 38.8972220071235], [-76.96588872662814, 38.897284715316324], [-76.96586750303123, 38.897312103203916], [-76.96585332042953, 38.89742497203509], [-76.96588163712393, 38.897537124775724], [-76.96596597455606, 38.89760328220426], [-76.96610648543952, 38.897654978052046], [-76.96615562957379, 38.897699202256305], [-76.96618401993003, 38.897761796069595], [-76.96617686754374, 38.8979466289561], [-76.9662264482592, 38.898333241454885], [-76.96621220367375, 38.89850918351335], [-76.9662403469933, 38.898562771224526], [-76.96626862685675, 38.8987650282903], [-76.96624749039643, 38.898887025302656], [-76.96633208205179, 38.89922348934916], [-76.96636038796638, 38.89945277644545], [-76.96640962013554, 38.899591608287025], [-76.96638877203442, 38.900024457804335], [-76.96636079130995, 38.90014656940369], [-76.9663187932738, 38.90068790000786], [-76.96625567764193, 38.90098630572432], [-76.96614309538062, 38.901281038539345], [-76.96613632567664, 38.90136224677819], [-76.9660449930634, 38.90165662219516], [-76.96584831232184, 38.90215550605051], [-76.96583464984467, 38.90231341693001], [-76.96569413087636, 38.90278432387596], [-76.96551873391881, 38.90319274428831], [-76.9653358207573, 38.90339405210565], [-76.96512513528043, 38.90368593250173], [-76.96508995994886, 38.90369102943132], [-76.96490733155328, 38.90381123814758], [-76.9647950376512, 38.90390773843007], [-76.96464752170513, 38.90395527372426], [-76.96432410574496, 38.90413191350269], [-76.96380394616118, 38.90436142173185], [-76.96364954283182, 38.90462982434765], [-76.96351619062284, 38.90481227583373], [-76.96344655412031, 38.9054892258554], [-76.96336930439578, 38.90570677381955], [-76.96328511428734, 38.90581631510907], [-76.9629691103266, 38.906105457164074], [-76.96289878212133, 38.906142680739954], [-76.96274393861748, 38.906329997888406], [-76.96249132696968, 38.906892887974976], [-76.96239984164283, 38.907038592894715], [-76.96228059478045, 38.90715773200825], [-76.96200663107668, 38.90733804004628], [-76.96091722975858, 38.907901476470684], [-76.9605099003711, 38.90798941228232], [-76.96017949731467, 38.90803100310043], [-76.95946254110662, 38.90802502151211], [-76.9593218451702, 38.90805891950263], [-76.95929400727785, 38.90808191263888], [-76.95915328888353, 38.908088780590006], [-76.95889316013344, 38.90802556815253], [-76.95864007776846, 38.907917186467245], [-76.95836603860619, 38.90772806161686], [-76.95823920187796, 38.90753196130611], [-76.95816914316728, 38.907461053404234], [-76.95807773958711, 38.90742654557002]], [[-76.96199912924574, 38.90630647920147], [-76.9621956042731, 38.906217576620996], [-76.96225892921244, 38.906135419036914], [-76.96244889594557, 38.90601959589169], [-76.96246256021935, 38.90599233509425], [-76.96248397695403, 38.90590637581812], [-76.96246985813272, 38.90582551950567], [-76.96240666434743, 38.90578153104936], [-76.96222388323827, 38.90573955163897], [-76.96211140068995, 38.90576396879421], [-76.96201311331978, 38.90581968313401], [-76.96182312682369, 38.90605264060305], [-76.96154928978238, 38.9062374512091], [-76.9614509898358, 38.9062796498255], [-76.96126815482769, 38.90631425887977], [-76.96109229793272, 38.90636677116154], [-76.96098704053425, 38.90641809572788], [-76.96090283515446, 38.90651411991357], [-76.96081847256953, 38.90670925975656], [-76.96079023313024, 38.906822363907004], [-76.96079751756886, 38.90691685105686], [-76.96081163459357, 38.90699770682534], [-76.96086093952624, 38.90708698311321], [-76.96093097847402, 38.90713085821557], [-76.96104361104095, 38.907137975815075], [-76.96118404466934, 38.90708155438439], [-76.96140172892055, 38.90693823537431], [-76.96147226014507, 38.906855956991265], [-76.96167571867547, 38.90651014305453], [-76.96176030763588, 38.906441143221976], [-76.96199912924574, 38.90630647920147]], [[-76.96319353194247, 38.90517361360787], [-76.96325643467361, 38.9050238838774], [-76.96316501312712, 38.90483169852334], [-76.96317891365783, 38.904799928329986], [-76.9633055177224, 38.90472571533428], [-76.96329828897932, 38.904698806366945], [-76.96288359789807, 38.90458414132183], [-76.96284134384206, 38.90459386248541], [-76.96270771944354, 38.90474027537916], [-76.96251130819657, 38.90489675442849], [-76.96249720734154, 38.90497357962798], [-76.96252549708646, 38.905058702562165], [-76.96238482001466, 38.905106119644145], [-76.96230767269806, 38.90517048952306], [-76.9623004933623, 38.9051976415833], [-76.96232854685032, 38.905287273857], [-76.96260993243497, 38.90536363585959], [-76.9627014168635, 38.90549274768767], [-76.96277180345928, 38.90552309989084], [-76.96291949727178, 38.905534131650676], [-76.96294761633679, 38.90556069007582], [-76.96292646011355, 38.90566917112904], [-76.96302495409624, 38.90571256546122], [-76.9631586521566, 38.90564724466388], [-76.96321451119759, 38.90554268596449], [-76.96317250058502, 38.905286596472045], [-76.96319353194247, 38.90517361360787]], [[-76.96499097009614, 38.90230960272252], [-76.96511751756684, 38.902181328203596], [-76.96533542819351, 38.90204700774402], [-76.96544077452519, 38.90171184969552], [-76.96542655509256, 38.90165352172468], [-76.9653562457519, 38.90157361273235], [-76.96528573788356, 38.901538758082914], [-76.96516639490143, 38.90153626302151], [-76.96490635777953, 38.901684806059514], [-76.96475889483406, 38.90178640280305], [-76.96449200985471, 38.90206571182923], [-76.96435163731178, 38.90217619900768], [-76.96411942909906, 38.902301746405115], [-76.96406368683905, 38.90239729309132], [-76.96395823270953, 38.902754977877045], [-76.96380365420869, 38.90309546845645], [-76.96359311515725, 38.90328822825686], [-76.96354384166558, 38.90337015005231], [-76.9635298665747, 38.90345147823965], [-76.96355082966019, 38.90353221911257], [-76.9635649017691, 38.903559014573226], [-76.96363528656826, 38.903589366204955], [-76.9640147241645, 38.90362803468376], [-76.96412012349677, 38.90360823905938], [-76.96438016960184, 38.90345969724905], [-76.96444326726741, 38.90326491199324], [-76.96443615350867, 38.90309834026565], [-76.96448531471091, 38.90289477917673], [-76.96463997495842, 38.90264889581364], [-76.96478011214276, 38.90254291705602], [-76.96487892682401, 38.90241510924762], [-76.96499097009614, 38.90230960272252]], [[-76.96671600852949, 38.8932746724334], [-76.96668097153847, 38.89277518571937], [-76.96671557733816, 38.892423197942016], [-76.96675782330932, 38.892282825069145], [-76.96674357692724, 38.891936164755265], [-76.96682764306816, 38.891457197602094], [-76.96685574326857, 38.89133958994532], [-76.96715783502052, 38.89101913579795], [-76.96724910385339, 38.89080134775651], [-76.96727015048218, 38.89071539456174], [-76.96725605591537, 38.890661569494036], [-76.96723514403388, 38.890634890827265], [-76.967129341358, 38.89058711657892], [-76.96701710764306, 38.89059351356295], [-76.96671517668953, 38.89056706490759], [-76.96650418219224, 38.89061116557197], [-76.96587191825085, 38.89087410699065], [-76.96581578971528, 38.89092911354026], [-76.9657595839246, 38.89103367977512], [-76.96573842320976, 38.89112864590874], [-76.9657811381015, 38.892024460145045], [-76.96585135042412, 38.89240171416407], [-76.96597111291948, 38.89274659698995], [-76.96597815391468, 38.892962728310074], [-76.96601324749957, 38.89313784046862], [-76.96602077358503, 38.89388107038146], [-76.96598549225224, 38.89402583016246], [-76.96602081131427, 38.89431356737014], [-76.96605591927221, 38.894371544097794], [-76.96618262664302, 38.8944324824306], [-76.96630195794704, 38.89443497774162], [-76.96652700838361, 38.8943906396385], [-76.96659000633616, 38.894231896613334], [-76.96671634000784, 38.894018023967696], [-76.9667302971324, 38.893923179157454], [-76.96669502478277, 38.893558853204155], [-76.96673724560111, 38.89339144906551], [-76.96671600852949, 38.8932746724334]]]}, \"attributes\": {\"OBJECTID\": 7, \"state\": \"DC\", \"region\": \"03\", \"organizationid\": \"DOEE\", \"reportingcycle\": 2020, \"assessmentunitidentifier\": \"DCAKL00L_00\", \"assessmentunitname\": \"KINGMAN LAKE\", \"ircategory\": \"4A\", \"isassessed\": \"Y\", \"isimpaired\": \"N\", \"on303dlist\": \"Y\", \"hastmdl\": \"Y\", \"hasotherplan\": \"N\", \"visionpriority303d\": \"Y\", \"drinkingwater_use\": null, \"ecological_use\": \"Not Supporting\", \"fishconsumption_use\": \"Not Supporting\", \"recreation_use\": \"Not Supporting\", \"other_use\": \"Fully Supporting\", \"abnormalflow\": null, \"acidity\": null, \"ammonia\": null, \"bacteriaandothermicrobes\": \"Cause\", \"biologicalpoisons\": null, \"causeunknown\": null, \"chlorine\": null, \"degradedaquaticlife\": null, \"degradedhabitat\": null, \"dioxins\": null, \"excessalgae\": null, \"excessaquaticweeds\": null, \"excesssediment\": null, \"fishkills\": null, \"fishunsafetoeat\": null, \"lowoxygen\": \"Cause\", \"mercury\": null, \"metalsotherthanmercury\": \"Insufficient Information\", \"murkywater\": \"Cause\", \"nitrogenandphosphorus\": null, \"nuisanceplantsoranimalsforeign\": null, \"nuisanceplantsoranimalsnative\": null, \"oilandgrease\": \"Cause\", \"pcbs\": \"Cause\", \"pesticides\": \"Insufficient Information\", \"pollutedothercause\": null, \"radiation\": null, \"salts\": null, \"tastecolorandodor\": null, \"temperature\": null, \"totaltoxicchemicals\": null, \"toxicinorganicchemicals\": null, \"toxicorganicchemicals\": \"Cause\", \"trash\": null, \"Shape_Length\": 11341.746782939324, \"Shape_Area\": 752543.2676347918}}], \"objectIdFieldName\": \"OBJECTID\", \"displayFieldName\": \"assessmentunitname\", \"spatialReference\": {\"wkid\": 4326, \"latestWkid\": 4326}, \"geometryType\": \"esriGeometryPolygon\", \"fields\": [{\"name\": \"OBJECTID\", \"type\": \"esriFieldTypeOID\", \"alias\": \"OBJECTID\"}, {\"name\": \"state\", \"type\": \"esriFieldTypeString\", \"alias\": \"State\", \"length\": 2}, {\"name\": \"region\", \"type\": \"esriFieldTypeString\", \"alias\": \"Region\", \"length\": 2}, {\"name\": \"organizationid\", \"type\": \"esriFieldTypeString\", \"alias\": \"OrganizationID\", \"length\": 30}, {\"name\": \"reportingcycle\", \"type\": \"esriFieldTypeInteger\", \"alias\": \"ReportingCycle\"}, {\"name\": \"assessmentunitidentifier\", \"type\": \"esriFieldTypeString\", \"alias\": \"AssessmentUnitIdentifier\", \"length\": 50}, {\"name\": \"assessmentunitname\", \"type\": \"esriFieldTypeString\", \"alias\": \"AssessmentUnitName\", \"length\": 255}, {\"name\": \"ircategory\", \"type\": \"esriFieldTypeString\", \"alias\": \"IRCategory\", \"length\": 5}, {\"name\": \"isassessed\", \"type\": \"esriFieldTypeString\", \"alias\": \"IsAssessed\", \"length\": 1}, {\"name\": \"isimpaired\", \"type\": \"esriFieldTypeString\", \"alias\": \"IsImpaired\", \"length\": 1}, {\"name\": \"on303dlist\", \"type\": \"esriFieldTypeString\", \"alias\": \"On303dList\", \"length\": 1}, {\"name\": \"hastmdl\", \"type\": \"esriFieldTypeString\", \"alias\": \"HasTMDL\", \"length\": 1}, {\"name\": \"hasotherplan\", \"type\": \"esriFieldTypeString\", \"alias\": \"HasOtherPlan\", \"length\": 1}, {\"name\": \"visionpriority303d\", \"type\": \"esriFieldTypeString\", \"alias\": \"VisionPriority303d\", \"length\": 1}, {\"name\": \"drinkingwater_use\", \"type\": \"esriFieldTypeString\", \"alias\": \"DrinkingWater_Use\", \"length\": 50}, {\"name\": \"ecological_use\", \"type\": \"esriFieldTypeString\", \"alias\": \"Ecological_Use\", \"length\": 50}, {\"name\": \"fishconsumption_use\", \"type\": \"esriFieldTypeString\", \"alias\": \"FishConsumption_Use\", \"length\": 50}, {\"name\": \"recreation_use\", \"type\": \"esriFieldTypeString\", \"alias\": \"Recreation_Use\", \"length\": 50}, {\"name\": \"other_use\", \"type\": \"esriFieldTypeString\", \"alias\": \"Other_Use\", \"length\": 50}, {\"name\": \"abnormalflow\", \"type\": \"esriFieldTypeString\", \"alias\": \"AbnormalFlow\", \"length\": 50}, {\"name\": \"acidity\", \"type\": \"esriFieldTypeString\", \"alias\": \"Acidity\", \"length\": 50}, {\"name\": \"ammonia\", \"type\": \"esriFieldTypeString\", \"alias\": \"Ammonia\", \"length\": 50}, {\"name\": \"bacteriaandothermicrobes\", \"type\": \"esriFieldTypeString\", \"alias\": \"BacteriaAndOtherMicrobes\", \"length\": 50}, {\"name\": \"biologicalpoisons\", \"type\": \"esriFieldTypeString\", \"alias\": \"BiologicalPoisons\", \"length\": 50}, {\"name\": \"causeunknown\", \"type\": \"esriFieldTypeString\", \"alias\": \"CauseUnknown\", \"length\": 50}, {\"name\": \"chlorine\", \"type\": \"esriFieldTypeString\", \"alias\": \"Chlorine\", \"length\": 50}, {\"name\": \"degradedaquaticlife\", \"type\": \"esriFieldTypeString\", \"alias\": \"DegradedAquaticLife\", \"length\": 50}, {\"name\": \"degradedhabitat\", \"type\": \"esriFieldTypeString\", \"alias\": \"DegradedHabitat\", \"length\": 50}, {\"name\": \"dioxins\", \"type\": \"esriFieldTypeString\", \"alias\": \"Dioxins\", \"length\": 50}, {\"name\": \"excessalgae\", \"type\": \"esriFieldTypeString\", \"alias\": \"ExcessAlgae\", \"length\": 50}, {\"name\": \"excessaquaticweeds\", \"type\": \"esriFieldTypeString\", \"alias\": \"ExcessAquaticWeeds\", \"length\": 50}, {\"name\": \"excesssediment\", \"type\": \"esriFieldTypeString\", \"alias\": \"ExcessSediment\", \"length\": 50}, {\"name\": \"fishkills\", \"type\": \"esriFieldTypeString\", \"alias\": \"FishKills\", \"length\": 50}, {\"name\": \"fishunsafetoeat\", \"type\": \"esriFieldTypeString\", \"alias\": \"FishUnsafeToEat\", \"length\": 50}, {\"name\": \"lowoxygen\", \"type\": \"esriFieldTypeString\", \"alias\": \"LowOxygen\", \"length\": 50}, {\"name\": \"mercury\", \"type\": \"esriFieldTypeString\", \"alias\": \"Mercury\", \"length\": 50}, {\"name\": \"metalsotherthanmercury\", \"type\": \"esriFieldTypeString\", \"alias\": \"MetalsOtherThanMercury\", \"length\": 50}, {\"name\": \"murkywater\", \"type\": \"esriFieldTypeString\", \"alias\": \"MurkyWater\", \"length\": 50}, {\"name\": \"nitrogenandphosphorus\", \"type\": \"esriFieldTypeString\", \"alias\": \"NitrogenAndPhosphorus\", \"length\": 50}, {\"name\": \"nuisanceplantsoranimalsforeign\", \"type\": \"esriFieldTypeString\", \"alias\": \"NuisancePlantsOrAnimalsForeign\", \"length\": 50}, {\"name\": \"nuisanceplantsoranimalsnative\", \"type\": \"esriFieldTypeString\", \"alias\": \"NuisancePlantsOrAnimalsNative\", \"length\": 50}, {\"name\": \"oilandgrease\", \"type\": \"esriFieldTypeString\", \"alias\": \"OilAndGrease\", \"length\": 50}, {\"name\": \"pcbs\", \"type\": \"esriFieldTypeString\", \"alias\": \"PCBs\", \"length\": 50}, {\"name\": \"pesticides\", \"type\": \"esriFieldTypeString\", \"alias\": \"Pesticides\", \"length\": 50}, {\"name\": \"pollutedothercause\", \"type\": \"esriFieldTypeString\", \"alias\": \"PollutedOtherCause\", \"length\": 50}, {\"name\": \"radiation\", \"type\": \"esriFieldTypeString\", \"alias\": \"Radiation\", \"length\": 50}, {\"name\": \"salts\", \"type\": \"esriFieldTypeString\", \"alias\": \"Salts\", \"length\": 50}, {\"name\": \"tastecolorandodor\", \"type\": \"esriFieldTypeString\", \"alias\": \"TasteColorAndOdor\", \"length\": 50}, {\"name\": \"temperature\", \"type\": \"esriFieldTypeString\", \"alias\": \"Temperature\", \"length\": 50}, {\"name\": \"totaltoxicchemicals\", \"type\": \"esriFieldTypeString\", \"alias\": \"TotalToxicChemicals\", \"length\": 50}, {\"name\": \"toxicinorganicchemicals\", \"type\": \"esriFieldTypeString\", \"alias\": \"ToxicInorganicChemicals\", \"length\": 50}, {\"name\": \"toxicorganicchemicals\", \"type\": \"esriFieldTypeString\", \"alias\": \"ToxicOrganicChemicals\", \"length\": 50}, {\"name\": \"trash\", \"type\": \"esriFieldTypeString\", \"alias\": \"Trash\", \"length\": 50}, {\"name\": \"Shape_Length\", \"type\": \"esriFieldTypeDouble\", \"alias\": \"Shape_Length\"}, {\"name\": \"Shape_Area\", \"type\": \"esriFieldTypeDouble\", \"alias\": \"Shape_Area\"}]}\n"
     ]
    }
   ],
   "source": [
    "from arcgis.geometry import filters\n",
    "\n",
    "lyr_url = 'https://inlandwaters.geoplatform.gov/arcgis/rest/services/BETA/hmw_cip/MapServer/2'\n",
    "attains_area_featurelayer = FeatureLayer(lyr_url)\n",
    "query_result5 = attains_area_featurelayer.query(where=\"assessmentunitidentifier in (\" + assessmentUnitList + \")\", \n",
    "                                                 out_fields='*',out_sr=4326)\n",
    "\n",
    "print(str(query_result5))\n",
    "\n",
    "if len(query_result5.features) == 0:\n",
    "    print(\"No area features found.\")\n",
    "else:\n",
    "    query_result5.sdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "if len(query_result5.features) == 0:\n",
    "    print(\"No area features found.\")\n",
    "else:\n",
    "    gis = GIS()\n",
    "    map5 = gis.map()\n",
    "    map5.basemap = \"gray\"\n",
    "    map5.height = '650px'\n",
    "    map5.clear_graphics()\n",
    "\n",
    "    symbol = {\n",
    "        \"color\": [\n",
    "            0,\n",
    "            112,\n",
    "            255,\n",
    "            168\n",
    "        ],\n",
    "        \"outline\": {\n",
    "            \"color\": [\n",
    "                0,\n",
    "                0,\n",
    "                0,\n",
    "                255\n",
    "            ],\n",
    "            \"width\": 1,\n",
    "            \"type\": \"esriSLS\",\n",
    "            \"style\": \"esriSLSSolid\"\n",
    "        },\n",
    "        \"type\": \"esriSFS\",\n",
    "        \"style\": \"esriSFSSolid\"\n",
    "    }\n",
    "\n",
    "    map5.draw(query_result5,symbol=symbol)\n",
    "\n",
    "    map5.extent = query_result5.sdf.spatial.full_extent\n",
    "\n",
    "    map5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "celltoolbar": "Raw Cell Format",
  "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}