CN112560229B - Rapid data processing method for shallow stratum profiler - Google Patents
Rapid data processing method for shallow stratum profiler Download PDFInfo
- Publication number
- CN112560229B CN112560229B CN202011372521.1A CN202011372521A CN112560229B CN 112560229 B CN112560229 B CN 112560229B CN 202011372521 A CN202011372521 A CN 202011372521A CN 112560229 B CN112560229 B CN 112560229B
- Authority
- CN
- China
- Prior art keywords
- data
- longitude
- latitude
- coord
- elevation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/20—Design optimisation, verification or simulation
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Geometry (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Geophysics And Detection Of Objects (AREA)
Abstract
The invention relates to the technical field of marine mapping data processing, and discloses a rapid data processing method of a shallow stratum profiler, which comprises the following steps: s1: the Excel transferring module at least extracts the longitude and latitude, the pipe top elevation and the seabed elevation of the pipeline detected by the shallow stratum profiler, and calculates the burial depth data by combining the set tidal sound velocity value, the pipe top elevation and the seabed elevation; s2: the COORD conversion module automatically converts the longitude and latitude data and the corresponding buried depth data into COORD data; s3: converting COORD data into coordinate data; s4: the CAD conversion module converts the coordinate data into a display point sentence conforming to the CAD command language; s5: generating a pipeline searching display diagram by CAD according to the display point statement; the invention simplifies the data screening step by using a fixed data conversion mode, realizes accurate and rapid data screening, provides convenience for the field staff to rapidly acquire the required data, and avoids the problem of data error and leakage in the data screening process.
Description
Technical Field
The invention relates to the technical field of marine mapping data processing, in particular to a rapid data processing method of a shallow stratum profiler.
Background
The shallow stratum profiler is an instrument for detecting the profile structure of a shallow stratum by utilizing sound waves, and is one of important means for current offshore geophysical investigation. The technology is widely used for detecting the exposed, suspended and buried states of the sea pipe, and the results of the technology are precisely judged, fused and processed for many times by the inner workers, so that comprehensive and clear pipeline effect diagrams and data result reports can be generated. The generation of the two achievements plays an important role in timely finding hidden danger sea pipes by owners and designing corresponding solutions aiming at the hidden danger sea pipes.
At present, the processing of the spread point data of the shallow stratum profiler is mostly carried out in a manual operation mode, and the method specifically comprises the following 5 steps: 1. based on a shallow stratum profiler original data file, acquiring data such as pipeline X coordinates, Y coordinates, pipe top elevation, seabed elevation, original data and the like, sequentially calculating burial depth conditions of each point of a pipeline according to tidal sound velocity values, and generating an Excel file; 2. screening the content of the newly generated Excel file, selecting two items of data of pipeline coordinates and burial depth, storing the two items of data into the newly created file Excel, and pasting the required data into the newly created text file; 3. converting geographic coordinates in the generated file into plane coordinates through third party software COORD, and generating a hfx file; 4. pasting the generated file content of hfx to a newly built Excel file, and adding CAD command sentences one by one; 5. and copying and pasting the command statement to a CAD command line, and generating a pipeline searching display diagram. The operation mode requires internal operators to switch txt and Excel files for multiple times, calculates and acquires required data by using a manual mode, has complex procedures and extremely high error rate, and is difficult to quickly generate a pipeline searching display diagram for data detected by a shallow stratum profiler.
Disclosure of Invention
Aiming at the defects existing in the prior art, the invention aims to provide a rapid data processing method of a shallow stratum profiler.
In order to achieve the above object, the present invention provides the following technical solutions:
a rapid data processing method of a shallow stratum profiler comprises the following steps:
s1: the Excel transferring module at least extracts the longitude and latitude, the pipe top elevation and the seabed elevation of the pipeline detected by the shallow stratum profiler, and calculates the burial depth data by combining the set tidal sound velocity value, the pipe top elevation and the seabed elevation;
s2: the COORD conversion module automatically converts the longitude and latitude data and the corresponding buried depth data into COORD data;
s3: converting COORD data into coordinate data;
s4: the CAD conversion module converts the coordinate data into a display point sentence conforming to the CAD command language;
s5: and the CAD generates a pipeline searching display diagram according to the display point statement.
In the present invention, preferably, in step S1, the conversion Excel module includes the steps of:
s101: extracting data of the shallow stratum profiler including longitude and latitude, elevation of the pipe top and elevation of the seabed, splitting the data by using blank spaces and respectively storing the split data;
s102: subtracting the last two data, adding the set tidal sound velocity value, and calculating to obtain buried depth data;
s103: and storing the buried data into an xls file after the buried data are put into the split data.
In the present invention, it is preferable that in step S103, xls file is created with the serial number, latitude and longitude, pipe top elevation, seabed elevation, and burial depth as the header.
In the present invention, preferably, in step S2, the COORD conversion module includes the following steps:
s201: dividing the data generated in step S103 by row unit according to the space between each data;
s202: extracting the first two bits of data to obtain a serial number and longitude and latitude corresponding to the serial number;
s203: and splitting and calculating the longitude and latitude data, and storing the longitude and latitude data as COORD data.
In the present invention, preferably, in step S203, the integer part of the longitude and latitude is divided into one group of units and ten bits, and the rest of the integer part is divided into one group, and the divided data are divided by ": the numbers are connected.
In the present invention, it is preferable that the fractional parts of longitude and latitude are extracted, multiplied by 60 in pure fractional form, and kept in three-bit fractional form, and passed through ": "concatenates after the integer re-concatenates the arrays.
In the present invention, it is preferred that the COORD data is stored in a format of hfx.
In the present invention, preferably, in step S3, the COORD data generated in step S2 is opened by using COORD software, and its geographic coordinates are converted into planar coordinates.
In the present invention, preferably, in step S4, the step of transferring to CAD includes the steps of:
s401: extracting plane coordinate data, dividing the plane coordinate data according to the steps, and respectively giving X, Y, Z the divided data;
s402: x, Y, Z is brought into the formula to form a punctuation statement that conforms to the CAD command language.
In the present invention, preferably, the formula is po { X }, { Y }
-text{X}，{Y}10{Z}。
Compared with the prior art, the invention has the beneficial effects that:
1. the invention can quickly convert the file format, reduce the frequency of repeated conversion of xls and txt format files, reduce the problems of data missing, error and the like possibly generated in the data transfer process, and improve the efficiency and accuracy of data conversion and data result generation;
2. the invention is based on the field detection data of the shallow layer sectioning instrument, can quickly generate CAD command text, and effectively avoids the problem that staff is required to repeatedly check and check in order to prevent the error of manually adding CAD command language;
3. the method simplifies the operation flow of the post-processing of the profiler data, helps staff to quickly and accurately generate the pipeline search display diagram, improves the hand-up rate of the post-processing of the new staff profiler data, greatly shortens the on-duty training time of staff, and saves the time cost and the economic cost of projects.
Drawings
FIG. 1 is a flow chart of a method for rapidly processing data of a shallow layer profiler according to the present invention.
Fig. 2 is a flowchart showing a method for rapidly processing data of a shallow layer profile according to the present invention.
Fig. 3 is a flowchart showing a method for rapidly processing data of a shallow layer profile according to the present invention in step S4.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
It will be understood that when an element is referred to as being "fixed to" another element, it can be directly on the other element or intervening elements may also be present. When a component is considered to be "connected" to another component, it can be directly connected to the other component or intervening components may also be present. When an element is referred to as being "disposed on" another element, it can be directly on the other element or intervening elements may also be present. The terms "vertical," "horizontal," "left," "right," and the like are used herein for illustrative purposes only.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. The term "and/or" as used herein includes any and all combinations of one or more of the associated listed items.
Referring to fig. 1 to 3, a preferred embodiment of the present invention provides a method for rapidly processing data of a shallow layer profiler, which is mainly used for rapidly sorting and screening data generated by the shallow layer profiler, reducing the problems of data loss, data error and the like in the conversion process, and improving the data conversion rate, and includes the following steps:
s1: the Excel transferring module at least extracts the longitude and latitude, the pipe top elevation and the seabed elevation of the pipeline detected by the shallow stratum profiler, and calculates the burial depth data by combining the set tidal sound velocity value, the pipe top elevation and the seabed elevation;
s2: the COORD conversion module automatically converts the longitude and latitude data and the corresponding buried depth data into COORD data;
s3: converting COORD data into coordinate data;
s4: the CAD conversion module converts the coordinate data into a display point sentence conforming to the CAD command language;
s5: and the CAD generates a pipeline searching display diagram according to the display point statement.
Specifically, an original data file generated by a shallow stratum profiler comprises information data such as longitude and latitude, tube top elevation, seabed elevation and the like of a pipeline, firstly, the longitude and latitude, tube top elevation and seabed elevation of the pipeline detected by the shallow stratum profiler are extracted by an Excel module, and the embedded depth data are calculated and stored by combining the set tidal sound velocity value, tube top elevation and seabed elevation, then the data are input into a COORD module, the COORD module automatically converts the longitude and latitude data and the corresponding embedded depth data into COORD data and stores the COORD data in a format of hfx, the COORD data are then imported into COORD software, coordinate data are automatically generated by the COORD software, then the coordinate data are passed through a CAD module to generate a spread point statement conforming to a CAD command language, the spread point statement is pasted into a command box in the CAD software, and the CAD software is used for generating a pipeline search spread point map; the whole process does not need personnel to copy and paste data in text files and other files for many times, and manually calculate and manually add commands, so that the problem of data error and leakage is avoided, the efficiency and accuracy of data conversion and data result generation are improved, the operation flow of data processing of the profiler is simplified, and the staff is easy to operate and has high hand-up rate.
In this embodiment, in step S1, the conversion Excel module includes the following steps:
s101: extracting data of the shallow stratum profiler including longitude and latitude, elevation of the pipe top and elevation of the seabed, splitting the data by using blank spaces and respectively storing the split data;
s102: subtracting the last two data, adding the set tidal sound velocity value, and calculating to obtain buried depth data;
s103: and storing the buried data into an xls file after the buried data are put into the split data.
Specifically, the Excel conversion module extracts data of longitude and latitude, pipe top elevation and seabed elevation, then separates and stores the data by blank space, then subtracts the last two data, namely the pipe top elevation and the seabed elevation, and then adds a tidal sound velocity value, wherein the tidal sound velocity value is known data, so as to obtain buried depth data of a pipeline, stores the buried depth data of the pipeline into corresponding seabed elevation data, and generates an x/xls file with sequence number, longitude and latitude, pipe top elevation, seabed elevation and buried depth as the gauge head.
In this embodiment, in step S2, the COORD conversion module includes the following steps:
s201: dividing the data generated in step S103 by row unit according to the space between each data;
s202: extracting the first two bits of data to obtain a serial number and longitude and latitude corresponding to the serial number;
s203: and splitting and calculating the longitude and latitude data, and storing the longitude and latitude data as COORD data.
In this embodiment, in step S203, the whole number of bits and ten bits of the longitude and latitude are divided into one group, and the rest of the whole number is divided into one group, and the divided data are divided by ": the numbers are connected.
In this embodiment, the decimal part of longitude and latitude is extracted, multiplied by 60 in pure decimal form, and kept in three decimal places, and passed through ": "concatenates after the integer re-concatenates the arrays.
In this embodiment, the COORD data is stored therein in a hfx format.
Specifically, in step S2, firstly, the data with the pipeline burial depth generated in step S1 is extracted to the COORD conversion module, the data is converted in the data processing process of the COORD conversion module, the original data is divided into row units, each row corresponds to a serial number, spaces between each data in the row are divided, longitude and latitude of the first two bits are extracted after division, the corresponding row numbers and longitude and latitude are stored as a group, the space is divided, longitude and latitude data are processed, the decimal part is extracted and converted into corresponding pure decimal, and then multiplied by 60, and three-bit decimal is reserved for storage, wherein the last two bits of the integral part are a group, and the rest bits are a group, and then the original data sequence is used ": "separate connection, processed data is stored in hfx format, converting the data to data format that can be opened by COORD software.
In this embodiment, in step S3, the geographical coordinates of the COORD data are converted into planar coordinates using existing COORD software.
In this embodiment, in step S4, the CAD conversion module includes the steps of:
s401: extracting plane coordinate data, dividing the plane coordinate data according to the steps, and respectively giving X, Y, Z the divided data;
s402: x, Y, Z is brought into the formula to form a punctuation statement that conforms to the CAD command language.
Specifically, the obtained plane coordinate data is divided by taking the reference of the symbol @, the first bit is a line number, the first bit is given to Z, the second bit and the third bit are longitude and latitude, X and Y are respectively given, and X, Y, Z is brought into the formula
po{X}，{Y}
-text{X}，{Y}10{Z}
Generating a display point sentence, pasting the display point sentence into a command box of the existing CAD software, and automatically generating a pipeline search display point diagram.
Working principle:
firstly, converting data generated by a shallow stratum profiler into Excel module to extract longitude and latitude, tube top elevation and seabed elevation of a pipeline detected by the shallow stratum profiler, calculating buried depth data according to tube top elevation, seabed elevation and known tidal sound velocity values, storing the buried depth data, converting the data with the pipeline buried depth by COORD module, dividing the data into row units, corresponding one serial number for each row, dividing spaces among the data in the row, extracting longitude and latitude of the first two bits, storing the corresponding row numbers and longitude and latitude as a group, separating, processing the longitude and latitude data, wherein the decimal part is extracted and converted into corresponding pure decimal, multiplied by 60, storing three decimal places, wherein the last two digits of the integral part are a group, and the rest digits are a group, and storing according to the original data sequence and with ": "separate connection, processed data is stored in format hfx, data in format hfx is opened by COORD software, geographic coordinates are converted into plane coordinates, finally CAD module is transferred to divide the obtained plane coordinate data by taking" as reference ", the first bit is a line number and is assigned to Z, the second bit and the third bit are longitude and latitude, X and Y are respectively assigned, and X, Y, Z is brought into formula:
po{X}，{Y}
-text{X}，{Y}10{Z}
generating a display point statement, wherein the display point statement is a command statement which can be identified by CAD software, pasting the display point statement to a command frame of CAD, and automatically generating a pipeline search display point diagram.
The foregoing description is directed to the preferred embodiments of the present invention, but the embodiments are not intended to limit the scope of the invention, and all equivalent changes or modifications made under the technical spirit of the present invention should be construed to fall within the scope of the present invention.
Claims (6)
1. A rapid data processing method of a shallow stratum profiler is characterized by comprising the following steps:
s1: the Excel transferring module at least extracts the longitude and latitude, the pipe top elevation and the seabed elevation of the pipeline detected by the shallow stratum profiler, and calculates the burial depth data by combining the set tidal sound velocity value, the pipe top elevation and the seabed elevation;
the conversion Excel module comprises the following steps:
s101: extracting data of the shallow stratum profiler including longitude and latitude, elevation of the pipe top and elevation of the seabed, splitting the data by using blank spaces and respectively storing the split data;
s102: subtracting the last two data, adding the set tidal sound velocity value, and calculating to obtain buried depth data;
s103: storing the buried depth data into an xls file after the buried depth data are put into the split data;
s2: the COORD conversion module automatically converts the longitude and latitude data and the corresponding buried depth data into COORD data;
s201: dividing the data generated in step S103 by row unit according to the space between each data;
s202: extracting the first two bits of data to obtain a serial number and longitude and latitude corresponding to the serial number;
s203: splitting and calculating longitude and latitude data, storing the longitude and latitude data as COORD data, splitting the whole number part of the longitude and latitude data into a group of units and ten units, and splitting the rest of the whole number part into a group, wherein the split data are obtained by using the following steps: the numbers are connected, the decimal parts of the longitude and the latitude are extracted, the decimal parts are multiplied by 60 in a pure decimal form, and three decimal places are reserved and stored, and the decimal parts are obtained by the steps of: "connect after integer re-concatenating arrays;
s3: converting COORD data into coordinate data;
s4: the CAD conversion module converts the coordinate data into a display point sentence conforming to the CAD command language;
s5: and the CAD generates a pipeline searching display diagram according to the display point statement.
2. The method according to claim 1, wherein in step S103, xls file with serial number, latitude and longitude, top elevation, bottom elevation, and depth of burial as the header is generated.
3. The rapid shallow profile data processing method of claim 1, wherein the COORD data is stored in format of hfx.
4. The method according to claim 1, wherein in step S3, COORD data generated in step S2 are opened by using COORD software to convert geographic coordinates into planar coordinates.
5. The method for rapidly processing data of a shallow layer profiler according to claim 1, wherein in step S4, the following steps are included in the transition CAD:
s401: extracting plane coordinate data, dividing the plane coordinate data according to the steps, and respectively giving X, Y, Z the divided data;
s402: x, Y, Z is brought into the formula to form a punctuation statement that conforms to the CAD command language.
6. A method for rapid processing of shallow profiler data as set forth in claim 5, characterized in that the formula is po { X }, { Y }, and
-text{X}，{Y}1 0{Z}。
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011372521.1A CN112560229B (en) | 2020-11-30 | 2020-11-30 | Rapid data processing method for shallow stratum profiler |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011372521.1A CN112560229B (en) | 2020-11-30 | 2020-11-30 | Rapid data processing method for shallow stratum profiler |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112560229A CN112560229A (en) | 2021-03-26 |
| CN112560229B true CN112560229B (en) | 2023-05-05 |
Family
ID=75045286
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011372521.1A Active CN112560229B (en) | 2020-11-30 | 2020-11-30 | Rapid data processing method for shallow stratum profiler |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112560229B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109359351A (en) * | 2018-09-27 | 2019-02-19 | 济南市市政工程设计研究院（集团）有限责任公司 | A kind of pipeline three-dimensional modeling method and pipe design method |
| CN111854704A (en) * | 2020-07-15 | 2020-10-30 | 天津市陆海测绘有限公司 | Marine geophysical comprehensive survey system |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471615A (en) * | 2018-10-22 | 2019-03-15 | 美丽国土（北京）生态环境工程技术研究院有限公司 | Coordinate data extracting method and device |
| CN111457929B (en) * | 2019-12-31 | 2022-01-25 | 南京工大数控科技有限公司 | Logistics vehicle autonomous path planning and navigation method based on geographic information system |
-
2020
- 2020-11-30 CN CN202011372521.1A patent/CN112560229B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109359351A (en) * | 2018-09-27 | 2019-02-19 | 济南市市政工程设计研究院（集团）有限责任公司 | A kind of pipeline three-dimensional modeling method and pipe design method |
| CN111854704A (en) * | 2020-07-15 | 2020-10-30 | 天津市陆海测绘有限公司 | Marine geophysical comprehensive survey system |
Non-Patent Citations (1)
| Title |
|---|
| 海底管线探测数据处理及自动化研究;亢保军;孔改红;孙立东;;港工技术(第04期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112560229A (en) | 2021-03-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101178310B (en) | Method for surveying and designing powerline and inside and outside trade integration using full digitisation photogrammetric technology | |
| JP5185089B2 (en) | Content position estimation device | |
| CN106779417A (en) | The collection of engineering investigation information digitalization, management and integrated application method | |
| CN105808609A (en) | Discrimination method and equipment of point-of-information data redundancy | |
| CN105589936A (en) | Data query method and system | |
| WO2010083217A1 (en) | Method and computer program product for geophysical and geologic data identification, geodetic classification, and organization | |
| CN106875949A (en) | A kind of bearing calibration of speech recognition and device | |
| CN103473409A (en) | FPGA (filed programmable gate array) fault automatic diagnosing method based on knowledge database | |
| Floros et al. | Investigating integration capabilities between IFC and CityGML LOD3 for 3D city modelling | |
| CN104699758B (en) | The commanding document intelligent generating system and method for a kind of graphics and text library association | |
| Floros et al. | Investigating interoperability capabilities between IFC and CityGML LOD 4–retaining semantic information | |
| Teerarojanarat et al. | Using GIS for linguistic study: a case of dialect change in the northeastern region of Thailand | |
| Zhu et al. | An Assessment of Paths for Transforming IFC to Shapefile for Integration of BIM and GIS | |
| CN106339371A (en) | English and Chinese word meaning mapping method and device based on word vectors | |
| Ackerman et al. | Geospatial capabilities of HEC-RAS for model development and mapping | |
| CN112560229B (en) | Rapid data processing method for shallow stratum profiler | |
| CN110688688A (en) | Method for converting surveying and mapping completion diagrams into surveying and mapping delimiting diagrams in batch | |
| Silang et al. | Wind energy projection for the Philippines based on climate change modeling | |
| CN104280764A (en) | Seismic exploration auxiliary data quality control method based on three-dimensional GIS | |
| CN105528341A (en) | Term translation mining system and method with field customization function | |
| CN116069783B (en) | Hydrologic data processing method and device, computer equipment and storage medium | |
| CN116303870A (en) | Gas flow value mapping method and system for gas pipe network data management | |
| Chen et al. | The design and implementation of the geological data acquisition system based on mobile GIS | |
| CN114091135A (en) | Lisp language-based ship body curved surface outer plate weight gravity center calculation program | |
| CN113159440A (en) | Municipal pipeline planning management method and system based on BIM and GIS |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |