CN118708643A - Data-driven distribution network visualization scenario platform construction method and system - Google Patents

Abstract

The present invention provides a method and system for constructing a distribution network visualization scene platform based on data-driven, including: obtaining product information, distribution network ledger data and distribution network environment data; storing the product information, distribution network ledger data and distribution network environment data in a pre-created database; connecting the pre-created database with a modeling system, calling the database in the modeling system, and generating a distribution network visualization scene platform. The present invention achieves the effect of one-click construction and calling of distribution network equipment and scenes in the distribution network platform through the connection between the database and the modeling system. The method can also quickly complete the reconstruction of multiple environmental scenes of the distribution network, providing innovative solutions for the management and optimization of the distribution network.

Description

Data-driven distribution network visualization scenario platform construction method and system

Technical Field

The present invention relates to the field of power system visualization, and in particular to a method and system for constructing a data-driven distribution network visualization scenario platform.

Background Art

In the construction and operation of smart grids in recent years, the distribution network, as the end of the power system, undertakes the important task of transmitting electric energy to users. With the gradual popularization of new technologies such as distributed energy, the distribution network needs to be monitored and managed more efficiently and intelligently. At present, the construction of two-dimensional visualization distribution network system in my country is relatively mature, but the realization of high-quality three-dimensional visualization management of distribution network requires knowledge of multiple fields such as geographic information system (GIS), three-dimensional modeling, and data visualization. In addition, the data of distribution network usually comes from different sources. The quality and consistency of data are one of the key factors for realizing three-dimensional visualization management. Reliable visualization modeling must be based on high-quality data. Therefore, it is necessary to ensure that the data obtained from various data sources are accurate, complete and consistent. At the same time, it is necessary to consider what data processing algorithms and visualization technologies to use to retain the information of the data to the greatest extent and accurately present the key information such as the structure and status of the distribution network. In addition, the distribution network is a dynamic system, and its state may change at any time. The system needs to be able to capture the changes in the state of the distribution network in a timely manner and update the visualization model in real time to maintain the accuracy of the model. In order to ensure the accuracy of visualization modeling, it is necessary to establish an effective model verification and evaluation mechanism, including comparison verification with actual scenarios, verification using historical data, and testing with simulators to verify the accuracy and reliability of the model. Considering the above situation, how to improve the efficiency of distribution network visualization modeling while ensuring the accuracy of visualization modeling and provide guarantee for the visualization management of distribution network platform has become one of the problems at this stage.

One of the existing visual modeling methods is the rule-based modeling method. That is, the rule-based modeling method usually relies on expert knowledge or a rule base, and describes the structure and state of the distribution network by defining a series of rules and performing a visual display. The accuracy of this method is highly dependent on the accuracy and completeness of the rules. As the distribution network is a complex dynamic system, it is difficult for the rules to cover all possible situations, so there are problems with imperfect and inaccurate models.

The second existing visual modeling method is the modeling method based on physical models, that is, the modeling method based on physical models uses physical equations and models to describe the operating status of the distribution network, usually including circuit analysis, topology analysis, etc. However, this method requires a lot of computing resources and time to establish an accurate physical model, and has high requirements on the system parameters, topology structure, etc. Moreover, in practical applications, due to the complexity and uncertainty of the distribution network, the physical model may not be able to fully and accurately describe the behavior of the system.

Summary of the invention

In order to solve the problem that the model constructed by the prior art cannot fully and accurately describe the behavior of the system, the present invention proposes a method for constructing a distribution network visualization scenario platform based on data-driven, including:

Obtain product information, distribution network ledger data, and distribution network environment data;

Storing the product information, distribution network ledger data and distribution network environment data in a pre-created database;

The pre-created database is connected to the modeling system, the database is called in the modeling system, and a distribution network visualization scenario platform is generated.

Optionally, storing the product information, distribution network ledger data, and distribution network environment data in a pre-created database includes:

Processing the product information by using a scripting language, storing the processed product information in a distribution network equipment model database;

Acquire topological relationship model data according to the distribution network ledger data in a hierarchical construction manner, and store the topological relationship model data in a distribution network equipment topological relationship database;

Storing the distribution network environment data in a distribution network environment scenario database;

Wherein, the database includes: a distribution network equipment model database, a distribution network equipment topology relationship database and a distribution network environment scenario database.

Optionally, the processing of the product information by using a scripting language and storing the processed product information in a distribution network equipment model database includes:

Based on the spatial and attribute information of the two-dimensional drawings in the product information, obtain the outline dimension data of key equipment in the distribution network;

Processing the outline dimension data of the key equipment by using a scripting language to obtain real-time structural function data;

Storing the real-time structural function data in a distribution network equipment model database;

The real-time structural function data refers to the distribution network equipment data and a series of operation command data when modeling based on the distribution network equipment data using 3D modeling software.

Optionally, the adopting a hierarchical construction method to obtain topology relationship model data according to the distribution network ledger data, and storing the topology relationship model data in a distribution network equipment topology relationship database includes:

Acquire device layer data and line layer data from the distribution network ledger data;

And assign connection labels at the fulcrum according to the set rules;

Storing the device layer data, line layer data and connection labels at the fulcrums in a distribution network equipment topology database;

The device layer data includes: device number, device name, and device longitude and latitude coordinate data;

The line layer data includes: connection relationships between various devices.

Optionally, the set rules include:

Only at the branch point, the connection label between the upper-level device and the first lower-level device is assigned the number of the upper-level device;

In the case of non-branching points, the connection labels between devices are assigned the numbers 0 and -1, where the number 0 indicates that there is a connection between the two devices, and the number -1 indicates that there is no connection between the two devices.

Optionally, the pre-created database is connected to a modeling system, the database is called in the modeling system, and a distribution network visualization scenario platform is generated, including:

In the modeling system, product information, distribution network ledger data and distribution network environment data in the database are called to build a panel of distribution network equipment, topology relationship and environment;

The distribution network equipment, topological relationship and environment panels form a distribution network visualization scene platform.

Optionally, it also includes: updating a pre-built database based on real-time acquired distribution network ledger data and distribution network environment data.

On the other hand, the present invention also discloses a data-driven distribution network visualization scene platform construction system, comprising:

Parameter acquisition module, used to obtain product information, distribution network ledger data and distribution network environment data;

A database generation module, used to store the product information, distribution network ledger data and distribution network environment data into a pre-created database;

The visualization scene generation module is used to connect the pre-created database with the modeling system, call the database in the modeling system, and generate a distribution network visualization scene platform.

Optionally, the database generation module includes:

The device model library construction submodule is used to process the product information through a scripting language and store the processed product information into a distribution network device model database;

A topology relationship library construction submodule is used to obtain topology relationship model data according to the distribution network ledger data in a hierarchical construction manner, and store the topology relationship model data in a distribution network equipment topology relationship database;

An environmental scenario library construction submodule is used to store the distribution network environmental data into a distribution network environmental scenario database;

Wherein, the database includes: a distribution network equipment model database, a distribution network equipment topology relationship database and a distribution network environment scenario database.

Optionally, the device model library construction submodule is specifically used for:

Based on the spatial and attribute information of the two-dimensional drawings in the product information, obtain the outline dimension data of key equipment in the distribution network;

Processing the outline dimension data of the key equipment by using a scripting language to obtain real-time structural function data;

Storing the real-time structural function data in a distribution network equipment model database;

The real-time structural function data refers to the distribution network equipment data and a series of operation command data when modeling based on the distribution network equipment data using 3D modeling software.

Optionally, the topology relationship library construction submodule is specifically used for:

Acquire device layer data and line layer data from the distribution network ledger data;

And assign connection labels at the fulcrum according to the set rules;

Storing the device layer data, line layer data and connection labels at the fulcrums in a distribution network equipment topology database;

The device layer data includes: device number, device name, and device longitude and latitude coordinate data;

The line layer data includes: connection relationships between various devices.

Optionally, the visualization scene generation module is specifically used for:

In the modeling system, product information, distribution network ledger data and distribution network environment data in the database are called to build a panel of distribution network equipment, topology relationship and environment;

The distribution network equipment, topological relationship and environment panels form a distribution network visualization scene platform.

Optionally, it also includes: an update module, which is used to update the pre-built database according to the distribution network ledger data and distribution network environment data obtained in real time.

In another aspect, the present application further provides a computing device, comprising: at least one processor and a memory;

The memory is used to store one or more programs;

When the one or more programs are executed by the at least one processor, the method for constructing a data-driven distribution network visualization scene platform as described above is implemented.

On the other hand, the present application also provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed, the method for constructing a data-driven distribution network visualization scenario platform as described above is implemented.

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

The present invention provides a method for constructing a distribution network visualization scene platform based on data-driven, including: obtaining product information, distribution network ledger data and distribution network environment data; storing the product information, distribution network ledger data and distribution network environment data in a pre-created database; connecting the pre-created database with a modeling system, calling the database in the modeling system, and generating a distribution network visualization scene platform. The present invention achieves the effect of one-click construction and calling of distribution network equipment and scenes in the distribution network platform through the connection between the database and the modeling system. The method can also quickly complete the reconstruction of various environmental scenes of the distribution network, providing innovative solutions for the management and optimization of the distribution network.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG1 is a flow chart of a method for constructing a data-driven distribution network visualization scenario platform according to the present invention;

FIG2 is a flowchart of a specific implementation of a method for constructing a data-driven distribution network visualization scenario platform according to the present invention;

FIG3 is a schematic diagram of the classification rules of the ledger data of the main equipment and branch equipment at all levels of the distribution network of the present invention;

FIG4 is a wiring logic diagram of the present invention taking a primary branch as an example;

FIG. 5 is a schematic diagram of the computer device structure of the present invention.

DETAILED DESCRIPTION

The present invention provides a method for constructing a data-driven distribution network visualization scene platform, which drives and stores a variety of data in combination with a three-dimensional virtual engine and a database, realizes high-precision modeling, model import, and scene reconstruction functions of distribution equipment on the basis of ensuring modeling time, and satisfies users' roaming and management in a three-dimensional distribution network scene. The main purpose is to realize real-time monitoring and analysis of the distribution network status, provide accurate decision support for operation and maintenance management, optimize the operation status of the distribution network, improve operation and maintenance efficiency and user experience, so as to achieve the purpose of improving the management level and operation efficiency of the distribution network.

Embodiment 1:

A method for constructing a data-driven distribution network visualization scenario platform, as shown in FIG1, includes:

Step 1: Obtain product information, distribution network ledger data and distribution network environment data;

Step 2: storing the product information, distribution network ledger data and distribution network environment data in a pre-created database;

Step 3: Connect the pre-created database to the modeling system, call the database in the modeling system, and generate a distribution network visualization scenario platform.

The present invention provides a method for constructing a distribution network visualization scene platform based on data-driven, which is further developed on a three-dimensional virtual engine, and the platform has batch reconstruction and scene roaming functions. Among them, batch reconstruction includes the functions of one-click generation of distribution network feeders and one-click switching of different scenes, which relies on the connection between the database and the modeling system, calling the database in the modeling system, building different panels of distribution network equipment, topological relationships and environments, and adding generation, switching and deletion buttons. The database here takes the MySQL database as an example, and is further introduced in comparison with the present invention. The roaming function of the distribution network platform is implemented by calling a script button to meet the construction of a three-dimensional visualization platform for the distribution network, and specifically includes the following steps and features:

Step 1: Obtain product information, distribution network ledger data, and distribution network environment data, including:

Use the product information provided by the equipment supplier, where the product information includes: the space and attribute information of the manufacturer's two-dimensional drawings;

Obtain distribution network ledger data through GIS/SCADA and other systems, including the latitude and longitude information, equipment model, equipment spacing and nameplate data of each equipment in the distribution network;

The distribution network environment data is obtained through the world map system. The environment data specifically includes:

Terrain data and road data, where terrain data is the digital elevation model (DEM); road network is the geometric information of roads and streets, including road width, intersections, etc.

Building data, where building data is building outline/boundary: the outer outline or boundary information of a building to define the basic shape of the building.

Step 2: Storing the product information, distribution network ledger data and distribution network environment data in a pre-created database, specifically including:

Three sub-databases are established: distribution network equipment model database, distribution network equipment topology relationship database and distribution network environment scenario database.

The distribution network equipment model database is called in the modeling system to realize the construction of the distribution network equipment model, the distribution network equipment topology relationship database is called in the modeling system to realize the multi-level import of the distribution network topology relationship model, and the distribution network environment scenario database is called in the modeling system to realize the model construction of multiple environment scenarios of the distribution network.

Using the space and attribute information of the manufacturer's two-dimensional drawings, the outline size data of key equipment in the distribution network (including but not limited to 15 types of equipment such as poles, lightning arresters, and reactors) is obtained. A table - Equipment is created in the distribution network equipment model database, and the data is processed by the script language to obtain the real-time structural function data for generating the distribution network equipment model and store it in the table. The real-time structural function data refers to the distribution network equipment data and the series of operation command data when the distribution network equipment data is modeled using 3D modeling software. The script voice in this embodiment uses MAXscript code.

The connection between 3D MAX and MySQL database is completed through MAXscript code to read and store various parameters to ensure efficient and accurate model creation.

A hierarchical construction method is adopted to obtain topological relationship model data based on ledger data. The data is divided into equipment layer and line layer. Equipment layer data includes equipment numbers, equipment names, equipment longitude and latitude coordinate data, etc. of various distribution network equipment such as poles, electrical switches, substations, etc.; the line layer manages cable line data, including the connection relationship between various devices, etc. The connection relationship between devices is expressed by connection labels. The connection label is assigned as follows: only at the branch point, the connection label between the upper-level device and the first lower-level device is assigned the number of the upper-level device; in the case of non-branch points, the connection label between devices is assigned the number 0 and the number -1, the number 0 indicates that there is a connection between the two devices, and the number -1 indicates that there is no connection between the two devices.

The device layer data, line layer data and connection labels at the fulcrums are stored in the distribution network equipment topology relationship database. In this embodiment, MySQL Server software is used to store the device layer data, line layer data and connection labels at the fulcrums in the distribution network equipment topology relationship database.

Using geographic information system technology, map information of distribution network equipment is obtained, including terrain, road and building data. The terrain data is the digital elevation model (DEM); the road network is the geometric information of roads and streets, including road width, intersections, etc.; the building data is the building outline/boundary, including the outer contour or boundary information of the building to define the basic shape of the building.

The above map information is converted into a 3D model through a modeling tool. Here, we take the CityEngine (city 3D modeling) tool as an example. This includes selecting the building bottom surface from the map information and associating the map. The CGA rule language of CityEngine is run to generate batch models, and the connection and data storage of the CityEngine tool and MySQL database are realized.

Step 3: Connect the pre-created database to the modeling system, call the database in the modeling system, and generate a distribution network visualization scenario platform.

In the modeling system, product information, distribution network ledger data and distribution network environment data in the database are called to build a panel of distribution network equipment, topology relationship and environment;

The distribution network equipment, topological relationship and environment panels form a distribution network visualization scene platform.

The present invention realizes the generation, switching and deletion of distribution network equipment, the multi-level import operation of the distribution network topology relationship model, and the generation, switching and deletion of the distribution network multi-environment scene, thereby completing the whole process of the distribution network visualization platform from equipment layout to environment setting, and providing users with interactive and real-time updated data-driven options. This not only improves the visualization effect of the distribution network scene, but also provides an intuitive and easy-to-operate management platform for relevant personnel.

The present invention proposes a method for constructing a distribution network visualization scene platform based on data drive. By connecting the database and the modeling system, the multi-source data obtained from the database by relying on equipment suppliers, GIS/SCADA and other systems and the world map system is called to achieve the effect of one-click construction and calling of distribution network equipment and scenes in the distribution network platform. The method can quickly complete the reconstruction of various environmental scenes of the distribution network and provide innovative solutions for the management and optimization of the distribution network.

Referring to FIG. 2 , the present invention provides a database driven method for power distribution network scene reconstruction, comprising the following steps:

S1. Construction of a distribution network scenario visualization platform for the modeling system. The constructed platform relies on connecting to a database that stores multi-source data and is data-driven, so as to call the stored data with one click;

S2. Construction of a multi-source database, the constructed database includes a distribution network equipment model database, a distribution network equipment topology relationship database, and a distribution network environment scenario database;

S3. Use the product information provided by the equipment supplier to obtain the distribution network equipment data. When constructing the equipment model, obtain the real-time structural function data required for constructing the model and store it in the distribution network equipment model database;

S4. Obtain distribution network ledger data through GIS/SCADA and other systems. When constructing a topological relationship model, obtain the topological relationship data required for model construction and store it in the distribution network topological relationship database to complete the multi-level import of the distribution network topological structure model.

S5. The distribution network environment data is obtained through the world map system. When constructing the distribution network environment scenario model, the real-time structural function data required for constructing the scenario model is obtained and stored in the distribution network environment scenario database to complete the rapid reconstruction of the distribution network multi-environment scenario.

Please refer to Figure 3. The level is identified according to the number of "-" in the name. When the number of "-" is 0, it is the main road; when the number of "-" is 1, it is the first-level branch; when the number of "-" is 2, it is the second-level branch. The next-level branch will judge the number before the "-" of the current branch to determine which distribution network device of the previous branch it is a branch of. For example, if it is the branch of the third distribution network device of the previous branch, the y coordinate of the distribution network device will be changed (a ₁ +a ₂ ,b ₁ ,0), where a ₁ represents the distance between the device and the first-level branch, a ₂ represents the distance between the device and the second-level branch, and b ₁ represents the distance between the distribution network device and the corresponding distribution network device of the previous branch. This is done by analogy to complete the establishment of the coordinates of the entire distribution network device.

In order to display cables in the modeling system, a new idea is needed to connect the distribution network devices (cable line drawing). Please refer to Figure 3. The index number is determined by the first device of each branch corresponding to the device of the previous branch. The index number is the number of the device of the previous branch.

Please refer to Figure 4, the connection confirmation method is: set the connection confirmation method storage column of the last device of each level branch to -1, -1 represents not connected to the next device; set the column of the remaining devices to 0 to ensure the connection between devices at the same level.

Furthermore, in S1, the modeling system platform is built, including:

Specifically, create a Canvas and place the required UI controls. Create an Image in the Canvas and place the image as the background of the login interface. Create Button, InputField, and Text to make the function buttons, account and password input boxes, and titles of the login interface. Add trigger events to the buttons. When the login button is clicked, the login interface is displayed. When the registration button is clicked, the registration interface is displayed and the login interface disappears.

Create an empty object as the parent object of the Camera, name it Player, and add the Character Controller component to this parent object to provide first-person or third-person movement control. Create a C# script to control the speed of the player's movement: define a floating-point value variable, define two floating-point variables to obtain key values, and define a three-dimensional variable to control the direction. Multiply the two key values obtained by the movement speed, and use the three-dimensional variable as the movement direction. Finally, complete the perspective movement operation through code control to further realize the roaming function.

Furthermore, in S2, the MySQL database and the modeling system are connected, including:

Specifically, import the MySQL connection library MySql.Data.dll in the Unity project and use the code snippet to establish a connection.

Three sub-databases are established in the MySQL database: distribution network equipment model database, distribution network equipment topology database, and distribution network environment scenario database

Furthermore, in S3, the equipment required for equipment modeling specifically includes:

There are 15 common types of equipment: poles, lightning arresters, reactors, insulators, transformers, circuit breakers, capacitors, current transformers, voltage transformers, energy storage equipment, photovoltaic equipment, wires and cables, disconnectors, incoming and outgoing line cabinets, and fuses.

Physical segmentation and edge detection technology are used to extract physical information of equipment including boundary dimension data from equipment suppliers and network images, and MAXscript code is used to complete the creation of distribution network equipment model primitive parameters. MAXscript modeling operations include turning, extrusion, scanning, editing splines, editing polygons, etc.

Specifically, the turning function is defined as latheOperation, which includes setting the number of segments, cutting angle and radius of the cube using the acquired boundary information; the extrusion function is defined as extrudeOperation, which includes performing an extrusion height operation on the cube using the acquired size information; the scanning function is defined as sweepOperation, which includes performing a path scanning on the cube using the acquired boundary information; the spline editing function is defined as editSplineOperationsplineObj, which includes a series of operations on control points; the polygon editing function is defined as editPolyOperation, which includes a series of operations for editing polygons using the acquired boundary information.

Specifically, a table - Equipment - is created in the distribution network equipment model database. Inserting a specified operation type into the Equipment table includes the creation and assembly of the distribution network equipment model element parameters. Assembly includes organic integration by coordinates. The operation parameters are stored in JSON format to complete the storage of the real-time structural function data of the distribution network equipment model, which is convenient for quick call in the modeling system later.

Furthermore, S4 specifically includes:

Use MySQL Server software to create a new sub-database distribution network equipment topology relationship database - Ledger.

In Ledger, create i data tables named PoleDat_i (i represents the branch level) to store the x, y, z coordinates, categories and connection labels of each level of branches. The structure of the data table is as follows:

PoleID: unique identifier of each distribution network device; x: x coordinate; y: y coordinate; z: z coordinate; Type: distribution equipment category; SY: connection label at the branch. Only at the branch point, the connection label between the upper-level device and the first lower-level device is assigned the number of the upper-level device; LJ: The connection labels between non-branch devices are assigned the numbers 0 and -1. The number 0 indicates that there is a connection between the two devices, and the number -1 indicates that there is no connection between the two devices.

Extract the distribution network ledger information provided by GIS/SCADA through Python script:

Use Python's file reading library openpyxl to load the ledger file;

Parse the file and extract the x, y, z coordinates and connection labels of each distribution network device as follows:

1. Input data: read data from the known ledger data xls file;

2. Data conversion: convert xls file to xlsx format;

3. Data segmentation: data is segmented into the main channel and multiple branch files according to specific standards;

4. Insert columns: insert multiple new columns at the specified position;

5. Assignment operation: assign values to the newly inserted columns.

The assignment operation process is as follows:

1. Extract x, y, z coordinates and connection labels:

The coordinates are extracted according to the distance relationship between the distribution network equipment in the ledger data, the distance of the distribution network equipment is obtained in the ledger data, and the coordinates of the first distribution network equipment are set to (0,0,0). The coordinates of the next distribution network equipment at the same level are (x1,0,0); the coordinates of the next distribution network equipment are (x2,0,0) and so on, where x1 represents the x-coordinate of the next distribution network equipment at the same level, and x2 represents the x-coordinate of the distribution network equipment coordinates.

2. Marking operation: Mark in the specified column according to different types of distribution network equipment;

3. Output data: save the processed data into a new xlsx file;

4. Extract the x, y, z coordinates of each distribution network device and the connection label of the device. Perform necessary data cleaning and format conversion on the extracted data to ensure data quality;

5.Store and process distribution network GIS latitude and longitude information:

Match the acquired coordinate information with the GIS longitude and latitude information, and use Python's geopandas library for data analysis and processing.

6. Import data into MySQL database:

Specifically, use Python's mysql-connector library to connect to the Network database, traverse each extracted distribution network equipment information, execute SQL insert operations to save the data into the PoleDat_i data table, and ensure that all data is correctly imported without omissions or errors.

Furthermore, in S5, the data mainly acquired are terrain data, road data and building data.

Furthermore, S5 specifically includes:

Import the map information of the distribution network equipment downloaded from the high-definition satellite map downloader into CityEngine, select the bottom surface of the modeling environment such as buildings and roads and associate them with the map, then run the 3D modeling rule program CGA syntax to batch generate building 3D models;

Specifically, the maximum height attr maxHeight and the minimum height attr minHeight are set in the CGA syntax. The modeling program sequentially reads each shp face and the corresponding attribute information, including the height of the three-dimensional environment model, the model texture, and the building structure of the environment model, and obtains the corresponding map according to the attribute information of the bottom surface of the building to generate the corresponding three-dimensional environment model building structure.

Create a sub-data distribution network environment scenario database in the database, and create a table named Environment in the database, update the scenario data such as coordinates, dimensions, and attribute data back to the table, and store real-time structural function data.

Mount the model on the modeling system:

Specifically, a Prefab is created for each model, a button is created, and a script is attached to each button to dynamically load and display the corresponding model Prefab.

Get the user information, distribution network equipment and environment model location, and cable line drawing information stored in the login panel from the MySQL database:

Use the modeling system script to query this information from the MySQL database, and use the queried data to dynamically locate and build topological relationship models in the Unity scene.

The present invention ultimately achieves the reconstruction of the distribution network scene, the generation and one-click import of key equipment in the distribution network, and completes the construction of a three-dimensional visualization platform for the distribution network.

The construction of the distribution network platform includes user registration, login panel settings, model button generation, script mounting, skybox and roaming, etc.; relying on the connection between the MySQL database and the modeling system, the MySQL database is called in the modeling system to store data, realizing user login and one-click model generation functions.

The steps for establishing three sub-databases include adding command name, command code and storage path fields to store different real-time structural function data respectively.

The physical data of key equipment in the distribution network is the size and boundary information of the equipment, which is extracted from equipment suppliers and network images using physical segmentation and edge detection technology; the real-time structural functional data refers to the structured data formed by integrating the physical data of key equipment in the distribution network with 3D Max modeling commands; a connection script is created between the MySQL database and 3D Max to complete the data interaction function and realize the storage of data in the distribution network equipment model database.

The inventory data described in S4 includes the latitude and longitude information, equipment model, equipment spacing and nameplate data of each equipment in the distribution network.

The construction of the topological structure model described in S4 specifically includes:

The equipment number information in the ledger data is extracted through a python script, and different levels of excel tables are automatically created according to the equipment number. Preferably, each excel table contains six columns of data, and the first four columns extract the equipment name and x, y, z coordinates of the distribution network according to the equipment spacing and nameplate data in the ledger data and store them. The last two columns extract and store the instruction information on whether to draw the cable line with the previous tower and the number of the tower on the previous road according to the equipment model in the ledger data, thereby completing the construction of the excel table of the multi-level distribution network equipment topology structure.

The Excel table and the six columns of data in the table are imported into the distribution network equipment topology database using the SQL statement insert function provided by MySQL.

The environmental data described in S5 specifically include:

Terrain data and road data, where terrain data is the digital elevation model (DEM); road network is the geometric information of roads and streets, including road width, intersections, etc.

Building data is building outline/boundary: the outer contour or boundary information of a building to define the basic shape of the building.

The storage in the distribution network environment scenario database described in S5 includes converting the environmental data into a CSV format understood by MySQL, completing the import of data into the distribution network environment scenario database, defining the generation rules of scenes such as buildings and roads in the environment through the CGA language, and realizing the batch processing function, thereby generating multiple different environmental scenarios.

The acquired multi-source data stored in the MySQL database and the connection between the MySQL database and the modeling system enable users to control database data calls, edit and update model information, and generate model specified locations through the modeling system interface, providing users with interactive and real-time updated data-driven operations, and completing the construction of the entire large-scale distribution network multi-scenario reconstruction platform.

Embodiment 2:

The present invention based on the same inventive concept also provides a data-driven distribution network visualization scene platform construction system, including:

Parameter acquisition module, used to obtain product information, distribution network ledger data and distribution network environment data;

A database generation module, used to store the product information, distribution network ledger data and distribution network environment data into a pre-created database;

The visualization scene generation module is used to connect the pre-created database with the modeling system, call the database in the modeling system, and generate a distribution network visualization scene platform.

Optionally, the database generation module includes:

The device model library construction submodule is used to process the product information through a scripting language and store the processed product information into a distribution network device model database;

A topology relationship library construction submodule is used to obtain topology relationship model data according to the distribution network ledger data in a hierarchical construction manner, and store the topology relationship model data in a distribution network equipment topology relationship database;

An environmental scenario library construction submodule is used to generate a distribution network environmental scenario database from the distribution network environmental data through a modeling tool;

Wherein, the database includes: a distribution network equipment model database, a distribution network equipment topology relationship database and a distribution network environment scenario database.

Optionally, the device model library construction submodule is specifically used for:

Based on the spatial and attribute information of the two-dimensional drawings in the product information, obtain the outline dimension data of key equipment in the distribution network;

Processing the outline dimension data of the key equipment by using a scripting language to obtain real-time structural function data;

Storing the real-time structural function data in a distribution network equipment model database;

The real-time structural function data refers to the distribution network equipment data and a series of operation command data when modeling based on the distribution network equipment data using 3D modeling software.

Optionally, the topology relationship library construction submodule is specifically used for:

Acquire device layer data and line layer data from the distribution network ledger data;

And assign connection labels at the fulcrum according to the set rules;

Storing the device layer data, line layer data and connection labels at the fulcrums in a distribution network equipment topology database;

The device layer data includes: device number, device name, and device longitude and latitude coordinate data;

The line layer data includes: connection relationships between various devices.

Optionally, the environment scene library construction submodule is specifically used for:

The bottom surface of the building and the associated map are selected from the distribution network environment data, and the model is generated in batches by running the rule language, and the model is stored in the distribution network environment scenario database.

Optionally, the visualization scene generation module is specifically used for:

In the modeling system, product information, distribution network ledger data and distribution network environment data in the database are called to build a panel of distribution network equipment, topology relationship and environment;

The distribution network equipment, topological relationship and environment panels form a distribution network visualization scene platform.

Optionally, it also includes: an update module, which is used to update the pre-built database according to the distribution network ledger data and distribution network environment data obtained in real time.

Example 3

As shown in FIG5 , the present invention also provides an electronic device, which may be a computer device, a single-chip device, an intelligent mobile device, etc. The electronic device in this embodiment may include a processor, a memory, a transceiver component, etc. The memory, the processor, and the transceiver component are connected via a bus; the memory may be used to store an execution program, and an exemplary execution program may include instructions; the processor is used to execute the instructions stored in the memory. The memory may also be used to store data, which may be called and/or modified when executing instructions.

The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. It is the computing core and control core of the terminal, which is suitable for implementing one or more instructions, specifically suitable for loading and executing one or more instructions in a storage medium to implement the corresponding method flow or corresponding functions, so as to realize the steps of the data-driven distribution network visualization scene platform construction method in the above embodiment.

Example 4

Based on the same inventive concept, the present invention also provides a readable storage medium, specifically an electronic device readable storage medium (Memory), which is a memory device in an electronic device for storing programs and data. It can be understood that the storage medium here can include both built-in storage media in electronic devices and, of course, extended storage media supported by electronic devices. The storage medium provides a storage space, which stores the operating system of the terminal. In addition, one or more instructions suitable for being loaded and executed by a processor are also stored in the storage space, and these instructions can be one or more execution programs (including program codes). It should be noted that the storage medium here can be a high-speed RAM memory or a non-volatile memory, such as at least one disk memory. The processor loads and executes one or more instructions stored in the storage medium, which can implement the steps of the data-driven distribution network visualization scene platform construction method in the above embodiment.

Those skilled in the art will appreciate 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 code.

The present invention is described with reference to the flowchart and/or block diagram of the method, device (system), and computer program product according to the embodiment of the present invention. It should be understood that each process and/or box in the flowchart and/or block diagram, as well as the combination of the process and/or box 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 produce a device for implementing the functions specified in one or more processes in the flowchart and/or one or more boxes in the block diagram.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer-readable memory produce a manufactured product including an instruction device that implements the functions specified in one or more processes in the flowchart and/or one or more boxes in the block diagram.

These computer program instructions may also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, whereby the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in one or more processes in the flowchart and/or one or more boxes in the block diagram.

The above are merely embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention are included in the scope of the claims of the present invention to be approved.

Claims (15)

1. A method for constructing a data-driven distribution network visualization scenario platform, comprising: Obtain product information, distribution network ledger data, and distribution network environment data; Storing the product information, distribution network ledger data and distribution network environment data in a pre-created database; The pre-created database is connected to the modeling system, the database is called in the modeling system, and a distribution network visualization scenario platform is generated. 2. The method according to claim 1, characterized in that storing the product information, distribution network ledger data and distribution network environment data in a pre-created database comprises: Processing the product information by using a scripting language, and storing the processed product information in a distribution network equipment model database; Acquire topological relationship model data according to the distribution network ledger data in a hierarchical construction manner, and store the topological relationship model data in a distribution network equipment topological relationship database; Storing the distribution network environment data in a distribution network environment scenario database; Wherein, the database includes: a distribution network equipment model database, a distribution network equipment topology relationship database and a distribution network environment scenario database. 3. The method according to claim 2, wherein the processing of the product information by using a scripting language and storing the processed product information in a distribution network equipment model database comprises: Based on the spatial and attribute information of the two-dimensional drawings in the product information, obtain the outline dimension data of key equipment in the distribution network; Processing the outline dimension data of the key equipment by using a scripting language to obtain real-time structural function data; Storing the real-time structural function data in a distribution network equipment model database; The real-time structural function data refers to the distribution network equipment data and a series of operation command data when modeling based on the distribution network equipment data using 3D modeling software. 4. The method according to claim 2, characterized in that the layered construction method is used to obtain topological relationship model data according to the distribution network ledger data, and the topological relationship model data is stored in the distribution network equipment topological relationship database, comprising: Acquire device layer data and line layer data from the distribution network ledger data; And assign connection labels at the fulcrum according to the set rules; Storing the device layer data, line layer data and connection labels at the fulcrums in a distribution network equipment topology database; The device layer data includes: device number, device name, and device longitude and latitude coordinate data; The line layer data includes: connection relationships between various devices. 5. The method according to claim 4, wherein the set rules include: Only at the branch point, the connection label between the upper-level device and the first lower-level device is assigned the number of the upper-level device; In the case of non-branching points, the connection labels between devices are assigned the numbers 0 and -1, where the number 0 indicates that there is a connection between the two devices, and the number -1 indicates that there is no connection between the two devices. 6. The method according to claim 1, characterized in that the step of connecting the pre-created database with a modeling system, calling the database in the modeling system, and generating a distribution network visualization scenario platform comprises: In the modeling system, product information, distribution network ledger data and distribution network environment data in the database are called to build a panel of distribution network equipment, topology relationship and environment; The distribution network equipment, topological relationship and environment panels form a distribution network visualization scene platform. 7. The method according to claim 1 is characterized in that it also includes: updating a pre-created database based on the distribution network ledger data and distribution network environment data obtained in real time. 8. A data-driven distribution network visualization scenario platform construction system, characterized by comprising: Parameter acquisition module, used to obtain product information, distribution network ledger data and distribution network environment data; A database generation module, used to store the product information, distribution network ledger data and distribution network environment data into a pre-created database; The visualization scene generation module is used to connect the pre-created database with the modeling system, call the database in the modeling system, and generate a distribution network visualization scene platform. 9. The system according to claim 8, wherein the database generation module comprises: The device model library construction submodule is used to process the product information through a scripting language and store the processed product information in a distribution network device model database; A topology relationship library construction submodule is used to obtain topology relationship model data according to the distribution network ledger data in a hierarchical construction manner, and store the topology relationship model data in a distribution network equipment topology relationship database; An environmental scenario library construction submodule is used to store the distribution network environmental data into a distribution network environmental scenario database; Wherein, the database includes: a distribution network equipment model database, a distribution network equipment topology relationship database and a distribution network environment scenario database. 10. The system according to claim 9, wherein the device model library construction submodule is specifically used for: Based on the spatial and attribute information of the two-dimensional drawings in the product information, obtain the outline dimension data of key equipment in the distribution network; Processing the outline dimension data of the key equipment by using a scripting language to obtain real-time structural function data; Storing the real-time structural function data in a distribution network equipment model database; The real-time structural function data refers to the distribution network equipment data and a series of operation command data when modeling based on the distribution network equipment data using 3D modeling software. 11. The system according to claim 9, wherein the topology relationship library construction submodule is specifically used for: Acquire device layer data and line layer data from the distribution network ledger data; And assign connection labels at the fulcrum according to the set rules; Storing the device layer data, line layer data and connection labels at the fulcrums in a distribution network equipment topology database; The device layer data includes: device number, device name, and device longitude and latitude coordinate data; The line layer data includes: connection relationships between various devices. 12. The system according to claim 9, wherein the visualization scene generation module is specifically used for: In the modeling system, product information, distribution network ledger data and distribution network environment data in the database are called to build a panel of distribution network equipment, topology relationship and environment; The distribution network equipment, topological relationship and environment panels form a distribution network visualization scene platform. 13. The system according to claim 8 is characterized in that it also includes: an update module for updating a pre-built database according to the distribution network ledger data and distribution network environment data obtained in real time. 14. An electronic device, comprising: at least one processor and a memory; the memory and the processor are connected via a bus; The memory is used to store one or more programs; When the one or more programs are executed by the at least one processor, a method for constructing a data-driven distribution network visualization scene platform as described in any one of claims 1 to 7 is implemented. 15. A readable storage medium, characterized in that an execution program is stored thereon, and when the execution program is executed, a method for constructing a data-driven distribution network visualization scene platform as described in any one of claims 1 to 7 is implemented.