From 24ec8b02c15c140a710440139821bfb7521adfc2 Mon Sep 17 00:00:00 2001 From: user Date: Sat, 28 Dec 2024 14:30:48 +0100 Subject: Data processor - Get multiple countries --- data_extractor/Makefile | 38 ++++++++++++++++++++++++++++++++++++-- 1 file changed, 36 insertions(+), 2 deletions(-) (limited to 'data_extractor/Makefile') 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 -- cgit v1.2.3