The challenge
Where they started
Following the first phase of its Environment and Net Zero dashboard, WMCA needed to extend reporting across five more areas, each owned by a different team with its own data sources and priorities. Flood risk data came from the University of Birmingham and the Environment Agency, air quality data from DEFRA, low-emission vehicle data from AWS Redshift, and waste and recycling figures partly from manual downloads. Much of this was spatial, so it needed to be mapped at local authority, ward and LSOA level and set alongside deprivation to show where environmental pressures and inequality overlap.