Underground pipeline renewal method

Abstract

The present invention relates to an underground pipeline updating method, belonging to the field of underground pipeline technology. It solves the problems in the prior art where pipeline data nodes are not marked and manual updating is time-consuming and labor-intensive when new pipeline data is added. The updating method includes: dividing the original pipeline segment vector data using newly added inflection points to obtain second-line vector data; judging whether there are newly added span points based on the newly added pipeline segment vector data and the second-line vector data to obtain first-line vector data; renumbering all pipeline segments in the first-line vector data; generating data corresponding to two endpoint pairs of each pipeline segment based on the first-line vector data, namely second-point vector data; numbering the pipeline points in the first-line vector data based on the original pipeline point vector data and the newly added pipeline point vector data to obtain third-point vector data; and determining the starting and ending directions corresponding to each pipeline segment in the second-point vector data based on the third-point vector data to obtain new pipeline data. This achieves the updating of the original pipeline data.

Description

Technical Field

[0001] The present invention relates to the technical field of underground pipelines, and in particular to an underground pipeline updating method. Background Art

[0002] Urban underground pipelines are a crucial component of urban underground municipal infrastructure. Their construction is a crucial foundation for the safe and orderly operation of cities and a key component of their high-quality development. Urban underground pipelines primarily include water supply, stormwater, sewage, gas, and other pipelines, as well as their ancillary facilities. Pipeline data forms the foundation for pipeline analysis and visualization applications.

[0003] Urban underground pipeline networks can be abstracted as a "pipeline point-segment" mathematical model. Existing technologies primarily employ a "two-point-one-line" data structure. Pipeline vector data consists of lines with pipeline segment attributes and coordinate information, and node data with pipeline point attributes and coordinate information. Some two-dimensional vector data for urban underground pipelines may have unmarked key inflection points, meaning that multiple continuous directed lines may be grouped into a single pipeline segment. Furthermore, when new pipeline data is added to the pipeline network, the existing pipeline data must be updated based on the newly added data.

[0004] In existing technologies, addressing the issue of unlabeled nodes in pipeline data is often done by ignoring these unlabeled points or manually calibrating each line. Ignoring key nodes inevitably impacts modeling and analysis results, while manual calibration is time-consuming and inefficient. Furthermore, replacing a new set of data is like starting over from scratch, making manual calibration unscalable.

[0005] When new pipeline data appears, it is also necessary to manually merge the newly added pipeline data with the original pipeline data and update the pipeline network, which is time-consuming, labor-intensive and inefficient. Summary of the Invention

[0006] In view of the above analysis, an embodiment of the present invention aims to provide an underground pipeline updating method to solve the problems in the prior art of pipeline data nodes not being marked and time-consuming and labor-intensive manual updating when adding new pipeline data.

[0007] An embodiment of the present invention provides an underground pipeline updating method, the updating method comprising:

[0008] Obtaining original pipeline data, newly added pipeline data, and newly added inflection points; the pipeline data includes pipeline segment vector data and pipeline point vector data;

[0009] The original pipeline segment vector data is divided using the newly added inflection points to obtain second line vector data; based on the newly added pipeline segment vector data and the second line vector data, it is determined whether there is a newly added span point; if so, the pipeline segments in the second line vector data and the newly added pipeline segment vector data are divided using the newly added span point to obtain first line vector data; if not, the second line vector data and the newly added pipeline segment vector data are used as the first line vector data; and all pipeline segments in the first line vector data are renumbered;

[0010] Based on the first line vector data, generating data of two endpoint pairs corresponding to each pipeline segment, namely, second point vector data;

[0011] Numbering the pipeline points in the first line vector data according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data;

[0012] The starting and ending directions corresponding to each pipeline segment in the second point vector data are determined according to the third point vector data to obtain new pipeline data.

[0013] According to a further improvement of the above method, the determining whether there is a newly added span point based on the newly added pipeline segment vector data and the second line vector data includes:

[0014] The pipeline segments in the newly added pipeline segment vector data and the pipeline segments in the second line vector data are projected onto the same horizontal plane to obtain the projection of each pipeline segment; if the projection of the pipeline segment in the newly added pipeline segment vector data and the projection of the pipeline segment in the second line vector data have an intersection, it is determined that a newly added span point exists, and the span point is obtained based on the intersection point.

[0015] Based on a further improvement of the above method, the dividing the original pipeline segment vector data by using the newly added inflection point includes: using the newly added inflection point as a dividing point to divide the pipeline segment in the original pipeline segment vector data where the newly added inflection point exists;

[0016] The dividing the pipeline segments in the second line vector data and the newly added pipeline segment vector data by using the newly added span point includes: dividing the pipeline segments in the second line vector data and the newly added pipeline segment vector data where the newly added span point exists by using the newly added span point as a dividing point;

[0017] The line attribute values ​​of each pipeline segment before division are assigned to each pipeline segment after division; the line attribute values ​​include a starting point number and an end point number.

[0018] Based on a further improvement of the above method, the step of assigning the line attribute values ​​of each pipeline segment before division to each pipeline segment after division includes:

[0019] If a pipeline segment is not split after division, its line attribute value remains unchanged;

[0020] If a pipeline segment is divided into multiple pipeline segments after division, the line attribute value of the pipeline segment before division is assigned to the multiple pipeline segments obtained by division.

[0021] Based on a further improvement of the above method, the pipeline points in the first line vector data are numbered according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data, including:

[0022] Based on the first line vector data, using a network analysis tool to generate data of all pipeline points in the first line vector data to obtain first point vector data;

[0023] Based on the original pipeline point vector data and the newly added pipeline point vector data, the first point vector data is numbered to obtain third point vector data.

[0024] Based on a further improvement of the above method, the first point vector data is numbered based on the original pipeline point vector data and the newly added pipeline point vector data to obtain the third point vector data, including:

[0025] Finding, in the first point vector data, pipeline points whose position coordinates are the same as those in the original pipeline point vector data and the newly added pipeline point vector data as old pipeline points, and assigning point attribute values ​​of each point in the original pipeline point vector data and the newly added pipeline point vector data to each corresponding old pipeline point, wherein the point attribute values ​​include geophysical prospecting point numbers;

[0026] The pipeline points other than the old pipeline points in the first point vector data are used as newly divided pipeline points, and the geophysical prospecting point numbers of the newly divided pipeline points are numbered to obtain the third point vector data.

[0027] Based on a further improvement of the above method, the point attribute value further includes one or more of the following:

[0028] Ground elevation SURF_H;

[0029] FeaturesFEATURE;

[0030] appendageSUBSID;

[0031] LocationLOCATION.

[0032] Based on a further improvement of the above method, determining the starting and ending directions corresponding to each pipeline segment in the second point vector data according to the third point vector data to obtain new pipeline data includes:

[0033] Finding pipeline points in the second point vector data with position coordinates identical to those in the third point vector data, mapping point attribute values ​​of the pipeline points with the same position coordinates in the third point vector data to corresponding pipeline points in the second point vector data, and obtaining geophysical prospecting point numbers of the mapped pipeline points;

[0034] Determine the final starting point number and ending point number corresponding to each pipeline segment in the second point vector data based on the starting point number and ending point number of each pipeline segment in the second point vector data before mapping and the geophysical prospecting point numbers of the two end points of each pipeline segment after mapping, obtain the pipeline segment number and its starting point number and ending point number of each pipeline segment, and further process them as pipeline segment vector data in the new pipeline data;

[0035] The third point vector data is used as the pipeline point vector data in the new pipeline data.

[0036] Based on a further improvement of the above method, the method of determining the final starting point number and ending point number corresponding to each pipeline segment in the second point vector data according to the starting point number and ending point number of each pipeline segment in the second point vector data before mapping and the geophysical prospecting point numbers of the two end points of each pipeline segment after mapping includes:

[0037] If E_Origin[i]=Point[i]_1 and S_Origin[i]=Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2;

[0038] If E_Origin[i]=Point[i]_2 and S_Origin[i]=Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1;

[0039] Among them, E_Origin[i] represents the end point number of the i-th pipeline segment before mapping, S_Origin[i] represents the starting point number of the i-th pipeline segment before mapping; Point[i]_1 represents the geophysical exploration point number of one end point of the i-th pipeline segment after mapping, Point[i]_2 represents the geophysical exploration point number of the other end point of the i-th pipeline segment after mapping; End_Point[i] represents the final end point number of the i-th pipeline segment, and Strart_Point[i] represents the final starting point number of the i-th pipeline segment.

[0040] Based on a further improvement of the above method, the method further includes determining the final starting point number and ending point number corresponding to each pipeline segment in the second point vector data according to the starting point number and ending point number of each pipeline segment in the second point vector data before mapping and the geophysical prospecting point numbers of the two end points of each pipeline segment after mapping, further comprising:

[0041] If E_Origin[i]=Point[i]_1 and S_Origin[i]≠Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2;

[0042] If E_Origin[i]≠Point[i]_1 and S_Origin[i]=Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2;

[0043] If E_Origin[i]≠Point[i]_2 and S_Origin[i]=Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1;

[0044] If E_Origin[i]=Point[i]_2 and S_Origin[i]≠Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1;

[0045] If E_Origin[i]≠Point[i]_2 and S_Origin[i]≠Point[i]_1, then determine End_Point[i] and Start_Point[i] according to the topological relationship rules.

[0046] Compared with the prior art, the present invention can achieve at least one of the following beneficial effects:

[0047] 1. The present invention uses newly added inflection points and newly added span points to re-divide the pipeline segments in the original pipeline segment vector data and the newly added pipeline segment vector data, renumbers the pipeline segment numbers of each divided pipeline segment, and determines the starting and ending directions corresponding to each divided pipeline segment, thereby realizing the update of pipeline data.

[0048] 2. The present invention intelligently generates unmarked span points in the original pipeline data and the newly added pipeline data, avoiding manual inspection of pipeline segments one by one, improving the efficiency of data processing, and providing an intelligent, efficient, replicable and scalable pipeline data update method.

[0049] In the present invention, the above-mentioned technical solutions can be combined with each other to achieve more preferred combinations. Other features and advantages of the present invention will be described in the following description, and some advantages will become apparent from the description or be learned through practice of the present invention. The objectives and other advantages of the present invention can be realized and obtained through the contents particularly pointed out in the description and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] The accompanying drawings are only for the purpose of illustrating particular embodiments and are not to be considered limiting of the present invention. Like reference symbols denote like parts throughout the drawings.

[0051] Figure 1 A schematic flow chart of an underground pipeline updating method provided by an embodiment of the present invention;

[0052] Figure 2 A schematic diagram of the pipeline network "breakpoints" provided by an embodiment of the present invention;

[0053] Figure 3 A schematic diagram of a “newly added inflection point” in a pipeline network provided by an embodiment of the present invention;

[0054] Figure 4 A schematic diagram of a “newly added span” in a pipeline network provided by an embodiment of the present invention;

[0055] Figure 5 One of the schematic diagrams of the pipeline network provided in an embodiment of the present invention;

[0056] Figure 6 One of the schematic diagrams for numbering pipeline points provided in an embodiment of the present invention;

[0057] Figure 7 The second schematic diagram of numbering pipeline points provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0058] The preferred embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings, wherein the accompanying drawings constitute a part of this application and are used together with the embodiments of the present invention to illustrate the principles of the present invention, and are not used to limit the scope of the present invention.

[0059] A specific embodiment of the present invention discloses a method for updating underground pipelines, such as Figure 1 As shown, the updating method includes:

[0060] Step S1: obtaining original pipeline data, newly added pipeline data, and newly added inflection points; the pipeline data includes pipeline segment vector data and pipeline point vector data;

[0061] Step S2: using the newly added inflection points to divide the original pipeline segment vector data to obtain second line vector data; based on the newly added pipeline segment vector data and the second line vector data, determining whether there are newly added span points; if so, using the newly added span points to divide the pipeline segments in the second line vector data and the newly added pipeline segment vector data to obtain first line vector data; if not, using the second line vector data and the newly added pipeline segment vector data as the first line vector data; and renumbering all pipeline segments in the first line vector data;

[0062] Step S3: Based on the first line vector data, generating data of two endpoint pairs corresponding to each pipeline segment, i.e., second point vector data;

[0063] Step S4: numbering the pipeline points in the first line vector data according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data;

[0064] Step S5: determining the starting and ending directions corresponding to each pipeline segment in the second point vector data according to the third point vector data, and obtaining new pipeline data.

[0065] Specifically, if Figure 1 As shown, in step S1, the original pipeline data includes the original pipeline segment vector data WSLINE1 and the original pipeline point vector data WSPOINT1 files. The original pipeline point vector data is the node in the original pipeline data, and the original pipeline segment vector data is the pipeline segment in the original pipeline data. The newly added pipeline data includes the newly added pipeline segment vector data WSLINE2 and the newly added pipeline point vector data WSPOINT2. The newly added pipeline point vector data is the node in the newly added pipeline data, and the newly added pipeline segment vector data is the pipeline segment in the newly added pipeline data.

[0066] Specifically, the inflection point represents the node in the middle part when multiple continuous directed line segments in the pipeline segment vector data are divided into one pipeline segment. Figure 2 As shown, in the pipeline segment P1P2, P1P2 is regarded as a pipeline segment, and the inflection points refer to P3 and P4.

[0067] It is worth noting that the newly added pipeline segment in the embodiment of the present invention does not have a breakpoint, that is, the breakpoint only exists on the pipeline segment in the original pipeline data.

[0068] It can be understood that the original pipeline data represents the historical pipeline data, the newly added pipeline data represents the newly imported pipeline data, and the newly added inflection point represents the newly added node based on any pipeline segment of the original pipeline data. Figure 3 As shown in the figure, there is a pipeline segment A1A2 in the original pipeline data, the pipeline points are A1 and A2, and the newly added inflection points represent B9 and B10. Figure 4 As shown, pipeline segment A3A4 is a pipeline segment in the original pipeline data, and pipeline segment C7C8 is a pipeline segment in the newly added pipeline data. Figure 5 As shown, pipeline segment A5A6 is a pipeline segment in the original pipeline data.

[0069] Specifically, in step S2, the original pipeline segment vector data is divided using the newly added inflection points to obtain second line vector data; based on the newly added pipeline segment vector data and the second line vector data, it is determined whether there are newly added span points; if so, the pipeline segments in the second line vector data and the newly added pipeline segment vector data are divided using the newly added span points to obtain first line vector data; if not, the second line vector data and the newly added pipeline segment vector data are used as the first line vector data; and all pipeline segments in the first line vector data are renumbered.

[0070] Preferably, the dividing the original pipeline segment vector data by using the newly added inflection point includes: using the newly added inflection point as a dividing point to divide the pipeline segment in the original pipeline segment vector data having the newly added inflection point.

[0071] For example, Figure 3 As shown, the pipeline segment A1A2 in the original pipeline data is divided using the newly added inflection points B9 and B10, with the newly added inflection points B9 and B10 as the dividing points. The pipeline segment A1A2 in the original pipeline data is divided using the newly added inflection points B9 and B10 to obtain pipeline segments A1B9, B9B10, and B10A2. The second line vector data includes the pipeline segments divided by the inflection points, and also includes the original pipeline segments that have not been divided by the inflection points. That is, the second line vector data includes the newly divided pipeline segments A1B9, B9B10, and B10A2, and also includes the original pipeline segments A3A4 and A5A6. Specifically, based on the newly added pipeline segment vector data and the second line vector data, it is determined whether there is a newly added span point, including:

[0072] The pipeline segments in the newly added pipeline segment vector data and the pipeline segments in the second line vector data are projected onto the same horizontal plane to obtain the projection of each pipeline segment; if the projection of the pipeline segment in the newly added pipeline segment vector data and the projection of the pipeline segment in the second line vector data have an intersection, it is determined that a newly added span point exists, and the span point is obtained based on the intersection point.

[0073] like Figure 4 As shown, the newly added pipeline segment vector data is pipeline segment C7C8. By mapping the newly added pipeline segment C7C8 and all pipeline segments A1B9, B9B10, B10A2, A3A4, and A5A6 in the second line vector data onto the same horizontal plane, it can be found that the projection of the newly added pipeline segment C7C8 and pipeline segment A3A4 in the second line vector data intersects. Based on this intersection, a newly added span point B11 is obtained. In other words, the newly added pipeline segment vector data and the pipeline segments in the second vector data have a newly added span point. If the newly added pipeline segment vector data does not intersect with the pipeline segments in the second line vector data, then there is no newly added span point.

[0074] It can be understood that after obtaining the intersection, the coordinates of the intersection on the horizontal plane can be obtained. By moving the intersection in the vertical direction to the height of the two intersecting pipelines, the position of the span point of each pipeline can be obtained, that is, the span point.

[0075] Preferably, the use of the newly added span point to divide the pipeline segments in the second line vector data and the newly added pipeline segment vector data includes: using the newly added span point as a dividing point to divide the pipeline segments in the second line vector data and the newly added pipeline data that have the newly added span point.

[0076] When there is a new span point between the newly added pipeline segment vector data and the pipeline segment vector data in the second line vector data, the pipeline segment with the new span point in the second line vector data and the newly added pipeline data is divided using the new span point as a dividing point.

[0077] For example, Figure 4 As shown, with the newly added span point B11 as the dividing point, the pipeline segment A3A4 and the newly added pipeline segment C7C8 in the second line vector data are divided to obtain pipeline segments A3B11, B11A4, C7B11 and B11C8.

[0078] It will be understood that the first line vector data includes all pipeline segments in the second line vector data after spanning, as well as all newly added pipeline segments after spanning. In this embodiment, the first line vector data includes pipeline segments A1B9, B9B10, B10A2, A5A6, A3B11, B11A4, C7B11, and B11C8. If there are no newly added spans, the first line vector data is the combination of the second line vector data and the newly added pipeline segment vector data.

[0079] Preferably, the line attribute values ​​of each pipeline segment before division are assigned to each pipeline segment after division; the line attribute values ​​include a start point number and an end point number.

[0080] Preferably, the line attribute values ​​of each pipeline segment after division are assigned to each pipeline segment after division. Preferably, the line attribute values ​​of each pipeline segment before division are assigned to each pipeline segment after division include:

[0081] If a pipeline segment is not split after division, its line attribute value remains unchanged;

[0082] If a pipeline segment is divided into multiple pipeline segments after division, the line attribute value of the pipeline segment before division is assigned to the multiple pipeline segments obtained by division.

[0083] For example, Figure 3 As shown, the starting point number S_POINT of the pipeline segment A1A2 before division is 1 and the end point number E_POINT is 2. The starting point numbers S_POINT of the pipeline segments A1B9, B9B10 and B10A2 after division are all 1 and the end point numbers E_POINT are all 2.

[0084] For example, Figure 4 As shown, before the division, the starting point number S_POINT of the pipeline segment A3A4 is 3 and the end point number E_POINT is 4; the starting point number S_POINT of the pipeline segment C7C8 is 7 and the end point number E_POINT is 8; after the division, the starting point numbers S_POINT of the pipeline segments A3B11 and B11A4 are both 3 and the end point numbers E_POINT are both 4; after the division, the starting point numbers S_POINT of the pipeline segments C7B11 and B11C8 are both 7 and the end point numbers E_POINT are both 8.

[0085] It is worth noting that if a pipeline segment is not split after division, such as Figure 5 As shown, there are neither new spans nor new inflection points in the pipeline segment A5A6. The starting point number S_POINT is 5 and the end point number E_POINT is 6, which remain unchanged.

[0086] Specifically, the pipeline segment numbers PIPEID of all pipeline segments in the first line vector data after division are renumbered, and all pipeline segments after division are summarized to determine the number of pipeline segments. Figure 3 、 Figure 4 and Figure 5 As shown, the pipeline segment numbers PIPEID of the divided pipeline segments A1B9, B9B10, B10A2, A5A6, A3B11, B11A4, C7B11 and B11C8 are 1, 2, 3, 4, 7, 5, 6 and 8 respectively, and the first line vector data is obtained.

[0087] It should be noted that the pipeline segments in the original pipeline data are far more than the above-mentioned pipeline segments A1A2, A3A4 and A5A6, the pipeline segments in the newly added pipeline data are far more than the above-mentioned pipeline segments C7C8, the newly added inflection points are far more than the above-mentioned inflection points B9 and B10, and the newly added span points are far more than the above-mentioned span point B11. This application only uses the above-mentioned some pipeline segments as examples to illustrate the steps of the present invention.

[0088] It is worth noting that after step S2 is completed, for each pipeline segment in the first line vector data, we can determine the pipeline segment number PIPEID of each pipeline segment, but cannot determine the direction of each pipeline segment.

[0089] Specifically, in step S3, based on the first line vector data, data of two endpoint pairs corresponding to each pipeline segment, ie, second point vector data, is generated.

[0090] Specifically, the first line vector data includes pipeline segments A1B9, B9B10, B10A2, A5A6, A3B11, B11A4, C7B11 and B11C8. For each pipeline segment, corresponding data of two endpoint pairs are generated, and the endpoints are two nodes of each pipeline segment.

[0091] Specifically, in step S4, the pipeline points in the first line vector data are numbered according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data.

[0092] It can be understood that in the first-line vector data, there are pipeline points A1, A2, A5, A6, B9, A3, C7, A4, B10, C8 and B11. According to the original pipeline point vector data WSPOINT1 and the newly added pipeline point vector data WSPOINT2, the pipeline points A1, A2, A5, A6, B9, A3, C7, A4, B10, C8 and B11 are numbered to obtain the third point vector data.

[0093] Preferably, numbering the pipeline points in the first line vector data according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data includes:

[0094] Based on the first line vector data, using a network analysis tool to generate data of all pipeline points in the first line vector data to obtain first point vector data;

[0095] Based on the original pipeline point vector data and the newly added pipeline point vector data, the first point vector data is numbered to obtain third point vector data.

[0096] Specifically, the first-line vector data exists as pipeline segments, and the endpoints of all pipeline segments do not exist independently. Based on the first-line vector data, network analysis tools are used to identify all pipeline points in the first-line vector data, namely pipeline points A1, A2, A5, A6, B9, A3, C7, A4, B10, C8, and B11, to obtain the first-point vector data. Pipeline points A1, A2, A5, A6, B9, A3, C7, A4, B10, C8, and B11 are then numbered based on the original pipeline point vector data WSPOINT1 and the newly added pipeline point vector data WSPOINT2, to obtain the third-point vector data including the geophysical point number and other point attribute values.

[0097] During implementation, you can use the Network Analysis feature in ArcGIS to obtain the first point vector data. Open the "Directory" toolbar, right-click the directory and file containing N_WSLINE, and select "New Network Dataset." Enter the network dataset name "N_WSLINE_ND." Select "No" for whether to model turns in this network. Select the default settings for connectivity. Select "None" for how to model elevation for network features. Select "No" for whether to set specific properties for the network dataset and whether to establish driving directions for this network dataset. The new network dataset is created. Select "Yes" for whether to build it now. Select "Yes" for whether to also add all feature classes participating in "N_WSLINE_ND" to the map.

[0098] The table of contents now has three more layers: the point layer "N_WSLINE_ND_Junctions" and the line layers "N_WSLINE" and "N_WSLINE_ND." "N_WSLINE_ND_Junctions" is the file containing the newly generated set of pipe points, that is, the first point vector data file.

[0099] Preferably, the step of numbering the first point vector data based on the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data includes:

[0100] Finding, in the first point vector data, pipeline points whose position coordinates are the same as those in the original pipeline point vector data and the newly added pipeline point vector data as old pipeline points, and assigning point attribute values ​​of each point in the original pipeline point vector data and the newly added pipeline point vector data to each corresponding old pipeline point, wherein the point attribute values ​​include geophysical prospecting point numbers;

[0101] It is understandable that if there is duplication in the geophysical point numbers of each point in the original pipeline point vector data and the newly added pipeline point vector data, the pipeline points in the newly added pipeline point vector data are renumbered to ensure the uniqueness of the nodes corresponding to the geophysical point numbers.

[0102] The pipeline points other than the old pipeline points in the first point vector data are used as newly divided pipeline points, and the geophysical prospecting point numbers of the newly divided pipeline points are numbered to obtain the third point vector data.

[0103] Specifically, find the pipeline points in the first point vector data whose position coordinates are the same as those in the original pipeline point vector data and the newly added pipeline point vector data, and use them as old pipeline points. Use the pipeline points in the first point vector data other than the old pipeline points as newly divided pipeline points. For example Figure 3 、 Figure 4 and Figure 5 The pipeline points A1, A2, A5, A6, A3, C7, A4 and C8 are regarded as old pipeline points; the pipeline points B9, B10 and B11 are regarded as newly divided pipeline points.

[0104] For old pipeline points, assign the point attribute value of each old pipeline point to the corresponding old pipeline point. The point attribute value includes the geophysical point number. For example, the geophysical point numbers of old pipeline points A1, A2, A5, A6, A3, C7, A4, and C8 are 1, 2, 5, 6, 3, 7, 4, and 8 respectively.

[0105] For the newly divided pipeline points B9, B10 and B11, the geophysical point numbers of the newly divided pipeline points B9, B10 and B11 are numbered. For example, after numbering, the geophysical point numbers of the newly divided pipeline points B9, B10 and B11 are 9, 10 and 11 respectively.

[0106] After the geophysical exploration point numbers of all pipeline points are numbered, the third point vector data is used. It can be understood that all pipeline points in the third point vector data have geophysical exploration point numbers.

[0107] During implementation, use [Analysis Tools] | [Overlay Analysis] | [Spatial Join] in the ArcToolbox toolbox, select N_WSLINE_ND_Junctions in the "Target Feature" in the pop-up Spatial Join window, select the original pipeline point vector data WSPOINT1 and the newly added pipeline point vector data WSPINT2 in the "Join Feature", select the output file save path and file name N_WSPOINT in the "Output Feature Class", select JOIN_ONE_TO_MANY in the "Join Operation", check "Keep all target features", select HAVE_THEIR_CENTER_IN in the "Match Option", and click OK to generate the point set data file N_WSPOINT.

[0108] Open the N_WSPOINT attribute table and delete unnecessary fields such as Join_Count, TARGET_FID, JOIN_FID, and ID. Then sort EXP_NO and number the unnumbered data in the EXP_NO field using a calculator or by opening the dbf file in WPS.

[0109] like Figure 6 、 Figure 7 As shown, taking WPS dbf processing as an example, open N_WSPOINT.dbf through WPS, insert a column to the left of column A, enter 1 in cell A2; double-click the cross in the lower left corner of cell A2 to complete the sequence filling; sort in descending order using the column containing EXP_NO as the key to filter out data with empty numbers; enter a number in the first empty cell of the EXP_NO data column (the maximum value among the existing numbers + 1 to ensure that the new number does not overlap with the existing number); in this embodiment, enter WSP1165; double-click the cross in this cell to complete the subsequent data filling; sort in ascending order using column A as the key; delete the newly added sequence number in column A, and save the file. This results in the processed pipe point set data file N_WSPOINT, i.e., the third point vector data file.

[0110] Preferably, the point attribute value further includes one or more of the following:

[0111] Ground elevation SURF_H;

[0112] FeaturesFEATURE;

[0113] appendageSUBSID;

[0114] LocationLOCATION.

[0115] In the third point vector data, the newly divided pipeline points and the old pipeline points are determined by the position coordinates, so that the attribute values ​​of the old pipeline points remain unchanged, and the newly divided pipeline points are numbered consecutively. The numbering of the pipeline points can reflect the time attributes of the pipeline points, which is convenient for subsequent analysis of the pipeline network.

[0116] Specifically, in step S5, the starting and ending directions corresponding to each pipeline segment in the second point vector data are determined based on the third point vector data to obtain new pipeline data. It is understood that the points in the second point vector data are generated based on each pipeline segment in the first line vector data. Therefore, two corresponding pipeline points are generated for each pipeline segment. That is, the position information of the two endpoints corresponding to each pipeline segment can be obtained from the second point vector data, but the correspondence between the two endpoints and the starting and ending points cannot be distinguished at this time. In particular, the point attribute values ​​in the second point vector data inherit the pipeline segment number PIPID, end point number E_POINT, and start point number S_POINT in the first line vector data. The end point number E_POINT and start point number S_POINT are the same as the end point number E_POINT and start point number S_POINT corresponding to the pipeline segment in the original pipeline data. However, the starting and ending points of each pipeline segment in the second point vector data are inaccurate and need to be corrected based on the third point vector data to obtain the final starting and ending points of each pipeline segment.

[0117] Preferably, determining the starting and ending directions corresponding to each pipeline segment in the second point vector data according to the third point vector data to obtain new pipeline data includes:

[0118] Finding pipeline points in the second point vector data with position coordinates identical to those in the third point vector data, mapping point attribute values ​​of the pipeline points with the same position coordinates in the third point vector data to corresponding pipeline points in the second point vector data, and obtaining geophysical prospecting point numbers of the mapped pipeline points;

[0119] Determine the final starting point number S_POINT and ending point number E_POINT corresponding to each pipeline segment in the second point vector data according to the starting point number S_POINT and ending point number E_POINT of each pipeline segment in the second point vector data before mapping and the geophysical point numbers of the two end points of each pipeline segment after mapping, obtain the pipeline segment number and its starting point number S_POINT and ending point number E_POINT of each pipeline segment, and further process them as pipeline segment vector data in the new pipeline data;

[0120] It can be understood that in the second point vector data, each row represents a pipeline point vector data, and every two pipeline point vector data constitute the data of a pipeline segment. After determining the start point number Start_POINT and end point number End_POINT of all endpoint pairs in the second point vector data, further processing is required to convert the endpoint pair data in the second point vector data into pipeline segment vector data. Each endpoint pair data corresponds to a pipeline segment vector data. The pipeline segment vector data obtained after further processing is used as the pipeline segment vector data in the new pipeline data.

[0121] It is worth noting that the correspondence between the final pipeline segment number PIPEID and the final starting point number S_POINT and end point number E_POINT exists in the second point vector data. Further processing is required to use this correspondence as the pipeline segment vector data in the updated pipeline data. For example: use the field connection tool of ArcGIS to associate the correspondence between PIPID and S_POINT and E_POINT in the second point vector data to the pipeline segment vector data.

[0122] The third point vector data is used as the pipeline point vector data in the new pipeline data.

[0123] It is worth noting that after mapping based on the third-point vector data, each pipeline point in the second-point vector data has a geophysical prospecting point number.

[0124] Specifically, pipeline points whose position coordinates are the same as those in the third point vector data are found in the second point vector data, and the point attribute values ​​of the pipeline points with the same position coordinates in the third point vector data are mapped to the corresponding pipeline points in the second point vector data to obtain the geophysical point numbers of the mapped pipeline points.

[0125] It can be understood that when pipeline points with the same position coordinates are regarded as the same pipeline point, the number of pipeline points in the second point vector data and the third point vector data is the same, and the point attribute values ​​of the pipeline points with the same position coordinates in the third point vector data are mapped to the corresponding pipeline points in the second point vector data. After mapping, all pipeline points in the second point vector data have geophysical point numbers.

[0126] for example Figure 3 、 Figure 4 and Figure 5 The geophysical point numbers of the two endpoints A1 and B9 of the pipeline segment A1B9 are 1 and 9 respectively; the geophysical point numbers of the two endpoints B9 and B10 of the pipeline segment B9B10 are 9 and 10 respectively; the geophysical point numbers of the two endpoints B10 and A2 of the pipeline segment B10A2 are 10 and 2 respectively; the geophysical point numbers of the two endpoints A3 and B11 of the pipeline segment A3B11 are 3 and 11 respectively; the geophysical point numbers of the two endpoints B11 and A4 of the pipeline segment B11A4 are 11 and 4 respectively; the geophysical point numbers of the two endpoints C7 and B11 of the pipeline segment C7B11 are 7 and 11 respectively; the geophysical point numbers of the two endpoints B11 and C8 of the pipeline segment B11C8 are 11 and 8 respectively; the geophysical point numbers of the two endpoints A5 and A6 of the pipeline segment A5A6 are 5 and 6 respectively.

[0127] During implementation, a spatial connection tool is used to compare the positions of the endpoint pair data turning_point obtained in step S3 and the midpoint of the pipeline point vector data N_WSPOINT obtained in step S4, and points with the same geographical location, i.e., coordinates, are regarded as the same point, that is, the pipeline point number in N_WSPOINT is mapped to turning_point.

[0128] Select [Analysis Tools] | [Overlay Analysis] | [Spatial Join] in the ArcToolbox toolbox. In the Spatial Join window that pops up, select turning_point in "Target Feature", select N_WSPOINT in "Join Feature", select the output file save path and file name Line_to_Point in "Output Feature Class", select JOIN_ONE_TO_ONE in "Join Operation", check "Keep all target features", select to keep PIPEID, E_POINT, S_POINT, EXP_NO fields in "Field Mapping of Join Features", select HAVE_THEIR_CENTER_IN in "Match Options", click OK to generate Line_to_Point, open the attribute table of the file, click [Table Options] | [Export], and in the Export Data window that pops up, select the file save path and file name in the output table.

[0129] Preferably, determining the final starting point number S_POINT and end point number E_POINT corresponding to each pipeline segment in the second point vector data according to the starting point number S_POINT and end point number E_POINT of each pipeline segment in the second point vector data before mapping and the geophysical point numbers of the two end points of each corresponding pipeline segment after mapping includes:

[0130] If E_Origin[i]=Point[i]_1 and S_Origin[i]=Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2;

[0131] If E_Origin[i]=Point[i]_2 and S_Origin[i]=Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1.

[0132] If E_Origin[i]=Point[i]_1 and S_Origin[i]≠Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2;

[0133] If E_Origin[i]≠Point[i]_1 and S_Origin[i]=Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2;

[0134] If E_Origin[i]≠Point[i]_2 and S_Origin[i]=Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1;

[0135] If E_Origin[i]=Point[i]_2 and S_Origin[i]≠Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1.

[0136] If E_Origin[i]≠Point[i]_2 and S_Origin[i]≠Point[i]_1, then determine End_Point[i] and Start_Point[i] according to the topological relationship rules.

[0137] Among them, E_Origin[i] represents the end point number E_POINT of the i-th pipeline segment before mapping, S_Origin[i] represents the starting point number S_POINT of the i-th pipeline segment before mapping; Point[i]_1 represents the geophysical point number of one end point of the i-th pipeline segment after mapping, Point[i]_2 represents the geophysical point number of the other end point of the i-th pipeline segment after mapping; End_Point[i] represents the final end point number E_POINT of the i-th pipeline segment, and Strart_Point[i] represents the final starting point number S_POINT of the i-th pipeline segment.

[0138] Specifically, for example, Figure 3 and Figure 4 As shown. Figure 3Before mapping, the first pipeline segment A1B9 had a starting point number S_POINT of 1 and an end point number E_POINT of 2. After mapping, the geophysical point numbers of the two endpoints of the first pipeline segment A1B9 are 1 and 9. Comparison shows that the final starting point number S_POINT for the first pipeline segment A1B9 is 1, and the end point number E_POINT is 9. Before mapping, the starting point number S_POINT for the third pipeline segment B10A2 was 1, and the end point number E_POINT was 2. After mapping, the geophysical point numbers of the two endpoints of the third pipeline segment B10A2 are 10 and 2. Comparison shows that the final starting point number S_POINT for the third pipeline segment B10A2 is 10, and the end point number E_POINT is 2.

[0139] exist Figure 4 In the figure, the starting point number S_POINT of the fifth pipeline segment A3B11 before mapping is 3, and the end point number E_POINT is 4. After mapping, the geophysical point numbers of the two end points of the fifth pipeline segment A3B11 are 3 and 11. By comparison, it can be seen that the final starting point number S_POINT corresponding to the fifth pipeline segment A3B11 is 3, and the end point number E_POINT is 11. In addition, it can be seen that the final starting point number S_POINT corresponding to the sixth pipeline segment B11A4 is 11, and the end point number E_POINT is 4; the final starting point number S_POINT corresponding to the seventh pipeline segment C7B11 is 7, and the end point number E_POINT is 11; the final starting point number S_POINT corresponding to the eighth pipeline segment B11C8 is 11, and the end point number E_POINT is 8. These will not be repeated here.

[0140] For example, Figure 5 As shown, the starting point number S_POINT of the 4th pipeline segment A5A6 before mapping is 5, and the end point number E_POINT is 6; after mapping, the geophysical point numbers of the two end points of the 4th pipeline segment A5A6 are 5 and 6. By comparison, it can be determined that the final starting point number S_POINT corresponding to the 4th pipeline segment A5A6 is 5, and the end point number E_POINT is 6.

[0141] For example, Figure 3 As shown, the starting point number S_POINT of the second pipeline segment B9B10 before mapping is 1, and the end point number E_POINT is 2. After mapping, the geophysical point numbers of the two end points of the second pipeline segment B9B10 are 9 and 10. At this time, according to the topological relationship rule, the final starting point number S_POINT corresponding to the second pipeline segment B9B10 is determined to be 9, and the end point number E_POINT is 10.

[0142] When implementing, the specific steps include:

[0143] 1) Input description: The data has 4 columns. The first column PIPEID is the pipeline segment ID PIPEID; the second column E_POINT is the end point number before mapping; the third column S_POINT is the starting point number before mapping; the fourth column EXP_NO is the geophysical point number of the two endpoints after mapping (the corresponding relationship between the start and end points is unknown).

[0144] 2) Output requirements: Match the start and end point numbers of the mapped pipeline segment with the pipeline segment.

[0145] 3)Logical implementation process:

[0146] i Take out the two data points (Point_1 and Point_2) representing the two endpoints of the same pipeline from the EXP_NO column;

[0147] ii. Compare the corresponding data E_Origin[i] and S_Origin[i] in the E_POINT and S_POINT columns of the corresponding pipeline with Point_1 and Point_2 taken in the previous step to obtain the starting point number Start_Point[i] and the end point number End_Point[i] corresponding to pipeline i:

[0148] a. If E_Origin[i]=Point_1 and S_Origin[i]=Point_2, then End_Point[i]=Point_1, Start_Point[i]=Point_2;

[0149] b. If E_Origin[i]=Point_2 and S_Origin[i]=Point_1, then End_Point[i]=Point_2, Strut_Point[i]=Point_1;

[0150] c. If E_Origin[i]=Point_1 and S_Origin[i]≠Point_2, then End_Point[i]=Point_1, Strat_Point[i]=Point_2;

[0151] d. If E_Origin[i]=Point_2 and S_Origin[i]≠Point_1, then End_Point[i]=Point_2, Start_Point[i]=Point_1;

[0152] e. If E_Origin[i]≠Point_1 and S_Origin[i]=Point_2, then End_Point[i]=Point_1, Start_Point[i]=Point_2;

[0153] f. If E_Origin[i]≠Point_2 and S_Origin[i]=Point_1, then End_Point[i]=Point_, Start_Point[i]=Point_1;

[0154] g. In other cases, Start_Point[i] = "to be determined", End_Point[i] = "to be determined".

[0155] For the situation in g, it is determined according to the topological relationship rules.

[0156] Compared with the prior art, the ground line pipeline update method provided by the embodiment of the present invention utilizes newly added inflection points and newly added span points to re-divide the pipeline segments in the original pipeline segment vector data and the newly added pipeline segment vector data, and renumbers the pipeline segment numbers of each divided pipeline segment and determines the corresponding starting and ending directions of each divided pipeline segment, thereby realizing the update of pipeline data; at the same time, by intelligently generating unmarked span points in the original pipeline data and the newly added pipeline data, manual inspection of pipeline segments one by one is avoided, the efficiency of data processing is improved, and an intelligent, efficient, replicable and popularizable pipeline data update method is provided.

[0157] Those skilled in the art will appreciate that all or part of the process steps of the above-described embodiments can be implemented by instructing related hardware through a computer program, and the program can be stored in a computer-readable storage medium, such as a magnetic disk, an optical disk, a read-only memory, or a random access memory.

[0158] The above description is only a preferred specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by any technician familiar with this technical field within the technical scope disclosed in the present invention should be covered by the scope of protection of the present invention.

Claims

1. A method for updating underground pipelines, characterized in that: The updating method includes: Obtaining original pipeline data, newly added pipeline data, and newly added inflection points; the pipeline data includes pipeline segment vector data and pipeline point vector data; The original pipeline segment vector data is divided using the newly added inflection points to obtain second line vector data; based on the newly added pipeline segment vector data and the second line vector data, it is determined whether there is a newly added span point; if so, the pipeline segments in the second line vector data and the newly added pipeline segment vector data are divided using the newly added span point to obtain first line vector data; if not, the second line vector data and the newly added pipeline segment vector data are used as the first line vector data; and all pipeline segments in the first line vector data are renumbered; Based on the first line vector data, generating data of two endpoint pairs corresponding to each pipeline segment, namely, second point vector data; Numbering the pipeline points in the first line vector data according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data; Determine the starting and ending directions corresponding to each pipeline segment in the second point vector data according to the third point vector data to obtain new pipeline data; The determining whether there is a newly added span point based on the newly added pipeline segment vector data and the second line vector data includes: The pipeline segments in the newly added pipeline segment vector data and the pipeline segments in the second line vector data are projected onto the same horizontal plane to obtain the projection of each pipeline segment; if the projection of the pipeline segment in the newly added pipeline segment vector data and the projection of the pipeline segment in the second line vector data have an intersection, it is determined that a newly added span point exists, and the span point is obtained based on the intersection point.

2. The updating method according to claim 1, wherein: The dividing the original pipeline segment vector data by using the newly added inflection point includes: dividing the pipeline segment having the newly added inflection point in the original pipeline segment vector data by using the newly added inflection point as a dividing point; The dividing the pipeline segments in the second line vector data and the newly added pipeline segment vector data by using the newly added span point includes: dividing the pipeline segments in the second line vector data and the newly added pipeline segment vector data where the newly added span point exists by using the newly added span point as a dividing point; The line attribute values ​​of each pipeline segment before division are assigned to each pipeline segment after division; the line attribute values ​​include a starting point number and an end point number.

3. The updating method according to claim 2, wherein: The step of assigning the line attribute values ​​of the pipeline segments before division to the pipeline segments after division includes: If a pipeline segment is not split after division, its line attribute value remains unchanged; If a pipeline segment is divided into multiple pipeline segments after division, the line attribute value of the pipeline segment before division is assigned to the multiple pipeline segments obtained by division.

4. The updating method according to claim 1, wherein: The step of numbering the pipeline points in the first line vector data according to the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data includes: Based on the first line vector data, using a network analysis tool to generate data of all pipeline points in the first line vector data to obtain first point vector data; Based on the original pipeline point vector data and the newly added pipeline point vector data, the first point vector data is numbered to obtain third point vector data.

5. The updating method according to claim 4, characterized in that: The step of numbering the first point vector data based on the original pipeline point vector data and the newly added pipeline point vector data to obtain third point vector data includes: Finding, in the first point vector data, pipeline points whose position coordinates are the same as those in the original pipeline point vector data and the newly added pipeline point vector data as old pipeline points, and assigning point attribute values ​​of each point in the original pipeline point vector data and the newly added pipeline point vector data to each corresponding old pipeline point, wherein the point attribute values ​​include geophysical prospecting point numbers; The pipeline points other than the old pipeline points in the first point vector data are used as newly divided pipeline points, and the geophysical prospecting point numbers of the newly divided pipeline points are numbered to obtain the third point vector data.

6. The updating method according to claim 5, characterized in that: The point attribute value also includes one or more of the following: Ground elevation SURF_H; FeaturesFEATURE; appendageSUBSID; LocationLOCATION.

7. The updating method according to claim 2, wherein: The determining, based on the third point vector data, the start and end directions corresponding to each pipeline segment in the second point vector data to obtain new pipeline data includes: Finding pipeline points in the second point vector data with position coordinates identical to those in the third point vector data, mapping point attribute values ​​of the pipeline points with the same position coordinates in the third point vector data to corresponding pipeline points in the second point vector data, and obtaining geophysical prospecting point numbers of the mapped pipeline points; Determine the final starting point number and ending point number corresponding to each pipeline segment in the second point vector data based on the starting point number and ending point number of each pipeline segment in the second point vector data before mapping and the geophysical prospecting point numbers of the two end points of each pipeline segment after mapping, obtain the pipeline segment number and its starting point number and ending point number of each pipeline segment, and further process them as pipeline segment vector data in the new pipeline data; The third point vector data is used as the pipeline point vector data in the new pipeline data.

8. The updating method according to claim 7, characterized in that: The determining, based on the starting point number and the ending point number of each pipeline segment in the second point vector data before mapping and the geophysical prospecting point numbers of the two end points of each pipeline segment after mapping, the final starting point number and the ending point number corresponding to each pipeline segment in the second point vector data includes: If E_Origin[i]=Point[i]_1 and S_Origin[i]=Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2; If E_Origin[i]=Point[i]_2 and S_Origin[i]=Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1; Among them, E_Origin[i] represents the end point number of the i-th pipeline segment before mapping, S_Origin[i] represents the starting point number of the i-th pipeline segment before mapping; Point[i]_1 represents the geophysical exploration point number of one end point of the i-th pipeline segment after mapping, Point[i]_2 represents the geophysical exploration point number of the other end point of the i-th pipeline segment after mapping; End_Point[i] represents the final end point number of the i-th pipeline segment, and Strart_Point[i] represents the final starting point number of the i-th pipeline segment.

9. The updating method according to claim 8, characterized in that: The method further comprises determining the final starting point number and ending point number corresponding to each pipeline segment in the second point vector data based on the starting point number and ending point number of each pipeline segment in the second point vector data before mapping and the geophysical prospecting point numbers of the two end points of each pipeline segment after mapping, further comprising: If E_Origin[i]=Point[i]_1 and S_Origin[i]≠Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2; If E_Origin[i]≠Point[i]_1 and S_Origin[i]=Point[i]_2, then End_Point[i]=Point[i]_1 and Start_Point[i]=Point[i]_2; If E_Origin[i]≠Point[i]_2 and S_Origin[i]=Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1; If E_Origin[i]=Point[i]_2 and S_Origin[i]≠Point[i]_1, then End_Point[i]=Point[i]_2 and Start_Point[i]=Point[i]_1; If E_Origin[i]≠Point[i]_2 and S_Origin[i]≠Point[i]_1, then determine End_Point[i] and Start_Point[i] according to the topological relationship rules.

Images