The invention discloses a
school bus real-
time trajectory deviation display method,
system and device and a medium, belongs to the technical field of
school bus monitoring, and aims to solve the technical problems of how to realize accurate monitoring of a
school bus driving trajectory, timely discover and give an alarm of a deviation behavior and improve monitoring efficiency and school
bus service safety. According to the technical scheme, original school
bus position data are received from a third-party interface, and data preprocessing is carried out; extracting and
processing school
bus position data from the
time sequence database through a timed task, obtaining a school bus standard track, and storing the school bus standard track into MySQL to form a school bus standard track
library; according to the obtained latest school bus position, the current school bus track deviation condition is judged; acquiring all position data of a corresponding school bus standard track
library, performing de-duplication
processing, and displaying a standard track on a map; acquiring the today position data of the corresponding school bus from the
time sequence database, forming a today trajectory on a map, comparing the today trajectory with a standard trajectory, and visually displaying the details of the deviation condition of the corresponding school bus.