Water plays a pivotal role in socio-economic development in Algeria. However, the overexploitations of groundwater resources, water scarcity, and the proliferation of pollution sources (including industrial and urban effluents, untreated landfills, and chemical fertilizers, etc.) have resulted in substantial groundwater contamination. Preserving water irrigation quality has thus become a primary priority, capturing the attention of both scientists and local authorities. The current study introduces an innovative method to mapping contamination risks, integrating vulnerability assessments, land use patterns (as a sources of pollution), and groundwater overexploitation (represented by the waterhole density) through the implementation of a decision tree model. The resulting risk map illustrates the probability of contamination occurrence in the substantial aquifer on the plateau of Mostaganem. An agricultural region characterized by the intensive nutrients and pesticides use, the significant presence of septic tanks, widespread illegal dumping, and a technical landfill not compliant with environmental standards. The critical situation in the region is exacerbated by excessive groundwater pumping surpassing the aquifer's natural replenishment capacity (with 115 boreholes and 6345 operational wells), especially in a semi-arid climate featuring limited water resources and frequent drought. Vulnerability was evaluated using the DRFTID method, a derivative of the DRASTIC model, considering parameters such as depth to groundwater, recharge, fracture density, slope, nature of the unsaturated zone, and the drainage density. All these parameters are combined with analyses of inter-parameter relationship effects. The results show a spatial distribution into three risk levels (low, medium, and high), with 31.5% designated as high risk, and 56% as medium risk. The validation of this mapping relies on the assessment of physicochemical analyses in samples collected between 2010 and 2020. The results indicate elevated groundwater contamination levels in samples. Chloride exceeded acceptable levels by 100%, nitrate by 71%, calcium by 50%, and sodium by 42%. These elevated concentrations impact electrical conductivity, resulting in highly mineralized water attributed to anthropogenic agricultural pollution and septic tank discharges. High-risk zones align with areas exhibiting elevated nitrate and chloride concentrations. This model, deemed satisfactory, significantly enhances the sustainable management of water resources and irrigated land across various areas. In the long term, it would be beneficial to refine "vulnerability and risk" models by integrating detailed data on land use, groundwater exploitation, and hydrogeological and hydrochemical characteristics. This approach could improve vulnerability accuracy and pollution risk maps, particularly through detailed local data availability. It is also crucial that public authorities support these initiatives by adapting them to local geographical and climatic specificities on a regional and national scale. Finally, these studies have the potential to foster sustainable development at different geographical levels.