Power grid GIS data editing method and system, electronic equipment and storage medium

Abstract

The invention discloses a power grid GIS data editing method and system, electronic equipment and a storage medium. The method comprises the steps that a server constructs power grid vector slice data based on power grid GIS data and converts power grid equipment data into GeoJSON data; the client obtains and loads the vector slices, picks up a power grid graph from the vector slices according to the position of the edited equipment, adsorbs the power grid graph to the edited equipment, and requests the server for GeoJSON data of the corresponding equipment; the server performs query based on the edited device to obtain a device associated with the edited device, and sends GeoJSON data of the edited device and the associated device to the client; and the client establishes a relation with the GeoJSON data according to a pre-configured vector slice layer, captures an editing operation, superposes the vector slice and the GeoJSON data and then displays the superposed vector slice and GeoJSON data in real time. The problems of graph rendering and large data volume online editing are solved by using a data layering mechanism combining vector slicing and GeoJSON, and the rendering efficiency is improved.

Description

Technical Field

[0001] The present application relates to the technical field of power grid GIS data, and more specifically, to a power grid GIS data editing method and system, electronic equipment, and storage medium. Background Art

[0002] At present, large-scale online editing of power grid GIS (Geographic Information System) data is performed on the web-based power grid geographic map based on the power grid vector slicing technology. Considering the editing performance problem of the web-based end, a large amount of data cannot be cached to the front end of the page for processing. The topology of the power grid equipment is a graph structure, and the power grid containers are interconnected. It is difficult to completely separate the containers. Therefore, the only way to achieve online editing is to use the method of dynamic loading and rendering according to the map viewport range. However, the existing technology has low rendering efficiency, slow data loading, and difficult equipment editing. Summary of the invention

[0003] In order to solve the deficiencies in the prior art, the present invention provides a power grid GIS data editing method and system, an electronic device, and a storage medium, which solve the problems of low graphics rendering efficiency, slow data loading and difficult device editing by using a data layering mechanism combining vector slices and GeoJSON.

[0004] The present invention adopts the following technical solution.

[0005] The first aspect of the present invention provides a power grid GIS data editing method, including: the server constructs a power grid vector slice based on the power grid GIS data, and converts the power grid equipment data into GeoJSON data; the client obtains and loads the power grid vector slice from the server, and picks up the power grid graphics from the power grid vector slice according to the location of the edited power grid equipment, and adsorbs the picked power grid graphics to the edited power grid equipment and then requests the server for the GeoJSON data of the corresponding equipment; the server queries based on the edited power grid equipment according to the request of the client, obtains the equipment associated with the edited power grid equipment, and sends the GeoJSON data of the edited power grid equipment and the associated equipment to the client; the client superimposes the power grid vector slice and the GeoJSON data of the edited power grid equipment and the associated equipment according to the editing operation on the edited network equipment obtained, and displays them in real time.

[0006] Optionally, the client obtains power grid vector slices from the server including: the client obtains parameter information of the power grid vector slices, and sends a vector slice request to the server according to the parameter information of the power grid vector slices; the server parses the received vector slice request, and generates multiple vector slices according to the parameter information obtained by the analysis and sends them to the client.

[0007] Optionally, the parameter information includes the row number, column number, map zoom level, slice generation configuration scheme and permission control parameters required for generating vector slices, and the server generates multiple vector slices according to the parameter information obtained by parsing, including: the server calculates the spatial range of the vector slice to be generated according to the row number, column number and map zoom level required for generating vector slices obtained by parsing; queries the spatial range in the spatial index information to obtain all power grid equipment data associated with the generated vector slices; deletes the power grid equipment data that does not meet the slice generation configuration scheme and map zoom level obtained by parsing, and filters the remaining power grid equipment data according to the permission control parameters obtained by parsing to obtain first power grid equipment data; generates multiple power grid vector slices based on the first power grid equipment data according to a preset vector slice data format.

[0008] Optionally, the server performs a query based on the edited power grid device according to the request of the client, and obtains the devices associated with the edited power grid device, including: the server uses a breadth-first search method to query in a pre-built power equipment topology network according to the request of the client, and obtains a first device associated with the edited power grid device topology; the server performs a business-related query based on the edited power grid device, and obtains a second device associated with the business of the edited power grid device; the first device and the second device constitute the devices associated with the edited power grid device.

[0009] Optionally, the client picks up power grid graphics from the vector slice according to the position of the edited power grid device, and adsorbs the picked up ground grid graphics to the edited device, including: using a bounding box collision detection algorithm, performing collision detection analysis on the rectangular bounding box of the moving mouse cursor and the bounding box of the sliced ​​rendered device or the original graphics of the device, and taking the bounding box of the rendered device or the original graphics of the device that meets the requirements of the rectangular bounding box of the moving mouse cursor as the picked up power grid graphics set; the mouse cursor is used to indicate the position of the edited power grid device; and selecting the power grid graphics that meet the adsorption rules in the power grid graphics set and adsorbing them to the edited power grid device.

[0010] Optionally, different bounding box calculation methods are adopted for different power grid graphic types.

[0011] Optionally, the adsorption rules include: selecting a power grid graphic with the highest adsorption weight priority in the power grid graphic set and adsorbing it to the edited power grid device; adsorption weight types include device resources, asset types and device graphic types; and / or, based on the acquired scenario of the editing operation on the edited network device, determining a corresponding adsorber to adsorb the power grid graphic to the edited power grid device.

[0012] Optionally, the absorber includes a device graphic connection point absorber and a device geometry absorber; wherein the device graphic connection point absorber is used to return the anchor point information of the operation absorption when editing the topological relationship, and the anchor point information is used to characterize the power grid point device; the device geometry absorber is used to return the geometry absorbed by the operation and its geometric calculation information when drawing the geometric relationship, and the geometric calculation information includes at least one of the center point of the geometry, the intersection of the line between the center point and the mouse and the geometry, and the orientation absorbed in the geometry.

[0013] Optionally, using the device graphic connection point absorber to absorb the power grid graphic to the edited power grid device includes: deleting the surface graphics in the picked power grid graphic set, retaining the point graphics and line graphics, and instantiating the anchor point objects contained in all retained point graphics and the terminal objects of the line graphics according to the mapping relationship between the device type and the anchor point model, to obtain an object set of all graphic connection points; calculating the longitude and latitude coordinates of the graphic connection points in the object set, and converting the longitude and latitude coordinates of the graphic connection points into screen coordinates; calculating and comparing the distance between the mouse and the screen coordinates of each graphic connection point, selecting the graphic connection point closest to the distance, and reverse indexing according to the selected graphic connection point information to obtain the information of the absorbed power grid device.

[0014] Optionally, using the device geometry absorber to absorb the power grid graphics to the edited power grid device includes: deleting the point graphics in the picked power grid graphics set, retaining the line graphics and the surface graphics; according to the plane geometry intersection algorithm, performing intersection calculations on the rectangular bounding box of the moving mouse cursor and the retained line graphics and the surface graphics in turn; according to the type of the device geometry absorber, evaluating the intersection calculation results to obtain an evaluation value, wherein the types of the device geometry absorber include device line graphics absorbers and device surface graphics absorbers; selecting the line graphics or point graphics corresponding to the highest evaluation value to absorb to the edited power grid device.

[0015] Optionally, when multiple types of absorbers are used simultaneously, an absorber queue is set, and the absorber queue includes all absorbers required for the editing operation and the corresponding sequence; the absorber corresponding to the editing scene is selected from the absorber queue for the absorption operation.

[0016] Optionally, when constructing power grid vector slices based on power grid GIS data, the vector slice layers are named using "layer_layer id_layer type_voltage level"; wherein the layer id is the classid value pre-assigned to each power grid equipment type, which is used to describe the classification information of the power grid equipment type; the layer type includes point symbol layers, line layers and surface layers according to the display form of the power grid equipment; the voltage level corresponds to the voltage value of the power grid equipment, which is used to realize the classification control of the power grid equipment whose power grid equipment type is off-site type; the power grid equipment data includes the attribute values ​​of each power grid vector slice layer, and the attribute values ​​include at least one of general attributes, symbol device attributes and line device attributes.

[0017] Optionally, the line device attributes of the vector tile include the start point coordinates and the end point coordinates of the line.

[0018] Optionally, after the client performs the display, the method further includes: the server performs a corresponding update on the database storing the GeoJSON data and the power grid vector slices based on the editing results received from the client.

[0019] The second aspect of the present invention provides a power grid GIS data editing system using the above method, including a server and a client. The server is used to construct a power grid vector slice based on the power grid GIS data, and convert the power grid equipment data into GeoJSON data; the client is used to obtain and load the power grid vector slice from the server, and pick up the power grid graphics from the power grid vector slice according to the location of the edited power grid equipment, and after adsorbing the picked power grid graphics to the edited power grid equipment, request the GeoJSON data of the corresponding equipment from the server; the server is used to query based on the edited power grid equipment according to the request of the client, obtain the equipment associated with the edited power grid equipment, and send the GeoJSON data of the edited power grid equipment and the associated equipment to the client; the client is used to superimpose the power grid vector slice and the GeoJSON data of the edited power grid equipment and the associated equipment according to the edit operation on the edited network equipment obtained, and then display them in real time.

[0020] Optionally, when the client is used to obtain and load power grid vector slices from the server, it includes: the client obtains parameter information of the power grid vector slices, and sends a vector slice request to the server according to the parameter information of the power grid vector slices; the client accepts the server to parse the received vector slice request, and generates multiple vector slices according to the parameter information obtained by the analysis and sends them to the client.

[0021] Optionally, when the server is used to generate multiple vector slices according to the parameter information obtained by parsing, it includes: the server calculates the spatial range of the vector slice to be generated according to the row number, column number and map zoom level required for generating the vector slice obtained by parsing; the spatial range is queried in the spatial index information to obtain all power grid equipment data associated with the generated vector slice; the server deletes the power grid equipment data that does not meet the slice generation configuration scheme and map zoom level obtained by parsing from all the power grid equipment data associated with the generated vector slice, and filters the remaining power grid equipment data according to the permission control parameters obtained by parsing to obtain the first power grid equipment data; the server generates multiple power grid vector slices based on the first power grid equipment data according to a preset vector slice data format; wherein the parameter information includes the row number, column number, map zoom level, slice generation configuration scheme and permission control parameters required for generating the vector slice.

[0022] Optionally, the server is used to query based on the edited power grid device according to the request of the client to obtain devices associated with the edited power grid device, including: the server uses a breadth-first search method to query in a pre-built power equipment topology network according to the request of the client to obtain a first device associated with the edited power grid device topology; the server performs a business association query based on the edited power grid device to obtain a second device associated with the business of the edited power grid device; the first device and the second device constitute the devices associated with the edited power grid device.

[0023] Optionally, the client is used to pick power grid graphics from the power grid vector slice according to the position of the edited power grid device, and adsorb the picked power grid graphics to the edited power grid device, including: the client adopts a bounding box collision detection algorithm, performs collision detection analysis on the rectangular bounding box of the moving mouse cursor and the bounding box of the rendered device or the original graphics of the device in the power grid vector slice, and takes the bounding box of the rendered device or the original graphics of the device that meets the requirements of the rectangular bounding box of the moving mouse cursor as the picked power grid graphics set; the mouse cursor is used to indicate the position of the edited network device; the client selects the power grid graphics that meet the adsorption rules in the power grid graphics set and adsorbs them to the edited power grid device.

[0024] Optionally, the client is used to adopt different bounding box calculation methods for different power grid graphics when picking power grid graphics from power grid vector slices according to the location of the edited power grid equipment.

[0025] Optionally, the adsorption rules adopted by the client include: the client selects the power grid graphic with the highest adsorption weight priority in the power grid graphic set and adsorbs it to the edited power grid device; the adsorption weight types include device resources, asset types and device graphic types; and / or the client determines the corresponding adsorber to adsorb the power grid graphic to the edited power grid device based on the acquired scenario of the editing operation on the edited network device.

[0026] Optionally, the client includes an absorber for absorbently attaching a power grid graphic to an edited power grid device, the absorber including a device graphic connection point absorber and a device geometry absorber; wherein the device graphic connection point absorber is used to return anchor point information of the operation absorption when editing a topological relationship, and the anchor point information is used to characterize the power grid point device; the device geometry absorber is used to return the geometry absorbed by the operation and its geometry calculation information when drawing a geometric relationship, and the geometry calculation information includes at least one of the center point of the geometry, the intersection of the line between the center point and the mouse and the geometry, and the orientation absorbed on the geometry.

[0027] Optionally, the client is used to use the device graphic connection point absorber to absorb the power grid graphic to the edited power grid device, including:

[0028] The client deletes the surface graphics in the picked power grid graphics set, retains the point graphics and line graphics, and instantiates the anchor point objects contained in all the retained point graphics and the terminal objects of the line graphics according to the mapping relationship between the equipment type and the anchor point model, and obtains the object set of all graphic connection points; the client calculates the longitude and latitude coordinates of the graphic connection points in the object set, and converts the longitude and latitude coordinates of the graphic connection points into screen coordinates; the client calculates and compares the distance between the mouse and the screen coordinates of each graphic connection point, selects the graphic connection point closest to it, and reversely indexes according to the selected graphic connection point information to obtain the information of the adsorbed power grid equipment.

[0029] Optionally, when the client is used to use the device geometry absorber to absorb the power grid graphics to the edited power grid device, it includes: the client deletes the point graphics in the picked power grid graphic set, and retains the line graphics and the surface graphics; the client performs intersection calculations on the rectangular bounding box of the moving mouse cursor and the retained line graphics and the surface graphics in turn according to the plane geometry intersection algorithm; the client evaluates the intersection calculation results according to the type of the device geometry absorber to obtain an evaluation value, wherein the types of device geometry absorbers include device line graphics absorbers and device surface graphics absorbers; the client selects the line graphics or point graphics corresponding to the highest evaluation value and absorbs it to the edited power grid device.

[0030] Optionally, when the client adsorbs the power grid graphic to the edited power grid device, it includes: when multiple types of adsorbers are used at the same time, an adsorber queue is set on the client, and the adsorber queue includes all adsorbers required for the editing operation and the corresponding order; the client selects the adsorber corresponding to the editing scene in the adsorber queue for the adsorption operation.

[0031] Optionally, when the client is used to construct power grid vector slices based on power grid GIS data, it uses "layer_layer id_layer type_voltage level" to name the vector slice layer; wherein the layer id is the classid value pre-assigned to each power grid equipment type, which is used to describe the classification information of the power grid equipment type; the layer type includes point symbol layers, line layers and surface layers according to the display form of the power grid equipment; the voltage level corresponds to the voltage value of the power grid equipment, which is used to realize the classification control of the power grid equipment whose power grid equipment type is off-site type; the power grid equipment data includes the attribute values ​​of each power grid vector slice layer, and the attribute value includes at least one of the general attributes, symbol device attributes and line device attributes.

[0032] Optionally, the server is also used to update the database storing GeoJSON data and power grid vector slices accordingly based on the editing results received from the client.

[0033] The third aspect of the present invention provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program implements the above-mentioned power grid GIS data editing method when loaded into the processor.

[0034] A fourth aspect of the present invention provides a computer-readable storage medium storing a computer program, which implements the above-mentioned power grid GIS data editing method when executed by a processor.

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

[0036] The present invention slices large-scale spatial data according to geographic coordinates through vector slicing. Each slice contains data within a small range. In this way, when rendering, only the slice data within the current view range needs to be loaded and drawn, rather than the entire data set, thereby greatly reducing the amount of data that needs to be processed. At the same time, the size of the slice data is fixed, and it can be quickly transmitted and rendered, reducing the delay when the view changes, and achieving a smoother user experience. GeoJSON supports rich attribute data, can flexibly add and modify the attribute information of the device, and is convenient for use in combination with vector slices, further improving the efficiency of graphics rendering.

[0037] The present invention stores the power grid equipment data in GeoJSON format, and uses the geospatial query capability of MongoDB to implement fast range query, proximity query and other complex spatial query operations, thereby reducing data loading time. Vector slice data can be pre-generated and stored in MongoDB, and the client loads the corresponding slice data as needed, avoiding a large number of I / O operations during each loading. Utilizing the characteristics of vector slices, the client only needs to transmit and render the changed slices after the initial loading to achieve incremental updates, further reducing the amount of network transmission. At the same time, since the amount of data for each slice is small, the pressure on network transmission is greatly reduced, and a faster data loading speed can be guaranteed even in a low-bandwidth or high-latency network environment.

[0038] The present invention integrates the business rules of the power grid into the editing tool, automatically processes the spatial relationship and topological relationship between devices, and reduces the workload of manual adjustment by users. The editing tool based on GeoJSON and vector slices can realize real-time feedback, and users can immediately see the preview effect of the modification when editing, which improves the editing experience. Using vector slice technology, users can edit devices within a more detailed view range, reducing the complexity of editing operations. Slices can be cached and locally edited on the client, which improves the response speed of editing. MongoDB supports concurrent writing and data synchronization, and combined with vector slice technology, real-time collaborative editing of multiple users can be realized. The data edited by each user is processed in slices, reducing data conflicts and the difficulty of synchronous updates. Through version control and differential storage of GeoJSON data, the editing operations of multiple users can be effectively managed and merged to ensure data consistency. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for describing the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative labor. Among them:

[0040] Figure 1 It is a schematic diagram of each layer set of a power grid GIS data editing system provided by an embodiment of the present invention;

[0041] Figure 2 is a schematic diagram of a flowchart for obtaining and generating vector slices provided by an embodiment of the present invention;

[0042] Figure 3 It is a schematic diagram of a pickup adsorption flow chart provided by an embodiment of the present invention;

[0043] Figure 4is a schematic diagram of an anchor point model of a transformer device provided by an embodiment of the present invention;

[0044] Figure 5 It is a schematic diagram of a flow chart of dynamic loading of device data provided by an embodiment of the present invention;

[0045] Figure 6 It is a schematic diagram of a logic flow chart of a topology search provided by an embodiment of the present invention;

[0046] Figure 7 It is a schematic diagram of a power equipment topology network provided by an embodiment of the present invention;

[0047] Figure 8 is a schematic diagram of a physical rod-operating rod model provided by an embodiment of the present invention;

[0048] Fig. 9 It is a schematic diagram of a line-substation-line model provided by an embodiment of the present invention;

[0049] Fig.10 It is a schematic diagram of a hierarchical architecture of a power grid GIS data editing system provided by an embodiment of the present invention;

[0050] Fig.11 It is a schematic diagram of a rendering speed curve comparison diagram provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical scheme and advantages of the present invention clearer, the technical scheme of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. The embodiments described in this application are only part of the embodiments of the present invention, not all of them. Based on the spirit of the present invention, other embodiments obtained by ordinary technicians in this field without creative work are all within the scope of protection of the present invention.

[0052] Vector slicing is a technology that slices and organizes geospatial data according to specific rules. It can be efficiently transmitted and rendered in a network environment. It can efficiently store geographic features such as points, lines, and surfaces by pre-slicing. It provides a wealth of geospatial query functions, such as geographic proximity query and spatial range query, and can quickly locate and retrieve the required power grid equipment data. GeoJSON is a geospatial data format based on JavaScript Object Notation (JSON). It has a simple format, is easy to read, and is easy to parse. It is suitable for data transmission and display in a Web environment. By converting power grid equipment data into GeoJSON format, standardized data management can be achieved, which facilitates data exchange and sharing between different systems.

[0053] Combination Figure 1As shown, the power grid GIS data editing system includes a power grid vector slice layer set, a geographic background layer set and an editing layer set. The geographic background layer set includes the gray base map and road grid at the bottom of the viewport. The power grid vector slice layer set includes the rendered power grid network data reference except the loaded editing layer data in the viewport. Figure 1 The size of the white box area next to the power grid vector tile layer set is displayed in the form of vector tiles superimposed on the geographic background layer set. The editing layer set includes the data picked up from the power grid and edited. The relevant data in the original power grid vector tile layer set will be hidden and rendered according to the data in the editing process.

[0054] based on Figure 1 A power grid GIS data editing system, embodiment 1 of the present invention provides a power grid GIS data editing method, comprising the following steps:

[0055] Step 1: The server constructs power grid vector slices based on power grid GIS data and converts power grid equipment data into GeoJSON data.

[0056] Specifically, the power grid vector slice is built based on the MVT (Mapbox Vector Tile) vector slice specification, which has the characteristics of faster generation speed, smaller slice size, and higher compression rate. Based on the basic principles of vector slices, combined with the professional classification, equipment type, equipment voltage level, and equipment display level requirements of power grid equipment, the layer classification, layer naming, and layer properties in the vector slice are designed to achieve efficient browsing of massive power grid data on the Web, providing efficient support for large-scale online editing of power grid GIS data.

[0057] In a preferred but non-limiting embodiment, the layer names in the vector slices are generally named in the format of "layer_layer id_layer type_voltage level". The layer id corresponds to the classid value pre-assigned to each type of power grid equipment, which is used to describe the specific classification information of the power grid equipment type; the layer type includes three types according to the display form of the power grid equipment, namely, point symbol layer, line layer and surface layer, with values ​​of 1 for point symbol layer, 2 for line layer and 3 for surface layer; the voltage level corresponds to the voltage value of the equipment, where direct current is expressed using negative values, such as 500000 for AC 500kV and -500000 for DC 500kV, which is used to implement classified control of power grid equipment of the off-site type. For the on-site type of power grid equipment, hierarchical control is not required according to the voltage level, and the voltage level is uniformly taken as 0, indicating that the voltage level attribute is ignored.

[0058] Going a step further, a typical layer naming example is as follows:

[0059] 1) 220kV substation layer: layer_110_1_220000

[0060] Among them, 110 represents the layer classid of the substation, 1 represents the point symbol layer, and 220000 represents that the voltage level of the substation is 220kV.

[0061] 2) 1000kV AC transmission line layer: layer_200_2_1000000

[0062] Among them, 200 represents the layer classid of the transmission line, 2 represents the line type layer, and 1000000 represents that the voltage level of the transmission line is 1000kV.

[0063] 3) 10kV distribution room layer: layer_333_3_10000

[0064] Among them, 333 represents the layer classid of the distribution room, 3 represents the surface type layer, and 10000 represents that the voltage level of the distribution feeder is 10kV.

[0065] 4) Circuit breaker layer in the distribution station: layer_433_1_0

[0066] Among them, 433 represents the classid of the circuit breaker layer in the distribution station, 1 represents the point symbol layer, and 0 means that the layer does not need to be divided by voltage level.

[0067] The encoding of the device layer classid is classified according to the segmentation rules. The specific segmentation rules are shown in Table 1:

[0068] Table 1

[0069]

[0070] The power grid equipment covers many types of equipment and follows the coding segmentation rules. The following lists the allocation of classids of some layers, as shown in Table 2:

[0071] Table 2

[0072] Layer id Type Name Layer id Type Name 100 power plant 300 Distribution feeder 107 Switching Station 301 Distribution feeder segmentation lines 108 Series compensation station 302 Power distribution cable 109 Converter Station 303 Distribution overhead lines 110 Substation 310 Distribution overhead line segment 111 Station building address 311 Distribution cable section 125 Busbar section in substation 312 Power distribution electrical connection wire 128 Electrical connection lines in substation 313 Power distribution super connection line 135 Substation internal and external connection points 314 Distribution transformer monitoring instrument on distribution column ... ... ... ... 200 Transmission Lines 500 Low voltage area 201 Transmission Section Line 501 Low voltage line branch 202 Transmission cable 510 Low voltage overhead line segment 203 Overhead transmission lines 511 Low voltage cable section 210 Overhead transmission line 512 Low voltage electrical connection wire 211 Transmission cable segment 513 Low voltage ultra-connector 212 Transmission electrical connection line 517 Low voltage cable terminal 213 Transmission super link 519 Low voltage user access point 219 High voltage user access point 520 Low voltage distribution box ... ... ... ...

[0073] Furthermore, the attribute values ​​in the power grid vector slice layer are related to the front-end display style of the power grid equipment and the realization of the editing function of the power grid equipment. The attributes of each device layer mainly include:

[0074] Common attributes: resource id, resource type, device name, device abbreviation, voltage level, layer id, topological connection relationship, main distribution network identification, etc. The device abbreviation is used to display the simplified device name at a small scale to improve the display effect of device annotation; the device name is used to display the full name of the device at a large scale; the voltage level is used to determine the color of the device rendering; the main distribution network identification is used to determine the main distribution network information to which the device belongs; the topological connection relationship is used to assist in the topological linkage of power grid equipment during data editing;

[0075] Symbol device attributes: symbol id, symbol frame, symbol size, symbol angle, etc. Symbol id is used to determine the type of symbol, such as circuit breaker; symbol frame is used to determine the specific state of the symbol, such as the open or closed state of the circuit breaker; symbol angle and symbol size are used to determine the size and rotation angle of the symbol display;

[0076] Line device properties: start point coordinates, end point coordinates, etc. Stores the start point and end point coordinates of line type devices to support the adsorption of line type devices during device editing.

[0077] In a preferred but non-limiting embodiment, MongoDB is used to store the power grid vector slices and power grid equipment data of this embodiment, and the power grid equipment data is stored in GeoJSON format. In this way, the geospatial query capability of MongoDB is used to implement fast range query, proximity query and other complex spatial query operations, reducing data loading time and improving data loading speed.

[0078] Step 2: The client obtains and loads the power grid vector slice from the server, and picks the power grid graphics from the power grid vector slice according to the location of the edited power grid device. After adsorbing the picked power grid graphics to the edited power grid device, the client requests the GeoJSON data of the corresponding device from the server.

[0079] Optionally, in step 2, the client obtains the power grid vector slice from the server, including: the client obtains parameter information of the power grid vector slice, and sends a vector slice request to the server according to the parameter information of the power grid vector slice, the server parses the received vector slice request, and generates multiple vector slices according to the parameter information obtained by the analysis and sends them to the client.

[0080] Specifically, the parameter information includes the row number, column number, map zoom level, tile generation configuration scheme, and permission control parameters required to generate vector tiles.

[0081] Optionally, the server generates multiple vector slices based on the parameter information obtained by parsing, including: calculating the spatial range of the vector slice to be generated by the server based on the row number, column number and map zoom level required for generating the vector slice; querying the spatial range in the spatial index information to obtain all power grid equipment data associated with the generated vector slice; deleting the power grid equipment data that does not meet the slice generation configuration scheme and map zoom level obtained by parsing from all the power grid equipment data associated with the generated vector slice, and filtering the remaining power grid equipment data according to the permission control parameters obtained by parsing to obtain the first power grid equipment data; and generating multiple power grid vector slices based on the first power grid equipment data in accordance with a preset vector slice data format.

[0082] Specifically, in order to improve the display effect of power grid data and the performance of vector slice generation, it is necessary to formulate power grid slice data generation specifications according to the equipment voltage level and equipment type, reduce the amount of data when generating slices, and achieve high-performance layered display of power grid data.

[0083] The general principle is that when the map zoom level is small, only high-voltage transmission lines and substations are displayed. As the map is continuously enlarged, grid data of lower voltage levels are displayed step by step, realizing the display of all grid data from DC 1100kV to low voltage 380V. The configuration rules for the generation of main container equipment are shown in Table 3:

[0084] Table 3

[0085]

[0086]

[0087] Optionally, the method further includes: when the vector slice service is started, according to the configuration information of the configuration file, the power grid equipment data in the power grid database is loaded into the memory according to the rules, and the data is preprocessed to convert into a memory device object containing coordinates, attributes, topology and other information. And the spatial index information of the device object is created according to the coordinate information to facilitate the rapid spatial query of the device.

[0088] like Figure 2 As shown in the figure, the logic for obtaining and generating vector tiles is as follows:

[0089] The client generates parameters for obtaining vector tiles through calculations and sends the parameters to the service through an HTTP request.

[0090] The service receives the client request and parses the client-specified parameters from the request, including row number, column number, scale, permission parameters, etc.

[0091] Generate multiple vector slices for the queried power grid equipment based on spatial scope, configuration scheme, spatial index, permission control, etc.;

[0092] Calculate the spatial range of the slice to be generated based on the slice row and column numbers and map level parameters;

[0093] Based on the spatial range, all power grid equipment involved in generating slices can be quickly queried in combination with spatial indexes;

[0094] According to the slice generation configuration scheme and the current map zoom level, filter out the power grid equipment that does not meet the client display scheme requirements under the current map viewport;

[0095] According to the authority control parameters, such as the operation and maintenance unit information, the above-screened data is further filtered to determine all the grid equipment data required for the final generation of the slice;

[0096] Generate and return power grid vector slices according to the vector slice data format;

[0097] The vector slices are sent to the client, and the client combines the layer style configuration file to display the power grid equipment.

[0098] Optionally, in step 2, the client picks up a power grid graphic from the power grid vector slice according to the position of the edited power grid device, and adsorbs the picked up power grid graphic to the edited power grid device, including: the client uses a bounding box collision detection algorithm to perform collision detection analysis on the rectangular bounding box of the moving mouse cursor and the bounding box of the sliced ​​rendered device or the original device graphic, and takes the bounding box of the rendered device or the original device graphic that meets the rectangular bounding box of the moving mouse cursor as the picked up power grid graphic set; the mouse cursor is used to indicate the position of the edited network device. The power grid graphic that meets the adsorption rule is selected from the power grid graphic set and adsorbed to the edited power grid device.

[0099] Specifically, combined Figure 3 , Figure 4 As shown in the figure, graphic picking is to accurately obtain the device to be edited from the vector slice according to the specific position of the mouse to enter the next editing operation. Adsorption is to be able to adsorb to different power grid devices according to a certain priority during the editing process, build accurate device connection relationships, and realize accurate and fast power grid equipment editing. The picking and adsorption function plays a key role in many aspects of the power grid graphic editing function, and different editing modes have different requirements for device picking and adsorption.

[0100] The editing requirements for power grid graphics can be roughly divided into the editing of topological connection relationships and the editing of geometric relationships. The editing of topological connection relationships includes drawing connecting lines, disconnecting one end of connecting lines, continuously drawing power grid equipment, and switching connection points of power grid equipment. The editing of geometric relationships is common in operations such as dragging equipment to move, rotating equipment angles, dragging station house rectangles to scale, and drawing running poles within the range of physical pole graphics.

[0101] More specifically, according to the following steps, anchor point modeling for any type of grid point equipment graphics includes: numbering and recording the anchor points contained in each type of equipment. Constructing an internal plane coordinate system of the equipment to locate and record the anchor point coordinates of the equipment. The mapping relationship between the equipment type and the anchor point model is stored in the form of a coordinate array, and the array subscript represents the anchor point sequence number.

[0102] It should be noted that the element 0 of the array has a special meaning, that is, the center point of the device, not the anchor point, and coincides with the actual coordinate point of the device.

[0103] Preferably, different bounding box calculation methods are adopted for different types of power grid graphics.

[0104] Specifically, through the established equipment type-anchor point model mapping relationship, it can be seen that the graphic bounding box of the power grid point equipment is actually a rectangular bounding box determined by its center coordinates and one or more anchor points corresponding to the equipment type. Secondly, the terminal coordinates of the line equipment are the starting and ending points of its own line graphics, so there is no need to calculate the bounding box, and it can directly participate in the collision detection analysis. Finally, the surface types in the power grid equipment, such as the substation building frame graphics, although they do not have the attributes of graphic topology connection points, there are still editing scenes of geometric relationships, so they also participate in the collision detection picking analysis. Within the scope of the above three types of graphics, the device bounding box or device graphics that are contained, contained or intersected by the mouse bounding box are regarded as the equipment picked up this time and returned.

[0105] Optionally, the adsorption rule includes: selecting a power grid graphic with the highest adsorption weight priority from the power grid graphic set and adsorbing it to the edited power grid device; the weight types include device resources, asset types and device graphic types.

[0106] For example, the adsorption weights of different types of devices are pre-processed in the picking stage, and one or more, or one or more devices of the highest weight type in the picked device set are always retained, and different weight types can exist at the same time. In this way, the friendliness and ease of use of the interaction can be improved.

[0107] Specifically, weight types include but are not limited to:

[0108] (1) Equipment resources and asset types, such as giving priority to adsorbing pole-mounted transformers and operating pole towers (resources), and not allowing adsorption of physical poles (assets), etc.

[0109] (2) Equipment graphic type, for example, line type equipment (lines) are preferentially adsorbed, polygon type equipment (station room frame graphics) is not allowed to be adsorbed, etc.

[0110] Optionally, the adsorption rule includes: determining a corresponding adsorber to perform an adsorption operation according to a scenario of the editing operation.

[0111] Optionally, the absorber includes a device graphic connection point absorber and a device geometry absorber; wherein the device graphic connection point absorber is used to return the anchor point information of the operation absorption when editing the topological relationship; the device geometry absorber is used to return the geometry absorbed by the operation and its geometric calculation information when drawing the geometric relationship, and the geometric calculation information includes the center point of the geometry, the intersection of the line between the center point and the mouse and the geometry, and the orientation absorbed on the geometry.

[0112] Optionally, using the device graphic connection point absorber to perform an absorption operation includes: deleting the surface graphics in the picked power grid graphic set, retaining the point graphics and line graphics, and instantiating the anchor point objects contained in all retained point graphics and the terminal objects of the line graphics according to the mapping relationship between the device type and the anchor point model, to obtain an object set of all graphic connection points; calculating the longitude and latitude coordinates of the graphic connection points in the object set, and converting the longitude and latitude coordinates of the graphic connection points into screen coordinates; calculating and comparing the distance between the mouse and the screen coordinates of each graphic connection point, selecting the closest graphic connection point, and reverse indexing according to the graphic connection point information to obtain the information of the absorbed power grid equipment.

[0113] Specifically, first remove the surface graphics in the pick set, and keep the point graphics and line graphics. According to the device information picked above and the relationship between the device type and the anchor point model, instantiate the anchor point objects contained in all picked point devices and the terminal objects of the line devices, and obtain the set of all graphic connection point objects.

[0114] Then the coordinates of the graphic connection points are calculated. The actual WGS84 coordinates of each anchor point are calculated by combining the device-anchor model with the center point coordinates, device symbol angle, symbol size and other geometric parameters.

[0115] The WGS84 coordinates of the terminal are calculated using the terminal number information and the starting point coordinates of the line device.

[0116] The longitude and latitude coordinates of the graphic connection points are converted to screen coordinates. The map engine of the embodiment of the present invention uses the web Mercator projection. The web Mercator coordinates can be obtained according to the WGS84-webMercator coordinate conversion algorithm, and the screen pixel coordinates are further calculated. The plane distance calculation is mainly based on the following two factors: (1) The distance calculation directly in the longitude and latitude spherical coordinate system is relatively complicated. (2) The distance between the anchor points inside the device is very close, and the calculation error caused by ignoring the curvature of the earth's spherical surface is negligible.

[0117] Finally, the distance between the mouse and the screen pixel coordinates of each graphic connection point is calculated and compared, and the nearest and most prioritized graphic connection point is obtained in combination with the adsorption rule. At the same time, the information of the adsorbed device is obtained by reverse indexing the graphic connection point information.

[0118] according to Figure 4 As shown, suppose the actual device graph of the transformer is: l, and its type - anchor model is: L, then: L.anchors = [(0.5,0.5), (0.5,0.0), (0.5,1.0)],

[0119] The known WGS84 coordinates of the device and its actual size are:

[0120] l.WGS84={lng:a,lat:b},l.size=x(m),

[0121] Get the web Mercator coordinates lw of the device:

[0122] lw=translateFromWSG84toWebMercator(l.WGS84)

[0123] The current arbitrary anchor point of the device can be obtained:

[0124] A n ={index:n,w:{lng:a-0.5*x+x*L.anchors[n][0],lat:b-0.50.5*x+x*L.anchors[n][1]}}

[0125] The anchor point pixel coordinates P can be obtained by the mapbox#project method n :

[0126] P n =map.project(A n [w])

[0127] Finally, the nearest adsorption anchor is obtained m :

[0128] P m=Math.min(P1,P2,......P n ), anchor m =L.anchors[m].

[0129] Optionally, the device geometry absorber includes a device line geometry absorber and a device surface geometry absorber, and the absorption operation using the device geometry absorber includes: deleting the point graphics in the picked power grid graphics set, retaining the line graphics and surface graphics; according to the plane geometry intersection algorithm, performing intersection calculations on the rectangular bounding box of the moving mouse cursor and the picked line graphics and surface graphics in turn; according to the type of the device geometry absorber, evaluating the intersection calculation results to obtain an evaluation value; selecting the line graphics or point graphics corresponding to the highest evaluation value to absorb to the edited power grid equipment.

[0130] Specifically, the intersection calculation will render the corresponding calculation results in a special way, and users can view the device that will be selected after clicking in real time based on the rendering differences. The corresponding geometric absorber develops different absorption strategies and absorption weights according to the graphic type, and absorbs according to the final scoring results.

[0131] Optionally, when multiple types of absorbers are used simultaneously, an absorber queue is set, and the absorber queue includes all absorbers required for the editing operation and the corresponding sequence; the absorber corresponding to the editing scene is selected from the absorber queue for the absorption operation.

[0132] Specifically, in practical applications, it is necessary to take into account multiple editing scenarios at the same time. For example, tower drawing operations, such as Figure 4 The operator may edit the topological connection relationship of the graph, such as editing the connection line to connect the existing running rod, or may edit the geometric relationship, such as creating a new running rod to absorb the physical rod. The embodiment of the present invention designs a variety of absorbers that can be used synchronously, and sets an absorber queue. The queue can define all absorbers and their order when editing, and traverse the queue to perform absorption operations one by one until the absorption operation obtains a valid analysis result or returns when the traversal is completed.

[0133] Step 3: The server queries the edited power grid device according to the client's request, obtains the devices associated with the edited power grid device, and sends the GeoJSON data of the edited power grid device and the associated devices to the client.

[0134] For example, when requesting data for edited power grid equipment, in order to ensure the integrity of data maintenance, the devices topologically connected to the edited power grid equipment and the devices associated with the business will also be requested. For example, a request for a substation will request the station house data, the data of the equipment inside the station, and the data of the connection lines between the station house and the equipment outside the station, so that when the station house is moved, the equipment and lines inside the station will move with it.

[0135] Combination Figure 5 As shown, Figure 5 The front end is the client. After the client loads the power grid vector slice, it determines whether the user clicks on the element, that is, performs an editing operation, based on the obtained user operation (such as roaming). If not, it continues to obtain the user operation. If so, it determines whether to request data from the server. If not, it continues to obtain the user operation. If so, the client sends a request to the server to obtain the GeoJSON data of the corresponding element. The server queries the power grid equipment database based on the edited element according to the client's request. The power grid data database stores the power grid equipment data in GeoJSON format. The server sends the queried GeoJSON data to the client. After receiving the GeoJOSN data, the client determines whether the user performs an editing operation. If not, it continues to obtain the user operation. If so, it obtains the user's editing operation. The client saves the editing result and sends it to the server, and the server updates the database according to the editing result.

[0136] The present invention supports real-time editing operations by reloading vector data (such as GeoJSON format) for superposition. At the same time, the performance limitations of client data storage and many factors such as interface access and transmission time must be fully considered. The amount of data requested should not be too large, and it should not be requested frequently. Instead, when a specific operation or situation is triggered, the required data should be accurately obtained to avoid overloading the system. However, the requested data must fully cover the key information required for the current editing operation, strive to achieve the ideal state of "small and complete", and dynamically request and load on demand.

[0137] In actual applications, during editing, there is a memory that stores the rendered static grid data. At the same time, the edited data is stored independently. The edited data is superimposed on the static grid in the memory for display, and the data before some changes on the static grid is hidden.

[0138] In this way, data can be edited on demand without affecting the original functions, saving bandwidth resources, reducing network transmission pressure, avoiding unnecessary data transmission, and greatly improving the utilization efficiency of network resources. It also reduces the pressure on front-end storage, can accurately obtain relevant data according to the user's specific behavior and scenarios, avoids unnecessary data processing and storage, and improves the utilization of system resources. In addition, it can flexibly adapt to changes in demand. When the data structure or content changes, only the dynamically loaded part needs to be updated, without reloading and deploying the entire page, which facilitates rapid iteration and maintenance.

[0139] Optionally, the server performs a query based on the edited power grid device to obtain devices associated with the edited power grid device, including:

[0140] Step 3.1: The server uses a breadth-first search method to query the pre-built power equipment topology network according to the request of the client to obtain the first device associated with the edited power grid equipment topology.

[0141] Specifically, the topological linkage of data refers to the inherent relationship and mutual influence between data. In the power grid system, the state change of a substation may trigger data changes in the connected transmission lines, transformers and other equipment. In this case, the on-demand dynamic data loading mechanism needs to be able to keenly perceive this topological linkage relationship so as to load related data comprehensively and timely. Figure 6 Specifically, find the graph where the starting point is located, build a node processing queue, put the starting point into the node processing queue, get the node and graph from the node processing queue, determine whether the node is a boundary node, if so, further determine whether it is connected to other graphs, if connected to other graphs, find the graph and node connected to it and put it into the node processing queue to continue tracking the next one, if the node is not a boundary node, continue to track the next node until the node processing queue is empty and stop tracking.

[0142] The loaded data can be used to store the terminal numbers of the power equipment in the network, and the power equipment topology network can be constructed based on the terminal numbers. According to the number of terminal numbers, the power equipment can be divided into the following categories:

[0143] (1) Single-terminal equipment: has only one terminal, such as running pole, busbar, access point, etc.

[0144] (2) Multi-terminal equipment: The number of terminals is greater than one, such as transformers, switches, etc.

[0145] If two devices have duplicate terminal numbers, they are considered to be directly topologically connected.

[0146] like Figure 7 As shown in the figure, A, E, and G are multi-terminal devices, C and I are single-terminal devices, and B, F, H, and E are connecting lines. In particular, the connecting lines of single-terminal devices are also directly connected. For example, the connecting lines B, D, and F of device C are also directly connected from the terminal number. Therefore, when encountering a single-terminal device during topology tracing, it is necessary to obtain the adjacent devices of the single-terminal device and subtract them from the path.

[0147] After the topology network is constructed, a topology search algorithm is constructed and implemented using the breadth-first search (BFS) method. This eliminates the need to completely traverse a route before accessing data on other routes, thus reducing performance waste.

[0148] Specifically, a source point performs a breadth-first search on unvisited features and returns a trajectory from the source point feature to the end point feature. The trajectory returned here is a shortest trajectory.

[0149] Step 3.2: The server performs a service association query based on the edited device to obtain a second device associated with the service of the edited device.

[0150] Specifically, since containers are associated with each other, when loading data to the client by container, if the associated opposite container is not loaded to the local computer, data will be left hanging. A container is a collection of equipment, which includes equipment entities, such as substations, and lines. There are several types of associations between containers:

[0151] (1) Same pole

[0152] like Figure 8 The two lines shown, line 1 and line 2, share the same physical pole, i.e., the same pole. The corresponding query logic is: when the query container is a transmission line (same for DC transmission lines), when there is a same pole in the line, there are two cases: if there is a running pole on line 1, under the premise of querying the current container graphic resources, it is also necessary to query the physical pole to which the running pole belongs and the running poles and adjacent equipment information of other lines on the physical pole; if there is a physical pole on line 2, under the premise of querying the current container graphic resources, it is also necessary to query the running poles and adjacent equipment information of other lines on the physical pole.

[0153] (2) Lines and stations (substations, converter stations, etc.)

[0154] Query logic: When the query container is a substation, it is necessary to query the substation inlet and outlet part to the first point device outside the station, such as Fig. 9 As shown, when querying the substation container, the tower 1, the super-connected line 1, the super-connected line 2, and the tower 2 need to be queried and returned together. The line in the figure represents a broad concept including transmission lines, DC transmission lines, and feeders.

[0155] Step 3.3: The first device and the second device form a device associated with the edited device.

[0156] Step 4: The client superimposes the grid vector slices and the GeoJSON data of the edited grid equipment and related training equipment according to the edit operation on the edited grid equipment, and displays them in real time.

[0157] Specifically, users can perform various editing operations on the loaded data, such as modification, addition, deletion, etc. The client will capture the user's operation in real time and send the edited results to the server in a specific format and protocol.

[0158] For user operations, the following editing scenarios can be summarized: dragging equipment to link associated line equipment, dragging pole-mounted equipment, dragging station houses, and dragging equipment connected to hyperlink lines.

[0159] After the vector data arrives at the client, the client establishes a connection with the data based on the pre-configured layers, and the style is driven by the data. The vector slices and the relevant operation information generated when the user clicks the device, as well as the specific requirements specified by the editing operation, such as the device identification, operation type, range and accuracy of the required data, etc. are superimposed.

[0160] By overlaying GeoJSON data on vector slices, specific areas or features can be supplemented, modified, and edited. In the process of editing power grid graphics, GeoJSON data is merged and processed with the underlying power grid vector slice data to achieve accurate display and editing. Users can maintain GeoJSON data and regenerate vector slices after maintenance, thereby achieving the effect of maintaining the power grid on a geographic map. This can not only give full play to the rendering advantages of vector slices for massive power grid data, but also load the data that needs to be edited locally as much as possible, facilitating the efficient implementation of front-end editing interaction.

[0161] Optionally, the method further includes: the server correspondingly updates the database storing the GeoJSON data and the power grid vector slices based on the received editing result sent by the client. In this way, the consistency and accuracy of the data can be improved.

[0162] In a preferred but non-limiting embodiment, the line device attributes of the vector tile separately store the starting point coordinates and the ending point coordinates of the line.

[0163] Since the terminal coordinates of line devices are always taken from the starting and ending points of line devices, the starting and ending point coordinates of the line are stored separately in the line device attributes of the slice, without the need to store the geometric data of the line device in full. This can solve the problem that in vector slices, the coordinates of line-type graphic elements will inevitably be split due to the cross-slice situation, resulting in incomplete line device graphics picking and inability to perform terminal adsorption operations. Even if the line geometry coordinates are incomplete during editing and picking, it does not affect the analysis and display of the graphic connection point absorber. This method will not significantly increase the size of the vector slice, and can effectively solve the problem of incomplete line graphics.

[0164] Embodiment 2 of the present invention provides a power grid GIS data editing system, which runs the power grid GIS data editing method described in Embodiment 1, and the system includes a server and a client.

[0165] Among them, the server is used to build power grid vector slices based on power grid GIS data and convert power grid equipment data into GeoJSON data; the client is used to obtain and load power grid vector slices from the server, and pick up power grid graphics from the power grid vector slices according to the location of the edited power grid equipment, and adsorb the picked power grid graphics to the edited power grid equipment and then request the GeoJSON data of the corresponding equipment from the server; the server is used to query based on the edited power grid equipment according to the request of the client, obtain the equipment associated with the edited power grid equipment, and send the GeoJSON data of the edited power grid equipment and associated equipment to the client; the client is used to superimpose the power grid vector slices and the GeoJSON data of the edited power grid equipment and associated equipment according to the editing operations on the edited network equipment obtained, and then display them in real time.

[0166] Optionally, when the client is used to obtain and load power grid vector slices from the server, it includes: the client obtains parameter information of the power grid vector slices, and sends a vector slice request to the server according to the parameter information of the power grid vector slices; the client accepts the server to parse the received vector slice request, and generates multiple vector slices according to the parameter information obtained by the analysis and sends them to the client.

[0167] Optionally, when the server is used to generate multiple vector slices according to the parameter information obtained by parsing, it includes: the server calculates the spatial range of the vector slice to be generated according to the row number, column number and map zoom level required for generating the vector slice obtained by parsing; the spatial range is queried in the spatial index information to obtain all power grid equipment data associated with the generated vector slice; the server deletes the power grid equipment data that does not meet the slice generation configuration scheme and map zoom level obtained by parsing from all the power grid equipment data associated with the generated vector slice, and filters the remaining power grid equipment data according to the permission control parameters obtained by parsing to obtain the first power grid equipment data; the server generates multiple power grid vector slices based on the first power grid equipment data according to a preset vector slice data format; wherein the parameter information includes the row number, column number, map zoom level, slice generation configuration scheme and permission control parameters required for generating the vector slice.

[0168] Optionally, the server is used to query based on the edited power grid device according to the request of the client to obtain devices associated with the edited power grid device, including: the server uses a breadth-first search method to query in a pre-built power equipment topology network according to the request of the client to obtain a first device associated with the edited power grid device topology; the server performs a business association query based on the edited power grid device to obtain a second device associated with the business of the edited power grid device; the first device and the second device constitute the devices associated with the edited power grid device.

[0169] Optionally, the client is used to pick power grid graphics from the power grid vector slice according to the position of the edited power grid device, and adsorb the picked power grid graphics to the edited power grid device, including: the client adopts a bounding box collision detection algorithm, performs collision detection analysis on the rectangular bounding box of the moving mouse cursor and the bounding box of the rendered device or the original graphics of the device in the power grid vector slice, and takes the bounding box of the rendered device or the original graphics of the device that meets the requirements of the rectangular bounding box of the moving mouse cursor as the picked power grid graphics set; the mouse cursor is used to indicate the position of the edited network device; the client selects the power grid graphics that meet the adsorption rules in the power grid graphics set and adsorbs them to the edited power grid device.

[0170] Optionally, the client is used to adopt different bounding box calculation methods for different power grid graphics when picking power grid graphics from power grid vector slices according to the location of the edited power grid equipment.

[0171] Optionally, the adsorption rules adopted by the client include: the client selects the power grid graphic with the highest adsorption weight priority in the power grid graphic set and adsorbs it to the edited power grid device; the adsorption weight types include device resources, asset types and device graphic types; and / or the client determines the corresponding adsorber to adsorb the power grid graphic to the edited power grid device based on the acquired scenario of the editing operation on the edited network device.

[0172] Optionally, the client includes an absorber for absorbently attaching a power grid graphic to an edited power grid device, the absorber including a device graphic connection point absorber and a device geometry absorber; wherein the device graphic connection point absorber is used to return anchor point information of the operation absorption when editing a topological relationship, and the anchor point information is used to characterize the power grid point device; the device geometry absorber is used to return the geometry absorbed by the operation and its geometry calculation information when drawing a geometric relationship, and the geometry calculation information includes at least one of the center point of the geometry, the intersection of the line between the center point and the mouse and the geometry, and the orientation absorbed on the geometry.

[0173] Optionally, the client is used to use the device graphic connection point absorber to absorb the power grid graphic to the edited power grid device, including:

[0174] The client deletes the surface graphics in the picked power grid graphics set, retains the point graphics and line graphics, and instantiates the anchor point objects contained in all the retained point graphics and the terminal objects of the line graphics according to the mapping relationship between the equipment type and the anchor point model, and obtains the object set of all graphic connection points; the client calculates the longitude and latitude coordinates of the graphic connection points in the object set, and converts the longitude and latitude coordinates of the graphic connection points into screen coordinates; the client calculates and compares the distance between the mouse and the screen coordinates of each graphic connection point, selects the graphic connection point closest to it, and reversely indexes according to the selected graphic connection point information to obtain the information of the adsorbed power grid equipment.

[0175] Optionally, when the client is used to use the device geometry absorber to absorb the power grid graphics to the edited power grid device, it includes: the client deletes the point graphics in the picked power grid graphic set, and retains the line graphics and the surface graphics; the client performs intersection calculations on the rectangular bounding box of the moving mouse cursor and the retained line graphics and the surface graphics in turn according to the plane geometry intersection algorithm; the client evaluates the intersection calculation results according to the type of the device geometry absorber to obtain an evaluation value, wherein the types of device geometry absorbers include device line graphics absorbers and device surface graphics absorbers; the client selects the line graphics or point graphics corresponding to the highest evaluation value and absorbs it to the edited power grid device.

[0176] Optionally, when the client adsorbs the power grid graphic to the edited power grid device, it includes: when multiple types of adsorbers are used at the same time, an adsorber queue is set on the client, and the adsorber queue includes all adsorbers required for the editing operation and the corresponding order; the client selects the adsorber corresponding to the editing scene in the adsorber queue for the adsorption operation.

[0177] Optionally, when the client is used to construct power grid vector slices based on power grid GIS data, it uses "layer_layer id_layer type_voltage level" to name the vector slice layer; wherein the layer id is the classid value pre-assigned to each power grid equipment type, which is used to describe the classification information of the power grid equipment type; the layer type includes point symbol layers, line layers and surface layers according to the display form of the power grid equipment; the voltage level corresponds to the voltage value of the power grid equipment, which is used to realize the classification control of the power grid equipment whose power grid equipment type is off-site type; the power grid equipment data includes the attribute values ​​of each power grid vector slice layer, and the attribute value includes at least one of the general attributes, symbol device attributes and line device attributes.

[0178] Combination Fig.10 As shown, the power grid GIS data editing system includes, from the functional level: data layer, cache layer, service layer and application layer.

[0179] Among them, the data layer is used to manage all power grid data, including graphic data, resource data and asset data. The cache layer is used to load the graphics and topology data in the data layer, and then generate the corresponding geographic map slices according to the set slice level to facilitate power grid graphics rendering and editing. The service layer is used to implement different business maintenance scenarios in the form of services, and prioritize the acquisition of cache layer data for loading. For missing data, the cache layer data is updated from the data layer to support the upper-layer application to complete the corresponding functions. The application layer is used to implement power grid model data maintenance operations through different functional applications according to the requirements of different businesses for graphic maintenance scenarios, thereby improving the maintenance operation experience.

[0180] Embodiment 3 of the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when loaded into the processor, implements the power grid GIS data editing method described in Embodiment 1.

[0181] Embodiment 4 of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, a power grid GIS data editing method according to embodiment 1 is implemented.

[0182] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes. The schemes in the embodiments of the present invention may be implemented in various computer languages, for example, object-oriented programming language Java and literal scripting language JavaScript, etc.

[0183] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0184] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0185] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0186] Although the preferred embodiments of the present invention have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0187] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

[0188] Embodiment 5 of the present invention provides a verification embodiment of a power grid GIS data editing system.

[0189] The vector tile mode has a higher rendering rate compared with the GeoJSON rendering and full data cache rendering modes developed based on the research results of this paper. Based on the 10 million data volume in the whole province in Table 4, three different rectangular viewport ranges were selected from levels 10 to 21 for rendering tests. The test case data volume is shown in Table 5, and the test server configuration parameters are shown in Table 6. The CPU utilization rate of the power grid GIS application server is 53%, and the network utilization rate is 84.7%. The detailed test results are shown in Table 7, and the rendering efficiency curve is shown in Fig.11 The horizontal axis is the slice level, and the vertical axis is the rendering completion time in seconds.

[0190] Table 4 Statistics of data volume of provincial GIS platform

[0191]

[0192]

[0193] Table 5 Rendering test data volume

[0194]

[0195] Table 6 Test configuration parameters

[0196]

[0197] Table 7 Rendering test results

[0198]

[0199]

[0200] Compared with the prior art, the present invention has the following beneficial effects:

[0201] The present invention slices large-scale spatial data according to geographic coordinates through vector slicing. Each slice contains data within a small range. In this way, when rendering, only the slice data within the current view range needs to be loaded and drawn, rather than the entire data set, thereby greatly reducing the amount of data that needs to be processed. At the same time, the size of the slice data is fixed, and it can be quickly transmitted and rendered, reducing the delay when the view changes, and achieving a smoother user experience. GeoJSON supports rich attribute data, can flexibly add and modify the attribute information of the device, and is convenient for use in combination with vector slices, further improving the graphics rendering effect.

[0202] The present invention stores the power grid equipment data in GeoJSON format, and uses the geospatial query capability of MongoDB to implement fast range query, proximity query and other complex spatial query operations, thereby reducing data loading time. Vector slice data can be pre-generated and stored in MongoDB, and the client loads the corresponding slice data as needed, avoiding a large number of I / O operations during each loading. Utilizing the characteristics of vector slices, the client only needs to transmit and render the changed slices after the initial loading to achieve incremental updates, further reducing the amount of network transmission. At the same time, since the amount of data for each slice is small, the pressure on network transmission is greatly reduced, and a faster data loading speed can be guaranteed even in a low-bandwidth or high-latency network environment.

[0203] The present invention integrates the business rules of the power grid into the editing tool, automatically processes the spatial relationship and topological relationship between devices, and reduces the workload of manual adjustment by users. The editing tool based on GeoJSON and vector slices can realize real-time feedback, and users can immediately see the preview effect of the modification when editing, which improves the editing experience. Using vector slice technology, users can edit devices within a more detailed view range, reducing the complexity of editing operations. Slices can be cached and locally edited on the client, which improves the response speed of editing. MongoDB supports concurrent writing and data synchronization, and combined with vector slice technology, real-time collaborative editing of multiple users can be realized. The data edited by each user is processed in slices, reducing data conflicts and the difficulty of synchronous updates. Through version control and differential storage of GeoJSON data, the editing operations of multiple users can be effectively managed and merged to ensure data consistency.

[0204] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents, and any modifications or equivalent replacements that do not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

Claims

1. A method for editing power grid GIS data, characterized in that: include: The server constructs power grid vector slices based on power grid GIS data and converts power grid equipment data into GeoJSON data; The client obtains and loads the power grid vector slice from the server, and picks the power grid graphics from the power grid vector slice according to the location of the edited power grid device. After adsorbing the picked power grid graphics to the edited power grid device, the client requests the GeoJSON data of the corresponding device from the server. The server queries the edited power grid device according to the client's request, obtains the devices associated with the edited power grid device, and sends the GeoJSON data of the edited power grid device and the associated devices to the client; Based on the acquired editing operations on the edited power grid device, the client overlays the power grid vector slices and the GeoJSON data of the edited power grid device and related devices for real-time display.

2. The power grid GIS data editing method according to claim 1, characterized in that: The client obtains the grid vector slice from the server including: The client obtains parameter information of the grid vector slice, and sends a vector slice request to the server according to the parameter information of the grid vector slice; The server parses the received vector slice request and generates multiple vector slices based on the parameter information obtained from the parsing and sends them to the client.

3. The power grid GIS data editing method according to claim 2, characterized in that: The parameter information includes the row number, column number, map zoom level, slice generation configuration scheme and permission control parameters required to generate vector slices. The server generates multiple vector slices based on the parameter information obtained through parsing, including: The server calculates the spatial range of the vector tiles to be generated based on the row number, column number and map zoom level required for generating the vector tiles obtained by parsing; The spatial range is queried in the spatial index information to obtain all the power grid equipment data associated with the generated vector slice; Delete the power grid equipment data that does not meet the slice generation configuration scheme and map zoom level obtained by parsing from all the power grid equipment data associated with the generated vector slice, and filter the remaining power grid equipment data according to the authority control parameters obtained by parsing to obtain the first power grid equipment data; According to a preset vector slice data format, a plurality of power grid vector slices are generated based on the first power grid equipment data.

4. The power grid GIS data editing method according to claim 1, characterized in that: The server performs a query based on the edited power grid device according to the client's request, and obtains the devices associated with the edited power grid device, including: The server uses a breadth-first search method to query the pre-built power equipment topology network according to the request of the client to obtain the first device associated with the edited power grid equipment topology; The server performs a service association query based on the edited power grid device to obtain a second device associated with the edited power grid device service; The first device and the second device constitute devices associated with the edited power grid device.

5. The power grid GIS data editing method according to claim 1, characterized in that: The client picks the grid graphics from the grid vector slice according to the location of the edited grid equipment, and adsorbs the picked grid graphics to the edited grid equipment, including: Adopting the bounding box collision detection algorithm, the rectangular bounding box of the moving mouse cursor is subjected to collision detection analysis with the bounding box of the rendered device or the original device graphics in the power grid vector slice, and the bounding box of the rendered device or the original device graphics that meet the requirements of the rectangular bounding box of the moving mouse cursor, which is contained, contained or intersected, is taken as the grid graphics set obtained by picking; the mouse cursor is used to indicate the position of the network device being edited; Select a power grid graphic that meets the adsorption rules from the power grid graphic collection and adsorb it to the edited power grid device.

6. The power grid GIS data editing method according to claim 5, characterized in that: Different bounding box calculation methods are adopted for different types of power grid graphics.

7. The power grid GIS data editing method according to claim 5, characterized in that: Adsorption rules include: Selecting a power grid graphic with the highest priority of adsorption weight from the power grid graphic set and adsorbing it to the edited power grid device; the adsorption weight types include device resources, asset types and device graphic types; and / or, According to the acquired scene of the editing operation on the edited network device, a corresponding absorber is determined to absorb the power grid graphic to the edited power grid device.

8. The power grid GIS data editing method according to claim 7, characterized in that: The absorber includes a device graphic connection point absorber and a device geometrical graphic absorber; Among them, the device graphic connection point absorber is used to return the anchor point information of the operation absorption when editing the topological relationship, and the anchor point information is used to characterize the power grid point equipment; The device geometry absorber is used to return the geometry absorbed by the operation and its geometry calculation information when drawing geometric relationships. The geometry calculation information includes at least one of the center point of the geometry, the intersection of the line between the center point and the mouse and the geometry, and the orientation absorbed on the geometry.

9. The power grid GIS data editing method according to claim 8, characterized in that: Using the device graphic connection point absorber to absorb the power grid graphic to the edited power grid equipment includes: Delete the surface graphics in the picked power grid graphics set, retain the point graphics and line graphics, and instantiate the anchor point objects contained in all the retained point graphics and the terminal objects of the line graphics according to the mapping relationship between the device type and the anchor point model, and obtain the object set of all the graphic connection points; Calculate the longitude and latitude coordinates of the graphic connection points in the object collection, and convert the longitude and latitude coordinates of the graphic connection points into screen coordinates; The distance between the mouse and the screen coordinates of each graphic connection point is calculated and compared, the graphic connection point with the nearest distance is selected, and the information of the adsorbed power grid equipment is obtained by reverse indexing based on the information of the selected graphic connection point.

10. The power grid GIS data editing method according to claim 8, characterized in that: Use the device geometry snapper to snap the grid graphics to the edited grid equipment including: Delete the point graphics in the picked power grid graphics set, and keep the line graphics and surface graphics; According to the plane geometry intersection algorithm, the intersection calculation is performed on the rectangular bounding box of the moving mouse cursor and the retained line graphics and surface graphics in turn; According to the type of device geometry absorber, the intersection calculation result is evaluated to obtain an evaluation value, wherein the type of device geometry absorber includes device line graph absorber and device surface graph absorber; Select the line graph or point graph corresponding to the highest evaluation value and adsorb it to the edited power grid device.

11. The method for editing power grid GIS data according to claim 8, characterized in that: When multiple types of absorbers are used at the same time, set the absorber queue, which includes all absorbers required for the editing operation and the corresponding order; In the absorber queue, select the absorber corresponding to the editing scene to perform the absorber operation.

12. The method for editing power grid GIS data according to any one of claims 1 to 11, characterized in that: When constructing power grid vector slices based on power grid GIS data, the vector slice layers are named using "layer_layer id_layer type_voltage level"; the layer id is the classid value pre-assigned to each power grid equipment type, which is used to describe the classification information of the power grid equipment type; the layer type includes point symbol layer, line layer and surface layer according to the display form of the power grid equipment; the voltage level corresponds to the voltage value of the power grid equipment, which is used to realize the classification control of the power grid equipment of the off-site type; The power grid equipment data includes attribute values ​​of each power grid vector slice layer, and the attribute values ​​include at least one of general attributes, symbol device attributes, and line device attributes.

13. The method for editing power grid GIS data according to claim 12, characterized in that: The line device attributes of the power grid vector slice include the starting point coordinates and the ending point coordinates of the line.

14. The method for editing power grid GIS data according to claim 13, characterized in that: After the client performs real-time display, the method further includes: Based on the editing results received from the client, the server updates the database that stores GeoJSON data and power grid vector tiles accordingly.

15. A power grid GIS data editing system using the power grid GIS data editing method according to any one of claims 1 to 14, comprising a server and a client, characterized in that: include: The server is used to construct power grid vector slices based on power grid GIS data and convert power grid equipment data into GeoJSON data; The client is used to obtain and load the power grid vector slice from the server, and pick up the power grid graphics from the power grid vector slice according to the location of the edited power grid equipment, and then adsorb the picked power grid graphics to the edited power grid equipment and request the GeoJSON data of the corresponding equipment from the server; The server is used to query based on the edited power grid device according to the client's request, obtain the devices associated with the edited power grid device, and send the GeoJSON data of the edited power grid device and the associated devices to the client; The client is used to overlay the grid vector slices and the GeoJSON data of the edited grid equipment and related equipment for real-time display based on the edit operations on the edited network equipment obtained.

16. The power grid GIS data editing system according to claim 15, characterized in that: The client is used to obtain and load power grid vector tiles from the server, including: The client obtains parameter information of the grid vector slice, and sends a vector slice request to the server according to the parameter information of the grid vector slice; The client accepts the vector slice request received by the server and parses it, and generates multiple vector slices based on the parameter information obtained from the parsing and sends them to the client.

17. The power grid GIS data editing system according to claim 16, characterized in that: The server is used to generate multiple vector tiles based on the parameter information obtained through parsing, including: The server calculates the spatial range of the vector tiles to be generated based on the row number, column number and map zoom level required for generating the vector tiles obtained by parsing; The server queries the spatial range in the spatial index information to obtain all the power grid equipment data associated with the generated vector slice; The server deletes the power grid device data that does not meet the slice generation configuration scheme and map zoom level obtained by parsing from all the power grid device data associated with the generated vector slice, and filters the remaining power grid device data according to the permission control parameters obtained by parsing to obtain the first power grid device data; The server generates multiple power grid vector slices based on the first power grid equipment data in accordance with a preset vector slice data format; wherein the parameter information includes the row number, column number, map zoom level, slice generation configuration scheme and permission control parameters required to generate the vector slices.

18. The power grid GIS data editing system according to claim 15, characterized in that: The server is used to query based on the edited power grid device according to the request of the client, and obtain the devices associated with the edited power grid device, including: The server uses a breadth-first search method to query the pre-built power equipment topology network according to the request of the client to obtain the first device associated with the edited power grid equipment topology; The server performs a business association query based on the edited power grid device to obtain a second device associated with the edited power grid device business; the first device and the second device constitute devices associated with the edited power grid device.

19. The power grid GIS data editing system according to claim 15, characterized in that: The client is used to pick up power grid graphics from the power grid vector slice according to the location of the edited power grid device, and adsorb the picked power grid graphics to the edited power grid device, including: The client uses a bounding box collision detection algorithm to perform collision detection analysis on the rectangular bounding box of the moving mouse cursor and the bounding box of the rendered device or the original device graphics in the power grid vector slice, and takes the bounding box of the rendered device or the original device graphics that are contained, contained by or intersected by the rectangular bounding box of the moving mouse cursor as the grid graphics set obtained by picking; the mouse cursor is used to indicate the position of the edited network device; The client selects a power grid graphic that meets the adsorption rule from the power grid graphic collection and adsorbs it to the edited power grid device.

20. The power grid GIS data editing system according to claim 19, characterized in that: The client is used to adopt different bounding box calculation methods for different power grid graphics when picking power grid graphics from power grid vector slices according to the location of the edited power grid equipment.

21. The power grid GIS data editing system according to claim 19, characterized in that: The adsorption rules adopted by the client include: The client selects the power grid graphic with the highest adsorption weight priority from the power grid graphic set and adsorbs it to the edited power grid device; the adsorption weight types include device resources, asset types and device graphic types; and / or the client determines the corresponding adsorber to adsorb the power grid graphic to the edited power grid device based on the acquired editing operation scenario on the edited network device.

22. The power grid GIS data editing system according to claim 20, characterized in that: The client includes an absorber for absorbently attaching a power grid graphic to an edited power grid device, and the absorber includes a device graphic connection point absorber and a device geometric graphic absorber; wherein the device graphic connection point absorber is used to return anchor point information of the operation absorption when editing a topological relationship, and the anchor point information is used to characterize the power grid point device; the device geometric graphic absorber is used to return the geometric graphic absorbed by the operation and its geometric calculation information when drawing a geometric relationship, and the geometric calculation information includes at least one of the center point of the geometric graphic, the intersection of the line between the center point and the mouse and the geometric graphic, and the orientation absorbed on the geometric graphic.

23. The power grid GIS data editing system according to claim 22, characterized in that: The client uses the device graphic connection point absorber to absorb the power grid graphic to the edited power grid device, including: The client deletes the surface graphics in the picked power grid graphics set, retains the point graphics and line graphics, and instantiates the anchor point objects contained in all the retained point graphics and the terminal objects of the line graphics according to the mapping relationship between the device type and the anchor point model, and obtains the object set of all the graphic connection points; The client calculates the longitude and latitude coordinates of the graphic connection points in the object collection, and converts the longitude and latitude coordinates of the graphic connection points into screen coordinates; The client calculates and compares the distance between the mouse and the screen coordinates of each graphic connection point, selects the graphic connection point with the nearest distance, and reversely indexes according to the selected graphic connection point information to obtain the information of the adsorbed power grid equipment.

24. The power grid GIS data editing system according to claim 22, characterized in that: The client uses the device geometry absorber to absorb the power grid graphics to the edited power grid equipment, including: The client deletes the point graphics in the picked power grid graphics set and retains the line graphics and the surface graphics; the client performs intersection calculations on the rectangular bounding box of the moving mouse cursor and the retained line graphics and the surface graphics in turn according to the plane geometry intersection algorithm; The client evaluates the intersection calculation result according to the type of the device geometry absorber to obtain an evaluation value, wherein the type of the device geometry absorber includes a device line graph absorber and a device surface graph absorber; The client selects the line graph or point graph corresponding to the highest evaluation value and adsorbs it to the edited power grid device.

25. The power grid GIS data editing system according to claim 22, characterized in that: When multiple types of absorbers are used simultaneously in the client, an absorber queue is set in the client, and the absorber queue includes all absorbers required for the editing operation and the corresponding sequence; the client selects the absorber corresponding to the editing scene in the absorber queue for the absorption operation.

26. The power grid GIS data editing system according to any one of claims 15 to 25, characterized in that: The client uses "layer_layer id_layer type_voltage level" to name the vector slice layer when constructing the power grid vector slice based on the power grid GIS data; wherein the layer id is the classid value pre-assigned to each power grid equipment type, which is used to describe the classification information of the power grid equipment type; the layer type includes point symbol layer, line layer and surface layer according to the display form of the power grid equipment; the voltage level corresponds to the voltage value of the power grid equipment, which is used to realize the classification control of the power grid equipment of the off-site type; the power grid equipment data includes the attribute values ​​of each power grid vector slice layer, and the attribute value includes at least one of the general attributes, symbol device attributes and line device attributes.

27. An electronic device, comprising a processor and a storage medium; characterized in that: The storage medium is used to store instructions; The processor is used to operate according to the instructions to execute the steps of the power grid GIS data editing method according to any one of claims 1 to 14.

28. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the steps of the power grid GIS data editing method described in any one of claims 1 to 14 are implemented.

Images