Online geological survey method for live-action three-dimensional digital outcrop

Abstract

The invention discloses an online geological survey method for a live-action three-dimensional digital outcrop, and relates to the technical field of crossing of network geographic information and live-action three-dimensional visualization. The method comprises a geological outcrop data co-construction and sharing service logic process, an online geological investigation service logic process and a user geological outcrop data management service logic process, and the co-construction and sharing service logic process comprises a user registration and login sub-process, a geological outcrop data co-construction sub-process and a geological outcrop data sharing sub-process. The investigation business logic process comprises a geological outcrop model and related data uploading sub-process, a geological outcrop model searching sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process and a geological information interaction sub-process; and the management service logic process comprises a contact person management sub-process, a geological outcrop data collection management sub-process and a geological outcrop data contribution management sub-process, so that the effectiveness of online investigation of the live-action three-dimensional digital outcrop can be achieved.

Description

Technical Field

[0001] The invention belongs to the cross-technical field of network geographic information and real-scene three-dimensional visualization, and specifically relates to an online geological survey method for real-scene three-dimensional digital outcrops. Background Art

[0002] In the field of network geographic information systems, when facing online geological surveys, it is usually necessary to establish a real-life 3D geographic information platform to meet the needs of online geological surveys by providing intuitive, accurate and highly realistic 3D geographic spatial data, combined with traditional photos, videos and / or panoramic data. At the same time, the real-life 3D geographic information platform should provide some relatively basic analysis and measurement tools, and add sufficient and professional geological information introductions to geological outcrops to help users conduct online geological surveys.

[0003] At present, the main international real-life three-dimensional network geographic information platforms include the V3Geo platform and the GeoVires platform.

[0004] The V3Geo platform is a 3D geological profile information platform with a large data scale, which has many 3D models of outcrop profiles from all over the world. The outcrop profile 3D models of the V3Geo platform are of high quality and allow users to adjust the visual effects of the model according to their needs, including parameters such as brightness and / or color difference. However, the V3Geo platform does not add professional geological information data for each geological outcrop profile, which means that for online geological surveys, there is a problem that it cannot play a good supporting role due to the lack of detailed geological information. In addition, the analysis tools of the V3Geo platform are relatively simple. For example, although the platform provides measurement functions, the measurement only supports the most basic measurements such as straight-line distance. When faced with the needs of measurements such as stratigraphic occurrence, it obviously lacks practicality.

[0005] The GeoVires platform is a relatively professional online geographic information system. In addition to providing regular displays of three-dimensional models of geological sections, the GeoVires platform also provides geological information for each model and supports the display of observation points, which is highly professional. However, the data volume of the GeoVires platform is relatively small: on the one hand, the types of geological sections covered by the GeoVires platform are not rich, the number of outcrops is relatively limited, and a single outcrop does not have photos, videos, and / or panoramic data; on the other hand, the quality of the three-dimensional models provided by the GeoVires platform is poor, and the model cannot show good details after being enlarged. In addition, the GeoVires platform does not provide users with any measurement tools. For users who want to inspect various geological sections online and obtain some basic geological measurement information, the GeoVires platform is not a good choice.

[0006] Therefore, in response to the actual needs of online geological surveys of real-life three-dimensional digital outcrops, how to provide a new solution that allows users to upload high-quality real-life three-dimensional geological outcrop models and their related data at the functional level, provide interactive communication functions for geological information, realize the co-construction and sharing of geological outcrop data, and provide efficient data management functions, thereby providing convenience for users in online geological surveys, is a topic that technical personnel in this field urgently need to study. Summary of the invention

[0007] The purpose of the present invention is to provide an online geological survey method for real-scene three-dimensional digital outcrops, so as to solve the problem that the existing real-scene three-dimensional network geographic information platform affects the user's online geological survey experience due to limited functions.

[0008] In order to achieve the above object, the present invention adopts the following technical solutions:

[0009] The present invention provides an online geological survey method for real-scene three-dimensional digital outcrops, including a geological outcrop data co-construction and sharing business logic process, an online geological survey business logic process after a user logs in, and a user geological outcrop data management business logic process;

[0010] The geological outcrop data co-construction and sharing business logic process includes a user registration and login sub-process, a geological outcrop data co-construction sub-process and a geological outcrop data sharing sub-process;

[0011] The online geological survey business logic process includes a geological outcrop model and related data uploading sub-process, a geological outcrop model search sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process and a geological information interaction sub-process;

[0012] The user geological outcrop data management business logic process includes a contact person management sub-process, a geological outcrop data collection management sub-process and a geological outcrop data contribution management sub-process.

[0013] Based on the above invention content, a new solution with multifunctional assistance for online geological survey of real-life three-dimensional digital outcrops is provided, which includes a geological outcrop data co-construction and sharing business logic process, an online geological survey business logic process after the user logs in, and a user geological outcrop data management business logic process, wherein the geological outcrop data co-construction and sharing business logic process includes a user registration and login sub-process, a geological outcrop data co-construction sub-process, and a geological outcrop data sharing sub-process; the online geological survey business logic process includes a geological outcrop model and related data uploading sub-process, a geological outcrop model search sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process, and a geological information interaction sub-process; the user geological outcrop data management business logic process includes a contact person management sub-process, a geological outcrop The outcrop data collection management sub-process and the outcrop data contribution management sub-process can provide a professional online geological survey real-life 3D digital outcrop system based on open source 3D Web development technology and supported by high-resolution UAV oblique photography data and geospatial data. It can not only upload models of geological outcrops, edit outcrop information, edit observation points, measure, map, share information and interact with each other, but also browse online geological outcrop related information such as descriptions, pictures, videos, panoramas, documents, observation points and geological mapping, which can support online geological surveys, realize the co-construction and sharing of geological outcrop data and the efficient management of user geological outcrop information, achieve the effectiveness of online surveys of real-life 3D digital outcrops and the friendliness of user operation experience, and facilitate practical application and promotion.

[0014] In a possible design, the user registration and login sub-process includes a user registration phase and a user login phase;

[0015] The user registration phase includes the following steps:

[0016] Verify the registration form containing user information through the front-end pre-made form to ensure that the input registration form conforms to the preset format and rules;

[0017] After successful verification, the user information is securely submitted to the backend via the HTTPS protocol; the backend uses the Django framework to receive the user information and perform server-side verification, wherein the server-side verification includes checking data integrity and application business logic correctness;

[0018] After the verification is passed, the user information is stored in the relational database PostgreSQL;

[0019] The user login stage includes the following steps:

[0020] Comparing whether the account number and password entered by the user match the user data stored in the relational database PostgreSQL;

[0021] If they match, the identity is confirmed to be legitimate and the login is successful.

[0022] In a possible design, the geological outcrop data co-construction sub-process includes the following steps:

[0023] When a user uploads a geological outcrop three-dimensional model and related data thereof, the Element UI upload component on the user side is used to verify the type and size of the uploaded file, and after the verification is passed, the server-side upload interface is called to upload the geological outcrop three-dimensional model and related data thereof, so that the geological outcrop three-dimensional model and related data thereof are uploaded to the server folder in pieces and synchronized to the object storage service OSS, and the metadata of the geological outcrop three-dimensional model and related data thereof are stored in the database;

[0024] And / or, the geological outcrop model and related data uploading sub-process includes the following steps:

[0025] Use the Element UI upload component on the user side to verify the size of the uploaded file containing the geological outcrop 3D model and its related data;

[0026] If the size of the uploaded file exceeds a preset threshold, the uploaded file is uploaded to the server folder in pieces using the MD5 hash algorithm and the Blob method;

[0027] The server sorts and reorganizes the shard data according to the MD5 identifier and the shard index, restores it to the original file and synchronizes it to the object storage service OSS, and stores the metadata of the geological outcrop 3D model and its related data in the database.

[0028] In a possible design, the geological outcrop data sharing sub-process includes the following steps:

[0029] Use the Cesium engine and asynchronous processing requests to load the geological outcrop 3D model;

[0030] Performing rotation interaction, translation interaction, scaling interaction and / or measurement interaction on the geological outcrop three-dimensional model through Canvas binding events;

[0031] Use Vue components and combine with Axios library to initiate a request to call the data display interface to obtain the relevant data of the geological outcrop three-dimensional model, and dynamically render the relevant data on the front-end page in the form of components, and use visualization plug-ins to browse the relevant data clearly and interactively, wherein the relevant data contains pictures, videos and / or panoramic information;

[0032] Use the WebSocket protocol for service encoding to establish a persistent connection between client terminals and achieve real-time sharing of geological outcrop information;

[0033] And / or, the geological outcrop model interaction sub-process includes the following steps:

[0034] The asynchronous loading technology of Cesium 3D engine is used to realize hardware accelerated rendering of geological outcrop 3D model through WebGL protocol.

[0035] The three-dimensional model of the geological outcrop is rotated, scaled and / or translated using a view control and event processing API, and an interpolation algorithm is used to achieve ground-based measurement of the distance, perimeter and / or area of ​​the three-dimensional model of the geological outcrop.

[0036] In a possible design, the geological outcrop model search subprocess includes the following steps:

[0037] Initiate an HTTPS request using the Axios library on the front end to encode the query parameters input by the user and send the encoded results to the server, wherein the query parameters include keywords, longitude and latitude, and geological outcrop element labels;

[0038] After receiving the HTTPS request, the server first decodes the query parameters, then uses the ORM method to filter out the geological outcrop three-dimensional models matching the query parameters from the database, and finally encapsulates the screening results in JSON format and returns them to the front end.

[0039] In a possible design, the geological outcrop related data display sub-process includes the following steps:

[0040] Through the model unique identifier and data type parameters, the Axios library is used to call the data display interface on the server to initiate a request for displaying geological outcrop related data;

[0041] The Django framework on the server side receives the geological outcrop related data display request, interacts with the PostgreSQL database through the object relational mapping (ORM), and executes SQL queries to retrieve and obtain the geological outcrop related data;

[0042] The query results are returned in JSON format and dynamically rendered on the front-end page by the Vue component to achieve real-time display of geological outcrop related data;

[0043] For the pictures, videos, and panoramic data returned by the file system, use <el-image>Label, <video>Tags and photo-shpere-viewer plugins are displayed;

[0044] The plotting and observation point data are loaded into the 3D visualization interface by adding entities.

[0045] In a possible design, the geological information interaction sub-process includes a real-time interaction stage and / or an asynchronous communication stage;

[0046] The real-time interaction stage includes the following steps:

[0047] When communication and sharing occurs between users, the WebSocket protocol is used to establish a full-duplex communication channel between the user interface and the server to allow real-time two-way exchange of information between users.

[0048] When a user submits geological information or shares content, the corresponding user front end encodes the geological information or the shared content and sends the encoding result to the server through the corresponding full-duplex communication channel;

[0049] The server decodes the encoding result to restore the geological information or the shared content, and broadcasts the geological information or the shared content to all connected user front ends to achieve real-time message reception and interface update;

[0050] Maintaining the connection of the full-duplex communication channel active through a heartbeat mechanism and performing corresponding processing when the connection is disconnected, so as to ensure the continuity and stability of communication between the user ends;

[0051] The asynchronous communication stage includes the following steps:

[0052] The server stores the form data from the user front end and including the user's likes, messages and / or comments on various information resources of the system into the database;

[0053] When other users access the same resource, relevant likes, messages and / or comments are retrieved from the database and dynamically displayed on the front-end page to achieve asynchronous interaction of information.

[0054] In a possible design, the contact management sub-process includes the following steps:

[0055] Render the friend list and / or discussion group list stored in the Vuex state management library through the Element UI component library, and provide add, delete, edit and / or query functions for the content in the list;

[0056] When querying a contact, the server searches the friend list and / or discussion group list for a contact field that matches the query keyword, and returns the matching result to the user front end;

[0057] When modifying a contact, the contact management interface on the server side is called through the Axios library to filter and update the contact information in the friend list and / or discussion group list, and finally the contact information is returned to the user front end for re-rendering.

[0058] In a possible design, the geological outcrop data collection management subprocess includes the following steps:

[0059] Use the Vuex state management library to save the user's favorite data ID in array form, and use the Element UI component library to render the favorites list;

[0060] When the favorites list is updated, the favorites field in the favorites list is updated by calling the favorites management interface on the server side using Axios request, thereby realizing dynamic management of geological outcrop data collection.

[0061] In a possible design, the geological outcrop data contribution management subprocess includes the following steps:

[0062] By utilizing the foreign key constraints in the PostgreSQL database, we can quickly match the contribution records whose uploader ID matches the currently logged-in user ID in each data table, return the contribution records to the user front end, and finally render the contribution list through the Element UI component library.

[0063] Beneficial effects of the above scheme:

[0064] (1) The present invention provides a new multifunctional solution for online geological survey of real-life three-dimensional digital outcrops, which includes a geological outcrop data co-construction and sharing business logic process, an online geological survey business logic process after user login, and a user geological outcrop data management business logic process, wherein the geological outcrop data co-construction and sharing business logic process includes a user registration and login sub-process, a geological outcrop data co-construction sub-process, and a geological outcrop data sharing sub-process; the online geological survey business logic process includes a geological outcrop model and related data uploading sub-process, a geological outcrop model search sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process, and a geological information interaction sub-process; the user geological outcrop data management business logic process includes a contact person management sub-process, a geological outcrop The outcrop data collection management sub-process and the outcrop data contribution management sub-process can provide a professional online geological survey real-scene 3D digital outcrop system based on open source 3D Web development technology and supported by high-resolution UAV oblique photography data and geospatial data. It can not only upload models of geological outcrops, edit outcrop information, edit observation points, measure, plot, share information and interact with each other, but also browse online geological outcrop related information such as descriptions, pictures, videos, panoramas, documents, observation points and geological plots, so as to support online geological surveys, realize the co-construction and sharing of geological outcrop data and the efficient management of user geological outcrop information, achieve the effectiveness of online surveys of real-scene 3D digital outcrops and the friendliness of user operation experience, and facilitate practical application and promotion.

[0065] (2) Compared with the time-consuming and labor-intensive traditional on-site geological survey, the present invention provides an online survey method, which does not require going to the site, and can realize the study of geological outcrops by simply operating on the screen. The operation method is simple and easy to understand, saving a lot of time and resources, and improving the efficiency of geological survey;

[0066] (3) The present invention can present the true three-dimensional form of geological outcrops, and the browsing display effect is smooth and clear, so that researchers can observe geological outcrops from different perspectives to obtain more comprehensive information and feel the real situation of geological outcrops more intuitively and realistically, which is conducive to more accurate analysis and interpretation;

[0067] (4) The present invention provides a variety of tools required for geological surveys and has good interactivity, fast and efficient data processing, and simple operation, which helps researchers conduct geological analysis, interpretation and research remotely, while reducing the damage to geological outcrops caused by human field surveys;

[0068] (5) The present invention reduces the interference of human operation through digital analysis, ensuring the reliability and accuracy of geological data; at the same time, geological data can be archived to ensure security and accessibility and prevent data loss or damage;

[0069] (6) The present invention supports data sharing and collaborative research. Researchers can share their personally collected geological data with other researchers online to promote the common progress of geological research.

[0070] (7) The present invention fully considers the encapsulation of the Web display system and the background analysis function module, and organically combines the front-end display and the analysis function module. Compared with simply using the map service provided by the GIS server, it is more flexible and more scalable. BRIEF DESCRIPTION OF THE DRAWINGS

[0071] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0072] Figure 1 A schematic flow chart of an online geological survey method for a real-scene three-dimensional digital outcrop provided in an embodiment of the present invention.

[0073] Figure 2 This is an example diagram of a geological outcrop selection interface provided in an embodiment of the present invention.

[0074] Figure 3 This is an example diagram of a macroscopic perspective view of an outcrop model provided in an embodiment of the present invention.

[0075] Figure 4 This is an example diagram of a local detail diagram of an outcrop model provided in an embodiment of the present invention.

[0076] Figure 5 This is an example diagram of a geological mapping effect display diagram provided in an embodiment of the present invention.

[0077] Figure 6 This is an example diagram of a geological observation point effect display diagram provided in an embodiment of the present invention.

[0078] Figure 7 This is an example diagram of the geological information interactive function interface provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0079] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be briefly introduced below in combination with the drawings and the description of the embodiments or the prior art. Obviously, the following description of the structures of the drawings is only some embodiments of the present invention. For ordinary technicians in this field, other embodiments can be obtained based on these embodiments without creative work. It should be noted that the description of these embodiments is used to help understand the present invention, but does not constitute a limitation of the present invention.

[0080] It should be understood that although the terms first and second, etc. may be used herein to describe various objects, these objects should not be limited by these terms. These terms are only used to distinguish one object from another object. For example, a first object can be referred to as a second object, and similarly, a second object can be referred to as a first object without departing from the scope of the exemplary embodiments of the present invention.

[0081] It should be understood that the term "and / or" that may appear in this article is merely a description of the association relationship of associated objects, indicating that there may be three relationships. For example, A and / or B can indicate three situations: A exists alone, B exists alone, or A and B exist at the same time. For another example, A, B and / or C can indicate the existence of any one of A, B and C or any combination of them. The term " / and" that may appear in this article describes another type of association object relationship, indicating that there may be two relationships. For example, A / and B can indicate two situations: A exists alone or A and B exist at the same time. In addition, the character " / " that may appear in this article generally indicates that the previous and next associated objects are in an "or" relationship.

[0082] Example

[0083] like Figure 1 As shown, the online geological survey method of the real-life three-dimensional digital outcrop provided in this embodiment includes but is not limited to a geological outcrop data co-construction and sharing business logic process, an online geological survey business logic process after the user logs in, and a user geological outcrop data management business logic process, etc.; the geological outcrop data co-construction and sharing business logic process includes but is not limited to a user registration and login sub-process, a geological outcrop data co-construction sub-process, and a geological outcrop data sharing sub-process, etc.; the online geological survey business logic process includes but is not limited to a geological outcrop model and related data uploading sub-process, a geological outcrop model search sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process, and a geological information interaction sub-process, etc.; the user geological outcrop data management business logic process includes but is not limited to a contact person management sub-process, a geological outcrop data collection management sub-process, and a geological outcrop data contribution management sub-process, etc.

[0084] User registration and login are the prerequisites for the joint construction of geological outcrop data. Specifically, the user registration and login sub-process includes but is not limited to a user registration stage and a user login stage, wherein the user registration stage includes but is not limited to the following steps S11 to S14.

[0085] S11. Verify the registration form containing user information through the front-end pre-made form to ensure that the input registration form complies with the preset format and rules.

[0086] In step S11, the purpose of the above-mentioned form verification action is to ensure that the user fills in the form data in the correct format, thereby ensuring that the submitted data can enable the subsequent application to work normally.

[0087] S12. After the verification is successful, the user information is securely submitted to the backend via the HTTPS (Hypertext Transfer Protocol Secure) protocol.

[0088] S13. The backend uses the Django framework to receive the user information and perform server-side verification, wherein the server-side verification includes but is not limited to checking data integrity and application business logic correctness.

[0089] In step S13, the Django framework is an open source Web framework written in Python and having complete website building capabilities. By using the Django framework, Python program developers can easily complete most of the content required for a formal website with only a few codes, and further develop full-featured Web services. Therefore, it can be applied to this embodiment to receive the user information and perform server-side verification.

[0090] S14. After the verification is passed, the user information is stored in the relational database PostgreSQL.

[0091] In step S14, the relational database PostgreSQL is an advanced open source object-relational database that provides a wide range of data types, powerful data integrity and scalability functions, and is particularly suitable for complex enterprise-level applications and big data solutions.

[0092] The user login stage includes but is not limited to the following steps S15 to S16.

[0093] S15. Compare the account number and password entered by the user to see if they match the user data stored in the relational database PostgreSQL.

[0094] S16. If they match, the identity is confirmed to be legitimate and the login is successful.

[0095] After step S15, if there is no match, it can be confirmed that the identity is illegal and the login fails.

[0096] Geological outcrop data co-construction means that after logging in, users can upload geological outcrop three-dimensional models and related data. Specifically, the geological outcrop data co-construction sub-process includes but is not limited to the following steps: when users upload geological outcrop three-dimensional models and related data, the Element UI upload component on the user side is used to verify the type and size of the uploaded file, and after the verification is passed, the server upload interface is called to upload the geological outcrop three-dimensional model and related data, so that the geological outcrop three-dimensional model and related data are uploaded to the server folder in pieces and synchronized to the object storage service OSS (Object Storage Service), and the metadata of the geological outcrop three-dimensional model and related data are stored in the database. The aforementioned Element UI is a front-end UI (User Interface, user interface, refers to the overall design of the human-computer interaction, operation logic, and beautiful interface of the software) framework based on Vue.js, which provides an upload component "el-upload", so the upload component can be applied to verify the type and size of the uploaded file.

[0097] Geological outcrop data sharing means that all users can browse and share uploaded geological outcrop models and related data. Specifically, the geological outcrop data sharing sub-process includes but is not limited to the following steps S31 to S34.

[0098] S31. Load the geological outcrop 3D model through the Cesium engine and asynchronous processing requests.

[0099] In step S31, the Cesium engine is an open source 3D earth rendering engine, which was officially released in 2014 and is often used to present high-precision three-dimensional earth and other celestial models on web pages.

[0100] S32. Perform rotation interaction, translation interaction, zoom interaction and / or measurement interaction on the geological outcrop three-dimensional model through Canvas binding events.

[0101] In step S32, Canvas is a tool that provides designers and developers with simplified web page development, solving the problems that have troubled designers and developers. Since Canvas is regarded as a canvas, it does not have the ability to handle events itself. Therefore, a transparent DOM (Document Object Model) element can be added to Canvas, and events can be bound to this element, thereby achieving the purpose of rotation interaction, translation interaction, zoom interaction and / or measurement interaction of the geological outcrop three-dimensional model.

[0102] S33. Use Vue components and combine with the Axios library to initiate a request to call the data display interface to obtain the relevant data of the geological outcrop three-dimensional model, and dynamically render the relevant data on the front-end page in the form of a component. At the same time, use a visualization plug-in to browse the relevant data clearly and interactively, wherein the relevant data includes but is not limited to pictures, videos and / or panoramic information.

[0103] In step S33, component is one of the most powerful features of Vue.js, which can extend HTML elements and encapsulate reusable code, and Axios library is a Promise-based network request library that works in nodejs and browsers, so the two can be combined to obtain the relevant data.

[0104] S34. Use the WebSocket protocol for service encoding to establish a persistent connection between user terminals and achieve real-time sharing of geological outcrop information.

[0105] In step S34, WebSocket is a protocol for full-duplex communication on a single TCP (Transmission Control Protocol, a connection-oriented, reliable, byte stream-based transport layer communication protocol defined by IETF's RFC 793) connection. Therefore, a continuous connection between user terminals can be established through service encoding, thereby realizing real-time sharing of geological outcrop information.

[0106] The purpose of uploading the geological outcrop model and related data is similar to that of the geological outcrop data co-construction. Specifically, the geological outcrop model and related data uploading sub-process includes the following steps S41 to S43.

[0107] S41. Use the Element UI upload component on the user side to verify the size of the uploaded file containing the geological outcrop 3D model and its related data.

[0108] S42. If the size of the uploaded file exceeds a preset threshold, the uploaded file is uploaded in pieces to a server folder using the MD5 hash algorithm and the Blob method.

[0109] In step S42, the MD5 hash algorithm (Message-Digest Algorithm 5) is a widely used hash function for generating a 128-bit digest of a message to ensure data integrity and prevent tampering; the MD5 algorithm converts input data of any length into a 128-bit hash value (i.e., a 32-character hexadecimal number) through a series of calculation processes, and this process is irreversible, i.e., the original data cannot be restored from the hash value. The Blob method is a method for slicing BLOB (Binary Large Object, a data type for storing binary large objects, such as images, audio, or video) data: a common slicing strategy is to slice by byte range, i.e., to divide BLOB data into blocks of fixed size (e.g., 1MB or 2MB); another strategy is to slice by file type, i.e., to store different types of BLOB data (such as images and audio, etc.) in different tables. Therefore, the two can be combined to upload the uploaded files in pieces, and restore the files on the server side.

[0110] S43. The server sorts and reorganizes the shard data according to the MD5 identifier and the shard index, restores it to the original file and synchronizes it to the object storage service OSS, and at the same time stores the metadata of the geological outcrop three-dimensional model and its related data in the database.

[0111] The geological outcrop model search refers to searching for a target model. Specifically, the geological outcrop model search subprocess includes but is not limited to the following steps S51 to S52.

[0112] S51. Use the Axios library on the front end to initiate an HTTPS request to encode the query parameters input by the user and send the encoded results to the server, wherein the query parameters include but are not limited to keywords, longitude and latitude, and geological outcrop element labels.

[0113] In step S51, Figure 2 As shown, in the geological outcrop selection interface, there are a variety of geological outcrop feature labels for selection and input.

[0114] S52. After receiving the HTTPS request, the server first decodes the query parameters, and then uses the ORM (Object Relational Mapping) method to filter out the geological outcrop three-dimensional model matching the query parameters from the database, and finally encapsulates the screening results in JSON (JavaScript Object Notation) format and returns them to the front end.

[0115] The purpose of geological outcrop model interaction is similar to that of geological outcrop data sharing. Specifically, the geological outcrop model interaction sub-process includes but is not limited to the following steps S61-S62.

[0116] S61. Utilize the asynchronous loading technology of Cesium 3D engine and use WebGL protocol to realize hardware accelerated rendering of geological outcrop 3D model.

[0117] In step S61, the WebGL (full text Web Graphics Library) protocol is a 3D drawing protocol. This drawing technology standard allows JavaScript and OpenGL ES2.0 to be combined together. By adding a JavaScript binding to OpenGLES2.0, WebGL can provide hardware 3D accelerated rendering for HTML5 Canvas, so that Web developers can use the system graphics card to display 3D scenes and models more smoothly in the browser, and can also create complex navigation and data visualization.

[0118] In step S61, Figures 3-4 As shown, a macroscopic view and local detail view of an outcrop model can be rendered.

[0119] S62. Use the view control and event processing API (Application Programming Interface) to perform rotation, scaling and / or translation operations on the geological outcrop three-dimensional model, and use an interpolation algorithm to achieve ground-based measurement of the distance, perimeter and / or area of ​​the geological outcrop three-dimensional model.

[0120] In step S62, the view control and event processing API can be implemented through JavaScript or some front-end frameworks (such as React, Vue or Angular, etc.).

[0121] The geological outcrop related data display refers to the front-end display of the relevant data of the target model. Specifically, the geological outcrop related data display sub-process includes but is not limited to the following steps S71 to S74.

[0122] S71. Using the model unique identifier and data type parameters, use the Axios library to call the data display interface on the server to initiate a geological outcrop related data display request.

[0123] S72. The Django framework on the server side receives the geological outcrop related data display request, interacts with the PostgreSQL database through object relational mapping (ORM), and executes SQL (Structured Query Language) query to retrieve and obtain the geological outcrop related data.

[0124] S73. The query results are returned in JSON format and dynamically rendered on the front-end page by the Vue component to achieve real-time display of geological outcrop related data.

[0125] S74. For the pictures, videos and panoramic data returned by the file system, use <el-image>Label, <video>Tags and photo-shpere-viewer plugin are shown.

[0126] In step S74, the <el-image>Label and Description <video>The tags are all existing tags, wherein the former corresponds to pictures, the latter corresponds to videos, and the photo-shpere-viewer plug-in is an existing plug-in and corresponds to panoramic data.

[0127] S75. Load the plotting and observation point data onto the three-dimensional visualization interface by adding entities.

[0128] In step S75, the display results of the geological mapping effect and the geological observation point effect can be respectively as follows: Figures 5-6 shown.

[0129] The geological information interaction is divided into two parts: real-time interaction and asynchronous communication. The former is the communication and sharing between users, and the latter refers to users liking and commenting on various information resources in the system. Specifically, the geological information interaction sub-process includes but is not limited to the real-time interaction stage and / or the asynchronous communication stage, wherein the real-time interaction stage includes but is not limited to the following steps S81 to S84.

[0130] S81. When communication and sharing occurs between users, the WebSocket protocol is used to establish a full-duplex communication channel between the user interface and the server to allow real-time two-way exchange of information between users.

[0131] S82. When a user submits geological information or shares content, the corresponding user front end encodes the geological information or the shared content and sends the encoding result to the server through the corresponding full-duplex communication channel.

[0132] S83. The server decodes the encoding result to restore the geological information or the shared content, and broadcasts the geological information or the shared content to all connected user front ends to achieve real-time message reception and interface update.

[0133] In step S83, the geological information interactive function interface can be, for example, Figure 7 shown.

[0134] S84. Maintain the connection of the full-duplex communication channel active through a heartbeat mechanism, and perform corresponding processing when the connection is disconnected, so as to ensure the continuity and stability of communication between user terminals.

[0135] The asynchronous communication stage includes but is not limited to the following steps S85-S86.

[0136] S85. The server stores the form data from the user front end and including the user's likes, messages and / or comments on various information resources of the system in the database.

[0137] S86. When other users access the same resource, relevant likes, messages and / or comments are retrieved from the database and dynamically displayed on the front-end page to achieve asynchronous interaction of information.

[0138] Contact management includes friend management and discussion group management. Specifically, the contact management sub-process includes but is not limited to the following steps S91 to S93.

[0139] S91. Through the Element UI component library, render the friend list and / or discussion group list stored in the Vuex state management library, and provide add, delete, edit and / or query functions for the content in the list.

[0140] S92. When searching for a contact, the server searches the friend list and / or the discussion group list for a contact field that matches the query keyword, and returns the matching result to the user front end.

[0141] S93. When modifying a contact, the contact management interface on the server is called through the Axios library to filter and update the contact information in the friend list and / or discussion group list, and finally return the contact information to the user front end for re-rendering.

[0142] The geological outcrop data collection management refers to the collection management of the target model and its related data collected by the user. Specifically, the geological outcrop data collection management sub-process includes but is not limited to the following steps S101 to S102.

[0143] S101. Use the Vuex state management library to save the user's favorite data IDs in array form, and use the ElementUI component library to render the favorites list.

[0144] In step S101, Vuex is the official state management library of Vue.js, which is used to manage the state of the application.

[0145] S102. When updating the favorites list, the favorites field in the favorites list is updated by calling the favorites management interface on the server side using Axios request, thereby achieving dynamic management of geological outcrop data collection.

[0146] In step S102, Axios is a promise-based network request library that works in node.js and browsers.

[0147] Geological outcrop data contribution management refers to the management of user data contribution records. Specifically, the geological outcrop data contribution management sub-process includes but is not limited to the following steps: using foreign key constraints in the PostgreSQL database to quickly match contribution records whose uploader ID matches the currently logged-in user ID in each data table, and return the contribution records to the user front end, and finally render the contribution list through the Element UI component library.

[0148] In summary, the online geological survey method provided by this embodiment has the following technical effects:

[0149] (1) This embodiment provides a new multifunctional solution for online geological survey of real-life three-dimensional digital outcrops, which includes a geological outcrop data co-construction and sharing business logic process, an online geological survey business logic process after the user logs in, and a user geological outcrop data management business logic process, wherein the geological outcrop data co-construction and sharing business logic process includes a user registration and login sub-process, a geological outcrop data co-construction sub-process, and a geological outcrop data sharing sub-process; the online geological survey business logic process includes a geological outcrop model and related data uploading sub-process, a geological outcrop model search sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process, and a geological information interaction sub-process; the user geological outcrop data management business logic process includes a contact person management sub-process, a geological outcrop The data collection management sub-process and the geological outcrop data contribution management sub-process can provide a professional online geological survey real-scene 3D digital outcrop system based on open source 3D Web development technology and supported by high-resolution UAV oblique photography data and geospatial data. It can not only upload models, edit outcrop information, edit observation points, measure, plot, share information and interact with geological outcrops, but also browse online geological outcrop related information such as descriptions, pictures, videos, panoramas, documents, observation points and geological plots, so as to support online geological surveys, realize the co-construction and sharing of geological outcrop data and the efficient management of user geological outcrop information, achieve the effectiveness of online surveys of real-scene 3D digital outcrops and the friendliness of user operation experience, and facilitate practical application and promotion;

[0150] (2) Compared with the time-consuming and labor-intensive traditional on-site geological survey, this embodiment provides an online survey method, which does not require going to the site, and can realize the study of geological outcrops by simply operating on the screen. The operation method is simple and easy to understand, which saves a lot of time and resources and improves the efficiency of geological survey;

[0151] (3) This embodiment can present the true three-dimensional form of the geological outcrop, and the browsing display effect is smooth and clear, so that researchers can observe the geological outcrop from different perspectives to obtain more comprehensive information and feel the real situation of the geological outcrop more intuitively and realistically, which is conducive to more accurate analysis and interpretation;

[0152] (4) This embodiment provides a variety of tools required for geological surveys and has good interactivity, and the data processing is fast and efficient, and the operation is simple, which helps researchers to conduct geological analysis, interpretation and research remotely, while reducing the damage to geological outcrops caused by human on-site surveys;

[0153] (5) This embodiment reduces the interference of human operation through digital analysis, ensuring the reliability and accuracy of geological data; at the same time, geological data can be archived to ensure security and accessibility and prevent data loss or damage;

[0154] (6) This embodiment supports data sharing and collaborative research. Researchers can share their personally collected geological data with other researchers online to promote the common progress of geological research.

[0155] (7) This embodiment fully considers the encapsulation of the Web display system and the background analysis function module, and organically combines the front-end display and analysis function modules. Compared with simply using the map service provided by the GIS server, it is more flexible and more scalable.

[0156] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.< / video> < / video> < / video>

Claims

1. A method for online geological investigation of real-life three-dimensional digital outcrops, characterized in that: It includes the business logic process of geological outcrop data co-construction and sharing, the business logic process of online geological survey after user login, and the business logic process of user geological outcrop data management; The geological outcrop data co-construction and sharing business logic process includes a user registration and login sub-process, a geological outcrop data co-construction sub-process and a geological outcrop data sharing sub-process; The online geological survey business logic process includes a geological outcrop model and related data uploading sub-process, a geological outcrop model search sub-process, a geological outcrop model interaction sub-process, a geological outcrop related data display sub-process and a geological information interaction sub-process; The user geological outcrop data management business logic process includes a contact person management sub-process, a geological outcrop data collection management sub-process and a geological outcrop data contribution management sub-process.

2. The online geological survey method according to claim 1, characterized in that: The user registration and login sub-process includes a user registration phase and a user login phase; The user registration phase includes the following steps: Verify the registration form containing user information through the front-end pre-made form to ensure that the input registration form conforms to the preset format and rules; After successful verification, the user information is securely submitted to the backend via the HTTPS protocol; the backend uses the Django framework to receive the user information and perform server-side verification, wherein the server-side verification includes checking data integrity and application business logic correctness; After the verification is passed, the user information is stored in the relational database PostgreSQL; The user login stage includes the following steps: Comparing whether the account number and password entered by the user match the user data stored in the relational database PostgreSQL; If they match, the identity is confirmed to be legitimate and the login is successful.

3. The online geological survey method according to claim 1, characterized in that: The geological outcrop data co-construction sub-process includes the following steps: When a user uploads a geological outcrop three-dimensional model and related data thereof, the Element UI upload component on the user side is used to verify the type and size of the uploaded file, and after the verification is passed, the server-side upload interface is called to upload the geological outcrop three-dimensional model and related data thereof, so that the geological outcrop three-dimensional model and related data thereof are uploaded to the server folder in pieces and synchronized to the object storage service OSS, and the metadata of the geological outcrop three-dimensional model and related data thereof are stored in the database; And / or, the geological outcrop model and related data uploading sub-process includes the following steps: Use the Element UI upload component on the user side to verify the size of the uploaded file containing the geological outcrop 3D model and its related data; If the size of the uploaded file exceeds a preset threshold, the uploaded file is uploaded to the server folder in pieces using the MD5 hash algorithm and the Blob method; The server sorts and reorganizes the shard data according to the MD5 identifier and the shard index, restores it to the original file and synchronizes it to the object storage service OSS, and stores the metadata of the geological outcrop 3D model and its related data in the database.

4. The online geological survey method according to claim 1, characterized in that: The geological outcrop data sharing sub-process includes the following steps: Use the Cesium engine and asynchronous processing requests to load the geological outcrop 3D model; Performing rotation interaction, translation interaction, scaling interaction and / or measurement interaction on the geological outcrop three-dimensional model through Canvas binding events; Use Vue components and combine with Axios library to initiate a request to call the data display interface to obtain the relevant data of the geological outcrop three-dimensional model, and dynamically render the relevant data on the front-end page in the form of components, and use visualization plug-ins to browse the relevant data clearly and interactively, wherein the relevant data contains pictures, videos and / or panoramic information; Use WebSocket protocol for service encoding to establish a persistent connection between clients and achieve real-time sharing of geological outcrop information; And / or, the geological outcrop model interaction sub-process includes the following steps: The asynchronous loading technology of Cesium 3D engine is used to realize hardware accelerated rendering of geological outcrop 3D model through WebGL protocol. The three-dimensional model of the geological outcrop is rotated, scaled and / or translated using a view control and event processing API, and an interpolation algorithm is used to achieve ground-based measurement of the distance, perimeter and / or area of ​​the three-dimensional model of the geological outcrop.

5. The online geological survey method according to claim 1, characterized in that: The geological outcrop model search sub-process includes the following steps: Initiate an HTTPS request using the Axios library on the front end to encode the query parameters input by the user and send the encoded results to the server, wherein the query parameters include keywords, longitude and latitude, and geological outcrop element labels; After receiving the HTTPS request, the server first decodes the query parameters, then uses the ORM method to filter out the geological outcrop three-dimensional models matching the query parameters from the database, and finally encapsulates the screening results in JSON format and returns them to the front end.

6. The online geological survey method according to claim 1, characterized in that: The geological outcrop related data display sub-process includes the following steps: Through the model unique identifier and data type parameters, the Axios library is used to call the data display interface on the server to initiate a request for displaying geological outcrop related data; The Django framework on the server side receives the geological outcrop related data display request, interacts with the PostgreSQL database through the object relational mapping (ORM), and executes SQL queries to retrieve and obtain the geological outcrop related data; The query results are returned in JSON format and dynamically rendered on the front-end page by the Vue component to achieve real-time display of geological outcrop related data; For the pictures, videos, and panoramic data returned by the file system, use <el-image>Label, <video> Tags and photo-shpere-viewer plugins are displayed;< / video> The plotting and observation point data are loaded into the 3D visualization interface by adding entities.

7. The online geological survey method according to claim 1, characterized in that: The geological information interaction sub-process includes a real-time interaction phase and / or an asynchronous communication phase; The real-time interaction stage includes the following steps: When communication and sharing occurs between users, the WebSocket protocol is used to establish a full-duplex communication channel between the user interface and the server to allow real-time two-way exchange of information between users. When a user submits geological information or shares content, the corresponding user front end encodes the geological information or the shared content and sends the encoding result to the server through the corresponding full-duplex communication channel; The server decodes the encoding result to restore the geological information or the shared content, and broadcasts the geological information or the shared content to all connected user front ends to achieve real-time message reception and interface update; Maintaining the connection of the full-duplex communication channel active through a heartbeat mechanism and performing corresponding processing when the connection is disconnected, so as to ensure the continuity and stability of communication between the user ends; The asynchronous communication stage includes the following steps: The server stores the form data from the user front end and including the user's likes, messages and / or comments on various information resources of the system into the database; When other users access the same resource, relevant likes, messages and / or comments are retrieved from the database and dynamically displayed on the front-end page to achieve asynchronous interaction of information.

8. The online geological survey method according to claim 1, characterized in that: The contact management sub-process includes the following steps: Render the friend list and / or discussion group list stored in the Vuex state management library through the Element UI component library, and provide add, delete, edit and / or query functions for the content in the list; When querying a contact, the server searches the friend list and / or discussion group list for a contact field that matches the query keyword, and returns the matching result to the user front end; When modifying a contact, the contact management interface on the server side is called through the Axios library to filter and update the contact information in the friend list and / or discussion group list, and finally the contact information is returned to the user front end for re-rendering.

9. The online geological survey method according to claim 1, characterized in that: The geological outcrop data collection management subprocess includes the following steps: Use the Vuex state management library to save the user's favorite data ID in array form, and use the Element UI component library to render the favorites list; When the favorites list is updated, the favorites field in the favorites list is updated by calling the favorites management interface on the server side using Axios request, thereby realizing dynamic management of geological outcrop data collection.

10. The online geological survey method according to claim 1, characterized in that: The geological outcrop data contribution management subprocess includes the following steps: By utilizing the foreign key constraints in the PostgreSQL database, we can quickly match the contribution records whose uploader ID matches the currently logged-in user ID in each data table, return the contribution records to the user front end, and finally render the contribution list through the Element UI component library.

Images