This instant download contains every UK Postcode (circa. 1,791,296 Postcodes) and the Postcode’s associated X & Y Coordinate as well as their Longitude & Latitude. In addition, we include a list of circa. 892,441 ‘Retired’ postcodes that are no longer used by Royal Mail. The product files are updated quarterly to ensure they remain current, and our clients receive an inclusive complete refresh every three months as part of the service, for no additional fee. Output file formats include Comma Separated Variable (CSV), Microsoft Access and Excel.
The Postcode Coordinates data is ideal for relating Postcodes and address information to their geographic location or to check if a postcode is still valid, or formatted within your database correctly. The data is therefore essential for analysing:
Three file formats are available (Comma Separated Variable (CSV), Microsoft Access (ACC) and Microsoft Excel (XLS)). The CSV version consists of two text files with header records and will open in any common application including SQL, Word, MS Access and MS Excel. Initially you receive one ZIP compressed file that when unpacked will reveal three files: (1) GRD-FLL-UK-CSV-1 containing all live Postcodes from Postcode Areas AB to LN (901,222 postcodes); (2) GRD-FLL-UK-CSV-2 containing all live Postcodes from Postcode Areas LS to ZE (890,074 postcodes); (3) GRD-FLL-UK-CSV-Retired containing all circa. 892,441 Retired Postcodes.
Fields presented in the files:
The Postcode Coordinates data covers the United Kingdom (England, Scotland, Wales and Northern Ireland).
The majority of grid references are derived from the Ordnance Survey product OS MasterMap that contains grid references for each address. Newly introduced postcodes initially have a grid reference that has been imputed by ONS Geography. In due course these are replaced by improved OS MasterMap grid references which use data supplied by Ordnance Survey’s field surveyors. The grid references provided for Northern Ireland postcodes are derived from the LPS ‘Pointer’ product and use the Irish National Grid system that covers all of Ireland and is independent of the British National Grid. These are then converted to the British National Grid system to ensure consistency across all Postcode records in the file.
The degrees latitude and longitude are calculated from the 1 metre grid reference by converting the easting and northing to numeric and then one point shapefile is created for GB using the ‘BritishNatGrid’ coordinate system and another for Northern Ireland using ‘Ireland 1965.ING’. These files are then projected to GCS_WGS_1984, using an OSGB_1936_to_WGS_1984_Petroleum transformation for GB and a TM75_to_WGS_1984_2 transformation for NI. Latitude and longitude are then calculated from the resulting x and y co- ordinates.
No geographic coordinates are provided for postcodes in the Channel Islands and the Isle of Man.
If present, the most recent occurrence of the postcode’s date of termination in the form YYYYMM (year and month), otherwise: null indicates a ‘live’ postcode. Postcodes are terminated by Royal Mail for various reasons but most commonly it is due to the demolition/re-development of buildings or to postcode reorganisations. Terminated postcodes are occasionally re-used by Royal Mail but not usually before an elapsed period of two or three years. In such circumstances, all terminated postcodes and their grid references are retained and a ‘retired’ date is added which provides a clear indication of a postcode’s status.
Downloads are supplied as licensed products, allowing unlimited reuse of the file content for 12 months. You may cancel the licence at any time without penalty. The licence fee you pay covers the considerable effort taken to compile and update the product, including our manual correction and verification, and finally verification against the latest Royal Mail and Ordnance Survey databases. On or before the 11th month, we will write to you, offering to extend the licence for a further 12 months or to let it expire.
As part of the fee paid, we will automatically send you a full product file refresher every 3 months for no additional fee. This will ensure the postcodes and associated content remains current.
We have developed internal quality processes to help ensure the data you purchase is fit for purpose. If you are for some reason not satisfied with the data or our work, we offer a no quibble refund in exchange for your feedback.
£179.00 – £599.00 / year
Instant Download: A link to the data, is emailed upon payment. We will also email a link to the updated version of this file every three months (included in the fee you pay).
Only logged in customers who have purchased this product may leave a review.
There are no reviews yet.