Better organize your address data.

Unfortunately, many organizations with legacy databases store large text blocks of address data in their systems (ie. an “Address” field). However, best practice is to elementatize the data and store it as precise components. There are several reasons for this, including an improved ability to validate and match the data. If you’re working with block data, Cleanlist can help you make the transition to proper elementization.

Address Elementization separates your street address data into its individual components: street name, civic number, unit number, street suffix, street type, and street direction.

Benefits

  1. Properly elementized addresses are essential for better matching and accuracy.
  2. Allows you to easily sort your data and identify neighbours.
  3. Easier to maintain and validate your data with properly separated addresses.
  4. Improves your ability to perform services like route planning and optimization.

Fields Appended

Field
Name
Length
Description
UNIT_NUM
20
Unit Number
ST_NUM
20
Street Number
ST_NUM_SFX
10
Street Number Suffix
ST_NAME
60
Street Name
ST_TYPE
20
Street Type
ST_DIR
20
Street Direction