diff options
Diffstat (limited to 'scripts/osm/osm.village.nat_ref.makefile')
-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,$^)) > $@ |