In July 2019 we reported on the challenge facing the UK to meet official recommendations to plant 30,000 hectares of trees every year as part of a target of eliminating carbon emissions by 2050.
We used data from the Forestry Commission and Forest Research on annual tree planting rates in the UK and the total amount of government funded trees planted in England between 2010 and 2018.
The story also involved the use of automation to generate dozens of shorter summaries of the story for different parts of the country. Some of these were used in BBC Local Live pages, and some were supplied to broadcast journalists to give an overview of the picture in their region.
The liveblog for Devon and Cornwall, for example, includes an update about Torridge, one on West Devon, one about East Devon, another about South Hams, the Isles of Scilly, and another about Exeter figures
- Forestry Commission: New planting of trees supported by the Rural Development Programme for England, and other forms of Government support: Report for April 2010 to September 2018 - data tables and version copied here
- CSV: Tree planting by year and nation, 1976-2019
- CSV: Tree planting by year and nation, 1976-2019 (long)
- CSV: Tree planting by region and BBC area, 2010-2018
- Ewa Kmietowicz, transport and agriculture team leader, Committee on Climate Change (CCC)
- Andy Howard, runs a company that finds places for new woodland
- Stuart Goodall, chief executive, Confor (represents the forestry and sawmilling sector across the UK)
- Spokesman, Department for the Environment, Food and Rural Affairs (Defra)
- Steve Marsh, the Woodland Trust
- Dr Jennifer Allan, lecturer in environmental politics, Cardiff University
- Histogram: Tree planting rates in the UK, 1976-2019
- Choropleth map: New trees planted per 1,000 population, 2010-2018
- Bar chart: 10 areas with the highest number of new trees planted between 2010-18 per 1,000 people
Rob England later created this Flourish bar chart race which was not used in the story.
A small part of the automated output (aggregating numbers by station) was generated by this Python script