Urban pipe network automation three-dimensional pipe network GIS modeling method, device, equipment and medium

Abstract

The invention belongs to the technical field of three-dimensional modeling, and discloses an automatic three-dimensional pipe network GIS modeling method, device, equipment and medium for an urban pipe network, and the method comprises the steps: obtaining pipeline data of the urban pipe network, preprocessing the pipeline data of the urban pipe network, and obtaining original pipeline information data; a pipe point table and a pipeline table in the original pipeline information data are identified, the pipe point table comprises key fields of a plurality of pipe points, and the pipeline table comprises key fields of a plurality of pipelines; generating a modeling configuration file based on the key fields of the plurality of pipe points and the key fields of the plurality of pipelines; and generating modeling time configuration, and based on the modeling time configuration, importing a modeling configuration file into a preset modeling program to perform automatic modeling on the urban pipe network to obtain a three-dimensional pipe network GIS model. The method can be seamlessly connected with different modeling software platforms, and has the advantages of being high in modeling efficiency, low in labor cost, fast in data updating, low in operation cost and the like.

Description

Technical Field

[0001] The present invention belongs to the technical field of three-dimensional modeling, and specifically relates to a method, device, equipment and medium for modeling a three-dimensional urban pipe network automation GIS model. Background Art

[0002] Urban underground pipelines are an important part of the city's underground municipal infrastructure. They include water supply, drainage, gas, heat, communication, electricity, industry and other categories. They are like the "nerves" and "blood vessels" in the human body, responsible for transmitting information and transporting energy day and night. They are the material basis for the survival and development of the city and are called the "lifeline" of the city. At the same time, in the process of urban planning, design, construction and management, if there is no complete and accurate information on underground pipelines, it will be difficult to move forward and even cause heavy losses. Understanding the current status of urban underground comprehensive pipelines is a need for urban planning, construction and management.

[0003] Traditional two-dimensional pipe network GIS (Geographic Information System) and two-dimensional CAD (Computer-Aided Design) maps are difficult to display the spatial distribution of pipelines in underground pipe networks. They can only display the plane distribution of pipelines. There are many intersections in densely populated areas, making it difficult to identify whether pipelines collide or the direction of high and low pipe networks. At the same time, two-dimensional pipe network GIS and CAD maps cannot directly display pipeline attribute information and ancillary facilities information at pipeline connections. They are only expressed indirectly through annotations. Therefore, annotations in densely populated areas are chaotic and even cover up pipeline information. However, as the scale of cities continues to change and the degree of refined urban management continues to improve, the complexity of underground pipe networks is increasing and needs to be constantly changed. Therefore, if traditional two-dimensional methods are still used, it will bring great challenges to the design, construction, maintenance, and planning of urban underground pipe networks.

[0004] Due to the large scale, wide range and many types of urban pipeline networks, the construction of three-dimensional pipeline networks requires a lot of manpower, capital and time costs. Summary of the invention

[0005] The purpose of the present invention is to provide a method, device, equipment and medium for automated three-dimensional urban pipe network GIS modeling, so as to solve the problem that the construction of three-dimensional pipe network requires a lot of manpower, capital and time costs due to the large scale, wide range and many types of urban pipe networks.

[0006] In order to achieve the above object, the present invention adopts the following technical solutions: In a first aspect, the present invention provides a method for GIS modeling of an automated three-dimensional urban pipe network, the method comprising: Obtain pipeline data of the urban pipeline network, pre-process the pipeline data of the urban pipeline network, and obtain original pipeline information data; Identify a pipe point table and a pipeline table in the original pipeline information data, wherein the pipe point table includes key fields of several pipe points, and the pipeline table includes key fields of several pipelines; Generate a modeling configuration file based on the key fields of several pipe points and the key fields of several pipelines; Generate a modeling time configuration, and based on the modeling time configuration, import the modeling configuration file into a preset modeling program to automatically model the urban pipe network to obtain a three-dimensional pipe network GIS model.

[0007] Preferably, the key fields of the pipe points in the pipe point table and the key fields of the pipelines in the pipeline table both include: pipeline type, pipeline subclass, pipe diameter and pipeline material; The key fields of the control points in the control point table also include at least: point number on the map, well depth, feature point, auxiliary facilities, horizontal coordinate, vertical coordinate, ground elevation, well neck depth, well cover type, well cover specification, well cover material and angle; The key fields of the pipeline in the pipeline table also include at least: starting point number, ending point number, starting point burial depth, ending point burial depth, starting point elevation, ending point elevation, burial method, hole specification and hole diameter.

[0008] Preferably, a modeling configuration file is generated based on the key fields of several pipe points and the key fields of several pipelines, including: Determine the type configuration of the pipeline according to the pipeline subclass in the pipeline table or pipeline point table; Determine the adaptive symbol configuration of the characteristic points of the pipe point according to the characteristic points in the pipe point table; According to the ancillary facilities in the control point table, determine the model configuration of the ancillary facilities of the control point; When the type of the auxiliary facility in the pipe point table is a well, determine the well configuration, wherein the well configuration includes: well model (square well, round well or conical well), well cover material and well chamber material; Determine the connection direction configuration of pipelines of the same type according to the start point number and end point number in the pipeline table; Determine the spatial layout configuration of each type of pipeline according to the horizontal coordinate, vertical coordinate and ground elevation in the pipeline point table and the starting point burial depth and terminal burial depth in the pipeline table; The pipe diameter, hole diameter and hole specification in the pipeline table or the pipeline material in the pipeline table determine the attribute configuration of each type of pipeline; A modeling configuration file is generated based on the pipeline type configuration, the adaptive symbol configuration of the characteristic points of the pipeline point, the model configuration of the ancillary facilities of the pipeline point, the well configuration when the type of the ancillary facilities of the pipeline point is a well, the connection direction configuration of the same type of pipelines, the spatial layout configuration of each type of pipelines and the attribute configuration of each type of pipelines.

[0009] Preferably, the model configuration of the auxiliary facilities of the pipe point is to use model symbols to build the model of the auxiliary facilities, and the well model uses three-dimensional adaptive symbols and model symbols to collaboratively build the model of the well.

[0010] Preferably, the attribute configuration of each type of pipeline includes: configuration of the multi-hole specifications of each type of pipeline; According to the pipe diameter, hole diameter and hole specifications in the pipeline table, determine the attribute configuration of each type of pipeline, including: Extract the hole position attributes of each pipeline from the hole specifications in the pipeline table, wherein the hole position attributes include: the number of pipe holes, arrangement mode, hole diameter and hole spacing of the pipeline; According to the hole diameter and hole spacing, calculate the distance between the center points of adjacent holes of each pipeline; According to the number of tube holes, arrangement, hole diameter, hole spacing, tube diameter and the distance between the center points of adjacent tube holes, the position coordinate information of each tube hole of each pipeline is generated, and the position coordinate information of each tube hole of each pipeline is used as the multi-hole specification configuration of the type pipeline.

[0011] Preferably, the method further comprises: Perform information verification on the pipe point table and the pipeline table to obtain verification results, wherein the verification results include: information completeness or information abnormality; wherein the information verification includes: key field empty verification and data type abnormality or specification verification; When the verification result is abnormal information, an abnormal log is generated.

[0012] Preferably, preprocessing the pipeline data of the urban pipeline network includes: importing the pipeline data of the urban pipeline network into a spatial database to obtain pipeline spatial data, and using the pipeline spatial data as original pipeline information data; Or convert the pipeline data of the urban pipeline network into Shape data, and use the Shape data as the original pipeline information data.

[0013] In a second aspect, the present invention provides a city pipe network automated three-dimensional pipe network GIS modeling device, which is used to implement the above-mentioned city pipe network automated three-dimensional pipe network GIS modeling method, and the device includes: The data processing module is used to obtain the pipeline data of the urban pipeline network, pre-process the pipeline data of the urban pipeline network, and obtain the original pipeline information data; A data identification module, used to identify a pipe point table and a pipeline table in the original pipeline information data, wherein the pipe point table includes key fields of several pipe points, and the pipeline table includes key fields of several pipelines; A data configuration module, used for generating a modeling configuration file based on key fields of a plurality of pipe points and key fields of a plurality of pipelines; The model building module is used to generate a modeling time configuration. Based on the modeling time configuration, the modeling configuration file is imported into a preset modeling program to automatically model the urban pipe network and obtain a three-dimensional pipe network GIS model.

[0014] In a third aspect, the present invention provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned urban pipeline network automated three-dimensional pipeline network GIS modeling method when executing the computer program.

[0015] In a fourth aspect, the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the above-mentioned urban pipe network automated three-dimensional pipe network GIS modeling method.

[0016] Beneficial effects: The present invention processes the pipeline data of the urban pipeline network to obtain original pipeline information data including a pipe point table and a pipeline table, and then generates a modeling configuration file according to the key fields of several pipe points in the pipe point table and the key fields of several pipelines in the pipeline table; then, according to the needs of users, the periodic time plan of modeling (i.e., modeling time configuration) is flexibly configured, and the modeling configuration file is imported into the preset modeling program to realize automatic modeling of the urban pipeline network; the present invention can be seamlessly connected with different modeling software platforms, and has the advantages of high modeling efficiency, low labor cost, fast data update and low operating cost. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] The accompanying drawings are used to provide a further understanding of the embodiments of the present invention and constitute a part of the specification. Together with the following specific implementations, they are used to explain the embodiments of the present invention, but do not constitute a limitation on the embodiments of the present invention. In the accompanying drawings: Figure 1 It is a flow chart of a method for GIS modeling of an automated three-dimensional urban pipe network provided by an embodiment of the present invention; Figure 2 is a schematic diagram of modeling steps provided by one embodiment of the present invention; Figure 3 It is a schematic diagram of the modeling effect of the integrated pipe network; Figure 4 This is a schematic diagram of the modeling effect of the pipe hole and pipeline; Figure 5It is a schematic diagram of the modeling effect of the tube well; Figure 6 It is a schematic diagram of the modeling effect of the ancillary facilities; Figure 7 It is a schematic diagram of the overall modeling effect of feature points; Figure 8 It is a schematic diagram of the modeling effect of the auxiliary facilities (substation); Fig. 9 It is a block diagram of an urban pipe network automated three-dimensional pipe network GIS modeling device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0018] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be briefly introduced below in combination with the drawings and the description of the embodiments or the prior art. Obviously, the following description of the structure of the drawings is only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. It should be noted that the description of these embodiments is used to help understand the present invention, but does not constitute a limitation of the present invention.

[0019] Embodiment 1 Figure 1 : is a flow chart of a method for GIS modeling of an automated three-dimensional urban pipe network provided by an embodiment of the present invention, such as Figure 1 As shown, this embodiment provides a method for GIS modeling of an automated three-dimensional urban pipe network, the method comprising: Step S10: Obtain pipeline data of the urban pipeline network, pre-process the pipeline data of the urban pipeline network, and obtain original pipeline information data.

[0020] In this embodiment, the pipeline data of the urban pipeline network mainly comes from existing data and census data, which generally include three types: paper data, drawings and electronic data.

[0021] In this embodiment, preprocessing the pipeline data of the urban pipeline network includes: importing the pipeline data of the urban pipeline network into a spatial database to obtain pipeline spatial data, and using the pipeline spatial data as the original pipeline information data; that is, uniformly arranging the data information contained in the above three types and importing them into the spatial database as the original pipeline information data, wherein the spatial database is a database specially designed for storing, querying and managing spatial data, i.e., data describing the surface features of the earth. This database supports the complex structure of spatial data, including spatial objects such as points, lines, and surfaces in a geographic information system (GIS).

[0022] Or convert the pipeline data of the urban pipeline network into Shape data (i.e. Shape file), and use Shape data as the original pipeline information data. Shape data is geographic spatial data stored in ESRI's Shapefile format. Shapefile is a very popular spatial data format developed by Esri for storage and exchange of spatial data in geographic information system (GIS) software.

[0023] Step S20: Identify the pipe point table and the pipeline table in the original pipeline information data, wherein the pipe point table includes key fields of several pipe points, and the pipeline table includes key fields of several pipelines.

[0024] In this embodiment, the key fields of the pipe points in the pipe point table and the key fields of the pipelines in the pipeline table both include: pipeline type, pipeline subclass, pipe diameter and pipeline material; The key fields of the control points in the control point table also include at least: point number on the map, well depth, feature point, auxiliary facilities, horizontal coordinate, vertical coordinate, ground elevation, well neck depth, well cover type, well cover specification, well cover material and angle; The key fields of the pipeline in the pipeline table also include at least: starting point number, ending point number, starting point burial depth, ending point burial depth, starting point elevation, ending point elevation, burial method, hole specification and hole diameter.

[0025] Among them, the starting point number and the ending point number in the pipeline table correspond to the points on the map in the pipe point table. The starting point number and the ending point number together represent the connection relationship of the pipeline network. The pipe point table is shown in Table 1, and the pipeline table is shown in Table 2.

[0026] Table 1 Pipeline Point Table

[0027] In Table 1, JS is water supply, 3T is tee, ZX is turning point, and PW is valve.

[0028] Table 2 Pipeline table

[0029] In this embodiment, all pipeline data information is collected in the pipeline table and the pipe point table, including various types of pipeline data information such as water supply, drainage, gas, heat, electricity and communication. The attribute information and expression form of each type of pipeline are different, and the pipeline type needs to be classified. The "type" in the pipeline table indicates the pipeline category. At the same time, the connection direction of the pipeline is determined by the starting point number and the end point number in the pipeline table; the spatial distribution of the pipeline is determined by the coordinates, ground elevation and buried depth; the attribute information of the pipeline is determined by the pipe diameter, number of holes, material and remarks, and the adaptive symbols such as tees, straight-throughs, and reducers are used in the "feature point" field in the pipe point table. The "accessory facilities" field corresponds to the model of the custom model library, such as water supply valves, fire hydrants, etc. The shape of the underground pipeline network can be obtained in this way.

[0030] In this embodiment, the method further includes: Step a10: perform information verification on the pipe point table and the pipeline table to obtain verification results, wherein the verification results include: information completeness or information abnormality; wherein the information verification includes: key field empty verification and data type abnormality or specification verification; Step a20: When the verification result is that the information is abnormal, an abnormal log is generated.

[0031] In this embodiment, by performing information verification on the pipe point table and the pipeline table, empty key fields, abnormal data types, and erroneous or non-standard data can be determined, and the empty key fields, abnormal data types, and erroneous or non-standard data are written into the exception log to facilitate finding abnormal problems in these data.

[0032] Step S30: Generate a modeling configuration file based on the key fields of the plurality of pipe points and the key fields of the plurality of pipelines.

[0033] In this embodiment, the three-dimensional pipe network scene is composed of two basic elements, namely, three-dimensional pipe segments and three-dimensional pipe points. For different elements, the automated three-dimensional modeling solution has formulated different construction schemes in the model library. First, the key fields in the pipeline table and the key fields in the pipe point table must be paired with the standard fields in the model library. Usually, the model library also has pipeline standard fields and pipe point standard fields. Similarly, the pipeline standard fields also include: pipeline type, pipeline subclass, pipe diameter and pipeline material, as well as starting point number, ending point number, starting point burial depth, end point burial depth, starting point elevation, end point elevation, burial method, hole specification and hole diameter; similarly, the pipe point standard fields also include: pipeline type, pipeline subclass, pipe diameter and pipeline material, as well as point number on the map, well depth, feature point, ancillary facilities, horizontal coordinate, vertical coordinate, ground elevation, well neck depth, manhole cover type, manhole cover specification, manhole cover material and angle, etc.

[0034] During the pairing process, the data in the pipeline table and the data in the pipe point table are mapped to the corresponding pipeline standard fields and pipe point standard fields in the model library respectively. When the pipeline field in the pipeline table does not match the pipeline standard field, for example, the pipeline field has an "x coordinate", the "x coordinate" is user-defined, and the pipeline standard field corresponding to the "x coordinate" is the "horizontal coordinate", it is necessary to manually specify the mapping relationship or use a recognition algorithm to identify the corresponding relationship between the two. The recognition algorithm can be a neural network algorithm.

[0035] In order to match the key fields in the pipeline table and the key fields in the pipe point table with the standard fields in the model library, it is necessary to build a modeling configuration file for the 3D pipe network.

[0036] The pipelines in the three-dimensional pipe network of this embodiment are modeled using three-dimensional pipe segment line symbols. Models of pipeline segments of various types of three-dimensional pipe networks are constructed by setting texture colors (such as texture, color) of different types of pipelines and specifying texture pictures; wherein the three-dimensional pipe segment line symbols are three-dimensional models used to represent characteristic symbols of pipelines. These models can be simple geometric shapes or highly complex solid models, for example: Geometric models: use basic geometric shapes (such as cubes, spheres, cylinders, etc.) to represent objects; for example: Solid models: create detailed three-dimensional models, which can include textures, materials, lighting effects, etc., to more realistically represent objects.

[0037] The pipe points in the three-dimensional pipe network of this embodiment are generally divided into three categories, including: characteristic points (elbows, tees, crosses, reducer points, etc.), wells (square wells, round wells, tapered wells, rain grates, etc.) and ancillary facilities (valves, water meters, fire hydrants, street lights, etc.); Among them, the modeling of feature points is constructed using three-dimensional adaptive pipe point symbols. The three-dimensional adaptive pipe point symbols can adaptively release the pipe points in the three-dimensional pipe according to the cross-section of the pipeline in the three-dimensional pipe network based on the topological relationship between the pipe points and the pipelines, so as to ensure the correct connection between the pipe points and the pipelines in the three-dimensional pipe network; the three-dimensional adaptive pipe point symbol refers to a symbol representation method used for pipe points in a three-dimensional GIS environment; this symbol can automatically adjust its appearance according to the scale, angle, importance of the pipe point or other contextual factors of the view to provide a clearer and more intuitive visual effect.

[0038] Among them, the well modeling adopts the collaborative construction of three-dimensional adaptive symbols and model symbols. For wells with simple geometric shapes, they can be automatically constructed parametrically according to the geometric shape, size and other information of the well. For wells with complex geometric shapes, three-dimensional model symbols are used for construction, and users can directly establish the association relationship between the well record information and the specified model in the model library.

[0039] Among them, the modeling of ancillary facilities is constructed using model symbols, and provides the function of valve adaptive pipeline connection. The valve can adaptively adjust the angle according to the direction of the pipeline to ensure that the valve switch direction is always perpendicular to the direction of the pipeline.

[0040] Specifically, based on the key fields of several pipe points and several pipelines, a modeling configuration file is generated, including: Step S301: Determine the type configuration of the pipeline according to the pipeline subclass in the pipeline table or the pipeline point table.

[0041] In this embodiment, the type of pipeline is configured by configuring the pipeline table with different colors or materials of pipelines according to the pipeline type (drainage, water supply, gas, heat, communication, electricity, etc.).

[0042] Step S302: Determine the adaptive symbol configuration of the characteristic points of the pipe points according to the characteristic points in the pipe point table; in this embodiment, the adaptive symbol configuration of the characteristic points of the pipe points is to use three-dimensional adaptive pipe point symbols for modeling.

[0043] Step S303: determining the model configuration of the ancillary facilities of the control point according to the ancillary facilities in the control point table, wherein the model configuration of the ancillary facilities of the control point is to construct a model of the ancillary facilities by using model symbols.

[0044] Step S304: when the type of ancillary facilities in the pipe point table is a well, determine the well configuration, which includes: a well model (square well, round well or conical well), a well cover material and a well chamber material. The well configuration is to collaboratively model the well using three-dimensional adaptive symbols and model symbols.

[0045] Step S305: Determine the connection direction configuration of pipelines of the same type according to the start point number and the end point number in the pipeline table.

[0046] Step S306: Determine the spatial layout configuration of each type of pipeline according to the horizontal coordinate, vertical coordinate and ground elevation in the pipeline point table and the starting point burial depth and the end point burial depth in the pipeline table.

[0047] Step S307: The pipe diameter, hole diameter and hole specification in the pipeline table or the pipeline material in the pipeline table are used to determine the attribute configuration of each type of pipeline.

[0048] Step S308: Generate a modeling configuration file based on the type configuration of pipelines, the adaptive symbol configuration of the characteristic points of pipeline points, the model configuration of the ancillary facilities of the pipeline points, the model configuration of the pipe wells of the pipeline points, the connection direction configuration of pipelines of the same type, the spatial layout configuration of each type of pipelines and the attribute configuration of each type of pipelines.

[0049] As a further optimization of this embodiment, the attribute configuration of each type of pipeline includes: the multi-hole specification configuration of each type of pipeline, that is, there is one pipe hole or multiple pipe holes (i.e., hole specifications) in a pipeline. When there are multiple pipe holes in a pipeline, it is necessary to determine the multi-hole specification configuration of each type of pipeline.

[0050] Specifically, according to the pipe diameter, hole diameter and hole specification in the pipeline table, the attribute configuration of each type of pipeline is determined, including: Step b10: extracting the hole position attributes of each pipeline from the hole specifications in the pipeline table, wherein the hole position attributes include: the number of pipe holes, arrangement mode, hole diameter and hole spacing of the pipeline; Step b20: Calculate the distance between the center points of adjacent holes of each pipeline according to the hole diameter and the hole spacing; Step b30: Generate the position coordinate information of each tube hole of each pipeline according to the number of tube holes, arrangement, hole diameter, hole spacing, tube diameter and the distance between the center points of adjacent tube holes, and use the position coordinate information of each tube hole of each pipeline as the multi-hole specification configuration of the type of pipeline.

[0051] In this embodiment, a pipeline with multiple pipe holes is called a pipe gallery. Take a pipe gallery with a hole specification of 3X3 as an example: The coordinate information of the corridor is ([x1, y1, z1], [x2, y2, z2]), where x1 is the longitude of the starting point of the corridor, y1 is the latitude of the starting point of the corridor, z1 is the elevation of the starting point of the corridor, x2 is the longitude of the end point of the corridor, y2 is the latitude of the end point of the corridor, and z2 is the elevation of the end point of the corridor. The hole specification 3X3 is converted into the location information of each pipe hole, as shown in Table 3: Table 3 Location information table

[0052] In Table 3, 1-1 represents the first tube hole in the first row from bottom to top and from left to right in the cross section, 1-2 represents the second tube hole in the first row from bottom to top and from left to right in the cross section, 1-3 represents the third tube hole in the first row from bottom to top and from left to right in the cross section; 2-1 represents the first tube hole in the second row from bottom to top and from left to right in the cross section, 2-2 represents the second tube hole in the second row from bottom to top and from left to right in the cross section, 2-3 represents the third tube hole in the second row from bottom to top and from left to right in the cross section; 3-1 represents the first tube hole in the third row from bottom to top and from left to right in the cross section, 3-2 represents the second tube hole in the third row from bottom to top and from left to right in the cross section, and 3-3 represents the third tube hole in the third row from bottom to top and from left to right in the cross section.

[0053] The slope of the tunnel on the two-dimensional plane (x, y) is k, the hole specifications of the tunnel are set to (m, n), the location information of each hole is set to (a, b), and the coefficient for converting longitude and latitude to meter units is j.

[0054] Then the coordinate offset in the X direction is: abs_x = b - Math.floor(n / 2); Math.floor() means rounding down a number, for example, Math.floor(2.3) = 2, and abs_x means how many unit hole specifications the aperture is offset from the center of the tunnel in the longitude direction; _x = distance / Math.sqrt(Math.pow(k, 2)+1) / j, distance = aperture +holeSpacing; where _x represents the distance (meters) of each unit hole specification offset in the longitude direction of the corridor with a slope of k, Math.sqrt() represents calculating the square root of a non-negative number, for example, Math.sqrt(9) = 3, Math.pow() represents calculating the specified power of a number, for example, Math.pow(3, 2) = 9; Math.pow(-2, 3) = -8; distance is the distance between the center points of adjacent pipe holes, aperture is the aperture, and holeSpacing is the hole spacing; hole_x = n % 2 === 0 ? (abs_x - 0.5) * _x : (abs_x - 1) * _x; where hole_x represents the actual coordinate offset of the aperture in the longitude direction; Then the coordinate offset in the z direction is: abs_z = a - Math.floor(m / 2); where abs_z indicates how many unit hole specifications the aperture is offset from the center of the tunnel in the z direction; _z = m % 2 === 0 ? distance * (abs_z - 0.5) : distance * (abs_z - 1); where _z represents the distance (meters) of each unit hole specification offset in the z direction. When the corridor slope does not exist, _x = 0, _y = distance / j; The final coordinate information is: [ [ x1+hole_x, y1+hole_y, z1+_z ], [ x2+hole_x, y2+hole_y, z2+_z ]], where hole_y represents the actual coordinate offset of the aperture in the latitude direction; Through the above formula, the location information of each pipe hole in the pipeline corridor can be calculated.

[0055] Step S40: Generate a modeling time configuration, and based on the modeling time configuration, import the modeling configuration file into a preset modeling program to automatically model the urban pipe network to obtain a three-dimensional pipe network GIS model.

[0056] In this embodiment, the modeling time configuration is to configure the time plan for automatic modeling (for example, by hour, day, week, month); the modeling configuration file of this embodiment can be an OBJ file or a 3dTiles file, and the modeling configuration file is stored locally.

[0057] In this embodiment, the preset modeling program can be a modeling software platform such as osgEarth, Cesium, ArcGIS, SuperMap, etc.; this embodiment realizes automatic modeling of the three-dimensional pipeline network according to the urban pipeline network data specification, osg, OpenGL, 3dTiles and other relevant specifications by importing the modeling configuration file into the preset modeling program.

[0058] The present invention processes the pipeline data of the urban pipeline network to obtain original pipeline information data including a pipe point table and a pipeline table, and then generates a modeling configuration file according to the key fields of several pipe points in the pipe point table and the key fields of several pipelines in the pipeline table; then, according to the needs of users, the periodic time plan of modeling (i.e., modeling time configuration) is flexibly configured, and the modeling configuration file is imported into the preset modeling program to realize automatic modeling of the urban pipeline network; the present invention can be seamlessly connected with different modeling software platforms (such as osgEarth, Cesium, ArcGIS, SuperMap, etc.), and has the advantages of high modeling efficiency, low labor cost and low operating cost of data update.

[0059] Therefore, the overall modeling steps of the present invention are divided into three stages, such as Figure 2 As shown, data organization, programming processing and software modeling; Among them, the data sorting stage is mainly used for: the main sources of urban pipeline network data and information are existing data and census data, which are generally of three types: paper data, drawings and electronic data. The data information contained in each type is different. In order to display all the information of the underground pipeline network as comprehensively as possible, the information contained in the above types of data is uniformly sorted and imported into the spatial database (or exported in Shape format) as the original pipeline information data. This embodiment is based on the requirements of the "Technical Regulations for Urban Underground Pipeline Detection" on the types and codes of pipelines, combined with the actual needs of automated modeling, to construct the key fields of the original pipeline information data pipe point table in the electronic database, including the point number on the map, pipeline type, pipeline subclass, well depth, pipe diameter, material, characteristics, ancillary facilities, horizontal coordinate, vertical coordinate, ground elevation, well neck depth, manhole cover type, manhole cover specification, manhole cover material, angle, and remarks. The key fields of the pipeline table include the start point number, end point number, pipeline type, pipeline subclass, start point burial depth, end point burial depth, start point elevation, end point elevation, pipeline material, burial method, pipe diameter, hole specification, hole diameter, and remarks. The start point number and end point number in the pipeline table correspond to the points on the map in the pipe point table. The start point number and end point number together represent the connection relationship of the pipeline network.

[0060] Among them, the programming processing stage is mainly used for: pipeline reading and identification, matching field configuration, hole specification judgment, and automatic modeling processing to generate OBJ files or 3dTiles files.

[0061] Spatial data contains all pipeline data information, including various types of pipeline data information such as water supply, drainage, gas, heat, electricity and communication. The attribute information and expression form of each type of pipeline are different, and the pipeline type needs to be classified. The "type" in the spatial data table represents the pipeline category. At the same time, the connection direction of the pipeline is determined by the starting point number and the end point number in the pipeline table; the spatial distribution of the pipeline is determined by the coordinates, ground elevation and buried depth; the attribute information of the pipeline is determined by the pipe diameter or number of holes, material and remarks, and the adaptive symbols such as tees, straight-throughs, and diameter reduction points are used in the "feature point" field in the pipe point table. The "appendage" field corresponds to the model of the custom model library, such as water supply valves, fire hydrants, etc. This can obtain the shape of the underground pipeline network. The specific steps include: 1) Identify the data information of each pipeline in the spatial database; 2) Determine the type of pipeline through the "Type" field in the data table; 3) Determine the type of pipeline through the "Type" field in the pipeline point table; 4) Adaptive symbols are set through the "Feature Point" field in the pipe point table, such as tees, straight-throughs, reducers, etc. The "Appendage" field corresponds to the models in the custom model library, such as water supply valves, fire hydrants, etc.

[0062] 5) Determine the connection direction of pipelines of the same type through the relationship between the starting number and the end number in the pipeline table; 6) Determine the spatial distribution of various types of pipelines through the horizontal coordinate, vertical coordinate, ground elevation and buried depth; 7) Determine the attribute information of each type of pipeline by pipe diameter or number of holes, material and remarks; 8) A special data algorithm is used to process pipelines with multiple holes. The arrangement of the detected holes is automatically calculated to generate pipeline data with multiple holes.

[0063] The configuration steps of pipelines and pipe points in this method are as follows: 1) Feature points of different types of pipelines can be assigned colors or textures.

[0064] 2) The program automatically counts the "attachment" categories in the pipe point table, and then matches the types according to these categories, or pre-configures these categories, and can specify the corresponding obj format accessory models (such as valves, fire hydrants, street lights, signal lights, signal boxes, etc.). If it is a well type, you can specify a square well, a round well, etc. You can specify the style or texture image of the manhole cover, and you can specify the material of the well, such as cement, red brick, sand and other texture materials.

[0065] 3) Different types of pipelines can be assigned colors or textures.

[0066] This method generates the following model configuration: 1) Configure the generated model type to be: OBJ file or 3dTiles file.

[0067] 2) Configure the storage address.

[0068] 3) Configure automatically generated periodic time plans, you can specify plans by hour, day of the week, time of the month, etc.

[0069] Among them, the software modeling stage is mainly used to: after the above data inspection and data processing, the data format required for modeling and the definition of modeling parameters. The program will combine the urban pipe network data specification, osg, OpenGL, 3dTiles and other related specifications to achieve pipe network modeling and finally input the model in the specified format.

[0070] The modeling effect of this embodiment is as follows: Figure 3-Figure 8 As shown, Figure 3 This is a schematic diagram of the modeling effect of the integrated pipe network. Figure 4 This is a schematic diagram of the modeling effect of the pipe hole and pipeline. Figure 5 This is a schematic diagram of the modeling effect of the tube well. Figure 6 This is a schematic diagram of the modeling effect of the ancillary facilities. Figure 7 This is a schematic diagram of the overall modeling effect of feature points; Figure 8This is a schematic diagram of the modeling effect of ancillary facilities (transformer box).

[0071] Embodiment 2 Fig. 9 is a block diagram of a device for GIS modeling of an automated three-dimensional urban pipe network provided by an embodiment of the present invention, such as Fig. 9 As shown, this embodiment provides a city pipe network automated three-dimensional pipe network GIS modeling device, which is used to implement the city pipe network automated three-dimensional pipe network GIS modeling method of embodiment 1, and the device includes: The data processing module is used to obtain the pipeline data of the urban pipeline network, pre-process the pipeline data of the urban pipeline network, and obtain the original pipeline information data; A data identification module, used to identify a pipe point table and a pipeline table in the original pipeline information data, wherein the pipe point table includes key fields of several pipe points, and the pipeline table includes key fields of several pipelines; A data configuration module, used for generating a modeling configuration file based on key fields of a plurality of pipe points and key fields of a plurality of pipelines; The model building module is used to generate a modeling time configuration. Based on the modeling time configuration, the modeling configuration file is imported into a preset modeling program to automatically model the urban pipe network and obtain a three-dimensional pipe network GIS model.

[0072] This embodiment also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the urban pipe network automated three-dimensional pipe network GIS modeling method of the first embodiment is implemented.

[0073] This embodiment also provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the urban pipe network automated three-dimensional pipe network GIS modeling method of the first embodiment is implemented.

[0074] The present invention processes the pipeline data of the urban pipeline network to obtain original pipeline information data including a pipe point table and a pipeline table, and then generates a modeling configuration file according to the key fields of several pipe points in the pipe point table and the key fields of several pipelines in the pipeline table; then, according to the needs of users, the periodic time plan of modeling (i.e., modeling time configuration) is flexibly configured, and the modeling configuration file is imported into the preset modeling program to realize automatic modeling of the urban pipeline network; the present invention can be seamlessly connected with different modeling software platforms (such as osgEarth, Cesium, ArcGIS, SuperMap, etc.), and has the advantages of high modeling efficiency, low labor cost and low operating cost of data update.

[0075] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present application may adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

[0076] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0077] The above are only embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included within the scope of the claims of the present application.

Claims

1. A method for GIS modeling of automated three-dimensional urban pipe network. It is characterized in that The method comprises: Obtain pipeline data of the urban pipeline network, pre-process the pipeline data of the urban pipeline network, and obtain original pipeline information data; Identify a pipe point table and a pipeline table in the original pipeline information data, wherein the pipe point table includes key fields of several pipe points, and the pipeline table includes key fields of several pipelines; Generate a modeling configuration file based on the key fields of several pipe points and the key fields of several pipelines; Generate a modeling time configuration, and based on the modeling time configuration, import the modeling configuration file into a preset modeling program to automatically model the urban pipe network to obtain a three-dimensional pipe network GIS model.

2. The urban pipe network automation three-dimensional pipe network GIS modeling method according to claim 1, It is characterized in that The key fields of the pipe points in the pipe point table and the key fields of the pipelines in the pipeline table both include: pipeline type, pipeline subclass, pipe diameter and pipeline material; The key fields of the control points in the control point table also include at least: point number on the map, well depth, feature point, auxiliary facilities, horizontal coordinate, vertical coordinate, ground elevation, well neck depth, well cover type, well cover specification, well cover material and angle; The key fields of the pipeline in the pipeline table also include at least: starting point number, ending point number, starting point burial depth, ending point burial depth, starting point elevation, ending point elevation, burial method, hole specification and hole diameter.

3. The urban pipe network automation three-dimensional pipe network GIS modeling method according to claim 2, It is characterized in that Based on the key fields of several pipe points and several pipelines, a modeling configuration file is generated, including: Determine the type configuration of the pipeline according to the pipeline subclass in the pipeline table or pipeline point table; Determine adaptive symbol configuration of characteristic points of pipe points according to characteristic points in the pipe point table; According to the ancillary facilities in the control point table, determine the model configuration of the ancillary facilities of the control point; When the type of the auxiliary facility in the pipe point table is a well, determine the well configuration, wherein the well configuration includes: a well model, a well cover material, and a well chamber material; Determine the connection direction configuration of pipelines of the same type according to the start point number and end point number in the pipeline table; Determine the spatial layout configuration of each type of pipeline according to the horizontal coordinate, vertical coordinate and ground elevation in the pipeline point table and the starting point burial depth and terminal burial depth in the pipeline table; The pipe diameter, hole diameter and hole specification in the pipeline table or the pipeline material in the pipeline table determine the attribute configuration of each type of pipeline; A modeling configuration file is generated based on the pipeline type configuration, the adaptive symbol configuration of the characteristic points of the pipeline point, the model configuration of the ancillary facilities of the pipeline point, the well configuration when the type of the ancillary facilities of the pipeline point is a well, the connection direction configuration of the same type of pipelines, the spatial layout configuration of each type of pipelines and the attribute configuration of each type of pipelines.

4. The urban pipe network automation three-dimensional pipe network GIS modeling method according to claim 3, It is characterized in that The model configuration of the auxiliary facilities of the pipe point is to use model symbols to build the model of the auxiliary facilities, and the well model uses three-dimensional adaptive symbols and model symbols to collaboratively build the well model.

5. The urban pipe network automation three-dimensional pipe network GIS modeling method according to claim 3, It is characterized in that The attribute configuration of each type of pipeline includes: the configuration of the multi-hole specifications of each type of pipeline; According to the pipe diameter, hole diameter and hole specifications in the pipeline table, determine the attribute configuration of each type of pipeline, including: Extract the hole position attributes of each pipeline from the hole specifications in the pipeline table, wherein the hole position attributes include: the number of pipe holes, arrangement mode, hole diameter and hole spacing of the pipeline; According to the hole diameter and hole spacing, calculate the distance between the center points of adjacent holes of each pipeline; According to the number of tube holes, arrangement, hole diameter, hole spacing, tube diameter and the distance between the center points of adjacent tube holes, the position coordinate information of each tube hole of each pipeline is generated, and the position coordinate information of each tube hole of each pipeline is used as the multi-hole specification configuration of the type pipeline.

6. The urban pipe network automation three-dimensional pipe network GIS modeling method according to claim 1, It is characterized in that The method further comprises: Perform information verification on the pipe point table and the pipeline table to obtain verification results, wherein the verification results include: information completeness or information abnormality; wherein the information verification includes: key field empty verification and data type abnormality or specification verification; When the verification result is abnormal information, an abnormal log is generated.

7. The urban pipe network automation three-dimensional pipe network GIS modeling method according to claim 1, It is characterized in that Preprocessing the pipeline data of the urban pipeline network includes: importing the pipeline data of the urban pipeline network into a spatial database to obtain pipeline spatial data, and using the pipeline spatial data as original pipeline information data; Or convert the pipeline data of the urban pipeline network into Shape data, and use the Shape data as the original pipeline information data.

8. A device for GIS modeling of an automated three-dimensional urban pipe network, the device being used to implement the method for GIS modeling of an automated three-dimensional urban pipe network as claimed in any one of claims 1 to 7, It is characterized in that The device comprises: The data processing module is used to obtain the pipeline data of the urban pipeline network, pre-process the pipeline data of the urban pipeline network, and obtain the original pipeline information data; A data identification module, used to identify a pipe point table and a pipeline table in the original pipeline information data, wherein the pipe point table includes key fields of several pipe points, and the pipeline table includes key fields of several pipelines; A data configuration module, used for generating a modeling configuration file based on key fields of a plurality of pipe points and key fields of a plurality of pipelines; The model building module is used to generate a modeling time configuration. Based on the modeling time configuration, the modeling configuration file is imported into a preset modeling program to automatically model the urban pipe network and obtain a three-dimensional pipe network GIS model.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, It is characterized in that When the processor executes the computer program, the urban pipe network automated three-dimensional pipe network GIS modeling method described in any one of claims 1-7 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, It is characterized in that When the program is executed by a processor, the urban pipe network automated three-dimensional pipe network GIS modeling method described in any one of claims 1 to 7 is implemented.

Images