location denormalized. comfort table now has location fields