Sheffield stink pipes -> https://geojson.io/#id=gist:alifeee/60e121a4b55ce1069b003e1d94f0e046

sheffield-stink-pipes.csv

sheffield-stink-pipes.geojson

sheffield-stink-pipes.md

Search for all Sheffield stink pipes on Historic England's website:

https://historicengland.org.uk/listing/the-list/results/?search=sewer&searchType=NHLE+Simple&facetValues=facet_ddl_countyDistrict%3ASheffield%3AcountyDistrict%7C&page=1

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
while read url; do curl -s "${url}" | awk '/data-os-grid-ref/{getline; a=$0; print gensub(/ /, "", "g", a)}' >> gridrefs.txt; done <<< $(csvtool format '%(3)\n' NHLEExport.csv | awk 'NR>1{print}')
dos2unix gridrefs.txt
# convert Grid References to latitude/longitude
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 git@github.com:pvernier/csv2geojson.git
(cd csv2geojson/; go build main.go)
./csv2geojson/main NHLEExport.csv