A method for judging the substation to which a switching station belongs

Abstract

The present invention provides a method for judging the substation to which a switching station belongs, comprising the following steps: A. Obtain the account data related to the switching station, and the account data related to the switching station includes: the city to which it belongs, the operating unit, the line name, the name of the substation or the switching station; B. Based on the account data related to the switching station obtained in step A, calculate and obtain the abbreviation library of substations and lines; C. According to the account data related to the switching station obtained in step A, extract the line abbreviation corresponding to the switching station; D. According to the abbreviation library of substations and lines obtained in step B, match the line abbreviation corresponding to the switching station obtained in step C with the abbreviation library of substations and lines to judge the substation to which the switching station belongs. The method for judging the substation to which a switching station belongs provided by the present invention can automatically identify the substation to which the switching station belongs, and help the operation and maintenance personnel to carry out the maintenance of basic files.

Description

Technical Field

[0001] The present invention relates to the technical field of operation detection of distribution substations, and specifically to a method for judging the substation to which a switching station belongs. Background Art

[0002] With the comprehensive transformation and development of the power transmission, distribution, and transformation networks, the number of switching stations has increased significantly across the country. A switching station is at the lower level of a substation in the power system and is a power facility that supplies high-voltage electricity to surrounding power-consuming units respectively. It is not only the most basic unit at the bottom layer of the distribution network but also one of the key links for power transmission from high voltage to low voltage.

[0003] The integration of operation and distribution data is a GIS-based integrated platform for operation and distribution data, that is, the integrated management of data from the marketing business application system, the production management information system, and the power grid geographic spatial information service platform. By comprehensively matching and sharing production data and marketing customer data, it is possible to achieve the integration of operation and distribution data and business through application integration and graphical display, and realize services such as fault location, power outage scope analysis, line loss statistics, and new business installation. The data of operation and distribution integration is the basic data for carrying out many distribution network services.

[0004] The operation and distribution integration data includes fields such as the city where it belongs, the operating unit, the line name, the substation area name, and the substation name. The actual operation and distribution integration data shows that some substation names use the names of switching stations and do not correspond to the names of the substations at the upper level of the switching stations. Currently, the general method is to manually record, check, and match the substations to which the switching stations belong one by one. Due to the large amount of archive data, the manual verification method is inefficient. To solve the above problems, the present invention proposes a method for judging the substation to which a switching station belongs. Summary of the Invention

[0005] In view of the above technical problems existing in the prior art, the present invention provides a method for judging the substation to which a switching station belongs, which can automatically identify the substation to which the switching station belongs, assist operation and maintenance personnel in carrying out the maintenance of basic archives, and improve work efficiency.

[0006] The technical solution adopted by the present invention is as follows:

[0007] A method for judging the substation to which a switching station belongs, comprising the following steps:

[0008] A. Obtain the account data related to the switching station, and the account data related to the switching station includes: the city where it belongs, the operating unit, the line name, and the substation or switching station name;

[0009] B. Based on the account data related to the switching station obtained in step A, calculate and obtain a substation and line abbreviation library;

[0010] C. Extract the abbreviated line names corresponding to the switchgear based on the ledger data related to the switchgear obtained in step A;

[0011] D. Based on the substation and abbreviated line name library obtained in step B, match the abbreviated line name corresponding to the switchgear obtained in step C with the substation and abbreviated line name library to determine the substation to which the switchgear belongs.

[0012] Furthermore, in step B, for the ledger data related to the switchgear obtained in step A, calculate and obtain the substation and abbreviated line name library, specifically:

[0013] The collected ledger data related to the switchgear is denoted as {DS i , DW i , XLN i , BDN i}, where DS i represents the corresponding city where the i-th ledger is located, DW i represents the corresponding operating unit in the i-th ledger, XLN i represents the corresponding line name in the i-th ledger, BDN i represents the corresponding substation (switchgear) name in the i-th ledger, 1 ≤ i ≤ n, and n is the total number of ledgers;

[0014] 1) According to BDN i in the ledger information, calculate the substation flag bit. If BDN i contains the string "substation", then record BZ i = 1, otherwise BZ i = 0. After calculating all the ledger information, the new ledger information can be obtained and denoted as S1, S1 = {DS i , DW i , XLN i , BDN i , BZ i};

[0015] 2) Based on the obtained new ledger information S1, perform deduplication with BDN i as the object. Specifically: If BZ i = 0, then delete the i-th row of the ledger; if BZ i = 1, then determine whether it is repeated with the existing ledger. If there are already J rows of ledgers that satisfy , then retain the i-th row of the ledger, otherwise delete it; the deduplicated ledger is denoted as S2, S2 = {DS k , DW k , XLN k , BDN k}, 1 ≤ k ≤ K, and K represents the total number of rows in the deduplicated ledger;

[0016] 3) Extract the short name of the substation through the LEFT function in Excel, BDJ k =LEFT(BDN k , 1), BDJ k is the short name of the k-th substation;

[0017] 4) Extract the short name of the line corresponding to the substation. For any XLN k , if there are M strings in the line ledger, for the m-th string, if it satisfies and then let where LEFT is the function in Excel, is the m-th string of XLN k ;

[0018] 5) After completing the calculation of the short names of all substations and lines in the ledger, a substation and line short name library can be obtained, denoted as S3, S3 = {BDN k , XLJ k , BDJ k}, 1 ≤ k ≤ K.

[0019] Furthermore, in step C, for the switch station ledger data obtained in step A, extract the short name of the line corresponding to the switch station, specifically:

[0020] 1) According to BDN i in the ledger information, calculate the substation flag bit. If BDN i contains the string "substation", then record BZ i = 1, otherwise BZ i = 0. After completing the calculation of all ledger information, the new ledger information is {DS i , DW i , XLN i , BDN i , BZ i}; According to the obtained new ledger information {DS i , DW i , XLN i , BDN i , BZ i}, if BZ i = 0, then retain this line of the ledger, otherwise delete it. At the same time, perform duplicate removal processing for the switch station. After the processing is completed, the ledger information of the switch station is denoted as S4, S4 = {DS p , DW p , XLN p , BDN p}, 1 ≤ p ≤ P, where P is the total number of rows of the switch station ledger;

[0021] 2) Extract the abbreviated name of the line corresponding to the switching station: For any XLN p , if there are T strings in the line ledger, for the t-th string, if it satisfies and then let where left is a function in Excel, is the t-th string of XLN p , and XLKJ p is the abbreviated name of the line corresponding to the switching station in the p-th row.

[0022] Furthermore, according to the substation and line abbreviated name library obtained in step B, match the abbreviated name of the line corresponding to the switching station obtained in step C with the substation and line abbreviated name library, and judge the substation to which the switching station belongs according to the matching result. Specifically:

[0023] For any XLN p , 1 ≤ p ≤ P, satisfying then let BDNC p = BDN k , that is, if the abbreviated name of the switching station in the p-th row is the same as the abbreviated name in the k-th row of the substation and line abbreviated name library S3, then assign the substation name in the k-th row to the switching station, where BDNC p is the substation name to which the matched switching station belongs; if the above conditions are not met, then let BDNC p = no match (indicating that the abbreviated name of the switching station cannot be found in the substation and line abbreviated name library S3, and at this time, the substation to which the switching station belongs cannot be judged), indicating no match or unsuccessful match. After completing the matching of all rows, the ledger information of the switching station is {DS p , DW p , XLN p , BDN p , BDNC p}.

[0024] The present invention proposes a method for judging the substation to which a switching station belongs, which can identify the substation to which the switching station belongs and assist maintenance personnel in maintaining basic files. Description of the Drawings

[0025] Figure 1 is a schematic flowchart of one embodiment of the method for judging the substation to which a switching station belongs according to the present invention. Detailed Embodiment

[0026] Next, the technical solutions in the present invention will be clearly and completely described in conjunction with the drawings in the present invention.

[0027] Please refer to Figure 1, which is a schematic flowchart of one embodiment of a method for judging the substation to which a switching station belongs in the present invention. The method includes the following steps:

[0028] A. Obtain the account data related to the switching station. The account data related to the switching station includes: the city where it belongs, the operating unit, the line name, and the name of the substation (switching station);

[0029] B. Based on the account data related to the switching station obtained in step A, calculate and obtain the abbreviation library of substations and lines. Specifically:

[0030] The collected account data related to the switching station is denoted as {DS i , DW i , XLN i , BDN i}, where DS i represents the city where it belongs corresponding to the i-th account, DW i represents the operating unit corresponding to the i-th account, XLN i represents the line name corresponding to the i-th account, BDN i represents the name of the substation (switching station) corresponding to the i-th account, 1 ≤ i ≤ n, and n is the total number of accounts;

[0031] 1) According to BDN i in the account information, calculate the substation flag bit. If BDN i contains the string "substation", then record BZ i = 1, otherwise BZ i = 0. After calculating all the account information, the new account information can be obtained and denoted as S1, S1 = {DS i , DW i , XLN i , BDN i , BZ i};

[0032] 2) According to the obtained new account information S1, de-duplicate with BDN i as the object. Specifically: If BZ i = 0, then delete the i-th row of the account; if BZ i = 1, then judge whether it is repeated with the existing accounts. If there are J existing accounts and satisfy then retain the i-th row of the account, otherwise delete it; the de-duplicated account is denoted as S2, S2 = {DS k , DW k , XLN k , BDN k}, 1 ≤ k ≤ K, and K represents the total number of rows of the de-duplicated account;

[0033] 3) Extract the short name of the substation through the LEFT function in Excel, BDJ k =LEFT(BDN k , 1), BDJ k is the short name of the k-th substation;

[0034] 4) Extract the short name of the line corresponding to the substation. For any XLN k , if there are M strings in the line ledger, for the m-th string, if it satisfies and then let where LEFT is a function in Excel, is the m-th string of XLN k ;

[0035] 5) After completing the calculation of the short names of all substation and line ledgers, a substation and line short name library can be obtained, denoted as {BDN k , XLJ k , BDJ k}, 1 ≤ k ≤ K;

[0036] C. According to the ledger data related to the switchgear obtained in step A, extract the short name of the line corresponding to the switchgear, specifically:

[0037] 1) Calculate the substation flag bit according to BDN i in the ledger information. If BDN i contains the string "substation", then record BZ i = 1, otherwise BZ i = 0. After completing the calculation of all ledger information, the new ledger information is {DS i , DW i , XLN i , BDN i , BZ i}; According to the obtained new ledger information {DS i , DW i , XLN i , BDN i , BZ i}, if BZ i = 0, then retain this line of the ledger, otherwise delete it. At the same time, perform deduplication processing on the switchgear. After the processing is completed, the ledger information of the switchgear is recorded as S4, S4 = {DS p , DW p , XLN p , BDN p}, 1 ≤ p ≤ P, where P is the total number of rows of the switchgear ledger;

[0038] 2) Extract the short name of the line corresponding to the switchgear: For any XLNp , if there are T strings in the line ledger, for the t-th string, if it satisfies and then let where left is a function in Excel, is the t-th string of XLN p , and XLKJ p is the abbreviation of the line corresponding to the switching station in the p-th row. ;

[0039] D. According to the substation and line abbreviation library obtained in step B, match the line abbreviation corresponding to the switching station obtained in step C with the substation and line abbreviation library to determine the substation to which the switching station belongs. Specifically:

[0040] For any XLN p , 1 ≤ p ≤ P, satisfying then let BDNC p = BDN k , that is, if the abbreviation of the switching station in the p-th row is the same as the abbreviation in the k-th row of the substation and line abbreviation library S3, then assign the substation name in the k-th row to the switching station, where BDNC p is the substation name to which the matched switching station belongs; if the above conditions are not met, then let BDNC p = no match (indicating that the abbreviation of the switching station cannot be found in the substation and line abbreviation library S3, and at this time, the substation to which the switching station belongs cannot be determined), indicating no match or unsuccessful match. After completing the matching of all rows, the ledger information of the switching station is {DS p , DW p , XLN p , BDN p , BDNC p}.

[0041] The following uses a specific embodiment to elaborate in detail on the technical solution and effect of the present invention:

[0042] In step A, 41327 pieces of data related to the switching station files in a certain area were obtained from the relevant system.

[0043] In step B, based on the switching station ledger data obtained in step A, calculate and obtain the substation and line abbreviation library, as shown in Table 1.

[0044] Table 1

[0045]

[0046]

[0047] In step C, extract the abbreviations of the line names corresponding to the switching stations, as shown in Table 2.

[0048] Table 2

[0049]

[0050] In step D, the line name abbreviation corresponding to the switch station is matched with the substation and line abbreviation library to determine the substation to which the switch station belongs, as shown in Table 3.

[0051] Table 3

[0052]

[0053] After on-site verification, the substations to which the switchgears determined by the above method belong are all correct, indicating the effectiveness of the method proposed in the present invention.

[0054] The present invention provides a method for determining the substation to which a switch station belongs, which can automatically identify the substation to which the switch station belongs, and help operation and maintenance personnel to carry out maintenance of basic files and improve work efficiency.

[0055] The above description is only a specific implementation mode of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by technicians in this technical field within the technical scope disclosed by the present invention should be covered by the protection scope of the present invention.

Claims

1. A method for judging the substation to which a switchgear belongs, characterized in that Including the following steps: A. Obtain the ledger data related to the switchgear station, and the ledger data related to the switchgear station includes: the city where it belongs, the operating unit, the line name, the name of the substation or switchgear station; B. Based on the ledger data related to the switchgear station obtained in step A, calculate and obtain the substation and line abbreviation library; C. According to the ledger data related to the switchgear station obtained in step A, extract the line abbreviations corresponding to the switchgear station; D. According to the substation and line abbreviation library obtained in step B, match the line abbreviations corresponding to the switchgear station obtained in step C with the substation and line abbreviation library to determine the substation to which the switchgear station belongs; In step B, for the switchgear station ledger data obtained in step A, calculate and obtain the substation and line abbreviation library, specifically: The collected ledger data related to switchgear stations is recorded as , where represents the corresponding city where the i-th ledger belongs, represents the corresponding operating unit in the i-th ledger, represents the corresponding line name in the i-th ledger, represents the corresponding substation or switchgear station name in the i-th ledger, , and n is the total number of ledgers; 1) According to in the ledger information, calculate the substation flag bit. If contains the string "substation", then record , otherwise . After completing the calculation of all ledger information, the new ledger information can be obtained and recorded as , ; 2) According to the obtained new ledger information , taking as the object for duplicate removal, specifically: if , then delete the ledger of the i-th row; if , then determine whether it is repeated with the existing ledger. If there are J rows of existing ledgers that satisfy , then retain the ledger of the i-th row, otherwise delete it; the ledger after duplicate removal is denoted as , , , where K represents the total number of rows of the ledger after duplicate removal; 3) Extract the short name of the substation through the LEFT function in Excel, , which is the short name of the k-th substation; 4) Extract the short name of the line corresponding to the substation. For any , if there are M strings in the line ledger, for the m-th string, if it satisfies , and , then let , where left is a function in excel, is 's m-th string; 5) After completing the calculation of the abbreviations of all ledger substations and lines, an abbreviation library for substations and lines is obtained, denoted as , , ; In step C, for the switchgear station ledger data obtained in step A, extract the line abbreviations corresponding to the switchgear station, specifically: 1) According to in the ledger information, calculate the substation flag bit. If contains the string "substation", then record , otherwise . After completing the calculation of all ledger information, the new ledger information obtained is ; According to the obtained new ledger information , if , then retain this line of ledger, otherwise delete it. At the same time, perform deduplication processing on the switching station. After the processing is completed, the ledger information of the switching station is recorded as , , , where P is the total number of rows of the switching station ledger; 2) Extract the abbreviated name of the line corresponding to the switching station: For any , if there are T strings in the line ledger, for the t-th string, if it satisfies , and , then let , where left is a function in Excel, is 's t-th string, is the abbreviated name of the line corresponding to the switching station in the p-th row.

2. The method for judging the substation to which a switchgear belongs according to claim 1, wherein: According to the substation and line abbreviation library obtained in step B, match the line abbreviations corresponding to the switchgear station obtained in step C with the substation and line abbreviation library, and determine the substation to which the switchgear station belongs according to the matching result, specifically: For any , , satisfying , then let , that is, if the abbreviation of the switching station in the p-th row is the same as the abbreviation in the k-th row of the substation and line abbreviation library , then assign the substation name in the k-th row to the switching station, where is the substation name to which the matched switching station belongs; If the above conditions are not met, then let , indicating no match or unsuccessful match. After completing the matching of all lines, the ledger information of the switchgear is .

Images