CN115358030A - Topological structure generation method and system based on distribution network line data - Google Patents
Topological structure generation method and system based on distribution network line data Download PDFInfo
- Publication number
- CN115358030A CN115358030A CN202210791912.XA CN202210791912A CN115358030A CN 115358030 A CN115358030 A CN 115358030A CN 202210791912 A CN202210791912 A CN 202210791912A CN 115358030 A CN115358030 A CN 115358030A
- Authority
- CN
- China
- Prior art keywords
- information
- data
- attribute
- equipment
- layer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/18—Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Abstract
The invention discloses a topological structure generation method and a topological structure generation system based on distribution network line data, wherein the method comprises the following steps of: uploading the data files with the line topological relation to a production management system singly or in batches; correspondingly analyzing each element information into the connection relation of the equipment according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information; if the connection relation is established, analyzing the basic information of the current equipment into a relation database, and analyzing the connection relation into a graph database; inquiring the cable information and the GPS information of the corresponding cable section from the equipment asset management system, and storing the GPS information into a relational database after matching; the invention greatly reduces the workload of power supply station personnel for maintaining the line topology, ensures the same data source, scientifically analyzes the collected and stored operation data of the power distribution network, and realizes the panoramic visibility and controllability of the power distribution network.
Description
Technical Field
The invention relates to the technical field of power grids, in particular to a topological structure generation method and system based on distribution network line data.
Background
The position of the topology analysis in the distribution network line loss calculation and the energy-saving analysis is self-evident, but in the prior art, the topology data maintenance is manually maintained by power supply station personnel, the workload is large, and errors often occur; the existing line data has the problem of different sources, and the problem of asynchronous maintenance can occur when maintenance is required in two different systems; with the rapid expansion of the scale of the power grid, the grid structure of the power distribution network is increasingly complex, and the operation mode is more flexible and changeable, thereby bringing new challenges to the dispatching and planning work of the power distribution network.
Disclosure of Invention
The purpose of the invention is as follows: in order to overcome the defects of the prior art, the invention provides a topological structure generation method based on distribution network line data, solves the problems of difficult maintenance of line topology, inaccurate maintenance and different sources of topological data, and also provides a topological structure generation system based on distribution network line data.
The technical scheme is as follows: according to a first aspect of the present invention, a topology structure generation method based on distribution network line data is provided, the method includes the following steps:
s1, individually or in batch uploading a data file with a line topology relationship to a production management system, wherein the data file comprises attribute information corresponding to each device, and the attribute information comprises an element tag, a basic information attribute and a connection relationship attribute;
s2, correspondingly analyzing each element information into the type of the equipment according to the element label of the data file; analyzing the element information into basic information of the equipment correspondingly according to the basic information attribute of the data file; correspondingly analyzing each element information into a connection relation of the equipment according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information;
s3, if the connection relation is established, analyzing the basic information of the current equipment into a relation database, and analyzing the connection relation into a graph database; otherwise, manually supplementing the missing data and matching and analyzing again;
s4, inquiring cable information and GPS (global positioning system) information of a corresponding cable segment from the equipment asset management system according to the basic information of each piece of equipment and the standing book data in the equipment asset management system, and storing the GPS information into a relational database after matching;
and S5, completely displaying the topological structures and coordinate data corresponding to the cable and other equipment obtained through analysis.
Further, the method comprises the following steps:
the data file is an SVG file or a compressed file of the SVG, an id information is in an element tag, and a corresponding tag is expressed as: the < gid = 'type coding' >, the type coding corresponds to the device type name ObjectName attribute of the cge: p.sr _ Ref label in the SVG original data one to one, and the device type name ObjectName attribute and the chinese corresponding relationship are as follows:
a Substation of subsystem _ Layer, a transformer of PowerTransformer _ Layer, a Breaker _ Layer switch, an EnergyConsumer _ Layer user, a PoleCode _ Layer tower, an ACLeSegment _ Layer cable, a ConnLine _ Layer connecting line, a BusbarSection _ Layer bus section, a Junction _ Layer connecting point, a composition switch _ Layer composite switch and a disconnect _ Layer isolating switch.
Further, the method comprises the following steps:
in S3, the conditions for establishing the connection relationship specifically include:
and (3) equipment query stage: SR _ Ref in SVG raw data includes a Global ID under the < g > tag, the Global ID is given to each device in the SVG raw data, the Global ID value of the current device is matched with the corresponding attribute value in the device asset management system, if the global ID value is the same as the corresponding attribute value, the information of the device is inquired, and the device type name ObjectName attribute in the basic attribute is analyzed into a relational database;
and (3) equipment matching: each element tag in the SVG raw data is provided with one or more cge-GLink _ Ref tags, each cge-GLink _ Ref tag comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current element, the linkObjectIdList information stores the ObjectIDs of other elements, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, devices corresponding to the two elements are in connection.
Further, the method comprises the following steps:
in S3, analyzing the connection relationship into a graph database, specifically including:
s31, correspondingly generating element labels of the ACLinesegment _ Layer in the SVG original data into a graph database to form line segment nodes;
s32, correspondingly analyzing the element label of the substtate _ Layer and the element label of the PoleCode _ Layer into a graph database to form a corresponding equipment node and connecting a segment node associated with the equipment node;
and S33, reading the device nodes, the segment nodes and the association relationship between the device nodes and the segment nodes generated in S31 and S32, and generating a basic line topology.
Further, the method comprises the following steps:
in S3, analyzing the connection relationship into a graph database, further comprising:
s34, correspondingly generating element tags of Breaker _ Layer, composition switch _ Layer, disconnect _ Layer and Power Transformer _ Layer into a graph database on the basis of basic circuit topology to generate circuit topology;
s35, removing PoleCode _ Layer elements on the basis of the circuit topology to generate an electrical topology.
Further, the method comprises the following steps:
in S32, connecting the segment nodes associated with the device nodes specifically includes: each cable element label in the SVG raw data is provided with one or more cge-GLink _ Ref labels, each cge-GLink _ Ref label comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current cable, the linkObjectIdList information stores the ObjectIDs of other devices, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, the cable and the device are associated.
According to a second aspect of the present invention, there is provided a topology generation system based on distribution network line data, the system comprising:
the file uploading module is used for uploading a data file with a line topological relation to a production management system in a single or batch mode, wherein the data file comprises attribute information corresponding to each device, and the attribute information comprises an element label, a basic information attribute and a connection relation attribute;
the file analysis module is used for correspondingly analyzing each element information into the type of the equipment according to the element label of the data file; correspondingly analyzing each element information into basic information of the equipment according to the basic information attribute of the data file; correspondingly analyzing each element information into a connection relation of the equipment according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information;
a mapping module comprising: if the connection relation is established, analyzing the basic information of the current equipment into a relation database, and analyzing the connection relation into a graph database; otherwise, manually supplementing the missing data and matching and analyzing again;
the position determining module is used for inquiring the cable information and the GPS information of the corresponding cable section from the PMS according to the basic information of each device and the standing book data in the PMS, and storing the GPS information into the relational database after matching;
and the display module is used for completely displaying the topological structures and the coordinate data corresponding to the cables and other equipment obtained through analysis.
Further, the method comprises the following steps:
in the mapping module, the condition that the connection relationship is established specifically includes:
an equipment inquiry unit: SR _ Ref in the SVG raw data includes a Global identity identifier (GlobeID) attribute under a < g > tag, the GlobeID attribute is given to each device with a unique and different ID in the SVG raw data, a GlobeID value of the current device is matched with a corresponding attribute value in a PMS, if the GlobeID value is the same as the corresponding attribute value in the PMS, information of the device is inquired, and a device type name ObjectName attribute in a basic attribute is analyzed into a relational database;
an equipment matching unit: each element tag in the SVG raw data is provided with one or more cge-GLink _ Ref tags, each cge-GLink _ Ref tag comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current element, the linkObjectIdList information stores the ObjectIDs of other elements, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, devices corresponding to the two elements are in connection.
Further, the method comprises the following steps:
in the mapping module, analyzing the connection relationship into a graph database, specifically comprising:
the cable mapping unit is used for correspondingly generating element labels of ACLINE information _ Layer in the SVG original data into a graph database to form line segment nodes;
the device mapping unit is used for correspondingly analyzing the element label of the substtation _ Layer and the element label of the PoleCode _ Layer into the graph database to form a corresponding device node and connecting the corresponding device node with the associated line segment node;
and the topology generating unit is used for reading the generated equipment nodes, the generated line segment nodes and the incidence relation among the equipment nodes, the line segment nodes and the incidence relation to generate the basic line topology.
Further, the method comprises the following steps:
in the device mapping unit, connecting the segment nodes associated with the device nodes specifically includes: each cable element label in the SVG raw data is provided with one or more cge-GLink _ Ref labels, each cge-GLink _ Ref label comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current cable, the linkObjectIdList information stores the ObjectIDs of other devices, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, the cable and the device are associated.
Has the beneficial effects that: the method comprises the steps of firstly analyzing an SVG file, mapping equipment information into a database, establishing a connection relation between equipment, and forming a topological structure; and then, coordinate data of the equipment is acquired in the equipment asset management system, and topology data of the distribution network line is automatically generated and displayed, so that the workload of power supply station personnel for maintaining the line topology is greatly reduced, the same source of data is ensured, the collected and stored operation data of the distribution network is scientifically analyzed, the panoramic visibility and controllability of the distribution network are realized, important conditions of more reliable, safe and economic electric energy are provided for a power grid company, and a foundation is provided for realizing lean management and control.
Drawings
Fig. 1 is a flowchart of a topology generation method according to an embodiment of the present invention;
fig. 2 is a schematic diagram of an SVG original file according to an embodiment of the present invention;
fig. 3 is a schematic label diagram of an SVG file according to an embodiment of the present invention;
fig. 4 is a schematic diagram of a tag where a connection relationship exists according to an embodiment of the present invention;
FIG. 5 is a schematic diagram illustrating the storage of a topology structure in a gallery according to an embodiment of the present invention;
FIG. 6 is a schematic diagram illustrating a basic circuit topology according to an embodiment of the present invention;
fig. 7 is a structural diagram of a topology generating system according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
First, the present invention provides a topology structure generation method based on distribution network line data, as shown in fig. 1, including:
and 1, uploading the data files with the line topological relation to a production management system singly or in batches.
In the embodiment, the data files are SVG files, the data files are uploaded to the 10Kv feeder SVG files outside the station or zip compressed files of a plurality of SVGs singly or in batches, and the service decompresses the zip files to a specific path to obtain an SVG file list;
the SVG is a very popular image file format at present, the SVG strictly speaking is an open standard vector graphics language, the SVG format can be used for directly drawing images by codes, SVG images can be opened by any word processing tool, the images have an interactive function by changing part of the codes, and the SVG can be inserted into HTML at any time and viewed by a browser.
The SVG format has the advantages that the formats such as jpg and png which are popular in the current network cannot have: the graphical display can be arbitrarily enlarged, but not at the expense of image quality; editable and searchable states can be reserved in the SVG image; SVG files are, on average, much smaller than image files in other formats and are therefore downloaded quickly.
As shown in fig. 2, the SVG file of the out-of-station 10Kv line topological relation mainly includes information of a feeder line, a tower, a transformer substation, a transformer, a bus, various switches, a connection line, a cable segment, a bus, a ring main unit, and the like.
Step 2, the data file comprises attribute information corresponding to each device, the attribute information comprises an element label, a basic information attribute and a connection relation attribute, and firstly, each element information is correspondingly analyzed into the type of the device according to the element label of the data file.
In this embodiment, first, the SVG file is read and parsed, and according to the id of the < g > tag in the SVG layer, the element information in all layers is parsed into a specific name of the device, with the following rules:
the data file is an SVG file or a compressed file of the SVG, an id information is in the element tag, and the corresponding tag is expressed as: the type code corresponds to the device type name ObjectName attribute of the cge: p.sr _ Ref tag in the SVG raw data one to one, and the relationship between the device type name ObjectName attribute and the chinese language is as follows:
for example, each element tag in SVG has an id information, such as < gid = "PoleCode _ Layer" >, and such a tag indicates that the content under the tag is all referred to as a tower. Other device types are as follows:
substtation _ Layer transformer Substation
PowerTransformer _ Layer transformer
Breaker _ Layer switch
EnergyConsumer _ Layer user
PoleCode _ Layer tower
ACLLINESegment _ Layer cable
ConnLine _ Layer connecting line
Busbarsection _ Layer bus section
Junction _ Layer connection point
Compsites switch _ Layer composite switch
Disconnect _ Layer Disconnector.
And 3, correspondingly analyzing each element information into basic information of the equipment according to the basic information attribute of the data file.
As shown in fig. 3, the basic information attribute is that the basic information of all devices is analyzed according to cge, p.sr _ Ref information in SVG metadata, including ObjectID, globeID, PSRType, objectName of devices such as cable segments, poles, towers, switches, distribution transformers, ring main units, etc.; further described are: different device information may be available under different tags. The information in the step 2 is analyzed by the id of the < g > tag, and the specific equipment type is indicated; the PSR _ Ref tag can analyze the detailed information of the current device type, such as objectID, globeID, PSRType and objectName.
The object ID is a device ID corresponding to the type code, the object name is a corresponding device name, the Global is original data in the SVG information, each device has own Global and different Global, the Global is a specific ID of the device in the PMS system, and the PMS assigns a value of a unique ID in the database to the Global when generating the SVG image, so that the unique corresponding device information can be inquired from the database of the PMS through the Global. The two ids of the GlobeID and the ObjectId are under the same device, and each device has one GlobeID and one ObjectId, so that one-to-one binding is formed. GlobeID is indeed different for each device. PSRType is the type of encoding.
Step 3 also includes: and correspondingly analyzing each element information into the connection relation of the equipment according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information. If the connection relation is established, analyzing basic information ObjectName of the current equipment into a mysql relation database, and analyzing connection relation data into a database; if not, only analyzing the topological data into the graph database, manually supplementing the missing data and matching and analyzing again.
Firstly, according to the fact that a GlobeID value of a current device is matched with a corresponding attribute value in a PMS, if the GlobeID value of the current device is the same as the corresponding attribute value in the PMS, information of the device is inquired, and a device type name attribute in a basic attribute is resolved into a relational database, wherein the PMS is a device asset management system which is mainly used for managing device assets, and the specific introduction can refer to https:// baijiaha.baidu.com/sid =1726061206807237372& = wfr = pc below.
And then, analyzing the front-back connection relation among all the devices according to cge, GLink _ Ref information of the SVG and the objectId in the previous step to generate relation-json data which is an analyzed json file, wherein the relation-json data is obtained according to the connection relation among the devices, namely all data contents in the SVG are screened, useless data are removed, and the rest data are spliced according to the upper-lower relation of the labels to generate relation-json.
As shown in fig. 4, each piece of data represents a device, and there is an object id representing the current device itself, and there is linkObjectIdList information representing the connection relationship between the current device and other devices, where the object id of other devices is stored in the linkObjectIdList, so that the object id and the linkObjectIdList can be used for matching in the program, and an equal value represents that the two devices are connected.
Finally, as shown in fig. 5, there are 300 nodes and 237 connection relationships, and the analyzing of the connection relationships into the graph database specifically includes:
(1) Correspondingly generating element labels of ACLINE attachment _ Layer in the SVG original data into a graph database to form line segment nodes;
(2) Correspondingly analyzing the element label of the substtation _ Layer and the element label of the PoleCode _ Layer into a graph database to form corresponding equipment nodes, and connecting the equipment nodes with the associated line segment nodes;
a line segment node is a line, namely < gid = 'ACLinesegement _ Layer' > element information in SVG original data; the device node refers to other nodes except for the line, the line in the system service can be understood as an upper-level device, and all other devices are devices under the line and have corresponding affiliations with the line.
As shown in the above raw SVG data, all the < g > tags have one or more < cge: GLink _ Ref > tags, so that the connection relationship between the device of the current < g > tag and other devices can be analyzed, that is, objectID in the < cge: GLink _ Ref > tag represents other devices. When the ObjectId in the line information is the same as linkObjectIdList in the other device, the device is considered to be associated with the line.
(3) And reading the generated equipment nodes, the line segment nodes and the incidence relation between the equipment nodes and the line segment nodes to generate a basic line topology.
(4) On the basis of basic line topology, correspondingly generating element tags of Breaker _ Layer, composition switch _ Layer, disconnect _ Layer and PowerTransformer _ Layer into a graph database to generate line topology;
(5) And removing the PoleCode _ Layer element on the basis of the line topology to generate an electrical topology.
Namely, the basic line topology refers to the topology formed by connecting all lines, substations and pole and tower equipment in the SVG;
the line topology refers to a basic line topology plus a topology generated by a switch, a transformer and a cable segment device;
the electric topology is that tower equipment is removed on the basis of the line topology.
Therefore, after the basic line topology is generated, corresponding topology data can be generated according to the requirements of the line topology and the electrical topology.
Step 4, inquiring cable information and GPS information of a corresponding cable segment from the PMS according to the basic information of each device and the standing book data in the PMS, and storing the GPS information into a mysql relational database after matching;
specifically, attribute information of all devices is analyzed, line information of the corresponding PMS and GPS information of the cable segment are called by matching account data and GPS information of the PMS according to a line or device GlobeID attribute, and the line information and the GPS information are matched and associated and then stored in a mysql relational database.
The standing book data is the standing book data in the PMS, such as asset number, meter reading section number, incoming line pole number, industry property, load property, power source property, electricity utilization type, total house number, user name, power supply capacity, name, longitude, latitude, pole change state, operation and maintenance unit, operation and distribution identification, pole change ID, pole change name, belonging pole tower, belonging feeder line ID, belonging power station and voltage grade required by special transformer equipment. Similarly, other devices also have corresponding ledger data.
And 5, completely displaying the topological structures and coordinate data corresponding to the cable and other equipment obtained through analysis.
Secondly, as shown in fig. 7, the present invention further provides a topology generating system based on distribution network line data, the system comprising:
the file uploading module is used for uploading a data file with a line topological relation to a production management system in a single or batch mode, wherein the data file comprises attribute information corresponding to each device, and the attribute information comprises an element label, a basic information attribute and a connection relation attribute;
the file analysis module is used for correspondingly analyzing each element information into the type of the equipment according to the element label of the data file; correspondingly analyzing each element information into basic information of the equipment according to the basic information attribute of the data file; analyzing the element information into the connection relation of the equipment correspondingly according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information;
a mapping module, comprising: if the connection relation is established, analyzing the basic information of the current equipment into a relation database, and analyzing the connection relation into a graph database; otherwise, manually supplementing the missing data and matching and analyzing again;
the position determining module is used for inquiring the cable information and the GPS information of the corresponding cable section from the PMS according to the basic information of each device and the standing book data in the PMS, and storing the GPS information into the relational database after matching;
and the display module is used for completely displaying the topological structures and the coordinate data corresponding to the cables and other equipment obtained through analysis.
In the mapping module, the condition that the connection relationship is established specifically includes:
an equipment inquiry unit: SR _ Ref in the SVG raw data includes a Global identity identifier (GlobeID) attribute under a < g > tag, the GlobeID attribute is given to each device with a unique and different ID in the SVG raw data, a GlobeID value of the current device is matched with a corresponding attribute value in a PMS, if the GlobeID value is the same as the corresponding attribute value in the PMS, information of the device is inquired, and a device type name ObjectName attribute in a basic attribute is analyzed into a relational database;
an equipment matching unit: each element tag in the SVG raw data is provided with one or more cge-GLink _ Ref tags, each cge-GLink _ Ref tag comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current element, the linkObjectIdList information stores the ObjectIDs of other elements, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, devices corresponding to the two elements are in connection.
Analyzing the connection relation into a graph database, which specifically comprises the following steps:
the cable mapping unit is used for correspondingly generating element labels of the ACLinesegment _ Layer in the SVG original data into a graph database to form line segment nodes;
the device mapping unit is used for correspondingly analyzing the element label of the substtation _ Layer and the element label of the PoleCode _ Layer into the graph database to form a corresponding device node and connecting the corresponding device node with the associated line segment node;
and the topology generating unit is used for reading the generated equipment nodes, the generated line segment nodes and the incidence relation among the equipment nodes, the line segment nodes and the incidence relation to generate the basic line topology.
Further, the method comprises the following steps:
in the device mapping unit, connecting the segment nodes associated with the device nodes specifically includes: each cable element label in the SVG raw data is provided with one or more cge-GLink _ Ref labels, each cge-GLink _ Ref label comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current cable, the linkObjectIdList information stores the ObjectIDs of other devices, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, the cable and the device are associated. Other corresponding technical details of the system are the same as those of the method, and are not described in detail in this specification.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various modifications and variations can be made in the embodiments of the present invention without departing from the spirit or scope of the embodiments of the invention. Thus, if such modifications and variations of the embodiments 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 encompass such modifications and variations.
Claims (10)
1. A topological structure generation method based on distribution network line data is characterized by comprising the following steps:
s1, singly or in batch, uploading a data file with a line topology relation to a production management system, wherein the data file comprises attribute information corresponding to each device, and the attribute information comprises an element tag, a basic information attribute and a connection relation attribute;
s2, correspondingly analyzing each element information into the type of the equipment according to the element label of the data file; correspondingly analyzing each element information into basic information of the equipment according to the basic information attribute of the data file; correspondingly analyzing each element information into a connection relation of the equipment according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information;
s3, if the connection relation is established, analyzing the basic information of the current equipment into a relation database, and analyzing the connection relation into a graph database; otherwise, manually supplementing the missing data and matching and analyzing again;
s4, according to basic information of the equipment and ledger data in the equipment asset management system, inquiring cable information and GPS information of a corresponding cable section from the equipment asset management system, and storing the GPS information into a relational database after matching;
and S5, completely displaying the topological structures and coordinate data corresponding to the cable and other equipment obtained through analysis.
2. The method for generating the topology structure based on the distribution network line data according to claim 1, wherein the data file is an SVG file or a compressed file of SVG, an id information is contained in an element tag, and the corresponding tag is expressed as: the < gid = 'type coding' >, the type coding corresponds to the device type name ObjectName attribute of the cge: p.sr _ Ref label in the SVG original data one to one, and the device type name ObjectName attribute and the chinese corresponding relationship are as follows:
a Substation, a PowerTransformer _ Layer transformer, a Breaker _ Layer switch, an energy conditioner _ Layer user, a PoleCode _ Layer tower, an ACLINE section _ Layer cable, a ConnLine _ Layer connecting line, a Busbarsection _ Layer bus section, a Junction _ Layer connecting point, a composite switch _ Layer composite switch, and a disconnect _ Layer isolating switch.
3. The method for generating a topology structure based on distribution network line data according to claim 1, wherein in S3, a condition that a connection relationship is established specifically includes:
and (3) equipment query stage: SR _ Ref in the SVG raw data includes a Global identity identifier (GlobeID) attribute under a < g > tag, the GlobeID attribute is given to each device with a unique and different ID in the SVG raw data, a GlobeID value of the current device is matched with a corresponding attribute value in a device asset management system, if the GlobeID value is the same as the corresponding attribute value, information of the device is inquired, and a device type name ObjectName attribute in a basic attribute is analyzed into a relational database;
and (3) equipment matching: each element tag in the SVG raw data is provided with one or more cge-GLink _ Ref tags, each cge-GLink _ Ref tag comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current element, the linkObjectIdList information stores the ObjectIDs of other elements, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, devices corresponding to the two elements are in connection.
4. The method for generating a topology structure based on distribution network line data according to claim 3, wherein in S3, analyzing the connection relationship into a graph database specifically comprises:
s31, correspondingly generating element labels of ACLINE attachment _ Layer in the SVG original data into a graph database to form line segment nodes;
s32, correspondingly analyzing the element label of the substtate _ Layer and the element label of the PoleCode _ Layer into a graph database to form a corresponding equipment node and connecting a segment node associated with the equipment node;
and S33, reading the device nodes, the line segment nodes and the association relationship between the device nodes and the line segment nodes generated in S31 and S32, and generating a basic line topology.
5. The method for generating a topology structure based on distribution network line data according to claim 4, wherein in S3, the analyzing the connection relationship into the graph database further comprises:
s34, correspondingly generating element labels of Breaker _ Layer, composition switch _ Layer, disconnect _ Layer and PowerTransformer _ Layer into a graph database on the basis of basic line topology to generate line topology;
s35, removing PoleCode _ Layer elements on the basis of the circuit topology to generate an electrical topology.
6. The method for generating a topology structure based on distribution network line data according to claim 4 or 5, wherein in S32, connecting the segment nodes associated with the device nodes specifically includes: each cable element label in the SVG raw data is provided with one or more cge-GLink _ Ref labels, each cge-GLink _ Ref label comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current cable, the linkObjectIdList information stores the ObjectIDs of other devices, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, the cable and the device are associated.
7. A topology structure generation system based on distribution network line data is characterized by comprising:
the file uploading module is used for uploading a data file with a line topological relation to a production management system in a single or batch mode, wherein the data file comprises attribute information corresponding to each device, and the attribute information comprises an element label, a basic information attribute and a connection relation attribute;
the file analysis module is used for correspondingly analyzing each element information into the type of the equipment according to the element label of the data file; correspondingly analyzing each element information into basic information of the equipment according to the basic information attribute of the data file; correspondingly analyzing each element information into a connection relation of the equipment according to the connection relation attribute of the data file, wherein the connection relation is a connection topological relation formed by matching the current equipment with other equipment through basic information;
a mapping module, comprising: if the connection relation is established, analyzing the basic information of the current equipment into a relation database, and analyzing the connection relation into a graph database; otherwise, manually supplementing the missing data and matching and analyzing again;
the device comprises a position determining module, a relation database and a management module, wherein the position determining module is used for inquiring cable information and GPS (global positioning system) information of a corresponding cable section from a device asset management system according to basic information of each device and ledger data in the device asset management system, and storing the GPS information into the relation database after matching;
and the display module is used for completely displaying the topological structures and the coordinate data corresponding to the cables and other equipment obtained through analysis.
8. The distribution network line data based topology generation system of claim 7,
in the mapping module, the condition that the connection relationship is established specifically includes:
an equipment inquiry unit: SR _ Ref in SVG raw data includes a Global ID under the < g > tag, the Global ID is given to each device in the SVG raw data, the Global ID value of the current device is matched with the corresponding attribute value in the device asset management system, if the global ID value is the same as the corresponding attribute value, the information of the device is inquired, and the device type name ObjectName attribute in the basic attribute is analyzed into a relational database;
a device matching unit: each element tag in the SVG raw data is provided with one or more cge-GLink _ Ref tags, each cge-GLink _ Ref tag comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current element, the linkObjectIdList information stores the ObjectIDs of other elements, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, devices corresponding to the two elements are in connection.
9. The system for generating a topology structure based on distribution network line data according to claim 8, wherein in the mapping module, the analyzing the connection relationship into the graph database specifically comprises:
the cable mapping unit is used for correspondingly generating element labels of the ACLinesegment _ Layer in the SVG original data into a graph database to form line segment nodes;
the device mapping unit is used for correspondingly analyzing the element labels of the Substation _ Layer and the element labels of the PoleCode _ Layer into the graph database to form corresponding device nodes and connecting the corresponding segment nodes;
and the topology generating unit is used for reading the generated equipment nodes, the generated line segment nodes and the incidence relation among the equipment nodes, the line segment nodes and the incidence relation to generate the basic line topology.
10. The topology structure generation system based on distribution network line data of claim 9, wherein the device mapping unit connects the segment nodes associated with the device nodes, and specifically includes: each cable element label in the SVG raw data is provided with one or more cge-GLink _ Ref labels, each cge-GLink _ Ref label comprises ObjectID information and linkObjectIdList information, wherein the ObjectID represents the ID of the current cable, the linkObjectIdList information stores the ObjectIDs of other devices, and if the ObjectID is equal to the ObjectID in the linkObjectIdList information, the cable and the device are associated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210791912.XA CN115358030B (en) | 2022-07-07 | 2022-07-07 | Topology structure generation method and system based on distribution network line data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210791912.XA CN115358030B (en) | 2022-07-07 | 2022-07-07 | Topology structure generation method and system based on distribution network line data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115358030A true CN115358030A (en) | 2022-11-18 |
| CN115358030B CN115358030B (en) | 2023-10-13 |
Family
ID=84030401
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210791912.XA Active CN115358030B (en) | 2022-07-07 | 2022-07-07 | Topology structure generation method and system based on distribution network line data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115358030B (en) |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| FR2828308A1 (en) * | 2001-07-31 | 2003-02-07 | Mondeca | Database management system for topological data relating to data search methods, especially for finding multimedia data in the Internet in a quicker more efficient manner |
| US20070130172A1 (en) * | 2005-12-02 | 2007-06-07 | Oracle International Corporation | Method and apparatus for creating topological features inside a database system |
| CN102043852A (en) * | 2010-12-22 | 2011-05-04 | 东北大学 | Path information based extensible markup language (XML) ancestor-descendant indexing method |
| US20110266338A1 (en) * | 2008-09-12 | 2011-11-03 | Babcock William J | Tag Communication, Identification, and Tracking Apparatus and System |
| CN103559355A (en) * | 2013-11-11 | 2014-02-05 | 国家电网公司 | SVG (Scalable Vector Graphics) technology-based distribution network modeling system |
| WO2015176451A1 (en) * | 2014-05-23 | 2015-11-26 | 中兴通讯股份有限公司 | Topologic display method and device |
| CN108334691A (en) * | 2018-01-30 | 2018-07-27 | 易麦克（苏州）信息科技有限公司 | Visual automatic drawing method for power distribution network |
| CN108984175A (en) * | 2018-07-12 | 2018-12-11 | 积成电子股份有限公司 | The power grid SVG line chart methods of exhibiting of object-oriented suitable for mobile device |
| CN109522268A (en) * | 2018-12-03 | 2019-03-26 | 中国南方电网有限责任公司 | It is a kind of that analysis method is imported with the power grid SVG mutually separated is imported based on verification |
| CN111160868A (en) * | 2019-12-31 | 2020-05-15 | 国网北京市电力公司 | Unified distribution network frame topology construction method based on graph fusion technology |
| CN111241349A (en) * | 2019-12-31 | 2020-06-05 | 中国电力科学研究院有限公司 | Wiring diagram data display method and system based on graph conversion |
| CN112286884A (en) * | 2020-11-04 | 2021-01-29 | 国网湖南省电力有限公司 | Method, system and medium for automatically generating topology of ring main unit of power distribution network |
| WO2022100233A1 (en) * | 2020-11-12 | 2022-05-19 | 全球能源互联网研究院有限公司 | Graph database-based power grid retrieval method and system |
-
2022
- 2022-07-07 CN CN202210791912.XA patent/CN115358030B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| FR2828308A1 (en) * | 2001-07-31 | 2003-02-07 | Mondeca | Database management system for topological data relating to data search methods, especially for finding multimedia data in the Internet in a quicker more efficient manner |
| US20070130172A1 (en) * | 2005-12-02 | 2007-06-07 | Oracle International Corporation | Method and apparatus for creating topological features inside a database system |
| US20110266338A1 (en) * | 2008-09-12 | 2011-11-03 | Babcock William J | Tag Communication, Identification, and Tracking Apparatus and System |
| CN102043852A (en) * | 2010-12-22 | 2011-05-04 | 东北大学 | Path information based extensible markup language (XML) ancestor-descendant indexing method |
| CN103559355A (en) * | 2013-11-11 | 2014-02-05 | 国家电网公司 | SVG (Scalable Vector Graphics) technology-based distribution network modeling system |
| WO2015176451A1 (en) * | 2014-05-23 | 2015-11-26 | 中兴通讯股份有限公司 | Topologic display method and device |
| CN108334691A (en) * | 2018-01-30 | 2018-07-27 | 易麦克（苏州）信息科技有限公司 | Visual automatic drawing method for power distribution network |
| CN108984175A (en) * | 2018-07-12 | 2018-12-11 | 积成电子股份有限公司 | The power grid SVG line chart methods of exhibiting of object-oriented suitable for mobile device |
| CN109522268A (en) * | 2018-12-03 | 2019-03-26 | 中国南方电网有限责任公司 | It is a kind of that analysis method is imported with the power grid SVG mutually separated is imported based on verification |
| CN111160868A (en) * | 2019-12-31 | 2020-05-15 | 国网北京市电力公司 | Unified distribution network frame topology construction method based on graph fusion technology |
| CN111241349A (en) * | 2019-12-31 | 2020-06-05 | 中国电力科学研究院有限公司 | Wiring diagram data display method and system based on graph conversion |
| CN112286884A (en) * | 2020-11-04 | 2021-01-29 | 国网湖南省电力有限公司 | Method, system and medium for automatically generating topology of ring main unit of power distribution network |
| WO2022100233A1 (en) * | 2020-11-12 | 2022-05-19 | 全球能源互联网研究院有限公司 | Graph database-based power grid retrieval method and system |
Non-Patent Citations (4)
| Title |
|---|
| 张德金;吴红卫;佘运波;: "基于统一电网资源模型的电网资源数据维护机制和关键技术的研究", 电气应用, no. 2 * |
| 罗志宏 等: "实现配电网合环潮流计算的快速方法", 第六届电力工业节能减排学术研讨会论文集 * |
| 董朝霞;戴琦;杨峰;: "基于CIM和SVG的电网建模技术", 电力系统及其自动化学报, no. 05 * |
| 邹亮;: "基于关系约束的XML元素近似查询研究", 科技广场, no. 01 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115358030B (en) | 2023-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105429291B (en) | The correlating method of intelligent substation primary connection figure and electrical secondary system logic connectivity diagram | |
| CN103675600B (en) | Based on the Fault Diagnosis of Distribution Network system and method for topological knowledge | |
| CN103970887B (en) | A kind of information flow display system and method based on GIS power distribution network figures | |
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| CN103955789B (en) | A kind of supply path analysis method based on allotment Integrated Model | |
| CN112765258B (en) | Power distribution network graph model checking management system and method thereof | |
| CN105718636B (en) | A kind of plant stand main wiring diagram model automatic switching method | |
| CN110046391B (en) | Automatic transformer substation primary wiring diagram generation method based on monitoring information table | |
| CN112039197A (en) | Automatic mapping method of distribution room topological graph and computer readable storage medium | |
| CN105335584A (en) | Distribution network system single line drawing generation optimization device and method | |
| CN103106565A (en) | Power grid information real-time display method and device which are based on geographic information system (GIS) and supervisory control and data acquisition (SCADA) | |
| CN104104151B (en) | The cut-in method of distribution terminal facility information | |
| CN109933634B (en) | Power system graph drawing method based on power radiation range | |
| CN110826165A (en) | GIS-based power supply path display method for important power users | |
| CN110196852A (en) | Regulation cloud grid model data management method and system based on metadata management | |
| CN104881739B (en) | Data consistency verification method is matched somebody with somebody by a kind of battalion based on IEC61970/61968 CIM standards | |
| CN109871566B (en) | Loop construction method based on power grid topology technology and storage medium | |
| CN113344364A (en) | Power failure plan risk analysis method and device, electronic equipment and storage medium | |
| CN115358030B (en) | Topology structure generation method and system based on distribution network line data | |
| CN114818631A (en) | Method and device for compiling over-plan power utilization and power limiting line modification table | |
| CN113743057A (en) | Object recognition redrawing-based power grid OCS drawing conversion method | |
| CN112256922B (en) | Method and system for quickly identifying faults and power failure | |
| CN115658642B (en) | Data processing method based on power grid resource data | |
| CN112580178A (en) | Graph-model bidirectional verification method and device for energy management system | |
| CN109829612A (en) | A kind of dispatching automation device information check method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |