CN109165312A - A kind of survey data management system - Google Patents
A kind of survey data management system Download PDFInfo
- Publication number
- CN109165312A CN109165312A CN201810826486.2A CN201810826486A CN109165312A CN 109165312 A CN109165312 A CN 109165312A CN 201810826486 A CN201810826486 A CN 201810826486A CN 109165312 A CN109165312 A CN 109165312A
- Authority
- CN
- China
- Prior art keywords
- data
- point
- management system
- module
- borehole
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/18—Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Geometry (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- General Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention discloses a kind of survey data management system, including borehole data memory module, for accordingly storing the corresponding field in database in corresponding data form after being verified the borehole data inputted by input interface；Query argument input module, for receiving the different query arguments of user's input；Searching module, for finding out the borehole data to match with the query argument in the database；Graphic making module calls AutoCAD software to automatically generate corresponding geologic map using the borehole data inquired, and exports display.The logical data to various exploration drilling acquisitions of the present invention carry out integrating unified management, it is able to achieve and is differently inquired, existing drill hole information in all history engineering project databases can be found in new exploration task, efficiently avoid repeating bore operation.
Description
Technical field
The present invention relates to survey data administrative skill fields, and in particular to a kind of survey data management system.
Background technique
Geological mapping data are regional by force, broad categories, input and output amount is big, working process is sufficiently complex, wherein soil layer
Borehole data be most important data, this data is more original, amount is bigger, more feature, deals with also more complicated, tradition
Engineering prospecting data content it is various, complicated, be unfavorable for that management saves and the later period calls, investigation result normalization information is modern
The inexorable trend developed afterwards.To realize that engineering geologic investigation data is information-based, have to a large amount of engineering geologic investigation data
Effect manages and establishes the digital solution of a set of engineering geology Data management and utilizaition, has great importance.
Summary of the invention
In view of the technical drawbacks of the prior art, it is an object of the present invention to provide one kind be applied to water conservancy industry,
The geological exploration data management system of industry and engineering geological investigation and the management of civil buildings industry etc..
The technical solution adopted to achieve the purpose of the present invention is:
A kind of survey data management system, comprising:
Borehole data memory module, for being accordingly stored after being verified the borehole data inputted by input interface
Corresponding field into database in corresponding data form；
Query argument input module, for receiving the different query arguments of user's input；
Data search module, for finding out the borehole data to match with the query argument in the database；
Graphic making module calls AutoCAD software to automatically generate accordingly using the borehole data inquired
Geologic map, and export display.
The query argument includes:
Coordinate query argument, for inquiring a certain range of drilling point data of one point of distance, the coordinate including the point
The distance of the coordinate value of value and the opposite point；
Polygon query argument, for inquiring a boring point whether in a given plane polygon, including this
The coordinate value of each endpoint of plane polygon and the coordinate value of the boring point；
River levee line query argument, for inquiring the data in the boring point of predetermined river levee line two sides, including the more of river levee line
The coordinate value of two endpoints of a straightway and distance value apart from each straightway.
The data search module includes:
List display module, the borehole data result for will find out generate list display on a display screen.
The geologic map includes engineering geological profile, log sheet, floor plan.
The graphic making module, by loading the Type Library shared library of AutoCAD, utilizes it in production
In function control CAD drawing.
The logical data to various exploration drilling acquisitions of the present invention carry out integrating unified management, realize and carry out by actual demand
Zatacode indexing function, is able to achieve and is differently inquired, and all history engineering projects can be found in new exploration task
Existing drill hole information in database efficiently avoids repeating bore operation.
Detailed description of the invention
Fig. 1 is the theory structure schematic diagram of survey data management system；
Fig. 2 is that point range inquiry calculates schematic diagram；
Fig. 3 is the calculating schematic diagram of polygon range query；
Fig. 4 is calculating schematic diagram of the point of inquiry on specified line segment；
Fig. 5 is that the point of inquiry is not specifying the calculating schematic diagram on line segment；
Fig. 6 is the floor plan that the present invention makes and exports；
Fig. 7 is the pattern diagram that the present invention made and exported histogram；
Fig. 8 is the log sheet that the present invention makes and exports；
Fig. 9 is the engineering geological profile that the present invention makes and exports.
Specific embodiment
The present invention is described in further detail below in conjunction with the drawings and specific embodiments.It should be appreciated that described herein
Specific embodiment be only used to explain the present invention, be not intended to limit the present invention.
Referring to shown in Fig. 1-9, a kind of survey data management system, comprising:
Borehole data memory module, for being accordingly stored after being verified the borehole data inputted by input interface
Corresponding field into database in corresponding data form；
Query argument input module, for receiving the different query arguments of user's input；
Data search module, for finding out the borehole data to match with the query argument in the database；
Graphic making module calls AutoCAD software to automatically generate accordingly using the borehole data inquired
Geologic map, and export display.
Specifically, in input data, it is unified to previous and later all engineering investigation achievement according to fixed format into
Row electronization typing and preservation.Engineering list, drilling list, formation information are such as created in Microsoft Access2000
List, mark pass through test list and sampling 5 borehole data lists of list.User is manually entered hole number from data inputting interface
According to software is by these acquisition information storages to the corresponding field of corresponding database list, and wherein the coordinate information of typing is used for
Inquiry calculates, and other information is used for the Graphing of Engineering of query result.Data check just has been carried out in input interface, has guaranteed typing
The format of data is correct.It is detailed in Fig. 1.
In the present invention, the query argument includes:
Coordinate query argument, for inquiring a certain range of drilling point data of one point of distance, the coordinate including the point
The distance of the coordinate value of value and the opposite point；
Polygon query argument, for inquiring a boring point whether in a given plane polygon, including this
The coordinate value of each endpoint of plane polygon and the coordinate value of the boring point；
River levee line query argument, for inquiring the data in the boring point of predetermined river levee line two sides, including the more of river levee line
The coordinate value of two endpoints of a straightway and distance value apart from each straightway.
Wherein, the data search module includes:
List display module, the borehole data result for will find out generate list display on a display screen.
In the following, being described in detail for above-mentioned querying method as follows:
Inquire and call at any time at work the data needed.Passed through according to the difference of inquiry mode using coordinate parameters
The result that difference is inquired needed for being calculated.
(1) point range is inquired:
This patent midpoint range query method are as follows: first input a coordinate value (Xa, Ya) and radius distance D, then basis
Pythagorean theorem formula(wherein (xb,yb) be database in all coordinate points coordinate
Value) it is calculated as a result, being compared with input radius D, D1It is judged as when≤D in selection range, D1It is not chosen then when > D,
It obtains all qualified coordinate points in database in this way, generates list in case doing subsequent processing, it is shown in Figure 2.
(2) arbitrary polygon range query is pressed:
To realize that user wants that, in given polygon range query, whether this patent is judged a little by mathematical algorithm in polygon
It is interior.For example: a polygon is at will drawn in plane coordinate system, by polygon endpoint be recorded as array (x1, y1,
X2, y2......), a point (Xa, Ya) is at will put, one ray y=Ya of this horizontal bar, (x >=Xa) are then passed through.First
Exclude and with the disjoint side of ray meet y1>Ya>y2, or as y1<y2 that is, as y1>y2 certainly, meet y1<Ya<
Y2 just can be carried out to be calculated in next step.After meeting condition, then pass through mathematical method calculating, the qualified side of how many item and ray
Intersection, if it is odd number, then judging that the point in polygon, is selected；If it is even number, then it is judged as outside polygon,
It is rejected.Some special circumstances are considered in algorithm, are such as surveyed coordinate points when on the boundary of polygon or endpoint, can be also chosen
It takes.Result is generated into list in case doing subsequent processing, referring to shown in Fig. 3-4.
(3) it is inquired by river levee line:
This patent is additionally provided by looping to determine exploration coordinate points to the vertical range of every river levee line segment, i.e., point is to directly
The algorithm of linear distance, come in searching database all exploration coordinate points whether looking within the scope of the river levee linear distance that user gives
Inquiry method.
It is first a string of arrays (x1, y1, x2, y2......) by multiple line segment endpoint coordinate records of bank line, it will
The point of inquiry is recorded as A (Xa, Ya).The straight line side of this line segment can be determined according to adjacent extreme coordinates (x1, y1) (x2, y2)
Journey, then pass through the coordinate (X for the perpendicular intersection B that point A is calculated to linear equationb,Yb).If point B line segment (x1, y1) (x2,
Y2 between), then the distance D for calculating point A and point B is the shortest distance of point A to line segment (x1, y1) (x2, y2)；If point B is not online
Between section (x1, y1) (x2, y2), then point B is calculated separately to the distance of endpoint (x1, y1) and point B to endpoint (x2, y2), is chosen
It is distance D apart from reckling.It is last if D within the allowable range (within the scope of generally 200 meters) if point A be selected, otherwise give up.
It is shown in Figure 5 by result generation list in case doing subsequent processing by circulation.
The present invention by the above various querying methods obtain as a result, can engineering be automatically generated on AutoCAD
Matter sectional view, log sheet, floor plan.
The tool of drawing part equally uses 2015 versions of Visual Basic, the Type of load AutoCAD2017 editions
Library shared library is charted using function control CAD therein.
Floor plan is fairly simple:
Different drilling types, is indicated with different segments.These segments are carried out in advance.When plane is charted, directly
Calling function is connect, segment is inserted into corresponding coordinate position on plane drawing, then puts on drilling number, aperture elevation, drilling
The drill hole informations such as depth, floor plan just complete.It is shown in Figure 6,
Below by taking log sheet as an example:
(1) what a picture frame file is first made, wherein there is indeclinable text, the text for needing to change is framed with " [] ".
(2) CAD program is first opened using function, creates a drawing, picture frame file is inserted into new drawing.
(3) (picture frame coordinate is known) searches for the texts of all bands " [] " within the scope of picture frame, and the text in bracket is
To need the variable name replaced, after reading corresponding value in database, replacement, as shown in Figure 7.
Wherein, the longitudinal content of histogram is arranged in proportion, is converted into figure in proportion according to depth of stratum numerical value
Corresponding information is read in position on paper from database, is added to corresponding position, such as formation information, stratum filling, and mark passes through
With the information of sampling etc..Word segment is directly write, and some segments, filling etc are to carry out in advance, which figure needs just to adjust
It is inserted into corresponding position with function, as shown in Figure 8.
The drawing of engineering geology section is more more complex than histogram.
(1) sectional view is in addition to needing by longitudinal ratio drawing, it is also necessary to chart by grid scale, substantially method and column
Figure drawing is the same.As shown in Figure 9.
(2) for the link problems of ground layer line, the Processing Algorithm of other software is all fairly simple at present, and actual conditions
More complicated, the result by simple algorithm drawing finally will be by manually modifying, though wasting time.By with it is special
Industry cartographer inquires into, and the result of even identical situation, different mapper's hand-drawings also has in personal habits not
Together.In summary two o'clock, ground layer line of the invention have only stayed the end of a thread, and there is no practical connection ground layer lines, and mapper is needed to remove hand
Dynamic connection, had both met the habit of mapper, and had also saved the time of modification.
The invention has the characteristics that:
1, from the point coordinate inquiry being confined in single engineering project, being improved to can be from all history item, according to seat
Cursor position is inquired, and query context is expanded.
2, the diversification of querying method is realized, this patent provides a coordinate inquiry, take polygon as inquiry boundary, into
It is inquired in line range and using river levee line as baseline, carrying out two sides has a variety of querying methods such as inquiry of range.
Digitized processing of the present invention by building library and to engineering project engineering prospecting borehole data is completed, foundation have
The investigation result database of unified stratigraphic sequence, is merged with other electronic data, realizes snap information inquiry exchange, electronics
Archives centralized management provides the dynamic management of technical advice support, engineering prospecting data for basic spatial data handling.
In short, the present invention improves the efficiency of data query by integrated management and recycling to historical summary achievement,
The accuracy of query result is improved, while corresponding any Zhang Changyong can be generated according to result and charted, makes to inquire and make
The operating procedure of figure and operating time are greatly reduced, and reduce the error rate in whole process, while reducing unnecessary
Repeated work reaches and shortens the construction period, and reduces the purpose of cost.
The above is only a preferred embodiment of the present invention, it is noted that for the common skill of the art
For art personnel, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications
Also it should be regarded as protection scope of the present invention.
Claims (5)
1. a kind of survey data management system characterized by comprising
Borehole data memory module, for accordingly storing number after being verified the borehole data inputted by input interface
According to the corresponding field in data form corresponding in library；
Query argument input module, for receiving the different query arguments of user's input；
Data search module, for finding out the borehole data to match with the query argument in the database；
Graphic making module calls AutoCAD software to automatically generate corresponding geology using the borehole data inquired
Figure, and export display.
2. survey data management system as described in claim 1, which is characterized in that the query argument includes:
Coordinate query argument, for inquiring a certain range of drilling point data of one point of distance, the coordinate value including the point with
And the distance of the coordinate value of the opposite point；
Polygon query argument, for inquiring a boring point whether in a given plane polygon, including the plane
The coordinate value of each endpoint of polygon and the coordinate value of the boring point；
River levee line query argument is multiple straight including river levee line for inquiring the data in the boring point of predetermined river levee line two sides
The coordinate value of two endpoints of line segment and distance value apart from each straightway.
3. survey data management system as claimed in claim 2, which is characterized in that the data search module includes:
List display module, the borehole data result for will find out generate list display on a display screen.
4. survey data management system as claimed in claim 2, which is characterized in that the geologic map includes engineering geology section
Figure, log sheet, floor plan.
5. survey data management system as claimed in claim 2, which is characterized in that the graphic making module production when,
By loading the Type Library shared library of AutoCAD, charted using function control CAD therein.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810826486.2A CN109165312A (en) | 2018-07-25 | 2018-07-25 | A kind of survey data management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810826486.2A CN109165312A (en) | 2018-07-25 | 2018-07-25 | A kind of survey data management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109165312A true CN109165312A (en) | 2019-01-08 |
Family
ID=64898035
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810826486.2A Pending CN109165312A (en) | 2018-07-25 | 2018-07-25 | A kind of survey data management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109165312A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112633707A (en) * | 2020-12-25 | 2021-04-09 | 山东省地质矿产勘查开发局第四地质大队(山东省第四地质矿产勘查院) | Engineering geology management system |
| CN113760381A (en) * | 2020-06-04 | 2021-12-07 | 中国石油化工股份有限公司 | Extraction method and system for non-standardized logging lithologic data information |
| CN118115689A (en) * | 2024-04-30 | 2024-05-31 | 自然资源实物地质资料中心 | Three-dimensional modeling system and method based on geological drilling data acquisition technology |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102446214A (en) * | 2011-09-19 | 2012-05-09 | 北京城建勘测设计研究院有限责任公司 | Interior work data processing method used in engineering investigation and device adopting same |
| CN103714203A (en) * | 2013-12-20 | 2014-04-09 | 柳州腾龙煤电科技股份有限公司 | Drilling histogram automatic mapping method based on CAD template binding technology |
| CN103823839A (en) * | 2013-12-20 | 2014-05-28 | 柳州腾龙煤电科技股份有限公司 | AutoCAD symbol configuration showing method based on gallery integration |
| US9395810B2 (en) * | 2013-05-28 | 2016-07-19 | The Boeing Company | Ubiquitous natural user system |
| CN106202156A (en) * | 2016-06-16 | 2016-12-07 | 中山大学 | The log sheet of a kind of sing on web generalized information system generates method online |
| CN106484943A (en) * | 2016-08-23 | 2017-03-08 | 中山大学 | A kind of online generation method of the log sheet based on nonlinear fitting control |
| CN106547941A (en) * | 2016-09-23 | 2017-03-29 | 中冶集团武汉勘察研究院有限公司 | A kind of method that BIM Engineering Exploration Information Systems are built based on revit figure models |
-
2018
- 2018-07-25 CN CN201810826486.2A patent/CN109165312A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102446214A (en) * | 2011-09-19 | 2012-05-09 | 北京城建勘测设计研究院有限责任公司 | Interior work data processing method used in engineering investigation and device adopting same |
| US9395810B2 (en) * | 2013-05-28 | 2016-07-19 | The Boeing Company | Ubiquitous natural user system |
| CN103714203A (en) * | 2013-12-20 | 2014-04-09 | 柳州腾龙煤电科技股份有限公司 | Drilling histogram automatic mapping method based on CAD template binding technology |
| CN103823839A (en) * | 2013-12-20 | 2014-05-28 | 柳州腾龙煤电科技股份有限公司 | AutoCAD symbol configuration showing method based on gallery integration |
| CN106202156A (en) * | 2016-06-16 | 2016-12-07 | 中山大学 | The log sheet of a kind of sing on web generalized information system generates method online |
| CN106484943A (en) * | 2016-08-23 | 2017-03-08 | 中山大学 | A kind of online generation method of the log sheet based on nonlinear fitting control |
| CN106547941A (en) * | 2016-09-23 | 2017-03-29 | 中冶集团武汉勘察研究院有限公司 | A kind of method that BIM Engineering Exploration Information Systems are built based on revit figure models |
Non-Patent Citations (1)
| Title |
|---|
| 蔡红英: "Visual Basic在AutoCAD平台的二次开发——创建钻孔数据库及钻孔自动绘制", 《矿山测量》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113760381A (en) * | 2020-06-04 | 2021-12-07 | 中国石油化工股份有限公司 | Extraction method and system for non-standardized logging lithologic data information |
| CN112633707A (en) * | 2020-12-25 | 2021-04-09 | 山东省地质矿产勘查开发局第四地质大队(山东省第四地质矿产勘查院) | Engineering geology management system |
| CN118115689A (en) * | 2024-04-30 | 2024-05-31 | 自然资源实物地质资料中心 | Three-dimensional modeling system and method based on geological drilling data acquisition technology |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Bisdom et al. | Calibrating discrete fracture-network models with a carbonate three-dimensional outcrop fracture network: Implications for naturally fractured reservoir modeling | |
| Caers | History matching under training-image-based geological model constraints | |
| US9684084B2 (en) | Three-dimensional multi-modal core and geological modeling for optimal field development | |
| US20200040719A1 (en) | Machine-Learning Based Drilling Models for A New Well | |
| CN104850732B (en) | One kind is based on the statistical oil reservoir detail stratigraphic division method and device of sand body | |
| US10510167B2 (en) | Geological formation and log visualization | |
| US20100114544A1 (en) | Three Dimensional Well Block Radius Determiner Machine And Related Computer Implemented Methods And Program Products | |
| US10385658B2 (en) | In-situ wellbore, core and cuttings information system | |
| Lia et al. | Uncertainties in reservoir production forecasts | |
| Suzuki et al. | History matching with an uncertain geological scenario | |
| US11269110B2 (en) | Computing system assessment of geological similarity of wells employing well-log data | |
| CN102089677A (en) | Well log normalization | |
| CN109165312A (en) | A kind of survey data management system | |
| CN106154322A (en) | Log curve correction method and apparatus | |
| Harris et al. | Online beach profile management and analysis system (PMAS) | |
| US11156740B2 (en) | Electrofacies determination | |
| CN113420348B (en) | Method for rapidly drawing uranium mine exploration line profile map | |
| Tran et al. | Direct geostatistical simulation with multiscale well, seismic, and production data | |
| US8255816B2 (en) | Modifying a magnified field model | |
| CN111767662B (en) | Method and device for correcting azimuth information of single sand body of oil reservoir | |
| US11280922B2 (en) | Structural volume segmentation | |
| Singh et al. | Building a Model for Reservoir Characterisation in GIS Using Machine Learning | |
| CN117992554A (en) | Uranium ore profile drawing auxiliary method | |
| Abed et al. | A dynamic multiwell data base | |
| US10890065B2 (en) | Well infiltration area calculation using logging while drilling data |
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 | ||
| CB02 | Change of applicant information |
Address after: 300204 No. 217 Racecourse Road, Tianjin, Hexi District Applicant after: Tianjin Water Planning Survey and Design Co., Ltd Address before: 300204 No. 217 Racecourse Road, Tianjin, Hexi District Applicant before: TIANJIN WATER RESOURCES SURVEY AND DESIGN INSTITUTE |
|
| CB02 | Change of applicant information |