Frozen soil comprehensive information statistical system and method based on optimized SQL parallel query

Abstract

The invention discloses a frozen soil comprehensive information statistical system and method based on optimized SQL parallel query, and relates to the field of power grid equipment operation and maintenance. The invention aims to establish a seasonal frozen area frozen soil information database. The frozen soil comprehensive information statistical method based on optimized SQL parallel query comprises the following steps: firstly, collecting land utilization status maps of different scales to establish an image database, wherein the land utilization status maps comprise a regional frozen soil standard freezing depth map, a regional thawing index standard value contour map, a regional annual average temperature map, a regional administrative region division map and a regional provincial distribution map; inputting the data in the image database into MapInfo software, and carrying out digital processing on the data in the image database; and finally, processing the digitized data to obtain a frozen soil distribution diagram containing frozen soil thematic elements, and completing statistics of frozen soil comprehensive information; and querying the counted frozen soil comprehensiveinformation by utilizing an SQL parallel query system.

Description

technical field [0001] The invention belongs to the field of operation and maintenance of power grid equipment, and in particular relates to statistical analysis of transmission line tower foundations. Background technique [0002] Seasonal permafrost is generally developed in northern my country. Compared with other soil types, permafrost mainly shows instability in thermodynamics, especially affected by climate and human disturbance, which makes it change greatly, and huge changes may cause permafrost regions. The foundations of transmission line towers were seriously deformed or even collapsed, which threatened the safety of power transmission in the area. Therefore, it is necessary to establish a corresponding permafrost information database in seasonally frozen regions and to grasp the distribution of permafrost in seasonally frozen regions where overhead transmission lines pass. Contents of the invention [0003] The present invention aims to establish a soil-moving ...

AI Technical Summary

Problems solved by technology

[0002] Seasonal permafrost is generally developed in northern my country. Compared with other soil types, permafrost mainly shows instability in thermodynamics, especially affected by climate and human disturbance, which makes it change greatly, and huge changes may cause permafrost regions. Severe deformation or even collapse of the tower foundation of the transmission line occurred, which threatened the safety of power transmission in the area

Images