Section speed measurement methods, devices, computer equipment and storage media

Abstract

The present application relates to an interval speed measurement method, device, computer equipment, storage medium and computer program product. The method comprises: obtaining the vehicle end record of the target vehicle in real time; the vehicle end record contains the vehicle interval identification; the vehicle interval identification contains the vehicle identification and interval identification of the target vehicle; querying the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and judging whether the vehicle end record and the target vehicle starting point record meet the preset data validity conditions; when both the vehicle end record and the target vehicle starting point record meet the data validity conditions, constructing the interval driving record of the target vehicle according to the target vehicle starting point record and the vehicle end record; determining the interval speed of the target vehicle based on the interval distance, starting time and ending time in the interval driving record. The use of this method can improve the efficiency of the interval speed measurement method.

Description

Technical Field

[0001] The present application relates to the field of traffic safety technology, and in particular to a method, device, computer equipment, storage medium and computer program product for measuring speed within an interval. Background Art

[0002] For urban management in traffic scenarios, it is necessary to control the speed of vehicles to prevent accidents caused by excessive speed. Therefore, it is necessary to measure the speed of vehicles in intervals to determine whether the speed of the vehicle exceeds the prescribed speed.

[0003] The current interval test method is to collect vehicle starting and ending records of vehicles passing through the interval speed measurement section through radar sonar radio frequency identification equipment and image recognition equipment, and build a vehicle starting record set and a vehicle ending record set when the number of vehicles reaches a preset number threshold. Then, the vehicle starting record corresponding to each vehicle ending record in the vehicle ending record set is determined respectively, and the interval speed of the vehicle is determined based on the vehicle ending record and its corresponding vehicle starting record.

[0004] However, the current interval speed measurement method requires the number of collected vehicles to reach a threshold value, resulting in a long time for the interval test method to process vehicle endpoint records. Therefore, the current interval speed measurement method is inefficient. Summary of the invention

[0005] Based on this, it is necessary to provide an interval speed measurement method, device, computer equipment, computer readable storage medium and computer program product to address the above technical problems.

[0006] In a first aspect, the present application provides an interval speed measurement method, comprising:

[0007] Acquire the vehicle destination record of the target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle;

[0008] Querying the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determining whether the vehicle end point record and the target vehicle starting point record meet a preset data validity condition;

[0009] In the case where both the vehicle endpoint record and the target vehicle starting record satisfy the data validity condition, constructing the interval driving record of the target vehicle according to the target vehicle starting record and the vehicle endpoint record;

[0010] The interval speed of the target vehicle is determined based on the interval distance, the starting time and the ending time in the interval driving record.

[0011] In the above interval speed measurement method, the vehicle end record of the target vehicle is obtained in real time, and the target vehicle starting record corresponding to the vehicle end record is determined, so that the target interval passed by the target vehicle can be quickly determined. Then, data processing is performed on the vehicle end record and the target vehicle starting record to obtain the interval speed of the target vehicle, thereby improving the efficiency of the interval speed measurement method.

[0012] In one embodiment, the real-time acquisition of the vehicle destination record of the target vehicle includes:

[0013] Acquire image data collected by each camera image acquisition device in real time, and determine the vehicle interval record corresponding to the target vehicle in the image data;

[0014] Deduplication processing is performed on the vehicle interval records to obtain the vehicle interval records that meet a preset deduplication condition;

[0015] Extracting the image acquisition device number in the vehicle interval record, and querying the interval start point and the interval end point of each interval configuration information based on the image acquisition device number to obtain the vehicle start point record and the vehicle end point record of the target vehicle;

[0016] A historical vehicle starting point record list is updated based on the vehicle starting point record to obtain a vehicle starting point record list.

[0017] In this embodiment, the image data is collected by an image acquisition device, and the image data is processed to obtain the vehicle interval record of the target vehicle. The vehicle interval record can be obtained by only using the image acquisition device, which reduces the hardware requirements of the interval speed measurement method. In addition, the vehicle starting point record and the vehicle end point record are determined respectively through the vehicle interval record, which can adapt to the interval speed measurement solution under different road scenes, and expand the scope of application of the interval speed measurement method.

[0018] In one embodiment, the deduplication processing of the vehicle interval record to obtain the vehicle interval record that meets a preset deduplication condition includes:

[0019] According to the vehicle interval identifier in the vehicle interval record, query the historical vehicle interval record in the history table;

[0020] If the historical vehicle interval record exists, determining whether a first time difference between the historical vehicle interval record and the vehicle interval record is greater than or equal to a preset first time threshold;

[0021] When the first time difference is greater than or equal to the first time threshold or the historical vehicle interval record does not exist, it is determined that the vehicle interval record meets a preset deduplication condition, and the vehicle interval record that meets the deduplication condition is obtained.

[0022] In this embodiment, by deduplicating vehicle interval records, vehicle interval records that meet deduplication conditions are obtained, which solves the problem of various deliberate avoidance of interval speed measurement in industry scenarios, reduces the time for processing vehicle interval records, and improves the efficiency of interval speed measurement.

[0023] In one embodiment, before extracting the image acquisition device number in the vehicle interval record, the method further includes:

[0024] In response to a request to configure target interval configuration information, display a configuration page including an interval configuration template; the interval configuration template includes an initial interval start point and an initial interval end point;

[0025] In response to a determination operation of a first target checkpoint at the starting point of the initial interval, determining the first target checkpoint as the starting point of the target interval;

[0026] In response to a determination operation of a second target checkpoint at the end point of the initial interval, determining the second target checkpoint as the end point of the target interval;

[0027] In response to a determination operation of the target configuration information in the interval configuration template, constructing the target interval configuration information based on the target configuration information, the target interval start point and the target interval end point;

[0028] The target interval configuration information is updated to the database through real-time log access technology, and the target interval configuration information is synchronized.

[0029] In this embodiment, the target interval start point and the target interval end point are determined based on the interval configuration template, and the target configuration information is configured. Then, the target interval configuration information is constructed according to the target interval start point, the target interval end point and the target configuration information, so as to realize the fast and flexible configuration of the target interval configuration information and expand the application scope of the interval speed measurement method.

[0030] In one embodiment, the querying of the interval start point and the interval end point of each interval configuration information based on the image acquisition device number to obtain the vehicle start point record and the vehicle end point record of the target vehicle includes:

[0031] Based on the image acquisition device number, query at the interval starting point of each interval configuration information to obtain the first interval configuration information including the image acquisition device number, and construct the vehicle starting point record of the target vehicle based on the first interval configuration information and the vehicle interval record;

[0032] Based on the image acquisition device number, query at the interval end point of each interval configuration information to obtain second interval configuration information including the image acquisition device number;

[0033] A vehicle destination record of the target vehicle is constructed based on the second section configuration information and the vehicle section record.

[0034] In this embodiment, the vehicle starting point record and the vehicle end point record are determined respectively by the image acquisition device number, which solves various ways of deliberately avoiding interval speed measurement, expands the interval speed measurement range covered by the interval speed measurement algorithm, and expands the scope of use of the interval speed measurement method.

[0035] In one embodiment, the determining whether the vehicle destination record and the target vehicle starting point record meet a preset data validity condition includes:

[0036] Determine a first interval identifier in the vehicle destination record, and determine a second interval identifier in the target vehicle start record;

[0037] Determining whether the first interval identifier and the second interval identifier are consistent;

[0038] If the first interval identifier and the second interval identifier are consistent, it is determined that the vehicle endpoint record and the target vehicle start point record meet a preset data validity condition.

[0039] In this embodiment, by judging whether the first interval identifier in the vehicle destination record is consistent with the second interval identifier in the target vehicle starting record, it is determined whether the target vehicle passes through the same interval, which facilitates the subsequent construction of the interval driving record of the target vehicle.

[0040] In one embodiment, after determining whether the vehicle destination record and the target vehicle starting point record meet a preset data validity condition, the method further includes:

[0041] When the vehicle destination record and the target vehicle starting record do not satisfy the data validity condition, obtaining the vehicle destination record of the next vehicle;

[0042] The vehicle destination record of the next vehicle is determined as the vehicle destination record of the target vehicle, and the step of searching the vehicle starting point record list for the target vehicle according to the vehicle identifier is performed.

[0043] In this embodiment, when the vehicle destination record and the target vehicle starting point record do not meet the data validity condition, the vehicle destination record of the next vehicle is obtained and the interval speed measurement method is executed, thereby improving the execution efficiency of the interval speed measurement method.

[0044] In one embodiment, after determining the interval speed of the target vehicle based on the interval distance, starting time and ending time in the interval driving record, the method further includes:

[0045] Determining whether the interval speed of the target vehicle is greater than a preset prescribed speed;

[0046] In the case where the interval speed is greater than the prescribed vehicle speed, a speeding record of the target vehicle is constructed based on the interval driving record and the interval speed, and the speeding record is fed back to the owner of the target vehicle and the cloud; the speeding record is used for speeding analysis in the cloud;

[0047] Determining whether the interval speed reaches a preset abnormal speed;

[0048] If the interval speed reaches the abnormal speed, an abnormal record of the target vehicle is constructed according to the interval driving record and the interval speed, and the abnormal record of the target vehicle is fed back to the target user.

[0049] In this embodiment, when the interval speed reaches the specified speed, the speeding record of the target vehicle is sent to the owner of the target vehicle, so that the owner of the target vehicle can clearly understand the speeding situation. In addition, when the interval speed reaches the abnormal speed, the abnormal record of the target vehicle is fed back to the target user, so that the target user can perform subsequent processing, which improves the convenience of the interval speed measurement method. In addition, the push reminder method after the interval abnormality allows the abnormal person to receive a warning in the first time, and also allows the traffic staff to conduct abnormal publicity and education in the first time. The high timeliness brings benefits to both the traffic staff and the abnormal person.

[0050] In a second aspect, the present application also provides an interval speed measurement device, comprising:

[0051] An acquisition module, used for acquiring a vehicle destination record of a target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle;

[0052] A query module, used to query the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determine whether the vehicle end point record and the target vehicle starting point record meet the preset data validity condition;

[0053] A judgment module, configured to construct a section driving record of the target vehicle according to the target vehicle starting record and the vehicle end record when both the vehicle end record and the target vehicle starting record meet the data validity condition;

[0054] The determination module is used to determine the interval speed of the target vehicle based on the interval distance, the starting time and the ending time in the interval driving record.

[0055] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0056] Acquire the vehicle destination record of the target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle;

[0057] Querying the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determining whether the vehicle end point record and the target vehicle starting point record meet a preset data validity condition;

[0058] In the case where both the vehicle endpoint record and the target vehicle starting record satisfy the data validity condition, constructing the interval driving record of the target vehicle according to the target vehicle starting record and the vehicle endpoint record;

[0059] The interval speed of the target vehicle is determined based on the interval distance, the starting time and the ending time in the interval driving record.

[0060] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:

[0061] Acquire the vehicle destination record of the target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle;

[0062] Querying the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determining whether the vehicle end point record and the target vehicle starting point record meet a preset data validity condition;

[0063] In the case where both the vehicle endpoint record and the target vehicle starting record satisfy the data validity condition, constructing the interval driving record of the target vehicle according to the target vehicle starting record and the vehicle endpoint record;

[0064] The interval speed of the target vehicle is determined based on the interval distance, the starting time and the ending time in the interval driving record.

[0065] In a fifth aspect, the present application further provides a computer program product, including a computer program, which implements the following steps when executed by a processor:

[0066] Acquire the vehicle destination record of the target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle;

[0067] Querying the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determining whether the vehicle end point record and the target vehicle starting point record meet a preset data validity condition;

[0068] In the case where both the vehicle endpoint record and the target vehicle starting record satisfy the data validity condition, constructing the interval driving record of the target vehicle according to the target vehicle starting record and the vehicle endpoint record;

[0069] The interval speed of the target vehicle is determined based on the interval distance, the starting time and the ending time in the interval driving record.

[0070] The above-mentioned interval speed measurement method, device, computer equipment, storage medium and computer program product obtain the vehicle end record of the target vehicle in real time; the vehicle end record contains the vehicle interval identifier; the vehicle interval identifier contains the vehicle identifier and the interval identifier of the target vehicle; according to the vehicle identifier, the target vehicle starting point record is queried in the vehicle starting point record list, and it is determined whether the vehicle end record and the target vehicle starting point record meet the preset data validity condition; when both the vehicle end record and the target vehicle starting point record meet the data validity condition, the interval travel record of the target vehicle is constructed according to the target vehicle starting point record and the vehicle end record; based on the interval distance, starting time and end time in the interval travel record, the interval speed of the target vehicle is determined. By adopting this method, the vehicle end record of the target vehicle is obtained in real time, and the target vehicle starting point record corresponding to the vehicle end record is determined, so that the target interval passed by the target vehicle can be quickly clarified. Then, data processing is performed on the vehicle end record and the target vehicle starting point record to obtain the interval speed of the target vehicle, thereby improving the efficiency of the interval speed measurement method. BRIEF DESCRIPTION OF THE DRAWINGS

[0071] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0072] Figure 1 A diagram showing an application environment of an interval speed measurement method in an embodiment;

[0073] Figure 2A schematic diagram of a flow chart of an interval speed measurement method in an embodiment;

[0074] Figure 3 A schematic diagram of a process flow of inter-section vehicle association in one embodiment;

[0075] Figure 4 A schematic diagram of a flow chart of steps for obtaining a vehicle destination record in one embodiment;

[0076] Figure 5 A schematic diagram of a flow chart of a step of deduplicating vehicle interval records in an embodiment;

[0077] Figure 6 is a flow chart of performing deduplication processing on vehicle interval records in one embodiment;

[0078] Figure 7 A schematic diagram of a flow chart of steps for configuring interval configuration information in one embodiment;

[0079] Figure 8 This is a UI diagram of a dynamic interval configuration interface in an embodiment;

[0080] Fig. 9 A schematic diagram of a flow chart of a step of determining a vehicle start and end point record in one embodiment;

[0081] Fig.10 A flow chart of real-time flow distribution of the start and end points of an interval in one embodiment;

[0082] Fig.11 A flowchart of a step for determining whether a vehicle destination record satisfies a data validity condition in an embodiment;

[0083] Fig.12 A schematic diagram of a flow chart of the step of updating a vehicle destination record in one embodiment;

[0084] Fig.13 A schematic diagram of a flow chart of the steps of determining whether a target vehicle is abnormally speeding in one embodiment;

[0085] Fig.14 A schematic diagram of a flow chart of an interval speed measurement method in another embodiment;

[0086] Fig.15 This is a schematic diagram of the data flow changes for this application;

[0087] Fig.16 is a structural block diagram of an interval speed measurement device in an embodiment;

[0088] Fig.17 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0089] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0090] The interval speed measurement method provided in the embodiment of the present application can be applied to Figure 1 In the distributed system 100 shown. The distributed system 100 includes a plurality of processing nodes 110 and a data storage system 120. The processing node 110 may be, but is not limited to, a personal computer, a laptop, a smart phone, a tablet computer, an Internet of Things device, and a server. The data storage system 120 may be a database or a database server. The data storage system is used to store the data generated by the processing node 110 executing the interval speed measurement method.

[0091] In an exemplary embodiment, Figure 2 As shown, a method for measuring speed within an interval is provided. Figure 1 The distributed system 100 in FIG. 1 (hereinafter, the reference numeral is omitted as the distributed system) is used as an example to illustrate the method, which includes the following steps 202 to 208. Among them:

[0092] Step 202, obtaining the vehicle destination record of the target vehicle in real time.

[0093] The vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle.

[0094] In implementation, checkpoints for interval speed measurement are set on the road sections where interval speed measurement is required. Different numbers of image acquisition devices are set on each checkpoint. The image acquisition devices collect image data in real time and transmit them to the distributed system. The distributed system obtains image data in real time and determines the vehicle interval record of the target vehicle from the image data. Then, the distributed system determines the vehicle starting point record and vehicle end point record of the target vehicle according to the configuration information of each interval and the vehicle interval record of the target vehicle. The distributed system updates the historical vehicle starting point record list based on the vehicle starting point record to obtain the vehicle starting point record list.

[0095] Step 204, query the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determine whether the vehicle end point record and the target vehicle starting point record meet the preset data validity condition.

[0096] The target vehicle starting point record indicates that the target vehicle passes the starting point of the interval corresponding to the vehicle starting point record. The data validity condition is that the second interval identifier in the target vehicle starting point record is consistent with the first interval identifier in the vehicle end point record.

[0097] In implementation, the distributed system searches for the target vehicle starting point record in the vehicle starting point record list based on the vehicle identifier. The distributed system searches for the target vehicle starting point record containing the vehicle identifier in the vehicle starting point record list. Then, the distributed system determines whether the second interval identifier in the target vehicle starting point record is consistent with the first interval identifier in the vehicle end point record.

[0098] In an exemplary embodiment, if there are continuous speed measurement intervals AB, AC and BC. For interval AB, the interval starting point is A and the interval end point is B. For interval AC, the interval starting point is A and the interval end point is C. For interval BC, the interval starting point is B and the interval end point is C. The vehicle end point record of the target vehicle includes the vehicle identification, the interval end point C, and the interval identification of the interval AC and BC where the interval end point C is located. The distributed system records the target vehicle starting point according to the vehicle identification. If the target vehicle passes through the interval starting point A and the interval starting point B, the target vehicle starting point record obtained by the distributed system includes a first target vehicle starting point record and a second target vehicle starting point record. Among them, the first target vehicle starting point record represents that the target vehicle passes through the interval starting point A. The second target vehicle starting point record represents that the target vehicle passes through the interval starting point B. Then, the distributed system determines whether the first target vehicle starting point record and the vehicle end point record meet the preset data validity conditions, and determines whether the second target vehicle starting point record and the vehicle end point record meet the preset data validity conditions.

[0099] In an optional embodiment, if the target vehicle starting point record is not found, the distributed system determines that the vehicle end point data is invalid data, and stores the vehicle end point record of the target vehicle in a dirty database. Then, the distributed system obtains the vehicle end point record of the next vehicle, and determines the next vehicle as the target vehicle. The distributed system executes step 204.

[0100] Step 206: When both the vehicle destination record and the target vehicle starting record meet the data validity condition, the interval driving record of the target vehicle is constructed according to the target vehicle starting record and the vehicle destination record.

[0101] In implementation, when both the vehicle destination record and the target vehicle starting record meet the data validity conditions, the distributed system merges the target vehicle starting record and the vehicle destination record to obtain the interval driving record of the target vehicle.

[0102] Step 208 : determining the interval speed of the target vehicle based on the interval distance, starting time, and ending time in the interval driving record.

[0103] The interval driving record includes the interval distance, the starting time when the target vehicle passes the starting point of the interval, and the ending time when the target vehicle passes the ending point of the interval.

[0104] In implementation, the distributed system calculates the interval speed of the target vehicle based on the interval distance, starting time and ending time in the interval driving record.

[0105] In an optional embodiment, if there is a first interval driving record and a second interval driving record in the interval driving record. The first interval driving record indicates that the target vehicle passes through interval AC, and the first interval driving record indicates that the target vehicle passes through interval BC. The distributed system calculates the interval speed of the target vehicle with respect to interval AC based on the interval distance, starting time, and end time of interval AC in the first interval driving record. The distributed system calculates the interval speed of the target vehicle with respect to interval BC based on the interval distance, starting time, and end time of interval BC in the second interval driving record.

[0106] In an exemplary embodiment, for the method of loading vehicle starting point records into the CDC (Change Data Capture) maintenance broadcast stream, the prior art is to read the vehicle starting point records from Oracle. Then, the vehicle starting point record data stream (the vehicle starting point record is transmitted in the form of a data stream, so it is called the vehicle starting point record data stream) is merged to obtain a vehicle starting point record list. However, there is a problem with the current method of obtaining vehicle starting point records, that is, it cannot guarantee that the data will be processed after the vehicle starting point record is loaded. For example, when the interval test program corresponding to the interval speed measurement method is started, the vehicle end point record data stream (the vehicle end point record is transmitted in the form of a data stream, so it is called the vehicle end point record data stream) has data flowing in, but at this time the vehicle starting point record data stream has not been loaded. At this time, some vehicle end point records cannot be associated with the vehicle starting point record, that is, some vehicle starting point records cannot query the corresponding target vehicle end point record, resulting in the problem of subsequent calculation data loss. In order to ensure that the vehicle starting point record arrives before the vehicle end point record, this application uses Flink (a standard real-time processing engine) state programming to solve this problem. Figure 3 An exemplary embodiment is provided. Figure 3 This is a schematic diagram of the interval vehicle association process, including:

[0107] Step 301: Load the left flow dimension table data.

[0108] In the implementation, the data in the left flow dimension table is the vehicle starting point record. The distributed system records the data flow of the vehicle starting point record.

[0109] Step 302: Dimension table data cache.

[0110] In implementation, the distributed system caches the vehicle starting point records to obtain a list of vehicle starting point records.

[0111] Step 303, record the last data recording time T1.

[0112] In the implementation, the distributed system records the latest loading time T1 of the vehicle starting point record. Every time a piece of data comes from the dimension table broadcast stream side, the distributed system needs to update the latest loading time T1.

[0113] Step 304, load the right stream real-time data.

[0114] In the implementation, the right stream real-time data is the vehicle destination record. The distributed system obtains the vehicle destination record.

[0115] Step 305, setting the current timestamp to T2.

[0116] In implementation, the distributed system determines the time for obtaining the vehicle endpoint record as T2.

[0117] Step 306: determine whether the second time difference between T1 and T2 is greater than a preset second time threshold N.

[0118] In implementation, the distributed system performs a difference operation on T2 and T2, and determines that the absolute value of the difference operation is the second time difference. Then, the distributed system determines whether the second time difference is greater than the preset second time threshold N. In the case where the second time difference is greater than the second time threshold N, the distributed system executes step 307. That is, when the difference between the latest loading time of the dimension table and the current time exceeds the specified time, the distributed system determines that all dimension table data has been loaded. Then, the distributed system executes step 307. In the case where the second time difference is less than or equal to the second time threshold N, the distributed system executes step 308.

[0119] Step 307: Join the two streams.

[0120] In implementation, the distributed system searches for the target vehicle starting point record in the vehicle starting point record list based on the vehicle identifier in the vehicle ending point record.

[0121] In an optional embodiment, if ListState caches a vehicle destination record, the distributed system obtains the vehicle destination record from ListState, and searches for the target vehicle starting point record in the vehicle starting point record list based on the vehicle identifier in the vehicle destination record.

[0122] Step 308, cache the right stream data ListState.

[0123] In implementation, the distributed system is pre-set with ListState, which is used to cache vehicle destination records. That is, when the dimension table is not loaded, the mainstream data is cached first. The distributed system defines the ListState state to save the first data in the mainstream. Then, the distributed system executes step 301 until the second time difference between T1 and T2 is greater than the preset second time threshold N.

[0124] Step 309, determine whether the Join Key matches.

[0125] In implementation, the distributed system determines whether the vehicle endpoint record and the target vehicle starting point record meet the preset data validity condition. If the vehicle endpoint record and the target vehicle starting point record meet the data validity condition, the distributed system executes step 311. If the vehicle endpoint record and the target vehicle starting point record do not meet the data validity condition, the distributed system executes step 310.

[0126] Step 310: output the unmatched data to a dirty database.

[0127] In implementation, the distributed system determines that a vehicle destination record has no matching target vehicle origin record and stores the vehicle destination record in a dirty database.

[0128] Step 311, output downstream.

[0129] In implementation, the distributed system constructs the target vehicle's interval driving record based on the vehicle's end point record and the target vehicle's start point record. Then, the distributed system determines the target vehicle's interval speed based on the interval distance, start time, and end time in the interval driving record.

[0130] In the above interval speed measurement method, the vehicle end record of the target vehicle is obtained in real time, and the target vehicle starting record corresponding to the vehicle end record is determined, so that the target interval passed by the target vehicle can be quickly determined. Then, data processing is performed on the vehicle end record and the target vehicle starting record to obtain the interval speed of the target vehicle, thereby improving the efficiency of the interval speed measurement method.

[0131] In an exemplary embodiment, Figure 4 As shown, the specific processing process of step 102 includes steps 402 to 408. Among them:

[0132] Step 402 , acquiring image data collected by each checkpoint image acquisition device in real time, and determining the vehicle section record corresponding to the target vehicle in the image data.

[0133] In implementation, checkpoints for interval testing are distributed on the road sections where the vehicle needs to be tested. Checkpoints are generally located at the starting point and the end point of the interval. In each checkpoint, there are an indefinite number of image acquisition devices. The image area acquired by the image acquisition device can completely cover the road section at the starting point of the interval or the road section at the end point of the interval. Each image acquisition device at each checkpoint collects image data of the vehicle passing through the starting point or the end point of the interval in real time, and transmits the collected image data to the distributed system. The distributed system performs image recognition processing on the image data for each frame of image data to obtain the vehicle interval record of the vehicle. Among them, the vehicle interval record includes the vehicle identification, image acquisition device number, checkpoint identification and acquisition time. The distributed system determines the vehicle interval record corresponding to the target vehicle based on the vehicle interval record of the current vehicle.

[0134] Optionally, the image acquisition device may be, but is not limited to, a camera or a still camera. The embodiment of the present application does not limit the image acquisition device.

[0135] Step 404 , performing deduplication processing on the vehicle interval records to obtain vehicle interval records that meet a preset deduplication condition.

[0136] In implementation, in order to avoid the repeated vehicle interval records generated by the vehicle repeatedly passing through the interval start point or the interval end point affecting the efficiency of the interval speed measurement method, it is necessary to perform deduplication processing on the vehicle interval records. The distributed system determines whether the vehicle interval record is a repeated vehicle interval record based on the acquisition time in the vehicle interval record. If the vehicle interval record is not a repeated vehicle interval record, the distributed system obtains a vehicle interval record that meets the preset deduplication condition. If the vehicle interval record is a repeated vehicle interval record, the distributed system discards the vehicle interval record and obtains the vehicle interval record of the next vehicle. The distributed system determines the vehicle interval record of the next vehicle as the vehicle interval record of the target vehicle and executes step 404.

[0137] In an exemplary embodiment, before deduplication processing is performed on the vehicle interval records, the distributed system filters the vehicle interval records based on preconfigured dirty data field rules to remove abnormal data in the vehicle interval records to obtain filtered vehicle interval records.

[0138] Step 406, extract the image acquisition device number in the vehicle interval record, and query the interval start point and interval end point of each interval configuration information based on the image acquisition device number to obtain the vehicle start point record and vehicle end point record of the target vehicle.

[0139] In implementation, the distributed system receives updated interval configuration information. The distributed system extracts the image acquisition device number in the vehicle interval record. The distributed system determines the first interval configuration information including the image acquisition device number in the interval start point of each interval configuration information, and determines the second interval configuration information including the image acquisition device number in the interval end point of each interval configuration information. Then, the distributed system constructs the vehicle start point record based on the first interval configuration information and the vehicle interval record. The distributed system constructs the vehicle end point record based on the second interval configuration information and the vehicle interval record.

[0140] In an optional embodiment, if the target vehicle only has a vehicle destination record, it indicates that the target vehicle has passed the checkpoint at the end of the interval. If the target vehicle only has a vehicle starting record, it indicates that the target vehicle has passed the checkpoint at the beginning of the interval. If the target vehicle has both a vehicle starting record and a vehicle destination record, it indicates that the target vehicle has passed through a continuous interval speed measurement section.

[0141] Step 408: Update the historical vehicle starting point record list based on the vehicle starting point record to obtain the vehicle starting point record list.

[0142] In implementation, the distributed system stores the vehicle starting point record in a historical vehicle starting point record list to obtain a vehicle starting point record list.

[0143] In this embodiment, the image data is collected by an image acquisition device, and the image data is processed to obtain the vehicle interval record of the target vehicle. The vehicle interval record can be obtained by only using the image acquisition device, which reduces the hardware requirements of the interval speed measurement method. In addition, the vehicle starting point record and the vehicle end point record are determined respectively through the vehicle interval record, which can adapt to the interval speed measurement solution under different road scenes, and expand the scope of application of the interval speed measurement method.

[0144] In an exemplary embodiment, Figure 5 As shown, the specific processing process of step 404 includes steps 502 to 506. Among them:

[0145] Step 502: Search the history table for the history vehicle interval record according to the vehicle interval identifier in the vehicle interval record.

[0146] The vehicle interval identification includes the vehicle identification and the checkpoint identification. The checkpoint identification is the interval end identification and the interval start identification.

[0147] In implementation, the distributed system extracts the vehicle identifier and the checkpoint identifier in the vehicle interval record to obtain the vehicle interval record. Then, the distributed system searches the history table for the history vehicle interval record according to the vehicle interval identifier. The history vehicle interval record contains the same vehicle interval identifier as the vehicle interval record.

[0148] Step 504: If there is a historical vehicle interval record, determine whether a first time difference between the historical vehicle interval record and the vehicle interval record is greater than or equal to a preset first time threshold.

[0149] In implementation, if there is a historical vehicle interval record in the history table, the distributed system determines the second collection time of the historical vehicle interval record and determines the first collection time of the vehicle interval record. Then, the distributed system performs a difference operation on the second collection time and the first collection time, and performs an absolute value operation on the result after the difference operation to obtain a first time difference. Then, the distributed system determines whether the first time difference is greater than or equal to a preset first time threshold.

[0150] In an optional embodiment, when the first time difference is less than a preset first time threshold, the distributed system determines that the vehicle interval record is a duplicate vehicle interval record. Then, the distributed system discards the vehicle interval record and obtains the vehicle interval record of the next vehicle. The distributed system determines the vehicle interval record of the next vehicle as the vehicle interval record of the target vehicle and executes step 502.

[0151] Optionally, the first time threshold is determined based on an interval speed measurement requirement, and the embodiment of the present application does not limit the first time threshold.

[0152] Step 506 , when the first time difference is greater than or equal to the first time threshold or there is no historical vehicle interval record, it is determined that the vehicle interval record meets a preset deduplication condition, and a vehicle interval record that meets the deduplication condition is obtained.

[0153] In implementation, when the first time difference is greater than or equal to the first time threshold or there is no historical vehicle interval record, the distributed system determines that the vehicle interval record meets the preset deduplication condition, that is, the distributed system determines that the vehicle interval record is not a duplicate vehicle interval record. Then, the distributed system obtains the vehicle interval record that meets the deduplication condition.

[0154] In an exemplary embodiment, if Figure 6 As shown, Figure 6 The flowchart of performing deduplication processing on vehicle interval records in one embodiment includes:

[0155] Step 601, loading fact stream data.

[0156] In implementation, the distributed system obtains the vehicle interval record of the target vehicle. Then, the distributed system extracts the vehicle interval identifier in the vehicle interval record to obtain KEY{HPHM_KKBH}, where KEY represents the key value and HPHM_KKBH represents the vehicle interval identifier.

[0157] Step 602, query KEY Map State.

[0158] In implementation, a KEY Map State is pre-set in the distributed system, and the KEY Map State is a history table. The KEY Map State is used to store multiple vehicle interval records. The distributed system queries the historical vehicle interval records in the KEY Map State according to the vehicle interval identifier.

[0159] Step 603, determine whether KEY exists.

[0160] In implementation, the distributed system determines whether a historical vehicle interval record exists. If a historical vehicle interval record exists, the distributed system obtains the vehicle passing time (collection time) of the vehicle interval record and executes step 604. If no historical vehicle interval record exists, the distributed system executes step 609.

[0161] Step 604, determine whether the KEY validity period | is T2-T1| <N

[0162] In implementation, the distributed system determines that the collection time of the vehicle interval record is T2, and determines that the collection time of the historical vehicle interval record is T1. Then, the distributed system performs a difference operation on T2 and T1, and determines that the absolute value of the difference operation is the first time difference. The distributed system determines whether the first time difference is less than a preset first time threshold T1. If the first time difference is less than the first time threshold, the distributed system executes step 606. If the first time difference is greater than or equal to the first time threshold, the distributed system executes step 605.

[0163] Step 605: output the downstream operator.

[0164] In implementation, the distributed system determines that the vehicle interval record meets a preset deduplication condition.

[0165] Step 606: discard the data stream.

[0166] In implementation, the distributed system discards the vehicle interval record.

[0167] Step 607: bypass output to the history table.

[0168] In implementation, the distributed system stores the vehicle interval record in a history table and executes step 601 .

[0169] Step 608, determine that the Key is HPHM_KKBH and the Value is the vehicle passing time.

[0170] In the implementation, the distributed system determines HPHM_KKBH as the Key and the vehicle passing time as the Value (attribute). Then, the distributed system stores the vehicle interval record in the form of KV in the KEY Map State.

[0171] Step 609, status clearing.

[0172] In implementation, the distributed system periodically clears the data in the KEY Map State.

[0173] Figure 6 A real-time deduplication logic based on state storage is demonstrated. The deduplication logic supports operations such as adding, modifying, and deleting topic fields in Kafka (an open source stream processing platform) after splicing according to a certain key combination. The distributed system reads each record in the Kafka topic and deserializes the record. The distributed system extracts the deduplication field information in the deserialized record and determines whether the state with the spliced ​​field as the key exists. If the state with the key does not exist, the distributed system adds the state for the first time. If the state with the key exists, the distributed system determines that it is duplicate data based on the key and deletes it, that is, bypasses it and outputs it to the history table, and does not propagate it in the normal data stream. At the same time, a timed state clearing design is added to the state storage system to prevent the state from being deleted after expiration and occupying memory.

[0174] In this embodiment, by deduplicating vehicle interval records, vehicle interval records that meet deduplication conditions are obtained, which solves the problem of various deliberate avoidance of interval speed measurement in industry scenarios, reduces the time for processing vehicle interval records, and improves the efficiency of interval speed measurement.

[0175] In an exemplary embodiment, before determining the vehicle starting point record and the vehicle end point record based on the interval configuration information, the interval configuration information needs to be constructed first. Figure 7 As shown, the specific processing process of step 404 includes steps 702 to 710. Among them:

[0176] Step 702: In response to a request to configure target interval configuration information, a configuration page including an interval configuration template is displayed.

[0177] The interval configuration template includes an initial interval start point and an initial interval end point.

[0178] In implementation, the distributed system is pre-set with an interval configuration template. When new interval configuration information is needed, the management personnel initiate a request to configure the target interval configuration information to the distributed system by operating the management platform of the distributed system. In response to the request to configure the target interval configuration information, the distributed system displays a configuration page containing the interval configuration template.

[0179] Step 704: In response to the determination operation of the first target checkpoint at the starting point of the initial interval, the first target checkpoint is determined as the starting point of the target interval.

[0180] The starting point of the initial interval includes various checkpoints, and each checkpoint includes information such as a checkpoint address, a checkpoint identifier, and an image acquisition device associated with the checkpoint.

[0181] In implementation, the management personnel determine the first target checkpoint among the checkpoints based on the speed measurement requirements of the interval. In response to the determination operation of the first target checkpoint at the starting point of the initial interval, the distributed system determines the first target checkpoint as the starting point of the target interval.

[0182] Step 706: In response to the determination operation of the second target checkpoint at the end point of the initial interval, the second target checkpoint is determined as the end point of the target interval.

[0183] The end point of the initial interval includes various checkpoints, and each checkpoint includes information such as a checkpoint address, a checkpoint identifier, and an image acquisition device associated with the checkpoint.

[0184] In implementation, the management personnel determine the second target checkpoint in each checkpoint based on the speed measurement requirement of the interval. In response to the determination operation of the second target checkpoint at the end point of the initial interval, the distributed system determines the second target checkpoint as the end point of the target interval.

[0185] Step 708: In response to the determination operation of the target configuration information in the interval configuration template, the target interval configuration information is constructed based on the target configuration information, the target interval start point and the target interval end point.

[0186] In implementation, after determining the target interval start point and the target interval end point, the administrator inputs the target configuration information of the target interval. The target configuration information includes an interval profile, interval speed limit information, etc. After inputting the target configuration information, the administrator performs an operation of determining the target configuration information in the interval configuration template to the distributed system. In response to the determination operation of the target configuration information in the interval configuration template, the distributed system constructs the target interval configuration information based on the target configuration information, the target interval start point and the target interval end point.

[0187] Step 710: Update the target interval configuration information to the database through real-time log access technology, and synchronize the target interval configuration information.

[0188] In the implementation, the distributed system updates the target interval configuration information to the database through the CDC real-time log access technology to obtain the updated configuration information of each interval. Then, the distributed system synchronizes the target interval configuration information to each node in the distributed system in the form of data stream.

[0189] In an exemplary embodiment, in order to clarify the congestion of the road, it is necessary to obtain the interval speed of different sections on the road. Therefore, it is necessary to set up multiple sections on the road and flexibly configure the interval configuration information of the sections. In the face of the demand for mobile interval speed measurement, it is necessary to constantly change the sections that need to be measured, which also requires flexible configuration of the interval configuration information of the sections. Because, in order to realize the flexible configuration of interval configuration information, this application manages the sections of the interval speed measurement in a unified visual interface, including the section name, the starting point of the section, the end point of the section, the interval distance, the speed limit value of the large vehicle in the section, the speed limit value of the small vehicle in the section, etc. According to the registered checkpoint, the starting and ending points can be freely selected. The camera under the checkpoint can be specifically selected to a certain road or a combination of several cameras, and the interval distance and speed limit can be set; different speed limits can also be set for different vehicle models and license plate colors, and the interval speed measurement system automatically calculates the standard time and the speeding ratio of different intervals. And support visual configuration of abnormal data push thresholds (including traffic integrated command platform, application client, etc.). Support dynamic setting and real-time effectiveness of interval rules. Based on the above configuration, the currently supported interval types include A->B, B->C continuous section intervals, A->C, B->C multiple sections with the same end point, A->B, A->C multiple sections with the same starting point, etc. This application provides a visual one-click operation for configuration operations such as adding, modifying, and deleting intervals, and the changes take effect immediately. It also supports the combined configuration of cameras between any camera ports, with no upper limit on the number of intervals, and the computing resources can be automatically scaled with the number of intervals, which can realize the flexible configuration of a large number of interval configuration information. Figure 8 It is a diagram of a UI (User Interface) for dynamic configuration of intervals in an exemplary embodiment.

[0190] In this embodiment, the target interval start point and the target interval end point are determined based on the interval configuration template, and the target configuration information is configured. Then, the target interval configuration information is constructed according to the target interval start point, the target interval end point and the target configuration information, so as to realize the fast and flexible configuration of the target interval configuration information and expand the application scope of the interval speed measurement method.

[0191] In an exemplary embodiment, Fig. 9 As shown, the specific processing process of step 406 includes steps 902 to 906. Among them:

[0192] Step 902, query at the interval starting point of each interval configuration information based on the image acquisition device number to obtain the first interval configuration information including the image acquisition device number, and construct the vehicle starting point record of the target vehicle based on the first interval configuration information and the vehicle interval record.

[0193] In implementation, the distributed system searches the interval starting point of each interval configuration information according to the image acquisition device number to obtain the first interval configuration information including the image acquisition device number. The first interval configuration information includes an interval identifier and an interval starting point identifier. Then, the distributed system constructs the vehicle starting point record of the target vehicle according to the first interval configuration information and the vehicle interval record.

[0194] In an optional embodiment, if the image acquisition device number appears in the interval starting point in one or more interval configuration information, that is, the image acquisition device number appears in the interval configuration starting point list one or more times, indicating that the same image acquisition device is the starting point of multiple intervals, then multiple first interval configuration information are corresponding. The distributed system constructs a vehicle starting point record of the target vehicle based on each first interval configuration information and vehicle interval record. The distributed system obtains multiple vehicle starting point records of the target vehicle.

[0195] Step 904: query at the end point of each interval configuration information based on the image acquisition device number to obtain second interval configuration information including the image acquisition device number.

[0196] In implementation, the distributed system searches the interval end points of each interval configuration information according to the image acquisition device number to obtain the second interval configuration information including the image acquisition device number, wherein the second interval configuration information includes an interval identifier and an interval end identifier.

[0197] Step 906: construct a vehicle destination record of the target vehicle based on the second interval configuration information and the vehicle interval record.

[0198] In implementation, the distributed system constructs a vehicle destination record of the target vehicle according to the second interval configuration information and the vehicle interval record.

[0199] In an optional embodiment, if the image acquisition device number appears in the interval starting point in one or more interval configuration information, that is, the image acquisition device number appears in the interval configuration starting point list one or more times, indicating that the same image acquisition device is the starting point of multiple intervals, then multiple first interval configuration information are corresponding. The distributed system constructs a vehicle starting point record of the target vehicle based on each first interval configuration information and vehicle interval record. The distributed system obtains multiple vehicle starting point records of the target vehicle.

[0200] In an exemplary embodiment, Fig.10The real-time interval start and end point diversion algorithm shown adopts a hypothesis testing idea. When a vehicle passes through a camera under a checkpoint at the end point, it is not clear where the vehicle starts. Therefore, the search interval configuration table is searched to see how many interval segments there are with the camera as the end point. This is used to prune the search matching intervals, and then compare them one by one in the limited interval list to find the real starting point and complete the match. Fig.10 A flow chart of real-time flow distribution of the start and end points of an interval in an embodiment includes:

[0201] Step 1001, obtaining a vehicle passing data stream.

[0202] In implementation, the vehicle passing data stream is a vehicle interval record, and the distributed system obtains the vehicle interval record.

[0203] Step 1002, extract the camera number.

[0204] In implementation, the image acquisition device is a camera, and the distributed system extracts the camera number from the vehicle interval record.

[0205] Step 1003: Obtain interval dimension table data stream.

[0206] In implementation, the distributed system receives the latest dimension table data stream and obtains updated configuration information of each interval.

[0207] Step 1004, query the start and end data streams.

[0208] In implementation, the distributed system queries the interval start point and the interval end point in the interval dimension table data stream according to the camera number to obtain the start and end point data streams.

[0209] Step 1005, determine the left stream endpoint data

[0210] In implementation, the distributed system determines the endpoint data in the start-end data stream to obtain the right stream endpoint data, which is the vehicle endpoint record of the target vehicle.

[0211] Step 1006, determine the right stream starting point data.

[0212] In implementation, the distributed system determines the starting point data in the starting and ending point data streams to obtain the left stream starting point data. The left stream starting point data is the vehicle starting point record of the target vehicle.

[0213] Step 1007: Join the two streams.

[0214] In implementation, the distributed system updates the historical vehicle starting point record list according to the vehicle starting point record of the target vehicle to obtain the vehicle starting point record list. Then, the distributed system determines the starting point record of the target vehicle in the vehicle starting point record list according to the vehicle identifier in the vehicle end point record of the target vehicle.

[0215] Step 1008, determine whether the Join Key matches.

[0216] In implementation, the distributed system determines whether the vehicle endpoint record and the target vehicle starting point record meet the preset data validity condition. If the vehicle endpoint record and the target vehicle starting point record meet the data validity condition, the distributed system executes step 1010. If the vehicle endpoint record and the target vehicle starting point record do not meet the data validity condition, the distributed system executes step 1009.

[0217] Step 1009: output the unmatched data to a dirty database.

[0218] In implementation, the distributed system determines that a vehicle destination record has no matching target vehicle origin record and stores the vehicle destination record in a dirty database.

[0219] Step 1010, output the downstream operator.

[0220] In implementation, the distributed system constructs the target vehicle's interval driving record based on the vehicle's end point record and the target vehicle's start point record. Then, the distributed system determines the target vehicle's interval speed based on the interval distance, start time, and end time in the interval driving record.

[0221] In this embodiment, the vehicle starting point record and the vehicle end point record are determined respectively by the image acquisition device number, which solves various ways of deliberately avoiding interval speed measurement, expands the interval speed measurement range covered by the interval speed measurement algorithm, and expands the scope of use of the interval speed measurement method.

[0222] In an exemplary embodiment, Fig.11 As shown, the determination of whether the vehicle destination record and the target vehicle starting point record meet the preset data validity condition in step 204 includes steps 1102 to 1106. Among them:

[0223] Step 1102, determining a first interval identifier in the vehicle destination record, and determining a second interval identifier in the target vehicle start record.

[0224] In implementation, the distributed system extracts the first interval identifier in the vehicle's destination record, and extracts the second interval identifier in the target vehicle's start point record.

[0225] In an optional embodiment, if there are multiple target vehicle starting point records, the distributed system extracts the second interval identifier in the target vehicle starting point record for each target vehicle starting point record.

[0226] Step 1104: determine whether the first interval identifier and the second interval identifier are consistent.

[0227] In implementation, the distributed system determines whether the first interval identifier and the second interval identifier are consistent.

[0228] In an optional embodiment, if the first interval identifier and the second interval identifier are inconsistent, the distributed system determines that the vehicle terminal record and the target vehicle starting point record do not meet the preset data validity condition. Then, the distributed system stores the vehicle terminal record in the dirty database.

[0229] Step 1106: If the first interval identifier and the second interval identifier are consistent, determine that the vehicle end record and the target vehicle start record meet a preset data validity condition.

[0230] In implementation, if the first interval identifier and the second interval identifier are consistent, the distributed system determines that the vehicle endpoint record and the target vehicle start point record meet a preset data validity condition.

[0231] In this embodiment, by judging whether the first interval identifier in the vehicle destination record is consistent with the second interval identifier in the target vehicle starting record, it is determined whether the target vehicle passes through the same interval, which facilitates the subsequent construction of the interval driving record of the target vehicle.

[0232] In an exemplary embodiment, Fig.12 As shown, when the vehicle end record and the target vehicle starting record do not meet the data validity condition, it is necessary to obtain the vehicle end record of the next vehicle and process it. After step 1104 is executed, the specific processing process of the interval speed measurement method also includes steps 1202 to 1204. Among them:

[0233] Step 1202: When the vehicle destination record and the target vehicle starting point record do not meet the data validity condition, obtain the vehicle destination record of the next vehicle.

[0234] In implementation, when the vehicle destination record and the target vehicle starting point record do not meet the data validity condition, the distributed system determines that the vehicle destination record is mismatched data. Then, the distributed system obtains the vehicle destination record of the next vehicle.

[0235] Step 1204, determining the vehicle destination record of the next vehicle as the vehicle destination record of the target vehicle, and executing the step of searching the vehicle starting point record list for the target vehicle according to the vehicle identification.

[0236] In implementation, the distributed system determines the vehicle destination record of the next vehicle as the vehicle destination record of the target vehicle. Then, the distributed system executes step 204. The specific implementation process of step 204 has been described in detail in the above embodiment, and the embodiment of this application will not be repeated here.

[0237] In this embodiment, when the vehicle destination record and the target vehicle starting point record do not meet the data validity condition, the vehicle destination record of the next vehicle is obtained and the interval speed measurement method is executed, thereby improving the execution efficiency of the interval speed measurement method.

[0238] In an exemplary embodiment, Fig.13 As shown, after obtaining the interval speed, it is necessary to determine whether the target vehicle is speeding based on the interval speed and perform subsequent processing. After step 208 is executed, the specific processing process of the interval speed measurement method also includes steps 1302 to 1308. Among them:

[0239] Step 1302, determining whether the interval speed of the target vehicle is greater than a preset prescribed speed.

[0240] In implementation, the distributed system determines the interval identifier in the interval driving record. Then, the distributed system determines the prescribed vehicle speed of the interval represented by the interval identifier based on the interval identifier. The distributed system determines whether the interval speed of the target vehicle is greater than the prescribed vehicle speed.

[0241] In an optional embodiment, when the target vehicle's interval speed is less than or equal to the specified speed, the distributed system determines that the target vehicle's speeding result is not speeding, and stores the interval driving record and speeding result in the database. When it is necessary to determine the interval congestion situation, the distributed system obtains the interval driving record and speeding result of each vehicle from the database, and performs data processing to obtain the congestion result of the interval.

[0242] Step 1304, when the interval speed is greater than the prescribed speed, a speeding record of the target vehicle is constructed based on the interval driving record and the interval speed, and the speeding record is fed back to the owner of the target vehicle and the cloud.

[0243] Among them, speeding records are used for speeding analysis in the cloud.

[0244] In implementation, when the interval speed is greater than the specified speed, the distributed device constructs the speeding record of the target vehicle based on the interval driving record and the interval speed. Then, the distributed system determines the contact information of the owner of the target vehicle based on the vehicle identification in the interval driving record. Based on the contact information of the owner of the target vehicle, the distributed system feeds back the speeding record to the target vehicle and feeds back the speeding record to the cloud at the same time.

[0245] In an optional embodiment, the distributed system stores the speeding records in a database. When faced with the need to analyze the speeding situation, the distributed system obtains a large number of speeding records from the database, and processes the data of each speeding record to obtain a speeding analysis result.

[0246] Step 1306, determining whether the interval speed reaches a preset abnormal speed.

[0247] In implementation, an abnormal speed is preset in the distributed system, and the distributed system determines whether the interval speed reaches the preset abnormal speed.

[0248] Optionally, the abnormal speed is generally set to 1.2 times the prescribed speed, and may also be set according to speed measurement requirements. The embodiment of the present application does not limit the abnormal speed.

[0249] Step 1308: If the interval speed reaches the abnormal speed, an abnormal record of the target vehicle is constructed according to the interval driving record and the interval speed, and the abnormal record of the target vehicle is fed back to the target user.

[0250] In implementation, if the interval speed reaches an abnormal speed, the distributed system constructs an abnormal record of the target vehicle based on the interval driving record and interval speed. Then, the distributed system feeds back the abnormal record of the target vehicle to the target user, who is the staff of the traffic station near the interval.

[0251] In an exemplary embodiment, the interval speed terminal application solution includes the following parts: the abnormal data and abnormal evidence such as slices generated by the interval speed measurement are stored in a relational database and an object storage respectively. At the same time, the abnormal results are pushed to the vehicle owner's mobile client and traffic client in real time. Currently, the following three types of scenario applications are supported:

[0252] 1. Real-time interval holographic alarm portrait construction, for all configured intervals, real-time monitoring and display of data in different dimensions, such as the speeding ratio distribution, speeding vehicle model distribution, speeding time distribution, speeding vehicle brand distribution, etc. in each interval.

[0253] 2. Real-time warning and push notification of abnormal speeding behavior. When a vehicle leaves the end of a section, the real-time speed of the section belonging to the vehicle has been calculated and pushed to the user's mobile client. The push content includes the section distance, the time when the vehicle passes through the starting and ending points of the section, the speed limit value of the section, the standard time of the section, the speeding ratio, the pictures of the vehicles passing through the starting and ending points of the section, and the synthesized abnormal evidence pictures, which are presented on the customer's mobile phone as evidence to warn and educate the driver.

[0254] 3. Build a speeding induction screen. For speeding vehicles, the real-time interval speed will be pushed to the staff at the traffic station near the end of the interval. The push range can be flexibly set according to the speeding ratio, fully mobilize police resources to stop abnormal vehicles as soon as possible, and provide on-site education to the drivers.

[0255] In this embodiment, when the interval speed reaches the specified speed, the speeding record of the target vehicle is sent to the owner of the target vehicle, so that the owner of the target vehicle can clearly understand the speeding situation. In addition, when the interval speed reaches the abnormal speed, the abnormal record of the target vehicle is fed back to the target user, so that the target user can perform subsequent processing, which improves the convenience of the interval speed measurement method. In addition, the push reminder method after the interval abnormality allows the abnormal person to receive a warning in the first time, and also allows the traffic staff to conduct abnormal publicity and education in the first time. The high timeliness brings benefits to both the traffic staff and the abnormal person.

[0256] In an exemplary embodiment, Fig.14 A schematic flow chart of an interval testing method in another embodiment includes:

[0257] Step 1401, dirty data detection.

[0258] During implementation, after the source Kafka vehicle passing data is connected in real time, the distributed system filters out related abnormal data based on the dirty data field rules configured in the interface, such as the license plate number is empty, the vehicle type is empty, the passing time exceeds the threshold range, and other dirty data, and obtains the vehicle interval record.

[0259] Step 1402, real-time deduplication.

[0260] In implementation, after the vehicle passing data stream (vehicle interval record data stream) enters the system, it is associated with the data stream (interval configuration information data stream) accessed by the CDC. The distributed system uses a custom state storage structure to perform real-time deduplication calculations on the vehicle passing data at the same checkpoint of the same vehicle. Deduplication scenario 1 is that a piece of vehicle passing data at the same checkpoint of the same vehicle is uploaded repeatedly. Scenario 2 is that multiple vehicle passing data are generated by multiple groups of cameras at the same checkpoint of the same vehicle.

[0261] Step 1403: Interval configuration information flow

[0262] In the implementation, managers use the interval configuration interface of the distributed system to select the camera number according to the card port number and configure the relevant attributes of the interval, such as direction, distance, and speed limit. The speed limit can be dynamically configured according to the type of vehicle or license plate passing through the interval. All interface configuration rules can be changed and accessed in milliseconds through CDC real-time log access technology, truly achieving real-time changes and real-time applications.

[0263] Step 1404: Divide the traffic flow at the starting and ending points of the interval.

[0264] In implementation, the distributed system configures the real-time information flow according to the accessed interval, extracts the camera number in the current vehicle passing data, and scans the configuration information flow to find out whether the camera belongs to the interval start point or the interval end point. Then, the distributed system will mark the start and end points with different labels and send them downstream.

[0265] Step 1405: interval vehicle association algorithm.

[0266] In the implementation, the distributed system processes the start and end double flows flowing in from the upstream separately. Specifically, the distributed system stores the state of the start flow, and triggers the interval matching calculation after the end flow flows in, performs a hash search according to the specified key, and matches the start information belonging to the end point. After completing the matching, the distributed system calculates the overspeed ratio and other information.

[0267] Step 1406, terminal application solution.

[0268] In implementation, the specific processing process of step 1406 has been described in detail in the above steps 1302 to 1308, and will not be repeated here in the embodiment of the present application.

[0269] In an exemplary embodiment, Fig.15 This is a schematic diagram of the data flow changes for this application. Fig.15 In the process, the distributed system receives the vehicle interval records in the message queue in real time, and performs dirty data filtering on the vehicle interval records to obtain the vehicle passing data stream (vehicle interval record). After the vehicle passing data stream is deduplicated, the deduplicated process data stream is processed based on the interval configuration information stream to obtain the interval starting point data stream (vehicle starting point record) and the interval end point data stream (vehicle end point record). The distributed system matches the interval end point data stream with the interval starting point data stream to obtain the interval driving record. The distributed system applies the interval driving record to various scenarios, including RDBMS (Relational Database Management System), OSS (Operation Support Systems System), user end, and traffic end. The distributed system includes various nodes, and each node can execute all or part of the steps in the above embodiment. For example, the first node executes the above step 404 to obtain the vehicle interval record that meets the preset deduplication condition, and transmits the vehicle interval record that meets the preset deduplication condition to the second node. The second node executes the above step 406 to obtain the vehicle starting point record and vehicle end point record of the target vehicle.

[0270] It should be understood that, although the steps in the flowcharts involved in the above embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps is not strictly limited in order, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above embodiments may include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0271] Based on the same inventive concept, the embodiment of the present application also provides an interval speed measurement device for implementing the interval speed measurement method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in one or more interval speed measurement device embodiments provided below can refer to the limitations of the interval speed measurement method above, and will not be repeated here.

[0272] In an exemplary embodiment, Fig.16 As shown, a speed measuring device 1600 is provided, including: an acquisition module 1601, a query module 1602, a judgment module 1603 and a determination module 1604, wherein:

[0273] The acquisition module 1601 is used to acquire the vehicle destination record of the target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle.

[0274] The query module 1602 is used to query the target vehicle starting point record in the vehicle starting point record list according to the vehicle identification, and determine whether the vehicle end point record and the target vehicle starting point record meet the preset data validity condition.

[0275] The judgment module 1603 is used to construct the interval driving record of the target vehicle according to the target vehicle starting point record and the vehicle end point record when both the vehicle end point record and the target vehicle starting point record meet the data validity condition.

[0276] The determination module 1604 is used to determine the interval speed of the target vehicle based on the interval distance, the starting time and the ending time in the interval driving record.

[0277] In an exemplary embodiment, the acquisition module 1602 includes:

[0278] The first acquisition submodule is used to acquire the image data collected by each checkpoint image acquisition device in real time, and determine the vehicle interval record corresponding to the target vehicle in the image data.

[0279] The first processing submodule is used to perform deduplication processing on the vehicle interval records to obtain vehicle interval records that meet preset deduplication conditions.

[0280] The first query submodule is used to extract the image acquisition device number in the vehicle interval record, and based on the image acquisition device number, query the interval start point and interval end point of each interval configuration information to obtain the vehicle start point record and vehicle end point record of the target vehicle.

[0281] The first updating submodule is used to update the historical vehicle starting point record list based on the vehicle starting point record to obtain the vehicle starting point record list.

[0282] In an exemplary embodiment, the first processing submodule includes:

[0283] The second query submodule is used to query the historical vehicle interval record in the history table according to the vehicle interval identifier in the vehicle interval record.

[0284] The first judgment submodule is used to judge whether a first time difference between the historical vehicle interval record and the vehicle interval record is greater than or equal to a preset first time threshold if there is a historical vehicle interval record.

[0285] The first determination submodule is used to determine whether the vehicle interval record meets a preset deduplication condition when the first time difference is greater than or equal to a first time threshold or there is no historical vehicle interval record, and obtain the vehicle interval record that meets the deduplication condition.

[0286] In an exemplary embodiment, the interval speed measurement device 1600 further includes:

[0287] The first display module is used to display a configuration page including an interval configuration template in response to a request for configuring target interval configuration information; the interval configuration template includes an initial interval start point and an initial interval end point.

[0288] The second determination module is configured to determine the first target checkpoint as the starting point of the target interval in response to the determination operation of the first target checkpoint at the starting point of the initial interval.

[0289] The third determination module is used to determine the second target checkpoint as the target interval end point in response to the determination operation of the second target checkpoint at the end point of the initial interval.

[0290] The first construction module is used to construct the target interval configuration information based on the target configuration information, the target interval start point and the target interval end point in response to the determination operation of the target configuration information in the interval configuration template.

[0291] The first updating module is used to update the target interval configuration information into the database through the real-time log access technology, and synchronize the target interval configuration information.

[0292] In an exemplary embodiment, the first query submodule includes:

[0293] The third query submodule is used to query the interval starting point of each interval configuration information based on the image acquisition device number, obtain the first interval configuration information including the image acquisition device number, and construct the vehicle starting point record of the target vehicle based on the first interval configuration information and the vehicle interval record.

[0294] The fourth query submodule is used to query at the end point of each interval configuration information based on the image acquisition device number to obtain the second interval configuration information including the image acquisition device number.

[0295] The first construction submodule is used to construct a vehicle destination record of the target vehicle based on the second interval configuration information and the vehicle interval record.

[0296] In an exemplary embodiment, the determination module 1603 includes:

[0297] The second determination submodule is used to determine the first interval identifier in the vehicle end point record and determine the second interval identifier in the target vehicle start point record.

[0298] The second determination submodule is used to determine whether the first interval identifier and the second interval identifier are consistent.

[0299] The third determination submodule is configured to determine that the vehicle endpoint record and the target vehicle start point record meet a preset data validity condition if the first interval identifier and the second interval identifier are consistent.

[0300] In an exemplary embodiment, the interval speed measurement device 1600 further includes:

[0301] The second acquisition module is used to acquire the vehicle destination record of the next vehicle when the vehicle destination record and the target vehicle starting point record do not meet the data validity condition.

[0302] The fourth determination module is used to determine the vehicle destination record of the next vehicle as the vehicle destination record of the target vehicle, and execute the step of searching the vehicle starting point record list for the target vehicle according to the vehicle identification.

[0303] In an exemplary embodiment, the interval speed measurement device 1600 further includes:

[0304] The second judgment module is used to judge whether the interval speed of the target vehicle is greater than a preset prescribed speed.

[0305] The second construction module is used to construct a speeding record of the target vehicle based on the interval driving record and the interval speed when the interval speed is greater than the specified vehicle speed, and to feed back the speeding record to the owner of the target vehicle and the cloud; the speeding record is used for speeding analysis in the cloud.

[0306] The third judgment module is used to judge whether the interval speed reaches a preset abnormal speed.

[0307] The third building module is used to build an abnormal record of the target vehicle according to the interval driving record and the interval speed if the interval speed reaches the abnormal speed, and feed back the abnormal record of the target vehicle to the target user.

[0308] Each module in the above-mentioned interval speed measurement device can be implemented in whole or in part by software, hardware and a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to each module above.

[0309] In an exemplary embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. Fig.17 As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface, the display unit and the input device are connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be implemented through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a method for measuring speed in an interval is implemented. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0310] Those skilled in the art will understand that Fig.17The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0311] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0312] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0313] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0314] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0315] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0316] The technical features of the above embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0317] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be construed as limiting the scope of the present application. It should be noted that, for a person of ordinary skill in the art, several modifications and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A method for measuring speed in intervals, characterized in that: The method comprises: Acquire the vehicle destination record of the target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle; When the time difference between the latest loading time of the vehicle endpoint record and the latest loading time of the vehicle starting point record is greater than a preset second time threshold, query the target vehicle starting point record in the vehicle starting point record list according to the vehicle identifier, and determine whether the vehicle endpoint record and the target vehicle starting point record meet a preset data validity condition; the data validity condition is that the second interval identifier in the target vehicle starting point record is consistent with the first interval identifier in the vehicle endpoint record; In the case where both the vehicle endpoint record and the target vehicle starting record satisfy the data validity condition, constructing the interval driving record of the target vehicle according to the target vehicle starting record and the vehicle endpoint record; The interval speed of the target vehicle is determined based on the interval distance, the starting time and the ending time in the interval driving record.

2. The method according to claim 1, characterized in that The real-time acquisition of the vehicle destination record of the target vehicle includes: Acquire image data collected by each camera image acquisition device in real time, and determine the vehicle interval record corresponding to the target vehicle in the image data; Deduplication processing is performed on the vehicle interval records to obtain the vehicle interval records that meet a preset deduplication condition; Extracting the image acquisition device number in the vehicle interval record, and querying the interval start point and the interval end point of each interval configuration information based on the image acquisition device number to obtain the vehicle start point record and the vehicle end point record of the target vehicle; A historical vehicle starting point record list is updated based on the vehicle starting point record to obtain a vehicle starting point record list.

3. The method according to claim 2, characterized in that The performing deduplication processing on the vehicle interval record to obtain the vehicle interval record that meets a preset deduplication condition includes: According to the vehicle interval identifier in the vehicle interval record, query the historical vehicle interval record in the history table; If the historical vehicle interval record exists, determining whether a first time difference between the historical vehicle interval record and the vehicle interval record is greater than or equal to a preset first time threshold; When the first time difference is greater than or equal to the first time threshold or the historical vehicle interval record does not exist, it is determined that the vehicle interval record meets a preset deduplication condition, and the vehicle interval record that meets the deduplication condition is obtained.

4. The method according to claim 2, characterized in that: Before extracting the image acquisition device number in the vehicle interval record, the method further includes: In response to a request to configure target interval configuration information, display a configuration page including an interval configuration template; the interval configuration template includes an initial interval start point and an initial interval end point; In response to a determination operation of a first target checkpoint at the starting point of the initial interval, determining the first target checkpoint as the starting point of the target interval; In response to a determination operation of a second target checkpoint at the end point of the initial interval, determining the second target checkpoint as the end point of the target interval; In response to a determination operation of the target configuration information in the interval configuration template, constructing the target interval configuration information based on the target configuration information, the target interval start point and the target interval end point; The target interval configuration information is updated to the database through real-time log access technology, and the target interval configuration information is synchronized.

5. The method according to claim 2, characterized in that: The method of querying the interval start point and the interval end point of each interval configuration information based on the image acquisition device number to obtain the vehicle start point record and the vehicle end point record of the target vehicle includes: Based on the image acquisition device number, query at the interval starting point of each interval configuration information to obtain the first interval configuration information including the image acquisition device number, and construct the vehicle starting point record of the target vehicle based on the first interval configuration information and the vehicle interval record; Based on the image acquisition device number, query at the interval end point of each interval configuration information to obtain second interval configuration information including the image acquisition device number; A vehicle destination record of the target vehicle is constructed based on the second section configuration information and the vehicle section record.

6. The method according to claim 1, characterized in that The determining whether the vehicle destination record and the target vehicle starting point record meet a preset data validity condition includes: Determine a first interval identifier in the vehicle destination record, and determine a second interval identifier in the target vehicle start record; Determining whether the first interval identifier and the second interval identifier are consistent; If the first interval identifier and the second interval identifier are consistent, it is determined that the vehicle endpoint record and the target vehicle start point record meet a preset data validity condition.

7. The method according to claim 1, characterized in that After determining whether the vehicle endpoint record and the target vehicle starting point record meet a preset data validity condition, the method further includes: When the vehicle destination record and the target vehicle starting record do not satisfy the data validity condition, obtaining the vehicle destination record of the next vehicle; The vehicle destination record of the next vehicle is determined as the vehicle destination record of the target vehicle, and the step of searching the vehicle starting point record list for the target vehicle according to the vehicle identifier is performed.

8. The method according to claim 7, characterized in that After determining the interval speed of the target vehicle based on the interval distance, starting time and ending time in the interval driving record, the method further includes: Determining whether the interval speed of the target vehicle is greater than a preset prescribed speed; In the case where the interval speed is greater than the prescribed vehicle speed, a speeding record of the target vehicle is constructed based on the interval driving record and the interval speed, and the speeding record is fed back to the owner of the target vehicle and the cloud; the speeding record is used for speeding analysis in the cloud; Determining whether the interval speed reaches a preset abnormal speed; If the interval speed reaches the abnormal speed, an abnormal record of the target vehicle is constructed according to the interval driving record and the interval speed, and the abnormal record of the target vehicle is fed back to the target user.

9. An interval speed measuring device, characterized in that: The device comprises: An acquisition module, used for acquiring a vehicle destination record of a target vehicle in real time; the vehicle destination record includes a vehicle interval identifier; the vehicle interval identifier includes a vehicle identifier and an interval identifier of the target vehicle; A query module, for querying a target vehicle starting point record in a vehicle starting point record list according to the vehicle identifier when the time difference between the latest loading time of the vehicle end point record and the latest loading time of the vehicle starting point record is greater than a preset second time threshold, and determining whether the vehicle end point record and the target vehicle starting point record meet a preset data validity condition; the data validity condition is that the second interval identifier in the target vehicle starting point record is consistent with the first interval identifier in the vehicle end point record; A judgment module, configured to construct a section driving record of the target vehicle according to the target vehicle starting record and the vehicle end record when both the vehicle end record and the target vehicle starting record meet the data validity condition; The determination module is used to determine the interval speed of the target vehicle based on the interval distance, the starting time and the ending time in the interval driving record.

10. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 8 are implemented.

11. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 8 are implemented.

Images