CN107451761A - The statistical method and system of a kind of transmission line of electricity distribution situation in special area - Google Patents

Abstract

The invention discloses a statistical method and system for the distribution of power transmission lines in a special area, wherein the method includes: obtaining the serial number and geographic coordinates of the physical towers of the designated lines; Perform spatial query in the area to obtain the type and level of the special area corresponding to each physical tower; classify the physical towers according to the type and level of the special area, and obtain the physical towers corresponding to each level in each type of special area Set; output and display the serial numbers of the physical towers in the physical tower set. The present invention can improve the accuracy of transmission line channel risk assessment and equipment failure category judgment by counting the distribution of transmission lines in special areas, and provide technical support for line operation and maintenance and protection work, and improve the disaster prevention and mitigation level of transmission lines .

Description

A statistical method and system for the distribution of transmission lines in a special area

technical field

Embodiments of the present invention relate to electric power technology, and in particular to a statistical method and system for the distribution of power transmission lines in a special area.

Background technique

The power special area map connects statistical data and geographical location to display power equipment information, analyze the geographical environment of the equipment, and provide decision support for equipment fault category judgment. Special area maps include polluted area map, bird damage map, dancing map, goaf map, lightning damage map, ice area map and wind area map. The first three types each contain a layer. There are five layers of 500kV shielding attack, 500kV counterattack and ground flash density, and the ice area map and wind area map each contain three distribution layers of 30 years, 50 years and 100 years. These special area maps provide decision support for grid planning and grid disaster prevention and mitigation.

At present, the accuracy of transmission line channel risk assessment and equipment failure category judgment is not high. The operation and maintenance of transmission lines need to be completed manually, which takes a long time and wastes a lot of manpower.

Contents of the invention

The invention provides a statistical method and system for the distribution of transmission lines in a special area, so as to realize the function of statistical distribution of transmission lines in a special area.

In the first aspect, the embodiment of the present invention provides a statistical method for the distribution of transmission lines in a special area, including:

Obtain the serial number and geographic coordinates of the physical tower of the specified line;

cyclically use the geographic coordinates of the physical towers to perform spatial queries on various special areas, and obtain the type and level of special areas corresponding to each physical tower;

classifying the physical towers according to the type and level of the special area, and obtaining a set of physical towers corresponding to each level in each type of special area;

Output and display the sequence numbers of the physical towers in the physical tower set.

Further, said obtaining the serial number and geographic coordinates of the physical towers of the specified line includes: obtaining the serial number and geographic coordinates of the physical towers of the specified line through the spatial information query service of the grid GIS platform.

Further, the cycle uses the geographical coordinates of the physical towers to perform spatial query on various special areas, and obtains the type and level of the special areas corresponding to each physical tower, including:

Add the layer of the special area to be counted to the spatial query layer set, and perform point spatial query;

Carrying out spatial query according to the geographic coordinates of the physical towers, performing circular analysis on the query results, and obtaining the type and level of the special area corresponding to each physical tower.

Further, classifying the physical towers according to the type and level of the special area, obtaining the set of physical towers corresponding to each level of each type of the special area, including:

Establishing the three-dimensional array of the special area type, grade and the physical tower;

Performing a unique query on the type and level data of the special area according to the type of the special area, obtaining the level of each type of the special area, and assigning it to the level array element of the three-dimensional array;

Carry out a query based on a classification algorithm based on multidimensional association rules for the obtained data on the serial number of the physical tower of the specified line, the type and level of the special area according to the type and level of the special area, and obtain the special area of each type The serial numbers of the physical towers in the physical tower set at each level are assigned to the physical tower array elements of the three-dimensional array.

Further, the outputting and displaying the serial numbers of the physical towers in the set of physical towers includes:

Sorting the serial numbers of the physical towers in the physical tower set corresponding to each level of each type of special area; judging the continuous physical towers and isolated physical towers in the physical tower set;

Arrange and write out the judged continuous physical towers in order of serial numbers, write out the isolated physical towers directly, and output and display the written results.

In the second aspect, the embodiment of the present invention also provides a statistical system for the distribution of transmission lines in a special area, the system includes:

The physical tower information acquisition module is used to obtain the serial number and geographic coordinates of the physical tower of the specified line;

The special area information acquisition module is used to perform spatial query on various special areas by circularly using the geographical coordinates of the physical towers, and obtain the type and level of the special area corresponding to each physical tower;

The physical tower classification module is used to classify the physical towers according to the type and level of the special area, and obtain the set of physical towers corresponding to each level in each type of special area;

A display module, configured to output and display the serial numbers of the physical towers in the set of physical towers.

According to the technical solution of the embodiment of the present invention, by obtaining the information of the physical tower of the specified line and the information of the corresponding special area, and performing classification and statistical processing on the above information, the distribution of the transmission line in the special area can be obtained, and the transmission line channel can be improved. The accuracy of risk assessment and equipment failure category judgment, and provide a guiding basis for line operation and maintenance work, and improve the disaster prevention and mitigation level of transmission lines.

Description of drawings

FIG. 1 is a schematic flowchart of a statistical method for the distribution of transmission lines in a special area provided by Embodiment 1 of the present invention;

2 is a schematic flowchart of a statistical method for the distribution of transmission lines in a special area provided by Embodiment 2 of the present invention;

3 is an example diagram of statistical results of a statistical method for the distribution of power transmission lines in a special area provided by Embodiment 2 of the present invention;

Fig. 4 is a schematic structural diagram of a statistical system for the distribution of transmission lines in a special area provided by Embodiment 3 of the present invention.

detailed description

The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, only some structures related to the present invention are shown in the drawings but not all structures.

Embodiment one

FIG. 1 is a schematic flow chart of a statistical method for the distribution of transmission lines in a special area provided by Embodiment 1 of the present invention. This embodiment is applicable to statistics of the distribution of transmission lines in a special area. The method can be performed by a statistical system for the distribution of transmission lines in a special area, as shown in Figure 1, the method of this embodiment specifically includes:

Step 110, acquire the serial number and geographical coordinates of the physical tower of the specified line.

In this embodiment, the physical tower of the specified line is associated with the three tables of transmission lines, operating towers, and physical towers in the data center to query the ledger data of the physical tower of the designated line, and a temporary line tower table can be created, and special area types, The grade, serial number and coordinate fields of the physical tower are saved. Further, through the spatial information query service of the power grid GIS platform, the serial number and geographic coordinate value of the physical tower of the specified line are obtained, and stored in the temporary line tower table.

Step 120, cyclically use the geographical coordinates of the physical towers to perform spatial query on various special areas, and obtain the type and level of special areas corresponding to each physical tower.

In this embodiment, all kinds of special areas have corresponding rest map services. The background map service is used in the spatial query process, and all special areas are searched through the geographical coordinates of physical towers to obtain the type of special area corresponding to each physical tower. and grade, and store it in the temporary line tower table.

It should be noted that the special areas include seven areas: pollution area, bird damage area, dancing area, goaf area, mine damage area, ice area and wind area, among which the pollution area, bird damage area, dancing area, The gob area includes one layer each, the lightning damage area includes five layers of 220kV shielding, 220kV counterattack, 500kV shielding, 500kV counterattack and ground flash density, and the ice area and wind area respectively include 30 years, 50 years, and 100 years Three layers.

Step 130, classify the physical towers according to the type and level of the special area, and obtain a set of physical towers corresponding to each level in each type of special area.

Wherein, preferably, the classification of the physical towers is realized by processing the data in the temporary line tower table. For example, if the special area is a wind zone with a grade of 30 years, the physical towers belonging to the wind zone for 30 years in the temporary line tower table are screened out, and the classification of the physical tower set corresponding to the wind zone for 30 years is completed.

Step 140, output and display the sequence numbers of the physical towers in the physical tower set.

This embodiment provides a statistical method for the distribution of transmission lines in a special area. By obtaining the information of the physical towers of the specified line and the information of the corresponding special area, and performing classification and statistical processing on the above information, the distribution of transmission lines in the special area is obtained. The distribution in the region can improve the accuracy of transmission line channel risk assessment and equipment failure category judgment, and provide a guiding basis for line operation and maintenance work, and improve the disaster prevention and mitigation level of transmission lines.

Embodiment two

Figure 2 is a schematic flowchart of a statistical method for the distribution of transmission lines in a special area provided by Embodiment 2 of the present invention. On the basis of the above-mentioned embodiment, this embodiment further optimizes the distribution of the above-mentioned transmission lines in a special area statistical method. Correspondingly, as shown in Figure 2, the method in this embodiment specifically includes:

Step 210, acquire the serial number and geographic coordinates of the physical tower of the specified line.

In this embodiment, a temporary line tower table may be created, and the acquired serial numbers and geographic coordinates of the physical towers are stored in the temporary line tower table.

Step 220, adding the layer of the special area to be counted into the spatial query layer set, and performing point spatial query.

Step 230, perform spatial query according to the geographic coordinates of the physical towers, and perform circular analysis on the query results to obtain the type and level of the special area corresponding to each physical tower.

Wherein, the query preferably starts from the first physical tower, performs circular analysis on the result of the geographic coordinate space query of the first physical tower, and writes all special area types and grades corresponding to the first physical tower into the Then, the geographical coordinates of the remaining physical towers are inquired in point space in turn, and the obtained results are analyzed circularly, and the corresponding data are written into the temporary line tower table.

Step 240, establishing the three-dimensional array of the special area type, grade and the physical tower;

Step 250, uniquely query the data of the type and level of the special area according to the type of the special area, obtain the level of each type of the special area, and assign it to the level array element of the three-dimensional array.

Wherein, the data of the type and level of the special area is stored in the temporary line tower table, so the relevant data of the temporary line tower table can be uniquely queried according to the type of the special area. The unique query refers to deleting duplicate data in the result while obtaining the result.

Step 260: Perform a query based on a classification algorithm based on multi-dimensional association rules for the obtained data on the serial number of the physical tower of the specified line, the type and level of the special area according to the type and level of the special area, and obtain the data of each category. The serial numbers of the physical towers in the physical tower set under each level of the special area are assigned to the physical tower array elements of the three-dimensional array.

Step 270, sort the serial numbers of the physical towers in the physical tower set corresponding to each level of each type of the special area.

Wherein, it is preferable to use the quick sort method to sort the serial numbers of the physical towers in the set of physical towers, and the obtained physical towers are arranged in order of serial numbers.

Step 280, judging continuous physical towers and isolated physical towers in the set of physical towers.

In this embodiment, judging the continuity of the set of elements of the array of physical towers is preferably judging whether the difference between adjacent elements is equal to 1. If the difference between adjacent elements is equal to 1, the physical towers are continuously distributed. If the element difference is not equal to 1, then the physical tower is an isolated physical tower.

Step 290, arrange and write the judged continuous physical towers in order of serial numbers, write out the isolated physical towers directly, and output and display the written results.

Among them, if the physical towers are distributed continuously, continue to judge until the difference between adjacent elements is not equal to 1, and the sequence of this continuous physical towers can be written as b1-b2, b1 is the physical tower at the beginning of the continuation, and b2 is the physical tower at the end of the continuation tower; the isolated physical tower is written directly.

In this embodiment, it is preferable to organize the results of the above-mentioned physical tower continuity judgment into a json string output display, and the format of the json string is as follows: special area type: the line spans n levels; level 1, level 2,... Grade n; Grade 1; Tower distribution is b, b1-b2, b3-b4,...; Grade 2: Tower distribution is d1-d2, d3-d4, d,...; Grade n: tower distribution is m, m1-m2, m3-m4,..., where n is the nth level, b, d, m is the number of a single tower, b1-b2, b3-b4, d1-d2, d3-d4, m1-m2, m3-m4, etc. are the starting and ending tower numbers of successive towers step by step. E.g:

Exemplarily, FIG. 3 is an example diagram of the statistical results of a statistical method for the distribution of transmission lines in a special area provided by this embodiment. Through the statistical method of this embodiment, the physical poles and towers of the specified line are obtained in various special areas. The collection of different levels in the area, and the output display.

This embodiment provides a statistical method for the distribution of transmission lines in a special area. By obtaining the information of the physical towers of the specified line and the information of the corresponding special area, a three-dimensional array of the type, grade and physical towers of the special area is established. The above-mentioned information is classified by querying and querying of classification algorithms based on multidimensional association rules, and the collection of classified physical towers is sorted and the continuity is judged. The output shows the distribution of transmission lines in a special area. The accuracy of information classification and statistics is improved, and the statistical results are more intuitive and convenient for network transmission and analysis. It can provide a guiding basis for line operation and maintenance, and improve the level of disaster prevention and mitigation of transmission lines.

Embodiment three

FIG. 3 is a schematic structural diagram of a statistical system for the distribution of transmission lines in a special area provided by Embodiment 3 of the present invention. This embodiment is applicable to statistics of the distribution of transmission lines in a special area. As shown in Figure 4, the statistical system includes:

The physical tower information acquisition module 410 is used to obtain the serial number and geographic coordinates of the physical tower of the designated line;

The special area information acquisition module 420 is used to perform spatial query on various special areas by circularly using the geographical coordinates of the physical towers to obtain the type and level of the special area corresponding to each physical tower;

The physical tower classification module 430 is configured to classify the physical towers according to the type and level of the special area, and obtain a set of physical towers corresponding to each level in each type of special area;

The display module 440 is configured to output and display the sequence numbers of the physical towers in the set of physical towers.

Further, the above-mentioned special area information acquisition module 420 may also include: a spatial query unit, configured to add the layer of the special area to be counted to the spatial query layer set, and perform point spatial query; a loop analysis unit, configured to Carrying out spatial query according to the geographic coordinates of the physical towers, performing circular analysis on the query results, and obtaining the type and level of the special area corresponding to each physical tower.

Preferably, the above-mentioned physical tower classification module 430 may also include: a three-dimensional array establishment unit, used to establish the three-dimensional array of the special area type, grade and the physical tower; a grade array assignment unit, used to pass through the special area The data of the type and level are uniquely queried according to the type of the special area, and the level of each type of the special area is obtained, and assigned to the level array element of the three-dimensional array; the physical tower array assignment unit is used to pass the The obtained serial number of the physical tower of the specified line, the type and grade data of the special area are queried based on the classification algorithm of the multidimensional association rules according to the type and grade of the special area, and the data of each type of the special area are obtained. The serial numbers of the physical towers in the physical tower set at each level are assigned to the physical tower array elements of the three-dimensional array.

Further, the above display module 440 may also include: a sorting unit for sorting the serial numbers of the physical towers in the physical tower set corresponding to each level of each type of the special area; a judging continuity unit for judging The continuous physical towers and the isolated physical towers in the set of physical towers; the output unit is used to arrange and write the judged continuous physical towers in order of serial numbers, write out the isolated physical towers directly, and output and display the written results.

This embodiment provides a statistical system for the distribution of transmission lines in a special area. By obtaining the information of the physical towers of the specified line and the information of the corresponding special area, a three-dimensional array of the type, grade and physical towers of the special area is established. The above-mentioned information is classified by querying and querying of classification algorithms based on multidimensional association rules, and the collection of classified physical towers is sorted and the continuity is judged. The output shows the distribution of transmission lines in a special area. The accuracy of information classification and statistics is improved, and the statistical results are more intuitive, which can provide a guiding basis for line operation and maintenance, and improve the disaster prevention and mitigation level of transmission lines.

The statistical system for the distribution of transmission lines in a special area provided by this embodiment can execute the statistical method for the distribution of transmission lines in a special area provided by any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method .

Note that the above are only preferred embodiments of the present invention and applied technical principles. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the protection scope of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and can also include more other equivalent embodiments without departing from the concept of the present invention, and the present invention The scope is determined by the scope of the appended claims.

Claims (10)

1. A statistical method for transmission line distribution in a special area, characterized in that it comprises: Obtain the serial number and geographic coordinates of the physical tower of the specified line; cyclically use the geographic coordinates of the physical towers to perform spatial queries on various special areas, and obtain the type and level of special areas corresponding to each physical tower; classifying the physical towers according to the type and level of the special area, and obtaining a set of physical towers corresponding to each level in each type of special area; Output and display the sequence numbers of the physical towers in the physical tower set. 2. statistical method according to claim 1, is characterized in that, described obtaining the sequence number and the geographic coordinates of the physical tower of specified line, comprising: Through the spatial information query service of the power grid GIS platform, the serial number and geographic coordinates of the physical towers of the specified line can be obtained. 3. The statistical method according to claim 2, characterized in that, the geographical coordinates of the physical towers are used cyclically to perform spatial queries on various special areas, and the information of the special areas corresponding to each of the physical towers is obtained. Type and grade, including: Add the layer of the special area to be counted to the spatial query layer set, and perform point spatial query; Carrying out spatial query according to the geographic coordinates of the physical towers, performing circular analysis on the query results, and obtaining the type and level of the special area corresponding to each physical tower. 4. The statistical method according to claim 3, characterized in that, the physical towers are classified according to the type and grade of the special area, so as to obtain the corresponding values for each grade of each type of special area. A collection of physical towers, including: Establishing the three-dimensional array of the special area type, grade and the physical tower; Performing a unique query on the type and level data of the special area according to the type of the special area, obtaining the level of each type of the special area, and assigning it to the level array element of the three-dimensional array; Carry out a query based on a classification algorithm based on multidimensional association rules for the obtained data on the serial number of the physical tower of the specified line, the type and level of the special area according to the type and level of the special area, and obtain the special area of each type The serial numbers of the physical towers in the physical tower set at each level are assigned to the physical tower array elements of the three-dimensional array. 5. The method according to claim 4, wherein the outputting and displaying the sequence numbers of the physical towers in the physical tower set includes: Sorting the serial numbers of the physical towers in the set of physical towers corresponding to each level of each type of special area; Judging continuous physical towers and isolated physical towers in the set of physical towers; Arrange and write out the judged continuous physical towers in order of serial numbers, write out the isolated physical towers directly, and output and display the written results. 6. A statistical system for the distribution of transmission lines in a special area, characterized in that it includes: The physical tower information acquisition module is used to obtain the serial number and geographic coordinates of the physical tower of the specified line; The special area information acquisition module is used to perform spatial query on various special areas by circularly using the geographical coordinates of the physical towers, and obtain the type and level of the special area corresponding to each physical tower; The physical tower classification module is used to classify the physical towers according to the type and level of the special area, and obtain the set of physical towers corresponding to each level in each type of special area; A display module, configured to output and display the serial numbers of the physical towers in the set of physical towers. 7. The statistical system according to claim 6, wherein the physical tower information acquisition module is specifically used to obtain the serial number and geographic coordinates of the physical tower of the specified line through the spatial information query service of the power grid GIS platform. 8. The statistical system according to claim 7, wherein the special area information acquisition module includes: A spatial query unit, configured to add the layer of the special area to be counted to the spatial query layer set, and perform point spatial query; The loop parsing unit is configured to perform spatial query according to the geographic coordinates of the physical towers, and loop parse the query results to obtain the type and level of the special area corresponding to each physical tower. 9. The statistical system according to claim 8, wherein the physical tower classification module includes: A three-dimensional array establishment unit, used to establish the three-dimensional array of the special area type, level and the physical tower; The grade array assignment unit is used to obtain the grade of each type of the special region by uniquely querying the data of the type and grade of the special region according to the type of the special region, and assign it to the grade of the three-dimensional array array element; The physical pole tower array assignment unit is used to query the classification algorithm based on multidimensional association rules according to the type and level of the special area according to the obtained data of the serial number of the physical pole tower of the specified line, the type and level of the special area , obtain the serial numbers of the physical towers in the physical tower set under each level of each type of the special area, and assign them to the physical tower array elements of the three-dimensional array. 10. The statistical system according to claim 9, wherein the display module comprises: A sorting unit, configured to sort the serial numbers of the physical towers in the set of physical towers corresponding to each level of each type of special area; A unit for judging continuity is used to judge continuous physical towers and isolated physical towers in the set of physical towers; The output unit is used to arrange and write out the judged continuous physical towers in order of serial numbers, directly write out the isolated physical towers, and output and display the written results.