diff options
Diffstat (limited to 'data_extractor/Makefile')
| -rw-r--r-- | data_extractor/Makefile | 38 |
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 |