Regional water and soil assessment for managing sustainable agriculture