Discussion in 'Website Design' started by murph, Nov 18, 2011.
Anyone got a link to a full postcode mysql database: district, postal town, prefix postcodes?
Nope but I have the UK phone directory in CSV format which has postcodes towns and allows you to do reverse lookups on phone numbers
There's a free one here but may not suit - postcode,x,y,lat,long:
Thanks guys, what I'm ideally after is something like:
prefix prostcode - district - region - x - y - long - lat
I had found one but it's not very complete!
If you have ALL the postcodes, then it should not be that difficult to write a script to push them against Google Maps to the get rest of the info required.
I appreciate that, was hoping someone had a link to a a file already made up. I know they're out there lol. Just tracking it down! Busy with other coding at the mo!! If nothing comes up quickly I'll go your route
Give me 2 minutes.. will see what I can do.
INSERT INTO postcodes values ("NW5", "Dartmouth Park", "Greater London", "51.552181", "-0.141292");
There's also this: http://en.wikipedia.org/wiki/List_of_postcode_districts_in_the_United_Kingdom although no coords
ok .. best I can do for now
To make it mysql just add INSERT INTO postcodes values ( in a new field and ) in last field.
Copy and past and remove tabs.
Separate names with a comma.