Licenced Royal Mail Data Reseller



 


 Home
About BPH POSTCODES

 Data Products

Street/Postcode Flat File
 Street/Postcode Dataset
Sector/Locality Table
 GIS Base Table
 Postcode Gazetteers
 Counties Table
 New Delivery Point File
 Delivery Point Flat File

Data Support
Pricing & Licences

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

    
BPH  Enhanced Postcode Data - Delivery Point Flat File

If you really want the full works, the Delivery Point Flat File contains all 28 million (approx) UK mail delivery points and includes organisation names in addition to property names, numbers and sub-buildings. It's construction is based on our Street/Postcode Flat File with additional Delivery Point and Organisation tables. Additional data such as OSGR Easting/Northing, Lat/Longs or administrative area codes are available as separate tables linked by the Postcode Id/Sequence field.

The Delivery Point Flat File consists of the following 3 tables (sample data is available to download in a multi-tab excel file together with a data layout):

1. POSTCODE MASTER TABLE - A table structured as per the Street/Postcode Flat File with the addition of Postcode Id/Sequence field linking Street, Locality, Town and Postcode data to the other tables.

 
 

2. DELIVERY POINT MASTER TABLE - Using the link field this table contains details of all delivery points in each postcode. If we look at the first entry on the Postcode Master Table, AB10 1AU contains 23 delivery points. Within these 5 have organisation details which can be identified by the Org Flag and accessed using the link field and Delivery Point Suffix.

 

  
 

3. ORGANISATIONS TABLE - contains Organisation Name, Department and PO Box information for those records identified by the Org Flag. Access is via the link field and DPS.

 

  
  For an example of the process, if  we enter AB10 1AU the application will return the elements - Netherkirkgate, Aberdeen from the Postcode Master Table and then reference the DP Master Table to create a "drop down" list of delivery points. As 5 of the 23 entries have the Org Flag set, then the process accesses the Organisation Table using Postcode Id/Sequence + DPS to build, for example, Holland & Barrett Ltd, 49.  


Downloads

 

 

 

File Layout PDF

 

Delivery Point
Flat File Sample

 

Last updated:

PAF® is a registered trade mark of Royal Mail Group plc.

© BPH Data Ltd  2008

Data Release Q08/09