Power grid asset dynamic space visualization method and device, terminal equipment and storage medium

Abstract

The invention discloses a power grid asset dynamic space visualization method and apparatus, a terminal device and a storage medium. The method comprises the steps of obtaining an asset state, an asset position, functional data, security situation data and a power grid topological structure of a to-be-processed power grid asset; associating to-be-processed power grid assets according to the asset state, the asset position, the function data, the security situation data and a power grid topological structure, and generating an asset spatial index; performing grid unit division according to the asset spatial index and the asset position, and constructing grid units and grid unit indexes; mapping the grid unit to a preset space map according to the grid unit index to obtain a target asset space map; and mapping the asset state, the function data and the security situation data to the target asset space map to obtain a final asset space map, and by implementing the method and the system, the demand of quick response of power grid assets is met.

Description

Technical Field

[0001] The present invention relates to the technical field of power systems, and in particular to a method, device, terminal equipment and storage medium for visualizing dynamic spatial drawing of power grid assets. Background Art

[0002] With the development of smart grids, smart grid IoT systems have become an important part of the power industry. The grid IoT system connects various IoT assets (sensors, smart meters, switchgear, etc.) to achieve real-time monitoring, control and management of the grid. In traditional grid monitoring, static maps or charts are usually used to display the topology and operating status of the grid. However, with the increase in grid assets and the increase in the complexity of the grid, it is difficult for traditional methods to manage and display the status changes of various assets in the grid in real time, and it is difficult to meet the demand for rapid response to the grid. Summary of the invention

[0003] The embodiments of the present invention provide a method, device, terminal device and storage medium for dynamic spatial visualization of power grid assets, which can effectively solve the problem that with the increase of power grid assets and the increase of power grid complexity, it is difficult to manage and display the status changes of various assets in the power grid in real time, and it is difficult to meet the demand for rapid response of the power grid.

[0004] An embodiment of the present invention provides a method for visualizing a dynamic space of power grid assets, including:

[0005] Obtain asset status, asset location, functional data, security situation data, and grid topology of the grid assets to be processed;

[0006] Associating the processed power grid assets according to the asset status, the asset location, the functional data, the security situation data, and the power grid topology structure to generate an asset space index;

[0007] Divide the grid cells according to the asset space index and the asset location, and construct grid cells and grid cell indexes;

[0008] According to the grid unit index, the grid unit is mapped onto a preset spatial map to obtain a target asset spatial map;

[0009] The asset status, the functional data and the security situation data are mapped onto the target asset space map to obtain a final asset space map.

[0010] Furthermore, before constructing the asset space index, it also includes:

[0011] Performing data smoothing processing on the asset status, the asset location, the functional data, and the security situation data according to a preset sliding window length to obtain the asset status, asset location, functional data, and security situation data after data processing;

[0012] The processed asset status, asset location, functional data and security situation data are standardized according to the preset data format to obtain the final asset status, asset location, functional data and security situation data.

[0013] Further, the processed power grid assets are associated according to the asset status, the asset location, the functional data, the security situation data, and the power grid topology structure to generate an asset space index, including:

[0014] Determine the grid area to which the asset to be processed belongs according to the asset location and the grid topology;

[0015] Determine the location of a grid node in the grid area to which the asset belongs according to the grid area to which the asset belongs and the grid topology structure;

[0016] Calculate the distance between the asset and the node according to the asset location and the grid node location, and spatially associate the grid asset to be processed with the smallest distance with the corresponding grid node to generate a spatially associated asset;

[0017] Time-aligning the spatially associated assets with the timestamps corresponding to the security situation data to obtain time-aligned spatially associated assets;

[0018] Based on each functional data in the spatially associated assets after time alignment, determine whether there is security situation data to match;

[0019] If so, the time-aligned spatially associated assets are associated with the matched security situation data to obtain associated power grid assets;

[0020] If not, then according to the asset status, the preset security situation value is associated with the corresponding functional data to obtain the associated power grid asset;

[0021] A spatial index is created for the associated power grid assets according to the power grid topology structure to obtain an asset spatial index.

[0022] Furthermore, grid unit division is performed according to the asset space index and the asset location, and grid units and grid unit indexes are constructed, including:

[0023] Divide the geographical location covered by the asset location into a number of grid cells according to a preset cell size;

[0024] Mapping the asset location to a plurality of grid cells, and determining the grid cell where each grid asset to be processed is located;

[0025] A grid unit index is constructed according to the asset space index and the grid unit where the power grid asset to be processed is located.

[0026] Furthermore, according to the grid unit index, the grid unit is mapped onto a preset spatial map to obtain a target asset spatial map, including:

[0027] Determine the geographic boundary and geographic coordinate information of the area covered by the assets to be processed based on the preset spatial map;

[0028] Determine the mapping correspondence of the grid cells according to the geographic coordinate information and the grid cell index;

[0029] According to the mapping correspondence of the grid cells, the grid cells corresponding to the grid cell indexes are mapped onto the spatial map within the geographic boundary to obtain the target asset spatial map.

[0030] Furthermore, the asset status, the functional data and the security situation data are mapped onto the target asset space map to obtain a final asset space map, including:

[0031] Determining the status of each grid cell in the target asset space map according to the asset status;

[0032] According to the status of the grid cells, the grid cells in the target asset space map are filled with different colors to obtain a filled target asset space map;

[0033] The function data and the security situation data are mapped to the grid cells corresponding to the filled target asset space map to obtain a final asset space map.

[0034] Further, it also includes: storing the asset status, the asset location, the functional data and the security situation data in a preset database according to the asset spatial index;

[0035] When a power grid asset on the asset space map changes, determining the affected power grid asset according to the power grid topology and the asset space index;

[0036] Determine the affected grid cells according to the affected power grid assets, and mark the affected grid cells;

[0037] The database is updated according to the affected grid assets and the asset spatial index.

[0038] As an improvement of the above solution, another embodiment of the present invention provides a device for visualizing the dynamic space of power grid assets, including:

[0039] An asset data acquisition module is used to obtain the asset status, asset location, functional data, security situation data and power grid topology of the power grid assets to be processed;

[0040] An asset index generation module, configured to associate the processed power grid assets according to the asset status, the asset location, the functional data, the security situation data, and the power grid topology structure, and generate an asset space index;

[0041] A grid index generation module, used to divide grid cells according to the asset spatial index and the asset location, and construct grid cells and grid cell indexes;

[0042] A grid mapping module, used to map the grid unit to a preset spatial map according to the grid unit index to obtain a target asset spatial map;

[0043] The asset visualization module is used to map the asset status, the functional data and the security situation data onto the target asset space map to obtain a final asset space map.

[0044] Another embodiment of the present invention provides a terminal device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, and when the processor executes the computer program, a method for dynamic spatial visualization of power grid assets as described in the above embodiment is implemented.

[0045] Another embodiment of the present invention provides a computer-readable storage medium, which includes a stored computer program, wherein when the computer program is running, the device where the computer-readable storage medium is located is controlled to execute a method for dynamic spatial visualization of power grid assets described in the above embodiment.

[0046] By implementing the present invention, at least the following beneficial effects are achieved:

[0047] The present invention provides a method, device, terminal equipment and storage medium for dynamic spatial visualization of power grid assets. The method can obtain the asset status, asset location, functional data, security situation data and power grid topology of the power grid assets to be processed; associate the power grid assets to be processed according to the asset status, the asset location, the functional data, the security situation data and the power grid topology to generate an asset space index; divide the grid units according to the asset space index and the asset location, and construct grid units and grid unit indexes; map the grid units to a preset space map according to the grid unit index to obtain a target asset space map; map the asset status, the functional data and the security situation data to the target asset space map to obtain a final asset space map. By integrating asset status, asset location, functional data and security situation data, generating asset space index and grid unit division, the complex power grid structure can be simplified. When the power grid assets change, they can be quickly mapped through the changed asset status, asset location, functional data and security situation data. Based on the power grid topology, a comprehensive visual asset space map of power grid assets is formed, which reduces the search time of power grid assets, meets the needs of rapid response of the power grid, and improves the rapid response capability of power grid assets. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] Figure 1 It is a flow chart of a method for dynamic spatial visualization of power grid assets provided by one embodiment of the present invention;

[0049] Figure 2 It is a structural schematic diagram of a dynamic spatial visualization device for power grid assets provided by one embodiment of the present invention. DETAILED DESCRIPTION

[0050] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0051] See also Figure 1 , is a flow chart of a method for visualizing a dynamic space of power grid assets provided by an embodiment of the present invention, including:

[0052] S1. Obtaining the asset status, asset location, functional data, security situation data and grid topology of the grid assets to be processed;

[0053] S2, associating the pending power grid assets according to the asset status, the asset location, the functional data, the security situation data and the power grid topology structure, and generating an asset space index;

[0054] S3, dividing the grid units according to the asset space index and the asset location, and constructing grid units and grid unit indexes;

[0055] S4. Mapping the grid unit to a preset spatial map according to the grid unit index to obtain a target asset spatial map;

[0056] S5. Map the asset status, the functional data, and the security situation data onto the target asset space map to obtain a final asset space map.

[0057] Specifically, in the power system, the power grid assets include sensors, circuit breakers, cameras and other equipment; the asset status includes normal equipment and abnormal equipment. For example, if the sensor temperature is abnormal, the asset status of the sensor is abnormal; for example, if the circuit breaker is offline or fails, the asset status of the circuit breaker as the power grid asset to be processed is abnormal. The asset location is the geographical location of the asset; functional data such as voltage, current and temperature can reflect the operation of the power grid asset. For example, the functional data of a power sensor can include its measurement range (such as 0-1000V), measurement accuracy (such as ±0.1%), and response time (such as 1 second); security situation data refers to data such as risk level, vulnerability, abnormal behavior, etc. The asset spatial index represents the creation of a spatial index for the power grid asset storage field to improve the efficiency of asset division and query. The asset spatial index can be created based on geometric object types such as points, lines and surfaces. In the present invention, for the asset data field, by establishing an asset spatial index, the further analysis of the asset is accelerated, and the efficiency of subsequent power grid asset visualization is improved. The grid unit index plays an important role in dividing the power grid assets into grid units and mapping the grid units to the preset spatial map.

[0058] In a preferred embodiment of the present invention, the asset status, asset location, functional data, security situation data and grid topology of the power grid asset to be processed are first obtained; then the power grid asset to be processed is associated according to the asset status, asset location, functional data, security situation data and grid topology to generate an asset space index; then the grid unit is divided according to the asset space index and the asset location to construct a grid unit and a grid unit index; then according to the grid unit index, the grid unit is mapped to a preset space map to obtain a target asset space map; finally, the asset status, functional data and security situation data are mapped to the target asset space map to obtain a final asset space map. The power grid assets are visualized so that managers can view and monitor the operation of the power grid in real time to meet the needs of rapid changes in the power grid.

[0059] Preferably, before constructing the asset space index, the method further includes:

[0060] Performing data smoothing processing on the asset status, the asset location, the functional data, and the security situation data according to a preset sliding window length to obtain the asset status, asset location, functional data, and security situation data after data processing;

[0061] The processed asset status, asset location, functional data and security situation data are standardized according to the preset data format to obtain the final asset status, asset location, functional data and security situation data.

[0062] In a preferred embodiment of the present invention, it is necessary to clean and denoise the asset status, asset location, functional data and security situation data of the power grid assets, exclude outliers and erroneous data, and ensure the accuracy and integrity of the data. For example, technologies such as data smoothing, interpolation and anomaly detection. In the IoT assets of the power grid, some sensors will regularly report their status data, such as voltage, current and temperature, etc., in which outliers may appear due to sensor failure, communication failure or other factors. In order to exclude these outliers, time series analysis techniques such as moving average, exponentially weighted average (EWA) or seasonal decomposition (STL) are used. For example, in the moving average method, a sliding window length (such as 5 time points) is preset, and the sliding average of each time point is calculated and compared with the actual observation value. If the difference between the actual value and the sliding average exceeds the set threshold range, the value is marked as an outlier and eliminated in subsequent analysis. At the same time, the collected data can be tested for upper and lower limits by combining statistical analysis methods (such as the triple standard deviation method): if the data exceeds three times the standard deviation of the normal range, it can be judged as an outlier. Through the above methods, erroneous data and outliers in asset status, asset location, functional data, and security situation data can be effectively eliminated, and the asset status, asset location, functional data, and security situation data after data processing can be obtained to ensure the reliability and integrity of data quality.

[0063] The processed asset status, asset location, functional data, and security situation data are standardized according to the preset data format to ensure data consistency and uniformity. For example, the data is converted into a standard data format (such as JSON, XML, etc.), and the coordinate system and unit are unified to obtain the final asset status, asset location, functional data, and security situation data.

[0064] Specifically, the processing grid assets are associated with each other according to the asset status, the asset location, the functional data, the security situation data and the grid topology structure to generate an asset space index, including:

[0065] Determine the grid area to which the asset to be processed belongs according to the asset location and the grid topology;

[0066] Determine the location of a grid node in the grid area to which the asset belongs according to the grid area to which the asset belongs and the grid topology structure;

[0067] Calculate the distance between the asset and the node according to the asset location and the grid node location, and spatially associate the grid asset to be processed with the smallest distance with the corresponding grid node to generate a spatially associated asset;

[0068] Time-aligning the spatially associated assets with the timestamps corresponding to the security situation data to obtain time-aligned spatially associated assets;

[0069] Based on each functional data in the spatially associated assets after time alignment, determine whether there is security situation data to match;

[0070] If so, the time-aligned spatially associated assets are associated with the matched security situation data to obtain associated power grid assets;

[0071] If not, then according to the asset status, the preset security situation value is associated with the corresponding functional data to obtain the associated power grid asset;

[0072] A spatial index is created for the associated power grid assets according to the power grid topology structure to obtain an asset spatial index.

[0073] Specifically, the asset data from different sources are associated and integrated, and the association relationship between power grid assets and asset security situation data is established, and then the asset spatial index is generated. First, the power grid area to which the power grid asset to be processed belongs is determined based on the asset location and the power grid topology structure; then, the power grid node location within the power grid area to which the asset belongs is determined based on the power grid area to which the asset belongs and the power grid topology structure; then, the distance between the asset and the node is calculated based on the asset location and the power grid node location, and the power grid asset to be processed with the smallest distance is spatially associated with the corresponding power grid node to generate a spatially associated asset, thereby realizing spatial association of power grid assets. Exemplarily, the spatial association uses the Euclidean distance formula:

[0074]

[0075] In the formula: x1 and y1 are the asset locations of the grid assets to be processed; x2 and y2 represent the grid node locations; the distance between the grid assets to be processed and the grid node locations is calculated, and the assets are associated with the grid nodes by using the distance threshold or the nearest neighbor principle. For example, if the distance between a grid asset to be processed and a grid node is less than a preset threshold, or the distance between the two is the smallest, the grid asset can be spatially associated with the grid node.

[0076] Specifically, the spatially associated assets are time-aligned with the timestamps corresponding to the security situation data to obtain the time-aligned spatially associated assets, thereby ensuring the temporal consistency of the asset data. The alignment is performed based on the timestamps corresponding to the security situation, or based on a preset time window. Schematically: matched data =match by time (asset data ,grid status data );

[0077] Where: asset data Represents grid asset data, including asset status, asset location, and functional data; grid status data Represents the security situation data of power grid assets, such as asset risks, vulnerability information, behavior baselines, etc. by time Function, matches the two data according to the timestamp to obtain the time-aligned spatially associated asset data matched data .

[0078] Specifically, according to each functional data in the spatially associated assets after time alignment, it is determined whether there is security situation data to match, that is, the attributes of the power grid assets to be processed and the security situation data are associated according to the functional data, and the corresponding relationship between the power grid assets and the security situation data is established. For each power grid asset, based on its functional data, the corresponding attribute information is found in the security situation data, and the attributes including asset type are matched. Schematically,

[0079] matched attributes =match by attributes (asset data ,grid status data );

[0080] asset data Represents spatially associated assets after time alignment, including aligned asset status, asset location, and functional data; grid status data Represents the security status data of assets, such as asset risks, vulnerability information, and behavior baselines.

[0081] If there is a match between the security situation data and the functional data, the time-aligned spatially associated assets are associated with the matched security situation data to obtain associated power grid assets; if there is no match between the security situation data and the functional data, the preset security situation value is associated with the corresponding functional data according to the asset status to obtain associated power grid assets; finally, a spatial index is created for the associated power grid assets according to the power grid topology to obtain an asset spatial index.

[0082] By associating power grid assets and security situation data, operation and maintenance personnel can take corresponding measures based on specific security risks. For example, if a security problem occurs in an asset (such as being attacked or failing), the scope of impact can be determined in a timely manner, and preventive measures can be taken on surrounding equipment. The association relationship can also help identify potential risk points for early intervention. In subsequent visualizations, the associated data can be filled and marked with images based on different attributes of power grid assets (such as function and security status). For example, different colors or symbols can be used to indicate the security level of an asset, helping users quickly identify which areas or equipment are at risk and which equipment is operating normally, thereby improving the efficiency of information communication.

[0083] Schematically, grid assets do not have specific security situation data. For example, some newly installed or tested grid assets may not have collected complete security situation data. In this case, in order not to affect the operation of the overall system, preset security situation values ​​can be provided for these assets. At certain times, security situation data may be partially missing due to sensor failure, communication delay, etc. In order to continue to operate, the system can also adopt the preset security situation value and assume that the missing data is in a normal state. For example, in a power grid, if a newly connected smart sensor device does not have real-time security level assessment data, its security level assessment data can be defaulted to "low" and associated with low-risk security situation data to ensure that the device can be included in the monitoring system in a timely manner. When the attributes or characteristics of a grid asset cannot be matched with any security situation data and there is no suitable preset security situation value to match, the system will mark the grid asset as "unmatched". This usually occurs in the following situations: (1) Asset information is seriously incomplete or erroneous: When the data of an IoT asset (such as location information, functional attributes) is seriously missing or abnormal, it cannot be effectively matched with the security situation data. (2) Lack of corresponding matching data in the security situation database: For some special assets, their security risk assessment data may not have a corresponding relationship in the current database. For example, in the power grid system, an IoT device with abnormal behavior cannot be associated with any power grid node due to its incorrect location data (such as exceeding the reasonable range). At this time, the device will be marked as "unmatched". The preset security situation value includes security situation level and security function attribute. When no matching data is found, the system can set a preset security situation level for the power grid asset, such as "low risk" or "medium risk", to ensure that the device is not missed; for power grid assets with unclear functional attributes, the system can set preset security function attributes according to common scenarios, such as "ordinary sensor" or "basic monitoring device". When a power grid asset is marked as "unmatched", the system will generate an abnormal warning or prompt information to notify the operation and maintenance personnel that the device cannot be matched with the security situation data, prompting possible risks or data anomalies, and the operation and maintenance personnel need to check or repair it in time. The operation and maintenance personnel can re-collect or correct the location information, functional data, etc. of the device according to the prompt information, or set the status of the device to "pending matching" so that the system can try to match again in subsequent data updates. Unmatched assets and their related information are recorded in the log for subsequent troubleshooting and data auditing. In some key devices or nodes, unmatched situations may require manual intervention, such as manually entering the device's security situation information or directly matching through manual judgment. For example, in a power grid monitoring system, when a smart meter cannot be matched with a grid node due to a deviation in its location data (beyond the grid area boundary), the system will issue a warning prompt and suggest that the operation and maintenance personnel perform data correction or re-collection.

[0084] Preferably, dividing the grid cells according to the asset space index and the asset location, and constructing the grid cells and the grid cell index includes:

[0085] Divide the geographical location covered by the asset location into a number of grid cells according to a preset cell size;

[0086] Mapping the asset location to a plurality of grid cells, and determining the grid cell where each grid asset to be processed is located;

[0087] A grid unit index is constructed according to the asset space index and the grid unit where the power grid asset to be processed is located.

[0088] In a preferred embodiment of the present invention, the geographical location covered by the asset location is first divided into a number of grid cells according to a preset cell size, and then the asset location is mapped to the grid cells, and the grid cell where each power grid asset to be processed is located is determined, and then the grid cell index is constructed according to the asset spatial index and the grid cell where the power grid asset to be processed is located:

[0089]

[0090]

[0091] Where: Grid i Represents the column index of the grid cell; Grid j Represents the row index of the grid cell; Longitude i Column index representing the asset spatial index; Latitude j Represents the row index of the asset space index; GridWidth represents the preset width of the grid cell; GridHeight represents the preset height of the grid cell; MinLongitude represents the boundary range of the geographic space, that is, the minimum longitude; MinLatitude represents the minimum latitude.

[0092] Preferably, mapping the grid unit to a preset spatial map according to the grid unit index to obtain a target asset spatial map includes:

[0093] Determine the geographic boundary and geographic coordinate information of the area covered by the assets to be processed based on the preset spatial map;

[0094] Determine the mapping correspondence of the grid cells according to the geographic coordinate information and the grid cell index;

[0095] According to the mapping correspondence of the grid cells, the grid cells corresponding to the grid cell indexes are mapped onto the spatial map within the geographic boundary to obtain the target asset spatial map.

[0096] In a preferred embodiment of the present invention, the geographical boundary range and geographical coordinate information of the area covered by the asset to be processed are first determined according to a preset spatial map, and then for each grid cell in the spatial map, the position of the grid cell on the map is calculated:

[0097] x=MinLongitude′+GridWidth×(Grid i +0.5);

[0098] y=MinLatitude′+GridHeight×(Grid j +0.5);

[0099] Where: MinLongitude′ represents the minimum longitude of the geographical boundary range; MinLatitude′ represents the minimum latitude of the geographical boundary range;

[0100] The calculated map coordinates (x, y) are matched with the geographic coordinate information on the map, and the mapping correspondence of the grid cells is determined according to the grid cell index. According to the mapping correspondence of the grid cells, the grid cells corresponding to the grid cell index are mapped to the spatial map within the geographic boundary to obtain the target asset spatial map. At this time, the grid cells are mapped to the spatial map accordingly.

[0101] Specifically, mapping the asset status, the functional data, and the security situation data onto the target asset space map to obtain a final asset space map includes:

[0102] Determining the status of each grid cell in the target asset space map according to the asset status;

[0103] According to the status of the grid cells, the grid cells in the target asset space map are filled with different colors to obtain a filled target asset space map;

[0104] The function data and the security situation data are mapped to the grid cells corresponding to the filled target asset space map to obtain a final asset space map.

[0105] In a preferred embodiment of the present invention, the state of each grid cell in the target asset space map is first determined according to the asset state. For example, if the state of all assets in the grid cell is normal, the current grid cell state is normal. If there is a power grid asset failure in the grid cell, the current grid cell will be marked as a failure state. Then, according to the state of the grid cell, the grid cells in the target asset space map are filled with different colors to obtain the filled target asset space map. For example, if all equipment in the substation in a grid cell is operating normally, the cell is filled with green; if the sensor in a substation detects an abnormal temperature, the color of the cell is filled with yellow, indicating a warning state; if the circuit breaker equipment in a substation is offline or fails, the cell is filled with red, indicating that it needs to be inspected and repaired immediately. After obtaining the target asset space map, the functional data and the security situation data are mapped to the grid cell corresponding to the filled target asset space map to obtain the final asset space map. If a camera is installed in a grid unit, a camera icon will be displayed in the unit, indicating that there is a monitoring device in the area; for areas containing sensors, sensor icons are used to mark them, so that operation and maintenance personnel can understand the function of the area; if it is a circuit breaker device, a gear icon is marked to indicate that there is an execution device in the area. Through such filling and marking, operation and maintenance personnel can quickly identify which areas have normal equipment and which areas have faults or risks through spatial images, and can clearly identify the functions of the equipment in the area. This intuitive representation method can significantly improve the operability and decision-making efficiency of the system.

[0106] Schematically, it also includes: storing the asset status, the asset location, the function data and the security situation data in a preset database according to the asset spatial index;

[0107] When a power grid asset on the asset space map changes, determining the affected power grid asset according to the power grid topology and the asset space index;

[0108] Determine the affected grid cells according to the affected power grid assets, and mark the affected grid cells;

[0109] The database is updated according to the affected grid assets and the asset spatial index.

[0110] In a preferred embodiment of the present invention, the database adopts one of PostgreSQL PostGIS extension, MySQLSpatial extension, and Oracle Spatial; the database table structure is designed according to the characteristics of the collected power grid assets, including tables for storing power grid asset data and asset security situation data. The table fields should include data information such as asset status, asset location, and functional data. Storing data in the database can ensure that the asset status, asset location, functional data, and other data of all power grid assets are stored and managed in a unified format, which provides a standardized data source for subsequent processing and analysis. All data are accessed through the database to ensure that the interfaces for data access and operation are consistent, reducing the coupling and inconsistency between different processing links. The database is optimized to support efficient data retrieval and concurrent query, and can better cope with the processing needs of large-scale data. The database usually has an efficient indexing mechanism (such as R-tree, B-tree, etc.), which can quickly retrieve the required data and significantly improve the speed of generating spatial images in real time; the database can reduce repeated calculations through a cache mechanism, and support concurrent data access to ensure the performance of multiple users or multiple processes performing spatial data operations at the same time.

[0111] When the grid assets on the asset space map change, the affected grid assets are determined based on the grid topology and the asset space index; the affected grid units are determined based on the affected grid assets, and the affected grid units are marked; the database is updated based on the affected grid assets and the asset space index. When a fault or abnormality occurs in the grid, the fault location and affected range can be quickly determined through the asset space map and the marking of the grid units, providing accurate information support for emergency repairs. The real-time updated database can ensure that emergency repair personnel obtain the latest grid asset information, improving the efficiency and success rate of repairs.

[0112] In another preferred embodiment of the present invention, the user location is obtained and mapped to a corresponding location on a spatial map:

[0113] x user =MinLongitude′+GridWidth×(Grid i +0.5);

[0114] y user =MinLatitude′+GridHeight×(Grid j +0.5);

[0115] Where: x user and user Respectively represent the longitude and latitude of the user's location;

[0116] When an asset fails or is attacked, the spatial image and map are updated. The location of the equipment failure or attack can be compared with the user's location, and the location of the user and the failed asset equipment can be marked on the map so that maintenance decisions can be made quickly. At the same time, in the case of changes in power grid assets, based on the asset spatial map, the impact range of the changed power grid assets can be quickly determined, and whether there are users within the impact range can be determined, so as to quickly respond to changes in power grid assets.

[0117] In another preferred embodiment of the present invention, any one of Matplotlib, Plotly, and D3.js is used as a visualization tool, which can be selected according to specific needs; the generated asset space image is rendered, symbolized and colored according to different attributes of the data to highlight the operating status information of the power grid. Interactive functions are built on the asset space map, including but not limited to zooming, panning, querying and other functions to improve user experience and analysis efficiency. These functions can be implemented by adding interactive controls or setting event responses. Set the title, label, legend, etc. of the asset space map so that users can understand the image content. Annotations or additional explanatory information can be added as needed. The generated real-time space map is visualized, and interactive functions are built so that users can easily view and analyze the operating status of the power grid, and perform related operations and decisions.

[0118] In a preferred embodiment of the present invention, the grid unit can be filled with color or graphically marked according to the status of the power grid asset (such as normal equipment, faulty, offline, etc.), using different colors or symbols to represent different statuses. According to the function of the power grid asset (such as sensors, actuators, cameras, etc.), specific graphic marks can be added to the grid unit to intuitively indicate the type and function of the asset in the unit. Use different intensities or types of colors to indicate the status of the device. For example: green means that the device is operating normally; yellow means that the device is in a warning state (such as a slight abnormality or performance degradation); red means that the device is faulty or offline. Icon marking can use different icons in the grid unit to mark the function of the power grid asset. For example: sensor devices can use sensor icons; cameras can use camera icons; actuators can use gear icons.

[0119] By implementing this embodiment, the asset status, asset location, functional data, security situation data and grid topology of the power grid asset to be processed are obtained; the power grid asset to be processed is associated according to the asset status, asset location, functional data, security situation data and grid topology to generate an asset space index; grid unit division is performed according to the asset space index and the asset location, and grid units and grid unit indexes are constructed; according to the grid unit index, the grid unit is mapped to a preset space map to obtain a target asset space map; the asset status, functional data and security situation data are mapped to the target asset space map to obtain a final asset space map. By integrating the asset status, asset location, functional data and security situation data, generating an asset space index and grid unit division, the complex power grid structure can be simplified. When the power grid assets change, the asset status, asset location, functional data and security situation data are quickly mapped, and a comprehensive visual asset space map of the power grid assets is formed based on the power grid topology, which reduces the search time of the power grid assets, meets the demand for rapid response of the power grid, and improves the rapid response capability of the power grid assets.

[0120] See also Figure 2 , is a schematic diagram of a structure of a dynamic spatial visualization device for power grid assets provided by an embodiment of the present invention, comprising:

[0121] An asset data acquisition module is used to obtain the asset status, asset location, functional data, security situation data and power grid topology of the power grid assets to be processed;

[0122] An asset index generation module, configured to associate the processed power grid assets according to the asset status, the asset location, the functional data, the security situation data, and the power grid topology structure, and generate an asset space index;

[0123] A grid index generation module, used to divide the grid units according to the asset space index and the asset location, and construct grid units and grid unit indexes;

[0124] A grid mapping module, used to map the grid unit to a preset spatial map according to the grid unit index to obtain a target asset spatial map;

[0125] The asset visualization module is used to map the asset status, the functional data and the security situation data onto the target asset space map to obtain a final asset space map.

[0126] The present invention provides a device for dynamic spatial visualization of power grid assets. According to an asset data acquisition module, the asset status, asset location, functional data, security situation data and power grid topology of the power grid assets to be processed are acquired; in an asset index generation module, the power grid assets to be processed are associated according to the asset status, the asset location, the functional data, the security situation data and the power grid topology, and an asset spatial index is generated; in a grid index generation module, grid unit division is performed according to the asset spatial index and the asset location, and grid units and grid unit indexes are constructed; in a grid mapping module, according to the grid unit index, the grid units are mapped to a preset spatial map to obtain a target asset spatial map; through an asset visualization module, the asset status, the functional data and the security situation data are mapped to the target asset spatial map to obtain a final asset spatial map. By integrating asset status, asset location, functional data and security situation data, generating asset space index and grid unit division, the complex power grid structure can be simplified. When the power grid assets change, they can be quickly mapped through the changed asset status, asset location, functional data and security situation data. Based on the power grid topology, a comprehensive visual asset space map of power grid assets is formed, which reduces the search time of power grid assets, meets the needs of rapid response of the power grid, and improves the rapid response capability of power grid assets.

[0127] It should be noted that the device embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. In addition, in the accompanying drawings of the device embodiments provided by the present invention, the connection relationship between the modules indicates that there is a communication connection between them, which may be specifically implemented as one or more communication buses or signal lines. A person of ordinary skill in the art may understand and implement it without paying any creative effort.

[0128] Those skilled in the art can clearly understand that, for the sake of convenience and brevity, the specific working process of the device described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.

[0129] Another embodiment of the present invention further provides a terminal device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, wherein the processor implements a method for visualizing the dynamic space of power grid assets as described in the above embodiment when executing the computer program. The terminal device may be a computing device such as a desktop computer, a notebook, a PDA, and a cloud server. The terminal device may include, but is not limited to, a processor and a memory.

[0130] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc. The processor is the control center of the terminal device, and uses various interfaces and lines to connect various parts of the entire terminal device.

[0131] The memory can be used to store the computer program, and the processor realizes various functions of the terminal device by running or executing the computer program stored in the memory and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the mobile phone, etc. In addition, the memory can include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device or other volatile solid-state storage device.

[0132] Another embodiment of the present invention provides a computer-readable storage medium, which includes a stored computer program, wherein when the computer program is running, the device where the computer-readable storage medium is located is controlled to execute a method for dynamic spatial visualization of power grid assets described in the above embodiment.

[0133] The storage medium is a computer-readable storage medium, and the computer program is stored in the computer-readable storage medium. When the computer program is executed by the processor, the steps of each of the above-mentioned method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium.

[0134] The above is a preferred embodiment of the present invention. It should be pointed out that a person skilled in the art can make several improvements and modifications without departing from the principle of the present invention. These improvements and modifications are also considered to be within the scope of protection of the present invention.

Claims

1. A method for dynamic spatial visualization of power grid assets, characterized in that: include: Obtain asset status, asset location, functional data, security situation data, and grid topology of the grid assets to be processed; Associating the processed power grid assets according to the asset status, the asset location, the functional data, the security situation data, and the power grid topology structure to generate an asset space index; Divide the grid cells according to the asset space index and the asset location, and construct grid cells and grid cell indexes; According to the grid unit index, the grid unit is mapped onto a preset spatial map to obtain a target asset spatial map; The asset status, the functional data and the security situation data are mapped onto the target asset space map to obtain a final asset space map.

2. A method for dynamic spatial visualization of power grid assets according to claim 1, characterized in that: Before building the asset space index, also include: Performing data smoothing processing on the asset status, the asset location, the functional data, and the security situation data according to a preset sliding window length to obtain the asset status, asset location, functional data, and security situation data after data processing; The processed asset status, asset location, functional data and security situation data are standardized according to the preset data format to obtain the final asset status, asset location, functional data and security situation data.

3. A method for dynamic spatial visualization of power grid assets according to claim 1, characterized in that: The processing of the power grid assets is associated with the asset status, the asset location, the functional data, the security situation data and the power grid topology structure to generate an asset space index, including: Determine the grid area to which the asset to be processed belongs according to the asset location and the grid topology; Determine the location of a grid node in the grid area to which the asset belongs according to the grid area to which the asset belongs and the grid topology structure; Calculate the distance between the asset and the node according to the asset location and the grid node location, and spatially associate the grid asset to be processed with the smallest distance with the corresponding grid node to generate a spatially associated asset; Time-aligning the spatially associated assets with the timestamps corresponding to the security situation data to obtain time-aligned spatially associated assets; Based on each functional data in the spatially associated assets after time alignment, determine whether there is security situation data to match; If so, the time-aligned spatially associated assets are associated with the matched security situation data to obtain associated power grid assets; If not, then according to the asset status, the preset security situation value is associated with the corresponding functional data to obtain the associated power grid asset; A spatial index is created for the associated power grid assets according to the power grid topology structure to obtain an asset spatial index.

4. A method for dynamic spatial visualization of power grid assets according to claim 1, characterized in that: Dividing the grid cells according to the asset space index and the asset location, and constructing the grid cells and the grid cell index, includes: Divide the geographical location covered by the asset location into a number of grid cells according to a preset cell size; Mapping the asset location to a plurality of grid cells, and determining the grid cell where each grid asset to be processed is located; A grid unit index is constructed according to the asset space index and the grid unit where the power grid asset to be processed is located.

5. A method for dynamic spatial visualization of power grid assets according to claim 1, characterized in that: According to the grid unit index, the grid unit is mapped to a preset spatial map to obtain a target asset spatial map, including: Determine the geographic boundary and geographic coordinate information of the area covered by the assets to be processed based on the preset spatial map; Determine the mapping correspondence of the grid cells according to the geographic coordinate information and the grid cell index; According to the mapping correspondence of the grid cells, the grid cells corresponding to the grid cell indexes are mapped onto the spatial map within the geographic boundary to obtain the target asset spatial map.

6. A method for dynamic spatial visualization of power grid assets according to claim 1, characterized in that: Mapping the asset status, the functional data, and the security situation data onto the target asset space map to obtain a final asset space map includes: Determining the status of each grid cell in the target asset space map according to the asset status; According to the status of the grid cells, the grid cells in the target asset space map are filled with different colors to obtain a filled target asset space map; The function data and the security situation data are mapped to the grid cells corresponding to the filled target asset space map to obtain a final asset space map.

7. A method for dynamic spatial visualization of power grid assets according to claim 1, characterized in that: Also includes: According to the asset spatial index, the asset status, the asset location, the functional data and the security situation data are stored in a preset database; When a power grid asset on the asset space map changes, determining the affected power grid asset according to the power grid topology and the asset space index; Determine the affected grid cells according to the affected power grid assets, and mark the affected grid cells; The database is updated according to the affected grid assets and the asset spatial index.

8. A device for visualizing dynamic space of power grid assets, characterized in that: include: An asset data acquisition module is used to obtain the asset status, asset location, functional data, security situation data and power grid topology of the power grid assets to be processed; An asset index generation module, configured to associate the processed power grid assets according to the asset status, the asset location, the functional data, the security situation data, and the power grid topology structure, and generate an asset space index; A grid index generation module, used to divide grid cells according to the asset spatial index and the asset location, and construct grid cells and grid cell indexes; A grid mapping module, used to map the grid unit to a preset spatial map according to the grid unit index to obtain a target asset spatial map; The asset visualization module is used to map the asset status, the functional data and the security situation data onto the target asset space map to obtain a final asset space map.

9. A terminal device, characterized in that: The method comprises a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, wherein when the processor executes the computer program, a method for dynamic spatial visualization of power grid assets as described in any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute a method for dynamic spatial visualization of power grid assets as described in any one of claims 1 to 7.

Images