Visualization of U.S. Electricity Generation via the EPA’s eGRID Dataset

I’ve been using the data visualization software package called Tableau for a while now. It is really a fantastic product, with lots of online tutorials and help. It even has a free one-year student edition! Below is my attempt to show how power is generated in the United States. The data comes from the EPA’s eGRID data set, with 2009 being the most recent data. It is a geographic bubble chart with the amount of energy produced at each plant represented by its size, and the fuel source for that energy by the bubble’s color. I’ve used some transparency to help with the overplotting. Even so, many points close together are hard to distinguish. I added a dark border to each bubble to help with that.

eGRID Annual Net Generation Data by Fuel Type

I’ve also used a horizontal bar chart as a legend, and it includes the percent that came from each source. So you can see that we get the largest percentage of our fuel from coal, at 45.2%, and the least from solar, with less than 0.0% (the actual value is 0.03%). The box on the lower right is the average annual plant production for each type of fuel. Note that this is different than the average plant size (its ‘nameplate capacity’). Production refers to how much energy was actually produced during the year, capacity refers to how much power could be provided at any particular time. If all plants operated all the time (24/7) the distinction wouldn’t matter, but all plants have some downtime, like for maintenance, or when the wind doesn’t blow for wind power.

Have any comments, ways it could be improved, or would you like to see a subset of the map, say with just a single component highlighted, just let me know!

Update: Because I couldn’t help myself, I went ahead and made the individual plots as well:

eGRID Map - Coal Constant Scale eGRID Map - Gas Constant Scale eGRID Map - Nuclear Constant Scale eGRID Map - Oil Constant Scale eGRID Map - Hydro Constant Scale eGRID Map - Wind Constant Scale eGRID Map - Biomass Constant Scale eGRID Map - Geothermal Constant Scale

The images below are rescaled to show each type of fuel individually and the other washed out power plants were removed. Be careful comparing them to the first map (with all fuels shown together) as the bubbles are very different scales.

Coal power plants from the EPA's eGRID data set Nuclear power plants from the EPA's eGRID data set Gas power plants from the EPA's eGRID data set Hydroelectric power plants from the EPA's eGRID data set Wind power plants from the EPA's eGRID data set Biomass power plants from the EPA's eGRID data set

Creative Commons License
Visualization of Energy Production in the United States using the EPA’s eGRID Dataset by Steven C. Isley is licensed under a Creative Commons Attribution 4.0 International License.

This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

3 Responses to Visualization of U.S. Electricity Generation via the EPA’s eGRID Dataset

  1. Daniel Maycock says:

    I’d do a time series to demonstrate the decrease and increase of certain fuel times over time

  2. Isley says:

    You can see the Columbia river project very clearly. So, why does the government say that the hydro from the Columbia isn’t renewable energy? Not if it is over 20 MW. Does this go thur all the environmental data, or just WA state data. I will have to look one of these days.

  3. steveisley says:

    Dan, I would love to do that, but the data’s limited. There’s also data for 2004, 5, and 7, so I couldn’t go back very far.

    Isley – I think hydro is generally considered renewable when making statements like, “X% of power from country Y comes from renewable sources” but they might change the definition in places like Washington where they are trying to encourage non-hydro renewable sources of power. Including hydro, Washington clocks in at nearly 75% renewable. See this: for the EPA’s official stance, hydro=renewable.

Leave a Reply

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

You are commenting using your 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