In order to study the effect of navigation aids optimization and evaluate the guiding effect of navigation mark adjustment on different ship types under different water conditions in specific water areas,we propose the method of quickly extracting the specified ship trajectory in the data based on the non-relational database MongoDB and according to parameters such as range,time zone and ship type,and visualize it on the front end based on WebGL,and develop the ship trajectory big data analysis system.Selecting the Nanjing Yangtze River Bridge as the test river section,we analyze the trajectory big data of the two seasons before and after the voyage optimization adjustment in 2017.The system reveals that after the navigation mark optimization and adjustment,the ship is launched through the six holes of the bridge during the flood period,and the angle between the track and the normal axis of the bridge axis is reduced,thus the expected effect is achieved.The results show that the method can quickly and automatically extract and display ships’ big data,which can be used to assist in optimizing the navigation mark distribution.