Thought I would post this here as it's hopefully interesting to other Drupal developers! Recently we launched a website for the Crafts Council, with a party in the House of Lords, no less... It's basically a data visualiation which shows the result of a survey they conducted as part of their Craft Matters campaign. The objective of the campaign is to show the importance of craft in the UK and the site is being used as a mechanism for demonstrating public interest when the Crafts Council apply for funding.

We used a customised version of Webform to create the main submission form. We also had to migrate around 4000 offline submissions that were provided to us in Excel format, so we built a small Ruby script to upload the raw data in to the database in 'webform' format. We then built a module to geocode submissions based on the postcode provided (this is done on-the-fly for new submissions, so that the user can see their submission on the map straight after submitting). Obviously we couldn't reveal the precise locations of the responses on a public site like this, so the geocoding is at a town-level granularity. Another module was developed to perform text analysis on submissions and highlight sentences that said something specific about craft.

The main animation and heatmap pages are done with jQuery.

Our case study is here, although it doesn't include much technical detail:

http://wemakewebsites.info/content/crafts-council-craft-matters

The site itself is here:

http://www.craftmatters.org.uk/

Thanks for reading,

Alex