WebGIS-based power transmission line digital basic model selection method
Through the digital basic selection method based on WebGIS technology, the problem of relying on manual experience and static computing models in the traditional method is solved, and efficient digital selection of the tower foundation is achieved, and design quality and work efficiency are improved.
Patent Information
- Application Number
- CN202411973923.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-30
- Publication Date
- 2025-04-18
AI Technical Summary
The traditional basic selection method relies on manual experience and static computing models, has subjective differences, limited data processing capabilities, time-consuming and error-prone, it is difficult to quickly adapt to design requirements and technological progress, and it lacks an integrated management and collaborative working platform.
Using a digital basic selection method based on WebGIS technology, the efficient digital selection of the tower foundation is achieved by collecting and sorting the survey data of historical transmission and transformation projects and converting it into a selection analysis and evaluation algorithm. Specific steps include geographic exploration data collection and database construction, basic selection topic data geological data mapping, basic selection analysis and evaluation logic formation, and the use of Cesium and Python to develop WebGIS applications and selection analysis algorithms.
It realizes efficient digital selection of tower foundations, reduces manual subjectivity, improves data processing efficiency and design quality, can quickly adapt to design requirements and technological progress, and improves information sharing and collaborative work efficiency.
Smart Images
Figure CN119849078A_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the field of power transmission and transformation line engineering pole tower design, and specifically implements the basic selection stage in the pole tower design process in power transmission line engineering based on WebGIS technology. The main application is to determine the appropriate pole tower foundation type under specific geological conditions, design parameters and technical and economic factors. Background Art
[0002] In the design and construction process of transmission line projects, foundation selection is a crucial link, which directly affects the stability and safety of transmission towers. Traditional foundation selection methods mainly rely on manual experience and static calculation models, which have been widely used in the past few decades. Specifically, engineers first conduct on-site surveys to collect data such as terrain and geology, and then select preliminary foundation types based on these data combined with design specifications and experience, and use static mechanical models (such as soil mechanics models) for calculations to determine the foundation size and materials. Then, by comparing multiple design schemes, the best solution is selected.
[0003] Although this method has played an important role in the past, its limitations are gradually becoming apparent. First, the traditional method is highly dependent on the experience and judgment of engineers. There may be large subjective differences between different engineers. New or inexperienced engineers may find it difficult to accurately select the appropriate foundation type, resulting in uneven design quality. In addition, the traditional method has limited capabilities in data collection and processing, and it is difficult to efficiently process a large amount of complex field data. The data processing process is cumbersome and error-prone, which increases design time and cost. When comparing multiple design schemes, the traditional method often requires manual calculation and comparison, which is time-consuming and prone to missing key factors. The lack of systematic evaluation criteria makes the selection of the optimal solution subjective. At the same time, the traditional method is difficult to quickly adapt to the ever-changing design requirements and technological advances. When encountering new engineering conditions or new technologies, it may not be able to provide effective solutions. Finally, the various links of the traditional method are relatively independent, lacking integrated management and collaborative work platforms, inefficient information transmission and sharing, and an imperfect design change and feedback mechanism, resulting in project delays and increased costs. Therefore, a more efficient and accurate digital foundation selection method is urgently needed to improve design quality and work efficiency. Summary of the invention
[0004] The technical problem to be solved by the present invention is that the traditional foundation selection requires a lot of field survey work, supplemented by rich design experience, to select the appropriate foundation type. Based on WebGIS technology, by collecting and sorting the survey data accumulated from historical power transmission and transformation projects, and converting the rules and regulations of foundation selection and design experience logic into selection analysis and evaluation algorithms, the digital foundation selection of transmission line towers is realized.
[0005] To achieve the above purpose, the present invention adopts the following technical solution steps: A method for selecting a digital foundation for power transmission lines based on WebGIS includes the following steps: Step 1: Geological survey data collection and database construction for power transmission and transformation projects: Collect historical geological survey data for power transmission and transformation projects, clean and standardize the geological survey data, and build a geological survey database for power transmission and transformation projects; Step 2: Drawing of geological data map of basic selected thematic data: Based on the data in the geological survey database, the overburden thickness, rock quality grade, and groundwater distribution grid data map are drawn, and the digital elevation model is processed to form a slope distribution grid data map; Step 3: Basic selection analysis and evaluation logic: With reference to regulations and specifications, the applicable range of cover thickness, rock quality grade range, slope range, vertical uplift force range of foundation, applicability when there is groundwater, and the economic and environmental performance of the foundation for each type of transmission line tower foundation are evaluated to form a quantitative foundation selection standard; Step 4: Basic selection analysis and evaluation of WebGIS application construction: Use the Cesium framework to build a WebGIS application for digital basic selection of transmission lines, import the drawn data graphs into the application, and use the Python language to develop the selection analysis algorithm.
[0006] In step 1, the geological survey data refers to the drilling data generated during the geological survey of the engineering site, including the geographic information data of the drilling hole, the distribution characteristics of the strata in the drilling hole, and the detailed physical property information of the strata.
[0007] Step 2 specifically includes: Step 2.1: Extract thematic data into a txt file from the geological survey database of power transmission and transformation projects; Step 2.2: Determine the coordinate system; Step 2.3: Load point data; Step 2.4: Create irregular triangulated network; Step 2.5: Adjust the pixel size; Step 2.6: Generate raster data.
[0008] Step 3 specifically includes: Step 3.1: Input coordinate points and range surface; Step 3.2: Read thematic geological data; Step 3.3: Data display and verification; Step 3.4: Input the vertical pulling force of the foundation; Step 3.5: Traverse all basic types and judge each condition. If the condition is met, proceed to the next condition; if the condition is not met, proceed to the next basic type. Step 3.6: Output the selection result based on the judgment result.
[0009] Step 4 is as follows: Step 4.1: Use Cesium to create a WebGIS application interface, configure a 3D earth scene and integrate necessary map services, and use Cesium API to develop tools for drawing point features and surface features in the 3D earth scene, which are used to support point-based precise selection and surface-based recommended selection respectively; Step 4.2: Import the drawn basic selected thematic data into the WebGIS application and publish the layer in GeoServer for data loading and visualization; Step 4.3: Based on the basic selection analysis and evaluation logic, use Python language to develop the selection analysis algorithm; Step 4.4: Use the Django framework in Python to build a web service and API interface, connect the Python algorithm with the Cesium front end, enable the front end to call the back end algorithm, and display the analysis results in real time on the interface.
[0010] The beneficial effect of the present invention is that, based on the WebGIS foundation, a digital foundation selection Web application is developed to realize efficient digital foundation selection of transmission line towers. BRIEF DESCRIPTION OF THE DRAWINGS
[0011] Figure 1 It is a basic selection process for digitalization of power transmission lines based on WebGIS; Figure 2 It is the basic selection of thematic geological data processing flow; Figure 3 It is the basic selection analysis and evaluation algorithm process; Figure 4 Hierarchical structural model of basic recommendation coefficients. DETAILED DESCRIPTION
[0012] like Figure 1As shown in the figure, a method for selecting the digital foundation of power transmission lines based on WebGIS is firstly used to collect, clean and standardize the historical power transmission and transformation project data, and build a geological survey database for power transmission and transformation projects. The geological thematic data map for foundation selection analysis is drawn based on the data in the geological survey database. Referring to the regulations and specifications, the applicable range of the covering layer thickness, rock quality grade range, slope range, vertical uplift force range of the foundation, the applicability when there is groundwater, and the economic and environmental protection of the foundation for each transmission line tower foundation are evaluated to form a quantitative foundation selection standard. The WebGIS application for digital foundation selection of transmission lines is constructed using the Cesium framework, the drawn data map is imported into the application, and the selection analysis algorithm is developed using the Python language.
[0013] The specific steps include: Step 1: Collection of geological survey data and construction of database for power transmission and transformation projects: Collect historical geological survey data for power transmission and transformation projects, clean and standardize the geological survey data, and build a geological survey database for power transmission and transformation projects.
[0014] In step 1, the geological survey data refers to the drilling data generated during the geological survey of the engineering site, including the geographic information data of the drilling hole, the distribution characteristics of the strata in the drilling hole, and the detailed physical property information of the strata.
[0015] According to the existing survey technology and survey results, the data collection standard that meets the characteristics of the power transmission and transformation project survey results is formulated, and the geological exploration data of the historical power transmission and transformation project is collected. The longitude and latitude coordinates of the exploration points adopt the 2000 National Geodetic Coordinate System and are retained to six decimal places. The elevation adopts the 1985 National Elevation Datum and is retained to two decimal places.
[0016] In order to ensure that the data status is consistent with the standard, after data collection, the data is cleaned and standardized according to the data collection standard. The specific content and standards of data collection are shown in Table 1.
[0017] Table 1 Geological survey data collection standards Field Name Field Format Project Name Char Exploration point number Char longitude Float latitude Float Original elevation of exploration point Float Raw data of cover thickness Float Bedrock level Char Groundwater elevation Float Strata No. Char Layer thickness Float Name of rock layer Char Geotechnical Description Char Formation status Char Moisture content Float Gravity density Float proportion Float Liquid limit Float Plastic Limit Float Internal friction angle Float Cohesion Float Compression modulus Float Bearing capacity characteristic value Float Side resistance Float End resistance Float Rock equivalent ultimate shear strength Char Rock hardness Char Rock mass integrity Char Basic rock quality grade Char After completing data collection and cleaning, a geological survey database for power transmission and transformation projects is constructed, and the field content and field format in the database are consistent with the data collection standards.
[0018] Step 2: Basic selection of thematic data and geological data mapping The geological data of foundation selection thematic data refers to the distribution map of geological factors that need to be considered in foundation selection analysis and evaluation, and the data format is GeoTiff.
[0019] According to the data in the geological survey database, the overburden thickness, rock quality grade, and groundwater distribution grid data map are drawn, and the digital elevation model is processed to form a slope distribution grid data map; specifically: first, the relevant data in the geological database is exported to a txt file, and the fields include: longitude, latitude, original elevation of the exploration point, original data of overburden thickness, bedrock grade, and groundwater elevation. The txt data file is imported into the ArcMap software for processing. The processing flow is as shown in the attached figure. Figure 2 shown.
[0020] Step 2.1: Extract thematic data into a txt file from the geological survey database of power transmission and transformation projects; Step 2.2: Determine the coordinate system; unify the coordinate parameters, projection parameters, scale and other spatial parameters of the modeling data to ensure the accuracy and standardization of the data. The coordinate parameters and projection parameters use the PseudoMercator projection coordinate system (PseudoMercator). In a large area, the magnitude of the X and Y coordinate spans of the boreholes is much larger than the drilling depth Z, which will cause the vertical undulation characteristics of the stratigraphic interface to be completely ignored when using the original data for modeling. When processing the data, we enlarged the stratigraphic thickness data by 10 to 1000 times according to factors such as the size of the geomorphic unit and the degree of elevation undulation, and uniformly added a 10,000 m offset between the strata to separate the stratigraphic planes from each other.
[0021] Step 2.3: Load point data; extract the bottom interface stratification points of the modeled strata. These points represent the changing trend of the bottom interface and form discrete points in space.
[0022] Step 2.4: Create an irregular triangulated network; according to the construction range of the stratum interface, uniformly set the size of the triangulated network, use these discrete points to automatically construct the bottom interface process surface of the stratum, and generate a preliminary stratum interface structure model.
[0023] Step 2.5: Adjust the pixel size; use the spatial discrete points of the bottom interface as control points and the contour line of the process surface as the constraint range, and use the discrete smooth interpolation method to adjust the process surface to ensure that the generated surface can pass through all control points so that the stratum interface strictly follows the original drilling layering information. Check whether the generated stratum bottom interface exceeds the stratum top interface. If this happens, according to the actual geological conditions, use the method of fine-tuning the triangulation or clipping the out-of-range method to correct it and finally obtain the accurate target stratum bottom interface.
[0024] Step 2.6: Generate raster data.
[0025] Step 3: Basic selection analysis and evaluation logic With reference to regulations and specifications, the applicable covering layer thickness range, rock quality grade range, slope range, vertical uplift force range of the foundation, applicability when there is groundwater, and the economic and environmental performance of the foundation for each type of transmission line tower foundation are evaluated to form a quantitative foundation selection standard.
[0026] Among them, the thickness of the cover layer, rock quality grade, slope, and vertical uplift force of the foundation can be extracted from the standard specifications to clearly quantify their range. Since the distribution of groundwater is strongly affected by seasons and human activities, the presence or absence of groundwater can be used to replace its specific range. The economic and environmental evaluation of the foundation adopts a hierarchical mathematical model to evaluate the influence of various technical and economic factors, and finally form a recommended coefficient for each foundation as a quantitative indicator of economy and environmental protection.
[0027] When conducting selection analysis, the foundation type is determined to be an optional type only if all five conditions are met at the same time. When multiple foundation types meet the selection conditions at the same location, the selection results are recommended and ranked according to the safety, construction difficulty, environmental protection and economy of the foundation. The specific foundation selection analysis and evaluation logic is as follows Figure 3 shown.
[0028] Step 3.1: Input coordinate points and range surface; Step 3.2: Read thematic geological data; Step 3.3: Data display and verification; Step 3.4: Input the vertical pulling force of the foundation; Step 3.5: Traverse all basic types and judge each condition. If the condition is met, proceed to the next condition; if the condition is not met, proceed to the next basic type. Step 3.6: Output the selection result based on the judgment result.
[0029] The sorting process is based on the basic recommendation coefficient, which is evaluated using a hierarchical structure model. The structure of the model is as follows: Figure 4 shown.
[0030] Step 4: Basic selection analysis and evaluation of WebGIS application construction Use the Cesium framework to build a WebGIS application for digital basic selection of power transmission lines, import the drawn data graph into the application, and use the Python language to develop the selection analysis algorithm. The specific contents are as follows: Step 4.1: Use Cesium to create a WebGIS application interface, configure a 3D earth scene and integrate necessary map services, and use Cesium API to develop tools for drawing point features and surface features in the 3D earth scene, which are used to support point-based precise selection and surface-based recommended selection respectively; Step 4.2: Import the drawn basic selected thematic data into the WebGIS application and publish the layer in GeoServer for data loading and visualization; Step 4.3: Based on the basic selection analysis and evaluation logic, use Python language to develop the selection analysis algorithm; Step 4.4: Use the Django framework in Python to build a web service and API interface, connect the Python algorithm with the Cesium front end, enable the front end to call the back end algorithm, and display the analysis results in real time on the interface.
[0031] In step 4, Cesium is used to build highly interactive earth visualization applications, which are suitable for developing Web-based geographic information system (GIS) applications. The selection analysis algorithm refers to the code implementation of the basic selection analysis evaluation logic formed in step c. The code is written in Python, and GIS libraries such as GDAL in Python are used to provide geographic information technology support for Web applications.
Claims
1. A method for selecting digital foundation of power transmission lines based on WebGIS, characterized in that The following steps are involved: Step 1: Geological survey data collection and database construction for power transmission and transformation projects: Collect historical geological survey data for power transmission and transformation projects, clean and standardize the geological survey data, and build a geological survey database for power transmission and transformation projects; Step 2: Drawing of geological data map of basic selected thematic data: Based on the data in the geological survey database, the overburden thickness, rock quality grade, and groundwater distribution grid data map are drawn, and the digital elevation model is processed to form a slope distribution grid data map; Step 3: Basic selection analysis and evaluation logic: With reference to regulations and specifications, the applicable range of cover thickness, rock quality grade range, slope range, vertical uplift force range of foundation, applicability when there is groundwater, and the economic and environmental performance of the foundation for each type of transmission line tower foundation are evaluated to form a quantitative foundation selection standard; Step 4: Basic selection analysis and evaluation of WebGIS application construction: Use the Cesium framework to build a WebGIS application for digital basic selection of transmission lines, import the drawn data graphs into the application, and use the Python language to develop the selection analysis algorithm.
2. The method for selecting a digital basis for power transmission lines based on WebGIS according to claim 1, characterized in that: In step 1, the geological survey data refers to the drilling data generated during the geological survey of the engineering site, including the geographic information data of the drilling hole, the distribution characteristics of the strata in the drilling hole, and the detailed physical property information of the strata.
3. The method for selecting a digital foundation for power transmission lines based on WebGIS according to claim 1, characterized in that: Step 2 specifically includes: Step 2.1: Extract thematic data into a txt file from the geological survey database of power transmission and transformation projects; Step 2.2: Determine the coordinate system; Step 2.3: Load point data; Step 2.4: Create irregular triangulated network; Step 2.5: Adjust pixel size; Step 2.6: Generate raster data.
4. The method for selecting a digital foundation for power transmission lines based on WebGIS according to claim 1, characterized in that: Step 3 specifically includes: Step 3.1: Input coordinate points and range surface; Step 3.2: Read thematic geological data; Step 3.3: Data display and verification; Step 3.4: Input the vertical pulling force of the foundation; Step 3.5: Traverse all basic types and judge each condition. If the condition is met, proceed to the next condition; if the condition is not met, proceed to the next basic type. Step 3.6: Output the selection result based on the judgment result.
5. The method for selecting a digital foundation for power transmission lines based on WebGIS according to claim 1, characterized in that: Step 4 is as follows: Step 4.1: Use Cesium to create a WebGIS application interface, configure a 3D earth scene and integrate necessary map services, and use Cesium API to develop tools for drawing point features and surface features in the 3D earth scene, which are used to support point-based precise selection and surface-based recommended selection respectively; Step 4.2: Import the drawn basic selected thematic data into the WebGIS application and publish the layer in GeoServer for data loading and visualization; Step 4.3: Based on the basic selection analysis and evaluation logic, use Python language to develop the selection analysis algorithm; Step 4.4: Use the Django framework in Python to build a web service and API interface, connect the Python algorithm with the Cesium front end, enable the front end to call the back end algorithm, and display the analysis results in real time on the interface.