Looking for full UK postcode database

[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

 

[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_postcode_districts_in_the_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.

 

[murph]

Nice! The second is same but with less info per postcode?

 

[namestrands]

Yes one is basic other has country region etc

 

[murph]

Hm having spot of bother with excel. I need to add doubles quotes around each field??

 

[murph]

No matter, find n replace in notepad sorted it! Cheers

 

[namestrands]

you could always just use PHP to parse it and dump into MySQL

fgetcsv if I remember.

 

[murph]

All sorted, used the first one as the district/county etc info more useful. Just realised the lat/long is rounded on this, but not important...can always find that data later and amend db!

Many thanks mate!

 

[namestrands]

(ok)

 

[namdas]

I used this API for a client and found it very good - its pretty cheap too, I think <1p per lookup if I recall correctly : http://www.postcodeanywhere.co.uk/ - can get full addresses from it.