I Speak for the Champion Trees

Answers to the two most common questions about champion trees: 1. Yes, there are actually quite a few people who enjoy measuring big trees. 2. A champion tree is the largest of its species based on this formula:

Champion Tree Points = Height (ft) + Circumference (in) + 1/4 Canopy spread (ft)

The data for this map is curated by the nonprofit American Forests and is a compilation of data from state champion tree lists. I first got interested in champion trees when I came across the Atlanta list; now I appreciate trees more when walking through my local neighborhoods and parks. Some of the national champions on the American Forests list have pictures too- click on a tree in the map to get an image link. Two of my favorite images are the Giant Sequoia and the Western Red Cedar.

Champion Giant Sequoia

Champion Western Red Cedar

I've heard the phrase "in it for the right reasons" more than once when talking to people who are into measuring big trees. I'm still not sure what that means. 

I also noticed from the linked pictures that big tree measuring seems to be a very male-dominated activity.

The graph below gives some additional context around champion trees. California has the most champion points and largest tree, while Florida has the most individual champions. (The map above only shows champions with at least 270 points, but the graph below includes all champions, including species that are quite small.) Eight states don't have any champions- Arkansas, Delaware, Nevada, North Dakota, South Dakota, Rhode Island, Wisconsin, and Wyoming.

To learn how the champion tree map was built in Tableau, see this post.

Champion Tree Map: Dynamic Custom Shapes and Web Scraping

This blog post serves as a "how-to". For a more general post about the champion tree map see here.

This is the closest I've come to a "Pimp my Viz" submission. For a moment I thought two different graphical representations of tree shape was too crowded for one dashboard, but I like them both too much. Here's how I got there.

The Data: American Forests

The nonprofit American Forests has over 700 champion tree pages- one for each tree. I used import.io, a free web extraction tool, to collect the American Forests data. This was a two step process- first use their extractor tool on their tree search page to get a table of all of the champion trees and their URLs. I then trained the extractor tool on individual tree pages and fed it the URL table to get a data set of all champion trees and their dimensions.

Screenshot of training import.io on a tree page.

One drawback of the resulting data set is the location data is somewhat inconsistent. Some locations are a county, some a city, and some a national park. I didn't know an easy way to deal with this, so I looked up the latitude and longitude for the largest 240 trees by hand. This was relatively quick on latlong.net and took me about 90 minutes.

Dynamic Custom Shapes

I made my first tree map a few months ago using Atlanta data and circles for each tree. I avoided tree shapes the first time because I thought it would look chart-junky. But this time I figured out how to make the tree shape proportional to the actual height, canopy size, and trunk width of the tree, so each image adds unique information.

How can we display all these unique tree shapes?!

Tableau custom shapes are easy to implement, but are designed for dimension variables- a different shape for each discrete value. They can vary in size on one continuous variable, but I wanted my trees to vary in size with respect to three independent dimensions- height, trunk, and canopy. To add a second size dimension, I created a bin on the height to canopy ratio, and assigned different-sized canopy images to each bin. To add a third size dimension, I used a dual axis map and did the same thing for trunks that I did for canopies. By assigning images based on the height to trunk and height to canopy ratios, I was then able to make the overall image size proportional to height, and all three variables are in correct proportion to each other and other trees. (I actually used height^1.6 as the size variable to get the proportions right- because the image size scale is based on area, not height.)

Canopy image for .5x height to canopy ratio.

Canopy image for 3.5x height to canopy ratio.

The two images above are examples. The top was used for trees whose total height is half the width of the canopy, and the bottom was used for trees with a height 3-4 times greater than the canopy width. Note that both PNG images use the same size canvas so Tableau will size them correctly when scaling for height. Both images leave space for the trunk at the bottom too. This keeps the trunk and canopy from overlapping on the dual axis graph. (I used the same image size for the trunk and kept them on the bottom half.)

A sad clear cut and weird green clouds- the workbook before selecting dual axis.

Tree Graph Bar Graph

I like the tree map, but their scattered locations and small size makes it hard to really compare different trees. So I added the "tree graph bar graph" at the bottom. To make this graph, I created a dual-axis bar graph, with one series of graphs for the canopies, and on for the height. I then played with the axes settings to make the trunk stand out below the canopies.

Tree graph before selecting dual axis

Final Touches

Final touches included a highlight action from the graph to the map, a dynamic sort on the bar graph, and background color for both the map and the bar graph. I usually keep backgrounds white to keep focus on the data, but in this case I enjoyed using colors consistent with nature.