'At-Risk' Post Office Outlets Mapped

last update:
Yorkshire area
http://mapperz.googlepages.com/yorkshire_post_offices
_at_risk_name.html

Outreach Post Offices Planned (replacing these Post Offices)
http://mapperz.googlepages.com/outreach_post_offices_named.html

data from...
http://news.bbc.co.uk/1/shared/bsp/hi/pdfs/02_10_07_po_total.pdf
so if that is wrong so will the location on the map

update:
Midlands is Mapped now.
http://mapperz.googlepages.com/Midlands_post_offices
_at_risk_named.html
*Starkholmes, 133 Starkholmes, Road Matlock E4 5JA was not mapped due to an incorrect postcode.

Kent 'at-risk' Post Office Outlets Mapped

"The Post Office has announced the first 180 branches earmarked for closure under its plan to shut 2,500 by the end of next year."

based on the pdf on the BBC website - Mapperz mapped them. In 15 minutes
http://news.bbc.co.uk/1/hi/uk/7023244.stm


How was this done so quick?

• Copy and pasted addresses and postcodes from the PDF into notepad, save as .txt

• Rename as .csv

• Open this in OpenOffice (or Word) as comma delimited.

• Adjusted the Postcodes into one column

• Copy and pasted to a batch geocoder

• Appended the lat/lng to the Post Office 'at risk' in OpenOffice

• Saved as .xls

• Uploaded to google spreadsheets (view the spreadsheet)

• Published this as 'public' (will not work if your don't)

• Used the google maps/spreadsheet wizard
  

*to create the link between the spreadsheet and google map via the Public Spreadsheet Key.
**the wizard does do a lot of things, icons sizes, colours, viewport, map extent based on data.
The Mapperz modified a little html to make the map centre on Europe before zooming to the Kent era.

View the 'At Risk' Post Offices in Kent Map

Mismatched postcodes with the geocoder
Kent had one Postcode that was incorrect replacing the 'I' for a '1' worked.
TN13 IHZ should be TN13 1HZ