An automatic construction method for an urban underground schematic pipeline model based on rule constraints
Through the automatic construction method of urban underground schematic pipeline model based on rule constraints, the characteristics of underground pipelines are extracted and mapped, and the problem of restricted information sharing and utilization in the existing technology is solved, and the effective sharing and utilization of information is realized, while meeting the information confidentiality requirements.
Patent Information
- Application Number
- CN202510187037.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-02-20
- Publication Date
- 2025-06-13
- Estimated Expiration
- 2045-02-20
AI Technical Summary
It is difficult for the prior art to reasonably apply underground pipeline information resources without leaking secrets, resulting in restricted information sharing and utilization.
The automatic construction method of urban underground schematic pipeline model based on rule constraints is adopted. By acquiring and preprocessing road data and underground pipeline data, the geometric and attribute characteristics of underground pipelines are extracted, the schematic pipeline network topology is constructed, and the real attributes are mapped onto the schematic pipeline model to realize information sharing and utilization.
It has achieved rational application of underground pipeline information resources without leaking secrets, improved the efficiency of information sharing and utilization, met the requirements of information confidentiality, and adapted to the needs of urban social and economic development.
Smart Images

Figure CN119691949B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of infrastructure construction, and particularly to an automatic construction method for an urban underground schematic pipeline model based on rule constraints. Background Art
[0002] Underground pipelines are an important part of underground infrastructure. They are responsible for the important tasks of transporting energy, transmitting substances, and conveying information. They are the material basis for the survival and development of cities and are known as the "lifelines" of cities.
[0003] Currently, urban construction is changing with each passing day, including new district construction, old city renovation, road reconstruction and expansion, continuous laying of new pipelines, continuous renovation of old pipelines, etc. On the one hand, there are requirements for the confidentiality of underground pipeline information, and on the other hand, there is an urgent need to utilize underground pipeline information. There is a strong contradiction between the two. The confidentiality requirements of underground pipelines have become the biggest bottleneck for the sharing of pipeline information resources. Facing the contradictions between confidentiality and utilization, self-use and sharing, how to achieve maximum information sharing and convenient utilization without compromising confidentiality is an urgent problem to be solved currently.
[0004] Currently, for the problem of how to reasonably apply underground pipeline information resources without compromising confidentiality in related technologies, no effective solution has been proposed. Summary of the Invention
[0005] The embodiments of the present application provide an automatic construction method and system for an urban underground schematic pipeline model based on rule constraints to at least solve the problem of how to reasonably apply underground pipeline information resources without compromising confidentiality in related technologies.
[0006] In a first aspect, the embodiments of the present application provide an automatic construction method for an urban underground schematic pipeline model based on rule constraints, and the method includes:
[0007] Obtain the road data of the traffic roads in a preset area and the corresponding underground pipeline data;
[0008] Preprocess the road data to reduce interference factors affecting the extraction of underground pipeline features, and obtain the preprocessed road data;
[0009] Based on the preprocessed road data, extract the features of the underground pipeline data to obtain the geometric features and attribute features of the underground pipeline;
[0010] Based on the road data and the geometric features of the underground pipeline, construct a schematic pipeline network topology to obtain the schematic pipeline model of the underground pipeline;
[0011] Based on the road data and the attribute characteristics of the underground pipelines, map the true attributes of the underground pipelines onto the schematic pipeline model to obtain a schematic pipeline model that can reflect the true attributes but does not contain the true attributes.
[0012] In some embodiments, preprocess the road data to reduce the interference factors affecting the extraction of underground pipeline features, and the preprocessed road data obtained includes:
[0013] From the road data of the traffic road, screen out the road data of elevated roads and tunnels, and delete the road data of elevated roads and tunnels from the road data of the traffic road to obtain the road data after deletion processing;
[0014] Perform preprocessing of grid cell subdivision on the road data after deletion processing to obtain the preprocessed road data.
[0015] In some embodiments, perform preprocessing of grid cell subdivision on the road data after deletion processing, and the preprocessed road data obtained includes:
[0016] Based on the road data after deletion processing, break the corresponding traffic road at intersections to obtain the road data corresponding to several road segments;
[0017] Then, according to the preset subdivision granularity Δ, each of the road segments l ={ p 1 ( x 1 , y 2 ), p 2 ( x 2 , y 2 )} is broken into N sub-segments of road segments to obtain the road data of each sub-segment of the road segment after preprocessing, where p 1 ( x 1 , y 2 ) is the starting coordinate of the road segment, p 2 ( x 2 , y 2 ) is the ending coordinate of the road segment.
[0018] In some embodiments, based on the preprocessed road data, extract the features of the underground pipeline data, and the geometric features of the underground pipeline obtained include:
[0019] The geometric features of underground pipelines include trend features, distribution features, burial depth features, distance features, and connectivity features;
[0020] Based on the preprocessed road data and the underground pipeline data, through the trend feature of the underground pipeline is calculated θ , where n p is the trend vector of the sub-segment of the road section, n q is the trend vector of the underground pipeline;
[0021] Based on the preprocessed road data and the underground pipeline data, the distribution feature of the underground pipeline under the sub-segment of the road section is determined λ ={0, 1, 2, 3}, where λ =0 indicates that there is no underground pipeline under the sub-segment of the road section, λ =1 indicates that the underground pipeline is distributed on the left side of the road center line of the sub-segment of the road section, λ =2 indicates that the underground pipeline is distributed on the right side of the road center line of the sub-segment of the road section, λ =3 indicates that the underground pipeline is distributed on both sides of the road center line of the sub-segment of the road section; Based on the preprocessed road data and the underground pipeline data, through the burial depth feature of the underground pipeline is calculated η , where L i is the length of the i th underground pipeline under the sub-segment of the road section, η i is the burial depth of the i th underground pipeline under the sub-segment of the road section;
[0022] Based on the preprocessed road data and the underground pipeline data, through the distance feature of the underground pipeline is calculated , where L i is the length of the i th underground pipeline under the sub-segment of the road section, is the distance of the i th underground pipeline from the road center line under the sub-segment of the road section;
[0023] Based on the preprocessed road data and the underground pipeline data, record the connectivity relationship between the underground pipelines under each sub-segment of the road section and the underground pipelines under other sub-segments of the road section, as the connectivity feature of the underground pipeline.
[0024] In some of these embodiments, based on the road data and the geometric features of the underground pipelines, a schematic pipeline network topology is constructed to obtain the schematic pipeline model of the underground pipelines, including:
[0025] Based on the road data and the trend features of the underground pipelines θ , distribution features λ , burial depth features η and distance features , the consistency of the pipeline burial depth and the distance between the pipeline and the center line of the road is processed separately for the underground pipelines under the sub - road sections of the originally connected road sections;
[0026] Based on the connectivity features of the underground pipelines, adjacent pipe segments of the underground pipelines that have completed the consistency processing are connected to obtain the schematic pipeline model of the underground pipelines.
[0027] In some of these embodiments, based on the pre - processed road data, attribute features of the underground pipeline data are extracted, and the obtained attribute features of the underground pipelines include:
[0028] Based on the pre - processed road data, feature extraction is performed on the underground pipeline data to obtain the attribute features of the underground pipelines. Among them, the attribute features include section pipe diameter features, section pipe age features, section pipe material features, section pipeline length features, section pipeline burial depth features, section manhole quantity features, and section rainwater grate quantity features.
[0029] In some of these embodiments, based on the road data and the attribute features of the underground pipelines, the real attributes of the underground pipelines are mapped onto the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not contain the real attributes, including:
[0030] Based on the road data and the attribute features of the underground pipelines, statistical analysis is performed on the underground pipelines under each road section to obtain an overall attribute profile of all the underground pipelines under the road section;
[0031] The real attribute information of the underground pipelines is mapped onto the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not contain the real attributes.
[0032] In some of these embodiments, before performing feature extraction on the underground pipeline data based on the pre - processed road data to obtain the geometric features and attribute features of the underground pipelines, the method includes:
[0033] Based on the laying rules of the underground pipelines within the preset area, the underground pipeline data of branch pipelines and household - entry pipelines are removed from the obtained underground pipeline data to obtain the removed underground pipeline data.
[0034] In some of these embodiments, after the schematic pipeline model is generated by simulation, the method further includes:
[0035] Manually inspect and repair the pipeline connectivity under complex road conditions in the schematic pipeline model, where the manual inspection and repair includes inspection and repair of distribution integrity, inspection and repair of correct alignment, inspection and repair of authenticity of topological relationships, and inspection and repair of correctness of attribute fusion.
[0036] In a second aspect, an embodiment of the present application provides an automatic construction system for an urban underground schematic pipeline model based on rule constraints. The system is used to execute the method described in the first aspect above. The system includes an acquisition module, a preprocessing module, and an automatic construction module;
[0037] The acquisition module is configured to acquire road data of traffic roads within a preset area and corresponding underground pipeline data;
[0038] The preprocessing module is configured to preprocess the road data to reduce interference factors affecting the extraction of underground pipeline features, and obtain preprocessed road data;
[0039] The automatic construction module is configured to extract features from the underground pipeline data according to the preprocessed road data to obtain geometric features and attribute features of the underground pipeline; construct a schematic pipeline network topology according to the road data and the geometric features of the underground pipeline to obtain a schematic pipeline model of the underground pipeline; map the real attributes of the underground pipeline to the schematic pipeline model according to the road data and the attribute features of the underground pipeline to obtain a schematic pipeline model that can reflect the real attributes but does not include the real attributes.
[0040] Compared with the related art, an automatic construction method and system for an underground schematic pipeline model based on rule constraints provided by an embodiment of the present application. Among them, the method includes obtaining road data and corresponding underground pipeline data of a preset area in a traffic road; preprocessing the road data to reduce interference factors affecting the extraction of underground pipeline features, obtaining preprocessed road data; based on the preprocessed road data, extracting features of the underground pipeline data to obtain geometric features and attribute features of the underground pipeline; based on the geometric features of the road data and the underground pipeline, constructing a schematic pipeline network topology to obtain a schematic pipeline model of the underground pipeline; based on the attribute features of the road data and the underground pipeline, mapping the real attributes of the underground pipeline onto the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not contain the real attributes, realizing the preprocessing of the road data based on grid element subdivision to improve the construction accuracy of the subsequent schematic pipeline model of the underground pipeline, separately extracting the attribute features of the underground pipeline with high sensitivity, and hiding the real attributes of the underground pipeline in the construction of the schematic pipeline model, meeting the information confidentiality requirements, and solving the problem of how to reasonably apply underground pipeline information resources without disclosing secrets. BRIEF DESCRIPTION OF THE DRAWINGS
[0041] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The schematic embodiments and descriptions thereof of the present application are used to explain the present application and do not constitute an improper limitation to the present application. In the drawings:
[0042] Figure 1 is a flowchart of the steps of the automatic construction method of the underground schematic pipeline model according to an embodiment of the present application;
[0043] Figure 2 is a schematic flowchart of the automatic construction method of the underground schematic pipeline model according to an embodiment of the present application;
[0044] Figure 3 is a schematic diagram of the schematic pipeline model simulated and generated according to an embodiment of the present application;
[0045] Figure 4 is a schematic diagram of the internal structure of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0046] In order to make the objectives, technical solutions and advantages of the present application clearer, the present application will be described and explained below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application. Based on the embodiments provided by the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the scope of protection of the present application.
[0047] Obviously, the accompanying drawings in the following description are only some examples or embodiments of the present application. For those of ordinary skill in the art, without creative efforts, the present application can also be applied to other similar scenarios based on these drawings. In addition, it can also be understood that although the efforts made in such a development process may be complex and lengthy, for those of ordinary skill in the art related to the content disclosed in the present application, some design, manufacturing, or production changes based on the technical content disclosed in the present application are only conventional technical means and should not be understood as the content disclosed in the present application being insufficient.
[0048] The mention of "embodiment" in the present application means that the specific features, structures, or characteristics described in connection with the embodiment can be included in at least one embodiment of the present application. The appearance of this phrase at various positions in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment mutually exclusive with other embodiments. Those of ordinary skill in the art explicitly and implicitly understand that the embodiments described in the present application can be combined with other embodiments without conflict.
[0049] Unless otherwise defined, the technical terms or scientific terms involved in the present application should be the ordinary meanings understood by those of ordinary skill in the technical field to which the present application belongs. The similar words such as "a", "an", "one kind", "the", etc. involved in the present application do not represent a quantity limitation and can represent a singular or plural number. The terms "including", "comprising", "having" and any variations thereof involved in the present application are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or device including a series of steps or modules (units) is not limited to the listed steps or units, but may further include unlisted steps or units, or may further include other steps or units inherent to these processes, methods, products, or devices. The similar words such as "connected", "coupled", etc. involved in the present application are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. The "plurality" involved in the present application refers to two or more. "And / or" describes the association relationship of associated objects and indicates that three relationships can exist. For example, "A and / or B" can represent: A exists alone, A and B exist simultaneously, and B exists alone. The character " / " generally represents an "or" relationship between the associated objects before and after. The terms "first", "second", "third", etc. involved in the present application are only used to distinguish similar objects and do not represent a specific order for the objects.
[0050] The embodiment of the present application provides an automatic construction method for an urban underground schematic pipeline model based on rule constraints. Figure 1 It is a flowchart of the steps of the automatic construction method for the underground schematic pipeline model according to the embodiment of the present application, asFigure 1 As shown in Figure 1 , the method includes the following steps:
[0051] Step S102: Obtain the road data of the traffic roads within the preset area and the corresponding underground pipeline data;
[0052] Step S104: Preprocess the road data to reduce the interference factors affecting the extraction of underground pipeline features, and obtain the preprocessed road data;
[0053] Step S104 specifically includes the following steps:
[0054] Step S1041: Screen out the road data of elevated roads and tunnels from the road data of the traffic roads, and delete the road data of elevated roads and tunnels from the road data of the traffic roads to obtain the road data after deletion processing;
[0055] Step S1042: Perform preprocessing of grid cell subdivision on the road data after deletion processing to obtain the preprocessed road data.
[0056] Specifically, in Step S1042, based on the road data after deletion processing, break the corresponding traffic roads at intersections to obtain the road data corresponding to several road segments;
[0057] Then, break each road segment l ={ p 1 ( x 1 , y 2 ), p 2 ( x 2 , y 2 )} into N sub-road segments of road segments to obtain the road data of each sub-road segment of the road segment after preprocessing, where, p 1 ( x 1 , y 2 ) is the starting coordinate of the road segment, p 2 ( x 2 , y 2 ) is the ending coordinate of the road segment.
[0058] In some preferred embodiments, for Step S104, Figure 2 is a schematic flow diagram of the automatic construction method of the underground schematic pipeline model according to the embodiment of the present application, as shown in Figure 2As shown in the figure, the underground schematic pipeline model of the underground pipeline is automatically simulated and constructed, and the influence of interference factors on the pipeline simulation should be reduced, that is, the underground pipeline data and road data should be preprocessed, and the underground pipeline laying principles should be formulated. Among them, the preprocessing steps of the road data are as follows:
[0059] ① Based on the road attributes, filter out all elevated and tunnel data and delete them from the original data.
[0060] ② In order to ensure the accuracy of the simulation, the road data is subdivided according to the granularity, as follows:
[0061] (1) Break along intersections: Using spatial geometric calculation methods, each road is broken into multiple sections at the intersections;
[0062] (2) For each road segment in (1), l ={ p 1 ( x 1 , y 2 ), p 2 ( x 2 , y 2 )}Further break N segments according to the preset subdivision granularity Δ, where: ;
[0063] (3) Based on the road width information in the road data, the interrupted road section is expanded into a road surface, which serves as the minimum cell for subsequent schematic pipeline feature extraction and simulation.
[0064] The steps for preprocessing underground pipeline data are as follows:
[0065] ③ Based on the laying rules of underground pipelines in the preset area, the simulation constraint rules for the schematic pipeline model of the underground pipeline are obtained. It should be noted that, for example, GB50289-2016 "Urban Engineering Pipeline Comprehensive Planning Specifications" can be referred to, combined with the relevant road construction section drawings of typical main and secondary roads with a length of 16-60 meters in Hangzhou, analysis and law extraction can be carried out to form basic simulation constraint rules.
[0066] ④ Filter out the primary and secondary pipeline networks and the transmission and distribution pipeline networks from the acquired underground pipeline data, and eliminate the underground pipeline data of branch pipelines and household pipelines to obtain the filtered and eliminated underground pipeline data.
[0067] Step S106, based on the pre-processed road data, feature extraction is performed on the underground pipeline data to obtain geometric features and attribute features of the underground pipeline;
[0068] Extract the geometric features of the underground pipelines in step S106, where the geometric features include the trend feature, distribution feature, burial depth feature, distance feature, and connectivity feature. The specific extraction process includes the following steps:
[0069] Step S1061: Based on the preprocessed road data and underground pipeline data, calculate the trend feature of the underground pipelines where θ , n p is the trend vector of the sub-segment of the road section, n q is the trend vector of the underground pipeline;
[0070] Step S1062: Based on the preprocessed road data and underground pipeline data, determine the distribution feature of the underground pipelines under the sub-segment of the road section λ ={0, 1, 2, 3}, where λ =0 indicates that there are no underground pipelines under the sub-segment of the road section, λ =1 indicates that the underground pipelines are distributed on the left side of the road center line of the sub-segment of the road section, λ =2 indicates that the underground pipelines are distributed on the right side of the road center line of the sub-segment of the road section, λ =3 indicates that the underground pipelines are distributed on both sides of the road center line of the sub-segment of the road section.
[0071] Step S1063: Based on the preprocessed road data and underground pipeline data, calculate the burial depth feature of the underground pipelines where η , L i is the length of the i th underground pipeline under the sub-segment of the road section, η i is the burial depth of the i th underground pipeline under the sub-segment of the road section;
[0072] Step S1064: Based on the preprocessed road data and underground pipeline data, calculate the distance feature of the underground pipelines where , L i is the length of the i th underground pipeline under the sub-segment of the road section, is the distance of the i th underground pipeline from the road center line under the sub-segment of the road section;
[0073] Step S1065: Based on the preprocessed road data and underground pipeline data, record the connection relationship between the underground pipelines under each sub-section of a road section and the underground pipelines under other road section sub-sections, so as to serve as the connection characteristics of the underground pipelines.
[0074] In some preferred embodiments, for extracting the geometric features of the underground pipelines in step S106, in combination with the overlay of all road data, calculate the underground pipeline data, and extract the geometric features of each underground pipeline under the road, specifically as follows:
[0075] ① Extraction of trend features: For each pipeline under the road, calculate the direction vector of the section n p , calculate the direction vector of the pipeline n q , and extract the trend feature of the pipeline , that is n p and n q the included angle between.
[0076] ② Extraction of distribution features: According to the width of the road surface, judge the distribution features of each pipeline under the section - the distribution position and quantity of the pipeline under the section, that is, the distribution feature λ ={0, 1, 2, 3}, where 0 means there is no pipeline under the section, 1 means the pipeline is distributed on the left side of the road center line, 2 means the pipeline is distributed on the right side of the road center line, and 3 means the pipeline is distributed on both sides of the road center line.
[0077] ③ Extraction of burial depth features: For the underground pipelines under each section, calculate the overall weighted burial depth of the pipelines under the section by weighted averaging the burial depth according to the length , where L i is the length of the i th underground pipeline under the sub-section of the road section, η i is the burial depth of the i th underground pipeline under the sub-section of the road section.
[0078] ④ Distance of the pipeline from the road center line: Extract the distance from the center point of each pipeline under the section to the center line of the section, and obtain the distance of the pipeline from the road center line by weighted averaging the distance according to the length , where L i is the length of the i th underground pipeline under the sub-section of the road section, is the distance from the center line of the road of the i th underground pipeline under the sub-section of the road section.
[0079] ⑤Connected feature extraction: For each road section, record the connection relationship between the pipelines under this road section and the pipelines under other road sections, which serves as the basis for simulating the connectivity of the subsequent schematic pipeline model. The specific recording method is as follows: If a certain road section is connected to other road sections and the pipelines under the road sections are also connected to each other, then the numbers of all road sections that meet the conditions should be recorded in this road section.
[0080] In some preferred embodiments, for extracting the attribute features of the underground pipelines in step S106, where the attribute features include:
[0081] Road section pipe diameter feature - Extract the maximum, minimum pipe diameters of all pipelines under the road section, and the two most representative pipe diameters, namely the mode and the second mode of the pipe diameters;
[0082] Road section pipe age feature - Extract the maximum, minimum pipe ages of all pipelines under the road section, and the two most representative pipe ages, namely the mode and the second mode of the pipe ages;
[0083] Road section pipe material feature - Extract the two most representative pipe materials under the road section, namely the mode and the second mode of the pipe materials;
[0084] Road section pipeline length feature - Extract the total length of all pipelines under the road section;
[0085] Road section pipeline burial depth feature - Extract the average burial depth of all pipelines under the road section;
[0086] Road section manhole number feature - Extract the number of all manholes on the road section surface;
[0087] Road section rainwater grate number feature - Extract the number of all rainwater grates on the road section surface.
[0088] Step S108: Based on the road data and the geometric features of the underground pipelines, construct the topology of the schematic pipeline network to obtain the schematic pipeline model of the underground pipelines;
[0089] Step S108 specifically includes the following steps:
[0090] Step S1081: Based on the road data and the alignment features θ , distribution features λ , burial depth features η and distance features of the underground pipelines, perform consistency processing on the burial depth of the underground pipelines and the distance from the pipeline to the center line of the road for the underground pipelines under the sub-road sections of the originally connected road sections respectively;
[0091] Step S1082: Based on the connectivity features of the underground pipelines, connect the adjacent pipe segments of the underground pipelines that have completed the consistency processing to obtain the schematic pipeline model of the underground pipelines.
[0092] In some of these preferred embodiments, for step S108, based on the extracted pipeline geometric features and attribute features, on the basis of the road centerline, relevant parameters required for simulating the schematic pipeline model are calculated, and the pipelines under the road are simulated using the road centerline. In order to keep the pipelines under the connected sections interconnected and avoid misalignment problems, further processing is also required for the extracted pipeline burial depth and the average distance from the pipeline center point to the road centerline. In other words, according to the above extraction rules, only one burial depth feature is extracted for each section. The pipelines under the same section have a starting point and an ending point, and these two points may coincide with the ending point or starting point of the adjacent section. Since the average burial depth of the pipelines under each section is calculated separately, the burial depths of the same vertex calculated under adjacent sections may be inconsistent, resulting in the problem that the simulated pipelines are not connected. In order to maintain the consistency of connectivity, for the pipeline burial depth feature η the following processing is performed: ① Let section R a ={ p a,1 , p a,2} be adjacent to section R b ={ p b,1 , p b,2}, and the pipelines below are interconnected, η a and η b are the average burial depths of the pipelines under the two sections respectively;
[0093] ② Let the burial depths of vertices p a,1 and p a,2 be η a , p b,1 and p b,2 be η b ;
[0094] ③ Assume that p a,2 coincides with p b,1 , that is, the two correspond to the same vertex, then their burial depths should be consistent with each other, and the average value of their burial depths is taken as the burial depth for simulation, that is .
[0095] ④For the treatment of multiple connected road sections, the same methods as ①②③ are adopted. Just take the average of the burial depths of adjacent vertices to obtain consistent burial depth parameters.
[0096] For the distance feature (the distance between the pipeline and the center line of the road) also needs to be processed for consistency. The specific method is as follows:
[0097] ⑤Make the starting and ending points of the pipeline under each road section coincide with the starting and ending points of the road section;
[0098] ⑥Assign the extracted pipeline distance feature to the starting and ending points of the pipeline;
[0099] ⑦Average the offset values of all pipelines connected to the starting point of the pipeline as the simulated offset value of this point;
[0100] ⑧Average the offset values of all pipelines connected to the ending point of the pipeline as the simulated offset value of this point.
[0101] It should be noted that after processing the burial depth feature η and the distance feature for consistency in the above manner, the pipelines under the road section can be simulated according to the extracted features. As Figure 2 shown, based on the laying rules of underground pipelines in the preset area, during the simulation process, the connection of adjacent pipe segments can be automatically completed according to the connectivity features of underground pipelines, and a schematic pipeline model is generated. Among them, since the road sections will be divided into relatively fragmented parts during the process of segment subdivision, which will affect the subsequent application of the schematic pipeline. Therefore, after generating the corresponding schematic pipeline according to the extracted parameters, the pipelines under the same road will be merged to avoid the problem of multiple pipelines corresponding to one road, which will interfere with the subsequent attachment of attribute features.
[0102] Step S110, based on the road data and the attribute features of underground pipelines, map the real attributes of underground pipelines onto the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not contain the real attributes. Figure 3 is a schematic diagram of the schematic pipeline model simulated according to the embodiment of the present application.
[0103] Step S110 specifically includes the following steps:
[0104] Step S1101, based on the road data and the attribute features of underground pipelines, conduct statistical analysis on the underground pipelines under each road section to obtain the real attributes of all underground pipelines under the road section;
[0105] Step S1102, map the real attribute information of underground pipelines onto the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not contain the real attributes.
[0106] In some of these preferred embodiments, for step S110, the attachment of the schematic pipeline model and the attribute information is mainly achieved by spatial calculation and unified coding to establish the mapping relationship between the real pipeline and the schematic pipeline. Statistical analysis is performed on the attributes of the real pipeline, and the calculation results are stored as attributes in the corresponding schematic pipeline, so as to reflect the overall attribute profile of the pipelines under each road. The steps are as follows:
[0107] ① The statistics of real attributes is a qualitative description of the pipelines under a road section. Based on the attribute characteristics of the pipelines under the section, statistical analysis is performed on the pipelines under the section to reflect the overall state of the pipeline distribution in each section, specifically including:
[0108] Pipeline length - the pipeline length of this pipe type under the schematic pipeline section (the same below);
[0109] Average burial depth - the average burial depth of this pipeline;
[0110] Representative pipe material - the mode (taking the first 1 - 2 digits) of the pipe materials of this pipe type;
[0111] Representative pipe diameter - the mode (taking the first 1 - 2 digits) of the pipe diameters of this pipe type;
[0112] Representative pipe age - the mode (taking the first 1 - 2 digits) of the pipe ages of this pipe type;
[0113] Maximum pipe diameter - the maximum pipe diameter under the section;
[0114] Minimum pipe diameter - the minimum pipe diameter under the section;
[0115] Maximum pipe age - the maximum pipe age under the section;
[0116] Minimum pipe age - the minimum pipe age under the section;
[0117] Manhole quantity - the quantity of all manholes on the section surface;
[0118] Rainwater grate quantity - the quantity of all rainwater grates on the section surface.
[0119] ② The schematic pipelines in the schematic pipeline model do not carry any attribute information. To meet the application requirements, it is necessary to map the real attributes of the underground pipelines to the simulated pipelines. Specifically, in the attribute mapping between the real underground pipelines and the schematic pipelines, a technology based on spatial location is used. Taking the road as the carrier, the attributes of the road and the real pipelines under the road are first integrated, and then the road data with the real pipeline attributes is mapped to the simulated pipelines.
[0120] In some of these preferred embodiments, further, in step S110, after the schematic pipeline model is simulated and generated, the connections of the pipelines at some intersections are relatively complex, and certain connection problems may occur after automated processing. Therefore, after automated processing, manual inspection and repair of the pipeline connectivity under complex road conditions such as road intersections are carried out to ensure that the connectivity of the schematic pipelines is consistent with that of the actual pipelines. The specific inspection and repair are as follows:
[0121] ① Distribution integrity: Check whether the distribution range of the simulated pipelines is consistent with that of the actual pipelines and whether there are any omissions. For the missing parts, feedback and supplementation are required.
[0122] ② Alignment correctness: The correctness inspection mainly focuses on whether the simulated relationship reflects the alignment and distribution of the actual pipelines. For the simulated errors, feedback and correction are required.
[0123] ③ Topological relationship authenticity: The connection relationship and network topology of the schematic pipelines should be consistent with those of the actual pipelines. For the inconsistent parts, feedback and correction are required.
[0124] ④ Attribute fusion correctness: The attributes of the schematic pipelines, including the statistical attributes attached and the mapped real information, need to be inspected separately. First, ensure that there is no confidential information in the content of the schematic pipelines and their attached information. Second, check whether the statistical values and mapping relationships are correct. For the incorrect information fusion, feedback and correction are required.
[0125] Through the above application embodiments, the preprocessing of road data is realized to improve the construction accuracy of the subsequent schematic pipeline model of underground pipelines, separately extract the attribute features of underground pipelines with high sensitivity, hide the real attributes of underground pipelines in the construction of the schematic pipeline model, meet the information confidentiality requirements, and solve the problem of how to reasonably apply underground pipeline information resources without disclosing secrets. It can effectively solve the contradiction between the confidentiality and utilization of underground pipelines, enable the management of urban underground pipelines to adapt to the utilization needs of urban social and economic development, and is of great significance for ensuring the sustainable development of the city, improving the comprehensive carrying capacity and safe operation level of underground pipelines.
[0126] It should be noted that the steps shown in the above process or the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions. And although the logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in a different order than here.
[0127] The embodiments of the present application provide an automatic construction system for an urban underground schematic pipeline model based on rule constraints. The system includes an acquisition module, a preprocessing module, and an automatic construction module;
[0128] An acquisition module, configured to acquire road data of traffic roads within a preset area and corresponding underground pipeline data;
[0129] A preprocessing module, configured to preprocess the road data to reduce interference factors affecting the extraction of underground pipeline features, and obtain the preprocessed road data;
[0130] An automatic construction module, configured to extract features of the underground pipeline data based on the preprocessed road data, and obtain geometric features and attribute features of the underground pipeline; construct a schematic pipeline network topology based on the road data and the geometric features of the underground pipeline, and obtain a schematic pipeline model of the underground pipeline; map the real attributes of the underground pipeline to the schematic pipeline model according to the road data and the attribute features of the underground pipeline, and obtain a schematic pipeline model that can reflect the real attributes but does not contain the real attributes.
[0131] Through the acquisition module, preprocessing module, and automatic construction module in the embodiments of the present application, the preprocessing of road data is realized to improve the construction accuracy of the subsequent schematic pipeline model of the underground pipeline, separately extract the attribute features of the underground pipeline with high sensitivity, and hide the real attributes of the underground pipeline in the construction of the schematic pipeline model, meeting the information confidentiality requirements, and solving the problem of how to reasonably apply the underground pipeline information resources without disclosing secrets. It can effectively solve the contradiction between the confidentiality and utilization of underground pipelines, enable the management of urban underground pipelines to adapt to the utilization needs of urban social and economic development, and is of great significance for ensuring the sustainable development of the city, improving the comprehensive bearing capacity and safe operation level of underground pipelines.
[0132] It should be noted that the above-mentioned various modules can be functional modules or program modules, and can be implemented either by software or by hardware. For the modules implemented by hardware, the above-mentioned various modules can be located in the same processor; or the above-mentioned various modules can also be located in different processors in any combination form.
[0133] This embodiment also provides an electronic device, including a memory and a processor. A computer program is stored in the memory, and the processor is configured to run the computer program to execute the steps in any one of the above method embodiments.
[0134] Optionally, the above-mentioned electronic device may further include a transmission device and an input / output device, wherein the transmission device is connected to the above-mentioned processor, and the input / output device is connected to the above-mentioned processor.
[0135] It should be noted that the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and will not be repeated here.
[0136] In addition, in combination with the method for automatically constructing a schematic pipeline model in the above embodiments, an embodiment of the present application can provide a storage medium to implement. A computer program is stored on the storage medium; when the computer program is executed by a processor, the method for automatically constructing any one of the schematic pipeline models in the above embodiments is implemented.
[0137] In one embodiment, a computer device is provided. The computer device may be a terminal. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for automatically constructing a schematic pipeline model is implemented. The display screen of the computer device may be a liquid crystal display screen or an electronic ink display screen. The input device of the computer device may be a touch layer covering the display screen, or a button, a trackball, or a touchpad provided on the housing of the computer device, or an external keyboard, a touchpad, or a mouse, etc.
[0138] In one embodiment, Figure 4 is a schematic internal structure diagram of an electronic device according to an embodiment of the present application, as Figure 4 shown, an electronic device is provided. The electronic device may be a server, and its internal structure diagram may be as Figure 4 shown. The electronic device includes a processor, a network interface, an internal memory, and a non-volatile memory connected through an internal bus. Among them, the non-volatile memory stores an operating system, a computer program, and a database. The processor is used to provide computing and control capabilities. The network interface is used to communicate with an external terminal through a network connection. The internal memory is used to provide an environment for the operation of the operating system and the computer program. When the computer program is executed by the processor, a method for automatically constructing a schematic pipeline model is implemented. The database is used to store data.
[0139] Those skilled in the art can understand that Figure 4 the structure shown in
[0140] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. This computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above methods. Among them, any reference to a memory, storage, database, or other medium used in the embodiments provided in the present application can include non-volatile and / or volatile memories. Non-volatile memories can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memories can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDR SDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), Rambus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and Rambus dynamic RAM (RDRAM), etc.
[0141] Those skilled in the art should understand that the technical features of the above embodiments can be combined arbitrarily. For the sake of brevity of description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered as within the scope described in this specification.
[0142] The above embodiments only represent several implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the scope of the invention patent. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application should be subject to the appended claims.
Claims
1. A method for automatically constructing a schematic urban underground pipeline model based on rule constraints, characterized in that: The method comprises: Obtain road data of traffic roads in a preset area and corresponding underground pipeline data; Preprocessing the road data to reduce interference factors that affect underground pipeline feature extraction, and obtaining preprocessed road data; Based on the preprocessed road data, feature extraction is performed on the underground pipeline data to obtain geometric features and attribute features of the underground pipeline; Based on the road data and the geometric features of the underground pipeline, construct a schematic pipeline network topology to obtain a schematic pipeline model of the underground pipeline; Based on the road data and the attribute characteristics of the underground pipelines, statistical analysis is performed on the underground pipelines under each road section to obtain the real attributes of all underground pipelines under the road section, wherein the real attributes include pipeline length, average burial depth, representative pipe material, representative pipe diameter, representative pipe age, maximum pipe diameter, minimum pipe diameter, maximum pipe age, minimum pipe age, number of manholes, and number of rainwater grates; Using spatial location-based technology and taking roads as carriers, the real attributes of road sections and underground pipelines under the road sections are first merged to obtain road data with real attributes. The road data with real attributes are then mapped to the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not include the real attributes.
2. The method according to claim 1, characterized in that The road data is preprocessed to reduce interference factors that affect the extraction of underground pipeline features, and the preprocessed road data includes: Filtering out road data of elevated roads and tunnels from the road data of the traffic roads, and deleting the road data of elevated roads and tunnels from the road data of the traffic roads to obtain road data after deletion processing; The road data after the deletion process is preprocessed by subdividing the grid units to obtain preprocessed road data.
3. The method according to claim 2, characterized in that The road data after the deletion process is preprocessed by subdividing the grid units, and the preprocessed road data obtained includes: Based on the road data after the deletion process, the corresponding traffic road is interrupted along the intersection to obtain road data corresponding to a plurality of road sections; Then, each road section is divided into l ={ p 1( x 1, y 2), p 2( x 2, y 2)} is broken into N road section sub-sections, and the road data of each road section sub-section after preprocessing is obtained, where: p 1( x 1, y 2) is the starting point coordinate of the road section, p 2( x 2, y 2) is the coordinates of the end point of the road section.
4. The method according to claim 3, characterized in that Based on the preprocessed road data, feature extraction is performed on the underground pipeline data to obtain geometric features of the underground pipeline, including: The geometric characteristics of underground pipelines include trend characteristics, distribution characteristics, buried depth characteristics, distance characteristics and connectivity characteristics; Based on the pre-processed road data and the underground pipeline data, Calculate the direction characteristics of the underground pipeline θ ,in, n p is the direction vector of the road section sub-section, n q is the direction vector of the underground pipeline; Based on the pre-processed road data and the underground pipeline data, the distribution characteristics of the underground pipelines in the road section sub-sections are determined. λ ={0,1,2,3}, where λ =0 means there is no underground pipeline under the road section subsection. λ =1 means that the underground pipeline is distributed on the left side of the road centerline of the road section subsection. λ =2 means that the underground pipelines are distributed on the right side of the road centerline of the road section subsection. λ =3 means that underground pipelines are distributed on both sides of the road centerline of the road section subsection; Based on the pre-processed road data and the underground pipeline data, Calculate the buried depth characteristics of the underground pipeline η ,in, L i For road section sub-sections i The length of underground pipelines, η i For road section sub-sections i The depth of underground pipelines; Based on the pre-processed road data and the underground pipeline data, Calculate the distance characteristics of the underground pipeline φ ,in, L i For road section sub-sections i The length of underground pipelines, φ i For road section sub-sections i The distance from the center line of the underground pipeline road; Based on the preprocessed road data and the underground pipeline data, the connectivity relationship between the underground pipelines under each road section sub-section and the underground pipelines under other road section sub-sections is recorded as a connectivity feature of the underground pipelines.
5. The method according to claim 4, characterized in that Based on the road data and the geometric features of the underground pipeline, a schematic pipeline network topology is constructed to obtain a schematic pipeline model of the underground pipeline, including: Based on the road data and the direction characteristics of the underground pipeline θ , distribution characteristics λ , burial depth characteristics η and distance features φ , for underground pipelines under the originally connected road sections, the consistency of the buried depth of the pipelines and the distance between the pipelines and the road centerline is processed; Based on the connectivity features of the underground pipeline, adjacent pipe sections of the underground pipeline that has completed the consistency processing are connected to obtain a schematic pipeline model of the underground pipeline.
6. The method according to claim 1, characterized in that Based on the pre-processed road data, feature extraction is performed on the underground pipeline data to obtain attribute features of the underground pipeline, including: Based on the preprocessed road data, feature extraction is performed on the underground pipeline data to obtain attribute characteristics of the underground pipeline, wherein the attribute characteristics include section pipe diameter characteristics, section pipe age characteristics, section pipe material characteristics, section pipeline length characteristics, section pipeline burial depth characteristics, section manhole quantity characteristics and section rain grate quantity characteristics.
7. The method according to claim 1, characterized in that Before extracting features of the underground pipeline data based on the preprocessed road data to obtain geometric features and attribute features of the underground pipeline, the method includes: Based on the laying rules of underground pipelines in the preset area, the underground pipeline data of branch pipelines and household pipelines are eliminated from the acquired underground pipeline data to obtain the eliminated underground pipeline data.
8. The method according to claim 1, characterized in that After simulating and generating the schematic pipeline model, the method further includes: The pipeline connectivity under complex road conditions in the schematic pipeline model is manually inspected and repaired, wherein the manual inspection and repair includes distribution integrity inspection and repair, direction correctness inspection and repair, topological relationship authenticity inspection and repair, and attribute fusion correctness inspection and repair.
9. A rule-based automatic construction system for urban underground schematic pipeline models, characterized in that: The system is used to perform the method according to any one of claims 1 to 8, and the system comprises an acquisition module, a preprocessing module and an automatic construction module; The acquisition module is used to acquire the road data of the traffic roads and the corresponding underground pipeline data in the preset area; The preprocessing module is used to preprocess the road data to reduce interference factors that affect the extraction of underground pipeline features, and obtain preprocessed road data; The automatic construction module is used to extract features of the underground pipeline data according to the preprocessed road data to obtain geometric features and attribute features of the underground pipeline; According to the road data and the geometric features of the underground pipeline, a schematic pipeline network topology is constructed to obtain a schematic pipeline model of the underground pipeline; according to the attribute features of the road data and the underground pipeline, the real attributes of the underground pipeline are mapped to the schematic pipeline model to obtain a schematic pipeline model that can reflect the real attributes but does not include the real attributes.
Citation Information
Patent Citations
Pipeline safety protection method and system based on gridding desensitization processing
CN117745067A
Road underground pipeline identification method and device and storage medium
CN118334515A