Exploration drilling parameter data processing system, method and storage medium

Abstract

This invention relates to a system, method, and storage medium for processing exploration drilling parameter data. Traditional exploration drilling parameter processing requires manual classification, is cumbersome, repetitive, and susceptible to human error. This method includes: real-time acquisition of exploration drilling parameter data via sensors; correlation of the data with the acquisition time to obtain raw data, which is then categorized and stored in a raw data file; screening and filtering the raw data to identify drilling process conditions; continued acquisition of valid exploration drilling parameter data via sensors, storing it in a target file; and extraction of optimal drilling parameters based on the categorized parameter sequence list in the target file. This invention achieves categorized storage and processing of exploration drilling parameter data, obtains optimal drilling parameter recommendations, and significantly improves data processing efficiency.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of geological exploration drilling parameter data processing, and particularly relates to an exploration drilling parameter data processing system and method and a storage medium. BACKGROUND

[0002] The XY-1B drilling machine is a vertical shaft drilling machine, which is most widely used in the railway survey and design industry at present because of its simple operation, convenient relocation and low comprehensive use cost, but has the disadvantage of lacking the functions of collecting, processing and displaying drilling parameters, and the parameters cannot be digitized and graphed. Different sensor components are installed on the XY-1B drilling machine to monitor and collect various parameters (such as drilling pressure, vertical shaft speed and drilling displacement) in the drilling process in real time. However, the collected large amount of raw data still needs to be manually classified and processed after being copied out, and the operation process is tedious, the processing process is repeated, and the human factor interference is large. Therefore, it is necessary to provide an exploration drilling parameter data processing method to solve the above problems. SUMMARY

[0003] The present application aims to provide an exploration drilling parameter data processing system and method and a storage medium to at least solve the problems of manual classification and processing, tedious operation process, repeated processing process and large human factor interference in the prior art.

[0004] To achieve the above-mentioned purpose, the technical scheme adopted by the present application is as follows:

[0005] The exploration drilling parameter data processing method comprises the following steps:

[0006] Real-time collection of exploration drilling parameter data by a sensor;

[0007] Association of the exploration drilling parameter data with the collection time to obtain raw data, and classified storage of the raw data in a raw data file;

[0008] Screening and filtering of the raw data to identify the drilling process situation;

[0009] Continued collection of effective exploration drilling parameter data by the sensor, and storage of the data in a target file;

[0010] Optimal drilling parameter extraction according to the classified parameter sequence table in the target file.

[0011] Further, the exploration drilling parameter data comprises drilling pressure P, vertical shaft speed R, instantaneous displacement S, pump pressure F and pump volume Q.

[0012] Further, the association of the exploration drilling parameter data with the collection time T to obtain raw data, and the classified storage of the raw data in a raw data file comprises:

[0013] The original data is composed of time-drilling pressure-vertical shaft speed-instantaneous displacement-pump pressure-pump volume;

[0014] The original data is combined by column and stored in five independent original data files, including time-drilling pressure, time-vertical shaft speed, time-instantaneous displacement, time-pump pressure, and time-pump volume.

[0015] Further, the original data is screened and filtered to identify the drilling process conditions, including:

[0016] Threshold ranges of various exploration drilling parameter data are set to screen the original data, and the original data that is not within the threshold range is identified;

[0017] The original data is not stored when the drilling pressure is less than the lower limit of the threshold range and the rest is within the threshold range, and the original data is not stored when the vertical shaft speed is 0 and the rest is within the threshold range;

[0018] When the pump pressure is greater than the upper limit of the threshold range, it is determined that the drilling is abnormal; when the vertical shaft speed is 0 and the instantaneous displacement is 0, it is determined that the drilling is abnormal; when the pump pressure is greater than the upper limit of the threshold range and the pump volume is less than the lower limit of the threshold range, it is determined that the drilling is abnormal; and an alarm is given for the drilling abnormality.

[0019] Further, according to the classified parameter sequence table in the target file, the optimal drilling parameter extraction is performed, including:

[0020] The time-instantaneous displacement sequence table is obtained;

[0021] According to the time-instantaneous displacement sequence table, the time-cumulative depth sequence table is calculated;

[0022] The number of cycles N and the segmented time interval ΔT are set, the drilling rate V on the time-cumulative depth curve within the ΔT interval is calculated, i.e. the slope value, and the N times of calculation results are sorted to obtain the {V N} sequence;

[0023] According to the obtained {V 1、 V 2、 V3…V N} sequence, the drilling pressure, vertical shaft speed, pump pressure, and pump volume corresponding to each drilling rate are extracted, so as to obtain the drilling parameter recommended value under different drilling rate conditions.

[0024] Further, the drilling parameter recommended value under different drilling rate conditions is obtained, including:

[0025] The drilling pressure, vertical shaft speed, pump pressure, and pump volume corresponding to different drilling rates are combined to obtain the data combination {V1、 P 1、 R 1、 F 1、 Q1}、{V 2、 P 2、 R 2、 F 2、 Q2}…{V N、 P N、 R N、 F N、 Q N};

[0026] Select the data combination with relatively large drilling rate, that is, obtain the optimal drilling parameter recommendation value.

[0027] In another aspect, a prospecting drilling parameter data system is provided, which is used to complete the method, and the system comprises:

[0028] A collection module is configured to collect prospecting drilling parameter data in real time through a sensor;

[0029] A classified storage module is configured to associate the prospecting drilling parameter data with the collection time, obtain original data, and store the original data in an original data file in a classified manner;

[0030] A judgment module is configured to screen and filter the original data and identify the drilling process situation;

[0031] A storage module is configured to continue to collect effective prospecting drilling parameter data through the sensor and store the data in a target file;

[0032] A parameter extraction module is configured to extract optimal drilling parameters according to the classified parameter sequence table in the target file.

[0033] In another aspect, a prospecting drilling parameter data system storage medium is provided, which comprises a stored program, and the program is executed by a processor to realize the method.

[0034] Compared with the prior art, the present application has the following beneficial effects:

[0035] The method of the present application realizes classified storage and processing of prospecting drilling parameter data, can obtain optimal drilling parameter recommendation values, greatly improves the data processing efficiency, can perform drilling process abnormality alarm and prompt, further guides the on-site operation of the drilling rig operator, avoids the interference of human factors, and is beneficial to early discovery of in-hole accidents. BRIEF DESCRIPTION OF DRAWINGS

[0036] In order to more clearly illustrate the technical solutions of the embodiments of the present application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or prior art description. Obviously, the drawings in the following description only show some of the embodiments of the present application, and for those skilled in the art, other drawings can also be obtained from these drawings without creative labor.

[0037] Figure 1 is a flow chart of the method of embodiment 1 of the present application.

[0038] Figure 2 is a system structure diagram of embodiment 3 of the present application.

[0039] Figure 3 is a schematic diagram of the original data in embodiment 2 of the present application.

[0040] Figure 4 is a time-cumulative displacement curve diagram in embodiment 2 of the present application. DETAILED DESCRIPTION

[0041] In order to facilitate the understanding of the present application, the following will be a more comprehensive description of the present application with reference to the relevant drawings. The drawings show the preferred embodiments of the present application. However, the present application can be realized in many different forms and is not limited to the embodiments described herein. On the contrary, the purpose of providing these embodiments is to make the disclosure of the present application more thorough and comprehensive.

[0042] It should be noted that the terms "comprise" and the like and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device that includes a series of steps or units does not have to be limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to these processes, methods, products or devices.

[0043] In addition, the steps "S1", "S2" and the like involved in the embodiments are only for the convenience of the description of the technical solutions and the understanding of the specific steps and contents of the embodiments, and should not be understood as a limitation on the order of the steps. Any change in the order of the steps should be within the protection scope of the present application.

[0044] Embodiment 1:

[0045] This embodiment relates to a survey drilling parameter data processing method, the steps can be executed in a computer system such as a set of computer executable instructions, and although the logical order is shown in the flow chart, in some cases, the order can be different from here.

[0046] As Figure 1The method can realize classified storage, classified processing and acquisition of optimal drilling parameter suggestion value of drilling parameter data, and comprises the following steps of:

[0047] S1: Real-time acquisition of exploration drilling parameter data through a sensor.

[0048] The exploration drilling parameter data comprises drilling pressure P, vertical shaft rotating speed R, instantaneous displacement S, pump pressure F and pump volume Q.

[0049] The drilling pressure data is the drilling pressure data of a feeding cylinder and is acquired through a pressure sensor. The pressure sensor is connected to the oil inlet pipeline of the feeding cylinder of the drilling machine through a tee joint, and the other end is connected to the original instrument end of the drilling machine.

[0050] The vertical shaft rotating speed data is the rotating speed data of the vertical shaft of the drilling machine and is acquired through a rotating speed sensor. The rotating speed sensor is installed on the outside of the object gear of the vertical shaft of the drilling machine through a mounting bracket and a fastening nut, and an inductive magnetic sheet is arranged on the vertical shaft of the drilling machine.

[0051] The instantaneous displacement data is the displacement data of the up-and-down travel of the vertical shaft of the drilling machine and is acquired through a displacement sensor. One end of the displacement sensor is connected to a connecting plate through a flexible pull rope, and the connecting plate is fixed on the hydraulic movable shaft of the drilling machine; the other end of the displacement sensor is fixed on the cover of the power head of the drilling machine through a bracket.

[0052] The pump pressure data is the liquid pressure data of the pump-out pipeline of the mud pump and is acquired through a pressure sensor. The pressure sensor is connected to the pump-out pipeline of the mud pump through a tee joint.

[0053] The pump volume data is the liquid flow data of the pump-out pipeline of the mud pump and is acquired through a flowmeter installed on the pump-out pipeline of the mud pump.

[0054] S2: Association of the exploration drilling parameter data with the acquisition time T to obtain original data and classified storage of the original data in an original data file, comprising the following steps of:

[0055] The original data comprises time-drilling pressure-vertical shaft rotating speed-instantaneous displacement-pump pressure-pump volume;

[0056] The original data is combined according to columns and is classified and stored as five independent original data files, including time-drilling pressure, time-vertical shaft rotating speed, time-instantaneous displacement, time-pump pressure and time-pump volume.

[0057] S3: Screening and filtering of the original data to identify the drilling process, comprising the following steps of:

[0058] Setting threshold ranges of various exploration drilling parameter data to screen the original data and identify the original data not within the threshold ranges.

[0059] After the identification, the following operations are performed:

[0060] (1) When drilling pressure is less than the lower limit of the threshold range and the rest is within the threshold range, the original data is not stored; when the vertical shaft rotation speed is 0 and the rest is within the threshold range, the original data is not stored.

[0061] (2) When pump pressure is greater than the upper limit of the threshold range, it is determined that drilling is abnormal; when the vertical shaft rotation speed is 0 and the instantaneous displacement is 0, it is determined that drilling is abnormal; when the pump pressure is greater than the upper limit of the threshold range and the pump volume is less than the lower limit of the threshold range, it is determined that drilling is abnormal; and an alarm is given for drilling abnormality.

[0062] S4: Continue to collect effective exploration drilling parameter data through the sensor and store it in the target file;

[0063] S5: Extract the optimal drilling parameters according to the classified parameter sequence table in the target file, including:

[0064] S501: Obtain the time-instantaneous displacement sequence table;

[0065] S502: Calculate the time-cumulative depth sequence table according to the time-instantaneous displacement sequence table;

[0066] S503: Set the number of cycles N and the segmented time interval ΔT, calculate the drilling rate V on the time-cumulative depth curve within the ΔT interval, that is, the curve slope value, and sort the N calculation results to obtain the {V1, V2, V3…V N} sequence;

[0067] S504: Extract the drilling pressure, vertical shaft rotation speed, pump pressure, and pump volume corresponding to each drilling rate according to the obtained {V 1、 V 2、 V3…V N} sequence to obtain drilling parameter suggestion values under different drilling rate conditions, including:

[0068] S50401: Combine the drilling pressure, vertical shaft rotation speed, pump pressure, and pump volume corresponding to different drilling rates to obtain data combinations {V 1、 P 1、 R 1、 F 1、 Q1}、{V 2、 P 2、 R 2、 F 2、 Q2}…{V N、 P N、 R N、 F N、 Q N};

[0069] S50402: Select the data combination with relatively large drilling rate, that is, obtain the optimal drilling parameter suggestion value.

[0070] Example 2:

[0071] The method described in Example 1 is further described below through specific operation examples:

[0072] (1) Install pressure sensors, rotational speed sensors, displacement sensors, and flow meters and other equipment on each part of the XY-IB drilling rig, and open the drilling, debug, and run, real-time collection and acquisition of raw data files, such as Figure 3 , the obtained raw data is composed of: time-drilling pressure-stand shaft rotational speed-instantaneous displacement-pump pressure-pump volume.

[0073] (2) The raw data is classified and stored as five independent files according to the time sequence: time-drilling pressure, time-stand shaft rotational speed, time-instantaneous displacement, time-pump pressure, and time-pump volume, and the files are backed up.

[0074] (3) Set threshold ranges:

[0075] 1MPA≤drilling pressure (P)≤6MPA;

[0076] stand shaft rotational speed (R)≠0;

[0077] instantaneous displacement <30cm / min;

[0078] 0.2MPA≤pump pressure≤2.0MPA;

[0079] pump volume≥0.014L / S.

[0080] Data filtering: ① When the drilling pressure is <1MPA and other parameters are normal, the data is not stored; ② When the stand shaft rotational speed is 0 and other parameters are normal, the data is not stored;

[0081] Warning prompts: ① When the pump pressure is >6MPA, the system warns that the drilling is abnormal; ② When the stand shaft rotational speed is 0 and the instantaneous displacement is 0, the system determines that the drill is stuck and prompts that the drilling is abnormal; ③ When the pump pressure is >2.0MPA and the pump volume is <0.014L / S, the system determines that the pump is blocked and there is a possibility of burying the drill. After the system warning prompt is issued, manual intervention is performed to stop drilling or adjust the drilling parameters to avoid accidents in the hole. Sudden reduction of instantaneous displacement data, slowing down of stand shaft rotational speed data, and sudden increase of pump pressure data are all considered abnormal.

[0082] (4) According to the time-instantaneous displacement sequence table, the time integral of the discrete instantaneous displacement is obtained to obtain a time-cumulative displacement sequence table, and a time-cumulative displacement curve is generated, such as Figure 4 .

[0083] (5) The core is classified according to the formation lithology, and the optimal parameters are extracted:

[0084] Taking the silt clay layer (0-12.20m) as an example, the optimal drilling parameters are found out, that is, the values of each parameter corresponding to the maximum drilling rate. In the time period of 0-110min, the cycle number is set to 5 times, the segmented time is 20min, the curve slope is obtained every 20min according to the time-cumulative displacement curve, that is, the drilling rate is obtained, and then the calculation results of 5 times are sorted to obtain the sequence {3.48m / h, 4.53m / h, 5.60m / h, 5.63m / h, 5.69m / h};

[0085] Correspondingly, according to the time sequence table of other parameters, the time (T)-drilling pressure (P), time (T)-vertical shaft speed (R), time (T)-pump pressure (F), time (T)-pump volume (Q) collection results at the corresponding time (every 20min) are extracted. Respectively, the drilling pressure is {1.5Mpa, 1.8Mpa, 1.8Mpa, 2.0Mpa, 2.0Mpa}; the vertical shaft speed is {61r / min, 163r / min, 338r / min, 338r / min, 338r / min}; the pump pressure is {0.3Mpa, 0.3Mpa, 0.5Mpa, 0.6Mpa, 0.6Mpa}; and the pump volume is {0.016L / s, 0.016L / s, 0.019L / s, 0.020L / s, 0.020L / s}.

[0086] Based on the sorting results of the above parameters, the largest result is selected, and thus the combination of the optimal drilling parameters of the silt clay layer, that is, the drilling pressure (P), the vertical shaft speed (R), the pump pressure (F) and the pump volume (Q) is {2.0Mpa, 338r / min, 0.6Mpa, 0.020L / s}.

[0087] Similarly, the optimal drilling parameters of the gravel soil, the strongly weathered granite and the weakly weathered granite are extracted according to the above process.

[0088] Example 3:

[0089] This embodiment relates to a prospecting drilling parameter data system, which can be realized in hardware or software and is used to complete the prospecting drilling parameter data processing method. As shown in Figure 2 The system comprises:

[0090] The acquisition module is used to acquire the prospecting drilling parameter data in real time through the sensor, corresponding to step S1 in example 1;

[0091] The classified storage module is used to associate the prospecting drilling parameter data with the acquisition time, obtain the original data, and store the original data in the original data file in a classified manner, corresponding to step S2 in example 1;

[0092] A judging module is configured to screen and filter the original data, and identify the drilling process situation, which corresponds to step S3 in Embodiment 1.

[0093] A storing module is configured to continue collecting the valid exploration drilling parameter data through the sensor, and store the data in the target file, which corresponds to step S4 in Embodiment 1.

[0094] A parameter extracting module is configured to extract the optimal drilling parameter according to the classified parameter sequence list in the target file, which corresponds to step S5 in Embodiment 1.

[0095] In Embodiment 4, the storage medium can be located in any one of the computer terminals in the computer terminal group in the computer network, or in any one of the mobile terminals in the mobile terminal group.

[0096] Optionally, in the embodiment, the storage medium is configured to store program codes for performing the following steps: collecting the exploration drilling parameter data in real time through the sensor; associating the exploration drilling parameter data with the collection time to obtain the original data, and storing the original data in the original data file in a classified manner; screening and filtering the original data, and identifying the drilling process situation; continuing to collect the valid exploration drilling parameter data through the sensor, and storing the data in the target file; and extracting the optimal drilling parameter according to the classified parameter sequence list in the target file.

[0097] Those skilled in the art can understand that all or part of the functions of the embodiments of the present application can be realized by hardware or by a computer program. When all or part of the functions in the above embodiments are realized by a computer program, the program can be stored in a computer readable storage medium, which can include a read-only memory, a random access memory, a magnetic disk, an optical disk, a hard disk, etc. The above functions are realized by executing the program by a computer. For example, the program is stored in the memory of the device, and when the program in the memory is executed by the processor, the above functions are realized. In addition, when all or part of the functions in the above embodiments are realized by a computer program, the program can also be stored in a server, another computer, a disk, an optical disk, a flash disk or a mobile hard disk, etc. The program is downloaded or copied into the memory of the local device, or the system of the local device is updated, and when the program in the memory is executed by the processor, the above functions are realized.

[0098] The above application of specific examples is used to help understand the present application, and does not limit the present application. Those skilled in the art can make some simple deductions, deformations or substitutions according to the idea of the present application.

Claims

1. A method for processing exploration drilling parameter data, characterized in that: the method comprises the following steps: collecting exploration drilling parameter data in real time through a sensor, wherein the exploration drilling parameter data comprises drilling pressure P, vertical shaft rotating speed R, instantaneous displacement S, pump pressure F, and pump volume Q; associating the exploration drilling parameter data with collection time to obtain raw data and store the raw data in a raw data file in a classified manner; screening and filtering the raw data to identify drilling process conditions; continuing to collect valid exploration drilling parameter data through the sensor and storing the data in a target file; extracting optimal drilling parameters according to a classified parameter sequence list in the target file; wherein: the extraction of the optimal drilling parameters according to the classified parameter sequence list in the target file comprises: obtaining a time-instantaneous displacement sequence list; calculating a time-cumulative depth sequence list according to the time-instantaneous displacement sequence list; obtaining drilling parameter recommended values under different drilling rates, comprising: selecting a data combination with a relatively large drilling rate to obtain optimal drilling parameter recommended values.

2. The method according to claim 1, characterized in that: the association of the exploration drilling parameter data with the collection time T to obtain the raw data and store the raw data in the raw data file in a classified manner comprises: the raw data is composed of time-drilling pressure-vertical shaft rotating speed-instantaneous displacement-pump pressure-pump volume; the raw data is combined in columns and stored in five independent raw data files, including time-drilling pressure, time-vertical shaft rotating speed, time-instantaneous displacement, time-pump pressure, and time-pump volume.

3. The method according to claim 2, characterized in that: the screening and filtering of the raw data to identify the drilling process conditions comprises: setting threshold ranges of various exploration drilling parameter data to screen the raw data and identify the raw data that is not within the threshold ranges; the raw data is not stored when the drilling pressure is less than the lower limit of the threshold range and the remaining parameters are within the threshold range, or the vertical shaft rotating speed is 0 and the remaining parameters are within the threshold range; the drilling is determined to be abnormal when the pump pressure is greater than the upper limit of the threshold range, the vertical shaft rotating speed is 0 and the instantaneous displacement is 0, or the pump pressure is greater than the upper limit of the threshold range and the pump volume is less than the lower limit of the threshold range; and an alarm is given for the drilling abnormality.

4. A system for processing exploration drilling parameter data, characterized in that: the system is used to complete the method according to claim 1, and the system comprises: a collection module for collecting exploration drilling parameter data in real time through a sensor, wherein the exploration drilling parameter data comprises drilling pressure P, vertical shaft rotating speed R, instantaneous displacement S, pump pressure F, and pump volume Q; a classified storage module for associating the exploration drilling parameter data with collection time to obtain raw data and store the raw data in a raw data file in a classified manner; a judgment module for screening and filtering the raw data to identify drilling process conditions; a storage module for continuing to collect valid exploration drilling parameter data through the sensor and storing the data in a target file; a parameter extraction module for extracting optimal drilling parameters according to a classified parameter sequence list in the target file; wherein: ​ ​ ​ ​ ​ ​ ​ Setting the cycle number N and the segmented time interval ΔT, the drilling rate V in the time interval ΔT on the time-cumulative depth curve is calculated, i.e. the slope value of the curve, and the N calculation results are sorted to obtain a {V1, V2, V3…V N} sequence; According to the obtained {V 1、 V 2、 V3…V N} sequence, drilling pressure, vertical shaft rotating speed, pump pressure and pump volume corresponding to each drilling speed are extracted, so as to obtain drilling parameter recommended values under different drilling speed conditions. ​ The drilling pressure, the vertical shaft rotating speed, the pump pressure and the pump volume corresponding to different drilling rates are combined to obtain a data combination {V 1、 P 1、 R 1、 F 1、 Q1}、{V 2、 P 2、 R 2、 F 2、 Q2}…{V N、 P N、 R N、 F N、 Q N} ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ According to the parameter sequence table classified in the target file, optimal drilling parameter extraction is performed, including: obtaining a time-instantaneous displacement sequence table; according to the time-instantaneous displacement sequence table, a time-cumulative depth sequence table is calculated; Setting the cycle number N and the segmented time AT, calculating the drilling rate V in the AT interval time period on the time-accumulative depth curve, i.e. the curve slope value, and sorting the N times of calculation results to obtain {V1, V2, V3…V N} sequence; According to the obtained {V 1、 V 2、 V3…V N} sequence, drilling pressure, vertical shaft rotating speed, pump pressure and pump volume corresponding to each drilling speed are extracted, so as to obtain drilling parameter recommended values under different drilling speed conditions. obtaining drilling parameter recommended values under different drilling rates, including: The drilling pressure, the vertical shaft rotating speed, the pump pressure and the pump volume corresponding to different drilling rates are combined to obtain a data combination 1、 P 1、 R 1、 F 1、 Q1}、{V 2、 P 2、 R 2、 F 2、 Q2}…{V N、 P N、 R N、 F N、 Q N}; selecting a data combination with a relatively large drilling rate, i.e. obtaining optimal drilling parameter recommended values. 5.A computer readable storage medium, characterized in that: the storage medium comprises a stored program, and the program is executed by a processor to implement the method of claim 1.

Images