Google maps: Wedgwood creditors

I've finally managed to get my Google Map of the creditors of Wedgwood working, after a bit of work to get the feed right.

Admittedly, it's four weeks later than I had hoped, but today has been the first chance I've had in a while to have a play with Yahoo Pipes.

To be honest, I'd already done the hard part in ripping the list of creditors out of a PDF document and then plonking them into a Google spreadsheet.

Once that was tidied up, I simply sucked in the data as a CSV file, renamed the company and balance outstanding columns as title and description - for RSS feed - and then thought I'd correctly used Yahoo Pipes' geographic tools (e.g. the rename tool) to create the necessary bits for a working GeoRSS feed. Seems I was wrong.

It would appear that although the tags for longitude and latitude can be geo:lat and geo:lon, neither Yahoo Pipes or Google Maps recognise this as GeoRSS. Instead they have to be renamed geo:lat and geo:long.

Then all you need to do is run the location extractor on the feed that's emerged and hey presto you get something that Pipes and Google Maps can use, like so:

View Wedgwood Creditors in a larger map

Admittedly, it's not all the creditors - although that seems to be as much to do with the limits of Google Spreadsheets in handling 900 different firms.

What is interesting is the cluster of firms around Stoke-on-Trent who got caught out by the company's collapse.

The next thing I'm trying to do is use Yahoo Pipe's text manipulation tools to make the information more presentable. At the moment, the description tag contains just a number to represent the balance outstanding, when really it could do with a phrase like "Balance outstanding:". It would also be great if I could swap the pointers for something a little more easy on the eye.

Any suggestions