The assessment and prediction of temporal variations in surface water quality—a case study