Download UK Postcodes with Latitude and Longitude
Download a list of UK out code postcodes with their latitude and longitude coordinates.
Introduction
The UK postal system uses postcodes to help with automating the sorting and delivery of mail. This is made up of a 2-part code, an out code and an in code. As the out code is the most significant part of the system, it can be used to obtain a rough area level break up of the UK. There are approximately 2971 out codes and approximately 1762460 full postcodes (out code + in code). These downloads provide a list of most of the out codes with their associated latitude and longitude.
Purpose
The uses of these out codes and lat/long values include mapping applications such as:
- Rough distance calculation
- Plot the rough location of a postcode on a map
- Simple postcode validation for input forms
List Status
Current List : 2850 Postcodes
Total Possible : 2971 Postcodes
Number of missing postcodes : 121
Postcodes To Add
- None- please let us know about any more!
Unknown Postcodes
- EX25
- EX26
- EX27
- EX28
- EX29
- EX30
- G16
- G17
- G18
- G19
- MK20
- MK21
- MK23
- MK24
- MK25
- MK27
Downloads
- SQL postcodes.sql (112 KB)
- CSV postcodes.csv (100 KB)
Relevant Links
- http://en.wikipedia.org/wiki/Haversine_formula
- http://mathforum.org/library/drmath/view/51879.html
- http://www.movable-type.co.uk/scripts/latlong.html
Version History
- 10/06/2008 - Added SQL, CSV and XLS formats each with 2821 rows
- 01/07/2008 - Added List Status
- 24/08/2008 - Added some new postcodes
- 22/10/2008 - Added some Isle of Man and Jersey Postcodes. XLS format is no longer provided.
- 27/06/2009 - Added NR7
Previous Comments For This Page
Cambridge info i found:
CB21 52.127,0.28244
CB22 52.127,0.13593
CB23 52.215,-0.03011
CB24 52.277,0.08374
CB25 52.260,0.25305
On 11/03/2010
I have an issue with lattitudes and longitude on my tomtom gps in Australia. I can only use the particular co-ordinates for that day only. If I plug in the same co-ordinates the next day I am lost.
Can anyone help me
harshalabharath@yahoo.com
By Barry on 24/12/2009
Could yu please coorect the map location of my village. North Nibey is located on teh road between Dursley and wotton under Edge. It is currently shown about 3 miles to the east located between Dursley and Tetbury
On 29/11/2009
Thank You for Your help
By kandy on 12/11/2009
Thank you for your list. Great work
By Sergio on 21/10/2009
Dr Paul A Daniels, This has now been updated on your original comment.
By Free Map Tools on 06/10/2009
This editor is mangling the input. There should be a 'plus' sign after the first '^2' in place of the space.
By Dr Paul A Daniels on 06/10/2009
The formula given by Nick is wrong; it should be =SQRT((69.1674*(C2-C3))^2+(41.6076*(D2-D3))^2) for the UK. The formula Nick used comes from a US site and assumes a mean latitude of 40deg.
The first constant of 69.1674 comes from the Earth's circumference through the poles divided by 360 degrees and is just a conversion factor from degrees of latitude on the Earth's surface to miles. The second factor, however, is the circumference of the latitude circle (i.e. perpendicular to the Earth's axis) at the mean latitude for the database divided by 360 degrees, i.e. R*cos(lat)/360 (where R is the Earth's mean radius); on the source US website this is a larger value because the latitude circle has a larger circumference at lower latitudes.
This approximate formula considers the lat/long pairs to be on a plane and ignores spherical considerations. This is probably good enough when the points are close together but will be less accurate calculating the distance from, say, New York to Bombay (or even Plymouth to Aberdeen). The 27% difference in the second constant would mostly show when the distance between two places on similar latitudes was being calculated.
By Dr Paul A Daniels on 06/10/2009
Interesting - as a REAL novice, tried the formula in Open Office (Excel, why?)from Nick's posting using these data, and got distance = 0 miles when it's around 7 ?? 52.612000° -2.480000° 52.512000° -2.480000°
By Peter on 06/10/2009
Thanks Elliott for the distance calc in Excel. However, you made a typo and missed out a ' '. The working rule for anyone else struggling should be: =SQRT((69.1*(C2-C3))^2 (53*(D2-D3))^2)
As an excel novice I pasted the CSV postcode data into a 2nd sheet in my XLS file, and used VLOOKUP's to locate the corresponding lat/lng values. For example, I lookup the postcode entered in cell A3 on sheet 1 in my sheet labelled 'Postcode' as follows:
=VLOOKUP(A3,Postcode!B2:D2853,2,FALSE)
This looks at the whole table of data and returns column 2 when a match is found to match identically. Good luck fellow excel noobies :)
By Nick on 24/07/2009
A very useful file. I've used it in Excel with a macro that will find the distance from a single source postcode to all the other postcodes listed. Missing: NR7 - NORWICH [Sprowston, Thorpe St. Andrew, Heartsease] = (52.642606, 1.335567) and Missing: PH37 - GLENFINNAN [Glenfinnan, Polloch] = (56.816195, -5.528405)
By DM on 05/05/2009
It would appear that the OX6 postcode area no longer exists and is now in other areas (ox28 to name but one). How often is the db updated?
On 28/04/2009
Hi, this is fantastic help. Can anyone talk me through creating my own map with this, ideally to create a radius of each postcode? thanks
By Kelly Elsworth on 14/04/2009
This is a really useful database. Thanks for providing. By the way, what is your source for this data?
By Dave on 02/04/2009
Doing the calculation in excel is simple (I did this 3 years ago! - Outcode only). Happy to send a copy to anyone that wants it (It also maps the post code onto a map).
Email me at david (dot) rignall (at) gmail (dot) com
I did write a macro to do a full post code map but it's too slow.
By Dave R on 18/03/2009
Hi, many thanks for the for postcodes! For those needing an Excel formulation for distance that's a close approximation, use the below:
=SQRT((69.1 * (C1-C2))^2 (53 *(D1 -D2))^2)
Where C1 and C2 are your two latitude cells and D1 and D2 are longitude. To find out where the 69.1 and 53 came from, go to: http://www.meridianworlddata.com/Distance-Calculation.asp
Seems accurate enough, I put the postcodes in Google Maps to check the distance and selected the new 'walking' option - obviously though Google will plot the best road/path to take not a direct line so you would expect it to be slightly more!!
Now I need to convert to an ASP loop to find all postcodes within a certain radius :)
By Elliott on 05/03/2009
PH37 is missing from the range
By Matthew on 16/02/2009
distance = square-root ( (Xb-Xa)2 (Yb - Ya)2 )
that is the formula for calculating distance between 2 codes
By Marty on 07/02/2009
I have managed to get the lat and lon values for every outcode I have but need a full list of outcodes can anyone help?
By Paramiliar.com on 06/02/2009
For the Excel question:
=ACOS(SIN(lat1)*SIN(lat2) COS(lat1)*COS(lat2)*COS(lon2-lon1))*6371
Richard: Correct, they are for the IOM. Google Maps/Earth now supports IMX postcodes so this data is easy to collect.
By Sharry on 22/10/2008
Showing the most recent 20 out of 32 comments. Click to see all the comments.
Add your own comment below and let others know what you think:
