The Housing Trilemma, captured in the chart below is based on the following claim:
Every city wants to have a strong local economy, high quality of life and housing affordability for its residents. Unfortunately these three dimensions represent the Housing Trilemma. A city can achieve success on two but not all three at the same time. Underlying all of these tradeoffs are local policies as well.
*image from Oregon Office of Economic Analysis.
Josh put together an interactive chart, both as Excel and a Google Doc. The charts allowed you to toggle between metros and see how they stacked up across ten variables in 4 categories:
Price Income Ratio
Cost Burdened Renters
Working Age Emp-Pop Ratio
Quality of Life
Household Purchasing Power
Housing Unit Growth
Housing Cost Differential
The Excel spreadsheet contained all the data, along with a list of sources, and the percentile rank of each metro across each variable.
The interactive spreadsheet was well done and easy to use, but I thought this might be a good case for a remix. Using animation through tweenr we could compare all the metros at once.
Ultimately, I ended up with the chart below. Let’s build it.