What is an Address Profile?

Edited

In other countries address cleaning is a simple concept. There is an accepted official version of an address, and the cleaning process is simply to match that address and overwrite the input address with the official address in order to correct any errors in the input.

There is no official address database in Ireland. People living in the same street, townland, or even house may write their address very differently. In the absence of an official address database, everyone is entitled to their own opinion of how to write their address barring obvious errors. Take the example of people who live on the following road in Dublin:

Percentage

Address Line 1

Address Line 2

Address Line 3

Address Line 4

75%

Woodlands Road

Dun Laoghaire

Co. Dublin

22%

Woodlands Road

Cabinteely

Dublin 18

3%

Woodlands Road

Rochestown Avenue

Dun Laoghaire

Co. Dublin

0%

Woodlands Road

Glenageary

Co. Dublin

75% of addresses we encounter for Woodlands Road are written as Dun Laoghaire, Co. Dublin, with the remaining 25% covered by the other two cases. The difference in the choice of the description of the address is referred to as a ‘Vanity Address’. The final version of Irish addresses is the An Post version. We have never encountered this version. It is the nearest address format that could be described as “Official” and is the version included in the Eircode Address Database. The address cleaning we apply to the input address attempts to preserve all of the “vanity” aspects of the input address. It also corrects for errors and inserts missing address elements. The example below illustrates this approach:

INPUT

Woodlands Road

cabintely

Dublin 19

OUTPUT

Woodlands Road

Cabinteely

Dublin 18


We corrected the misspelling of Cabinteely and a wrong or missing Dublin Postal District.  However, we do not replace the input address with the most common version of that address, in this case, “Woodlands Road, Dun Laoghaire, Co. Dublin.”

We provide output flags to indicate where the address cleaning has been corrected

  • a spelling,

  • a format change or

  • an altered address

It is important to note the changes that we make to your input data as it may need to be reviewed by you before re-importing to ensure it complies with your internal policies and systems.

Address cleaning is only half the process; the second stage is to reformat the address so that it can be saved to your backend CRM or database. We do this by using an Address Profile that defines the constraints and requirements needed to match your system. An Address Profile has the following definitions: 

  • Number of Address Lines

  • Field widths (Maximum characters allowed)

  • What can go on each line (e.g. House Number)

  • Required Fields (e.g. Town or County)

  • Capitalise (UPPER, lower or Proper case)

  • Substitutions (e.g. Special characters)

The default Address Profile we use has five address lines, with Town and County fields as follows:

Address Label

Description

Width

Required Field

Address Line 1

The first line of address could be a business or Organisation name

100

No

Address Line 2

The second line of address if it exists

100

No

Address Line 3

The third line of address if it exists

100

No

Town

City, Town, Village, or Urban Area if it exists

100

Yes

County

County, if it exists in the address

100

Yes


Note:
Required fields are filled first, then the rest of the address is filled from top to bottom (Address Line 1 to Address Line 3).
A Business name will appear in Address Line 1 if it is part of the address. This can be moved to a separate Address Line if required. The example below demonstrates how an address is populated using our standard Address Profile.

Address Label

Description

Width

Required Field

Address Line 1

24 Woodlands Road

100

No

Address Line 2

Rochestown Avenue

100

No

Address Line 3

Dun Laoghaire

100

No

Town

100

Yes

County

Co Dublin

100

Yes

Town and County

It is important to note that even if you have a required Town and County field, this does not guarantee that they will always be populated for the following reasons:

County

It is standard practice when writing an address with a County town that the County field is blank so as not to duplicate the County name (e.g., rather than Carlow, Co. Carlow). In the example below we return Example 1A version of the address rather than Example 1B.

Address Label

Example 1A

Example 1B

Address Line 1

Carlow College

Carlow College

Address Line 2

College Street

College Street

Address Line 3

Town

Carlow

Carlow

County

Co. Carlow

In the standard Address Profile, we put Dublin Postal Districts into the County field.  However, some customers prefer it to be populated in the Town field. In this scenario, the County field will be blank (e.g., rather than Dublin 9, Co. Dublin). In the example below we return Example 2A version of the address rather than Example 2B.

Address Label

Example 2A

Example 2B

Address Line 1

Pine View

Pine View

Address Line 2

The Thatch Road

The Thatch Road

Address Line 3

Whitehall

Whitehall

Town

Dublin 9

Dublin 9

County

Co. Dublin


Note: We can populate the County field if required as per Example 2B above.

Town

Not all addresses contain a town, which is a surprise to most people.  If the Dublin Postal District is in the County field, then the Town field will be blank for many addresses. Some addresses simply do not have elements to fill each field, e.g., O’Connell, Dublin 1. Other addresses may have omitted a locality from the address; therefore, we cannot append one, e.g., Woodlands Road, Dublin 18.

There are two standard approaches to dealing with this issue,

  • pull in the next available address line or

  • duplicate an already existing address element

The examples below illustrate this. They represent how someone would complete an online form when challenged by a required Town field. 

Address Label

Example 1

Example 2

Address Line 1

IRISH LIFE GROUP

IRISH LIFE GROUP

Address Line 2

Beresford Court

Beresford Court

Address Line 3

Abbey Street Lower

Town

Abbey Street Lower

Dublin 1

County

Dublin 1

Dublin 1



Note: 
We can ensure the Town field is always populated using either of these two approaches if required.

The Address Profile attempts to reformat and fit the entire address into the required number of address lines. If the address does not fit, we will apply abbreviations:

  • Street » St

  • Apartment » Apt

  • Road » Rd

  • Industrial Estate » Ind Est

If it still does not fit, we may be forced to drop an element from the address. We analyze the address and remove the most superfluous element of the address, as highlighted in the examples below:

Example 1

Example 2

Example 3

IRISH LIFE GROUP

Mercury House

Cois Abhainn

Beresford Court

Ravens Rock Road

Ballynaclash

Abbey Street Lower

Sandyford Industrial Estate

Clashmore

Dublin 1

Sandyford

Youghal

Dublin 18

Co. Cork


 We return a REFORMAT RESULT field so you can clearly see what we have done to the address, such as truncating an address line or dropping an element of the address in order to fit it into the profile.

REFORMAT_RESULT

COUNT

%

100 Success

101 Address Element Truncated

102 Address Element Lost

103 Address Element Lost and Truncated

110 Address Element Abbreviated

TOTAL



Note:  We can craft a specific Address Profile to suit your exact needs.