CN113535827B - Three-dimensional pipe network monomer query method and system based on structured data - Google Patents
Three-dimensional pipe network monomer query method and system based on structured data Download PDFInfo
- Publication number
- CN113535827B CN113535827B CN202111080338.9A CN202111080338A CN113535827B CN 113535827 B CN113535827 B CN 113535827B CN 202111080338 A CN202111080338 A CN 202111080338A CN 113535827 B CN113535827 B CN 113535827B
- Authority
- CN
- China
- Prior art keywords
- dimensional
- pipeline
- pipe network
- query
- model
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Human Computer Interaction (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention relates to the technical field of data query in electric digital data processing, and discloses a three-dimensional pipe network monomer query method and a three-dimensional pipe network monomer query system based on structured data, which are used for realizing query of a pipe monomer and improving query efficiency. The method comprises the following steps: simplifying the structural relationship between the three-dimensional pipelines into a topological relationship between the center lines of the three-dimensional pipelines; constructing at least two sections of three-dimensional pipelines in the region in the same three-dimensional pipeline model according to the coverage range; in a three-dimensional pipe network GIS system, a user clicks a pipeline section to be inquired through a mouse; acquiring the position of a mouse, and screening out a three-dimensional pipeline central line in a preset range near the mouse; and calculating the shortest distance between the center line of each screened three-dimensional pipeline and the mouse, determining the pipeline corresponding to the shortest distance minimum value from the three-dimensional pipeline center lines of which the shortest distance is less than or equal to the radius of the corresponding pipeline as a target pipeline monomer inquired by the user, and reading and displaying second attribute data of the target pipeline monomer.
Description
Technical Field
The invention relates to the technical field of data query in electric digital data processing, in particular to a three-dimensional pipe network monomer query method and a three-dimensional pipe network monomer query system based on structured data.
Background
The city pipe network has the following characteristics: (1) the scale is large. The pipe network of a single factory or a single building can exceed ten thousand sections, and the pipe network scale of a small and medium-sized city can be large. (2) The range is wide. The length of the artificial gas pipe network in the Chinese city is 10915 kilometers in 2019; the length of the urban natural gas pipe network is 767946 kilometers; the length of the urban liquefied petroleum gas pipe network is 4452 kilometers; the length of the municipal drainage pipe network is 743982 kilometers; the length of the urban central heating pipe network is 392917 kilometers; the urban water supply network has a length of 920082 kilometers. (3) There are many kinds. The city pipe network includes more than 8 kinds of 20 kinds of water supply, water drainage, gas, heat power, electric power, communication, radio and television, industry, etc. (4) The spatial distribution is complex. In order to save the construction cost and the occupied area, different pipe networks can share the same underground passage or overhead passage space, so that the pipe networks form complicated staggered layout in space. (5) The change is fast. With the lapse of time, the pipe network will suffer from the problems of corrosion aging, heavy rain waterlogging, road surface collapse, pipeline leakage and explosion, etc., and therefore, the old pipe network needs to be continuously maintained and updated.
The pipe network data structure has the following characteristics: (1) the cross-sectional shape is regular. The cross-sectional shape of the tubular network is generally circular and very few other shapes. (2) There is a spatial topological relationship. The pipe network is composed of linear and point-shaped space entities, and the linear-linear topological relation and the point-linear topological relation are necessarily stored.
Aiming at the characteristics of the pipe network, the construction of the urban pipe network system is changed from the traditional two-dimensional plane pipe network system to a three-dimensional intelligent pipe network system. The three-dimensional pipe network model is the most important content in the intelligent pipe network system, and the model is visually expressed by using a three-dimensional engine rendering tool, so that visual analysis and query of pipe network data are achieved. In the three-dimensional intelligent pipe network system, the query function of the pipe network single object is one of the most core functions in the whole system. The query algorithm of the existing three-dimensional pipe network system on the pipe network monomer object is established on the premise of the three-dimensional pipe network model monomer modeling. The implementation mode is as follows: according to the requirement of the fineness degree of the query service, a three-dimensional pipe network model is subjected to monomer modeling in three-dimensional modeling software (such as 3dMax, Sketchup, AutoCAD and the like) in advance, then a monomer pipeline model is queried through a mouse model pickup function, then attribute data well associated with the model are read from the selected monomer model, and finally the monomer model is re-rendered in a highlight mode.
Although this method can achieve a single query, it has several disadvantages: (1) the model is fragmented, which is not beneficial to management. The whole pipeline has to be artificially segmented for the individual object query, and the pipe network modeling needs to be performed for the pipe network in the whole range in a single mode, namely, the pipe network is segmented, so that a plurality of fragment models in a large scene are generated, and the management and the maintenance of model data are not facilitated. (2) The process of model modification is cumbersome: the modification of the model requires splitting the original model and then adding and assembling a new model, and simultaneously requires re-associating attribute information for the newly added or split model and finally processing the three-dimensional topological relation of the model. (3) The association of service attributes is difficult. The existing three-dimensional pipe network model file cannot directly associate attributes in the model, and the fragmented model can make attribute hooking work become huge and complex.
Aiming at the defects of the three-dimensional pipe network model query method, the invention provides a three-dimensional pipe network monomer query method and a three-dimensional pipe network monomer query system based on structured data by fully utilizing the structural characteristics (mainly the regularity of pipe network cross section graphs), and practices prove that the algorithm can effectively solve the defects.
Disclosure of Invention
The invention aims to disclose a three-dimensional pipe network monomer query method and a three-dimensional pipe network monomer query system based on structured data, so as to realize the query of a pipeline monomer and improve the query efficiency.
In order to achieve the purpose, the invention discloses a three-dimensional pipe network monomer query method based on structured data, which comprises the following steps:
simplifying the structural relationship between the three-dimensional pipelines into a topological relationship between the center lines of the three-dimensional pipelines;
constructing at least two sections of three-dimensional pipelines in an area in the same three-dimensional pipeline model according to a coverage range, and determining a first attribute and a second attribute of a three-dimensional pipeline center line of each section in the three-dimensional pipeline model, wherein the pipeline radius of the same section of pipeline is equal, the first attribute of each section of three-dimensional pipeline center line comprises a pipeline radius value, three-dimensional coordinates of a starting point and an end point, and a three-dimensional space distribution rule of a connecting line between the starting point and the end point, and the second attribute of each section of three-dimensional pipeline center line comprises query result information correspondingly displayed according to a corresponding query request;
generating the three-dimensional pipeline model according to the first attribute data of each governed three-dimensional pipeline central line;
leading the generated three-dimensional pipeline model and the first attribute data and the second attribute data of the covered three-dimensional pipeline central line into a three-dimensional pipe network GIS system;
in the three-dimensional pipe network GIS system, a user clicks a pipeline section to be inquired through a mouse;
acquiring position information of a point P where a mouse is located, and preliminarily screening out three-dimensional pipeline center lines within a preset range from the point P according to first attributes of the three-dimensional pipeline center lines of all sections;
and finally, determining the pipeline corresponding to the minimum value of the shortest distance in the two-dimensionally screened three-dimensional pipeline central lines as a target pipeline monomer for user query, reading second attribute data of the pipeline central line corresponding to the target pipeline monomer and displaying the second attribute data in the three-dimensional pipe network GIS system.
Preferably, the method of the present invention further comprises: and simplifying the structural relationship between the three-dimensional pipeline and the valve into the relationship between the point and the central line of the three-dimensional pipeline.
Preferably, the first attribute of the centerline of each three-dimensional pipeline of the present invention further comprises: maximum and minimum values on the X-axis, maximum and minimum values on the Y-axis, and maximum and minimum values on the Z-axis; in the process of screening the three-dimensional pipeline central line within the preset range of the distance P point, the method further comprises the following steps:
determining the maximum pipeline radius value M in all three-dimensional pipeline center lines in the three-dimensional pipe network GIS system;
obtaining the X-axis coordinate X of the P point of the mouse1Y axis coordinate Y1And Z-axis coordinate Z1Determining the range setting of the X axis within the preset range from the point P as [ X ]1-M，X1+ M ], Y-axis range is set to [ Y ]1-M，Y1+ M ], range of Z axis is set as [ Z ]1-M，Z1+M】；
The maximum and minimum values of the X axis are compared with [ X ]1-M，X1+ M ] there is an intersection, the maximum and minimum of the Y axis and [ Y ]1-M，Y1+ M ] there is an intersection and the maximum and minimum values of the Z axis are equal to [ Z ]1-M，Z1+ M ] Presence CrossAnd determining the central line of the three-dimensional pipeline of the set as the central line of the three-dimensional pipeline preliminarily screened in the preset range of the distance P.
Preferably, before calculating the shortest distance between each of the screened three-dimensional pipeline center lines and the point P, the present invention first determines whether a breakpoint exists in a range where the mouse point position extends based on the maximum pipeline radius value M, if not, calculates one by one whether the preliminarily screened three-dimensional pipeline center line is the three-dimensional pipeline center line whose shortest distance is less than or equal to the corresponding pipeline radius in the order of the pipeline radius from large to small, and directly determines the three-dimensional pipeline center line satisfying the conditions corresponding to the secondary screening as the pipeline center line corresponding to the target pipeline monomer after inquiring that any one of the three-dimensional pipeline center lines satisfies the conditions corresponding to the secondary screening.
Preferably, the method of the present invention further comprises:
acquiring a pipeline adding request;
setting a first attribute and a second attribute of the three-dimensional pipeline center line of the added pipeline, superposing the incremental model of the added pipeline on the original three-dimensional pipeline model, and adding corresponding breakpoint information at the updating position corresponding to the related three-dimensional pipeline center line.
Preferably, the method of the present invention further comprises:
acquiring a valve adding request;
and superposing the incremental model of the added valve on the original three-dimensional pipeline model, and adding corresponding breakpoint information at the corresponding updated position of the central line of the associated three-dimensional pipeline.
Preferably, when the second attribute data of the target pipeline monomer is read and displayed in the three-dimensional pipe network GIS system, the method further includes: the queried target pipe singles are displayed as a three-dimensional pipe semi-transparent schematic model that distinguishes from other adjoining pipes.
In order to achieve the above object, the present invention further discloses a three-dimensional pipe network monomer query system based on structured data, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the above method when executing the computer program.
The invention has the following beneficial effects:
compared with the topological relation of the three-dimensional model, the topological relation of the structured data converted into the central line of the processing pipe network and the attribute editing become simpler, more efficient and more flexible. The complexity of the topological relation is reduced, the workload of data processing in the early stage is reduced, and the data quality inspection in the later stage is more convenient.
The method can construct multiple sections or even all three-dimensional pipelines in the area in the same three-dimensional pipeline model according to the coverage range, and introduce the three-dimensional pipeline model and the first attribute data and the second attribute data of the central lines of the covered three-dimensional pipelines into the three-dimensional pipe network GIS system, thereby solving the series problems caused by the fragmentation of the model generated by the sectional modeling according to the pipelines in the prior art and simultaneously providing a data basis for realizing the single query of the pipelines in the model.
Moreover, the invention converts the query mode of the existing fragmentation model into the query of the pipeline monomer corresponding to each three-dimensional pipe network central line in the model, the query algorithm is practical and efficient, and the query precision and efficiency are ensured. Particularly, when the vector data query algorithm is used for querying urban mass data, the query performance based on the vector data query algorithm is better.
The present invention will be described in further detail below with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate embodiments of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
fig. 1 is a schematic flow chart of a structured data-based three-dimensional pipe network monomer query method disclosed in an embodiment of the present invention.
Detailed Description
The embodiments of the invention will be described in detail below with reference to the drawings, but the invention can be implemented in many different ways as defined and covered by the claims.
Example 1
The embodiment of the invention discloses a structured data-based three-dimensional pipe network single body (a single body, namely a single-section pipeline without valves or devices connected with other pipelines between a starting point and an end point, wherein the radius of the inner diameter of the pipeline is generally equal, but the overall trend of the pipeline comprises but is not limited to a linear type) query method, which comprises the following steps:
and step S1, simplifying the structural relationship between the three-dimensional pipelines into the topological relationship between the center lines of the three-dimensional pipelines. Preferably, the step further comprises: and simplifying the structural relationship between the three-dimensional pipeline and the valve into the relationship between the point and the central line of the three-dimensional pipeline.
In the step, compared with the topological relation of the three-dimensional model, the topological relation and the attribute editing of the structured data converted into the processing pipe network central line become simpler, more efficient and more flexible. The complexity of the topological relation is reduced, the workload of data processing in the early stage is reduced, and the data quality inspection in the later stage is more convenient.
Step S2, at least two sections of three-dimensional pipelines in the area are constructed in the same three-dimensional pipeline model according to the coverage, determining a first attribute and a second attribute of a three-dimensional pipe centerline of each segment in the three-dimensional pipe model, wherein the pipeline radius of the same pipeline is equal, and the first attribute of the central line of each three-dimensional pipeline comprises a pipeline radius value, three-dimensional coordinates of a starting point and an end point, and a three-dimensional space distribution rule of a connecting line between the starting point and the end point (a corresponding three-dimensional curve equation can be fitted according to a hand-drawn three-dimensional pipeline central line to express the connecting line between the starting point and the end point, wherein the connecting line between the starting point and the end point can be a straight line or a curve, and for some special-shaped pipelines, a piecewise function can be used for expressing, for example, one section of the piecewise function is an arc curve and the other section is a straight line), and the second attribute of each section of the three-dimensional pipeline central line comprises query result information correspondingly displayed according to a corresponding query request.
For example, the second attribute may include information of the construction date, the road, the material, the code, the burial depth, the grade, and the like of the corresponding pipeline.
Preferably, in the specific implementation process of this step, an array sequence composed of three-dimensional coordinates distributed at equal intervals on the centerline of the three-dimensional pipeline may be used to represent the three-dimensional spatial distribution rule of the connecting line, and two adjacent discrete three-dimensional coordinates are regarded as being connected by a line segment; thereby providing convenience for the subsequent steps to calculate the shortest distance between the three-dimensional pipeline central line and the mouse position.
And step S3, generating the three-dimensional pipeline model according to the first attribute data of the center line of each three-dimensional pipeline under jurisdiction.
And step S4, importing the generated three-dimensional pipeline model and the first attribute data and the second attribute data of the covered three-dimensional pipeline central line into a three-dimensional pipe network GIS system.
In the invention, the three-dimensional pipeline model can be regarded as a three-dimensional effect displayed in the three-dimensional pipe network GIS system (in most application scenes, the internal three-dimensional pipeline center line is usually not displayed, so the three-dimensional pipeline center line of the embodiment is regarded as a part independent of the three-dimensional pipeline model), and each pipeline in the coverage range of the same area can be integrated into a single file of the integral model.
And step S5, in the three-dimensional pipe network GIS system, clicking the pipeline section needing to be inquired by a user through a mouse.
And step S6, obtaining the position information of the point P where the mouse is located, and preliminarily screening the three-dimensional pipeline center lines within a preset range from the point P according to the first attribute of each section of the three-dimensional pipeline center line.
Preferably, the first attribute of the centerline of each three-dimensional pipeline of the present invention further comprises: maximum and minimum values on the X-axis, maximum and minimum values on the Y-axis, and maximum and minimum values on the Z-axis; in the process of screening the three-dimensional pipeline central line within the preset range of the distance P point, the method further comprises the following steps:
and step S61, determining the maximum pipeline radius value M in all the three-dimensional pipeline center lines in the three-dimensional pipeline network GIS system.
Step S62, obtaining the X-axis coordinate X of the P point of the mouse1Y axis coordinate Y1And Z-axis coordinate Z1Determining the range setting of the X axis within the preset range from the point P as [ X ]1-M，X1+ M ], Y-axis range is set to [ Y ]1-M，Y1+ M ], range of Z axis is set as [ Z ]1-M，Z1+M】。
Step S63, the maximum value and the minimum value of the X axis are compared with X1-M，X1+ M ] there is an intersection, the maximum and minimum of the Y axis and [ Y ]1-M，Y1+ M ] there is an intersection and the maximum and minimum values of the Z axis are equal to [ Z ]1-M，Z1And M, determining the center line of the three-dimensional pipeline with the intersection as the center line of the three-dimensional pipeline screened within the preset range from the point P.
Based on the steps S61 to S63, the potential three-dimensional pipeline center line within the preset range of the distance P can be quickly checked and calibrated. In the process, a plurality of impossible three-dimensional pipeline center lines can be filtered, and huge computing resource consumption caused by traversing each three-dimensional pipeline center line and computing the distance between each three-dimensional pipeline center line and a mouse point is avoided.
Step S7, respectively calculating the shortest distance between each preliminarily screened three-dimensional pipeline central line and the point P, screening the three-dimensional pipeline central lines of which the shortest distance is smaller than or equal to the radius of the corresponding pipeline to realize secondary screening, finally determining the pipeline corresponding to the shortest distance minimum value in the three-dimensional pipeline central lines after secondary screening as a target pipeline monomer inquired by a user, and then reading second attribute data of the pipeline central line corresponding to the target pipeline monomer and displaying the second attribute data in the three-dimensional pipeline network GIS system.
Preferably, in this step, before calculating the shortest distance between the centerline of each screened three-dimensional pipeline and the point P, it is determined whether a break point (typically, a meeting point of the pipeline and the pipeline or a position point of a valve in the pipeline) exists in a range extending based on the maximum pipeline radius value M in step S61 at the position of the mouse point, if not, calculating whether the preliminarily screened three-dimensional pipeline center line is the three-dimensional pipeline center line with the shortest distance smaller than or equal to the corresponding pipeline radius one by one according to the sequence of the pipeline radii from large to small (generally, the larger the pipeline radius is, the larger the probability that the pipeline is the target query pipeline is), when any three-dimensional pipeline center line is inquired to meet the secondary screening condition, the subsequent calculation process can be terminated, and the three-dimensional pipeline center line meeting the condition corresponding to the secondary screening is directly determined as the pipeline center line corresponding to the target pipeline monomer; therefore, part of computing resources can be saved. On the contrary, if it is determined that a breakpoint exists in the range where the position of the mouse point extends based on the maximum pipeline radius value M in step S61, since the mouse position is likely to exist at the intersection between the pipelines, the shortest distance between the center line of each preliminarily screened three-dimensional pipeline and the point P needs to be calculated in an ergodic manner, and then subsequent secondary screening and tertiary screening are performed (that is, the pipeline corresponding to the shortest distance minimum value in the three-dimensional pipeline center lines after the secondary screening is determined as the target pipeline monomer for the user query).
The essence of the embodiment is that the query mode of the existing fragmentation model is converted into the query of the pipeline monomer corresponding to each three-dimensional pipe network central line in the model, the query algorithm is practical and efficient, and the query precision and efficiency are ensured. Particularly, when the vector data query algorithm is used for querying urban mass data, the query performance based on the vector data query algorithm is better.
Further, the method of the invention also comprises the following steps:
and step S8, acquiring the pipeline adding request.
And step S9, setting a first attribute and a second attribute of the three-dimensional pipeline center line of the added pipeline, superposing the incremental model of the added pipeline on the original three-dimensional pipeline model, and adding corresponding breakpoint information at the updating position corresponding to the related three-dimensional pipeline center line.
Still further, the method of the present invention further comprises:
and step S10, acquiring a valve adding request.
And step S11, superposing the incremental model of the added valve on the original three-dimensional pipeline model, and adding corresponding breakpoint information at the corresponding update position of the central line of the associated three-dimensional pipeline.
Preferably, when reading the second attribute data of the target pipeline monomer and displaying the second attribute data in the three-dimensional pipe network GIS system, the embodiment further includes: the inquired target pipeline monomer is displayed as a three-dimensional pipeline semi-transparent schematic model which is distinguished from other adjacent pipelines, so that the observation of a user is facilitated, and the user experience is improved.
As a specific implementation manner, referring to fig. 1, the above scheme of this embodiment may be further simplified to the following specific steps:
1. and performing a series of editing processing on the existing two-dimensional or three-dimensional data of the pipeline to form a three-dimensional pipeline central line.
2. The structural relationship of the processed three-dimensional pipeline is simplified into the topological relationship of a central line, namely the line-line relationship between the pipeline and the point-line relationship between the pipeline and the valve.
3. And editing the attribute of the pipeline central line to generate a structured three-dimensional pipeline central line with the attribute.
4. A three-dimensional pipeline model is made from pipeline centerline data and the derived model may be an integral model of a single file.
5. And importing the three-dimensional pipeline model and pipeline center line data into a three-dimensional pipe network GIS system.
6. And clicking the pipeline segment needing to be inquired by the mouse.
7. And acquiring the coordinates of the three-dimensional point at the intersection of the mouse point and the model and marking as a model mouse point P.
8. Finding out the pipeline central line L within the preset range of the distance P point and independently storing the pipeline central line L in a temporary central line array A = { L = (L) }1,L2,L3,…}。
9. Respectively calculating the shortest distance (non-vertical distance) from the point P to the central line of each pipeline in the array A, screening out the central lines of the three-dimensional pipelines with the shortest distance less than or equal to the radius of the corresponding pipeline to realize secondary screening, and finally screening out the three-dimensional pipelines after the secondary screeningThe pipeline corresponding to the minimum value of the shortest distance in the three-dimensional pipeline central lines is determined as a target pipeline single body inquired by a user, and the pipeline central line corresponding to the pipeline is recorded as Ln。
10. Structure LnAnd the lines correspond to the semi-transparent schematic models of the three-dimensional pipelines.
11. Show L simultaneouslynAnd attribute information corresponding to the line. Therefore, three-dimensional schematic and corresponding attribute display of the three-dimensional pipeline structured monomer query under the first modeling are realized.
12. If the pipeline or the valve is added, the corresponding incremental model is only needed to be superimposed on the basis of the original three-dimensional pipeline model.
13. And adding a breakpoint and a line at the updated position corresponding to the pipeline central line and adding the attribute.
14. And repeating the steps of 5-11 to finish the three-dimensional pipeline structured monomer query work.
15. The update iteration can be completed by repeating 12-13-14.
In summary, compared with the method for processing the topological relation of the three-dimensional model, the method for processing the topological relation of the structured data of the central line of the pipe network and editing the attributes of the central line of the pipe network are simpler, more efficient and more flexible. The complexity of the topological relation is reduced, the workload of data processing in the early stage is reduced, and the data quality inspection in the later stage is more convenient.
Meanwhile, according to the embodiment, multiple sections or even all three-dimensional pipelines in the area can be built in the same three-dimensional pipeline model according to the coverage range, the three-dimensional pipeline model and the first attribute data and the second attribute data of the center lines of the covered three-dimensional pipelines are imported into the three-dimensional pipe network GIS system, the series problems caused by model fragmentation generated by modeling according to pipeline sections in the prior art are solved, and meanwhile, a data basis is provided for realizing the query of pipeline monomers in the model.
In addition, the embodiment converts the query mode of the existing fragmentation model into the query of the single pipeline corresponding to the central line of each three-dimensional pipe network in the model, the query algorithm is practical and efficient, and the query precision and efficiency are ensured. Particularly, when the vector data query algorithm is used for querying urban mass data, the query performance based on the vector data query algorithm is better.
Example 2
The embodiment discloses a three-dimensional pipe network single query system based on structured data, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the computer program to realize the steps corresponding to the method embodiments.
In summary, the three-dimensional pipe network monomer query method and system based on structured data disclosed in the embodiments of the present invention at least have the following beneficial effects:
(1) the number of the monomer models is reduced, and the modeling and the management are convenient
When the three-dimensional solid model of the pipe network is modeled, a single model does not need to be established for the pipe network in a segmented mode, the model in a specified area range can be directly derived to be a single integral model according to the requirement of actual business on model refinement, and the segmented fragmented modeling of the pipe network model in the area range is not needed. According to the algorithm, the monomer object query is carried out on the pipe network model by using the vector structured data, the monomer refinement degree of the model depends on the subdivision degree of the vector structured data, and the monomer refinement of the vector structured data can be refined to a very fine degree (for example, each pipeline is segmented at intervals of 1 meter), so that the modeling complexity of the three-dimensional pipe network is simplified to a great extent, the modeling efficiency is improved, and the model management of the whole three-dimensional system is facilitated.
(2) The flow of model modification is simple
The three-dimensional model is modified without splitting the original model, directly adding the model to be newly added into the original model and without re-mounting the associated attribute of the model, and only the vector structured data (such as a central line of a pipe network) corresponding to the newly added model or the model to be modified is subjected to topological relation processing and service associated attribute processing. Compared with the topological relation for processing the three-dimensional model body, the topological relation and the attribute editing of the structured data converted into the central line of the processing pipe network become simpler, more efficient and more flexible. The complexity of the topological relation is reduced, the workload of data processing in the early stage is reduced, and the data quality inspection in the later stage is more convenient.
(3) More convenient attribute association
Compared with the method for associating the business attributes with a large number of monomer models, the method for associating the attributes by using the existing vector structured data does not need to do too much processing work, and is more convenient and easier to process by using the existing mature spatial data processing algorithm or GIS (geographic information system) mapping software.
(4) The query performance is better
The query on the model object is converted into the query on the central line of the three-dimensional pipe network, so that the complexity of a query algorithm is simplified, and the query efficiency is improved. Particularly, when the method is used for inquiring urban mass data, the existing mature vector data inquiry algorithm is reused, and the method has better performance.
(5) Two-dimensional and three-dimensional integration is more convenient
When the two-dimensional and three-dimensional integrated processing operation is carried out, the single object is inquired in the three-dimensional scene based on the structured data, the inquiry result is also suitable for being displayed in the two-dimensional scene, and the two-dimensional and three-dimensional integrated interaction is more convenient.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (8)
1. A three-dimensional pipe network monomer query method based on structured data is characterized by comprising the following steps:
simplifying the structural relationship between the three-dimensional pipelines into a topological relationship between the center lines of the three-dimensional pipelines;
constructing at least two sections of three-dimensional pipelines in an area in the same three-dimensional pipeline model according to a coverage range, and determining a first attribute and a second attribute of a three-dimensional pipeline center line of each section in the three-dimensional pipeline model, wherein the pipeline radius of the same section of pipeline is equal, the first attribute of each section of three-dimensional pipeline center line comprises a pipeline radius value, three-dimensional coordinates of a starting point and an end point, and a three-dimensional space distribution rule of a connecting line between the starting point and the end point, and the second attribute of each section of three-dimensional pipeline center line comprises query result information correspondingly displayed according to a corresponding query request;
generating the three-dimensional pipeline model according to the first attribute data of each governed three-dimensional pipeline central line;
leading the generated three-dimensional pipeline model and the first attribute data and the second attribute data of the covered three-dimensional pipeline central line into a three-dimensional pipe network GIS system;
in the three-dimensional pipe network GIS system, a user clicks a pipeline section to be inquired through a mouse;
acquiring position information of a point P where a mouse is located, and preliminarily screening out three-dimensional pipeline center lines within a preset range from the point P according to first attributes of the three-dimensional pipeline center lines of all sections;
and finally, determining the pipeline corresponding to the minimum value of the shortest distance in the two-dimensionally screened three-dimensional pipeline central lines as a target pipeline monomer for user query, reading second attribute data of the pipeline central line corresponding to the target pipeline monomer and displaying the second attribute data in the three-dimensional pipe network GIS system.
2. The method of claim 1, further comprising: and simplifying the structural relationship between the three-dimensional pipeline and the valve into the relationship between the point and the central line of the three-dimensional pipeline.
3. The method of claim 1, wherein the first attribute of the centerline of each segment of the three-dimensional pipe further comprises: maximum and minimum values on the X-axis, maximum and minimum values on the Y-axis, and maximum and minimum values on the Z-axis; in the process of screening the three-dimensional pipeline central line within the preset range of the distance P point, the method further comprises the following steps:
determining the maximum pipeline radius value M in all three-dimensional pipeline center lines in the three-dimensional pipe network GIS system;
obtaining the X-axis coordinate X of the P point of the mouse1Y axis coordinate Y1And Z-axis coordinate Z1Determining the range setting of the X axis within the preset range from the point P as [ X ]1-M，X1+ M ], Y-axis range is set to [ Y ]1-M，Y1+ M ], range of Z axis is set as [ Z ]1-M，Z1+M】；
The maximum and minimum values of the X axis are compared with [ X ]1-M，X1+ M ] there is an intersection, the maximum and minimum of the Y axis and [ Y ]1-M，Y1+ M ] there is an intersection and the maximum and minimum values of the Z axis are equal to [ Z ]1-M，Z1And M, determining the three-dimensional pipeline center line with the intersection as the preliminarily screened three-dimensional pipeline center line in the preset range from the point P.
4. The method of claim 3, further comprising, prior to calculating the shortest distance between each screened three-dimensional pipeline centerline and point P:
judging whether a breakpoint exists in a range of the position of the mouse point extending based on the maximum pipeline radius value M, if not, calculating one by one according to the sequence of pipeline radii from large to small whether the preliminarily screened three-dimensional pipeline center line is the three-dimensional pipeline center line of which the shortest distance is less than or equal to the corresponding pipeline radius, and directly determining the three-dimensional pipeline center line meeting the corresponding condition of the secondary screening as the pipeline center line corresponding to the target pipeline monomer after inquiring that any three-dimensional pipeline center line meets the corresponding condition of the secondary screening.
5. The method of any of claims 1 to 4, further comprising:
acquiring a pipeline adding request;
setting a first attribute and a second attribute of the three-dimensional pipeline center line of the added pipeline, superposing the incremental model of the added pipeline on the original three-dimensional pipeline model, and adding corresponding breakpoint information at the updating position corresponding to the related three-dimensional pipeline center line.
6. The method of claim 5, further comprising:
acquiring a valve adding request;
and superposing the incremental model of the added valve on the original three-dimensional pipeline model, and adding corresponding breakpoint information at the corresponding updated position of the central line of the associated three-dimensional pipeline.
7. The method of claim 6, wherein when the second attribute data of the target pipe unit is read and displayed in the three-dimensional pipe network GIS system, the method further comprises:
the queried target pipe singles are displayed as a three-dimensional pipe semi-transparent schematic model that distinguishes from other adjoining pipes.
8. A structured data based three-dimensional pipe network single query system, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method according to any one of the preceding claims 1 to 7 when executing the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111080338.9A CN113535827B (en) | 2021-09-15 | 2021-09-15 | Three-dimensional pipe network monomer query method and system based on structured data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111080338.9A CN113535827B (en) | 2021-09-15 | 2021-09-15 | Three-dimensional pipe network monomer query method and system based on structured data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113535827A CN113535827A (en) | 2021-10-22 |
| CN113535827B true CN113535827B (en) | 2022-01-18 |
Family
ID=78123084
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111080338.9A Active CN113535827B (en) | 2021-09-15 | 2021-09-15 | Three-dimensional pipe network monomer query method and system based on structured data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113535827B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101630419A (en) * | 2009-08-13 | 2010-01-20 | 苏州市数字城市工程研究中心有限公司 | Structuring method for three-dimensional visualizing system of urban synthesis pipeline network |
| CN105550758A (en) * | 2016-01-18 | 2016-05-04 | 无锡扬晟科技有限公司 | GIS-based underground pipeline operation and maintenance system |
| CN109359351A (en) * | 2018-09-27 | 2019-02-19 | 济南市市政工程设计研究院（集团）有限责任公司 | A kind of pipeline three-dimensional modeling method and pipe design method |
| CN112487589A (en) * | 2020-11-26 | 2021-03-12 | 博迈科海洋工程股份有限公司 | Data conversion method based on pipeline three-dimensional model |
| KR102229787B1 (en) * | 2020-07-29 | 2021-03-19 | (주)내가시스템 | Sewage facility analysis system |
-
2021
- 2021-09-15 CN CN202111080338.9A patent/CN113535827B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101630419A (en) * | 2009-08-13 | 2010-01-20 | 苏州市数字城市工程研究中心有限公司 | Structuring method for three-dimensional visualizing system of urban synthesis pipeline network |
| CN105550758A (en) * | 2016-01-18 | 2016-05-04 | 无锡扬晟科技有限公司 | GIS-based underground pipeline operation and maintenance system |
| CN109359351A (en) * | 2018-09-27 | 2019-02-19 | 济南市市政工程设计研究院（集团）有限责任公司 | A kind of pipeline three-dimensional modeling method and pipe design method |
| KR102229787B1 (en) * | 2020-07-29 | 2021-03-19 | (주)내가시스템 | Sewage facility analysis system |
| CN112487589A (en) * | 2020-11-26 | 2021-03-12 | 博迈科海洋工程股份有限公司 | Data conversion method based on pipeline three-dimensional model |
Non-Patent Citations (2)
| Title |
|---|
| Modular Pipe Climber;Rama Vadapalli等;《AIR 2019：Proceedings of the Advances in Robotics 2019》;20190731;第1-6页 * |
| 三维管道设计系统的研究与开发;刘家仓;《中国优秀硕士学位论文全文数据库 信息科技辑》;20060415;I138-180第1-61页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113535827A (en) | 2021-10-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106898047B (en) | Self-adaptive network visualization method for dynamic fusion of tilt model and multivariate model | |
| CN109359351A (en) | A kind of pipeline three-dimensional modeling method and pipe design method | |
| CN108776993B (en) | Modeling method of three-dimensional point cloud with hole and modeling method of underground cable work well | |
| CN106372293B (en) | Building BIM (building information modeling) model establishing method based on three-dimensional datum line | |
| CN101924647B (en) | Local area topology rebuilding method for updating navigation road network increment | |
| CN102147830B (en) | Method and system for optimally designing water supply pipe network | |
| CN110111410A (en) | A kind of two three-dimensional pipe network data organizations and display methods based on spatial database | |
| CN111540051B (en) | CIM-based full-element mass data lightweight and topology analysis application platform | |
| CN101976248A (en) | Method for rapidly identifying environmental risk of power transmission and transformation project | |
| CN103383556B (en) | Comprehensive pipeline data indoor and field integration real-time update method of quality control | |
| CN106204719B (en) | Magnanimity model real-time scheduling method in three-dimensional scenic based on two-dimensional neighbourhood retrieval | |
| CN115641407A (en) | Three-dimensional pipe network incremental updating modeling method and device, storage medium and electronic equipment | |
| CN108959598A (en) | The method that CAD data based on GIS imported into SWMM | |
| CN107944203A (en) | A kind of visual architectural design method of wind-velocity streamline | |
| Yang et al. | A map‐algebra‐based method for automatic change detection and spatial data updating across multiple scales | |
| CN117113471A (en) | City simulation model algorithm based on CIM technology | |
| CN113535827B (en) | Three-dimensional pipe network monomer query method and system based on structured data | |
| CN105335478A (en) | Method and device constructing city land space stereo investigation data semantic association | |
| CN113486429A (en) | Automatic construction method of space intersection structure based on interpolation algorithm | |
| CN111914039B (en) | Road network updating method and device | |
| CN116432355A (en) | Automatic modeling method for three-dimensional model of urban comprehensive underground pipeline | |
| CN109086528B (en) | Method for automatically naming netty roads in civil3d according to ordering rule | |
| CN115344915B (en) | Automatic construction method and application of shield construction risk analysis model | |
| CN113609691B (en) | Intersection modeling processing method oriented to intelligent traffic simulation | |
| CN106599044A (en) | Recognition and processing method for road network target information |
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 | ||
| CP03 | Change of name, title or address | ||
| CP03 | Change of name, title or address |
Address after: No.755, Xueshi street, Yuelu District, Changsha City, Hunan Province, 410205 Patentee after: Zhongda Intelligent Technology Co.,Ltd. Address before: 410000 Bachelor's Street, Yuelu District, Changsha City, Hunan Province, 755 Bachelor's Road Patentee before: CUHK testing (Hunan) Co.,Ltd. |