3D water environment treatment integrated digital platform and application method thereof

Abstract

The application provides a 3D water environment treatment integrated digital platform and an application method thereof, and belongs to the technical field of three-dimensional modeling.The 3D water environment treatment integrated digital platform comprises a database server and a cloud platform.The database server is used for receiving water environment data uploaded by an external terminal, and storing the water environment data after detection and reconstruction.The database server is also used for storing a pre-designed three-dimensional model and pre-collected three-dimensional scene data.The cloud platform is used for generating a visual file according to the water environment data, the three-dimensional model and the three-dimensional scene data stored in the database server in response to a data request of the external terminal, and transmitting the visual file to the corresponding external terminal, so as to realize visual display of data through the external terminal.The application realizes visual display of water environment data based on 3D visualization technology.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of three-dimensional modeling, and more particularly to a 3D water environment treatment integrated digital platform and an application method thereof. BACKGROUND

[0002] Water environment treatment involves many pipelines and facility points, and there are many inconveniences in checking and management. In the prior art, manual checking and paper record are usually used to check and manage the water environment, but this method has high cost and low efficiency, and the treatment results cannot be effectively displayed.

[0003] Therefore, the present application aims to provide a solution to solve the above problems. SUMMARY

[0004] The present application aims to provide a 3D water environment treatment integrated digital platform and an application method thereof to solve the technical problems of high cost, low efficiency and inability to visually display the treatment results in the prior art.

[0005] To achieve the above-mentioned purpose, the technical solution adopted by the present application is to provide a 3D water environment treatment integrated digital platform, comprising:

[0006] a database server and a cloud platform;

[0007] The database server is used to receive water environment data uploaded by an external terminal, and after detecting and reconstructing the water environment data, store the detected and reconstructed water environment data; the database server is also used to store a pre-designed three-dimensional model and pre-collected three-dimensional scene data;

[0008] The cloud platform is used to generate a visual file according to the water environment data, three-dimensional model and three-dimensional scene data stored in the database server in response to a data request of an external terminal, and transmit the visual file to the corresponding external terminal, so as to realize visual display of data through the external terminal.

[0009] In a possible implementation manner, the database server is specifically used to:

[0010] detect the data integrity of the water environment data uploaded by the external terminal, detect the naming specification of the file, and store the water environment data that passes the detection to a temporary database;

[0011] The water environment data is subjected to edge detection, attribute consistency detection, data precision detection and logical consistency detection in the temporary database, the water environment data passing the detection is subjected to data splicing and topological reconstruction, the spliced and reconstructed water environment data is subjected to topological relationship detection and splicing relationship detection, and the water environment data passing the detection is stored into the formal database.

[0012] In a possible implementation, the database server is specifically configured to store the metadata corresponding to the three-dimensional model by the following steps:

[0013] The volume metadata, the surface metadata, the line metadata and the point metadata corresponding to the three-dimensional model are stored in the form of pointer values or numbers respectively;

[0014] For the volume metadata corresponding to the three-dimensional model, the corresponding relationships between the volume metadata and the surface metadata, the volume metadata and the line metadata, and the volume metadata and the point metadata are stored; for the surface metadata corresponding to the three-dimensional model, the corresponding relationships between the surface metadata and the line metadata, and the surface metadata and the point metadata are stored; for the line metadata corresponding to the three-dimensional model, the corresponding relationship between the line metadata and the point metadata is stored.

[0015] In a possible implementation, the water environment data is various types of investigation data, including:

[0016] The investigation data of sewage treatment plants, pipe network, river, various pollution sources and urban water environment; the two-dimensional vector data of each position point in the investigation area is included in the various types of investigation data; correspondingly, the cloud platform is specifically configured to:

[0017] In response to an investigation data query request of an external terminal, the cloud platform acquires corresponding investigation data, a three-dimensional model and three-dimensional scene data from the database server according to the investigation data query request, generates a visualization file, and transmits the visualization file to the corresponding external terminal, so as to realize visual display of the data through the external terminal.

[0018] In a possible implementation, the cloud platform specifically generates a visualization file by the following steps:

[0019] The three-dimensional scene data is acquired from the database server, and the three-dimensional scene data is preprocessed;

[0020] The preprocessed three-dimensional scene data is processed based on a three-dimensional engine tool, a three-dimensional terrain scene file is generated, and the three-dimensional scene file is imported into a browser;

[0021] Obtain two-dimensional vector data of each position point corresponding to the three-dimensional scene from various troubleshooting data stored in the database server, and superimpose the two-dimensional vector data on the three-dimensional terrain scene file in the browser to obtain a labeled three-dimensional terrain scene file.

[0022] Obtain three-dimensional building model data corresponding to the three-dimensional scene from the three-dimensional scene data stored in the database server, and adjust the position and size of each building in the three-dimensional terrain scene file according to the three-dimensional building model data to obtain a visual file of the processed three-dimensional scene.

[0023] In a possible implementation, the three-dimensional scene data includes various aerial photograph data, satellite image data, DEM data, three-dimensional building model data, and building texture data required for constructing the three-dimensional scene.

[0024] Correspondingly, the cloud platform specifically preprocesses the three-dimensional scene data by the following steps:

[0025] The three-dimensional scene data is subjected to DEM error correction processing, image stitching processing, image fusion processing, and building 3DMAX model format conversion processing.

[0026] In a possible implementation, the cloud platform is further configured to:

[0027] Perform water environment management analysis according to the water environment data; the water environment management analysis at least includes the following analysis contents: 3D outlet tracing analysis, 3D pipe network profile analysis, and 3D pipe line patrol analysis.

[0028] In a possible implementation, the 3D water environment management integrated digital platform further includes a mobile terminal.

[0029] The mobile terminal is configured to collect water environment data, upload the collected water environment data to the database server, or send a data request to the cloud platform and receive a visual file returned by the cloud platform according to the data request, and realize visual display of data based on the visual file.

[0030] In a possible implementation, the 3D water environment management integrated digital platform further includes a display terminal.

[0031] The display terminal is in communication connection with the cloud platform, and is configured to realize visual display of data based on the visual file generated by the cloud platform.

[0032] To solve the above problems, the application further provides an application method of the 3D water environment management integrated digital platform, including:

[0033] The external terminal sends a data request to the cloud platform.

[0034] The cloud platform receives the data request sent by the external terminal, obtains corresponding water environment data, a three-dimensional model and three-dimensional scene data from the database server according to the data request, generates a visualization file, and transmits the visualization file to the corresponding external terminal.

[0035] The external terminal receives the visualization file and realizes visual display of data based on the visualization file.

[0036] The 3D water environment treatment integrated digital platform and the application method thereof have the following beneficial effects: the database server is designed to store various water environment data, three-dimensional models and three-dimensional scene data required for constructing a three-dimensional scene, and the water environment data is detected and reconstructed before storing the water environment data, so that recording errors and inconvenience in checking caused by paper records are effectively avoided, and the subsequent data analysis means are effectively supported, so that the cost problem caused by manual investigation is greatly reduced, and the efficiency of water environment treatment is improved. Moreover, the three-dimensional visualization display scheme is provided, that is, the cloud platform generates a visualization file by calling data in the database server in response to a data request of the external terminal, and the external terminal directly realizes three-dimensional visualization display based on the visualization file. Different from the visualization display in the prior art, the visualization display of the present application is cloud rendering and direct display of the external terminal, which can effectively avoid the processing pressure caused by local rendering, realize visualization bearing of massive engineering investigation data, and ensure the three-dimensional visualization effect of data. BRIEF DESCRIPTION OF DRAWINGS

[0037] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the embodiments or prior art description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0038] Figure 1 The structural schematic diagram of the 3D water environment treatment integrated digital platform provided by an embodiment of the present application is shown in the figure.

[0039] Figure 2 The flowchart of the application method of the 3D water environment treatment integrated digital platform provided by an embodiment of the present application is shown in the figure.

[0040] Figure 3 The meaning schematic diagram of edge data provided by an embodiment of the present application is shown in the figure.

[0041] Figure 4 The schematic diagram of pipeline data update provided by an embodiment of the present application is shown in the figure. Detailed Implementation

[0042] To make the technical problems to be solved, the technical solutions, and the beneficial effects of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present invention and are not intended to limit the present invention.

[0043] The present invention will now be described in further detail with reference to the accompanying drawings and specific embodiments.

[0044] Please refer to Figure 1 , Figure 1 This is a schematic diagram of the structure of a 3D integrated digital platform for water environment management provided in an embodiment of the present invention. The 3D integrated digital platform for water environment management 10 includes:

[0045] Database server 11 and cloud platform 12.

[0046] Database server 11 is used to receive water environment data uploaded by external terminals, and after detecting and reconstructing the water environment data, to store the detected and reconstructed water environment data. Database server 11 is also used to store pre-designed 3D models and pre-collected 3D scene data.

[0047] The cloud platform 12 responds to data requests from external terminals, generates visualization files based on water environment data, 3D models, and 3D scene data stored in the database server 11, and transmits the visualization files to the corresponding external terminals to achieve data visualization display through the external terminals.

[0048] In this embodiment, water environment data refers to data related to water environment investigation and management, such as, but not limited to, investigation data of sewage treatment plants, pipeline networks, rivers, various pollution sources, and urban water environment. There may be some overlap among these different types of investigation data. The various types of investigation data listed in this embodiment can be thematic displays of data corresponding to the database server. That is, the database server can support thematic displays of "plants," "networks," "rivers," "sources," and "cities," as well as queries for related detailed information.

[0049] In this embodiment, the external terminal can be a mobile terminal or an external computer. That is, the user can edit and upload various investigation data through an app application on the mobile terminal, or upload various investigation data through a computer via input devices such as a keyboard and microphone. This embodiment does not limit the specific form of the external terminal.

[0050] In the embodiment, the troubleshooting data can include two-dimensional vector data corresponding to the pipe network, plant station, river, pollution source and city, and the two-dimensional vector data can include location coordinates, name, attribute and other characteristics of the pipe network, plant station, river, pollution source and city.

[0051] In the embodiment, the three-dimensional scene data can be obtained by shooting by a device such as a drone, or can be directly obtained from the network, which is not limited here.

[0052] In the embodiment, the cloud platform 12 receives a data request of an external terminal, requests corresponding data from the database server 11 according to the data request of the external terminal, generates a visualization file corresponding to the data request according to the requested data, and transmits the visualization file to the corresponding external terminal, so as to realize the visualization display of the data through the external terminal.

[0053] From the above description, it can be known that the embodiment of the application first designs a database server to store water environment data, three-dimensional models and three-dimensional scene data required for constructing a three-dimensional scene, and detects and reconstructs the water environment data before storing the water environment data, so as to effectively avoid the recording errors and inconvenience of checking caused by paper records, and on this basis, the design of the data server can effectively support subsequent data analysis methods, so as to greatly reduce the cost problem caused by manual troubleshooting, and is beneficial to improve the efficiency of water environment governance. Moreover, the embodiment of the application also provides a three-dimensional visualization display scheme, that is, the cloud platform generates a visualization file by calling data in the database server in response to a data request of an external terminal, and the external terminal can directly realize three-dimensional visualization display based on the visualization file. Different from the visualization display in the prior art, the visualization display of the embodiment of the application is cloud rendering and direct display of the external terminal, which can effectively avoid the processing pressure caused by local rendering, realize the visualization bearing of massive engineering troubleshooting data, and ensure the three-dimensional visualization effect of the data.

[0054] With the Shunde District of Foshan City as an example, the embodiment of the present application is applied to the Shunde District, and a 3D water environment treatment integrated digital platform related to the Shunde District is generated, a special display interface of 'factory', 'network', 'river','source' and 'city' of the Shunde District is constructed, and the query of related detailed information is supported. Through the construction of the 3D water environment treatment integrated digital platform of the Shunde District, the problems of recording errors and inconvenience in checking caused by paper records are effectively avoided, and on this basis, the cost problem caused by manual investigation can be greatly reduced, which is beneficial to improving the efficiency of water environment treatment. Moreover, the 3D water environment treatment integrated digital platform of the Shunde District constructed by the embodiment of the present application also supports a three-dimensional visual display scheme, that is, the cloud platform responds to the data request of the external terminal, calls the data in the database server to generate a visual file, and the external terminal can directly realize three-dimensional visual display based on the visual file. Different from the visual display in the prior art, the visual display of the embodiment of the present application is cloud rendering and direct display of the external terminal (mobile terminal or large screen segment), which can effectively avoid the processing pressure caused by local rendering, realize the visual bearing of massive engineering investigation data, and ensure the three-dimensional visual effect of the water environment data of the Shunde District.

[0055] In a possible implementation manner, the database server is specifically configured to:

[0056] The water environment data uploaded by the external terminal is subjected to data integrity detection, file naming specification detection, and the water environment data passing the detection is stored in a temporary database.

[0057] The water environment data in the temporary database is subjected to edge detection, attribute consistency detection, data precision detection and logical consistency detection, the water environment data passing the detection is subjected to data splicing and topology reconstruction, the spliced and reconstructed water environment data is subjected to topology relationship detection and splicing relationship detection, and the water environment data passing the detection is stored in a formal database.

[0058] In the embodiment, the manner of detecting the data integrity of the water environment data can be that whether each field in the data table corresponding to the water environment data is empty is detected, if a field that is empty and is a required field is included in a certain data table, it is determined that the data table is incomplete.

[0059] In the embodiment, the manner of detecting the file naming specification of the water environment data can be that the file names of each file corresponding to the water environment data are traversed, whether the file names of each file conform to a preset format is judged, and if the file name of a certain file does not conform to the preset format, it is determined that the file does not conform to the specification of the file naming.

[0060] In this embodiment, the graph consistency detection on the water environment data refers to judging whether the graphs and the corresponding data in the water environment data correspond to each other, and the logical consistency detection on the water environment data refers to detecting whether there is a contradiction in each item of data in the water environment data.

[0061] In this embodiment, the topological relationship of the water environment data refers to the topological relationship of the pipelines generated according to the pipe network investigation data in the water environment data. On this basis, a specific method of detecting the topological relationship of the water environment data can be as follows: generating a pipeline node connectivity relationship table corresponding to the topological relationship according to the generated topological relationship, the pipeline node connectivity relationship table being used to represent the connectivity relationship of each pipeline node in the topological relationship. Then, matching the pipeline node connectivity relationship table with the source data corresponding to the topological relationship to obtain a detection result of the topological relationship. A specific method of detecting the topological relationship of the water environment data can also be as follows: extracting each node in the generated topological relationship, determining the water potential value of each node according to the attribute of each node, and detecting the rationality of the topological relationship itself according to the water potential value of each node and the connectivity direction between each node (for example, if the water potential value of point A is greater than that of point B in the topological relationship, but the connectivity direction is from point B to point A, then the connectivity relationship about the two points in the topological relationship is not reasonable).

[0062] In this embodiment, a method of checking the splicing relationship of two groups of water environment data in the water environment data can be as follows: first, the two groups of water environment data are denoted as first water environment data and second water environment data, respectively, the edge data when splicing the first water environment data and the second water environment data is extracted from the first water environment data to obtain first edge data. The edge data when splicing the first water environment data and the second water environment data is extracted from the second water environment data to obtain second edge data. If the data amount of the first edge data and the second edge data is greater than a preset data amount, the features of the first edge data and the second edge data can be extracted, the feature matching degree of the first edge data and the second edge data is calculated, and if the feature matching degree of the first edge data and the second edge data is greater than a preset matching degree, it is determined that the splicing relationship of the first water environment data and the second water environment data is correct. If the data amount of the first edge data and the second edge data is less than the preset data amount, the Euclidean distance of the first edge data and the second edge data can be directly calculated, and if the Euclidean distance of the first edge data and the second edge data is less than a preset distance, it is determined that the splicing relationship of the first water environment data and the second water environment data is correct. The meaning of the edge data is shown in Figure 3 The first edge data is the data in the first water environment data that is spliced with the second water environment data, and the second edge data is the data in the second water environment data that is spliced with the first water environment data.

[0063] In a possible implementation, the database server is specifically configured to store the metadata corresponding to the three-dimensional model by the following steps:

[0064] The volume metadata, the surface metadata, the line metadata and the point metadata corresponding to the three-dimensional model are stored in the form of pointer values or numbers respectively.

[0065] For the volume metadata corresponding to the three-dimensional model, the corresponding relationships between the volume metadata and the surface metadata, the volume metadata and the line metadata, and the volume metadata and the point metadata are also stored. For the surface metadata corresponding to the three-dimensional model, the corresponding relationships between the surface metadata and the line metadata, and the surface metadata and the point metadata are also stored. For the line metadata corresponding to the three-dimensional model, the corresponding relationship between the line metadata and the point metadata is also stored.

[0066] In the embodiment, the metadata corresponding to the three-dimensional model, i.e., the volume metadata, the surface metadata, the line metadata and the point metadata, can be stored in the form of pointer values or numbers in sequence. After the volume metadata is stored, the volume metadata can be split to obtain multiple surface metadata, line metadata and point metadata, and the corresponding relationships between the volume metadata and the surface metadata, the volume metadata and the line metadata, and the volume metadata and the point metadata are stored. When the model is called subsequently, more models can be designed by changing the aforementioned corresponding relationships, thereby saving the time for subsequent model establishment and scene generation. The effects of storing the corresponding relationships between the surface metadata and the line metadata, and the line metadata and the line metadata are similar, and thus will not be described herein.

[0067] In a possible implementation, the water environment data is various types of investigation data, including:

[0068] The investigation data of sewage treatment plants, the investigation data of pipe networks, the investigation data of river channels, the investigation data of various types of pollution sources, and the investigation data of urban water environment. The two-dimensional vector data of each position point in the investigation area is included in each type of investigation data. Correspondingly, the cloud platform is specifically configured to:

[0069] In response to an investigation data query request of an external terminal, the cloud platform acquires corresponding investigation data, three-dimensional models and three-dimensional scene data from the database server according to the investigation data query request, generates a visual file, and transmits the visual file to the corresponding external terminal, so as to realize visual display of the data through the external terminal.

[0070] The investigation stage of the water environment treatment project is the basis of the digital project and the prerequisite for forming a digital bottom plate. The data types involved in this stage include basic geographic information, engineering construction document data, drawing data, 3D data of hydraulic equipment, 3D models, equipment digital data, personnel investment information, and water environment comprehensive treatment project information. Therefore, the data topic design of the database server is particularly important. In this embodiment, various investigation data is divided into sewage treatment plant investigation data, pipe network investigation data, river investigation data, various pollution source investigation data, and urban water environment investigation data. The data is displayed in the topics of "plant", "network", "river", "source", and "city" to facilitate data query and visual display.

[0071] In a possible implementation, the cloud platform specifically generates the visualization file by the following steps:

[0072] The three-dimensional scene data is obtained from the database server and preprocessed.

[0073] The preprocessed three-dimensional scene data is processed based on a three-dimensional engine tool to generate a three-dimensional terrain scene file, and the three-dimensional scene file is imported into the browser.

[0074] The two-dimensional vector data of each position point corresponding to the three-dimensional scene is obtained from the various investigation data stored in the database server, and the two-dimensional vector data is superimposed on the three-dimensional terrain scene file in the browser to obtain the labeled three-dimensional terrain scene file.

[0075] The three-dimensional building model data corresponding to the three-dimensional scene is obtained from the three-dimensional scene data stored in the database server, and the position and size of each building in the three-dimensional terrain scene file are adjusted according to the three-dimensional building model data to obtain the visualization file of the processed three-dimensional scene.

[0076] In a possible implementation, the three-dimensional scene data includes various aerial photograph data, satellite image data, DEM (Digital Elevation Model) data, three-dimensional building model data, and building texture data required for constructing the three-dimensional scene.

[0077] Correspondingly, the cloud platform specifically preprocesses the three-dimensional scene data by the following steps:

[0078] The three-dimensional scene data is subjected to DEM error correction processing, image stitching processing, image fusion processing, and building 3DMAX model format conversion processing.

[0079] In the embodiment, the three-dimensional scene data is preprocessed, and part of the preprocessed three-dimensional scene data (i.e., preprocessed various aerial photographs, satellite images, and elevation data) is directly loaded into the browser in the form of a file, and edge processing and feathering operations are performed, and subsequently, a three-dimensional terrain scene file is generated by using a three-dimensional engine tool and another part of the three-dimensional scene data, and the three-dimensional scene file is imported into the browser to realize fusion with the original data. On this basis, by connecting a spatial database in a database server, two-dimensional vector data is superimposed, and three-dimensional building model data in the database is imported into the browser to realize generation of a final engineering file (i.e., a visualization file corresponding to the three-dimensional scene).

[0080] In a possible implementation, the cloud platform is further configured to:

[0081] Water environment management analysis is performed according to the water environment data. The water environment management analysis at least includes the following analysis contents: 3D discharge source tracing analysis, 3D pipe network profile analysis, and 3D pipe line patrol analysis.

[0082] In the embodiment, subsequent data analysis can also be performed based on the data stored in the database server, for example, after finding that the sewage is not up to standard, tracing the discharge source of the sewage (i.e., 3D discharge source tracing analysis), for example, 3D pipe network profile analysis, 3D pipe line patrol analysis, and the like.

[0083] In a possible implementation, the 3D water environment management integrated digital platform further includes a mobile terminal.

[0084] The mobile terminal is configured to collect water environment data, and upload the collected water environment data to the database server. Alternatively, the mobile terminal is configured to send a data request to the cloud platform, and receive a visualization file returned by the cloud platform according to the data request, and realize visualization display of data based on the visualization file.

[0085] In the embodiment, a corresponding app application program can be designed and installed in the mobile terminal, and the mobile terminal is used to realize pipe network inspection and collection of water environment related data. On this basis, the mobile terminal can also be used to realize visualization display of query data.

[0086] In a possible implementation, the 3D water environment management integrated digital platform further includes a display terminal.

[0087] The display terminal is in communication connection with the cloud platform, and is configured to realize visualization display of data based on the visualization file generated by the cloud platform.

[0088] In the embodiment, the 3D water environment management integrated digital platform can further include a large-screen display terminal, i.e., a display terminal, to realize three-dimensional visualization display of data.

[0089] As a specific embodiment of the 3D water environment treatment integrated digital platform provided by the application, the embodiment of the application further provides a large number of three-dimensional pipe network modeling and updating scheme, and on this basis, the database server can be specifically used for:

[0090] First, the pipe network system is parameterized modeled, that is, the drainage pipe network and accessory facility information is received in the investigation process, and the three-dimensional modeling is performed on the pipes, inspection wells, gratings, culverts (channels) and the like by using the parameterized modeling technology. For a large number of three-dimensional pipe network modeling, the specific modeling process can be described as follows:

[0091] 1) Data standardization processing: a data processing tool is called to process the pipe network investigation data (for example, pipe network data in data formats such as CAD, GDB, MDB and SHP) to generate standard pipe point and pipeline vector files. In order to ensure the effect of model creation, the pipe point data and the pipeline data both carry coordinate information, and the pipe point data includes but is not limited to the following attribute fields: geophysical prospecting point number, ground elevation, well bottom elevation, characteristics and accessories and the like. The geophysical prospecting point number is the unique identification of the pipe point (which cannot be omitted and repeated), and the ground elevation and the well bottom elevation are mandatory fields. On this basis, in order to ensure the three-dimensional attributes of the pipe point data to be rich and more in line with the actual situation, different pipe point types can be recorded in the accessory field. The pipeline data includes but is not limited to the following attribute fields: starting point number, ending point number, starting point elevation, ending elevation, pipeline length, pipeline material, pipe diameter field and the like.

[0092] 2) Data modeling: the type of the pipe network segment or the pipe network point is detected, if a pipe network segment is a pipe network segment with regular shape and single structure (which cannot be reused), then the positioning, pipe diameter and material information of the two-dimensional pipe network segment are mapped as data basis, and the OpenGL (OpenGL, Open Graphics Library, Open Graphics Library) technology is used to draw the three-dimensional pipe network segment in real time. If a pipe network segment is a pipe network point with irregular shape but can be reused, such as a valve, a fire hydrant, a junction box and the like, then a high-precision three-dimensional model component library can be established in advance, the positioning, orientation and type information of the two-dimensional pipe network point are mapped as data basis, and the three-dimensional pipe network point is generated in real time. If a pipe network point is a pipe network point with regular shape but cannot be reused, such as a variable diameter, an elbow and a tee, then the positioning, orientation, pipe diameter and material information of the two-dimensional pipe network point are mapped as basis, the main pipe and branch pipe models are respectively established, the OpenGL Boolean operation is performed, and the complete solid model is formed by cutting and connecting.

[0093] Optionally, in addition to the above modeling method, the embodiment of the present application can also use manual modeling technology to pre-model the water-related element data in the pipe network investigation process, and the modeling result of the water-related element data can be directly obtained subsequently. A large amount of water-related element data will be obtained in the known project investigation process, wherein the water-related element data mainly includes plant data (wastewater treatment plant, booster pump station, etc.) and river data (river, sluice, etc.), and therefore, in order to further improve the modeling accuracy, the water-related element data in the key area can be considered for fine manual modeling. Optionally, fine three-dimensional modeling of all elements in the key area of the city can also be performed, including buildings, ground, roads, water systems, vegetation, etc. The manual modeling can use professional three-dimensional modeling software, such as 3dsMax software, Revit software, etc., and can be based on the existing modeling software and the obtained pipe network investigation data (such as GIS data, CAD drawings, photos or videos, etc.) to perform three-dimensional modeling.

[0094] Secondly, the pipe line data in the pipe network system is updated. The specific updating method can be: updating based on the pipe line basic library in the current area and the user data configuration table. For details, refer to Figure 4 As shown in the figure, the two-dimensional GIS data update result and the updated data configuration table can be obtained, the three-dimensional database is cleaned based on the two-dimensional GIS data update result and the updated data configuration table, and then the update data is imported, the topological relationship is created, and the three-dimensional update of the pipe line data is realized.

[0095] Optionally, as a specific implementation of the 3D water environment treatment integrated digital platform provided by the embodiment of the present application, weather (such as rainfall, snowfall), river water level rise, etc. can be simulated based on the 3D water environment treatment integrated digital platform.

[0096] Specifically, the database server in the embodiment of the present application can obtain the weather data of each area as a simulation data set, and then realize weather data simulation based on the simulation data set and the interface of the cloud platform. According to the knowledge of meteorology, the rainfall can be divided into seven categories. No rain level, category ID C0, intensity ≤0.1 / mm; light rain level, category ID C1, intensity 0.1-10; moderate rain level, category ID C2, intensity 10-25; heavy rain level, category ID C3, intensity 25-50; heavy rain level, category ID C4, intensity 50-100; heavy rain level, category ID C5, intensity 100-250; and extremely heavy rain level, category ID C6, intensity > 250. As a possible implementation, the cloud platform can pre-generate a scene simulation file according to each rainfall level combined with weather data, and then the scene simulation file can be called through the API interface to realize weather simulation when simulation is needed.

[0097] Specifically, for the simulation of river water level rise, the cloud platform can establish river water level and flow rate deduction simulation calculation based on two-dimensional river channel geography and water environment data stored in the database server, and push the backend calculation results to the front end for user viewing. Specifically, since the basis for the construction of simulation visualization is to establish a simulation visualization basic information environment, the embodiment can first visually simulate the river channel scene, use simulation technology to spatially describe the river channel geographic space, build an intuitive simulation model, and realize a three-dimensional realistic model based on the core technologies of virtual reality, computer animation, and scientific visualization, to realize the simulation of river water level rise through the 3D digital twin platform.

[0098] As a specific implementation effect of the present application, with the development of new generation information technology, digital twin technology, as one of the important technologies for further improving the level of intelligent water management, faces the vertical and horizontal intersection of plain river network sections in Shunde area. Under the present urban construction subgrade condition, according to the completion status of Foshan Shunde plain water conservancy construction, including river flood control engineering, plain river regulation engineering, plain drainage gate station engineering, etc., the verified model is used to analyze the plain drainage capacity of the project area and its surrounding area. According to the important and objective data collected, investigated and collected, based on the water flow equation, the water dynamic module of MIKE11 software is used to simulate the water dynamic situation of the basin, and a three-dimensional water dynamic model of the urban river is constructed taking the first Shunde link as an example. It can be applied to the simulation of water level, flow and water quantity of estuary river network, and the three-dimensional model and visual scene are used to truly reflect the characteristics of water quality change process in the study area. That is, the embodiment of the present application can construct a three-dimensional water dynamic model conforming to the actual construction situation of Shunde area through a series of engineering investigation, model establishment and model simulation analysis based on the actual construction situation of Shunde area. Based on this model, various environmental data can be queried, various environments can be simulated, water quality change can be analyzed, and the query / simulation / analysis results can be displayed in three dimensions on the corresponding digital platform. Based on the three-dimensional water dynamic model of Shunde area, the human cost can be effectively saved, and the subsequent water environment analysis and water environment construction of Shunde area can be assisted, and reliable data support is provided for the water environment management of Shunde area.

[0099] Please refer to Figure 2 The present application also provides an application method of a 3D water environment management integrated digital platform, comprising:

[0100] S201: The external terminal sends a data request to the cloud platform.

[0101] S202: After receiving the data request sent by the external terminal, the cloud platform obtains the corresponding water environment data, three-dimensional model and three-dimensional scene data from the database server according to the data request and generates a visualization file, and transmits the visualization file to the corresponding external terminal.

[0102] S203: After the external terminal receives the visualization file, the data is visualized based on the visualization file.

[0103] The database server is designed to store various water environment data, three-dimensional models required for constructing three-dimensional scenes, and three-dimensional scene data. Before storing the water environment data, the water environment data is detected and reconstructed, thereby effectively avoiding recording errors and inconvenience in checking caused by paper records. The design of the data server can effectively support subsequent data analysis methods, thereby greatly reducing the cost problem caused by manual troubleshooting and improving the efficiency of water environment management. Furthermore, the embodiment of the present application also provides a three-dimensional visualization display scheme, that is, the cloud platform generates a visualization file by calling data in the database server in response to a data request of an external terminal, and the external terminal directly displays three-dimensional visualization based on the visualization file. Unlike the visualization display in the prior art, the visualization display of the embodiment of the present application is cloud rendering and direct display of the external terminal, which can effectively avoid the processing pressure caused by local rendering, realize the visualization bearing of massive engineering troubleshooting data, and ensure the three-dimensional visualization effect of the data.

[0104] The above is only a specific embodiment of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art can easily think of various equivalent modifications or replacements within the technical range disclosed by the present application, and these modifications or replacements should be covered within the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.

Claims

1. A 3D water environment treatment integrated digital platform, characterized in that, The application relates to a water environment data processing system, which comprises a database server and a cloud platform. The database server is used for receiving water environment data uploaded by an external terminal, and storing the water environment data after detection and reconstruction; the database server is also used for storing a pre-designed three-dimensional model and pre-collected three-dimensional scene data. The cloud platform is used for generating a visualization file according to the water environment data, the three-dimensional model and the three-dimensional scene data stored in the database server, and transmitting the visualization file to a corresponding external terminal, so as to realize data visualization display through the external terminal. The database server is specifically used for: performing data integrity detection and file naming specification detection on the water environment data uploaded by the external terminal, and storing the water environment data passing the detection into a temporary database; performing edge detection, attribute consistency detection, data precision detection and logic consistency detection on the water environment data in the temporary database, performing data splicing and topological reconstruction on the water environment data passing the detection, performing topological relationship detection and splicing relationship detection on the spliced and reconstructed water environment data, and storing the water environment data passing the detection into an official database; wherein the splicing relationship detection on the spliced and reconstructed water environment data comprises: two groups of spliced and reconstructed water environment data are respectively denoted as first water environment data and second water environment data; edge data of the first water environment data when spliced with the second water environment data is extracted to obtain first edge data; edge data of the second water environment data when spliced with the first water environment data is extracted to obtain second edge data; if the data amount of the first edge data and the second edge data is greater than a preset data amount, the features of the first edge data and the second edge data can be extracted, the feature matching degree of the first edge data and the second edge data is calculated, and if the feature matching degree of the first edge data and the second edge data is greater than a preset matching degree, the splicing relationship of the first water environment data and the second water environment data is determined to be correct; if the data amount of the first edge data and the second edge data is less than a preset data amount, the Euclidean distance of the first edge data and the second edge data can be directly calculated, and if the Euclidean distance of the first edge data and the second edge data is less than a preset distance, the splicing relationship of the first water environment data and the second water environment data is determined to be correct; wherein the first edge data is data of the first water environment data for splicing with the second water environment data, and the second edge data is data of the second water environment data for splicing with the first water environment data. The database server is specifically used for storing metadata corresponding to the three-dimensional model by the following steps:

2. The 3D water environment management integrated digital platform of claim 1, wherein, the volume metadata, the surface metadata, the line metadata and the point metadata corresponding to the three-dimensional model are stored in the form of pointer values or numbers; for the volume metadata corresponding to the three-dimensional model, the corresponding relationships of the volume metadata with the surface metadata, the volume metadata with the line metadata and the volume metadata with the point metadata are stored; for the surface metadata corresponding to the three-dimensional model, the corresponding relationships of the surface metadata with the line metadata and the surface metadata with the point metadata are stored. ​ For the line element data corresponding to the three-dimensional model, the correspondence between the line element data and the point element data is also stored.

3. The integrated digital platform for 3D water environment management according to claim 1, wherein, The water environment data is various investigation data, including: Sewage treatment plant station investigation data, pipe network investigation data, river investigation data, various pollution source investigation data, and urban water environment investigation data; each type of investigation data contains two-dimensional vector data of each position point in the investigation area; correspondingly, the cloud platform is specifically used for: In response to an investigation data query request from an external terminal, the cloud platform obtains corresponding investigation data, three-dimensional model and three-dimensional scene data from the database server and generates a visualization file, and transmits the visualization file to the corresponding external terminal to realize visual display of the data through the external terminal.

4. The integrated digital platform for 3D water environment management according to claim 3, wherein, The cloud platform specifically generates a visualization file by the following steps: Obtain three-dimensional scene data from the database server and preprocess the three-dimensional scene data; Process the preprocessed three-dimensional scene data based on a three-dimensional engine tool to generate a three-dimensional terrain scene file, and import the three-dimensional scene file into a browser; Obtain two-dimensional vector data of each position point corresponding to the three-dimensional scene from various investigation data stored in the database server, and superimpose the two-dimensional vector data on the three-dimensional terrain scene file in the browser to obtain a labeled three-dimensional terrain scene file; Obtain three-dimensional building model data corresponding to the three-dimensional scene from the three-dimensional scene data stored in the database server, and adjust the position and size of each building in the three-dimensional terrain scene file according to the three-dimensional building model data to obtain a visualization file of the processed three-dimensional scene.

5. The 3D water environment treatment integrated digital platform of claim 4, wherein, The three-dimensional scene data includes various aerial photograph data, satellite image data, DEM data, three-dimensional building model data, and building texture data required for constructing a three-dimensional scene. Correspondingly, the cloud platform specifically preprocesses the three-dimensional scene data by the following steps: Perform DEM error correction processing, image stitching processing, image fusion processing, and building 3DMAX model format conversion processing on the three-dimensional scene data.

6. The integrated digital platform for 3D water environment management according to claim 1, wherein, The cloud platform is also used for: Water environment management analysis based on water environment data; the water environment management analysis includes at least one of the following analysis contents: 3D outlet tracing analysis, 3D pipe network profile analysis, and 3D pipe line patrol analysis.

7. The integrated digital platform for 3D water environment management according to claim 1, wherein, The 3D water environment management integrated digital platform also includes a mobile terminal. The mobile terminal is used to collect water environment data and upload the collected water environment data to the database server, or to send a data request to the cloud platform and receive a visualization file returned by the cloud platform according to the data request, and realize visual display of the data based on the visualization file.

8. The integrated digital platform for 3D water environment management according to claim 1, wherein, The 3D water environment management integrated digital platform also includes a display terminal. The display terminal is in communication connection with the cloud platform and is used to realize visual display of the data based on the visualization file generated by the cloud platform.

9. An application method of a 3D water environment treatment integrated digital platform, characterized in that, It includes: The external terminal sends a data request to the cloud platform; The cloud platform receives the data request sent by the external terminal, acquires corresponding water environment data, a three-dimensional model, and three-dimensional scene data from the database server according to the data request, generates a visualization file, and transmits the visualization file to the corresponding external terminal; The external terminal receives the visualization file and realizes visual display of data based on the visualization file; Before acquiring corresponding water environment data, a three-dimensional model, and three-dimensional scene data from the database server according to the data request and generating a visualization file, the method further includes: The database server performs data integrity detection and file naming specification detection on the water environment data uploaded by the external terminal, and stores the water environment data passing the detection to a temporary database; The database server performs edge detection, attribute consistency detection, data precision detection, and logical consistency detection on the water environment data in the temporary database, performs data splicing and topological reconstruction on the water environment data passing the detection, performs topological relationship detection and splicing relationship detection on the spliced and reconstructed water environment data, and stores the water environment data passing the detection to a formal database; The method for detecting the splicing relationship of the spliced and reconstructed water environment data includes: Two groups of spliced and reconstructed water environment data are denoted as first water environment data and second water environment data, respectively; Edge data for splicing the first water environment data and the second water environment data is extracted from the first water environment data to obtain first edge data; Edge data for splicing the first water environment data and the second water environment data is extracted from the second water environment data to obtain second edge data; If the data amount of the first edge data and the second edge data is greater than a preset data amount, features of the first edge data and the second edge data are extracted, a feature matching degree of the first edge data and the second edge data is calculated, and if the feature matching degree of the first edge data and the second edge data is greater than a preset matching degree, it is determined that the splicing relationship of the first water environment data and the second water environment data is correct; If the data amount of the first edge data and the second edge data is less than a preset data amount, a Euclidean distance of the first edge data and the second edge data is directly calculated, and if the Euclidean distance of the first edge data and the second edge data is less than a preset distance, it is determined that the splicing relationship of the first water environment data and the second water environment data is correct; The first edge data is data in the first water environment data for splicing the second water environment data, and the second edge data is data in the second water environment data for splicing the first water environment data.

Images