Full UK Postcode Database

This file contains full UK postcodes along with associated lat/long. With close to 3 million entries, it covers pretty much every UK postcode, and was last updated in November 2009. Here's a sample: 

LS61BL:53.8156817450436:-1.5655622903835
LS61BN:53.8156817450436:-1.5655622903835
LS61BP:53.8147938355912:-1.56860945196983
LS61BQ:53.8129740864632:-1.56255244262109
LS61BR:53.8075863753479:-1.56412726253481
LS61BS:53.8166024690639:-1.57162898755877
LS61BT:53.8157144055246:-1.57467608863725
LS61BU:53.8166024690639:-1.57162898755877
LS61BW:53.8129740864632:-1.56255244262109
LS61BX:53.814804722062:-1.57164731972678
LS61BY:53.815703595631:-1.5716381538915
LS61BZ:53.8157090101945:-1.57315712101653
LS61DA:53.8148101364483:-1.57316625435225
LS61DB:53.8148101364483:-1.57316625435225
LS61DD:53.8148101364483:-1.57316625435225
LS61DE:53.815703595631:-1.5716381538915
LS61DF:53.814804722062:-1.57164731972678
LS61DG:53.815703595631:-1.5716381538915
LS61DH:53.8139004149156:-1.57013758343434
LS61DJ:53.8147992884429:-1.57012838559871
LS61DL:53.813911262566:-1.57317538719233
LS61DN:53.8147992884429:-1.57012838559871
LS61DP:53.8166024690639:-1.57162898755877
LS61DQ:53.8156981618341:-1.57011918726391
LS61DR:53.8139004149156:-1.57013758343434

The cost of this file is £120, which reflects the time spent in compiling and checking it. If you'd like a copy of the database, please contact me at pete@linuxbox.co.uk



UK Postcode Outfield Database

The database (actually a CSV file) contains geographical information for each UK postcode outfield (ie the first part of the postcode), and consists of approx 28,000 entries. It was last updated November 2009. Here's a sample of the SQL file


INSERT INTO postcodes values ("NW5", "Dartmouth Park", "Greater London", "England", "51.552181", "-0.141292");
INSERT INTO postcodes values ("NW5", "Gospel Oak", "Greater London", "England", "51.552181", "-0.141292");
INSERT INTO postcodes values ("NW5", "Kentish Town", "Greater London", "England", "51.552181", "-0.141292");
INSERT INTO postcodes values ("NW5", "Tufnell Park", "Greater London", "England", "51.552181", "-0.141292");
INSERT INTO postcodes values ("NW6", "Brondesbury", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "Brondesbury Park", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "Kensal Rise", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "Kilburn", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "Kilburn Park", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "Maida Vale", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "Queen's Park", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "South Hampstead", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW6", "West Hampstead", "Greater London", "England", "51.552426", "-0.193282");
INSERT INTO postcodes values ("NW7", "Arkley", "Greater London", "England", "51.557112", "-0.202718");
INSERT INTO postcodes values ("NW7", "Mill Hill", "Greater London", "England", "51.557112", "-0.202718");
INSERT INTO postcodes values ("NW7", "Mill Hill East", "Greater London", "England", "51.557112", "-0.202718");
INSERT INTO postcodes values ("NW8", "Abbey Road", "Greater London", "England", "51.535624", "-0.181951");
INSERT INTO postcodes values ("NW8", "Lisson Grove", "Greater London", "England", "51.535624", "-0.181951");
INSERT INTO postcodes values ("NW8", "St John's Wood", "Greater London", "England", "51.535624", "-0.181951");
INSERT INTO postcodes values ("NW9", "Colindale", "Greater London", "England", "51.584491", "-0.260429");
INSERT INTO postcodes values ("NW9", "Edgware Road", "Greater London", "England", "51.584491", "-0.260429");

As you can see, each outfield typically maps to multiple districts/suburbs/towns. The data also contains the latitude/longitude of a point in the outfield, allowing you to calculate the distance between two postcodes (usually accurate to 1 mile or so).

The database was created for use in an online store which has multiple physical stores across the UK, and has been checked for accuracy (and corrections made where necessary) on multiple occassions. We've found it invaluable for attracting visitors from Google: for example, each product in the store had a list of postcodes associated with it (postcodes in which the product is available) and we are able to dynamically translate these into a list of towns/suburbs, which are then shown on the product description page, and ensure we come high in Google results when a user searchs for a product in their town.

The cost of the database is £50. This reflects the time spent in compiling and checking the information in it. If you'd like a copy of the database, please contact me at pete@linuxbox.co.uk

Services

Code

vBulletin

Data

Fun Stuff



linux support email pete@linuxbox.co.uk
(+44) 07890 592198