CN110111410B - Two-three-dimensional pipe network data organization and display method based on spatial database - Google Patents
Two-three-dimensional pipe network data organization and display method based on spatial database Download PDFInfo
- Publication number
- CN110111410B CN110111410B CN201910222137.4A CN201910222137A CN110111410B CN 110111410 B CN110111410 B CN 110111410B CN 201910222137 A CN201910222137 A CN 201910222137A CN 110111410 B CN110111410 B CN 110111410B
- Authority
- CN
- China
- Prior art keywords
- pipe
- point
- dimensional
- pipeline
- pipe network
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T17/00—Three dimensional [3D] modelling, e.g. data description of 3D objects
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Computer Graphics (AREA)
- Geometry (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention provides a two-three-dimensional pipe network data organization and display method based on a spatial database, which comprises the following specific steps: a1, counting pipe network data into a pipe point table and a pipeline table; a2, importing data in a pipe point table and a pipe line table into a spatial database, and creating a pipe point layer and a pipe line layer; b1, acquiring a spatial range of a pipe network in a spatial database; b2, dividing the space range of the pipe network and constructing a quadtree index; b3, loading the quad-tree nodes; c1, calculating the grid range of the leaf nodes of the quadtree; c2, repeatedly inquiring the edge of the dynamic pipe network modeling; and C3, calculating and rendering three-dimensional pipe network modeling parameters. The invention has the beneficial effects that: on the organization of a two-dimensional spatial database, a triangular network display is directly generated according to dynamic query data of the spatial database, model files are not generated in the middle, and two-dimensional and three-dimensional integrated storage of pipe network data is realized on the bottom layer in a real sense.
Description
Technical Field
The invention relates to the technical field of pipe network data organization, in particular to a two-dimensional and three-dimensional pipe network data organization and display method based on a spatial database.
Background
The underground pipeline is used for transmitting information, transmitting energy and discharging resources and is a life line of a city. The traditional pipeline management mode is generally two-dimensional pipeline management based on CAD or GIS, which can describe basic attribute information and spatial distribution information of the pipeline, but the spatial stereo characteristics and the spatial staggered relationship between the spatial stereo characteristics and the spatial staggered relationship of the pipeline are difficult to describe accurately and intuitively. With the upgrading of application requirements, the three-dimensional underground pipeline technology is increasingly applied to various underground pipeline information systems. The three-dimensional pipeline is added, the stereoscopic impression and the vivid sense of the pipeline can be improved, the comprehensive and real reflection of the distribution condition of the underground comprehensive pipeline is facilitated, and an auxiliary decision making function is provided for the efficient work driving of governments, the emergency accident handling and the urban sustainable development.
However, the three-dimensional spatial data model data expression and analysis technology is not mature, the related three-dimensional analysis and application of the underground pipeline are carried out by depending on a two-dimensional spatial data model, and the working mode for constructing the three-dimensional data of the pipeline is usually to realize the three-dimensional modeling of the pipeline data based on a certain automatic three-dimensional modeling tool according to the data such as the burial depth, the elevation, the material quality and the pipe diameter and the information of related characteristic attachments stored in the two-dimensional pipeline data attribute. The three-dimensional display of the pipe network data is also a very complex process, a mainstream three-dimensional scene mainly constructs nodes in a three-dimensional space, and the nodes dynamically load and unload the model files according to cutting scheduling so as to ensure the limited calling of a program memory and a display card. Due to the complexity of three-dimensional development, a three-dimensional data management method, which may also be referred to as a three-dimensional database, is generally used for recording the spatial position and posture (scaling factor and rotation angle) of a three-dimensional node and the address of a dynamically scheduled model file.
Due to the complexity of pipe network modeling calculation and the complexity of three-dimensional platform display scheduling, the prior art generally separates two processes, that is, two-dimensional spatial data of an original pipe network is stored and managed through a spatial database or a shp file, a three-dimensional pipeline model file is stored and managed through a three-dimensional platform such as Skyline or City maker, three-dimensional pipeline model data is called when pipeline three-dimensional visual display is carried out, and two-dimensional pipeline data is still called when specific pipeline information management application is carried out.
Disclosure of Invention
In view of the above, the invention provides a two-three-dimensional pipe network data organization and display method based on a spatial database, which utilizes the openness of the spatial database to a two-dimensional platform, solves the complexity of modeling and displaying the pipe network data by a three-dimensional display platform, and realizes real two-three-dimensional storage integration at the bottom layer.
The invention provides a two-dimensional and three-dimensional pipe network data organization and display method based on a spatial database, which comprises the following steps:
pipe network data organization:
a1, collecting pipe network data of field survey, and counting the pipe network data into a pipe point table and a pipeline table;
further, the pipe point table comprises attribute fields such as pipe point numbers, X coordinates, Y coordinates, ground elevations, burial depths, well depths, component types, general purpose, equipment numbers, accessories, characteristics, accessory scales, accessory type codes, structure codes, pipe point materials, construction times, exploration time and the like; the pipeline meter comprises attribute fields such as a pipe section code, a starting point number, an end point number, a mixed connection code, a pipeline type, an embedding mode, a starting point ground elevation, an end point ground elevation, a starting point outer top elevation, an end point outer top elevation, a starting point inner bottom elevation and an end point inner bottom elevation.
Further, the topological relation between the pipe point table and the pipeline table is established by associating the starting point number and the end point number of the pipeline table with the pipe point number of the pipe point table.
A2, importing the data in the tube point table and the pipeline table in the step A1 into a spatial database, and creating two spatial data layers, namely a tube point layer and a pipeline layer;
further, the tube point diagram layer uses the X coordinate and the Y coordinate in the tube point table to construct a geometric field, and other attributes in the tube point table are reserved; the pipeline layer uses the starting point number and the end point number in the pipeline table to associate with the pipeline point table to obtain the X coordinate and the Y coordinate of the starting point and the end point of the pipeline, so that the geometric field of the pipeline is constructed according to the coordinates, and other attributes in the pipeline table are reserved.
Index construction and node loading:
b1, acquiring a spatial range of a pipe network in a spatial database;
further, the spatial range is a union of rectangular bounding boxes formed by geometric elements of the tube points and geometric elements of the pipelines.
B2, dividing the space range of the pipe network into 4 L Each grid, wherein L is a natural number greater than 0, and a quad tree of an L level is constructed for grid indexing;
b3, loading the nodes of the quad tree generated in the step B2 in a three-dimensional engine by using an LOD mode;
further, the specific process of loading the quadtree nodes by using the LOD mode is as follows: loading a root node LOD _0 of the quad tree, loading a next level LOD _ L node after entering an LOD _ (L-1) node according to the current viewpoint distance during three-dimensional display, wherein the LOD _ L node is a leaf node of the quad tree, the LOD _ (L-1) node is a father node associated with the leaf node, and the LOD _ L leaf node layer has 4 in total L And L is a natural number greater than 0.
And (3) carrying out dynamic pipe network modeling and rendering after the scene is loaded to the LOD _ L node with the highest level:
c1, calculating the grid range of the quad-tree according to the hierarchical relation of the leaf nodes of the quad-tree in the tree;
c2, performing spatial query in the pipe point layer created in the step A2 by taking the grid range as a constraint condition to obtain a first pipe point set needing to construct a three-dimensional model;
c3, using the pipe point numbers in the first pipe point set to correlate and query the pipeline layer created in the step A2, and obtaining a first pipeline set having a connection relation with the first pipe point set;
c4, using the starting point number and the end point number in the first pipeline set and the pipe point numbers in the first pipe point set to associate and query the pipe point map layers created in the step A2, and obtaining a second pipe point set which has a connection relation with the first pipeline set and does not contain the first pipe point set;
c5, using the pipe point numbers in the second pipe point set to correlate and query the pipeline layer created in the step A2, and obtaining a second pipe set which has a connection relation with the second pipe point set and does not contain the first pipe set;
c6, marking the pipe point coordinates in the first pipe point set and the pipe line set of which the pipe line geometric center coordinates in the first pipe line set are in the grid range as a data owned set of the current grid, and calculating the three-dimensional pipe network modeling parameters of each pipe network device for the set with complete topological relation by using a pipe network three-dimensional modeling calculation method, namely calculating the three-dimensional pipe network modeling parameters of the pipe points and the pipe lines by combining the pipe diameters, the attachments, the well parameters, the connection relations and the like in the spatial database in the step A2;
furthermore, the three-dimensional pipe network modeling parameters of the pipe points and the pipelines are middleware of a non-model file between pipe point and pipeline modeling calculation and gridding, the middleware is a parameter text stream, parameters in the middleware are used for constructing grid display only when a three-dimensional scene is rendered, and the parameter text stream is a light-weight-level transmission medium and is only used for data transmission and is not stored or edited. It should be noted that the parameter text stream includes information such as absolute elevations of the center point of the calculation pipe point and the center points of the two ends of the pipeline, and is a process variable set for calculating the two-dimensional pipe network entity into the three-dimensional pipe network entity.
C7, dispatching LOD nodes by a three-dimensional engine, constructing a triangulation network model of the data possession set of the grid LOD and giving texture information to the material by utilizing the three-dimensional pipe network modeling parameters obtained by the calculation in the step C6, and finally drawing and displaying the triangulation network model in a three-dimensional scene.
The technical scheme provided by the invention has the following beneficial effects:
(1) The invention provides a two-three-dimensional pipe network data organization and display method based on a spatial database, which adopts a mode of dynamic query, calculation, data flow dynamic transmission, modeling and rendering, namely, a model file is not generated, the process of two-dimensional pipe network three-dimension is executed in the data flow process, and because no intermediate file or intermediate database exists, the method can directly modify spatial column space fields or attribute fields of the spatial database in the pipe network editing process, so that the purposes of editing in a two-dimensional platform, three-dimensional synchronous updating, editing in a three-dimensional platform and synchronous updating in a two-dimensional view can be achieved, and the two-three-dimensional synchronization of pipe network data in the true sense can be realized;
(2) According to the two-three-dimensional pipe network data organization and display method based on the spatial database, a grid LOD construction is combined with an edge multi-query mode, and three-dimensional rendering can be performed on massive pipe network data in real time to form a three-dimensional pipeline scene;
(3) The method uses an open standard space database, namely only data modification is carried out on data editing and updating without extra linkage updating codes, so that two three-dimensional platforms and a B/S system can achieve data synchronization as long as the standard space database is supported, and the method has the characteristic of multi-platform oriented;
(4) The data organization of the method is aligned with the database standard of the pipe network to the maximum extent, namely, the data table structure detected by the pipe network is taken, and the table structure does not need to be abandoned or forcibly converted into a certain rule specified by the method.
Drawings
Fig. 1 is a schematic flow chart of a two-dimensional and three-dimensional pipe network data organization and display method based on a spatial database according to an embodiment of the present invention;
fig. 2 is a schematic diagram of constructing a quadtree at a level of L =2 when a pipe network is divided according to an embodiment of the present invention;
fig. 3 is a schematic diagram of an edge multi-query method for dynamic pipe network modeling according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a pipeline of pipe points to be displayed in a three-dimensional scene according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be further described with reference to the accompanying drawings.
Referring to fig. 1, an embodiment of the present invention provides a method for organizing and displaying two-dimensional and three-dimensional pipe network data based on a spatial database, which includes the following steps:
pipe network data organization:
a1, collecting pipe network data of field survey, and counting the pipe network data into a pipe point table and a pipeline table;
the pipe point table comprises attribute fields such as pipe point numbers, X coordinates, Y coordinates, ground elevations, burial depths, well depths, component types, multi-channel connectors, equipment numbers, accessories, characteristics, accessory scales, accessory type codes, structure codes, pipe point materials, construction times, exploration time and the like; the pipeline meter comprises attribute fields such as a pipe section code, a starting point number, an end point number, a mixed connection code, a pipeline type, an embedding mode, a starting point ground elevation, an end point ground elevation, a starting point outer top elevation, an end point outer top elevation, a starting point inner bottom elevation and an end point inner bottom elevation. The topological relation between the pipe point table and the pipeline table is established by associating the pipe point numbers of the pipe point table with the starting point numbers and the end point numbers of the pipeline table.
And A2, importing the data in the tube point table and the pipeline table in the step A1 into a spatial database, and creating two spatial data layers, namely a tube point layer and a pipeline layer.
Specifically, the tube point diagram layer uses the X coordinate and the Y coordinate in the tube point table to construct a geometric field, and reserves other attributes in the tube point table; the pipeline layer uses the starting point number and the end point number in the pipeline table to associate with the pipeline point table to obtain the X coordinate and the Y coordinate of the starting point and the end point of the pipeline, so that the geometric field of the pipeline is constructed according to the coordinates, and other attributes in the pipeline table are reserved.
In this embodiment, pipe network data organization is performed by using the shape data carrier and the rainwater pipe network data. Firstly, arranging rainwater pipe network data into a pipe point table and a pipeline table, and then constructing a shape pipe point map layer by using an X coordinate and a Y coordinate in the pipe point table, wherein the shape pipe point map layer is named as 'rainwater _ not.shp'; and (3) using the starting point number and the end point number in the pipeline table to externally connect the associated pipeline point table, acquiring X coordinates and Y coordinates of the starting point and the end point of the pipeline, and constructing a shape pipeline layer named as rainwater _ lin. The rainwater _ non.shp and the rainwater _ lin.shp are two-three-dimensional integrated data sources.
So far, two-dimensional rainwater pipe network layers are constructed through two data tables, and it should be noted that the network uses an attribute topology rule of field detection, that is, a network data layer with a calculated topology cannot be generated, a pipe point needs to use a point number to inquire a starting point number and an end point number of a pipeline table in two-dimensional editing, and a geometric field X coordinate and a geometric field Y coordinate of a pipeline are synchronously updated.
In the embodiment, model bodies of various types of pipe fittings are stored in a memory in the form of parameter text streams (middleware), and the three-dimensional pipe network display is a process of scheduling the parameter text streams, and three-dimensionally gridding and displaying the parameters. But two issues need to be considered: (1) For massive pipe network data, it is impractical to store parameter text streams required by the whole network three-dimensionality in a memory; (2) How to edit and update the pipe network organization structure, for example, picking up a certain section of pipeline to modify the pipe diameter, the three-way pipe point connected with the pipeline will also change, so that the other two pipelines connected with the three-way pipe will also change, and thus the continuous continuation will cause that all the calculated middleware need to be recalculated without an explicit termination point, and if the calculation process is terminated easily, the result may be different from the calculation process of the whole network for re-three-dimensionality, so that the result is different.
In order to solve the above problems, in this embodiment, a level of Detail (LOD) technology is used, a gridding modeling method is combined, and a method of querying for multiple times by using an edge is used, so as to implement dynamic query of pipe nodes and pipeline data in a three-dimensional scene, dynamic calculation and storage of middleware, and real-time rendering of a three-dimensional pipe network model. The method comprises the following specific steps:
index construction and node loading:
b1, acquiring a pipe network range of a spatial database, namely a union set of rectangular bounding boxes formed by geometric elements of pipe points and geometric elements of pipelines;
b2, dividing the space range of the pipe network into 4 L Each grid, wherein L is a natural number greater than 0, and a quad tree of an L level is constructed for grid indexing;
referring to fig. 2, a schematic diagram of a quadtree with a level of L =2 is constructed when a pipe network range is divided according to an embodiment of the present invention, where each node in the tree corresponds to a region of the pipe network range, any non-leaf node has 4 child nodes, and a sampling region of the child node exactly bisects a parent node. As shown in the figure, the root node LOD _0 of the tree covers the whole pipe network, the root node is divided into four equal parts to obtain 4 LOD _1 nodes, and one LOD _1 node is divided into four equal parts to obtain 4 LOD _2 nodes.
And B3, loading the quad tree nodes in the three-dimensional engine by using an LOD mode.
Specifically, a root node LOD _0 of the quadtree is loaded first, and a next-level LOD _ L node is loaded after entering an LOD _ (L-1) node according to a current viewpoint distance during three-dimensional display, wherein the LOD _ L node is a leaf node of the quadtree, the LOD _ (L-1) node is a father node associated with the leaf node, and the LOD _ L leaf node layer has 4 in total L And L is a natural number greater than 0.
It should be noted that, when the LOD dynamic loading technology is applied to massive pipe network data on a three-dimensional platform, the problem that the number of frames is too low or even unloaded data reaches the upper limit of the memory due to the clipping calculation of too many LODs by the three-dimensional scene may result. Thus, in said step B2, the whole pipe network area is divided into 4 L And C, establishing L-level quad-tree for grid indexing, expanding the LOD one-to-one pipe network records into a pair of zone records, and loading pipe network data in a range interval when the LOD loads a quad-tree node in the step B3.
In the problem (2), whether the whole pipe network data needs to be modeled again after the data is edited and updated depends on the query granularity of the LOD dynamic query spatial database, namely the size of the grid corresponding to the leaf node of the quad tree constructed in the step B2, and the optimal condition is that one node corresponds to one pipe pipeline. However, due to the topological relationship between the pipe points and the pipelines, the ideal query granularity cannot be achieved. The embodiment adopts a mode of edge multi-query to solve the problem (2) on the basis of constructing the grid LOD.
Specifically, the steps of performing dynamic pipe network modeling and rendering after the scene is loaded to the LOD _ L node of the highest level are as follows:
c1, calculating a grid range M of the quad-tree according to the hierarchical relation of leaf nodes LOD _ L of the quad-tree in the tree;
c2, performing space query in the pipe point map layer created in the step A2 by taking the grid range M as a constraint condition to obtain a first pipe point set P0 of a three-dimensional model to be constructed;
the pseudo SQL code is:
SELECT*FROM POINT_TABLE WHERE geom.STIntersect(M.Extent)；
c3, using the pipe point numbers of the first pipe point set P0 to carry out correlation query on the pipeline layers created in the step A2, and acquiring a first pipeline set L0 having a connection relation with the first pipe point set P0;
the pseudo SQL code is:
SELECT FROM LINE _ TABLE WHERE start No. IN P0. OR end No. IN P0.;
c4, using the starting point number and the end point number of the first pipeline set L0 and the pipe point number in the first pipe point set P0 to associate the pipe point map layer created in the query step A2, and acquiring a second pipe point set P1 which has a connection relation with the first pipeline set L0 and does not contain the first pipe point set P0;
the pseudo SQL code is:
SELECT FROM POINT _ TABLE WHERE ID IN L0. start number OR ID IN L0. end number AND ID NOT IN P0. POINT number;
c5, using the pipe point numbers in the second pipe point set P1 to carry out correlation query on the pipeline layer created in the step A2, and obtaining a second pipe set L1 which has a connection relation with the second pipe point set P1 and does not contain the first pipe set L0;
the pseudo SQL code is:
SELECT FROM LINE _ TABLE WHERE (start number IN p1. Point number OR end number IN p1. Point number) AND ID NOT IN l0.ID;
referring to fig. 3, the middle grid is M, the first pipe point set P0 is a pipe point set in the grid range M, the first pipe line set connected to the first pipe point set P0 is L0, the center of the pipe line in the first pipe line set L0 may be in the grid range M or outside the grid range M, the other pipe point sets connected to the first pipe line set L0 except the first pipe point set P0 are the second pipe point set P1, the other pipe line sets connected to the second pipe point set P1 except the first pipe line set L0 are the second pipe line set L1, the second pipe point set P1 and the second pipe line set L1 are always outside the grid range M, the connection relationship between the first pipe point set P0 and the first pipe line set L0 is complete, and a key topology attribute of three-dimensional modeling can be provided.
C6, marking the pipe point set and the pipeline set of the pipe point coordinate in the first pipe point set P0 and the pipe line geometric center coordinate in the first pipeline set L0 in the grid range M as a data owned set of the current LOD grid, and calculating the three-dimensional pipe network modeling parameters of each pipe network device for the set with complete topological relation by using a pipe network three-dimensional modeling calculation method, namely calculating the three-dimensional pipe network modeling parameters of the pipe points and the pipelines by combining the pipe diameters, the attachments, the well parameters, the connection relations and the like in the spatial database in the step A2;
it should be noted that the three-dimensional pipe network modeling parameter of the pipe point and the pipeline is an intermediate piece of a non-model file between the pipe point and the pipeline modeling calculation and the gridding, the intermediate piece is a parameter text stream, the parameter in the intermediate piece is used for constructing the grid display only when the three-dimensional scene is rendered, the parameter text stream is a light-weight-level transmission medium and is only used for data transmission and is not stored or edited, for example, for a circular pipeline, parameters such as pipe diameter, nut, texture, closure, three-dimensional coordinates of a start point/end point, normal line and the like are recorded in the text stream, for a circular three-way pipe point, parameters such as three end point coordinates of a tee, pipe point center coordinates, pipe diameters of three end points and the like are recorded in the text stream, and information such as absolute elevations of the center point of the pipe point and the center points of the pipeline is calculated, which is a process variable set for calculating the two-dimensional pipe network entity to the three-dimensional pipe network entity.
The specific process of calculating the absolute elevation is as follows: for a pipe network with elevation related information stored in pipe point equipment, the absolute elevation of the central point of a pipe point can be obtained through 'ground elevation-burial depth-pipe radius' or 'vertex elevation-pipe radius' or 'bottom point elevation + pipe radius' stored in the pipe point; for a pipe network with elevation related information stored in pipeline equipment, the absolute elevation of the central points of two tanks of the pipeline can be respectively calculated by 'starting point/end point ground elevation-starting point/end point burial depth-pipe radius' stored in the pipeline.
Referring to fig. 4, in a grid range M, a model body is constructed only for pipe points and pipelines surrounded by ellipses, a first pipe point set P0 is a pipe point set to be constructed belonging to a current grid range, a second pipe point set P1 and a second pipe line set L1 are outside the grid, so that only modeling calculation is involved (part of modeling attributes of the first pipe point set P0 and the first pipe line set L0 need to be obtained by calculation according to the second pipe point set P1 and the second pipe line set L1) and no pipe model body is constructed, pipelines whose centers are within the current grid range M in the first pipe line set L0 are screened to construct a pipe model body, and pipelines whose centers are not within the current range (surrounded by rectangles in the figure) belong to other grids without construction, so as to ensure that each grid does not repeatedly construct a pipe model body.
C7, dispatching LOD nodes by a three-dimensional engine, constructing a triangulation network model of a data-owned set of the current grid LOD by using the three-dimensional pipe network modeling parameters obtained by calculation in the step C6, giving texture information to materials, and finally drawing and displaying the data in a three-dimensional scene.
The specific process of calculating the absolute elevation is as follows: for a pipe network with elevation related information stored in pipe point equipment, the absolute elevation of the central point of a pipe point can be obtained through 'ground elevation-buried depth-pipe radius' or 'vertex elevation-pipe radius' or 'bottom point elevation + pipe radius' stored in the pipe point; for the pipe network with the elevation related information stored in the pipeline equipment, the absolute elevation of the central points at the two ends of the pipeline can be respectively calculated by 'starting point/end point ground elevation-starting point/end point burial depth-pipe radius' stored in the pipeline.
According to the two-three-dimensional pipe network data organization and display method based on the spatial database, the two-three-dimensional pipe network data is directly generated on the organization of the two-dimensional spatial database according to the dynamic query data of the spatial database to be displayed in a triangular net mode, model files are not generated in the middle, and the pipe network data is stored in a two-three-dimensional integrated mode in the bottom layer in the real sense.
The features of the embodiments and embodiments described herein above may be combined with each other without conflict.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (8)
1. A two-three-dimensional pipe network data organization and display method based on a spatial database is characterized by comprising the following steps:
pipe network data organization:
a1, collecting pipe network data of field investigation, and counting the pipe network data into a pipe point table and a pipeline table;
a2, importing the data in the tube point table and the pipeline table in the step A1 into a spatial database, and creating a tube point layer and a pipeline layer;
index construction and node loading:
b1, acquiring a spatial range of a pipe network in a spatial database;
b2, dividing the space range of the pipe network into 4 L Each grid, wherein L is a natural number greater than 0, and a quad tree of an L level is constructed for grid indexing;
b3, loading the nodes of the quadtree generated in the step B2 in a three-dimensional engine;
carrying out dynamic pipe network modeling and rendering:
c1, calculating the grid range of the leaf nodes according to the hierarchical relation of the leaf nodes of the quad tree in the tree;
c2, performing spatial query in the pipe point layer created in the step A2 by taking the grid range as a constraint condition to obtain a first pipe point set needing to construct a three-dimensional model;
c3, using the pipe point numbers in the first pipe point set to correlate and query the pipeline layer created in the step A2, and obtaining a first pipeline set having a connection relation with the first pipe point set;
c4, using the starting point number and the end point number in the first pipeline set and the pipe point numbers in the first pipe point set to associate and query the pipe point map layers created in the step A2, and obtaining a second pipe point set which has a connection relation with the first pipeline set and does not contain the first pipe point set;
c5, using the pipe point numbers in the second pipe point set to correlate and query the pipeline layer created in the step A2, and obtaining a second pipe set which has a connection relation with the second pipe point set and does not contain the first pipe set;
c6, marking the pipe point set and the pipeline set of which the pipe point coordinates in the first pipe point set and the pipe geometric center coordinates in the first pipeline set are in the grid range as a data owning set of the grid, and calculating the three-dimensional pipe network modeling parameters of each pipe network device for the set with complete topological relation;
and C7, scheduling leaf nodes by a three-dimensional engine, constructing a triangulation network model of the data possession set in the step C6 by using the three-dimensional pipe network modeling parameters obtained by calculation in the step C6, giving texture information to the material, and finally drawing and displaying the material in a three-dimensional scene.
2. The spatial database-based two-three-dimensional pipe network data organization and display method according to claim 1, wherein in the step A1, the attribute fields in the pipe point table include pipe point number, X coordinate, Y coordinate, ground elevation, burial depth, well depth, component type, multi-channel, equipment number, attachment, feature, attachment scale, attachment type code, structure code, pipe point material, construction year, exploration time; the attribute fields in the pipeline meter comprise a pipe section code, a starting point number, an end point number, a mixed connection code, a pipeline type, a burying mode, a starting point ground elevation, an end point ground elevation, a starting point outer top elevation, an end point outer top elevation, a starting point inner bottom elevation and an end point inner bottom elevation; the topological relation between the pipe point table and the pipeline table is established by associating the pipe point numbers of the pipe point table with the starting point number and the end point number of the pipeline table.
3. The spatial database-based two-three-dimensional pipe network data organization and display method according to claim 2, wherein in the step A2, the pipe point map layer constructs geometric fields by using X coordinates and Y coordinates in the pipe point table, and reserves other attributes in the pipe point table; the pipeline layer uses the starting point number and the end point number in the pipeline table to associate with the pipeline point table to obtain the X coordinate and the Y coordinate of the starting point and the end point of the pipeline, so that the geometric field of the pipeline is constructed according to the coordinates, and other attributes in the pipeline table are reserved.
4. The method for organizing and displaying data of a two-dimensional and three-dimensional pipe network based on a spatial database according to claim 1, wherein in the step B1, the spatial range of the pipe network is a union of rectangular bounding boxes formed by geometric elements of pipe points and geometric elements of pipelines.
5. The spatial database-based two-three-dimensional pipe network data organization and display method according to claim 1, wherein the step B3 loads the quadtree nodes in an LOD manner, and the specific process is as follows: loading a root node LOD _0 of the quad tree, loading a next level LOD _ L node after entering an LOD _ (L-1) node according to the current viewpoint distance during three-dimensional display, wherein the LOD _ L node is a leaf node of the quad tree, the LOD _ (L-1) node is a father node associated with the leaf node, and the LOD _ L leaf node layer has 4 in total L And L is a natural number greater than 0.
6. The two-three dimensional pipe network data organization and display method based on the spatial database according to claim 1, wherein in the step C6, the specific process of calculating the three-dimensional modeling parameters is as follows: and D, calculating three-dimensional body modeling parameters of the pipe points and the pipelines by combining the pipe diameters, the attachments, the well parameters and the connection relations in the spatial database in the step A2.
7. The method according to claim 1, wherein the three-dimensional pipe network modeling parameters of the pipe points and the pipelines calculated in step C6 are middleware of a non-model file between the pipe point and pipeline modeling calculation and the gridding, and the middleware is a parameter text stream.
8. The two-three dimensional pipe network data organization and display method based on the spatial database according to claim 1, characterized in that a LOD detail level technology is adopted in the pipe network data display process, a gridding modeling method is combined, and a method of utilizing edge multiple query is utilized to realize dynamic query of pipe point and pipeline data under a three-dimensional scene, dynamic calculation and storage of middleware, and real-time rendering of a three-dimensional pipe network model.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910222137.4A CN110111410B (en) | 2019-03-22 | 2019-03-22 | Two-three-dimensional pipe network data organization and display method based on spatial database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910222137.4A CN110111410B (en) | 2019-03-22 | 2019-03-22 | Two-three-dimensional pipe network data organization and display method based on spatial database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110111410A CN110111410A (en) | 2019-08-09 |
| CN110111410B true CN110111410B (en) | 2023-02-10 |
Family
ID=67484497
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910222137.4A Active CN110111410B (en) | 2019-03-22 | 2019-03-22 | Two-three-dimensional pipe network data organization and display method based on spatial database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110111410B (en) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112562075A (en) * | 2019-09-26 | 2021-03-26 | 中国石油天然气集团有限公司 | Three-dimensional geological modeling method and device for multi-slip-layer structure |
| CN110796736B (en) * | 2019-10-30 | 2023-02-10 | 广州海格星航信息科技有限公司 | Method and device for establishing Beidou space map grid model |
| CN111536428B (en) * | 2020-05-13 | 2022-07-26 | 华北水利水电大学 | Pipe network leakage control model based on big data and construction method thereof |
| CN111858743B (en) * | 2020-07-27 | 2023-08-11 | 重庆市勘测院 | Spatial defect detection method for drainage pipeline |
| US20220205808A1 (en) * | 2020-12-25 | 2022-06-30 | Mapsted Corp. | Localization using tessellated grids |
| CN113051312B (en) * | 2021-03-17 | 2023-07-04 | 中广核工程有限公司 | Material information statistical method, device, equipment and storage medium |
| CN116186187B (en) * | 2023-04-21 | 2023-07-14 | 山东省国土测绘院 | Method, system, medium and equipment for constructing grouping recursion type pipeline combination entity |
| CN116521921B (en) * | 2023-05-16 | 2024-02-13 | 三峡科技有限责任公司 | Configuration and query method of data model in three-dimensional visual scene |
| CN116257318B (en) * | 2023-05-17 | 2023-07-21 | 湖南一特医疗股份有限公司 | Oxygen supply visual construction method and system based on Internet of things |
| CN117271500B (en) * | 2023-11-21 | 2024-02-13 | 上海叁零肆零科技有限公司 | Data restoration method and related device for gas pipe network node |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8665266B2 (en) * | 2010-06-23 | 2014-03-04 | The United States Of America, As Represented By The Secretary Of The Navy | Global visualization process terrain database builder |
| CN106683198B (en) * | 2015-11-10 | 2020-02-14 | 星际空间（天津）科技发展有限公司 | Three-dimensional automatic modeling and scheduling rendering method for comprehensive pipe network |
| CN106373188B (en) * | 2016-08-31 | 2019-02-01 | 正元地理信息有限责任公司 | A kind of generation method and system of underground pipe network threedimensional model |
-
2019
- 2019-03-22 CN CN201910222137.4A patent/CN110111410B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110111410A (en) | 2019-08-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110111410B (en) | Two-three-dimensional pipe network data organization and display method based on spatial database | |
| US11222465B2 (en) | Embedded urban design scene emulation method and system | |
| CN110704928B (en) | Method for converting BIM model into GIS model | |
| CN101630419B (en) | Structuring method for three-dimensional visualizing system of urban synthesis pipeline network | |
| CN109360260A (en) | A kind of cut-away restructing algorithm of triangle gridding threedimensional model | |
| CN103679804A (en) | System and method for automatically building three-dimensional model of data of underground pipeline | |
| CN110189409B (en) | PLAXIS-based rapid true three-dimensional geological modeling method and system | |
| CN108573112B (en) | Space flight test emission two-dimensional layout analysis method based on digital simulation | |
| CN103942838A (en) | Point cloud data based single tree three-dimensional modeling and morphological parameter extracting method | |
| CN106095907A (en) | Based on the laser point cloud data management method that Octree is integrated with three-dimensional R star tree | |
| CN105320811A (en) | Method for establishing topological connected model of urban underground electricity pipe network | |
| CN110442925A (en) | A kind of three-dimensional visualization method and system based on the reconstruct of real-time dynamic partition | |
| CN106373191A (en) | Railway field investigation system based on 3DGIS and investigation method | |
| CN108765567A (en) | A kind of system for building urban design digitlization sand table | |
| CN108629836B (en) | Method for converting CATIA BIM entity model into Supermap GIS standardized model | |
| CN105005580B (en) | A kind of method for showing reservoir landform and device thereof | |
| CN106023297A (en) | Texture dynamic organization method for fine three-dimensional model | |
| CN105261067A (en) | Overground and underground integrated modeling method based on true 3D volumetric display technique and system | |
| CN111445569B (en) | Sedimentary geological evolution dynamic simulation method | |
| CN112017287A (en) | Three-dimensional parametric modeling and efficient rendering method for underground cable facilities | |
| CN112687007B (en) | Stereoscopic grid chart generation method based on LOD technology | |
| Zlatanova | 3D geometries in spatial DBMS | |
| CN110610541B (en) | BIM geologic model modeling method based on database and GIS technology | |
| CN111553836A (en) | Method for automatically generating closed filling surface by scattered multiple lines | |
| CN117408004A (en) | Method and system for realizing three-dimensional pipe network dynamic modeling based on vector slicing technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |