Add alpha 2 code for Switzerland Cantons about ems-file-service HOT 4 CLOSED

The region codes in your data are missing the two letter country code (e.g. CH-VD, CH-ZH). The full ISO code for regions is required to maintain distinctiveness when multiple region maps are displayed on a dashboard. For example, Germany and Switzerland both have subdivisions with the two letter code "BE".

This blog post shows an example of data similar to yours and how a scripted field can be used to construct the correct ISO code from documents in Elasticsearch provided that the documents also have a country code field.

from ems-file-service.

@nickpeihl: can we consider an option for an alpha2 only code which is the common way to denote cantons in Switzerland? This used to work in 6.x releases... (typically combined with a filter query on the country to „avoid“ ambiguity) (similarly for the united states map, where it is is also possible to just use the alpha2 state abbreviations like CA,NY etc)?

from ems-file-service.

@dschneiter This sounds reasonable to me. For example, the US States layer has an extra field for the two letter postal codes (e.g. CA for California, NY for New York). Some other countries include statistical codes (ex. cut-code for Chile, logianm in Ireland).

Do you have a suggestion for the name of the field? Postal code?

from ems-file-service.

Nope, postal code/zip-code is a different concept. It's about canton codes (which are language-independent). So whether it is about "Zürich" (German) or "Zurigo" (Italian) it's always "ZH". It's the identifier which we also use on car plates and in all statistical data available from the Swiss government. I will do some investigation whether we do have a standardized name to reference that field (Canton Code is my suggestion).

After consulting ISO and commenting #121 I would suggest ISO 3166 Canton Code (not sure what's your naming guideline with respect to plural and singular)

from ems-file-service.