koords.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import koordinates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "client = koordinates.Client(host='labs.koordinates.com', token='06e2dc0ee7304b6faf10b8e643a2e091')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "AuthenticationError",
     "evalue": "401 Client Error: UNAUTHORIZED",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mHTTPError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36m_raw_request\u001b[1;34m(self, method, url, headers, *args, **kwargs)\u001b[0m\n\u001b[0;32m    138\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdebug\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Response: headers=%s'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mheaders\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 139\u001b[1;33m             \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mraise_for_status\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    140\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/lib/python3/dist-packages/requests/models.py\u001b[0m in \u001b[0;36mraise_for_status\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    824\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mhttp_error_msg\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 825\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mHTTPError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mhttp_error_msg\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    826\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mHTTPError\u001b[0m: 401 Client Error: UNAUTHORIZED",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mAuthenticationError\u001b[0m                       Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-30-d7087f279564>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[1;32mfor\u001b[0m \u001b[0mlayer\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mclient\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlayers\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0morder_by\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'created_at'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;36m10\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m     \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlayer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m__getitem__\u001b[1;34m(self, k)\u001b[0m\n\u001b[0;32m    214\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Only query[:N] slicing is supported.\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    215\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 216\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mlist\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitertools\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mislice\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__iter__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mk\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstop\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    217\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    218\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_clone\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m__iter__\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    168\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    169\u001b[0m             \u001b[0murl\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_to_url\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 170\u001b[1;33m             \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0murl\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    171\u001b[0m             \u001b[0mpage_results\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjson\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    172\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m_request\u001b[1;34m(self, url, method)\u001b[0m\n\u001b[0;32m    113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    114\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'GET'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 115\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_manager\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclient\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheaders\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_to_headers\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    116\u001b[0m         \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mraise_for_status\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    117\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36mrequest\u001b[1;34m(self, method, url, *args, **kwargs)\u001b[0m\n\u001b[0;32m    110\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    111\u001b[0m         \u001b[0mheaders\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_assemble_headers\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpop\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"headers\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 112\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_raw_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheaders\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    114\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mmethod\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'POST'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36m_raw_request\u001b[1;34m(self, method, url, headers, *args, **kwargs)\u001b[0m\n\u001b[0;32m    141\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mHTTPError\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    142\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mwarn\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Response: %s: %s'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 143\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mexceptions\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mServerError\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_requests_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    144\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mRequestException\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    145\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mexceptions\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mServerError\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_requests_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mAuthenticationError\u001b[0m: 401 Client Error: UNAUTHORIZED"
     ]
    }
   ],
   "source": [
    "for layer in client.layers.order_by('created_at')[:10]:\n",
    "    print(layer)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "clcata = client.catalog"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "cli = clcata.list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CatalogManager.list of <koordinates.catalog.CatalogManager object at 0xb192c270>>"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cli"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "clcata.get"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "AuthenticationError",
     "evalue": "401 Client Error: UNAUTHORIZED",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mHTTPError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36m_raw_request\u001b[1;34m(self, method, url, headers, *args, **kwargs)\u001b[0m\n\u001b[0;32m    138\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdebug\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Response: headers=%s'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mheaders\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 139\u001b[1;33m             \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mraise_for_status\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    140\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/lib/python3/dist-packages/requests/models.py\u001b[0m in \u001b[0;36mraise_for_status\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    824\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mhttp_error_msg\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 825\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mHTTPError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mhttp_error_msg\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    826\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mHTTPError\u001b[0m: 401 Client Error: UNAUTHORIZED",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mAuthenticationError\u001b[0m                       Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-26-fefc95ea3b59>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[1;32mfor\u001b[0m \u001b[0mlayer\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mclient\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlayers\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlist\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m     \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlayer\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mid\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m__iter__\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    168\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    169\u001b[0m             \u001b[0murl\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_to_url\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 170\u001b[1;33m             \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0murl\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    171\u001b[0m             \u001b[0mpage_results\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjson\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    172\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m_request\u001b[1;34m(self, url, method)\u001b[0m\n\u001b[0;32m    113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    114\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'GET'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 115\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_manager\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclient\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheaders\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_to_headers\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    116\u001b[0m         \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mraise_for_status\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    117\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36mrequest\u001b[1;34m(self, method, url, *args, **kwargs)\u001b[0m\n\u001b[0;32m    110\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    111\u001b[0m         \u001b[0mheaders\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_assemble_headers\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpop\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"headers\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 112\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_raw_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheaders\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    114\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mmethod\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'POST'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36m_raw_request\u001b[1;34m(self, method, url, headers, *args, **kwargs)\u001b[0m\n\u001b[0;32m    141\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mHTTPError\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    142\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mwarn\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Response: %s: %s'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 143\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mexceptions\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mServerError\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_requests_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    144\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mRequestException\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    145\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mexceptions\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mServerError\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_requests_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mAuthenticationError\u001b[0m: 401 Client Error: UNAUTHORIZED"
     ]
    }
   ],
   "source": [
    "for layer in client.layers.list():\n",
    "    print(layer.id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "opschoolzone = open('/home/wcm/Downloads/ccschool.csv', 'r')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "UnicodeDecodeError",
     "evalue": "'ascii' codec can't decode byte 0xe2 in position 2128: ordinal not in range(128)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mUnicodeDecodeError\u001b[0m                        Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-6-15ff8443a20f>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mrdsczone\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mopschoolzone\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m/usr/lib/python3.4/encodings/ascii.py\u001b[0m in \u001b[0;36mdecode\u001b[1;34m(self, input, final)\u001b[0m\n\u001b[0;32m     24\u001b[0m \u001b[1;32mclass\u001b[0m \u001b[0mIncrementalDecoder\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcodecs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mIncrementalDecoder\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     25\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mdecode\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minput\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfinal\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mFalse\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 26\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mcodecs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mascii_decode\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0minput\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0merrors\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     27\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     28\u001b[0m \u001b[1;32mclass\u001b[0m \u001b[0mStreamWriter\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mCodec\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mcodecs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mStreamWriter\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mUnicodeDecodeError\u001b[0m: 'ascii' codec can't decode byte 0xe2 in position 2128: ordinal not in range(128)"
     ]
    }
   ],
   "source": [
    "rdsczone = opschoolzone.read()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "AuthenticationError",
     "evalue": "401 Client Error: UNAUTHORIZED",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mHTTPError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36m_raw_request\u001b[1;34m(self, method, url, headers, *args, **kwargs)\u001b[0m\n\u001b[0;32m    138\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdebug\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Response: headers=%s'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mheaders\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 139\u001b[1;33m             \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mraise_for_status\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    140\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/lib/python3/dist-packages/requests/models.py\u001b[0m in \u001b[0;36mraise_for_status\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    824\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mhttp_error_msg\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 825\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mHTTPError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mhttp_error_msg\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    826\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mHTTPError\u001b[0m: 401 Client Error: UNAUTHORIZED",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mAuthenticationError\u001b[0m                       Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-25-d7087f279564>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[1;32mfor\u001b[0m \u001b[0mlayer\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mclient\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlayers\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0morder_by\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'created_at'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;36m10\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m     \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlayer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m__getitem__\u001b[1;34m(self, k)\u001b[0m\n\u001b[0;32m    214\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Only query[:N] slicing is supported.\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    215\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 216\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mlist\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitertools\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mislice\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__iter__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mk\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstop\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    217\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    218\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_clone\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m__iter__\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    168\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    169\u001b[0m             \u001b[0murl\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_to_url\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 170\u001b[1;33m             \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0murl\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    171\u001b[0m             \u001b[0mpage_results\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjson\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    172\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/base.py\u001b[0m in \u001b[0;36m_request\u001b[1;34m(self, url, method)\u001b[0m\n\u001b[0;32m    113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    114\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'GET'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 115\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_manager\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclient\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheaders\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_to_headers\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    116\u001b[0m         \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mraise_for_status\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    117\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36mrequest\u001b[1;34m(self, method, url, *args, **kwargs)\u001b[0m\n\u001b[0;32m    110\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    111\u001b[0m         \u001b[0mheaders\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_assemble_headers\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpop\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"headers\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 112\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_raw_request\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheaders\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    114\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mmethod\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'POST'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/local/lib/python3.4/dist-packages/koordinates/client.py\u001b[0m in \u001b[0;36m_raw_request\u001b[1;34m(self, method, url, headers, *args, **kwargs)\u001b[0m\n\u001b[0;32m    141\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mHTTPError\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    142\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mwarn\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Response: %s: %s'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 143\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mexceptions\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mServerError\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_requests_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    144\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mRequestException\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    145\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mexceptions\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mServerError\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_requests_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mAuthenticationError\u001b[0m: 401 Client Error: UNAUTHORIZED"
     ]
    }
   ],
   "source": [
    "for layer in client.layers.order_by('created_at')[:10]:\n",
    "    print(layer)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "schnam = pandas.read_csv('/home/wcm/Downloads/nzschoolzone.csv', index_col=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SchoolName\n",
       "Palmerston North Intermediate     POLYGON ((2730615.392561290878803 6090740.2981...\n",
       "Freyberg High School              POLYGON ((2745043.800439903512597 6112272.2000...\n",
       "Mangorei School                   POLYGON ((2600820.374574344605207 6221545.9363...\n",
       "Henderson Intermediate            MULTIPOLYGON (((2655706.400050358846784 647910...\n",
       "Waitakere School                  POLYGON ((2638211.172554983757436 6481043.2694...\n",
       "Hutt Intermediate                 POLYGON ((2670071.899875052738935 5993800.9007...\n",
       "Tawa Intermediate                 POLYGON ((2665593.000167114194483 6001129.0004...\n",
       "Tawa College                      POLYGON ((2665593.000167114194483 6001129.0004...\n",
       "Long Bay College (Home Zone 1)    POLYGON ((2661280.464295980520546 6501402.4220...\n",
       "Long Bay College (Home Zone 2)    POLYGON ((2664664.430524981580675 6501501.9185...\n",
       "Clive School                      POLYGON ((2842612.622409 6171176.2446414381265...\n",
       "Paremata School                   POLYGON ((2666257.528198571875691 6009107.7309...\n",
       "Fairfield School (Dunedin)        POLYGON ((2307516.583301387261599 5477283.7539...\n",
       "Riverdale School (P North)        POLYGON ((2730601.000682259444147 6088867.9998...\n",
       "Fernside School                   POLYGON ((2473495.105003115255386 5768297.1780...\n",
       "...\n",
       "Hurupaki School                 POLYGON ((2627575.883569485042244 6612390.5332...\n",
       "Mt Albert Grammar School        POLYGON ((2662916.948640319053084 6478821.6355...\n",
       "Brightwater School              POLYGON ((2514303.539093079511076 5985865.0162...\n",
       "Maori Hill School               POLYGON ((2316327.270695094484836 5480556.5303...\n",
       "Woodend School                  POLYGON ((2486750.50003167334944 5765002.89961...\n",
       "Goldfields School (Cromwell)    POLYGON ((2198555.058699835557491 5573970.2297...\n",
       "Papakowhai School               POLYGON ((2667153.139621315058321 6007286.0829...\n",
       "Heathcote Valley School         POLYGON ((2486673.445020992774516 5734897.7473...\n",
       "Hastings Intermediate           POLYGON ((2840876.605659266468138 6169538.7043...\n",
       "Ngatea School                   POLYGON ((2728265.140026539098471 6439337.1802...\n",
       "Makarewa School                 POLYGON ((2147037.691040768753737 5427733.9947...\n",
       "Stonefields School              POLYGON ((2673623.120287223253399 6477684.7821...\n",
       "Wakefield School                POLYGON ((2502458.437301402911544 5980917.3828...\n",
       "Maidstone Intermediate          POLYGON ((2685459.300130560062826 6004301.5002...\n",
       "Thorndon School                 MULTIPOLYGON (((2658828.394955039955676 599186...\n",
       "Name: What, Length: 713, dtype: object"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schnam.What.cal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>﻿WKT</th>\n",
       "      <th>SchoolID</th>\n",
       "      <th>Office</th>\n",
       "      <th>ApprovalDate</th>\n",
       "      <th>EffectiveDate</th>\n",
       "      <th>INSTTYPE</th>\n",
       "      <th>Underreview</th>\n",
       "      <th>chk</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SchoolName</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Palmerston North Intermediate</th>\n",
       "      <td> POLYGON ((2730615.392561290878803 6090740.2981...</td>\n",
       "      <td>    2419</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> Intermediate</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freyberg High School</th>\n",
       "      <td> POLYGON ((2745043.800439903512597 6112272.2000...</td>\n",
       "      <td>     200</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mangorei School</th>\n",
       "      <td> POLYGON ((2600820.374574344605207 6221545.9363...</td>\n",
       "      <td>    2189</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Henderson Intermediate</th>\n",
       "      <td> MULTIPOLYGON (((2655706.400050358846784 647910...</td>\n",
       "      <td>    1307</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2002/12/18</td>\n",
       "      <td> 2002/12/18</td>\n",
       "      <td> Intermediate</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waitakere School</th>\n",
       "      <td> POLYGON ((2638211.172554983757436 6481043.2694...</td>\n",
       "      <td>    1557</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2008/02/21</td>\n",
       "      <td> 2008/02/21</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hutt Intermediate</th>\n",
       "      <td> POLYGON ((2670071.899875052738935 5993800.9007...</td>\n",
       "      <td>    2863</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> Intermediate</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tawa Intermediate</th>\n",
       "      <td> POLYGON ((2665593.000167114194483 6001129.0004...</td>\n",
       "      <td>    3034</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> Intermediate</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tawa College</th>\n",
       "      <td> POLYGON ((2665593.000167114194483 6001129.0004...</td>\n",
       "      <td>     257</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long Bay College (Home Zone 1)</th>\n",
       "      <td> POLYGON ((2661280.464295980520546 6501402.4220...</td>\n",
       "      <td>   27002</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2005/11/02</td>\n",
       "      <td> 2005/11/02</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long Bay College (Home Zone 2)</th>\n",
       "      <td> POLYGON ((2664664.430524981580675 6501501.9185...</td>\n",
       "      <td>   27001</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2005/11/02</td>\n",
       "      <td> 2008/01/01</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Clive School</th>\n",
       "      <td> POLYGON ((2842612.622409 6171176.2446414381265...</td>\n",
       "      <td>    2549</td>\n",
       "      <td> HM</td>\n",
       "      <td> 2004/06/14</td>\n",
       "      <td> 2004/06/14</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Paremata School</th>\n",
       "      <td> POLYGON ((2666257.528198571875691 6009107.7309...</td>\n",
       "      <td>    2950</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/02/25</td>\n",
       "      <td> 2003/02/25</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fairfield School (Dunedin)</th>\n",
       "      <td> POLYGON ((2307516.583301387261599 5477283.7539...</td>\n",
       "      <td>    3736</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2003/01/22</td>\n",
       "      <td> 2003/01/22</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Riverdale School (P North)</th>\n",
       "      <td> POLYGON ((2730601.000682259444147 6088867.9998...</td>\n",
       "      <td>    2437</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/02/25</td>\n",
       "      <td> 2003/02/25</td>\n",
       "      <td> Contributing</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fernside School</th>\n",
       "      <td> POLYGON ((2473495.105003115255386 5768297.1780...</td>\n",
       "      <td>    3340</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Christchurch Girls' High School</th>\n",
       "      <td> POLYGON ((2480632.30014349007979 5742883.50030...</td>\n",
       "      <td>     328</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2005/08/10</td>\n",
       "      <td> 2005/08/10</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Plimmerton School</th>\n",
       "      <td> POLYGON ((2670008.799272179603577 6010857.4998...</td>\n",
       "      <td>    2960</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Palmerston North Girls' High School</th>\n",
       "      <td> POLYGON ((2731754.900352925993502 6089216.6996...</td>\n",
       "      <td>     203</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Frankley School</th>\n",
       "      <td> POLYGON ((2600242.385744854342192 6235684.5896...</td>\n",
       "      <td>    2168</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> 2003/01/07</td>\n",
       "      <td> Contributing</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Allenton School</th>\n",
       "      <td> POLYGON ((2407791.063124474603683 5701653.6885...</td>\n",
       "      <td>    3274</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td> Contributing</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rosebank School (Balclutha)</th>\n",
       "      <td> POLYGON ((2256514.299498674925417 5436773.5002...</td>\n",
       "      <td>    3812</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2003/07/08</td>\n",
       "      <td> 2003/07/07</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Riverlands School</th>\n",
       "      <td> POLYGON ((2590106.899930706247687 5965576.6998...</td>\n",
       "      <td>    2981</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2003/07/08</td>\n",
       "      <td> 2003/07/08</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wellington Girls' College</th>\n",
       "      <td> POLYGON ((2658880.700493346434087 5989905.1005...</td>\n",
       "      <td>     272</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Westburn School</th>\n",
       "      <td> POLYGON ((2474449.999938263557851 5745198.4999...</td>\n",
       "      <td>    3589</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2003/01/22</td>\n",
       "      <td> 2003/01/22</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Avonside Girls' High School</th>\n",
       "      <td> POLYGON ((2481365.959411066025496 5743985.8583...</td>\n",
       "      <td>     324</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2005/08/10</td>\n",
       "      <td> 2005/08/10</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beckenham School</th>\n",
       "      <td> POLYGON ((2480684.000307884067297 5738421.0002...</td>\n",
       "      <td>    3291</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burnside High School</th>\n",
       "      <td> POLYGON ((2473925.199291485361755 5746697.4005...</td>\n",
       "      <td>     319</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hukanui School</th>\n",
       "      <td> POLYGON ((2711431.800331362057477 6380387.7998...</td>\n",
       "      <td>    1749</td>\n",
       "      <td> HM</td>\n",
       "      <td> 2003/09/22</td>\n",
       "      <td> 2003/09/22</td>\n",
       "      <td> Contributing</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Massey Primary School</th>\n",
       "      <td> POLYGON ((2653362.500090703833848 6485832.9002...</td>\n",
       "      <td>    1363</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2002/09/30</td>\n",
       "      <td> 2002/09/30</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kerikeri High School</th>\n",
       "      <td> POLYGON ((2596289.317205696832389 6678005.9493...</td>\n",
       "      <td>       5</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td> 2002/12/06</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Matarau School (years 7-8)</th>\n",
       "      <td> POLYGON ((2619284.816485492978245 6612291.4422...</td>\n",
       "      <td> 1043001</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2009/12/01</td>\n",
       "      <td> 2009/12/01</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kaukapakapa School</th>\n",
       "      <td> POLYGON ((2639489.203145041130483 6513715.0492...</td>\n",
       "      <td>    1326</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2009/12/17</td>\n",
       "      <td> 2009/12/17</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hillcrest High School</th>\n",
       "      <td> MULTIPOLYGON (((2731829.250435898546129 637692...</td>\n",
       "      <td>     138</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2009/12/22</td>\n",
       "      <td> 2009/12/22</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mosston School</th>\n",
       "      <td> POLYGON ((2681487.999516027513891 6141264.9992...</td>\n",
       "      <td>    2403</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2010/02/04</td>\n",
       "      <td> 2005/01/01</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Porirua College</th>\n",
       "      <td> POLYGON ((2664900.500163984019309 6006179.9997...</td>\n",
       "      <td>     255</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2010/02/04</td>\n",
       "      <td> 2010/02/08</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Devonport School</th>\n",
       "      <td> POLYGON ((2671321.956953046377748 6484140.2010...</td>\n",
       "      <td>    1260</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/03/15</td>\n",
       "      <td> 2010/03/15</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Onewhero Area School (Years 7-13)</th>\n",
       "      <td> POLYGON ((2674050.258564048446715 6433841.7871...</td>\n",
       "      <td>  108001</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/03/31</td>\n",
       "      <td> 2010/03/31</td>\n",
       "      <td>    Composite</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dunsandel School</th>\n",
       "      <td> POLYGON ((2431517.19942346168682 5733284.59920...</td>\n",
       "      <td>    3331</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/04/12</td>\n",
       "      <td> 2010/04/12</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Southbridge School</th>\n",
       "      <td> POLYGON ((2432972.268764344509691 5717360.3689...</td>\n",
       "      <td>    3509</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/04/12</td>\n",
       "      <td> 2010/04/12</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Roydvale School</th>\n",
       "      <td> POLYGON ((2473392.299265498295426 5745425.0002...</td>\n",
       "      <td>    3493</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/04/12</td>\n",
       "      <td> 2010/04/12</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ormiston Senior College</th>\n",
       "      <td> POLYGON ((2680143.397820746991783 6470583.8595...</td>\n",
       "      <td>     564</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/04/21</td>\n",
       "      <td> 2010/04/21</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Botany Downs School</th>\n",
       "      <td> POLYGON ((2682297.523071551229805 6475237.1926...</td>\n",
       "      <td>    1235</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finlayson Park School</th>\n",
       "      <td> POLYGON ((2676385.600107788108289 6462255.9996...</td>\n",
       "      <td>    1275</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harrisville School</th>\n",
       "      <td> POLYGON ((2682296.315404510591179 6436877.4582...</td>\n",
       "      <td>    1303</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sutton Park School</th>\n",
       "      <td> POLYGON ((2672373.673204316291958 6470481.4489...</td>\n",
       "      <td>    1520</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> 2010/05/05</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurupaki School</th>\n",
       "      <td> POLYGON ((2627575.883569485042244 6612390.5332...</td>\n",
       "      <td>    1018</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/05/06</td>\n",
       "      <td> 2010/05/06</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mt Albert Grammar School</th>\n",
       "      <td> POLYGON ((2662916.948640319053084 6478821.6355...</td>\n",
       "      <td>      69</td>\n",
       "      <td> AK</td>\n",
       "      <td> 2010/03/24</td>\n",
       "      <td> 2010/03/24</td>\n",
       "      <td>    Secondary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brightwater School</th>\n",
       "      <td> POLYGON ((2514303.539093079511076 5985865.0162...</td>\n",
       "      <td>    3183</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/07/26</td>\n",
       "      <td> 2010/07/26</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Maori Hill School</th>\n",
       "      <td> POLYGON ((2316327.270695094484836 5480556.5303...</td>\n",
       "      <td>    3768</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/06/28</td>\n",
       "      <td> 2010/06/28</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Woodend School</th>\n",
       "      <td> POLYGON ((2486750.50003167334944 5765002.89961...</td>\n",
       "      <td>    3600</td>\n",
       "      <td> SI</td>\n",
       "      <td>        NaN</td>\n",
       "      <td>        NaN</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Goldfields School (Cromwell)</th>\n",
       "      <td> POLYGON ((2198555.058699835557491 5573970.2297...</td>\n",
       "      <td>    3741</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/06/28</td>\n",
       "      <td> 2010/06/28</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Papakowhai School</th>\n",
       "      <td> POLYGON ((2667153.139621315058321 6007286.0829...</td>\n",
       "      <td>    2946</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2010/07/14</td>\n",
       "      <td> 2010/07/14</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heathcote Valley School</th>\n",
       "      <td> POLYGON ((2486673.445020992774516 5734897.7473...</td>\n",
       "      <td>    3371</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/08/23</td>\n",
       "      <td> 2010/08/23</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hastings Intermediate</th>\n",
       "      <td> POLYGON ((2840876.605659266468138 6169538.7043...</td>\n",
       "      <td>    2570</td>\n",
       "      <td> HM</td>\n",
       "      <td> 2010/08/23</td>\n",
       "      <td> 2010/08/23</td>\n",
       "      <td> Intermediate</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ngatea School</th>\n",
       "      <td> POLYGON ((2728265.140026539098471 6439337.1802...</td>\n",
       "      <td>    1850</td>\n",
       "      <td> HM</td>\n",
       "      <td> 2010/08/25</td>\n",
       "      <td> 2010/08/25</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Makarewa School</th>\n",
       "      <td> POLYGON ((2147037.691040768753737 5427733.9947...</td>\n",
       "      <td>    3982</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/08/23</td>\n",
       "      <td> 2010/08/23</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stonefields School</th>\n",
       "      <td> POLYGON ((2673623.120287223253399 6477684.7821...</td>\n",
       "      <td>     565</td>\n",
       "      <td> AK</td>\n",
       "      <td>        NaN</td>\n",
       "      <td>        NaN</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wakefield School</th>\n",
       "      <td> POLYGON ((2502458.437301402911544 5980917.3828...</td>\n",
       "      <td>    3234</td>\n",
       "      <td> SI</td>\n",
       "      <td> 2010/08/30</td>\n",
       "      <td> 2010/08/30</td>\n",
       "      <td> Contributing</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Maidstone Intermediate</th>\n",
       "      <td> POLYGON ((2685459.300130560062826 6004301.5002...</td>\n",
       "      <td>    2893</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> 2003/01/31</td>\n",
       "      <td> Intermediate</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thorndon School</th>\n",
       "      <td> MULTIPOLYGON (((2658828.394955039955676 599186...</td>\n",
       "      <td>    3040</td>\n",
       "      <td> WN</td>\n",
       "      <td> 2003/02/27</td>\n",
       "      <td> 2003/02/27</td>\n",
       "      <td> Full Primary</td>\n",
       "      <td>  --</td>\n",
       "      <td> Yes</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>713 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                  ﻿WKT  \\\n",
       "SchoolName                                                                               \n",
       "Palmerston North Intermediate        POLYGON ((2730615.392561290878803 6090740.2981...   \n",
       "Freyberg High School                 POLYGON ((2745043.800439903512597 6112272.2000...   \n",
       "Mangorei School                      POLYGON ((2600820.374574344605207 6221545.9363...   \n",
       "Henderson Intermediate               MULTIPOLYGON (((2655706.400050358846784 647910...   \n",
       "Waitakere School                     POLYGON ((2638211.172554983757436 6481043.2694...   \n",
       "Hutt Intermediate                    POLYGON ((2670071.899875052738935 5993800.9007...   \n",
       "Tawa Intermediate                    POLYGON ((2665593.000167114194483 6001129.0004...   \n",
       "Tawa College                         POLYGON ((2665593.000167114194483 6001129.0004...   \n",
       "Long Bay College (Home Zone 1)       POLYGON ((2661280.464295980520546 6501402.4220...   \n",
       "Long Bay College (Home Zone 2)       POLYGON ((2664664.430524981580675 6501501.9185...   \n",
       "Clive School                         POLYGON ((2842612.622409 6171176.2446414381265...   \n",
       "Paremata School                      POLYGON ((2666257.528198571875691 6009107.7309...   \n",
       "Fairfield School (Dunedin)           POLYGON ((2307516.583301387261599 5477283.7539...   \n",
       "Riverdale School (P North)           POLYGON ((2730601.000682259444147 6088867.9998...   \n",
       "Fernside School                      POLYGON ((2473495.105003115255386 5768297.1780...   \n",
       "Christchurch Girls' High School      POLYGON ((2480632.30014349007979 5742883.50030...   \n",
       "Plimmerton School                    POLYGON ((2670008.799272179603577 6010857.4998...   \n",
       "Palmerston North Girls' High School  POLYGON ((2731754.900352925993502 6089216.6996...   \n",
       "Frankley School                      POLYGON ((2600242.385744854342192 6235684.5896...   \n",
       "Allenton School                      POLYGON ((2407791.063124474603683 5701653.6885...   \n",
       "Rosebank School (Balclutha)          POLYGON ((2256514.299498674925417 5436773.5002...   \n",
       "Riverlands School                    POLYGON ((2590106.899930706247687 5965576.6998...   \n",
       "Wellington Girls' College            POLYGON ((2658880.700493346434087 5989905.1005...   \n",
       "Westburn School                      POLYGON ((2474449.999938263557851 5745198.4999...   \n",
       "Avonside Girls' High School          POLYGON ((2481365.959411066025496 5743985.8583...   \n",
       "Beckenham School                     POLYGON ((2480684.000307884067297 5738421.0002...   \n",
       "Burnside High School                 POLYGON ((2473925.199291485361755 5746697.4005...   \n",
       "Hukanui School                       POLYGON ((2711431.800331362057477 6380387.7998...   \n",
       "Massey Primary School                POLYGON ((2653362.500090703833848 6485832.9002...   \n",
       "Kerikeri High School                 POLYGON ((2596289.317205696832389 6678005.9493...   \n",
       "...                                                                                ...   \n",
       "Matarau School (years 7-8)           POLYGON ((2619284.816485492978245 6612291.4422...   \n",
       "Kaukapakapa School                   POLYGON ((2639489.203145041130483 6513715.0492...   \n",
       "Hillcrest High School                MULTIPOLYGON (((2731829.250435898546129 637692...   \n",
       "Mosston School                       POLYGON ((2681487.999516027513891 6141264.9992...   \n",
       "Porirua College                      POLYGON ((2664900.500163984019309 6006179.9997...   \n",
       "Devonport School                     POLYGON ((2671321.956953046377748 6484140.2010...   \n",
       "Onewhero Area School (Years 7-13)    POLYGON ((2674050.258564048446715 6433841.7871...   \n",
       "Dunsandel School                     POLYGON ((2431517.19942346168682 5733284.59920...   \n",
       "Southbridge School                   POLYGON ((2432972.268764344509691 5717360.3689...   \n",
       "Roydvale School                      POLYGON ((2473392.299265498295426 5745425.0002...   \n",
       "Ormiston Senior College              POLYGON ((2680143.397820746991783 6470583.8595...   \n",
       "Botany Downs School                  POLYGON ((2682297.523071551229805 6475237.1926...   \n",
       "Finlayson Park School                POLYGON ((2676385.600107788108289 6462255.9996...   \n",
       "Harrisville School                   POLYGON ((2682296.315404510591179 6436877.4582...   \n",
       "Sutton Park School                   POLYGON ((2672373.673204316291958 6470481.4489...   \n",
       "Hurupaki School                      POLYGON ((2627575.883569485042244 6612390.5332...   \n",
       "Mt Albert Grammar School             POLYGON ((2662916.948640319053084 6478821.6355...   \n",
       "Brightwater School                   POLYGON ((2514303.539093079511076 5985865.0162...   \n",
       "Maori Hill School                    POLYGON ((2316327.270695094484836 5480556.5303...   \n",
       "Woodend School                       POLYGON ((2486750.50003167334944 5765002.89961...   \n",
       "Goldfields School (Cromwell)         POLYGON ((2198555.058699835557491 5573970.2297...   \n",
       "Papakowhai School                    POLYGON ((2667153.139621315058321 6007286.0829...   \n",
       "Heathcote Valley School              POLYGON ((2486673.445020992774516 5734897.7473...   \n",
       "Hastings Intermediate                POLYGON ((2840876.605659266468138 6169538.7043...   \n",
       "Ngatea School                        POLYGON ((2728265.140026539098471 6439337.1802...   \n",
       "Makarewa School                      POLYGON ((2147037.691040768753737 5427733.9947...   \n",
       "Stonefields School                   POLYGON ((2673623.120287223253399 6477684.7821...   \n",
       "Wakefield School                     POLYGON ((2502458.437301402911544 5980917.3828...   \n",
       "Maidstone Intermediate               POLYGON ((2685459.300130560062826 6004301.5002...   \n",
       "Thorndon School                      MULTIPOLYGON (((2658828.394955039955676 599186...   \n",
       "\n",
       "                                     SchoolID Office ApprovalDate  \\\n",
       "SchoolName                                                          \n",
       "Palmerston North Intermediate            2419     WN   2003/01/31   \n",
       "Freyberg High School                      200     WN   2003/01/07   \n",
       "Mangorei School                          2189     WN   2003/01/07   \n",
       "Henderson Intermediate                   1307     AK   2002/12/18   \n",
       "Waitakere School                         1557     AK   2008/02/21   \n",
       "Hutt Intermediate                        2863     WN   2003/01/31   \n",
       "Tawa Intermediate                        3034     WN   2003/01/07   \n",
       "Tawa College                              257     WN   2003/01/07   \n",
       "Long Bay College (Home Zone 1)          27002     AK   2005/11/02   \n",
       "Long Bay College (Home Zone 2)          27001     AK   2005/11/02   \n",
       "Clive School                             2549     HM   2004/06/14   \n",
       "Paremata School                          2950     WN   2003/02/25   \n",
       "Fairfield School (Dunedin)               3736     SI   2003/01/22   \n",
       "Riverdale School (P North)               2437     WN   2003/02/25   \n",
       "Fernside School                          3340     SI   2002/12/06   \n",
       "Christchurch Girls' High School           328     SI   2005/08/10   \n",
       "Plimmerton School                        2960     WN   2003/01/07   \n",
       "Palmerston North Girls' High School       203     WN   2003/01/07   \n",
       "Frankley School                          2168     WN   2003/01/07   \n",
       "Allenton School                          3274     SI   2002/12/06   \n",
       "Rosebank School (Balclutha)              3812     SI   2003/07/08   \n",
       "Riverlands School                        2981     SI   2003/07/08   \n",
       "Wellington Girls' College                 272     WN   2003/01/31   \n",
       "Westburn School                          3589     SI   2003/01/22   \n",
       "Avonside Girls' High School               324     SI   2005/08/10   \n",
       "Beckenham School                         3291     SI   2003/01/31   \n",
       "Burnside High School                      319     SI   2002/12/06   \n",
       "Hukanui School                           1749     HM   2003/09/22   \n",
       "Massey Primary School                    1363     AK   2002/09/30   \n",
       "Kerikeri High School                        5     AK   2002/12/06   \n",
       "...                                       ...    ...          ...   \n",
       "Matarau School (years 7-8)            1043001     AK   2009/12/01   \n",
       "Kaukapakapa School                       1326     AK   2009/12/17   \n",
       "Hillcrest High School                     138     AK   2009/12/22   \n",
       "Mosston School                           2403     WN   2010/02/04   \n",
       "Porirua College                           255     WN   2010/02/04   \n",
       "Devonport School                         1260     AK   2010/03/15   \n",
       "Onewhero Area School (Years 7-13)      108001     AK   2010/03/31   \n",
       "Dunsandel School                         3331     SI   2010/04/12   \n",
       "Southbridge School                       3509     SI   2010/04/12   \n",
       "Roydvale School                          3493     SI   2010/04/12   \n",
       "Ormiston Senior College                   564     AK   2010/04/21   \n",
       "Botany Downs School                      1235     AK   2010/05/05   \n",
       "Finlayson Park School                    1275     AK   2010/05/05   \n",
       "Harrisville School                       1303     AK   2010/05/05   \n",
       "Sutton Park School                       1520     AK   2010/05/05   \n",
       "Hurupaki School                          1018     AK   2010/05/06   \n",
       "Mt Albert Grammar School                   69     AK   2010/03/24   \n",
       "Brightwater School                       3183     SI   2010/07/26   \n",
       "Maori Hill School                        3768     SI   2010/06/28   \n",
       "Woodend School                           3600     SI          NaN   \n",
       "Goldfields School (Cromwell)             3741     SI   2010/06/28   \n",
       "Papakowhai School                        2946     WN   2010/07/14   \n",
       "Heathcote Valley School                  3371     SI   2010/08/23   \n",
       "Hastings Intermediate                    2570     HM   2010/08/23   \n",
       "Ngatea School                            1850     HM   2010/08/25   \n",
       "Makarewa School                          3982     SI   2010/08/23   \n",
       "Stonefields School                        565     AK          NaN   \n",
       "Wakefield School                         3234     SI   2010/08/30   \n",
       "Maidstone Intermediate                   2893     WN   2003/01/31   \n",
       "Thorndon School                          3040     WN   2003/02/27   \n",
       "\n",
       "                                    EffectiveDate      INSTTYPE Underreview  \\\n",
       "SchoolName                                                                    \n",
       "Palmerston North Intermediate          2003/01/31  Intermediate          --   \n",
       "Freyberg High School                   2003/01/07     Secondary          --   \n",
       "Mangorei School                        2003/01/07  Full Primary          --   \n",
       "Henderson Intermediate                 2002/12/18  Intermediate          --   \n",
       "Waitakere School                       2008/02/21  Full Primary         NaN   \n",
       "Hutt Intermediate                      2003/01/31  Intermediate          --   \n",
       "Tawa Intermediate                      2003/01/07  Intermediate          --   \n",
       "Tawa College                           2003/01/07     Secondary          --   \n",
       "Long Bay College (Home Zone 1)         2005/11/02     Secondary         NaN   \n",
       "Long Bay College (Home Zone 2)         2008/01/01     Secondary         NaN   \n",
       "Clive School                           2004/06/14  Contributing         NaN   \n",
       "Paremata School                        2003/02/25  Full Primary          --   \n",
       "Fairfield School (Dunedin)             2003/01/22  Full Primary          --   \n",
       "Riverdale School (P North)             2003/02/25  Contributing          --   \n",
       "Fernside School                        2002/12/06  Full Primary          --   \n",
       "Christchurch Girls' High School        2005/08/10     Secondary          --   \n",
       "Plimmerton School                      2003/01/07  Full Primary          --   \n",
       "Palmerston North Girls' High School    2003/01/07     Secondary          --   \n",
       "Frankley School                        2003/01/07  Contributing          --   \n",
       "Allenton School                        2002/12/06  Contributing          --   \n",
       "Rosebank School (Balclutha)            2003/07/07  Full Primary          --   \n",
       "Riverlands School                      2003/07/08  Full Primary          --   \n",
       "Wellington Girls' College              2003/01/31     Secondary          --   \n",
       "Westburn School                        2003/01/22  Full Primary          --   \n",
       "Avonside Girls' High School            2005/08/10     Secondary          --   \n",
       "Beckenham School                       2003/01/31  Full Primary          --   \n",
       "Burnside High School                   2002/12/06     Secondary          --   \n",
       "Hukanui School                         2003/09/22  Contributing          --   \n",
       "Massey Primary School                  2002/09/30  Full Primary          --   \n",
       "Kerikeri High School                   2002/12/06     Secondary          --   \n",
       "...                                           ...           ...         ...   \n",
       "Matarau School (years 7-8)             2009/12/01  Full Primary         NaN   \n",
       "Kaukapakapa School                     2009/12/17  Full Primary         NaN   \n",
       "Hillcrest High School                  2009/12/22     Secondary         NaN   \n",
       "Mosston School                         2005/01/01  Contributing         NaN   \n",
       "Porirua College                        2010/02/08     Secondary         NaN   \n",
       "Devonport School                       2010/03/15  Contributing         NaN   \n",
       "Onewhero Area School (Years 7-13)      2010/03/31     Composite         NaN   \n",
       "Dunsandel School                       2010/04/12  Contributing         NaN   \n",
       "Southbridge School                     2010/04/12  Contributing         NaN   \n",
       "Roydvale School                        2010/04/12  Contributing         NaN   \n",
       "Ormiston Senior College                2010/04/21     Secondary         NaN   \n",
       "Botany Downs School                    2010/05/05  Contributing         NaN   \n",
       "Finlayson Park School                  2010/05/05  Contributing         NaN   \n",
       "Harrisville School                     2010/05/05  Contributing         NaN   \n",
       "Sutton Park School                     2010/05/05  Full Primary         NaN   \n",
       "Hurupaki School                        2010/05/06  Contributing         NaN   \n",
       "Mt Albert Grammar School               2010/03/24     Secondary         NaN   \n",
       "Brightwater School                     2010/07/26  Contributing         NaN   \n",
       "Maori Hill School                      2010/06/28  Contributing         NaN   \n",
       "Woodend School                                NaN  Full Primary         NaN   \n",
       "Goldfields School (Cromwell)           2010/06/28  Contributing         NaN   \n",
       "Papakowhai School                      2010/07/14  Full Primary         NaN   \n",
       "Heathcote Valley School                2010/08/23  Full Primary         NaN   \n",
       "Hastings Intermediate                  2010/08/23  Intermediate         NaN   \n",
       "Ngatea School                          2010/08/25  Full Primary         NaN   \n",
       "Makarewa School                        2010/08/23  Contributing         NaN   \n",
       "Stonefields School                            NaN  Full Primary         NaN   \n",
       "Wakefield School                       2010/08/30  Contributing         NaN   \n",
       "Maidstone Intermediate                 2003/01/31  Intermediate          --   \n",
       "Thorndon School                        2003/02/27  Full Primary          --   \n",
       "\n",
       "                                     chk  \n",
       "SchoolName                                \n",
       "Palmerston North Intermediate        Yes  \n",
       "Freyberg High School                 Yes  \n",
       "Mangorei School                      Yes  \n",
       "Henderson Intermediate               Yes  \n",
       "Waitakere School                     Yes  \n",
       "Hutt Intermediate                    Yes  \n",
       "Tawa Intermediate                    Yes  \n",
       "Tawa College                         Yes  \n",
       "Long Bay College (Home Zone 1)       NaN  \n",
       "Long Bay College (Home Zone 2)       NaN  \n",
       "Clive School                         Yes  \n",
       "Paremata School                      Yes  \n",
       "Fairfield School (Dunedin)           Yes  \n",
       "Riverdale School (P North)           Yes  \n",
       "Fernside School                      Yes  \n",
       "Christchurch Girls' High School      Yes  \n",
       "Plimmerton School                    Yes  \n",
       "Palmerston North Girls' High School  Yes  \n",
       "Frankley School                      Yes  \n",
       "Allenton School                      Yes  \n",
       "Rosebank School (Balclutha)          Yes  \n",
       "Riverlands School                    Yes  \n",
       "Wellington Girls' College            Yes  \n",
       "Westburn School                      Yes  \n",
       "Avonside Girls' High School          Yes  \n",
       "Beckenham School                     Yes  \n",
       "Burnside High School                 Yes  \n",
       "Hukanui School                       Yes  \n",
       "Massey Primary School                Yes  \n",
       "Kerikeri High School                 Yes  \n",
       "...                                  ...  \n",
       "Matarau School (years 7-8)           NaN  \n",
       "Kaukapakapa School                   NaN  \n",
       "Hillcrest High School                NaN  \n",
       "Mosston School                       NaN  \n",
       "Porirua College                      NaN  \n",
       "Devonport School                     NaN  \n",
       "Onewhero Area School (Years 7-13)    NaN  \n",
       "Dunsandel School                     NaN  \n",
       "Southbridge School                   NaN  \n",
       "Roydvale School                      NaN  \n",
       "Ormiston Senior College              NaN  \n",
       "Botany Downs School                  NaN  \n",
       "Finlayson Park School                NaN  \n",
       "Harrisville School                   NaN  \n",
       "Sutton Park School                   NaN  \n",
       "Hurupaki School                      NaN  \n",
       "Mt Albert Grammar School             NaN  \n",
       "Brightwater School                   NaN  \n",
       "Maori Hill School                    NaN  \n",
       "Woodend School                       NaN  \n",
       "Goldfields School (Cromwell)         NaN  \n",
       "Papakowhai School                    NaN  \n",
       "Heathcote Valley School              NaN  \n",
       "Hastings Intermediate                NaN  \n",
       "Ngatea School                        NaN  \n",
       "Makarewa School                      NaN  \n",
       "Stonefields School                   NaN  \n",
       "Wakefield School                     NaN  \n",
       "Maidstone Intermediate               Yes  \n",
       "Thorndon School                      Yes  \n",
       "\n",
       "[713 rows x 8 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schnam"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Palmerston North Intermediate', 'Freyberg High School', 'Mangorei School', 'Henderson Intermediate', 'Waitakere School', 'Hutt Intermediate', 'Tawa Intermediate', 'Tawa College', 'Long Bay College (Home Zone 1)', 'Long Bay College (Home Zone 2)', 'Clive School', 'Paremata School', 'Fairfield School (Dunedin)', 'Riverdale School (P North)', 'Fernside School', 'Christchurch Girls' High School', 'Plimmerton School', 'Palmerston North Girls' High School', 'Frankley School', 'Allenton School', 'Rosebank School (Balclutha)', 'Riverlands School', 'Wellington Girls' College', 'Westburn School', 'Avonside Girls' High School', 'Beckenham School', 'Burnside High School', 'Hukanui School', 'Massey Primary School', 'Kerikeri High School', 'Mangere Bridge School', 'Waterlea Public School', 'Whakatane High School', 'Whenuapai School', 'Red Beach School', 'Tauranga Intermediate', 'Willowpark School', 'Pakuranga Intermediate', 'St Joseph's School (Queenstown)', 'Ngaere School', 'Fernridge School', 'Raroa Normal Intermediate', 'Loburn School', 'Columba College', 'St Hildas Collegiate', 'Arthur Miller School', 'Mapua School', 'Woodhill School', 'Henley School (Nelson)', 'Ellesmere College', 'Kirwee Model School', 'Kio Kio School', 'Lindisfarne College', 'Parkvale School', 'St Joseph's Maori Girls' College', 'Maungatapu School', 'Havelock North Primary School', 'Berkley Normal Middle School', 'Pukehou School', 'Pukehamoamoa School', 'Makaraka School', 'Takanini School', 'Rhode Street School', 'Aidanfield Christian School', 'Middleton Grange School (Years 11 - 13)', 'Emmanuel Christian School', 'St Thomas of Canterbury College', 'Hillview Christian School', 'Howick College (NEW ZONE)', 'Stanhope Road School', 'Mangapapa School', 'Remarkables Primary School', 'Rolleston School', 'Clearview Primary', 'St Albans School', 'Botany Downs Secondary College (NEW ZONE)', 'Richmond Road School', 'Waikowhai Intermediate', 'Brooklyn School (Wellington)', 'Macleans College', 'Karori Normal School', 'Aotea College', 'Opawa School', 'Otago Girls' High School', 'Motueka South School', 'Greenpark School (Tauranga)', 'Marshland School', 'Elmwood Normal School', 'Mt Roskill Grammar', 'Buckland School', 'Coatesville School', 'Chelsea School', 'Epsom Normal School', 'John McGlashan College', 'Shirley School', 'Harewood School', 'Mairehau School', 'Mangawhai Beach School', 'Ilam School', 'Fairfield School (Levin)', ...], dtype='object')"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schnam.SchoolID.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.4.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}