CN113704945A

CN113704945A - Pipe network road correlation analysis method and device, storage medium and electronic equipment

Info

Publication number: CN113704945A
Application number: CN202111241935.5A
Authority: CN
Inventors: 吴红燕; 张学全; 罗云
Original assignee: Wuhan Huancheng Jingwei Technology Co ltd
Current assignee: Wuhan Huancheng Jingwei Technology Co ltd
Priority date: 2021-10-25
Filing date: 2021-10-25
Publication date: 2021-11-26
Anticipated expiration: 2041-10-25
Also published as: CN113704945B

Abstract

The invention discloses a method and a device for analyzing association of a pipe network road, a storage medium and electronic equipment, wherein the method comprises the following steps: acquiring vector underground pipeline data and pipe point data of a target area, and performing instantiation modeling according to the vector underground pipeline data and the pipe point data based on a pipe network template to construct a first underground pipe network three-dimensional model; acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface for each segment; performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model; and generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross section position relation between the underground pipe network of the target area and the road. According to the invention, the technical problems of low rendering efficiency, low query speed and poor analysis effect of the underground pipe network three-dimensional model constructed by the related technology are solved.

Description

Pipe network road correlation analysis method and device, storage medium and electronic equipment

Technical Field

The invention relates to the field of computers, in particular to a method and a device for analyzing association of a pipe network road, a storage medium and electronic equipment.

Background

In the related art, the construction of cities is not only extended to the high altitude but also developed to the underground. The underground pipe network is one of the most important urban underground facilities, the urban construction is accelerated in recent years, and the updating frequency of the underground pipe network construction is greatly increased, so that the underground pipe network has the characteristics of various types, wide range, complex layout, high changing speed and the like. Meanwhile, underground pipe network facilities generally have the characteristic of linear distribution along long and narrow roads, and the distribution range of the underground pipe network facilities is a certain space geographic range under the road surface. The traditional homeland resource data usually stores road and underground pipe network data respectively and independently, so that the classified management of different data can be realized, and the quick query and analysis of the pipe network of the road position are difficult to realize under the condition of classified and independent storage.

In the related art, the current analysis method of the three-dimensional underground pipe network has the following disadvantages: (1) the underground pipe network model has large data volume and low rendering efficiency. Current urban large-scale underground pipe network models are typically based on manual modeling or automatic modeling, each pipe model comprising several geometric meshes and texture maps. The underground of one road usually comprises dozens of hundreds of pipelines, which causes huge model data volume and low rendering efficiency. (2) The underground pipe network analysis efficiency is low, a large number of pipe network models need to be traversed in order to query the underground pipe network under the current road, the query efficiency is low, and the query speed is low. (3) The relevance between the underground pipe network and the road is poor, so that a user can hardly obtain the geographic space distribution relation between the underground pipe network and the road, and the effect is poor.

In view of the above problems in the related art, no effective solution has been found at present.

Disclosure of Invention

The embodiment of the invention provides a method and a device for analyzing association of a pipe network road, a storage medium and electronic equipment.

According to an aspect of the embodiments of the present application, there is provided a method for analyzing association of a pipe network road, including: acquiring vector underground pipeline data and pipe point data of a target area, and performing instantiation modeling according to the vector underground pipeline data and the pipe point data based on a pipe network template to construct a first underground pipe network three-dimensional model; acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface for each segment; performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model; and generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross section position relation between the underground pipe network of the target area and the road.

Further, performing instantiation modeling according to the vector underground pipeline data and the pipe network data based on a pipe network template comprises: acquiring a first instantiation parameter of a pipeline, a second instantiation parameter of a joint and a third instantiation parameter of an accessory facility from the vector underground pipeline data or the pipe point data; adopting the first instantiation parameters and the pipeline template to construct a pipeline three-dimensional model, adopting the second instantiation parameters and the pipeline template to construct a joint three-dimensional model, and adopting the third instantiation parameters and the accessory parameter template to construct an accessory facility three-dimensional model; and connecting the three-dimensional pipeline models by adopting the joint three-dimensional model, and deploying the three-dimensional accessory facility models on the three-dimensional pipeline models to obtain a first underground pipe network three-dimensional model.

Further, the constructing a three-dimensional model of the pipeline by using the first instantiation parameters and the pipeline template comprises: acquiring a standard radius R and a standard length d of a standard pipeline model, and acquiring a radius R, a starting pipeline spherical coordinate and a terminal pipeline spherical coordinate of a target pipeline; converting the starting pipeline spherical coordinate and the end pipeline spherical coordinate into a first Cartesian coordinate and a second Cartesian coordinate respectively; calculating a scaling matrix according to the first Cartesian coordinate and the second Cartesian coordinate, R, d and R, and calculating a rotation matrix according to the first Cartesian coordinate and the second Cartesian coordinate; converting the standard pipe model to a pipe three-dimensional model of the target pipe based on the pipe center point coordinates, the scaling matrix, and the rotation matrix.

Further, constructing a joint three-dimensional model by using the second instantiation parameters and the pipeline template comprises: decomposing a target multi-way joint into a plurality of straight pipes, wherein the number of the straight pipes is the same as that of channels of the target multi-way joint; for each straight pipe of the target multi-way joint, taking a common intersection point of a plurality of channels as a starting point, sampling along the pipeline direction of the straight pipe by a preset length to obtain a sampling point, and adopting a communication section from the intersection point to the sampling point to form a pipe section of the straight pipe; and constructing pipe section models of a plurality of pipe sections of the target multi-way joint by adopting a standard pipe model, and combining to obtain a joint three-dimensional model of the target multi-way joint based on the plurality of pipe section models.

Further, the data organization of the underground pipe network three-dimensional model based on the distribution of the road surface comprises: determining a level k of a terrain pyramid to be indexed; acquiring a geographic coordinate area range of the target area, calculating a mapping relation between the underground pipe network three-dimensional model and the k layers of rows and columns based on the geographic coordinate area range, and constructing a primary space index of the underground pipe network three-dimensional model; acquiring corresponding road line vector data from the road surface according to the tile range of the primary spatial index; and constructing a secondary block index of the underground pipe network three-dimensional model according to the road route vector data.

Further, the step of constructing a secondary block index of the three-dimensional model of the underground pipe network according to the road route vector data comprises the following steps: acquiring a road intersection position from the road route vector data, and setting a first rectangular frame with the length and the width of w along a road based on the road intersection position; retrieving pipe network objects falling in the first rectangular frame in the three-dimensional model of the underground pipe network; after the retrieval of the pipe network object is completed, recalculating an outsourcing rectangle of the object in the first rectangular frame, and updating the length and width of the first rectangular frame, wherein each first rectangular frame corresponds to one secondary tile block; acquiring the road length between two intersections from the road route vector data, segmenting the road length based on the step length s, and constructing a second rectangular frame with the length s and the width w in each segment; retrieving pipe network objects falling in the second rectangular frame in the underground pipe network three-dimensional model; after the retrieval of the pipe network object is completed, recalculating the outsourcing rectangle of the object in the second rectangular frame, and updating the length and width of the second rectangular frame, wherein each second rectangular frame corresponds to one secondary tile block; wherein, the pipe network object comprises: the pipeline, the joint and the accessory facilities, s is a positive number, and w is a positive number.

Further, generating an association analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross-section position relationship between the underground pipe network of the target area and the road, wherein the association analysis chart comprises the following steps: taking the road center point of the road surface as an original point, and constructing a two-dimensional plane coordinate system of the road section in a direction perpendicular to the road line; for each pipeline in the second underground pipe network three-dimensional model, taking a section central point of the pipeline as a section characteristic point, and converting the longitude and latitude coordinates of the earth of the section characteristic point of each pipeline into a first coordinate based on an earth three-dimensional Cartesian coordinate system; converting the first coordinates into second coordinates based on the two-dimensional plane coordinate system; drawing a pipeline section according to the second coordinate and section data of the corresponding pipeline, calculating the clear distance and the ground clearance elevation of the pipeline, and generating an association analysis chart of the second underground pipe network three-dimensional model and the road surface, wherein the pipeline section data comprises at least one of the following data: radius, length and width.

According to another aspect of the embodiments of the present application, there is also provided an association analysis apparatus for a pipe network road, including: the system comprises a first construction module, a second construction module and a third construction module, wherein the first construction module is used for acquiring vector underground pipeline data and pipeline data of a target area, carrying out instantiation modeling according to the vector underground pipeline data and the pipeline data based on a pipeline network template, and constructing a first underground pipeline network three-dimensional model; the second construction module is used for acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface in each segment; the organization module is used for carrying out data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model; and the generation module is used for generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross section position relation between the underground pipe network of the target area and the road.

Further, the first building block comprises: the acquisition unit is used for acquiring a first instantiation parameter of a pipeline, a second instantiation parameter of a joint and a third instantiation parameter of an accessory facility from the vector underground pipeline data or the pipe point data; the construction unit is used for constructing a three-dimensional pipeline model by adopting the first instantiation parameters and the pipeline template, constructing a three-dimensional joint model by adopting the second instantiation parameters and the pipeline template, and constructing a three-dimensional affiliated facility model by adopting the third instantiation parameters; and the processing unit is used for connecting the pipeline three-dimensional model by adopting the joint three-dimensional model and deploying the attached facility three-dimensional model on the pipeline three-dimensional model to obtain a first underground pipe network three-dimensional model.

Further, the construction unit includes: the acquisition subunit is used for acquiring a standard radius R and a standard length d of the standard pipeline model, and acquiring a radius R, a starting pipeline spherical coordinate and a terminal pipeline spherical coordinate of the target pipeline; the conversion subunit is used for converting the starting pipeline spherical coordinate and the end pipeline spherical coordinate into a first Cartesian coordinate and a second Cartesian coordinate respectively; the calculating subunit is used for calculating a scaling matrix according to the first Cartesian coordinate, the second Cartesian coordinate, the R, the d and the R, and calculating a rotation matrix according to the first Cartesian coordinate and the second Cartesian coordinate; and the conversion subunit is used for converting the standard pipeline model into a three-dimensional pipeline model of the target pipeline based on the pipeline central point coordinate, the scaling matrix and the rotation matrix.

Further, the construction unit includes: the decomposition subunit is used for decomposing the target multi-way joint into a plurality of straight pipes, wherein the number of the straight pipes is the same as that of channels of the target multi-way joint; the construction subunit is used for sampling each straight pipe of the target multi-way joint by a preset length along the pipeline direction of the straight pipe by taking a common intersection point of a plurality of channels as a starting point, and forming a pipe section of the straight pipe by adopting a communication section from the intersection point to the sampling point; and the combination subunit is used for constructing pipe section models of a plurality of pipe sections of the target multi-way joint by adopting a standard pipe model and obtaining a joint three-dimensional model of the target multi-way joint based on the combination of the pipe section models.

Further, the organization module includes: the determining unit is used for determining the level k of the terrain pyramid to be indexed; the first construction unit is used for acquiring a geographic coordinate region range of the target region, calculating a mapping relation between the underground pipe network three-dimensional model and the k layers of rows and columns based on the geographic coordinate region range, and constructing a primary space index of the underground pipe network three-dimensional model; the acquisition unit is used for acquiring corresponding road line vector data from the road surface according to the tile range of the primary spatial index; and the second construction unit is used for constructing a secondary block index of the underground pipe network three-dimensional model according to the road line vector data.

Further, the second building unit comprises: the first construction subunit is used for acquiring the position of the road intersection from the road line vector data and setting a first rectangular frame with the length and the width of w along the road based on the position of the road intersection; retrieving pipe network objects falling in the first rectangular frame in the three-dimensional model of the underground pipe network; after the retrieval of the pipe network object is completed, recalculating an outsourcing rectangle of the object in the first rectangular frame, and updating the length and width of the first rectangular frame, wherein each first rectangular frame corresponds to one secondary tile block; the second construction subunit is used for acquiring the road length between two intersections from the road line vector data, segmenting the road length based on the step length s, and constructing a second rectangular frame with the length s and the width w in each segment; retrieving pipe network objects falling in the second rectangular frame in the underground pipe network three-dimensional model; after the retrieval of the pipe network object is completed, recalculating the outsourcing rectangle of the object in the second rectangular frame, and updating the length and width of the second rectangular frame, wherein each second rectangular frame corresponds to one secondary tile block; wherein, the pipe network object comprises: the pipeline, the joint and the accessory facilities, s is a positive number, and w is a positive number.

Further, the generating module includes: the construction unit is used for constructing a two-dimensional plane coordinate system of the road section by taking the road central point of the road surface as an original point and being vertical to the direction of the road line; the first conversion unit is used for converting the longitude and latitude coordinates of the earth of the section characteristic point of each pipeline into a first coordinate based on an earth three-dimensional Cartesian coordinate system by taking the section central point of the pipeline as the section characteristic point for each pipeline in the second underground pipe network three-dimensional model; a second conversion unit configured to convert the first coordinate into a second coordinate based on the two-dimensional plane coordinate system; the generating unit is used for drawing a pipeline section according to the second coordinate and section data of a corresponding pipeline, calculating the clear distance and the ground clearance elevation of the pipeline, and generating an association analysis chart of the second underground network three-dimensional model and the road surface, wherein the pipeline section data comprises at least one of the following data: radius, length and width.

According to another aspect of the embodiments of the present application, there is also provided a storage medium including a stored program that executes the above steps when the program is executed.

According to another aspect of the embodiments of the present application, there is also provided an electronic device, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus; wherein: a memory for storing a computer program; a processor for executing the steps of the method by running the program stored in the memory.

Embodiments of the present application also provide a computer program product containing instructions, which when run on a computer, cause the computer to perform the steps of the above method.

According to the invention, vector underground pipeline data and pipe point data of a target area are obtained, and instantiation modeling is carried out according to the vector underground pipeline data and the pipe point data based on a pipe network template to construct a first underground pipe network three-dimensional model; acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface for each segment; performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model; according to the method, an association analysis chart of a second underground pipe network three-dimensional model and a road surface is generated according to the cross section position relation of an underground pipe network and a road in a target area, and underground pipe network data organization is carried out based on road distribution, so that the quick query and analysis of the underground pipe network corresponding to the road can be realized, the analysis efficiency is improved, the spatial azimuth relation is calculated and an analysis result is generated according to the cross section characteristics of the underground pipe network and the road, the spatial association of the underground pipe network and the road is improved, and the technical problems that the rendering efficiency of the underground pipe network three-dimensional model constructed by the related technology is low, the query speed of the underground pipe network model is low, and the analysis effect is poor are solved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:

FIG. 1 is a block diagram of a hardware configuration of a computer according to an embodiment of the present invention;

fig. 2 is a flowchart of a method for analyzing association of pipe network roads according to an embodiment of the present invention;

FIG. 3 is a schematic diagram of pipeline instantiation modeling in accordance with an embodiment of the present invention;

FIG. 4 is a schematic diagram illustrating an instantiated modeling of a pipe network joint according to an embodiment of the present invention;

FIG. 5 is a schematic diagram of an instantiated modeling of a pipe network attachment in accordance with an embodiment of the present invention;

FIG. 6 is a schematic diagram of a network road association multi-level index organization according to an embodiment of the present invention;

FIG. 7 is a schematic diagram of a pipe network road correlation analysis according to an embodiment of the present invention;

FIG. 8 is a diagram illustrating a three-dimensional modeling effect of an underground pipe network according to an embodiment of the present invention;

FIG. 9 is a diagram illustrating the effect of the pipe network road correlation analysis according to the embodiment of the present invention;

fig. 10 is a block diagram of a configuration of a pipe network road correlation analysis device according to an embodiment of the present invention.

Detailed Description

In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application. It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict.

It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example 1

The method provided by the first embodiment of the present application may be executed in a computer, a mobile phone, a handheld device, or a similar computing device. Taking an example of the present invention running on a computer, fig. 1 is a block diagram of a hardware structure of a computer according to an embodiment of the present invention. As shown in fig. 1, the computer may include one or more (only one shown in fig. 1) processors 102 (the processor 102 may include, but is not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, and optionally, a transmission device 106 for communication functions and an input-output device 108. It will be appreciated by those of ordinary skill in the art that the configuration shown in FIG. 1 is illustrative only and is not intended to limit the configuration of the computer described above. For example, a computer may also include more or fewer components than shown in FIG. 1, or have a different configuration than shown in FIG. 1.

The memory 104 may be configured to store a computer program, for example, a software program and a module of an application, such as a computer program corresponding to a method for analyzing a relationship between pipe networks, in an embodiment of the present invention, and the processor 102 executes various functional applications and data processing by running the computer program stored in the memory 104, so as to implement the method described above. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to a computer through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.

The transmission device 106 is used to receive or transmit data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer. In one example, the transmission device 106 includes a Network adapter (NIC) that can be connected to other Network devices through a base station to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used to communicate with the internet in a wireless manner.

In this embodiment, a method for analyzing association of a pipe network road is provided, and fig. 2 is a flowchart of a method for analyzing association of a pipe network road according to an embodiment of the present invention, as shown in fig. 2, the flowchart includes the following steps:

step S202, vector underground pipeline data and pipeline data of a target area are obtained, instantiation modeling is carried out according to the vector underground pipeline data and the pipeline data based on a pipeline network template, and a first underground pipeline network three-dimensional model is constructed;

the vector underground pipeline data and the pipeline data of the embodiment are two-dimensional underground pipe network data which are obtained and stored by acquisition or detection equipment in advance.

Step S204, acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface in each segment;

optionally, the road vector lines are segmented according to geometric features (road trend, etc.) and attribute information (such as lane number, lane width, etc.) of the road vector lines.

Step S206, performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model;

in the embodiment, the data organization of the three-dimensional model of the road surface and the underground pipe network is realized by establishing the index relationship between the model elements (such as pipelines, joints and the like) of the three-dimensional model of the road surface and the underground pipe network.

And S208, generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross section position relation of the underground pipe network of the target area and the road.

Through the steps, vector underground pipeline data and pipe point data of the target area are obtained, instantiation modeling is carried out according to the vector underground pipeline data and the pipe point data based on the pipe network template, and a first underground pipe network three-dimensional model is constructed; acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface for each segment; performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model; according to the method, an association analysis chart of a second underground pipe network three-dimensional model and a road surface is generated according to the cross section position relation of an underground pipe network and a road in a target area, and underground pipe network data organization is carried out based on road distribution, so that the quick query and analysis of the underground pipe network corresponding to the road can be realized, the analysis efficiency is improved, the spatial azimuth relation is calculated and an analysis result is generated according to the cross section characteristics of the underground pipe network and the road, the spatial association of the underground pipe network and the road is improved, and the technical problems that the rendering efficiency of the underground pipe network three-dimensional model constructed by the related technology is low, the query speed of the underground pipe network model is low, and the analysis effect is poor are solved.

The method comprises the steps of performing instantiation three-dimensional modeling according to underground pipe network vector data, constructing three-dimensional models of underground pipelines, joints and auxiliary facilities, and performing multi-level organization and association analysis of the underground pipe network three-dimensional models according to road vector line data, which is described in detail below.

In this embodiment, the pipes in the underground pipe network are straight pipes, and include information such as a start point, an end point, and a buried depth. The pipe may be classified into water supply, rainwater, sewage, electricity, telecommunication, gas, heat supply, communication, broadcasting, military, etc. according to its usage attributes, and may be classified into a circular pipe and a square pipe according to geometric types. According to the traditional method, each pipeline is independently modeled, so that the modeling workload is increased, and the rendering efficiency is low when the three-dimensional platform is loaded. Due to the similarity of the shapes and the materials of the pipelines, the method can be realized by setting a standard pipeline for instantiation modeling.

In this embodiment, performing instantiation modeling according to the vector underground pipeline data and the pipe network data based on a pipe network template includes:

s11, acquiring a first instantiation parameter of the pipeline, a second instantiation parameter of the joint and a third instantiation parameter of the accessory facility from the vector underground pipeline data or the pipeline point data;

s12, constructing a three-dimensional pipeline model by using the first instantiation parameters and the pipeline template, constructing a three-dimensional joint model by using the second instantiation parameters and the pipeline template, and constructing a three-dimensional affiliated facility model by using the third instantiation parameters and the affiliated parameter template;

in one embodiment of the pipeline modeling, the building of the pipeline three-dimensional model using the first instantiation parameters and the pipeline template comprises: acquiring a standard radius R and a standard length d of a standard pipeline model, and acquiring a radius R, a starting pipeline spherical coordinate and a terminal pipeline spherical coordinate of a target pipeline; converting the spherical coordinates of the starting pipeline and the finishing pipeline into a first Cartesian coordinate and a second Cartesian coordinate respectively; calculating a scaling matrix according to the first Cartesian coordinate and the second Cartesian coordinate, R, d and R, and calculating a rotation matrix according to the first Cartesian coordinate and the second Cartesian coordinate; and converting the standard pipeline model into a pipeline three-dimensional model of the target pipeline based on the pipeline central point coordinate, the scaling matrix and the rotation matrix. And the standard pipeline model is a pipeline template.

Taking the rainwater pipeline instantiated modeling as an example, the modeling method of other pipeline types is similar, the modeling method is shown in fig. 3, fig. 3 is a schematic diagram of the pipeline instantiated modeling of the embodiment of the invention, and the description is given by combining the drawing, and the radius of a standard rainwater circular pipe model is set as r, and the length is set as d. The radius of the current modeling pipeline is R, the longitude and latitude and height coordinates of the starting point are (lon1, lat1, h1), the longitude and latitude and height coordinates of the ending point are (lon2, lat2, h2), and the calculation steps of the scaling coefficient are as follows:

and constructing a global Cartesian coordinate system O-XYZ by taking the earth center as an origin, and constructing a local Cartesian coordinate system O-XYZ by taking the pipeline center as the origin. And (3) setting longitude and latitude coordinates and height marks (lon, lat, h) of the central point of the pipeline, converting the longitude and latitude coordinates and the height marks into global Cartesian coordinates, wherein delta x, delta y and delta z are coordinate positions of the origin of the local Cartesian coordinate system in the global Cartesian coordinate system:

the translation matrix for the current pipe modeling can be expressed as:

assuming that the global cartesian coordinates of the start point and the end point of the pipeline after coordinate transformation are (x1, y1, z1) and (x2, y2, z2), the scaling factor thereof can be expressed as:

the scaling matrix for the current pipeline modeling can be expressed as:

assuming that the rotation angle of the current pipe model with respect to the standard pipe is (a, b, g), and the coordinates of the two end points of the current pipe are (x1, y1, z1) and (x2, y2, z2), the rotation angle can be calculated as:

the rotation matrix of the current pipe modeling can be expressed as:

according to the pipeline center point coordinates, and the scaling matrix (M) of the pipeline_scaling) Rotation matrix, translation matrix (M)_translation) The standard rainwater pipeline can be instantiated to form an object to express the current rainwater pipeline.

Similarly, for a large-range rainwater pipe network, different rainwater pipes can be constructed based on an instantiation modeling method to realize the rainwater pipe network.

In one embodiment of joint modeling, constructing a three-dimensional model of a joint using the second instantiated parameters and a pipe template comprises: decomposing the target multi-pass joint into a plurality of straight pipes, wherein the number of the straight pipes is the same as that of channels of the target multi-pass joint; for each straight pipe of the target multi-way joint, taking a common intersection point of a plurality of channels as a starting point, sampling along the pipeline direction of the straight pipe by a preset length to obtain a sampling point, and forming a pipe section of the straight pipe by adopting a communication section from the intersection point to the sampling point; and constructing pipe section models of a plurality of pipe sections of the target multi-way joint by adopting a standard pipe model, and combining the pipe section models to obtain a joint three-dimensional model of the target multi-way joint.

In this embodiment, the joint includes an elbow (two-way), a tee, a four-way, and the like, for realizing the connection between the pipes. The joint can be disassembled into a plurality of sections of pipelines to be combined, so that the joint instantiation modeling can be realized on the basis of the pipeline instantiation modeling. The two-way joint can be divided into two straight pipes which are connected, the three-way joint can be divided into three direct-view joints, and the four-way joint can be divided into four direct-view joints. The transition between different segments of the joint can be smoothed by shielding the three-dimensional model.

In an example, a tee instantiation modeling is taken as an example for explanation, fig. 4 is a schematic diagram of pipe network joint instantiation modeling according to an embodiment of the present invention, where pipelines PA, PB, and PC are connected based on a tee joint at a feature point P, and a point E, F, G is obtained by sampling along a pipeline direction with a length k and with the feature point P as a starting point, and then PE, PF, and PG are pipe segments constituting the tee joint, and coordinates of a point E are calculated as:

therefore, the three-way instantiation modeling at the point P can construct three pipelines of PE, PF and PG by the instantiation pipeline modeling method, and then form a three-dimensional tee model by combination.

In the instantiation modeling process of the auxiliary facility in the embodiment, the pipeline auxiliary facility comprises equipment such as a pipe well, a valve, a water meter, a transformer box and the like. Based on the instantiation modeling, an accessory standard model library is constructed according to the accessory types, the current standard model is obtained by judging the current pipe point type, and parameters such as scaling, rotation, position and the like are set to instantiate a facility object, and fig. 5 is a schematic diagram of the instantiation modeling of the pipe network and the accessory in the embodiment of the invention, which is similar to the principle of the pipeline instantiation modeling in fig. 3.

And S13, connecting the three-dimensional pipeline models by adopting the joint three-dimensional models, and deploying the three-dimensional accessory facility models on the three-dimensional pipeline models to obtain a first underground pipe network three-dimensional model.

Aiming at the characteristics of the underground pipe network, pipeline, joint and accessory facility models are respectively constructed based on an instantiation parameter three-dimensional modeling method, the data volume of the models is remarkably reduced through an instantiation technology, and the rendering efficiency of the large-range three-dimensional pipe network is improved.

The underground pipe network is generally distributed along roads, and when a manager checks three-dimensional model data of the underground pipe network, the phenomena of slow loading and unsmooth rendering easily occur due to large data volume of the three-dimensional model, so that the embodiment realizes the data organization of the pipe network model based on a multi-level index strategy, as shown in fig. 6, fig. 6 is a schematic diagram of the pipe network road association multi-level index organization of the embodiment of the invention. In an embodiment of this embodiment, the organizing data of the first underground pipe network three-dimensional model based on the distribution of the road surface includes:

s21, determining a level k of a terrain pyramid to be indexed, wherein k is a positive integer;

s22, acquiring a geographical coordinate area range of the target area, calculating a mapping relation between the three-dimensional model of the underground pipe network and k layers of rows and columns based on the geographical coordinate area range, and constructing a primary spatial index of the three-dimensional model of the underground pipe network;

s23, acquiring corresponding road line vector data from the road surface according to the tile range of the primary spatial index;

and S24, constructing a two-stage block index of the underground pipe network three-dimensional model according to the road line vector data.

In one example, the constructing of the two-level block index of the three-dimensional model of the underground pipe network according to the road line vector data comprises: acquiring a road intersection position from the road line vector data, and setting a first rectangular frame with the length and the width of w along a road based on the road intersection position; searching a pipe network object falling in the first rectangular frame in the underground pipe network three-dimensional model; after the retrieval of the pipe network object is completed, recalculating the outsourcing rectangle of the object in the first rectangular frame, and updating the length and width of the first rectangular frame, wherein each first rectangular frame corresponds to one secondary tile block; acquiring the road length between two intersections from the road line vector data, segmenting the road length based on the step length s, and constructing a second rectangular frame with the length s and the width w in each segment; retrieving pipe network objects falling in the second rectangular frame in the underground pipe network three-dimensional model; after the retrieval of the pipe network object is completed, recalculating the outsourcing rectangle of the object in the second rectangular frame, and updating the length and width of the second rectangular frame, wherein each second rectangular frame corresponds to one secondary tile block; wherein, pipe network object includes: the pipeline, the joint and the accessory facilities, s is a positive number, and w is a positive number.

In the process of indexing the first-level pipe network quad-tree, in order to quickly query and acquire the data area of the underground pipe network in the current range, the geographical range of the urban area is divided into first-level blocks based on the terrain quad-tree. For road regions, the pyramid level may be set to a larger level, such as level 18, due to the smaller subsurface range to which it corresponds. And performing primary organization on the three-dimensional model of the underground pipe network according to the quadtree subdivision, and realizing primary data scheduling by acquiring a layer row corresponding to the current mobile end camera.

In an implementation scene, coordinates of the upper left corner and the lower right corner of a scene geographic range shot by a mobile-end camera are set as (minLon, maxLat) and (maxLon, minLat) respectively, and a mapping relation between the coordinates and a terrain pyramid layer row and column is calculated. Then corresponding to the k-th level pyramid of the terrain, the range of rows and columns of the data can be calculated as:

based on the implementation scenario, in the process of the secondary road pipe network association index, the user can quickly position the corresponding underground pipe network tile according to the longitude and latitude of the mobile terminal through the primary quadtree partitioning index. However, the underground pipe network three-dimensional model for displaying the whole tile is directly loaded, the data volume is still large, and the phenomenon of blockage of the enhanced display rendering is easily caused. The embodiment is based on the characteristic that the underground pipe network is distributed along the long and narrow road, and users usually observe along the road, so that a two-level block index is constructed along the road, and the loading and rendering data volume at the current view angle is reduced. For the ith row and jth column of quad-tree tiles of the kth layer (k is more than or equal to 0 and less than or equal to n), the tile ranges are as follows:

acquiring corresponding road line vector data according to the range of the first-level index tiles, wherein the strategy implementation step of the second-level along-road block indexing comprises the following steps:

(1) the method comprises the steps of acquiring the position of a road intersection, setting a rectangular frame with the length and the width being fixed w, and judging the object ID of a pipeline, a joint, an accessory facility and the like falling in the rectangle. After the object retrieval is finished, recalculating the outsourcing rectangle of the object in the current tile, updating the length and the width of the object, and constructing the object as the current tile; wherein the joint and the attached facility are processed as point elements, and whether the point elements fall in the rectangular frame is judged based on the contained operation. The pipe type is a line element, and whether it falls on a rectangular frame is determined based on the overlay analysis.

(2) The method comprises the steps of obtaining the length of a road between two intersections, segmenting the road based on the step length s, constructing each segment into a rectangular frame with the length s and the width w, and judging the ID of an object, such as a pipeline, a joint, an accessory facility and the like, falling in the rectangular frame. And after the object retrieval is finished, recalculating the outsourcing rectangle of the object in the current tile, updating the length and the width of the object, and constructing the current tile.

The organization and rendering of the underground pipe network are realized based on the instantiated pipe network modeling and the secondary index mechanism, the effect is shown in fig. 7, fig. 7 is a schematic diagram of the pipe network road association analysis of the embodiment of the invention, the three-dimensional underground pipe network has better drawing effect and is more smooth in rendering.

In an embodiment of this embodiment, generating an association analysis graph between a second three-dimensional model of the underground pipe network and a road surface according to a cross-sectional position relationship between the underground pipe network of the target area and the road includes: taking the road center point of the road surface as an original point, and constructing a two-dimensional plane coordinate system of the road section in a direction perpendicular to the road line; for each pipeline in the second underground pipe network three-dimensional model, taking the section central point of the pipeline as a section characteristic point, and converting the longitude and latitude coordinates of the earth of the section characteristic point of each pipeline into a first coordinate based on an earth three-dimensional Cartesian coordinate system; converting the first coordinates into second coordinates based on a two-dimensional plane coordinate system; drawing a pipeline section according to the second coordinate and section data of the corresponding pipeline, calculating the clear distance and the ground clearance elevation of the pipeline, and generating an association analysis chart of the second underground pipe network three-dimensional model and the road surface, wherein the pipeline section data comprises at least one of the following data: radius, length and width.

Roads can be classified into expressways, general highways, and the like according to their common types. According to the coordinate position and the attribute information of the road vector data, a road section distribution diagram can be constructed. As shown in fig. 8, fig. 8 is a three-dimensional modeling effect diagram of an instantiation of an underground pipe network according to an embodiment of the present invention, where a two-dimensional plane coordinate system o-xy is constructed in a direction perpendicular to a road line with a road center point as an origin, and a road section is constructed according to parameters such as isolation zones, the number of lanes, and lane widths in road attributes. The method comprises the following steps of calculating the characteristics of the pipeline section by taking the road section as a reference, wherein the method comprises the following steps:

and converting the longitude and latitude coordinates of the earth of the feature points into three-dimensional Cartesian coordinates O-XYZ of the earth.

The method comprises the steps of converting three-dimensional Cartesian coordinates O-XYZ of the earth into two-dimensional plane coordinates O-xy, and specifically realizing the conversion through a seven-parameter conversion method. Assuming that the coordinates of the sampling point in the two-dimensional plane coordinate system O-xy are (X, Y), and the coordinates of the sampling point in the global cartesian coordinate system O-XYZ are (X, Y, Z), the transformation equation is:

wherein s is a scaling coefficient, α is an included angle between an X axis of a plane coordinate system and an X axis of a Cartesian coordinate system of the earth, β is an included angle between a Y axis of the plane coordinate system and a Y axis of the Cartesian coordinate system of the earth, γ is an included angle between a road line direction and a Z axis of the Cartesian coordinate system of the earth, and coordinates of a center point of the earth in a two-dimensional plane coordinate system are (X0, Y0).

According to the steps, the plane position coordinates of the center point of each pipeline section can be calculated, then the pipeline section is drawn according to the pipeline section data (radius or length and width), the clear distance of the pipeline, the elevation from the ground and the like are calculated, the pipe network road correlation analysis drawing is realized, the pipe network road correlation analysis effect is shown in fig. 9, and fig. 9 is an effect diagram of the pipe network road correlation analysis according to the embodiment of the invention.

According to the scheme of the embodiment, an underground pipe network model is built through an instantiation parameter three-dimensional modeling method, and data organization and correlation analysis are carried out by correlating an underground pipe network and an urban road. For the characteristics of the underground pipe network, pipeline, joint and accessory facility models are respectively constructed based on an instantiation parameter three-dimensional modeling method, the data volume of the models is remarkably reduced through an instantiation technology, and the rendering efficiency of the large-range three-dimensional pipe network is improved. Aiming at the characteristic that underground pipe network facilities generally have long and narrow linear distribution along roads, underground pipe network data organization is carried out based on road distribution, the quick query and analysis of the underground pipe network corresponding to the roads are realized, and the analysis efficiency is improved. And calculating the spatial orientation relation of the underground pipe network and the cross-section characteristics of the road and generating an analysis result, so that the spatial correlation of the analysis result is improved.

Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.

Example 2

In this embodiment, a device for analyzing association of a pipe network road is further provided, which is used to implement the foregoing embodiments and preferred embodiments, and which has already been described and will not be described again. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.

Fig. 10 is a block diagram of a structure of a pipe network road correlation analysis device according to an embodiment of the present invention, and as shown in fig. 10, the device includes: a first building block 100, a second building block 102, an organization block 104, a generation block 106, wherein,

the system comprises a first construction module 100, a first data processing module and a second data processing module, wherein the first construction module is used for obtaining vector underground pipeline data and pipeline data of a target area, carrying out instantiation modeling according to the vector underground pipeline data and the pipeline data based on a pipeline network template, and constructing a first underground pipeline network three-dimensional model;

the second construction module 102 is configured to obtain road vector line data of a target area, segment the road vector line, and construct a road surface for each segment;

the organization module 104 is configured to perform data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model;

and the generating module 106 is configured to generate an association analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross-sectional position relationship between the underground pipe network of the target area and the road.

Optionally, the first building module includes: the acquisition unit is used for acquiring a first instantiation parameter of a pipeline, a second instantiation parameter of a joint and a third instantiation parameter of an accessory facility from the vector underground pipeline data or the pipe point data; the construction unit is used for constructing a three-dimensional pipeline model by adopting the first instantiation parameters and the pipeline template, constructing a three-dimensional joint model by adopting the second instantiation parameters and the pipeline template, and constructing a three-dimensional affiliated facility model by adopting the third instantiation parameters; and the processing unit is used for connecting the pipeline three-dimensional model by adopting the joint three-dimensional model and deploying the attached facility three-dimensional model on the pipeline three-dimensional model to obtain a first underground pipe network three-dimensional model.

Optionally, the building unit includes: the acquisition subunit is used for acquiring a standard radius R and a standard length d of the standard pipeline model, and acquiring a radius R, a starting pipeline spherical coordinate and a terminal pipeline spherical coordinate of the target pipeline; the conversion subunit is used for converting the starting pipeline spherical coordinate and the end pipeline spherical coordinate into a first Cartesian coordinate and a second Cartesian coordinate respectively; the calculating subunit is used for calculating a scaling matrix according to the first Cartesian coordinate, the second Cartesian coordinate, the R, the d and the R, and calculating a rotation matrix according to the first Cartesian coordinate and the second Cartesian coordinate; and the conversion subunit is used for converting the standard pipeline model into a three-dimensional pipeline model of the target pipeline based on the pipeline central point coordinate, the scaling matrix and the rotation matrix.

Optionally, the building unit includes: the decomposition subunit is used for decomposing the target multi-way joint into a plurality of straight pipes, wherein the number of the straight pipes is the same as that of channels of the target multi-way joint; the construction subunit is used for sampling each straight pipe of the target multi-way joint by a preset length along the pipeline direction of the straight pipe by taking a common intersection point of a plurality of channels as a starting point, and forming a pipe section of the straight pipe by adopting a communication section from the intersection point to the sampling point; and the combination subunit is used for constructing pipe section models of a plurality of pipe sections of the target multi-way joint by adopting a standard pipe model and obtaining a joint three-dimensional model of the target multi-way joint based on the combination of the pipe section models.

Optionally, the organization module includes: the determining unit is used for determining the level k of the terrain pyramid to be indexed; the first construction unit is used for acquiring a geographic coordinate region range of the target region, calculating a mapping relation between the underground pipe network three-dimensional model and the k layers of rows and columns based on the geographic coordinate region range, and constructing a primary space index of the underground pipe network three-dimensional model; the acquisition unit is used for acquiring corresponding road line vector data from the road surface according to the tile range of the primary spatial index; and the second construction unit is used for constructing a secondary block index of the underground pipe network three-dimensional model according to the road line vector data.

Optionally, the second building unit includes: the first construction subunit is used for acquiring the position of the road intersection from the road line vector data and setting a first rectangular frame with the length and the width of w along the road based on the position of the road intersection; retrieving pipe network objects falling in the first rectangular frame in the three-dimensional model of the underground pipe network; after the retrieval of the pipe network object is completed, recalculating an outsourcing rectangle of the object in the first rectangular frame, and updating the length and width of the first rectangular frame, wherein each first rectangular frame corresponds to one secondary tile block; the second construction subunit is used for acquiring the road length between two intersections from the road line vector data, segmenting the road length based on the step length s, and constructing a second rectangular frame with the length s and the width w in each segment; retrieving pipe network objects falling in the second rectangular frame in the underground pipe network three-dimensional model; after the retrieval of the pipe network object is completed, recalculating the outsourcing rectangle of the object in the second rectangular frame, and updating the length and width of the second rectangular frame, wherein each second rectangular frame corresponds to one secondary tile block; wherein, the pipe network object comprises: the pipeline, the joint and the accessory facilities, s is a positive number, and w is a positive number.

Optionally, the generating module includes: the construction unit is used for constructing a two-dimensional plane coordinate system of the road section by taking the road central point of the road surface as an original point and being vertical to the direction of the road line; the first conversion unit is used for converting the longitude and latitude coordinates of the earth of the section characteristic point of each pipeline into a first coordinate based on an earth three-dimensional Cartesian coordinate system by taking the section central point of the pipeline as the section characteristic point for each pipeline in the second underground pipe network three-dimensional model; a second conversion unit configured to convert the first coordinate into a second coordinate based on the two-dimensional plane coordinate system; the generating unit is used for drawing a pipeline section according to the second coordinate and section data of a corresponding pipeline, calculating the clear distance and the ground clearance elevation of the pipeline, and generating an association analysis chart of the second underground network three-dimensional model and the road surface, wherein the pipeline section data comprises at least one of the following data: radius, length and width.

It should be noted that, the above modules may be implemented by software or hardware, and for the latter, the following may be implemented, but not limited to: the modules are all positioned in the same processor; alternatively, the modules are respectively located in different processors in any combination.

Example 3

Embodiments of the present invention also provide a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps of any of the above method embodiments when executed.

Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:

s1, acquiring vector underground pipeline data and pipeline data of a target area, and performing instantiation modeling according to the vector underground pipeline data and the pipeline data based on a pipeline network template to construct a first underground pipeline network three-dimensional model;

s2, acquiring road vector line data of the target area, segmenting the road vector line, and constructing a road surface in each segment;

s3, performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model;

and S4, generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross-section position relation between the underground pipe network of the target area and the road.

Optionally, in this embodiment, the storage medium may include, but is not limited to: various media capable of storing computer programs, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.

Embodiments of the present invention also provide an electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the steps of any of the above method embodiments.

Optionally, the electronic device may further include a transmission device and an input/output device, wherein the transmission device is connected to the processor, and the input/output device is connected to the processor.

Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:

Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again.

The above-mentioned serial numbers of the embodiments of the present application are merely for description and do not represent the merits of the embodiments.

In the above embodiments of the present application, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

The foregoing is only a preferred embodiment of the present application and it should be noted that those skilled in the art can make several improvements and modifications without departing from the principle of the present application, and these improvements and modifications should also be considered as the protection scope of the present application.

Claims

1. A correlation analysis method for a pipe network road is characterized by comprising the following steps:

acquiring vector underground pipeline data and pipe point data of a target area, and performing instantiation modeling according to the vector underground pipeline data and the pipe point data based on a pipe network template to construct a first underground pipe network three-dimensional model;

acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface for each segment;

performing data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model;

and generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross section position relation between the underground pipe network of the target area and the road.

2. The method of claim 1, wherein instantiating modeling from the vector underground pipeline data and the pipe pipeline data based on a pipe network template comprises:

acquiring a first instantiation parameter of a pipeline, a second instantiation parameter of a joint and a third instantiation parameter of an accessory facility from the vector underground pipeline data or the pipe point data;

adopting the first instantiation parameters and the pipeline template to construct a pipeline three-dimensional model, adopting the second instantiation parameters and the pipeline template to construct a joint three-dimensional model, and adopting the third instantiation parameters and the accessory parameter template to construct an accessory facility three-dimensional model;

and connecting the three-dimensional pipeline models by adopting the joint three-dimensional model, and deploying the three-dimensional accessory facility models on the three-dimensional pipeline models to obtain a first underground pipe network three-dimensional model.

3. The method of claim 2, wherein constructing a three-dimensional model of a pipe using the first instantiated parameters and a pipe template comprises:

acquiring a standard radius R and a standard length d of a standard pipeline model, and acquiring a radius R, a starting pipeline spherical coordinate and a terminal pipeline spherical coordinate of a target pipeline;

converting the starting pipeline spherical coordinate and the end pipeline spherical coordinate into a first Cartesian coordinate and a second Cartesian coordinate respectively;

calculating a scaling matrix according to the first Cartesian coordinate and the second Cartesian coordinate, R, d and R, and calculating a rotation matrix according to the first Cartesian coordinate and the second Cartesian coordinate;

converting the standard pipe model to a pipe three-dimensional model of the target pipe based on the pipe center point coordinates, the scaling matrix, and the rotation matrix.

4. The method of claim 2, wherein constructing a joint three-dimensional model using the second instantiated parameters and a pipe template comprises:

decomposing a target multi-way joint into a plurality of straight pipes, wherein the number of the straight pipes is the same as that of channels of the target multi-way joint;

for each straight pipe of the target multi-way joint, taking a common intersection point of a plurality of channels as a starting point, sampling along the pipeline direction of the straight pipe by a preset length to obtain a sampling point, and adopting a communication section from the intersection point to the sampling point to form a pipe section of the straight pipe;

and constructing pipe section models of a plurality of pipe sections of the target multi-way joint by adopting a standard pipe model, and combining to obtain a joint three-dimensional model of the target multi-way joint based on the plurality of pipe section models.

5. The method of claim 1, wherein the data organizing of the three-dimensional model of the underground pipe network based on the distribution of the road surface comprises:

determining a level k of a terrain pyramid to be indexed;

acquiring a geographic coordinate area range of the target area, calculating a mapping relation between the underground pipe network three-dimensional model and the k layers of rows and columns based on the geographic coordinate area range, and constructing a primary space index of the underground pipe network three-dimensional model;

acquiring corresponding road line vector data from the road surface according to the tile range of the primary spatial index;

and constructing a secondary block index of the underground pipe network three-dimensional model according to the road route vector data.

6. The method of claim 5, wherein constructing a two-level block index of the three-dimensional model of the underground pipe network from the road-route vector data comprises:

acquiring a road intersection position from the road route vector data, and setting a first rectangular frame with the length and the width of w along a road based on the road intersection position; retrieving pipe network objects falling in the first rectangular frame in the three-dimensional model of the underground pipe network; after the retrieval of the pipe network object is completed, recalculating an outsourcing rectangle of the object in the first rectangular frame, and updating the length and width of the first rectangular frame, wherein each first rectangular frame corresponds to one secondary tile block;

acquiring the road length between two intersections from the road route vector data, segmenting the road length based on the step length s, and constructing a second rectangular frame with the length s and the width w in each segment; retrieving pipe network objects falling in the second rectangular frame in the underground pipe network three-dimensional model; after the retrieval of the pipe network object is completed, recalculating the outsourcing rectangle of the object in the second rectangular frame, and updating the length and width of the second rectangular frame, wherein each second rectangular frame corresponds to one secondary tile block;

wherein, the pipe network object comprises: the pipeline, the joint and the accessory facilities, s is a positive number, and w is a positive number.

7. The method of claim 1, wherein generating the correlation analysis map of the second three-dimensional model of the underground pipe network and the road surface according to the cross-sectional position relationship between the underground pipe network of the target area and the road comprises:

taking the road center point of the road surface as an original point, and constructing a two-dimensional plane coordinate system of the road section in a direction perpendicular to the road line;

for each pipeline in the second underground pipe network three-dimensional model, taking a section central point of the pipeline as a section characteristic point, and converting the longitude and latitude coordinates of the earth of the section characteristic point of each pipeline into a first coordinate based on an earth three-dimensional Cartesian coordinate system;

converting the first coordinates into second coordinates based on the two-dimensional plane coordinate system;

drawing a pipeline section according to the second coordinate and section data of the corresponding pipeline, calculating the clear distance and the ground clearance elevation of the pipeline, and generating an association analysis chart of the second underground pipe network three-dimensional model and the road surface, wherein the pipeline section data comprises at least one of the following data: radius, length and width.

8. A correlation analysis device for a pipe network road is characterized by comprising:

the system comprises a first construction module, a second construction module and a third construction module, wherein the first construction module is used for acquiring vector underground pipeline data and pipeline data of a target area, carrying out instantiation modeling according to the vector underground pipeline data and the pipeline data based on a pipeline network template, and constructing a first underground pipeline network three-dimensional model;

the second construction module is used for acquiring road vector line data of a target area, segmenting the road vector line, and constructing a road surface in each segment;

the organization module is used for carrying out data organization on the first underground pipe network three-dimensional model based on the distribution of the road surface to obtain a second underground pipe network three-dimensional model;

and the generation module is used for generating a correlation analysis chart of the second underground pipe network three-dimensional model and the road surface according to the cross section position relation between the underground pipe network of the target area and the road.

9. A storage medium, characterized in that the storage medium comprises a stored program, wherein the program is operative to perform the method steps of any of the preceding claims 1 to 7.

10. An electronic device comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are communicated with each other through the communication bus; wherein:

a memory for storing a computer program;

a processor for performing the method steps of any of claims 1 to 7 by executing a program stored on a memory.