see more maps on https://alifeee.co.uk/maps/
Search for all Sheffield stink pipes on Historic England's website:
Then, add data and convert to geojson
View on https://geojson.io/#id=gist:alifeee/60e121a4b55ce1069b003e1d94f0e046
get coordinates
# download CSV from
# https://historicengland.org.uk/listing/the-list/results/?search=sewer&searchType=NHLE+Simple&facetValues=facet_ddl_countyDistrict%3ASheffield%3AcountyDistrict%7C&page=1
mv ~/Downloads/NHLEExport.csv .
# fetch OS Grid References
rm gridrefs.txt; while read url; do curl -s "${url}" | awk '/data-os-grid-ref/{getline; a=$0; print gensub(/ /, "", "g", a)}' | tee -a gridrefs.txt; done <<< $(csvtool format '%(3)\n' NHLEExport.csv | awk 'NR>1{print}')
dos2unix gridrefs.txt
# convert Grid References to latitude/longitude
pip install osgridconverter
while read GRID; do python3 -c 'from OSGridConverter import grid2latlong; l=grid2latlong("'"${GRID}"'"); print(f"'"${GRID}"',{l.latitude},{l.longitude}")'; done < gridrefs.txt > coordinates.csv
# add CSV header
awk 'BEGIN{printf "OS Grid Reference,latitude,longitude\n"} {print}' coordinates.csv > temp.csv
mv temp.csv coordinates.csv
dos2unix *
# combine CSVs
paste -d"," NHLEExport.csv coordinates.csv > temp.csv
mv temp.csv NHLEExport.csv create geojson with csv2geojson
# build binaries
git clone [email protected]:pvernier/csv2geojson.git
(cd csv2geojson/; go build main.go)
./csv2geojson/main NHLEExport.csv