Method and system for constructing historical state grid geographic map of digital power distribution network operating system

Abstract

The invention discloses a method and a system for constructing a historical state grid geographic map of a digital power distribution network operating system, and belongs to the technical field of smart power grids. The method specifically comprises the following steps: acquiring a historical state vector tile request generated by a user operation viewport of a digital power distribution network operation system; calculating tile coordinates in a vector tile rendering engine, wherein the tile coordinates comprise a scaling hierarchy, a row number, a column number and grid time; performing multi-concurrence query on historical state power grid vector tile data in a historical state vector tile memory object database according to the tile coordinates through a historical state vector tile query engine, if the historical state power grid vector tile data cannot be queried, calling a historical state vector slicing service, generating the historical state power grid vector tile data according to the tile coordinates, and storing the historical state power grid vector tile data in the historical state vector tile memory object database; and rendering through a vector tile rendering engine to generate a historical grid geographic map, thereby realizing construction of the historical grid geographic map of the digital power distribution network operating system. According to the method, slice division of the vector data of the power grid equipment considering the time state is realized, and the concurrent response capability of the server is improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of smart grids, and more specifically, relates to a method and system for constructing a historical state grid frame geographic map of a digital distribution network operating system. Background Art

[0002] In a geographic information system, geographic data only involves two aspects: spatial information and attribute information. Most geographic data only describes its instantaneous state and does not have the time dynamics of geographic data. When new data appears, the old data will be replaced. This method cannot analyze the differences between data in different time states, nor can it predict and analyze the development trend of future geographic data. The existing vector slicing algorithm cannot achieve the slicing and partitioning of vector data of power grid equipment containing temporal information.

[0003] The important presentation, interaction, and application carrier of the historical state digital power grid is the historical state grid frame geographic map display service implemented based on the power grid one-map application. This service needs to support the concurrent invocation of the geographic map by digital business applications in each network province. However, the existing technology uses a single index to store tile data. When invoking the geographic map, a large number of change records of non-target time or non-target space need to be traversed, which is difficult to cope with the high-frequency change scenario of power grid equipment, has low query efficiency, and is not suitable for the concurrent invocation of the geographic map by a large number of power grid equipment.

[0004] The existing technical document 1 (CN116975399B) discloses a method and system for displaying a historical state power grid geographic map. Its disadvantage is that querying the historical state table is only based on a single query condition (such as the equipment coordinates before change or the equipment coordinates after change), resulting in the inability to cover the situation where the position of the equipment before and after change crosses the tile boundary, causing data loss when restoring the historical state grid frame and resulting in an incomplete tile topology. Summary of the Invention

[0005] To solve the deficiencies in the existing technology, the present invention provides a method and system for constructing a historical state grid frame geographic map of a digital distribution network operating system. By querying the data before and after the device change to construct historical state vector tiles and caching the vector tiles in multiple data tables, the slicing and partitioning of vector data of power grid equipment that takes into account temporal and spatial information are realized, a complete tile topology is generated, historical state data is stored in separate databases by date, change records of non-target time periods are quickly filtered, and adjacent tile data is discretely stored according to the tile coordinate hash value, reducing the data transmission volume of the historical state geographic map and enabling multi-concurrent access.

[0006] The present invention adopts the following technical solutions.

[0007] The first aspect of the present invention provides a method for constructing a historical state grid frame geographic map of a digital distribution network operating system, characterized in that:

[0008] Obtain the historical state vector tile requests generated by the user operation viewport of the digital distribution network operating system;

[0009] Calculate tile coordinates in the vector tile rendering engine according to the historical state vector tile requests, where the tile coordinates include zoom level, row number, column number, and grid time;

[0010] Query historical power grid vector tile data in multiple concurrencies in the historical state vector tile memory object database according to the tile coordinates through the historical state vector tile query engine. If the data cannot be queried, call the historical state vector slicing service to generate historical power grid vector tile data according to the tile coordinates;

[0011] Transmit the queried or generated historical power grid vector tile data to the vector tile rendering engine for rendering to generate a historical grid geographical map, realizing the construction of the historical grid geographical map of the digital distribution network operating system.

[0012] Preferably, the obtaining of the historical state vector tile requests generated by the user operation viewport of the digital distribution network operating system specifically includes:

[0013] The user performs operations such as panning, zooming, or changing the grid time on the historical grid geographical map in the geographical map service client, causing the viewport of the geographical map service client to generate new historical state vector tile requests.

[0014] Preferably, the calling of the historical state vector slicing service to generate historical power grid vector tile data according to the tile coordinates specifically includes:

[0015] Calculate the BBox (Bounding Box) and layer list according to the row number, column number, and zoom level in the tile coordinates;

[0016] Obtain the running state device data records that meet the device types in the layer list within the BBox range in the historical state vector tile memory object database to form a running state grid device set;

[0017] Query the earliest historical device change records within the BBox range by using the joint query method according to the device types in the layer list and the grid time in the tile coordinates to form a historical grid change set;

[0018] Replace the corresponding device states in the running state grid device set with the historical device state sections in the historical grid change set, and trace back the running state grid in the running state grid device set to the historical grid state corresponding to the grid time to form a historical state grid device set;

[0019] Cut the device vector data with graphic information recorded in all historical state device data in the historical state grid device set according to the BBOX longitude and latitude boundaries to obtain the cut geographical feature vector data;

[0020] Overlay the device attribute data in the historical state grid equipment set with the cut geographic feature vector data, and package it into historical state power grid vector tiles according to the vector tile specification.

[0021] Preferably, according to the device type in the layer list and the grid time in the tile coordinates, use the combined query method to query the earliest historical device change records within the BBox range to form the historical grid change set B. Among them, the query range for querying the earliest historical device change records within the BBox range specifically includes:

[0022] Set the situation where both before and after the device change fall within the BBox range as the first query range;

[0023] Set the situation where the device is within the BBox range before the change and outside the BBox range after the change as the second query range;

[0024] Set the situation where the device is outside the BBox range before the change and within the BBox range after the change as the third query range.

[0025] Preferably, using the combined query method to query the earliest historical device change records within the BBox range specifically includes:

[0026] Set the first query condition according to the first query range and the second query range, and query the device change records that meet the first query condition in the historical state table according to the device type in the layer list to obtain the first query result;

[0027] Set the second query condition according to the third query range, and query the device change records that meet the second query condition in the historical state table according to the device type in the layer list to obtain the second query result;

[0028] Remove duplicates from the first query result and the second query result respectively and then merge them to generate the historical grid change set corresponding to the tile.

[0029] Preferably, the first query condition specifically includes:

[0030] The longitude and latitude coordinates of the device before the change in the record are within the BBox range;

[0031] The change operation time in the record is later than the grid time. If there are multiple change records of the same device after the grid time, take the change record with the closest change time to the grid time.

[0032] Preferably, the second query condition specifically includes:

[0033] The new longitude and latitude coordinates after the change in the record are within the BBox range;

[0034] The change operation time in the record is later than the grid frame time. If there are multiple change records for the same device after the grid frame time, the change record with the closest change time to the grid frame time is selected.

[0035] Preferably, after de-duplicating the first query result and the second query result respectively and then merging them, if the change records of the same device are included in both the first query result and the second query result, the record with the closer change time to the grid frame time of this device is retained.

[0036] Preferably, the historical state power grid vector tile data is generated according to the tile coordinates, and the generated historical state power grid vector tile data is cached in the historical state vector tile in-memory database, and stored in the database by date in the historical state vector tile in-memory database. For tiles of the same date, they are scattered according to the tile coordinates through the hash algorithm, and adjacent tiles are stored in multiple data tables. When querying, multi-concurrent queries are performed on multiple data tables through the historical state vector tile query engine.

[0037] The second aspect of the present invention provides a historical state grid frame geographic map construction system for a digital distribution network operating system, which includes, according to the historical state grid frame geographic map construction method described in the first aspect of the present invention:

[0038] Tile request acquisition module: used to acquire the historical state vector tile requests generated by the user operation viewport of the digital distribution network operating system;

[0039] Tile coordinate solving module: used to calculate the tile coordinates in the vector tile rendering engine according to the historical state vector tile request, and the tile coordinates include the zoom level, row number, column number, and grid frame time;

[0040] Tile data query module: used to multi-concurrently query the historical state power grid vector tile data in the historical state vector tile in-memory object database according to the tile coordinates through the historical state vector tile query engine. If it cannot be queried, the historical state vector slicing service is called to generate the historical state power grid vector tile data according to the tile coordinates;

[0041] Historical geographic map generation module: used to transmit the queried or generated historical state power grid vector tile data to the vector tile rendering engine for rendering, generate the historical grid frame geographic map, and realize the construction of the historical state grid frame geographic map of the digital distribution network operating system.

[0042] The third aspect of the present invention proposes an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the computer program is loaded into the processor, it implements a historical state grid frame geographic map construction method according to the first aspect of the present invention.

[0043] A fourth aspect of the present invention proposes a computer-readable storage medium storing a computer program, which when executed by a processor, implements a method for constructing a historical state grid geographical map of a digital distribution network operating system according to the first aspect of the present invention.

[0044] Compared with the prior art, the beneficial effects of the present invention at least include:

[0045] By setting the ranges before and after the device change as query conditions, the present invention completely covers all associated change records of the device before and after the device change, avoiding the lack of historical state grid data. At the same time, considering the rectangular longitude and latitude range, it realizes the slicing division of the vector data of power grid devices considering temporal and spatial information, and generates a complete tile topology.

[0046] The present invention stores historical state data in separate databases by date, quickly filters change records in non-target time periods, and discretely stores adjacent tile data according to the hash value of tile coordinates, reducing the data transmission volume of the historical state geographical map. It can be accessed concurrently, improving the concurrent response ability of the server, reducing the single-table query pressure, and being applicable to the concurrent call of geographical maps for large-scale power grid devices. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 is a schematic diagram of the historical state geographical map display service architecture provided according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0048] To make the objectives, technical solutions, and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. The described embodiments are only a part of the embodiments of the present invention, rather than all embodiments. Based on the spirit of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0049] As Figure 1 shown, Embodiment 1 of the present invention provides a method for constructing a historical state grid geographical map of a digital distribution network operating system, including the following steps:

[0050] Step 1: Obtain a historical state vector tile request generated by the user operation viewport of the digital distribution network operating system.

[0051] In a preferred but non-limiting embodiment of the present invention, the geographical map service client (B / S) is embedded in the upper-layer business applications of each network province as a grid geographical map display sub-module. Operations such as panning, zooming, or changing the grid time of the historical grid geographical map by the user on the geographical map service client result in a new historical state vector tile request being generated by the client viewport.

[0052] The geographical longitude and latitude range that can be displayed by the client viewport each time is limited. Only the set of tiles required by the viewport (usually several to a dozen adjacent tiles) needs to be obtained, and the vector data in the tiles is rendered into pictures, which can then be pieced together into the geographical map to be displayed in the current viewport.

[0053] Step 2: Calculate the tile coordinates of the historical state vector tile request obtained in Step 1 in the vector tile rendering engine. The tile coordinates include the zoom level, row number, column number, and grid time.

[0054] In a preferred but non-limiting embodiment of the present invention, when operations such as panning, zooming, or changing the grid time of the historical grid geographical map on the geographical map service client by the user result in a new historical state vector tile request for the client viewport, the vector tile rendering engine calculates the coordinates of the required tiles according to the historical state vector tile request. Among them, the tile row coordinate X and column coordinate Y are obtained by performing operations on the longitude and latitude coordinates using the WGS84 coordinate conversion algorithm.

[0055] Further preferably, the historical state vector tile request includes: the zoom level of the client viewport displaying the historical grid geographical map, the longitude range of the historical grid geographical map, the dimension range, and the historical grid time parameter.

[0056] More preferably, the vector tile rendering request calculates the four tile coordinates of the tile zoom level Z, row number X, column number Y, and grid time T through the four viewport parameters of the zoom level, longitude range, dimension range, and historical grid time of the front-end displayed geographical map.

[0057] Step 3: Query the historical state power grid vector tile data in the historical state vector tile memory object database according to the tile coordinates described in Step 2 through the historical state vector tile query engine. If it cannot be queried, call the historical state vector slicing service to generate the historical state power grid vector tile data according to the tile coordinates.

[0058] In a preferred but non-limiting embodiment of the present invention, the historical state vector tile query engine provides an external historical state vector tile service based on WebService and multi-user concurrency, including multi-user concurrent task scheduling, vector tile stitching of multiple provinces, and network transmission based on a RESTful distributed architecture.

[0059] In a preferred but non-limiting embodiment of the present invention, according to the rectangular longitude and latitude range corresponding to the tile coordinates, query the running state device data and historical device change data within the range, backtrack the running state grid within the range to the historical state grid, cut the vectorized historical state grid data and geographical feature data according to the tile boundary, and finally package them into historical state vector tiles. The calling of the historical state vector slicing service to generate the historical state power grid vector tile data according to the tile coordinates specifically includes:

[0060] Step 3.1: Calculate the BBox and the layer list layerList based on the row number X, column number Y, and zoom level Z in the tile coordinates obtained in Step 2. The layerList records the device types in this tile.

[0061] Step 3.2: Obtain the running device data records that meet the requirements of the device types in the layer list within the BBox obtained in Step 3.1 from the historical state vector tile memory object database, and form the running grid device set A.

[0062] Further preferably, the running state power grid device data records have been cached in the historical state vector tile memory object database. Through the initial loading and incremental update mechanisms, the comprehensiveness and accuracy of the data are ensured. In the slicing algorithm, the access to the device ledger, topological relationship, and graphical data of the running devices are all processed based on the historical state vector tile memory object database, eliminating disk access.

[0063] Step 3.3: According to the device types in the layerList and the grid time T in the tile coordinates, use the combined query method to query the earliest historical device change records within the BBox (that is, if there are multiple change records for the same device after T, take the record with the change time closest to T), and form the historical grid change set B;

[0064] Further preferably, when querying the historical device change records within the BBox, the query scope is divided into the following three cases:

[0065] Set the situation where both the device before and after the change fall within the BBox as the first query scope;

[0066] Set the situation where the device is within the BBox before the change and outside the BBox after the change as the second query scope;

[0067] Set the situation where the device is outside the BBox before the change and within the BBox after the change as the third query scope.

[0068] Further preferably, using the combined query method to query the earliest historical device change records within the BBox specifically includes:

[0069] Set the first query condition according to the first query scope and the second query scope, and query the device change records that meet the first query condition in the historical state table according to the device types in the layer list to obtain the first query result;

[0070] More preferably, the first query condition specifically includes:

[0071] The longitude and latitude coordinates of the device before the change in the record are within the BBox;

[0072] The change operation time in the record is later than the grid time T. If there are multiple change records for the same device after the grid time T, take the change record with the closest change time to the grid time T.

[0073] Set the second query condition according to the third query range. According to the device type in the layer list, query the device change records that meet the second query condition in the historical state table to obtain the second query result.

[0074] More preferably, the second query condition specifically includes:

[0075] The new longitude and latitude coordinates after the change in the record are within the BBox range.

[0076] The change operation time in the record is later than the grid time T. If there are multiple change records for the same device after the grid time T, take the change record with the closest change time to the grid time.

[0077] Deduplicate the first query result and the second query result respectively and then merge them to generate the historical grid change set B corresponding to the tile.

[0078] When deduplicating and merging the first query result and the second query result respectively, if the change records of the same device are included in both the first query result and the second query result, keep the record with the closer change time to the grid time T of this device.

[0079] It should be noted that in the prior art, querying the historical state table is only based on a single query condition (such as the device coordinates before the change or the device coordinates after the change), resulting in the inability to cover the situation where the position of the device spans the tile boundary before and after the change, causing data loss when restoring the historical state grid, resulting in an incomplete tile topology. The present invention sets the ranges before and after the device change as query conditions, completely covering all associated change records of the device before and after the device change, avoiding the loss of historical state grid data, and at the same time considering the rectangular longitude and latitude range, realizing the slicing division of the vector data of power grid devices that takes into account temporal and spatial information, and generating a complete tile topology.

[0080] Step 3.4: The historical grid change set B contains the historical device state section before the change. Replace the corresponding device state in A obtained in step 3.2 with the historical device state section in the historical grid change set B obtained in step 3.3, so as to trace back the running state grid in the running state grid device set A to the historical grid state at time T, forming the historical state grid device set C. Among them, the historical state device data in the historical state grid device set C includes device attribute data and device vector data recording graphic information.

[0081] Step 3.5: Cut the device vector data that records graphic information in all historical device data in the historical grid equipment set C in Step 3.4 according to the BBOX longitude and latitude boundaries to obtain the cut geographic feature vector data.

[0082] It should be noted that the present invention restores the historical grid first and then cuts it, ensuring the integrity of device connections.

[0083] Step 3.6: Overlay the device attribute data in the historical grid equipment set C with the cut geographic feature vector data, and package it into historical grid vector tiles according to the MVT (Mapbox Vector Tile, vector tile standard) specification.

[0084] Further preferably, for the historical grid at a certain moment, a quadtree tile pyramid structure is composed of 24 global historical grid geographic maps with increasing size and gradually detailed elements, divided into 1 - 24 zoom levels. The 24 geographic maps at the bottom are the largest in size, containing all the grid device vector data and geographic feature vector data. Cut the 24 geographic maps into square tiles of the same size by rows and columns, called historical vector tiles. Each tile contains a part of the geographic map of a rectangular longitude and latitude area, and the geographic map exists in the form of vector data. The tile is uniquely determined by four coordinates: row number X, column number Y, zoom level Z, and grid time T. Z determines the longitude and latitude of the tile. The larger the value, the smaller the longitude and latitude range contained in a single tile, and the more detailed the grid device data and geographic features contained.

[0085] Further preferably, the historical vector tile in-memory object database is the in-memory mirror of the grid data in the application server. Cache the historical vector tiles that have been generated into the historical vector tile in-memory database and persistently store them in mongoDB. If the tile requested by the client (user operation viewport) is missing in the historical vector tile in-memory object database, then call the historical vector slicing service to generate the historical vector tile with the specified coordinates.

[0086] More preferably, generate the historical grid vector tile data according to the tile coordinates, cache the generated historical grid vector tile data into the historical vector tile in-memory database, and store it in separate databases by date in the historical vector tile in-memory database. For tiles of the same date, scatter them according to the tile coordinates through the hash algorithm, and store adjacent tiles in multiple data tables. When querying, perform concurrent queries in multiple data tables through the historical vector tile query engine. Compared with the running state data, the scale of historical device change data required by the slicing algorithm is smaller, and it can be loaded from mongoDB in a parallel multi-threaded manner. This caching method realizes the high-speed processing of large-scale grid data.

[0087] It should be noted that the prior art uses a single index to store tile data, and it is necessary to traverse a large number of change records in non-target time or non-target space, which is difficult to cope with the high-frequency change scenarios of power grid equipment, with low query efficiency. The present invention stores historical state data in databases by date, quickly filters change records in non-target time periods, and discretely stores adjacent tile data according to the hash value of tile coordinates, enabling multi-concurrent access, reducing the single-table query pressure, and being applicable to the concurrent calls of geographical maps for large-scale power grid equipment.

[0088] Step 4: Transmit the historical state power grid vector tile data queried in Step 3 to the vector tile rendering engine for rendering to generate a historical grid geographical map, thus realizing the construction of the historical grid geographical map of the digital distribution network operating system.

[0089] In a preferred but non-limiting embodiment of the present invention, the client viewport has a limited size, and the server only needs to transmit the set of vector tiles required by the current client viewport (usually several to dozens of adjacent tiles). After the client receives the historical state vector tiles, which are uniquely determined by four coordinates: zoom level Z, row number X, column number Y, and grid time T, the historical grid geographical map required by the viewport is generated after being rendered by the vector tile rendering engine.

[0090] The beneficial effects of the present invention at least include:

[0091] By setting the ranges before and after the device change as query conditions, the present invention completely covers all associated change records of the device before and after the device change, avoiding the lack of historical grid data. At the same time, considering the rectangular longitude and latitude range, it realizes the slicing division of the vector data of power grid equipment considering temporal and spatial information, generating a complete tile topology;

[0092] The present invention stores historical state data in databases by date, quickly filters change records in non-target time periods, and discretely stores adjacent tile data according to the hash value of tile coordinates, reducing the data transmission volume of the historical state geographical map, enabling multi-concurrent access, improving the concurrent response ability of the server, reducing the single-table query pressure, and being applicable to the concurrent calls of geographical maps for large-scale power grid equipment.

[0093] Embodiment 2 of the present invention provides a system for constructing a historical grid geographical map of a digital distribution network operating system, which runs the method for constructing a historical grid geographical map of a digital distribution network operating system described in Embodiment 1, including:

[0094] Tile request acquisition module: used to acquire the historical state vector tile requests generated by the user operation viewport of the digital distribution network operating system;

[0095] Tile Coordinate Solving Module: It is used to calculate tile coordinates in the vector tile rendering engine according to the historical state vector tile request. The tile coordinates include zoom level, row number, column number, and grid time;

[0096] Tile Data Query Module: It is used to query historical state power grid vector tile data in the historical state vector tile memory object database through the historical state vector tile query engine according to the tile coordinates in a multi-concurrent manner. If the data cannot be queried, it calls the historical state vector slicing service to generate historical state power grid vector tile data according to the tile coordinates;

[0097] Historical Geographic Map Generation Module: It is used to transmit the queried or generated historical state power grid vector tile data to the vector tile rendering engine for rendering to generate a historical grid geographic map, thereby realizing the construction of the historical state grid geographic map of the digital distribution network operation system.

[0098] Embodiment 3 of the present invention provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the computer program is loaded into the processor, it implements a method for constructing a historical state grid geographic map of a digital distribution network operation system according to Embodiment 1.

[0099] Embodiment 4 of the present invention provides a computer-readable storage medium. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it implements a method for constructing a historical state grid geographic map of a digital distribution network operation system according to Embodiment 1.

[0100] The present disclosure can be a system, a method, and / or a computer program product. The computer program product may include a computer-readable storage medium having thereon computer-readable program instructions for causing a processor to implement various aspects of the present disclosure.

[0101] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit them. Although the present invention has been described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications or equivalent replacements can still be made to the specific embodiments of the present invention. Any modification or equivalent replacement without departing from the spirit and scope of the present invention shall be covered by the protection scope of the claims of the present invention.

Claims

1. A method for constructing a historical grid geographic map of a digital distribution network operating system, characterized in that: Obtain the historical state vector tile request generated by the user operation viewport of the digital distribution network operating system; Calculating tile coordinates in a vector tile rendering engine according to the historical vector tile request, wherein the tile coordinates include a zoom level, a row number, a column number, and a grid time; The historical state vector tile query engine concurrently queries the historical state power grid vector tile data in the historical state vector tile memory object database according to the tile coordinates. If the historical state vector tile data cannot be found, the historical state vector slicing service is called to generate the historical state power grid vector tile data according to the tile coordinates. The queried or generated historical power grid vector tile data is transmitted to a vector tile rendering engine for rendering, generating a historical grid geographic map, thereby realizing the construction of a historical grid geographic map of a digital distribution network operating system.

2. A method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 1, characterized in that: The obtaining of the historical state vector tile request generated by the user operating the viewport of the digital distribution network operating system specifically includes: When a user pans, zooms, or changes the grid time on the historical grid geographic map on the geographic map service client, the geographic map service client viewport generates a new historical state vector tile request.

3. The method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 1, characterized in that: The calling of the historical vector slicing service to generate historical power grid vector tile data according to tile coordinates specifically includes: Calculate the BBox and layer list according to the row number, column number and zoom level in the tile coordinates; Acquire the running state device data records that match the device type in the layer list within the BBox range in the historical state vector tile memory object database to form a running state grid device set; According to the device type in the layer list and the grid time in the tile coordinates, a joint query method is used to query the earliest historical device change record within the BBox range to form a historical grid change set; The historical equipment state section in the historical grid change set replaces the corresponding equipment state in the running grid equipment set, and the running grid in the running grid equipment set is traced back to the historical grid state of the corresponding grid time to form a historical grid equipment set; Cut the device vector data recording the graphic information in all the historical device data in the historical grid device set according to the BBOX longitude and latitude boundaries to obtain the cut geographic element vector data; The device attribute data in the historical grid device set is superimposed with the cut geographic element vector data, and packaged into historical power grid vector tiles according to the vector tile specifications.

4. A method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 3, characterized in that: According to the device type in the layer list and the grid time in the tile coordinates, a joint query method is used to query the earliest historical device change record within the BBox range to form a historical grid change set B, wherein the earliest historical device change record within the BBox range is queried, and the query range specifically includes: Set the device to fall within the BBox range before and after the change, and set it as the first query range; Set the device to be within the BBox range before the change and outside the BBox range after the change as the second query range; The device is outside the BBox range before the change and within the BBox range after the change, and is set as the third query range.

5. A method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 4, characterized in that: Use the joint query method to query the earliest historical equipment change record within the BBox range, including: The first query condition is set according to the first query range and the second query range, and the device change record that meets the first query condition is searched in the history state table according to the device type in the layer list to obtain the first query result; The second query condition is set according to the third query range, and according to the device type in the layer list, the device change record that meets the second query condition is searched in the history state table to obtain the second query result; The first query result and the second query result are respectively deduplicated and then merged to generate a historical grid change set of the corresponding tiles.

6. A method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 5, characterized in that: The first query condition specifically includes: The longitude and latitude coordinates of the device before the change in the record are within the BBox range; The change operation time in the record is later than the grid time. If there are multiple change records for the same device after the grid time, take the change record with the closest change time to the grid time.

7. A method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 5, characterized in that: The second query condition specifically includes: The new longitude and latitude coordinates after the change in the record are within the BBox range; The change operation time in the record is later than the grid time. If there are multiple change records for the same device after the grid time, take the change record with the closest change time to the grid time.

8. The method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 5, characterized in that: The first query result and the second query result are respectively deduplicated and then merged. If the first query result and the second query result both contain change records of the same device, a record whose device change time is closer to the grid time is retained.

9. The method for constructing a historical grid geographic map of a digital distribution network operating system according to claim 1, characterized in that: The historical power grid vector tile data is generated according to the tile coordinates, the generated historical power grid vector tile data is cached in the historical vector tile memory database, and the historical vector tile memory database is stored in the database by date. Tiles of the same date are scattered according to the tile coordinates through a hash algorithm, and adjacent tiles are stored in multiple data tables. When querying, multiple concurrent queries are performed in multiple data tables through a historical vector tile query engine.

10. A system for constructing a historical state grid geographic map of a digital distribution network operating system, according to a method for constructing a historical state grid geographic map of a digital distribution network operating system according to any one of claims 1 to 9, characterized in that: Tile request acquisition module: used to obtain the historical vector tile request generated by the user operation viewport of the digital distribution network operating system; Tile coordinate solving module: used for calculating tile coordinates in the vector tile rendering engine according to the historical vector tile request, wherein the tile coordinates include zoom level, row number, column number and grid time; Tile data query module: used to query historical power grid vector tile data in the historical vector tile memory object database according to the tile coordinates through the historical vector tile query engine. If the historical power grid vector tile data cannot be found, the historical vector slicing service is called to generate historical power grid vector tile data according to the tile coordinates. Historical geographic map generation module: used to transmit the queried or generated historical power grid vector tile data to the vector tile rendering engine for rendering, generate a historical grid geographic map, and realize the construction of a historical grid geographic map of the digital distribution network operating system.

11. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the computer program is loaded into a processor, a method for constructing a historical grid geographic map of a digital distribution network operating system according to any one of claims 1 to 9 is implemented.

12. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, a method for constructing a historical grid geographic map of a digital distribution network operating system according to any one of claims 1 to 9 is implemented.

Images