napinfo.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%%bash\n",
    "# download the napinfo dataset\n",
    "ogr2ogr -f GeoJSON napinfo.json -a_srs EPSG:28992 -t_srs EPSG:4326 'WFS:http://geodata.nationaalgeoregister.nl/napinfo/wfs'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/baart_f/.virtualenvs/main/lib/python3.5/site-packages/matplotlib/__init__.py:913: UserWarning: axes.color_cycle is deprecated and replaced with axes.prop_cycle; please use the latter.\n",
      "  warnings.warn(self.msg_depr % (key, alt_key))\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2009, 3, 17, 0, 0)"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import fiona\n",
    "import logging\n",
    "import dateutil.parser\n",
    "import numpy as np\n",
    "import pandas\n",
    "dateutil.parser.parse('17-mar-2009')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "WARNING:Fiona:PROJ data files not located, PROJ_LIB not set\n"
     ]
    }
   ],
   "source": [
    "ds = fiona.open('napinfo.json')\n",
    "features_by_id = {int(feature['id']): feature for feature in ds}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "features = []\n",
    "for feature in ds:\n",
    "    try:\n",
    "        meetdatum = feature['properties']['meetdatum']\n",
    "        if meetdatum is not None:\n",
    "            date = dateutil.parser.parse(feature['properties']['meetdatum'])\n",
    "            feature['properties']['time'] = date.isoformat()\n",
    "    except:\n",
    "        logging.exception(feature['properties']['meetdatum'])\n",
    "        break\n",
    "    properties = ['x_rd', 'y_rd', 'nap_hoogte', 'x_muur_cm', 'y_muur_cm', 'orde']\n",
    "    for key in properties:\n",
    "        try:\n",
    "            feature['properties'][key] = int(feature['properties'][key])\n",
    "        except (ValueError, TypeError):\n",
    "            try:\n",
    "                feature['properties'][key] = float(feature['properties'][key])\n",
    "            except (ValueError, TypeError):\n",
    "                feature['properties'][key] = feature['properties'][key]\n",
    "    feature['id'] = int(feature['id'])\n",
    "    features.append(feature)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import geojson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "geojson.dump(\n",
    "    geojson.FeatureCollection(features), \n",
    "    open('nap.json', 'w')\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gml_id</th>\n",
       "      <th>peilmerk</th>\n",
       "      <th>x_rd</th>\n",
       "      <th>y_rd</th>\n",
       "      <th>nap_hoogte</th>\n",
       "      <th>pub_tekst</th>\n",
       "      <th>x_muur_cm</th>\n",
       "      <th>y_muur_cm</th>\n",
       "      <th>meetdatum</th>\n",
       "      <th>orde</th>\n",
       "      <th>time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>nappeilmerken.1</td>\n",
       "      <td>001C0001</td>\n",
       "      <td>149490</td>\n",
       "      <td>600320</td>\n",
       "      <td>3.043</td>\n",
       "      <td>KORENMOLEN FORMERUM, L.V.INGANG</td>\n",
       "      <td>42</td>\n",
       "      <td>35</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nappeilmerken.2</td>\n",
       "      <td>001C0004</td>\n",
       "      <td>148330</td>\n",
       "      <td>601990</td>\n",
       "      <td>5.111</td>\n",
       "      <td>ZOMERHUISJE 'SIL' N-EINDE HEEREWG</td>\n",
       "      <td>-279</td>\n",
       "      <td>42</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>nappeilmerken.3</td>\n",
       "      <td>001C0005</td>\n",
       "      <td>149040</td>\n",
       "      <td>602360</td>\n",
       "      <td>12.982</td>\n",
       "      <td>STRAND HTL-REST.FORMERUM AAN ZEE        -EINDE...</td>\n",
       "      <td>-607</td>\n",
       "      <td>50</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>nappeilmerken.4</td>\n",
       "      <td>001C0006</td>\n",
       "      <td>149050</td>\n",
       "      <td>600020</td>\n",
       "      <td>3.416</td>\n",
       "      <td>BDR TE LANDEROM (GEM. NO.9)</td>\n",
       "      <td>-44</td>\n",
       "      <td>30</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nappeilmerken.5</td>\n",
       "      <td>001C0009</td>\n",
       "      <td>148160</td>\n",
       "      <td>600570</td>\n",
       "      <td>2.924</td>\n",
       "      <td>TRAFO HEEREWEGG/DUINWEG NABIJ HS        DUINWE...</td>\n",
       "      <td>26</td>\n",
       "      <td>8</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>nappeilmerken.6</td>\n",
       "      <td>001D0001</td>\n",
       "      <td>150560</td>\n",
       "      <td>600580</td>\n",
       "      <td>1.424</td>\n",
       "      <td>ZUIVELFB FORMERUM</td>\n",
       "      <td>60</td>\n",
       "      <td>25</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>nappeilmerken.7</td>\n",
       "      <td>001D0002</td>\n",
       "      <td>152000</td>\n",
       "      <td>601180</td>\n",
       "      <td>2.635</td>\n",
       "      <td>GB 'ONS HUIS' DORPSSTR 29</td>\n",
       "      <td>-137</td>\n",
       "      <td>45</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>nappeilmerken.8</td>\n",
       "      <td>001D0003</td>\n",
       "      <td>152630</td>\n",
       "      <td>601430</td>\n",
       "      <td>3.040</td>\n",
       "      <td>BDR DORPSSTR 99</td>\n",
       "      <td>576</td>\n",
       "      <td>46</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>nappeilmerken.9</td>\n",
       "      <td>001D0012</td>\n",
       "      <td>151220</td>\n",
       "      <td>600940</td>\n",
       "      <td>1.609</td>\n",
       "      <td>BDR A/D Z-Z V/D WEG TE LIES NR. 48</td>\n",
       "      <td>53</td>\n",
       "      <td>15</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>nappeilmerken.10</td>\n",
       "      <td>001D0014</td>\n",
       "      <td>153500</td>\n",
       "      <td>601840</td>\n",
       "      <td>3.733</td>\n",
       "      <td>HS NW-Z V/D WEG HOORN-OOSTEREND GEM 5</td>\n",
       "      <td>53</td>\n",
       "      <td>35</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>nappeilmerken.11</td>\n",
       "      <td>001D0016</td>\n",
       "      <td>155070</td>\n",
       "      <td>603650</td>\n",
       "      <td>2.929</td>\n",
       "      <td>SCHROEFANKER (ZIE AANM.SCHETS)          X=1550...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>nappeilmerken.12</td>\n",
       "      <td>001D0021</td>\n",
       "      <td>155900</td>\n",
       "      <td>603780</td>\n",
       "      <td>3.407</td>\n",
       "      <td>SCHROEFANKER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>nappeilmerken.13</td>\n",
       "      <td>001D0022</td>\n",
       "      <td>154580</td>\n",
       "      <td>602020</td>\n",
       "      <td>3.617</td>\n",
       "      <td>TRAFO HOOFDWG 59</td>\n",
       "      <td>92</td>\n",
       "      <td>14</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>nappeilmerken.14</td>\n",
       "      <td>001D0023</td>\n",
       "      <td>156520</td>\n",
       "      <td>604720</td>\n",
       "      <td>3.040</td>\n",
       "      <td>HOUTENPL 19.400/L240</td>\n",
       "      <td>10</td>\n",
       "      <td>-50</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>nappeilmerken.15</td>\n",
       "      <td>001D0024</td>\n",
       "      <td>157100</td>\n",
       "      <td>604940</td>\n",
       "      <td>2.716</td>\n",
       "      <td>HOUTENPL 20.000/L180</td>\n",
       "      <td>10</td>\n",
       "      <td>-50</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>nappeilmerken.16</td>\n",
       "      <td>001D0025</td>\n",
       "      <td>158060</td>\n",
       "      <td>605220</td>\n",
       "      <td>1.979</td>\n",
       "      <td>HOUTEN HOOFDPL 21.000</td>\n",
       "      <td>10</td>\n",
       "      <td>-50</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>nappeilmerken.17</td>\n",
       "      <td>001D0026</td>\n",
       "      <td>159040</td>\n",
       "      <td>605430</td>\n",
       "      <td>2.041</td>\n",
       "      <td>HOUTEN HOOFDPL 22.000</td>\n",
       "      <td>10</td>\n",
       "      <td>-50</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>nappeilmerken.18</td>\n",
       "      <td>001D0032</td>\n",
       "      <td>155900</td>\n",
       "      <td>603780</td>\n",
       "      <td>3.701</td>\n",
       "      <td>RD STEEN RD= 019111-17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>nappeilmerken.19</td>\n",
       "      <td>001D0033</td>\n",
       "      <td>155900</td>\n",
       "      <td>603780</td>\n",
       "      <td>3.430</td>\n",
       "      <td>N-KANT V/H WILDROOSTER IN FIETSPAD</td>\n",
       "      <td>8</td>\n",
       "      <td>-5</td>\n",
       "      <td>17-mar-2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009-03-17T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>nappeilmerken.20</td>\n",
       "      <td>001G0008</td>\n",
       "      <td>160900</td>\n",
       "      <td>606260</td>\n",
       "      <td>1.846</td>\n",
       "      <td>HOUTENPL 24.000/ZIII400</td>\n",
       "      <td>10</td>\n",
       "      <td>-50</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>nappeilmerken.21</td>\n",
       "      <td>001G0009</td>\n",
       "      <td>160000</td>\n",
       "      <td>605850</td>\n",
       "      <td>1.854</td>\n",
       "      <td>HOUTENPL 23.000/Z200</td>\n",
       "      <td>10</td>\n",
       "      <td>-50</td>\n",
       "      <td>30-jun-2001</td>\n",
       "      <td>2</td>\n",
       "      <td>2001-06-30T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>nappeilmerken.22</td>\n",
       "      <td>001H0003</td>\n",
       "      <td>171160</td>\n",
       "      <td>605300</td>\n",
       "      <td>3.035</td>\n",
       "      <td>BDR ZO V.TJETTEPAD 2</td>\n",
       "      <td>36</td>\n",
       "      <td>39</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>nappeilmerken.23</td>\n",
       "      <td>001H0005</td>\n",
       "      <td>171850</td>\n",
       "      <td>605520</td>\n",
       "      <td>4.190</td>\n",
       "      <td>TOREN HK HOLLUM</td>\n",
       "      <td>-110</td>\n",
       "      <td>68</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>nappeilmerken.24</td>\n",
       "      <td>001H0007</td>\n",
       "      <td>170640</td>\n",
       "      <td>605920</td>\n",
       "      <td>2.906</td>\n",
       "      <td>HS NAAST HS BADWG 44</td>\n",
       "      <td>28</td>\n",
       "      <td>30</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>nappeilmerken.25</td>\n",
       "      <td>001H0009</td>\n",
       "      <td>171220</td>\n",
       "      <td>605950</td>\n",
       "      <td>2.733</td>\n",
       "      <td>HS BADWG 17</td>\n",
       "      <td>76</td>\n",
       "      <td>37</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>nappeilmerken.26</td>\n",
       "      <td>001H0011</td>\n",
       "      <td>173710</td>\n",
       "      <td>606820</td>\n",
       "      <td>3.580</td>\n",
       "      <td>BDR VERBINDINGSWG 14</td>\n",
       "      <td>140</td>\n",
       "      <td>33</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>nappeilmerken.27</td>\n",
       "      <td>001H0013</td>\n",
       "      <td>174900</td>\n",
       "      <td>606460</td>\n",
       "      <td>4.586</td>\n",
       "      <td>TOREN BALLUM</td>\n",
       "      <td>89</td>\n",
       "      <td>130</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>nappeilmerken.28</td>\n",
       "      <td>001H0014</td>\n",
       "      <td>175080</td>\n",
       "      <td>606680</td>\n",
       "      <td>3.621</td>\n",
       "      <td>BDR NESSERWG 2</td>\n",
       "      <td>-52</td>\n",
       "      <td>36</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>nappeilmerken.29</td>\n",
       "      <td>001H0016</td>\n",
       "      <td>177320</td>\n",
       "      <td>606660</td>\n",
       "      <td>2.734</td>\n",
       "      <td>SCH TEN N.V. VERBINDINGSWG</td>\n",
       "      <td>-63</td>\n",
       "      <td>48</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>nappeilmerken.30</td>\n",
       "      <td>001H0022</td>\n",
       "      <td>170794</td>\n",
       "      <td>605520</td>\n",
       "      <td>5.902</td>\n",
       "      <td>SCHROEFANKER W-Z DUIN IN PUT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25-feb-2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2014-02-25T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36974</th>\n",
       "      <td>nappeilmerken.36975</td>\n",
       "      <td>062E0045</td>\n",
       "      <td>203110</td>\n",
       "      <td>317890</td>\n",
       "      <td>163.332</td>\n",
       "      <td>3147 DOM HS PANNESHEIDERSTR 47</td>\n",
       "      <td>-20</td>\n",
       "      <td>22</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36975</th>\n",
       "      <td>nappeilmerken.36976</td>\n",
       "      <td>062E0047</td>\n",
       "      <td>202640</td>\n",
       "      <td>318630</td>\n",
       "      <td>158.273</td>\n",
       "      <td>2685 DOM HS CANISIUSSTR 24, KERKRADE</td>\n",
       "      <td>22</td>\n",
       "      <td>25</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36976</th>\n",
       "      <td>nappeilmerken.36977</td>\n",
       "      <td>062E0048</td>\n",
       "      <td>200220</td>\n",
       "      <td>317920</td>\n",
       "      <td>155.577</td>\n",
       "      <td>1019 WS HS HAMSTR 193</td>\n",
       "      <td>-22</td>\n",
       "      <td>25</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36977</th>\n",
       "      <td>nappeilmerken.36978</td>\n",
       "      <td>062E0064</td>\n",
       "      <td>202430</td>\n",
       "      <td>319700</td>\n",
       "      <td>153.809</td>\n",
       "      <td>ON 1152 KLOOSTER DR.KEYENSTR 8</td>\n",
       "      <td>-80</td>\n",
       "      <td>53</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36978</th>\n",
       "      <td>nappeilmerken.36979</td>\n",
       "      <td>062E0066</td>\n",
       "      <td>200080</td>\n",
       "      <td>324410</td>\n",
       "      <td>157.619</td>\n",
       "      <td>CF HOOGSTR 157 BT DSM</td>\n",
       "      <td>-37</td>\n",
       "      <td>67</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36979</th>\n",
       "      <td>nappeilmerken.36980</td>\n",
       "      <td>062E0067</td>\n",
       "      <td>200950</td>\n",
       "      <td>319650</td>\n",
       "      <td>155.946</td>\n",
       "      <td>3637-DSM RKK KAPELWG 1 (IN VOORGEVEL L.-PENANT)</td>\n",
       "      <td>47</td>\n",
       "      <td>24</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36980</th>\n",
       "      <td>nappeilmerken.36981</td>\n",
       "      <td>062E0071</td>\n",
       "      <td>202500</td>\n",
       "      <td>322950</td>\n",
       "      <td>99.527</td>\n",
       "      <td>RD-VASTL 620311-11 RKK EIJGELSHOVEN     Z-VLAK...</td>\n",
       "      <td>32</td>\n",
       "      <td>90</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36981</th>\n",
       "      <td>nappeilmerken.36982</td>\n",
       "      <td>062E0078</td>\n",
       "      <td>203890</td>\n",
       "      <td>320040</td>\n",
       "      <td>153.165</td>\n",
       "      <td>CENTRUM ROLDUC KERKRADE (RD-VASTLEG. 11)</td>\n",
       "      <td>267</td>\n",
       "      <td>147</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36982</th>\n",
       "      <td>nappeilmerken.36983</td>\n",
       "      <td>062E0079</td>\n",
       "      <td>202850</td>\n",
       "      <td>318260</td>\n",
       "      <td>161.373</td>\n",
       "      <td>HS BLEYERHEIDESTR 170</td>\n",
       "      <td>-28</td>\n",
       "      <td>56</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36983</th>\n",
       "      <td>nappeilmerken.36984</td>\n",
       "      <td>062E0080</td>\n",
       "      <td>203800</td>\n",
       "      <td>319380</td>\n",
       "      <td>161.071</td>\n",
       "      <td>HS NIEUWSTR 178</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36984</th>\n",
       "      <td>nappeilmerken.36985</td>\n",
       "      <td>062E0081</td>\n",
       "      <td>204210</td>\n",
       "      <td>320420</td>\n",
       "      <td>108.218</td>\n",
       "      <td>HS KLOSTERLINDESTR 1</td>\n",
       "      <td>35</td>\n",
       "      <td>53</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36985</th>\n",
       "      <td>nappeilmerken.36986</td>\n",
       "      <td>062E0082</td>\n",
       "      <td>202000</td>\n",
       "      <td>319980</td>\n",
       "      <td>119.390</td>\n",
       "      <td>853-DOM HS HAMMOLENWG 12</td>\n",
       "      <td>-70</td>\n",
       "      <td>31</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36986</th>\n",
       "      <td>nappeilmerken.36987</td>\n",
       "      <td>062E0094</td>\n",
       "      <td>203120</td>\n",
       "      <td>322220</td>\n",
       "      <td>103.180</td>\n",
       "      <td>HS HAANRADESTRAAT 42</td>\n",
       "      <td>232</td>\n",
       "      <td>42</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36987</th>\n",
       "      <td>nappeilmerken.36988</td>\n",
       "      <td>062E0095</td>\n",
       "      <td>203490</td>\n",
       "      <td>321720</td>\n",
       "      <td>105.948</td>\n",
       "      <td>HS MEUSERSTRAAT 146</td>\n",
       "      <td>34</td>\n",
       "      <td>85</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36988</th>\n",
       "      <td>nappeilmerken.36989</td>\n",
       "      <td>062E0096</td>\n",
       "      <td>202190</td>\n",
       "      <td>324170</td>\n",
       "      <td>133.234</td>\n",
       "      <td>HS EUROPAWG ZUID 340</td>\n",
       "      <td>-42</td>\n",
       "      <td>25</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36989</th>\n",
       "      <td>nappeilmerken.36990</td>\n",
       "      <td>062E0097</td>\n",
       "      <td>202690</td>\n",
       "      <td>321240</td>\n",
       "      <td>143.783</td>\n",
       "      <td>VDC BEUKENBOSWG O/D N299 W-LHFD         RD= 62...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36990</th>\n",
       "      <td>nappeilmerken.36991</td>\n",
       "      <td>062E0098</td>\n",
       "      <td>202680</td>\n",
       "      <td>321240</td>\n",
       "      <td>143.322</td>\n",
       "      <td>N VLMR VDC BEUKENBOSWG O/D N299 W-LHFD  RD= 62...</td>\n",
       "      <td>-7</td>\n",
       "      <td>-5</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36991</th>\n",
       "      <td>nappeilmerken.36992</td>\n",
       "      <td>062E0099</td>\n",
       "      <td>202680</td>\n",
       "      <td>321200</td>\n",
       "      <td>141.773</td>\n",
       "      <td>HS BEUKENBOSWG 20 RD= 620313-15</td>\n",
       "      <td>-10</td>\n",
       "      <td>10</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36992</th>\n",
       "      <td>nappeilmerken.36993</td>\n",
       "      <td>062E0100</td>\n",
       "      <td>200700</td>\n",
       "      <td>324950</td>\n",
       "      <td>141.547</td>\n",
       "      <td>VDC OVER NIEWENHAGERHEIDESTR</td>\n",
       "      <td>22</td>\n",
       "      <td>40</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36993</th>\n",
       "      <td>nappeilmerken.36994</td>\n",
       "      <td>062E0101</td>\n",
       "      <td>203930</td>\n",
       "      <td>320050</td>\n",
       "      <td>143.069</td>\n",
       "      <td>GEBW Z/Z CENTR ROLDUC A/H FIETSPAD</td>\n",
       "      <td>-160</td>\n",
       "      <td>30</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36994</th>\n",
       "      <td>nappeilmerken.36995</td>\n",
       "      <td>062E0102</td>\n",
       "      <td>202790</td>\n",
       "      <td>320100</td>\n",
       "      <td>149.539</td>\n",
       "      <td>6KNT BT IN HS KOESTRAAT 4</td>\n",
       "      <td>-42</td>\n",
       "      <td>35</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36995</th>\n",
       "      <td>nappeilmerken.36996</td>\n",
       "      <td>062E0103</td>\n",
       "      <td>202690</td>\n",
       "      <td>319880</td>\n",
       "      <td>155.970</td>\n",
       "      <td>HS NIERSPRINKSTRAAT 16 LV 14</td>\n",
       "      <td>-22</td>\n",
       "      <td>37</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36996</th>\n",
       "      <td>nappeilmerken.36997</td>\n",
       "      <td>062E0104</td>\n",
       "      <td>200960</td>\n",
       "      <td>318560</td>\n",
       "      <td>150.921</td>\n",
       "      <td>FABR GEBW HAMSTR 76                     TRAPMR...</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36997</th>\n",
       "      <td>nappeilmerken.36998</td>\n",
       "      <td>062G0003</td>\n",
       "      <td>201400</td>\n",
       "      <td>309000</td>\n",
       "      <td>222.014</td>\n",
       "      <td>BT IN HS KANDELFDSTR 74</td>\n",
       "      <td>-120</td>\n",
       "      <td>50</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36998</th>\n",
       "      <td>nappeilmerken.36999</td>\n",
       "      <td>062G0004</td>\n",
       "      <td>201360</td>\n",
       "      <td>309010</td>\n",
       "      <td>217.811</td>\n",
       "      <td>MB IN AANBOUW VAALSERSTR 387/385</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36999</th>\n",
       "      <td>nappeilmerken.37000</td>\n",
       "      <td>062G0005</td>\n",
       "      <td>200470</td>\n",
       "      <td>309060</td>\n",
       "      <td>199.927</td>\n",
       "      <td>BT IN Z-Z VAN N-STUETZMAUER, VAALSER STR</td>\n",
       "      <td>-71</td>\n",
       "      <td>16</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37000</th>\n",
       "      <td>nappeilmerken.37001</td>\n",
       "      <td>062G0006</td>\n",
       "      <td>201080</td>\n",
       "      <td>309160</td>\n",
       "      <td>217.545</td>\n",
       "      <td>TRAFO WKCENTRUM A/D VAALSERSTR</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37001</th>\n",
       "      <td>nappeilmerken.37002</td>\n",
       "      <td>062G0007</td>\n",
       "      <td>200560</td>\n",
       "      <td>309040</td>\n",
       "      <td>200.835</td>\n",
       "      <td>DK Z-Z VAALSERSTR</td>\n",
       "      <td>23</td>\n",
       "      <td>-35</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37002</th>\n",
       "      <td>nappeilmerken.37003</td>\n",
       "      <td>062G0008</td>\n",
       "      <td>200080</td>\n",
       "      <td>309210</td>\n",
       "      <td>198.780</td>\n",
       "      <td>BT IN ZOLLAMT GEBOUWTJE NABIJ HS NR 538</td>\n",
       "      <td>37</td>\n",
       "      <td>110</td>\n",
       "      <td>13-may-2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2012-05-13T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37003</th>\n",
       "      <td>nappeilmerken.37004</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37004 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    gml_id  peilmerk    x_rd    y_rd  nap_hoogte  \\\n",
       "0          nappeilmerken.1  001C0001  149490  600320       3.043   \n",
       "1          nappeilmerken.2  001C0004  148330  601990       5.111   \n",
       "2          nappeilmerken.3  001C0005  149040  602360      12.982   \n",
       "3          nappeilmerken.4  001C0006  149050  600020       3.416   \n",
       "4          nappeilmerken.5  001C0009  148160  600570       2.924   \n",
       "5          nappeilmerken.6  001D0001  150560  600580       1.424   \n",
       "6          nappeilmerken.7  001D0002  152000  601180       2.635   \n",
       "7          nappeilmerken.8  001D0003  152630  601430       3.040   \n",
       "8          nappeilmerken.9  001D0012  151220  600940       1.609   \n",
       "9         nappeilmerken.10  001D0014  153500  601840       3.733   \n",
       "10        nappeilmerken.11  001D0016  155070  603650       2.929   \n",
       "11        nappeilmerken.12  001D0021  155900  603780       3.407   \n",
       "12        nappeilmerken.13  001D0022  154580  602020       3.617   \n",
       "13        nappeilmerken.14  001D0023  156520  604720       3.040   \n",
       "14        nappeilmerken.15  001D0024  157100  604940       2.716   \n",
       "15        nappeilmerken.16  001D0025  158060  605220       1.979   \n",
       "16        nappeilmerken.17  001D0026  159040  605430       2.041   \n",
       "17        nappeilmerken.18  001D0032  155900  603780       3.701   \n",
       "18        nappeilmerken.19  001D0033  155900  603780       3.430   \n",
       "19        nappeilmerken.20  001G0008  160900  606260       1.846   \n",
       "20        nappeilmerken.21  001G0009  160000  605850       1.854   \n",
       "21        nappeilmerken.22  001H0003  171160  605300       3.035   \n",
       "22        nappeilmerken.23  001H0005  171850  605520       4.190   \n",
       "23        nappeilmerken.24  001H0007  170640  605920       2.906   \n",
       "24        nappeilmerken.25  001H0009  171220  605950       2.733   \n",
       "25        nappeilmerken.26  001H0011  173710  606820       3.580   \n",
       "26        nappeilmerken.27  001H0013  174900  606460       4.586   \n",
       "27        nappeilmerken.28  001H0014  175080  606680       3.621   \n",
       "28        nappeilmerken.29  001H0016  177320  606660       2.734   \n",
       "29        nappeilmerken.30  001H0022  170794  605520       5.902   \n",
       "...                    ...       ...     ...     ...         ...   \n",
       "36974  nappeilmerken.36975  062E0045  203110  317890     163.332   \n",
       "36975  nappeilmerken.36976  062E0047  202640  318630     158.273   \n",
       "36976  nappeilmerken.36977  062E0048  200220  317920     155.577   \n",
       "36977  nappeilmerken.36978  062E0064  202430  319700     153.809   \n",
       "36978  nappeilmerken.36979  062E0066  200080  324410     157.619   \n",
       "36979  nappeilmerken.36980  062E0067  200950  319650     155.946   \n",
       "36980  nappeilmerken.36981  062E0071  202500  322950      99.527   \n",
       "36981  nappeilmerken.36982  062E0078  203890  320040     153.165   \n",
       "36982  nappeilmerken.36983  062E0079  202850  318260     161.373   \n",
       "36983  nappeilmerken.36984  062E0080  203800  319380     161.071   \n",
       "36984  nappeilmerken.36985  062E0081  204210  320420     108.218   \n",
       "36985  nappeilmerken.36986  062E0082  202000  319980     119.390   \n",
       "36986  nappeilmerken.36987  062E0094  203120  322220     103.180   \n",
       "36987  nappeilmerken.36988  062E0095  203490  321720     105.948   \n",
       "36988  nappeilmerken.36989  062E0096  202190  324170     133.234   \n",
       "36989  nappeilmerken.36990  062E0097  202690  321240     143.783   \n",
       "36990  nappeilmerken.36991  062E0098  202680  321240     143.322   \n",
       "36991  nappeilmerken.36992  062E0099  202680  321200     141.773   \n",
       "36992  nappeilmerken.36993  062E0100  200700  324950     141.547   \n",
       "36993  nappeilmerken.36994  062E0101  203930  320050     143.069   \n",
       "36994  nappeilmerken.36995  062E0102  202790  320100     149.539   \n",
       "36995  nappeilmerken.36996  062E0103  202690  319880     155.970   \n",
       "36996  nappeilmerken.36997  062E0104  200960  318560     150.921   \n",
       "36997  nappeilmerken.36998  062G0003  201400  309000     222.014   \n",
       "36998  nappeilmerken.36999  062G0004  201360  309010     217.811   \n",
       "36999  nappeilmerken.37000  062G0005  200470  309060     199.927   \n",
       "37000  nappeilmerken.37001  062G0006  201080  309160     217.545   \n",
       "37001  nappeilmerken.37002  062G0007  200560  309040     200.835   \n",
       "37002  nappeilmerken.37003  062G0008  200080  309210     198.780   \n",
       "37003  nappeilmerken.37004      None       0       0       0.000   \n",
       "\n",
       "                                               pub_tekst  x_muur_cm  \\\n",
       "0                        KORENMOLEN FORMERUM, L.V.INGANG         42   \n",
       "1                      ZOMERHUISJE 'SIL' N-EINDE HEEREWG       -279   \n",
       "2      STRAND HTL-REST.FORMERUM AAN ZEE        -EINDE...       -607   \n",
       "3                            BDR TE LANDEROM (GEM. NO.9)        -44   \n",
       "4      TRAFO HEEREWEGG/DUINWEG NABIJ HS        DUINWE...         26   \n",
       "5                                      ZUIVELFB FORMERUM         60   \n",
       "6                              GB 'ONS HUIS' DORPSSTR 29       -137   \n",
       "7                                        BDR DORPSSTR 99        576   \n",
       "8                     BDR A/D Z-Z V/D WEG TE LIES NR. 48         53   \n",
       "9                  HS NW-Z V/D WEG HOORN-OOSTEREND GEM 5         53   \n",
       "10     SCHROEFANKER (ZIE AANM.SCHETS)          X=1550...          0   \n",
       "11                                          SCHROEFANKER          0   \n",
       "12                                      TRAFO HOOFDWG 59         92   \n",
       "13                                  HOUTENPL 19.400/L240         10   \n",
       "14                                  HOUTENPL 20.000/L180         10   \n",
       "15                                 HOUTEN HOOFDPL 21.000         10   \n",
       "16                                 HOUTEN HOOFDPL 22.000         10   \n",
       "17                                RD STEEN RD= 019111-17          0   \n",
       "18                    N-KANT V/H WILDROOSTER IN FIETSPAD          8   \n",
       "19                               HOUTENPL 24.000/ZIII400         10   \n",
       "20                                  HOUTENPL 23.000/Z200         10   \n",
       "21                                  BDR ZO V.TJETTEPAD 2         36   \n",
       "22                                       TOREN HK HOLLUM       -110   \n",
       "23                                  HS NAAST HS BADWG 44         28   \n",
       "24                                           HS BADWG 17         76   \n",
       "25                                  BDR VERBINDINGSWG 14        140   \n",
       "26                                          TOREN BALLUM         89   \n",
       "27                                        BDR NESSERWG 2        -52   \n",
       "28                            SCH TEN N.V. VERBINDINGSWG        -63   \n",
       "29                          SCHROEFANKER W-Z DUIN IN PUT          0   \n",
       "...                                                  ...        ...   \n",
       "36974                     3147 DOM HS PANNESHEIDERSTR 47        -20   \n",
       "36975               2685 DOM HS CANISIUSSTR 24, KERKRADE         22   \n",
       "36976                              1019 WS HS HAMSTR 193        -22   \n",
       "36977                     ON 1152 KLOOSTER DR.KEYENSTR 8        -80   \n",
       "36978                              CF HOOGSTR 157 BT DSM        -37   \n",
       "36979    3637-DSM RKK KAPELWG 1 (IN VOORGEVEL L.-PENANT)         47   \n",
       "36980  RD-VASTL 620311-11 RKK EIJGELSHOVEN     Z-VLAK...         32   \n",
       "36981           CENTRUM ROLDUC KERKRADE (RD-VASTLEG. 11)        267   \n",
       "36982                              HS BLEYERHEIDESTR 170        -28   \n",
       "36983                                    HS NIEUWSTR 178         11   \n",
       "36984                               HS KLOSTERLINDESTR 1         35   \n",
       "36985                           853-DOM HS HAMMOLENWG 12        -70   \n",
       "36986                               HS HAANRADESTRAAT 42        232   \n",
       "36987                                HS MEUSERSTRAAT 146         34   \n",
       "36988                               HS EUROPAWG ZUID 340        -42   \n",
       "36989  VDC BEUKENBOSWG O/D N299 W-LHFD         RD= 62...          0   \n",
       "36990  N VLMR VDC BEUKENBOSWG O/D N299 W-LHFD  RD= 62...         -7   \n",
       "36991                    HS BEUKENBOSWG 20 RD= 620313-15        -10   \n",
       "36992                       VDC OVER NIEWENHAGERHEIDESTR         22   \n",
       "36993                 GEBW Z/Z CENTR ROLDUC A/H FIETSPAD       -160   \n",
       "36994                          6KNT BT IN HS KOESTRAAT 4        -42   \n",
       "36995                       HS NIERSPRINKSTRAAT 16 LV 14        -22   \n",
       "36996  FABR GEBW HAMSTR 76                     TRAPMR...         20   \n",
       "36997                            BT IN HS KANDELFDSTR 74       -120   \n",
       "36998                   MB IN AANBOUW VAALSERSTR 387/385         40   \n",
       "36999           BT IN Z-Z VAN N-STUETZMAUER, VAALSER STR        -71   \n",
       "37000                     TRAFO WKCENTRUM A/D VAALSERSTR         44   \n",
       "37001                                  DK Z-Z VAALSERSTR         23   \n",
       "37002            BT IN ZOLLAMT GEBOUWTJE NABIJ HS NR 538         37   \n",
       "37003                                                  0          0   \n",
       "\n",
       "       y_muur_cm    meetdatum  orde                 time  \n",
       "0             35  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "1             42  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "2             50  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "3             30  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "4              8  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "5             25  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "6             45  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "7             46  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "8             15  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "9             35  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "10             0  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "11             0  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "12            14  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "13           -50  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "14           -50  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "15           -50  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "16           -50  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "17             0  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "18            -5  17-mar-2009     2  2009-03-17T00:00:00  \n",
       "19           -50  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "20           -50  30-jun-2001     2  2001-06-30T00:00:00  \n",
       "21            39  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "22            68  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "23            30  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "24            37  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "25            33  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "26           130  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "27            36  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "28            48  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "29             0  25-feb-2014     2  2014-02-25T00:00:00  \n",
       "...          ...          ...   ...                  ...  \n",
       "36974         22  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36975         25  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36976         25  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36977         53  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36978         67  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36979         24  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36980         90  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36981        147  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36982         56  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36983         15  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36984         53  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36985         31  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36986         42  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36987         85  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36988         25  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36989          0  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36990         -5  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36991         10  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36992         40  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36993         30  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36994         35  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36995         37  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36996         20  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36997         50  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36998          5  13-may-2012     2  2012-05-13T00:00:00  \n",
       "36999         16  13-may-2012     2  2012-05-13T00:00:00  \n",
       "37000         30  13-may-2012     2  2012-05-13T00:00:00  \n",
       "37001        -35  13-may-2012     2  2012-05-13T00:00:00  \n",
       "37002        110  13-may-2012     2  2012-05-13T00:00:00  \n",
       "37003          0         None     0                  NaN  \n",
       "\n",
       "[37004 rows x 11 columns]"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pandas.DataFrame([x['properties'] for x in features])"
   ]
  },
  {
   "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.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}