Pipeline data calibration method based on node-edge relationship

Abstract

The present application relates to a kind of pipeline data calibration method based on "node-edge" relationship, belong to data processing technical field, solve the problem of time-consuming and labor-consuming in prior art for the artificial calibration of each piece in the case where part node of pipeline data is not marked.The calibration method includes: obtaining original pipeline data and newly added inflection point, cross point;Original pipeline section vector data is redivided using inflection point, cross point to pipeline section, and all pipeline sections after division are renumbered, to obtain first line vector data;Based on first line vector data, the data corresponding to two end point pairs of each pipeline section is generated, i.e.second point vector data;According to original pipeline point vector data, the pipeline point in first line vector data is numbered, to obtain third point vector data;According to third point vector data, the start and end direction corresponding to each pipeline section in second point vector data is determined, to obtain new pipeline data.The calibration of pipeline data is realized, and the accuracy of data processing is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a pipeline data calibration method based on a "node-edge" relationship. BACKGROUND

[0002] Urban underground pipelines are an important part of urban underground municipal infrastructure, and the construction of underground pipelines is an important foundation for the safe and orderly operation of cities and an important part of high-quality urban development. Urban underground pipelines mainly include water supply, rainwater, sewage, gas pipelines and ancillary facilities, etc. Pipeline data is the basis for pipeline analysis, visualization applications, etc.

[0003] Urban underground pipeline networks can be abstracted as a "pipeline point-pipeline segment" mathematical model, and the existing technology mainly uses a "two-point-one-line" data structure. Pipeline vector data is composed of lines with pipeline segment attributes and coordinate information, and node data with pipeline point attribute information and coordinate information. For some two-dimensional vector data of urban underground pipelines, there are cases where key turning points are not marked, i.e., when dividing pipeline segments, multiple continuous directed lines are divided into one pipeline segment; there are also cases where key nodes at the cross-line are not marked.

[0004] In the prior art, for the problem of some nodes of the pipeline data not being marked, the unmarked points are usually directly ignored, or manually calibrated line by line. Directly ignoring some key nodes will inevitably affect the modeling effect and analysis results, while manual calibration is time-consuming and labor-intensive, and the efficiency is low. Moreover, a new set of data is equivalent to starting from scratch, so manual calibration line by line lacks generalizability. SUMMARY

[0005] In view of the above analysis, the embodiments of the present application aim to provide a pipeline data calibration method based on a "node-edge" relationship to solve the problem of manual calibration line by line for the case of some nodes of the pipeline data not being marked in the prior art.

[0006] The embodiments of the present application provide a pipeline data calibration method based on a "node-edge" relationship, which comprises:

[0007] Obtaining original pipeline data and newly added turning points and cross points, wherein the original pipeline data comprises original pipeline segment vector data and original pipeline point vector data;

[0008] Re-dividing the pipeline segments in the original pipeline segment vector data using the turning points and cross points, and re-numbering all the divided pipeline segments to obtain first line vector data;

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

[0010] According to the original pipeline point vector data, the pipeline points in the first line vector data are numbered to obtain third point vector data;

[0011] According to the third point vector data, the corresponding start and end directions of each pipeline segment in the second point vector data are determined to obtain new pipeline data.

[0012] Based on the further improvement of the above method, the pipeline segments in the original pipeline segment vector data are re-divided by using the fold points and cross points, including:

[0013] The pipeline segments with cross points in the original pipeline segment vector data are divided by taking the cross points as the dividing points;

[0014] The pipeline segments with fold points in the original pipeline segment vector data are divided by taking the fold points as the dividing points;

[0015] The line attribute values of each pipeline segment before division are assigned to each pipeline segment after division; the line attribute values include start point number and end point number.

[0016] Based on the further improvement of the above method, the line attribute values of each pipeline segment before division are assigned to each pipeline segment after division, including:

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

[0018] 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.

[0019] Based on the 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 to obtain third point vector data, including:

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

[0021] Based on the original pipeline point vector data, the first point vector data is numbered to obtain third point vector data.

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

[0023] In the first point vector data, find the pipeline points with the same position coordinates as those in the original pipeline point vector data as old pipeline points, and assign the point attribute values of each point in the original pipeline point vector data to each corresponding old pipeline point, the point attribute values including geophysical point number;

[0024] The pipeline points in the first point vector data except the old pipeline points are taken as new pipeline points, and the geophysical point numbers of the new pipeline points are numbered to obtain the third point vector data.

[0025] Based on further improvement of the above method, the point attribute value further comprises one or more of the following:

[0026] ground elevation SURF_H;

[0027] feature FEATURE;

[0028] accessory SUBSID;

[0029] location LOCATION.

[0030] Based on further improvement of the above method, the determining of the corresponding start and end directions of each pipeline segment in the second point vector data according to the third point vector data to obtain new pipeline data comprises:

[0031] finding the pipeline points with the same position coordinates in the second point vector data and the third point vector data, mapping the point attribute values of the pipeline points with the same position coordinates in the third point vector data to the corresponding pipeline points in the second point vector data to obtain the geophysical point numbers of the mapped pipeline points;

[0032] determining the final start point number and end point number of each pipeline segment in the second point vector data according to the start point number and end point number of each pipeline segment in the second point vector data before mapping and the geophysical point numbers of the two end points of the corresponding pipeline segment after mapping, obtaining the pipeline segment number of each pipeline segment and its start point number and end point number, and further processing to serve as the pipeline segment vector data in the new pipeline data;

[0033] taking the third point vector data as the pipeline point vector data in the new pipeline data.

[0034] Based on further improvement of the above method, the determining of the final start point number and end point number of each pipeline segment in the second point vector data according to the start point number and end point number of each pipeline segment in the second point vector data before mapping and the geophysical point numbers of the two end points of the corresponding pipeline segment after mapping comprises:

[0035] 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;

[0036] 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;

[0037] 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.

[0038] 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:

[0039] 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;

[0040] 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;

[0041] 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;

[0042] 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.

[0043] Based on the further improvement of the above method, the determination of the final start point number and end point number of each pipeline segment in the second point vector data according to the start point number, end point number of each pipeline segment in the second point vector data before mapping and the geophysical point number of the two end points of the corresponding pipeline segment after mapping further comprises:

[0044] If E_Origin[i]≠Point[i]_2 and S_Origin[i]≠Point[i]_1, End_Point[i] and Start_Point[i] are determined according to the topological relationship rule.

[0045] Compared with the prior art, the present application can realize at least one of the following beneficial effects:

[0046] 1. The present application re-divides the pipeline segments in the original pipeline segment vector data by using the fold points and cross points, re-numbers the pipeline segment numbers of each divided pipeline segment and determines the start and end directions of each divided pipeline segment, thereby realizing the calibration of the original pipeline data.

[0047] 2. The present application intelligently generates important nodes in the original pipeline data which are not marked, avoids manual inspection of each pipeline segment, improves the efficiency of data processing and provides an intelligent, efficient, replicable and generalizable pipeline data processing method.

[0048] In the present application, the above technical solutions can be combined with each other to realize more preferred combination solutions. Other features and advantages of the present application will be described in the subsequent specification, and some advantages will become apparent from the specification or be understood by implementing the present application. The purposes and other advantages of the present application can be realized and obtained from the contents specifically indicated in the specification and the drawings. BRIEF DESCRIPTION OF DRAWINGS

[0049] The accompanying drawings are included to provide a further understanding of the present application and are incorporated herein and constitute a part of the specification. The drawings illustrate embodiments of the present application and, together with the description, serve to explain the principles of the present application.

[0050] Figure 1 A pipeline data calibration method based on the "node-edge" relationship provided for the embodiments of the present application;

[0051] Figure 2 One of the pipeline network "node-edge" diagrams provided for the embodiments of the present application;

[0052] Figure 3 The second pipeline network "node-edge" diagram provided for the embodiments of the present application;

[0053] Figure 4Figure 3 is a schematic diagram of a pipeline network "node-edge" relationship provided by an embodiment of the present application;

[0054] Figure 5 Figure 1 is a schematic diagram of numbering pipeline points provided by an embodiment of the present application;

[0055] Figure 6 Figure 2 is another schematic diagram of numbering pipeline points provided by an embodiment of the present application. DETAILED DESCRIPTION

[0056] The preferred embodiments of the present application will be described in detail with reference to the drawings, in which:

[0057] One specific embodiment of the present application discloses a pipeline data calibration method based on a "node-edge" relationship, as shown in Figure 1 The calibration method comprises the following steps:

[0058] Step S1: obtaining original pipeline data and newly added fold points and cross points, wherein the original pipeline data comprises original pipeline segment vector data and original pipeline point vector data;

[0059] Step S2: re-dividing pipeline segments in the original pipeline segment vector data by using the fold points and the cross points, and re-numbering all the divided pipeline segments to obtain first line vector data;

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

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

[0062] Step S5: determining the start and end directions of each pipeline segment in the second point vector data according to the third point vector data to obtain new pipeline data.

[0063] Specifically, in step S1, the original pipeline data comprises original pipeline segment vector data WSLINE and original pipeline point vector data WSPOINT file, and the original pipeline point vector data is a node in the original pipeline data, and the original pipeline segment vector data is an edge in the original pipeline data.

[0064] Specifically, the fold point represents a node in the middle part when a plurality of continuous directed line segments in the original pipeline segment vector data are divided into one pipeline segment. For example, as shown in Figure 2 In the original pipeline segment vector data, P1 to P2 are taken as one pipeline segment, and the newly added fold points refer to P9 and P10.

[0065] Specifically, the cross point represents the intersection of two directed line segments in the original pipeline segment vector data, that is, in the actual pipeline data, two pipelines are at different height positions and actually do not intersect, but there is a cross point when the two pipelines are projected onto a horizontal plane. For example, as shown in the figure, Figure 3 P3 to P4 is a pipeline segment, P5 to P6 is a pipeline segment, and the newly added cross point refers to P11.

[0066] Specifically, in step S2, the pipeline segments in the original pipeline segment vector data are re-divided by using the fold points and the cross points, and all the pipeline segments after division are re-numbered to obtain the first line vector data.

[0067] Preferably, the re-division of the pipeline segments in the original pipeline segment vector data by using the fold points and the cross points comprises:

[0068] dividing the pipeline segment in the original pipeline segment vector data that has the cross point by taking the cross point as a boundary point;

[0069] dividing the pipeline segment in the original pipeline segment vector data that has the fold point by taking the fold point as a boundary point;

[0070] assigning the line attribute value of each pipeline segment before division to each pipeline segment after division; the line attribute value includes a start point number S_POINT and an end point number E_POINT.

[0071] Specifically, as shown in the figure, Figure 2 the pipeline segment P1P2 is a pipeline segment in the original pipeline segment vector data that has a fold point, and the pipeline segment P1P2 is divided into the pipeline segments P1P9, P9P10 and P10P2 by taking the fold points P9 and P10 as boundary points.

[0072] In implementation,

Data Management

Features

Split Line at Fold Point

Split Line at Fold Point

[0073] Specifically, as shown in the figure, Figure 3 the pipeline segment P3P4 and the pipeline segment P5P6 are pipeline segments in the original pipeline segment vector data that have a cross point, and the pipeline segment P3P4 and the pipeline segment P5P6 are divided by taking the cross point P11 as a boundary point, and the pipeline segment P3P4 and the pipeline segment P5P6 are divided into the pipeline segments P3P11, P11P4, P5P11 and P11P6.

[0074] During implementation, ArcGIS can be used to perform cross-point segmentation on the original pipeline segment vector data WSLINE. First, right-click the WSLINE layer, select [Edit Feature], and then select [Start Editing] to make the pipeline layer editable. Then, right-click the WSLINE layer, select [Select], and then select [Select All]. Use the [Break Intersecting Lines] function in the Advanced Editing Tools to break the lines at their intersections. Click OK in the "Break Intersecting Lines" window that pops up to complete the break.

[0075] Specifically, the line attribute values ​​of the pipeline segment include the starting point number S_POINT and the end point number E_POINT. In addition, the line attribute values ​​also include the pipeline segment number PIPEID, construction time BuildTime, burial method D_TYPE, pipe diameter D_S and material MATERIAL, etc.

[0076] Assigning the line attribute values ​​of each pipeline segment after division to each pipeline segment after division. Preferably, assigning the line attribute values ​​of each pipeline segment before division to each pipeline segment after division includes:

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

[0078] 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.

[0079] For example, Figure 2 As shown, the starting point number S_POINT of the pipeline segment P1P2 before division is 1 and the end point number E_POINT is 2. The starting point numbers S_POINT of the pipeline segments P1P9, P9P10 and P10P2 after division are all 1 and the end point numbers E_POINT are all 2.

[0080] For example, Figure 3 As shown, before the division, the starting point number S_POINT of the pipeline segment P3P4 is 3 and the end point number E_POINT is 4; the starting point number S_POINT of the pipeline segment P5P6 is 5 and the end point number E_POINT is 6; after the division, the starting point number S_POINT of the pipeline segments P3P11 and P11P4 are both 3 and the end point number E_POINT are both 4; after the division, the starting point number S_POINT of the pipeline segments P5P11 and P11P6 ​​are both 5 and the end point number E_POINT are both 6.

[0081] It is worth noting that if a pipeline segment is not split after division, such as Figure 4 As shown, there is neither a span point nor a turning point in the pipeline segment P7P8, the starting point number S_POINT is 7, and the end point number E_POINT is 8, which remain unchanged.

[0082] Specifically, the pipeline segment numbers PIPEID of all the divided pipeline segments are renumbered, all the divided pipeline segments are summarized, and the number of pipeline segments is determined. As shown in Figure 2 , Figure 3 and Figure 4 , the pipeline segment numbers PIPEID of the divided pipeline segments P1P9, P9P10, P10P2, P3P11, P11P4, P5P11, P11P6 and P7P8 are 1, 2, 3, 4, 7, 5, 6 and 8 respectively, obtaining the first line vector data.

[0083] It should be noted that the pipeline segments in the pipeline data are far more than the above-mentioned pipeline segments P1P9, P9P10, P10P2, P3P11, P11P4, P5P11, P11P6 and P7P8, and the present application only uses the above-mentioned pipeline segments as examples to explain the steps of the present application.

[0084] In implementation, N_WSLINE represents all the divided pipeline segment vector data, in the non-editing state of N_WSLINE, by right-clicking

Open Property Table

Field Calculator

OK

[0085] It should be noted that after the end of step S2, for each pipeline segment, the pipeline segment number PIPEID of each pipeline segment can be determined, but the direction of each pipeline segment cannot be determined.

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

[0087] Specifically, the first line vector data includes pipeline segments P1P9, P9P10, P10P2, P3P11, P11P4, P5P11, P11P6 and P7P8, and for each pipeline segment, the data of the corresponding two endpoint pairs is generated, and the endpoints are the two nodes of each pipeline segment.

[0088] In implementation, the ArcToolbox toolbox of ArcGIS is used for processing. In the

Data Management

Features

Feature Vertices to Points

[0089] Specifically, in step S4, the pipeline points in the first line vector data are numbered according to the original pipeline point vector data, and third point vector data is obtained.

[0090] It can be understood that in the first line vector data, there are pipeline points P1, P2, P9, P10, P3, P4, P6, P5, P11, P7 and P8. The pipeline points P1, P2, P9, P10, P3, P4, P6, P5, P11, P7 and P8 are numbered according to the original pipeline point vector data WSPOINT, and third point vector data is obtained.

[0091] Preferably, the numbering of the pipeline points in the first line vector data according to the original pipeline point vector data to obtain the third point vector data comprises:

[0092] Based on the first line vector data, a network analysis tool is used to generate data of all pipeline points in the first line vector data, and first point vector data is obtained.

[0093] Based on the original pipeline point vector data, the first point vector data is numbered to obtain third point vector data.

[0094] Specifically, in the first line vector data, the pipeline segments exist in the form of pipeline segments, and the endpoints of all pipeline segments do not exist independently. Based on the first line vector data, a network analysis tool is used to determine all pipeline points in the first line vector data, i.e., to determine the pipeline points P1, P2, P9, P10, P3, P4, P6, P5, P11, P7 and P8, and obtain the first point vector data. Then, the pipeline points P1, P2, P9, P10, P3, P4, P6, P5, P11, P7 and P8 are numbered according to the original pipeline point vector data WSPOINT, and third point vector data including geophysical point numbers and other point attribute values is obtained.

[0095] In the implementation, the first point vector data can be obtained by using the Network Analysis function in ArcGIS. The "Catalog" is opened through the standard toolbar, the directory in which the N_WSLINE is located is found, and the right button is clicked on the file to create a new network dataset. The name of the network dataset is input as "N_WSLINE_ND". Whether to build a turn model in the network is selected as "No". The connectivity is selected by default. How to model the elevation of the network features is selected as "None". The attribute of the network dataset is not set. Whether to build a driving direction for the network dataset is selected as "No". The new network dataset is created. Whether to build immediately is selected as "Yes". Whether to add all feature classes participating in the "N_WSLINE_ND" to the map is selected as "Yes".

[0096] At this point, three layers are added to the content list, a point layer "N_WSLINE_ND_Junctions", a line layer "N_WSLINE", and "N_WSLINE_ND". Among them, "N_WSLINE_ND_Junctions" is a file in which all the newly generated pipe point sets are located, that is, the first point vector data file.

[0097] Preferably, the first point vector data is numbered based on the original pipe point vector data to obtain third point vector data, including:

[0098] In the first point vector data, find the pipe points with the same position coordinates as those in the original pipe point vector data as old pipe points, and assign the point attribute values of the points in the original pipe point vector data to the corresponding old pipe points. The point attribute values include geophysical point numbers;

[0099] The pipe points in the first point vector data except the old pipe points are taken as new pipe points, and the geophysical point numbers of the new pipe points are numbered to obtain the third point vector data.

[0100] Specifically, in the first point vector data, find the pipe points with the same position coordinates as those in the original pipe point vector data as old pipe points. The pipe points in the first point vector data except the old pipe points are taken as new pipe points. For example Figure 2 、 Figure 3 and Figure 4 The pipe points P1, P2, P3, P4, P6, P5, P7, and P8 are taken as old pipe points, and the pipe points P9, P10, and P11 are taken as new pipe points.

[0101] For the old pipeline points, the point attribute values of each point in the old pipeline points are assigned to each corresponding old pipeline point, including the geophysical point number. For example, the geophysical point numbers of the old pipeline points P1, P2, P3, P4, P6, P5, P7 and P8 are 1, 2, 3, 4, 6, 5, 7 and 8 respectively.

[0102] For the new pipeline points P9, P10 and P11, the geophysical point numbers of the new pipeline points P9, P10 and P11 are numbered, such as the geophysical point numbers of the new pipeline points P9, P10 and P11 after numbering are 9, 10 and 11 respectively.

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

[0104] In implementation, through the

Analysis Tools

Overlay Analysis

Spatial Join

[0105] The attribute table of N_WSPOINT is opened, and the redundant fields such as Join_Count, TARGET_FID, JOIN_FID and ID are deleted. Then, the EXP_NO is sorted, and the data in the EXP_NO field column which is not numbered is numbered through the calculator or by opening the dbf file through WPS.

[0106] As shown in Figure 5 , Figure 6 , taking the dbf processed by WPS as an example, N_WSPOINT.dbf is opened through WPS, a column is inserted on the left side of column A, and 1 is input in cell A2. The cross at the lower left corner of cell A2 is double-clicked to complete the sequence filling. The column where the EXP_NO is located is taken as the key to sort in descending order to filter out the data whose number is empty. The first empty cell in the EXP_NO data column is input with the number (the maximum value + 1 of the existing number to ensure that the new number is not repeated with the existing number), which is WSP1165 in the embodiment. The cross of the cell is double-clicked to complete the filling of the subsequent data. The column A is taken as the key to sort in ascending order. The new serial number in column A is deleted, and the file is saved. Thus, the processed pipeline point set data file N_WSPOINT, i.e. the third point vector data file, is obtained.

[0107] Preferably, the point attribute value further comprises one or more of:

[0108] a ground elevation SURF H;

[0109] a feature FEATURE;

[0110] a subsidiary SUBSID;

[0111] a location LOCATION.

[0112] In the third point vector data, the new pipeline point and the old pipeline point are determined through the location coordinates, so that the attribute value of the old pipeline point is kept unchanged, and the newly added pipeline point is numbered in sequence, and the time attribute of the pipeline point can be reflected through the number of the pipeline point, facilitating subsequent analysis of the pipeline network.

[0113] Specifically, in step S5, the start and end directions corresponding to each pipeline segment in the second point vector data are determined according to the third point vector data, and new pipeline data is obtained. It can be understood that the points in the second point vector data are generated based on each pipeline segment in the first line vector data, and each pipeline segment generates a corresponding two pipeline points, i.e., the position information of the two endpoints corresponding to each pipeline segment can be obtained from the second vector data, but at this time, it is not possible to distinguish the corresponding relationship between the two endpoints and the start and end points. In particular, the point attribute value in the second point vector data is inherited from the pipeline segment number PIPID, the end point number E POINT, the start point number S POINT, etc. in the first line vector data, and the end point number E POINT and the start point number S POINT are the end point number E POINT and the start point number S POINT corresponding to the pipeline segment in the original pipeline data. However, the start point number and the end point number of each pipeline segment in the second point vector data are not accurate and need to be corrected according to the third point vector data to obtain the start point number and the end point number of each pipeline segment.

[0114] Preferably, the determining the start and end directions corresponding to each pipeline segment in the second point vector data according to the third point vector data to obtain new pipeline data comprises:

[0115] finding out the pipeline points with the same location coordinates in the second point vector data and the third point vector data, mapping the point attribute values of the pipeline points with the same location coordinates in the third point vector data to the corresponding pipeline points in the second point vector data to obtain the geophysical point numbers of the mapped pipeline points;

[0116] According to the start point number S_POINT, the end point number E_POINT of each pipeline segment in the second point vector data before mapping and the geophysical point number of the two end points of the corresponding pipeline segment after mapping, the final start point number S_POINT and the end point number E_POINT of each pipeline segment in the second point vector data are determined, and the pipeline segment number, the start point number S_POINT and the end point number E_POINT of each pipeline segment are obtained, which are further processed as pipeline segment vector data in the new pipeline data;

[0117] It can be understood that in the second point vector data, each row represents a pipeline point vector data, and each two pipeline point vector data form the data of a pipeline segment. After determining the start point number S_POINT and the end point number E_POINT of all end point pairs in the second point vector data, the end point pair data in the second point vector data needs to be further processed into pipeline segment vector data, each end point pair data corresponds to a pipeline segment vector data, and the pipeline segment vector data obtained after further processing is taken as the pipeline segment vector data in the new pipeline data.

[0118] It can be understood that in the second point vector data, each row represents a pipeline point vector data, and each two pipeline point vector data form the data of a pipeline segment. After determining the start point number S_POINT and the end point number E_POINT of all end point pairs in the second point vector data, the end point pair data in the second point vector data needs to be further processed into pipeline segment vector data, each end point pair data corresponds to a pipeline segment vector data, and the pipeline segment vector data obtained after further processing is taken as the pipeline segment vector data in the new pipeline data.

[0119] It is worth noting that the correspondence between the final pipeline segment number PIPEID and the final start point number S_POINT and the end point number E_POINT exists in the second point vector data, and this correspondence needs to be further processed as the pipeline segment vector data in the updated pipeline data. For example, the field connection tool of ArcGIS is used to associate the correspondence between the PIPIP and the S_POINT and the E_POINT in the second point vector data to the pipeline segment vector data.

[0120] The third point vector data is taken as the pipeline point vector data in the new pipeline data.

[0121] 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 point number.

[0122] Specifically, the pipeline points with the same position coordinates in the second point vector data and the third point vector data are found out, and the 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, so as to obtain the geophysical point numbers of the mapped pipeline points.

[0123] It can be understood that, in the case of regarding the pipeline points with the same position coordinates 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, the 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, and after the mapping, all the pipeline points in the second point vector data have the geophysical point numbers.

[0124] For example, in the figures of Figure 2 , Figure 3 and Figure 4 , the geophysical point numbers of the two end points P1 and P9 of the pipeline segment P1P9 are 1 and 9 respectively, the geophysical point numbers of the two end points P9 and P10 of the pipeline segment P9P10 are 9 and 10 respectively, the geophysical point numbers of the two end points P10 and P2 of the pipeline segment P10P2 are 10 and 2 respectively, the geophysical point numbers of the two end points P3 and P11 of the pipeline segment P3P11 are 3 and 11 respectively, the geophysical point numbers of the two end points P11 and P4 of the pipeline segment P11P4 are 11 and 4 respectively, the geophysical point numbers of the two end points P5 and P11 of the pipeline segment P5P11 are 5 and 11 respectively, the geophysical point numbers of the two end points P11 and P6 of the pipeline segment P11P6 are 11 and 6 respectively, and the geophysical point numbers of the two end points P7 and P8 of the pipeline segment P7P8 are 7 and 8 respectively.

[0125] In the implementation, the positions of the end point pair data turning_point obtained in the step S3 and the points in the pipeline point vector data N_WSPOINT obtained in the step S4 are compared by using a spatial connection tool, and the points with the same geographical position, i.e. coordinates, are regarded as the same point, i.e. the numbers of the pipeline points in N_WSPOINT are mapped to turning_point.

[0126] Through the

Analysis Tools

Overlay

Spatial Join

Table Options

Export

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

[0128] 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;

[0129] 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.

[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]_1 and S_Origin[i] = Point[i]_2, then End_Point[i] = Point[i]_1 and Start_Point[i] = Point[i]_2;

[0132] 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;

[0133] 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.

[0134] 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.

[0135] 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.

[0136] Specifically, for example, Figure 4 As shown, in Figure 4 Before mapping, the starting point number S_POINT of the 8th pipeline segment P7P8 is 7, and the end point number E_POINT is 8. After mapping, the position coordinates of the two end points of the 8th pipeline segment P7P8 are the same as the position coordinates in the third point vector data. Therefore, the geophysical point numbers of the two end points of the 8th pipeline segment P7P8 after mapping are still 7 and 8. By comparison, it can be seen that the final starting point number S_POINT of the 8th pipeline segment P7P8 is 7, and the end point number E_POINT is 8.

[0137] For example, Figure 2 and Figure 3 As shown. Figure 2The start point number S POINT of the first pipeline segment P1P9 before mapping is 1, and the end point number E POINT is 2; the geophysical point numbers of the two end points of the first pipeline segment P1P9 after mapping are 1 and 9. Comparing, the final start point number S POINT corresponding to the first pipeline segment P1P9 is 1, and the end point number E POINT is 9. The start point number S POINT of the third pipeline segment P10P2 before mapping is 1, and the end point number E POINT is 2; the geophysical point numbers of the two end points of the third pipeline segment P10P2 after mapping are 10 and 2. Comparing, the final start point number S POINT corresponding to the third pipeline segment P10P2 is 10, and the end point number E POINT is 2.

[0138] In Figure 3 , the start point number S POINT of the fourth pipeline segment P3P11 before mapping is 3, and the end point number E POINT is 4; the geophysical point numbers of the two end points of the fourth pipeline segment P3P11 after mapping are 3 and 11. Comparing, the final start point number S POINT corresponding to the fourth pipeline segment P3P11 is 3, and the end point number E POINT is 11. In addition, it can be known that the final start point number S POINT corresponding to the fifth pipeline segment P5P11 is 5, and the end point number E POINT is 11; the final start point number S POINT corresponding to the sixth pipeline segment P11P6 is 11, and the end point number E POINT is 6; the final start point number S POINT corresponding to the seventh pipeline segment P11P4 is 11, and the end point number E POINT is 4, which will not be described here.

[0139] For example, as Figure 2 shown, the start point number S POINT of the second pipeline segment P9P10 before mapping is 1, and the end point number E POINT is 2; the geophysical point numbers of the two end points of the second pipeline segment P9P10 after mapping are 9 and 10. At this time, according to the topological relationship rule, the final start point number S POINT corresponding to the second pipeline segment P9P10 is 9, and the end point number E POINT is 10.

[0140] In implementation, the specific steps include:

[0141] 1) Input description: There are 4 columns of data in total, the first column PIPEID is the pipeline segment number PIPEID; the second column E POINT is the end point number before mapping; the third column S POINT is the start point number before mapping; and the fourth column EXP NO is the geophysical point number of the two end points after mapping (the start and end point correspondence is unknown).

[0142] 2) Output requirement: The start and end point numbers of the pipeline segment after mapping are corresponded to the pipeline segment.

[0143] 3) Logic implementation process:

[0144] i. Take out Point_1, Point_2 from two data in EXP_NO column data representing two endpoints of the same pipeline;

[0145] ii. Compare E_POINT, S_POINT column corresponding data E_Origin[i], S_Origin[i] with the Point_1, Point_2 taken out in the previous step to get the start point number Start_Point[i] and the end point number End_Point[i] corresponding to the pipeline i:

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

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

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

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

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

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

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

[0153] For the case in g, the topological relationship rules are determined.

[0154] Compared with the prior art, the pipeline data calibration method based on the "node-edge" relationship provided by the embodiment of the application re-divides the pipeline segments in the original pipeline segment vector data by using the fold points and the cross points, re-numbers the pipeline segment numbers of each divided pipeline segment, and determines the start and end directions of each divided pipeline segment, thereby realizing calibration of the original pipeline data. Meanwhile, important nodes in the original pipeline data that are not marked are intelligently generated, thereby avoiding manual inspection of each pipeline segment, improving the data processing efficiency, and providing an intelligent, efficient, replicable and generalizable pipeline data processing method.

[0155] Those skilled in the art can understand that all or part of the processes of the above-mentioned embodiments can be completed by a computer program instructing relevant hardware, and the program can be stored in a computer readable storage medium. The computer readable storage medium includes a magnetic disk, an optical disk, a read-only memory, a random access memory, etc.

[0156] The above description is only a preferred embodiment of the application, but the protection scope of the application is not limited thereto, and any person skilled in the art can easily think of changes or replacements within the technical range disclosed by the application, which should be covered within the protection scope of the application.

Claims

1. A pipeline data calibration method based on "node-edge" relationship, characterized in that: The calibration method comprises: Obtaining original pipeline data and newly added inflection points and span points, wherein the original pipeline data includes original pipeline segment vector data and original pipeline point vector data; the span point represents the intersection of two pipelines at different heights in the original pipeline segment vector data when projected onto a horizontal plane; Re-dividing the pipeline segments in the original pipeline segment vector data using the newly added inflection points and span points, and renumbering all the divided pipeline segments to obtain the first line vector data; 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 to obtain third point vector data; 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.

2. The calibration method according to claim 1, wherein: The re-dividing of the pipeline segments in the original pipeline segment vector data by using the newly added inflection points and span points includes: Taking the span point as a dividing point, dividing the pipeline segment having the span point in the original pipeline segment vector data; Taking the inflection point as a dividing point, dividing the pipeline segment with the inflection point in the original pipeline segment vector data; 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 calibration 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 calibration 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 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, the first point vector data is numbered to obtain third point vector data.

5. The calibration 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 to obtain third point vector data includes: Finding pipeline points in the first point vector data whose position coordinates are the same as those in the original pipeline point vector data as the old pipeline points, and assigning point attribute values ​​of each point in the original 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 taken as new pipeline points, and the geophysical prospecting point numbers of the new pipeline points are numbered to obtain the third point vector data.

6. The calibration 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 calibration 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 calibration method according to claim 7, characterized in that: 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: 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 calibration 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.

10. The calibration method according to claim 9, 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]_2 and S_Origin[i]≠Point[i]_1, then determine End_Point[i] and Start_Point[i] according to the topological relationship rules.

Images