CN110807023B - Survey management and data intelligent analysis system and method based on GIS - Google Patents
Survey management and data intelligent analysis system and method based on GIS Download PDFInfo
- Publication number
- CN110807023B CN110807023B CN201911088143.1A CN201911088143A CN110807023B CN 110807023 B CN110807023 B CN 110807023B CN 201911088143 A CN201911088143 A CN 201911088143A CN 110807023 B CN110807023 B CN 110807023B
- Authority
- CN
- China
- Prior art keywords
- data
- information
- management
- database
- project
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
Abstract
The present disclosure provides a survey management and data intelligent analysis system and method based on GIS, comprising a data management end, which imports the latest geotechnical engineering survey data into a database; the server is communicated with the database, and the server forms a two-dimensional graph by mass geological information; the data management end builds a database, analyzes the data file format of the geotechnical investigation data, realizes the inspection and data import of the geotechnical investigation data, and imports the investigation data into the database in batches; and the Web desktop terminal is deployed on the server in a B/S mode, and queries, retrieves and counts geotechnical engineering investigation data stored in the server in various forms through a browser. The method and the system regularly import the latest engineering survey data into the system database so as to ensure the normal updating of the data in the system and facilitate all personnel to see the latest results in time.
Description
Technical Field
The disclosure relates to the technical field of survey design, in particular to a survey management and data intelligent analysis system and method based on GIS.
Background
On the basis that the existing geotechnical engineering survey data inside and outside the province are collected and collated by professionals, a survey management and data intelligent analysis system based on the GIS utilizes the GIS technology to establish an open and dynamic geological information platform, combs the existing survey data, establishes a unified geotechnical engineering survey database standard, gradually completes the database building work of the past geological survey result data, realizes the standardized design of a spatial database, and completes the warehousing and query of the data, some basic analysis functions, flow management and the like on the basis.
The current geological survey related data presents the following technical problems in use:
1. the early stage of the engineering is generally completed by means of site survey and data collection, and how to efficiently and accurately collect early data is very critical, so that the subjective difference of the site survey is large and the data collection degree is not uniform due to the influence of personal work experience, working capacity and cognition of engineering personnel.
2. The survey data volume is big and categorised, deposit and be miscellaneous, and the retrieval inquiry of data is mainly manual, does not have systematicness, and efficiency is lower. Taking Shandong electric power engineering consulting institute as an example, nearly 3000 construction projects of various types and more than 20000 drilling holes have been completed since the Shandong institute was built, but most of project investigation results (before 2006) are stored in a file room by paper documents, retrieval and inquiry of data all depend on manual filing, and the work benefit is very low.
3. The traditional management mode has no power for more and more data, and can not fully reflect the knowledge value of engineering data, and especially can not start the integrated analysis of comprehensive survey information in a large-scale area. Along with the rapid development of city construction, especially the tightening of big data construction and informatization construction advocated from the national level in China at present, the content of engineering investigation work is continuously expanded, the information retrieval requirement on engineering investigation is continuously improved, and the limitation and the deficiency of the management mode of the traditional paper archives and manual filing are increasingly reflected.
4. The existing geological survey related data has low utilization rate, large professional barriers, dispersed forms and no unified classification storage mode, provides guidance and reference value for project early planning and design and subsequent engineering design and investigation, does not explore the advantages of big data, and cannot provide powerful and reliable basis for regional geological features and empirical formulas.
Disclosure of Invention
The invention aims to provide a survey management and data intelligent analysis system based on a GIS (geographic information system), which is used for regularly importing latest engineering survey data into a system database so as to ensure the normal updating of the data in the system and bring convenience for all personnel to see the latest results in time.
The invention provides a survey management and data intelligent analysis system based on a GIS, which specifically comprises:
the data management end is used for importing the latest geotechnical engineering survey data into a database;
the server is communicated with the database, and the server forms a two-dimensional graph by mass geological information;
the data management end builds a database, analyzes the data file format of the geotechnical investigation data, realizes the inspection and data import of the geotechnical investigation data, and imports the investigation data into the database in batch;
and the Web desktop terminal is deployed on the server in a B/S mode, and queries, retrieves and counts geotechnical engineering investigation data stored in the server in various forms through a browser.
The technical scheme is further that the system comprises a mobile terminal, the server is connected to the internet through one-way network gate physical isolation, the mobile terminal is connected to the internet, data in the server are checked through the mobile terminal, and meanwhile field data are uploaded through the mobile terminal.
According to the further technical scheme, for an 80-coordinate system and longitude and latitude in geotechnical engineering survey data, a coordinate conversion method is used for converting the drilling coordinates in batches, and the matching of the drilling data and the online map coordinates is realized.
In a further technical scheme, the result graph in the ArcGIS format, including the plane graph, is imported into a spatial database for management, so that front-end display and query are facilitated.
The further technical scheme is that the original archives of the engineering project and the inventory lists of other achievement reports are put in storage, so that online query and retrieval are facilitated.
According to the further technical scheme, when the server processes the data, the coordinate data in the database are associated with the online map, and the related data are displayed on the map.
According to a further technical scheme, the map display related data comprises the following steps:
displaying the project and the drilling layer according to different scale precisions;
drawing a frame, drawing a line or drawing a polygon on a map, inquiring basic information of a project, basic information of a drill hole and fracture structure information in multiple modes;
inquiring related project information, drilling information and result report information according to the project name, the project number and the address basic information;
and according to the designated area, carrying out statistical calculation on the geotechnical test indexes in the area.
Further technical solution, the mobile terminal includes:
a user authentication interface: the system is used for user login verification and is unified with a desktop end user;
the spatial data release related interface: the method is used for displaying and inquiring the drilling data and the drawing data;
drilling data query correlation interface: the method is used for inquiring drilling data, related geotechnical tests and in-situ test data;
data query correlation interface: the function module is used for inquiring and downloading data;
a system management interface: for other functions of the system, including system setup.
Further technical scheme, the mobile terminal realizes:
displaying an online map: displaying an online map based on ArcGIS mobile terminal development;
and (3) information query: inquiring related drilling basic information, project information and fracture information by acquiring the real-time position of a user or the designated position of the user;
uploading the field photos: according to the actual situation of the field, photographing, uploading the description to a server after the description is filled in, and automatically recording the uploading time and coordinate information by the mobile terminal;
surveying data: related project information, achievement report information and the like are inquired according to the project name, the project number and the address basic information, and an achievement report can be checked;
and (3) detailed information query: and viewing and browsing the concerned report according to the query result.
The invention provides a survey management and data intelligent analysis method based on a GIS, which specifically comprises the following steps:
importing the latest geotechnical engineering investigation data into a database;
forming a two-dimensional graph by using mass geological information;
when the database is built, analyzing the data file format of the geotechnical investigation data, realizing the inspection and data import of the geotechnical investigation data, and importing the geotechnical investigation data into the database in batches;
and querying, retrieving and counting the geotechnical engineering investigation data stored in the server in various forms through a browser.
Compared with the prior art, the beneficial effect of this disclosure is:
the method provides a feasible design and implementation method of a detailed database structure design mode, a server data management mode, a survey data format analysis mode, drilling coordinate conversion, process management information, achievement drawing warehousing, data directory information warehousing and the like. The professional can use the program to regularly import the latest engineering survey data into the system database so as to ensure the normal updating of the data in the system and bring convenience to all the personnel to see the latest results in time.
The GIS-based survey management and data intelligent analysis system and method developed by means of computer technology, information technology, database technology and graphic visualization technology can solve the contradiction that the traditional archive management mode is difficult to adapt to the current working requirement, provide guidance and reference for project early-stage planning and design and subsequent engineering design and survey, and provide a powerful and reliable basis for summarizing regional geological features and empirical formulas.
The survey management and data intelligent analysis system and method based on the GIS utilizes the powerful functions of the GIS to visually display relevant data information of survey, rock and soil, geology and the like on a map, realizes data sharing and cooperative operation, and has the functions of browsing, analyzing, inquiring and the like. The use of this platform can improve staff's efficiency greatly, for the enterprise uses manpower and materials resources sparingly, also has certain help to the accuracy of reconnaissance design result. Through preliminary exploration and research on the application of the GIS system in the field of geotechnical engineering, the GIS system can provide beneficial reference for informatization management and reutilization of data in the field of geotechnical engineering. The research, development and trial results of the system show that the platform is stable in performance, the working efficiency of technical personnel is greatly improved, and meanwhile resources are saved for enterprises.
Drawings
The accompanying drawings, which are included to provide a further understanding of the disclosure, illustrate embodiments of the disclosure and together with the description serve to explain the disclosure and are not to be construed as limiting the disclosure.
FIG. 1 is a GIS-based geotechnical engineering information system operation overall operation architecture of an embodiment of the present disclosure;
FIG. 2 is a schematic diagram of an Oracle database structure according to an embodiment of the present disclosure;
FIG. 3 is a diagram illustrating a system shortcut query in accordance with an exemplary embodiment of the present disclosure;
FIG. 4 is a schematic diagram of a system space query according to an exemplary embodiment of the disclosure;
FIG. 5 is a schematic diagram of a system buffer analysis query according to an exemplary embodiment of the present disclosure;
fig. 6 (a) -6 (d) are schematic diagrams of the system mobile terminal function interface according to the embodiment of the disclosure.
Detailed Description
It should be noted that the following detailed description is exemplary and is intended to provide further explanation of the disclosure. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs.
It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of example embodiments according to the present disclosure. As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, and it should be understood that when the terms "comprises" and/or "comprising" are used in this specification, they specify the presence of stated features, steps, operations, devices, components, and/or combinations thereof, unless the context clearly indicates otherwise.
Example of implementation 1
The implementation example discloses a GIS-based survey management and data intelligent analysis system, which adopts ArcGIS 10 as a spatial data management platform and Oracle database management software. According to system requirements, the whole system is mainly divided into a data management end, a Web desktop end and a mobile end (a mobile phone APP based on Android), and specifically relates to the contents of survey data format analysis, warehousing management, online maps, survey project data query, management processes, mobile phone APP development and the like. The overall operation structure of the system is shown in the attached figure 1 in the specification.
The system mainly realizes the following survey management and data intelligent analysis functions:
1) Combing the existing geotechnical survey data, establishing a unified geotechnical engineering survey database standard, and gradually completing the database construction work of the past geological survey result data;
2) By combining with a corresponding management flow, the normalized updating of latest geological survey result data can be realized;
3) By combining with an online map, the method can conveniently inquire, retrieve, count and the like the geotechnical engineering survey drilling data, fracture structures, result reports and other data, and provides convenience for the collection of early-stage engineering data.
In a specific embodiment, the general structure of the operation of the GIS-based geotechnical engineering information system is shown in fig. 1, and the functions of each part are as follows:
(1) Data management terminal
The data management end is a data entry of the whole system and is very important. The method has the main functions of analyzing the result data of the geotechnical investigation software, and providing the functions of result data inspection, batch warehousing and the like.
The system is deployed in a C/S mode, is installed on a computer with data storage requirements, and periodically leads latest geotechnical engineering survey data into a system database so as to ensure normal updating of the data in the system.
The ArcGIS 10 platform installed at the data management end adopts a two-dimensional space technical means, has the function of forming mass geological information into a two-dimensional graph, and can realize secondary development of an intelligent function. The Oracle database software has massive data management capability, can ensure high performance and high availability of data through reasonable management, and can ensure the safety of the data.
According to the existing survey data, management process data and the like, an ArcGIS 10 platform is utilized to perform secondary development by adopting a two-dimensional space technical means, and the structural design of Oracle data is completed, and an initial database is established as shown in the attached figure 2.
(2) Web desktop end
The program is provided for users in an intranet in a webpage form, the users can inquire, retrieve and count the past data results in various forms such as a map, a list and the like in the system, and the inquiry results comprise project basic information, drilling basic information, fracture structure information and the like; geotechnical test data, in-situ test, result report and the like can be further inquired; the user can also inquire the peripheral data according to the new project range. In addition, in combination with department management work, the program also provides a process management function module, and the whole process of related management processes such as development, check, audit and approval of each project in the department is managed, statistically analyzed and the like.
The system is deployed on the server in a B/S mode, a client does not need to additionally install software, and a user can use all functions of the system through a browser.
Specifically, referring to fig. 3, the information related to the items and the boreholes is presented in the form of an electronic map. And searching and querying the information of the items and the drill holes through the attributes and the spatial relationship in combination with the map. The information query comprises the query of item and drilling data through attribute data, the query through spatial position, buffer analysis query and quick query. And retrieving project and drilling data by means of a map, and deeply digging business data of the project and the drilling.
The basic framework of the geotechnical surveying geological data information management platform is completed, and the basic framework comprises a surveying data module, project process management, basic data management, an electronic map, system management and the like.
The main functional modules are arranged as follows:
surveying the data catalog: survey data, borehole information.
Project flow management: project information management, project field management, project check management, project audit management, project approval management and project common problem management.
Basic data management: system dependent basic autologging management (department nature, job title, academic calendar, job nature, part nature, project type, project source, project status, job type, etc.).
An electronic map: map base functions (zoom in, zoom out, previous view, next view, roam, eagle eye), layer management, quick query, note, map label mapping, map measurement, legend, condition query, space query.
And (3) system management: company management, department management, post management, role authority management, user management and log management.
(3) Mobile terminal
The program is a mobile phone APP program based on Android, and is convenient for field front-line personnel to know data, download reports, upload field photos and the like in time.
The basically completed functions of the mobile terminal include: user login, survey data query, project process query, personal center and electronic map.
User login: and logging in by the mobile terminal user.
And (3) surveying data: and inquiring the items, the basic data of the drilling and the related business data of the drilling.
And (3) item flow query: and inquiring the process information of each stage of the project process.
An electronic map: and inquiring the project and drilling information in a map mode.
The personal center: system version upgrades, personal information, etc.
The technical route of the embodiments of the present specification is described below again as follows:
the system main body is a B/S framework, a latest corresponding front-end page construction mode is adopted, and an Oracle database is accessed based on an MVC framework. NET and JavaScript are adopted for developing the front end of the Web, java is adopted for developing the mobile end, and Microsoft. The system GIS application part is mainly based on ArcGIS as a system platform, the spatial database engine adopts ArcGIS SDE, the Web end adopts ArcGIS Viewer for Flex, and the mobile end adopts ArcGIS Runtime for Android.
The function implementation mode of the specification is as follows:
(1) Data management terminal
a database design
Detailed design of a database structure: according to the existing survey data, management process data and the like, a unified database structure is designed, so that the centralized storage, the system calling, the data backup safety and the like of the data are facilitated;
and (3) server data management: the method comprises the steps of database space planning (an Oracle database is planned to be adopted), establishing according to a database design document, storing and releasing ArcGIS space data, and the like; FIG. 2 is a schematic diagram of an Oracle database structure.
And (3) analyzing the format of the survey data: the data file format of the existing Huaning rock-soil survey data is analyzed, a special data management program is developed for checking the rock-soil survey data and importing the data, the survey data can be imported into a database in batches, and long-term data updating and maintenance are facilitated.
b database establishment
And (3) converting drilling coordinates: according to coordinate data such as an 80 coordinate system, longitude and latitude and the like provided by a user, a drilling coordinate batch conversion function is provided by combining an ArcGIS coordinate conversion method, so that the drilling data and the online map coordinate are matched to form a map;
flow management information: designing related business processes and database formats according to the business logic of process management, and importing the existing management process data;
warehousing of the result drawing: the method comprises the following steps of importing result graphs in ArcGIS format, such as plane graphs of fracture structure graphs, regional geological graphs and the like, into a spatial database for management, so that front-end display and query are facilitated;
and (3) warehousing the information of the data directory: the electronic version data (such as original files of engineering projects and other result reports) list mastered by the user is put in storage, so that the professional can conveniently inquire and read on line.
(2) Desktop end system functional design
a system framework development
System navigation grid: setting a navigation grid of a home page as an entrance guide of each main functional module of the system;
front end page frame: the method is mainly based on that Net and Flex front ends are used for frame writing, and functions of layer management, multi-layer overlapping display, transparent display, zooming in and out, bookmark (favorite) management, printout and the like are integrated in a map module;
and a GIS analysis function: and basic GIS analysis functions such as distance measurement, area measurement, buffer area query and the like are integrated.
b on-line map integration
The invention considers that the management is convenient, a certain online map (such as Google map/image, arcGIS map/image or sky map/image and the like) is integrated into an information platform to be used as a system bottom plate without maintaining basic geographic data such as the map, remote sensing image and the like in real time, and the availability of an intranet computer (needing network environment matching) is ensured.
(3) Exploration data module development
The map display module: on the basis of a map frame, related positioning and query functions are integrated, and layers such as items and drilling holes support display according to different scale precision;
referring to fig. 4, the spatial information query: the method comprises the steps of inquiring basic information of a project, basic information of a drill hole and fracture structure information, wherein the inquiring mode provides a plurality of modes of space inquiring and attribute inquiring, such as drawing a frame, drawing a line or drawing a polygon on a map;
and (4) inquiring attribute information: related project information, drilling information, achievement report information and the like can be inquired according to basic information such as project names, project numbers, addresses and the like;
and (3) detailed information query: the query of the relevant information such as the drilling geotechnical test data, the in-situ test, the result report and the like can draw a drilling histogram (including geotechnical test data), a static exploration curve and the like according to the data;
and (4) geotechnical test data statistics: performing common statistical calculation on geotechnical test indexes in the area according to the designated area;
contour line generation: specifying element Cl according to sampling point data 1- 、SO 4 2- Generating and releasing ion contour lines;
referring to fig. 5, the new project analysis: and (3) specifying a new project range (supporting the modes of delineation on a graph, coordinate input and the like), setting a buffer radius, and inquiring the associated geological data and the like within a given distance range.
(4) Process management module development
And (3) process management and query: according to project management requirements, a project can be newly built, the specific progress condition of the existing project can be inquired, and the whole process of the project can be managed;
and (3) process management auditing: setting information input, leadership examination and approval and the like of relevant management processes such as project development, verification, auditing, approval and the like in a specific implementation link of each project;
and (3) reporting rock and soil yield value: project pre-project investment registering and declaring the workload;
and (5) counting a report form: and according to the business requirements of project process management, carrying out various statistical analyses on the data generated by the process management to generate various statistical graphs, reports and the like.
(5) User rights module development
User management: the user information management of the system provides functions of creating, inquiring, modifying, deleting user information and the like, and each user has a corresponding role;
and (3) role management: various roles such as a browsing role, an editing role, a leader role and the like can be defined through role management, different roles have different permission groups, and the user permission is managed by giving permission to the roles;
and (3) authority management: the authorization function of the user and the role is completed through authorization management, and the new creation, editing and deletion authorities of the sub-function points are given to the corresponding role or the user;
operating the log: the system records the operation records of all users on the information platform, can be used for an administrator to inquire and count the operation log records of all users, and provides an output function.
(6) Mobile terminal APP function design
Referring to fig. 6 (a) -6 (d), a background service interface
A user authentication interface: the method is used for user login verification and can be unified with a desktop end user;
the spatial data release related interface comprises: the method is used for displaying and inquiring the drilling data and the drawing data;
drilling data query correlation interface: the method is used for inquiring drilling data, related geotechnical tests and in-situ test data;
data query correlation interface: the function module is used for inquiring and downloading the data;
a system management interface: for other functions of the system, such as system setup, etc.
b map module
Displaying an online map: displaying an online map based on ArcGIS mobile terminal development;
and (3) information query: inquiring related drilling basic information, project information, fracture information and the like by acquiring the real-time position of a user or the designated position of the user;
uploading the field photos: the user can shoot according to the actual condition in place, fills in the description and uploads to the server, and the program automatically records information such as uploading time, coordinates and the like (the function needs to add a corresponding layer at the desktop end, develop related display and query functions, can realize real-time uploading of data, and the intranet can see after the mobile phone end uploads).
c survey data module
And (3) surveying data: a user can inquire related project information, achievement report information and the like according to basic information such as a project name, a project number, an address and the like, and can check an achievement report;
and (3) detailed information query: the user can view and browse the concerned report according to the query result.
d flow management module
Surveying project process management: the user can inquire the progress conditions of checking, auditing, approving and the like of each project process according to the basic information of the project name, the project number and the like.
E system setting module
User information management: setting basic information such as user name and password;
updating system data: updating and downloading data of the system and layer data;
with regard to: the system version number, the copyright, the APP new version prompt, the two-dimensional code downloading and installing and the like.
A survey management and data intelligent analysis system based on the GIS adopts a C/S, B/S and M/S mixed framework to operate, and internal and external network physical isolation protection measures are implemented by adopting safety equipment such as a network gate and the like in an internal network environment for ensuring the safety of data. The database and the application system are deployed on an intranet server, a related extranet channel is set through a network gate, the server can access an extranet online map, the extranet can access intranet data through a mobile phone APP single mode, and desktop clients are deployed on all desktop terminals of the intranet.
The database design system mainly comprises database design and library building functions, and provides a set of feasible database structure detailed design mode, a server data management mode, a survey data format analysis mode, drilling coordinate conversion, process management information, achievement drawing warehousing, data catalogue information warehousing and other designs and implementation methods thereof.
A unified database structure is designed according to the existing survey data, management process data and the like, so that the centralized storage, the system calling, the data backup safety and the like of the data are facilitated.
The server data management mode mainly comprises database space planning (adopting an Oracle database), database design document establishment, arcGIS space data storage and release and the like.
Taking the geotechnical investigation data as an example, mainly analyzing the data file format of the existing geotechnical investigation data, developing a special data management program for the inspection and data import of the geotechnical investigation data, and importing the investigation data into a database in batches so as to facilitate long-term data update and maintenance.
The method is realized by taking geotechnical survey data as an example, so that a professional can regularly import the latest engineering survey data into a system database, thereby ensuring the normal updating of the data in the system and facilitating the sharing and use.
Survey management and data intelligent analysis system based on GIS, the core is to realize survey data aggregation and application mining, completes various survey data aggregation by combing the past achievement data, unifying data specifications and matching management flows, further completes data application mining by using information integration technology, management system combing, system operation mode exploration and the like, and serves management work, scientific research work and field front-line related professionals. The description introduces a general framework of a project, explains key technologies involved in the construction process of a survey management and data intelligent analysis system, makes some attempts on the aspects of geotechnical survey data digitization and information construction, and basically realizes the integrated management and application of geotechnical survey data.
Geotechnical survey data:
engineering information, stratum sequence expansion, stratum sequence description, a drilling list, drilling layering expansion, drilling layering description, soil sample data, conventional geotechnical data, special geotechnical data, dynamic exploration N63.5 continuous data, dynamic exploration N63.5 discrete data, static exploration data, a static exploration data single bridge, a static exploration data double bridge, side pressure test data, cross plate data, core sampling rate data, cross plate data and a data import log.
Geotechnical survey dictionary: dictionary-rock-soil code, dictionary-exploration point type, dictionary-geological cause, dictionary-sampling type, dictionary-compression method and dictionary-shearing method.
Seismic oscillation parameters: earthquake motion peak acceleration and earthquake motion response spectrum characteristic period.
Project management process: the system comprises thesis information, software information, dongle lending conditions, meeting summary, safety and quality control inspection list, standard update suggestion, standard information, project safety and quality control inspection list, project operation history, project outsourcing engineering workload, project data application download table, rock and earth output value declaration table, geotechnical test information, project stage information, project common repeated problems and times, project problem inspection list, project basic information, project uploaded data, project checking and approval inspection list, field detail table, instrument maintenance information, instrument equipment information, instrument borrowing information and instrument reservation information.
Database building: by analyzing the data file format of the geotechnical investigation software, a corresponding database standard is established, and a data conversion program is compiled.
There are three sets of systems for domestic longitude and latitude:
WGS84: is a geodetic coordinate system and is also a coordinate system used by the GPS (global positioning system) which is widely used at present.
GCJ02: also known as the mars coordinate system, is a coordinate system of a geographic information system established by the chinese national surveying and mapping bureau. The coordinate system encrypted by the WGS84 coordinate system.
BD09: and in a hundred-degree coordinate system, encrypting again on the basis of a GCJ02 coordinate system. Wherein bd09ll represents the hundredth latitude and longitude coordinate, and bd09mc represents the hundredth mercator coordinate.
Coordinates using OpenStreetMap are WGS84; coordinates of a Gaode map and an Tencent map are used as GCJ02; the coordinate of using the Baidu map is BD09; the chinese part of *** maps and Bing maps uses the data of the highlands, so the coordinates are GCJ02.
The coordinate system of the Google map is adopted in the implementation example of the application, and longitude and latitude deviation correction is carried out in a domestic range.
Survey management and data intelligent analysis system based on GIS, the core is to realize survey data aggregation and application mining, completes various survey data aggregation by combing the past achievement data, unifying data specification and matching management flow, further completes data application mining by information integration technology, management system combing, system operation mode exploration and the like, and serves management work, scientific research work and field front-line related professionals.
The method introduces a project overall framework, explains key technologies involved in the construction process of a survey management and data intelligent analysis system database, basically realizes the integrated management and application of the geotechnical survey data database in the aspects of geotechnical survey data digitization and information construction, and lays a good foundation for further information engineering.
It is to be understood that throughout the description of the present specification, reference to the term "one embodiment", "another embodiment", "other embodiments", or "first through nth embodiments", etc., is intended to mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, or materials described may be combined in any suitable manner in any one or more embodiments or examples.
The above description is only a preferred embodiment of the present disclosure and is not intended to limit the present disclosure, and various modifications and changes may be made to the present disclosure by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present disclosure should be included in the protection scope of the present disclosure.
Claims (6)
1. Survey management and data intelligent analysis system based on GIS, characterized by includes:
the data management terminal is used for importing the latest geotechnical engineering investigation data into a database;
the server is communicated with the database, and the server forms a two-dimensional graph by mass geological information;
the data management end builds a database, analyzes the data file format of the geotechnical investigation data, realizes the inspection and data import of the geotechnical investigation data, and imports the investigation data into the database in batches; converting the drilling coordinates in batches by using a coordinate conversion method for an 80 coordinate system and longitude and latitude in geotechnical engineering survey data to realize the coordinate matching of the drilling data and an online map; when the server processes the data, the coordinate data in the database is associated with the online map, and the related data is displayed on the map; the original files of the engineering project and the catalog lists of other achievement reports are put in storage, so that online query and retrieval are facilitated;
the map display related data comprises:
displaying the project and the drilling layer according to different scale precisions;
drawing a frame, drawing a line or drawing a polygon on a map, inquiring basic information of a project, basic information of a drill hole and fracture structure information in multiple modes;
inquiring related project information, drilling information and result report information according to the project name, the project number and the address basic information;
according to the appointed area, carrying out statistical calculation on the geotechnical test indexes in the area;
and the Web desktop terminal is deployed on the server in a B/S mode, and queries, retrieves and counts the geotechnical engineering investigation data stored in the server in various forms through a browser.
2. The GIS-based survey management and data intelligent analysis system according to claim 1 further comprising a mobile terminal, wherein the server is physically isolated and connected to the Internet through a unidirectional gatekeeper, the mobile terminal is connected to the Internet, the mobile terminal is used for viewing data in the server, and uploading field data through the mobile terminal.
3. The GIS based survey management and data intelligent analysis system according to claim 1 wherein the ArcGIS formatted result map, including the plane map, is imported into a spatial database for management, facilitating front-end display and query.
4. The GIS-based survey management and data intelligent analysis system according to claim 2 wherein the mobile terminal comprises:
a user authentication interface: the system is used for user login verification and is unified with a desktop end user;
the spatial data release related interface comprises: the method is used for displaying and inquiring the drilling data and the drawing data;
drilling data query correlation interface: the method is used for inquiring drilling data, related geotechnical tests and in-situ test data;
data query correlation interface: the function module is used for inquiring and downloading data;
a system management interface: for other functions of the system, including system setup.
5. The GIS-based survey management and data intelligent analysis system according to claim 2, wherein the mobile end implements:
displaying an online map: displaying an online map based on ArcGIS mobile terminal development;
and (3) information query: inquiring related drilling basic information, project information and fracture information by acquiring the real-time position or the designated position of a user;
uploading the field photos: according to the actual situation of the field, photographing, uploading the description to a server after the description is filled in, and automatically recording the uploading time and coordinate information by the mobile terminal;
and (3) surveying data: inquiring related project information and achievement report information according to the project name, the project number and the address basic information, and checking an achievement report;
and (3) detailed information query: and viewing and browsing the concerned report according to the query result.
6. An analysis method for the GIS based survey management and data intelligent analysis system according to any of claims 1-5, characterized by comprising:
importing latest geotechnical engineering investigation data into a database;
forming a two-dimensional graph by using mass geological information;
when the database is built, analyzing the data file format of the geotechnical investigation data, realizing the inspection and data import of the geotechnical investigation data, and importing the investigation data into the database in batches;
and querying, retrieving and counting the geotechnical engineering investigation data stored in the server in various forms through a browser.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911088143.1A CN110807023B (en) | 2019-11-08 | 2019-11-08 | Survey management and data intelligent analysis system and method based on GIS |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911088143.1A CN110807023B (en) | 2019-11-08 | 2019-11-08 | Survey management and data intelligent analysis system and method based on GIS |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110807023A CN110807023A (en) | 2020-02-18 |
| CN110807023B true CN110807023B (en) | 2023-01-20 |
Family
ID=69501629
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911088143.1A Active CN110807023B (en) | 2019-11-08 | 2019-11-08 | Survey management and data intelligent analysis system and method based on GIS |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110807023B (en) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111460061A (en) * | 2020-03-05 | 2020-07-28 | 中国地质大学（武汉） | Database management system for solid core data |
| CN111400400A (en) * | 2020-03-10 | 2020-07-10 | 山东省地质矿产勘查开发局八〇一水文地质工程地质大队 | Underground space geological data information platform |
| CN112116307A (en) * | 2020-08-05 | 2020-12-22 | 佛山科学技术学院 | Traceable engineering investigation data management method and system |
| CN112016132B (en) * | 2020-08-27 | 2024-04-12 | 上海勘察设计研究院(集团)股份有限公司 | Block chain-based investigation data management system and working method thereof |
| CN112732964A (en) * | 2021-01-15 | 2021-04-30 | 成都理工大学 | Three-rock digital information retrieval and display system and method |
| CN113204563B (en) * | 2021-01-29 | 2022-03-18 | 北京城建勘测设计研究院有限责任公司 | Auxiliary investigation design system based on multi-precision hierarchical map display and retrieval service |
| CN112925842B (en) * | 2021-03-26 | 2021-11-09 | 重庆市规划和自然资源信息中心 | Planning implementation project library generation method |
| CN115033767B (en) * | 2022-08-15 | 2022-11-01 | 山东省地震工程研究院 | Earthquake security evaluation query method and system |
| CN117435579B (en) * | 2023-12-21 | 2024-03-12 | 四川正基岩土工程有限公司 | Data management system based on geotechnical engineering three-dimensional modeling |
| CN117743347A (en) * | 2024-02-21 | 2024-03-22 | 中国有色金属工业昆明勘察设计研究院有限公司 | System for storing and utilizing investigation result data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2835747A2 (en) * | 2013-08-08 | 2015-02-11 | Sap Se | Managing and querying spatial point data in column stores |
| CN104462539A (en) * | 2014-12-24 | 2015-03-25 | 中国电建集团成都勘测设计研究院有限公司 | Three-dimensional visual original exploration data management method |
| CN105260427A (en) * | 2015-09-29 | 2016-01-20 | 安徽博微广成信息科技有限公司 | Internet based panoramic image display method |
| CN109615696A (en) * | 2018-11-28 | 2019-04-12 | 苏州微维大数据有限公司 | A kind of engineering geology D visualization processing method |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7925982B2 (en) * | 2006-09-01 | 2011-04-12 | Cheryl Parker | System and method of overlaying and integrating data with geographic mapping applications |
| US8533217B2 (en) * | 2006-11-01 | 2013-09-10 | Yahoo! Inc. | System and method for dynamically retrieving data specific to a region of a layer |
| US20080120122A1 (en) * | 2006-11-20 | 2008-05-22 | Jon Olenski | Field site data gathering and reporting system and method |
| CN106779417A (en) * | 2016-12-20 | 2017-05-31 | 黄河勘测规划设计有限公司 | The collection of engineering investigation information digitalization, management and integrated application method |
| CN107909271A (en) * | 2017-11-15 | 2018-04-13 | 国网四川省电力公司经济技术研究院 | A kind of Geotechnical Engineering Investigation Data management and assessment generalized information system |
| CN110097335A (en) * | 2019-04-08 | 2019-08-06 | 广州市城市规划勘测设计研究院 | A kind of geotechnical engineering investigation informationization operating system and method |
| CN109947068A (en) * | 2019-04-24 | 2019-06-28 | 广州市城市规划勘测设计研究院 | A kind of field data acquisition system and method |
| CN110222373B (en) * | 2019-05-09 | 2020-10-30 | 中国地质大学（武汉） | Geotechnical engineering full life cycle oriented engineering investigation data processing method |
-
2019
- 2019-11-08 CN CN201911088143.1A patent/CN110807023B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2835747A2 (en) * | 2013-08-08 | 2015-02-11 | Sap Se | Managing and querying spatial point data in column stores |
| CN104462539A (en) * | 2014-12-24 | 2015-03-25 | 中国电建集团成都勘测设计研究院有限公司 | Three-dimensional visual original exploration data management method |
| CN105260427A (en) * | 2015-09-29 | 2016-01-20 | 安徽博微广成信息科技有限公司 | Internet based panoramic image display method |
| CN109615696A (en) * | 2018-11-28 | 2019-04-12 | 苏州微维大数据有限公司 | A kind of engineering geology D visualization processing method |
Non-Patent Citations (2)
| Title |
|---|
| Use geographic ontology and web mining to enhance service quality of web map;Maojun Huang;《2010 3rd International Conference on Computer Science and Information Technology》;20100907;全文 * |
| 基于网络的钻孔数据管理及空间数据发布与查询***研究;孙宏伟;《中国优秀硕士学位论文全文数据库 基础科学辑》;20160215;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110807023A (en) | 2020-02-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110807023B (en) | Survey management and data intelligent analysis system and method based on GIS | |
| CN104504094A (en) | Various data source integrated management method for oil and gas field | |
| CN111612405A (en) | Rock and soil dynamic information processing system and method based on cloud GIS platform | |
| CN104006805A (en) | Electric power engineering field reconnaissance method based on mobile GIS | |
| CN111582729A (en) | System and method for acquiring field data of soil mass and geological survey | |
| CN115617889A (en) | GIS-based survey data acquisition and processing method and system | |
| KR102068094B1 (en) | Integrated underground water data management system | |
| US20130232158A1 (en) | Data subscription | |
| CN117436054B (en) | Geotechnical engineering big data sharing platform | |
| US20110258007A1 (en) | Data subscription | |
| CN111966725A (en) | Data acquisition method and device applied between internal network and external network and electronic equipment | |
| CN117076585A (en) | Investigation inside and outside industry integrated system based on three-dimensional geological information model | |
| Alam | An innovative project management system | |
| Curdt et al. | Development of a metadata management system for an interdisciplinary research project | |
| Munoz et al. | A mobile quality assurance application for the nrdc | |
| Doherty | Development of a web-based geotechnical data management system for the Alabama Department of Transportation | |
| CN117435579B (en) | Data management system based on geotechnical engineering three-dimensional modeling | |
| Graettinger et al. | GeoGIS: phase III. | |
| Shankar | Scientific data archiving: the state of the art in information, data, and metadata management | |
| Defu et al. | Building an interactive web-based GIS system for planning of geological survey works | |
| Liu et al. | Design and Implementation of Earthquake Emergency Information Linkage and Public Service System | |
| Dasenbrock | Geotechnical data sharing and electronic data exchange at Minnesota DOT | |
| Azyat et al. | MGISP: Integrated Framework Based on GPS for Spatial Data Acquisition, Management and Geovisualization | |
| Kelley | Creating a Well Database and Web Mapping Application: Using Geographic Information Systems to Manage and Monitor Groundwater Resources in Sonoma County, California | |
| Kisaaga et al. | Real Time Digital and Meta Data Collection in Forming Urban Information System: Case Study Elazig (Turkey) |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |