Which data is used to determine whether a substation is classified as green, amber, or red?

This information typically comes from the headroom rating provided by the data provider. The exact source can vary depending on the DNO, as each one supplies data slightly differently. In some cases, we also carry out our own calculations based on the available data.