Integrating historical and near real-time river data close to the coastal area