Licenced Royal Mail Data Reseller









Street/Postcode Flat File

Street/Postcode Dataset

 Delivery Point Flat File

            GIS Base Table

   Sector/Locality Table

New Delivery Point File

    Postcode Gazetteers

            Counties Table




 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

     Data Supplied By....

 

    
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 and now we've added optional county elements. It's construction is based on our Street/Postcode Flat File with additional Delivery Point and Organisation tables linked by a unique Postcode Id/Seq field..

The Delivery Point Flat File consists of the following 3 tables (sample data is available to download in zipped folder containing 3 TAB delimited files with a data layout above):

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 + optional County 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
(Zipped Folder)

 

Last updated:

PAF® is a registered trade mark of Royal Mail Group Ltd

© BPH Data Ltd  2010

Data Release Q10/06