Text this: Enhancing livelihoods in farming communities through super-resolution agromet advisories using advanced digital agriculture technologies