4 files changed, 45 insertions, 32 deletions

diff --git a/alias b/alias
index 704a49c..2937f6b 100644
--- a/alias
+++ b/alias
@@ -158,6 +158,7 @@ alias sample-csv='curl -O https://docs.mapbox.com/help/data/airports.csv'
 alias sample-svg='curl -O https://docs.mapbox.com/help/data/bicycle-24.svg'
 alias sample-mbtiles='curl -O https://docs.mapbox.com/help/data/trails.mbtiles'
 alias sample-kml='curl -O https://docs.mapbox.com/help/data/farmers_markets.kml'
+alias sample-osm='curl https://api.openstreetmap.org/api/0.6/node/3428095932'
 
 # data file
 alias taiwan='curl -O http://download.geofabrik.de/asia/taiwan-latest.osm.pbf'
diff --git a/scripts/osm/osm b/scripts/osm/osm
index 2d32575..f2f08f1 100644
--- a/scripts/osm/osm
+++ b/scripts/osm/osm
@@ -1,10 +1,10 @@
 #! /bin/sh
 
 #OSM_SERVER=https://master.apis.dev.openstreetmap.org
-OSM_SERVER=https://api.openstreetmap.org
+export OSM_SERVER=https://api.openstreetmap.org
 
-OSM_API=$OSM_SERVER/api/0.6
-OSM_USER_PASSWD=$(cat $SETTING_DIR/tokens/osm)
+export OSM_API=$OSM_SERVER/api/0.6
+export OSM_USER_PASSWD=$(cat $SETTING_DIR/tokens/osm)
 
 FILENAME=$0
 
diff --git a/scripts/osm/osm.osc.create b/scripts/osm/osm.osc.create
index 61a4dfb..c9bdaa8 100755
--- a/scripts/osm/osm.osc.create
+++ b/scripts/osm/osm.osc.create
@@ -1,17 +1,29 @@
-    while read -r line
-    do
-        array=( $(echo $line) )
+#!/bin/bash
 
-        cat $1 |\
-        sed -nr "
-            /<$array[1] id=$array[2]/,/<\/$array[1]/ {
-            /<$array[1] id=$array[2]/ a \ \ \ \ <tag k=\"$array[3]\" v=$array[4]\/>
-            /<tag k=$array[3]/ !p
-            /<\/$array[1]/ q
-         }" >> $1.osc
-     done
+while read -r line
+do
+    TYPE=$(echo $line | cut -d ' ' -f1)
+    ID=$(echo $line | cut -d ' ' -f2)
+    NEW_TAGS=$(echo $line |\
+               cut -d' ' -f3- | xargs -n2 echo |\
+               sed -r 's/^([^ ]+) (.+)/<tag k=\"\1\" v=\"\2\"\/>/' |\
+               paste -s)
 
-    sed -ir '1 i <osmChange version="0.6" generator="bash script">
-             1 i <modify>
-             $ a </modify>
-             $ a </osmChange>' $1.osc
+    TAG_PATTERN=$(echo $line |\
+                  cut -d' ' -f3- | xargs -n2 echo |\
+                  cut -d' ' -f1 | paste -s -d'|')
+
+    echo $TAG_PATTERN > /dev/tty
+
+    cat $1 |\
+    sed -nr "/<$TYPE id=\"$ID\"/,/<\/$TYPE/ {
+             /<$TYPE id=\"$ID\"/ a \ \ \ \ $NEW_TAGS
+             /<tag k=\"($TAG_PATTERN)\"/ !p
+             /<\/$TYPE/ q
+            }" >> $1.osc
+done
+
+sed -ir '1 i <osmChange version="0.6" generator="bash script">
+         1 i <modify>
+         $ a </modify>
+         $ a </osmChange>' $1.osc
diff --git a/scripts/osm/osm.village.nat_ref.makefile b/scripts/osm/osm.village.nat_ref.makefile
index f763c19..ffadcf4 100755..100644
--- a/scripts/osm/osm.village.nat_ref.makefile
+++ b/scripts/osm/osm.village.nat_ref.makefile
@@ -1,3 +1,5 @@
+SHELL := /bin/bash
+
 data/taiwan-latest.osm.pbf:
         mkdir -p data
         curl -o $@ http://download.geofabrik.de/asia/taiwan-latest.osm.pbf
@@ -23,7 +25,13 @@ village.no_nat_ref.csv: village.csv
 village.with_nat_ref.csv: village.csv
         (head -1 $<; grep nat_ref $<) |\
         sed -r "s/\"\"\".*nat_ref\"\"=>\"\"([^\"]+).*\"\"\"/\1/g" |\
-        sed '1s/other_tags/nat_ref/'> $@
+        sed '1s/other_tags/nat_ref/;s/"//g' |\
+        (sed -u 1q; sort -t',' -k5)> $@
+
+village.gov.csv: data/VILLAGE_MOI_1081007.shp
+        ogr2ogr -f CSV /vsistdout/ $< |\
+        (sed -u 1q; sort -t',' -k1) |\
+        sed 's/"//g'> $@
 
 matched.csv: data/VILLAGE_MOI_1081007.shp village.no_nat_ref.csv
         ogr2ogr $@ $(word 2,$^) \
@@ -33,18 +41,12 @@ matched.csv: data/VILLAGE_MOI_1081007.shp village.no_nat_ref.csv
                       FROM 'village.no_nat_ref' osm, '$<'.VILLAGE_MOI_1081007 gov \
                       WHERE osm.name = gov.VILLNAME AND Intersects(gov.geometry, osm.geometry)"
 
-village.gov.csv: data/VILLAGE_MOI_1081007.shp
-        ogr2ogr $@ $<
+matched.by_nat_ref.list: village.with_nat_ref.csv village.gov.csv 
+        join -t',' -1 5 -2 1 <(sed 1d $<) <(sed 1d $(word 2,$^)) > $@
 
-matched.by_ref.csv: village.gov.csv village.with_nat_ref.csv
-        ogr2ogr $@ $(word 2,$^) \
-                -dialect sqlite \
-                -sql "SELECT osm.osm_id, gov.* \
-                      FROM 'village.with_nat_ref' osm, '$<'.'village.gov' gov \
-                      WHERE osm.nat_ref = gov.VILLCODE"
-
-diff: matched.by_ref.csv
-        awk -F',' -v q='"' '{print (, "is_in:county", q{q, "is_in:town", q{})}" q, "name:en", q$6q }' $<
+change.county_town_en.list: matched.by_nat_ref.list
+        awk -F',' -v q=\" '{print $$4, "is_in:county", q$$6q, "is_in:town", q$$7q, "name:en", q$$9q }' $< |\
+        sed 's/^/relation /' > $@
 
 confilct.list: matched.csv
         cat $< | cut -d',' -f2 | sort | uniq -d | xargs -I {} grep {} $<
@@ -60,5 +62,3 @@ change.list: matched.csv
         cat $< |\
         sed 1d |\
         awk -F',' '{print "relation", $$1, "nat_ref", $$2}' > $@
-
-# sed -i -r 's/([0-9]+ +)(.+)$/\1"name:en" "\2"/' diff.eng