A multidisciplinary geoscientific study for water resource management using spatial information technologies in a typical semi arid region andhra pradesh india