From 56c24f398714b9594085eb85be38e90d24b5b49d Mon Sep 17 00:00:00 2001 From: typebrook Date: Mon, 18 Nov 2019 15:18:50 +0800 Subject: update --- scripts/osm/osm.village.nat_ref.makefile | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'scripts') diff --git a/scripts/osm/osm.village.nat_ref.makefile b/scripts/osm/osm.village.nat_ref.makefile index ffadcf4..cfaf92a 100644 --- a/scripts/osm/osm.village.nat_ref.makefile +++ b/scripts/osm/osm.village.nat_ref.makefile @@ -37,9 +37,9 @@ matched.csv: data/VILLAGE_MOI_1081007.shp village.no_nat_ref.csv ogr2ogr $@ $(word 2,$^) \ -oo X_POSSIBLE_NAMES=X -oo Y_POSSIBLE_NAMES=Y \ -dialect sqlite \ - -sql "SELECT osm.osm_id, gov.* \ + -sql "SELECT osm.osm_id, osm.name, gov.* \ FROM 'village.no_nat_ref' osm, '$<'.VILLAGE_MOI_1081007 gov \ - WHERE osm.name = gov.VILLNAME AND Intersects(gov.geometry, osm.geometry)" + WHERE Intersects(gov.geometry, osm.geometry)" 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,$^)) > $@ -- cgit v1.2.3-70-g09d2