Power system panoramic net rack display method based on BPA data analysis

Abstract

The invention discloses a power system panoramic net rack display method based on BPA data analysis, and the method comprises the steps: carrying out the XML data model conversion based on a BPA data file, and carrying out the data cleaning and storage of the data; forming a station line according to the network structure data on the basis of constraint conditions of position distribution between the power stations; according to the attribute data of the equipment, obtaining the coordinate position of each piece of equipment, and further constructing a whole-line circuit structure grid topology model; establishing power flow direction mapping according to the station number and the active power, and forming a text number real-time mapping model; and splicing the data according to a set rule to respectively form complete unit, node and line data so as to complete the display of the panoramic net rack of the power system. The method has the beneficial effects that by analyzing the operation states and parameters of various equipment, lines, power supplies and other elements in the power grid, the model can generate a comprehensive power grid operation graph, abundant data analysis tools and visual charts are provided, and a scientific basis is provided for planning decision and data management.

Description

Technical Field

[0001] The present invention relates to the technical field of new energy scene construction, and in particular to a method for displaying a panoramic grid of an electric power system based on BPA data analysis. Background Art

[0002] The panoramic grid perception modeling and analysis method is a data analysis and display method proposed in response to the needs of power system operation analysis, planning decision-making, grid management and other fields under the background of the rapid development of big data and artificial intelligence technology.

[0003] As the scale and complexity of power systems continue to expand, traditional data analysis methods can no longer meet the needs of modern power systems. A panoramic grid data analysis and display model has emerged. Through the visualization of the grid, key nodes and weak links in the power grid can be intuitively identified, and the operation status of the power grid can be visualized for analysis. However, the generation of planning scheme grids is often done manually, which takes a lot of time and effort, and has problems such as low efficiency, difficulty in updating, and poor data consistency. Secondly, the planning analysis platform and the business production system data are not interactive, and there is a data gap between the two. Combining the BPA data commonly used in planning business work to realize the automatic generation of the grid can not only greatly reduce the time of manual drawing and improve work efficiency, but also ensure the consistency of the grid diagram with the actual power grid operation data. The dynamic display and intelligent analysis functions provided make the power grid planning more accurate and efficient. Summary of the invention

[0004] The purpose of the present invention is to overcome the deficiencies of the above-mentioned prior art and provide a method for displaying a panoramic grid of a power system based on BPA data analysis. The method aims to solve the deficiencies of the prior art and is specifically implemented by the following technical solutions:

[0005] The method for displaying a panoramic grid of a power system based on BPA data analysis includes:

[0006] Based on the BPA data file, perform XML data model conversion and store the data in the ORACLE database after data cleaning;

[0007] Obtain network structure data including line association relationship ID, the first and last names of power stations, the first and last voltage levels of power stations, and the number of line loops of power stations from the ORACLE database, and form site lines based on the constraints of the location distribution between power stations according to the network structure data; obtain device attribute data including the coordinate data of each device from the ORACLE database, and obtain the two-dimensional coordinate position of each device through processing and calculation according to the device attribute data; construct a grid topology model of the entire line structure according to the two-dimensional coordinate position of the site line and each device;

[0008] Based on the grid topology model of the entire line structure, a power flow direction mapping is established according to the site number and active power to form a real-time text-mathematical mapping model; based on the real-time text-mathematical mapping model, the data in the ORACLE database are spliced ​​through the SUBSTRM function according to the set rules to form complete unit, node, and line data, completing the display of the panoramic grid of the power system.

[0009] A further design of the method for displaying the panoramic grid of the power system based on BPA data analysis is that the data in the ORACLE database includes network structure data, node attribute data and equipment attribute data.

[0010] A further design of the method for displaying the panoramic grid of the power system based on BPA data analysis is that the constraint condition for the location distribution between power stations is: if the names of the beginning and end of the station are the same, the voltage level is the same, and the number of line loops is the same, then the power stations form a complete line.

[0011] The further design of the power system panoramic grid display method based on BPA data analysis is to calculate the coefficient offset of the coordinate data in the device attribute data of each device to obtain the two-dimensional coordinate system coordinate values ​​X and Y corresponding to the longitude and latitude, and obtain the two-dimensional coordinate position of each device according to the two-dimensional coordinate system coordinate values ​​X and Y, specifically:

[0012]

[0013] Wherein, latitude represents the X-axis longitude value of the device obtained from the BPA data conversion model, longitude represents the Y-axis latitude value of the device obtained from the BPA data conversion model, R represents the radius of the earth, x represents the specific X-axis coordinate coefficient converted from the X-axis coordinate coefficient of the device obtained from the BPA data conversion model, and y represents the specific Y-axis coordinate coefficient converted from the Y-axis coordinate coefficient of the device obtained from the BPA data conversion model.

[0014] The further design of the method for displaying the panoramic grid of the power system based on BPA data analysis is that the set rules include:

[0015] U 机组 =U CARD_TYPE +U CARD_NAME +U CARD_VOLT +U UNIT_NAME +U PART

[0016] +U CONST_ACTIVE_LOAD +U CONST_REACTIVE_LOAD

[0017] +U PARALLEL_ACTIVE_LOAD +U PARALLEL_REACTIVE_LOAD

[0018] +U MAX_ACTIVE_OUTPUT +U REAL_ACTIVE_OUTPUT

[0019] +U MAX_REACTIVE_OUTPUT, +U MIN_REACTIVE_OUTPUT +U VMAX +U VMIN

[0020] +U FACTORY

[0021] In the above formula, U CARD_TYPE Represents the card type, U CARD_NAME Represents the card name, U CARD_VOLT Represents the card voltage, U UNIT_NAME Represents the unit splicing name, U PART Represents the partition, U CONST_ACTIVE_LOAD Represents constant active load, U CONST_REACTIVE_LOAD Represents a constant reactive load, U PARALLEL_ACTIVE_LOAD Represents the parallel admittance active load, U PARALLEL_REACTIVE_LOAD Represents the parallel admittance reactive load, U MAX_ACTIVE_OUTPUT Represents the maximum active output, U REAL_ACTIVE_OUTPUT Represents the measured active output, U MAX_REACTIVE_OUTPUT, Represents the arranged reactive power output value, U MIN_REACTIVE_OUTPUT Represents the minimum reactive power output value, U VMAX Represents the highest voltage arrangement, U VMIN Represents the lowest voltage of the arrangement, U FACTORY Represents power factor; U 机组 Indicates the unit card information.

[0022] According to the above formula, the SUBSTRM function is used to splice and supplement a complete unit data;

[0023] N 节点 =N card_type +N card_name +N card_volt

[0024] +N node_volt +N node_name +N part

[0025] In the above formula, N card_type Represents the card type, N card_name Represents the card name, N card_volt Represents the card voltage, N node_volt Represents the node voltage, N node_name Represents the node splicing name, NL part Represents node partition; N 节点 Represents node card information;

[0026] According to the above formula, the SUBSTRM function is used to splice and supplement it into a complete node data.

[0027] L 线路 =L card_type +L line_start_name +L line_start_volt +L card_end_name +L card_end_volt

[0028] +L part +L parallel_mark +L inductance +L capacitance +L dc_power

[0029] +L length

[0030] In the above formula, L card_type Represents the line card type, L line_start_name Represents the name of the headend node, L line_start_volt Represents the first-end node voltage, L card_end_name Represents the terminal node name, L card_end_volt represents the terminal node voltage, L part Represents the region, L parallel_mark Represents the loop symbol of the parallel circuit, L inductance Represents the per-unit value of inductance, L capacitance Represents the capacitance per unit value, L dc_power Represents DC power, L length Represents the line length, L 线路 Represents line card information; according to the above formula, it is spliced ​​and supplemented into a complete line data through the SUBSTRM function.

[0031] A further design of the method for displaying the panoramic grid of the power system based on BPA data analysis is that the flow direction mapping is specifically as follows: when the active power is positive, the flow direction in the line follows the direction of the beginning and end of the line, and the site numbers are from small to large in the positive direction of the line; conversely, when the active power is negative, the flow direction is opposite to the line direction.

[0032] A further design of the method for displaying the panoramic grid of the power system based on BPA data analysis is that the information displayed by the panoramic grid of the power system also includes: the operation status of the power grid, time series changes, the flow of active power flow and the output status of the power plant. The operation status of the power grid, time series changes, and the flow of active power flow are all displayed in the form of streamline diagrams, and the output status of the power plant is obtained through the electric field output analysis model of the simulation software.

[0033] The present invention also provides an electronic device, comprising a memory, a processor and a computer program, wherein the computer program is stored in the memory and is configured to be executed by the processor to implement the method for displaying a panoramic grid of a power system based on BPA data analysis.

[0034] The present invention also provides a computer-readable storage medium, wherein the storage medium stores a computer program, and the computer program is executed by a processor to implement the method for displaying a panoramic grid of a power system based on BPA data analysis.

[0035] The advantages of the present invention are as follows:

[0036] The method for displaying the panoramic grid of the power system based on BPA data analysis of the present invention builds a data bridge between the planning and analysis platform and the business production system, realizes the processing, processing, conversion, display and application of power grid data, improves the analysis ability of power grid planning and analysis at the grid level, helps planners to intuitively identify key nodes and weak links in the power grid, and conducts a visual analysis of the operating status of the power grid. By using the accurate data of the business production system platform and analyzing the operating status and parameters of various equipment, lines, power supplies and other elements in the power grid, each model can generate a comprehensive power grid operation map to display the overall operating status of the power grid and detailed information of each node. At the same time, the model also provides a wealth of data analysis tools and visualization charts, automatically generates a grid diagram that matches the planning scheme, dynamically displays the time-series operating status of the power grid, helps users to deeply understand the operating characteristics and potential problems of the power grid, and provides a scientific basis for planning decisions and data management.

[0037] The panoramic grid display method of the present invention combines disordered device information with page views, presents the information corresponding to the entire grid on the page, can quickly find the required information on the page, quickly generate the flow calculation file and the necessary information such as the flow direction and power plant output, simplify the cumbersome process of looking up data from tables or data sets, and integrate data, quickly obtain the desired results from the page, and provide technical support for grid adjustment and optimization. At the same time, the constructed panoramic grid provides a technical basis for further topology-based system inertia evaluation and reactive power optimization adjustment. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Figure 1 Schematic diagram of the flow of the method for displaying the panoramic grid of the power system based on BPA data analysis in this embodiment.

[0039] Figure 2 Schematic diagram of the panoramic grid diagram constructed by BPA data analysis for Jiangsu's 2030 power grid planning scheme. DETAILED DESCRIPTION

[0040] The technical solution of the present invention is described in detail below.

[0041] The method for displaying the panoramic grid of the power system based on BPA data analysis in this embodiment specifically includes:

[0042] Based on the BPA data file, XML data model conversion is performed, and the data is stored in the ORACLE database after data cleaning to form a two-dimensional coordinate ETL data cleaning model. In this embodiment, the data in the ORACLE database includes network structure data, node attribute data, and device attribute data.

[0043] The network structure data including the line association relationship ID, the first and last names of the power station, the first and last voltage levels of the power station, and the number of line loops of the power station are obtained from the ORACLE database (see the following formula), and the site line is formed based on the constraint conditions of the location distribution between the power stations; the device attribute data including the coordinate data of each device is obtained from the ORACLE database, and the two-dimensional coordinate position of each device is obtained through processing and calculation based on the device attribute data; the grid topology model of the entire line structure is constructed according to the two-dimensional coordinate position of the site line and each device.

[0044]

[0045] In the above formula, RELATION_ID represents the obtained relationship ID value, BRANCH_BUS1 and RANCH_BUS2 represent the first and last names of the power station, BRANCH_VB1 and BRANCH_VB2 represent the first and last voltage levels of the power station, and BRANCH_CKT represents the number of line loops of the power station.

[0046] The two-dimensional coordinate position of each device is obtained by processing and calculating the device attribute data: the coordinate data in the device attribute data of each device is calculated by coefficient offset to obtain the two-dimensional coordinate system coordinate values ​​X and Y corresponding to the longitude and latitude, and the two-dimensional coordinate position of each device is obtained according to the two-dimensional coordinate system coordinate values ​​X and Y, specifically:

[0047]

[0048] Wherein, latitude represents the X-axis longitude value of the device obtained from the BPA data conversion model, longitude represents the Y-axis latitude value of the device obtained from the BPA data conversion model, R represents the radius of the earth, x represents the specific X-axis coordinate coefficient converted from the X-axis coordinate coefficient of the device obtained from the BPA data conversion model, and y represents the specific Y-axis coordinate coefficient converted from the Y-axis coordinate coefficient of the device obtained from the BPA data conversion model.

[0049] Based on the grid topology model of the entire line structure, the flow direction mapping is established according to the site number and active power to form a text-mathematical real-time mapping model; based on the text-mathematical real-time mapping model, the data in the ORACLE database is spliced ​​through the SUBSTRM function according to the set rules to form complete unit, node, and line data, and complete the display of the power system panoramic grid. In this embodiment, the information displayed by the power system panoramic grid also includes: the operation status of the power grid, time sequence changes, the flow of active power flow, and the output status of the power plant, see Figure 2 The grid operation status, time sequence changes, and active power flow are all displayed in the form of streamline diagrams, and the power plant output status is obtained through the existing simulation electric field output analysis model.

[0050] The constraint condition for the location distribution between power stations in this embodiment is: if the names of the beginning and end of the station are the same, the voltage level is the same, and the number of line loops is the same, then the power stations form a complete line.

[0051] The rules set above include:

[0052]

[0053] In the above formula, U CARD_TYPE Represents the card type, U CARD_NAME Represents the card name, U CARD_VOLT Represents the card voltage, U UNIT_NAME Represents the unit splicing name, U PART Represents the partition, U CONST_ACTIVE_LOAD Represents constant active load, U CONST_REACTIVE_LOAD Represents a constant reactive load, U PARALLEL_ACTIVE_LOAD Represents the parallel admittance active load, U PARALLEL_REACTIVE_LOAD Represents the parallel admittance reactive load, U MAX_ACTIVE_OUTPUT Represents the maximum active output, U REAL_ACTIVE_OUTPUT Represents the measured active output, U MAX_REACTIVE_OUTPUT , represents the arranged reactive power output value, U MIN_REACTIVE_OUTPUT Represents the minimum reactive power output value, U VMAX Represents the highest voltage arrangement, U VMIN Represents the lowest voltage of the arrangement, U FACTORY Represents power factor; U 机组 Indicates the unit card information.

[0054] According to the above formula, the SUBSTRM function is used to splice and supplement it into a complete unit data.

[0055] N 节点 =N card_type +N card_name +N card_volt

[0056] +N node_volt +N node_name +N part

[0057] In the above formula, N card_type Represents the card type, N card_name Represents the card name, N card_volt Represents the card voltage, N node_volt Represents the node voltage, N node_name Represents the node splicing name, NL part Represents node partition; N 节点 Represents node card information.

[0058] According to the above formula, the SUBSTRM function is used to splice and supplement it into a complete node data.

[0059] L 线路 =L card_type +L line_start_name +L line_start_volt +L card_end_name +L card_end_volt

[0060] +L part +L parallel_mark +L inductance +L capacitance +L dc_power

[0061] +L length

[0062] In the above formula, L card_type Represents the line card type, L line_start_name Represents the name of the headend node, L line_start_volt Represents the first-end node voltage, L card_end_name Represents the terminal node name, L card_end_volt represents the terminal node voltage, L part Represents the region, L parallel_mark Represents the loop symbol of the parallel circuit, L inductance Represents the per-unit value of inductance, L capacitance Represents the capacitance per unit value, L dc_power Represents DC power, L length Represents the line length, L 线路 Indicates line card information.

[0063] According to the above formula, the SUBSTRM function is used to splice and supplement the data into a complete line data.

[0064] The power flow direction mapping of this embodiment is specifically as follows: when the active power is positive, the power flow direction in the line follows the direction of the beginning and end of the line, and the site numbers from small to large are in the positive direction of the line. Conversely, when the active power is negative, the power flow direction is in the opposite direction of the line direction.

[0065] This embodiment also provides an electronic device, including a memory, a processor, and a computer program, wherein the computer program is stored in the memory and is configured to be executed by the processor to implement the method for displaying the panoramic grid of the power system based on BPA data analysis.

[0066] This embodiment also provides a computer-readable storage medium, which stores a computer program. The computer program is executed by a processor to implement the method for displaying a panoramic grid of a power system based on BPA data analysis.

[0067] The following is an example of the application of the power system panoramic grid display method of the present application in a power grid planning simulation platform.

[0068] like Figure 2 In this example, the Jiangsu 2030 power grid planning scheme is used to implement the process of BPA data analysis and construction of a panoramic grid diagram. The data input is BPA flow data. After data analysis, cleaning, and conversion to the required grid structure data, the mapping of production simulation data and grid structure is completed through the text-mathematical real-time mapping model. Finally, a time-series panoramic grid with visual display capabilities is established through the full grid dynamic perception model. The display and hiding of equipment names are realized through the display and hiding control buttons of the plant, line, and substation. The rendering and loading of flow power, time-series operation status, etc. are realized through time and indicator selection. Through the above process, the power system panoramic grid display method realizes the data conversion, automatic mapping and visual analysis of BPA data and panoramic grid, and intuitively displays the weak links of the grid in the form of indicator rendering, supporting planners to formulate and evaluate the feasibility of planning schemes more efficiently and accurately, and improving the lean level of power grid planning.

[0069] The above is only a preferred specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims

1. A method for displaying a panoramic grid of a power system based on BPA data analysis, characterized in that Based on the BPA data file, perform XML data model conversion and store the data in the ORACLE database after data cleaning; Obtain network structure data including line association relationship ID, the first and last names of power stations, the first and last voltage levels of power stations, and the number of line loops of power stations from the ORACLE database, and form site lines based on the constraints of the location distribution between power stations according to the network structure data; obtain device attribute data including the coordinate data of each device from the ORACLE database, and obtain the two-dimensional coordinate position of each device through processing and calculation according to the device attribute data; construct a grid topology model of the entire line structure according to the two-dimensional coordinate position of the site line and each device; Based on the grid topology model of the entire line structure, a power flow direction mapping is established according to the site number and active power to form a real-time text-mathematical mapping model; based on the real-time text-mathematical mapping model, the data in the ORACLE database are spliced ​​through the SUBSTRM function according to the set rules to form complete unit, node, and line data, completing the display of the panoramic grid of the power system.

2. The method for displaying a panoramic grid of a power system based on BPA data analysis according to claim 1 is characterized in that The data in the ORACLE database includes network structure data, node attribute data, and device attribute data.

3. The method for displaying a panoramic grid of a power system based on BPA data analysis according to claim 1 is characterized in that The constraints for the location distribution between power stations are: if the names of the first and last stations are the same, the voltage levels are the same, and the number of line loops is the same, then the power stations form a complete line.

4. The method for displaying a panoramic grid of a power system based on BPA data analysis according to claim 1 is characterized in that The coordinate data in the device attribute data of each device is calculated by coefficient offset to obtain the two-dimensional coordinate system coordinate values ​​X and Y corresponding to the longitude and latitude. The two-dimensional coordinate position of each device is obtained according to the two-dimensional coordinate system coordinate values ​​X and Y, specifically: Wherein, latitude represents the X-axis longitude value of the device obtained from the BPA data conversion model, longitude represents the Y-axis latitude value of the device obtained from the BPA data conversion model, R represents the radius of the earth, x represents the specific X-axis coordinate coefficient converted from the X-axis coordinate coefficient of the device obtained from the BPA data conversion model, and y represents the specific Y-axis coordinate coefficient converted from the Y-axis coordinate coefficient of the device obtained from the BPA data conversion model.

5. The method for displaying a panoramic grid of a power system based on BPA data analysis according to claim 1 is characterized in that The set rules include: IN 机组 =U CARD_TYPE +U CARD_NAME +U CARD_VOLT +U UNIT_NAME +U PART +U CONST_ACTIVE_LOAD +U CONST_REACTIVE_LOAD +U PARALLEL_ACTIVE_LOAD +U PARALLEL_REACTIVE_LOAD +U MAX_ACTIVE_OUTPUT +U REAL_ACTIVE_OUTPUT +U MAX_REACTIVE_OUTPUT, +U MIN_REACTIVE_OUTPUT +U VMAX +U VMIN +U FACTORY In the above formula, U CARD_TYPE Represents the card type, U CARD_NAME Represents the card name, U CARD_VOLT Represents the card voltage, U UNIT_NAME Represents the unit splicing name, U PART Represents the partition, U CONST_ACTIVE_LOAD Represents constant active load, U CONST_REACTIVE_LOAD Represents a constant reactive load, U PARALLEL_ACTIVE_LOAD Represents the parallel admittance active load, U PARALLEL_REACTIVE_LOAD Represents the parallel admittance reactive load, U MAX_ACTIVE_OUTPUT Represents the maximum active output, U REAL_ACTIVE_OUTPUT Represents the measured active output, U MAX_REACTIVE_OUTPUT, Represents the arranged reactive power output value, U MIN_REACTIVE_OUTPUT Represents the minimum reactive power output value, U VMAX Represents the highest voltage arrangement, U VMIN Represents the lowest voltage of the arrangement, U FACTORY Represents the power factor, U 机组 Indicates the unit card information; according to the above formula, it is spliced ​​and supplemented into a complete unit data through the SUBSTRM function; N 节点 =N card_type +N card_name +N card_volt +N node_volt +N node_name +N part In the above formula, N card_type Represents the card type, N card_name Represents the card name, N card_volt Represents the card voltage, N node_volt Represents the node voltage, N node_name Represents the node splicing name, NL part Represents the node partition, N 节点 Represents node card information; According to the above formula, the SUBSTRM function is used to splice and supplement a complete node data; L 线路 =L card_type +L line_start_name +L line_start_volt +L card_end_name +L card_end_volt +L part +L parallel_mark +L inductance +L capacitance +L dc_power +L length In the above formula, L card_type Represents the line card type, L line_start_name Represents the name of the headend node, L line_start_volt Represents the first-end node voltage, L card_end_name Represents the terminal node name, L card_end_volt represents the terminal node voltage, L part Represents the region, L parallel_mark Represents the loop symbol of the parallel circuit, L inductance Represents the per-unit value of inductance, L capacitance Represents the capacitance per unit value, L dc_power Represents DC power, L length Represents the line length, L 线路 Represents line card information; according to the above formula, it is spliced ​​and supplemented into a complete line data through the SUBSTRM function.

6. The method for displaying a panoramic grid of a power system based on BPA data analysis according to claim 1 is characterized in that The power flow direction mapping is specifically as follows: when the active power is positive, the power flow direction in the line follows the line head-end direction, and the station numbers from small to large are in the positive direction of the line; conversely, when the active power is negative, the power flow direction is in the opposite direction of the line direction.

7. The method for displaying a panoramic grid of a power system based on BPA data analysis according to claim 1 is characterized in that The information displayed by the panoramic grid of the power system also includes: the operating status of the power grid, time sequence changes, the flow of active power flow and the output status of the power plant. The operating status of the power grid, time sequence changes, and the flow of active power flow are all displayed in the form of streamline diagrams. The output status of the power plant is obtained through the electric field output analysis model of the simulation software.

8. An electronic device, characterized in that: It includes a memory, a processor and a computer program, wherein the computer program is stored in the memory and is configured to be executed by the processor to implement the method for displaying a panoramic grid of a power system based on BPA data analysis as described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that The storage medium stores a computer program, and the computer program is executed by a processor to implement the method for displaying a panoramic grid of a power system based on BPA data analysis as described in any one of claims 1 to 7.

Images