I am trying to make a deprivation map using google map. My data contains an array of 2 elements - 'a deprivation value' at a location 'postcode'. All I need to do is to draw a color (darker = more deprivation) on the postcode area. This seems to be easy to implement using Fusion table.
However, the postcode I have is either 7 or 8 characters long (eg AB1 1WA). However, the 'UK Regional KML Boundaries' data I found on google seems to contain the first 3 or 4 letters. In the above example, it will be 'AB1 1'. My question is how do I convert my original postcodes (7/8 letters) to the new format (3/4 letters)?
I could do it manually first (or write a seperate program) and then copy it to fusion table. But can I possibly write a javascript program to do it? How can the fusion table works together with customized javascript program?