Not just sparklers.

Last week I helped the fine folks over at MassLive put together a map of all the fireworks displays in the Pioneer Valley on and around July 4.

I compiled all the data and threw it on a spreadsheet with some very basic HTML, and then, from my understanding, MassLive put it through a magic Internet machine and, hey presto, it’s a fireworks map.

This is what it looked like before:

13973083

And here’s the after:

fire

Tags: ,

This rant was rambled on Tuesday, June 30th, 2009 at 6:51 am and is filed under Graphics, Web. You can follow any responses to this entry through a series of tubes to the RSS 2.0 feed. Make your mark, or hit the streets from your own site.

2 Responses to “Not just sparklers.”

  1. Jeff Says:
    July 8th, 2009 at 2:11 am

    This is one of my favorite tricks. It essentially makes Google Spreadsheets into the roughest content manager system ever.

    What’s going on here: information is entered into the spreadsheet, the speadsheet is then published automatically as a .json file, which is interpreted by javascript and overlaid on a map all on page load. There are other, better ways to do this, but they require php and interpreted languages interacting with the Google API, and those methods aren’t available on the MassLive servers (which are tuned for heavy load and raw HTML serving more than nimble execution of dynamic languages).

    So hideously convoluted javascript it is.

  2. S.P. Sullivan. Media. Dot com. And so on.» Blog Archive » Mapping photos with Flickr. Says:
    February 13th, 2010 at 11:11 am

    [...] think I’ve made it abundantly clear that I really love [...]

Leave a reply

Spam Protection by WP-SpamFree Plugin

What's that? I can't hear you - type it in that box up there.