Uk Post Codes And Areas
I have a list of all UK postcodes with postal town, latitude and longitude.
I want to extend this in 2 ways – drilling up one level and down one level
Up
I want to link the postal town to the county it comes from and add the county number ( all counties already established with ID numbers.
Down
I want a table of all the names of towns which fall within each postal code with one field for the name, and other fields to merge in all the other data to add postal town, postcode, latitude, longitude.
As an example.
I have all postcodes in this format
“postcode”,”district”,”x”,”y”,”latitude”,”longitude”
“M28″,”Manchester”,373700,402100,53.51,-2.39
Using available online resources I have found
M28 Boothstown Greater Manchester
M28 Walkden Greater Manchester
M28 Worsley Greater Manchester
Where Greater Manchester is the county and there are 3 towns associated with M28
The resource I used is http://www.firstaidcafe.co.uk/PostCodes/postcode.asp
But this produced ‘No results” for some postcodes such as AB1 – there may be better resources available. You must source these
For reference, this is the type of use I want the data for
http://readysteadyvillas.com/search_new.php
I prefer the Results to be supplied as a functioning sql file