Database-based power transmission line path selection system and method

Abstract

The invention relates to the technical field of power transmission line planning, in particular to a power transmission line path selection system and method based on a database, and the system comprises a data collection and preprocessing module, a data storage and management module, an algorithm module, an application module and a user interface module. And the data acquisition and preprocessing module is used for acquiring multi-source data of satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data and geological data. According to the method, the power transmission line path is comprehensively evaluated and optimally selected by constructing the standardized database of multi-source data fusion and combining an intelligent optimization algorithm, so that the optimal path planning scheme can be quickly generated according to different constraint conditions and actual requirements, and dynamic adjustment is realized when a power grid fails or the environment is changed; the global optimization and dynamic adjustment of path planning are realized, and the defects of poor data intercommunity, one-sided evaluation and insufficient adaptability in the prior art are overcome.

Description

A database-based transmission line route selection system and method Technical Field

[0001] This invention relates to the field of power transmission line planning technology, specifically to a database-based power transmission line path selection system and method. Background Technology

[0002] The purpose of transmission line route selection is to choose an economically reasonable, safe, easy-to-construct, and compliant route between the starting and ending points, which also conforms to national policies. With the development of the power system, the requirements for transmission line route selection are constantly increasing. It is necessary not only to reduce construction costs and investment costs, but also to take into account the difficulty of construction and the impact of line operation on the environment along the route. Therefore, transmission line route selection has become a spatial multi-objective decision-making problem involving engineering, environment, and economy.

[0003] Currently, traditional methods and technologies for selecting power transmission line routes have many shortcomings. Existing technologies usually only consider single factors such as terrain and cost, without comprehensively evaluating multi-dimensional parameters such as erection difficulty, obstacle impact, and construction feasibility. This results in a lack of global optimization in route selection, which may lead to difficulties such as poor data interoperability, one-sided evaluation, and insufficient adaptability in actual construction. Summary of the Invention

[0004] The purpose of this invention is to provide a database-based transmission line route selection system and method, which improves the scientificity, accuracy and efficiency of transmission line route selection in power engineering.

[0005] To achieve the above objectives, the present invention provides the following technical solution: a database-based transmission line path selection system, comprising a data acquisition and preprocessing module, a data storage and management module, an algorithm module, an application module, and a user interface module; the data acquisition and preprocessing module is used to acquire multi-source data including satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data, and to perform preprocessing operations on the acquired data, including cleaning, registration, and fusion; the data storage and management module uses a distributed database system to construct a standardized database covering multi-source heterogeneous data, including a terrain database, an obstacle database, and a tower component database. The database comprises sub-databases of the national database, meteorological database, and geological database, and achieves data interconnection and sharing through a data association model; the algorithm module includes an improved multi-peak optimization genetic algorithm module, a Dijkstra algorithm module, a power supply sourcing algorithm module, and a comprehensive scoring calculation module, used to perform path planning and optimization based on user-input constraints and requirements; the application module provides application functions such as path planning, path evaluation, dynamic adjustment, and 3D visualization; the user interface module provides a user-friendly interface that supports users in inputting path planning parameters and constraints, viewing path planning results and 3D visualization models, and performing interactive operations and decision-making.

[0006] As a preferred embodiment of the database-based transmission line path selection system of the present invention, the improved multi-peak optimization genetic algorithm module introduces a multi-peak search mechanism and an adaptive mutation strategy, and evaluates the dependency relationship of path influencing factors through a sequence-to-sequence model.

[0007] As a preferred embodiment of the database-based transmission line path selection system of the present invention, the comprehensive scoring calculation module constructs a multi-dimensional comprehensive scoring model that includes erection cost, obstacle impact, construction difficulty, environmental adaptability, and operation and maintenance cost. The weight of each factor is determined by the analytic hierarchy process, and the comprehensive score of each path is calculated by the fuzzy comprehensive evaluation method.

[0008] As a preferred embodiment of the database-based transmission line path selection system of the present invention, the dynamic adjustment module combines the Dijkstra algorithm and the power supply sourcing algorithm of the substation to adjust the path planning results in real time when there is a power grid fault or environmental change.

[0009] A database-based transmission line route selection method includes the following steps: Step 1, data acquisition and preprocessing: acquiring multi-source data and performing preprocessing operations such as data cleaning, registration, and fusion; Step 2, constraint labeling: labeling the constraints of the transmission line route on a topographic map; Step 3, preliminary route design: generating multiple sets of candidate routes using an improved multi-peak optimization genetic algorithm based on the user-input start point, end point, and constraints; Step 4, route evaluation and optimization: constructing a comprehensive scoring model, calculating the comprehensive score of each candidate route, and selecting the optimal route; Step 5, dynamic route adjustment: adjusting the route planning results in real time using the Dijkstra algorithm and the power supply sourcing algorithm when there is a grid fault or environmental change. As a preferred embodiment of this database-based transmission line route selection method, the multi-source data includes satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data.

[0010] As a preferred embodiment of the database-based transmission line route selection method of the present invention, the comprehensive scoring model includes multiple factors such as erection cost, obstacle impact, construction difficulty, environmental adaptability, and operation and maintenance cost, and the weight of each factor is determined by the analytic hierarchy process.

[0011] Compared with the prior art, the beneficial effects of the present invention are as follows: In the present invention, by constructing a standardized database that integrates multi-source data and combining it with intelligent optimization algorithms, the transmission line path is comprehensively evaluated and optimized. It can quickly generate the optimal path planning scheme according to different constraints and actual needs, and can dynamically adjust it when the power grid fails or the environment changes. This achieves global optimization and dynamic adjustment of path planning, and solves the defects of poor data interoperability, one-sided evaluation, and insufficient adaptability in the prior art. Attached Figure Description

[0012] Figure 1 is a system diagram of the present invention; Figure 2 is a path planning flowchart of the present invention; Figure 3 is a path selection diagram of the present invention. Detailed Implementation

[0013] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

[0014] Please refer to Figures 1 to 3. A database-based transmission line path selection system includes a data acquisition and preprocessing module, a data storage and management module, an algorithm module, an application module, and a user interface module. The data acquisition and preprocessing module collects multi-source data, including satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data. It performs preprocessing operations on the collected data, including cleaning, registration, and fusion, to generate standardized data formats, providing a foundation for subsequent data storage and analysis. The data storage and management module uses a distributed database system to construct a standardized database covering multi-source heterogeneous data, including sub-databases for terrain, obstacle, tower component, meteorological, and geological databases. It achieves data interconnection and sharing through a data association model and employs data backup and recovery mechanisms to ensure data security and reliability. The algorithm module includes an improved multi-peak optimization genetic algorithm. The system comprises several modules: a Dijkstra algorithm module, a power supply sourcing algorithm module, and a comprehensive scoring calculation module. These modules are used to perform path planning and optimization based on user-input constraints and requirements, employing appropriate algorithms. The application module provides path planning, path evaluation, dynamic adjustment, and 3D visualization functions. The path planning function generates alternative paths based on user-input start and end points and constraints. The path evaluation function calculates the comprehensive score for each path and outputs the optimal path. The dynamic adjustment function adjusts the path planning results in real time during power grid faults or environmental changes. The 3D visualization function displays the path planning results as a 3D model for easy viewing and analysis. The user interface module provides a user-friendly interface that allows users to input path planning parameters and constraints, view path planning results and 3D visualization models, and perform interactive operations and decision-making. The user interface uses a graphical interface design, making it simple and easy to understand, suitable for users of different skill levels.

[0015] As a technical optimization scheme of the present invention, the improved multi-peak optimization genetic algorithm module introduces a multi-peak search mechanism and an adaptive mutation strategy, and evaluates the dependency of path influencing factors through a sequence-to-sequence model.

[0016] As a technical optimization scheme of the present invention, the comprehensive scoring calculation module constructs a multi-dimensional comprehensive scoring model that includes construction cost, obstacle impact, construction difficulty, environmental adaptability, and operation and maintenance cost. The weight of each factor is determined by the hierarchical analysis method, and the comprehensive score of each path is calculated by the fuzzy comprehensive evaluation method.

[0017] As a technical optimization scheme of the present invention, the dynamic adjustment module combines the Dijkstra algorithm and the power supply sourcing algorithm of the power station to adjust the path planning results in real time when the power grid fails or the environment changes.

[0018] By establishing a comprehensive data standardization system, different types of data are uniformly encoded and formatted to ensure data consistency and compatibility. At the same time, a data association model is constructed to explore the potential relationships between data, such as the relationship between terrain data and obstacle data, and the relationship between meteorological data and construction difficulty data, so as to provide more in-depth analysis and decision support for route planning.

[0019] Efficient integration of heterogeneous data: Employing a distributed database architecture and middleware technology, it achieves efficient integration of data from different data sources, such as internal enterprise databases, external public databases, and data collected by IoT devices; through data caching and preloading mechanisms, it improves data access speed and response efficiency, meeting the needs of real-time path planning.

[0020] A database-based method for selecting transmission line routes includes the following steps: Step 1, data acquisition and preprocessing: acquiring multi-source data and performing preprocessing operations such as cleaning, registration, and fusion; acquiring data from various sources, including satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data; performing preprocessing operations such as cleaning, denoising, registration, and fusion on the acquired data to generate a standardized data format, providing a foundation for subsequent data storage and analysis.

[0021] Step 2, Constraint Labeling: Label the constraints of the transmission line route on the topographic map; construct a standardized database covering multi-source heterogeneous data by using a distributed database system; the database includes sub-databases such as topographic database, obstacle database, tower component database, meteorological database, and geological database, and realizes data interconnection and sharing through a data association model; at the same time, adopt data backup and recovery mechanisms to ensure data security and reliability.

[0022] Step 3, Preliminary Path Design: Based on the user-inputted starting point, ending point, and constraints, multiple alternative paths are generated using an improved multi-peak optimization genetic algorithm. This is achieved by deploying the improved multi-peak optimization genetic algorithm module, the Dijkstra algorithm module, the power supply sourcing algorithm module, and the comprehensive scoring calculation module. The algorithm layer receives data from the data layer and, based on the user-input constraints and requirements, uses the corresponding algorithms for path planning and optimization.

[0023] Step 4, Path Evaluation and Optimization: Construct a comprehensive scoring model to calculate the comprehensive score of each candidate path and select the optimal path; provide application functions such as path planning, path evaluation, dynamic adjustment, and 3D visualization; the path planning function generates candidate paths based on the user-input start point, end point, and constraints; the path evaluation function calculates the comprehensive score of each path and outputs the optimal path; the dynamic adjustment function adjusts the path planning results in real time when there is a power grid fault or environmental change; the 3D visualization function displays the path planning results in the form of a 3D model, making it convenient for users to view and analyze intuitively.

[0024] Step 5, Dynamic Path Adjustment: In the event of power grid failure or environmental changes, the path planning results are adjusted in real time using the Dijkstra algorithm and the power supply sourcing algorithm at the substation. A user-friendly interface is provided to support users in inputting path planning parameters and constraints, viewing path planning results and 3D visualization models, and performing interactive operations and decision-making. The user interface adopts a graphical interface design, which is simple and easy to understand, making it convenient for users of different levels.

[0025] As a technical optimization of the present invention, the multi-source data includes satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data.

[0026] As a technical optimization scheme of the present invention, the comprehensive scoring model includes multiple factors such as erection cost, obstacle influence, construction difficulty, environmental adaptability, and operation and maintenance cost, and the weight of each factor is determined by the analytic hierarchy process.

[0027] Intelligent generation of alternative paths: Based on the constraints of component attributes in the database, such as tower type, material cost, and insulator specifications, an improved multi-peak optimization genetic algorithm is used to generate multiple sets of alternative paths. Each set of paths contains detailed parameter information, such as the location of corner towers, the location of straight towers, the erection cost, the path length, and the number of obstacles to be crossed, providing a wealth of choices for subsequent path evaluation and optimization.

[0028] Comprehensive Path Evaluation and Optimization: Construct a comprehensive scoring model that includes multiple dimensions such as installation cost, degree of obstacle impact, installation difficulty, construction feasibility, and environmental adaptability; calculate the scores of each indicator for each candidate path, sort them according to the comprehensive score, and output the optimal path planning result; at the same time, it can adjust the weights of the scoring model according to the user's needs and preferences to achieve personalized path optimization.

[0029] Example 1: Planning of a large-scale transmission line project; In a 500kV transmission line project planning project, the system and method of the present invention are used for route selection.

[0030] Data acquisition and processing: Acquire satellite remote sensing data with a resolution of 0.2 meters, oblique photogrammetry data covering an area of ​​20 square kilometers, laser point cloud data with a point density of 100 points / square meter, manual inspection data, meteorological data, and geological data; clean, register, and fuse the data to build a standardized database.

[0031] Path planning: The user inputs the starting point, ending point, and constraints such as avoiding nature reserves and crossing rivers; the system uses an improved multi-peak optimization genetic algorithm to generate 10 alternative paths.

[0032] Path evaluation and optimization: The comprehensive score of each path is calculated based on the comprehensive scoring model, and the optimal path is selected. The evaluation shows that the construction cost of the optimal path is reduced by 15% compared with the traditional method, the obstacle influence coefficient is reduced by 25%, the construction difficulty coefficient is reduced by 20%, and the environmental adaptability score is increased by 28%, which significantly improves the rationality and economy of the path.

[0033] Dynamic adjustment: During project implementation, if local geological disasters are encountered, the system automatically activates the dynamic adjustment module, uses the Dijkstra algorithm to generate detour paths, and refines the paths through the power supply sourcing algorithm of the power station; the detour distance of the adjusted path increases by 10%, but the power supply restoration time is shortened by 50%, ensuring the smooth progress of the project.

[0034] Example 2: Urban power transmission line renovation planning; In a renovation planning project for old power transmission lines in a certain city, the system and method of the present invention are used for path selection.

[0035] Data Acquisition and Processing: Collect satellite remote sensing data, oblique photogrammetry data, laser point cloud data, manual inspection data, and urban planning data for urban areas; after processing the data, construct a database, focusing on constraints such as urban buildings, roads, and underground pipelines.

[0036] Path planning: The user inputs the starting point, destination, and constraints such as avoiding high-rise buildings and underground pipelines; the system generates 8 alternative paths.

[0037] Route evaluation and optimization: Calculate the comprehensive score of each route and select the optimal route; the optimal route minimizes the impact on urban traffic and residents' lives while meeting the safety distance requirements, and the construction cost is reduced by 12% compared with the original plan, and the construction period is shortened by 20%.

[0038] Dynamic adjustment: During construction, if temporary traffic control is encountered, the system will adjust the route planning in a timely manner to ensure the continuity of construction and not have a significant impact on the project progress.

[0039] The above are merely preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A database-based transmission line path selection system, characterized in that: It includes a data acquisition and preprocessing module, a data storage and management module, an algorithm module, an application module, and a user interface module. The data acquisition and preprocessing module is used to acquire multi-source data such as satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data, and to perform preprocessing operations on the acquired data, including cleaning, registration, and fusion. Data storage and management module: A standardized database covering multi-source heterogeneous data is constructed using a distributed database system, including sub-databases for terrain, obstacle, tower component, meteorology, and geology databases. Data interconnection and sharing are achieved through a data association model. Algorithm module: Includes an improved multi-peak optimization genetic algorithm module, a Dijkstra algorithm module, a power supply sourcing algorithm module, and a comprehensive scoring calculation module. These modules are used for path planning and optimization based on user-input constraints and requirements. Application module: Provides application functions such as path planning, path evaluation, dynamic adjustment, and 3D visualization. User interface module: Provides a user-friendly interface that allows users to input path planning parameters and constraints, view path planning results and 3D visualization models, and perform interactive operations and decision-making.

2. The database-based transmission line path selection system according to claim 1, characterized in that: The improved multi-peak optimization genetic algorithm module introduces a multi-peak search mechanism and an adaptive mutation strategy, and evaluates the dependency of path influencing factors through a sequence-to-sequence model.

3. The database-based transmission line path selection system according to claim 1, characterized in that: The comprehensive scoring calculation module constructs a multi-dimensional comprehensive scoring model that includes construction cost, obstacle impact, construction difficulty, environmental adaptability, and operation and maintenance cost. It uses the analytic hierarchy process to determine the weight of each factor and calculates the comprehensive score of each path using the fuzzy comprehensive evaluation method.

4. The database-based transmission line path selection system according to claim 1, characterized in that: The dynamic adjustment module combines Dijkstra's algorithm and the power supply sourcing algorithm to adjust the path planning results in real time when there is a power grid fault or environmental change.

5. A database-based method for selecting transmission line routes, characterized in that, Includes the following steps: Step 1, Data Acquisition and Preprocessing: Acquire multi-source data and perform preprocessing operations such as data cleaning, registration, and fusion; Step 2, Constraint Labeling: Label the constraints of the transmission line route on the topographic map. Step 3, Preliminary Path Design: Based on the user-input start point, end point, and constraints, an improved multi-peak optimization genetic algorithm is used to generate multiple sets of candidate paths. Step 4, Path Evaluation and Optimization: A comprehensive scoring model is constructed to calculate the comprehensive score of each candidate path and select the optimal path. Step 5, Dynamic Path Adjustment: In the event of power grid failure or environmental changes, the path planning results are adjusted in real time using the Dijkstra algorithm and the power supply sourcing algorithm for power plants.

6. The database-based transmission line path selection method according to claim 1, characterized in that: The multi-source data includes satellite remote sensing data, oblique photography data, laser point cloud data, manual inspection data, meteorological data, and geological data.

7. The database-based transmission line path selection method according to claim 1, characterized in that: The comprehensive scoring model includes multiple factors such as installation cost, obstacle impact, construction difficulty, environmental adaptability, and operation and maintenance cost. The weight of each factor is determined using the analytic hierarchy process (AHP).

Images