Data analysis method, device and equipment for latitude survey files

Abstract

The present invention relates to the technical field of data analysis, and discloses a data analysis method, device and equipment for latitude and longitude survey files. The method includes obtaining an original latitude and longitude survey file, and extracting and storing the file content of the original latitude and longitude survey file; extracting pile number information based on the stored line element original data, and calculating various indicators of the vertical curve based on the stored vertical curve element original data; generating basic data based on the pile number information and various indicators of the vertical curve; calculating the structure based on the basic data to obtain the structure information; writing the structure information into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file. In the present invention, the original latitude and longitude survey file is read, extracted and stored in the warehouse, which can realize the automatic analysis of files of different formats, and store the parsed data in the corresponding database table according to predefined rules, optimize the data analysis process, improve the data processing efficiency and accuracy, and meet the needs of different application scenarios.

Description

Technical Field

[0001] The present invention relates to the field of data analysis technology, and in particular to a method, device and equipment for analyzing data of latitude and longitude survey files. Background Art

[0002] As the scale and complexity of modern engineering construction projects continue to increase, geological survey and engineering design software plays a vital role in project planning and implementation. As a leading solution on the market, Weidi Survey and Design Software has powerful data processing capabilities and rich functional modules. Its data analysis capabilities directly affect the accuracy of engineering design and analysis.

[0003] However, the existing latitude survey and design software still has some shortcomings and limitations in data analysis. For example, the existing latitude survey and design software algorithms are prone to inefficiency and error accumulation when processing complex geological data. In addition, the data analysis process lacks flexibility and scalability, making it difficult to meet the needs of different projects and application scenarios. These problems reduce the overall efficiency of the project planning and implementation process and add additional costs and time. Summary of the invention

[0004] The main purpose of the present invention is to provide a data analysis method, device and equipment for latitude and longitude survey files, aiming to solve at least one of the above-mentioned technical problems.

[0005] To achieve the above object, the present invention provides a data parsing method for latitude and longitude survey files, comprising:

[0006] Obtaining an original latitude and longitude survey file, and extracting and storing the file content of the original latitude and longitude survey file;

[0007] Extract the pile number information based on the original data of the line element stored in the library, and calculate the various indicators of the vertical curve based on the original data of the vertical curve elements stored in the library;

[0008] Generate basic data according to the pile number information and various indicators of the vertical curve;

[0009] Perform structural calculations based on the basic data to obtain structural information;

[0010] The structure information is written into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file.

[0011] In some embodiments, the obtaining of the original latitude and longitude survey file, and extracting and storing the file content of the original latitude and longitude survey file, includes:

[0012] Obtaining an original latitude and longitude survey file, and obtaining a file format according to the file name of the original latitude and longitude survey file;

[0013] The file content of the original latitude and longitude survey file is cut according to rows and columns to obtain a two-dimensional array;

[0014] Cut each line of the two-dimensional array according to the tag character and clean up the blanks to obtain the text content;

[0015] The text content is parsed and stored based on the file format.

[0016] In some embodiments, the parsing and warehousing the text content based on the file format includes:

[0017] When the file format is zdm format, a vertical curve element data set is parsed from the text content;

[0018] Extracting vertical curve element valid data from the vertical curve element data set;

[0019] Construct a collection of attribute objects based on the fields of the profile table;

[0020] The valid data of the vertical curve element is written into a database based on the attribute object set.

[0021] In some embodiments, the parsing and warehousing the text content based on the file format includes:

[0022] When the file format is hdm format, parsing the cross-section measurement data set from the text content;

[0023] Acquire a left data set and a right data set from the cross-sectional measurement data set according to left and right position serial numbers respectively;

[0024] Constructing a storage attribute object set for the left data set and the right data set respectively;

[0025] The left data set and the right data set are written into a database based on the storage attribute object set.

[0026] In some embodiments, the parsing and warehousing the text content based on the file format includes:

[0027] When the file format is a ctr format, the structure data sets are respectively parsed from the text content; wherein the structure data sets include a bridge data set, a culvert data set, a tunnel data set and a hub interchange data set;

[0028] Writing the bridge data set, culvert data set, tunnel data set and hub interchange data set into corresponding tables of the database respectively;

[0029] or,

[0030] When the file format is a dmx format, a longitudinal section ground line data set is parsed from the text content;

[0031] The longitudinal section ground line data set is written into the database.

[0032] In some embodiments, the parsing and warehousing the text content based on the file format includes:

[0033] When the file format is PM format, parsing the line element curve segment data set from the text content;

[0034] Grouping every three line element data in the line element curve segment data set into a group, and merging the line element data in each group into an array;

[0035] Construct a collection of attribute objects according to the line metadata table fields;

[0036] The plurality of arrays are written into a database based on the attribute object set.

[0037] In some embodiments, the parsing and warehousing the text content based on the file format includes:

[0038] When the file format is wid format, parsing the road width data set from the text content;

[0039] Respectively acquiring a left data set and a right data set from the road width data set according to left and right position serial numbers;

[0040] Constructing a storage attribute object set for the left data set and the right data set respectively;

[0041] The left data set and the right data set are written into a database based on the storage attribute object set.

[0042] In some embodiments, the structure information includes line element information, bridge information, tunnel information, hub interchange information, culvert information, bridge pier information, and embankment and cutting information.

[0043] In addition, to achieve the above-mentioned purpose, the present invention also proposes a data parsing device for latitude and longitude survey files, comprising:

[0044] A file extraction module is used to obtain the original latitude and longitude survey file, and extract the file content of the original latitude and longitude survey file and store it in the database;

[0045] The data analysis module is used to extract the pile number information according to the original data of the line element stored in the library, and calculate the various indicators of the vertical curve according to the original data of the vertical curve element stored in the library;

[0046] A data preparation module, used to generate basic data according to the pile number information and various indicators of the vertical curve;

[0047] A structure calculation module, used to perform structure calculation according to the basic data to obtain structure information;

[0048] The information writing module is used to write the structure information into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file.

[0049] In addition, to achieve the above-mentioned purpose, the present invention also proposes an electronic device, which includes: a memory, a processor, and a data parsing program for a latitude survey file stored in the memory and runnable on the processor, wherein the data parsing program for the latitude survey file is configured to implement the data parsing method for the latitude survey file as described above.

[0050] The present invention provides a data parsing method for a latitude survey file, comprising: obtaining an original latitude survey file, and extracting and storing the file content of the original latitude survey file; extracting pile number information based on the stored line element original data, and calculating various vertical curve indicators based on the stored vertical curve element original data; generating basic data based on the pile number information and various vertical curve indicators; performing structural calculations based on the basic data to obtain structural information; and writing the structural information into a corresponding table in a database to complete the data parsing of the latitude survey file. The present invention performs a process of reading, extracting, and storing the original latitude survey file, which can realize automatic parsing of files of different formats, and stores the parsed data in a corresponding database table according to predefined rules, thereby optimizing the data parsing process, improving data processing efficiency and accuracy, and meeting the needs of different application scenarios. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] Figure 1 A schematic diagram of the structure of an electronic device in a hardware operating environment involved in an embodiment of the present invention;

[0052] Figure 2 A schematic diagram of a flow chart of an embodiment of a method for analyzing data of a latitude survey file of the present invention;

[0053] Figure 3 It is a technical flow chart involved in the embodiment of the present invention;

[0054] Figure 4 This is a schematic diagram of parsing data in a zdm format file involved in an embodiment of the present invention;

[0055] Figure 5 This is a schematic diagram of data parsing of an hdm format file involved in an embodiment of the present invention;

[0056] Figure 6 This is a schematic diagram of parsing data in a ctr format file involved in an embodiment of the present invention;

[0057] Figure 7 This is a schematic diagram of data parsing of a PM format file involved in an embodiment of the present invention;

[0058] Figure 8 This is a schematic diagram of parsing data in a wid format file involved in an embodiment of the present invention;

[0059] Fig. 9 This is a schematic diagram of parsing data in a dmx format file involved in an embodiment of the present invention;

[0060] Fig.10 It is a diagram of the vertical curve calculation involved in the embodiment of the present invention;

[0061] Fig.11 A schematic diagram of a convex vertical curve involved in an embodiment of the present invention;

[0062] Fig.12 This is a structural block diagram of an embodiment of a data parsing device for latitude and longitude survey files of the present invention.

[0063] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0064] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0065] It should be noted that all directional indications in the embodiments of the present invention (such as up, down, left, right, front, back, etc.) are only used to explain the relative position relationship, movement status, etc. between the components under a certain specific posture (as shown in the accompanying drawings). If the specific posture changes, the directional indication will also change accordingly.

[0066] In addition, the descriptions of "first", "second", etc. in the present invention are only used for descriptive purposes and cannot be understood as indicating or implying their relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In addition, the technical solutions between the various embodiments can be combined with each other, but it must be based on the ability of ordinary technicians in the field to implement. When the combination of technical solutions is contradictory or cannot be implemented, it should be deemed that such combination of technical solutions does not exist and is not within the scope of protection required by the present invention. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0067] Reference Figure 1 , Figure 1 The figure is a schematic diagram of the structure of an electronic device of the hardware operating environment involved in the embodiment of the present invention.

[0068] like Figure 1 As shown, the electronic device may include: a processor 1001, such as a central processing unit (CPU), a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Among them, the communication bus 1002 is used to realize the connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. The network interface 1004 may optionally include a standard wired interface and a wireless interface (such as a wireless fidelity (Wireless-Fidelity, Wi-Fi) interface). The memory 1005 may be a high-speed random access memory (Random Access Memory, RAM memory) or a stable non-volatile memory (Non-Volatile Memory, NVM), such as a disk memory. The memory 1005 may also be a storage device independent of the aforementioned processor 1001.

[0069] Those skilled in the art will understand that Figure 1 The structure shown in the figure does not constitute a limitation on the electronic device, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.

[0070] like Figure 1 As shown, the memory 1005 as a storage medium may include an operating system, a network communication module, a user interface module, and a data parsing program for latitude and longitude survey files.

[0071] exist Figure 1In the electronic device shown, the network interface 1004 is mainly used for data communication with a network server; the user interface 1003 is mainly used for data interaction with a user; the processor 1001 and the memory 1005 in the electronic device of the present invention can be set in the electronic device, and the electronic device calls the data parsing program of the latitude survey file stored in the memory 1005 through the processor 1001, and executes the data parsing method of the latitude survey file provided in the embodiment of the present invention.

[0072] The present invention provides a data parsing method, device and equipment for latitude and longitude survey files.

[0073] The embodiment of the present invention provides a method for analyzing data of a latitude survey file, referring to Figure 2 , Figure 2 Schematic diagram of a flow chart of an embodiment of a method for analyzing data of a latitude survey file according to the present invention.

[0074] like Figure 2 As shown, the data parsing method of the latitude survey file includes:

[0075] Step S100: obtaining an original latitude and longitude survey file, and extracting and storing the file content of the original latitude and longitude survey file;

[0076] Step S200: extracting pile number information according to the stored original data of line elements, and calculating various indicators of vertical curves according to the stored original data of vertical curve elements;

[0077] Step S300: Generate basic data according to the pile number information and various indicators of the vertical curve;

[0078] Step S400: performing structural calculation according to the basic data to obtain structural information;

[0079] Step S500: Write the structure information into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file.

[0080] It should be noted that the execution subject in this embodiment may be an electronic device, which may be a computer device with data processing functions, or other devices that can achieve the same or similar functions. This embodiment does not limit this. In this embodiment, a computer device is used as an example for explanation.

[0081] It is understandable that this embodiment is explained by taking the data analysis algorithm and process for the Weidi survey and design software as an example. The Weidi survey and design software is widely used in civil engineering, geological survey and other fields. The method described in this embodiment is intended to provide an efficient and accurate data analysis solution, which is convenient for data processing and application in civil engineering, geological survey and other fields, optimizes the data analysis process, improves data processing efficiency and accuracy, meets the needs of different application scenarios, and promotes the smooth progress of engineering projects, providing more efficient and accurate survey and design services.

[0082] In one embodiment, an original latitude and longitude survey file is obtained, and the file content of the original latitude and longitude survey file is extracted and stored in a database, including: obtaining the original latitude and longitude survey file, and obtaining the file format according to the file name of the original latitude and longitude survey file; cutting the file content of the original latitude and longitude survey file according to rows and columns to obtain a two-dimensional array; cutting each row of the two-dimensional array according to tags and clearing blanks to obtain text content; parsing and storing the text content based on the file format.

[0083] For example, Figure 3 As shown, the first step is to read, extract and store the original file.

[0084] Specifically, the file content can be read through the passed file object and file text content string. First, the file format is obtained according to the file name. For example, the sample code is:

[0085] return fileName.split('.').pop().toLowerCase()

[0086] Specifically, the file content is cut into two-dimensional arrays by rows and columns, and each row is further cut according to the tag character (such as "\t" or space), and the blanks are cleaned. Example code:

[0087]

[0088] Specifically, the parsing and storage of files in different formats are described by taking the zdm format, hdm format, ctr format, dmx format, pm format and wid format as examples in this embodiment. Figure 3 As shown, the zdm format file may include vertical curve feature data, the hdm format file may include cross-section measurement data, the ctr format file may include structure data, the dmx format file may include longitudinal section ground line data, the pm format file may include line metadata, and the wid format file may include road width data.

[0089] In one embodiment, the text content is parsed and stored based on the file format, including: when the file format is zdm format, parsing a vertical curve element data set from the text content; extracting vertical curve element valid data from the vertical curve element data set; constructing an attribute object set according to the longitudinal section table fields; and writing the vertical curve element valid data into a database based on the attribute object set.

[0090] Specifically, parse the .zdm format file and parse out the data set (such as Figure 4 As shown in the figure, the valid data starts from the third line and is written into the library. Sample code is as follows:

[0091]

[0092] For example, Figure 3 As shown, when uploading a file in .zdm format, the file content can be extracted through the zdm parsing algorithm, the file in .zdm format can be parsed, the data can be parsed and written into the library.

[0093] In one embodiment, the text content is parsed and stored in a database based on the file format, including: when the file format is an HDM format, parsing a cross-sectional measurement data set from the text content; obtaining a left data set and a right data set from the cross-sectional measurement data set according to left and right position numbers; constructing a storage attribute object set for the left data set and the right data set respectively; and writing the left data set and the right data set into a database based on the storage attribute object set.

[0094] Specifically, parse out the valid data set (such as Figure 5 As shown), start from the second line. According to the position numbers of the left and right, obtain the left and right data sets respectively, construct the database attribute object set, and write it into the library. Sample code, for example:

[0095]

[0096]

[0097] For example, Figure 3 As shown, when uploading a file in .hdm format, the file content can be extracted through the Hdm parsing algorithm, the file in .hdm format can be parsed, the data can be parsed and written into the library.

[0098] In one embodiment, the parsing and warehousing of the text content based on the file format includes: when the file format is the ctr format, parsing the structure data sets from the text content respectively; wherein the structure data sets include a bridge data set, a culvert data set, a tunnel data set and a hub interchange data set; and writing the bridge data set, the culvert data set, the tunnel data set and the hub interchange data set into the corresponding table of the database respectively.

[0099] Specifically, the data of bridges, tunnels, hub interchanges, culverts, etc. (such as Figure 6 As shown), and write the parsed data sets into different database tables. Example code:

[0100]

[0101] For example, Figure 3 As shown, when uploading a file in .ctr format, the file content can be extracted through the Ctr parsing algorithm, and the file in .ctr format can be parsed to extract the data and write it into the library.

[0102] In one embodiment, the text content is parsed and stored based on the file format, including: when the file format is pm format, parsing a line element curve segment data set from the text content; dividing every three line element data in the line element curve segment data set into a group, and merging the line element data in each group into an array; constructing an attribute object set according to the line element data table field; and writing a plurality of the arrays into a database based on the attribute object set.

[0103] Specifically, the line element curve segment data (such as Figure 7 ). Example code is as follows:

[0104]

[0105] For example, Figure 3 As shown, when uploading a file in .pm format, the file content can be extracted through the Pm parsing algorithm, the file in .pm format can be parsed, the data can be parsed and written into the library.

[0106] In one embodiment, the text content is parsed and stored in a database based on the file format, including: when the file format is a wid format, parsing a road width data set from the text content; obtaining a left data set and a right data set from the road width data set according to left and right position numbers; constructing a storage attribute object set for the left data set and the right data set respectively; and writing the left data set and the right data set into a database based on the storage attribute object set.

[0107] Specifically, the left and right width information of the road width is parsed (such as Figure 8 ). Example code is as follows:

[0108]

[0109]

[0110] For example, Figure 3 As shown, when uploading a file in .wid format, the file content can be extracted through the Wid parsing algorithm, the file in .wid format can be parsed, the data can be parsed and written into the library.

[0111] In one embodiment, the text content is parsed and stored in a database based on the file format, including: when the file format is a dmx format, parsing a longitudinal section ground line data set from the text content; and writing the longitudinal section ground line data set into a database.

[0112] Specifically, the cross-section data (such as Fig. 9 ). Example code is as follows:

[0113] / / 1. Parse the data set from the text content, and the valid data starts from the second line

[0114] const fileData=this.splitFileContent(content).slice(1).filter(arr=>arr.some(item=>item!==”)&&arr.length>=2).map(arr=>arr.map(item=>item.replace( / [A-Za-z] / g,”)))

[0115] const atts=this.makeAttsByMajMin(fileData,ETTMAP.zdmdmxsj,fileName)

[0116] / / 2. Add to inventory.

[0117] For example, Figure 3 As shown, when uploading a file in .dmx format, the Dmx parsing algorithm can be used to extract the file content, parse the file in .dmx format, parse out the data and write it into the library.

[0118] It should be noted that in the above process of extracting and storing the original latitude and longitude survey files, the following auxiliary methods can be used:

[0119] Read the contents of files in different formats and cut them into two-dimensional arrays by rows and columns. Example code:

[0120] return content.split('\n').map(item=>item.replaceAll(",'\t').replaceAll('\r',")).map(item=>item.split('\t').filter(item=>item!=="))

[0121] Find the data of the specified module in the array after text conversion, and find the data of the specified module for further processing. Sample code example:

[0122] const fileData=this.splitFileContent(content);

[0123] / / Starting position

[0124] const beginIdx=fileData.findIndex(arr=>arr.some(item=>item.indexOf(key)!==-1));

[0125] const data=fileData.slice(beginIdx+1);

[0126] / / End position

[0127] const endIdx=data.findIndex(arr=>arr.some(item=>item.toLowerCase().indexOf('.dat')!==-1));

[0128] / / Extract the string in the range and format it

[0129] return data.slice(0,endIdx).map(arr=>arr.filter(item=>item.indexOf('r')===-1)).map(arr=>arr.map(item=>item.replace( / [A-Za-z] / g,”)));

[0130] In one embodiment, the pile number information is extracted based on the stored original data of the line element, and various vertical curve indicators are calculated based on the stored original data of the vertical curve element; basic data is generated based on the pile number information and various vertical curve indicators; and structure calculation is performed based on the basic data to obtain structure information.

[0131] For example, Figure 3 As shown, the second step is to calculate the coordinates, elevation, road width, and extract structures such as cut roadbed and fill roadbed based on the extracted data in combination with relevant mathematical formulas.

[0132] In one embodiment, if Figure 3 As shown, the structure information includes line element information, bridge information, tunnel information, hub interchange information, culvert information, bridge pier information and embankment and cutting information.

[0133] Specifically, vertical curve elevation calculation: refer to Fig.10 The calculation formula shown in the figure is used to determine the design elevation of the roadbed with a specified pile number on the design longitudinal slope. The calculation steps include:

[0134] (1) Basic elements for calculating vertical curves: vertical curve length: L; tangent length: T; external distance: E.

[0135] (2) Calculate the stake numbers of the starting and ending points of the vertical curve: the stake number of the starting point of the vertical curve = the stake number of the slope change point - T; the stake number of the end point of the vertical curve = the stake number of the slope change point + T.

[0136] (3) Calculate the tangent elevation and correction value of any point on the vertical curve: Tangent elevation = elevation of the slope change point ± (Tx) * i; Correction value:

[0137] (4) Calculate the design elevation of any point on the vertical curve: the design elevation of a pile number on a convex vertical curve = the design elevation of the pile number on the tangent - y; the design elevation of a pile number on a concave vertical curve = the design elevation of the pile number on the tangent + y.

[0138] In an example, the vertical curve elevation calculation is as follows: a secondary highway in a mountainous area, the slope change point stake number is K3+030.00, the elevation is 427.68, the front slope is upslope, i=+5%, the back slope is downslope, iq=-4%, and the vertical curve radius R=2000m. Calculate the design elevations of the vertical curve elements and stake numbers K3+000.00 and K3+100.00:

[0139] (1) Calculate the vertical curve element: ω = i1-i2 = 5%-(-4%) = 0.09, so the vertical curve is a convex vertical curve (such as Fig.11As shown), curve length: L = Rω = 2000 × 0.09 = 180m; tangent length: T = L / 2 = 180 / 2 = 90m; outer distance:

[0140] (2) Vertical curve starting and ending pile numbers: Vertical curve starting pile number = (K3 + 030.00) - 90 = K2 + 940.00; Vertical curve ending pile number = (K3 + 030.00) + 90 = K3 + 120.00.

[0141] (3) Tangent elevation and correction value of K3+000.00 and K3+100.00:

[0142] Tangent elevation of K3+000.00 = 427.68-(K3+030.00-K3+000.00)*5% = 426.18m

[0143]

[0144] Tangent elevation of K3+100.00 = 427.68-(K3+100.00-K3+030.00)*4% = 424.88m

[0145]

[0146] (4) Design elevations of K3+000.00 and K3+100.00:

[0147] Design elevation of K3+000.00=426.18-0.9=425.28m

[0148] The design elevation of K3+100.00=424.88-0.1=424.78m.

[0149] Exemplarily, the vertical curve elevation calculation algorithm code is implemented as follows:

[0150]

[0151] Specifically, the stake number (zh) coordinate information calculation algorithm code is implemented as follows:

[0152]

[0153]

[0154] Specifically, the calculation algorithm code of the pile number (zh) elevation information is implemented as follows:

[0155]

[0156]

[0157]

[0158]

[0159] Specifically, the line element coordinate calculation algorithm code is implemented as follows:

[0160]

[0161]

[0162]

[0163]

[0164]

[0165] It should be noted that if Figure 3 As shown, after extracting and storing the contents of various formats of latitude and land survey files, data parsing and calculation are started; the maximum, minimum, and 1m interval pile number information is extracted according to the stored line element original data, and the vertical curve indicators are calculated according to the stored vertical curve element original data to obtain basic data; various structural information calculations are performed according to the prepared basic data, such as line element information calculation (including coordinates), bridge information calculation (including coordinates), tunnel information calculation (including coordinates), hub interchange information calculation (including coordinates), culvert information calculation (including coordinates), bridge pier information calculation (including coordinates) and embankment and cutting information calculation (including coordinates) to obtain structural information, wherein the structural signal can also include basic attribute information, start and end line coordinates, left and right boundary lines, start and end structure detail coordinates, and start and end pile numbers, center pile number, and pile number along the way; the calculated structural information is written into the corresponding table of the database, and the data parsing of the latitude and land survey file is completed.

[0166] The method described in this embodiment is used for the data analysis algorithm and process for the latitude survey and design software, and has the following beneficial effects: Improve data processing efficiency: The algorithm and process of the method described in this embodiment can effectively analyze and process various types of geographic information data and design data, greatly improving the speed and efficiency of data processing and reducing the time cost in the engineering design process. Improve data analysis accuracy: The use of advanced data analysis technology can more accurately analyze and process various types of geological survey data, improve the accuracy and reliability of data, and provide more reliable data support for engineering design; Expand the scope of technical application: The algorithm and process of the method described in this embodiment can be widely used in geological survey, land planning, road design, hydrology and water conservancy and other fields, providing data analysis and processing support for different types of engineering projects, and expanding the scope of application of technology; Improve engineering design quality: By using the algorithm and process of the method described in this embodiment, engineers and technicians can be more effectively assisted in data analysis and processing, further improving the quality and effect of engineering design such as design plans and results.

[0167] The present embodiment provides a data parsing method for latitude and longitude survey files. In the present embodiment, the original latitude and longitude survey files are read, extracted and stored in the warehouse, which can realize the automatic parsing of files of different formats, and store the parsed data into the corresponding database table according to predefined rules, thereby optimizing the data parsing process, improving data processing efficiency and accuracy, and meeting the needs of different application scenarios.

[0168] In addition, an embodiment of the present invention further proposes a storage medium, on which a data parsing program for a latitude survey file is stored. When the data parsing program for a latitude survey file is executed by a processor, the steps of the data parsing method for a latitude survey file as described above are implemented.

[0169] Reference Fig.12 , Fig.12 This is a structural block diagram of an embodiment of a data parsing device for latitude and longitude survey files of the present invention.

[0170] like Fig.12 As shown, the data parsing device of the latitude survey file includes:

[0171] The file extraction module 10 is used to obtain the original latitude and longitude survey file, and extract the file content of the original latitude and longitude survey file and store it in the database;

[0172] The data analysis module 20 is used to extract the pile number information according to the stored line element original data, and calculate various indicators of the vertical curve according to the stored vertical curve element original data;

[0173] A data preparation module 30, for generating basic data according to the pile number information and various indicators of the vertical curve;

[0174] A structure calculation module 40 is used to perform structure calculation according to the basic data to obtain structure information;

[0175] The information writing module 50 is used to write the structure information into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file.

[0176] The present embodiment provides a data parsing device for latitude and longitude survey files. In the present embodiment, the original latitude and longitude survey files are read, extracted and stored in the warehouse, which can realize the automatic parsing of files of different formats, and store the parsed data into the corresponding database table according to predefined rules, thereby optimizing the data parsing process, improving data processing efficiency and accuracy, and meeting the needs of different application scenarios.

[0177] It should be noted that, for technical details that are not described in detail in the embodiment of the data parsing device for the latitude survey file, reference can be made to the data parsing method for the latitude survey file as described above provided in any embodiment of the present invention, and will not be repeated here.

[0178] It should be understood that the above is only an example and does not constitute any limitation on the technical solution of the present invention. In specific applications, technicians in this field can make settings as needed, and the present invention does not limit this.

[0179] It should be noted that the workflow described above is merely illustrative and does not limit the scope of protection of the present invention. In practical applications, those skilled in the art can select part or all of them according to actual needs to achieve the purpose of the present embodiment, which is not limited here. In addition, it should be noted that, in this article, the terms "include", "comprise" or any other variant thereof are intended to cover non-exclusive inclusion, so that the process, method, article or system including a series of elements includes not only those elements, but also includes other elements that are not explicitly listed, or also includes elements inherent to such process, method, article or system. In the absence of more restrictions, the elements defined by the sentence "including one..." do not exclude the existence of other identical elements in the process, method, article or system including the element. The above-mentioned serial numbers of the embodiments of the present invention are only for description and do not represent the advantages and disadvantages of the embodiments.

[0180] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as a read-only memory (ROM) / RAM, a magnetic disk, or an optical disk), and includes a number of instructions for a terminal device (which can be a mobile phone, a computer, a server, or a network device, etc.) to execute the methods described in each embodiment of the present invention.

[0181] The above are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A data analysis method for latitude and longitude survey files, characterized in that: include: Obtaining an original latitude and longitude survey file, and extracting and storing the file content of the original latitude and longitude survey file; Extract the pile number information based on the original data of the line element stored in the library, and calculate the various indicators of the vertical curve based on the original data of the vertical curve elements stored in the library; Generate basic data according to the pile number information and various indicators of the vertical curve; Perform structural calculations based on the basic data to obtain structural information; The structure information is written into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file.

2. The method according to claim 1, characterized in that The obtaining of the original latitude and longitude survey file, and extracting and storing the file content of the original latitude and longitude survey file, includes: Obtaining an original latitude and longitude survey file, and obtaining a file format according to the file name of the original latitude and longitude survey file; The file content of the original latitude and longitude survey file is cut according to rows and columns to obtain a two-dimensional array; Cut each line of the two-dimensional array according to the tag character and clean up the blanks to obtain the text content; The text content is parsed and stored based on the file format.

3. The method according to claim 2, characterized in that The parsing and warehousing of the text content based on the file format includes: When the file format is zdm format, a vertical curve element data set is parsed from the text content; Extracting vertical curve element valid data from the vertical curve element data set; Construct a collection of attribute objects based on the fields of the profile table; The valid data of the vertical curve element is written into a database based on the attribute object set.

4. The method according to claim 2, characterized in that The parsing and warehousing of the text content based on the file format includes: When the file format is hdm format, parsing the cross-section measurement data set from the text content; Acquire a left data set and a right data set from the cross-sectional measurement data set according to left and right position serial numbers respectively; Constructing a storage attribute object set for the left data set and the right data set respectively; The left data set and the right data set are written into a database based on the storage attribute object set.

5. The method according to claim 2, characterized in that The parsing and warehousing of the text content based on the file format includes: When the file format is a ctr format, the structure data sets are respectively parsed from the text content; wherein the structure data sets include a bridge data set, a culvert data set, a tunnel data set and a hub interchange data set; Writing the bridge data set, culvert data set, tunnel data set and hub interchange data set into corresponding tables of the database respectively; or, When the file format is a dmx format, a longitudinal section ground line data set is parsed from the text content; The longitudinal section ground line data set is written into the database.

6. The method according to claim 2, characterized in that The parsing and warehousing of the text content based on the file format includes: When the file format is PM format, parsing the line element curve segment data set from the text content; Grouping every three line element data in the line element curve segment data set into a group, and merging the line element data in each group into an array; Construct a collection of attribute objects according to the line metadata table fields; The plurality of arrays are written into a database based on the attribute object set.

7. The method according to claim 2, characterized in that The parsing and warehousing of the text content based on the file format includes: When the file format is wid format, parsing the road width data set from the text content; Respectively acquiring a left data set and a right data set from the road width data set according to left and right position serial numbers; Constructing a storage attribute object set for the left data set and the right data set respectively; The left data set and the right data set are written into a database based on the storage attribute object set.

8. The method according to any one of claims 1 to 7, characterized in that The structure information includes line element information, bridge information, tunnel information, hub interchange information, culvert information, bridge pier information and embankment and cutting information.

9. A data analysis device for latitude and longitude survey files, characterized in that: include: A file extraction module is used to obtain the original latitude and longitude survey file, and extract the file content of the original latitude and longitude survey file and store it in the database; The data analysis module is used to extract the pile number information according to the original data of the line element stored in the library, and calculate the various indicators of the vertical curve according to the original data of the vertical curve element stored in the library; A data preparation module, used to generate basic data according to the pile number information and various indicators of the vertical curve; A structure calculation module, used to perform structure calculation according to the basic data to obtain structure information; The information writing module is used to write the structure information into the corresponding table of the database to complete the data analysis of the latitude and longitude survey file.

10. An electronic device, characterized in that: The electronic device includes: a memory, a processor, and a data parsing program for a latitude survey file stored in the memory and executable on the processor, wherein the data parsing program for a latitude survey file is configured to implement a data parsing method for a latitude survey file as described in any one of claims 1 to 8.

Images