murph

Anyone got a link to a full postcode mysql database: district, postal town, prefix postcodes?

namestrands

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

__________________

grantw

There's a free one here but may not suit - postcode,x,y,lat,long:

http://www.easypeasy.com/guides/article.php?article=64

Grant

__________________
Domain Brokerage :: Bulk UK Whois :: Property Insurance

murph

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!

namestrands

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.

__________________

murph

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

namestrands

Give me 2 minutes.. will see what I can do.

__________________

murph

Something like:

INSERT INTO postcodes values ("NW5", "Dartmouth Park", "Greater London", "51.552181", "-0.141292");

There's also this: http://en.wikipedia.org/wiki/List_of...United_Kingdom although no coords

namestrands

ok .. best I can do for now


http://www.voove.com/postcodes.csv

http://www.voove.com/postcodes2.csv

__________________

namestrands

To make it mysql just add INSERT INTO postcodes values ( in a new field and ) in last field.

Copy and past and remove tabs.

__________________