Data processor - Get multiple countries

1 files changed, 36 insertions, 2 deletions

diff --git a/data_extractor/Makefile b/data_extractor/Makefile
index 3ae44a7..c896889 100644
--- a/data_extractor/Makefile
+++ b/data_extractor/Makefile
@@ -1,2 +1,36 @@
-process_data:
-	osm2pgsql -d map -O flex -S data_extractor.lua ~/Downloads/denmark-latest.osm.pbf
+.PHONY: process_data
+SHELL := /bin/bash
+
+pbfs/hamburg-latest.osm.pbf:
+	cd pbfs && wget https://download.geofabrik.de/europe/germany/hamburg-latest.osm.pbf
+
+pbfs/denmark-latest.osm.pbf:
+	cd pbfs && wget https://download.geofabrik.de/europe/denmark-latest.osm.pbf
+
+hamburg: pbfs/hamburg-latest.osm.pbf
+	# Load Hamburg, this resets DB
+	sudo -u postgres osm2pgsql -d map.node5.net -O flex -S data_extractor.lua pbfs/hamburg-latest.osm.pbf --slim
+	sudo -u postgres psql -d map.node5.net -c "update poi set region = 'Hamburg' where region IS NULL;"
+	sudo -u postgres psql -d map.node5.net -c "update poi set country = 'Germany' where country IS NULL;"
+
+denmark:
+	# Load Denmark
+	sudo -u postgres osm2pgsql -d map.node5.net -O flex -S data_extractor.lua pbfs/denmark-latest.osm.pbf --append --slim
+	sudo -u postgres psql -d map.node5.net -c "update poi set country = 'Denmark' where country IS NULL;"
+
+permission:
+	# Set code user permission
+	sudo -u postgres psql -d map.node5.net -c 'grant select on table poi to "map.node5.net";'
+
+count_per_country:
+	sudo -u postgres psql -d map.node5.net -c "select country, count(*) from poi group by country;"
+
+db_shell:
+	sudo -u postgres psql -d map.node5.net
+
+notify_desktop:
+	notify-send "OSM processing" "done"
+
+process_data: hamburg denmark count_per_country notify_desktop
+
+.DEFAULT_GOAL := process_data