{ "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", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
gml_idpeilmerkx_rdy_rdnap_hoogtepub_tekstx_muur_cmy_muur_cmmeetdatumordetime
0nappeilmerken.1001C00011494906003203.043KORENMOLEN FORMERUM, L.V.INGANG423517-mar-200922009-03-17T00:00:00
1nappeilmerken.2001C00041483306019905.111ZOMERHUISJE 'SIL' N-EINDE HEEREWG-2794217-mar-200922009-03-17T00:00:00
2nappeilmerken.3001C000514904060236012.982STRAND HTL-REST.FORMERUM AAN ZEE -EINDE...-6075017-mar-200922009-03-17T00:00:00
3nappeilmerken.4001C00061490506000203.416BDR TE LANDEROM (GEM. NO.9)-443017-mar-200922009-03-17T00:00:00
4nappeilmerken.5001C00091481606005702.924TRAFO HEEREWEGG/DUINWEG NABIJ HS DUINWE...26817-mar-200922009-03-17T00:00:00
5nappeilmerken.6001D00011505606005801.424ZUIVELFB FORMERUM602517-mar-200922009-03-17T00:00:00
6nappeilmerken.7001D00021520006011802.635GB 'ONS HUIS' DORPSSTR 29-1374517-mar-200922009-03-17T00:00:00
7nappeilmerken.8001D00031526306014303.040BDR DORPSSTR 995764617-mar-200922009-03-17T00:00:00
8nappeilmerken.9001D00121512206009401.609BDR A/D Z-Z V/D WEG TE LIES NR. 48531517-mar-200922009-03-17T00:00:00
9nappeilmerken.10001D00141535006018403.733HS NW-Z V/D WEG HOORN-OOSTEREND GEM 5533517-mar-200922009-03-17T00:00:00
10nappeilmerken.11001D00161550706036502.929SCHROEFANKER (ZIE AANM.SCHETS) X=1550...0017-mar-200922009-03-17T00:00:00
11nappeilmerken.12001D00211559006037803.407SCHROEFANKER0030-jun-200122001-06-30T00:00:00
12nappeilmerken.13001D00221545806020203.617TRAFO HOOFDWG 59921417-mar-200922009-03-17T00:00:00
13nappeilmerken.14001D00231565206047203.040HOUTENPL 19.400/L24010-5030-jun-200122001-06-30T00:00:00
14nappeilmerken.15001D00241571006049402.716HOUTENPL 20.000/L18010-5030-jun-200122001-06-30T00:00:00
15nappeilmerken.16001D00251580606052201.979HOUTEN HOOFDPL 21.00010-5030-jun-200122001-06-30T00:00:00
16nappeilmerken.17001D00261590406054302.041HOUTEN HOOFDPL 22.00010-5030-jun-200122001-06-30T00:00:00
17nappeilmerken.18001D00321559006037803.701RD STEEN RD= 019111-170017-mar-200922009-03-17T00:00:00
18nappeilmerken.19001D00331559006037803.430N-KANT V/H WILDROOSTER IN FIETSPAD8-517-mar-200922009-03-17T00:00:00
19nappeilmerken.20001G00081609006062601.846HOUTENPL 24.000/ZIII40010-5030-jun-200122001-06-30T00:00:00
20nappeilmerken.21001G00091600006058501.854HOUTENPL 23.000/Z20010-5030-jun-200122001-06-30T00:00:00
21nappeilmerken.22001H00031711606053003.035BDR ZO V.TJETTEPAD 2363925-feb-201422014-02-25T00:00:00
22nappeilmerken.23001H00051718506055204.190TOREN HK HOLLUM-1106825-feb-201422014-02-25T00:00:00
23nappeilmerken.24001H00071706406059202.906HS NAAST HS BADWG 44283025-feb-201422014-02-25T00:00:00
24nappeilmerken.25001H00091712206059502.733HS BADWG 17763725-feb-201422014-02-25T00:00:00
25nappeilmerken.26001H00111737106068203.580BDR VERBINDINGSWG 141403325-feb-201422014-02-25T00:00:00
26nappeilmerken.27001H00131749006064604.586TOREN BALLUM8913025-feb-201422014-02-25T00:00:00
27nappeilmerken.28001H00141750806066803.621BDR NESSERWG 2-523625-feb-201422014-02-25T00:00:00
28nappeilmerken.29001H00161773206066602.734SCH TEN N.V. VERBINDINGSWG-634825-feb-201422014-02-25T00:00:00
29nappeilmerken.30001H00221707946055205.902SCHROEFANKER W-Z DUIN IN PUT0025-feb-201422014-02-25T00:00:00
....................................
36974nappeilmerken.36975062E0045203110317890163.3323147 DOM HS PANNESHEIDERSTR 47-202213-may-201222012-05-13T00:00:00
36975nappeilmerken.36976062E0047202640318630158.2732685 DOM HS CANISIUSSTR 24, KERKRADE222513-may-201222012-05-13T00:00:00
36976nappeilmerken.36977062E0048200220317920155.5771019 WS HS HAMSTR 193-222513-may-201222012-05-13T00:00:00
36977nappeilmerken.36978062E0064202430319700153.809ON 1152 KLOOSTER DR.KEYENSTR 8-805313-may-201222012-05-13T00:00:00
36978nappeilmerken.36979062E0066200080324410157.619CF HOOGSTR 157 BT DSM-376713-may-201222012-05-13T00:00:00
36979nappeilmerken.36980062E0067200950319650155.9463637-DSM RKK KAPELWG 1 (IN VOORGEVEL L.-PENANT)472413-may-201222012-05-13T00:00:00
36980nappeilmerken.36981062E007120250032295099.527RD-VASTL 620311-11 RKK EIJGELSHOVEN Z-VLAK...329013-may-201222012-05-13T00:00:00
36981nappeilmerken.36982062E0078203890320040153.165CENTRUM ROLDUC KERKRADE (RD-VASTLEG. 11)26714713-may-201222012-05-13T00:00:00
36982nappeilmerken.36983062E0079202850318260161.373HS BLEYERHEIDESTR 170-285613-may-201222012-05-13T00:00:00
36983nappeilmerken.36984062E0080203800319380161.071HS NIEUWSTR 178111513-may-201222012-05-13T00:00:00
36984nappeilmerken.36985062E0081204210320420108.218HS KLOSTERLINDESTR 1355313-may-201222012-05-13T00:00:00
36985nappeilmerken.36986062E0082202000319980119.390853-DOM HS HAMMOLENWG 12-703113-may-201222012-05-13T00:00:00
36986nappeilmerken.36987062E0094203120322220103.180HS HAANRADESTRAAT 422324213-may-201222012-05-13T00:00:00
36987nappeilmerken.36988062E0095203490321720105.948HS MEUSERSTRAAT 146348513-may-201222012-05-13T00:00:00
36988nappeilmerken.36989062E0096202190324170133.234HS EUROPAWG ZUID 340-422513-may-201222012-05-13T00:00:00
36989nappeilmerken.36990062E0097202690321240143.783VDC BEUKENBOSWG O/D N299 W-LHFD RD= 62...0013-may-201222012-05-13T00:00:00
36990nappeilmerken.36991062E0098202680321240143.322N VLMR VDC BEUKENBOSWG O/D N299 W-LHFD RD= 62...-7-513-may-201222012-05-13T00:00:00
36991nappeilmerken.36992062E0099202680321200141.773HS BEUKENBOSWG 20 RD= 620313-15-101013-may-201222012-05-13T00:00:00
36992nappeilmerken.36993062E0100200700324950141.547VDC OVER NIEWENHAGERHEIDESTR224013-may-201222012-05-13T00:00:00
36993nappeilmerken.36994062E0101203930320050143.069GEBW Z/Z CENTR ROLDUC A/H FIETSPAD-1603013-may-201222012-05-13T00:00:00
36994nappeilmerken.36995062E0102202790320100149.5396KNT BT IN HS KOESTRAAT 4-423513-may-201222012-05-13T00:00:00
36995nappeilmerken.36996062E0103202690319880155.970HS NIERSPRINKSTRAAT 16 LV 14-223713-may-201222012-05-13T00:00:00
36996nappeilmerken.36997062E0104200960318560150.921FABR GEBW HAMSTR 76 TRAPMR...202013-may-201222012-05-13T00:00:00
36997nappeilmerken.36998062G0003201400309000222.014BT IN HS KANDELFDSTR 74-1205013-may-201222012-05-13T00:00:00
36998nappeilmerken.36999062G0004201360309010217.811MB IN AANBOUW VAALSERSTR 387/38540513-may-201222012-05-13T00:00:00
36999nappeilmerken.37000062G0005200470309060199.927BT IN Z-Z VAN N-STUETZMAUER, VAALSER STR-711613-may-201222012-05-13T00:00:00
37000nappeilmerken.37001062G0006201080309160217.545TRAFO WKCENTRUM A/D VAALSERSTR443013-may-201222012-05-13T00:00:00
37001nappeilmerken.37002062G0007200560309040200.835DK Z-Z VAALSERSTR23-3513-may-201222012-05-13T00:00:00
37002nappeilmerken.37003062G0008200080309210198.780BT IN ZOLLAMT GEBOUWTJE NABIJ HS NR 5383711013-may-201222012-05-13T00:00:00
37003nappeilmerken.37004None000.000000None0NaN
\n", "

37004 rows × 11 columns

\n", "
" ], "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 }