ARRA funding map

by Ben Sheesley on April 30, 2009

ARRA Funding Map

Lots of maps are coming out that document when, where, and how stimulus money is being spent through the ARRA, like these at the Foundation Center. With all of the reporting, accountability, and transparency required of ARRA grant recipients, I’m sure we’ll only be seeing a lot more of these in the future. Recovery.gov directs traffic to states’ Web sites where some of this data is appearing. I’m looking forward to seeing more and more mash-ups and interactive maps and graphics as developers and designers get their hands on this stuff and data from other sources that track stimulus money.

Our Map

For now, we decided to get involved by putting together a static map that shows where our ARRA tax dollars are going for energy-related programs administered by the DOE. As underlying layers, the map shows states’ historical energy consumption trends and their projected trends required to meet consumption goals set for 2012.

I’m sure we could all talk about the politics around ARRA funding and energy consumption and how this might or might not be shaped by patterns that the map does or doesn’t show. But to me, a few of the most interesting things about this map are related to its design:

1) Encoding data in state boundaries

I’ve always been attracted to National Geographic political reference maps, with their countries each outlined in a different color. On those maps, outline color clearly helps distinguish one place from another. Plenty of other maps use enumeration unit outlines to represent data, too, like those that categorize administrative boundaries using line weight, dashes and dots, etc. I wondered what was to stop the application of this idea to a thematic map? Why not try to take it one step further and encode numerical data, as opposed to nominal data, in unit outlines? I haven’t seem many examples of this.

The main limitations here are line weight and unit size. Line weight has to be heavy enough so that color can be seen and read. For my map, this seemed to work best above around 4 pts. Only thing is, as enumeration units get smaller, the outline can eat up more interior space and obscure the presence of a second data set, which in this case is the historical energy consumption trend, encoded using unit fill color. So, I had to cheat a little bit with some small states and states with small pieces (e.g., Delaware and Maryland) and decrease the line weights a bit under 4 pts. I don’t see this approach working very well with really small enumeration units like US counties, unless the map scale is really huge.

2) Color selection

The challenge here was to select colors for three data sets (historical energy, projected energy, and ARRA money) that not only encoded data properly but were harmonious (i.e., not competing or ugly). The historical energy data set has a natural midpoint around zero, so it needed a diverging color scheme. On the other hand, the projected energy data, having no midpoint, required a sequential scheme (thanks to ColorBrewer 2.0 for both sets of specs). Proportional rings for ARRA money just needed to be readable and look nice on top of the other colors.

Here are some earlier attempts at getting color right. In my first try, I used a grayscale sequential ramp for the historical data (state fill color), matching the middle value to the map’s background for a pseudo-diverging ramp feel. But this seemed overly subtle and downplayed the importance of clearly distinguishing states with decreasing and increasing energy consumption trends.

First attempt at color.

First attempt at color.

So, my next try was to replace the grayscale ramp with a true diverging ramp. Yuck. The mix of red outlines and fill colors bothered me on an purely aesthetic level. Other diverging ramps with other hues in them produced similarly ugly results.

Second attempt at color

Second attempt at color.

The final colors for historical energy consumption trends (blue-white-red) seem to best emphasize the data’s midpoint, with red doing its part to connote “alarm” in the states with a poor track record. The projected energy consumption data set is now lower down in the visual hierarchy (shown using a grayscale color ramp on state outlines), but this seems to be acceptable compromise. Using gray prevents these two ramps from competing for attention or overlapping and confusing the map reader. From my perspective, at least, it also results in an (yes, subjective) improvement in overall color harmony.

Other thoughts about the ARRA funding map? Please add them to the comments.

There are 6 comments in this article:

  1. April 30, 2009Daniel Huffman says:

    Well done and attractively presented.

    I am, actually (without being able to see more than your small clip of it), more of a fan of putting the states in greyscale and the state borders in color. I think that, since so much less ink is devoted to them, they need something to give them greater visibility. As they stand now, it takes more mental processing to pick out the pattern – much more than it does to assess the pattern for the main fill, the annual % change. I think that desaturating the colors (maybe not even all the way down to grey) of the state fills and giving more color to the stroke will help this out.

    I might also suggest putting a thin non-thematic border between all the states to define them better. Looking for example at Arkansas, it looks like it has a border at the top that is twice as thick as everywhere else. This is just because it happens to border MO, which has the same color border, whereas the other surrounding states don’t. But when those things happen it gives a feeling of an inconsistent border width.

    Also, I like the part where the upper edges of the US poke into the title bar.

    Just some off-the-cuff thoughts. I like it, though. I am a fan of data-dense maps with multiple layers of symbology, and also of dark color schemes.

  2. May 1, 2009ben says:

    Hey Daniel-

    Thanks for your comments. I like these suggestions, and agree that the pattern in the state outlines could be made more visible. Perhaps, as you say, decreasing state fill color saturation and adding a bit of color back to the outlines could help. I’ll definitely give it a try.

  3. May 1, 2009Jon Peltier says:

    Nice. It took me a moment to realize the color scheme had nothing to do with Dems and Reps. Still have that election mindset in my subconscious, I guess. The attempt at layering is ambitious, but I think the borders should not be counted on to provide the same level or quality of information as the interiors. If the borders had a color scheme more similar to the interiors, it might be easier to compare them.

  4. May 12, 2009Richard Treves says:

    Nice experiment. I agree with Ben that non-thematic boundaries as well as boundaries would work well. I would have gone for expanding up the East coast States in a separate magnified box myself. Overall though I think its a very usable way of presenting 3 variables on one thematic map.

    Rich

  5. June 23, 2009Where are all the dollar$ going? at SweetMaps says:

    [...] such map about DOE (Dept. of Energy) projects was made by ace cartographers at Axis Maps in Madison Wisconsin.  This illustrates various techniques for communicating data on a static [...]

  6. January 8, 2011Where are all the dollar$ going? « SweetMaps says:

    [...] such map about DOE (Dept. of Energy) projects was made by ace cartographers at Axis Maps in Madison Wisconsin.  This illustrates various techniques for communicating data on a static [...]