DS =\
-dsco NAME="Dr. A. Santos Ave., Parañaque, Philippines addresses" \
-dsco DESCRIPTION="See $(subst $(HOME)/,https://www.,$(PWD))"
### Makefile ---
## Author: Dan Jacobson https://www.jidanni.org/
## Copyright: https://www.gnu.org/licenses/gpl.html
## Created: 2025-02-24T02:00:52+0000
## Last-Updated: 2025-02-27T21:01:24+0000
##     Update #: 103
##
# https://overpass-turbo.eu/?Q=%7B%7BgeocodeArea%3APara%C3%B1aque%7D%7D-%3E.q%3B%0Anw%5B%22addr%3Ahousenumber%22%5D%5B%22addr%3Astreet%22%7E%22Santos%20Ave%22%5D%28area.q%29%3Bout%20geom%3B
d=~/Downloads
f=$d/santos.geojson
P=dr_a_santos_ave
v:$P.vik
%.vik:%.kmz; viking $<
#We got house outlines(w:way), and address points (n:node), from our Overpass Turbo OSM query.
#Let's make them all into points for easier mapping:
raw.csv:$f Makefile
	ogr2ogr $@ $< -lco GEOMETRY=AS_WKT -lco STRING_QUOTING=IF_NEEDED -dialect SQLite -q -sql \
	'SELECT "addr:housenumber" AS name, ST_Centroid(GEOMETRY) AS "WKT" FROM $(notdir $(basename $<))'
filtered.csv:raw.csv
	perl -F, -anwle 'if(/WKT/){print;next}; if($$F[-1] =~ /8\d{3}/){print "$$F[0],$$&"}' $< > $@
$P.kmz:filtered.csv
	ogr2ogr $(DS) -f LIBKML $@ $< -q -sql \
	'SELECT name FROM $(basename $<)'
clean:; rm *.csv