CN113672647B - Planned power outage specification verification method and device - Google Patents

Planned power outage specification verification method and device Download PDF

Info

Publication number
CN113672647B
CN113672647B CN202110883880.1A CN202110883880A CN113672647B CN 113672647 B CN113672647 B CN 113672647B CN 202110883880 A CN202110883880 A CN 202110883880A CN 113672647 B CN113672647 B CN 113672647B
Authority
CN
China
Prior art keywords
power failure
fault
information
time
overhaul
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202110883880.1A
Other languages
Chinese (zh)
Other versions
CN113672647A (en
Inventor
王元元
张佳琦
黄彦
韩韬
杜红卫
张蓓蓓
黄素娟
苏义荣
张玉林
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Nari Technology Co Ltd
NARI Nanjing Control System Co Ltd
Original Assignee
Nari Technology Co Ltd
NARI Nanjing Control System Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Nari Technology Co Ltd, NARI Nanjing Control System Co Ltd filed Critical Nari Technology Co Ltd
Priority to CN202110883880.1A priority Critical patent/CN113672647B/en
Publication of CN113672647A publication Critical patent/CN113672647A/en
Application granted granted Critical
Publication of CN113672647B publication Critical patent/CN113672647B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/103—Workflow collaboration or project management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/20—Administration of product repair or maintenance
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06—Energy or water supply
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
    • Y04S10/00—Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • Databases & Information Systems (AREA)
  • Economics (AREA)
  • Data Mining & Analysis (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Engineering & Computer Science (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Computational Linguistics (AREA)
  • Health & Medical Sciences (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Public Health (AREA)
  • Water Supply & Treatment (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Supply And Distribution Of Alternating Current (AREA)
  • Remote Monitoring And Control Of Power-Distribution Networks (AREA)

Abstract

The invention discloses a planned outage specification verification method and device, which are used for matching different database table information according to maintenance list basic information, carrying out data extraction and information analysis, and obtaining a display result of outage and maintenance plans and a display result of maintenance list normalization verification. According to the basic information of the power failure, matching different database table information, carrying out data extraction and information analysis, and obtaining the display results of the power failure and the power failure, and the display results of the online circulation and the repair by robbery. The planned outage specification verification method and device provided by the invention can intuitively display comprehensive information such as planned outage specification information, verification results and the like in real time, greatly reduce the workload of manual inquiry, avoid repeated and complicated information integration analysis work, effectively monitor the running condition of the distribution network switch and provide an auxiliary decision function for planned outage management and control of the distribution network.

Description

Planned power outage specification verification method and device
Technical Field
The invention relates to a planned outage specification verification method and device, and belongs to the technical field of power grid system automation.
Background
At present, the distribution automation coverage rate is relatively low, all distribution network switches cannot be monitored, the former supervision means is limited, the basic-level private pulling and messy stop condition is serious, the manual inquiry amount is large, the information integration analysis is complex, and the current use requirement of an OMS (operation management system) of the power system cannot be met.
The power system OMS system is an important component of a Distribution Management System (DMS), including planned outage management and fault outage management. As a part of high-level application analysis of the power distribution network, the function of checking the planned outage specification is very important, but how to realize the verification of the planned outage specification on the power distribution network with relatively low power distribution automation coverage rate is a technical problem which needs to be solved by the technicians in the field.
Disclosure of Invention
The purpose is as follows: in order to overcome the defects of limited monitoring means, large manual inquiry amount and complicated information integration and analysis in the prior art, the invention provides a planned outage specification checking method, which is based on the operation information and measurement information of distribution network equipment acquired by a distribution automation master station system, combines the functions of the existing maintenance planning outage analysis and fault tripping outage range analysis of a main distribution integrated system, comprehensively analyzes whether the situation of irregular maintenance such as 'false filling of an OMS (open management system) planned maintenance list', 'circulation under an unscheduled maintenance line', 'condition of maintenance with first aid maintenance of an operation and maintenance unit', and the like, thereby realizing the information inquiry of a distribution network outage event, a maintenance plan and a fault outage event.
The technical scheme is as follows: in order to solve the technical problems, the invention adopts the following technical scheme:
A planned outage specification verification method comprises the following steps:
and matching different database table information according to the basic information of the overhaul list, and carrying out data extraction and information analysis to obtain the display results of the outage and restoration and overhaul plans.
And matching different database table information according to the basic information of the overhaul list, and carrying out data extraction and information analysis to obtain the display result of the overhaul list standardization check.
And matching different database table information according to the power failure and power restoration basic information, and carrying out data extraction and information analysis to obtain the display results of power failure and power restoration and fault power failure.
According to the power failure basic information, matching different database table information, carrying out data extraction and information analysis, and obtaining the display results of online downflow and urgent repair.
A planned outage specification verification device, comprising the steps of:
and the power outage and repair plan module is used for matching different database table information according to the basic information of the repair list, carrying out data extraction and information analysis, and obtaining the display result of the power outage and repair plan.
And the overhaul list standardization verification module is used for matching different database table information according to the overhaul list basic information, carrying out data extraction and information analysis, and obtaining the display result of the overhaul list standardization verification.
And the power failure and power restoration stopping and fault power failure module is used for matching different database table information according to the power failure and power restoration stopping basic information, carrying out data extraction and information analysis, and obtaining the display results of power failure and power restoration stopping and fault power failure.
And the online downflow and first-aid repair module is used for matching different database table information according to the power failure basic information, carrying out data extraction and information analysis, and obtaining the display result of online downflow and first-aid repair.
As a preferred scheme, the method for acquiring the display results of the outage and maintenance plan comprises the following steps:
and acquiring data information of the maintenance list number, maintenance content, power outage approval starting time and power outage approval ending time from the maintenance list basic information table.
And matching the affected distribution network lines corresponding to the same maintenance list number in the power failure area equipment information table according to the maintenance list number, and listing the affected line names in a character string form.
And matching the equipment ID with the distribution network transformer table according to the equipment ID and the equipment station set of the same service list number in the service list number matching power outage area equipment information table, acquiring the distribution network transformer as a power outage influence distribution transformer, and displaying all distribution transformer names in the power outage influence distribution transformer by clicking a detailed word on a display interface and another bullet window.
Matching the approved power outage starting time and the approved power outage ending time with the fault occurrence time of the DA fault diagnosis and isolation information table or the DA fault diagnosis and isolation history table, and screening records of the fault occurrence time in the range of the approved power outage starting time and the approved power outage ending time; and matching the fault tripping switch in the screened record with the overhaul content, screening the record with the same fault tripping switch, and selecting the id number of the fault identifier in the record as the stop-recovery electricity research judgment number.
According to the id number of the fault identification, acquiring a trip switch in a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, matching a distribution network switch table according to the id information of the trip switch to obtain feeder line id information corresponding to the trip switch id information, and matching a distribution network feeder line table according to the feeder line id information to obtain a feeder line name as a distribution network line.
And acquiring a DA fault diagnosis and isolation information table or a fault time domain in the DA fault diagnosis and isolation history table as power failure occurrence time for power failure recovery study and judgment according to the id number of the fault identification.
Screening the equipment ids with the same fault identification id in the DA path coloring information table according to the fault identification id, matching the equipment ids with the distribution network transformer table, acquiring the names of the distribution network transformers as fault judgment influence distribution transformers, clicking the interface detail word, and obtaining all the names of the distribution transformer equipment in the fault judgment influence distribution transformers on a new pop-up interface.
As a preferred scheme, the method for acquiring the display result of the overhaul mono-standardization check comprises the following steps:
and acquiring data information of an overhaul sheet number, an overhaul sheet type, overhaul contents, power failure application start time, work application end time, power supply application recovery time, work execution start time, work execution end time, power failure execution start time and power supply recovery execution time from an overhaul sheet basic information table.
And matching the equipment ID with the distribution network transformer table according to the equipment ID and the equipment station set of the same service list number in the service list number matching power failure area equipment information table, acquiring the name of the distribution network transformer as an influence distribution transformer, and displaying all the distribution transformer names in the influence distribution transformer by clicking a detailed word on a display interface and another bullet window.
And carrying out matching analysis on each line and the power failure and restoration research judgment event according to the lines influenced by the overhaul sheet, and judging whether the overhaul starting time is matched with the overhaul influence range or not in the power failure and restoration research judgment event.
And (3) enabling the maintenance starting time of the power failure and power failure judging event to be: t is t 1 ，t 1 Taking the power failure stopping and repeating, researching and judging the power failure occurrence time and repeating the power failure time: t (T) 1 ，T 1 Take approval of power failure start time, if T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a For the first time threshold, the maintenance start time accords with the maintenance list specification, wherein T a Can be configured for 0.5 hours.
If the number of the power failure affecting distribution transformer corresponding to the maintenance corresponding to the power failure restoring study judgment event/the number of the fault studying judgment affecting distribution transformer in the maintenance plan is multiplied by 100 percent not less than N percent, and N is a maintenance duty ratio threshold, the maintenance affecting range accords with the maintenance list specification, wherein N can be configured to be 50.
When the overhaul starting time and the overhaul influencing range are matched, the field meeting the specification is filled with yes, otherwise, no is filled.
As a preferred scheme, the method for acquiring the display results of the power failure and the power outage comprises the following steps:
and acquiring data information of fault identification, fault tripping switch and fault occurrence time from the DA fault diagnosis and isolation information table or the DA fault diagnosis and isolation history table, and respectively serving as data information of power failure number, tripping switch and power failure time.
And screening the names of the main network stations or the feeder line names of the distribution networks in the main network breaker table or the distribution network switch table, which are recorded in accordance with the tripping switch, as power outage lines according to the tripping switch.
And screening the equipment id in the record consistent with the outage number in the DA path coloring information table according to the outage number, screening the distribution transformer name in the record consistent with the equipment id in the distribution network transformer table according to the equipment id, and taking the distribution transformer name as the influence distribution transformer. Clicking the detailed word on the display interface, and displaying all the distribution transformer names in the influence distribution transformer by another popup window.
Screening the fault tripping occurrence time dtime in the id domain according to the tripping switch in the fault tripping switch information table, which is consistent with the tripping switch, and taking the fault tripping occurrence time dtime as the fault tripping time.
And screening the cb_id in the record consistent with the tripping switch in the fault tripping switch information table according to the tripping switch, matching the cb_id with the distribution network switch table, and obtaining the switch name as the fault tripping switch.
Screening action_id in records consistent with the cb_id in the fault tripping switch information table according to the cb_id, screening distribution transformer equipment information corresponding to the same id domain in the fault tripping area information table according to the action_id, taking the distribution transformer equipment as fault tripping influence distribution transformer, and displaying all distribution transformer names in the fault tripping influence distribution transformer by clicking a detailed word on a display interface.
And screening the recolonic_state information in the record consistent with the cb_id in the fault tripping switch information table according to the cb_id, and taking the recolonic_state as a reclosing state.
As a preferred scheme, the method for displaying the results by on-line downflow and rush repair comprises the following steps:
and acquiring data information of fault identification, fault tripping switch and fault occurrence time from the DA fault diagnosis and isolation information table or the DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure recovery number, a tripping switch and fault judging time.
And screening the names of the main network stations or the names of feeder lines to which the distribution network belongs in records consistent with the tripping switch in the main network breaker table or the distribution network switch table as the feeder lines to which the main network stations or the distribution network belongs.
And screening the equipment id in the record consistent with the outage number in the DA path coloring information table according to the outage number, screening the distribution transformer name in the record consistent with the equipment id in the distribution network transformer table according to the equipment id, and taking the distribution transformer name as the influence distribution transformer. Clicking the detailed word on the display interface, and displaying all the distribution transformer names in the influence distribution transformer by another popup window.
And carrying out matching analysis on each line and the power failure and restoration research judgment event according to the lines influenced by the overhaul sheet, and judging whether the overhaul starting time is matched with the overhaul influence range or not in the power failure and restoration research judgment event.
And (3) enabling the maintenance starting time of the power failure and power failure judging event to be: t is t 1 ，t 1 Taking the power failure occurrence time of the power failure recovery study judgment, and the power failure recovery time of the power failure recovery study judgment: t (T) 1 ，T 1 Take approval of power failure start time, if T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a And if the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification. Wherein T is a Can be configured for 0.5 hours.
And if the number of the distribution transformers affected by the power failure in the maintenance corresponding outage and restoration electricity research judgment event/the number of the distribution transformers affected by the fault research judgment in the maintenance plan are multiplied by 100 percent not less than N percent, and N is a maintenance duty ratio threshold, the maintenance influence range accords with the maintenance list specification. Wherein 50 is configurable.
When the overhaul start time and the overhaul influence range are matched, the field of the 'whether to match the planned overhaul list' is filled with 'yes', otherwise, the field of the 'no' is filled with 'no'.
And matching the power failure start time of the power failure recovery research judgment event with the fault tripping information, and matching the power failure start time of the power failure recovery research judgment event with the power failure influence range.
And enabling the power failure starting time of the power failure stopping and repeating research judgment event to be x, enabling the fault tripping time to be y and enabling the time offset to be z minutes, and if y-z is not less than z and not more than y+z. Wherein z is configured to be 10 minutes. The power outage start time meets the fault trip specification.
The number of the distribution transformer is influenced by fault research and judgment in the outage and restoration research and judgment event/the distribution number of the circuit is multiplied by 100 percent not less than M% influenced by fault tripping, M is a fault duty ratio threshold value, and the influence range of power outage accords with the fault tripping standard. Wherein M is configurable to 50.
When the power failure starting time and the power failure influence range are matched, the field of the 'whether the power failure is matched with the fault tripping' is filled with 'yes', otherwise, the field of the 'no' is filled with 'no'.
The beneficial effects are that: according to the planned outage specification verification method provided by the invention, the distribution network equipment operation information and measurement information are acquired based on the distribution automation master station system, the information inquiry of distribution network outage events, maintenance plans and fault outage events is realized, the data extraction, the information analysis matching and the function verification of the ten related tables are carried out, the information display functions of distribution network outage and maintenance plans, maintenance single-normalization verification, outage and fault outage, offline circulation and preemptive maintenance verification are realized, the comprehensive information such as planned outage specification information and verification results is intuitively displayed in real time, the workload of manual inquiry is greatly reduced, repeated and complicated information integration analysis work is avoided, the operation condition of distribution network switches can be effectively monitored, and an auxiliary decision function is provided for power distribution network planned outage management and control.
Drawings
FIG. 1 is a schematic diagram of a planned outage specification verification process according to the present invention;
FIG. 2 is a shutdown and repair planning interface of the present invention;
FIG. 3 shows detailed distribution information of the power outage influence distribution transformer;
FIG. 4 shows the detail page distribution information of the fault judging influence distribution changes of the invention;
FIG. 5 is a service single normalization check interface of the present invention;
FIG. 6 shows detailed page distribution information of the distribution transformer affected by overhaul single standardization check of the invention;
FIG. 7 is a power outage and fault interface of the present invention;
FIG. 8 shows the detailed page distribution information of the distribution change affected by the power failure and the power failure interface;
FIG. 9 is a fault trip influencing configuration details page configuration information of the present invention;
FIG. 10 is a down-line flow and preemptive dimension verification interface of the present invention;
FIG. 11 shows the power failure affecting distribution information of the present invention; .
Detailed Description
The invention will be further described with reference to specific examples.
As shown in fig. 1, a planned outage specification verification device includes the following modules:
the system comprises a power failure and power restoration and maintenance planning module, a maintenance single normalization verification module, a power failure and power restoration and failure power failure module and an off-line transfer and maintenance replacement verification module.
And the power failure and restoration and maintenance plan, the power failure and restoration and the fault power failure are respectively that the power failure and restoration research and judgment event is matched and screened with different reference objects. If the power failure and the power restoration match the maintenance plan, the power failure and the power failure can not be matched under normal conditions.
And the outage and maintenance plan is provided with outage and restoration electricity research judgment numbers, wherein the outage and restoration electricity research judgment numbers, the outage and fault power failure, the offline circulation and the outage in the emergency maintenance verification are derived from the same table, if the outage and restoration electricity research judgment numbers in the outage and maintenance plan are A, the outage and restoration electricity research judgment numbers in the outage and fault power failure are B, and the outage and restoration electricity numbers in the offline circulation and emergency maintenance verification are C, all records in the table (outage and restoration electricity fault research judgment event=planned maintenance power failure+fault power failure+offline circulation power failure).
The service list specification is similar to the abbreviation of the service list, and whether the service list is correct or not is analyzed by matching the power failure and the data of scheduled service.
The matching flow is as follows, and whether irregular filling exists in OMS (power outage management system) scheduled maintenance is analyzed according to OMS maintenance list/power outage restoration information/fault tripping information. If the OMS maintenance list can be matched with the recovery power failure research judgment event, the OMS maintenance list is considered to be filled in the specification, and the power failure is normal failure power failure or planned power failure filled in by the OMS. If the power failure event cannot be matched, the OMS maintenance list is considered to be out of specification, and the power failure event is off-line transfer or maintenance in robbery.
And the matching of the outage and restoration fault research and judgment event and the OMS maintenance list has two dimensions, and whether the maintenance starting time is matched with the maintenance influence range or not, namely, the matching principle and the power outage range matching principle.
The time matching principle enables the actual power failure time (power failure time of the mining area): t is t 1 The power failure time is recovered: t (T) 1 If T is satisfied 1 ≤t 1 ≤(T 1 +0.5 h), the time meets the specification, and the matching principle is satisfied. Wherein 0.5 hours is configurable.
And if the maintenance corresponds to all outage and recombination events to influence the distribution transformer/maintenance schedule, the distribution transformer multiplied by 100 percent is more than or equal to 50 percent, the specification is met, and the matching principle is satisfied. Of which 50% is configurable.
The power failure recovery fault research and judgment event is matched with the fault tripping power failure event, the matching has two dimensions, and whether the power failure starting time is matched with the power failure influence range or not, namely, the matching principle and the power failure range matching principle are adopted.
According to the time matching principle, the power failure time of the power failure judgment is x, the fault tripping time is y, and the time offset is z minutes, so that y-z is not less than z and not more than y+z needs to be satisfied. Where z defaults to 10 minutes, configurable.
And the power failure range matching principle is adopted, the power failure event influences the distribution transformer/fault tripping to influence the distribution transformer multiplied by 100 percent of the circuit to be more than or equal to 50 percent, and the power failure range matching principle meets the specification. Of which 50% is configurable.
The data of the present invention is derived from real-time library tables and commercial library tables.
Example 1:
a planned outage specification verification method comprises the following steps:
step one: double-clicking an icon of the plan overhaul standard verification module on a system interface, popping up a plan overhaul standard verification module login interface, inputting an authorized user name and password, clicking and logging in, and entering a user operation interface;
step two: clicking a power failure and restoration and maintenance plan button, displaying a power failure and restoration and maintenance plan page, and displaying a maintenance list result matched with a power failure and restoration research judgment event.
The display result comprises: the information of the service bill number, the service content, the start time of the approved power outage, the end time of the approved power outage, the influence of the power outage on the distribution network line, the distribution transformer, the stop-duplicate power research judgment number, the distribution network line, the stop-duplicate power research judgment power outage occurrence time and the fault research judgment influence on the distribution transformer is displayed with reference to the interface of the figure 2;
the method for obtaining the display result comprises the following steps: :
1. obtaining basic information of an overhaul list: acquiring the number, the maintenance content, the start time and the end time of the power outage of the maintenance list from a maintenance list basic information table;
2. acquiring an influence distribution network line: and matching the affected distribution network lines corresponding to the same maintenance list number in the power failure area equipment information table according to the maintenance list number, and listing the affected line names in a character string form.
3. Acquiring power failure influence distribution transformer: according to the equipment ID and equipment station set of the same service list number in the service list number matching power outage area equipment information table, matching the equipment ID with a distribution network transformer table, obtaining the names of distribution transformers as power outage influence distribution transformers, referring to FIG. 3, displaying the names of all distribution transformers in the power outage influence distribution transformer by clicking the detailed word on a display interface, and displaying another bullet window.
4. Acquiring a stop-recovery electricity grinding judgment number: matching the approved power outage starting time and the approved power outage ending time with the fault occurrence time of the DA fault diagnosis and isolation information table or the DA fault diagnosis and isolation history table, and screening records of the fault occurrence time in the range of the approved power outage starting time and the approved power outage ending time; and matching the fault tripping switch in the screened record with the overhaul content, screening the record with the same fault tripping switch, and selecting the id number of the fault identifier in the record as the stop-recovery electricity research judgment number.
5. Acquiring a distribution network line: according to the id number of the fault identification, acquiring a trip switch in a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, matching a distribution network switch table according to the id information of the trip switch to obtain feeder line id information corresponding to the trip switch id information, and matching a distribution network feeder line table according to the feeder line id information to obtain a feeder line name as a distribution network line.
6. Acquiring the power failure occurrence time of power failure recovery study judgment: and acquiring a DA fault diagnosis and isolation information table or a fault time domain in the DA fault diagnosis and isolation history table as power failure occurrence time for power failure recovery study and judgment according to the id number of the fault identification.
7. Obtaining fault grinding and judging influence distribution transformation: screening equipment id sets of the same fault identification ids in the DA path coloring information table according to the fault identification ids, matching the equipment ids with a distribution network transformer table, acquiring the names of the distribution transformers as fault judgment influence distribution transformers, clicking the interface detail word, and obtaining the equipment name information of all the distribution transformers in the fault judgment influence distribution transformers on a new pop-up interface.
Step three: in the interface of the power outage and maintenance plan, clicking a query button at the right upper corner of the interface, starting the power outage and maintenance plan interface information query function, completing query result information display, and further checking the name information of the affected specific distribution equipment by clicking a detail word for the display fields of the power outage influence distribution transformer and the fault research judgment influence distribution transformer, wherein the interface display is shown in figures 3 and 4.
Step four: clicking a maintenance list normalization check button, displaying a maintenance list normalization check page, and displaying maintenance list information and normalization check results thereof.
The display result comprises: the service list number, the service list type, the service content, the service power failure start time, the service work end time, the power supply restoration time, the execution work start time, the execution work end time, the power failure start time, the power supply restoration time, the power distribution influence, and the information whether the service list number, the service list type, the service content, the service power failure start time, the service power restoration time, the power supply restoration time, the power distribution influence, and the information whether the service list meets the specifications, wherein whether the service list meets the specifications finally shows a matching result in yes or no, and the interface is shown and referred to in fig. 5 according to a matching principle.
1. The method for obtaining the display result comprises the following steps: obtaining basic information of an overhaul list: obtaining data information of an overhaul sheet number, an overhaul sheet type, overhaul contents, power failure application starting time, work application ending time, power supply application recovery time, work execution starting time, work execution ending time, power failure execution starting time and power supply recovery execution time from an overhaul sheet basic information table;
2. obtaining an influence distribution transformer: and matching the equipment ID with the distribution network transformer table according to the equipment ID and the equipment station set of the same service list number in the service list number matching power failure area equipment information table, taking the obtained distribution network transformer name as an influence distribution transformer, and displaying all distribution transformer names in the influence distribution transformer by clicking a detailed word on a display interface and another bullet window.
3. Acquiring whether the specification is met or not: filling in "yes" or "no", the matching principle is as follows:
and according to the lines affected by the overhaul list, carrying out matching analysis on the lines and the outage and restoration electricity research judgment events, and judging whether the overhaul starting time in the outage and restoration electricity research judgment events is matched with the overhaul influence range or not, wherein the real-time matching principle and the outage range matching principle are adopted.
The time matching principle is that the overhaul starting time of the outage research judgment event (the power outage starting time executed by a platform area) is: t is t 1 The power failure time is recovered: t (T) 1 If T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a And if the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification, and the time matching principle is met. Wherein T is a Can be configured for 0.5 hours.
And if the number of the power failure influencing distribution transformer corresponding to the maintenance corresponding to the power failure restoration research judgment event/the number of the fault research judgment influencing distribution transformer in the maintenance plan is multiplied by 100 percent not less than N percent, and N is a maintenance duty ratio threshold, the maintenance influence range accords with the maintenance list specification, and the power failure range matching principle is satisfied. Where N may be configured as 50.
When the two principles are matched, the field of whether the two principles meet the specification fills in yes, otherwise, no is filled in.
Step five: in the interface for checking the normalization of the overhaul list, clicking a query button at the right upper corner of the interface, starting an information query function of the interface for checking the normalization of the overhaul list, completing information display of query results, and for an 'influencing distribution transformer' display field in the information display, further checking the name information of the influenced distribution transformer equipment by clicking a detailed word, wherein the interface display is shown in FIG. 6;
Step six: clicking a power failure stopping and restoring button, displaying a power failure stopping and restoring page, and displaying the matching result of the power failure stopping and restoring research and judgment event and the power failure time and the tripping information.
The display result comprises a power failure number, a power failure line, a tripping switch, a power failure time, an influence distribution transformer, a fault tripping time, a fault tripping switch, a fault tripping influence distribution transformer and a reclosing state, and the interface display is shown in FIG. 7;
the method for obtaining the display result comprises the following steps:
1. acquiring basic information of power failure and power restoration: acquiring data information of fault identification, fault tripping switch and fault occurrence time from a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure number, a tripping switch and a power failure time;
2. obtaining a power failure line: and (3) screening the main network station names or the feeder line names of the distribution networks in the main network breaker table or the distribution network switch table, which are recorded in accordance with the tripping switch, as power outage lines according to the tripping switch obtained in the step (1).
3. Obtaining an influence distribution transformer: and screening the equipment id in the record consistent with the outage number in the DA path coloring information table according to the outage number in 1, screening the distribution transformer name in the record consistent with the equipment id in the distribution transformer table according to the equipment id, and taking the distribution transformer name as the influence distribution transformer. Clicking the detailed word on the display interface, and displaying all the distribution transformer names in the influence distribution transformer by another popup window.
4. Acquiring fault tripping time: screening the fault tripping occurrence time dtime in the id domain according to the tripping switch in the fault tripping switch information table, which is consistent with the tripping switch, and taking the fault tripping occurrence time dtime as the fault tripping time.
5. Acquiring a fault tripping switch: screening the cb_id in the record consistent with the tripping switch in the tripping switch information table according to the tripping switch obtained in the step 1, matching the cb_id with the distribution network switch table, and obtaining the switch name as the tripping switch of the fault.
6. Acquiring fault tripping influence distribution transformer: and screening action_id in the record consistent with the cb_id in the fault tripping switch information table according to the cb_id obtained in step 5, screening corresponding distribution transformer equipment information in the record consistent with the same id field in the fault tripping area information table according to the action_id, taking the distribution transformer equipment as fault tripping influence distribution transformer, and displaying all distribution transformer names in the fault tripping influence distribution transformer through clicking a detailed word on a display interface.
7. Acquiring a reclosing state: and screening the recolonic_state information in the record consistent with the cb_id in the fault tripping switch information table according to the cb_id obtained in step 5, and taking the recolonic_state as a reclosing state.
Step seven: clicking a query button at the right upper corner of the interface in the interface for stopping and resetting electricity and fault power failure, starting the function of inquiring the information of the interface for stopping and resetting electricity and fault power failure, completing the information display of the query result, and further checking the information of the affected distribution equipment by clicking the detailed words for the display fields of the distribution equipment for affecting distribution and the distribution for tripping of the fault in the display fields, wherein the interface display is shown in figures 8 and 9;
step eight: clicking a button for checking the offline flow and the first-aid dimension, displaying a page for checking the offline flow and the first-aid dimension, and displaying the information result of the power failure and restoration research and judgment event matched with the offline flow and the first-aid dimension.
The display result comprises: the number of the power failure, the feeder line, the tripping switch, the fault studying and judging time, the power failure influence distribution transformer, whether the power failure is matched with a planned maintenance list, and whether the power failure tripping (unusable and the like) information is matched.
Wherein, whether the repair order is matched with the plan is finally displayed by yes or no, whether the repair order is normally matched (accords with the specification) or not, whether the repair order is matched with the fault trip is finally displayed by yes or no, the two are matched according to the matching principle, and the interface display is shown in the figure 10;
Step nine: clicking a query button at the right upper corner of the interface in an interface of on-line down-flow and preemptive maintenance, starting the function of checking the interface information by the on-line down-flow and preemptive maintenance, completing the information display of query results, and for a display field of 'power failure and power restoration influence distribution transformation', further checking the affected distribution transformation equipment information by clicking a detailed word, wherein the interface display is shown in fig. 11;
1. the method for obtaining the display result comprises the following steps: acquiring basic information of power failure and power restoration: acquiring data information of fault identification, fault tripping switch and fault occurrence time from a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure recovery number, a tripping switch and fault judging time;
2. acquiring the feeder line: and (3) screening the names of the main network stations or the names of the feeder lines to which the distribution network belongs in records consistent with the tripping switch in the main network breaker table or the distribution network switch table according to the tripping switch obtained in the step (1).
3. Obtaining an influence distribution transformer: and screening the equipment id in the record consistent with the outage number in the DA path coloring information table according to the outage number in 1, screening the distribution transformer name in the record consistent with the equipment id in the distribution transformer table according to the equipment id, and taking the distribution transformer name as the influence distribution transformer. Clicking the detailed word on the display interface, and displaying all the distribution transformer names in the influence distribution transformer by another popup window.
4. Acquiring whether a planned maintenance list is matched or not: filling in "yes" or "no", the matching principle is as follows:
and according to the lines affected by the overhaul list, carrying out matching analysis on the lines and the outage and restoration electricity research judgment events, and judging whether the overhaul starting time in the outage and restoration electricity research judgment events is matched with the overhaul influence range or not, wherein the real-time matching principle and the outage range matching principle are adopted.
The time matching principle is that the overhaul starting time of the outage research judgment event (the power outage starting time executed by a platform area) is: t is t 1 The power failure time is recovered: t (T) 1 If T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a And if the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification, and the time matching principle is met. Wherein T is a Can be configured for 0.5 hours.
And if the number of the distribution transformers affected by the power failure in the maintenance corresponding to the power failure restoration research judgment event/the number of the distribution transformers affected by the fault research judgment in the maintenance plan are more than or equal to N%, wherein N is a maintenance duty ratio threshold, the maintenance influence range accords with the maintenance list specification, and the power failure range matching principle is satisfied. Wherein 50 is configurable.
When the two principles are matched, the field of the 'whether to match the planned maintenance list' is filled with 'yes', otherwise 'no'.
5. Acquiring whether fault tripping is matched or not: filling in "yes" or "no", the matching principle is as follows:
and matching the outage restoration research and judgment event with the fault tripping information, wherein the matching has two dimensions, and the matching has the characteristics that whether the outage starting time of the outage restoration research and judgment event is matched with the outage influence range is matched, namely, the matching principle and the outage range matching principle are adopted.
According to the time matching principle, the power failure starting time of the power failure stopping and repeating research and judgment event is x, the fault tripping time is y, and the time offset is z minutes, so that y-z is not less than z and not more than y+z needs to be satisfied. Wherein z is configured to be 10 minutes. The power failure start time meets the fault tripping specification and the time matching principle is satisfied.
And according to the power failure range matching principle, the number of the distribution transformer is influenced by fault research and judgment in the outage and restoration research and judgment event/the number of the distribution transformer is multiplied by 100 percent and is more than or equal to M percent, M is a fault duty ratio threshold, the power failure influence range meets the fault tripping standard, and the power failure range matching principle is met. Wherein M is configurable to 50.
When both principles match, the field "if match fault tripped" fills in "yes", otherwise "no" is filled in.
To sum up: the invention provides a planned outage specification verification method, which mainly comprises four parts of outage and repair planning, repair single-specification verification, outage and fault outage, offline circulation and emergency maintenance verification, and the functions of information display of distribution network outage and repair planning, repair single-specification verification, outage and fault outage, offline circulation and emergency maintenance verification are realized through data extraction, information analysis and matching and function verification, comprehensive information such as planned outage specification information, verification result and the like is intuitively displayed in real time, the workload of manual query is greatly reduced, repeated and complicated information integration analysis work is avoided, the operation condition of a distribution network switch can be effectively monitored, and an auxiliary decision function is provided for power distribution network planned outage management and control.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing is only a preferred embodiment of the invention, it being noted that: it will be apparent to those skilled in the art that various modifications and adaptations can be made without departing from the principles of the present invention, and such modifications and adaptations are intended to be comprehended within the scope of the invention.

Claims (5)

1. A planned outage specification verification method is characterized by comprising the following steps of: the method comprises the following steps:
According to the basic information of the overhaul list, matching different database table information, carrying out data extraction and information analysis, and obtaining the display results of the outage and restoration and overhaul plans;
according to the basic information of the overhaul list, matching different database table information, carrying out data extraction and information analysis, and obtaining the display result of the overhaul list standardization check;
according to the power failure and power restoration basic information, matching different database table information, performing data extraction and information analysis, and obtaining display results of power failure and power restoration and fault power failure;
according to the power failure basic information, matching different database table information, performing data extraction and information analysis, and obtaining the display results of online downflow and preemptive repair;
the method for obtaining the display results of the outage and repair plan comprises the following steps:
acquiring the number, the maintenance content, the start time and the end time of the power outage of the maintenance list from a maintenance list basic information table;
matching the affected distribution network lines corresponding to the same maintenance list number in the power failure area equipment information table according to the maintenance list number, and listing the affected line names in a character string form;
matching the equipment ID with the distribution network transformer table according to the equipment ID and the equipment station set of the same maintenance number in the equipment information table of the power outage area, and obtaining the name of the distribution network transformer as the power outage influence distribution transformer;
Matching the approved power outage starting time and the approved power outage ending time with the fault occurrence time of the DA fault diagnosis and isolation information table or the DA fault diagnosis and isolation history table, and screening records of the fault occurrence time in the range of the approved power outage starting time and the approved power outage ending time; matching the fault tripping switch in the screened record with the overhaul content, screening the record with the consistent fault tripping switch, and selecting the id number of the fault identifier in the record as a stop-and-repeat electricity research judgment number;
acquiring a trip switch in a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table according to the id number of the fault identifier, matching a distribution network switch table according to the id information of the trip switch to obtain feeder line id information corresponding to the trip switch id information, and matching a distribution network feeder table according to the feeder line id information to obtain a feeder line name as a distribution network line;
according to the id number of the fault identification, acquiring a DA fault diagnosis and isolation information table or a fault time domain in the DA fault diagnosis and isolation history table as power failure occurrence time for power failure recovery study judgment;
screening a device id set of the same fault identification id in the DA path coloring information table according to the fault identification id, matching the device id with the distribution network transformer table, and obtaining the name of the distribution network transformer as a fault research judgment influence distribution transformer;
The method for acquiring the display result of the overhaul list standardization check comprises the following steps:
obtaining data information of an overhaul sheet number, an overhaul sheet type, overhaul contents, power failure application starting time, work application ending time, power supply application recovery time, work execution starting time, work execution ending time, power failure execution starting time and power supply recovery execution time from an overhaul sheet basic information table;
matching the equipment ID and the equipment station set of the same service list number in the equipment information table of the power failure area according to the service list number, matching the equipment ID with a distribution network transformer table, and taking the obtained distribution network transformer name as an influence distribution transformer;
according to the lines affected by the overhaul list, carrying out matching analysis on the lines and the power failure and restoration research judgment event, and judging whether the overhaul starting time in the power failure and restoration research judgment event is matched with the overhaul affecting range;
and (3) enabling the maintenance starting time of the power failure and power failure judging event to be: t is t 1 ，t 1 Taking the power failure occurrence time of the power failure recovery study judgment, and the power failure recovery time of the power failure recovery study judgment: t (T) 1 ，T 1 Take approval of power failure start time, if T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a If the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification;
if the number of the distribution transformers is influenced by the power failure of the maintenance corresponding to the power failure recovery analysis event/the number of the distribution transformers is multiplied by 100 percent not less than N which is the maintenance duty ratio threshold value in the maintenance plan, the maintenance influence range accords with the maintenance list specification;
When the overhaul starting time and the overhaul influence range are matched, filling in the "yes" field which is in accordance with the specification "or else filling in the" no ";
the method for obtaining the display results of the power failure and the power outage comprises the following steps:
acquiring data information of fault identification, fault tripping switch and fault occurrence time from a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure number, a tripping switch and a power failure time;
according to the tripping switch, screening a main network station name or a feeder line name of a distribution network in a main network breaker table or a distribution network switch table, which is recorded in accordance with the tripping switch, as a power failure line;
screening the equipment id in the record consistent with the power failure number in the DA path coloring information table according to the power failure number, screening the distribution transformer name in the record consistent with the equipment id in the distribution network transformer table according to the equipment id, and taking the distribution transformer name as an influence distribution transformer;
screening the fault tripping occurrence time dtime in the id domain according to the tripping switch in the fault tripping switch information table, which is consistent with the tripping switch, and taking the fault tripping occurrence time dtime as the fault tripping time;
Screening cb_id in records consistent with the tripping switch in the fault tripping switch information table according to the tripping switch, matching the cb_id with a distribution network switch table, and obtaining a switch name as a fault tripping switch;
screening action_id in records consistent with the cb_id in the fault tripping switch information table according to the cb_id, screening distribution transformer equipment information corresponding to the same id domain in the fault tripping area information table according to the action_id, and taking the distribution transformer equipment as fault tripping influence distribution transformer;
screening the reclose_state information in the record consistent with the cb_id in the fault tripping switch information table according to the cb_id, and taking the reclose_state as a reclosing state;
the method for displaying the results by on-line downflow and rush repair comprises the following steps:
acquiring data information of fault identification, fault tripping switch and fault occurrence time from a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure recovery number, a tripping switch and fault judging time;
according to the tripping switch, screening a main network station name or a feeder line name of a distribution network in a main network breaker table or a distribution network switch table, which is recorded in accordance with the tripping switch, as a feeder line;
screening the equipment id in the record consistent with the power failure number in the DA path coloring information table according to the power failure number, screening the distribution transformer name in the record consistent with the equipment id in the distribution network transformer table according to the equipment id, and taking the distribution transformer name as an influence distribution transformer;
According to the lines affected by the overhaul list, carrying out matching analysis on the lines and the power failure and restoration research judgment event, and judging whether the overhaul starting time in the power failure and restoration research judgment event is matched with the overhaul affecting range;
and (3) enabling the maintenance starting time of the power failure and power failure judging event to be: t is t 1 ，t 1 Taking the power failure occurrence time of the power failure recovery study judgment, and the power failure recovery time of the power failure recovery study judgment: t (T) 1 ，T 1 Take approval of power failure start time, if T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a If the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification;
if the number of the distribution transformers affected by power failure in the maintenance corresponding power outage restoration research judgment event/the number of the distribution transformers affected by fault research judgment in the maintenance plan are multiplied by 100 percent not less than N percent, and N is a maintenance duty ratio threshold, the maintenance influence range accords with the maintenance list specification;
when the overhaul starting time and the overhaul influencing range are matched, the field of the "whether to match the planned overhaul list" is filled with "yes", otherwise, the field of the "no" is filled with;
matching the power failure start time of the power failure recovery research judgment event with the fault tripping information, and matching the power failure start time of the power failure recovery research judgment event with the power failure influence range;
the number of the fault grinding and judging influencing distribution transformer/the number of the fault tripping influencing the distribution number of the line is multiplied by 100 percent not less than M in the power failure recovery grinding and judging event, M is a fault duty ratio threshold value, and the power failure influencing range accords with the fault tripping standard;
When the power failure starting time and the power failure influence range are matched, the field of the 'whether the power failure is matched with the fault tripping' is filled with 'yes', otherwise, the field of the 'no' is filled with 'no'.
2. The planned outage specification verification method according to claim 1, wherein: the power failure influence distribution transformer displays a detailed word on a display interface, and by clicking the detailed word, another bullet window displays all distribution transformer names in the power failure influence distribution transformer; and the fault research judgment influence distribution transformer displays a detailed character on the display interface, and the other bullet window displays the names of all distribution transformer devices in the fault research judgment influence distribution transformer by clicking the detailed character.
3. The planned outage specification verification method according to claim 1, wherein: the influence distribution transformer displays a detailed word on the display interface, and by clicking the detailed word, the other popup window displays all distribution transformer names in the influence distribution transformer.
4. The planned outage specification verification method according to claim 1, wherein: the influence distribution transformer displays a detailed word on a display interface, and by clicking the detailed word, a further popup window displays all distribution transformer names in the influence distribution transformer; the fault tripping influence distribution transformer displays a detailed word on a display interface, and by clicking the detailed word, another bullet window displays all distribution transformer names in the fault tripping influence distribution transformer.
5. A planned outage specification verifying attachment, its characterized in that: the method comprises the following steps:
the power outage and repair plan module is matched with different database table information, performs data extraction and information analysis and is used for acquiring the display results of the power outage and repair plan according to the basic information of the repair list;
the overhaul list standardization checking module is matched with the table information of different databases, performs data extraction and information analysis and is used for acquiring the display result of overhaul list standardization checking according to the basic information of the overhaul list;
the power failure and recovery module is matched with different database table information, performs data extraction and information analysis and is used for acquiring display results of power failure and recovery according to the basic information of power failure and recovery;
the online downflow and first-aid repair module is matched with the table information of different databases to perform data extraction and information analysis and is used for acquiring the display results of online downflow and first-aid repair according to the basic information of power failure;
the method for obtaining the display results of the outage and repair plan comprises the following steps:
acquiring the number, the maintenance content, the start time and the end time of the power outage of the maintenance list from a maintenance list basic information table;
Matching the affected distribution network lines corresponding to the same maintenance list number in the power failure area equipment information table according to the maintenance list number, and listing the affected line names in a character string form;
matching the equipment ID with the distribution network transformer table according to the equipment ID and the equipment station set of the same maintenance number in the equipment information table of the power outage area, and obtaining the name of the distribution network transformer as the power outage influence distribution transformer;
matching the approved power outage starting time and the approved power outage ending time with the fault occurrence time of the DA fault diagnosis and isolation information table or the DA fault diagnosis and isolation history table, and screening records of the fault occurrence time in the range of the approved power outage starting time and the approved power outage ending time; matching the fault tripping switch in the screened record with the overhaul content, screening the record with the consistent fault tripping switch, and selecting the id number of the fault identifier in the record as a stop-and-repeat electricity research judgment number;
acquiring a trip switch in a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table according to the id number of the fault identifier, matching a distribution network switch table according to the id information of the trip switch to obtain feeder line id information corresponding to the trip switch id information, and matching a distribution network feeder table according to the feeder line id information to obtain a feeder line name as a distribution network line;
According to the id number of the fault identification, acquiring a DA fault diagnosis and isolation information table or a fault time domain in the DA fault diagnosis and isolation history table as power failure occurrence time for power failure recovery study judgment;
screening a device id set of the same fault identification id in the DA path coloring information table according to the fault identification id, matching the device id with the distribution network transformer table, and obtaining the name of the distribution network transformer as a fault research judgment influence distribution transformer;
the method for acquiring the display result of the overhaul list standardization check comprises the following steps:
obtaining data information of an overhaul sheet number, an overhaul sheet type, overhaul contents, power failure application starting time, work application ending time, power supply application recovery time, work execution starting time, work execution ending time, power failure execution starting time and power supply recovery execution time from an overhaul sheet basic information table;
matching the equipment ID and the equipment station set of the same service list number in the equipment information table of the power failure area according to the service list number, matching the equipment ID with a distribution network transformer table, and taking the obtained distribution network transformer name as an influence distribution transformer;
according to the lines affected by the overhaul list, carrying out matching analysis on the lines and the power failure and restoration research judgment event, and judging whether the overhaul starting time in the power failure and restoration research judgment event is matched with the overhaul affecting range;
And (3) enabling the maintenance starting time of the power failure and power failure judging event to be: t is t 1 ，t 1 Taking the power failure occurrence time of the power failure recovery study judgment, and the power failure recovery time of the power failure recovery study judgment: t (T) 1 ，T 1 Take approval of power failure start time, if T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a If the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification;
if the number of the distribution transformers is influenced by the power failure of the maintenance corresponding to the power failure recovery analysis event/the number of the distribution transformers is multiplied by 100 percent not less than N which is the maintenance duty ratio threshold value in the maintenance plan, the maintenance influence range accords with the maintenance list specification;
when the overhaul starting time and the overhaul influence range are matched, filling in the "yes" field which is in accordance with the specification "or else filling in the" no ";
the method for obtaining the display results of the power failure and the power outage comprises the following steps:
acquiring data information of fault identification, fault tripping switch and fault occurrence time from a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure number, a tripping switch and a power failure time;
according to the tripping switch, screening a main network station name or a feeder line name of a distribution network in a main network breaker table or a distribution network switch table, which is recorded in accordance with the tripping switch, as a power failure line;
Screening the equipment id in the record consistent with the power failure number in the DA path coloring information table according to the power failure number, screening the distribution transformer name in the record consistent with the equipment id in the distribution network transformer table according to the equipment id, and taking the distribution transformer name as an influence distribution transformer;
screening the fault tripping occurrence time dtime in the id domain according to the tripping switch in the fault tripping switch information table, which is consistent with the tripping switch, and taking the fault tripping occurrence time dtime as the fault tripping time;
screening cb_id in records consistent with the tripping switch in the fault tripping switch information table according to the tripping switch, matching the cb_id with a distribution network switch table, and obtaining a switch name as a fault tripping switch;
screening action_id in records consistent with the cb_id in the fault tripping switch information table according to the cb_id, screening distribution transformer equipment information corresponding to the same id domain in the fault tripping area information table according to the action_id, and taking the distribution transformer equipment as fault tripping influence distribution transformer;
screening the reclose_state information in the record consistent with the cb_id in the fault tripping switch information table according to the cb_id, and taking the reclose_state as a reclosing state;
the method for displaying the results by on-line downflow and rush repair comprises the following steps:
Acquiring data information of fault identification, fault tripping switch and fault occurrence time from a DA fault diagnosis and isolation information table or a DA fault diagnosis and isolation history table, wherein the data information is respectively used as data information of a power failure recovery number, a tripping switch and fault judging time;
according to the tripping switch, screening a main network station name or a feeder line name of a distribution network in a main network breaker table or a distribution network switch table, which is recorded in accordance with the tripping switch, as a feeder line;
screening the equipment id in the record consistent with the power failure number in the DA path coloring information table according to the power failure number, screening the distribution transformer name in the record consistent with the equipment id in the distribution network transformer table according to the equipment id, and taking the distribution transformer name as an influence distribution transformer;
according to the lines affected by the overhaul list, carrying out matching analysis on the lines and the power failure and restoration research judgment event, and judging whether the overhaul starting time in the power failure and restoration research judgment event is matched with the overhaul affecting range;
and (3) enabling the maintenance starting time of the power failure and power failure judging event to be: t is t 1 ，t 1 Taking the power failure occurrence time of the power failure recovery study judgment, and the power failure recovery time of the power failure recovery study judgment: t (T) 1 ，T 1 Take approval of power failure start time, if T is satisfied 1 ≤t 1 ≤(T 1 +T a )，T a If the first time threshold value is the first time threshold value, the overhaul starting time accords with the overhaul list specification;
If the number of the distribution transformers affected by power failure in the maintenance corresponding power outage restoration research judgment event/the number of the distribution transformers affected by fault research judgment in the maintenance plan are multiplied by 100 percent not less than N percent, and N is a maintenance duty ratio threshold, the maintenance influence range accords with the maintenance list specification;
when the overhaul starting time and the overhaul influencing range are matched, the field of the "whether to match the planned overhaul list" is filled with "yes", otherwise, the field of the "no" is filled with;
matching the power failure start time of the power failure recovery research judgment event with the fault tripping information, and matching the power failure start time of the power failure recovery research judgment event with the power failure influence range;
the number of the fault grinding and judging influencing distribution transformer/the number of the fault tripping influencing the distribution number of the line is multiplied by 100 percent not less than M in the power failure recovery grinding and judging event, M is a fault duty ratio threshold value, and the power failure influencing range accords with the fault tripping standard;
when the power failure starting time and the power failure influence range are matched, the field of the 'whether the power failure is matched with the fault tripping' is filled with 'yes', otherwise, the field of the 'no' is filled with 'no'.
CN202110883880.1A 2021-08-02 2021-08-02 Planned power outage specification verification method and device Active CN113672647B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110883880.1A CN113672647B (en) 2021-08-02 2021-08-02 Planned power outage specification verification method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110883880.1A CN113672647B (en) 2021-08-02 2021-08-02 Planned power outage specification verification method and device

Publications (2)

Publication Number Publication Date
CN113672647A CN113672647A (en) 2021-11-19
CN113672647B true CN113672647B (en) 2023-10-31

Family

ID=78541498

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110883880.1A Active CN113672647B (en) 2021-08-02 2021-08-02 Planned power outage specification verification method and device

Country Status (1)

Country Link
CN (1) CN113672647B (en)

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE102008062630A1 (en) * 2008-12-17 2010-06-24 Airbus Deutschland Gmbh Method for scheduling maintenance operations of systems
CN202013408U (en) * 2011-04-15 2011-10-19 广东电网公司电力科学研究院 On-line monitoring system of breaker
CN104638764A (en) * 2015-01-22 2015-05-20 国家电网公司 Intelligent state diagnosis and overhauling system for power distribution network equipment
CN106992520A (en) * 2017-05-25 2017-07-28 国网福建省电力有限公司 Power distribution network based on multi-source data stops monitoring method of sending a telegram in reply
CN107846011A (en) * 2017-07-17 2018-03-27 中国南方电网有限责任公司 A kind of distribution network failure restoration methods based on main distribution Collaborative Control
CN110929900A (en) * 2019-12-17 2020-03-27 南京理工大学 Intelligent maintenance management system and method for power grid
CN111311129A (en) * 2020-03-31 2020-06-19 广东电网有限责任公司 Automatic work distribution method, system and computer equipment for power distribution network on-duty task allocation
CN112487119A (en) * 2020-11-30 2021-03-12 深圳供电局有限公司 Power failure early warning signal verification method and system

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102611086B (en) * 2012-03-27 2015-01-07 许继电气股份有限公司 Centralized protection system and method for region distribution network
DE102016122315A1 (en) * 2015-12-10 2017-06-14 General Electric Company System and method for fault diagnosis in an emissions control system

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE102008062630A1 (en) * 2008-12-17 2010-06-24 Airbus Deutschland Gmbh Method for scheduling maintenance operations of systems
CN202013408U (en) * 2011-04-15 2011-10-19 广东电网公司电力科学研究院 On-line monitoring system of breaker
CN104638764A (en) * 2015-01-22 2015-05-20 国家电网公司 Intelligent state diagnosis and overhauling system for power distribution network equipment
CN106992520A (en) * 2017-05-25 2017-07-28 国网福建省电力有限公司 Power distribution network based on multi-source data stops monitoring method of sending a telegram in reply
CN107846011A (en) * 2017-07-17 2018-03-27 中国南方电网有限责任公司 A kind of distribution network failure restoration methods based on main distribution Collaborative Control
CN110929900A (en) * 2019-12-17 2020-03-27 南京理工大学 Intelligent maintenance management system and method for power grid
CN111311129A (en) * 2020-03-31 2020-06-19 广东电网有限责任公司 Automatic work distribution method, system and computer equipment for power distribution network on-duty task allocation
CN112487119A (en) * 2020-11-30 2021-03-12 深圳供电局有限公司 Power failure early warning signal verification method and system

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
Condition Monitoring and Fault Diagnosis of Induction Motors: A Review;Anurag Choudhary等;《SpringerLink》;第1221-1238页 *
基于OPEN-3000配网管理系统的配网可靠性统计;苏标龙等;《电网技术》(第S2期);第561-566页 *
基于系统互联的检修计划停电用户分析应用研究;冯秋侠等;《电工电气》;第263卷(第11期);第64-67页 *

Also Published As

Publication number Publication date
CN113672647A (en) 2021-11-19

Similar Documents

Publication Publication Date Title
CN110336375B (en) Processing method and system for power grid monitoring alarm information
CN102930365B (en) A kind of relay protection statistical analysis and the check method of operational management data
CN107844880A (en) A kind of electric network fault grade automatic identifying method based on multisource data fusion
CN106815373B (en) Distribution network first-aid repair big data display method and system based on BI analysis
CN110879327B (en) 10KV line monitoring method by multi-data fusion
CN104463696A (en) Power grid operating risk recognition and prevention method and system
CN106651643A (en) Power security management and control method for whole process based on distribution and adjustment
CN110210630A (en) A kind of power distribution network active emergency repair method based on multiple faults information source and study and judge system
CN108629526A (en) A kind of accident presentation method based on automation system for the power network dispatching
CN110956282A (en) Power distribution automation defect management system and method
CN116743079A (en) Photovoltaic string fault processing method and device, photovoltaic management system and medium
CN111861186A (en) Method for detecting power grid risk event and acquiring power failure equipment
CN114529166A (en) Power distribution network operation safety risk early warning method and system
CN113672647B (en) Planned power outage specification verification method and device
CN112785109A (en) Power grid equipment fault analysis method and system based on regulation cloud
CN110738427A (en) electric power part work quality scoring system
CN112446619B (en) Power distribution network rush-repair processing method and device
CN113364131B (en) Equipped patrol system based on secondary equipment intelligent management and control platform
CN112821566B (en) Intelligent statistical method and device for remote control intervention processing of distribution network faults
CN113472068A (en) Island microgrid remote operation and maintenance method, system and storage medium
Yunguang et al. Research on secondary circuit identification technology and condition-based maintenance mode of intelligent substation
Ruiz Flores ADMS technology: The challenges of modeling to operating electrical systems with digital twins
Koval et al. Assessment of transmission-line common-mode, station-originated, and fault-type forced-outage rates
Burt et al. Intelligent on-line decision support for distribution system control and operation
CN106709158B (en) Performance improvement method of power grid feeder automation system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant