CN107797980A - A kind of geological prospecting borehole data processing and control system based on Internet of Things - Google Patents
A kind of geological prospecting borehole data processing and control system based on Internet of Things Download PDFInfo
- Publication number
- CN107797980A CN107797980A CN201711194507.5A CN201711194507A CN107797980A CN 107797980 A CN107797980 A CN 107797980A CN 201711194507 A CN201711194507 A CN 201711194507A CN 107797980 A CN107797980 A CN 107797980A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- things
- internet
- data processing
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)
Abstract
The invention discloses a kind of geological prospecting borehole data processing and control system based on Internet of Things, including central control process module, central control process module connects data processing module, data processing module includes Database Unit, data import unit, data error detection unit and data amendment member, central control process module connects borehole data graph generation module, borehole data graph generation module includes borehole data block diagram automatic mapping module and section drilling perspective view automatic mapping module, central control process module connection data memory module and wireless signal transceiver module, central control process module connects Internet of Things by wireless signal transceiver module, present system is simple, the visualization processing of geological prospecting borehole data can be realized, block diagram displaying and perspective view displaying can be realized, meet present requirement.
Description
Technical field
The present invention relates to a kind of data handling system, specifically a kind of geological prospecting borehole data processing based on Internet of Things
Control system.
Background technology
Borehole data is most basic geologic information, the part that draws a geologic map, the estimation of mine resources amount, mine three-dimensional geologic
Modeling etc. is all as data source, and therefore, foundation is accurate, the bore database of standard is particularly significant.The collection of borehole data, place
Reason with into figure have data volume is big, process is cumbersome, waste time and energy, easily malfunction the characteristics of, brought to traditional manual processing
Very big difficulty.With extensive use of the computer technology in geology field, by CAD replace hand labor oneself into
For inevitable development trend.Since the nineties, occur some data processings and Become the picture software in succession both at home and abroad, it is such as middlely digital
Group release MapG work S softwares, be it is globally unique build formula G work S datas center integrating and developing platform, the system uses face
Design philosophy, multi-tier systematic structure to service, data tissue, the efficient magnanimity for realizing space-oriented entity and its relation are empty
Between data storage and index, large scale Dynamic and Multi dimensional spatial information database, d solid modeling and analysis, it would be preferable to support sea
Amount, distributed NSDI construction, the SURPAC released by GEMCOM (Kingcon) World Mining Industries software company are soft
Part, it is that a geological prospecting information management, the foundation of ore body resource model, mining production planning and the design, mine of being fully integrated is surveyed
The large-scale three dimensional Digital Mine software of the function such as amount and quantities checking computations, scheduling of production establishment.These softwares are in data
Processing and into making great progress in terms of figure, but the data format and geological map obtained and do not meet China's geology row
The specification of industry, it is therefore, imperative using computer development data handling system and automatic mapping software, now with Internet of Things
Development and computer development, the requirement that the visualization processings of geological prospecting borehole data controls is realized and provided preferably
Technology.
The content of the invention
It is an object of the invention to provide a kind of geological prospecting borehole data processing and control system based on Internet of Things, with solution
The problem of being proposed in certainly above-mentioned background technology.
To achieve the above object, the present invention provides following technical scheme：
A kind of geological prospecting borehole data processing and control system based on Internet of Things, including central control process module, center control
Processing module processed connects data processing module, and data processing module includes Database Unit, data import unit, data error detection list
Member and data amendment member, central control process module connect borehole data graph generation module, borehole data graphic hotsopt mould
Block includes borehole data block diagram automatic mapping module and section drilling perspective view automatic mapping module, central control process module
Connection data memory module and wireless signal transceiver module, central control process module pass through wireless signal transceiver module attachment
Networking.
As the further scheme of the present invention：The central control process module is arranged in computer, at central control
Reason module includes multinuclear control processor.
As the further scheme of the present invention：The Database Unit includes data item, data flow, data structure, number
According to storage and five parts of processing procedure.
As the further scheme of the present invention：The Database Unit mainly includes four tables:Bore direction table, deviational survey
Table, geology table and sampling table.
As the further scheme of the present invention：The operational process of the data import unit is：Connect original borehole data
Table, the Sheet tables where data are selected, then the line number scope according to where actual conditions select field in the table, obtain word
The content of section, and shown in list box;Because the field of criteria table (i.e. template file) is the first line number in Excel
According to, obtain template file field, only need to connect standard Excel tables, then normative document field is displayed in list box.By template
File field and initial data field are matched, and are filtered out the field for needing to carry out data importing, are added to " the correspondence of screening
In field " list box.
As the further scheme of the present invention：The data error unit is the standard Excel numbers for importing data to completion
According to debugging is carried out, mistake is included in the tables of data gridiron on system interface, mistake can be changed according to actual conditions, can
Complete Data duplication error checking, the inconsistent error checking of data start-stop depth, data over run error checking and hole termination depth one
The inspection of cause property.
As the further scheme of the present invention：The data modification unit include supplement blank function, delete repeat function,
Angle scaling function and searching data missing function.
As the further scheme of the present invention：The borehole data block diagram automatic mapping module connects including bore database
Connection module, block diagram model customization module and block diagram generation and man-machine interaction editor module.
As the further scheme of the present invention：The borehole data block diagram automatic mapping module also includes block diagram level
Structural model generation module.
As the further scheme of the present invention：The section drilling perspective view automatic mapping module includes database connection mould
Block, drilling track line projection module and addition labeling module and man-machine interaction editor module.
Compared with prior art, the beneficial effects of the invention are as follows：Present system is stable, can realize geological prospecting
The visualization processing of borehole data, block diagram displaying and perspective view displaying can be realized, be provided for geological prospecting work more preferable
Hardware condition, there is great marketing application prospect.
Embodiment
The technical scheme in the embodiment of the present invention will be clearly and completely described below, it is clear that described implementation
Example only part of the embodiment of the present invention, rather than whole embodiments.It is common based on the embodiment in the present invention, this area
The every other embodiment that technical staff is obtained under the premise of creative work is not made, belong to the model that the present invention protects
Enclose.
In the embodiment of the present invention, a kind of geological prospecting borehole data processing and control system based on Internet of Things, including center
Control process module, central control process module connect data processing module, and data processing module includes Database Unit, data
Import unit, data error detection unit and data amendment member, central control process module connect borehole data graph generation module,
Borehole data graph generation module includes borehole data block diagram automatic mapping module and section drilling perspective view automatic mapping mould
Block, central control process module connection data memory module and wireless signal transceiver module, central control process module pass through nothing
Line signal transmitting and receiving module connects Internet of Things, and central control process module is arranged in computer, and central control process module includes
Multinuclear control processor, Database Unit include data item, data flow, data structure, data storage and processing procedure five
Part, Database Unit mainly include four tables:Bore direction table, deviational survey table, geology table and sampling table, data import unit
Operational process is：Original borehole data table is connected, the Sheet tables where data is selected, then selects the table according to actual conditions
Line number scope where middle field, obtains the content of field, and is shown in list box;Due to criteria table (i.e. template text
Part) field be the first row data in Excel, obtain template file field, only need to connect standard Excel tables, then normative document
Field is displayed in list box.Template file field and initial data field are matched, filtering out needs to carry out data
The field of importing, it is added in " corresponding field of screening " list box, data error unit is the standard for importing data to completion
Excel data carry out debugging, mistake are included in the tables of data gridiron on system interface, mistake can be changed according to actual conditions
By mistake, Data duplication error checking, the inconsistent error checking of data start-stop depth, data over run error checking and whole hole can be completed
Depth consistency inspection, data modification unit include supplement blank function, delete repeat function, angle scaling function and search number
According to missing function, borehole data block diagram automatic mapping module includes bore database link block, block diagram model customization mould
Block and block diagram generation also include block diagram level knot with man-machine interaction editor module, borehole data block diagram automatic mapping module
Structure model generation module, section drilling perspective view automatic mapping module include database connection module, drilling track line projection mould
Block and addition labeling module and man-machine interaction editor module.
Present system is stable, can realize the visualization processing of geological prospecting borehole data, can realize column
Figure displaying and perspective view displaying, more preferable hardware condition is provided for geological prospecting work, there is great marketing application
Prospect.
It is obvious to a person skilled in the art that the invention is not restricted to the details of above-mentioned one exemplary embodiment, Er Qie
In the case of without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, embodiment all should be regarded as exemplary, and be nonrestrictive, the scope of the present invention is by appended power
Profit requires rather than described above limits, it is intended that all in the implication and scope of the equivalency of claim by falling
Change is included in the present invention.
Moreover, it will be appreciated that although the present specification is described in terms of embodiments, not each embodiment is only wrapped
Containing an independent technical scheme, this narrating mode of specification is only that those skilled in the art should for clarity
Using specification as an entirety, the technical solutions in the various embodiments may also be suitably combined, forms those skilled in the art
It is appreciated that other embodiment.
Claims (10)
1. a kind of geological prospecting borehole data processing and control system based on Internet of Things, including central control process module, it is special
Sign is that the central control process module connection data processing module, data processing module includes Database Unit, data are led
Enter unit, data error detection unit and data amendment member, central control process module and connect borehole data graph generation module, bore
Hole data graph generation module includes borehole data block diagram automatic mapping module and section drilling perspective view automatic mapping module,
Central control process module connection data memory module and wireless signal transceiver module, central control process module pass through wireless communication
Number transceiver module connection Internet of Things.
2. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The central control process module is arranged in computer, and central control process module includes multinuclear control processor.
3. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The Database Unit includes five data item, data flow, data structure, data storage and processing procedure parts.
4. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The Database Unit mainly includes four tables:Bore direction table, deviational survey table, geology table and sampling table.
5. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The operational process of the data import unit is：Original borehole data table is connected, selects the Sheet tables where data, Ran Hougen
The line number scope in the table where field is selected according to actual conditions, obtains the content of field, and shown in list box;Due to
The field of criteria table (i.e. template file) is the first row data in Excel, obtains template file field, only need to connect standard
Excel tables, then normative document field be displayed in list box, template file field and initial data field are matched,
The field for needing to carry out data importing is filtered out, is added in " corresponding field of screening " list box.
6. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The data error unit is that the standard Excel data for importing data to completion carry out debugging, and mistake is included in system interface
On tables of data gridiron in, can change mistake according to actual conditions, it is deep that Data duplication error checking, data start-stop can be completed
Spend inconsistent error checking, data over run error checking and hole termination depth consistency check.
7. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The data modification unit includes supplement blank function, deletes repeat function, angle scaling function and searching data missing function.
8. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The borehole data block diagram automatic mapping module includes bore database link block, block diagram model customization module and column
Figure generation and man-machine interaction editor module.
9. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, it is characterised in that
The borehole data block diagram automatic mapping module also includes block diagram hierarchy Model generation module.
10. the geological prospecting borehole data processing and control system according to claim 1 based on Internet of Things, its feature exist
In the section drilling perspective view automatic mapping module includes database connection module, drilling track line projection module and addition
Labeling module and man-machine interaction editor module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711194507.5A CN107797980A (en) | 2017-11-24 | 2017-11-24 | A kind of geological prospecting borehole data processing and control system based on Internet of Things |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711194507.5A CN107797980A (en) | 2017-11-24 | 2017-11-24 | A kind of geological prospecting borehole data processing and control system based on Internet of Things |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107797980A true CN107797980A (en) | 2018-03-13 |
Family
ID=61534696
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711194507.5A Pending CN107797980A (en) | 2017-11-24 | 2017-11-24 | A kind of geological prospecting borehole data processing and control system based on Internet of Things |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107797980A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN116166729A (en) * | 2023-02-15 | 2023-05-26 | 中国科学院广州地球化学研究所 | Processing method and device of drilling histogram data, electronic equipment and storage medium |
| CN117743347A (en) * | 2024-02-21 | 2024-03-22 | 中国有色金属工业昆明勘察设计研究院有限公司 | System for storing and utilizing investigation result data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070168133A1 (en) * | 2006-01-13 | 2007-07-19 | Schlumberger Technology Corporation | Computer-based method for while-drilling modeling and visualization of layered subterranean earth formations |
| CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
| CN103714203A (en) * | 2013-12-20 | 2014-04-09 | 柳州腾龙煤电科技股份有限公司 | Drilling histogram automatic mapping method based on CAD template binding technology |
| CN106022560A (en) * | 2016-05-05 | 2016-10-12 | 四川铁安达科技有限公司 | Subway shield segment attitude monitoring and management system based on Internet of Things and cloud computing |
| CN106779417A (en) * | 2016-12-20 | 2017-05-31 | 黄河勘测规划设计有限公司 | The collection of engineering investigation information digitalization, management and integrated application method |
-
2017
- 2017-11-24 CN CN201711194507.5A patent/CN107797980A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070168133A1 (en) * | 2006-01-13 | 2007-07-19 | Schlumberger Technology Corporation | Computer-based method for while-drilling modeling and visualization of layered subterranean earth formations |
| CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
| CN103714203A (en) * | 2013-12-20 | 2014-04-09 | 柳州腾龙煤电科技股份有限公司 | Drilling histogram automatic mapping method based on CAD template binding technology |
| CN106022560A (en) * | 2016-05-05 | 2016-10-12 | 四川铁安达科技有限公司 | Subway shield segment attitude monitoring and management system based on Internet of Things and cloud computing |
| CN106779417A (en) * | 2016-12-20 | 2017-05-31 | 黄河勘测规划设计有限公司 | The collection of engineering investigation information digitalization, management and integrated application method |
Non-Patent Citations (1)
| Title |
|---|
| 彭少龙 等: "《钻孔设计与轨迹动态监控系统研究》", 《探矿工程(岩土钻掘工程)》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN116166729A (en) * | 2023-02-15 | 2023-05-26 | 中国科学院广州地球化学研究所 | Processing method and device of drilling histogram data, electronic equipment and storage medium |
| CN116166729B (en) * | 2023-02-15 | 2023-11-17 | 中国科学院广州地球化学研究所 | Processing method and device of drilling histogram data, electronic equipment and storage medium |
| CN117743347A (en) * | 2024-02-21 | 2024-03-22 | 中国有色金属工业昆明勘察设计研究院有限公司 | System for storing and utilizing investigation result data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108710739A (en) | A kind of Building Information Model lightweight and three-dimensional scenic visualization method and system | |
| CN106779417A (en) | The collection of engineering investigation information digitalization, management and integrated application method | |
| CN105160708B (en) | A kind of engineering geology inside and outside trade integration information system | |
| US8719304B2 (en) | Systems, methods, and graphical tools for representing connectedness of individuals | |
| Walker et al. | StraboSpot data system for structural geology | |
| CN1252625C (en) | Computer-aided geologic investigation system based on portable machine | |
| CN102270137B (en) | Method for acquiring ADL (architecture description language) and modeling tool | |
| CN104899384A (en) | Structural health monitoring visualization system based on Revit | |
| CN103955558A (en) | Method for collecting and processing engineering investigation data of different industries | |
| CN107797980A (en) | A kind of geological prospecting borehole data processing and control system based on Internet of Things | |
| CN112527944A (en) | Method for building spatial semantic database based on BIM and GIS data integration | |
| CN105930460A (en) | Multi-algorithm-integrated big data analysis middleware platform | |
| CN104299270A (en) | Method for establishing three-dimensional geologic model based on database | |
| CN108665543A (en) | Data supervision system is surveyed in coal Digital Mine mountainous region | |
| Strassberg et al. | A geographic data model for representing ground water systems | |
| CN102999610A (en) | Data access system and data access method | |
| CN117076585A (en) | Investigation inside and outside industry integrated system based on three-dimensional geological information model | |
| CN116610380A (en) | SysML model collaborative development system supporting data interoperability of heterogeneous modeling tools | |
| Amirebrahimi et al. | An integrated web-based 3D modeling and visualization platform to support sustainable cities | |
| CN111753000A (en) | Water supply network information system | |
| Pouliot et al. | Development of a Web Geological Feature Server (WGFS) for sharing and querying of 3D objects | |
| Brisaboa et al. | Collecting and publishing large multiscale geographic datasets | |
| Baldissini et al. | An information system for the integration, management and visualization of 3D reality based archaeological models from different operators | |
| Clemen et al. | Site plan for BIM?–A free and open source plug-in for as-is vicinity models to be used in small and medium-sized BIM-projects | |
| Rawat | Interoperable Geo-spatial Data Model in the Context of the Indian NSDI. |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180313 |
|
| WD01 | Invention patent application deemed withdrawn after publication |