School bus real-time trajectory deviation display method, system and device and medium
By receiving and processing school bus position data, forming a standard trajectory library, judging and displaying trajectory deviation, the problems of low monitoring efficiency and signal error of school buses in the existing technology are solved, and the precise monitoring and automatic alarm of school buses are realized, and the school buses are improved. Service security and efficiency.
Patent Information
- Application Number
- CN202411224815.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-03
- Publication Date
- 2024-12-03
AI Technical Summary
The existing technology has problems such as inefficiency and signal errors in monitoring whether school buses are strictly driven in accordance with prescribed routes, which makes it difficult to achieve accurate monitoring and timely alarms, affecting the safety and efficiency of school bus services.
By receiving school bus position data from a third-party interface, preprocessing and storing it into a timing database, obtaining standard trajectories, judging the trajectory deviation, and displaying the deviation on the map, automatic alarm and data analysis are achieved.
It realizes accurate monitoring of school bus driving trajectory, timely discovers and alarms, improves monitoring efficiency and safety, reduces manpower consumption, and improves the scientific nature of response speed and route planning.
Smart Images

Figure CN119066137A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of school bus monitoring, and in particular to a method, system, equipment and medium for displaying real-time track deviation of a school bus. Background Art
[0002] In the current educational environment, school buses are an important means of transportation for students to go to and from school, and their safety has always been the focus of social attention. With the increase in the number of school buses and the expansion of their operating scope, how to effectively supervise the routes of school buses and ensure the safety of students has become an urgent problem to be solved. Although many school buses are equipped with global positioning systems (GPS) or Beidou positioning systems that can track the location of vehicles in real time, existing technologies are insufficient in monitoring whether school buses strictly follow the prescribed routes.
[0003] Traditional monitoring methods mainly rely on manual inspections, which are not only inefficient but also easily affected by human factors, leading to blind spots in supervision. In addition, although existing GPS positioning technology can provide real-time location information of vehicles, it often has certain limitations when judging whether the vehicle has deviated from the scheduled route due to signal errors, map data update lags and other issues. Especially in complex and changeable road environments, it is difficult to achieve accurate monitoring by relying solely on GPS positioning.
[0004] In addition, when a school bus deviates from the scheduled route, the existing technical means often lack a timely and effective alarm mechanism, and cannot quickly notify managers or drivers to take measures, thus missing the best time to prevent accidents. At the same time, due to the lack of systematic analysis of school bus driving data, it is difficult for regulatory authorities to optimize and adjust school bus driving routes, affecting the overall quality and efficiency of school bus services.
[0005] Therefore, how to achieve accurate monitoring of school bus driving trajectories, timely detect and alarm deviations, and improve monitoring efficiency and the safety of school bus services is a technical problem that needs to be solved urgently. Summary of the invention
[0006] The technical task of the present invention is to provide a method, system, equipment and medium for displaying real-time school bus trajectory deviation to solve the problem of how to accurately monitor the school bus driving trajectory, timely detect and alarm deviation behavior, and improve monitoring efficiency and the safety of school bus services.
[0007] The technical task of the present invention is achieved in the following manner: a method for displaying real-time track deviation of a school bus, the method being specifically as follows:
[0008] Receive raw school bus location data from a third-party interface, perform data preprocessing, and store it in a time series database;
[0009] Extract and process school bus location data from the time series database through scheduled tasks, obtain the standard track of the school bus, and store it in MySQL to form a standard track library of the school bus;
[0010] According to the latest school bus position obtained, determine the deviation of the current school bus track;
[0011] Obtain all location data of the corresponding school bus standard trajectory library, perform deduplication processing, and display the standard trajectory on the map;
[0012] The corresponding school bus's today's location data is obtained from the time series database, and today's trajectory is formed on the map. Today's trajectory is compared with the standard trajectory to intuitively display the details of the corresponding school bus's deviation.
[0013] As a preferred method, the original school bus location data is received from a third-party interface and data preprocessing is performed as follows:
[0014] Extract various data from the original object, calculate and adjust the data type of each data to convert it into the required data, and obtain the pre-processed school bus location data;
[0015] The preprocessed school bus location data is stored in the time series database.
[0016] As a preferred method, the school bus location data is extracted and processed from the time series database through a scheduled task to obtain the standard track of the school bus, and stored in MySQL to form a standard track library of the school bus as follows:
[0017] Get 31 days of school bus location data from the time series database;
[0018] For each school bus, process the location data of each day;
[0019] Split a day into minutes and determine whether the school bus is online every minute:
[0020] If online, the position data is retained as a standard trajectory point;
[0021] After all the school bus data are judged, the online time and location of the online school buses are merged and saved in the MySQL database to form a school bus standard trajectory library;
[0022] Set up a scheduled task to synchronize online school bus data every 10 minutes and establish a real-time updated school bus standard track library;
[0023] After the first synchronization is completed, you only need to synchronize the online school bus location data of the last 10 minutes, which improves the synchronization efficiency of the school bus standard trajectory library.
[0024] Preferably, the method for determining whether the school bus is online every minute is as follows: first obtain the school bus location data for the 10 minutes before the current minute and the school bus location data for the 10 minutes after the current minute; then obtain the latest school bus location data for the first 10 minutes and the earliest school bus location data for the last 10 minutes; then determine whether the time difference between the two data exceeds 10 minutes: if it does not exceed 10 minutes, it is considered that the school bus is online at the current moment; if it does not exceed 10 minutes, it is considered that the school bus is offline at the current moment.
[0025] As a preferred method, according to the latest acquired school bus position, the current school bus track deviation is determined as follows:
[0026] Get the real-time location of the school bus, calculate the physical distance with the online school bus data in the school bus standard trajectory library, and determine whether the minimum distance exceeds the set threshold:
[0027] If the threshold is exceeded, it is considered that the current school bus has deviated from its track, and a school bus track deviation warning prompt is displayed at the corresponding school bus position on the map.
[0028] As a preferred method, all the location data of the corresponding school bus standard track library are obtained, and duplicate removal is performed, and the standard track is displayed on the map as follows:
[0029] For any school bus, query the standard track coordinate points of the corresponding school bus from the school bus standard track library, perform coordinate point deduplication processing, and retain the longitude and latitude of the coordinates to 3 decimal places;
[0030] The vehicle coordinate points with repeated longitude and latitude are deduplicated, and the final standard trajectory coordinate points are displayed on the map as a standard trajectory.
[0031] As a preferred method, the current location data of the corresponding school bus is obtained from the time series database, and the current trajectory is formed on the map. The current trajectory is compared with the standard trajectory to intuitively display the details of the corresponding school bus deviation as follows:
[0032] For any school bus, query the current location data of the corresponding school bus from the time series database and display the current track on the map;
[0033] The corresponding school bus today's trajectory layer and standard trajectory layer are superimposed and displayed:
[0034] If today's trajectory layer and the standard trajectory layer overlap, it means that the corresponding school bus has not deviated from the trajectory;
[0035] If today's trajectory layer and the standard trajectory layer do not overlap, it means that the corresponding school bus has deviated from the trajectory, and the specific situation of the deviation of the corresponding school bus trajectory is intuitively displayed.
[0036] A school bus real-time track deviation display system, the system is used to implement the school bus real-time track deviation display method as described above; the system comprises:
[0037] A preprocessing module is used to receive the original school bus location data from a third-party interface, perform data preprocessing, and store it in a time series database;
[0038] The acquisition module is used to extract and process school bus location data from the time series database through a scheduled task, obtain the standard track of the school bus, and store it in MySQL to form a standard track library of the school bus;
[0039] A judgment module is used to judge the deviation of the current school bus track according to the latest acquired school bus position;
[0040] The deduplication module is used to obtain all the location data of the corresponding school bus standard trajectory library, perform deduplication processing, and display the standard trajectory on the map;
[0041] The comparison module is used to obtain the corresponding school bus's today's location data from the time series database, form today's trajectory on the map, compare today's trajectory with the standard trajectory, and intuitively display the details of the corresponding school bus's deviation.
[0042] An electronic device comprising: a memory and at least one processor;
[0043] Wherein, the memory stores a computer program;
[0044] The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the school bus real-time trajectory deviation display method as described above.
[0045] A computer-readable storage medium stores a computer program, which can be executed by a processor to implement the school bus real-time trajectory deviation display method as described above.
[0046] The school bus real-time track deviation display method, system, device and medium of the present invention have the following advantages:
[0047] (1) The present invention can monitor in real time and automatically give an alarm: The present invention can monitor the driving trajectory of the school bus in real time, and automatically give an alarm once a deviation from the predetermined route is detected, thereby improving the monitoring capability of the school bus driving safety;
[0048] (ii) The present invention reduces the consumption of manpower and material resources: through the automated monitoring system, the dependence on human monitoring is reduced, the monitoring omissions caused by human factors are reduced, and the consumption of material resources is also reduced;
[0049] (iii) The present invention improves response speed: the automated alarm system can respond quickly to the situation where the school bus deviates from the route, and measures can be taken more quickly than manual monitoring, thereby potentially reducing the risk of accidents;
[0050] (iv) The present invention can perform data recording and analysis: the server can record the driving data of the school bus, which can be used for subsequent analysis and optimization to improve the scientificity and rationality of school bus route planning;
[0051] (V) The application of the present invention helps school bus drivers comply with the prescribed driving routes, reduces violations, and improves the overall standardization of the school bus industry;
[0052] (VI) The present invention realizes accurate monitoring of the driving trajectory of school buses, timely discovers and warns of deviations, improves the supervision efficiency and the safety of school bus services, can effectively reduce the occurrence of school bus accidents, and ensure the safety of students going to and from school. At the same time, it also provides a highly efficient and intelligent supervision tool for school bus management and supervision departments;
[0053] (VII) Compared with the prior art, the present invention greatly improves the safety of school bus driving through real-time trajectory monitoring and intelligent automatic alarm, while reducing supervision costs and improving response speed. It also has data recording and analysis functions, optimizes route planning, strengthens compliance with regulations, and ensures efficient and standardized school bus operations. BRIEF DESCRIPTION OF THE DRAWINGS
[0054] The present invention is further described below in conjunction with the accompanying drawings.
[0055] Attached Figure 1 A flowchart of extracting and processing school bus location data from a time series database through a scheduled task, obtaining the standard trajectory of the school bus, and storing it in MySQL to form a school bus standard trajectory library. DETAILED DESCRIPTION
[0056] The school bus real-time trajectory deviation display method, system, device and medium of the present invention are described in detail below with reference to the drawings and specific embodiments of the specification.
[0057] Embodiment 1:
[0058] This embodiment provides a method for displaying real-time track deviation of a school bus, which is specifically as follows:
[0059] S1, receiving the original school bus location data from the third-party interface, performing data preprocessing, and storing it in the time series database;
[0060] S2. Extract and process school bus location data from the time series database through a scheduled task, obtain the standard track of the school bus, and store it in MySQL to form a standard track library of the school bus;
[0061] S3. Determine the deviation of the current school bus track based on the latest school bus position obtained;
[0062] S4, obtaining all the location data of the corresponding school bus standard trajectory library, performing deduplication processing, and displaying the standard trajectory on the map;
[0063] S5. Obtain the current location data of the corresponding school bus from the time series database, form the current trajectory on the map, compare the current trajectory with the standard trajectory, and intuitively display the details of the deviation of the corresponding school bus.
[0064] In step S1 of this embodiment, the original school bus location data is received from the third-party interface and data preprocessing is performed as follows:
[0065] S101, extracting various data from the original object, and converting the various data into required data by calculating and adjusting the data type, and obtaining the pre-processed school bus location data;
[0066] S102. Store the pre-processed school bus location data into a time series database.
[0067] As attached Figure 1 As shown, in step S2 of this embodiment, the school bus position data is extracted and processed from the time series database through a scheduled task to obtain the standard track of the school bus, and stored in MySQL to form a standard track library of the school bus as follows:
[0068] S201, obtaining 31 days of school bus location data from a time series database;
[0069] S202, processing the location data of each school bus every day;
[0070] S203, splitting a day into minutes, and determining whether a school bus is online every minute:
[0071] If online, the position data is retained as a standard trajectory point;
[0072] S204, after all school bus data are judged, the online time and location of the online school buses are merged and saved in the MySQL database to form a school bus standard track library;
[0073] S205. Set a scheduled task to synchronize online school bus data every 10 minutes and establish a real-time updated school bus standard track library;
[0074] It is worth noting that after the first synchronization is completed, it is only necessary to synchronize the online school bus location data of the last 10 minutes, which improves the synchronization efficiency of the school bus standard trajectory library.
[0075] The method for determining whether the school bus is online every minute in step S203 of this embodiment is specifically as follows: first obtain the school bus location data for the 10 minutes before the current minute and the school bus location data for the 10 minutes after the current minute; then obtain the latest school bus location data for the first 10 minutes and the earliest school bus location data for the last 10 minutes; then determine whether the time difference between the two data exceeds 10 minutes: if it does not exceed 10 minutes, it is considered that the school bus is online at the current moment; if it does not exceed 10 minutes, it is considered that the school bus is offline at the current moment.
[0076] In step S3 of this embodiment, judging the deviation of the current school bus track according to the latest acquired school bus position is specifically as follows:
[0077] Get the real-time location of the school bus, calculate the physical distance with the online school bus data in the school bus standard trajectory library, and determine whether the minimum distance exceeds the set threshold:
[0078] If the threshold is exceeded, it is considered that the current school bus has deviated from its track, and a school bus track deviation warning prompt is displayed at the corresponding school bus position on the map.
[0079] In step S4 of this embodiment, all the position data of the corresponding school bus standard track library are obtained, duplicate removal is performed, and the standard track is displayed on the map as follows:
[0080] S401, for any school bus, query the standard track coordinate points of the corresponding school bus from the school bus standard track library, perform coordinate point deduplication processing, and retain the longitude and latitude of the coordinates to 3 decimal places;
[0081] S402, de-duplication operation is performed on the vehicle coordinate points with repeated longitude and latitude, and the finally obtained standard track coordinate points are displayed on the map as a standard track.
[0082] In step S5 of this embodiment, the current position data of the corresponding school bus is obtained from the time series database, and the current track is formed on the map. The current track is compared with the standard track to intuitively display the details of the corresponding school bus deviation as follows:
[0083] S501: for any school bus, query the current location data of the corresponding school bus from the time series database, and display the current track on the map;
[0084] S502, overlaying and displaying the corresponding school bus today's trajectory layer and the standard trajectory layer:
[0085] If today's trajectory layer and the standard trajectory layer overlap, it means that the corresponding school bus has not deviated from the trajectory;
[0086] If today's trajectory layer and the standard trajectory layer do not overlap, it means that the corresponding school bus has deviated from the trajectory, and the specific situation of the deviation of the corresponding school bus trajectory is intuitively displayed.
[0087] Embodiment 2:
[0088] This embodiment provides a school bus real-time track deviation display system, which is used to implement the school bus real-time track deviation display method in embodiment 1; the system includes:
[0089] A preprocessing module is used to receive the original school bus location data from a third-party interface, perform data preprocessing, and store it in a time series database;
[0090] The acquisition module is used to extract and process school bus location data from the time series database through a scheduled task, obtain the standard track of the school bus, and store it in MySQL to form a standard track library of the school bus;
[0091] A judgment module is used to judge the deviation of the current school bus track according to the latest acquired school bus position;
[0092] The deduplication module is used to obtain all the location data of the corresponding school bus standard trajectory library, perform deduplication processing, and display the standard trajectory on the map;
[0093] The comparison module is used to obtain the corresponding school bus's today's location data from the time series database, form today's trajectory on the map, compare today's trajectory with the standard trajectory, and intuitively display the details of the corresponding school bus's deviation.
[0094] Embodiment 3:
[0095] This embodiment also provides an electronic device, including: a memory and a processor;
[0096] Wherein, the memory stores computer-executable instructions;
[0097] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the school bus real-time trajectory deviation display method in any embodiment of the present invention.
[0098] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.
[0099] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.
[0100] Embodiment 4:
[0101] This embodiment also provides a computer-readable storage medium, in which a plurality of instructions are stored, and the instructions are loaded by a processor, so that the processor executes the real-time school bus track deviation display method in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which a software program code that implements the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or device reads and executes the program code stored in the storage medium.
[0102] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.
[0103] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.
[0104] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.
[0105] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.
[0106] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.
Claims
1. A method for displaying real-time track deviation of a school bus, characterized in that: The method is as follows: Receive raw school bus location data from a third-party interface, perform data preprocessing, and store it in a time series database; Extract and process school bus location data from the time series database through scheduled tasks, obtain the standard track of the school bus, and store it in MySQL to form a standard track library of the school bus; According to the latest school bus position obtained, determine the deviation of the current school bus track; Obtain all location data of the corresponding school bus standard trajectory library, perform deduplication processing, and display the standard trajectory on the map; The corresponding school bus's today's location data is obtained from the time series database, and today's trajectory is formed on the map. Today's trajectory is compared with the standard trajectory to intuitively display the details of the corresponding school bus's deviation.
2. The method for displaying real-time school bus track deviation according to claim 1, characterized in that: Receive the original school bus location data from the third-party interface and perform data preprocessing as follows: Extract various data from the original object, calculate and adjust the data type of each data to convert it into the required data, and obtain the pre-processed school bus location data; The preprocessed school bus location data is stored in the time series database.
3. The method for displaying real-time school bus track deviation according to claim 1, characterized in that: The school bus location data is extracted and processed from the time series database through a scheduled task to obtain the standard track of the school bus and store it in MySQL to form a standard track library of the school bus. The details are as follows: Get 31 days of school bus location data from the time series database; For each school bus, process the location data of each day; Split a day into minutes and determine whether the school bus is online every minute: If online, the position data is retained as a standard trajectory point; After all the school bus data are judged, the online time and location of the online school buses are merged and saved in the MySQL database to form a school bus standard trajectory library; Set up a scheduled task to synchronize online school bus data every 10 minutes and establish a real-time updated school bus standard track library; After the first synchronization is completed, you only need to synchronize the online school bus location data of the last 10 minutes, which improves the synchronization efficiency of the school bus standard trajectory library.
4. The method for displaying real-time school bus track deviation according to claim 3, characterized in that: The specific method for judging whether the school bus is online every minute is as follows: first obtain the school bus location data for the 10 minutes before the current minute and the school bus location data for the 10 minutes after the current minute; then obtain the latest school bus location data for the first 10 minutes and the earliest school bus location data for the last 10 minutes; then determine whether the time difference between the two data exceeds 10 minutes: if it does not exceed 10 minutes, it is considered that the school bus is online at the current moment; if it does not exceed 10 minutes, it is considered that the school bus is offline at the current moment.
5. The method for displaying real-time school bus track deviation according to claim 1, characterized in that: According to the latest school bus position obtained, the current school bus track deviation is judged as follows: Get the real-time location of the school bus, calculate the physical distance with the online school bus data in the school bus standard trajectory library, and determine whether the minimum distance exceeds the set threshold: If the threshold is exceeded, it is considered that the current school bus has deviated from its track, and a school bus track deviation warning prompt is displayed at the corresponding school bus position on the map.
6. The method for displaying real-time school bus track deviation according to claim 1, characterized in that: Get all the location data of the corresponding school bus standard trajectory library, perform deduplication processing, and display the standard trajectory on the map as follows: For any school bus, query the standard track coordinate points of the corresponding school bus from the school bus standard track library, perform coordinate point deduplication processing, and retain the longitude and latitude of the coordinates to 3 decimal places; The vehicle coordinate points with repeated longitude and latitude are deduplicated, and the final standard trajectory coordinate points are displayed on the map as a standard trajectory.
7. The method for displaying real-time school bus track deviation according to claim 1, characterized in that: Get the current location data of the corresponding school bus from the time series database, and form the current track on the map. Compare the current track with the standard track to intuitively display the details of the corresponding school bus deviation as follows: For any school bus, query the current location data of the corresponding school bus from the time series database and display the current track on the map; The corresponding school bus today's trajectory layer and standard trajectory layer are superimposed and displayed: If today's trajectory layer and the standard trajectory layer overlap, it means that the corresponding school bus has not deviated from the trajectory; If today's trajectory layer and the standard trajectory layer do not overlap, it means that the corresponding school bus has deviated from the trajectory, and the specific situation of the corresponding school bus trajectory deviation is intuitively displayed.
8. A school bus real-time track deviation display system, characterized in that: The system is used to implement the school bus real-time track deviation display method as described in any one of claims 1 to 7; the system comprises: A preprocessing module is used to receive the original school bus location data from a third-party interface, perform data preprocessing, and store it in a time series database; The acquisition module is used to extract and process school bus location data from the time series database through a scheduled task, obtain the standard track of the school bus, and store it in MySQL to form a standard track library of the school bus; A judgment module is used to judge the deviation of the current school bus track according to the latest acquired school bus position; The deduplication module is used to obtain all the location data of the corresponding school bus standard trajectory library, perform deduplication processing, and display the standard trajectory on the map; The comparison module is used to obtain the corresponding school bus's today's location data from the time series database, form today's trajectory on the map, compare today's trajectory with the standard trajectory, and intuitively display the details of the corresponding school bus's deviation.
9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the school bus real-time trajectory deviation display method as described in any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the school bus real-time trajectory deviation display method as described in any one of claims 1 to 7.
