In [1]:
%%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'
In [85]:
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))
Out[85]:
datetime.datetime(2009, 3, 17, 0, 0)
In [78]:
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
In [80]:
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)
In [30]:
import geojson
In [82]:
geojson.dump(
geojson.FeatureCollection(features),
open('nap.json', 'w')
)
In [86]:
pandas.DataFrame([x['properties'] for x in features])
Out[86]:
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
In [ ]:
Content source: SiggyF/notebooks
Similar notebooks: