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