Model the station metadata to include both responsible member state from the ICOS member state table and the country location of the station (if it is a fixed station) from the UN list of 251 countries. Good place to get table of countries and iso codes, geojson and shape data is https://hub.arcgis.com/datasets/esri::world-countries-generalized/explore?location=1.666601%2C-156.639144%2C2.54. Data should be consistent over all domains. Now domains have different tables and ecosystem table is inconsistent (UK/GB, lists DRC as resposible country etc.
Model the station metadata to include both responsible member state from the ICOS member state table and the country location of the station (if it is a fixed station) from the UN list of 251 countries. Good place to get table of countries and iso codes, geojson and shape data is https://hub.arcgis.com/datasets/esri::world-countries-generalized/explore?location=1.666601%2C-156.639144%2C2.54. Data should be consistent over all domains. Now domains have different tables and ecosystem table is inconsistent (UK/GB, lists DRC as resposible country etc.