pmgre/Makefile at master · Daml/pmgre · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
SHAPES=data/2017_T4_ZAPM.shp data/2018_T1_ZAPM.shp data/2018_T2_ZAPM.shp data/2018_T3_ZAPM.shp data/2018_T4_ZAPM.shp data/2019_T1_ZAPM.shp

all: $(SHAPES) data/osm.csv data/zapm.png

data/osm.csv: query.xml
	mkdir -p $(@D)
	curl -s -o $@ -X POST -d @$< https://overpass-api.de/api/interpreter

data/zapm.png: zapm.gp data/zapm.dat
	mkdir -p $(@D)
	gnuplot zapm.gp > $@

data/zapm.dat: $(SHAPES:.shp=.csv)
	mkdir -p $(@D)
	python zapm.py $? > data/ZAPM.dat

data/%.csv: data/%.shp
	mkdir -p $(@D)
	ogr2ogr -lco STRING_QUOTING=IF_NEEDED -dialect sqlite -f "CSV" -sql "SELECT REPLACE(REPLACE(CodeOI,'FRTE','FI'),'ISER', 'IF') AS CID,COUNT(*) AS NBPM,COALESCE(SUM(lgtZAPM),0) AS NBLOC, SUM(lgtMadPM) AS NBRAC FROM '$(basename $(@F))' WHERE INSEE_DEP='38' GROUP BY CodeOI" $@ $<

# Extract SHP bruts
# -----------------

tmp/%.shp: refs/%.zip
	mkdir -p $(@D)
	unzip -d $(@D) $<
	touch $@

tmp/%.shp: refs/%.7z
	mkdir -p $(@D)
	7z e -o$(@D) $<
	touch $@

# Extract SHP clean
# -----------------

data/2017_T4_ZAPM.shp: tmp/2017T4_ZAPM_OD.shp
	mkdir -p $(@D)
	ogr2ogr -f "ESRI Shapefile" -where "INSEE_DEP='38'" $@ $<

data/2018_T1_ZAPM.shp: tmp/2018T1_ZAPM_OD.shp
	mkdir -p $(@D)
	ogr2ogr -f "ESRI Shapefile" -where "INSEE_DEP='38'" $@ $<

data/2018_T2_ZAPM.shp: tmp/2018T2_zapm_od.shp
	mkdir -p $(@D)
	ogr2ogr -f "ESRI Shapefile" -where "INSEE_DEP='38'" $@ $<

data/2018_T3_ZAPM.shp: tmp/2018_T3_zapm_dep_V6.shp
	mkdir -p $(@D)
	ogr2ogr -f "ESRI Shapefile" -where "INSEE_DEP='38'" $@ $<

data/2018_T4_ZAPM.shp: tmp/zapm_T4_dep_V10.shp
	mkdir -p $(@D)
	ogr2ogr -f "ESRI Shapefile" -where "INSEE_DEP='38'" $@ $<

data/2019_T1_ZAPM.shp: tmp/2019T1_ZAPM.shp
	mkdir -p $(@D)
	ogr2ogr -f "ESRI Shapefile" -where "INSEE_DEP='38'" $@ $<

# Downloads
# ---------

refs/2017T4_ZAPM_OD.zip:
	mkdir -p $(@D)
	curl -o $@ https://www.data.gouv.fr/s/resources/le-marche-du-haut-et-tres-haut-debit-fixe-deploiements/20180607-184721/2017T4_ZAPM_OD.zip

refs/2018T1_ZAPM_OD.zip:
	mkdir -p $(@D)
	curl -o $@ https://www.data.gouv.fr/s/resources/le-marche-du-haut-et-tres-haut-debit-fixe-deploiements/20180607-184623/2018T1_ZAPM_OD.zip

refs/2018T2_zapm_od.7z:
	mkdir -p $(@D)
	curl -o $@ https://static.data.gouv.fr/resources/le-marche-du-haut-et-tres-haut-debit-fixe-deploiements/20180918-115753/2018t2-zapm-od.7z

refs/2018_T3_zapm_dep_V6.zip:
	mkdir -p $(@D)
	curl -o $@ https://static.data.gouv.fr/resources/le-marche-du-haut-et-tres-haut-debit-fixe-deploiements/20190305-190551/2018-t3-zapm-dep-v6.zip

refs/zapm_T4_dep_V10.zip:
	mkdir -p $(@D)
	curl -o $@ https://static.data.gouv.fr/resources/le-marche-du-haut-et-tres-haut-debit-fixe-deploiements/20190305-190428/zapm-t4-dep-v10.zip

refs/2019T1_ZAPM.zip:
	mkdir -p $(@D)
	curl -o $@ https://static.data.gouv.fr/resources/le-marche-du-haut-et-tres-haut-debit-fixe-deploiements/20190625-124056/2019t1-zapm.zip

# Phony stuffs
# ------------

clean:
	rm -rf tmp

purge: clean
	rm -rf data

.PHONY: clean purge