When geocoding is used for Canadian addresses, postal code matching fails.

When geocoding is used for Canadian addresses, postal code matching fails.

book

Article ID: KB0081913

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

When creating a map with Canadian addresses, the user is unable to use the postal code as a geocoding table match because our geocoding tables only include the first three characters and not the full six character code.  Users will see an error similar to the following. 

=====
Geocoding Value Mismatch
Some geographic names are not positioned, since they do not exactly match names in the geocoding table.
=====
 

Issue/Introduction

When geocoding is used for Canadian addresses, postal code matching fails.

Environment

Product: TIBCO Spotfire (desktop client / Analyst / Professional) Version: All supported versions OS: All supported Operating Systems

Resolution

Spotfire uses a third party product for the geocoding tables. We only provide the tables that are free, and the full Canadian postal codes are not free.

There are a couple of options available to address this issue. Users can work directly with third party software to get full tables, or work with another source, such as GeoPostcodes (http://www.geopostcodes.com/Canada) in order to build their own Canadian postal codes geocoding table. These options are not handled by TIBCO Technical Support. The user would need to work with TIBCO Professional Services Group (PSG) to build this custom code. One other option is to configure Spotfire to only send the first three characters of the postal code to get a match, however that will be less accurately located on the map. Use an expression similar to:

 

left([PostalCode],3)

 

when setting up the geocoding column matches.

Powered by Wolken Software