diff options
| author | typebrook <typebrook@gmail.com> | 2019-11-18 15:18:50 +0800 |
|---|---|---|
| committer | typebrook <typebrook@gmail.com> | 2019-11-18 15:18:50 +0800 |
| commit | 56c24f398714b9594085eb85be38e90d24b5b49d (patch) | |
| tree | 01bce1841b920758765759353c22c4e3b84c77e4 | |
| parent | cc036aeb915a7a282a66fe21f9b30668336b6c96 (diff) | |
update
| -rw-r--r-- | scripts/osm/osm.village.nat_ref.makefile | 4 |
1 files changed, 2 insertions, 2 deletions
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 | |||
| 37 | ogr2ogr $@ $(word 2,$^) \ | 37 | ogr2ogr $@ $(word 2,$^) \ |
| 38 | -oo X_POSSIBLE_NAMES=X -oo Y_POSSIBLE_NAMES=Y \ | 38 | -oo X_POSSIBLE_NAMES=X -oo Y_POSSIBLE_NAMES=Y \ |
| 39 | -dialect sqlite \ | 39 | -dialect sqlite \ |
| 40 | -sql "SELECT osm.osm_id, gov.* \ | 40 | -sql "SELECT osm.osm_id, osm.name, gov.* \ |
| 41 | FROM 'village.no_nat_ref' osm, '$<'.VILLAGE_MOI_1081007 gov \ | 41 | FROM 'village.no_nat_ref' osm, '$<'.VILLAGE_MOI_1081007 gov \ |
| 42 | WHERE osm.name = gov.VILLNAME AND Intersects(gov.geometry, osm.geometry)" | 42 | WHERE Intersects(gov.geometry, osm.geometry)" |
| 43 | 43 | ||
| 44 | matched.by_nat_ref.list: village.with_nat_ref.csv village.gov.csv | 44 | matched.by_nat_ref.list: village.with_nat_ref.csv village.gov.csv |
| 45 | join -t',' -1 5 -2 1 <(sed 1d $<) <(sed 1d $(word 2,$^)) > $@ | 45 | join -t',' -1 5 -2 1 <(sed 1d $<) <(sed 1d $(word 2,$^)) > $@ |