General specific yield is a very important parameter in water resources assessment.However,it is too difficult to calculate it in handwork in calculation of large district where water stage has descended extensively.It is convenient to use hydrogeologic database and modern software tools in solving this problem.This paper introduced a method of calculating the general specific yield of water stage fluctuation belt by using MapGIS and VB to extract hydrogeologic test data,lithology,thickness and water table from the hydrogeologic database,which has been applied for the project of investigation and assessment of the groundwater resources for sustainable utilization in the North China Plain.In this project,in accordance with the great thickness of the water stage fluctuation belt resulted from groundwater overdrafting,based on the hydrogeologic database,the general specific yield of the fluctuation belt were obtained and the distributed graph of general specific yield in the North China Plain was made with MapGIS and VB program.