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 - Street/Postcode Dataset
The Street/Postcode Dataset is derived from the Thoroughfare PAF® containing approximately 1.8 million postcodes, with separate tables for Post Town, Locality and Thoroughfare names.

 

Below are extracts from the 4 relational tables which constitute the Street/Postcode Dataset, they have been "colour coded" to demonstrate how the address is built. Further down the page are File Structures and Notes. If you wish to try the data, there are downloads to the right of this page.

 

Postcode Master Table

Outcode       Incode        Seq.No.      Type         PostTown       Locality          Street1        Street2    DP Count

  
  This builds into the following address:
The Green (Dependent Thoroughfare)
Berrymuir Road  (Thoroughfare)
Portlethen (Locality)
ABERDEEN     (Post Town)
AB12 4UN  (Postcode)

Thoroughfare Names Table

  

 Locality Names Table

Post Town Names Table

 

 File Layouts & Notes  
The following file structures and corresponding notes are available in PDF format. Additionally, there is a set of sample files from which the above extracts were taken. Please download both and discover how simple it is to construct fully validated addresses.

 

POSTCODE MASTER TABLE

 

 

Postcode - Outcode

4

) 

Postcode - Incode

3

)  Pointer to Delivery Point Master Table

Postcode Sequence No.

1

)

Postcode Type

1

   L= Large User, S= Small User, s= Small User Duplicate entry

PostTown Key

4

  Pointer to Town Names Table

Locality Key

5

   Pointer to Locality Names Table

Thoroughfare Key

6

   Pointer to Thoroughfare Names Table

Dependent Thoroughfare Key

6

   Pointer to Thoroughfare Names Table
Delivery Point Count

3

    No. of Addresses (Delivery Points)

Total

33

 

 

POST TOWN NAMES TABLE

 

 

Post Town Key

4

   Index

Postal Area

2

  

Town Name

22

   Upper Case Text

Postal County Name

18

    Mixed Case Text

County Flag

1

   R/N/S

Country Code

1

    E/S/W/N

Total

48

 

 

LOCALITY NAMES TABLE

 

 

Locality Key

5

   Index

Locality Name

50

   Mixed Case Text

Total

55

 

 

THOROUGHFARE NAMES TABLE

 

 

Thoroughfare Key

6

   Index

Thoroughfare Name

50

   Mixed Case Text

Total

56

 
 


Downloads

 

 

 

 

 

 

 

 

 

 

 

 

Street/Postcode Dataset Sample File

 

 

 

Street/Postcode Dataset File Layout & Notes

 

Last updated:

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

© BPH Data Ltd  2008

Data Release Q08/12