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.

Global Obesity: We're Getting Bigger

The visual above shows global obesity rates and their changes since 1990. The storyboard explains that the US has seen large obesity gains since 1990, but trends have reversed (slightly) in recent years. I suspect that the fitness industry is finally having a larger impact than the junk food industry on our waistlines. This could also explain why the child obesity rate continues to tick up: fitness marketing is rarely aimed at children.

The data also show that almost every country has seen an increase in obesity rates in the past 25 years. Although the US is on the high end, several countries in the middle east and Oceania have higher obesity rates. Use the filters to explore the data on the last slide- switch between adult and childhood obesity, include overweight in the statistics, or find a specific country or region by clicking on the lists.

Source data is re-purposed from this visualization by the talented Ramon Martinez, and is originally from Institute for Health Metrics and Evaluation available here. 

Students Referred to Law Enforcement

This data was originally published as a series of bar graphs by The Center for Public Integrity. The graphs are supported by compelling individual stories, including an autistic sixth-grader charged with felony assault.

Thanks to Ben Wieder of CPI for sharing the data.

Public Transit: All About Density

I grew up outside of a small town of about 8,000. If we wanted to go anywhere other than the local crick we needed to drive. Imagine my surprise when I was 14 and visited Montreal: a massive subway system and underground malls! Big city folk had a whole different lifestyle.

Now I live in Atlanta and drive everywhere.

My experience in Atlanta isn't unique. See the graph below, which shows average daily usage of all public transit in a city. (You can filter to a specific type in the bottom right.) New York City has more than twice the per capita public transit usage of any other metro area. Most metros have less than 0.1 daily trips per person. Those trips are unlinked (i.e. a transfer counts as another trip) and don't count return trips, so in most metros less than 5% of the population uses public transit on a given day.

Learn About Tableau

This leads people to say, "the public transportation in city X sucks". We've all heard it. But look at the graph again. New York City has twice the transit usage of any other city, but is also more than twice as dense (denoted by color). Why does this matter? Based on average density, in New York City 6,100 people live within a quarter mile of each metro stop¹ while 430 people in Atlanta live within a quarter mile of each metro stop. Also, the alternative (driving) is much worse in a denser city. Traffic may not be great in Atlanta, but its far worse in a city with 15 times the density.

So, how does Atlanta's transit stack up when controlling for density? See the graph below. Atlanta is one of the least dense big metros in America, but compared to similarly dense metro ares, Atlanta has a high rate of public transit usage. For example, observe Jacksonville which also has a little more than two thousand persons per square mile. Jacksonville has about 0.03 daily trips per capita and is right on the trend line (the average for similarly dense cities). Atlanta has over twice the usage of Jacksonville.

Learn About Tableau

This visual is full of other fun information. Washington DC and Boston are the two biggest public transportation over-achievers. Los Angeles, even though it has more public transit than most metros, is one of the biggest under-achievers, along with San Jose and Riverside. Click on the Los Angeles circle to see that nearly all of their public transit comes from bus, or click on the orange segment of the US map to see that western cities fall into two distinct trends of public transit vs. density.

The last visual gives us an idea of how a city's transit use is changing. Raleigh has more than doubled their transit use in the past twelve years, but their current rate (as represented by color-coding) is only 0.02 per capita, so the actual increase was slight. Scrolling down the graphs and looking for color outliers shows that Salt Lake City, Seattle, and New York City all had impressive gains in metro use.

Learn About Tableau

Atlanta's public transit use declined by 9% over the past twelve years and was the only city to see a decline in heavy rail usage. Where does this put Atlanta going forward?

This post is about public transit, but what really matters is quality of life. I don't actually drive everywhere; I live in the Old Fourth Ward and can walk to great coffee shops and parks. I have a ten minute driving commute to my office downtown. Atlanta's Beltline project and related push for mixed use development should make a lifestyle of walkable neighborhoods and short commutes accessible for more people. And as that happens I expect Atlanta to grow in density and public transit.

Notes

• All population information is from the 2010 census, and uses population-weighted density to be more meaningful. 
• Transportation data is from the American Public Transit Association, available on their website. (See the monthly data)
• The APTA uses urbanized areas (UZAs) to report usage, while I only had population-weighted densities for metro areas, which sometimes encompass multiple UZAs. I was able to merge the two with a name crosswalk, but did have to look up a few by hand.
• I suspect a reporting error in the 2002 APTA data for Austin. Their drop is entirely from 2002 to 2003, and in privately provided public busing.

---

1 Calculations are totally based entirely on average population-weighted density, and not on actual stop locations.↩