Urban lifeline existing pipeline data availability evaluation and upgrading method

Abstract

The invention discloses an urban lifeline existing pipeline data availability evaluation and upgrading method. The method comprises the steps that a pipeline historical database and a pipeline current situation database are formed; the method comprises the following steps: preliminarily dividing roads into unchanged roads, changed roads, newly added roads and lost roads; for the unchanged road, the pipeline point type is judged in combination with the pipeline current situation database; and calculating the gross error proportion, the plane precision mean error, the elevation precision mean error, the pipeline point change and the newly-added and extinction proportion of each pipeline point to obtain a preliminary available analysis result: available, partially available or unavailable, and performing general survey or repair test and upgrade on the pipeline by combining the preliminary available analysis result. According to the method, multi-source basic geographic information data is fully utilized, available evaluation of existing pipeline data is participated, available pipeline data is obtained through economic, efficient and reliable evaluation, repairing, testing and upgrading are carried out, fusion utilization with newly-added pipeline data is carried out, and the repeated detection cost is saved.

Description

Technical Field

[0001] The present invention relates to the field of surveying and mapping geographic information technology, and particularly relates to a method for evaluating and upgrading the available data of existing pipelines in urban lifelines. Background Art

[0002] Urban lifelines include systems such as urban gas, roads, bridges, water supply, drainage, heating, electricity, elevators, communication, rail transit, and utility tunnels, and are important infrastructure for maintaining the normal operation of cities and ensuring the production and living needs of the masses. The "Urban Lifeline Safety Project" integrates new-generation information technologies such as cloud computing, big data, GIS, and the Internet of Things into the operation and management of urban lifelines to achieve full-domain perception, automatic collection, monitoring and analysis, and early warning reporting, so as to effectively control risks, promptly address potential hazards, prevent accidents from occurring, ensure the normal operation of urban lifelines, and effectively improve the urban safety guarantee ability.

[0003] At present, China's urban development has entered a renewal period, and the contradictions and problems accumulated during the large-scale and high-speed urban development are becoming increasingly prominent. Some infrastructure has "inherent deficiencies", was built early, has low design standards, and has been operating under high load for a long time, and has collectively entered the aging period; the renewal of some old facilities is slow, and there are problems of "operating while being sick"; the operation and management of underground pipe networks such as gas, water supply, drainage, and heating lack effective overall planning; in some megacities and cities in high-risk natural disaster areas, the operation risks of infrastructure are prone to occur frequently. Generally speaking, the situation of the safe operation of urban infrastructure in China is severe and complex, and safety accident risks such as gas explosions, urban waterlogging, pipe network leaks, and road surface collapses still exist. There is an urgent need to take effective measures to improve the safety resilience of cities.

[0004] The primary task of the safe operation of urban lifelines is to clarify the inventory of infrastructure and risk points and lay a solid data foundation. On the basis of infrastructure census, an urban infrastructure database is established to have a clear understanding of the situation. Underground pipe networks are the data with the largest proportion, the highest cost, and the most difficult to detect, and their timeliness and reliability directly affect the construction effect. Therefore, there is an urgent need to propose a low-cost method for analyzing and evaluating the available data of existing pipelines in urban lifelines using multi-source geographic information data, which can promote the integrated management and utilization of existing and newly added pipeline data. Summary of the Invention

[0005] The purpose of the present invention is to provide a method for evaluating and upgrading the available data of existing pipelines in urban lifelines, which makes full use of existing multi-source basic geographic information data such as pipeline completion surveying and mapping data, large-scale topographic maps, orthophoto maps, and real-scene three-dimensional models to participate in the evaluation of the available data of existing pipelines, and economically, efficiently, and reliably evaluates the available pipeline data and implements repair surveying, mapping, and upgrading, as well as integrated utilization with newly added pipeline data, saving the cost of repeated detection.

[0006] To achieve the above technical objectives, the technical solution adopted by the present invention is as follows:

[0007] A method for evaluating and upgrading the available data of existing pipelines in urban lifelines, the method comprising the following steps:

[0008] S1. Standardize the existing pipeline data to form a pipeline historical database;

[0009] S2. Collect pipeline planning and construction materials, screen out pipeline completion surveying and mapping data from them, obtain new pipeline data after preprocessing, and perform edge fusion of the new pipeline data with the pipeline historical database to generate a pipeline current situation database;

[0010] S3. Extract road elements from the latest large-scale topographic map, overlay the high-resolution orthophoto map of the same phase in the pipeline historical database, and discover road changes through visual comparison. Divide the roads into unchanged roads, changed roads, newly added roads, and disappeared roads;

[0011] S4. For disappeared roads, delete the corresponding existing pipeline data; for changed roads and newly added roads, if there is no corresponding pipeline completion surveying and mapping data, start a pipeline census for the corresponding roads. If there is corresponding pipeline completion surveying and mapping data, regard them as unchanged roads; for unchanged roads, obtain manhole cover sampling detection data, topographic map data, and real scene three-dimensional data respectively, and combine the pipeline current situation database to judge the pipeline point type. The pipeline point types include unchanged pipeline points, changed pipeline points, newly added pipeline points, and disappeared pipeline points;

[0012] S5. Calculate the gross error ratio, plane precision mean error, elevation precision mean error, pipeline point changes, and new and disappeared ratios of each pipeline point to obtain a preliminary available analysis result: available, partially available, or unavailable, and respectively conduct a census on the pipelines or perform repair surveying and upgrading in combination with the preliminary available analysis result.

[0013] Step S1 further includes:

[0014] Perform type conversion processing on the existing pipeline data by means of splitting and merging. Among them, if there is a corresponding relationship and the pipeline does not need to be processed after conversion, directly perform the corresponding conversion; if multiple pipelines have a corresponding relationship with one pipeline, directly perform the corresponding conversion; if one pipeline has a corresponding relationship with multiple pipelines, perform subdivision through attribute items, form a one-to-one correspondence and then perform the corresponding conversion; if there is a corresponding relationship between pipelines but conversion cannot be performed due to inconsistent geometric features of the elements, perform graphic editing or re-collection on the source data to make the geometric features of the elements consistent and then perform the corresponding conversion;

[0015] Based on the pipeline type conversion result, complete the pipeline layer conversion processing by means of mapping, splitting, and merging;

[0016] Analyze the logical relationships between the attribute fields of the existing pipeline data and perform attribute conversion processing on the existing pipeline data. Among them, if both the attribute name and the attribute value remain unchanged, they are directly copied and used. If the attribute name changes, it is directly converted according to the corresponding relationship of the attribute names in the attribute comparison table. If the attribute value changes, it is directly converted according to the corresponding relationship of the attribute values in the attribute comparison table.

[0017] Perform quality inspection on the existing pipeline data after type, layer, and attribute conversion, and form a pipeline historical database after passing the inspection.

[0018] Step S2 further includes:

[0019] S21. Comprehensively analyze the collected pipeline planning and construction application materials, determine at least 4 coincidence points for calculating parameters from them, calculate the conversion parameters, construct a benchmark conversion platform, and use the benchmark conversion platform to perform coordinate conversion on the pipeline data.

[0020] S22. Standardize the underground pipeline data after coordinate conversion.

[0021] S23. Correct the graphics and attributes of the underground pipeline data after standardization processing.

[0022] S24. Perform edge fusion on the newly added pipeline data among them with the pipeline historical database to generate a pipeline current situation database.

[0023] Furthermore, in step S21, select some of the coincidence points as external verification points, and the external verification points do not participate in the calculation of the conversion parameters. After obtaining the conversion parameters, calculate the converted coordinates of the external verification points using the conversion parameters and compare them with the known coordinates, and perform external verification on the conversion parameters according to the comparison results.

[0024] Furthermore, in step S21, the process of using the benchmark conversion platform to perform coordinate conversion on the pipeline data includes the following steps:

[0025] Create a new feature class or layer with the same structure as the original feature class.

[0026] Obtain the coordinates of each feature in the original coordinate system and calculate the coordinates of each feature in the target coordinate system point by point.

[0027] Write the features in the target coordinate system into the newly created feature class or layer.

[0028] Update the attribute values of relevant fields.

[0029] Furthermore, in step S3, the process of initially dividing the roads into unchanged roads, changed roads, newly added roads, and disappeared roads includes:

[0030] If the roads on the topographic map and the orthoimage are consistent, the roads are preliminarily classified as unchanged roads;

[0031] If the roads exist on both the topographic map and the orthoimage but are inconsistent, the roads are preliminarily classified as changed roads;

[0032] If there are roads on the topographic map but none on the orthoimage, the roads are preliminarily classified as newly added roads;

[0033] If there are no roads on the topographic map but there are some on the orthoimage, the roads are preliminarily classified as disappeared roads;

[0034] Using land use data and road reconstruction and expansion data, further judgment and correction are made on the data preliminarily classified as unchanged roads. The correction process includes: if the corresponding area in the land use data has been changed to a non-road use, the unchanged road is corrected to a changed road; if there is a construction record in the corresponding area of the road reconstruction and expansion data, the unchanged road is corrected to a changed road

[0035] Furthermore, in step S4, for the unchanged roads, the process of obtaining the sampling inspection data of manhole covers, topographic map data, and real scene three-dimensional data respectively and judging the types of pipeline points in combination with the pipeline status database includes the following steps:

[0036] Obtain the sampling inspection data of manhole covers, and judge the types of pipeline points in combination with the sampling inspection data of manhole covers and the pipeline status database to obtain the first analysis data; specifically including:

[0037] Adopt the sampling inspection method to randomly inspect some manhole cover data; use the RTK method to measure the plane position and elevation of the pipeline points, record the measurement point numbers during the measurement process, and observe with the set pipeline point marker as the center to obtain the first analysis data; among them, when measuring, place the prism rod with a bubble on the pipeline point and make the bubble centered; before and after each pipeline point measurement, conduct instrument height level point inspection;

[0038] Extract the pipeline elements in the topographic map, overlay them with the pipeline historical database for topological analysis to obtain the second analysis data; among them, if there are pipeline elements in both the topographic map and the pipeline historical database and they are consistent, it is judged as an unchanged pipeline point; if there are pipeline elements in both the topographic map and the pipeline historical database but there are differences, it is judged as a changed pipeline point; if there are pipeline elements in the topographic map but none in the pipeline historical database, it is judged as a newly added pipeline point; if there are no pipeline elements in the topographic map but there are some in the pipeline historical database, it is judged as a disappeared pipeline point;

[0039] Overlay the real - scene 3D model with the pipeline historical database for topological analysis to obtain the third analysis data. Among them, if there are pipeline elements in both the real - scene 3D model and the pipeline historical database and they are consistent, it is judged as an unchanged pipeline point; if there are pipeline elements in both the real - scene 3D model and the pipeline historical database but there are differences, it is judged as a changed pipeline point; if there are pipeline elements in the real - scene 3D model but not in the pipeline historical database, it is judged as a newly added pipeline point; if there are no pipeline elements in the real - scene 3D model but there are in the pipeline historical database, it is judged as a lost pipeline point.

[0040] Summarize the first analysis data, the second analysis data, and the third analysis data to form the overall analysis data.

[0041] Furthermore, in step S5, for some available pipeline data, determine the processing method as patching survey and upgrading for use; for pipeline data that cannot be utilized, determine the processing method as general survey; for available pipeline data, conduct well - opening verification on safety - related pressure pipes. If there are changes, determine the processing method as patching survey and upgrading for use; if there are no changes, determine the processing method as retaining for use.

[0042] Furthermore, in step S5, the process of patching survey and upgrading the pipeline includes:

[0043] S51, check the pipeline data; specifically including the following steps:

[0044] Randomly select obvious pipeline points, check the horizontal position, elevation accuracy, and measurement accuracy, calculate the corresponding errors, and it can be used only if the requirements are met; for hidden pipeline points found to have problems during the data quality inspection, conduct on - site detection to determine the position and burial depth of the pipeline and complete the mathematical accuracy inspection.

[0045] Successively complete the attribute accuracy inspection including field non - null check, field uniqueness check, field value range check, drawing - attribute consistency check, and other problem checks.

[0046] Successively complete the topological consistency inspection including overlapping line check, hanging line check, duplicate point check, hanging point check, and vertical clearance check.

[0047] Successively complete the logical accuracy inspection including numerical over - limit investigation, numerical error investigation, coding standard investigation, and numerical logic error investigation.

[0048] Conduct currency verification on the incomplete, connection - error, and mutually - contradictory part of the existing pipeline data. The currency verification includes existence verification and change verification.

[0049] S52, based on the pipeline data inspection results, upgrade the attributes of the pipeline data; specifically including the following steps:

[0050] Errata for null value fields including pipe point null values and pipeline null values;

[0051] Upgrade abnormal pipe point data including logical errors, abnormal ground elevation, abnormal well chamber structure size, abnormal well depth, misused length unit, hanging points, duplicate points, abnormal associated fields, and null value data;

[0052] Upgrade abnormal pipeline segment data including abnormal burial depth at the start and end points, abnormal pipe diameter, abnormal pipeline elevation at the start and end points, abnormal ground elevation at the start and end points, abnormal overburden thickness at the start and end points, repeated measurements, element overlap, hanging lines, pipeline missing, length anomaly, field null values, and excessive differences in elevation, ground elevation, burial depth, and overburden thickness between the start and end points;

[0053] S53. Based on the inspection results of pipeline data, perform currency upgrade on the pipeline data; specifically including the following steps:

[0054] By comparing the positions of existing pipeline data with obvious field points, confirm the existence of pipelines, mark the obvious points that no longer exist in the existing pipeline data; at the same time, mark the newly added obvious points, and after supplementary detection, store them in the database for upgrade;

[0055] Verify whether the attribute information including position, burial depth, specifications, and number of holes in the existing pipeline data has changed; if the number of holes or the cross-sectional dimensions of pipe blocks of power and communication pipelines change, perform revised surveying; if additional pipe holes are added to communication and power pipe blocks, re-explore; when the changed pipeline is connected to the old pipeline, determine the edge connection relationship through fieldwork; for the changed pipeline data, after supplementary detection, upgrade and store it in the database.

[0056] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0057] The method for evaluating and upgrading existing pipeline data of urban lifelines of the present invention makes full use of existing multi-source basic geographic information data such as pipeline completion surveying and mapping data, large-scale topographic maps, orthophoto maps, and real-scene 3D models, and participates in the available evaluation of relevant data, reducing the fieldwork workload in the evaluation process by about 50%, reducing the fieldwork cost by about 50%, and shortening the construction period by about 40%. At the same time, upgrade the available existing pipeline data to realize the integrated utilization of existing pipeline data and newly added pipeline data, saving a large amount of repeated detection costs. Therefore, the method for evaluating and upgrading existing pipeline data of urban lifelines of the present invention can be widely applied in fields such as underground pipeline census or update, urban lifeline safety project construction, and urban renewal. Description of the Drawings

[0058] Figure 1 It is a flowchart of the method for evaluating and upgrading existing pipeline data of urban lifelines of the present invention;

[0059] Figure 2 It is a flow chart for the standardization processing of existing pipeline data;

[0060] Figure 3 It is a flow chart for the conversion and storage of pipeline completion surveying and mapping data into the database. Specific implementation manners

[0061] The embodiments of the present invention will be further described in detail below with reference to the accompanying drawings.

[0062] A method for evaluating and upgrading the availability of existing pipeline data in urban lifelines, the method comprising the following steps:

[0063] S1, performing standardization processing on the existing pipeline data to form a pipeline historical database;

[0064] S2, collecting pipeline planning and construction application materials, screening out pipeline completion surveying and mapping data therefrom, obtaining new pipeline data after preprocessing, and performing edge fusion of the new pipeline data with the pipeline historical database to generate a pipeline current situation database;

[0065] S3, extracting road elements from the latest large-scale topographic map, overlaying the high-resolution orthophoto map of the same phase in the pipeline historical database, discovering road changes through visual comparison, and initially dividing the roads into unchanged roads, changed roads, newly added roads, and disappeared roads;

[0066] S4, for the disappeared roads, deleting the corresponding existing pipeline data; for the changed roads and newly added roads, if there is no corresponding pipeline completion surveying and mapping data, starting the pipeline census corresponding to the road, and if there is corresponding pipeline completion surveying and mapping data, regarding it as an unchanged road; for the unchanged roads, respectively obtaining manhole cover sampling detection data, topographic map data, and real scene three-dimensional data, and judging the pipeline point types in combination with the pipeline current situation database, and the pipeline point types include unchanged pipeline points, changed pipeline points, newly added pipeline points, and disappeared pipeline points;

[0067] S5, calculating the gross error ratio, plane accuracy mean error, elevation accuracy mean error, pipeline point changes, and new and disappearance ratios of each pipeline point to obtain a preliminary available analysis result: available, partially available, or unavailable, and respectively conducting a census on the pipeline or performing patching surveying and upgrading in combination with the preliminary available analysis result.

[0068] See Figure 1 , the method specifically comprises the following steps:

[0069] I. Standardization processing of existing pipeline data

[0070] The standardization process of existing pipeline data is carried out on the basis of fully analyzing the logical relationships among the attribute fields in the existing database and comparing the differences between the existing database and the urban lifeline collection standard database. Figure 2 It is the flow chart for the standardization process of existing pipeline data.

[0071] 1.1 Pipeline type conversion

[0072] Adopt a classification processing method:

[0073] (1) For pipelines with corresponding relationships and no need for processing after conversion, direct comparison conversion is carried out.

[0074] (2) When there is a corresponding relationship between multiple pipelines and one pipeline, direct comparison conversion is carried out.

[0075] (3) When there is a corresponding relationship between one pipeline and multiple pipelines, it is subdivided through attribute items (such as name, remarks, etc.), and after forming a one-to-one correspondence, comparison conversion is carried out.

[0076] (4) For pipelines with corresponding relationships but unable to be converted due to inconsistent geometric features of the elements, graphic editing or re-acquisition of the source data is carried out, and after making the geometric features of the elements consistent, comparison conversion is carried out.

[0077] 1.2 Pipeline layer conversion

[0078] After completing the pipeline type mapping, the corresponding relationship is relatively clear, and after sorting, direct mapping, splitting, and merging are carried out.

[0079] 1.3 Pipeline attribute conversion

[0080] Also adopt a classification processing method:

[0081] (1) If both the attribute name and the attribute value remain unchanged, it is directly copied and used.

[0082] (2) If the attribute name changes, it is directly converted according to the corresponding relationship of the attribute names in the attribute comparison table.

[0083] (3) If the attribute value changes, it is directly converted according to the corresponding relationship of the attribute values in the attribute comparison table.

[0084] 1.4 Pipeline historical database

[0085] Through pipeline type conversion, pipeline layer conversion, and pipeline attribute conversion, after passing the quality inspection, a pipeline historical database is formed, which serves as the basic data for subsequent continuous analysis.

[0086] II. Conversion and warehousing of pipeline completion surveying and mapping data

[0087] See Figure 3, This step mainly rectifies and stores the pipeline completion surveying and mapping data to enhance the accuracy, reliability, and currency of the pipeline database.

[0088] 2.1 Coordinate Transformation

[0089] The main steps of coordinate transformation include:

[0090] (1) Collect existing control data, especially control data with both the original coordinate system and the target coordinate system.

[0091] (2) Comprehensively analyze the collected control data and determine at least 4 coincident points for calculating parameters from them. Select some coincident points as external check points, which do not participate in the calculation of transformation parameters. Compare the transformed coordinates of these points calculated with the transformation parameters with the known coordinates for external checking. At least 6 evenly distributed coincident points should be selected to check the coordinate transformation accuracy.

[0092] (3) Use the determined coincident points to calculate the transformation parameters and construct a two-dimensional seven-parameter transformation model.

[0093] (4) Import the calculated transformation parameters into the reference transformation platform.

[0094] (5) Use the reference transformation platform to perform coordinate transformation on the pipeline data. Specific methods:

[0095] ① Create a new feature class (or layer) with the same structure as the original feature class;

[0096] ② Obtain the coordinates of each feature in the original coordinate system and calculate the coordinates of each feature in the target coordinate system point by point;

[0097] ③ Write the features in the target coordinate system into the newly created feature class (or layer);

[0098] ④ Update the relevant field attribute values.

[0099] (6) Check the results of the transformation to ensure that information such as coordinate accuracy and attributes is accurate.

[0100] 2.2 Standardization Processing

[0101] Through work such as data preprocessing, graphic transformation, attribute mapping, and information supplementation, convert the underground pipeline data into the format required by the new data standard.

[0102] (1) Data Preprocessing

[0103] Use GIS software to load the CAD underground pipeline map and initially convert it into the format of the underground pipeline database.

[0104] (2) Pipeline Type Conversion

[0105] Adopt the classification processing method, same as step 1.1.

[0106] (3) Pipeline layer conversion

[0107] After the pipeline type mapping is completed, the corresponding relationship is relatively clear. After sorting, it is directly mapped, split, and merged. Adopt the classification processing method, same as step 1.2.

[0108] (4) Pipeline attribute conversion

[0109] Adopt the classification processing method, same as step 1.3.

[0110] 2.3 Edge connection processing and database storage

[0111] The newly added pipeline data is edge-connected and integrated with the pipeline historical database to ensure the overall consistency, mutual connectivity, and topological accuracy of the underground pipelines.

[0112] III. Analysis of the availability of pipeline data

[0113] 3.1 Analysis of the current road situation

[0114] Extract road elements from the latest large-scale topographic map, overlay the high-resolution orthophoto map of the same phase in the pipeline historical database, and discover road changes through visual comparison.

[0115] (1) If the roads on the topographic map and the orthophoto map are the same, they are initially classified as unchanged roads.

[0116] (2) If the roads exist on both the topographic map and the orthophoto map but are inconsistent, they are initially classified as changed roads.

[0117] (3) If there is a road on the topographic map but not on the orthophoto map, it is initially classified as a newly added road.

[0118] (4) If there is no road on the topographic map but there is one on the orthophoto map, it is initially classified as a disappeared road.

[0119] (5) Further use land use data and road reconstruction and expansion data to further judge and correct the data initially classified as unchanged roads.

[0120] ① If the area has been changed to a non-road use in the land use data, the unchanged road is corrected to a changed road.

[0121] ② If there is a construction record in the area in the road reconstruction and expansion data, the unchanged road is corrected to a changed road.

[0122] 3.2 Analysis method for the scope of unchanged roads

[0123] (1) Manhole cover sampling inspection

[0124] ① Adopt the sampling detection method and randomly detect 10% of the manhole cover data in the field.

[0125] ② Use the RTK method to measure the plane position and elevation of pipeline points. During the measurement process, record the measurement point numbers, and conduct observations centered on the set pipeline point markers. When measuring, place the prism rod with a bubble on the pipeline point and make the bubble centered.

[0126] ③ Before and after each pipeline point measurement, conduct instrument high-level point inspections to ensure that the difference between the detected coordinates and the known coordinates meets the requirements.

[0127] (2) Topographic map comparison and analysis

[0128] ① Extract the pipeline elements (pipeline points) in the topographic map and perform topological analysis by overlaying them with the pipeline historical database.

[0129] ② For pipeline elements that exist in both the topographic map and the pipeline historical database and are consistent, they are judged as unchanged pipeline points.

[0130] ③ For pipeline elements that exist in both the topographic map and the pipeline historical database but have differences, they are judged as changed pipeline points.

[0131] ④ For pipeline elements that exist in the topographic map but not in the pipeline historical database, they are judged as newly added pipeline points.

[0132] ⑤ For pipeline elements that do not exist in the topographic map but exist in the pipeline historical database, they are judged as lost pipeline points.

[0133] (3) True three-dimensional comparison and analysis

[0134] ① In the two- and three-dimensional integration platform, overlay the true three-dimensional model with the pipeline historical database to perform topological analysis.

[0135] ② For pipeline elements that exist in both the true three-dimensional model and the pipeline historical database and are consistent, they are judged as unchanged pipeline points.

[0136] ③ For pipeline elements that exist in both the true three-dimensional model and the pipeline historical database but have differences, they are judged as changed pipeline points.

[0137] ④ For pipeline elements that exist in the true three-dimensional model but not in the pipeline historical database, they are judged as newly added pipeline points.

[0138] ⑤ For pipeline elements that do not exist in the true three-dimensional model but exist in the pipeline historical database, they are judged as lost pipeline points.

[0139] (4) Preliminary analysis results

[0140] ① Summarize the data of manhole cover sampling detection, topographic map comparison and analysis, and true three-dimensional comparison and analysis to form overall analysis data.

[0141] ② Calculate the proportion of gross errors, the mean square error of plane accuracy, the mean square error of elevation accuracy, the changes in pipeline points, and the proportion of new additions and disappearances.

[0142] ③ Compare with the predefined thresholds to obtain the preliminary available analysis results: available, partially available, or unavailable.

[0143] ④ The available pipeline data needs to be further verified later.

[0144] ⑤ For the partially available pipeline data, determine the processing method as patch survey and use after upgrading.

[0145] ⑥ For the unavailable pipeline data, determine the processing method as a general survey.

[0146] (5) Further verification of available pipelines

[0147] ① For the available pipelines, for pressure pipelines (water supply, gas, heat, industry) and other safety-related pipelines (electric power, etc.), conduct on-site inspection of wells to check for changes.

[0148] ② For those with changes, determine the processing method as patch survey and use after upgrading.

[0149] ③ For those without changes, determine the processing method as retaining for use.

[0150] 3.3 Analysis method for the scope of changed roads

[0151] (1) Determine whether there is pipeline completion survey data for the scope of changed roads

[0152] (2) If there is pipeline completion survey data, operate according to the analysis method for the scope of unchanged roads in 4.2.

[0153] (3) If there is no pipeline completion survey data, determine the processing method as a general survey.

[0154] 3.4 Analysis method for the scope of newly added roads

[0155] (1) Determine whether there is pipeline completion survey data for the scope of newly added roads

[0156] (2) If there is pipeline completion survey data, operate according to the analysis method for the scope of unchanged roads in 4.2.

[0157] (3) If there is no pipeline completion survey data, determine the processing method as a general survey.

[0158] 3.5 Analysis method for the scope of disappeared roads

[0159] Directly determine the processing method as deleting the existing pipeline data.

[0160] IV. Pipeline patch survey and upgrading

[0161] 4.1 Inspection of background data

[0162] (1) Mathematical precision inspection

[0163] ① Inspection of pipeline point measurement. Randomly select 10% of the obvious points to check the horizontal position and elevation accuracy, and calculate the mean errors in the horizontal and vertical directions. It can be used only when the requirements are met.

[0164] ② Inspection of obvious pipeline point measurement. Randomly select 10% of the obvious points to check the measurement accuracy, and calculate the mean error. It can be used only when the requirements are met.

[0165] ③ Inspection of buried pipeline point detection. For the buried points found to have problems during the data quality inspection process, conduct on-site detection to determine the position and burial depth of the pipeline.

[0166] (2) Attribute accuracy inspection

[0167] ① Field non-empty inspection

[0168] Check for errors where the value is empty for the required fields.

[0169] ② Field uniqueness inspection

[0170] For fields that cannot have duplicate records (such as geophysical exploration point numbers, pipe point codes, pipe section codes, etc.) as required by the data standard, check for errors where the values are repeated.

[0171] ③ Field value range inspection

[0172] For fields with threshold limits, check whether the values exceed the range.

[0173] ④ Drawing-attribute consistency inspection

[0174] Check for errors such as having a drawing without an attribute, having an attribute without a drawing, and mismatches for the correlation between the drawing and the attribute.

[0175] ⑤ Inspection of other problems

[0176] Conduct inspections for layer data arrangement, feature symbolization, etc.

[0177] (3) Topological consistency inspection

[0178] ① Overlapping line inspection

[0179] Conduct topological analysis on the pipeline data. If the pipeline positions completely overlap, submit for on-site correction.

[0180] ② Dangling line inspection

[0181] Conduct topological analysis on the pipeline data. If there are no pipe points at both ends of the pipeline, submit for on-site supplementary measurement.

[0182] ③ Duplicate point inspection

[0183] Perform topological analysis on the pipe point data. If the positions of two pipe points are exactly the same, submit a field errata.

[0184] ④ Hanging point inspection

[0185] Perform topological analysis on the pipe point data. If there is no pipeline endpoint at the position where the pipe point is located, submit a field re-survey.

[0186] ⑤ Vertical clearance inspection

[0187] Perform vertical clearance inspection on the pipe segments. When the pipe segments are cross-laid and the safety distance is insufficient (or there is a collision), submit a field errata.

[0188] (4) Logical accuracy inspection

[0189] ① Numerical limit checking

[0190] For attribute fields such as the structural dimensions of the well chamber, well depth, and manhole cover size, if they exceed the threshold range, submit a field errata.

[0191] ② Numerical error checking

[0192] For attribute fields such as the structural dimensions of the well chamber, well depth, and manhole cover size, if they are contradictory or in conflict, submit a field errata.

[0193] ③ Coding specification checking

[0194] For attribute fields using codes, if they exceed the data standard regulations, submit a field errata.

[0195] ④ Numerical logic error checking

[0196] For attribute fields with logical relationships, if there are logical association errors or conversion result conflicts, submit a field errata.

[0197] (4) Data currency verification

[0198] It mainly includes existence verification and change verification. At the same time, for incomplete, connection error, and mutual relationship contradiction in the existing pipeline data, on-site verification and correction should also be carried out.

[0199] 1) Sources of currency change information

[0200] ① Pipeline completion data, pipeline planning approval data.

[0201] ② Through obvious point surveys, obtain information such as the structural dimensions of the well chamber, well neck diameter, well neck depth, manhole cover shape, manhole cover size, and manhole cover material, and at the same time, the changes in the pipeline can be directly viewed.

[0202] ③During the field inspection, check for road surface enclosures, excavations, landfills, or newly paved asphalt marks, and identify new construction, reconstruction, or expansion of pipelines.

[0203] 2) Current field verification records

[0204] ①Location and area of changes.

[0205] ②Change type (ground excavation, new pipeline laying, pipeline cable threading, other situations).

[0206] ③Types of pipelines with changes.

[0207] 4.2 Upgrading the attributes of existing pipeline data

[0208] (1) Correction of null value fields

[0209] 1) Null values of pipe points:

[0210] Screen for null values in the field survey data such as the structural dimensions of the well chamber, well depth, manhole cover dimensions, manhole cover shape, manhole cover material, ground elevation, and appendages, and submit the field survey.

[0211] 2) Null values of pipelines

[0212] Screen for null values in fields such as pipe material, pipe diameter, laying method, starting burial depth, and ending burial depth, and submit the field survey.

[0213] (2) Upgrading of pipe point data

[0214] 1) Logical errors: Conflicts occur in the logical calculation between multiple field values (e.g., well depth, well chamber depth, well neck depth). Solution: Analyze the correctness of the existing data and calculate according to the logical relationship.

[0215] 2) Abnormal ground elevation: The value exceeds the reasonable threshold. Solution: First, judge according to materials such as images, terrain, and digital elevation models. For those that cannot be judged, conduct field verification.

[0216] 3) Abnormal structural dimensions of the well chamber: The value exceeds the reasonable threshold. Solution: First, judge according to the pipeline type and local actual situation based on the topographic map. For those that cannot be judged, conduct field verification.

[0217] 4) Abnormal well depth (burial depth): The value exceeds the reasonable threshold. Solution: Judge according to the pipeline type and local actual situation based on the topographic map. For those that cannot be judged, conduct field verification.

[0218] 5) Misuse of length units: Confused or incorrect use of length units (kilometer, meter, decimeter, centimeter, millimeter). Solution: Judge according to common sense or conduct on-site verification.

[0219] 6) Hanging points: Isolated pipe points have no corresponding pipelines, and the positions of pipeline pipe points are offset and not connected. Solution: Non-eccentric isolated pipe points can be deleted. For the rest, judge according to the original data, images, terrain, surrounding data, etc. For those that cannot be judged, conduct on-site verification.

[0220] 7) Duplicate points: The distances between the positions of two pipe points are extremely close. Solution: Keep one of them and modify the corresponding attributes at the same time.

[0221] 8) Abnormal associated fields: For example, the appurtenance is not a well, but has well-related attributes. Solution: Make a comprehensive judgment and combine on-site investigation.

[0222] 9) Null value data: The required fields are empty. Solution: Conduct on-site investigation.

[0223] (3) Upgrade of pipeline segment data

[0224] 1) Abnormal burial depths of starting and ending points: The values exceed the reasonable threshold. Solution: Make a comprehensive judgment according to the laying method or the data before and after. For those that cannot be judged, conduct on-site verification.

[0225] 2) Abnormal pipe diameters: The values exceed the reasonable threshold or the units are not unified. Solution: Make a comprehensive judgment according to the data and pipeline types.

[0226] 3) Abnormal pipeline elevations of starting and ending points: The values exceed the reasonable threshold. Solution: Make a judgment by combining the ground elevation and burial depth.

[0227] 4) Abnormal ground elevations of starting and ending points: The values exceed the reasonable threshold. Solution: Make a judgment by combining the ground elevations of pipe points.

[0228] 5) Abnormal cover thicknesses of starting and ending points: The values exceed the reasonable threshold. Solution: Make a judgment by combining the burial depths of starting and ending points.

[0229] 6) The differences in elevations, ground elevations, burial depths, and cover thicknesses of starting and ending points are too large. Solution: Make a comprehensive judgment according to the image and terrain data. For those that cannot be judged, conduct on-site verification.

[0230] 7) Repeated measurements: Multiple measurement data exist simultaneously. Solution: Judge according to the image and terrain, and keep the data with the strongest reliability.

[0231] 8) Overlapping elements: The positions overlap with different or the same attributes. Solution: Those with the same attributes can be deleted, and those with different attributes are judged in the field.

[0232] 9) Hanging lines: Pipelines lack pipe points. Solution: Analyze specifically according to the data before and after. For those that cannot be judged, conduct on-site verification

[0233] 10) Pipeline missing: The pipeline is disconnected and missing in the middle. Solution: Verify on-site.

[0234] 11) Abnormal length: The pipeline length exceeds the reasonable threshold. Solution: Verify on-site.

[0235] 12) Null field value: The required attribute field is empty. Solution: Conduct on-site investigation.

[0236] 4.3 Updating the currency of existing pipeline data

[0237] (1) Updating existence data

[0238] Check whether the existing pipeline data exists, has been lost, or has changed. By comparing the positions of the existing pipeline data with the obvious points on the ground, confirm whether the pipeline exists, and mark the obvious points that no longer exist in the existing pipeline data. At the same time, mark the newly added obvious points, and after supplementary detection, store them in the database for upgrading.

[0239] (2) Updating change data

[0240] Verify whether the existing pipeline data has changed, mainly including information such as position, burial depth, specifications, and the number of holes.

[0241] 1) When the number of holes or the cross-sectional size of the pipe block of power and communication pipelines changes, a resurvey should be carried out. For communication and power pipe blocks with increased pipe holes, re-probe.

[0242] 2) When the changed pipeline is connected to the old pipeline, determine the edge connection relationship through fieldwork.

[0243] 3) For changed pipeline data, after supplementary detection, upgrade and store it in the database.

[0244] Those skilled in the art should understand that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present application can take 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 code. The solutions in the embodiments of the present application can be implemented in various computer languages, for example, object-oriented programming languages such as Java and interpreted scripting languages such as JavaScript.

[0245] This application is described with reference to the flowcharts and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the present application. It should be understood that each flow and / or block in the flowchart and / or block diagram, and the combination of flows and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing device to generate a machine, such that the instructions run by the processor of the computer or other programmable data processing device generate means for implementing the functions specified in one or more of the flows Figure 1 one or more of the flows and / or blocks Figure 1 or means for implementing the functions specified in one or more of the blocks.

[0246] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory generate a manufacture including instruction means that implement the functions specified in one or more of the flows Figure 1 one or more of the flows and / or blocks Figure 1 or means for implementing the functions specified in one or more of the blocks.

[0247] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are run on the computer or other programmable device to generate a computer-implemented process, so that the instructions run on the computer or other programmable device provide steps for implementing the functions specified in one or more of the flows Figure 1 one or more of the flows and / or blocks Figure 1 or means for implementing the functions specified in one or more of the blocks.

[0248] Although the preferred embodiments of the present application have been described, those skilled in the art can make additional changes and modifications once they learn the basic creative concepts. Therefore, the appended claims are intended to be construed to include the preferred embodiments and all changes and modifications falling within the scope of the present application.

[0249] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalent technologies, the present application is also intended to include these changes and modifications.

Claims

1. A method for evaluating and upgrading the available data of existing pipelines in the urban lifeline, characterized in that, The method includes the following steps: S1. Standardize the existing pipeline data to form a pipeline historical database; S2. Collect pipeline planning and construction approval materials, screen out pipeline completion surveying and mapping data from them, obtain new pipeline data after preprocessing, and perform edge connection and fusion of the new pipeline data with the pipeline historical database to generate a pipeline current situation database; S3. Extract road elements from the latest large-scale topographic map, overlay the high-resolution orthophoto map of the same phase in the pipeline historical database, and discover road changes through visual comparison. Divide the roads into unchanged roads, changed roads, newly added roads, and disappeared roads; S4. For disappeared roads, delete the corresponding existing pipeline data; for changed roads and newly added roads, if there is no corresponding pipeline completion surveying and mapping data, start a pipeline census corresponding to the road. If there is corresponding pipeline completion surveying and mapping data, regard it as an unchanged road; for unchanged roads, obtain manhole cover sampling detection data, topographic map data, and real-scene 3D data respectively, and judge the pipeline point type in combination with the pipeline current situation database. The pipeline point types include unchanged pipeline points, changed pipeline points, newly added pipeline points, and disappeared pipeline points; S5. Calculate the gross error ratio, plane accuracy mean error, elevation accuracy mean error, pipeline point changes, and newly added and disappeared ratios of each pipeline point to obtain a preliminary available analysis result: available, partially available, or unavailable, and conduct a pipeline census or perform repair surveying and upgrading on the pipeline respectively in combination with the preliminary available analysis result.

2. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 1, wherein Step S1 further includes: Perform type conversion processing on the existing pipeline data by means of splitting and merging. Among them, for pipelines with corresponding relationships and no need for processing after conversion, directly perform corresponding conversion; for multiple pipelines with a corresponding relationship with one pipeline, directly perform corresponding conversion; for one pipeline with a corresponding relationship with multiple pipelines, conduct subdivision through attribute items, form a one-to-one correspondence, and then perform corresponding conversion; for pipelines with corresponding relationships but unable to be converted due to inconsistent geometric features of elements, perform graphic editing or re-collection on the source data, and perform corresponding conversion after making the geometric features of the elements consistent; Based on the pipeline type conversion result, complete the pipeline layer conversion processing by means of mapping, splitting, and merging; Analyze the logical relationship between the attribute fields of the existing pipeline data and perform attribute conversion processing on the existing pipeline data; among them, if both the attribute name and attribute value remain unchanged, directly copy and use; if the attribute name changes, directly convert according to the corresponding relationship of the attribute names in the attribute comparison table; if the attribute value changes, directly convert according to the corresponding relationship of the attribute values in the attribute comparison table; Inspect the existing pipeline data after type, layer, and attribute conversion, and form a pipeline historical database after passing the inspection.

3. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 1, characterized in that, Step S2 further includes: S21. Comprehensively analyze the collected pipeline planning and construction approval materials, determine at least 4 coincidence points for calculating parameters from them, calculate the conversion parameters, construct a reference conversion platform, and use the reference conversion platform to perform coordinate conversion on the pipeline data; S22. Standardize the underground pipeline data after coordinate conversion; S23. Correct the graphics and attributes of the standardized underground pipeline data; In S24, the newly added pipeline data is joined and fused with the pipeline historical database to generate the pipeline current situation database.

4. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 3, wherein In step S21, some overlapping points are selected as external verification points, and the external verification points do not participate in the calculation of transformation parameters; after obtaining the transformation parameters, the transformation coordinates of the external verification points are calculated using the transformation parameters and compared with the known coordinates, and the transformation parameters are externally verified according to the comparison results.

5. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 3, characterized in that, In step S21, the process of coordinate transformation of pipeline data using the reference transformation platform includes the following steps: Create a new feature class or layer with the same structure as the original feature class. Obtain the coordinates of each feature in the original coordinate system and calculate the coordinates of each feature in the target coordinate system point by point. Write the features in the target coordinate system into the newly created feature class or layer. Update the relevant field attribute values.

6. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 1, wherein In step S3, the process of initially dividing the roads into unchanged roads, changed roads, newly added roads, and disappeared roads includes: If the roads on the topographic map and the orthophoto map are the same, the roads are initially divided into unchanged roads. If the roads exist on both the topographic map and the orthophoto map but are inconsistent, the roads are initially divided into changed roads. If there are roads on the topographic map but not on the orthophoto map, the roads are initially divided into newly added roads. If there are no roads on the topographic map but there are roads on the orthophoto map, the roads are initially divided into disappeared roads. Using land use data and road reconstruction and expansion data, further judgment and correction are made on the data initially divided into unchanged roads. The correction process includes: if the corresponding area in the land use data has been changed to a non-road use, the unchanged road is corrected to a changed road; if there is a construction record in the corresponding area of the road reconstruction and expansion data, the unchanged road is corrected to a changed road.

7. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 1, characterized in that, In step S4, for unchanged roads, the process of obtaining manhole cover sampling inspection data, topographic map data, and real scene 3D data respectively and judging the pipeline point type in combination with the pipeline current situation database includes the following steps: Obtain the manhole cover sampling inspection data, judge the pipeline point type in combination with the manhole cover sampling inspection data and the pipeline current situation database to obtain the first analysis data; specifically including: Adopt the sampling inspection method to randomly inspect some manhole cover data; use the RTK method to measure the plane position and elevation of the pipeline points, record the measurement point numbers during the measurement process, and observe with the set pipeline point marker as the center to obtain the first analysis data; among them, when measuring, place the prism rod with a bubble on the pipeline point and make the bubble centered; perform instrument height and grade point inspections before and after each pipeline point measurement. Extract the pipeline elements in the topographic map, overlay them with the pipeline historical database for topological analysis to obtain the second analysis data; among them, if there are pipeline elements in both the topographic map and the pipeline historical database and they are consistent, it is judged as an unchanged pipeline point; if there are pipeline elements in both the topographic map and the pipeline historical database but there are differences, it is judged as a changed pipeline point; if there are pipeline elements in the topographic map but not in the pipeline historical database, it is judged as a newly added pipeline point; if there are no pipeline elements in the topographic map but there are in the pipeline historical database, it is judged as a disappeared pipeline point. Overlay the real - scene 3D model with the pipeline historical database for topological analysis to obtain the third analysis data. Among them, if there are pipeline elements in both the real - scene 3D model and the pipeline historical database and they are consistent, it is judged as an unchanged pipeline point; if there are pipeline elements in both the real - scene 3D model and the pipeline historical database but there are differences, it is judged as a changed pipeline point; if there are pipeline elements in the real - scene 3D model but not in the pipeline historical database, it is judged as a newly added pipeline point; if there are no pipeline elements in the real - scene 3D model but there are in the pipeline historical database, it is judged as a lost pipeline point. Summarize the first analysis data, the second analysis data, and the third analysis data to form the overall analysis data.

8. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 1, characterized in that, In step S5, for some available pipeline data, determine the processing method as patching survey and upgrading for use; for the pipeline data that cannot be utilized, determine the processing method as a general survey; for the available pipeline data, conduct well - opening verification for the pressure pipes related to safety. If there are changes, determine the processing method as patching survey and upgrading for use; if there are no changes, determine the processing method as retaining for use.

9. The method for evaluating and upgrading the available data of existing pipelines in the urban lifeline according to claim 1, characterized in that, In step S5, the process of patching survey and upgrading the pipeline includes: S51, check the pipeline data; specifically including the following steps: Randomly select obvious pipeline points, check the horizontal position, elevation accuracy, and measurement accuracy, calculate the corresponding errors, and it can be used only if it meets the requirements; for the hidden pipeline points found to have problems during the data quality inspection, conduct on - site detection to determine the position and burial depth of the pipeline, and complete the mathematical accuracy inspection. Successively complete the attribute accuracy inspection including field non - null check, field uniqueness check, field value range check, map - attribute consistency check, and other problem checks. Successively complete the topological consistency check including overlapping line check, hanging line check, duplicate point check, hanging point check, and vertical clearance check. Successively complete the logical accuracy check including numerical limit checking, numerical error checking, coding specification checking, and numerical logic error checking. Conduct currency verification on the incomplete, connection - error, and mutually - contradictory part of the existing pipeline data. The currency verification includes existence verification and change verification. S52, based on the pipeline data inspection results, upgrade the attributes of the pipeline data; specifically including the following steps: Correct the null - value fields including pipe - point null values and pipeline null values. Upgrade the abnormal pipe - point data including logical errors, abnormal ground elevation, abnormal well - chamber structure size, abnormal well depth, misused length unit, hanging points, duplicate points, associated field anomalies, and null - value data. Upgrade the abnormal pipe - section data including abnormal start - end burial depth, abnormal pipe diameter, abnormal start - end pipeline elevation, abnormal start - end ground elevation, abnormal start - end covering thickness, repeated measurement, element overlap, hanging line, pipeline missing, length anomaly, field null value, and the situation where the elevation, ground elevation, burial depth, and covering thickness at the start - end differ greatly. S53, based on the pipeline data inspection results, upgrade the currency of the pipeline data; specifically including the following steps: By comparing the positions of existing pipeline data with the obvious points on the ground, confirm the existence of pipelines, mark the obvious points that no longer exist on the existing pipeline data; at the same time, mark the newly added obvious points, and after supplementary detection, store them in the database for upgrading; Verify whether the attribute information including position, burial depth, specifications, and number of holes in the existing pipeline data has changed; if the number of holes and the cross-sectional dimensions of the pipe blocks of power and communication pipelines change, conduct revised surveys; if communication and power pipe blocks add pipe holes, conduct re-exploration; when the changed pipelines are connected to the old pipelines, determine the joint relationship through fieldwork; for variable pipeline data, after supplementary detection, upgrade and store them in the database.

Images