In view of the problems including seepage deformation，seismic liquefaction，groundwater control，natural building material balance，and hydrophilic safety in the water environment of Yangwa ship lock of China’s North Canal，this paper uses comprehensive geological mapping，comprehensive engineering geophysical prospecting，geological drilling，in-situ test，hydrogeological test，laboratory test，water environment quality survey，BIM，and other technologies to investigate the construction site and conducts in-depth research on main engineering geological problems. The results show that the standard penetration and static cone penetration determine the lower limit of seismic liquefaction in the site，and the laboratory test of undisturbed sand obtains the physical and mechanical properties and seepage deformation parameters of the foundation bearing stratum. The field pumping test reveals hydrogeological parameters of groundwater control in the ship lock foundation pit. BIM finely calculates the amount of excavated spoil. The comprehensive analysis of water quality confirms that the water will pose no health risks to humans，and the investigation yields favorable results.