Page Comparison

...

Geocoding feature is used to convert customer/supplier address data into geographical coordinates that can later be used for data visualization on a Map chart. This feature can be used in any Hansaworld HansaWorld data cube for which customer (CUVc) register is imported.

...

Geocoding is used to link customer addresses to longitude and latitude values. 

• Add the following code to your config/eazybi.toml file:

  Anchor
  step2 step2

  Code Block
  [[regular_jobs]] job = "Geocoding.perform" every = "24h"

  Specify a new regular job Geocoding.perform and the frequency for execution of this job. In the code example below, a frequency of 24h is set. You can specify a value that corresponds to your needs.
  
  

• Add the following code to the [general] section of your config/eazybi.toml file:
  

  Code Block
  tomtom_api_key = "<your_tomtom_api_key>" tomtom_base_URL = "api.tomtom.com" tomtom_version_number = "2"

  
  In the code block above, you have to replace <your_tomtom_api_key> with your actual TomTom API key. Also you have to check if the defined version is the current version of the API.
  
  

• Define the following plan parameters in the Update Account section's Plan parameters box of your flex.bi account:
  

  Code Block
  enable_geocoding = true min_address_precision = 8 min_address_similarity = 0.85

  You can also use the following plan parameter, to enable debugging mode and log geocoding errors:

  Code Block
  debug_geocoding = "error"

  
  

• min_address_precision is the minimum geocoding result precision that is required to save the latitude and longitude values. The default value is 8, but you can increase it, to make the rules for result acceptance more strict, or decrease it, to make the rules less strict. The precision is a value returned by the TomTom service together withe the geocoding results, which specifies how precise are the returned results based on the TomTom algorithm.

• min_address_similarity is the minimum similarity between the original address and the address returned from the geocoding service. The default value is 0.85, but you can increase it, to make the similarity rules more strict, or decrease it, to make the rules less strict. The similarity is a value calculated by comparing the address saved in flex.bi and the results returned from the TomTom geocoding service.

...

To get the missing geocoding data, you have to check the previously mentioned properties and the customer/supplier properties used for geocoding (street, city, geocoding_needed, inv_addr2, inv_addr3, inv_addr4, country_code) and make the necessary changes either in the precision and similarity limits or customer/supplier address data. 

...

Likewise, if you feel that the geocoding results stored are not precise enough, you can increase the minimum address precision an and similarity limits (see step 2).

...

Improving Customer/Supplier Address Data In

...

HansaWorld

If no geocoding results are returned for a particular customer/supplier or the results are not precise enough, this can be caused by missing, incomplete or wrong address data in HansaWorld. As mentioned before, Geocoding uses all of the following customer/supplier properties: street, city, inv_addr2, inv_addr3, inv_addr4, country_code, so these are the values that you should check and improve if necessary. The following are some basic tips for checking and improving address data in HansaWorld:

• Check if the complete address data (street + city + inv_addr2 + inv_addr3 + inv_addr4 + country_code) gives a precise result in a maps search engine like Google Maps. If not, try to add/omit something, until you get the result you need.
• Make sure that the complete address data constitutes a full address containing country, street name, building number, zip code, region name, district name etc.
• Remove any information not related to the address, for example, name, phone number etc.
• Remove any information that you would not give to a taxi driver, like the name of a building, floor number, name of an office etc.

After fixing some address data in HansaWorld, you have to reimport this data in flex.bi and wait for the next scheduled geocoding run, for the changes to take effect.