Straight-curve table processing method and device

Abstract

The present invention provides a straight curve table processing method and device, and the straight curve table processing method includes: S101: receiving an input instruction, obtaining the storage format of the straight curve table according to the instruction, and reading the straight curve table according to the storage format, wherein the storage format includes the number of rows where the table header is located and the number of columns where the elements contained in the intersection stored in the straight curve table are located; S102: judging whether the transition curve corresponding to the intersection is complete, if complete, executing S104, if incomplete, executing S103; S103: reading all the pile numbers of the transition curve, and calculating the coordinates of the transition curve according to the pile numbers; S104: forming an intersection data set according to the straight curve table, and processing the intersection data set according to the input processing instruction. The present invention can obtain the storage format of the straight curve table through the input instruction, read the straight curve table according to the storage format, and process the data in the straight curve table, with high efficiency, high speed, short time consumption, and will not confuse the rows and columns of data entry, avoiding data entry errors, and improving the speed and accuracy of road design.

Description

Technical Field

[0001] The invention relates to the field of road design, and in particular to a straight and curved table processing method and device. Background Art

[0002] Traditional road design methods include intersection method, element method and coordinate method, among which the most frequently used and widely used design method is intersection method. In the process of road centerline stakeout, the design unit generally hands over the designed straight-curve table file to the construction unit, and the construction personnel then input the data of each road intersection described in the straight-curve table into the construction stakeout handbook software system one by one for processing.

[0003] However, since there are many intersections in the designed road, the amount of data is relatively large, and manual input is inefficient, slow, and time-consuming. In addition, it is easy to confuse the rows and columns of data input during manual input, which can easily lead to data input errors and reduce the speed and accuracy of road design. Summary of the invention

[0004] In order to overcome the shortcomings of the prior art, the present invention proposes a straight-curve table processing method and device, which can obtain the storage format of the straight-curve table through input instructions, read the straight-curve table according to the storage format, and process the data in the straight-curve table. It is efficient, fast, and time-saving, and will not confuse the rows and columns of data entry, avoid data entry errors, and improve the speed and accuracy of road design.

[0005] To solve the above problem, a technical solution adopted by the present invention is: a straight-curve table processing method, the straight-curve table processing method comprising: S101: receiving an input instruction, obtaining a storage format of a straight-curve table according to the instruction, and reading the straight-curve table according to the storage format, wherein the storage format includes the row number where the table header is located and the column number where the elements contained in the intersection stored in the straight-curve table are located; S102: judging whether the transition curve corresponding to the intersection is complete, if complete, executing S104, if incomplete, executing S103; S103: reading all stake numbers of the transition curve, and calculating the coordinates of the transition curve according to the stake numbers; S104: forming an intersection data set according to the straight-curve table, and processing the intersection data set according to the input processing instruction.

[0006] Furthermore, before the step of determining whether the transition curve corresponding to the intersection point is complete, the step also includes: obtaining a parameter accuracy setting instruction for the transition curve radius.

[0007] Furthermore, the straight-curve table is an Excel table.

[0008] Furthermore, the step of reading the straight-curve table according to the storage format specifically includes: reading at least two of the pile number, coordinates, circle radius and transition curve radius, length and parameters of each intersection point in the straight-curve table according to the storage format.

[0009] Furthermore, the transition curve includes a first transition curve and a second transition curve.

[0010] Furthermore, the step of determining whether the transition curve corresponding to the intersection point is complete specifically includes: 2 =L*R to determine whether the transition curve is complete, wherein A is the transition curve parameter, L is the transition curve length, and R is the transition curve radius.

[0011] Furthermore, the step of reading all the pile numbers of the transition curve specifically includes: reading the pile numbers of the first transition curve in order of radius from large to small, and reading the pile numbers of the second transition curve in order of radius from small to large.

[0012] Furthermore, the step of forming an intersection data set according to the straight-curve table specifically includes: traversing each worksheet of the straight-curve table, cyclically reading data of all intersections in the straight-curve table, and forming an intersection data set according to the data.

[0013] Furthermore, the step of processing the intersection data set according to the input instruction specifically includes: generating at least one of a pile-by-pile coordinate table, a road element table, and a stakeout handbook according to the input instruction.

[0014] Furthermore, the straight-curve table processing device includes a processor and a memory, wherein the processor is coupled to the memory; the memory stores program data and the straight-curve table, and the processor executes the straight-curve table processing method as described above according to the program data.

[0015] Compared with the prior art, the beneficial effects of the present invention are: it is possible to obtain the storage format of the straight-curve table through input instructions, read the straight-curve table according to the storage format, and process the data in the straight-curve table, which is efficient, fast, and time-saving, and will not confuse the rows and columns of data entry, avoiding data entry errors, and improving the speed and accuracy of road design. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 A flow chart of an embodiment of a straight-curve table processing method of the present invention;

[0017] Figure 2 A system operation flow chart of an embodiment of a straight-curve table processing method of the present invention;

[0018] Figure 3A system operation flow chart of an embodiment of a straight-curve table processing method of the present invention;

[0019] Figure 4 It is a structural diagram of an embodiment of a straight-curve table processing device of the present invention. DETAILED DESCRIPTION

[0020] The present invention is further described below in conjunction with the accompanying drawings and specific implementation methods. It should be noted that, under the premise of no conflict, the various embodiments or technical features described below can be arbitrarily combined to form a new embodiment.

[0021] See also Figure 1-3 ,in, Figure 1 A flow chart of an embodiment of a straight-curve table processing method of the present invention; Figure 2 A system operation flow chart of an embodiment of a straight-curve table processing method of the present invention; Figure 3 FIG. 1 is a system operation flow chart of an embodiment of the straight-curve table processing method of the present invention. Figure 1-3 The straight-curve table processing method of the present invention is described in detail.

[0022] In this embodiment, the straight-curve table processing method includes:

[0023] S101: receiving an input instruction, obtaining a storage format of a straight-curve table according to the instruction, and reading the straight-curve table according to the storage format, wherein the storage format includes the row number where the table header is located and the column number where the elements contained in the intersection stored in the straight-curve table are located.

[0024] In this embodiment, the device for executing the straight-curve table processing method can be a computer, a server, a cloud server, a tablet computer, a mobile phone, and other physical smart devices or virtual terminals. The following description will be made with the device being a computer.

[0025] In this embodiment, the input instructions include the positions of each element of the intersection in the straight-curve table, which specifically include the intersection point name, north coordinate, east coordinate, circle radius, first transition curve length, second transition curve length, first transition curve parameters, second transition curve parameters, the column number where the intersection pile number is located, and the number of row jumps in the table header, whether to read alternate rows, the accuracy of the transition curve parameters, and other information.

[0026] In this embodiment, the straight-curve table is an Excel table, and the Excel table stores the data of each road intersection. The Excel table can be any one of *.xls, *.xlsx, and *.xlt files.

[0027] In other embodiments, the straight-curve table may also be a txt text file, a *.bin binary file, a Word file, or other files that can store intersection data, which is not limited here.

[0028] In this embodiment, the intersection data stored in the straight-curve table include the intersection name, plane coordinates, intersection pile number, turning angle value, circular curve radius, transition curve parameters and length, tangent length, and curve length. It also stores some verification data information of the intersections, such as the mileage and coordinates of the starting and ending points of the transition curve, the length and orientation of the straight line, and other intersection element information.

[0029] The straight-curve table stores a lot of useful intersection information, but not all information is necessary for building roads. Generally speaking, knowing the coordinates of each intersection that makes up the road, the radius and parameters of the transition curve, and the radius of the circle you go through can create complete road information. Adding the intersection pile number that represents the road mileage, you can match the designed road with the construction mileage.

[0030] In this embodiment, the step of reading the straight-curve table according to the storage format specifically includes: reading at least two of the stake number, coordinates, circle radius and transition curve radius, length and parameters of each intersection point in the straight-curve table according to the storage format.

[0031] In this embodiment, the coordinates include the north coordinate and the east coordinate of the intersection, and the transition curve includes a first transition curve and a second transition curve.

[0032] In this embodiment, the computer can receive input instructions through the keyboard, voice and handwriting, and obtain the storage format of the straight-curve table according to the instructions. In other embodiments, the computer can also obtain the storage format information of the straight-curve table by reading a header screenshot of the straight-curve table or loading the straight-curve table, and read the intersection data stored in the straight-curve table according to the storage format information.

[0033] In a specific embodiment, the computer receives an input instruction through the road design system running on the computer, obtains the storage format of the straight-curve table according to the instruction, opens the corresponding straight-curve table document, and reads the original data cached in the straight-curve table document.

[0034] S102: Determine whether the transition curve corresponding to the intersection point is complete. If it is complete, execute S104; if it is incomplete, execute S103.

[0035] In this embodiment, before the step of determining whether the transition curve corresponding to the intersection point is complete, the method further includes: obtaining a parameter accuracy setting instruction for the transition curve radius. When determining whether the transition curve is complete, the parameter of the transition curve radius is processed according to the parameter accuracy setting instruction. The parameter accuracy setting instruction can be input to the computer before the system in the computer reads the straight curve table, or can be obtained when the computer determines whether the transition curve is complete.

[0036] In this embodiment, when designing a road using the intersection data in the straight-curve table, it is necessary to determine whether the transition curve corresponding to each intersection is a complete curve.

[0037] In this embodiment, the step of determining whether the transition curve corresponding to the intersection point is complete specifically includes: 2 =L*R is used to determine whether the transition curve is complete, where A is the transition curve parameter, L is the transition curve length, and R is the transition curve radius.

[0038] For the intersection feature, there is a typical structure of straight line-first transition curve-circle-second transition curve-straight line, and the length, radius and parameters of the two transition curves obey the formula A 2 =L·R, by judging whether the first transition curve parameter is the same as the second transition curve parameter, it can be judged whether the transition curve is complete.

[0039] In a specific embodiment, the straight curve table stores the transition curve radius and transition curve length, and the computer calculates the transition curve constant according to the transition curve radius and transition curve length in the straight curve table through the road design system. And it is determined whether the transition curve constant of the first transition curve is the same as the transition curve constant of the second transition curve. If they are the same, it is determined that the transition curve is complete, and if they are not the same, it is determined that the transition curve is incomplete.

[0040] S103: Read all stake numbers of the transition curve, and calculate the coordinates of the transition curve according to the stake numbers.

[0041] In this embodiment, for incomplete transition curves, the system determines the comparison between the starting radius and the end radius of each transition curve, and divides the transition curve into two situations for separate processing: whether the starting radius to the end radius of the transition curve extends from a large radius to a small radius or from a small radius to a large radius. For the first transition curve, the starting radius is the radius of the connecting straight line (with an infinite radius) or the starting curve of the connecting transition curve, and the end radius is the radius of the circular curve; for the second transition curve, the starting radius is the radius of the circular curve, and the end radius is the radius of the curve connecting the end of the transition curve or the radius of the straight line (infinite).

[0042] In this embodiment, the step of reading all the pile numbers of the transition curve specifically includes: reading the pile number of the first transition curve in order of radius from large to small, and reading the pile number of the second transition curve in order of radius from small to large. According to the coordinates of the pile number, the relevant parameters and curve elements of the complete transition curve including the incomplete transition curve are calculated, and then the coordinates of any point on the incomplete transition curve are calculated according to the method of calculating the coordinates of the complete transition curve, and the coordinates are stored in the straight curve table to obtain the intersection data. Among them, the method of calculating the complete transition curve and the coordinates of the transition curve can refer to the existing technology, which will not be repeated here.

[0043] S104: forming an intersection data set according to the straight-curve table, and processing the intersection data set according to the input processing instruction.

[0044] In this embodiment, the step of forming an intersection data set according to the straight-curve table specifically includes: traversing each worksheet of the straight-curve table, cyclically reading data of all intersections in the straight-curve table, and forming an intersection data set according to the data.

[0045] In this embodiment, the step of processing the intersection data set according to the input command specifically includes: generating at least one of a pile-by-pile coordinate table, a road element table, and a stakeout handbook according to the input command.

[0046] In a specific embodiment, the road design system operated by the computer includes a road data entry module and a road result output module. The computer receives the input instruction through the road design entry module to obtain the storage format of the straight curve table, and obtains the location of the straight curve table file, imports the straight curve table data according to the location, directly obtains the starting mileage, coordinates, transition curve length, transition curve radius and other information, and processes the obtained information to form an intersection data set. The road result output module receives the input processing instruction, and after processing the intersection data set according to the processing instruction, it can display the road design graphics, simulate the road setting out, and display the result table of the coordinates of each pile, and finally can export the road design file and the result table of the coordinates of each pile to deliver to the user for field setting out.

[0047] Among them, the road results output module can also receive the input preview instructions, parse the contents of the straight curve table according to the preview instructions, and display the information of each intersection in the form of a table on the interface, including the integrity and correctness of the intersection. Users can enter processing instructions such as modification and deletion of data by double-clicking the cell. After the user confirms that the data is correct, click "Confirm", and the road design system will store the data in the interface table into the software and automatically calculate the road. Users can view the road direction and graphics in the graphical interface, view the road's pile-by-pile coordinate table, and perform simulated stakeout and other operations. Users can also output the road design results in EXCEL format, such as the pile-by-pile coordinate table and road element table, in the road design system, and generate and save road files suitable for the stakeout manual for field stakeout.

[0048] The platform applicable to the straight-curve table processing method of the present invention is a QT-based Windows system application, but is not limited to the straight-curve table importing method under the Windows system.

[0049] In other embodiments, it can also be applied to Linux environment, Unix environment and other operating system environments. The programming language used to implement the straight-curve table processing method can also be set according to user needs, which will not be elaborated here.

[0050] Beneficial effects: The straight-curve table processing method of the present invention can obtain the storage format of the straight-curve table through input instructions, read the straight-curve table according to the storage format, and process the data in the straight-curve table, which is efficient, fast, and time-saving, and will not confuse the rows and columns of data entry, avoid data entry errors, and improve the speed and accuracy of road design.

[0051] Based on the same inventive concept, the present invention also proposes a straight-curve table processing device, see Figure 4 , Figure 4 This is a structural diagram of an embodiment of a straight-curve table processing device of the present invention, Figure 4 The straight-curve table processing device of the present invention is described in detail.

[0052] The straight-curve table processing device includes a processor and a memory, and the processor is coupled to the memory;

[0053] The memory stores program data and a straight-curve table, and the processor executes the straight-curve table processing method described in the above embodiment according to the program data.

[0054] In this embodiment, the straight-curve table processing device can be a computer, a server, a cloud server, a tablet computer, a mobile phone, and other physical smart devices or virtual terminals.

[0055] Beneficial effects: The straight-curve table processing device of the present invention can obtain the storage format of the straight-curve table through input instructions, read the straight-curve table according to the storage format, and process the data in the straight-curve table, which is efficient, fast, and time-saving, and will not confuse the rows and columns of data entry, avoid data entry errors, and improve the speed and accuracy of road design.

[0056] In the several embodiments provided by the present invention, it should be understood that the disclosed devices, modules and circuits can be implemented in other ways. For example, the device implementation described above is only schematic. For example, the structural device division of the module is only a logical function division. There may be other division methods in actual implementation, such as multiple modules can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interface, device or, which can be electrical, mechanical or other forms.

[0057] The components described as separate components may or may not be physically separated, and the components shown may or may not be physical, that is, they may be located in one place or distributed in multiple locations. Some or all of them may be selected according to actual needs to achieve the purpose of this embodiment.

[0058] The above-mentioned embodiments are only preferred embodiments of the present invention and cannot be used to limit the scope of protection of the present invention. Any non-substantial changes and substitutions made by technicians in this field on the basis of the present invention shall fall within the scope of protection required by the present invention.

Claims

1. A straight-curve table processing method, characterized in that: The straight-curve table processing method comprises: S101: receiving an input instruction, obtaining a storage format of a straight-curve table according to the instruction, and reading at least two of the pile number, coordinates, circle radius, and transition curve radius, length, and parameters of each intersection point in the straight-curve table according to the storage format; wherein the storage format includes the row number where the table header is located and the column number where the elements contained in the intersection points stored in the straight-curve table are located; S102: Determine whether the transition curve corresponding to the intersection point is complete, if complete, execute S104, if incomplete, execute S103; wherein the transition curve includes a first transition curve and a second transition curve; S103: Read all stake numbers of the transition curve, and calculate the coordinates of the transition curve according to the stake numbers; S104: forming an intersection data set according to the straight-curve table, and processing the intersection data set according to an input processing instruction; Wherein, for an incomplete transition curve, reading all the stakes of the transition curve includes: for a first transition curve, reading the stakes of the first transition curve in order of radius from large to small, and for a second transition curve, reading the stakes of the second transition curve in order of radius from small to large; and, The step of calculating the coordinates of the transition curve according to the stake number comprises: The relevant parameters and curve elements of the complete transition curve including the incomplete transition curve are calculated according to the coordinates of the pile number, and then the coordinates of any point on the incomplete transition curve are calculated according to the method of calculating the coordinates of the complete transition curve, and the coordinates are stored in the straight curve table to obtain the intersection data.

2. The straight-curve table processing method according to claim 1, characterized in that: Before the step of determining whether the transition curve corresponding to the intersection point is complete, the following step is further included: Get the parameter accuracy setting instruction of the transition curve radius.

3. The straight-curve table processing method according to claim 1, characterized in that: The straight-curve table is an Excel table.

4. The straight-curve table processing method according to claim 1, characterized in that: The step of judging whether the transition curve corresponding to the intersection point is complete specifically includes: By formula Determine whether the transition curve is complete, wherein A is the transition curve parameter, L is the transition curve length, and R is the transition curve radius.

5. The straight-curve table processing method according to claim 1, characterized in that: The step of forming an intersection data set according to the straight-curve table specifically includes: Each worksheet of the straight-curve table is traversed, the data of all intersections in the straight-curve table are cyclically read, and an intersection data set is formed according to the data.

6. The straight-curve table processing method according to claim 5, characterized in that: The step of processing the intersection data set according to the input processing instruction specifically includes: At least one of a pile-by-pile coordinate table, a road element table and a stakeout handbook is generated according to the input processing instruction.

7. A straight-curve table processing device, characterized in that: The straight-curve table processing device comprises a processor and a memory, wherein the processor is coupled to the memory; The memory stores program data and a straight-curve table, and the processor executes the straight-curve table processing method according to any one of claims 1 to 6 according to the program data.

Images