A method for monitoring slag handling volume based on slag truck trajectory data

Abstract

The present invention discloses a method for monitoring the amount of slag processing based on the trajectory data of slag trucks, comprising: matching the trajectory data of each slag truck with the point information of a management point to obtain a vehicle entry and exit point details table, adding an auxiliary counting column for marking the point change of the slag truck in the vehicle entry and exit point details table to obtain a first auxiliary table; dividing the first auxiliary table into a vehicle entry point details table and a vehicle exit point details table corresponding to each slag truck and splicing them into a vehicle operation details table; counting the entry and exit frequency of each slag truck at the management point according to the vehicle operation details table, and calculating the amount of slag transported by the slag truck at the management point to monitor the working status of the current management point, and realizing supervision of each management point by only analyzing the trajectory data of the slag truck and quickly grasping the transportation status of each slag truck between each management point.

Description

Technical Field

[0001] The present invention relates to the technical field of slag operation monitoring, and in particular to a slag processing amount monitoring method based on slag truck trajectory data. Background Art

[0002] Driven by both socioeconomic growth and rapid urban expansion, the generation of construction waste has exploded, leading to an increasingly serious problem of indiscriminate stacking and dumping. While dedicated waste disposal sites play a key role, limited processing capacity, technical limitations, and a lack of monitoring and early warning mechanisms have led to frequent excessive discharge of construction waste and overloaded disposal sites, resulting in environmental pollution, safety hazards, and even illegal operations. Dump trucks, as a key vehicle for transporting construction waste, possess a wealth of information about their movements. This information not only impacts transportation efficiency and route planning, but also directly impacts the operational management and environmental safety of construction sites and disposal sites. However, due to the large number of sites and their dispersion, traditional management models rely on manual monitoring and rough estimates, making it difficult to accurately assess the actual loading and unloading status of each dump truck. Therefore, integrating cutting-edge information technology to deeply analyze the entire process of waste flow and achieve intelligent early warning of excessive waste discharge and disposal has become a pressing issue for improving the level of intelligent urban management and environmental protection. However, current early warning technology is too complicated. How to quickly process data and manage and monitor construction sites and disposal sites is an urgent problem that needs to be solved. Summary of the Invention

[0003] The purpose of the present invention is to provide a method for monitoring the amount of slag processing based on the trajectory data of slag trucks. By only analyzing the trajectory data of the slag trucks and quickly grasping the transportation status of each slag truck between each management point, supervision of each management point can be achieved.

[0004] To achieve the above objectives, this application adopts the following scheme:

[0005] A method for monitoring the amount of slag processed based on slag truck trajectory data, comprising the following steps:

[0006] S1. Obtain the trajectory data of each muck truck within the monitoring area and the corresponding maximum single-trip transport volume of the vehicle; the point information of the management point and the corresponding muck control volume;

[0007] S2. Match the trajectory data of each muck truck with the location information of the management point, obtain the location information of each trajectory point of each muck truck and store it in the vehicle entry and exit point details table, which includes the time of each trajectory point of each vehicle and the location information of the location;

[0008] S3. Add an auxiliary count column for marking the position changes of the muck truck to the vehicle entry and exit point details table to obtain a first auxiliary table;

[0009] S4. Divide the first auxiliary table into a vehicle entry point details table and a vehicle exit point details table corresponding to each muck truck according to each muck truck and the auxiliary count column, and concatenate the vehicle entry point details table and the vehicle exit point details table of each muck truck to obtain a vehicle operation details table;

[0010] S5. Count the entry and exit frequencies of each muck truck at the management point based on the vehicle operation details table of each vehicle, and calculate the amount of muck transported by the muck truck at the management point based on the entry and exit frequencies of each muck truck and the corresponding maximum single-trip transport volume of the vehicle;

[0011] S6. Determine whether the amount of slag transported by the slag truck at the management point exceeds the corresponding slag control amount. If so, issue an early warning to the current management point.

[0012] In some specific implementation schemes, the trajectory data of each muck truck includes the license plate number, the latitude and longitude of each trajectory point, and the time. The point information of the management point includes the point name and point type of the management point, and the latitude and longitude range of the regional geographic fence. The specific process of step S2 is:

[0013] S21. Sort the trajectory data of each dump truck in chronological order and match them with the longitude and latitude range of the regional geofence to determine the location name of each trajectory point. If the trajectory data cannot be matched with the longitude and latitude range of the regional geofence, mark the location name of the trajectory point as a null value;

[0014] S22. Create a vehicle entry and exit point details table. The fields of the vehicle entry and exit point details table include license plate, time, and area. The license plate number, time, and point name corresponding to each trajectory point are stored as field values of a data item in the license plate, time, and area fields of the vehicle entry and exit point details table.

[0015] S23, sequentially traversing the vehicle entry and exit point details table to determine whether the point names corresponding to the time-continuous trajectory points are consistent. If inconsistent, the inconsistent trajectory points are recorded as drift points;

[0016] S24. Correct the area field value in the vehicle entry and exit point details table, obtain the point names corresponding to the trajectory points at adjacent times before and after the drift point, compare whether the point names before and after the drift point are consistent, and if they are consistent, correct the point name of the drift point to the corresponding point name when they are consistent.

[0017] In some specific implementation schemes, the fields of the first auxiliary table include the license plate number of the muck truck, the time of the track point, the point information, and the auxiliary count column; wherein the auxiliary count column is used to mark the position change of the muck truck as follows:

[0018] Traverse the names of the two points in the area field in turn to determine whether the point names corresponding to the two track points have changed. If they have changed, add one to the field value of the auxiliary count column corresponding to the changed track point to mark the change in the point of the dump truck.

[0019] In some specific implementation schemes, the fields of the vehicle entry point details table of each muck truck include license plate number, entry time, region, and auxiliary count column; the fields of the vehicle exit point details table of each muck truck include license plate number, exit time, region, and auxiliary count column. The specific process of step S4 is as follows:

[0020] S41. Group the vehicle operation details table according to the license plate number to obtain a grouping table for each muck truck;

[0021] S42, obtaining the first and last data of the grouping table of each muck truck, storing the first data in the vehicle entry point details table corresponding to the muck truck, and storing the last data in the vehicle exit point details table corresponding to the muck truck;

[0022] S43. Merge the same fields and concatenate the different fields in the vehicle entry point details table and the vehicle exit point details table of each dump truck, and add the residence time field to obtain the vehicle operation details table corresponding to each dump truck, wherein the residence time field value is the difference between the departure time field value and the entry time field value of each data in the vehicle operation details table.

[0023] In some specific implementation schemes, the specific process of step S5 is:

[0024] For each muck truck's vehicle operation details table, traverse each area field value of each muck truck's vehicle operation details table, that is, each data point name is not empty, and determine whether the residence time of each data is greater than a preset time. If not, delete the data from the vehicle operation details table, and obtain an updated vehicle operation details table after traversal;

[0025] According to the updated vehicle operation details table, the amount of data contained in each management point is counted according to the point name corresponding to the area field value as the frequency of the muck truck entering and exiting the management point. The transportation volume of the muck truck at the management point is obtained by multiplying the maximum single-trip transportation volume of the muck truck by the frequency of the muck truck entering and exiting the management point.

[0026] The total amount of transportation of all muck trucks corresponding to each management point is counted to obtain the amount of muck transported by muck trucks at each management point.

[0027] In some specific implementation schemes, the specific process of step S6 is:

[0028] Obtain the construction certificate for each management point, calculate the historical amount of slag soil accumulated from the project start time specified in the construction certificate, calculate the difference between the total amount of slag soil specified in the construction certificate and the historical amount of slag soil, and obtain the slag soil control amount corresponding to the management point;

[0029] Determine whether the amount of slag transported by slag trucks at the management point exceeds the corresponding slag control amount. If so, issue an overload warning for the current management point.

[0030] In some specific embodiments, the steps are further included:

[0031] S51, for each vehicle operation details table, traverse each area field value of each muck truck's vehicle operation details table, i.e., each data whose point name is not empty;

[0032] S52. Determine whether the residence time of each piece of data is greater than a preset time. If so, mark the piece of data as the corresponding operation type according to the point type corresponding to the point name of the piece of data. When the point type corresponding to the point name is a construction site, mark the piece of data as a loading operation. When the point type corresponding to the point name is a disposal site, mark the piece of data as a dumping operation.

[0033] S53: Save the data marked with loading operation and dumping operation in a vehicle statistics list.

[0034] In some specific implementation schemes, before saving to the vehicle statistics list, the steps of:

[0035] S521. Mark the operation type of the data with an empty point name in the vehicle operation details table as transportation, and delete the data with a stay time less than a preset time from the vehicle operation details table to obtain a vehicle operation details table;

[0036] S522. Traverse the vehicle operation details table to determine whether there is data of continuous loading operations or dumping operations before and after the data of the operation type of transportation. If so, merge the continuous loading operation data and mark them as one loading operation, and merge the continuous dumping operation data and mark them as one dumping operation.

[0037] In some specific implementation schemes, the vehicle statistics list is counted according to the marked operation type, and a continuous loading operation and a dumping operation are regarded as a set of operation data;

[0038] The number of groups of operation data included in the vehicle statistics list is counted, and the total amount of muck transported by each muck truck in the monitoring area is obtained based on the product of the maximum single-trip transportation volume of the muck truck and the number of groups of operation data.

[0039] In some specific implementation schemes, the total amount of slag transported by all slag trucks in the monitoring area is calculated to obtain the total transportation volume in the detection area;

[0040] Obtain the construction certificate for each management point, calculate the historical amount of slag soil accumulated from the project start time specified in the construction certificate, calculate the difference between the total amount of slag soil specified in the construction certificate and the historical amount of slag soil, and obtain the slag soil control amount corresponding to each management point;

[0041] According to the type of management points, the total amount of waste soil discharged from all construction sites and the total amount of waste soil disposed of at all disposal sites are counted respectively;

[0042] Determine whether the total transport volume exceeds the total amount of muck discharge. If so, issue an over-discharge warning in the monitoring area.

[0043] Determine whether the total transportation volume exceeds the total amount of slag disposal. If so, issue an over-disposal warning in the monitoring area.

[0044] The present invention has the beneficial effects:

[0045] The present invention achieves real-time monitoring and intelligent analysis of the slag removal process by integrating GPS positioning trajectory data of slag trucks, electronic geo-fencing data of construction sites and disposal sites, government-approved construction site emission permits, and disposal site disposal permits. This allows for timely and effective statistics of construction site slag emissions and disposal site disposal volumes, providing a basis for supervision of construction sites and disposal sites.

[0046] The present invention uses Python's highly abstract functions and methods of DataFrame to complete the complex data cleaning, conversion, merging, grouping, filtering and other processing processes in the slag truck trajectory in one go, eliminating the need to manually write loop logic, reducing the error probability, improving code readability and maintainability, and accelerating data processing. It helps regulators quickly grasp situations such as over-discharge of slag and over-operation of disposal sites, and take timely management measures. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 A flow chart of a method for monitoring slag processing volume based on slag truck trajectory data provided by an embodiment of the present invention;

[0048] Figure 2 A schematic diagram of a trajectory point correction method provided by an embodiment of the present invention;

[0049] Figure 3This is a flowchart of a specific method for obtaining a vehicle operation details table provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0050] The following will be combined with the accompanying drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the embodiments described are only part of the embodiments of the present invention, rather than all the embodiments. The following description of at least one exemplary embodiment is actually only illustrative and is in no way intended to limit the present invention and its application or use. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0051] Unless otherwise specifically stated, the relative arrangement of components and steps, the numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention.

[0052] At the same time, it should be understood that for the convenience of description, the sizes of the various parts shown in the drawings are not drawn according to the actual proportional relationship.

[0053] Additionally, descriptions of well-known structures, functions, and configurations may be omitted for clarity and conciseness. Those skilled in the art will recognize that various changes and modifications can be made to the examples described herein without departing from the spirit and scope of the present disclosure.

[0054] Technologies, methods and equipment known to ordinary technicians in the relevant art may not be discussed in detail, but where appropriate, such technologies, methods and equipment should be considered part of the authorization specification.

[0055] In all examples shown and discussed herein, any specific values should be interpreted as merely exemplary and not limiting. Therefore, other examples of the exemplary embodiments may have different values.

[0056] Example 1

[0057] like Figure 1 As shown, this embodiment provides a method for monitoring the amount of slag processed based on slag truck trajectory data, which specifically includes the following steps:

[0058] S1. Obtain the trajectory data of each muck truck within the monitoring area and the corresponding maximum single-trip transport volume of the vehicle; the location information of the management point and the corresponding muck control volume;

[0059] It should be noted that the management points in this application include construction sites and disposal sites. For construction sites, the controlled amount of slag is the emission amount of the construction site, and the controlled amount of slag at the disposal site is the slag disposal amount. The controlled amount of slag is related to the historical emission (disposal) amount of the construction site (disposal site) and its corresponding construction certificate (construction site emission certificate and disposal site disposal certificate). Specifically, the process of obtaining the vehicle GPS trajectory data within the monitoring period of the monitoring area and the preliminary processing in step S1 is as follows:

[0060] S11, obtain the real-time trajectory data of each muck truck in the monitoring area, including license plate number, longitude and latitude, time and other information. Each trajectory data of each muck truck is recorded as Zi (s, lat i ,lon i , t i ), where s represents the license plate number, lat i Indicates latitude, lon i Indicates longitude, t i Indicates time;

[0061] S12. Obtain the maximum single-trip transport volume information of each dump truck, that is, the emission standard type of each dump truck, such as National V vehicle, National VI vehicle, new energy vehicle, etc. This type of information is mainly used to quantify the vehicle full load standard. For example, the volume of dump trucks when fully loaded with National V vehicles is 20 cubic meters, and when fully loaded with new energy vehicles, it is 15 cubic meters.

[0062] S13, the point information of the management point, mainly includes the point name, point type, latitude and longitude, regional geo-fence information, etc. of the management point (construction site and disposal site). The data of each point is recorded as Gd (name, type ， lat, lon, geometry);

[0063] S14. Construction certificate information of the management point (construction site emission certificate and disposal site disposal certificate information), mainly including the construction site (disposal site) name, emission certificate ID, slag emission (disposal) cycle start and end time, emission (disposal) limit, etc., recorded as (name, id, start_time, end_time, threshold); where threshold is a specific value, such as 10,000 cubic meters.

[0064] S2. Match the trajectory data of each muck truck with the location information of the management point, obtain the location information of each trajectory point of each muck truck and store it in the vehicle entry and exit point details table, which includes the time of each trajectory point of each vehicle and the location information of the location;

[0065] In order to avoid the drift of the track data of the dump truck and the repeated occurrence of the track data in a certain management point area, the following operations need to be performed when matching the track point data of the dump truck with the management point: the track data of each dump truck includes the license plate number, the latitude and longitude of each track point and the time, and the point information of the management point includes the point name and point type of the management point, and the latitude and longitude range of the regional geographic fence, such as Figure 2 As shown, the specific process of step S2 is:

[0066] S21. Sort the trajectory data of each dump truck in chronological order and match them with the longitude and latitude range of the regional geofence to determine the location name of each trajectory point. If the trajectory data cannot be matched with the longitude and latitude range of the regional geofence, mark the location name of the trajectory point as a null value;

[0067] S22. Create a vehicle entry and exit point details table. The fields of the vehicle entry and exit point details table include license plate, time, and area. The license plate number, time, and point name corresponding to each trajectory point are stored as field values of a data item in the license plate, time, and area fields of the vehicle entry and exit point details table.

[0068] S23, sequentially traversing the vehicle entry and exit point details table to determine whether the point names corresponding to the time-continuous trajectory points are consistent. If inconsistent, the inconsistent trajectory points are recorded as drift points;

[0069] S24. Correct the area field value in the vehicle entry and exit point details table, obtain the point names corresponding to the trajectory points at adjacent times before and after the drift point, compare whether the point names before and after the drift point are consistent, and if they are consistent, correct the point name of the drift point to the corresponding point name when they are consistent.

[0070] For each acquired trajectory data, the trajectory data of each dump truck is sorted in chronological order, and the longitude and latitude in each trajectory data are matched with the longitude and latitude range of the regional geographic fence of the management point respectively, so as to determine the area of the management point where each trajectory point is located, that is, to determine whether the dump truck trajectory point is within the geometry range of the point, and obtain the matching result of each trajectory data. The data format of the matching result is recorded as (s, lat i ,lon i , t i ,name i ), s is a certain muck truck (indicated by the license plate number), (lat i ,lon i ) is the real-time track position of the muck truck, i.e., longitude and latitude, t i The real time of the muck truck, name iIndicates the point name (construction site or disposal site name) where the current trajectory is located, and stores it in the data result set R, and replaces the s and t in the matching results of each trajectory data with i ,name i As field values, fill in the license plate, time, and area fields of the vehicle entry and exit point details table, as shown in Table 1. If the current track is not at the construction site or disposal site, it means that the vehicle is on the road or in other areas. At this time, name i Empty.

[0071] Due to the drift of the vehicle trajectory, the position of the vehicle s will change continuously in continuous time, such as t i-1 Located at construction site A, t i Area name i Empty, t i+1 Then we return to construction site A. Considering that the transmission frequency of the muck truck trajectory is relatively frequent (for example, once every 30 seconds), we can assume that the vehicle is at t i Point name i If there is an offset, it can be preliminarily corrected to A based on the timing changes before and after the position. The corrected vehicle entry and exit point details are shown in Table 2.

[0072] Table 1 Details of vehicle entry and exit points

[0073]

[0074] After the first round of data cleaning, for a vehicle s, the continuity of the change of the area where it is located over time increases during the monitoring period (such as 12 hours), which may be (construction site A, ..., construction site A, null, ..., null, disposal site B, ..., disposal site B, null, ..., null, construction site A, ..., construction site A, null, ...), that is, a truckload of construction waste leaves construction site A and arrives at disposal site B after a period of time, and then leaves disposal site B and returns to construction site A after a period of time.

[0075] Table 2 Corrected vehicle entry and exit point details

[0076]

[0077] S3. Add an auxiliary count column for marking the position changes of the muck truck to the vehicle entry and exit point details table to obtain a first auxiliary table;

[0078] In order to obtain the entry and exit status of vehicles at different points, an auxiliary count column is added to the revised vehicle entry and exit point details table in Table 2, resulting in Table 3. The purpose is to mark the vehicle at different points according to time. Among them, the fields of the first auxiliary table include the license plate number of the dump truck, the time of the trajectory point, the point information, and the auxiliary count column; the auxiliary count column is used to mark the changes in the location of the dump truck as follows:

[0079] Traverse the names of the two points in the area field in turn to determine whether the point names corresponding to the two track points have changed. If they have changed, add one to the field value of the auxiliary count column corresponding to the changed track point to mark the change in the point of the dump truck.

[0080] To reduce the probability of errors, improve code readability and maintainability, and avoid the use of loop query logic, the Python dataframe framework can be used to briefly obtain the vehicle entry and exit status using the frequency of point changes, as shown in Table 3. If the vehicle point changes, the corresponding auxiliary column count increases by 1. If the vehicle passes through the points (A, A, A, null, B, B, A...), the corresponding auxiliary count column is (0, 0, 0, 1, 2, 2, 3...).

[0081] Table 3 First auxiliary table

[0082]

[0083] S4. Divide the first auxiliary table into a vehicle entry point details table and a vehicle exit point details table corresponding to each muck truck according to each muck truck and the auxiliary count column, and concatenate the vehicle entry point details table and the vehicle exit point details table of each muck truck to obtain a vehicle operation details table;

[0084] Specifically, the fields of the vehicle entry point details table of each muck truck include license plate number, entry time, region and auxiliary count column; the fields of the vehicle departure point details table of each muck truck include license plate number, departure time, region and auxiliary count column, such as Figure 3 As shown, the specific process of step S4 is:

[0085] S41. Group the vehicle operation details table according to the license plate number to obtain a grouping table for each muck truck;

[0086] S42, obtaining the first and last data of the grouping table of each muck truck, storing the first data in the vehicle entry point details table corresponding to the muck truck, and storing the last data in the vehicle exit point details table corresponding to the muck truck;

[0087] S43. Merge the same fields and concatenate the different fields in the vehicle entry point details table and the vehicle exit point details table of each dump truck, and add the residence time field to obtain the vehicle operation details table corresponding to each dump truck, wherein the residence time field value is the difference between the departure time field value and the entry time field value of each data in the vehicle operation details table.

[0088] Similarly, to facilitate statistics, this example uses the groupby method in DataFrame to group by the "License Plate Number" and "Auxiliary Count Column" columns. The first method is called to obtain the first row of data for each group, thereby obtaining data records for each time a vehicle enters a new location, as shown in Table 4 below. The last method is also called to obtain the last row of data for each group, thereby obtaining data records for each time a vehicle leaves a location, as shown in Table 5 below.

[0089] Table 4 Vehicle entry point details

[0090]

[0091] Table 5 Vehicle departure point details

[0092]

[0093] The grouped entry and exit point area tables are concatenated based on the 'License Plate Number' and 'Auxiliary Count Columns' to obtain detailed records of each vehicle entry and exit at each point, as shown in Table 6 below. Dwell Time = Exit Time - Entry Time. It should be understood that the Auxiliary Count column in Table 6 represents statistics for a single entry or exit.

[0094] Table 6 Details of vehicle entry and exit points

[0095]

[0096] S5. Count the entry and exit frequencies of each muck truck at the management point based on the vehicle operation details table of each vehicle, and calculate the amount of muck transported by the muck truck at the management point based on the entry and exit frequencies of each muck truck and the corresponding maximum single-trip transport volume of the vehicle;

[0097] With the above Table 6, statistics can be collected for each management point. The residence time threshold can be used to determine whether a vehicle is operating in the area. If the residence time is less than the preset time (for example, 2 minutes), it is considered that the vehicle has temporarily entered or exited the area, and the record can be filtered out. The specific process is as follows:

[0098] For each muck truck's vehicle operation details table, traverse each area field value of each muck truck's vehicle operation details table, that is, each data point name is not empty, and determine whether the residence time of each data is greater than a preset time. If not, delete the data from the vehicle operation details table, and obtain an updated vehicle operation details table after traversal;

[0099] According to the updated vehicle operation details table, the amount of data contained in each management point is counted according to the point name corresponding to the area field value as the frequency of the muck truck entering and exiting the management point. The transportation volume of the muck truck at the management point is obtained by multiplying the maximum single-trip transportation volume of the muck truck by the frequency of the muck truck entering and exiting the management point.

[0100] The total amount of transportation of all muck trucks corresponding to each management point is counted to obtain the amount of muck transported by muck trucks at each management point.

[0101] S6. Determine whether the amount of slag transported by the slag truck at the management point exceeds the corresponding slag control amount. If so, issue an early warning to the current management point.

[0102] Specifically, the specific process of step S6 is:

[0103] Obtain the construction certificate for each management point, calculate the historical amount of slag soil accumulated from the project start time specified in the construction certificate, calculate the difference between the total amount of slag soil specified in the construction certificate and the historical amount of slag soil, and obtain the slag soil control amount corresponding to the management point;

[0104] Determine whether the amount of slag transported by slag trucks at the management point exceeds the corresponding slag control amount. If so, issue an overload warning for the current management point.

[0105] Based on the travel details of vehicles at various points during the study period, the frequency of their appearance at each point is counted according to the auxiliary count series, that is, the number of trips the vehicle enters and exits the point. Then, based on the vehicle's emission standard information (National V, National VI, new energy, etc.), the vehicle's maximum single-trip transportation volume is obtained, and the vehicle's slag transportation volume at the point can be obtained = maximum single-trip transportation volume * frequency; the transportation volume of different vehicles is accumulated, and finally the current slag transportation volume of each point (construction site, disposal site) is obtained.

[0106] Starting from the project start time specified in the construction site emission certificate (disposal site certificate), the historical slag volume of each construction site (disposal site) is calculated cumulatively to determine whether the current historical cumulative slag volume exceeds the slag emission (disposal) specified in the certificate. If so, an alarm message is given.

[0107] In this embodiment, the amount of slag soil at each management point can be counted separately to monitor the situation at each management point, or the amount of waste soil at the entire monitoring area can be monitored as a whole. Based on Tables 1 to 6 above, the specific process of the overall early warning method for the monitoring area is as follows:

[0108] S51, for each vehicle operation details table, traverse each area field value of each muck truck's vehicle operation details table, i.e., each data whose point name is not empty;

[0109] S52. Determine whether the residence time of each piece of data is greater than a preset time. If so, mark the piece of data as the corresponding operation type according to the point type corresponding to the point name of the piece of data. When the point type corresponding to the point name is a construction site, mark the piece of data as a loading operation. When the point type corresponding to the point name is a disposal site, mark the piece of data as a dumping operation.

[0110] S53. Save the data marked with the loading operation and the dumping operation into the vehicle statistics list.

[0111] In order to avoid vehicles from being counted repeatedly due to certain special circumstances (such as repeatedly entering and leaving a certain type of area, since the muck truck generally follows the continuous operation process of loading muck from the construction site and then transporting it to the corresponding disposal site for dumping, and each muck truck generally operates in a fixed order of construction site A-road null-disposal site B-road null during the monitoring period, the vehicle operation details table can be re-screened based on the above characteristics to avoid the problem of repeated statistics. Therefore, the screening step is also included before saving to the vehicle statistics list:

[0112] S521. Mark the operation type of the data with an empty point name in the vehicle operation details table as transportation, and delete the data with a stay time less than a preset time from the vehicle operation details table to obtain a vehicle operation details table, as shown in Table 7;

[0113] Table 7 Vehicle operation details

[0114]

[0115] S522. Traverse the vehicle operation details table to determine whether there is data of continuous loading operations or dumping operations before and after the data of the operation type of transportation. If so, merge the continuous loading operation data and mark them as one loading operation, and merge the continuous dumping operation data and mark them as one dumping operation.

[0116] It can be understood that a complete operation process includes a loading operation and a dumping operation. Therefore, the continuous loading operation and dumping operation can be regarded as a group of operation processes. In this way, when counting the amount of slag in the monitoring area, the total amount of slag in the monitoring section of the monitoring area can be counted through the operation process of the slag truck. The specific process is as follows:

[0117] The vehicle statistics list is counted according to the marked operation type, and a continuous loading operation and a dumping operation are regarded as a group of operation data; the number of groups of operation data contained in the vehicle statistics list is counted, and the total amount of muck transported by each muck truck in the monitoring area is obtained according to the product of the maximum single-trip transportation volume of the muck truck and the number of groups of operation data.

[0118] The total amount of slag transported by all slag trucks in the monitoring area is calculated to obtain the total transportation volume in the monitoring area;

[0119] Obtain the construction certificate for each management point, calculate the historical amount of slag soil accumulated from the project start time specified in the construction certificate, calculate the difference between the total amount of slag soil specified in the construction certificate and the historical amount of slag soil, and obtain the slag soil control amount corresponding to each management point;

[0120] According to the type of management points, the total amount of waste soil discharged from all construction sites and the total amount of waste soil disposed of at all disposal sites are counted respectively;

[0121] Determine whether the total transport volume exceeds the total amount of muck discharge. If so, issue an over-discharge warning in the monitoring area.

[0122] Determine whether the total transportation volume exceeds the total amount of slag disposal. If so, issue an over-disposal warning in the monitoring area.

[0123] Therefore, if you want to quickly understand the construction status of slag in the monitoring area, you can directly use the above method to quickly determine it. If over-discharge or over-disposal occurs, you can use the specific process of steps S5-S6 to check each management point in turn.

[0124] It is understandable that this application only uses the GPS data of the slag trucks, the relevant certificate information of the construction site and the disposal site, and the geographic fence data to achieve rapid real-time monitoring and accurate prediction of the point slag processing capacity, and timely issue overload warning signals to provide decision-making support for managers and ensure that related operations are carried out within the framework of safety and environmental protection.

[0125] Use Python's DataFrame's highly abstract functions and methods to complete complex data processing tasks such as cleaning, conversion, merging, grouping, and filtering in the dump truck trajectory at one time, eliminating the need to manually write loop logic, reducing the probability of errors, and improving code readability and maintainability.

[0126] The above description is merely a preferred embodiment of the present invention and does not constitute any form of limitation to the present invention. Based on the technical essence of the present invention and within the spirit and principles of the present invention, any simple modification, equivalent replacement and improvement of the above embodiment shall still fall within the scope of protection of the technical solution of the present invention.

Claims

1. A method for monitoring the amount of slag processed based on slag truck trajectory data, characterized in that: The specific steps include: S1. Obtain the trajectory data of each muck truck within the monitoring area and the corresponding maximum single-trip transport volume of the vehicle; the point information of the management point and the corresponding muck control volume; S2. Match the trajectory data of each muck truck with the location information of the management point, obtain the location information of each trajectory point of each muck truck and store it in the vehicle entry and exit point details table, which includes the time of each trajectory point of each vehicle and the location information of the location; S3. Add an auxiliary count column for marking the position changes of the muck truck to the vehicle entry and exit point details table to obtain a first auxiliary table; The fields of the first auxiliary table include the license plate number of the muck truck, the time of the track point, the point information, and the auxiliary count column. The auxiliary count column is used to mark the changes in the position of the muck truck as follows: Traverse the two point names in the area field in sequence to determine whether the point names corresponding to the two track points have changed. If so, increase the field value of the auxiliary count column corresponding to the changed track point by one to mark the change of the muck truck's point. S4. Divide the first auxiliary table into a vehicle entry point details table and a vehicle exit point details table corresponding to each muck truck according to each muck truck and the auxiliary count column, and concatenate the vehicle entry point details table and the vehicle exit point details table of each muck truck to obtain a vehicle operation details table; The fields of the vehicle entry point details table of each muck truck include the license plate number, entry time, region, and auxiliary count column; the fields of the vehicle exit point details table of each muck truck include the license plate number, exit time, region, and auxiliary count column. The specific process of step S4 is: S41. Group the vehicle operation details table according to the license plate number to obtain a grouping table for each muck truck; S42, obtaining the first and last data of the grouping table of each muck truck, storing the first data in the vehicle entry point details table corresponding to the muck truck, and storing the last data in the vehicle exit point details table corresponding to the muck truck; S43. Merge the same fields and concatenate the different fields in the vehicle entry point details table and the vehicle exit point details table for each muck truck, and add a dwell time field to obtain a vehicle operation details table corresponding to each muck truck. The dwell time field value is the difference between the departure time field value and the entry time field value of each data item in the vehicle operation details table. S5. Count the entry and exit frequencies of each muck truck at the management point based on the vehicle operation details table of each vehicle, and calculate the amount of muck transported by the muck truck at the management point based on the entry and exit frequencies of each muck truck and the corresponding maximum single-trip transport volume of the vehicle; Also includes the steps: S51, for each vehicle operation details table, traverse each area field value of each muck truck's vehicle operation details table, i.e., each data whose point name is not empty; S52. Determine whether the residence time of each piece of data is greater than a preset time. If so, mark the piece of data as the corresponding operation type according to the point type corresponding to the point name of the piece of data. When the point type corresponding to the point name is a construction site, mark the piece of data as a loading operation. When the point type corresponding to the point name is a disposal site, mark the piece of data as a dumping operation. S53, saving the data marked with loading operation and dumping operation into the vehicle statistics list; S6. Determine whether the amount of slag transported by the slag truck at the management point exceeds the corresponding slag control amount. If so, issue an early warning to the current management point.

2. The method for monitoring the amount of slag processed based on the trajectory data of slag trucks according to claim 1, characterized in that: The trajectory data of each dump truck includes the license plate number, the longitude and latitude of each trajectory point, and the time. The location information of the management point includes the location name and location type of the management point, and the longitude and latitude range of the regional geographic fence. The specific process of step S2 is as follows: S21. Sort the trajectory data of each dump truck in chronological order and match them with the longitude and latitude range of the regional geofence to determine the location name of each trajectory point. If the trajectory data cannot be matched with the longitude and latitude range of the regional geofence, mark the location name of the trajectory point as a null value; S22. Create a vehicle entry and exit point details table. The fields of the vehicle entry and exit point details table include license plate, time, and area. The license plate number, time, and point name corresponding to each trajectory point are stored as field values of a data item in the license plate, time, and area fields of the vehicle entry and exit point details table. S23, sequentially traversing the vehicle entry and exit point details table to determine whether the point names corresponding to the time-continuous trajectory points are consistent. If inconsistent, the inconsistent trajectory points are recorded as drift points; S24. Correct the area field value in the vehicle entry and exit point details table, obtain the point names corresponding to the trajectory points at adjacent times before and after the drift point, compare whether the point names before and after the drift point are consistent, and if they are consistent, correct the point name of the drift point to the corresponding point name when they are consistent.

3. The method for monitoring the amount of slag processed based on the trajectory data of slag trucks according to claim 1, characterized in that: The specific process of step S5 is: For each muck truck's vehicle operation details table, traverse each area field value of each muck truck's vehicle operation details table, that is, each data point name is not empty, and determine whether the residence time of each data is greater than a preset time. If not, delete the data from the vehicle operation details table, and obtain an updated vehicle operation details table after traversal; According to the updated vehicle operation details table, the amount of data contained in each management point is counted according to the point name corresponding to the area field value as the frequency of the muck truck entering and exiting the management point. The transportation volume of the muck truck at the management point is obtained by multiplying the maximum single-trip transportation volume of the muck truck by the frequency of the muck truck entering and exiting the management point. The total amount of transportation of all muck trucks corresponding to each management point is counted to obtain the amount of muck transported by muck trucks at each management point.

4. The method for monitoring the amount of slag processed based on the trajectory data of slag trucks according to claim 3, characterized in that: The specific process of step S6 is: Obtain the construction certificate for each management point, calculate the historical amount of slag soil accumulated from the project start time specified in the construction certificate, calculate the difference between the total amount of slag soil specified in the construction certificate and the historical amount of slag soil, and obtain the slag soil control amount corresponding to the management point; Determine whether the amount of slag transported by slag trucks at the management point exceeds the corresponding slag control amount. If so, issue an overload warning for the current management point.

5. The method for monitoring the amount of slag processed based on the trajectory data of slag trucks according to claim 1, characterized in that: Before saving to the vehicle statistics list, the following steps are also included: S521. Mark the operation type of the data with an empty point name in the vehicle operation details table as transportation, and delete the data with a stay time less than a preset time from the vehicle operation details table to obtain a vehicle operation details table; S522. Traverse the vehicle operation details table to determine whether there is data of continuous loading operations or dumping operations before and after the data of the operation type of transportation. If so, merge the continuous loading operation data and mark them as one loading operation, and merge the continuous dumping operation data and mark them as one dumping operation.

6. The method for monitoring the amount of slag processed based on the trajectory data of slag trucks according to claim 1, characterized in that: The vehicle statistics list is counted according to the marked operation type, and a continuous loading operation and a dumping operation are regarded as a set of operation data; The number of groups of operation data included in the vehicle statistics list is counted, and the total amount of muck transported by each muck truck in the monitoring area is obtained based on the product of the maximum single-trip transportation volume of the muck truck and the number of groups of operation data.

7. The method for monitoring the amount of slag processed based on the trajectory data of slag trucks according to claim 6, characterized in that: The total amount of slag transported by all slag trucks in the monitoring area is calculated to obtain the total transportation volume in the monitoring area; Obtain the construction certificate for each management point, calculate the historical slag volume based on the project start time specified in the construction certificate, calculate the difference between the total slag volume specified in the construction certificate and the historical slag volume, and obtain the slag control volume corresponding to each management point. The slag control volume includes the total slag discharge volume and the total slag disposal volume. According to the type of management points, the total amount of waste soil discharged from all construction sites and the total amount of waste soil disposed of at all disposal sites are counted respectively; Determine whether the total transport volume exceeds the total amount of muck discharge. If so, issue an over-discharge warning in the monitoring area. Determine whether the total transportation volume exceeds the total amount of slag disposal. If so, issue an over-disposal warning in the monitoring area.

Images