Sealed bad drilling is an important risk adverse impact mine production safety, the bad drilling has turned bad on roof drilling on the aquifer, enhanced roof sandstone rich water. To solve this problem, the electrode was putted into the top of the face roof, using of sub-station data collection. After the data collection was completed, after data preprocessing and infinity corrected and roadway correction, removed the side interference handling, the least squares method was used to smooth mapping of data retrieval, the data retrieval was imported into 3D visualization Mapping, drilling rock near the water-rich area was described, providing decision-making for mine water treatment workers.