Glasgow is the host of the COP26 Climate Conference and also the only non-EU city that took part in the survey