In 2010 I worked on a very interesting project for the British Council.
The brief was to help the external relations team communicate the work of the British Council throughout the UK. The result was the Activity Mapping Project.
One output of the project was a set of Google Earth animated presentations.
Maps were created for each parliamentary constituency in the UK.
The technical basis of this project was the processing of data from over 200 separate British Council teams. We asked each team to provide the address of the beneficiary organization, together with the overseas partner countries. I developed an ASP.Net MVC application to de-duplicate the address data, then we were in a position to geo-code the data to present on the maps.