@camjstark asks how our map today rearranging Canada in a system of 14 provinces of roughly equal population was made:
@pcaintoronto Will we be treated to one of your thorough methodological explanations at some point? Interested to see how you did it!
— Cam Stark (@camjstark) February 19, 2013
It was pretty low-tech – it’s just the 2006 FSA population tables, divided up in Excel. Each province was supposed to have roughly two million people, so I ran a running total downward*, hoping that a geographically logical stopping point met each point where the total got up to two million or so. It occurred to me late in the process that I could use Pivot Tables to check these.
Then I pasted colour hex values in by notional province, saved it as a .csv, uploaded it to Fusion Tables, merged it with a .kml of the 2006 FSA boundaries and had a look. The FSA system is often but not all that precisely tied to geography (not very precisely, in the L-series postal codes in the 905), so it needed a couple of cycles of being corrected visually. The Fusion Tables map turned out to look better with border opacity set to 0, in other words invisible.
(This is, in fact, as much fun as you can have with a set of population tables.)
* =SUM(B2:B158), then =SUM(B159:281) and so on