I like your idea.

We would need to have a key "color to climate type", wouldn't we?

I'm off on holidays in a couple of hours, but will get back to this in September. That is, if you didn't fully solve the problem by then.