blob: b9bbb1d8e789a2047941d1e5f9724f2125a06350 (
plain)
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
|
.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
# sudo -u postgres osm2pgsql -d map.node5.net -O flex -S data_extractor.lua pbfs/hamburg-latest.osm.pbf --slim --append
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, this resets DB
sudo -u postgres osm2pgsql -d map.node5.net -O flex -S data_extractor.lua pbfs/denmark-latest.osm.pbf --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: denmark hamburg count_per_country notify_desktop
.DEFAULT_GOAL := process_data
|
