1. How were the rankings calculated?
In short, all cities were assigned a percentage relative to the other 99 cities, and ranked on that percentage. The lowest scoring city (e.g. the city with the highest metric tons of CO2 per capita) receives a 0% and the highest scoring city receives 100%. All cities in between are assigned a proportional score. The city that is assigned a 100% in the green space indicator does not commit 100% of its space to open parks, rather it has a larger share of its city land committed to green space than the other 99 cities. The indicators were weighted and then each city is given a ranking in the sub-index. Then a city’s ranking across all three sub-indices is averaged to give the city its overall ranking.
In more detail, the Sustainable Cities Index is constructed by a three-stage averaging process. Some of the indicators are composites, meaning these take an average of their component sub-indicators. In most cases this is the simple average, however given the importance of housing costs to household spending the affordability index was weighted 70:30 in favor of housing. The three sub-indices are calculated by taking weighted averages of their component indicators and the overall score is calculated by taking the simple average of the three sub-indices.
Even where there is no weighting system applied, since the number of indicators differs across sub-indices, the weights in the overall index do implicitly differ. The same applies for the sub-indicators: two components which go into one indicator will naturally have half the weight of another indicator within the same pillar which has only one component.
The averaging process demands that the scores be converted into common units, for which we use percentages. Each is scaled such that the worst-performing city receives 0% and the best performer receives 100%. Since the sub-indices and the overall index are simply averages of the indicators, they are also measured in percentage terms.
Several of the indicators have outlying values – these are defined as observations two standard deviations away from the mean. These are given the maximum or minimum score, as appropriate, and the next-highest/lowest value is defined as the boundary observation which is used to calculate the scores of the other (non-outlier) values.
City-level data are used wherever possible, though in some cases only national-level data exist. Where there is no comparable city-level data across countries, the national value is taken, and a national database is used to scale the cities so that they are given a spread around the national average.
In 2018 we have revised the calculation of the indices to give greater emphasis to the digital capabilities of cities. We use the adoption of digital solutions as a proxy measure for the pace at which cities are equipping themselves to meet future needs. Connectivity, mobility, citizen engagement and disaster management are all areas where the adoption of new digital solutions will enable cities to accelerate their sustainable development.
Download the report