Fault information screening method for distribution lines and distribution transformers

Abstract

An embodiment of the present invention discloses a method for screening fault information of distribution lines and distribution transformers. The method for screening fault information of distribution lines and distribution transformers includes: importing a distribution line problem table and a distribution transformer problem table; retrieving the distribution line problem table and the distribution transformer problem table according to a key field library to generate a target problem library table; retrieving the associated information associated with the key field in the target problem library table according to the key field table, and writing the associated information into an infrastructure planning project library table. In the case where the data of distribution line problems and distribution transformer problems are constantly updated, this solution can quickly screen the updated data in the updated distribution line problem table and the distribution transformer problem table to generate a target problem library table, thereby improving the efficiency of data screening. Through the infrastructure planning project library table generated by the target problem library table, it is easy to obtain the basic information of the distribution lines and distribution transformers, take maintenance measures for equipment failures in a timely manner, and improve operation and maintenance efficiency.

Description

Technical Field

[0001] The embodiments of the present invention relate to the field of information processing technology, and in particular to a method for screening fault information of power distribution lines and distribution transformers. Background Art

[0002] Infrastructure project data is constantly updated daily, and the data volume is enormous. Currently, the operations team and the medium and low voltage operation and maintenance team report collected issues and proposed solutions to the planning team. The planning team manually screens the data and includes only those eligible for inclusion in the problem database. This requires staff to analyze and screen each item in the 10kV medium voltage distribution line ledger and the public distribution transformer ledger. Based on the criteria for specific data fields, staff manually fill in the problem database table in the ledger table. After completing this, each item with outstanding issues must be summarized and recorded in the medium and low voltage problem database ledger and the medium and low voltage distribution network infrastructure planning project database table. This work model clearly places a high workload on staff and severely impacts work efficiency in an environment of constantly updating data. Summary of the Invention

[0003] An embodiment of the present invention provides a method for screening distribution line and distribution transformer fault information to achieve rapid screening of updated data in an updated distribution line problem table and distribution transformer problem table, thereby improving data screening efficiency and further improving the work efficiency of staff.

[0004] In a first aspect, an embodiment of the present invention provides a method for screening fault information of a distribution line and distribution transformer, comprising:

[0005] Import the distribution line problem table and distribution transformer equipment problem table;

[0006] Retrieve the distribution line problem table and the distribution transformer equipment problem table according to the key field library to generate the target problem library table;

[0007] According to the key field table, the remark information associated with the key field table in the target question library table is retrieved, and the remark information associated with the key field table is written into the infrastructure planning project library table.

[0008] Optionally, import the distribution line problem table and distribution transformer equipment problem table, including:

[0009] Import multiple distribution line problem tables and multiple distribution transformer equipment problem tables;

[0010] The imported multiple distribution line problem tables and multiple distribution transformer equipment problem tables are aggregated into a summary problem table; wherein the summary problem table includes a distribution line problem table area and a distribution transformer equipment problem table area.

[0011] Optionally, the key field library includes: a distribution line key field library and a distribution transformer key field library;

[0012] The distribution line key field library is associated with the distribution line problem table area, and the distribution transformer key field library is associated with the distribution transformer problem table area.

[0013] Optionally, the distribution line problem table and the distribution transformer equipment problem table are retrieved according to the key field library to generate a target problem library table, including:

[0014] The distribution line problem table area is retrieved according to the distribution line key field library, and the distribution transformer equipment problem table area is retrieved according to the distribution transformer equipment key field library to generate the target problem library table.

[0015] Optionally, searching the distribution line problem table and the distribution transformer equipment problem table according to the key field library to generate a target problem library table further includes:

[0016] Retrieve distribution line problems and distribution transformer equipment problems based on the key fields in the key field library; determine whether the distribution line problems and distribution transformer equipment problems meet the screening conditions;

[0017] The distribution line problems and distribution transformer equipment problems that meet the screening criteria are summarized to generate a target problem database table.

[0018] Optionally, determine whether distribution line problems and distribution transformer equipment problems meet the screening criteria, including:

[0019] Retrieve the mark characters in the columns corresponding to the key fields of distribution line problems and distribution transformer equipment problems;

[0020] If the mark character in the column corresponding to the key field of distribution line problem and distribution transformer equipment problem is "yes", the screening condition is met;

[0021] If the mark character in the column corresponding to the key field of distribution line problem and distribution transformer equipment problem is "No", the filtering condition is not met.

[0022] Optionally, the key fields in the key field library of the distribution line include: "Is it heavy loaded?", "Is it overloaded?", "Is it light loaded?", "Is the contact point unreasonable?", "Is the segmentation unreasonable?", "Is it single radiation?", "Is it atypical wiring?", "Is it not transferable?", "Is the installed capacity too high?", "Is the installed capacity too low?", "Is there a bottleneck in the wire?", "Is there a large branch?", "Is the main line not meeting the automation configuration requirements?", and "Is the important branch line not meeting the automation configuration requirements?"

[0023] Optionally, the key fields in the key field library of distribution transformer equipment include: "Is it overloaded?", "Is it heavily loaded?", "Is it lightly loaded?", "Is there three-phase imbalance?", "Is there high voltage in the substation?", "Is there low voltage in the substation?", "Is there obsolete equipment or lines?", "Is there a safety hazard?", "Is line loss exceeding 15%?", "Is the application restricted?", "Is a distribution transformer monitoring terminal installed?", "Is it a high-loss distribution transformer?", "Is smart meters not fully covered?" and "Is low-voltage meter reading not fully covered?"

[0024] Optionally, retrieving the remark information associated with the key field table in the target question library table according to the key field table, and writing the remark information associated with the key field table into the infrastructure planning project library table, including:

[0025] Retrieve the remark area of the target question library table according to the key fields in the key field table;

[0026] Obtain the remark information associated with the remark area of the target question library table and the key field in the key field table;

[0027] Fill in the remarks information into the infrastructure planning project library table.

[0028] Optionally, the key fields in the key field table include: "Year of Discovery", "Year of Planned Resolution", "Provincial Company Name", "Municipal Bureau Name", "County Bureau Name", "Power Supply Station Name", "Substation Name", "Feeder Name", "Distribution Transformer Name", "Problem Code", "Problem Name", "Problem Object Type", "Associated Object ID", "Problem Type", "Problem Information" and "Problem Description".

[0029] The technical solution of the embodiment of the present invention imports the distribution line problem table and the distribution transformer problem table, automatically retrieves the distribution line problem table and the distribution transformer problem table according to the key field library to generate a target problem library table, retrieves the remark information associated with the key field table in the target problem library table according to the key field table, and writes the remark information associated with the key field table into the infrastructure planning project library table. In this way, when the data of the distribution line problem and the distribution transformer problem are constantly updated, the updated data in the updated distribution line problem table and the distribution transformer problem table can be quickly screened to generate the target problem library table, thereby improving the efficiency of data screening. Through the infrastructure planning project library table generated by the target problem library table, it is easy to obtain the basic information of the distribution line and the distribution transformer equipment, take maintenance measures for equipment failures in a timely manner, and improve operation and maintenance efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, a brief introduction will be given below to the drawings required for use in the embodiments or the description of the prior art. Obviously, although the drawings described below are some specific embodiments of the present invention, for those skilled in the art, the basic concepts of the device structure, driving method and manufacturing method disclosed and suggested by the various embodiments of the present invention can be expanded and extended to other structures and drawings. Undoubtedly, these should all be within the scope of the claims of the present invention.

[0031] Figure 1 A schematic flow chart of a method for screening fault information of power distribution lines and distribution transformers provided in an embodiment of the present invention;

[0032] Figure 2 A partial schematic diagram of a distribution line problem table provided by an embodiment of the present invention;

[0033] Figure 3 A partial schematic diagram of a distribution transformer equipment problem table provided in an embodiment of the present invention;

[0034] Figure 4 A partial schematic diagram of an infrastructure planning project library table provided by an embodiment of the present invention;

[0035] Figure 5 A schematic flow chart of another method for screening fault information of power distribution lines and distribution transformers provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0036] To make the objectives, technical solutions, and advantages of the embodiments of the present invention more clear, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0037] Figure 1 This is a flow chart of a method for screening fault information of distribution lines and distribution transformers provided by an embodiment of the present invention. This embodiment is applicable to screening fault information of distribution lines and distribution transformers in power grids. The method specifically includes the following steps:

[0038] S110. Import the distribution line problem table and the distribution transformer equipment problem table.

[0039] Among them, the distribution line problem table is a registration table in which the staff summarizes the distribution line problems. Figure 2This is a partial schematic diagram of a distribution line problem table provided by an embodiment of the present invention; the distribution transformer equipment problem table is a registration table in which staff summarize the distribution transformer equipment problems. Figure 3 A partial schematic diagram of a distribution transformer equipment problem table provided in an embodiment of the present invention.

[0040] After the staff registers the distribution line problem table and the distribution transformer equipment problem table, they need to upload the distribution line problem table and the distribution transformer equipment problem table for unified data screening and processing.

[0041] S120. Retrieve the distribution line problem table and the distribution transformer equipment problem table according to the key field library to generate a target problem library table.

[0042] Each key field contained in the key field library corresponds to a problem in the distribution line problem table and the distribution transformer problem table. After importing the distribution line problem table and the distribution transformer problem table, the problem tables are filtered for specific issues based on the key fields stored in the key field library. The corresponding data filtered out from the distribution line problem table and the distribution transformer problem table is then aggregated into a target problem library. Clearly, the target problem library is a problem library generated by filtering the distribution line problem table and the distribution transformer problem table based on the selected key fields. The resulting target problem library is also known as the "key field" problem library. For example, based on the key field "whether loaded" stored in the key field library, the data on whether the distribution lines and distribution transformers are loaded can be filtered out from the distribution line problem table and the distribution transformer problem table. The data filtered out from the distribution line problem table and the distribution transformer problem table is then aggregated into a "whether loaded" problem library table.

[0043] S130. Retrieve the remark information associated with the key field table from the target question library table according to the key field table, and write the remark information associated with the key field into the infrastructure planning project library table.

[0044] Among them, the infrastructure project planning project database table is a basic information record of the problems recorded in the target problem database. Figure 4 A partial schematic diagram of an infrastructure planning project library table provided by an embodiment of the present invention. Remarks information associated with the key field table in the target question library table is retrieved based on the key field table, and the remark information associated with the key field is written into the infrastructure planning project library table. Specifically, the key fields in the key field table need to be associated with the remark information in the target question library table in advance. This allows accurate retrieval of the remark information associated with the selected key field in the key field table in the target question library table, and writes the remark information associated with the selected key field into the infrastructure planning project library table to record basic information.

[0045] In summary, this solution imports the distribution line problem table and the distribution transformer problem table, automatically retrieves the distribution line problem table and the distribution transformer problem table based on the key field library to generate a target problem library table, retrieves the remark information associated with the key field table in the target problem library table based on the key field table, and writes the remark information associated with the key field table into the infrastructure planning project library table. In this way, as the data on distribution line problems and distribution transformer problems is constantly updated, the updated data in the updated distribution line problem table and distribution transformer problem table can be quickly screened to generate a target problem library table, thereby improving data screening efficiency. The infrastructure planning project library table generated from the target problem library table facilitates the acquisition of basic information on distribution lines and distribution transformer equipment, allowing timely maintenance measures for equipment failures and improving operation and maintenance efficiency.

[0046] Figure 5 A flow chart of another method for screening fault information of distribution lines and distribution transformers provided by an embodiment of the present invention is shown as follows: Figure 5 As shown, the specific steps of the method include:

[0047] S210: Import multiple distribution line problem tables and multiple distribution transformer equipment problem tables.

[0048] S220. Aggregate the imported multiple distribution line problem tables and multiple distribution transformer equipment problem tables into a summary problem table; wherein the summary problem table includes a distribution line problem table area and a distribution transformer equipment problem table area.

[0049] After uploading multiple power distribution line problem tables and multiple power distribution transformer problem tables, they need to be integrated, that is, the multiple power distribution line problem tables and the multiple power distribution transformer problem tables are aggregated into a summary problem table. Obviously, the summary problem table includes the data of each uploaded power distribution line problem table and each power distribution transformer problem table, and the summary problem table includes a power distribution line problem table area and a power distribution transformer problem table area. When integrating the multiple power distribution line problem tables and the multiple power distribution transformer problem tables, the data contained in the multiple power distribution line problem tables is integrated into the power distribution line problem table area of the summary problem table, and the data contained in the multiple power distribution transformer problem tables is integrated into the power distribution transformer problem table area of the summary problem table.

[0050] S230: Retrieve the distribution line problem table and the distribution transformer equipment problem table according to the key field library to generate a target problem library table.

[0051] Optionally, the key field library includes: a distribution line key field library and a distribution transformer key field library; the distribution line key field library is associated with the distribution line problem table area, and the distribution transformer key field library is associated with the distribution transformer problem table area.

[0052] The summary problem table includes a distribution line problem table area and a distribution transformer problem table area. The key field library includes a distribution line key field library and a distribution transformer key field library. Retrieving the distribution line problem table and the distribution transformer problem table from the key field library to generate a target problem library table requires pre-association of the distribution line key field library with the distribution line problem table area, and pre-association of the distribution transformer key field library with the distribution transformer problem table area. This allows the target problem library table to be generated by retrieving the distribution line problem table and the distribution transformer problem table from the distribution line key field library and the distribution transformer key field library.

[0053] Specifically, the target problem library table is generated by retrieving the distribution line problem table and the distribution transformer problem table according to the key field library, including: retrieving the distribution line problem table area according to the distribution line key field library, retrieving the distribution transformer problem table area according to the distribution transformer key field library, and generating the target problem library table.

[0054] The key fields in the distribution line key field library include: "Is it heavy loaded?", "Is it overloaded?", "Is it light loaded?", "Is the contact point unreasonable?", "Is the segmentation unreasonable?", "Is it single-radiation?", "Is it atypical wiring?", "Is it unavailable for transfer?", "Is the installed capacity too high?", "Is the installed capacity too low?", "Is there a conductor bottleneck?", "Is there a large branch?", "Does the main line not meet automation configuration requirements?", and "Does an important branch line not meet automation configuration requirements?" Therefore, the distribution line problem table area is retrieved based on the key fields included in the distribution line key field library. The key fields in the distribution transformer key field library include: "Is it overloaded?", "Is it heavy loaded?", "Is it light loaded?", "Is there three-phase imbalance?", "Is there high voltage in the substation?", "Is there low voltage in the substation?", "Is there obsolete equipment or lines?", "Is there a safety hazard?", "Is there a line loss exceeding 15%?", "Is there a registration restriction?", "Is a distribution transformer monitoring terminal installed?", "Is there a high-loss distribution transformer?", "Is there incomplete smart meter coverage?", and "Is there incomplete low-voltage metering coverage?" Therefore, the distribution transformer problem table area is retrieved based on the key fields included in the distribution transformer key field library. The data retrieved from the distribution line problem table area and the distribution transformer equipment problem table area are summarized to form a target problem library.

[0055] In addition, retrieving the distribution line problem table and the distribution transformer equipment problem table according to the key field library to generate the target problem library table also includes: retrieving the distribution line problems and the distribution transformer equipment problems according to the key fields in the key field library; judging whether the distribution line problems and the distribution transformer equipment problems meet the screening conditions; summarizing the distribution line problems and the distribution transformer equipment problems that meet the screening conditions to generate the target problem library table.

[0056] Among them, the distribution line problems are obtained by searching the distribution line problem table area according to the distribution line key field library, and the distribution transformer equipment problems are obtained by searching the distribution transformer equipment problem table area according to the distribution transformer equipment key field library.

[0057] In addition, determining whether the distribution line problem and the distribution transformer equipment problem meet the screening conditions includes: retrieving the mark characters in the column corresponding to the key fields of the distribution line problem and the distribution transformer equipment problem; if the mark characters in the column corresponding to the key fields of the distribution line problem and the distribution transformer equipment problem are "yes", the screening conditions are met; if the mark characters in the column corresponding to the key fields of the distribution line problem and the distribution transformer equipment problem are "no", the screening conditions are not met.

[0058] Therefore, based on the judgment of the distribution line problems and distribution transformer equipment problems, the distribution line problems and distribution transformer equipment problems that meet the screening conditions are summarized to generate a target problem library table.

[0059] S240. Retrieve the remarks area of the target question library table according to the key fields in the key field table.

[0060] Specifically, the target question library table includes a remark area, wherein the key fields in the key field table are associated with the remark area of the target question library table, thereby the remark area of the target question library table can be retrieved according to the key fields in the key field table.

[0061] S250: Obtain the remark characters associated with the key fields in the remark area of the target question library table.

[0062] Among them, the key field of the remark area is associated with the remark character of the remark area. The key field of the remark area can be retrieved according to the key field in the key field table, and the remark character of the remark area associated with the key field of the remark area of the target question library table can be obtained through the key field of the remark area.

[0063] Specifically, the key fields in the key field table include: "Year of Discovery", "Year of Planned Resolution", "Provincial Company Name", "Municipal Bureau Name", "County Bureau Name", "Power Supply Station Name", "Substation Name", "Feeder Name", "Distribution Transformer Name", "Problem Code", "Problem Name", "Problem Object Type", "Associated Object ID", "Problem Type", "Problem Information" and "Problem Description".

[0064] For example, the comment text associated with the key field "Year of Discovery" in the comment area is: the specific year the problem occurred, such as "2021"; the comment text associated with the key field "Year of Planned Resolution" in the comment area is: the specific year the problem was resolved, such as "2022". Other comment text associated with key fields in the comment area are not listed here one by one.

[0065] S260. Fill in the remark characters into the infrastructure planning project library table.

[0066] Fill in the infrastructure planning project library table according to the remark characters in the remark area. For example, if the remark characters in the remark area associated with the key field "Planned Solution Year" in the remark area are: "2022", then fill in "2022" in the infrastructure planning project library table.

[0067] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A method for screening fault information of distribution lines and distribution transformers, characterized in that: include: Import the distribution line problem table and distribution transformer equipment problem table; Retrieving the distribution line problem table and the distribution transformer problem table according to the key field library to generate a target problem library table; Retrieving the remark information associated with the key field table in the target question library table according to the key field table, and writing the remark information associated with the key field table into the infrastructure planning project library table; The key field library includes: a distribution line key field library and a distribution transformer key field library; the distribution line key field library is associated with the distribution line problem table area, and the distribution transformer key field library is associated with the distribution transformer problem table area; The step of retrieving the distribution line problem table and the distribution transformer problem table according to the key field library to generate the target problem library table includes: retrieving the distribution line problem table area according to the distribution line key field library, and retrieving the distribution transformer problem table area according to the distribution transformer key field library to generate the target problem library table; The step of retrieving the distribution line problem table and the distribution transformer problem table according to the key field library to generate the target problem library table further includes: retrieving distribution line problems and distribution transformer problems according to the key fields in the key field library; determining whether the distribution line problems and the distribution transformer problems meet the screening conditions; and summarizing the distribution line problems and the distribution transformer problems that meet the screening conditions to generate the target problem library table. Wherein, the determining whether the power distribution line problem and the distribution transformer problem meet the screening conditions includes: searching for the mark characters in the columns corresponding to the key fields of the power distribution line problem and the distribution transformer problem; if the mark characters in the columns corresponding to the key fields of the power distribution line problem and the distribution transformer problem are "yes", the screening conditions are met; if the mark characters in the columns corresponding to the key fields of the power distribution line problem and the distribution transformer problem are "no", the screening conditions are not met; The step of retrieving the remark information associated with the key field table in the target question library table according to the key field table and writing the remark information associated with the key field table into the infrastructure planning project library table comprises: retrieving the remark area of the target question library table according to the key field in the key field table; obtaining the remark characters associated with the key field in the key field table and the remark area of the target question library table; and filling the remark characters into the infrastructure planning project library table. The distribution line problem is obtained by searching the distribution line problem table area according to the distribution line key field library, and the distribution transformer problem is obtained by searching the distribution transformer problem table area according to the distribution transformer key field library.

2. The method for screening fault information of distribution lines and distribution transformers according to claim 1, characterized in that: Import the distribution line problem table and distribution transformer equipment problem table, including: Importing a plurality of the distribution line problem tables and a plurality of the distribution transformer equipment problem tables; The imported multiple distribution line problem tables and the multiple distribution transformer problem tables are aggregated into a summary problem table; wherein the summary problem table includes a distribution line problem table area and a distribution transformer problem table area.

3. The method for screening fault information of distribution lines and distribution transformers according to claim 1, characterized in that: The key fields in the distribution line key field library include: "whether it is heavy loaded", "whether it is overloaded", "whether it is light loaded", "whether the contact point is unreasonable", "whether the segmentation is unreasonable", "whether it is single radiation", "whether it is atypical wiring", "whether it is not transferable", "whether the installed capacity is too high", "whether the installed capacity is too low", "whether the wire is stuck", "whether there is a large branch", "whether the main line does not meet the automation configuration requirements" and "whether the important branch line does not meet the automation configuration requirements".

4. The method for screening fault information of distribution lines and distribution transformers according to claim 1, characterized in that: The key fields in the key field library of the distribution transformer equipment include: "Whether it is overloaded", "Whether it is heavy loaded", "Whether it is light loaded", "Whether there is three-phase imbalance", "Whether the voltage in the substation is too high", "Whether the voltage in the substation is too low", "Whether there are old equipment or lines", "Whether there are safety hazards", "Whether the line loss exceeds 15%", "Whether the application is restricted", "Whether the distribution transformer monitoring terminal is installed", "Whether it is a high-loss distribution transformer", "Whether the smart meter is not fully covered" and "Whether the low-voltage meter reading is not fully covered".

5. The method for screening fault information of distribution lines and distribution transformers according to claim 1, characterized in that: The key fields in the key field table include: "Year of Discovery", "Year of Planned Resolution", "Provincial Company Name", "Municipal Bureau Name", "County Bureau Name", "Power Supply Station Name", "Substation Name", "Feeder Name", "Distribution Transformer Name", "Problem Code", "Problem Name", "Problem Object Type", "Associated Object ID", "Problem Type", "Problem Information" and "Problem Description".

Images