adding consolidated data for the environment