CN115205886A - Method and device for extracting borehole stratum information, electronic equipment and storage medium - Google Patents

Method and device for extracting borehole stratum information, electronic equipment and storage medium Download PDF

Info

Publication number
CN115205886A
CN115205886A CN202210827693.6A CN202210827693A CN115205886A CN 115205886 A CN115205886 A CN 115205886A CN 202210827693 A CN202210827693 A CN 202210827693A CN 115205886 A CN115205886 A CN 115205886A
Authority
CN
China
Prior art keywords
stratum
information
drilling
graphic
configuration information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210827693.6A
Other languages
Chinese (zh)
Inventor
高源�
苏东升
李薇
杨国平
商剑平
段一峰
崔峰
高鑫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Water Transport Planning And Design Co ltd
Original Assignee
Water Transport Planning And Design Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Water Transport Planning And Design Co ltd filed Critical Water Transport Planning And Design Co ltd
Priority to CN202210827693.6A priority Critical patent/CN115205886A/en
Publication of CN115205886A publication Critical patent/CN115205886A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
    • G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
    • G06V30/40—Document-oriented image-based pattern recognition
    • G06V30/42—Document-oriented image-based pattern recognition based on the type of document
    • G06V30/422—Technical drawings; Geographical maps
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
    • G06V10/00—Arrangements for image or video recognition or understanding
    • G06V10/70—Arrangements for image or video recognition or understanding using pattern recognition or machine learning
    • G06V10/764—Arrangements for image or video recognition or understanding using pattern recognition or machine learning using classification, e.g. of video objects
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
    • G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
    • G06V30/10—Character recognition
    • G06V30/14—Image acquisition
    • G06V30/148—Segmentation of character regions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
    • G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
    • G06V30/10—Character recognition
    • G06V30/19—Recognition using electronic means
    • G06V30/191—Design or setup of recognition systems or techniques; Extraction of features in feature space; Clustering techniques; Blind source separation
    • G06V30/19153—Design or setup of recognition systems or techniques; Extraction of features in feature space; Clustering techniques; Blind source separation using rules for classification or partitioning the feature space

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Multimedia (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Artificial Intelligence (AREA)
  • Evolutionary Computation (AREA)
  • Medical Informatics (AREA)
  • Software Systems (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • Computing Systems (AREA)
  • Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)

Abstract

The invention discloses a method and a device for extracting borehole stratum information, electronic equipment and a storage medium. Wherein, the method comprises the following steps: reading all graphic elements in the drawing file, and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: a picture frame set; extracting graphic elements in the picture frame set and configuration information of related graphic elements in the picture frame configuration information set, wherein the picture frame configuration information set comprises a plurality of configuration information, and the configuration information comprises relative position coordinates of the drilling map information in the drilling map; and extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain the drilling information and the stratum information. The invention solves the technical problems of long time consumption and low efficiency in the related technology by manually reading drawing information and manually inputting drilling stratum information.

Description

Method and device for extracting borehole stratum information, electronic equipment and storage medium
Technical Field
The invention relates to the field of information processing, in particular to a method and a device for extracting borehole stratum information, electronic equipment and a storage medium.
Background
In the field of engineering design and engineering exploration, a large amount of engineering information is displayed through a drilling histogram, and currently, with the help of a BIM (building information model) technology, some auxiliary design software realize the functions of creating a three-dimensional geological model, excavating and filling engineering quantity statistics, automatically generating a geological profile, automatically generating the drilling histogram and the like based on drilling stratum information, so that the design efficiency of engineering designers is greatly improved, and the quality of design results is improved.
When the engineering designer designs by using the BIM auxiliary software, the drilling stratum information needs to be sorted and imported according to a data interface provided by the software. Therefore, collating borehole formation information is an important preparatory task for planning.
In the related art, when the borehole stratum information is acquired, a designer needs to manually read the borehole histogram and then manually input the borehole stratum information, and the technical means for extracting the borehole stratum information takes a long time and is low in efficiency.
From the perspective of identifying drawing information, the possibility exists that some prior art schemes are applied to identifying information in a drilling histogram, for example, an image character identification model is designed based on a convolutional neural network, and title bar information and labeled dimension information in engineering drawings are mainly extracted; or, by reading the information in the DXF file, a knowledge-based understanding strategy and geometric constraint identification method is provided, a specific algorithm is adopted to identify the wall surface, and then other components are identified according to the constraint, so that the reading, identification and reconstruction of the 3D model from the DXF file are realized.
However, the above drawing identification scheme has a plurality of significant disadvantages:
1. when the number of the drilled holes is small, the requirements of construction period and efficiency can be met reluctantly by adopting a manual input method. However, when the number of drilled holes is large, the design period is short, and the design quality is guaranteed, the manual data input mode is not satisfactory.
2. By adopting the image character recognition method, the recognition accuracy is difficult to ensure, and a great deal of effort is required to correct the information accuracy; in addition, the information in the drilling histogram is complex, such as the situations of framing of the drilling histogram, cross-layer description of stratum and the like, and compared with the conventional table information such as picture frame information and the like, the regularity is much worse, and the difficulty is increased for image and character recognition.
3. The method for reading and identifying DXF file information has the problem of proposing an algorithm aiming at specific services. Reading, identifying, converting and organizing the information in the file into service information in order are the key points that the method can be used for solving the practical problems. The algorithm is obviously only suitable for identifying the wall surface, and further identifying other components such as doors and windows.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a method and a device for extracting drilling stratum information, electronic equipment and a storage medium, which at least solve the technical problems that in the related art, a long time is needed and the efficiency is low in a mode of manually inputting the drilling stratum information by manually reading drawing information.
According to an aspect of the embodiments of the present invention, there is provided a method for extracting borehole formation information, including: reading all graphic elements in a drawing file, and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: a picture frame set; extracting a graphic element in the drawing frame set and configuration information related to the graphic element in the drawing frame configuration information set, wherein the drawing frame configuration information set comprises a plurality of configuration information, and the configuration information comprises relative position coordinates of drilling drawing information in a drilling drawing; and extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain drilling information and stratum information.
Optionally, the step of extracting borehole map information associated with the element sequence number of the graphic element to obtain borehole information and formation information includes: extracting world coordinates of a lower left corner point of the picture frame block; calculating the world coordinate range of each drilling graphic element in the drilling graphic element set by combining the world coordinates of the lower left corner point of the picture frame block and the configuration information, wherein the drilling graphic element set comprises drilling graphic elements of at least one of the following components: drilling hole number, hole opening elevation and hole opening coordinates; inquiring the drilling graphic elements positioned in the world coordinate range of the drilling graphic elements in the picture frame set to obtain the element coordinate value of each drilling graphic element; determining the drilling information based on the element coordinate values of each of the drilling graphic elements.
Optionally, the element classification result further includes: the stratum numbering block set is used for extracting drilling map information associated with the element serial numbers of the graphic elements to obtain drilling information and stratum information, and the method further comprises the following steps: extracting world coordinates of a left lower corner point of the picture frame block; and calculating the world coordinate range of each stratum graphic element in a stratum graphic element set by combining the world coordinates of the left lower corner point of the picture frame block and the configuration information, wherein the stratum graphic element set comprises at least one stratum graphic element selected from the following stratum graphic elements: stratum number, age cause, stratum layer height, standard penetration number, rock-soil name and rock-soil characteristic; traversing the stratum number block set, and inquiring all stratum graphic elements within the world coordinate range of the stratum number to obtain the element coordinate value of each stratum graphic element; and determining the stratum information based on the element coordinate value of each stratum graphic element.
Optionally, the element classification result further includes: the stratum number ellipse set further comprises, after traversing the stratum number block set: if the number block element is not found in the stratum number block set, traversing the stratum number ellipse set to obtain all ellipse elements; and converting the inquired ellipse elements into the stratum numbers.
Optionally, the element classification result further includes: the text element set further comprises, after traversing the stratum number block set: traversing the character element set, and respectively finding all character elements related to the stratum layer height, the standard penetration number, the rock and soil name and the rock and soil characteristics in the stratum graphic element set; and converting the text elements into numerical values or text descriptions corresponding to the stratum graphic elements.
Optionally, the element classification result further includes: a set of line elements, further comprising, after traversing the set of line elements: traversing the line element set, finding the line element information about the epoch cause in the stratum graphic element set, and obtaining the number and height of the epoch cause; and determining the incidence relation between the stratum and the epoch cause according to the epoch cause layer number, the layer height and the stratum layer number.
Optionally, after determining the association relationship between the formation and the epoch cause, further comprising: if the same stratum is distributed in different borehole images, determining that a soil layer cross-image conclusion exists; or, if any stratum parameter is not marked on the parting line of the bottom of the layer, wherein the stratum parameter is one of the following: determining that a soil layer cross map conclusion exists according to the layer bottom elevation, the layer bottom depth and the layering thickness; and under the condition that the conclusion that the soil layer cross map exists is determined, deleting the data of the corresponding deepest soil layer in the extracted stratum graphic element set, the stratum number, the era cause, the rock and soil name and the rock and soil characteristics.
According to another aspect of the embodiments of the present invention, there is also provided an apparatus for extracting information of a borehole, including: the reading unit is used for reading all graphic elements in the drawing file and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following components: a picture frame set; a first extraction unit, configured to extract a graphic element in the frame set and configuration information associated with the graphic element in a frame configuration information set, where the frame configuration information set includes a plurality of configuration information, and the configuration information includes a relative position coordinate of drill hole map information in a drill hole map; and the second extraction unit is used for extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain the drilling information and the stratum information.
Optionally, the second extraction unit includes: the first extraction module is used for extracting world coordinates of a left lower corner point of the picture frame block; a first calculation module, configured to calculate, in combination with the world coordinates of the lower left corner of the frame block and the configuration information, a world coordinate range of each drilling graphic element in a drilling graphic element set, where the drilling graphic element set includes drilling graphic elements of at least one of: drilling hole number, hole elevation and hole coordinate; the first determining module is used for inquiring the drilling graphic elements positioned in the world coordinate range of the drilling graphic elements in the drawing frame set to obtain the element coordinate value of each drilling graphic element; a second determination module for determining the drilling information based on the element coordinate values of each of the drilling graphic elements.
Optionally, the element classification result further includes: the second extraction unit further includes: the second extraction module is used for extracting world coordinates of the lower left corner of the picture frame block; a second calculating module, configured to calculate, by combining the world coordinates of the lower left corner of the frame block and the configuration information, a world coordinate range of each stratum graphic element in a stratum graphic element set, where the stratum graphic element set includes at least one of the following stratum graphic elements: stratum number, age cause, stratum layer height, standard penetration number, rock-soil name and rock-soil characteristics; the first traversal module is used for traversing the stratum number block set, inquiring all stratum graphic elements within the world coordinate range of the stratum number, and obtaining the element coordinate value of each stratum graphic element; and the third determining module is used for determining the stratum information based on the element coordinate value of each stratum graphic element.
Optionally, the element classification result further includes: the oval set of stratum serial number, the extraction element of drilling stratum information still includes: the second traversal module is used for traversing the stratum numbering block set to obtain all the ellipse elements if the number block elements in the stratum numbering block set are not found; and the first conversion module is used for converting the inquired ellipse elements into the stratum numbers.
Optionally, the element classification result further includes: the extraction element of characters element set, drilling stratum information still includes: a third traversing module, configured to traverse the text element set after traversing the stratum numbering block set, and find all text elements related to the stratum layer height, the standard penetration number, the rock-soil name, and the rock-soil feature in the stratum graphic element set respectively; and the second conversion module is used for converting the text elements into numerical values or text descriptions corresponding to the stratum graphic elements.
Optionally, the element classification result further includes: the line element set, the extraction element of the stratum information of drilling still includes: the fourth traversal module is used for traversing the line element set after traversing the line element set, finding the line element information about the epoch cause in the stratum graphic element set, and obtaining the number of layers and the height of the epoch cause; and the fourth determining module is used for determining the incidence relation between the stratum and the epoch cause according to the epoch cause layer number, the layer height and the stratum layer number.
Optionally, the device for extracting information of the borehole formation further comprises: the fifth determining module is used for determining that a soil layer cross-map conclusion exists if the same stratum is distributed in different drilling maps after determining the incidence relation between the stratum and the time cause; or, if any stratum parameter is not marked on the parting line of the bottom of the stratum, wherein the stratum parameter is one of the following parameters: determining that a soil layer cross map conclusion exists according to the layer bottom elevation, the layer bottom depth and the layering thickness; and the deleting module is used for deleting the data of the corresponding deepest soil layer in the extracted stratum graphic element set, the stratum number, the era cause, the rock and soil name and the rock and soil characteristics under the condition of determining that a soil layer cross-map conclusion exists.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the method of extracting borehole formation information of any one of the above via execution of the executable instructions.
According to another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium, which includes a stored computer program, wherein when the computer program runs, the apparatus where the computer-readable storage medium is located is controlled to execute any one of the above-mentioned methods for extracting borehole formation information.
In the invention, all graphic elements in the drawing file can be read and classified to obtain an element classification result, wherein the element classification result at least comprises the following steps: and the picture frame set extracts graphic elements in the picture frame set and configuration information of associated graphic elements in the picture frame configuration information set, wherein the picture frame configuration information set comprises a plurality of configuration information, the configuration information comprises relative position coordinates of the drilling graph information in the drilling graph, and the drilling graph information associated with the element serial numbers of the graphic elements is extracted by combining the graphic elements and the corresponding configuration information to obtain the drilling information and the stratum information. According to the drilling information and stratum information recognition method, the drilling stratum information in the drilling histogram can be automatically recognized in batches by extracting the graphic elements in the drawing frame set and the configuration information of the associated graphic elements in the drawing frame configuration information set, then combining the graphic elements and the corresponding configuration information, and extracting the drilling graph information associated with the element serial numbers of the graphic elements to obtain the drilling information and the stratum information, so that the technical problems that in the related art, the long time is needed and the efficiency is low due to the mode that the drawing information is manually read and the drilling stratum information is manually input are solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a schematic illustration of an alternative borehole histogram in accordance with an embodiment of the invention;
FIG. 2 is a flow chart of an alternative method of extracting borehole formation information in accordance with an embodiment of the present invention;
FIG. 3 is a flow chart for automatically identifying borehole formation information in a borehole histogram in accordance with an embodiment of the present invention;
FIG. 4 is a flow chart of an alternative method of extracting borehole information according to an embodiment of the present invention;
FIG. 5 is a flow chart of an alternative method of reading formation information in accordance with an embodiment of the present invention;
FIG. 6 is a schematic diagram of an alternative borehole formation information extraction apparatus according to an embodiment of the present invention;
fig. 7 is a block diagram of a hardware structure of an electronic device (or a mobile device) of a method for extracting borehole formation information according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Moreover, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
To facilitate understanding of the invention by those skilled in the art, some terms or nouns referred to in the embodiments of the invention are explained below:
a Building Information Model (BIM) is a computer aided design mainly based on three-dimensional graphics, object guidance and architecture.
The drilling histogram can describe the stratigraphy, thickness, lithology, structural configuration and contact relation, drilling structure and other conditions of a drilling hole penetrating through rock strata, and is an important basis for analyzing engineering geological conditions and drawing a geological section diagram. The method can be used as a basic tool for visualizing underground exploration information and plays an important role in analysis and decision of various projects.
The geological profile map is a composition member reflecting the stratum structure and rock mass attribute characteristics, is an intuitive and effective expression mode of the stratum in the vertical direction, and can intuitively display the stratum structure information, the stratum attribute information, the stratum structure type and the deposition rule obtained by engineering geological survey.
The invention can be applied to various software/systems/products for identifying the information of the drilling stratum in the drilling histogram, or applied to the Building Information Model (BIM)/engineering drawing software, and the drilling histogram drawn by the invention can contain the information of the drilling geographic position, the stratum label, the stratum height, the era cause, the rock and soil name and the characteristics thereof, the standard penetration number and the like.
It should be noted that, the applicable scenarios of the present invention include but are not limited to: excavation and filling design, structural section analysis, water transport engineering (including but not limited to geological exploration, berth state exploration and water level state exploration), municipal engineering and the like. For example, in the excavation and filling design, the method is used for determining excavation quantities of different soil qualities in a layering mode; in structural profile drawings, adjacent borehole histograms need to be inserted to show the geology near the profile.
It should be noted that the technical solution of the present invention can solve the following problems:
1. the problem of low efficiency of manual arrangement of the drilling stratum information is solved;
2. the problem that the identification accuracy is difficult to guarantee is solved, and the identification result can be directly applied to engineering design.
3. The method solves the problem of identifying the missing of the drilling histogram algorithm, and establishes a technical scheme for automatically identifying the drilling stratum information in the drilling histogram.
By solving the problems, the drilling stratum information can be quickly and accurately extracted from the drilling histogram automatically in batches so as to carry out subsequent engineering design.
FIG. 1 is a schematic diagram of an alternative drill hole histogram according to an embodiment of the invention, as shown in FIG. 1, a drill hole histogram frame includes a plurality of blocks: project number (e.g., 1-20113002-1), project name (e.g., ". The universal berth of an engineered geological survey work area"), drill number (e.g., ETS-C1), bore elevation (m), bore diameter (mm), coordinates, start date, completion date, water at rest (m), formation number, epoch cause, sub-sea elevation (m), sub-sea depth (m), sub-sea thickness (m), bar graph, geotechnical name and its features, penetration number, project responsibility, graph number, etc. The method can also comprise the following steps: sampling, measuring water level date, auditors and the like.
In the present invention, several features of the borehole histogram are provided:
1. the frame of the borehole histogram is drawn in blocks, which include: drilling coordinates, project names, orifice elevations (or orifice elevations) and the like.
2. The names of the box blocks may be named in the form of 'block + number'.
3. Borehole formation numbering exists in two forms: 1) Exist in block form, the name is named in the form of 'Dcbh + number'; 2) Exist in the form of '2 characters +1 circle', and the 2 characters are respectively a main number and a secondary number.
4. The time cause is "one-to-many case".
5. Multiple bore maps may be generated for a single bore, and multiple pages may be required because the information on the bore maps may be more.
6. The same formation may be distributed over different borehole histograms.
7. The layer bottom elevation, the layer bottom depth and the layer thickness are only marked on the parting line of the layer bottom.
8. The geotechnical name and the characteristics of one soil layer can cause the description to occupy the space of other layers by crossing layers due to too many descriptors or insufficient layer height.
9. For the stratum with cross-map, the rock soil name and the characteristics thereof can be marked on each map, which is different from the marks of the layer bottom elevation, the layer bottom depth and the layered thickness.
10. The labeling of the penetration number has no relation with the layer number distribution, and no one-to-one correspondence exists.
11. The different stratums are divided in straight lines. This segmentation characteristic is not always applicable to the era cause, rock name and its features, penetration number.
And identifying and extracting the information in the drilling histogram by adopting a drilling stratum information extraction method based on a plurality of characteristics of the drilling histogram.
The present invention will be described in detail with reference to examples.
Example one
In accordance with an embodiment of the present invention, there is provided an embodiment of a method for extracting formation information from a borehole, it being noted that the steps illustrated in the flowchart of the drawings may be carried out in a computer system such as a set of computer-executable instructions, and that while a logical order is illustrated in the flowchart, in some cases, the steps illustrated or described may be carried out in an order different than presented herein.
Fig. 2 is a flow chart of an alternative method for extracting borehole formation information according to an embodiment of the present invention, as shown in fig. 2, the method comprising the steps of:
step S202, reading all graphic elements in the drawing file, and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: a picture frame set;
step S204, extracting graphic elements in a picture frame set and configuration information of related graphic elements in the picture frame configuration information set, wherein the picture frame configuration information set comprises a plurality of configuration information, and the configuration information comprises relative position coordinates of drilling map information in a drilling map;
and step S206, extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain drilling information and stratum information.
Through the steps, all the graphic elements in the drawing file can be read, and all the graphic elements are classified to obtain an element classification result, wherein the element classification result at least comprises the following steps: and the picture frame set extracts graphic elements in the picture frame set and configuration information of associated graphic elements in the picture frame configuration information set, wherein the picture frame configuration information set comprises a plurality of configuration information, the configuration information comprises relative position coordinates of the drill hole map information in the drill hole map, and the drill hole map information associated with the element serial numbers of the graphic elements is extracted by combining the graphic elements and the corresponding configuration information to obtain the drill hole information and the stratum information. In the embodiment, the drilling information and the stratum information in the drilling histogram can be automatically and massively identified by extracting the graphic elements in the frame set and the configuration information of the associated graphic elements in the frame configuration information set and then extracting the drilling map information associated with the element serial numbers of the graphic elements by combining the graphic elements and the corresponding configuration information, so that the technical problems of long time consumption and low efficiency in a mode of manually reading the drawing information and manually inputting the drilling stratum information in the related art are solved.
The present invention will be described in detail below with reference to the above-described embodiments.
Step S202, reading all graphic elements in the drawing file, and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: a collection of frames.
It should be noted that the drawing file in the present embodiment may be a CAD drawing or other software drawing (e.g., microstation).
By reading all graphic elements in the drilling drawing file, five types of element sets can be extracted: drawing frame set, stratum numbering block set, stratum numbering ellipse set, character set and line set.
After extracting the graphic elements and classifying the graphic elements to obtain element classification results, judging whether one element is a picture frame or not, and utilizing the characteristics 1 of the drilling histogram: "the frame of the drilling histogram is drawn in blocks", and feature 2: "the name of a block of a frame may be named in the form of 'block + number', and if the graphic element is a block and the block name contains 'block', the element is a frame". When determining whether a stratum element is a stratum number, the above-mentioned 3: "borehole formation numbering exists in two forms: 1) Exist in block form, the name is named in the form of 'Dcbh + number'; 2) Exist in the form of '2 characters +1 circle ', and the 2 characters are respectively a main number and a secondary number '. If the element is a block and the block name contains "Dcbh", then the element is a stratigraphic number. And when judging whether one element is an ellipse, a character or a line, using the corresponding element type.
Step S204, extracting the graphic elements in the picture frame set and the configuration information of the related graphic elements in the picture frame configuration information set, wherein the picture frame configuration information set comprises a plurality of configuration information, and the configuration information comprises the relative position coordinates of the drilling map information in the drilling map.
The drilling drawing information can be extracted by respectively extracting all graphic elements contained in the drawing frame set and combining drawing frame configuration information, and when the drilling drawing information is specifically extracted, a first element in the drawing frame set and first configuration information in the drawing frame configuration information set can be extracted firstly, and the first drilling drawing information is read. Wherein the frame configuration information is a set of relative position coordinates of the drill hole map information in the drill hole map.
The frame configuration information is schematically illustrated by table 1 below.
TABLE 1 frame configuration information
Figure BDA0003747130130000091
Figure BDA0003747130130000101
Figure BDA0003747130130000111
A complete frame configuration would include all the information listed in table 1, where each margin is measured with reference to the leftmost line of the drill histogram and the top and bottom margins with reference to the lowest transverse line; the left margin refers to the closest distance from the leftmost vertical line of the drilling histogram in the boundary line of the picture frame elements; the right margin is the farthest distance from the leftmost vertical line of the drilling histogram in the picture frame element boundary line; the bottom edge distance refers to the closest distance from the lowest transverse line of the drilling histogram in the boundary line of the picture frame elements; the top edge distance refers to the farthest distance from the lowest vertical line of the drilling histogram in the boundary line of the picture frame elements. Of course, in the actual information extraction process, other edge lines may also be used as the measurement reference boundary line, so as to determine the information boundary line of each graphic element.
It should be noted that the frame configuration information set in this embodiment includes configuration information of a common frame, and may be dynamically supplemented as needed.
Optionally, the frame configuration information set of this embodiment may be stored in a plurality of file formats, for example, in a word file format, a PDF file format, a picture file format, and an XML file format, and preferably, information is stored in an XML format file.
And step S206, extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain the drilling information and the stratum information.
The extracted five types of element sets are combined respectively as follows: drawing frame set, stratum numbering block set, stratum numbering ellipse set, character set and line set, and the extraction of each graphic element information and configuration information is explained in detail.
For the element extraction of the drawing frame set, optionally, the step of extracting drill hole map information associated with the element serial number of the graphic element to obtain drill hole information and formation information includes: extracting world coordinates of a left lower corner point of the picture frame block; calculating the world coordinate range of each drilling graphic element in the drilling graphic element set by combining the world coordinates and the configuration information of the left lower corner point of the picture frame block, wherein the drilling graphic element set comprises at least one drilling graphic element of the following parts: drilling hole number, hole elevation and hole coordinate; inquiring the drilling graphic elements within the world coordinate range of the drilling graphic elements in the picture frame set to obtain the element coordinate value of each drilling graphic element; based on the element coordinate values of each of the drill hole figure elements, drill hole information is determined.
It should be noted that the drilling information (including the drilling number, the elevation of the hole, the XY coordinates of the hole) in this embodiment is contained in a block of frames, and the block is a set of multiple elements, so that the set of elements needs to be extracted first, and the drilling information needs to be found in the set. And extracting world (absolute) coordinates of the left lower corner point of the picture frame block, and then calculating the world coordinate Range (Range) of the drilling hole number, the hole elevation and the hole coordinate according to the picture frame configuration information. When determining the relative coordinate system and the coordinate value of each graphic element in the picture frame set, the sitting corner of the picture frame is taken as the origin of the coordinate system, and the world coordinate range of each drilling graphic element in the drilling graphic element set is calculated by combining the world coordinate and the configuration information of the left lower corner of the picture frame block.
In this embodiment, the frame configuration information may be equivalent to the relative coordinates, and the frame sitting corner coordinates are added to obtain the coordinate range where the corresponding information is located. Taking the aperture coordinate X as an example, assuming that the coordinates of the BOTTOM LEFT corner of the frame are (X0, y 0), and the four edges of the aperture coordinate X are Xleft, ybottom, xright, and Ytop (corresponding to drilpositionox _ LEFT, drilpositionox _ BOTTOM, drilpositionox _ RIGHT, and drilpositionox _ TOP in the configuration file one by one), the range of the aperture coordinate X may be represented by two coordinate points, which are (X0 + Xleft, y0+ ybottot), (X0 + Xright, and y0+ Ytop), respectively. Next, elements within the orifice coordinate X range are found in the set of elements and attempted to be converted to coordinate values. Until all the information is found, success can be returned; otherwise, when all the information is not acquired after all the child elements are traversed, failure is returned. If the return fails, the current frame configuration information is not matched with the identified frame block, at this moment, the next piece of configuration information is acquired, and the step is continuously repeated. And if the drilling information is successfully read, carrying out the next step.
For the extraction of elements from the stratum number block set, optionally, the element classification result further includes: the stratum numbering block set is used for extracting drilling map information associated with the element serial numbers of the graphic elements to obtain drilling information and stratum information, and the method further comprises the following steps: extracting world coordinates of a left lower corner point of the picture frame block; and calculating the world coordinate range of each stratum graphic element in the stratum graphic element set by combining the world coordinates and the configuration information of the lower left corner point of the picture frame block, wherein the stratum graphic element set comprises at least one stratum graphic element of the following components: stratum number, age cause, stratum layer height, standard penetration number, rock-soil name and rock-soil characteristic; traversing the stratum number block set, and inquiring all stratum graphic elements in the world coordinate range of the stratum number to obtain the element coordinate value of each stratum graphic element; and determining formation information based on the element coordinate value of each formation graphic element.
In this embodiment, the world coordinates of the lower left corner of the frame block may be extracted, and then the world coordinate ranges (Range) of the stratum number column, the epoch cause column, the stratum layer height column, the standard penetration number column, the rock name and the feature column thereof may be obtained according to the frame configuration information. And traversing the stratum number block set to find all stratum graphic elements within the stratum number column range.
For the extraction of the elements of the stratum number ellipse set, optionally, the element classification result further includes: the stratum number ellipse set further comprises, after traversing the stratum number block set: if the element located in the numbering block is not found in the stratum numbering block set, traversing the stratum numbering ellipse set to obtain all ellipse elements; and converting the inquired ellipse elements into stratum numbers.
In this embodiment, if no number block element located in the range of the formation number column is found, the ellipse set is traversed to find all the ellipse elements located in the column, and then the found number block or ellipse element is converted into a number.
For the element extraction of the text element set, optionally, the element classification result further includes: the text element set further comprises, after traversing the stratum number block set: traversing the character element set, and respectively finding out all character elements related to stratum height, penetration number, rock-soil name and rock-soil characteristics in the stratum graphic element set; and converting the text elements into numerical values or text descriptions of the corresponding stratum graphic elements.
In this embodiment, the text element set may be traversed to find all text elements located in the range of the formation level high column, the penetration number column, the rock-soil name, and the feature column thereof, and then the found text elements are converted into corresponding numerical values or text descriptions.
For the element extraction of the line element set, optionally, the element classification result further includes: the line element set further comprises, after traversing the line element set: traversing the line element set, finding out line element information about the epoch cause in the stratum graphic element set, and obtaining the number of layers and the layer height of the epoch cause; and determining the incidence relation between the stratum and the epoch cause according to the number of the epoch cause, the layer height and the number of the stratum layers.
In this embodiment, the line element set may be traversed to find all line elements located within the epoch cause column range, thereby determining the number and height of epoch cause layers. Then, the character element set is traversed, and the characters are converted into the time cause description.
Optionally, after determining the association relationship between the stratum and the epoch cause, the method further includes: if the same stratum is distributed in different borehole images, determining that a soil layer cross-image conclusion exists; or, if any stratum parameter is not marked on the parting line of the bottom of the stratum, wherein the stratum parameter is one of the following parameters: determining that a soil layer cross map conclusion exists according to the layer bottom elevation, the layer bottom depth and the layering thickness; and under the condition that the conclusion that the soil layer crosses the map is determined, deleting data about the stratum number, the age cause, the rock and soil name and the corresponding deepest soil layer in the rock and soil characteristics in the extracted stratum graphic element set.
In this embodiment, a possible one-to-many relationship between the stratum and the era cause can be determined according to the number of the era cause, the layer height, and the number of the stratum layers, and if the same stratum is distributed in different drilling drawings, the situation that the soil layer is over-drawing is indicated, and the data of the extracted stratum number, the era cause, the rock name, and the characteristics corresponding to the deepest soil layer are deleted.
Through the embodiment, the drilling stratum information in the drilling histogram can be automatically identified, and the drawing frame configuration information is stored by adopting the xml file, so that different drawing frame configuration information can be dynamically expanded.
The invention is described in detail below with reference to alternative embodiments.
FIG. 3 is a flow chart for automatically identifying borehole formation information in a borehole histogram, as shown in FIG. 3, including:
first, reading all the graphic elements in the drilling cad file (corresponding to the drawing file of the above embodiment), and extracting five types of element sets from the graphic elements: drawing frame set, stratum numbering block set, stratum numbering ellipse set, character set and line set. The above features 1 and 2 can be used when determining whether an element is a frame, and if the element is a block and the block name includes 'block', the element is a frame. The above feature 3 can be used when judging whether or not a stratum element is a stratum number, and if the element is a block and the block name contains 'Dcbh', the element is a stratum number. When judging whether an element is an ellipse, a character or a line, the element type is utilized.
And secondly, reading the first element in the picture frame set and the first configuration information in the picture frame configuration information set to read the first drill picture information. The frame configuration information is a set of relative position coordinates of the borehole map information in the borehole map.
And thirdly, judging whether the drilling information is read successfully or not.
The drilling information (including the drilling number, the elevation of the hole, the coordinates of the hole XY) is contained in a block of frames, and the block is a set of a plurality of elements, so that the set of elements needs to be extracted first.
Fig. 4 is a flow chart of an alternative method for extracting borehole information according to an embodiment of the present invention, as shown in fig. 4, including: extracting a sub-element set of the read picture frame block, and searching drilling information in the set; extracting world coordinates of a left lower corner point of the picture frame block, and then calculating a drilling hole number, a hole opening elevation and a world coordinate Range (Range) of the hole opening coordinates according to picture frame configuration information; removing a first element in the set of child elements; judging whether the element type is a character or not; if yes, calculating whether the character element is located in the orifice number, the orifice elevation and the world coordinate range (range) of the orifice coordinate, and if not, acquiring the next element; and for the condition that the character elements are located in the orifice number, the orifice elevation and the world coordinate range (range) of the orifice coordinate, attempting to convert the characters into corresponding information, then acquiring the next element, judging whether the elements are not empty and not all information is not acquired, if so, continuing to execute the step of judging whether the elements are the characters, if not, judging whether all required information is acquired, if so, returning to be successful, and if not, returning to be failed.
In this embodiment, the frame configuration information may be equivalent to the relative coordinates, and the frame sitting corner coordinates are added to obtain the coordinate range where the corresponding information is located. Still taking the aperture coordinate X as an example, assuming that the coordinates of the BOTTOM LEFT corner of the frame are (X0, y 0), and the four edges of the aperture coordinate X are Xleft, ybottom, xright, and Ytop (corresponding to drilpositionx _ LEFT, drilpositionx _ BOTTOM, drilpositionx _ RIGHT, and drilpositionx _ TOP in the configuration file one by one), the range of the aperture coordinate X may be represented by two coordinate points, which are (X0 + Xleft, y0+ ybottot), (X0 + Xright, and y0+ Ytop), respectively. Next, elements within the orifice coordinate X range are found in the set of elements and attempted to be converted to coordinate values. Success can be returned until all information is found; otherwise, when all the information is not acquired after all the child elements are traversed, failure is returned. If the return fails, it indicates that the current frame configuration information does not match the identified frame block, and at this time, the next piece of configuration information should be obtained, and the step is repeated. And if the drilling information is successfully read, carrying out the next step.
And fourthly, judging whether the stratum information is successfully read.
The world coordinates of the lower left corner of the picture frame block are extracted, and then the world coordinate ranges (Range) of the stratum number column, the era cause column, the stratum layer height column, the standard penetration number column, the rock and soil name and the characteristic column thereof are calculated according to the picture frame configuration information. And traversing the stratum number block set to find all elements within the range of the stratum number column. If no numbered block element in the column is found, the ellipse set is traversed to find all ellipse elements in the column. The found numbering blocks or ellipse elements are converted into numbers. And traversing the character element set to respectively find all character elements positioned in the stratum high column range, the standard penetration number column, the rock and soil name and the characteristic column thereof. And converting the found text elements into corresponding numerical values or text descriptions. And traversing the line element set to find all the line elements in the epoch cause column range, thereby determining the epoch cause layer number and the epoch cause layer height. Then, the character element set is traversed, and the characters are converted into the time cause description.
FIG. 5 is a flow chart of an alternative method of reading formation information, according to an embodiment of the invention, FIG. 5 includes: traversing a stratum number block set, a character element set, a line element set, extracting a stratum number (N1), an epoch cause (N2), a layer height (N3), a standard penetration number sequence (N4), rock and soil names and characteristics (N5) thereof, wherein N1, N2, N3, N4 and N5 represent the number of extraction; then judging whether N1, N2, N3, N4 and N5 are all 0; if yes, directly returning to fail; if not, then judge N1! = N3 or N5! And if so, judging whether N1= = N3, if so, judging whether N1-N3 are equal to 1, if so, deleting the extracted data of the deepest soil layer in the stratum number, the era cause, the rock and soil name and the characteristics, and otherwise, returning to failure.
That is, in the present embodiment, the one-to-many relationship (the aforementioned feature 4) that may exist between the formation and the occurrence factor is determined based on the number of the occurrence factor layers, the layer height, and the number of the formation layers, and for example, N1-N5 is the number of pieces of information extracted, and the corresponding relationship is the formation number (N1), the occurrence factor (N2), the layer height (N3), the number of punctuation (N4), the rock name, and the feature (N5) thereof. If N1, N2, N3, N4 and N5 are all 0, returning failure; otherwise, if N1! = N3 or N5! And = N3, the situation that the soil layer crosses the map is illustrated (which can be proved by using the characteristics 6 and 7), at this time, if N1-N3 are equal to 1, the extracted stratum number, the era cause, the rock and soil name and the data of the deepest soil layer in the characteristics are deleted, and otherwise, failure is returned. Finally, judge N1! = N3 or N5! = N3, if the result is negative, the success is returned; otherwise, failure is returned. And if the returning fails, the current picture frame configuration information is not matched with the identified picture frame block, the next piece of configuration information is obtained at the moment, the third step to the fourth step are continuously repeated to extract stratum information, and if the stratum information is successfully read, the next step is carried out.
And fifthly, circularly reading the information of the drilling strata of other histograms in the file according to the current configuration information.
And if the drilling stratum information is successfully read, the matching of the current picture frame configuration information is proved. And extracting all drilling histogram information according to the picture frame information.
The automatic identification drilling histogram algorithm provided by the embodiment can realize batch identification of information of a plurality of drilling histograms and 1 minute identification of hundreds of drilling histograms, and solves the problem of low efficiency of manual arrangement of drilling stratum information.
Meanwhile, the embodiment can dynamically expand different frame information in a mode of storing frame configuration information by an xml file, so that the algorithm has strong universality.
The invention is described below in connection with an alternative embodiment.
Example two
The embodiment provides an extraction device of borehole stratum information, which comprises a plurality of implementation units, wherein each implementation unit corresponds to each implementation step in the first embodiment.
Fig. 6 is a schematic diagram of an alternative apparatus for extracting borehole formation information according to an embodiment of the present invention, as shown in fig. 6, the apparatus may include: a reading unit 61, a first extraction unit 63, a second extraction unit 65, wherein,
the reading unit 61 is configured to read all graphic elements in the drawing file, and classify all the graphic elements to obtain an element classification result, where the element classification result at least includes: a picture frame set;
a first extracting unit 63, configured to extract a graphic element in the frame set and configuration information of an associated graphic element in the frame configuration information set, where the frame configuration information set includes a plurality of configuration information, and the configuration information includes a relative position coordinate of the drill hole map information in the drill hole map;
and a second extracting unit 65, configured to extract, in combination with the graphic element and the corresponding configuration information, drilling map information associated with the element number of the graphic element, so as to obtain drilling information and formation information.
The device for extracting the borehole stratum information can read all graphic elements in the drawing file through the reading unit 61, and classify all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: and the picture frame set extracts a graphic element in the picture frame set and configuration information of an associated graphic element in the picture frame configuration information set through a first extraction unit 63, wherein the picture frame configuration information set comprises a plurality of configuration information, the configuration information comprises relative position coordinates of the drill hole map information in the drill hole map, and the drill hole map information associated with the element serial number of the graphic element is extracted through a second extraction unit 65 by combining the graphic element and the corresponding configuration information to obtain the drill hole information and the stratum information. In the embodiment, the drilling information and the stratum information in the drilling histogram can be automatically and massively identified by extracting the graphic elements in the frame set and the configuration information of the associated graphic elements in the frame configuration information set and then extracting the drilling map information associated with the element serial numbers of the graphic elements by combining the graphic elements and the corresponding configuration information, so that the technical problems of long time consumption and low efficiency in a mode of manually reading the drawing information and manually inputting the drilling stratum information in the related art are solved.
Optionally, the second extracting unit includes: the first extraction module is used for extracting world coordinates of a left lower corner point of the picture frame block; the first calculation module is used for calculating the world coordinate range of each drilling graphic element in the drilling graphic element set by combining the world coordinates and the configuration information of the lower left corner point of the frame block, wherein the drilling graphic element set comprises at least one drilling graphic element of the following: drilling hole number, hole elevation and hole coordinate; the first determining module is used for inquiring the drilling graphic elements within the world coordinate range of the drilling graphic elements in the picture frame set to obtain the element coordinate value of each drilling graphic element; a second determination module for determining drilling information based on the element coordinate values of each drilling graphical element.
Optionally, the element classification result further includes: the second extracting unit further includes: the second extraction module is used for extracting world coordinates of the lower left corner of the picture frame block; the second calculation module is used for calculating the world coordinate range of each stratum graphic element in the stratum graphic element set by combining the world coordinates and the configuration information of the lower left corner point of the picture frame block, wherein the stratum graphic element set comprises at least one stratum graphic element of the following stratum graphic elements: stratum number, age cause, stratum layer height, standard penetration number, rock-soil name and rock-soil characteristic; the first traversal module is used for traversing the stratum number block set, inquiring all stratum graphic elements within the world coordinate range of the stratum number, and obtaining the element coordinate value of each stratum graphic element; and the third determining module is used for determining the stratum information based on the element coordinate value of each stratum graphic element.
Optionally, the element classification result further includes: the oval set of stratum serial number, the extraction element of drilling stratum information still includes: the second traversal module is used for traversing the stratum numbering block set to obtain all the ellipse elements if the number block elements in the stratum numbering block set are not found; and the first conversion module is used for converting the inquired ellipse elements into stratum numbers.
Optionally, the element classification result further includes: the extraction element of characters element set, drilling stratum information still includes: the third traversal module is used for traversing the character element set after traversing the stratum numbering block set, and respectively finding all character elements related to stratum height, standard penetration number, rock and soil name and rock and soil characteristics in the stratum graphic element set; and the second conversion module is used for converting the text elements into numerical values or text descriptions of the corresponding stratum graphic elements.
Optionally, the element classification result further includes: the line element set, the extraction element of the stratum information of drilling still includes: the fourth traversal module is used for traversing the line element set after traversing the line element set, finding the line element information about the epoch cause in the stratum graphic element set and obtaining the number and height of the epoch cause; and the fourth determining module is used for determining the incidence relation between the stratum and the age cause according to the number of age cause layers, the layer height and the number of stratum layers.
Optionally, the device for extracting information of a borehole formation further includes: the fifth determining module is used for determining that a conclusion that the soil layer crosses the map exists if the same stratum is distributed in different drilling maps after determining the incidence relation between the stratum and the time cause; or, if any stratum parameter is not marked on the parting line of the bottom of the stratum, wherein the stratum parameter is one of the following parameters: determining the conclusion that the soil layer crosses the map if the layer bottom elevation, the layer bottom depth and the layering thickness are high; and the deleting module is used for deleting data of the corresponding deepest soil layer in the stratum number, the time cause, the rock and soil name and the rock and soil characteristics in the extracted stratum graphic element set under the condition of determining that the soil layer cross-map conclusion exists.
The extraction device of the borehole formation information may further include a processor and a memory, the reading unit 61, the first extraction unit 63, the second extraction unit 65, and the like are all stored in the memory as program units, and the processor executes the program units stored in the memory to implement corresponding functions.
The processor comprises a kernel, and the kernel calls a corresponding program unit from the memory. The kernel can be set to be one or more than one, and drilling map information associated with the element serial number of the graphic element is extracted by adjusting the kernel parameters to combine the graphic element and the corresponding configuration information, so as to obtain the drilling information and the stratum information.
The memory may include volatile memory in a computer readable medium, random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions for the processor; wherein the processor is configured to perform any of the above-described methods of extraction of borehole formation information via execution of executable instructions.
According to another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium, which includes a stored computer program, wherein when the computer program runs, the apparatus where the computer-readable storage medium is located is controlled to execute any one of the above-mentioned methods for extracting borehole formation information.
The present application further provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device: reading all graphic elements in the drawing file, and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: a picture frame set; extracting the graphic elements in the picture frame set and the configuration information of the related graphic elements in the picture frame configuration information set, wherein the picture frame configuration information set comprises a plurality of configuration information, and the configuration information comprises the relative position coordinates of the drill hole drawing information in the drill hole drawing; and extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain the drilling information and the stratum information.
Fig. 7 is a block diagram of a hardware structure of an electronic device (or a mobile device) of a method for extracting borehole formation information according to an embodiment of the present invention. As shown in fig. 7, the electronic device may include one or more (shown as 702a, 702b, \8230;, 702 n) processors 702 (the processors 702 may include, but are not limited to, processing devices such as microprocessor MCUs or programmable logic devices FPGAs), memory 704 for storing data. In addition, the method can also comprise the following steps: a display, an input/output interface (I/O interface), a Universal Serial Bus (USB) port (which may be included as one of the ports of the I/O interface), a network interface, a keyboard, a power supply, and/or a camera. It will be understood by those skilled in the art that the structure shown in fig. 7 is only an illustration and is not intended to limit the structure of the electronic device. For example, the electronic device may also include more or fewer components than shown in FIG. 7, or have a different configuration than shown in FIG. 7.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described apparatus embodiments are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or may not be executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention, which is substantially or partly contributed by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims (10)

1. A method for extracting borehole stratum information is characterized by comprising the following steps:
reading all graphic elements in a drawing file, and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following steps: a picture frame set;
extracting a graphic element in the drawing frame set and configuration information related to the graphic element in a drawing frame configuration information set, wherein the drawing frame configuration information set comprises a plurality of configuration information, and the configuration information comprises relative position coordinates of the drilling drawing information in the drilling drawing;
and extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain drilling information and stratum information.
2. The extraction method according to claim 1, wherein the step of extracting borehole map information associated with the element numbers of the graphic elements to obtain borehole information and formation information comprises:
extracting world coordinates of a left lower corner point of the picture frame block;
calculating the world coordinate range of each drilling graphic element in the drilling graphic element set by combining the world coordinates of the lower left corner point of the frame block and the configuration information, wherein the drilling graphic element set comprises drilling graphic elements of at least one of the following components: drilling hole number, hole elevation and hole coordinate;
inquiring the drilling graphic elements positioned in the world coordinate range of the drilling graphic elements in the picture frame set to obtain the element coordinate value of each drilling graphic element;
determining the drilling information based on the element coordinate values of each of the drilling graphical elements.
3. The extraction method according to claim 1, wherein the element classification result further comprises: the stratum numbering block set is used for extracting drilling map information associated with the element serial numbers of the graphic elements to obtain drilling information and stratum information, and the method further comprises the following steps:
extracting world coordinates of a left lower corner point of the picture frame block;
and calculating the world coordinate range of each stratum graphic element in a stratum graphic element set by combining the world coordinates of the lower left corner point of the picture frame block and the configuration information, wherein the stratum graphic element set comprises at least one stratum graphic element of the following stratum graphic elements: stratum number, age cause, stratum layer height, standard penetration number, rock-soil name and rock-soil characteristic;
traversing the stratum number block set, and inquiring all stratum graphic elements within the world coordinate range of the stratum number to obtain the element coordinate value of each stratum graphic element;
and determining the stratum information based on the element coordinate value of each stratum graphic element.
4. The extraction method according to claim 3, wherein the element classification result further comprises: a set of stratigraphic number ellipses, further comprising, after traversing the set of stratigraphic number blocks:
if the number block element is not found in the stratum number block set, traversing the stratum number ellipse set to obtain all ellipse elements;
and converting the inquired ellipse elements into the stratum numbers.
5. The extraction method according to claim 3, wherein the element classification result further comprises: the text element set further comprises, after traversing the stratum number block set:
traversing the character element set, and respectively finding all character elements related to the stratum layer height, the standard penetration number, the rock-soil name and the rock-soil feature in the stratum graphic element set;
and converting the text elements into numerical values or text descriptions corresponding to the stratum graphic elements.
6. The extraction method according to claim 5, wherein the element classification result further comprises: a set of line elements, further comprising, after traversing the set of line elements:
traversing the line element set, finding the line element information about the epoch cause in the stratum graphic element set, and obtaining the number and height of the epoch cause;
and determining the incidence relation between the stratum and the epoch cause according to the epoch cause number, the layer height and the stratum number.
7. The extraction method according to claim 6, further comprising, after determining the correlation between the formation and the temporal cause:
if the same stratum is distributed in different borehole images, determining that a soil layer cross-image conclusion exists; or,
if any stratum parameter is not marked on the parting line of the bottom of the layer, wherein the stratum parameter is one of the following parameters: determining that a soil layer cross map conclusion exists according to the layer bottom elevation, the layer bottom depth and the layering thickness;
and under the condition that the conclusion that the soil layer cross map exists is determined, deleting the data of the corresponding deepest soil layer in the extracted stratum graphic element set, the stratum number, the era cause, the rock and soil name and the rock and soil characteristics.
8. An extraction device for borehole formation information, comprising:
the reading unit is used for reading all graphic elements in the drawing file and classifying all the graphic elements to obtain an element classification result, wherein the element classification result at least comprises the following components: a picture frame set;
the first extraction unit is used for extracting graphic elements in the drawing frame set and configuration information related to the graphic elements in the drawing frame configuration information set, wherein the drawing frame configuration information set comprises a plurality of configuration information, and the configuration information comprises relative position coordinates of drilling map information in a drilling map;
and the second extraction unit is used for extracting the drilling map information associated with the element serial number of the graphic element by combining the graphic element and the corresponding configuration information to obtain the drilling information and the stratum information.
9. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the method of extracting borehole formation information of any one of claims 1 to 7 via execution of the executable instructions.
10. A computer-readable storage medium comprising a stored computer program, wherein the computer program when executed controls an apparatus in which the computer-readable storage medium is located to perform the method for extracting borehole formation information according to any one of claims 1 to 7.
CN202210827693.6A 2022-07-14 2022-07-14 Method and device for extracting borehole stratum information, electronic equipment and storage medium Pending CN115205886A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210827693.6A CN115205886A (en) 2022-07-14 2022-07-14 Method and device for extracting borehole stratum information, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210827693.6A CN115205886A (en) 2022-07-14 2022-07-14 Method and device for extracting borehole stratum information, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115205886A true CN115205886A (en) 2022-10-18

Family

ID=83582998

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210827693.6A Pending CN115205886A (en) 2022-07-14 2022-07-14 Method and device for extracting borehole stratum information, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115205886A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117251739A (en) * 2023-11-17 2023-12-19 核工业北京地质研究院 Construction method of sample set for sandstone uranium resource quantitative prediction

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2008033875A (en) * 2006-07-03 2008-02-14 Bigvan Inc Layering program of cad drawing data, recording medium and device therefor, and layering system therefor, and cad drawing reference data checking device
CN103345540A (en) * 2013-05-27 2013-10-09 华东师范大学 Method for stimulating and displaying geological drilling information on digital earth software platform
CN110209630A (en) * 2019-04-25 2019-09-06 广东联城住工装备信息科技有限公司 DXF file information processing method, device, computer equipment and storage medium
CN111274626A (en) * 2020-02-25 2020-06-12 山东省交通规划设计院有限公司 Engineering investigation data processing system
CN113626546A (en) * 2021-06-16 2021-11-09 中国铁路设计集团有限公司 Railway bridge geological graph digital storage and application method

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2008033875A (en) * 2006-07-03 2008-02-14 Bigvan Inc Layering program of cad drawing data, recording medium and device therefor, and layering system therefor, and cad drawing reference data checking device
CN103345540A (en) * 2013-05-27 2013-10-09 华东师范大学 Method for stimulating and displaying geological drilling information on digital earth software platform
CN110209630A (en) * 2019-04-25 2019-09-06 广东联城住工装备信息科技有限公司 DXF file information processing method, device, computer equipment and storage medium
CN111274626A (en) * 2020-02-25 2020-06-12 山东省交通规划设计院有限公司 Engineering investigation data processing system
CN113626546A (en) * 2021-06-16 2021-11-09 中国铁路设计集团有限公司 Railway bridge geological graph digital storage and application method

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117251739A (en) * 2023-11-17 2023-12-19 核工业北京地质研究院 Construction method of sample set for sandstone uranium resource quantitative prediction
CN117251739B (en) * 2023-11-17 2024-01-30 核工业北京地质研究院 Construction method of sample set for sandstone uranium resource quantitative prediction

Similar Documents

Publication Publication Date Title
US8666149B2 (en) Method for editing a multi-point facies simulation
CN106355627A (en) Method and system used for generating knowledge graphs
CN104620136A (en) Hybrid method of combining multipoint statistic and object-based methods for creating reservoir property models
CN111950051A (en) BIM-based three-dimensional geological modeling and geological model-based construction application method
CN104915521A (en) Drilling histogram compilation method based on field documentation data and automatic cartographic generalization
CN111950046B (en) Drilling data model construction method based on BIM
CN113434623A (en) Fusion method based on multi-source heterogeneous space planning data
CN104077447A (en) Urban three-dimensional space vector modeling method based on paper plane data
CN103955558A (en) Method for collecting and processing engineering investigation data of different industries
CN111583407B (en) Efficient three-dimensional geological modeling intelligent processing method based on paper drilling
CN107180452A (en) The stratified geological objects modeling method of the multi-source data coupling on the stratum containing standard
CN106202156A (en) The log sheet of a kind of sing on web generalized information system generates method online
CN103797382A (en) Method and system of subsurface horizon assignment
CN115205886A (en) Method and device for extracting borehole stratum information, electronic equipment and storage medium
CN103714203A (en) Drilling histogram automatic mapping method based on CAD template binding technology
CN112199886A (en) Processing method of PRB data deep learning geological map prediction model
Zhiliang et al. Construction of carbonate reservoir knowledge base and its application in fracture-cavity reservoir geological modeling
CN110826393A (en) Efficient automatic extraction method for drilling histogram information
CN114386504A (en) Engineering drawing character recognition method
CN116894915A (en) Artificial intelligence semi-automatic three-dimensional geological modeling data processing method
CN114898057B (en) Geological profile three-dimensional space information extraction method and device and storage medium
CN115374198A (en) Urban global data processing method and device
CN115035258A (en) Efficient urban three-dimensional geological modeling method based on CAD (computer-aided design) drilling histogram
CN108805154A (en) A kind of geological fault recognition methods based on space clustering
CN114114390B (en) Oil and gas exploration method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20221018

RJ01 Rejection of invention patent application after publication