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
- https://www.ordnancesurvey.co.uk/opendatadownload/products.html
- 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
Hi, we have downloaded the code-point product and did find the co-ordinates. However, this presentation seems more digestible.
By Free Map Tools on 02/06/2010
Thanks for the update, but which product is it? The code-point list does not contain lat/long coordinates. Thanks again.
On 02/06/2010
Afraid this is outdated now that Ordnance Survey has released a postcode database with lat/long positions for every full UK postcode!
On 02/06/2010
How accurate is the 'Download UK Postcodes with Latitude and Longitude' database.Many thanks.
On 02/06/2010
You'll be pleased to hear that you can now download UK postcodes (GB actually, as Northern Ireland is excluded) and coordinates free of charge from Ordnance Survey under an open source license (similar to Creative Commons Attribution 3.0). Its called Code-Point Open, its been available since April 2010, and you can download it at https://www.ordnancesurvey.co.uk/opendatadownload/products.html
By artemgy on 27/05/2010
UK post codes cam be up to 7 characters (4-char out code plus 3-char in code, usually written with a space between out and in). This list has only the out codes. The coordinates are presumably for the approximate centre of the area covered by the post code, not the location of any particular village; and presumably they come from the Post Office so are to be corrected by them, not here.
The full list of out and in codes is Very Large. The Post Office doesn't publish it, as they charge for access.
By John on 25/05/2010
as far as I know the postal code should have 6 digits but your database seem to miss a few . Don't you have a database with full postal codes ?
By morcovar@aol.com on 16/05/2010
What happened to the list of location post codes I used to use the site as a driving instructor for post codes to advertise my services i and this used to include All NG post codes as a list of towns covered by each post code so i knew which to quote
By Dave on 10/05/2010
Excellent resource. The following appear to be valid postcode zones but are missing:
EC4P
AB24
CM77
By Roger on 30/04/2010
Great list Looking to use it on www.Partyrama.co.uk
By Gareth on 14/04/2010
LN3 5TP should be at 53 13 14.95N
00 17 07.72W
On 13/04/2010
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
Showing the most recent 20 out of 43 comments. Click to see all the comments.
Add your own comment below and let others know what you think:
