Cable channel data acquisition method and system, medium and product

Abstract

The invention discloses a cable channel data acquisition method and system, a medium and a product, and relates to the technical field of data processing. The method comprises the following steps: firstly, acquiring sampling data comprising a cable well position, a channel type and a cable section attribute, and generating a code identifier according to the sampling data; and then, based on a cable section corresponding to the identifier, track coordinates and burial depth data are acquired by adopting an electromagnetic induction detection mode. The system calculates the spatial position deviation of the cable in the channel according to the collected data, and generates a deviation mark when the deviation exceeds a corresponding threshold value. And after the mark points are corrected, generating a cable path map and a channel profile map according to the code identifiers and the corrected coordinates, and finally converting the cable path map and the channel profile map into a result file in a preset format. By implementing the technical scheme provided by the invention, the accuracy of cable channel data acquisition can be improved.

Description

Technical Field

[0001] This application relates to the field of data processing technology, specifically to a method, system, medium, and product for acquiring data in cable channels. Background Technology

[0002] With the intelligent upgrading of urban underground infrastructure, the scale and complexity of underground pipelines such as power and communication lines are constantly increasing. As a key infrastructure carrying various pipelines, the accurate acquisition of spatial information of cable tunnels is of great significance for the scientific management of pipeline assets.

[0003] Currently, data acquisition for cable ducts primarily relies on establishing measurement benchmarks at cable wells and using surveying equipment to obtain the spatial coordinates of key nodes within the duct. This fixed-node-based acquisition method can obtain basic spatial information about cable ducts and has been widely used in underground pipeline surveys.

[0004] However, with the increasing density of underground pipelines, the internal space of cable tunnels is becoming increasingly compact. In practical applications, fixed-node-based acquisition methods struggle to accurately obtain the actual trajectory and burial depth data of cable segments, and the integrity and consistency of the acquired data are difficult to guarantee. Especially when the cable location deviates from the design position, the lack of effective spatial positioning and deviation analysis mechanisms easily leads to discrepancies between the acquired data and the actual situation, thereby reducing the accuracy of cable tunnel data acquisition. Summary of the Invention

[0005] This application provides a method, system, medium, and product for acquiring data in cable channels, which can improve the accuracy of data acquisition in cable channels.

[0006] The first aspect of this application provides a method for acquiring cable channel data, comprising: Acquire sampling data of the cable channel, the sampling data including cable well location information, channel type and cable segment attributes; A coded identifier is generated based on the cable well location information, channel type, and cable segment attributes. Based on the cable segment corresponding to the coded identifier, the trajectory coordinates and burial depth data of the cable segment are collected using electromagnetic induction detection. The spatial position deviation of the cable in the channel type is calculated based on the trajectory coordinates and burial depth data. When the spatial position deviation exceeds the deviation threshold corresponding to the channel type, a deviation mark is generated. The trajectory coordinates with the deviation markers are corrected, and a cable path diagram and a channel profile diagram are generated based on the coded identifier and the corrected trajectory coordinates. The cable path diagram and the channel profile diagram are then converted into output files in a preset format.

[0007] By adopting the above technical solution, sampling data of the cable channel is acquired and coded, and electromagnetic induction detection is used to collect the trajectory coordinates and burial depth data of the cable segment. Then, the spatial position deviation of the cable is calculated and corrected, ultimately generating a cable path map and a channel profile, thus achieving accurate acquisition of cable channel data. This solution overcomes the limitations of traditional fixed-node-based acquisition methods, accurately acquiring the actual trajectory and burial depth data of the cable segment. The introduction of a coding and identification mechanism ensures the integrity and consistency of the acquired data. Furthermore, by setting deviation thresholds for spatial position deviation analysis and correction, the problem of inaccurate data caused by cable position deviation from the design position is effectively solved, improving the accuracy of cable channel data acquisition.

[0008] Optionally, the road name and road direction are extracted from the cable well location information, and a road information code is generated based on the road direction to determine the numbering direction; an orientation code is generated based on the spatial relationship between the cable well location information and the road name; the number of the same channel type on the same side of the same road is counted, and a corridor sequence code is generated when the number exceeds a preset threshold; it is determined whether there is a new cable well between two adjacent cable wells based on the cable segment attributes, and if there is a new cable well, a supplementary sequence code is added after the road information code and orientation code of the previous cable well; the road information code, the orientation code, the corridor sequence code, and the supplementary sequence code are combined to generate the code identifier.

[0009] Optionally, the number of pipelines and their burial depth are extracted from the cable segment; when the number of pipelines is a single pipeline and the burial depth is less than a first depth threshold, electromagnetic induction detection is performed using preset first detection parameters; when the number of pipelines is multiple parallel pipelines or the burial depth is greater than or equal to the first depth threshold, electromagnetic induction detection is performed using preset second detection parameters; differential positioning is performed on the trajectory points obtained by electromagnetic induction detection to obtain the plane coordinates, elevation coordinates, and burial depth data of each trajectory point; the plane coordinates, elevation coordinates, and burial depth data are associated and stored with the coded identifier to generate the trajectory coordinates.

[0010] Optionally, the channel centerline position, channel cross-sectional dimensions, and pipe block arrangement position are extracted from the channel type; the sequence of trajectory points between two adjacent cable wells in the trajectory coordinates is extracted, and the planar offset of the trajectory point sequence relative to the channel centerline position is calculated; based on the burial depth data, the channel cross-sectional dimensions, and the pipe block arrangement position, the vertical deviation between the trajectory point sequence and the pipe block arrangement position is calculated; the planar offset is compared with a preset planar limit to obtain the planar deviation degree, and the vertical deviation is compared with a preset vertical limit to obtain the vertical deviation degree; the planar deviation degree and the vertical deviation degree are weighted and calculated to obtain the spatial position deviation.

[0011] Optionally, the following steps are taken: First, obtain a sequence of trajectory points with the deviation markers; extract the corresponding pipe block layout positions and channel cross-sectional parameters; generate a theoretical trajectory line based on the pipe block layout positions; project the trajectory point sequence onto the theoretical trajectory line to obtain corrected planar coordinates; perform linear interpolation on the burial depth data based on the channel cross-sectional parameters to obtain corrected vertical coordinates; combine the corrected planar coordinates and the corrected vertical coordinates to generate corrected trajectory coordinates; extract the corresponding cable well location information based on the encoded identifier, and generate a planar cable path diagram based on the corrected trajectory coordinates; use the cable wells in the planar cable path diagram as nodes, divide the cross-section according to a preset interval, and generate the channel profile diagram.

[0012] Optionally, the trajectory lines, cable wells, and annotation information in the cable route diagram are extracted and converted into vector layer data; a cross-sectional attribute table is generated based on the channel profile diagram, the cross-sectional attribute table including cross-sectional number, cable well code, burial depth data, and pipe block specifications; the vector layer data is classified according to a preset layer naming rule to generate a graphic data file; the cross-sectional attribute table is converted into a database format and associated with the graphic data file; according to a preset data exchange standard, the graphic data file and the database-formatted cross-sectional attribute table are packaged to generate the preset format result file.

[0013] Optionally, the system receives the as-built data of the cable channel and extracts the change type and change location information from the as-built data. It then queries the corresponding code identifier in the deliverable file based on the change location information. When the change type is splicing, relocation, or reconstruction, it obtains the changed cable segment trajectory coordinates and burial depth data, and updates the trajectory coordinates of the corresponding code identifier in the deliverable file based on the changed cable segment trajectory coordinates and burial depth data. The system recalculates and corrects the spatial position deviation of the updated trajectory coordinates, and updates the graphic data file and cross-sectional attribute table in the deliverable file. Finally, it generates a version number and update timestamp for the updated deliverable file and associates and stores the version number, update timestamp, and updated deliverable file in the database.

[0014] In a second aspect, embodiments of this application provide a cable channel data acquisition system, which includes: one or more processors and a memory; the memory is coupled to the one or more processors, and the memory is used to store computer program code, which includes computer instructions, and the one or more processors call the computer instructions to cause the cable channel data acquisition system to perform the method described in the first aspect and any possible implementation thereof.

[0015] Thirdly, embodiments of this application provide a computer-readable storage medium including instructions that, when executed on a cable channel data acquisition system, cause the cable channel data acquisition system to perform the method described in the first aspect and any possible implementation thereof.

[0016] Fourthly, embodiments of this application provide a computer program product containing instructions that, when the computer program product is run on a cable channel data acquisition system, cause the cable channel data acquisition system to perform the method described in the first aspect and any possible implementation thereof.

[0017] In summary, one or more technical solutions provided in this application have at least the following technical effects or advantages: By adopting the above technical solution, sampling data of the cable channel is acquired and coded, and electromagnetic induction detection is used to collect the trajectory coordinates and burial depth data of the cable segment. Then, the spatial position deviation of the cable is calculated and corrected, ultimately generating a cable path map and a channel profile, thus achieving accurate acquisition of cable channel data. This solution overcomes the limitations of traditional fixed-node-based acquisition methods, accurately acquiring the actual trajectory and burial depth data of the cable segment. The introduction of a coding and identification mechanism ensures the integrity and consistency of the acquired data. Furthermore, by setting deviation thresholds for spatial position deviation analysis and correction, the problem of inaccurate data caused by cable position deviation from the design position is effectively solved, improving the accuracy of cable channel data acquisition. Attached Figure Description

[0018] Figure 1 This is a flowchart illustrating a cable channel data acquisition method disclosed in an embodiment of this application; Figure 2 This is another schematic flowchart of a cable channel data acquisition method disclosed in an embodiment of this application; Figure 3 This is a schematic diagram of the structure of a system provided in an embodiment of this application.

[0019] Explanation of reference numerals in the attached drawings: 301, Central Processing Unit; 302, Read-Only Memory; 303, Random Access Memory; 304, Bus; 305, Input / Output Interface; 306, Input Section; 307, Output Section; 308, Storage Section; 309, Communication Section; 310, Driver; 311, Removable Media. Detailed Implementation

[0020] To enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments.

[0021] In the description of the embodiments of this application, the words "for example" or "for instance" are used to indicate examples, illustrations, or explanations. Any embodiment or design that is described as "for example" or "for instance" in the embodiments of this application should not be construed as being more preferred or advantageous than other embodiments or design options. Rather, the use of the words "for example" or "for instance" is intended to present the relevant concepts in a specific manner.

[0022] In the description of the embodiments of this application, the term "multiple" means two or more. For example, multiple systems means two or more systems, and multiple screen terminals means two or more screen terminals. Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the indicated technical features. Thus, a feature defined with "first" or "second" may explicitly or implicitly include one or more of that feature. The terms "comprising," "including," "having," and variations thereof all mean "including but not limited to," unless otherwise specifically emphasized.

[0023] This application provides a method for acquiring data in cable channels, referring to... Figure 1 , Figure 1 This is a flowchart illustrating a cable channel data acquisition method provided in an embodiment of this application. The method is applied to a system, which refers to a hardware and software integrated platform capable of executing a cable channel data acquisition program. The system can execute a cable channel data acquisition program, and the method includes steps 101 to 105, as follows: Step 101: Obtain sampling data of the cable channel, including cable well location information, channel type and cable segment attributes.

[0024] Cable ducts refer to underground linear engineering facilities used for laying power, communication, and other cables, including cable wells and cable sections. Cable well location information refers to the spatial positioning data of the cable well, including latitude and longitude coordinates, ground elevation, and well cover elevation. The duct type refers to the structural form of the cable duct, such as pipe gallery type, trench type, or culvert type, each type having different cross-sectional dimensions and pipe block arrangement. Cable section attributes refer to the characteristic parameters of the duct section between two adjacent cable wells, including the number of pipes, burial depth, laying method, and cable specifications. For example, a cable duct under a city road might have cable well location information of "longitude 116.123456, latitude 39.654321, ground elevation 35.6 meters," a duct type of "trench type, cross-sectional dimensions 2000×1000mm," and cable section attributes of "3 10kV power cables, burial depth 1.5 meters, pipe laying."

[0025] Specifically, firstly, GNSS RTK surveying equipment is used to locate the cable well, obtaining the plane coordinates of the well cover's center point. A level is used to measure the ground elevation and the well cover's elevation, thus forming the cable well's location information. Secondly, through on-site investigation and verification with design drawings, information such as the channel's structural type, cross-sectional dimensions, and pipe block arrangement is recorded to determine the channel type. Finally, a pipeline detector is used to inspect the cable section, recording parameters such as the number of pipelines and their burial depth. Cable specifications and laying methods are obtained through manual inspection, forming the cable section's attributes. Measurement data is recorded using a handheld data logger, survey information is filled in a dedicated form, and detection data is automatically stored by the equipment. All data is formatted and then imported into a database. In actual operation, the measurement accuracy should meet the requirements of surveying and mapping specifications: the plane position measurement error should not exceed ±10mm, the elevation measurement error should not exceed ±5mm, and the sampling interval for detection data is set to 1 meter.

[0026] Step 102: Generate a coded identifier based on the cable well location information, channel type, and cable segment attributes.

[0027] The coded identifier is a character sequence used to uniquely identify each cable segment in a cable tunnel, generated using a hierarchical coding method. The coded identifier consists of four parts: road information code, orientation code, corridor sequence code, and supplementary sequence code. The road information code reflects the road name and direction, such as "HF-N" indicating "Hefeng Road - Northbound"; the orientation code indicates the position of the cable manhole relative to the road, such as "E" indicating "East"; the corridor sequence code indicates the sequence number of the tunnel on the same side, such as "C2" indicating "Second Tunnel"; the supplementary sequence code is used to identify newly added cable manholes, such as "S01" indicating "First New Manhole". A complete example of a coded identifier: "HF-NE-C2-S01", representing the first newly added manhole segment in the second tunnel on the east side of Hefeng Road, heading north.

[0028] Specifically, firstly, the first letter or pinyin abbreviation of the road name is extracted and combined with the road direction (N / S for north-south and E / W for east-west) to generate a road information code. Then, the orientation is determined based on the relative position of the cable manhole center point to the road centerline: east is represented by E, west by W, south by S, and north by N. Next, the number of passages on the same side of the same road is counted and numbered sequentially from the inside out, generating a corridor sequence code in the format "C + sequence number". Finally, it is checked whether there are any newly added cable manholes not marked in the design drawings between adjacent cable manholes; for these new manholes, a supplementary sequence code is generated using the format "S + two-digit sequence number". Finally, the four parts of the code are combined in the format "road information code - orientation code - corridor sequence code - supplementary sequence code", connected by hyphens "-" to form a complete code identifier. After generation, the code is stored in a database and associated with the spatial data of the cable segment. The coding rules are fixed to ensure that the code identifiers within the same area are not duplicated, facilitating subsequent data processing and querying.

[0029] In one possible implementation, a coded identifier is generated based on the cable well location information, channel type, and cable segment attributes, specifically including steps 1021-1025, as follows: Step 1021: Extract the road name and road direction from the cable well location information, and generate road information codes based on the road direction to determine the numbering direction.

[0030] Road names refer to the standard names of urban roads, consisting of a combination of letters and numbers, such as "Hefeng Road" and "Innovation Avenue". Road direction refers to the direction in which the road extends, with two basic types: north-south and east-west. Numbering direction refers to the starting and increasing direction of numbering on the same road; north-south roads are numbered from south to north, and east-west roads are numbered from west to east. Road information codes consist of the road name abbreviation and direction identifier, such as "HF-N" for "Hefeng Road - Northbound" and "CX-E" for "Innovation Avenue - Eastbound".

[0031] Specifically, first, extract the name of the road where the cable well is located from the cable well coordinate data. For Chinese road names, extract the first letter of the pinyin (e.g., "Hefeng Road" is extracted as "HF"), and for English road names, extract the capital letters (e.g., "INNOVATION ROAD" is extracted as "IR"). Then, determine the road orientation by calculating the angle between the line connecting the two endpoints of the road and the due north direction. If the angle is within the range of -45° to 45°, it is determined to be north-south and marked as N / S. If the angle is within the range of 45° to 135°, it is determined to be east-west and marked as E / W. Then, determine the numbering direction according to the road orientation. For north-south roads, number from the south end to the north, and for east-west roads, number from the west end to the east. Finally, connect the abbreviated road name and the orientation identifier with a hyphen "-" to form the road information code.

[0032] Step 1022: Generate an orientation code according to the spatial position relationship of the cable well position information relative to the road name.

[0033] The spatial position relationship refers to the relative position of the center point of the cable well relative to the center line of the road, including four basic relationships: east side, west side, south side, and north side. The orientation code uses a single capital letter to represent the position relationship, E represents the east side, W represents the west side, S represents the south side, and N represents the north side. For example, if a cable well is located on the east side of Hefeng Road, its orientation code is "E".

[0034] Specifically, first, obtain the linear equation of the road center line and the plane coordinates of the cable well. Then, calculate the perpendicular distance from the cable well coordinate point to the road center line and the projection position. For north-south roads, determine the east-west relationship by comparing the difference in the abscissa between the cable well coordinates and the road center line coordinates. A positive coordinate difference indicates it is on the east side and is coded as "E", and a negative coordinate difference indicates it is on the west side and is coded as "W". For east-west roads, determine the north-south relationship by comparing the difference in the ordinate. A positive coordinate difference indicates it is on the north side and is coded as "N", and a negative coordinate difference indicates it is on the south side and is coded as "S". Finally, use the determined orientation letter as the orientation code.

[0035] Step 1023: Count the number of channel types on the same side of the same road. When the number exceeds the preset threshold, generate a corridor sequence code.

[0036] The number of channel types refers to the number of cable channels laid in parallel on the same side (east side, west side, south side, or north side) of the same road. The preset threshold is the channel number standard that triggers the generation of the corridor sequence code, usually set to 2. The corridor sequence code adopts the format of "C + serial number", such as "C1" represents the first channel, and "C2" represents the second channel. For example, if there are 3 parallel channels on the east side of a certain road, when the threshold of 2 is exceeded, they are coded as "C1", "C2", and "C3" from the inside to the outside in sequence.

[0037] Specifically, the system first groups roads by name and location, counting the number of passages within each group. For groups exceeding a preset threshold (2 passages), a sequence coding generation program is initiated. Coding is generated from the inside out, with the passage closest to the road centerline coded as "C1," and incrementing outwards. In practice, the vertical distance from each passage to the road centerline is calculated, and the passages are sorted in ascending order of distance. The letter "C" is then concatenated with the sorting number (starting from 1) to form the corridor sequence code. For groups with fewer than the preset threshold, no corridor sequence code is generated, and the relevant fields are left blank. All generated codes are stored in a database and linked to the channel spatial data.

[0038] Step 1024: Determine whether there is a new cable well between two adjacent cable wells based on the cable segment attributes. If there is a new cable well, add a supplementary sequence code after the road information code and orientation code of the previous cable well.

[0039] Adjacent cable manholes refer to two cable manholes directly connected within the same conduit. Newly added cable manholes are those added later between the cable manholes marked on the original design drawings, typically to address line adjustments or maintenance needs. The supplementary sequence code uses the format "S + two-digit serial number" to identify the order of the newly added cable manholes, such as "S01" for the first newly added manhole and "S02" for the second. The preceding cable manhole refers to the previous designed cable manhole along the numbering direction. For example, if a new cable manhole is added after the cable manhole numbered "HF-NE", its supplementary sequence code is "S01", and the complete code is "HF-NE-S01".

[0040] Specifically, firstly, the measured pipeline length and the spacing data of adjacent cable wells in the design drawings are extracted from the cable segment attributes. When the difference between the measured length and the design spacing exceeds 5 meters, the new well judgment process is initiated. A portable detection device is used to scan the cable segment meter by meter, recording the location of signal abrupt change points. On-site verification is conducted at these signal abrupt change points to confirm the existence of new cable wells. For confirmed new cable wells, they are sequentially numbered according to the direction from the starting well to the ending well, generating a supplementary sequence code in the format "S + two-digit serial number". This supplementary sequence code is added after the road information code and orientation code of the previous designed cable well, connected by a hyphen "-". The serial number of the supplementary sequence code uses two digits from 01 to 99, increasing sequentially according to the order of addition. The complete code for each new well is formed by adding the supplementary sequence code after the basic code of its previous designed cable well.

[0041] Step 1025: Combine the road information code, orientation code, corridor sequence code, and supplementary sequence code to generate a code identifier.

[0042] The coded identifier is a unique identification code for each cable segment in a cable tunnel, consisting of four parts: road information code (reflecting the road it is located on), orientation code (indicating relative location), corridor sequence code (identifying parallel tunnels), and supplementary sequence code (marking newly added manholes). The combination rule uses a fixed order of concatenation, with each part separated by a hyphen "-". A complete coding example: "HF-NE-C2-S01", representing the first newly added manhole segment of the second tunnel on the north-to-east side of Hefeng Road.

[0043] Specifically, first, the validity of the four coding parts is checked. Road information coding and orientation coding are mandatory, while corridor sequence coding and supplementary sequence coding are filled in according to the actual situation. Then, they are arranged in a fixed order: "Road Information Coding - Orientation Coding - Corridor Sequence Coding - Supplementary Sequence Coding". Each coding part is connected by a hyphen "-". For non-existent coding parts, they are skipped without retaining the hyphen. The generated coding identifier should conform to the following format specifications: letters are all uppercase, numbers are Arabic numerals, and no other special characters are used except for hyphens. The coding length is determined based on the actual components, with a minimum including road information coding and orientation coding (e.g., "HF-NE") and a maximum including all four parts (e.g., "HF-NE-C2-S01"). The generated coding identifier is stored in the database and associated with the spatial and attribute data of the cable segment.

[0044] Step 103: Based on the cable segment corresponding to the coded identifier, the trajectory coordinates and burial depth data of the cable segment are collected using electromagnetic induction detection.

[0045] Electromagnetic induction detection is a method of locating cables by utilizing the electromagnetic field generated when the cable is energized. It includes two modes: active detection (applying a signal to the cable) and passive detection (using power frequency signals). Trajectory coordinates refer to the position data of a cable segment in three-dimensional space, including planar coordinates (X, Y) and elevation coordinates (H). Burial depth data represents the vertical distance of the cable from the ground surface, in meters. A cable segment refers to the passage between two adjacent cable manholes. For example, a cable segment coded "HF-NE-C2" has trajectory coordinates of "X=553421.325, Y=3452678.156, H=35.624" and a burial depth of "1.5 meters".

[0046] Specifically, the starting and ending cable manhole locations of the cable segment to be detected are first determined based on the coded identifier. A transmitter from the detector then applies a specific frequency (typically 33kHz) detection signal to the target cable at the starting cable manhole. A receiver is used to collect data at 1-meter intervals along the expected cable route, recording the three-dimensional coordinates and burial depth of each point. The signal strength is strongest when the receiver probe is directly above the cable; the recorded coordinates at this point represent the cable location. Simultaneously, the burial depth is calculated by measuring the probe's tilt angle to the ground and the electromagnetic field strength. The coordinates of each measurement point are obtained using GNSS RTK technology, achieving a positioning accuracy better than ±2 cm. For sections with weak signals, the transmission power is appropriately increased or the detection frequency is adjusted. The detection data is stored in real-time in the data acquisition unit, including the measurement point number, planar coordinates, elevation coordinates, burial depth, and signal strength. The signal is verified at the ending cable manhole to ensure the continuity and integrity of the detection data. Finally, the collected coordinate and burial depth data are associated with the coded identifier and stored in a database for unified management.

[0047] In one possible implementation, based on the cable segment corresponding to the coded identifier, the trajectory coordinates and burial depth data of the cable segment are collected using electromagnetic induction detection, specifically including steps 1031-1034, as follows: Step 1031: Extract the number of pipelines and burial depth from the cable segment; when the number of pipelines is a single pipeline and the burial depth is less than the first depth threshold, use the preset first detection parameters to perform electromagnetic induction detection.

[0048] The number of pipelines refers to the number of cables laid in a cable segment, categorized as a single pipeline (1 cable) or multiple parallel pipelines (2 or more cables). Burial depth refers to the vertical distance from the top of the cable to the ground surface, measured in meters. The first depth threshold is set to 1.5 meters as the criterion for selecting detection parameters. The first detection parameter is for shallowly buried single-pipe situations, with a transmission power of 0.5W, a detection frequency of 33kHz, and a sampling interval of 1 meter. Specific example: A cable segment contains one 10kV cable buried at a depth of 1.2 meters; the first detection parameter is suitable for detection.

[0049] Specifically, an on-site investigation was conducted at the cable well. The number of pipes was recorded by observing the number of pipe holes and checking cable identification signs. The burial depth was measured at the cable well opening using a depth sounder, with 5 measurements taken and the average value taken. The measured burial depth was compared with the first depth threshold of 1.5 meters. When there was only one pipe and the burial depth was less than 1.5 meters, the first detection parameter configuration was activated: the transmitter power was set to 0.5W, the detection frequency was selected to be 33kHz, and the sampling interval was set to 1 meter. A direct connection method was used during detection, with the signal clamp directly connected to the metal sheath of the cable. The receiver used a single antenna mode and was set to a medium sensitivity level. A measurement point was recorded every 1 meter along the cable path, with the probe kept vertical at the measurement point, and the measurement point acquisition duration was set to 3 seconds.

[0050] Step 1032: When the number of pipelines is multiple parallel pipelines or the burial depth is greater than or equal to the first depth threshold, electromagnetic induction detection is performed using preset second detection parameters.

[0051] Multiple parallel pipelines refer to two or more cables laid in parallel within the same cable segment. The second detection parameter refers to the detection settings for deep burial or multi-pipe situations, with the transmission power set to 2W, the detection frequency set to 8kHz, and the sampling interval set to 0.5 meters. Specific example: A cable segment contains three parallel 10kV cables, buried at a depth of 1.8 meters, and the second detection parameter is suitable for detection.

[0052] Specifically, first, confirm that there are multiple parallel pipelines in the cable section or that the burial depth is greater than or equal to 1.5 meters; then adjust the parameters of the detection equipment: set the transmitter power to 2W, set the detection frequency to 8kHz to increase the signal penetration depth, and set the sampling interval to 0.5 meters to improve the positioning accuracy; apply signals to the multiple parallel pipelines one by one using an inductive clamp method; set the receiver to dual-antenna mode to improve the sensitivity level; perform a 360-degree rotation scan at each measuring point during detection to determine the precise location of each pipeline; set the acquisition time at the measuring point to 5 seconds to increase the average number of data points; and simultaneously record the relative positional relationship and spacing data of each pipeline.

[0053] Step 1033: Perform differential positioning on the trajectory points obtained by electromagnetic induction detection to obtain the plane coordinates, elevation coordinates and burial depth data of each trajectory point.

[0054] Differential positioning refers to a measurement method that uses a base station and a rover station for real-time coordinate correction. Track points refer to spatial location points collected at fixed intervals along the cable path. Planar coordinates use the X and Y coordinates of the National Coordinate System 2000, elevation coordinates use the 1985 National Elevation Datum, and burial depth data refers to the vertical distance from the top of the cable to the ground surface at each track point.

[0055] Specifically, the first step is to select known coordinate control points to set up a GNSS reference station; the second step is to start the RTK rover to establish a data link with the reference station, confirming that the number of satellites reaches more than 10; the third step is to fix the GNSS antenna directly above the receiver probe at each detection point; the fourth step is to collect data when the position accuracy reaches 2 cm, recording the geodetic coordinates B, L, and H of the measurement point; the fifth step is to use coordinate transformation software to convert the geodetic coordinates to plane rectangular coordinates X and Y; the sixth step is to obtain the elevation coordinates by GNSS elevation reduction to the leveling point; the seventh step is to have the receiver automatically calculate the burial depth data based on the electromagnetic field strength; the eighth step is to increase the observation time or use multiple measurements to take the average value for areas with poor signal; all data use a unified coordinate system and projection parameters.

[0056] Step 1034: Associate and store the plane coordinates, elevation coordinates, and burial depth data with the coded identifier to generate trajectory coordinates.

[0057] Association storage refers to establishing a correspondence between the collected spatial data and the coded identifier and saving them uniformly. Trajectory coordinates refer to a complete dataset describing the spatial location of the cable, including the coded identifier, plane coordinates, elevation coordinates, burial depth data, and acquisition time. Example of complete data: Measurement point code is HF-NE-C2, X coordinate value is 553421.325, Y coordinate value is 3452678.156, elevation value is 35.624 meters, burial depth value is 1.5 meters, acquisition time is 20260113143022.

[0058] Specifically, the first step is to establish a trajectory point table and a code identifier table as a unified data storage structure. The trajectory point table includes fields for point number, X-coordinate, Y-coordinate, elevation, burial depth, and acquisition time. The code identifier table includes fields for code, starting well, ending well, pipeline type, and burial method. The second step is to link the two data tables through the code identifier to achieve unified management of spatial and attribute data. The third step is to use database transactions to ensure data integrity, submitting data upon completion of a cable segment detection. The fourth step is to set up both differential backup and full backup methods for automatic data backup. The fifth step is to establish unique indexes and spatial indexes to improve data query efficiency. The sixth step is to establish a data update mechanism to record update time and update personnel information. The main differences between the preset first and second detection parameters lie in three aspects: transmission power, detection frequency, and sampling interval. The transmission power of the first detection parameter is set to 0.5W, lower than the 2W of the second detection parameter; the detection frequency of the first detection parameter is set to 33kHz, higher than the 8kHz of the second detection parameter; and the sampling interval of the first detection parameter is set to 1 meter, greater than the 0.5 meters of the second detection parameter. These parameter configuration differences are primarily based on the detection requirements of different application scenarios: the first detection parameter is suitable for simple scenarios with a single pipeline and a burial depth of less than 1.5 meters. In this case, lower power is used to avoid signal interference, higher frequency to improve near-surface response, and larger sampling interval to improve work efficiency. The second detection parameter is suitable for complex scenarios with multiple parallel pipelines or a burial depth of 1.5 meters or greater. In this case, higher power is used to ensure signal penetration, lower frequency to reduce attenuation loss, and smaller sampling interval to improve positioning accuracy. Differentiated parameter configurations meet the detection accuracy requirements of different scenarios while balancing detection efficiency and equipment energy consumption.

[0059] Step 104: Calculate the spatial position deviation of the cable in the channel type based on the trajectory coordinates and burial depth data. When the spatial position deviation exceeds the deviation threshold corresponding to the channel type, a deviation mark is generated.

[0060] The trajectory coordinates refer to the three-dimensional spatial position data of each measuring point in the cable segment, including X-coordinate, Y-coordinate, and elevation value. Burial depth data refers to the vertical distance from the top of the cable to the ground surface at the measuring point. Channel type refers to the structural form of the cable channel, including pipe gallery type, trough type, and trench type, each with standard cross-sectional dimensions and block layout specifications. Spatial position deviation refers to the degree of deviation of the actual cable position from the designed position, calculated from the horizontal offset and vertical deviation. Deviation threshold refers to the maximum allowable position deviation for different channel types, such as a horizontal deviation threshold of 0.3 meters and a vertical deviation threshold of 0.2 meters for a pipe gallery type channel. Deviation marking is a data identifier used to mark the position of measuring points exceeding the threshold. Specific example: The trajectory coordinates of a measuring point in a trough type channel are X=553421.325, Y=3452678.156, H=35.624, with a burial depth of 1.5 meters. The calculated horizontal offset is 0.4 meters and the vertical deviation is 0.3 meters, exceeding the threshold and requiring marking.

[0061] Specifically, firstly, the design data for the channel type is read, including the channel centerline coordinates, cross-sectional dimensions, and pipe block layout. For each measuring point, its vertical distance from the channel centerline is calculated as the planar offset. The calculation method is as follows: the shortest distance from the measuring point coordinates to the centerline is used, specifically the point-to-straight-line distance formula d=|Ax0+By0+C| / M, where A, B, and C are the centerline equation parameters, x0 and y0 are the measuring point coordinates, and M is a coefficient. Then, the vertical deviation of the measuring point is calculated by comparing the burial depth data with the pipe block design elevation. The vertical deviation is equal to the measured burial depth minus the design burial depth. Next, a weighted calculation is performed to obtain the spatial position deviation. The calculation formula is: Spatial position deviation = K × D, where K is the weighting coefficient and D is the deviation base. For pipe gallery-type channels, the planar weight is 0.6 and the vertical weight is 0.4; for trough-type channels, the planar weight is 0.5 and the vertical weight is 0.5; and for trench-type channels, the planar weight is 0.4 and the vertical weight is 0.6. The calculated spatial position deviation is compared with the deviation threshold corresponding to the channel type. When the spatial position deviation is greater than the deviation threshold, a deviation marker field is added to the database for the measuring point, with the marker value set to 1. At the same time, the specific deviation value and deviation direction are recorded.

[0062] In one possible implementation, the spatial position deviation of the cable in the channel type is calculated based on the trajectory coordinates and burial depth data, specifically including steps 1041-1043, as follows: Step 1041: Extract the channel centerline position, channel cross-sectional dimensions, and pipe block layout position from the channel type; extract the trajectory point sequence between two adjacent cable wells in the trajectory coordinates, and calculate the planar offset of the trajectory point sequence relative to the channel centerline position.

[0063] The centerline position of the cable channel refers to the coordinate sequence of the centerline of the cable channel in a plane, used to locate the channel's direction. The channel cross-sectional dimensions refer to the width and height of the channel's cross-section, such as a trough-type channel with a cross-section of 2000 × 1000 mm. The cable block arrangement position refers to the designed installation position of the cable block within the channel cross-section, including the horizontal distance from the centerline and the vertical distance from the bottom. The trajectory point sequence refers to a set of ordered coordinates of measuring points obtained through detection between adjacent cable wells. The planar offset refers to the horizontal and vertical distances from the measured trajectory points to the channel centerline.

[0064] Specifically, firstly, the design parameters corresponding to the channel type are read from the channel design database, and the coordinate sequence of feature points of the channel centerline is extracted. The centerline equation is obtained through linear fitting. Secondly, the standard cross-sectional diagram of the channel is read, and the cross-sectional dimension data, including key dimensions such as trench width, clearance height, and wall thickness, are extracted. Thirdly, the pipe block layout diagram is extracted to obtain the relative arrangement positions of the pipe blocks within the cross-section. Fourthly, the measurement point data between adjacent cable wells is retrieved from the trajectory coordinate data table according to the code identifier, and the measurement points are arranged according to the acquisition time sequence to form a trajectory point sequence. For each trajectory point, its coordinates are first substituted into the centerline equation to calculate the point to the straight line. The distance is calculated using the formula for the distance from the midpoint to the line in plane analytical geometry. Let the equation of the centerline be ax + by + c = 0, and the coordinates of the measuring point be x0 / y0. Then, the plane offset d = |ax0 + by0 + c| / M, where M is a coefficient. The calculated offset is compared with the pipe block layout position marked on the channel design drawing to determine the offset direction. A plane offset field is added to each measuring point in the database to record the offset value and direction identifier. Measuring points with offsets exceeding 1 / 4 of the channel width are marked as key verification objects. Database transactions ensure the integrity of the batch calculation results.

[0065] Step 1042: Based on the burial depth data, channel cross-sectional dimensions, and pipe block layout location, calculate the vertical deviation between the trajectory point sequence and the pipe block layout location.

[0066] Burial depth data refers to the vertical distance from the top of the cable to the ground surface, measured in meters, obtained through electromagnetic induction detection. Channel cross-sectional dimensions refer to the geometric dimensions of the channel's cross-section, including the total channel height, channel clearance height, and foundation burial depth. Pipe block placement refers to the vertical design elevation of the pipe block within the channel cross-section, determined relative to the bottom of the channel. Trajectory point sequence refers to a set of continuously measured spatial location points. Vertical deviation refers to the difference in the vertical direction between the measured cable position and the designed pipe block position.

[0067] Specifically, firstly, a unified elevation benchmark system is established, unifying the ground surface elevation, the top elevation of the passage, the bottom elevation of the passage, and the design elevation of the pipe blocks to the 1985 National Elevation Benchmark; the passage design cross-section is read, and the passage structural dimension data is extracted, including the total passage height H1, the passage clearance height H2, and the foundation burial depth H3; the pipe block layout cross-section is extracted, and the design elevation h1 of the pipe block from the bottom of the passage is obtained; the design burial depth D1 of the pipe block is calculated using the formula: D1 = Ground surface elevation - Top elevation of the passage + Total passage height - Elevation of the pipe block from the bottom; for each trajectory point, the measured burial depth data D2 is read; the vertical deviation value is calculated using the formula: Vertical deviation = D2 - D1; a deviation direction indicator is set, marking a downward offset when D2 is greater than D1, and an upward offset otherwise; a vertical deviation field is added to the database for each measuring point, recording the deviation value and direction indicator; measuring points with a vertical deviation exceeding 1 / 3 of the passage clearance height are marked as key review targets; finally, systematic vertical deviations are identified through statistical analysis, providing a basis for subsequent passage structure adjustments.

[0068] Step 1043: Compare the plane offset with the preset plane limit to obtain the plane deviation, and compare the vertical deviation with the preset vertical limit to obtain the vertical deviation; perform a weighted calculation on the plane deviation and the vertical deviation to obtain the spatial position deviation.

[0069] Planar tolerance refers to the permissible deviation in planar position specified in the tunnel design code, such as a 0.3-meter plane tolerance for a utility tunnel. Vertical tolerance refers to the permissible deviation in vertical position specified in the tunnel design code, such as a 0.2-meter vertical tolerance for a utility tunnel. Planar deviation degree refers to the ratio of the measured planar offset to the plane tolerance. Vertical deviation degree refers to the ratio of the measured vertical deviation to the vertical tolerance. Spatial position deviation refers to the overall degree of deviation in both the planar and vertical directions.

[0070] Specifically, first, read the design specifications corresponding to the channel type and extract the planar deviation value L1 and the vertical deviation value L2; for the planar offset M1 of each measuring point, calculate the planar deviation D1 = M1 / L1; for the vertical deviation M2 of each measuring point, calculate the vertical deviation D2 = M2 / L2; select the corresponding weighting coefficient according to the channel type: for pipe gallery type channels, set the planar weight W1 = 0.6 and the vertical weight W2 = 0.4; for trough type channels, set the planar weight W1 = 0.5 and the vertical weight W2 = 0.5; for trench type channels, set the planar weight W1 = 0. 4. Vertical weight W2 = 0.6; Calculate spatial position deviation S = W1 × D1 + W2 × D2; Set deviation level classification standards: S < 1.0 is normal range, 1.0 ≤ S < 1.5 is slight deviation, 1.5 ≤ S < 2.0 is moderate deviation, and S ≥ 2.0 is severe deviation; Add plane deviation, vertical deviation, spatial position deviation, and deviation level fields to each measuring point in the database; Generate deviation markers for measuring points with spatial position deviations exceeding 1.0; Identify deviation distribution patterns through data statistical analysis and establish a deviation distribution chart.

[0071] Step 105: Correct the trajectory coordinates with deviation markers, generate cable path diagrams and channel profile diagrams based on the coded identifiers and corrected trajectory coordinates, and convert the cable path diagrams and channel profile diagrams into result files in a preset format.

[0072] Deviation markers indicate measurement points whose spatial deviation exceeds a threshold. Correction processing refers to the data processing procedure of adjusting the deviation measurement points to reasonable positions. Cable route diagrams are engineering drawings showing the planar direction of cables, including information such as cable well locations, pipeline routes, and laying positions. Channel cross-section diagrams are engineering drawings showing the cross-sectional structure of channels, including channel dimensions, pipe block layout, and cable positions. Preset format deliverables refer to engineering file formats conforming to industry standards, such as DWG format drawings and MDB format databases.

[0073] Specifically, the first stage involves data correction, which involves screening measuring points marked with deviations and reading data from normal measuring points within 5 meters before and after each measuring point; generating a correction curve using cubic spline interpolation, with the control points selected from the coordinates of the normal measuring points; calculating the projection position of the deviation measuring point onto the correction curve as the corrected coordinates; the corrected coordinates must meet the following requirements: the offset from the channel centerline must be less than the plane tolerance, and the difference from the design burial depth must be less than the vertical tolerance; the second stage involves drawing generation, setting the drawing scale to 1:500 and the drawing size to A1; and drawing the cable route diagram, including: overlaying the base map, the channel centerline, and... The process includes: 1) cable well symbols, pipeline routes, measuring point locations, coding labels, and legend descriptions; 2) generating channel profiles, including cross-sectional dimensions, pipe block layout, cable locations, soil cover depth, and elevation markings; 3) format conversion, converting graphic data to DWG format, with layer settings including: base layer, pipeline layer, label layer, and well location layer; 4) exporting attribute data to MDB format, with data tables including: measuring point table, pipeline table, and cable well table; 5) establishing the relationship between graphic and attribute data; 6) adding auxiliary elements such as title blocks, legends, and annotations; and 7) outputting the final file and performing data integrity checks.

[0074] In one possible implementation, the trajectory coordinates with deviation markers are corrected, and a cable path diagram and a channel profile diagram are generated based on the encoded identifier and the corrected trajectory coordinates. Specifically, this includes steps 1051-1055, as follows: Step 1051: Obtain the trajectory point sequence with deviation markers, and extract the pipe block layout position and channel cross-sectional parameters corresponding to the trajectory point sequence.

[0075] The deviation marker trajectory point sequence refers to a set of continuous measurement point data where the spatial position deviation exceeds a threshold. Each measurement point includes three-dimensional coordinates and a deviation value. The pipe block layout location refers to the designed installation location of the cable pipe block within the channel, including horizontal offset distance and vertical burial depth. Channel cross-sectional parameters refer to the geometric dimensions describing the cross-sectional characteristics of the channel, including channel width, channel height, wall thickness, foundation depth, etc. Specific example: Five consecutive measurement points in a cable segment mark the deviation, corresponding to a trough-type channel cross-section of 2000×1000 mm. The designed location of the pipe block is 300 mm to the left of the centerline and 200 mm from the bottom.

[0076] Specifically, the process begins by executing a database query to retrieve measurement point records marked with deviations. Then, using SQL statements, the measurement points are sorted in ascending order by their numbers, and their complete attributes are extracted, including coordinates, burial depth, deviation, and acquisition time. The measurement point data is grouped, with points spaced less than 10 meters apart grouped together to form a continuous sequence of trajectory points. The channel design data corresponding to each group of measurement points is read, and the pipe block layout diagram is extracted to obtain the pipe block design location parameters: horizontal offset X1, vertical burial depth Y1, and pipe block diameter D1. The standard channel cross-section diagram is extracted, and the cross-section parameters are analyzed: total channel width W1, net width W2, total height H1, net clearance height H2, wall thickness T1, and foundation burial depth B1. The trajectory point sequence is then associated with the pipe block design location and cross-section parameters. An operation log is recorded during the data extraction process, including data extraction time, number of records, and association identifiers. A data cache is established for subsequent correction calculations. Database transactions ensure the integrity and consistency of the extracted data.

[0077] Step 1052: Generate a theoretical trajectory line based on the location of the pipe block, project the trajectory point sequence onto the theoretical trajectory line to obtain the corrected planar coordinates; perform linear interpolation on the burial depth data based on the channel cross-section parameters to obtain the corrected vertical coordinates.

[0078] The theoretical trajectory line refers to the standard path line generated based on the designed location of the cable block, reflecting the ideal laying path of the cable. Planar coordinate projection refers to mapping the coordinates of measured points to orthogonal projection points on the theoretical trajectory line. Linear interpolation refers to a mathematical method that uses linear functions to correct the burial depth data. The corrected planar coordinates refer to the two-dimensional position data after projection. The corrected vertical coordinates refer to the burial depth data after interpolation calculation. Specific example: The planar coordinates of a certain deviation measurement point sequence are 553421.325 / 3452678.156, with a burial depth of 1.5 meters. The corrected coordinates after projection onto the theoretical trajectory line are 553421.000 / 3452678.000, and the corrected burial depth after interpolation is 1.3 meters.

[0079] Specifically, firstly, the location data of the pipe block layout is extracted, including the coordinates of adjacent cable wells and the offset value of the pipe block centerline; the theoretical trajectory line equation is generated using the piecewise cubic Hermite interpolation method, with the interpolation nodes selected from the cable well locations and the designed offset points of the pipe blocks; for each deviation measurement point P, the shortest distance projection point P' to the theoretical trajectory line is calculated; the projection calculation adopts an iterative method, setting the initial projection point position, calculating the normal direction from the measurement point to the curve, and adjusting the projection point position along the normal direction until convergence; the convergence condition is that the difference between the projection point positions of two adjacent calculations is less than 1 mm; the corrected plane coordinate values, including the X and Y coordinates, are recorded.

[0080] Then, the channel cross-sectional parameters are read to determine the design burial depth of the pipe block; the burial depth data of normal measuring points within a 5-meter range before and after the deviation measuring point are extracted; a linear interpolation function is established, with the measuring point mileage as the independent variable and the burial depth value as the dependent variable; the interpolation calculation adopts a piecewise linear method, selecting two adjacent normal measuring points for interpolation in each segment; for the deviation measuring point, the corrected burial depth value is calculated based on its mileage position and substituted into the interpolation function; the calculation result must meet the following requirements: the corrected burial depth value is not less than the design burial depth of the pipe block and not greater than the top cover depth of the channel; the corrected vertical coordinate values ​​are recorded. All corrected data are stored in the database, including: original coordinates, corrected coordinates, correction method, and correction time; data verification ensures that the correction results meet the design specifications; a measuring point correction record report is generated for subsequent drawing generation.

[0081] Step 1053: Combine the corrected planar coordinates and the corrected vertical coordinates to generate the corrected trajectory coordinates.

[0082] The corrected planar coordinates refer to the two-dimensional position data after projection correction, including X and Y coordinates. The corrected vertical coordinates refer to the burial depth value after linear interpolation correction. The corrected trajectory coordinates refer to the complete three-dimensional spatial position data combining the planar and vertical correction results. Specific example: The corrected planar coordinates of a measuring point are X=553421.000 / Y=3452678.000, the corrected vertical coordinate is 1.3 meters, and the combined trajectory coordinates are X=553421.000 / Y=3452678.000 / H=35.624 / D=1.3.

[0083] Specifically, firstly, a unified coordinate data structure is established, including fields for measuring point number, plane coordinates, vertical coordinates, and mileage; the corrected plane coordinate data is read, and the X and Y coordinate values ​​are extracted; the corrected vertical coordinate data is read, and the burial depth value is extracted; the absolute elevation of the measuring point is calculated by subtracting the corrected burial depth value from the surface elevation; the plane and vertical coordinates are combined according to the measuring point number order; a complete trajectory coordinate record is generated, with the data format as: point number, X coordinate, Y coordinate, elevation, burial depth, and mileage; the combined coordinate data is stored in the database, establishing a relationship with the original measuring points; and a data integrity check ensures that all measuring points have completed coordinate combination.

[0084] Step 1054: Extract the corresponding cable well location information based on the coded identifier, and generate a planar cable path map by combining it with the corrected trajectory coordinates.

[0085] The cable identification code is a unique identifier for the cable channel. Cable manhole location information refers to the spatial positioning data of the cable manhole, including the coordinates of the manhole opening, the elevation of the manhole bottom, and the elevation of the manhole cover. The planar cable route map refers to the engineering drawing showing the planar direction of the cable, including layers such as the base map, manhole locations, pipelines, and annotations. Specific example: For cable manhole HF-NE-C2, the coordinates of manhole 1 are 553400.000 / 3452670.000, and the coordinates of manhole 2 are 553450.000 / 3452680.000. The generated route map has a scale of 1:500.

[0086] Specifically, first, the cable well data table is queried based on the coded identifier to extract the location information of the starting and ending wells; the corrected trajectory coordinate data is read and arranged in mileage order; drawing parameters are set, including the drawing size A1, the drawing scale 1:500, the coordinate system, and layer settings; graphic elements are drawn in the following order: topographic features are drawn on the base map layer, cable well symbols are drawn on the well location layer, cable routing lines are drawn on the pipeline layer, cross-section location lines are drawn on the dimension layer, and codes and annotations are added to the annotation layer; graphic expression requirements: cable wells use national standard symbols, pipelines use solid lines, cross-section location lines use dashed lines, and text uses standard drawing fonts; map frame finishing elements are added, including the drawing name, drawing number, scale, and legend; the drawing file is output in DWG format.

[0087] Step 1055: Using the cable wells in the planar cable path diagram as nodes, divide the sections according to the preset intervals to generate a channel profile diagram.

[0088] Cross-section division refers to setting cross-sectional positions at fixed intervals along the cable route. The preset interval refers to the standard distance between cross-sections, typically set to 20 meters. A channel cross-section drawing is an engineering drawing showing the cross-sectional structure of the channel, including structural dimensions, pipe block locations, and cable laying details. Specific example: A cable segment is 100 meters long, divided into 20-meter sections, generating a total of 5 standard cross-section drawings.

[0089] Specifically, firstly, the path length between cable wells is calculated using a segmented accumulation method; the cross-section positions are determined according to a standard interval of 20 meters, with the starting point set at the first cable well; at each cross-section position, the channel structure parameters are read, including cross-section dimensions, pipe block layout, and soil cover depth; the corrected trajectory coordinates at the cross-section position are extracted, including planar position and burial depth data; the profile parameters are set: horizontal scale 1:100, vertical scale 1:50, and map size A3; the profile elements are drawn: the structure layer draws the channel outline, the pipe block layer draws the pipe block layout, the cable layer draws the laying position, and the dimension layer draws the annotation lines; the graphic representation requirements are: the channel structure uses cross-section filling, the pipe blocks use circular symbols, and the cables use solid circles; cross-section annotations are added: cross-section number, mileage station number, ground elevation, pipe block elevation, and cable burial depth; a cross-section table is generated, recording the key parameters of each cross-section; the cross-section file is output in DWG format.

[0090] In the above embodiments, basic cable duct mapping functions were achieved through data acquisition and spatial analysis. To further improve the standardization of the results data and reduce the impact of data format heterogeneity on the application of the results, this application also provides a cable duct data conversion method. This method constructs a unified data conversion framework by analyzing the attribute characteristics, data structure, and encoding rules of graphic elements, and performs adaptive format conversion, enabling the system to more efficiently handle the needs of results integration in complex engineering environments. The following section combines... Figure 2 Another cable channel data acquisition method in the embodiments of this application is described below: Please see Figure 2 This is a flowchart illustrating a cable channel data acquisition method in an embodiment of this application.

[0091] Step 201: Extract the trajectory lines, cable wells, and annotation information from the cable route map and convert them into vector layer data; generate a cross-section attribute table based on the channel profile diagram. The cross-section attribute table includes the cross-section number, cable well code, burial depth data, and pipe block specifications.

[0092] A cable track line refers to a linear element in a cable path diagram that represents the direction of a cable. A cable well refers to a well-like facility in a cable tunnel used for splicing and cable pulling. Labeling information refers to text, symbols, dimensions, and other annotation elements in the drawing. Vector layer data refers to spatial data expressed using geometric elements such as coordinate points, lines, and surfaces. A cross-sectional attribute table refers to a data table describing the cross-sectional characteristics of the tunnel. A cross-sectional number refers to a unique identifier for the cross-sectional view. Pipe block specifications refer to the model and size parameters of the pipe block. Specific example: A cable segment contains a broken line track, two cable wells, and multiple annotation texts. After conversion, a line layer, a point layer, and an annotation layer are generated; the cross-sectional attribute table records the cross-sectional number D001, cable well code HF-001, burial depth 1.5 meters, and pipe block specification DN200.

[0093] Specifically, the process involves reading DWG format cable route diagrams and cross-sectional views, establishing a data access interface, reading the vertex coordinate sequence of trajectory line elements through the ObjectDBX interface, converting it into line layer data with attribute fields including line number, start coordinates, end coordinates, and length, reading the insertion point coordinates of well chamber symbols, converting them into point layer data with attribute fields including well number, X coordinate, Y coordinate, and well depth, extracting text annotations and dimension annotations, converting them into annotation layer data with attribute fields including annotation content, text height, angle, and position, and establishing an attribute table structure with fields including cross-section number (primary key, text type, 20 digits), cable well code (text type, 20 digits), mileage marker (numeric type, precision 0.001), and ground elevation (numeric type, ...). The system includes the following data sets: pipe block depth (numeric, 0.001 precision), burial depth data (numeric, 0.001 precision), pipe block specifications (text, 10 digits), pipe block material (text, 10 digits), and remarks (text, 200 digits). Attribute records are entered in the order of the cross-sections. Cross-section numbers use the format "D + 4-digit serial number". Cable well codes are extracted from the route map. Mileage station numbers are accumulated from the starting point. Ground elevation is obtained from measurement data. Pipe block depth is read from the profile view and calculated from the burial depth data. Pipe block specifications are extracted from the design drawings. The system establishes the association between the cross-section attribute table and the layer data. Topology checks and data validation are performed to ensure the integrity of graphic elements and the accuracy of attribute records. The conversion results are submitted through database transactions.

[0094] Step 202: Classify the vector layer data according to the preset layer naming rules to generate graphic data files; convert the cross-section attribute table into database format and establish a relationship with the graphic data files.

[0095] Vector layer data refers to spatial data structures expressed using geometric elements such as points, lines, and polygons. Layer naming rules refer to standardized layer naming encoding systems, such as "CABLE_LINE" representing a cable line layer. Graphic data files refer to standard format files that store spatial data, such as GDB format files. Database formats refer to the tabular storage format of relational databases, such as MDB format. Association relationships refer to the correspondence and connections between graphic elements and attribute records.

[0096] Specifically, the first step is to perform layer classification. This involves reading the vector layer data and classifying it according to feature type. Cable lines are classified under the "CABLE_LINE" layer, with attributes including line number, start coordinates, end coordinates, line type, and color. Cable wells are classified under the "CABLE_WELL" layer, with attributes including well number, coordinates, elevation, type, and specifications. Equipment is classified under the "CABLE_EQUIP" layer, with attributes including equipment number, name, model, and installation location. Labels are classified under the "ANNO_TEXT" layer, with attributes including text content, text height, angle, and position. Finally, a graphic data file is created using ESRI. The code uses GDB format, sets the coordinate system to CGCS2000, and stores layers in binary format. It writes the categorized layer data into a GDB file, creates a spatial index for each layer, and sets the layer display scale range. It then performs a section attribute table conversion, creates an Access database file, establishes a section information table with field types consistent with the original table, and imports attribute records into the database table using SQL statements. In the GDB file, it adds a correlation field to the graphic features, storing the primary key value of the section attribute table. In the Access database, it adds a spatial index field to the section information table, storing the unique identifier of the graphic features. It establishes a bidirectional association relationship to enable linked queries between graphics and attributes. A data integrity check is performed to ensure all graphic features have corresponding attribute records. A correlation metadata file is generated, recording the layer structure and correlation definitions. Finally, it outputs the final GDB format graphic file and MDB format database file.

[0097] Step 203: Based on the preset data exchange standard, package the graphic data file and the cross-sectional attribute table in database format to generate a result file in the preset format.

[0098] Data exchange standards refer to standardized data file organization methods and format rules, including regulations on file naming, directory structure, and data format. Graphical data files refer to GDB format files that store spatial geometric elements. Database formats refer to MDB format files that store attribute data. Pre-defined format output files refer to final output file packages that conform to industry standards, such as ZIP format compressed packages.

[0099] Specifically, the process begins by reading the data exchange standard document to obtain file organization rules; creating a standard directory structure, including: setting up a Vector folder in the root directory to store GDB format graphic files, a Database folder to store MDB format database files, a Metadata folder to store XML format metadata files, and a Document folder to store PDF format documentation; generating file names using the "project code-date" format, where the project code includes the region code, professional code, type code, and sequence number; checking the integrity of the graphic data files to confirm the inclusion of all layer data: cable line layer, cable well layer, equipment layer, and annotation layer; and verifying the database file structure to confirm the completeness of the cross-section attribute table fields: cross-section code... The process involves: collecting data such as cable well number, mileage marker, ground elevation, pipe block depth, burial depth data, and pipe block specifications; generating metadata files to record basic data information: data generation time, coordinate system, accuracy level, data format, layer structure, attribute definitions, and relationships; creating a documentation file containing data acquisition methods, processing procedures, quality descriptions, and usage instructions; copying all files to a temporary folder according to the directory structure; packaging the temporary folder using a ZIP compression algorithm with optimal compression level; outputting a ZIP format result file with standard naming conventions; generating a file checksum and calculating the file's feature value using the MD5 algorithm; recording the result file size, compression ratio, checksum, and other information; deleting the temporary folder; and completing the result file generation.

[0100] In one possible implementation, a result file in a preset format is generated. Following this step, steps 2031-2034 are further included, as follows: Step 2031: Receive the as-built data of the cable channel, extract the change type and change location information from the as-built data, and query the corresponding code identifier in the deliverables based on the change location information.

[0101] As-built documentation refers to the actual construction records after the completion of the cable duct project, including documents such as construction process, quality inspection, and acceptance records. Change type refers to the classification of modifications to the design scheme during construction, such as route changes, cross-sectional changes, and material changes. Change location information refers to the specific spatial location where the design change occurred, including start and end station numbers and spatial coordinates. The coding identifier refers to the unique identification code of the cable duct.

[0102] Specifically, firstly, as-built documentation data is read via a file interface. Document formats include PDF documents, CAD drawings, and Excel spreadsheets. Then, an as-built change information table is created, with fields including: Change Number (primary key, text, 20 digits), Change Type (text, 10 digits), Starting Chainage (numeric, precision 0.001), Ending Chainage (numeric, precision 0.001), Starting Coordinate X (numeric, precision 0.001), Starting Coordinate Y (numeric, precision 0.001), Ending Coordinate X (numeric, precision 0.001), Ending Coordinate Y (numeric, precision 0.001), Change Description (text, 200 digits), and Approval Status (text, 2 digits). Change records are then extracted from the as-built documentation and processed according to the change... Type Classification: For route changes, extract the coordinates of the old and new routes; for cross-section changes, extract the cross-section location and dimensions; for material changes, extract the change range and specifications. Fill the change information into the information table, using the "C + 6-digit serial number" format for the change number, selecting the preset type code for the change type, and extracting the station number and coordinates from the as-built survey data. Read the graphic data from the results file, and query intersecting cable channel elements based on the spatial range of the change location. Extract the code identifiers of the intersecting elements and establish a correspondence between change records and channel codes. Add a channel code field to the change information table, recording the queried code identifiers. Verify the accuracy of the correspondence between the change location and the channel code through spatial location verification. Write the query results into the database, establishing an association index between change information and channel data.

[0103] Step 2032: When the change type is cut-off, relocation or reconstruction, obtain the trajectory coordinates and burial depth data of the changed cable segment, and update the trajectory coordinates of the corresponding coded identifier in the result file according to the changed cable segment trajectory coordinates and burial depth data.

[0104] Cut-out refers to the construction operation of cutting and reconnecting an existing cable line. Relocation refers to the construction operation of completely rerouting an existing cable line. Reconstruction refers to the construction operation of rebuilding an existing cable channel. The trajectory coordinates of the changed cable segment refer to the spatial location data of the new line after construction is completed. Burial depth data refers to the measured value of the cable laying depth. Trajectory coordinates refer to the three-dimensional coordinate sequence describing the spatial location of the cable.

[0105] Specifically, the process involves reading construction change records to obtain change type codes: cutover code "CJ", migration code "QY", and reconstruction code "GB"; extracting change scope data, including start and end station numbers, plane coordinates, and cross-sectional locations; reading as-built survey data to obtain trajectory point data for the newly constructed cable section, with each measurement point containing: point number, X coordinate, Y coordinate, elevation, burial depth, and acquisition time; preprocessing the measurement point data, including coordinate system conversion, noise filtering, and data smoothing; establishing a trajectory line fitting model using cubic spline interpolation, selecting the original measurement points as control points, and generating a continuous and smooth trajectory line equation; and calculating the coordinates of densified points at 1-meter intervals based on the trajectory line equation to form a uniformly distributed trajectory point network. The process involves: reading the graphic data corresponding to the coded identifier in the output file and locating the range of line segments to be updated; deleting the coordinates of the trajectory points of the original line segments; inserting the new trajectory point sequence into the graphic data file and updating the geometric information of the line features; synchronously updating the burial depth data in the cross-section attribute table, including: cross-section number, station location, and burial depth value; recalculating basic attributes such as line segment length and start / end coordinates; updating the metadata information of the graphic data file, recording the update time, update type, and data source; performing an integrity check on the updated data to verify the continuity of the trajectory lines and the rationality of the burial depth data; generating a data update log, recording the update range, data volume, and feature values; and submitting the database transaction to complete the trajectory coordinate update operation.

[0106] Step 2033: Recalculate the spatial position deviation of the updated trajectory coordinates and correct it, and update the graphic data file and cross-section attribute table in the result file.

[0107] Updated trajectory coordinates refer to the new cable location data after the change in construction. Spatial position deviation refers to the spatial difference between the measured position and the design position, including planar offset and vertical deviation. Correction processing refers to the data processing procedure of adjusting out-of-tolerance positions to within the allowable range. Graphical data file refers to a GDB format file storing spatial geometric elements. Cross-section attribute table refers to a data table recording cross-sectional characteristic parameters.

[0108] Specifically, firstly, the updated trajectory coordinate data is read to obtain the three-dimensional coordinate values ​​of each measuring point; secondly, the channel design data is read to extract the pipe block layout position and cross-sectional dimension parameters; thirdly, the planar offset is calculated, including: extracting the channel centerline equation, calculating the horizontal and vertical distances from the measuring point to the centerline using the point-to-line distance formula d=|ax0+by0+c| / M; fourthly, the vertical deviation is calculated, including: extracting the pipe block design burial depth, calculating the difference between the measured burial depth and the design burial depth of the measuring point; fifthly, determining whether the deviation exceeds the limit, with the planar limit taken as 1 / 4 of the channel width and the vertical limit taken as 1 / 3 of the channel height; sixthly, correction calculations are performed for measuring points exceeding the limit, with the planar correction using the projection method to move the measuring point within the limit range, and the vertical correction... The following steps are employed: linear interpolation is used to adjust the burial depth value; the graphic data file is updated, including: deleting the original trajectory line features, creating new trajectory line features, updating line feature attributes, and rebuilding the spatial index; the cross-section attribute table is updated, including: modifying the burial depth data, updating the cross-section number, adjusting the mileage value, and recording the correction information; the corrected feature parameters are calculated, including: line segment length, start and end coordinates, and average burial depth; a data quality report is generated, recording the number of correction points, deviation statistics, and correction magnitude; metadata information is updated, including: correction time, correction method, and correction result; a data consistency check is performed to verify the correspondence between the graphic data and the attribute data; and the correction results are written to the deliverables file to complete the data update operation.

[0109] Step 2034: Generate the version number and update timestamp of the updated result file, and associate the version number, update timestamp, and updated result file into the database.

[0110] The version number refers to the iteration identifier of the output file, using a combination of major and minor version numbers, such as V2.1. The update timestamp refers to the precise time record of the file update, accurate to the second, such as 20260113143022. The output file refers to a complete data package containing graphical and attribute data. Association storage refers to establishing a correspondence between version information and file data in the database.

[0111] Specifically, first, a version number generation rule is established: the major version number represents a major update, and the minor version number represents a minor update, in the format "V" + major version number + "." + minor version number; historical version records are read from the database to obtain the latest version number; the update type is determined: major changes such as route changes and section changes increment the major version number, while minor changes such as local fixes increment the minor version number; a new version number is generated, such as updating from the original version V2.0 to V2.1; the system time is obtained and formatted as a 14-digit timestamp in the format "year month day hour minute second"; a version information table is created, with fields including: version number (primary key, text, 10 digits), timestamp (text, 14 digits), file name (text, 100 digits), file size (numeric, precision 0.001), update type (text, 10 digits), update description (text, 200 digits), operator (…). The system handles the following: 1) MD5 checksum (text, 20 bits); 2) MD5 checksum calculation of the output file to ensure file integrity; 3) Copying the output file to a specified directory on the file server, with the directory structure organized by "year / month / date"; 4) Inserting version information records into the database, establishing the association between version information and file paths; 5) Creating a file index to record the mapping between version numbers and file storage paths; 6) Establishing version increment rules to restrict version numbers to increment only, not regress; 7) Generating a version update log to record the version change process and important parameters; 8) Performing data backup operations, backing up important version data off-site; 9) Updating metadata information to record version history and file status; 10) Completing version control and storage operations.

[0112] The following describes a cable channel data acquisition system according to an embodiment of the present invention from the perspective of hardware processing. Please refer to [link / reference needed]. Figure 3 This is a schematic diagram of the structure of a cable channel data acquisition system in an embodiment of this application.

[0113] It should be noted that, Figure 3 The structure of the cable channel data acquisition system shown is merely an example and should not impose any limitations on the functionality and scope of use of the embodiments of the present invention.

[0114] like Figure 3As shown, a cable channel data acquisition system includes a Central Processing Unit (CPU) 301, which can perform various appropriate actions and processes according to a program stored in a Read-Only Memory (ROM) 302 or a program loaded from a storage section 308 into a Random Access Memory (RAM) 303, such as executing the methods described in the above embodiments. The RAM 303 also stores various programs and data required for system operation. The CPU 301, ROM 302, and RAM 303 are interconnected via a bus 304. An Input / Output (I / O) interface 305 is also connected to the bus 304.

[0115] The following components are connected to I / O interface 305: input section 306 including audio input devices, push-button switches, etc.; output section 307 including a liquid crystal display (LCD) and audio output devices, indicator lights, etc.; storage section 308 including a hard disk, etc.; and communication section 309 including a network interface card such as a LAN (Local Area Network) card, modem, etc. Communication section 309 performs communication processing via a network such as the Internet. Drive 310 is also connected to I / O interface 305 as needed. Removable media 311, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., are installed on drive 310 as needed so that computer programs read from them can be installed into storage section 308 as needed.

[0116] In particular, according to embodiments of the present invention, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of the present invention include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing computer programs for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication section 309, and / or installed from removable medium 311. When the computer program is executed by central processing unit (CPU) 301, it performs the various functions defined in the present invention.

[0117] It should be noted that specific examples of computer-readable storage media may include, but are not limited to: electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM), flash memory, optical fiber, portable compact disc read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0118] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present invention. Each block in a flowchart or block diagram may represent a module, segment, or portion of code, which contains one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those shown in the drawings.

[0119] Specifically, a cable channel data acquisition system according to this embodiment includes a processor and a memory. The memory stores a computer program, and when the computer program is executed by the processor, it implements a cable channel data acquisition method provided in the above embodiment.

[0120] In another aspect, the present invention also provides a computer-readable storage medium, which may be included in a cable channel data acquisition system described in the above embodiments; or it may exist independently and not assembled into the cable channel data acquisition system. The storage medium carries one or more computer programs, which, when executed by a processor of the cable channel data acquisition system, cause the cable channel data acquisition system to implement the cable channel data acquisition method based on IoT-based encrypted data transmission provided in the above embodiments.

Claims

1. A method for acquiring data from a cable channel, characterized in that, The method includes: Acquire sampling data of the cable channel, the sampling data including cable well location information, channel type and cable segment attributes; A coded identifier is generated based on the cable well location information, channel type, and cable segment attributes. Based on the cable segment corresponding to the coded identifier, the trajectory coordinates and burial depth data of the cable segment are collected using electromagnetic induction detection. The spatial position deviation of the cable in the channel type is calculated based on the trajectory coordinates and burial depth data. When the spatial position deviation exceeds the deviation threshold corresponding to the channel type, a deviation mark is generated. The trajectory coordinates with the deviation markers are corrected, and a cable path diagram and a channel profile diagram are generated based on the coded identifier and the corrected trajectory coordinates. The cable path diagram and the channel profile diagram are then converted into output files in a preset format.

2. The cable channel data acquisition method according to claim 1, characterized in that, The step of generating a coded identifier based on the cable well location information, channel type, and cable segment attributes includes: Extract the road name and road direction from the cable well location information, and generate road information codes based on the road direction to determine the numbering direction; A directional code is generated based on the spatial relationship between the cable well location information and the road name; The number of the same channel type on the same side of the same road is counted, and a corridor sequence code is generated when the number exceeds a preset threshold. Based on the cable segment attributes, determine whether there is a new cable well between two adjacent cable wells. If there is a new cable well, add a supplementary sequence code after the road information code and orientation code of the previous cable well. The road information code, the orientation code, the corridor sequence code, and the supplementary sequence code are combined to generate the coded identifier.

3. The cable channel data acquisition method according to claim 1, characterized in that, The process of collecting the trajectory coordinates and burial depth data of the cable segment corresponding to the coded identifier using electromagnetic induction detection includes: Extract the number of pipelines and their burial depth from the cable segment; When the number of pipelines is a single pipeline and the burial depth is less than the first depth threshold, electromagnetic induction detection is performed using preset first detection parameters. When the number of pipelines is multiple parallel pipelines or the burial depth is greater than or equal to the first depth threshold, electromagnetic induction detection is performed using preset second detection parameters. Differential positioning is performed on the trajectory points obtained by electromagnetic induction detection to obtain the plane coordinates, elevation coordinates and burial depth data of each trajectory point; The plane coordinates, elevation coordinates, and burial depth data are associated and stored with the coded identifier to generate the trajectory coordinates.

4. The cable channel data acquisition method according to claim 1, characterized in that, The calculation of the spatial position deviation of the cable in the channel type based on the trajectory coordinates and burial depth data includes: Extract the channel centerline position, channel cross-sectional dimensions, and pipe block arrangement position from the channel type; Extract the sequence of trajectory points between two adjacent cable wells from the trajectory coordinates, and calculate the planar offset of the trajectory point sequence relative to the centerline of the channel; Based on the burial depth data, the channel cross-sectional dimensions, and the pipe block arrangement position, calculate the vertical deviation between the trajectory point sequence and the pipe block arrangement position; The plane offset is compared with a preset plane limit to obtain the plane deviation, and the vertical deviation is compared with a preset vertical limit to obtain the vertical deviation. The spatial position deviation is obtained by weighting the planar deviation and the vertical deviation.

5. The cable channel data acquisition method according to claim 1, characterized in that, The step of correcting the trajectory coordinates with the deviation marker, and generating a cable path diagram and a channel profile diagram based on the encoded identifier and the corrected trajectory coordinates, includes: Obtain the trajectory point sequence with the deviation marker, and extract the pipe block layout position and channel cross-sectional parameters corresponding to the trajectory point sequence; A theoretical trajectory line is generated based on the arrangement position of the pipe block, and the trajectory point sequence is projected onto the theoretical trajectory line to obtain the corrected planar coordinates. Based on the channel cross-section parameters, the burial depth data is linearly interpolated to obtain the corrected vertical coordinates; The corrected planar coordinates and the corrected vertical coordinates are combined to generate the corrected trajectory coordinates; Extract the corresponding cable well location information based on the encoded identifier, and generate a planar cable path map by combining it with the corrected trajectory coordinates; Using the cable wells in the planar cable path diagram as nodes, the cross-section is divided according to a preset interval to generate the channel profile diagram.

6. The method according to claim 1, characterized in that, The process of converting the cable route diagram and the channel cross-sectional diagram into output files of a preset format includes: Extract the trajectory lines, cable wells, and annotation information from the cable path diagram and convert them into vector layer data; A cross-sectional attribute table is generated based on the channel profile diagram. The cross-sectional attribute table includes the cross-sectional number, cable well code, burial depth data, and pipe block specifications. The vector layer data is categorized according to a preset layer naming rule to generate graphic data files; Convert the cross-sectional attribute table into a database format and establish a relationship with the graphic data file; According to the preset data exchange standard, the graphic data file and the cross-sectional attribute table in the database format are packaged to generate the result file in the preset format.

7. The method according to claim 6, characterized in that, After generating the result file in the preset format, the method further includes: Receive the as-built data of the cable channel, and extract the change type and change location information from the as-built data; Based on the changed location information, the corresponding code identifier is queried in the result file; When the change type is splicing, relocation or reconstruction, the trajectory coordinates and burial depth data of the changed cable segment are obtained, and the trajectory coordinates of the corresponding coded identifier in the result file are updated according to the changed cable segment trajectory coordinates and burial depth data. The spatial position deviation of the updated trajectory coordinates is recalculated and corrected, and the graphic data file and cross-sectional attribute table in the result file are updated. Generate the version number and update timestamp of the updated result file, and associate and store the version number, the update timestamp, and the updated result file in the database.

8. A cable channel data acquisition system, characterized in that, The cable channel data acquisition system includes: one or more processors and a memory; the memory is coupled to the one or more processors, the memory is used to store computer program code, the computer program code including computer instructions, and the one or more processors call the computer instructions to cause the cable channel data acquisition system to perform the method as described in any one of claims 1-7.

9. A computer-readable storage medium comprising instructions, characterized in that, When the instruction is executed on the cable channel data acquisition system, the cable channel data acquisition system performs the method as described in any one of claims 1-7.

10. A computer program product, characterized in that, When the computer program product is run on the cable channel data acquisition system, the cable channel data acquisition system performs the method as described in any one of claims 1-7.

Images