A method and device for compiling a super-planned power consumption power reduction line reconstruction table

Abstract

The application discloses a kind of super plan power consumption power limiting line reconstruction table compiling method and device, method includes: to non-automated switch data, power grid asset line conductor data and only limit not contain key word transformer switch data are intersection processing, obtain the switch data needing automation reconstruction;Transformer data and its corresponding equipment topological relation information are obtained from target database pool, combined with power grid asset line conductor data and only limit not contain key word line conductor data, obtain the line data needing reconstruction of the distribution network region to be analyzed;Super plan power consumption power limiting line reconstruction table is obtained by gathering line data needing reconstruction and switch data needing automation reconstruction.Thereby, in the case that transformer with preset key word is not connected into super plan power consumption power limiting line reconstruction table by identifying result, super plan power consumption power limiting line reconstruction table is automatically compiled.

Description

Technical Field

[0001] This invention relates to the field of orderly power consumption technology, and in particular to a method and apparatus for compiling a table of over-planned power consumption and power restriction line modification. Background Technology

[0002] Orderly electricity use refers to the management of controlling electricity demand from users on the demand side through administrative measures, economic means, and technical methods in situations such as insufficient power supply or sudden accidents (events), with the premise of ensuring the safety of the power grid and maintaining a stable and orderly power supply and consumption order. The implementation of orderly electricity use should strictly adhere to the basic principles of "four guarantees" (guaranteeing people's livelihood, guaranteeing public services, guaranteeing social stability, and guaranteeing power grid safety).

[0003] As an important part of orderly electricity use, the power supply department will prepare a plan for the transformation of power rationing lines for over-planned electricity use in advance and transform the lines for over-planned electricity use in order to achieve the power rationing target more efficiently during over-planned electricity use, thereby realizing orderly electricity use.

[0004] The existing method for compiling the over-planned power consumption and rationing line modification schedule involves manual multi-disciplinary system queries and statistics, analyzing whether the lines include "four-guarantee" users, and then compiling modification plans for lines containing "four-guarantee" users. Clearly, the existing method suffers from drawbacks such as low efficiency and susceptibility to errors, and cannot meet the needs of business operations. Summary of the Invention

[0005] This invention provides a method and apparatus for compiling a table of over-planned power consumption and power rationing line modifications. The table is automatically compiled when transformers with preset keywords are excluded from the table based on the identification results.

[0006] In a first aspect, the present invention provides a method for compiling a table of power rationing lines subject to over-planned power consumption, comprising:

[0007] The graphical model data of the distribution network area to be analyzed is parsed to obtain the corresponding graphical model parameters; the graphical model data is obtained from a preset equipment center; the graphical model parameters are used to construct the target database.

[0008] The transformer information of all transformers is obtained from the power data system, and all the transformers are identified by combining them with preset keywords to obtain the identification results and target transformer data; the identification results are the basis for generating the target transformer data.

[0009] The communication IP information of the circuit breaker and the ownership information of the line conductor are obtained from the target database to determine the non-automatic switch data and the line conductor data of the power grid assets;

[0010] Equipment topology information is obtained from the target database, and transformer switch data and transformer line conductor data are generated by combining the target transformer data.

[0011] Based on the transformer switch data and the transformer line conductor data, it is determined that only transformer switch data without keywords is restricted, and only line conductor data without keywords is restricted.

[0012] The intersection of the non-automated switch data, the power grid asset line conductor data, and the transformer switch data that only restricts the keywords is processed to obtain the switch data that needs to be automated.

[0013] The transformer data and its corresponding equipment topology information are obtained from the target database. Combined with the power grid asset line conductor data and the line conductor data that only restricts and does not contain keywords, the data of the lines that need to be upgraded in the distribution network area to be analyzed is obtained. The table of upgraded lines for over-planned power consumption and power curtailment is obtained by aggregating the data of the lines that need to be upgraded and the data of the switches that need to be automated.

[0014] Optionally, the transformer information includes: user information and metering point information; the preset keywords include: preset user information keywords and preset metering point information keywords; the target transformer data includes: target data containing keywords and target data without keywords; the transformer information of all transformers is obtained from the power data system, and all the transformers are identified by combining the preset keywords to obtain the identification results and target transformer data, including:

[0015] Crawl all user information and metering point information of the transformers from the power data system;

[0016] The identification result is obtained by sequentially detecting whether the user information of the transformer contains the preset user information keyword and whether the metering point information of the transformer contains the preset metering point information keyword.

[0017] Based on the identification results, target data containing keywords and target data without keywords are generated.

[0018] Optionally, the communication IP information of the circuit breaker and the ownership information of the line conductor are obtained from the target database to determine non-automatic switch data and power grid asset line conductor data, including:

[0019] Circuit breakers without communication IP information are sequentially added to the initial non-automatic switch list to obtain the non-automatic switch data;

[0020] Based on the owner information of the line conductors, the asset attributes of all the line conductors are determined, and the power grid asset line conductor data is determined based on the asset attributes.

[0021] Optionally, the transformer switch data includes: a set of switch data restricting those containing keywords and a total set of transformer switch data restricting all switches; the transformer line conductor data includes: a set of conductor data restricting those containing keywords and a total set of transformer line conductor data restricting all conductors; equipment topology information is obtained from the target database, and combined with the target transformer data to generate transformer switch data and transformer line conductor data, including:

[0022] Based on the device topology information, and combined with the user ID containing the keyword target data and the user ID not containing the keyword target data, the topology information of the transformer device containing the keyword and the topology information of the transformer device not containing the keyword are determined respectively; the topology information of the transformer device containing the keyword is used to determine the switch information and line conductor information of the transformer device containing the keyword; the topology information of the transformer device not containing the keyword is used to determine the switch information and line conductor information of the transformer device not containing the keyword.

[0023] The switch information and line conductor information of the transformer equipment topology information containing keywords are collected respectively to obtain a restricted switch data set and a restricted line conductor data set containing keywords.

[0024] By combining the switch information of the transformer equipment topology information containing keywords and the switch information of the transformer equipment topology information without keywords, a total set of restricted transformer switch data is obtained.

[0025] By combining the line conductor information of the transformer equipment topology information containing keywords and the switch information of the transformer equipment topology information without keywords, a total set of restricted transformer line conductor data is obtained.

[0026] Optionally, based on the transformer switch data and the transformer line conductor data, it is determined to restrict only transformer switch data without keywords and only line conductor data without keywords, including:

[0027] Extract the difference between the restricted switch data set containing keywords and the restricted transformer switch data set to obtain the restricted transformer switch data without keywords.

[0028] Extract the difference between the restricted conductor data set containing keywords and the restricted transformer conductor data set to obtain the restricted conductor data without keywords.

[0029] Optionally, the transformer data and its corresponding equipment topology information are obtained from the target database. Combined with the power grid asset line conductor data and the line conductor data that only excludes keywords, the data of the lines requiring modification in the distribution network area to be analyzed is obtained, including:

[0030] By collecting the switch information of the transformer equipment topology information that does not contain keywords, a restricted switch data set without keywords is obtained;

[0031] Identify the intersection of the restricted switch data set without keywords and the restricted switch data set with keywords to obtain switch data that simultaneously restricts both keywords and non-keywords.

[0032] Filter out the target line conductors that belong to the data that only restricts line conductors without keywords from the power grid asset line conductor data;

[0033] Based on the device topology information, it is determined whether the target line conductor is controlled by the switches in the simultaneous restriction switch data containing and without keywords; if so, the power grid asset line conductor is defined as a line requiring modification; the data of lines requiring modification is obtained by aggregating all the lines requiring modification.

[0034] Optionally, the graphical model data includes: connection point model data and equipment model data; the graphical model parameters include: equipment parameters and connection parameters; parsing the graphical model file of the distribution network data to be analyzed yields the corresponding graphical model file parameters, including:

[0035] Export the CIM file from the drawing file according to the preset CIM export rules;

[0036] The CIM file is parsed using a pre-set CIM structural model to obtain the equipment parameters corresponding to the equipment model data and the connection parameters corresponding to the connection point model data.

[0037] The target database is constructed using the CIM file, the device parameters, and the connection point parameters.

[0038] Secondly, the present invention also provides a device for compiling a table of over-planned power consumption and power restriction line modification, comprising:

[0039] The parsing module is used to parse the graphical model data of the distribution network area to be analyzed to obtain the corresponding graphical model parameters; the graphical model data is obtained from a preset equipment center; the graphical model parameters are used to construct the target database.

[0040] The identification module is used to obtain transformer information of all transformers from the power data system, identify all the transformers by combining them with preset keywords, and obtain identification results and target transformer data; the identification results are the basis for generating target transformer data.

[0041] The information acquisition module is used to acquire the communication IP information of the circuit breaker and the owner information of the line conductor from the target database in order to determine the non-automatic switch data and the power grid asset line conductor data;

[0042] The transformer switch data generation module is used to obtain equipment topology relationship information from the target database, and combine it with the target transformer data to generate transformer switch data and transformer line conductor data;

[0043] The restricted data acquisition module is used to determine, based on the transformer switch data and the transformer line conductor data, to restrict only transformer switch data without keywords and to restrict only line conductor data without keywords.

[0044] The intersection processing module is used to perform intersection processing on the non-automated switch data, the power grid asset line conductor data, and the transformer switch data that only restricts the keywords to obtain the switch data that needs to be automated.

[0045] The modification table determination module is used to obtain the transformer data and its corresponding equipment topology information from the target database, and combine it with the power grid asset line conductor data and the line conductor data that only restricts and does not contain keywords to obtain the line data that needs to be modified in the distribution network area to be analyzed; the over-planned power consumption and power curtailment line modification table is obtained by aggregating the line data that needs to be modified and the switch data that needs to be automated.

[0046] A third aspect of this application provides an electronic device, the device including a processor and a memory;

[0047] The memory is used to store program code and transmit the program code to the processor;

[0048] The processor is used to execute the method for compiling the over-planned power consumption and power restriction line modification table as described in the first aspect, according to the instructions in the program code.

[0049] The fourth aspect of this application provides a computer-readable storage medium for storing program code for executing the method for compiling the over-planned power consumption and power restriction line modification table as described in the first aspect.

[0050] As can be seen from the above technical solutions, the present invention has the following advantages:

[0051] This invention obtains corresponding model parameters by parsing the model data of the distribution network area to be analyzed; the model data is obtained from a preset equipment center; the model parameters are used to construct a target database; transformer information of all transformers is obtained from the power data system, and all transformers are identified by combining preset keywords to obtain identification results and target transformer data; the identification results are the basis for generating target transformer data; the communication IP information of circuit breakers and the owner information of line conductors are obtained from the target database to determine non-automatic switch data and power grid asset line conductor data; Equipment topology information is obtained from the target database. Combined with the target transformer data, transformer switch data and transformer line conductor data are generated. Based on the transformer switch data and the transformer line conductor data, data restricting only those without keywords (e.g., transformer switch data and line conductor data) are determined. The intersection of the non-automated switch data, the power grid asset line conductor data, and the data restricting only those without keywords is processed to obtain switch data requiring automation upgrades. The transformer data and its corresponding equipment topology information are obtained from the target database. Combined with the power grid asset line conductor data and the data restricting only those without keywords, the data of lines requiring upgrades for the distribution network area to be analyzed is obtained. The over-planned power consumption and curtailment line upgrade table is obtained by aggregating the upgrade line data and the automation upgrade switch data. The over-planned power consumption and curtailment line upgrade table is automatically compiled when transformers with preset keywords are excluded from the over-planned power consumption and curtailment line upgrade table based on the identification results. Attached Figure Description

[0052] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0053] Figure 1 This is a flowchart illustrating the steps of a method for compiling a power rationing line modification table according to an embodiment of the present invention.

[0054] Figure 2 This is a flowchart illustrating the steps of a second embodiment of the method for compiling a power restriction line modification table for over-planned power consumption according to the present invention.

[0055] Figure 3 This is a structural block diagram of an embodiment of a device for compiling a power rationing and over-limit electricity line modification table according to the present invention. Detailed Implementation

[0056] This invention provides a method and apparatus for compiling a table of over-planned power consumption and power rationing line modifications. The table is automatically compiled when transformers with preset keywords are excluded from the table based on the identification results.

[0057] To make the objectives, features, and advantages of this invention more apparent and understandable, the technical solutions of the embodiments of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described below are only some embodiments of this invention, and not all embodiments. Based on the embodiments of this invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this invention.

[0058] Please see Figure 1 , Figure 1 This is a flowchart illustrating the steps of a method for compiling a power rationing line modification table according to an embodiment of the present invention. Specifically, it may include the following steps:

[0059] Step S101: Parse the graphic model data of the distribution network area to be analyzed to obtain the corresponding graphic model parameters; the graphic model data is obtained from a preset equipment center; the graphic model parameters are used to construct the target database;

[0060] In an optional embodiment, the graphical model data includes: connection point model data and equipment model data; the graphical model parameters include: equipment parameters and connection parameters; parsing the graphical model file of the distribution network data to be analyzed yields the corresponding graphical model file parameters, including:

[0061] Export the CIM file from the drawing file according to the preset CIM export rules;

[0062] The CIM file is parsed using a pre-set CIM structural model to obtain the equipment parameters corresponding to the equipment model data and the connection parameters corresponding to the connection point model data.

[0063] The target database is constructed using the CIM file, the device parameters, and the connection point parameters.

[0064] In this embodiment of the invention, GIS map data is obtained from the distribution network to be analyzed. This data includes detailed equipment information and connection topology relationships between 10kV lines. Following preset CIM export rules, a CIM file is exported from the map data. Then, a pre-made CIM structure template is used to parse the CIM file, thereby obtaining the equipment parameters corresponding to the equipment model data and the connection parameters corresponding to the connection point model data. The CIM file, equipment parameters, and connection point parameters then serve as the data foundation for establishing the target database. The target database includes various tables such as sorted transformer information tables, switch information tables, and line conductor information tables, as well as topology information of the equipment obtained after analyzing the connection relationships of various devices.

[0065] In practical implementation, the equipment parameters corresponding to the equipment model data and the connection parameters corresponding to the connection point model data, relative to the element encoding of the CIM file, include a detailed description of the element category label (transformer, cable, etc. or connection point in the drawing model) of the CIM file.

[0066] It should be noted that GIS refers to Geographic Information System, a technological system that, with the support of computer hardware and software systems, collects, stores, manages, processes, analyzes, displays, and describes geographic distribution data of the entire or part of the Earth's surface (including the atmosphere). It possesses powerful spatial information analysis and spatial topology modeling capabilities, giving it a natural advantage in power distribution network topology analysis applications.

[0067] CIM (Consumer Information Model) is a conceptual model for describing management information, based on the ICE 61970 / IEC 61968 standards. It provides standards and applications for information inheritance and interaction between management systems. Essentially, it's an implementation-independent conceptual model for describing management information. CIM consists of two parts: the CIM Specification and the CIM Schema. The CIM Specification provides the formal definition of the model, describing the language, naming conventions, meta-schema, and mapping techniques to other management models (such as SNMP MIB). The CIM Schema provides a description of the actual model. The CIM model comprises three layers: a core model, a common model, and extended models. The core model is a collection of classes, connections, and attributes that provides a basic information model common to all management domains. The common model provides a general information model for specific management domains, such as systems, applications, networks, and devices. Extended models represent specific technical extensions of the common model.

[0068] CIM modeling allows for the abstraction and representation of entities within a management domain, including their attributes, operations, and relationships. Such a model is independent of any specific database, application, protocol, or platform. Therefore, CIM models require applications from different developers on different platforms to use a standardized format to describe management data, enabling data sharing across multiple applications. CIM employs an object-oriented approach to construct a new structural and conceptual model suitable for management systems and networks. CIM modeling is a general methodology. CIM modeling for a specific management domain extends upon the core and common models.

[0069] Step S102: Obtain transformer information for all transformers from the power data system, and identify all the transformers using preset keywords to obtain identification results and target transformer data; the identification results serve as the basis for generating the target transformer data.

[0070] Step S103: Obtain the communication IP information of the circuit breaker and the owner information of the line conductor from the target database to determine the non-automatic switch data and the power grid asset line conductor data;

[0071] Step S104: Obtain device topology relationship information from the target database, and combine it with the target transformer data to generate transformer switch data and transformer line conductor data;

[0072] Step S105: Based on the transformer switch data and the transformer line conductor data, determine to restrict only transformer switch data without keywords and to restrict only line conductor data without keywords, respectively.

[0073] Step S106: Perform intersection processing on the non-automated switch data, the power grid asset line conductor data, and the transformer switch data that only restricts the keywords to obtain the switch data that needs to be automated;

[0074] Step S107: Obtain the transformer data and its corresponding equipment topology information from the target database, and combine the power grid asset line conductor data and the line conductor data that only restricts and does not contain keywords to obtain the line data that needs to be upgraded in the distribution network area to be analyzed; the over-planned power consumption and power restriction line upgrade table is obtained by collecting the line data that needs to be upgraded and the switch data that needs to be automated.

[0075] This invention provides an embodiment of the method for obtaining corresponding model parameters by parsing the model data of the distribution network area to be analyzed. The model data is obtained from a preset equipment center. The model parameters are used to construct a target database. Transformer information of all transformers is obtained from the power data system, and all transformers are identified by combining preset keywords to obtain identification results and target transformer data. The identification results are the basis for generating target transformer data. The communication IP information of circuit breakers and the owner information of line conductors are obtained from the target database to determine non-automatic switch data and power grid asset line conductor data. Equipment topology information is obtained from the target database. Combined with the target transformer data, transformer switch data and transformer line conductor data are generated. Based on the transformer switch data and the transformer line conductor data, data restricting only those without keywords (e.g., transformer switch data and line conductor data) are determined. The intersection of the non-automated switch data, the power grid asset line conductor data, and the data restricting only those without keywords is processed to obtain switch data requiring automation upgrades. The transformer data and its corresponding equipment topology information are obtained from the target database. Combined with the power grid asset line conductor data and the data restricting only those without keywords, the data of lines requiring upgrades for the distribution network area to be analyzed is obtained. The over-planned power consumption and curtailment line upgrade table is obtained by aggregating the upgrade line data and the automation upgrade switch data. The over-planned power consumption and curtailment line upgrade table is automatically compiled when transformers with preset keywords are excluded from the over-planned power consumption and curtailment line upgrade table based on the identification results.

[0076] Please see Figure 2 The flowchart below shows the steps of a second embodiment of the method for compiling a power rationing line modification table according to the present invention, specifically including:

[0077] Step S201: Parse the graphic model data of the distribution network area to be analyzed to obtain the corresponding graphic model parameters; the graphic model data is obtained from a preset equipment center; the graphic model parameters are used to construct the target database;

[0078] Step S202: Crawl user information and metering point information of all transformers from the power data system;

[0079] Step S203: Sequentially detect whether the user information of the transformer contains the preset user information keyword, and whether the metering point information of the transformer contains the preset metering point information keyword, to obtain the identification result;

[0080] Step S204: Based on the identification results, generate target data containing keywords and target data without keywords;

[0081] In this embodiment of the invention, the preset user information keywords are specifically user information "four guarantees" keywords, including electricity category keywords: "residential life", "agricultural production" and "agricultural irrigation and drainage"; customer group keywords: "residential customers", "important customers" and "key customers".

[0082] The pre-set metering point information keywords are specifically the "four guarantees" keywords for metering point information, including the electricity consumption category of the metering point: "residential life", "agricultural production" and "agricultural irrigation and drainage".

[0083] The industry classification of measurement points includes: "Electricity and heat production and supply", "Agriculture", "Railway transportation", "Forestry", "Gas production and supply", "Water conservancy, environment and public facilities management", "Residential services, repair and other services", "Water transportation", "Education, culture, sports and entertainment", "Pipeline transportation", "Agricultural, forestry, animal husbandry and fishery professional and auxiliary activities", "Health and social work", "Urban residents" and "Rural residents".

[0084] In the specific implementation, if the user information contains any of the above-mentioned "four guarantees" keywords, the transformer is marked as a "four guarantees" transformer; if the metering point information contains any of the above-mentioned "four guarantees" keywords, the transformer is marked as a "four guarantees" transformer. Compared with transformers that are not "four guarantees" transformers, they are marked as non-"four guarantees" transformers. Then, based on the marked "four guarantees" transformers and non-"four guarantees" transformers, the non-"four guarantees" transformer data containing user ID information, i.e., target data without keywords, and the "four guarantees" transformer data, i.e. target data with keywords, are determined.

[0085] Step S205: Obtain the communication IP information of the circuit breaker and the owner information of the line conductor from the target database to determine the non-automatic switch data and the power grid asset line conductor data;

[0086] Specifically, it includes:

[0087] Circuit breakers without communication IP information are sequentially added to the initial non-automatic switch list to obtain the non-automatic switch data;

[0088] Based on the owner information of the line conductors, the asset attributes of all the line conductors are determined, and the power grid asset line conductor data is determined based on the asset attributes.

[0089] In this embodiment of the invention, based on the communication IP information of the circuit breaker, it is determined from the target database whether the circuit breaker is an automated switch, thereby obtaining a list of automated switches and a list of non-automated switches; simultaneously, based on the owner information of the circuit breaker, it is determined whether the circuit breaker is a power grid asset, thereby obtaining a list of power grid asset switches and a list of user asset switches; finally, based on the owner information of the line conductor, it is determined whether the line conductor is a power grid asset, thereby obtaining a list of power grid asset line conductors and a list of user asset line conductors.

[0090] Step S206: Based on the device topology relationship information, and combined with the user ID containing the keyword target data and the user ID not containing the keyword target data, determine the topology information of the transformer device containing the keyword and the topology information of the transformer device not containing the keyword, respectively; the topology information of the transformer device containing the keyword is used to determine the switch information and line conductor information of the transformer device containing the keyword; the topology information of the transformer device not containing the keyword is used to determine the switch information and line conductor information of the transformer device not containing the keyword.

[0091] Step S207: Collect the switch information and line conductor information of the transformer equipment topology information containing keywords, respectively, to obtain the restricted switch data set and the restricted line conductor data set containing keywords;

[0092] Step S208: Collect the switch information containing the topology information of the transformer equipment with keywords and the switch information without the topology information of the transformer equipment with keywords to obtain the total set of restricted transformer switch data;

[0093] Step S209: Collect the line conductor information of the transformer equipment topology information containing keywords and the switch information of the transformer equipment topology information without keywords to obtain the total set of restricted transformer line conductor data;

[0094] It should be noted that because a single switch can control multiple "four-protection" transformers and non-"four-protection" transformers, as long as the switch controls a "four-protection" transformer, it can be included in the keyword-containing switch dataset. Therefore, a switch can exist simultaneously in both the keyword-containing switch dataset and the keyword-free switch dataset. Furthermore, the keyword-free switch dataset is the dataset of switches that control transformers without keywords.

[0095] In this embodiment of the invention, based on the device topology relationship information in the target database, according to the user IDs of non-"four-protection" transformer data and "four-protection" transformer data, the device topology information of non-"four-protection" transformers (i.e., device topology information of transformers without keywords) and the device topology relationship of "four-protection" transformers (i.e., device topology information of transformers with keywords) are obtained respectively. Then, the switch information in the non-"four-protection" transformer device topology relationship (i.e., switch information of transformers without keywords), the switch information in the "four-protection" transformer device topology relationship (i.e., switch information of transformers with keywords), the line conductor information in the non-"four-protection" transformer device topology relationship (i.e., line conductor information of transformers without keywords), and the line conductor information in the "four-protection" transformer device topology relationship (i.e., line conductor information of transformers with keywords) are determined respectively.

[0096] Then, by aggregating the switch information, i.e. line conductor information, in the topology of the "four-protection" transformer equipment, we obtain the switch data that restricts the "four-protection" transformer, i.e. the set of switch data that restricts the "four-protection" transformer, and the line conductor information that restricts the "four-protection" transformer, i.e. the set of line conductor data that restricts the "four-protection" transformer.

[0097] Next, by aggregating the switch information in the topology of the "four-protection" transformers and the switch information in the equipment topology of non-"four-protection" transformers, the total set of switch data for limiting transformers is obtained, including the switch data for limiting both "four-protection" and non-"four-protection" transformers.

[0098] Finally, by aggregating the line conductor information in the topology of "four-protection" transformers and the line conductor information in the equipment topology of non-"four-protection" transformers, we obtain the total set of line conductor data for all conductors, including the conductor data for both "four-protection" and non-"four-protection" transformers.

[0099] Step S210: Based on the transformer switch data and the transformer line conductor data, determine to restrict only transformer switch data without keywords and to restrict only line conductor data without keywords.

[0100] Specifically, it includes:

[0101] Extract the difference between the restricted switch data set containing keywords and the restricted transformer switch data set to obtain the restricted transformer switch data without keywords.

[0102] Extract the difference between the restricted conductor data set containing keywords and the restricted transformer conductor data set to obtain the restricted conductor data without keywords.

[0103] In this embodiment of the invention, the set corresponding to the switch data of the "four-protection" transformer is determined, and the difference set between the switch data of both the "four-protection" transformer and the non-"four-protection" transformer is determined, to obtain switch data that only restricts non-"four-protection" transformers, that is, only restricts switch data of transformers without keywords; the set corresponding to the line conductor data of the "four-protection" transformer is determined, and the difference set between the line conductor data of both the "four-protection" transformer and the non-"four-protection" transformer is determined, to obtain line conductor data that only restricts non-"four-protection" transformers, that is, only restricts line conductor data without keywords.

[0104] Step S211: Obtain the transformer data and its corresponding equipment topology information from the target database, and combine the power grid asset line conductor data and the line conductor data that only restricts the data without keywords to obtain the line data that needs to be upgraded in the distribution network area to be analyzed.

[0105] Specifically, it includes:

[0106] By collecting the switch information of the transformer equipment topology information that does not contain keywords, a restricted switch data set without keywords is obtained;

[0107] Identify the intersection of the restricted switch data set without keywords and the restricted switch data set with keywords to obtain switch data that simultaneously restricts both keywords and non-keywords.

[0108] Filter out the target line conductors that belong to the data that only restricts line conductors without keywords from the power grid asset line conductor data;

[0109] Based on the device topology information, it is determined whether the target line conductor is controlled by the switches in the simultaneous restriction switch data containing and without keywords; if so, the power grid asset line conductor is defined as a line requiring modification; the data of lines requiring modification is obtained by aggregating all the lines requiring modification.

[0110] In this embodiment of the invention, after determining the switch data that simultaneously restricts both those containing and not containing keywords, the conductor data of the power grid assets in the distribution area to be analyzed is identified and matched with the switch data that simultaneously restricts both those containing and not containing keywords to obtain the target conductor. Then, it is sequentially determined whether the target conductor is controlled by the switches in the switch data that simultaneously restricts both those containing and not containing keywords, thereby obtaining the lines that need to be modified. Finally, all lines that need to be modified are summarized to obtain the data of the lines that need to be modified.

[0111] Compared to the current method of manually compiling a table of over-planned power consumption and curtailment lines through multi-disciplinary system queries and statistics, this invention provides a method for compiling such a table. This method involves parsing the graphical model data of the distribution network area to be analyzed to obtain corresponding graphical model parameters. The graphical model data is obtained from a pre-set equipment center. The graphical model parameters are used to construct a target database. Transformer information for all transformers is obtained from the power data system, and all transformers are identified using pre-set keywords to obtain identification results and target transformer data. The identification results serve as the basis for generating the target transformer data. The communication IP information of circuit breakers and the owner information of line conductors are obtained from the target database to determine non-automatic switch data and power grid asset line conductor data. Equipment topology information is obtained from the target database, and transformer switch data and transformer line conductor data are generated by combining the target transformer data. Based on the transformer switch data and the transformer line conductor data, only transformer switch data without keywords and line conductor data without keywords are restricted. The intersection of the non-automated switch data, the power grid asset line conductor data, and the transformer switch data without keywords is processed to obtain the switch data that needs to be automated. The transformer data and its corresponding equipment topology information are obtained from the target database, and the power grid asset line conductor data and the line conductor data without keywords are combined to obtain the line data that needs to be modified in the distribution network area to be analyzed. The over-planned power consumption and curtailment line modification table is obtained by aggregating the line data that needs to be modified and the switch data that needs to be automated. Based on real-time field crawling and discrimination of the power data system, intelligent identification of "four-guarantee" users is realized, ensuring that "four-guarantee" users are not included in the over-planned power consumption and curtailment sequence table, with high accuracy. Data is acquired based on professional systems such as the equipment center and the power data system, and the data is effectively correlated to realize the automatic compilation of the over-planned power consumption and curtailment line modification table, which greatly reduces the workload of manual labor and improves efficiency.

[0112] Please see Figure 3 The diagram shows a structural block diagram of an embodiment of a device for compiling a table of power rationing lines for exceeding planned power consumption, including the following modules:

[0113] Parsing module 301 is used to parse the map model data of the distribution network area to be analyzed to obtain the corresponding map model parameters; the map model data is obtained from a preset equipment center; the map model parameters are used to construct a target database;

[0114] The identification module 302 is used to obtain transformer information of all transformers from the power data system, identify all the transformers by combining them with preset keywords, and obtain identification results and target transformer data; the identification results are the basis for generating target transformer data.

[0115] The information acquisition module 303 is used to acquire the communication IP information of the circuit breaker and the owner information of the line conductor from the target database in order to determine the non-automatic switch data and the power grid asset line conductor data;

[0116] The transformer switch data generation module 304 is used to obtain equipment topology relationship information from the target database and generate transformer switch data and transformer line conductor data by combining the target transformer data.

[0117] The data acquisition module 305 is used to determine, based on the transformer switch data and the transformer line conductor data, to restrict only transformer switch data without keywords and to restrict only line conductor data without keywords.

[0118] The intersection processing module 306 is used to perform intersection processing on the non-automated switch data, the power grid asset line conductor data, and the transformer switch data that only restricts the keywords to obtain the switch data that needs to be automated.

[0119] The modification table determination module 307 is used to obtain the transformer data and its corresponding equipment topology information from the target database, and combine it with the power grid asset line conductor data and the line conductor data that only restricts and does not contain keywords to obtain the line data that needs to be modified in the distribution network area to be analyzed; the over-planned power consumption and power restriction line modification table is obtained by collecting the line data that needs to be modified and the switch data that needs to be automated.

[0120] In an optional embodiment, the transformer information includes: user information and metering point information; the preset keywords include: preset user information keywords and preset metering point information keywords; the target transformer data includes: target data containing keywords and target data without keywords; the identification module 302 includes:

[0121] The crawling submodule is used to crawl all user information and metering point information of the transformers from the power data system.

[0122] The detection submodule is used to sequentially detect whether the user information of the transformer contains the preset user information keywords, and whether the metering point information of the transformer contains the preset metering point information keywords, to obtain the identification result;

[0123] The target data generation submodule is used to generate target data containing keywords and target data without keywords based on the identification results.

[0124] In an optional embodiment, the information acquisition module 303 includes:

[0125] The non-automatic switch data acquisition submodule is used to sequentially add circuit breakers without communication IP information to the initial non-automatic switch list to obtain the non-automatic switch data.

[0126] The attribute determination submodule is used to determine the asset attributes of all the line conductors based on the owner information of the line conductors, and to determine the power grid asset line conductor data based on the asset attributes.

[0127] In an optional embodiment, the transformer switch data includes: a set of switch data restricting keywords and a total set of transformer switch data restricting all switches; the transformer line conductor data includes: a set of conductor data restricting keywords and a total set of transformer line conductor data restricting all conductors; the transformer switch data generation module 304 includes:

[0128] The device topology information determination submodule is used to determine, based on the device topology relationship information and in combination with the user ID containing the keyword target data and the user ID not containing the keyword target data, the topology information of transformer devices containing keywords and the topology information of transformer devices not containing keywords, respectively. The topology information of transformer devices containing keywords is used to determine the switch information and line conductor information of the transformer devices containing keywords. The topology information of transformer devices not containing keywords is used to determine the switch information and line conductor information of the transformer devices not containing keywords.

[0129] The switch and line data generation submodule is used to collect the switch information and line conductor information of the transformer equipment topology information containing keywords, respectively, to obtain a restricted set of switch data containing keywords and a restricted set of line conductor data containing keywords.

[0130] The first aggregation submodule is used to aggregate the switch information of the transformer equipment topology information containing keywords and the switch information of the transformer equipment topology information without keywords, to obtain a total set of restricted transformer switch data.

[0131] The second aggregation submodule is used to aggregate the line conductor information of the transformer equipment topology information containing keywords and the switch information of the transformer equipment topology information without keywords, to obtain a total set of restricted transformer line conductor data.

[0132] In an optional embodiment, the restricted data acquisition module 305 includes:

[0133] The first extraction submodule is used to extract the difference between the restricted switch data set containing keywords and the restricted transformer switch data set to obtain the restricted transformer switch data without keywords.

[0134] The second extraction submodule is used to extract the difference between the restricted conductor data set containing keywords and the restricted transformer conductor data set, to obtain the restricted conductor data without keywords.

[0135] In an optional embodiment, the modification table determination module 307 includes:

[0136] The switch information collection submodule is used to collect the switch information of the transformer equipment topology information without keywords, and obtain a restricted switch data set without keywords.

[0137] Identify the intersection of the restricted switch data set without keywords and the restricted switch data set with keywords to obtain switch data that simultaneously restricts both keywords and non-keywords.

[0138] Filter out the target line conductors that belong to the data that only restricts line conductors without keywords from the power grid asset line conductor data;

[0139] Based on the device topology information, it is determined whether the target line conductor is controlled by the switches in the simultaneous restriction switch data containing and without keywords; if so, the power grid asset line conductor is defined as a line requiring modification; the data of lines requiring modification is obtained by aggregating all the lines requiring modification.

[0140] In an optional embodiment, the graph model data includes: connection point model data and device model data; the graph model parameters include: device parameters and connection parameters; the parsing module includes:

[0141] The export submodule is used to export CIM files from the drawing file according to preset CIM export rules;

[0142] The model parameter parsing submodule is used to parse the CIM file using a preset CIM structure model to obtain the equipment parameters corresponding to the equipment model data and the connection parameters corresponding to the connection point model data.

[0143] A submodule is constructed to build the target database using the CIM file, the device parameters, and the connection point parameters.

[0144] This application also provides an electronic device, which includes a processor and a memory;

[0145] The memory is used to store program code and transfer the program code to the processor;

[0146] The processor is used to execute the method for compiling the over-planned power consumption and power restriction line modification table in the above method embodiment according to the instructions in the program code.

[0147] This application also provides a computer-readable storage medium for storing program code for executing the method for compiling the over-planned power consumption and power restriction line modification table in the above method embodiments.

[0148] In the several embodiments provided in this application, it should be understood that the disclosed apparatus and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between apparatuses or units may be electrical, mechanical, or other forms.

[0149] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0150] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit.

[0151] If the integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for executing all or part of the steps of the methods described in the various embodiments of this application through a computer device (which may be a personal computer, server, or network device, etc.). The aforementioned storage medium includes: USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, optical disks, and other media capable of storing program code.

[0152] The above-described embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of this application.

Claims

1. A method for preparing a super-planning power limiting line reconstruction table, characterized in that, The method comprises the following steps: Resolving graph model data of a power distribution network area to be analyzed to obtain corresponding graph model parameters; The graph model data is obtained from a preset device center; The graph model parameters are used to construct a target database; Transformer information of all transformers is obtained from a power data system, and all the transformers are identified in combination with preset keywords to obtain identification results and target transformer data; the identification results are the basis for generating the target transformer data; Communication IP information of circuit breakers and owner information of line conductors are obtained from the target database to determine non-automated switch data and power grid asset line conductor data; Device topology relationship information is obtained from the target database, and the target transformer data is combined to generate transformer switch data and transformer line conductor data; Based on the transformer switch data and the transformer line conductor data, respectively, only limit non-keyword transformer switch data and only limit non-keyword line conductor data are determined; The non-automated switch data, the power grid asset line conductor data, and the only limit non-keyword transformer switch data are processed by intersection to obtain switch data that needs to be automated and transformed; The transformer data and its corresponding device topology relationship information are obtained from the target database, and the power grid asset line conductor data and the only limit non-keyword line conductor data are combined to obtain line data that needs to be transformed in the power distribution network area to be analyzed; The super-plan electricity consumption power line reconstruction table is obtained by collecting the line data that needs to be transformed and the switch data that needs to be automated and transformed.

2. The method of claim 1, wherein the super-planning electricity consumption and power cut line reconstruction table is prepared by, The transformer information includes user information and metering point information; the preset keywords include preset user information keywords and preset metering point information keywords; the target transformer data includes keyword-containing target data and non-keyword-containing target data; the transformer information of all transformers is obtained from the power data system, and all the transformers are identified in combination with preset keywords to obtain identification results and target transformer data, which comprises: User information and metering point information of all the transformers are crawled from the power data system; Whether the user information of the transformer contains the preset user information keywords and whether the metering point information of the transformer contains the preset metering point information keywords are detected in sequence to obtain the identification results; According to the identification results, keyword-containing target data and non-keyword-containing target data are generated.

3. The method of claim 1, wherein the super-planning electricity consumption and power cut line reconstruction table is prepared by, The communication IP information of the circuit breakers and the owner information of the line conductors are obtained from the target database to determine the non-automated switch data and the power grid asset line conductor data, which comprises: Circuit breakers without communication IP information are sequentially listed in an initial non-automated switch list to obtain the non-automated switch data; According to the asset attributes of the line conductors, the asset attributes of all the line conductors are determined, and the power grid asset line conductor data is determined according to the asset attributes.

4. The method of claim 2, wherein the super-planning electricity consumption power line reconstruction table is prepared by, The transformer switch data includes: a limited keyword-containing switch data set and a limited total transformer switch data set; the transformer line conductor data includes: a limited keyword-containing conductor data set and a limited total transformer line conductor data set; device topology relationship information is acquired from the target database, and the transformer switch data and the transformer line conductor data are generated in combination with the target transformer data, including: Based on the device topology relationship information, the keyword-containing transformer device topology information and the keyword-not-containing transformer device topology information are determined in combination with the user number of the keyword-containing target data and the user number of the keyword-not-containing target data; the keyword-containing transformer device topology information is used to determine switch information and line conductor information of the keyword-containing transformer device topology information; the keyword-not-containing transformer device topology information is used to determine switch information and line conductor information of the keyword-not-containing transformer device topology information; The switch information and the line conductor information of the keyword-containing transformer device topology information are collected respectively to obtain the limited keyword-containing switch data set and the limited keyword-containing line conductor data set; The switch information of the keyword-containing transformer device topology information and the switch information of the keyword-not-containing transformer device topology information are collected to obtain the limited total transformer switch data set; The line conductor information of the keyword-containing transformer device topology information and the switch information of the keyword-not-containing transformer device topology information are collected to obtain the limited total transformer line conductor data set.

5. The method of claim 4, wherein the super-planning electricity consumption power line reconstruction table is prepared by, Based on the transformer switch data and the transformer line conductor data respectively, the limited keyword-not-containing transformer switch data and the limited keyword-not-containing line conductor data are determined, including: The limited keyword-containing switch data set is extracted, and a difference set part of the limited total transformer switch data set is obtained to obtain the limited keyword-not-containing transformer switch data; The limited keyword-containing line conductor data set is extracted, and a difference set part of the limited total transformer line conductor data set is obtained to obtain the limited keyword-not-containing line conductor data.

6. The method of claim 5, wherein the super-planning electricity consumption power line reconstruction table is prepared by, The transformer data and the corresponding device topology relationship information are acquired from the target database, the grid asset line conductor data and the limited keyword-not-containing line conductor data are combined, and the line data to be reformed in the to-be-analyzed power distribution network region is obtained, including: The switch information of the keyword-not-containing transformer device topology information is collected to obtain the limited keyword-not-containing switch data set; An intersection of the limited keyword-not-containing switch data set and the limited keyword-containing switch data set is identified to obtain switch data containing keywords and not containing keywords at the same time; The target line conductor belonging to the limited keyword-not-containing line conductor data is screened out from the grid asset line conductor data. In combination with the device topology relationship information, it is judged whether the target line conductor is controlled by the switch in the switch data containing and not containing the keyword; if yes, the power grid asset line conductor is defined as a line to be transformed; the line to be transformed data is obtained by collecting all the lines to be transformed.

7. The method of claim 1, wherein the super-planning electricity consumption power line reconstruction table is prepared by, The graph model data includes connection point model data and device model data; the graph model parameters include device parameters and connection parameters; the graph model file of the power distribution network to be analyzed is parsed to obtain corresponding graph model file parameters, including: According to a preset CIM export rule, a CIM file is exported from the graph model file; The CIM file, the device parameters and the connection point parameters are used to construct the target database. It includes:

8. A method for preparing a super-planning power limiting line reconstruction table, characterized in that, The parsing module is used to parse the graph model data of the power distribution network region to be analyzed to obtain corresponding graph model parameters; The graph model data is obtained from a preset device center; the graph model parameters are used to construct a target database; The identification module is used to obtain transformer information of all transformers from a power data system, identify all the transformers in combination with a preset keyword, and obtain an identification result and target transformer data; the identification result is the basis for generating the target transformer data; The information acquisition module is used to obtain communication IP information of circuit breakers and owner information of line conductors from the target database to determine non-automated switch data and power grid asset line conductor data; The transformer switch data generation module is used to obtain device topology relationship information from the target database in combination with the target transformer data to generate transformer switch data and transformer line conductor data; The limit data acquisition module is used to determine only limit keyword-free transformer switch data and only limit keyword-free line conductor data based on the transformer switch data and the transformer line conductor data, respectively; The intersection processing module is used to perform intersection processing on the non-automated switch data, the power grid asset line conductor data and the only limit keyword-free transformer switch data to obtain switch data to be automatically transformed; The transformation table determination module is used to obtain the transformer data and its corresponding device topology relationship information from the target database, in combination with the power grid asset line conductor data and the only limit keyword-free line conductor data, to obtain line data to be transformed in the power distribution network region to be analyzed; The super-plan electricity limiting line transformation table is obtained by collecting the line data to be transformed and the switch data to be automatically transformed. The computer readable instructions are executed by the processor to run the method of any one of claims 1-7.

9. An electronic device, comprising: The computer program is executed by the processor to run the method of any one of claims 1-7.

10. A storage medium having stored thereon a computer program, characterized in that ​

Images