{ "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": [ "
\n", " | gml_id | \n", "peilmerk | \n", "x_rd | \n", "y_rd | \n", "nap_hoogte | \n", "pub_tekst | \n", "x_muur_cm | \n", "y_muur_cm | \n", "meetdatum | \n", "orde | \n", "time | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "nappeilmerken.1 | \n", "001C0001 | \n", "149490 | \n", "600320 | \n", "3.043 | \n", "KORENMOLEN FORMERUM, L.V.INGANG | \n", "42 | \n", "35 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
1 | \n", "nappeilmerken.2 | \n", "001C0004 | \n", "148330 | \n", "601990 | \n", "5.111 | \n", "ZOMERHUISJE 'SIL' N-EINDE HEEREWG | \n", "-279 | \n", "42 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
2 | \n", "nappeilmerken.3 | \n", "001C0005 | \n", "149040 | \n", "602360 | \n", "12.982 | \n", "STRAND HTL-REST.FORMERUM AAN ZEE -EINDE... | \n", "-607 | \n", "50 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
3 | \n", "nappeilmerken.4 | \n", "001C0006 | \n", "149050 | \n", "600020 | \n", "3.416 | \n", "BDR TE LANDEROM (GEM. NO.9) | \n", "-44 | \n", "30 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
4 | \n", "nappeilmerken.5 | \n", "001C0009 | \n", "148160 | \n", "600570 | \n", "2.924 | \n", "TRAFO HEEREWEGG/DUINWEG NABIJ HS DUINWE... | \n", "26 | \n", "8 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
5 | \n", "nappeilmerken.6 | \n", "001D0001 | \n", "150560 | \n", "600580 | \n", "1.424 | \n", "ZUIVELFB FORMERUM | \n", "60 | \n", "25 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
6 | \n", "nappeilmerken.7 | \n", "001D0002 | \n", "152000 | \n", "601180 | \n", "2.635 | \n", "GB 'ONS HUIS' DORPSSTR 29 | \n", "-137 | \n", "45 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
7 | \n", "nappeilmerken.8 | \n", "001D0003 | \n", "152630 | \n", "601430 | \n", "3.040 | \n", "BDR DORPSSTR 99 | \n", "576 | \n", "46 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
8 | \n", "nappeilmerken.9 | \n", "001D0012 | \n", "151220 | \n", "600940 | \n", "1.609 | \n", "BDR A/D Z-Z V/D WEG TE LIES NR. 48 | \n", "53 | \n", "15 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
9 | \n", "nappeilmerken.10 | \n", "001D0014 | \n", "153500 | \n", "601840 | \n", "3.733 | \n", "HS NW-Z V/D WEG HOORN-OOSTEREND GEM 5 | \n", "53 | \n", "35 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
10 | \n", "nappeilmerken.11 | \n", "001D0016 | \n", "155070 | \n", "603650 | \n", "2.929 | \n", "SCHROEFANKER (ZIE AANM.SCHETS) X=1550... | \n", "0 | \n", "0 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
11 | \n", "nappeilmerken.12 | \n", "001D0021 | \n", "155900 | \n", "603780 | \n", "3.407 | \n", "SCHROEFANKER | \n", "0 | \n", "0 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
12 | \n", "nappeilmerken.13 | \n", "001D0022 | \n", "154580 | \n", "602020 | \n", "3.617 | \n", "TRAFO HOOFDWG 59 | \n", "92 | \n", "14 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
13 | \n", "nappeilmerken.14 | \n", "001D0023 | \n", "156520 | \n", "604720 | \n", "3.040 | \n", "HOUTENPL 19.400/L240 | \n", "10 | \n", "-50 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
14 | \n", "nappeilmerken.15 | \n", "001D0024 | \n", "157100 | \n", "604940 | \n", "2.716 | \n", "HOUTENPL 20.000/L180 | \n", "10 | \n", "-50 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
15 | \n", "nappeilmerken.16 | \n", "001D0025 | \n", "158060 | \n", "605220 | \n", "1.979 | \n", "HOUTEN HOOFDPL 21.000 | \n", "10 | \n", "-50 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
16 | \n", "nappeilmerken.17 | \n", "001D0026 | \n", "159040 | \n", "605430 | \n", "2.041 | \n", "HOUTEN HOOFDPL 22.000 | \n", "10 | \n", "-50 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
17 | \n", "nappeilmerken.18 | \n", "001D0032 | \n", "155900 | \n", "603780 | \n", "3.701 | \n", "RD STEEN RD= 019111-17 | \n", "0 | \n", "0 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
18 | \n", "nappeilmerken.19 | \n", "001D0033 | \n", "155900 | \n", "603780 | \n", "3.430 | \n", "N-KANT V/H WILDROOSTER IN FIETSPAD | \n", "8 | \n", "-5 | \n", "17-mar-2009 | \n", "2 | \n", "2009-03-17T00:00:00 | \n", "
19 | \n", "nappeilmerken.20 | \n", "001G0008 | \n", "160900 | \n", "606260 | \n", "1.846 | \n", "HOUTENPL 24.000/ZIII400 | \n", "10 | \n", "-50 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
20 | \n", "nappeilmerken.21 | \n", "001G0009 | \n", "160000 | \n", "605850 | \n", "1.854 | \n", "HOUTENPL 23.000/Z200 | \n", "10 | \n", "-50 | \n", "30-jun-2001 | \n", "2 | \n", "2001-06-30T00:00:00 | \n", "
21 | \n", "nappeilmerken.22 | \n", "001H0003 | \n", "171160 | \n", "605300 | \n", "3.035 | \n", "BDR ZO V.TJETTEPAD 2 | \n", "36 | \n", "39 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
22 | \n", "nappeilmerken.23 | \n", "001H0005 | \n", "171850 | \n", "605520 | \n", "4.190 | \n", "TOREN HK HOLLUM | \n", "-110 | \n", "68 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
23 | \n", "nappeilmerken.24 | \n", "001H0007 | \n", "170640 | \n", "605920 | \n", "2.906 | \n", "HS NAAST HS BADWG 44 | \n", "28 | \n", "30 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
24 | \n", "nappeilmerken.25 | \n", "001H0009 | \n", "171220 | \n", "605950 | \n", "2.733 | \n", "HS BADWG 17 | \n", "76 | \n", "37 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
25 | \n", "nappeilmerken.26 | \n", "001H0011 | \n", "173710 | \n", "606820 | \n", "3.580 | \n", "BDR VERBINDINGSWG 14 | \n", "140 | \n", "33 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
26 | \n", "nappeilmerken.27 | \n", "001H0013 | \n", "174900 | \n", "606460 | \n", "4.586 | \n", "TOREN BALLUM | \n", "89 | \n", "130 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
27 | \n", "nappeilmerken.28 | \n", "001H0014 | \n", "175080 | \n", "606680 | \n", "3.621 | \n", "BDR NESSERWG 2 | \n", "-52 | \n", "36 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
28 | \n", "nappeilmerken.29 | \n", "001H0016 | \n", "177320 | \n", "606660 | \n", "2.734 | \n", "SCH TEN N.V. VERBINDINGSWG | \n", "-63 | \n", "48 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
29 | \n", "nappeilmerken.30 | \n", "001H0022 | \n", "170794 | \n", "605520 | \n", "5.902 | \n", "SCHROEFANKER W-Z DUIN IN PUT | \n", "0 | \n", "0 | \n", "25-feb-2014 | \n", "2 | \n", "2014-02-25T00:00:00 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
36974 | \n", "nappeilmerken.36975 | \n", "062E0045 | \n", "203110 | \n", "317890 | \n", "163.332 | \n", "3147 DOM HS PANNESHEIDERSTR 47 | \n", "-20 | \n", "22 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36975 | \n", "nappeilmerken.36976 | \n", "062E0047 | \n", "202640 | \n", "318630 | \n", "158.273 | \n", "2685 DOM HS CANISIUSSTR 24, KERKRADE | \n", "22 | \n", "25 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36976 | \n", "nappeilmerken.36977 | \n", "062E0048 | \n", "200220 | \n", "317920 | \n", "155.577 | \n", "1019 WS HS HAMSTR 193 | \n", "-22 | \n", "25 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36977 | \n", "nappeilmerken.36978 | \n", "062E0064 | \n", "202430 | \n", "319700 | \n", "153.809 | \n", "ON 1152 KLOOSTER DR.KEYENSTR 8 | \n", "-80 | \n", "53 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36978 | \n", "nappeilmerken.36979 | \n", "062E0066 | \n", "200080 | \n", "324410 | \n", "157.619 | \n", "CF HOOGSTR 157 BT DSM | \n", "-37 | \n", "67 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36979 | \n", "nappeilmerken.36980 | \n", "062E0067 | \n", "200950 | \n", "319650 | \n", "155.946 | \n", "3637-DSM RKK KAPELWG 1 (IN VOORGEVEL L.-PENANT) | \n", "47 | \n", "24 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36980 | \n", "nappeilmerken.36981 | \n", "062E0071 | \n", "202500 | \n", "322950 | \n", "99.527 | \n", "RD-VASTL 620311-11 RKK EIJGELSHOVEN Z-VLAK... | \n", "32 | \n", "90 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36981 | \n", "nappeilmerken.36982 | \n", "062E0078 | \n", "203890 | \n", "320040 | \n", "153.165 | \n", "CENTRUM ROLDUC KERKRADE (RD-VASTLEG. 11) | \n", "267 | \n", "147 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36982 | \n", "nappeilmerken.36983 | \n", "062E0079 | \n", "202850 | \n", "318260 | \n", "161.373 | \n", "HS BLEYERHEIDESTR 170 | \n", "-28 | \n", "56 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36983 | \n", "nappeilmerken.36984 | \n", "062E0080 | \n", "203800 | \n", "319380 | \n", "161.071 | \n", "HS NIEUWSTR 178 | \n", "11 | \n", "15 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36984 | \n", "nappeilmerken.36985 | \n", "062E0081 | \n", "204210 | \n", "320420 | \n", "108.218 | \n", "HS KLOSTERLINDESTR 1 | \n", "35 | \n", "53 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36985 | \n", "nappeilmerken.36986 | \n", "062E0082 | \n", "202000 | \n", "319980 | \n", "119.390 | \n", "853-DOM HS HAMMOLENWG 12 | \n", "-70 | \n", "31 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36986 | \n", "nappeilmerken.36987 | \n", "062E0094 | \n", "203120 | \n", "322220 | \n", "103.180 | \n", "HS HAANRADESTRAAT 42 | \n", "232 | \n", "42 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36987 | \n", "nappeilmerken.36988 | \n", "062E0095 | \n", "203490 | \n", "321720 | \n", "105.948 | \n", "HS MEUSERSTRAAT 146 | \n", "34 | \n", "85 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36988 | \n", "nappeilmerken.36989 | \n", "062E0096 | \n", "202190 | \n", "324170 | \n", "133.234 | \n", "HS EUROPAWG ZUID 340 | \n", "-42 | \n", "25 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36989 | \n", "nappeilmerken.36990 | \n", "062E0097 | \n", "202690 | \n", "321240 | \n", "143.783 | \n", "VDC BEUKENBOSWG O/D N299 W-LHFD RD= 62... | \n", "0 | \n", "0 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36990 | \n", "nappeilmerken.36991 | \n", "062E0098 | \n", "202680 | \n", "321240 | \n", "143.322 | \n", "N VLMR VDC BEUKENBOSWG O/D N299 W-LHFD RD= 62... | \n", "-7 | \n", "-5 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36991 | \n", "nappeilmerken.36992 | \n", "062E0099 | \n", "202680 | \n", "321200 | \n", "141.773 | \n", "HS BEUKENBOSWG 20 RD= 620313-15 | \n", "-10 | \n", "10 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36992 | \n", "nappeilmerken.36993 | \n", "062E0100 | \n", "200700 | \n", "324950 | \n", "141.547 | \n", "VDC OVER NIEWENHAGERHEIDESTR | \n", "22 | \n", "40 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36993 | \n", "nappeilmerken.36994 | \n", "062E0101 | \n", "203930 | \n", "320050 | \n", "143.069 | \n", "GEBW Z/Z CENTR ROLDUC A/H FIETSPAD | \n", "-160 | \n", "30 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36994 | \n", "nappeilmerken.36995 | \n", "062E0102 | \n", "202790 | \n", "320100 | \n", "149.539 | \n", "6KNT BT IN HS KOESTRAAT 4 | \n", "-42 | \n", "35 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36995 | \n", "nappeilmerken.36996 | \n", "062E0103 | \n", "202690 | \n", "319880 | \n", "155.970 | \n", "HS NIERSPRINKSTRAAT 16 LV 14 | \n", "-22 | \n", "37 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36996 | \n", "nappeilmerken.36997 | \n", "062E0104 | \n", "200960 | \n", "318560 | \n", "150.921 | \n", "FABR GEBW HAMSTR 76 TRAPMR... | \n", "20 | \n", "20 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36997 | \n", "nappeilmerken.36998 | \n", "062G0003 | \n", "201400 | \n", "309000 | \n", "222.014 | \n", "BT IN HS KANDELFDSTR 74 | \n", "-120 | \n", "50 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36998 | \n", "nappeilmerken.36999 | \n", "062G0004 | \n", "201360 | \n", "309010 | \n", "217.811 | \n", "MB IN AANBOUW VAALSERSTR 387/385 | \n", "40 | \n", "5 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
36999 | \n", "nappeilmerken.37000 | \n", "062G0005 | \n", "200470 | \n", "309060 | \n", "199.927 | \n", "BT IN Z-Z VAN N-STUETZMAUER, VAALSER STR | \n", "-71 | \n", "16 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
37000 | \n", "nappeilmerken.37001 | \n", "062G0006 | \n", "201080 | \n", "309160 | \n", "217.545 | \n", "TRAFO WKCENTRUM A/D VAALSERSTR | \n", "44 | \n", "30 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
37001 | \n", "nappeilmerken.37002 | \n", "062G0007 | \n", "200560 | \n", "309040 | \n", "200.835 | \n", "DK Z-Z VAALSERSTR | \n", "23 | \n", "-35 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
37002 | \n", "nappeilmerken.37003 | \n", "062G0008 | \n", "200080 | \n", "309210 | \n", "198.780 | \n", "BT IN ZOLLAMT GEBOUWTJE NABIJ HS NR 538 | \n", "37 | \n", "110 | \n", "13-may-2012 | \n", "2 | \n", "2012-05-13T00:00:00 | \n", "
37003 | \n", "nappeilmerken.37004 | \n", "None | \n", "0 | \n", "0 | \n", "0.000 | \n", "0 | \n", "0 | \n", "0 | \n", "None | \n", "0 | \n", "NaN | \n", "
37004 rows × 11 columns
\n", "