A method for rarefying map borehole stratigraphic data based on WeChat applet

The WeChat mini-program can quickly display drilling stratum data on the map, solving the time-consuming and labor-intensive data viewing and real-time issues in geotechnical engineering surveys, and achieving efficient, accurate display and convenient application of data.

CN117171257BActive Publication Date: 2025-09-23WUHAN SURVEYING GEOTECHN RES INST OF MCC
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202311140307.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-09-06
Publication Date
2025-09-23
Estimated Expiration
2043-09-06

AI Technical Summary

Technical Problem

In geotechnical engineering surveys, on-site application and review of drilled stratum data is time-consuming and laborious. It is impossible to view current location data in real time, and paper reports are thick and inconvenient to carry, resulting in inefficient data application.

Method used

Through the WeChat mini-program, user location and map information are obtained, drilling stratum data is identified, thinning is performed, and the data is quickly displayed on the map, achieving efficient and accurate data display.

Benefits of technology

It achieves fast, efficient and accurate display of drilling formation data, improves the convenience of data viewing and application, and solves the problems of slow data loading and real-time viewing.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117171257B_ABST
    Figure CN117171257B_ABST
Patent Text Reader

Abstract

The present application relates to a method for thinning out map borehole stratigraphic data based on a WeChat applet, comprising the following specific steps: S1, obtaining the user's current location information, current map zoom ratio, and mobile phone screen size information through the WeChat applet for identification and parsing to obtain the current visual map container information; S2, identifying and parsing the input borehole stratigraphic data; S3, thinning out the data parsed in S2 based on the visual map container in S1, and displaying the thinned out data on a map. The present invention enables fast, efficient, and accurate display of borehole stratigraphic data in the case of numerous drilling points, making map display smoother and loading faster, allowing users to view and apply borehole stratigraphic data more quickly and conveniently.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of geotechnical engineering investigation, specifically, a method for thinning out map drilling stratum data based on a WeChat applet. Background Art

[0002] The vast amount of borehole stratigraphic data obtained during geotechnical engineering surveys, including the physical properties and structural characteristics of underground rocks and soils, soil stability analysis, foundation bearing capacity calculations, and groundwater level analysis, plays a vital role in construction projects. Currently, on-site application and review of survey results still relies on thick paper reports, which have the following drawbacks: First, for large-scale survey projects with thousands of exploration points, manually searching for specific borehole stratigraphic data is time-consuming and laborious; second, it is impossible to view the current location's borehole stratigraphic data in real time wherever one is; and third, paper reports are heavy and difficult to carry and distribute. These are all issues that cannot be addressed with current paper reports. Summary of the Invention

[0003] The purpose of the embodiment of the present application is to provide a method for thinning out map borehole stratum data based on the WeChat applet, which can quickly, efficiently and accurately display the borehole stratum data when there are many drilling points, making the map display smoother and loading faster, allowing users to view and apply the borehole stratum data more quickly and conveniently.

[0004] To achieve the above objectives, this application provides the following technical solutions:

[0005] The present application provides a method for thinning out map borehole stratum data based on a WeChat applet, comprising the following specific steps:

[0006] S1. Obtain the user's current location information, current map zoom ratio, and mobile phone screen size information through the WeChat applet for identification and analysis to obtain the current visible map container information;

[0007] S2, identifying and analyzing the input drilling formation data;

[0008] S3: Based on the visual map container of S1, the data parsed by S2 is thinned out, and the thinned out data is displayed on the map.

[0009] The step S1 specifically includes the following steps:

[0010] S11. The center point of the WeChat mini-program map moves to the user's current location and obtains the user's current location information, the current zoom scale of the map, and the phone screen size information;

[0011] S12. Calculate current visual range information based on the information obtained in S11.

[0012] In step S12, the current visual range information is calculated based on the information obtained in step S11, specifically:

[0013] Get the actual scale corresponding to the current zoom scale according to the WeChat applet map zoom scale correspondence table;

[0014] Get the shortest side of the current screen and obtain the actual length of the shortest side based on the scale relationship;

[0015] Take half of the actual length of the shortest side and combine it with the user's current location information to calculate the longitude and latitude of the four sides of the current user's location.

[0016] The step S2 specifically includes the following steps:

[0017] S21. Filtering out the drilled formation data that does not have longitude and latitude information and cannot be used on a map based on the input drilled formation data;

[0018] S22. Based on the map visible range in S12 and the borehole formation data available on the map in S21, a loop is used to determine whether the longitude and latitude of each nearby borehole formation data is within the visible range, and the borehole formation data meeting the conditions is calculated.

[0019] The step S3 specifically includes the following steps:

[0020] S31, determining whether the drilled formation data in S22 needs to be thinned out;

[0021] S32, calculating the drilling formation data in S22 to obtain a batch of data closest to the user's current location information;

[0022] S33, performing stratigraphic extraction on the drilled stratigraphic data in S22 to obtain stratigraphic information of the current area;

[0023] S34, performing thinning processing on the remaining borehole formation data in S32 based on the current regional formation information to obtain thinned borehole formation data;

[0024] S35, merging the batch of data closest to the user in S32 and the drilled stratum data after thinning in S34 to obtain the data to be finally displayed on the map;

[0025] S36, plotting and displaying the data finally obtained in S35 on the WeChat applet;

[0026] S37. Repeat all the above steps when the user location information changes.

[0027] Compared with the prior art, the present invention has the following beneficial effects:

[0028] This application can quickly, efficiently and accurately display drilling formation data when there are many drilling points, making the map display smoother and loading faster, allowing users to view and apply drilling formation data more quickly and conveniently. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following is a brief introduction to the drawings required for use in the embodiments of the present application. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other relevant drawings can be obtained based on these drawings without creative work.

[0030] Figure 1 This is a flow chart of a method according to an embodiment of the present invention;

[0031] Figure 2 This is the effect diagram of the implementation of this law. DETAILED DESCRIPTION

[0032] The technical solutions in the embodiments of the present application will be described below in conjunction with the accompanying drawings. It should be noted that similar reference numerals and letters represent similar items in the following drawings. Therefore, once an item is defined in one drawing, it does not need to be further defined or explained in subsequent drawings.

[0033] The terms "comprises," "comprising," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or apparatus that includes a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article, or apparatus. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not preclude the presence of additional identical elements in the process, method, article, or apparatus that includes the element.

[0034] The terms "first," "second," etc. are only used to distinguish one entity or operation from another entity or operation, and are not to be understood as indicating or implying relative importance, nor are they to be understood as requiring or implying any actual relationship or order between these entities or operations.

[0035] like Figure 1 As shown, the present invention provides a technical solution:

[0036] A method for thinning out map borehole stratum data based on a WeChat applet, comprising the following steps:

[0037] S1. Obtain the user's current location information, current map zoom ratio, and mobile phone screen size information through the WeChat applet for identification and analysis to obtain the current visible map container information;

[0038] S2, identifying and analyzing the input drilling formation data;

[0039] S3: Based on the visual map container of S1, the data parsed by S2 is thinned out, and the thinned out data is displayed on the map.

[0040] As a further solution of the present invention: Step S1 includes the following steps:

[0041] S11. The center point of the WeChat mini-program map moves to the user's current location and obtains the user's current location information centerUserLocationLatLng, the map's current zoom scale information mapScale, and the phone's screen size information screenWidth and screenHeight.

[0042] S12. Calculate the current visual range information visualRange based on the information obtained in S11 (centerUserLocationLatLng, mapScale, screenWidth, screenHeight);

[0043] According to the WeChat applet map zoom ratio correspondence table

[0044] Proportion

[0045]

[0046] Get the actual scale mapScaleLength corresponding to the current zoom scale mapScale;

[0047] Get the minWidth of the shortest side of the current screen screenWidth and screenHeight, and get the actual length minWidthLength of the shortest side according to the scale relationship;

[0048] Take half of the actual length of the shortest side and combine it with the user's current location information centerUserLocationLatLng to calculate the longitude and latitude of the four sides of the current user's location; one degree of longitude and latitude is approximately equal to 111 kilometers.

[0049] distanceInDegrees=minWidthLength / 2 / 111;

[0050] East direction: centerUserLocationLng+distanceInDegrees;

[0051] South direction: centerUserLocationLat-distanceInDegrees;

[0052] West direction: centerUserLocationLng-distanceInDegrees;

[0053] North direction: centerUserLocationLat+distanceInDegrees.

[0054] As a further solution of the present invention: step S2 includes the following steps:

[0055] S21, filtering out the drilling stratum data canUseDrillingStratumData that has no latitude and longitude information and cannot be used on the map according to the input drilling stratum data drillingStratumData;

[0056] S22. Based on the map visual range visualRange in S12 and the drilling stratum data that can be used on the map canUseDrillingStratumData in S21, the drilling stratum data that meets the conditions, drillingStratumDataList, is calculated. Here, a loop is used to determine whether the latitude and longitude of each nearby drilling stratum data is within the visual range visualRange;

[0057] As a further solution of the present invention: step S3 includes the following steps:

[0058] S31, judging whether the drilling stratum data drillingStratumDataList in S22 needs to be thinned out;

[0059] S32, calculating the drilling stratum data drillingStratumDataList in S22 to obtain a batch of data aroundDrillingStratumDataList closest to the user's current location information centerUserLocationLatLng;

[0060] S33, extracting the stratum data drillingStratumDataList in S22 to obtain the current regional stratum information regionalStratumDataList;

[0061] S34, performing thinning processing on the remaining drilling stratum data outOfScopeDrillingStratumDataList in S32 based on the current regional stratum information regionalStratumDataList, to obtain the thinned drilling stratum data thinningOutOfScopeDrillingStratumDataList;

[0062] S35, merging the data closest to the user in aroundDrillingStratumDataList in S32 and the thinned-out drilling stratum data in thinningOutOfScopeDrillingStratumDataList in S34 to obtain the final data to be displayed on the map, finallyDrillingStratumDataList;

[0063] S36, plotting and displaying the data finally obtained in S35 on the WeChat applet;

[0064] S37. Repeat all the above steps when the user location information changes.

[0065] An education bureau plans to construct a six-story middle school, a two-story lecture hall, a five-story elementary school, a five-story administrative office building, a three-story general purpose building, and a two-story elevated corridor. The project covers a total land area of ​​46,677.00 square meters, with a total construction area of ​​72,908.05 square meters, including approximately 46,677.90 square meters of above-ground construction and 26,231.15 square meters of underground construction.

[0066] The school's advanced drilling survey project deployed 1,224 boreholes, with a cumulative footage of over 26,000 meters. Previously, paper results were provided to the construction unit. In order to effectively utilize the survey data, speed up the construction period, and reduce project costs, the survey results were digitized. Due to the large amount of data, dense boreholes, and large stratum spans, problems such as slow data loading, lags, and the inability to view data in real time on site have caused great trouble for regional geological analysis and application. To solve this problem, this patented technology was used. The workflow is as follows:

[0067] 1) Organize project survey data

[0068] Based on the collation and summary of the drilling, stratum, standard stratum and other data of the site, the standard stratum of the site was established, totaling 10 layers, including 6 large layers such as fill, silty clay, silty clay, fine sand, and sandstone, and 4 small layers such as plain fill, slag layer, and marble.

[0069] 2) Digitalization of survey results

[0070] The sorted data is digitized and processed electronically and entered into the system.

[0071] 3) Drilling formation data thinning

[0072] According to the method provided by this patent, a starting borehole is determined as the target borehole for calculation, and it is determined whether the borehole needs to be thinned out. If thinning out is required, a range thinning calculation is performed based on the regional strata. After the borehole calculation is completed, the next borehole is cycled through, and then the next borehole is found and marked. The cycle is repeated to complete the calculation of all borehole strata, and all boreholes are marked and displayed on the WeChat mini-program map.

[0073] 4) View drilling formation data

[0074] After the thinning is completed, in order to verify the rationality and prevent the reappearance of abnormal data, this technology can be used again for a cycle, and it is more intuitive to view it in combination with positioning. The results are as follows Figure 2 shown.

[0075] The above description is merely an embodiment of the present application and is not intended to limit the scope of protection of the present application. For those skilled in the art, various modifications and variations of the present application are possible. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present application shall be included in the scope of protection of the present application.

Claims

1. A method for rarefying map borehole stratum data based on WeChat applet, characterized in that: The specific steps include: S1. Obtain the user's current location information, current map zoom ratio, and mobile phone screen size information through the WeChat applet for identification and analysis to obtain the current visible map container information; S2, identifying and analyzing the input drilling formation data; S3, based on the visual map container of S1, performs thinning processing on the data parsed by S2, and displays the thinned data on the map; The step S1 specifically includes the following steps: S11. The center point of the WeChat mini-program map moves to the user's current location and obtains the user's current location information, the current zoom scale of the map, and the phone screen size information; S12. Calculate the current visual range information based on the information obtained in S11; The step S2 specifically includes the following steps: S21. Filtering out the drilled formation data that does not have longitude and latitude information and cannot be used on a map based on the input drilled formation data; S22, based on the map visible range in S12 and the borehole formation data that can be used on the map in S21, a loop is used to determine whether the longitude and latitude of each nearby borehole formation data is within the visible range, and the borehole formation data that meets the conditions is calculated; The step S3 specifically includes the following steps: S31, determining whether the drilled formation data in S22 needs to be thinned out; S32, calculating the drilling formation data in S22 to obtain a batch of data closest to the user's current location information; S33, performing stratigraphic extraction on the drilled stratigraphic data in S22 to obtain stratigraphic information of the current area; S34, performing thinning processing on the remaining borehole formation data in S32 based on the current regional formation information to obtain thinned borehole formation data; S35, merge the batch of data closest to the user in S32 and the thinned-out borehole formation data in S34 to obtain the data to be displayed on the map; S36, plotting and displaying the data finally obtained in S35 on the WeChat applet; S37. Repeat all the above steps when the user location information changes.

2. A method for extracting map borehole stratum data based on WeChat applet according to claim 1, characterized in that: In step S12, the current visual range information is calculated based on the information obtained in step S11, specifically: Get the actual scale corresponding to the current zoom scale according to the WeChat applet map zoom scale correspondence table; Get the shortest side of the current screen and obtain the actual length of the shortest side based on the scale relationship; Take half of the actual length of the shortest side and combine it with the user's current location information to calculate the longitude and latitude of the four sides of the current user's location.

Citation Information

Patent Citations

  • WeChat applet-based chart data thinning method

    CN109800341A

  • Drilling data thinning method and device, equipment and storage medium

    CN110610544A