More Electricity Visualization

Peter Rukavina

Cosm, which I’ve been using as the repository for the electricity data I’ve been logging for Prince Edward Island is a great resource, but its graphs are static and not particularly useful for dynamic exploration of data. So I’ve been experimenting with local logging of this data, and then using the Google Charts Tools to visualize the archived data.

The result is this graph, which is dynamic — you can change the time period viewed, and examine anywhere from a minute’s worth of data to a year’s worth (there’s only a week’s worth of data there now, so that’s as far out as you can see as I write this post).

By exploring the graph, you can see how Prince Edward Island’s electricity usage (the “Load” line in blue) over the course of the day and the course of the week. For example, compare a Sunday morning to a Monday morning to see what effect not going to work has on electricity usage. As the archive of data grows, we’ll be able to explore seasonal changes as well.

Comments

Submitted by Neal Gillis on

Permalink

Interested to know: has there been any noticeable change in electricity usage since daylight savings time ended?

Submitted by Peter Rukavina on

Permalink

A good question. Alas I’ve only been locally archiving data for the past week, so I can’t tell you from the local data I have, and Cosm is breaking down when I call for longer-term graphs.


The solution is to use the Cosm API to pull out the several months worth of archival data I have stored there into my local archive; then I’ll be able to answer your question.

Submitted by Peter Rukavina on

Permalink

Okay, scratch that: I was able to use Cosm to look at this.


Take a look at this graph, which shows energy load for the last 30 days; I’ve highlighted November 4, when we switched away from DST for the year. I’m pretty sure Cosm isn’t doing time zone handling properly, so the graph is off by four hours; but it still gives you a sense of the higher peak that happens immediately after that date.


Whether or not that’s due to the switch away from DST, I can’t tell you.

Submitted by Neal Gillis on

Permalink

Thanks Peter. It’d be interesting to map the energy usage data up against weather (wind speed + temperature?) over the winter, since an increasing number of homes are heated with electricity. How does temperature affect electricity usage? Does the energy from wind farms during a nor’easter offset the increased usage on those days?

Submitted by Michael Tawton on

Permalink

Interesting to think of the world circling wave of electricity usage created as sunrise races westward.

Add new comment

Plain text

  • Allowed HTML tags: <b> <i> <em> <strong> <blockquote> <code> <ul> <ol> <li>
  • Lines and paragraphs break automatically.

About This Blog

Photo of Peter RukavinaI am . I am a writer, letterpress printer, and a curious person.

To learn more about me, read my /nowlook at my bio, listen to audio I’ve posted, read presentations and speeches I’ve written, or get in touch (peter@rukavina.net is the quickest way). 

You can subscribe to an RSS feed of posts, an RSS feed of comments, or a podcast RSS feed that just contains audio posts. You can also receive a daily digests of posts by email.

Search