"quite amusing and drastically geeky at the same time"
Saturday, February 19, 2022
UK postcode data update
I've uploaded the latest ONS postcode data to my website. The data has passed my sanity tests, but let me know if you spot anything amiss. The CSV downloads now include a UPRNs column, which is a comma separated list of the UPRNs in the postcode
2 comments:
Nick
said...
Hi, These files are really helpful but since the new UPRN coloumn Im having lots of problems loading into sql db using the import function as MS seems to have problems with the commas in the uprn field even if they are quoted
I've adjusted the CSV downloads so you can add &uprn=false on the end to prevent UPRNs being included. If you let me know where you're downloading them from I'll add links for the non UPRN versions
2 comments:
Hi, These files are really helpful but since the new UPRN coloumn Im having lots of problems loading into sql db using the import function as MS seems to have problems with the commas in the uprn field even if they are quoted
I've adjusted the CSV downloads so you can add &uprn=false on the end to prevent UPRNs being included. If you let me know where you're downloading them from I'll add links for the non UPRN versions
Post a Comment