The key goal of the current study was to determine suitable areas of water pumping for drinking and agricultural harvest in Tabriz aquifer, located in East Azerbaijan province, northwest Iran. In the study area, groundwater is the key foundation of water for drinking and farming requirements. Groundwater compatibility study was conducted by analyzing Electrical conductivity (EC), Total dissolved solids (TDS), Chloride (Cl), Calcium (Ca), Magnesium (Mg), Sodium (Na), Potassium (K), Sulfate (SO4), Total hardness (TH), Bicarbonate (HCO3), pH, carbonate (CO3) and Sodium Adsorption Ratio (SAR) obtained from 39 wells in the period of 2003 to 2014. For this purpose, the Water Quality Index (WQI) and irrigation water quality (IWQ) index were utilized. The WQI index zoning exposed that the groundwater of the study area for drinking purposes is categorized as excellent, good and poor water. Most drinking water harvested for urban and rural areas are in the class of 'excellent water'. The results revealed that about 37 percent (296 km2) of groundwater has high compatibility, and 63 percent of the study area (495 km2) has average compatibility for agricultural purposes. The trend of IWQ and WQI indexes demonstrates that the groundwater is getting worse over the time.

In this research, a new conceptual framework introduced to analysis of water security. Using the exponential, logistic growth model, and employing the historical population of Tabriz city from 1956 to 2016, the future period (2022-2100) population predicted. Pearson Correlation, Spearman's Rho and Kendall's rank coefficients were used for analyzing correlation between population and water consumption. In addition, the amount of city water demand in the future period predicted using the ordinary least square model. Then, water stress and water scarcity indices calculated for Tabriz city in the future period. Results indicated that the mathematical population growth models are very suitable for prediction of city population. There was a significant positive correlation between the city population and water demand. In addition, the amount of water demand will proportionally increase with rising number of population. Finally, linear and quadratic equations presented for city water demand based on the city population number. It can be concluded that Tabriz city will be faced with severe water stress in the future period. The proposed new method in this study can be used for other different cities of the world. Also, Results will be helpful for decision makers in optimum management of urban water resources.