Geological data query system and method based on mobile terminal

Abstract

The invention discloses a geological data query system and method based on a mobile terminal, the system comprises the mobile terminal and a server, a display screen is embedded in the mobile terminal, and a login verification module, a map module, a data query module and a data drawing module are arranged in the mobile terminal; the server is provided with a database establishment module, an initial query HTTP interface, a precise query HTTP interface and a GIS overlay analysis module; the method comprises the following steps: 1, establishing a geological database and a user information database; 2, user login and geological data query range statement input; 3, inquiring geological data; and 4, visually displaying the stratigraphic histogram of the to-be-inquired drill hole. The borehole geological database is established through the server, and remote geological data query is realized based on the mobile terminal, so that query efficiency and accuracy are improved, and visual display of the stratigraphic histogram of the to-be-queried borehole and acquisition of related parameter information of the to-be-queried borehole required by a user can be realized.

Description

Technical Field

[0001] The present invention belongs to the technical field of geological data, and particularly relates to a geological data query system based on a mobile terminal. Background Art

[0002] Engineering investigation is the forerunner of engineering construction, and its accuracy and scientificity are directly related to the safety and economy of subsequent projects. In the engineering investigation industry, through drilling, not only can the stratum distribution and stratum physical and mechanical indexes at the drilling point be obtained, but also the distribution law of the internal attribute parameters of the foundation soil can be understood according to the drilling data. These existing geological data are crucial for determining the depth and quantity of exploration boreholes for new construction projects to ensure the rationality of the exploration work and the safety of future engineering construction.

[0003] However, the existing engineering investigation work mode has obvious limitations. The geological data of most investigation enterprises are still stored in paper form. The geological drilling data stored in the traditional paper form are scattered and not convenient for direct in-depth utilization. The query of paper archives takes a lot of time, resulting in low efficiency of querying and updating information. There may also be query omissions and errors, increasing the risk of rework, thus bringing unnecessary economic losses. Secondly, paper archives are easily damaged or lost due to environmental factors and are difficult to store for a long time. In addition, due to the physical limitations of paper archives, it is difficult to achieve fast and accurate data retrieval and not convenient for remote real-time query.

[0004] Therefore, a reasonably designed geological data query system and method based on a mobile terminal are needed. The establishment of a drilling geological database is realized through a server, and remote geological data query is realized based on the mobile terminal, thereby improving the query efficiency and accuracy, and being able to directly display the stratigraphic column diagram of the borehole to be queried and obtain the relevant parameter information of the borehole to be queried required by the user, with convenient operation. Summary of the Invention

[0005] The technical problem to be solved by the present invention is to provide a geological data query system based on a mobile terminal aiming at the deficiencies in the above-mentioned prior art. The method steps are simple and reasonably designed. The establishment of a drilling geological database is realized through a server, and remote geological data query is realized based on the mobile terminal, thereby improving the query efficiency and accuracy, and being able to directly display the stratigraphic column diagram of the borehole to be queried and obtain the relevant parameter information of the borehole to be queried required by the user, with convenient operation.

[0006] To solve the above technical problems, the technical solution adopted by the present invention is as follows: A mobile-based geological data query system, characterized in that: it includes a mobile terminal and a server. A display screen is embedded on the mobile terminal. A login verification module, a map module, a data query module, and a data drawing module are provided in the mobile terminal; wherein, the login verification module is used to confirm whether the login information input by the user conforms to the user information database; the data query module is used for the user to input a query statement, and the data drawing module is used to draw the geological data queried by the query statement to obtain a stratigraphic columnar diagram; the display screen is used to display the stratigraphic columnar diagram;

[0007] A database establishment module, an initial query HTTP interface, an accurate query HTTP interface, and a GIS overlay analysis module are provided on the server; wherein, the database establishment module is used to insert borehole geological data to establish a borehole geological database; the initial query HTTP interface is used for the mobile terminal to send the query statement input by the user to the server through this interface; the accurate query HTTP interface is used for the mobile terminal to send the ID of the borehole to be queried input by the user to the server through this interface; the GIS overlay analysis module is used to perform GIS overlay analysis on the query statement and the borehole geological database to obtain the geological data queried by the query statement and send it to the mobile terminal.

[0008] In the above mobile-based geological data query system, it is characterized in that: the login verification module includes

[0009] The name module is used to input the user's name;

[0010] The unit name module is used for the user to input the name of the unit where they work;

[0011] The mobile phone number verification information is used for the user to input the mobile phone number;

[0012] The password verification module is used for the user to input the login password.

[0013] In the above mobile-based geological data query system, it is characterized in that: the mobile terminal communicates with the server through HTTP.

[0014] A mobile-based geological data query method, characterized in that the method includes the following steps:

[0015] Step 1. Establish a geological database and a user information database:

[0016] Step 101. Input geological data using the server, and establish a borehole geological database using Oracle software through the database establishment module; wherein, the borehole geological database is an Oracle database, and the borehole geological database includes an exploration engineering table, a borehole data table, and a stratigraphic information table;

[0017] The column fields in the exploration engineering table are project ID, project name, project location, construction unit, project personnel, project start and end dates, geomorphic unit, site type, number of boreholes, borehole ID, and borehole WGS84 coordinates; among them, the project ID is the primary key of the exploration engineering table, and the borehole ID is the foreign key of the exploration engineering table;

[0018] The column fields in the borehole data table are project ID, borehole ID, total borehole depth, equivalent shear wave velocity, borehole date, elevation at the hole opening, water level elevation, average cone penetration resistance, and average tip resistance; among them, the borehole ID is the primary key of the borehole data table, and the project ID is the foreign key of the exploration engineering table;

[0019] The column fields in the stratum information table are borehole ID, stratum ID, stratum name, stratum color, stratum thickness, compression coefficient a1-2, collapsibility coefficient, self-weight collapsibility coefficient, standard penetration test data, void ratio, compression modulus Es1-2, internal friction angle, cohesion, saturation, water content, liquid limit, and plastic limit; among them, the stratum ID is the primary key of the borehole data table, and the borehole ID is the foreign key of the stratum information table;

[0020] Step 102: Establish a user information database; among them, the user information database includes name, unit name, mobile phone number, and login password;

[0021] Step Two: User login and input of geological data query range statement:

[0022] Step 201: The user operates the login verification module and inputs the name, unit name, mobile phone number, and login password through the name module, unit name module, mobile phone number verification module, and verification password module; when the name, unit name, mobile phone number, and login password input by the user match the name, unit name, mobile phone number, and login password stored in the user information database, the user's login is completed;

[0023] Step 202: The user operates the map module, imports an electronic map, and obtains the current spatial geographical location coordinates (X, Y) of the user; among them, (X, Y) are the longitude and latitude coordinates in the GCJ02 coordinate system;

[0024] Step 203: The user inputs the search radius R and the current spatial geographical location coordinates (X, Y) through the data query module, and converts the current spatial geographical location (X, Y) coordinates into the current position conversion coordinates (X’, Y’); among them, (X’, Y’) are the longitude and latitude coordinates in the WGS84 coordinate system;

[0025] Step Three: Geological data query:

[0026] Step 301: The mobile device uses HTTP communication to call the preliminary query HTTP interface in the server, and sends the converted coordinates of the current location (X’, Y’) and the search radius R to the server through the preliminary query HTTP interface. The server receives the converted coordinates of the current location (X’, Y’), and the search radius R. Among them, the converted coordinates of the current location (X’, Y’) and the search radius R are recorded as the initial query statement.

[0027] Step 302: The server inputs the initial query statement into the GIS overlay analysis module, and uses Oracle software to perform GIS overlay analysis on the initial query statement and the borehole geological database to obtain the borehole ID data, and sends it to the mobile device.

[0028] Step 303: The mobile device uses HTTP communication to call the precise query HTTP interface in the server, and sends the borehole ID to be queried to the server through the precise query HTTP interface. The server receives the borehole ID to be queried.

[0029] Step 304: The server searches the borehole geological database according to the borehole ID to be queried, obtains the borehole data and formation information of the borehole ID to be queried, and records the borehole data and formation information of the borehole ID to be queried as the geological data of the borehole ID to be queried, and sends it to the mobile device.

[0030] Step Four: Intuitive display of the stratigraphic columnar diagram of the borehole to be queried:

[0031] The mobile device draws according to the formation data in the geological data of the borehole ID to be queried through the data drawing module to obtain the stratigraphic columnar diagram of the borehole to be queried, and visually displays it through the display screen; obtain the relevant parameter information of the borehole to be queried that the user needs according to the geological data of the borehole ID to be queried.

[0032] The above-mentioned geological data query method based on a mobile device is characterized in that: in step 302, the specific process is as follows:

[0033] Step A01: The server uses Oracle software to input the converted coordinates of the current location (X’, Y’) and the search radius R, and accesses the exploration engineering table of the borehole geological database.

[0034] Step A02: The server uses Oracle software to perform GIS overlay analysis on the initial query statement and the exploration engineering table data to obtain the borehole ID data corresponding to the initial query statement.

[0035] Step A03: The server packs the borehole ID data into an HTTP response and sends it to the mobile device through the network.

[0036] Step A04: The mobile device receives the HTTP response and parses it to obtain the borehole ID data.

[0037] The above-mentioned mobile-based geological data query method is characterized in that: Step 304, the specific process is as follows:

[0038] Step B01: The server inputs the borehole ID to be queried using Oracle software and accesses the borehole data table and the formation information table;

[0039] Step B02: The server searches from the borehole data table and the formation information table according to the borehole ID to be queried, obtains the borehole data and formation information of the borehole ID to be queried, and converts the borehole WGS84 coordinates in the borehole data of the borehole ID to be queried into borehole GCJ02 coordinates. Then, the borehole data and formation information of the borehole ID to be queried are recorded as the geological data of the borehole ID to be queried;

[0040] Step B03: The server packs the geological data of the borehole ID to be queried into an HTTP response and sends it to the mobile terminal through the network;

[0041] Step B04: The mobile terminal receives the HTTP response and parses it to obtain the geological data of the borehole ID to be queried.

[0042] The above-mentioned mobile-based geological data query method is characterized in that: Step Four, the specific process is as follows:

[0043] Step A: Initialize the Canvas element, and obtain the width and effective height of the display screen on the mobile terminal as the width W and height H of the Canvas element;

[0044] Step B: Denote the formation IDs in the geological data of the borehole ID to be queried as formation 1,..., formation i,..., formation I in sequence; among them, the formation IDs are marked in the order from top to bottom along the borehole depth direction; i and I are positive integers, and 1 ≤ i ≤ I;

[0045] Step C: Obtain the corrected drawing thickness Layer″(i) of formation i according to the formation thickness of formation i and height H;

[0046] Step D: Set the Canvas context type to 2D context;

[0047] Step E: Obtain the Canvas context, set the abscissa X1 of the upper left corner of formation 1, the ordinate Y1 of the upper left corner of formation 1, the width W1 of rectangle 1, and the height H1 of rectangle 1. Use the fillRect function to draw rectangle 1 corresponding to formation 1, and fill rectangle 1 according to the formation color of formation 1; among them, the height H1 of rectangle 1 takes the value of the corrected drawing thickness Layer″(1) of formation 1, the width W1 of rectangle 1 is 1 / 3 of the width of the Canvas element, and X1 + W1 / 2 = W;

[0048] Step F: Use the measureText function to calculate the width of the formation name, and draw the formation name on Rectangle 1 through the fillText function; wherein, the formation name is centered on Rectangle 1.

[0049] Step G: Repeat Step E and Step F multiple times, and set the abscissa X of the upper left corner of Formation i i , the ordinate Y of the upper left corner of Formation i i , the width W of Rectangle i i , the height H of Rectangle i i , draw Rectangle i corresponding to Formation i, and fill Rectangle i according to the formation color of Formation i; wherein, the height H of Rectangle i i takes the value of the corrected drawing thickness Layer″(i) of Formation i.

[0050] Step H: Repeat Step G multiple times until the drawing of Rectangle I corresponding to Formation I is completed, and obtain the stratigraphic columnar section of the borehole to be queried.

[0051] The above-mentioned geological data query method based on a mobile terminal is characterized in that: Step C, the specific process is as follows:

[0052] Step C01: Denote the formation thickness of Formation i as Layer(i), and obtain the minimum formation thickness Layer(min) from Formation 1 to Formation I; and according to the formula obtain the actual drawing thickness Layer′(i) of Formation i; wherein, D T represents the total depth of the borehole of the borehole ID to be queried; when i is greater than 1, according to obtain the ordinate Y of the upper left corner of Formation i i ; wherein, Y1 represents the ordinate of the upper left corner of Formation 1, k is a positive integer, and 1 ≤ k ≤ i - 1;

[0053] Step C02: According to the formula obtain the total actual drawing thickness Layer′(z) of the formation; according to H′ = H - Y1, obtain the total drawing height H′ of the display screen;

[0054] Step C03: Compare Layer′(z) with H′. If Layer′(z) is greater than H′, then according to the formula α = A × H′ / Layer′(z), obtain the formation drawing thickness correction coefficient α; wherein, A is the total thickness correction coefficient;

[0055] Step C04: According to the formula Layer″(i) = α × Layer′(i), obtain the corrected drawing thickness Layer″(i) of Formation i.

[0056] The present invention has the following advantages compared with the prior art:

[0057] 1. The method steps of the present invention are simple and reasonably designed, solving the drawbacks of the paper-based preservation of drilling geological data and the problem of low utilization efficiency of drilling geological data.

[0058] 2. The login verification module of the present invention binds the user's mobile phone number and login password. Only when both the login password and the mobile phone number match, it ensures that the user himself / herself logs in to the device, excluding the possibility of illegal users logging in to the system and improving the security of querying data.

[0059] 3. The present invention realizes the transmission of the initial query statement through the preliminary query HTTP interface, facilitating the input of the initial query statement into the GIS overlay analysis module for GIS overlay analysis to obtain the drilling ID data; it realizes the transmission of the drilling ID to be queried through the precise query HTTP interface, searches from the drilling geological database according to the drilling ID to be queried, and obtains the drilling data and formation information of the drilling ID to be queried. Through the cooperation of preliminary and precise queries, the query efficiency is improved.

[0060] 4. The query statement that needs to be input in the data query module of the present invention includes the current spatial geographical location coordinates and the query radius value R. Through the limitation of the query radius value R, the query volume of drilling geological data is reduced, and the utilization efficiency of drilling geological data is improved.

[0061] 5. The present invention draws the formation data in the geological data of the drilling ID to be queried through the data drawing module to obtain the formation histogram of the drilling to be queried. The system can accurately draw and visually display the drilling formation situation, enabling users to easily query and understand the geological structure, improving the accessibility and visualization effect of geological data. Furthermore, through the intuitive display method, it helps to better understand the geological situation, thereby making more scientific decisions for subsequent new projects.

[0062] In summary, the method steps of the present invention are simple and reasonably designed. It realizes the establishment of the drilling geological database through the server and remotely queries geological data based on the mobile terminal, thereby improving the query efficiency and accuracy, and can realize the intuitive display of the formation histogram of the drilling to be queried and obtain the relevant parameter information of the drilling to be queried required by the user, with convenient operation.

[0063] The technical solution of the present invention will be further described in detail below through the accompanying drawings and embodiments. Description of the Drawings

[0064] Figure 1 It is the system block diagram of the present invention.

[0065] Figure 2 It is the method flow block diagram of the present invention. Detailed Embodiments

[0066] As Figure 1 shown, the mobile - based geological data query system of the present invention includes a mobile terminal 1 and a server 2. A display screen 4 is embedded in the mobile terminal 1. A login verification module, a map module 15, a data query module 16, and a data drawing module 17 are provided in the mobile terminal 1. Among them, the login verification module is used to confirm whether the login information input by the user conforms to the user information database; the data query module 16 is used for the user to input a query statement, and the data drawing module 17 is used to draw the geological data queried by the query statement to obtain a stratigraphic columnar diagram; the display screen 4 is used to display the stratigraphic columnar diagram;

[0067] A database establishment module 21, a preliminary query HTTP interface 22, an accurate query HTTP interface 23, and a GIS overlay analysis module 24 are provided on the server 2. Among them, the database establishment module 21 is used to insert borehole geological data to establish a borehole geological database; the preliminary query HTTP interface 22 is used for the mobile terminal 1 to send the query statement input by the user to the server 2 through this interface; the accurate query HTTP interface 23 is used for the mobile terminal 1 to send the ID of the borehole to be queried input by the user to the server 2 through this interface; the GIS overlay analysis module 24 is used to perform GIS overlay analysis on the query statement and the borehole geological database to obtain the geological data queried by the query statement and send it to the mobile terminal 1.

[0068] The above - mentioned mobile - based geological data query system is characterized in that: the login verification module includes

[0069] A name module 11 for inputting the user's name;

[0070] An organization name module 12 for the user to input the name of the organization where they work;

[0071] A mobile phone number verification information 13 for the user to input the mobile phone number;

[0072] A password verification module 14 for the user to input the login password.

[0073] The above - mentioned mobile - based geological data query system is characterized in that: the mobile terminal 1 communicates with the server 2 through HTTP.

[0074] As Figure 2 shown, the mobile - based geological data query method of the present invention includes the following steps:

[0075] Step 1: Establish a geological database and a user information database:

[0076] Step 101: Input geological data using Server 2. Use Oracle software through the database establishment module 21 to establish a borehole geological database. Among them, the borehole geological database is an Oracle database, and the borehole geological database includes an exploration project table, a borehole data table, and a stratigraphic information table.

[0077] The column fields in the exploration project table are project ID, project name, project location, construction unit, project personnel, project start and end dates, geomorphic unit, site type, number of boreholes, borehole ID, and borehole WGS84 coordinates. Among them, the project ID is the primary key of the exploration project table, and the borehole ID is the foreign key of the exploration project table.

[0078] The column fields in the borehole data table are project ID, borehole ID, total borehole depth, equivalent shear wave velocity, borehole date, elevation at the hole mouth, water level elevation, average cone penetration resistance, and average tip resistance. Among them, the borehole ID is the primary key of the borehole data table, and the project ID is the foreign key of the exploration project table.

[0079] The column fields in the stratigraphic information table are borehole ID, stratigraphic ID, stratigraphic name, stratigraphic color, stratigraphic thickness, compression coefficient a1-2, collapsibility coefficient, self-weight collapsibility coefficient, standard penetration data, void ratio, compression modulus Es1-2, internal friction angle, cohesion, saturation, moisture content, liquid limit, and plastic limit. Among them, the stratigraphic ID is the primary key of the borehole data table, and the borehole ID is the foreign key of the stratigraphic information table.

[0080] Step 102: Establish a user information database. Among them, the user information database includes name, unit name, mobile phone number, and login password.

[0081] Step 2: User login and input of geological data query range statement:

[0082] Step 201: The user operates the login verification module and inputs the name, unit name, mobile phone number, and login password through the name module 11, unit name module 12, mobile phone number verification module 13, and verification password module 14. When the name, unit name, mobile phone number, and login password input by the user match the name, unit name, mobile phone number, and login password stored in the user information database, the user's login is completed.

[0083] Step 202: The user operates the map module 15, imports an electronic map, and obtains the current spatial geographical location coordinates (X, Y) of the user. Among them, (X, Y) are the longitude and latitude coordinates of the GCJ02 coordinate system.

[0084] Step 203: The user inputs the search radius R and the current spatial geographical location coordinates (X, Y) through the data query module 16, and converts the current spatial geographical location coordinates (X, Y) into the current position conversion coordinates (X', Y'); where the current position conversion coordinates (X', Y') are the longitude and latitude coordinates in the WGS84 coordinate system.

[0085] Step Three: Geological data query:

[0086] Step 301: The mobile terminal 1 uses HTTP communication to call the preliminary query HTTP interface 22 in the server 2, and sends the current position conversion coordinates (X', Y') and the search radius R to the server 2 through the preliminary query HTTP interface 22. The server 2 receives the current position conversion coordinates (X', Y') and the search radius R; where the current position conversion coordinates (X', Y') and the search radius R are recorded as the initial query statement.

[0087] Step 302: The server 2 inputs the initial query statement into the GIS overlay analysis module 24, and uses Oracle software to perform GIS overlay analysis on the initial query statement and the borehole geological database to obtain the borehole ID data, and sends it to the mobile terminal 1.

[0088] Step 303: The mobile terminal 1 uses HTTP communication to call the precise query HTTP interface 23 in the server 2, and sends the borehole ID to be queried to the server 2 through the precise query HTTP interface 23. The server 2 receives the borehole ID to be queried.

[0089] Step 304: The server 2 searches from the borehole geological database according to the borehole ID to be queried, obtains the borehole data and formation information of the borehole ID to be queried, and records the borehole data and formation information of the borehole ID to be queried as the geological data of the borehole ID to be queried, and sends it to the mobile terminal 1.

[0090] Step Four: Intuitive display of the stratigraphic columnar diagram of the borehole to be queried:

[0091] The mobile terminal 1 draws according to the formation data in the geological data of the borehole ID to be queried through the data drawing module 17 to obtain the stratigraphic columnar diagram of the borehole to be queried, and visually displays it through the display screen 4; relevant parameter information of the borehole to be queried that the user needs is obtained according to the geological data of the borehole ID to be queried.

[0092] In this embodiment, for step 302, the specific process is as follows:

[0093] Step A01: The server 2 uses Oracle software to input the current position conversion coordinates (X', Y') and the search radius R, and accesses the exploration engineering table of the borehole geological database.

[0094] Step A02: The server 2 uses Oracle software to perform GIS overlay analysis with the data in the exploration engineering table using the initial query statement, and obtains the borehole ID data corresponding to the initial query statement;

[0095] Step A03: The server 2 packs the borehole ID data into an HTTP response and sends it to the mobile device 1 via the network;

[0096] Step A04: The mobile device 1 receives the HTTP response and parses it to obtain the borehole ID data.

[0097] In this embodiment, step 304 is specifically as follows:

[0098] Step B01: The server 2 uses Oracle software to input the borehole ID to be queried and accesses the borehole data table and the formation information table;

[0099] Step B02: The server 2 searches from the borehole data table and the formation information table according to the borehole ID to be queried, obtains the borehole data and formation information of the borehole ID to be queried, and converts the borehole WGS84 coordinates in the borehole data of the borehole ID to be queried into borehole GCJ02 coordinates, then records the borehole data and formation information of the borehole ID to be queried as the geological data of the borehole ID to be queried;

[0100] Step B03: The server 2 packs the geological data of the borehole ID to be queried into an HTTP response and sends it to the mobile device 1 via the network;

[0101] Step B04: The mobile device 1 receives the HTTP response and parses it to obtain the geological data of the borehole ID to be queried.

[0102] In this embodiment, step four is specifically as follows:

[0103] Step A: Initialize the Canvas element, and obtain the width and effective height of the display screen 4 on the mobile device 1 as the width W and height H of the Canvas element;

[0104] Step B: Denote the formation IDs in the geological data of the borehole ID to be queried as formation 1,..., formation i,..., formation I in sequence; where the formation ID is marked in order from top to bottom along the borehole depth direction; i and I are positive integers, and 1 ≤ i ≤ I;

[0105] Step C: According to the formation thickness of formation i and the height H, obtain the corrected drawing thickness Layer″(i) of formation i;

[0106] Step D: Set the Canvas context type to 2D context;

[0107] Step E: Obtain the Canvas context, set the abscissa X1 of the upper left corner of formation 1, the ordinate Y1 of the upper left corner of formation 1, the width W1 of rectangle 1, and the height H1 of rectangle 1. Use the fillRect function to draw rectangle 1 corresponding to formation 1, and fill rectangle 1 according to the formation color of formation 1. Among them, the height H1 of rectangle 1 takes the value of the corrected drawing thickness Layer″(1) of formation 1, the width W1 of rectangle 1 is 1 / 3 of the width of the Canvas element, and X1 + W1 / 2 = W.

[0108] Step F: Use the measureText function to calculate the width of the formation name, and use the fillText function to draw the formation name on rectangle 1. Among them, the formation name is centered on rectangle 1.

[0109] Step G: Repeat Step E and Step F multiple times, set the abscissa X of the upper left corner of formation i i , the ordinate Y of the upper left corner of formation i i , the width W of rectangle i i , the height H of rectangle i i , draw rectangle i corresponding to formation i, and fill rectangle i according to the formation color of formation i. Among them, the height H of rectangle i i takes the value of the corrected drawing thickness Layer″(i) of formation i;

[0110] Step H: Repeat Step G multiple times until the drawing of rectangle I corresponding to formation I is completed, and obtain the formation histogram of the drill hole to be queried.

[0111] In this embodiment, Step C is specifically as follows:

[0112] Step C01: Denote the formation thickness of formation i as Layer(i), and obtain the minimum formation thickness Layer(min) from formation 1 to formation I; and according to the formula obtain the actual drawing thickness Layer′(i) of formation i; among them, D T represents the total depth of the drill hole of the drill hole ID to be queried; when i is greater than 1, according to obtain the ordinate Y of the upper left corner of formation i i ; among them, Y1 represents the ordinate of the upper left corner of formation 1, k is a positive integer, and 1 ≤ k ≤ i - 1;

[0113] Step C02: According to the formula obtain the total actual drawing thickness Layer′(z) of the formation; according to H′ = H - Y1, obtain the total drawing height H′ of the display screen;

[0114] Step C03: Compare Layer′(z) with H′. If Layer′(z) is greater than H′, then obtain the formation drawing thickness correction factor α according to the formula α = A × H′ / Layer′(z), where A is the total thickness correction factor;

[0115] Step C04: Obtain the corrected drawing thickness Layer″(i) of formation i according to the formula Layer″(i) = α × Layer′(i).

[0116] In this embodiment, the search radius R is taken as 1000m and is adjusted according to requirements during actual use.

[0117] In this embodiment, the effective height described in Step A is equal to the screen height of the display screen 4 minus the height of the top navigation bar and then minus the height of the bottom navigation bar; where the heights of the top navigation bar and the bottom navigation bar are set according to design requirements.

[0118] In this embodiment, during actual use, the upper left corner of the screen of the display screen 4 is taken as the origin, the horizontal axis is along the width, and the vertical axis is along the height.

[0119] In this embodiment, during actual use, the width W1 of rectangle 1 is 1 / 3 of the width of the Canvas element, and X1 + W1 / 2 = W to center the rectangle.

[0120] In this embodiment, during actual use, the ordinate Y1 of the upper left corner of formation 1 is set according to design requirements and can be taken as 20px.

[0121] In this embodiment, during actual use, the value range of the total thickness correction factor A is 0.95 - 0.99.

[0122] In this embodiment, in Step G, rectangle i is filled according to the formation color of formation i, specifically as follows: The selection of the filling color is mainly based on the lithology, composition or other properties of the formation, and is defined using the RGB model, where the color range is from 0 to 255. For example, the color of loess is RGB(255, 255, 0), the color of plain fill is RGB(139, 69, 19), and the color of clay is RGB(128, 0, 128). Through the predefined lithology - color dictionary, the lithology attribute can be associated with the corresponding RGB value, thereby realizing the intuitive visual display of the formation color. The formation color displayed by this method is consistent with the common color of this formation in nature. Compared with the form of texture mapping, this method occupies less memory and has a faster rendering speed.

[0123] In this embodiment, the corrected drawing thickness of formation i is obtained by step C to ensure the visibility and aesthetics of the formation histogram. It is necessary to adjust the size and position of each layer according to the actual display area of the screen, and ensure that the histogram does not exceed the visible range of the screen to avoid scrolling or data clipping. In addition, it can also ensure visibility even when a certain formation is small.

[0124] In summary, the method of the present invention has simple steps and reasonable design. The establishment of the borehole geological database is realized through the server, and the remote geological data query is realized based on the mobile terminal, thereby improving the query efficiency and accuracy, and can realize the intuitive display of the formation histogram of the borehole to be queried and the acquisition of relevant parameter information of the borehole to be queried required by the user, with convenient operation.

[0125] The above are only the preferred embodiments of the present invention, and do not impose any limitations on the present invention. Any simple modifications, changes, and equivalent structural changes made to the above embodiments according to the technical essence of the present invention still fall within the protection scope of the technical solution of the present invention.

Claims

1. A mobile-based geological data query system, characterized in that: The invention comprises a mobile terminal (1) and a server (2), wherein the mobile terminal (1) is embedded with a display screen (4), and the mobile terminal (1) is provided with a login verification module, a map module (15), a data query module (16) and a data drawing module (17); wherein the login verification module is used to confirm whether the login information input by the user is consistent with the user information database; the data query module (16) is used for the user to input a query statement, and the data drawing module (17) is used to draw the geological data queried by the query statement to obtain a stratigraphic column chart; and the display screen (4) is used to display the stratigraphic column chart; The server (2) is provided with a database establishment module (21), an initial query HTTP interface (22), a precise query HTTP interface (23) and a GIS overlay analysis module (24); wherein the database establishment module (21) is used to insert borehole geological data to establish a borehole geological database; the initial query HTTP interface (22) is used for the mobile terminal (1) to send a query statement input by a user to the server (2) through the interface; the precise query HTTP interface (23) is used for the mobile terminal (1) to send a borehole ID to be queried input by a user to the server (2) through the interface; and the GIS overlay analysis module (24) is used to perform GIS overlay analysis on the query statement and the borehole geological database to obtain geological data queried by the query statement and send the geological data to the mobile terminal (1).

2. A mobile terminal-based geological data query system according to claim 1, characterized in that: The login verification module includes The name module (11) is used to input the user's name; The unit name module (12) is used for the user to input the name of the unit where he / she works; Mobile phone number verification information (13) is used for users to enter their mobile phone numbers; The password verification module (14) is used for the user to input a login password.

3. A mobile-based geological data query system according to claim 1 or 2, characterized in that: The mobile terminal (1) communicates with the server (2) via HTTP.

4. A geological data query method based on a mobile terminal, characterized in that: The method comprises the following steps: Step 1: Establish geological database and user information database: Step 101, using a server (2) to input geological data, and using Oracle software to establish a borehole geological database through a database establishment module (21); wherein the borehole geological database is an Oracle database, and the borehole geological database includes a survey engineering table, a borehole data table, and a stratum information table; The fields in the survey engineering table are project ID, project name, project location, construction unit, project personnel, project start and end dates, geomorphic unit, site type, number of boreholes, borehole ID, and borehole WGS84 coordinates; among which, project ID is the primary key of the survey engineering table, and borehole ID is the foreign key of the survey engineering table; The columns in the drilling data table are project ID, borehole ID, total borehole depth, equivalent shear wave velocity, drilling date, hole elevation, water level elevation, average specific penetration resistance, and average cone tip resistance; wherein the borehole ID is the primary key of the drilling data table, and the project ID is the foreign key of the survey project table; The columns of the formation information table are borehole ID, formation ID, formation name, formation color, formation thickness, compression coefficient a1-2, collapsibility coefficient, deadweight collapsibility coefficient, standard penetration data, porosity, compression modulus Es1-2, internal friction angle, cohesion, saturation, water content, liquid limit, and plastic limit; wherein the formation ID is the primary key of the borehole data table, and the borehole ID is the foreign key of the formation information table; Step 102: Establish a user information database; wherein the user information database includes name, company name, mobile phone number and login password; Step 2: User login and geological data query range statement input: Step 201, the user operates the login verification module and inputs the name, unit name, mobile phone number and login password through the name module (11), the unit name module (12), the mobile phone number verification module (13) and the verification password module (14); when the name, unit name, mobile phone number and login password input by the user match the name, unit name, mobile phone number and login password stored in the user information database, the user login is completed; Step 202: The user operates the map module (15), imports the electronic map, and obtains the user's current spatial geographic location coordinates (X, Y); wherein (X, Y) are the longitude and latitude coordinates of the GCJ02 coordinate system; Step 203: The user inputs the search radius R and the current spatial geographic location coordinates (X, Y) through the data query module (16), and converts the current spatial geographic location coordinates (X, Y) into the current location conversion coordinates (X', Y'); wherein (X', Y') are the longitude and latitude coordinates of the WGS84 coordinate system; Step 3: Geological data query: Step 301: The mobile terminal (1) uses HTTP communication to call the preliminary query HTTP interface (22) in the server (2), and sends the current position conversion coordinates (X', Y') and the search radius R to the server (2) through the preliminary query HTTP interface (22). The server (2) receives the current position conversion coordinates (X', Y') and the search radius R; wherein the current position conversion coordinates (X', Y') and the search radius R are recorded as the initial query statement; Step 302: The server (2) inputs the initial query statement into the GIS overlay analysis module (24), uses Oracle software to perform GIS overlay analysis on the initial query statement and the borehole geological database, obtains the borehole ID data, and sends it to the mobile terminal (1); Step 303: the mobile terminal (1) uses HTTP communication to call the precise query HTTP interface (23) in the server (2), and sends the borehole ID to be queried to the server (2) through the precise query HTTP interface (23), and the server (2) receives the borehole ID to be queried; Step 304: the server (2) searches the borehole geological database according to the borehole ID to be queried, obtains the borehole data and stratigraphic information of the borehole ID to be queried, records the borehole data and stratigraphic information of the borehole ID to be queried as the geological data of the borehole ID to be queried, and sends it to the mobile terminal (1); Step 4: Visual display of the stratigraphic column chart of the borehole to be queried: The mobile terminal (1) draws the stratigraphic data in the geological data of the borehole ID to be queried through a data drawing module (17), obtains a stratigraphic column diagram of the borehole to be queried, and intuitively displays it through a display screen (4); and obtains relevant parameter information of the borehole to be queried required by the user based on the geological data of the borehole ID to be queried.

5. A mobile terminal-based geological data query method according to claim 4, characterized in that: Step 302, the specific process is as follows: Step A01, the server (2) uses Oracle software to input the current position conversion coordinates (X', Y') and the search radius R, and accesses the survey engineering table of the borehole geological database; Step A02, the server (2) uses Oracle software to perform GIS overlay analysis on the initial query statement and the survey engineering table data to obtain the borehole ID data corresponding to the initial query statement; Step A03, the server (2) packages the drilling ID data into an HTTP response and sends it to the mobile terminal (1) via the network; Step A04, the mobile terminal (1) receives and parses the HTTP response to obtain the drilling ID data.

6. A mobile terminal-based geological data query method according to claim 4, characterized in that: Step 304, the specific process is as follows: Step B01, the server (2) uses Oracle software to input the borehole ID to be queried, and accesses the borehole data table and the formation information table; Step B02, the server (2) searches the borehole data table and the stratigraphic information table according to the borehole ID to be queried, obtains the borehole data and stratigraphic information of the borehole ID to be queried, and converts the borehole WGS84 coordinates in the borehole data of the borehole ID to be queried into the borehole GCJ02 coordinates, and then records the borehole data and stratigraphic information of the borehole ID to be queried as the geological data of the borehole ID to be queried; Step B03, the server (2) packages the geological data of the borehole ID to be queried into an HTTP response and sends it to the mobile terminal (1) through the network; Step B04, the mobile terminal (1) receives and parses the HTTP response to obtain the geological data of the borehole ID to be queried.

7. A mobile terminal-based geological data query method according to claim 4, characterized in that: Step 4: The specific process is as follows: Step A, initializing the Canvas element, and obtaining the width and effective height of the display screen (4) on the mobile terminal (1) as the width W and height H of the Canvas element; Step B, recording the stratum IDs in the geological data of the borehole ID to be queried as stratum 1, ..., stratum i, ..., stratum I in sequence; wherein the stratum IDs are marked in order from top to bottom along the depth direction of the borehole; i and I are positive integers, and 1≤i≤I; Step C, obtaining a corrected drawn thickness Layer″(i) of the stratum i according to the stratum thickness and height H of the stratum i; Step D, set the Canvas context type to 2D context; Step E, get the Canvas context, set the upper left corner horizontal coordinate X1 of layer 1, the upper left corner vertical coordinate Y1 of layer 1, the width W1 of rectangle 1, the height H1 of rectangle 1, use the fillRect function to draw rectangle 1 corresponding to layer 1, and fill rectangle 1 according to the layer color of layer 1; wherein the height H1 of rectangle 1 is taken as the corrected drawing thickness Layer″(1) of layer 1; Step F, using the measureText function to calculate the width of the stratum name, and using the fillText function to draw the stratum name on rectangle 1; wherein the stratum name is centered on rectangle 1; Step G: Repeat steps E and F for multiple times to set the horizontal coordinate X of the upper left corner of the layer i. i , the ordinate Y of the upper left corner of layer i i , the width W of rectangle i i , the height H of rectangle i i , draw rectangle i corresponding to stratum i, and fill rectangle i according to the stratum color of stratum i; where the height H of rectangle i i The value is the modified drawing thickness of layer i, Layer″(i), W i =W1, and X i =X1; Step H, repeat step G multiple times until the drawing of rectangle I corresponding to stratum I is completed, and the stratigraphic column diagram of the borehole to be queried is obtained.

8. A mobile terminal-based geological data query method according to claim 7, characterized in that: Step C, the specific process is as follows: Step C01, record the thickness of layer i as Layer(i), obtain the minimum layer thickness Layer(min) from layers 1 to I; and calculate the minimum layer thickness according to the formula Get the actual drawn thickness of layer i, Layer′(i); where D T Indicates the total depth of the drilling hole ID to be queried; when i is greater than 1, according to Get the upper left corner ordinate Y of layer i i ; Wherein, Y1 represents the upper left corner ordinate of layer 1, k is a positive integer, and 1≤k≤i-1; Step C02: According to the formula The total actual drawing thickness of the stratum Layer′(z) is obtained; according to H′=H-Y1, the total drawing height of the display screen H′ is obtained; Step C03, compare Layer′(z) and H′. If Layer′(z) is greater than H′, then according to the formula α=A×H′ / Layer′(z), obtain the formation mapping thickness correction coefficient α; wherein A is the total thickness correction coefficient; Step C04: Obtain the corrected drawing thickness Layer″(i) of layer i according to the formula Layer″(i)=α×Layer′(i).

Images