A method and system for batch extraction of geological information based on CAD drawings

Abstract

The present invention discloses a method and system for batch extracting geological information based on CAD drawings. The method comprises: step 101, preprocessing a geological longitudinal section CAD drawing; step 102, redefining the layer name of the upper boundary line of each soil layer with the rock and soil category number as the name; step 103, importing a stratum code table and a bridge mileage table, and drawing pier position lines; step 104, calculating the coordinates of the intersection of each pier position line and the boundary lines of each soil layer; step 105, calculating the thickness of each soil layer, recording the soil layer name, and generating a table containing all pier position stratum data.

Description

Technical Field

[0001] The present invention belongs to the technical field of geological information processing, and more specifically, relates to a method and system for batch extracting geological information based on CAD drawings. Background Art

[0002] When designing elevated bridges such as railways, highways or rail transit, it is necessary to extract the rock and soil stratification and parameter information of all pile positions for the calculation of the bearing capacity of the lower structures such as pile foundations and caps. The number of piles in long and large elevated lines is huge, and the lower structure of each pile position needs to be mechanically verified according to the geological conditions and span results. Affected by external conditions and related professional plans, the line is frequently adjusted and optimized during the design phase, and the workload of the lower structure bearing capacity verification of the bridge span design is large. The geological data of the drilling position is mainly obtained manually from the geological longitudinal section. When the span plan is adjusted, the pile position will change, and the geological conditions and burial depth data need to be re-queried, which is extremely inefficient. It is urgent to develop pile position data based on the bridge span plan to achieve rapid capture of corresponding geological parameters and support design calculations, and improve the utilization efficiency and editing degree of survey results.

[0003] At present, there are studies on geological survey tools and methods, mainly focusing on geological survey field data collection, two-dimensional geological profile generation and three-dimensional geological modeling. For example, "An information system integrating engineering geology field and field" (application number: 201510532049.6) uses new information technology, combined with mobile terminal technology, global positioning system technology, geographic information system, and computer-aided design technology to realize an information system integrating engineering geology field and field. "A three-dimensional visualization processing method for engineering geological information" proposes a three-dimensional visualization processing method for engineering geological information, improves the collection and centralized processing efficiency of engineering geological information, and generates two-dimensional geological maps and three-dimensional models based on drilling data. "A system and method for linking coal mine geotechnical data and drawings" mainly solves the problems of geological database construction, geological two-dimensional profile generation and dynamic update, and is mainly used for the synchronization update of drawings after the address drilling data is gradually enriched.

[0004] In summary, existing research mainly solves problems such as process data management and automated generation of results in the survey process, and realizes the key technologies required for survey and production, from drilling data to two-dimensional profiles, and then to the generation of three-dimensional models, but does not involve technical methods for convenient extraction and calling of geological parameters required for downstream design. During the bridge engineering design stage, the application scenarios for the survey results are mainly to obtain the stratigraphic distribution information of the pile layout location from the geological profile CAD drawing, and perform mechanical calculations together with the geotechnical test parameters. When the bridge span plan is adjusted, the pile foundation position and burial depth change, and it is necessary to re-acquire the geological stratification information of the corresponding pile foundation position. Therefore, there is an urgent need for a technical solution that can batch extract geological information based on CAD drawings. Summary of the invention

[0005] In order to solve the above technical problems, the present invention proposes a method for batch extraction of geological information based on CAD drawings, comprising:

[0006] Step 101, preprocessing the geological longitudinal section CAD drawing;

[0007] Step 102, using the geotechnical category number as the name, redefine the layer name of the upper boundary of each soil layer;

[0008] Step 103, importing the stratum code table and bridge mileage table, and drawing the pier position line;

[0009] Step 104, calculating the coordinates of the intersections of each pier position line and each soil layer boundary line;

[0010] Step 105, calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data.

[0011] Furthermore, the preprocessing of the geological longitudinal section CAD drawing in step 101 is specifically as follows: adjusting the drawing scale of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through a primitive scaling operation.

[0012] Furthermore, in step 102, the layer name of the upper boundary of each soil layer is redefined using the soil layer type number as the name: the layer name of the upper boundary of each soil layer is redefined using the geotechnical category number of the layer of the lower boundary of the soil layer.

[0013] Furthermore, the calculation of the intersection coordinates of each pier position line and each soil layer boundary line in step 104 is specifically as follows: according to the pier position number sequence, the intersection coordinate values ​​of each vertical pier position line and the soil layer boundary line are calculated in sequence, and the pier position number is used as a unique identifier.

[0014] Furthermore, the step 105 of calculating the thickness of each soil layer includes: calculating the Y coordinate difference between two upper and lower adjacent intersection points in turn according to the coordinate values ​​of the intersection points of the pier position line and the boundary lines of each soil layer, to obtain the thickness of each soil layer.

[0015] The present invention also proposes a geological information batch extraction system based on CAD drawings, comprising:

[0016] Preprocessing module, used to preprocess geological longitudinal section CAD drawings;

[0017] The redefinition module is used to redefine the layer name of the upper boundary of each soil layer using the geotechnical category number as the name;

[0018] The module for drawing pier position lines is used to import the formation code table and bridge mileage table and draw pier position lines;

[0019] The intersection coordinate calculation module is used to calculate the intersection coordinates of each pier position line and each soil layer boundary line;

[0020] The table generation module is used to calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data.

[0021] Furthermore, the preprocessing module preprocesses the geological longitudinal section CAD drawing by adjusting the drawing scales of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through a primitive scaling operation.

[0022] Furthermore, the redefinition module uses the soil layer type number as the name to redefine the layer name of the upper boundary of each soil layer. Specifically, the layer name of the upper boundary of each soil layer is redefined using the geotechnical category number of the layer of the lower boundary of the soil layer.

[0023] Furthermore, the intersection coordinate calculation module calculates the intersection coordinates of each pier position line and each soil layer boundary line in the following manner: according to the pier position number sequence, the intersection coordinate values ​​of each vertical pier position line and the soil layer boundary line are calculated in sequence, and the pier position number is used as the unique identifier.

[0024] Furthermore, the calculation of the thickness of each soil layer in the table generation module includes: calculating the Y coordinate difference between two adjacent intersection points in turn according to the coordinate values ​​of the intersection points of the pier position line and the boundary lines of each soil layer to obtain the thickness of each soil layer.

[0025] In general, the above technical solution conceived by the present invention has the following beneficial effects compared with the prior art:

[0026] Through the above technical scheme, the present invention can quickly obtain the geological type and layer thickness information of all pier positions in the geological profile CAD drawing, and form a data table, which can be quickly matched with the geotechnical experimental parameters in the bridge substructure bearing capacity verification link, greatly improving the efficiency of geological parameter collection and parameter configuration. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Figure 1 is a flow chart of the method of embodiment 1 of the present invention;

[0028] Figure 2 is a structural diagram of a system in Embodiment 2 of the present invention;

[0029] Figure 3 It is a schematic diagram of pier position line layout and intersection analysis according to Example 1 of the present invention;

[0030] Figure 4 This is a schematic diagram of the bridge mileage representation of Example 1 of the present invention;

[0031] Figure 5 It is a schematic diagram of soil layer data analysis and calculation at each pier position in Example 1 of the present invention;

[0032] Figure 6 It is a schematic diagram of the geological stratification information of each pier position derived in Example 1 of the present invention.

[0033] Wherein, the accompanying drawings are marked as follows:

[0034] 1 – upper dividing line of soil layer;

[0035] 2 – lower dividing line of soil layer;

[0036] 3——pier position line;

[0037] 4——The intersection of the pier position line and the upper boundary line of the soil layer;

[0038] 5——The intersection of the pier position line and the boundary line under the soil layer. DETAILED DESCRIPTION

[0039] In order to better understand the above technical solution, the above technical solution will be described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0040] The method provided by the present invention can be implemented in the following terminal environment, and the terminal may include one or more of the following components: a processor, a storage medium, and a display screen. The storage medium stores at least one instruction, and the instruction is loaded and executed by the processor to implement the method described in the following embodiment.

[0041] The processor may include one or more processing cores. The processor uses various interfaces and lines to connect various parts in the entire terminal, and executes various functions of the terminal and processes data by running or executing instructions, programs, code sets or instruction sets stored in the storage medium, and calling data stored in the storage medium.

[0042] The storage medium may include a random access memory (RAM) or a read-only memory (ROM). The storage medium may be used to store instructions, programs, codes, code sets or instructions.

[0043] The display screen is used to display the user interface of each application.

[0044] In addition, those skilled in the art can understand that the structure of the above terminal does not constitute a limitation on the terminal, and the terminal may include more or fewer components, or combine certain components, or arrange the components differently. For example, the terminal also includes components such as a radio frequency circuit, an input unit, a sensor, an audio circuit, and a power supply, which will not be described in detail here.

[0045] Example 1

[0046] like Figure 1 As shown, an embodiment of the present invention provides a method for batch extraction of geological information based on CAD drawings, comprising:

[0047] Step 101, pre-processing the geological longitudinal section map, with the X:Y axis ratio being 1:1;

[0048] Step 102, using the geotechnical type number as the name, redefine the layer name of the upper boundary of each soil layer;

[0049] Step 103, after importing the stratum code table and bridge mileage table, draw the pier position line;

[0050] Step 104, calculating the coordinates of the intersections of each pier position line and each soil layer boundary line;

[0051] Step 105, calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data. In this technical solution, the technical principle is made public, and corresponding software is provided to realize the batch rapid collection of geological parameters required for bridge substructure calculation.

[0052] In the above technical solution, step 101 includes: checking the drawing scale of the X-axis and Y-axis of the geological longitudinal section CAD drawing, adjusting it to a 1:1 real scale through the primitive scaling operation, and unifying the measurement units for the subsequent drawing of pier position lines and calculation of soil layer thickness.

[0053] In the above technical solution, step 102 includes: renaming the layer of the soil layer boundary line in the cross-section diagram, and the name uses the geotechnical category number of the layer below the boundary line. The soil layer boundary line should be continuous and uninterrupted to ensure that the vertical positioning line drawn later has an intersection with it. The geotechnical category number should be consistent with the number in the figure to ensure that the geotechnical test parameters can be associated with the number as a unique identifier in subsequent calculations. To facilitate the preparation of data tables, the layer number is expressed in pure numbers, such as "2-1" (such as Figure 3 as shown).

[0054] In the above technical solution, step 103 includes: importing a stratigraphic code table containing stratigraphic codes and stratigraphic names, and storing relevant data. Importing a bridge mileage table containing pier numbers, mileages and spans (such as Figure 4 ) and store the relevant data, pick up a point in the diagram, and enter the X coordinate value as the reference point. According to the bridge odometer data, calculate the relative coordinates of each pier and the reference point in turn, locate the pier position, draw the vertical pier line, and write the pier number into the attribute information of the pier line as the unique identifier of the line. The vertical pier line is expressed in a highlighted color to facilitate data inspection.

[0055] In the above technical solution, step 104 includes: calculating the intersection coordinate values ​​of each vertical pier line and the soil layer boundary line in sequence according to the pier number sequence, and storing the relevant data with the pier number as the unique identifier. The intersection coordinate data of the pier line and the soil layer boundary line are arranged in descending order according to the Y coordinate value.

[0056] In the above technical solution, if Figure 5 As shown, step 105 includes: according to the coordinate values ​​of the intersection points of the pier position line and the boundary lines of each soil layer, the Y coordinate difference between the two adjacent intersection points is calculated in turn to obtain the thickness of the soil layer, and the relevant data is stored. According to the pier position number, the intersection coordinate data of all pier position lines are traversed in turn to obtain a stratum data information table containing pier number, pier number mileage, soil layer number and soil layer thickness, and after confirmation, it is exported to an Excel table (such as Figure 6 When calculating the thickness of the soil layer, the bottom soil layer often lacks the lower boundary, so the Y coordinate of the bottom intersection point is taken according to the drilling depth.

[0057] According to the coordinate values ​​of the intersection points of the pier position line and the boundary lines of each soil layer, the Y coordinate difference of the two adjacent intersection points is calculated in turn to obtain the thickness of the soil layer, specifically:

[0058] First, if Figure 3The geological stratification map is a fixed result obtained after the survey. The vertical line 3 represents the drilling position, which may change according to the design position of the bridge design pile. The present invention calculates the local stratum distribution based on the intersection of the pile, i.e., the positioning line, and the stratum boundary line.

[0059] For a bridge design project, the geological entity information is unchanged, and the layered information (such as Figure 3 Layer lines such as 1 and 2 in the figure may vary due to differences in survey point density, data processing experience, etc. Figure 3 The pile position line represented by 1 in the middle changes according to the pile layout plan of the design.

[0060] The strata are sorted from top to bottom, and the intersections of the pile position lines and the strata boundary lines are also sorted from top to bottom. The thickness of the soil layer is calculated as follows: the thickness of the i-th layer map Hi = |Zi -Zi+1|. Figure 3 , the thickness of the first layer of soil (miscellaneous fill soil) is the elevation coordinate of the first intersection "point 4" minus the elevation coordinate of the second intersection "point 5". Note: The vertical coordinates of the geological profile are elevation coordinates; the definition of soil layer sequence and intersection sequence does not affect this calculation, and can be synchronized with the storage logic.

[0061] In order to calculate the soil layer thickness more accurately, this embodiment sets a dynamic soil layer thickness model to calculate the dynamic thickness of the soil layer. The dynamic soil layer thickness model is as follows:

[0062] ,

[0063] in, For the The thickness of the soil layer, For the The vertical coordinates of the upper and lower boundaries of the soil layer, For the The vertical coordinates of the upper and lower boundaries of the soil layer, is the amplitude factor, which is used to control the intensity of the soil layer thickness changing with the vertical axis coordinate. is the frequency factor, which is used to adjust the frequency of soil thickness changes. is an exponential decay factor, which is used to affect the rapid decay of soil thickness along the vertical axis. is the first adjustment factor of the dynamic soil thickness model, is an oscillation factor used to capture the periodic variation of soil thickness. It is the second adjustment factor of the dynamic soil thickness model.

[0064] In order to more accurately calculate the intersection coordinates of the pier position line and the soil layer boundary, the calculation model of the intersection of the pier position line and the soil layer boundary is set as shown below:

[0065] ,

[0066] in, For the The pier line and the The coordinates of the intersection of the soil layers, For the The horizontal and vertical coordinates of the pier line, For the The vertical coordinate of the soil layer boundary, is the number of multiple effects, For the The first adjustment factor for this effect is For the The angle of the pier line, For the The second adjustment factor for this effect is For the The angle of the soil layer boundary, For the The third adjustment factor for this effect is For the The fourth adjustment factor for this effect is For the The reference horizontal and vertical coordinates of the pier line.

[0067] For example, multiple effects can be the following:

[0068] Soil type:

[0069] Clay, sand, gravel, limestone, sandstone, etc.

[0070] Soil thickness:

[0071] The actual thickness of different soil layers, such as topsoil, bearing layer, bedrock, etc.

[0072] Soil layer boundaries:

[0073] Interface characteristics between different soil layers, such as the shape and location of the dividing line.

[0074] Soil density:

[0075] The density values ​​of different soil layers have a direct impact on their bearing capacity and stability.

[0076] A soil layer comprehensive characteristic evaluation model is set to evaluate the bearing capacity of the soil layer. The soil layer comprehensive characteristic evaluation model is as follows:

[0077] ,

[0078] in, It is an evaluation index of the comprehensive characteristics of soil layers. is the number of soil layers, It is the first adjustment factor of the soil comprehensive characteristic evaluation model. It is the second adjustment factor of the soil comprehensive characteristic evaluation model. is the soil layer slope, It is the third adjustment factor of the soil comprehensive characteristic evaluation model. is the variance of the soil layer thickness, It is the fourth adjustment factor of the soil comprehensive property evaluation model.

[0079] Example 2

[0080] like Figure 2 As shown, the embodiment of the present invention also provides a geological information batch extraction system based on CAD drawings, including:

[0081] Preprocessing module, used to preprocess geological longitudinal section CAD drawings;

[0082] Specifically, the preprocessing module preprocesses the geological longitudinal section CAD drawing by adjusting the drawing scales of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through a primitive scaling operation.

[0083] The redefinition module is used to redefine the layer name of the upper boundary of each soil layer using the geotechnical category number as the name;

[0084] Specifically, the redefinition module uses the soil layer type number as the name to redefine the layer name of the upper boundary of each soil layer. Specifically, the layer name of the upper boundary of each soil layer is redefined using the geotechnical category number of the layer of the lower boundary of the soil layer.

[0085] The module for drawing pier position lines is used to import the formation code table and bridge mileage table and draw pier position lines;

[0086] The intersection coordinate calculation module is used to calculate the intersection coordinates of each pier position line and each soil layer boundary line;

[0087] Specifically, the intersection coordinates calculation module calculates the intersection coordinates of each pier position line and each soil layer boundary line by calculating the intersection coordinates of each vertical pier position line and the soil layer boundary line in sequence according to the pier position number sequence, and uses the pier position number as a unique identifier.

[0088] The table generation module is used to calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data.

[0089] Specifically, the calculation of the thickness of each soil layer in the table generation module includes: calculating the Y coordinate difference between two adjacent intersection points in turn according to the coordinate values ​​of the intersections of the pier position line and the boundary lines of each soil layer, to obtain the thickness of each soil layer.

[0090] Example 3

[0091] The embodiment of the present invention further provides a storage medium storing a plurality of instructions, wherein the instructions are used to implement the method for batch extracting geological information based on CAD drawings.

[0092] Optionally, in this embodiment, the above storage medium may be located in any computer terminal in a computer terminal group in a computer network, or in any mobile terminal in a mobile terminal group.

[0093] Optionally, in this embodiment, the storage medium is configured to store program codes for executing the following steps: Step 101, preprocessing the geological longitudinal section CAD drawing;

[0094] Step 102, using the geotechnical category number as the name, redefine the layer name of the upper boundary of each soil layer;

[0095] Step 103, importing the stratum code table and bridge mileage table, and drawing the pier position line;

[0096] Step 104, calculating the coordinates of the intersections of each pier position line and each soil layer boundary line;

[0097] Step 105, calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data.

[0098] Specifically, the preprocessing of the geological longitudinal section CAD drawing in step 101 is specifically: adjusting the drawing scale of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through the primitive scaling operation.

[0099] Specifically, in step 102, the layer name of the upper boundary of each soil layer is redefined using the soil layer type number as the name: the layer name of the upper boundary of each soil layer is redefined using the geotechnical category number of the layer of the lower boundary of the soil layer.

[0100] Specifically, the coordinates of the intersections of each pier position line and each soil layer boundary line are calculated in step 104 as follows: according to the pier position number sequence, the coordinates of the intersections of each vertical pier position line and the soil layer boundary line are calculated in sequence, and the pier position number is used as a unique identifier.

[0101] Specifically, the step 105 of calculating the thickness of each soil layer includes: calculating the Y coordinate difference between two adjacent intersection points in turn according to the coordinate values ​​of the intersection points between the pier position line and the boundary lines of each soil layer, to obtain the thickness of each soil layer.

[0102] Example 4

[0103] An embodiment of the present invention also proposes an electronic device, including a processor and a storage medium connected to the processor, wherein the storage medium stores multiple instructions, and the instructions can be loaded and executed by the processor so that the processor can execute the method for batch extraction of geological information based on CAD drawings.

[0104] Specifically, the electronic device of this embodiment may be a computer terminal, and the computer terminal may include: one or more processors, and a storage medium.

[0105] Among them, the storage medium can be used to store software programs and modules, such as a method for batch extraction of geological information based on CAD drawings in an embodiment of the present invention, corresponding program instructions / modules, and the processor executes various functional applications and data processing by running the software programs and modules stored in the storage medium, that is, realizing the above-mentioned method for batch extraction of geological information based on CAD drawings. The storage medium may include a high-speed random storage medium, and may also include a non-volatile storage medium, such as one or more magnetic storage systems, flash memory, or other non-volatile solid-state storage media. In some instances, the storage medium may further include a storage medium remotely arranged relative to the processor, and these remote storage media may be connected to the terminal via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0106] The processor can call the information and application program stored in the storage medium through the transmission system to perform the following steps: Step 101, preprocessing the geological longitudinal section CAD drawing;

[0107] Step 102, using the geotechnical category number as the name, redefine the layer name of the upper boundary of each soil layer;

[0108] Step 103, importing the stratum code table and bridge mileage table, and drawing the pier position line;

[0109] Step 104, calculating the coordinates of the intersections of each pier position line and each soil layer boundary line;

[0110] Step 105, calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data.

[0111] Specifically, the preprocessing of the geological longitudinal section CAD drawing in step 101 is specifically: adjusting the drawing scale of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through the primitive scaling operation.

[0112] Specifically, in step 102, the layer name of the upper boundary of each soil layer is redefined using the soil layer type number as the name: the layer name of the upper boundary of each soil layer is redefined using the geotechnical category number of the layer of the lower boundary of the soil layer.

[0113] Specifically, the coordinates of the intersections of each pier position line and each soil layer boundary line are calculated in step 104 as follows: according to the pier position number sequence, the coordinates of the intersections of each vertical pier position line and the soil layer boundary line are calculated in sequence, and the pier position number is used as a unique identifier.

[0114] Specifically, the step 105 of calculating the thickness of each soil layer includes: calculating the Y coordinate difference between two adjacent intersection points in turn according to the coordinate values ​​of the intersection points between the pier position line and the boundary lines of each soil layer, to obtain the thickness of each soil layer.

[0115] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0116] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0117] In the several embodiments provided by the present invention, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the system embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components 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 through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

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

[0119] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0120] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only storage medium (ROM, Read-Only Memory), random access storage medium (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes.

[0121] Obviously, the above embodiments are merely examples for the purpose of clear explanation, and are not intended to limit the implementation methods. For those skilled in the art, other different forms of changes or modifications can be made based on the above description. It is not necessary and impossible to list all the implementation methods here. The obvious changes or modifications derived therefrom are still within the scope of protection of the invention.

Claims

1. A method for batch extraction of geological information based on CAD drawings, characterized in that: include: Step 101, preprocessing the geological longitudinal section CAD drawing; Step 102, using the geotechnical category number as the name, redefine the layer name of the upper boundary of each soil layer; Step 103, importing the stratum code table and bridge mileage table, and drawing the pier position line; Step 104, calculating the coordinates of the intersections of each pier position line and each soil layer boundary line; Step 105, calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data; It also includes setting a dynamic soil thickness model to calculate the dynamic thickness of the soil layer. The dynamic soil thickness model includes: ， in, For the The thickness of the soil layer, For the The vertical coordinates of the upper and lower boundaries of the soil layer, For the The vertical coordinates of the upper and lower boundaries of the soil layer, is the amplitude factor, which is used to control the intensity of the soil layer thickness changing with the vertical axis coordinate. is the frequency factor, which is used to adjust the frequency of soil thickness changes. is an exponential decay factor, which is used to affect the rapid decay of soil thickness along the vertical axis. is the first adjustment factor of the dynamic soil thickness model, is an oscillation factor used to capture the periodic variation of soil thickness. is the second adjustment factor of the dynamic soil thickness model; It also includes the calculation model for setting the intersection point between the pier position line and the soil boundary: ， in, For the The pier line and the The coordinates of the intersection of the soil layers, For the The horizontal and vertical coordinates of the pier line, For the The vertical coordinate of the soil layer boundary, is the number of multiple effects, For the The first adjustment factor for this effect is For the The angle of the pier line, For the The second adjustment factor for this effect is For the The angle of the soil layer boundary, For the The third adjustment factor for this effect is For the The fourth adjustment factor for this effect is For the The reference horizontal and vertical coordinates of the pier line.

2. A method for batch extraction of geological information based on CAD drawings as claimed in claim 1, characterized in that: The preprocessing of the geological longitudinal section CAD drawing in step 101 is specifically as follows: adjusting the drawing scales of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through a primitive scaling operation.

3. A method for batch extraction of geological information based on CAD drawings as claimed in claim 1, characterized in that: In step 102, the layer name of the upper boundary of each soil layer is redefined by using the soil layer type number as the name. Specifically, the layer name of the upper boundary of each soil layer is redefined by using the geotechnical category number of the layer of the lower boundary of the soil layer.

4. A method for batch extraction of geological information based on CAD drawings as claimed in claim 1, characterized in that: The calculation of the intersection coordinates of each pier position line and each soil layer boundary line in step 104 is specifically as follows: according to the pier position number sequence, the intersection coordinate values ​​of each vertical pier position line and the soil layer boundary line are calculated in sequence, and the pier position number is used as a unique identifier.

5. A method for batch extraction of geological information based on CAD drawings as claimed in claim 1, characterized in that: Calculating the thickness of each soil layer in step 105 includes: calculating the Y coordinate difference between two upper and lower adjacent intersection points in sequence according to the coordinate values ​​of the intersection points of the pier position line and the boundary lines of each soil layer, to obtain the thickness of each soil layer.

6. A geological information batch extraction system based on CAD drawings, characterized in that: include: Preprocessing module, used to preprocess geological longitudinal section CAD drawings; The redefinition module is used to redefine the layer name of the upper boundary of each soil layer using the geotechnical category number as the name; The module for drawing pier position lines is used to import the formation code table and bridge mileage table and draw pier position lines; The intersection coordinate calculation module is used to calculate the intersection coordinates of each pier position line and each soil layer boundary line; Generate table module, used to calculate the thickness of each soil layer, record the name of the soil layer, and generate a table containing all the pier position stratigraphic data; It also includes setting a dynamic soil thickness model to calculate the dynamic thickness of the soil layer. The dynamic soil thickness model includes: ， in, For the The thickness of the soil layer, For the The vertical coordinates of the upper and lower boundaries of the soil layer, For the The vertical coordinates of the upper and lower boundaries of the soil layer, is the amplitude factor, which is used to control the intensity of the soil layer thickness changing with the vertical axis coordinate. is the frequency factor, which is used to adjust the frequency of soil thickness changes. is an exponential decay factor, which is used to affect the rapid decay of soil thickness along the vertical axis. is the first adjustment factor of the dynamic soil thickness model, is an oscillation factor used to capture the periodic variation of soil thickness. is the second adjustment factor of the dynamic soil thickness model; It also includes the calculation model for setting the intersection point between the pier position line and the soil boundary: ， in, For the The pier line and the The coordinates of the intersection of the soil layers, For the The horizontal and vertical coordinates of the pier line, For the The vertical coordinate of the soil layer boundary, is the number of multiple effects, For the The first adjustment factor for this effect is For the The angle of the pier line, For the The second adjustment factor for this effect is For the The angle of the soil layer boundary, For the The third adjustment factor for this effect is For the The fourth adjustment factor for this effect is For the The reference horizontal and vertical coordinates of the pier line.

7. A geological information batch extraction system based on CAD drawings as claimed in claim 6, characterized in that: The preprocessing module preprocesses the geological longitudinal section CAD drawing specifically by adjusting the drawing scales of the X-axis and the Y-axis of the geological longitudinal section CAD drawing to 1:1 through a primitive scaling operation.

8. A geological information batch extraction system based on CAD drawings as claimed in claim 6, characterized in that: In the redefinition module, the layer name of the upper boundary of each soil layer is redefined using the soil layer type number as the name. Specifically, the layer name of the upper boundary of each soil layer is redefined using the geotechnical category number of the layer of the lower boundary of the soil layer.

9. A geological information batch extraction system based on CAD drawings as claimed in claim 6, characterized in that: The intersection coordinate calculation module calculates the intersection coordinates of each pier position line and each soil layer boundary line in the following way: according to the pier position number sequence, the intersection coordinate values ​​of each vertical pier position line and the soil layer boundary line are calculated in sequence, and the pier position number is used as the unique identifier.

10. A geological information batch extraction system based on CAD drawings as claimed in claim 6, characterized in that: Calculating the thickness of each soil layer in the table generation module includes: calculating the Y coordinate difference between two upper and lower adjacent intersection points in sequence according to the coordinate values ​​of the intersection points of the pier position line and the boundary lines of each soil layer, to obtain the thickness of each soil layer.

Images