A Day in the Life: Geocoding! (aka Mapping)

Posted by

I work for University of Iowa Healthcare (all opinions always my own), and I love that I get to work with all sorts of departments from across the institution. Generally, my work is focused on operational analysis. I enjoy this, as it’s a strong suit of mine, but it does mean that I rarely have opportunities to map data.

I recently started working on a high-level project for senior leadership, with the goal of telling our story to a broader audience. A big part of that story is that although we are physically located in Iowa City, we serve the entire state of Iowa. This is because we’re the only Tertiary Care center in the state. To put it simply, whenever someone in Iowa gets too sick for their local hospital, they get transferred here. We really are a resource for the whole state of Iowa (and beyond).

Getting to this blog entry’s point, what this means is… Maps!

Maps!
The reason I even started writing this entry was because of this graph I created accidentally in my data flow:
1 Appointment Volumes Map (Non-Iowa)

I love how this emphasizes our regional (and national) impact. Also, as a design nerd, I love that it includes an image of Iowa via white space. I think this visualization may be an important part of the narrative, but we’ll see whether it makes the cut, as we’re still early in the project.

To skip ahead to the punch line, here is where I eventually ended up:
2 Appointment Volumes Map

I don’t normally love labels, and when I do use them, I tend to use one or two. In this case, however, the visualization is intended for PowerPoint decks, meaning you can’t rely on hover texts.

A technical aside…
One technical point worth mentioning is how I addressed the color scale. Though we serve the entire state, we do have more visits from Johnson County (where we’re located). If I just used a straight color scale, it wouldn’t be all that informative:
3 bad color scale

To get around this, I set up a table calculation that takes the 95th percentile of the volumes for all of the counties, and uses that as a ceiling for the color scale:
4 calc

There is an argument to be made that this is misleading, but I think the narrative intent behind the visualization (e.g. the story being told) warrants this design choice.

Short entry this time, but I hope you found it useful, interesting, or ideally both! Until next time…

Jeff

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.