python_scripts/crimedata.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-02-02T15:15:15.363920Z",
     "start_time": "2018-02-02T15:15:14.337886Z"
    }
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import datetime as datetime\n",
    "import requests\n",
    "import ds100_utils\n",
    "%matplotlib inline\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Getting the Data\n",
    "We first pulled all the crime data from the City of Berkeley public dataset.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-02-02T15:15:19.115040Z",
     "start_time": "2018-02-02T15:15:19.070620Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Using cached version that was downloaded (UTC): Sun Oct 27 00:04:32 2019\n"
     ]
    },
    {
     "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>CASENO</th>\n",
       "      <th>OFFENSE</th>\n",
       "      <th>EVENTDT</th>\n",
       "      <th>EVENTTM</th>\n",
       "      <th>CVLEGEND</th>\n",
       "      <th>CVDOW</th>\n",
       "      <th>InDbDate</th>\n",
       "      <th>Block_Location</th>\n",
       "      <th>BLKADDR</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19045459</td>\n",
       "      <td>DOMESTIC VIOLENCE</td>\n",
       "      <td>08/16/2019 12:00:00 AM</td>\n",
       "      <td>14:40</td>\n",
       "      <td>FAMILY OFFENSE</td>\n",
       "      <td>5</td>\n",
       "      <td>10/26/2019 07:01:07 AM</td>\n",
       "      <td>FRONTAGE &amp;UNIVERSITY AVE\\nBerkeley, CA</td>\n",
       "      <td>FRONTAGE &amp;UNIVERSITY AVE</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19091565</td>\n",
       "      <td>BURGLARY AUTO</td>\n",
       "      <td>08/03/2019 12:00:00 AM</td>\n",
       "      <td>21:45</td>\n",
       "      <td>BURGLARY - VEHICLE</td>\n",
       "      <td>6</td>\n",
       "      <td>10/26/2019 07:01:07 AM</td>\n",
       "      <td>CENTER ST\\nBerkeley, CA</td>\n",
       "      <td>CENTER ST</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19059951</td>\n",
       "      <td>DISTURBANCE</td>\n",
       "      <td>10/22/2019 12:00:00 AM</td>\n",
       "      <td>12:06</td>\n",
       "      <td>DISORDERLY CONDUCT</td>\n",
       "      <td>2</td>\n",
       "      <td>10/26/2019 07:01:08 AM</td>\n",
       "      <td>2950 DURANT ST\\nBerkeley, CA</td>\n",
       "      <td>2950 DURANT ST</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>19091397</td>\n",
       "      <td>IDENTITY THEFT</td>\n",
       "      <td>06/20/2019 12:00:00 AM</td>\n",
       "      <td>12:45</td>\n",
       "      <td>FRAUD</td>\n",
       "      <td>4</td>\n",
       "      <td>10/26/2019 07:01:06 AM</td>\n",
       "      <td>PO BOX 5884\\nBerkeley, CA</td>\n",
       "      <td>PO BOX 5884</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>19026262</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>05/13/2019 12:00:00 AM</td>\n",
       "      <td>18:44</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>1</td>\n",
       "      <td>10/26/2019 07:01:09 AM</td>\n",
       "      <td>CALIFORNIA STREET &amp; 62ND ST\\nBerkeley, CA</td>\n",
       "      <td>CALIFORNIA STREET &amp; 62ND ST</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     CASENO            OFFENSE                 EVENTDT EVENTTM  \\\n",
       "0  19045459  DOMESTIC VIOLENCE  08/16/2019 12:00:00 AM   14:40   \n",
       "1  19091565      BURGLARY AUTO  08/03/2019 12:00:00 AM   21:45   \n",
       "2  19059951        DISTURBANCE  10/22/2019 12:00:00 AM   12:06   \n",
       "3  19091397     IDENTITY THEFT  06/20/2019 12:00:00 AM   12:45   \n",
       "4  19026262            ROBBERY  05/13/2019 12:00:00 AM   18:44   \n",
       "\n",
       "             CVLEGEND  CVDOW                InDbDate  \\\n",
       "0      FAMILY OFFENSE      5  10/26/2019 07:01:07 AM   \n",
       "1  BURGLARY - VEHICLE      6  10/26/2019 07:01:07 AM   \n",
       "2  DISORDERLY CONDUCT      2  10/26/2019 07:01:08 AM   \n",
       "3               FRAUD      4  10/26/2019 07:01:06 AM   \n",
       "4             ROBBERY      1  10/26/2019 07:01:09 AM   \n",
       "\n",
       "                              Block_Location                      BLKADDR  \\\n",
       "0     FRONTAGE &UNIVERSITY AVE\\nBerkeley, CA     FRONTAGE &UNIVERSITY AVE   \n",
       "1                    CENTER ST\\nBerkeley, CA                    CENTER ST   \n",
       "2               2950 DURANT ST\\nBerkeley, CA               2950 DURANT ST   \n",
       "3                  PO BOX 5884\\nBerkeley, CA                  PO BOX 5884   \n",
       "4  CALIFORNIA STREET & 62ND ST\\nBerkeley, CA  CALIFORNIA STREET & 62ND ST   \n",
       "\n",
       "       City State  \n",
       "0  Berkeley    CA  \n",
       "1  Berkeley    CA  \n",
       "2  Berkeley    CA  \n",
       "3  Berkeley    CA  \n",
       "4  Berkeley    CA  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calls_url = 'https://data.cityofberkeley.info/api/views/k2nh-s5h5/rows.csv?accessType=DOWNLOAD'\n",
    "calls_file = ds100_utils.fetch_and_cache(calls_url, 'calls.csv')\n",
    "calls = pd.read_csv(calls_file, warn_bad_lines=True)\n",
    "calls.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "How many records did we get?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-02-02T15:15:19.122345Z",
     "start_time": "2018-02-02T15:15:19.118071Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4979"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(calls)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "solution2": "hidden",
    "solution2_first": true
   },
   "source": [
    "### Preliminary observations on the data?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "solution2": "hidden"
   },
   "source": [
    "1. `EVENTDT` -- Contains the incorrect time\n",
    "1. `EVENTTM` -- Contains the time in 24 hour format (What timezone?)\n",
    "1. `CVDOW` -- Encodes the day of the week (see data documentation).\n",
    "1. `InDbDate` -- Appears to be correctly formatted and appears pretty consistent in time.\n",
    "1. `Block_Location` -- a multi-line string that contains coordinates.\n",
    "1. `BLKADDR` -- Appears to be the address in `Block Location`.\n",
    "1. `City` and `State` seem redundant given this is supposed to be the city of Berkeley dataset."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Making the polygon\n",
    "\n",
    "In order to create a constraint on the rideOS API, we need to make a region. So, for each crime event, we create a small box that encompasses the intersection where the crime occurred. The dataframe contains all 4 corners of the crime event."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-02-02T15:15:19.268222Z",
     "start_time": "2018-02-02T15:15:19.233193Z"
    }
   },
   "outputs": [],
   "source": [
    "calls_lat_lon = (\n",
    "    calls['Block_Location']\n",
    "    .str.extract(\"\\((\\d+\\.\\d+)\\, (-\\d+\\.\\d+)\\)\")\n",
    ")\n",
    "val = 0.0001\n",
    "calls_lat_lon.columns = ['Lat', 'Lon']\n",
    "calls_lat_lon\n",
    "calls['Lat'] = calls_lat_lon['Lat']\n",
    "calls['Lon'] = calls_lat_lon['Lon']\n",
    "calls_dropped =calls.dropna()\n",
    "calls_dropped['lat++'] = calls_dropped['Lat'].apply(float).round(4)+val\n",
    "calls_dropped['lon++'] = calls_dropped['Lon'].apply(float).round(4)+val\n",
    "calls_dropped['lat+-'] = calls_dropped['Lat'].apply(float).round(4)+val\n",
    "calls_dropped['lon+-'] = calls_dropped['Lon'].apply(float).round(4)-val\n",
    "calls_dropped['lat--'] = calls_dropped['Lat'].apply(float).round(4)-val\n",
    "calls_dropped['lon--'] = calls_dropped['Lon'].apply(float).round(4)-val\n",
    "calls_dropped['lat-+'] = calls_dropped['Lat'].apply(float).round(4)-val\n",
    "calls_dropped['lon-+'] = calls_dropped['Lon'].apply(float).round(4)+val\n",
    "calls_dropped['lat++2'] = calls_dropped['Lat'].apply(float).round(4)+val\n",
    "calls_dropped['lon++2'] = calls_dropped['Lon'].apply(float).round(4)+val\n",
    "\n",
    "calls_final = calls_dropped.drop('CASENO', axis=1).drop('EVENTTM', axis=1).drop('CVLEGEND', axis=1).drop('CVDOW', axis=1)\n",
    "calls_square = calls_final.drop('InDbDate', axis=1).drop('Block_Location', axis=1).drop('BLKADDR', axis=1).drop('City', axis=1).drop('State', axis=1).drop('Lat', axis=1).drop('Lon', axis=1)\n",
    "calls_square= calls_square.reset_index().drop('index', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>OFFENSE</th>\n",
       "      <th>EVENTDT</th>\n",
       "      <th>lat++</th>\n",
       "      <th>lon++</th>\n",
       "      <th>lat+-</th>\n",
       "      <th>lon+-</th>\n",
       "      <th>lat--</th>\n",
       "      <th>lon--</th>\n",
       "      <th>lat-+</th>\n",
       "      <th>lon-+</th>\n",
       "      <th>lat++2</th>\n",
       "      <th>lon++2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>05/30/2019 12:00:00 AM</td>\n",
       "      <td>37.8710</td>\n",
       "      <td>-122.2659</td>\n",
       "      <td>37.8710</td>\n",
       "      <td>-122.2661</td>\n",
       "      <td>37.8708</td>\n",
       "      <td>-122.2661</td>\n",
       "      <td>37.8708</td>\n",
       "      <td>-122.2659</td>\n",
       "      <td>37.8710</td>\n",
       "      <td>-122.2659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ASSAULT/BATTERY MISD.</td>\n",
       "      <td>09/22/2019 12:00:00 AM</td>\n",
       "      <td>37.8830</td>\n",
       "      <td>-122.2793</td>\n",
       "      <td>37.8830</td>\n",
       "      <td>-122.2795</td>\n",
       "      <td>37.8828</td>\n",
       "      <td>-122.2795</td>\n",
       "      <td>37.8828</td>\n",
       "      <td>-122.2793</td>\n",
       "      <td>37.8830</td>\n",
       "      <td>-122.2793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>VEHICLE STOLEN</td>\n",
       "      <td>09/08/2019 12:00:00 AM</td>\n",
       "      <td>37.8597</td>\n",
       "      <td>-122.2972</td>\n",
       "      <td>37.8597</td>\n",
       "      <td>-122.2974</td>\n",
       "      <td>37.8595</td>\n",
       "      <td>-122.2974</td>\n",
       "      <td>37.8595</td>\n",
       "      <td>-122.2972</td>\n",
       "      <td>37.8597</td>\n",
       "      <td>-122.2972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>THEFT FELONY (OVER $950)</td>\n",
       "      <td>08/13/2019 12:00:00 AM</td>\n",
       "      <td>37.8914</td>\n",
       "      <td>-122.2799</td>\n",
       "      <td>37.8914</td>\n",
       "      <td>-122.2801</td>\n",
       "      <td>37.8912</td>\n",
       "      <td>-122.2801</td>\n",
       "      <td>37.8912</td>\n",
       "      <td>-122.2799</td>\n",
       "      <td>37.8914</td>\n",
       "      <td>-122.2799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DISTURBANCE</td>\n",
       "      <td>08/01/2019 12:00:00 AM</td>\n",
       "      <td>37.8738</td>\n",
       "      <td>-122.2685</td>\n",
       "      <td>37.8738</td>\n",
       "      <td>-122.2687</td>\n",
       "      <td>37.8736</td>\n",
       "      <td>-122.2687</td>\n",
       "      <td>37.8736</td>\n",
       "      <td>-122.2685</td>\n",
       "      <td>37.8738</td>\n",
       "      <td>-122.2685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    OFFENSE                 EVENTDT    lat++     lon++  \\\n",
       "0                   ROBBERY  05/30/2019 12:00:00 AM  37.8710 -122.2659   \n",
       "1     ASSAULT/BATTERY MISD.  09/22/2019 12:00:00 AM  37.8830 -122.2793   \n",
       "2            VEHICLE STOLEN  09/08/2019 12:00:00 AM  37.8597 -122.2972   \n",
       "3  THEFT FELONY (OVER $950)  08/13/2019 12:00:00 AM  37.8914 -122.2799   \n",
       "4               DISTURBANCE  08/01/2019 12:00:00 AM  37.8738 -122.2685   \n",
       "\n",
       "     lat+-     lon+-    lat--     lon--    lat-+     lon-+   lat++2    lon++2  \n",
       "0  37.8710 -122.2661  37.8708 -122.2661  37.8708 -122.2659  37.8710 -122.2659  \n",
       "1  37.8830 -122.2795  37.8828 -122.2795  37.8828 -122.2793  37.8830 -122.2793  \n",
       "2  37.8597 -122.2974  37.8595 -122.2974  37.8595 -122.2972  37.8597 -122.2972  \n",
       "3  37.8914 -122.2801  37.8912 -122.2801  37.8912 -122.2799  37.8914 -122.2799  \n",
       "4  37.8738 -122.2687  37.8736 -122.2687  37.8736 -122.2685  37.8738 -122.2685  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calls_square.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Filtering the data\n",
    "\n",
    "In order to not overpopulate the map with crime events, we only took the data from the first three days of July. There were 61 crimes in the span of these three days."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>OFFENSE</th>\n",
       "      <th>EVENTDT</th>\n",
       "      <th>lat++</th>\n",
       "      <th>lon++</th>\n",
       "      <th>lat+-</th>\n",
       "      <th>lon+-</th>\n",
       "      <th>lat--</th>\n",
       "      <th>lon--</th>\n",
       "      <th>lat-+</th>\n",
       "      <th>lon-+</th>\n",
       "      <th>lat++2</th>\n",
       "      <th>lon++2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MISSING JUVENILE</td>\n",
       "      <td>2019-07-01 12:00:00</td>\n",
       "      <td>37.8644</td>\n",
       "      <td>-122.2917</td>\n",
       "      <td>37.8644</td>\n",
       "      <td>-122.2919</td>\n",
       "      <td>37.8642</td>\n",
       "      <td>-122.2919</td>\n",
       "      <td>37.8642</td>\n",
       "      <td>-122.2917</td>\n",
       "      <td>37.8644</td>\n",
       "      <td>-122.2917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT FELONY (OVER $950)</td>\n",
       "      <td>2019-07-01 12:00:00</td>\n",
       "      <td>37.8700</td>\n",
       "      <td>-122.3005</td>\n",
       "      <td>37.8700</td>\n",
       "      <td>-122.3007</td>\n",
       "      <td>37.8698</td>\n",
       "      <td>-122.3007</td>\n",
       "      <td>37.8698</td>\n",
       "      <td>-122.3005</td>\n",
       "      <td>37.8700</td>\n",
       "      <td>-122.3005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY AUTO</td>\n",
       "      <td>2019-07-02 12:00:00</td>\n",
       "      <td>37.8716</td>\n",
       "      <td>-122.2726</td>\n",
       "      <td>37.8716</td>\n",
       "      <td>-122.2728</td>\n",
       "      <td>37.8714</td>\n",
       "      <td>-122.2728</td>\n",
       "      <td>37.8714</td>\n",
       "      <td>-122.2726</td>\n",
       "      <td>37.8716</td>\n",
       "      <td>-122.2726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BURGLARY AUTO</td>\n",
       "      <td>2019-07-02 12:00:00</td>\n",
       "      <td>37.8586</td>\n",
       "      <td>-122.2933</td>\n",
       "      <td>37.8586</td>\n",
       "      <td>-122.2935</td>\n",
       "      <td>37.8584</td>\n",
       "      <td>-122.2935</td>\n",
       "      <td>37.8584</td>\n",
       "      <td>-122.2933</td>\n",
       "      <td>37.8586</td>\n",
       "      <td>-122.2933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BURGLARY AUTO</td>\n",
       "      <td>2019-07-01 12:00:00</td>\n",
       "      <td>37.8802</td>\n",
       "      <td>-122.2974</td>\n",
       "      <td>37.8802</td>\n",
       "      <td>-122.2976</td>\n",
       "      <td>37.8800</td>\n",
       "      <td>-122.2976</td>\n",
       "      <td>37.8800</td>\n",
       "      <td>-122.2974</td>\n",
       "      <td>37.8802</td>\n",
       "      <td>-122.2974</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    OFFENSE             EVENTDT    lat++     lon++    lat+-  \\\n",
       "0          MISSING JUVENILE 2019-07-01 12:00:00  37.8644 -122.2917  37.8644   \n",
       "1  THEFT FELONY (OVER $950) 2019-07-01 12:00:00  37.8700 -122.3005  37.8700   \n",
       "2             BURGLARY AUTO 2019-07-02 12:00:00  37.8716 -122.2726  37.8716   \n",
       "3             BURGLARY AUTO 2019-07-02 12:00:00  37.8586 -122.2933  37.8586   \n",
       "4             BURGLARY AUTO 2019-07-01 12:00:00  37.8802 -122.2974  37.8802   \n",
       "\n",
       "      lon+-    lat--     lon--    lat-+     lon-+   lat++2    lon++2  \n",
       "0 -122.2919  37.8642 -122.2919  37.8642 -122.2917  37.8644 -122.2917  \n",
       "1 -122.3007  37.8698 -122.3007  37.8698 -122.3005  37.8700 -122.3005  \n",
       "2 -122.2728  37.8714 -122.2728  37.8714 -122.2726  37.8716 -122.2726  \n",
       "3 -122.2935  37.8584 -122.2935  37.8584 -122.2933  37.8586 -122.2933  \n",
       "4 -122.2976  37.8800 -122.2976  37.8800 -122.2974  37.8802 -122.2974  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# filtering the calls_square dataframe based on time\n",
    "calls_square['EVENTDT'] =  calls_square['EVENTDT'].apply(pd.Timestamp)\n",
    "calls_square_date_filtered = calls_square[(calls_square['EVENTDT']>pd.Timestamp(year=2019, month=7, day=1)) & (calls_square['EVENTDT']< pd.Timestamp(year=2019, month=7, day=3))]  \n",
    "calls_square_date_filtered = calls_square_date_filtered.reset_index().drop(\"index\", axis=1)\n",
    "calls_square_date_filtered.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "metadata": {},
   "outputs": [],
   "source": [
    "# DATA USED TO FORMAT BOUNDING BOX FOR API REQUEST\n",
    "def format_request_data(id_str, plusplus, plusminus, minusminus, minusplus):\n",
    "    data_template = {\n",
    "      \"constraints\": [\n",
    "        {\n",
    "          \"id\": id_str,\n",
    "          \"avoidArea\": {\n",
    "            \"positions\": [\n",
    "              {\n",
    "                \"longitude\": plusplus[0],\n",
    "                \"latitude\": plusplus[1]\n",
    "              },\n",
    "              {\n",
    "                \"longitude\": plusminus[0],\n",
    "                \"latitude\": plusminus[1]\n",
    "              },\n",
    "              {\n",
    "                \"longitude\": minusminus[0],\n",
    "                \"latitude\": minusminus[1]\n",
    "              },\n",
    "              {\n",
    "                \"longitude\": minusplus[0],\n",
    "                \"latitude\": minusplus[1]\n",
    "              },\n",
    "              {\n",
    "                \"longitude\": plusplus[0],\n",
    "                \"latitude\": plusplus[1]\n",
    "              }\n",
    "            ]\n",
    "          }\n",
    "        }\n",
    "      ]\n",
    "    }\n",
    "    return data_template"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "metadata": {},
   "outputs": [],
   "source": [
    "# AUTHORIZATION HEADERS USED IN APPLICATION\n",
    "headers = {\n",
    "    \"Accept\": \"application/json\",\n",
    "    \"X-Api-Key\": \"t0vu9A7eqyLtDjLPLa6vdtC2Qhe1ZLYq:Gi-96xXJzAH99imHt09zFmZTSLHo-oLqdQ7UxKxA4nMZvC2X8Tyxrb0sCJ7hLwE2\",\n",
    "    \"Content-Type\": \"application/json\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 261,
   "metadata": {},
   "outputs": [],
   "source": [
    "# USE CONSTRAINT DATA API TO ASSOCIATE WITH OPERATOR LEVEL \n",
    "def add_constraint(auth, data):\n",
    "    response = requests.post('https://api.rideos.ai/constraints/v1/AddOrReplaceConstraints', headers=auth, json=data)\n",
    "    return response \n",
    "\n",
    "# USE RIDE HAIL OPERATIONS TO SET FLEET ROUTING CONSTRAINTS\n",
    "def set_fleet(auth, fleet_id, id_start, id_end):\n",
    "    ids = [\"demo\" + str(i) for i in range(id_start, id_end+1)]\n",
    "    data = {\n",
    "      \"fleetId\": fleet_id,\n",
    "      \"constraints\": {\n",
    "        \"blacklistConstraintIds\": ids\n",
    "      }\n",
    "    }\n",
    "    response = requests.post('https://api.rideos.ai/ride-hail-operations/v1/SetFleetRoutingConstraints', headers=auth, json=data)\n",
    "    return response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "metadata": {},
   "outputs": [],
   "source": [
    "# CALLS CURL COMMAND FOR EACH ROW IN THE CRIME DATASET\n",
    "def curl_commands(crime_df):\n",
    "    for index, row in crime_df.iterrows():\n",
    "        data = format_request_data(\"demo\" + str(index), \n",
    "                                    (round(row[\"lon++\"], 4), round(row[\"lat++\"], 4)), \n",
    "                                    (round(row[\"lon+-\"], 4), round(row[\"lat+-\"], 4)), \n",
    "                                    (round(row[\"lon--\"], 4), round(row[\"lat--\"], 4)),\n",
    "                                    (round(row[\"lon-+\"], 4), round(row[\"lat-+\"], 4)))\n",
    "        response = add_constraint(headers, data)\n",
    "        print(response)\n",
    "    return index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'constraints': [{'id': 'demo0', 'avoidArea': {'positions': [{'longitude': -122.2917, 'latitude': 37.8644}, {'longitude': -122.2919, 'latitude': 37.8644}, {'longitude': -122.2919, 'latitude': 37.8642}, {'longitude': -122.2917, 'latitude': 37.8642}, {'longitude': -122.2917, 'latitude': 37.8644}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo1', 'avoidArea': {'positions': [{'longitude': -122.3005, 'latitude': 37.87}, {'longitude': -122.3007, 'latitude': 37.87}, {'longitude': -122.3007, 'latitude': 37.8698}, {'longitude': -122.3005, 'latitude': 37.8698}, {'longitude': -122.3005, 'latitude': 37.87}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo2', 'avoidArea': {'positions': [{'longitude': -122.2726, 'latitude': 37.8716}, {'longitude': -122.2728, 'latitude': 37.8716}, {'longitude': -122.2728, 'latitude': 37.8714}, {'longitude': -122.2726, 'latitude': 37.8714}, {'longitude': -122.2726, 'latitude': 37.8716}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo3', 'avoidArea': {'positions': [{'longitude': -122.2933, 'latitude': 37.8586}, {'longitude': -122.2935, 'latitude': 37.8586}, {'longitude': -122.2935, 'latitude': 37.8584}, {'longitude': -122.2933, 'latitude': 37.8584}, {'longitude': -122.2933, 'latitude': 37.8586}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo4', 'avoidArea': {'positions': [{'longitude': -122.2974, 'latitude': 37.8802}, {'longitude': -122.2976, 'latitude': 37.8802}, {'longitude': -122.2976, 'latitude': 37.88}, {'longitude': -122.2974, 'latitude': 37.88}, {'longitude': -122.2974, 'latitude': 37.8802}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo5', 'avoidArea': {'positions': [{'longitude': -122.2936, 'latitude': 37.8703}, {'longitude': -122.2938, 'latitude': 37.8703}, {'longitude': -122.2938, 'latitude': 37.8701}, {'longitude': -122.2936, 'latitude': 37.8701}, {'longitude': -122.2936, 'latitude': 37.8703}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo6', 'avoidArea': {'positions': [{'longitude': -122.2565, 'latitude': 37.8673}, {'longitude': -122.2567, 'latitude': 37.8673}, {'longitude': -122.2567, 'latitude': 37.8671}, {'longitude': -122.2565, 'latitude': 37.8671}, {'longitude': -122.2565, 'latitude': 37.8673}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo7', 'avoidArea': {'positions': [{'longitude': -122.2974, 'latitude': 37.8802}, {'longitude': -122.2976, 'latitude': 37.8802}, {'longitude': -122.2976, 'latitude': 37.88}, {'longitude': -122.2974, 'latitude': 37.88}, {'longitude': -122.2974, 'latitude': 37.8802}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo8', 'avoidArea': {'positions': [{'longitude': -122.2999, 'latitude': 37.8824}, {'longitude': -122.3001, 'latitude': 37.8824}, {'longitude': -122.3001, 'latitude': 37.8822}, {'longitude': -122.2999, 'latitude': 37.8822}, {'longitude': -122.2999, 'latitude': 37.8824}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo9', 'avoidArea': {'positions': [{'longitude': -122.2575, 'latitude': 37.8635}, {'longitude': -122.2577, 'latitude': 37.8635}, {'longitude': -122.2577, 'latitude': 37.8633}, {'longitude': -122.2575, 'latitude': 37.8633}, {'longitude': -122.2575, 'latitude': 37.8635}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo10', 'avoidArea': {'positions': [{'longitude': -122.2914, 'latitude': 37.8813}, {'longitude': -122.2916, 'latitude': 37.8813}, {'longitude': -122.2916, 'latitude': 37.8811}, {'longitude': -122.2914, 'latitude': 37.8811}, {'longitude': -122.2914, 'latitude': 37.8813}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo11', 'avoidArea': {'positions': [{'longitude': -122.259, 'latitude': 37.8688}, {'longitude': -122.2592, 'latitude': 37.8688}, {'longitude': -122.2592, 'latitude': 37.8686}, {'longitude': -122.259, 'latitude': 37.8686}, {'longitude': -122.259, 'latitude': 37.8688}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo12', 'avoidArea': {'positions': [{'longitude': -122.2899, 'latitude': 37.8815}, {'longitude': -122.2901, 'latitude': 37.8815}, {'longitude': -122.2901, 'latitude': 37.8813}, {'longitude': -122.2899, 'latitude': 37.8813}, {'longitude': -122.2899, 'latitude': 37.8815}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo13', 'avoidArea': {'positions': [{'longitude': -122.2919, 'latitude': 37.8692}, {'longitude': -122.2921, 'latitude': 37.8692}, {'longitude': -122.2921, 'latitude': 37.869}, {'longitude': -122.2919, 'latitude': 37.869}, {'longitude': -122.2919, 'latitude': 37.8692}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo14', 'avoidArea': {'positions': [{'longitude': -122.27, 'latitude': 37.8683}, {'longitude': -122.2702, 'latitude': 37.8683}, {'longitude': -122.2702, 'latitude': 37.8681}, {'longitude': -122.27, 'latitude': 37.8681}, {'longitude': -122.27, 'latitude': 37.8683}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo15', 'avoidArea': {'positions': [{'longitude': -122.2586, 'latitude': 37.868}, {'longitude': -122.2588, 'latitude': 37.868}, {'longitude': -122.2588, 'latitude': 37.8678}, {'longitude': -122.2586, 'latitude': 37.8678}, {'longitude': -122.2586, 'latitude': 37.868}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo16', 'avoidArea': {'positions': [{'longitude': -122.2533, 'latitude': 37.8606}, {'longitude': -122.2535, 'latitude': 37.8606}, {'longitude': -122.2535, 'latitude': 37.8604}, {'longitude': -122.2533, 'latitude': 37.8604}, {'longitude': -122.2533, 'latitude': 37.8606}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo17', 'avoidArea': {'positions': [{'longitude': -122.2916, 'latitude': 37.8765}, {'longitude': -122.2918, 'latitude': 37.8765}, {'longitude': -122.2918, 'latitude': 37.8763}, {'longitude': -122.2916, 'latitude': 37.8763}, {'longitude': -122.2916, 'latitude': 37.8765}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo18', 'avoidArea': {'positions': [{'longitude': -122.2501, 'latitude': 37.8694}, {'longitude': -122.2503, 'latitude': 37.8694}, {'longitude': -122.2503, 'latitude': 37.8692}, {'longitude': -122.2501, 'latitude': 37.8692}, {'longitude': -122.2501, 'latitude': 37.8694}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo19', 'avoidArea': {'positions': [{'longitude': -122.2632, 'latitude': 37.8662}, {'longitude': -122.2634, 'latitude': 37.8662}, {'longitude': -122.2634, 'latitude': 37.866}, {'longitude': -122.2632, 'latitude': 37.866}, {'longitude': -122.2632, 'latitude': 37.8662}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo20', 'avoidArea': {'positions': [{'longitude': -122.27, 'latitude': 37.8683}, {'longitude': -122.2702, 'latitude': 37.8683}, {'longitude': -122.2702, 'latitude': 37.8681}, {'longitude': -122.27, 'latitude': 37.8681}, {'longitude': -122.27, 'latitude': 37.8683}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo21', 'avoidArea': {'positions': [{'longitude': -122.2747, 'latitude': 37.8686}, {'longitude': -122.2749, 'latitude': 37.8686}, {'longitude': -122.2749, 'latitude': 37.8684}, {'longitude': -122.2747, 'latitude': 37.8684}, {'longitude': -122.2747, 'latitude': 37.8686}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo22', 'avoidArea': {'positions': [{'longitude': -122.299, 'latitude': 37.8798}, {'longitude': -122.2992, 'latitude': 37.8798}, {'longitude': -122.2992, 'latitude': 37.8796}, {'longitude': -122.299, 'latitude': 37.8796}, {'longitude': -122.299, 'latitude': 37.8798}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo23', 'avoidArea': {'positions': [{'longitude': -122.2727, 'latitude': 37.8858}, {'longitude': -122.2729, 'latitude': 37.8858}, {'longitude': -122.2729, 'latitude': 37.8856}, {'longitude': -122.2727, 'latitude': 37.8856}, {'longitude': -122.2727, 'latitude': 37.8858}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo24', 'avoidArea': {'positions': [{'longitude': -122.2822, 'latitude': 37.8639}, {'longitude': -122.2824, 'latitude': 37.8639}, {'longitude': -122.2824, 'latitude': 37.8637}, {'longitude': -122.2822, 'latitude': 37.8637}, {'longitude': -122.2822, 'latitude': 37.8639}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo25', 'avoidArea': {'positions': [{'longitude': -122.2695, 'latitude': 37.8821}, {'longitude': -122.2697, 'latitude': 37.8821}, {'longitude': -122.2697, 'latitude': 37.8819}, {'longitude': -122.2695, 'latitude': 37.8819}, {'longitude': -122.2695, 'latitude': 37.8821}]}}]}\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo26', 'avoidArea': {'positions': [{'longitude': -122.2606, 'latitude': 37.8649}, {'longitude': -122.2608, 'latitude': 37.8649}, {'longitude': -122.2608, 'latitude': 37.8647}, {'longitude': -122.2606, 'latitude': 37.8647}, {'longitude': -122.2606, 'latitude': 37.8649}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo27', 'avoidArea': {'positions': [{'longitude': -122.2711, 'latitude': 37.8489}, {'longitude': -122.2713, 'latitude': 37.8489}, {'longitude': -122.2713, 'latitude': 37.8487}, {'longitude': -122.2711, 'latitude': 37.8487}, {'longitude': -122.2711, 'latitude': 37.8489}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo28', 'avoidArea': {'positions': [{'longitude': -122.2693, 'latitude': 37.8803}, {'longitude': -122.2695, 'latitude': 37.8803}, {'longitude': -122.2695, 'latitude': 37.8801}, {'longitude': -122.2693, 'latitude': 37.8801}, {'longitude': -122.2693, 'latitude': 37.8803}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo29', 'avoidArea': {'positions': [{'longitude': -122.2677, 'latitude': 37.8673}, {'longitude': -122.2679, 'latitude': 37.8673}, {'longitude': -122.2679, 'latitude': 37.8671}, {'longitude': -122.2677, 'latitude': 37.8671}, {'longitude': -122.2677, 'latitude': 37.8673}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo30', 'avoidArea': {'positions': [{'longitude': -122.2664, 'latitude': 37.9011}, {'longitude': -122.2666, 'latitude': 37.9011}, {'longitude': -122.2666, 'latitude': 37.9009}, {'longitude': -122.2664, 'latitude': 37.9009}, {'longitude': -122.2664, 'latitude': 37.9011}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo31', 'avoidArea': {'positions': [{'longitude': -122.2544, 'latitude': 37.8878}, {'longitude': -122.2546, 'latitude': 37.8878}, {'longitude': -122.2546, 'latitude': 37.8876}, {'longitude': -122.2544, 'latitude': 37.8876}, {'longitude': -122.2544, 'latitude': 37.8878}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo32', 'avoidArea': {'positions': [{'longitude': -122.2693, 'latitude': 37.8803}, {'longitude': -122.2695, 'latitude': 37.8803}, {'longitude': -122.2695, 'latitude': 37.8801}, {'longitude': -122.2693, 'latitude': 37.8801}, {'longitude': -122.2693, 'latitude': 37.8803}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo33', 'avoidArea': {'positions': [{'longitude': -122.2929, 'latitude': 37.857}, {'longitude': -122.2931, 'latitude': 37.857}, {'longitude': -122.2931, 'latitude': 37.8568}, {'longitude': -122.2929, 'latitude': 37.8568}, {'longitude': -122.2929, 'latitude': 37.857}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo34', 'avoidArea': {'positions': [{'longitude': -122.3175, 'latitude': 37.8637}, {'longitude': -122.3177, 'latitude': 37.8637}, {'longitude': -122.3177, 'latitude': 37.8635}, {'longitude': -122.3175, 'latitude': 37.8635}, {'longitude': -122.3175, 'latitude': 37.8637}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo35', 'avoidArea': {'positions': [{'longitude': -122.2925, 'latitude': 37.8703}, {'longitude': -122.2927, 'latitude': 37.8703}, {'longitude': -122.2927, 'latitude': 37.8701}, {'longitude': -122.2925, 'latitude': 37.8701}, {'longitude': -122.2925, 'latitude': 37.8703}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo36', 'avoidArea': {'positions': [{'longitude': -122.2695, 'latitude': 37.8638}, {'longitude': -122.2697, 'latitude': 37.8638}, {'longitude': -122.2697, 'latitude': 37.8636}, {'longitude': -122.2695, 'latitude': 37.8636}, {'longitude': -122.2695, 'latitude': 37.8638}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo37', 'avoidArea': {'positions': [{'longitude': -122.3161, 'latitude': 37.8704}, {'longitude': -122.3163, 'latitude': 37.8704}, {'longitude': -122.3163, 'latitude': 37.8702}, {'longitude': -122.3161, 'latitude': 37.8702}, {'longitude': -122.3161, 'latitude': 37.8704}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo38', 'avoidArea': {'positions': [{'longitude': -122.2705, 'latitude': 37.8707}, {'longitude': -122.2707, 'latitude': 37.8707}, {'longitude': -122.2707, 'latitude': 37.8705}, {'longitude': -122.2705, 'latitude': 37.8705}, {'longitude': -122.2705, 'latitude': 37.8707}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo39', 'avoidArea': {'positions': [{'longitude': -122.2612, 'latitude': 37.8685}, {'longitude': -122.2614, 'latitude': 37.8685}, {'longitude': -122.2614, 'latitude': 37.8683}, {'longitude': -122.2612, 'latitude': 37.8683}, {'longitude': -122.2612, 'latitude': 37.8685}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo40', 'avoidArea': {'positions': [{'longitude': -122.272, 'latitude': 37.8736}, {'longitude': -122.2722, 'latitude': 37.8736}, {'longitude': -122.2722, 'latitude': 37.8734}, {'longitude': -122.272, 'latitude': 37.8734}, {'longitude': -122.272, 'latitude': 37.8736}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo41', 'avoidArea': {'positions': [{'longitude': -122.2708, 'latitude': 37.8505}, {'longitude': -122.271, 'latitude': 37.8505}, {'longitude': -122.271, 'latitude': 37.8503}, {'longitude': -122.2708, 'latitude': 37.8503}, {'longitude': -122.2708, 'latitude': 37.8505}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo42', 'avoidArea': {'positions': [{'longitude': -122.2895, 'latitude': 37.8722}, {'longitude': -122.2897, 'latitude': 37.8722}, {'longitude': -122.2897, 'latitude': 37.872}, {'longitude': -122.2895, 'latitude': 37.872}, {'longitude': -122.2895, 'latitude': 37.8722}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo43', 'avoidArea': {'positions': [{'longitude': -122.2663, 'latitude': 37.8742}, {'longitude': -122.2665, 'latitude': 37.8742}, {'longitude': -122.2665, 'latitude': 37.874}, {'longitude': -122.2663, 'latitude': 37.874}, {'longitude': -122.2663, 'latitude': 37.8742}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo44', 'avoidArea': {'positions': [{'longitude': -122.2682, 'latitude': 37.8713}, {'longitude': -122.2684, 'latitude': 37.8713}, {'longitude': -122.2684, 'latitude': 37.8711}, {'longitude': -122.2682, 'latitude': 37.8711}, {'longitude': -122.2682, 'latitude': 37.8713}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo45', 'avoidArea': {'positions': [{'longitude': -122.2719, 'latitude': 37.8837}, {'longitude': -122.2721, 'latitude': 37.8837}, {'longitude': -122.2721, 'latitude': 37.8835}, {'longitude': -122.2719, 'latitude': 37.8835}, {'longitude': -122.2719, 'latitude': 37.8837}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo46', 'avoidArea': {'positions': [{'longitude': -122.3099, 'latitude': 37.8656}, {'longitude': -122.3101, 'latitude': 37.8656}, {'longitude': -122.3101, 'latitude': 37.8654}, {'longitude': -122.3099, 'latitude': 37.8654}, {'longitude': -122.3099, 'latitude': 37.8656}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo47', 'avoidArea': {'positions': [{'longitude': -122.2662, 'latitude': 37.874}, {'longitude': -122.2664, 'latitude': 37.874}, {'longitude': -122.2664, 'latitude': 37.8738}, {'longitude': -122.2662, 'latitude': 37.8738}, {'longitude': -122.2662, 'latitude': 37.874}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo48', 'avoidArea': {'positions': [{'longitude': -122.2752, 'latitude': 37.8576}, {'longitude': -122.2754, 'latitude': 37.8576}, {'longitude': -122.2754, 'latitude': 37.8574}, {'longitude': -122.2752, 'latitude': 37.8574}, {'longitude': -122.2752, 'latitude': 37.8576}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo49', 'avoidArea': {'positions': [{'longitude': -122.2639, 'latitude': 37.8528}, {'longitude': -122.2641, 'latitude': 37.8528}, {'longitude': -122.2641, 'latitude': 37.8526}, {'longitude': -122.2639, 'latitude': 37.8526}, {'longitude': -122.2639, 'latitude': 37.8528}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo50', 'avoidArea': {'positions': [{'longitude': -122.2614, 'latitude': 37.8575}, {'longitude': -122.2616, 'latitude': 37.8575}, {'longitude': -122.2616, 'latitude': 37.8573}, {'longitude': -122.2614, 'latitude': 37.8573}, {'longitude': -122.2614, 'latitude': 37.8575}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo51', 'avoidArea': {'positions': [{'longitude': -122.2749, 'latitude': 37.8713}, {'longitude': -122.2751, 'latitude': 37.8713}, {'longitude': -122.2751, 'latitude': 37.8711}, {'longitude': -122.2749, 'latitude': 37.8711}, {'longitude': -122.2749, 'latitude': 37.8713}]}}]}\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo52', 'avoidArea': {'positions': [{'longitude': -122.2781, 'latitude': 37.8945}, {'longitude': -122.2783, 'latitude': 37.8945}, {'longitude': -122.2783, 'latitude': 37.8943}, {'longitude': -122.2781, 'latitude': 37.8943}, {'longitude': -122.2781, 'latitude': 37.8945}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo53', 'avoidArea': {'positions': [{'longitude': -122.2842, 'latitude': 37.8702}, {'longitude': -122.2844, 'latitude': 37.8702}, {'longitude': -122.2844, 'latitude': 37.87}, {'longitude': -122.2842, 'latitude': 37.87}, {'longitude': -122.2842, 'latitude': 37.8702}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo54', 'avoidArea': {'positions': [{'longitude': -122.2625, 'latitude': 37.8629}, {'longitude': -122.2627, 'latitude': 37.8629}, {'longitude': -122.2627, 'latitude': 37.8627}, {'longitude': -122.2625, 'latitude': 37.8627}, {'longitude': -122.2625, 'latitude': 37.8629}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo55', 'avoidArea': {'positions': [{'longitude': -122.2696, 'latitude': 37.8837}, {'longitude': -122.2698, 'latitude': 37.8837}, {'longitude': -122.2698, 'latitude': 37.8835}, {'longitude': -122.2696, 'latitude': 37.8835}, {'longitude': -122.2696, 'latitude': 37.8837}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo56', 'avoidArea': {'positions': [{'longitude': -122.3099, 'latitude': 37.8656}, {'longitude': -122.3101, 'latitude': 37.8656}, {'longitude': -122.3101, 'latitude': 37.8654}, {'longitude': -122.3099, 'latitude': 37.8654}, {'longitude': -122.3099, 'latitude': 37.8656}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo57', 'avoidArea': {'positions': [{'longitude': -122.2531, 'latitude': 37.8585}, {'longitude': -122.2533, 'latitude': 37.8585}, {'longitude': -122.2533, 'latitude': 37.8583}, {'longitude': -122.2531, 'latitude': 37.8583}, {'longitude': -122.2531, 'latitude': 37.8585}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo58', 'avoidArea': {'positions': [{'longitude': -122.28, 'latitude': 37.8753}, {'longitude': -122.2802, 'latitude': 37.8753}, {'longitude': -122.2802, 'latitude': 37.8751}, {'longitude': -122.28, 'latitude': 37.8751}, {'longitude': -122.28, 'latitude': 37.8753}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo59', 'avoidArea': {'positions': [{'longitude': -122.259, 'latitude': 37.8688}, {'longitude': -122.2592, 'latitude': 37.8688}, {'longitude': -122.2592, 'latitude': 37.8686}, {'longitude': -122.259, 'latitude': 37.8686}, {'longitude': -122.259, 'latitude': 37.8688}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo60', 'avoidArea': {'positions': [{'longitude': -122.3021, 'latitude': 37.8823}, {'longitude': -122.3023, 'latitude': 37.8823}, {'longitude': -122.3023, 'latitude': 37.8821}, {'longitude': -122.3021, 'latitude': 37.8821}, {'longitude': -122.3021, 'latitude': 37.8823}]}}]}\n",
      "<Response [200]>\n",
      "{'constraints': [{'id': 'demo61', 'avoidArea': {'positions': [{'longitude': -122.2839, 'latitude': 37.8537}, {'longitude': -122.2841, 'latitude': 37.8537}, {'longitude': -122.2841, 'latitude': 37.8535}, {'longitude': -122.2839, 'latitude': 37.8535}, {'longitude': -122.2839, 'latitude': 37.8537}]}}]}\n",
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "index = curl_commands(calls_square_date_filtered)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 262,
   "metadata": {},
   "outputs": [],
   "source": [
    "FLEET_ID = \"0\"\n",
    "START_INDEX = 0 \n",
    "END_INDEX = index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "fleet_response = set_fleet(headers, \"sim_fleet_dee8f8\", START_INDEX, END_INDEX)\n",
    "print(fleet_response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}