CN-121979876-A - Vehicle unloading data cleaning method, storage medium and device

CN121979876ACN 121979876 ACN121979876 ACN 121979876ACN-121979876-A

Abstract

The invention discloses a vehicle unloading data cleaning method, a storage medium and equipment, which belong to the technical field of industrial Internet of things data processing, the invention groups the unwashed vehicle unloading data into a pre-established data-unloading bit group based on a vehicle unloading bit identifier, vehicle identity information and a time stamp corresponding to unwashed vehicle unloading data in a database, the method is characterized in that the method comprises the steps of distinguishing the same vehicle fragment recorded data from different vehicles continuously recorded data, determining the working state of each data-unloading bit group according to a preset cleaning strategy, updating a database according to the working states of different data-unloading bit groups, and accurately combining the data, so that the problem that the traditional data cleaning method is easy to combine the recorded data of the same parking space operation vehicle in an error mode, and the data is seriously distorted is solved.

Inventors

JI MING
XU LIPING
LIU CHONG
LIU ZHEN
HAN JUANJUAN

Assignees

徐工汉云技术股份有限公司

Dates

Publication Date: 20260505
Application Date: 20260127

Claims (10)

1. A method for cleaning vehicle discharge data, comprising: Acquiring a vehicle unloading position identifier, vehicle identity information and a time stamp corresponding to unwashed vehicle unloading data in a database; Grouping unwashed vehicle unloading data into pre-established data-unloading bit groups for distinguishing the same vehicle fragment record data from different vehicle continuous record data based on the vehicle unloading bit identification, the vehicle identification information and the time stamp; determining the working state of each data-unloading bit group according to a preset cleaning strategy; The database is updated based on the operating conditions of the different data-discharge bits.
2. The vehicle discharge data cleansing method of claim 1 wherein said method of establishing a data-discharge bit set comprises: Dividing the unloading data of the vehicles meeting the same grouping condition in the database into the same group, and sequencing the unloading data in sequence according to the time stamp to obtain a data-unloading bit group; creating a new data-discharge bit group, and dividing the vehicle discharge data which does not meet the same grouping condition into the new data-discharge bit group; the vehicle discharge data in the end of packet data-discharge bit set adds a "purged" tag.
3. The method for cleaning vehicle unloading data according to claim 2, wherein valid vehicle identity information is screened before the vehicle unloading data satisfying the same grouping condition in the database is classified into the same group; The method for screening the effective vehicle identity information comprises the following steps: if the vehicle identity information corresponding to the vehicle unloading data meets the license plate number format, the vehicle identity information is effective.
4. The vehicle discharge data cleansing method of claim 2 wherein the same grouping condition comprises: and dividing the vehicle unloading data with the same unloading position identification and vehicle identity information into the same group and sequencing the same in sequence according to the time stamp, wherein the time interval between the time stamp of the last vehicle unloading data and the end of the current grouping is smaller than a preset period.
5. The vehicle discharge data cleaning method of claim 4, wherein the predetermined period of time has a value of 30 to 60 seconds.
6. The vehicle discharge data purging method as defined in claim 2, wherein the preset purging strategy includes: acquiring a time stamp and current server time corresponding to the unloading data of the last vehicle in each grouped ending data-unloading bit group; if the time difference between the time stamp and the current server is smaller than a preset threshold, the unloading task corresponding to the unloading data of the vehicle is not completed, the starting time of the unloading task corresponding to the unloading data of the vehicle, the identification of the unloading position of the vehicle and the identity information of the vehicle are recorded in a database, and the operation duration and the ending time of the unloading task corresponding to the unloading data of the vehicle are left; otherwise, the unloading task corresponding to the unloading data of the vehicle is completed.
7. The method of claim 6, wherein updating the database based on the operating status of the different data-discharge bit sets comprises: If the current working state of the data-unloading bit group is incomplete, searching for an incomplete record associated with the current data-unloading bit group in the database; If the associated incomplete records exist, comparing the unloading task starting time corresponding to the current data-unloading bit group with the unloading task starting time corresponding to the incomplete records, and reserving earlier unloading task starting time; If there is no associated incomplete record, then a new incomplete record is added with the current working state of the data-unloading bit group.
8. The method of claim 6, wherein updating the database based on the operating status of the different data-discharge bit sets, further comprises: If the current data-unloading bit set working state is completed, searching for incomplete records associated with the current data-unloading bit set in the database; If the relevant incomplete records exist, calculating the operation duration of the unloading task according to the time stamp corresponding to the unloading data of the last vehicle of the current data-unloading bit group, and filling the operation duration of the unloading task and the ending time which are left blank in the incomplete records by adopting the operation duration of the unloading task and the time stamp corresponding to the unloading data of the last vehicle of the current data-unloading bit group; updating the incomplete record to a completed record; If the related incomplete record does not exist, calculating the operation duration of the unloading task according to the timestamp corresponding to the unloading data of the last vehicle of the current data-unloading bit group, and adding a completed record.
9. A computer readable storage medium, on which a computer program is stored, which computer program, when being executed by a processor, implements a vehicle discharge data cleaning method according to any one of claims 1 to 8.
10. A computer device, comprising: a memory for storing instructions; a processor for executing the instructions to cause the apparatus to perform a vehicle discharge data cleaning method as claimed in any one of claims 1 to 8.

Description

Vehicle unloading data cleaning method, storage medium and device Technical Field The invention relates to a vehicle unloading data cleaning method, a storage medium and equipment, and belongs to the technical field of industrial Internet of things data processing. Background In current logistics parks or large factories, there are a large number of loading and unloading vehicles to carry out loading and unloading operations, and the vehicles need to be parked in designated loading and unloading parking spaces to operate. In general, the system automatically recognizes the license plate of a vehicle parked in a loading/unloading space by means of a camera, and continuously tracks the in-place state of the vehicle, thereby generating a large number of data records arranged in time sequence. These records are important bases for analyzing the work efficiency, the parking space occupation, the vehicle dispatching and calculating the related fees. A complete unloading process of the same vehicle may be split by the system into a plurality of time-adjacent records. The conventional method cannot splice these records correctly into one complete record. For example, when one vehicle is unloaded in an unloading position for a long time, the monitoring equipment can only record one piece of data every minute, and a large amount of time-continuous fragmented data is finally formed, and in addition, when different vehicles continuously use the same parking space, the records of the vehicles are connected end to end in time, and the traditional method is easy to combine the records of the front vehicle and the rear vehicle in error, so that the data is seriously distorted. Disclosure of Invention The invention aims to overcome the defects in the prior art, and provides a vehicle unloading data cleaning method, a storage medium and equipment, which can distinguish the same vehicle fragment recorded data from different vehicles continuously recorded data and accurately combine the data, so that the problem that the data is seriously distorted due to the fact that the recorded data of the same parking space operation vehicle are easily combined in error by the traditional data cleaning method is solved. In order to solve the technical problems, the invention is realized by adopting the following technical scheme: In one aspect, the invention provides a method for cleaning unloading data of a vehicle, comprising: Acquiring a vehicle unloading position identifier, vehicle identity information and a time stamp corresponding to unwashed vehicle unloading data in a database; Grouping unwashed vehicle unloading data into pre-established data-unloading bit groups for distinguishing the same vehicle fragment record data from different vehicle continuous record data based on the vehicle unloading bit identification, the vehicle identification information and the time stamp; determining the working state of each data-unloading bit group according to a preset cleaning strategy; The database is updated based on the operating conditions of the different data-discharge bits. Further, the method for establishing the data-unloading bit group comprises the following steps: Dividing the unloading data of the vehicles meeting the same grouping condition in the database into the same group, and sequencing the unloading data in sequence according to the time stamp to obtain a data-unloading bit group; creating a new data-discharge bit group, and dividing the vehicle discharge data which does not meet the same grouping condition into the new data-discharge bit group; the vehicle discharge data in the end of packet data-discharge bit set adds a "purged" tag. Furthermore, before the unloading data of the vehicles meeting the same grouping condition in the database are divided into the same group, effective vehicle identity information is screened out; The method for screening the effective vehicle identity information comprises the following steps: if the vehicle identity information corresponding to the vehicle unloading data meets the license plate number format, the vehicle identity information is effective. Still further, the same grouping condition includes: and dividing the vehicle unloading data with the same unloading position identification and vehicle identity information into the same group and sequencing the same in sequence according to the time stamp, wherein the time interval between the time stamp of the last vehicle unloading data and the end of the current grouping is smaller than a preset period. Further, the preset period of time has a value of 30 to 60 seconds. Further, the preset cleaning strategy includes: acquiring a time stamp and current server time corresponding to the unloading data of the last vehicle in each grouped ending data-unloading bit group; if the time difference between the time stamp and the current server is smaller than a preset threshold, the unloading task corresponding to the unloading data of the veh