The Donghuantuo Mine has the highest normal water inflow among active mines in Hebei Province. The safe production of its main mining coal seam is threatened by the sandstone aquifer in the roof of the No. 5 coal seam. This aquifer exhibits uneven spatial distribution of water abundance, characterized by generally weak to moderate water-richness with localized areas of strong water-bearing capacity. Historical mining data reveals that multiple water inrush incidents at the mine have been closely associated with this aquifer, necessitating a comprehensive risk assessment of the roof aquifer. The "Three Maps -Two Predictions" method, a mature evaluation approach for roof water hazards, was employed in this study. Guided by this theoretical framework and based on actual mine data, we addressed the current insufficiency in hydrogeological investigation by integrating data and conducting cross-validation. This process established correlations between geological boreholes and hydrogeological boreholes, enhanced the extraction of hydrogeological attributes from drilling data, achieved the secondary development and efficient utilization of historical data in roof water hazard assessment.