get weather location from smarthome to mysql to visualization