### Makefile ---
N=Orem, Utah address / road name grid
DESC1=using PLSS data.
## Author: Dan Jacobson https://www.jidanni.org/
## Copyright: https://www.gnu.org/licenses/gpl.html
## Created: 2024-03-25T04:06:46+0000
## Last-Updated: 2024-03-25T07:20:19+0000
##     Update #: 50
DB=~/Downloads/UtahPLSSGCDBPoints_7983128980204462126.gdb.zip
arr.csv:orr.csv pid2addr
	./pid2addr $<
orr.csv: $(DB) #Makefile
#	ogrinfo -ro -al -features -dialect SQLITE -sql
	ogr2ogr $@ -dialect SQLITE -sql $(\
	)'SELECT XCOORD,YCOORD,POINTID FROM PLSSPoint_GCDB WHERE POINTID LIKE $(\
	)"UT260060S0020E0___0__0"' $<
f:$(DB); file $<
o:$(DB); ogrinfo $<
U = ../../../../utilities
export PERLLIB = $U
export PATH := $U:$(PATH)
include $U/m1.makefile
SHELL = /bin/bash
$W0.csv:pid2addr; ./$< --points
json:pid2addr; ./$< --$@|json_pp
W=orem_ut
$W.vik:
C= > $@.t && test -s $@.t && mv $@.t $@
D=~/Downloads
B=UtahPLSSGCDBPoints
Q=UtahPLSSQuarterQuarterSections
/tmp/$B.geojson:$D/$B*geojson; ln -s $< $@
$W1.csv:$W0.csv pid2addr; ./pid2addr $< $C
# https://gis.utah.gov/data/cadastre/plss/
# https://opendata.gis.utah.gov/datasets/utah-plss-point-gcdb/explore Yes, want POINTS, not areas!


$W0.csv:/tmp/$B.geojson Makefile
	ogr2ogr \
        -sql "SELECT XCOORD,YCOORD,POINTID FROM $B WHERE \
	POINTID LIKE 'UT260060S0020E0'" /tmp/g.csv $<
	cat /tmp/g.csv | sed 1d | tr -d \" $C
ln_one_time: # Must do to make ogr2ogr read it. Also no symlinks on 9p file system.
	cd ~/Downloads && \
	set -xeu; for i in $$(find Utah*zip -mtime -1|fgrep -v .gdb.zip);\
	do ln $$i $${i/zip/gdb.zip}; done
clean:; rm *.csv