US address mapping
InfoSum Platform lets you map US postal addresses in a source data file to the USA Address category in the Global Schema.
Mapping US postal addresses to the Global Schema has a number of advantages:
- Three keys will be generated after normalization (USA address, Zip9 and Zip5).
- Combination keys are created for US postal addresses (for example, address + name).
- US addresses can be entered in various formats.
Note: US address mapping is only available for US East Bunkers.
The street address mapping that you can access is based on your InfoSum plan. This is because not all InfoSum Platform features come as standard - please contact sales@infosum.com for details.
Validating
InfoSum verifies that the US address is valid and complete.
Normalizing
When normalizing US addresses, address line 1, 2, town and state is hashed to generate three keys: USA address, Zip9 and Zip5.
Mapping US addresses to the Global Schema
Supported formats
You must always provide US addresses in raw format. Values are required in either:
- street name, city and state fields, OR
- street name and zip code fields.
The following Zip formats are supported by InfoSum Platform:
- Zip9 is accepted in two formats: 01740-1329 or 017401329
- Street name is required along with Zip code. The Platform cannot map or normalize Zip code on it's own without a street. Both Street name and Zip code are required to validate an address.
- City and State are not mandatory values.
- If an address has a Zip5, InfoSum Platform creates a Zip9 key.
Steps
Go to the Platform, create a Bunker in a US East region and upload your dataset.
In preview settings, check that the source data file contains the address details.
You can perform some other optional minor manipulations to the source data here, please see this article for information.
Click the Accept Preview Config button, then New from the Create a new config box.
Check that your source columns for US addresses are correctly mapped to the Global Schema categories as shown in the table below.
|
Your Column |
Global Schema Category |
Map to property |
|
City |
USA Address |
city |
|
State |
USA Address |
state |
|
ZIP code |
USA Address |
zip_code |
|
Plus four ZIP code |
USA Address |
zip_plus4 |
|
3rd line of address |
USA Address |
address_line3 |
|
House Number |
USA Address |
house_number |
|
Street |
USA Address |
street_name |
|
2nd line of address |
USA Address |
secondary_address_line |
Select ACCEPT WIZARD SETTINGS. A unique ID is generated for each US Address.
US addresses can be entered in various formats. The addresses in the table below are in different formats, but both will map to the same address.
|
House Number |
Street |
|
250 |
Hartford Avenue |
|
<null> |
250 Hartford Avenue |
The Global Schema creates a ‘USA Address hashed’ key and combination keys for USA Address and any categories such as Name that cannot be used as a key in their own right, for example, ‘Fullname:USA Address hashed’ and ‘Forename:USA Address hashed’. You can view all keys created for USA Address in the Keys tab of the Normalize section of your Bunker:
If name or date of birth is in the source data, the Platform automatically combines this data with USA Address to make a combination key.
Click the Normalize button and then click the Publish button. The USA Address keys are now available on the Platform for the published dataset.