Repository of ISO region codes for geo maps

This guide contains a repository of CSV files with the ISO region codes for various countries. ISO region codes are required to create certain types of geo map widgets.

Introduction

To display a metric value in a region on a geo map, Adverity needs a dimension containing ISO region code data. The ISO region codes are added to a data extract using a mapping table and a transformation script. Use one of the ISO region codes CSV files from the repository below to populate a mapping table. For more information on populating a mapping table table with these ISO region codes, see Creating a mapping table that contains ISO region codes.

If you cannot find the ISO region codes CSV file for the country you wish to display in a geo map widget, contact the Adverity Account Management team and request the creation of the required CSV file.

Repository of ISO region codes CSV files

Search for the country to display in a geo map widget and click on the hyperlink to download the CSV file containing the ISO region codes.

All countries in the world can be displayed on a geo map widget. This global geo map requires the following ISO codes to display the countries.

World ISO Country Codes

Once you have downloaded the CSV file containing the ISO region codes, create a mapping table that adds the ISO regions codes to a data extract. For more information, see Creating ISO region codes for geo maps.

Finding alternative names for region

mapping tables find source values in your data and map these source values to target values. When searching for source values, mapping tables look for an exact match for the value provided in the Match column. As a consequence, small differences in region names may cause mapping tables to fail and not match the regions to ISO codes.

Small differences in region names may cause mapping tables to fail and not match the regions to ISO codes.

For example, the Austria region Wien may not be found in a data extract because the data source uses the English name, Vienna, for the region.

Also, the Latvian city of Riga may not be found in the data extract because the data source uses the Latvian spelling of Rīga.

Both of these issues can be solved using regular expressions within the Match column of the ISO region code mapping table.

For more information on how to edit a mapping table, see Editing mapping table entries.

See the regular expression examples below for potential solutions when finding alternative names for regions.

Regular expression example	What the regular expression is looking for
`/Wien\|Vienna/`	Looks for either Wien or Vienna.
`/(w\|Wien\|(v\|V)ienna/`	Looks for Wien or Vienna and ignores case.
`/^(r\|R)iga\|^(r\|R)īga/`	Looks for region names that start with Riga or Rīga, and also ignores case. This regular expression would also find region names such as riga city or Rīga (capital)