Downloads
Data samples and file layouts are available to download from this area......
Delivery Point Flat File Sample Data
Delivery Point Flat File Layout
BPH Enhanced PAF® 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):
-
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.
-
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.
-
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.
Click image to enlarge (3 images)
As an example of the process, if we enter AB10 1AU the application will return the elements - Netherkirkgate, Aberdeen, Aberdeenshire from the Postcode Master Table and then reference the DP Master Table to create a "drop down" list of the 23 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.