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 1.74M full postcodes (out code + in code).
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
Outcode Postcodes Current List : 2974
Full UK Postcode Current List : 1741532
Non Geographic Postcodes
Non geographic postcodes are listed below. Note these will have a latitude and longitude of an empty string
AB99, BT58, CA99, CM92, CM98, CR44, CR90, GIR, IM99, IV99, JE5, M61, ME99, N1C, N81, NR99, NW26, PA80, PE99, RH77, SL60, SO97, SW95, SY99, WD99, WF90
Downloads
Full UK Postcode Latitude Longitude Download
- MSSQL ukpostcodesmssql.zip (32MB zipped, 228MB unzipped)
- Uses a table called [postcodelatlng]
- Script to create table ukpostcodes_tablemssql.sql (1 KB)
- MySQL ukpostcodesmysql.zip (37MB zipped, 234MB unzipped)
- Uses a table called postcodelatlng
- Script to create table ukpostcodes_tablemysql.sql (1 KB)
- CSV ukpostcodes.zip (33MB zipped, 96MB unzipped)
- Header is in the first row : id,postcode,latitude,longitude
Outcode Area Postcodes (AB1,B2,BT7 etc..)
- MSSQL postcode-outcodes-mssql.sql (293 KB)
- Uses a table called [postcodelatlng]
- Script to create table postcode-outcodes_tablemssql (1 KB)
- MySQL postcode-outcodes-mysql (280 KB)
- Uses a table called postcodelatlng
- Script to create table postcode-outcodes_tablemysql.sql (1 KB)
- CSV postcode-outcodes.csv (82 KB)
- Header is in the first row : id,outcode,latitude,longitude
Contains Ordnance Survey data © Crown copyright and database right 2016
Contains Royal Mail data © Royal Mail copyright and database right 2016
Contains National Statistics data © Crown copyright and database right 2016
Using This Data
To import to a web based MySQL database we would recommend BigDump: Staggered MySQL Dump Importer
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
- MySQL UK post code table with corresponding longitude and latitude
- Calculating the distance between a set of postcodes and ranking them in order
Version History
- 19th May 2017 - General Updates. All non-geo postcoces now have an empty latitude,longitude e.g. VALUES (1682513, 'EN77 1AB', '','');
- 4th January 2017 - Updates 54 lat/lng previously set to 99.9,0
- 23rd December 2016 - Updates to data - Remove some instances of ??? O?? (O is letter O)
- 17th October 2016 - Updates to data files
- 11th August 2016 - Updates to B9 4AU, MK11 4AL & DN189AH
- 22nd July 2016 - Updates to SW11 7AS, EX6 9AA, EN77 & WV98
- 16th November 2015 - November 2015 update
- 19th October 2015 - Removed some duplicates
- 23rd September 2015 - Postcode column now has a space in the appropriate place
- 7th May 2015 - Some no loner used postcodes removed. Around 3000 corrections based on feedback
- 29th April 2015 - New update engine in place. Now provides MS SQL and MySQL script
- 5th March 2015 - Added B37 7FP
- 16th July 2014 - Added BB12 7BF
- 9th February 2014 - Added S1 4DE
- 9th February 2014 - Updated Full postcode list. 222 duplicates removed
- 9th February 2014 - Updated Outcode data. SQL script is for MSSQL
- 20th January 2014 - Removed 2 rows of incorrect data. Rows 1699835 and 1699836
- 11th September 2013 - Removed Duplicate BD98 And M60
- 1st August 2013 - Added full postcode list CSV and SQL (SQL insert) format with 1703751 rows
- 15th September 2011 - Added E20 (Olympic Park Postcodes)
- 23rd February 2011 - Added AB24, B99, BB94, BD97, BD98, BD98, BD99, BL11, BL78, BN50, BN51, BN52, BN88, BN99, BS80, BS98, CA95, CF30, CF91, CF95, CF99, CH25, CH26, CH27, CH28, CH29, CH30, CH31, CH32, CH33, CH34, CH70, CH88, CH99, CM77, CM99, CR9, CT50, CW98, DE99, DH97, DH98, DH99, DN55, E77, E98, EC1P, EC2P, EC4P, EC50, EH91, EH95, EH99, FY0, G58, G70, G75, G79, G9, G90, GU95, IP98, KY99, L67, L68, L71, L72, L73, L74, L75, LE19, LE21, LE41, LE55, LE87, LE94, LE95, LS88, LS98, LS99, M50, M60, M99, MK77, N1P, NE82, NE83, NE85, NE88, NE92, NE98, NG70, NG80, NG90, NW1W, OL95, PL95, PR0, PR11, S49, S96, S97, S98, S99, SA80, SA99, SE1P, SL95, SN38, SN99, SS22, SS99, ST55, SW99, TR93, UB18, W1A, WA55, WA88, WR78, WR99, YO90, YO91
- 27th June 2009 - Added NR7
- 22nd October 2008 - Added some Isle of Man and Jersey Postcodes. XLS format is no longer provided.
- 24th August 2008 - Added some new postcodes
- 1st July 2008 - Added List Status
- 10th June 2008 - Added SQL, CSV and XLS formats each with 2821 rows
Comments For This Page
Could you please include postcode town and county as strings in the postcode table?
By Francis on 10th October 2017
Hi Ryan, yes thats correct.
By Free Map Tools on 14th July 2017
is the latitude/longitude the geometric centre of postcode?
By Ryan on 13th July 2017
Excellent! Thank you for you fast response and for excellent dataset!
By Raphi on 22nd May 2017
Raphi, they are free to use. They come with these credits [https://www.ordnancesurvey.co.uk/business-and-government/licensing/using-creating-data-with-os-products/os-opendata.html] and this license [http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/]
By Free Map Tools on 22nd May 2017
Hi, are these datasets free of re-use in a commercial product? Thank you!
By Raphi on 22nd May 2017
No actual streets given.
On 21st May 2017
Hi Robert, yes there are no (little) Isle of Man postcodes. This is something we are looking to get sorted.
By Free Map Tools on 13th April 2017
Brilliant resource, thank you. Seems to be missing IM7 (Isle-of-Man) data. Many thanks, Robert
By Robert on 12th April 2017
James, point taken. Thanks for the feedback.
By Free Map Tools on 5th April 2017
Hi, great site thanks. Is it worth adding an extra bullet point note under the full postcodes files to state that it includes non geographic postcodes and what their long lat values show as?
By James on 5th April 2017
IS there anywhere that provides mapping for historic/discontinued postcodes to their replacement?
By Mark on 4th April 2017
Hi, there is no charge.
By Free Map Tools on 24th March 2017
Is this completely free of charge ? Can I use it for development for my company please ?
By Piotr on 24th March 2017
TW10
On 14th March 2017
Hi, PAF is not free. Is there any free database including door numbers and address details. Thanks
By Afzal on 22nd February 2017
Hi Mark, You can get that database from - http://www.royalmail.com/business/services/marketing/data-optimisation/paf
By Divyansh Saxena on 13th February 2017
Hi Mark, sorry, it doesn't go to this level of detail.
By Free Map Tools on 23rd January 2017
Hi, This is great. is there any that includes door number and street name for all postcodes
By Mark on 18th January 2017
Hi Oliver, there are no limitations apart from the attributions :
Contains Ordnance Survey data © Crown copyright and database right 2016
Contains Royal Mail data © Royal Mail copyright and database right 2016
Contains National Statistics data © Crown copyright and database right 2016
By Free Map Tools on 29th September 2016
Showing the most recent 20 out of 217 comments. Click to see all the comments.
Add your own comment below and let others know what you think:
