Monthly homicides and shootings report.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First, we need to connect to NewsroomDB and download all shootings and homicides."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "doh\n",
      "doh\n",
      "doh\n",
      "Found 1519 homicides and 11463 shootings\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "import requests\n",
    "\n",
    "def get_table_data(table_name):\n",
    "    url = '%stable/json/%s' % (os.environ['NEWSROOMDB_URL'], table_name)\n",
    "    try:\n",
    "        r = requests.get(url)\n",
    "        return r.json()\n",
    "    except:\n",
    "        print 'doh'\n",
    "        return get_table_data(table_name)\n",
    "\n",
    "homicides = get_table_data('homicides')\n",
    "shootings = get_table_data('shootings')\n",
    "\n",
    "print 'Found %d homicides and %d shootings' % (len(homicides), len(shootings))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "Right now, we're interested in all shootings and homicides for the current month. So filter the lists based on whatever that month is."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2016:\t257 shootings\t\t47 homicides\n",
      "2015:\t145 shootings\t\t32 homicides\n",
      "2014:\t101 shootings\t\t24 homicides\n",
      "2013:\t190 shootings\t\t44 homicides\n",
      "2012:\t174 shootings\t\t0 homicides\n",
      "1984:\t1 shootings\t\t0 homicides\n"
     ]
    }
   ],
   "source": [
    "from datetime import date, datetime\n",
    "today = date.today()\n",
    "\n",
    "homicides_this_month = {}\n",
    "for h in homicides:\n",
    "    try:\n",
    "        dt = datetime.strptime(h['Occ Date'], '%Y-%m-%d')\n",
    "    except ValueError:\n",
    "        continue\n",
    "    if dt.month == today.month:\n",
    "        if dt.year not in homicides_this_month:\n",
    "            homicides_this_month[dt.year] = []\n",
    "        homicides_this_month[dt.year].append(h)\n",
    "\n",
    "shootings_this_month = {}\n",
    "for s in shootings:\n",
    "    try:\n",
    "        dt = datetime.strptime(s['Date'], '%Y-%m-%d')\n",
    "    except ValueError:\n",
    "        continue\n",
    "    if dt.month == today.month:\n",
    "        if dt.year not in shootings_this_month:\n",
    "            shootings_this_month[dt.year] = []\n",
    "        shootings_this_month[dt.year].append(s)\n",
    "\n",
    "for year in sorted(shootings_this_month.keys(), reverse=True):\n",
    "    try:\n",
    "        s = len(shootings_this_month[year])\n",
    "    except:\n",
    "        s = 0\n",
    "    try:\n",
    "        h = len(homicides_this_month[year])\n",
    "    except:\n",
    "        h = 0\n",
    "    print '%d:\\t%d shootings\\t\\t%d homicides' % (year, s, h)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "Now let's find the days without a shooting."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No shootings on 2015-02-28\n",
      "No shootings on 2015-02-24\n",
      "No shootings on 2015-02-18\n",
      "No shootings on 2015-02-05\n",
      "No shootings on 2015-02-02\n",
      "No shootings on 2015-01-15\n",
      "No shootings on 2015-01-12\n",
      "No shootings on 2015-01-07\n",
      "No shootings on 2014-11-14\n",
      "No shootings on 2014-05-23\n",
      "No shootings on 2014-03-26\n",
      "No shootings on 2014-03-13\n",
      "No shootings on 2014-02-26\n",
      "No shootings on 2014-02-17\n",
      "No shootings on 2014-02-16\n",
      "No shootings on 2014-02-11\n",
      "No shootings on 2014-01-23\n",
      "No shootings on 2014-01-21\n",
      "No shootings on 2014-01-10\n",
      "No shootings on 2014-01-06\n",
      "No shootings on 2014-01-02\n"
     ]
    }
   ],
   "source": [
    "from datetime import date, timedelta\n",
    "\n",
    "test_date = date.today()\n",
    "one_day = timedelta(days=1)\n",
    "\n",
    "shooting_days = {}\n",
    "for shooting in shootings:\n",
    "    if shooting['Date'] not in shooting_days:\n",
    "        shooting_days[shooting['Date']] = 0\n",
    "    shooting_days[shooting['Date']] += 1\n",
    "\n",
    "while test_date.year > 2013:\n",
    "    if test_date.strftime('%Y-%m-%d') not in shooting_days:\n",
    "        print 'No shootings on %s' % test_date\n",
    "    test_date -= one_day"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And days without a homicide."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No homicides on 2016-03-25\n",
      "No homicides on 2016-03-24\n",
      "No homicides on 2016-03-23\n",
      "No homicides on 2016-03-22\n",
      "No homicides on 2016-03-21\n",
      "No homicides on 2016-03-20\n",
      "No homicides on 2016-03-19\n",
      "No homicides on 2016-03-17\n",
      "No homicides on 2016-03-16\n",
      "No homicides on 2016-03-06\n",
      "No homicides on 2016-03-05\n",
      "No homicides on 2016-03-03\n",
      "No homicides on 2016-02-29\n",
      "No homicides on 2016-02-28\n",
      "No homicides on 2016-02-25\n",
      "No homicides on 2016-02-23\n",
      "No homicides on 2016-02-15\n",
      "No homicides on 2016-02-12\n",
      "No homicides on 2016-02-10\n",
      "No homicides on 2016-02-09\n",
      "No homicides on 2016-02-06\n",
      "No homicides on 2016-01-22\n",
      "No homicides on 2016-01-19\n",
      "No homicides on 2016-01-15\n",
      "No homicides on 2016-01-12\n",
      "No homicides on 2016-01-10\n",
      "No homicides on 2016-01-03\n",
      "No homicides on 2015-12-31\n",
      "No homicides on 2015-12-30\n",
      "No homicides on 2015-12-28\n",
      "No homicides on 2015-12-21\n",
      "No homicides on 2015-12-19\n",
      "No homicides on 2015-12-18\n",
      "No homicides on 2015-12-15\n",
      "No homicides on 2015-12-14\n",
      "No homicides on 2015-12-09\n",
      "No homicides on 2015-12-07\n",
      "No homicides on 2015-12-02\n",
      "No homicides on 2015-11-24\n",
      "No homicides on 2015-11-20\n",
      "No homicides on 2015-11-19\n",
      "No homicides on 2015-11-16\n",
      "No homicides on 2015-11-15\n",
      "No homicides on 2015-11-13\n",
      "No homicides on 2015-11-10\n",
      "No homicides on 2015-11-08\n",
      "No homicides on 2015-11-04\n",
      "No homicides on 2015-10-30\n",
      "No homicides on 2015-10-29\n",
      "No homicides on 2015-10-28\n",
      "No homicides on 2015-10-27\n",
      "No homicides on 2015-10-22\n",
      "No homicides on 2015-10-20\n",
      "No homicides on 2015-10-15\n",
      "No homicides on 2015-10-05\n",
      "No homicides on 2015-10-03\n",
      "No homicides on 2015-10-02\n",
      "No homicides on 2015-10-01\n",
      "No homicides on 2015-09-12\n",
      "No homicides on 2015-09-11\n",
      "No homicides on 2015-09-09\n",
      "No homicides on 2015-09-05\n",
      "No homicides on 2015-08-28\n",
      "No homicides on 2015-08-18\n",
      "No homicides on 2015-08-10\n",
      "No homicides on 2015-08-08\n",
      "No homicides on 2015-08-04\n",
      "No homicides on 2015-08-03\n",
      "No homicides on 2015-07-29\n",
      "No homicides on 2015-07-23\n",
      "No homicides on 2015-07-22\n",
      "No homicides on 2015-07-19\n",
      "No homicides on 2015-07-16\n",
      "No homicides on 2015-07-14\n",
      "No homicides on 2015-06-26\n",
      "No homicides on 2015-06-24\n",
      "No homicides on 2015-06-22\n",
      "No homicides on 2015-06-19\n",
      "No homicides on 2015-06-15\n",
      "No homicides on 2015-06-11\n",
      "No homicides on 2015-06-09\n",
      "No homicides on 2015-06-02\n",
      "No homicides on 2015-05-27\n",
      "No homicides on 2015-05-26\n",
      "No homicides on 2015-05-22\n",
      "No homicides on 2015-05-19\n",
      "No homicides on 2015-05-17\n",
      "No homicides on 2015-05-16\n",
      "No homicides on 2015-05-12\n",
      "No homicides on 2015-05-11\n",
      "No homicides on 2015-05-08\n",
      "No homicides on 2015-05-06\n",
      "No homicides on 2015-05-04\n",
      "No homicides on 2015-05-02\n",
      "No homicides on 2015-04-27\n",
      "No homicides on 2015-04-22\n",
      "No homicides on 2015-04-16\n",
      "No homicides on 2015-04-14\n",
      "No homicides on 2015-04-13\n",
      "No homicides on 2015-04-12\n",
      "No homicides on 2015-04-09\n",
      "No homicides on 2015-04-06\n",
      "No homicides on 2015-04-05\n",
      "No homicides on 2015-03-23\n",
      "No homicides on 2015-03-18\n",
      "No homicides on 2015-03-17\n",
      "No homicides on 2015-03-14\n",
      "No homicides on 2015-03-13\n",
      "No homicides on 2015-03-12\n",
      "No homicides on 2015-03-11\n",
      "No homicides on 2015-03-10\n",
      "No homicides on 2015-03-06\n",
      "No homicides on 2015-03-05\n",
      "No homicides on 2015-03-04\n",
      "No homicides on 2015-03-01\n",
      "No homicides on 2015-02-28\n",
      "No homicides on 2015-02-27\n",
      "No homicides on 2015-02-26\n",
      "No homicides on 2015-02-24\n",
      "No homicides on 2015-02-23\n",
      "No homicides on 2015-02-18\n",
      "No homicides on 2015-02-17\n",
      "No homicides on 2015-02-14\n",
      "No homicides on 2015-02-12\n",
      "No homicides on 2015-02-11\n",
      "No homicides on 2015-02-07\n",
      "No homicides on 2015-02-06\n",
      "No homicides on 2015-02-05\n",
      "No homicides on 2015-02-03\n",
      "No homicides on 2015-01-28\n",
      "No homicides on 2015-01-26\n",
      "No homicides on 2015-01-22\n",
      "No homicides on 2015-01-19\n",
      "No homicides on 2015-01-15\n",
      "No homicides on 2015-01-12\n",
      "No homicides on 2015-01-11\n",
      "No homicides on 2015-01-10\n",
      "No homicides on 2015-01-07\n",
      "No homicides on 2015-01-02\n",
      "No homicides on 2015-01-01\n",
      "No homicides on 2014-12-30\n",
      "No homicides on 2014-12-29\n",
      "No homicides on 2014-12-24\n",
      "No homicides on 2014-12-20\n",
      "No homicides on 2014-12-18\n",
      "No homicides on 2014-12-14\n",
      "No homicides on 2014-12-07\n",
      "No homicides on 2014-12-06\n",
      "No homicides on 2014-12-04\n",
      "No homicides on 2014-12-02\n",
      "No homicides on 2014-12-01\n",
      "No homicides on 2014-11-29\n",
      "No homicides on 2014-11-27\n",
      "No homicides on 2014-11-26\n",
      "No homicides on 2014-11-24\n",
      "No homicides on 2014-11-23\n",
      "No homicides on 2014-11-20\n",
      "No homicides on 2014-11-14\n",
      "No homicides on 2014-11-12\n",
      "No homicides on 2014-11-11\n",
      "No homicides on 2014-10-30\n",
      "No homicides on 2014-10-25\n",
      "No homicides on 2014-10-21\n",
      "No homicides on 2014-10-20\n",
      "No homicides on 2014-10-17\n",
      "No homicides on 2014-10-15\n",
      "No homicides on 2014-10-13\n",
      "No homicides on 2014-10-01\n",
      "No homicides on 2014-09-24\n",
      "No homicides on 2014-09-23\n",
      "No homicides on 2014-09-16\n",
      "No homicides on 2014-09-15\n",
      "No homicides on 2014-09-12\n",
      "No homicides on 2014-09-07\n",
      "No homicides on 2014-09-03\n",
      "No homicides on 2014-09-02\n",
      "No homicides on 2014-08-28\n",
      "No homicides on 2014-08-23\n",
      "No homicides on 2014-08-22\n",
      "No homicides on 2014-08-13\n",
      "No homicides on 2014-08-09\n",
      "No homicides on 2014-08-08\n",
      "No homicides on 2014-08-07\n",
      "No homicides on 2014-07-30\n",
      "No homicides on 2014-07-28\n",
      "No homicides on 2014-07-27\n",
      "No homicides on 2014-07-26\n",
      "No homicides on 2014-07-17\n",
      "No homicides on 2014-07-16\n",
      "No homicides on 2014-07-10\n",
      "No homicides on 2014-06-29\n",
      "No homicides on 2014-06-20\n",
      "No homicides on 2014-06-16\n",
      "No homicides on 2014-06-14\n",
      "No homicides on 2014-06-11\n",
      "No homicides on 2014-06-08\n",
      "No homicides on 2014-06-02\n",
      "No homicides on 2014-05-28\n",
      "No homicides on 2014-05-23\n",
      "No homicides on 2014-05-20\n",
      "No homicides on 2014-05-15\n",
      "No homicides on 2014-05-13\n",
      "No homicides on 2014-05-12\n",
      "No homicides on 2014-05-08\n",
      "No homicides on 2014-05-07\n",
      "No homicides on 2014-05-02\n",
      "No homicides on 2014-04-29\n",
      "No homicides on 2014-04-22\n",
      "No homicides on 2014-04-21\n",
      "No homicides on 2014-04-17\n",
      "No homicides on 2014-04-16\n",
      "No homicides on 2014-04-14\n",
      "No homicides on 2014-04-12\n",
      "No homicides on 2014-04-10\n",
      "No homicides on 2014-04-08\n",
      "No homicides on 2014-04-06\n",
      "No homicides on 2014-04-04\n",
      "No homicides on 2014-04-03\n",
      "No homicides on 2014-04-02\n",
      "No homicides on 2014-03-30\n",
      "No homicides on 2014-03-29\n",
      "No homicides on 2014-03-27\n",
      "No homicides on 2014-03-24\n",
      "No homicides on 2014-03-23\n",
      "No homicides on 2014-03-17\n",
      "No homicides on 2014-03-13\n",
      "No homicides on 2014-03-09\n",
      "No homicides on 2014-03-08\n",
      "No homicides on 2014-03-07\n",
      "No homicides on 2014-03-06\n",
      "No homicides on 2014-03-04\n",
      "No homicides on 2014-03-03\n",
      "No homicides on 2014-02-26\n",
      "No homicides on 2014-02-25\n",
      "No homicides on 2014-02-23\n",
      "No homicides on 2014-02-19\n",
      "No homicides on 2014-02-18\n",
      "No homicides on 2014-02-17\n",
      "No homicides on 2014-02-16\n",
      "No homicides on 2014-02-15\n",
      "No homicides on 2014-02-11\n",
      "No homicides on 2014-02-08\n",
      "No homicides on 2014-02-02\n",
      "No homicides on 2014-01-30\n",
      "No homicides on 2014-01-27\n",
      "No homicides on 2014-01-24\n",
      "No homicides on 2014-01-23\n",
      "No homicides on 2014-01-21\n",
      "No homicides on 2014-01-18\n",
      "No homicides on 2014-01-14\n",
      "No homicides on 2014-01-13\n",
      "No homicides on 2014-01-12\n",
      "No homicides on 2014-01-10\n",
      "No homicides on 2014-01-09\n",
      "No homicides on 2014-01-07\n",
      "No homicides on 2014-01-04\n",
      "No homicides on 2014-01-02\n",
      "No homicides on 2014-01-01\n"
     ]
    }
   ],
   "source": [
    "from datetime import date, timedelta\n",
    "\n",
    "test_date = date.today()\n",
    "one_day = timedelta(days=1)\n",
    "\n",
    "homicide_days = {}\n",
    "for homicide in homicides:\n",
    "    if homicide['Occ Date'] not in homicide_days:\n",
    "        homicide_days[homicide['Occ Date']] = 0\n",
    "    homicide_days[homicide['Occ Date']] += 1\n",
    "\n",
    "while test_date.year > 2013:\n",
    "    if test_date.strftime('%Y-%m-%d') not in homicide_days:\n",
    "        print 'No homicides on %s' % test_date\n",
    "    test_date -= one_day"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "Let's get the latitudes and longitudes of every murder in 2015 (Manya Brachear asked)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "coordinates = []\n",
    "for homicide in homicides:\n",
    "    if not homicide['Occ Date'].startswith('2015-'):\n",
    "        continue\n",
    "    # Since the format of this field is (x, y) (or y, x? I always confuse the two) we need to extract just x and y\n",
    "    try:\n",
    "        coordinates.append(\n",
    "            (homicide['Geocode Override'][1:-1].split(',')[0], homicide['Geocode Override'][1:-1].split(',')[1]))\n",
    "    except:\n",
    "        # Not valid/expected lat/long format\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "484\n"
     ]
    }
   ],
   "source": [
    "print len(coordinates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "41.87549740076065,-87.71006070077419\n",
      "41.99511721730232,-87.68506787717342\n",
      "41.75300158560276,-87.60407656431198\n",
      "41.715926080942154,-87.6460363715887\n",
      "41.784969329833984,-87.6525650024414\n",
      "41.75092315673828,-87.66917419433594\n",
      "41.87679022550583,-87.74513997137547\n",
      "41.877763867378235,-87.73800395429134\n",
      "41.88046216964722,-87.74548664689064\n",
      "41.90096664428711,-87.72660064697266\n",
      "41.765151992440224,-87.64943540096283\n",
      "41.951365023851395,-87.76714414358139\n",
      "41.790470123291016,-87.6502685546875\n",
      "41.858261,-87.653007\n",
      "41.729496002197266,-87.566162109375\n",
      "41.87741115689278,-87.75500379502773\n",
      "41.872432708740234,-87.71296691894531\n",
      "41.681470423936844,-87.62647099792957\n",
      "41.74011993408203,-87.66717529296875\n",
      "41.8740838766098,-87.76458531618118\n",
      "41.883392333984375,-87.7058334350586\n",
      "41.79697036743164,-87.65287780761719\n",
      "41.76420249044895,-87.56497532129288\n",
      "41.76323318481445,-87.64591979980469\n",
      "41.76974105834961,-87.6594467163086\n",
      "41.8737678527832,-87.7481918334961\n",
      "41.75372314453125,-87.61934661865234\n",
      "41.909419298172,-87.75896742939949\n",
      "41.83688499033451,-87.72830441594124\n",
      "41.66349157691002,-87.6197312772274\n",
      "41.76416493952274,-87.65427343547344\n",
      "41.96714782714844,-87.71367645263672\n",
      "42.000484466552734,-87.68230438232422\n",
      "41.723598,-87.606918\n",
      "41.752162,-87.710075\n",
      "41.893756,-87.751396\n",
      "41.7517248541117,-87.5701063871384\n",
      "41.7517248541117,-87.5701063871384\n",
      "41.863189,-87.733283\n",
      "41.86507,-87.703491\n",
      "41.815864,-87.689178\n",
      "41.7883329838514,-87.6843738555908\n",
      "41.864612,-87.725463\n",
      "41.8237582594156,-87.61893466115\n",
      "41.8822418153286,-87.6792857050896\n",
      "41.797424,-87.654098\n",
      "41.772445,-87.681236\n",
      "41.753452,-87.552421\n",
      "41.7506003379822,-87.6343164592981\n",
      "41.885379999876,-87.7402201294899\n",
      "41.753643,-87.669235\n",
      "41.7471697926521,-87.5747217983007\n",
      "41.859764,-87.711219\n",
      "41.7723751813173,-87.6533199101686\n",
      "41.8022348731756,-87.6111247390509\n",
      "41.676528,-87.628265\n",
      "41.850124,-87.624206\n",
      "41.806934,-87.615257\n",
      "41.7406647652388,-87.7000091224909\n",
      "41.712406,-87.619728\n",
      "41.745491,-87.684371\n",
      "41.8766983598471,-87.7616140991449\n",
      "41.902896,-87.75473\n",
      "41.8837632983923,-87.671847268939\n",
      "41.920963,-87.776237\n",
      "41.767269,-87.674026\n",
      "41.792312040925,-87.6463870704174\n",
      "41.884784,-87.741485\n",
      "41.858261,-87.653007\n",
      "41.776008,-87.594085\n",
      "41.96297,-87.652587\n",
      "41.909,-87.772132\n",
      "41.909,-87.772132\n",
      "41.97303,-87.727302\n",
      "41.8789554387331,-87.74515673518181\n",
      "41.899089,-87.697677\n",
      "41.74834460020065,-87.55014538764954\n",
      "41.733249,-87.668205\n",
      "41.697086,-87.540985\n",
      "41.877292,-87.756103\n",
      "41.851821,-87.623313\n",
      "41.92166022956371,-87.66866616904736\n",
      "41.67205,-87.651809\n",
      "41.76690950989723,-87.63725012540817\n",
      "41.77473,-87.664985\n",
      "41.751468,-87.674728\n",
      "41.913973689079285,-87.69482508301735\n",
      "41.96367636322975,-87.65643060207367\n",
      "41.84896230697632,-87.6929797232151\n",
      "41.855155,-87.711807\n",
      "41.72478340566158,-87.6274674385786\n",
      "41.831043,-87.679313\n",
      "41.7702763527632,-87.6833351701498\n",
      "41.924716,-87.679527\n",
      "41.75750732421875,-87.59112548828125\n",
      "41.749046325683594,-87.65093231201172\n",
      "41.866729736328125,-87.73160552978516\n",
      "41.866729736328125,-87.73160552978516\n",
      "41.77719511091709,-87.70217031240463\n",
      "41.7658805847168,-87.64842987060547\n",
      "41.7625617980957,-87.64521789550781\n",
      "41.864230781793594,-87.66014412045479\n",
      "41.738624572753906,-87.70101165771484\n",
      "41.90958786010742,-87.67179107666016\n",
      "41.88096618652344,-87.754638671875\n",
      "41.88337326049805,-87.7077407836914\n",
      "41.77137756347656,-87.58293914794922\n",
      "41.85826873779297,-87.6511001586914\n",
      "41.9406852722168,-87.72518157958984\n",
      "41.77930936217308,-87.67772264778614\n",
      "41.89248275756836,-87.75045013427734\n",
      "41.72402232885361,-87.5920046120882\n",
      "41.83072529733181,-87.64519214630127\n",
      "41.88679151237011,-87.74891182780266\n",
      "41.98450469970703,-87.69035339355469\n",
      "41.83580017089844,-87.6504898071289\n",
      "41.76045608520508,-87.6458511352539\n",
      "41.749656,-87.624107\n",
      "41.77372360229492,-87.60977172851562\n",
      "41.75808334350586,-87.60084533691406\n",
      "41.86223387718201,-87.71765470504761\n",
      "41.882877349853516,-87.72782897949219\n",
      "41.71367645263672,-87.62329864501953\n",
      "41.691442877054214,-87.6599308848381\n",
      "41.85919952392578,-87.71537780761719\n",
      "41.842247009277344,-87.72727966308594\n",
      "41.72749377787113,-87.66277268528938\n",
      "41.75651168823242,-87.55228424072266\n",
      "41.73261260986328,-87.6596908569336\n",
      "41.73261260986328,-87.6597908569336\n",
      "41.8937686085701,-87.70669654011726\n",
      "41.74286651611328,-87.55006408691406\n",
      "41.90428161621094,-87.75869750976562\n",
      "41.8889045715332,-87.7496566772461\n",
      "41.94822311401367,-87.71556091308594\n",
      "41.88696206562131,-87.63013947168031\n",
      "42.016894072294235,-87.67357796430588\n",
      "41.74956130981445,-87.57141876220703\n",
      "41.86449432373047,-87.73403930664062\n",
      "41.89308166503906,-87.72199249267578\n",
      "41.83879852294922,-87.72891235351562\n",
      "41.75822067260742,-87.63533782958984\n",
      "41.67595446109772,-87.61658303439617\n",
      "41.904808044433594,-87.74690246582031\n",
      "41.756656646728516,-87.67296600341797\n",
      "41.860450744628906,-87.73269653320312\n",
      "41.681609228253365,-87.61969707906246\n",
      "41.680744,-87.626029\n",
      "41.65723331272602,-87.60255441069603\n",
      "41.878858879208565,-87.72937193512917\n",
      "41.87954330444336,-87.72251892089844\n",
      "41.797088623046875,-87.76766967773438\n",
      "41.72490879893303,-87.63008259236813\n",
      "41.90894119441509,-87.72274754941463\n",
      "41.78593826293945,-87.66525268554688\n",
      "41.80402755737305,-87.59160614013672\n",
      "41.78367233276367,-87.65738677978516\n",
      "41.88867950439453,-87.7520523071289\n",
      "41.872249603271484,-87.69441223144531\n",
      "41.770328521728516,-87.5730972290039\n",
      "41.89345169067383,-87.76100158691406\n",
      "41.80852800607681,-87.61622093617916\n",
      "41.868160247802734,-87.69996643066406\n",
      "41.85676574707031,-87.71356964111328\n",
      "41.910972,-87.773132\n",
      "41.819236755371094,-87.60568237304688\n",
      "41.739749908447266,-87.657958984375\n",
      "41.742488861083984,-87.6677474975586\n",
      "41.697601,-87.647758\n",
      "41.74557113647461,-87.59134674072266\n",
      "41.90007,-87.69963\n",
      "41.750492095947266,-87.59996032714844\n",
      "41.78658150136471,-87.68070191144943\n",
      "41.67633466422558,-87.61634632945061\n",
      "42.02060021460056,-87.67182514071465\n",
      "41.790569,-87.642982\n",
      "41.882602,-87.720863\n",
      "41.84855651855469,-87.69306945800781\n",
      "41.78725051879883,-87.64764404296875\n",
      "41.74401752650738,-87.60484769940376\n",
      "41.80069260299206,-87.70258001983166\n",
      "41.89556635916233,-87.7224538475275\n",
      "41.890052407979965,-87.7606250345707\n",
      "41.90552520751953,-87.76318359375\n",
      "42.00804948806763,-87.65950709581375\n",
      "41.91335543990135,-87.6630449295044\n",
      "41.89878836274147,-87.7482620626688\n",
      "41.761905670166016,-87.61431121826172\n",
      "41.69164203107357,-87.63048492372036\n",
      "41.854000091552734,-87.69666290283203\n",
      "41.85365295410156,-87.72742462158203\n",
      "41.69097137451172,-87.6280288696289\n",
      "41.879955,-87.735649\n",
      "41.8018647283316,-87.6551304012537\n",
      "41.76494814455509,-87.6591745018959\n",
      "41.6778206080198,-87.6287005841732\n",
      "41.735702008009,-87.6324657350779\n",
      "41.686565,-87.617195\n",
      "42.01246306300163,-87.67455160617828\n",
      "41.9670874625444,-87.6629228889942\n",
      "41.70264311134815,-87.56447106599808\n",
      "41.80857293307781,-87.67512492835522\n",
      "41.703178,-87.629547\n",
      "41.839984,-87.721115\n",
      "41.748016,-87.589721\n",
      "41.747959,-87.637001\n",
      "41.946983,-87.772705\n",
      "41.876914,-87.703178\n",
      "41.741107,-87.586074\n",
      "41.725269,-87.657035\n",
      "41.790615,-87.656852\n",
      "41.763603,-87.676414\n",
      "41.77135527133942,-87.57649272680283\n",
      "41.74272067844868,-87.56330899894238\n",
      "41.92124515771866,-87.79170513153076\n",
      "41.764179,-87.698173\n",
      "41.788367852568626,-87.61588633060455\n",
      "41.763920187950134,-87.61506892740726\n",
      "41.924404,-87.756927\n",
      "41.733184,-87.604278\n",
      "41.895946,-87.693428\n",
      "41.688198,-87.643814\n",
      "41.78455911576748,-87.61568114161491\n",
      "41.708343,-87.651741\n",
      "41.748287,-87.701965\n",
      "41.762641,-87.589347\n",
      "41.766128,-87.68975\n",
      "41.81634195148945,-87.6263053715229\n",
      "41.76387995481491,-87.5793707370758\n",
      "41.915016,-87.689941\n",
      "41.719192,-87.64402\n",
      "41.8481120467186,-87.7126148343086\n",
      "41.687873,-87.636535\n",
      "41.79047,-87.650268\n",
      "41.930697932839394,-87.75140225887299\n",
      "41.930697932839394,-87.75140225887299\n",
      "41.97314187884331,-87.68438592553139\n",
      "41.93267,-87.691925\n",
      "41.872901,-87.713798\n",
      "41.6552848815918,-87.60883331298828\n",
      "41.887027740478516,-87.74748229980469\n",
      "41.74806594848633,-87.63145446777344\n",
      "41.70080244541168,-87.5632493197918\n",
      "41.995281502604485,-87.68605962395668\n",
      "41.758766174316406,-87.60577392578125\n",
      "41.743099212646484,-87.54700469970703\n",
      "41.805167868733406,-87.67345391213894\n",
      "41.96761518716812,-87.65894517302513\n",
      "41.900455355644226,-87.75670632719994\n",
      "41.69953536987305,-87.62936401367188\n",
      "41.69953536987305,-87.62936401367188\n",
      "41.77675247192383,-87.67418670654297\n",
      "41.742509454488754,-87.55146704614162\n",
      "41.805877685546875,-87.72632598876953\n",
      "41.917137145996094,-87.69963073730469\n",
      "41.769447,-87.621307\n",
      "41.83701507747173,-87.65858441591263\n",
      "41.78195571899414,-87.66999053955078\n",
      "41.82877667248249,-87.62562811374664\n",
      "41.95573425292969,-87.72312927246094\n",
      "41.96943171322346,-87.65621937811375\n",
      "41.85253635048866,-87.69429333508015\n",
      "41.93540185689926,-87.65356063842773\n",
      "41.79334066808224,-87.715023458004\n",
      "41.79334066808224,-87.715023458004\n",
      "41.86262212693691,-87.65195734798908\n",
      "41.75053024291992,-87.58251953125\n",
      "41.78877639770508,-87.66844940185547\n",
      "41.883385106921196,-87.74531498551369\n",
      "42.014163970947266,-87.66968536376953\n",
      "41.67222820222378,-87.65409640967846\n",
      "41.84933580458164,-87.69299380481243\n",
      "41.687259,-87.635826\n",
      "41.7362174987793,-87.62311553955078\n",
      "41.91033172607422,-87.74549102783203\n",
      "41.90887078642845,-87.74613448808193\n",
      "41.752628326416016,-87.60314178466797\n",
      "41.98073959350586,-87.84066772460938\n",
      "41.817474365234375,-87.61873626708984\n",
      "41.900474801659584,-87.7543057501316\n",
      "41.8133659362793,-87.60636138916016\n",
      "41.77873611450195,-87.70002746582031\n",
      "41.816139221191406,-87.70393371582031\n",
      "41.96317948400974,-87.65613622963428\n",
      "41.880523681640625,-87.71273803710938\n",
      "41.813846588134766,-87.6715316772461\n",
      "41.75027444958687,-87.60400213301182\n",
      "41.962164267897606,-87.66098029911518\n",
      "41.751058995723724,-87.60771632194519\n",
      "42.020865082740784,-87.67063423991203\n",
      "41.74257278442383,-87.56087493896484\n",
      "41.9099644571543,-87.7312682569027\n",
      "41.85408020019531,-87.72941589355469\n",
      "41.78364944458008,-87.66276550292969\n",
      "41.758122593164444,-87.63477645814419\n",
      "41.86186218261719,-87.71615600585938\n",
      "41.99005588889122,-87.67051622271538\n",
      "41.90263666212559,-87.73316256701946\n",
      "41.831116899847984,-87.62029655277729\n",
      "41.754188537597656,-87.55104064941406\n",
      "41.89460372924805,-87.72079467773438\n",
      "41.726089641451836,-87.65068396925926\n",
      "41.69953536987305,-87.62936401367188\n",
      "41.81142807006836,-87.66834259033203\n",
      "41.801326751708984,-87.68939971923828\n",
      "41.916358947753906,-87.69257354736328\n",
      "41.872420236468315,-87.73312568664551\n",
      "41.96316406130791,-87.68319837749004\n",
      "41.65565013885498,-87.59499661624432\n",
      "41.8051643371582,-87.66400909423828\n",
      "41.81578941643238,-87.61825136840343\n",
      "41.88235580921173,-87.76662446558475\n",
      "41.7619743347168,-87.59053802490234\n",
      "41.72682189941406,-87.58704376220703\n",
      "41.77486762404442,-87.58887447416782\n",
      "41.77076183259487,-87.62678481638432\n",
      "41.75542026758194,-87.56264984607697\n",
      "41.749053955078125,-87.61542510986328\n",
      "41.8681755065918,-87.69874572753906\n",
      "41.90099582076073,-87.72386468946934\n",
      "41.96542717516422,-87.73851558566093\n",
      "41.96542717516422,-87.73851558566093\n",
      "41.99972525238991,-87.68102511763573\n",
      "41.8672127276659,-87.71412827074528\n",
      "41.89018249511719,-87.7224349975586\n",
      "41.96720886230469,-87.70686340332031\n",
      "41.75190734863281,-87.57015228271484\n",
      "41.75825469195843,-87.60776996612549\n",
      "41.878047943115234,-87.75535583496094\n",
      "41.78723193705082,-87.6255563646555\n",
      "41.78033262491226,-87.60050050914288\n",
      "41.76235109567642,-87.59721949696541\n",
      "41.89308166503906,-87.72199249267578\n",
      "41.84798812866211,-87.70671081542969\n",
      "41.88839340209961,-87.75\n",
      "41.751983642578125,-87.70284271240234\n",
      "41.7431526184082,-87.60222625732422\n",
      "41.876583099365234,-87.66895294189453\n",
      "41.901283264160156,-87.72469329833984\n",
      "41.90308380126953,-87.7094497680664\n",
      "41.828026324510574,-87.60264560580254\n",
      "41.814720153808594,-87.67033386230469\n",
      "41.86351664364338,-87.65241399407387\n",
      "41.901687,-87.765983\n",
      "41.898231506347656,-87.75979614257812\n",
      "41.77754592895508,-87.66329193115234\n",
      "41.696791872382164,-87.65566349029541\n",
      "41.74757766723633,-87.55802154541016\n",
      "41.87440171837807,-87.72503547370434\n",
      "41.89387893676758,-87.71175384521484\n",
      "41.87681034207344,-87.63328582048416\n",
      "41.6959228515625,-87.63679504394531\n",
      "41.864433,-87.713294\n",
      "41.808650970458984,-87.68486022949219\n",
      "41.6959228515625,-87.63679504394531\n",
      "41.87542724609375,-87.73374938964844\n",
      "41.923775151371956,-87.78392471373081\n",
      "41.93023592233658,-87.71718464791775\n",
      "41.923755034804344,-87.77720645070076\n",
      "41.75874710083008,-87.6329345703125\n",
      "41.79877471923828,-87.64439392089844\n",
      "41.81981658935547,-87.70161437988281\n",
      "41.9072380065918,-87.64765930175781\n",
      "41.788313537836075,-87.68530324101448\n",
      "41.887062072753906,-87.745849609375\n",
      "41.790035247802734,-87.66656494140625\n",
      "41.898877546191216,-87.74838544428349\n",
      "41.887590140104294,-87.71603062748909\n",
      "41.75826206803322,-87.61517688632011\n",
      "41.87586084008217,-87.70279325544834\n",
      "41.69822311401367,-87.6283950805664\n",
      "41.92166022956371,-87.66866616904736\n",
      "41.86608485877514,-87.65746727585793\n",
      "41.745129972696304,-87.60130651295185\n",
      "41.87197297811508,-87.70114503800869\n",
      "41.80535888671875,-87.60330963134766\n",
      "41.90188980102539,-87.74629974365234\n",
      "41.773036,-87.62236\n",
      "41.92384958267212,-87.77834638953209\n",
      "41.863033294677734,-87.7345199584961\n",
      "41.97366692125797,-87.65755847096443\n",
      "41.76020050048828,-87.55979919433594\n",
      "41.930885314941406,-87.77523040771484\n",
      "41.770641803741455,-87.64656476676464\n",
      "41.97338528931141,-87.65766642987728\n",
      "41.88274383544922,-87.68551635742188\n",
      "41.88559341430664,-87.71090698242188\n",
      "41.7086296081543,-87.63958740234375\n",
      "41.74757480621338,-87.60450035333633\n",
      "41.87884546816349,-87.70406529307365\n",
      "41.884407699108124,-87.65248775482178\n",
      "41.78346544504166,-87.60592393577099\n",
      "41.91034600138664,-87.69914478063583\n",
      "41.94204702973366,-87.73202665150166\n",
      "41.740570068359375,-87.54503631591797\n",
      "41.679721,-87.623085\n",
      "41.84810467064381,-87.7130513638258\n",
      "41.962290331721306,-87.71320089697838\n",
      "41.788719,-87.628784\n",
      "41.90276809036732,-87.73112945258617\n",
      "41.81467495858669,-87.59894214570522\n",
      "41.68511199951172,-87.6632080078125\n",
      "41.909620463848114,-87.76559382677078\n",
      "41.90422439575195,-87.76485443115234\n",
      "41.83935597538948,-87.62197963893414\n",
      "41.673072814941406,-87.65724182128906\n",
      "41.718639,-87.647651\n",
      "41.85792960226536,-87.6544913649559\n",
      "41.81819066405296,-87.63559184968472\n",
      "41.81819066405296,-87.63559184968472\n",
      "41.78644739091396,-87.72302784025669\n",
      "41.875271424651146,-87.72199183702469\n",
      "41.7357177734375,-87.68943786621094\n",
      "41.86648941040039,-87.72295379638672\n",
      "41.857215881347656,-87.7220458984375\n",
      "41.857215881347656,-87.7220458984375\n",
      "41.90308392047882,-87.73114286363125\n",
      "41.87141036987305,-87.72195434570312\n",
      "41.78266906738281,-87.68827056884766\n",
      "41.89501953125,-87.77265167236328\n",
      "41.683246,-87.669494\n",
      "41.796382904052734,-87.69840240478516\n",
      "41.79697036743164,-87.65287780761719\n",
      "41.74348175525665,-87.62567639350891\n",
      "41.836345,-87.657249\n",
      "41.727020263671875,-87.5964584350586\n",
      "41.70932388305664,-87.61538696289062\n",
      "41.80946946144104,-87.60741390287876\n",
      "41.90933609008789,-87.72563934326172\n",
      "41.69841003417969,-87.63380432128906\n",
      "41.797424,-87.642448\n",
      "41.97446060180664,-87.77855682373047\n",
      "41.73586654663086,-87.62211608886719\n",
      "41.81819066405296,-87.63559184968472\n",
      "41.888355910778046,-87.72347442805767\n",
      "41.74556350708008,-87.60662841796875\n",
      "41.701637268066406,-87.61762237548828\n",
      "41.795555,-87.619712\n",
      "41.84522247314453,-87.72370147705078\n",
      "41.88483428955078,-87.73595428466797\n",
      "41.8007698059082,-87.69173431396484\n",
      "41.74797439575195,-87.67343139648438\n",
      "41.791568756103516,-87.68489074707031\n",
      "41.75370633602142,-87.54996433854103\n",
      "41.80173110961914,-87.65369415283203\n",
      "41.759803771972656,-87.65312194824219\n",
      "41.801696,-87.623123\n",
      "41.786827087402344,-87.64289093017578\n",
      "41.90650939941406,-87.73414611816406\n",
      "41.896541595458984,-87.76510620117188\n",
      "41.879886,-87.736633\n",
      "41.761653900146484,-87.65567779541016\n",
      "41.78083038330078,-87.68891906738281\n",
      "41.900630950927734,-87.75241088867188\n",
      "41.685161143541336,-87.6253940910101\n",
      "41.77498245239258,-87.64795684814453\n",
      "41.674732,-87.620765\n",
      "41.86090014874935,-87.70792029798031\n",
      "41.797843,-87.643157\n",
      "41.77383804321289,-87.66568756103516\n",
      "41.80325947701931,-87.65127405524254\n",
      "41.875966116786,-87.74537734687328\n",
      "41.96648329496384,-87.6502051949501\n",
      "41.76313781738281,-87.65250396728516\n",
      "41.96864700317383,-87.71489715576172\n",
      "41.912742614746094,-87.76469421386719\n",
      "41.7430305480957,-87.65753173828125\n",
      "41.774775087833405,-87.61276759207249\n",
      "41.77017778158188,-87.61458680033684\n",
      "41.79904556274414,-87.64685821533203\n",
      "41.900631710886955,-87.75324292480946\n",
      "41.72701232135296,-87.64111518859863\n",
      "41.75310082733631,-87.67204910516739\n",
      "41.76525995135307,-87.64392882585526\n",
      "41.78710386157036,-87.63026498258114\n",
      "41.78710386157036,-87.63026498258114\n",
      "41.87274932861328,-87.73117065429688\n",
      "41.72932815551758,-87.59772491455078\n",
      "41.80852197110653,-87.66016691923141\n",
      "41.795753479003906,-87.66255950927734\n",
      "41.873554,-87.694236\n",
      "41.953147888183594,-87.7107925415039\n",
      "41.744319915771484,-87.59687042236328\n",
      "41.73358917236328,-87.55036163330078\n"
     ]
    }
   ],
   "source": [
    "for coordinate in coordinates:\n",
    "    print '%s,%s' % (coordinate[0].strip(), coordinate[1].strip())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}