Construction site transportation distance calculation system and method, computer equipment and storage medium

Abstract

The invention relates to the technical field of power transmission line engineering cost, and discloses a construction site transportation distance calculation system and method, computer equipment and a storage medium, and the system comprises an import analysis module and a transportation distance calculation module connected with the import analysis module; the import analysis module is configured to import a target format file according to an import statement in the script file; analyzing the target format file according to an analysis statement in the script file to determine transportation path information; transmitting the transportation path information to a transportation distance calculation module according to a first interaction statement in the script file; the transportation path information comprises information of a plurality of strain sections and road information and terrain information in a preset range of the to-be-constructed line; and the freight distance calculation module is configured to determine a target manpower freight distance and a target vehicle freight distance of the to-be-constructed line according to the transportation path information based on a freight distance calculation statement in the script file. The efficiency of transportation distance calculation can be improved, and errors are reduced.

Description

Technical Field

[0001] This invention relates to the field of power transmission line engineering cost technology, specifically to a system, method, computer equipment, and storage medium for calculating the transportation distance at the construction site. Background Art

[0002] The transportation distance of materials for power transmission line projects has a significant impact on the cost of power transmission lines.

[0003] In previous engineering construction projects, design units generally calculated the distance of each section of the route by measuring the straight distance of the highway based on the topographic map, multiplying it by the curvature coefficient, and then taking a weighted average to obtain the manpower transport distance.

[0004] However, due to the age of the topographic maps, some existing highways cannot be represented on the maps in a timely manner, and the terrain division is not accurate enough. Therefore, the calculation results deviate from the actual situation, which in turn affects the rationality of the project cost.

[0005] Therefore, improving the accuracy of transportation distance calculation has become a technical problem that urgently needs to be solved by those skilled in the art. Summary of the Invention

[0006] In view of this, the present invention provides a construction site transportation distance calculation system, method, computer equipment and storage medium to solve the problems of low efficiency and easy error in the calculation of transportation distance in related technologies.

[0007] In a first aspect, the present invention provides a construction site transportation distance calculation system, the construction site transportation distance calculation system comprising:

[0008] Import parsing module and distance calculation module connected to the import parsing module;

[0009] The import parsing module is configured to import a target format file according to the import statement in the script file; parse the target format file according to the parsing statement in the script file to determine the transportation route information; and send the transportation route information to the transportation distance calculation module according to the first interaction statement in the script file. The transportation route information includes: information on multiple tension sections and highway information and terrain information within a preset range of the line to be constructed; the information on a single tension section includes the location information of multiple transmission towers.

[0010] The transport distance calculation module is configured to determine the target manpower transport distance and the target vehicle transport distance of the route to be constructed based on the transport route information in the script file.

[0011] Wherein, the target manual transport distance is the minimum manual transport distance, representing the average manual transport distance for transporting construction materials from the target unloading point located on the highway to the construction site. The target unloading point is the unloading point corresponding to the minimum manual transport distance determined from at least one preset unloading point. The target vehicle transport distance is the minimum vehicle transport distance corresponding to the target unloading point, representing the average vehicle transport distance for transporting construction materials from the target material station to the target unloading point using transportation vehicles.

[0012] In one optional implementation, the distance calculation module includes a planning unit and a calculation unit;

[0013] The planning unit is configured to determine the adjacent highways of each tension section based on information on multiple tension sections and highway information within a preset range of the line to be constructed. The adjacent highway is the highway with the smallest distance from the tension section.

[0014] For each tension section, at least one preset unloading point and at least one preset material station are determined on the adjacent highway of each tension section. The preset unloading point with the smallest total distance to all transmission towers in the tension section is taken as the target unloading point of the tension section, thus obtaining the target unloading point of each tension section. The preset material station with the smallest total distance to the target unloading point of each tension section is taken as the target material station.

[0015] The calculation unit is configured to determine the target manual transport distance of the line to be constructed using a preset manual transport distance algorithm based on the bending coefficient of each tension section, the amount of line material in each tension section, and the straight-line distance from the target unloading point of each tension section to the construction point of its corresponding tension section; the bending coefficient of each tension section is determined based on the terrain information within a preset range of the line to be constructed, and the amount of line material in each tension section is determined based on the location information of each transmission tower in each tension section;

[0016] Determine the distance from the target unloading point to the target material station for each tension section, and then perform a weighted average of the distances from the target unloading point to the target material station for each tension section to obtain the target vehicle transport distance for the line to be constructed.

[0017] In one optional embodiment, the construction site transportation distance calculation system further includes: a script generation module; the script generation module is connected to both the import parsing module and the transportation distance calculation module;

[0018] The script generation module is configured to generate a script file based on communication rules and distance calculation rules; the script file includes import statements, interaction statements, and distance calculation statements; the interaction statements include a first interaction statement.

[0019] In one optional embodiment, the construction site transportation distance calculation system further includes a script execution module, which is configured to call and execute the script file generated by the script generation module.

[0020] In one optional embodiment, the construction site transportation distance calculation system further includes: a script monitoring module, which is configured to monitor the execution status of the script file generated by the script generation module by the script execution module; and determine whether the script file is executed correctly based on the execution status of the script file.

[0021] In one optional implementation, the script monitoring module is further configured to generate a re-execution instruction when it is determined from the execution status of the script file that the script file has not been executed correctly, and send the re-execution instruction to the script execution module; the re-execution instruction is used to instruct the script execution module to re-execute the script file.

[0022] In one optional embodiment, the construction site transportation distance calculation system further includes: a display module connected to the transportation distance calculation module, the display module including a display interface and a result output module connected to the transportation distance calculation module;

[0023] The display module is configured to receive the target manpower transport distance and the target vehicle transport distance sent by the transport distance calculation module, and display the target manpower transport distance and the target vehicle transport distance on the display interface;

[0024] The result output module is configured to receive the target human transport distance and the target vehicle transport distance sent by the transport distance calculation module, and send the target human transport distance and the target vehicle transport distance to the target terminal through the communication interface, or store the target human transport distance and the target vehicle transport distance locally.

[0025] Secondly, the present invention provides a method for calculating the transportation distance at a construction site, the method comprising:

[0026] Import the target format file according to the import statement in the script file;

[0027] The target format file is parsed according to the parsing statements in the script file to determine the transportation route information; the transportation route information includes: information on multiple tension sections and highway information and terrain information within the preset range of the line to be constructed; the information on a single tension section includes the location information of multiple transmission towers;

[0028] The transportation route information is sent to the distance calculation module according to the first interactive statement in the script file;

[0029] Based on the distance calculation statements in the script file, the target manpower transportation distance and the target vehicle transportation distance of the route to be constructed are determined according to the transportation route information.

[0030] Thirdly, the present invention provides a computer device, comprising: a memory and a processor, the memory and the processor being communicatively connected to each other, the memory storing computer instructions, and the processor executing the computer instructions to perform the construction site transportation distance calculation system of the first aspect or any corresponding embodiment described above.

[0031] Fourthly, the present invention provides a computer-readable storage medium storing computer instructions for causing a computer to execute the construction site transportation distance calculation system of the first aspect or any corresponding embodiment described above.

[0032] The technical solution provided by this invention has the following technical effects:

[0033] This invention achieves accurate calculation of transportation distances through the collaborative work of an import parsing module and a transportation distance calculation module. By automating the reading and parsing of target format files, errors from manual input are avoided, while simultaneously improving calculation speed. The transportation distance calculation module can automatically calculate the target manpower and vehicle transportation distances for the route to be constructed based on the transportation route information, improving the efficiency and accuracy of manpower and vehicle transportation distance calculations, thereby enhancing the rationality of project costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the specific embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0035] Figure 1 This is a structural block diagram of a construction site transportation distance calculation system according to an embodiment of the present invention;

[0036] Figure 2 This is a structural block diagram of another construction site transportation distance calculation system according to an embodiment of the present invention;

[0037] Figure 3 This is a flowchart illustrating the construction site transportation distance calculation method according to an embodiment of the present invention;

[0038] Figure 4 This is a schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0039] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0040] Current technologies for calculating transportation distances have the following problems:

[0041] Low efficiency: Traditional manual calculation methods are slow and prone to delays when dealing with site transportation distances, and cannot meet the needs of modern power transmission line projects for rapid response and decision-making.

[0042] Poor accuracy:

[0043] Manual operation is susceptible to subjective factors, resulting in a high error rate in the calculation of transportation distance, which in turn affects the accuracy of the project budget and the control of project cost.

[0044] Difficulties in communication and coordination:

[0045] The lack of an effective data sharing and communication mechanism has led to inconsistencies in the calculation of transportation distances among different units, affecting the overall coordination and execution of the project.

[0046] Therefore, embodiments of the present invention provide a construction site transportation distance calculation system, method, computer equipment, and storage medium to solve the above problems, improve calculation efficiency, reduce errors, and realize unified calculation of transportation distances between different units.

[0047] This embodiment provides a construction site transportation distance calculation system, which is built based on Robotic Process Automation (RPA) technology and is used to implement the following embodiments and optional implementation methods. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the system described in the following embodiments is preferably implemented in software, hardware implementation, or a combination of software and hardware, is also possible and contemplated.

[0048] Figure 1 This is a structural block diagram of a construction site transportation distance calculation system according to an embodiment of the present invention, such as... Figure 1 As shown, the construction site transportation distance calculation system provided in this embodiment of the invention includes:

[0049] Import parsing module 11, and distance calculation module 12 connected to import parsing module 11.

[0050] The import parsing module 11 is configured to import a target format file based on import statements in a script file. It then parses the target format file according to the parsing statements in the script file to determine the transportation route information. Finally, it sends the transportation route information to the distance calculation module 12 based on the first interactive statement in the script file. The transportation route information includes: information on multiple tension sections and road and terrain information within the preset range of the line to be constructed. Information on a single tension section includes the location information of multiple transmission towers.

[0051] The distance calculation module 12 is configured to determine the target manpower and vehicle distance of the route to be constructed based on the distance calculation statement in the script file and the transportation route information.

[0052] In this embodiment, the transportation distance includes the target manual transport distance and the target vehicle transport distance. The target manual transport distance is the minimum manual transport distance, representing the average distance traveled manually to transport construction materials from the target unloading point located on the highway to the construction site. The target unloading point is the unloading point corresponding to the minimum manual transport distance determined from at least one preset unloading point. The target vehicle transport distance is the minimum vehicle transport distance corresponding to the target unloading point, representing the average vehicle transport distance used to transport construction materials from the target material station to the target unloading point.

[0053] In this embodiment, the target format file is a KML format file. Based on the target format file, three-dimensional map data of the preset range of the line to be constructed can be obtained. Multiple tension section information and highway and terrain information within the preset range of the line to be constructed are determined based on the three-dimensional map data. The form of transportation route information includes, but is not limited to, data, lists, and images. The import parsing module 11 identifies tension towers and straight-line towers by parsing the target format file. Multiple straight-line towers are located between every two tension towers, and tension sections are located between tension towers. By identifying the tension towers, the tension sections constituting the line to be constructed are determined. Tension sections are the basic management unit of power lines; therefore, this embodiment uses tension sections as the basic planning unit for road planning.

[0054] In this embodiment, the import parsing module 11 includes a file generation component, a file reading component, and a data parsing component.

[0055] The document generation component includes an input interface, a validation tool, and a KML file builder. The input interface is configured to allow users to input geographic data via a form, display a visual map, and allow users to directly add or adjust geographic coordinates on the map. The visual map displays the user-input geographic data. The validation tool is configured to validate the geographic data entered by the user in the input interface according to preset validation rules, ensuring the accuracy of the input data and providing prompts and corrections when errors are found. The KML file builder is configured to convert the geographic data entered by the user in the input interface into a KML format file, specifically by constructing the KML structure and embedding geographic data using industry standards.

[0056] The file reading component is configured to import target format files based on import statements in a script file. Specifically, the target format file can be imported by executing the import statements in the script file.

[0057] The data parsing component is configured to parse the target format file to determine the transportation route information based on the parsing statements in the script file. Specifically, it can parse the target format file to determine the transportation route information by executing the parsing statements in the script file, and parse the coordinate data in the target format file into a computable format, including coordinate transformation and data standardization.

[0058] In this embodiment, the distance calculation module 12 also includes a Geographic Information System (GIS) data interface and a configuration interface. The distance calculation module 12 also includes a configuration interface.

[0059] The GIS data interface provides an integration point with external GIS systems, allowing the import and export of geographic data and supporting multiple GIS data formats.

[0060] The configuration interface is designed to allow users to configure corresponding distance calculation rules and other parameters according to specific transportation distance calculation needs. Users interact with the construction site transportation distance calculation system through an intuitive interface to set rules and parameters, without needing to understand the underlying automation logic, thus improving the user experience.

[0061] In this embodiment, the distance calculation module 12 may include a planning unit and a calculation unit.

[0062] The planning unit is configured to determine the adjacent highways of each tension section based on information on multiple tension sections and highway information within the preset range of the line to be constructed. The adjacent highway is the highway with the smallest distance from the tension section.

[0063] In this embodiment, to minimize the manual transport distance, the materials required for construction need to be placed on the road closest to the construction line. Methods for determining the nearest road to each tension section include, but are not limited to, determining the nearest road to each tension section based on 3D map data, through manual means or image recognition. The nearest roads to each tension section may not be on the same road, but the roads are interconnected; alternatively, they can be assumed to be a single road. Therefore, each tension section corresponds to a target unloading point, and the entire construction line is assumed to have a single target material station.

[0064] The planning unit is configured to identify at least one pre-set unloading point and at least one pre-set material station on the adjacent road for each tension section. The pre-set unloading point with the smallest total distance to all transmission towers in the tension section is designated as the target unloading point for that tension section, thus obtaining the target unloading points for each tension section. Similarly, the pre-set material station with the smallest total distance to the target unloading points of each tension section is designated as the target material station.

[0065] In this embodiment, the preset unloading point can be any point on the adjacent road of a single tension section. Specifically, it can be any point between the perpendicular intersections A and B of the starting tower and ending tower of the single tension section and the adjacent road of the single tension section. In this embodiment, considering that the adjacent road of a single tension section is relatively long and the terrain between the unloading point and the construction point may be rugged, making it difficult to determine the target unloading point, this embodiment first determines at least one preset unloading point. Based on the total distance between the preset unloading point and each transmission tower in the tension section, the preset unloading point with the smallest total distance is determined from the at least one preset unloading point as the target unloading point.

[0066] In this embodiment, the preset material station can be any point on the adjacent highway of a single tension section.

[0067] The calculation unit is configured to determine the target manual transport distance of the line to be constructed based on the bending coefficient of each tension section, the amount of line material in each tension section, and the straight-line distance from the target unloading point of each tension section to the construction point of its corresponding tension section, using a preset manual transport distance algorithm. The bending coefficient of each tension section is determined based on the terrain information within a preset range of the line to be constructed, and the amount of line material in each tension section is determined based on the location information of each transmission tower in each tension section.

[0068] In this embodiment, the calculation formula for the preset human transport distance algorithm is as follows:

[0069]

[0070] Among them, Y j L represents the distance traveled by human labor. j This indicates the amount of material used in each tension section of the railway line, represented by the length of each tension section. Rj This represents the straight-line distance from the target unloading point of each tension section to the construction point of its corresponding tension section, and K represents the bending coefficient. This is just an example and is not a limitation.

[0071] In this embodiment, the curvature coefficient refers to the ratio of the actual transport distance to the straight-line distance, reflecting the curvature of the transport path due to terrain, topography, and ground obstacles, including uphill, downhill, mountain roads, and the distribution of materials from one unloading point to multiple transmission towers. Each terrain type is assigned a corresponding curvature coefficient based on actual conditions to reflect the impact of different terrains on manual transport distances. The curvature coefficient of each tension section is determined based on the terrain information from each tension section to the adjacent highway. For example: the curvature coefficient for flat land is 1.05–1.1; for swamps, it is 1.1–1.2; for hills, it is 1.1–1.3; for mountains, it is 1.3–1.5; for high mountains and steep ridges, it is 1.6–1.8; and for deserts, it is 1.3–1.5. These are merely examples and are not intended to limit the scope. As an example, the length of the transmission line between adjacent transmission towers can be determined based on the location information of each transmission tower in each tension section. The sum of the lengths of the transmission lines between each adjacent transmission tower in a single tension section is the line length of that tension section. The line length of that tension section is used as the amount of line material for that tension section. The amount of line material for each tension section can be determined according to the above scheme.

[0072] The calculation unit is configured to determine the distance from the target unloading point to the target material station for each tension section, and to calculate the weighted average of the distances from the target unloading point to the target material station for each tension section to obtain the target vehicle transport distance for the line to be constructed.

[0073] In this embodiment, the calculation unit is specifically configured to calculate the distance from the target unloading point to the target material station of each tension section based on the image or latitude and longitude information of the target unloading point and the target material station of each tension section. Based on the distance from the target unloading point to the target material station of each tension section, a weighted average of the material transport distance of the vehicle between the target material station and the target unloading point of each tension section is determined, and the weighted average is used as the vehicle transport distance of the transmission line project.

[0074] Based on the actual vehicle transport distance from the target material station to the target unloading point on the map, the average vehicle transport distance is calculated using the following formula:

[0075]

[0076] Among them, Y i Indicates the vehicle transport distance, L i The material quantity of each tension section of the railway line (represented by the length of each tension section), R iThe transportation distance of materials for each tension section of the railway by car or ship, where C represents the distance exceeding the next station (referring to the portion of the transportation distance from the railway station or dock to the construction site material station that exceeds the price of materials not included in the quota for the next station transportation distance, which can be included in the construction site transportation distance as stipulated in the price of materials not included in the quota; if there is no stipulation, it will not be included).

[0077] In this embodiment, the script file enables automatic data transfer between the import parsing module 11 and the distance calculation module 12. The import parsing module 11 can automatically send the transportation route information to the distance calculation module 12 according to the first interactive statement in the script file. The distance calculation module 12 can automatically determine the target manpower transportation distance and the target vehicle transportation distance of the route to be constructed based on the transportation route information according to the distance calculation statement in the script file.

[0078] Figure 2 This is a structural block diagram of another construction site transportation distance calculation system according to an embodiment of the present invention, such as... Figure 2 As shown, the construction site transportation distance calculation system provided in this embodiment of the invention includes, in addition to the above-mentioned import parsing module 11 and transportation distance calculation module 12 connected to the import parsing module 11, a script generation module 13, a script execution module 14 and a script monitoring module 15.

[0079] The script generation module 13 is integrated with the import parsing module 11 and the distance calculation module 12. The script generation module 13 is configured to generate script files based on communication rules and distance calculation rules. The script files include statements including, but not limited to, import statements, interaction statements, and distance calculation statements. The interaction statements include a first interaction statement. Each statement corresponds to one task.

[0080] The script generation module 13 is also connected to the script execution module 14, and the script generation module 13 is also configured to send the generated script file to the script execution module 14. The script execution module 14 is connected to both the import parsing module 11 and the distance calculation module 12.

[0081] The script execution module 14 is configured to call and execute the script file generated by the script generation module 13.

[0082] The script execution module 14 is specifically configured to call and execute statements in the script file generated by the script generation module 13 according to the statement execution order. The statement execution order can be pre-set according to priority. Specifically, the script execution module 14 can be a task scheduler, responsible for script execution management, including task queuing and priority allocation, to ensure that the script is executed efficiently in a predetermined order and at a predetermined time.

[0083] The script monitoring module 15 is connected to the script generation module 13, the script execution module 14, the import parsing module 11, and the distance calculation module 12.

[0084] The script monitoring module 15 is configured to monitor the execution status of script files generated by the script generation module 13 and executed by the script execution module 14. It determines whether the script files are executed correctly based on the execution status of the script files.

[0085] The script monitoring module 15 is also configured to generate a re-execution command and send it to the script execution module 14 when it is determined from the execution status of the script file that the script file has not been executed correctly. The re-execution command is used to instruct the script execution module 14 to re-execute the script file.

[0086] Specifically, the script monitoring module 15 can be configured to, based on the execution status of statements in the script file, determine when a statement in the script file has not been executed correctly, generate a re-execution instruction based on the incorrectly executed statement in the script file, and send the re-execution instruction to the script execution module 14. In other words, when the script monitoring module 15 detects that a statement currently being executed by the script execution module 14 has not been executed correctly, it generates and sends a re-execution instruction to the script execution module 14. The script execution module 14 is also configured to, upon receiving a re-execution instruction, re-execute the incorrectly executed statement in the script file according to the re-execution instruction.

[0087] The script monitoring module 15 is also configured to generate a continue execution instruction when it determines that the statements in the script file are being executed correctly based on the execution status of the statements in the script file. This continue execution instruction is then sent to the script execution module 14. The continue execution instruction instructs the script execution module 14 to call and execute the next statement in the script file generated by the script generation module 13 according to the statement execution order.

[0088] In this embodiment, the communication rules include, but are not limited to, import rules and interaction rules. As an example, the interaction rules may include a first interaction rule between the import parsing module 11 and the distance calculation module 12, and a second interaction rule between the planning unit and the calculation unit in the distance calculation module 12. The script generation module 13 can be configured to generate import statements based on the import rules, generate first interaction statements based on the first interaction rule, and generate second interaction statements based on the second interaction rule. In this embodiment, in addition to the aforementioned first and second interaction rules, the interaction rules should also include interaction rules between other modules, and correspondingly, interaction statements generated based on the interaction rules between other modules. For example, interaction rules between the script generation module 13 and the script execution module 14, the script monitoring module 15 and the script execution module 14, the display module 16 and the distance calculation module 12, and the result output module 17 and the distance calculation module 12.

[0089] In this embodiment, the construction site transportation distance calculation system is equipped with a script monitoring module 15. This module not only monitors the execution status of each statement in the script file but also determines whether a statement has been executed correctly based on its execution status. If a statement is not executed correctly, it generates a re-execution instruction for that statement, which the script execution module 14 can then re-execute. The script monitoring module 15 is configured to monitor the entire execution process of the script file, ensuring correct data transmission between modules and guaranteeing the efficiency of transportation distance calculation.

[0090] In this embodiment, the script generation module 13 can automatically generate script files based on the communication rules and distance calculation rules determined by the communication requirements between various modules in the construction site transportation distance calculation system. The script execution module 14 executes the script files to achieve import, parsing, calculation and output, thereby automating the transportation distance calculation of the construction site transportation distance calculation system and effectively avoiding errors caused by manual operation.

[0091] like Figure 2 As shown, the construction site transportation distance calculation system provided in this embodiment of the invention further includes: a display module 16 connected to the transportation distance calculation module 12, and a result output module 17 connected to the transportation distance calculation module 12. Both the display module 16 and the result output module 17 are also connected to the script execution module 14 and the script monitoring module 15.

[0092] The distance calculation module 12 is also configured to send the target manpower distance and target vehicle distance of the route to be constructed to the display module 16 and the result output module 17.

[0093] Display module 16 includes a display interface.

[0094] The display module 16 is configured to receive the target manpower and vehicle transport distances for the route to be constructed from the transport distance calculation module 12, and display these distances on the display interface. It can generate transport distance reports according to preset formats, which may include text, charts, or graphics, among others. This allows users to easily view the target manpower and vehicle transport distances for the route to be constructed on the display interface.

[0095] The output module 17 includes a selection interface. The selection interface allows the user to choose whether to send the target manpower and vehicle transport distances of the route to be constructed to the target terminal via the communication interface, or to store the target manpower and vehicle transport distances of the route to be constructed locally.

[0096] The result output module 17 is configured to receive the target manpower transport distance and the target vehicle transport distance sent by the transport distance calculation module 12, and send the target manpower transport distance and the target vehicle transport distance to the target terminal through the communication interface, or store the target manpower transport distance and the target vehicle transport distance locally for the convenience of users and relevant units to view and use.

[0097] The result output module 17 is specifically configured to receive the target manpower transport distance and target vehicle transport distance sent by the transport distance calculation module 12. After receiving the target manpower transport distance and target vehicle transport distance sent by the transport distance calculation module 12, it displays a selection interface and outputs the target manpower transport distance and target vehicle transport distance according to the output method selected by the user on the selection interface, or outputs the target manpower transport distance and target vehicle transport distance according to the preset method when the time is greater than or equal to a preset time. The output method selected by the user on the selection interface includes at least one of the first output method and the second output method. The first output method is to send the target manpower transport distance and target vehicle transport distance to a specified WeChat group or individual user in the target terminal through the communication interface. The second output method is to store the target manpower transport distance and target vehicle transport distance in a local folder or file. The preset time is initially a default value and can be modified according to actual needs. The preset method is initially a default method, which includes at least one of the first output method and the second output method and can be modified according to actual needs.

[0098] In this embodiment, a suitable RPA tool or platform is needed to develop the result output module 17. The automated process created by the RPA tool or platform includes reading the target manpower transport distance and target vehicle transport distance sent by the transport distance calculation module 12, and sending the target manpower transport distance and target vehicle transport distance as messages to a designated WeChat group or individual user through the communication interface, or storing them in a local folder or file.

[0099] The output module 17 is also configured to determine the communication interface and related message sending mechanism, determine the storage path of the local folder or file, and configure write permissions. If it is necessary to send the target manpower transport distance and target vehicle transport distance to a designated WeChat group or individual user, it may be necessary to integrate with the interface of the WeChat group or individual user to obtain authorization and related login information.

[0100] The output module 17 can also automatically send transportation distance reports through various channels such as email and WeChat, while providing local storage and printing functions.

[0101] Technical effects of the present invention:

[0102] To address the cumbersome process of manually calculating transportation distances, which is easily limited by individual experience and skills, this invention provides a transportation distance calculation module 12 in the construction site transportation distance calculation system. This module integrates transportation distance calculation, achieving automated calculation. The system can automatically calculate transportation distances based on transportation route information, improving calculation accuracy. Users only need to import the target format file to automatically determine the transportation distance, simplifying the operation process.

[0103] To address the issues of manual operation, error-proneness, and low efficiency in data transfer and processing during transportation distance calculation, this invention provides a construction site transportation distance calculation system that utilizes RPA technology. RPA automates the entire transportation distance calculation process, including data reading, processing, and transportation distance output. It ensures automatic data transfer between modules, guaranteeing accuracy and consistency across different processing stages, reducing manual intervention and error rates. Furthermore, automated processing accelerates the overall response speed of transportation distance calculation, enabling rapid result output. Applying RPA technology automatically retrieves necessary transportation route information from KML format files and relevant data sources (e.g., GIS systems) without manual intervention. Detailed log records are generated during script execution, enhancing the traceability of the calculation process and facilitating auditing and monitoring.

[0104] To address the issue that the sharing and communication of transportation distance calculation results relies on manual methods, hindering rapid decision-making and coordination, the display module 16 and result output module 17 in the construction site transportation distance calculation system provided by this invention can automatically display transportation distances and automatically send the calculation results to designated WeChat groups or store them locally using RPA technology, facilitating immediate viewing and communication. This automated result output and communication mechanism enables relevant users and units to obtain transportation distances instantly, and the immediate sharing of transportation distance calculation results improves the transparency of transportation distance calculation.

[0105] By automating KML file import and parsing, and integrating the distance calculation module 12, this invention significantly reduces the time spent on manual input and calculation. This automated process makes transportation distance calculation faster, thereby improving overall work efficiency.

[0106] This invention automatically calculates transportation distance using precise location data of the origin, destination, and route between them, reducing the possibility of human input errors. Furthermore, the transportation distance calculation module 12 comprehensively considers multiple factors to ensure the accuracy of the calculation results.

[0107] The application of RPA technology automates the transfer of data between different processing stages and modules, reducing the complexity and error rate of data management. Automated data management not only improves the efficiency of data processing but also ensures data consistency and reliability.

[0108] The real-time output and communication mechanism of transportation distance calculation results enables rapid sharing of these results with all relevant parties. By automatically sending results to WeChat groups or storing them locally, this invention enhances communication and coordination between the project team and stakeholders.

[0109] According to an embodiment of the present invention, a method for calculating the transportation distance at a construction site is provided. It should be noted that the steps shown in the flowchart in the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions. Furthermore, although a logical order is shown in the flowchart, in some cases, the steps shown or described may be executed in a different order than that shown here.

[0110] Figure 3 This is a flowchart illustrating the construction site transportation distance calculation method according to an embodiment of the present invention, as shown below. Figure 3 As shown in the embodiment of the present invention, a method for calculating construction site transportation distance is provided and applied to the above-mentioned construction site transportation distance calculation system embodiment or any optional implementation method. The construction site transportation distance calculation system includes: an import parsing module and a transportation distance calculation module connected to the import parsing module. The construction site transportation distance calculation method includes:

[0111] S101: Import the target format file according to the import statement in the script file, and parse the target format file according to the parsing statement in the script file to determine the transportation path information.

[0112] In this embodiment, the transport route information is sent to the transport distance calculation module according to the first interactive statement in the script file. The transport route information includes: information on multiple tension sections and highway and terrain information within a preset range of the line to be constructed. The information on a single tension section includes the location information of multiple transmission towers.

[0113] S102: Based on the distance calculation statement in the script file, determine the target manpower transportation distance and the target vehicle transportation distance of the route to be constructed according to the transportation route information.

[0114] In one optional implementation, determining the target manpower transport distance and target vehicle transport distance of the route to be constructed based on the transport route information in step S102 includes:

[0115] Based on information from multiple tension sections and highway information within the pre-defined range of the line to be constructed, the adjacent highways for each tension section are determined. The adjacent highway is the highway with the smallest distance from the tension section.

[0116] For each tension section, at least one pre-designated unloading point and at least one pre-designated material station are identified on the adjacent highway. The pre-designated unloading point with the smallest total distance to all transmission towers in that tension section is selected as the target unloading point for that tension section, thus obtaining the target unloading points for each tension section. Similarly, the pre-designated material station with the smallest total distance to the target unloading points of each tension section is selected as the target material station.

[0117] Based on the bending coefficient of each tension section, the amount of line material in each tension section, and the straight-line distance from the target unloading point of each tension section to its corresponding construction point, the target manual transport distance for the line to be constructed is determined using a preset manual transport distance algorithm. The bending coefficient of each tension section is determined based on the terrain information within a preset range of the line to be constructed, and the amount of line material in each tension section is determined based on the location information of each transmission tower in each tension section.

[0118] Determine the distance from the target unloading point to the target material station for each tension section, and then calculate a weighted average of these distances to obtain the target vehicle transport distance for the line to be constructed.

[0119] In one optional implementation, the construction site transportation distance calculation method is applied to a construction site transportation distance calculation system, which further includes a script generation module. The script generation module is connected to both the import / parsing module and the transportation distance calculation module.

[0120] The method for calculating the transportation distance at the construction site also includes generating a script file based on communication rules and transportation distance calculation rules. The script file includes import statements, interactive statements, and transportation distance calculation statements. The interactive statements include a first interactive statement.

[0121] In one optional implementation, the construction site transportation distance calculation system to which the construction site transportation distance calculation method is applied further includes a script execution module.

[0122] The method for calculating the transportation distance at the construction site also includes: calling and executing the script file generated by the script generation module.

[0123] In one optional implementation, the construction site transportation distance calculation system to which this construction site transportation distance calculation method is applied further includes a script monitoring module.

[0124] The method for calculating the transportation distance at the construction site also includes: monitoring the execution status of the script files generated by the script generation module and executing the script execution module. The execution status of the script files is used to determine whether the script files are executed correctly.

[0125] In one optional implementation, determining whether a script file has been executed correctly based on its execution status includes: if it is determined that the script file has not been executed correctly, generating a re-execution instruction and sending the re-execution instruction to the script execution module. The re-execution instruction is used to instruct the script execution module to re-execute the script file.

[0126] In one optional embodiment, the construction site transportation distance calculation system to which the construction site transportation distance calculation method is applied further includes: a display module connected to the transportation distance calculation module, the display module including a display interface and a result output module connected to the transportation distance calculation module.

[0127] The method for calculating the transportation distance at the construction site also includes: receiving the target manpower transportation distance and the target vehicle transportation distance sent by the transportation distance calculation module, and displaying the target manpower transportation distance and the target vehicle transportation distance on the display interface.

[0128] The method for calculating the transportation distance at the construction site also includes: receiving the target manpower transportation distance and the target vehicle transportation distance sent by the transportation distance calculation module, and sending the target manpower transportation distance and the target vehicle transportation distance to the target terminal through the communication interface, or storing the target manpower transportation distance and the target vehicle transportation distance locally.

[0129] It should be noted that the contents not described in detail in this specification are common knowledge to those skilled in the art.

[0130] This invention also provides a computer device; please refer to [link / reference]. Figure 4 , Figure 4 This is a schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention, such as... Figure 4 As shown, the computer device includes one or more processors 10, memory 20, and interfaces for connecting the components, including high-speed interfaces and low-speed interfaces. The components communicate with each other via different buses and can be mounted on a common motherboard or otherwise installed as needed. The processors can process instructions executed within the computer device, including instructions stored in or on memory to display graphical information of a GUI on external input / output devices (such as display devices coupled to the interfaces). In some alternative implementations, multiple processors and / or multiple buses can be used with multiple memories and multiple memory modules, if desired. Similarly, multiple computer devices can be connected, each providing some of the necessary operations (e.g., as a server array, a group of blade servers, or a multiprocessor system). Figure 4 Take a processor 10 as an example.

[0131] Processor 10 may be a central processing unit, a network processor, or a combination thereof. Processor 10 may further include a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (PLD), or a combination thereof. The programmable logic device may be a complex programmable logic device (CAMP), a field-programmable gate array (FPGA), a general-purpose array logic (GDA), or any combination thereof.

[0132] The memory 20 stores instructions executable by at least one processor 10 to cause at least one processor 10 to perform the method shown in the above embodiments.

[0133] The memory 20 may include a program storage area and a data storage area. The program storage area may store the operating system and applications required for at least one function. The data storage area may store data created based on the use of the computer device. Furthermore, the memory 20 may include high-speed random access memory and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid-state storage device. In some alternative embodiments, the memory 20 may optionally include memory remotely located relative to the processor 10, which can be connected to the computer device via a network. Examples of such networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.

[0134] Memory 20 may include volatile memory, such as random access memory. Memory may also include non-volatile memory, such as flash memory, hard disk, or solid-state drive. Memory 20 may also include combinations of the above types of memory.

[0135] The computer device also includes a communication interface 30 for communicating with other devices or communication networks.

[0136] This invention also provides a computer-readable storage medium. The methods described above according to embodiments of the invention can be implemented in hardware or firmware, or implemented as computer code that can be recorded on a storage medium, or implemented as computer code downloaded over a network and originally stored on a remote storage medium or a non-transitory machine-readable storage medium and then stored on a local storage medium. Thus, the methods described herein can be processed by software stored on a storage medium using a general-purpose computer, a dedicated processor, or programmable or dedicated hardware. The storage medium can be a magnetic disk, optical disk, read-only memory, random access memory, flash memory, hard disk, or solid-state drive, etc. Further, the storage medium may also include combinations of the above types of memory. It is understood that computers, processors, microprocessor controllers, or programmable hardware include storage components capable of storing or receiving software or computer code, which, when accessed and executed by the computer, processor, or hardware, implements the methods shown in the above embodiments.

[0137] Although embodiments of the invention have been described in conjunction with the accompanying drawings, those skilled in the art can make various modifications and variations without departing from the spirit and scope of the invention, and such modifications and variations all fall within the scope defined by the appended claims.

Claims

1. A construction site transportation distance calculation system, characterized in that: include: An import and analysis module, and a transport distance calculation module connected to the import and analysis module; The import parsing module is configured to import the target format file according to the import statement in the script file; Parsing the target format file according to the parsing statements in the script file to determine the transport path information; Sending the transport path information to the transport distance calculation module according to the first interactive statement in the script file; The transport route information includes: information on multiple tension sections and highway information and terrain information within a preset range of the line to be constructed; information on a single tension section includes location information on multiple transmission towers; The transport distance calculation module is configured to determine the target manpower transport distance and target vehicle transport distance of the line to be constructed according to the transport path information based on the transport distance calculation statement in the script file; Among them, the target manpower transportation distance is the minimum manpower transportation distance, which indicates the average manpower transportation distance for transporting construction materials from the target unloading point on the highway to the construction point by manpower, and the target unloading point is the unloading point corresponding to the minimum manpower transportation distance determined from at least one preset unloading point; the target vehicle transportation distance is the minimum vehicle transportation distance corresponding to the target unloading point, which indicates the average vehicle transportation distance for transporting construction materials from the target material station to the target unloading point by means of transportation.

2. The system according to claim 1, characterized in that The transport distance calculation module includes a planning unit and a calculation unit; The planning unit is configured to determine the adjacent highways of each tension section according to the information of the plurality of tension sections and the highway information within the preset range of the line to be constructed, wherein the adjacent highway is the highway with the shortest distance from the tension section; For the adjacent roads of each tension section, at least one preset unloading point and at least one preset material station on the adjacent roads of a single tension section are determined, and the preset unloading point with the smallest total distance from each transmission tower in the single tension section among the at least one preset unloading point is used as the target unloading point of the single tension section, so as to obtain the target unloading point of each tension section; The preset material station with the smallest total distance from the target unloading point of each tension section among all preset material stations is taken as the target material station; The calculation unit is configured to determine the target manpower transportation distance of the line to be constructed by using a preset manpower transportation distance algorithm according to the bending coefficient of each tension section, the amount of line material of each tension section, and the straight-line distance from the target unloading point of each tension section to the construction point of its corresponding tension section; the bending coefficient of each tension section is determined according to the terrain information within the preset range of the line to be constructed, and the amount of line material of each tension section is determined according to the position information of each transmission tower in each tension section; The distance from the target unloading point of each tension section to the target material station is determined, and the distance from the target unloading point of each tension section to the target material station is weighted averaged to obtain the target vehicle transportation distance of the line to be constructed.

3. The system according to claim 1, characterized in that The construction site transportation distance calculation system further includes: a script generation module; the script generation module is connected to the import analysis module and the transportation distance calculation module; The script generation module is configured to generate a script file according to the communication rules and the distance calculation rules; the script file includes an import statement, an interaction statement and a distance calculation statement; the interaction statement includes a first interaction statement.

4. The system according to claim 3, characterized in that The construction site transportation distance calculation system further includes: a script execution module, which is configured to call and execute the script file generated by the script generation module.

5. The system according to claim 4, characterized in that The construction site transportation distance calculation system also includes: a script monitoring module, which is configured to monitor the execution status of the script file generated by the script generation module by the script execution module; and determine whether the script file is executed correctly according to the execution status of the script file.

6. The system according to claim 5, characterized in that The script monitoring module is also configured to generate a re-execution instruction when it is determined that the script file is not executed correctly based on the execution status of the script file, and send the re-execution instruction to the script execution module; the re-execution instruction is used to instruct the script execution module to re-execute the script file.

7. The system according to claim 1, characterized in that The construction site transportation distance calculation system further includes: a display module connected to the transportation distance calculation module, the display module including a display interface, and a result output module connected to the transportation distance calculation module; The display module is configured to receive the target manpower transportation distance and the target vehicle transportation distance sent by the transportation distance calculation module, and display the target manpower transportation distance and the target vehicle transportation distance on the display interface; The result output module is configured to receive the target manpower distance and the target vehicle distance sent by the distance calculation module, and send the target manpower distance and the target vehicle distance to the target terminal through the communication interface, or store the target manpower distance and the target vehicle distance locally.

8. A method for calculating the construction site transportation distance, characterized in that: include: Import the target format file according to the import statement in the script file; Parsing the target format file according to the parsing statements in the script file to determine the transport path information; The transport route information includes: information on multiple tension sections and highway information and terrain information within a preset range of the line to be constructed; information on a single tension section includes location information on multiple transmission towers; Sending the transport path information to a transport distance calculation module according to a first interactive statement in the script file; Based on the distance calculation statement in the script file, the target manpower transportation distance and target vehicle transportation distance of the line to be constructed are determined according to the transportation path information.

9. A computer device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the steps of the method for calculating the construction site transportation distance according to claim 8 by executing the computer instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the steps of the construction site transportation distance calculation method according to claim 8.

Images