Site preferences of transition metal ions in silicate crystal structures