Conditional heavy-tail behavior with applications to precipitation and river flow extremes