A municipal pipeline planning inspection index analysis method and system thereof

Abstract

The application provides a kind of municipal pipeline planning inspection index analysis method and system thereof, comprising importing data step: importing the design coordinates and measured coordinates of pipeline, connecting design coordinates into design pipeline according to pipeline alignment, connecting measured coordinates into measured pipeline according to pipeline alignment;Deviation calculation step: calculate the lateral deviation value and longitudinal deviation value of each test point of pipeline;According to the positional relationship between test point and design pipeline, the direction of lateral deviation and longitudinal deviation is determined by vector calculation;Report generation step: formulate surveying and mapping achievement report template, automatically write the lateral deviation value, longitudinal deviation value and positional deviation value of each test point into surveying and mapping report together with other project information.The application more intuitively and accurately expresses the degree and direction of plane deviation of municipal pipeline engineering by introducing lateral deviation and longitudinal deviation index, meets the individual needs of regulatory authorities for municipal pipeline engineering, and improves the accuracy and efficiency of planning inspection.

Description

Technical Field

[0001] This invention relates to the field of municipal pipeline planning and inspection technology, specifically to a method and system for analyzing municipal pipeline planning and inspection indicators, aiming to improve the accuracy and efficiency of municipal pipeline planning and inspection, and to meet the personalized needs of regulatory authorities for municipal pipeline projects. Background Technology

[0002] With the accelerated pace of urban infrastructure construction and the overall requirement for intensive development, the utilization of municipal pipeline projects (especially underground pipeline space) is receiving increasing attention. Adopting reasonable indicator testing standards to accurately express the construction status of pipeline projects and their conformity with the application, and precisely reflecting the actual condition of the pipelines, is conducive to optimizing infrastructure layout, intensively utilizing space, avoiding construction damage, ensuring project safety, and promoting the healthy development of urbanization. Planning verification is a surveying process conducted to ensure that the spatial location of the target project, including its plan, elevation, and orientation, conforms to the accuracy of the application plan and meets geometric accuracy requirements (such as planar position error and burial depth error).

[0003] Currently, the mainstream method for planning and inspecting municipal pipelines is the same as that for buildings: comparing planar coordinates to calculate the offset of pipeline feature points. Figure 1 As shown.

[0004] However, in the vertical dimension, municipal pipelines, like buildings, have a difference index as the difference between the measured elevation and the planned design elevation of a characteristic point. This index can intuitively and accurately express the vertical offset of the target point, enabling regulatory authorities to understand whether the target location meets the tolerance requirements in the vertical dimension and the application for construction, and providing data support for the planning, design and construction of other pipeline projects in the vertical dimension.

[0005] However, in the planar dimension, architectural engineering generally uses the method of comparing the planar coordinates of building feature points to determine the difference between the building's reported location and its actual location. This is because buildings are generally planar features, and in the planar dimension, the displacement deviation weights in each direction are the same. By mapping the planar coordinates, the planar displacement of the building relative to its design location can be accurately grasped. In contrast, municipal pipelines are linear features, and the displacement deviation weights of pipeline feature points in each direction are not the same. Regulatory authorities pay more attention to the lateral deviation of the pipeline (perpendicular to the pipeline's direction) for municipal pipeline projects, while having lower or no requirements for the longitudinal deviation (parallel to the pipeline's direction).

[0006] Depend on Figure 1As can be seen from the planar coordinate comparison method, in the planar dimension, the offset of the planar coordinates of feature points changes with the direction of the pipeline. For example, pipelines with large measured lateral deviations have larger deviations in the Y direction when running east-west and larger deviations in the X direction when running north-south. Other directions are even more complex and not easy to distinguish intuitively (in surveying, the X and Y axes of the Cartesian coordinate system and the mathematical coordinate system are interchangeable). Therefore, it is evident that planar coordinate comparison cannot intuitively express the degree of planar deviation of the actual position of the pipeline from the design position, highlight the indicator characteristics of pipeline engineering planning and verification, nor can it meet the personalized needs of regulatory departments for municipal pipeline projects. Summary of the Invention

[0007] To address the problem that existing municipal pipeline planning inspection methods cannot intuitively express the degree of planar deviation between the actual location and the designed location of pipelines in a planar dimension, this invention provides a municipal pipeline planning inspection index analysis method and system. By introducing lateral deviation and longitudinal deviation indices, it more intuitively and accurately expresses the degree and direction of planar offset of municipal pipeline projects, meets the personalized needs of regulatory departments for municipal pipeline projects, and improves the accuracy and efficiency of planning inspection.

[0008] The present invention achieves the above objectives through the following technical solutions: A method for analyzing municipal pipeline planning inspection indicators includes: Data import steps: Import the design coordinates and measured coordinates of the pipeline, connect the design coordinates according to the pipeline direction to form the design pipeline, connect the measured coordinates according to the pipeline direction to form the measured pipeline, and mark the corresponding point numbers on the design pipeline and the measured pipeline respectively to form pairs of points with the same name; Deviation calculation steps: Calculate the lateral and longitudinal deviation values ​​of each test point of the pipeline. The lateral deviation value is the distance from the vertical foot to the corresponding test point, and the longitudinal deviation value is the distance from the vertical foot to the corresponding planning and design point. Based on the positional relationship between the test points and the designed pipelines, the directions of lateral and longitudinal deviations are determined through vector calculations. Report generation steps: Create a surveying and mapping results report template, and automatically write the lateral deviation value, longitudinal deviation value, and positional deviation value of each test point, along with other project information, into the surveying and mapping report.

[0009] According to the method for analyzing municipal pipeline planning inspection indicators provided by the present invention, a vertical line generation step is performed before calculating the lateral and longitudinal deviation values ​​of the inspection points: For straight sections in the designed pipeline, at each test point Draw a perpendicular line to the line connecting the design points, and denote the foot of the perpendicular as . , is the intersection of the perpendicular line and the line connecting the design points; the line connecting the design points is formed by adjacent design points. and Connection formed; If the test point If it is not possible to draw a perpendicular line directly to the line connecting the design points, then draw a perpendicular line on its extension, with the foot of the perpendicular being... The intersection of the perpendicular line and the extension of the line connecting the design point; Among them, the design point is a characteristic point determined in the pipeline planning and design stage, and its spatial position is represented by the design coordinates. The test point is a characteristic point in the measured coordinates, and its spatial position is represented by the measured coordinates, forming a point pair with the design point.

[0010] According to the present invention, a method for analyzing inspection indicators of municipal pipeline planning is provided, which uses test points for arc or transition curve segments in the designed pipeline. Draw a perpendicular line to the tangent at the corresponding planning and design point, with the foot of the perpendicular passing through the test point. The direction of the tangent is determined by drawing a perpendicular line to the tangent line of the segment. The direction of the tangent line is determined by the direction of the tangent line of the arc jointly determined by the planning and design point and the two adjacent arc points or transition curve points. If it is not possible to draw a perpendicular line directly, then draw a perpendicular line on the extension of the tangent line, and the foot of the perpendicular is the intersection of the perpendicular line and the extension of the tangent line.

[0011] According to the present invention, a method for analyzing the inspection indicators of municipal pipeline planning is provided, including the lateral deviation value. Defined as foot of perpendicular To the corresponding test point The distance is calculated using the Euclidean distance formula in a Cartesian coordinate system:

[0012] Longitudinal deviation value Defined as foot of perpendicular To the corresponding planning and design point The distance is calculated using the Euclidean distance formula in a Cartesian coordinate system: .

[0013] According to the present invention, a method for analyzing municipal pipeline planning inspection indicators is provided, wherein the direction of lateral deviation is determined by the vector cross product method, including: Construct vectors for adjacent design points and test points. For adjacent design points... and Construct vector For the testing points and design points Construct vectors ; According to the rules for calculating the cross product of vectors, the cross product of two vectors is calculated as follows: ; Based on the calculated cross product value Determine the direction of lateral deviation. If the deviation is greater than 0, the lateral deviation is considered positive, meaning the test point is located on the right side of the designed pipeline; if... If the value is less than 0, the lateral deviation is determined to be negative, meaning the test point is located on the left side of the designed pipeline.

[0014] According to the method for analyzing the inspection indicators of municipal pipeline planning provided by the present invention, the method for determining the direction of longitudinal deviation includes: Selecting design points As a reference point for determining the direction of longitudinal deviation, two collinear vectors are defined to reflect the longitudinal orientation characteristics of the pipeline. Vector one is from the design point... The previous adjacent design point Pointing to the design point The vector, denoted as . Vector 2 is from the design point The previous adjacent design point The vector pointing to the position of the foot of the perpendicular corresponding to the test point is denoted as... ; Use the dot product operation method for vectors and The directionality of the vectors is determined by the dot product value; if the dot product is greater than zero, then the vectors are considered to be in the same direction. and Same direction, meaning the test point is at the design point. A positive longitudinal deviation indicates that the current centerline point of the completed pipeline is within the planned design point. Before the design point; if the dot product is less than 0, then reverse the direction, meaning the test point is at the design point. A negative longitudinal deviation indicates that the current centerline point of the completed pipeline is located at the planned design point. After that.

[0015] According to the present invention, a method for analyzing inspection indicators of municipal pipeline planning includes a longitudinal deviation judgment rule: The positional relationship between the completed pipeline and the planned pipeline is defined in advance, and the direction of longitudinal deviation is used as the reference direction for determining the longitudinal deviation along the pipeline mileage. When the longitudinal deviation value is greater than 0, it indicates that the current center axis point of the completed pipeline is located before the planned design point. When the longitudinal deviation value is less than 0, it indicates that the current center axis point of the completed pipeline is located after the planned design point. Lateral deviation judgment rules: The direction of increasing pipeline mileage is used as the reference direction for determining lateral deviation; If the lateral deviation value is greater than 0, it indicates that the current center axis point of the completed pipeline is located to the right of the planned pipeline. When the lateral deviation value is less than 0, it indicates that the current center axis point of the completed pipeline is located to the left of the planned pipeline.

[0016] According to the method for analyzing inspection indicators of municipal pipeline planning provided by the present invention, the lateral deviation value with positive and negative signs corresponding to each inspection point is obtained from the deviation calculation step. and longitudinal deviation value These respectively reflect the differences in the positions of the test points relative to the planning and design in the horizontal and vertical directions; According to the Pythagorean theorem, in a right triangle formed by the lateral deviation and the longitudinal deviation, the lateral deviation value... and longitudinal deviation value Consider them as the lengths of the two right-angled sides, and the positional deviation... The length of the hypotenuse is calculated using the following formula:

[0017] Calculated position deviation It is used to comprehensively measure the overall deviation of each test point from its planned and designed location.

[0018] According to the present invention, a method for analyzing the inspection indicators of municipal pipeline planning is provided. Based on the geographical characteristics of the area where the municipal pipeline is located, the accuracy parameters of the measuring instrument, and the experience data of previous similar pipeline measurements, the threshold range of the coordinate data of the inspection point in the horizontal, vertical, and elevation directions is set. Establish a real-time data transmission connection with the measuring instrument, perform real-time detection on the coordinate data of each input test point, and compare the horizontal, vertical and elevation coordinate values ​​of the current test point with the corresponding threshold ranges respectively; if the coordinate value in any direction exceeds the set threshold range, the coordinate data of the test point is determined to be an outlier or gross error; Once abnormal data is detected, the prompt and feedback mechanism is immediately triggered. The display terminal at the measurement site will use color and text to prompt the measurement personnel that the data at the test point is abnormal and indicate the direction of the abnormality. Record abnormal data information in a log file, including at least the test point number, measurement time, and direction of the abnormality.

[0019] A municipal pipeline planning inspection index analysis system, characterized in that, for implementing the aforementioned municipal pipeline planning inspection index analysis method, it includes: Data import module: Used to import the design coordinates and measured coordinates of pipelines, connect the design coordinates according to the pipeline direction to form the design pipeline, connect the measured coordinates according to the pipeline direction to form the measured pipeline, and mark the corresponding point numbers on the design pipeline and the measured pipeline respectively to form pairs of points with the same name; Deviation calculation module: The deviation calculation submodule is used to calculate the lateral and longitudinal deviation values ​​of each inspection point of the pipeline. The lateral deviation value is the distance from the vertical foot to the corresponding inspection point, and the longitudinal deviation value is the distance from the vertical foot to the corresponding planning and design point. The direction determination submodule is used to determine the direction of lateral and longitudinal deviations through vector calculation based on the positional relationship between the test point and the designed pipeline. Report generation module: Used to create surveying and mapping result report templates, automatically writing the lateral deviation, longitudinal deviation, and positional deviation values ​​of each test point, along with other project information, into the surveying and mapping report.

[0020] Therefore, compared with existing technologies, the municipal pipeline planning inspection index analysis method and system proposed in this invention can intuitively and accurately express the degree and direction of planar offset of municipal pipeline projects, meet the personalized needs of regulatory departments for municipal pipeline projects, and improve the accuracy and efficiency of planning inspection. It has the following beneficial effects: 1. For linear projects such as municipal pipelines, the inspection index analysis method proposed in this invention is highly targeted. Traditional methods struggle to intuitively present the deviation of the actual pipeline position from the designed position in a planar dimension. However, by introducing lateral and longitudinal deviation indicators, this invention can clearly and accurately express the degree and direction of planar offset in municipal pipeline projects. For example, in complex urban underground pipe network layouts, regulatory authorities can quickly understand the specific lateral and longitudinal deviations of each pipeline segment, promptly identify potential construction problems, and provide a clear basis for subsequent adjustments and optimizations.

[0021] 2. The inspection index analysis method proposed in this invention can better meet the personalized regulatory needs of administrative departments. Municipal pipelines are linear features, and the displacement deviation weights of pipeline feature points in different directions are not the same. Some regulatory departments pay more attention to the lateral deviation (perpendicular to the pipeline direction) of municipal pipeline projects, while having lower or no requirements for the longitudinal deviation (parallel to the pipeline direction). The traditional method is to determine the actual position deviation of the pipeline by comparing the plane coordinates (X,Y). However, ΔX (north-south deviation) and ΔY (east-west deviation) change continuously with the direction, and the lateral deviation cannot be represented by a single parameter, failing to intuitively express the degree of lateral deviation of the actual pipeline position from the design position.

[0022] 3. This invention more accurately meets the regulatory needs of administrative departments, which have strict requirements for the supervision of municipal pipeline projects and need to have a comprehensive and accurate understanding of the pipeline construction status. The new inspection indicators can provide detailed and specific deviation data, enabling regulatory departments to effectively supervise the construction process based on this data and ensure that municipal pipeline projects meet planning and safety standards. For example, in the acceptance phase of municipal pipelines, regulatory departments can quickly determine whether the pipelines are qualified based on the new inspection indicators, improving acceptance efficiency and accuracy.

[0023] 4. This invention is a planning and inspection system based on the secondary development and customization of EPS (Geographic Information Workstation), providing effective data support for pipeline collision analysis and spacing compliance. In municipal pipeline engineering, collisions and unreasonable spacing between different pipelines can lead to serious safety hazards and construction difficulties. This system can accurately analyze the relative positional relationships between pipelines by automatically calculating lateral and longitudinal deviations, and can detect potential collision risks and spacing problems in advance. For example, in the construction of a comprehensive utility tunnel in a large city, this system was used to inspect and analyze multiple pipelines, successfully avoiding multiple pipeline collisions and insufficient spacing, ensuring the smooth progress of the project.

[0024] 5. This invention facilitates accurate spatial planning. With the acceleration of urbanization and the increasing scarcity of land resources, the rational planning and utilization of underground space is particularly important. The detailed pipeline deviation data provided by the planning verification system can help planning departments better understand the distribution and occupancy of existing pipelines, thereby enabling more scientific pipeline layout in new planning and construction, and improving the efficiency of land use. For example, in the planning of new urban areas, based on the data provided by the system, the direction and location of some pipelines have been rationally adjusted, avoiding redundant construction and wasted space.

[0025] 6. This invention achieves fully automated production operations, greatly reducing reliance on manual labor. Traditional municipal pipeline planning and inspection requires extensive manual data measurement, calculation, and analysis, which is not only inefficient but also prone to human error. The planning and inspection system of this invention can automatically complete a series of tasks such as data import, deviation calculation, and report generation, reducing manual operations and lowering the possibility of errors caused by human factors.

[0026] 7. Automated production operations reduce work difficulty and intensity. The system of this invention is simple and easy to understand to operate. Through a user-friendly interface and automated processes, operators can easily complete various tasks. The automated operation of the planning and inspection system improves the work efficiency and accuracy of operators. The system can quickly and accurately complete various calculation and analysis tasks, generate detailed results reports, and greatly shorten the inspection cycle. At the same time, due to the reduction of human error, the accuracy of inspection results is also significantly improved.

[0027] The present invention will now be described in further detail with reference to the accompanying drawings and specific embodiments. Attached Figure Description

[0028] Figure 1 This is a schematic diagram of the existing technology regarding the planar coordinate comparison method.

[0029] Figure 2 This is a flowchart of an embodiment of the method for analyzing the inspection indicators of municipal pipeline planning according to the present invention.

[0030] Figure 3 This is an example schematic diagram of pipeline inspection in an embodiment of the municipal pipeline planning inspection index analysis method of the present invention.

[0031] Figure 4 This is a schematic diagram of an embodiment of the municipal pipeline planning inspection index analysis system of the present invention.

[0032] Figure 5 This is a schematic diagram of the pipeline planning inspection index after introducing lateral deviation and longitudinal deviation in an embodiment of the municipal pipeline planning inspection index analysis method of the present invention. Detailed Implementation

[0033] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0034] In this document, the term "embodiment" means that a particular feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of this application. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a separate or alternative embodiment mutually exclusive with other embodiments. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0035] An Example of an Analysis Method for Municipal Pipeline Planning Inspection Indicators See Figures 2 to 5 This embodiment provides a method for analyzing municipal pipeline planning inspection indicators, including: Data import steps: Import the design coordinates and measured coordinates of the pipeline, connect the design coordinates according to the pipeline direction to form the design pipeline, connect the measured coordinates according to the pipeline direction to form the measured pipeline, and mark the corresponding point numbers on the design pipeline and the measured pipeline respectively to form pairs of points with the same name; Deviation calculation steps: Calculate the lateral and longitudinal deviation values ​​of each test point of the pipeline. The lateral deviation value is the distance from the vertical foot to the corresponding test point, and the longitudinal deviation value is the distance from the vertical foot to the corresponding planning and design point. Based on the positional relationship between the test points and the designed pipelines, the directions of lateral and longitudinal deviations are determined through vector calculations. Report generation steps: Create a surveying and mapping results report template, and automatically write the lateral deviation value, longitudinal deviation value, and positional deviation value of each test point, along with other project information, into the surveying and mapping report.

[0036] Before calculating the lateral and longitudinal deviation values ​​of the test points, perform the vertical line generation step: For straight sections in the designed pipeline, at each test point Draw a perpendicular line to the line connecting the design points, and denote the foot of the perpendicular as . , is the intersection of the perpendicular line and the line connecting the design points; the line connecting the design points is formed by adjacent design points. and Connection formed; If the test point If it is not possible to draw a perpendicular line directly to the line connecting the design point (e.g., the test point is located outside the extension of the design line segment), then draw a perpendicular line on its extension, with the foot of the perpendicular... The intersection of the perpendicular line and the extension of the line connecting the design point; Among them, the design point is a characteristic point determined in the pipeline planning and design stage, and its spatial position is represented by the design coordinates. The test point is a characteristic point in the measured coordinates, and its spatial position is represented by the measured coordinates, forming a point pair with the design point.

[0037] For arc or gentle curve sections in the pipeline design, use the test points Draw a perpendicular line to the tangent at the corresponding planning and design point, with the foot of the perpendicular passing through the test point. The direction of the tangent is determined by drawing a perpendicular line to the tangent line of the segment. The direction of the tangent line is determined by the direction of the tangent line of the arc jointly determined by the planning and design point and the two adjacent arc points or transition curve points. If it is not possible to draw a perpendicular line directly (such as when the test point is located outside the extension of the tangent line), then draw a perpendicular line on the extension of the tangent line, and the foot of the perpendicular is the intersection of the perpendicular line and the extension of the tangent line.

[0038] In this embodiment, the lateral deviation value Defined as foot of perpendicular To the corresponding test point The distance is calculated using the Euclidean distance formula in a Cartesian coordinate system:

[0039] In this embodiment, the longitudinal deviation value Defined as foot of perpendicular To the corresponding planning and design point The distance is calculated using the Euclidean distance formula in a Cartesian coordinate system:

[0040] The lateral deviation direction is determined using the vector cross product method, including: Construct vectors for adjacent design points and test points. For adjacent design points... and Construct vector For the testing points and design points Construct vectors ; According to the rules for calculating the cross product of vectors, the cross product of two vectors is calculated as follows: ; Based on the calculated cross product value Determine the direction of lateral deviation. If the deviation is greater than 0, the lateral deviation is considered positive, meaning the test point is located on the right side of the designed pipeline, and the direction of determination is the direction of increasing pipeline mileage; if If the value is less than 0, the lateral deviation is determined to be negative, meaning the test point is located on the left side of the designed pipeline. Similarly, the determination is based on the direction of increasing pipeline mileage.

[0041] The methods for determining the direction of longitudinal deviation include: In the planning system of municipal pipelines, any design point with planning positioning characteristics is selected. As a reference point for determining the direction of longitudinal deviation, two collinear vectors are defined to reflect the longitudinal orientation characteristics of the pipeline. Vector one is from the design point... The previous adjacent design point Pointing to the design point J i The vector, denoted as . Vector 2 is from the design point J The previous adjacent design point The vector pointing to the position of the foot of the perpendicular corresponding to the test point (this position is determined based on the pipeline geometry model and the spatial relationship between the test point and the designed pipeline to ensure its reasonable participation in the determination of the longitudinal deviation direction) is denoted as... The selection of these two vectors needs to comprehensively consider the overall pipeline route, local geometric features, and planning requirements to ensure accurate representation of the pipeline at the design point. The longitudinal relationship of the vicinity; Use the dot product operation method for vectors and The directionality of the vectors is determined by the dot product value; if the dot product is greater than zero, then the vectors are considered to be in the same direction. and Same direction, meaning the test point is at the design point. A positive longitudinal deviation indicates that the current centerline point of the completed pipeline is within the planned design point. Before the design point; if the dot product is less than 0, then reverse the direction, meaning the test point is at the design point. A negative longitudinal deviation indicates that the current centerline point of the completed pipeline is located at the planned design point. After that.

[0042] When the longitudinal deviation value is greater than 0 (i.e., longitudinal deviation > 0), it indicates that the current centerline point of the completed pipeline is located before the planned design point. This "before" direction is defined as the direction of increasing pipeline mileage. In specific pipeline planning inspection and analysis, this judgment result means that the completed pipeline is ahead of the planned design point at the corresponding position, providing a key basis for assessing the degree of conformity between pipeline construction progress and planning.

[0043] When the longitudinal deviation value is less than 0 (i.e., longitudinal deviation < 0), it means that the current centerline point of the completed pipeline is located after the planned design point, also with reference to the direction of increasing pipeline mileage. This result reflects that the completed pipeline lags behind the planned design point at the corresponding location, which helps to identify potential schedule delays or other related problems during construction.

[0044] If the lateral deviation value is greater than 0, it indicates that the current centerline point of the completed pipeline is located to the right of the planned pipeline. Here, "right" is determined by the direction of increasing pipeline mileage. This determination clearly shows the lateral offset of the completed pipeline relative to the planned pipeline, providing a clear standard for checking whether pipeline construction followed the planned lateral position.

[0045] When the lateral deviation value is less than 0, i.e., lateral deviation < 0, it indicates that the current centerline point of the completed pipeline is located to the left of the planned pipeline, still based on the direction of increasing pipeline mileage. This result helps to identify potential leftward offset issues during lateral pipeline construction, providing a reference for timely adjustment and correction of construction deviations.

[0046] In this embodiment, the lateral deviation value with positive and negative signs corresponding to each test point is obtained from the deviation calculation step. and longitudinal deviation value ,in i Indicates the number of the test point. , n This represents the total number of test points, reflecting the differences in their positions relative to the planning and design in both the horizontal and vertical directions. According to the Pythagorean theorem, in a right triangle formed by the lateral deviation and the longitudinal deviation, the lateral deviation value... and longitudinal deviation value Consider them as the lengths of the two right-angled sides, and the positional deviation... The length of the hypotenuse is calculated using the following formula:

[0047] For each test point, the obtained lateral and longitudinal deviation values ​​are substituted into the above formula for calculation. Since the formula sums the squares of the lateral and longitudinal deviation values ​​and then takes the square root, regardless of the original positive or negative signs of the lateral and longitudinal deviation values, the calculated positional deviation will be... It is always a positive value.

[0048] Calculated position deviation It is used to comprehensively measure the overall deviation of each test point from the planned design position. By comparing the positional deviation of different test points, the construction accuracy of the pipeline at different positions can be intuitively understood.

[0049] In this embodiment, based on the geographical characteristics of the area where the municipal pipeline is located, the accuracy parameters of the measuring instruments, and experience data from previous measurements of similar pipelines, threshold ranges for the coordinate data of the test points in the horizontal, vertical, and elevation directions are set. For example, in flat areas, considering the measurement accuracy of the total station, the threshold ranges for the horizontal and vertical coordinates are set to ±[L] and ±[D] cm, respectively; for the elevation direction, considering the accuracy of the level instrument and the terrain undulations, the threshold range is set to ±[H] cm; if the pipeline is located in a complex terrain area, such as a mountainous area or a soft soil foundation area, the threshold range will be dynamically adjusted based on field survey data and expert experience.

[0050] Establish a real-time data transmission connection with the measuring instrument to ensure that the coordinate data of the measured test points can be transmitted to the automatic verification algorithm system in a timely and accurate manner.

[0051] The system performs real-time detection on the coordinate data of each input test point, comparing the horizontal, vertical, and elevation coordinates of the current test point with the corresponding threshold ranges. If the coordinate value in any direction exceeds the set threshold range, the coordinate data of the test point is determined to be an outlier or gross error. For example, if the horizontal coordinate value of a test point exceeds ±[L] centimeters, the system immediately marks it as outlier data.

[0052] Once abnormal data is detected, the system immediately triggers a prompt and feedback mechanism. The display terminal at the measurement site uses color (e.g., red) and text to alert the surveyors that the data at the measurement point is abnormal, clearly indicating the direction of the anomaly, such as horizontal, vertical, or elevation. Simultaneously, the system can provide possible cause analysis and suggestions, such as, "This may be due to instrument vibration; please stabilize the instrument and measure again." Furthermore, the system will record the abnormal data information in a log file, including detailed information such as the measurement point number, measurement time, and direction of the anomaly, for data quality analysis and traceability.

[0053] In practical applications, most GIS software can automatically obtain the coordinates of feature points. The difference between the design coordinates (X, Y) and measured coordinates (X, Y) of the same point number can be obtained. However, lateral and longitudinal deviations are not considered basic data and require additional functionality. Therefore, this embodiment utilizes EPS (Geographic Information Workstation) for secondary development. First, the coordinates of the design pipeline and the measured pipeline are imported and connected into lines according to the pipeline's direction. Then, the design pipeline and the measured pipeline points are labeled to form pairs of points with the same name. Finally, a function is developed to automatically draw perpendicular lines from each measured point of the pipeline to the line connecting to the design point (for points where direct perpendicular lines are not possible, perpendicular lines are drawn on their extensions), obtaining the foot of the perpendicular. The lateral deviation is the distance from the vertical foot to the pipeline inspection point, and the longitudinal deviation is the distance from the vertical foot to the pipeline planning and design point. Figure 3 As shown.

[0054] For circular arcs and transition curves, a perpendicular line is drawn from the tangent of the test point to the corresponding planning and design point (if a perpendicular line cannot be drawn directly, it can be drawn on the extension of the tangent). The tangent of the planning and design point is determined by the circle formed by the point and the two adjacent circular arc points or transition curve points.

[0055] Then, the lateral and longitudinal deviation values ​​of the test points are calculated, and their positive and negative signs are determined based on the positional relationship between the test points and the designed pipeline. The feet of the perpendiculars are obtained by drawing perpendicular lines from the lines connecting each test point to the design point (or, if a direct perpendicular cannot be drawn, by drawing a perpendicular line on its extension). The lateral deviation is the distance from the vertical foot to the pipeline inspection point, and the longitudinal deviation is the distance from the vertical foot to the pipeline planning and design point. The values ​​are obtained by calculating the distance based on the coordinates of the three points.

[0056] To more accurately and intuitively express the positional relationship between the test points and the designed pipelines, this embodiment imposes the following constraints on the positive and negative signs of longitudinal and lateral deviations: Longitudinal deviation > 0 indicates that the current centerline point of the completed pipeline is located before the planned design point (in the direction of increasing mileage). Longitudinal deviation < 0 indicates that the current centerline point of the completed pipeline is located after the planned design point (along the direction of increasing mileage). Lateral deviation > 0 indicates that the current centerline point of the completed pipeline is located to the right of the planned pipeline (facing the direction of increasing mileage). Lateral deviation < 0 indicates that the current centerline point of the completed pipeline is located to the left of the planned pipeline (facing the direction of increasing mileage). As can be seen from the above constraints, the sign of the longitudinal and lateral deviations is based on the pipeline design location and direction. Therefore, during functional development, the determination of the sign is compared with the design pipeline.

[0057] In surveying, the X and Y axes of a Cartesian coordinate system are opposite to those of a mathematical coordinate system. The vertical axis is the X-axis, with north as positive, and the horizontal axis is the Y-axis, with east as positive. Figure 3 As shown, this embodiment is based on the Cartesian coordinate system in surveying, and the sign of its lateral deviation is opposite to that of the mathematical coordinate system.

[0058] For longitudinal deviation, Taking points as an example, determine collinear vectors and Whether they are in the same direction; if they are in the same direction, the longitudinal deviation is positive; otherwise, it is negative. For lateral deviation, the cross product method is used to determine it. The orientation of the point is determined by calculating the sign of the cross product. Taking a point as an example, determine its relationship with the design direction using the following methods. , Positional relationship.

[0059] The pipeline design route starts from point and Confirmed, the point to be judged is the measured point. Construct vector and .

[0060] Calculate the cross product value : If M < 0: point C is to the left of the line; If M > 0: point C is on the right side of the line; If M=0: point C lies on the straight line.

[0061] Finally, a template for the surveying results report was developed, which included the lateral and longitudinal deviation values ​​of each test point with positive and negative signs, and the positional deviation calculated according to the Pythagorean theorem (fixed as a positive value). This, along with other entered project information, was written into the surveying report.

[0062] Furthermore, the method for determining whether a test point can be directly perpendicular to is described in this embodiment includes the following key steps and judgment criteria: The projection parameter t is set as the decisive condition for determining the position of the perpendicular point, based on the endpoints of the designed line segment. , , measured points Where the foot of the perpendicular is H, the projection parameter t is determined by the following method, and the position of the perpendicular point is determined based on its range: The value of the projection parameter t is calculated using the following formula:

[0063] This formula can accurately determine the specific value of the projection parameter t, providing crucial data support for determining the position of the perpendicular point.

[0064] Based on the calculated range of projection parameter t, the position of the perpendicular foot H is determined according to the judgment rules shown in Table 1, thereby determining whether a perpendicular line cannot be directly drawn: Table 1: Judgment Rules

[0065] The judgment results regarding whether a perpendicular line cannot be directly drawn at the aforementioned perpendicular point location are recorded in real time in the municipal pipeline planning and inspection database. Recorded information includes, but is not limited to, the inspection point number, coordinates of the design line segment endpoints, coordinates of the measured point, projection parameter t-value, perpendicular point location judgment result, and judgment time. Simultaneously, corresponding prompts are generated based on the judgment results, providing clear guidance for subsequent operations in municipal pipeline planning and inspection work. For example, when a perpendicular line cannot be directly drawn, it prompts inspectors to adopt other appropriate inspection methods or conduct further data analysis. This method can effectively improve the accuracy and efficiency of municipal pipeline planning and inspection work, reduce inspection errors and work delays caused by inaccurate judgments, and provide reliable technical support for the construction and management of municipal pipeline projects.

[0066] Furthermore, the method for calculating the perpendicular coordinates in this embodiment includes the following specific calculation steps and formula applications: The coordinates of the two endpoints of the design line segment are set as follows: , The measured coordinates are , seek the foot as .

[0067] Calculate the intermediate parameters a, b, and c, where , , ; Calculate the x-coordinate of the foot of the perpendicular H using the following formula:

[0068] Calculate the ordinate of the foot of the perpendicular H using the following formula:

[0069] In practical software applications, the above formula can be used to directly calculate the coordinates of the perpendicular foot. There is no need to additionally determine whether the perpendicular foot is on the line segment. After calculating the coordinates of the perpendicular foot, it is connected with the corresponding corresponding point to obtain the longitudinal and lateral deviations. This provides key data support for the inspection of municipal pipeline planning, meets the data accuracy requirements of municipal pipeline planning inspection, and helps to improve the efficiency and reliability of municipal pipeline planning inspection.

[0070] An Example of a Municipal Pipeline Planning Inspection Index Analysis System like Figure 4 As shown in the figure, this embodiment provides a municipal pipeline planning inspection index analysis system to implement the above-mentioned municipal pipeline planning inspection index analysis method, including: Data import module: Used to import the design coordinates and measured coordinates of pipelines, connect the design coordinates according to the pipeline direction to form the design pipeline, connect the measured coordinates according to the pipeline direction to form the measured pipeline, and mark the corresponding point numbers on the design pipeline and the measured pipeline respectively to form pairs of points with the same name; Deviation calculation module: The perpendicular line generation submodule is used to draw perpendicular lines from the lines connecting each test point to the design point to obtain the lateral and longitudinal deviations. For cases where a perpendicular line cannot be drawn directly, a perpendicular line is drawn on its extension line. For arcs and transition curves, a perpendicular line is drawn from the tangent line from the test point to the corresponding planning and design point. If a perpendicular line cannot be drawn directly, a perpendicular line is drawn on the extension line of its tangent line. The deviation calculation submodule is used to calculate the lateral and longitudinal deviation values ​​of each inspection point of the pipeline. The lateral deviation value is the distance from the vertical foot to the corresponding inspection point, and the longitudinal deviation value is the distance from the vertical foot to the corresponding planning and design point. The direction determination submodule is used to determine the direction of lateral and longitudinal deviations through vector calculation based on the positional relationship between the test point and the designed pipeline. Report generation module: Used to create surveying and mapping result report templates, automatically writing the lateral deviation, longitudinal deviation, and positional deviation values ​​of each test point, along with other project information, into the surveying and mapping report.

[0071] In the vertical line generation submodule, for each straight segment in the designed pipeline, at each test point... Draw a perpendicular line to the line connecting the design points, and denote the foot of the perpendicular as . , is the intersection of the perpendicular line and the line connecting the design points; the line connecting the design points is formed by adjacent design points. and Connection formed; If the test point If it is not possible to draw a perpendicular line directly to the line connecting the design point (e.g., the test point is located outside the extension of the design line segment), then draw a perpendicular line on its extension, with the foot of the perpendicular... The intersection of the perpendicular line and the extension of the line connecting the design point; Among them, the design point is the characteristic point determined in the pipeline planning and design stage, and its spatial location is represented by the design coordinates. The test point is the characteristic point in the measured coordinates, forming a point pair with the design point.

[0072] For arc or gentle curve sections in the pipeline design, use the test points Draw a perpendicular line to the tangent at the corresponding planning and design point, with the foot of the perpendicular passing through the test point. The direction of the tangent is determined by drawing a perpendicular line to the tangent line of the segment. The direction of the tangent line is determined by the direction of the tangent line of the arc jointly determined by the planning and design point and the two adjacent arc points or transition curve points. If it is not possible to draw a perpendicular line directly (such as when the test point is located outside the extension of the tangent line), then draw a perpendicular line on the extension of the tangent line, and the foot of the perpendicular is the intersection of the perpendicular line and the extension of the tangent line.

[0073] The technical features of the above embodiments can be combined in any way. For the sake of brevity, 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, they should be considered to be within the scope of this specification.

[0074] The above embodiments are merely preferred embodiments of the present invention and should not be construed as limiting the scope of protection of the present invention. Any non-substantial changes and substitutions made by those skilled in the art based on the present invention shall fall within the scope of protection claimed by the present invention.

Claims

1. A method for analyzing inspection indicators of municipal pipeline planning, characterized in that, include: Data import steps: Import the design coordinates and measured coordinates of the pipeline, connect the design coordinates according to the pipeline direction to form the design pipeline, connect the measured coordinates according to the pipeline direction to form the measured pipeline, and mark the corresponding point numbers on the design pipeline and the measured pipeline respectively to form pairs of points with the same name; Deviation calculation steps: Calculate the lateral and longitudinal deviation values ​​of each test point of the pipeline. The lateral deviation value is the distance from the vertical foot to the corresponding test point, and the longitudinal deviation value is the distance from the vertical foot to the corresponding planning and design point. Based on the positional relationship between the test points and the designed pipelines, the directions of lateral and longitudinal deviations are determined through vector calculations. Report generation steps: Create a surveying and mapping results report template, and automatically write the lateral deviation value, longitudinal deviation value, and positional deviation value of each test point, along with other project information, into the surveying and mapping report.

2. The method according to claim 1, characterized in that, Before calculating the lateral and longitudinal deviation values ​​of the test points, perform the vertical line generation step: For straight sections in the designed pipeline, at each test point Draw a perpendicular line to the line connecting the design points, and denote the foot of the perpendicular as . , is the intersection of the perpendicular line and the line connecting the design point; The design point connection line is formed by adjacent design points. and Connection formed; If the test point If it is not possible to draw a perpendicular line directly to the line connecting the design points, then draw a perpendicular line on its extension, with the foot of the perpendicular being... The intersection of the perpendicular line and the extension of the line connecting the design point; Among them, the design point is a characteristic point determined in the pipeline planning and design stage, and its spatial position is represented by the design coordinates. The test point is a characteristic point in the measured coordinates, and its spatial position is represented by the measured coordinates, forming a point pair with the design point.

3. The method according to claim 2, characterized in that: For arc or gentle curve sections in the pipeline design, use the test points Draw a perpendicular line to the tangent at the corresponding planning and design point, with the foot of the perpendicular passing through the test point. The direction of the tangent is determined by drawing a perpendicular line to the tangent line of the segment. The direction of the tangent line is determined by the direction of the tangent line of the arc jointly determined by the planning and design point and the two adjacent arc points or transition curve points. If it is not possible to draw a perpendicular line directly, then draw a perpendicular line on the extension of the tangent line, and the foot of the perpendicular is the intersection of the perpendicular line and the extension of the tangent line.

4. The method according to claim 3, characterized in that: Lateral deviation value Defined as foot of perpendicular To the corresponding test point The distance is calculated using the Euclidean distance formula in a Cartesian coordinate system: ； Longitudinal deviation value Defined as foot of perpendicular To the corresponding planning and design point The distance is calculated using the Euclidean distance formula in a Cartesian coordinate system: 。 5. The method according to claim 4, characterized in that, The direction of lateral deviation is determined using the vector cross product method, including: Construct vectors for adjacent design points and test points. For adjacent design points... and Construct vector For the testing points and design points Construct vectors ; According to the rules for calculating the cross product of vectors, the cross product of two vectors is calculated as follows: ； Based on the calculated cross product value Determine the direction of lateral deviation. If the deviation is greater than 0, the lateral deviation is considered positive, meaning the test point is located on the right side of the designed pipeline; if... If the value is less than 0, the lateral deviation is determined to be negative, meaning the test point is located on the left side of the designed pipeline.

6. The method according to claim 4, characterized in that, Methods for determining the direction of longitudinal deviation include: Selecting design points As a reference point for determining the direction of longitudinal deviation, two collinear vectors are defined to reflect the longitudinal orientation characteristics of the pipeline. Vector one is from the design point... The previous adjacent design point Pointing to the design point The vector, denoted as . Vector 2 is from the design point The previous adjacent design point The vector pointing to the position of the foot of the perpendicular corresponding to the test point is denoted as... ; Use the dot product operation method for vectors and The directionality of the vectors is used to determine if the dot product value is greater than zero. and Same direction, meaning the test point is at the design point. A positive longitudinal deviation indicates that the current centerline point of the completed pipeline is within the planned design point. Before the design point; if the dot product is less than 0, then reverse the direction, meaning the test point is at the design point. A negative longitudinal deviation indicates that the current centerline point of the completed pipeline is located at the planned design point. After that.

7. The method according to any one of claims 1 to 6, characterized in that: Longitudinal deviation judgment rules: The positional relationship between the completed pipeline and the planned pipeline is defined in advance, and the direction of longitudinal deviation is used as the reference direction for determining the longitudinal deviation along the pipeline mileage. When the longitudinal deviation value is greater than 0, it indicates that the current center axis point of the completed pipeline is located before the planned design point. When the longitudinal deviation value is less than 0, it indicates that the current center axis point of the completed pipeline is located after the planned design point. Lateral deviation judgment rules: The direction of increasing pipeline mileage is used as the reference direction for determining lateral deviation; If the lateral deviation value is greater than 0, it indicates that the current center axis point of the completed pipeline is located to the right of the planned pipeline. When the lateral deviation value is less than 0, it indicates that the current center axis point of the completed pipeline is located to the left of the planned pipeline.

8. The method according to any one of claims 1 to 6, characterized in that: From the deviation calculation steps, obtain the lateral deviation value with positive and negative signs corresponding to each test point. and longitudinal deviation value These respectively reflect the differences in the positions of the test points relative to the planning and design in the horizontal and vertical directions; According to the Pythagorean theorem, in a right triangle formed by the lateral deviation and the longitudinal deviation, the lateral deviation value... and longitudinal deviation value Consider them as the lengths of the two right-angled sides, and the positional deviation... The length of the hypotenuse is calculated using the following formula: ； Calculated position deviation It is used to comprehensively measure the overall deviation of each test point from its planned and designed location.

9. The method according to any one of claims 1 to 6, characterized in that: Based on the geographical features of the area where the municipal pipeline is located, the accuracy parameters of the measuring instruments, and the experience data of previous measurements of similar pipelines, threshold ranges for the coordinate data of the test points in the horizontal, vertical, and elevation directions are set. Establish a real-time data transmission connection with the measuring instrument, perform real-time detection on the coordinate data of each input test point, and compare the horizontal, vertical and elevation coordinate values ​​of the current test point with the corresponding threshold ranges respectively; if the coordinate value in any direction exceeds the set threshold range, the coordinate data of the test point is determined to be an outlier or gross error; Once abnormal data is detected, the prompt and feedback mechanism is immediately triggered. The display terminal at the measurement site will use color and text to prompt the measurement personnel that the data at the test point is abnormal and indicate the direction of the abnormality. Record abnormal data information in a log file, including at least the test point number, measurement time, and direction of the abnormality.

10. A municipal pipeline planning inspection index analysis system, characterized in that, A method for analyzing municipal pipeline planning inspection indicators according to any one of claims 1-9 includes: Data import module: Used to import the design coordinates and measured coordinates of pipelines, connect the design coordinates according to the pipeline direction to form the design pipeline, connect the measured coordinates according to the pipeline direction to form the measured pipeline, and mark the corresponding point numbers on the design pipeline and the measured pipeline respectively to form pairs of points with the same name; Deviation calculation module: The deviation calculation submodule is used to calculate the lateral and longitudinal deviation values ​​of each inspection point of the pipeline. The lateral deviation value is the distance from the vertical foot to the corresponding inspection point, and the longitudinal deviation value is the distance from the vertical foot to the corresponding planning and design point. The direction determination submodule is used to determine the direction of lateral and longitudinal deviations through vector calculation based on the positional relationship between the test point and the designed pipeline. Report generation module: Used to create surveying and mapping result report templates, automatically writing the lateral deviation, longitudinal deviation, and positional deviation values ​​of each test point, along with other project information, into the surveying and mapping report.

Images